Loading...
HomeMy WebLinkAbout08.17.20 Council Packet CITYOF Meeting Location: FARMINGTON Farmington City Hall 430 Third Street AMINO=w. r/�/ � Farmington,MN 55024 CITY COUNCIL REGULAR MEETING AGENDA August 17, 2020 7:00 P.M. Action Taken 1. CALL TO ORDER 7.00 P.M. 2. PLEDGE OFALLEGIANCE 3. ROLL CALL 4. APPROVE AGENDA S. ANNOUNCEMENTS I COMMENDATIONS 6. CITIZEN COMMENTS/RESPONSES TO COMMENTS(This time is reserved for citizen comments regarding non-agenda items. No official action can be taken on these items. Speakers are limited to five minutes to address the city council during citizen comment time.) 7. CONSENT AGENDA a) Approve Minutes of the August 3, 2020, City Council Meeting— Administration Approved b) Approve Minutes of the August 10, 2020, City Council Work Session— Administration Approved c) Approve Agreement with Wold Architects and Engineers to Provide Design Services to Enclose the Main Service Counter in City Hall—Parks Approved d) Acknowledge Financial Review for the Quarter Ending June 30, 2020— Finance Acknowledged e) Approve Bills - Finance Approved REGULAR AGENDA 8. PUBLIC HEARINGS 9. AWARD OF CONTRACT a) Schmitz-Maki Arena Rubber Floor Replacement Project Approved 10. PETITIONS,REQUESTSAND COMMUNICATIONS 11. UNFINISHED BUSINESS 12. NEW BUSINESS 13. CITY COUNCIL ROUNDTABLE 14. EXECUTIVE SESSION a) City Administrator Annual Performance Review 15. ADJOURN CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 1�ulWll�l�u,� ® Farmington MN.gov TO: Mayor, Councilmembers and City Administrator FROM: David McKnight, City Administrator SUBJECT: Approve Minutes of the August 3, 2020 City Council Meeting-Administration DATE: August 17, 2020 INTRODUCTION Attached for your review are the minutes of the August 3, 2020 city council meeting. DISCUSSION NA BUDGET IMPACT NA ACTION REQUESTED Approve the minutes of the August 3, 2020 city council meeting. ATTACHMENTS: Type Description D Cover Memo August 3, 2020 City Council Minutes CITY OF FARMINGTON CITY COUNCIL MINUTES REGULAR MEETING AUGUST 3, 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, Craig and Hoyt Absent-Donnelly Staff Present-Community Development Director Kienberger, Finance Director Malecha, Parks and Recreation Director Distad, Police Chief Rutherford and Fire Chief Elvestad. 4. Agenda Motion by Bernhjelm, second by Craig, to approve the agenda as presented. APIF, motion carried. 5. Announcements/Commendations None 6. Citizen Comments a) Response to Mr. William Pelach 7. Consent Agenda Motion by Hoyt, second by Bernhjelm,to approve the consent agenda: a) Approve Minutes of the July 20, 2020 City Special Council Meeting-Administration b) Approve Contract for the 2020 Sidewalk Repairs-Public Works c) Adopt Resolution R33-2020 Establishing the Date of an Assessment Hearing for the Reassessment of the County Road 50 Water and Sewer Utilities-Public Works d) Approve Consent to Assignment Sapphire Lake Development Contracts-Community Development August 3, 2020 Minutes -1- e) Adopt Resolution R34-2020 Approving a Gambling Premise Permit for Farmington Wrestling-Community Development f) Approve Recommendation for Hire Fire-Human Resources g) Approve Recommendation for Hire Fire-Human Resources h) Approve Recommendation for Hire Fire-Human Resources i) Approve Recommendation for Hire Fire-Human Resources j) Approve Recommendation for Hire Fire-Human Resources k) Approve Recommendation for Hire Fire-Human Resources 1) Approve Recommendation for Hire Liquor-Human Resources m) Approve Bills-Finance APIF, motion carried. 8. Public Hearings None 9. Award of Contract None 10. Petitions, Requests and Communications None 11. Unfinished Business None 12. New Business a) CARES Act Grant Funding and Reimbursement Finance Director Malecha presented an update on CARES Act funding the city has received. The city has received financial assistance under the CARES Act for COVID-19 related expenses. Guidelines and frequently asked questions on the use of these funds has been developed by the United States Treasury Department and continues to be updated. Staff has been working on evaluating expenditures that are reimbursable under the CARES Act. DISCUSSION The city received an allocation of$1,723,785 from the CARES Act.The allocation provides for expense reimbursement, but not revenue replacement for lost revenues. City staff have August 3,2020 Minutes -2- been evaluating expenditures that are eligible for reimbursement.The CARES Act funding can only be used to cover costs that: • are necessary expenditures incurred due to the public health emergency with respect to COVID-19. • were not accounted for in the budget most recently approved as of March 27,2020. • were incurred during the covered period of March 1, 2020 through November 15,2020.Those dates are for cities only. The guidance provided by the United States Treasury is broad and staff continues to utilize the information as it is updated.The expenses that are eligible include: • Medical • Public Heath • Payroll • Public Health Measures • Economic Support The city has expended a vast amount of money in response to COVID-19. Much of it relates to ensuring staff safety and telework to continue city operations. Below is a list of items that are eligible under the CARES Act. Item Cost Cleaning Supplies $4,345.60 Thermometers 407.45 Personal Protective Equipment 7,666.94 Building Materials 2,343.23 IT Equipment 237,376.15 Wages 416,687.86 The cleaning supplies include hand sanitizer, hand soap, disinfectant, bleach, etc.The city has purchased PPE for staff including safety glasses, N95 masks, gloves,face shields, and isolation gowns.The RRC, liquor stores, city hall, and the police department have had plexiglass installed along with other safety measures. The equipment necessary for staff to telework and continue to maintain city operations is extensive.The IT equipment is listed in detail below. Many of the city staff have desktop computers, but are able to telework with the appropriate equipment.This provides those capable with the necessary items. The conference room equipment allows the city to setup conference rooms for remote meetings,trainings, and accommodate social distancing. It includes two at city hall, one at the fire station, one at the RRC, and one at the police department.The wireless access points and mapping allow staff to determine where to best place access points throughout city facilities to accommodate social distancing August 3, 2020 Minutes -3- measures.The server and switch upgrades are needed to allow staff telework capabilities similar to working at city facilities. Item Cost Laptops&Peripherals $42,435.34 Professional Services 7,667.87 Conference Room Equipment 19,850.00 Wireless Access Points&Mapping 11,033.00 Switch Upgrade 18,277.35 Server Upgrade 138,112.59 The guidelines for payroll expenses limit what can be reimbursed. Per the Treasury guidance, payroll expenses for public safety, public health, health care, human services, and similar employees are included if they are substantially dedicated to mitigating or responding to COVID-19.The government entity may presume payroll costs for public safety employees are payments for services substantially dedicated to mitigating or responding to COVID-19.Therefore, potentially allowing the entire payroll cost to be covered. Payroll and benefit costs associated with public employees who could have been furloughed or otherwise laid off but were repurposed instead are also covered. Hazard pay for performing hazardous duty or work involving physical hardship due to COVID-19 is eligible.The wages included for reimbursement include employees in the following departments: Administration, Communications, City Hall, Finance, Building Inspections, Planning, Police, Fire, Engineering, Streets, Parks, RRC, Liquor, Solid Waste, and IT. Staff has spoken with the city's auditor, MMKR,for guidance on the reimbursement of expenditures. Per MMKR, the city is currently taking a conservative approach on reimbursement item requests. At this point, it is in the best interest of the city to continue that approach. Currently the city is not requesting reimbursement for all public safety payroll costs. If after all other items have been reimbursed and there are funds remaining, the city can review the possibility of reimbursing for additional public safety wages. In addition to the items above, the city is also able to reimburse additional items for staff safety, COVID-19 mitigation, and telework.Those items include: • HVAC filters at all city buildings. • Water bottle fountains at city hall and the central maintenance facility. • Automated paper towel dispensers, automated soap dispensers, and foot-activated restroom door openers at city facilities. • Restroom cleaning systems for sanitizing and disinfecting at all city buildings. • Additional sink at the police department. • Electrostatic sprayers for sanitizing and disinfecting difficult to clean items such as the fire engines. August 3,2020 Minutes -4- • Fire equipment decontamination washers at each fire station for cleaning and disinfecting equipment and gear after use. • Fingerprint reader at the police station to reduce officer contact by eliminating transportation, booking,and introduction into jail for some individuals. • Cloth face masks for all city staff. • Cube modification for staff that does not currently meet social distancing guidelines. • AC unit for server room housing new server and switches for telework.There is not currently a dedicated unit for the server room leaving equipment open to vulnerabilities. • Enclosing front reception desk at city hall. The cost of those items is roughly$168,670 and covered under the current CARES Act reimbursement guidelines. The city is able to provide small local businesses with grants. Dakota County and the Dakota County CDA have created a Small Business Relief Grant Program to allow temporary financial support to small businesses affected by COVID-19.The city will be working with the Dakota County CDA to distribute $500,000 to local businesses based upon their application submission that can be done through the Dakota County CDA. The guidelines for the program include: • Businesses may apply for a one-time emergency grant up to $10,000 based on economic hardship from COVID-19. • Businesses must have 50 or fewer full-time employees. • It is required to be a locally owned and operated for-profit organization with a physical location in Farmington. • Majority owned by a permanent resident in Minnesota. • In good standing with the Minnesota Secretary of State and the Minnesota Department of Revenue as of March 1, 2020. • In good standing with Dakota County and city of Farmington. • Demonstrate the business was adversely affected by Executive Orders related to COVID-19 business restrictions. • Demonstrate financial hardship because of the COVID-19 outbreak. Ineligible businesses include: • Businesses that do not have a physical address in Dakota County and the city of Farmington. • Home based businesses with the exception of licensed childcare providers. • Non-profit organizations. • Businesses that derive any income from adult-oriented uses. • Businesses in default conditions prior to February 29, 2020. August 3,2020 Minutes -5- • Businesses that derive income from passive investments without operational ties to operating businesses. • Businesses primarily focusing on speculative activities based on fluctuations in price rather than the normal course of trade. • Businesses earning more than half of its annual net revenue from lending. • Businesses engaging in pyramid dales, where a participant's primary incentive is based on sales of an ever-increasing number of participants. • Businesses engaging in activities prohibited by federal law or applicable law in the local jurisdiction of the business. • Businesses engaging in gambling enterprises, unless the business earns less than 50 percent of its annual revenue from lottery sales. The administration costs of the program will likely be roughly 3.44 percent of the money we dedicate to the program.The grant application is available on the Dakota County CDA's website for submission.The applications will be accepted until 4:30 p.m. on Friday,August 14, 2020. If the applicants exceed the available funding, a randomized selection process will take place. City staff anticipates that this is the first of three rounds of expenditures that the city council will be asked to consider and approve. The next round of expenditures will be city reimbursement related items that we are still gathering costs on for you to review. The third round of expenditures will be any final city reimbursements, any decisions that need to be made in the area of business grants and the potential consideration of funding to other entities that have contacted the city in regards to potential use of our CARES Act dollars. At this point, Fairview Ridges and ISD 192 have contacted the city. Finally, a thank you to city staff members Peter Gilbertson,Jim Constantineau,Jennifer Gabbard,Justin Elvestad, Adam Kienberger and David McKnight for their work on this committee. Councilmember Bernhjelm asked about ineligible businesses, specifically non-profit organizations. Malecha stated we believe we can contribute some of our funds to this type of organization. Bernhjelm asked about the reporting from the county in terms of business assistance applications. Community Development Director Kienberger stated that we would hear from the county in terms of applications after the deadline has passed. We will receive an update at that point. Bernhjelm clarified the deadline date of August 14, 2020 for Farmington businesses to apply for these funds. August 3,2020 Minutes -6- Councilmember Craig asked about business eligibility of those who received funding from previous government assistance COVID programs. Kienberger clarified that the Dakota County CDA has great information on eligibility guidelines that businesses should review. Councilmember Hoyt asked for clarification on the amount of potential city expenditures. Malecha provided this clarification for the city council. Hoyt was trying to determine if there would be any funding available for potential future city reimbursement. Malecha stated she estimated about$292,000 that the city will have to work with on potential reimbursements. Motion by Bernhjelm, Second by Hoyt, to adopt Resolution R35-2020 Approving First Round Reimbursement of City Expenditures Due to COVID-19 and Provide $500,000 in Grant Funding to Local Businesses with the CARES Act Allotment. APIF, motion carried. b) COVID-19 Response Update Parks and Recreation Director Distad, Fire Chief Elvestad and Police Chief Rutherford all provided updates to city activities related to COVID in their respective departments. Parks programs have been operating over the past few months and the Rambling River Center has slowly started to offer a few programs in the facility. Fire Chief Elvestad updated the city council on fire inspections, the success of duty crews and other department related items. Mayor Larson asked about the smaller group trainings. Elvestad stated they are working out very well. Firefighters are getting more hands on training compared to the large group training. Police Chief Rutherford shared that not much has changed in the past month. The department has gone back to the standard schedule recently that is working out. The department has reestablished a good supply of PPE for all city staff as well. All staff is now back in the building and they are still considering options on when to open the police department back open to the public. Councilmembers thanked the department heads for the update. 13. City Council Roundtable Bern hjelm-Thanked Representative Garofalo for the signs thanking the police and fire department. Thought the way that residents communicated with the city council last week in regards to the ice arena was a good example of how we work together. Congratulated all of the new firefighters who graduated last week. Thanked parks staff for opening the Rambling River Center. Hoyt-Congratulated the new firefighters and thanked city staff for their work. August 3, 2020 Minutes -7- Craig-Thanked staff for their work on COVID and the CARES Act. Encouraged residents to contact the city council with concerns they have on our approach to the pandemic. Kienberger-Encou raged businesses to apply for CARES funding and shared that masks are available at city hall for businesses through the State of Minnesota and the Dakota County Regional Chamber of Commerce. Rutherford-Thanked the community for the continued support of the department. Shared that the newest member of the department is doing remarkably well. Larson-Thanked city staff for all of their work related to the pandemic and encouraged residents to shop local. Adjourn Motion by Hoyt, second by Bernhjelm, to adjourn the meeting at 7:41 p.m. APIF, motion carried. Respectfully Submitted David McKnight, City Administrator August 3,2020 Minutes -8- CITY 4F O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-280-6800 Farmington MN.gov TO: Mayor, Councilmembers and City Administrator FROM: David McKnight, City Administrator SUBJECT: Approve Minutes of the August 10, 2020 City Council Work Session-Administration DATE: August 17, 2020 INTRODUCTION Attached for your review are the minutes of the August 10, 2020 city council work session. DISCUSSION NA BUDGET IMPACT NA ACTION REQUESTED Approve the minutes of the August 10, 2020 city council work session. ATTACHMENTS: Type Description D Backup Material August 10, 2020 Work Session Minutes CITY OF FARMINGTON CITY COUNCIL MINUTES WORK SESSION AUGUST 10,2020 Call to Order Mayo Larson called the work session to order at 6:00 p.m. Roll Call Present-Larson, Bernhjelm,Craig, Donnelly, and Hoyt Absent-None Also Present-Police Chief Rutherford, Parks and Recreation Director Distad, and Finance Director Malecha Agenda Motion by Bernhjelm,second by Craig,to approve the agenda as presented.APIF, motion carried. 2021 Draft Budgets Finance Director Malecha presented the second draft of the 2021 General Fund budget and tax levy. Bernhjelm asked who determined that the vehicles were police only being replaced. Malecha stated that it was discussed by McKnight and her to reduce it to that number.The capital improvement plan will be brought back at the September 14th work session and fleet is a part of that.The vehicles replaced can be changed with that amount. Larson asked Rutherford how many vehicles were replaced at the PD. Rutherford stated that the PD was mindful due to the budget but was unsure of the number. Bernhjelm and Donnelly requested clarification for what year the liquor store profits were from. Donnelly was concerned that the city was allocating funds that were not yet earned. Malecha clarified that the funds were from previous years; part was allocated to the arena approved at the last meeting and this would be the remainder. Donnelly asked where the$200,000 from the LGA reduction would come from. Malecha explained that due to Farmington's growth being at nine percent and the average of other cities at 5.8 percent, Farmington would see a reduction in LGA of roughly$220,000. She stated that there are some options that her and McKnight would like to discuss prior to bringing it back to council. Donnelly stated that he was not comfortable with six percent with that outstanding. Craig and Bernhjelm would like staff to discuss reopening union contracts. Donnelly and Bernhjelm would like to be mindful of the current economy and staffing, but raises should not be included in the budget. Malecha stated that raises and benefits are included in the current GF draft budget. Even if contracts were able to be reopened it would not be completed by the September 2150 meeting to adopt the levy. City council is not comfortable adopting a six percent increase. Donnelly stated that once it is adopted it will never be reduced. It has historically been done once. Council requested that an additional work session be held to further reduce the draft budget with no specific number provided.They requested staff to bring additional ideas. Bernhjelm would like to see the city align their preliminary budget with other comparable cities. Donnelly stated that the fund balance is something that could be used to reduce the levy. Malecha stated that staff would further revise the budget and bring it back at the work session on September 14th with the CIP. Law Enforcement Reform Legislation Police Chief Rutherford discussed peer counselling and stress management teams including what is privileged information and what is not.The information firms up peer counselling for public safety. Not available in Farmington yet. Rutherford is unsure of how well it would be received among staff.Our PD does have annual wellness checks. The legislation authorized BCA to create a special unit to handle use of force,conflict of interest,and criminal sexual conduct. Four-year sunset included in legislation. There was a residency incentive authorized. Bernhjelm asked whether we would have to adopt a resolution. Larson stated the council would be supportive. Use of certain types of restraints was banned including: hog tying,chokeholds including vascular neck restraint.They have not been used in Farmington 12+years. Rutherford stated our policies are being updated to reflect. Cleaned up language on use of deadly force. Warrior style training has been prohibited. Larson asked if our officers are able still able to protect themselves. Rutherford said they are. Craig is concerned by the language regarding warrior style training and restrictions on officers. POST Board must establish advisory council,central depository for information, require new and updated policy on use of force, database for misconduct. Passed legislation for more training and funding for conflict management, menta Rutherford stated that Farmington adopts POST Board policies as they come out verbatim. Grievance arbitration selection procedure refined to six arbitrators. Donnelly requested clarification on previous process of arbitration. Rutherford stated that it was previously much broader and described how it could cause issues.Craig asked if six people are enough. Rutherford believes that it will be and will be a positive change. Larson said that it was good information. Bernhjelm thanked Rutherford for providing the information and explaining how it would apply to Farmington. Rutherford stated that the vascular neck restraint was the best tool they had and is disappointed of the change. If used properly it is more effective than a taser, baton,or chemical sprays. Adjourn Motion by Hoyt,second by Bernhjelm,to adjourn the meeting at 6:49 p.m.APIF, motion carried. CITY OF 0 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 OFarmington MN.gov TO: Mayor, Councilmembers and City Administrator FROM: Randy Distad, Parks and Recreation Director SUBJECT: Approve Agreement with Wold Architects and Engineers to Provide Design Services to Enclose the Main Service Counter in City Hall-Parks DATE: August 17, 2020 INTRODUCTION The CARES Act funding allows for projects to be completed to help mitigate COW D-19. DISCUSSION At the August 3, 2020 City Council meeting approval was given to use CARES Act funding to complete projects associated with mitigating COW D-19. One of the projects staff identified was to enclose in glass the main service counter in city hall. The project would involved having glass placed from the counter all the way to the ceiling for the entire length of the counter. Staff contacted Wold Architects and Engineers (Wold) about providing design services for this project because of the amount of glass needed to enclose this space and also due to different heights of the counter. Wold staff submitted a proposal, which is attached. Wold is proposing to charge a fee of$1,500 to design the glass enclosure plus an additional $100 to cover reimbursable costs. Wold has also estimated the project will cost$25,000.00, which includes funding for contingencies. Wold has experience with this type of project and recently was hired by Rice County to design a glass enclosure similar to what the city is looking to accomplish. Wold is also willing to expedite the design process, so the project work can be bid and work can be completed before the November 14, 2020 deadline that the CARES Act funding must be spent. The proposal submitted will allow city staff to work directly with Wold staff on project design and preparation of the construction documents. Once the construction documents are completed, Wold staff will solicit quotes for the project. Once quotes are received, tabulated and the low apparent quote is known for the project, staff will be requesting from the City Council entering into a contract with the contractor submitting the low quote to complete the project. City staff will oversee the construction of the city hall's main service counter glass enclosure. BUDGET IMPACT The cost of Wold's services is proposed at a total cost of$1,500.00 plus an estimated$100.00 for reimbursable expenses. The cost of the professional services Wold will be providing to the city will be covered by the CARES Act funding. ACTION REQUESTED The action requested is to approve a contract with Wold in the amount of$1,500.00 and an estimated $100.00 for reimbursables and further authorize the mayor and city administrator to sign the contract with Wold to provide the following services: • design and create a construction document for a glass enclosure of the main service counter in city hall • solicit and provide quotes from contractors to the city for the project ATTACHMENTS: Type Description © Backup Material Wold Proposal AGREEMENT AGREEMENT made this / 2 //? day of re" 2020,between the CITY OF FARMINGTON, a Minnesota municipal corporation ('City"), and WOLD ARCHITECTS AND ENGINEERS,INC.,a Minnesota corporation("Wold"). 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. Wold Proposal dated July 31,2020,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"having the last priority. 2. OBLIGATIONS OF WOLD. Wold shall provide the goods, services, and perform the work in accordance with the Contract Documents. 3. OBLIGATIONS OF THE CITY. The City shall pay Wold in accordance with the proposal. 4. SOFTWARE LICENSE. If the equipment provided by Wold pursuant to this Contract contains software, including that which the manufacturer may have embedded into the hardware as an integral part of the equipment, Wold shall pay all software licensing fees. Wold shall also pay for all software updating fees for a period of one year following cutover+!Wold 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. Wold shall complete its obligations on or before September 15,2020. 7. PAYMENT. a. When the obligations of Wold have been fulfilled and accepted,the City shall pay Wold $1,500.00 plus up to $100.00 in reimbursable expenses. Such payment shall be made not later than thirty(30)days after completion, certification thereof, and invoicing by Wold. b. No final payment shall be made under this Contract until Wold 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 Wold 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 Wold, 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, Wold must pay any subcontractor within ten (10) days of the Wold's receipt of payment from the City for undisputed services provided by the subcontractor. Wold must pay interest of one and one-half percent (1% %) 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, Wold shall pay the actual penalty due to the subcontractor. A subcontractor who prevails in a civil action to collect interest penalties from Wold shall be awarded its costs and disbursements, including attorney's fees, incurred in bringing the action. 10. WORKER'S COMPENSATION. Wold 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. Wold 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: 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 Wold shall continue to provide evidence of such coverage to City on an annual basis during the aforementioned period; or if any reason Wold's work ceases before final payment,for a minimum period of three (3)years from the date Wold ceases work. 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): 2 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. Wold 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 Wold pursuant to this Agreement. Wold 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 Wold receives a request to release data, Wold must immediately notify City. City will give Wold instructions concerning the release of the data to the requesting party before the data is released. Wold agrees to defend, indemnify, and hold City, its officials, officers, agents, employees, and volunteers harmless from any claims resulting from Wold'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. Wold shall maintain complete and accurate records of expenses involved in the performance of services. 14. 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. Wold will include a similar provision in all subcontracts entered into for the performance of this contract. 15. INDEMNITY. Wold 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 Wold's performance of work or services provided for herein. 16. 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. 17. GOVERNING LAW. The laws of the State of Minnesota govern the interpretation of this Contract. 18. 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 renders this Contract impossible to perform. Such remaining terms and conditions of the Contract shall continue in full force and effect and shall continue to operate as the parties'entire contract. 3 19. 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. 20. TERMINATION. This Agreement may be terminated by the City for any reason or for convenience upon written notice to Wold. In the event of termination, the City shall be obligated to Wold for payment of amounts due and owing for materials provided or for services performed or furnished to the date and time of termination. Dated: /'? , 2020. CITY OF FARMINGTON By: .�— ------ Todd Larson,Mayor By: lz� avid McKnight, ty Adipinistrator Dated: August 17, 2020 WOLD ARCHITECTS AND ENGINEERS,INC. By: Its: Partner Partner 4 Fx klb ^`-f July 31,2020 Randy Distad,Parks and Recreation Director City of Farmington 430 Third Street Farmington,Minnesota 55024 Re: City of Farmington City Hall Service Counter Glass Installation Commission No.9999 Dear Randy: Thank you for meeting with me earlier this week to discuss the potential permanent glass barrier installation at the existing City Hall's Main Service Window to help protect the public and city staff. As discussed,the City is looking for a permanent glass barrier between the service desk and the corridor containing a 4"-5"gap at the middle,accessible section. Based on recent cost information for glass installations similar in size and scope to this project,we are estimating a construction cost of roughly$22,000 which would include all glazing,hardware components and any potential modifications to the existing ceiling required to support the new glass system. Using the fee factor of 7.5%for renovation work,the design fees are calculated to be$1,500 for the base bid scope of work. Reimbursable expenses would be in addition to this fixed fee and are estimated to be approximately $100. We understand that the City of Farmington would be potentially funding this project through the CARES ACT and consequently would need to be fully completed and paid for by November 15, 2020. We are prepared to expedite the design and assist in soliciting quotes to ensure this project is completed in time. Please let me know if you would like to move forward with this proposal. Sincerely, Wold Architects and Engineers W u" J ke Wollensak I AIA Associate cc: John McNamara,Wold Matt Mooney,Wold LW/Promo/CI_Farmington/crsp/jul20 Wold Architects and Engineers PLANNERS 332 Minnesota Street,Suite W2000 ARCHITECTS Saint Paul,MN 55101 woldae.com 1 651 227 7773 ENGINEERS Wold Architects and Engineers • • 332 Minnesota Street,Suite W2000 Saint Paul,MN 55101 woldae.com 651 227 7773 Estimate for Glass Service Window Glazing: Approx. 200 SF x $110/SF = $22,000 (including and hardware for attaching to counter, walls and possibly ceiling) Misc. Soft Costs: $3,000 (including design fee and contingency) TOTAL ESTIMATED PROJECT COST: $25,000 Approx.8'up to ceiling \ N O r t; CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-280-6800 II/®�►�� ® Farmington M N.gov TO: Mayor, Councilmembers and City Administrator FROM: Teah Malecha, Finance Director SUBJECT: Acknowledge Financial Review for the Quarter Ending June 30, 2020-Finance DATE: August 17, 2020 INTRODUCTION Staff reviews the financial performance of the General Fund and several other funds with the city council quarterly review.The financial statements are included in your packet and incorporate more detailed analytical comments.The following provides a more in depth review of the General Fund and highlights notable areas for the other funds included in this review. DISCUSSION General Fund The General Fund is the city's primary operating account. The financial summary for 2020 is the first attachment.The following will provide explanations for the various revenue items and highlight the more significant expenditure variations.The items reviewed are in the order they appear on the attached General Fund financial statement. Revenues For 2020, budgeted General Fund revenues total$12,334,782. During the first half of the year the city recorded General Fund revenues totaling$5,795,088 or 46.98 percent of total budgeted revenues. Property taxes represent the majority of total General Fund revenues (including transfers in from other funds). Property taxes are generally payable in two installments, May and October, and collected by the county.The city typically receives their portion in June and December. Property tax penalties were abated until July 15th due to COVI D-19. The city received payments in May and June for tax receipts received by the county through June 30th. While there are many reasons the city needs a fund balance(which is similar to an individual's personal net worth), needing to pay its bills between the receipt of tax payments from the county is the most significant reason.The other types of revenues that the city collects assist in maintaining that balance. The other types of revenues in the General Fund consist of licenses, permits, intergovernmental revenue, charge for services,fines, investment income,franchise fees, rental income, etc. Licensing includes liquor, beer and wine, massage, animal, etc.All first and second quarter licenses were received;although,there will be a reduction in the amount received in 2020. The city council approved waiving all liquor license fees for April and some for May for the businesses could not be open to sell alcohol due to COVI D-19. Permit revenue includes building, plumbing, heating, electric, etc. permits.The revenue for 2020 was trending higher than 2019.The city has issued 196 building permits in 2020 compared to 205 in 2019. Plumbing, heating, and electric permits are up at 287 in 2020 versus 252 in 2019. Overall, permits were trending higher in 2020 than in 2019. Intergovernmental revenue includes local government aid (LGA), municipal state aid (MSA) maintenance, police and fire aid, etc.The first half of MSA maintenance was received. The second half will be received in July. LGA is received in July and December. Police and fire aid are received in October. The city needs a strong fund balance as many of these items are paid later in the year. Charge for services includes:fire, recreation, school resource officer(SRO), etc., charges. Castle Rock and Eureka townships are billed quarterly for fire protection. Empire,the largest of the three townships, is billed annually, after year-end, per contract. This amount is typically received in April of the following year. Non-contract(i.e. illegal and/or hazardous)fires charges are billed as they occur. Recreation programs are primarily offered in the summer.The school is billed for their share of the school resource officer's human resource costs on a quarterly basis. Recreation revenue is trending lower due to COVI D-19. Fine revenue is received the following month. The revenue for 2020 is trending lower than 2019. 1 nvestment interest consists of investment earnings and the city's annual mark-to-market to recognize the change in the market value of its investment portfolio. The market rates have dropped dramatically over the past few months in part due to COV I D-19.Therefore, interest income is trending lower in 2020 than in 2019. It is anticipated to trend lower overall as the city reinvests funds. Miscellaneous revenues include rental income related to the Rambling River Center(RRC-senior center) and city hall and also donations. Franchise fee revenue in the General Fund represents the transfer of a portion of the city's franchise fee revenue to the General Fund to help pay for city operations.The remainder of the franchise fees are used to pay for the city's cable operations. Expenditures Finance tracks expenditures by department.The following notes explain significant or unusual variations from last year or actual versus budgeted amounts which vary a bit from the expected 50 percent(6 of 12 months)through the end of June in the same order as they appear on the attached General Fund financial report. The general election will be held in November resulting in higher costs for Elections. Non-election year costs consist of ongoing maintenance and training fees. The city is a part of a JPA for the Dakota Broadband Board (D BB). Annual costs include programming fees, access fees, and operational costs.The costs were allocated to the EDA in 2019 and have been moved to the General Fund for 2020. Police Administration, Patrol Services, and I nvestigations are viewed on a combined basis rather than individually. The three departments combined are at 48.62 percent of budget. Overall, General Fund expenditures, excluding transfers, are at 45.13 percent of budget for 2020. EDA, Park Improvement,and Arena The EDA (Economic Development Authority), Park Improvement Fund, and Ice Arena activities have historically been of interest to council.They are also included for your review. EDA The EDA revenues are interest income only.This accounts for the EDA's portion of the investment income received by the city. The DBB's Executive Director costs have been moved from the General Fund to the EDA for 2020.The expenses are invoiced quarterly and reimbursed to the city through an employee interchange agreement. Park Improvement Fund The Park I mprovement fund revenue is interest income and farm lease payments.The Westview area basketball court was resurfaced in second quarter. Arena The ice arena was closed March 16th to June 14th due to COVI D-19 resulting in lower than anticipated revenues. Liquor Operations The city has two financial benchmarks for its liquor operations. The first is a 25 percent gross profit margin. The second standard is a 6 percent profit as a percent of sales.This is evaluated on a combined basis. The liquor stores were closed on March 18th due to COVI D-19. Both stores have since reopened, but are operating on limited hours. Due to the closures and reduction of inventory,the gross profit margin and profit as a percent of sales numbers are not an accurate depiction of the stores for the first half of the year. After each calendar year, staff reviews the financial results for the two liquor stores combined, determines the amount of funds needed to cover day-to-day operations and administrative transfers to the General Fund.The remaining funds are divided evenly and transferred into the Community Investment and Capital Improvements accounts. This is referred to as the four pots philosophy. Each year staff utilizes actual financial results to fund these four pots. Staff periodically makes recommendations to council on how to best invest available dollars in the Community I nvestment pot to benefit the community. Meanwhile,the capital improvement dollars are available for future liquor store capital building needs (e.g. remodeling, updating, relocation, possible building, etc.). Enterprise Funds The city operates five utility funds:sanitary sewer, solid waste,storm water,water, and street lighting.The rates were increased on solid waste and water for 2020. Sanitary Sewer There was an increase in MCES (Metropolitan Council Environmental Services)fees in 2020.These are the fees charged to the city to treat its sewer water.The fees reflect an increase in the cost to treat the volumes processed. Solid Waste Expenditures are trending higher due to the increase in recycling costs and tipping fees.The city was temporarily bringing solid waste to a landfill in 2019. It has since been moved to Red Wing for processing.The city is also seeing an increase in costs due to COVI D-19 and increased disposal from households. Storm Water Revenues are trending similarly to 2019 with a reduction in expenses. Water Revenues are trending higher in 2020 due to a rate increase.There is also a large increase in water availability charges with the receipt of development payments.The expenditures were higher in 2019 due to the construction for Well 9 and the water tower refurbishment. For all of the city's utility funds,the billing cycle(revenue) lags the recording of expenses. For example, the city bills every three months.The January billing includes November and December of the previous year, as well as January of the current year. So, two-thirds of that billing cycle is attributable to the prior year and is recorded as such in the financial statements.This means that at the end of this year,the financial statements will remain open so that we can capture the revenues related to the current year, which will not be billed out until January and February of the following year. Additional comments,which may be of interest to you, including those for street light funds are contained in the comment section of the attached financial statements. BUDGET IMPACT The budget impacts have been noted above as appropriate. ACTION REQUESTED Review and acknowledge the financial reports for quarter ended June 30, 2020 ATTACHMENTS: Type Description ❑ Backup Material General Fund YTD Ended June 30, 2020 ❑ Backup Material General Fund Chart YTD Ended June 30, 2020 ❑ Backup Material Special Revenue Funds YTD Ended June 30, 2020 ❑ Backup Material Liquor Fund YTD Ended June 30, 2020 ❑ Backup Material Utility Funds YTD Ended June 30, 2020 General Fund 2nd Quarter 2020 YTD Operating Report Quarter Quarter Quarter June YTD Quarter 2 Actual Quarter Company Actual 2019 Actual Actual Actual Actual Budget 2020 Budget Variance Act as%of Comments 2019 2020 2020 2020 2020 Bud 2020 Revenues._..,._._. Property Taxes 9,716,274 5,080,238 0 5,246,168 5,246,168.. 10,231,191 (4,985,023) 51.28% Property taxes received in June and December.Received property taxes from county for receipts through June 30th.Penalties abated through July 15th. Licenses 48,452 8,665 23,065 1,841 24,906 50,080 (25,174) 49.73% Includes liquor,beer&wine,dub arcade,massage,gambling,animal,etc.1st& 2nd quarter liquor licenses received.City waived liquor licensing fees for April and May due to COVID 19. Permits 373,126 102,691 86,115. 105,448 191,563 423,035 (231,472) 45.28% Includes building,plumbing and heating,electric,etc.permits.1st quarter 2019: building permits 205,plumbing 51,heating 69,fire 6,electric 132.1st quarter 2020: building permits 196,plumbing 62,heating 66,fire 5,electric 159. Intergovernmental Revenue 1,085,064 88,772 84,629 520 85,149 922,294 (837,145). 9.23% Includes Local Government Aid(LGA),Municipal State Aid(MSA)Maintenance, Police and Fire Aid,etc.Received MSA road maintenance.A portion of 2020 coded to road maintenance account.Fire training reimbursement received in 2019. Charge for Service 502,901 91,118 62,442 52,123 114,565 445,802 (331,237) 25.70% Includes fire,recreation,school resource officer,etc.charges.Castle Rock and Eureka are billed quarterly for fire charges/contract.Empire,largest amount, billed annually,after year-end/contract.Non-contract(i.e.illegal,hazardous) fire charges are billed as they occurred.School resource officer is billed quarterly.Recreation programs are primarily held in the summer.Recreation and RRC decreased due to COVID 19. Pines 63,561 15,163 12,935 9,529 22,464 49,000 (26,536) 45.84% Fine revenue received a month late,e.g.January received in February. Investment Interest 142,074 12,340 19,868 17,115 36,984 38,800 (1,816) 95.32% Intestment earnings attributable to General Fund's proportionate share of investment balances. Miscellaneous 53,125 13,997 14,936 4,413 19,349. 54,580 (35,231) 35.45% Includes Sr Center and City Hall rental income,and donations. Franchise Fees 120,000 57,229 0 53,941 53,941 120,000 (66,059) 44.95%A portion of the city's franchise fee is used to pay for the city's General Fund operations.The remainder is used to pay for the city's cable operation. Subtotal Revenues 12,104,578 5,470,213. 303,990 5,491,098 5,795,088 12,334,782 (6,539,694) 46.98% Expenditures _. Legislative 77,604 16,036 13,947 15,824 29,771 87,772 (58,001) 33.92% Administration 278,967 69,157 66,451 61,715 128,166 302,068 (173,902) 42.43% Elections 9,207 23 11,782 4,607 16,389 44,124 (27,735) 37.14% Provision for annual election equipment maintenance fee and ongoing training. Presidential primary in March. Communications 106,028 26,381 26,467 27,308 53,776 108,537 (54,761) 49.55% City Halt 306,692 67,443 86,316 78,210 164,526 364,661 (200,135) 45.12% Includes annual subscription for building automation system and roof repair. Dakota Broadband 8,813 4,154 11,326 7,326 18,652 24,489 (5,837) 76.16% Executive Director costs moved to EDA.Includes DEB programming fee,access fee,and operational costs. Finance and Risk Mgmt 696,283 198,705 184,333 193,835 378,168778,889 . (400,721) 48.55% Human Resource 355,103 110,519 74,966 73,307 148,273 349,226 (200,953) 42.46%2019 included costs for staff retirement and contract staff. Police Administration 950,880 239,315 309,055 260,292 569,346 1,235,377 (666,031) 46.09%On a combined basis Police Admin,Patrol,and Investigations are 48.62%. Patrol Services 2,610,315 653,928 625,144 625,631 1,250,776 2,538,727 (1,287,951) 49.27%On a combined basis Police Admin,Patrol,and Investigations are 48.62%. Investigations 851,206 214,460 228,557 219,999 448,556 892,059 (443,503) 50.28% On a combined basis Police Admin,Patrol,and Investigations are 48.62%. Emergency Management 2,802 (11) 54 1,661 1,715 11,650 (9,935) 14.72% Includes 55-gallon drum hand sanitizer. Fire 1,318,556 244,160 242,490 223,048 465,538 1,445,410 (979,872) 32.21% Engineering 636,954 167,783 158,390 163,263 321,653 665,173 (343,520) 48.36% Planning 481,590 141,696 122,242 162,587 284,829. 591,133 (306,304) 48.18% New staff hired in mid-2019. Building Inspection 412,357 105,384 111,824 104,416 216,240 423,734 (207,494) 51.03%_ Natural Resources 89,201 30,707 5,184 7,306 12,490' 129,462 (116,972) 9.65% Position is vacant. Streets 1,145,647 284,565 279,301 307,496 586,797 1,197,200 (610,403) 49.01% New staff hired in mid-2019. Snow Removal 321,275 30,680 74,752 11,178 85,930 241,878 (155,948) 35.53% Park Maintenance 671,976 182,676 144,275 185,491 329,766 700,111 (370,345) 47.10% Majority of the maintenance costs are during the spring and summer. Rambling River Center 165,878 40,392 43,665 37,415 81,081 190,822 (109,741) 42.49% Park&Rec Admin 269,159 69,685 64,790 66,968 131,758 287,925 (156,167) 45.76% Recreation Programs 102,394 33,763 7,318 4,972 12,290.. 99,718 (87,428) 12.33% Majority of the programming is in the summer.There will be a reduction due to COVID-19. Interest Paid 0... 0. 0 0. 0 0 0 _.. Bad Debt Expense 50 ...0. 0 0 0 0 Other Expense 49,447 0 0 0 0 0 Subtotal Expenditures 11,918,385 2,931,602 2,892,630 2,843,855 5,736,485 12,710,145 (6,973,660) 45.13% Revenues(Over)Under Expenditure 186,193 2,538,611 (2,588,639) 2,647,243 58,603. (375,363) 433,966 -15.61% Other Financing _ Transfers In 1,244,256 311,064 326,892 326,892 653,785 1,307,570 (653,785) 50.00% Transfers Out (1,281,138) (385,285) (233,052) (233,052) (466,103), (932,207) 466,104 50.00% Subtotal Other Financing (36,882) (74,221) 93,841 93,841 187,682 375,363 (187,682) 50.00% Net Change in Fund Balance 149,311 2,464,391 (2,494,799) 2,741,083' 246,285. 0 246,285 City of Farmington General Fund Fund Balance $7,500,000 -- $7,000,000 $6,500,000 V $6,000,000 41 if M $5,500,000 - $5,000,000 -- m _ $4,500,000 - $4,000,000 $3,500,000LL — $3,000,000 -- — -- -- $2,500,000 - — — -- $2,000,000 - - - - - $1,500,000 — V $1,000,000 - 4 $500,000 — — Jan Feb Mar Apr May June July Aug Sept Oct Nov Dec 2016 20'.7 20'.8 2019 2020 —40%of Prelim.2020 Exp t50%of Prelim.20206p t40%of Prelim.2021 Esp �4-50%of Prelim.2021 Exp EDA, Park Improvement,Arena 2nd Quarter 2020 YTD Operating Report Quarter 2 Quarter 1 Quarter 2 June YTD Quarter 2 Actual Quarter 2 YTD Company Actual 2019 Actual Actual Actual Actual Budget 2020 Budget Variance Act as%of Bud Comment 2019 2020 2020 2020 2020 2020 ,. r » .,+„ .... ..., .+ r •:�".�.,'i� a ,..... t',..a ��"...,... r "Al r_„.. , .,.,. :EE ,.. „-. . ..,r.., , ,m r..,.r t.`. .Le ,,,.:,h... ..,... we .,s ,#., a`,.: {,, ..x,. + , ..... 4 r 4 ...e.. .. ,... ." .. 3 _..,.s: »a»+ f .+ s ry „ » .r..,r a-..y. u+ Y".. ... ..,r k.... ,.:."n, ,o-#' ,.+..x .,. ,_ , ,._.,., k„ ,-,ua , ....., .. -. », ..,. h.,. �,... ��.. % ,.......o- zk'. ,. ,.. o-..... .. ... ,...... d s.x+. _. ! .,. ..., .,>r ... ws:.. ., _.. _ a. ........ {x#, x„ �k,... ,k.= ,:,7�^~•.`....... . _.,., �-.a ,. .�:. ,±�' �,.. _.. ..,. +- '�?. rvr. ,...tt. _�.,..."# ...,..*,,,au:,vn�... e: v,:»,. .�.....+ a=ar<.............a..;wr„S �.,. +7.,..a y.r_, .�`"s'.,.ra= ,r, rn,..�,..., Mv.,..._....9,,..�„ ,...... ... ...,@ .,r*.._..,. ,. .,,, ..., ,."w*r..;;ti r,,.... x ,., EDA Revenues 10,434 1,706 1,562 1,082' 2,644 2,700' (56)'' 97.91%Interest income Dakota Broadband 65,398 0 35,419 43,539 78,959 162,911 (83,952) 48.47%,Reimbursement for DBB Executive Director expenses per Reimbursement agreement with DBB Board. EDA Expenses 64,872 8,637 12,137 14,662 26,800 38,730 (11,930) 69.20%,DBB costs were included in 2019. DBB Human Resource 65,398 0 34,761 43,379 78,140' 162,911 (84,771) 47.96% Wage and benefit expenses for DBB Executive Director. Expense Invoiced quarterly. Dakota Broadband 659 160 819 819 Expensed for DBB Executive Director.Invoiced quarterly. Expense EDA Net (54,438)' (6,931) (10,575) (13,581)' (24,156) (36,030) 11,874 67.04% Revenues/Expenditures Transfers In 50,000 12,500 10,000 10,000 20,000' 40,000 (20,000) 50.00% Transfers Out (2,850) (713) 0 0 0 0 0 Subtotal Other Financing 47,150 11,787 10,000 10,000 20,000 40,000 (20,000) 50.00% Net Change in EDA Fund (7,288) 4,857 (575) (3,581) (4,156) 3,970 (8,126) -104.69% Balance _,. MPS �.. �. ,u. Park Improvement 83,588 61,822 1,669 9,608 11,276 36,745 (25,469)' 30.69% Includes lease payments and interest. Revenues Park Improvement 328,100 138,859 1,716 5,487 7,203 39,000 (31,797) 18.47% Westview basketball court resurfacing. Expenditures Park Improvement Net (244,512) (77,037) (47) 4,120 4,073' (2,255) 6,328 -180.62% Change in Fund Balance ,.✓•�'"., ......,+ ...,a:4, ,r ",S".r.,.. Ya,.y,. . .... ,....✓., �.. w ::.., f , .5.. ,:: s#r..n'.; mrr:: a ,s .....;,5 .,.rtt , rr f .r ,..-,.. x MXe"a k+X a.... »" r.v�. xr 5..w... .x•^'µ::: ,,. .' ,sX u-:' t>..� ,::.. t_ =:s .,..r.::ro- 5....„isr .2..... .} , wx! ., r� „�.� .. ...» ,,,amu. .. .... .... .. Ice Arena Revenues 366,852' 9,014 133,016 12,706' 145,723 367,700 (221,977) 39.63%'Ice arena was closed March 16-June 14 due to COVID-19. Ice Arena Expenditures 380,836 63,755 114,009 63,591 177,600 368,200 (190,600) 48.23% Ice Arena-Rev Over (13,985) (54,740) 19,008 (50,885) (31,877)' (500) (31,377)' 6,375.42% (Under)Expenditures Ice Arena-Transfers In 0 0 0 0 0 0 0' Ice Arena-Transfers Out 0 0 0 0 0 0 0 Ice Arena Net Transfers 0 0 0 0 0' 0 0 Ice Arena Net Change in (13,985) (54,740) 19,008 (50,885) (31,877) (500) (31,377), 6,375.42% Fund Balance Liquor Stores Statement of Revenue & Expenses 2nd Quarter 2020 Quarter 1 Quarter 2 June YTD Quarter 1 Quarter 2 June YTD Quarter 2 Actual Quarter 2 Company Actual 2016 Actual 2017 Actual 2018 Actual 2019 Actual Actual Actual Actual Actual Actual Budget 2020 Budget Variance ACTBUDGET% Comment 2019 2019 2019 2020 2020 2020 2020 2020 Revenues-Downtown .� Total Revenue-Downtown 2,222,128 2,315,459, 2,454,807 2,626,193 554,873 677,001 1,231,874 494,279 149,724, 644,003 2,348,258 (1,704,255) 27.42% Downtown store's sales have declined $587k from 2019.The store is operating on limited hours due to COVID-19. Cost of Goods Sold-Downtown Cost of Goods Sold 1,659,631 1,728,0591,840,890, 1,940,136 413,682 500,485 914,166 367,837 126,462 494,299 1,667,418 (1,173,119) 29.64% Decrease in COGS due to temporary closing and decline in sales. Gross Profit-Downtown._ .... _. _.. _. _ _.. _... _... __. ..... _ _.. .... _._ _ _... _... Gross Profit 562,497 587,400 623,917' 686,057. 141,191 176,516 317,707 126,442 23,262 149,704 680,840 (531,136) 21.99% Gross Profit%-Downtown 25.3%' 25.4% 25;3°/0 26.1%, 25.4% 26.1% 25.8%, 25.6% 15.5%: 23.2% 29.0% (5.7)%; 80.2%.25%benchmark. Expenses-Downtown _.... .. _.. __. .... ... ._... ..._ ___ ___.. _. ...... _.... ..... Advertising 5,198 4,327 3,872 1,954 125' 580 705 242 0' 242 5,500' (5,258)' 4.41% Total Expenses-Downtown 475,533. 488,195 514,184 581,961. 129,044 141,966 271,010 141,442: 98,861 240,302 577,425. (337,123) 41.62% Revenues(Losses)Before Transfer Revenue(Loss)B4Trans-Downtown 86,964, 99,205: 109,733 104,096: 12,1471 34,550. 46,897+ (14,999)', (75,599); (90,598)1, 103,415 (194,013): -87.61%: Revenues-Pilot Knob. ,.. Total Revenues-Pilot Knob 2,529,076 2,663,162 2,807,608 3,022,065 621,193 777,885 1,399,078 657,894 1,073,427 1,731,321 2,706,462 (975,141) 63.97% PK store's sales are$332K higher than year ago.The store is operating on limited hours due to COVID-19. Cost of Goods Sold-Pilot Knob Cost of Goods Sold-Pilot Knob 1,878,227 1,979,304 2,083,078 2,243,479 458,776 582,355 1,041,132 483,419 797,802 1,281,221 1,850,260 (569,039) 69.25% Increase in COGS due to increase in sales. Gross Profit-Pilot Knob Gross Profit-PK 650,849 683,859 724,530 778,586 162,417 195,530 357,947 174,475 275,625 450,100 856,202. (406,102) 52.57% Gross Profit%-PK 25.7%' 25.7%: 25.8% 25.8% 26.1% 25.1% 25.6%` 26.5%. 25.7% 26.0% 31.6% 5.6%' 82.2% 25%benchmark. Expenses-Pilot Knob Advertising 5,198 4,282 3,632 1,959! 130 580 710 238 5 243 4,250 (4,007) 5.71% Total Expenses-Pilot Knob 435,498 438,925' 450,597 486,868 112,544 126,636 239,179.. 108,380 119,848 228,228 519,357 (291,129). 43.94% Revenues(Losses)B4 Transfer _.. Revenues(Losses)84Trans-Pilot Knob 215,351 244,934, 273,933 291,718' 49,873; 68,894! 118,768' 66,094; 155,777! 221,872!; 336,845', (114,974) 65.87%' Combined Inc(Loss)Before Transfers Combined Inc(Loss)B4 Transfers 302,315 344,139 383,666' 395,814 62,020 103,444 165,464 51,095 8D,178 131,273 440,26D (308,987) 29.82% Profit(Loss)As A%of Sales 6.4% 6.9% 7.3% 7.0%, 5.3%j 7.1%I 6.3%% 4.4%'; 6.6% 5.5%i 8.7%I (3.2)%, 63.5%,The goal is 6%. Operating Transfers Operating Transfers-Out 204,113' 248,592 194,377. 134,088. 33,522 33,522' 67,044 34,113 34,113 68,226: 136,452 (68,226). 50.00%: Sewer,Solid Waste,Storm Water,Water&Street Lights 2nd Quarter 2020 YTD Operating Report Quarter 2 Quarter 1 Quarter 2 June YTD Quarter 2 YTD Quarter 2 Company Actual 2019 Actual Actual Actual Actual Budget 2020 Actual Budget YTD Act as% Comment 2019 2020 2020 2020 Variance 2020 of Bud,2020 Revenues(Sewer) 2,204,045 527,173 428,082' 525,374' 953,457 2,326,614 (1,373,157)' 40.98% Expenses-(Sewer) 2,312,354 375,813 436,793 433,722 870,515 2,573,895 (1,703,380) 33.82% MCES(Metropolitan Council Environmental Services)fees are higher in 2020. Revenues Over Expenses(Sewer) (108,309)' 151,361 (8,710) 91,652 82,942 (247,281) 330,223 -33.54% Transfers In(Sewer) 11,149 0 0 0 0 0, Transfers Out(Sewer) 986,029 77,589 81,886' 81,886 163,772 327,545 (163,773) 50.00% See detailed transfers worksheet. Net Change in Fund Balance(Sewer) (1,083,188) 73,772 (90,597) 9,766' (80,831) (574,826) 493,995 14.06% 43 ;t, .g :. 'S€`- �` .-sx -. Sr ^s,'^§ +.#� a .; „:s�..+v s :� r+ *g* r f . z .. k n .. ., TATEmak ` Revenues(Solid Waste) 2,344,704 578,978 490,222 679,131 1,169,353 2,449,853 (1,280,500) 47.73% Rate increase in 2020. Expenses-(Solid Waste) 1,941,259 567,659 598,572 673,217 1,271,789 2,312,989 (1,041,200)' 54.98% Increase in recycling costs and tipping fees. Revenues Over Expenses(Solid Waste) 403,445' 11,319 (108,350) 5,914 (102,435) 136,864 (239,299) -74.84% Transfers In(Solid Waste) 86,244' 17,380 17,550 17,550 35,100 70,201 (35,101) 50.00% Transfers Out(Solid Waste) 145,314 36,329 36,970 36,970 73,940 147,879 (73,940) 50.00%;See detailed transfers worksheet. Net Change in Fund Balance(Solid Waste) 344,374 (7,629) (127,769) (13,505) (141,274) 59,186 (200,460) -238.70% ,.� `"�''. z Revenues(Storm Water) 1,171,372 295,928 244,507 293,086 537,593 1,242,633 (705,040), 43.26% Expenses-(Storm Water) 553,625 34,876 24,234 17,546 41,780 1,036,854 (995,074) 4.03% Revenues Over Expenses(Storm Water) 617,747' 261,053 220,273 275,540 495,813 205,779 290,034, 240.94% Transfers In(Storm Water) 5,575 0 0 0 0 0 Transfers Out 713,387 96,442 99,038 99,038 198,076 396,152 (198,076) 50.00% See detailed transfers worksheet. Net Change in Fund Balance(Storm Water (90,065) 164,611 121,235 176,502 297,737 (190,373) 488,110 -156.40% Revenues(Water) Water Availability Charges 47,690 17,570 33,698 82,123' 115,821 81,575 34,246' 141.98% Correlates to building permit activity. Net Interest Income 303,877 55,304 41,617 32,464 74,081 78,500' (4,419) 94.37%' Rental Income 241,777' 56,194 127,092 55,441 182,533 236,000 (53,467) 77.34%,Reflects wireless companies(ex.Sprint,ATT,Verizon)rental of space on the city's water towers. Enterprise Sales 1,584,456 332,214 232,814 375,577 608,392 2,011,619 (1,403,227) 30.24%° Rate increase in 2020. All Other Revenues 411,193' 391,965 8,107 11,277 19,384 0 19,384 2019 included development fees. Total Revenues 2,588,993 853,248 443,328 556,882 1,000,210 2,407,694 (1,407,484) 41.54% Expenses-(Water) 1,426,000 2,082,550 130,387 138,554 268,941 7,246,319 (6,977,378) 3.71%:2019 includes water tower refurb and well 9 costs. Revenues Over Expenses(Water) 1,162,993 (1,229,303) 312,941 418,328 731,269 (4,838,625) 5,569,894 -15.11% Transfers In(Water) 11,149' 800,000 0 0 0 0 0 Transfers Out(Water) 1,105,506 104,840 217,630 112,713 330,343 540,245 (209,902) 61.15% See detailed transfers worksheet. Net Change in Fund Balance(Water) 68,636 (534,143) 95,311 305,615 400,926 (5,378,870) 5,779,796 -7.45% mom I Revenues(Streetlight) 233,437 57,319' 42,114 57,498 99,613 224,900 (125,287) 44.29% Expenses 165,887 39,877 37,186 51,091 88,277 221,500 (133,223) 39.85% Revenues Over Expenses(Street Light) 67,550' 17,441 4,929 6,407 11,335 3,400 7,935 333.40%', CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-280-6800 Farmington MN.gov TO: Mayor, Councilmembers and City Administrator FROM: Teah Malecha, Finance Director SUBJECT: Approve Bills-Finance DATE: August 17, 2020 INTRODUCTION Attached is the July 27 2020-August 11, 2020 city council check register and recently processed automatic payments for your consideration. DISCUSSION ONA BUDGET IMPACT NA ACTION REQUESTED Approve the attached payments. ATTACHMENTS: Type Description D Backup Material Check Register 7/27/20-8/11/20 R55CKS2 LOGIS600VCOUNCIL MEETING AUGUST 17, 2020 CITY OF FARMINGTON 8/12/2020 9:05:21 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 1 7/1/2020 - 8/11/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 152026 7/31/2020 100708 AMERICAN PLANNING ASSOCIATION 372.00 2020APA MEMBER DUES:WIPPLER 186377 210888-2045 1030 6460 MEMBER DUES&LICENSURE PLANNING&ZONING 01000 03 372.00 152027 7/31/2020 110959 ANCONA TITLE&ESCROW 66.68 REF UTIL@4535 198TH ST W 186370 2020-174819 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 66.68 152028 7/31/2020 113303 ARTISAN BEER COMPANY 666.50 BEER ORDER 186399 3428314 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 666.50 152029 7/31/2020 108446 ASPEN MILLS,INC. 106.22 UNIFORM ITEMS:ELVESTAD,J 186051 258803 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 108.22 152030 7/31/2020 115249 BEARD,SHELLY 20.00 2020 NOTARY REG S.BEARD 166373 071420-BEARD 1021 6460 MEMBER DUES&LICENSURE GENERAL ACCOUNTING 01000 02 58.91 PRINTER INK WFH COVID 186373 071420-BEARD 1021 6220 EQUIP SUPPLIES&PARTS GENERAL ACCOUNTING 01000 02 78.91 152031 7/31/2020 100493 BELLBOY CORPORATION 124.02 LIQUOR SUPPLIES&MIXES ORDER 186354 101683600 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 171.10 LIQUOR SUPPLIES&MIXES ORDER 186355 0084930100 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 345.02 LIQUOR SUPPLIES&MIXES ORDER 186405 0101724200 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 640.14 152032 7/31/2020 115569 BOURGET IMPORTS,LLC 173.25 WINE ORDER 186346 171483 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 173.25 152033 7/31/2020 114472 BREAKTHRU BEVERAGE MN BEER,LLC 13,163.70 BEER ORDER 186356 1091151277 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 4,022.00 BEER ORDER 186365 1091153463 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 12,618.35 BEER ORDER 166409 1091153464 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 29,804.05 152034 7/31/2020 114471 BREAKTHRU BEVERAGE MN WINE&SPIRITS 449.12 LIQUOR&SPIRITS ORDER 186357 1081155617 6100 1405 15 INVENTORY PILOT KNOB LIQUOR OPERATIONS 06100 02 65.45 WINE ORDER 166362 1081158377 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 2,147.54 LIQUOR&SPIRITS ORDER 186364 1081158376 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 3,819.66 LIQUOR&SPIRITS ORDER 186407 1081158378 6100 1405 15 INVENTORY PILOT KNOB LIQUOR OPERATIONS 06100 02 487.25 WINE ORDER 186408 1081158379 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 6,969.04 152035 7/31/2020 110218 BURNET TITLE 63.09 REF UTIL CR@609 PARK DR 186372 2124020-06491 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 R55CKS2 LOGIS600V CITY OF FARMINGTON 8/12/2020 9:05:21 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 2 7/1/2020 - 8/11/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 63.09 152036 7/31/2020 111050 CASTLE ROCK KENNELS INC 140.00 ANIMAL CONTROL BOARDING FEES 186071 27702 1050 6401 PROFESSIONAL SERVICES POLICE ADMINISTRATION 01000 05 140.00 152037 7/31/2020 100071 COLLEGE CITY BEVERAGE INC 6.12- BEER ORDER CREDIT 186391 729-02110 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 6,590.65 BEER ORDER 186392 729-02109 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 16.80- BEER ORDER CREDIT 186394 729-02105 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 8,530.05 BEER ORDER 186396 729-02104 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 15,097.78 152038 7/31/2020 100133 DAKOTA COUNTY FINANCIAL SRVS 1,026.52 JUN'20 RADIO SUBSCRIBER FEES 186207 00038614 1050 6560 CONTRACTUAL SERVICES POLICE ADMINISTRATION 01000 05 1,423.13 JUN-20 RADIO SUBSCRIBER FEES 186207 00038614 1060 6560 CONTRACTUAL SERVICES FIRE SERVICES 01000 06 2,449.65 152039 7/31/2020 100149 ECM PUBLISHERS,INC 34.00 PC PUBLIC HEARING:VDOVENKO 186209 783587 1030 6455 LEGAL NOTICES PLANNING&ZONING 01000 03 29.75 PC PUBLIC HEARING:BARKE 166210 783586 1030 6455 LEGAL NOTICES PLANNING&ZONING 01000 03 63.75 152040 7/31/2020 113296 EDINA REALTY TITLE 197.11 REF UTIL CR@19878 DENALI WAY 186366 1547434/61 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 197.11 152041 7/31/2020 115414 EXECUTIVE TITLE SERVICE,INC 64.40 REF UTIL CR@5305 ORIOLE DR 186369 14200/60 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 64.40 152042 7/31/2020 109931 FACTORY MOTOR PARTS 87.88 BATTERIES FOR 4783 186020 1-Z22284 1060 6230 VEHICLE SUPPLIES&PARTS FIRE SERVICES 01000 06 445.00 BATTERIES FOR 3211 186020 1-Z22284 6302 6230 VEHICLE SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 28.63- 186020 1-Z22284 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 24.42 9 VOLT BATTERIES 186021 1-Z22285 7200 6220 EQUIP SUPPLIES&PARTS FLEET OPERATIONS 07200 08 28.42 STOCK FILTERS 186039 1-6456115 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 557.09 152043 7/31/2020 100027 GREAT LAKES COCA-COLA DISTRIBUTION,LLC 470.96 POP ORDER 186390 3608210595 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 470.96 152044 7/31/2020 107123 GS DIRECT INC 29.37 PLOTTER INK 186386 357435 6302 6220 EQUIP SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 27.49 PLOTTER INK 186386 357435 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 1.89- 186386 357435 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 R55CKS2 LOGIS600V CITY OF FARMINGTON 8/12/2020 9:05:21 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 3 7/1/2020 - 8/11/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept Div 27.48 PLOTTER INK 186386 357435 1095 6220 EQUIP SUPPLIES&PARTS RECREATION PROGRAM SERVIC 01000 09 27.49 PLOTTER INK 186386 357435 6402 6220 EQUIP SUPPLIES&PARTS STORM WATER UTILITY OPERA 06400 08 27.48 PLOTTER INK 186386 357435 6202 6220 EQUIP SUPPLIES&PARTS SEWER OPERATIONS EXPENSE 06200 08 27.49 PLOTTER INK 186386 357435 1070 6220 EQUIP SUPPLIES&PARTS ENGINEERING SERVICES 01000 07 27.48 PLOTTER INK 186386 357435 1030 6220 EQUIP SUPPLIES&PARTS PLANNING&ZONING 01000 03 192.39 152045 7/31/2020 100074 HOHENSTEINS INC 823.80 BEER ORDER 186398 210396 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 823.80 152046 7/31/2020 117341 INBOUND BREWCO 402.66 BEER ORDER 186403 7637 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 402.66 152047 7/31/2020 113417 INDEED BREWING COMPANY,LLC 234.60 BEER ORDER 186353 91762 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 234.60 152048 7/31/2020 117717 INNOVATIVE GRAPHICS 772.00 YOUTH REC PROGRAM SHIRTS 185991 49414 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 772.00 152049 7/31/2020 111773 INNOVATIVE OFFICE SOLUTIONS,LLC 17.30 NOTARY STAMP 185968 IN3023187 1010 6210 OFFICE SUPPLIES ADMINISTRATION 01000 01 24.15 INSTRUCTION PAPER 185969 IN3025474 1013 6210 OFFICE SUPPLIES ELECTIONS 01000 01 16.13 HIGHLIGHTERS 185969 IN3025474 1010 6210 OFFICE SUPPLIES ADMINISTRATION 01000 01 75.80 DYMO LABELS 185969 IN3025474 1013 6210 OFFICE SUPPLIES ELECTIONS 01000 01 6.24 HIGHLIGHTERS 185970 IN3025476 1010 6210 OFFICE SUPPLIES ADMINISTRATION 01000 01 5.15 HIGHLIGHTERS 185971 IN3025477 1010 6210 OFFICE SUPPLIES ADMINISTRATION 01000 01 144.77 152050 7/31/2020 109846 JJ TAYLOR DISTRIBUTING COMPANY OF MN INC 5,657.45 BEER ORDER 186401 3108436 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 57.90- BEER ORDER CREDIT 186412 3074890 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 5,599.55 152051 7/31/2020 100033 JOHNSON BROTHERS LIQUOR COMPANY 768.05 LIQUOR&SPIRITS ORDER 186326 1601838 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 134.76 LIQUOR&SPIRITS ORDER 186327 1601834 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 399.48 WINE ORDER 186328 1601839 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 27.00 KINKY COCKTAILS ORDER 186329 1601837 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 25.51 MASTER MIXES MARGARITA ORDER 186333 1601836 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 395.12 WINE ORDER 186334 1601835 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 29.51 COCKTAIL ESNTL SIM SYRUP ORDER 186337 1596761 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 309.53 SVEDKA VODKA ORDER 186338 1596762 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 R55CKS2 LOGIS600V CITY OF FARMINGTON 8/12/2020 9:05:21 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 4 7/1/2020 - 8/11/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 242.54 LIQUOR&SPIRITS ORDER 186339 1596759 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 59.41 WINE ORDER 186340 1596763 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,255.28 WINE ORDER 186341 1596760 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 598.13 LIQUOR&SPIRITS ORDER 186342 1596765 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 25.60 KINKY COCKTAILS ORDER 186343 1596766 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 227.68 WINE ORDER 186344 1596767 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,326.03 LIQUOR&SPIRITS ORDER 186345 1596764 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 10.50- WINE ORDER CREDIT 186393 108102 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 708.61 TOWER VODKA ORDER 186414 1596619 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 459.97 BUTTERCREAM CHARDONNAY ORDER 186417 1581675 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 600.25 TOWER VODKA ORDER 186418 1581674 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 640.72 WINE ORDER 186420 1601738 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 33.51 AGALIMA MARGARITA ORDER 186421 1601735 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,003.77 LIQUOR&SPIRITS ORDER 186422 1601737 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 27.00 KINKY COCKTAILS ORDER 186423 1601736 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,094.37 WINE ORDER 186424 1601734 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 415.16 LIQUOR&SPIRITS ORDER 186425 1601733 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 768.44 WINE ORDER 186426 1601732 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,986.14 SVEDKA VODKA ORDER 186427 1601731 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,410.32 LIQUOR&SPIRITS ORDER 186428 1601730 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 15,961.39 152052 7/31/2020 117732 KLAVON,MARY 5.99 PARK SHELTER RENTAL REFUND 186389 PRK SHLTR RENTAL 1000 2415 MN SALES TAX DUE GENERAL FUND BALANCE SHEE 01000 REFUND 84.01 PARK SHELTER RENTAL REFUND 186389 PRK SHLTR RENTAL 1001 4975 RENTAL INCOME GENERAL FUND REVENUES 01000 01 REFUND 90.00 152053 7/31/2020 102456 KLM ENGINEERING INC 8,000.00 ANTENNA INSPECTIONS-T-MOBILE 186030 7834 6500 2256 01902 DEVELOPMENT ESCROWS WATER UTILITY 06500 08 8,000.00 ANTENNA INSPECTIONS-VERIZON 186031 7833 6500 2256 01902 DEVELOPMENT ESCROWS WATER UTILITY 06500 08 16,000.00 152054 7/31/2020 107747 M.AMUNDSON LLP 978.80 CIGARETTES&POP ORDER 186413 304909 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 978.80 152055 7/31/2020 117708 M/I HOMES 225.00 VOID BLDG PRMT46095 186381 VOID BLDG PRMT 1001 4612 EROSION&SEDIMENT CONTROL GENERAL FUND REVENUES 01000 01 46095 2,145.15 VOID BLDG PRMT46095 186381 VOID BLDG PRMT 1001 4305 BUILDING PERMITS GENERAL FUND REVENUES 01000 01 46095 2,407.00 VOID BLDG PRMT46095 186381 VOID BLDG PRMT 6501 4640 WATER AVAILABILITY CHARGE WATER UTILITY REVENUES 06500 08 R55CKS2 LOGIS600V CITY OF FARMINGTON 8/12/2020 9:05:21 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 5 7/1/2020 - 8/11/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 46095 555.00 VOID BLDG PRMT 46095 186381 VOID BLDG PRMT 3900 4625 SANITARY SEWER TRUNK FEE SANITARY SEWER TRUNK 03900 07 46095 3,000.00 VOID BLDG PRMT 46095 166381 VOID BLDG PRMT 4600 2255 DEPOSITS PAYABLE PRIVATE CAPITAL PROJECTS 04600 07 46095 65.00 VOID BLDG PRMT 46095 186381 VOID BLDG PRMT 1001 4315 PLUMBING&HEATING PERMITS GENERAL FUND REVENUES 01000 01 46095 27.43 VOID BLDG PRMT 46095 186381 VOID BLDG PRMT 6500 2415 MN SALES TAX DUE WATER UTILITY 06500 08 46095 697.17 VOID BLDG PRMT 46095 186381 VOID BLDG PRMT 1001 4305 BUILDING PERMITS GENERAL FUND REVENUES 01000 01 46095 170.00 VOID BLDG PRMT 46095 186381 VOID BLDG PRMT 1001 4315 PLUMBING&HEATING PERMITS GENERAL FUND REVENUES 01000 01 46095 3.00 VOID BLDG PRMT 46095 186381 VOID BLDG PRMT 1000 2420 BUILDING PERMIT SURCHARGE GENERAL FUND BALANCE SHEE 01000 46095 2,485.00 VOID BLDG PRMT 46095 186381 VOID BLDG PRMT 6200 2425 MCES SAC(SWR AVAIL CHG) SEWER OPERATIONS 06200 08 46095 75.00 VOID BLDG PRMT 46095 166381 VOID BLDG PRMT 6201 4325 SEWER PERMITS SEWER OPERATIONS REVENUE 06200 08 46095 75.00 VOID BLDG PRMT 46095 186381 VOID BLDG PRMT 6501 4320 WATER PERMITS WATER UTILITY REVENUES 06500 08 46095 385.00 VOID BLDG PRMT 46095 186381 VOID BLDG PRMT 6501 4510 CUSTOMER SERVICE TAXABLE WATER UTILITY REVENUES 06500 08 46095 12,314.75 152056 7/31/2020 113442 METERING&TECHNOLOGY SOLUTIONS 225.92 ORION MODULE 186017 17325 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 225.92 152057 7/31/2020 108780 MINNESOTA AG GROUP INC 470.54 PTO CLUTCH FOR 0939 186022 IN83244 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 470.54 152058 7/31/2020 101313 MN DEPT OF LABOR&INDUSTRY 20.00 PERSSURE VESSEL PERMIT 166191 ABR0235227X 1015 6564 PERMIT FEES CITY HALL 01000 01 20.00 152059 7/31/2020 112385 NATIONAL PUBLIC EMPL LABOR RELATIONS 40.00 8/12/20 VIRTUAL CONF:GABBARD 186440 JGLCABCD73 1011 6470 TRAINING&SUBSISTANCE HUMAN RESOURCES 01000 04 40.00 152060 7/31/2020 116902 NORTHLAND SECURITIES 495.00 2019 TIF REPORTS PREP&FILING 186213 6160 2054 6401 PROFESSIONAL SERVICES TRIDENT HOUSING TIF DIST 02054 07 495.00 2019 TIF REPORTS PREP&FILING 186213 6160 2000 6401 PROFESSIONAL SERVICES HRA/ECONOMIC DEVELOPMENT 02000 03 990.00 R55CKS2 LOGIS600V CITY OF FARMINGTON 8/12/2020 9:05:21 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 6 7/1/2020 - 8/11/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 152061 7/31/2020 116942 OMNI BREWING COMPANY,LLC 305.00 BEER ORDER 186404 E-7593 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 305.00 152062 7/31/2020 100290 PAUSTIS&SONS WINE COMPANY 245.25 WINE ORDER 186363 95958 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 752.75 WINE ORDER 186406 95959 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 998.00 152063 7/31/2020 100032 PEPSI COLA COMPANY 148.45 POP ORDER 186397 82701957 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 148,45 152064 7/31/2020 100034 PHILLIPS WINE AND SPIRITS,INC 63.51 WINE ORDER 186331 6063328 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 207.82 UV VODKA ORDER 186335 6063327 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 40.31 ZING ZANG MIXES ORDER 186347 6059785 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 156.04 DAILY'S POUCH ORDER 166348 6D59784 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 615.76 LIQUOR&SPIRITS ORDER 186349 6059783 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 40.31 ZING ZANG BL MARY MIX ORDER 186415 6063278 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 513.33 WINE ORDER 186416 6063277 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 952.35 LIQUOR&SPIRITS ORDER 186419 6063276 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,591.43 152065 7/31/2020 100196 QUALITY REFRIGERATION INC 404.79 COOLER CONDENSER REPAIR 186431 0079485 6115 6505 EQUIPMENT REPAIR/MAINTENANCE PILOT KNOB LIQUOR 06100 02 2,786.02 COOLER CONDENSER REPAIR 186432 0079486 6115 6505 EQUIPMENT REPAIR/MAINTENANCE PILOT KNOB LIQUOR 06100 02 3,190.81 152066 7/31/2020 108826 RED WING,CITY OF 87,406.35 JUN-20 TIPPING FEES 186444 0047092 6302 6401 PROFESSIONAL SERVICES SOLID WASTE OPERATIONS 06300 08 87,406.35 152067 7/31/2020 112561 RICOH USA,INC 948.88 AUG'20 COPIER LEASES 186359 103909504 1010 6555 RENTAL OF EQUIPMENT ADMINISTRATION 01000 01 948.88 152068 7/31/2020 117727 SAPPHIRE LAKE DEVELOPMENT 24,880.00 CR:SPPHR LK 2-WTR MN OVRSIZE 186387 SAPPHIRE LK 2-WTR 6501 4640 WATER AVAILABILITY CHARGE WATER UTILITY REVENUES 06500 08 MN OVR 24,880.00 162069 7/31/2020 107018 SHAMROCK GROUP 89.74 ICE CUBE ORDER 186395 2526308 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 109.54 ICE CUBE ORDER 186400 2527454 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 R55CKS2 LOGIS600V CITY OF FARMINGTON 8/12/2020 9:05:21 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 7 7/1/2020 - 8/11/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 199.28 152070 7/31/2020 117381 SHARPER HOMES INC 3,000.00 ER 2893 213TH ST W 186382 ER 2893 213TH ST W 4600 2255 DEPOSITS PAYABLE PRIVATE CAPITAL PROJECTS 04600 07 3,000.00 ER 2880 213TH ST W 186383 ER 2880 213TH ST W 4600 2255 DEPOSITS PAYABLE PRIVATE CAPITAL PROJECTS 04600 07 6,000.00 152071 7/31/2020 108220 SOUTH METRO RENTAL INC 28.80 CHAIN SAW OIL 166140 106598 1076 6220 EQUIP SUPPLIES&PARTS NATURAL RESOURCES 01000 07 28.80 152072 7/31/2020 112051 SOUTHERN GLAZER'S OF MN 267.68 WINE ORDER 186330 1974242 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 484.08 WINE ORDER 186332 1974241 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 987.35 LIQUOR&SPIRITS ORDER 186336 1974240 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 4,037.00 LIQUOR&SPIRITS ORDER 186350 5058406 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 11.52 LIQUOR&SPIRITS ORDER 186351 1971577 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,998.91 LIQUOR&SPIRITS ORDER 186352 1971927 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,804.34 LIQUOR&SPIRITS ORDER 186402 1974247 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 977.76 WINE ORDER 186411 1974248 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 12,568.64 152073 7/31/2020 100379 SPRINT-NEXTEL 28.18 JULY 2020 SOLID WASTE TRACKER 186360 875483313-224 6302 6412 CELLULAR SERVICES SOLID WASTE OPERATIONS 06300 08 1.81- 186360 875483313-224 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 26.37 152074 7/31/2020 109225 STEWART TITLE OF MN,INC 75.96 REF UTIL CR@19839 EMBERS AVE 186367 749932 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 75.96 152075 7/31/2020 117728 SZUMERIA KUVASZ 433.86 K-9 ODIN BOARDING 166361 K-9 BOARDING 2200 6401 PROFESSIONAL SERVICES K-9(EFF.2019) 02200 05 JUNE/JULY'20 433.86 152076 7/31/2020 100519 TC CONSTRUCTION,INC 3,000.00 ER 6537 210TH ST W 186388 ER 6537 210TH ST W 4600 2255 DEPOSITS PAYABLE PRIVATE CAPITAL PROJECTS 04600 07 3,000.00 152077 7/31/2020 117634 TITLESMART INC. 51.22 REF UTIL CR@19775 ENGLISH AVE 186379 223557(77 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 51.22 152078 7/31/2020 114013 TRADEMARK TITLE SERVICES,INC 166.17 REF UTIL CR@18586 EXODUS AVE 186368 20-1954/78 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 166.17 R55CKS2 LOGIS600V CITY OF FARMINGTON 8/12/2020 9:05:21 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 8 7/1/2020 - 8/11/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 152079 7/31/2020 108808 VINOCOPIA,INC 316.83 WINE ORDER 186410 0260372-IN 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 316.83 152080 7/31/2020 117257 WATERMARK TITLE AGENCY 132.82 REF UTI CR@712 SPRUCE ST 186371 70110 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 132.82 152081 8/7/2020 103446 ALLIED BLACKTOP CO 8,265.24 2020 TRAIL FOG SEALING 186624 5193 5721 6401 PROFESSIONAL SERVICES TRAIL MAINTENANCE 05700 8,265.24 162082 817/2020 100011 ANDERSEN,EARL F 183.60 SIGN POSTS/SIGNS 186233 0123835-IN 1072 6254 SIGNS&STRIPING MATERIALS STREET MAINTENANCE 01000 08 183.60 152083 8/7/2020 113303 ARTISAN BEER COMPANY 1,082.10 BEER ORDER 186601 3429477 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,082.10 152084 8/7/2020 108446 ASPEN MILLS,INC. 288.10 UNIFORM ITEMS:FRANCIS,G 186487 259057 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 215.15 UNIFORM ITEMS:OLSON,M 186488 259054 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 359.25 UNIFORM ITEMS:ALTHOFF,B 186490 259055 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 355.25 UNIFORM ITEMS:MATTINGLY,S. 186491 259056 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 349.25 UNIFORM ITEMS:CARROLL,B. 186492 259052 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 345.25 UNIFORM ITEMS:GOEDTEL,S 186493 259053 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 1,912.25 152085 817/2020 117737 ASSURED COMFORT HEATING&A/C 1.00 VOID MECH PRMT 46279 186526 VOID MECH PRMT 1000 2420 BUILDING PERMIT SURCHARGE GENERAL FUND BALANCE SHEE 01000 46279 55.00 VOID MECH PRMT 46279 186526 VOID MECH PRMT 1001 4315 PLUMBING&HEATING PERMITS GENERAL FUND REVENUES 01000 01 46279 56.00 152086 8/7/2020 116931 AUTHORITY TITLE,INC 158.75 REF UTIL CR@30 PINE PL 173298 190014 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 158.75 152087 817/2020 113390 BJORGE,LYDIA K 90.00 2019 STIPEND:PLANNING COMM 181022 2019 PLANNING 1030 6401 PROFESSIONAL SERVICES PLANNING&ZONING 01000 03 COMMISSION 90.00 152088 8/7/2020 110290 BOLTON&MENK,INC R55CKS2 LOGIS600V CITY OF FARMINGTON 6/12/2020 9:05:21 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 9 7/1/2020 - 8/11/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept Div 950.00 APR'20 SVS:COMPR PLAN TECH 186529 0248998 1070 6401 PROFESSIONAL SERVICES ENGINEERING SERVICES 01000 07 950.00 152089 8/7/2020 114472 BREAKTHRU BEVERAGE MN BEER,LLC 98.40- MIKE'S HARD RASP LEMON CREDIT 186592 2090450349 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 11,207.25 BEER ORDER 186597 1091155522 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 3,241.40 BEER ORDER 186600 1091155521 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 14,350.25 152090 8/7/2020 114471 BREAKTHRU BEVERAGE MN WINE&SPIRITS 30.00- LIQUOR&SPIRITS CREDIT 186566 2080277844 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 25.00- LIQUOR&SPIRITS CREDIT 166567 2080277845 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 23.83- LIQUOR&SPIRITS CREDIT 186568 2080281735 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 45.00- LIQUOR&SPIRITS CREDIT 186587 2080277843 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 71.48- LIQUOR&SPIRITS ORDER 186588 2080281733 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 12.47- LIQUOR&SPIRITS CREDIT 186589 2080276998 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 43.50- LIQUOR&SPIRITS ORDER 186590 2080277846 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 186.35 WINE ORDER 186591 1081161266 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 3,222.86 LIQUOR&SPIRITS ORDER 186596 1081161267 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,241.22 LIQUOR&SPIRITS ORDER 166599 1061161266 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 5,399.15 152091 8/7/2020 100026 CINTAS CORP LOC 754 43.84 JUL'20 WEEKLY UNIFORM SERVICES 186182 4055344434 1072 6290 UNIFORMS&CLOTHING STREET MAINTENANCE 01000 08 43.83 JUL'20 WEEKLY UNIFORM SERVICES 186182 4055344434 1090 6290 UNIFORMS&CLOTHING PARK MAINTENANCE 01000 09 3.01- 186182 4055344434 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 43.84 JUL'20 WEEKLY UNIFORM SERVICES 186182 4055344434 6202 6290 UNIFORMS&CLOTHING SEWER OPERATIONS EXPENSE 06200 08 46.85 JUL'20 WEEKLY UNIFORM SERVICES 186182 4055344434 6302 6290 UNIFORMS&CLOTHING SOLID WASTE OPERATIONS 06300 08 43.84 JUL'20 WEEKLY UNIFORM SERVICES 186182 4055344434 6402 6290 UNIFORMS&CLOTHING STORM WATER UTILITY OPERA 06400 08 43.31 JUL'20 WEEKLY UNIFORM SERVICES 186182 4055344434 6502 6290 UNIFORMS&CLOTHING WATER UTILITY EXPENSE 06500 08 43.83 JUL'20 WEEKLY UNIFORM SERVICES 186247 4055910173 1072 6290 UNIFORMS&CLOTHING STREET MAINTENANCE 01000 08 43.84 JUL'20 WEEKLY UNIFORM SERVICES 186247 4055910173 1090 6290 UNIFORMS&CLOTHING PARK MAINTENANCE 01000 09 3.01- 186247 4055910173 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 43.84 JUL'20 WEEKLY UNIFORM SERVICES 186247 4055910173 6202 6290 UNIFORMS&CLOTHING SEWER OPERATIONS EXPENSE 06200 08 46.85 JUL'20 WEEKLY UNIFORM SERVICES 186247 4055910173 6302 6290 UNIFORMS&CLOTHING SOLID WASTE OPERATIONS 06300 08 43.84 JUL'20 WEEKLY UNIFORM SERVICES 186247 4055910173 6402 6290 UNIFORMS&CLOTHING STORM WATER UTILITY OPERA 06400 08 43.31 JUL'20 WEEKLY UNIFORM SERVICES 186247 4055910173 6502 6290 UNIFORMS&CLOTHING WATER UTILITY EXPENSE 06500 08 43.31 JUL'20 WEEKLY UNIFORM SERVICES 186548 4057202166 6502 6290 UNIFORMS&CLOTHING WATER UTILITY EXPENSE 06500 08 43.84 JUL'20 WEEKLY UNIFORM SERVICES 186548 4057202166 6402 6290 UNIFORMS&CLOTHING STORM WATER UTILITY OPERA 06400 08 3.01- 186548 4057202166 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 46.85 JUL'20 WEEKLY UNIFORM SERVICES 166548 4057202166 6302 6290 UNIFORMS&CLOTHING SOLID WASTE OPERATIONS 06300 08 43.84 JUL'20 WEEKLY UNIFORM SERVICES 186548 4057202166 6202 6290 UNIFORMS&CLOTHING SEWER OPERATIONS EXPENSE 06200 08 43.84 JUL'20 WEEKLY UNIFORM SERVICES 186548 4057202166 1090 6290 UNIFORMS&CLOTHING PARK MAINTENANCE 01000 09 43.83 JUL'20 WEEKLY UNIFORM SERVICES 186548 4057202166 1072 6290 UNIFORMS&CLOTHING STREET MAINTENANCE 01000 08 R55CKS2 LOGIS600V CITY OF FARMINGTON 8/12/2020 9:05:21 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 10 7/1/2020 - 8/11/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 43.75 JUL'20 WEEKLY UNIFORM SERVICES 186551 4056564256 6502 6290 UNIFORMS&CLOTHING WATER UTILITY EXPENSE 06500 08 43.75 JUL'20 WEEKLY UNIFORM SERVICES 186551 4056564256 6402 6290 UNIFORMS&CLOTHING STORM WATER UTILITY OPERA 06400 08 3.01- 186551 4056564256 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 46.76 JUL'20 WEEKLY UNIFORM SERVICES 186551 4056564256 6302 6290 UNIFORMS&CLOTHING SOLID WASTE OPERATIONS 06300 08 43.75 JUL'20 WEEKLY UNIFORM SERVICES 186551 4056564256 6202 6290 UNIFORMS&CLOTHING SEWER OPERATIONS EXPENSE 06200 08 43.75 JUL'20 WEEKLY UNIFORM SERVICES 186551 4056564256 1090 6290 UNIFORMS&CLOTHING PARK MAINTENANCE 01000 09 43.75 JUL'20 WEEKLY UNIFORM SERVICES 186551 4056564256 1072 6290 UNIFORMS&CLOTHING STREET MAINTENANCE 01000 08 1,050.00 152092 8/7/2020 100071 COLLEGE CITY BEVERAGE INC 4.90- BEER ORDER CREDIT 186560 729-02151 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 11,838.48 BEER ORDER 186561 729-02150 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 5,732.65 BEER ORDER 186563 729-02153 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 38.00- BEER ORDER CREDIT 186564 729-02156 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 17,528.23 152093 8/7/2020 100030 CORE&MAIN,LP 52.01 STORM GRATE 186510 M659553 6402 6220 EQUIP SUPPLIES&PARTS STORM WATER UTILITY OPERA 06400 08 52.01 152094 8/7/2020 110844 DAKOTA COUNTY FINANCIAL SRVS 49.95 MAY'20 GOPHER 1 FIBER LOCATES 186454 00038587 7400 6401 PROFESSIONAL SERVICES INFORMATION TECHNOLOGY 07400 04 49.95 152095 8/7/2020 100081 DAKOTA COUNTY LUMBER COMPANY 47.85 CONCRETE TUBE:FARM PRESERVE 186648 2007-766941 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 47.85 152096 8/7/2020 114949 DVS REGISTRATION 14.25 F#0571 LIC FEES V#47556 186521' 2017 CHEV TAB 1050 6234 VEHICLE LICENSES,TAXES,FEE POLICE ADMINISTRATION 01000 05 RENEW2020 14.25 152097 8/7/2020 100149 ECM PUBLISHERS,INC 89.25 2019ANNUALTIF PUBLICATION 186212 784658 2054 6455 LEGAL NOTICES PUBLICATIONS TRIDENT HOUSING TIF DIST 02054 07 29.75 FILING NOTICE 166223 1058615 1013 6455 LEGAL NOTICES ELECTIONS 01000 01 42.50 GROUP MEDICAL BIDS 186433 784656 1011 6455 LEGAL NOTICES HUMAN RESOURCES 01000 04 161.50 152098 817/2020 109931 FACTORY MOTOR PARTS 285.92 BRAKE PARTS FOR 0721 186152 1-6460219 1070 6230 VEHICLE SUPPLIES&PARTS ENGINEERING SERVICES 01000 07 138.07 WHEEL BEARING FOR 0700 186154 1-6461924 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 484.58 BRAKE PARTS FOR 0561 186155 1-6461831 1051 6230 VEHICLE SUPPLIES&PARTS PATROL SERVICES 01000 05 200.92 BRAKE PARTS FOR 0902 186156 1-6462842 1090 6230 VEHICLE SUPPLIES&PARTS PARK MAINTENANCE 01000 09 1,109.49 R55CKS2 LOGIS600V CITY OF FARMINGTON 6/12/2020 9:05:21 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 11 7/1/2020 - 8/11/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 152099 8/7/2020 100022 FARMINGTON PRINTING INC 73.00 COPY PAPER 186211 13626 1010 6210 OFFICE SUPPLIES ADMINISTRATION 01000 01 73.00 152100 8/7/2020 111431 FERGUSON WATERWORKS 2,915.32 AFC MOD KIT:HYDRANT PARTS 166012 0456680 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 2,915.32 152101 8/7/2020 116270 FORD OF HIBBING 31,719.70 F#0303'20 FORD EXPL#62994 186620 9968126 5602 6940 VEHICLES GEN CAPITAL EQUIP FUND EX 05600 31,719.70 152102 8/7/2020 100077 FRONTIER COMMUNICATIONS 73.90 AUG'20 ARENA ALARM LINE 186543 651-463-3016 2502 6411 TELEPHONE/CABLE SERVICES ICE ARENA OPERATIONS EXPE 02500 09 AUG'20 73.90 152103 8/7/2020 102071 GOODYEAR TIRE&RUBBER COMPANY,THE 694.48 TIRES FOR 0571 186157 124-1098319 7200 6232 VEHICLE/EQUIPMENT TIRES FLEET OPERATIONS 07200 08 694.48 152104 8/7/2020 100044 GRAINGER INC 136.00 SOLENOID FOR WATER TANK 186192 9586960030 2502 6220 EQUIP SUPPLIES&PARTS ICE ARENA OPERATIONS EXPE 02500 09 136.00 152105 8/7/2020 108140 HEDLUND IRRIGATION&LANDSCAPING INC 54.00 MOWING SVS:20012 ENGLISH AVE 186622 2995 4600 6560 CONTRACTUAL SERVICES PRIVATE CAPITAL PROJECTS 04600 07 54.00 152106 8/7/2020 107688 HENTGES AND SONS INC,S.M. 511,117.07 PAY REQ#1/2020 OVERLAYS 186527 PAY REQ#1/20-03 5702 7010 02003 CONSTRUCTION CONTRACTS SEALCOATING EXPENSES 05700 OVERLAYS 511,117.07 152107 8/7/2020 100074 HOHENSTEINS INC 702.00 BEER ORDER 186468 211430 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 673.50 BEER ORDER 186602 211431 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,375.50 152108 8/7/2020 116553 HOLTON,SANDRA L 43.93 REF UTILCR@19683 MEADOWLARK WY 169258 18-345.PFD/18-3451 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 /24 43.93 152109 8/7/2020 117717 INNOVATIVE GRAPHICS 116.00 T-SHIRTS-SUMMER SPA 186277 49454 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 116.00 R55CKS2 LOGIS600V CITY OF FARMINGTON 8/12/2020 9:05:21 Note. Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 12 7/1/2020 - 8/11/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept Div 152110 8/7/2020 107591 INTERNATIONAL FIRE PROTECTION 152.00 OVRPYMT FIRE PRMT 44719 177427 OVRPYMT FIRE PRM11000 2255 DEPOSITS PAYABLE GENERAL FUND BALANCE SHEE 01000 44719 152.00 152111 8/7/2020 109846 JJ TAYLOR DISTRIBUTING COMPANY OF MN INC 5,383.85 BEER ORDER 186469 3108468 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 7,195.20 BEER ORDER 186562 3106467 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 12,579.05 162112 8/7/2020 111068 JOHN HENRY FOSTER MN,INC 18.52 AIR COMPRESSOR PART 186248 10495609-00 1072 6220 EQUIP SUPPLIES&PARTS STREET MAINTENANCE 01000 08 18.54 AIR COMPRESSOR PART 186248 10495609-00 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 1.27- 186248 10495609-00 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 18.54 AIR COMPRESSOR PART 186248 10495609-00 6202 6220 EQUIP SUPPLIES&PARTS SEWER OPERATIONS EXPENSE 06200 08 19.81 AIR COMPRESSOR PART 186248 10495609-00 6302 6220 EQUIP SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 18.54 AIR COMPRESSOR PART 186248 10495609-00 6402 6220 EQUIP SUPPLIES&PARTS STORM WATER UTILITY OPERA 06400 08 18.32 AIR COMPRESSOR PART 186248 10495609-00 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 111.00 162113 8/7/2020 100033 JOHNSON BROTHERS LIQUOR COMPANY 67.02 AGALIMA MARGARITA ORDER 186476 1606629 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 128.73 WINE ORDER 186477 1606628 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 214.53 LIQUOR&SPIRITS ORDER 186478 1606627 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 103.51 SVEDKA VODKA ORDER 186479 1606625 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 517.02 LIQUOR&SPIRITS ORDER 186480 1606524 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 698.09 LIQUOR&SPIRITS ORDER 186554 1606630 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 56.66 WINE ORDER 186555 1606631 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 565.31 WINE ORDER 186556 1606626 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 598.53 LIQUOR&SPIRITS ORDER 186557 1606624 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 51.16- WINE ORDER CREDIT 186569 109125 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 794.78 WINE ORDER 186570 1602668 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 270.84 WINE ORDER 186571 1606527 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 665.85 SVEDKA VODKA ORDER 186572 1606526 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 4,206.62 LIQUOR&SPIRITS ORDER 186573 1606525 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 389.35 LIQUOR&SPIRITS ORDER 186574 1606528 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 701.70 WINE ORDER 186575 1606529 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 51.02 MASTER MIXES MARGARITA ORDER 186576 1606530 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 27.00 KINKY COCKTAILS ORDER 186577 1606533 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 683.72 WINE ORDER 186578 1606532 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,317.16 LIQUOR&SPIRITS ORDER 186579 1606531 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 400.05 LIQUOR&SPIRITS ORDER 186580 1606523 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 26.68- WINE ORDER CREDIT 186598 109048 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 12,579.65 R55CKS2 LOGIS600V CITY OF FARMINGTON 8/12/2020 9:05:21 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 13 7/1/2020 - 8/11/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 152114 8/7/2020 115466 LIFE INSURANCE COMPANY OF NORTH AMERICA 335.16 JAN'20 ACCIDENT&Cl INSURANCE 186536 A1960331 JAN'20 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07D00 02 340.55 DEC'19 ACCIDENT&Cl INSURANCE 186537 A1960331 DEC'19 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 675.71 152115 8/7/2020 117708 M/1 HOMES 3,000.00 ER 3752 192ND ST W 186525 ER 3752 192ND ST W4600 2255 DEPOSITS PAYABLE PRIVATE CAPITAL PROJECTS 04600 07 3,000.00 152116 8/7/2020 100715 MENARDS-APPLE VALLEY 30.88 CTY HALL SECRTY CAMERA SUPLIES 186553 82953 1015 6220 EQUIP SUPPLIES&PARTS CITY HALL 01000 01 30.88 152117 8/7/2020 113442 METERING&TECHNOLOGY SOLUTIONS 5,000.00 BEACON ENGAGEMENT FEE:SERVICE 186530 17253 6502 6401 PROFESSIONAL SERVICES WATER UTILITY EXPENSE 06500 08 5,000.00 152118 8/7/2020 100527 METRO ALARM CONTRACTORS INC 337.44 SEPT-NOV'20 PKALARM MONITOR 186603 040317 6115 6515 BUILDING REPAIR/MAINTENANCE PILOT KNOB LIQUOR 06100 02 273.17 SEPT-NOV'20 DT ALARM MONITOR 186604 040316 6110 6515 BUILDING REPAIR/MAINTENANCE DOWNTOWN LIQUOR REV&EXP 06100 02 610.61 152119 8/7/2020 116929 MINNESOTA TITLE 123.83 REF UTIL CR@18639 ESQUIRE WY 177545 MT-1906-1084-ED/11 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 4 151.64 REF UTIL CR@4833 191ST ST W 178528 MT-1907-1106-MG/48 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 275.47 152120 8/7/2020 100070 MINNESOTA VALLEY TESTING LABORATORIES 110.00 BAC-T SAMPLE(10)/MTHLY REPORT 186142 1040963 6502 6401 PROFESSIONAL SERVICES WATER UTILITY EXPENSE 06500 08 110.00 152121 8/7/2020 101313 MN DEPT OF LABOR&INDUSTRY 40.00 PRESSURE VESSEL PRMT(4) 186552 ABR0234974X 1015 6564 PERMIT FEES CITY HALL 01D00 01 40.00 152122 8/7/2020 107932 MOOD MEDIA 93.25 AUGUST 2020 RADIO SVS-LIQUOR 186481 55559281 6110 6401 PROFESSIONAL SERVICES DOWNTOWN LIQUOR REV&EXP 06100 02 93.25 AUGUST 2020 RADIO SVS-LIQUOR 186481 55559261 6115 6401 PROFESSIONAL SERVICES PILOT KNOB LIQUOR 06100 02 186.50 152123 817/2020 113976 NORTHLAND RECREATION,LLC 4,400.00 WOOD FIBER FOR PLAYGROUNDS 186195 2101 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 2,200.00 WOOD FIBER FOR PLAYGROUNDS 186196 2102 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 6,600.00 152124 8/7/2020 100290 PAUSTIS&SONS WINE COMPANY R55CKS2 LOGIS600V CITY OF FARMINGTON 8/12/2020 9:05:21 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 14 7/1/2020 - 8/11/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept Div 499.50 WINE ORDER 186593 96742 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 499.50 152125 8/7/2020 100093 PELLICCI HARDWARE&RENTAL 17.99 WEED SPRAYER 185808 K36911 IF 1090 6950 MACHINERY,EQUIPMENT&TOOLS PARK MAINTENANCE 01000 09 17.98 DRILL BITS 185818 K36917/F 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 24.07 NUTS/BOLTS:DOCK REPAIR 185995 K36963/F 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 4.98 TOILET CLEANER 185996 K36961/F 1090 6242 CLEANING SUPPLIES PARK MAINTENANCE 01000 09 .79 O RING FOR WATER FILTER 185997 K37031/F 2502 6220 EQUIP SUPPLIES&PARTS ICE ARENA OPERATIONS EXPE 02500 09 24.99 WALL BOARD KIT 185999 K37073/F 1015 6240 BUILDING SUPPLIES&PARTS CITY HALL 01000 01 22.86 FUNNELITIESNINYL TUB:WTR LK 186000 37027/F'20 2502 6220 EQUIP SUPPLIES&PARTS ICE ARENA OPERATIONS EXPE 02500 09 16.26 EXTENSION CORD 50' 186028 37138/F 6115 6220 EQUIP SUPPLIES&PARTS PILOT KNOB LIQUOR 06100 02 32.97 MOPHEAD/RAGS 186028 37138/F 6115 6242 CLEANING SUPPLIES PILOT KNOB LIQUOR 06100 02 32.12 RAGS INABX(2) 186133 K37177/F 6115 6242 CLEANING SUPPLIES PILOT KNOB LIQUOR 06100 02 21.99 TIE DOWN RATCHET 186134 K37103/F 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 69.99 GRASS SEED 186141 37136/F 1076 6255 LANDSCAPING MATERIALS NATURAL RESOURCES 01000 07 16.02 TOUCH'N FLOW PISTOL 186143 K37138/F 6302 6950 MACHINERY,EQUIPMENT&TOOLS SOLID WASTE OPERATIONS 06300 08 1.03- 186143 K37138/F 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 8.54 BROOM,ANGLE SML BASC 186144 K37204/F 6302 6950 MACHINERY,EQUIPMENT&TOOLS SOLID WASTE OPERATIONS 06300 08 .55- 186144 K37204/F 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 9.99 WALL CLEANER 186160 K37069/F 2502 6242 CLEANING SUPPLIES ICE ARENA OPERATIONS EXPE 02500 09 4.00 VAC BAGS AND SPRAYER 186179 K37078/F 1015 6220 EQUIP SUPPLIES&PARTS CITY HALL 01000 01 4.00 VAC BAGS AND SPRAYER 186179 K37078/F 1060 6220 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 .08- 186179 K37078/F 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 5.99 VAC BAGS AND SPRAYER 186179 K37078/F 1072 6220 EQUIP SUPPLIES&PARTS STREET MAINTENANCE 01000 08 1.20 VAC BAGS AND SPRAYER 186179 K37078/F 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 3.97 VAC BAGS AND SPRAYER 166179 K37078/F 1093 6220 EQUIP SUPPLIES&PARTS SENIOR CITIZEN SERVICES 01000 09 1.20 VAC BAGS AND SPRAYER 186179 K37078/F 6202 6220 EQUIP SUPPLIES&PARTS SEWER OPERATIONS EXPENSE 06200 08 1.28 VAC BAGS AND SPRAYER 186179 K37078/F 6302 6220 EQUIP SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 1.20 VAC BAGS AND SPRAYER 186179 K37078/F 6402 6220 EQUIP SUPPLIES&PARTS STORM WATER UTILITY OPERA 06400 08 1.20 VAC BAGS AND SPRAYER 186179 K37078/F 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 9.99 WEATHER STRIPPING 186180 K37105/F 1015 6240 BUILDING SUPPLIES&PARTS CITY HALL 01000 01 79.98 PITCH FORKS 5TN ASH HNDL(2) 186184 K37167/F 1090 6950 MACHINERY,EQUIPMENT&TOOLS PARK MAINTENANCE 01000 09 24.99 LEATHER GLOVES 186186 K37196/F 1090 6290 UNIFORMS&CLOTHING PARK MAINTENANCE 01000 09 11.99 CAULK 186188 K37178/F 1093 6240 BUILDING SUPPLIES&PARTS SENIOR CITIZEN SERVICES 01000 09 415.17 WATER SOFTENER SALT 186189 K37174/F 2502 6240 BUILDING SUPPLIES&PARTS ICE ARENA OPERATIONS EXPE 02500 09 9.99 9V BATTERY ADV LITH 186190 K37220/F 2502 6220 EQUIP SUPPLIES&PARTS ICE ARENA OPERATIONS EXPE 02500 09 34.95 CONCRETE MIX 186228 37232/F 6402 6250 OTHER SUPPLIES&PARTS STORM WATER UTILITY OPERA 06400 08 72.82 BATH TISSUE/PAPER TOWELS 186243 37297/F'20 6110 6242 CLEANING SUPPLIES DOWNTOWN LIQUOR REV&EXP 06100 02 34.07 CUTTER ACE CARTON CARDED(20) 186243 37297/F'20 6110 6220 EQUIP SUPPLIES&PARTS DOWNTOWN LIQUOR REV&EXP 06100 02 11.43 SILCONE/BOLTS 186249 K37290/F 1015 6220 EQUIP SUPPLIES&PARTS CITY HALL 01000 01 5.00 MARKING PAINT 186255 K37295/F 1093 6220 EQUIP SUPPLIES&PARTS SENIOR CITIZEN SERVICES 01000 09 R55CKS2 LOGIS600V CITY OF FARMINGTON 8/12/2020 9:05:21 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 15 7/1/2020 - 8/11/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 62.00 FLOOR CLEANER 186268 23353/1' 6502 6242 CLEANING SUPPLIES WATER UTILITY EXPENSE 06500 08 62.00 FLOOR CLEANER 186268 23353/F 6402 6242 CLEANING SUPPLIES STORM WATER UTILITY OPERA 06400 08 3.42- 186268 23353/F 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 53.12 FLOOR CLEANER 186268 23353/F 6302 6242 CLEANING SUPPLIES SOLID WASTE OPERATIONS 06300 08 31.59 FLOOR CLEANER 186268 23353/1' 6202 6242 CLEANING SUPPLIES SEWER OPERATIONS EXPENSE 06200 08 78.97 FLOOR CLEANER 186268 23353/1' 1093 6242 CLEANING SUPPLIES SENIOR CITIZEN SERVICES 01000 09 31.59 FLOOR CLEANER 186268 23353/1' 1090 6242 CLEANING SUPPLIES PARK MAINTENANCE 01000 09 157.93 FLOOR CLEANER 186268 23353/1' 1072 6242 CLEANING SUPPLIES STREET MAINTENANCE 01000 08 78.97 FLOOR CLEANER 186268 23353/1' 1060 6242 CLEANING SUPPLIES FIRE SERVICES 01000 06 78.97 FLOOR CLEANER 186268 23353/F 1015 6242 CLEANING SUPPLIES CITY HALL 01000 01 11.98 PVC PIPE AND PLUG TESTER 186270 37348/F 1015 6220 EQUIP SUPPLIES&PARTS CITY HALL 01000 01 7.47 TOILET CLEANER 186271 K37363/F 1015 6242 CLEANING SUPPLIES CITY HALL 01000 01 243.26 PAPER TWLS/MLT-FLD TWLS 186272 18927/F 1015 6242 CLEANING SUPPLIES CITY HALL 01000 01 121.64 PAPER TWLS/MLT-FLD TWLS 186272 18927/F 1060 6242 CLEANING SUPPLIES FIRE SERVICES 01000 06 3.34- 186272 18927/1' 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 243.23 PAPER TWLS/MLT-FLD TWLS 186272 18927/F 1072 6242 CLEANING SUPPLIES STREET MAINTENANCE 01000 08 48.65 PAPER TWLS/MLT-FLD TWLS 186272 18927/F 1090 6242 CLEANING SUPPLIES PARK MAINTENANCE 01000 09 121.63 PAPER TWLS/MLT FLD TWLS 186272 18927/F 1093 6242 CLEANING SUPPLIES SENIOR CITIZEN SERVICES 01000 09 48.65 PAPER TWLS/MLT-FLD TWLS 186272 18927/1' 6202 6242 CLEANING SUPPLIES SEWER OPERATIONS EXPENSE 06200 08 51.99 PAPER TWLS/MLT-FLD TWLS 186272 18927/F 6302 6242 CLEANING SUPPLIES SOLID WASTE OPERATIONS 06300 08 48.65 PAPER TWLS/MLT-FLD TWLS 186272 18927/1' 6402 6242 CLEANING SUPPLIES STORM WATER UTILITY OPERA 06400 08 48.65 PAPER TWLS/MLT-FLD TWLS 186272 18927/F 6502 6242 CLEANING SUPPLIES WATER UTILITY EXPENSE 06500 08 49.98 GLOVES:LEATHER XL(1) L(1) 186273 K37380/F 1090 6290 UNIFORMS&CLOTHING PARK MAINTENANCE 01000 09 37.75 PAPER TOWELS 186274 K37390/F 1015 6242 CLEANING SUPPLIES CITY HALL 01000 01 18.89 PAPER TOWELS 186274 K37390/F 1060 6242 CLEANING SUPPLIES FIRE SERVICES 01000 06 .52- 186274 K37390/F 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 37.78 PAPER TOWELS 186274 K37390/F 1072 6242 CLEANING SUPPLIES STREET MAINTENANCE 01000 08 7.56 PAPER TOWELS 186274 K37390/F 1090 6242 CLEANING SUPPLIES PARK MAINTENANCE 01000 09 18.89 PAPER TOWELS 186274 K37390/F 1093 6242 CLEANING SUPPLIES SENIOR CITIZEN SERVICES 01000 09 7.56 PAPER TOWELS 186274 K37390/F 6202 6242 CLEANING SUPPLIES SEWER OPERATIONS EXPENSE 06200 08 8.08 PAPER TOWELS 186274 K37390/F 6302 6242 CLEANING SUPPLIES SOLID WASTE OPERATIONS 06300 08 7.56 PAPER TOWELS 186274 K37390/F 6402 6242 CLEANING SUPPLIES STORM WATER UTILITY OPERA 06400 08 7.55 PAPER TOWELS 186274 K37390/F 6502 6242 CLEANING SUPPLIES WATER UTILITY EXPENSE 06500 08 6.42 VACUUM BELT 186290 K37407/F 6115 6220 EQUIP SUPPLIES&PARTS PILOT KNOB LIQUOR 06100 02 43.90 BATTERIESNELCRO 186290 K37407/F 6110 6220 EQUIP SUPPLIES&PARTS DOWNTOWN LIQUOR REV&EXP 06100 02 23.28 CAP 3/4"(12);STOP NUTS/PIPE 186321 K37305/F 6302 6220 EQUIP SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 1.50- 186321 K37305/F 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 3.95 STOP NUTS 186322 K37308/F 6302 6220 EQUIP SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 .25- 186322 K37308/F 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 6.41 KING SIZE MARKER BLACK(2) 186358 K37543/F 6115 6210 OFFICE SUPPLIES PILOT KNOB LIQUOR 06100 02 16.06 TRASH BAGS 13 GAL 186430 37563/1' 6115 6242 CLEANING SUPPLIES PILOT KNOB LIQUOR 06100 02 2.99 COVER JUNCTN BOXSECURITYCAMERA 186483 K37392/F 1015 6240 BUILDING SUPPLIES&PARTS CITY HALL 01000 01 R55CKS2 LOGIS600V CITY OF FARMINGTON 8/12/2020 9:05:21 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 16 7/1/2020 - 8/11/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 63.97 FAUCET LAV/SPLYFCT FIRE ST#2 186486 K37170/F 1060 6240 BUILDING SUPPLIES&PARTS FIRE SERVICES 01000 06 24.99 TOTE FOR BLDG CLEANING RAGS 186495 K37399/F 1015 6240 BUILDING SUPPLIES&PARTS CITY HALL 01000 01 7.48 TOILET BOWL CLEANER 186538 27357/F 1015 6242 CLEANING SUPPLIES CITY HALL 01000 01 3.74 TOILET BOWL CLEANER 186538 27357/F 1060 6242 CLEANING SUPPLIES FIRE SERVICES 01000 06 .10- 186538 27357/1' 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 7.47 TOILET BOWL CLEANER 186538 27357/1' 1072 6242 CLEANING SUPPLIES STREET MAINTENANCE 01000 08 1.49 TOILET BOWL CLEANER 186538 27357/F 1090 6242 CLEANING SUPPLIES PARK MAINTENANCE 01000 09 3.74 TOILET BOWL CLEANER 186538 27357/F 1093 6242 CLEANING SUPPLIES SENIOR CITIZEN SERVICES 01000 09 1.49 TOILET BOWL CLEANER 186538 27357/F 6202 6242 CLEANING SUPPLIES SEWER OPERATIONS EXPENSE 06200 08 1.59 TOILET BOWL CLEANER 186538 27357/F 6302 6242 CLEANING SUPPLIES SOLID WASTE OPERATIONS 06300 08 1.49 TOILET BOWL CLEANER 186538 27357/F 6402 6242 CLEANING SUPPLIES STORM WATER UTILITY OPERA 06400 08 1.49 TOILET BOWL CLEANER 186538 27357/F 6502 6242 CLEANING SUPPLIES WATER UTILITY EXPENSE 06500 08 4.99 GLUE 186539 K37581/F 1015 6220 EQUIP SUPPLIES&PARTS CITY HALL 01000 01 157.90 RESTROOM DISINFECTANT 186540 39654/F 1015 6242 CLEANING SUPPLIES CITY HALL 01000 01 78.97 RESTROOM DISINFECTANT 186540 39654/F 1060 6242 CLEANING SUPPLIES FIRE SERVICES 01000 06 2.17- 186540 39654/1' 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 157.93 RESTROOM DISINFECTANT 186540 39654/F 1072 6242 CLEANING SUPPLIES STREET MAINTENANCE 01000 08 31.59 RESTROOM DISINFECTANT 186540 39654/F 1090 6242 CLEANING SUPPLIES PARK MAINTENANCE 01000 09 78.97 RESTROOM DISINFECTANT 186540 39654/1' 1093 6242 CLEANING SUPPLIES SENIOR CITIZEN SERVICES 01000 09 31.59 RESTROOM DISINFECTANT 186540 39654/F 6202 6242 CLEANING SUPPLIES SEWER OPERATIONS EXPENSE 06200 08 33.76 RESTROOM DISINFECTANT 186540 39654/1' 6302 6242 CLEANING SUPPLIES SOLID WASTE OPERATIONS 06300 08 31.59 RESTROOM DISINFECTANT 186540 39654/1' 6402 6242 CLEANING SUPPLIES STORM WATER UTILITY OPERA 06400 08 31.59 RESTROOM DISINFECTANT 186540 39654/F 6502 6242 CLEANING SUPPLIES WATER UTILITY EXPENSE 06500 08 18.75 DISPOSABLE GLOVES 186541 K37589/F 1015 6242 CLEANING SUPPLIES CITY HALL 01000 01 9.37 DISPOSABLE GLOVES 186541 K37589/F 1060 6242 CLEANING SUPPLIES FIRE SERVICES 01000 06 .26- 186541 K37589/F 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 18.73 DISPOSABLE GLOVES 186541 K37589/F 1072 6242 CLEANING SUPPLIES STREET MAINTENANCE 01000 08 3.75 DISPOSABLE GLOVES 186541 K37589/F 1090 6242 CLEANING SUPPLIES PARK MAINTENANCE 01000 09 9.37 DISPOSABLE GLOVES 186541 K37589/F 1093 6242 CLEANING SUPPLIES SENIOR CITIZEN SERVICES 01000 09 3.75 DISPOSABLE GLOVES 186541 K37589/F 6202 6242 CLEANING SUPPLIES SEWER OPERATIONS EXPENSE 06200 08 4.01 DISPOSABLE GLOVES 186541 K37589/F 6302 6242 CLEANING SUPPLIES SOLID WASTE OPERATIONS 06300 08 3.75 DISPOSABLE GLOVES 186541 K37589/F 6402 6242 CLEANING SUPPLIES STORM WATER UTILITY OPERA 06400 08 3.75 DISPOSABLE GLOVES 186541 K37589/F 6502 6242 CLEANING SUPPLIES WATER UTILITY EXPENSE 06500 08 15.96 PAINT BRUSHES 186545 K37601/F 1093 6240 BUILDING SUPPLIES&PARTS SENIOR CITIZEN SERVICES 01000 09 34.99 TORX BIT SOCKET SET TP 5PC 186546 K37471/F 1015 6950 MACHINERY,EQUIPMENT&TOOLS CITY HALL 01000 01 5.00 PAINT TO STRIPE FIELDS 186547 K37417/F 1090 6254 SIGNS&STRIPING MATERIALS PARK MAINTENANCE 01000 09 134.95 FLOOR LEVELR/SPIN LGHT/REGISTR 186549 K37641/F 1093 6220 EQUIP SUPPLIES&PARTS SENIOR CITIZEN SERVICES 01000 09 24.96 WASP SPRAY/BSKTBLL NET/CBLE TI 186550 K37453/F 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 5.37 WATER BALLOONS FOR PARKS GAMES 186611 K37638/F 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 101.94 BLACKTOP REPAIR:TRAILS 186614 K37675/F 1090 6250 OTHER SUPPLIES&PARTS PARK MAINTENANCE 01000 09 4.73 STEEL WOOL/BRKPRS FRND/TILE CL 186616 37683/F'20 1015 6242 CLEANING SUPPLIES CITY HALL 01000 01 2.37 STEEL WOOL/BRKPRS FRND/TILE CL 186616 37683/F'20 1060 6242 CLEANING SUPPLIES FIRE SERVICES 01000 06 R55CKS2 LOGIS600V CITY OF FARMINGTON 8/12/2020 9:05:21 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 17 7/1/2020 - 8/11/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div .07- 186616 37683/1 '20 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 4.74 STEEL WOOL/BRKPRS FRND/TILE CL 186616 37683/F'20 1072 6242 CLEANING SUPPLIES STREET MAINTENANCE 01000 08 .95 STEEL WOOL/BRKPRS FRND/TILE CL 186616 37683/F'20 1090 6242 CLEANING SUPPLIES PARK MAINTENANCE 01000 09 2.37 STEEL WOOL/BRKPRS FRND/TILE CL 186616 37683/1 '20 1093 6242 CLEANING SUPPLIES SENIOR CITIZEN SERVICES 01000 09 .95 STEEL WOOL/BRKPRS FRND/TILE CL 186616 37683/F'20 6202 6242 CLEANING SUPPLIES SEWER OPERATIONS EXPENSE 06200 08 1.02 STEEL WOOL/BRKPRS FRND/TILE CL 186616 37683/F'20 6302 6242 CLEANING SUPPLIES SOLID WASTE OPERATIONS 06300 08 .95 STEEL WOOL/BRKPRS FRND/TILE CL 186616 37683/F'20 6402 6242 CLEANING SUPPLIES STORM WATER UTILITY OPERA 06400 08 .95 STEEL WOOL/BRKPRS FRNDfTILE CL 186616 37683/F'20 6502 6242 CLEANING SUPPLIES WATER UTILITY EXPENSE 06500 08 4,153.47 152126 8/7/2020 117193 PEMBERTON LAW,P.L.L.P. 107.50 JUN'20 HR LEGAL SVS 186609 20196312-000M 1011 6403 LEGAL HUMAN RESOURCES 01000 04 JUNE'20 107.50 152127 8/7/2020 100034 PHILLIPS WINE AND SPIRITS,INC 122.18- WINE ORDER CREDIT 186472 610431 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 147.02 WINE ORDER 186473 6066709 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 2,617.72 WINE ORDER 186474 6066708 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 93.76 LIQUOR&SPIRITS ORDER 166475 6066707 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 170.50 WINE ORDER 186565 6068359 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 547.35 WINE ORDER 186581 6066649 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,266.94 LIQUOR&SPIRITS ORDER 186582 6066648 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 4,721.11 152128 8/7/2020 108759 PROFESSIONAL BEVERAGE SYSTEMS INC 11 33.51 ICE MACHINE REPAIR 186542 47980 1072 6505 EQUIPMENT REPAIR/MAINTENANCE STREET MAINTENANCE 01000 08 33.53 ICE MACHINE REPAIR 166542 47980 1090 6505 EQUIPMENT REPAIR/MAINTENANCE PARK MAINTENANCE 01000 09 33.53 ICE MACHINE REPAIR 186542 47980 6202 6505 EQUIPMENT REPAIR/MAINTENANCE SEWER OPERATIONS EXPENSE 06200 08 33.53 ICE MACHINE REPAIR 186542 47980 6302 6505 EQUIPMENT REPAIR/MAINTENANCE SOLID WASTE OPERATIONS 06300 08 33.53 ICE MACHINE REPAIR 186542 47980 6402 6505 EQUIPMENT REPAIR/MAINTENANCE STORM WATER UTILITY OPERA 06400 08 33.12 ICE MACHINE REPAIR 186542 47980 6502 6505 EQUIPMENT REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 200.75 152129 8/7/2020 100196 QUALITY REFRIGERATION INC 462.00 COOLER CONDENSER REPAIR 186612 0079798 6115 6505 EQUIPMENT REPAIR/MAINTENANCE PILOT KNOB LIQUOR 06100 02 462.00 152130 8/7/2020 112561 RICOH USA,INC 22.03 AUG'20 COPIER FAX CARD LEASE 186494 103918877 1010 6555 RENTAL OF EQUIPMENT ADMINISTRATION 01000 01 865.08 AUG'20 COPIER LEASES 186494 103918877 1010 6555 RENTAL OF EQUIPMENT ADMINISTRATION 01000 01 887.11 152131 8/7/2020 110990 SCHINDLER ELEVATOR CORPORATION 680.43 QTRLY ELEVATOR MAI NT CONTRACT 186647 8105395060 1015 6515 BUILDING REPAIR/MAINTENANCE CITY HALL 01000 01 R55CKS2 LOGIS600V CITY OF FARMINGTON 8/12/2020 9:05:21 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 18 7/1/2020 - 8/11/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 680.43 152132 8/7/2020 116845 SELA 652.75 ROOF LEAK REPAIR 186617 14610 1015 6515 BUILDING REPAIR/MAINTENANCE CITY HALL 01000 01 652.75 152133 8/7/2020 117738 SHAFER CONTRACTING CO INC 50.00 VOID ROW PRMT 33696 186621 VOID ROW PRMT 1001 4350 UTILITY PERMITS GENERAL FUND REVENUES 01000 01 33696 1.50- VOID ROW PRMT 33696 186621 VOID ROW PRMT 1070 6545 PYMT PROCESSING FEES ENGINEERING SERVICES 01000 07 33696 48.50 152134 8/7/2020 107018 SHAMROCK GROUP 169.56 ICE CUBE ORDER 186558 2526306 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 65.96 ICE CUBE ORDER 186559 2526717 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 235.52 152135 8/7/2020 113195 SKYVIEW RANCH,LLC 470.00 PETTING ZOO AT MOVIE IN PARK 186610 4877 1095 6560 CONTRACTUAL SERVICES RECREATION PROGRAM SERVIC 01000 09 470.00 152136 8/7/2020 108220 SOUTH METRO RENTAL INC 300.84 CHOP SAW/BLADES 186234 106783 6502 6950 MACHINERY,EQUIPMENT&TOOLS WATER UTILITY EXPENSE 06500 08 300.84 CHOP SAW/BLADES 186234 106783 6402 6950 MACHINERY,EQUIPMENT&TOOLS STORM WATER UTILITY OPERA 06400 08 300.84 CHOP SAW/BLADES 186234 106783 6202 6950 MACHINERY,EQUIPMENT&TOOLS SEWER OPERATIONS EXPENSE 06200 08 300.84 CHOP SAW/BLADES 186234 106783 1072 6950 MACHINERY,EQUIPMENT&TOOLS STREET MAINTENANCE 01000 08 1,203.36 152137 8/7/2020 112051 SOUTHERN GLAZER'S OF MN 2,492.32 LIQUOR&SPIRITS ORDER 186470 1976805 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 173.12 WINE ORDER 186471 1976804 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 2.56 DELIVERY CHARGE 186584 1976809 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 672.08 WINE ORDER 186585 1976810 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,537.46 LIQUOR&SPIRITS ORDER 186586 1976811 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 5,877.54 152138 8/7/2020 117728 SZUMERIA KUVASZ 96.41 JUL'20 K-9 ODIN BOARDING 186533 K-9 2200 6401 PROFESSIONAL SERVICES K-9(EFF.2019) 02200 05 20200724-20200726 96.41 152139 8/7/2020 100519 TC CONSTRUCTION,INC 3,000.00 ER 21022 FLAGSTONE WAY 186524 ER 21022 FLAGSTON14600 2255 DEPOSITS PAYABLE PRIVATE CAPITAL PROJECTS 04600 07 WAY 3,000.00 R55CKS2 LOGIS600V CITY OF FARMINGTON 8/12/2020 9:05:21 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 19 7/1/2020 - 8/11/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 152140 8/7/2020 112307 T-MOBILE USA INC 6.67 JUL'20 GPS SERVICE 186528 823329497 JULY'20 6502 6412 CELLULAR SERVICES WATER UTILITY EXPENSE 06500 08 6.66 JUL'20 GPS SERVICE 186528 823329497 JULY'20 6202 6412 CELLULAR SERVICES SEWER OPERATIONS EXPENSE 06200 08 6.66 JUL'20 GPS SERVICE 186528 823329497 JULY'20 6402 6412 CELLULAR SERVICES STORM WATER UTILITY OPERA 06400 08 19.99 152141 8/7/2020 100618 TOLL GAS&WELDING SUPPLY 87.91 WELDING SUPPLIES 186619 10363059 7200 6220 EQUIP SUPPLIES&PARTS FLEET OPERATIONS 07200 08 87.91 152142 8/7/2020 110954 ULINE SHIPPING&SUPPLY SPECIALISTS,INC 431.20 N95 MASKS 186205 122037636 1050 6220 00019 EQUIP SUPPLIES&PARTS POLICE ADMINISTRATION 01000 05 431.20 152143 8/7/2020 108808 VINOCOPIA,INC 234.33 WINE ORDER 186594 0260889-IN 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 234.33 152144 8/7/2020 111267 WATER CONSERVATION SERVICE,INC 321.90 LOCATE LEAK EUCLID WAY/ST 186508 10592 6502 6401 PROFESSIONAL SERVICES WATER UTILITY EXPENSE 06500 06 321.90 152145 817/2020 117211 WE SHINE WINDOWS,LLC 60.00 OUTSIDE WINDOW CLEANING SVS 186653 1104 6110 6515 BUILDING REPAIR/MAINTENANCE DOWNTOWN LIQUOR REV&EXP 06100 02 60.00 152146 8/7/2020 102592 WINE COMPANY,THE 157.00 JCARVER STRAIGHT BOURBON ORDER 186595 147846 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 157.00 152147 8/7/2020 100330 WINEBOW 342.75 WINE ORDER 186583 MN00081694 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 342.75 20200715 7/31/2020 109509 US BANK 15,525.00 SERIES 2019A 2020 INT WATER 185397 1613279 6502 7120 DEBT INTEREST WATER UTILITY EXPENSE 06500 08 19,500.00 SERIES 2019A 2020 INT STREET 185397 1613279 3138 7120 DEBT INTEREST 2019A GO CAPITAL IMP BOND 03138 02 61,925.00 SERIES 2016B 2020 INTEREST 185680 1617189 3136 7120 DEBT INTEREST GO CAP IMP PLAN REFUND 20 03136 02 12,400.00 SERIES 2013A2020 INTEREST 185680 1617189 3091 7120 DEBT INTEREST 2013A GO IMP REFUNDING BO 03091 02 29,300.00 SERIES 2015A 2020 INTEREST 185680 1617189 3093 7120 DEBT INTEREST 2015A 195TH ST RECONSTR P 03093 02 15,20D.00 SERIES 2016A 2020 INTEREST 185680 1617189 3094 7120 DEBT INTEREST GO REFUNDING 2016A 03094 02 153,850.00 20200716 7/31/2020 116053 109 ELM,LLC 12,394.58 AUG'20 DT LIQUOR STORE RENT 186146 AUGUST 2020 6110 6556 BUILDING RENTAL DOWNTOWN LIQUOR REV&EXP 06100 02 12,394.58 20200717 7/30/2020 114654 INVOICE CLOUD R55CKS2 LOGIS600V CITY OF FARMINGTON 8/12/2020 9:05:21 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 20 7/1/2020 - 8/11/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 549.01 JUN'20 IC PYMT FEES 186452 819-2020_6 6202 6545 PYMT PROCESSING FEES SEWER OPERATIONS EXPENSE 06200 08 549.01 JUNTO IC PYMT FEES 186452 819-2020_6 6302 6545 PYMT PROCESSING FEES SOLID WASTE OPERATIONS 06300 08 549.01 JUNTO IC PYMT FEES 186452 819-2020_6 6402 6545 PYMT PROCESSING FEES STORM WATER UTILITY OPERA 06400 08 549.02 JUNTO IC PYMT FEES 186452 819-2020_6 6502 6545 PYMT PROCESSING FEES WATER UTILITY EXPENSE 06500 08 2,196.05 20200718 7/30/2020 116040 HRMDIRECT INC 10,977.12 RECRUITING PLATFORM ANNUAL FEE 186489 04238 7400 6505 EQUIPMENT REPAIR/MAINTENANCE INFORMATION TECHNOLOGY 07400 04 10,977.12 20200719 712812020 102160 CARDMEMBER SERVICES 42.53 JUN'20 CELL PHONE SERVICE 185839 6913-7979-6/18 2000 6412 20 CELLULAR SERVICES-DBB HRA/ECONOMIC DEVELOPMENT 02000 03 1,227.29 JUN'20 VERIZON DATA SERVICE 185839 6913-7979-6/18 7400 6412 CELLULAR SERVICES INFORMATION TECHNOLOGY 07400 04 3,082.55 JUNTO CELL PHONE SERVICE 185839 6913-7979-6/18 7400 6412 CELLULAR SERVICES INFORMATION TECHNOLOGY 07400 04 1,037.34 BB POLE/BACKBRD FTGN PRESRV PK 185842 5604-2036-6/15 2300 6950 MACHINERY&EQUIPMENT PARK IMPROVEMENT FUND 02300 09 184.00 MFF GAS MASK FILTERS 185936 4021-8854-6/9 1051 6220 EQUIP SUPPLIES&PARTS PATROL SERVICES 01000 05 335.72 RPLCMNT BATTERIES:AED 185938 4021-9307-6/26 1051 6220 EQUIP SUPPLIES&PARTS PATROL SERVICES 01000 05 15.95 DISH WAND SPONGE HEADS 185939 4021-9638-6/12 1050 6242 CLEANING SUPPLIES POLICE ADMINISTRATION 01000 05 85.77 BATTERIES AA,AAA,C,D,9V 185939 4021-9638-6/12 1050 6220 EQUIP SUPPLIES&PARTS POLICE ADMINISTRATION 01000 05 .99 JUN'20 ICLOUD STRGE SIEBENALER 185941 6913-8790-6/8 1014 6412 CELLULAR SERVICES COMMUNICATIONS 01000 01 11.38 USB CABLE(2):SQUAD PRINTER 185942 0915-3716-6/22 1051 6220 EQUIP SUPPLIES&PARTS PATROL SERVICES 01000 05 161.88 OTTERBOX PHONE CASES(3) 185943 0915-4060-6/19 7400 6220 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 15.18 USB CABLE(2):SQUAD PRINTER 185944 0915-9093-6/19 1051 6220 EQUIP SUPPLIES&PARTS PATROL SERVICES 01000 05 10.00 USB CABLE(2):SQUAD PRINTER 185945 0915-8468-6/17 1051 6220 EQUIP SUPPLIES&PARTS PATROL SERVICES 01000 05 8.99 SERIAL TO USB ADPT-MTRREAD 185946 0915-6251-6/17 7400 6220 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 8.99 SERIAL TO USB ADPT-SCHIMMEL 185947 0915-6485-6/9 7400 6220 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 215.89 SCANNERS(2)FOR PK REGISTERS 185948 0915-0176-6/8 6115 6220 EQUIP SUPPLIES&PARTS PILOT KNOB LIQUOR 06100 02 13.89- 185948 0915-0176-6/8 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 79.85 BINGO CARDS 185949 3544-8116-6/25 1093 6570 PROGRAMMING EXPENSE SENIOR CITIZEN SERVICES 01000 09 27.49 LAMINATING SUPPLIES 185950 3544-8699-6/12 1093 6210 OFFICE SUPPLIES SENIOR CITIZEN SERVICES 01000 09 464.00 TOUCHLESS HAND SANT[DISP(8) 185951 3544-7388-6/12 1093 6950 00019 MACHINERY,EQUIPMENT&TOOLS SENIOR CITIZEN SERVICES 01000 09 14.35 SUMMER PRKADVENTURES SUPPLIES 185952 3544-1190-6/26 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 4.29 SUMMER PRKADVENTURES SUPPLIES 185953 3544-8565-6/26 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 162.71 BANNERS:MUSIC/MOVIES IN PARK 185954 3544-7071-6/25 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 6.98 STYLUS FOR TOUCH SCREEN 185955 3544-0000-6/8 1093 6220 EQUIP SUPPLIES&PARTS SENIOR CITIZEN SERVICES 01000 09 69.98 LAMINATING POUCHES 185956 6984-9587-6/11 1095 6210 OFFICE SUPPLIES RECREATION PROGRAM SERVIC 01000 09 79.25 LEARN TO SKATE DUES:WALL,J. 185957 6984-0177-6/19 2502 6460 MEMBER DUES&LICENSURE ICE ARENA OPERATIONS EXPE 02500 09 100.00 COACHES INS:LEARN TO SKATE 185958 6984-8981-6/19 2502 6426 INSURANCE ICE ARENA OPERATIONS EXPE 02500 09 130.00 PROF SKTRS ASSOC DUES:WALL,J 185959 6984-1033-6/19 2502 6460 MEMBER DUES&LICENSURE ICE ARENA OPERATIONS EXPE 02500 09 70.00 2020/21 COACH/CHOR PRG MOD 3 185959 6984-1033-6/19 2502 6470 TRAINING&SUBSISTANCE ICE ARENA OPERATIONS EXPE 02500 09 78.18 MEALS:LADDR TRK INSP. 185960 8801-4112-6/26 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01000 06 37.98 MEALS:LADDR TRK INSP. 185961 8801-8005-6/25 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01000 06 67.92 DINNER FOR LIVE BURN TRAINING 185962 6125-4012-6124 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01000 06 R55CKS2 LOGIS600V CITY OF FARMINGTON 8/12/2020 9:05:21 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 21 7/1/2020 - 8/11/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept Div 387.00- RFND FDIC INT'L CNF:ELVESTAD, 185963 6133-1500-6/25 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01000 06 604.96 ENRGY(3)/ACCESS(3)CODE 185964 8032-8003-6/9 1031 6280 BOOKS&SUBSCRIPTIONS BUILDING INSPECTIONS 01000 07 16.06 JUL'20 ZOOM SUBSCRIPTION 185965 5212-2266-6/25 2000 6280 20 BOOKS&SUBSCRIPTIONS-DBB HRA/ECONOMIC DEVELOPMENT 02000 03 19.95 JUN'20 EPERMITS PAYPAL FEES 186072 6913-4954-7/6 1031 6545 PYMT PROCESSING FEES BUILDING INSPECTIONS 01000 07 122.08 MUSIC LICENSE FEE 2020-2021 186073 5604-5730-6/24 2502 6280 BOOKS&SUBSCRIPTIONS ICE ARENA OPERATIONS EXPE 02500 09 122.09 MUSIC LICENSE FEE 2020-2021 186073 5604-5730-6/24 1093 6280 BOOKS&SUBSCRIPTIONS SENIOR CITIZEN SERVICES 01000 09 122.09 MUSIC LICENSE FEE 2020-2021 186073 5604-5730-6/24 1095 6280 BOOKS&SUBSCRIPTIONS RECREATION PROGRAM SERVIC 01000 09 1,114.98 REFRIGERATOR CITY HALL 186074 5604-0155-7/7 1015 6960 FURNITURE,OFFICE EQUIP,IT CITY HALL 01000 01 259.75 INK FOR POSTAGE MACHINE 186075 6913-3001-7/2 1010 6220 EQUIP SUPPLIES&PARTS ADMINISTRATION 01000 01 122.50 PE LICENSE RENEWAL-GEHLER,K. 186076 6976-4328-7/1 1070 6460 MEMBER DUES&LICENSURE ENGINEERING SERVICES 01000 07 50.40 DISP-VGA FOR HUB LAP DOCKS(6) 186077 0915-7930-7/1 7400 6220 00019 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 34.77 HDMI-VGA FOR HUB LAP DOCKS(3) 186077 0915-7930-7/1 7400 6220 00019 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 2,849.97 HP LAPTOPS FOR HUB @ PD(3) 186078 6913-7958-7/6 7400 6960 00019 FURNITURE,OFFICE EQUIP,IT INFORMATION TECHNOLOGY 07400 04 243.64 3 UPS FOR PK REGSTRS&NTWKRACK 186079 0915-8464-6/30 6115 6220 EQUIP SUPPLIES&PARTS PILOT KNOB LIQUOR 06100 02 15.67- 186079 0915-8464-6/30 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 584.97 LPTOP DOCKS 4 HUB AT PD(3) 186080 6913-4326-7/1 7400 6220 00019 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 57.09 OTTERBOX PHONE CASE(1) 186081 0915-3595-6/29 6302 6220 EQUIP SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 3.67- 186081 0915-3595-6/29 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 25.90 SCREEN PROTECTORS 4 IPHONES(2) 186082 0915-2866-6/29 7400 6220 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 57.09 OTTERBOXPHONE CASE 4 SOLWASTE 186083 0915-6368-6/29 6302 6220 EQUIP SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 3.67- 186083 0915-6368-6/29 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 695.00 INTERNALAFFAIRS TRNG:LUTZ,C 186084 4021-6592-6/29 1051 6470 TRAINING&SUBSISTANCE PATROL SERVICES 01000 05 190.64 JUMP START PACKS 186085 4021-4756-7/1 1051 6220 EQUIP SUPPLIES&PARTS PATROL SERVICES 01000 05 11.99 FORFEITURE KEY TAGS 186086 4021-3296-7/2 2100 6220 EQUIP SUPPLIES&PARTS POLICE FORFEITURES 02100 05 57.60 DOOR PRESSURE GAUGE 186087 4021-7129-6/29 1060 6220 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 .99 JUL'20 ICLOUD STRGE SIEBENALER 186088 6913-3077-7/6 1014 6412 CELLULAR SERVICES COMMUNICATIONS 01000 01 58.90 JUL'20 ZOOM LIC:A KIENBERGER 186282 0915-9414-7/1 7400 6505 00019 EQUIPMENT REPAIR/MAINTENANCE INFORMATION TECHNOLOGY 07400 04 58.91 JUL'20 ZOOM LIC.:L SIEBENALER 186282 0915-9414-7/1 7400 6505 00019 EQUIPMENT REPAIR/MAINTENANCE INFORMATION TECHNOLOGY 07400 04 57.67 OTTERBOXPHONE CASE 4 SOLWASTE 186283 0915-4857-7/2 7400 6220 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 3.71- 186283 0915-4857-7/2 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 57.08 OTTERBOXPHONE CASE 4 SOLWASTE 186284 0915-5282-7/1 7400 6220 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 3.67- 186284 0915-5282-7/1 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 57.66 OTTERBOXPHONE CASE 4 SOLWASTE 186285 0915-9810-7/1 7400 6220 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 3.71- 186285 0915-9810-7/1 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 434.97 MONITORS 4 HUB(3) 186286 6913-5266-7/2 7400 6220 00019 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 74.97 MOUSE/KEYBOARD 4 HUB(3) 186286 6913-5266-7/2 7400 6220 00019 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 149.85 LAPTOP CASES 4 HUB(3) 186286 6913-5266-712 7400 6220 00019 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 38.97 DISPLAY-HDMI 4 HUB(3) 186286 6913-5266-7/2 7400 6220 00019 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 51.97 CLEANING SUPPLIES AND MASKS 186287 6984-2295-7/7 1095 6570 00019 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 387.00- RFND:2020 FDIC CONF:SCHMITZ 186453 6125-8205-7/21 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01000 06 149.85- LAPTOP CASE RETURN 186467 6913-9978-7/8 7400 6220 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 60.00- RFND:CRTCL INCDNTS SEM-SAUTER 186534 4021-4819-7/8 1051 6470 TRAINING&SUBSISTANCE PATROL SERVICES 01000 05 R55CKS2 LOGIS600V CITY OF FARMINGTON 8/12/2020 9:05:21 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 22 7/1/2020 - 8/11/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 15,211.05 20200720 7/27/2020 100085 DAKOTA ELECTRIC ASSOCIATION 17.60 JUN'20 PK CITY SIGN NORTH ENTR 185752 200010011266 1090 6422 ELECTRIC PARK MAINTENANCE 01 D00 09 JUNE'20 223.12 JUN'20 ELEC DNMRK/SPRCE ST LTS 185825 200004222477 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 JUNE'20 15.88 JUNTO ELEC WELL#9 185830 200010028004 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 JUNE'20 18.83 JUN'20 ELEC 220TH ST LIFT STN 185831 200001405224 6202 6422 ELECTRIC SEWER OPERATIONS EXPENSE 06200 08 JUNE'20 538.68 JUNTO ELEC FIRE STATION 1 185861 200001679489 1060 6422 ELECTRIC FIRE SERVICES 01000 06 JUNE'20 34.57 JUN'20 ELEC PARK&REC SIGN 186522 200002260479 1090 6422 ELECTRIC PARK MAINTENANCE 01000 09 JUNE'20 18.36 JUNTO ELEC SPRUCE ST MNMNT LT 186544 200004099123 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 JUNE'20 867.04 20200801 8/5/2020 115438 AMERITAS LIFE INSURANCE CORP 6,611.52 JUL-20 DENTAL INSURANCE 186608 010-4446 JULY'20 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 6,611.52 20200802 8/3/2020 100085 DAKOTA ELECTRIC ASSOCIATION 509.90 JUNTO ELEC FIRE STATN#2 186052 200003971959 1060 6422 ELECTRIC FIRE SERVICES 01000 06 JUNE'20 5.15 JUN'20 ELEC CIV DEF SIREN 186069 200001982271 1054 6422 ELECTRIC EMERGENCY MGMT SERVICES 01000 05 JUNE'20 6,284.85 JUN-20 ELEC 9TH ST STREET LTS 186138 200001038421 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 JUNE'20 2,711.05 JUN-20 ELEC WELL#5 186139 200002785533 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 JUNE'20 32.82 JUNTO ELEC TUNNEL LIGHT 186183 200005468327 1090 6422 ELECTRIC PARK MAINTENANCE 01000 09 JUNE'20 5.15 JUN'20 ELEC CIV DEF SIREN 186532 200002260958 1054 6422 ELECTRIC EMERGENCY MGMT SERVICES 01000 05 JUNE'20 1,581.37 JUN-20 ELEC PK LIQ STORE 186655 200003759891 6115 6422 ELECTRIC PILOT KNOB LIQUOR 06100 02 JUNE'20 23.44 JUNTO ELEC DAISY KNOLL TOWER 186664 200001318518 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 JUNE'20 1,998.96 JUN'20 ELEC WELL#4 186665 200001318526 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 JUNE'20 3,258.54 JUN'20 ELEC WELL#6 186666 200001550151 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 JUNE'20 R55CKS2 LOGIS600V CITY OF FARMINGTON 8/12/2020 9:05:21 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data seiection. Council Check Summary Page- 23 7/1/2020 - 8/11/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 2,568.27 JUN'20 ELEC WELL#7 186667 200003490737 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 JUNE'20 153.12 JUN'20 ELEC 195TH WATER TOWER 186668 200002587095 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 JUNE'20 122.63 JUN'20 ELEC VERM GROVE LS 186669 200003215779 6202 6422 ELECTRIC SEWER OPERATIONS EXPENSE 06200 08 JUNE'20 2,274.64 JUN'20 ELEC WELL#8 186670 200004199709 6502 6422 ELECTRIC - WATER UTILITY EXPENSE 06500 08 JUNE'20 21,529.89 20200803 8/4/2020 112399 DEARBORN LIFE INSURANCE COMPANY 1,154.60 AUG-20 STD INSURANCE PREMIUMS 186605 019839-1 AUG'20 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 1,154.60 JUL'20 STD INSURANCE PREMIUMS 166606 019639-1 JULY'20 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 2,309.20 20200804 8/4/2020 115445 HEALTH PARTNERS 81,846.50 AUG-20 HEALTH INSURANCE 186607 98479255 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 81,846.50 20200805 8/6/2020 108980 MINNESOTA ENERGY RESOURCES CORPORATION 16.00 JUL'20 GAS 208TH ST WARM HOUSE 186635 0506537561 JULY'20 1090 6423 NATURAL GAS PARK MAINTENANCE 01000 09 1 B.00 20200806 8/3/2020 100135 PUBLIC EMPLOYEES RETIREMENT ASSN. 23,525.47 186445 0730201035001 7000 2113 PERA PAYABLE EMPLOYEE EXPENSE FUND 07000 02 31,274.00 186446 0730201035002 7000 6154 PERA EMPLOYEE EXPENSE FUND 07000 02 54,799.47 20200807 8/5/2020 100394 XCEL ENERGY 6,231.83 JUN-20 ELEC NON-METER ST LTS 166227 51-4874005 JUNE'20 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 7.12 JUN'20 ELEC CITY GARAGE 186227 51-4874005 JUNE'20 1090 6422 ELECTRIC PARK MAINTENANCE 01000 09 .68- 186227 51-4874005 JUNE'20 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 4.27 JUN'20 ELEC CITY GARAGE 186227 51-4874005 JUNE'20 1072 6422 ELECTRIC STREET MAINTENANCE 01000 08 2.85 JUN'20 ELEC CITY GARAGE 186227 51-4874005 JUNE'20 6402 6422 ELECTRIC STORM WATER UTILITY OPERA 06400 08 10.55 JUNTO ELEC CITY GARAGE 186227 51-4874005 JUNE'20 6302 6422 ELECTRIC SOLID WASTE OPERATIONS 06300 08 105.44 JUN'20 ELEC CITY GARAGE 186227 51-4874005 JUNE'20 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 12.82 JUN'20 ELEC CITY GARAGE 186227 51-4874005 JUNE'20 6202 6422 ELECTRIC SEWER OPERATIONS EXPENSE 06200 08 124.80 JUN'20 ELEC ROUNDABOUT 186227 51-4874005 JUNE'20 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 53.15 JUN'20 ELEC TRAFFIC SIGNAL 186227 51-4874005 JUNE'20 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 58.81 JUNTO ELEC LIFT STATIONS 186227 51-4874005 JUNE'20 6202 6422 ELECTRIC SEWER OPERATIONS EXPENSE 06200 08 3,093.06 JUN-20 ELEC WELL#1&3 186227 51-4874005 JUNE'20 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 39.59 JUN'20 ELEC DOWNTOWN ST LTS 186227 51-4874005 JUNE'20 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 9,743.61 Report Totals 1,296,748.11 APPROVALS: LARSON BERNHJELM CRAIG DONNELLY (j�--HOYT CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 IIIIIIIIII� ® Farmington MN.gov TO: Mayor, Councilmembers and City Administrator FROM: Randy Distad, Parks and Recreation Director SUBJECT: Schmitz-Maki Arena Rubber Floor Replacement Project DATE: August 17, 2020 INTRODUCTION A request is being made to spend a portion of the$200,000 in liquor store profits that were transferred to Schmitz-Maki Arena Capital I mprovement Projects Fund. The request is to replace the arena's rubber flooring material. DISCUSSION Previously staff had discussed with the City Council at the July 13, 2020 work session a request to have $200,000 in liquor store profits be transferred to the Arena Capital I mprovement Fund in order to complete a number of identified capital improvement projects. One of the projects identified was to replace the existing rubber file floor throughout the building,with the exception of the men's public restroom rubber file floor because it was replaced this summer. The rubber file floor in the lobby,women's public restroom and team room#1 and#2 area was last replaced in 2005.The rubber file floor in team room 5 and 6 has not been replaced since these team rooms were built in the 1990's. Given the age and condition of the rubber tile floors in these areas of the arena, staff solicited proposals to have the existing rubber file floor removed and new rubber file flooring installed. Staff solicited proposals from two companies that sell and install the same rubber file floor that was installed by staff this summer in the men's public restroom. This is so that the rubber file floor installed in the men's restroom will match the rubber file floor that will be installed in the other areas of the arena. The rubber file floor provides a needed protection for skaters so they can walk to and from the team rooms and restrooms without touching the concrete floor,which would dull the blades of the skates. Attached is a tabulation of the proposals received from the two companies. As you can see, All American Arena Products, LLC submitted the low quote for this work in the amount of$76,750.00. Included in your meeting packet is the proposal submitted by All American Arena Products, LLC,.The proposal is inclusive of removing and disposing of the existing rubber flooring material and replacing it with new rubber flooring material. I n addition to staff recommending that the arena's rubber flooring material be replaced, Farmington Youth Hockey Association also identified this as one of the arena projects they would like to see completed this year. BUDGET IMPACT Staff had previously estimated the cost of replacing the rubber flooring material in the Arena at $80,000.00.The actual cost of the project based on the low quote submitted by All-American Arena Products, LLC is$76,750.00. This is $3,250.00 under the estimated cost. Funding to replace the rubber flooring material will come from the$200,000.00 in Farmington Liquor Store profits that were transferred to the arena's Capital I mprovement Fund. This means after this project is completed,there will still be$123,250.00 remaining from the liquor store profit transfer that can be used for other arena capital projects that staff previously identified. ACTION REQUESTED Staff is requesting the city council approve a contract with All American Arena Products, LLC in the amount of$76,750.00 to replace the arena's rubber flooring material and authorize the Mayor and City Administrator to sign the contract. ATTACHMENTS: Type Description D Backup Material Quote Tabulation Form D Backup Material All American Arena Products Proposal 2020 Arena Rubber Flooring Replacement Project Bid Tabulation Form Contractor Name Total Bid Amount All American Arena Products 76,750.00 Becker Arena Products 84,432.70 AGREEMENT AGREEMENT made this 171h day of August, 2020, between the CITY OF FARMINGTON, a Minnesota municipal corporation ("City"), and ALL AMERICAN ARENA PRODUCTS,LLC 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 quote dated August 6,2020 and 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"having the last priority. 2. OBLIGATIONS OF THE CONTRACTOR. The Contractor shall provide the goods,services,and perforin 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 December 1,2020. 7. PAYMENT. a. When the obligations of the Contractor have been fulfilled,inspected,and accepted, the City shall pay the Contractor$76,750.00.Such payment shall be made not later than thirty(30) days after completion,certification thereof;and invoicing by the Contractor. b. 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-excced 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%:%)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: 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 2 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 Properly 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 receives a request to release data, Contractor must immediately notify City. City will give Contractor instructions concerning the release of the data to the requesting party before the data is released Contractor agrees to defend, indemnify,and hold City, its officials, officers, agents, employees, and volunteers harmless from any claims resulting from Contractor's officers', agents', city's, partners', employees', volunteers', assignees' or subcontractors'unlawful disclosure and/or use of protected data. The terms of this paragraph shall survive the cancellation or termination of this Agreement. 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 wan-antics 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 3 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}�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. 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 renders this Contract impossible to perform. Such remaining terms and conditions of the Contract shall continue in full force and effect and shall continue to operate as the parties'entire contract. 20. ENTIRE AGREEMENT. This Contract represents the entire agreement of the parties and is a final,complete,and all-inclusive statement of the terns 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. 4 Dated: 2020 CITY OF FARMINGTON By: Todd Larson, Mayor w c fay: 6 cL avid McKnight, i Admin trator Dated: ,2020 CONTRACTOR: ALL AMERICAN ARENA PRODUCTS, LLC By:. Its: (�S�rJ 5 "Op A ALLAMERICAN ARENA PRODUCTS 100 W. Mail)S11-cel Iii? {dux'35).5 t11dcIL IVI V ')6009 (8,14) 231-2227 scsw!++�:xllan�crirararcua.rom August 11, 2020 QUOTATION Attention: Jeremy Pire Schmitz-Maki Arena 114 Spruce St, Farmington, MN 55024 Project: Rubber Flooring Dear Jeremy, Thank you for the opportunity to submit a quote to demo, supply, and install rubber flooring/base. Summary of scope of work by All American Arena Products will include: SCOPE OF WORK: Entryway, locker rooms, bathrooms, hallways • Supply. install, demo and disposal of rubber flooring o Approximately 4950 sf • Furnish and install Stamina Reaction Tile -Matte-630 Charcoal 10mm o Includes material. adhesive, installation and shipping o Color(1'131)) o Includes base • Finish accessories as needed (transitions. reducers. caulk, etc.) • All demo and disposal are done by All American Arena Products Supply, install, demo and disposal price- Base bid- $76,750 Price is valid for 30 days. Unless stated otherwise, pricing does not include permits, bonding, shipping, or any local and/or state sales tax. The attached Terms and Conditions are incorporated and part of this quote. If you have any questions or need additional information, please feel free to give us a call. Accept 61-1-- Decline The above proposal is accepted by Purchaser: PresidenUOwner/General Manager All-American Arena Products ALLAMERICAN ARENA PRODUCTS 100\\'..faits street l't} BoX:3.3.1 Aldeii,MN 360 09 'To c�cf � (ti:t!)'x:31-`1`2`?7 4 r sari scant%ball:unericaIlarena.r0n1 Name of Signee (please print) Date: _�' foo bate; TERMS AND CONDITIONS 1. All sales of material or equipment by All-American Ice,LLC(DBA All-American Arena Products)("All-American")are expressly conditioned upon the terms and conditions set forth below.Any additional or different terms or conditions set forth in any purchase order of the Buyer or in any similar such communication are hereby objected to by All- American and shall not be binding or effective unless expressly assented to in writing by an authorized representative of All-American, 2. SITE: The site must be accessible to a tractor-trailer and industrial forklift.All driveways to the rink slab/surface must support all necessary equipment. Power outlets with no less than a 30amp breaker must be within 50'of the rink slab/surface or a portable generator with a minimum of 5KW power rating. Prior to commencement,surface must be broom clean and work area will be free of all materials and debris.A dumpster(minimum size of 10 yards)and/or an area for trash must be available within 100'of the rink slab/surface so the installers can remove their debris. Delays or extra work and expenses caused by the site not being ready will be charged to the Purchaser. Concrete to be level within 1/8"in 10 ft.non-cumulative. 3. PRICE: Prices subject to receipt of final construction drawings and specifications.This quotation is based on the installation taking place from start to finish during the same trip.Re-mobilizing for any reason other than All-American Arena's own,will result in extra charges. 4. INSURANCE: Special insurance requirements are not included. S. PERMITTING: Any applicable Permits and/or License Fees are not included,and Purchaser shall be responsible for obtaining the same, 6. COMPLETION: When job is completed or nearing completion,the Purchaser must be available for a final walk-through to inspect the installation with the All-American installation Supervisor.'This will be the Purchaser's chance to formulate a final punch list of items left unfinished or needing to be changed.All items not listed on the punch list will not be considered a punch list item,and unless covered by All-American warranty,will be replaced at the Purchaser's expense, 7. DELAY: Notwithstanding the foregoing,should All-American be delayed in the commencement,prosecution or completion of the work by any cause beyond All-American's control and not due to any fault,neglect,act or omission on its part,then Ali-American shall be entitled to an extension of time to the extent necessary to remove any such cause of any delay and shall not be held liable for any damages for any delays caused by either the owner or general contractor or cause beyond the control of All-American. 8. WARRANTY: Except as to title,THERE ARE NO WARRANTIES,WRITTEN,ORAL, IMPLIED,OR STATUTORY relating to the described material or equipment which extend beyond that described in this paragraph.NO WARRANTY OF MERCHANTABILITY OR OF FITNESS FOR PURPOSE SHALL APPLY. Any product warranties provided by All-American Arena Product suppliers shall be assigned to the Purchaser to the extent possible. 9, SECURITY: All-American retains a security interest in all the products covered in this agreement until all sales'terms have been met. E74 ALLAMERICAN AugARENA PRODUCTS 100 W. Main street Udell, M riii009 (H I:f) 2131-2'2'27 +can�+allamcrirauarciri.r�>m 10. PAYMENT:Terms are Net 30 or as otherwise agreed upon. Late payments are subject to a 1.5 percent per month or 18 percent annual finance charge. 11. LIMITED LIABILITY: All-American's liability on any claim for loss or damage arising out of this contract or from the performance or breach thereof or connected with the supplying of material or equipment hereunder,or its sale,resale, operation or use,whether based on warranty,contract,negligence or other grounds shall comply with State of Minnesota requirements as laid out in the contract with the City of Farmington dated 8-17-2020. 12. ATTORNEY'S FEES,JURISDICTION,AND VENUE: Purchaser agrees that making any purchases from All-American constitutes doing business in the state of MINNESOTA and that Buyer consents to the personal jurisdiction of the state and federal courts in MINNESOTA, unless elected otherwise by All-American.Purchaser agrees that the venue to resolve any and all disputes with All-American shall exclusively lie in the state or federal courts situated in Dakota County, MINNESOTA. Buyer agrees that in the event of any legal action brought by or against All-American,the non- prevailing party shall pay to the prevailing party all costs and expenses incurred in connection with such action, including but not limited to attorney's fees(whether hourly or contingent),lien fees,court costs and any other costs of litigation or collection proceedings(including without limitation expert witness fees,deposition or court transcript fees, photocopy charges,and document vendor charges). 13. ONE-YEAR LIMITATION: Any and all claims brought by Purchaser against Seller shall be filed in one of the above referenced jurisdictions within one(1)year after the date of shipment or installation or it shall be deemed forever waived. CITY OF O 430 Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 �o ® Farmington MN.gov TO: Mayor, Councilmembers and City Administrator FROM: David McKnight, City Administrator SUBJECT: City Administrator Annual Performance Review DATE: August 17, 2020 INTRODUCTION The annual performance review of City Administrator David McKnight is held in the August/September timeframe to coincide with his employment anniversary of August 29, 2011. DISCUSSION Pursuant to Minnesota Statute 13D.05, Subd. 3A,the city council may go into closed session to conduct the performance evaluation of an individual subject to their authority. The city council must summarize the conclusion of the performance review at the next regular meeting. The annual performance review will be attended by the five city councilmembers,the city administrator and the city attorney. BUDGET IMPACT NA ACTION REQUESTED A motion should be made to go into closed session to conduct the annual performance evaluation of City Administrator David McKnight as authorized by Minnesota Statute 13D.05.