Loading...
HomeMy WebLinkAbout05.04.20 Council Packet CITY OF Meeting Location: FARMINGTON Farmington City Hall 430 Third Street Farmington,MN 55024 CITY COUNCIL REGULAR MEETING AGENDA May 4, 2020 7:00 P.M. Action Taken 1. CALL TO ORDER 7.00 P.M. 2. PLEDGE OFALLEGL4NCE 3. ROLL CALL 4. APPROVE AGENDA S. ANNOUNCEMENTS I COMMENDATIONS a) Dakota County Commissioner Mike Slavik Information Received b) Proclaim May 2020 as Mental Health Month Proclaimed 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 April 13, 2020, City Council Meeting— Administration Approved b) Approve Agreement Schmitz-Maki Arena Exclusive Vending Service— Parks Approved c) Approve Rambling River Center Advisory Board Bylaws—Parks Approved d) Approve Recommendation for Hire Police Department—Human Resources Approved e) Approve One-Year Extension of C1earCompany Contract—Human Resources Approved f) Acknowledge Financial Review for the Quarter Ending March 31, 2020 - Finance Acknowledged g) Approve Bills - Finance Approved REGULAR AGENDA 8. PUBLIC HEARINGS 9. AWARD OF CONTRACT 10. PETITIONS,REQUESTSAND COMMUNICATIONS 11. UNFINISHED BUSINESS 12 NEW BUSINESS a) Fiber Optic Indefeasible Right to Use Agreement By and Between the City of Farmington and the Dakota Broadband Board Approved b) Update on City Response to the COVID Pandemic Information Received 13. CITY COUNCIL ROUNDTABLE 14. ADJOURN CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-280-6800 1�� ® FarmingtonMN.gov TO: Mayor, Councilmembers and City Administrator FROM: SUBJECT: This meeting will be a virtual meeting held on Zoom. Anyone wishing to participate in the meeting should email communications@farmingtommn.gov prior to noon on Monday, May 4, 2020.The meeting will be broadcast on channel 180 and online. DATE: May 4, 2020 CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-280-6800 III ® Farmington M N.gov TO: Mayor, Councilmembers and City Administrator FROM: David McKnight, City Administrator SUBJECT: Dakota County Commissioner Mike Slavik DATE: May 4, 2020 INTRODUCTION County Commissioner Mike Slavik will provide an update on the county's response to the current pandemic as a part of the city council meeting. DISCUSSION NA BUDGET IMPACT NA ACTION REQUESTED Ask any questions you may have of Commissioner Slavik. CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON 651-28o-6800 OFarmington MN.gov TO: Mayor, Councilmembers and City Administrator FROM: David McKnight, City Administrator SUBJECT: Proclaim May 2020 as Mental Health Month DATE: May 4, 2020 INTRODUCTION The city has been asked to consider making a proclamation making May 2020 as Mental Health Month in Farmington. Councilmember Hoyt brought this request forward. DISCUSSION NA BUDGET IMPACT NA ACTION REQUESTED Proclaim May 2020 as Mental Health Month in Farmington. ATTACHMENTS: Type Description ❑ Backup Material Mental Health Month Proclamation CITY OF FARMINGTON -o PROCLAMATION Mental Health Month 2020 WHEREAS, mental health is essential to everyone's overall health and well-being; and WHEREAS, all Americans face challenges in life that can impact their mental health; and WHEREAS, prevention is an effective way to reduce the burden of mental health conditions; and WHEREAS, there are practical tools that all people can use to improve their mental health and increase resiliency; and WHEREAS, mental health conditions are real and prevalent in our nation; and WHEREAS, with effective treatment, those individuals with mental health conditions can recover and lead full, productive lives; and WHEREAS, each business, school, government agency, healthcare provider, organization and citizen shares the burden of mental health problems and has a responsibility to promote mental wellness and support prevention efforts. THEREFORE, I, Todd Larson, Mayor of Farmington, do hereby proclaim May 2020 as Mental Health Month in Farmington. As the Mayor, I also call upon the citizens, government agencies, public and private institutions, businesses and schools in Farmington to commit our community to increasing awareness and understanding of mental health, the steps our citizens take to protect mental health, and the need for appropriate and accessible services for all people with mental health conditions. PROCLAIMED this 4th day of May 2020. / o son, ayor CITY OF O 43o Third St„ Farmington, MN 55024 FARMINGTON © 651-28o-6800 ■II■�I O Farmington M N.gov TO: Mayor, Councilmembers and City Administrator FROM: David McKnight, City Administrator SUBJECT: Approve Minutes of the April 13, 2020 City Council Meeting-Administration DATE: May 4, 2020 INTRODUCTION Attached for your review are the minutes from the April 13, 2020 city council meeting. DISCUSSION NA BUDGET IMPACT NA ACTION REQUESTED Approve the minutes of the April 13, 2020 city council meeting. ATTACHMENTS: Type Description D Cover Memo April 13, 2020 City Council Minutes CITY OF FARMINGTON CITY COUNCIL MINUTES REGULAR MEETING APRIL 13, 2020 1. Call to Order Mayor Larson called the meeting to order at 7:00 p.m. This meeting was a virtual meeting conducted on Zoom due to the COVID pandemic. 2. Pledge of Allegiance Mayor Larson shared that the pledge would not be conducted during virtual meetings due to issues with broadcast delays. 3. Roll Call Present-Larson, Bernhjelm, Craig, Donnelly and Hoyt Absent-None Staff Present-Administrator McKnight, Public Works Director Gehler, Communications Specialist Siebenaler and Attorney Jamnik. 4. Agenda Motion by Bernhjelm, second by Hoyt,to approve the agenda as presented. APIF, motion carried. S. Announcements/Commendations None 6. Citizen Comments None 7. Consent Agenda Motion by Hoyt, second by Bernhjelm,to approve the consent agenda as printed: a) Approve Minutes of the March 16, 2020 Special City Council Meeting-Administration b) Approve Minutes of the March 16, 2020 City Council Meeting-Administration c) Approve Arbor Day Proclamation-Public Works April 13, 2020 Regular Minutes - 1 - d) Approve Street Maintenance Services Through South Metro Joint Powers Agreement- Public Works e) Approve Joint Powers Agreement between Dakota County and the City of Farmington for a Household Hazardous Waste Collection Event-Public Works f) Approve Contract for 2020 Trail Crack Sealing-Public Works g) Award Contract for 2020 Pavement Rehabilitation Project-Public Works h) Adopt as Agreement with MnDOT and Adopt Resolution R23-2020 Related to a Turn Lane on TH3 at 209th Street-Public Works i) Award Contract Fire Station #1 Apparatus Door Replacement Project-Parks j) Acknowledge First Quarter 2020 New Construction Report and Population Estimate- Community Development k) Adopt Resolution R24-2020 Amending the 2020 Budget-Finance 1) Approve 2019 Interfund Transfers-Finance m) Approve Bills-Finance 8. Public Hearings None 9. Award of Contract None 10. Petitions, Requests and Communications None 11. Unfinished Business None 12. New Business a) COVID-19 City Response Update Administrator McKnight provided an update on the city's response the COVID-19 pandemic. McKnight shared the actions that have occurred to date. ✓ City council declared an emergency on March 16, 2020 ✓ City facilities were closed to the public on March 18, 2020 ✓ Service delivery changes were implemented, most notably in the following departments- April 13, 2020 Regular Minutes -2- o Police Department o Fire Department o Solid Waste o Building Inspections ✓ PPE gathered, and continues to be gathered, for city staff ✓ We shared PPE with neighboring cities and some senior facilities in Farmington because we had extra ✓ Cancelled or postponed a number of city events ✓ Working closely with the federal government, State of Minnesota, Dakota County and our neighboring cities in a wide variety of areas ✓ Our days have been filled with Zoom meetings, daily and weekly updates from the state and Dakota County ✓ Asked for patience from the public as we implemented these changes ✓ We placed on emphasis on communication through our social media and webpage ✓ Main goal is to protect our staff members so they can provide the essential services like police, fire, solid waste, public works and more ✓ We closed both liquor stores and have reopened the PK liquor store after implementing protective measures for staff and customers ✓ Governor Walz issued a Stay at Home order originally through April 10th that was extended to May 4th ✓ Service delivery adjustments have continued, we have analyzed and tweaked our approach as well ✓ As of today, staff is either working normally (police, fire, public works), working from home and a few continue to work out of closed city facilities ✓ This week we have staff performing more traditional work as compared to COVID work ✓ Work this week will include the completion of street sweeping so we can start hydrant flushing on Monday, April 20 ✓ We will be advertising the hydrant flushing work in the next few days and likely daily over the two weeks it will take to complete hydrant flushing ✓ We will continue to adjust service delivery as we go but realize we will not make everyone happy ✓ We waived late fees for utility bills that were due on March 31St to help residents ✓ Thanked- • City staff for their willingness to change our approach to work and for their continued dedication to all aspect of Farmington o Residents for their patience as we do our part to develop our new normal when it comes to service delivery o City Council for your support as staff made quick decisions on how to make this work as best as we could ✓ The city administrator has tried to communicate with the city council and city staff on a regular basis the past month April 13, 2020 Regular Minutes -3- ✓ As you know from my last communication, for the most part everyone seems to have settled into the new service delivery method and things have been relatively quiet the past week or so ✓ We will continue to monitor what is occurring with pandemic and address issues as needed Councilmember Bernhjelm shared that she is proud of city staff for the work they have done over the past month. Councilmember Craig thanked city staff for their work and for handling the changes. Councilmember Donnelly thanked staff for going above and beyond and asked about possible date changes for first half property taxes. McKnight stated that the state legislature sets the due date for property taxes and any change would have to be done at that level. The county has the ability to waive late fees and penalties. Mayor Larson thanked staff for the communication and for the work that continues to be done. b) Direction/Guidance/Action on City Related Issues Due to the COVID Pandemic Administrator McKnight presented a summary of actions that city staff has or will take because of the COVID-19 pandemic. McKnight asked the city council to formally approve the following actions- 1) The city will waive any late fees for utility bill payments for those bills that were due on March 31, 2020. 2) Caps will be temporarily removed for vacation, sick time and PTO for city staff for the time being but will be put back in place by December 31, 2020 at the latest. 3) Temporary wage increase of$2 per hour for liquor store for hours worked between Saturday, March 28, 2020 and Friday, April 10, 2020 with the exclusion of the liquor operations manager. 4) Waiver of all liquor license fees for April 2020 since these businesses cannot be open to sell alcohol. Councilmember Donnelly asked about the end date for the temporary wage increase for liquor store employees. He asked why the end date was April 10th and not May 4th. Councilmember Craig asked if the end date could be adjusted to align with the end of the stay at home order. McKnight stated the original date was the end of the first stay at home order. The city council agreed to adjust the date to the end of the stay at home order. Motion by Bernhjelm, second by Craig, to approve the elimination of utility bills late fees for bills due March 31, 2020; the temporary suspension of vacation, sick and PTO caps for 2020, April 13, 2020 Regular Minutes -4- the $2 per hour wage increase for liquor store staff through the end of the stay at home order and the waiver of liquor license fees for April 2020. APIF, motion carried. 13. City Council Roundtable Bern hjelm-Thanked residents for their support during this time. Encouraged residents to stay positive. Shared that a Zoom EDA meeting will be held on April 23rd. Encouraged residents to complete their census forms. Donnelly-Thanked residents for their support. Encouraged residents to stay positive. Craig-Thanked staff and the police department for their positive approach to this issue. Encouraged residents to stay connected. Hoyt-Encouraged residents to support local businesses. Reminded everyone to continue to touch base. Shared that May is mental health month and he asked the city administrator to bring forward a proclamation at the May meeting. McKnight-Shared that the city council meeting will return to their normal schedule with the next meeting on May 4th Larson-Thanked US Representative Craig for her support during this issue. 14. Adjourn Motion by Bernhjelm, second by Craig, to adjourn the meeting at 7:23 p.m. APIF, motion carried. Respectfully Submitted vova P. "C'Kn'�rlit David McKnight, City Administrator April 13, 2020 Regular Minutes -5 - CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON 651-280-6800 ®o Farmington M N.gov TO: Mayor, Councilmembers and City Administrator FROM: Randy Distad, Parks and Recreation Director SUBJECT: Approve Agreement Schrriitz-Maki Arena Exclusive Vending Service-Parks DATE: May 4, 2020 INTRODUCTION The city currently does not have a vending contract at the Schmitz-Maki Arena. DISCUSSION I n 2013,the city completed an Exclusive Vendi ng Service Request for Proposal(RFP) process, and as a result of this process, entered into a five year a reement with Midwest Vending Services, I nc. (MVS)to provide exclusive vending services for the city. he contract expired in the fall of 2018. The arena's vending machines continued to be serviced by MVS after the contract expired. The arena is currently receiving sales commissions from MVS in the following percentages: • Hot Beverages 0% • Bottled Soda and Sports Drinks 12% • Bottled Water and Canned Drinks 19% • Snack Items 12% Because there is no current vending contract inlplace, staff mailed an RFP to 12 different vending companies and posted the RFP on the city's website. Proposals were due on or before 10:00 a.m. on Thursday, April 16, 2020. The city received proposals from three vend ingl'companies. Proposals submitted were tabulated and compared to one another.The tabulated propo�als are attached for city council review. It appears that C &S Vending Company(CSVCfrom Faribault, Minnesota submitted the best proposal based on the following: • Provided commission rates for all vending categories and commission rates are based on net sales after sales tax is taken out • Highest sales commission percentage, which means the arena will receive a greater amount in revenue from vending sales • Offered additional incentives including: 1b free cases of water annually,web access to monitor sales and free customer designer fronts for machines Staff is proposing to the city council that the city enter into a three year agreement with CSVC to provide exclusive vending services at the arena. Should the agreement be approved, it is anticipated that on June 1, 2020, the current MVS vending machines will have been removed and CSVC vending machines will be installed and in use. I t is important to note the city previously had a contract with CSVC from 2008-2013 for exclusive vending services.The city did not have any issues with the vending service CSVC provided during the contract period. BUDGET IMPACT n 2019,the arena received a total of$1,172.5 in vending sales revenue based on the sales commissions it was receiving from MVS. Based on the higher vending sales commission that CSVC identified in its proposal, the arena should receive higher vending revenue in the future than what it currently receives. ACTION REQUESTED The city council is being asked to approve an agreement for three years with CSVC to provide exclusive vending services at the arena and authorize thel Mayor and City Administrator to sign the agreement. ATTACHMENTS: Type Description © Exhibit Arena Vending Proposals Tabulation Schmitz-Maki Arena Exclusive Vending Services Proposals Tabulation Form Name of Hot Beverages City Cold Beverage Snacks/Candy Bulk Candy Company Commission City Commission City Commission Toy Rack Comments/Other Incentives C& S 1. Customer designer fronts on machines at no additional charge Vending 25% 25% 25% 25% 2. 10 cases of water annually at no cost Company, Inc. 3. Free web access to see machines performance to self audit sales Midwest no Vendingo 0 o commission Services, 0% 18/0 18/o identified in no other incentives provided Inc. proposal submitted Grand Prix does not supply this does not supply this does not supply this 1. Only provides bulk vending,which consists of loose and hard pressed Vending type of vending type of vending type of vending 30% candy, gum, small novelty encapsulated toys, sports themed stickers, etc. machines machines machines 2. One time payment of$500.00 AGREEMENT AGREEMENT made this 49'day of May,2024,between the CITY OF FARMINGTON,a Minnesota municipal corporation ("City"), and C&S FENDING COMPANY, INC. a Minnesota corporation("Contractor"). IN CONSIDERATION OF THE MUTUAL UNDERTAKINGS HEREIN CONTAINED,THE PARTIES AGREE AS FOLLOWS: L CONTRACT DOCUMENTS. 'ncc following documents shall be referred to as the "Contract Documents", all of which shall be taken together as a whole as the contract between the parties as if they were set verbatim and in full herein: A. This Agreement B. Contractor Proposal attached as 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 perform the work in accordance with the Contract Documents. 3. OBLIGATIONS OF THE CITY. The City shall pay the Contractor in accordance with the bid. 4. SOFTWARE LICENSE. If the equipment provided by the Contractor pursuant to this Contract contains software, including that which the manufacturer may have embedded into the hardware as an integral part of the equipment, the Contractor shalt 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 at 12:00 a.m.midnight on May 31,2023. 7. PAYMENT. 2. The Contractor agrees to pay the city m brithly commission payments and including a detailed report showing total net sales after Minnesota'sales tax is removed for the month no later than by the 15�1 day or the month following the month the sales were received. b. The Contractor agrees to pay the city the following commission amounts on a monthly basis based on the total net sales after Minnesota sales tax is removed: Cold Beverages 25% Hot Beverage 25% Candy/Snacks 25% Bulk Vending 25% C. The Contractor agrees to provide the following additional incentives at no additional cost to the city: • 10 cases of water annually and it no cost • Free web access to monitor vending machine sales • free customer designer fronts for machines 8. EXTRA SERVICES. No claim will be honored for compensation for extra services or beyond the scope of this Agreement or the not-to-c'xcccd 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 VM 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 (I Y2 %) 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 disbursernients, 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. 2 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 "I 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 all warranties as specified within the bid shall be in full force and transferred to the City upon payment by the City. The Contractor shall be held responsible for any and all defects in workmanship, materials, and equipment which may develop in any pail 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 manufacturers 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 tither 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 4 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 parries'entire contract. 20. ENTIRE AGREEMENT. This Contract represents the entire agreement of the patties and is a final, complete, and all-inclusive statement of the terms thereof, and supersedes and terminates any prior agreement(s),understandings,or written or verbal representations made between the parties with respect thereto. 21. TERMINATION. This Agreement may be terminated by the City for any reason or for convenience upon written notice to the Contractor. In the event of termination,the City shall be obligated to the Contractor for payment ofamounts due and owing for materials provided or for services performed or furnished to the date and time of termination. AA Dated: 1 't ,2020 CITY OF FARMINGTON Todd Larson,Mayor By: �... avid McKnig t,Cit Administrator Dated:P� ,2020 CONTRACTOR: C&S VENDING COMPANY,INC. By:_L ✓ %� lts:�,fet�t'Jf ��,�kc»+e�(rrkJth Zr►,};,,��',✓c,� 5 CITY OF 0 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 �urulururr„` O FarmingtonMN.gov TO: Mayor, Councilmembers and City Administrator FROM: Randy Distad, Parks and Recreation Director SUBJECT: Approve Rambling River Center Advisory Board Bylaws-Parks DATE: May 4, 2020 INTRODUCTION It is good practice for an advisory board to have bylaws that identify rules so the group operates consistently,there are clear expectations identified for members and it can function in an orderly manner so internal disputes and conflict can be avoided. The Rambling River Center Advisory Board (RRCAB) does not currently have bylaws. DISCUSSION One of the 2020 work plan goals for the RRCAB was to create bylaws for itself. It reviewed other sample bylaws from other senior organizations and were able to create draft bylaws that it approved at its March 91 2020 meeting. The approved bylaws are attached for the city council to review. ACTION REQUESTED The action requested of the City Council is to approve the attached RRCAB bylaws, so they can be implemented and followed by the RRCAB. ATTACHMENTS: Type Description ❑ Backup Material Rambling River Center Advisory Board Bylaws CITY OF O 43o Third St.,Farmington.MN 55024 FARMINGTON (S) 65i-28o-6800 •ply FarmingtonMN.gov City of Farmington, Minnesota Rambling River Center Advisory Board Bylaws I. Name. The name of the organization is Rambling River Center Advisory Board (Advisory Board). II. 'Scope The Advisory Board's mission is to advise and make recommendations to the Parks and Recreation Commission and Farmington City Council concerning the operations of the Rambling River Center including programs, activities, events, budgets, building operations and comprehensive building planning and improvements. The Advisory Board is committed to providing quality program and services, while encouraging the involvement of adults over age 50. III. Membership. The number of Advisory Board members is seven (7),which is established by city ordinance. Each member is appointed by the City Council for a three-year term. Terms are staggered so a majority of members are not replaced in any one year during the appointment process. Any vacancies occurring during the year will be filled by the City Council. Prior to assuming the duties to which first appointed, each member shall take an oath of office. IV. Functions and Powers. The function of the Advisory Board shall be to provide recommendations and advice to the Parks and Recreation Commission and City Council about the Rambling River Center operations, programming and annual budgets. The Advisory Board's role is to ensure senior citizen's life in the city is enriched and the quality of life is enhanced. In performance of its functions, the Advisory Board is authorized to: a. Recommend and conduct, as required, any studies or reviews as advised regarding assessment of needs, development, and maintenance of programs, activities and services which meet the needs and wishes of Rambling River Center members and other members of the senior community in the Farmington area, so seniors may continue to contribute, participate, and share in the He of the community. CITY OF FARMINGTON O 43oThird St,Farmington,MN 55024 651-28o-6800 FarminglonMN.gov ---,..wry-- b. Cooperate with any group or organization in any way that will aid in fulfilling its functions to enhance senior lifestyles. c. Make recommendations to the Park and Recreation Commission and City Council regarding policies for use of the Rambling River Center. d. Adopt any rules and procedures it feels advisable for the conduct of its meetings. e. Act as a sounding board for senior citizens in the community who seek new or altered opportunities for activities, education, policies, and services. e. Support the use of the Rambling River Center as a source of education and programming for senior health, nutrition, safety and security, and recreational activities and events. V. Meetines. The Advisory Board shall meet at 930 a.m. on the second Monday of each month at the Rambling River Center, unless it is a city holiday and then the Advisory Board shall meet on the Tuesday following the holiday. Special meetings may be called upon the request of the Parks and Recreation Director, or the Chair of the Advisory Board. The notice of a special meeting shall be given at least 72 hours prior to the meeting and shall state the subject matter to be considered and no other matter shall be before the Advisory Board. In the event there is no matter to be considered, the Parks and Recreation Director, in consultation with the Chair, may cancel a meeting by notifying each Board member at least 24 hours prior to the time set for the meeting. Meeting cancellation will also be emailed to the media and other appropriate individuals and it will be provided on the city's website. Signs will also be posted at the Rambling River Center entrances about the meeting cancellation. VI. Meeting Rules of Order. General parliamentary rules, as given in Robert's Rules of Order, as modified by the rules and regulations of the Commission shall be observed during meetings. VII. Quorum. Four(4) members of the Advisory Board shall need to be present at the meeting to constitute a quorum for the transaction of business and all actions shall -require the concurring vote of a majority of members present. CITY OF FARM I NGTON O 43o Third St,Farmington.MN 55024 �, 651-280.6800 FarmingtonMN.gov VIII. Meeting Attendance. In order to maintain maximum participation of all appointed Advisory Board members at all regularly scheduled meetings, it is important to establish meeting attendance expectations. Advisory Board members shall have no more than four (4) total absences in one calendar year, which should consist of no more than two unexcused absence in a calendar year. An unexcused absence is described as when a member is absent from the meeting, but does not provide notice of their absence prior to the meeting to either the chair, Parks and Recreation Director, or the Recreation Supervisor. If any Advisory Board member is absent from more than four (4) scheduled monthly Advisory Board meetings in a year or has more than two (2) unexcused absences in a year, whether consecutive or not, during any one-year time period, the Advisory Board member will be recommended for dismissal unless extenuating circumstances exist. The recommendation for dismissal shall be made by a majority of the Advisory Board and then the recommendation shall be provided by city staff to the City Council for official action. IX. Resignation. Should an Advisory Board member resign, a written letter of resignation, either on paper or via email, shall be provided either to the Parks and Recreation Director, or Recreation Supervisor as soon as possible, so it may be placed on the next City Council meeting agenda to be accepted. X. Officers. Annually and at the regular February meeting the Advisory Board shall elect a chair and a vice chair for one-year terms beginning immediately. There are no term limits for members to serve in either the chair and vice-chair role, so long as they continue to be appointed by the City Council. Duties of Officers a. Chair: The chair shall preside at all meetings of the Advisory Board, decide all points of order, appoint membership to such temporary committees as deemed necessary, sign documents on behalf of the Board, and in consultation with the Parks and Recreation Director call regular or special meetings of the Advisory Board. b. Vice-Chair: The vice-chair shall assume all the duties of the chair in the chair's absence. The Recreation Supervisor, or the Parks and Recreation Director in the CITvoF--- O 430 Third St.,Farmington.MN 55024 FARMINGTON © 661-28o-6800 FarmingtonMN.gov c. The Recreation Supervisor shall record the minutes of the meeting and be responsible for providing a draft of the minutes to the Parks and Recreation Director for inclusion in the following meeting's packet. XI. Meeting Packet. At least one week prior to the monthly meeting, the chair, Parks and Recreation Director and Recreation Supervisor shall review and set the meeting agenda. The Parks and Recreation Director, in consultation with the Recreation Supervisor, is responsible for the preparation and posting of the meeting packet on the city's website at least five (5) days prior to the meeting. Rambling River Center staff shall be responsible for printing and making copies of the meeting packet. The meeting packet will be available to be picked up at the Rambling River Center building by Advisory Board members at least 72 hours prior to the meeting. The order of business of all regular meetings shall be as follows: Agenda Format 1. Call to Order 2. Approval of Agenda 3. Approval of Minutes 4. Presentations 5. Business Items 6. Discussion Items 7. Staff Report 8. Roundtable 9. Topics for Next Meeting Agenda 10.Adjournment XII. voting. An affirmative vote of a majority of those present shall be necessary to pass any motion involving the adoption or amending of plans, policy statements, or recommendations to the Palic"RecreationComrission ardCiy Council. Voting shall be by voice vote and shall not be recorded as individual ayes or nays unless requested by a member of the Advisory Board, in which case the chair shall order the vote to be so recorded except that any member may abstain by so declaring prior to vote. An abstention may only be made in the case of a conflict of interest; it is otherwise the duty of all Advisory Board members present to participate in the vote. CITY OF O 43o Third St.,Farmington,MN 55024 FARMINGTON © 651-280-6800 MrrlOr�� FarmingtonWgov XIII. Notice. Adequate notice of all meetings and matters to be discussed shall be given to the public and appropriate city offices, and shall be posted on the city's website. All meetings shall be open to the public. XIV. Annual Report. The Advisory Board shall receive a presentation annually from city staff summarizing the activities and operations of the Rambling River Center that occurred in the prior year. XV. Approval of Bylaws. The Advisory Board shall be responsible for revising and approving its bylaws. Once approved by the Advisory Board, the bylaws will be reviewed and approved by the City Council. XVI. Amendment of Bylaws. These bylaws may be amended by majority vote of the members of the Advisory Board. An amendment to the bylaws shall be voted on at the next regular meeting after the regular meeting at which the amendment is proposed. The amended bylaws will then be reviewed and approved by the City Council. ADVISORY BOARD APPROVAL DATE: MARCH 9, 2020 CITY COUNCIL APPROVAL DATE: J9- 7. S� aaao SIGNATURE: MAYOR: DATE: CITY OF 0 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 W� O Farmington M N.gov TO: Mayor, Councilmembers and City Administrator FROM: Jennifer Gabbard, Human Resources Director SUBJECT: Approve Recommendation for Hire Police Department-Human Resources DATE: May 4, 2020 INTRODUCTION The recruitment and selection process for the appointment of the open Police Officer has been completed. DISCUSSION After a thorough review by the Police and Human Resources Departments, a contingent offer of employment has been made to Robert Hagfors. This offer is still contingent on his passing the POST Board Exam, and the ratification by city council. Mr. Hagfors has already completed the extensive background check, the physical examination and pre- employment drug and alcohol test, and the comprehensive psychological exam. Mr. Hagfors comes to us after completing his Associate's Degree in Law Enforcement from Rasmussen College, and seven years of experience with the U.S. Army. He also gained leadership experience with Valmont as a supervisor. BUDGET IMPACT Mr. Hagfors'starting salary will be$30.05 per hour, which is step Step 1 of the salary range for the position. Funding for this position is included in the 2020 budget. ACTION REQUESTED Approve the appointment, with the condition, of Robert Hagfors as a Police Officer on or after May 5, 2020 contingent upon obtaining a POST license. CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 Iii O FarmingtonMN.gov TO: Mayor, Councilmembers and City Administrator FROM: Jennifer Gabbard, Human Resources Director SUBJECT: Approve One-Year Extension of ClearCompany Contract-Human Resources DATE: May 4, 2020 INTRODUCTION There are many things that are important to an organization, but none more important that those that we hire. We currently have systems in place to help with our hiring process, including our agreement with ClearCompany as our recruiting platform. DISCUSSION n 2016, the city subscribed to ClearCompany as an improvement to our service to the public and to create work efficiencies internally. ClearCompany is an electronic applicant tracking system (ATS)that automates most of our recruitment processes. Overall,the ClearCompany system is a very transparent system for both Human Resources and the departments we serve. I t is not the common application that most public government use for hiring. However, ClearCompany has been willing to work with me on improvements to the system to be more user friendly for a public government. Since 2016, ClearCompany has provided some additional helpful modules that now include texting applicants with interview times. Based on this, it is my recommendation that we enter into another one year contract with ClearCompany. BUDGET IMPACT The total impact of the contract with ClearCompany is$10,977.12 for one year. This is $300 higher than our contract with them in 2019. These funds are available in the 2020 budget. ACTION REQUESTED Approve the contract with ClearCompany. ATTACHMENTS: Type Description D Backup Material ClearCompany 2020 Renewal- City of Farmington ClearCompany - 2020 ClearCompany PROPOSAL Renewal Prepared for: Jennifer Gabbard Company name: City of Farmington, MN Prepared by: Ari Crane Proposal date: 4/28/2020 Hire, Engage and Retain Top Talent �m g ClearCompany Qj f It has been a pleasure working with you and ClearCompany is eager to continue our partnership with City of Farmington, MN. As you may know, ClearCompany provides talent software solutions for over 2,000 satisfied customers. We appreciate your business and collaboration. Our award-winning team of HR technology experts would like to continue working with you and is committed to ensuring our platform supports City of Farmington, MN's key talent priorities and business goals. This proposal provides an overview of our software capabilities, services and support, and pricing. We would be delighted to work with you in the year ahead! Ito if No _JL Hire, Engage and Retain Top Talent with ClearCompany Talent Acquisition Talent Management Talent Engagement Talent Analytics • Applicant • Continuous • App Provisioning • Comprehensive Tracking and Performance by Role (World of Total Talent Sourcing Management Work) Reporting • Paperless • Goals Alignment • Integratio ns/SSO • Interactive Data Onboarding • 360 Reviews • Social Newsfeed Visualization Tools • Recruitment • Employee • Executive Marketing Recognition (2o19) Dashboards A Powerful Platform for Talent Success Leadership and Feature Quality Integration Expertise Throughout the Platform ClearCompany seamlessly integrates with the The #1 ranked end-to-end talent suite and most world's largest collection of workplace apps. complete feature set for mid-sized companies. Intuitive and Mobile-Ready Powered by the ghSMART A Method Our award-winning user interface and mobile from NY Times Best Seller Who functionality throughout make ClearCompany The proven research-based A methodology connects the talent platform everyone loves to use. every ClearCompany talent module and increases ______ • your ability to attract, engage and retain top talent. Commitment to World-Class Service and Support Our dedicated, in-house implementation, customer success, consulting services, account management, training and support teams will ensure your success. SubmltDocumords 4 = ry Robust Analytics that Deliver Actionable Insights Our comprehensive analytics suite synthesizes and connects data from across the platform to provide deep insights on employee performance and potential throughout the employee lifecycle. r A Unified Talent Model jalent Analytics IPPPPPP--. -744. Acquf eth Care HR Oor Drive success throughout the employee lifecycle ClearCompanyTM is different from other solutions. Our software automates the A Method at scale and connects every talent module. It brings your company's unique mission, goals and roles into every phase of the employee experience. This connected, continuous approach, combined with our superior analytics suite, enables ClearCompany to drive ongoing improvement to your talent strategy. You need a connected talent suite, not siloed talent modules With a connected talent strategy, you can leverage the performance profiles of your A players in your recruiting efforts to attract and hire candidates with similar performance attributes. Don't let your ATS or performance management software silo valuable talent data. Leverage insights and performance data from every part of your talent platform to drive future hiring decisions, employee engagement and business success. WNW The Industry's Best Talent Suite Talent Acquisition Talent Engagement Applicant Tracking App Provisioning by Role (World of Work) An award-winning and patent-pending ATS Rethink single sign-on and identity management for attracting and hiring A Players Our platform makes single sign-on and identity Only ClearCompany uses the profiles of management technology more useful by connecting it to the your top performers to identify your next great unique roles in your organization. Easily customize or change employee, not just high potential applicants. app access based on an employee's role or status without IT Optimize your recruiting process start to finish with help. Seamlessly onboard and off-board employees or change software that helps you manage job boards and their workplace tools when roles change. requisitions, identify and score candidates, source passive talent, perform recruitment marketing Integration Expertise activities, conduct effective interviews, streamline Streamline and improve how work gets done recruiting schedules and candidate communications, No talent platform integrates with more apps and tools to help and engage your entire hiring team in the recruiting you and your employees work efficiently. We offer single sign- process. on and thousands of turnkey integrations with payroll providers, HRIS systems and workplace applications to improve Paperless Onboarding business productivity. Our bi-directional data flow with ADP Make a great first impression on new hires links employee compensation data and HRIS data with A smooth and engaging onboarding experience ClearCompany talent data to provide a holistic view of each builds new hire trust and enthusiasm. Our system employee. makes it easy to onboard new hires, manage compliance and documentation, provision workplace Social Recognition apps and tools seamlessly, and introduce new hires Use recognition to promote engagement and culture to teammates, the company's mission, vision and Recognize employee accomplishments, celebrate team wins values, and their performance goals before they start. and let co-workers chime in to congratulate peers. Coming Q1 2019. Talent Management Talent Analytics Performance and Goals software that employees, See the full picture and turn insights into action managers & HR teams appreciate Our flexible technology achieves strong ClearCompany's analytics suite provides a robust employee approval ratings and participation because it intelligence layer across our talent modules to support puts your company's mission, goals and values at the better people-related decision making and workforce heart of performance discussions. It enables continuous planning. Synthesize data throughout the employee feedback and informal check-ins between managers and lifecycle to predict attrition, forecast hiring needs and employees. Conduct 360 reviews and easily customize measure employee engagement, performance and your review formats, cycles, questions and potential. Use our interactive reports and data communications to make reviews a positive experience for visualization tools to gain deep insights into everyone. Continually apply performance insights to your the performance of each department, manager, recruiting efforts to hire more A players. employee and team. ClearCompany Is the Talent Expert You Can Rely On (7 cnnxn X cRONv C3 cxowo 500 113 BEST PLACES TO WORK Customers Appreciate ClearCompany "The ease of the platform is incredible and creates a "This program streamlines the recruiting and great deal of organizational efficiency. With onboarding process. It puts it all in one place!Saves ClearCompany we were able to centralize our 7 our company about 10-12 labor hours a week! I like office organization on their platform and create best knowing exactly where my candidates are in the practices and a process that worked for our firm. We hiring process. The electronic onboarding makes our increased our resume flow by 1000% and have the process painless and paperless. Alert emails keep ability to scale. In 2016 our number of employees me posted on what I need to do." grew by 113% and almost all of this growth can be — Kasey H. attributed to our implementation of Chick-Fil-A ClearCompany." — Matt C. "ClearCompany has drastically made our hiring and Healthcare Appraisers, Inc. onboarding process better. We used to be completely "The software is very user-friendly. The system paper-based. The ClearCompany platform has makes allowed us to develop a more robust hiring process recruiting and keeping track of candidates so much from beginning to end. We chose ClearCompany more efficient. We've been able to reduce hiring over 2 other ATS vendors and I have no regrets in time and customize processes. Some of our end doing so. The support and numerous features have users rave about how easy ClearCompany is to been great" navigate." — Nick H. — Roland M. The Villages of Indiana BrightPoint Health PROPOSAL Prepared for: Jennifer Gabbard Date: 4/28/2020 Main Subscriber Contact Bill To Subscription Agreement Jennifer Gabbard Jennifer Gabbard Prepared By: Ari Crane City of Farmington, MN City of Farmington, MN Agreement Term: 12 430 3rd St 430 3rd St Subscription Start Date: 2020-07-29 farmington, Minnesota 55024-1355 farmington, Minnesota 55024-1355 Billing Start Date:2020-07-29 Annual Annual Total Annual Services Qty List Rate Sales Rate Discount Investment Shortened Term Premium 1 $997.92 $997.92 $998 Shortened Term Premium 182: Advanced Recruiting Platform 110 $90.72 $90.72 $9,979 182:Advanced Recruiting Platform First Year Investment: $10,977.12 Special handling instructions: 12 Month term agreement WOW • ii•��' •ani i i We help companies achieve their missions with the only software designed for hiring, engaging and retaining A players. yaws ClearCompany V4 ClearCompanyI vvww.clearcompany.com 617-938-3801 OQClearCompany /ClearCompany General Terms and Conditions ClearCompany agrees to provide an online information service to the Subscriber via the ClearCompany site, a custom site or data feed as specified below. Subscriber(as specified above) agrees to pay all charges arising from the use of all user accounts listed in this schedule. Subscriber(as specified above)agrees to limit access to and use of the service to the Offices as set forth on the agreement. Subscriber shall provide ClearCompany with (and update as necessary)complete information regarding its use of the Service including the Offices authorized to access the Service.The interface provided by ClearCompany is intended for the use of the purchasing company. ClearCompany makes no warranties express or implied as to the suitability of the service for Subscriber's business purposes. ClearCompany's liability shall be limited to no more than the amount of all subscription fees paid by Subscriber. Subscriber agrees that ClearCompany may use the Subscriber's name and logo to identify it as a client of ClearCompany on ClearCompany's website and as part of a general list of clients in marketing literature. Any copying, distribution or disclosure is strictly prohibited. ClearCompany may suspend or terminate access to the Service if the Office information is inaccurate, not current or incomplete. Credit Inquiries and Credit Reporting ClearCompany is authorized to check the Subscriber's credit for the purposes of determining credit worthiness at the time of this service agreement or thereafter in connection with the same transaction. ClearCompany is further authorized to provide history information to others about ClearCompany's credit experience with Subscriber, including outside collection agencies and outside counsel. Effective Date and Term of Agreement The Effective Date is the "Subscription Start Date" specified at the top of this agreement.The Initial Term of this Agreement shall be for 24 months as designated unless otherwise specified in the Special Handling Instructions and shall be automatically renewed for successive periods of equal length to the Initial Term unless otherwise terminated by either party upon no less than 90 days written notice to the other. All discounts and incentives are effective for the initial year of this Agreement only. Should a subscriber wish to cancel after the Initial Term,the official anniversary date is equal to the Effective Date of Agreement, for each billable service. Prices are subject to change with 90 days written notice after the Initial Term. Billing Terms and Conditions ClearCompany reserves the right at any time to establish specific billing terms for each Subscriber based upon ClearCompany's assessment of a Subscriber's credit worthiness in ClearCompany's sole discretion, including without limitation, requiring advance payment for services. In the event that any of client's service charges remain unpaid for more than 90 days(from the stated invoice date), in addition to any other remedies, ClearCompany reserves the right to(1)discontinue services under this agreement,without notice to client, or(2)alter the initial billing terms under this agreement should client wish to continue receiving services from ClearCompany. Subscriber agrees that this Agreement shall be governed by the laws of the Commonwealth of Massachusetts and that exclusive jurisdiction and venue for any Litigation shall be federal or state courts located in Boston, Suffolk County, Massachusetts. Subscriber agrees to pay all costs of collection, including without limitation reasonable attorney's fees, in the event ClearCompany refers the subscriber's account for collection. Billing shall be annual unless otherwise noted in the Special Handling Instructions. ClearCompany will invoice Subscriber for any applicable setup fees plus the first annual payment as of the "Billing Start Date" specified on reverse unless otherwise specified. Implementation services shall be extended upon receipt of initial required payment.Applicable state sales tax will be reflected on invoices.All invoices are payable upon receipt unless specifically stipulated in this Agreement. Should the Subscriber fail to make payment within 30 days of the stated invoice date,the Subscriber agrees to pay interest charges of 1.5%per month or part thereof(or the maximum interest rate allowed by law if less)or part thereof on the unpaid balance from the original due date.All discounted agreements require the first or sole payment to be received within 30 days of the Billing Start Date. Subscriber agrees to pay the full billing Total minus any Discount in the event payment is not received by this time. Subscriber agrees that all internal costs associated with the processing of an invoice shall be the Subscriber's responsibility. Data Confidentially, Retention, and Ownership Policy ClearCompany regards all documents sent, received, and stored in the System as the property of the Subscriber and will provide archival copies upon request.All proprietary data not released publicly via a job posting, advertising campaign, or other means, will be regarded as confidential and will not be shared with or released to any party other than Subscriber without authorization by an appropriate employee or officer of Subscriber. Subscriber authorizes ClearCompany to publicly release information contained in job advertisements and other communications to third parties on its behalf via the use of explicit features in the system for dissemination of such information.Subscriber acknowledges that ClearCompany shall not be held liable for any uses of data by third parties where that data was either(i) provided to the third party with Subscriber's permission;or(ii)published in a public forum such as on the Subscriber's career website. In these cases ClearCompany's responsibility shall be limited to providing reasonable technical support and liaison. Subscriber is entitled to unlimited data storage and retention for a period of two years from the date such data is submitted into the system. Data two or more years old is subject to archival and removal from active management, with backup copies provided to Subscriber,or may be retained in the system at no charge subject to a capacity quota of the lesser of 200MB of data,or 5000 candidates and requisitions combined, per active, paid recruiter license. Subscribers wishing to retain active data in excess of these quotas may purchase additional seat licenses,or pay a charge of$1.00/MB per year for data retention. Subscribers exceeding retention quotas shall be notified and given 30 days to select an archival backup or purchase additional capacity as detailed above. Subscriber may request a backup of data stored by ClearCompany at any time. ClearCompany will,within 30 days of receiving such a request, provide Subscriber with a copy of all resumes received and stored in the System.All reports and backups may be delivered electronically to subscriber once per quarter, and again in the event of termination of this Agreement. Resumes will be in either the source format or HTML. Structured database backups including parsed resume output in table or HR-XML format, as well as requisition information,will be provided subject to a one-time report setup fee to be quoted upon request by ClearCompany. If ClearCompany introduces a Subscriber self-service data archiving capability providing substantially similar capabilities, it shall be deemed to have satisfied the obligations described herein. In the event of termination, ClearCompany shall not be required to maintain former subscribers' data in a usable format after a backup has been provided in accordance with the terms above, or after b months after the date of termination if no backup request has been received by that time. Subscriber acknowledges that ClearCompany may continue to retain data for operational or technical reasons after termination of the agreement.The confidentiality provisions in this section shall survive any termination and continue until such data has been deleted or otherwise destroyed. oo Signatu Date: yy, yq, p Name (print). ? Title: or f . _... ., a Zcs ,_ ClearCompany Signature Date: Name (print): Title: CITY OF 0 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 OFarmingtonMN.gov TO: Mayor, Councilmembers and City Administrator FROM: Teah Malecha, Finance Director SUBJECT: Acknowledge Financial Review for the Quarter Ending March 31, 2020-Finance DATE: May 4, 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 quarter the city recorded General Fund revenues totaling$303,252 or 2.46 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 receives their portion in June and December. There will be changes in receipts of tax payments due to COVI D-19. 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 quarter licenses were received. There will be a reduction in the amount received in 2020. At the April 13, 2020 city council meeting the city council approved waiving all liquor license fees for April 2020 as the businesses cannot 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 113 building permits in 2020 compared to 79 in 2019. Plumbing, heating, and electric permits are up at 226 in 2020 versus 194 in 2019. Overall, permits were trending higher in 2020 than in 2019. COVI D-19 will have a negative impact on this revenue source. 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 officers human resource costs on a quarterly basis. Recreation revenue is anticipated to trend lower due to COVI D-19. Fine revenue is received the following month. The revenue for 2020 is trending lower than 2019. Investment 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 couple months in part due to COVI 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 25 percent(3 of 12 months) through the end of March in the same order as they appear on the attached General Fund financial report. Numerous departments are trending higher in 2020 over 2019 due to wage and benefit increases. Staff was hired in Fire, Planning, and Streets. The presidential primary was held in March.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 J PA 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 Investigations are viewed on a combined basis rather than individually. The three departments combined are at 26.6 percent of budget. Overall, General Fund expenditures, excluding transfers, are at 22.71 percent of budget for 2020. EDA, Park Improvement,and Arena The EDA (Economic Development Authority), Park I mprovement Fund, and I ce 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 D BB'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 only. Arena The ice arena was closed March 15th due to COVI D-19. 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. The Pilot Knob store was reopened on March 28th with limited hours. The store continues to expand hours.The downtown store will be reopening in the future. 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 first quarter. 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 I nvestment and Capital I mprovements 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 Revenues trended lower in first quarter for 2020 as a result of lower consumption on commercial accounts. There was an increase in MCES (Metropolitan Council Environmental Services)fees.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. Storm Water Revenues are trending higher in the first quarter due to the timing of the 2019 rate increase. Water Revenues are trending higher in 2020 due to a rate increase. The expenditures were higher in 2019 due to the construction for Well 9. 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 March 31, 2020 ATTACHMENTS: Type Description ❑ Backup Material General Fund YTD Ended March 31, 2020 ❑ Backup Material General Fund Chart YTD Ended March 31, 2020 ❑ Backup Material Special Revenue Funds YTD Ended March 31, 2020 ❑ Backup Material Liquor Stores YTD Ended March 31, 2020 ❑ Backup Material Utility Funds YTD Ended March 31, 2020 General Fund 1st Quarter 2020 YTD Operating Report Quarter 1 Quarter 1 Quarter 1 Actual Quarter 1 YTD Act Company Actual 2019 Actual Actual Actual 2020 Budget 2020 Budget Variance Comments 2019 2020 2020 as%of Bud 2020 Revenues M Property Taxes 9,716,274'. 0'. 0:' 0! 10,231,191 (10,231,191)':. 0.00%:Property taxes received in June and December.First payment received in June. Licenses 48,452 23,267 23,065 29,590!. 50,080'. (27,015), 46.06% Includes liquor,beer&wine,club arcade,massage,gambling,animal,etc.1st quarter liquor licenses received.All but 4 second quarter received.City will be waiving liquor licensing fees for April due to COVID 19. Permits 373,126, 42,924:. 86,1151. 102,976':. 423,035', (336,920) 20.36% Includes building,plumbing and heating,electric,etc.permits.1st quarter 2019: building permits 79,plumbing 39,heating 51,fire 8,electric 104.1st quarter 2020: building permits 113,plumbing 56,heating 61,fire 6,electric 109. Intergovernmental Revenue 1,085,064 116,4471 84,629, 85,149': 922,294 (837,665)'. 9.18%,Includes Local Government Aid(LGA),Municipal State Aid(MSA)Maintenance, Police and Fire Aid,etc.Received MSA road maintenance.MSA received in February 2020.A portion of 2020 coded to road maintenance account. Charge for Service 502,901 74,033'. 62,477'. 63,031', 445,802:, (383,325).: 14.01% 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 quartedy.Recreation programs are primarily held in the summer.PUD and plat fees received in 2019. Recreation will decrease due to COVID 19. Fines 63,561 13,397 12,935 12,935: 49,000 (36,065) 26.40% Fine revenue received a month late,e.g.January received in February. Investment Interest 142,074 24,649 19,868: 19,8681 38,800: (18,932) 51.21% Investment earnings attributable to General Fund's proportionate share of investment balances. Miscellaneous 53,125', 12,838 14,162: 14,2621 54,580 (40,418) 25.95% Includes Sr Center and City Hall rental income,and donations. Franchise Fees : 120,000 0' 0: 0', 120,000' (120,000) 0.00%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 307,555 303,252 327,811 12,334,762 (12,031,530) 2.46 Expenditures _... _. _.. _..... _. Legislative 77,604: 14,365 13,947 16,938: 87,772 (73,825), 15.89% Administration 278,967' 61,915'. 66,348 77,852' 302,068 (235,720). 21.96% Increase in wages&benefits in 2020. Elections 9,207'. 0' 11,782 11,7821 44,124 (32,342): 26.70% Provision for annual election equipment maintenance fee and ongoing training. Presidential primary in March. Communications 106,028 26,406: 26,467 30,421! 108,537 (82,070)' 24.39 City Hall 306,692 89,116'. 86,3161 97,275! 364,661 (278,345) 23.67% 2019 included new equipment for custodial staff. Dakota Broadband 8,813 0 11,326 11,3261 24,469 (13,163) 46.25% Executive Director costs moved to EDA.Includes DBB programming fee,access fee,and operational costs. Finance and Risk Mgmt 696,283 174,952 184,333 210,084 778,889 (594,556) 23.67% Increase in wages&benefits in 2020. Human Resource 355,103 82,684' 74,966 88,569: 349,226 (274,260): 21.47% 2019 included costs for staff retirement and contract staff. Police Administration 950,8801 248,948'. 308,941 375,936! 1,235,377'. (926,436)'.. 25.01% On a combined basis Police Admin,Patrol,and Investigations are 26.6%. Patrol Services 2,610,315: 640,022'. 625,144' 733,4541 2,538,727 (1,913,583) 24.62% On a combined basis Police Admin,Patrol,and Investigations are 26.6%. Investigations 651,206' 201,989 228,557 269,2091 892,059 (663,502)'. 25.62% On a combined basis Police Admin,Patrol,and Investigations are 26.6%. Emergency Management 2,802 54 54 54 11,650 (11,596), 0.46% Fire 1,318,556 213,038 240,338'. 288,196: 1,445,410 (1,205,072);. 16.63% New staff hired in mid-2019. Engineering 636,954 144,388. 158,281 189,2771 665,173 (506,892) 23.80%'.Increase in wages&benefits in 2020. Planning 481,5901 100,108 122,2421 151,351 591,133'. (468,891)'1, 20.68%'..New staff hired in mid-2019. Building Inspection 412,357 99,065 111,784 131,4941 423,734' (311,950) 26.38% Increase in wages,benefits,and Logis costs in 2020. Natural Resources 89,201 25,530'. 5,030'. 5,030': 129,462 (124,432)', 3.89% Position is vacant. Streets 1,145,647: 242,613'. 279,162: 336,2871 1,197,2001 (918,038), 23.32%,New staff hired in mid-2019. Snow Removal 321,2751 180,441 73,775: 73,775! 241,878 (168,103) 30.50% Higher March snowfall in 2019. Park Maintenance 671,976': 148,136' 144,169 169,629: 700,111 (555,942) 20.59% Majority ofthe maintenance costs are during the spring and summer. Rambling River Center 165,8781 41,950. 41,981 46,829' 190,822 (148,841) 22.00%. Park&Rec Admin 269,159 64,599': 64,790': 81,367 287,925 (223,135) 22.50% Recreation Programs 102,394 10,615'. 7,318: 14,153: 99,718 (92,400), 7.34% Majority of the programming is in the summer. Interest Paid.._ 0. 0 0 0! p 0.: Bad Debt Expense. 50.,.. 0,_.. 0... .. 0.. .. 0:.__.. _.. . _.. _..... Other Expense _.._. 49,447_ 0,.. 01 0.. 0,.. _.. _ _... _.. _... Subtotal Expenditures 11,918,3851 2,810,958' 2,887,0531 3,410,287'; 12,710,145 (9,823,092), 22.71%'. Revenues(Over)Under Expenditure 186,193' (2,503,403)', (2,583,801) (3,082,476) (375,363)'.. (2,208,438) 686.35%I, Other Financing Transfers In 1,244,256': 311,064 326,892 326,892 1,307,570 (980,678) 25.00 Transfers Out (1,281,138) (500,285) (233,052) (233,052). (932,207) 699,155 25.00% Subtotal Other Financing (36,882): (189,221): 93,841 93,841', 375,363'. (281,522)': 25.00% Net Change in Fund Balance 149,311:, (2,692,623); (2,489,960):, (2,988,636)',. 0,, (2,489,960)' City of Farmington General Fund Fund Balance $7,500,000 - $7,000,000 $6,500,000 V $6,000,000 $5,500,000 - R3 $5,000,000 IM $4,500,000 _ $4,000,000 $3,500,000LL - $3,000,000 - CD $2,500,000 — — $2,000,000 — — — $1 ,500,000 — — — t V $1 ,000,000 - — — — $500,000 -- Jan Feb Mar Apr May June July Aug Sept Oct Nov Dec 2011 20:7 2018 2010 2020 x-40%of Prelim.2020 Exp t 50%of Prelim.2020 Exp �40%of Prelim.2021 Exp �0—50%of Prelim.2021 Exp EDA, Park Improvement,Arena 1st Quarter 2020 YTD Operating Report Quarter 1 Quarter 1 Quarter 1 Actual Quarter 1 Company Actual 2019 Actual Actual Actual 2020 Budget 2020 Budget Variance YTD Act as%of Bud Comment 2019 2020 2020 2020 EDA EDA Revenues 10,434 1,674 1,562 1,562 2,700 (1,138) 57.85% Interest income Dakota Broadband 65,398 0 35,419 35,419 162,911 (127,492) 21.74% Reimbursement for DBB Executive Director expenses per Reimbursement agreement with DBB Board. EDA Expenses 64,872 20,291 12,137 12,137 38,730 (26,593) 31.34% DBB costs were included in 2019. DBB Human Resource 65,398 0 34,761 40,777 162,911 (128,150) 21.34% Wage and benefit expenses for DBB Executive Director. Expense Invoiced quarterly. Dakota Broadband 659 659 659 Expensed for DBB Executive Director. Invoiced quarterly. Expense EDA Net (54,438) (18,617) (10,575) (16,592) (36,030) 25,455 29.35% Revenues/Expenditures Transfers In 50,000 12,500 10,000 10,000 40,000 (30,000) 25.00% Transfers Out (2,850) (713) 0 0 0 0 Subtotal Other Financing 47,150 11,787 10,000 10,000 40,000 (30,000) 25.00% Net Change in EDA Fund (7,288) (6,830) (575) (6,592) 3,970 (4,545) -14.49% Balance Park Improvement Park Improvement 83,588 13,898 1,669 8,914 36,745 (35,076) 4.54% Interest income.2019 included grant funding and farm Revenues lease. Park Improvement 328,100 15,612 0 0 39,000 (39,000) 0.00% 2019 includes Bike-Ped Path Plan expenses. Expenditures Park Improvement Net (244,512) (1,714) 1,669 8,914 (2,255) 3,924 -74.00% Change in Fund Balance Ice Arena Ice Arena Revenues 366,852 126,794 133,016 133,016 367,700 (234,684) 36.18% Ice arena closed March 15 due to COVID 19. Ice Arena Expenditures 380,836 106,747 114,009 117,175 368,200 (254,191) 30.96% Ice Arena-Rev Over (13,985) 20,048 19,008 15,841 (500) 19,508 -3,801.51% (Under) Expenditures Ice Arena-Transfers In 0 0 0 0 0 0 Ice Arena-Transfers Out 0 0 0 0 0 0 Ice Arena Net Transfers 0 0 0 0 0 0 Ice Arena Net Change in (13,985) 20,048 19,008 15,841 (500) 19,508 -3,801.51% Fund Balance Liquor Stores Statement of Revenue & Expenses 1st Quarter 2020 Quarter 1 Quarter 1 Quarter 1 Company Actual 2016 Actual 2017 Actual 2018 Actual 2019 Actual Actual Actual 2020 Budget 2020 Quarter 1 Actual ACTBUDGET°% Comment 2019 2020 Budget Variance 2020 2020 Revenues-Downtown Total Revenue-Downtown 2,222,128 2,315,459 2,464,807 2,626,193 554,873 494,279 494,279 2,348,258 (1,853,979) 21.05% Downtown store's sales have declined from 1st quarter 2019.Store closed 3/18/2020 due to COVID 19. Cost of Goods Sold-Downtown Cost of Goods Sold 1,659,631 1,728,059 1,840,890 1,940,136 413,682 258,901 258,901 1,667,418 (1,408,517) 15.53% Decrease in COGS due to store closing. Will increase when reopens. Gross Profit-Downtown Gross Profit 562,497 587,400 623,917 686,057 141,191 235,378 235,378 680,840 (445,462) 34.57% Gross Profit%-Downtown 25.3% 25.4% 25.3% 26.1% 25.4% 47.6% 47.6% 29.0% 18.6% 164.2% 25%benchmark. Expenses-Downtown Advertising 5,198 4,327 3,872 1,954 125 242 242 5,500 (5,258) 4.41% Total Expenses-Downtown 475,533 488,195 514,184 581,961 129,044 141,065 163,012 577,425 (436,360) 24.43% Revenues(Losses)Before Transfer Revenue(Loss)B4 Trans-Downtown 86,964 99,205 109,733 104,096 12,147 94,313 72,366 103,415 (9,102) 91.20% Revenues-Pilot Knob Total Revenues-Pilot Knob 2,529,076 2,663,162 2,807,608 3,022,065 621,193 657,894 755,419 2,7065462 (2,048,568) 24.31% PK store's sales are$36K higher than a year ago.Store closed 3/18/2020 due to COVID 19. Reopened PT 3/28/2020. 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 322,447 322,447 1,850,260 (1,527,813) 17.43% Decrease in COGS due to decrease in sales. Gross Profit-Pilot Knob Gross Profit-PK 650,849 683,859 724,530 778,586 162,417 335,447 432,972 856,202 (520,755) 39.18% Gross Profit%-PK 25.7% 25.7% 25.8% 25.8% 26.1% 51.0% 57.3% 31.6% 19.4% 161.2% 25%benchmark. Expenses-Pilot Knob Advertising 5,198 4,282 3,632 1,959 130 238 243 4,250 (4,012) 5.60% Total Expenses-Pilot Knob 435,498 438,925 450,597 486,868 112,544 108,757 129,755 519,357 (410,600) 20.94% Revenues(Losses)B4 Transfer Revenues(Losses)B4 Trans-Pilot Knob 215,351 244,934 273,933 291,718 49,873 226,690 303,217 336,845 (110,155) 67.30% Combined Inc(Loss)Before Transfers Combined Inc(Loss)B4 Transfers 302,315 344,139 383,666 395,814 62,020 321,003 375,584 440,260 (119,257) 72.91% Profit(Loss)As A%of Sales 6.4% 6.9% 7.3% 7.0% 5.3% 27.9% 30.1% 8.7% 19.2% 319.9% The goal is 6%. Operating Transfers Operating Transfers-Out 204,113 248,592 194,377 134,088 33,522 34,113 34,113 136,452 (102,339) 25.00% Net Increase(Decrease)in Assets 98,202 95,547 189,289 261,726 28,498 286,890 341,471 303,808 (16,918) 94.43% Sewer,Solid Waste, Storm Water,Water&Street Lights 1st Quarter 2020 YTD Operating Report Quarter 1 Quarter 1 Quarter 1 Actual Quarter 1 YTD Company Actual 2019 Actual Actual Actual 2020 Budget 2020 Budget Variance Act as%of Bud Comment 2019 2020 2020 2020 Sewer ---- ....-.__ _...._.w _,n .._...... ,,,. . ...,_.. Revenues(Sewer) 2,204,045 457,039 428,082 428,505 2,326,614 (1,898,532) 18.40% The consumption for 2020 is lower than 2019 for commercial accounts. Expenses-(Sewer) 2,312,354 477,174 430,421 689,071 2,573,895 (2,143,474) 16.72% MCES(Metropolitan Council Environmental Services)fees are higher in 2020. Equipment was purchased in 2019 showing higher expenses. Revenues Over Expenses(Sewer) (108,309) (20,134) (2,339) (260,565) (247,281) 244,942 0.95% Transfers In(Sewer) 11,149 0 0 0 0 Transfers Out(Sewer) 986,029 77,589 81,886 81,886 327,545 (245,659) 25.00% See detailed transfers worksheet. Net Change in Fund Balance(Sewer) (1,083,188) (97,723) (84,225) (342,451) (574,826) 490,601 14.65% Solid Waste Revenues(Solid Waste) 2,344,704 464,723 490,222 490,439 2,449,853 (1,959,631) 20.01% Rate increase in 2020. Expenses-(Solid Waste) 1,941,259 530,313 595,044 619,600 2,312,989 (1,717,945) 25.73% Increase in recycling costs and tipping fees. Revenues Over Expenses(Solid Waste) 403,445 (65,589) (104,822) (129,161) 136,864 (241,686) -76.59% Transfers In(Solid Waste) 86,244 17,380 17,550 17,550 70,201 (52,651) 25.00% Transfers Out(Solid Waste) 145,314 36,329 36,970 36,970 147,879 (110,909) 25.00% See detailed transfers worksheet. Net Change in Fund Balance(Solid Waste) 344,374 (84,538) (124,242) (148,581) 59,186 (183,428) -209.92% Storm Water Revenues(Storm Water) 1,171,372 225,681 244,507 244,507 1,242,633 (998,126) 19.68% 2020 is higher due to the timing of rate increases.Beginning of 2019 was still 2018 rates. Expenses-(Storm Water) 553,625 24,129 23,926 25,313 1,036,854 (1,012,928) 2.31% Revenues Over Expenses(Storm Water) 617,747 201,552 220,581 219,194 205,779 14,802 107.19% Transfers In(Storm Water) 5,575 0 0 0 0 Transfers Out 713,387 96,442 99,038 99,038 396,152 (297,114) 25.00% See detailed transfers worksheet. Net Change in Fund Balance(Storm Water (90,065) 105,110 121,543 120,157 (190,373) 311,916 -63.84% Water Revenues(Water) Water Availability Charges 47,690 7,530 33,698 38,512 81,575 (47,877) 41.31% Correlates to building permit activity. Net Interest Income 303,877 55,724 41,617 41,617 78,500 (36,883) 53.02% Rental Income 241,777 97,194 127,865 127,865 236,000 (108,135) 54.18% Reflects wireless companies(ex.Sprint,ATT,Verizon)rental of space on the city's water towers.Some 2nd quarter leases paid in 1st quarter. Enterprise Sales 1,584,456 203,195 232,814 232,814 2,011,619 (1,778,805) 11.57% Rate increase in 2020. All Other Revenues 411,193 3,673 8,107 9,027 0 8,107 Total Revenues 2,588,993 367,315 444,102 449,836 2,407,694 (1,963,592) 18.45% Expenses-(Water) 1,426,000 334,501 129,003 132,525 7,246,319 (7,117,316) 1.78% Well 9 costs in 2019. Revenues Over Expenses(Water) 1,162,993 32,814 315,099 317,311 (4,838,625) 5,153,724 -6.51% Transfers In(Water) 11,149 0 0 0 0 0 Transfers Out(Water) 1,105,506 104,840 217,630 217,630 540,245 (322,615) 40.28% See detailed transfers worksheet.2020 includes water tower reconstruction debt service payment. Net Change in Fund Balance(Water) 68,636 (72,026) 97,469 99,681 (5,378,870) 5,476,339 -1.81% Streetlight Revenues(Streetlight) 233,437 41,151 42,114 42,114 224,900 (182,786) 18.73% Expenses 165,887 42,532 30,283 37,263 221,500 (191,217) 13.67% Revenues Over Expenses(Street Light) 67,550 (1,381) 11,831 4,851 3,400 8,431 347.97% 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: May 4, 2020 INTRODUCTION Attached is the Mach 30, 2020-April 29, 2020 city council check register and recently processed automatic payments for your consideration. DISCUSSION NA BUDGET IMPACT NA ACTION REQUESTED Approve the attached payments. ATTACHMENTS: Type Description D Backup Material Check Register 3/30/20-4/29/20 R55CKS2 LOGIS600V CITY OF FARMINGTON 4/29/2020 7:57:44 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 1 4/1/2020 - 4/29/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 151005 4/10/2020 100058 ADVANCE AUTO PARTS 49.64 HEADLIGHTS(4) 183735 2131-527360 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 75.94 PARTS FOR 0737 183736 2131-526815 1072 6230 VEHICLE SUPPLIES&PARTS STREET MAINTENANCE 01000 08 44.87 PARTS FOR#3211 183737 2131-526695 6302 6230 VEHICLE SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 2.89- 183737 2131-526695 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 32.86 PARTS FOR SWEEPER 183738 2131-527256 6402 6220 EQUIP SUPPLIES&PARTS STORM WATER UTILITY OPERA 06400 08 64.88 PARTS FOR MOWER 0945 183866 2131-527610 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 265.30 151006 4/10/2020 117624 AMES,JENNY 35.00 CANCELLED ARTS AND CRAFTS 183729 041820 4502 5355 DONATIONS RRC CAPITAL IMPROVEMENT F 04500 09 35.00 151007 4/10/2020 100193 APPLE VALLEY,CITY OF 20,270.93 2ND QTR CABLE JPA AGREEMENT 183950 7045 4005 6401 PROFESSIONAL SERVICES CABLE/COMMUNICATIONS PROD 04000 01 20,270.93 151008 4/10/2020 113303 ARTISAN BEER COMPANY 655.40 SURLY BEER ORDER 183985 3412784 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 655.40 151009 4/10/2020 100493 BELLBOY CORPORATION 642.51 LIQUOR&SPIRITS ORDER 183922 0083417300 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 213.73 BAG ORDER 183923 0101100600 6115 6250 OTHER SUPPLIES&PARTS PILOT KNOB LIQUOR 06100 02 719.09 LIQUOR SUPPLIES&MIXES ORDER 183923 0101100600 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,575.33 151010 4/10/2020 112555 BENNETT,KAY 37.00 CANCELL FARIBAULT IN SPRING 183703 042320 1001 4670 RECREATION FEES-SENIOR CTR GENERAL FUND REVENUES 01000 01 37.00 151011 4/10/2020 117623 BENTZ,THERESA 45.00 CANCELLED ARTS AND CRAFTS FAIR 183728 041820 4502 5355 DONATIONS RRC CAPITAL IMPROVEMENT F 04500 09 45.00 151012 4/10/2020 109503 BIFFS,INC 5.32 MAR'20 PRTBLE RNTL-JIM BELL PR 183887 W757053 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 4.58 MAR'20 PRTBLE RNTL-NRTH CRK SK 183888 W757052 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 5.32 MARTO PRTBLE RNTL-NORTH CREEK 183889 W757051 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 5.32 MAR'20 PRTBLE RNTL-EVRGRN KNL 183890 W757050 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 5.32 MAR'20 PRTBLE RNTL-FIRM PRSRVE 183891 W757049 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 5.32 MAR'20 PRTBLE RNTL-MDWVW PRK 183892 W757048 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 9.54 MAR'20 PRTBLE RNTL-FEELY FLDS 183893 W757047 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 2.10 MARTO PRTBLE RNTL-RR PRK 183894 W757046 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 5.32 MAR'20 PRTBLE RNTL-PRRVW PRK 183895 W757045 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 5.32 MARTO PRTBLE RNTL-TMRCK PRK 183896 W757044 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 R55CKS2 LOGIS600V CITY OF FARMINGTON 4/29/2020 7:57:44 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 2 4/1/2020 - 4129/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 5.32 MAR'20 PRTBLE RNTL-LK JULIA 183897 W757043 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 5.32 MAR'20 PRTBLE RNTL-HILL DEE 183898 W757042 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 5.32 MAR'20 PRTBLE RNTL-DKTA EST 183899 W757041 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 5.32 MAR'20 PRTBLE RNTL-DAISY KNLL 183900 W757040 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 74.74 151013 4/10/2020 114472 BREAKTHRU BEVERAGE MN BEER,LLC 9,080.30 BEER ORDER 183964 1091130276 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 9,080.30 151014 4/10/2020 114471 BREAKTHRU BEVERAGE MN WINE&SPIRITS 2,622.29 LIQUOR&SPIRITS ORDER 183967 1081119565 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 223.90 WINE ORDER 183974 1081119566 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,846.19 151015 4/10/2020 109117 BRIESACHER,MARILYN 42.00 RRC YOGA 1/2 SESSION C AND D 183697 031620 1001 4670 RECREATION FEES-SENIOR CTR GENERAL FUND REVENUES 01000 01 67.00 CANCELL FARIBAULT IN SPRING 183707 042320 1001 4670 RECREATION FEES-SENIOR CTR GENERAL FUND REVENUES 01000 01 109.00 151016 4/10/2020 100071 COLLEGE CITY BEVERAGE INC 12,334.40 BEER ORDER 183924 729-01336 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 55.18- BEER ORDER CREDIT 183925 850-00049 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 14,105.52- BEER ORDER CREDIT 183963 511-00141 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 7,161.25 BEER ORDER 183972 511-00142 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 4.90- BEER ORDER CREDIT 183976 729-01371 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 5,330.05 151017 4/10/2020 114574 CRAWFORD,LINDSEY 37.00 CANCELL FARIBAULT IN SPRING 183702 042320 1001 4670 RECREATION FEES-SENIOR CTR GENERAL FUND REVENUES 01000 01 37.00 151018 4/10/2020 113299 CUES 643.00 SEWER CAMERA PARTS 183846 557533 6202 6220 EQUIP SUPPLIES&PARTS SEWER OPERATIONS EXPENSE 06200 08 643.00 151019 4/10/2020 117622 DAVIS,KRISTINA 35.00 CANCELLED ARTS AND CRAFT FAIR 183727 041820 4502 5355 DONATIONS RRC CAPITAL IMPROVEMENT F 04500 09 35.00 151020 4/10/2020 116219 Dea,Elizabeth 70.00 CANCELLED ARTS AND CRAFTS 183692 041820 4502 5355 DONATIONS RRC CAPITAL IMPROVEMENT F 04500 09 70.00 151021 4/10/2020 110462 DENNISON TECHNOLOGY GROUP CONSULTING LLC 217.50 MITEL SERVER UPG TRBLSHOOTING 183755 2-6417 7400 6505 EQUIPMENT REPAIR/MAINTENANCE INFORMATION TECHNOLOGY 07400 04 525.63 MITEL SERVER UPG 183756 2-6420 7400 6505 EQUIPMENT REPAIR/MAINTENANCE INFORMATION TECHNOLOGY 07400 04 R55CKS2 LOGIS600V CITY OF FARMINGTON 4/29/2020 7:57:44 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 3 4/1/2020 - 4/29/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 398.75 MITEL SERVER UPG 183757 2-6421 7400 6505 EQUIPMENT REPAIR/MAINTENANCE INFORMATION TECHNOLOGY 07400 04 108.75 POLYCOM SETUP 183758 2-6434 7400 6401 PROFESSIONAL SERVICES INFORMATION TECHNOLOGY 07400 04 1,250.63 151022 4/10/2020 100057 DICK'S SANITATION SERVICE 8,142.00 JAN-20 WASTE HAULING FEES 183931 DT0003105018 6302 6401 PROFESSIONAL SERVICES SOLID WASTE OPERATIONS 06300 08 6,720.00 MAR-20 WASTE HAULING FEES 183932 DT0003250643 6302 6401 PROFESSIONAL SERVICES SOLID WASTE OPERATIONS 06300 08 6,243.00 FEB'20 WASTE HAULING FEES 183933 DT0003201031 6302 6401 PROFESSIONAL SERVICES SOLID WASTE OPERATIONS 06300 08 45,749.81 MAR-20 RECYCLING RESIDENTIAL 183951 DT0003234474 6302 6401 PROFESSIONAL SERVICES SOLID WASTE OPERATIONS 06300 08 45,749.81- MARTO RECYCLING RESIDENTIAL 183951 DT0003234474 6302 6401 PROFESSIONAL SERVICES SOLID WASTE OPERATIONS 06300 08 45,749.81 MAR-20 RECYCLING RESIDENTIAL 183951 DT0003234474 6302 6560 CONTRACTUAL SERVICES SOLID WASTE OPERATIONS 06300 08 1,419.22 MAR-20 RECYCLING SCHOOLS 183952 DT0003212179 6302 6401 PROFESSIONAL SERVICES SOLID WASTE OPERATIONS 06300 08 1,419.22- MAR-20 RECYCLING SCHOOLS 183952 DT0003212179 6302 6401 PROFESSIONAL SERVICES SOLID WASTE OPERATIONS 06300 08 1,419.22 MARTO RECYCLING SCHOOLS 183952 DT0003212179 6302 6560 CONTRACTUAL SERVICES SOLID WASTE OPERATIONS 06300 08 10,792.49 MAR-20 RECYCLING COMMERCIAL 183953 DT0003234473 6302 6401 PROFESSIONAL SERVICES SOLID WASTE OPERATIONS 06300 08 10,792.49- MAR-20 RECYCLING COMMERCIAL 183953 DT0003234473 6302 6401 PROFESSIONAL SERVICES SOLID WASTE OPERATIONS 06300 08 10,792.49 MAR'20 RECYCLING COMMERCIAL 183953 DT0003234473 6302 6560 CONTRACTUAL SERVICES SOLID WASTE OPERATIONS 06300 08 79,066.52 151023 4/10/2020 100270 EMERGENCY MEDICAL PRODUCTS INC 837.37 SANIZIDE/NITRILE GLOVES 183870 2143644 1060 6250 00019 OTHER SUPPLIES&PARTS FIRE SERVICES 01000 06 837.37 151024 4/10/2020 110962 FALLS,PHYLLIS 67.00 CANCELL FARIBAULT IN SPRING 183705 042320 1001 4670 RECREATION FEES-SENIOR CTR GENERAL FUND REVENUES 01000 01 67.00 151025 4/10/2020 117604 FISCHER,MARY 35.00 CANCELLED ARTS AND CRAFTS FAIR 183709 041820 4502 5355 DONATIONS RRC CAPITAL IMPROVEMENT F 04500 09 35.00 151026 4/10/2020 117621 FORD,JENNIFER 45.00 CANCELLED ARTS AND CRAFTS FAIR 183726 0418120 4502 5355 DONATIONS RRC CAPITAL IMPROVEMENT F 04500 09 45.00 151027 4/10/2020 100077 FRONTIER COMMUNICATIONS 73.68 APR'20ARENAALARM LINE 183884 651-463-3016 2502 6411 TELEPHONE/CABLESERVICES ICE ARENA OPERATIONS EXPE 02500 09 APRIL'20 73.68 151028 4/10/2020 100016 GERSTER JEWELERS 100.00 REDMOND-EE RECOGNITION 15 YR 184000 15 YR EE REC- 1011 7420 OTHER HUMAN RESOURCES 01000 04 REDMUND,C 100.00 151029 4/10/2020 100027 GREAT LAKES COCA-COLA DISTRIBUTION,LLC R55CKS2 LOGIS600V CITY OF FARMINGTON 4/29/2020 7:57:44 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 4 4/1/2020 - 4/29/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 478.32 POP ORDER 183977 3608209849 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 478.32 151030 4/10/2020 103029 GUNDERSON,KATHY&THOMAS 47.00 CANCELL FARIBAULT IN SPRING 183704 042320 1001 4670 RECREATION FEES-SENIOR CTR GENERAL FUND REVENUES 01000 01 47.00 151031 4/10/2020 117583 HIATT,ROSSALYN 67.00 CANCELL FARIBAULT IN SPRING 183700 042320 1001 4670 RECREATION FEES-SENIOR CTR GENERAL FUND REVENUES 01000 01 67.00 151032 4/10/2020 100074 HOHENSTEINS INC 1,382.00 BEER ORDER 183970 198657 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,382.00 151033 4/10/2020 117620 HUNECKE,JUDY 45.00 CANCELLED ARTS AND CRAFTS FAIR 183725 041820 4502 5355 DONATIONS RRC CAPITAL IMPROVEMENT F 04500 09 45.00 151034 4/10/2020 112416 IMPACT MAILING OF MN,INC 260.16 MAR'20 UB BILL POSTAGE 183751 146725 6502 6445 POSTAGE WATER UTILITY EXPENSE 06500 08 260.16 MAR'20 UB BILL POSTAGE 183751 146725 6402 6445 POSTAGE STORM WATER UTILITY OPERA 06400 08 14.38- 183751 146725 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 260.16 MAR'20 UB BILL POSTAGE 183751 146725 6302 6445 POSTAGE SOLID WASTE OPERATIONS 06300 08 260.16 MAR'20 UB BILL POSTAGE 183751 146725 6202 6445 POSTAGE SEWER OPERATIONS EXPENSE 06200 08 53.85 MAR'20 UB MAIL PREP 183751 146725 6202 6401 PROFESSIONAL SERVICES SEWER OPERATIONS EXPENSE 06200 08 57.55 MAR'20 UB MAIL PREP 183751 146725 6302 6401 PROFESSIONAL SERVICES SOLID WASTE OPERATIONS 06300 08 53.85 MAR'20 UB MAIL PREP 183751 146725 6402 6401 PROFESSIONAL SERVICES STORM WATER UTILITY OPERA 06400 08 53.85 MAR'20 UB MAIL PREP 183751 146725 6502 6401 PROFESSIONAL SERVICES WATER UTILITY EXPENSE 06500 08 155.31 2020 RATE INCREASE INSERT 183751 146725 6502 6401 PROFESSIONAL SERVICES WATER UTILITY EXPENSE 06500 08 155.31 2020 RATE INCREASE INSERT 183751 146725 6402 6401 PROFESSIONAL SERVICES STORM WATER UTILITY OPERA 06400 08 165.99 2020 RATE INCREASE INSERT 183751 146725 6302 6401 PROFESSIONAL SERVICES SOLID WASTE OPERATIONS 06300 08 155.31 2020 RATE INCREASE INSERT 183751 146725 6202 6401 PROFESSIONAL SERVICES SEWER OPERATIONS EXPENSE 06200 08 1,877.28 151035 4/10/2020 100176 JEFF BELZER'S CHEV-DODGE-KIA 99.00 EXTRA VEHICLE KEY 183744 858503 1051 6230 VEHICLE SUPPLIES&PARTS PATROL SERVICES 01000 05 128.82 SPARE KEYS DEPUTY PICK-UP 183954 373603 1060 6230 VEHICLE SUPPLIES&PARTS FIRE SERVICES 01000 06 227.82 151036 4/10/2020 109846 JJ TAYLOR DISTRIBUTING COMPANY OF MN INC 8,553.05 BEER ORDER 183968 3084441 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 8,553.05 151037 4/10/2020 100033 JOHNSON BROTHERS LIQUOR COMPANY 1,317.57 LIQUOR&SPIRITS ORDER 183969 1534648 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 R55CKS2 LOGIS600V CITY OF FARMINGTON 4/29/2020 7:57:44 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 5 4/1/2020 - 4/29/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept D 825.00 LIQUOR&SPIRITS ORDER 183971 1534937 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 103.51 SVEDKA VODKA ORDER 183981 1534643 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,286.03 LIQUOR&SPIRITS ORDER 183982 1534649 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 41.51 REAL COCO ORDER 183983 1534651 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 89.52 CUERVO MIX MARG LIME ORDER 183992 1534646 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,129.57 WINE ORDER 183993 1534647 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 5,046.15 LIQUOR&SPIRITS ORDER 183994 1534645 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,277.52 WINE ORDER 183996 1534644 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,045.67 WINE ORDER 183997 1534650 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 14,162.05 151038 4/10/2020 110766 JOHNSON CONTROLS FIRE PROTECTION LP 424.67 FIRE/SPRNKLR INSP FEES F2 183855 21535310 1060 6515 BUILDING REPAIR/MAINTENANCE FIRE SERVICES 01000 06 705.33 FIREALARM/SPRNKLR TESTING 183872 21535312 1050 6515 BUILDING REPAIR/MAINTENANCE POLICE ADMINISTRATION 01000 05 84.84 CMF FIRE ALARM MONITORING 183902 21535311 1072 6515 BUILDING REPAIR/MAINTENANCE STREET MAINTENANCE 01000 08 84.84 CMF ALARM MONITRNG 183902 21535311 1090 6515 BUILDING REPAIR/MAINTENANCE PARK MAINTENANCE 01000 09 5.83- 183902 21535311 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 84.82 CMF ALARM MONITRNG 183902 21535311 6202 6515 BUILDING REPAIR/MAINTENANCE SEWER OPERATIONS EXPENSE 06200 08 90.67 CMF ALARM MONITRNG 183902 21535311 6302 6515 BUILDING REPAIR/MAINTENANCE SOLID WASTE OPERATIONS 06300 08 84.84 CMF ALARM MONITRNG 183902 21535311 6402 6515 BUILDING REPAIR/MAINTENANCE STORM WATER UTILITY OPERA 06400 08 83.82 CMF ALARM MONITRNG 183902 21535311 6502 6515 BUILDING REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 377.88 2020 RRC ALARM MONITORING 183903 21538275 1093 6515 BUILDING REPAIR/MAINTENANCE SENIOR CITIZEN SERVICES 01000 09 275.60 2020 RRC ALARM MONITORING 183904 21537463 1093 6515 BUILDING REPAIR/MAINTENANCE SENIOR CITIZEN SERVICES 01000 09 21.91 1ST ST GARALARM MONITRNG 183905 21538038 1072 6515 BUILDING REPAIR/MAINTENANCE STREET MAINTENANCE 01000 08 21.90 1ST ST GAR ALARM MONITRNG 183905 21538038 1090 6515 BUILDING REPAIR/MAINTENANCE PARK MAINTENANCE 01000 09 1.51- 183905 21538038 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 21.91 1ST ST GARALARM MONITRNG 183905 21538038 6202 6515 BUILDING REPAIR/MAINTENANCE SEWER OPERATIONS EXPENSE 06200 08 23.42 1ST ST GAR ALARM MONITRNG 183905 21538038 6302 6515 BUILDING REPAIR/MAINTENANCE SOLID WASTE OPERATIONS 06300 08 21.91 IST ST GAR ALARM MONITRNG 183905 21538038 6402 6515 BUILDING REPAIR/MAINTENANCE STORM WATER UTILITY OPERA 06400 08 21.64 1ST ST GAR ALARM MONITRNG 183905 21538038 6502 6515 BUILDING REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 818.62 CITYHALLALRM MONITORING 183906 21537173 1015 6515 BUILDING REPAIR/MAINTENANCE CITY HALL 01000 01 131.18 CITYHALLALRM MONITORING 183907 21537305 1015 6515 BUILDING REPAIR/MAINTENANCE CITY HALL 01000 01 60.17 1ST STREET FIRE ALARM MONITOR 183908 21537172 1072 6515 BUILDING REPAIR/MAINTENANCE STREET MAINTENANCE 01000 08 60.16 1 ST ST GAR ALARM MONITRNG 183908 21537172 1090 6515 BUILDING REPAIR/MAINTENANCE PARK MAINTENANCE 01000 09 4.14- 183908 21537172 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 60.16 1ST ST GAR ALARM MONITRNG 183908 21537172 6202 6515 BUILDING REPAIR/MAINTENANCE SEWER OPERATIONS EXPENSE 06200 08 64.30 1ST ST GARALARM MONITRNG 183908 21537172 6302 6515 BUILDING REPAIR/MAINTENANCE SOLID WASTE OPERATIONS 06300 08 60.16 1ST ST GARALARM MONITRNG 183908 21537172 6402 6515 BUILDING REPAIR/MAINTENANCE STORM WATER UTILITY OPERA 06400 08 59.44 IST ST GAR ALARM MONITRNG 183908 21537172 6502 6515 BUILDING REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 21.26 CMF FIRE ALARM MONITOR 183909 21535739 1072 6515 BUILDING REPAIR/MAINTENANCE STREET MAINTENANCE 01000 08 21.24 CMF ALARM MONITRNG 183909 21535739 1090 6515 BUILDING REPAIR/MAINTENANCE PARK MAINTENANCE 01000 09 1.46- 183909 21535739 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 R55CKS2 LOGIS600V CITY OF FARMINGTON 4/29/2020 7:57:44 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 6 4/1/2020 - 4/29/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 21.24 CMF ALARM MONITRNG 183909 21535739 6202 6515 BUILDING REPAIR/MAINTENANCE SEWER OPERATIONS EXPENSE 06200 08 22.70 CMF ALARM MONITRNG 183909 21535739 6302 6515 BUILDING REPAIR/MAINTENANCE SOLID WASTE OPERATIONS 06300 08 21.24 CMF ALARM MONITRNG 183909 21535739 6402 6515 BUILDING REPAIR/MAINTENANCE STORM WATER UTILITY OPERA 06400 08 20.99 CMF ALARM MONITRNG 183909 21535739 6502 6515 BUILDING REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 56.00 RRC ALARM REPAIR 183913 86657115 1093 6515 BUILDING REPAIR/MAINTENANCE SENIOR CITIZEN SERVICES 01000 09 266.81 FD STATION#1 ALARM MONITORING 183942 21539567 1060 6515 BUILDING REPAIR/MAINTENANCE FIRE SERVICES 01000 06 4,182.73 151039 4/10/2020 113114 JOHNSON,JULIA 37.00 CANCELL FARIBAULT IN SPRING 183701 042320 1001 4670 RECREATION FEES-SENIOR CTR GENERAL FUND REVENUES 01000 01 37.00 151040 4/10/2020 117619 KARGEL,JEANNE 55.00 CANCELLED ARTS AND CRAFTS FAIR 183724 041820 4502 5355 DONATIONS RRC CAPITAL IMPROVEMENT F 04500 09 55.00 151041 4/10/2020 113700 KINARD,SHARON 35.00 CANCELLED ARTS AND CRAFTS FAIR 183693 041820 4502 5355 DONATIONS RRC CAPITAL IMPROVEMENT F 04500 09 35.00 151042 4/10/2020 117618 LARSEN,ALISA 35.00 CANCELLED ARTS AND CRAFTS FAIR 183723 041820 4502 5355 DONATIONS RRC CAPITAL IMPROVEMENT F 04500 09 35.00 151043 4/10/2020 117617 LARSON,KATHRYN 45.00 CANCELLED ARTS AND CRAFT SHOW 183722 041820 4502 5355 DONATIONS RRC CAPITAL IMPROVEMENT F 04500 09 45.00 151044 4/10/2020 117616 LEMKE,JANTHRA 35.00 CANCELLED ARTS AND CRAFTS FAIR 183721 041820 4502 5355 DONATIONS RRC CAPITAL IMPROVEMENT F 04500 09 35.00 151045 4/10/2020 116190 Lloyd,Trudi 35.00 CANCELLED ARTS AND CRAFTS FAIR 183694 041820 4502 5355 DONATIONS RRC CAPITAL IMPROVEMENT F 04500 09 35.00 151046 4/10/2020 117615 LOFTUS,LYNNE 45.00 CANCELLED ARTS AND CRAFTS FAIR 183720 041820 4502 5355 DONATIONS RRC CAPITAL IMPROVEMENT F 04500 09 45.00 151047 4/10/2020 117625 MADY,ALICIA 35.00 CANCELLED ARTS AND CRAFTS 183730 041820 4502 5355 DONATIONS RRC CAPITAL IMPROVEMENT F 04500 09 35.00 151048 4/10/2020 115581 MARKET ON OAK 50.00 15 YR EE REC REDMOND,C. 184001 15 YR EE REC 1011 7420 OTHER HUMAN RESOURCES 01000 04 REDMOND C. 50.00 R55CKS2 LOGIS600V CITY OF FARMINGTON 4/29/2020 7:57:44 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 7 4/1/202D - 4/29/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 151049 4/10/2020 100155 METROPOLITAN COUNCIL ENVIRO SERVICES 27,335.00 MAR'20 MCES SAC FEES 183961 MAR'20 MCES SAC 6200 2425 MCES SAC(SWR AVAIL CHG) SEWER OPERATIONS 06200 08 FEES 273.35- MARTO MCES SAC FEES 183961 MAR'20 MCES SAC 6201 5030 SAC CHARGE RETAINER SEWER OPERATIONS REVENUE 06200 08 FEES 27,061.65 151050 4/10/2020 100134 MINNESOTA POLLUTION CONTROL AGENCY 23.00 WSTWTR CERT:BERRA,N 183740 20200601 BERRA,N 6202 6460 MEMBER DUES&LICENSURE SEWER OPERATIONS EXPENSE 06200 08 23.00 151051 4/10/2020 102249 MN FIRE SERVICE CERTIFICATION BOARD 720.00 FFI CERT EXAM FEES (6) 183854 7591 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01000 06 1,190.00 HAZ MAT OF CLASS FEES(7) 183854 7591 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01000 06 720.00 FFII CERT EXAM FEES(6) 183854 7591 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01000 06 25.00 FFI RETEST FEE(1) 183854 7591 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01000 06 2,655.00 151052 4/10/2020 117378 MOORE,PEGGY 67.00 CANCELL FARIBAULT IN SPRING 183699 042320 1001 4670 RECREATION FEES-SENIOR CTR GENERAL FUND REVENUES 01000 01 67.00 151053 4/10/2020 117614 MOREY,CONNIE 45.00 CANCELLED ARTS AND CRAFTS FAIR 183719 041820 4502 5355 DONATIONS RRC CAPITAL IMPROVEMENT F 04500 09 45.00 151054 4/10/2020 100544 MOTOROLA SOLUTIONS INC 803.25 SQUAD RADIO HEAD 184009 8280926196 5602 6940 50 VEHICLES-POLICE GEN CAPITAL EQUIP FUND EX 05600 803.25 151055 4/10/2020 102936 NORTHERN DOOR COMPANY 474.00 CMF DOOR REPAIR 183837 66504 1072 6515 BUILDING REPAIR/MAINTENANCE STREET MAINTENANCE 01000 08 474.00 CMF DOOR REPAIR 183837 66504 1090 6515 BUILDING REPAIR/MAINTENANCE PARK MAINTENANCE 01000 09 32.59- 183837 66504 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 474.00 CMF DOOR REPAIR 183837 66504 6202 6515 BUILDING REPAIR/MAINTENANCE SEWER OPERATIONS EXPENSE 06200 08 506.59 CMF DOOR REPAIR 183837 66504 6302 6515 BUILDING REPAIR/MAINTENANCE SOLID WASTE OPERATIONS 06300 08 474.00 CMF DOOR REPAIR 183837 66504 6402 6515 BUILDING REPAIR/MAINTENANCE STORM WATER UTILITY OPERA 06400 08 468.30 CMF DOOR REPAIR 183837 66504 6502 6515 BUILDING REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 2,838.30 151056 4/10/2020 102644 NORTHERN SAFETY TECHNOLOGY,INC 345.37 COMPUTER MOUNT FOR CHIEF VEHIC 183851 49754 1060 6230 VEHICLE SUPPLIES&PARTS FIRE SERVICES 01000 06 345.37 151057 4/10/2020 117613 PAGE,RHONDA R55CKS2 LOGIS600V CITY OF FARMINGTON 4/29/2020 7:57:44 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 8 4/1/2020 - 4/29/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept D 35.00 CANCELLED ARTS AND CRAFTS FAIR 183718 041820 4502 5355 DONATIONS RRC CAPITAL IMPROVEMENT F 04500 09 35.00 151058 4/10/2020 100290 PAUSTIS&SONS WINE COMPANY 608.50 WINE ORDER 183966 85326 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 608.50 151059 4/10/2020 100093 PELLICCI HARDWARE&RENTAL 1.49 PVC COUPLING 183743 32166 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 133.92 RRC HVAC EQUIP FILTERS 183749 43223 1093 6220 EQUIP SUPPLIES&PARTS SENIOR CITIZEN SERVICES 01000 09 39.99 VEHICLE KEY 183759 K32106/F'20 1070 6230 VEHICLE SUPPLIES&PARTS ENGINEERING SERVICES 01000 07 7.96 DOOR STOP TIPS 183835 K34095/F 1050 6515 BUILDING REPAIR/MAINTENANCE POLICE ADMINISTRATION 01000 05 53.89 FURNACE FILTERS BOTH FIRE STAT 183849 K33994/F 1060 6240 BUILDING SUPPLIES&PARTS FIRE SERVICES 01000 06 3.00 PLUMBING REPAIR 183885 K34116/F 1072 6220 EQUIP SUPPLIES&PARTS STREET MAINTENANCE 01000 08 3.00 FLEX TAPE/CLAMPS 183885 K34116/F 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 .21- 183885 K34116/F 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 3.00 FLEX TAPE/CLAMPS 183885 K34116/1' 6202 6220 EQUIP SUPPLIES&PARTS SEWER OPERATIONS EXPENSE 06200 08 3.21 FLEX TAPE/CLAMPS 183885 K34116/F 6302 6220 EQUIP SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 3.00 FLEX TAPE/CLAMPS 183885 K34116/F 6402 6220 EQUIP SUPPLIES&PARTS STORM WATER UTILITY OPERA 06400 08 2.97 FLEX TAPE/CLAMPS 183885 K34116/F 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 46.95 GLUE/PAINT SCRAPERS 183886 K34110 2502 6220 EQUIP SUPPLIES&PARTS ICE ARENA OPERATIONS EXPE 02500 09 8.99 DRILL BIT 183914 K23996/F 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 11.96 SPRAY BOTTLES FOR DISINFECTANT 183917 K24279/F 1050 6242 00019 CLEANING SUPPLIES POLICE ADMINISTRATION 01000 05 47.88 HAND SOAP AND SANITIZER 183920 K33861 1015 6242 00019 CLEANING SUPPLIES CITY HALL 01000 01 18.47 CAULK/ANCHORS/CAULK TOOL SET 183939 32294/F'20 1093 6220 EQUIP SUPPLIES&PARTS SENIOR CITIZEN SERVICES 01000 09 192.00 BTTLED WATER FOR TRAINING 183943 25145/F 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01000 06 60.00 BTTLED WATER FOR FIRE GRND 183944 K24025/F 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01000 06 641.47 151060 4/10/2020 113294 PEPERA,VICKI 42.00 RRC YOGA 1/2 SESSION C AND D 183698 031820 1001 4670 RECREATION FEES-SENIOR CTR GENERAL FUND REVENUES 01000 01 67.00 CANCELL FARIBAULT IN SPRING 183706 042320 1001 4670 RECREATION FEES-SENIOR CTR GENERAL FUND REVENUES 01000 01 109.00 151061 4/10/2020 100032 PEPSI COLA COMPANY 192.40 POP ORDER 183975 27604609 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 192.40 151062 4/10/2020 100034 PHILLIPS WINE AND SPIRITS,INC 160.53 WINE ORDER 183978 6020114 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,386.37 LIQUOR&SPIRITS ORDER 183984 6020112 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,155.33 WINE ORDER 183995 6020113 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 4,702.23 151063 4/10/2020 114224 RADCO-BURNSVILLE R55CKS2 LOGIS600V CITY OF FARMINGTON 4/29/2020 7:57:44 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 9 4/1/2020 - 4/29/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 20.00 DCKD DRWR DIVIDER:CHF VHCLE 183960 BR-1043647 1060 6230 VEHICLE SUPPLIES&PARTS FIRE SERVICES 01000 06 20.00 151064 4/10/2020 117612 REZAC,DON 35.00 CANCELLED ARTS AND CRAFTS FAIR 183717 041820 4502 5355 DONATIONS RRC CAPITAL IMPROVEMENT F 04500 09 35.00 151065 4/10/2020 112632 RICOH USA,INC 5.12 MAR'20 COPIER MAINTENANCE 183949 5059203245 1010 6505 EQUIPMENT REPAIR/MAINTENANCE ADMINISTRATION 01000 01 1,170.60 JAN-MAR'20 COPIER MAINTENANCE 183986 5059223409 1010 6505 EQUIPMENT REPAIR/MAINTENANCE ADMINISTRATION 01000 01 421.32 MAR'20 COPIER MAINTENANCE 183987 5059223461 1010 6505 EQUIPMENT REPAIR/MAINTENANCE ADMINISTRATION 01000 01 1,597.04 151066 4/10/2020 117595 ROWE,DOUG 130.95 FOOD FOR OFFICER MEETING 183850 20200310-ROWE 4302 6480 MEETING EXPENSE FIRE RELIEF 04300 06 130.95 151067 4/10/2020 117611 SCHLICHLE,YVONNE 45.00 CANCELLED ARTS AND CRAFTS FAIR 183716 041820 4502 5355 DONATIONS RRC CAPITAL IMPROVEMENT F 04500 09 45.00 151068 4/10/2020 116192 Schmidt,Mary 35.00 CANCELLED ARTS AND CRAFTS FAIR 183696 041820 4502 5355 DONATIONS RRC CAPITAL IMPROVEMENT F 04500 09 35.00 151069 4/10/2020 117603 SIPLE,MARY 42.00 RRC YOGA 1/2 SESSION C AND D 183848 031820 1001 4670 RECREATION FEES-SENIOR CTR GENERAL FUND REVENUES 01000 01 42.00 151070 4/10/2020 103130 SOLBERG AGGREGATE,INC 537.60 HAUL GRAVEL TO 190TH 183930 22373 1072 6253 STREET MATERIALS STREET MAINTENANCE 01000 08 537.60 151071 4/10/2020 112051 SOUTHERN GLAZER'S OF MN 6,620.66 LIQUOR&SPIRITS ORDER 183965 1940105 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 6,620.66 151072 4/10/2020 100496 SPEIKER,MARILYN 25.00 CANCELLED ARTS AND CRAFTS FAIR 183695 041820 4502 5355 DONATIONS RRC CAPITAL IMPROVEMENT F 04500 09 25.00 151073 4/10/2020 100379 SPRINT-NEXTEL 28.18 MAR 2020 SOLID WASTE TRACKER 183873 875483313-220 6302 6412 CELLULAR SERVICES SOLID WASTE OPERATIONS 06300 08 1.81- 183873 875483313-220 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 26.37 151074 4/10/2020 116461 STOUT,MARY 67.00 CANCELL FARIBAULT IN SPRING 183847 042320 1001 4670 RECREATION FEES-SENIOR CTR GENERAL FUND REVENUES 01000 01 R55CKS2 LOGIS600V CITY OF FARMINGTON 4/29/2020 7:57:44 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 10 4/1/2020 - 4/29/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 67.00 151075 4/10/2020 117610 TENNANT,DENIANN 35.00 CANCELLED ARTS AND CRAFT FAIR 183715 041820 4502 5355 DONATIONS RRC CAPITAL IMPROVEMENT F 04500 09 35.00 151076 4/10/2020 117608 THOMAS,SHIRLEY 45.00 CANCELLED ARTS AND CRAFT FAIR 183713 041820 4502 5355 DONATIONS RRC CAPITAL IMPROVEMENT F 04500 09 45.00 151077 4/10/2020 112307 T-MOBILE USA INC 6.66 MAR'20 GPS SERVICE 183915 823329497 MAR'20 6502 6412 CELLULAR SERVICES WATER UTILITY EXPENSE 06500 08 6.66 MAR'20 GPS SERVICE 183915 823329497 MAR'20 6202 6412 CELLULAR SERVICES SEWER OPERATIONS EXPENSE 06200 08 6.67 MAR'20 GPS SERVICE 183915 823329497 MARTO 6402 6412 CELLULAR SERVICES STORM WATER UTILITY OPERA 064D0 08 19.99 151078 4/10/2020 117607 TORMAN,CHRISTINA 70.00 CANCELLED ARTS AND CRAFT FAIR 183712 041820 4502 5355 DONATIONS RRC CAPITAL IMPROVEMENT F 04500 09 70.00 151079 4/10/2020 115645 TRANSUNION,LLC 17.93 MAR'20 BKGRD CREDIT CHECK 183988 03056004 1011 6405 EMPLOYMENT TESTING HUMAN RESOURCES 01000 04 17.93 151080 4/10/2020 116210 TRAXLER,TOMMY 35.00 CANCELLED ARTS AND CRAFT FAIR 183708 041820 4502 5355 DONATIONS RRC CAPITAL IMPROVEMENT F 04500 09 35.00 151081 4/10/2020 117609 TURNER,WYNN 35.00 CANCELLED ARTS AND CRAFT FAIR 183714 041820 4502 5355 DONATIONS RRC CAPITAL IMPROVEMENT F 04500 09 35.00 151082 4/10/2020 117606 ULRICH,THOMAS 35.00 CANCELLED ARTS AND CRAFT FAIR 183711 040820 4502 5355 DONATIONS RRC CAPITAL IMPROVEMENT F 04500 09 35.00 151083 4/10/2020 117605 VERHEY,CJ 35.00 CANCELLED ARTS AND CRAFT FAIR 183710 041820 4502 5355 DONATIONS RRC CAPITAL IMPROVEMENT F 04500 09 35.00 151084 4/10/2020 108808 VINOCOPIA,INC 279.50 WINE ORDER 183980 0254530-IN 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 279.50 151085 4/10/2020 102592 WINE COMPANY,THE 316.20 WINE ORDER 183973 139445 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 316.20 151086 4/10/2020 100334 WINE MERCHANTS R55CKS2 LOGIS600V CITY OF FARMINGTON 4/29/2020 7:57:44 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 11 4/1/2020 - 4/29/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept D 235.02 WINE ORDER 183979 7279885 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 235.02 151087 4/10/2020 115011 WOOTON,GINA 21.44 MILEAGE:FORFTRE TRNG 184011 20200130-WOOTON 1050 6485 MILEAGE REIMBURSEMENT POLICE ADMINISTRATION 01000 05 21.44 151088 4/10/2020 100020 ZARNOTH BRUSH WORKS INC 795.20 COLD PATCH 183741 0178703-IN 1072 6253 STREET MATERIALS STREET MAINTENANCE 01000 08 795.20 151089 4/17/2020 113906 AMERICAN SOLUTIONS FOR BUSINESS 166.35 CITY FLAG WITH NEW LOGO 183879 INVO4655114 1010 6450 OUTSIDE PRINTING ADMINISTRATION 01000 01 166.35 151090 4/17/2020 100011 ANDERSEN,EARL F 1,418.83 STREET SIGNS 183537 0122735-IN 1072 6254 SIGNS&STRIPING MATERIALS STREET MAINTENANCE 01000 08 259.60 STREET SIGNS(12) 183633 0122771-IN 1072 6254 SIGNS&STRIPING MATERIALS STREET MAINTENANCE 01000 08 1,678.43 151091 4/17/2020 106097 APPLIED CONCEPTS INC 290.00 SQD 02 RADAR CABLES 183562 364318 5602 6940 50 VEHICLES-POLICE GEN CAPITAL EQUIP FUND EX 05600 290.00 151092 4/17/2020 113303 ARTISAN BEER COMPANY 852.60 BEER ORDER 184072 3413405 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 852.60 151093 4/17/2020 108446 ASPEN MILLS,INC. 189.95 UNIFORM ITEMS:FRANCIS,G. 183857 254786 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 24.00 UNIFORM ITEMS:FRANCIS,G. 183859 254789 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 182.30 UNIFORM ITEMS:JONES,M. 183860 254785 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 195.85 UNIFORM ITEMS:BOLTON,C 183861 254788 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 200.00 UNIFORM ITEMS:ARENS,MARK 183862 254787 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 175.85 UNIFORM ITEMS:ALLBEE,J 183863 254782 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 220.35 UNIFORM ITEMS:PRICE,M 183864 254783 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 273.65 UNIFORM ITEMS:MATTINGLY,S 183867 254784 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 1,461.95 151094 4/17/2020 100079 ASPENWALL TREE SERVICE,INC. 6,650.00 MAR'20 TREE TRIMMING SVS 184095 18-0713 5751 6560 CONTRACTUAL SERVICES EMERALD ASH BORER PROJECT 05700 6,650.00 151095 4/17/2020 100493 BELLBOY CORPORATION 92.55 LIQUOR&SPIRITS ORDER 184074 0083558600 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 340.02 LIQUOR SUPPLIES&MIXES ORDER 184076 101150100 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 432.57 R55CKS2 LOGIS600V CITY OF FARMINGTON 4/29/2020 7:57:44 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 12 4/1/2020 - 4/29/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 151096 4/17/2020 110290 BOLTON&MENK,INC 10,263.50 FEB'20 SVS:TH3 LPP TRL DSGN 183941 0247853 5721 6401 02002 PROFESSIONAL SERVICES TRAIL MAINTENANCE 05700 10,263.50 151097 4/17/2020 114472 BREAKTHRU BEVERAGE MN BEER,LLC 4,880.30 BEER ORDER 184078 1091131231 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 4,880.30 151098 4/17/2020 114471 BREAKTHRU BEVERAGE MN WINE&SPIRITS 2,642.81 LIQUOR&SPIRITS ORDER 184077 1081121244 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 446.02 WINE ORDER 184079 1081121245 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 3,088.83 151099 4/17/2020 111050 CASTLE ROCK KENNELS INC 125.00 MAR'20 ANIMAL CNTRL BOARDING 183561 27549 1050 6401 PROFESSIONAL SERVICES POLICE ADMINISTRATION 01000 05 125.00 151100 4/17/2020 110511 CHARTER COMMUNICATIONS HOLDINGS,LLC 541.39 APR'20 CABLE&ALARM LINES 183948 0001792040120 7400 6411 TELEPHONE/CABLE SERVICES INFORMATION TECHNOLOGY 07400 04 541.39 151101 4/17/2020 100071 COLLEGE CITY BEVERAGE INC 4,844.75 BEER ORDER 184071 722-01442 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 4,844.75 151102 4/17/2020 109182 DAKOTA COMMUNICATIONS CENTER 8,458.67 MAY 2020 DCC FEES 183731 FA2020-05 1060 6560 CONTRACTUAL SERVICES FIRE SERVICES 01000 06 16,917.33 MAY 2020 DCC FEES 183731 FA2020-05 1050 6560 CONTRACTUAL SERVICES POLICE ADMINISTRATION 01000 05 25,376.00 151103 4/17/2020 110844 DAKOTA COUNTY FINANCIAL SRVS 273.68 1ST QTR 2020 UTILITIES 184050 00038062 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 273.68 151104 4/17/2020 100041 DAKOTA COUNTY PROPERTY TAXATION 623.00 2019 TIF MAINTENANCE 183621 2019 TIF 2054 6401 PROFESSIONAL SERVICES TRIDENT HOUSING TIF DIST 02054 07 MAINTENANCE 623.00 151105 4/17/2020 111645 DALCO ENTERPRISES,INC 363.73 [-MOP XXL REPAIR 183921 3585431 6110 6505 EQUIPMENT REPAIR/MAINTENANCE DOWNTOWN LIQUOR REV&EXP 06100 02 17.93- 183921 3585431 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 345.80 151106 4/17/2020 105810 DLT SOLUTIONS INC 4,777.44 AUTOCAD CIVIL/31D ANNUAL MAINT 184005 4826945A 7400 6505 EQUIPMENT REPAIR/MAINTENANCE INFORMATION TECHNOLOGY 07400 04 4,777.44 R55CKS2 LOGIS600V CITY OF FARMINGTON 4/29/2020 7:57:44 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 13 4/1/2020 - 4/29/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description SU Description Co Dept D 151107 4/17/2020 103692 FASTENAL COMPANY 37.13 GREEN FLAGS 183935 MNLAK174029 6202 6220 EQUIP SUPPLIES&PARTS SEWER OPERATIONS EXPENSE 06200 08 183.06 RED PAINT/FLAGS 183935 MNLAK174029 6602 6220 EQUIP SUPPLIES&PARTS STREETLIGHT UTILITY EXPEN 06600 08 183.39 ORANGE PAINT/FLAGS 183935 MNLAK174029 7400 6220 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 53.38 WHITE PAINT 183935 MNLAK174029 1072 6220 EQUIP SUPPLIES&PARTS STREET MAINTENANCE 01000 08 456.96 151108 4/17/2020 103373 GRAYBAR ELECTRIC CO INC 175.95 STREET LIGHT LOWER ASSY 184047 9315251136 6602 6220 EQUIP SUPPLIES&PARTS STREETLIGHT UTILITY EXPEN 06600 08 175.95 151109 4/17/2020 100074 HOHENSTEINS INC 866.00 BEER ORDER 184075 199233 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 866.00 151110 4/17/2020 113417 INDEED BREWING COMPANY,LLC 103.02 BEER ORDER 184080 88938 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 103.02 151111 4/17/2020 111773 INNOVATIVE OFFICE SOLUTIONS,LLC 106.36 PERMIT PAPER 183543 IN2932411 1010 6210 OFFICE SUPPLIES ADMINISTRATION 01000 01 106.36 151112 4/17/2020 109846 JJ TAYLOR DISTRIBUTING COMPANY OF MN INC 5,045.90 BEER ORDER 184040 3044115 6100 1405 15 INVENTORY PILOT KNOB LIQUOR OPERATIONS 06100 02 1,063.45 BEER ORDER 184067 3045605 6100 1405 15 INVENTORY PILOT KNOB LIQUOR OPERATIONS 06100 02 1,525.95 BEER ORDER 184073 3084470 6100 1405 15 INVENTORY PILOT KNOB LIQUOR OPERATIONS 06100 02 7,635.30 151113 4/17/2020 100033 JOHNSON BROTHERS LIQUOR COMPANY 537.24 CATCH FIRE CINN WHISKY ORDER 184041 1534158 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 227.02 LIQUOR&SPIRITS ORDER 184056 1537735 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 3,188.25 LIQUOR&SPIRITS ORDER 184057 1537737 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,430.94 LIQUOR&SPIRITS ORDER 184058 1537732 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 436.18 WINE ORDER 184059 1537736 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 257.00 WINE ORDER 184060 1537734 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 54.00 KINKY COCKTAILS ORDER 184061 1537731 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 115.53 LIQUOR MIXES ORDER 184062 1537733 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 415.45 BUTTERCREAM CHARDONNAY ORDER 184063 1534157 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 625.07 WINE ORDER 184064 1537730 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 376.55 TOWER VODKA ORDER 184065 1534156 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 415.45 BUTTERCREAM CHARDONNAY ORDER 184066 1534159 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 103.01 SVEDKA VODKA ORDER 184083 1537729 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 9,181.69 R55CKS2 LOGIS600V CITY OF FARMINGTON 4/29/2020 7:57:44 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 14 4/1/2020 - 4/29/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 151114 4/17/2020 117632 LAKETOWN ELECTRIC 102.50 VOID ELECT PRMT 45548 184069 VOID ELECT PRMT 1001 4327 ELECTRIC PERMITS GENERAL FUND REVENUES 01000 01 45548 307.50 VOID ELECT PRMT 45548 184069 VOID ELECT PRMT 1000 2020 CONTRACTS PAYABLE GENERAL FUND BALANCE SHEE 01000 45548 10.00 VOID ELECT PRMT 45548 184069 VOID ELECT PRMT 1001 4327 ELECTRIC PERMITS GENERAL FUND REVENUES 01000 01 45548 420.00 151115 4/17/2020 115568 LEAGUE OF MN CITIES 156,925.00 1ST INSTALL 2020 P&L INS PREM. 183628 10003113 032620 7100 6426 INSURANCE INSURANCE 07100 02 156,925.00 151116 4/17/2020 100070 MINNESOTA VALLEY TESTING LABORATORIES 63.00 BAC-T SAMPLE(6) 183549 1023775 6502 6401 PROFESSIONAL SERVICES WATER UTILITY EXPENSE 06500 08 63.00 151117 4/17/2020 100290 PAUSTIS&SONS WINE COMPANY 283.75 WINE ORDER 184042 85691 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 283.75 151118 4/17/2020 100034 PHILLIPS WINE AND SPIRITS,INC 526.09 WINE ORDER 184053 6021917 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 83.82 ZING ZANG BL MARY MIX ORDER 184055 6021918 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,526.76 LIQUOR&SPIRITS ORDER 184082 6021916 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,136.67 151119 4/17/2020 117491 POMP'S TIRE SERVICE,INC 1,537.66 TIRES(11) 184093 210461790 7200 6232 VEHICLE/EQUIPMENT TIRES FLEET OPERATIONS 07200 08 293.86 MOUNT/BALANCE TRUCK TIRES 184094 210459271 6302 6510 1 OUTSIDE VEHICLE REPAIR/MAINT SOLID WASTE OPERATIONS 06300 08 6.36- 184094 210459271 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 1,825.16 151120 4/17/2020 110760 PRO-TECH DESIGN,INC 4,312.50 CAMERA(4)+INST PD&1ST ST G 183625 95824 7400 6960 FURNITURE,OFFICE EQUIP,IT INFORMATION TECHNOLOGY 07400 04 4,312.50 151121 4/17/2020 117564 RECYCLE MINNESOTA LLC 5,658.64 MAR'20 TRANSLOAD FEES 184052 0000001053 6302 6401 PROFESSIONAL SERVICES SOLID WASTE OPERATIONS 06300 08 5,658.64 151122 4/17/2020 112051 SOUTHERN GLAZER'S OF MN .32 DELIVERY CHARGE 182950 1927781 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 5,515.04 LIQUOR&SPIRITS ORDER 182951 1927780 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 5,999.05 LIQUOR&SPIRITS ORDER 182997 1927784 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 3,840.05 LIQUOR&SPIRITS ORDER 183058 1930511 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 R55CKS2 LOGIS600V CITY OF FARMINGTON 4/29/2020 7:57:44 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 15 4/1/2020 - 4/29/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 229.84 WINE ORDER 183062 1930510 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 2,531.00 JAMESON IRISH WHISKEY ORDER 183063 5055312 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 3.84 DELIVERY CHARGE 184054 1941676 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 3,780.74 LIQUOR&SPIRITS ORDER 184081 1941677 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 21,899.88 151123 4/17/2020 109843 SPOK,INC. 2.63 APR'20 PAGER CONTRACT 183742 D0317419P 6502 6412 CELLULAR SERVICES WATER UTILITY EXPENSE 06500 08 2.63 APR'20 PAGER CONTRACT 183742 D0317419P 6202 6412 CELLULAR SERVICES SEWER OPERATIONS EXPENSE 06200 08 2.63 APR'20 PAGER CONTRACT 183742 D0317419P 6402 6412 CELLULAR SERVICES STORM WATER UTILITY OPERA 06400 08 7.89 151124 4/17/2020 106866 TOTAL TOOL SUPPLY INC 380.00 HOIST INSPEC FOR BOTH FIRE STA 183852 77121222 1060 6505 EQUIPMENT REPAIR/MAINTENANCE FIRE SERVICES 01000 06 380.00 151125 4/17/2020 109709 TRIHUS,DAVID M 27.60 MAR'20 MILEAGE:LIQ DEP,ETC 184084 20200331-TRIHUS 6110 6485 MILEAGE REIMBURSEMENT DOWNTOWN LIQUOR REV&EXP 06100 02 27.60 MAR'20 MILEAGE:LIQ DEP,ETC 184084 20200331-TRIHUS 6115 6485 MILEAGE REIMBURSEMENT PILOT KNOB LIQUOR 06100 02 55.20 151126 4/17/2020 100020 ZARNOTH BRUSH WORKS INC 744.00 GUTTER BROOMS(6) 183746 0179566-IN 6402 6220 EQUIP SUPPLIES&PARTS STORM WATER UTILITY OPERA 06400 08 744.00 151127 4/17/2020 103119 HY-VEE FOOD STORES INC 3,956.90 TOYS FOR TOWN FOOD 181761 TOYS FOR TOWN FOOD00 2255 DEPOSITS PAYABLE GENERAL FUND BALANCE SHEE 01000 3,956.90 151128 4/24/2020 100058 ADVANCE AUTO PARTS 5.05 WHITEBOARD MARKING TAPE 183918 2131-528848 1050 6220 EQUIP SUPPLIES&PARTS POLICE ADMINISTRATION 01000 05 5.05 151129 4/24/2020 103774 AMERICAN PUBLIC WORKS ASSOCIATION 273.44 2020 APWA MEMBERSHIP 184186 699682-2020 DUES 6502 6460 MEMBER DUES&LICENSURE WATER UTILITY EXPENSE 06500 08 273.43 2020 APWA MEMBERSHIP 184186 699682-2020 DUES 6402 6460 MEMBER DUES&LICENSURE STORM WATER UTILITY OPERA 06400 08 273.44 2020 APWA MEMBERSHIP 184186 699682-2020 DUES 6302 6460 MEMBER DUES&LICENSURE SOLID WASTE OPERATIONS 06300 08 273.44 2020 APWA MEMBERSHIP 184186 699682-2020 DUES 6202 6460 MEMBER DUES&LICENSURE SEWER OPERATIONS EXPENSE 06200 08 1,093.75 151130 4/24/2020 113303 ARTISAN BEER COMPANY 408.60 BEER ORDER 184208 3414136 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 408.60 151131 4/24/2020 108446 ASPEN MILLS,INC. 186.80 UNIFORM ITEMS:CASTILLO,S 183946 255082 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 203.30 UNIFORM ITEMS:LEUBNER,R. 183947 255081 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 R55CKS2 LOGIS600V CITY OF FARMINGTON 4/29/2020 7:57:44 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 16 4/1/2020 - 4/29/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept D 88.80 UNIFORM ITEMS:THREET,J 183957 255148 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 119.90 UNIFORM ITEMS:KUYKENDALL,D 183958 255147 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 598.80 151132 4/24/2020 113809 BANKERS TITLE 24.51 REF UTIL CR@181 HICKORY CT 184143 20.8.02805 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 24.51 151133 4/24/2020 100493 BELLBOY CORPORATION 135.00- EVERCLEAR CREDIT 184194 0083623400 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 42.05- WESTERN SON RASPBERRY CREDIT 184195 0082870900 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 369.41 LIQUOR&SPIRITS ORDER 184196 0083633900 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 42.05- WESTERN SON WATERMELON CREDIT 184197 0082680300 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 124.78 LIQUOR SUPPLIES&MIXES ORDER 184199 101179100 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 275.09 151134 4/24/2020 117284 BLACK STACK BREWING,INC 189.00 BEER ORDER 184198 7780 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 189.00 151135 4/24/2020 110290 BOLTON&MENK,INC 350.00 MAR'20 SVS:WTRTWR 3 SITING 184068 0248753 6502 6401 02004 PROFESSIONAL SERVICES WATER UTILITY EXPENSE 06500 08 350.00 151136 4/24/2020 100508 BOYER TRUCKS 537.57 RADIATOR FOR 0710 184126 29025D 6202 6230 VEHICLE SUPPLIES&PARTS SEWER OPERATIONS EXPENSE 06200 08 537.57 151137 4/24/2020 114472 BREAKTHRU BEVERAGE MN BEER,LLC 11,173.41 BEER ORDER 184209 1091132265 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 11,173.41 151138 4/24/2020 114471 BREAKTHRU BEVERAGE MN WINE&SPIRITS 105.75- KORBEL CA CHAMPAGNE CREDIT 184200 2080271329 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 110.86- SKYY VODKA CREDIT 184201 2080269864 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,251.66 LIQUOR&SPIRITS ORDER 184202 1081123419 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 208.35- JACK DANIELS WHISKEY CREDIT 184203 2080271321 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,826.70 151139 4/24/2020 105434 BUREAU OF CRIMINAL APPREHENSION 270.00 1ST QTR 2020 CJDN FEES 184135 00000598546 1050 6411 TELEPHONE/CABLE SERVICES POLICE ADMINISTRATION 01000 05 270.00 151140 4/24/2020 100253 CAMPBELL KNUTSON,P.A. 233.80 MAR'20 LEGAL FEES-GENERAL/RETN 183989 1852-000OG MAR'20 1050 6403 LEGAL POLICE ADMINISTRATION 01000 05 33.40 MAR'20 LEGAL FEES-GENERAL/RETN 183989 1852-000OG MAR'20 1021 6403 LEGAL GENERAL ACCOUNTING 01000 02 83.50 MAR'20 LEGAL FEES-GENERAL/RETN 183989 1852-000OG MAR'20 1094 6403 LEGAL PARK&RECREATION ADMIN 01000 09 R55CKS2 LOGIS600V CITY OF FARMINGTON 4/29/2020 7:57:44 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 17 4/1/2020 - 4/29/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 236.30 MAR'20 LEGAL FEES-GENERAL/RETN 183989 1852-000OG MAR'20 1010 6403 LEGAL ADMINISTRATION 01000 01 183.70 MAR'20 LEGAL FEES-GENERAL/RETN 183989 1852-000OG MAR'20 1030 6403 LEGAL PLANNING&ZONING 01000 03 167.00 MAR'20 LEGAL FEES-GENERAL/RETN 183989 1852-000OG MAR'20 1005 6403 LEGAL LEGISLATIVE CONTROL 01000 01 640.30 MARTO LEGAL FEES-FORFEITURE 183990 1852-0003G MAR'20 1050 6403 LEGAL POLICE ADMINISTRATION 01000 05 8,050.87 MAR'20 LEGAL FEES-PROSECUTION 183991 1852-0999G MAR'20 1050 6403 LEGAL POLICE ADMINISTRATION 01000 05 9,628.87 151141 4/24/2020 110511 CHARTER COMMUNICATIONS HOLDINGS,LLC 16.91 APR'20 CABLE FD STATION#2 184039 0164297040620 7400 6411 TELEPHONE/CABLE SERVICES INFORMATION TECHNOLOGY 07400 04 16.91 151142 4/24/2020 100025 CINTAS CORP LOC 754 53.13 MARTO WEEKLY UNIFORM SERVICES 184122 4046271226 1072 6290 UNIFORMS&CLOTHING STREET MAINTENANCE 01000 08 53.13 MAR'20 WEEKLY UNIFORM SERVICES 184122 4046271226 1090 6290 UNIFORMS&CLOTHING PARK MAINTENANCE 01000 09 4.00- 184122 4046271226 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 53.13 MARTO WEEKLY UNIFORM SERVICES 184122 4046271226 6202 6290 UNIFORMS&CLOTHING SEWER OPERATIONS EXPENSE 06200 08 62.13 MAR'20 WEEKLY UNIFORM SERVICES 184122 4046271226 6302 6290 UNIFORMS&CLOTHING SOLID WASTE OPERATIONS 06300 08 57.13 MARTO WEEKLY UNIFORM SERVICES 184122 4046271226 6402 6290 UNIFORMS&CLOTHING STORM WATER UTILITY OPERA 06400 08 54.71 MARTO WEEKLY UNIFORM SERVICES 184122 4046271226 6502 6290 UNIFORMS&CLOTHING WATER UTILITY EXPENSE 06500 08 329.36 151143 4/24/2020 100071 COLLEGE CITY BEVERAGE INC 6,859.90 BEER ORDER 184188 722-01458 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 20.56- BEER ORDER CREDIT 184193 850-00065 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 6,839.34 151144 4/24/2020 110591 CONSOLIDATED COMMUNICATIONS 2,038.08 APR'20 PHONE LINES 183734 507-150-1389 APRIL 7400 6411 TELEPHONE/CABLE SERVICES INFORMATION TECHNOLOGY 07400 04 '20 2,038.08 151145 4/24/2020 103925 CONSTANTINEAU,JAMES 74.98 REPL LUNCH ROOM MICROWAVE 184220 20200416- 1050 6960 FURNITURE,OFFICE EQUIP,IT POLICE ADMINISTRATION 01000 05 CONSTANTINEAU 74.98 151146 4/24/2020 113962 COVERT TRACK GROUP,INC 600.00 2020 GPS TRACKER ACCESS FEES 183874 37570 1052 6280 BOOKS&SUBSCRIPTIONS INVESTIGATION SERVICES 01000 05 600.00 151147 4/24/2020 100133 DAKOTA COUNTY FINANCIAL SRVS 1,026.52 MARTO RADIO SUBSCRIBER FEES 184133 00038046 1050 6560 CONTRACTUAL SERVICES POLICE ADMINISTRATION 01000 05 1,423.13 MARTO RADIO SUBSCRIBER FEES 184133 00038046 1060 6560 CONTRACTUAL SERVICES FIRE SERVICES 01000 06 2,449.65 151148 4/24/2020 100147 DAKOTA COUNTY TECHNICAL COLLEGE R55CKS2 LOGIS600V CITY OF FARMINGTON 4/29/2020 7:57:44 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 18 4/1/2020 - 4/29/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 250.00 PURSUIT REFRSHER:FOX,J. 184131 655645 1051 6470 TRAINING&SUBSISTANCE PATROL SERVICES 01000 05 250.00 151149 4/24/2020 110291 DCA TITLE 43.02 REF UTIL CR@19453 ELKRIDGE TRL 184162 20-010102-R 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 43.02 151150 4/24/2020 110986 DCA TITLE 21.92 REF UTI CR@5050 UPR 182 ST W 184147 20-020052-RR 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 21.92 151151 4/24/2020 108967 DICK'S VALLEY SERVICE INC 196.03 20000407 TOW FEE 183760 224142 1052 6401 PROFESSIONAL SERVICES INVESTIGATION SERVICES 01000 05 196.03 151152 4/24/2020 113296 EDINA REALTY TITLE 313.71 EF UTIL CR@704 12TH ST 184145 1344919/46 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 37.54 REF UTIL CR@4259 207TH ST W 184146 1341387/136 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 351.25 151153 4/24/2020 100270 EMERGENCY MEDICAL PRODUCTS INC 131.90 NITRILE GLOVES(1 CASE) 183753 2147248 1051 6242 00019 CLEANING SUPPLIES PATROL SERVICES 01000 05 1,043.52 N95 MASK(8 CASES) 183858 2147190 1060 6220 00019 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 1,175.42 151154 4/24/2020 100419 EMPIRE TOWNSHIP 472.05 1ST QTR 2020 SEWER USAGE FEE 184013 01-00000057 6202 6560 CONTRACTUAL SERVICES SEWER OPERATIONS EXPENSE 06200 08 JAN-MAR'20 472.05 151155 4/24/2020 100211 EUREKA TOWNSHIP 216.00 MAR'20 ROAD MAINTENANCE 184151 MARCH'20 RD MAINT5741 6535 OTHER REPAIR/MAINTENANCE TOWNSHIP ROAD MAINTENANCE 05700 452.00 FEB'20 ROAD MAINTENANCE 184185 FEB'20 RD MAINT 5741 6535 OTHER REPAIR/MAINTENANCE TOWNSHIP ROAD MAINTENANCE 05700 668.00 151156 4/24/2020 100022 FARMINGTON PRINTING INC 190.00 ENVELOPES 184221 13532 1050 6450 OUTSIDE PRINTING POLICE ADMINISTRATION 01000 05 190.00 151157 4/24/2020 111631 FULL SERVICE BATTERY,INC 185.76 BATTERIES FOR SCBA PACKS 184158 0020510 1060 6220 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 185.76 151158 4/24/2020 100024 GOPHER STATE ONE-CALL 59.40 MARCH 2020 LOCATES 183747 0030386 6502 6401 PROFESSIONAL SERVICES WATER UTILITY EXPENSE 06500 08 59.40 MARCH 2020 LOCATES 183747 0030386 6202 6401 PROFESSIONAL SERVICES SEWER OPERATIONS EXPENSE 06200 08 59.40 MARCH 2020 LOCATES 183747 0030386 6402 6401 PROFESSIONAL SERVICES STORM WATER UTILITY OPERA 06400 08 178.20 R55CKS2 LOGIS600V CITY OF FARMINGTON 4/29/2020 7:57:44 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 19 4/1/2020 - 4/29/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 151159 4/24/2020 116589 GREATAMERICA FINANCIAL SERVICES 217.85 APR'20 POSTAGE METER RENTAL 184004 26834610 1010 6555 RENTAL OF EQUIPMENT ADMINISTRATION 01000 01 217.85 151160 4/24/2020 100074 HOHENSTEINS INC 422.50 BEER ORDER 184189 199769 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 422.50 151161 4/24/2020 109846 JJ TAYLOR DISTRIBUTING COMPANY OF MN INC 1,081.10 BEER ORDER 184187 3047493 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,576.05 BEER ORDER 184219 3084509 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,657.15 151162 4/24/2020 100033 JOHNSON BROTHERS LIQUOR COMPANY 374.95 WINE ORDER 184211 1540913 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 41.51 MSTR MIXES OLD FASHION ORDER 184212 1540914 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,832.62 LIQUOR&SPIRITS ORDER 184213 1540912 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 732.45 LIQUOR&SPIRITS ORDER 184214 1540916 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 335.53 WINE ORDER 184215 1540915 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 472.19 WINE ORDER 184216 1540917 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 37.16- WINE ORDER CREDIT 184217 595088 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 233.02- SMIRNOFF VODKA CREDIT 184218 597993 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 4,519.07 151163 4/24/2020 117075 JOHNSON CONTROLS 967.40 CITY HALL HVAC CONTROL PARTS 184167 1-95171968115 1015 6240 BUILDING SUPPLIES&PARTS CITY HALL 01000 01 967.40 151164 4/24/2020 100049 LOCAL GOVERNMENT INFORMATION SYSTEMS 2,442.00 APR'20 APPL SUPPORT INVOICE 183750 48566 1011 6402 DATA PROCESSING HUMAN RESOURCES 01000 04 4,638.00 APR'20 APPL SUPPORT INVOICE 183750 48566 1021 6402 DATA PROCESSING GENERAL ACCOUNTING 01000 02 2,941.00 APR'20 APPL SUPPORT INVOICE 183750 48566 1031 6402 DATA PROCESSING BUILDING INSPECTIONS 01000 07 2,297.00 APR'20 APPL SUPPORT INVOICE 183750 48566 1050 6402 DATA PROCESSING POLICE ADMINISTRATION 01000 05 371.00 APR'20 APPL SUPPORT INVOICE 183750 48566 1060 6402 DATA PROCESSING FIRE SERVICES 01000 06 1,135.00 APR'20 APPL SUPPORT INVOICE 183750 48566 6202 6402 DATA PROCESSING SEWER OPERATIONS EXPENSE 06200 08 968.00 APR'20 APPL SUPPORT INVOICE 183750 48566 6302 6402 DATA PROCESSING SOLID WASTE OPERATIONS 06300 08 968.00 APR'20 APPL SUPPORT INVOICE 183750 48566 6402 6402 DATA PROCESSING STORM WATER UTILITY OPERA 06400 08 968.00 APR'20 APPL SUPPORT INVOICE 183750 48566 6502 6402 DATA PROCESSING WATER UTILITY EXPENSE 06500 08 3,448.00 APR'20 APPL SUPPORT INVOICE 183750 48566 7400 6402 DATA PROCESSING INFORMATION TECHNOLOGY 07400 04 406.25 MAR'20 NETWORK SERVICES 183962 48533 7400 6505 EQUIPMENT REPAIR/MAINTENANCE INFORMATION TECHNOLOGY 07400 04 1,092.00 SHI MICRO OFFICE STD(14) 183998 48631 7400 6505 EQUIPMENT REPAIR/MAINTENANCE INFORMATION TECHNOLOGY 07400 04 1,187.57 INSIGHT VMWARE LICENSES(6) 183998 48631 7400 6505 EQUIPMENT REPAIR/MAINTENANCE INFORMATION TECHNOLOGY 07400 04 743.46 SHI MICRO WINSRV LIC(2) 183998 48631 7400 6505 EQUIPMENT REPAIR/MAINTENANCE INFORMATION TECHNOLOGY 07400 04 2,421.44 SHI MICRO OFFICE STD(16) 183998 48631 7400 6505 EQUIPMENT REPAIR/MAINTENANCE INFORMATION TECHNOLOGY 07400 04 R55CKS2 LOGIS600V CITY OF FARMINGTON 4/29/2020 7:57:44 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 20 4/1/2020 - 4/29/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 13,405.46 SHI MICROSOFT EXCH/OFFICE LIC 183998 48631 7400 6505 EQUIPMENT REPAIR/MAINTENANCE INFORMATION TECHNOLOGY 07400 04 2,398.41 SHI MICROSOFT EXCH MAINT(47) 183998 48631 7400 6505 EQUIPMENT REPAIR/MAINTENANCE INFORMATION TECHNOLOGY 07400 04 326.34 FEB'20 MN IT WAN SERVICE 183998 48631 7400 6402 DATA PROCESSING INFORMATION TECHNOLOGY 07400 04 15.00 VPN TOKEN BARR,S. 183998 48631 1050 6402 00019 DATA PROCESSING POLICE ADMINISTRATION 01000 05 15.00 VPN TOKEN WOOTEN,G. 183998 48631 1050 6402 00019 DATA PROCESSING POLICE ADMINISTRATION 01000 05 15.00 VPN TOKEN MAI LHOT,A. 183998 48631 1050 6402 00019 DATA PROCESSING POLICE ADMINISTRATION 01000 05 15.00 VPN TOKEN DECUR,M. 183998 48631 1070 6402 00019 DATA PROCESSING ENGINEERING SERVICES 01000 07 15.00 VPN TOKEN SNYDER,S. 183998 48631 1070 6402 00019 DATA PROCESSING ENGINEERING SERVICES 01000 07 15.00 VPN TOKEN SCHIMMEL,R. 183998 48631 1070 6402 00019 DATA PROCESSING ENGINEERING SERVICES 01000 07 15.00 VPN TOKEN GEISE,T. 183998 48631 1021 6402 00019 DATA PROCESSING GENERAL ACCOUNTING 01000 02 15.00 VPN TOKEN SIEBENALER,L. 183998 48631 1014 6402 00019 DATA PROCESSING COMMUNICATIONS 01000 01 15.00 VPN TOKEN BEARD,S. 183998 48631 1021 6402 00019 DATA PROCESSING GENERAL ACCOUNTING 01000 02 15.00 VPN TOKEN MCMILLEN,C. 183998 48631 1021 6402 00019 DATA PROCESSING GENERAL ACCOUNTING 01000 02 15.00 VPN TOKEN HAYES,R. 183998 48631 1094 6402 00019 DATA PROCESSING PARK&RECREATION ADMIN 01000 09 15.00 VPN TOKEN LARSON,L. 183998 48631 6302 6402 00019 DATA PROCESSING SOLID WASTE OPERATIONS 06300 08 15.00 VPN TOKEN DISTAD,R. 183998 48631 1094 6402 00019 DATA PROCESSING PARK&RECREATION ADMIN 01000 09 15.00 VPN TOKEN MULLER,C. 183998 48631 1030 6402 00019 DATA PROCESSING PLANNING&ZONING 01000 03 42,366.93 151165 4/24/2020 112658 LOCATION TECHNOLOGIES,INC 43.25 APR 2020 GPS SERVICES 183883 15852 6302 6412 CELLULAR SERVICES SOLID WASTE OPERATIONS 06300 08 43.25 151166 4/24/2020 102796 MARTIN-MCALLISTER 550.00 HAGFORS EMPLOYMENT PSYCH 183733 12947 1050 6405 EMPLOYMENT TESTING POLICE ADMINISTRATION 01000 05 550.00 151167 4/24/2020 100095 METROPOLITAN COUNCIL ENVIRONMENTAL SVS 127,380.78 MAY 2020 WASTE WATER MCES FEES 184014 0001108364 MAY'20 6202 6565 MCES FEES SEWER OPERATIONS EXPENSE 06200 08 127,380.78 151168 4/24/2020 108780 MINNESOTA AG GROUP INC 12,000.00 #0945 EXMARK MOWER#606WO 183754 IN81051 5602 6930 HEAVY EQUIPMENT GEN CAPITAL EQUIP FUND EX 05600 12,000.00 151169 4/24/2020 102725 MINNESOTA DEPT OF HEALTH 23.00 WTR LIC RENEWAL:BERRA,N 184124 WATER LIC RENEW-6502 6460 MEMBER DUES&LICENSURE WATER UTILITY EXPENSE 06500 08 BERRA 23.00 151170 4/24/2020 100322 MN NCPERS LIFE INSURANCE 16.00 184141 0423201125533 7000 2119 PERA LIFE INS PAYABLE EMPLOYEE EXPENSE FUND 07000 02 16.00 151171 4/24/2020 113129 NETWORK TITLE INC 196.38 REF UTIL CR@20691 E OAKS DR 184164 20-0582 TRIM 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 R55CKS2 LOGIS600V CITY OF FARMINGTON 4/29/2020 7:57:44 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 21 4/1/2020 - 4/29/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept D 196.38 151172 4/24/2020 102644 NORTHERN SAFETY TECHNOLOGY,INC 62.90 SQD 02 CUP HOLDER 183752 50157 5602 6940 50 VEHICLES-POLICE GEN CAPITAL EQUIP FUND EX 05600 62.90 151173 4/24/2020 113031 NRG RELIABILITY SOLUTIONS LLC 1,517.23 MAR'20 ELEC LAW ENFORCE CNTR 184134 3346-2004 1050 6422 ELECTRIC POLICE ADMINISTRATION 01000 05 418.17 MAR'20 ELEC CMF 184182 3347-2004 1072 6422 ELECTRIC STREET MAINTENANCE 01000 08 418.17 MAR'20 ELEC CMF 184182 3347-2004 1090 6422 ELECTRIC PARK MAINTENANCE 01000 09 28.75- 184182 3347-2004 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 418.17 MAR'20 ELEC CMF 184182 3347-2004 6202 6422 ELECTRIC SEWER OPERATIONS EXPENSE 06200 08 446.92 MAR'20 ELEC CMF 184182 3347-2004 6302 6422 ELECTRIC SOLID WASTE OPERATIONS 06300 08 418.17 MAR'20 ELEC CMF 184182 3347-2004 6402 6422 ELECTRIC STORM WATER UTILITY OPERA 06400 08 413.18 MAR'20 ELEC CMF 184182 3347-2004 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 4,021.26 151174 4/24/2020 101254 ORKIN EXTERMINATING,LLC 107.10 MAR'20 PEST CONTROL CITY HALL 184178 194854606 1015 6515 BUILDING REPAIR/MAINTENANCE CITY HALL 01000 01 20.67 MAR'20 PEST CONTROL CMF 184179 194854199 1072 6515 BUILDING REPAIR/MAINTENANCE STREET MAINTENANCE 01000 08 20.67 MAR'20 PEST CONTROL CMF 184179 194854199 1090 6515 BUILDING REPAIR/MAINTENANCE PARK MAINTENANCE 01000 09 1.42- 184179 194854199 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 20.67 MAR'20 PEST CONTROL CMF 184179 194854199 6202 6515 BUILDING REPAIR/MAINTENANCE SEWER OPERATIONS EXPENSE 06200 08 22.09 MAR'20 PEST CONTROL CMF 184179 194854199 6302 6515 BUILDING REPAIR/MAINTENANCE SOLID WASTE OPERATIONS 06300 08 20.67 MAR'20 PEST CONTROL CMF 184179 194854199 6402 6515 BUILDING REPAIR/MAINTENANCE STORM WATER UTILITY OPERA 06400 08 20.43 MAR'20 PEST CONTROL CMF 184179 194854199 6502 6515 BUILDING REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 106.06 MAR'20 PEST CNTRL-5446 195TH 184184 194853742 6502 6515 BUILDING REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 336.94 151175 4/24/2020 100290 PAUSTIS&SONS WINE COMPANY 98.25 WINE ORDER 184190 86815 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 210.50 WINE ORDER 184192 86310 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 308.75 151176 4/24/2020 100032 PEPSI COLA COMPANY 150.05 POP ORDER 184191 19223811 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 150.05 151177 4/24/2020 117635 PETERSEN,KORI&THOMAS 173.37 REF UTIL CR@5991 193RD ST W 184181 DUPLICATE PYMT 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 173.37 151178 4/24/2020 100034 PHILLIPS WINE AND SPIRITS,INC 149.64 ZING ZANG BL MARY MIX ORDER 184204 6023833 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 744.20 LIQUOR&SPIRITS ORDER 184205 6023831 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 470.09 WINE ORDER 184207 6023832 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 R55CKS2 LOGIS600V CITY OF FARMINGTON 4/29/2020 7:57:44 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 22 4/1/2020 - 4/29/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept D 59.16- DAILY'S&UV VODKA CREDIT 184210 602169 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,304.77 151179 4/24/2020 115677 PILLAR TITLE SERVICES 74.87 REF UTIL CR@5228 185TH ST W 184148 100362.20 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 74.87 151180 4/24/2020 107446 PIZZA MAN 140.72 FOOD FOR BRUSH FIRE 184130 20200408-FIRE 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01000 06 140.72 151181 4/24/2020 117548 PROSPERITY FIRST TITLE 136.37 REF UTI CR@3414 209TH ST W 184165 PFT-3041/70 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 136.37 151182 4/24/2020 114224 RADCO-BURNSVILLE 39.95 LIGHT FOR CHIEF VEHICLE 184128 BR-1043789 1060 6230 VEHICLE SUPPLIES&PARTS FIRE SERVICES 01000 06 39.95 151183 4/24/2020 108826 RED WING,CITY OF 64,122.30 MAR'20 TIPPING FEES 184051 0045204 6302 6401 PROFESSIONAL SERVICES SOLID WASTE OPERATIONS 06300 08 64,122.30 151184 4/24/2020 115041 SAND,HEATHER LEE 284.00 FEB'20 ZUMBA&YOGA CLASS 184107 20200228 1095 6560 CONTRACTUAL SERVICES RECREATION PROGRAM SERVIC 01000 09 144.00 MAR'20 ZUMBA&YOGA CLASS 184108 20200316 1095 6560 CONTRACTUAL SERVICES RECREATION PROGRAM SERVIC 01000 09 428.00 151185 4/24/2020 112051 SOUTHERN GLAZER'S OF MN 3,183.20 LIQUOR&SPIRITS ORDER 184206 1943651 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 3,183.20 151186 4/24/2020 117636 THAKURDIAL,LEELAWATTEE 300.00 RENTAL DURING COVID-19 CLOSURE 184138 050220 1001 4972 RENTAL INCOME-RRC GENERAL FUND REVENUES 01000 01 300.00 151187 4/24/2020 117634 TITLESMART INC. 17.18 REF UTIL CR@423 WHSPRING RV LN 184166 216444/91 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 17.18 151188 4/24/2020 114013 TRADEMARK TITLE SERVICES,INC 47.32 REF UTIL CR@20374 EAVES WAY 184163 20-0849/69 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 47.32 151189 4/24/2020 116242 TRANSUNION RISK&ALTERNATIVE 100.00 MAR'20 TLO SUBSCRIPTION 183732 4711941 MAR'20 1052 6401 PROFESSIONAL SERVICES INVESTIGATION SERVICES 01000 05 100.00 151190 4/24/2020 110954 ULINE SHIPPING&SUPPLY SPECIALISTS,INC R55CKS2 LOGIS600V CITY OF FARMINGTON 4/29/2020 7:57:44 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 23 4/1/2020 - 4/29/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 87.03 ANTIBACTERIAL HAND SOAP 183916 118525370 1050 6242 00019 CLEANING SUPPLIES POLICE ADMINISTRATION 01000 05 87.03 151191 4/24/2020 117457 WATERMARK TITLE AGENCY 107.86 REF UTI CR@412 SPRUCE ST 184144 65738 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 107.86 151192 4/24/2020 113123 WATERMARK TITLE AGENCY,LLC 66.94 REF UTIL CR@5937 189 ST W 184161 65765 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 66.94 151193 4/24/2020 100389 WOLD ARCHITECTS&ENGINEERS INC 1,272.96 DESIGN FEES RESURFACER PROJECT 183748 65784 4503 6401 00114 PROFESSIONAL SERVICES ICE ARENA CAPITAL IMPR FU 04500 09 1,272.96 151194 4/27/2020 117075 JOHNSON CONTROLS 3,119.00 HVAC SYSTEM REPAIR 184227 1-95210778163 1015 6515 BUILDING REPAIR/MAINTENANCE CITY HALL 01000 01 3,119.00 20200320 3/30/2020 116053 109 ELM,LLC 12,394.58 APR'20 DT LIQUOR STORE RENT 184002 APRIL 2020 6110 6556 BUILDING RENTAL DOWNTOWN LIQUOR REV&EXP 06100 02 12,394.58 20200401 4/6/2020 108980 MINNESOTA ENERGY RESOURCES CORPORATION 96.95 MAR'20 GAS 208TH ST WARM HOUSE 183569 0506537581 MAR'20 1090 6423 NATURAL GAS PARK MAINTENANCE 01000 09 96.95 20200402 4/9/2020 115445 HEALTH PARTNERS 83,947.00 APR'20 HEALTH INSURANCE 183999 95980277 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 83,947.00 20200403 4/10/2020 100135 PUBLIC EMPLOYEES RETIREMENT ASSN. 23,026.36 183868 0409201136551 7000 2113 PERA PAYABLE EMPLOYEE EXPENSE FUND 07000 02 30,539.87 183869 0409201136552 7000 6154 PERA EMPLOYEE EXPENSE FUND 07000 02 53,566.23 20200404 4/1/2020 100135 PUBLIC EMPLOYEES RETIREMENT ASSN. 24,635.70 183552 032620949411 7000 2113 PERA PAYABLE EMPLOYEE EXPENSE FUND 07000 02 32,817.90 183553 032620949412 7000 6154 PERA EMPLOYEE EXPENSE FUND 07000 02 57,453.60 20200405 4/6/2020 100085 DAKOTA ELECTRIC ASSOCIATION 34.74 FEB'20 ELEC TUNNEL LIGHT 183105 200005468327 1090 6422 ELECTRIC PARK MAINTENANCE 01000 09 FEB'20 1,511.05 FEB'20 ELEC WELL#5 183205 200002785533 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 FEB'20 118.97 FEB'20 ELEC VERM GROVE LS 183206 200003215779 6202 6422 ELECTRIC SEWER OPERATIONS EXPENSE 06200 08 FEB'20 R55CKS2 LOGIS600V CITY OF FARMINGTON 4/29/2020 7:57:44 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 24 4/1/2020 - 4/29/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 3,167.01 FEB-20 ELEC WELL#8 183207 200004199709 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 FEB'20 6,284.85 FEB'20 ELEC 9TH ST STREET LTS 183208 200001038421 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 FEB'20 30.78 FEB'20 ELEC DAISY KNOLL TOWER 183209 200001318518 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 FEB'20 931.95 FEB'20 ELEC WELL#4 183210 200001318526 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 FEB'20 3,470.50 FEB'20 ELEC WELL#6 183211 200001550151 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 FEB'20 1,235.55 FEB'20 ELEC PK LIQ STORE 183236 200003759891 6115 6422 ELECTRIC PILOT KNOB LIQUOR 06100 02 FEB'20 232.24 FEB'20 ELEC 195TH WATER TOWER 183239 200002587095 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 FEB'20 1,266.75 FEB-20 ELEC WELL#7 183240 200003490737 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 FEB'20 551.47 FEB'20 ELEC FIRE STATN#2 183281 200003971959 1060 6422 ELECTRIC FIRE SERVICES 01000 06 FEB'20 5.15 FEB'20 ELEC CIV DEF SIREN 183301 200001982271 1054 6422 ELECTRIC EMERGENCY MGMT SERVICES 01000 05 FEB'20 5.15 FEB'20 ELEC CIV DEF SIREN 183302 200002260958 1054 6422 ELECTRIC EMERGENCY MGMT SERVICES 01000 05 FEB'20 18,846.16 20200406 4/14/2020 108980 MINNESOTA ENERGY RESOURCES CORPORATION 65.69 MAR'20 GAS WELL#5 183881 0507120636 MAR'20 6502 6423 NATURAL GAS WATER UTILITY EXPENSE 06500 08 14.40 MAR'20 GAS VERM GROVE LIFT STN 183882 0503080372 MAR'20 6202 6423 NATURAL GAS SEWER OPERATIONS EXPENSE 06200 08 80.09 20200407 4/17/2020 108980 MINNESOTA ENERGY RESOURCES CORPORATION 408.16 MAR'20 GAS FIRE STATION 2 183865 0505001779 MAR'20 1060 6423 NATURAL GAS FIRE SERVICES 01000 06 545.44 MAR'20 GAS POLICE DEPT 183871 0505974444 MAR'20 1050 6423 NATURAL GAS POLICE ADMINISTRATION 01000 05 234.20 MAR'20 GAS DT LIQ STORE 183876 0503154879 MAR'20 6110 6423 NATURAL GAS DOWNTOWN LIQUOR REV R EXP 06100 02 915.76 MAR'20 GAS RRC 183878 0507948331 MAR'20 1093 6423 NATURAL GAS SENIOR CITIZEN SERVICES 01000 09 49.99 MARTO GAS WELL HOUSE 1 OAK ST 183880 0506788875 MAR'20 6502 6423 NATURAL GAS WATER UTILITY EXPENSE 06500 08 1,469.28 MAR-20 GAS ARENA 183910 0502346011 MAR'20 2502 6423 NATURAL GAS ICE ARENA OPERATIONS EXPE 02500 09 51.67 MAR'20 GAS 1ST STREET GARAGE 183911 0505547424 MAR'20 1072 6423 NATURAL GAS STREET MAINTENANCE 01000 08 51.67 MAR'20 GAS 1ST STREET GARAGE 183911 0505547424 MAR'20 1090 6423 NATURAL GAS PARK MAINTENANCE 01000 09 3.55- 183911 0505547424 MAR'20 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 51.67 MAR'20 GAS 1 ST STREET GARAGE 183911 0505547424 MAR'20 6202 6423 NATURAL GAS SEWER OPERATIONS EXPENSE 06200 08 55.22 MAR'20 GAS 1ST STREET GARAGE 183911 0505547424 MAR'20 6302 6423 NATURAL GAS SOLID WASTE OPERATIONS 06300 08 51.67 MAR'20 GAS IST STREET GARAGE 183911 0505547424 MAR'20 6402 6423 NATURAL GAS STORM WATER UTILITY OPERA 06400 08 51.05 MAR'20 GAS 1ST STREET GARAGE 183911 0505547424 MAR'20 6502 6423 NATURAL GAS WATER UTILITY EXPENSE 06500 08 R55CKS2 LOGIS600V CITY OF FARMINGTON 4/29/2020 7:57:44 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 25 4/1/2020 - 4/29/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 1,379.70 MAR'20 GAS CITY HALL 183912 0505346885 MAR'20 1015 6423 NATURAL GAS CITY HALL 01000 01 489.06 MAR'20 GAS CMF 183919 0502362190 MAR'20 1072 6423 NATURAL GAS STREET MAINTENANCE 01000 08 489.05 MAR'20 GAS CMF 183919 0502362190 MAR'20 1090 6423 NATURAL GAS PARK MAINTENANCE 01000 09 33.62- 183919 0502362190 MAR'20 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 489.05 MAR'20 GAS CMF 183919 0502362190 MAR'20 6202 6423 NATURAL GAS SEWER OPERATIONS EXPENSE 06200 08 522.67 MAR'20 GAS CMF 183919 0502362190 MAR'20 6302 6423 NATURAL GAS SOLID WASTE OPERATIONS 06300 08 489.05 MAR'20 GAS CMF 183919 0502362190 MAR'20 6402 6423 NATURAL GAS STORM WATER UTILITY OPERA 06400 08 483.20 MAR'20 GAS CMF 183919 0502362190 MAR'20 6502 6423 NATURAL GAS WATER UTILITY EXPENSE 06500 08 8,240.39 20200408 4/15/2020 115734 MINNESOTA OCCUPATIONAL HEALTH 374.00 MAR'20 EMPLOYMENT TESTING 184044 339973 1011 6405 EMPLOYMENT TESTING HUMAN RESOURCES 01000 04 374.00 20200409 4/15/2020 108490 MINNESOTA UI FUND 524.19 1ST QTR 2020 UI PAYMENT 184096 13333645-1ST QTR 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 '20 524.19 20200410 4/16/2020 100394 XCEL ENERGY 4,119.44 MAR'20 ELEC-ICE ARENA 184036 51-4874007-2 MAR 2502 6422 ELECTRIC ICE ARENA OPERATIONS EXPE 02500 09 '20 668.17 MAR'20 ELEC-SENIOR CENTER 184036 51-4874007-2 MAR 1093 6422 ELECTRIC SENIOR CITIZEN SERVICES 01000 09 '20 2,660.63 MAR'20 ELEC-CTY HALL/FRT BLDG 184036 51-4874007-2 MAR 1015 6422 ELECTRIC CITY HALL 01000 01 '20 282.33 MAR'20 ELEC-PARK/WARM HOUSE 184036 51-4874007-2 MAR 1090 6422 ELECTRIC PARK MAINTENANCE 01000 09 '20 7,730.57 Report Totals 1,045,840.35 CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-280-6800 ® IIr1 ® Farmington M N.gov TO: Mayor, Councilmembers and City Administrator FROM: David McKnight, City Administrator SUBJECT: Fiber Optic Indefeasible Right to Use Agreement by and Between the City of Farmington and the the Dakota Broadband Board DATE: May 4, 2020 INTRODUCTION I ncluded for your review and consideration is the Fiber Optic I ndefeasible Right to Use Agreement between the City of Farmington and the Dakota Broadband Board. This agreement has been approved by the DBB at their February 12, 2020 meeting. DISCUSSION The I ndefeasable Right to Use Agreement grants the Dakota Broadband Board (D BB) the right to use, manage and maintain fibers and fiber facilities within certain fiber optic cable segments on the terms established in this agreement. The City of Farmington has built a fiber network that is shown on the map attached to the agreement and referred to as exhibit A. The map shows both the Farmington network and the Dakota County network. The execution of this agreement was defined in the joint powers agreement signed by all D BB members in 2017. This document is a technical document that allows the operations and maintenance contractor (LOG IS)to ensure member assets are property maintained and the DBB network is fully supported. The template does not determine policy direction when it comes to the use of the DBB network, policy is determined by the DBB Board. If the city council wishes not to include some or all of our network in the agreement,the responsibility and cost to maintain and operate the member's assets will be city responsibility. When the city agreed to join the DBB, it was always our assumption that we would be in 100% and do our part to help the DBB thrive and maintain the city's fiber infrastructure that will continue to grow. BUDGET IMPACT The costs associated with this agreement have been incorporated into the 2020 budget and will continue to be budgeted for in the future. ACTION REQUESTED Ask any questions that you may have on the draft agreement. Once the city council is comfortable, a motion should be made to approve the Fiber Optic I ndefeasible Right to Use Agreement By and Between the City of Farmington and the Dakota Broadband Board. ATTACHMENTS: Type Description D Backup Material Draft Agreement Map DBB Contract# FIBER OPTIC INDEFEASIBLE RIGHT TO USE AGREEMENT BY AND BETWEEN CITY OF FARMINGTON AS GRANTOR AND DAKOTA BROADBAND BOARD AS GRANTEE FIBER OPTIC INDEFEASIBLE RIGHT TO USE AGREEMENT This Agreement for the indefeasible right to use (or "IRU") together with the attached exhibit(collectively the"Agreement"or the "IRU Agreement") is made by and between the City of Farmington, a Minnesota municipal corporation ("IRU Grantor" or "the City"), and Dakota Broadband Board, a Minnesota independent joint powers organization, acting by and through its Board of Directors ("IRU Grantee", or "the DBB"). The IRU Grantor and IRU Grantee may be referred to herein individually as a"Party" or collectively as the"Parties." BACKGROUND A. The City has installed and maintained, or plans to install and maintain, certain Fibers and Fiber Facilities, and B. The City is a participant in and a member of the Dakota Broadband Board and to further the purpose and goals of the DBB,the City agrees to grant to the DBB the right to use, manage and maintain Fibers and Fiber Facilities within certain Fiber Optic Cable segments on the terms and conditions set forth below. C. The DBB desires to use, manage and maintain optic Fibers and Fiber Facilities from the City as described in this Agreement. DEFINITIONS The following terms are used in this IRU Agreement: A. "County Right-of-Way" means the real property, including all fee simple, easements, access rights, rights of use and other interests, owned and/or operated by Dakota County, devoted to County road or highway purposes. B. "City Right-of-Way" means the real property, including all fee simple, easements, access rights, rights of use and other interests owned and/or operated by the City, devoted to City road or highway purposes. C. "Dakota Broadband Network"means a high-performance network connecting local government facilities in Dakota County with the physical assets (conduit, fiber optic cable, handholes, cabinets, network equipment) owned by DBB members but maintained and managed by the DBB. D. "Effective Date" is the date upon which all Parties have executed this Agreement. E. "Fiber"means a glass strand or strands which is/are used to transmit a communication signal along the glass strand in the form of pulses of light. F. "Fiber Facilities"means a handhole, conduit, splice enclosures and related equipment, but excluding any electronic or optronic equipment at termination points located in City facilities. 1 G. "Fiber Optic Cable" or "Cable" means a collection of fibers with a protective outer covering. H. "IRU Assets" means the City's IRU conduit, IRU Cable, IRU Fibers and Fiber Facilities that is subject to this Agreement as more specifically described in Exhibit A. I. "IRU Cable" means a Cable containing one or more Fibers, constructed and owned by the City in which the DBB has an IRU pursuant to the terms of this Agreement. J. "IRU Fibers" means the specific City owned Fiber described in Exhibit A, an IRU for which is granted to the DBB in the IRU Cable pursuant to the terms of this Agreement. K. "Indefeasible Right of Use"or"IRU"means an indefeasible right to use,maintain and manage the IRU Fibers and Fiber Facilities, provided, however, that granting of such IRU does not convey legal title to the IRU Fibers or Fiber Facilities. L. "Optical Splice Point" means a point where the City's Cable is connected to another entity's Cable within a splice enclosure. M. "Relocation" means any physical movement of fiber optic cable or conduit required due to reconstruction, modification, change in grade, expansion or relocation of a County road or highway, or a city street or other public improvement. In consideration of their mutual promises,the Parties expressly agree as follows: ARTICLE I LICENSES Section 1.1 The DBB desires to obtain an IRU in the City's IRU Assets further described in Exhibit A to this Agreement,which is incorporated into this IRU by reference. In consideration of the promises by the DBB in this Agreement, the City grants an IRU to the DBB in the IRU Assets identified in Exhibit A hereto, subject to any interests the City has previously granted to other cities or Dakota County,pursuant to IRUs or other contractual arrangements. The DBB shall be entitled to use the IRU Assets for any lawful purposes subject to (i) agreeing to be bound by all laws, regulations and any requirements of the City regarding access to City rights of way, and(ii) otherwise complying with the terms and conditions of this IRU. Section 1.2 Subject to the terms and conditions of this IRU Agreement, City hereby grants to the DBB a license to access and use the IRU Assets during the term of this Agreement and any extension of this Agreement. The Parties acknowledge and agree that they may add additional IRU Assets owned by the City to become subject to this Agreement, and will agree upon an amended Exhibit A that reflects the changes to the City IRU Assets to be subject to DBB use and management, which shall supersede all previous versions of Exhibit A. Such amended Exhibit A 2 need not be formally approved by the DBB Board or the City Council of the City in order for the amendment to become effective. Section 1.3 The IRU Assets are provided to the DBB "as is." If any new Fiber Facilities or any fiber splices are needed to interconnect IRU Fibers to the Dakota Broadband Network,the DBB shall be responsible for coordinating this work with the City and shall pay any and all costs and fees associated with connecting the IRU Fibers to other fibers not owned by the City for Dakota Broadband Network purposes. The DBB and the city or cities that own the Dakota Broadband Network assets shall confer and agree upon which Party is responsible for the costs and fees associated with connecting the IRU Fibers to other fibers for Dakota Broadband Network purposes of parties outside of the DBB or shall agree upon an allocation of the costs and fees between the Parties. If the Parties cannot agree upon the responsibility for costs and fees related to Dakota Broadband Network connections,the issue shall be presented to the DBB Board and the DBB Board decision on cost responsibility shall be final. Section 1.4 Notwithstanding anything contained to the contrary in this Agreement, the Parties acknowledge and agree nothing contained in this Agreement shall operate to limit,interfere with, or otherwise adversely affect each Party's right to manage, control, construct, relocate, maintain, replace and expand the portion of its fiber optic network equipment and infrastructure that is not subject to this Agreement, and is not included in the description of Fiber and Fiber Facilities in Exhibit A. ARTICLE II EFFECTIVE DATE AND TERM The DBB may use the granted IRU Assets commencing on the Effective Date. This Agreement has an initial term of 10 years, with two separate five-year renewals which shall be effective unless the DBB Board affirmatively decides not to renew and provides ninety(90) days' notice to the City prior to termination or unless terminated by agreement of the Parties in writing or by one of the events in Article XI, Section 11.2 of this Agreement,whichever occurs first. ARTICLE III LICENSE FEES The City will not impose, and the DBB shall not pay a fee for the use of the IRU Assets during the term of this Agreement on any renewal of this Agreement. The City will contribute to the cost of using, managing and maintaining the City's Fiber Assets through its DBB participant fees and other financial contributions as approved by the DBB Board. 3 ARTICLE IV MAINTENANCE AND REPAIR The DBB shall be responsible for the maintaining,repairing and when necessary replacing the City's IRU Assets assigned to the DBB as described in Exhibit A within the Dakota Broadband Network managed by the DBB. Responsibility for the cost of maintenance and repair of new City Fiber Facilities used within the Dakota Broadband Network will be as follows: If the City has amended Exhibit A of its IRU Agreement with the DBB to include the new Dakota Broadband Network/city fiber among the IRU Assets to be managed and maintained by the DBB,the cost of maintenance and repair of the new Dakota Broadband Network fiber is the responsibility of the DBB. If the City has not amended Exhibit A of its IRU Agreement with the DBB to include the new city fiber among the IRU Assets to be managed and maintained by the DBB,the cost of maintenance and repair of the new Dakota Broadband Network/City fiber is the responsibility of the city until the new Dakota Broadband Network fiber is added to Exhibit A. The response time to repair breaks or other failures causing an interruption in communications through City IRU Assets will be the response time standards set forth in the break/fix contract between the DBB,or its network administrator, and the selected break/fix repair contractor. ARTICLE V REPRESENTATIONS AND WARRANTIES Section 5.1 The DBB's use of the IRU Assets shall comply with all applicable governmental codes, ordinances, laws, rules, regulations and/or restrictions. Section 5.2 The City represents and warrants that it has the right to grant this IRU in its IRU Assets. ARTICLE VI LIABILITY; INDEMNIFICATION Section 6.1 Neither the City nor the DBB shall be liable to the other for any indirect, special, punitive or consequential damages arising under this Agreement or from any breach or partial breach of the provisions of this Agreement or arising out of any act or omission of either Party hereto, its directors, officers, employees, servants, contractors and/or agents. Section 6.2 The DBB assumes,releases and agrees to indemnify, defend,protect and save City(including its officers,agents,representatives and employees)harmless from and against any claim, damage, loss, liability, injury, cost and expense (including reasonable attorney's fees and expenses) in connection with any loss or damage to any person or property arising out of or resulting in any way from the acts or omissions to act, negligence or willful misconduct of the 4 DBB, its directors, officers, employees, servants, contractors and/or agents in connection with the exercise of its rights and obligations under the terms of this IRU. The City assumes, releases and agrees to indemnify, defend, protect and save DBB (including its officers, agents, representatives and employees) harmless from and against any claim, damage, loss, liability, injury, cost and expense (including reasonable attorney's fees and expenses) in connection with any loss or damage to any person or property arising out of or resulting in any way from the acts or omissions to act, negligence or willful misconduct of the City, its directors, officers,employees,servants,contractors and/or agents in connection with the exercise of its rights and obligations under the terms of this IRU. Notwithstanding the foregoing, such indemnity is limited to the amount of available insurance coverage and nothing herein shall be considered as a waiver of its statutory tort limits under Minn. Stat. Chap. 466. Section 6.3 Nothing contained herein shall operate as a limitation on the right of either Parry hereto to bring an action for damages, including consequential damages, against any third party based on any acts or omissions of such third party as such acts or omissions may affect the construction, operation or use of the Fiber, Cable, or IRU Fibers; provided, however, that (i) the Parties to this Agreement shall not have any claim against the other Parry for indirect, incidental, special, punitive or consequential damages (including, but not limited to, any claim from any customer for loss of services), and(ii)each Party hereto shall assign such rights or claims, execute such documents and do whatever else may be reasonably necessary to enable the injured party to pursue any such action against such third party. ARTICLE VII FORCE MAJEURE The obligations of the parties hereto are subject to force majeure and neither party shall be in default under this Agreement if any failure or delay in performance is caused by strike or other labor dispute; accidents; acts of God; fire; flood; earthquake; lightning; unusually severe weather; material or facility shortages or unavailability not resulting from such party's failure to timely place orders therefor; lack of transportation; acts of any governmental authority; condemnation or the exercise of rights of eminent domain; war or civil disorder; or any other cause beyond the reasonable control of either parry hereto. The excused party shall use reasonable efforts under the circumstances to avoid or remove such causes of non-performance and shall proceed to perform with reasonable dispatch whenever such causes are removed or ceased. ARTICLE VIII RELOCATION OF CABLE Section 8.1 The City shall have the right to relocate the IRU Assets at any time upon written notice to the DBB (a "Relocation"). The City and/or Dakota County shall be responsible for all costs associated with a Relocation of the IRU Assets in County Right-of-Way that is required by alteration of the County Right-of-Way or by the request of a third party having authority to require 5 the move. The City may seek and receive funding or reimbursement from a third party for a Relocation within County Right-of-Way. The City shall be responsible for all costs associated with a Relocation of its IRU Assets in City Right-of-Way that is required by alteration of the City Right-of-Way or by the request of a third party having authority to require the move. The City may seek and receive funding or reimbursement from a third party for a Relocation by the City. Section 8.2 Either Party shall give the other Party at least sixty (60) days prior notice of any Relocation, if possible. The City has the right to determine the extent of, the timing of, and the methods to use for such Relocation; provided that any such relocated IRU Assets shall be constructed and tested in accordance with industry standard specifications and requirements. In addition, the City shall use reasonable efforts to ensure Relocation does not result in an adverse change to the operations, performance or connection points with the DBB Fiber Optic Cable network Section 8.3 The DBB has the right to review the Relocation plans at least fourteen (14) days prior to commencement of any Relocation. Either party may submit comments on the Relocation plans,which comments shall not delay commencement of the Relocation. Both parties shall have the right to have a representative present at the time a Relocation occurs. ARTICLE IX CONFIDENTIALITY The Parties agree and recognize that this Agreement as well as information and documents the Parties receive from one another during the term of this Agreement may be considered public data under the Minnesota Government Data Practices Act, Minn. Stat. Ch 13, as amended. The Parties agree to comply with the Minnesota Government Data Practices Act as it applies to all data provided by the Parties under this Agreement, and as it applies to all data created, collected, received, stored, used, maintained, or disseminated by any Party under this Agreement. The civil remedies of Minn. Stat. § 13.08 apply to the release of the data referred to in this clause by any Party. If either Party receives a request to release data arising out of or related to the Fiber Facilities or the use, operation or maintenance thereof, the Party receiving the request must immediately notify the other Party of the request. The Parties will promptly consult and discuss the best way to respond to the request. ARTICLE X ABANDONMENT; TERMINATION; EFFECT OF TERMINATION Section 10.1 Should the City decide to abandon all or part of the IRU Fibers during the term of this Agreement, it may do so by providing sixty (60) days' notice informing the DBB in writing of its intent to abandon. Such abandonment shall be at no cost to either Party except as set forth in this Article. If the City provides notice of intent to abandon,the DBB may notify the City prior to the expiration of the notice period of its intent to take ownership of the IRU Fibers. If the 6 DBB provides timely notice of such intent, the Parties will execute any agreements or documents transferring legal title of the IRU Fibers to the DBB, at no cost to either Party. Section 10.2 This Agreement shall terminate upon the first to occur of the following: (a) Expiration of the term of this Agreement; (b) Upon written notice from either Party to the other if a default occurs that is not cured within the time allowed hereunder, or (a) Upon a termination as provided in Section 10.4. Section 10.3 If this Agreement terminates under Article X, Section 10.2(a), neither Party shall have any liability to the other Party for the use of the IRU Fibers;If this Agreement terminates under Article X, Section 10.2(b), the non-defaulting party shall not have any liability to the defaulting party, and the defaulting party shall be liable for such damages to the non-defaulting party as the non-defaulting party may establish in a court of law, except as limited by this Agreement. Upon termination of this Agreement for any reason, the Parties agree to promptly execute any documents reasonably required to effect such termination. Section 10.4 The City may terminate this Agreement as to any IRU Assets owned by it with not less than two years prior written notice to the DBB. The DBB Board will consent to such termination unless the removal will render the Optical Fiber Dakota Broadband Network Backbone to be less than carrier class or violate any DBB contracts.The Parties recognize the two- year notice period is necessary and appropriate to permit the DBB to make alternative provisions for the continuance of service. The DBB Board may waive the two-year notice if it determines, in its sole discretion,that early termination will not adversely impact the Network. Section 10.5 Upon termination of this Agreement for any reason, the DBB shall cease to have any rights to the IRU Assets or other rights under this Agreement or any obligations under this Agreement except for obligations under this Article and any other obligations that arose prior to such termination. Section 10.6 If the City ceases to be a member of the DBB prior to the expiration or termination of this Agreement,this IRU Agreement will continue to be in effect until expiration. ARTICLE XI DEFAULT Section 11.1 Neither Party shall be in default under this Agreement unless and until the other Parry shall have given the defaulting party written notice of such default and the defaulting party shall have failed to cure the default within thirty(3 0)days after written receipt of such notice; provided, however, that where a default cannot be reasonably cured within the thirty (30) day period, if the defaulting party shall promptly proceed to cure the default with due diligence, the time for curing the default shall be extended for a period of up to ninety (90) days from the date of receipt of the default notice or until the default is cured,whichever is shorter. 7 Section 11.2 Upon the failure by the defaulting party to timely cure any default after notice thereof from the non-defaulting party,the non-defaulting party may take any action it determines, in its discretion, to be necessary to correct the default, and/or pursue any legal remedies it may have under applicable law or principles of equity relating to the breach. ARTICLE XII NOTICES Section 12.1 Unless otherwise provided herein,all notices and communications concerning this Agreement shall be in writing and addressed as follows: If to the City: City of Farmington Attn:Peter Gilbertson, IT Department 430 Third Street Farmington,MN 55024 With a copy to: City Attorney: Joel Jamnik Campbell Knutson 860 Blue Gentian Road Suite 2900 Eagan, MN 55121 If to DBB: Dakota Broadband Board Attn: Carah Koch, Executive Director 430 Third Street Farmington, MN 55024 With a copy to: Dakota Broadband Board Attorney: Paul Beaumaster Dakota County Attorney's Office 1560 Hwy 55 Hastings,MN 55033 Section 12.2 Unless otherwise provided herein,notices shall be sent by certified U.S.Mail, return receipt requested, or by commercial overnight delivery service which provides acknowledgment of delivery, and shall be deemed delivered: if sent by U.S. Mail, five (5) days after deposit; if sent by commercial overnight delivery service,upon verification of receipt. ARTICLE XIII LIMITATION ON PROPERTY INTEREST This Agreement does not grant the DBB any property interest or estate in or lien upon the City's property, the City's Optical Fiber Network or any components thereof or any Intellectual Property, except for use of the IRU Assets during the term of this Agreement. All liens, claims 8 and charges of the DBB shall not attach to any interest of the City or in any property owned by the City. This Agreement does not grant the City any property interest or estate in or lien upon the DBB's property, its Optical Fiber Dakota Broadband Network or any components thereof or any Intellectual Property. All liens, claims and charges of the City shall not attach to any interest of the DBB or in any property owned by the DBB. ARTICLE XIV GOVERNING LAW AND VENUE This Agreement shall be governed and construed in accordance with the laws of the State of Minnesota without regard to its conflict of laws provision. The Parties agree that any action arising out of this Agreement or with respect to the enforcement of this Agreement shall be venued in the Dakota County District Court, State of Minnesota. ARTICLE XV INDEPENDENT CONTRACTOR The performance by the DBB and the City of all duties and obligations under this Agreement shall be as independent local government units and not as agents of the other Parry, and no person employed or utilized by a party shall be considered the employee or agent of the other. Neither Party shall have the authority to enter into any agreement purporting to bind the other without its specific written authorization. The Parties agree this Agreement does not create a partnership between, or a joint venture of the DBB and the City. ARTICLE XVI MISCELLANEOUS Section 16.1 The headings of the Articles in this Agreement are strictly for convenience and shall not in any way be construed as amplifying or limiting any of the terms, provisions or conditions of this IRU Agreement. Section 16.2 When interpreting this Agreement, words used in the singular shall include the plural and the plural, the singular, and "of is used in the inclusive sense, in all cases where such meanings would be appropriate. Section 16.3 If any provision of this Agreement is found by any court of competent jurisdiction to be invalid or unenforceable, then the parties hereby waive such provision to the extent that it is found to be invalid or unenforceable and to the extent that to do so would not deprive one of the parties of the substantial benefit of its bargain. Such provision, to the extent allowable by law and the preceding sentence, shall not be voided or canceled, but instead will be modified by such court so that it becomes enforceable with all of the other terms of this Agreement continuing in full force and effect. 9 Section 16.4 This IRU Agreement may be amended only by a written instrument executed by all Parties. Section 16.5 No failure to exercise and no delay in exercising, on the part of either Parry hereto,any right,power or privilege hereunder shall operate as a waiver hereof,except as expressly provided herein. Any waiver by either Party of a breach of any provision of this Agreement shall not be deemed to be a waiver of any other or subsequent breach and shall not be construed to be a modification of the terms of this Agreement unless and until agreed to in writing by both Parties. Section 16.6 All actions, activities, consents, approvals and other undertakings of the Parties in this IRU Agreement shall be performed in a reasonable and timely manner. Section 16.7 Unless expressly defined herein,words having well known technical or trade meanings shall be so construed. Section 16.8 This IRU Agreement is solely for the benefit of the parties hereto and their permitted successors and assigns. ARTICLE XVII ENTIRE AGREEMENT This Agreement and any Exhibits referenced and attached hereto or to be attached hereto constitutes the entire agreement between the Parties and supersede any and all prior negotiations, understandings and agreements, whether oral or written. IRU GRANTOR: IRU GRANTEE: CITY OF FARMINGTON DAKOTA BROADBAND BOARD By: By: Its: Mayor Its: Board Chair Date: 20,Wc Date: B Its: Clerk Approved as to Form Assistant County Attorney Date 10 EXHIBIT A Description of City IRU Assets Subject to the IRU 1 NrmFpen l'q✓r t1-Xw T\�MYI15 •' ' J1 1'+���/...JJJ✓�,n tmlii N.Na✓,u r htl4 _ �r,.yan f++.flat✓.11-Mr1F , ✓.Fa. t L6.W.t •.✓F94.✓[W✓ NrtSew 4 NrF.IStrrtwrr w+l ! r[. ■ - . J n ■ ✓,attar arr. m fre SNltn Fl-S.✓F -- Legend o�aait - :a,:lt h✓rr lt✓Ml,1wM.knae - - I,vmi tan NntuarF — Oal:ol ,tnly IFetuurh � - , FARMINGTON IIBER WT-WORK u at s o..s as KRe / ' r,ara.mr.�•N. CITY OF O Q 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 =!nth O Farmington M N.gov TO: Mayor, Councilmembers and City Administrator FROM: David McKnight, City Administrator SUBJECT: Update on City Response to the COVI D Pandemic DATE: May 4, 2020 INTRODUCTION City staff will provide an update on the response to the COW D pandemic. DISCUSSION NA BUDGET IMPACT NA ACTION REQUESTED Please ask any questions you may have on the city's response to the COVI D pandemic.