Loading...
HomeMy WebLinkAbout12.07.20 Council Packet CITYOF Meeting Location: FARMINGTON Farmington City Hall 430 Third Street aa�k. Farmington, MN 55024 CITY COUNCIL REGULAR MEETING AGENDA December 7, 2020 7:00 P.M. Action Taken 1. CALL TO ORDER 7.00 P.M. 2. PLEDGE OFALLEGIANCE 3. ROLL CALL 4. APPROVE AGENDA 5. ANNOUNCEMENTS/COMMENDATIONS a) Recognition of Outgoing City Councilmembers Recognized b) Dakota County Commissioner Mike Slavik Information Received 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 Minutes of the November 16, 2020, City Council Meeting— Administration Approved b) Approve Various License and Permit Renewals for 2021 —Community Development Approved c) Adopt Resolution Approving Polling Locations for 2021 —Community Development R53-20 d) Adopt Resolution Accepting a Monetary Donation from the Farmington Firefighters Relief Association—Fire R54-20 e) Approve Policies and Procedures for Federal Awards Administration- Finance Approved f) Approve Bills - Finance Approved REGULAR AGENDA 8. PUBLIC HEARINGS a) 2021 License Renewals Approved b) Adopt Resolution Vacating Certain Sanitary and Storm Sewer Easements R55-20 9. AWARD OF CONTRACT a) Schmitz-Maki Arena Pressure Relief Valve Replacement and Top End Overhaul of Compressor#2 Project Approved 10. PETITIONS,REQUESTSAND COMMUNICATIONS 11. UNFINISHED BUSINESS 12. NEW BUSINESS a) Adopt Resolution 2021 Final Budget and Tax Levy R56-20 b) Pandemic Response Update Information Received 13. CITY COUNCIL ROUNDTABLE 14. ADJOURN CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 OFarmington MN.gov TO: Mayor, Councilmembers and City Administrator FROM: David McKnight, City Administrator SUBJECT: Recognition of Outgoing City Councilmembers DATE: December 7, 2020 INTRODUCTION After each election the city takes time to recognize the service of city councilmembers whose terms are coming to an end. DISCUSSION We will take time at the meeting to recognize the service of the following members- Councilmember Robyn Craig who served from 2017 through 2020 Councilmember Terry Donnelly who served from 2009 through 2020 Mayor Todd Larson who served from 2009 through 2020 BUDGET IMPACT NA ACTION REQUESTED Please take the time to thank these members for their service to the City of Farmington. CITY OF 0 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 OFarmington M N.gov TO: Mayor, Councilmembers and City Administrator FROM: David McKnight, City Administrator SUBJECT: Dakota County Commissioner Mike Slavik DATE: December 7, 2020 INTRODUCTION Dakota County Commissioner Mike Slavik will be in attendance at the December 7, 2020 city council meeting to provide an update on county activities and issues. DISCUSSION NA BUDGET IMPACT NA ACTION REQUESTED Hear the update provided by Commissioner Slavik and ask any questions you may have. CITY OF 0 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 OFarmington MN.gov TO: Mayor, Councilmembers and City Administrator FROM: David McKnight, City Administrator SUBJECT: Approve Minutes of the November 16, 2020 City Council Meeting-Administration DATE: December 7, 2020 INTRODUCTION Attached for your review are the minutes of the November 16, 2020 city council meeting. DISCUSSION NA BUDGET IMPACT NA ACTION REQUESTED Approve the minutes of the November 16, 2020 city council meeting. ATTACHMENTS: Type Description D Cover Memo November 16, 2020 Minutes CITY OF FARMINGTON CITY COUNCIL MINUTES REGULAR MEETING NOVEMBER 16, 2020 1. Call to Order Mayor Larson called the meeting to order at 7:00 p.m. 2. Pledge of Allegiance Mayor Larson led those in attendance in the Pledge of Allegiance. 3. Roll Call Present-Larson, Bernhjelm and Hoyt Absent-Craig and Donnelly Staff Present-Administrator McKnight, Finance Director Malecha, Parks and Recreation Director Distad and Attorney Jamnik 4. Agenda Motion by Bernhjelm, second by Hoyt,to approve the agenda as presented. APIF, motion carried. S. Announcements/Commendations None 6. Citizen Comments None 7. Consent Agenda Motion by Hoyt, second by Bernhjelm, to approve the following consent agenda items as amended with Mayor Larson pulling item 7k: a) Approve Minutes of the October 19, 2020 City Council Meeting-Administration b) Approve Minutes of the November 12, 2020 Special City Council Meeting- Administration c) Approve Minutes of the November 12, 2020 City Council Work Session-Administration d) Approve Recycling Contract Extension with Dick's Sanitation Inc.-Public Works November 16,2020 Minutes - 1- e) Adopt Resolution R49-2020 Approving a Master Agreement with the Minnesota Department of Transportation-Public Works f) Approve Community Waste Abatement Grant Agreement-Public Works g) Adopt Resolution R50-2020 Accepting a $500 Donation from the Farmington Sons of the American Legion to the Rambling River Center-Parks h) Approve a Right-of-Way Encroachment Agreement with East Farmington Homeowners Association-Community Development i) Approve Community Solar Garden Subscription Agreements-Nokomis Energy Garden Conditions-Community Development j) Adopt Resolution R51-2020 Approving a Gambling Event Permit for the Farmington Volleyball Club-Community Development Appreve 2021NeR BargaiRiRg Cernpensatiep-Hiwmian Reseurses 1) Approve 2021 Firefighter Compensation-Human Resources m) Approve 2021 Seasonal Compensation-Human Resources n) Approve Seasonal Hiring-Human Resources o) Approve Participation in the Dakota County SHIP Worksite Wellness Grant Program- Human Resources p) Acknowledge Financial Review for the Quarter Ending September 2020-Finance q) Approve Bills-Finance APIF, motion carried. Motion by Hoyt, second by Bernhjelm, to approve Resolution R52-2020 approving the 2021 Non-Bargaining Compensation. Voting Yea-Bernhjelm and Hoyt. Abstaining-Larson. Motion approved 2-0 with one abstention. 8. Public Hearings a) 2021 Fee Schedule Finance Director Malecha reviewed with the city council the draft 2021 fee schedule. The following summary of changes were reviewed with the city council at the November 2020 work session: • Fire o A fee of$150 per response for nuisance or unintentional alarms allows us to charge for someone working on an alarm or sprinkler system and fails to put the system in test mode and initiates a fire response. If the person puts the system in test mode it does not initiate a fire response. This fee to assist in eliminating false alarms that can be avoided. o The addition of the aerial ladder truck charge is recommended to be added at $525 per hour for non-contracted services. The rate is comparable to other area cities. November 16,2020 Minutes -2- o The addition of a temporary tent permit of$40 is recommended. It is currently charged, but not listed on the fee schedule. o The verbiage has been updated from Fire Sprinkler System to Fire Suppression System. The charges have not changed. o Addition of the Complaint, Requested, or Routine Fire Life Safety Inspection - Initial and Follow-up is recommended at no charge. On any fire inspection after the initial inspection the responsible party will receive a written corrections letter with any code violations and time frame for corrections. The letter contains a re-inspection date and time for a follow-up inspection. Any inspections after this requires a re-inspection and fee that is listed separately in the fee schedule. • Parks and Recreation (Rambling River Center Rental Rates) o An increase in annual membership from $37 to $38 for an individual is recommended. Additional programs have been added at no cost to members. • Parks and Recreation (Schmitz-Maki Arena Rates) o Staff is recommending increasing the advertising rates $10 per year at the arena. There is a discounted rate if a business chooses to do a three-year advertisement. However, it must be paid in full up front. o An increase of$5 per hour in ice rental rates is recommended to help cover operational and maintenance costs. o An increase to the cost of skate sharpening to $4 per pair or$35 per 10 pairs is proposed by staff. • Permits - Building (General) o An addition of a $10 fee for cancelled permits is recommended. Currently, when an epermit is pulled the city incurs credit card fees. When the permit is cancelled and refunded the city has lost administrative time and the money charged for the credit card fees. • Utility Service Connection Permits o The city WAC fee is proposed to increase based on an estimated 2 percent construction cost index increase. • Platting Fees, Escrows, & Sureties (Area charges to support development) o The Sanitary Sewer Trunk Area Charge, Sealcoating Fee, Surface Water Management Fee, Surface Water Quality Management, Water Trunk Area Charge, and Park Development Fee are proposed to increase based on an estimated 2 percent construction cost index increase. • Water Tower Communication Devices (Base Lease Rate and Additional Antenna and Space Rental Lease) o These fees are proposed to increase 5 percent annually to align with the 5 percent annual increase included in our existing leases. • Utility Charges and Fees-The CIP for the utility enterprise funds was reviewed at the October 12th work session. These funds support the ongoing operations as well as capital replacement projects of the three major utilities. o Water-There is no increase proposed for this fund. November 16, 2020 Minutes -3- o Sanitary Sewer-An increase of 4 percent to the base fee and volume charges are being proposed this evening. There was no increase in 2020. o Storm Water-There is no increase proposed for this fund. • Other o Removal of Solid Waste Collection (See Schedule Q. Schedule C was consolidated with the main fee schedule in 2020. • Solid Waste Charges and Fees o The proposed rate increase for 2020 is 5 percent. o An increase of$5 for the per trip charge to empty a temporary 300 gallon container is proposed. With the increase, the charge would be consistent with a return collection trip charge. o An increase in the time limit for residential rolloffs from 1 week to 2 weeks is proposed. o Recommended changes to the commercial rolloffs include increasing 5 percent per load to $150.15 and decreasing the disposal per ton cost to $128. Mayor Larson opened the public hear. No one in attendance wished to speak. Motion by Bernhjelm, second by Hoyt, to close the public hearing. APIF, motion carried. Motion by Hoyt, second by Bernhjelm, to approve Ordinance No. 2020-752 establishing charges and fees for licenses, permits or other city approvals and services for calendar year 2021. APIF, motion carried. 9. Award of Contract a) Replacement of Zamboni Batteries Parks and Recreation Director Distad presented the city council with bids to replace the Zamboni batteries. The existing batteries are original to the purchase of the Zamboni in 2016. These batteries have a four to five year life expectancy. The current batteries do not hold a charge. Staff contacted R and R Specialties to receive a quote on the cost to have the batteries replaced. The quote received was $9,500. This is the price that staff estimated for this purchase. Motion by Bernhjelm, second by Hoyt, to approve an agreement with R and R Specialties in the amount of$9,500 to replace the Zamboni batteries and clean and inspect the electric motor and authorize Mayor Larson and Administrator McKnight to sign the agreement. APIF, motion carried. November 16, 2020 Minutes -4- b) Schmitz-Maki Arena Oil Separator Replacement Project Parks and Recreation Director Distad presented bids to replace the oil separator that is part of the arenas refrigeration system. The oil separator is an important part of the system that is installed in the compressor discharge line. As the refrigerant leaves the compressor to travel to the evaporative condenser to be cooled, some of the oil in the compressor is lost during the process. The oil separator captures the lost oil from the refrigerant, temporarily stores it and then returns in to the crankcase. Without the separator device, oil from the compressor would collect in the evaporative condenser and would damage the equipment. The current separator is undersized and has difficulty recapturing all of the lost oil. With this upgrade, the system should run most efficiently and cleaner because more of the lost oil will be captured and returned to the compressor. Staff solicited two companies to remove the existing separator and replace it with a larger oil separator. The results of the two quotes include: Cool Air Mechanical, Inc. $10,830 Gartner Refrigeration, Inc. $16,257 The work to replace the separator can be performed at the same time that the evaporative condenser is replaced later this year. Councilmember Hoyt asked about the difference in the two bids and whether we reaffirmed with the low bidder what they submitted. Distad stated that both bids were on the same specific piece of equipment. Motion by Hoyt, second by Bernhjelm,to approve an agreement with Cool Air Mechanical, Inc. for$10,830 to replace the oil separator and authorize Mayor Larson and Administrator McKnight to sign the agreement. APIF, motion carried. 10. Petitions, Requests and Communications None 11. Unfinished Business None 12. New Business November 16,2020 Minutes -5- None 13. City Council Roundtable McKnight-Updated the city council on steps being taken in regards to the pandemic. Also shared that he had spoken to Councilmembers Hoyt, Bernhjelm, and the two councilmembers- elect about the vacancy that will exist on the city council in 2021. All four members agreed that they would like to do an application process to fill the vacancy. Staff will get to work on advertising this opening. Larson-Shared that Toys of Town bins are out and encouraged residents to donate. Encouraged residents to shop local. 14. Adjourn Motion by Bernhjelm, second by Hoyt,to adjourn the meeting at 7:17 p.m. APIF, motion carried. Respectfully Submitted Dava A "C'rft4�/;r David McKnight, City Administrator November 16, 2020 Minutes -6- CITY OF 0 43o Third St., Farmington, MN 55024 FARMINGTON © 651-280-6800 OFarmington M N.gov TO: Mayor, Councilmembers and City Administrator FROM: Cynthia Muller, Administrative Assistant SUBJECT: Approve Various License and Permit Renewals for 2021-Community Development DATE: December 7, 2020 INTRODUCTION Per city code the City Council has the authority to approve On-Sale and Off-Sale Beer Licenses, and Tobacco Licenses. DISCUSSION The following establishments have submitted their applications for renewal: 3.2 Beer On-Sale Fountain Valley Golf Course, 2830 220th Street West 3.2 Beer Off-Sale Fountain Valley Golf Course, 2830 220th Street West Kwik Trip, 217 Elm Street Kwik Trip, 18290 Pilot Knob Road Speedway#4534, 18520 Pilot Knob Road Tobacco License Farmington Amcon, 957 8th Street Farmington Municipal Liquor Store, 18350 Pilot Knob Road Farmington Municipal Liquor Store, 109 Elm Street GYT Enterprises LLC, 10 8th Street Kwik Trip#693, 217 Elm Street Kwik Trip#443, 18290 Pilot Knob Road Premium Tobacco&Vape, I nc., 18350 Pilot Knob Road Speedway#4534, 18520 Pilot Knob Road Tobacco and Vape Store, 919 8th Street The appropriate forms,fees and insurance information have been submitted with the applications. The applications have also been reviewed and approved by the Police Department. BUDGET IMPACT The fees collected are included in the revenue estimates of the 2021 budget. ACTION REQUESTED Approve licenses for the above mentioned applicants. CITY OF 0 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 OFarmington MN.gov TO: Mayor, Councilmembers and City Administrator FROM: Cynthia Muller, Administrative Assistant SUBJECT: Adopt Resolution Approving Polling Locations for 2021-Community Development DATE: December 7, 2020 INTRODUCTION Due to new legislation, cities are required to designate polling locations for election and non-election years. DISCUSSION I n case an election were to take place in 2021, Farmington polling locations are as follows: Precinct 1—Rambling River Center, 325 Oak Street Precinct 2—St. Michael's Catholic Church, 22120 Denmark Avenue Precinct 3 - Farmington Maintenance Facility, 19650 Municipal Drive Precinct 4—Farmington Lutheran Church, 20600 Akin Road Precinct 5—Bible Baptist Church, 19700 Akin Road Precinct 6—Farmington City Hall, 430 Third Street BUDGET IMPACT Rental cost is included in the 2021 budget. ACTION REQUESTED Adopt the attached resolution designating the above polling locations for 2021. ATTACHMENTS: Type Description D Resolution Resolution RESOLUTION NO. R 5 3-2 0 DESIGNATING POLLING LOCATIONS FOR 2021 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 7th day of December 2020 at 7:00 p.m. Members Present: Larson, Bernhj elm, Craig, Hoyt Members Absent: Donnelly Member Bernhj elm and Member Craig introduced and seconded the following: WHEREAS,due to new legislation, cities are required to designate polling locations for election and non-election years; and WHEREAS,Farmington polling locations for 2021 are as follows: Precinct 1 -Rambling River Center, 325 Oak Street Precinct 2-St. Michael's Catholic Church, 22120 Denmark Avenue Precinct 3 -Farmington Maintenance Facility, 19650 Municipal Drive Precinct 4-Farmington Lutheran Church, 20600 Akin Road Precinct 5 -Bible Baptist Church, 19700 Akin Road Precinct 6-Farmington City Hall, 430 Third Street NOW, THEREFORE,BE IT RESOLVED that after due consideration,the Mayor and City Council of the City of Farmington, Minnesota, hereby designate the above polling locations for 2021. This resolution adopted by recorded vote of the Farmington City Council in open session on the 7th day of December 2020. f -- �Mayor Attested to the 7A day of December 2020. ity Administrat SEAL CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 OFarmington MN.gov TO: Mayor, Councilmembers and City Administrator FROM: Justin Elvestad, Fire Chief SUBJECT: Adopt Resolution Accepting a Monetary Donation from the Farmington Firefighters Relief Association-Fire DATE: December 7, 2020 INTRODUCTION The Farmington Firefighters Relief Association (FFRA) recently donated $50,000 the Farmington Fire Department. DISCUSSION From time to time the Farmington Firefighters Relief Association donates proceeds from fundraising efforts to assist the Farmington Fire Department with equipment needs. The FFRA has made a $50,000.00 donation to the Farmington Fire Department. BUDGET IMPACT This donation positively impacts the budget as these dollars are used in place of tax dollars to purchase equipment. ACTION REQUESTED Accept the donation from the Farmington Firefighters Relief Association and acknowledge and thank the members for their continuing support of the Farmington Fire Department. ATTACHMENTS: Type Description D Resolution Resolution RESOLUTION NO. R54-20 ACCEPTING DONATIONS TO THE FARMINGTON FIRE DEPARTMENT 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 7th day of December 2020 at 7:00 p.m. Members Present: Larson, Bernhj elm, Craig, Hoyt Members Absent: Donnelly Member Bernhj elm and Member Craig introduced and seconded the following: WHEREAS,the Farmington Fire Department provides fire and emergency medical services; and WHEREAS,the Farmington Firefighters Relief Association from time to time donates substantial funds to the City of Farmington. NOW, THEREFORE,BE IT RESOLVED that after due consideration,the Mayor and City Council of the City of Farmington, Minnesota, hereby accept the monetary donation of $50,000.00 from the Farmington Firefighters Relief Association to the City of Farmington Fire Department to be deposited in the Fire Capital Projects Fund. This resolution adopted by recorded vote of the Farmington City Council in open session on the 7th day of December 2020. Mayor Attested to the 7th day of December 2020. iAdministrat SEAL G17Y OF 0 43o Third St., Farmington, MN 55024 FARMINGTON © 651-280-6800 v O Farmington M N.gov TO: Mayor, Councilmembers and City Administrator FROM: Teah Malecha, Finance Director SUBJECT: Approve Policies and Procedures for Federal Awards Administration-Finance DATE: December 7, 2020 INTRODUCTION The city has received funding from the Federal CARES Act. There are additional audit procedures required when the federal amount expended exceeds$750,000. DISCUSSION I n July 2020, the city received $1,723,785 in federal funds from the CARES Act. The funds were to be used to cover costs that: • were necessary expenditures incurred due to the public health emergency with respect to COVI D- 19 • were not accounted for in the budget most recently approved as of March 27,2020 • were incurred during the period March 1- November 15, 2020 There are additional requirements for federal funds received when the expended amount exceeds $750,000 in a single audit. For the year ended December 31, 2020 the city will exceed that limit requiring additional policies and procedures to administer the funds. The city must comply with the Office of Management and Budget(O M B) Uniform Guidance which includes internal controls, necessary documentation, and subrecipient monitoring for grant recipients among numerous other items. The information is included in the attached Policies and Procedures for Federal Awards Administration. BUDGET IMPACT N/A ACTION REQUESTED Approve the attached Policies and Procedures for Federal Awards Administration. ATTACHMENTS: Type Description © Backup Material Policies and Procedures for Federal Awards Administration City of Farmington Policies and Procedures for Federal Awards Administration Table of Contents Overview............................................................................................................................................................................2 General Accounting and Financial Management.........................................................................................................2 Purchasing and Procurement.........................................................................................................................................3 Payrolland Timekeeping.................................................................................................................................................6 GrantAdministration........................................................................................................................................................6 Year-end Closing and Reporting....................................................................................................................................8 Additional Federal Awards Compliance Requirements..............................................................................................9 GeneralInformation .........................................................................................................................................................9 Activities Allowed/Un-allowed and Allowable Costs/Cost Principles........................................................................9 CashManagement.........................................................................................................................................................10 Eligibility...........................................................................................................................................................................10 Equipment and Real Property Management..............................................................................................................10 Matching, Level of Effort and Earmarking...................................................................................................................11 Periodof Performance...................................................................................................................................................12 Procurement, Suspension and Debarment................................................................................................................12 ProgramIncome.............................................................................................................................................................12 Sub-recipient Monitoring................................................................................................................................................13 Special Tests and Provisions........................................................................................................................................13 Page 1 Overview Purpose—This manual has been prepared to document the policies and procedures for the administration of federal awards of city of Farmington (the"city"). The Office of Management and Budget(OMB)Uniform Administrative Requirements, Cost Principles and Audit Requirements[34 CFR Part 80,2 CFR Part 213 and Part 6 of the Office of Management and Budget(OMB)Uniform Guidance Compliance Supplement] require all sub-recipients of federal funds to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations and program compliance requirements.Written policies and procedures are part of the necessary internal controls and are required as a precondition to receiving federal funds.These policies and procedures are intended to be sufficiently comprehensive to adequately meet such requirements. However, in no case are these policies and procedures intended to supersede or limit federal or state laws or regulations, or the provisions of individual grant agreements. Hierarchy of Authority—In the event that conflicting guidance on the administration of Federal awards is available,the city has deemed Federal guidance to be most authoritative,followed by other State or local agencies. Revisions—Guidance provided by the Federal government through the OMB Uniform Guidance Compliance Supplement are expected to be updated each year.Such updates are considered by the city as they become available and policies and procedures will be revised accordingly. Compliance Failures—Compliances failures,whether noted internally by management or through the external audit process, will be addressed immediately by reviewing the reason for the failure with responsible personnel and devising an improved process to encourage compliance in the future. General Accounting and Financial Management It is the policy of the city to comply with all statutory, regulatory, and contractual requirements in the conduct of,and accounting for, its financial operations.The official books of record for the city will be maintained subject to the following provisions: 1. The city will account for its operations in accordance with the Generally Accepted Accounting Principles (GAAP)applicable to local units of government. 2. The city will comply with all applicable circulars issued by the Office of Management and Budget(OMB), including, but not limited to: a. OMB Circular A-87—Cost Principles for States, Local and Indian Tribal Governments. b. OMB Uniform Guidance—Audits of States, Local Governments,and Non-Profit Organizations(the Single Audit Act). 3. The city will comply with all contractual requirements detailed in its duly executed grant agreements with awarding agencies. 4. The city will contract annually with an independent CPA firm for the purposes of conducting the city's external financial audit.To the extent that the city has expended federal awards in excess of the applicable single audit limit (currently$750,000),the city will have a single audit performed in accordance with OMB Uniform Guidance. 5. To ensure continuing compliance with all applicable accounting requirements,the city may, at its discretion, contract with a CPA firm to provide internal auditing and/or consulting services. 6. The Finance Director shall be responsible for the maintenance of all accounting and financial records(including journals,timesheets, bank statements,audit reports,and similar documents). Such records shall be retained as required by contractual or regulatory requirements.The city has adopted the state's records retention scheduleas its official guide for records storage,filing, and destruction. 7. The city and employees are required to comply with the city's conflict of interest procedures and report anypotential conflicts of interest to their managers. No employee, officer or agent may participate in the selection, award or administration of a contract supported by a Federal award if he or she has a real or apparent conflict of interest. Such violations may result in appropriate discipline. 8. The city will request prior approval from federal agencies for program or budget changes. 9. The city reserves the right to delay the implementation of new federal purchasing procedures by two years which follow:Acquisitions for micro-purchases(below$3,500 or below$2,000 for construction subject to the Davis Bacon Act)may be awarded without soliciting bids if the city considers the price to be reasonable.Procurements for Small Purchases(less than$175,000-Minn. Stat.§471.345), in which case quotations must be obtained from an adequate number of sources. Procurements made by sealed bid should be made to the lowest responsible(not necessarily the lowest)bidder. Procurements made by competitive proposal must have standards to evaluate the selected recipient. Procurement made by non-competitive proposals(to one vendor)may be used only if one of the following applies a)the item is available from a single source, b)an emergency exists c)the federal agency expressly authorizes non-competitive proposals, or d)competition is seen as inadequate after solicitation to a number of vendors. 10. Other procurement procedures include: Contractors who develop or draft specifications for bids are precluded from bidding on them. The city must maintain oversight so that contractors perform work as bid. Multiple provisions must be included in contracts(see Appendix II of grant procurement guidelines of super circular procedures).The city must verify to http://www.sam.gov/if contract is$25,000 or more to review if on the suspended and debarred list for federal grants. 11. Procedures for inventory of federal capital purchases will be maintained by the Finance Department,with the help of the Engineer, and all items will be tracked annually. 12. The Finance Director(or designee)or the City Administrator are required to certify expenditures. Purchasing and Procurement It is the policy of the city to ensure that all disbursements of city funds are properly reviewed and authorized,and consistent with sound financial management principles, and made in compliance with all applicable federal,state and local laws. In order to meet these objectives,all disbursements of city funds shall be subject to the following provisions,to the extent that they do not conflict with or contradict with any specific federal,state or local law or Council policies(the most specific or restrictive law, policy or procedure will be followed): 1. Substantial state and federal requirements exist pertaining to standards of conduct and conflict of interest. It is the intent of the city for all employees,officers,or agents to conduct all activities associated with procurements in compliance with the highest ethical standards, including the avoidance of any real or perceived conflict of interest. It is also the intent of the city to impose appropriate sanctions or disciplinary actions, including but not limited to termination and/or prosecution, for any employees or officers who violate any of these requirements. 2. The city avoids the acquisition of unnecessary or duplicative items.Additionally,the city considers consolidating or breaking out procurements to obtain a more economical purchase.And,where appropriate,the city makes an analysis of leases versus purchase alternatives, and other appropriate analyses to determine the most economical approach. 3. To foster greater economy and efficiency,the city enters into state and local intergovernmental agreements where appropriate for procurement or use of common or shared goods and services.This includes cooperative purchasing agreements where practical and beneficial. Depending on the purchase requested,the city may purchase it from a cooperative or inter-local agreement if the price is competitive and the goods or service are needed in a timely manner.The Finance Director and the City Administrator will make this determination. 4. The city awards contracts only to responsible contractors possessing the ability to perform successfully under the terms and conditions of a proposed procurement.The city considers such matters as contractor integrity and business ethics, compliance with public policy,ability to complete the project on time and in accordance with specifications, record of past performance,and the contractor's financial and technical resources. 5. The city will award a contract to a contractor who has the appropriate experience, expertise, qualifications,and any required certifications, necessary to perform the work. Contractors should also have the financial resources to sustain the project while the initial work is being completed and during each service period until he or she submits invoices for payment to the city as work is completed.Contractors should have the proper equipment or the capability to subcontract for the proper equipment necessary to complete the contracted work. 6. Debarment and Suspension: The city will not subcontract with or award subgrants to any person orcompany who is debarred or suspended from receiving federal funds.The Finance Director, or designee thereof, is required to check for excluded parties at the System for Award Management(SAM)website before any procurement transaction paid with federal funds.This list is located at:http://www.sam.gov/. 7. All procurement transactions paid with federal funds are conducted in a manner providing full and open competition. In an environment of full and open competition, no proposer or bidder has a competitive advantage over another.All potential proposers and bidders must be provided the same information and have the same opportunity to submit a bid or proposal. Providing a competitive advantage to one or more potential proposers or bidders over another can open up the potential for disputes and lawsuits that can be costly and can significantly delay the completion of projects. 8. In order to ensure objective contractor performance and eliminate unfair competitive advantage, contractorsthat develop or draft specifications, requirements,statements of work, or invitations for bids or requests for proposals (RFPs)are excluded from competing for such procurements.The city does not engage in the following situations that may restrict full and open competition, including but not limited to: • Placing unreasonable requirements on firms in order for them to qualify to do business. • Requiring unnecessary experience and excessive bonding. • Noncompetitive pricing practices between firms or between affiliated companies; • Noncompetitive contracts to consultants that are on retainer contracts. • Organizational conflicts of interest. • Specifying only a"brand name"product instead of allowing"an equal"product to beoffered and describing the performance or other relevant requirements of the procurement. • Any arbitrary action in the procurement process. • The city conducts federal procurements in a manner that prohibits the use of statutorily or administratively imposed state or local geographical preferences in the evaluation of bidsor proposals,except in those cases where applicable federal statutes expressly mandate or encourage geographic preference. 9. All solicitations will incorporate a clear and accurate description of the technical requirements for the material, product,or service to be procured.Such description will not, in competitive procurements, contain features which unduly restrict competition.The description will include a statement of the qualitative nature of the material, product or service to be procured and, when necessary, will set forth those minimum essential characteristics and standards to which it must conform if it is to satisfy its intended use. Detailed product specifications will be avoided if at all possible. 10. The city will make independent estimates of the goods or services being procured before receiving bids or proposals to get an estimate of how much the goods and services are valued in the current market.To accomplish this, after bids and proposals are received, but before awarding a contract,the Cityconducts either a price analysis or a cost analysis, depending on the type of contract, in connection with every procurement with federal funds in excess of $100,000. 11. The city takes all necessary affirmative steps to assure that minority businesses and women's business enterprises, and labor surplus area firms are used when possible.To accomplish this,the City uses thefollowing required affirmative steps: • Placing qualified small and minority businesses and women's business enterpriseson solicitation lists. • Assuring that small and minoritybusiness,and women's business enterprises are solicited whenever they are potential sources. • Dividing total requirements,when economically feasible, into smaller tasks or quantities to permit maximum participation by small and minority businesses, and women's business enterprises. • Establishing delivery schedules,where the requirement permits,which encourage participation by small and minority businesses, and women's business enterprises. • Using the services and assistance,as appropriate, of such organizations as the Small Business Administration and the Minority Business Development Agency of the Department of Commerce. • Requiring the prime contractor, if subcontracts are to be let,to take the affirmative steps listed above. 12. Federal methods provide for procurement by micro-purchase. Micro-purchase is a purchase of supplies or services using simplified acquisition procedures,the aggregate amount of which doesnot exceed$3,000.The micro-purchase method is used in order to expedite the completion of its lowest-dollar small purchase transactions and minimize the associated administrative burden and cost. 13. Small purchase procedures may be used in those relatively simple and informal procurement methodsfor securing nonprofessional services,supplies, or other property that do not cost more than$900,000. 14. Sealed bids($100,000,formal advertising, price is a major factor). Requirements for sealed bids: • The invitation for bids will be publicly advertised and bids must be selected from an adequate number of known suppliers, providing them sufficient response time prior to the date set for opening the bids. • The invitation for bids, which will include any specifications and pertinent attachments,must define the items or services in order for the bidder to properly respond. • All bids will be publicly opened at the time and place prescribed in the invitation forbid. • A firm fixed price contract award will be made in writing to the lowest responsive and responsible bidder. • Any or all bids may be rejected if there is a sound documented reason. • Competitive proposal(>$100,000,fixed price or cost reimbursement, request forproposal (RFP)with evaluation methods). Requirement for competitive proposal procedures: • Requests for proposals must be publicized requests and identify all evaluation factors andtheir relative importance. • Proposals must be solicited from an adequate number of qualified sources. • The organization must have a written method for conducting technical evaluations of the proposals received and for selecting recipients. • Contracts must be awarded to the responsible firm whose proposal is most advantageous tothe program. • The organization may only use qualification-based methods,whereby competitors'qualifications are evaluated and the most qualified competitor is selected, in the procurementof architectural/engineering professional services. 15. Procurement by noncompetitive proposals is procurement through solicitation of a proposal from only one source and may be used when using federal funds only when one or more of the following circumstances apply: • The item is available only from a single source.This must be documented. • The public exigency or emergency for the requirement will not permit a delay resultingfrom competitive solicitation. • Any federal awarding agency expressly authorizes noncompetitive proposals in response to written request from the city. • After solicitation of a number of sources, competition is determined inadequate. 16. Time and materials type contract means a contract whose cost to the city is the sum of:the actual costs of materials,and direct labor hours charged at fixed hourly rates that reflect wages,general and administrative expenses, and profit. • The city may use a time and materials type contract paid with federal funds in accordance with the above only(1)after a determination that no other contract is suitable; and (2)if thecontract includes a ceiling price that the contractor exceeds at its own risk. 17. The city ensures that all prequalified lists of persons,firms,or products which are used in acquiring goods and services are current and include enough qualified sources to ensure maximum open and free competition.The city accomplishes this by conducting internet searches, including using vendor searches,and by using other less technologically-advanced tools to locate and identify potential contractors. Federal guidelines are followed regarding the number of bids required. 18. The city requires that construction or facility improvement contracts, or subcontracts exceeding$175,000, include a bid guarantee equivalent to 5%of the bid price from eah bidder(such as bid bond or certified check),a performance bond on the part of the contractor for 100 percent of the contract price,and a payment bond on the part of the contractor for 100 percent of the contract price. Note: The city's purchasing policy does not apply to procurement by contractors or subcontractors on projects, federally supported or otherwise. Payroll and Timekeeping The following provisions apply to the payment of employees and recording of time and effort(as required)in accordance with OMB Uniform Guidance: 1. The payroll records must be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable,and properly allocated including: a. The total number of hours worked each day. b. The use of any holiday, personal,vacation,sick,or other approved time off with pay. c. The total number of hours to be paid. d. The allocation of those hours to each program or department for which work was performed, when necessary. e. The dated signature or electronic signature of the employee and supervisor for each payroll period. 2. Be incorporated into the city's official records. 3. Reasonably reflect the total activity for which the employee is compensated. 4. Encompass federally-assisted and all other compensated activities by the city on an integrated basis, but may use subsidiary records. 5. Support the distribution of the employee's salary or wages among specific activities if the employee works in more than one area. 6. Budget estimates are not an allowable form of allocation, but may be used in the interim if: a. The system for establishing estimates provides reasonable approximations. b. Significant work changes are entered into the system in a timely manner. c. The city's internal controls include review of after-the-fact interim charges. 7. Salaried employees charged to a Federal grant will document time and effort as outlined in paragraph 1 above.The time must also be supported by records indicating the total number of hours worked each day. It is the responsibility of the employee being charged to a Federal award(s)to clarify documentation requirements with the Human Resources Director or Finance Director and provide appropriate documentation to the Payroll Clerk as it becomes available.The employee should retain a copy of the documentation for his/her personal records. In the event that an after-the-fact correction is necessary to an employee's timesheet due to errors in the allocation of time worked, such corrections must be submitted to the Human Resources Director,and approved in writing by both the employee and his/her supervisor. Certifications should never be signed prior to the end date of the payroll period being certified. Each certification should be provided to the Human Resources Department when available. Employees should retain a copy of the certifications for his/her personal records. Grant Administration The following policies and procedures will also be applied,to the extent that they do not conflict with or contradict any existing Council policies: 1. Grant Development,Application,and Approval— a. Legislative Approval—The point at which legislative approval is required is determined by the requirements of the grant program. If the grant must be submitted by"an individual authorized by the legislative body/',then City Council approval is required prior to submitting the application. If such legislative approval is not specifically required by the written terms of the grant,then the City Administrator or designee may, at his or her discretion, approve grant applications. b. Matching Funds–Grants that require cash local matches must be coordinated through the Finance Department. At a minimum,funds must be identified within the existing budget to provide the match,or a budget amendment will be required. Depending on the nature of the grant,there may also be some policy implications that will bear discussion. For example, will the grant establish a level of service that cannot be sustained once the grant funds are depleted. In all cases involving matching funds,the grant applicant should contact the Finance Department to determine the strategy for securing matching funds. Refer to the section within this manual titled"Matching, Level of Effort, and Earmarking"for additional information on compliance with the provisions of the OMB Uniform Guidance Compliance Supplement. c. Grant Budgets–Most grants require the submission of an expenditure budget.The Finance Director will review this portion of the grant request prior to submission. Frequently, a technical review will discover inconsistencies in the calculations,cost centers that might have been overlooked,or identify rei m bu rsable expenses of which program staff may not be aware—particularly in the area of indirect costs. 2. Grant Program Implementation– a. Notification and Acceptance of an Award–Official notification of a grant award is typically sent bya funding agency to the program director and/or other official designated in the original grant proposal. However,the authorization to actually spend grant funds is derived from the City Council through the approval of a grant budget. Such notification should also be directed to the Finance Department. b. Establishment of Accounts–The department that obtained the grant will provide the Finance Director with information needed to establish revenue and expense accounts for the project,as well as a project code for tracking purposes. Ordinarily,this information will include a copy of a summary of the project and detail of the full project budget. c. Purchasing Guidelines–All other city purchasing guidelines apply to the expenditure of grant funds.The use of grant funds does not exempt any purchase from normal purchasing requirements.All typical paperwork and bidding requirements as well as normal staff approvals apply.When in doubt,the program director should contact the Finance Director for further assistance. 3. Financial and Budgetary.Compliance– a. Monitoring Grant Funds–Departments may use some internal mechanism (such as a spreadsheet)to monitor grant revenues, expenditures and budgetary compliance, at the grant level.The Finance Director maintains all this information in financial software system as well;this is considered to be the city's"official" accounting system by the granting agencies. Program Directors are strongly encouraged to use financial software reports provided by the Finance Department for their grant tracking. If any"off-system"accounting records are maintained, it is the responsibility of the Program Director to ensure that the program's internal records agree to the city's accounting system. b. Fiscal Years–Occasionally,the fiscal year for the granting agency will not coincide with the city's fiscal year. This may require adjustments to the city's internal budget accounts and interim financial reports as well as special handling during fiscal year-end close. It is the responsibility of the Program Director to bring such discrepancies to the attention of the Finance Department at the time the grant accounts are established. c. Grant Budgets–The terms of each specific grant will dictate whether any budget transfers between budgeted line items will be permitted. In no case will the Program Director be authorized to exceed thetotal budget authority provided by the grant. If grant funds have not been totally expended by fiscal year-end, it is the responsibility of the Program Director to notify the Finance Director that budget funds need to be carried forward to the new fiscal year, and to confirm the amounts of such carry-forwards. Carry-forwards of grant funds will be subjected to maximum allowable amounts/percentages based on the grant award agreement and/or the OMB Uniform Guidance Compliance Supplement. Capital Assets—The city is responsible for maintaining an inventory of assets purchased with grant funds. The city is accountable for them and must make them physically available for inspection during any audit. The City Council must approve of any sale of these assets. Customarily, the proceeds of the sale can only be used on the grant program that purchased them. (Refer to the specific regulations governing the original grant). The Finance Director will coordinate this grant requirement.All transactions that involve the acquisition or disposal of grant funded capital assets must be immediately brought to the attention of the Finance Director. Refer to the city's capital assets procedures and the section of this manual titled"Equipment and Real Property Management"for additional information. [OMB Circular A-133;34 CFR Sec. 74.34] 4. Record Keeping— a. Audit Work-papers—The city's external auditors audit all grants at the end of each fiscal year.The Finance Director will prepare the required audit work papers. Program Directors may be asked to assist in this process, if necessary. b. Record Keeping Requirements—Grant record keeping requirements may vary substantially from one granting agency to another. Consequently, a clear understanding of these grant requirements at the beginning of the grant process is vital.The Finance Department will maintain copies of all grant draw requests and approved grant agreements(including budgets).The Program Director should maintain all other records. 5. Other Guidelines—Specific information on policies and procedures related to compliance with the provisionsof the OMB Uniform Guidance Compliance Supplement have been addressed later in this manual and should be considered along with the information in this section. Year-end Closing and Reporting The following provisions will govern the year-end close-out process of the city for purposes of external financial reporting: 1. To the extent that the city is required to have a single audit completed in accordance with OMB Uniform Guidance,the city will accumulate the information necessary to prepare a schedule of expenditures of federal awards("SEFA')in accordance with Federal and State requirements.Thisschedule will be characterized as follows: a. The schedule will include all federal financial assistance, including:grants,contracts, property, loans, loan guarantees, interest subsidies,cooperative agreements, insurance or directappropriations.Amounts will be reported whether received directly from the Federal government or through a pass-through agency(in the event that the city is determined to be a sub-recipient and not a vendor). b. The schedule will be prepared on the same basis of accounting as the related financial statements. c. Federal awards will be grouped based on Federal awarding agency. Each Federal award with current expenditures will be listed along with its CFDA number, pass-through grantor name(if applicable)and award/pass-through grantor number(if applicable). Such information will agree to the award documentation. d. If the CFDA number of a Federal award cannot be reasonably determined, it shall be reported in the schedule using the two-digit prefix for the related Federal agency,followed by"UNKNOWN". e. To the extent that amounts are passed-through to sub-recipients, a schedule of federal awards provided to sub-recipients will be prepared. f. In addition to current year expenditures,the schedule will list approved award/grant amount, accrued/deferred revenue at the beginning of the year, current year cash received,current yearactual expenditures, and accrued/deferred revenue at the end of the year. If expenditures were incurred relative to this award in the prior year(s),this amount should be disclosed as memorandum-only. g. Any adjustments to prior year awards, expenditures, and balances(including transfers between grants)will be disclosed in the footnotes to the schedule. h. Accrued/deferred revenue in the schedule shall agree to the amounts recorded asreceivable/deferrals in the related financial statements. i. To the extent that a separate line item is included in the financial statements for Federal revenue,this amount shall agree to expenditures in the schedule.Any reconciling items will be disclosed in the footnotes to the schedule. Additional Federal Awards Compliance Requirements A number of the Federal awards received by the city are passed-through the State of Minnesota. Managementwill consider both the OMB Uniform Guidance Compliance Supplement and any applicable compliance requirements as set forth by the State of Minnesota. General Information Source of Information—Each year the Federal government(Office of Management and Budget)issues a comprehensive document on the compliance requirements each grant recipient is obligated to follow in general terms, along with program- specific guidance on various grant awards.There are 12 compliance requirements identified, each of which is considered individually in this manual. The following pages document the policies and procedures of the city related to compliance with such procedures, as applicable. In each year that the city is subject to a single audit, applicable compliance requirements are expected to be tested in detail by the city's independent auditors. Obiectives—The objectives of most compliance requirements are generic in nature.While the criteria for each program may vary,the main objective of the compliance requirement is relatively consistent across all programs.As such,the policies and procedures of the city have been based on the generic sense of the compliance requirement. For selected compliance requirements,this manual addresses the specific regulations applicable to individual grants.This is not intended to imply that a program is not subject to such policies if it is not specifically mentioned here. It is the intention of the city that all Federal awards are subject to the following policies and procedures. Controls over Compliance—In addition to creating policies and procedures over compliance with provisions of Federal awards,the city has implemented internal controls over such compliance, generally in the form of administrative oversight and/or independent review and approval. In order to document these control activities, all independent reviews must be signed/initialed and dated. Documentation—The city will maintain adequate documentation to support both the compliance with applicable requirements as well as internal controls over such compliance.This documentation will be provided to the city's independent auditors and/or pass-through grantor agencies, as requested, during the single audit and program audits. Activities Allowed/Un-allowed and Allowable Costs/Cost Principles Source of Governinq Requirements—The requirements for activities allowed or un-allowed are contained in program legislation, Federal awarding agency regulations, and the terms and conditions of the award.The requirements for allowable costs/cost principles are contained in the A-102 Common Rule(§ .22), OMB Circular A-133 (2 CFR section 215.27), program legislation, Federal awarding agency regulations, and the terms and conditions or the award. In order to ensure compliance with these requirements,the city has implemented the following policies and procedures: 1. All grant expenditures will be in compliance with OMB Circular 2 CFR 200, Subpart E, State law, city policy,and the provisions of the grant award agreement,which will also be considered in determining allowability. Grant funds will only be used for expenditures that are considered reasonable and necessary for the administration of the program. 2. Grant expenditures will be approved by department heads/program managers initially through the purchasing process and again when the bill or invoice is received.This will be evidenced by approval via the city's accounting software.Accounts payable disbursements will not be processed for payment by the Finance Department until necessary approval has been obtained. 3. Payroll costs will be documented in accordance with OMB Circular A-87 as described in the section of this manual titled"Payroll and Timekeeping".An indirect cost rate will only be charged to the grant to the extent that it was specifically approved through the grant budget/agreement.When allowable, indirect costs will be charged based on the Cost Allocation Plan of the city. Cash Management Source of Governing Requirements—The requirements for cash management are contained in the A-102 Common Rule(§ .21),OMB Circular A-133(2 CFR section 215.22), program legislation, Federal awarding agency regulations, and the terms and conditions or the award. In order to ensure compliance with these requirements,the city has implemented the following policies and procedures: 1. Substantially all of the city's grants are awarded on a reimbursement basis.As such, program costs willbe expended and disbursed prior to requesting reimbursement from the grantor agency. 2. Cash draws will be initiated by the Finance Director or City Administrator who will determine the appropriate draw amount.Documentation of how this amount was determined will be retained and signed/dated. 3. The physical draw of cash will be processed through SWIFT(Minnesota's State-wide Integrated Financial Tools payment system)or through the means prescribed in the grant agreement. 4. Supporting documentation from SWIFT or a copy of the cash draw paperwork will be filed along with the approved paperwork described above and retained for audit purposes. Eligibility Source of Governing Requirements—The requirements for eligibility are contained in program legislation, Federal awarding agency regulations, and the terms and conditions of the award. 1. Federal grants will only benefit those individuals and/or groups of participants that are deemed to be eligible. Equipment and Real Property Management Source of Governinq Requirements—The requirements for equipment are contained in the A-102 Common Rule(§ .32), OMB Circular A-133(2 CFR section 215.34), (34 CRF section 74.34), program legislation, Federal awarding agency regulations, and the terms and conditions of the award. The following policies and procedures will also be applied,to the extent that they do not conflict with or contradict any existing Council policies: 1. All equipment will be used in the program for which it was acquired or,when appropriate and allowable,other Federal programs. 2. When required, purchases of equipment will be pre-approved by the grantor or pass-through agency.The Finance Director, or designee will be responsible for ensuring that equipment purchases have been previously approved, if required, and will retain evidence of this approval. 3. Equipment records will be maintained and an appropriate system shall be used to safeguard equipment. Equipment should be assigned to a program and physical location on the inventory. If such equipment is moved, it will be noted and adjusted in the city's capital assets records. 4. When equipment is no longer needed for a Federal program, it may be retained or sold with the Federalagency having a right to a proportionate amount of the current fair market value. Proper sales procedures shall be used that provide for competition to the extent practicable and result in the highest possible return. Procedures for Disposition of Equipment: a. The city will keep,sell, or otherwise dispose of the equipment with no further obligation unless disposal requirements are specifically detailed in the grant. b. A record of the date, reason, and method of disposal or sale will be maintained withthe equipment inventory. Equipment purchased will be identified and kept in a capital asset listing.An equipment listing shall be maintained that includes the following: 1. Asset number and description of the equipment 2. Location of the equipment 3. Depreciation method &years of expected life 4. Acquisition date 5. Cost of the equipment 6. Equipment classification (land, building, equipment,etc.) 7. Make, Model, &Serial number or other identification number 8. Vendor and invoice number to purchase equipment 9. Disposition data including date and sale price of the equipment A physical inventory of the property will be conducted periodically, and the results will be reconciled with the capital asset listing. A control system will be developed to ensure adequate safeguards to prevent loss, damage,or theft of the property. Any loss, damage, or theft will be investigated. Maintenance procedures are in place to keep the equipment in good condition. Matching, Level of Effort and Earmarking Source of Governing Requirements—The requirements for matching are contained in the A-102 Common Rule(§ .24), OMB Circular A-133(2 CFR section 215.23), program legislation, Federal awarding agency regulations,and the terms and conditions of the award.The requirements for level of effort and earmarking are contained in program legislation, Federal awarding agency regulations, and the terms and conditions of the award. The city defines"matching","level of effort",and"earmarking"consistent with the definitions of the OMB Uniform Guidance Compliance Supplement: Matching or cost sharing includes requirements to provide contributions(usually non-Federal)or a specified amount or percentage of match Federal awards. Matching may be in the form of allowable costs incurred or in-kind contributions (including third-party in-kind contributions). Level of effort includes requirements for (a) a specified level of service to be provided from period to period, (b) a specified level of expenditures from non-Federal or Federal sources for specified activities to be maintained from period to period, and (c)Federal funds to supplement and not supplant non-Federal funding of services. Earmarking includes requirements that specify the minimum and/or maximum amount of percentage of the program's funding that must/may be used for specified activities, including funds provided to sub-recipients. Earmarking may also be specified in relation to the types of participants covered. In order to ensure compliance with these requirements,the city has implemented the following policies and procedures: 1. Compliance with matching, level of effort,and earmarking requirements will be the responsibility of the Finance Director. 2. Adequate documentation will be maintained to support compliance with matching, level of effort, and earmarking requirements. Such information will be made available to city administration,auditors,and pass-through or grantor agencies, as requested. 3. Maintenance of effort for grants through the State Minnesota will be determined at the State level. Period of Performance Source of Governinq Requirements—The requirements for period of performance of Federal funds are contained in the A-102 Common Rule(§ .23), OMB Circular A-133(2 CFR sections 215.28 and 215.71), program legislation, Federal awarding agency regulations, and the terms and conditions of the award. In order to ensure compliance with these requirements,the city has implemented the following policies and procedures: 1. Costs will be charged to an award only if the obligation was incurred during the funding period(unless pre- approved by the Federal awarding agency or pass-through grantor agency). 2. All obligations will be liquidated not later than 90 days after the end ofthe funding period (or as specified by program legislation). 3. Compliance with period of performance requirements will initially be assigned to the individual approving the allowability of the expense/payment.This will be subject to review and approval by the Finance Department as part of the payment processing. Procurement, Suspension and Debarment Source of Governinq Requirements—The requirements for procurement are contained in the A-102 Common Rule(§ .36);OMB Circular A-133(2 CFR sections 215.40 through 215.48), program legislation, Federal awarding agency regulations,and the terms and conditions of the award.The requirements for suspension and debarment are contained OMB guidance in 2 CFR part 180,which implements Executive Orders 12549 and 12689, Debarment and Suspension; Federal agency regulations in 2 CFR implementing the OMB guidance;the A-102 Common Rule(§.36);OMB Circular A- 133(2 CFR section 215.13); program legislation; Federal awarding agency regulations;and the terms and conditions of the award. In order to ensure compliance with these requirements,the city has implemented the following policies and procedures: 1. Purchasing and procurement related to Federal grants will be subject to the general policies and proceduresof the city(described in the section of this manual titled"Purchasing and Procurement"). 2. Contract files will document the significant history of the procurement,including the rationale for the method of procurement, selection of the contract type,contractor selection or rejection, and the basis of contract price. 3. The Finance Director will be responsible for determining whether the city is entering into a transaction thatmay be subject to suspension or debarment procedures and executing appropriate oversight and control activities at that time. Program Income Source of Governing Requirements—The requirements for program income are found in the A-102 Common Rule (§.21 (payment)and§.25(program income)); OMB Circular A-133(2 CFR section 215.2(program income definition),2 CFR section 215.22(payment), and 2 CFR section 215.24(program income)), program legislation, Federal awarding agency regulations,and the terms and conditions of the award. In order to ensure compliance with these requirements,the city has implemented the following policies and procedures: 1. Program income will include(but will not be limited to): income from fees for services performed,the use or rental of real or personal property acquired with grant funds,the sale of commodities or items fabricated under a grant agreement,and payments of principal and interest on loans made with grant funds. It will not include interest on grant funds unless otherwise provided in the Federal awarding agency regulations or terms and conditions of the award. 2. The city will allow program income to be used in one of three methods: a. Deducted from outlays b. Added to the project budget c. Used to meet matching requirements In the absence of specific guidance in the Federal awarding agency regulations or the terms and conditions of the award, program income shall be deducted from program outlays. 3. Program income,when applicable,will be accounted for as a revenue source in the same project code as the Federal grant. Sub-recipient Monitoring The city will ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and, if any of these data elements change, include the changes in subsequent subaward modification. Required information includes: 1. Federal Award Identification. a. Subrecipient name(which must match the name associated with its unique entity identifier); b. Subrecipient's unique entity identifier; c. Federal Award Identification Number(FAIN); d. Federal Award Date(see§200.39 Federal award date)to the recipient by the Federal agency; c. Subaward Period of Performance Start and End Date; f. Amount of Federal Funds Obligated by this action by the pass-through entity to the subrecipient; g. Total Amount of Federal Funds Obligated to the subrecipient by the pass-through entityincluding the current obligation; h. Total Amount of the Federal Award committed to the subrecipient by the pass-through entity; i. Federal award project description, as required to be responsive to the Federal Funding Accountability and Transparency Act(FFATA); j. Name of Federal awarding agency, pass-through entity, and contact information forawarding official of the Pass-through entity; k. CFDA Number and Name;the pass-through entity must identify the dollar amount made available under each Federal award and the CFDA number at time of disbursement; 1. Identification of whether the award is R&D;and m. Indirect cost rate for the Federal award (including if the de minimis rate is charged per§200.414 Indirect(F&A)costs). Special Tests and Provisions In order to ensure compliance with these requirements,the city has implemented the following policies and procedures: 1. The Finance Director will be assigned the responsibility for identifying financial-related compliance requirements for special tests and provisions, determining approved methods for compliance,and retaining any necessary documentation. Program-related compliance requirements will be the responsibility of thedepartment administering the grant. CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-280-6800 y O FarmingtonMN°gov TO: Mayor, Councilmembers and City Administrator FROM: Teah Malecha, Finance Director SUBJECT: Approve Bills-Finance DATE: December 7, 2020 INTRODUCTION Attached is the October 19, 2020- December 1, 2020 city council check register and recently processed automatic payments for your consideration. DISCUSSION N/A BUDGET IMPACT N/A ACTION REQUESTED Approve the attached payments. ATTACHMENTS: Type Description ❑ Backup Material Council Check Summary 10/19/2020- 12/1/2020 R55CKS2 LOGIS600V CITY OF FARMINGTON 12/1/2020 17:01:41 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 1 11/10/2020- 12/1/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 153064 11/13/2020 117642 MOTOROLA SOLUTIONS CREDIT COMPANY LLC 36,340.10 SEMI ANN RADIOLEASE PAYMENT 188966 29554 5602 6950 50 MACHINERY,EQUIPMENT&TOOLS GEN CAPITAL EQUIP FUND EX 05600 36,340.10 153065 11/13/2020 113076 A PLUS ROOFING COMPANY 68.48 CMF ROOF LEAK REPAIR 189111 1633 6502 6515 BUILDING REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 69.31 CMF ROOF LEAK REPAIR 189111 1633 6402 6515 BUILDING REPAIR/MAINTENANCE STORM WATER UTILITY OPERA 06400 08 69.31 CMF ROOF LEAK REPAIR 189111 1633 6302 6515 BUILDING REPAIR/MAINTENANCE SOLID WASTE OPERATIONS 06300 08 69.31 CMF ROOF LEAK REPAIR 189111 1633 6202 6515 BUILDING REPAIR/MAINTENANCE SEWER OPERATIONS EXPENSE 06200 08 69.31 CMF ROOF LEAK REPAIR 189111 1633 1090 6515 BUILDING REPAIR/MAINTENANCE PARK MAINTENANCE 01000 09 69.28 CMF ROOF LEAK REPAIR 189111 1633 1072 6515 BUILDING REPAIR/MAINTENANCE STREET MAINTENANCE 01000 08 415.00 153066 11/13/2020 100058 ADVANCE AUTO PARTS 56.96 ANTI-FREEZE FOR 0501 189102 2131-546899 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 100.00- CORE RETURNS 189105 2131-546867 CR 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 37.23 HEADLIGHTS FOR STOCK 189107 2131-546821 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 35.92 HOSE FITTINGS FOR STOCK 189107 2131-546821 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 33.98 MOTOR RELAY FOR 0720 189108 2131-547433 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 12.86- RETURN:JB WELD 189109 2131-548206 CR 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 51.23 153067 11/13/2020 115673 ALTERNATIVE BUSINESS FURNITURE,INC 8,751.31 CD AND ITADDL BARRIER PANELS 188982 64151 1015 6960 00019 FURNITURE,OFFICE EQUIP,IT CITY HALL 01000 01 8,751.31 153068 11/13/2020 100204 APPLE FORD LINCOLN-APPLE VALLEY 33.55 BLOCK HEATER FOR 0501 188810 505852 Al W 1051 6230 VEHICLE SUPPLIES&PARTS PATROL SERVICES 01000 05 33.55 153069 11/13/2020 116035 ARDEN TITLE,LLC 212.66 REF UTIL CR@905 9TH ST 188979 2020-53008 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 212.66 153070 11/13/2020 113303 ARTISAN BEER COMPANY 415.55 BEER ORDER 189005 3445845 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 35.60 BEER ORDER 189006 3445846 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 451.15 153071 11/13/2020 113809 BANKERS TITLE 107.80 REF UTIL CR@1011 WESTVIEW DR 188981 20.608.00350 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 107.80 153072 11/13/2020 100493 BELLBOY CORPORATION 37.62 BAG ORDER 188973 0102241100 6115 6250 OTHER SUPPLIES&PARTS PILOT KNOB LIQUOR 06100 02 129.17 LIQUOR SUPPLIES&MIXES ORDER 188973 0102241100 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 R55CKS2 LOGIS600V CITY OF FARMINGTON 12/1/2020 17:01:41 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 2 11/10/2020- 12/1/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 67.04 LIQUOR SUPPLIES&MIXES ORDER 189014 0102271100 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 328.20 LIQUOR SUPPLIES&MIXES ORDER 189015 0086641100 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 59.05 LIQUOR SUPPLIES&MIXES ORDER 189048 0102270900 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 32.78 BAG ORDER 189048 0102270900 6110 6250 OTHER SUPPLIES&PARTS DOWNTOWN LIQUOR REV&EXP 06100 02 132.26 LIQUOR&SPIRITS ORDER 189049 0086640400 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 786.12 153073 11/13/2020 107436 BELSON OUTDOORS,LLC 509.47 REPLACEMENT BENCH BOARDS 189118 187935 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 509.47 153074 11/13/2020 109503 BIFFS,INC 15.97 OCT'20 PRTBLE RNTL-JIM BELL PR 189064 #W787668 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 53.22 OCT'20 PRTBLE RNTL-FRM PRSRV P 189065 #W787666 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 123.96 OCT'20 PRTBLE RNTL-FEELY FIELD 189066 #W787664 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 53.22 OCT'20 PRTBLE RNTL-NRTH CREEK 189067 #W787667 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 53.22 OCT'20 PRTBLE RNTL-WSTVW ACRES 189070 #W787669 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 68.22 OCT'20 PRTBLE RNTL-MDWVW PRK 189071 #W787665 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 21.07 OCT'20 PRTBLE RNTL-RRP 189072 #W787663 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 53.22 OCT'20 PRTBLE RNTL-TMRCK PRK 189073 #W787661 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 53.22 OC720 PRTBLE RNTL-HILL DEE PK 189074 #W787658 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 53.22 OCT'20 PRTBLE RNTL-PINE KNOLL 189075 #W787660 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 53.22 OC720 PRTBLE RNTL-PRRVW PRK 189076 #W787662 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 53.22 OC720 PRTBLE RNTL-LK JULIA PK 189077 #W787659 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 53.22 OCT'20 PRTBLE RNTL-DKTA EST PK 189078 #W787657 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 53.22 OCT'20 PRTBLE RNTL-DAISY KNOLL 189079 #W787656 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 154.00 OCT'20 PRTBLE RNTL-RRC 189080 #W787671 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 64.00 OCT'20 PRTBLE RNTL-PRAIRIE PIN 189081 #W787670 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 979.42 153075 11/13/2020 115569 BOURGET IMPORTS,LLC 293.25 WINE ORDER 189046 173830 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 293.25 153076 11/13/2020 114472 BREAKTHRU BEVERAGE MN BEER,LLC 2,361.51 BEER ORDER 188943 1091182765 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 8,608.70 BEER ORDER 189021 1091186705 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,721.55 BEER ORDER 189050 1091186704 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 12,691.76 153077 11/13/2020 114471 BREAKTHRU BEVERAGE MN WINE&SPIRITS 3,955.47 LIQUOR&SPIRITS ORDER 189020 1081201552 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 49.45 WINE ORDER 189051 1081201551 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 2,802.67 LIQUOR&SPIRITS ORDER 189052 1081201550 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 6,807.59 R55CKS2 LOGIS600V CITY OF FARMINGTON 12/1/2020 17:01:41 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 3 11/10/2020- 12/1/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 153078 11/13/2020 110218 BURNET TITLE 263.54 REF UTIL CR@1000 8TH ST 188980 2131020-13192 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 263.54 153079 11/13/2020 110511 CHARTER COMMUNICATIONS HOLDINGS,LLC 580.12 NOV'20 CABLE&ALARM LINES 188935 0001792110120 7400 6411 TELEPHONE/CABLE SERVICES INFORMATION TECHNOLOGY 07400 04 580.12 153080 11/13/2020 100071 COLLEGE CITY BEVERAGE INC 4,158.95 BEER ORDER 189003 651849 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 28.22- BEER ORDER CREDIT 189008 651848 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 10,786.45 BEER ORDER 189011 651754 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 9.50- BEER ORDER CREDIT 189012 651782 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 14,907.68 153081 11/13/2020 117861 CONDON,LINDSAY 50.00 ALCOHOL TOBACCO COMP 189068 ALCOHOL TOBACCO 1050 6401 PROFESSIONAL SERVICES POLICE ADMINISTRATION 01000 05 COMP 50.00 153082 11/13/2020 112888 COOL AIR MECHANICAL,INC 22,588.17 33%DOWN PMT EVAP CONDENSER 188944 99320 4503 6950 00114 MACHINERY,EQUIPMENT&TOOLS ICE ARENA CAPITAL IMPR FU 04500 09 22,588.17 153083 11/13/2020 113299 CUES INC 722.43 CAMERA TRANSPORTER MAINT. 188711 572895 6202 6505 EQUIPMENT REPAIR/MAINTENANCE SEWER OPERATIONS EXPENSE 06200 08 722.43 CAMERA TRANSPORTER MAINT. 188711 572895 6402 6505 EQUIPMENT REPAIR/MAINTENANCE STORM WATER UTILITY OPERA 06400 08 519.97 SEWER CAMERA MAINT. 188712 572893 6202 6505 EQUIPMENT REPAIR/MAINTENANCE SEWER OPERATIONS EXPENSE 06200 08 519.97 SEWER CAMERA MAINT. 188712 572893 6402 6505 EQUIPMENT REPAIR/MAINTENANCE STORM WATER UTILITY OPERA 06400 08 2,484.80 153084 11/13/2020 109077 DAKOTA COUNTY CDA 7,975.00 DAKOTA CO CARES GRANT ADMIN 188974 20201105 1015 6401 00019 PROFESSIONAL SERVICES CITY HALL 01000 01 7,975.00 153085 11/13/2020 100057 DICK'S SANITATION SERVICE 1,996.24 OCT'20 RECYCLING SCHOOLS 188957 DT0003565581 6302 6560 CONTRACTUAL SERVICES SOLID WASTE OPERATIONS 06300 08 46,092.06 OCT-20 RECYCLING RESIDENTIAL 188958 DT0003587815 6302 6560 CONTRACTUAL SERVICES SOLID WASTE OPERATIONS 06300 08 8,160.00 OCT'20 WASTE HAULING FEES 188961 DT0003596749 6302 6560 CONTRACTUAL SERVICES SOLID WASTE OPERATIONS 06300 08 15,948.75 OCT-20 RECYCLING COMMERCIAL 189093 DT0003587814 6302 6560 CONTRACTUAL SERVICES SOLID WASTE OPERATIONS 06300 08 72,197.05 153086 11/13/2020 107008 DISTAD,RANDY 18.40 OCT'20 MILEAGE R DISTAD 188997 20201029 1090 6485 MILEAGE REIMBURSEMENT PARK MAINTENANCE 01000 09 18.40 OCT'20 MILEAGE R DISTAD 188997 20201029 1094 6485 MILEAGE REIMBURSEMENT PARK&RECREATION ADMIN 01000 09 R55CKS2 LOGIS600V CITY OF FARMINGTON 12/1/2020 17:01:41 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 4 11/10/2020- 12/1/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 36.80 153087 11/13/2020 114949 DVS REGISTRATION 19.25 F#0592 V#92619 RENEWAL 189136 FORD'20 EKL337 1050 6234 VEHICLE LICENSES,TAXES,FEE POLICE ADMINISTRATION 01000 05 RENEW 19.25 153088 11/13/2020 100149 ECM PUBLISHERS,INC 16.50 NOTICE:ACCURACY TEST 188601 799661 1013 6455 LEGAL NOTICES ELECTIONS 01000 01 83.75 SAMPLE BALLOT NOTICE 188605 799662 1013 6455 LEGAL NOTICES ELECTIONS 01000 01 100.25 153089 11/13/2020 113296 EDINA REALTY TITLE 80.65 REF UTIL CR@1055 WILLOW TRL 188983 1751578/48 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 79.09 REF UTIL CR@1300 LOCUST ST 188984 1752855/72 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 159.74 153090 11/13/2020 100364 EHLERS&ASSOCIATES INC 1,000.00 INTERIM ARBITRAGE REPORT 2015A 189061 85134 3093 7130 FISCAL AGENT FEES 2015A 195TH ST RECONSTR P 03093 02 1,000.00 153091 11/13/2020 115414 EXECUTIVE TITLE SERVICE,INC 224.51 REF UTIL CR@18725 ENGLEWOOD WY 188987 14955/71 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 224.51 153092 11/13/2020 109931 FACTORY MOTOR PARTS 87.79 WATERPUMP FOR 0552 188719 1-6598767 1051 6230 VEHICLE SUPPLIES&PARTS PATROL SERVICES 01000 05 40.32 STOCK FILTERS 188720 1-6598808 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 128.11 153093 11/13/2020 117006 FERGUSON ENTERPRISES LLC 188.09 HYDRANT METER STAND 188956 0177843 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 188.09 153094 11/13/2020 112904 FLEETPRIDE TRUCK&TRAILER PARTS 167.14 BRAKE PARTS FOR 0709 188614 61623104 1072 6230 VEHICLE SUPPLIES&PARTS STREET MAINTENANCE 01000 08 213.06 EXHAUST FOR 0705 188809 61742279 1072 6230 VEHICLE SUPPLIES&PARTS STREET MAINTENANCE 01000 08 134.51 BRAKE AIR DRYERS 188809 61742279 6302 6230 VEHICLE SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 8.65- 188809 61742279 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 506.06 153095 11/13/2020 100077 FRONTIER COMMUNICATIONS 81.81 NOV'20 ARENAALARM LINE 189087 6514633016 NOV'20 2502 6411 TELEPHONE/CABLE SERVICES ICE ARENA OPERATIONS EXPE 02500 09 81.81 153096 11/13/2020 111456 GLOBAL CLOSING&TITLE SERVICES 16.33 REF UTIL CR@519 7TH ST 188977 MN-09-200347 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 16.33 R55CKS2 LOGIS600V CITY OF FARMINGTON 12/1/2020 17:01:41 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 5 11/10/2020- 12/1/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 153097 11/13/2020 100044 GRAINGER INC 170.12 HVAC ACTUATORS 188620 9686868309 1015 6240 BUILDING SUPPLIES&PARTS CITY HALL 01000 01 170.12 153098 11/13/2020 100027 GREAT LAKES COCA-COLA DISTRIBUTION,LLC 318.44 POP ORDER 189002 3608211573 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 318.44 153099 11/13/2020 112640 GRENGS,DARBY 595.00 FLAG FB OFFICIAL 188995 20201012 D GRENGS 1095 6401 PROFESSIONAL SERVICES RECREATION PROGRAM SERVIC 01000 09 595.00 153100 11/13/2020 107123 GS DIRECT INC 23.65 PLOTTER SUPPLIES 188917 358938 6302 6220 EQUIP SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 22.13 PLOTTER SUPPLIES 188917 358938 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 1.52- 188917 358938 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 22.13 PLOTTER SUPPLIES 188917 358938 1095 6220 EQUIP SUPPLIES&PARTS RECREATION PROGRAM SERVIC 01000 09 22.13 PLOTTER SUPPLIES 188917 358938 6402 6220 EQUIP SUPPLIES&PARTS STORM WATER UTILITY OPERA 06400 08 22.13 PLOTTER SUPPLIES 188917 358938 6202 6220 EQUIP SUPPLIES&PARTS SEWER OPERATIONS EXPENSE 06200 08 22.13 PLOTTER SUPPLIES 188917 358938 1070 6220 EQUIP SUPPLIES&PARTS ENGINEERING SERVICES 01000 07 22.12 PLOTTER SUPPLIES 188917 358938 1030 6220 EQUIP SUPPLIES&PARTS PLANNING&ZONING 01000 03 154.90 153101 11/13/2020 111623 HACH COMPANY 97.39 CHLORINE DISPENSER 189096 12091316 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 566.15 FLORIDE ACCUVACS 189097 12145244 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 68.80 CHLORINE DISPENSER 189098 12094094 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 732.34 153102 11/13/2020 100074 HOHENSTEINS INC 294.80 BEER ORDER 189000 370526 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 472.40 BEER ORDER 189013 370525 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 767.20 153103 11/13/2020 112416 IMPACT MAILING OF MN,INC 38.67 OCT'20 US MAIL PREP 189063 150130 6502 6401 PROFESSIONAL SERVICES WATER UTILITY EXPENSE 06500 08 38.67 OCT'20 UB MAIL PREP 189063 150130 6402 6401 PROFESSIONAL SERVICES STORM WATER UTILITY OPERA 06400 08 2.66- 189063 150130 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 41.33 OCT'20 US MAIL PREP 189063 150130 6302 6401 PROFESSIONAL SERVICES SOLID WASTE OPERATIONS 06300 08 38.67 OCT'20 US MAIL PREP 189063 150130 6202 6401 PROFESSIONAL SERVICES SEWER OPERATIONS EXPENSE 06200 08 189.01 OCT'20 US BILL POSTAGE 189063 150130 6202 6445 POSTAGE/SHIPPING FEES SEWER OPERATIONS EXPENSE 06200 08 189.01 OCT'20 US BILL POSTAGE 189063 150130 6302 6445 POSTAGE/SHIPPING FEES SOLID WASTE OPERATIONS 06300 08 189.01 OCT'20 US BILL POSTAGE 189063 150130 6402 6445 POSTAGE/SHIPPING FEES STORM WATER UTILITY OPERA 06400 08 189.01 OCT'20 US BILL POSTAGE 189063 150130 6502 6445 POSTAGE/SHIPPING FEES WATER UTILITY EXPENSE 06500 08 R55CKS2 LOGIS600V CITY OF FARMINGTON 12/1/2020 17:01:41 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 6 11/10/2020- 12/1/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 910.72 — — 153104 11/13/2020 117341 INBOUND BREWCO 100.00 BEER ORDER 189016 8679 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 100.00 153105 11/13/2020 111773 INNOVATIVE OFFICE SOLUTIONS,LLC 83.03 FOLDERS 188709 IN3138300 1010 6210 OFFICE SUPPLIES ADMINISTRATION 01000 01 83.03 153106 11/13/2020 105641 INSIGHT PUBLIC SECTOR 49,243.01 OFFICE 365+PHONE LICENSING 1YR 188829 327053993 7400 1505 00019 PREPAID EXPENSES INFORMATION TECHNOLOGY 07400 04 49,243.01 153107 11/13/2020 109846 JJ TAYLOR DISTRIBUTING COMPANY OF MN INC 3,661.20 BEER ORDER 188938 3139800 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 2,584.90 BEER ORDER 189001 3139843 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 7,241.10 BEER ORDER 189010 3139842 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 13,487.20 153108 11/13/2020 100033 JOHNSON BROTHERS LIQUOR COMPANY 2,055.01 WINE ORDER 188940 1671343 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,504.79 LIQUOR&SPIRITS ORDER 188942 1671342 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 798.07 WINE ORDER 189019 1671027 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 300.44 LIQUOR&SPIRITS ORDER 189022 1676499 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,509.77 WINE ORDER 189023 1676500 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 126.01 SVEDKA VODKA ORDER 189024 1676503 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,028.47 WINE ORDER 189025 1676504 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 881.56 LIQUOR&SPIRITS ORDER 189026 1676505 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 709.24 WINE ORDER 189027 1676506 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,894.61 LIQUOR&SPIRITS ORDER 189032 1676498 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 33.51 AGALIMA MIXES ORDER 189034 1676502 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 93.02 LIQUOR&SPIRITS ORDER 189035 1676501 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 302.04 WINE ORDER 189036 1676571 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 523.05 LIQUOR&SPIRITS ORDER 189037 1676570 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 103.51 SVEDKA VODKA ORDER 189040 1676572 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 446.30 WINE ORDER 189041 1676573 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 412.53 LIQUOR&SPIRITS ORDER 189043 1676569 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 220.52 LIQUOR&SPIRITS ORDER 189044 1676574 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 257.00 WINE ORDER 189045 1676575 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 13,199.45 153109 11/13/2020 116827 JOHNSON LITHO GRAPHICS OF EAU CLAIRE LTD 1,100.16 WINTER-20 CURRENTS POSTAGE 188962 101245 1094 6445 POSTAGE/SHIPPING FEES PARK&RECREATION ADMIN 01000 09 275.04 WINTER'20 CURRENTS POSTAGE 188962 101245 6202 6445 POSTAGE/SHIPPING FEES SEWER OPERATIONS EXPENSE 06200 08 R55CKS2 LOGIS600V CITY OF FARMINGTON 12/1/2020 17:01:41 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 7 11/10/2020- 12/1/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept D 275.04 WINTER'20 CURRENTS POSTAGE 188962 101245 6302 6445 POSTAGE/SHIPPING FEES SOLID WASTE OPERATIONS 06300 08 275.04 WINTER'20 CURRENTS POSTAGE 188962 101245 6402 6445 POSTAGEISHIPPING FEES STORM WATER UTILITY OPERA 06400 08 275.04 WINTER'20 CURRENTS POSTAGE 188962 101245 6502 6445 POSTAGE/SHIPPING FEES WATER UTILITY EXPENSE 06500 08 2,200.32 153110 11/13/2020 115466 LIFE INSURANCE COMPANY OF NORTH AMERICA 335.16 OCT'20 ACCIDENT&Cl INSURANCE 188970 A1960331 OCT'20 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 335.16 NOV'20 ACCIDENT&Cl INSURANCE 188971 A1960331 NOV'20 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 335.16 SEP'20 ACCIDENT&Cl INSURANCE 188972 A1960331 SEPT'20 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 1,005.48 153111 11/13/2020 100049 LOCAL GOVERNMENT INFORMATION SYSTEMS 3,093.75 OCT'20 SVS:SERVER PROJ 188930 49483 7400 6401 00019 PROFESSIONAL SERVICES INFORMATION TECHNOLOGY 07400 04 82,515.06 SERVER EQUIP FOR IT SVR PRJ 188963 49528 7400 6960 00019 FURNITURE,OFFICE EQUIP,IT INFORMATION TECHNOLOGY 07400 04 12,500.00 M365 OFFICE MIGRATION AZURE AD 189135 49546 7400 6401 00019 PROFESSIONAL SERVICES INFORMATION TECHNOLOGY 07400 04 2,343.75 OCT'20 SVS:SERVER PROJ 189140 49545 7400 6401 00019 PROFESSIONAL SERVICES INFORMATION TECHNOLOGY 07400 04 100,452.56 153112 11/13/2020 115396 MACQUEEN EMERGENCY GROUP 231.90 FIREFIGHTING FOAM 188690 P04229 1060 6220 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 231.90 153113 11/13/2020 114572 MANLEY SOLUTIONS INC 2,686.32 2021ALARM LINE SUBSCIPTIONS 189141 INV-0920-41 7400 6505 EQUIPMENT REPAIR/MAINTENANCE INFORMATION TECHNOLOGY 07400 04 2,686.32 153114 11/13/2020 101374 MINNESOTA DEPT OF PUBLIC SAFETY 2,098.83 F#0743 V#11718 LIC&REG 189137 F#0743 SEWER 6202 6940 VEHICLES SEWER OPERATIONS EXPENSE 06200 08 2,098.83 F#0731 V#10571 TITLE&REG FEE 189138 F#0731 SEWER 6202 6940 VEHICLES SEWER OPERATIONS EXPENSE 06200 08 2,098.83 F#0914 V#09626 TITLE&REG FEE 189139 F#0914 PARKS 5602 6940 VEHICLES GEN CAPITAL EQUIP FUND EX 05600 6,296.49 153115 11/13/2020 117764 MINNESOTA TITLE 90.82 REF UTIL CR@145 HICKORY CT 188975 MT-2008-1669-BV/77 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 146.59 REF UTIL CR@19149 EVENSTON DR 188988 MT-2009-1093-MH/72 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 237.41 153116 11/13/2020 100070 MINNESOTA VALLEY TESTING LABORATORIES 73.50 BAC-T SAMPLE(7) 188616 1056649 6502 6401 PROFESSIONAL SERVICES WATER UTILITY EXPENSE 06500 08 73.50 153117 11/13/2020 117862 NORTH AMERICAN TITLE COMPANY 218.79 REF UTIL CR@19150 EVEREST TRL 188990 40869-20-00272-MN 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 218.79 153118 11/13/2020 117866 NORTHSTAR TITLE GROUP,LLC 48.13 REF UTIL CR@20645 EASTVIEW AVE 188991 20-80 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 R55CKS2 LOGIS600V CITY OF FARMINGTON 12/1/2020 17:01:41 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 8 11/10/2020- 12/1/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept D 48.13 153119 11/13/2020 101254 ORKIN EXTERMINATING,LLC 106.06 OC720 PEST CNTRL-5446 195TH 188790 203171223/28454299 6502 6515 BUILDING REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 88.52 4TH QT 2020 PEST CONTROL 188799 203171987/28594962 1051 6515 BUILDING REPAIR/MAINTENANCE PATROL SERVICES 01000 05 20.43 OCT'20 PEST CONTROL CMF 188815 203171718/28367911 6502 6515 BUILDING REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 20.67 OCT'20 PEST CONTROL CMF 188815 203171718/28367911 6402 6515 BUILDING REPAIR/MAINTENANCE STORM WATER UTILITY OPERA 06400 08 1.42- 188815 203171718/28367911 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 22.09 OCT'20 PEST CONTROL CMF 188815 203171718/28367911 6302 6515 BUILDING REPAIR/MAINTENANCE SOLID WASTE OPERATIONS 06300 08 20.67 OCT'20 PEST CONTROL CMF 188815 203171718/28367911 6202 6515 BUILDING REPAIR/MAINTENANCE SEWER OPERATIONS EXPENSE 06200 08 20.67 OCT'20 PEST CONTROL CMF 188815 203171718/28367911 1090 6515 BUILDING REPAIR/MAINTENANCE PARK MAINTENANCE 01000 09 20.67 OCT'20 PEST CONTROL CMF 188815 203171718/28367911 1072 6515 BUILDING REPAIR/MAINTENANCE STREET MAINTENANCE 01000 08 107.10 OCT'20 PEST CONTROL CITY HALL 188816 203172168/28379954 1015 6515 BUILDING REPAIR/MAINTENANCE CITY HALL 01000 01 425.46 153120 11/13/2020 100290 PAUSTIS&SONS WINE COMPANY 211.50 WINE ORDER 189018 106799 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 159.00 WINE ORDER 189047 106798 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 370.50 153121 11/13/2020 117864 PELACH,NICHOLAS 50.00 ALCOHOL TOBACCO COMP 189069 ALCOHOL TOBACCO 1050 6401 PROFESSIONAL SERVICES POLICE ADMINISTRATION 01000 05 COMP 50.00 153122 11/13/2020 100093 PELLICCI HARDWARE&RENTAL 89.99 6'STEP LADDER 188946 K39328/F 1015 6950 MACHINERY,EQUIPMENT&TOOLS CITY HALL 01000 01 9.98 SCRAPR BLADES/RAZOR BLADES 188946 K39328/F 1015 6220 EQUIP SUPPLIES&PARTS CITY HALL 01000 01 19.98 MARKER FLAGS FOR LOCATES 188947 K39844/F 1072 6220 EQUIP SUPPLIES&PARTS STREET MAINTENANCE 01000 08 6.25 FILTER AND CARPET PROTECTOR 189091 39878/F 1015 6220 EQUIP SUPPLIES&PARTS CITY HALL 01000 01 6.24 FILTER AND CARPET PROTECTOR 189091 39878/F 1060 6220 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 .22- 189091 39878/F 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 12.50 FILTER AND CARPET PROTECTOR 189091 39878/F 1072 6220 EQUIP SUPPLIES&PARTS STREET MAINTENANCE 01000 08 2.50 FILTER AND CARPET PROTECTOR 189091 39878/F 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 6.25 FILTER AND CARPET PROTECTOR 189091 39878/F 1093 6220 EQUIP SUPPLIES&PARTS SENIOR CITIZEN SERVICES 01000 09 6.25 FILTER AND CARPET PROTECTOR 189091 39878/F 2502 6220 EQUIP SUPPLIES&PARTS ICE ARENA OPERATIONS EXPE 02500 09 2.50 FILTER AND CARPET PROTECTOR 189091 39878/F 6202 6220 EQUIP SUPPLIES&PARTS SEWER OPERATIONS EXPENSE 06200 08 2.67 FILTER AND CARPET PROTECTOR 189091 39878/F 6302 6220 EQUIP SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 2.50 FILTER AND CARPET PROTECTOR 189091 39878/F 6402 6220 EQUIP SUPPLIES&PARTS STORM WATER UTILITY OPERA 06400 08 2.50 FILTER AND CARPET PROTECTOR 189091 39878/1' 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 1.87 WRENCH 189091 39878/F 1015 6950 MACHINERY,EQUIPMENT&TOOLS CITY HALL 01000 01 1.87 WRENCH 189091 39878/F 1060 6950 MACHINERY,EQUIPMENT&TOOLS FIRE SERVICES 01000 06 3.75 WRENCH 189091 39878/F 1072 6950 MACHINERY,EQUIPMENT&TOOLS STREET MAINTENANCE 01000 08 .75 WRENCH 189091 39878/F 1090 6950 MACHINERY,EQUIPMENT&TOOLS PARK MAINTENANCE 01000 09 R55CKS2 LOGIS600V CITY OF FARMINGTON 12/1/2020 17:01:41 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 9 11/10/2020- 12/1/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 1.87 WRENCH 189091 39878/1' 1093 6950 MACHINERY,EQUIPMENT&TOOLS SENIOR CITIZEN SERVICES 01000 09 1.87 WRENCH 189091 39878/F 1050 6950 MACHINERY,EQUIPMENT&TOOLS POLICE ADMINISTRATION 01000 05 .75 WRENCH 189091 39878/F 6202 6950 MACHINERY,EQUIPMENT&TOOLS SEWER OPERATIONS EXPENSE 06200 08 .80 WRENCH 189091 39878/F 6302 6950 MACHINERY,EQUIPMENT&TOOLS SOLID WASTE OPERATIONS 06300 08 .75 WRENCH 189091 39878/F 6402 6950 MACHINERY,EQUIPMENT&TOOLS STORM WATER UTILITY OPERA 06400 08 .75 WRENCH 189091 39878/1' 6502 6950 MACHINERY,EQUIPMENT&TOOLS WATER UTILITY EXPENSE 06500 08 184.92 153123 11/13/2020 100032 PEPSI COLA COMPANY 141.95 POP ORDER 189004 29137502 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 141.95 153124 11/13/2020 100034 PHILLIPS WINE AND SPIRITS,INC 255.43 LIQUOR&SPIRITS ORDER 188941 6112813 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,438.07 LIQUOR&SPIRITS ORDER 189028 6116527 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 452.10 WINE ORDER 189029 6116528 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 91.32 LIQUOR MIXES ORDER 189030 6116529 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 63.51 WINE ORDER 189038 6116583 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 376.73 LIQUOR&SPIRITS ORDER 189039 6116582 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 2,677.16 153125 11/13/2020 117491 POMP'S TIRE SERVICE,INC 345.88 TIRES MOUNTED FOR SANITATION 188949 210490004 6302 6510 1 OUTSIDE VEHICLE REPAIR/MAINT SOLID WASTE OPERATIONS 06300 08 4.88- 188949 210490004 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 941.60 SQUAD TIRES 188950 210490889 7200 6232 VEHICLE/EQUIPMENT TIRES FLEET OPERATIONS 07200 08 774.87 RECAP TIRES FOR SANITATION 188951 210493621 7200 6232 VEHICLE/EQUIPMENT TIRES FLEET OPERATIONS 07200 08 49.85- 188951 210493621 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 575.84 TIRES FOR 0720 188952 210491669 7200 6232 VEHICLE/EQUIPMENT TIRES FLEET OPERATIONS 07200 08 281.44 TIRES FOR 0934 189142 210472988 7200 6232 VEHICLE/EQUIPMENT TIRES FLEET OPERATIONS 07200 08 565.73 RECAP TIRES FOR SANITATION 189143 210471423 7200 6232 VEHICLE/EQUIPMENT TIRES FLEET OPERATIONS 07200 08 36.39- 189143 210471423 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 288.50 TIRE MOUNTING FOR SANITATION 189144 210470378 6302 6510 1 OUTSIDE VEHICLE REPAIR/MAINT SOLID WASTE OPERATIONS 06300 08 122.95 TIRE REPAIR FOR SANITATION 189145 210472710 6302 6510 1 OUTSIDE VEHICLE REPAIR/MAINT SOLID WASTE OPERATIONS 06300 08 3,805.69 153126 11/13/2020 110760 PRO-TECH DESIGN,INC 17,854.91 CH PRJ-MAIN ENT VEST DR LOCKS 188796 98599 1015 6401 00019 PROFESSIONAL SERVICES CITY HALL 01000 01 6,906.94 CARES ACT CH VESTIBULE DRS PRJ 189062 98788 7400 6401 00019 PROFESSIONAL SERVICES INFORMATION TECHNOLOGY 07400 04 24,761.85 153127 11/13/2020 100125 R&R SPECIALTIES OF WISCONSIN INC 37.50 ZAMBONI BLADE SHARPEN 188622 0071344-IN 2502 6505 EQUIPMENT REPAIR/MAINTENANCE ICE ARENA OPERATIONS EXPE 02500 09 37.50 153128 11/13/2020 117865 RAK CONSTRUCTION,INC R55CKS2 LOGIS600V CITY OF FARMINGTON 12/1/2020 17:01:41 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 10 11/10/2020- 12/1/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 45,051.85 PAY REQ#1:FS#1 OVRHD DOOR PROJ 188992 19240-20254J 5731 7010 21625 CONSTRUCTION CONTRACTS BUILDING MAINTENANCE 05700 45,051.85 153129 11/13/2020 113930 RANGER CHEVROLET 31,617.40 F#0743 V#11718 21 GMC SIERRA 189112 9987873 F#0743 6202 6940 VEHICLES SEWER OPERATIONS EXPENSE 06200 08 SEWER 31,617.40 F#0731 V#10571 21 GMC SIERRA 189113 9987871 F#0731 6202 6940 VEHICLES SEWER OPERATIONS EXPENSE 06200 08 SEWER 31,617.40 F#0914 V#09626 21 GMC SIERRA 189114 9987872 F#0914 5602 6940 VEHICLES GEN CAPITAL EQUIP FUND EX 05600 PARKS 94,852.20 153130 11/13/2020 117564 RECYCLE MINNESOTA LLC 6,169.76 OCT'20 TRANSLOAD FEES 188959 0000002366 6302 6401 PROFESSIONAL SERVICES SOLID WASTE OPERATIONS 06300 08 6,169.76 153131 11/13/2020 116843 RESULTS TITLE 30.04 REF UTIL CR@705 CENTENNIAL CIR 188978 20-09604 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 30.04 153132 11/13/2020 112632 RICOH USA,INC 26.15 OCT'20 COPIER MAINTENANCE 188933 5060654774 1010 6505 EQUIPMENT REPAIR/MAINTENANCE ADMINISTRATION 01000 01 636.51 OCT'20 COPIER MAINTENANCE 188994 5060707220 1010 6505 EQUIPMENT REPAIR/MAINTENANCE ADMINISTRATION 01000 01 662.66 153133 11/13/2020 110990 SCHINDLER ELEVATOR CORPORATION 680.43 QTRLY ELEVATOR MAI NT CONTRACT 189082 8105465224 1015 6515 BUILDING REPAIR/MAINTENANCE CITY HALL 01000 01 680.43 153134 11/13/2020 117867 SCHNOBRICH,RACHELLE 262.34 REF OF DUP CC LIQ TRANS 188998 REF OF DUP CC LIQ 6115 5370 CASH OVER&SHORT PILOT KNOB LIQUOR 06100 02 TRANS 262.34 153135 11/13/2020 107018 SHAMROCK GROUP 108.42 ICE CUBE ORDER 188999 2565041 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 192.92 ICE CUBE ORDER 189007 2563247 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 301.34 153136 11/13/2020 103130 SOLBERG AGGREGATE,INC 344.40 CLASS 5 GRAVEL TO 190TH 189094 23338 1072 6253 STREET MATERIALS STREET MAINTENANCE 01000 08 344.40 153137 11/13/2020 112051 SOUTHERN GLAZER'S OF MN 4,865.85 LIQUOR&SPIRITS ORDER 188939 2010054 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 3,824.37 WINE ORDER 189009 2012715 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1.28 DELIVERY CHARGE 189033 2012710 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 R55CKS2 LOGIS600V CITY OF FARMINGTON 12/1/2020 17:01:41 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 11 11/10/2020- 12/1/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 1,247.51 WINE ORDER 189053 2012711 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 9,939.01 153138 11/13/2020 110799 SPECIALIZED ENVIRONMENTAL TECHNOLOGIES 198.00 OCT'20 STREET LEAVE COMPOSTING 189100 10159 OCT'20 6402 6401 PROFESSIONAL SERVICES STORM WATER UTILITY OPERA 06400 08 198.00 153139 11/13/2020 109843 SPOK,INC. 2.64 NOV'20 PAGER CONTRACT 188953 0317419-0 6502 6412 CELLULAR SERVICES WATER UTILITY EXPENSE 06500 08 2.64 NOV'20 PAGER CONTRACT 188953 0317419-0 6202 6412 CELLULAR SERVICES SEWER OPERATIONS EXPENSE 06200 08 2.66 NOV'20 PAGER CONTRACT 188953 0317419-0 6402 6412 CELLULAR SERVICES STORM WATER UTILITY OPERA 06400 08 7.94 153140 11/13/2020 100379 SPRINT-NEXTEL 28.18 OCT 2020 SOLID WASTE TRACKER 188965 875483313-227 6302 6412 CELLULAR SERVICES SOLID WASTE OPERATIONS 06300 08 1.81- 188965 875483313-227 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 26.37 153141 11/13/2020 100100 STRETCHER'S 1,241.25 GUN CLEANER SOLUTION 188968 11462629 1051 6220 EQUIP SUPPLIES&PARTS PATROL SERVICES 01000 05 1,241.25 153142 11/13/2020 117634 TITLESMART INC. 174.72 REF UTIL CR@20947 CANNON RD 188989 230310/67 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 174.72 153143 11/13/2020 117670 TITLESMART,INC 162.02 REF UTIL CR@4275 206TH ST W 188985 231394/58 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 162.02 153144 11/13/2020 114013 TRADEMARK TITLE SERVICES,INC 79.65 REF UTIL CR@201 13TH ST 188976 20-6687/76 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 79.65 153145 11/13/2020 100140 US BANK TRUST N A 500.00 2015A FISCAL AGENT FEES 188934 5909045 3093 7130 FISCAL AGENT FEES 2015A 195TH ST RECONSTR P 03093 02 500.00 153146 11/13/2020 117863 VANZUILEN,LUKE 385.00 FLAG FB OFFICIAL 188996 20201014 VANZUILEN1095 6401 PROFESSIONAL SERVICES RECREATION PROGRAM SERVIC 01000 09 385.00 153147 11/13/2020 117257 WATERMARK TITLE AGENCY 63.98 REF UTIL CR@4874 189TH ST W 188986 74835 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 63.98 153148 11/13/2020 100334 WINE MERCHANTS 65.51 WINE ORDER 189031 7305060 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 R55CKS2 LOGIS600V CITY OF FARMINGTON 12/1/2020 17:01:41 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 12 11/10/2020- 12/1/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 695.23 WINE ORDER 189042 7305075 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 760.74 153149 11/13/2020 100330 WINEBOW 342.50 WINE ORDER 189017 MN00086055 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 342.50 153150 11/13/2020 116886 LABRASH PLUMBING&HEATING 3,379.50 WATER BOTTLE FILLING STATIONS 189146 6029 1015 6950 00020 MACHINERY,EQUIPMENT&TOOLS CITY HALL 01000 01 1,844.48 CMF WATER BOTTLE STATIONS 189147 6028 1090 6960 00019 FURNITURE,OFFICE EQUIP,IT PARK MAINTENANCE 01000 09 5,223.98 153151 11/20/2020 117911 BELLEFEUILLE,MCKINZEY 70.00 SKATE LESSON REFUND 189306 LTS REFUND 2501 4815 LESSONS ICE ARENA REVENUE 02500 09 70.00 153152 11/20/2020 117669 A THIS LITTLE PIGGY CATERING 616.66 LIQ LIC REF:NOV&DEC 2020 189374 LIQ LIC REF:NOV& 1001 4205 LIQUOR LICENSES GENERAL FUND REVENUES 01000 01 DEC 616.66 153153 11/20/2020 103983 AAA STRIPING SERVICE CO 660.00 2020 JPA/OVERLAY STRIPING 189360 107458 5702 6560 02003 CONTRACTUAL SERVICES SEALCOATING EXPENSES 05700 660.00 153154 11/20/2020 100058 ADVANCE AUTO PARTS 8.44 BRAKE PARTS FOR 0737 189104 2131-547555 1072 6230 VEHICLE SUPPLIES&PARTS STREET MAINTENANCE 01000 08 8.44 153155 11/20/2020 100160 AFFINITY PLUS FEDERAL CREDIT UNION 179.38 REF UTIL CR@20401 CYPRESS DR 189365 20201023537/43 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 179.38 153156 11/20/2020 109681 AMUNDSON,JASON 12.57 MOBILE FIELD FORCE TRNG LUNCH 189204 20201028-AMUNDSOIN051 6470 TRAINING&SUBSISTANCE PATROL SERVICES 01000 05 12.57 153157 11/20/2020 100028 ANCOM COMMUNICATIONS,INC 250.80 CHARGING STATIONS FOR PAGERS 189195 98098 1060 6220 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 250.80 153158 11/20/2020 113303 ARTISAN BEER COMPANY 16.00- BEER ORDER CREDIT 189259 495422 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 927.20 BEER ORDER 189277 3446914 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 911.20 153159 11/20/2020 117910 ASPEN ELECTRIC 20.50 VOID ELECT PRMT 46920 189367 VOID ELECT PRMT 1001 4327 ELECTRIC PERMITS GENERAL FUND REVENUES 01000 01 R55CKS2 LOGIS600V CITY OF FARMINGTON 12/1/2020 17:01:41 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 13 11/10/2020- 12/1/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 46920 31.50 VOID ELECT PRMT 46920 189367 VOID ELECT PRMT 1000 2020 CONTRACTS PAYABLE GENERAL FUND BALANCE SHEE 01000 46920 52.00 153160 11/20/2020 108446 ASPEN MILLS,INC. 172.40 UNIFORM ITEMS:PRICE,M. 189193 263192 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 172.40 153161 11/20/2020 100493 BELLBOY CORPORATION 288.05 LIQUOR&SPIRITS ORDER 189278 0086754300 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 27.50 BAG ORDER 189279 0102311500 6115 6250 OTHER SUPPLIES&PARTS PILOT KNOB LIQUOR 06100 02 196.21 LIQUOR SUPPLIES&MIXES ORDER 189279 0102311500 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 186.20 LIQUOR&SPIRITS ORDER 189288 0086754200 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 114.30 LIQUOR SUPPLIES&MIXES ORDER 189289 0102311400 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 82.50 BAG ORDER 189289 0102311400 6110 6250 OTHER SUPPLIES&PARTS DOWNTOWN LIQUOR REV&EXP 06100 02 894.76 153162 11/20/2020 110290 BOLTON&MENK,INC 1,748.00 OCT'20 SVS:TRNSPRTN PLN UPDTE 189362 0258916 1070 6401 PROFESSIONAL SERVICES ENGINEERING SERVICES 01000 07 1,748.00 153163 11/20/2020 114472 BREAKTHRU BEVERAGE MN BEER,LLC 5,529.86 BEER ORDER 189275 1091188774 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 8,844.00 BEER ORDER 189346 1091188775 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 14,373.86 153164 11/20/2020 114471 BREAKTHRU BEVERAGE MN WINE&SPIRITS 2,092.25 LIQUOR&SPIRITS ORDER 189274 1081204866 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 483.00 WINE ORDER 189280 1081204868 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,922.12 LIQUOR&SPIRITS ORDER 189347 1081204867 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 5,497.37 153165 11/20/2020 110218 BURNETTITLE 194,35 REF UTIL CR@5416 186TH ST W 189246 2121020-14386 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 194.35 153166 11/20/2020 108360 CANNON RIVER WINERY 312.00 WINE ORDER 189273 9038 6100 1405 10 INVENTORY DOWNTOWN LIQUOR OPERATIONS 06100 02 312.00 WINE ORDER 189283 9039 6100 1405 15 INVENTORY PILOT KNOB LIQUOR OPERATIONS 06100 02 624.00 153167 11/20/2020 108428 CDW GOVERNMENT LLC 659.47 RECEIPT PRINTER FOR DT LIQ 188916 3400428 6110 6960 FURNITURE,OFFICE EQUIP,IT DOWNTOWN LIQUOR REV&EXP 06100 02 659.47 RECEIPT PRINTER FOR PK LIQ 188916 3400428 6115 6960 FURNITURE,OFFICE EQUIP,IT PILOT KNOB LIQUOR 06100 02 84.84- 188916 3400428 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 R55CKS2 LOGIS600V CITY OF FARMINGTON 12/1/2020 17:01:41 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 14 11/10/2020- 12/1/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 1,234.10 153168 11/20/2020 112560 CELT'S IRISH PUB&GRILL 616.66 LIQ LIC REF:NOV&DEC 2020 189371 LIQ LIC REF:NOV& 1001 4205 LIQUOR LICENSES GENERAL FUND REVENUES 01000 01 DEC 616.66 153169 11/20/2020 110511 CHARTER COMMUNICATIONS HOLDINGS,LLC 16.91 NOV'20 CABLE FD STATION#2 189181 0164297110620 7400 6412 CELLULAR SERVICES INFORMATION TECHNOLOGY 07400 04 16.91 SEP'20 CABLE FD STATION#2 189329 0164297090620 A 7400 6411 TELEPHONE/CABLE SERVICES INFORMATION TECHNOLOGY 07400 04 33.82 153170 11/20/2020 117735 CLEAR RIVER BEVERAGE 636.00 BEER ORDER 189338 558675 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 636.00 153171 11/20/2020 116853 CLIMATE MAKERS INC 105.00 REPROGRAM RADIANTFLOOR HEATING 189316 102172 1050 6515 BUILDING REPAIRWAINTENANCE POLICE ADMINISTRATION 01000 05 17.50 REPROGRAM RADIANTFLOOR HEATING 189316 102172 6502 6515 BUILDING REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 17.50 REPROGRAM RADIANTFLOOR HEATING 189316 102172 6402 6515 BUILDING REPAIR/MAINTENANCE STORM WATER UTILITY OPERA 06400 08 17.50 REPROGRAM RADIANTFLOOR HEATING 189316 102172 6302 6515 BUILDING REPAIR/MAINTENANCE SOLID WASTE OPERATIONS 06300 08 17.50 REPROGRAM RADIANTFLOOR HEATING 189316 102172 6202 6515 BUILDING REPAIR/MAINTENANCE SEWER OPERATIONS EXPENSE 06200 08 17.50 REPROGRAM RADIANTFLOOR HEATING 189316 102172 1090 6515 BUILDING REPAIR/MAINTENANCE PARK MAINTENANCE 01000 09 17.50 REPROGRAM RADIANTFLOOR HEATING 189316 102172 1072 6515 BUILDING REPAIR/MAINTENANCE STREET MAINTENANCE 01000 08 210.00 153172 11/20/2020 100071 COLLEGE CITY BEVERAGE INC 9,057.75 BEER ORDER 189341 653393 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 80.00- BEER ORDER CREDIT 189342 653392 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 180.00- BEER ORDER CREDIT 189343 653334 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 58.50 BEER ORDER 189344 653312 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 8,467.93 BEER ORDER 189345 653313 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 17,324.18 153173 11/20/2020 112888 COOL AIR MECHANICAL,INC 5,415.00 50%DOWN PMT OIL SEPARATOR 189350 99404 4503 6950 MACHINERY,EQUIPMENT&TOOLS ICE ARENA CAPITAL IMPR FU 04500 09 5,415.00 153174 11/20/2020 100030 CORE&MAIN,LP 310.50 HYDRANT BREAK AWAY KIT 188955 N229898 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 310.50 153175 11/20/2020 109182 DAKOTA COMMUNICATIONS CENTER 8,458.67 DEC'20 DCC FEES 188967 FA2020-12 1060 6560 CONTRACTUAL SERVICES FIRE SERVICES 01000 06 16,917.33 DEC'20 DCC FEES 188967 FA2020-12 1050 6560 CONTRACTUAL SERVICES POLICE ADMINISTRATION 01000 05 25,376.00 R55CKS2 LOGIS600V CITY OF FARMINGTON 12/1/2020 17:01:41 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 15 11/10/2020- 12/1/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept D 153176 11/20/2020 110844 DAKOTA COUNTY FINANCIAL SRVS 144.24 SEPT'20 DIESEL FUEL 189333 00039372 1076 6272 FUEL NATURAL RESOURCES 01000 07 350.85 SEPT'20 DIESEL FUEL 189333 00039372 1060 6272 FUEL FIRE SERVICES 01000 06 228.27- 189333 00039372 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 514.87 SEPT'20 DIESEL FUEL 189333 00039372 1072 6272 FUEL STREET MAINTENANCE 01000 08 3,548.54 SEPT'20 DIESEL FUEL 189333 00039372 6302 6272 FUEL SOLID WASTE OPERATIONS 06300 08 44.04 SEPT'20 DIESEL FUEL 189333 00039372 1090 6272 FUEL PARK MAINTENANCE 01000 09 68.85 SEPT'20 GOPHER 1 FIBER LOCATES 189353 00039437 7400 6401 PROFESSIONAL SERVICES INFORMATION TECHNOLOGY 07400 04 4,443.12 153177 11/20/2020 108012 DAKOTA COUNTY REGIONAL CHAMBER COMMERCE 1,295.00 2021 DAKOTA CHAMBER DUES 189325 71836 1010 6460 MEMBER DUES&LICENSURE ADMINISTRATION 01000 01 1,295.00 153178 11/20/2020 111645 DALCO ENTERPRISES,INC 198.80 BRUSH FOR FLOOR SCRUBBER 188825 3692724 2502 6220 EQUIP SUPPLIES&PARTS ICE ARENA OPERATIONS EXPE 02500 09 7,972.96 ARENA:FLOOR SCRUBBER T00018 188945 3691777 4503 6950 00114 MACHINERY,EQUIPMENT&TOOLS ICE ARENA CAPITAL IMPR FU 04500 09 8,171.76 153179 11/20/2020 117831 DESERT ENTERPRISES 616.66 LIQUOR LIC REF:NOV&DEC 2020 189368 LIQUOR LICENSE 1001 4205 LIQUOR LICENSES GENERAL FUND REVENUES 01000 01 REFUND 616.66 153180 11/20/2020 110847 EAGLE CREEK TITLE LLC 190.75 REF UTIL CR@14 OAK ST 189242 22290/21 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 190.75 153181 11/20/2020 100149 ECM PUBLISHERS,INC 68.00 ELECTION NOTICE:VOTE LOCATNS 188964 800900 1013 6455 LEGAL NOTICES ELECTIONS 01000 01 68.00 153182 11/20/2020 115815 EDGEWATER TITLE GROUP,LLC 81.33 REF UTIL CR@1017 LARCH ST 189245 28879 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 81.33 153183 11/20/2020 117915 EL CHARRO MEXICAN RESTAURANT 616.66 LIQ LIC REF:NOV&DEC 2020 189378 LIQ LIC REF:NOV& 1001 4205 LIQUOR LICENSES GENERAL FUND REVENUES 01000 01 DEC 616.66 153184 11/20/2020 107446 ENDSON INC 616.66 LIQ LIC REF:NOV&DEC 2020 189373 LIQ LIC REF:NOV& 1001 4205 LIQUOR LICENSES GENERAL FUND REVENUES 01000 01 DEC 616.66 153185 11/20/2020 103121 ESS BROTHERS&SONS INC R55CKS2 LOGIS600V CITY OF FARMINGTON 12/1/2020 17:01:41 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 16 11/10/2020- 12/1/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 821.50 STORM SEWER GRATE 188954 AA10360 6402 6220 EQUIP SUPPLIES&PARTS STORM WATER UTILITY OPERA 06400 08 821.50 153186 11/20/2020 115191 EXECUTIVE TITLE OF MN,LLC 122.37 REF UTIL CR@20350 ERICKSON PA 189252 DV20090873/55 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 122.37 153187 11/20/2020 109931 FACTORY MOTOR PARTS 61.89 BRAKE PADS FOR 0737 188781 1-6600884 1072 6230 VEHICLE SUPPLIES&PARTS STREET MAINTENANCE 01000 08 369.95 BATTERIES FOR SQUAD TAHOES 188808 1-Z23415 1051 6230 VEHICLE SUPPLIES&PARTS PATROL SERVICES 01000 05 431.84 153188 11/20/2020 103396 FARMINGTON VFW 83.33 CLUB LIC REF:NOV&DEC 2020 189376 CLUB LIC REF:NOV 1001 4209 CLUB LICENSES GENERAL FUND REVENUES 01000 01 &DEC 83.33 153189 11/20/2020 108507 FLAHERTY'S HAPPY TYME COMPANY 80.75 TOM&JERRY MIX ORDER 189255 37329 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 80.75 153190 11/20/2020 111067 FRONTIER AG&TURF 317.84 ROLLER PARTS FOR BEFCO MOWER 188721 P27989 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 695.14 DR SHAFT/SEAL FOR 0934 188722 P27990 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 75.61 HYDRAULIC FILTER FOR 0929 188795 P28221 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 1,088.59 153191 11/20/2020 111456 GLOBAL CLOSING&TITLE SERVICES 233.74 REF UTIL CR@18815 EASTON AVE 189249 MN-09-200546 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 233.74 153192 11/20/2020 103373 GRAYBAR ELECTRIC CO INC 118.73 LIGHT SOCKETS 188789 9318430100 6602 6220 EQUIP SUPPLIES&PARTS STREETLIGHT UTILITY EXPEN 06600 08 118.73 153193 11/20/2020 100027 GREAT LAKES COCA-COLA DISTRIBUTION,LLC 553.96 POP ORDER 189340 3608211596 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 553.96 153194 11/20/2020 113797 HEALTH STRATEGIES 8,720.00 FIREFIGHTER PYSICAL EXAMS 189223 9029 1060 6405 EMPLOYMENT TESTING FIRE SERVICES 01000 06 8,720.00 153195 11/20/2020 100074 HOHENSTEINS INC 657.60 BEER ORDER 189276 371911 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 652.80 BEER ORDER 189337 371912 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,310.40 R55CKS2 LOGIS600V CITY OF FARMINGTON 12/1/2020 17:01:41 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 17 11/10/2020- 12/1/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 153196 11/20/2020 117868 HY-TEC CONSTRUCTION 9,372.65 VOID BLDG PRMT 45233 189152 VOID BLDG PRMT 1001 4305 BUILDING PERMITS GENERAL FUND REVENUES 01000 01 45233 7,221.00 VOID BLDG PRMT 45233 189152 VOID BLDG PRMT 6501 4640 WATER AVAILABILITY CHARGE WATER UTILITY REVENUES 06500 08 45233 1,665.00 VOID BLDG PRMT 45233 189152 VOID BLDG PRMT 3900 4335 CITY SEWER ACCESS CHARGE SANITARY SEWER TRUNK 03900 07 45233 7,455.00 VOID BLDG PRMT 45233 189152 VOID BLDG PRMT 6200 2425 MCES SAC(SWR AVAIL CHG) SEWER OPERATIONS 06200 08 45233 75.00 VOID BLDG PRMT 45233 189152 VOID BLDG PRMT 1001 4325 SEWER PERMITS GENERAL FUND REVENUES 01000 01 45233 743.20 VOID BLDG PRMT 45233 189152 VOID BLDG PRMT 1000 2420 BUILDING PERMIT SURCHARGE GENERAL FUND BALANCE SHEE 01000 45233 75.00 VOID BLDG PRMT 45233 189152 VOID BLDG PRMT 6501 4320 WATER PERMITS WATER UTILITY REVENUES 06500 08 45233 24,154.46 VOID BLDG PRMT45233 189152 VOID BLDG PRMT 7500 2255 DEPOSITS PAYABLE ESCROW FUND 07500 02 45233 24,154.46- VOID BLDG PRMT 45233 189152 VOID BLDG PRMT 7500 2255 DEPOSITS PAYABLE ESCROW FUND 07500 02 45233 24,154.46 VOID BLDG PRMT 45233 189152 VOID BLDG PRMT 4600 2255 DEPOSITS PAYABLE PRIVATE CAPITAL PROJECTS 04600 07 45233 50,761.31 153197 11/20/2020 117341 INBOUND BREWCO 146.00 BEER ORDER 189286 8736 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 146.00 153198 11/20/2020 113417 INDEED BREWING COMPANY,LLC 239.60 BEER ORDER 189284 95296 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 239.60 153199 11/20/2020 107414 JEFFERSON FIRE&SAFETY INC 224.95 TFT STORZ LEVER RPLCMNT KIT 189196 IN123225 1060 6220 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 224.95 153200 11/20/2020 109846 JJ TAYLOR DISTRIBUTING COMPANY OF MN INC 5,600.40 BEER ORDER 189256 3106967 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 7,089.110 BEER ORDER 189339 3139876 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 12,689.50 153201 11/20/2020 100033 JOHNSON BROTHERS LIQUOR COMPANY 649.90 WINE ORDER 189182 1671026 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 2,248.67 SVEDKA VODKA ORDER 189260 1681204 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 602.82 WINE ORDER 189261 1681205 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 226.51 WINE ORDER 189262 1681206 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 R55CKS2 LOGIS600V CITY OF FARMINGTON 12/1/2020 17:01:41 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 18 11/10/2020- 12/1/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 583.22 WINE ORDER 189263 1681207 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 208.33 NEW AMSTERDAM VODKA 189264 1681208 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 515.89 WINE ORDER 189265 1681209 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,475.06 LIQUOR&SPIRITS ORDER 189266 1681210 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,430.06 LIQUOR&SPIRITS ORDER 189295 1681144 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 51.20 KINKY COCKTAILS ORDER 189296 1681143 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 690.13 WINE ORDER 189297 1681142 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,296.74 LIQUOR&SPIRITS ORDER 189298 1681141 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,421.75 WINE ORDER 189299 1681140 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,316.78 SVEDKA VODKA ORDER 189300 1681139 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 33.51 AGALIMA MIXES ORDER 189301 1681138 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,120.41 WINE ORDER 189302 1681137 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 825.65 LIQUOR&SPIRITS ORDER 189303 1681136 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 16,696.63 153202 11/20/2020 116827 JOHNSON LITHO GRAPHICS OF EAU CLAIRE LTD 1,940.00 CALENDAR CLINGS 189331 101312 6502 6570 PROGRAMMING EXPENSE WATER UTILITY EXPENSE 06500 08 6,220.13 CALENDAR CLINGS 189331 101312 6302 6450 OUTSIDE PRINTING SOLID WASTE OPERATIONS 06300 08 400.13- 189331 101312 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 7,760.00 153203 11/20/2020 100109 LAKEVILLE TROPHY COMPANY 42.58 SFTBALL CHAMPION TROPHY 189313 25875 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 42.58 153204 11/20/2020 117914 LAS ENCHILADAS 616.66 LIQ LIC REF:NOV&DEC 2020 189377 LIQ LIC REF:NOV& 1001 4205 LIQUOR LICENSES GENERAL FUND REVENUES 01000 01 DEC 616.66 153205 11/20/2020 117521 LEGACYTITLE 50.02 REF UTIL CR@20959 CATALINA WY 189253 MN14890/37 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 50.02 153206 11/20/2020 115622 LONE OAK STORES LLC 616.66 LIQ LIC REF:NOV&DEC 2020 189372 LIQ LIC REF:NOV& 1001 4205 LIQUOR LICENSES GENERAL FUND REVENUES 01000 01 DEC 616.66 153207 11/20/2020 100155 METROPOLITAN COUNCIL ENVIRO SERVICES 173.95- OCT'20 MCES SAC FEES 189351 OCT'20 SAC FEES 6201 5030 SAC CHARGE RETAINER SEWER OPERATIONS REVENUE 06200 08 9,940.00 OCT'20 MCES SAC FEES 189351 OCT'20 SAC FEES 6200 2425 MCES SAC(SWR AVAIL CHG) SEWER OPERATIONS 06200 08 9,766.05 153208 11/20/2020 102725 MINNESOTA DEPT OF HEALTH 17,596.00 4TH QTR 2020 SVS CONNECT FEES 189314 1190008 OCT-DEC'20 6502 6560 CONTRACTUAL SERVICES WATER UTILITY EXPENSE 06500 08 R55CKS2 LOGIS600V CITY OF FARMINGTON 12/1/2020 17:01:41 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 19 11/10/2020- 12/1/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 17,596.00 153209 11/20/2020 100084 MINNESOTA DEPT OF PUBLIC SAFETY 20.00 2021 BUYER CARD-DT LIQ 189254 2021 BUYER CARD 6100 1505 PREPAID EXPENSES LIQUOR OPERATIONS 06100 02 20.00 2021 BUYER CARD-PK LIQ 189254 2021 BUYER CARD 6100 1505 PREPAID EXPENSES LIQUOR OPERATIONS 06100 02 40.00 153210 11/20/2020 101374 MINNESOTA DEPT OF PUBLIC SAFETY 2,098.83 F#0728 V#11299 21 GMC SIERRA 189307 F#0728 5602 6940 VEHICLES GEN CAPITAL EQUIP FUND EX 05600 2,098.83 153211 11/20/2020 100186 MN CHIEFS OF POLICE ASSOCIATION 50.00 CRITICAL ISSUES TRNG:VAN DORN 188802 11086 1051 6470 TRAINING&SUBSISTANCE PATROL SERVICES 01000 05 50.00 153212 11/20/2020 100322 MN NCPERS LIFE INSURANCE 16.00 189328 1119201128493 7000 2119 PERA LIFE INS PAYABLE EMPLOYEE EXPENSE FUND 07000 02 16.00 153213 11/20/2020 117912 MOHAMED,ABDIRAHMAN 480.00 REF UTIL CR@18273 DUNBURY AVE 189336 18273 DUNBRYAV 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 DUP PYMT 480.00 153214 11/20/2020 100544 MOTOROLA SOLUTIONS INC 38,264.50 FIRE RADIOS(8) 189240 41293665 1060 6950 00019 MACHINERY,EQUIPMENT&TOOLS FIRE SERVICES 01000 06 38,264.50 153215 11/20/2020 108225 MUNICIPAL EMERGENCY SERVICES,INC 470.00 FIRE HELMETS(2) 189236 IN1497724 1060 6290 1 TURNOUT GEAR FIRE SERVICES 01000 06 1,460.10 FIRE GLOVES 189237 IN1499329 1060 6290 1 TURNOUT GEAR FIRE SERVICES 01000 06 1,930.10 153216 11/20/2020 102644 NORTHERN SAFETY TECHNOLOGY,INC 136.89 SQD 61 SPOTLIGHT REPAIR PARTS 188797 51282 1051 6230 VEHICLE SUPPLIES&PARTS PATROL SERVICES 01000 05 136.89 153217 11/20/2020 112901 ON SITE TITLE LLC 102.87 REF UTIL CR@ 701 11TH ST 189243 20-867 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 153.19 REF UTIL CR@18770 ESSENCE TRL 189247 20-866 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 256.06 153218 11/20/2020 100290 PAUSTIS&SONS WINE COMPANY 30.00- WINE ORDER CREDIT 189257 107991 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 154.50 WINE ORDER 189271 107618 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 453.75 WINE ORDER 189287 107619 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 578.25 R55CKS2 LOGIS600V CITY OF FARMINGTON 12/1/2020 17:01:41 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 20 11/10/2020- 12/1/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 153219 11/20/2020 100093 PELLICCI HARDWARE&RENTAL 19.99 45 PC SCREWDRIVING SET 189197 K39674/F 1060 6950 MACHINERY,EQUIPMENT&TOOLS FIRE SERVICES 01000 06 19.01 MOUNTNG TAPE/NUTS/BOLTS 189197 K39674/F 1060 6220 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 252.00 24PK BOTTLED WATER(84) 189198 75244/F 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01000 06 3.99 DISC FML FINS16 189230 39813/F'20 1060 6220 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 15.98 OUTLET TESTER 120V AC GB 189230 39813/F'20 1060 6950 MACHINERY,EQUIPMENT&TOOLS FIRE SERVICES 01000 06 310.97 153220 11/20/2020 100034 PHILLIPS WINE AND SPIRITS,INC 343.52 LIQUOR&SPIRITS ORDER 189267 6119980 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 121.02 WINE ORDER 189268 6119981 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 51.01 DAILY'S ORDER 189269 6119982 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 3,385.18 LIQUOR&SPIRITS ORDER 189292 6119930 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 683.59 WINE ORDER 189293 6119931 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 164.83 WINE ORDER 189294 6119932 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 4,749.15 153221 11/20/2020 117491 POMP'S TIRE SERVICE,INC 522.68 DRIVE TIRES 189324 210495307 7200 6232 VEHICLE/EQUIPMENT TIRES FLEET OPERATIONS 07200 08 522.68 153222 11/20/2020 117228 QUICK SHIP PLUS 110.13 SHIPTRANSPOTER/CAMERA 188793 15801 6202 6445 POSTAGE/SHIPPING FEES SEWER OPERATIONS EXPENSE 06200 08 110.13 153223 11/20/2020 113930 RANGER CHEVROLET 31,617.40 F#728 ENG V#11299 GMC SIERRA 189221 9987852 GMC SIERRP5602 6940 VEHICLES GEN CAPITAL EQUIP FUND EX 05600 250 31,617.40 153224 11/20/2020 117829 REBEL CHEF LLC 616.66 LIQ LIC REF:NOV&DEC 2020 189369 LIQ LIC REF:NOV& 1001 4205 LIQUOR LICENSES GENERAL FUND REVENUES 01000 01 DEC 616.66 153225 11/20/2020 117089 ROCK HARD LANDSCAPE SUPPLY 66.00 CLASS 5 BUFF:PRKNG LOT REPAIR 188822 96899 1090 6250 OTHER SUPPLIES&PARTS PARK MAINTENANCE 01000 09 66.00 153226 11/20/2020 103092 ROCKMOUNT RESEARCH AND ALLOYS INC 410.83 GRINDING WHEELS 189191 1257564 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 410.83 153227 11/20/2020 112172 SCOTT COUNTY ABSTRACT&TITLE CO.,INC 41.05 REF UTIL CR@19125 EVEREST TRL 189250 1-32600/25 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 41.05 R55CKS2 LOGIS600V CITY OF FARMINGTON 12/1/2020 17:01:41 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 21 11/10/2020- 12/1/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept D 153228 11/20/2020 116850 SOUTH METRO SWAT 730.20 2020 FEES FOR FORT MCCOY 189205 2020 FT MCCOY 1051 6470 TRAINING&SUBSISTANCE PATROL SERVICES 01000 05 730.20 153229 11/20/2020 112051 SOUTHERN GLAZER'S OF MN 1,380.26 LIQUOR&SPIRITS ORDER 189258 2015307 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 3.84 LIQUOR&SPIRITS ORDER 189285 5063164 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 5,588.01 LIQUOR&SPIRITS ORDER 189348 2015311 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 751.92 WINE ORDER 189349 2017729 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 7,724.03 153230 11/20/2020 117822 STAHL ENTERPRISES,INC 616.66 LIQ LIC REF:NOV&DEC 2020 189370 LIQ LIC REF:NOV& 1001 4205 LIQUOR LICENSES GENERAL FUND REVENUES 01000 01 DEC 616.66 153231 11/20/2020 113754 TITLE SMART,INC 269.21 REF UTIL CR@18793 EASTON CT 189248 231668/95 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 316.92 REF UTIL CR@4529 199TH ST W 189356 234542/45 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 586.13 153232 11/20/2020 115540 TITLE SMART,INC 67.20 REF UTIL CR@1005 3RD ST 189354 231759/66 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 67.20 153233 11/20/2020 117634 TITLESMART INC. 109.75 REF UTIL CR@19516 EWING ST 189251 230996/68 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 109.75 153234 11/20/2020 112307 T-MOBILE USA INC 6.66 OCT'20 GPS SERVICE 189151 823329497 OCT'20 6502 6412 CELLULAR SERVICES WATER UTILITY EXPENSE 06500 08 6.66 OCT'20 GPS SERVICE 189151 823329497 OCT'20 6202 6412 CELLULAR SERVICES SEWER OPERATIONS EXPENSE 06200 08 6.67 OCT'20 GPS SERVICE 189151 823329497 OCT'20 6402 6412 CELLULAR SERVICES STORM WATER UTILITY OPERA 06400 08 19.99 153235 11/20/2020 116742 TOWMASTER,LLC 706.69 OIL TANK FOR 0705 189217 432099 1072 6230 VEHICLE SUPPLIES&PARTS STREET MAINTENANCE 01000 08 706.69 153236 11/20/2020 114013 TRADEMARK TITLE SERVICES,INC 18.28 REF UTIL CR@3057 211TH ST W 189355 20-6865/64 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 18.28 153237 11/20/2020 111230 UGLY MUG RESTAURANT 616.66 LIQ LIC REF:NOV&DEC 2020 189375 LIQ LIC REF:NOV& 1001 4205 LIQUOR LICENSES GENERAL FUND REVENUES 01000 01 DEC 616.66 R55CKS2 LOGIS600V CITY OF FARMINGTON 12/1/2020 17:01:41 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 22 11/10/2020- 12/1/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept D 153238 11/20/2020 112567 ULTIMATE SAFETY CONCEPTS,INC 401.20 SENSOR FOR 5 GAS MONITOR 189194 191460 1060 6220 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 401.20 153239 11/20/2020 109418 VALLEY-RICH CO,INC 8,664.24 PILOT KNOB G.V.REPAIR 189315 28873 6502 6401 PROFESSIONAL SERVICES WATER UTILITY EXPENSE 06500 08 8,664.24 153240 11/20/2020 108808 VINOCOPIA,INC 439.33 WINE ORDER 189272 0267585-IN 6100 1405 10 INVENTORY DOWNTOWN LIQUOR OPERATIONS 06100 02 295.50 WINE ORDER 189281 0267512-IN 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 257.50 WINE ORDER 189282 0267581-IN 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 132.00 WINE ORDER 189290 0267869-IN 6100 1405 10 INVENTORY DOWNTOWN LIQUOR OPERATIONS 06100 02 1,124.33 153241 11/20/2020 100334 WINE MERCHANTS 267.02 WINE ORDER 189270 7305957 6100 1405 10 INVENTORY DOWNTOWN LIQUOR OPERATIONS 06100 02 582.79 WINE ORDER 189291 7305939 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 849.81 153242 11/20/2020 113569 WS&D PERMIT SERVICE 140.00 VOID PRMTS 46762&46907 189361 VOID PRMTS 46762&1001 4305 BUILDING PERMITS GENERAL FUND REVENUES 01000 01 46907 140.00 153243 11/25/2020 103983 AAA STRIPING SERVICE CO 345.00 2020 JPA/OVERLAY STRIPING 189410 107488 5702 6560 CONTRACTUAL SERVICES SEALCOATING EXPENSES 05700 345.00 153244 11/25/2020 100058 ADVANCE AUTO PARTS 12.86 EPDXY 189101 2131-548188 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 12.86 EPDXY FOR 0738 189103 2131-548186 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 14.04 HOSE FITTINGS FOR 3215 189106 2131-548232 6302 6230 VEHICLE SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 .90- 189106 2131-548232 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 38.86 153245 11/25/2020 100253 CAMPBELL KNUTSON,P.A. 234.80 OCT'20 LEGAL FEES-FORFEITURE 189208 1852-0003G OCT'20 1050 6403 LEGAL POLICE ADMINISTRATION 01000 05 102.20 OCT'20 LEGAL FEES-POLICE 189209 1852=0004G OCT'20 1050 6403 LEGAL POLICE ADMINISTRATION 01000 05 9,546.31 OCT-20 LEGAL FEES-PROSECUTION 189210 1852-0999G OC720 1050 6403 LEGAL POLICE ADMINISTRATION 01000 05 33.40 OCT'19 LEGAL FEES-EDA GENERAL 189212 1852-0013G OCT'20 2000 6403 LEGAL HRA/ECONOMIC DEVELOPMENT 02000 03 50.10 OCT'l9 LEGAL-EDA/HMESTD CHRCH 189213 1852-00596 OCT'20 2000 6403 LEGAL HRA/ECONOMIC DEVELOPMENT 02000 03 83.50 OCT'20 LEGAL FEES-GENERAURETN 189394 1852-000OG OCT'20 1094 6403 LEGAL PARK&RECREATION ADMIN 01000 09 50.10 OCT'20 LEGAL FEES-GENERAURETN 189394 1852-000OG OCT'20 1011 6403 LEGAL HUMAN RESOURCES 01000 04 133.60 OCT'20 LEGAL FEES-GENERAURETN 189394 1852-000OG OCT'20 1070 6403 LEGAL ENGINEERING SERVICES 01000 07 66.80 OCT'20 LEGAL FEES-GENERAURETN 189394 1852-000OG OCT'20 1050 6403 LEGAL POLICE ADMINISTRATION 01000 05 R55CKS2 LOGIS600V CITY OF FARMINGTON 12/1/2020 17:01:41 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 23 11/10/2020- 12/1/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 445.80 OCT'20 LEGAL FEES-GENERAURETN 189394 1852-000OG OCT'20 1030 6403 i LEGAL PLANNING&ZONING 01000 03 534.40 OCT'20 LEGAL FEES-GENERAURETN 189394 1852-000OG OCT'20 1005 6403 LEGAL LEGISLATIVE CONTROL 01000 01 240.00 OCT'20 LEGAL FEES-GENERAURETN 189394 1852-000OG OCT'20 1010 6403 LEGAL ADMINISTRATION 01000 01 11,521.01 153246 11/25/2020 100578 GEMSTONE CONCRETE MATERIALS,LLC 375.00 CONCRETE FOR RECYCLE CONTAINER 189092 C2282400 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 535.00 CONCRETE FOR RECYCLE CONTAINER 189117 C2283259 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 910.00 153247 11/25/2020 110591 CONSOLIDATED COMMUNICATIONS 2,018.87 NOV'20 PHONE LINES 188936 507-150-1389 7400 6411 TELEPHONE/CABLE SERVICES INFORMATION TECHNOLOGY 07400 04 NOV'20 2,018.87 153248 11/25/2020 100133 DAKOTA COUNTY FINANCIAL SRVS 1,026.52 OCT-20 RADIO SUBSCRIBER FEES 189391 00039394 1050 6560 CONTRACTUAL SERVICES POLICE ADMINISTRATION 01000 05 1,539.78 OC720 RADIO SUBSCRIBER FEES 189391 00039394 1060 6560 CONTRACTUAL SERVICES FIRE SERVICES 01000 06 2,566.30 153249 11/25/2020 100241 DELEGARD TOOL CO 112.56 FAST FIT GLOVES(12) 189190 28491 7200 6290 UNIFORMS&CLOTHING FLEET OPERATIONS 07200 08 16.18 MICRO STREAM 189190 28491 7200 6950 MACHINERY,EQUIPMENT&TOOLS FLEET OPERATIONS 07200 08 11.52 UPHLSTRY REMOVER(2) 189190 28491 7200 6950 MACHINERY,EQUIPMENT&TOOLS FLEET OPERATIONS 07200 08 193.68 HEX BIT SCKT SET/PRYBAR SET(2) 189190 28491 7200 6950 MACHINERY,EQUIPMENT&TOOLS FLEET OPERATIONS 07200 08 100.20 HEAT SHRNK MERCH/GREASE GUN 189190 28491 7200 6950 MACHINERY,EQUIPMENT&TOOLS FLEET OPERATIONS 07200 08 91.23 TOOL CART 189215 29122 7200 6950 MACHINERY,EQUIPMENT&TOOLS FLEET OPERATIONS 07200 08 525.37 153250 11/25/2020 100149 ECM PUBLISHERS,INC 477.73 PUMPKIN RECYCLING AD 188960 803279 6302 6492 ADVERTISING SOLID WASTE OPERATIONS 06300 08 30.73- 188960 803279 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 447.00 153251 11/25/2020 115815 EDGEWATER TITLE GROUP,LLC 413.38 REF UTIL CR@18888 EAGLEWD TRL 189382 29570 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 413.38 153252 11/25/2020 115191 EXECUTIVE TITLE OF MN,LLC 174.86 REF UTIL CR@5138 LWR 183 ST W 189379 MJ20100273/76 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 174.86 153253 11/25/2020 115414 EXECUTIVE TITLE SERVICE,INC 157.35 REF UTIL CR@20215 AKIN RD 189384 15086/56 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 157.35 153254 11/25/2020 109931 FACTORY MOTOR PARTS R55CKS2 LOGIS600V CITY OF FARMINGTON 12/1/2020 17:01:41 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 24 11/10/2020- 12/1/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept D 12.36 STOCK FILTERS 188811 95-314612 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 65.50 STOCK FILTERS 188812 1-6610074 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 377.76 BATTERIES 189192 1-Z23501 1051 6230 VEHICLE SUPPLIES&PARTS PATROL SERVICES 01000 05 455.62 153255 11/25/2020 100077 FRONTIER COMMUNICATIONS 96.23 NOV'20 WELL HOUSE LINE 189352 651-460-4974 7400 6411 TELEPHONE/CABLE SERVICES INFORMATION TECHNOLOGY 07400 04 NOV'20 96.23 153256 11/25/2020 116906 GOODPOINTE TECHNOLOGY,LLC 4,030.00 ICON ASSET MGMT MAINTAGRMNT 189411 4118 1070 6505 EQUIPMENT REPAIR/MAINTENANCE ENGINEERING SERVICES 01000 07 4,030.00 153257 11/25/2020 100024 GOPHER STATE ONE-CALL 143.55 OCTOBER 2020 LOCATES 188807 0100389 6502 6401 PROFESSIONAL SERVICES WATER UTILITY EXPENSE 06500 08 143.55 OCTOBER 2020 LOCATES 188807 0100389 6202 6401 PROFESSIONAL SERVICES SEWER OPERATIONS EXPENSE 06200 08 143.55 OCTOBER 2020 LOCATES 188807 0100389 6402 6401 PROFESSIONAL SERVICES STORM WATER UTILITY OPERA 06400 08 430.65 153258 11/25/2020 116589 GREATAMERICA FINANCIAL SERVICES 217.85 NOV'20 POSTAGE METER RENTAL 188993 28160951 1010 6555 RENTAL OF EQUIPMENT ADMINISTRATION 01000 01 217.85 153259 11/25/2020 107414 JEFFERSON FIRE&SAFETY INC 2,532.31 TURNOUT GEAR BAGS(60) 189238 PB000432 1060 6290 1 00019 TURNOUT GEAR FIRE SERVICES 01000 06 2,532.31 153260 11/25/2020 110501 LAND TITLE INC 123.81 REF UTIL CR@5144 UPR 183 ST W 189380 622453 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 123.81 153261 11/25/2020 100354 LEAGUE OF MN CITIES INSURANCE TRUST 135,650.00 3RD INSTALL 2020 WRKS COMP 188927 10002620 110420 7000 6159 WORKERS COMP EMPLOYEE EXPENSE FUND 07000 02 135,650.00 153262 11/25/2020 100049 LOCAL GOVERNMENT INFORMATION SYSTEMS 2,442.00 OCT-20 APPL SUPPORT INVOICE 188929 49425 1011 6402 DATA PROCESSING HUMAN RESOURCES 01000 04 4,638.00 OCT-20 APPL SUPPORT INVOICE 188929 49425 1021 6402 DATA PROCESSING GENERAL ACCOUNTING 01000 02 2,941.00 OCT'20 APPL SUPPORT INVOICE 188929 49425 1031 6402 DATA PROCESSING BUILDING INSPECTIONS 01000 07 2,297.00 OCT-20 APPL SUPPORT INVOICE 188929 49425 1050 6402 DATA PROCESSING POLICE ADMINISTRATION 01000 05 371.00 OCT'20 APPL SUPPORT INVOICE 188929 49425 1060 6402 DATA PROCESSING FIRE SERVICES 01000 06 1,135.00 OCT'20 APPL SUPPORT INVOICE 188929 49425 6202 6402 DATA PROCESSING SEWER OPERATIONS EXPENSE 06200 08 968.00 OCT'20 APPL SUPPORT INVOICE 188929 49425 6302 6402 DATA PROCESSING SOLID WASTE OPERATIONS 06300 08 968.00 OCT'20 APPL SUPPORT INVOICE 188929 49425 6402 6402 DATA PROCESSING STORM WATER UTILITY OPERA 06400 08 968.00 OCT'20 APPL SUPPORT INVOICE 188929 49425 6502 6402 DATA PROCESSING WATER UTILITY EXPENSE 06500 08 R55CKS2 LOGIS600V CITY OF FARMINGTON 12/1/2020 17:01:41 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 25 11/10/2020- 12/1/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 3,448.00 OCT'20 APPL SUPPORT INVOICE 188929 49425 7400 6402 DATA PROCESSING INFORMATION TECHNOLOGY 07400 04 20,176.00 153263 11/25/2020 112658 LOCATION TECHNOLOGIES,INC 46.22 NOV 2020 GPS SERVICES 188948 15952 6302 6412 CELLULAR SERVICES SOLID WASTE OPERATIONS 06300 08 2.97- 188948 15952 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 43.25 153264 11/25/2020 116399 LUNDE,JOSHUA 70.68 REF UTIL CR @ 1217 LOCUST ST 167327 1217 LOCUST ST 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 70.68 153265 11/25/2020 117708 M/1 HOMES 3,000.00 ER 3760 192ND ST W 189387 ER 3760 192ND ST W 4600 2255 DEPOSITS PAYABLE PRIVATE CAPITAL PROJECTS 04600 07 3,000.00 ER 19149 COLONIAL TRL 189388 ER 19149 COLONIAL 4600 2255 DEPOSITS PAYABLE PRIVATE CAPITAL PROJECTS 04600 07 TRL 6,000.00 153266 11/25/2020 113442 METERING&TECHNOLOGY SOLUTIONS 55.92 TEST METER 189095 18200 6502 6401 PROFESSIONAL SERVICES WATER UTILITY EXPENSE 06500 08 55.92 153267 11/25/2020 100095 METROPOLITAN COUNCIL ENVIRONMENTAL SVS 127,380.78 DEC 2020 WASTE WATER MCES FEES 189099 0001115952 6202 6565 MCES FEES SEWER OPERATIONS EXPENSE 06200 08 127,380.78 153268 11/25/2020 100070 MINNESOTA VALLEY TESTING LABORATORIES 73.50 BAC-T SAMPLE(7) 188806 1058948 6502 6401 PROFESSIONAL SERVICES WATER UTILITY EXPENSE 06500 08 73.50 153269 11/25/2020 101313 MN DEPT OF LABOR&INDUSTRY 100.00 ELEVATOR ANNUAL OPERATOR 189121 ALRO112619X 1015 6505 EQUIPMENT REPAIR/MAINTENANCE CITY HALL 01000 01 100.00 153270 11/25/2020 113031 NRG RELIABILITY SOLUTIONS LLC 1,651.53 OCT'20 ELEC LAW ENFORCE CNTR 189395 3346-2011 1050 6422 ELECTRIC POLICE ADMINISTRATION 01000 05 1,651.53 153271 11/25/2020 117848 PEMBER COMPANIES 21,639.91 2020 SIDEWALK REPLACEMENT 189392 11867 1072 6560 CONTRACTUAL SERVICES STREET MAINTENANCE 01000 08 21,639.91 153272 11/25/2020 100377 PREMIER LIGHTING,INC 200.31 LIGHT BULBS 189393 56444 1015 6240 BUILDING SUPPLIES&PARTS CITY HALL 01000 01 200.31 153273 11/25/2020 110760 PRO-TECH DESIGN,INC 464.10 PD AFTER HRS DOOR CONTROL CARD 188912 98701 1050 6505 EQUIPMENT REPAIR/MAINTENANCE POLICE ADMINISTRATION 01000 05 R55CKS2 LOGIS600V CITY OF FARMINGTON 12/1/2020 17:01:41 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 26 11/10/2020- 12/1/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 497.00 LABOR FOR CONTROL CARD INSTALL 188912 98701 1050 6401 PROFESSIONAL SERVICES POLICE ADMINISTRATION 01000 05 961.10 153274 11/25/2020 108826 RED WING,CITY OF 68,028.23 OCT'20 TIPPING FEES 189334 0049432 6302 6401 PROFESSIONAL SERVICES SOLID WASTE OPERATIONS 06300 08 68,028.23 153275 11/25/2020 116843 RESULTS TITLE 129.34 REF UTIL CR@19256 EUCLID PATH 189383 20-10155 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 129.34 153276 11/25/2020 102929 RIVERLAND COMMUNITY COLLEGE 1,500.00 LIVE BURN TRAILER 189224 739795 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01000 06 1,500.00 LIVE BURN TRAILER 189225 739768 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01000 06 1,500.00 LIVE BURN TRAILER 189226 739870 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01000 06 4,500.00 153277 11/25/2020 114206 SUN LIFE FINANCIAL 2,877.45 SEPT-20 LTD INSURANCE 189385 237780 SEPT'20 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 2,877.45 153278 11/25/2020 114206 SUN LIFE FINANCIAL 2,877.45 OCT-20 LTD INSURANCE 189386 237780 OCT'20 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 2,877.45 153279 11/25/2020 114206 SUN LIFE FINANCIAL 2,877.45 NOV'20 LIFE INSURANCE 189409 237780 NOV'20 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 2,877.45 153280 11/25/2020 115540 TITLE SMART,INC 112.33 REF UTIL CR@5583 EUCLID WAY 189381 231836/77 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 112.33 153281 11/25/2020 113972 YOUNGFIELD HOMES 3,000.00 ER 6677 U 210TH ST W 189389 ER 6677 U 210TH ST 4600 2255 DEPOSITS PAYABLE PRIVATE CAPITAL PROJECTS 04600 07 W 3,000.00 ER 6650 U 210TH ST W 189390 ER 6650 U 210TH ST 4600 2255 DEPOSITS PAYABLE PRIVATE CAPITAL PROJECTS 04600 07 W 6,000.00 20201022 10/19/2020 108980 MINNESOTA ENERGY RESOURCES CORPORATION 97.63 SEPT'20 GAS RRC 188080 0507948331 SEPT'20 1093 6423 NATURAL GAS SENIOR CITIZEN SERVICES 01000 09 18.00 SEPT'20 GAS WELL HOUSE 1 OAK S 188103 0506788875 SEPT'20 6502 6423 NATURAL GAS WATER UTILITY EXPENSE 06500 08 53.39 SEPT'20 GAS FIRE STATION 1 188120 0506565319 SEPT'20 1060 6423 NATURAL GAS FIRE SERVICES 01000 06 59.56 SEPT'20 GAS FIRE STATION 2 188121 0505001779 SEPT20 1060 6423 NATURAL GAS FIRE SERVICES 01000 06 436.22 SEPT'20 GAS POLICE DEPT 188138 0505974444 SEPT'20 1050 6423 NATURAL GAS POLICE ADMINISTRATION 01000 05 774.82 SEPT20 GAS ARENA 188167 0502346011 SEPT'20 2502 6423 NATURAL GAS ICE ARENA OPERATIONS EXPE 02500 09 R55CKS2 LOGIS600V CITY OF FARMINGTON 12/1/2020 17:01:41 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 27 11/10/2020- 12/1/2D20 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 7.52 SEPT'20 GAS 1ST STREET GARAGE 188169 0505547424 SEPT'20 1072 6423 NATURAL GAS STREET MAINTENANCE 01000 08 7.52 SEPT'20 GAS 1ST STREET GARAGE 188169 0505547424 SEPT'20 1090 6423 NATURAL GAS PARK MAINTENANCE 01000 09 .52- 188169 0505547424 SEPT'20 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 7.49 SEPT'20 GAS 1ST STREET GARAGE 188169 0505547424 SEPT'20 6202 6423 NATURAL GAS SEWER OPERATIONS EXPENSE 06200 08 8.04 SEPT'20 GAS 1ST STREET GARAGE 188169 0505547424 SEP720 6302 6423 NATURAL GAS SOLID WASTE OPERATIONS 06300 08 7.52 SEPT'20 GAS 1ST STREET GARAGE 188169 0505547424 SEPT'20 6402 6423 NATURAL GAS STORM WATER UTILITY OPERA 06400 08 7.43 SEPT'20 GAS 1ST STREET GARAGE 188169 0505547424 SEPT'20 6502 6423 NATURAL GAS WATER UTILITY EXPENSE 06500 08 722.51 SEPT'20 GAS CITY HALL 188170 0505346885 SEPT'20 1015 6423 NATURAL GAS CITY HALL 01000 01 37.03 SEPT'20 GAS CMF 188610 0502362190 SEPT'20 1072 6423 NATURAL GAS STREET MAINTENANCE 01000 08 37.02 SEPT'20 GAS CMF 188610 0502362190 SEP720 1090 6423 NATURAL GAS PARK MAINTENANCE 01000 09 2.55- 188610 0502362190 SEPT'20 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 37.02 SEPT'20 GAS CMF 188610 0502362190 SEPT'20 6202 6423 NATURAL GAS SEWER OPERATIONS EXPENSE 06200 08 39.57 SEPT'20 GAS CMF 188610 0502362190 SEPT'20 6302 6423 NATURAL GAS SOLID WASTE OPERATIONS 06300 08 37.02 SEPT'20 GAS CMF 188610 0502362190 SEPT'20 6402 6423 NATURAL GAS STORM WATER UTILITY OPERA 06400 08 36.58 SEPT'20 GAS CMF 188610 0502362190 SEPT'20 6502 6423 NATURAL GAS WATER UTILITY EXPENSE 06500 08 48.91 SEPT'20 GAS DT LIQ STORE 188937 0503154879 SEPT'20 6110 6423 NATURAL GAS DOWNTOWN LIQUOR REV&EXP 06100 02 2,477.73 20201023 10/28/2020 102160 CARDMEMBER SERVICES 530.00 2019 GFOA CERT OF EXCELLENCE 187950 6913-1731-9/15 1021 6460 MEMBER DUES&LICENSURE GENERAL ACCOUNTING 01000 02 1,512.57 SEPT'20 VERIZON DATA SERVICE 187951 6913-7916-9/18 7400 6412 CELLULAR SERVICES INFORMATION TECHNOLOGY 07400 04 3,089.06 SEPT-20 CELL PHONE SERVICE 187951 6913-7916-9/18 7400 6412 CELLULAR SERVICES INFORMATION TECHNOLOGY 07400 04 41.44 SEPT'20 CELL PHONE SERVICE 187951 6913-7916-9/18 2000 6412 20 CELLULAR SERVICES-DBB HRA/ECONOMIC DEVELOPMENT 02000 03 49.99 75'HDMI CBL:SPLT MNTR FEED 188028 0915-0416-9/21 1050 6220 EQUIP SUPPLIES&PARTS POLICE ADMINISTRATION 01000 05 19.69 TV MNT:TV PD INTRVEIW RM 188030 0915-1833-9/15 7400 6220 00019 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 10.99 HDMI CABLE FOR 170 TV 188030 0915-1833-9/15 7400 6220 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 14.84 EXTENSION CORD FOR 170 TV 188030 0915-1833-9/15 7400 6220 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 53.17 5 PHONE HOLDERS:SNTATION TRKS 188031 0915-2760-9/11 6302 6220 EQUIP SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 3.42- 188031 0915-2760-9/11 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 49.44 6 CABLE ADAPTERS:SURFACE USRS 188032 0915-9180-9/10 7400 6220 00019 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 11.99 CORD HIDER KIT:TV CBL MGNT 188033 0915-6493-9/8 7400 6220 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 29.46 2 CBLE PLATES:TV CBL MNGT 188033 0915-6493-9/8 7400 6220 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 219.99 43"TV:PD INTERVIEW RM 188034 0915-9868-9/21 7400 6960 00019 FURNITURE,OFFICE EQUIP,IT INFORMATION TECHNOLOGY 07400 04 65.97 BINGO CARD PUNCH OUT 188035 3544-7097-9/9 1093 6570 PROGRAMMING EXPENSE SENIOR CITIZEN SERVICES 01000 09 289.22 50"TV REPLACEMENT:CMRA MONTR 188036 0915-4646-9/18 7400 6960 FURNITURE,OFFICE EQUIP,IT INFORMATION TECHNOLOGY 07400 04 289.23 50"TV REPLACEMENT FOR PD-EOC 188036 0915-4646-9/18 7400 6960 00019 FURNITURE,OFFICE EQUIP,IT INFORMATION TECHNOLOGY 07400 04 1,807.70 TOUCHLESS SOAP DISPENSERS(30) 188037 5604-7777-9/14 1015 6960 00019 FURNITURE,OFFICE EQUIP,IT CITY HALL 01000 01 175.00 MRPA CONFERENCE:HAYES,R 188038 6984-0079-9/11 1095 6470 TRAINING&SUBSISTANCE RECREATION PROGRAM SERVIC 01000 09 118.20 HOTEL:BIAS TRNG-VAN DORN 188040 4021-5134-9/21 1051 6470 TRAINING&SUBSISTANCE PATROL SERVICES 01000 05 16.60 POSTAGE FOR DEF SOLD PHONE 188041 4021-8807-9/16 1050 6445 POSTAGE/SHIPPING FEES POLICE ADMINISTRATION 01000 05 .99 SEP'20 ICLOUD STRGE SIEBENALER 188042 6913-6108-9/8 1014 6412 CELLULAR SERVICES COMMUNICATIONS 01000 01 53.44 DROP OFF DAY FACEBOOK BOOST 188043 6913-3532-9/9 6302 6492 ADVERTISING SOLID WASTE OPERATIONS 06300 08 R55CKS2 LOGIS600V CITY OF FARMINGTON 12/1/2020 17:01:41 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 28 11/10/2020- 12/1/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept D 3.44- 188043 6913-3532-9/9 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 15.95 DROP OFF DAY FACEBOOK BOOST 188044 6913-7349-9/8 6302 6492 ADVERTISING SOLID WASTE OPERATIONS 06300 08 1.03- 188044 6913-7349-9/8 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 25.51 PADFOLIO AND INSP MIRROR 188045 4021-5251-9/15 1060 6220 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 278.25 POSTAGE METER INK 188047 8032-1443-9/16 1013 6220 EQUIP SUPPLIES&PARTS ELECTIONS 01000 01 75.06 MULTIMETER TEST KIT(2) 188216 4021-5457-9/8 1060 6950 MACHINERY,EQUIPMENT&TOOLS FIRE SERVICES 01000 06 10.71 SCOTCH BRITE DISHWAND REFILLS 188217 4021-0147-9/8 1050 6242 CLEANING SUPPLIES POLICE ADMINISTRATION 01000 05 64.18 TEST LEADS AND TESTER CASES 188218 4021-5825-9/8 1060 6220 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 10.75 PAPER FOLDERS 188219 4021-7240-9/14 1031 6210 OFFICE SUPPLIES BUILDING INSPECTIONS 01000 07 25.98 IPHONE CAR CHARGERS(2) 188220 4021-9960-9/14 1051 6220 EQUIP SUPPLIES&PARTS PATROL SERVICES 01000 05 17.58 BINDER TABS 188221 4021-1031-9/14 1060 6220 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 34.62 THREE RING BINDERS 188222 4021-2297-9/14 1060 6220 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 54.32 DISH SOAP 188223 4021-5954-9/8 1050 6242 CLEANING SUPPLIES POLICE ADMINISTRATION 01000 05 138.53 TABLE FOR VESTIBULE 188224 4021-1789-9/8 1050 6960 FURNITURE,OFFICE EQUIP,IT POLICE ADMINISTRATION 01000 05 19.95 SEPT'20 EPERMITS PAYPAL FEES 188627 6913-6867-10/5 1031 6545 PYMT PROCESSING FEES BUILDING INSPECTIONS 01000 07 66.54 REINDEER:SECRET HOL SHOP 188628 3544-3031-9/25 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 113.17 FEDORA HATS:SECRET HOL SHOP 188629 3544-4161-9/25 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 114.28 POOL NOODLES:SEC HOL SHOP 188630 3544-1132-9/23 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 20.99 FOAM NOODLES:SEC HOL SHOP 188631 3544-1008-9/23 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 19.24- TAX REFUND FOR 50"TV 188632 0915-5221-9/28 7400 6960 FURNITURE,OFFICE EQUIP,IT INFORMATION TECHNOLOGY 07400 04 19.23- TAX REFUND FOR 50"TV 188632 0915-5221-9/28 7400 6960 00019 FURNITURE,OFFICE EQUIP,IT INFORMATION TECHNOLOGY 07400 04 656.00 PD EOC PC TO CONTRL 4 SCREENS 188633 0915-9451-9/25 7400 6960 00019 FURNITURE,OFFICE EQUIP,IT INFORMATION TECHNOLOGY 07400 04 452.84 MOWER ENGINE PARTS 188634 8678-6404-10/7 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 .99 OCT'20 ICLOUD STRGE SIEBENALER 188635 6913-0941-10/6 1014 6412 CELLULAR SERVICES COMMUNICATIONS 01000 01 37.49 DROP OFF DAY FACEBOOK BOOST 188636 6913-7449-9/29 6302 6492 ADVERTISING SOLID WASTE OPERATIONS 06300 08 2.41- 188636 6913-7449-9/29 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 83.77 INSTRUCTOR FACE COVERINGS 188637 6984-9716-10/5 2502 6290 UNIFORMS&CLOTHING ICE ARENA OPERATIONS EXPE 02500 09 149.00 LEADS FAIR/IMPARTIAL POLICING 188638 4021-6389-9/25 1050 6470 TRAINING&SUBSISTANCE POLICE ADMINISTRATION 01000 05 149.00 LEADS FAIR/IMPARTIAL POLICING 188638 4021-6389-9/25 1052 6470 TRAINING&SUBSISTANCE INVESTIGATION SERVICES 01000 05 1,341.00 LEADS FAIR/IMPARTIAL POLICING 188638 4021-6389-9/25 1051 6470 TRAINING&SUBSISTANCE PATROL SERVICES 01000 05 184.55 FRONT VESTIBULE TABLE 188639 4021-6453-9/28 1050 6960 FURNITURE,OFFICE EQUIP,IT POLICE ADMINISTRATION 01000 05 125.00 CRISIS INT/MENTAL ILLNESS TRNG 188640 4021-9978-10/6 1052 6470 TRAINING&SUBSISTANCE INVESTIGATION SERVICES 01000 05 125.00 CRISIS INT/MENTAL ILLNESS TRNG 188640 4021-9978-10/6 1050 6470 TRAINING&SUBSISTANCE POLICE ADMINISTRATION 01000 05 1,125.00 CRISIS INT/MENTAL ILLNESS TRNG 188640 4021-9978-10/6 1051 6470 TRAINING&SUBSISTANCE PATROL SERVICES 01000 05 1,275.00 NEUMANN FORENSIC INTERVIEW TRN 188641 4021-2671-9/24 1051 6470 TRAINING&SUBSISTANCE PATROL SERVICES 01000 05 40.00 NEUMANN NASRO DUES 188642 4021-9805-9/24 1051 6460 MEMBER DUES&LICENSURE PATROL SERVICES 01000 05 445.00 NEUMANN NASRO CONFERENCE 188643 4021-9813-9/24 1051 6470 TRAINING&SUBSISTANCE PATROL SERVICES 01000 05 250.00 AMUNDSON TEAM DYNAMICS TRNG 188644 4021-5636-9/28 1051 6470 TRAINING&SUBSISTANCE PATROL SERVICES 01000 05 9.99 CORR FLEX CONDUIT: HIDE WIRES 188645 4021-3620-10/1 1050 6220 EQUIP SUPPLIES&PARTS POLICE ADMINISTRATION 01000 05 116.10 KLEENEX 188646 4021-7884-9/28 1050 6242 CLEANING SUPPLIES POLICE ADMINISTRATION 01000 05 6.94 MECHANICAL PENCILS 188647 4021-3252-9/28 1010 6210 OFFICE SUPPLIES ADMINISTRATION 01000 01 25.49 CONFERENCE ROOM WEBCAM 188648 4021-8307-9/23 1050 6220 00019 EQUIP SUPPLIES&PARTS POLICE ADMINISTRATION 01000 05 R55CKS2 LOGIS600V CITY OF FARMINGTON 12/1/2020 17:01:41 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 29 11/10/2020- 12/1/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept D 21.49 LABELMAKER TAPE 188649 0915-4173-10/6 7400 6220 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 66.46 PD SERVER PWR CABLES 188650 0915-5802-10/6 7400 6220 00019 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 15.99 7 PIECE PLIERS TOOL SET FOR IT 188651 0915-7101-10/5 7400 6950 MACHINERY,EQUIPMENT&TOOLS INFORMATION TECHNOLOGY 07400 04 19.99 4 PIECE VISE GRIP TOOL SET:IT 188651 0915-7101-10/5 7400 6950 MACHINERY,EQUIPMENT&TOOLS INFORMATION TECHNOLOGY 07400 04 149.99 TOOL KIT FOR IT 188651 0915-7101-10/5 7400 6950 MACHINERY,EQUIPMENT&TOOLS INFORMATION TECHNOLOGY 07400 04 74.96 OCT'20 ZOOM LIC:L SIBENALER 188652 0915-7982-10/1 7400 6505 00019 EQUIPMENT REPAIR/MAINTENANCE INFORMATION TECHNOLOGY 07400 04 42.99 SSD DRIVE:PD EOC PC 188653 0915-4303-9/28 7400 6220 00019 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 119.73 PC WALL ENCLOSURE:PD EOC 188654 0915-9752-9/28 1050 6240 00019 BUILDING SUPPLIES&PARTS POLICE ADMINISTRATION 01000 05 24.99 LOGITECH KEY/MOUSE:RMT USERS 188655 0915-5669-9/28 7400 6220 00019 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 24.99 LOGITECH KEY/MOUSE:RMT USERS 188655 0915-5669-9/28 7400 6220 00019 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 179.99 SURFACE DOCK:RMTE USER 188656 0915-4366-9/25 7400 6220 00019 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 16.06 OCT'20 ZOOM ACCT 188657 5212-2806-9/25 2000 6280 20 BOOKS&SUBSCRIPTIONS-DBB HRA/ECONOMIC DEVELOPMENT 02000 03 12.98 OCT'20 WEBSITE HOSTING FEES 188658 5212-8669-9/28 2000 6505 EQUIPMENT REPAIR/MAINTENANCE HRA/ECONOMIC DEVELOPMENT 02000 03 99.00 APA MEMBERSHIP-KALLEY SWIFT 188730 8032-4131-9/30 1030 6460 MEMBER DUES&LICENSURE PLANNING&ZONING 01000 03 100.00 APA CONFERENCE-KALLEY SWIFT 188731 8032-5369-9/30 1030 6470 TRAINING&SUBSISTANCE PLANNING&ZONING 01000 03 275.00 ASCE MEMBERSHIP:GEHLER,K. 188738 6976-2055-9/24 1070 6460 MEMBER DUES&LICENSURE ENGINEERING SERVICES 01000 07 1,199.00- LOBBY WINDOW INTERCOM RETURN 188739 4021-5699-10/13 1050 6220 EQUIP SUPPLIES&PARTS POLICE ADMINISTRATION 01000 05 57.99- FRONT DESK INTERCOM REFUND 189322 4021-8780-10/22 1050 6220 00019 EQUIP SUPPLIES&PARTS POLICE ADMINISTRATION 01000 05 29.99- BOOKING CAMERA CLAMP REFUND 189323 4021-9640-10/21 1050 6220 00019 EQUIP SUPPLIES&PARTS POLICE ADMINISTRATION 01000 05 16,042.37 20201101 11/2/2020 100085 DAKOTA ELECTRIC ASSOCIATION 1,600.26 SEPT'20 ELEC PK LIQ STORE 188370 200003759891 6115 6422 ELECTRIC PILOT KNOB LIQUOR 06100 02 SEPT'20 33.69 SEPT'20 ELEC TUNNEL LIGHT 188405 200005468327 1090 6422 ELECTRIC PARK MAINTENANCE 01000 09 SEPT'20 2,103.52 SEPT'20 ELEC WELL#7 188439 200003490737 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 SEPT'20 119.41 SEPT'20 ELEC VERM GROVE LS 188440 200003215779 6202 6422 ELECTRIC SEWER OPERATIONS EXPENSE 06200 08 SEPT'20 5.15 SEPT'20 ELEC CIV DEF SIREN 188450 200001982271 1054 6422 ELECTRIC EMERGENCY MGMT SERVICES 01000 05 SEPT'20 5.15 SEPT'20 ELEC CIV DEF SIREN 188451 200002260958 1054 6422 ELECTRIC EMERGENCY MGMT SERVICES 01000 05 SEPT'20 130.28 SEPT'20 ELEC 195TH WATER TOWER 188453 200002587095 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 SEPT'20 4,224.54 SEPT'20 ELEC WELL#8 188454 200004199709 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 SEPT'20 25.70 SEPT'20 ELEC DAISY KNOLL TOWER 188455 200001318518 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 SEPT'20 6,284.85 SEPT'20 ELEC 9TH ST STREET LTS 188456 200001038421 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 SEPT'20 R55CKS2 LOGIS600V CITY OF FARMINGTON 12/1/2020 17:01:41 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 30 11/10/2020- 12/1/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 3,207.52 SEPT'20 ELEC WELL#6 188457 200001550151 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 SEPT'20 1,642.60 SEPT'20 ELEC WELL#5 188458 200002785533 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 SEPT'20 2,757.28 SEPT-20 ELEC WELL#4 188459 200001318526 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 SEPT'20 541.28 SEPT'20 ELEC FIRE STATN#2 188503 200003971959 1060 6422 ELECTRIC FIRE SERVICES 01000 06 SEPT'20 22,681.23 20201102 11/3/2020 100394 XCEL ENERGY 7.61 SEPT'20 ELEC CIV DEF SIREN 188685 51-4874006 SEPT'20 1054 6422 ELECTRIC EMERGENCY MGMT SERVICES 01000 05 6,867.18 SEPT'20 ELEC NON-METER ST LTS 188710 51-4874005 SEPT'20 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 7.96 SEPT'20 ELEC CITY GARAGE 188710 51-4874005 SEPT'20 1090 6422 ELECTRIC PARK MAINTENANCE 01000 09 .77- 188710 51-4874005 SEPT'20 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 4.77 SEPT'20 ELEC CITY GARAGE 188710 51-4874005 SEPT'20 1072 6422 ELECTRIC STREET MAINTENANCE 01000 08 3.18 SEPT'20 ELEC CITY GARAGE 188710 51-4874005 SEPT'20 6402 6422 ELECTRIC STORM WATER UTILITY OPERA 06400 08 11.91 SEPT'20 ELEC CITY GARAGE 188710 51-4874005 SEPT'20 6302 6422 ELECTRIC SOLID WASTE OPERATIONS 06300 08 117.74 SEPT'20 ELEC CITY GARAGE 188710 51-4874005 SEPT'20 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 14.32 SEPT'20 ELEC CITY GARAGE 188710 51-4874005 SEP720 6202 6422 ELECTRIC SEWER OPERATIONS EXPENSE 06200 08 185.73 SEPT'20 ELEC ROUNDABOUT 188710 51-4874005 SEPT'20 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 59.37 SEPT'20 ELEC TRAFFIC SIGNAL 188710 51-4874005 SEP-1720 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 56.64 SEPT'20 ELEC LIFT STATIONS 188710 51-4874005 SEP720 6202 6422 ELECTRIC SEWER OPERATIONS EXPENSE 06200 08 2,085.67 SEPT-20 ELEC WELL#1&3 188710 51-4874005 SEPT'20 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 43.86 SEPT'20 ELEC DOWNTOWN ST LTS 188710 51-4874005 SEPT'20 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 9,465.17 20201103 11/6/2020 115462 GROUP HEALTH INC.-WORKSITE 151.00 SEPT'20 EAP PROGRAM 188385 W817836 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 151.00 20201104 11/9/2020 100135 PUBLIC EMPLOYEES RETIREMENT ASSN. 25,716.11 188787 1105201351241 7000 2113 PERA PAYABLE EMPLOYEE EXPENSE FUND 07000 02 34,154.02 188788 1105201351242 7000 6154 PERA EMPLOYEE EXPENSE FUND 07000 02 59,870.13 20201105 11/10/2020 115445 HEALTH PARTNERS 78,913.50 189148 99803368 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 79,678.00 NOV'20 HEALTH INSURANCE 189149 100338100 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 158,591.50 20201106 11/13/2020 108980 MINNESOTA ENERGY RESOURCES CORPORATION 44.95 OCT20 GAS WELL#5 189187 0507120636 OC720 6502 6423 NATURAL GAS WATER UTILITY EXPENSE 06500 08 19.99 OCT'20 GAS VERM GROVE LIFT STN 189188 0503080372 OCT'20 6202 6423 NATURAL GAS SEWER OPERATIONS EXPENSE 06200 08 64.94 R55CKS2 LOGIS600V CITY OF FARMINGTON 12/1/2020 17:01:41 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 31 11/10/2020- 12/1/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 20201107 11/12/2020 115438 AMERITAS LIFE INSURANCE CORP 6,611.52 OCT-20 DENTAL INSURANCE 189156 010-44446 OCT'20 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 6,477.00 NOV'20 DENTAL INSURANCE 189207 010-44446 NOV'20 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 13,088.52 20201108 11/16/2020 111046 VOYAGER FLEET SYSTEMS INC 779.19 OCT'20 FUEL PARKS 189119 869088237043 PARKS1090 6272 FUEL PARK MAINTENANCE 01000 09 60.37 OCT'20 FUEL BLDG MAINT 189120 869088237043 BLDG 1090 6272 FUEL PARK MAINTENANCE 01000 09 MAINT 169.32 OCT'20 FUEL NAT RES 189153 869088237043 NAT 1076 6272 FUEL NATURAL RESOURCES 01000 07 RES 161.33 OCT'20 FUEL ENGINEERING 189154 869088237043 ENG 1070 6272 FUEL ENGINEERING SERVICES 01000 07 560.13 OCT'20 FUEL SEWER 189159 869088237043 SEWEF6202 6272 FUEL SEWER OPERATIONS EXPENSE 06200 08 110.66 OCT'20 FUEL STORM 189160 869088237043 STORW402 6272 FUEL STORM WATER UTILITY OPERA 06400 08 120.98 OCT'20 FUEL SNOW 189161 869088237043 ST/SN 1073 6272 FUEL SNOW REMOVAL SERVICES 01000 08 266.22 OCT'20 FUEL STREET 189161 869088237043 ST/SN 1072 6272 FUEL STREET MAINTENANCE 01000 08 349.57 OCT'20 FUEL WATER 189162 869088237043 WATEF6502 6272 FUEL WATER UTILITY EXPENSE 06500 08 111.37 OCT'20 FUEL SOLID WASTE 189176 869088237043 SLD 6302 6272 FUEL SOLID WASTE OPERATIONS 06300 08 WSTE 7.16- 189176 869088237043 SLD 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 WSTE 86.16 OCT'20 FUEL BLDG INSP 189179 869088237043 BLDG 1031 6272 FUEL BUILDING INSPECTIONS 01000 07 INSP 3,498.38 OCT'20 FUEL POLICE 189199 869088237043 1051 6272 FUEL PATROL SERVICES 01000 05 POLICE 47.62 OCT'20 FUEL FLEET 189216 869088237043 FLEET 7200 6272 FUEL FLEET OPERATIONS 07200 08 432.88 OCT'20 FUEL FIRE 189231 869088237043 FIRE 1060 6272 FUEL FIRE SERVICES 01000 06 6,747.02 20201109 11/17/2020 117633 NOKOMIS ENERGY LLC 4,000.29 OCT'20 ELEC CITYHALL 189155 AOR3YP-2020-10-31 1015 6422 ELECTRIC CITY HALL 01000 01 5,117.50 OCT'20 ELEC ARENA 189155 AOR3YP-2020-10-31 2502 6422 ELECTRIC ICE ARENA OPERATIONS EXPE 02500 09 9,117.79 20201110 11/18/2020 108980 MINNESOTA ENERGY RESOURCES CORPORATION 575.80 OCTOBER 2020 NATURAL GAS 189203 0505974444 OCT20 1050 6423 NATURAL GAS POLICE ADMINISTRATION 01000 05 197.09 OCT'20 GAS FIRE STATION 2 189235 0505001779 OCT'20 1060 6423 NATURAL GAS FIRE SERVICES 01000 06 772.89 20201111 11/19/2020 108980 MINNESOTA ENERGY RESOURCES CORPORATION 1,290.92 OCT'20 GAS ARENA 189126 0502346011 OCT'20 2502 6423 NATURAL GAS ICE ARENA OPERATIONS EXPE 02500 09 40.87 OCT'20 GAS 1ST STREET GARAGE 189127 0505547424 OCT'20 1072 6423 NATURAL GAS STREET MAINTENANCE 01000 08 40.87 OCT'20 GAS IST STREET GARAGE 189127 0505547424 OCT'20 1090 6423 NATURAL GAS PARK MAINTENANCE 01000 09 R55CKS2 LOGIS600V CITY OF FARMINGTON 12/1/2020 17:01:41 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 32 11/10/2020- 12/1/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 2,81- 189127 0505547424 OCT'20 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 40.87 OC720 GAS 1ST STREET GARAGE 189127 0505547424 OCT'20 6202 6423 NATURAL GAS SEWER OPERATIONS EXPENSE 06200 08 43.68 OCT'20 GAS 1ST STREET GARAGE 189127 0505547424 OCT'20 6302 6423 NATURAL GAS SOLID WASTE OPERATIONS 06300 08 40.87 OCT'20 GAS 1ST STREET GARAGE 189127 0505547424 OCT'20 6402 6423 NATURAL GAS STORM WATER UTILITY OPERA 06400 08 40.38 OCT'20 GAS 1ST STREET GARAGE 189127 0505547424 OCT'20 6502 6423 NATURAL GAS WATER UTILITY EXPENSE 06500 08 181.61 OCT'20 GAS CMF 189129 0502362190 OCT'20 6502 6423 NATURAL GAS WATER UTILITY EXPENSE 06500 08 183.80 OCT'20 GAS CMF 189129 0502362190 OCT'20 6402 6423 NATURAL GAS STORM WATER UTILITY OPERA 06400 08 12.64- 189129 0502362190 OCT'20 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 196.44 OCT'20 GAS CMF 189129 0502362190 OC-1720 6302 6423 NATURAL GAS SOLID WASTE OPERATIONS 06300 08 183.80 OCT'20 GAS CMF 189129 0502362190 OCT'20 6202 6423 NATURAL GAS SEWER OPERATIONS EXPENSE 06200 08 183.80 OC720 GAS CMF 189129 0502362190 OCT'20 1090 6423 NATURAL GAS PARK MAINTENANCE 01000 09 183.80 OCT'20 GAS CMF 189129 0502362190 OCT'20 1072 6423 NATURAL GAS STREET MAINTENANCE 01000 08 356.26 OCT'20 GAS RRC 189133 0507948331 OCT'20 1093 6423 NATURAL GAS SENIOR CITIZEN SERVICES 01000 09 29.87 OCT'20 GAS WELL HOUSE 1 OAK ST 189189 0506788875 OCT'20 6502 6423 NATURAL GAS WATER UTILITY EXPENSE 06500 08 225.32 OCT'20 GAS FIRE STATION 1 189234 0506565319 OC720 1060 6423 NATURAL GAS FIRE SERVICES 01000 06 3,247.71 20201112 11/20/2020 108980 MINNESOTA ENERGY RESOURCES CORPORATION 158.56 OCT'20 GAS DT LIQ STORE 189057 0503154879 OCT'20 6110 6423 NATURAL GAS DOWNTOWN LIQUOR REV&EXP 06100 02 1,199.37 OCT'20 GAS CITY HALL 189128 0505346885 OCT'20 1015 6423 NATURAL GAS CITY HALL 01000 01 1,357.93 20201113 11/19/2020 100394 XCEL ENERGY 1,298.61 OCT'20 ELEC-DT LIQ STORE 189055 51-4874008 OCT'20 6110 6422 ELECTRIC DOWNTOWN LIQUOR REV&EXP 06100 02 20.35 OCT'20 ELEC-ELM ST EDA SIGN 189150 51-4874009 OCT'20 2000 6422 ELECTRIC HRA/ECONOMIC DEVELOPMENT 02000 03 193.46 OCT'20 ELEC-321 ELM ST LTS 189184 51-8608862 OCT'20 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 15.07 OCT'20 ELEC-LINDEN ST LFT STN 189185 51-6585658 OCT'20 6202 6422 ELECTRIC SEWER OPERATIONS EXPENSE 06200 08 32.08 OCT'20 ELEC-5262 208TH ST LTS 189186 51-8391412 OCT'20 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 1,559.57 20201114 11/20/2020 100394 XCEL ENERGY 24.08 OCT'20 ELEC-DUNBRY AVE WRM HSE 189124 51-9027188 OCT'20 1090 6422 ELECTRIC PARK MAINTENANCE 01000 09 178.35 OCT'20 ELEC-190TH ST BRDG LTS 189183 51-9371130 OCT'20 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 202.43 20201115 11/23/2020 100085 DAKOTA ELECTRIC ASSOCIATION 28.94 OCT'20 PARK REC SIGN ELECTRIC 189060 200002260479 1090 6422 ELECTRIC PARK MAINTENANCE 01000 09 OCT'20 17.96 OCT'20 PK CITY SIGN NORTH ENTR 189123 200010011266 1090 6422 ELECTRIC PARK MAINTENANCE 01000 09 OCT'20 19.21 OCT'20 ELEC SPRUCE ST MNMNT LT 189172 200004099123 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 OCT'20 253.65 OCT'20 ELEC DNMRK/SPRCE ST LTS 189173 200004222477 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 OCT'20 R55CKS2 LOGIS600V CITY OF FARMINGTON 12/1/2020 17:01:41 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 33 11/10/2020- 12/1/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 53.47 OCT'20 ELEC WELL#9 189174 200010028004 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 OCT'20 18.78 OCT'20 ELEC 220TH ST LIFT STN 189175 200001405224 6202 6422 ELECTRIC SEWER OPERATIONS EXPENSE 06200 08 OCT'20 425.31 OCT'20 ELEC FIRE STATION 1 189233 200001679489 1060 6422 ELECTRIC FIRE SERVICES 01000 06 OCT'20 817.32 20201116 11/23/2020 108980 MINNESOTA ENERGY RESOURCES CORPORATION 121.26 OCT 20 GAS PK LIQ STORE 189056 0507026961 OCT'20 6115 6423 NATURAL GAS PILOT KNOB LIQUOR 06100 02 121.26 20201117 11/25/2020 100135 PUBLIC EMPLOYEES RETIREMENT ASSN. 25,218.18 189326 1119201128491 7000 2113 PERA PAYABLE EMPLOYEE EXPENSE FUND 07000 02 33,509.87 189327 1119201128492 7000 6154 PERA EMPLOYEE EXPENSE FUND 07000 02 58,728.05 Report Totals 1,707,543.33y c / rJ� r7J e s CITY OF © 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 OFarmington M N.gov TO: Mayor, Councilmembers and City Administrator FROM: Cynthia Muller, Administrative Assistant SUBJECT: 2021 License Renewals DATE: December 7, 2020 INTRODUCTION Per city code, a public hearing must be held to issue or renew On-Sale Liquor Licenses, On-Sale Sunday Liquor Licenses, Club Licenses and Therapeutic Massage Licenses. DISCUSSION The required applications, fees and insurance information have been submitted for renewal and have been reviewed and approved by the Police Department for the following establishments: On-Sale Liquor and On-Sale Sunday: Bourbon Butcher, 20700 Chippendale Avenue W, Suite 15 Celt's Pub & Grill, 200 3rd Street EI Charro Mexican Restaurant, 120 Elm Street Farmington Lanes, 27 5th Street Las Enchiladas, 18500 Pilot Knob Road, Suite A Long Branch Saloon and Eatery; Farmington Tap House, 309 3rd Street Pizza Man,409 3rd Street Rebel Chef, 953 8th Street The Mug, 18450 Pilot Knob Road This Little Piggy Catering Inc, 22280 Chippendale Avenue W Club License and On-Sale Sunda VFW Club Post#7662, 421 3rd Street Therapeutic Massage: Stephanie Delzer, Main Street Day Spa, 328 Third Street BUDGET IMPACT The fees collected are included in the revenue estimates of the 2021 budget. ACTION REQUESTED Conduct the public hearing and receive any comments that are made. Once the city council is comfortable, a motion should be made to approve the On-Sale Liquor, On-Sale Sunday Liquor, Club, and Therapeutic Massage Licenses as listed. CITY OF 0 43o Third St., Farmington, MN 55024 FARMINGTON 651-28o-6800 OFarmington M N,gov TO: Mayor, Councilmembers and City Administrator FROM: Tony Wippler, Planning Manager SUBJECT: Vacating Certain Sanitary and Storm Sewer Easements DATE: December 7, 2020 INTRODUCTION The City is proposing to vacate three easements that exist on the property located at 4685 212th Street West and owned by Northern Natural Gas Company. The easements are for two existing sanitary sewer lines and one storm sewer line that service the Northern Natural Gas Company site. DISCUSSION In 1992 the City completed a utility improvement project on the above referenced property owned by Northern Natural Gas(formerly EN RON Gas Company). The improvements for this project consisted of the installation of two sanitary sewer lateral lines that connected to the existing trunk sewer within CSAH 50 as well as a storm drainage system consisting of a storm sewer pipe,ditches and some area regrading. I have attached the site plan (Exhibit C)from 1992 that shows the utility lines that were installed (highlighted in yellow). An easement document was executed on October 20, 1992 providing easements over these utility lines to the City. Attached,as Exhibits A and B,are the survey depicting the easements and the legal descriptions describing the easements covering these three utility lines, respectively. Northern Natural Gas is currently in process of completing site upgrades at this location including,among other things,the construction of anew auxiliary building. Anew sewer connection has been made to the western most sanitary sewer service to provide sanitary sewer for this building. Due to these site upgrades the City re- evaluated the need for the City to retain these sewer easements and determined that these are private lines that only benefit the Northern Natural Gas property and that it would be in the City's interest to vacate these easements. The City has been working with Northern Natural Gas Company on their site upgrades and they are in concurrence with the City to take over responsibility for the utility lines. BUDGET IMPACT NA ACTION REQUESTED Adopt the attached resolution vacating the sewer easements depicted and described in the Exhibits A and B, respectively. ATTACHMENTS: Type Description D Resolution Vacation Resolution D Backup Material Exhibit A-survey D Backup Material Exhibit B- legal descriptions D Backup Material Exhibit C- 1992 site plan RESOLUTION NO. R55-20 A RESOLUTION VACATING CERTAIN SANITARY AND STORM SEWER EASEMENTS 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 7'day of December,2020 at 7:00 P.M. Members Present: Larson, Bernhj elm, Craig, Hoyt Members Absent: Donnelly Member Bernhj elm introduced and Member Craig seconded the following: WHEREAS, two existing sanitary sewer easements and one storm sewer easement are located on the property owned by Northern Natural Gas Co. and addressed as 4685 212''Street W. WHEREAS,the two sanitary sewer lines and one storm sewer line covered by these easements are not of public benefit and therefore the City of Farmington is requesting to vacate two existing sanitary sewer easements and one existing storm sewer easement, which are all depicted in Exhibit "A" and legally described in Exhibit`B"; and WHEREAS, it appears that it is in the public interest to vacate the two sanitary sewer easements and one storm sewer easement depicted in Exhibit "A" and legally described in Exhibit `B"; and recorded at Dakota County in Document No. 1091818; and WHEREAS, pursuant to Minn. Stat. §412.851, the Farmington City Council has conducted a hearing proceeded by published and posted notice to consider the easements vacations requested by the City of Farmington. NOW,THEREFORE,BE IT RESOLVED by the City Council of Farmington: 1. The two sanitary sewer easements and one storm sewer easement depicted in Exhibit "A" and legally described in Exhibit`B"are hereby vacated. 2. The City Clerk is directed to file a certified copy of this resolution with the County Auditor and County Recorder in and for Dakota County,Minnesota. This resolution adopted by recorded vote of the Farmington City Council in open session on the 7"'day of December,2020. Mayor Attest to the 2 day of December,2020. ` (�iity Administrat r SEAL �V 'A m - m S M w w s m - m W O � 81•a6'U'E 7078.72 40 Q_ ` 6S'85'S6'E S1tlB.BB �•SO�."li . • : � ~� 67av7 Bare,eamre7r . ,S� '' 87'08•l9'£'718.7a 83•Bo'76�y'' .98 +�— saBrrun ae'emsear a, a.NLs- cu °moi gg� will W 13 DELMAR H. SCHWANZ Intro suavEyons,INC, .h I .• Rspbtund U Ar LAwq of tha sib of Mhmaois ' 1476 SOUTH ilO9ERT TPAIL ROSEMOUNT,MINNESOTA 5.088 812/423-17es SURVEYOR'S CERTIFICATE DESCRIPTIONS Sanitary Sewer Easement "A" A 40.00 foot easement for sanitary sewer purposes over, under and across a strip of land located in the North Half of the Northeast Quarter of Section 36, Township 114, Range 20, Dakota County, Minnesota, the centerline of which is described as follows; Commencing at the northeast-corner of said North Half of the Northeast Quarter; thence on an assumed bearing of South 88 degrees 51 minutes 11 seconds West along the north line bf said North Half of the Northeast Quarter 1272.90 feet; 'thence South 1 degree 08 minutes 49 seconds East 1012.12 feet to the beginning of the centerline to be des- 4(} cribed; thence South 34 degrees 02 minutes 38 seconds East along said cen- ;z terline 289.11 feet, said centerline there terminating. 'tea Storm Sewer Easement "Y" A 20.00 foot easement for storm sewer purpose's over, under and across a strip of land located in the North Half of the Northeast Quzirter of Section 36, Township 114, Range 20-, Dakota County, Minnesota. the centerline of which is described as foltows,' Commencing at the northeast corner of said North Half of the Northeast Quarter'; thence ort an'assumed bearing of South , 88 degrees 51 minutes 11 seconds West along the north line of said North Half of the 'Northeast Quarter 1533.67 feet to the beginning of the centerline to be described; thence South 1 degree 05 minutes 56 seconds East along said centerline 1106.58 feet, said centerline -there terminating. Sanitary Sewer Easement "C" A 40.00 foot easement for sanitary sewsk purposes over, under and across a strip of land located in the North Half of the Northeast Quarter of Section 36, Township114, Range 20, Dakota County, -Minnesota, the centerline of which is described as follows: Commencing at the northeast corner of said North Half of the Northeast Quarter; thence onjan assumed bearing o€ South 88 degrees 51 minutes 11 seconds West along the north line of said North Half of the Northeast ouarter 1801.13 feet; thence South'1 deikee 08 minutes 49 seconds East 716.16 feet'to the beginning of the centerline to be des- cribed; thence South 3- degrees 50 minutes'16 seconds West along said cen- terline 543.98 feet, said centerline there terminating. I hereby csrtlfy that this survey,plan,or report was prepared by me or under lny dlrectsupervtslonand i} that I am a duly Registered Land Survdyor under the laws of the State of Mlnomofa-, �Z(E; October 7, 1992 Dolmar Ft,Sahwint +' Dated Minn*oota flooMratfen No.a= r✓' • ex , 8 µ Uys 03. 01. 91 AP:I e, F1f r fli BEE SHEET 6 �.� ��� .........wu..« NOTE �\, � I °I •••••�.w.�`i I _ j� ..w t.»...0\\ �� I\ -- w<or+f,eruxwcwaunr..e"� . ,,\ lll... / ,•.�«. f , �� � I '""'aas.c'1°iu°Pfnao wi v.... 0 00 'Fon! . r 10)(InerCONC SLAB FOR MH 8 OIL BEP CASTING PROTECTION IN GRAVEL AREAS ----- — — -_— �xaxew.»-n re u• �'j; 1 •--_-- --9 _— wwaw w».rx y� lxi l°drWta Omriea°rneaq,rW �.n d•. x °S � _ a,eua.xMaunwum plica v�iw° — - rlXti.ev4amarar irnoa-wux° —- I MwSv avmy w ti." CITY OF FARMINGTON I LEGENDNOTE MdrwlRWraliNLlALbIlDW ..awtler my°4ex auxltl.n Ex, l '""""»"•'r w��s"�m.mr"`..wia:.c,,. c.. ..�x .,,,,e„h a,.ywm FARMINGTON,MINNESOTA ee.�R�ws awurrxmwnr,ewmwr.w .wax sWxw�,w wrox aex.sswulwRoveNwrs ® w.,axw+n u u m.Suu.r un SITE PLAN .amu•.x�u CwN nvTi 1 x rua:M1f°' SHEET 2 OF 5 9S. CITY 4F O Q 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 OFarmington M N.gov TO: Mayor, Councilmembers and City Administrator FROM: Randy Distad, Parks and Recreation Director SUBJECT: Schmitz-Maki Arena Pressure Relief Valve Replacement and Top End Overhaul of Compressor#2 Project DATE: December 7, 2020 INTRODUCTION There is currently a remaining balance from the original $200,000 Farmington Liquors profits that was transferred to Schmitz-Maki Arena Capital Improvement Projects Fund. A request is being made to spend some of the remaining funds to replace 13 pressure relief valves in the arena's refrigeration system and to complete a top end overhaul of compressor#2. DISCUSSION Previously staff had discussed with the City Council at its July 13, 2020 work session a number of identified capital improvement projects. Two items recommended to be completed by staff was to replace the pressure relief valves in the arena's refrigeration system and to complete a top end overhaul of compressor#2. Pressure relief valves are a type of safety valve used to control or limit the pressure in a refrigeration system. Pressure relief valves are spring-loaded valves normally encased in a brass body with a neoprene seal. They are designed to automatically reset once the pressure inside the vessel reaches a safe level. They are located in different sections of the refrigeration system and where ever refrigerant vapor is located.This allows only the vapor to be released from the vessel rather than any liquid refrigerant. If the pressure relief valves are not functioning correctly, pressure might build up and could cause instrument and/or equipment to fail, or worse could cause a fire. The arena's current pressure relief valves have not been replaced since 2011. It is recommended that pressure relief valves be replaced every 5 years. As you can see,the pressure relief valves should have been replaced in 2016 and so it is four years past the recommended replacement schedule. Staff has updated the arena's five year capital improvement plan to show this work being completed every five years,which would mean this work would be completed again in 2025. Compressor#2 serves as a backup compressor should compressor#1 fail or not be able to handle the workload to maintain ice conditions. A top end overhaul consists of providing and replacing/changing the following: • Suction valves • Discharge valves • Suction valve springs • Discharge valve springs • Oil filter • Compressor oil • Gaskets I n addition, other work completed during the top end overhaul includes: • Pull piston and check rod, rod bearing insert, piston rings and wrist pin • Pressure test and leak test • Start-up testing which includes checking safety and operating controls An overhaul will extend the life of a compressor. It is recommended to have atop end overhaul of a compressor every five years. It has been five years since compressor#2 last received atop end overhaul, so this work should be completed. Staff solicited quotes from two companies that are experienced with the Project. The results of the quotes received are as follows: Name of Contractor Amount Cool Air Mechanical, Inc. $8,522.00 Gartner Refrigeration, Inc. $10,218.00 As you can see Cool Air Mechanical, I nc. submitted the low quote. The quote includes all parts and labor associated with the project. Staff is recommending the city enter into a contract with Cool Air Mechanical, I nc.to complete the project work. It is anticipated this work will be completed by the end of January 2021. BUDGET IMPACT Staff previously estimated the cost of the Project at$10,500.00.The actual cost of the Project based on the low quote submitted by Cool Air Mechanical, I nc. is $8,522.00. This is $1,978.00 under what staff had estimated it would cost. As stated previously,funding to complete the project is recommended to come from the remaining balance of the$200,000.00 in Farmington Liquor Store profits that were transferred to the Arena Capital Improvement Fund. There is currently a balance of$34,971.00 remaining from the original amount. After subtracting the costs associated with the project,the balance remaining will be$26,449.00 to spend on other arena projects. ACTION REQUESTED Staff is recommending the city council approve an agreement with Cool Air Mechanical, I nc. in the amount of$8,522.00 to complete the Project and authorize Mayor Todd Larson and City Administrator David McKnight to sign the agreement. AGREEMENT AGREEMENT made this 7"'day of December, 2020,between the CITY OF FARMINGTON, a Minnesota municipal corporation ("City"), and COOL AIR MECHANICAL, INC. a Minnesota corporation("Contractor"). IN CONSIDERATION OF THE MUTUAL UNDERTAKINGS HEREIN CONTAINED,THE PARTIES AGREE AS FOLLOWS: 1. CONTRACT DOCUMENTS. The following documents shall be referred to as the "Contract Documents", all of which shall be taken together as a whole as the contract between the parties as if they were set verbatim and in full herein: A. This Agreement B. Contractor's relief valve replacement proposal dated November 12, 2020 and Contractor's compressor top end overhaul proposal dated October 23, 2020 and both attached as Exhibit"A." In the event of conflict among the provisions of the Contract Documents,the order in which they are listed above shall control in resolving any such conflicts with Contract Document "A" having the first priority and Contract Document"B" and"C"having the last priority. 2. OBLIGATIONS OF THE CONTRACTOR. The Contractor shall provide the goods, services,and perform the work in accordance with the Contract Documents. 3. OBLIGATIONS OF THE CITY. The City shall pay the Contractor in accordance with the bid. 4. SOFTWARE LICENSE. If the equipment provided by the Contractor pursuant to this Contract contains software, including that which the manufacturer may have embedded into the hardware as an integral part of the equipment,the Contractor shall pay all software licensing fees. The Contractor shall also pay for all software updating fees for a period of one year following cutover. The Contractor shall have no obligation to pay for such fees thereafter.Nothing in the software license or licensing agreement shall obligate the City to pay any additional fees as a condition for continuing to use the software. 5. ASSIGNMENT. Neither party may assign, sublet,or transfer any interest or obligation in this Contract without the prior written consent of the other party, and then only upon such terms and conditions as both parties may agree to and set forth in writing. 6. TIME OF PERFORMANCE. The Contractor shall complete its obligations on or before January 31,2021. 6. TIME OF PERFORMANCE. The Contractor shall complete its obligations on or before January 31,2021 7. PAYMENT. The total project cost to complete a compressor top end overhaul and complete relief valve replacements is proposed at $9,352.00. When the obligations of the Contractor have been fulfilled, inspected, and accepted, the City shall pay the Contractor the amount of$9,352.00. Such payment shall be made not later than thirty(30) days after completion,certification thereof, and invoicing by the Contractor. No final payment shall be made under this Contract until Contractor has satisfactorily established compliance with the provisions of Minn. Stat. Section 290.92. A certificate of the commissioner shall satisfy this requirement with respect to the Contractor or any subcontractor. 8. EXTRA SERVICES. No claim will be honored for compensation for extra services or beyond the scope of this Agreement or the not-to-exceed price for the services identified in the proposal without written submittal by the Contractor,and approval of an amendment by the City, with specific estimates of type, time, and maximum costs, prior to commencement of the work. 9. PROMPT PAYMENT TO SUBCONTRACTORS. Pursuant to Minnesota Statute 471.25, Subdivision 4a,the Contractor must pay any subcontractor within ten(10) days of the Contractor's receipt of payment from the City for undisputed services provided by the subcontractor. The Contractor must pay interest of one and one-half percent (1'/2 %)per month or any part of a month to subcontractor on any undisputed amount not paid on time to the subcontractor. The minimum monthly interest penalty payment for an unpaid balance of$100.00 or more is $10.00. For an unpaid balance of less than $100.00, the Contractor shall pay the actual penalty due to the subcontractor. A subcontractor who prevails in a civil action to collect interest penalties from the Contractor shall be awarded its costs and disbursements, including attorney's fees,incurred in bringing the action. 10. WORKER'S COMPENSATION. If Contractor does public work, the Contractor shall obtain and maintain for the duration of this Contract, statutory Worker's Compensation Insurance and Employer's Liability Insurance as required under the laws of the State of Minnesota. 11. COMPREHENSIVE GENERAL LIABILITY. Contractor shall obtain the following minimum insurance coverage and maintain it at all times throughout the life of the Contract, with the City included as an additional name insured by endorsement: 2 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 Products and Completed Operations Insurance shall be maintained for a minimum period of three(3)years after final payment and Contractor shall continue to provide evidence of such coverage to the City on an annual basis during the aforementioned period; or if any reason Contractor's work ceases before final payment, for a minimum period of three (3) years from the date Contractor ceases work. Property Damage Liability Insurance shall include coverage for the following hazards: X (Explosion) C (Collapse) U (Underground) Contractual Liability(identifying the contract): Bodily Injury: $2,000,000 each occurrence Property Damage: $2,000,000 each occurrence $2,000,000 aggregate Personal Injury,with Employment Exclusion deleted: $2,000,000 aggregate Comprehensive Automobile Liability(owned,non-owned,hired): Bodily Injury: $2,000,000 each occurrence $2,000,000 each accident Property Damage: $2,000,000 each occurrence 12. MINNESOTA GOVERNMENT DATA PRACTICES ACT. Contractor must comply with the Minnesota Government Data Practices Act, Minnesota Statutes Chapter 13, as it applies to (1) all data provided by the City pursuant to this Agreement, and (2) all data, created, collected, received, stored, used, maintained, or disseminated by Contractor pursuant to this Agreement. Contractor is subject to all the provisions of the Minnesota Government Data Practices Act, including but not limited to the civil remedies of Minnesota Statutes Section 13.08,as if it were a government entity. In the event Contractor 3 receives a request to release data, Contractor must immediately notify City. City will give Contractor instructions concerning the release of the data to the requesting party before the data is released. Contractor agrees to defend, indenurify, and hold City, its officials, officers, agents, employees, and volunteers harmless from any claims resulting from Contractor's officers', agents', city's, partners', employees', volunteers', assignees' or subcontractors' unlawful disclosure and/or use of protected data. The terms of this paragraph shall survive the cancellation or termination of this Agreement. 13. RECORDS. Contractor shall maintain complete and accurate records of expenses involved in the performance of services. 14. WARRANTY. The Contractor guarantees that all new equipment warranties as specified within the bid shall be in full force and transferred to the City upon payment by the City. The Contractor shall be held responsible for any and all defects in workmanship,materials, and equipment which may develop in any part of the contracted service, and upon proper notification by the City shall immediately replace, without cost to the City,any such faulty part or parts and damage done by reason of the same in accordance with the bid specifications. The Contractor further warrants to the City that all goods and services furnished under the Contract will be in conformance with Contract Documents and that the goods are of merchantable quality and are fit for the use for which they are sold. This warranty is in addition to any manufacturer's standard warranty y, and any warranty provided by law. 15. NONDISCRIMINATION. All Contractors and subcontractors employed shall comply with all applicable provisions of all federal, state and municipal laws which prohibit discrimination in employment to members of a protected class and all rules and regulations, promulgated and adopted pursuant thereto. The Contractor will include a similar provision in all subcontracts entered into for the performance of this contract. 16. INDEMNITY. The Contractor agrees to defend, hold harmless, and indemnify the City, its officers, agents, and employees, for and against any and all claims, demands, actions, or causes of action, of whatever nature or character, arising from the Consultant's performance of work or services provided for herein. The Contractor shall take all reasonable precautions for the safety of all employees on the site and shall provide reasonable protection to prevent damage or loss to the property on the site or properties adjacent thereto and to work,materials and equipment under the Contractor's control. 17. WAIVER. In the particular event that either party shall at any time or times waive any breach of this Contract by the other, such waiver shall not constitute a waiver of any other or any succeeding breach of this Contract by either party,whether of the same or any other covenant, condition, or obligation. 18. GOVERNING LAW. The laws of the State of Minnesota govern the interpretation of this Contract. 4 19. SEVERABILITY. If any provision,term, or condition of this Contract is found to be or become unenforceable or invalid, it shall not affect the remaining provisions, terms, and conditions of this Contract, unless such invalid or unenforceable provision, term, or condition rendp s this Contract impossible to perform. Such remaining terms and conditions of the Contract shall continue in fiill force and effect and shall continue to operate as the parties'entire contract. X ENTIRE AGREEMENT, This Contract represents the entire agreement of the parties and is a final, complete, and all-inclusive statement of the terms thereof, and supersedes and terminates any,prior agreement(s),understandings,or written or verbal representations made between the parties with respect thereto. 21. TERMINATION. This Agreement may be terminated by the City for any reason or for convenience upon written notice to the Contractor. In the event of termination, the City shall be obligated to the Contractor for payment of amounts due and owing for materials provided or for services performed or furnished to the date and time of termination. F � -7 2020 CITY OF FARMINGTON Dated•,r�C�'er� By: Todd Larson,Mayor op avid Mc i t, ty Administrator Dated, cem4e.- to ,2020 CONTRACTOR. COOL AIR MECHANICAL,INC. By Ifs: 1 x�rS�'•a� Ret�jS�cNaLl,�,, _—tel is 5 FAA-4 A 1544-134"'Ave.NE,Harn Lake,MN 55304 24 Hour Number763-205-0821 Fax 762-432-7394 a wcoolairmechanical.coni ..... �-- 00R Age . �4 MECHANICAL,INC. 111 u October 23, 2020 Quote# 10.20.2774-BCS Schmitz-Maki Arena 114 Spruce St. Farmington, MN 55024 Attn: Jeremy Pire RE: Vilter 454XL Compressor Top End Overhaul Dear Jeremy, Cool Air Mechanical is pleased to submit this proposal to complete the top end overhaul on your Vilter 454XL compressor. We will complete the overhaul and inspect the pistons, mic the cylinder liners, mic the bearing on the crank for 1 piston and inspect the housing. If any problems are found, we will bring it to your attention and quote the parts before proceeding. Please review the items listed below that are included in our proposal. Items included in our proposal: • Pump down the compressor and isolate • Provide and replace the following o Suction valves o Discharge valves o Suction valve springs o Discharge valve springs o Oil filter o Compressor oil o Gasket kit • Pull 1 piston; check rod, rod bearing insert, piston rings &wrist pin • Change compressor oil • Reassemble compressor with new gaskets • Pressure test &leak test • Start up, test and check safety& operating controls • Technical service to complete the overhaul • Shop materials and supplies • Freight • MN sales tax Schmitz-Maki Arena Net Price for Vilter 454XL Compressor Top End Overhaul.....................$3,354.00 Items Not Included in the above proposal: • Other repairs or parts not listed above • Extra time if isolation valves do not hold • Overtime • Disposal of removed compressor oil • PSM & RMP services If during the top end overhaul of the compressor it is found that other items need to be replaced, Cool Air Mechanical will quote the additional parts with replacement prior to proceeding. We appreciate the opportunity to present this proposal. If you have any questions or concerns please call. Sincerely, Cool Air Mechanical, Inc. lj - _. Bret Swanson 763-205-0862 Terms and Conditions: 1. All Material is guaranteed to be as specified.All work will be completed in a workmanlike manner according to standard industry practices. Any deviation or alteration from the above listed specifications may involve extra charges over& above the quoted figure. 2. Cool Air Mechanical, Inc. will not be liable for agreements contingent upon strikes, accidents or delays beyond our control. 3. The building owner and or customer will carry fire, property and other necessary insurances. Cool Air Mechanical will not assume any insurance obligations beyond that included in their current insurance coverage. 4. Cool Air Mechanical, Inc. will not be responsible for any work or cost of asbestos abatement. 5. The building owner will provide a safe work area with free access to carry out our work. 6. All work to be performed during the normal work day (7am-3:30pm, Mon-Fri) on straight time unless otherwise noted. 7. Warranty includes one (1) year on equipment and installation labor, 90 days on parts and service labor. 8. On all accounts over 30 days, the customer agrees to pay all reasonable collection and/or attorney fees. 9. The above quoted figure is good for 90 days. Customer is responsible for any increase in price for equipment or materials after the 90 days. 10.Mutually agreeable construction/work schedule 11.Payment Terms—50% Down, and remainder when complete, net 30 This proposal is hereby accepted by: on purchase order# dated 611�161_� A "I HE Ilam Ittko,h!N 55301 2.1 Hour Niffa6er7C_T'205-01.12I Fttx 762-13?-73E�d�yw�Yete lunnectu7niculceiri MECH NICALy INC. � V�i it November 12, 2020 Quote# 10.20.2772-BCS-1 Schmitz-Maki Arena 114 Spruce St. Farmington, MN 55024 Attn: Jeremy Pire RE: Relief Valve Replacement Dear Jeremy, Cool Air Mechanical is pleased to submit this proposal to replace the relief valves on your ammonia refrigeration system. We will supply and replace all of the relief valves, complete pump downs as required and dispose of the removed relief valves. Please see the items listed below at are included in our proposal. • Supply thirteen (13) new relief valves • Mobilize on site • Change out the relief valves on the following equipment: o Compressors—4 relief valves o Oil separators—2 relief valves o Chiller—2 relief valves o HPR—2 relief valves o Condenser—2 relief valves o Oil Pot— 1 relief valve • Remove existing relief valves • Install the new relief valves • Pump down of the compressors, oil separators and oil pot for replacement • Technical service to complete the relief replacements • Freight for the new relief valves • Disposal of the removed relief valves Schmitz-Maki Arena Net Price to Replace the Ammonia Relief Valves...................................$5,998.00 Items not included on the above pricings: • Other labor, repairs or parts not listed above • Extra time if isolation valves do not hold • Overtime installation • Pipe painting • Additional ammonia • PSM & RMP services We appreciate the opportunity to present this proposal. If you have any questions or concerns please call. Sincerely, Cool Air Mechanical, Inc. lw�-"' '"— Bret Swanson 763-205-0862 Terms and Conditions: 1. All Material is guaranteed to be as specified.All work will be completed in a workmanlike manner according to standard industry practices. Any deviation or alteration from the above listed specifications may involve extra charges over&above the quoted figure. 2. Cool Air Mechanical, Inc.will not be liable for agreements contingent upon strikes, accidents or delays beyond our control. 3. The building owner and or customer will carry fire, property and other necessary insurances. Cool Air Mechanical will not assume any insurance obligations beyond that included in their current insurance coverage. 4. Cool Air Mechanical, Inc.will not be responsible for any work or cost of asbestos abatement. 5. The building owner will provide a safe work area with free access to carry out our work. 6. All work to be performed during the normal work day(7am-3:30pm, Mon-Fri) on straight time unless otherwise noted. 7. Warranty includes one (1) year on equipment and installation labor, 90 days on parts and service labor. 8. On all accounts over 30 days, the customer agrees to pay all reasonable collection and/or attorney fees. 9. The above quoted figure is good for 90 days. Customer is responsible for any increase in price for equipment or materials after the 90 days. 10.Mutually agreeable construction/work schedule 11.Payment Terms—50% Down, remainder billed upon completion, net 30 CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON 0 651-28o-6800 UI O Farmington MN.gov TO: Mayor, Councilmembers and City Administrator FROM: Teah Malecha, Finance Director SUBJECT: 2021 Final Budget and Tax Levy DATE: December 7, 2020 INTRODUCTION The city council and staff have been discussing, developing, and revising the draft 2021 budgets since May of this year. The city council approved the preliminary tax levy on September 21, 2020. State statute requires that the final property tax levy for the upcoming year be certified to Dakota County on or before December 30th. DISCUSSION The city council discussed the draft 2021 General Fund budget and tax levy at work sessions in May,July, August, September, and November.The proposed final budget and tax levy are shown below. 2021 Increase 2020 Budget Proposed (Decrease) Budget Revenues $3,411,161 $3,298,344 (3.31)% Expenditures 13,642,352 13,832,464 1.39 Revenues Under Expenditures 10,231,191 10,534,120 2.96 Debt Levy 2,805,387 3,012,093 7.37 Gross Levy 13,036,578 13,546,213 3.91 Fiscal Disparities (2,294,024) (2,277,659) (0.71) Net Tax Levy $10,742,554 $11,268,554 4.90% The city council approved the preliminary 2020 tax levy on September 21, 2020 and set the amount at $11,268,554. General Fund Revenues COVI D-19 has created challenging times for many businesses but also for the city. Some areas that have seen a decrease due to COVI D-19 are parks and recreation,the Rambling River Center, and liquor licensing as part of the General Fund. The reduction is predicted to continue into 2021 resulting in lower revenue receipts than the typical annual increase shown in the budget. The revenues for 2020 are projected to decrease 3.31 percent. The majority of those decreases are accounted for in intergovernmental revenue and investment income. The city will see a reduction of $228,800 in Local Government Aid (LGA) along with a decrease in MSA maintenance. Permit revenue is anticipated to rise in 2021. 2021 Increase 2020 Budget Proposed (Decrease) Budget Licenses and Permits $473,115 $517,076 9.29% I ntergovern mental Revenue 922,294 667,912 (27.58) Charge for Service 565,802 576,197 1.84 Fines and Forfeitures 49,000 49,000 0.00 I nvestment I ncome 38,800 29,100 (25.00) Miscellaneous 54,580 79,370 45.42 Transfers 11307,570 1,379,689 5.52 Total Revenues $3,411,161 $3,298,344 (3.31)% General Fund Expenditures The proposed 2020 department budgets are summarized below. 2021 Increase 2020 Budget Proposed (Decrease) Budget Administration $907,162 $902,915 (0.47)% Human Resource 349,226 361,658 3.56 Dakota Broadband 24,489 37,500 53.13 Finance 778,889 776,287 (0.33) Police 4,677,813 4,845,796 3.59 Fire 1,445,410 1,435,685 (0.67) Community Development 1,014,867 1,007,849 (0.69) Engineering 794,635 813,895 2.42 Municipal Services 1,439,078 1,511,187 5.01 Parks and Recreation 1,278,576 1,317,341 3.03 Transfers 932,207 822,351 (11.78) Total Expenditures $13,642,352 $13,832,464 1.39% All of the budgets include estimated human resource costs based on approved union contracts and estimates for employee benefits and worker's compensation premiums.The union contracts were approved for 2019 through 2021 and include a three percent wage increase each year. Human Resources completed a RFP process for staff health insurance and was successful resulting in over$100,000 in savings that impacts the General Fund. Transfers There are transfers in and out shown in the General Fund budget.The transfers into the General Fund are from the enterprise funds to reimburse the General Fund for human resource and administrative costs which benefit the enterprise funds.The transfers out are comprised of the LGA and tax levy.Those fund public safety equipment,trail maintenance, EDA, and building maintenance among many other items. A detailed break-down of the transfers has been included as a separate exhibit in your packet. Fiscal Disparities This is a metro wide program that is used to balance the development of commercial and industrial growth through the region. The city has received a preliminary estimate of the final number which includes a decrease of$16,365. Debt Levy The debt levy represents the amount of tax levy needed to meet the city's 2021 debt repayment obligations. The 2021 debt levy is 7.37 percent higher than the 2020 debt levy. The increase is due to the purchase of Ladder One which will be delivered in early 2021.The city continues repayment on six bonds and three interfund loans. While the city will be issuing additional debt in future years,the efforts will continue to pay for projects through a combination of debt and cash. Other Budgets City council and staff also reviewed and revised the budgets for other areas of the city including: special revenue funds, capital projects funds, and enterprise funds. Some of the highlights of these budgets for 2021 include: • General Capital Equipment Fund-The city will be continuing fleet replacements with three in the police department. • Maintenance Fund - Funding for street and trail maintenance has been allocated to continue improving the city's streets and trails. There will be crack sealing, seal coating, along with mill and overlay projects in 2021 along with trail replacement. • Liquor Stores -There is a transfer of$75,000 into the Park I mprovement fund that is typically done each year. Additional transfers of$200,000 to support pavement maintenance and $25,000 to support the General Fund are proposed for 2021. • Water-There is fleet replacement scheduled for 2021. • Storm Water- Pond capacity improvements and vegetation management are allocated for 2021. • Sanitary Sewer-Sanitary sewer lining will continue in 2021 along with fleet replacement. These budgets along with the capital improvement plan were reviewed in detail at the October and November city council work sessions. Impact The estimated market value of the average residential home in Farmington increased 6.39 percent from $268,732 in 2019 to$285,906 in 2020.The increase is similar to the increase of 6.42 percent from 2018 to 2019. The city tax impact to the average homeowner for 2021 is roughly$40. BUDGET IMPACT This establishes the budgets for 2021. ACTION REQUESTED Hear the presentation that will be made by city staff and ask any questions you may have. Accept any comments that residents may wish to share with the city council. Once the city council is comfortable, a motion should be made to: • Adopt the attached resolution establishing the 2021 tax levy. • Approve the 2021 budgets. ATTACHMENTS: Type Description ❑ Backup Material 2021 General Fund Budget D Backup Material 2021 Other Budgets D Resolution 2021 Resolution City of Farmington Budget and Tax Levy 2020 Budget,2021 Proposed and 2022 Proposed Company 2020 2021 Budget% 2022 Budget °/° Budget Proposed Change Proposed Change Non-Property Tax Revenues Licenses and Permits 473,115 517,076 9.29% 453,600 (12.28)% Intergovernmental Revenue 922,294 667,912 (27.58)%° 663,587 (0.65)% Charge for Service 565,802 576,197 1.84% 589,285', 2.27% Fines and Forfeitures 49,000 49,000 0.00% 49,000 0.00%' Investment Income 38,800 29,100 (25.00)%' 15,400 (47.08)% Miscellaneous 54,580 79,370 45.42% 53,170 (33.01)% Transfers In 1,307,570 1,379,689' 5.52%' 1,408,874 2.12%' Total Revenues 3,411,161 3,298,344 (3.31)% 3,232,916 (1.98)%', Expenditures Administration 907,162 902,915' (0.47)% 1,087,554 20.45% Human Resource 349,226 361,658' 3.56% 391,509 8.25% Dakota Broadband 24,489 37,500 53.13%' 40,500 8.00%' Finance and Risk Mgmt 778,889 776,287 (0.33)% 827,688 6.62% Police 4,677,813 4,845,796 3.59%' 5,321,825 9.82% Fire 1,445,410 1,435,685 (0.67)% 1,573,473 9.60% Community Development 1,014,867 1,007,849 (0.69)% 1,103,540 9.49% Engineering 794,635' 813,895 2.42% 889,172 9.25% Municipal Services 1,439,078' 1,511,187 5.01% 1,630,813 7.92%' Parks and Recreation 1,278,576 1,317,341 3.03% 1,454,246 10.39%I Transfers Out 932,207 822,351 (11.78)% 3,381,534 311.20%' Total Expenditures 13,642,352 13,832,464 1.39% 17,701,854 27.97% Revenues Over(Under)Expenditures (10,231,191) (10,534,120) 2.96%', (14,468,938)' 37.35% Debt Levy Bonds 2,222,950 2,444,840 9.98%' 2,099,788 (14.11)% 2005C Loan Repay-Storm Water Tr Adv 166,000 275,000 65.66% 166,000 (39.64)% 2010A Loan RepayStorm Water Tr Adv 400,000 292,253' (26.94)% 0 (100.00)% 201 OD Loan Repay-Storm Water Tr Adv 16,437 0 (100.00)% Total Debt Levy 2,805,387 3,012,093 7.37%' 2,265,788 (24.78)%' Use of Fund Balance to Lower Debt Levy 0 Net Debt Levy 2,805,387 3,012,093 7.37% 2,265,788' (24.78)% Gross Levy 13,036,578 13,546,213 3.91% 16,734,726 23.54%' Fiscal Disparities (2,294,024) (2,277,659) (0.71)% (2,277,659) 0.00% Farmington Net Tax Levy 10,742,554 11,268,554' 4.90% 14,457,067 28.30% General Fund Detailed Non-Property Tax Revenue Summary 2019 Budget, 2020 Budget, 2021 Proposed and 2022 Proposed Object 2019 2020 2021 2022 Account Budget Budget Proposed Proposed LIQUOR LICENSES 42,000 41,700 40,000 37,000 BEER&WINE LICENSES 1,750 1,100 1,100 850 CLUB LICENSES 500 500 500 500 MASSAGE LICENSE 150 350 300 100 GAMBLING LICENSE/PERMIT 250 450 250 250 OTHER LICENSE&PERMIT 1,700 1,900 1,700 1,500 ANIMAL LICENSES 4,000 4,080 2,500 3,000 Licenses 50,350 50,080 46,350 43,200 BUILDING PERMITS 272,400 330,000 380,876 325,000 REINSPECTION FEES 1,000 1,000 1,500 1,000 CODE ENFORCEMENT FEES 1,000 2,600 1,500 1,500 PLUMBING&HEATING PERMITS 35,000 52,500 50,000 50,000 SEWER PERMITS 5,000 5,000 0 0 ELECTRIC PERMITS 18,000 16,000 16,000 16,000 ISTS PERMITS 250 300 300 300 UTILITY PERMITS 6,130 6,420 10,500 7,500 SIGN PERMITS 570 790 800 800 BURNING PERMITS 1,710 1,425 1,250 1,300 OTHER PERMITS 5,000 7,000 8,000 7,000 Permits 346,060 423,035 470,726 410,400 Licenses and Permits 396,410 473,115 517,076 453,600 FEDERAL GRANT 0 5,000 5,000 5,000 FEDERAL AID LOCAL GOVERNMENT AID 314,725 328,374 105,587 105,587 MSA MAINTENANCE 215,000 215,000 184,000 184,000 POLICE AID 196,000 198,500 198,000 198,000 POST TRAINING 15,160 15,160 15,160 15,160 FIRE AID 137,910 137,910 142,490 142,490 STATE GRANT 0 9,000 MARKET VALUE CREDIT 0 0 COUNTY MISCELLANEOUS 13,470 13,350 13,350 13,350 Intergovernmental 892,265 922,294 663,587 663,587 CUSTOMER SERVICE TAXABLE CUSTOMER SERVICES NONTAXABLE 250 200 210 210 ZONING&SUBDIVISION FEES 2,000 3,050 2,600 2,600 ADMINISTRATION FEES-PROJECTS 4,000 4,500 4,000 4,000 FIRE CHARGES 225,780 237,172 239,227 260,940 POLICE SERVICE CHARGES 77,000 78,030 78,810 80,385 ENGINEERING FEES-PROJECTS EROSION &SEDIMENT CONTROL 9,900 8,100 8,100 8,100 RECREATION FEES-GENERAL 90,000 85,000 75,000 85,000 RECREATION FEES-SENIOR CTR 18,000 19,000 15,000 18,000 MEMBERSHIP FEES-SENIOR CTR 9,000 8,000 6,000 7,500 MOBILE MEALS-SENIOR CTR ADVERTISING 750 950 750 750 ADVERTISING 2,200 1,800 1,500 1,800 FRANCHISE FEE 120,000 120,000 145,000 120,000 Charges For Services 558,880 565,802 576,197 589,285 COURT FINES 42,000 49,000 49,000 49,000 Pape 1 of General Fund Detailed Non-Property Tax Revenue Summary 2019 Budget, 2020 Budget, 2021 Proposed and 2022 Proposed Object 2019 2020 2021 2022 Account Budget Budget Proposed Proposed CODE VIOLATIONS&ADMIN FINES 0 0 Fines&Forfeitures 42,000 49,000 49,000 49,000 INTEREST ON INVESTMENTS 21,900 38,800 29,100 15,400 GAIN/LOSS INVEST MKT VALUE Investment Income 21,900 38,800 29,100 15,400 MISCELLANEOUS REVENUE 5,000 1,500 31,700 1,500 CASH OVER&SHORT RENTAL INCOME-RRC 22,000 20,880 18,000 20,000 RENTAL INCOME 16,775 31,700 29,670 31,670 DONATIONS 0 500 Misc Revenue 43,775 54,580 79,370 53,170 OPERATING TRANSFERS 1,244,256 1,307,570 1,379,689 1,408,874 Transfers In 1,244,256 1,307,570 1,379,689 1,408,874 Total Revenues $3,199,486 $3,411,161 $3,294,019 $3,232,916 Pape 2 of General Fund Expenditure Detail Summary 2019 Budget, 2020 Budget 2021 Proposed and 2022 Proposed Company 2019 2020 2021 2022 Budget Budget Proposed Proposed Expenditures Administration Legislative(1005) 96,447 87,772 87,392 89,642 Administration(1010) 295,214 302,068 321,712 454,221 Elections(1013) 35,867 44,124 9,351 47,454 Communications(1014) 99,650 108,537 114,900 124,057 City Hall(1015) 354,144 364,661 369,560 372,180 Administration 881,322 907,162 902,915 1,087,554 Human Resources 336,447 349,226 361,658 391,509 Human Resource(1011) 336,447 349,226 361,658 391,509 Human Resources 336,447 349,226 361,658 391,509 Dakota Broadband 24,489 37,500 40,500 Dakota Broadband 24,489 37,500 40,500 Dakota Broadband 24,489 37,500 40,500 Finance and Risk Management Finance(1021) 569,926 609,079 603,097 651,848 Risk Management(1022) 169,810 169,810 173,190 175,840 Finance and Risk Management 739,736 778,889 776,287 827,688 Police Police Administration(1050) 873,339 1,235,377 1,263,014 1,426,458 Patrol Services(1051) 2,738,524 2,538,727 2,639,752 2,880,295 Investigations(1052) 856,544 892,059 926,430 998,472 Emergency Management(1054) 11,650 11,650 16,600 16,600 Police 4,480,057 4,677,813 4,845,796 5,321,825 Fire Fire(1060) 1,267,885 1,445,410 1,435,685 1,573,473 Fire 1,267,885 1,445,410 1,435,685 1,573,473 Community Development 908,890 1,014,867 1,007,849 1,103,540 Planning(1030) 521,062 591,133 567,681 629,388 Building Inspection(1031) 387,828 423,734 440,168 474,152 Community Development 908,890 1,014,867 1,007,849 1,103,540 Engineering Engineering(1070) 624,587 665,173 694,134 749,555 Natural Resources(1076) 122,583 129,462 119,761 139,617 Engineering 747,170 794,635 813,895 889,172 Municipal Services Streets(1072) 1,146,492 1,197,200 1,268,832 1,367,910 Snow Removal(1073) 227,064 241,878 242,355 262,903 Municipal Services 1,373,556 1,439,078 1,511,187 1,630,813 Parks and Recreation Park Maintenance(1090) 671,357 700,111 733,607 780,897 Rambling River Center(1093) 182,287 190,822 185,054 218,149 Park&Rec Admin(1094) 271,145 287,925 304,383 347,473 Recreation Programs(1095) 106,804 99,718 94,297 107,727 Parks and Recreation 1,231,593 1,278,576 1,317,341 1,454,246 Transfers Out 1,041,138.00 932,207.00 822,351.00 3,381,534.00 Transfers Out 1,041,138.00 932,207.00 822,351.00 3,381,534.00 Total Expenditures 13,007,794 13,642,352 13,832,464 17,701,854 Debt Service Funds Summary 2019 Actual, 2020 Budget, 2021 Proposed and 2022 Proposed Company Actual Budget Proposed Proposed 2019 2020 2021 2022 Revenues Property Taxes(i.e.Debt Levy) 3,212,460 2,805,387 3,012,093 2,265,788 Special Assessments 270,722 369,027 345,075 276,197 Deferred Assessments(VRC) 7,258 0 MSA Construction 0 0 Interest on Investments 48,323 13,900 10,600 6,800 Total Revenues 3,538,764 3,188,314 3,367,768 2,548,785 Expenditures Principal Repayment 2,435,000 2,975,000 2,155,000 2,190,000 Interest on Debt 370,171 358,578 335,838 251,675 Debt-Fiscal Charges 42,195 64,498 22,865 25,165 Total Expenditures 2,847,367 3,398,076 2,513,703 2,466,840 Other Financing Sources Bond Proceeds 0 1,285,000 Transfers In 293,649 89,392 Transfers Out (98,246) (1,789,337) (574,153) (472,900) Total Transfers 195,403 (414,945) (574,153) (472,900) Change in Fund Balance 886,799 (624,707) 279,912 (390,955) C D E F H M N O 1 P O R S T 1 2021 OPERATING TRANSFERS 2 TRANSFERS IN (5205) General General General General Capital Capital Capital Storm Capital Equipment Equip Fund Equip Fund General Water Arena Cap Equip Fund Fund (Police (Police (Fire 3 Fund EDA Park Imp Trunk Proj Fd (Vehicles) Vehicles) Equip) Equip) Sealcoat Street Main 5 F Fund 1000 2000 2300 1 4400 4503 5600 5600.5 5600.5 5600.6 1 5701 5711 6 572,775 1000 Tax Levy - 75,000 91,545 331,208 7 105,587 1000LGA 40,000 - 8 - 1000 Future Street CIP Debt 9 - 1000 Future Street CIP Cash 10 143,989 1000 Future Vehicle CIP Cash 143,989 11 1000 Projects CIP Cash 12 1000 Projects CIP Debt 13 2000 EDA 14 - 2500 Arena 15 6,900 3094-2016A 6,900 16 292,253 3097-2010A 292,253 17 - 3099-2011 A 18 275,000 3130-2005C 275,000 19 - 3136-2016B 20 3137-2016C 21 3300-201 OD 22 - 3139-2020A 23 340,410 6100 Admin (GF) 63,910 75,000 200,000 24 25,000 6100 25,000 25 89,411 6202 Admin(GF) 86,911 26 243,692 6202 HR 236,880 27 87,411 6302 Admin (GF) 86,911 28 61,848 6302 HR 61,848 29 86,911 6402 Admin(GF) 86,911 30 315,665 6402 HR 308,853 31 86,911 6502 Admin (GF) 86,911 32 357,126 6502 HR 335,554 33 3,090,889 1,379,689 40,000 75,000 574,153 143,989 75,000 91,545 531,208 Cell: F6 Comment:Teah Malecha: Reduced$10k 7/13/2020 Cell: N6 Comment:Teah Malecha: Removed$1,024 8/31/2020 Cell:S6 Comment:Teah Malecha: Reduced$400k 6/30/2020, moved$200k to liquor proceeds 7/13/20 Cell: U6 Comment:Teah Malecha: Reduced$40k 6/30/2020, reduced$30k 8/4/2020 Cell:W6 Comment:Teah Malecha: Reduce$17,172 8/31/2020 Cell:Z6 Comment:Teah Malecha: Employer portion of T Daus's insurance premium Cell:AA6 Comment:Teah Malecha: Budgeted transfer for insurance deductible.Reduced by$10k 6/30/2020, Reduced$4,024 and moved to LGA. Cell: F7 Comment:Teah Malecha: Reduced$20k 7/13/2020 Cell: N7 Comment:Teah Malecha: Moved $3k moved to Township rd maint,$5,976 to prop ins 8/31/2020 Cell:S7 Comment:Teah Malecha: moved$156,208 to tax levy due to LGA cut Cell:W7 Comment:Teah Malecha: Reduced$60k to$82,958 6/30/2020. Moved$67,172 to tax levy due to LGA cut Cell:T8 Comment:Teah Malecha: debt payment for backage road-Moved$126k to 2022 Cell:T9 Comment:Teah Malecha: moved$350k to 2022, update to$300k per David 6/17/2020 202nd St. Move$100k to liquor store proceeds 6/30/2020,removed$200k per council 7/13 Comment:Teah Malecha: 2016A interest pymt for interfund loan,attributed to 2010C, but to minimize special assessment prepayment risk for 2016A bonds Cell: M16 Comment:Teah Malecha: Represents annual debt service for 2010A which is used to repay Storm Water Trunk interfund loan. Actually doesn't flow through operating transfers, but is shown that way for budget purposes. Cell: M18 Comment:Teah Malecha: Represents annual debt service for 2005C which is used to repay Storm Water Trunk interfund loan. Actually doesn't flow through operating transfers,but is shown that way for budget purposes. Cell: E23 Comment:Teah Malecha: Approx 4%increase rounded to be evenly divided by 12(i.e.monthly transfers) Cell:T23 Comment:Teah Malecha: $100k DT sidewalks moved from projects CIP cash&$100k from Future Street CIP cash FHS 6/30/2020,moved to sealcoat 7/13/20 Cell:AA23 Comment:Teah Malecha: Budgeted transfer for insurance deductible-Insurance Deductible Spreadsheet Cell: E25 Comment:Teah Malecha: Approx 4%increase rounded to be evenly divided by 12(i.e.monthly transfers) Cell:AA25 Comment:Teah Malecha: Budgeted transfer for insurance deductible-Insurance Deductible Spreadsheet Cell: E26 Comment:Teah Malecha: Amounts per worksheet in @H Drive-Budget 2021 Updated 2020 Salary Distribution Cell:Y26 Comment:Teah Malecha: Amounts per worksheet in @H Drive-Budget 2021 Updated 2020 Salary Distribution Cell: E27 Comment:Teah Malecha: Approx 4%increase rounded to be evenly divided by 12(i.e.monthly transfers) Cell:AA27 Comment:Teah Malecha: Budgeted transfer for insurance deductible-Insurance Deductible Spreadsheet Cell: E28 Comment:Teah Malecha: Amounts per worksheet in @H Drive-Budget 2021 Updated 2020 Salary Distribution rron• G,70 Approx 4%increase rounded to be evenly divided by 12(i.e.monthly transfers) Cell: E32 Comment:Teah Malecha: Amounts per worksheet in @H Drive-Budget 2021 Updated 2020 Salary Distribution Cell:Y32 Comment:Teah Malecha: Amounts per worksheet in @H Drive-Budget 2021 Updated 2020 Salary Distribution Special Revenue Funds Budget Summary 2019 Actual, 2020 Budget, 2021 Proposed and 2022 Proposed Company 2019 2020 2021 2022 Actual Budget Proposed Proposed Revenues EDA(2000) 75,832 165,611 182,574 194,196 TIF-Trident(2054) 147,996 146,410 146,310 Police Donations&Forfeitures(2100) 4,063 1,300 3,050 3,000 Park Improvement Fund(2300) 84,188 36,745 36,200 35,200 Ice Arena(2500) 367,717 368,200 380,000 395,900 Total Revenues 679,795 571,856 748,234 774,606 Expenditures EDA(2000) 130,270 201,641 205,190 231,559 TIF-Trident(2054) 132,995 2,850 134,439 134,439 Police Donations&Forfeitures(2100) 1,790 3,100 2,000 2,000 Park Improvement Fund(2300) 328,100 39,000 15,000 160,000 Ice Arena(2500) 380,836 368,200 373,917 395,725 Total Expenditures 973,991 614,791 730,546 923,723 Transfers Transfers In 127,850 115,000 115,000 116,085 Transfers Out (12,639) 0 Total Transfers 115,211 115,000 115,000 116,085 Change in Fund Balance (178,984) 72,065 132,688 (33,032) Capital Projects Funds Summary 2019 Actual, 2020 Budget, 2021 Proposed and 2022 Proposed Company 2019 2020 2021 2022 Actual Budget Proposed Proposed Revenues Sanitary Sewer Trunk(3900) 67,610 33,540 28,985 27,985' Cable Communications Fund(4000) 184,327 146,500 146,000 143,800' Road and Bridge/Street Reconstruction Fund(4100) 11,333 1,700 900 600 Fire Capital Projects Fund(4300) 79,191 0 800 500' Storm Water Trunk(4400) 212,837 8,600 13,200 8,400 RRC&Youth Hockey Cap Proj Donations(Rec Cap Proj Fund-4500) 31,477 18,900 15,900 15,500 Private Capital Projects(4600) 32,921 4,300 6,200 4,000 Permanent Imp Revolving Fund(4900) 6,923 1,400 1,200 800 Gen'I Cap Equip Fund(5600) 33,763 2,500 7,000 4,500 Maintenance Fund(5700) 1,786,374 13,600 103,500 5,345,453' Total Revenues 2,446,756 231,040 323,685 5,551,538 Expenditures Sanitary Sewer Trunk 0 0 Cable Communications Fund 100,236 126,000 123,000 123,000 Road and Bridge/Street Reconstruction Fund(4100) 24 0 Fire Capital Projects Fund(4300) 317,591 1,200,000 Storm Water Trunk Fund 59,010 0 RRC&Youth Hockey Cap Proj Donations(Rec Cap Proj Fund-4500) 51,038 9,600 24,500 1,220,000' Private Capital Projects 2,723 0 Permanent Imp Revolving Fund 0 0 Gen'I Cap Equip Fund(5600) 204,293 728,256 511,148 880,949 Maintenance Fund 4,533,035 1,084,607 624,400 9,497,736' Total Expenditures 5,267,950 3,148,463 1,283,048 11,721,685'' Transfers Transfers In 2,657,554 2,668,522 1,537,506 7,260,995' Transfers Out 0 0 Total Transfers 2,657,554 2,668,522 1,537,506 7,260,995' Change in Fund Balance (163,640) (248,901) 578,143 1,090,848' Enterprise Funds Budget Summary 2019 Actual, 2020 Budget, 2021 Proposed and 2022 Proposed Company 2019 2020 2021 2022 Actual Budget Proposed Proposed Revenues Liquor Stores,Net of Cost of Goods Sold(6100:6115) 1,475,234 1,537,042 1,575,570 2,137,185 Sewer Operations(6200:6205) 2,991,034 2,326,614 2,423,687 2,555,546 Solid Waste(6300:6302) 2,345,256 2,449,853 2,588,985 3,025,065 Storm Water(6400:6405) 1,703,000 1,242,633 1,214,320 1,266,050' Water(6500:6508) 3,363,005 2,407,694 2,501,293 2,591,438 Streetlights(6600:6602) 233,437 224,900 225,200 224,800' Total Revenues 12,110,965 10,188,736 10,529,055 11,800,084'' Expenditures Liquor Stores 1,073,621 1,097,782 1,005,760 1,137,405' Sewer Operations 2,312,354 2,573,895 3,122,704 2,685,412' Solid Waste 1,941,259 2,312,989 2,792,189 3,279,439' Storm Water 553,632 1,036,854 758,276 760,484' Water 1,426,000 7,246,319 2,002,148 7,875,108 Streetlights 165,887 221,500 221,500 221,500 Total Expenditures 7,472,753 14,489,339 9,902,577 15,959,348' Transfers Transfers In 2,219,925 70,201 35,196 36,605' Transfers Out (3,084,324) (1,548,273) (1,694,385) (5,005,647) Total Transfers (864,399) (1,478,072) (1,659,189) (4,969,042), Change in Fund Balance 3,773,813 (5,778,675) (1,032,711) (9,128,306) RESOLUTION NO. R 6 2020 A RESOLUTION APPROVING THE 2020 PROPOSED TAX LEVY COLLECTIBLE IN 2021 Pursuant to due call and notice thereof, a regular meeting of the City Council of the city of Farmington was held at the Farmington City Hall on the 7`h day of December 2020 at 7:00 p.m. Members Present: Larson, Bernhj elm, Craig, Hoyt Members Absent: Donnelly Member Hoyt and Member Craig introduced and seconded the following: WHEREAS, Minnesota State Statute currently in force requires certification of the proposed tax levy to the Dakota County Auditor on or before December 30, 2020; and WHEREAS, the City Council of the city of Farmington, Minnesota is in receipt of the proposed 2021 revenue and expenditure budget. WHEREAS, the City Council shall use existing City revenues to meet the annual debt obligations for 2013A GO Improvement Refunding Bonds $56,025; thereby reducing the total debt levy issued and collected from property taxes of$443,000. WHEREAS, the City Council shall use existing City revenues to meet the annual debt obligations for 2016B GO Capital Improvement Plan Refunding Bonds $30,385; thereby reducing the total debt levy issued and collected from property taxes of$635,000. NOW, THEREFORE, BE IT RESOLVED by the Mayor and City Council of the city of Farmington that the following sums of money be levied in 2020, collectible in 2021, upon the taxable property in said city of Farmington for the following purposes: General Fund $10,534,120 Debt Le + 3 012 093 Gross Le $13,546,213 Fiscal Disparities - $2,277,659 Net Tax Le $11,268,554 This resolution was adopted by recorded vote of the Farmington City Council in open session on the 7ffi day of December 2020. Todd Larson, Mayor Attested to on the 7fh day of December 2030. , David McKnight, City Administrator SEAL 2021 BUDGET Summary of Debt Service levy to be attached and become part of this resolution. Fund Proiect Levy Amount 3091 2013A GO Improvement Refunding Bond $443,000 3093 2015A GO Improvement Bond $293,500 3094 2016A GO Refunding Bond $574,327 3136 2016B GO Refunding Bond $635,000 3138 2019A GO Street Reconstruction Bond $231,000 3139 2020A GO Equipment Certificates $268,013 Total Bond Financing $2,444,840 3130 2005C GO Capital Improvement Bond $275,000 3097 2010A GO Improvement Bond $292,253 Total Debt Levy $3,012,093 The amount levied is less than the required amounts from the payment schedule for some of the bonds. The bonds are listed on Form B which is part of this resolution. The city has sufficient revenues in the bond funds to meet the debt obligations. City of Farmington,Levy Certification,Debt Service Schedule. Form B Net Levy Original Amount Per Increase Certified B.U. Bond Issue Principal Date Issued Bond Book (Decrease) Debt Levy Notes 3091 GO Improvement Refunding 2013A $ 5,365,000 1/10/2013 $ 499,025 $ (56,025) $ 443,000 A 3093 GO Street Reconstruction 2015A $ 3,050,000 10/15/2015 $ 285,915 $ 7,585 $ 293,500 3094 GO Refunding 2016A $ 3,450,000 12/1/2016 $ - $ 574,327 $ 574,327 3136 Cap Imp Plan Refunding 2016B $ 4,540,000 12/1/2016 $ 665,385 $ (30,385) $ 635,000 A 3138 GO Street Reconstruction 2019A $ 1,645,000 5/15/2019 $ 231,000 $ $ 231,000 3139 GO Equipment Certificates 2020A $ 1,105,000 2/19/2020 $ 268,013 $ $ 268,013 Total Bond Financing $ 19,155,000 $ 1,949,337 $ 495,502 $ 2,444,840 3130 2005C GO Bonds Internal Loan Repayment $ 2,280,000 7/5/2005 $ - $ 275,000 $ 275,000 B 3097 2010A GO Cap Imp Internal Loan Repayment $ 3,850,000 1/11/2010 $ - $ 292,253 $ 292,253 B $ 6,130,000 Total Debt $ 25,285,000 $ 1,949,337 $ 1,062,755 $ 3,012,093 Agrees to I hereby certify that the above schedule of bond levies to be spread on the payable 2021 tax rolls agrees with the City preliminary debt records. A copy of the corresponding debt levy resolution is attached. > levy adopted by ni council 12/7/2020 12/7/20 20. Finance Director Date € (A)Existing revenues in the respective bond fund are being used to meet the annual debt obligations. (B)Bonds optionally redeemed with an internal loan from the city. Loan is being repaid with debt levy. CITY OF © 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 uu� O Farmington M N.gov TO: Mayor, Councilmembers and City Administrator FROM: David McKnight, City Administrator SUBJECT: Pandemic Response Update DATE: December 7, 2020 INTRODUCTION will provide an update on the city's response the pandemic as a part of the city council meeting. DISCUSSION NA BUDGET IMPACT NA ACTION REQUESTED Listen to the update that is provided and provide any guidance as appropriate.