Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
10.03.22 Council Packet
CITY OF Meeting Location: FARMINGTI ONN Farmingt430 Third rd S City Hall 430 TStreet Farmington, MN 55024 CITY COUNCIL REGULAR MEETING AGENDA October 3, 2022 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 September 19, 2022, City Council Meeting Minutes- Administration Approved b) Adopt Resolution Approving Gambling Event Permit—Farmington Volleyball Club—Administration R67-22 c) Approve Sergeants LELS Union Local #387 Memorandum of Understanding (MOU)—Administration Approved d) Approve Bills—Finance Approved e) Approve Out of State Training— Fire Approved f) Approve Contract with Soundwave Production —Fire Approved g) Adopt Resolution Accepting Donation from Immanuel Dental to the Rambling River Center—Parks and Recreation R68-22 h) Adopt Resolution Accepting Donation from MN Nice Gardens and Landscapes to the Rambling River Center—Parks and Recreation R69-22 i) Adopt Resolution Accepting Donation from The Polka Dots to the Rambling River Center—Parks and Recreation R70-22 J) Adopt Resolution Accepting Donation from Happy Harry's Furniture to the Rambling River Center—Parks and Recreation R71-22 REGULAR AGENDA 8. PUBLIC HEARINGS 9. AWARD OF CONTRACT 10. PETITIONS, REQUESTS AND COMMUNICATIONS 11. UNFINISHED BUSINESS 12. NEW BUSINESS a) Adopt Resolution Approving New ERP and Utility Billing Software - Finance R72-22 13. CITY COUNCIL ROUNDTABLE 14. ADJOURN CITY OF 0 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 I' Farmington MN.gov TO: Mayor, Councilmembers and City Administrator FROM: Cynthia Muller, Administrative Assistant SUBJECT: Approve September 19, 2022; City Council Meeting Minutes-Administration DATE: October 3, 2022 INTRODUCTION Attached for your review are the minutes of the September 19, 2022, city council meeting. DISCUSSION N/A BUDGET IMPACT N/A ACTION REQUESTED Approve the minutes of the September 19, 2022, city council meeting. ATTACHMENTS: Type Description D Exhibit Meeting Minutes COUNCIL MINUTES REGULAR September 19, 2022 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, Bernhjelm, Lien, Porter, Wilson Members Absent: None Also Present: Leah Koch, City Attorney; Lynn Gorski, City Administrator; Julie Flaten, Assistant City Administrator/HR Director; Chris Regis, Finance Director;Justin Elvestad, Fire Chief; Kellee Omlid, Parks and Recreation Director; Cynthia Muller, Administrative Assistant Audience: Dan Pecarina 4. APPROVE AGENDA Move item 7k) Staff Changes and Recommendations to New Business. MOTION by Wilson, second by Porter to approve the agenda. APIF, MOTION CARRIED. S. ANNOUNCEMENTS 6. CITIZEN COMMENTS 7. CONSENT AGENDA MOTION by Bernhjelm, second by Lien to approve the Consent Agenda as follows: a) Approved JPA Solid Waste and Recycling Coordinator-Administration b) Adopted RESOLUTION R63-22 Appointing 2022 General Election Judges - Administration C) Adopted RESOLUTION R64-22 Approving a Gambling Event Permit—Farmington Firefighters Auxiliary Association -Administration d) Acknowledged City Administrator Performance Review Summary—City Council e) Approved September 6, 2022, City Council Work Session and Meeting Minutes— Administration f) Approved Fire Station#2 Maintenance Service Agreement—Facilities g) Approved Bills—Finance h) Approved Purchasing Site Furnishings for Downtown—Parks i) Adopted ORDINANCE 022-769 and Summary Ordinance Amending Section 10-5- 17 (Industrial) of the Zoning Code Allowing Offices as a Permitted Use— Community Development D Adopted RESOLUTION R65-22 Granting a Time Extension for Recording of Final Plat—Vita Attiva at South Creek Third Addition —Community Development APIF, MOTION CARRIED. 8. PUBLIC HEARINGS Council Minutes(Regular) September 19,2022 Page 2 a) Notice of Intent to Consider Issuance of Cable Franchise—Administration Hiawatha Broadband Communications (HBC) applied for a cable franchise. This also includes internet,TV and phone services. The build out would begin in Farmington in 2023 and full build out would be completed in 2025. HBC will finance the project themselves and have an office in Farmington. They will also connect city parks and other facilities. Mr. Dan Pecarina, President of HBC, stated they have 30+fiber communities in southern MN. MOTION by Wilson, second by Bernhjelm to close the public hearing. APIF, MOTION CARRIED. Mr. Pecarina stated their biggest challenge is they want to be a good steward. It can be difficult to make homeowners happy after digging a big hole in their front yard. They advise them in advance, while they are there and provide contact information. A crew follows later with dirt to fill the hole. They make sure they do a good job setting up in one community before moving on to the next. They would be happy to join the Dakota County Regional Chamber. In smaller towns everything revolves around schools and churches that's where they excel. They will build a brick and mortar building here and will be hiring employees here. Councilmembers were very pleased to have HBC coming to Farmington and thanked Mr. Pecarina for reaching out to us. MOTION by Porter, second by Wilson to negotiate franchise terms with HBC and present the final recommendation for city council action. APIF, MOTION CARRIED. 9. A WARD OF CONTRACT 10. PETITIONS, REQUESTS AND COMMUNICATIONS 11. UNFINISHED BUSINESS a) Approve Final Proposal for USDA Lease Amendment-Administration City Administrator Gorski has been negotiating with the USDA to lease additional office space in the expansion area at City Hall. The lease is for 16 years with a five-year guarantee. The city will be required to build out the space to be rented with an estimated cost of$260,000. Staff is recommending using the general fund and the future payoff of the first build out to pay for the build out cost. The costs will be covered in the rent the USDA pays in the first five years of the lease, which includes an interest rate of 6%. If the USDA ends the lease prior to five years, they will be responsible for repaying the build out costs. Their rentable square feet will go from 2,610 sq.ft. to 5,181 sq.ft. The USDA will have the use of 42 parking spots in the city lots and a 300 sq. ft. fenced area located off of Second Street. The USDA will pay$141,493 annually the first five years of the contract and $92,740 annually in years 5-10; $112,428 annually in years 11-16. The price reduction after year 5 is associated with the build out costs being paid in full after five years. The previous lease in 2018 was signed for$29,545 for Council Minutes(Regular) September 19,2022 Page 3 years 1-10 and $19,575 in years 11-20. MOTION by Bernhjelm, second by Lien to approve the final lease proposal with the USDA for the lease of space at Farmington City Hall and authorize the city administrator to execute all documents associated with the lease. APIF, MOTION CARRIED. 12. NEW BUSINESS a) Staff Changes and Recommendations MOTION by Bernhjelm, second by Wilson to approve the appointment of Ethan Stender as a seasonal arena supervisor. APIF, MOTION CARRIED. b) Adopt Resolution Approving Preliminary 2023 General Fund Budget and Tax Levy- Finance The 2023 budget was prepared in line with council's goals. Property taxes continue to be the primary source of income for the city. Highlights include -for 2023, LGA was cut by$105,587; in 2022 three new positions were added and in 2023 there will be three more new positions, solid waste has been transferred to the general fund,the final 2023 budget will be approved in December 2022. The net tax levy for 2023 is$12,749,000 which is a 5.96%increase over 2022. This amounts to a $28 increase in property taxes for the average valued home. Revenues are projected to be $3.8 million which is a 5.13% increase. Expenditures are projected to be $16.8 million which is a 7.34% increase. Finance Director Regis reviewed special revenue funds, capital project funds and enterprise funds. Councilmembers commended staff on a great job collaborating for the first year and felt this increase is a reasonable amount for residents. Council asked about trail maintenance and that is kept in a separate fund. There is$50,000 set aside for EAB treatment, but that needs to increase each year as the city has 3300 ash trees in boulevards. Council asked how cities like West and South St. Paul have $2 million in LGA and we have zero. It is a complex formula and involves tax capacity valuation. The right approach is to assume we will receive zero. Council was a little worried about the permit number as the market has shifted. Staff has confirmed this amount with builders and their expectations. Council noted this budget process started in June with understanding what the baseline is. We have been making improvements and ensuring proper funding. We still face challenges and applauded taking small steps. Residents should notice on their tax statement the increase in their property valuation. MOTION by Bernhjelm, second by Wilson to adopt RESOLUTION R66-22 establishing the 2023 preliminary tax levy and setting the public hearing for the final 2023 budget and tax levy for December 5, 2022. APIF, MOTION CARRIED. 13. COUNCIL ROUNDTABLE Council Minutes(Regular) September 19,2022 Page 4 Wilson: We approved 76 election judges on the consent agenda tonight and thanked Administrative Assistant Cindy Muller for her work on elections. His mom is the newest resident of Farmington. Thanked Parks and Recreation Director Omlid for the food truck event last week. Faith United Methodist Church is looking for volunteers to help with Loaves and Fishes. Porter. She saw our public service departments in action in different capacities this weekend and thanked them for the work they do. Bernhjelm: One of council's goals is telling our story. Communications Specialist Lauren Siebenaler has been selected as a finalist for the Leaders in Local Government award to be held September 29, 2022. She read the submission about the work Lauren has done celebrating Farmington's 150th Anniversary. Lien: Encouraged residents that have ash trees to look for EAB and treat it or safely remove the tree. Koch: The courts are getting through the backlog of cases and are 62%done. Flaten: Lauren's nomination for the Local Government award is great news. An employee appreciation picnic will be held Wednesday. This week staff will be conducting interviews for a public works director and community development director. Gorski. Gave an update on the stages of the Spruce Street project. Notices will be placed on front doors of what to expect and residents can sign up for email notifications. The contractor will be reassessing the project on October 7 and may have to delay it until 2023 if the weather becomes too cold. Omlid: The Rambling River Center turns 40 this year and there will be a celebration on Thursday. She thanked Rambling River Center Coordinator Missie Kohlbeck for her work on this event. Regis: He's working on tax forms. Elvestad: The Fire Station Open House will be October 12 and turkey bingo is November 12. Hoyt: School is in session so watch for buses and kids. Thank you to Great Oaks Academy for resolving transportation issues. Congratulations to Empire for officially incorporating two weeks ago. Patriotic Day will be held November 10 at Farmington High School and he encouraged residents to attend. 14. ADJOURN MOTION by Bernhjelm, second by Porter to adjourn at 7:58 p.m. APIF, MOTION CARRIED. Council Minutes(Regular) September 19,2022 Page 5 Respectfully submitted, Cynthia �vluller Cynthia Muller Administrative Assistant CITY OF O 430 Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 Farmington MN.gov TO: Mayor, Councilmembers and City Administrator FROM: Cynthia Muller,Administrative Assistant SUBJECT: Adopt Resolution Approving Gambling Event Permit- Farmington Volleyball Club- Administration DATE: October 3, 2022 INTRODUCTION The Farmington Volleyball Club is requesting a Gambling Event Permit for a 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 2022 budget. ACTION REQUESTED Consider the attached resolution granting a Gambling Event Permit to the Farmington Volleyball Club,to be held at EI Charro Mexican Restaurant, 122 Elm Street, on January 11, 2023. ATTACHMENTS: Type Description D Resolution Resolution RESOLUTION NO. R67-22 APPROVING A MINNESOTA LAWFUL GAMBLING EVENT PERMIT APPLICATION FOR THE FARMINGTON VOLLEYBALL CLUB 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 3rd day of October 2022 at 7:00 p.m. Members Present: Hoyt, Bernhjelm, Lien, Porter,Wilson Members Absent: None Member Wilson 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 Farmington Volleyball Club has submitted an application for a Gambling Event Permit to be conducted at EI Charro Mexican Restaurant, 122 Elm Street,on January 11, 2023,for Council consideration. NOW,THEREFORE,BE IT RESOLVED by the Farmington City Council that the Gambling Event Permit for the Farmington Volleyball Club,to be held at EI Charro Mexican Restaurant, 122 Elm Street, is hereby approved. This resolution adopted by recorded vote of the Farmington City Council in open session on the 3rd day of October 2022. Ma Attested to the day of October 2022. y Adn ' istrator SEAL CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 h Farmington M N.gov TO: Mayor, Councilmembers and City Administrator FROM: Lynn Gorski, City Administrator SUBJECT: Sergeants LELS Union Local#387 Memorandum of Understanding(MOU)- Administration DATE: October 3, 2022 INTRODUCTION We are requesting the approval of a Memorandum of Understanding with the Sergeants LELS Union Local#387 for the contract period through December 31, 2024. DISCUSSION The attached MO U outlines the following changes to the sergeant's contract. These changes include: - Adjusting the maximum total accrued compensatory time to a not to exceed amount of 90 hours for the calendar year effective January 1, 2022 - Consistency in health care insurance language and increasing city contribution amounts for coverage levels -Adjusting the uniform allowance to$900 effective January 1, 2022 - Adjusting the specialty pay for assignment of Investigative Sergeant to $300 per month effective the first payroll following council approval All other terms and conditions remained unchanged. BUDGET IMPACT The budget impact of the MO U is an estimated amount of$6,000. This amount is based on current elections and current staff cost. ACTION REQUESTED Approve the memorandum of understanding with Sergeants LELS Union Local#387 ATTACHMENTS: Type Description D Cover Memo Memorandum of Understanding i i Memorandum of Understanding(MOU) i I This memorandum of understanding is made and entered into between the City of Farmington, Minnesota, ("Employer"),and Law Enforcement Labor Services(LELS)Local#387, j i Whereas,the City and Union are parties to a collective bargaining agreement("CBA"), In effect from January 1, 2022 through December 31,2024, and i Whereas,Article XII—Overtime, 12.7 states, in part,the maximum total accrued compensatory time shall not exceed eighty(80) hours for that calendar year,and I i i Whereas,Article XVI—Insurance 16.1 states that effective January 1,2022 and each January thereafter, the EMPLOYER'S contributions for each tier shall be the contribution for the previous year increased or decreased by an amount equal to fifty percent(50%)of the increase or decrease to the HDDP 2800/5600 with HSA health insurance plan. The employee will pay any excess of the monthly amount contributed by the employer through payroll deduction. For 2022,the EMPLOYER monthly contribution for the HDDP 2800/5600 with HSA will be: Single $965 Employee+Spouse $1130 Employee+Children $1025 Family $1310 *Contributions vary based on each plan and network selected Whereas,Article XXII—Unforms provides for a clothing allowance equal to the sum of$850 for 2022, 2023,and 2024,and i Whereas,Appendix A—Specialty Pay provides for the position of Investigative Sergeant a specialty pay of$250 per month, I Now therefore,the parties agree hereto agree to the following: 1) that effective January 1,2022 maximum total accrued compensatory time shall not exceed ninety(90) hours for that calendar year. 2) that effective January 1,2023 Article XVI—Insurance 16.1 the following language will be added: Effective January,2023,and each January thereafter,the Employer's contribution shall cover the cost of single basic life,single dental, and single health insurance coverage at 100%. For Employee plus Child(ren), Employee plus Spouse or Family coverage,the Employer's contribution shall be the contribution of the previous year increased or decreased by an amount equal to sixty percent(60%)of the increase or decrease to the highest value plan. I i The City's contribution amount includes dollars allocated to either the HRA or HSA. I i E �t i As of January 1,2023,the EMPLOYER'S total contribution will be: 4 z Single $993.96 I Employee+Spouse $1280.97 Employee+Child(ren) $1355.89 Family $1668.98 f If an employee has waived health insurance coverage,the value of the lowest single premium offered by the Employer shall be used to calculate the remaining Employer contribution. Any Employer contribution dollars remaining after basic life coverage deduction, and optional employee purchased health insurance, dental insurance,vision insurance, and i short-term disability insurance shall be either paid out in taxable cash or contributed to. i the Employee's deferred compensation account and/or Health Savings Account(HSA). i The employee will pay any excess of the monthly contribution by the Employer through payroll deduction. i 3) that effective January 1,2022 the uniform allowance will be$900. 4) that effective the first payroll following date of agreement of this MOU the Specialty Pay for the position of Investigative Sergeant shall be$300 per month. I i The terms of the Memorandum shall remain in effect through December 31,2024, unless the parties mutually agree otherwise. In Wtness Whereof,the parties hereto have executed this Memorandum of Understanding on this 3'' day of Z- 2022. CITY OF FARMINGTON LELS LOCAL 387 Approved by the City Council 3 ,2022 Oe X 6;11J v— r IQ Lynn Gor i,City AdministratorJ m Murp rgeant 4C ob Sauter,Sergeant 4Seacl(Wight, LELS i I CITY OF 0 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 I h Farmington MN.gov TO: Mayor, Councilmembers and City Administrator FROM: Chris Regis, Finance Director SUBJECT: Approve Bills- Finance DATE: October 3, 2022 INTRODUCTION Attached is the September 14, 2022—September 27, 2022 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 Backup Material Council Check Summary R55CKS2 LOGIS600V COUNCIL MEETING OCT 3, 2022 CITY OF FARMINGTON 9/27/2022 8:14:23 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 1 9/14/2022 - 9/27/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 101101 9/16/2022 100193 APPLE VALLEY,CITY OF 5,824.76 COMPUTER PURCHASE FARM'S SHARE 206332 7676 4005 6401 PROFESSIONAL SERVICES CABLE/COMMUNICATIONS PROJ 04000 01 5,824.76 101102 9/16/2022 109503 BIFFS,INC 160.00 SEP'22 PRTBLE RNTL-TMRCK PRK 206200 #W881582 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 160.00 SEP'22 PRTBLE RNTL-EVRGRN KN 206201 #W881588 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 160.00 SEP'22 PRTBLE RNTL-HILL DEE 206202 #W881579 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 311.00 BIFF RAMBLING RIVER SEPT 22 206203 #W881584 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 160.00 BIFF FARM PRESERVE SEPT 22 206204 #W861587 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 160.00 BIFF PINE KNOLL SEPT 22 206205 #W881581 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 215.00 BIFF RRP EVENTS SEPT 22 206206 #W884999 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 160.00 BIFF DAKOTA ESTATES SEPT 22 206207 #W881578 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 160.00 BIFF DAISY KNOLL SEPT 22 206208 #W881577 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 160.00 BIFF MEADOWVIEW SEPT 22 206209 #W881586 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 160.00 BIFF JIM BELL SEPT 22 206210 #W881590 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 300.00 BIFF FEELY FIELDS SEPT 22 206211 #W881585 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 160.00 BIFF DISTAD SEPT 22 206212 #W881589 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 160.00 BIFF LAKE JULIA SEPT 22 206213 #W881580 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 160.00 BIFF PRAIRIEVIEW SEPT 22 206214 #W881583 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 2,746.00 101103 9/16/2022 108967 DICK'S VALLEY SERVICE INC 95.00 TOWING FEE 206074 22-41868 7200 6510 1 OUTSIDE VEHICLE REPAIR/MAINT FLEET OPERATIONS 07200 08 95.00 101104 9/16/2022 100022 FARMINGTON PRINTING INC 64.00 CERTIFICATION ENVELOPES 205847 14372 6502 6450 OUTSIDE PRINTING WATER UTILITY EXPENSE 06500 08 64.00 CERTIFICATION ENVELOPES 205847 14372 6202 6450 OUTSIDE PRINTING SEWER OPERATIONS EXPENSE 06200 08 64.00 CERTIFICATION ENVELOPES 205847 14372 6402 6450 OUTSIDE PRINTING STORM WATER UTILITY OPERA 06400 08 21.38 COPY PAPER 206153 14377 6115 6210 OFFICE SUPPLIES PILOT KNOB LIQUOR 06100 02 21.37 COPY PAPER 206153 14377 6110 6210 OFFICE SUPPLIES DOWNTOWN LIQUOR REV&EXP 06100 02 2.75- 206153 14377 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 232.00 101105 9/16/2022 117498 GILBERTSON,PETER 98.06 AUG'22 MILEAGE REIMB 206156 20220831 7400 6485 MILEAGE REIMBURSEMENT INFORMATION TECHNOLOGY 07400 04 GILBERTSON 98.06 101106 9/16/2022 110525 IN-SITU INC 100.00 AUG'22 CELL SVS:WTR LVS SFTWR 206194 10088 6502 6505 EQUIPMENT REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 100.00 SEPT'22 CELL SVS:WTR LVS SFTW 206195 HV10561 6502 6505 EQUIPMENT REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 200.00 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/27/2022 8:14:23 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 2 9/14/2022 - 9/27/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 101107 9/16/2022 116886 LABRASH PLUMBING&HEATING 367.73 WATER LEAK REPAIR 206136 10037 2502 6515 BUILDING REPAIR/MAINTENANCE ICE ARENA OPERATIONS EXPE 02500 09 154.73 TOILET REPAIR 206137 10038 1015 6515 BUILDING REPAIR/MAINTENANCE CITY HALL 01000 01 522.46 101108 9/16/2022 115396 MACQUEEN EMERGENCY GROUP 3,883.29 REPAIRS TO ENGINE 11 STEERING 205856 W04588 1060 6510 1 OUTSIDE VEHICLE REPAIR/MAINT FIRE SERVICES 01000 06 3,883.29 101109 9/16/2022 113442 METERING&TECHNOLOGY SOLUTIONS 15,246.10 ORION REGISTERS(QTY:72) 205935 INV164 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 1,906.00 2"&1 1/2" METERS/ORION 205941 INV187 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 17,154.10 101110 9/16/2022 115734 MINNESOTA OCCUPATIONAL HEALTH 233.00 AUG'22 EMPLOYMENT TESTING 206167 405870 1011 6405 EMPLOYMENT TESTING HUMAN RESOURCES 01000 04 233.00 101111 9/16/2022 100070 MINNESOTA VALLEY TESTING LABORATORIES 95.02 BAC-T SAMPLE(7) 205934 1159805 6502 6535 OTHER REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 95.02 101112 9/16/2022 102644 NORTHERN SAFETY TECHNOLOGY,INC 36.00 MICROPHONE CLIP FOR 0523 205970 54429 1051 6230 VEHICLE SUPPLIES&PARTS PATROL SERVICES 01000 05 36.00 101113 9/16/2022 117848 PEMBER COMPANIES 7,910.63 FINAL PAY:DWNTWN SIDEWLK RPLC 206197 OT1.124241 FINAL 5700 2020 02101 CONTRACTS PAYABLE MAINTENANCE FUND BALANCE 05700 07 7,910.63 101114 9/16/2022 109709 TRIHUS,DAVID M 61.25 AUG'22 MILEAGE REIMB 206155 20220831 TRIHUS 6110 6485 MILEAGE REIMBURSEMENT DOWNTOWN LIQUOR REV&EXP 06100 02 61.25 AUG'22 MILEAGE REIMB 206155 20220831 TRIHUS 6115 6485 MILEAGE REIMBURSEMENT PILOT KNOB LIQUOR 06100 02 122.50 101115 9/16/2022 112567 ULTIMATE SAFETY CONCEPTS,INC 3,016.75 SENSORS FOR GAS MONITORS 206090 201606 1060 6220 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 3,016.75 101116 9/23/2022 117229 2N SYSTEMS,LLC 3,750.00 MAINTENANCE FEE 206004 INV105754 7400 6505 EQUIPMENT REPAIR/MAINTENANCE INFORMATION TECHNOLOGY 07400 04 3,750.00 101117 9/23/2022 106886 ALERT-ALL CORP 720.00 FIRE PREV DAY-IMPR FIRE HATS 206382 222080593 1060 6570 PROGRAMMING EXPENSE FIRE SERVICES 01000 06 720.00 101118 9/23/2022 108482 AXON ENTERPRISE,INC R55CKS2 LOGIS600V CITY OF FARMINGTON 9/27/2022 8:14:23 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 3 9/14/2022 - 9/27/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 2,309.93 SQD 23 CAMERA 206179 INUS095836 5602 6940 50 VEHICLES-POLICE GEN CAPITAL EQUIP FUND EX 05600 2,309.93 101119 9/23/2022 100493 BELLBOY CORPORATION 43.75 BAG ORDER 206349 0105671800 6115 6250 OTHER SUPPLIES&PARTS PILOT KNOB LIQUOR 06100 02 87.50- BAG RETURN 206353 0105674100 CR 6115 6250 OTHER SUPPLIES&PARTS PILOT KNOB LIQUOR 06100 02 603.73 LIQUOR&SPIRITS ORDER 206413 0096374200 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 90.18 LIQUOR&SPIRITS ORDER 206416 0105698000 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 43.75 BAGS 206416 0105698000 6115 6250 OTHER SUPPLIES&PARTS PILOT KNOB LIQUOR 06100 02 270.70 LIQUOR&SPIRITS ORDER 206450 0096443600 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 93.93 BAG ORDER 206451 0105727400 6110 6250 OTHER SUPPLIES&PARTS DOWNTOWN LIQUOR REV&EXP 06100 02 138.84 LIQUOR SUPPLIES AND MIXES ORDE 206453 0105720500 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 229.90 BAG ORDER 206472 0105720700 6115 6250 OTHER SUPPLIES&PARTS PILOT KNOB LIQUOR 06100 02 181.47 LIQUOR SUPPLIES AND MIXES ORDE 206472 0105720700 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 551.40 LIQUOR&SPIRITS ORDER 206485 0096444000 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 292.95 WINE ORDER 206490 0096380200 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 436.50 LIQUOR&SPIRITS ORDER 206491 0096314200 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 44.25 BAG ORDER 206561 0105757700 6110 6250 OTHER SUPPLIES&PARTS DOWNTOWN LIQUOR REV&EXP 06100 02 1,975.25 LIQUOR&SPIRITS ORDER 206565 0096549800 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 146.45 LIQUOR SUPPLIES&MIXES ORDER 206567 0105757600 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 23.73 LIQUOR SUPPLIES&MIXES ORDER 206568 0105757500 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 277.96 LIQUOR SUPPLIES&MIXES ORDER 206588 0105757400 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 491.95 LIQUOR&SPIRITS ORDER 206593 00965494D0 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 5,649.19 101120 9/23/2022 109503 BIFFS,INC 275.00 PRTBLE RNTL:DISTAD MUSIC PRK 206604 #W885393 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 275.00 101121 9/23/2022 118704 BLUE CLOUD DISTRIBUTION OF MINNESOTA INC 1,670.61 LIQUOR&SPIRITS ORDER 206410 101070638 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 239.96 LIQUOR&SPIRITS ORDER 206492 101070637 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 980.00 LIQUOR&SPIRITS ORDER 206540 101070685 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 2,890.57 101122 9/23/2022 100253 CAMPBELL KNUTSON,P.A. 1,199.20 AUG'22 LEGAL FEES-GENERAURETN 206497 1852-OOOOGAUG'22 1005 6403 LEGAL LEGISLATIVE CONTROL 01000 01 1,834.90 AUG'22 LEGAL FEES-GENERAURETN 206497 1852-000OG AUG'22 1010 6403 LEGAL ADMINISTRATION 01000 01 35.40 AUG'22 LEGAL FEES-GENERAURETN 206497 1852-D000G AUG'22 1013 6401 PROFESSIONAL SERVICES ELECTIONS 01000 01 250.40 AUG'22 LEGAL FEES-GENERAURETN 206497 1852-OOOOGAUG'22 1030 6403 LEGAL PLANNING&ZONING 01000 03 247.80 AUG'22 LEGAL FEES-GENERAURETN 206497 1852-OOOOGAUG'22 1050 6403 LEGAL POLICE ADMINISTRATION 01000 05 208.00 AUG'22 LEGAL FEES-GENERAURETN 206497 1852-000OG AUG'22 1070 6403 LEGAL ENGINEERING SERVICES 01000 07 557.60 AUG'22 LEGAL FEES-GENERAURETN 206497 1852-000OG AUG'22 1094 6403 LEGAL PARK&RECREATION ADMIN 01000 09 49.00 AUG'22 LEGAL FEES-FORFEITURE 206518 1852-0003G AUG'22 2100 6403 LEGAL POLICE FORFEITURES 02100 05 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/27/2022 8:14:23 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 4 9/14/2022 - 9/27/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 405.00 AUG'22 LEGAL FEES-POLICE 206519 1852-0004G AUG'22 1050 6403 LEGAL POLICE ADMINISTRATION 01000 05 7,781.41 AUG'22 LEGAL FEES-PROSECUTION 206520 1852-0999G AUG'22 1050 6403 LEGAL POLICE ADMINISTRATION 01000 05 12,568.71 101123 9/23/2022 117735 CLEAR RIVER BEVERAGE 314.50 BEER ORDER 206406 648773 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 235.75 BEER ORDER 206484 649476 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 0610D 02 309.50 BEER ORDER 206538 650962 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 64.50- BEER ORDER CREDIT 206581 651066 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 266.00 BEER ORDER 206582 650978 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,061.25 101124 9/23/2022 100071 COLLEGE CITY BEVERAGE INC 7,620.15 BEER ORDER 206400 829540 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 114.00 SPIRIT&LIQUOR ORDER 206401 829541 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 125.40- BEER ORDER 206403 1682-00053 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 607.50 SPIRITS ORDER 206405 829428 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 12,073.55 BEER ORDER 206425 829369 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 376.00 LIQUOR&SPIRITS ORDER 206447 831564 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 6.00- LIQUOR SUPPLIES AND MIXES ORDE 206449 831563 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 5,899.65 BEER ORDER 206452 831565 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 9,734.50 BEER ORDER 206483 831404 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 216.00 LIQUOR&SPIRITS ORDER 206488 831403 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 120.00- BEER ORDER CREDIT 206529 833870 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 393.51 BEER ORDER 206537 833017 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 418.50 BEER ORDER 206539 833871 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 14,205.10 BEER ORDER 206555 833872 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 35.27- BEER ORDER CREDIT 206580 833851CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 202.50 BEER ORDER 206584 833850 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 0610D 02 8,995.65 BEER ORDER 206598 833849 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 60,569.94 101125 9/23/2022 109182 DAKOTA COMMUNICATIONS CENTER 6,092.67 OCT 2022 DCC FEES 206238 FA2022-10 1060 6560 CONTRACTUAL SERVICES FIRE SERVICES 01000 06 12,185.33 OCT 2022 DCC FEES 206238 FA2022-10 1050 6560 CONTRACTUAL SERVICES POLICE ADMINISTRATION 01000 05 18,278.00 101126 9/23/2022 118179 FARMINGTON MALL LLC 6,678.50 OC722 RENT DT LIQUOR STORE 206506 20221001 DT LIQ 6110 6556 BUILDING RENTAL DOWNTOWN LIQUOR REV&EXP 06100 02 6,678.50 101127 9/23/2022 112416 IMPACT MAILING OF MN,INC 100.32 AUG'22 UB MAIL PREP 206390 201488 6202 6401 PROFESSIONAL SERVICES SEWER OPERATIONS EXPENSE 06200 08 100.32 AUG'22 UB MAIL PREP 206390 201488 6402 6401 PROFESSIONAL SERVICES STORM WATER UTILITY OPERA 06400 08 100.31 AUG'22 UB MAIL PREP 206390 201488 6502 6401 PROFESSIONAL SERVICES WATER UTILITY EXPENSE 06500 08 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/27/2022 8:14:23 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 5 9/14/2022 - 9/27/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 285.17 AUG'22 UB BILL POSTAGE 206390 201488 6502 6445 POSTAGE/SHIPPING FEES WATER UTILITY EXPENSE 06500 08 285.17 AUG'22 UB BILL POSTAGE 206390 201488 6402 6445 POSTAGE/SHIPPING FEES STORM WATER UTILITY OPERA 06400 08 285.17 AUG'22 UB BILL POSTAGE 206390 201488 6202 6445 POSTAGE/SHIPPING FEES SEWER OPERATIONS EXPENSE 06200 08 1,156.46 101128 9/23/2022 110766 JOHNSON CONTROLS FIRE PROTECTION LP 56.16 1ST ST GAR ALARM MONITRNG 206618 23130927 6502 6515 BUILDING REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 80.23 1ST ST GARALARM MONITRNG 206618 23130927 6402 6515 BUILDING REPAIR/MAINTENANCE STORM WATER UTILITY OPERA 06400 08 40.11 1ST ST GAR ALARM MONITRNG 206618 23130927 6202 6515 BUILDING REPAIR/MAINTENANCE SEWER OPERATIONS EXPENSE 06200 08 64.18 1ST ST GAR ALARM MONITRNG 206618 23130927 1090 6515 BUILDING REPAIR/MAINTENANCE PARK MAINTENANCE 01000 09 40.11 IST ST GAR ALARM MONITRNG 206618 23130927 1072 6515 BUILDING REPAIR/MAINTENANCE STREET MAINTENANCE 01000 08 280.79 101129 9/23/2022 100049 LOCAL GOVERNMENT INFORMATION SYSTEMS 404.30 JUL'22 MN IT WAN SERVICE 206170 52699 7400 6402 DATAPROCESSING INFORMATION TECHNOLOGY 07400 04 7,260.10 CISCO SWITCHES 206170 52699 7400 696D FURNITURE,OFFICE EQUIP,IT INFORMATION TECHNOLOGY 07400 04 12,103.74 CISCO SWITCHES 206170 52699 7400 6960 FURNITURE,OFFICE EQUIP,IT INFORMATION TECHNOLOGY 07400 04 919.36 KNOWBE4 ANNUAL RENEWAL 206170 52699 7400 6505 EQUIPMENT REPAIR/MAINTENANCE INFORMATION TECHNOLOGY 07400 04 15.00 VPN TOKEN TERRI WILSON 206170 52699 7400 6402 DATA PROCESSING INFORMATION TECHNOLOGY 07400 04 4,970.00 SEPT'22 APPL SUPPORT INV 206171 52579 1021 6402 DATA PROCESSING FINANCE 01000 02 2,606.00 SEPT'22 APPL SUPPORT INV 206171 52579 1011 6402 DATAPROCESSING HUMAN RESOURCES 01000 04 2,492.00 SEPT'22 APPL SUPPORT INV 206171 52579 1050 6402 DATA PROCESSING POLICE ADMINISTRATION 01000 05 397.00 SEPT'22 APPL SUPPORT INV 206171 52579 1060 6402 DATAPROCESSING FIRE SERVICES 01000 06 3,528.00 SEPT'22APPL SUPPORT INV 206171 52579 1031 6402 DATAPROCESSING BUILDING INSPECTIONS 01000 07 1,379.00 SEPT-22APPLSUPPORT INV 206171 52579 6202 6402 DATAPROCESSING SEWER OPERATIONS EXPENSE 06200 08 1,379.00 SEPT-22APPL SUPPORT INV 206171 52579 6402 6402 DATA PROCESSING STORM WATER UTILITY OPERA 06400 08 1,379.00 SEPT'22 APPL SUPPORT INV 206171 52579 6502 6402 DATA PROCESSING WATER UTILITY EXPENSE 06500 08 2,634.00 SEPT'22 APPL SUPPORT INV 206171 52579 7400 6402 DATA PROCESSING INFORMATION TECHNOLOGY 07400 04 195.00 TK#308625 MAIL SVR ACCESS 206175 52644 7400 6401 PROFESSIONAL SERVICES INFORMATION TECHNOLOGY 07400 04 32.50 TK#310459 PD SVR NETWK INFO 206175 52644 7400 6401 PROFESSIONAL SERVICES INFORMATION TECHNOLOGY 07400 04 41,696.00 101130 9/23/2022 113199 LUBE-TECH 8.PARTNERS,LLC 315.50 SHOP LIFT INSPECTIONS 206100 3001328 7200 6505 EQUIPMENT REPAIR/MAINTENANCE FLEET OPERATIONS 07200 08 913.61 INGROUND HOIST REPAIR 206230 3004107 7200 6505 EQUIPMENT REPAIR/MAINTENANCE FLEET OPERATIONS 07200 08 1,229.11 101131 9/23/2022 107747 M.AMUNDSON LLP 995.37 CIGARETTES&POP ORDER 206457 348381 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 995.37 101132 9/23/2022 115396 MACQUEEN EMERGENCY GROUP 357.37 EQUIPMENT FOR FIRE ENGINE 206059 P07589 1060 6230 VEHICLE SUPPLIES&PARTS FIRE SERVICES 01000 06 357.37 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/27/2022 8:14:23 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 6 9/14/2022 - 9/27/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 101133 9/23/2022 113031 NRG RELIABILITY SOLUTIONS LLC 42.67 (AUG)'22 ELECTRIC CMF 2D6219 3347-2209 1072 6422 ELECTRIC STREET MAINTENANCE 01000 08 111.81 (AUG)'22 ELECTRIC CMF 2D6219 3347-2209 1090 6422 ELECTRIC PARK MAINTENANCE 01000 09 64.02 (AUG)'22 ELECTRIC CMF 206219 3347-2209 6202 6422 ELECTRIC SEWER OPERATIONS EXPENSE 06200 08 42.68 (AUG)'22 ELECTRIC CMF 206219 3347-2209 6402 6422 ELECTRIC STORM WATER UTILITY OPERA 06400 08 1,536.38 (AUG)'22 ELECTRIC CMF 206219 3347-2209 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 1,986.35 AUG'22 ELEC LAW ENFORCE CNTR 206246 3346-2209 1050 6422 ELECTRIC POLICE ADMINISTRATION 01000 05 3,783.91 101134 9/23/2022 107945 SCHWINESS,LLC 10,071.10 OCT'22 RENT PK LIQUOR STORE 206600 2908 6115 6556 BUILDING RENTAL PILOT KNOB LIQUOR 06100 02 10,071.10 101135 9/23/2022 109258 VAN DORN,ANDREW 43.50 SEP'22 TRNG:MEAL REIMB 206396 20220913 VAN DORN 1051 6470 TRAINING&SUBSISTANCE PATROL SERVICES 01000 05 43.50 101136 9/23/2022 108808 VINOCOPIA,INC 716.25 LIQUOR&SPIRITS ORDER 206454 0312370-IN 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 346.50 WINE ORDER 206595 0312569-IN 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,062.75 101137 9/23/2022 102592 WINE COMPANY,THE 406.00 LIQUOR&SPIRITS ORDER 206591 214828 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 406.00 101138 9/23/2022 100389 WOLD ARCHITECTS&ENGINEERS INC 2,299.92 2022 PD SPACE NEEDS STUDY 206083 81261 7600 6401 27004 PROFESSIONAL SERVICES FEDERAL AID-COVID19 07600 02 2,299.92 101139 9/23/2022 108450 WSB&ASSOCIATES INC 674.00 VRWJPO DRAINAGE STUDY 206392 R-018756-000-9 6402 6401 PROFESSIONAL SERVICES STORM WATER UTILITY OPERA 06400 08 827.25 MS4 PERMIT IMPLEMENTATION 206394 R-020038-000-5 6402 6401 PROFESSIONAL SERVICES STORM WATER UTILITY OPERA 06400 08 4,480.00 JUL'22 CODE ENFORCEMENT SERVIC 206512 R-019521-000-7 1030 6401 PROFESSIONAL SERVICES PLANNING&ZONING 01000 03 5,981.25 158549 9/16/2022 100058 ADVANCE AUTO PARTS .67 GASKET FOR 0937 206102 2131-600822 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 11.94 ADHESIVE FOR GASKETS 206102 2131-600822 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 2.12 LIGHT LENS FOR TRAILER 206108 2131-601074 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 331.35- RTRN:ROTOR/BRK PADS/BRK CAL 206231 2131-599189 CR 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 331.35 ACCIDENTAL CHARGE BY CARQUEST 206232 2131-599188 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 14.73 158550 9/16/2022 100011 ANDERSEN,EARL F 173.12 STREET SIGN POST/BRACKET 205942 0130593-IN 1072 6254 SIGNS&STRIPING MATERIALS STREET MAINTENANCE 01000 08 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/27/2022 8:14:23 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 7 9/14/2022 - 9/27/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 173.12 158551 9/16/2022 108446 ASPEN MILLS,INC. 312.18 UNIFORM THAMMER 206094 299593 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 312.18 158552 9/16/2022 118698 AT&T MOBILITY-CITY HALL 370.40 AUG'22 NON-PUBSAFETY DATA SVC 206174 287307208222X090327400 6412 CELLULAR SERVICES INFORMATION TECHNOLOGY 07400 04 022 1,844.57 AUG'22 NON-PUBSAFETY CELL SVC 206174 287307208222X090327400 6412 CELLULAR SERVICES INFORMATION TECHNOLOGY 07400 04 022 2,214.97 158553 9/16/2022 118206 AT&T MOBILITY-PUBLIC SAFETY 1,345.06 AUG22 PUB SAFETY CELL SVC 206173 287307208195X090327400 6412 CELLULAR SERVICES INFORMATION TECHNOLOGY 07400 04 022 1,259.16 AUG'22 PUB SAFETY DATA SVC 206173 287307208195X090327400 6412 CELLULAR SERVICES INFORMATION TECHNOLOGY 07400 04 022 2,604.22 158554 9/16/2022 118155 AV FOR YOU,LLC 1,350.00 AUDIO AND VISUAL MOVIE SERVICE 206329 36270 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 1,350.00 158555 9/16/2022 110290 BOLTON&MENK,INC 3,835.00 MAY-22 SVS:MYST MDW TRL 206328 0291691 5810 6401 PROFESSIONAL SERVICES Trail Maintenance 05810 09 486.00 JUN'22 SVS:MYSTIC MDW TRL 206337 0294100 5810 6401 PROFESSIONAL SERVICES Trail Maintenance 05610 09 4,321.00 158556 9/16/2022 112868 BROADCAST MUSIC,INC 130.33 MUSIC LICENSING ANNUAL FEE 206327 10753354 1093 6460 MEMBER DUES&LICENSURE SENIOR CITIZEN SERVICES 01000 09 130.33 MUSIC LICENSING ANNUAL FEE 206327 10753354 1095 6460 MEMBER DUES&LICENSURE RECREATION PROGRAM SERVIC 01000 09 130.34 MUSIC LICENSING ANNUAL FEE 206327 10753354 2502 6460 MEMBER DUES&LICENSURE ICE ARENA OPERATIONS EXPE 02500 09 391.00 158557 9/16/2022 107730 CENTURY COLLEGE 4,725.00 REGISTRATION FOR FIRE CLASS 206056 1072245 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01000 06 4,725.00 158558 9/16/2022 110511 CHARTER COMMUNICATIONS HOLDINGS,LLC 518.23 AUG'22 CABLE&ALARM LINES 206334 0001792080122 7400 6411 TELEPHONE/CABLE SERVICES INFORMATION TECHNOLOGY 07400 04 518.23 SEPT'22 CABLE&ALARM LINES 206335 0001792090122 7400 6411 TELEPHONE/CABLE SERVICES INFORMATION TECHNOLOGY 07400 04 1,036.46 158559 9/16/2022 100025 CINTAS CORP LOC 754 44.31 AUG'22 WEEKLY UNIFORM SVS 206147 4129975000 6502 6290 UNIFORMS&CLOTHING WATER UTILITY EXPENSE 06500 08 51.69 AUG'22 WEEKLY UNIFORM SVS 206147 4129975000 6402 6290 UNIFORMS&CLOTHING STORM WATER UTILITY OPERA 06400 08 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/27/2022 8:14:23 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 8 9/14/2022 - 9/27/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept Div 51.69 AUG'22 WEEKLY UNIFORM SVS 206147 4129975000 6202 6290 UNIFORMS&CLOTHING SEWER OPERATIONS EXPENSE 06200 08 66.46 AUG'22 WEEKLY UNIFORM SVS 206147 4129975000 1090 6290 UNIFORMS&CLOTHING PARK MAINTENANCE 01000 09 73.85 AUG'22 WEEKLY UNIFORM SVS 206147 4129975000 1072 6290 UNIFORMS&CLOTHING STREET MAINTENANCE 01000 08 288.00 158560 9/16/2022 100030 CORE&MAIN,LP 453.25 HYDRANT TRAFFIC REPAIR KIT 206087 R449594 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 453.25 158561 9/16/2022 100081 DAKOTA COUNTY LUMBER COMPANY 829.28 BOARDS FOR RINK REPAIRS 206223 2209-858761 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 829.28 158562 9/16/2022 101400 DAKOTA UNLIMITED 6,586.00 FENCE FOR K9 SMOKE 206240 3279 2100 6220 EQUIP SUPPLIES&PARTS POLICE FORFEITURES 02100 05 6,586.00 158563 9/16/2022 117201 DIAMOND VOGEL PAINT CENTER- 807 1,649.10 STRIPING PAINT/SPRAYER PARTS 205938 807089898 1072 6254 SIGNS&STRIPING MATERIALS STREET MAINTENANCE 01000 08 1,649.10 158564 9/16/2022 100057 DICK'S SANITATION SERVICE 1,093.47 AUG-22 FAA RECYCLE CHARGES 206154 4805556T460 6302 6560 CONTRACTUAL SERVICES SOLID WASTE OPERATIONS 06300 08 1,093.47 158565 9/16/2022 118859 ENTERPRISE FM TRUST 1,581.38 SEPT'22 PD LEASE PYMT 206241 FBN4556433 5602 6555 RENTAL OF EQUIPMENT GEN CAPITAL EQUIP FUND EX 05600 1,581.38 158566 9/16/2022 109931 FACTORY MOTOR PARTS 140.55 BATTERY FOR 4784 205930 1-Z30184 1060 6230 VEHICLE SUPPLIES&PARTS FIRE SERVICES 01000 06 140.55 158567 9/16/2022 100223 FEDEX 282.93 SHIPPING:WATER SAMPLES 206338 7-876-26645 6502 6445 POSTAGE/SHIPPING FEES WATER UTILITY EXPENSE 06500 08 282.93 158568 9/16/2022 118479 FLAHERTY&HOOD,P.A. 1,612.50 AUG'22 HR SERVICES 206191 20220909 1011 6403 LEGAL HUMAN RESOURCES 01000 04 1,612.50 158569 9/16/2022 100077 FRONTIER COMMUNICATIONS 82.14 SEPT'22ARENAALARMLINE 206142 651-463-3016 2502 6411 TELEPHONE/CABLE SERVICES ICEARENA OPERATIONS EXPE 02500 09 SEPT'22 82.14 158570 9/16/2022 100499 HAKALA,ANNETTE 61.25 AUG'22 MILEAGE REIMB 206157 20220831 HAKALA 7400 6485 MILEAGE REIMBURSEMENT INFORMATION TECHNOLOGY 07400 04 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/27/2022 8:14:23 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 9 9/14/2022 - 9/27/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept Div 61.25 158571 9/16/2022 117645 HARTMAN,KAREN 380.00 WAIT LIST RETURN 206124 091422 1001 4670 RECREATION FEES-SENIOR CTR GENERAL FUND REVENUES 01000 01 380.00 158572 9/16/2022 100007 HAWKINS INC 1,033.67 2 CHLOURINE INJECTORS 206006 6275861 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 1,033.67 158573 9/16/2022 119000 JOHNSON,ANDREW 224.12 REF UTIL CR@512 PINE ST 201374 MN-18088 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 224.12 158574 9/16/2022 114167 JONES&BARTLETT LEARNING,LLC 335.77 FIRE BOOKS 206125 292190 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01000 06 709.65 BUILDING CONST.BOOKS 206126 539222 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01000 06 1,045.42 158575 9/16/2022 118482 MIDWEST MACHINERY CO 19.24 STEERING WHEEL KNOB FOR 0949 206097 9290829 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 19.24 158576 9/16/2022 108724 MIDWEST PLAYSCAPES INC 577.65 PLAYGROUND PARTS 206216 9731 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 577.65 158577 9/16/2022 100153 MINNESOTA STATE FIRE CHIEFS ASSOCIATION 75.00 FIRE TRAILER FOR OPEN HOUSE 206123 20221012 OPEN 1060 6570 PROGRAMMING EXPENSE FIRE SERVICES 01000 06 HOUSE 75.00 158578 9/16/2022 118742 MUNICIPAL EMERGENCY SERVICES,INC 370.00 REPAIRS TO TURNOUT GEAR 206049 IN1754052 1060 6290 1 TURNOUT GEAR FIRE SERVICES 01000 06 370.00 158579 9/16/2022 101254 ORKIN EXTERMINATING,LLC 130.00 AUG'22 PEST CONTROL-RRC 206133 229986628 1090 6515 BUILDING REPAIR/MAINTENANCE PARK MAINTENANCE 01000 09 27.00 AUG'22 PEST CONTROL CMF 206134 229985034 6502 6515 BUILDING REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 38.57 AUG'22 PEST CONTROL CMF 206134 229985034 6402 6515 BUILDING REPAIR/MAINTENANCE STORM WATER UTILITY OPERA 06400 08 19.29 AUG'22 PEST CONTROL CMF 206134 229985034 6202 6515 BUILDING REPAIR/MAINTENANCE SEWER OPERATIONS EXPENSE 06200 08 30.86 AUG'22 PEST CONTROL CMF 206134 229985034 1090 6515 BUILDING REPAIR/MAINTENANCE PARK MAINTENANCE 01000 09 19.28 AUG'22 PEST CONTROL CMF 206134 229985034 1072 6515 BUILDING REPAIR/MAINTENANCE STREET MAINTENANCE 01000 08 265.00 158580 9/16/2022 100093 PELLICCI HARDWARE&RENTAL 7.99 SPRAY PAINT 206128 52692/F'22 1015 6220 EQUIP SUPPLIES&PARTS CITY HALL 01000 01 7.99 FINISHING NAILS 206129 K52734/F 1093 6220 EQUIP SUPPLIES&PARTS SENIOR CITIZEN SERVICES 01000 09 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/27/2022 8:14:23 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 10 9/14/2022 - 9/27/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 7.94 WINDOW SCRAPPER WASP KILLE 206131 K52720/F 1015 6220 EQUIP SUPPLIES&PARTS CITY HALL 01000 01 2.04 WINDOW SCRAPPER WASP KILLE 206131 K52720/F 1060 6220 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 .57 WINDOW SCRAPPER WASP KILLE 206131 K52720/F 1072 6220 EQUIP SUPPLIES&PARTS STREET MAINTENANCE 01000 08 .91 WINDOW SCRAPPER WASP KILLE 206131 K52720/F 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 .45 WINDOW SCRAPPER WASP KILLE 206131 K52720/F 1093 6220 EQUIP SUPPLIES&PARTS SENIOR CITIZEN SERVICES 01000 09 .57 WINDOW SCRAPPER WASP KILLER 206131 K52720/F 1050 6220 EQUIP SUPPLIES&PARTS POLICE ADMINISTRATION 01000 05 .57 WINDOW SCRAPPER WASP KILLE 206131 K52720/F 6202 6220 EQUIP SUPPLIES&PARTS SEWER OPERATIONS EXPENSE 06200 08 1.13 WINDOW SCRAPPER WASP KILLE 206131 K52720/F 6402 6220 EQUIP SUPPLIES&PARTS STORM WATER UTILITY OPERA 06400 08 .80 WINDOW SCRAPPER WASP KILLE 206131 K52720/F 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 19.98 CABLE TIES FOR BANNERS 206132 K52710/F 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 3.89 MARIGOLD BENCH REPAIR 206135 K52697/F 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 68.96 WALLBOARD AND BRACKETS 206138 K52704/F 1093 6220 EQUIP SUPPLIES&PARTS SENIOR CITIZEN SERVICES 01000 09 8.50 BROOM AND DUST PAN 206140 K52770/F 1050 6220 EQUIP SUPPLIES&PARTS POLICE ADMINISTRATION 01000 05 132.29 158581 9/16/2022 118588 PETERSON COMPANIES INC 995.03 2022 POND MNT PAY REQ#2/FINAL 206196 PAY REQ#2/F:'22 6402 7010 CONSTRUCTION CONTRACTS STORM WATER UTILITY OPERA 06400 08 PND MAINT 995.03 158582 9/16/2022 110760 PRO-TECH DESIGN,INC 51.00 TROUBLESHOOT USDA DOOR 206007 106460 7400 6401 PROFESSIONAL SERVICES INFORMATION TECHNOLOGY 07400 04 51.00 158583 9/16/2022 118492 QUALITY LOCKSMITH SERVICE 1,103.12 FSICIPHERLOCK REPLMENT REAR DR 206168 QLS23323 1060 6505 EQUIPMENT REPAIR/MAINTENANCE FIRE SERVICES 01000 06 260.00 REKEY TERRI WILSON DOOR 206169 QLS23325 5811 6515 00430 BUILDING REPAIR/MAINTENANCE Building Maintenance Fund 05811 01 1,363.12 158584 9/16/2022 112632 RICOH USA,INC 572.02 AUG'22 COPIER MAINTENANCE 206172 5065446541 1010 6505 EQUIPMENT REPAIR/MAINTENANCE ADMINISTRATION 01000 01 572.02 158585 9/16/2022 118809 RITE ENTERPRISES,INC 2,060.02 PK HANDHELD SCANNER 206161 T0460001303 6115 6960 FURNITURE,OFFICE EQUIP,IT PILOT KNOB LIQUOR 06100 02 2,060.01 DT HANDHELD SCANNER 206161 T0460001303 6110 6960 FURNITURE,OFFICE EQUIP,IT DOWNTOWN LIQUOR REV&EXP 06100 02 4,120.03 158586 9/16/2022 110022 SCHWICKERT'S TECTA AMERICA,LLC 5,040.00 BEARING REPLACEMENTAIR HANDLE 206249 S510098719 1015 6505 EQUIPMENT REPAIR/MAINTENANCE CITY HALL 01000 01 5,040.00 158587 9/16/2022 118046 SHRED RIGHT 33.00 RRC SHREDAUG 22 206330 583133 4502 6570 PROGRAMMING EXPENSE RRC CAPITAL IMPROVEMENT F 04500 09 33.00 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/27/2022 8:14:23 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 11 9/14/2022 - 9/27/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 158588 9/16/2022 100100 STREICHER'S 1,132.91 NEW HIRE BADGES 206247 11588205 1050 6290 UNIFORMS&CLOTHING POLICE ADMINISTRATION 01000 05 1,132.91 158589 9/16/2022 111333 TITAN ENERGY SYSTEMS,INC 1,143.75 GENERATOR MAINTENACE 206130 201119-027 1015 6515 BUILDING REPAIR/MAINTENANCE CITY HALL 01000 01 1,143.75 158590 9/16/2022 109522 TRISTATE BOBCAT INC 152.84 LAWNMOWER DECK WHEELS 206162 P80163 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 152.84 158591 9/16/2022 113269 UNIVERSITY OF MN,REGENTS OF 260.00 SEPT 6 RANGE USAGE 206242 0430006487 1051 6470 TRAINING&SUBSISTANCE PATROL SERVICES 01D00 05 260.00 158592 9/16/2022 118999 WENDEL ARCHITECTURE 1,050.00 FIRE STATION PLAN 206228 502238 1060 6401 PROFESSIONAL SERVICES FIRE SERVICES 01000 06 1,050.00 158593 9/16/2022 118072 WINSUPPLY LAKEVILLE MN CO. 487.50 LIGHT BULBS 206217 396019 02 1060 6220 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 611.25 LIGHT BULBS 206218 395255 1050 6220 EQUIP SUPPLIES&PARTS POLICE ADMINISTRATION 01000 05 1,098.75 158594 9/23/2022 100058 ADVANCE AUTO PARTS 52.20 BATTERY FOR 0931 206103 2131-601595 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 52.20 158595 9/23/2022 113303 ARTISAN BEER COMPANY 509.60 LIQUOR&SPIRITS ORDER 206371 3556890 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 120.00 BEER ORDER 206424 3557902 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 341.40 BEER ORDER 206430 3558648 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 599.10 BEER ORDER 206473 3558527 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 36.90 BEER ORDER 206474 3558528 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 415.10 BEER ORDER 206544 3559795 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 541.50 BEER ORDER 206589 3559741 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,563.60 168596 9/23/2022 108446 ASPEN MILLS,INC. 34.50 UNIFORM ALLOWANCE GOETEL 206379 299950 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 34.50 158697 9/23/2022 115520 BALD MAN BREWING,INC 244.00 BEER ORDER 206415 E-6491 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 244.00 168698 9/23/2022 118862 BETTER BEV CO LLC R55CKS2 LOGIS600V CITY OF FARMINGTON 9/27/2022 8:14:23 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 12 9/14/2022 - 9/27/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 420.00 BEER ORDER 206562 1183 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 420.00 158599 9/23/2022 117284 BLACK STACK BREWING,INC 567.00 BEER ORDER 206359 16993 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 567.00 158600 9/23/2022 110290 BOLTON&MENK,INC 475.50 JUL'22 SVS:MYSTIC MDW TRL 206336 0295678 5810 6401 PROFESSIONAL SERVICES Trail Maintenance 05810 09 5,933.50 JUL'22 SVS:SAPPHIRE 4TH ADDN 206384 0295683 4600 2256 70408 DEVELOPMENT ESCROWS PRIVATE CAPITAL PROJECTS 04600 07 8,138.00 JUN'22 SVS:SAPPHIRE LK 4TH 206385 0294105 4600 2256 70408 DEVELOPMENT ESCROWS PRIVATE CAPITAL PROJECTS 04600 07 11,558.00 JUN'22 SVS:WHSPRNG FLDS 2ND 206386 0294109 4600 2256 70805 DEVELOPMENT ESCROWS PRIVATE CAPITAL PROJECTS 04600 07 2,663.50 JUL'22 SVS:WHSPRNG FLDS 2ND 206387 0295687 4600 2256 70805 DEVELOPMENT ESCROWS PRIVATE CAPITAL PROJECTS 04600 07 18,287.00 JUL'22 SVS:VRM CMMNS 1STADDN 206388 0295685 4600 2256 71004 DEVELOPMENT ESCROWS PRIVATE CAPITAL PROJECTS 04600 07 3,065.00 JUN'22 SVS:VRM CMMNS 1ST 206389 0294106 4600 2256 71004 DEVELOPMENT ESCROWS PRIVATE CAPITAL PROJECTS 04600 07 11,510.00 JUN'22 SVS:VITA ATTIVA 206393 0294108 4600 2256 70903 DEVELOPMENT ESCROWS PRIVATE CAPITAL PROJECTS 04600 07 7,851.80 JUN'22 SVS:AKIN RD DESIGN 206395 0294099 5702 6401 02201 PROFESSIONAL SERVICES SEALCOATING EXPENSES 05700 69,482.30 158601 9/23/2022 114472 BREAKTHRU BEVERAGE MN BEER,LLC 201.80 BEER ORDER 206404 345486200 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 12,443.05 BEER ORDER 206408 345486199 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 24,373.50 BEER ORDER 206418 345485858 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 44.80 BEER ORDER 206421 345485859 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 80.00- BEER ORDER 206433 410085413 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 3,004.20 BEER ORDER 206442 345577595 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 89.70 BEER ORDER 206445 345577597 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 320.00 BEER ORDER 206446 345577596 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 17,691.85 BEER ORDER 206464 345573278 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 245.70 BEER ORDER 206467 345573275 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 9.50- BEER ORDER CREDIT 206525 410091451CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 16,025.80 BEER ORDER 206552 345666112 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 255.90 BEER ORDER 206566 345666113 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 12,916.60 BEER ORDER 206587 345665672 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 22.00- BEER ORDER CREDIT 206597 410091452 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 87,501.40 158602 9/23/2022 114471 BREAKTHRU BEVERAGE MN WINE&SPIRITS 275.50- LIQUOR&SPIRITS ORDER 206363 410054095 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,230.82 LIQUOR&SPIRITS ORDER 206402 345482651 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 722.15 WINE ORDER 206409 345482652 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,796.27 LIQUOR&SPIRITS ORDER 206419 345483052 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 48.00 LIQUOR SUPPLIES AND MIXES ORDE 206420 345483053 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 647.25 WINE ORDER 206438 345572595 6100 1406 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/27/2022 8:14:23 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 13 9/14/2022 - 9/27/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 385.80 WINE ORDER 206440 345572597 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 2,063.54 LIQUOR&SPIRITS ORDER 206441 345572596 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 161.45 WINE ORDER 206465 345572196 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 647.25 WINE ORDER 206466 345572194 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,058.13 LIQUOR&SPIRITS ORDER 206471 345572195 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 21.00- WINE ORDER CREDIT 206526 410079002 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 126.20- LIQUOR&SPIRITS ORDER CREDIT 206527 409880247 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 167.95- LIQUOR&SPIRITS ORDER CREDIT 206528 409973991 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 127.36- LIQUOR&SPIRITS ORDER CREDIT 206530 410018001CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 4,769.17 LIQUOR&SPIRITS ORDER 206554 345663497 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 709.45 LIQUOR&SPIRITS ORDER 206564 345704584 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 227.25 WINE ORDER 206592 345662901 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 4,254.63 LIQUOR&SPIRITS ORDER 206596 345662900 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 21,005.15 158603 9/23/2022 119004 BRS FIELD OPS LIC 31.50 VOID ELECT PRMT 51884 206501 VOID ELECT PRMT 1000 2020 CONTRACTS PAYABLE GENERAL FUND BALANCE SHEE 01000 51884 20.50 VOID ELECT PRMT 51884 206501 VOID ELECT PRMT 1001 4327 ELECTRIC PERMITS GENERAL FUND REVENUES 01000 01 51884 1.00 VOID ELECT PRMT 51884 206501 VOID ELECT PRMT 1000 2420 BUILDING PERMIT SURCHARGE GENERAL FUND BALANCE SHEE 01000 51864 1.00 VOID ELECT PRMT 51880 206502 VOID ELECT PRMT 1000 2420 BUILDING PERMIT SURCHARGE GENERAL FUND BALANCE SHEE 01000 51880 31.50 VOID ELECT PRMT 51880 206502 VOID ELECT PRMT 1000 2020 CONTRACTS PAYABLE GENERAL FUND BALANCE SHEE 01000 51880 20.50 VOID ELECT PRMT 51880 206502 VOID ELECT PRMT 1001 4327 ELECTRIC PERMITS GENERAL FUND REVENUES 01000 01 51880 20.50 VOID ELECT PRMT 51857 206503 VOID ELECT PRMT 1001 4327 ELECTRIC PERMITS GENERAL FUND REVENUES 01000 01 51857 31.50 VOID ELECT PRMT 51857 206503 VOID ELECT PRMT 1000 2020 CONTRACTS PAYABLE GENERAL FUND BALANCE SHEE 01000 51857 1.00 VOID ELECT PRMT 51657 206503 VOID ELECT PRMT 1000 2420 BUILDING PERMIT SURCHARGE GENERAL FUND BALANCE SHEE 01000 51857 159.00 168604 9/23/2022 108360 CANNON RIVER WINERY 798.00 WINE ORDER 206556 13988 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 798.00 168605 9/23/2022 110611 CHARTER COMMUNICATIONS HOLDINGS,LLC 16.85 SEPT'22 CABLE FD STATION#2 206333 0164297090622 7400 6412 CELLULAR SERVICES INFORMATION TECHNOLOGY 07400 04 16.85 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/27/2022 8:14:23 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 14 9/14/2022 - 9/27/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 158606 9/23/2022 100456 COMMERCIAL ASPHALT COMPANY 1,527.71 ASPHALT 206180 220831 1072 6253 STREET MATERIALS STREET MAINTENANCE 01000 08 1,527.71 158607 9/23/2022 110844 DAKOTA COUNTY FINANCIAL SRVS 6,895.00 3RD QTR 2022 DBB OPER COSTS 206496 00045128 1020 6570 PROGRAMMING EXPENSE DAKOTA BROAD BAND-DBB 01000 6,895.00 158608 9/23/2022 113096 ETERNITY HOMES,LLC 3,000.00 ER 296-15TH ST 206398 ER 296-15TH ST 4600 2255 DEPOSITS PAYABLE PRIVATE CAPITAL PROJECTS 04600 07 3,000.00 ER 344-15TH ST 206499 ER 344-15TH ST 4600 2255 DEPOSITS PAYABLE PRIVATE CAPITAL PROJECTS 04600 07 3,000.00 ER 2790-213TH ST W 206500 ER 2790-213TH ST 4600 2255 DEPOSITS PAYABLE PRIVATE CAPITAL PROJECTS 04600 07 W 9,000.00 158609 9/23/2022 111631 FULL SERVICE BATTERY,INC 3.99 BATTERY 206377 0023721 1072 6220 EQUIP SUPPLIES&PARTS STREET MAINTENANCE 01000 08 13.95 FIRE ALARM BATTERIES 206603 0024290 6502 6240 BUILDING SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 19.93 FIREALARM BATTERIES 206603 0024290 6402 6240 BUILDING SUPPLIES&PARTS STORM WATER UTILITY OPERA 06400 08 9.96 FIRE ALARM BATTERIES 206603 0024290 6202 6240 BUILDING SUPPLIES&PARTS SEWER OPERATIONS EXPENSE 06200 08 15.95 FIREALARM BATTERIES 206603 0024290 1090 6240 BUILDING SUPPLIES&PARTS PARK MAINTENANCE 01000 09 9.96 FIREALARM BATTERIES 206603 0024290 1072 6240 BUILDING SUPPLIES&PARTS STREET MAINTENANCE 01000 08 73.74 158610 9/23/2022 100024 GOPHER STATE ONE-CALL 236.70 AUGUST 2022 LOCATES 206182 2080391 6502 6401 PROFESSIONAL SERVICES WATER UTILITY EXPENSE 06500 08 236.70 AUGUST 2022 LOCATES 206182 2080391 6202 6401 PROFESSIONAL SERVICES SEWER OPERATIONS EXPENSE 06200 08 236.70 AUGUST 2022 LOCATES 206182 2080391 6402 6401 PROFESSIONAL SERVICES STORM WATER UTILITY OPERA 06400 08 710.10 158611 9/23/2022 103373 GRAYBAR ELECTRIC CO INC 1,630.01 STREET LIGHT BALLAST/GLOBE 206086 9328473012 6602 6220 EQUIP SUPPLIES&PARTS STREETLIGHT UTILITY EXPEN 06600 08 1,630.01 158612 9/23/2022 100027 GREAT LAKES COCA-COLA DISTRIBUTION,LLC 651.58 LIQUOR SUPPLIES AND MIXES ORDE 206364 3608217414 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 791.45 POP ORDER 206535 3608217517 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,443.03 158613 9/23/2022 116589 GREATAMERICA FINANCIAL SERVICES 217.85 SEPT'22 POSTAGE METER RENTAL 206331 32405665 1010 6555 RENTAL OF EQUIPMENT ADMINISTRATION 01000 01 217.85 168614 9/23/2022 118267 HAWKE,MICHAEL J 4,848.15 ELEC PRMTS THROUGH 07/31/2022 206521 INV#2022-6 1000 2020 CONTRACTS PAYABLE GENERAL FUND BALANCE SHEE 01000 4,848.15 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/27/2022 8:14:23 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 15 9/14/2022 - 9/27/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 158616 9/23/2022 100074 HOHENSTEINS INC 51.00 BEER ORDER 206344 535681 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 576.00 BEER ORDER 206350 535666 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,472.70 BEER ORDER 206361 535669 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 68.00- LIQUOR&SPIRITS ORDER 206373 535667 CR 6100 1405 10 INVENTORY--DOWNTOWN LIQUOR OPERATIONS 06100 02 624.70 BEER&MIX ORDER 206427 537918 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,424.45 LIQUOR&SPIRITS ORDER 206482 537847 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 546.30 BEER ORDER 206534 540108 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,099.60 BEER ORDER 206585 540101 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 145.20 BEER ORDER 206586 541072 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 5,871.95 168616 9/23/2022 110116 IN-CONTROL,INC 11,620.48 INSTALL NEW SOFT START WELL 6 206236 22158RA-01 6502 6401 PROFESSIONAL SERVICES WATER UTILITY EXPENSE 06500 08 11,620.48 158617 9/23/2022 113439 INDIAN ISLAND WINERY LLC 297.12 WINE ORDER 206563 4692 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 297.12 158618 9/23/2022 101325 JAYTECH INC 2,701.21 COOLING TOWER CHEMICALS 206158 222186 2502 6505 EQUIPMENT REPAIR/MAINTENANCE ICE ARENA OPERATIONS EXPE 02500 09 2,701.21 158619 9/23/2022 100033 JOHNSON BROTHERS LIQUOR COMPANY 1,506.65 WINE ORDER 206339 2125002 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 3,302.75 LIQUOR&SPIRITS ORDER 206340 2125001 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 5.10 LIQUOR&SPIRITS ORDER 206343 2124922 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 965.60 LIQUOR&SPIRITS ORDER 206348 2124927 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,477.73 WINE ORDER 206352 2124931 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,740.32 WINE ORDER 206357 2124928 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,638.65 WINE ORDER 206358 2124925 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,547.32 LIQUOR&SPIRITS ORDER 206362 2124924 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 3,770.28 LIQUOR&SPIRITS ORDER 206365 2124921 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 669.88 WINE ORDER 206366 2125004 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 927.61 LIQUOR&SPIRITS ORDER 206368 2125003 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 101.20 LIQUOR&SPIRITS ORDER 206369 2124929 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 6,546.07 LIQUOR&SPIRITS ORDER 206370 2125000 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 171.40 WINE ORDER 206372 2124930 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 818.70 LIQUOR&SPIRITS ORDER 206426 2131463 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 125.10 LIQUOR SUPPLIES AND MIXES ORDE 206429 2131468 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 345.15 WINE ORDER 206431 2131467 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 809.25 LIQUOR&SPIRITS ORDER 206432 2131466 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 2,504.45 LIQUOR&SPIRITS ORDER 206434 2131462 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/27/2022 8:14:23 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 16 9/14/2022 - 9/27/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 593.29 WINE ORDER 206436 2131464 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 38.13 LIQUOR SUPPLIES AND MIXES ORDE 206437 2131465 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,330.70 LIQUOR&SPIRITS ORDER 206463 2131190 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 97.33- WINE ORDER 206468 217593 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 40.00- WINE ORDER 206469 217592 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 509.80 WINE ORDER 206470 2131192 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 651.34 LIQUOR&SPIRITS ORDER 206475 2131193 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,395.57 WINE ORDER 206476 2131194 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,849.20 LIQUOR&SPIRITS ORDER 206478 2131191 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 15.52- WINE ORDER 206486 217601 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 428.50 WINE ORDER 206489 2131195 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 322.80 WINE ORDER 206542 2135338 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 137.05 LIQUOR&SPIRITS ORDER 206543 2135516 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 700.50 LIQUOR&SPIRITS ORDER 206545 2135329 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 931.10 WINE ORDER 206546 2135512 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,274.02 LIQUOR&SPIRITS ORDER 206547 2135510 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 595.40 LIQUOR&SPIRITS ORDER 206548 2135331 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 573.01 WINE ORDER 206549 2135515 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,323.95 LIQUOR&SPIRITS ORDER 206550 2135514 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 2,260.55 LIQUOR&SPIRITS ORDER 206551 2135511 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 38.70 LIQUOR&SPIRITS ORDER 206559 2135513 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,310.16 WINE ORDER 206570 2135333 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 3,415.36 LIQUOR&SPIRITS ORDER 206571 2135334 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,650.08 LIQUOR&SPIRITS ORDER 206572 2135335 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 700.50 LIQUOR&SPIRITS ORDER 206574 2135330 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 583.11 WINE ORDER 206576 2135336 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 421.69 LIQUOR&SPIRITS ORDER 2D6577 2135332 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 60.00 LIQUOR&SPIRITS ORDER 206578 2135337 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 224.70 LIQUOR&SPIRITS ORDER 206579 2135328 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 54,139.57 168620 9/23/2022 110493 LYNCH,DAVID 257.50 SEPT'22 MILEAGE REIMB 206505 20220916 LYNCH 2502 6485 MILEAGE REIMBURSEMENT ICE ARENA OPERATIONS EXPE 02500 09 257.50 158621 9/23/2022 118927 MENTAL EDGE CONSULTING LLC 60.50 LEARN TO SKATE INSTRUCTOR 206493 2022 SKATE- 2502 6560 CONTRACTUAL SERVICES ICE ARENA OPERATIONS EXPE 02500 09 BURMEISTER 2 60.50 168622 9/23/2022 100166 METROPOLITAN COUNCIL ENVIRO SERVICES 19,880.00 AUG'22 MCES SAC FEES 206391 AUG'22 SAC FEES 6200 2425 MCES SAC(SWR AVAIL CHG) SEWER OPERATIONS 06200 08 198.80- AUG'22 MCES SAC FEES 206391 AUG'22 SAC FEES 6201 5030 SAC CHARGE RETAINER SEWER OPERATIONS REVENUE 06200 08 19,681.20 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/27/2022 8:14:23 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 17 9/14/2022 - 9/27/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept Div 158623 9/23/2022 100095 METROPOLITAN COUNCIL ENVIRONMENTAL SVS 149,085.30 OCT 2022 WASTE WATER MCES FEES 206181 0001145126 6202 6565 MCES FEES SEWER OPERATIONS EXPENSE 06200 08 149,085.30 158624 9/23/2022 100544 MOTOROLA SOLUTIONS INC 4,720.00 SQUAD 23 RADIO 206376 8281414566 5602 6940 50 VEHICLES-POLICE GEN CAPITAL EQUIP FUND EX 05600 4,720.00 158625 9/23/2022 107449 MTI DISTRIBUTING,INC 15,803.00 SPRAY MASTER MAX 7 S#412491200 206165 1361565-00 1090 6950 MACHINERY,EQUIPMENT&TOOLS PARK MAINTENANCE 01000 09 15,803.00- SPRAY MASTER MAX 7 S#412491200 206165 1361565-00 1090 6950 MACHINERY,EQUIPMENT&TOOLS PARK MAINTENANCE 01000 09 15,803.00 SPRAY MASTER MAX 7 S#412491200 206165 1361565-00 6502 6950 MACHINERY,EQUIPMENT&TOOLS WATER UTILITY EXPENSE 06500 08 15,803.00 158626 9/23/2022 106959 MYRON CORPORATION 231.39 2023 CALENDARS 206513 127722676 1010 6210 OFFICE SUPPLIES ADMINISTRATION 01000 01 231.39 158627 9/23/2022 100290 PAUSTIS&SONS WINE COMPANY 397.50 WINE ORDER 206417 176151 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 290.50 WINE ORDER 206423 175872 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 235.00 WINE ORDER 206458 176687 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 614.75 WINE ORDER 206590 177396 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,537.75 158628 9/23/2022 100032 PEPSI COLA COMPANY 176.50 POP ORDER 206411 29314155 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 176.50 158629 9/23/2022 118379 PEQUOD DISTRIBUTING 78.00 BEER ORDER 206355 W-160603 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 324.00 BEER ORDER 206553 W-162300 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 402.00 158630 9/23/2022 100034 PHILLIPS WINE AND SPIRITS,INC 364.52 WINE ORDER 206345 6453468 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,235.41 LIQUOR&SPIRITS ORDER 206346 6453467 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 292.10 WINE ORDER 206354 6453416 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 790.55 LIQUOR&SPIRITS ORDER 206356 6453415 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 44.50 LIQUOR SUPPLIES AND MIXES ORDE 206367 6453469 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 741.96 WINE ORDER 206435 6458026 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 518.06 LIQUOR&SPIRITS ORDER 206443 6458025 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 402.88 WINE ORDER 206479 6457781 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 47.70 LIQUOR SUPPLIES AND MIXES ORDE 206480 6457782 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 936.50 LIQUOR&SPIRITS ORDER 206481 6457780 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/27/2022 8:14:23 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 18 9/14/2022 - 9/27/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 3,277.35 LIQUOR&SPIRITS ORDER 206541 6460867 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 94.20 LIQUOR&SPIRITS ORDER 206557 6461025 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 2,454.94 LIQUOR&SPIRITS ORDER 206558 6461023 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 678.05 WINE ORDER 206560 6461024 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 163.40 WINE ORDER 206573 6460869 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 456.81 WINE ORDER 206575 6460868 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 12,498.93 158631 9/23/2022 110760 PRO-TECH DESIGN,INC 204.88 ANNUALALARM MONITORINGRENEWAL 206176 106622 6115 6505 EQUIPMENT REPAIR/MAINTENANCE PILOT KNOB LIQUOR 06100 02 204.88 ANNUALALARM MONITORING RENEWAL 206176 106622 6110 6505 EQUIPMENT REPAIR/MAINTENANCE DOWNTOWN LIQUOR REV&EXP 06100 02 26.36- 206176 106622 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 383.40 158632 9/23/2022 117905 PRYES BREWING COMPANY LLC 364.00 BEER ORDER 206533 W-43125 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 364.00 158633 9/23/2022 103239 RCM SPECIALTIES INC 173.42 EMULSION 206399 8672 1072 6253 STREET MATERIALS STREET MAINTENANCE 01000 08 173.42 158634 9/23/2022 114619 RED BULL DISTRIBUTION COMPANY,INC 415.68 RED BULL ORDER 206531 5003036307 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 415.68 158635 9/23/2022 100151 SAUBER PLUMBING&HEATING COMPANY 560.00 CURB BOXICURB STOP 206523 23658 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 560.00 158636 9/23/2022 110022 SCHWICKERT'S TECTA AMERICA,LLC 2,930.58 REPAIR WATERHEATER ST 1 206375 S500007914 1060 6505 EQUIPMENT REPAIR/MAINTENANCE FIRE SERVICES 01000 06 2,930.58 158637 9/23/2022 107018 SHAMROCK GROUP 113.05 ICE ORDER 206342 2804645 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 99.60 ICE ORDER 206360 2804643 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 242.40 ICE ORDER 206407 2806975 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 179.30 ICE ORDER 206448 2809519 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 97.90 ICE ORDER 206487 2807130 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 58.70 ICE CUBE ORDER 206532 2809685 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 128.25 ICE CUBE ORDER 206536 2806977 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 220.40 ICE CUBE ORDER 206583 2811739 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,139.60 168638 9/23/2022 112061 SOUTHERN GLAZER'S OF MN R55CKS2 LOGIS600V CITY OF FARMINGTON 9/27/2022 8:14:23 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 19 9/14/2022 - 9/27/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 3,589.52 LIQUOR&SPIRITS ORDER 206347 2252535 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,676.24 LIQUOR&SPIRITS ORDER 206414 2254019 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 4,125.95 LIQUOR&SPIRITS ORDER 206422 2252532 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 2,625.51 LIQUOR&SPIRITS ORDER 206439 2255010 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 210.49 LIQUOR&SPIRITS ORDER 206444 5088222 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 .64 WINE ORDER 206455 5087624 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 .08 LIQUOR&SPIRITS ORDER 206459 5087623 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 847.44 WINE ORDER 206460 2255015 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 5,497.38 LIQUOR&SPIRITS ORDER 206461 2255014 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1.28 WINE ORDER 206462 5087165 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 7,166.67 LIQUOR&SPIRITS ORDER 206569 2257657 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 981.92 WINE ORDER 206594 2257662 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 3,384.67 LIQUOR&SPIRITS ORDER 206599 2257661 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 30,107.79 158639 9/23/2022 100100 STREICHER'S 419.97 NEW HIRE BADGES 206248 11589237 1050 6290 UNIFORMS&CLOTHING POLICE ADMINISTRATION 01000 05 419.97 158640 9/23/2022 118440 SUMMER LAKES BEVERAGE LLC 299.25 LIQUOR&SPIRITS ORDER 206428 4559 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 441.00 LIQUOR&SPIRITS ORDER 206456 4558 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 740.25 158641 9/23/2022 100062 SWEET KNEADS BAKERY 150.00 CUPCAKES ANNIVERSARY 206374 092222 1093 6570 PROGRAMMING EXPENSE SENIOR CITIZEN SERVICES 01000 09 150.00 158642 9/23/2022 119010 TICKAPERSAUD,RUDY 45.00- EXTRA CLEANING CHG ON RENTAL 206378 091722 1001 4972 RENTAL INCOME-RRC GENERAL FUND REVENUES 01000 01 500.00 RRC DEPOSIT REFUND 206378 091722 1000 2255 DEPOSITS PAYABLE GENERAL FUND BALANCE SHEE 01000 455.00 158643 9/23/2022 100334 WINE MERCHANTS 422.52 WINE ORDER 206341 7393443 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 209.70 WINE ORDER 206351 7393426 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 121.70 WINE ORDER 206477 7394466 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 753.92 158644 9/23/2022 100330 WINEBOW 332.19 WINE ORDER 206412 MN00118215 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 332.19 20220907 9/1/2022 112399 DEARBORN LIFE INSURANCE COMPANY 1,446.31 SEPT'22 STD INSURANCE PREMIUM 206193 019839-1 SEP'22 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 1,446.31 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/27/2022 8:14:23 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 20 9/14/2022 - 9/27/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 20220908 9/6/2022 115438 AMERITAS LIFE INSURANCE CORP 5,330.76 SEPT'22 DENTAL INSURANCE 206177 010-44446 SEP'22 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 5,330.76 20220909 9/7/2022 116564 FP MAILING SOLUTIONS/POSTALIA 200.00 POSTAGE FOR POSTAGE METER 206237 11822345 20220906 1050 6445 POSTAGE/SHIPPING FEES POLICE ADMINISTRATION 01000 05 200.00 20220910 9/12/2022 116564 FP MAILING SOLUTIONS/POSTALIA 500.00 POSTAGE METER REFILL 206397 61858118 20220914 1014 6445 POSTAGE/SHIPPING FEES COMMUNICATIONS 01000 01 500.00 20220911 9/15/2022 102160 CARDMEMBER SERVICES 16.02 WHISKEY GIVEAWAY FACEBOOKAD 206115 6133-7247-8/8 6115 6492 ADVERTISING PILOT KNOB LIQUOR 06100 02 16.01 WHISKEY GIVEAWAY FACEBOOKAD 206115 6133-7247-8/8 6110 6492 ADVERTISING DOWNTOWN LIQUOR REV&EXP 06100 02 2.06- 206115 6133-7247-8/8 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 975.00- ELAN POINTS CREDIT 206116 CR REDEEMED 7400 5360 REFUNDS&REIMBURSEMENTS INFORMATION TECHNOLOGY 07400 04 POINTS-8/30 43.94 ZUMBA GOLD AUG 22 206117 3544-6194-8/23 1093 6460 MEMBER DUES&LICENSURE SENIOR CITIZEN SERVICES 01000 09 10.72 CRICUT DESIGN SPACE AUG 22 206118 3544-0696-8/8 1093 6280 BOOKS&SUBSCRIPTIONS SENIOR CITIZEN SERVICES 01000 09 103.50 RRC CRAFT SUPPLIES 206119 3544-5646-8/8 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 3,286.44 SQUAD 23 TOUGHBOOK 206120 0915-4699-8/25 7400 6960 FURNITURE,OFFICE EQUIP,IT INFORMATION TECHNOLOGY 07400 04 .99 CELL PHONE STORAGE AUG 2022 206121 0915-6781-8/8 1014 6412 CELLULAR SERVICES COMMUNICATIONS 01000 01 20.28 GEO CACHE PRIZE CAP 206122 3544-3582-8/9 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 2,520.84 20220912 9/15/2022 108980 MINNESOTA ENERGY RESOURCES CORPORATION 22.32 AUG'22 GAS VERM GROVE LIFT STN 205998 0503080372 AUG'22 6202 6423 NATURAL GAS SEWER OPERATIONS EXPENSE 06200 08 18.00 AUG'22 GAS 208TH ST WARM HOUSE 206145 0506537581 AUG'22 1090 6423 NATURAL GAS PARK MAINTENANCE 01000 09 40.32 20220913 9/16/2022 117633 NOKOMIS ENERGY LLC 5,792.22 AUG-22 ELEC CITYHALL 206159 AOR3YP-2022-08-31 1015 6422 ELECTRIC CITY HALL 01000 01 1,051.99 AUG-22 ELEC RRC 206159 AOR3YP-2022-08-31 1093 6422 ELECTRIC SENIOR CITIZEN SERVICES 01000 09 8,883.91 AUG'22 ELEC ARENA 206159 AOR3YP-2022-08-31 2502 6422 ELECTRIC ICE ARENA OPERATIONS EXPE 02500 09 15,728.12 20220914 9/7/2022 117955 VSP INSURANCE CO. 281.35 SEPT'22 VISION INS PREMIUM 206178 815861499 SEP'22 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 281.35 20220916 9/20/2022 111046 VOYAGER FLEET SYSTEMS INC 90.04 AUG'21 FUEL FLEET 205943 8690882372235 7200 6272 FUEL FLEET OPERATIONS 07200 08 FLEET 1,147.85 AUG-22 FUEL STREET 205944 8690882372235 1072 6272 FUEL STREET MAINTENANCE 01000 08 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/27/2022 8:14:23 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 21 9/14/2022 - 9/27/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div ST/SN 619.31 AUG'22 FUEL WATER 205945 8690882372235 6502 6272 FUEL WATER UTILITY EXPENSE 06500 08 WATER 82.92 AUG'22 FUEL STORM 205946 8690882372235 6402 6272 FUEL STORM WATER UTILITY OPERA 06400 08 STORM 70.00 AUG'22 FUEL RECREATION 205947 8690882372235 1093 6272 FUEL SENIOR CITIZEN SERVICES 01000 09 RECREATION 85.31 AUG'22 FUEL RECREATION 205947 8690882372235 1094 6272 FUEL PARK&RECREATION ADMIN 01000 09 RECREATION 15.41 AUG'22 FUEL BLDG MAINT 205964 8690882372235 BLDG6502 6272 FUEL WATER UTILITY EXPENSE 06500 08 MAINT 22.02 AUG'22 FUEL BLDG MAINT 205964 8690882372235 BLDG6402 6272 FUEL STORM WATER UTILITY OPERA 06400 08 MAINT 11.01 AUG'22 FUEL BLDG MAINT 205964 8690882372235 BLDG6202 6272 FUEL SEWER OPERATIONS EXPENSE 06200 08 MAINT 11.01 AUG'22 FUEL BLDG MAINT 205964 8690882372235 BLDG1050 6272 FUEL POLICE ADMINISTRATION 01000 05 MAINT 8.81 AUG'22 FUEL BLDG MAINT 205964 8690882372235 BLDG1093 6272 FUEL SENIOR CITIZEN SERVICES 01000 09 MAINT 17.61 AUG'22 FUEL BLDG MAINT 205964 8690882372235 BLDG1090 6272 FUEL PARK MAINTENANCE 01000 09 MAINT 11.01 AUG'22 FUEL BLDG MAINT 205964 8690882372235 BLDG1072 6272 FUEL STREET MAINTENANCE 01000 08 MAINT 39.63 AUG'22 FUEL BLDG MAINT 205964 8690882372235 BLDG 1060 6272 FUEL FIRE SERVICES 01000 06 MAINT 154.10 AUG'22 FUEL BLDG MAINT 205964 8690882372235 BLDG1015 6272 FUEL CITY HALL 01000 01 MAINT 5.95 AUG'22 FUEL JANITORIAL 205965 8690882372235 6502 6272 FUEL WATER UTILITY EXPENSE 06500 08 JANITORIAL 8.50 AUG'22 FUEL JANITORIAL 205965 8690882372235 6402 6272 FUEL STORM WATER UTILITY OPERA 06400 08 JANITORIAL 4.25 AUG'22 FUEL JANITORIAL 205965 8690882372235 6202 6272 FUEL SEWER OPERATIONS EXPENSE 06200 08 JANITORIAL 4.26 AUG'22 FUEL JANITORIAL 205965 8690882372235 1050 6272 FUEL POLICE ADMINISTRATION 01000 05 JANITORIAL 3.40 AUG'22 FUEL JANITORIAL 205965 8690882372235 1093 6272 FUEL SENIOR CITIZEN SERVICES 01000 09 JANITORIAL 6.80 AUG'22 FUEL JANITORIAL 205965 8690882372235 1090 6272 FUEL PARK MAINTENANCE 01000 09 JANITORIAL 4.25 AUG'22 FUEL JANITORIAL 205965 8690882372235 1072 6272 FUEL STREET MAINTENANCE 01000 08 JANITORIAL 15.31 AUG'22 FUEL JANITORIAL 205965 8690882372235 1060 6272 FUEL FIRE SERVICES 01000 06 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/27/2022 8:14:23 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 22 9/14/2022 - 9/27/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div JANITORIAL 59.52 AUG'22 FUEL JANITORIAL 205965 8690882372235 1015 6272 FUEL CITY HALL 01000 01 JANITORIAL 1,605.98 AUG'22 FUEL SEWER 205969 8690882372235 6202 6272 FUEL SEWER OPERATIONS EXPENSE 06200 08 SEWER 6,978.94 AUG-22 FUEL POLICE 205977 8690882372235 1051 6272 FUEL PATROL SERVICES 01000 05 POLICE 2,754.70 FUELAUGUST22 205986 8690882372235 1090 6272 FUEL PARK MAINTENANCE 01000 09 PARKS 234.37 AUG'22 FUEL BLDG INSP 205988 8690882372235 BLDG1031 6272 FUEL BUILDING INSPECTIONS 01000 07 INSP 83.69 AUG'22 FUEL CODE ENFORCEMENT 205989 8690882372235 1030 6272 FUEL PLANNING&ZONING 01000 03 PLAN/ZONE 1,077.02 AUG'22 FUEL NAT RES 206046 8690882372235 NAT 1076 6272 FUEL NATURAL RESOURCES 01000 07 RES 125.26 AUG'22 FUEL ENGINEERING 206047 8690882372235 1070 6272 FUEL ENGINEERING SERVICES 01000 07 ENGINNERING 101.56 AUG'22 FUEL ENGINEERING 206047 8690882372235 1031 6272 FUEL BUILDING INSPECTIONS 01000 07 ENGINNERING 1,105.20 AUG-22 FUEL FIRE 206055 8690882372235 FIRE 1060 6272 FUEL FIRE SERVICES 01000 06 16,565.00 20220916 9/20/2022 108980 MINNESOTA ENERGY RESOURCES CORPORATION 48.20 AUG'22 GAS DT LIQ STORE 206084 0731950432 AUG'22 6110 6423 NATURAL GAS DOWNTOWN LIQUOR REV&EXP 06100 02 48.20 20220917 9/20/2022 100394 XCEL ENERGY 213.10 AUG'22 ELEC-321 ELM ST LTS 205936 51-8608862 AUG'22 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 21.72 AUG'22 ELEC-LINDEN ST LFT STN 205937 51-6585658 AUG'22 6202 6422 ELECTRIC SEWER OPERATIONS EXPENSE 06200 08 37.32 AUG'22 ELEC-5262 208TH ST LTS 205939 51-8391412 AUG'22 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 188.71 AUG'22 ELEC-190TH ST BRDG LTS 205940 51-9371130 AUG'22 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 29.19 AUG'22 ELEC-DISTAD PARK WRM HS 205962 51-9027188 AUG'22 1090 6422 ELECTRIC PARK MAINTENANCE 01000 09 490.04 20220918 9/21/2022 100394 XCEL ENERGY 1,555.95 AUG'22 ELEC-DT LIQ STORE 205893 51-0013680782 6110 6422 ELECTRIC DOWNTOWN LIQUOR REV&EXP 06100 02 AUG'22 1,555.95 20220919 9/22/2022 108980 MINNESOTA ENERGY RESOURCES CORPORATION 11.84 AUG'22 GAS IST STREET GARAGE 206143 0505547424 AUG'22 6502 6423 NATURAL GAS WATER UTILITY EXPENSE 06500 08 7.11 AUG'22 GAS 1ST STREET GARAGE 206143 0505547424 AUG'22 6402 6423 NATURAL GAS STORM WATER UTILITY OPERA 06400 08 8.88 AUG'22 GAS 1ST STREET GARAGE 206143 0505547424AUG'22 6202 6423 NATURAL GAS SEWER OPERATIONS EXPENSE 06200 08 9.47 AUG'22 GAS 1ST STREET GARAGE 206143 0505547424 AUG'22 1090 6423 NATURAL GAS PARK MAINTENANCE 01000 09 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/27/2022 8:14:23 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 23 9/14/2022 - 9/27/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 7.70 AUG'22 GAS 1ST STREET GARAGE 206143 0505547424AUG'22 1072 6423 NATURAL GAS STREET MAINTENANCE 01000 08 48.20 AUG'22 GAS PK LIQ STORE 206152 0507026961 AUG'22 6115 6423 NATURAL GAS PILOT KNOB LIQUOR 06100 02 93.20 20220920 9/23/2022 108980 MINNESOTA ENERGY RESOURCES CORPORATION 66.01 AUG'22 GAS CITY HALL 206148 0505346885 AUG'22 1015 6423 NATURAL GAS CITY HALL 01000 01 1,032.54 AUG'22 GAS POLICE DEPT 206504 0505974444AUG'22 1050 6423 NATURAL GAS POLICE ADMINISTRATION 01000 05 1,098.55 Report Totals 852,519.99 iH VALS: OYT ERNHJELM -'�LIEN WONRTE 1 7 CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 FarmingtonMN.gov TO: Mayor, Councilmembers and City Administrator FROM: Justin Elvestad, Fire Chief SUBJECT: Approve Out of State Training- Fire DATE: October 3, 2022 INTRODUCTION I n May the city council approved sending three fire personnel to High Rise Operations Conference in Pensacola, FL December 6th_8th 2022 DISCUSSION After soliciting interested from the department officers it was determinate to send four personnel.The fire department membership voted to fund the fourth person with a donation form relief association the city.The relief association will pay for all expenses except for wages.This is great opportunity for the city to receive additional training from world class instructors for one more firefighter with only the expenses of the wages. BUDGET IMPACT The wages are included in the 2022 budget and will be submitted for reimbursement from the Minnesota Board of Fire Training and Education. ACTION REQUESTED Approve the out of state training for one additional firefighter to the 2022 High Rise Operations Conference at the Hilton Pensacola Beach Gulf Side Convention Center in Pensacola Beach, Florida. CITY OF O 430 Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 Farmington M N.gov TO: Mayor, Councilmembers and City Administrator FROM: Justin Elvestad, Fire Chief SUBJECT: Approve Contract with Soundwave Production- Fire DATE: October 3, 2022 INTRODUCTION The Fire Department provides its services to the Dakota County Fairgrounds for events throughout the year. For the past several years Soundwave Productions has hosted a fall Demolition Derby,this year they have moved their event to the Dakota County Fairgrounds and would like the Fire Departments services at the event in October. DISCUSSION The demolition derby will be held October 7th and 8th 2022 at the Dakota County Fair Grandstand. We will provide fire, rescue, and emergency equipment and personnel to provide fire suppression and first aid services for the event. Soundwave Productions has agreed to pay$1,000 for the fire departments services. BUDGET IMPACT All wages and expenses for the services provided will be covered through contract. ACTION REQUESTED Approve the contract with Soundwave Productions for fire services. ATTACHMENTS: Type Description D Contract Contract i i I i t I ]FIRE,-RESCUT SERVICE AGREEMENT THIS AGREEMENT (the "Agreement") made this.3fday of 2022, by and between the CITY Or FARMINGTON,a Minnesota municipal corporation("City")with i offices at 430 Third Street, Farmington, Minnesota 55024, and JON BAIRD d/b/a SOUNDWA'VE PRODUCTIONS, a sole proprietor ("Host")with offices at 225 Middle Street West, Cannon Falls,Minnesota 55009. k WHEREAS, Host has requested that the City provide special free-rescue and related emergency services to the Subject Property, in particular: s Fire, rescue, and emergency equipment and personnel available to provide fire suppression and first aid emergency services as necessary in conjunction with the grandstand motor events held at the Dakota County Fairgrounds located at 4008 2201h Street West,Farmington,Minnesota 55024 on October 7 and 8,2022. j E NOW THEREFORE,IN CONSIDERATION OF THE MUTUAL COVENANTS SET FORTH HEREIN,THE PARTIES AGREE AS FOLLOWS: E 1. The City will provide the requested service under this Agreement on October 7 and 8,2022, and assume all responsibility for equipment and personnel to be provided, j including,but not limited to,compensation and insurance matters. 2. Host understands that the City will only offer basic first aid unless or until an ambulance service is on site.The City cannot transport persons undergoing medical emergencies. i i 3. Host will compensate the City One Thousand and no/100dis Dollars ($1,000.00) for its service commitment. Said compensation is due and payable by October 31, 2022. i 4. Host agrees to acknowledge both the City of Farmington and the Farmington Fire- Rescue Department as sponsors, i 3 5. If Host requests additional services beyond the grandstand motor events, Host agrees to compensate the City according to the Farmington fee structure in place at the time of the requested services, 6. Host shall obtain the minimum insurance coverage and maintain it at all times throughout the life of the Agreement, with the City endorsed as an additional insured: Bodily Injury: $2,000,000 each occurrence $2,000,000 aggregate,products and completed operations Property Damage: $2,000,000 each occurrence $2,000,000 aggregate 223645v2 Business Automobile Liability(owned,noxi-awned,hired): Bodily Injury&Property Damage: $2,000,000 each occurrence $2,000,000 each accident or $2,000,000 combined single limit CITY Or FARMINGTON By Jos ua or By • U Lynoorski,City Administrator SOUNDWAVE PRODUCTION'S roht Baird 223645v2 SOUND-1 ACORO" CERTIFICATE OF LIABILITY INSURANCE DarE(MMrnorYYVY) 10103/2022 THIS CERTIFICATE IS ISSUED AS A MATTER OF INFORMATION ONLY AND CONFERS NO RIGHTS UPON THE CERTIFICATE HOLDER. THIS CERTIFICATE DOES NOT AFFIRMATIVELY OR NEGATIVELY AMEND, EXTEND OR ALTER THE COVERAGE AFFORDED BY THE POLICIES BELOW. THIS CERTIFICATE OF INSURANCE DOES NOT CONSTITUTE A CONTRACT BETWEEN THE ISSUING INSURER(S), AUTHORIZED REPRESENTATIVE OR PRODUCER,AND THE CERTIFICATE HOLDER, IMPORTANT: If the certificate holder is an ADDITIONAL INSURED, the policy(les) must have ADDITIONAL INSURED provisions or be endorsed. If SUBROGATION IS WAIVED, subject to the terms and conditions of the policy, certain policies may require an endorsement. A statement on this certificate does not confer rights to the certificate holder in lieu of such endorsement(s) PRODUCER 651-480-4636 Co r CT Adam Pettit I Vermillion Insurance AgencyPHONE 651-4804636F 651-437-8455 255 W 33rd Street A1C No Ext: A!C No: Hastings, MN 55033 E-MAIL ADDRFS Adam Pettit I INSURERS AFFORDING COVERAGE NAIC# NsU E :West Bend Mutual Insurance Co. 15350 I E INSURER Soundwave Productions B` Jon Baird INSURER C 225 Middle St W Cannon Falls,MN 55009 INSURER D: —INSURER E INSURER F: COVERAGES CERTIFICATE NUMBER: REVISION NUMBER: THIS IS TO CERTIFY THAT THE POLICIES OF INSURANCE LISTED BELOW HAVE BEEN ISSUED TO THE INSURED NAMED ABOVE FOR THE POLICY PERIOD INDICATED. NOTWITHSTANDING ANY REQUIREMENT,TERM OR CONDITION OF ANY CONTRACT OR OTHER DOCUMENT WITH RESPECT TO WHICH THIS CERTIFICATE MAY BE ISSUED OR MAY PERTAIN, THE INSURANCE AFFORDED BY THE POLICIES DESCRIBED HEREIN IS SUBJECT TO ALL THE TERMS, EXCLUSIONS AND CONDITIONS OF SUCH POLICIES.LIMITS SHOWN MAY HAVE BEEN REDUCED BY PAID CLAIMS. INSR TYPEOFINSURANCE ADDLSUBR POLICY NUMBER POLICY EFF POLICYEXP LIMITS 111118D wvn A rX COMMERCIAL GENERAL LIABILITY1,000,000 EACH OCCURRENCE _ CLAIMS-MADE a OCCUR y B134331-00 1010712022 10/0912022 D3,13EMll ET(EaoccD S 100,000 MED EXP An one erson PERSONAL BADV INJURY 11000,000 GEN1AGGREGATE LIMIT APPLESPER, G AGGREGATE 2'000,000 1:1X POLICY ,P3ECT LJ Loc PRODUCTS-COMPOPAGG 2,000,000 OTHER: COMBINED SINGLE LIMIT AUTOMOBILE LIABILITY ,cideno_ ANY AUTO BODILY INJURY Perperson) OWNED SCHEDULED AIUT050NLY AUTOS BODILY INJURY Perccidenl AUSONLY L $ AUTOS ONLY eOaERYtAMAGE I UMBRELLALIABOCCUR EACH OCCURRENCE EXCESS LIAR HCLAIMS-MADE AGGREGATE $ j DEO RETENTION$ WORKERS COMPENSATION PER OTH- ANDEMPLOYERS'LIABILITY e YIN ANY PROPRIETORIPARTNERIEXECUTNE E.L.EACH (appIM )EXCLUDED? � NfAMdoyNH ; E.L.DISEASE-EA EMPLOYE If yes,describe under DESCRIPTION OF OPERATIONS below E.L.DISEASE-POLICY LIM T DESCRIPTION OF OPERATIONS ILOCATIONS I VEHICLES(ACORD 701,Additional Remarks Schedule,maybe attached If more space Is required) Certificate Holder is also listed as an Additional Insured. E e I i CERTIFICATE HOLDER CANCELLATION { SHOULD ANY OF THE ABOVE DESCRIBED POLICIES BE CANCELLED BEFORE i THE EXPIRATION DATE THEREOF, NOTICE WILL BE DELIVERED IN s ACCORDANCE WITH THE POLICY PROVISIONS. City of Farmington i 430 Third St Farmington,MN 55024 AUTHORIZED REPRESENTATIVE i ACORD 25(2016103) ©'1988-2015 ACORD CORPORATION. All rights reserved. I The ACORD Dame and logo are registered marcs of ACORD I I 1 i CITY OF 0 43o Third St., Farmington, MN 55024 FARMINGTON 651-28o-6800 Farmington MN.gov TO: Mayor, Councilmembers and City Administrator FROM: Kellee Omlid, Parks and Recreation Director SUBJECT: Adopt Resolution Accepting Donation from Immanuel Dental to the Rambling River Center- Parks and Recreation DATE: October 3, 2022 INTRODUCTION Immanuel Dental recently gave a donation to the Rambling River Center. DISCUSSION Immanuel Dental recently made a $100.00 donation to the Rambling River Center for the upcoming breakfast and silent auction fundraiser. The fundraiser will be held Saturday, October 29 from 8 to 11 a.m. at the Rambling River Center. The donated money will be placed in the Rambling River Center's Capital I mprovement Fund, so it may either be used for future building improvements at the Rambling River Center or to purchase new equipment or furniture. Staff will communicate the city's appreciation on behalf of the city council to I mmanuel Dental for this generous donation. BUDGET IMPACT N/A ACTION REQUESTED Adopt the attached resolution accepting the donation of$100.00 from Immanuel Dental to the Rambling River Center. ATTACHMENTS: Type Description ❑ Resolution Donation Resolution RESOLUTION NO. R68-22 ACCEPTING DONATION OF$100.00 FROM IMMANUEL DENTAL 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 3rd day of October 2022 at 7:00 p.m. Members Present: Hoyt, Bernhjelm, Lien, Porter, Wilson Members Absent: None Member Wilson and Member Lien .introduced and seconded the following: WHEREAS, a donation of$100.00 was made by Immanuel Dental 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 $100.00 from Immanuel Dental to the Rambling River Center. This resolution adopted by recorded vote of the Farmington City Council in open session on the 3rd day of October 2022. , yor Attested to the 3 day of October 2022. City qministrator SEAL CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 FarmingtonMN.gov TO: Mayor, Councilmembers and City Administrator FROM: Kellee Omlid, Parks and Recreation Director SUBJECT: Adopt Resolution Accepting Donation from MN Nice Gardens and Landscapes to the Rambling River Center- Parks and Recreation DATE: October 3, 2022 INTRODUCTION MN Nice Gardens and Landscapes recently gave a donation to the Rambling River Center. DISCUSSION MN Nice Gardens and Landscapes recently gave a donation of landscaping to the Rambling River Center in honor of the 40th anniversary celebration. The new landscaping,which includes a magnolia tree, plants, limestone boulders, and mulch is in the front of the Rambling River Center. Staff will communicate the city's appreciation on behalf of the city council to MN Nice Gardens and Landscapes for this generous donation. BUDGET IMPACT N/A ACTION REQUESTED Adopt the attached resolution accepting the donation of landscaping valued at$1,920.00 from MN Nice Gardens and Landscapes to the Rambling River Center. ATTACHMENTS: Type Description ❑ Resolution Donation Resolution RESOLUTION NO. R69-22 ACCEPTING DONATION OF LANDSCAPING FROM MN NICE GARDENS AND LANDSCAPES 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 3rd day of October 2022 at 7:00 p.m. Members Present: Hoyt, Bernhjelm, Lien, Porter, Wilson Members Absent: None Member Wilson and Member Lien introduced and seconded the following: WHEREAS, a donation of landscaping was made by MN Nice Gardens and Landscapes to the Rambling River Center in honor of the 401h anniversary celebration; 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 a landscaping valued at$1,920.00 from MN Nice Gardens and Landscapes to the Rambling River Center in honor of the 40th anniversary celebration. This resolution adopted by recorded vote of the Farmington City Council in open session on the Yd day of October 2022. M r Attested to the 3 day of October 2022. City Admi istrator SEAL CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 + FarmingtonMN.gov _ar TO: Mayor, Councilmembers and City Administrator FROM: Kellee Omlid, Parks and Recreation Director SUBJECT: Adopt Resolution Accepting Donation from The Polka Dots to the Rambling River Center- Parks and Recreation DATE: October 3, 2022 INTRODUCTION The Polka Dots recently gave a donation to the Rambling River Center. DISCUSSION The Polka Dots recently gave a donation of entertainment to the Rambling River Center in honor of the 40th anniversary celebration. The Polka Dots provided entertainment through music and storytelling during the celebration. Staff will communicate the city's appreciation on behalf of the city council to The Polka Dots for this generous donation. BUDGET IMPACT N/A ACTION REQUESTED Adopt the attached resolution accepting the donation of entertainment from The Polka Dots to the Rambling River Center. ATTACHMENTS: Type Description D Resolution Donation Resolution RESOLUTION NO. R70-22 ACCEPTING DONATION OF ENTERTAINMENT FROM THE POLKA DOTS 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 Std day of October 2022 at 7:00 p.m. Members Present: Hoyt, Bernhjelm, Lien, Porter, Wilson Members Absent: None Member Wilson and Member Lien introduced and seconded the following: WHEREAS, a donation of entertainment was made by The Polka Dots to the Rambling River Center in honor of the 40th anniversary celebration;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 a entertainment from The Polka Dots to the Rambling River Center in honor of the 40tn anniversary celebration. This resolution adopted by recorded vote of the Farmington City Council in open session on the 31d day of October 2022. M or Attested to the �3 day of October 2022. City Ad istrator SEAL CITY OF O 430 Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 FarmingtonMN.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: October 3, 2022 INTRODUCTION A donation was recently made to the Rambling River Center(RRC) by Happy Harry's Furniture. DISCUSSION A donation in the amount of$278.60 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,192.07 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$278.60 from Happy Harry's Furniture to the RRC. ATTACHMENTS: Type Description 0 Resolution Donation Resolution RESOLUTION NO. R71-22 ACCEPTING DONATION OF$278.60 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 3rd day of October 2022 at 7:00 p.m. Members Present: Hoyt, Bernhjelm, Lien, Porter, Wilson Members Absent: None Member Wilson and Member Lien introduced and seconded the following: WHEREAS, a donation of$278.60 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 $278.60 from Happy Harry's Furniture to the Rambling River Center. This resolution adopted by recorded vote of the Farmington City Council in o ession on the 3rd day of October 2022. Ma r Attested to the 3 � day of October 2022. E tov 1 City Ad nistrator SEAL CITY OF 0 43o 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: New ERP and Utility Billing Software- Finance DATE: October 3, 2022 INTRODUCTION The city is a member of the LOG IS (Local Government Information Systems) consortium and uses LOGIS for the provision of financial, utility billing and other software and hardware needs. DISCUSSION Over the past 18 months the LOGIS consortium has been working with its membership to research, evaluate, and select a new ERP and Utility Billing software solution to meet the future needs of the membership. The result of this process has been the selection of Oracle Cloud ERP and Sprypoint Cloud Utility Billing software solutions.The selection of these new software solutions will be a significant and operational investment for the city. As part of the process LOGI S has negotiated with the vendors on pricing and in order to secure the best possible price,the LOGI S consortium is asking for a formal 10-year commitment from its members by November 15, 2022 Attached to this memo is a letter dated August 17, 2022 from LOGI S that contains not only costs but also advantages and value added outcomes of this change and a FAQ that answers questions regarding this change. BUDGET IMPACT The budget impact will be significant.There will be an increase in annual costs for the financial software portion (Oracle Cloud ERP) of$57,027 and$9,155 for the Sprypoint Cloud Utility Billing solution.The increase in financial software portion will be absorbed gradually through interdepartmental user fees charged by the IT fund. The utility billing portion will be absorbed by the four utility funds. The implementation costs will be$252,555 for the Oracle Cloud ERP and$109,081 for the Sprypoint Cloud Utility Billing. These costs will not be due until the city begins the implementation process. LOGIS estimates that it will take 4-5 years to implement all members with the new software. It is estimated that the city will be converted in 2-3 years. Staff's recommendation for funding of the implementation costs would be to use one half of the HyVee special assessments for two years to fund the financial software portion. For the utility billing implementation staff recommends using funding from the four utility funds. These costs are based on all of the members committing to the new software solutions. However, if some members opt out or there are new members these costs can change. ACTION REQUESTED Adopt the attached resolution approving the city's 10 year commitment to the new LOGIS ERP and Utility Billing Software applications. ATTACHMENTS: Type Description D Resolution LOGIS ERP Resolution D Backup Material LOGIS August 17,2022 Letter D Backup Material LOGIS ERP FAQs RESOLUTION NO. R72-22 Approving a 10-Yeah Commitment For the LOGIS ERP and Utility Billing Software Applications 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 3rd day of October 2022 at 7:00 p.m. Members Present: Hoyt, Bernhjelm, Lien, Porter, Wilson Members Absent: None Member Wilson and Member Lien introduced and seconded the following: WHEREAS,the City of Farmington is a member of the Local Government Information Systems (LOGIS) association; and WHEREAS,the City of Farmington desires to remain in the LOGIS-supported ERP and utility billing software application systems; and WHEREAS,LOGIS has negotiated new long-term contracts with Oracle Corporation and Spypoint Solutions, Inc.to serve the ERP and utility billing needs of its membership; and WHEREAS, in recognition of the substantial investment and operational impact of implementing a new software system,the City of Farmington acknowledges the benefits of ensuring long-term financial and operational certainty; and WHEREAS,each member participant is asked to adopt a I0-year commitment to secure its ERP and utility billing software pricing and support through LOGIS. NOW, THEREFORE,BE IT RESOLVED, by the City of Farmington,that this resolution affirms our long-term commitment to the LOGIS ERP and utility billing software applications and associated software support effective January 1, 2023 through December 31, 2032. This resolution adopted by recorded vote of the Farmington City Council it ell i the 3rd day of October 2022. My.or Attested to the '-1//day of October 2022. City 4ministrator SEAL 1972 L/CI C 1 S J LOGtL U"iIVER i+ENT IIIII IN I"ONt+tATIC)N SYS T(.M5 1022 eeeed44 rg 50 geaaa oa EzteUe ae August 17, 2022 Dear LOGIS Members, Over the past 18 months LOGIS has been working with its membership to research, evaluate, and select a new ERP and Utility Billing software solution to meet your needs.This featured a member- driven process involving 27 agencies who collectively established software functional requirements and participated in software demonstrations. It also included an 8-member ERP Selection Team to guide and oversee the entire process. We also partnered with the Government Finance Officers Association's Research and Consulting Center to refine the requirements,create the RFP,guide the selection process,and assist on pricing negotiations. We received proposals from the following providers: ■ Advanced Utility Systems ■ Sprypoint ■ Central Square ■ Tyler MUNIS ■ Oracle Fusion ■ Workday After two months of proposal reviews,four weeks of software demonstrations,and several months of follow-up discussions; the Oracle Cloud ERP and Sprypoint Cloud Utility Billing software solutions have been elevated by the ERP Selection Team as the preferred choice—a culmination of over 1,500 collective hours from the membership and LOGIS staff. We recognize that moving to the new systems will require a significant financial and operational investment. To help guide you in this decision, we've compiled a list of advantages and value- added outcomes that accompany these changes. This list is presented in Appendix A. Proposed member costs are included in Appendices B (annual)& C(one-time implementation). We understand that this is a major decision that requires careful consideration.However,to secure your pricing, each member organization will need to provide a formal 10-year commitment by November 15, 2022. Please let us know if you have any questions or concerns regarding the selection process, proposed costs, or formal commitment. We look forward to serving your ERP and utility billing needs moving forward. Sincerely, CJU44 opher K. Mi,Uer To-wya,L. Ku4mu rek Christopher K. Miller Tonya L. Kusmirek LOGIS Executive Director LOGIS Director of Finance & Administration Phone: 763-543-2600 Address: 5750 Duluth Street, Golden Valley, MN 55422-4036 WWW.LOGIS.ORG 1972 </ �1.-T'EIGIS 5S,FMS 2!(]N Y ' 1�L2 L/ele4uttirq 50 ycau oa ExeeUeae Appendix A:Advantages &Value-Added Outcomes Member Advantages General ■ Top-tier software solution with advanced features and capabilities ■ Cloud-based solutions with on-going enhancements and functionality that will meet member needs as they evolve ■ Direct software support from highly-trained LOGIS staff ■ Guaranteed pricing for the next 10 years ■ More competitive price entry points for prospective member participants Oracle ■ Enhanced user experience for financial & human resources staff and workflow and employee self-service capabilities for all employees ■ Improved/added HR functionality over JDE ■ Potential replacement for third-party HR applications such as NEOGOV, Benefits Connect, etc. ■ Fully-integrated HR/payroll/general ledger systems (no more double-entry) ■ Built-in workflow module including accounts payable ■ Built-in budgeting and financial reporting modules/dashboards ■ Separate data and configuration environment for each member Sprypoint ■ Fully-integrated with Oracle general ledger ■ Fully-integrated meter management function ■ Built-in mobile field service: Sprypoint ■ Built-in customer portal/payment solution: Sprypoint ■ Built-in utility billing workflow module ■ Potential replacement for third-party electronic payment solutions ■ State-of-the-art interface/web service capability ■ Embedded business intelligence reporting platform ■ Separate data and configuration environment for each member Member Value-Added Outcomes ■ Volume discount pricing on software solutions ■ Vendor and LOGIS staff implementation services ■ Relationship with vendors managed by LOGIS staff ■ Software evaluation& selection process that featured a collective knowledge-base from 27 member-organizations ■ Free on-site or remote training for system enhancements and staff on-boarding ■ Locally-held user group meetings with over two dozen participating local governments Phone: 763-543-2600 Address: 5750 Duluth Street, Golden Valley, MN 55422-4036 WWW.LOGIS.ORG 1972 �aGis �Lac..� envcx�rner+r IN F'ONMAiI CJN vYSTE MS 2022 e[le�tgturg 50 Beau a6$xeelluae Appendix B: Member Annual Costs Oracle Fusion Cloud ERP Current NEW ERP Cost(estimated) Fin/HR/Pay Oracle LOGIS Total $ Member Cost Cost Cost Cost Change NW Community TV $ 16,255 $ 50,886 $ 11,858 $ 62,745 $ 46,490 DCC 18,190 50,886 13,270 64,156 45,966 SW TRANSIT 18,555 50,886 13,536 64,423 45,868 MN VALLEY TRANSIT 27,410 50,886 19,996 70,882 43,472 WACONIA 36,860 50,886 26,890 77,776 40,916 RAMSEY 66,855 50,886 48,772 99,658 32,803 NEW HOPE 74,665 50,886 54,470 105,356 30,691 S.ST PAUL 77,655 50,886 56,651 107,537 29,882 AUSTIN 83,350 80,886 60,806 141,692 58,342 CRYSTAL 86,470 80,886 63,082 143,968 57,498 FARMINGTON 88,210 80,886 64,351 145,237 57,027 WHITE BEAR 95,750 80,886 69,852 150,738 54,988 GOLDEN VALLEY 104,680 80,886 76,366 157,253 52,573 SHAKOPEE 129,835 80,886 94,717 175,604 45,769 RICHFIELD 141,695 80,886 103,370 184,256 42,561 EDEN PRAIRIE 138,795 114,636 101,254 215,890 77,095 BROOKLYN CENTER 149,690 114,636 109,202 223,838 74,148 LAKEVILLE 152,785 114,636 111,460 226,096 73,311 APPLE VALLEY 155,120 114,636 113,163 227,800 72,680 COON RAPIDS 167,655 114,636 122,308 236,944 69,289 MINNETONKA 184,490 114,636 134,589 249,226 64,736 ST LOUIS PARK 201,210 114,636 146,787 261,423 60,213 EAGAN 216,965 114,636 158,281 272,917 55,952 MAPLE GROVE 251,770 114,636 183,672 298,308 46,538 $2,684,915 $2,005,020 $1,958,704 $3,963,724 $1,278,809 Notes: ■ Current financial, HR, &payroll costs are based on members' 2023 budget amounts. ■ Oracle costs includes annual licensing, software enhancements &upgrades, and data hosting. Oracle costs will remain fixed for 2023-2027, followed by a 2% annual increase from 2028-2032. ■ LOGIS costs include all software support and training. Inflationary-type increases are projected in 2024-2032. ■ `$ change' column represents the difference between the new ERP system cost and your current cost with JDE+add-ons. ■ Oracle Fusion ERP system modules are tightly integrated and cannot be priced separately. Oracle pricing includes all system components including financial, HR, payroll,workflow tools, and advanced reporting tools. Phone: 763-543-2600 Address: 5750 Duluth Street, Golden Valley, MN 55422-4036 WWW.LOGIS.ORG 1972 <LLE1131S/f / LOCAL Gr' fN!'f.113MAYCI11OENRNSMYIS NTTE;*15 24122 ed"-a-q 50 years o6�ztcl(eaa Appendix B: Member Annual Costs Sprypoint Cloud Utility Billing Current NEW Utility Billing Cost(estimated) Utility Billing Sprypoint LOGIS Total $ Member Cost Cost Cost Cost Change NEW HOPE $ 69,640 $ 27,824 $ 36,689 $ 64,513 $ (5,127) S.ST PAUL 69,710 33,372 36,726 70,098 388 FARMINGTON 51,620 33,580 27,195 60,775 9,155 GOLDEN VALLEY 69,760 35,620 36,752 72,372 2,612 CRYSTAL 69,905 36,888 36,828 73,716 3,811 WHITE BEAR 69,725 37,900 36,734 74,634 4,909 BROOKLYN CENTER 92,049 41,160 48,494 89,654 (2,395) RICHFIELD 84,830 48,480 44,691 93,171 8,341 ST LOUIS PARK 103,505 60,852 54,530 115,382 11,877 APPLE VALLEY 116,240 71,096 61,239 132,335 16,095 MINNETONKA 116,320 74,572 61,281 135,853 19,533 EDEN PRAIRIE 134,395 88,032 70,804 158,836 24,441 EAGAN 132,130 88,312 69,611 157,923 25,793 COON RAPIDS 132,130 90,500 69,611 160,111 27,981 LAKEVILLE 116,320 98,996 61,281 160,277 43,957 MAPLE GROVE 132,130 103,744 69,611 173,355 41,225 WOODBURY 132,130 107,092 69,611 176,703 44,573 $1,692,539 $1,078,020 $ 891,687 $1,969,707 $ 277,168 Notes: ■ Current utility billing costs are based on members' 2023 budget amounts. ■ Sprypoint costs includes annual licensing, software enhancements &upgrades, and data hosting. Sprypoint costs will increase 5%annually from 2024-2032. ■ LOGIS costs include all software support and training. Inflationary-type increases are projected in 2024-2032. ■ LOGIS costs include all software support and training. ■ `$ change' column represents the difference between the new utility billing system cost and your current cost with CIS Infinity(Advanced). ■ Pricing includes all system components including billing &payments, meter management, and mobile field service. Phone: 763-543-2600 Address: 5750 Duluth Street, Golden Valley, MN 55422-4036 WWW.LOGIS.ORG 1972 LOGIS /l0[:♦4. C:OVEit tw Mf NT III INFtiik�IATt(]NSYS'TEMu 2022 4eW'4&kf 50 5- Mr-Appendix C: Member Implementation Costs Oracle Fusion Cloud ERP Impl. Member Cost est. NW Community TV $ 158,885 DCC 158,885 SW TRANSIT 158,885 MN VALLEY TRANSIT 158,885 WACONIA 158,885 RAMSEY 15 8,8 85 NEW HOPE 158,885 S.ST PAUL 158,885 AUSTIN 252,555 CRYSTAL 252,555 FARMINGTON 252,555 WHITE BEAR 252,555 GOLDEN VALLEY 252,555 SHAKOPEE 252,555 RICHFIELD 252,555 EDEN PRAIRIE 3 57,93 5 BROOKLYN CENTER 357,935 LAKEVILLE 357,935 APPLE VALLEY 357,935 COON RAPIDS 357,935 MINNETONKA 357,935 ST LOUIS PARK 357,935 EAGAN 357,935 MAPLE GROVE 357,935 $ 6,260,380 Notes: ■ Software implementation involves one-time costs that will be pro-rated and paid at various milestones throughout the process. ■ Implementation services will be conducted jointly by the software provider and LOGIS. Phone: 763-543-2600 Address: 5750 Duluth Street, Golden Valley, MN 55422-4036 WWW.LOGIS.ORG 1972 YOGIS / I gGo[]t. Gb hMINT I' NFHMATIt1C]'"ST'S G022 (�loGTQZtKy.�yeazd Od Ezceflerec Appendix C: Member Implementation Costs Sprypoint Cloud Utility Billing Impl. Member Cost est. NEW HOPE $ 109,081 S.ST PAUL 109,081 FARMINGTON 109,081 GOLDEN VALLEY 109,081 CRYSTAL 109,081 WHITE BEAR 109,081 BROOKLYN CENTER 109,081 RICHFIELD 109,081 ST LOUIS PARK 109,081 APPLE VALLEY 156,184 MINNETONKA 156,184 EDEN PRAIRIE 156,184 EAGAN 156,184 COON RAPIDS 156,184 LAKEVILLE 156,184 MAPLE GROVE 156,184 WOODBURY 156,184 $ 2,231,200 Notes: ■ Software implementation involves one-time costs that will be pro-rated and paid at various milestones throughout the process. ■ Implementation services will be conducted jointly by the software provider and LOGIS. Phone: 763-543-2600 Address: 5750 Duluth Street, Golden Valley, MN 55422-4036 WWW.LOGIS.ORG 1971 v LlD C 15 2022 ERP and Utility Billing Software FAQ's M d,aruq 501/--4£xce&— General Questions Q: Why are the existing JDE and CIS Infinity software systems being replaced? A: Over the past several years, members have increasingly expressed frustration with JDE's HR module and the need to utilize a number of third-party add-ons to make the software operationally viable. There was a strong desire to bring in a modern application that can meet members' everyday needs and position ourselves better for the future. Similarly,the CIS Infinity application is two major versions behind its latest software version which require a significant change to all participating members. In addition,the entry price point for this application was cost-prohibitive for most local governments and we haven't been able to secure a new member participant in ten years. Q: Is there a sunset(end-of-life) date for the existing JDE or Advanced Utility System software? A: No, neither solution has not announced an end-of-life date. However,these systems no longer reflect the vendor's preferred solution which means they're unlikely to get any significant upgrades or enhancements moving forward,other than those that are required to meet federal or state-mandated requirements and to address data security concerns. Q: Why is a 10-year commitment necessary? A: LOGIS Staff negotiated a 10-year price commitment to provide the membership with greater certainty over the expected minimum life of the new systems. This not only resulted in a lower overall cost to the membership, but it allows a lower entry price point for prospective members to join LOGIS and reduce overall costs moving forward. In the absence of a 10-year commitment, vendors will re-price (i.e. increase)their offering and reduce the price guarantees. This will significantly reduce our ability to control long- term costs. Q: How long will we continue to pay the `old' pricing for the legacy systems compared to the `new' pricing for Oracle and Sprypoint? A: You will continue to pay for the existing legacy systems and their price points (see the 2023 budget amounts depicted in the ERP Member Letter dated August 17, 2022) until you fully migrate to the new applications. At that time, you will begin paying the costs for the new systems. Keep in mind that if you decide to continue storing and accessing your financial, payroll, and HR data in Hubble(JDE add-on); we will need to continue charging you for that. During the migration, LOGIS staff will be supporting both the legacy and new systems simultaneously. Depending on the pace at which the membership moves to the new system, and the support needs of the new system, we may hire additional temporary staff to assist with the transition. WWW.LOGIS.ORG LOGIS 2022 ERP and Utility Billing N� /-1 sM5"F2022 Software FAQs Q: What cash reserves does LOGIS have for system development charges? A: We currently have approximately$1.7 million in system development charges for the ERP and utility billing software systems, and they are available to help offset some of the costs of migrating to the new systems. LOGIS Staff recommend that the funds be used to pay for limited-term employees to help with supporting legacy software systems which will allow on-going employees to focus on member implementations and supporting the new systems. Further discussions with the members will be needed to determine if other uses of the funds would be appropriate at this time. These funds may also be needed to help offset the costs to build the implementation templates which must be paid before any implementations can begin. Q: Will LOGIS be looking to have all members adopt a standard chart of accounts? "Added 9/19/2022 A: We're recommending that a standard chart of accounts and account-code structure be used by the members. This approach allows us to utilize templates that can be replicated for each member implementation; which saves everyone time and money. It also allows our support staff to more effectively build and share custom reports and troubleshoot any software issues that may arise. Q: Is there a distinction between support and customization/configuration? "Added 9/19/2022 A: SaaS software applications including the selected Oracle and Sprypoint solutions are specifically designed with standardized functions and processes. Customization opportunities are generally limited, but members will have the ability to create unique reports and personalized dashboards. All report-building and guidance provided by LOGIS are included in the reported support costs. Q: Will Oracle or Sprypoint come with a test environment? "Added 9/19/2022 A: LOGIS Staff will have access to a test environment which will allow us to test any custom reports or personalized dashboards that we build. However,we will not have the ability to do any advanced testing on software enhancements that are released by the vendors. We will be relying on their testing procedures to verify that the enhancements work. We do not expect this to present a big challenge as the software will lack the types of customizations that would normally require individualized software updates and review. WWW.LOGIS.ORG > 2022 ERP ,and Utility Billing �,�L❑ CIS LOCM. GGVENNMEHT Software FAQ's eeCeGaatieq 501teuae as£udlaree Pricing & Cost Questions Q: How will the existing costs change as members migrate to the new system or away altogether? A: Each year, LOGIS will recalculate the costs depending who remains on the legacy systems and who has migrated to the new system. If we experience a net loss of members,those members' costs will be redistributed proportionally to the remaining members Alternatively, the members could request a reduction in support to keep their costs unchanged. Q: What happens to the pricing if some members choose to leave LOGIS? A: The pricing is based on all existing members migrating to the new systems. If some choose not to migrate,the pricing could be negatively impacted as the vendor would no longer have the same financial certainty. However, we do not know how many could leave before the pricing is impacted. This is why each member organization is asked to commit by November 15 in order for us to lock in the prices. It is our hope that if a few existing members do choose to leave, that we can bring new members in to replace them. We currently have about a half-dozen agencies that have expressed an interest in potentially joining LOGIS when the new systems are available. Q: What happens if new members join after we implement the new system? A: Once the new system is fully implemented a new pricing model will be in effect. Each new member would be asked to pay their proportionate share and the costs could drop for all other participants holding all other factors constant. Q: What is included in the LOGIS costs? A: LOGIS costs include all software support and training. This includes all personnel and a proportionate amount of overhead costs for the ERP application. These costs are expected to rise at an inflationary amount each year, unless members request a different level of service. They will also change based on the number of members that subscribe to our services. Q: What are the support costs per call/ticket? A: LOGIS support costs are based on each member's proportional amount of utilization (i.e. transactions and FTE's) as defined in current cost allocation method. You are not charged per call/ticket. WWW.LOGIS.ORG iLOCI 5 2022 ERP and Utility Billing •'` � Software FAQs ecld�aruy so 2�ls 4 EwMK« Q: How does the vendor pricing compare to their open market price? A: The pricing we received are based on negotiated volume-discounted pricing based on our existing members. There is no way to determine what the `market' price will be for an individual member agency, because the individual circumstances would be different. Each member would have to independently seek vendor pricing to determine what their price would be outside of the LOGIS consortium. WWW.LOGIS.ORG 91: LO - I S 2022 ERP and Utility Billing 1 / 2022 Software FAQs Software-as-a-Service (SaaS) Questions Q: What is included in the vendor's SaaS costs? A: The annual SaaS costs includes software licensing, enhancements& upgrades, and data hosting. The vendors have not provided a breakdown between these cost categories. Q: When do we start paying SaaS costs? A: Your annual SaaS costs will begin during the year you go live. Q: What access does LOGIS have to vendor's SaaS environment? A: None. Unlike our current arrangement with JDE where the software was acquired,the proposed vendor solutions are proprietary and subscription based; and LOGIS does not have access to the source code. LOGIS' access in the new systems will be for data management purposes only. Q: How often and who is responsible for version upgrades & enhancements? A: The vendors typically provide quarterly upgrades or enhancements,which will be announced in advanced. Those upgrades and enhancements will be made based on customer input and feedback, federal and state mandated requirements, and data security needs. Q: Does LOGIS still provide software support? "Added 9/19/2022 A: YES, LOGIS will still be your software support provider. We will contact the vendors if an issue arises that we cannot fix on our own. WWW.LOGIS.ORG _e `L0 G I S 2022 ERP and Utility Billing /LGGAL GGVE(iNMENTAIg 2022 Software FAQ's (;ccca.4GlLitg$0�i'Ktd Od G�kCCUE.tGI Implementation Questions Q: What is included in the implementation costs? A: This includes the costs associated with the vendors creating the software templates that will be used to convert your data from the legacy systems into the new ones. It also includes the actual data migration. They represent one-time costs that are separate from the SaaS costs. Q: When do we start paying implementation costs? A: Implementation costs are payable at various milestones once the implementation is initiated. The membership has not discussed alternative terms, but LOGIS could borrow money to pay for the implementation in lieu of a direct payment by each member. However, this will require some sort of assessment being levied back against that member which would increase your overall cost. Keep in mind,that LOGIS does not have the legal ability to issue a debt instrument on its own. A member organization will need to pledge its bond authority for this purpose. Q: Do implementation costs decrease as LOGIS takes over? A: No,the implementation costs already factor in the expected labor sharing distribution Between the vendors and LOGIS. The vendors will be taking the lead on the first cohort of installs with LOGIS assuming a greater role in subsequent installs. Q: What amount of member staff time will be needed during the implementation? "Added 9/19/2022 A: Each member's circumstances will dictate the amount of resources you will need to commit to this process—and it could be substantial. Members will be responsible for validating your data once it's migrated into the new system; which includes verifying beginning account balances and data for employees, vendors, and customers. Members are also encouraged to conduct small-batch test runs on regular processes such as payroll,journal entries, A/P, A/R, cash receipts, and utility billing to verify that the implementation was successful. This includes testing the interfaces you may have including payment platforms, and imports from your meter-reading system. WWW.LOGIS.ORG