Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
02.06.23 Council Packet
CITY OF Meeting Location: F/� ��'����� Farmington City Hall A 430 Third Street Farmington, MN 55024 CITY COUNCIL REGULAR MEETING AGENDA February 6, 2023 7:00 P.M. Action Taken 1. CALL TO ORDER 7:00 P.M. 2. PLEDGE OF ALLEGIANCE 3. ROLL CALL 4. APPROVE AGENDA S. ANNOUNCEMENTS/COMMENDATIONS 6. CITIZEN COMMENTS/RESPONSES TO COMMENTS(This time is reserved for citizen comments regarding non-agenda items. No official action can be taken on these items. Speakers are limited to five minutes to address the city council during citizen comment time.) 7. CONSENT AGENDA a) Approve January 17, 2023, City Council Meeting Minutes—Administration Approved b) Approve Temporary On-Sale Liquor License—Rotary Club of Farmington - Administration Approved c) Adopt Resolution Approving Gambling Event Permit—MN Youth Fishing Organization—Administration R09-23 d) Approve Staff Changes and Recommendations—Human Resources Approved e) Approve Bills—Finance Approved f) Adopt Resolution Approving 2023 Budget Amendment—Finance R10-23 g) Approve Out of State Travel to Attend Fire Department Instructors Conference- Fire Approved h) Adopt Resolution Declaring Surplus Property— Fire R11-23 I) Approve Agreement for Portable Toilet Services—Parks and Recreation Approved j) Adopt Resolution Accepting Donation from Appliance ReNew to the Rambling River Center—Parks and Recreation R12-23 k) Adopt Resolution Accepting Donation from Happy Harry's Furniture to the Rambling River Center—Parks and Recreation R13-23 REGULAR AGENDA 8. PUBLIC HEARINGS 9. AWARD OF CONTRACT 10. PETITIONS, REQUESTS AND COMMUNICATIONS 11. UNFINISHED BUSINESS 12. NEW BUSINESS a) 2022 Investment Review- Finance Information Received 13. CITY COUNCIL ROUNDTABLE 14. ADJOURN CITY OF 0 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 OFarmington MN.gov TO: Mayor, Councilmembers and City Administrator FROM: Cynthia Muller, Administrative Assistant SUBJECT: Approve January 17, 2023, City Council Meeting Minutes-Administration DATE: February 6, 2023 INTRODUCTION Attached for your review are the minutes of the January 17, 2023, city council meeting. DISCUSSION N/A BUDGET IMPACT N/A ACTION REQUESTED Approve the minutes of the January 17, 2023, city council meeting. ATTACHMENTS: Type Description 0 Exhibit Meeting Minutes COUNCIL MINUTES REGULAR January 17, 2023 1. CALL TO ORDER The meeting was called to order by Mayor Hoyt at 7:00 p.m. 2. PLEDGE OF ALLEGIANCE Mayor Hoyt led the audience and Council in the Pledge of Allegiance. 3. ROLL CALL Members Present: Hoyt, Bernatz, Lien, Wilson Members Absent: Porter Also Present: Leah Koch, City Attorney; Lynn Gorski, City Administrator; Julie Flaten,Assistant City Administrator/HR Director; Chris Regis, Finance Director; Deanna Kuennen, Community Development Director;John Powell, Public Works Director; Kellee Omlid, Parks and Recreation Director; Gary Rutherford, Police Chief;Justin Elvestad, Fire Chief;Tony Wippler, Planning Manager; Cynthia Muller, Administrative Assistant Audience: Barb Svoboda and Margaret Stone, Dakota County Library; David McMillen, Pat Hennen, Blanche Reichert, Ashley Crabtree,Julia Johnson, Marilyn Walton, Larry Smith, Dorothea Vanderwed, Rachel Edwards, Marjorie Koski,Judy Offenbacher, Marlene Swantek, Sandra McCollum, Deb Knubel, Missie Kohlbeck 4. APPROVE AGENDA MOTION by Bernatz, second by Wilson to approve the agenda. APIF, MOTION CARRIED. 5. ANNOUNCEMENTS a) Acknowledge and Adopt Resolution Accepting Donation from Minnwest Bank to the Rambling River Center—Parks and Recreation In December 2021,the Rambling River Center Advisory Board started fundraising for a new passenger van. Any fundraising in 2022 also went toward the van. In November 2022, Neil Anderson of Minnwest Bank contacted the city about community projects and he was directed to the senior center van. At that point, the senior center was short$16,000 to purchase the van. Minnwest Bank donated the$16,000 for the van and presented the check to the Rambling River Center Advisory Board. The senior center members are very excited to go on trips. Councilmembers commented this is amazing and what makes Farmington a great place. Farmington has become like family and this is a phenomenal extension of heart. Council appreciated the bank's continued involvement in the city. MOTION by Wilson, second by Bernatz to adopt RESOLUTION R03-23 accepting a donation of$16,000 from Minnwest Bank to the Rambling River Center. APIF, MOTION CARRIED. Council Minutes(Regular) January 17,2023 Page 2 b) Farmington Library Self-Service Hours Program—Dakota County Margaret Stone, Dakota County Library Director and Barb Svoboda, Farmington Library Director, were in attendance to explain the new self-service hours at the Farmington Library. The library's goal is to expand access to services. Expanded hours are meant to allow people access to public areas in the library. Customers can manage without staff to print a document or have a quiet place to study. Anyone 18 years and older can sign up online to register for expanded hours. Applicants watch a training video, get an application and the library prepares an access card. They are given a tour of the building and shown how the equipment works. There are 8,300 people who have library accounts. There has been a lot of positive, immediate feedback. Residents will have access seven days a week from 6 am to 11 pm. There are 35 people registered so far. People can have ten active reservations at a time and can reserve space 90 days out. Council agreed this is a great program. C) Accept Toys for Town Donations- Police Police Chief Rutherford explained Toys for Town started 35 years ago by Police Chief Dan Siebenaler. This year the program provided toys, gifts and meals to 120 area families with 400 children. Each child, infant to 13 years of age received toys and gifts, each child from 14 to 17 years of age received a gift card. Each child from 2 to 17 years of age also received a gift certificate to Muddy Waters Art Studio. Each family received a complete holiday meal kit from the Bourbon Butcher which included an additional $25 gift card to their group of restaurants. The police department set a goal to raise $35,000 in monetary donations. The final total raised was$40,697.19. Councilmember Bernatz stated the Toys for Town wrapping is her favorite day of the year. She encouraged the community to participate. Councilmember Wilson stated this defines who we are as a community. Councilmember Lien stated he and his family had fun at wrapping day and will come back. Mayor Hoyt noted it is unfortunate we have this need. Our community finds a way. Be part of this event and it will change your life. MOTION by Bernatz, second by Lien to adopt RESOLUTION R04-23 accepting monetary donations in the amount of$40,697.19 for the Farmington Police Department Toys for Town program. APIF, MOTION CARRIED. d) Award of Appropriations Community Project Funding for Rambling River Center-Administration In 2017, a study was done on how to best make use of the space at the Rambling River Center. In March 2022, Congresswoman Angie Craig's office notified staff about available community project funding grants for 2023. Staff submitted a grant request for interior rehabilitation and an exterior expansion which includes a multi-use plaza. A grant request was submitted for$3.6 million. Farmington was awarded $750,000. The grant submission was also supported by Senator Tina Smith and Senator Amy Klobuchar. Council Minutes(Regular) January 17,2023 Page 3 Councilmembers noted this has been a really exciting week. These improvements will help bring the community together and highlight a great structure. Council thanked the elected officials for their support. This stresses the importance of collaboration and building that relationship. We've established new priorities and can't be afraid to ask. Council is extremely grateful for making Congresswoman Craig's short list and the support of our senators. 6. CITIZEN COMMENTS 7. CONSENT AGENDA MOTION by Wilson, second by Lien to approve the Consent Agenda as follows: a) Approved January 3, 2023, City Council Work Session and Meeting Minutes— Administration b) Approved Appointments to Boards and Commissions-Administration C) Approved Commercial Multi-Container Rates for DSI Contract—Administration d) Received Fourth Quarter 2022 New Construction Report/End of the Year and Population Estimate—Community Development e) Adopted RESOLUTION R05-23 Approving the Application for FY 2023 Community Development Block Grant Funds—Community Development f) Approved Development Contract—Denmark Housing Addition—Community Development g) Approved Bills—Finance h) Authorized Spending for 150th Anniversary of Fire Service—Fire i) Approved Creation of Economic Development Coordinator Position —Human Resources and Community Development j) Approved Joint Powers Agreement with Dakota County for Sentence to Service Program Work Crews—Parks and Recreation k) Adopted RESOLUTION R06-23 Accepting Donation from David McKnight to the Rambling River Center—Parks and Recreation 1) Approved an Amendment to the Scope and Budget for Design Services for the Akin Road Improvements—Public Works m) Adopted RESOLUTION R08-23 Approving an Agency Agreement with the Minnesota Department of Transportation —Public Works n) Approved the 2023 Solid Waste and Recycling Coordination Services JPA—Public Works APIF, MOTION CARRIED. 8. PUBLIC HEARINGS 9. AWARD OF CONTRACT 10. PETITIONS, REQUESTS AND COMMUNICATIONS a) Adopt Resolution Approving PUD Amendment—Kwik Trip, 18290 Pilot Knob Road—Community Development Council Minutes(Regular) January 17,2023 Page 4 Kwik Trip, 18290 Pilot Knob Road, located in Dakota County Estates Third Addition is seeking approval of a PUD amendment to allow for a 233.5 square foot freezer addition. The addition would be located on the southwest side of the building, facing Pilot Knob, and would contain a walk-in cooler/freezer. The proposed addition would encroach into the required 50-foot setback from the right-of-way of Pilot Knob Road and increase the square-footage of the building. The addition would be 9 feet, 4 inches wide and 25 feet long. This will not affect the 34 parking stalls located on the property. There are no access changes proposed for the site. Two condensing units will be placed on the ground adjacent to the cooler. These will be stacked units and slatted fencing will be installed to screen the units. The Planning Commission reviewed the PUD amendment on January 10, 2023, and recommended approval. The basis for the 50 foot setback along Pilot Knob is due to the classification of the road in the zoning code and traffic generated. There are no plans to expand Pilot Knob. Councilmembers looked forward to the addition. MOTION by Wilson, second by Bernatz to adopt RESOLUTION R07-23 amending the PUD Agreement for Dakota County Estates Third Addition to allow for a reduced setback and increased building square-footage for Kwik Trip located at 18290 Pilot Knob Road. APIF, MOTION CARRIED. 11. UNFINISHED BUSINESS 12. NEW BUSINESS 13. COUNCIL ROUNDTABLE Wilson: We have more snow coming Thursday. He appreciated DSI looking out for the safety of their drivers and vehicles. Bernatz: Thank you to the police department and her peers on the school board. As a parent she appreciated their due diligence to keep kids safe. Lien: Thank you to the fire department for the invitation to the annual fire banquet. Congratulations to the Rambling River Center. Koch: The Secretary of State has vacancies for boards and commissions on their website. Gorski. Thank you to the fire department for the banquet. Congratulations to Mark Jones for receiving Firefighter of the Year and Amanda Christensen for Officer of the Year. Thank you to Neil Anderson from Minnwest Bank for their amazing gift. Thank you to Barb and the library for being so innovative. Flaten: With the approval tonight, the posting for the Economic Development Coordinator will be on the website and two more full time postings are coming up. Council Minutes(Regular) January 17,2023 Page 5 Kuennen: Thanked council for the EDA discussion and their positive support. Powell: The EAB request for quotes is out. Last week he responded to questions from consulting firms on the statement for qualifications. The Akin Road project will be submitted for state aid this week. The road will be reclaimed this summer and repaved along with the trail on the east side. Omlid. Thank you to the McKnight family for donating the last$5,000 for the van. Thank you to Mayor Hoyt for making the calls to bring the grant home. Regis: Finance is working on year end and audit. Elvestad: Congratulations to all the firefighters for their work done this year. We are getting ready to hire more. Recruitment events are coming up. Rutherford: He encouraged residents to download the DSI app and they will receive prompt notification of their garbage schedule. Hoyt: We have a promising future and we are there. He is proud of this team and the community. Appreciate what you have. Support the community and businesses. 14. ADJOURN MOTION by Wilson, second by Lien to adjourn at 7:55 p.m. APIF, MOTION CARRIED. Respectfully submitted, Cynthia Muller Cynthia Muller Administrative Assistant CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-280-6800 OFarmington MN.gov TO: Mayor, Councilmembers and City Administrator FROM: Cynthia Muller, Administrative Assistant SUBJECT: Approve Temporary On-Sale Liquor License- Rotary Club of Farmington- Administration DATE: February 6, 2023 INTRODUCTION The Rotary Club of Farmington is requesting a Temporary On-Sale Liquor License for a fundraiser to be held June 23 &24, 2023. DISCUSSION This event will be held outside at the Rambling River Center, 325 Oak Street. Per State Statute, a Temporary Liquor License must first be approved by the city and then forwarded to the state for approval. BUDGET IMPACT The state of Minnesota waives all fees for Temporary Liquor Licenses for non-profit organizations. Therefore,the city has not established a fee for a Temporary On-Sale Liquor License. ACTION REQUESTED Approve the attached application fora Temporary On-Sale Liquor License for the Rotary Club of Farmington,for a fundraiser to be held outside at the Rambling River Center, 325 Oak Street, on June 23 &24, 2023. ATTACHMENTS: Type Description D Exhibit Temporary On-Sale Liquor Application Authentisign ID:37493ABF-CDD6-EC11-13656-501AC586DF91) Minnesota Department of Public Safety Alcohol and Gambling Enforcement Division 445 Minnesota Street,Suite 222,St.Paul,MN 55101 651-201-7500 Fax 651-297-5259 TTY 651-282-6555 Alcohol '6nmhling 60oroemen{' APPLICATION AND PERMIT FOR A 1 DAY TO 4 DAY TEMPORARY ON-SALE LIQUOR LICENSE Name of organization Date organized Tax exempt number_ The Rotary Club of Farmington 5/1 EV2001 36-4631800 Address City State Zip Code PO Box 175 1 Farmingt iMinnesota 155024 Name of person making application Business phone Home phone Jenna Calhoun 651-587-497,0 Date(s)of event Type of organization 6/23/2023-6/24/2023 ❑X Club ❑ Charitable E] Religious Other non-profit Organization officer's name City State Zip Code Barb Svoboda IFarmington Minnesota 155024 Organization officer's name City State Zip Code Treasurer- Nathan Lehmeyer lFarmington I Minnesota 1 55024 Organization officer's name City State Zip Code P.f Farmington Minnesota 155024 City State Zip Code Farmington Minnesota 155024 Fundraising Chair- Jenna Calhoun Location where permit will be used. If an outdoor area,describe. Rambling River Center, outdoor concert area 325 Oak Street, Farmington If the applicant will contract for intoxicating liquor service give the name and address of the liquor license providing the service. If the applicant will carry liquor liability insurance please provide the carrier's name and amount of coverage. First National Insurance, James Lundquist 651460-6014x4 APPROVAL APPLICATION MUST BE APPROVED BY CITY OR COUNTY BEFORE SUBMITTING TO ALCOHOL AND GAMBLING ENFORCEMENT City or County approving the license Date Approved Fee Amount Permit Date Date Fee Paid City or County E-mail Address City or County Phone Number Signature City Clerk or County Official Approved Director Alcohol and Gambling Enforcement CLERKS NOTICE:Submit this form to Alcohol and Gambling Enforcement Division 30 days prior to event. ONE SUBMISSION PER EMAIL,APPLICATION ONLY. PLEASE PROVIDE A VALID E-MAIL ADDRESS FOR THE CITY/COUNTY AS ALL TEMPORARY PERMIT APPROVALS WILL BE SENT BACK VIA EMAIL. E-MAIL THE APPLICATION SIGNED BY CITY/COUNTY TO AGE.TEMPORARYAPPLICATION aSTATE.MN.US CITY OF O 430 Third St., Farmington, MN 55024 FARMINGTON © 651-280-6800 111 FarmingtonMN.gov TO: Mayor, Councilmembers and City Administrator FROM: Cynthia Muller,Administrative Assistant SUBJECT: Adopt Resolution Approving Gambling Event Permit—MN Youth Fishing Organization-Administration DATE: February 6, 2023 INTRODUCTION The MN Youth Fishing Organization is requesting a Gambling Event Permit for a banquet and raffle. DISCUSSION Per State Statute 349.166 and pertinent City Code, a Gambling Event Permit must be issued by the city for this type of event. An application has been received, along with the appropriate fees. The police department has reviewed the application and approved the request. BUDGET IMPACT Gambling fees are included in the revenue portion of the 2023 budget. ACTION REQUESTED Consider the attached resolution granting a Gambling Event Permit to the MN Youth Fishing Organization,to be held at Celt's, 200 3rd Street, on September 13, 2023. ATTACHMENTS: Type Description D Resolution Resolution i RESOLUTION No. R09-23 APPROVING A MINNESOTA LAWFUL GAMBLING EVENT PERMIT APPLICATION FOR THE MN YOUTH FISHING ORGANIZATION Pursuant to due call and notice thereof,a regular meeting of the City Council of the City of Farmington, Minnesota,was held in the Council Chambers of said city on the 61h day of February 2023 at 7:00 p.m. Members Present: Hoyt, Bernatz, Lien, Porter,Wilson Members Absent: None Member Bernatz and Member Lien Introduced and seconded the following: WHEREAS,pursuant to M.S.349.166,the State of Minnesota Gambling Board may not issue or renew a Gambling Event Permit unless the City Council adopts a resolution approving said permit; and, WHEREAS,the MN Youth Fishing Organization has submitted an application for a Gambling Event Permit to be conducted at Celt's, 200 31d Street,on September 13, 2023,for Council consideration. NOW,THEREFORE, BE IT RESOLVED by the Farmington City Council that the Gambling Event Permit for the MN Youth Fishing Organization,to be held at Celt's, 200 3rd Street, is hereby approved. This resolution adopted by recorded vote of the Farmington City Council in open session on the 6th day of February 2023. r 7a� yor Attested to the �h day of February 2023. L � Dir City 4dministrator SEAL CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 OFarmington MN.gov TO: Mayor, Councilmembers and City Administrator FROM: Julie Flaten, Assistant City Administrator/Human Resource Director SUBJECT: Staff Changes and Recommendations- Human Resources DATE: February 6, 2023 INTRODUCTION Approve the appointment of three fulltime employees and two seasonal employees. DISCUSSION Fulltime Employees We are recommending Kyle Miller be appointed to fill a current police officer vacancy. Kyle is currently a police officer with the city of New Prague and has worked in security. He has also served in the Army National Guard where he was assigned to do analytics for the Ramsey County Sheriff's Office Violent Crimes Enforcement Team. Kyle will begin on February 7th. Next, we are recommending Caryn Hojnicki be appointed as Communications Specialist. Caryn has her bachelor's degree in Communicans/Technology and her master's degree in Recreation Administration. She has previously worked for two cities in Michigan managing social media and website content and recently moved to Minnesota. Caryn will begin on February 8th. Finally,we are recommending Jared Johnson be appointed Planning Coordinator. Jared has his bachelor's degree in Environmental Planning with a minor in GIS. He currently works for WSB Consulting and has been assigned to work with the City of Farmington since April of 2021. Jared will begin on February 13th. Seasonal Employee We are recommending the hiring of Anna Goodrich and Ava Goodrich as Seasonal Skating Instructors. Both will begin employment on February 11th. BUDGET IMPACT Wages have been included in the 2023 budget. ACTION REQUESTED Appoint Kyle Miller as a Police Officer, Caryn Hojnicki as the Communications Specialist,Jared Johnson as the Planning Coordinator, and Anna Goodrich and Ava Goodrich as Seasonal Skate Instructors. CITY OF O 430 Third St., Farmington, MN 55024 FARMINGTON © 651-280-6800 Farmington M N.gov TO: Mayor, Councilmembers and City Administrator FROM: Chris Regis, Finance Director SUBJECT: Approve Bills- Finance DATE: February 6, 2023 INTRODUCTION Attached is the January 10, 2023—January 31, 2023 city council check register and recently processed automatic payments for your review. DISCUSSION N/A BUDGET IMPACT N/A ACTION REQUESTED Approve the attached payments. ATTACHMENTS: Type Description D Backup Material Council Check Summary R55CKS2 LOGIS600V COUNCIL MEETING FEB 6,2023 CITY OF FARMINGTON 1/30/2023 16:21:15 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 1 1/10/2023 - 1/31/2023 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 101392 1/13/2023 100493 BELLBOY CORPORATION 439.48 LIQUOR&SPIRITS ORDER 209363 0097923300 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 290.48 LIQUOR SUPPLIES&MIXES ORDER 209368 0106240700 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 153.65 BAG ORDER 209368 0106240700 6110 6250 OTHER SUPPLIES&PARTS DOWNTOWN LIQUOR REV&EXP 06100 02 883.61 101393 1/13/2023 100071 COLLEGE CITY BEVERAGE INC 11.69- BEER ORDER CREDIT 209359 1543-00202 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 323.70 BEER ORDER 209362 865155 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 7,708.70 BEER ORDER 209367 865156 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 7,706.05 BEER ORDER 209389 865308 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,472.10 WINE ORDER 209390 865309 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 101.42- BEER ORDER CREDIT 209391 1543-00203 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 17,097.44 101394 1/13/2023 119312 DILIGENT CORPORATION 15,275.00 2023 ICOMPASS SUB 209421 INV375774 7400 6505 EQUIPMENT REPAIR/MAINTENANCE INFORMATION TECHNOLOGY 07400 04 15,275.00 101395 1/13/2023 100022 FARMINGTON PRINTING INC 28.00 NAME PLATE 209285 14465 1010 6210 OFFICE SUPPLIES ADMINISTRATION 01000 01 28.00 101396 1/13/2023 111431 FERGUSON WATERWORKS 244.91 UNIFORMS 209328 0506224-1 6502 6290 UNIFORMS&CLOTHING WATER UTILITY EXPENSE 06500 08 244.91 UNIFORMS 209328 0506224-1 6402 6290 UNIFORMS&CLOTHING STORM WATER UTILITY OPERA 06400 08 244.91 UNIFORMS 209328 0506224-1 6202 6290 UNIFORMS&CLOTHING SEWER OPERATIONS EXPENSE 06200 08 244.89 UNIFORMS 209328 0506224-1 1072 6290 UNIFORMS&CLOTHING STREET MAINTENANCE 01000 08 979.62 101397 1/13/2023 100350 FORCE AMERICA DISTRIBUTING,LLC 1,914.41 SALT SPREADER PARTS 0707 209067 001-1691936 1073 6220 EQUIP SUPPLIES&PARTS SNOW REMOVAL SERVICES 01000 08 1,922.71 SATL SPREADER CONTROL FOR 0706 209218 001-1692802 1073 6230 VEHICLE SUPPLIES&PARTS SNOW REMOVAL SERVICES 01000 08 84.34 CABLE ADAPTER FOR 0706 209219 001-1693398 1073 6230 VEHICLE SUPPLIES&PARTS SNOW REMOVAL SERVICES 01000 08 1,890.00- RTRN:RETROFIT KIT 209351 001-0028466 CR 1073 6230 VEHICLE SUPPLIES&PARTS SNOW REMOVAL SERVICES 01000 08 2,031.46 101398 1/13/2023 112416 IMPACT MAILING OF MN,INC 120.29 DEC22 US MAIL PREP 209355 203683 6202 6401 PROFESSIONAL SERVICES SEWER OPERATIONS EXPENSE 06200 08 120.29 DEC22 UB MAIL PREP 209355 203683 6402 6401 PROFESSIONAL SERVICES STORM WATER UTILITY OPERA 06400 08 120.30 DEC22 UB MAIL PREP 209355 203683 6502 6401 PROFESSIONAL SERVICES WATER UTILITY EXPENSE 06500 08 334.30 DEC22 UB BILL POSTAGE 209355 203683 6202 6445 POSTAGE/SHIPPING FEES SEWER OPERATIONS EXPENSE 06200 08 334.30 DEC22 UB BILL POSTAGE 209355 203683 6402 6445 POSTAGE/SHIPPING FEES STORM WATER UTILITY OPERA 06400 08 334.30 DEC22 UB BILL POSTAGE 209355 203683 6502 6445 POSTAGE/SHIPPING FEES WATER UTILITY EXPENSE 06500 08 1,363.78 R55CKS2 LOGIS600V CITY OF FARMINGTON 1/30/2023 16:21:15 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 2 1/10/2023 - 1/31/2023 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept Div 101399 1/13/2023 116396 MACQUEEN EMERGENCY GROUP 5,039.52 FIRE ENGINE 2 REPAIRS 209231 W04865 1060 6510 1 OUTSIDE VEHICLE REPAIR/MAINT FIRE SERVICES 01000 06 5,039.52 101400 1/13/2023 116734 MINNESOTA OCCUPATIONAL HEALTH 1,184.00 DEC'22 EMPLOYMENT TESTING 209290 415935 1011 6405 EMPLOYMENT TESTING HUMAN RESOURCES 01000 04 1,184.00 101401 1/13/2023 100110 MINNESOTA RECREATION&PARK ASSN 499.00 2023 MRPAAGENCY MEMBERSHIP 209287 2023 MRPAAGENCY 1094 6460 MEMBER DUES&LICENSURE PARK&RECREATION ADMIN 01000 09 170.00 2023 MRPA MEMBERSHIP DUES 209287 2023 MRPAAGENCY 1094 6460 MEMBER DUES&LICENSURE PARK&RECREATION ADMIN 01000 09 170.00 2023 MRPA MEMBERSHIP DUES 209287 2023 MRPAAGENCY 1090 6460 MEMBER DUES&LICENSURE PARK MAINTENANCE 01000 09 170.00 2023 MRPA MEMBERSHIP DUES 2D9287 2023 MRPAAGENCY 1095 6460 MEMBER DUES&LICENSURE RECREATION PROGRAM SERVIC 01000 09 215.00 2023 MRPA MEMBERSHIP DUES 209287 2023 MRPAAGENCY 1093 6460 MEMBER DUES&LICENSURE SENIOR CITIZEN SERVICES 01000 09 90.00 2023 MRPA MEMBERSHIP DUES 209287 2023 MRPAAGENCY 2502 6460 MEMBER DUES&LICENSURE ICE ARENA OPERATIONS EXPE 02500 09 1,314.00 101402 1/13/2023 100070 MINNESOTA VALLEY TESTING LABORATORIES 95.02 BAC-T SAMPLE(7) 209072 1179213 6502 6535 OTHER REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 95.02 101403 1/13/2023 110692 MOBILE MINI,INC 910.00 JAN'23 WARMING HOUSE RENTAL 209291 9016433627 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 910.00 101404 1/13/2023 113424 TITAN MACHINERY 779.16 SNOWBLOWER PARTS 209065 17889207 GP 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 779.16 101406 1/13/2023 109709 TRIHUS,DAVID M 51.25 DEC'22 MILEAGE REIMBURSEMENT 209354 20221231 TRIHUS 6115 6485 MILEAGE REIMBURSEMENT PILOT KNOB LIQUOR 06100 02 51.25 DEC'22 MILEAGE REIMBURSEMENT 209354 20221231 TRIHUS 6110 6485 MILEAGE REIMBURSEMENT DOWNTOWN LIQUOR REV&EXP 06100 02 102.50 101406 1/20/2023 100493 BELLBOY CORPORATION 442.90 LIQUOR&SPIRITS ORDER 209519 0097991300 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 139.77 LIQUOR SUPPLIES&MIXES ORDER 209522 0106267100 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 387.50 LIQUOR SUPPLIES&MIXES ORDER 209598 0106266900 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 192.30 BAG ORDER 209598 0106266900 6115 6250 OTHER SUPPLIES&PARTS PILOT KNOB LIQUOR 06100 02 560.10 LIQUOR&SPIRITS ORDER 209599 0097990900 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,722.57 101407 1/20/2023 118704 BLUE CLOUD DISTRIBUTION OF MINNESOTA INC 972.00 LIQUOR&SPIRIST ORDER 209575 100960415 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 732.00 LIQUOR&SPIRITS ORDER 209712 100960446 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,704.00 R55CKS2 LOGIS600V CITY OF FARMINGTON 1/30/2023 16:21:15 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 3 1/10/2023 - 1/31/2023 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 101408 1/20/2023 117736 CLEAR RIVER BEVERAGE 250.00 BEER ORDER 209549 669005 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 346.50 BEER ORDER 209606 668847 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 596.50 101409 1/20/2023 100071 COLLEGE CITY BEVERAGE INC 352.00 LIQUOR&SPIRITS ORDER 209550 869484 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 4,830.10 BEER ORDER 209551 867201 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,202.40 BEER ORDER 209552 867200 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 124.00- BEER ORDER CREDIT 209555 869297 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 7,563.95 BEER ORDER 209560 869258 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 28.73- BEER ORDER CREDIT 209573 867199 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 84.60 BEER ORDER 209574 867370 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 10,301.30 BEER ORDER 209576 867371 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 131.70- BEER ORDER CREDIT 209577 1543-00208 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 22.85- BEER ORDER CREDIT 209605 1543-00211CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 86.00- BEER ORDER CREDIT 209607 869524 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 224.90 BEER ORDER 209609 869472 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 4,355.65 BEER ORDER 209610 869473 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 28,521.62 101410 1/20/2023 109182 DAKOTA 911 9,212.67 FEB 2023 DAKOTA 911 FEES 209411 FA2023-02 1060 6560 CONTRACTUAL SERVICES FIRE SERVICES 01000 06 18,425.33 FEB 2023 DAKOTA 911 FEES 209411 FA2023-02 1050 6560 CONTRACTUAL SERVICES POLICE ADMINISTRATION 01000 05 27,638.00 101411 1/20/2023 117341 INBOUND BREWCO 237.50 BEER ORDER 209600 15260 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 237.50 101412 1/20/2023 117973 LAWRENCE,GREGG 190.00 2023 SAFETY BOOT ALLOW 209568 2023 0112 LAWRENCE1015 6290 UNIFORMS&CLOTHING CITY HALL 01000 01 190.00 101413 1/20/2023 107747 M.AMUNDSON LLP 1,109.90 POP&CIGARETTES ORDER 209634 355212 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,109.90 101414 1/20/2023 115396 MACQUEEN EMERGENCYGROUP 1,518.75 E 2 TANK LEAK REPAIR 209235 W04601 1060 6510 1 OUTSIDE VEHICLE REPAIR/MAINT FIRE SERVICES 01000 06 1,518.75 101415 1/20/2023 100715 MENARDS-APPLE VALLEY 24.98 VINYL/PLUS 3 COMPOUND PAIL 209735 47567 1015 6240 BUILDING SUPPLIES&PARTS CITY HALL 01000 01 24.98 R55CKS2 LOGIS600V CITY OF FARMINGTON 1/30/2023 16:21:15 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 4 1/10/2023 - 1/31/2023 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 101416 1/20/2023 100070 MINNESOTA VALLEY TESTING LABORATORIES 148.23 BAC-T SAMPLE(7) 209449 1179953 6502 6535 OTHER REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 148.23 101417 1/20/2023 113031 NRG RELIABILITY SOLUTIONS LLC 1,213.53 DEC'22 ELEC LAW ENFORCE CNTR 209410 3346-2301 1050 6422 ELECTRIC POLICE ADMINISTRATION 01000 05 1,699.54 DEC'22 ELEC CMF 209733 3347-2301 6502 6422 ELECTRIC WATER UTILITY EXPENSE 065D0 08 47.21 DEC'22 ELEC CMF 209733 3347-2301 6402 6422 ELECTRIC STORM WATER UTILITY OPERA 06400 08 70.81 DEC'22 ELEC CMF 209733 3347-2301 6202 6422 ELECTRIC SEWER OPERATIONS EXPENSE 06200 08 123.69 DEC'22 ELEC CMF 209733 3347-2301 1090 6422 ELECTRIC PARK MAINTENANCE 01000 09 47.21 DEC'22 ELEC CMF 209733 3347-2301 1072 6422 ELECTRIC STREET MAINTENANCE 01000 08 3,201.99 101418 1/20/2023 108808 VINOCOPIA,INC 502.46 WINE ORDER 209512 0321118-IN 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,309.01 WINE ORDER 209595 0321276-IN 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,811.47 101419 1/27/2023 100193 APPLE VALLEY,CITY OF 22,419.75 4TH QTR 2022 CABLE JPA 209753 7550 4005 6401 PROFESSIONAL SERVICES CABLE/COMMUNICATIONS PROJ 04000 01 23,193.75 1ST QTR 2023 CABLE JPA 209805 7704 4005 6401 PROFESSIONAL SERVICES CABLE/COMMUNICATIONS PROJ 04000 01 45,613.50 101420 1/27/2023 100493 BELLBOY CORPORATION 635.26 LIQUOR&SPIRITS ORDER 209781 0098123300 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 73.36 LIQUOR SUPPLIES&MIXES ORDER 209789 0106317900 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 425.16 LIQUOR SUPPLIES&MIXES ORDER 209843 0106316800 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 132.50 BAG ORDER 209843 0106316800 6115 6250 OTHER SUPPLIES&PARTS PILOT KNOB LIQUOR 06100 02 1,266.28 101421 1/27/2023 100253 CAMPBELL KNUTSON,P.A. 6,743.63 DEC'22 LEGAL FEES-PROSECUTION 209657 1852-0999G DEC'22 1050 6403 LEGAL POLICE ADMINISTRATION 01000 05 730.30 DEC'22 LEGAL FEES-POLICE 209661 1852-0004G DEC'22 1050 6403 LEGAL POLICE ADMINISTRATION 01000 05 1,172.64 DEC'22 LEGAL RETAINER 209670 1852-000OG DEC'22 1005 6403 LEGAL LEGISLATIVE CONTROL 01000 01 REVISED 1,350.50 DEC'22 LEGAL RETAINER 209670 1852-000OG DEC'22 1010 6403 LEGAL ADMINISTRATION 01000 01 REVISED 875.60 DEC'22 LEGAL RETAINER 209670 1852-000OG DEC'22 1030 6403 LEGAL PLANNING&ZONING 01000 03 REVISED 208.00 DEC'22 LEGAL RETAINER 209670 1852-000OG DEC'22 1070 6403 LEGAL ENGINEERING SERVICES 01000 07 REVISED 194.70 DEC'22 LEGAL RETAINER 209670 1852-000OG DEC'22 1094 6403 LEGAL PARK&RECREATION ADMIN 01000 09 REVISED 715.50 DEC'22 LEGAL RETAINER 209670 1852-000OG DEC'22 7400 6403 LEGAL INFORMATION TECHNOLOGY 07400 04 REVISED R55CKS2 LOGIS600V CITY OF FARMINGTON 1/30/2023 16:21:15 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 5 1/10/2023 - 1/31/2023 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 11,990.87 101422 1/27/2023 100071 COLLEGE CITY BEVERAGE INC 2,101.25 BEER ORDER 209782 871874 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 366.90 LIQUOR&SPIRITS ORDER 209785 671469 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 2,126.25- BEER ORDER CREDIT 209788 871873 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 14.09- BEER ORDER CREDIT 209791 1543-00215 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 7,491.00 BEER ORDER 209792 871470 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 12,038.95 BEER ORDER 209818 871652 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 132.80- BEER ORDER CREDIT 209822 871650 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 280.60 BEER ORDER 209826 871651 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 20,005.56 101423 1/27/2023 100022 FARMINGTON PRINTING INC 91.75 COPY PAPER RRC 209494 14470 1010 6220 EQUIP SUPPLIES&PARTS ADMINISTRATION 01000 01 91.75 101424 1/27/2023 109232 HELM ELECTRIC INC 332.28 SHORTED WIRE REPAIR 209874 15236B 1093 6515 BUILDING REPAIR/MAINTENANCE SENIOR CITIZEN SERVICES 01000 09 180.00 HOOK UP ELECTRIC WARMING HOUSE 209875 15234B 1090 6515 BUILDING REPAIR/MAINTENANCE PARK MAINTENANCE 01000 09 379.36 DISTAD PARK LIGHT REPAIR 209876 15235B 1090 6515 BUILDING REPAIR/MAINTENANCE PARK MAINTENANCE 01000 09 203.15 LED LAMPS 209877 15233B 1050 6240 BUILDING SUPPLIES&PARTS POLICE ADMINISTRATION 01000 05 1,094.79 101426 1/27/2023 107984 KIESLER'S POLICE SUPPLY INC 300.63 PEPPER SPRAY 209795 IN206321 1051 6250 OTHER SUPPLIES&PARTS PATROL SERVICES 01000 05 300.63 101426 1/27/2023 102456 KLM ENGINEERING INC 4,500.00 T-MOBILE ANTENNA INSPECTION 209937 9130 6500 2256 65004 DEVELOPMENT ESCROWS WATER UTILITY 06500 08 4,500.00 101427 1/27/2023 119309 LEGACY FARMINGTON MALL LLC 6,678.50 FEB'23 RENT DT LIQUOR STORE 209647 20230201 RENT DT 6110 6556 BUILDING RENTAL DOWNTOWN LIQUOR REV&EXP 06100 02 LIQ 6,678.50 101428 1/27/2023 100063 MACQUEEN EQUIPMENT,INC 245.52 SPRAY GUN FOR 0710 209280 P46709 6202 6230 VEHICLE SUPPLIES&PARTS SEWER OPERATIONS EXPENSE 06200 08 245.52 101429 1/27/2023 102796 MARTIN-MCALLISTER 600.00 K MILLER PREEMPLOYMENT PSYCH 209463 15054 1050 6405 EMPLOYMENT TESTING POLICE ADMINISTRATION 01000 05 600.00 101430 1/27/2023 100125 R&R SPECIALTIES OF WISCONSIN INC 37.50 ZAMBONI BLADE SHARPEN 209267 0077712-IN 2502 6505 EQUIPMENT REPAIR/MAINTENANCE ICE ARENA OPERATIONS EXPE 02500 09 R55CKS2 LOGIS600V CITY OF FARMINGTON 1/30/2023 16:21:15 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 6 1/10/2023 - 1/31/2023 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 37.50 101431 1/27/2023 107945 SCHWINESS,LLC 10,071.10 FEB-23 RENT PK LIQUOR STORE 21)9852 2960 6115 6556 BUILDING RENTAL PILOT KNOB LIQUOR 06100 02 10,071.10 101432 1/27/2023 114206 SUN LIFE FINANCIAL 3,872.30 FEB-23 LIFE INSURANCE 209890 237780 FEB'23 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 3,872.30 101433 1/27/2023 113424 TITAN MACHINERY 157.63 WIPER PARTS FOR 0735 209281 17932121 GP 1073 6220 EQUIP SUPPLIES&PARTS SNOW REMOVAL SERVICES 01000 08 157.63 101434 1/27/2023 108808 VINOCOPIA,INC 588.58 WINE ORDER 209786 0322255-IN 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 431.50 WINE ORDER 209840 0322254-IN 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,020.08 101435 1/27/2023 108450 WSB&ASSOCIATES INC 7,700.00 NOV'22 CODE ENFORCEMENT SERVIC 209294 R-019521-000-11 1030 6401 PROFESSIONAL SERVICES PLANNING&ZONING 01000 03 43.00 MN CHAMBER LUNCHEON 209325 20221207 1010 6470 TRAINING&SUBSISTANCE ADMINISTRATION 01000 01 CONFERENCE 7,672.00 NOV'22 STAFF AUGMENTATION 209349 R-021331-000-3 1070 6401 PROFESSIONAL SERVICES ENGINEERING SERVICES 01000 07 134.75 NOV'22 SVS:MS4 PRMT IMPLMNTN 209350 R-020038-000-9 6402 6401 PROFESSIONAL SERVICES STORM WATER UTILITY OPERA 06400 OB 15,549.75 159439 1/13/2023 119308 ATL LEADERS INTERNATIONAL 3,000.00 ELVESTAD LEADERSHIP TRAINING 209308 2265 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01000 06 3,000.00 169440 1/13/2023 100058 ADVANCE AUTO PARTS 221.40 FUEL FOR CHAINSAWS 209297 2131-609652 1076 6272 FUEL NATURAL RESOURCES 01000 07 22.00- BATTERY CORE RETURN FOR 0933 209298 2131-609255 CR 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 8.17 CAB FRESHENERS FOR 0711 209299 2131-608793 1072 6230 VEHICLE SUPPLIES&PARTS STREET MAINTENANCE 01000 OB 42.84 WIPER BLADES FOR 0552 209301 2131-609391 1051 6230 VEHICLE SUPPLIES&PARTS PATROL SERVICES 01000 05 58.44 BRAKE CLEANER FOR SHOP 209302 2131-609583 7200 6220 EQUIP SUPPLIES&PARTS FLEET OPERATIONS 07200 08 206.07 ALTERNATOR FOR 0726 209304 2131-609361 1072 6220 EQUIP SUPPLIES&PARTS STREET MAINTENANCE 01000 08 10.38 CIRCUIT BREAKER FOR 0715 209305 2131-609700 1072 6230 VEHICLE SUPPLIES&PARTS STREET MAINTENANCE 01000 08 60.92 WIPER BLADES FOR 0562 209306 2131-609825 1051 6230 VEHICLE SUPPLIES&PARTS PATROL SERVICES 01000 05 17.46 WINDSHIELD WAX FOR 0720 209307 2131-609703 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 603.68 159441 1/13/2023 100011 ANDERSEN,EARL F 3,033.75 AREA 1 SIGNS 209073 0131754-IN 1072 6254 SIGNS&STRIPING MATERIALS STREET MAINTENANCE 01000 08 3,951.90 AREA2 SIGNS 209076 0131753-IN 1072 6254 SIGNS&STRIPING MATERIALS STREET MAINTENANCE 01000 08 R55CKS2 LOGIS600V CITY OF FARMINGTON 1/30/2023 16:21:15 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 7 1/10/2023 - 1/31/2023 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 6,985.65 159442 1/13/2023 113303 ARTISAN BEER COMPANY 1,510.80 BEER ORDER 209381 3578712 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,510.80 159443 1/13/2023 108446 ASPEN MILLS,INC. 46.95 EIKLENBORG HANDCUFFS 209244 306178 1051 6290 UNIFORMS&CLOTHING PATROL SERVICES 01000 05 1,309.00 EIKLENBORG INITIAL UNIFORMS 209293 306072 1051 6290 UNIFORMS&CLOTHING PATROL SERVICES 01000 05 1,355.95 159444 1/13/2023 100112 BADGER METER INC 428.28 DEC'22 BEACON MBL HOSTING SERV 209346 80116345 6502 6505 EQUIPMENT REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 3,900.00 ANNUAL SVS/USER AGRMNT-MBL MOD 209346 80116345 6502 6505 EQUIPMENT REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 4,328.28 159445 1/13/2023 114472 BREAKTHRU BEVERAGE MN BEER,LLC 90.00 BEER ORDER 209360 347140364 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 5,814.30 BEER ORDER 209361 347139977 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 119.35 BEER ORDER 209364 347139976 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 43.80 BEER ORDER 209366 347139975 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 76.80 BEER ORDER 209377 347138089 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 13,331.85 BEER ORDER 209392 347138090 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 19,476.10 159446 1/13/2023 114471 BREAKTHRU BEVERAGE MN WINE&SPIRITS 90.90 WINE ORDER 209370 347136747 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 329.80 WINE ORDER 209371 347136746 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 3,256.78 LIQUOR&SPIRITS ORDER 209373 347136744 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 812.35 WINE ORDER 209375 347136745 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,636.74- LIQUOR&SPIRITS ORDER CREDIT 209379 410432137 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 166.90- WINE ORDER CREDIT 209383 410460782 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 698.15- WINE ORDER CREDIT 209384 410432138 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 126.20- LIQUOR&SPIRITS ORDER CREDIT 209385 410460781 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 61.90- LIQUOR&SPIRITS ORDER CREDIT 209387 410437828 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,799.94 159447 1/13/2023 108360 CANNON RIVER WINERY 180.00 WINE ORDER 209374 14561 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 180.00 159448 1/13/2023 118498 CHU,MEGAN 5,000.00 TUITION REIMB:CHU,M 209423 2023 0105 CHU 1011 6475 TUITION REIMBURSEMENT HUMAN RESOURCES 01000 04 5,000.00 159449 1/13/2023 100057 DICK'S SANITATION SERVICE R55CKS2 LOGIS600V CITY OF FARMINGTON 1/30/2023 16:21:15 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 8 1/10/2023 - 1/31/2023 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept Div 1,093.47 FAA DEC 22 RECYCLE TRASH 209320 8593491T460 6302 6560 CONTRACTUAL SERVICES SOLID WASTE OPERATIONS 06300 08 505.23 FAA DEC 22 DAYCARE RECYC TRASH 209321 8593492T460 6302 6560 CONTRACTUAL SERVICES SOLID WASTE OPERATIONS 06300 08 1,598.70 159450 1/13/2023 100149 ECM PUBLISHERS,INC 58.50 ORD#022-770 209062 925004 1010 6455 LEGAL NOTICES ADMINISTRATION 01000 01 58.50 159451 1/13/2023 109931 FACTORY MOTOR PARTS 162.54 BATTERY FOR 0717 209216 1-Z31373 6502 6230 VEHICLE SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 162.54 159462 1/13/2023 100223 FEDEX 79.89 SHIP WATER SAMPLES 209353 7-983-77726 6502 6445 POSTAGE/SHIPPING FEES WATER UTILITY EXPENSE 06500 08 79.89 159453 1/13/2023 112904 FLEETPRIDE TRUCK&TRAILER PARTS 356.21 STOCK FILTERS 209295 104518676 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 128.00 STOCK FILTERS 209296 104547393 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 484.21 159454 1/13/2023 118406 GILMER,DARREL 200.00 SEPTIC INSP BLD PMT 52300 209322 SEPTIC INSP BLD 1031 6401 PROFESSIONAL SERVICES BUILDING INSPECTIONS 01000 07 PMT 52300 200.00 159455 1/13/2023 100499 HAKALA,ANNETTE 43.00 NOV'22 MILEAGE REIMB 209318 20221130 HAKALA 7400 6485 MILEAGE REIMBURSEMENT INFORMATION TECHNOLOGY 07400 04 40.94 DEC'22 MILEAGE REIMBURSEMENT 209319 20221231 HAKALA 7400 6485 MILEAGE REIMBURSEMENT INFORMATION TECHNOLOGY 07400 04 83.94 159456 1/13/2023 100276 HARTFORD LIFE 799.50 2023 VOL FIREFGHTRACC INS 209292 13959329 2023 1060 6158 EMPLOYEE BENEFITS FIRE SERVICES 01000 06 799.50 159457 1/13/2023 100074 HOHENSTEINS INC 1,437.25 BEER ORDER 209372 569995 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,437.25 159458 1/13/2023 111773 INNOVATIVE OFFICE SOLUTIONS,LLC 62.52 TONER 209070 IN4040144 1010 6220 EQUIP SUPPLIES&PARTS ADMINISTRATION 01000 01 62.52 159459 1/13/2023 107414 JEFFERSON FIRE&SAFETY INC 13,618.88 FIRE HOSE 209314 IN147697 5602 6950 60 MACHINERYEQUIP&TOOLS-FD GEN CAPITAL EQUIP FUND EX 05600 13,618.88 169460 1/13/2023 100033 JOHNSON BROTHERS LIQUOR COMPANY R55CKS2 LOGIS600V CITY OF FARMINGTON 1/30/2023 16:21:15 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 9 1/10/2023 - 1/31/2023 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept Div 10.50 WINE ORDER 209365 2209753 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 6.80 WINE ORDER 209369 2209752 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,339.61 WINE ORDER 209394 2207478 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 308.46 LIQUOR&SPIRITS ORDER 209395 2207477 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,194.09 LIQUOR&SPIRITS ORDER 209396 2207480 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 4,623.25 WINE ORDER 209398 2207481 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 3,307.41 LIQUOR&SPIRITS ORDER 209399 2207476 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 35.20 LIQUOR&SPIRITS ORDER 209400 2207479 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 204.80 LIQUOR&SPIRITS ORDER 209402 2209751 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 12,030.12 159461 1/13/2023 119271 KUENNEN,DEANNA 165.00 DEC'22 MILEAGE 209317 20221231 KUENNEN 2000 6485 MILEAGE REIMBURSEMENT HRA/ECONOMIC DEVELOPMENT 02000 03 19.28 MEAL REIMB DEC'22 209317 20221231 KUENNEN 1030 6480 MEETING EXPENSE PLANNING&ZONING 01000 03 184.28 159462 1/13/2023 115568 LEAGUE OF MN CITIES 3,511.58 CL#253564 LAWRENCE 209344 7751 7100 6430 INSURANCE DEDUCTIBLE INSURANCE 07100 02 3,511.58 159463 1/13/2023 100179 LITTLE FALLS MACHINE INC 722.59 CYLINDER FOR PLOW 0708 209273 365997 1073 6230 VEHICLE SUPPLIES&PARTS SNOW REMOVAL SERVICES 01000 08 722.59 159464 1/13/2023 100317 METRO PEST MANAGEMENT INC 91.00 QTRLY PEST CNTRL-FIRE ST#2 209311 23243 1060 6515 BUILDING REPAIR/MAINTENANCE FIRE SERVICES 01000 06 91.00 QTRLY PEST CNTRL-FIRE ST#1 209312 23244 1060 6515 BUILDING REPAIR/MAINTENANCE FIRE SERVICES 01000 06 182.00 159465 1/13/2023 100155 METROPOLITAN COUNCIL ENVIRO SERVICES 44,730.00 DEC-22 MCES SAC FEES 209356 DEC'22 SAC FEES 6200 2425 MCES SAC(SWR AVAIL CHG) SEWER OPERATIONS 06200 08 447.30- DEC'22 MCES SAC FEES 209356 DEC'22 SAC FEES 6201 5030 SAC CHARGE RETAINER SEWER OPERATIONS REVENUE 06200 08 44,282.70 159466 1/13/2023 100290 PAUSTIS&SONS WINE COMPANY 887.50 WINE ORDER 209378 188849 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 887.50 159467 1/13/2023 100093 PELLICCI HARDWARE&RENTAL 9.99 WHITE MARKING PAINT 209450 102735/F 1072 6220 EQUIP SUPPLIES&PARTS STREET MAINTENANCE 01000 08 9.99 159468 1/13/2023 100034 PHILLIPS WINE AND SPIRITS,INC 2,849.49 WINE ORDER 209397 6519875 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 3,576.49 LIQUOR&SPIRITS ORDER 209401 6519874 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 312.30 WINE ORDER 209403 6519876 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 R55CKS2 LOGIS600V CITY OF FARMINGTON 1/30/2023 16:21:15 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 10 1/10/2023 - 1/31/2023 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept Div 6,738.28 — 159469 1/13/2023 110760 PRO-TECH DESIGN,INC 51.00 FIX ISD192 CAM INTEGRATION 209177 107885 7400 6401 PROFESSIONAL SERVICES INFORMATION TECHNOLOGY 07400 04 51.00 159470 1/13/2023 112561 RICOH USA,INC 887.11 JAN'23 COPIER LEASES 209420 106790298 1010 6555 RENTAL OF EQUIPMENT ADMINISTRATION 01000 01 867.11 159471 1/13/2023 118049 SAFE RESTRAINTS,INC 1,497.12 WRAP SAFE RESTRAINT 209242 CH122122FPD 1051 6220 EQUIP SUPPLIES&PARTS PATROL SERVICES 01000 05 1,497.12 159472 1/13/2023 110022 SCHWICKERT'S TECTA AMERICA,LLC 30.33 BOILER REBATE RECORD INFO 209266 S510104376 6502 6515 BUILDING REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 43.33 BOILER REBATE RECORD INFO 209266 S510104376 6402 6515 BUILDING REPAIR/MAINTENANCE STORM WATER UTILITY OPERA 06400 08 21.67 BOILER REBATE RECORD INFO 209266 S510104376 6202 6515 BUILDING REPAIR/MAINTENANCE SEWER OPERATIONS EXPENSE 06200 08 34.67 BOILER REBATE RECORD INFO 209266 S510104376 1090 6515 BUILDING REPAIR/MAINTENANCE PARK MAINTENANCE 01000 09 21.67 BOILER REBATE RECORD INFO 209266 S510104376 1072 6515 BUILDING REPAIR/MAINTENANCE STREET MAINTENANCE 01000 08 151.67 BOILER REBATE RECORD INFO 209266 S510104376 1015 6515 BUILDING REPAIR/MAINTENANCE CITY HALL 01000 01 151.66 BOILER REBATE RECORD INFO 209266 S510104376 1050 6515 BUILDING REPAIR/MAINTENANCE POLICE ADMINISTRATION 01000 05 455.00 159473 1/13/2023 107018 SHAMROCK GROUP 182.00 ICE CUBE ORDER 209376 2648213 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 182.00 159474 1/13/2023 110507 SHRED-IT USA,LLC 100.43 12/12/22 SHREDDING SERVICE 209071 8002970120 1010 6401 PROFESSIONAL SERVICES ADMINISTRATION 01000 01 100.43 159475 1/13/2023 112051 SOUTHERN GLAZER'S OF MN 2.56 WINE ORDER 209380 2296949 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 226.31 LIQUOR&SPIRITS ORDER 209388 2296948 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 6,631.33 LIQUOR&SPIRITS ORDER 209393 2296950 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 6,860.20 159476 1/13/2023 100099 STAR TRIBUNE MEDIA COMPANY,LLC 72.76 STAR TRIBUNE SUBSCRIPTION 209326 10158201 2023 6502 6280 BOOKS&SUBSCRIPTIONS WATER UTILITY EXPENSE 06500 08 72.76 STAR TRIBUNE SUBSCRIPTION 209326 10158201 2023 6402 6280 BOOKS&SUBSCRIPTIONS STORM WATER UTILITY OPERA 06400 08 72.78 STAR TRIBUNE SUBSCRIPTION 209326 10158201 2023 6202 6280 BOOKS&SUBSCRIPTIONS SEWER OPERATIONS EXPENSE 06200 08 218.30 159477 1/13/2023 111333 TITAN ENERGY SYSTEMS,INC 630.00 FIRE ST 2 GENERATOR REPAIR 209236 221220-015 1060 6515 BUILDING REPAIR/MAINTENANCE FIRE SERVICES 01000 06 630.00 R55CKS2 LOGIS600V CITY OF FARMINGTON 1/30/2023 16:21:15 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 11 1/10/2023 - 1/31/2023 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 159478 1/13/2023 100140 US BANK TRUST N A 500.00 AGENT FEES:GO IMP BNDS 2016B 209315 6766703 3136 7130 FISCAL AGENT FEES GO CAP IMP PLAN REFUND 20 03136 02 500.00 AGENT FEES:GO RFND BNDS 2016A 209316 6766702 3094 7130 FISCAL AGENT FEES GO REFUNDING 2016A 03D94 02 1,000.00 159479 1/13/2023 109418 VALLEY-RICH CO,INC 10,444.34 20170 DUNBAR AVE MAIN REPAIR 209327 31602 6502 6401 PROFESSIONAL SERVICES WATER UTILITY EXPENSE 06500 08 10,444.34 159480 1/13/2023 100334 WINE MERCHANTS 73.70 WINE ORDER 209382 7409920 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 267.40 WINE ORDER 209386 7409919 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 341.10 159481 1/13/2023 111333 TITAN ENERGY SYSTEMS,INC 1,262.00 FIRE ST 2 GENERATOR REPAIR 209237 220926-041 1060 6515 BUILDING REPAIR/MAINTENANCE FIRE SERVICES 01000 06 1,262.00 159482 1/20/2023 100058 ADVANCE AUTO PARTS 52.79 HYDRAULIC FITTINGS FOR 0925 209303 2131-610163 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 52.79 159483 1/20/2023 110959 ANCONA TITLE&ESCROW 130.72 REF UTIL CR@1004 MAPLE ST 209478 2022-216685 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 130.72 159484 1/20/2023 100011 ANDERSEN,EARL F 1,492.05 CAMBODIA/213TH SIGNAGE 209471 0131767-IN 1072 6254 SIGNS&STRIPING MATERIALS STREET MAINTENANCE 01000 08 1,492.05 159485 1/20/2023 113303 ARTISAN BEER COMPANY 506.10 BEER ORDER 209588 3579954 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 212.30 BEER ORDER 209615 3580883 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 634.40 BEER ORDER 209720 3582161 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,352.80 159486 1/20/2023 118698 AT&T MOBILITY-CITY HALL 1,903.60 DEC'22 NON-PUBSAFETY CELL SVC 209467 287307208222X010327400 6412 CELLULAR SERVICES INFORMATION TECHNOLOGY 07400 04 023 431.67 DEC'22 NON-PUBSAFETY DATA SVC 209467 287307208222X010327400 6412 CELLULAR SERVICES INFORMATION TECHNOLOGY 07400 04 023 2,335.27 159487 1/20/2023 118206 AT&T MOBILITY-PUBLIC SAFETY 1,417.84 DEC'22 PUB SAFETY CELL SVC 209468 287307208195X010327400 6412 CELLULAR SERVICES INFORMATION TECHNOLOGY 07400 04 023 R55CKS2 LOGIS600V CITY OF FARMINGTON 1/30/2023 16:21:15 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 12 1/10/2023 - 1/31/2023 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 1,217.20 DEC-22 PUB SAFETY DATA SVC 209468 287307208195X010327400 6412 CELLULAR SERVICES INFORMATION TECHNOLOGY 07400 04 023 2,635.04 159488 1/20/2023 119360 BAUTISTA,DON R 340.52 REF UTIL CR@18030 EMPIRE TRL 209488 18030 EMPIRE TRL 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 340.52 159489 1/20/2023 110290 BOLTON&MENK,INC 637.00 NOV'22 SVS:MYSTIC MDW TRL 209665 0303826 5810 6401 PROFESSIONAL SERVICES Trail Maintenance 05810 09 637.00 159490 1/20/2023 114472 BREAKTHRU BEVERAGE MN BEER,LLC 151.70 BEER ORDER 209517 347334256 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 236.95 BEER ORDER 209545 347246372 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 9,182.70 BEER ORDER 209559 347246371 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 9,136.80 BEER ORDER 209563 347334255 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 10,827.70 BEER ORDER 209594 347246631 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 33.85 BEER ORDER 209602 347246630 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 33.85 BEER ORDER 209633 347334247 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 7,739.22 BEER ORDER 209637 347334246 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 37,342.77 159491 1/20/2023 114471 BREAKTHRU BEVERAGE MN WINE&SPIRITS 101.91 WINE ORDER 209508 347332113 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 45.45 WINE ORDER 209528 347244338 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 218.90 WINE ORDER 209532 347244337 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 89.45- WINE ORDER CREDIT 209535 410482304 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 545.65 LIQUOR&SPIRITS ORDER 209536 347244336 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 3,437.01 LIQUOR&SPIRITS ORDER 209562 347332112 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 2,618.30 LIQUOR&SPIRITS ORDER 209593 347244054 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 477.80 WINE ORDER 209618 347331790 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 3,201.60 LIQUOR&SPIRITS ORDER 209635 347331789 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,076.25 LIQUOR&SPIRITS ORDER 209724 347413401 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 11,633.42 159492 1/20/2023 108360 CANNON RIVER WINERY 180.00 WINE ORDER 209636 14616 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 180.00 159493 1/20/2023 119348 CHAPMAN,LAURINDA ANN MCKAY 575.00 LC FOOTCARE NOV DEC 22 209493 100 1093 6560 CONTRACTUAL SERVICES SENIOR CITIZEN SERVICES 01000 09 575.00 159494 1/20/2023 110511 CHARTER COMMUNICATIONS HOLDINGS,LLC 11.13- DEC'22 CHARTER CABLE CREDIT 209419 161655101 7400 6411 TELEPHONE/CABLE SERVICES INFORMATION TECHNOLOGY 07400 04 R55CKS2 LOGIS600V CITY OF FARMINGTON 1/30/2023 16:21:15 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 13 1/10/2023 - 1/31/2023 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 517.03 JAN'23 CABLE&ALARM LINES 209481 0001792010123 7400 6411 TELEPHONE/CABLE SERVICES INFORMATION TECHNOLOGY 07400 04 505.90 159495 1/20/2023 100215 DAKOTA COUNTY CHIEFS OF POLICE ASSN. 600.00 DAKOTA CHIEFS DUES 2023 209660 2023 MEMBERSHIP 1050 6460 MEMBER DUES&LICENSURE POLICE ADMINISTRATION 01000 05 600.00 169496 1/20/2023 110844 DAKOTA COUNTY FINANCIAL SRVS 1,314.84 OCT'22 DIESEL FUEL 209472 000457211 1072 6272 FUEL STREET MAINTENANCE 01000 08 00045722 FINAL 203.12 OCT'22 DIESEL FUEL 209472 00045721/ 6402 6272 FUEL STORM WATER UTILITY OPERA 06400 08 00045722 FINAL 995.10 OCT'22 DIESEL FUEL 209472 00045721/ 1060 6272 FUEL FIRE SERVICES 01000 06 00045722 FINAL 91.12 OCT'22 DIESEL FUEL 209472 00045721/ 1076 6272 FUEL NATURAL RESOURCES 01000 07 00045722 FINAL 2,604.18 159497 1/20/2023 100081 DAKOTA COUNTY LUMBER COMPANY 59.50 WOOD FOR BROKEN GLASS 209738 2301-870734 2502 6220 EQUIP SUPPLIES&PARTS ICE ARENA OPERATIONS EXPE 02500 09 59.50 159498 1/20/2023 108012 DAKOTA COUNTY REGIONAL CHAMBER COMMERCE 300.00 2023 DAKOTA CO CHAMBER DUE 209715 74099 6115 6460 MEMBER DUES&LICENSURE PILOT KNOB LIQUOR 06100 02 300.00 2023 DAKOTA CO CHAMBER DUE 209715 74099 6110 6460 MEMBER DUES&LICENSURE DOWNTOWN LIQUOR REV&EXP 06100 02 600.00 159499 1/20/2023 100147 DAKOTA COUNTY TECHNICAL COLLEGE 250.00 CHU PURSUIT REFRESHER 209651 1068210 1051 6470 TRAINING&SUBSISTANCE PATROL SERVICES 01000 05 300.00 AMUNDSON PURSUIT REFR 209652 1085385 1051 6470 TRAINING&SUBSISTANCE PATROL SERVICES 01000 05 250.00 SUNDGREN PURSUIT REFR 209653 1095402 1052 6470 TRAINING&SUBSISTANCE INVESTIGATION SERVICES 01000 05 300.00 BELLOWS PURSUIT REFR 209654 1066917 1051 6470 TRAINING&SUBSISTANCE PATROL SERVICES 01000 05 600.00 NEUMANN/CRAVEN PURSUIT REFR 209656 1092198 1051 6470 TRAINING&SUBSISTANCE PATROL SERVICES 01000 05 1,700.00 159500 1/20/2023 119361 DCA TITLE-THE TITLE TEAM 82.70 REF UTIL CR@19030 EPIC CT 209489 DC221003/108 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 82.70 159501 1/20/2023 115062 DISTINCTIVE DESIGN BUILD,LLC 48.53 REF UB CR@2653 213TH ST W 209664 2653 213TH ST W 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 48.53 159502 1/20/2023 113296 EDINA REALTY TITLE 747.59 REF UTIL CR@908 2ND ST 209477 2177342/170 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 747.59 R55CKS2 LOGIS600V CITY OF FARMINGTON 1/30/2023 16:21:15 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 14 1/10/2023 - 1/31/2023 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept Div 159603 1/20/2023 113296 EDINA REALTY TITLE 115.17 REF UTIL CR@19651 ESTES PATH 209486 2186163/80 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 115.17 159504 1/20/2023 118859 ENTERPRISE FM TRUST 2,356.54 JAN'23 SQUAD LEASE PYMT(3) 209662 FBN4648385 5600 2601 LEASE PAYABLE GENERAL CAPITAL EQUIPMENT 05600 2,356.54 159505 1/20/2023 103298 EVIDENT,INC. 642.97 CRIME SCENE SUPPLIES 209655 205228A 1052 6220 EQUIP SUPPLIES&PARTS INVESTIGATION SERVICES 01000 05 642.97 159506 1/20/2023 113463 EXECUTIVE TITLE INC 133.78 REF UTIL CR@816 8TH ST 209476 G22120145/42 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 133.78 159507 1/20/2023 109931 FACTORY MOTOR PARTS 28.58 WASHER PUMP FOR 0582 209274 25-1083894 1051 6230 VEHICLE SUPPLIES&PARTS PATROL SERVICES 01000 05 28.58 159508 1/20/2023 118479 FLAHERTY&HOOD,P.A. 3,765.00 209490 20230111 1011 6403 LEGAL HUMAN RESOURCES 01000 04 3,765.00 159509 1/20/2023 102071 GOODYEAR TIRE&RUBBER COMPANY,THE 1,349.20 SQUAD TIRES 209279 124-1107024 7200 6232 VEHICLE/EQUIPMENT TIRES FLEET OPERATIONS 07200 08 1,349.20 169610 1/20/2023 100027 GREAT LAKES COCA-COLA DISTRIBUTION,LLC 752.18 POP ORDER 209557 3600216984 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 732.24 POP ORDER 209578 3608218487 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,484.42 159511 1/20/2023 100074 HOHENSTEINS INC 362.75 BEER ORDER 209564 572378 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,281.50 BEER ORDER 209579 572635 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 315.00 BEER ORDER 209603 574756 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,959.25 159512 1/20/2023 111773 INNOVATIVE OFFICE SOLUTIONS,LLC 364.30 WHITE BOARD 209283 IN4046687 1050 6960 FURNITURE,OFFICE EQUIP,IT POLICE ADMINISTRATION 01000 05 364.30 169513 1/20/2023 116281 J.P.NIXON CONSULTING,LLC 235.00 EIKLENBORG SEARCH/SEIZ TRNG 209663 816 1051 6470 TRAINING&SUBSISTANCE PATROL SERVICES 01000 05 235.00 169614 1/20/2023 100033 JOHNSON BROTHERS LIQUOR COMPANY R55CKS2 LOGIS600V CITY OF FARMINGTON 1/30/2023 16:21:15 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 15 1/10/2023 - 1/31/2023 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 30.58- WINE ORDER CREDIT 209510 2127537-1 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 3,320.12 LIQUOR&SPIRITS ORDER 209524 2212724 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 33.70 LIQUOR&SPIRITS ORDER 209525 2212727 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 404.51 WINE ORDER 209527 2212726 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 671.18 WINE ORDER 209529 2212723 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 973.90 LIQUOR&SPIRITS ORDER 209530 2212725 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 5.10 LIQUOR&SPIRITS ORDER 209531 2212543 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 257.10 WINE ORDER 209533 2212553 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 2.55 LIQUOR&SPIRITS ORDER 209534 2212552 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 2,033.71 LIQUOR&SPIRITS ORDER 209537 2212722 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 462.10 LIQUOR&SPIRITS ORDER 209541 2216562 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 220.28 WINE ORDER 209542 2216563 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 41.70 LIQUOR&SPIRITS ORDER 209546 2216564 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 339.11 LIQUOR&SPIRITS ORDER 209547 2216559 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 457.60 WINE ORDER 209548 2216561 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 375.06 LIQUOR&SPIRITS ORDER 209553 2216560 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 850.55 WINE ORDER 209580 2212550 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,700.73 LIQUOR&SPIRITS ORDER 209581 2212549 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 125.10 LIQUOR&SPIRITS ORDER 209582 2212551 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 38.70 LIQUOR&SPIRITS ORDER 209583 2212547 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 934.71 LIQUOR&SPIRITS ORDER 209584 2212544 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 60.00 LIQUOR&SPIRITS ORDER 209585 2212546 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,442.51 LIQUOR&SPIRITS ORDER 209586 2212548 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 121.40 WINE ORDER 209587 2212545 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 61.72- LIQUOR&SPIRITS ORDER CREDIT 209617 220498 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1.70 DELIVERY ADJUSTMENT 209619 2127536 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 38.70 LIQUOR&SPIRITS ORDER 209621 2216419 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 33.70 LIQUOR&SPIRITS ORDER 209623 2216422 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 897.92 WINE ORDER 209624 2216421 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 973.20 LIQUOR&SPIRITS ORDER 209625 2216420 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 959.35 LIQUOR&SPIRITS ORDER 209627 2216416 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 733.70 LIQUOR&SPIRITS ORDER 209628 2216415 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,177.79 LIQUOR&SPIRITS ORDER 209629 2216417 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 393.75 WINE ORDER 209630 2216418 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 437.95 LIQUOR&SPIRITS ORDER 209714 2220738 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 582.24 LIQUOR&SPIRITS ORDER 209716 2220892 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 171.40 WINE ORDER 209717 2220737 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,888.20 LIQUOR&SPIRITS ORDER 209718 2220896 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 392.51 WINE ORDER 209719 2220893 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 705.41 LIQUOR&SPIRITS ORDER 209721 2220894 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 524.60 WINE ORDER 209722 2220895 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 153.60 LIQUOR&SPIRITS ORDER 209723 2220736 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 R55CKS2 LOGIS600V CITY OF FARMINGTON 1/30/2023 16:21:15 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 16 1/10/2023 - 1/31/2023 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 26,844.84 159515 1/20/2023 119359 KNIGHT BARRY TITLE UNITED LLC 108.78 REF UTIL CR@5827 180TH ST W 209487 2185991/99 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 108.78 159516 1/20/2023 116892 KOSS,ELIZABETH 30.00 2023 STIPEND PARK&REC COMMIS 209571 2023 PARK&REC 1094 6401 PROFESSIONAL SERVICES PARK&RECREATION ADMIN 01000 09 BOARD 30.00 159517 1/20/2023 117759 LAKE TITLE 139.50 REF UTIL CR@608 13TH ST 209475 22-3214-KM 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 139.50 159518 1/20/2023 110501 LAND TITLE INC 17.20 REF UTIL CR@18075 EXTER PL 209483 669575 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 17.20 159519 1/20/2023 105967 MCMILLEN,CINDY 20.00 NOTARY FILING FEE @ CTY 209565 2023 NOTARY FILING 1021 6460 MEMBER DUES&LICENSURE FINANCE 01000 02 FEE 20.00 159520 1/20/2023 111035 MEDICINE LAKE TOURS 1,045.00 TO KILL MOCKINGBIRD TRIP 209495 20230219 ORPHEUM 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 1,045.00 159521 1/20/2023 108490 MINNESOTA UI FUND 1,677.72 4TH QTR 2022 UI PAYMENT 209569 07986748 4TH 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 QTR'22 1,677.72 159522 1/20/2023 118742 MUNICIPAL EMERGENCY SERVICES,INC 24,240.00 8 SETS OF TURNOUT GEAR 209238 lNlB09432 1060 6290 1 TURNOUT GEAR FIRE SERVICES 01000 06 24,240.00 159523 1/20/2023 101254 ORKIN EXTERMINATING,LLC 97.00 1ST QTR 2023 PEST CONTROL-PD 209409 236875556 1050 6515 BUILDING REPAIR/MAINTENANCE POLICE ADMINISTRATION 01000 05 97.00 159524 1/20/2023 100290 PAUSTIS&SONS WINE COMPANY 386.00 WINE ORDER 209518 189689 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 794.00 WINE ORDER 209601 189548 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 327.50 WINE ORDER 209632 190181 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,507.50 159525 1/20/2023 100032 PEPSI COLA COMPANY R55CKS2 LOGIS600V CITY OF FARMINGTON 1/30/2023 16:21:15 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 17 1/10/2023 - 1/31/2023 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 204.70 POP ORDER 209604 64904556 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 204.70 159526 1/20/2023 118379 PEQUOD DISTRIBUTING 553.00 BEER ORDER 209509 W-173933 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 553.00 159527 1/20/2023 100034 PHILLIPS WINE AND SPIRITS,INC 318.93 WINE ORDER 209520 6523893 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 81.70 WINE ORDER 209521 6523894 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 178.85 LIQUOR&SPIRITS ORDER 209526 6523892 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 288.95 LIQUOR&SPIRITS ORDER 209538 6526894 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 735.23 WINE ORDER 209543 6526895 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,318.15 WINE ORDER 209589 6523722 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 55.95 LIQUOR&SPIRITS ORDER 209590 6523723 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,114.15 LIQUOR&SPIRITS ORDER 209592 6523721 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 38.25- LIQUOR&SPIRITS ORDER CREDIT 209616 686216 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,098.40 LIQUOR&SPIRITS ORDER 209622 6526775 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 931.24 WINE ORDER 209626 6526776 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 7,083.30 159528 1/20/2023 110760 PRO-TECH DESIGN,INC 546.00 100 KEY FOBS FOR NEW DOOR SYS 209418 107933 7400 6220 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 546.00 159529 1/20/2023 114619 RED BULL DISTRIBUTION COMPANY,INC 233.28 RED BULL ORDER 209556 5004309368 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 233.28 159530 1/20/2023 117646 RESULTS TITLE 76.40 REF UTIL CR@18434 DUNBURYAVE 209484 22-08238 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 76.40 159531 1/20/2023 112632 RICOH USA,INC 1,060.59 DEC'22 COPIER MAINTENANCE 209469 5066456439 1010 6505 EQUIPMENT REPAIR/MAINTENANCE ADMINISTRATION 01000 01 526.38 DEC'22 COPIER MAINTENANCE 209470 5066456569 1010 6505 EQUIPMENT REPAIR/MAINTENANCE ADMINISTRATION 01000 01 1,586.97 159532 1/20/2023 110022 SCHWICKERTS TECTA AMERICA,LLC 160.00 INFRARED HEATING REPAIR DEC 22 209725 S510104806 2502 6515 BUILDING REPAIR/MAINTENANCE ICE ARENA OPERATIONS EXPE 02500 09 1,050.00 INFRARED HEATING REPAIR DEC 22 209726 S510104809 2502 6515 BUILDING REPAIR/MAINTENANCE ICE ARENA OPERATIONS EXPE 02500 09 360.00 PLANNED SERIVICE INFRARED HEAT 209727 S510104816 2502 6515 BUILDING REPAIR/MAINTENANCE ICE ARENA OPERATIONS EXPE 02500 09 595.00 HVAC REPAIR 209730 S510104662 1093 6515 BUILDING REPAIR/MAINTENANCE SENIOR CITIZEN SERVICES 01000 09 854.00 HVAC REPAIR 209731 S510104377 1015 6515 BUILDING REPAIR/MAINTENANCE CITY HALL 01000 01 98.40 BOILER REPAIR DEC 22 209732 S510104649 6502 6515 BUILDING REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 140.57 BOILER REPAIR DEC 22 209732 S510104649 6402 6515 BUILDING REPAIR/MAINTENANCE STORM WATER UTILITY OPERA 06400 08 R55CKS2 LOGIS600V CITY OF FARMINGTON 1/30/2023 16:21:15 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 18 1/10/2023 - 1/31/2023 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 70.27 BOILER REPAIR DEC 22 209732 S510104649 6202 6515 BUILDING REPAIR/MAINTENANCE SEWER OPERATIONS EXPENSE 06200 08 112.47 BOILER REPAIR DEC 22 209732 S510104649 1090 6515 BUILDING REPAIR/MAINTENANCE PARK MAINTENANCE 01000 09 70.29 BOILER REPAIR DEC 22 209732 S510104649 1072 6515 BUILDING REPAIR/MAINTENANCE STREET MAINTENANCE 01000 08 505.00 HVAC PREVENT MAINTENANCE 209734 S510104663 1015 6515 BUILDING REPAIR/MAINTENANCE CITY HALL 01000 01 4,016.00 159533 1/20/2023 107018 SHAMROCK GROUP 110.50 ICE CUBE ORDER 209554 2848214 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 110.50 159534 1/20/2023 118046 SHRED RIGHT 33.00 SHRED RIGHT DEC 22 209492 591026 4502 6570 PROGRAMMING EXPENSE RRC CAPITAL IMPROVEMENT F 04500 09 33.00 159535 1/20/2023 112051 SOUTHERN GLAZER'S OF MN 1.28 WINE ORDER 209511 2299616 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 184.95 LIQUOR&SPIRITS ORDER 209513 5092986 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 271.28 LIQUOR&SPIRITS ORDERF 209514 5092068 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 624.00- LIQUOR&SPIRITS ORDER CREDIT 209515 9471653 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 406.26 LIQUOR&SPIRITS ORDER 209516 5092067 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 3.20 LIQUOR&SPIRITS ORDER 209539 2301765 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,931.36 LIQUOR&SPIRITS ORDER 209544 5093695 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,961.92 LIQUOR&SPIRITS ORDER 209558 2301766 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 4,777.71 LIQUOR&SPIRITS ORDER 209561 2299617 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 5,006.91 LIQUOR&SPIRITS ORDER 209596 2299621 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 974.83 LIQUOR&SPIRITS ORDER 209597 5092998 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 208.00- LIQUOR&SPIRITS ORDER CREDIT 209611 9471654 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 183.00- LIQUOR&SPIRITS ORDER CREDIT 209612 9470508 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 18.00- LIQUOR&SPIRITS ORDER CREDIT 209613 9472082 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 36.75- WINE ORDER CREDIT 209614 9472150 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 4,886.37 LIQUOR&SPIRITS ORDER 209638 2301770 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 11.52 LIQUOR&SPIRITS ORDER 209639 2301769 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,141.77 LIQUOR&SPIRITS ORDER 209713 2304103 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 21,489.61 159536 1/20/2023 110799 SPECIALIZED ENVIRONMENTAL TECHNOLOGIES 504.00 LOGS/WOOD CHIPS DISPOSAL 209507 10159 DEC'22 1072 6401 PROFESSIONAL SERVICES STREET MAINTENANCE 01000 08 504.00 159537 1/20/2023 100100 STREICHER'S 189.99 NEW HIRE HOLSTER 209461 11609070 1051 6290 UNIFORMS&CLOTHING PATROL SERVICES 01000 05 189.99 159638 1/20/2023 111333 TITAN ENERGY SYSTEMS,INC 346.36 GENERATOR REPAIR 209646 221220-022 1015 6505 EQUIPMENT REPAIR/MAINTENANCE CITY HALL 01000 01 R55CKS2 LOGIS600V CITY OF FARMINGTON 1/30/2023 16:21:15 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 19 1/10/2023 - 1/31/2023 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 833.65 GENERATOR ANNUAL SERVICE 209736 201119-028 1015 6515 BUILDING REPAIR/MAINTENANCE CITY HALL 01000 01 1,180.01 159539 1/20/2023 115777 TITLE GROUP INC,THE 144.03 REF UB CR@18057 DUNCAN CT 209567 221141172/90 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 144.03 159540 1/20/2023 117634 TITLESMART INC. 351.00 REF UTIL CR@6684 210TH ST W 209482 274025/83 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 351.00 159541 1/20/2023 119295 TRUST IN US,LLC 383.12 EMERGENCY TESTING SERVICES 209241 96561 1011 6405 EMPLOYMENT TESTING HUMAN RESOURCES 01000 04 383.12 159542 1/20/2023 113269 UNIVERSITY OF MN,REGENTS OF 520.00 JAN 3 RANGE FEES 209464 0430006685 1051 6470 TRAINING&SUBSISTANCE PATROL SERVICES 01D00 05 520.00 159543 1/20/2023 117589 WATERMARK TITLE AGENCY 166.90 REF UTIL CR@4925 204TH ST W 209479 97744 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 59.87 REF UTIL CR@18835 EMBERS AVE 209485 97774 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 226.77 159544 1/20/2023 100334 WINE MERCHANTS 73.70 WINE ORDER 209523 7411070 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 299.97 WINE ORDER 209540 7411750 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 98.84 WINE ORDER 209591 7411036 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 127.70 WINE ORDER 209620 7411718 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 600.21 159545 1/20/2023 100330 WINEBOW 425.35 LIQUOR&SPIRITS ORDER 209631 MN00125017 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 425.35 159546 1/27/2023 100058 ADVANCE AUTO PARTS 27.85 SPRAYER WAND FITTINGS FOR 0710 209300 2131-610364 6202 6230 VEHICLE SUPPLIES&PARTS SEWER OPERATIONS EXPENSE 06200 08 27.85 159547 1/27/2023 109681 AMUNDSON,JASON 9.88 JAN'23 MEAL REIMB 209803 20230117 AMUNDSON1051 6470 TRAINING&SUBSISTANCE PATROL SERVICES 01000 05 9.88 159548 1/27/2023 119378 ANDERSON,TODD E. 300.00 ENTERTAINMENT ELVIS 209895 012523 1093 6570 PROGRAMMING EXPENSE SENIOR CITIZEN SERVICES 01000 09 300.00 169649 1/27/2023 113303 ARTISAN BEER COMPANY R55CKS2 LOGIS600V CITY OF FARMINGTON 1/30/2023 16:21:15 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 20 1/10/2023 - 1/31/2023 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 13.56- LIQUOR&SPIRITS ORDER CREDIT 209836 353011 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 641.60 BEER ORDER 209839 3582103 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 628.04 159550 1/27/2023 100079 ASPENWALL TREE SERVICE,INC. 2,560.00 EMERGENCY TREE WORK 209776 22-1310 5751 6560 CONTRACTUAL SERVICES FORESTRY MANAGEMENT 05700 2,560.00 159551 1/27/2023 119369 BECKMANN,CURTIS 200.00 GOOD OLE DAYS WCCO 020723 209799 020723 1093 6570 PROGRAMMING EXPENSE SENIOR CITIZEN SERVICES 01000 09 200.00 159552 1/27/2023 110290 BOLTON&MENK,INC 1,978.00 NOV'22 SVS:VERM CMMNS 1 ST CON 209765 0303859 4600 2256 71004 DEVELOPMENT ESCROWS PRIVATE CAPITAL PROJECTS 04600 07 3,616.50 NOV'22 SVS:WHSPRNG FLDS CONST 209767 0303865 4600 2256 70805 DEVELOPMENT ESCROWS PRIVATE CAPITAL PROJECTS 04600 07 2,215.00 NOV'22 SVS:AKIN RD DSGN SVS 209769 0303825 5702 6401 02201 PROFESSIONAL SERVICES SEALCOATING EXPENSES 05700 56.20 NOV'22 SVS:222 PRKNG LOT DSGN 209770 0303855 5801 6401 02202 PROFESSIONAL SERVICES 2022 Parking Lot Project 05801 07 229.80 NOV'22 SVS:2022 SPRUCE ST DSG 209770 0303855 5800 6401 02202 PROFESSIONAL SERVICES Spruce Street Reconstruct 05800 07 1,012.50 NOV'22 SVS:BISCAYNE AVE SWR S 209861 0303858 7600 6401 27010 PROFESSIONAL SERVICES FEDERALAID-COVID19 07600 02 9,108.00 159553 1/27/2023 114472 BREAKTHRU BEVERAGE MN BEER,LLC 59.00 LIQUOR&SPIRITS ORDER 209783 347414926 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 43.80 LIQUOR&SPIRITS ORDER 209784 347414928 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 7,906.10 BEER ORDER 209793 347414927 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 10,133.50 BEER ORDER 209830 347414884 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 8.00- BEER ORDER CREDIT 209841 410466133 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 3.30- BEER ORDER CREDIT 209849 410466134 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 73.05 BEER ORDER 209850 347420245 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 18,204.15 159554 1/27/2023 114471 BREAKTHRU BEVERAGE MN WINE&SPIRITS 3,929.57 LIQUOR&SPIRITS ORDER 209827 347412802 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 210.90- WINE ORDER CREDIT 209842 410522350 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 519.25 WINE ORDER 209844 347412804 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 181.45- LIQUOR&SPIRITS ORDER CREDIT 209845 410522349 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 7.25 LIQUOR SUPPLIES&MIXES ORDER 209846 347412803 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 388.35 WINE ORDER 209847 347412805 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 4,452.07 159555 1/27/2023 108360 CANNON RIVER WINERY 180.00 WINE ORDER 209848 14643 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 180.00 159556 1/27/2023 110511 CHARTER COMMUNICATIONS HOLDINGS,LLC 16.85 JAN'23 FS2 CABLE LINE 209754 0164297010623 7400 6412 CELLULAR SERVICES INFORMATION TECHNOLOGY 07400 04 R55CKS2 LOGIS600V CITY OF FARMINGTON 1/30/2023 16:21:15 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 21 1/10/2023 - 1/31/2023 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept Div 16.85 — — 159557 1/27/2023 100149 ECM PUBLISHERS,INC 27.50 PC PH:TEN NINTEEN DEV 209284 926972 1030 6455 LEGAL NOTICES PLANNING&ZONING 01000 03 27.50 159558 1/27/2023 113296 EDINA REALTY TITLE 245.08 REF UTIL CR@20543 EASTVIEWAVE 209800 2186280/117 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 245.08 159559 1/27/2023 100364 EHLERS&ASSOCIATES INC 2,671.25 DEC'22 SVS:TIF 15-ANALYSIS 209863 92835 4600 2256 80000 DEVELOPMENT ESCROWS PRIVATE CAPITAL PROJECTS 04600 07 2,671.25 159560 1/27/2023 119045 FLEX TITLE COMPANY LLC 186.29 REF UTIL CR@18871 DUNBURY AVE 209779 2212-0754/54 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 186.29 159561 1/27/2023 119045 FLEX TITLE COMPANY LLC 224.33 REF UTIL CR@805 SPRUCE ST 209780 2212-0797/53 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 224.33 159562 1/27/2023 100077 FRONTIER COMMUNICATIONS 97.67 JAN'23 WELL HOUSE LINE 209755 651-460-4974 6502 6411 TELEPHONE/CABLE SERVICES WATER UTILITY EXPENSE 06500 08 JAN'23 97.67 159563 1/27/2023 110895 GALLAGHER BENEFIT SERVICES,INC 400.00 CITY CLERK JOB CLASSIFICATIONS 209804 2022012922 1011 6401 PROFESSIONAL SERVICES HUMAN RESOURCES 01000 04 400.00 159564 1/27/2023 100024 GOPHER STATE ONE-CALL 57.60 DECEMBER 2022 LOCATES 209334 2120392 6502 6401 PROFESSIONAL SERVICES WATER UTILITY EXPENSE 06500 08 57.60 DECEMBER 2022 LOCATES 209334 2120392 6402 6401 PROFESSIONAL SERVICES STORM WATER UTILITY OPERA 06400 08 57.60 DECEMBER 2022 LOCATES 209334 2120392 6202 6401 PROFESSIONAL SERVICES SEWER OPERATIONS EXPENSE 06200 08 172.80 159565 1/27/2023 116689 GREATAMERICA FINANCIAL SERVICES 217.85 JAN'23 POSTAGE METER RENTAL 209480 33202984 1010 6555 RENTAL OF EQUIPMENT ADMINISTRATION 01000 01 217.85 159566 1/27/2023 118267 HAWKE,MICHAEL J 5,352.75 DEC'22 ELEC PRMTS PAYABLE 209857 INV#2023-1 1000 2020 CONTRACTS PAYABLE GENERAL FUND BALANCE SHEE 01000 5,352.75 159567 1/27/2023 100074 HOHENSTEINS INC 742.50 BEER ORDER 209808 576383 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 734.25 BEER ORDER 209820 574601 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 R55CKS2 LOGIS600V CITY OF FARMINGTON 1/30/2023 16:21:15 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 22 1/10/2023 - 1/31/2023 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 1,476.75 159568 1/27/2023 111773 INNOVATIVE OFFICE SOLUTIONS,LLC 33.54 LABELS,PAPER 209286 IN4049578 1010 6210 OFFICE SUPPLIES ADMINISTRATION 01000 01 94.91 LABELS/PENS/CLIPS/WRISTREST 209289 IN4049580 1050 6210 OFFICE SUPPLIES POLICE ADMINISTRATION 01000 05 12.00 DIVIDERS 209406 IN4052472 1050 6210 OFFICE SUPPLIES POLICE ADMINISTRATION 01000 05 140.45 159569 1/27/2023 100033 JOHNSON BROTHERS LIQUOR COMPANY 305.88 WINE ORDER 209610 2225274 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 188.60 WINE ORDER 209811 2225115 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 102.40 LIQUOR&SPIRITS ORDER 209812 2225114 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 2,293.79 LIQUOR&SPIRITS ORDER 209813 2225270 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 745.45 LIQUOR&SPIRITS ORDER 209814 2225273 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 394.85 LIQUOR&SPIRITS ORDER 209815 2225271 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 300.49 WINE ORDER 209816 2225272 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,535.17 WINE ORDER 209819 2223047 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,315.59 LIQUOR&SPIRITS ORDER 209823 2223045 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 199.10 LIQUOR&SPIRITS ORDER 209825 2223046 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 524.50 WINE ORDER 209833 2223043 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 49.70 LIQUOR&SPIRITS ORDER 209835 2223044 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,274.22 LIQUOR&SPIRITS ORDER 209837 2223042 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 49.70 LIQUOR&SPIRITS ORDER 209851 2223048 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 9,279.44 159570 1/27/2023 100121 LEAGUE OF MINNESOTA CITIES 2,340.00 2023 PATROL ONLINE FEES 209859 374832 1050 656D CONTRACTUAL SERVICES POLICE ADMINISTRATION 01000 05 2,340.00 159571 1/27/2023 115466 LIFE INSURANCE COMPANY OF NORTH AMERICA 200.45 FEB'23 ACCIDENT INSURANCE 209887 A1960331 FEB'23 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 174.16 FEB'23 Cl INSURANCE 209888 C1960343 FEB'23 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 374.61 159572 1/27/2023 112398 MADISON NATIONAL LIFE INSURANCE CO, 1,000.02 FEB'23 LTD INSURANCE 209886 1539019 FEB'23 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 1,000.02 159573 1/27/2023 100095 METROPOLITAN COUNCIL ENVIRONMENTAL SVS 166,243.95 FEB 2023 WASTE WATER MCES FEES 209348 0001150233 6202 6565 MCES FEES SEWER OPERATIONS EXPENSE 06200 08 166,243.95 159574 1/27/2023 119372 MICROSOFT CORPORATION 450.00 SURFACE LAPTOP REPAIR 209881 9441638166 7400 6505 EQUIPMENT REPAIR/MAINTENANCE INFORMATION TECHNOLOGY 07400 04 450.00 R55CKS2 LOGIS600V CITY OF FARMINGTON 1/30/2023 16:21:15 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 23 1/10/2023 - 1/31/2023 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 159575 1/27/2023 100322 MN NCPERS LIFE INSURANCE 16.00 209940 012623822253 7000 2119 PERA LIFE INS PAYABLE EMPLOYEE EXPENSE FUND 07000 02 16.00 159576 1/27/2023 107932 MOOD MEDIA 58.52 FEB 2023 RADIO SVS-LIQUOR 209794 57346859 6115 6401 PROFESSIONAL SERVICES PILOT KNOB LIQUOR 06100 02 58.53 FEB 2023 RADIO SVS-LIQUOR 209794 57346859 6110 6401 PROFESSIONAL SERVICES DOWNTOWN LIQUOR REV&EXP 06100 02 117.05 159577 1/27/2023 118558 MUDDY WATERS STUDIO INC 300.00 CERAMIC MUG CLASS 209856 20230102 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 300.00 159578 1/27/2023 118742 MUNICIPAL EMERGENCY SERVICES,INC 674.15 EXTINGUISHER FLUID 209310 IN1810881 1060 6220 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 820.00 FIREFIGHTING BOOTS 209756 IN1810393 1060 6290 1 TURNOUT GEAR FIRE SERVICES 01000 06 1,494.15 159579 1/27/2023 119375 NICOLAI,DAVID 1,114.00 OVRPYMT WAC FEE PRMT46326 209855 OVRPYMT WAC FEE 6500 2255 DEPOSITS PAYABLE WATER UTILITY 06500 08 PRMT46326 1,114.00 159580 1/27/2023 100290 PAUSTIS&SONS WINE COMPANY 212.00 WINE ORDER 209821 190860 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 212.00 159581 1/27/2023 100034 PHILLIPS WINE AND SPIRITS,INC 309.40 LIQUOR&SPIRITS ORDER 209787 6532274 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 377.76 WINE ORDER 209790 6532275 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 221.87 WINE ORDER 209809 6533816 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 756.75 LIQUOR&SPIRITS ORDER 209817 6533815 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 569.11 WINE ORDER 209834 6532128 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 588.15 LIQUOR&SPIRITS ORDER 209838 6532127 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,823.04 159582 1/27/2023 110760 PRO-TECH DESIGN,INC 396.93 BADGE PRINTER INK 209422 108128 7400 6220 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 396.93 159583 1/27/2023 112430 PROVOST,SCOTT 79.97 '23 WORK BOOTS 209802 20230123 PROVOST 1090 6290 UNIFORMS&CLOTHING PARK MAINTENANCE 01000 09 79.98 '23 WORK BOOTS 209802 20230123 PROVOST 2502 6290 UNIFORMS&CLOTHING ICE ARENA OPERATIONS EXPE 02500 09 159.95 159584 1/27/2023 117958 QUAD E COMPANIES,INC 3,339.70 SNOW HAULING 209954 4890 1073 6560 CONTRACTUAL SERVICES SNOW REMOVAL SERVICES 01000 08 R55CKS2 LOGIS600V CITY OF FARMINGTON 1/30/2023 16:21:15 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 24 1/10/2023 - 1/31/2023 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 3,339.70 159585 1/27/2023 100196 QUALITY REFRIGERATION INC 1,208.01 HVAC REPAIR-ROOF UNIT 209853 1112321 6110 6515 BUILDING REPAIR/MAINTENANCE DOWNTOWN LIQUOR REV&EXP 06100 02 1,208.01 159586 1/27/2023 119371 REA LIGHTING 476.00 OVERPYMT ELECT PRMT 51066 209801 OVERPYMT ELECT 1000 2255 DEPOSITS PAYABLE GENERAL FUND BALANCE SHEE 01000 PRMT 51066 476.00 159587 1/27/2023 112561 RICOH USA,INC 948.88 FEB'23 COPIER LEASES 209882 106868875 1010 6555 RENTAL OF EQUIPMENT ADMINISTRATION 01000 01 948.88 169588 1/27/2023 112632 RICOH USA,INC 10.37 JAN'23 PLOTTER MAINTENANCE 209884 5066611522 1010 6505 EQUIPMENT REPAIR/MAINTENANCE ADMINISTRATION 01000 01 10.37 159589 1/27/2023 112011 ROSEMOUNT,CITY OF 375.00 NM HISTORY THEATER TRIP 209806 MN HISTORY CTR 1093 6570 PROGRAMMING EXPENSE SENIOR CITIZEN SERVICES 01000 09 011923 375.00 159590 1/27/2023 110022 SCHWICKERT'S TECTA AMERICA,LLC 3,250.00 HVAC REPAIR 209743 S510104973 1060 6515 BUILDING REPAIR/MAINTENANCE FIRE SERVICES 01000 06 3,250.00 169591 1/27/2023 119377 SECURITY CONTROL SYSTEMS 81.57 OVRPYMT FIRE PRMT 52780 209864 OVRPYMT FIRE PRMTI000 2255 DEPOSITS PAYABLE GENERAL FUND BALANCE SHEE 01000 52780 81.57 159592 1/27/2023 107018 SHAMROCK GROUP 105.75 ICE CUBE ORDER 209824 2851389 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 105.75 159593 1/27/2023 112051 SOUTHERN GLAZER'S OF MN 2,243.68 LIQUOR&SPIRITS ORDER 209828 2304104 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 963.21 LIQUOR&SPIRITS ORDER 209829 2304105 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 3,206.89 159594 1/27/2023 100100 STREICHER'S 262.99 REUBEN VEST CARRIER 209858 11611335 1051 6290 UNIFORMS&CLOTHING PATROL SERVICES 01000 05 262.99 159596 1/27/2023 119370 VERGARA,MARTIN 500.00 RRC DAMAGE DEPOSIT RTRN 011423 209752 011423 1000 2255 DEPOSITS PAYABLE GENERAL FUND BALANCE SHEE 01000 R55CKS2 LOGIS600V CITY OF FARMINGTON 1/30/2023 16:21:15 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 25 1/10/2023 - 1/31/2023 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept Div 500.00 159596 1/27/2023 100334 WINE MERCHANTS 1,203.30 WINE ORDER 209831 7412948 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 73.70 WINE ORDER 209832 7412949 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,277.00 159597 1/27/2023 118545 XAVUS SOLUTIONS 1,200.00 MY SENIOR CENTER 23 209807 20819 1093 6560 CONTRACTUAL SERVICES SENIOR CITIZEN SERVICES 01000 09 1,200.00 20230101 1/3/2023 100085 DAKOTA ELECTRIC ASSOCIATION 1,075.24 NOV'22 ELEC PK LIQ STORE 208636 200003759891 6115 6422 ELECTRIC PILOT KNOB LIQUOR 06100 02 NOV'22 36.02 NOV'22 ELEC TUNNEL LIGHT 208752 200005468327 1090 6422 ELECTRIC PARK MAINTENANCE 01000 09 NOV'22 2,596.74 NOV'22 ELEC WELL#4 208765 200001318526 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 NOV'22 2,280.45 NOV'22 ELEC WELL#5 208766 200002785533 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 NOV'22 1,506.09 NOV'22 ELEC WELL#6 208767 200001550151 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 NOV'22 329.43 NOV'22 ELEC WELL#7 208768 200003490737 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 NOV'22 122.67 NOV'22 ELEC VERM GROVE LS 208769 200003215779 6202 6422 ELECTRIC SEWER OPERATIONS EXPENSE 06200 08 NOV'22 24.86 NOV'22 ELEC DAISY KNOLL TOWER 208770 200001318518 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 NOV'22 7,222.57 NOV'22 ELEC 9TH ST STREET LTS 208771 200001038421 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 NOV'22 164.18 NOV'22 ELEC 195TH WATER TOWER 208772 200002587095 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 NOV'22 535.62 NOV'22 ELEC WELL#8 208773 200004199709 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 NOV'22 1,388.34 NOV'22 ELEC WELL#9 208774 200010028004 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 NOV'22 5.00 NOV'22 ELEC CIV DEF SIREN 208782 200001982271 1054 6422 ELECTRIC EMERGENCY MGMT SERVICES 01000 05 NOV'22 5.00 NOV'22 ELEC CIV DEF SIREN 208783 200002260958 1054 6422 ELECTRIC EMERGENCY MGMT SERVICES 01000 05 NOV'22 525.11 NOV'22 ELEC FIRE STATN#2 208869 200003971959 1060 6422 ELECTRIC FIRE SERVICES 01000 06 NOV'22 17,817.32 R55CKS2 LOGIS600V CITY OF FARMINGTON 1/30/2023 16:21:15 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 26 1/10/2023 - 1/31/2023 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 20230102 1/3/2023 112399 DEARBORN LIFE INSURANCE COMPANY 1,701.23 JAN-23 STD INSURANCE PREMIUMS 209162 019839-1 JAN'23 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 1,701.23 20230103 1/4/2023 117955 VSP INSURANCE CO. 393.99 JAN'23 VISION INS PREMIUM 209166 816768380 JAN'23 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 393.99 20230104 1/4/2023 100085 DAKOTA ELECTRIC ASSOCIATION 11.46 PARK&REC SIGN ELEC FINAL 208828 200002260479 1090 6422 ELECTRIC PARK MAINTENANCE 01000 09 DEC'22 FINAL 11.46 20230105 1/4/2023 100394 XCEL ENERGY 9.34 NOV'22 ELEC CIV DEF SIREN 208784 51-4874006 NOV'22 1054 6422 ELECTRIC EMERGENCY MGMT SERVICES 01000 05 9.34 20230106 1/5/2023 100394 XCEL ENERGY 98.87 NOV'22 ELEC DOWNTOWN ST LTS 208775 51-4874005 NOV'22 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 434.23 NOV'22 ELEC WELL#1&3 208775 51-4874005 NOV'22 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 64.05 NOV'22 ELEC LIFT STATIONS 208775 514874005 NOV'22 6202 6422 ELECTRIC SEWER OPERATIONS EXPENSE 06200 08 53.40 NOV'22 ELEC TRAFFIC SIGNAL 208775 51-4874005 NOV'22 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 226.37 NOV'22 ELEC ROUNDABOUT 206775 51-4874005 NOV'22 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 6.77 NOV'22 ELEC CITY GARAGE 208775 51-4874005 NOV'22 6202 6422 ELECTRIC SEWER OPERATIONS EXPENSE 06200 08 162.49 NOV'22 ELEC CITY GARAGE 208775 51-4874005 NOV'22 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 4.51 NOV'22 ELEC CITY GARAGE 208775 51-4874005 NOV'22 6402 6422 ELECTRIC STORM WATER UTILITY OPERA 06400 08 4.51 NOV'22 ELEC CITY GARAGE 208775 51-4874005 NOV'22 1072 6422 ELECTRIC STREET MAINTENANCE 01000 08 11.84 NOV'22 ELEC CITY GARAGE 208775 51-4874005 NOV'22 1090 6422 ELECTRIC PARK MAINTENANCE 01000 09 8,811.10 NOV'22 ELEC NOW METER ST LTS 208775 51-4874005 NOV'22 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 9,878.14 20230107 1/5/2023 115438 AMERITAS LIFE INSURANCE CORP 5,939.96 JAN-23 DENTAL INSURANCE 209288 010-44446 JAN'23 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 5,939.96 20230108 1/5/2023 116564 FP MAILING SOLUTIONS/POSTALIA 10.00 POSTAGE FOR POSTAGE METER 209405 11822345 20230103 1050 6555 RENTAL OF EQUIPMENT POLICE ADMINISTRATION 01000 05 10.00 20230109 1/6/2023 117968 EBSO 82,247.66 JAN-23 HEALTH INS PREMIUM 209466 9029-080528-1000 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 82,247.66 20230110 1/9/2023 108980 MINNESOTA ENERGY RESOURCES CORPORATION 159.76 DEC'22 GAS 208TH ST WARM HOUSE 209060 0506537581 DEC'22 1090 6423 NATURAL GAS PARK MAINTENANCE 01000 09 1,895.04 DEC'22 GAS FIRE STATION 2 209103 0505001779 NOV'22 1060 6423 NATURAL GAS FIRE SERVICES 01000 06 R55CKS2 LOGIS600V CITY OF FARMINGTON 1/30/2023 16:21:15 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 27 1/10/2023 - 1/31/2023 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 2,054.80 20230111 1/12/2023 116564 FP MAILING SOLUTIONS/POSTALIA 500.00 POSTAGE METER REFILL 209358 61858118 20230110 1014 6445 POSTAGE/SHIPPING FEES COMMUNICATIONS 01000 01 500.00 20230112 1/13/2023 100135 PUBLIC EMPLOYEES RETIREMENTASSN. 25,642.81 209457 011223945401 7000 2113 PERA PAYABLE EMPLOYEE EXPENSE FUND 07000 02 34,015.37 209458 011223945402 7000 6154 PERA EMPLOYEE EXPENSE FUND 07000 02 59,658.18 20230113 1/18/2023 117633 NOKOMIS ENERGY LLC 2,065.79 DEC'22 ELEC CITYHALL 209271 AOR3YP-2022-12-31 1015 6422 ELECTRIC CITY HALL 01000 01 250.79 DEC'22 ELEC RRC 209271 AOR3YP-2022-12-31 1093 6422 ELECTRIC SENIOR CITIZEN SERVICES 01000 09 3,280.91 DEC'22 ELEC ARENA 209271 AOR3YP-2022-12-31 2502 6422 ELECTRIC ICE ARENA OPERATIONS EXPE 02500 09 5,597.49 20230114 1/19/2023 111046 VOYAGER FLEET SYSTEMS INC 657.94 DEC'22 FUEL NAT RES 209214 8690882372262 NAT 1076 6272 FUEL NATURAL RESOURCES 01000 07 RES 129.61 DEC'22 FUEL ENGINEERING 209223 8690882372252 1070 6272 FUEL ENGINEERING SERVICES 01000 07 ENGINEERING 946.39 DEC'22 FUEL FIRE 209233 8690882372252 FIRE 1060 6272 FUEL FIRE SERVICES 01000 06 4,766.92 DEC'22 FUEL POLICE 209245 8690882372262 1051 6272 FUEL PATROL SERVICES 01000 05 POLICE 3,169.96 DEC-22 FUEL PARKS 209272 8690882372262 1090 6272 FUEL PARK MAINTENANCE 01000 09 PARKS 260.38 DEC'22 FUEL BLDG INSP 209473 8690882372252 BLDG 1031 6272 FUEL BUILDING INSPECTIONS 01000 07 INSP 536.60 DEC'22 FUEL SEWER 209474 8690882372262 6202 6272 FUEL SEWER OPERATIONS EXPENSE 06200 08 SEWER 279.37 DEC'21 FUEL FLEET 209496 8690882372252 7200 6272 FUEL FLEET OPERATIONS 07200 08 FLEET 451.96 DEC'22 FUEL WATER 209497 8690882372252 6502 6272 FUEL WATER UTILITY EXPENSE 06500 08 WATER 239.79 DEC'22 FUEL STORM 209498 8690882372252 6402 6272 FUEL STORM WATER UTILITY OPERA 06400 08 STORM 259.40 DEC'22 FUEL STREET 209499 8690882372252 ST/ 1072 6272 FUEL STREET MAINTENANCE 01000 08 SN 1,745.02 DEC'22 FUEL SNOW 209499 8690882372252 ST/ 1073 6272 FUEL SNOW REMOVAL SERVICES 01000 08 SN 13,443.34 20230115 1/19/2023 108980 MINNESOTA ENERGY RESOURCES CORPORATION 195.63 DEC'22 GAS WELL#5 209329 0507120636 DEC'22 6502 6423 NATURAL GAS WATER UTILITY EXPENSE 06500 08 R55CKS2 LOGIS600V CITY OF FARMINGTON 1/30/2023 16:21:15 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 28 1/10/2023 - 1/31/2023 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 24.87 DEC'22 GAS VERM GROVE LIFT STN 209330 0503080372 DEC'22 6202 6423 NATURAL GAS SEWER OPERATIONS EXPENSE 06200 08 220.50 20230116 1/20/2023 108980 MINNESOTA ENERGY RESOURCES CORPORATION 846.73 DEC'22 GAS DT LIQ STORE 209414 0731950432 DEC'22 6110 6423 NATURAL GAS DOWNTOWN LIQUOR REV&EXP 06100 02 848.73 20230117 1/23/2023 100086 DAKOTA ELECTRIC ASSOCIATION 584.64 DEC'22 ELEC FIRE STATION 1 209240 200001679489 1060 6422 ELECTRIC FIRE SERVICES 01000 06 DEC'22 16.22 DEC'22 PK CITY SIGN NORTH ENTR 209265 200010011266 1090 6422 ELECTRIC PARK MAINTENANCE 01000 09 DEC'22 21.85 DEC'22 ELEC 220TH ST LIFT STN 209331 200001405224 6202 6422 ELECTRIC SEWER OPERATIONS EXPENSE 06200 08 DEC'22 324.32 DEC'22 ELEC DNMRK/SPRCE ST LTS 209332 200004222477 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 DEC'22 21.48 DEC'22 ELEC SPRUCE ST MNMNT LT 209333 200004099123 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 DEC'22 970.51 20230118 1/24/2023 100394 XCEL ENERGY 168.77 DEC'22 ELEC-DISTAD PARK WRM HS 209259 51-9027188 DEC'22 1090 6422 ELECTRIC PARK MAINTENANCE 01000 09 260.86 DEC'22 ELEC-190TH ST BRDG LTS 209500 51-9371130 DEC'22 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 41.99 DEC'22 ELEC-LINDEN ST LFT STN 209501 51-6565658 DEC'22 6202 6422 ELECTRIC SEWER OPERATIONS EXPENSE 06200 08 46.53 DEC'22 ELEC-5262 206TH ST LTS 209502 51-8391412 DEC'22 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 271.47 DEC'22 ELEC-321 ELM ST LTS 209503 51-8608862 DEC'22 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 789.62 20230119 1/25/2023 108980 MINNESOTA ENERGY RESOURCES CORPORATION 2,124.86 DEC'22 GAS FIRE STATION 209309 0506565319 DEC'22 1060 6423 NATURAL GAS FIRE SERVICES 01000 06 2,358.37 DEC'22 GAS RRC 209324 0507948331 DEC'22 1093 6423 NATURAL GAS SENIOR CITIZEN SERVICES 01000 09 146.15 DEC'22 GAS WELL HOUSE 1 OAK ST 209335 0506788875 DEC'22 6502 6423 NATURAL GAS WATER UTILITY EXPENSE 06500 08 341.15 DEC'22 GAS 1ST STREET GARAGE 209643 0505547424 DEC'22 6502 6423 NATURAL GAS WATER UTILITY EXPENSE 06500 08 204.69 DEC'22 GAS 1ST STREET GARAGE 209643 0505547424 DEC'22 6402 6423 NATURAL GAS STORM WATER UTILITY OPERA 06400 08 255.86 DEC'22 GAS 1ST STREET GARAGE 209643 0505547424 DEC'22 6202 6423 NATURAL GAS SEWER OPERATIONS EXPENSE 06200 08 272.92 DEC'22 GAS 1ST STREET GARAGE 209643 0505547424 DEC'22 1090 6423 NATURAL GAS PARK MAINTENANCE 01000 09 221.75 DEC'22 GAS 1ST STREET GARAGE 209643 0505547424 DEC'22 1072 6423 NATURAL GAS STREET MAINTENANCE 01000 08 2,169.34 DEC'22 GAS CMF 209649 0502362190 DEC'22 6502 6423 NATURAL GAS WATER UTILITY EXPENSE 06500 08 1,301.60 DEC'22 GAS CMF 209649 0502362190 DEC'22 6402 6423 NATURAL GAS STORM WATER UTILITY OPERA 06400 08 1,627.00 DEC'22 GAS CMF 209649 0502362190 DEC'22 6202 6423 NATURAL GAS SEWER OPERATIONS EXPENSE 06200 08 1,735.46 DEC'22 GAS CMF 209649 0502362190 DEC'22 1090 6423 NATURAL GAS PARK MAINTENANCE 01000 09 1,410.09 DEC'22 GAS CMF 209649 0502362190 DEC'22 1072 6423 NATURAL GAS STREET MAINTENANCE 01000 08 4,719.21 DEC'22 GAS ARENA 209650 0502346011 DEC'22 2502 6423 NATURAL GAS ICE ARENA OPERATIONS EXPE 02500 09 18,888.45 R55CKS2 LOGIS600V CITY OF FARMINGTON 1/30/2023 16:21:15 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 29 1/10/2023 - 1/31/2023 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 20230120 1/25/2023 109509 US BANK 225,000.00 FEB 1 2023 DS PMTS 209963 2023 DEBT SERVICE 3091 7110 DEBT PRINCIPAL 2013A GO IMP REFUNDING BO 03091 02 22,850.00 FEB 1 2023 DS PMTS 209963 2023 DEBT SERVICE 3091 7120 DEBT INTEREST 2013A GO IMP REFUNDING BO 03091 02 445,000.00 FEB 1 2023 DS PMTS 209963 2023 DEBT SERVICE 3094 7110 DEBT PRINCIPAL GO REFUNDING 2016A 03094 02 4,450.00 FEB 1 2023 DS PMTS 209963 2023 DEBT SERVICE 3094 7120 DEBT INTEREST GO REFUNDING 2016A 03094 02 545,000.00 FEB 1 2023 DS PMTS 209963 2023 DEBT SERVICE 3136 7110 DEBT PRINCIPAL GO CAP IMP PLAN REFUND 20 03136 02 46,475.00 FEB 1 2023 DS PMTS 209963 2023 DEBT SERVICE 3136 7120 DEBT INTEREST GO CAP IMP PLAN REFUND 20 03136 02 200,000.00 FEB 1 2023 DS PMTS 209963 2023 DEBT SERVICE 3138 7110 DEBT PRINCIPAL 2019A GO CAPITAL IMP BOND 03138 02 10,250.00 FEB 1 2023 DS PMTS 209963 2023 DEBT SERVICE 3138 7120 DEBT INTEREST 2019A GO CAPITAL IMP BOND 03138 02 210,000.00 FEB 1 2023 DS PMTS 209963 2023 DEBT SERVICE 3139 7110 DEBT PRINCIPAL 2020A FIRE EQUIP CERTIFIC 03139 02 22,625.00 FEB 1 2023 DS PMTS 209963 2023 DEBT SERVICE 3139 7120 DEBT INTEREST 2020A FIRE EQUIP CERTIFIC 03139 02 91,737.51 FEB 1 2023 DS PMTS 209963 2023 DEBT SERVICE 3141 7120 DEBT INTEREST 2022A GO Bonds 03141 02 65,000.00 FEB 1 2023 DS PMTS 209963 2023 DEBT SERVICE 6500 2505 BONDS PAYABLE-CURRENT WATER UTILITY 06500 08 12,400.00 FEB 1 2023 DS PMTS 209963 2023 DEBT SERVICE 6502 7120 DEBT INTEREST WATER UTILITY EXPENSE 06500 08 1,900,787.51 20230121 1/25/2023 100394 XCEL ENERGY 1,172.09 DEC'22 ELEC-DT LIQ STORE 209147 51-0013680782 6110 6422 ELECTRIC DOWNTOWN LIQUOR REV&EXP 06100 02 DEC'22 1,172.09 20230122 1/26/2023 108980 MINNESOTA ENERGY RESOURCES CORPORATION 954.71 DEC'22 GAS PK LIQ STORE 209416 0507026961 DEC'22 6115 6423 NATURAL GAS PILOT KNOB LIQUOR 06100 02 954.71 20230123 1/27/2023 100135 PUBLIC EMPLOYEES RETIREMENT ASSN. 25,930.19 209938 012623822251 7000 2113 PERA PAYABLE EMPLOYEE EXPENSE FUND 07000 02 34,403.68 209939 012623822252 7000 6154 PERA EMPLOYEE EXPENSE FUND 07000 02 60,333.87 Report Totals 3,001,874.88 APPROVALS: -&H OYT LI€RNATZ LIEN ALRTE>___ CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 I� O Farmington MN.gov TO: Mayor, Councilmembers and City Administrator FROM: Chris Regis, Finance Director SUBJECT: 2023 Budget Amendment- Finance DATE: February 6, 2023 INTRODUCTION Staff is requesting as budget amendment to the 2023 General Fund budget. DISCUSSION n reviewing staffing and position responsibilities it was determined to reclass two staff members from their present budget locations. At the present time the Administrative Support Technician (Front Desk) is budgeted in the Building Inspections budget and the Administrative Assistant—Engineering is budgeted in the Engineering Services budget. Staff requests that the Administrative Support Technician be reclassified into the Engineering Services budget and the Administrative Assistant—Engineering be reclassified into the Building Inspections budget. BUDGET IMPACT The net effect of the reclassification is an increase in the Building I nspections budget of$48,154.30 and a decrease in the Engineering Services budget of$48,154.30 for zero impact to the 2023 General Fund budget. ACTION REQUESTED Approve the attached resolution for the requested budget amendment to the 2023 General Fund budget. ATTACHMENTS: Type Description D Resolution 2023 Budget Amendment Resolution i RESOLUTION NO. R10-23 APPROVING 2023 BUDGET AMENDMENT Pursuant to due call and notice thereof, a regular meeting of the City Council of the City of Farmington, Minnesota,was held in the council chambers of said City on the 6th day of February 2023 at 7:00 p.m. Members Present: Hoyt, Bernatz, Lien, Porter,Wilson Members Absent: None Member Bernatz and Member Lien introduced and seconded the following: WHEREAS, Resolution R86-22 appropriated funds for personal services,other services and charges, supplies and capital outlays for each department of the city for the year 2023; and, WHEREAS,the City Administrator has requested an amendment of the 2023 budget appropriations in accordance with city policy; and, NOW,THEREFORE, BE IT RESOLVED that after due consideration, the Mayor and City Council of the City of Farmington, Minnesota, hereby amend the 2023 General Fund budget as follows: Summary Increase in Budgeted Expenditures Building Inspections Division $48,154.30 Total $48,154.30 Decrease in Budget Expenditures Engineering Services Division $48,154.30 Total $48,154.30 Net Change to General Fund -0- This resolution adopted by recorded vote of the Farmington City Council in open session on the 6th day of February 2023. M or Attested to the 6'�-h day of February 2023. City Ac6inistrator SEAL CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 �I O Farmington M N.gov II�IIIMIIIII TO: Mayor, Councilmembers and City Administrator FROM: Justin Elvestad, Fire Chief SUBJECT: Approve Out of State Travel to Attend Fire Department I nstructors Conference-Fire DATE: February 6, 2023 INTRODUCTION A request to send fire department personnel to out of state training in accordance with City of Farmington policy. DISCUSSION The Fire Department Instructors Conference (FDIC) is the largest fire service training and trade show event in the United States and will be held in Indianapolis, Indiana April 24-29, 2023. World class instructors will provide classroom and hands on training opportunities throughout the week. In addition, every kind of new technology in the fire and emergency medical services field will be displayed during the trade show with access to the inventors, engineers, manufacturers and sales representatives of products we utilize day in and day out. Chief Elvestad, Captain Scott Mattingly and Lieutenant Steven Endres, have requested to attend this conference pursuant to city policy. BUDGET IMPACT Registration fees, hotels, and travel expenses are not expected to exceed$2,600 per person. These expenses are included in the 2023 training budget. ACTION REQUESTED Approve the request to send Justin Elvestad, Scott Mattingly and Steven Endres to the Fire Department Instructors Conference(FDIC) April 2023 and reimburse expenses according to city policy. CITY OF 0 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 ri Farmington MN.gov TO: Mayor, Councilmembers and City Administrator FROM: Justin Elvestad, Fire Chief SUBJECT: Adopt Resolution Declaring Surplus Property-Fire DATE: February 6, 2023 INTRODUCTION The Farmington Fire Department(FFD)staff has determined certain items to no longer be suitable for use due to age and wear and tear. DISCUSSION Attached is a list of items that have been identified, and determined to no longer be useful for FFD purposes. BUDGET IMPACT None ACTION REQUESTED Adopt a resolution declaring this property as surplus and authorize the sale at auction, any items not sold at auction will be donated or disposed of. ATTACHMENTS: Type Description D Resolution Resolution D Backup Material Surplus List i i RESOLUTION NO. R11-23 I i DECLARING SURPLUS PROPERTY I Pursuant to due call and notice thereof, a regular meeting of the City Council of the City of Farmington, Minnesota,was held in the council chambers of said city on the 61h day of February 2023 at 7:00 p.m. Members Present: Hoyt, Bernatz, Lien, Porter,Wilson Members Absent; None Member Bernatz and Member Lien introduced and seconded the following: WHEREAS,the Farmington Fire Department has recommended that miscellaneous items in various states of disrepair be declared surplus; and, WHEREAS,the City of Farmington seeks to follow recognized standards for the safety of firefighting personnel. NOW,THEREFORE, BE IT RESOLVED that, after due consideration, the Mayor and City Council of the City of Farmington, Minnesota, hereby declares the attached list as surplus equipment and authorizes the disposal of and/or auction of said equipment This resolution adopted by recorded vote of the Farmington City Council in open session on the 6th day of February 2023. yor Attested to the 4t, day of February 2023. AI City Adriphistrator SEAL • Craftsman toolbox(lower cabinet and upper chest) • (4)Yellow emergency blankets • KED back board • Hatchet • Green 02 Bag • HazMat leak plug kit • Centaur hydraulic hose • (5)Sperian Multi-pro gas monitors • Akron low level strainer • Unifier Positive Pressure Ventilation Fan,w/Honda GX160 gas engine • Quickstep folding ladder • (2)Small Craftsman toolboxes (1-grey, 1-red) • 24v DeWalt battery charger • Angus 5"Storz to(3) 2%' manifold • Neon door markers • Foam nozzle adapter • SuperVac P164SE Extractor fan and door hanger • 12" Bolt cutter • Guardian 20ton bottle jack • Misc. playpipe handles • Stack-on toolbox w/misc.tools • Fire extinguisher bracket • 36" Boston bolt cutter • Craftsman pipe wrench • Misc. non-sparking tools • (2) crow bars • Ladder belt • Receiver hitch • (2) Milwaukee Sawzall Cases • Piercing nozzle • 6' pike pole • 3' pike pole • (4)flathead shovels • Spade shovel • (2)scoop shovels • (4) Halligan tools • Push broom • (2) Pick head axes • Tine fork • Misc. Broom handles • 15'of Forestry hose • Misc. buckets • (2)Genesis Hydraulic tool mounts • Amrox 4-ton porta power • (77)Scott SCBA masks • (46)Scott voice amplifiers • (12) Maglite flashlights • (2)Streamlight flashlights • Luxfer TC-3FCM-153 SCBA bottle • DeWalt%" corded drill • Small storage bin w/drawers • %" drive rachet set • 3/8"drive rachet set • Load distribution receiver hitch w/2 5/16" ball • (2) Holmatro 16' hydraulic hoses • (2) Holmatro 32' hydraulic hoses • Holmatro 4240 hydraulic spreader 424001202 • Holmatro 4350 hydraulic telescoping ram 435003274 • Holmatro 405ONCT hydraulic cutter 405ONCT03452 • (29)Safety vests • Justrite Type 1 Fuel safety can, 5 gallons • Zee first aid cabinet • Jumper cables • Air hose • Misc. extension cords • Turtle wax buffer • (2) ResQtec NT4 air bags w/inflation kit(Pelican case) • Scott RIT bag(blue) • (4)Steel SCBA bottles • (2) Back boards • (6) Collapsible traffic cones • SKIED Stretcher • 6lbs Sledgehammer(short handle) • (2) Level A Hazmat suits • (2) Hazmat boots • (14)Wooden 8'tables • (40) Brown Chairs CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 I � ® FarmingtonMN.gov TO: Mayor, Councilmembers and City Administrator FROM: Kellee Omlid, Parks and Recreation Director SUBJECT: Approve Agreement for Portable Toilet Services—Parks and Recreation DATE: February 6, 2023 INTRODUCTION The City of Farmington (the City) utilizes portable toilets rather than full restroom facilities in many of the city parks. I n 2018,the City entered into a five-year agreement with Biff's I nc.to provide contracted services for portable toilets to be placed in various city parks and the subsequent cleaning of the units. Specifically,the portable toilets had to be handicap accessible and comply with the Americans with Disabilities Act(ADA) before they could be placed in city parks.The current agreement expires on March 31, 2023. DISCUSSION Staff mailed a Request for Quotes (RFQ)to thirteen (13) portable toilet vendors. Quotes were solicited based on a per unit monthly charge for units compliant with the ADA. The RFQ primarily requested a price for ADA units to be annually provided over a five-year period beginning on April 1, 2023 and ending on March 31, 2028.The RFQ can be found as an attachment in the proposed agreement. Three vendors submitted quotes to the City. A tabulation of the quotes submitted is attached. Rent-N- Save Portable Services from Faribault, Minnesota submitted the low quote for an ADA unit at an average annual cost of$160.00 per unit over the five-year contract.The previous five-year contract had an annual average cost of$155.00 per unit over the five-year contract. Attached is an agreement with Rent-N-Save Portable Services to provide ADA portable toilet units in parks beginning April 1, 2023 and ending March 31, 2028. The city attorney reviewed the attached agreement and found it to be acceptable. BUDGET IMPACT Funding for the portable toilets will be through Rental of Equipment in the Parks Maintenance budget. Staff will schedule and place the appropriate number of portable units needed in parks where recreation programs, special events, and ballfield rentals happen.The proposed prices are to increase$5.00 per year per unit rented. Based on the price escalator proposed, staff will evaluate annually whether it may need to request additional funds in the 2024 to 2027 budgets depending on recreation program details and the number of parks used. ACTION REQUESTED Approve the attached agreement with Rent-N-Save Portable Services from Faribault, Minnesota to provide portable toilet services in parks beginning April 1, 2023 and ending March 31, 2028. ATTACHMENTS: Type Description D Backup Material 2023-2027 Portable Toilet Services Quote Tabulation D Backup Material Portable Toilet Services Agreement 2023-2027 Portable Toilet Quotes Tabulation Form Hand 2023 Price 2024 Price 2025 Price 2026 Price 2027 Price 5 Year Sanitizer Non-ADA Company Name ADA Unit ADA Unit ADA Unit ADA Unit ADA Unit Avera a Cost Unit Additional Cost Per Unit Emergency Trip Rent-N-Save $150.00 $155.00 $160.00 $165.00 $170.00 $160.00 Included $95.00 $80 regular/$140 ADA $25 per unit/$75 minimum per trip $35 weekday/$45 weekend per Biffs,Inc. $185.00 $185.00 $185.00 $185.00 $185.00 $185.00 Included $90.00 $90 regular/$185 ADA unit Porta Potty Dogs 1 $339.00 1 $339.00 1 $369.00 1 $369.00 1 $399.00 1 $363.00 $30.00 1 $239.00 1 "Variable" $200-$500 AGREEMENT THIS AGREEMENT is made this ba'day of February,2023,by and between Rent-N-Save Portable Services,a Minnesota corporation, ("the Contractor") and the City of Farmington,a Minnesota municipal corporation(the"City") (collectively referred to as the"Parties"). WHEREAS, the City has in the past utilized contracted portable toilet services in its parks; and, WHEREAS, quotes were solicited from thirteen contractors to provide portable toilet services; and, WHEREAS, Rent-N-Save Portable Services submitted the low overall annual quote for a per unit per month charge for ADA units over a five-year time period;and, WHEREAS, Rent-N-Save Portable Services will provide contracted portable toilet services including portable toilets (units)that are accessible to people with disabilities and the cleaning and servicing of these units. CONTRACT DOCUMENTS. The following documents shall be referred to as the "Contract Documents",all of which shall be taken together as a whole as the contract between the parties as if they were set verbatim and in full herein: A. This Agreement B. Contractor Proposal attached as Attachment"A." C. Solicitation of Quotes 2023 Portable Toilet Services,attached as Attachment"B". In the event of conflict among the provisions of the Contract Documents,the order in which they are listed above shall control in resolving any such conflicts with Contract Document "A" having priority and Contract Document"C" having the last priority. NOW,THEREFORE,in consideration of the promises contained herein,the Parties hereby agree as follows: 1. TERMS OF AGREEMENT. A. Except as otherwise specifically provided herein,the Contractor shall provide units in park locations identified by Parks and Recreation staff. B. This Agreement shall run for a period of five years beginning at 12:01 a.m. on April 1, 2023 and shall end on 12:00 Midnight on March 31,2028. C. The terms of this Agreement do not bind the Parties to the leasing of units by private organizations or groups for non-city organized events or activities that are on city park property. D. The Contractor shall invoice the City monthly for services rendered the previous month and based on the proposed amounts attached as Exhibit A. E. If this Agreement is ever terminated prior to the end date of this Agreement,the Page 1 of 5 Contractor shall remove the units within 48 hours of the date that this Agreement is terminated. If the Contractor fails to remove the units from city property within seven calendar days of the termination of this Agreement,the City reserves the right to relocate the units to other city property. F. Both Parties agree no surrounds(enclosures around the units)will be provided by the City. However,the City has a number of parks that have wooden walls the units will be anchored to. 2. CONTRACTOR OBLIGATIONS. A. The Contractor shall provide units that are in good and workable condition. B. Units shall be provided that meet any code or law(including the American with Disabilities Act)requirements and if any permit(s)or License(s)are ever required,then the Contractor agrees to provide a copy of said permit(s)or license(s)to the City. C. The upkeep,maintenance,and repair of all units shall be the responsibility of the Contractor. D. The Contractor agrees to clean,repair,and/or replace units at its own expense that are vandalized. E. Cleaning/servicing of units shall be provided on a once-a-week basis. F. The Contractor shall remove all units within 24 hours identified by the City to be removed after being contacted by city staff. 3. CITY'S OBLIGATIONS. A. The City shall provide a map identifying the locations for the placement of the units in parks. B. The City shall contact the Contractor about the moving or removing of any units. C. The City shall be responsible for contacting the Contractor within 24 hours of any vandalism that occurs to any unit. D. Payment to the Contractor shall be made within 30 days of when invoice was received. 4. ASSIGNMENT. Neither party may assign, sublet, or transfer any interest or obligation in this Contract without the prior written consent of the other party, and then only upon such terms and conditions as both parties may agree to and set forth in writing. 5. INSURANCE REQUIREMENTS A. WORKER'S COMPENSATION. The Contractor must provide Worker's Compensation Insurance for all its employees in accordance with the statutory requirements of the State of Minnesota. The Contractor shall also provide Employer's Liability Insurance with minimum limits as follows: • $500,000-Bodily Injury by Disease per employee • $500,000-Bodily Injury by Disease aggregate • $500,000-Bodily Injury by Accident B. COMMERCIAL GENERAL LIABILITY INSURANCE. Page 2 of 5 The Contractor is required to maintain Commercial General Liability Insurance protecting it from claims for damages for bodily injury,including death,and from claims for property damage,which may arise from operations under the contract. Insurance minimum limits are as follows: • $2,000,000—per occurrence • $2,000,000—annual aggregate • $2,000,000—annual aggregate—Products/Complete Operations The following coverages shall be included: • Premises and Operation Bodily Injury and Property Damage • Personal and Advertising Injury • Blanket Contractual Liability • Products and Completed Operations Liability The City, including its elected and appointed officials,employees,and agents must be endorsed as an Additional Insured using ISO Form CG 20 10 or equivalent for Ongoing Operations and ISO Form CG 20 37 or equivalent for Products/Completed Operations. C. BUSINESS AUTOMOBILE LIABILITY INSURANCE. The Contractor is required to maintain Business Automobile Liability Insurance protecting it from claims for damages for bodily injury, including death, and from claims for property damage resulting from the ownership, operation, maintenance,or use of all autos which may arise from operations under the contract. Insurance minimum limits are as follows: • $2,000,000—per occurrence Combined Single Limit for Bodily Injury and Property Damage • The following coverages shall be included: Owned,Hired, and Non-owned Automobiles D. ADDITIONAL INSURANCE CONDITIONS. • The Contractor's policies shall be primary insurance and non-contributory to any other valid and collectible insurance available to the City with respect to any claim arising out of the Contractor's performance under the contract. • An Umbrella or Excess Liability insurance policy may be used to supplement the Contractor's policy limits to satisfy the full policy limits required by the contract. The City shall be named as an additional insured on any umbrella or excess liability policy. • Any insurance limits in excess of the minimum limits shall be available to the City. • The Contractor is required to submit a Certificate of Insurance acceptable to the City as evidence of the required insurance coverage requirements. • The Contractor's policies and Certificate of Insurance shall contain a provision that coverage afforded under the policies shall not be cancelled without at least thirty(30) days' advanced written notice to the City, or ten(10)days' written notice for non- payment of premium. Page 3 of 5 • The Contractor shall require all subcontractors to meet the same insurance requirements and is responsible to review and ensure all subcontractors comply with the insurance provisions contained herein. • The City's failure to approve or disapprove the contractor's policies or certificates shall not relieve the Contractor of full responsibility to maintain the required insurance. • No representation is made that the minimum insurance requirements are sufficient to cover the obligations of the Contractor under the contract. 9.MINNESOTA GOVERNMENT DATA PRACTICES ACT. Contractor must comply with the Minnesota Government Data Practices Act, Minnesota Statutes Chapter 13,as it applies to(1)all data provided by the City pursuant to this Agreement,and(2)all data,created,collected,received, stored,used,maintained,or disseminated by Contractor pursuant to this Agreement. Contractor is subject to all the provisions of the Minnesota Government Data Practices Act, including but not limited to the civil remedies of Minnesota Statutes Section 13.08, as if it were a government entity. In the event Contractor receives a request to release data, Contractor must immediately notify City. City will give Contractor instructions concerning the release of the data to the requesting party before the data is released. Contractor agrees to defend, indemnify, and hold City, its officials, officers, agents, employees, and volunteers harmless from any claims resulting from Contractor's officers',agents',city's,partners',employees',volunteers', assignees' or subcontractors' unlawful disclosure and/or use of protected data. The terms of this paragraph shall survive the cancellation or termination of this Agreement. 10. NONDISCRIMINATION. All Contractors and subcontractors employed shall comply with all applicable provisions of all federal, state and municipal laws which prohibit discrimination in employment to members of a protected class and all rules and regulations, promulgated and adopted pursuant thereto. The Contractor will include a similar provision in all subcontracts entered into for the performance of this contract. 11.INDEMNITY. The Contractor agrees to defend, hold harmless, and indemnify the City, its officers, agents, and employees, for and against any and all claims, demands, actions, or causes of action, of whatever nature or character, arising from the Consultant's performance of work or services provided for herein. The Contractor shall take all reasonable precautions for the safety of all employees on the site and shall provide reasonable protection to prevent damage or loss to the property on the site or properties adjacent thereto and to work, materials and equipment under the Contractor's control. 12.WAIVER. In the particular event that either party shall at any time or times waive any breach of this Contract by the other, such waiver shall not constitute a waiver of any other or any succeeding breach of this Contract by either party,whether of the same or any other covenant,condition,or obligation. 13.GOVERNING LAW. The laws of the State of Minnesota govern the interpretation of this Contract. Page 4 of 5 14.SEVERABILITY. If any provision,term,or condition of this Contract is found to be or become unenforceable or invalid, it shall not effect the remaining provisions, terms, and conditions of this Contract, unless such invalid or unenforceable provision, term, or condition renders this Contract impossible to perform. Such remaining terms and conditions of the Contract shall continue in full force and effect and shall continue to operate as the parties'entire contract. 15.ENTIRE AGREEMENT. This Contract represents the entire agreement of the parties and is a final, complete, and all- inclusive statement of the terms thereof,and supersedes and terminates any prior agreement(s), understandings,or written or verbal representations made between the parties with respect thereto. 16.TERMINATION. This Agreement may be terminated by the City for any reason or for convenience upon written notice to the Contractor. In the event of termination, the City shall be obligated to the Contractor for payment of amounts due and owing for materials provided or for services performed or furnished to the date and time of termination. Dated: ' 2023 CITY OF FARMINGTON By: Jos Hoyt,May r By: Lynn Gorski, City Administrator Dated: ' �0 ' , 2023 CONTRACTOR: RENT-N-SAVE PORTABLE SERVICES By: z�ZjA&'l- — Its: Page 5 of 5 Attachment A Farmington Parks and Recreation Department's Portable Toilet Quote Submittal Form I. Contractor's Information The undersigned,being familiar with local conditions, having made the field inspections and investigations deemed necessary, having studied the specifications for the work and being familiar with all factors and other conditions affecting the work and costs thereof,herby propose to furnish all labor,tools,materials,skills, equipment,and all else necessary to complete the work in accordance with the specifications identified previously. Please provide in the space that follows,your company's information. I / Name of Company Submitting Quote: &r l`� Save ►-©rtoible, can Gey Contact Person: 416" Address: IJS 'a z Work Phone Number:'�o,��-� E- mail. Signature of Company Representative Submitting Quote: Date: �� _ II. Standard Quote Items 2023 Price per ADA unit: $ 150- 2024 5o2024 Price per ADA unit: $ l5-5_ 2025 Price per ADA unit: $ 1Wc 2026 Price per ADA unit: $ I' 6 2027 Price per ADA unit: $ 1 ?0 Ill. Additional Quote Items Nand sanitizer cost per unit: $ ti G Il �fiCU' Price per non-ADA unit: $ .. Cost of renting additional units for events: $ 80- 1,10AI AAA IV. Additional Information 140- AbA Describe the anchoring system: I ra rao Moo1A U&)l F,FCAM IODSi" C>A P('f l;' '1 irC - Ro-6�srirp o ver foo- � 'on hard t6 ! VyeC �3/ 1" 5 _ IMAIV inclless Y00,0YO Cost of Emergency Trip: NJ chop- Provide what day you anticipate the weekly cleaning: I a W j I would., +yPicatlty b ori a Toed weA or 1710r" Attachment B CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 FarmingtonMN.gov October 4, 2022 TO: Whom it May Concern RE: Solicitation of Quotes for Portable Toilet Service The Farmington Parks and Recreation Department would like to inform you it is accepting quotes for providing five (5)years of exclusive portable toilet service for the City of Farmington in its parks for the years 2023, 2024, 2025, 2026 and 2027.The contract will begin April 1, 2023 and end on March 31, 2028.The City is accepting quotes for Americans with Disabilities Act (ADA) compliant portable toilets as the primary quote in order to be compliant with ADA requirements.Toilets are required to be serviced once a week unless otherwise requested. Quotes for the ADA compliant units are required to be submitted in the following format: 1. Cost per ADA unit per month (cost should reflect the cost to service and clean each unit weekly, any delivery and pick up charges, and the cost to pump the unit weekly) 2. Insurance Requirements are as follows: The vendor's insurance company will waive its right to assert the immunity of the City as a defense to any claims made under said insurance. The vendor shall take out and maintain during the life of the contract, vendor's General Liability&Automobile Insurance, including vendor's Contingent or Protective Insurance to protect the vendor from damage claims arising for operations under this contract, which shall protect them and any subcontractor performing work covered by this contract,from claims for damages for personal injury including accidental death under this contract whether such operations by themselves or by any subcontractor or by anyone directly or indirectly employed by either of them and the amounts of the insured shall be as follows: A. Worker's Compensation Insurance The contractor must provide Worker's Compensation Insurance for all its employees in accordance with the statutory requirements of the State of Minnesota.The contractor shall also provide Employer's Liability Insurance with minimum limits as follows: $500,000- Bodily Injury by Disease per employee $500,000- Bodily Injury by Disease aggregate $500,000- Bodily Injury by Accident B. Commercial General Liability Insurance_ The contractor is required to maintain Commercial General Liability Insurance protecting it from claims for damages for bodily injury, including death, and from claims for property damage, which may arise from operations under the contract. Insurance minimum limits are as follows: $2,000,000—per occurrence $2,000,000—annual aggregate $2,000,000—annual aggregate—Products/Complete Operations The following coverages shall be included: Premises and Operation Bodily Injury and Property Damage Personal and Advertising Injury Blanket Contractual Liability Products and Completed Operations Liability The City, including its elected and appointed officials, employees, and agents must be endorsed as an Additional Insured using ISO Form CG 20 10 or equivalent for Ongoing Operations and ISO Form CG 20 37 or equivalent for Products/Completed Operations. C. Business Automobile Liability Insurance The contractor is required to maintain Business Automobile Liability Insurance protecting it from claims for damages for bodily injury, including death, and from claims for property damage resulting from the ownership, operation, maintenance, or use of all autos which may arise from operations under the contract. Insurance minimum limits are as follows: $2,000,000—per occurrence Combined Single Limit for Bodily Injury and Property Damage The following coverages shall be included: Owned, Hired, and Non-owned Automobiles D. Additional Insurance Conditions • The contractor's policies shall be primary insurance and non-contributory to any other valid and collectible insurance available to the city with respect to any claim arising out of the contractor's performance under the contract. • An Umbrella or Excess Liability insurance policy may be used to supplement the contractor's policy limits to satisfy the full policy limits required by the contract.The city shall be named as an additional insured on any umbrella or excess liability policy. • Any insurance limits in excess of the minimum limits shall be available to the city. • The contractor is required to submit a Certificate of Insurance acceptable to the city as evidence of the required insurance coverage requirements. • The contractor's policies and Certificate of Insurance shall contain a provision that coverage afforded under the policies shall not be cancelled without at least thirty(30) days' advanced written notice to the city, or ten (10) days' written notice for non-payment of premium. • The contractor shall require all subcontractors to meet the same insurance requirements and is responsible to review and ensure all subcontractors comply with the insurance provisions contained herein. • The city's failure to approve or disapprove the contractor's policies or certificates shall not relieve the contractor of full responsibility to maintain the required insurance. • No representation is made that the minimum insurance requirements are sufficient to cover the obligations of the contractor under the contract. 3. Describe how the units will be anchored. 4. Provide what day you anticipate the weekly cleaning of the portable toilets. 5. Show the cost for emergency service and/or extra trip. 6. Provide a quote on the cost per unit to rent additional units during special events. 7. Identify in each of the five years what your rate would be and clearly indicate if there would or wouldn't be a rate increase in years two through five of the contract. 8. Provide a quote per unit for portable toilets that do not meet ADA requirements. The following information about the rental time period, location, and number of ADA units should be taken into consideration when submitting your quote: Tentative Location General Dates Number of ADA Units Dakota Estates Park April 10—October 15 One Distad Park&Greenway December 10—February 20 One Evergreen Knoll Park May 1—October 1 One Farmington Preserve Park August 15—October 15 One Hill Dee Park April 10—October 15 One Lake Julia Park April 10—October 15 One Meadowview Park April 10—October 15 One Prairieview Park April 10—October 15 One Rambling River Park Feely Fields April 16—October 15 One, plus one regular Rambling River Park Shelter Site April 10—October 15 One Tamarack Park April 10—October 15 One The City of Farmington will not be held liable for any damages which occur to the portable toilets during the rental period. The deadline for submitting a proposal is on or before 10:00 a.m. on Monday, November 21, 2022. Failure to submit your proposal/quote by this deadline and on the attached quote submittal form will disqualify your company from consideration of providing the portable toilet service to the Farmington Parks and Recreation Department during this five-year time period. Quotes may be mailed or emailed to the following Parks and Recreation Department employee: Emilee Shearer, Recreation Supervisor City of Farmington 430 Third Street Farmington, MN 55024 Phone: 651-280-68541 Cell: 651-775-5942 Email: EShearer@FarmingtonMN.Rov The City reserves the right to reject any and/or all quotes submitted. Selection criteria will be based on adding each quote provided over the five years and then dividing by five to come up with the average annual cost.The company selected will be based on the lowest average annual cost per ADA unit over the five-year contract. Sincerely, Emilee Shearer Recreation Supervisor CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-280-6800 �IIII��III ® Farmington MN.gov TO: Mayor, Councilmembers and City Administrator FROM: Kellee Omlid, Parks and Recreation Director SUBJECT: Adopt Resolution Accepting Donation from Appliance ReNew to the Rambling River Center—Parks and Recreation DATE: February 6, 2023 INTRODUCTION Appliance ReNew recently gave a donation to the Rambling River Center. DISCUSSION Appliance ReNew recently gave a donation of two refrigerators to the Rambling River Center. This included a GE refrigerator valued at$500 and a Magic Chef refrigerator valued at$250. Two Farmington residents bought new refrigerators from Appliance ReNew, but their old ones were still in very good and working condition. Thus, Michael Rabon, Appliance ReNew,stopped by city hall to see if the Rambling River Center needed a new refrigerator(s). He said he was glad to give the refrigerators to a good organization. Staff will communicate the city's appreciation on behalf of the city council to Appliance ReNew for this generous donation. BUDGET IMPACT N/A ACTION REQUESTED Adopt the attached resolution accepting the donation of refrigerators valued at$750 from Appliance ReNew to the Rambling River Center. ATTACHMENTS: Type Description D Resolution Donation Resolution i I� RESOLUTION NO. R12-23 1 i ACCEPTING DONATION OF REFRIGERATORS FROM APPLIANCE RENEW TO THE RAMBLING RIVER CENTER Pursuant to due call and notice thereof, a regular meeting of the City Council of the City of Farmington, Minnesota, was held in the council chambers of said City on the fit'day of February 2023 at 7:00 p.m. Members Present: Hoyt, Bernatz, Lien, Porter,Wilson Members Absent: None Member Bernatz and Member Lien introduced and seconded the following: WHEREAS, a donation of refrigerators was made by Appliance ReNew to the Rambling River Center;and, WHEREAS, it Is required by State Statute that such donation be formally accepted; and, WHEREAS, it is in the best interest of the city to accept this donation. NOW,THEREFORE,BE IT RESOLVED that after due consideration,the Mayor and City Council of the City of Farmington, Minnesota, hereby accepts with gratitude the generous donation of two refrigerators valued at$750 from Appliance ReNew to the Rambling River Center. This resolution adopted by recorded vote of the Farmington City Council in open session on the Gth day of February 2023. M7(0 r �CGt Attested to the day of February 2023. City A inistrator SEAL CITYOF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-280-6800 OFarmingtonMN.gov TO: Mayor, Councilmembers and City Administrator FROM: Kellee Omlid, Parks and Recreation Director SUBJECT: Adopt Resolution Accepting Donation from Happy Harry's Furniture to the Rambling River Center- Parks and Recreation DATE: February 6, 2023 INTRODUCTION A donation was recently made to the Rambling River Center(RRC) by Happy Harry's Furniture. DISCUSSION A donation in the amount of$179.80 was recently made by Happy Harry's Furniture to the RRC. The donation was made through a program created in 2011 in which a customer of Happy Harry's Furniture can select a charity of their choice to receive a donation when merchandise is purchased from the store. Then 10%from the sale to the customer is donated to the charity. The RRC is one of the charities that can be selected by customers. With these donations, Happy Harry's Furniture has donated a total of$14,371.87 to the RRC since the program's inception.This partnership with Happy Harry's Furniture has been very beneficial over the long term given the funds that have been donated to the RRC. The donation has been deposited into the RRC Capital Improvement Fund to fund future building improvements and/or purchase new equipment and furniture. Staff will communicate the city's appreciation on behalf of the city council to Happy Harry's Furniture for their generous donation to the RRC. BUDGET IMPACT N/A ACTION REQUESTED Adopt the attached resolution accepting the donation of$179.80 from Happy Harry's Furniture to the RRC. ATTACHMENTS: Type Description D Resolution Donation Resolution RESOLUTION NO. R13-23 ACCEPTING DONATION OF$179.80 FROM HAPPY HARRY'S FURNITURE TO THE RAMBLING RIVER CENTER Pursuant to due call and notice thereof, a regular meeting of the City Council of the City of Farmington, Minnesota,was held in the council chambers of said City on the 6th day of February 2023 at 7:00 p.m. Members Present: Hoyt, Bernatz, Lien, Porter,Wilson Members Absent: None Member Bernatz and Member Lien introduced and seconded the following: WHEREAS, a donation of$179.80 was made by Happy Harry's Furniture to the Rambling River Center; and, WHEREAS, it Is required by State Statute that such donation be formally accepted;and, WHEREAS, it is in the best interest of the city to accept this donation. NOW,THEREFORE, BE IT RESOLVED that after due consideration,the Mayor and City Council of the City of Farmington, Minnesota, hereby accepts with gratitude the generous donation of $179.80 from Happy Harry's Furniture to the Rambling River Center. This resolution adopted by recorded vote of the Farmington City Council in open session on the 61h day of February 2023. Attested to the � day of February 2023. City A inistrator SEAL CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-280-6800 OFarmington MN.gov TO: Mayor, Councilmembers and City Administrator FROM: Chris Regis, Finance Director SUBJECT: 2022 Investment Review- Finance DATE: February 6, 2023 INTRODUCTION I n accordance with the city's investment policy,staff annually reviews the city's cash and investment portfolio with the city council. DISCUSSION As of December 31, 2022, the city had a combined cash and investment balance of$49.8 million. Of this amount,the city had invested$3.7 million in collateralized accounts and $46.1 million in a variety of investments with various financial institutions. One of the challenges to investing city funds is balancing the short-term cash flow needs of day to day operations with the needs to cash flow infrastructure projects and longer term needs such as semiannual debt service.At the same time the three primary objectives of the city's investment policy always must be considered in any investment purchases.These objectives in order of importance are safety, liquidity, and yield/return. The city has two buckets of funds to invest.The short-term funds that are in the city's most liquid accounts,checking and savings, and funds that are invested in longer terms to meet future cash flow needs and return higher yields. Short term yields earned varying rates of return during the year, ranging from .02 percent to 3.56 percent. This compares to 2021 when yields ranged from .02 percent to .50 percent. Funds that have been invested in longer terms have yields that range from .35 percent to 4.20 percent with maturities as short as less than a year to just short of five years as of December 31, 2022. The city purchases investments from a variety of financial institutions. As of December 31, 2022, the city had funds on deposit with Old National Bank, Castle Rock Bank, and investments with Oppenheimer& Co., and RBC Capital Markets. Where were the city's investments purchased? Castle Rock Old National 4%, Bank 3% ms`s, gar•` 4 Oppenheimer sb 50% RBC Capitalf-- z 4 Markets " a 43% , **rte •al As defined in Minnesota State Statute Section 118A.04 the city may invest in a variety of investment instruments. I n prior years, as rates decreased due to the pandemic, certificates of deposit(CD's) generally provided higher yields than comparable U.S. Treasury and Government Agency instruments. This was not unusual as CD rates typically lag in the market, staying higher while other instrument yields decline at a faster pace.Therefore, about 16%of the city's investments remain in CD's. However, with CD's, in order to maintain FDIC insurance there is a $250,000 per insured institution limit. As interest rates have increased over the past year, the yield for municipal bonds, government agencies and US Treasury Notes are providing yields that are now competitive with CD's. At year end municipal bonds make up 26% of the city's portfolio. I n addition,the portfolio has investments with government agencies (FNMA, FFCB, FHLB, FH LMC, TVA)that make up 22% and US Treasury Notes at 25%. Rounding out the city's portfolio are deposits with Old National Bank, Castle Rock Bank, and money market funds with Oppenheimer&Co., and RBC Capital Markets. Investments By Type (Market Value) Money Savings 7% Government Markets 4/ Agencies �y 22% Certificates of Deposit 16% Municipal Bonds US Treasuries 26% 25% The city's longest investment maturity as of December 31, 2022 is just short of five years. The maturity range for the portfolio are approximately 29%for less than one year and 71%for 1 to 5 years. The city ladders its investment maturities, so that each month an investment or investments matures to meet the cash flow needs of each month. Per the city's investment policy, no more than 30 percent of total investments can extend beyond 5 years and no investments can be purchased for beyond 15 years. Maturity Range Less than 1 Year 29% 1-5 years) 71% Mark-To-Market To provide a realistic measure of an entity's investment portfolio, accounting rules require the investment portfolio be adjusted to the current market value as of December 31 of each year.This will provide readers of the financial statements with an accurate picture of the liquidation value of an entity's investments as of the balance sheet date and provides a consistent method of measurement between different entities. It should be noted that the city purchases investments with the intention to hold until maturity. BUDGET IMPACT The city had an investment income budget of$290,900 for 2022. Actual investment income for the year, prior to any mark to market adjustments, was $680,107. This is an increase from the 2021 investment income of$491,628. When budgeting, callable investments are not taken into account as it is not known if the investment will be held for the entire year. At the end of 2022,the city had $3.46 million in callable investments.This is a decrease from 2021 when the value of callable investments was $3.8 million.The yield of the city's investment portfolio as of December 31, 2022 was 2.015 percent which is an increase from 1.014 percent in 2021. ACTION REQUESTED Receive the annual investment report and ask any questions you may have. ATTACHMENTS: Type Description ❑ Backup Material I nvestment Portfolio by Security Type City of Farmington Investment Portfolio-by Security Type As of 1213112022 Settlement YTM @ Face Maturity Days To Accrued %of Description CUSIP/Ticker Date Cost Amount/Shares Cost Value Book Value Market Value Date Maturity Interest Portfolio FFCB Bond FFCB 0.12 1/12/2023 13133EMML3 12/28/2021 0.350 675,000.00 673,393.50 674,949.27 674,291.25 1/12/2023 12 380.25 1.29 FFCB 0.125 2/3/2023 3133EMPH9 12/28/2021 0.370 1,000,000.00 997,320.00 999,773.33 996,300.00 2/3/2023 34 513.89 1.92 FFCB 0.125 5/10/2023 3133EMYX4 1/24/2022 0.738 800,000.00 793,688.00 798,257.83 787,840.00 5/10/2023 130 141.67 1.53 FFCB 0.875 11/18/2024 3133ENEJ5 7/21/2022 3.101 500,000.00 475,225.00 479,970.39 468,215.00 11/18/2024 688 522.57 0.96 Sub Total/Average FFCB Bond 0.923 2,975,000.00 2,939,626.50 2,952,950.82 2,926,646.25 165 1,558.38 5.70 FHLB Bond FHLB 0.5 1/24/2023 3130AQQ71 1/24/2022 0.557 1,000,000.00 999,430.00 999,962.52 997,410.00 1/24/2023 24 2,180.56 1.92 FHLB 0.64 1/27/2025 3130AN5P1 7/29/2022 2.835 700,000.00 663,250.00 669,489.05 646,366.00 1/27/2025 758 1,891.56 1.34 FHLB 1.01 7/28/2025 3130APL52 12/15/2022 4.121 800,000.00 738,800.00 739,824.27 732,072.00 7/28/2025 940 359.11 1.53 FHLB 2.23 3/28/2025-22 3130ARDA6 10/7/2022 4.200 600,000.00 572,484.00 575,074.10 568,830.00 3/28/2025 818 3,122.00 1.15 FHLB 2.5 12/8/2023 3130AAHEl 6/28/2022 2.920 500,000.00 497,D45.00 498,085.97 489,005.00 12/8/2023 342 798.61 0.96 Sub Total/Average FHLB Bond 2.728 3,600,000.00 3,471,009.00 3,482,435.91 3,433,683.00 547 8,351.84 6.90 FHLMC Bond FHLMC 3.375 6/30/2025 13134GXXA7 12/15/20221 4.171 710,000.001 696,510.00 696,742.591 690,886.80 6/30/20251 912 0.001 1.36 Sub Total/Average FHLMC Bond 1 4.1711 710,000.001 696,510.001 696,742.591 690,886.801 1 9121 0.001 1.36 FNMA Bond Fannie Mae 0.65 11/23/2026-22 3135GA3J8 11/23/2020 0.650 300,000.00 300,000.00 300,000.00 260,586.00 11/23/2026 1,423 205.83 0.58 FNMA 0.25 7/10/2023 3135GO5G4 2/4/2022 0.920 500,000.00 495,240.00 498,254.97 488,275.00 7/10/2023 191 593.75 0.96 FNMA 0.511/7/2025 3135GO6G3 11/13/2020 0.500 300,000.00 300,000.00 300,000.00 270,033.00 11(7/2025 1,042 225.00 0.58 FNMA 0.75 10/8/2027 3135GO5Y5 11/13/2020 0.750 300,000.00 300,000.00 300,000.00 258,849.00 10/8/2027 1,742 518.75 0.58 FNMA 1.625 1/7/2025 3135GOX24 7/29/2022 2.818 1,000,000.00 972,080.00 976,926.14 945,440.00 1/7/2025 738 6,861.11 1.92 FNMA 1.625 10/15/2024 3135GOW66 7/21/2022 3.082 900,000.00 871,929.00 877,529.46 855,423.00 10/15/2024 654 3,087.50 1.73 Sub Total/Average FNMA Bond 2.006 3,300,000.00 3,239,249.00 3,252,710.57 3,078,606.00 813 11,491.94 6.33 Money Market Castle Rock Bank MM MM3201CRB 6/4/2020 1.000 2,078,727.59 2,078,727.59 2,078,727.59 2,078,727.59 N/A 1 3.99 Old National Bank MM MM010BONB 9/30/2014 3.560 1,580,827.53 1,580,827.53 1,580,827.53 1,580,827.53 N/A 1 3.03 Oppenheimer MM 608919718 8/12/2022 3.520 1,006,757.97 1,006,757.97 1,006,757.97 1,006,757.97 N/A 1 1.93 RBC Capital Markets MM 74926P654 11/8/2021 2.9501 1,069,512.02 1,069,512.02 1,069,512.02 1,069,512.02 N/A 1 2.05 Sub Total/Average Money Market 2.5111 5,735,825.11 5,735,825.11 5,735,825.11 5,735,825.11 1 0.00 11.00 Municipal Bond Anchor Bay Mich Sch Dist 1.25 5/1/2026 D32879UVB 7/16/2020 1.120 400,000.00 402,904.00 401,671.00 355,472.00 5/1/2026 1,217 833.33 0.77 Anchor Bay Mich Sch Dist 1.4 5/1/2027 032879UX4 7/16/2020 1.320 400,000.00 402,068.00 401,319.18 345,252.00 5/1/2027 1,582 933.33 0.77 Bensalem Twp PA Sch Dist 1.735 12/15/2027 082383QH6 12/15/2020 1.438 160,000.00 163,153.60 162,233.18 141,344.00 12/15/2027 1,810 1,048.71 0.31 Brainerd Minnlndpt Sch Dist4 2/1/2023 105007NP9 12/6/2018 3.079 200,000.00 207,114.00 200,149.97 199,924.00 2/1/2023 32 3,333.33 0.38 Brewton Ala 1.612/1/2026 107781ND4 11/5/2020 1.350 160,000.00 162,323.20 161,499.55 141,896.00 12/1/2026 1,431 213.33 0.31 Central Marin Police Auth Cali 1.115 2/1/2026 154070AE6 5/25/2021 0.900 250,000.00 252,457.50 251,618.25 222,662.50 2/1/2026 1,128 1,161.46 0.48 Cook Cnty III Cmnty College 1 6/1/2025 216057FD6 12/30/2020 0.650 200,000.00 203,044.00 201,665.34 183,306.00 6/1/2D25 883 166.67 0.38 Cook Cnty III Sch Dist No 101 3 12/1/2027 214417KN6 1/15/2021 1.000 380,000.00 430,388.00 416,040.16 343,736.60 12/1/2027 1,796 950.00 0.73 Crook Cnty Ore Sch Dist 1.734 6/15/2024 227183DJ6 5!7/2020 1.250 250,000.00 254,825.00 251,711.27 239,952.50 6/15/2024 532 192.67 0.48 Cupertino Calif Un Sch Dist 1.168 8/1/2026 231237R34 3/19/2021 1.020 105,000.00 105,808.50 105,539.69 92,514.45 8/1/2026 1,309 511.DO 0.20 Daphne Ala l7/1/2024 237019KN3 10/28/2020 0.800 300,000.00 302,166.00 300,884.48 284,748.00 7/1/2D24 548 1,5DO.00 0.58 Duluth Minn Indpt Sch Dist 4 2/1/2025 264471KU6 11/13/2020 0.751 200,000.00 226,926.00 213,331.95 203,800.00 2/1/2025 763 3,333.33 0.38 East Windsor NJ Re I Sch 0.761 3/1/2024 276029LR4 2/24/2021 0.350 200,000.00 202,466.00 200,954.15 191,424.00 3/1/2024 426 507.33 D.38 Ecorse Mich Pub Sch Dist 2.092 5/1/2025 279196CW7 5/5/2020 1.300 400,DDO.00 415,252.00 407,132.11 376,868.00 5/1/2025 852 1,394.67 0.77 EI Cajon Calif 1.1794/1/2025 282659AX9 2/22/2021 0.800 150,000.00 152,292.00 151,256.85 137,950.50 4/1/2025 822 442.12 0.29 FLA Wtr Pollution Ctl Fing 2.15 1/15/2025 343246ENO 1/16/2020 1.950 400,000.00 403,788.00 401,547.56 379,256.00 1/15/2025 746 3,965.56 0.77 Fort Lee NJ Brd EdO.854 12/1/2023 347712ET4 10/22/2020 0.520 300,000.00 303,084.00 300,910.26 290,178.00 12/1/2023 335 213.50 0.58 Hermantown Minn Indpt Sch 1.289 2/1/2027 427506JP6 7/27/2020 1.050 300,000.00 304,500.00 302,822.90 261,360.00 2/1/2027 1,493 1,611.25 0.58 Hocking Tech College Ohio 1.672 7/1/2026 434159AW9 12/17/2020 1.330 285,000.00 290,187.00 288,278.43 250,942.50 7/1/2D26 1,278 2,362.60 0.55 Kittitas Cnty Wash Sch Dist 1.98 12/1/2025 498278DT4 5/27/2020 1.250 240,000.00 249,300.00 244,922.44 221,776.80 12/1/2025 1,066 396.00 0.46 City of Farmington Investment Portfolio-by Security Type As of 12/31/2022 Settlement YTM @ Face Maturity Days To Accrued %of Description CUSIP/Ticker Date Cost Amount/Shares Cost Value Book Value Market Value Date Maturity Interest Portfolio Lee&Dekalb Cntys 1113.9 2/1/2026-24 523351CJ1 11/6/2020 1.973 350,000.00 383,411.00 369,700.79 340,424.00 2/1/2026 1,128 5,687.50 0.67 Manhattan Beach Calif Pension 1.569 1/1/2027 562784AG3 5/12/2021 1.150 325,000.00 332,406.75 330,256.64 284,602.50 1/1/2027 1,462 2,549.62 0.62 Massachusetts State RevenueBonds 3.66 1/15/2025 576004GY5 8/30/2022 3.353 1,000,000.00 1,006,990.00 1,006,000.62 981,530.00 1/15/2025 746 12,200.00 1.92 Middlesex Cnty NJ 1.07 1/15/2026 59656NM74 12/31/2020 0.721 150,000.00 152,593.50 151,565.12 135,232.50 1/15/2026 1,111 740.08 0.29 Mississippi St Taxable GO 0.715 11/1/2025-21 605581 NAI 3/3/2021 0.715 300,000.00 300,000.00 300,000.00 269,010.00 11/1/2025 1,036 357.50 0.58 New York NT City Trans 2.718/1/2023 64971QW1-3 12/11/2018 3.221 400,000.00 391,264.00 398,901.55 395,764.00 8/1/2023 213 4,516.67 0.77 New York NY City Transitional 0.66 2/1/2025 64971XWU8 3/26/2021 0.800 110,000.00 109,417.00 109,684.07 100,758.90 2/1/2025 763 302.50 0.21 New York NY City Transitional 3.43 8/1/2026 64971XEKO 7/22/2020 1.070 225,000.00 255,901.50 243,378.04 212,649.75 8/1/2026 1,309 3,215.63 0.43 New York,NY 0.31 8/1/2023 64966QWT3 12/30/2021 0.601 750,000.00 746,565.00 748,736.35 732,465.00 8/1/2023 213 968.75 1.44 Ohio St Higher Ed14.249 1/1/2025 67756A2SO 3/8/2021 0.701 125,000.00 141,665.00 133,744.65 123,255.00 1/1/2D25 732 2,655.62 0.24 Oregon Cmnty College Dists 5.66 6/30/2024 68583RCT7 2/4/2021 0.450 200,000.00 235,174.00 215,491.29 202,700.00 6/30/2024 547 0.00 0.38 Osseo Minn Indpt Sch Dist 279 3 4/1/2024-21 688445BD6 2/18/2021 0.400 340,000.00 367,373.40 350,992.66 340,411.40 4/1/2024 457 2,550.00 0.65 Fender Cnty NC LTD Oblig 1.43 6/1/2026 706716CR6 10/29/2020 1.2001 135,000.00 136,672.65 136,022.77 119,634.30 6/1/2026 1,2481 160.88 0.26 Pierce Cnty Wash Sch Dist 0.693 12/1/2024 720424ZS2 9/3/2020 0.570 100,000.00 100,514.00 100,232.46 93,099.00 12/1/2024 701 57.75 0.19 Pinal Cnty Ariz Rev Obligs 0.795 8/1/2023 72205RFE7 12/7/2021 0.540 750,000.00 753,135.00 751,109.23 734,670.00 8/1/2023 213 2,484.38 1.44 Pomona Calif Pension Obli 0 7/1/2023 73208PAV3 11/7/2019 2.111 380,000.00 351,971.20 376,170.24 370,306.20 7/1/2023 182 0.00 0.73 Potterville Mich Pub Schs 2.05 5/1/2027 73817OGFO 9/10/2020 0.960 160,000.00 171,193.60 167,305.39 142,956.80 5/1/2027 1,582 546.67 0.31 Potterville Mich Pub Schs 2.15 5/1/2026 738170GE3 9/10/2020 0.800 160,000.00 171,889.60 167,027.51 147,310.40 5/1/2026 1,217 573.33 0.31 Potterville Mich Pub Schs 2.35 5/1/2025 73817OGD5 9/10/2020 0.700 175,000.00 188,163.50 181,620.60 165,980.50 5/1/2025 852 685.42 0.34 Rancho Santiago Calif Cmnty CO 0.734 9/1/2025 752147HJO 1077/2020 0.680 150,000.00 150,388.50 150,211.61 135,193.50 9/1/2025 975 367.00 0.29 Rio Calif Elem Sch Dist 1.375 8/1/2027 767032JCO 9/30/2020 1.050 240,000.00 245,131.20 243,441.36 205,497.60 8/1/2027 1,674 1,375.00 0.46 San Bernardino Calif City LIN 1.411 8/1/2026 796711F38 9/24/2020 1.080 400,000.00 407,488.00 404,586.71 355,348.00 8/1/2026 1,309 2,351.67 0.77 Sonoma Cnty Calif Jr College 2.447 8/1/2026 835569GT5 6/2/2020 1.200 430,000.00 461,759.BD 448,468.94 398,059.60 6/1/2026 1,309 4,384.21 0.82 Texas Pub Fin Auth 1.076 2/1/2027 882669BV5 12/31/2020 0.861 500,000.00 506,385.00 504,288.26 426,855.00 2/1/2027 1,493 2,241.67 0.96 University Pittsburgh PA 2.877 9/15/2024 914805EV4 8/7/2020 0.720 100,000.00 108,710.00 103,623.36 97,065.00 9/15/2024 624 847.12 0.19 Vernon Twp NJ 1.513 1/1/2027 924735GS6 10/7/2020 1.130 205,000.00 209,710.90 208,024.74 180,145.80 1/1/2027 1,462 1,550.82 0.39 Wauconda III Fire Protn Dist 1.512 12/30/2025 942813AE6 10/14/2020 1.031 200,000.00 204,876.00 202,805.69 182,082.00 12/30/2025 1,095 0.00 0.38 Yuma Cnty Ariz Pledged Rev 1.326 7/15/2026 988636AG1 12/31/2020 0.921 200,000.00 204,376.00 202,796.14 177,574.00 7/15/2026 1,292 1,222.67 0.38 Sub Total/Average Municipal Bond 1 1.2721 13,840,000.00 14,229,172.90 14,071,675.51 12,914,964.601 1 9211 79,682.851 26.54 Negotiable Certificate Of Deposit Adirondack Bk Utica NY 1.1 3/25/2025 OD687QAT9 3/25/2020 1.100 245,000.00 245,000.00 245,000.00 226,818.55 3/25/2025 815 44.30 0.47 Axos Bk San Diego Calif 1.65 3/26/2025 05465DAE8 3/26/2020 1.650 245,000.00 245,000.00 245,000.00 229,663.00 3/26/2025 816 55.38 0.47 Bank of New England NH 3.25 7/31/2023 06426KANB 7/31/2018 3.250 245,000.00 245,000.00 245,000.00 243,412.40 7/31/2023 212 0.00 0.47 Bankunited A Svgs Bk Miami 0.95 3/31/2026-21 066519QT9 3/31/2021 0.950 245,000.00 245,000.00 245,000.00 218,179.85 3/31/2026 1,186 0.00 0.47 BMO Harris Bk Natl Assn 1 4/13/2026-21 056DOXCP3 4/13/2021 1.000 245,000.00 245,000.00 245,000.00 218,380.75 4/13/2026 1,199 530.27 0.47 Capital One Bk USA Natl As 2.65 5/22/2024 14042TAP2 5/22/2019 2.650 245,000.00 245,000.00 245,000.00 238,529.55 5/22/2024 508 693.72 0.47 CFBANK FAIRLAWN OHIO 2.8 8/14/2023 15721 UCW7 2/14/2019 2.800 245,000.00 245,000.00 245,000.00 242,562.25 8/14/2023 226 319.51 0.47 COMENITY CAP BK UTAH 3.1 2/15/2024 20033AP91 2/15/2019 3.100 245,000.00 245,000.00 245,000.00 240,884.00 2/15/2024 411 332.93 0.47 Continental Bk Salt Lake City UT 0.5 7/29/2025-20 211163KQ2 8/6/2020 0.500 210,000.00 210,000.DO 210,000.00 189,136.50 7/29/2025 941 5.75 0.40 Farmers&Merchants NB 1.85 7/29/2024-20 308862DP3 12/27/2019 1.899 245,000.00 244,461.00 244,814.76 235,153.45 7/29/2024 576 49.67 0.47 FINWISE BANK(UTAH)3.15 6/28/2023 31810PAJ8 6/28/2018 3.150 245,000.00 245,000.00 245,000.00 243,652.50 6/28/2023 179 63.43 0.47 First Natl Bk McGregor TX 1.8 12/30/2024 32112UDJ7 12/30/2019 1.800 245,000.00 245,000.00 245,000.00 231,899.85 12/30/2024 730 12.08 0.47 First Premier Bank SD 3 8/20/2024 3361ORPT4 8/20/2014 3.000 246,000.00 246,000.00 246,000.00 239,776.20 8/20/2024 598 2,689.15 0.47 First St Bk Buxton ND 1.65 9/5/2023 33648RAZ2 9/5/2019 1.650 245,000.00 245,000.00 245,000.00 240,335.20 9/5/2023 248 287.96 0.47 First UTD BK&TR Company 3.1 3/6/2026 33742CAF4 3/6/2019 3.1001 245,000.00 245,000.00 245,000.00 234,288.60 3/6/2026 1,1611 520.21 0.47 Firstbank Puerto Rice 1.95 9/8/2025 33767GAH1 9/6/2019 1.950 245,000.00 245,000.00 245,000.00 229,594.40 9/8/2025 982 327.23 0.47 Flagstar Bk FSB Troy Mich 1.25 4/30/2025 33847E3A3 4/30/2020 1.250 245,000.00 245,D00.00 245,000.00 227,053.75 4/30/2025 851 520.21 0.47 GE Capital Bank UT 3.3 4/25/2024 36157QYN1 4/25/2014 3.300 97,000.00 97,000.00 97,000.00 95,123.05 4/25/2024 481 587.58 0.19 Goldman Sachs Bk USA 0.9 5/19/2026-21 38149MWH2 5/19/2021 0.900 245,000.00 245,000.00 245,000.00 216,758.85 5/19/2026 1,235 72.49 0.47 Jonesboro State Bank CD CLL 1 3/15/2026-21 4804OPKA2 3/15/2021 1.000 245,000.00 245,000.00 245,000.00 218,880.55 3/15/2026 1,170 107.40 0.47 JPMorgan Chase Cc 0.55 12/15/2025-21 48128ULL1 9/15/2020 0.550 245,000.00 245,000.00 245,000.00 217,856.45 12/15/2025 1,080 59.07 0.47 City of Farmington Investment Portfolio-by Security Type As of 12/31/2022 Settlement YTM @ Face Maturity Days To Accrued %of Description CUSIP/Ticker Date Cost Amount/Shares Cost Value Book Value Market Value Date Maturity Interest Portfolio Lincoln 1st Bk Lincoln Pk NJ 0.5 8/11/2025-21 53362LBE3 8/12/2020 0.500 245,000.00 245,000.00 245,000.00 220,345.65 8/11/2025 954 63.77 0.47 Morgan Stanley Pvt Bk 1.9 12/26/2023 61760A4Z9 12/26/2019 1.900 245,000.00 245,000.00 245,000.00 238,566.30 12/26/2023 360 63.77 0.47 National Coop Bk N A Hillsboro 3.4 12/21/2023 635573AL2 12/21/2018 3.400 245,000.00 245,000.00 245,000.00 242,145.75 12/21/2023 355 228.22 0.47 Northwest Bk Boise Idaho 2.1 7/11/2024 66736ABOl 7/11/2019 2.100 245,000.00 245,000.00 245,000.00 235,888.45 7/11/2024 558 281.92 0.47 NORTHWESTERN BK IA 2.75 2/13/2023 668015AL4 2/13/2019 2.750 245,000.00 245,000.00 245,000.00 244,617.80 2/13/2023 44 332.26 0.47 Plains Comm Bk Hoven SD 2.55 6/7/2024 72651LCL6 6/7/2019 2.550 245,000.00 245,000.00 245,000.00 238,000.35 6/7/2024 524 410.791 0.47 Plains St Bk Tex 2.3 6/21/2024 726547BK7 6/21/2019 2.300 245,000.00 245,000.00 245,000.00 236,900.30 6/21/2024 538 154.38 0.47 SALLIE MAE BK MURRY UTAH 0.7 8/12/2024 795451AL7 8/11/2021 0.700 245,000.00 245,000.00 245,000.00 230,175.05 8/12/2024 590 667.21 0.47 Spring Bank Bronx NY 1.75 9/12/2024 849430AZ6 9/12/2019 1.750 245,000.00 245,000.00 245,000.00 233,543.80 9/12/2024 621 223.18 0.47 State Bk India Chicago III 1 7/10/2025 856283N93 7/10/2020 1.000 245,000.00 245,D00.00 245,000.00 224,226.45 7/10/2025 922 1,167.95 0.47 Texas Exchange Bk Crowley 1 6/19/2025-20 88241THU7 6/19/2020 1.000 245,000.00 245,OOD.00 245,000.00 224,495.95 6/19/2025 901 80.55 0.47 Toyota Finl Svgs Bk Hand NV 0.55 12/1/2025 89235MKS9 11/30/2020 0.550 245,000.00 245,000.00 245,000.00 218,297.45 12/1/2025 1,066 110.75 0.47 Upper Peninsula St Bk 1.75 12/27/2024 191130PAS0 12/27!2019 1.750 245,000.00 245,000.00 245,000.00 231,716.10 12/27/2024 727 46.99 0.47 Washington Fed Seattle 2.05 8/23/2024 938828BJ8 8/23!2019 2.050 245,000.00 245,000.00 245,000.00 235,043.20 8/23/2024 601 110.08 0.47 Sub Total/Average Negotiable Certificate Of Deposit 1.833 8,393,000.00 8,392,461.00 8,392,814.76 7,931,902.30 699 11,220.16 16.09 Treasury Note T-Note 0.125 1/15/2024 91282CBEO 6/28/2022 2.920 1,000,000.00 958,020.00 971,815.55 953,710.00 1/15/2024 380 574.05 1.92 T-Note 0.125 1/15/2024 91282CBE0 7/14/2022 3.081 1,500,000.00 1,435,380.00 1,455,353.45 1,430,565.00 1/15/2024 380 861.07 2.88 T-Note 0.125 2/28/2023 91282CBN0 12/29/2021 0.380 Tow,D00.00 997,031.25 999,588.84 993,330.00 2/28/2023 59 421.27 1.92 T-Note 0.1253/31/2023 91282CBU4 12/29/2021 0.450 1,000,000.00 995,937.50 999,199.95 989,760.00 3/31/2023 90 315.93 1.92 T-Note 0.256/15/2023 912828ZU7 1/31/2022 0.831 1,000,000.00 992,100.00 997,377.20 980,630.00 6/15/2023 166 109.89 1.92 T-Note 0.25 9/30/2023 91282CDA6 6/28/2022 2.850 700,000.00 677,687.50 686,729.17 676,732.00 9/30/2023 273 442.31 1.34 T-Note 0.375 10/31/2023 91282CDD0 6/28/2022 2.865 1,000,000.00 967,500.00 979,836.73 964,340.00 10/31/2023 304 631.91 1.92 T-Note 0.375 9/15/2024 91282CCX7 7/20/2022 3.1291 500,000.00 471,510.00 477,439.39 466,270.00 9/15/2024 624 554.21 0.96 T-Note 0.8751/31/2024 91282CDV0 7/15/2022 3.153 700,000.00 676,156.25 683,288.27 671,755.00 1/31/2024 396 2,546.54 1.34 T-Note 1.5 2/29/2024 91282CEA5 7/15/2022 3.152 1,000,000.00 974,062.50 981,442.02 964,260.00 2/29/2024 425 5,081.97 1.92 T-Note 2.25 10/31/2024 9128283D0 7/28/2022 2.922 1,300,000.00 1,281,072.00 1,284,646.78 1,249,274.00 10/31/2024 670 4,928.87 2.49 T-Note 2.54/30/2024 91282CEK3 7/20/2022 3.090 1,100,000.00 1,088,813.00 1,091,635.57 1,069,068.00 4/30/2024 486 4,633.98 2.11 T-Note 2.75 2/28/2025 9128283Z1 10/7/2022 4.082 500,DD0.00 464,940.00 486,402.97 483,455.00 2/28/2025 790 4,058.16 0.96 T-Note 2.875 5/31/2025 19128284RB 12/16/2022 4.021 500,OD0.00 486,730.00 486,951.91 483,730.00 5!31/2025 882 688.62 0.96 Sub Total/Average Treasury Note 2.518 12,800,000.00 12,486,940.00 12,581,707.80 12,376,879.00 392 25,848.78 24.54 TVA Bond TVA 0.755/15/2025 1880591EW8 12/16/20221 4.1201 800,000.001 738,648.001 739,692.59 731,656.00 5/15/20251 8661 266.67 1.53 Sub Total/Average TVA Bond 4.120 800,000.00 738,648.00 739,692.59 731,656.00 866 266.67 1.53 Total/Average 2.015 52,153,825.11 51,929,441.51 51,906,555.66 49,821,049.06 577 138,420.62 100 Petty Cash 4,032.00 49,825,081.06