Loading...
HomeMy WebLinkAbout07.19.21 Council Packet CITY OF Meeting Location: Farmington City Hall FARMINGTON 430 Third Street . Farmington,MN 55024 CITY COUNCIL REGULAR MEETING AGENDA July 19, 2021 7:00 P.M. Action Taken 1. CALL TO ORDER 7.00 P.M. This will be a joint meeting between the Farmington City Council and the Farmington School Board 2. PLEDGE OFALLEGIANCE 3. ROLL CALL 4. APPROVEAGENDA 5. ANNOUNCEMENTS I COMMENDATIONS 6. CITIZEN COMMENTS/RESPONSES TO COMMENTS(This time is reserved for citizen comments regarding non-agenda items.No official action can be taken on these items. Speakers are limited to five minutes to address the city council during citizen comment time.) 7. CONSENT AGENDA a) Approve Minutes of the June 21, 2021, City Council Meeting— Administration Approved b) Approve Minutes of the July 12, 2021, City Council Work Session— Administration Approved c) Adopt Resolution Accepting Donations to the Rambling River Center— Administration R32-21 d) Approve Extension of Employee Interchange Agreement with the Dakota Broadband Board -Administration Approved e) Approve IT Director Position Description and Promotion—Administration Approved f) Approve Recommendation for Hire—Administration Approved g) Approve Out of State Travel/Training—Dakota Broadband Approved h) Adopt Resolution Accepting Donations from Happy Harry's Furniture to the Rambling River Center- Parks R33-21 i) Adopt Resolution Accepting Donation from Thomas Dault-Beauchane to the Rambling River Center—Parks R34-21 j) Adopt Resolution Approving State of Minnesota Joint Powers Agreement with the City of Farmington on Behalf of its City Attorney and Police Department—Police R35-21 k) Approve a Contract for the 2021 Pavement Rejuvenation Project—Public Works Approved 1) Findings of Fact for Appeal of Planning Commission Decision—Farmington Enterprises, LLC—310 Third Street—Community Development Approved m) Approve Change Order#3 for Liquor Store Relocation Project- Administration Approved n) Approve Bills - Finance Approved REGULAR AGENDA 8. PUBLIC HEARINGS 9. AWARD OF CONTRACT 10. PETITIONS,REQUESTSAND COMMUNICATIONS 11. UNFINISHED BUSINESS 12. NEW BUSINESS a) Presentation of School District 192 Community Survey Results Information Received b) ISD 192 Update Information Received c) City of Farmington and Development Update Information Received 13. CITY COUNCIL ROUNDTABLE 14. ADJOURN CITY OF 0 430 Third St., Farmington, MN 55024 FARMINGTON 651-280-6800 FarmingtonMN.gov TO: Mayor, Councilmembers and City Administrator FROM: SUBJECT: This will be a joint meeting between the Farmington City Council and the Farmington School Board DATE: July 19, 2021 CITY OF © 430 Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 FarmingtonMN,gov TO: Mayor, Councilmembers and City Administrator FROM: David McKnight, City Administrator SUBJECT: Approve Minutes of the June 21, 2021 City Council Meeting-Administration DATE: July 19, 2021 INTRODUCTION Attached for your review are the minutes of the June 21, 2021 city council meeting. DISCUSSION NA BUDGET IMPACT NA ACTION REQUESTED Approve the minutes of the June 21, 2021 city council meeting. ATTACHMENTS: Type Description D Cover Memo June 21, 2021 City Council Minutes CITY OF FARMINGTON CITY COUNCIL MINUTES REGULAR MEETING JUNE 21, 2021 1) Call to Order Mayor Hoyt called the meeting to order at 7:00 p.m. 2) Pledge of Allegiance Mayor Hoyt led those in attendance in the Pledge of Allegiance. 3) Roll Call Present-Hoyt, Bernhjelm, Pearson, Porter and Wilson Absent-None Staff Present-Administrator McKnight, Parks and Recreation Director Omlid, Police Chief Rutherford, Fire Chief Elvestad, Planning Manager Wippler, Public Works Director Gehler, Community Development Director DiMaggio and Attorney Jamnik. 4) Agenda Motion by Bernhjelm, second by Pearson, to approve the agenda as amended with Councilmember Wilson pulling item 7e from the consent agenda. APIF, motion carried. 5) Announcement/Commendations a) Welcome Community Development Director DiMaggio Administrator McKnight welcome our new Community Development Director Samantha DiMaggio. She joins us from the City of Le Sueur where she worked in the same position and has experience with the City of Shakopee and DEED. The city council welcomed DiMaggio to her new position. 6) Citizen Comments a) Kyle Thompson-5375 180th Street-He was disappointed the city council chose not to support a Juneteenth proclamation. June 21, 2021 Minutes b) Kelsy Jezierski-18297 Dunbury Avenue-She was disappointed the city council chose not to support a Juneteenth proclamation. 7) Consent Agenda Motion by Pearson, second by Wilson,to approve the consent agenda: a) Approve Minutes of the June 7, 2021 City Council Meeting-Administration b) Approve Minutes of the June7, 2021 City Council Work Session-Administration c) Approve Liquor Store Renovations Change Orders-Administration d) Approve a Joint Powers Agreement with Dakota County to Establish an Organics Drop-Off Site in Farmington-Public Works e) Approve-Sea al H;riRg HuFna, o„sewFEes f) Approve Out of State Training-Fire g) Approve Recommendation for Hire-Fire h) Approve Recommendation for Hire-Fire i) Approve Recommendation for Hire-Fire j) Approve Recommendation for Hire-Fire k) Approve Recommendation for Hire-Fire 1) Approve Recommendation for Hire-Fire m) Approve Recommendation for Hire-Liquor n) Approve Additional Staff Issued Business Credit Cards-Finance o) Approve Bills-Finance Motion by Bernhjelm, second by Pearson, to approve item 7e, seasonal hiring. Voting in Favor- Bernhjelm, Pearson, Porter and Hoyt. Abstaining-Wilson. Motion passed 4-0. 8) Public Hearing a) Appeal of a Planning Commission Decision Regarding a Conditional Use Permit Request to Allow an Auto Repair, Major Use Within the B-2 Zoning District Planning Manager Wippler shared with the city council the appeal of the Zoning Board of Adjustment action to deny a conditional use permit for an auto repair, major use at the property address of 310 Third Street. The appeal was submitted by Farmington Enterprises, LLC, the owner of the property. The Planning Commission reviewed the application and held a public hearing for the conditional use permit on May 11, 2021. The Planning Commission denied the conditional use request. June 21, 2021 Minutes City staff recommended denial of the conditional use permit and the Planning Commission did not feel that the proposed use would be harmonious with the surrounding neighborhood. Motion by Bernhjelm, second by Wilson, to close the public hearing. APIF, motion carried. Motion by Bernhjelm, second by Pearson, to deny the appeal of Farmington Enterprises, LLC asking to allow an auto repair, major use at the property located at 310 Third Street. APIF, motion carried. 9) Award of Contract None 10) Petitions, Requests and Communications None 11) Unfinished Business None 12) New Business a) Accept Bids and Award a Contract for the 2021 Downtown Sidewalk Replacement Project Public Works Director Gehler presented the results of the 2021 Downtown Sidewalk Replacement Project. The project, as bid,will entail replacement of sidewalk along Third Street from County Road 50 to Spruce Street, at the intersection of Third Street and Oak Street, along Spruce Street and around City Hall. County sidewalk replacements have also been incorporated along Elm Street through a joint powers agreement. Plans and specifications were developed for the project and advertised for bidding on May 14, 2021. Bids were due on June 8,2021 with the city receiving four bids. The bid amounts were as follows: Pember Companies $571,685.70 McNamara Contracting $605,736.00 JL Thies $695,418.10 Urban Companies $892,464.00 Pember Companies was the lowest responsible bidder. The have completed a similar downtown project in Hastings. The city council is asked to accept the bid and award the contract to Pember Companies. June 21,2021 Minutes Outside of the construction contract,there are other components to this project for the city council to consider- 1. Many of the 52 light bases in the downtown have been damaged to varying degrees over the last 20 years. As part of the project,the bases are planned to be replaced. The bases will be purchased directly by the city to minimize multiple mark-ups on the expense. The specifications have been developed to include installation of the bases assuming no major distribution delays occur. The city council is being asked to authorize the purchase of bases as part of this agenda item that is estimated to be$56,000. 2. With the rest of the new items, including the street light bases,staff will also pursue painting of the poles. Many of the poles have been scratched and the paint is fading. Funding for this work will come from the Street Light Fund and is estimated to cost$6,500. 3. Due to the very favorable bids,staff approached the contractor to gauge the willingness and availability to complete additional work. The contractor is willing to entertain adding segments to the project at the unit bid prices.This pricing was applied to the Oak Street sidewalks along with the pedestrian area between Third Street and Second Street south of the Dakota Motors Building. This cost is estimated to be an additional$150,000. If the city council would like to pursue this work,they should authorize the change to the contract. 4. The project has focused on the replacement of the aging bricks with standard concrete sidewalks. To complete the aesthetics in the downtown,site furniture such as benches, planters and garbage receptacles could be considered. Staff is estimating the cost for replacing the benches and garbage receptacles in place today and adding several planters would cost around $70,000. 5. The engineering contract for this project was completed before the parking lots were added to the project. The additional engineering (survey, design, plan preparation and construction administration) has been quoted at $17,229. The city council is being asked to approve this modification to the contract. In addition, if the city council wishes to complete the additional work on Oak Street, they should authorize staff to negotiate an amended for this work as well. The city council discussed allocating funds for this project with $300,000 dedicated for the sidewalk work and$400,000 dedicated to replacement of parking lots. In addition, Dakota County will contribute funds for their portion of the work. If the city council would like to consider the additional work along Oak Street and the pedestrian walkway,funding could be allocated from the General Fund balance. Councilmember Bernhjelm asked about the possibility of attaching the Spruce Street work to the project next year. Gehler stated the project in 2022 would end at the railroad tracks. Councilmember Pearson asked if the low bid was a surprise. Gehler stated it is the condition of the market at this point. Councilmember Porter shared that she thought the aesthetic improvements were important. Councilmember Wilson shared he has some financial concerns with the addition but also believes aesthetics are important. June 21, 2021 Minutes Motion by Bernhjelm,second by Porter,to accept the bids and award a contract to Pember Companies in the amount of$571,685.70, authorize staff to purchase street light bases estimated to be$56,000, approve a change order for the additional work along Oak Street and the pedestrian way between Second and Third Streets, approve an amendment to the engineering contract and include the streetscape aesthetic improvements. APIF, motion carried. b) 2021/2022 City Council Priorities Update Administrator McKnight provided an update on the city council 2021/2022 city council priorities. Earlier this year the city council set three intentionally broad priorities-business growth, community engagement and infrastructure support. These priorities included the how and who in making progress on each item. McKnight reviewed the progress in all three areas. Recent staff changes slowed some of the work but now that we are approaching full staff levels again,work can begin in a number of areas. Councilmember Bernhjelm stated she was glad that the city council set these priorities for two years with the unexpected issues we have encountered this year. Mayor Hoyt shared that communication like this increases efficiencies and transparency. 13) City Council Roundtable Bernhjelm-Participated in the first BR and E first this morning and shared her thoughts on Juneteenth. Pearson-Shared her thoughts on Juneteenth and thanked residents for their input. Porter-Congratulated the FHS Baseball team for winning the state championship. Wilson-Congratulated the FHS Baseball team for winning the state championship welcome the new firefighters hired on the consent agenda tonight, congratulated the track teams for their success at the state tournament and thanked parks staff for a successful Dew Run. Jamnik-Provided an update on the legislative special session. Gehler-Water rebate program and EAP treatment program are available to residents. DiMaggio-Thanked everyone for the warm welcome today. Omlid-Music in the Park will take place on June 30, 2021 at Rambling River Park. June 21, 2021 Minutes Hoyt-Congratulated the Tiger athletic teams, shared about the organics drop off approved on the consent agenda and shared his thoughts on Juneteenth. 13. Adjourn Motion by Wilson,second by Bernhjelm,to adjourn the meeting at 8:00 p.m. APIF, motion carried. Respectfully Submitted V~a9 "C-11 ,vlit David McKnight, City Administrator June 21,2021 Minutes CITY C3 O 430 Third St., Farmington, MN 55024 FARMINGTON © 651-280-6800 i FarmingtonMN.gov TO: Mayor, Councilmembers and City Administrator FROM: David McKnight, City Administrator SUBJECT: Approve Minutes of the July 12, 2021 City Council Work Session-Administration DATE: July 19, 2021 INTRODUCTION Attached for your review are the minutes of the July 12, 2021 city council work session. DISCUSSION NA BUDGET IMPACT NA ACTION REQUESTED Approve the July 12, 2021 city council work session minutes. ATTACHMENTS: Type Description © Cover Memo July 12, 2021 Work Session Minutes CITY OF FARMINGTON CITY COUNCIL MINUTES WORK SESSION JULY 12,2021 Call to Order Mayor Hoyt called the work session to order at 5:00 p.m. Roll Call Present-Hoyt, Bernhjelm, Pearson, Porter and Wilson Absent-None Also Present-Administrator McKnight, Police Chief Rutherford, Fire Chief Elvestad, Parks and Recreation Director Omlid and Public Works Director Gehler. Agenda Motion by Pearson, second by Bernhjelm,to approve the agenda as presented.APIF, motion carried. 2022/2023 Draft Budget Administrator McKnight presented the first draft of the 2022/2023 budget. McKnight shared that the budget was based off department needs and city council priorities set for 2022/2023. These priorities include: ✓ Developing dedicated financial benchmarks for capital replacement in the annual budget. ✓ Developing dedicated financial benchmarks for infrastructure support and facilities in the annual budget. ✓ Developing a staffing plan for inclusion in the annual budget and financial plan. McKnight reviewed the current draft of the 2022 budget- 2021 Budget 2022 Draft Budget Increase/(Decrease) Revenues $3,298,344 $3,577,333 8.46% Expenditures $13,832,464 $15,870,719 16.70% Fiscal Disparities $2,277,659 $2,277,659 0.00% Gen Fund Levy $8,256,461 $10,015,727 21.31% Debt Levy $3,012,093 $2,265,788 (17.32%) Net Tax Levy $11,268,554 $12,281,515 8.99% McKnight reviewed the reasoning behind the increases in revenues and expenditures. A lot of discussion occurred around the proposed increases in the Transfers Budget related to the city council priorities for 2022/2023. Councilmember Bernhjelm asked about the estimate for new tax growth in 2022. McKnight estimated it to be 1%at the most. Councilmember Pearson asked about the potential use of dollars we will start to review from Hy-Vee this year. McKnight stated that he would inquire with the city attorney to see if there are any restrictions. Councilmember Wilson expressed a desire to increase trail maintenance funding. Mayor Hoyt asked about the impact of deferred trail maintenance and expressed a desire to really address the funding issue and not continue to pass it on to future city councils. Bernhjelm expressed support for where the budget stands today to start address the needs of the community. She would prefer that the additional funding be targeted to projects that residents can see. Councilmember Pearson expressed concern about the economy changing and how reduced permit revenues and foreclosures will affect the city. The impact on the potential 2022 ballot question was also discussed. Wilson would like to shift more funding to trail maintenance. He would also like staff to discuss possible state and federal bonding project possibilities. The consensus of the city council was to have staff adjust the budget to develop a plan forward the next few years to address the three city council priorities. Concern was expressed about where the tax levy stands today. The city council will review the draft budget again at the August work session. Emergency Management and City Council Role Police Chief Rutherford and Fire Chief Elvestad discussed the issue of emergency management and the city council role in large-scale events. Rutherford reviewed the four goals of emergency management and how they can be incorporated into events that occur in Farmington. The city council and city staff discussed the general approach that has been and will be taken when issues of significance occur. A common theme of trusting the work that staff is doing was discussed. Communication between the city council, city administrator and city staff was a key issue for our successful handing of these events. The city council role in emergencies was discussed. Having one spokesperson, relying on staff to perform their jobs and being on the same page was discussed. Recent examples of how cities have approach this issue were reviewed. The group agreed that the discussion was positive and should continue in the future. City Administrator Update Administrator McKnight updated the city council on the following items: ✓ Downtown liquor store move progress and new store buildout. ✓ Joint City Council/School Board meeting next week. ✓ Ladder 1 ceremony scheduled for July 21St ✓ Parks tour scheduled for August 11tH ✓ Update on the assistant city administrator and finance director positions. Adjourn Motion by Bernhjelm,second by Pearson,to adjourn the meeting at 6:45 p.m. APIF, motion carried. CITY OF O 430 Third St., Farmington, MN 55024 FARMINGTON © 651-280-6800 T FarmingtonMN.gov TO: Mayor, Councilmembers and City Administrator FROM: David McKnight, City Administrator SUBJECT: Adopt Resolution Accepting Donations to the Rambling River Center-Administration DATE: July 19, 2021 INTRODUCTION Recently a fundraising effort was undertaken to raise funds to purchase a new treadmill for the Rambling River Center. DISCUSSION The city administrator recently led a fundraising effort to raise funds to purchase a new treadmill for the Rambling River Center. This effort involved running 150 miles of city streets and trails over the past three months. I am happy to report that this effort has been completed and a new treadmill has been delivered to the Jack and Bev McKnight Fitness Center at the Rambling River Center. BUDGET IMPACT The money raised through this fundraiser will be used to purchase a new treadmill for the Rambling River Center. Any leftover funds will be used to purchase additional equipment for the fitness center. ACTION REQUESTED Adapt the resolution accepting donations from various parties in the amount of$6,000 for use at the the Rambling River Center. ATTACHMENTS: Type Description D Resolution RRC Resolution D Backup Material Donations Tracker RESOLUTION NO. R32-21 A RESOLUTION ACCEPTING DONATIONS TO THE RAMBLING RIVER CENTER Pursuant to due call and notice thereof, a regular meeting of the City Council of the City of Farmington was held at Farmington City Hall on the 19th day of July 2021 at 7:00 p.m. Members Present: Bernhj elm, Pearson, Porter, Wilson Members Absent: Hoyt Member Pearson and Member Wilson introduced and seconded the following: WHEREAS, the Jack and Bev McKnight Fitness Center in the Rambling River Center is in need of upgraded equipment; and WHEREAS, the city administrator undertook a fundraising effort to run 150 miles of city streets and trails between April and June 2021 for the purchase of a new treadmill; and WHEREAS, the fundraising efforts were successful with $6,000 being raised from numerous individuals for the purchase of a new treadmill. NOW THEREFORE BE IT RESOLVED, the Mayor and City Council of the City of Farmington hereby accept the donation of $6,000 from the individuals listed on the attached document for the purchase of a new treadmill for the Jack and Bev McKnight Fitness Center. This resolution was adopted by recorded vote of the Farmington City Council in open session on the 19th day of July 2021. oshua Hoyt, Mayor Attested to on the 19th day of July 2021. David cKnight, C y inistrator SEAL CITY OF FARMINGTON RUN FOR THE RAMBLING RIVER CENTER DONATIONS TRACKER DONATIONS SUE AND JOHN RYDBERG $100.00 DAVID AND RUTH MCKNIGHT $300.00 DARIN PETTIS $100.00 MARK SHIRLEY $100.00 DEAN AND MICHELLE BOSTROM $60.00 JOY PEARSON $250.00 LACELLE AND SHERRY CORDES $300.00 JAKE CORDES $100.00 MARILYN TOSNEY $50.00 KATIE BERNHJELM $20.00 MARY AND VERN VALLIANT $100.00 JANIE TUTEWOHL $500.00 JACKIE AND STU WORKMAN $50.00 PAULETTE AND LEROY MCLAUGHLIN $75.00 JOSHUA HOYT $200.00 MARK AND MARGIE SCHROEDER $200.00 MARK DONNELLY $100.00 TIM AND SHELLY THOMPSON $200.00 MIKE AND CINDY MCKNIGHT $100.00 STEVE WILSON $150.00 TIM MCKNIGHT $50.00 KEVIN AND JULIE MCKNIGHT $100.00 RYAN HAYES $100.00 CASTLE ROCK BANK $200.00 CAROLE HANSEN $100.00 LOIS LOTZE/AMY VANDENHEUVEL $100.00 RRC COFFEE GUYS $50.00 JODY PECKHAM $25.00 JENNIFER AND HENRY SCHNEIDER $100.00 CINDY MCMILLEN $20.00 PAM HEIKKILA $100.00 WHITE FUNERAL HOME $250.00 LINDA AND PAUL LANDWEHR $100.00 NORRIE ARMSTRONG $20.00 PAM MCCARTHY $500.00 FARMINGTON VFW $250.00 KIM LOMAS $20.00 JIM AND SHARI MCKNIGHT $100.00 MAUREEN AND MEL KUNDE $100.00 NANCY GUSTAFSON $100.00 ANONYMOUS $560.00 TOTAL $6,000.00 CITY OF 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 Ou�YI� Farmington MN,gov TO: Mayor, Councilmembers and City Administrator FROM: David McKnight, City Administrator SUBJECT: Approve Extension of Employee Interchange Agreement with the Dakoa Broadband Board-Administration DATE: July 19, 2021 INTRODUCTION In 2019,the City of Farmington and the Dakota Broadband Board entered into an Employee Interchange Agreement. That agreement had a two year term that expired in June 2021. DISCUSSION The purpose of the Employee Interchange Agreement is to provide assistance with the operations of the Dakota Broadband Board and to fulfill the requirements of the agreement between the city and the DBB. The referred employee is assigned to the role of executive director of the DBB during the term of the agreement or until either party terminates this agreement prior to the expiration of the term. Having the DBB Executive Director as a City of Farmington employee has proven successful. The DBB Board did not have any concerns with extending the agreement with the city. I have attached a copy of the Employee I nterchange Agreement that was approved in 2019 for your review. BUDGET IMPACT These is no additional budget impact on the city with the extension of this agreement. The city would continue to be responsible for our share of the DBB costs as detailed in other agreements. ACTION REQUESTED Ask any questions you may have on this issue. Once the city council is comfortable, a motion should be made to extend the Employee I nterchange Agreement between the City of Farmington and the Dakota Broadband Board through June 2023. ATTACHMENTS: Type Description D Cover Memo Employee Interchange Agreement EMPLOYEE INTERCHANGE AGREEMENT This Agreement constitutes a written record of the obligations and responsibilities of the following parties to an employee assignment arranged under the authority of Minn. Stat.§15.51 15.59. In the event any provision in this form Is found to be In conflict with any current statute applicable to this agreement, the statute will prevail, and the provision shall be.deemed revised to the extent necessary to conform to the statutory requirements. PART I-- Parties to the Agreement Sending Agency: City of Farmington Receiving Agency: Dakota Broadband Board (DBB), a joint powers organization PART I1—Status of this Agreement X New Agreement Modification Extension PART III —Reason for Employee Interchange The purpose of this employee interchange is to provide assistance with the operations of the Dakota Broadband Board and to fulfill the requirements of an interagency agreement between the City of Farmington and the DBB.The referred employee is assigned to the role of executive director of the DBB during the term of this agreement or until either party terminates this agreement prior to the expiration of the term. PART IV—Information on Participating Employee Name: Carah Koch Home Address: Home Phone: Position Title: Executive Director Current Pay Detail (Hourly rate/Annual Salary): Salary Grade D62; Range$98,543 to $127,927 Special Pay Conditions: N/A PART V-- Data on Sending Agency City of Farmington Employment Address: 430 Third St., Farmington, MN 55024 Immediate Supervisor: David McKnight, City Administrator Sig-203 Farmington Employee Interchange Agreement with Dakota Broadband Board v4 2 Supervisor's Phone: 651,280.6801 Supervisor's eMail: dmcknight@farmingtommn.gov PART Vi — Data on Receiving Agency: Dakota Broadband Board A joint powers organization created by the cities of Apple Valley, Burnsville, Farmington, Hastings, Inver Grove Heights, Lakeville, Mendota Heights, Rosemount, South St. Paul, West St. Paul and the County of Dakota Mailing Address: 1590 Highway 55, Hastings, MN 55033 Immediate Supervisor: Dakota Broadband Board Chair Supervisor's phone: 651.450.2500 Supervisor's eMaii: gtourville@invergroveheights,org PART Vll - Position Summary: The primary responsibility of this position is to fulfill the role and job duties of executive director of the Dakota Broadband Board. PART VIII --Position Description (Attached) PART IX--Salary and Benefits; Fiscal Obligations and Billing Process Farmington (the Sending Agency) will be the employer and will pay the employee's salary and fringe benefits under this Agreement. The employee will retain all benefits provided by Farmington. The Receiving Agency will reimburse Farmington for any salary, fringe benefits and reimbursable travel and transportation expenses at the rates paid by Farmington during the term of this agreement, Farmington will bill the DBB quarterly to obtain reimbursement for employee's salary, fringe benefits and reimbursable travel and transportation expenses. As an employee of Farmington, the employee will abide by the policies and procedures of Farmington regarding PTO leave and holiday benefits. The employee should request approval of PTO leave through the Farmington supervisor and Farmington will, to the extent possible, be flexible in adjusting time off while meeting work demands. Farmington shall conferwith the DBB Executive Committee Chair regarding any requested leave in excess of 3 days to take into consider the potential impacts on the employee's work demands. Any overtime scheduling or balancing of hours will be made by Farmington. Farmington will provide to the DBB reports and records of PTO leave used by employee as requested by the DBB. The employee consents to the disclosure of this information to the DBB during the period that she is serving as the DBB executive director. Farmington will prepare invoices In a manner prescribed by DBB, or otherwise agreed upon by the parties, and transmit them to the chair of the DBB Executive Committee and the DBB financial administrator, currently the Dakota County Financial Services Department, at the 819-203 Farrington Employee Interchange Agreement with Dakota Broadband Board v4 2 i i address provided by the financial administrator, no later than the 10th day of the month following j the end of the quarter. Time sheets and documentation of days worked will be kept by Farmington for 7 years. PART X --Travel, Transportation Expenses and Allowances Farmington will reimburse the employee directly for all travel, lodging and meat expenses associated with DBB related work activities. To receive reimbursements for these activities, employee must submit statements and invoices to Farmington. The types of expenses and amounts reimbursed will as allowed by Farmington's expense reimbursement plan. PART XI ­Work Location and Nature/Extent of Supervision Provided Work Location Farmington will provide an office or work station at Farmington city offices for employee's use, but the parties acknowledge and agree that the employee will often perform work tasks at other locations throughout Dakota County and may be provided other work locations by the DBB. Employee Supervision and Performance'Reviews The parties agree that the employee will have a six-month probationary period. The parties agree that the annual goals and objectives for the employee will.be developed by the DBB In coordination with Farmington to ensure they are consistent with the goals and objectives of the DBB Board and its Executive Committee. Prior to preparing an annual performance review, Farmington will request input from the DBB on the performance of the employee and the accomplishment of annual goals and objectives. Farmington will take Into account the input provided by the DBB when preparing a performance reviews for the employee. Employee agrees to provide a copy of her annual performance review, and consents to Farmington providing a copy of her annual performance review, to the Chairs of the DBB Board and Executive Committee and authorizes the Chairs to share information in the employee's performance reviews with others on the DBB Board or Executive Committee members as necessary to improve the operations of the DBB. PART X11 --Status of Employee While performing work for the DBB pursuant to this Agreement, the employee's status shall be governed by M.S. §15.56. For all purposes, the employee shall remain and be considered to be an employee of Farmington, unless provided otherwise by this Agreement. If the employee suffers a disability, personal injury or death as a result of personal Injury arising out of and in the course of this assignment,or sustained In the performance of these duties,the DBB or its insurer shall reimburse Farmington for the costs It incurs for compensating the employee for the employee's disability, personal Injury or death as a result of personal injury arising out of and in the course of this assignment. However, if Farmington is a member of the DBB on the date employee suffers a disability, personal injury or death when performing work duties under this Agreement, the reimbursement paid to Farmington by the DBB shall be adjusted to account for Farmington's share of the DBE's financial obligations as a member. For workers' compensation coverage purposes, the employee shall be treated as an employee of Farmington and any compensation paid shall be Farmington's responsibility under its worker's compensation insurance program. S19-203 Farmington Employee Interchange Agreement with Dakota Broadband Board v4 3 PART X111 —Liability Except as provided in PART XII,the DBB will be responsible for the acts of the employee during the term of this Agreement to the extent authorized by law. Liability to third parties arising from actions of the employee while performing work duties under this Agreement shall be paid in the following order of priority, as available: Liability Insurance purchased by DBB Liability insurance purchased by Farmington Available funds of the DDB PART XIV--Cancellation This Agreement is subject to cancellation by either the Sending Agency or the Receiving Agency upon 60 days written notice. PART XV--Applicability of Rules, Regulations and Policies The employee will abide by all policies and procedures governing the operation and management of the DBB while working with the DBB. PART XVI --Duration of Agreement The Agreement is effective on the date of execution by all parties and shall continue for an Initial term period of six (6) months from the first day employee is employed by Farmington, an employment start date that shall be mutually agreed upon by employee and Farmington. This initial term is referred to herein as the Probationary Term. If Farmington, in consultation with the DBB, does not terminate the employee and the employee does not resign from the position before the expiration of the Probationary Term, this Agreement will continue for a period of two years. Prior to expiration of the initial two year term, the City of Farmington may extend this Agreement for an additional two year term by action of Its governing body. M-203 Farmington Employee Interchange Agreement with Dakota Broadband Board v4 4 PART XVII --Assigned Employee's Statement of Understanding I, Carah Koch, understand the terms of this interchange agreement which provides for my assignment to the position of Dakota Broadband Board Executive Director. I also understand the expectations of the Dakota Broadband Board regarding this assignment. Intending to be bound by all of its terms, the parties have executed this Agreement on the dates indicated below. Employee Date Dakota Broadband Board Chair Date V,os A.% R4,101'a X*OA CL e ity of Farmington Date Approved as to form: Assistant County Attorney/Date 819-203 Farmington Employee Interchange Agreement with Dakota Broadband Board v4 5 CITY OF 0 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 Farmington MN.gov TO: Mayor, Councilmembers and City Administrator FROM: David McKnight, City Administrator SUBJECT: Approve IT Director Position Description and Promotion-Administration DATE: July 19, 2021 INTRODUCTION Over the past two years our organizations information technology needs have both expanded and evolved and are one of the most demanding times in city history. I am proposing an update of the lead position in our I T Department to reflect the work that has taken place over the past few years and to prepare for the future. DISCUSSION Prior to my arrival,the city I T functions were a part of the H uman Resources Department for a number of reasons. Over the past ten years I have watched as our demands in the I T area have grown, staff in other departments have taken on tasks related to IT and the culmination of the high demands of IT over the past 15 months with the pandemic. Three years ago,the IT staff were moved under the Administration Department. Our current IT structure has the Network Administrator and IT Specialist both reporting to the city administrator. Our current Network Administrator, Peter Gilbertson, came into his position two years ago and started from scratch on building the IT Department into what it is today. His knowledge of our many different systems has proven to be very beneficial to city staff and our organization. It is time to make the changes to both reflect the actual work that is being done and set up a structure to allow the I T Department to thrive and prepare for the future. With this in mind, I am making the following recommendations- 1. The Network Administrator position description be upgraded to the new IT Director position description. 2. The IT Director will report,for now,to the Assistant City Administrator. 3. The IT Director will be the direct supervisor of the IT Specialist and will be responsible for all supervisory type functions. 4. The IT Director position has been sent in for a band/grade review. That will be placed on a future city council agenda for approval. 5. Peter Gilbertson shall be named as the IT Director. 6. Mr. Gilbertson's wage will be evaluated once we review the band/grade review back and placed on a future city council meeting for approval. 7. The effective date of all of the proposed changes is Monday,June 21, 2021. Farmington City Code Section 1-7-3 requires the city council to approve, amongst other things; promotions/changes to job titles and band changes and other changes in employee compensation outside of normal practices. The performance shown by Mr. Gilbertson over the past two years has given me great confidence in his ability to take on the I T Director role. I n reality, he has been doing this work since he started working for the city. You have all witnessed how he led the I T work during the pandemic and know first hand the skills and abilities he possesses. BUDGET IMPACT This will be determined once we received the new band/grade for the position. ACTION REQUESTED Ask any questions you may have on this proposal. If the city council is comfortable, a motion should be made to approve the IT Directorjob description and the promotion of Peter Gilbertson to IT Director. CITE OF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 r FarmingtonMN.gov TO: Mayor, Councilmembers and City Administrator FROM: Jennifer Gabbard, Human Resources Director SUBJECT: Approve Recommendation for Hire-Administration DATE: July 19, 2021 INTRODUCTION The recruitment and selection process for the appointment of an Assistant City Administrator position has been completed. DISCUSSION After a thorough review by the Administration and Human Resources Department, a contingent offer of employment has been made to Lynn Gorski,subject to ratification by the city council. Ms. Gorski currently works for the City of Owatonna as their Human Resources Director. Her experience meets the qualifications for this position. BUDGET IMPACT Mr. Gorski's starting salary will be$126,442, which is Step 8 of the salary range for this position (salary range:$104,543 to$135,716) The city council previously agreed to add this position to the 2021 budget. ACTION REQUESTED Approve the appointment of Lynn Gorski effective on or about August 16, 2021. CITY O 0 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 Farmington MN.gov TO: Mayor, Councilmembers and City Administrator FROM: David McKnight, City Administrator SUBJECT: Approve Out of State Travel/Training-Dakota Broadband DATE: July 19, 2021 INTRODUCTION Dakota Broadand Board Executive Director Carah Koch has requested to attend the Fiber Connect 2021 Conference in Nashville,Tennessee. DISCUSSION Carah Koch has requested to attend a conference out of state to enhance her role as the Dakota Broadband Board Executive Director. She would like to attend the Fiber Connect 2021 Conference from July 25-28, 2021 to be held in Nashville Tennessee. The conference includes educational seminars on broadband, its development and opportunities for funding and public/private partnerships. I n addition, technology exhibits and networking with participants from across the county are an added benefit to these types of conferences. The cost of attending the conference is estimated at$2,000 to include conference registration, airfare and hotel. The Dakota Broadband Board Chair is in support of this request. More information on the conference can be found at http://www.fiberconnect2021.com/program/. BUDGET IMPACT The Dakota Broadband Board 2021 budget includes $5,000 for training and education. ACTION REQUESTED Ask any questions you may have on this topic. Once the city council is comfortable, a motion should be made to approve the attendance of Dakota Broadband Board Executive Director Carah Koch at the Fiber Connect 2021 Conference in Nashville,Tennessee from July 25-28,2021. CITYOF O 430 Third St., Farmington, MN 55024 FARMINGTON © 651-280-6800 I' Farmington MN.gov TO: Mayor, Councilmembers and City Administrator FROM: Kellee Omlid, Parks and Recreation Director SUBJECT: Adopt Resolution Accepting Donations From Happy Harry's Furniture to the Rambling River Center-Parks DATE: July 19, 2021 INTRODUCTION Two donations were recently made by Happy Harry's Furniture to the Rambling River Center(RRC). DISCUSSION Donations in the amount of$109.90 and $248.80 for a total of$358.70 were recently made by Happy Harry's Furniture to the RRC.The donation was made through a program created in 2011 in which a customer of Happy Harry's Furniture is able to select a charity of their choice to receive a donation when merchandise is purchased from the store. Then 10%from the sale to the customer is donated to the charity. The RRC is one of the charities that can be selected by customers. With these donations, Happy Harry's Furniture has donated a total of$12,7279.97 to the RRC since the program's inception.This partnership with Happy Harry's Furniture has been very beneficial over the long term given the funds that have been donated to the RRC. These donations have been deposited into the RRC Capital Improvement Fund to fund future building improvements and/or purchase new equipment and furniture. Staff will communicate the City's appreciation on behalf of the City Council to Happy Harry's Furniture for their generous donations to the RRC. BUDGET IMPACT NA ACTION REQUESTED Adopt the attached resolution accepting the donations totaling$358.70 from Happy Harry's Furniture to the RRC. ATTACHMENTS: Type Description ❑ Resolution Donation Resolution RESOLUTION NO. R33-21 ACCEPT DONATION OF $358.70 FROM HAPPY HARRY'S FURNITURE TO THE RAMBLING RIVER CENTER Pursuant to due call and notice thereof, a regular meeting of the City Council of the City of Farmington, Minnesota, was held in the Council Chambers of said City on the 19th day of July, 2021 at 7:00 p.m. Members Present: Bernhj elm, Pearson, Porter, Wilson Members Absent: Hoyt Member Pearson and Member Wilson introduced and seconded the following: WHEREAS, a donation of$358.70 was made by Happy Harry's Furniture to the Rambling River Center; and, WHEREAS, it is required by State Statute that such donation be formally accepted; and, WHEREAS, it is in the best interest of the city to accept this donation. NOW, THEREFORE,BE IT RESOLVED that the city of Farmington hereby accepts with gratitude the generous donation of$358.70 from Happy Harry's Furniture to the Rambling River Center. This resolution adopted by recorded vote of the Farmington City Council in ol2en session on the 19th day of July, 2021. Mayor Attested to the day of July, 2021. i Administrator el�(l SEAL CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 e FarmingtonMN.gov TO: Mayor, Councilmembers and City Administrator FROM: Kellee Omlid, Parks and Recreation Director SUBJECT: Adopt Resolution Accepting Donation From Thomas Dault-Beauchane to the Rambling River Center-Parks DATE: July 19, 2021 INTRODUCTION Thomas Dault-Beauchane recently gave a donation to the Rambling River Center. DISCUSSION Thomas Dault-Beauchane recently made a $100.00 donation to the Rambling River Center. The donated money will be placed in the Rambling River Center's Capital Improvement Fund,so it may either be used for future building improvements at the Rambling River Center or to purchase new equipment or furniture. Staff will communicate the City's appreciation on behalf of the City Council to Thomas Dault-Beauchane for this generous donation. ACTION REQUESTED Adopt the attached resolution accepting the donation of$100.00 from Thomas Dault-Beauchane to the Rambling River Center. ATTACHMENTS: Type Description D Resolution Donation Resolution RESOLUTION NO. R34-21 ACCEPT DONATION OF $100.00 FROM THOMAS DAULT-BEAUCHANE TO THE RAMBLING RIVER CENTER Pursuant to due call and notice thereof, a regular meeting of the City Council of the City of Farmington, Minnesota, was held in the Council Chambers of said City on the 19th day of July, 2021 at 7:00 p.m. Members Present: Bernhj elm, Pearson, Porter, Wilson Members Absent: Hoyt Member Pearson and Member Wilson introduced and seconded the following: WHEREAS, a donation of$100.00 was made by Thomas Dault-Beauchane to the Rambling River Center; and, WHEREAS, it is required by State Statute that such donation be formally accepted; and, WHEREAS, it is in the best interest of the city to accept this donation. NOW, THEREFORE, BE IT RESOLVED that the city of Farmington hereby accepts with gratitude the generous donation of$100.00 from Thomas Dault-Beauchane to the Rambling River Center. This resolution adopted by recorded vote of the Farmington City Council in open session on the 19th day of July, 2021. Mayor Attested to the day of July, 2021. 01ty AVdn:�m�i'niestr4arteo�r(--4.-J� SEAL CITY O O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 Farmington MN.gov TO: Mayor, Councilmembers and City Administrator FROM: Gary Rutherford, Chief of Police SUBJECT: Adopt Resolution Approving State of Minnesota Joint Powers Agreement with the City of Farmington on Behalf of its City Attorney and Police Department-Police DATE: July 19, 2021 INTRODUCTION The State of Minnesota, Bureau of Criminal Apprehension (BCA), is authorized under Minnesota State Statute to maintain and provide a criminal justice data communications network. In addition,the BCA maintains or has access to repositories of data that benefit criminal justice agencies. This data is utilized in support of our criminal justice duties. DISCUSSION I n order for the BCA to share access to this data, it is necessary that the City of Farmington,the Farmington Police Department and its Prosecuting Authority enter into a joint powers agreement allowing that information to be shared. This JPA was last approved in 2016 and renewal is required every five years. BUDGET IMPACT The City of Farmington currently pays the State$1,080 annually for connection services allowing us to access information necessary to fulfill our mission. This amount is budgeted annually and no change has been requested. ACTION REQUESTED Staff recommends adoption of the attached resolution between the State of Minnesota, Bureau of Criminal Apprehension and the City of Farmington. ATTACHMENTS: Type Description D Resolution BCA CJ D N JPA Resolution n Backup Material BCA JPA D Backup Material Court Amendment RESOLUTION NO. R35-21 RESOLUTION APPROVING STATE OF MINNESOTA JOINT POWERS AGREEMENTS WITH THE CITY OF FARMINGTON ON BEHALF OF ITS CITY ATTORNEY AND POLICE DEPARTMENT Pursuant to due call and notice thereof, a regular meeting of the City Council of the City of Farmington, Minnesota, was held in the council chambers of said city on the 19"' day of July 2021 at 7:00 p.m. Members Present: Bernhj elm, Pearson, Porter. Wilson Members Absent: Hoyt Member Pearson and Member Wilson introduced and seconded the following: WHEREAS,the City of Farmington on behalf of its Prosecuting Attorney and Police Department desires to enter into Joint Powers Agreements with the State of Minnesota, Department of Public Safety, Bureau of Criminal Apprehension to use systems and tools available over the State's criminal justice data communications network for which the City is eligible. The Joint Powers Agreements further provide the City with the ability to add, modify and delete connectivity, systems and tools over the five year life of the agreement and obligates the City to pay the costs for the network connection. NOW, THEREFORE, BE IT RESOLVED by the Mayor and City Council of the City of Farmington, Minnesota as follows: 1. That the State of Minnesota Joint Powers Agreements by and between the State of Minnesota acting through its Department of Public Safety, Bureau of Criminal Apprehension and the City of Farmington on behalf of its Prosecuting Attorney and Police Department, are hereby approved. 2. That the Chief of Police, Gary Rutherford, or his successor, is designated the Authorized Representative for the Police Department. The Authorized Representative is also authorized to sign any subsequent amendment or agreement that may be required by the State of Minnesota to maintain the City's connection to the systems and tools offered by the State. To assist the Authorized Representative with the administration of the agreement,the Deputy Chief of Police, James Constantineau, is appointed as the Authorized Representative's designee. 3. That the City Attorney, Elliot Knetsch, or his successor, is designated the Authorized Representative for the Prosecuting Attorney. The Authorized Representative is also authorized to sign any subsequent amendment or agreement that may be required by the State of Minnesota to maintain the City's connection to the systems and tools offered by the State. To assist the Authorized Representative with the administration of the agreement, the City Administrator, David McKnight, is appointed as the Authorized Representative's designee. 4. That Joshua Hoyt, the Mayor for the City of Farmington, and David McKnight,the City Clerk, are authorized to sign the State of Minnesota Joint Powers Agreements. This resolution adopted by recorded vote of the Farmington City Council in open session on the 19th day of July 2021. ayor Attested to the 19th day of July 2021. 64Y/Administrafor (� SEAL SWIFT Contract#195893 M N 0190200 itfin State of Minnesota Joint Powers Agreement miNmeSOTA This Agreement is between the State of Minnesota,acting through its Department of Public Safety on behalf of the Bureau of Criminal Apprehension ("BCA"), and the City of Farmington of behalf of its Police Department("Governmental Unit").The BCA and the Governmental Unit may be referred to jointly as"Parties." Recitals Under Minn. Stat. §471.59, the BCA and the Governmental Unit are empowered to engage in agreements that are necessary to exercise their powers. Under Minn.Stat. § 299C.46,the BCA must provide a criminal justice data communications network to benefit political subdivisions as defined under Minn. Stat. § 299C.46,subd. 2 and subd. 2(a). The Governmental Unit is authorized by law to utilize the criminal justice data communications network pursuant to the terms set out in this Agreement. In addition, BCA either maintains repositories of data or has access to repositories of data that benefit authorized political subdivisions in performing their duties.The Governmental Unit wants to access data in support of its official duties. The purpose of this Agreement is to create a method by which the Governmental Unit has access to those systems and tools for which it has eligibility, and to memorialize the requirements to obtain access and the limitations on the access. Agreement 1 Term of Agreement 1.1 Effective Date.This Agreement is effective on the date the BCA obtains all required signatures under Minn. Stat. § 16C.05, subdivision 2. 1.2 Expiration Date.This Agreement expires five years from the date it is effective. 2 Agreement Between the Parties 2.1 General Access. BCA agrees to provide Governmental Unit with access to the Minnesota Criminal Justice Data Communications Network(CJDN) and those systems and tools which the Governmental Unit is authorized by law to access via the CJDN for the purposes outlined in Minn. Stat. § 299C.46. 2.2 Methods of Access. The BCA offers three (3) methods of access to its systems and tools. The methods of access are: A. Direct access occurs when individual users at the Governmental Unit use the Governmental Unit's equipment to access the BCA's systems and tools.This is generally accomplished by an individual user entering a query into one of BCA's systems or tools. B. Indirect Access occurs when individual users at the Governmental Unit go to another Governmental Unit to obtain data and information from RCA's systems and tools.This method of access generally results in the Governmental Unit with indirect access obtaining the needed data and information in a physical format like a paper report. C. Computer-to-Computer System Interface occurs when the Governmental Unit's computer exchanges data and information with BCA's computer systems and tools using an interface.Without limitation, interface types include: state message switch,web services,enterprise service bus and message queuing. For purposes of this Agreement,Governmental Unit employees or contractors may use any of these methods to use BCA's systems and tools as described in this Agreement.Governmental Unit will select a 1 DPS/BCA CJDN JPA—March 2021 SWIFT Contract#195893 M N 0190200 method of access and can change the methodology following the process in Clause 2.10. 2.3 Federal Systems Access. In addition, pursuant to 28 CFR§20.30-38 and Minn. Stat. §299C.58, BCA may provide Governmental Unit with access to the Federal Bureau of Investigation (FBI) National Crime Information Center. 2.4 Governmental Unit Policies. Both the BCA and the FBI's Criminal Justice Information Systems (FBI-CJIS) have policies, regulations and laws on access, use, audit, dissemination, hit confirmation, logging, quality assurance, screening (pre-employment), security,timeliness,training, use of the system, and validation. Governmental Unit has created its own policies to ensure that Governmental Unit's employees and contractors comply with all applicable requirements. Governmental Unit ensures this compliance through appropriate enforcement.These BCA and FBI-CJIS policies and regulations,as amended and updated from time to time, are incorporated into this Agreement by reference.The policies are available at https://bcanextest.x.state.mn.us/launchpad/. 2.5 Governmental Unit Resources.To assist Governmental Unit in complying with the federal and state requirements on access to and use of the various systems and tools, information is available at https:HsPs.x.state.mn.us/sites/bcaservicecatalog/defauIt.aspx.Additional information on appropriate use is found in the Minnesota Bureau of Criminal Apprehension Policy on Appropriate Use of Systems and Data available at https://bcanextest.x.state.mn.us/launchpad/c*isdocs/docs.cgi?cmd=FS&ID=795&TYPE=DOCS. 2.6 Access Granted. A. Governmental Unit is granted permission to use all current and future BCA systems and tools for which Governmental Unit is eligible. Eligibility is dependent on Governmental Unit (i) satisfying all applicable federal or state statutory requirements; (ii)complying with the terms of this Agreement; and (iii) acceptance by BCA of Governmental Unit's written request for use of a specific system or tool. B. To facilitate changes in systems and tools,Governmental Unit grants its Authorized Representative authority to make written requests for those systems and tools provided by BCA that the Governmental Unit needs to meet its criminal justice obligations and for which Governmental Unit is eligible. 2.7 Future Access. On written request from the Governmental Unit, BCA also may provide Governmental Unit with access to those systems or tools which may become available after the signing of this Agreement,to the extent that the access is authorized by applicable state and federal law. Governmental Unit agrees to be bound by the terms and conditions contained in this Agreement that when utilizing new systems or tools provided under this Agreement. 2.8 Limitations on Access. BCA agrees that it will comply with applicable state and federal laws when making information accessible. Governmental Unit agrees that it will comply with applicable state and federal laws when accessing, entering, using, disseminating, and storing data. Each party is responsible for its own compliance with the most current applicable state and federal laws. 2.9 Supersedes Prior Agreements.This Agreement supersedes any and all prior agreements between the BCA and the Governmental Unit regarding access to and use of systems and tools provided by BCA. 2.10 Requirement to Update Information.The parties agree that if there is a change to any of the information whether required by law or this Agreement,the party will send the new information to the other party in writing within 30 days of the change.This clause does not apply to changes in systems or tools provided under this Agreement. This requirement to give notice additionally applies to changes in the individual or organization serving the Governmental Unit as its prosecutor. Any change in performance of the prosecutorial function must be provided to the BCA in writing by giving notice to the Service Desk, BCA.ServiceDesk@state.mn.us. 2.11 Transaction Record.The BCA creates and maintains a transaction record for each exchange of data utilizing its systems and tools. In order to meet FBI-CJIS requirements and to perform the audits described in Clause 7,there must be a method of identifying which individual users at the Governmental Unit conducted a 2 DPS/BCA CJDN RA—March 2021 SWIFT Contract#195893 M N 0190200 particular transaction. If Governmental Unit uses either direct access as described in Clause 2.2A or indirect access as described in Clause 2.213, BCA's transaction record meets FBI-CJIS requirements. When Governmental Unit's method of access is a computer-to-computer interface as described in Clause 2.2C,the Governmental Unit must keep a transaction record sufficient to satisfy FBI-CJIS requirements and permit the audits described in Clause 7 to occur. If a Governmental Unit accesses data from the Driver and Vehicle Services Division in the Minnesota Department of Public Safety and keeps a copy of the data, Governmental Unit must have a transaction record of all subsequent access to the data that are kept by the Governmental Unit.The transaction record must include the individual user who requested access, and the date,time and content of the request.The transaction record must also include the date, time and content of the response along with the destination to which the data were sent.The transaction record must be maintained for a minimum of six(6)years from the date the transaction occurred and must be made available to the BCA within one (1) business day of the BCA's request. 2.12 Court Information Access. Certain BCA systems and tools that include access to and/or submission of Court Records may only be utilized by the Governmental Unit if the Governmental Unit completes the Court Data Services Subscriber Amendment, which upon execution will be incorporated into this Agreement by reference.These BCA systems and tools are identified in the written request made by the Governmental Unit under Clause 2.6 above.The Court Data Services Subscriber Amendment provides important additional terms, including but not limited to privacy(see Clause 8.2, below),fees (see Clause 3 below), and transaction records or logs,that govern Governmental Unit's access to and/or submission of the Court Records delivered through the BCA systems and tools. 2.13 Vendor Personnel Screening.The BCA will conduct all vendor personnel screening on behalf of Governmental Unit as is required by the FBI CAS Security Policy.The BCA will maintain records of the federal,fingerprint-based background check on each vendor employee as well as records of the completion of the security awareness training that may be relied on by the Governmental Unit. 3 Payment The Governmental Unit currently accesses the criminal justice data communications network described in Minn. Stat. §299C.46. The bills are sent quarterly for the amount of Two Hundred Seventy Dollars ($270.00) or a total annual cost of One Thousand Eighty Dollars ($1,080.00). The Governmental Unit will identify its contact person for billing purposes, and will provide updated information to BCA's Authorized Representative within ten business days when this information changes. If Governmental Unit chooses to execute the Court Data Services Subscriber Amendment referred to in Clause 2.12 in order to access and/or submit Court Records via BCA's systems, additional fees, if any, are addressed in that amendment. 4 Authorized Representatives The BCA's Authorized Representative is the person below, or her successor: Name: Dana Gotz, Deputy Superintendent Address: Minnesota Department of Public Safety; Bureau of Criminal Apprehension 1430 Maryland Avenue Saint Paul, MN 55106 3 DPS/BCA CJDN JPA—March 2021 SWIFT Contract#195893 M N 0190200 Telephone: 651.793.1007 Email Address: Dana.Gotz@state.mn.us The Governmental Unit's Authorized Representative is the person below, or his/her successor: Name: Gary Rutherford, Chief Address: 19500 Municipal Dr Farmington, MN 55027 Telephone: 651.280.6700 Email Address: grutherford@farmingtommn.gov 5 Assignment,Amendments,Waiver,and Agreement Complete 5.1 Assignment. Neither party may assign nor transfer any rights or obligations under this Agreement. 5.2 Amendments.Any amendment to this Agreement, except those described in Clauses 2.6 and 2.7 above must be in writing and will not be effective until it has been signed and approved by the same parties who signed and approved the original agreement,their successors in office, or another individual duly authorized. 5.3 Waiver. If either party fails to enforce any provision of this Agreement,that failure does not waive the provision or the right to enforce it. 5.4 Agreement Complete.This Agreement contains all negotiations and agreements between the BCA and the Governmental Unit. No other understanding regarding this Agreement,whether written or oral, may be used to bind either party. 6 Liability Each party will be responsible for its own acts and behavior and the results thereof and shall not be responsible or liable for the other party's actions and consequences of those actions.The Minnesota Torts Claims Act, Minn.Stat. § 3.736 and other applicable laws govern the BCA's liability.The Minnesota Municipal Tort Claims Act, Minn.Stat. Ch.466 and other applicable laws,governs the Governmental Unit's liability. 7 Audits 7.1 Under Minn. Stat. § 16C.05, subd. 5,the Governmental Unit's books, records, documents, internal policies and accounting procedures and practices relevant to this Agreement are subject to examination by the BCA, the State Auditor or Legislative Auditor, as appropriate, for a minimum of six years from the end of this Agreement. Under Minn. Stat. § 6.551,the State Auditor may examine the books, records, documents, and accounting procedures and practices of BCA. The examination shall be limited to the books, records, documents, and accounting procedures and practices that are relevant to this Agreement. 7.2 Under applicable state and federal law,the Governmental Unit's records are subject to examination by the BCA to ensure compliance with laws, regulations and policies about access, use,and dissemination of data. 7.3 If the Governmental Unit accesses federal databases,the Governmental Unit's records are subject to examination by the FBI and BCA; the Governmental Unit will cooperate with FBI and BCA auditors and make any requested data available for review and audit. 7.4 If the Governmental Unit accesses state databases,the Governmental Unit's records are subject to examination by the BCA:the Governmental Unit will cooperate with the BCA auditors and make any requested data available for review and audit. 7.5 To facilitate the audits required by state and federal law, Governmental Unit is required to have an inventory of the equipment used to access the data covered by this Agreement and the physical location of each. 4 DPS/BCA CJDN JPA—March 2021 SWIFT Contract#195893 MN0190200 8 Government Data Practices 8.1 BCA and Governmental Unit.The Governmental Unit and BCA must comply with the Minnesota Government Data Practices Act, Minn. Stat. Ch. 13, as it applies to all data accessible under this Agreement, and as it applies to all data created, collected, received, stored, used, maintained, or disseminated by the Governmental Unit under this Agreement.The remedies of Minn.Stat. §§ 13.08 and 13.09 apply to the release of the data referred to in this clause by either the Governmental Unit or the BCA. 8.2 Court Records. If Governmental Unit chooses to execute the Court Data Services Subscriber Amendment referred to in Clause 2.12 in order to access and/or submit Court Records via BCA's systems,the following provisions regarding data practices also apply. The Court is not subject to Minn.Stat. Ch. 13 but is subject to the Rules of Public Access to Records of the Judicial Branch promulgated by the Minnesota Supreme Court. All parties acknowledge and agree that Minn.Stat. § 13.03, subdivision 4(e) requires that the BCA and the Governmental Unit comply with the Rules of Public Access for those data received from Court under the Court Data Services Subscriber Amendment. All parties also acknowledge and agree that the use of, access to or submission of Court Records, as that term is defined in the Court Data Services Subscriber Amendment, may be restricted by rules promulgated by the Minnesota Supreme Court, applicable state statute or federal law. All parties acknowledge and agree that these applicable restrictions must be followed in the appropriate circumstances. 9 Investigation of Alleged Violations;Sanctions For purposes of this clause, "Individual User" means an employee or contractor of Governmental Unit. 9.1 Investigation.The Governmental Unit and BCA agree to cooperate in the investigation and possible prosecution of suspected violations of federal and state law referenced in this Agreement. Governmental Unit and BCA agree to cooperate in the investigation of suspected violations of the policies and procedures referenced in this Agreement. When BCA becomes aware that a violation may have occurred, BCA will inform Governmental Unit of the suspected violation, subject to any restrictions in applicable law.When Governmental Unit becomes aware that a violation has occurred, Governmental Unit will inform BCA subject to any restrictions in applicable law. 9.2 Sanctions Involving Only BCA Systems and Tools. The following provisions apply to BCA systems and tools not covered by the Court Data Services Subscriber Amendment. None of these provisions alter the Governmental Unit internal discipline processes, including those governed by a collective bargaining agreement. 9.2.1 For BCA systems and tools that are not covered by the Court Data Services Subscriber Amendment, Governmental Unit must determine if and when an involved Individual User's access to systems or tools is to be temporarily or permanently eliminated.The decision to suspend or terminate access may be made as soon as alleged violation is discovered, after notice of an alleged violation is received,or after an investigation has occurred. Governmental Unit must report the status of the Individual User's access to BCA without delay. BCA reserves the right to make a different determination concerning an Individual User's access to systems or tools than that made by Governmental Unit and BCA's determination controls. 9.2.2 If BCA determines that Governmental Unit has jeopardized the integrity of the systems or tools covered in this Clause 9.2, BCA may temporarily stop providing some or all the systems or tools under this Agreement until the failure is remedied to the BCA's satisfaction. If Governmental Unit's failure is continuing or repeated, Clause 11.1 does not apply and BCA may terminate this Agreement immediately. 9.3 Sanctions Involving Only Court Data Services The following provisions apply to those systems and tools covered by the Court Data Services Subscriber Amendment, if it has been signed by Governmental Unit.As part of the agreement between the Court and 5 DPS/BCA CJDN RA—March 2021 SWIFT Contract#195893 M N0190200 the BCA for the delivery of the systems and tools that are covered by the Court Data Services Subscriber Amendment, BCA is required to suspend or terminate access to or use of the systems and tools either on its own initiative or when directed by the Court.The decision to suspend or terminate access may be made as soon as an alleged violation is discovered, after notice of an alleged violation is received, or after an investigation has occurred.The decision to suspend or terminate may also be made based on a request from the Authorized Representative of Governmental Unit.The agreement further provides that only the Court has the authority to reinstate access and use. 9.3.1 Governmental Unit understands that if it has signed the Court Data Services Subscriber Amendment and if Governmental Unit's Individual Users violate the provisions of that Amendment, access and use will be suspended by BCA or Court. Governmental Unit also understands that reinstatement is only at the direction of the Court. 9.3.2 Governmental Unit further agrees that if Governmental Unit believes that one or more of its Individual Users have violated the terms of the Amendment, it will notify BCA and Court so that an investigation as described in Clause 9.1 may occur. 10 Venue Venue for all legal proceedings involving this Agreement, or its breach, must be in the appropriate state or federal court with competent jurisdiction in Ramsey County, Minnesota. 11 Termination 11.1 Termination.The BCA or the Governmental Unit may terminate this Agreement at any time,with or without cause, upon 30 days' written notice to the other party's Authorized Representative. 11.2 Termination for Insufficient Funding. Either party may immediately terminate this Agreement if it does not obtain funding from the Minnesota Legislature, or other funding source; or if funding cannot be continued at a level sufficient to allow for the payment of the services covered here.Termination must be by written notice to the other party's authorized representative.The Governmental Unit is not obligated to pay for any services that are provided after notice and effective date of termination. However,the BCA will be entitled to payment, determined on a pro rata basis,for services satisfactorily performed to the extent that funds are available. Neither party will be assessed any penalty if the agreement is terminated because of the decision of the Minnesota Legislature, or other funding source, not to appropriate funds. Notice of the lack of funding must be provided within a reasonable time of the affected party receiving that notice. 12 Continuing Obligations The following clauses survive the expiration or cancellation of this Agreement: Liability; Audits; Government Data Practices; 9. Investigation of Alleged Violations; Sanctions; and Venue. THE BALANCE OF THIS PAGE INTENTIONALLY LEFT BLANK 6 DPS/BCA CJDN JPA—March 2021 SWIFT Contract#195893 MN0190200 The Parties indicate their agreement and authority to execute this Agreement by signing below. 1. GOVERNMENTAL UNIT 2. DEPARTMENT OF PUBLIC SAFETY,BUREAU OF CRIMINAL APPREHENSION Name: \L Name: (OilPRINTE • (PRINTED) Signed: Signed: • a Title: •� d nd Title: (with dele ted authority) (with delegated authority) Date: ` • Date: 3. COMMISSIONER OF ADMINISTRATION a� As delegated to the Office of State Procurement Name: V (PRINTED) By: Date: Signed: � Title: ��'l► ��/K/`�fet �— (with delegated authority) Date: 7 DPS/BCA CJDN JPA—March 2021 COURT DATA SERVICES SUBSCRIBER AMENDMENT TO CJDN SUBSCRIBER AGREEMENT This Court Data Services Subscriber Amendment ("Subscriber Amendment") is entered into by the State of Minnesota, acting through its Department of Public Safety, Bureau of Criminal Apprehension, ("BCA") and the City of Farmington on behalf of its Police Department ("Agency"), and by and for the benefit of the State of Minnesota acting through its State Court Administrator's Office ("Court") who shall be entitled to enforce any provisions hereof through any legal action against any party. Recitals This Subscriber Amendment modifies and supplements the Agreement between the BCA and Agency, SWIFT Contract number 195893, of even or prior date, for Agency use of BCA systems and tools (referred to herein as "the CJDN Subscriber Agreement"). Certain BCA systems and tools that include access to and/or submission of Court Records may only be utilized by the Agency if the Agency completes this Subscriber Amendment. The Agency desires to use one or more BCA systems and tools to access and/or submit Court Records to assist the Agency in the efficient performance of its duties as required or authorized by law or court rule. Court desires to permit such access and/or submission. This Subscriber Amendment is intended to add Court as a party to the CJDN Subscriber Agreement and to create obligations by the Agency to the Court that can be enforced by the Court. It is also understood that, pursuant to the Master Joint Powers Agreement for Delivery of Court Data Services to CJDN Subscribers ("Master Authorization Agreement") between the Court and the BCA, the BCA is authorized to sign this Subscriber Amendment on behalf of Court. Upon execution the Subscriber Amendment will be incorporated into the CJDN Subscriber Agreement by reference. The BCA, the Agency and the Court desire to amend the CJDN Subscriber Agreement as stated below. The CJDN Subscriber Agreement is amended by the addition of the following provisions: 1. TERM; TERMINATION; ONGOING OBLIGATIONS. This Subscriber Amendment shall be effective on the date finally executed by all parties and shall remain in effect until expiration or termination of the CJDN Subscriber Agreement unless terminated earlier as provided in this Subscriber Amendment. Any party may terminate this Subscriber Amendment with or without cause by giving written notice to all other parties. The effective date of the termination shall be thirty days after the other party's receipt of the notice of termination, unless a later date is specified in the notice. The provisions of sections 5 through 9, 12.b., 12.c., and 15 through 24 shall survive any termination of this Subscriber Amendment as shall any other provisions which by their nature are intended or expected to survive such termination. Upon termination,the Subscriber shall perform the responsibilities set forth in paragraph 7(f) hereof. 2. Definitions. Unless otherwise specifically defined, each term used herein shall have the meaning assigned to such term in the CJDN Subscriber Agreement. 1 a. "Authorized Court Data Services" means Court Data Services that have been authorized for delivery to CJDN Subscribers via BCA systems and tools pursuant to an Authorization Amendment to the Joint Powers Agreement for Delivery of Court Data Services to CJDN Subscribers ("Master Authorization Agreement") between the Court and the BCA. b. "Court Data Services" means one or more of the services set forth on the Justice Agency Resource webpage of the Minnesota Judicial Branch website (for which the current address is www.courts.state.mn.us) or other location designated by the Court, as the same may be amended from time to time by the Court. C. "Court Records" means all information in any form made available by the Court to Subscriber through the BCA for the purposes of carrying out this Subscriber Amendment, including: i. "Court Case Information" means any information in the Court Records that conveys information about a particular case or controversy, including without limitation Court Confidential Case Information, as defined herein. ii. "Court Confidential Case Information" means any information in the Court Records that is inaccessible to the public pursuant to the Rules of Public Access and that conveys information about a particular case or controversy. iii. "Court Confidential Security and Activation Information" means any information in the Court Records that is inaccessible to the public pursuant to the Rules of Public Access and that explains how to use or gain access to Court Data Services, including but not limited to login account names, passwords, TCP/IP addresses, Court Data Services user manuals, Court Data Services Programs, Court Data Services Databases, and other technical information. iv. "Court Confidential Information" means any information in the Court Records that is inaccessible to the public pursuant to the Rules of Public Access, including without limitation both i) Court Confidential Case Information; and ii) Court Confidential Security and Activation Information. d. "DCA" shall mean the district courts of the state of Minnesota and their respective staff. e. "Policies & Notices" means the policies and notices published by the Court in connection with each of its Court Data Services, on a website or other location designated by the Court, as the same may be amended from time to time by the Court. Policies & Notices for each Authorized Court Data Service identified in an approved request form under section 3, below, are hereby made part of this Subscriber Amendment by this reference and provide additional terms and conditions that govern Subscriber's use of Court Records accessed through such services, including but not limited to provisions on access and use limitations. 2 f. "Rules of Public Access" means the Rules of Public Access to Records of the Judicial Branch promulgated by the Minnesota Supreme Court, as the same may be amended from time to time, including without limitation lists or tables published from time to time by the Court entitled Limits on Public Access to Case Records or Limits on Public Access to Administrative Records, all of which by this reference are made a part of this Subscriber Amendment. It is the obligation of Subscriber to check from time to time for updated rules, lists, and tables and be familiar with the contents thereof. It is contemplated that such rules, lists, and tables will be posted on the Minnesota Judicial Branch website, for which the current address is www.courts.state.mn.us. g. "Court" shall mean the State of Minnesota, State Court Administrator's Office. h. "Subscriber" shall mean the Agency. i. "Subscriber Records" means any information in any form made available by the Subscriber to the Court for the purposes of carrying out this Subscriber Amendment. 3. REQUESTS FOR AUTHORIZED COURT DATA SERVICES. Following execution of this Subscriber Amendment by all parties, Subscriber may submit to the BCA one or more separate requests for Authorized Court Data Services. The BCA is authorized in the Master Authorization Agreement to process, credential and approve such requests on behalf of Court and all such requests approved by the BCA are adopted and incorporated herein by this reference the same as if set forth verbatim herein. a. Activation. Activation of the requested Authorized Court Data Service(s) shall occur promptly following approval. b. Rejection. Requests may be rejected for any reason, at the discretion of the BCA and/or the Court. C. Requests for Termination of One or More Authorized Court Data Services. The Subscriber may request the termination of an Authorized Court Data Services previously requested by submitting a notice to Court with a copy to the BCA. Promptly upon receipt of a request for termination of an Authorized Court Data Service, the BCA will deactivate the service requested. The termination of one or more Authorized Court Data Services does not terminate this Subscriber Amendment. Provisions for termination of this Subscriber Amendment are set forth in section 1. Upon termination of Authorized Court Data Services, the Subscriber shall perform the responsibilities set forth in paragraph 7(f) hereof. 4. SCOPE OF ACCESS TO COURT RECORDS LIMITED. Subscriber's access to and/or submission of the Court Records shall be limited to Authorized Court Data Services identified in an approved request form under section 3, above, and other Court Records necessary for Subscriber to use Authorized Court Data Services. Authorized Court Data Services shall only be used according to the instructions provided in corresponding Policies & Notices or other materials and only as necessary to assist Subscriber in the efficient performance of Subscriber's duties 3 required or authorized by law or court rule in connection with any civil, criminal, administrative, or arbitral proceeding in any Federal, State, or local court or agency or before any self-regulatory body. Subscriber's access to the Court Records for personal or non-official use is prohibited. Subscriber will not use or attempt to use Authorized Court Data Services in any manner not set forth in this Subscriber Amendment, Policies & Notices, or other Authorized Court Data Services documentation, and upon any such unauthorized use or attempted use the Court may immediately terminate this Subscriber Amendment without prior notice to Subscriber. 5. GUARANTEES OF CONFIDENTIALITY. Subscriber agrees: a. To not disclose Court Confidential Information to any third party except where necessary to carry out the Subscriber's duties as required or authorized by law or court rule in connection with any civil, criminal, administrative, or arbitral proceeding in any Federal, State, or local court or agency or before any self-regulatory body. b. To take all appropriate action, whether by instruction, agreement, or otherwise, to insure the protection, confidentiality and security of Court Confidential Information and to satisfy Subscriber's obligations under this Subscriber Amendment. C. To limit the use of and access to Court Confidential Information to Subscriber's bona fide personnel whose use or access is necessary to effect the purposes of this Subscriber Amendment, and to advise each individual who is permitted use of and/or access to any Court Confidential Information of the restrictions upon disclosure and use contained in this Subscriber Amendment, requiring each individual who is permitted use of and/or access to Court Confidential Information to acknowledge in writing that the individual has read and understands such restrictions. Subscriber shall keep such acknowledgements on file for one year following termination of the Subscriber Amendment and/or CJDN Subscriber Agreement, whichever is longer, and shall provide the Court with access to, and copies of, such acknowledgements upon request. For purposes of this Subscriber Amendment, Subscriber's bona fide personnel shall mean individuals who are employees of Subscriber or provide services to Subscriber either on a voluntary basis or as independent contractors with Subscriber. d. That, without limiting section 1 of this Subscriber Amendment, the obligations of Subscriber and its bona fide personnel with respect to the confidentiality and security of Court Confidential Information shall survive the termination of this Subscriber Amendment and the CJDN Subscriber Agreement and the termination of their relationship with Subscriber. e. That, notwithstanding any federal or state law applicable to the nondisclosure obligations of Subscriber and Subscriber's bona fide personnel under this Subscriber Amendment, such obligations of Subscriber and Subscriber's bona fide personnel are founded independently on the provisions of this Subscriber Amendment. 6. APPLICABILITY TO PREVIOUSLY DISCLOSED COURT RECORDS. Subscriber acknowledges and agrees that all Authorized Court Data Services and related Court Records disclosed to Subscriber prior to the effective date of this Subscriber Amendment shall be subject to the provisions of this Subscriber Amendment. 4 7. LICENSE AND PROTECTION OF PROPRIETARY RIGHTS. During the term of this Subscriber Amendment, subject to the terms and conditions hereof, the Court hereby grants to Subscriber a nonexclusive, nontransferable, limited license to use Court Data Services Programs and Court Data Services Databases to access or receive the Authorized Court Data Services identified in an approved request form under section 3, above, and related Court Records. Court reserves the right to make modifications to the Authorized Court Data Services, Court Data Services Programs, and Court Data Services Databases, and related materials without notice to Subscriber. These modifications shall be treated in all respects as their previous counterparts. a. Court Data Services Programs. Court is the copyright owner and licensor of the Court Data Services Programs. The combination of ideas, procedures, processes, systems, logic, coherence and methods of operation embodied within the Court Data Services Programs, and all information contained in documentation pertaining to the Court Data Services Programs, including but not limited to manuals, user documentation, and passwords, are trade secret information of Court and its licensors. b. Court Data Services Databases. Court is the copyright owner and licensor of the Court Data Services Databases and of all copyrightable aspects and components thereof. All specifications and information pertaining to the Court Data Services Databases and their structure, sequence and organization, including without limitation data schemas such as the Court XML Schema, are trade secret information of Court and its licensors. C. Marks. Subscriber shall neither have nor claim any right, title, or interest in or use of any trademark used in connection with Authorized Court Data Services, including but not limited to the marks "MNCIS" and"Odyssey." d. Restrictions on Duplication, Disclosure, and Use. Trade secret information of Court and its licensors will be treated by Subscriber in the same manner as Court Confidential Information. In addition, Subscriber will not copy any part of the Court Data Services Programs or Court Data Services Databases, or reverse engineer or otherwise attempt to discern the source code of the Court Data Services Programs or Court Data Services Databases, or use any trademark of Court or its licensors, in any way or for any purpose not specifically and expressly authorized by this Subscriber Amendment. As used herein, "trade secret information of Court and its licensors" means any information possessed by Court which derives independent economic value from not being generally known to, and not being readily ascertainable by proper means by, other persons who can obtain economic value from its disclosure or use. "Trade secret information of Court and its licensors" does not, however, include information which was known to Subscriber prior to Subscriber's receipt thereof, either directly or indirectly, from Court or its licensors, information which is independently developed by Subscriber without reference to or use of information received from Court or its licensors, or information which would not qualify as a trade secret under Minnesota law. It will not be a violation of this section 7, sub-section d, for Subscriber to make up to one copy of training materials and configuration documentation, if any, for each individual authorized to access, use, or configure Authorized Court Data Services, solely for its own use in connection with this Subscriber Amendment. Subscriber will take all steps reasonably necessary to protect the copyright, trade secret, and trademark rights of Court and its licensors and Subscriber will advise its bona fide personnel who are permitted access to any of the Court Data Services Programs and Court Data Services Databases, and trade secret information of Court and its licensors, of the restrictions upon duplication, disclosure and use contained in this Subscriber Amendment. 5 e. Proprietary Notices. Subscriber will not remove any copyright or proprietary notices included in and/or on the Court Data Services Programs or Court Data Services Databases, related documentation, or trade secret information of Court and its licensors, or any part thereof, made available by Court directly or through the BCA, if any, and Subscriber will include in and/or on any copy of the Court Data Services Programs or Court Data Services Databases, or trade secret information of Court and its licensors and any documents pertaining thereto, the same copyright and other proprietary notices as appear on the copies made available to Subscriber by Court directly or through the BCA, except that copyright notices shall be updated and other proprietary notices added as may be appropriate. f. Title; Return. The Court Data Services Programs and Court Data Services Databases, and related documentation, including but not limited to training and configuration material, if any, and logon account information and passwords, if any, made available by the Court to Subscriber directly or through the BCA and all copies, including partial copies, thereof are and remain the property of the respective licensor. Except as expressly provided in section 12.b., within ten days of the effective date of termination of this Subscriber Amendment or the CJDN Subscriber Agreement or within ten days of a request for termination of Authorized Court Data Service as described in section 4, Subscriber shall either: (i) uninstall and return any and all copies of the applicable Court Data Services Programs and Court Data Services Databases, and related documentation, including but not limited to training and configuration materials, if any, and logon account information, if any; or (2) destroy the same and certify in writing to the Court that the same have been destroyed. 8. INJUNCTIVE RELIEF. Subscriber acknowledges that the Court, Court's licensors, and DCA will be irreparably harmed if Subscriber's obligations under this Subscriber Amendment are not specifically enforced and that the Court, Court's licensors, and DCA would not have an adequate remedy at law in the event of an actual or threatened violation by Subscriber of its obligations. Therefore, Subscriber agrees that the Court, Court's licensors, and DCA shall be entitled to an injunction or any appropriate decree of specific performance for any actual or threatened violations or breaches by Subscriber or its bona fide personnel without the necessity of the Court, Court's licensors, or DCA showing actual damages or that monetary damages would not afford an adequate remedy. Unless Subscriber is an office, officer, agency, department, division, or bureau of the state of Minnesota, Subscriber shall be liable to the Court, Court's licensors, and DCA for reasonable attorneys fees incurred by the Court, Court's licensors, and DCA in obtaining any relief pursuant to this Subscriber Amendment. 9. LIABILITY. Subscriber and the Court agree that, except as otherwise expressly provided herein, each party will be responsible for its own acts and the results thereof to the extent authorized by law and shall not be responsible for the acts of any others and the results thereof. Liability shall be governed by applicable law. Without limiting the foregoing, liability of the Court and any Subscriber that is an office, officer, agency, department, division, or bureau of the state of Minnesota shall be governed by the provisions of the Minnesota Tort Claims Act, Minnesota Statutes, section 3.376, and other applicable law. Without limiting the foregoing, if Subscriber is a political subdivision of the state of Minnesota, liability of the Subscriber shall be governed by the provisions of Minn. Stat. Ch. 466 (Tort Liability, Political Subdivisions) or other applicable law. Subscriber and Court further acknowledge that the liability, if any, of the BCA is governed by a separate agreement between the Court and the BCA dated December 13, 2010 with DPS-M -0958. 6 10. AVAILABILITY. Specific terms of availability shall be established by the Court and communicated to Subscriber by the Court and/or the BCA. The Court reserves the right to terminate this Subscriber Amendment immediately and/or temporarily suspend Subscriber's Authorized Court Data Services in the event the capacity of any host computer system or legislative appropriation of funds is determined solely by the Court to be insufficient to meet the computer needs of the courts served by the host computer system. 11. [reserved] 12. ADDITIONAL USER OBLIGATIONS. The obligations of the Subscriber set forth in this section are in addition to the other obligations of the Subscriber set forth elsewhere in this Subscriber Amendment. a. Judicial Policy Statement. Subscriber agrees to comply with all policies identified in Policies & Notices applicable to Court Records accessed by Subscriber using Authorized Court Data Services. Upon failure of the Subscriber to comply with such policies, the Court shall have the option of immediately suspending the Subscriber's Authorized Court Data Services on a temporary basis and/or immediately terminating this Subscriber Amendment. b. Access and Use; Log. Subscriber shall be responsible for all access to and use of Authorized Court Data Services and Court Records by Subscriber's bona fide personnel or by means of Subscriber's equipment or passwords, whether or not Subscriber has knowledge of or authorizes such access and use. Subscriber shall also maintain a log identifying all persons to whom Subscriber has disclosed its Court Confidential Security and Activation Information, such as user ID(s) and password(s), including the date of such disclosure. Subscriber shall maintain such logs for a minimum period of six years from the date of disclosure, and shall provide the Court with access to, and copies of, such logs upon request. The Court may conduct audits of Subscriber's logs and use of Authorized Court Data Services and Court Records from time to time. Upon Subscriber's failure to maintain such logs, to maintain accurate logs, or to promptly provide access by the Court to such logs, the Court may terminate this Subscriber Amendment without prior notice to Subscriber. C. Personnel. Subscriber agrees to investigate, at the request of the Court and/or the BCA, allegations of misconduct pertaining to Subscriber's bona fide personnel having access to or use of Authorized Court Data Services, Court Confidential Information, or trade secret information of the Court and its licensors where such persons are alleged to have violated the provisions of this Subscriber Amendment, Policies & Notices, Judicial Branch policies, or other security requirements or laws regulating access to the Court Records. d. Minnesota Data Practices Act Applicability. If Subscriber is a Minnesota Government entity that is subject to the Minnesota Government Data Practices Act, Minn. Stat. Ch. 13, Subscriber acknowledges and agrees that: (1) the Court is not subject to Minn. Stat. Ch. 13 (see section 13.90) but is subject to the Rules of Public Access and other rules promulgated by the Minnesota Supreme Court; (2) Minn. Stat. section 13.03, subdivision 4(e) requires that Subscriber comply with the Rules of Public Access and other rules promulgated by the Minnesota Supreme Court for access to Court Records provided via the 7 BCA systems and tools under this Subscriber Amendment; (3)the use of and access to Court Records may be restricted by rules promulgated by the Minnesota Supreme Court, applicable state statute or federal law; and (4) these applicable restrictions must be followed in the appropriate circumstances. 13. FEES; INVOICES. Unless the Subscriber is an office, officer, department, division, agency, or bureau of the state of Minnesota, Subscriber shall pay the fees, if any, set forth in applicable Policies & Notices, together with applicable sales, use or other taxes. Applicable monthly fees commence ten(10) days after notice of approval of the request pursuant to section 3 of this Subscriber Amendment or upon the initial Subscriber transaction as defined in the Policies & Notices, whichever occurs earlier. When fees apply, the Court shall invoice Subscriber on a monthly basis for charges incurred in the preceding month and applicable taxes, if any, and payment of all amounts shall be due upon receipt of invoice. If all amounts are not paid within 30 days of the date of the invoice, the Court may immediately cancel this Subscriber Amendment without notice to Subscriber and pursue all available legal remedies. Subscriber certifies that funds have been appropriated for the payment of charges under this Subscriber Amendment for the current fiscal year, if applicable. 14. MODIFICATION OF FEES. Court may modify the fees by amending the Policies & Notices as provided herein, and the modified fees shall be effective on the date specified in the Policies & Notices, which shall not be less than thirty days from the publication of the Policies & Notices. Subscriber shall have the option of accepting such changes or terminating this Subscriber Amendment as provided in section 1 hereof. 15. WARRANTY DISCLAIMERS. a. WARRANTY EXCLUSIONS. EXCEPT AS SPECIFICALLY AND EXPRESSLY PROVIDED HEREIN, COURT, COURT'S LICENSORS, AND DCA MAKE NO REPRESENTATIONS OR WARRANTIES OF ANY KIND, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF FITNESS FOR A PARTICULAR PURPOSE OR MERCHANTABILITY, NOR ARE ANY WARRANTIES TO BE IMPLIED, WITH RESPECT TO THE INFORMATION, SERVICES OR COMPUTER PROGRAMS MADE AVAILABLE UNDER THIS AGREEMENT. b. ACCURACY AND COMPLETENESS OF INFORMATION. WITHOUT LIMITING THE GENERALITY OF THE PRECEDING PARAGRAPH, COURT, COURT'S LICENSORS, AND DCA MAKE NO WARRANTIES AS TO THE ACCURACY OR COMPLETENESS OF THE INFORMATION CONTAINED IN THE COURT RECORDS. 16. RELATIONSHIP OF THE PARTIES. Subscriber is an independent contractor and shall not be deemed for any purpose to be an employee, partner, agent or franchisee of the Court, Court's licensors, or DCA. Neither Subscriber nor the Court, Court's licensors, or DCA shall have the right nor the authority to assume, create or incur any liability or obligation of any kind, express or implied, against or in the name of or on behalf of the other. 17. NOTICE. Except as provided in section 2 regarding notices of or modifications to Authorized Court Data Services and Policies &Notices, any notice to Court or Subscriber 8 hereunder shall be deemed to have been received when personally delivered in writing or seventy- two (72) hours after it has been deposited in the United States mail, first class, proper postage prepaid, addressed to the party to whom it is intended at the address set forth on page one of this Agreement or.at such other address of which notice has been given in accordance herewith. 18. NON-WAIVER. The failure by any party at any time to enforce any of the provisions of this Subscriber Amendment or any right or remedy available hereunder or at law or in equity, or to exercise any option herein provided, shall not constitute a waiver of such provision, remedy or option or in any way affect the validity of this Subscriber Amendment. The waiver of any default by either Party shall not be deemed a continuing waiver, but shall apply solely to the instance to which such waiver is directed. 19. FORCE MAJEURE. Neither Subscriber nor Court shall be responsible for failure or delay in the performance of their respective obligations hereunder caused by acts beyond their reasonable control. 20. SEVERABILITY. Every provision of this Subscriber Amendment shall be construed, to the extent possible, so as to be valid and enforceable. If any provision of this Subscriber Amendment so construed is held by a court of competent jurisdiction to be invalid, illegal or otherwise unenforceable, such provision shall be deemed severed from this Subscriber Amendment, and all other provisions shall remain in full force and effect. 21. ASSIGNMENT AND BINDING EFFECT. Except as otherwise expressly permitted herein, neither Subscriber nor Court may assign, delegate and/or otherwise transfer this Subscriber Amendment or any of its rights or obligations hereunder without the prior written consent of the other. This Subscriber Amendment shall be binding upon and inure to the benefit of the Parties hereto and their respective successors and assigns, including any other legal entity into, by or with which Subscriber may be merged, acquired or consolidated. 22. GOVERNING LAW. This Subscriber Amendment shall in all respects be governed by and interpreted, construed and enforced in accordance with the laws of the United States and of the State of Minnesota. 23. VENUE AND JURISDICTION. Any action arising out of or relating to this Subscriber Amendment, its performance, enforcement or breach will be venued in a state or federal court situated within the State of Minnesota. Subscriber hereby irrevocably consents and submits itself to the personal jurisdiction of said courts for that purpose. 24. INTEGRATION. This Subscriber Amendment contains all negotiations and agreements between the parties. No other understanding regarding this Subscriber Amendment, whether written or oral, may be used to bind either party, provided that all terms and conditions of the CJDN Subscriber Agreement and all previous amendments remain in full force and effect except as supplemented or modified by this Subscriber Amendment. IN WITNESS WHEREOF, the Parties have, by their duly authorized officers, executed this Subscriber Amendment in duplicate, intending to be bound thereby. 9 1. SUBSCRIBER(AGENCY) 2. DEPARTMENT OF PUBLIC SAFETY, BUREAU OF CRIMINAL APPREHENSION Subscriber must attach written verification of authority to sign on behalf of and bind the entity, Name: such as an opinion of counsel or resolution. (PRINTED) Name: Q ' Signed: (PRINTED) Signed: �- Title: (with delegated authority) Title: 0 G Date: (with de gaatted authority) Date: -1' 3. COMMISSIONER OF ADMINISTRATION delegated to Materials Management Division By: Date: (PRINTED) Signed: 4. COURTS �( � Authority granted to Bureau of Criminal Apprehension Title: �� /T�l'1 Y4 f L (with delegated authority) Name: (PRINTED) Date: ac a Signed: Title: (with authorized authority) Date: 10 CITY 4F O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-280-6800 VIII I�� Y Farmington MN.gov TO: Mayor, Councilmembers and City Administrator FROM: Matt Decur, Assistant City Engineer SUBJECT: Approve a Contract for the 2021 Pavement Rejuvenation Project-Public Works DATE: July 19, 2021 INTRODUCTION As discussed with the April 2021 approval of the South Metro Pavement Maintenance JPA, the City has begun to transition away from traditional pavement seal coating to new techniques to extend pavement life. A number of cities around the metro have started using Reclamite, a pavement rejuvenator, as one of their pavement management strategies. Reclamite is a Maltene based pavement rejuvenator that is applied to newer pavement surfaces and restores the pavement's durability and flexibility lost during construction. Reclamite was developed over 50 years ago and has proven to add 5 to 7 years to the service life of pavements. DISCUSSION As part of our pavement maintenance strategies, 4.7 miles of streets have been selected to be applied with a pavement rejuvenator and are highlighted on the attached map. The cost of rejuvenation is slightly less than chip sealing so a similar mileage of roads can be maintained annually. Reclamite is only manufactured by Golden Bear Oil Specialties, and only licensed for application to one contractor(Corrective Asphalt Materials) in the upper midwest. Corrective Asphalt Materials has applied Reclamite for over thirty years, and successfully applied Reclamite in several Minnesota cities, including Lakeville, Richfield, St. Michael and Lino Lakes,for several years. Plans and specs for the pavement rejuvenation project were distributed to contractors, advertised on June 2, 2021, and quotes were accepted until June 28, 2021. One quote was received from Corrective Asphalt Materials in the amount of$82,560.00 BUDGET IMPACT The Corrective Asphalt Materials LLC contract for pavement rejuvenation will be funded through the seal coating fund. ACTION REQUESTED Approve a contract with Corrective Asphalt Materials, LLC in the amount of$82,560.00. ATTACHMENTS: Type Description a Backup Material 2021 Farmington Pavement Rejuvenation FARMINGTON 2021 Pavement Rejuvenation i z ' .......... I --4 Legend �. I Develop—Project ■ rr ■ " Sunrise Regatta Nicolai Westview Reclaimed Milled N 0 0.4 0.8 1 .6 2.4 3.2 Miles Date: 5/18/2021 This drawing is neither a legally recorded map nor a survey and is not intended to be used as one. This drawing is a compilation of records, information,and data located in various city,county,and state offices and other sources and is to be used for reference purposes only. The city of Farmington is not responsible for any inaccuracies herein contained. FORM OF AGREEMENT BETWEEN CITY OF FARMINGTON AND CORRECTIVE ASPHALT MATERIALS,LLC FOR NON-BID CONSTRUCTION CONTRACT THIS AGREEMENT made this /' day of July, 2021, by and between the CITY OF FARMINGTON, a Minnesota municipal corporation ("Owner" or"City") and CORRECTIVE ASPHALT MATERIALS,LLC,an Illinois Limited Liability Company("Contractor"). Owner and Contractor, in consideration of the mutual covenants set forth herein, agree as follows: 1. CONTRACT DOCUMENTS. The following documents shall be referred to as the "Contract Documents", all of which shall be taken together as a whole as the contract between the parties as if they were set verbatim and in full herein: A. This Agreement B. Project Specifications and Maps C. Contractor's Quote In the event of a 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"C" having the last priority. 2. OBLIGATIONS OF THE CONTRACTOR. The Contractor shall provide the goods,services, and perform the work in accordance with the Contract Documents. 3. CONTRACT PRICE. Owner shall pay Contractor for completion of the Work,in accordance with the Contract,$82,560.00 inclusive of taxes, if any. 4. PAYMENT PROCEDURES. A. Contractor shall submit an Invoice upon completion of the work. Invoices will be processed by the City Engineer. B. Payments to Subcontractors. (1) Prompt Payment to Subcontractors. Pursuant to Minn. Stat. §471.25, Subd.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 1% percent per month or any part of a month to the 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. D. Final Payment. Due to the small scope and short duration of this project, only one payment will be made upon completion of the project as recommended by the City Engineer. S. COMPLETION DATE. The Work must be completed by October 31, 2021. 6. CONTRACTOR'S REPRESENTATIONS. A. Contractor has examined and carefully studied the Contract Docurnents.anrl other related data identified in the Contract Documents, B. Contractor has visited the Site and become familiar with and is satisfied as to the general, local, and Site conditions that may affect cost, progress,and performance of the Work. C. Contractor is familiar with and is satisfied as to all federal,state, and local laws and regulations that may affect cost, progress,and performance of the Work. D. The Contract Documents are generally sufficient to indicate and convey understanding of all terms and conditions for performance and furnishing of the Work. 7. WORKER'S COMPENSATION. 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. 8. COMPREHENSIVE GENERAL LIABILITY. Contractor shall obtain the following minimum insurance coverage and maintain it at all times throughout the life of the Contract,with the City included as an additional name insured on the general liability insurance on a primary and noncontributory basis. The Contractor shall furnish the City a certificate of insurance satisfactory to the City evidencing the required coverage: Bodily Injury: $2,000,000 each occurrence $2,000,000 aggregate products and completed operations Property Damage: $2,000,000 each occurrence $2,000,000 aggregate Contractual Liability(identifying the contract): Bodily Injury: $2,000,000 each occurrence Property Damage: $2,000,000 each occurrence $2,000,000 aggregate Comprehensive Automobile Liability(owned, non-owned, hired): Bodily Injury, $2,000,000 each occurrence $2,000,000 each accident Property Damage: $2,000,000 each occurrence 10. INDEMNITY. The Contractor agrees to indemnify and hold the City harmless from any claim made by third parties as a result of the services performed by it. In addition,the Contractor shall reimburse the City for any cost of reasonable attorney's fees it may incur as a result of any such claims. 11. PERFORMANCE AND PAYMENT BONDS. Performance and payment bonds are not required. 12. MISCELLANEOUS. A. Owner and Contractor each binds itself, its partners, successors, assigns and legal representatives to the other party hereto, its partners,successors, assigns and legal representatives in respect to all covenants,agreements,and obligations contained in the Contract Documents. B. Any provision or part of the Contract Documents held to be void or unenforceable under any law or regulation shall be deemed stricken, and all remaining provisions shalJ continue to be valid and binding upon Owner and Contractor,who agree that the Contract Documents shall be reformed to replace such stricken provision or part thereof with a valid and enforceable provision that comes as close as possible to expressing the intention of the stricken provisions. C. Data Practices/Records. (1) All data created, collected, received, maintained or disseminated for any purpose in the course of this Contract is governed by the Minnesota Government Data Practices Act, Minn.Stat. Ch. 13, any other applicable state statute, or any state rules adopted to implement the act, as well as federal regulations on data privacy. (2) All books, records, documents and accounting procedures and practices to the Contractor and its subcontractors, if any, relative to this Contract are subject to examination by the City. D. Waiver. In the particular event that either party shall at anytime 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. E. Governing Law/Venue. The laws of the State of Minnesota govern the interpretation of this Contract. In the event of litigation,the exclusive venue shall be in the District Court of the State of Minnesota for Dakota County. F. Severability. If any provision,term or condition of this Contract is found to be or become unenforceable or invalid, it shall not affect the remaining provisions, terms and conditions of this Contract, unless such invalid or unenforceable provision,term or condition renders this Contract impossible to perform. Such remaining terms and conditions of the Contract shall continue in full force and effect and shall continue to operate as the parties' entire contract. G. Entire Agreement. This Contract represents the entire agreement of the parties and is a final,complete and all-inclusive statement of the terms thereof,and supersedes and terminates any prior agreement(s), understandings or written or verbal representations made between the parties with respect thereto. H. If the work is delayed or the sequencing of work is altered because of the action or inaction of the Owner,the Contractor shall be allowed a time extension to complete the work but shall not be entitled to any other compensation. OWNER: CONTRACTOR: CITY OF FARMINGTON CORRECTIVE ASPHALT MATERIALS, LLC VL BY: BY: � J�� s�: , •ku .,t..,,•'!�velli Leighanne Bornes Its Mayor �r Its'. Manager AND Gil Its City Administrate CITY 4F O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 ®®. O FarmingtonMN.gov TO: Mayor, Councilmembers and City Administrator FROM: Tony Wippler, Planning Manager SUBJECT: Findings of Fact for Appeal of Planning Commission Decision- Farmington Enterprises, LLC-310 Third Street-Community Development DATE: July 19, 2021 INTRODUCTION Farmington Enterprises, LLC, owner of 310 Third Street, appealed the May 11th decision of the Planning Commission to deny the Conditional Use Permit application by Armando Gutierrez to allow auto repair, major at the property located at 310 Third Street to the City Council. DISCUSSION The City Council held a public hearing on June 21, 2021 to consider the appeal request. The City Council denied the request appeal with a S-0 vote and requested that Findings of Fact be drafted and presented to City Council at the July 19th regular meeting. Attached, are the Findings of Fact. BUDGET IMPACT NA ACTION REQUESTED A motion should be made to adopt the Findings of Fact as presented. ATTACHMENTS: Type Description D Backup Material Findings of Fact CITY OF FARMINGTON DAKOTA COUNTY,MINNESOTA IN RE: Appeal of a Planning Commission Decision to the FINDINGF OF FACT City Council Regarding the Application of Armando AND DECISION Gutierrez For a Conditional Use Permit for The purpose of allowing an Auto Repair,Major Use at the property located at 310 Third Street On June 21, 2021, the Farmington City Council met to consider the appeal of the Planning Commission's decision regarding the application of Armando Gutierrez for a Conditional Use Permit for the purpose of operating an auto repair,maj or use out of the property addressed as 310 Third Street. Having considered the Planning Commission's decision,the City's Comprehensive Plan,its official controls,staff reports,and all other written materials,having heard testimony from all interested persons wishing to speak; and based on its knowledge of the community; the City Council now makes the following: FINDINGS OF FACT 1. The property is located at 310 Third Street("Subject Property") and is guided Commercial by the 2040 Comprehensive Plan and is zoned B-2 (Downtown Business). 2. The property had historically been used as an auto sales business that included an auto repair,major component. The auto repair was used strictly for the auto sales operation. 3. Auto sales is neither a permitted or conditional use within the B-2 zoning district and because of this,that use at the subject property was deemed a nonconforming use. 4. The auto sales operation ceased several years ago, thereby terminating the ability for the nonconforming use to continue—per Section 10-4-2(3)3(b) of the City Code. 5. Auto Repair,Major is listed as a conditional use within the B-2 zoning district. 6. The City Code,Section 10-3-5 provides"Conditional uses,as specified within each zoning district, may be allowed or denied by the board of adjustment in accordance with the criteria and provisions listed herein. The board of adjustment may establish any reasonable conditions of approval that are deemed necessary to mitigate adverse impacts associated with the conditions of use to protect neighboring properties,and to achieve the objectives elsewhere in this title." 7. The City Code, Section 10-3-5 specifies the procedures for reviewing the application and conducting a public hearing on the application,and those requirements have been met. 8. The City Code, Section 10-3-5 (C) provides: A conditional use shall be approved if it is found to meet the following criteria: 1. The proposed use conforms to the district permitted and conditional use provisions and all general regulations of this title. Auto repair, Major is listed as a conditional use within the B-2 (Downtown Business)zoning district. 2. The proposed use shall not involve any element or cause any conditions that may be dangerous, injurious or noxious to any other property persons and shall comply with the performance standards listed below. Based on previous history with the applicant staff does believe the location of major auto repair at this location would create instances where the use does create potential dangerous, injurious and noxious situations. 3. The proposed use shall be constructed, designed, sited, oriented and landscaped to produce harmonious relationship of buildings and grounds to adjacent buildings and properties. This site is a highly visible site at the entrance of downtown. The proposed use and based on past history with the applicant the use will not produce a harmonious relationship with surrounding properties. It should be noted that the 2016 Downtown Redevelopment Plan specifically identifies this site as a potential redevelopment site for a mixed use building (commercial/residential) which would be more harmonious with the adjacent properties and uses. 4. The proposed use shall produce a total visual impression and environment which is consistent with the environment of the neighborhood. Again, this is a highly visible location at the edge of downtown and staff believes the proposed use will not produce a total visual impression and environment which is consistent with the environment of the neighborhood. 5. The proposed use shall organize vehicular access and parking to minimize traffic congestion in the neighborhood. This site is constrained for off-street parking. Adding this type of use at this location would likely have a negative impact on the parking and access at this location as the applicant would likely want to keep vehicles that will be worked on outside of the building. 6. The proposed use shall preserve the objectives of this title and shall be consistent with the comprehensive plan. The comprehensive plan has the subject property guided for commercial uses. 9. The Planning Commission met on May 11, 2021 to consider the application and held a public hearing. The Planning Commission denied the application with a vote of 5-0 based on the above- mentioned criteria. 10. Section 10-3-10 of the City Code allows a party to appeal a zoning decision by the board of adjustment to the City Council if the appeal is filed within 10 days of the decision by the board of adjustment. The City Council must then conduct a hearing within 60 days after receipt of the appeal. 11. The city received an appeal from the property owner on May 21,2021. 12. The City Council held a public hearing regarding the appeal on June 21, 2021 after notice was given to all property owners adjacent to the subject property. DECISION Applicant's request for an appeal of the Planning Commission's decision regarding the Conditional Use Permit for purposes of operating an auto repair, major use on the property located at 310 Third Street is denied. CITY OF FARMINGTON BY: . Ra,,, L e /—Mayor ATTEST: dministrator CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 goo 6U Farmington M N.gov TO: Mayor, Councilmembers and City Administrator FROM: David McKnight, City Administrator SUBJECT: Approve Chang Order#3 for Liqour Store Relocation Project-Administration DATE: July 19, 2021 INTRODUCTION The work to transition the downtown liquor store into our new space at the Farmington Mall is progressing at a fast pace. We have worked with our construction manager on one additional change order for the project. DISCUSSION The space that we are moving into has no ramp for deliveries on the backside of the building. Due to the number of deliveries we will receive each week,the need to install a ramp is important. APPRO Development has worked with a contractor to develop an estimate for the work in the amount of $2,891 which includes demo and install of a ramp and the APPRO fees. BUDGET IMPACT The$2, 891 cost of the proposed change order will be taken out of the project contingency to have a net zero impact on the project budget. ACTION REQUESTED Ask any questions you may have on the proposed change order. Once the city council is comfortable, a motion should be made to authorize the city administrators signature on change order#3 in the amount of$2,891 for the liquor store relocation project. ATTACHMENTS: Type Description ❑ Cover Memo Change Order#3 E I CHANGE Distribution to: ORDER OWNER ARCHITECT ❑ II CONTRACTOR ® 1 PROJECT: Farmington Liquor Store CHANGE ORDER NUMBER: #3 923 811 Street Suite 945 Farmington,MN 55024 INITIATION DATE: July 14,2021 TO(Contractor): CONTRACT DATE:April 16,2021 APPRO Development,Inc. 21476 Grenada Avenue Lakeville,MN 55044 You are directed to make the following changes in this Contract: 1. Increase Cost Code:3-3053—Demo and install concrete for delivery ramp------------------------------------------------------Add $ 2,450.00 ($550.00 Material,$1,900.00 Labor) Sub-total Add $ 2,450.00 2. Increase APPRO Development Fees Add $ 441.00 3. Decrease Cost Code:49-1000—Contingency--------------------------------.-- .__.-_-_-___--.--________________----.-__________Deduct ($ 2,891.00) Total Change Order 43— Add $ 0.00 Pending Items: *Final design considerations/costs *Final costs with sub-bid credits *Exterior Sign(excluded from scope)moving and electrical connections Not valid until signed by both tlx Owner and Contractor. Slgnatum of the Contractor indicates his agreement hemwith,including and adjustment in the Contract Sum or Contract Time The original(Contract Sum)(Guarau )was........... ----------.__.--------.___.--.-----------------------------------$ 282,863.15 Net change by previously authorized Change Orders--------------------------------------------------------------------------------------------------------$ 27,528.85 The Contract Sum Guaranteed Maxisnu Costprior to this Change Order was ------------------$ 310,392.00 The(Contract Sum)( )will be (increased)(deorease- (u w4iiinged)by this Change Order------------------------------------------------------------------------------------ 0.00 The new(Contract Sum)(Guavas te-e44vlax iautx C-e )including this Change Order will be.........................................------------$ 310,392.00 The Contract Time will be(ixemased)(decreased)(unchanged)by ( 0 )Days. The Date of Substantial Completion as of the date of this Change Order therefore is unchanged Authorized: APPRO Development,Inc. City of Farmington ARCIIrrCCT CONTRACTOR O\W,ra 21476 Grenada Avenue 430 31 Street Address Address Address Lakeville,MN 55044 Farmington,MN 55024 Cay,Suit r 41 0 A"L t��1 k"& BY BY 111' 7,:slit r,�aitnil 87:,vid McKnight(Jul 1 ;)9:Ia CD r) DATE DATE wiu,wn DATE J-110- i i i CITY OF © 43o Third St., Farmington, MN 55024 FARMINGTON 651-28o-6800 Farmington M N.gov TO: Mayor, Councilmembers and City Administrator FROM: David McKnight, City Administrator SUBJECT: Approve Bills-Finance DATE: July 19, 2021 INTRODUCTION Attached is the check register for the period of June 16, 2021 through July 14, 2021. DISCUSSION NA BUDGET IMPACT NA ACTION REQUESTED Ask any questions you may have on the attached check register. Once the city council is comfortable, a motion should be made to approve the check register for the period of June 16, 2021 through July 14, 2021. ATTACHMENTS: Type Description D Cover Memo Check Register R55CKS2 LOGIS600V COICRACIL MEETING JULY 19, 2021 CITY OF FARMINGTON 7/14/2021 9:33:37 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 1 6/16/2021 - 7/14/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 155214 6/18/2021 100058 ADVANCE AUTO PARTS 15.84 HOSE FITTING 194417 2131-565283 6302 6230 VEHICLE SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 6.72 CHAINSAW SPARKPLUG 194417 2131-565283 1060 6220 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 1.02- 194417 2131-565283 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 140.42 HUB BEARING FOR 3223 194420 2131-565147 6302 6230 VEHICLE SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 9.03- 194420 2131-565147 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 7.63 ENGINE ASSEMBLY GREASE 194423 2131-565501 1051 6230 VEHICLE SUPPLIES&PARTS PATROL SERVICES 01000 05 12.20 BATTERY TERMINAL FOR 0726 194595 2131-564232 1072 6230 VEHICLE SUPPLIES&PARTS STREET MAINTENANCE 01000 08 8.09 SPARK PLUG FOR 0551 194596 2131-564274 1051 6230 VEHICLE SUPPLIES&PARTS PATROL SERVICES 01000 05 80.34 FUSE BLOCK FOR 0511 194597 2131-563326 1051 6230 VEHICLE SUPPLIES&PARTS PATROL SERVICES 01000 05 17.92 BUG TAR REMOVER 194598 2131-564267 6302 6242 CLEANING SUPPLIES SOLID WASTE OPERATIONS 06300 OB 279.11 155215 6/18/2021 110959 ANCONA TITLE&ESCROW 82.84 REF UTIL CR@5278 187TH ST W 194584 2021-194151 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 82.84 155216 6/18/2021 113303 ARTISAN BEER COMPANY 1,352.15 BEER ORDER 194655 3477856 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,352.15 155217 6/18/2021 108446 ASPEN MILLS,INC. 22.85 UNIFORM ITEMS:JONES,M. 194035 274843 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 22.85 UNIFORM ITEMS:THREET J. 194036 274844 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 22.85 UNIFORM ITEMS:LEUBNER,R. 194037 274846 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 35.70 UNIFORM ITEMS:CASTILLO,S. 194038 274845 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 149.95 UNIFORM ITEMS:BOLTON,C. 194183 274954 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 254.20 155218 6/18/2021 100112 BADGER METER INC 417.54 MAY'21 BEACON MBL HOSTING SERV 194536 80075072 6502 6505 EQUIPMENT REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 OB 417.54 155219 6/18/2021 100013 BECKER ARENA PRODUCTS,INC. 1,402.40 FLOORING FOR NORTH END OF RINK 194162 601105 2502 6240 BUILDING SUPPLIES&PARTS ICE ARENA OPERATIONS EXPE 02500 09 1,402.40 155220 6/18/2021 100493 BELLBOY CORPORATION 101.10 LIQUOR&SPIRITS ORDER 194575 0089757200 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 193.83 LIQUOR SUPPLIES&MIXES ORDER 194576 0103389500 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 106.58 LIQUOR SUPPLIES&MIXES ORDER 194620 0103389600 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 113.55 LIQUOR&SPIRITS ORDER 194621 0089757500 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 515.06 155221 6/18/2021 109503 BIFFS,INC 215.00 PRTBLE RNTL:MUSIC IN THE PARK 194519 $215.00 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 R55CKS2 LOGIS600V CITY OF FARMINGTON 7/14/2021 9:33:37 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 2 6/16/2021 - 7/14/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept Div 215.00 ' 155222 6/18/2021 117284 BLACK STACK BREWING,INC 225.00 BEER ORDER 194622 13071 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 225.00 155223 6/18/2021 110290 BOLTON&MENK,INC 497.00 2020 GEN ENG SVS 194531 0268230 1070 6401 PROFESSIONAL SERVICES ENGINEERING SERVICES 01000 07 1,665.50 APR'21 ENG SVS:FAIRHILL 4TH 194545 0269616 4600 2256 70208 DEVELOPMENT ESCROWS PRIVATE CAPITAL PROJECTS 04600 07 1,650.00 APR'21 ENG SVS:VITAATTIVA 194546 0269618 4600 2256 70901 DEVELOPMENT ESCROWS PRIVATE CAPITAL PROJECTS 04600 07 4,662.00 APR'21 ENG SVS:WHPRNG FLDS FP 194547 0269619 4600 2256 70802 DEVELOPMENT ESCROWS PRIVATE CAPITAL PROJECTS 04600 07 157.00 2020 ENG SVS:SAN FLW RATE 194548 0269605 1070 6401 PROFESSIONAL SERVICES ENGINEERING SERVICES 01000 07 368.00 APR'21 ENG SVS:FAIRHILL 3RD 194549 0269606 4600 2256 70207 DEVELOPMENT ESCROWS PRIVATE CAPITAL PROJECTS 04600 07 16,070.00 APR'21 ENG:TH3 LPP TRAIL DSGN 194550 0269614 5721 6401 02002 PROFESSIONAL SERVICES TRAIL MAINTENANCE 05700 25,069.50 155224 6/18/2021 114472 BREAKTHRU BEVERAGE MN BEER,LLC 81.40 BEER ORDER 194577 339809803 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 12,138.65 BEER ORDER 194580 339809802 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 14,395.35 BEER ORDER 194617 339609658 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 29.50 BEER ORDER 194623 339809659 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 26,644.90 155225 6/18/2021 114471 BREAKTHRU BEVERAGE MN WINE&SPIRITS 1,637.76 WINE ORDER 194578 339808917 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,205.57 LIQUOR&SPIRITS ORDER 194579 339808916 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,525.76 WINE ORDER 194626 339808751 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 3,397.56 LIQUOR&SPIRITS ORDER 194628 339808750 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 147.30 LIQUOR&SPIRITS ORDER 194637 339606752 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 061DO 02 7,913.95 155226 6/18/2021 100578 CEMSTONE CONCRETE MATERIALS,LLC 358.50 19712 EVERHILL SERVICE REPAIR 194309 C2344947 6502 6250 OTHER SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 358.50 155227 6/18/2021 110511 CHARTER COMMUNICATIONS HOLDINGS,LLC 675.45 JUN'21 CABLE&ALARM LINES 194238 0001792060121 7400 6411 TELEPHONE/CABLE SERVICES INFORMATION TECHNOLOGY 07400 04 675.45 155228 6118/2021 113887 CLEANLITES RECYLING,INC 173.35 IT EQUIP/DRIVES RECYCLING 194213 IN0061568 7400 6401 PROFESSIONAL SERVICES INFORMATION TECHNOLOGY 07400 04 173.35 155229 6/18/2021 117735 CLEAR RIVER BEVERAGE 130.75 BEER ORDER 194573 584122 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 556.50 BEER ORDER 194656 584137 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 R55CKS2 LOGIS600V CITY OF FARMINGTON 7/14/2021 9:33:37 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 3 6/16/2021 - 7/14/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 687.25 155230 6/18/2021 117504 CLEAR TITLE LLC 282.89 REF UTIL CR@1212 WALNUT ST 194570 2021040176/57 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 282.89 155231 6/18/2021 100071 COLLEGE CITY BEVERAGE INC 57.60- BEER ORDER CREDIT 194651 702068 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 178.50 LIQUOR&WINE ORDER 194652 702069 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 28.00- BEER ORDER CREDIT 194661 702128 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 16,268.99 BEER ORDER 194663 702070 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 9,985.40 BEER ORDER 194664 702130 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 12,05- BEER ORDER CREDIT 194665 702129 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 26,335,24 155232 6/18/2021 100030 CORE&MAIN,LP 68.16 HYDRANT PARTS 194299 0231384 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 47.22 DRIVE WAY CASTING 194426 0298214 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 115.38 155233 6/18/2021 109182 DAKOTA COMMUNICATIONS CENTER 8,357.67 JULY 2021 DCC FEES 194612 FA2021-07 1060 6560 CONTRACTUAL SERVICES FIRE SERVICES 01000 06 16,715.33 JULY 2021 DCC FEES 194612 FA2021-07 1050 6560 CONTRACTUAL SERVICES POLICE ADMINISTRATION 01000 05 25,073.00 155234 6/18/2021 111645 DALCO ENTERPRISES,INC 8,705.70 NEW FLOOR SCRUBBER 194319 3786470 1015 6950 MACHINERY,EQUIPMENT&TOOLS CITY HALL 01000 01 8,705.70- NEW FLOOR SCRUBBER 194319 3786470 1015 6950 MACHINERY,EQUIPMENT&TOOLS CITY HALL 01000 01 8,705.70 NEW FLOOR SCRUBBER 194319 3786470 5731 6950 00430 MACHINERY,EQUIPMENT&TOOLS BUILDING MAINTENANCE 05700 8,705.70 155235 6/18/2021 113296 EDINA REALTY TITLE 123.90 REF UTIL CR@5341 184TH ST W 194585 2121548/108 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 730.16 REF UTIL CR@5657 180TH ST W 194586 2118897/87 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 13.41 REF UTIL CR@19370 EUREKAAVE 194590 2122013/97 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 867.47 155236 6/18/2021 109931 FACTORY MOTOR PARTS 65.83 PLUG WIRES FOR 0551 193920 112-161910 1051 6230 VEHICLE SUPPLIES&PARTS PATROL SERVICES 01000 05 243.93 ENGINE PARTS FOR 0551 193921 1-6937250 1051 6230 VEHICLE SUPPLIES&PARTS PATROL SERVICES 01000 05 309.76 155237 6/18/2021 100022 FARMINGTON PRINTING INC 31.80 NAME PLATES:OMLID,K 194515 13961 1010 6210 OFFICE SUPPLIES ADMINISTRATION 01000 01 31.80 156238 6/18/2021 110176 FIRST FINANCIAL TITLE R55CKS2 LOGIS600V CITY OF FARMINGTON 7/14/2021 9:33:37 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 4 6/16/2021 - 7/14/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 188.07 REF UTIL CR@20587 CAMDEN PATH 194591 21-44120/33 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 188.07 155239 6/18/2021 111067 FRONTIER AG&TURF 717.42 HYDROLIC PRSSRE VALVE-JD MWR 194210 P34154 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 717.42 155240 6/18/2021 107123 GS DIRECT INC 17.82 PLOTTER SUPPLIES 194514 362689 6302 6220 EQUIP SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 16.67 PLOTTER SUPPLIES 194514 362689 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 1.15- 194514 362689 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 16.67 PLOTTER SUPPLIES 194514 362689 1095 6220 EQUIP SUPPLIES&PARTS RECREATION PROGRAM SERVIC 01000 09 16.67 PLOTTER SUPPLIES 194514 362689 6402 6220 EQUIP SUPPLIES&PARTS STORM WATER UTILITY OPERA 06400 08 16.67 PLOTTER SUPPLIES 194514 362689 6202 6220 EQUIP SUPPLIES&PARTS SEWER OPERATIONS EXPENSE 06200 08 16.67 PLOTTER SUPPLIES 194514 362689 1070 6220 EQUIP SUPPLIES&PARTS ENGINEERING SERVICES 010D0 07 16.66 PLOTTER SUPPLIES 194514 362689 1030 6220 EQUIP SUPPLIES&PARTS PLANNING&ZONING 01000 03 116.68 155241 6/1812021 108140 HEDLUND IRRIGATION&LANDSCAPING INC 54.00 MOWING SVS:18840 EMBERS AVE 194537 4531 4600 6560 CONTRACTUAL SERVICES PRIVATE CAPITAL PROJECTS 04600 07 54.00 156242 6/1812021 109232 HELM ELECTRIC INC 498.92 ELEC FOR GAR OPENER:FIRE 2 194518 14350B 1060 6515 BUILDING REPAIR/MAINTENANCE FIRE SERVICES 01000 06 498.92 155243 611812021 100074 HOHENSTEINS INC 1,138.10 BEER ORDER 194654 416061 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,138.10 155244 6/1812021 110525 IN-SITU INC 50.00 JUN'21 CELL SVS:WTR LVS SFTWR 194534 4693 6502 6412 CELLULAR SERVICES WATER UTILITY EXPENSE 06500 08 50.00 155246 6/18/2021 109846 JJ TAYLOR DISTRIBUTING COMPANY OF MN INC 53.75- BEER ORDER CREDIT 194636 3162396 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 8,344.40 BEER ORDER 194658 3191134 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 8,290.65 155246 6/18/2021 100033 JOHNSON BROTHERS LIQUOR COMPANY 3,797.86 LIQUOR&SPIRITS ORDER 194624 1818241 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,385.72 LIQUOR&SPIRITS ORDER 194625 1618242 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 061DO 02 871.35 WINE ORDER 194627 1618243 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 765.99 LIQUOR&SPIRITS ORDER 194629 1818244 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 77.02 LIQUOR&SPIRITS ORDER 194630 1818245 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 51.20 KINKY COCKTAILS ORDER 194631 1818246 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 R55CKS2 LOGIS600V CITY OF FARMINGTON 7/14/2021 9:33:37 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 5 6/16/2021 - 7/14/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 661.66 WINE ORDER 194632 1818247 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,694.09 LIQUOR&SPIRITS ORDER 194640 1818442 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 560.72 WINE ORDER 194641 1818441 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,121.98 LIQUOR&SPIRITS ORDER 194642 1818440 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 537.47 WINE ORDER 194643 1818439 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 178.53 LIQUOR&SPIRITS ORDER 194644 1818438 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 11,703.59 155247 6/18/2021 110766 JOHNSON CONTROLS FIRE PROTECTION LP 44.43 FIRE ALARM REPAIR 194527 87837063 1072 6515 BUILDING REPAIR/MAINTENANCE STREET MAINTENANCE 01000 08 44.42 FIRE ALARM REPAIR 194527 87837063 1090 6515 BUILDING REPAIR/MAINTENANCE PARK MAINTENANCE 01000 09 3.05- 194527 87837063 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 44.42 FIREALARM REPAIR 194527 87837063 6202 6515 BUILDING REPAIR/MAINTENANCE SEWER OPERATIONS EXPENSE 06200 08 47.47 FIRE ALARM REPAIR 194527 87837063 6302 6515 BUILDING REPAIR/MAINTENANCE SOLID WASTE OPERATIONS 06300 08 44.42 FIREALARM REPAIR 194527 87837063 6402 6515 BUILDING REPAIR/MAINTENANCE STORM WATER UTILITY OPERA 06400 08 43.89 FIREALARM REPAIR 194527 87837063 6502 6515 BUILDING REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 1,215.46 SPRNKLR-5 YR OBST INSP 194666 22316584 1015 6515 BUILDING REPAIR/MAINTENANCE CITY HALL 01000 01 1,481.46 155248 6/18/2021 102456 KLM ENGINEERING INC 1,500.00 T-MOBILE ANTENNA REVIEW 194538 8278 6502 6401 65001 PROFESSIONAL SERVICES WATER UTILITY EXPENSE 06500 08 1,500.00 155249 6/18/2021 110501 LAND TITLE INC 99.98 REF UTIL CR@5265 180TH ST W 194583 636922 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 79.50 REF UTIL CR@18854 DYLAN DR 194588 636024 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 179.48 155250 6/18/2021 101275 LIBERTY TIRE RECYCLING,LLC 308.30 TIRE RECYCLING 194226 2051671 6302 6401 PROFESSIONAL SERVICES SOLID WASTE OPERATIONS 06300 08 308.30 155251 6/18/2021 107747 M.AMUNDSON LLP 976.65 CIGARETTES&POP ORDER 194581 322638 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 976.65 155252 6/18/2021 115396 MACQUEEN EMERGENCY GROUP 408.18 REPAIRS TO 4782 194181 P05188 1060 6510 1 OUTSIDE VEHICLE REPAIR/MAINT FIRE SERVICES 01000 06 400.86 VALVE,SOLENOID FOR 4781 194182 P05181 1060 6230 VEHICLE SUPPLIES&PARTS FIRE SERVICES 01000 06 809.04 155253 6/18/2021 118104 MIDWEST CONCRETE SPECIALISTS 25.00 BURN PERMIT REFUND 194544 BURN PERMIT REFUNm01 4365 BURNING PERMITS GENERAL FUND REVENUES 01000 01 25.00 165254 6/18/2021 117764 MINNESOTA TITLE R55CKS2 LOGIS600V CITY OF FARMINGTON 7/14/2021 9:33:37 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 6 6/16/2021 - 7/14/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 60.52 REF UTIL CR@353 15TH ST 194567 MT-2101-1128-BV/11 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 6 60.52 155255 6/18/2021 100070 MINNESOTA VALLEY TESTING LABORATORIES 25.00 BAC-T SAMPLE(1) 194190 1089229 6502 6535 OTHER REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 77.00 BAC-T SAMPLE(7) 194191 1089230 6502 6535 OTHER REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 102.00 155256 6/18/2021 100322 MN NCPERS LIFE INSURANCE 16.00 194671 0616211219073 7000 2119 PERA LIFE INS PAYABLE EMPLOYEE EXPENSE FUND 07000 02 16.00 155257 6/18/2021 102644 NORTHERN SAFETY TECHNOLOGY,INC 1,869.92 K-9 SQUAD EQUIPMENT 194174 52415 2200 6230 VEHICLE SUPPLIES&PARTS K-9(EFF.2019) 02200 05 1,869.92 155258 6/18/2021 100032 PEPSI COLA COMPANY 202.30 POP ORDER 194574 50668057 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 133.30 POP ORDER 194657 50668058 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 335.60 155259 6/18/2021 100034 PHILLIPS WINE AND SPIRITS,INC 134.83 LIQUOR&SPIRITS ORDER 194633 6217022 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 517.83 WINE ORDER 194634 6217021 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 359.04 LIQUOR&SPIRITS ORDER 194635 6217020 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 465.10 WINE ORDER 194638 6217170 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 327.02 LIQUOR&SPIRITS ORDER 194639 6217169 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,803.82 155260 6/18/2021 117491 POMP'S TIRE SERVICE,INC 162.75 TIRE REPAIR FOR 0725 194599 210517556 1072 6510 1 OUTSIDE VEHICLE REPAIR/MAINT STREET MAINTENANCE 01D00 08 162.75 155261 6/18/2021 110664 PREMIER TITLE INSURANCE AGENCY INC 82.86 REF UTIL CR@2761 213TH ST 194571 36141/42 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 82.86 155262 6/18/2021 117905 PYRES BREWING COMPANY LLC 258.17 BEER ORDER 194572 W-23205 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 208.00 BEER ORDER 194653 W-23305 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 466.17 155263 6/18/2021 114646 QUALITY FLOW SYSTEMS,INC 430.00 VERMILLION GROVE L.S.REPAIR 194204 40967 6202 6535 OTHER REPAIR/MAINTENANCE SEWER OPERATIONS EXPENSE 06200 08 430.00 166264 6/18/2021 100196 QUALITY REFRIGERATION INC R55CKS2 LOGIS600V CITY OF FARMINGTON 7/14/2021 9:33:37 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 7 6/16/2021 - 7/14/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 468.26 WALK IN COOLER REPAIR 194668 0090479 6110 6505 EQUIPMENT REPAIR/MAINTENANCE DOWNTOWN LIQUOR REV&EXP 06100 02 468.26 155265 6/18/2021 114224 RADCO-BURNSVILLE 2,568.00 F#0728 TRUCK TOPPER 194297 BR-1039274-01 5602 6940 VEHICLES GEN CAPITAL EQUIP FUND EX 05600 2,568.00 155266 6/18/2021 117564 RECYCLE MINNESOTA LLC 5,813.01 MAY'21 TRANSLOAD FEES 194600 0000006753 6302 6401 PROFESSIONAL SERVICES SOLID WASTE OPERATIONS 06300 08 5,813.01 155267 6/18/2021 112632 RICOH USA,INC 352.89 MAY'21 COPIER MAINTENANCE 194552 5062098219 1010 6505 EQUIPMENT REPAIR/MAINTENANCE ADMINISTRATION 01000 01 352.89 165268 6/18/2021 103092 ROCKMOUNT RESEARCH AND ALLOYS INC 194.63 FLAT WHEEL/HD FLAP DISC:GRIND 194293 1262500 7200 6220 EQUIP SUPPLIES&PARTS FLEET OPERATIONS 07200 08 194.63 155269 6/16/2021 107018 SHAMROCK GROUP 194.02 ICE CUBE ORDER 194648 2629633 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 135.01 ICE CUBE ORDER 194649 2636036 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 99.94 ICE CUBE ORDER 194650 2632122 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 172.38 ICE CUBE ORDER 194662 2632124 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 601.35 155270 6/18/2021 118103 SIMON,RUSSELL 55.00 VOID MECH PRMT48044 194543 VOID MECH PRMT 1001 4315 PLUMBING&HEATING PERMITS GENERAL FUND REVENUES 01000 01 48044 1.00 VOID MECH PRMT 48044 194543 VOID MECH PRMT 1000 2420 BUILDING PERMIT SURCHARGE GENERAL FUND BALANCE SHEE 01000 48044 56.00 155271 6/1B/2021 112051 SOUTHERN GLAZER'S OF MN 2,834.93 LIQUOR&SPIRITS ORDER 194618 2088710 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 6.40 LIQUOR&SPIRITS ORDER 194645 2088706 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1.28 DELIVERY CHARGE 194646 2088702 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1.28 DELIVERY CHARGE 194647 2088704 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,048.74 WINE ORDER 194659 2088705 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 12.80 LIQUOR&SPIRITS ORDER 194660 2088712 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 3,905.43 155272 6/18/2021 109431 SYMBOLARTS 1,210.50 REWARD COINS 194554 0378884-IN 1060 6450 OUTSIDE PRINTING FIRE SERVICES 01000 06 1,210.50 166273 6/16/2021 100619 TC CONSTRUCTION,INC R55CKS2 LOGIS600V CITY OF FARMINGTON 7/14/2021 9:33:37 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 8 6/16/2021 - 7/14/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept Div 3,000.00 ER 6536 UPR 210TH ST W 194539 ER 6536 UPR 210TH 4600 2255 DEPOSITS PAYABLE PRIVATE CAPITAL PROJECTS 04600 07 ST W 3,000.00 ER 21040 FLAGSTONE WAY 194540 ER 21040 FLAGSTON14600 2255 DEPOSITS PAYABLE PRIVATE CAPITAL PROJECTS 04600 07 WAY 3,000.00 ER 6590 210TH ST W 194541 ER 6590 210TU ST W 4600 2255 DEPOSITS PAYABLE PRIVATE CAPITAL PROJECTS 04600 07 3,000.00 ER 6516 UPR 210TH ST W 194542 ER 6516 UPR 210TH 4600 2255 DEPOSITS PAYABLE PRIVATE CAPITAL PROJECTS 04600 07 ST W 12,000.00 155274 6/18/2021 108670 TERMINAL SUPPLY COMPANY 624.37 WIRE AND WIRING SUPPLIES 194189 46242-00 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 624.37 155275 6/18/2021 115777 TITLE GROUP INC,THE 84.11 REF UTIL CR@4823 189TH ST W 194582 210536205/70 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 84.11 155276 6/18/2021 113754 TITLE SMART,INC 47.82 REF UTIL CR@19069 EVEREST TRL 194589 243992/84 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 165.75 REF UTIL CR@22421 CALICO CT 194592 245700/79 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 213.57 155277 6/18/2021 115789 TITLE SMART,INC 346.25 REF UTIL CR@1125 PINE ST 194569 246558/54 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 346.25 155278 6/18/2021 112307 T-MOBILE USA INC 6.67 MAY'21 GPS SERVICE 194513 823329497 MAY'21 6502 6412 CELLULAR SERVICES WATER UTILITY EXPENSE 06500 08 6.66 MAY'21 GPS SERVICE 194513 823329497 MAY'21 6202 6412 CELLULAR SERVICES SEWER OPERATIONS EXPENSE 06200 08 6.66 MAY'21 GPS SERVICE 194513 823329497 MAY'21 6402 6412 CELLULAR SERVICES STORM WATER UTILITY OPERA 06400 08 19.99 155279 6/18/2021 109709 TRIHUS,DAVID M 11.20 MAY'21 MILEAGE REIMB 194606 20210531 TRIHUS 6115 6485 MILEAGE REIMBURSEMENT PILOT KNOB LIQUOR 06100 02 11.20 MAY'21 MILEAGE REIMB 194606 20210531 TRIHUS 6110 6485 MILEAGE REIMBURSEMENT DOWNTOWN LIQUOR REV&EXP 06100 02 22.40 155280 6/18/2021 108808 VINOCOPIA,INC 984.00 WINE ORDER 194619 0280512-IN 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 984.00 156281 6/18/2021 113123 WATERMARK TITLE AGENCY,LLC 165.65 REF UTIL CR@506 13TH ST 194568 81813 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 37.38 REF UTIL CR@18744 EUCLID PATH 194587 81044 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 203.03 165282 6/25/2021 101344 ABM EQUIPMENT&SUPPLY INC. R55CKS2 LOGIS600V CITY OF FARMINGTON 7/14/2021 9:33:37 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 9 6/16/2021 - 7/14/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept Div 979.34 PARTS FOR 3204 TARP 194732 0167719-IN 6302 6230 VEHICLE SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 63.00- 194732 0167719-IN 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 916.34 155283 6/25/2021 100058 ADVANCE AUTO PARTS 9.79 ZIP TIES FOR MOUNTING 194556 1596-333352 1060 6220 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 13.84 HVAC BELTS 194678 2131-564176 1060 6240 BUILDING SUPPLIES&PARTS FIRE SERVICES 01000 06 11.41 HVAC BELTS 194679 2131-564177 1093 6240 BUILDING SUPPLIES&PARTS SENIOR CITIZEN SERVICES 01000 09 16.48 HVAC BELTS 194680 2131-564480 1015 6240 BUILDING SUPPLIES&PARTS CITY HALL 01000 01 21.49 HVAC BELTS 194681 2131-564483 1050 6240 BUILDING SUPPLIES&PARTS POLICE ADMINISTRATION 01000 05 73.01 155284 6/25/2021 108446 ASPEN MILLS,INC. 24.85 NAME TAGS(6) 194557 275311 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 49.70 FIREFIGHTER NAME TAG 194558 275312 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 74.55 155285 6/25/2021 110290 BOLTON&MENK,INC 22,172.50 APR'21 SVS:DWNTWN SIDEWLKS 194736 0269729 5721 6401 02101 PROFESSIONAL SERVICES TRAIL MAINTENANCE 05700 7,470.00 MAR'21 SVS:LPP TH3 TRL IMPRV 194737 0268231 5721 6401 02002 PROFESSIONAL SERVICES TRAIL MAINTENANCE 05700 29,642.50 155286 6/25/2021 100243 BRAUN INTERTEC CORPORATION 170.00 MAY'21 SVS:BORINGS FAIRHLL PR 194735 B254187 2327 6401 PROFESSIONAL SERVICES JIM BELL PARKAND PRESERV 02300 09 170.00 155287 6/26/2021 100253 CAMPBELL KNUTSON,P.A. 276.60 MAY'21 LEGAL FEES-EDA HMSTD CH 194551 1852-D059G MAY'21 2000 6403 LEGAL HRA/ECONOMIC DEVELOPMENT 02000 03 10,409.98 MAY-20 LEGAL FEES-PROSECUTION 194704 1852-0999G MAY'21 1050 6403 LEGAL POLICE ADMINISTRATION 01000 05 319.50 MAY'20 LEGAL FEES-FORFEITURE 194705 1852-0003G MAY'21 2100 6403 LEGAL POLICE FORFEITURES 02100 05 51.60 MAY'20 LEGAL FEES-POLICE 194706 1852-0004G MAY'21 1050 6403 LEGAL POLICE ADMINISTRATION 01000 05 1,056.00 MAY'21 LEGAL FEES-GENERAURETN 194726 1852-000OG MAY'21 1005 6403 LEGAL LEGISLATIVE CONTROL 01000 01 223.60 MAY'21 LEGAL FEES-GENERAURETN 194726 1852-OODOG MAY'21 1010 6403 LEGAL ADMINISTRATION 01000 01 639.60 MAY'21 LEGAL FEES-GENERAURETN 194726 1852-000OG MAY'21 1030 6403 LEGAL PLANNING&ZONING 01000 03 313.20 MAY'21 LEGAL FEES-GENERAURETN 194726 1852-ODOOG MAY'21 1050 6403 LEGAL POLICE ADMINISTRATION 01000 05 68.80 MAY'21 LEGAL FEES-GENERAURETN 194726 1852-D000G MAY'21 1070 6403 LEGAL ENGINEERING SERVICES 01000 07 13,358.88 155288 6/25/2021 113887 CLEAN LITES RECYLING,INC 2,202.90 ELECTRONICS/DRIVES RECYCLING 194216 IN0061755 7400 6401 PROFESSIONAL SERVICES INFORMATION TECHNOLOGY 07400 04 2,202.90 155289 6/26/2021 118112 COMES,AVERY 135.24 06/18/2021 PRACH RETURN 194675 06/18/2021 PRACH 7000 2255 DEPOSITS PAYABLE EMPLOYEE EXPENSE FUND 07000 02 RTRN 135.24 R55CKS2 LOGIS600V CITY OF FARMINGTON 7/14/2021 9:33:37 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 10 6/16/2021 - 7/14/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 155290 6/25/2021 100466 COMMERCIAL ASPHALT COMPANY 469.97 ASPHALT 194303 210531 1072 6253 STREET MATERIALS STREET MAINTENANCE 01000 08 469.97 155291 6/25/2021 112888 COOL AIR MECHANICAL,INC 2,599.20 OIL SEPERATOR 194728 99886 4503 6950 MACHINERY,EQUIPMENT&TOOLS ICE ARENA CAPITAL IMPR FU 04500 09 16,427.80 CONDENSER REPLACEMENT 194729 99885 4503 6950 MACHINERY,EQUIPMENT&TOOLS ICEARENA CAPITAL IMPR FU 04500 09 19,027.00 156292 6125/2021 109077 DAKOTA COUNTY CDA 42,823.00 TWIN PONDS BACKAGE ROAD REFUN 194740 20210622 ESCROW 4600 2255 DEPOSITS PAYABLE PRIVATE CAPITAL PROJECTS 04600 07 RFD 37,500.00 TWIN PONDS TH3 TURN LANE REFUN 194740 20210622 ESCROW 4600 2255 DEPOSITS PAYABLE PRIVATE CAPITAL PROJECTS 04600 07 RFD 80,323.00 155293 6/25/2021 100133 DAKOTA COUNTY FINANCIAL SRVS 1,026.52 MAY 2021 RADIO SUBSCRIBER FEES 194708 00041322 1050 656D CONTRACTUAL SERVICES POLICE ADMINISTRATION 01000 05 1,539.78 MAY 2021 RADIO SUBSCRIBER FEES 194708 00041322 1060 6560 CONTRACTUAL SERVICES FIRE SERVICES 01000 06 2,566.30 155294 6/25/2021 110844 DAKOTA COUNTY FINANCIAL SRVS 73.91 MAY'21 DIESEL FUEL 194719 00041296 1076 6272 FUEL NATURAL RESOURCES 01000 07 914.42 MAY'21 DIESEL FUEL 194719 00041296 1060 6272 FUEL FIRE SERVICES 01000 06 203.91- 194719 00041296 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 13.60 MAY'21 DIESEL FUEL 194719 00041296 6202 6272 FUEL SEWER OPERATIONS EXPENSE 06200 08 408.55 MAY'21 DIESEL FUEL 194719 00041296 1072 6272 FUEL STREET MAINTENANCE 01000 08 3,169.82 MAY-21 DIESEL FUEL 194719 00041296 6302 6272 FUEL SOLID WASTE OPERATIONS 06300 08 26.17 MAY'21 DIESEL FUEL 194719 00041296 1090 6272 FUEL PARK MAINTENANCE 01000 09 28.35 APR'21 GOPHER 1 FIBER LOCATES 194725 00041127 7400 6401 PROFESSIONAL SERVICES INFORMATION TECHNOLOGY 07400 04 4,430.91 155295 6/25/2021 100081 DAKOTA COUNTY LUMBER COMPANY 277.20 CONCRETE MIX 194692 2106-805837 1090 6250 OTHER SUPPLIES&PARTS PARK MAINTENANCE 01000 09 277.20 155296 6/25/2021 111645 DALCO ENTERPRISES,INC 103.00 FLOOR SCRUBBER PADS 194279 3787650 1015 6220 EQUIP SUPPLIES&PARTS CITY HALL 01000 01 103.00 155297 6/26/2021 117831 DESERT ENTERPRISES 308.33 LIQ LIC REFND DUE TO SALE 194702 LIQ LIC RFND DUE 1001 4205 LIQUOR LICENSES GENERAL FUND REVENUES 01000 01 TO SALE 308.33 R55CKS2 LOGIS600V CITY OF FARMINGTON 7/14/2021 9:33:37 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 11 6/16/2021 - 7/14/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 155298 6/25/2021 100149 ECM PUBLISHERS,INC 27.50 ORD#021-758 194200 837095 1010 6455 LEGAL NOTICES ADMINISTRATION 01000 01 16.50 FRMNGTN TAP HOUSE P.H 194202 837096 1010 6455 LEGAL NOTICES ADMINISTRATION 01000 01 30.25 ORD#021-757 194203 837094 1010 6455 LEGAL NOTICES ADMINISTRATION 01000 01 187.00 AD FOR BID-DT SIDEWALKS 194535 837093 5721 6455 02101 LEGAL NOTICES TRAIL MAINTENANCE 05700 261.25 155299 6/25/2021 117581 ELLIE FAMILY SERVICES 3,720.00 DEPARTMENT WELLNESS CHECKS 194703 06142021_413M 1050 6405 EMPLOYMENT TESTING POLICE ADMINISTRATION 01000 05 3,720.00 165302 6/25/2021 100022 FARMINGTON PRINTING INC 73.00 COPY PAPER 194242 13963 1010 6210 OFFICE SUPPLIES ADMINISTRATION 01000 01 73.00 155303 6/25/2021 111067 FRONTIER AG&TURF 336.48 JOHN DEERE MOWER PARTS 194295 P34387 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 336.48 155304 6/25/2021 100024 GOPHER STATE ONE-CALL 214.65 MAY 2021 LOCATES 194229 1050387 6502 6401 PROFESSIONAL SERVICES WATER UTILITY EXPENSE 06500 08 214.65 MAY 2021 LOCATES 194229 1050387 6202 6401 PROFESSIONAL SERVICES SEWER OPERATIONS EXPENSE 06200 08 214.65 MAY 2021 LOCATES 194229 1050387 6402 6401 PROFESSIONAL SERVICES STORM WATER UTILITY OPERA 06400 08 643.95 155305 6/25/2021 100044 GRAINGER INC 104.86 STEEL BANDING 194301 9920402188 1072 6220 EQUIP SUPPLIES&PARTS STREET MAINTENANCE 01000 08 104.86 166306 6/26/2021 116589 GREATAMERICA FINANCIAL SERVICES 217.85 JUN'21 POSTAGE METER RENTAL 194565 29490786 1010 6555 RENTAL OF EQUIPMENT ADMINISTRATION 01000 01 217.85 155307 6/25/2021 118114 HANSON,RILEY 323.85 AUTO DEPOSIT RETURNED 194676 06/18/2021 PRACH 7000 2255 DEPOSITS PAYABLE EMPLOYEE EXPENSE FUND 07000 02 RTRN 323.85 155308 6/25/2021 118115 HANSON,ZACHARY 323.85 06/18/2021 PRACH RETURN 194677 06/18/2021 PRACH 7000 2255 DEPOSITS PAYABLE EMPLOYEE EXPENSE FUND 07000 02 RTRN 323.85 156309 6/25/2021 100597 INDEPENDENT BLACK DIRT CO INC 105.00 19712 EVERHILL SERVICE REPAIR 194300 MAY 2021 6502 6250 OTHER SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 370.00 WATER MAIN REPAIR ASH ST 194300 MAY 2021 6502 6250 OTHER SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 294.00 STUMP GRINDING RESTORATION 194300 MAY 2021 1076 6255 LANDSCAPING MATERIALS NATURAL RESOURCES 01000 07 R55CKS2 LOGIS600V CITY OF FARMINGTON 7/14/2021 9:33:37 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 12 6/16/2021 - 7/14/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept Div 769.00 155310 6/25/2021 111773 INNOVATIVE OFFICE SOLUTIONS,LLC 44.16 PENS,STAPLES 194201 IN3367302 1010 6210 OFFICE SUPPLIES ADMINISTRATION 01000 01 44.16 155311 6/25/2021 110766 JOHNSON CONTROLS FIRE PROTECTION LP 111.75 FIRE ALARM MONITORING 194690 22316582 1072 6515 BUILDING REPAIR/MAINTENANCE STREET MAINTENANCE 01000 08 111.77 FIRE ALARM MONITORING 194690 22316582 1090 6515 BUILDING REPAIR/MAINTENANCE PARK MAINTENANCE 01000 09 7.68- 194690 22316582 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 111.75 FIRE ALARM MONITORING 194690 22316582 6202 6515 BUILDING REPAIR/MAINTENANCE SEWER OPERATIONS EXPENSE 06200 08 119.43 FIRE ALARM MONITORING 194690 22316582 6302 6515 BUILDING REPAIR/MAINTENANCE SOLID WASTE OPERATIONS 06300 08 111.75 FIRE ALARM MONITORING 194690 22316582 6402 6515 BUILDING REPAIR/MAINTENANCE STORM WATER UTILITY OPERA 06400 08 110.42 FIRE ALARM MONITORING 194690 22316582 6502 6515 BUILDING REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 669.19 155312 6/25/2021 115466 LIFE INSURANCE COMPANY OF NORTH AMERICA 387.57 APR'21ACCIDENT&Cl INSURANCE 194694 A1960331APRIL'21 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 387.57 JUNTIACCIDENT&Cl INSURANCE 194695 A1960331 JUNE'21 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 387.57 MAY'21ACCIDENT&Cl INSURANCE 194696 A1960331 MAY'21 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 387.57 MAR'21ACCIDENT&Cl INSURANCE 194697 A1960331 MARCH'21 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 1,550.28 155313 6/25/2021 100049 LOCAL GOVERNMENT INFORMATION SYSTEMS 106.00 JUN'21 APPL SUPPORT INVOICE 194332 50437 7400 6402 DATA PROCESSING INFORMATION TECHNOLOGY 07400 04 1,323.00 JUN'21 APPL SUPPORT INVOICE 194332 50437 7400 6402 DATA PROCESSING INFORMATION TECHNOLOGY 07400 04 1,427.00 JUN'21 APPL SUPPORT INVOICE 194332 50437 7400 6402 DATA PROCESSING INFORMATION TECHNOLOGY 07400 04 220.00 JUN'21 APPL SUPPORT INVOICE 194332 50437 1031 6402 DATA PROCESSING BUILDING INSPECTIONS 01000 07 2,881.00 JUN'21 APPL SUPPORT INVOICE 194332 50437 1031 6402 DATA PROCESSING BUILDING INSPECTIONS 01000 07 173.00 JUN'21 APPL SUPPORT INVOICE 194332 50437 6202 6402 DATA PROCESSING SEWER OPERATIONS EXPENSE 06200 08 1,312.00 JUN'21 APPL SUPPORT INVOICE 194332 50437 1021 6402 DATA PROCESSING GENERAL ACCOUNTING 01000 02 321.00 JUN'21 APPL SUPPORT INVOICE 194332 50437 1050 6402 DATA PROCESSING POLICE ADMINISTRATION 01000 05 382.00 JUN'21 APPL SUPPORT INVOICE 194332 50437 1060 6402 DATA PROCESSING FIRE SERVICES 01000 06 2,044.00 JUN-21 APPL SUPPORT INVOICE 194332 50437 1050 6402 DATA PROCESSING POLICE ADMINISTRATION 01000 05 2,514.00 JUN'21 APPL SUPPORT INVOICE 194332 50437 1011 6402 DATA PROCESSING HUMAN RESOURCES 01000 04 476.00 JUN'21 APPL SUPPORT INVOICE 194332 50437 1021 6402 DATA PROCESSING GENERAL ACCOUNTING 01000 02 775.00 JUN'21 APPL SUPPORT INVOICE 194332 50437 7400 6402 DATA PROCESSING INFORMATION TECHNOLOGY 07400 04 2,997.00 JUN'21 APPL SUPPORT INVOICE 194332 50437 1021 6402 DATA PROCESSING GENERAL ACCOUNTING 01000 02 996.75 JUN'21 APPL SUPPORT INVOICE 194332 50437 6502 6402 DATA PROCESSING WATER UTILITY EXPENSE 06500 08 996.75 JUN'21 APPL SUPPORT INVOICE 194332 50437 6402 6402 DATA PROCESSING STORM WATER UTILITY OPERA 06400 08 996.75 JUN'21 APPL SUPPORT INVOICE 194332 50437 6302 6402 DATA PROCESSING SOLID WASTE OPERATIONS 06300 08 996.75 JUN'21 APPL SUPPORT INVOICE 194332 50437 6202 6402 DATA PROCESSING SEWER OPERATIONS EXPENSE 06200 08 62.50 TICKET#265451:PD SWITCH PORT 194566 50497 7400 6401 PROFESSIONAL SERVICES INFORMATION TECHNOLOGY 07400 04 368.75 AUG'20 MN IT WAN SERVICE 194722 50544 7400 6402 DATA PROCESSING INFORMATION TECHNOLOGY 07400 04 R55CKS2 LOGIS600V CITY OF FARMINGTON 7/14/2021 9:33:37 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 13 6/16/2021 - 7/14/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 368.75 APR'21 MN IT WAN SERVICE 194722 50544 7400 6402 DATA PROCESSING INFORMATION TECHNOLOGY 07400 04 15.00 ENTRUST VPN TOKEN:KELEE OLMID 194722 50544 7400 6505 EQUIPMENT REPAIR/MAINTENANCE INFORMATION TECHNOLOGY 07400 04 21,753.00 155314 6/25/2021 110645 MERRITT HOMES,CHARLES 3,000.00 ER 4776 187TH ST W 194742 ER 4776 187TH ST W 4600 2255 DEPOSITS PAYABLE PRIVATE CAPITAL PROJECTS 04600 07 3,000.00 155315 6/25/2021 100095 METROPOLITAN COUNCIL ENVIRONMENTAL SVS 138,425.37 JUL 2021 WASTE WATER MCES FEES 194424 0001125437 6502 6565 MCES FEES WATER UTILITY EXPENSE 06500 08 138,425.37 155316 6/25/2021 108780 MINNESOTA AG GROUP INC 75.35 EXMARK MOWER PARTS 194294 IN93269 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 75.35 155317 6/25/2021 108225 MUNICIPAL EMERGENCY SERVICES,INC 3,536.44 F#4797 LADDER 1:ROPE BAGS 194315 IN1584389 4301 6940 VEHICLES FIRE CAPITAL PROJECTS 04300 06 3,536.44 155318 6/25/2021 102936 NORTHERN DOOR COMPANY 2,667.00 IND DUTY DOOR OPENER:FIRE#2 194727 68915 1060 6950 MACHINERY,EQUIPMENT&TOOLS FIRE SERVICES 01000 06 2,867.00 155319 6/25/2021 113031 NRG RELIABILITY SOLUTIONS LLC 1,793.61 MAY'21 ELEC LAW ENFORCE CNTR 194611 3346-2106 1050 6422 ELECTRIC POLICE ADMINISTRATION 01000 05 378.56 MAY'21 ELEC CMF 194730 3347-2106 1072 6422 ELECTRIC STREET MAINTENANCE 01000 08 378.57 MAY'21 ELEC CMF 194730 3347-2106 1090 6422 ELECTRIC PARK MAINTENANCE 01000 09 26.03- 194730 3347-2106 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 378.56 MAY'21 ELEC CMF 194730 3347-2106 6202 6422 ELECTRIC SEWER OPERATIONS EXPENSE 06200 08 404.59 MAY'21 ELEC CMF 194730 3347-2106 6302 6422 ELECTRIC SOLID WASTE OPERATIONS 06300 08 378.56 MAY'21 ELEC CMF 194730 3347-2106 6402 6422 ELECTRIC STORM WATER UTILITY OPERA 06400 08 374.03 MAY'21 ELEC CMF 194730 3347-2106 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 4,060.45 155320 6/25/2021 118111 POOT,MICHAEL 400.00 MUSIC IN PARK 062521 194674 062521 1095 6401 PROFESSIONAL SERVICES RECREATION PROGRAM SERVIC 01000 09 400.00 155321 6/25/2021 110760 PRO-TECH DESIGN,INC 255.00 PK STORE CAMERA TROUBLEHSOOTIN 194217 101201 7400 6401 PROFESSIONAL SERVICES INFORMATION TECHNOLOGY 07400 04 306.00 CITY HALL DURESS BUTTON ISSUE 194218 101199 7400 6401 PROFESSIONAL SERVICES INFORMATION TECHNOLOGY 07400 04 561.00 155322 6/25/2021 108826 RED WING,CITYOF 70,241.51 MAY'21 TIPPING FEES 194601 0062837 6302 6401 PROFESSIONAL SERVICES SOLID WASTE OPERATIONS 06300 08 70,241.51 R55CKS2 LOGIS600V CITY OF FARMINGTON 7/14/2021 9:33:37 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 14 6/16/2021 - 7/14/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 155323 6/25/2021 117089 ROCK HARD LANDSCAPE SUPPLY 54.00 MULCH-2YD 194282 1014873 1090 6255 LANDSCAPING MATERIALS PARK MAINTENANCE 01000 09 54.00 MULCH-2YD 194283 1014488 1090 6255 LANDSCAPING MATERIALS PARK MAINTENANCE 01000 09 108.00 155324 6/25/2021 116842 TRAUT COMPANIES 812.78 WELL 1 AIR RELEASE VALVE KIT 194720 300000 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 812.78 155325 6/25/2021 116029 WALZ,DAVE 5.00 VOID BLDG PRMT48050 194734 VOID BLDG PRMT 1000 2420 BUILDING PERMIT SURCHARGE GENERAL FUND BALANCE SHEE 01000 48050 215.90 VOID BLDG PRMT48050 194734 VOID BLDG PRMT 1001 4305 BUILDING PERMITS GENERAL FUND REVENUES 01000 01 48D50 220.90 155326 6/25/2021 110930 WAYZATA RESULTS 745.50 DEW RUN TIMER 194709 3110 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 745.50 155327 6/25/2021 100645 WESTWOOD SPORTS,INC 2,803.20 SOFTBALLS 194673 09-13409-01 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 2,803.20 155328 6/25/2021 100389 WOLD ARCHITECTS&ENGINEERS INC 2,500.00 DT LIQ RELOCATION STUDY 194212 72774 6110 7020 OTHER CONSTRUCTION COSTS DOWNTOWN LIQUOR REV&EXP 06100 02 2,500.00 155329 6/25/2021 108450 WSB&ASSOCIATES INC 3,360.00 APR'21 CODE ENFORCE SERVICES 194239 R-017977-000-1 1030 6401 PROFESSIONAL SERVICES PLANNING&ZONING 01000 03 3,360.00 155330 7/2/2021 113798 ACROSS THE STREET PRODUCTIONS 1,155.00 BLUE CARD TRAINING(3) 194560 INV08031 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01000 06 1,155.00 155331 7/2/2021 113303 ARTISAN BEER COMPANY 334.95 BEER ORDER 194872 3479124 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 334.95 155332 7/2/2021 108446 ASPEN MILLS,INC. 170.00 UNIFORM BRASS:ARENS,M 194559 275494 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 99.34 UNIFORM ITEMS:OLSON,M 194562 275647 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 200.00 UNIFORM ITEMS:ALTHOFF,B 194672 275604 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 469.34 166333 7/2/2021 114076 BLACKFIRE CREATIVE DESIGNS R55CKS2 LOGIS600V CITY OF FARMINGTON 7/14/2021 9:33:37 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 15 6/16/2021 - 7/14/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 48.04 BUILDING STICKERS 194841 5201 1060 6450 OUTSIDE PRINTING FIRE SERVICES 01000 06 48.04 155334 7/2/2021 114472 BREAKTHRU BEVERAGE MN BEER,LLC 6,468.25 BEER ORDER 194874 339902931 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,171.75 BEER ORDER 194932 339903058 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 597.50 BEER ORDER 194933 339985543 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 32.00- LIQUOR&SPIRITS ORDER CREDIT 194942 406762948 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 8,205.50 155335 7/2/2021 114471 BREAKTHRU BEVERAGE MN WINE&SPIRITS 2,237.58 LIQUOR&SPIRITS ORDER 194877 339897064 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 41.45 WINE ORDER 194878 339897065 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 208.45- LIQUOR&SPIRITS ORDER CREDIT 194879 408633767 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 224.90- LIQUOR&SPIRITS ORDER CREDIT 194934 408673201 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 89.45 WINE ORDER 194935 339897338 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 21.24- LIQUOR&SPIRITS ORDER CREDIT 194936 408642607 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 470.94 LIQUOR&SPIRITS ORDER 194937 339897337 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 126.20- LIQUOR&SPIRITS ORDER CREDIT 194938 408575101 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 231.84- LIQUOR&SPIRITS ORDER CREDIT 194939 408608348 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 97.45- LIQUOR&SPIRITS ORDER CREDIT 194940 408715872 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,047.30 LIQUOR&SPIRITS ORDER 194941 339984900 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 237.35- LIQUOR&SPIRITS ORDER CREDIT 194952 408642608 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 180.45- LIQUOR&SPIRITS ORDER CREDIT 194953 408642609 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 2,558.84 155336 7/2/2021 110511 CHARTER COMMUNICATIONS HOLDINGS,LLC 16.86 JUN'21 CABLE FD STATION#2 194845 0164297060621 7400 6411 TELEPHONE/CABLE SERVICES INFORMATION TECHNOLOGY 07400 04 16.86 155337 7/2/2021 100025 CINTAS CORP LOC 754 44.59 JUN'21 WEEKLY UNIFORM SERVICES 194274 4086068037 1072 6290 UNIFORMS&CLOTHING STREET MAINTENANCE 01000 08 44.57 JUN'21 WEEKLY UNIFORM SERVICES 194274 4086068037 1090 6290 UNIFORMS&CLOTHING PARK MAINTENANCE 01000 09 3.07- 194274 4086068037 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 44.59 JUN'21 WEEKLY UNIFORM SERVICES 194274 4086068037 6202 6290 UNIFORMS&CLOTHING SEWER OPERATIONS EXPENSE 06200 08 47.66 JUN'21 WEEKLY UNIFORM SERVICES 194274 4086068037 6302 6290 UNIFORMS&CLOTHING SOLID WASTE OPERATIONS 06300 08 44.59 JUN'21 WEEKLY UNIFORM SERVICES 194274 4086068037 6402 6290 UNIFORMS&CLOTHING STORM WATER UTILITY OPERA 06400 08 44.05 JUN'21 WEEKLY UNIFORM SERVICES 194274 4086068037 6502 6290 UNIFORMS&CLOTHING WATER UTILITY EXPENSE 06500 08 44.57 JUN'21 WEEKLY UNIFORM SERVICES 194528 4086750999 1072 6290 UNIFORMS&CLOTHING STREET MAINTENANCE 01000 08 44.59 JUN'21 WEEKLY UNIFORM SERVICES 194528 4086750999 1090 6290 UNIFORMS&CLOTHING PARK MAINTENANCE 01000 09 3.07- 194528 4086750999 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 44.59 JUN'21 WEEKLY UNIFORM SERVICES 194528 4086750999 6202 6290 UNIFORMS&CLOTHING SEWER OPERATIONS EXPENSE 06200 08 47.66 JUN'21 WEEKLY UNIFORM SERVICES 194528 4086750999 6302 6290 UNIFORMS&CLOTHING SOLID WASTE OPERATIONS 06300 08 44.59 JUN'21 WEEKLY UNIFORM SERVICES 194528 4086750999 6402 6290 UNIFORMS&CLOTHING STORM WATER UTILITY OPERA 06400 08 R55CKS2 LOGIS600V CITY OF FARMINGTON 7/14/2021 9:33:37 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 16 6/16/2021 - 7/14/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 44.05 JUN'21 WEEKLY UNIFORM SERVICES 194528 4086750999 6502 6290 UNIFORMS&CLOTHING WATER UTILITY EXPENSE 06500 08 44.59 JUN'21 WEEKLY UNIFORM SERVICES 194808 4087336514 1072 6290 UNIFORMS&CLOTHING STREET MAINTENANCE 01000 08 44.59 JUN'21 WEEKLY UNIFORM SERVICES 194808 4087336514 1090 6290 UNIFORMS&CLOTHING PARK MAINTENANCE 01000 09 3.06- 194808 4087336514 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 44.59 JUN'21 WEEKLY UNIFORM SERVICES 194808 4087336514 6202 6290 UNIFORMS&CLOTHING SEWER OPERATIONS EXPENSE 06200 08 47.63 JUN'21 WEEKLY UNIFORM SERVICES 194808 4087336514 6302 6290 UNIFORMS&CLOTHING SOLID WASTE OPERATIONS 06300 08 44.59 JUN'21 WEEKLY UNIFORM SERVICES 194808 4087336514 6402 6290 UNIFORMS&CLOTHING STORM WATER UTILITY OPERA 06400 08 44.05 JUN'21 WEEKLY UNIFORM SERVICES 194808 4087336514 6502 6290 UNIFORMS&CLOTHING WATER UTILITY EXPENSE 06500 08 800.94 155338 7/2/2021 118117 COMMERCIAL DOOR SYSTEMS INC 1,199.87 DT NEW LOC-BUILDOUT COSTS 194864 0154478-IN 6110 7020 OTHER CONSTRUCTION COSTS DOWNTOWN LIQUOR REV&EXP 06100 02 77.18- 194864 0154478-IN 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 1,122.69 155339 7/2/2021 100081 DAKOTA COUNTY LUMBER COMPANY 9.05 CONCRETE TUBE FOR SIGNS 194768 2106-805667 1090 6254 SIGNS&STRIPING MATERIALS PARK MAINTENANCE 01000 09 5.78 CONCRETE TUBE FOR SIGNS 194769 2106-805670 1090 6254 SIGNS&STRIPING MATERIALS PARK MAINTENANCE 01000 09 14.83 155340 7/2/2021 117201 DIAMOND VOGEL PAINT CENTER- 807 1,365.30 STRIPING PAINT 194428 807076025 1072 6254 SIGNS&STRIPING MATERIALS STREET MAINTENANCE 01000 08 1,365.30 155341 7/2/2021 100057 DICK'S SANITATION SERVICE 506.02 DT NEW LOC-ROLLOFF DUMPSTER 194860 DT0003975322 6110 7020 OTHER CONSTRUCTION COSTS DOWNTOWN LIQUOR REV&EXP 06100 02 506.02 155342 7/2/2021 100149 ECM PUBLISHERS,INC 22.00 PC PH:209 OAK STREET SALE 194331 838264 1030 6455 LEGAL NOTICES PLANNING&ZONING 01000 03 22.00 155343 7/2/2021 100270 EMERGENCY MEDICAL PRODUCTS INC 3,109.71 MEDICAL SUPPLIES STOCK 194561 2260810 1060 6250 OTHER SUPPLIES&PARTS FIRE SERVICES 01000 06 10.63- 02 REGULATOR PART RETURN 2012 194707 122298 CR 1051 6220 EQUIP SUPPLIES&PARTS PATROL SERVICES 01000 05 3,099.08 155344 7/2/2021 109931 FACTORY MOTOR PARTS 116.52 BATTERY FOR 0917 194594 1-Z25966 1090 6230 VEHICLE SUPPLIES&PARTS PARK MAINTENANCE 01000 09 116.52 155345 7/2/2021 100551 FARMINGTON GREENHOUSE/FLORAL,INC. 1,278.50 HANGING BASKETS AND FLOWER POT 194820 4220 1090 6255 LANDSCAPING MATERIALS PARK MAINTENANCE 01000 09 1,278.50 155346 7/2/2021 109458 FARMINGTON MUNICIPAL LIQUORS 200.00 20 YR EE REC RON LEY 194745 20 YR EE REC RON 1011 7420 OTHER HUMAN RESOURCES 01000 04 R55CKS2 LOGIS600V CITY OF FARMINGTON 7/14/2021 9:33:37 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 17 6/16/2021 - 7/14/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept Div LEY 200.00 155347 7/2/2021 100077 FRONTIER COMMUNICATIONS 97.71 JUN'21 WELL HOUSE LINE 194842 651-460-4974 7400 6411 TELEPHONE/CABLE SERVICES INFORMATION TECHNOLOGY 07400 04 JUNE'21 97.71 155348 7/2/2021 110895 GALLAGHER BENEFIT SERVICES,INC 1,200.00 POSITION CLASSIFICATION EVAL 194859 202130956 1011 6401 PROFESSIONAL SERVICES HUMAN RESOURCES 01000 04 1,200.00 155349 7/2/2021 118113 HEDDINGER,LAURIE 500.00 RRC DEP RFND:HEDDINGER 194744 061221 1000 2255 DEPOSITS PAYABLE GENERAL FUND BALANCE SHEE 01000 500.00 155350 7/2/2021 100074 HOHENSTEINS INC 1,334.00 BEER ORDER 194871 418099 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 488.80 BEER ORDER 194927 420071 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,822.80 155351 7/2/2021 105641 INSIGHT PUBLIC SECTOR 456.84 18 OFFICE365 G1 LICENSES-LQ 194553 1100842091 7400 6505 EQUIPMENT REPAIR/MAINTENANCE INFORMATION TECHNOLOGY 07400 04 456.84 155352 7/2/2021 100031 JIRIK SOD FARMS,INC 85.00 EROSION BLANKET REPAIR MAIN 194815 47386 6502 6255 LANDSCAPING MATERIALS WATER UTILITY EXPENSE 06500 08 45.00 EROSION BLANKET REPAIR MAIN 194816 47398 6502 6255 LANDSCAPING MATERIALS WATER UTILITY EXPENSE 06500 08 130.00 155353 7/2/2021 109846 JJ TAYLOR DISTRIBUTING COMPANY OF MN INC 1,260.50 BEER ORDER 194848 3191185 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 6,497.69 BEER ORDER 194866 3191184 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 9.00- BEER ORDER CREDIT 194898 3191134 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,294.35 BEER ORDER 194923 3200471 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 387.20 BEER ORDER 194924 3200429 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 9,430.74 155354 7/2/2021 100033 JOHNSON BROTHERS LIQUOR COMPANY 56.66 WINE ORDER 194850 1823445 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 333.74 LIQUOR&SPIRITS ORDER 194651 1823446 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 154.50 LIQUOR&SPIRITS ORDER 194852 1823447 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 113.32 WINE ORDER 194853 1823448 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 .13- FREIGHT CHARGE 194856 148766 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 97.02 LIQUOR&SPIRITS ORDER 194857 1823443 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 37.51 LIQUOR&SPIRITS ORDER 194858 1823444 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 R55CKS2 LOGIS600V CITY OF FARMINGTON 7/14/2D21 9:33:37 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 18 6/16/2021 - 7/14/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 940.65 WINE ORDER 194882 1822473 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,099.75 LIQUOR&SPIRITS ORDER 194883 1822472 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 15.00- LIQUOR&SPIRITS ORDER CREDIT 194884 144392 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 6.17- LIQUOR&SPIRITS ORDER CREDIT 194885 142780 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 13.08- LIQUOR&SPIRITS ORDER CREDIT 194886 142779 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 522.11 WINE ORDER 194887 1823249 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 38.51 LIQUOR&SPIRITS ORDER 194888 1823248 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,832.72 LIQUOR&SPIRITS ORDER 194889 1823247 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,039.27 WINE ORDER 194890 1823246 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 457.76 LIQUOR&SPIRITS ORDER 194891 1823245 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 3,280.53 LIQUOR&SPIRITS ORDER 194892 1823244 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 23.69- LIQUOR&WINE CREDIT 194929 152229 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 3.84- LIQUOR&SPIRITS ORDER CREDIT 194930 151543 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 835.30 LIQUOR&SPIRITS ORDER 194931 1827597 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 331.59 LIQUOR&SPIRITS ORDER 194943 1833339 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 318.57 WINE ORDER 194944 1833340 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 65.90 WINE ORDER 194945 1833341 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 171.02 LIQUOR&SPIRITS ORDER 194946 1833342 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 251.36 WINE ORDER 194947 1833343 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 180.90- WINE ORDER CREDIT 194956 152335 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 11,734.98 155355 7/2/2021 113240 JOHNSON REILAND BUILDERS 9,000.00 ER 101 3RD ST 194907 ER 101 3RD ST 4600 2255 DEPOSITS PAYABLE PRIVATE CAPITAL PROJECTS 04600 07 9,000.00 155356 7/2/2021 100109 LAKEVILLE TROPHY COMPANY 145.32 DEW RUN MEDALS 194802 26325 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 010DO 09 145.32 155357 7/2/2021 117973 LAWRENCE,GREGG 20.00 BOILER LICENSE:LAWRENCE,G. 194753 20210610 LAWRENCE1015 6460 MEMBER DUES&LICENSURE CITY HALL 01000 01 20.00 155358 7/2/2021 100354 LEAGUE OF MN CITIES INSURANCE TRUST 50,289.00 2ND INSTALL 2021 P&L INS PREM. 194275 10003113 060421 7100 6426 INSURANCE INSURANCE 07100 02 79,380.00 3RD INSTALL 2021 WRKS COMP 194276 10002620 060421 7000 6159 WORKERS COMP EMPLOYEE EXPENSE FUND 07000 02 129,669.00 155359 7/2/2021 115622 LONE OAK STORES LLC 50.00 25 YR EE REC JIM MURPHY 194747 25 YR EE REC JIM 1011 7420 OTHER HUMAN RESOURCES 01000 04 MURPHY 50.00 166360 7/2/2021 113199 LUBE-TECH&PARTNERS,LLC R55CKS2 LOGIS600V CITY OF FARMINGTON 7/14/2021 9:33:37 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 19 6/16/2021 - 7/14/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 253.94 DIESEL EXHAUST FLUID 194310 2634192 6302 6274 LUBRICANTS&ADDITIVES SOLID WASTE OPERATIONS 06300 08 16.34- 194310 2634192 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 237.60 155361 7/2/2021 108716 MED COMPASS 625.00 ANNUAL EMPLOYEE HEARING TEST 194846 39498 1050 6405 EMPLOYMENT TESTING POLICE ADMINISTRATION 01000 05 625.00 155362 7/2/2021 100070 MINNESOTA VALLEY TESTING LABORATORIES 25.00 BAC-T SAMPLE(1) 194432 1091536 6502 6535 OTHER REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 71.00 BAC-T SAMPLE(6)&MTHLY REPRT 194433 1091537 6502 6535 OTHER REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 96.00 155363 7/2/2021 102249 MN FIRE SERVICE CERTIFICATION BOARD 1,200.00 FIRE OFFICER 1 TESTING FEE 194839 9055 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01000 06 1,20D.00 155364 7/212021 109197 NATIONAL COUNCIL ON AGING 145.00 NTL INST SR CTRS MEMBERSHIP 194793 3433 -2021 MBR 1093 6460 MEMBER DUES&LICENSURE SENIOR CITIZEN SERVICES 01000 09 RENEWAL 145.00 155365 7/2/2021 108745 NICOLAI,DAVID 3,000.00 ER 22425 CAMBRIAN CT 194909 ER 22425 CAMBRIAN 4600 2255 DEPOSITS PAYABLE PRIVATE CAPITAL PROJECTS 04600 07 CT 3,000.00 155366 7/2/2021 102644 NORTHERN SAFETY TECHNOLOGY,INC 292.50 BEACONS FOR MOWERS 194593 52479 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 292.50 155367 7/2/2021 100290 PAUSTIS&SONS WINE COMPANY 180.50 WINE ORDER 194876 130133 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 129.25 WINE ORDER 194897 130132 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 309.75 155368 7/2/2021 100093 PELLICCI HARDWARE&RENTAL 6.43 GLADE SPRAYNIREX II RTD 5L 194268 K44487/F 6502 6242 CLEANING SUPPLIES WATER UTILITY EXPENSE 06500 08 8.43 GLADE SPRAYNIREX II RTD 5L 194268 K44487/F 6402 6242 CLEANING SUPPLIES STORM WATER UTILITY OPERA 06400 08 .58- 194268 K44487/F 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 9.01 GLADE SPRAYNIREX II RTD 51- 194268 K44487/F 6302 6242 CLEANING SUPPLIES SOLID WASTE OPERATIONS 06300 08 8.43 GLADE SPRAYNIREX II RTD 5L 194268 K44487/F 6202 6242 CLEANING SUPPLIES SEWER OPERATIONS EXPENSE 06200 08 21.08 GLADE SPRAYNIREX II RTD 51- 194268 K44487/F 1050 6242 CLEANING SUPPLIES POLICE ADMINISTRATION 01000 05 21.08 GLADE SPRAYNIREX II RTD 51- 194268 K44487/F 1093 6242 CLEANING SUPPLIES SENIOR CITIZEN SERVICES 01000 09 8.43 GLADE SPRAYNIREX II RTD 5L 194268 K44487/F 1090 6242 CLEANING SUPPLIES PARK MAINTENANCE 01000 09 42.17 GLADE SPRAYNIREX 11 RTD 5L 194268 K44487/F 1072 6242 CLEANING SUPPLIES STREET MAINTENANCE 01000 08 R55CKS2 LOGIS600V CITY OF FARMINGTON 7/14/2021 9:33:37 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 20 6/16/2021 - 7/14/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 21.08 GLADE SPRAYNIREX II RTD 5L 194268 K44487/F 1060 6242 CLEANING SUPPLIES FIRE SERVICES 01000 06 21.11 GLADE SPRAYNIREX II RTD 5L 194268 K44487/F 1015 6242 CLEANING SUPPLIES CITY HALL 01000 01 35.97 AIR FILTERSNALVE BALL 194272 K44538/F 2502 6240 BUILDING SUPPLIES&PARTS ICE ARENA OPERATIONS EXPE 02500 09 21.98 LAMBSWOOLAPPLCTR/MOP PAD 194281 44531/F 1015 6240 BUILDING SUPPLIES&PARTS CITY HALL 01000 01 39.98 WEED WHIP PARTS 194284 K44557/F 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 52.79 FUNNELAND TUBE FOR WATER LEAK 194285 K44563/F 2502 6220 EQUIP SUPPLIES&PARTS ICE ARENA OPERATIONS EXPE 02500 09 4.99 TAPE FOR FLOODING 194287 K44568/F 2502 6220 EQUIP SUPPLIES&PARTS ICE ARENA OPERATIONS EXPE 02500 09 9.99 MAGNET PICKUP TOOL 194305 K44572/F 1072 6950 MACHINERY,EQUIPMENT&TOOLS STREET MAINTENANCE 01000 08 14.99 CLEANING TOWELS 194427 K44647/F 1072 6242 CLEANING SUPPLIES STREET MAINTENANCE 01000 08 26.97 CONCRETE MIX 194430 K44664/F 6402 6250 OTHER SUPPLIES&PARTS STORM WATER UTILITY OPERA 06400 08 19.99 CIRCULATOR FAN 194431 K44682/F 6502 6950 MACHINERY,EQUIPMENT&TOOLS WATER UTILITY EXPENSE 06500 08 27.96 CONCRETE MIX 194443 K44699/F 6402 6250 OTHER SUPPLIES&PARTS STORM WATER UTILITY OPERA 06400 08 42.81 RUBBER MALLETS-160Z&320Z 194445 K44689/F 6110 7020 OTHER CONSTRUCTION COSTS DOWNTOWN LIQUOR REV&EXP 06100 02 28.96 DAWN SOAP/BRUSH:GREASE REMOVAL 194510 44551/F'21 1093 6242 CLEANING SUPPLIES SENIOR CITIZEN SERVICES 01000 09 11.99- PAINT ROLLER RETURN 194516 K44604/F CR 1015 6240 BUILDING SUPPLIES&PARTS CITY HALL 01000 01 14.99 FERTILZER FOR FLOWERS 194517 44602/F 1090 6255 LANDSCAPING MATERIALS PARK MAINTENANCE 01000 09 .98 GLADE SPRAY/CLR/KEY RING 194521 K44631/F 6502 6242 CLEANING SUPPLIES WATER UTILITY EXPENSE 06500 08 .98 GLADE SPRAY/CLR/KEY RING 194521 K44631/F 6402 6242 CLEANING SUPPLIES STORM WATER UTILITY OPERA 06400 08 .07- 194521 K44631/F 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 1.05 GLADE SPRAY/CLR/KEY RING 194521 K44631/F 6302 6242 CLEANING SUPPLIES SOLID WASTE OPERATIONS 06300 08 .98 GLADE SPRAY/CLR/KEY RING 194521 K44631/F 6202 6242 CLEANING SUPPLIES SEWER OPERATIONS EXPENSE 06200 08 2.45 GLADE SPRAY/CLR/KEY RING 194521 K44631/F 1050 6242 CLEANING SUPPLIES POLICE ADMINISTRATION 01000 05 2.45 GLADE SPRAY/CLR/KEY RING 194521 K44631/F 1093 6242 CLEANING SUPPLIES SENIOR CITIZEN SERVICES 01000 09 .98 GLADE SPRAY/CLR/KEY RING 194521 K44631/1' 1090 6242 CLEANING SUPPLIES PARK MAINTENANCE 01000 09 4.89 GLADE SPRAY/CLR/KEY RING 194521 K44631/1' 1072 6242 CLEANING SUPPLIES STREET MAINTENANCE 01000 08 2.45 GLADE SPRAY/CLR/KEY RING 194521 K44631/1' 1060 6242 CLEANING SUPPLIES FIRE SERVICES 01000 06 2.42 GLADE SPRAY/CLR/KEY RING 194521 K44631/F 1015 6242 CLEANING SUPPLIES CITY HALL 01000 01 25.17 GLOVES FOR SEASONAL WORKER 194522 K44645/F 1090 629D UNIFORMS&CLOTHING PARK MAINTENANCE 01000 09 250.00 CALBE TIES FOR FLAGS DOWNTOWN 194525 9757/1' 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 26.98 FIRE 1:SC KT ADPTR/SCRWD RIVER 194555 K44578/F 1060 6950 MACHINERY,EQUIPMENT&TOOLS FIRE SERVICES 01000 06 12.46 OUTLET PARTS FIRE ST 2 194563 K44697/F 1060 6240 BUILDING SUPPLIES&PARTS FIRE SERVICES 01000 06 5.99 DROP CLOTH 194602 K44723/F 1072 6220 EQUIP SUPPLIES&PARTS STREET MAINTENANCE 01000 08 49.99 HIGH VELCTY FAN:WELL 194603 K44727/F 6502 6950 MACHINERY,EQUIPMENT&TOOLS WATER UTILITY EXPENSE 06500 08 29.98 GARBAGE BAGS 194682 K44744/F 2502 6242 CLEANING SUPPLIES ICE ARENA OPERATIONS EXPE 02500 09 3.50 BATHROOM CLEANER 194683 K44742/F 6502 6242 CLEANING SUPPLIES WATER UTILITY EXPENSE 06500 08 3.50 BATHROOM CLEANER 194683 K44742/F 6402 6242 CLEANING SUPPLIES STORM WATER UTILITY OPERA 06400 08 .24- 194683 K44742/F 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 3.74 BATHROOM CLEANER 194683 K44742/F 6302 6242 CLEANING SUPPLIES SOLID WASTE OPERATIONS 06300 08 3.60 BATHROOM CLEANER 194683 K44742/F 6202 6242 CLEANING SUPPLIES SEWER OPERATIONS EXPENSE 06200 08 8.75 BATHROOM CLEANER 194683 K44742/F 2502 6242 CLEANING SUPPLIES ICE ARENA OPERATIONS EXPE 02500 09 8.75 BATHROOM CLEANER 194683 K44742/F 1093 6242 CLEANING SUPPLIES SENIOR CITIZEN SERVICES 01000 09 3.50 BATHROOM CLEANER 194683 K44742/F 1090 6242 CLEANING SUPPLIES PARK MAINTENANCE 01000 09 R55CKS2 LOGIS600V CITY OF FARMINGTON 7/14/2021 9:33:37 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 21 6/16/2021 - 7/14/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 17.50 BATHROOM CLEANER 194683 K44742/F 1072 6242 CLEANING SUPPLIES STREET MAINTENANCE 01000 08 8.75 BATHROOM CLEANER 194683 K44742/F 1060 6242 CLEANING SUPPLIES FIRE SERVICES 01000 06 8.75 BATHROOM CLEANER 194683 K44742/F 1015 6242 CLEANING SUPPLIES CITY HALL 01000 01 28.97 WALLANCHORS AND SHELF BRACKET 194685 K44773/F 1015 6240 BUILDING SUPPLIES&PARTS CITY HALL 01000 01 16.52 KEYS:NUTS/BOLTS 194686 K44793/F 2502 6240 BUILDING SUPPLIES&PARTS ICE ARENA OPERATIONS EXPE 02500 09 17.62 FLOOR CLNR/TRSH CADDY/KEY 194687 17227/F 1015 6242 CLEANING SUPPLIES CITY HALL 01000 01 17.63 FLOOR CLNR/TRSH CADDY/KEY 194687 17227/F 1060 6242 CLEANING SUPPLIES FIRE SERVICES 01000 06 .48- 194687 17227/F 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 35.26 FLOOR CLNR/TRSH CADDY/KEY 194687 17227/F 1072 6242 CLEANING SUPPLIES STREET MAINTENANCE 01000 08 7.05 FLOOR CLNR/TRSH CADDY/KEY 194687 17227/F 1090 6242 CLEANING SUPPLIES PARK MAINTENANCE 01000 09 17.63 FLOOR CLNR/TRSH CADDY/KEY 194687 17227/F 1093 6242 CLEANING SUPPLIES SENIOR CITIZEN SERVICES 01000 09 17.63 FLOOR CLNR/TRSH CADDY/KEY 194687 17227/F 1050 6242 CLEANING SUPPLIES POLICE ADMINISTRATION 01000 05 7.05 FLOOR CLNR/TRSH CADDY/KEY 194687 17227/F 6202 6242 CLEANING SUPPLIES SEWER OPERATIONS EXPENSE 06200 08 7.53 FLOOR CLNR/TRSH CADDY/KEY 194687 17227/F 6302 6242 CLEANING SUPPLIES SOLID WASTE OPERATIONS 06300 08 7.05 FLOOR CLNR/TRSH CADDY/KEY 194687 17227/1' 6402 6242 CLEANING SUPPLIES STORM WATER UTILITY OPERA 06400 08 7.05 FLOOR CLNR/TRSH CADDY/KEY 194687 17227/F 6502 6242 CLEANING SUPPLIES WATER UTILITY EXPENSE 06500 08 5.98 KEY HOLDER 194688 K44795/F 2502 6240 BUILDING SUPPLIES&PARTS ICE ARENA OPERATIONS EXPE 02500 09 26.77 STRETCH FILM CLR PK 4 194698 K44819/F 6110 6250 OTHER SUPPLIES&PARTS DOWNTOWN LIQUOR REV&EXP 06100 02 64.99 GRASS SEED 194716 K44810/1' 6502 6255 LANDSCAPING MATERIALS WATER UTILITY EXPENSE 06500 08 3.89 WELL 5 SOFFIT SUPPLIES 194718 K44821/F 6502 6240 BUILDING SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 19.96 PARTY IN PARK SUPPLIES 194739 K448201F 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 27.96 PAINT FOR DEW RUN ROUTE 194743 K44710/F 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 8.99 CONCRETE MIX 194758 K44890/F 6402 6250 OTHER SUPPLIES&PARTS STORM WATER UTILITY OPERA 06400 08 79.40 BASKETBALL NETS:QTY 20 194767 16241/F 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 37.98 HAMMER/PRY BAR 194774 K44859/F 1090 6950 MACHINERY,EQUIPMENT&TOOLS PARK MAINTENANCE 01000 09 124.97 SPADE FORK/BEDDING FORK 194777 K44847JF 1090 6950 MACHINERY,EQUIPMENT&TOOLS PARK MAINTENANCE 01000 09 39.97 KNEE PADS/PRM SEAM TAPE 194777 K44847/F 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 2.37 GOO GONE AND ANT TRAPS 194794 44898/F'21 1015 6240 BUILDING SUPPLIES&PARTS CITY HALL 01000 01 2.37 GOO GONEAND ANT TRAPS 194794 44898/1''21 1060 6240 BUILDING SUPPLIES&PARTS FIRE SERVICES 01000 06 .07- 194794 44898/F'21 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 4.75 GOO GONE AND ANT TRAPS 194794 44698/F'21 1072 6240 BUILDING SUPPLIES&PARTS STREET MAINTENANCE D10D0 08 .95 GOO GONE AND ANT TRAPS 194794 44898/F'21 1090 6240 BUILDING SUPPLIES&PARTS PARK MAINTENANCE 01000 09 2.37 GOO GONE AND ANT TRAPS 194794 44898/F'21 1093 6240 BUILDING SUPPLIES&PARTS SENIOR CITIZEN SERVICES 01000 09 2.37 GOO GONE AND ANT TRAPS 194794 44898/F'21 2502 6240 BUILDING SUPPLIES&PARTS ICE ARENA OPERATIONS EXPE 02500 09 .95 GOO GONE AND ANT TRAPS 194794 44898/F'21 6202 6240 BUILDING SUPPLIES&PARTS SEWER OPERATIONS EXPENSE 06200 08 1.02 GOO GONEANDANTTRAPS 194794 44898/F'21 6302 6240 BUILDING SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 .95 GOO GONE AND ANT TRAPS 194794 44898/F'21 6402 6240 BUILDING SUPPLIES&PARTS STORM WATER UTILITY OPERA 06400 08 .95 GOO GONE AND ANT TRAPS 194794 44898/F'21 6502 6240 BUILDING SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 31.96 TRUCK HOSES 194796 K44921/F 6302 6230 VEHICLE SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 2.06- 194796 K44921/F 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 69.97 PAPER TOWELS 194809 37947/1' 1015 6242 CLEANING SUPPLIES CITY HALL 01000 01 69.99 PAPER TOWELS 194809 37947/1' 1060 6242 CLEANING SUPPLIES FIRE SERVICES 01000 06 R55CKS2 LOGIS600V CITY OF FARMINGTON 7/14/2021 9:33:37 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 22 6/16/2021 - 7/14/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 1.93- 194809 37947/1' 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 139.98 PAPER TOWELS 194809 37947/1' 1072 6242 CLEANING SUPPLIES STREET MAINTENANCE 01000 08 28.00 PAPER TOWELS 194809 37947/1' 1090 6242 CLEANING SUPPLIES PARK MAINTENANCE 01000 09 69.99 PAPER TOWELS 194809 37947/F 1093 6242 CLEANING SUPPLIES SENIOR CITIZEN SERVICES 01000 09 69.99 PAPER TOWELS 194809 37947/F 1050 6242 CLEANING SUPPLIES POLICE ADMINISTRATION 01000 05 28.00 PAPER TOWELS 194809 37947/F 6202 6242 CLEANING SUPPLIES SEWER OPERATIONS EXPENSE 06200 08 29.93 PAPER TOWELS 194809 37947/F 6302 6242 CLEANING SUPPLIES SOLID WASTE OPERATIONS 06300 08 28.00 PAPER TOWELS 194809 37947/F 6402 6242 CLEANING SUPPLIES STORM WATER UTILITY OPERA 06400 08 28.00 PAPER TOWELS 194809 37947/F 6502 6242 CLEANING SUPPLIES WATER UTILITY EXPENSE 06500 08 19.68 GLADE SPRAY/DISP GLOVES 194817 40903/F 1015 6242 CLEANING SUPPLIES CITY HALL 01000 01 19.68 GLADE SPRAY/DISP GLOVES 194817 40903/F 1060 6242 CLEANING SUPPLIES FIRE SERVICES 01000 06 .54- 194817 40903/F 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 39.36 GLADE SPRAY/DISP GLOVES 194817 4D903/F 1072 6242 CLEANING SUPPLIES STREET MAINTENANCE 01000 08 7.87 GLADE SPRAY/DISP GLOVES 194817 40903/F 1090 6242 CLEANING SUPPLIES PARK MAINTENANCE 01000 09 19.68 GLADE SPRAY/DISP GLOVES 194817 4D903/F 1093 6242 CLEANING SUPPLIES SENIOR CITIZEN SERVICES 01000 09 19.69 GLADE SPRAY/DISP GLOVES 194817 40903/F 1050 6242 CLEANING SUPPLIES POLICE ADMINISTRATION 01000 05 7.87 GLADE SPRAY/DISP GLOVES 194817 40903/1' 6202 6242 CLEANING SUPPLIES SEWER OPERATIONS EXPENSE 06200 08 8.41 GLADE SPRAY/DISP GLOVES 194817 40903/1' 6302 6242 CLEANING SUPPLIES SOLID WASTE OPERATIONS 06300 08 7.87 GLADE SPRAY/DISP GLOVES 194817 40903/1 6402 6242 CLEANING SUPPLIES STORM WATER UTILITY OPERA 06400 08 7.87 GLADE SPRAY/DISP GLOVES 194817 40903/F 6502 6242 CLEANING SUPPLIES WATER UTILITY EXPENSE 06500 08 15.96 PAINT TO COVER GRAFFITI 194818 K44953/F 1090 6540 VANDALISM PARK MAINTENANCE 01000 09 22.41 HANDLES FOR CAMERON WOODS 194826 K44992/F 6302 6220 EQUIP SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 1.44- 194826 K44992/F 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 13.98 STRAPS FOR UTV 194834 K44868/F 1060 6220 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 9.99 BLOWOFF DUSTER 194835 44879/F'21 1060 6220 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 19.99 32 GAL TRASH CAN:FIRE#1 194836 K44957/F 1060 6960 FURNITURE,OFFICE EQUIP,IT FIRE SERVICES 01000 06 16.98 VEHICLE LUBRICATION MATERIALS 194837 K44961/F 1060 6274 LUBRICANTS&ADDITIVES FIRE SERVICES 01000 06 74.99 GRASS SEED FOR ST 1 194838 K44973/F 1060 6255 LANDSCAPING MATERIALS FIRE SERVICES 01000 06 3.99 GARAGE DOOR REPAIR PART 194840 K44997/F 1060 6240 BUILDING SUPPLIES&PARTS FIRE SERVICES 01000 06 20.05 BOX CUTTER/BLADES 194902 K44914/F 6115 6220 EQUIP SUPPLIES&PARTS PILOT KNOB LIQUOR 06100 02 112.47 HAND TRUCK(3) 194910 18129/1' 6110 6950 MACHINERY,EQUIPMENT&TOOLS DOWNTOWN LIQUOR REV&EXP 06100 02 112.46 HAND TRUCK(3) 194910 18129/F 6115 6950 MACHINERY,EQUIPMENT&TOOLS PILOT KNOB LIQUOR 06100 02 31.37 CARTON SEAL TAPE 194911 K44852/F 6110 6220 EQUIP SUPPLIES&PARTS DOWNTOWN LIQUOR REV&EXP 06100 02 21.41 GARDEN KNEELER(2) 194957 K45126/F 6110 6220 EQUIP SUPPLIES&PARTS DOWNTOWN LIQUOR REV&EXP 06100 02 3.20 GLASS CLEANER 194957 K45126/F 6110 6242 CLEANING SUPPLIES DOWNTOWN LIQUOR REV&EXP 06100 02 14.97 SPRAY PAINT 194958 K45032/F 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 2,875.57 155369 7/2/2021 100034 PHILLIPS WINE AND SPIRITS,INC 29.18 LIQUOR&SPIRITS ORDER 194854 6221087 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 244.70 WINE ORDER 194855 6221088 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 45.51- WINE ORDER CREDIT 194893 633347 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 R55CKS2 LOGIS600V CITY OF FARMINGTON 7/14/2021 9:33:37 Note:.Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 23 6/16/2021 - 7/14/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 664.73 LIQUOR&SPIRITS ORDER 194894 6220938 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 182.04 WINE ORDER 194895 6220939 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 351.78 LIQUOR&SPIRITS ORDER 194948 6228983 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 232.70 WINE ORDER 194949 6228984 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,659.62 155370 7/2/2021 100196 QUALITY REFRIGERATION INC 396.28 WALK IN COOLER REPAIR 194913 0090794 6115 6505 EQUIPMENT REPAIR/MAINTENANCE PILOT KNOB LIQUOR 06100 02 396.28 155371 7/2/2021 103239 RCM SPECIALTIES INC 41.86 EMULSION 194799 7990 1072 6253 STREET MATERIALS STREET MAINTENANCE 01000 08 71.76 EMULSION 194800 8007 1072 6253 STREET MATERIALS STREET MAINTENANCE 01000 08 113.62 155372 7/2/2021 112561 RICOH USA,INC 22.03 JUL'21 COPIER FAX CARD LEASE 194843 105088179 1010 6555 RENTAL OF EQUIPMENT ADMINISTRATION 01000 01 865.08 JUL'21 COPIER LEASES 194843 105088179 1010 6555 RENTAL OF EQUIPMENT ADMINISTRATION 01000 01 948.88 JUL'21 COPIER LEASES 194844 105074649 1010 6555 RENTAL OF EQUIPMENT ADMINISTRATION 01000 01 1,835.99 155373 7/2/2021 117089 ROCK HARD LANDSCAPE SUPPLY 54.00 MULCH-2YD 194508 1015046 1090 6255 LANDSCAPING MATERIALS PARK MAINTENANCE 01000 09 54.00 MULCH-2YD 194520 1015586 1090 6255 LANDSCAPING MATERIALS PARK MAINTENANCE 01000 09 54.00 MULCH-2YD 194523 1015928 1090 6255 LANDSCAPING MATERIALS PARK MAINTENANCE 01000 09 54.00 MULCH-2YD 194524 1016016 1090 6255 LANDSCAPING MATERIALS PARK MAINTENANCE 01000 09 108.00 MULCH-4YD 194526 1016416 1090 6255 LANDSCAPING MATERIALS PARK MAINTENANCE 01000 09 54.00 MULCH FOR PARK SIGNS 194667 1016714 1090 6255 LANDSCAPING MATERIALS PARK MAINTENANCE 01000 09 378.00 165374 7/2/2021 118118 SAFETYFIRST PLAYGROUND MAINTENANCE 4,169.00 WOOD FIBER FOR PLAYGROUNDS 194795 7536 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 4,169.00 155375 7/2/2021 107018 SHAMROCK GROUP 142.37 ICE CUBE ORDER 194849 2632373 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 101.05 ICE CUBE ORDER 194869 2635066 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 198.41 ICE CUBE ORDER 194870 2632371 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 69.02 ICE CUBE ORDER 194954 2639911 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 149.17 ICE CUBE ORDER 194955 2640916 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 660.02 165376 7/2/2021 112061 SOUTHERN GLAZER'S OF MN 2,070.51 LIQUOR&SPIRITS ORDER 194865 2092094 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1.49 DELIVERY CHARGE 194880 2092093 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 470.24 WINE ORDER 194881 2092095 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 R55CKS2 LOGIS600V CITY OF FARMINGTON 7/14/2021 9:33:37 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 24 6/16/2021 - 7/14/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept Div 142.56 WINE ORDER 194899 2092088 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 270.28 LIQUOR&SPIRITS ORDER 194900 2092087 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 244.40 WINE ORDER 194950 2096815 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,418.34 LIQUOR&SPIRITS ORDER 194951 2096816 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 4,617.82 155377 7/2/2021 100519 TC CONSTRUCTION,INC 3,000.00 ER 6664 UPPER 210TH ST W 194908 ER 6664 UPPER 4600 2255 DEPOSITS PAYABLE PRIVATE CAPITAL PROJECTS 04600 07 210TH ST W 3,000.00 155378 7/2/2021 117486 TOM'S PRO GLASS 680.95 WINDSHIELD FOR 0583 194764 7367 1051 6510 1 OUTSIDE VEHICLE REPAIR/MAINT PATROL SERVICES 01000 05 680.95 155379 7/2/2021 116302 TOWN SPORTS,LLC 1,600.00 QTY:280 DEW RUN SHIRTS 194766 20210613 DEW RUN 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 SHIRTS 114.75 STAFF SHIRT REC FROG 194792 20210611 1095 6290 UNIFORMS&CLOTHING RECREATION PROGRAM SERVIC 01000 09 1,714.75 155380 7/2/2021 118106 TREEBIZ LLC 8,192.85 ARROW GOLD RTK-GPS UNIT/POLE 194741 957 7400 6950 MACHINERY,EQUIPMENT&TOOLS INFORMATION TECHNOLOGY 07400 04 8,192.85 155381 7/2/2021 113269 UNIVERSITY OF MN,REGENTS OF 687.50 JUN 1 2021 RANGE RENTAL 194847 0430005833 1051 6470 TRAINING&SUBSISTANCE PATROL SERVICES 01000 05 687.50 155382 7/2/2021 109418 VALLEY-RICH CO,INC 12,722.63 WATER MAIN REPAIR 4300 200TH 194918 29523 6502 6535 OTHER REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 12,722.63 155383 7/2/2021 118116 WENCL SERVICES 1,000.00 DT NEW LOC-REROUTE DUCTWRK 194863 87137-1 6110 7020 OTHER CONSTRUCTION COSTS DOWNTOWN LIQUOR REV&EXP 06100 02 1,000.00 155384 7/9/2021 100011 ANDERSEN,EARL F 81.15 NO SKATE BOARDING SIGN 194969 0125775-IN 1093 6240 BUILDING SUPPLIES&PARTS SENIOR CITIZEN SERVICES 01000 09 81.15 155385 7/9/2021 113303 ARTISAN BEER COMPANY 35.60 BEER ORDER 195051 3480394 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,152.60 BEER ORDER 195052 3480393 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 447.40 BEER ORDER 195087 3481762 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,635.60 155386 7/9/2021 108446 ASPEN MILLS,INC. R55CKS2 LOGIS600V CITY OF FARMINGTON 7/14/2021 9:33:37 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 25 6/16/2021 - 7/14/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept Div 24.35 UNIFORM ITEMS:MATTINGLY,S 194970 275921 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 24.35 155387 7/9/2021 118134 BARTLEY SALES COMPANY,INC 290.00 DT LIQ BLDOUT TOILETACCESSOR 195043 145640 6110 7020 OTHER CONSTRUCTION COSTS DOWNTOWN LIQUOR REV&EXP 06100 02 290.00 155388 7/9/2021 114472 BREAKTHRU BEVERAGE MN BEER,LLC 37.75 WINE ORDER 195076 339985398 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 14,530.05 BEER ORDER 195083 339985397 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 37.75 WINE ORDER 195123 339985399 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 14,605.55 155389 7/9/2021 114471 BREAKTHRU BEVERAGE MN WINE&SPIRITS 17.43- LIQUOR&SPIRITS ORDER 195050 408642606 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 53.45 WINE ORDER 195074 339984732 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 121.45 WINE ORDER 195078 339984731 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 855.34 LIQUOR&SPIRITS ORDER 195080 339984729 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 061D0 02 55.30 WINE ORDER 195082 339984730 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,552.93 LIQUOR&SPIRITS ORDER 195085 340077078 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 5,886.42 LIQUOR&SPIRITS ORDER 195093 340076933 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 245.35 LIQUOR&SPIRITS ORDER 195096 340076934 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 146.90 WINE ORDER 195124 339984901 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 8,899.71 155390 7/9/2021 108428 CDW GOVERNMENT LLC 13,473.20 '21 SOPHS WKS/SVR ANTIVRUS SUB 194724 F573409 7400 6505 EQUIPMENT REPAIR/MAINTENANCE INFORMATION TECHNOLOGY 07400 04 13,473.20 155391 7/9/2021 100578 CEMSTONE CONCRETE MATERIALS,LLC 290.00 CATCH BASIN REPAIR 194756 C2355767 6402 6250 OTHER SUPPLIES&PARTS STORM WATER UTILITY OPERA 06400 08 290.00 155392 7/9/2021 100025 CINTAS CORP LOC 754 44.57 JUN'21 WEEKLY UNIFORM SERVICES 195004 4088047895 1072 6290 UNIFORMS&CLOTHING STREET MAINTENANCE 01000 08 44.59 JUN'21 WEEKLY UNIFORM SERVICES 195004 4088047895 1090 6290 UNIFORMS&CLOTHING PARK MAINTENANCE 01000 09 3.07- 195004 4088047895 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 44.59 JUN'21 WEEKLY UNIFORM SERVICES 195004 4088047895 6202 6290 UNIFORMS&CLOTHING SEWER OPERATIONS EXPENSE 06200 08 47.66 JUN'21 WEEKLY UNIFORM SERVICES 195004 4088047895 6302 6290 UNIFORMS&CLOTHING SOLID WASTE OPERATIONS 06300 08 44.59 JUN'21 WEEKLY UNIFORM SERVICES 195004 4088047895 6402 6290 UNIFORMS&CLOTHING STORM WATER UTILITY OPERA 06400 08 44.05 JUN'21 WEEKLY UNIFORM SERVICES 195004 4088047895 6502 6290 UNIFORMS&CLOTHING WATER UTILITY EXPENSE 06500 08 44.57 JUN'21 WEEKLY UNIFORM SERVICES 195018 4D88628326 1072 6290 UNIFORMS&CLOTHING STREET MAINTENANCE 01000 08 44.59 JUN'21 WEEKLY UNIFORM SERVICES 195018 4088628326 1090 6290 UNIFORMS&CLOTHING PARK MAINTENANCE 01000 09 3.07- 195018 4088628326 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 44.59 JUN'21 WEEKLY UNIFORM SERVICES 195018 4088628326 6202 6290 UNIFORMS&CLOTHING SEWER OPERATIONS EXPENSE 06200 08 R55CKS2 LOGIS600V CITY OF FARMINGTON 7/14/2021 9:33:37 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 26 6/16/2021 - 7/14/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 47.66 JUN'21 WEEKLY UNIFORM SERVICES 195018 4088628326 6302 6290 UNIFORMS&CLOTHING SOLID WASTE OPERATIONS 06300 08 44.59 JUN'21 WEEKLY UNIFORM SERVICES 195018 4088628326 6402 6290 UNIFORMS&CLOTHING STORM WATER UTILITY OPERA 06400 08 44.05 JUN'21 WEEKLY UNIFORM SERVICES 195018 4088628326 6502 6290 UNIFORMS&CLOTHING WATER UTILITY EXPENSE 06500 08 533.96 155393 7/9/2021 100456 COMMERCIAL ASPHALT COMPANY 1,275.13 ASPHALT 194814 210615 1072 6253 STREET MATERIALS STREET MAINTENANCE 01000 08 1,275.13 155394 7/9/2021 118117 COMMERCIAL DOOR SYSTEMS INC 275.00 DT LIQ BUILD OUT 195039 0154878-IN 6110 7020 OTHER CONSTRUCTION COSTS DOWNTOWN LIQUOR REV&EXP 06100 02 275.00 155395 7/9/2021 112888 COOL AIR MECHANICAL,INC 6,844.90 NEW CONDENSER 195109 99933 4503 6950 MACHINERY,EQUIPMENT&TOOLS ICE ARENA CAPITAL IMPR FU 04500 09 6,844.90 155396 7/9/2021 100030 CORE&MAIN,LP 200.00 BLUE MARKING FLAGS 194823 P061487 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 110.00 GREEN MARKING FLAGS 194823 P061487 6202 6220 EQUIP SUPPLIES&PARTS SEWER OPERATIONS EXPENSE 06200 08 79.74 HYDRANT PARTS 194991 P077020 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 389.74 155397 7/9/2021 109077 DAKOTA COUNTY CDA 22,750.00 RISTE LOT:CDBG REIMBURSEMENT 195195 RISTE LOT SALE 2000 5360 REFUNDS&REIMBURSEMENTS HRA/ECONOMIC DEVELOPMENT 02000 03 2021 22,750.00 155398 7/9/2021 100081 DAKOTA COUNTY LUMBER COMPANY 22.72 BOARDS FOR EAST FARM SHELTER 195005 2106-807249 1090 6240 BUILDING SUPPLIES&PARTS PARK MAINTENANCE 01000 09 1,542.15 BOARDS FOR EAST FARM ROOF 195016 2106-807905 1090 6240 BUILDING SUPPLIES&PARTS PARK MAINTENANCE 01000 09 1,564.87 155399 7/9/2021 100147 DAKOTA COUNTY TECHNICAL COLLEGE 300.00 STRESE PURSUIT/PIT REFRESHER 195187 831124 1051 6470 TRAINING&SUBSISTANCE PATROL SERVICES 01000 05 300.00 155400 7/9/2021 100057 DICK'S SANITATION SERVICE 8,880.00 JUN'21 WASTE HAULING FEES 195131 DT0004069009 6302 6560 CONTRACTUAL SERVICES SOLID WASTE OPERATIONS 06300 08 952.60 JUN'21 RECYCLING SCHOOLS 195132 DT0004038215 6302 6560 CONTRACTUAL SERVICES SOLID WASTE OPERATIONS 06300 08 13,660.13 JUN-21 RECYCLING COMMERCIAL 195133 DT0004060259 6302 6560 CONTRACTUAL SERVICES SOLID WASTE OPERATIONS 06300 08 46,789.38 JUN-21 RECYCLING RESIDENTIAL 195134 DT0004060260 6302 6560 CONTRACTUAL SERVICES SOLID WASTE OPERATIONS 06300 08 70,282.11 155401 7/9/2021 100149 ECM PUBLISHERS,INC 19.25 JUN'21 PH:FRMNGTN ENTRPRISES 194721 839600 1010 6455 LEGAL NOTICES ADMINISTRATION 01000 01 19.25 R55CKS2 LOGIS600V CITY OF FARMINGTON 7/14/2021 9:33:37 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 27 6/16/2021 - 7/14/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 155402 7/9/2021 109931 FACTORY MOTOR PARTS 2.82 STOCK FILTER 194710 139-060678 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 2.82 STOCK FILTER 194711 74-271236 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 2.82 STOCK FILTER 194712 19-864282 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 5.64 STOCK FILTER 194713 75-410803 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 OB 2.82 STOCK FILTER 194714 112-163479 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 65.88 COOLANT TANK FOR 0552 194715 1-6972284 1051 6230 VEHICLE SUPPLIES&PARTS PATROL SERVICES 01000 05 82.80 155403 7/9/2021 100022 FARMINGTON PRINTING INC 83.50 COPY PAPER 194700 13973 1010 6210 OFFICE SUPPLIES ADMINISTRATION 01000 01 77.00 COPY PAPER 194701 13972 1010 6210 OFFICE SUPPLIES ADMINISTRATION 01000 01 160.50 155404 7/9/2021 103692 FASTENAL COMPANY 148.48- CR:SPRAY PAINT(MNLAK174029) 184296 MNLAK174088 CR 6602 6220 EQUIP SUPPLIES&PARTS STREETLIGHT UTILITY EXPEN 06600 08 49.37 FILTER FOR HVAC UNIT 190478 MNLAK181131 2502 6220 EQUIP SUPPLIES&PARTS ICE ARENA OPERATIONS EXPE 02500 09 49.37 MEDIA ROLL 190733 MNLAK181194 2502 6240 BUILDING SUPPLIES&PARTS ICE ARENA OPERATIONS EXPE 02500 09 301.03 PAINT/FLAGS 194604 MNLAK184766 6202 6220 EQUIP SUPPLIES&PARTS SEWER OPERATIONS EXPENSE 06200 OB 194.49 PAINT/FLAGS 194604 MNLAK184766 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 445.78 155405 7/9/2021 111067 FRONTIER AG&TURF 366.09 GANG MOWER PART 194605 P34830 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 366.09 155406 7/9/2021 100077 FRONTIER COMMUNICATIONS 75.33 JUL'21 ARENAALARM LINE 195008 651-463-3016 2502 6411 TELEPHONE/CABLE SERVICES ICE ARENA OPERATIONS EXPE 02500 09 JUL'21 75.33 156407 7/9/2021 100016 GERSTER JEWELERS 37.00 PLAQUE 195034 009100 1010 6210 OFFICE SUPPLIES ADMINISTRATION 01000 01 37.00 155406 7/9/2021 100044 GRAINGER INC 273.88 DRUM DOLLYS 194773 9936297390 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 OB 277.20 DRUM DOLLYS 194773 9936297390 6402 6220 EQUIP SUPPLIES&PARTS STORM WATER UTILITY OPERA 06400 08 19.06- 194773 9936297390 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 296.26 DRUM DOLLYS 194773 9936297390 6302 6220 EQUIP SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 277.20 DRUM DOLLYS 194773 9936297390 6202 6220 EQUIP SUPPLIES&PARTS SEWER OPERATIONS EXPENSE 06200 08 277.20 DRUM DOLLYS 194773 9936297390 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 277.22 DRUM DOLLYS 194773 9936297390 1072 6220 EQUIP SUPPLIES&PARTS STREET MAINTENANCE 01000 08 1,659.90 R55CKS2 LOGIS600V CITY OF FARMINGTON 7/14/2021 9:33:37 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 28 6/16/2021 - 7/14/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 155409 7/9/2021 116391 GRANICUS,LLC 7,950.00 NOVUS AGENDAANNUAL SUB'21 194723 140785 7400 6505 EQUIPMENT REPAIR/MAINTENANCE INFORMATION TECHNOLOGY 07400 04 7,950.00 155410 7/9/2021 100027 GREAT LAKES COCA-COLA DISTRIBUTION,LLC 751.36 POP ORDER 195059 3608213495 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 751.36 155411 7/9/2021 100007 HAWKINS INC 20,308.09 WELL CHEMICALS 194601 4962220 6502 6260 CHEMICALS WATER UTILITY EXPENSE 06500 08 20,306.09 155412 7/9/2021 100074 HOHENSTEINS INC 615.00 BEER ORDER 195057 420066 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 061D0 02 46.00 BEER ORDER 195062 421202 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 884.50 BEER ORDER 195088 422056 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,545.50 155413 7/9/2021 113417 INDEED BREWING COMPANY,LLC 162.70 BEER ORDER 195075 101974 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 162.70 155414 7/9/2021 109846 JJ TAYLOR DISTRIBUTING COMPANY OF MN INC 7,212.35 BEER ORDER 195060 3200428 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,319.20 BEER ORDER 195073 3168186 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 7,013.75 BEER ORDER 195089 3200470 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 15,545.30 155415 7/9/2021 100033 JOHNSON BROTHERS LIQUOR COMPANY 25.60 KINKY COCKTAILS ORDER 195063 1828253 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 385.53 WINE ORDER 195064 1828252 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,170.20 LIQUOR&SPIRITS ORDER 195065 1828251 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 631.05 LIQUOR&SPIRITS ORDER 195066 1826250 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 497.43 WINE ORDER 195067 1828249 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 136.04 LIQUOR&SPIRITS ORDER 195068 1628248 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 125.91 LIQUOR&SPIRITS ORDER 195069 1628247 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,846.82 WINE ORDER 195092 1833140 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 25.60 LIQUOR&SPIRITS ORDER 195098 1833146 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,843.20 WINE ORDER 195099 1833145 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 38.51 LIQUOR&SPIRITS ORDER 195100 1833144 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,746.39 LIQUOR&SPIRITS ORDER 195101 1833142 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,844.85 LIQUOR&SPIRITS ORDER 195102 1833141 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 37.51 LIQUOR&SPIRITS ORDER 195103 1833139 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,196.69 WINE ORDER 195104 1833138 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,367.86 LIQUOR&SPIRITS ORDER 195105 1833137 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 R55CKS2 LOGIS600V CITY OF FARMINGTON 7/14/2021 9:33:37 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 29 6/16/2021 - 7/14/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 940.65 WINE ORDER 195198 1822471 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,094.35 LIQUOR&SPIRITS ORDER 195199 1822470 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 16,156.19 155416 7/9/2021 114167 JONES&BARTLETT LEARNING,LLC 616.12 FAO TEXT BOOKS 195120 292570 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01000 06 616.12 155417 7/9/2021 118141 KLOTZ,RACHEL 328.65 PAYROLLACH RETURN-KLOTZ 195190 086300010000208 7000 2255 DEPOSITS PAYABLE EMPLOYEE EXPENSE FUND 07000 02 328.65 155418 7/9/2021 118119 LITURGICAL PUBLICATIONS,INC 2,725.00 SENIOR SPACE 20 194967 015938 7400 6505 EQUIPMENT REPAIR/MAINTENANCE INFORMATION TECHNOLOGY 07400 04 2,725.00 155419 7/9/2021 100317 METRO PEST MANAGEMENT INC 81.00 QTRLY PEST CNTRL-FIRE ST#2 195118 14649 1060 6515 BUILDING REPAIR/MAINTENANCE FIRE SERVICES 01000 06 81.00 QTRLY PEST CNTRL-FIRE ST#1 195119 14645 1060 6515 BUILDING REPAIR/MAINTENANCE FIRE SERVICES 01000 06 162.00 155420 7/9/2021 108780 MINNESOTA AG GROUP INC 220.92 MOWER PARTS 194779 IN93825 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 220.92 155421 7/9/2021 100070 MINNESOTA VALLEY TESTING LABORATORIES 77.00 BAC-T SAMPLE(7) 194717 1092698 6502 6535 OTHER REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 77.00 155422 7/9/2021 113833 MMKR CERTIFIED PUBLIC ACCOUNTANTS 9,500.00 2020 AUDIT SVS-FINAL 194731 50709 1021 6401 PROFESSIONAL SERVICES GENERAL ACCOUNTING 01000 02 9,500.00 155423 7/9/2021 107932 MOOD MEDIA 55.68 JULY 2021 RADIO SVS-LIQUOR 194984 56254164 6115 6401 PROFESSIONAL SERVICES PILOT KNOB LIQUOR 06100 02 55.68 JULY 2021 RADIO SVS-LIQUOR 194984 56254164 6110 6401 PROFESSIONAL SERVICES DOWNTOWN LIQUOR REV&EXP 06100 02 111.36 165424 7/9/2021 100093 PELLICCI HARDWARE&RENTAL 200.00 25 YR EE REC JIM MURPHY 194746 25 YR EE REC JIM 1011 7420 OTHER HUMAN RESOURCES 01000 04 MURPHY 21.25 DRILL BATTERIES 195014 K45096/F 1015 6220 EQUIP SUPPLIES&PARTS CITY HALL 01000 01 21.25 DRILL BATTERIES 195014 K45096/F 1060 6220 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 .58- 195014 K45096/F 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 42.50 DRILL BATTERIES 195014 K45096/F 1072 6220 EQUIP SUPPLIES&PARTS STREET MAINTENANCE 01000 08 8.50 DRILL BATTERIES 195014 K45096/F 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 21.25 DRILL BATTERIES 195014 K45096/F 1093 6220 EQUIP SUPPLIES&PARTS SENIOR CITIZEN SERVICES 01000 09 R55CKS2 LOGIS600V CITY OF FARMINGTON 7/14/2021 9:33:37 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 30 6/16/2021 - 7/14/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 21.24 DRILL BATTERIES 195014 K45096/F 1050 6220 EQUIP SUPPLIES&PARTS POLICE ADMINISTRATION 01000 05 8.50 DRILL BATTERIES 195014 K45096/F 6202 6220 EQUIP SUPPLIES&PARTS SEWER OPERATIONS EXPENSE 06200 08 9.08 DRILL BATTERIES 195014 K45096/F 6302 6220 EQUIP SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 8.50 DRILL BATTERIES 195014 K45096/F 6402 6220 EQUIP SUPPLIES&PARTS STORM WATER UTILITY OPERA 06400 08 8.50 DRILL BATTERIES 195014 K45096/F 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 39.99 SCREWS FOR EAST FARM ROOF 195015 K45095/1' 1090 6240 BUILDING SUPPLIES&PARTS PARK MAINTENANCE 01000 09 29.99 TOOLAPRON,12 PKT LEATHER 195017 K45108/F 1090 6950 MACHINERY,EQUIPMENT&TOOLS PARK MAINTENANCE 01000 09 2.49 NOTEBOOK STENO 80CT 6X9 195022 45116/F 6502 6210 OFFICE SUPPLIES WATER UTILITY EXPENSE 06500 08 21.99 EAR MUFFS 195022 45116/F 6502 6290 UNIFORMS&CLOTHING WATER UTILITY EXPENSE 06500 08 9.99 CHALK STRING 195023 K45123/F 1072 6220 EQUIP SUPPLIES&PARTS STREET MAINTENANCE 01000 08 21.99 SHOVEL 195025 45126/F'21 1072 6950 MACHINERY,EQUIPMENT&TOOLS STREET MAINTENANCE 01000 08 14.98 PVC PLUG/PVC ADAPTER 195025 45126/F'21 6202 6220 EQUIP SUPPLIES&PARTS SEWER OPERATIONS EXPENSE 06200 08 7.99 PRUNING SEAL 195135 45062/1' 1076 6250 OTHER SUPPLIES&PARTS NATURAL RESOURCES 01000 07 519.40 155425 7/9/2021 100032 PEPSI COLA COMPANY 211.65 POP ORDER 195058 55178306 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 211.65 155426 7/9/2021 118142 PERFORMANCE KENNELS INC 16,100.00 K9 SMOKE PURCHASE AND TRNG 195197 3113 2200 6406 K-9 EXPENSE K-9(EFF.2019) 02200 05 16,100.00 155427 7/9/2021 100034 PHILLIPS WINE AND SPIRITS,INC 104.71 LIQUOR&SPIRITS ORDER 195070 6224764 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 296.82 WINE ORDER 195071 6224765 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 91.32 LIQUOR&SPIRITS ORDER 195072 6224766 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 40.31 LIQUOR&SPIRITS ORDER 195094 6228818 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 308.57 WINE ORDER 195095 6228817 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 3,390.14 LIQUOR&SPIRITS ORDER 195097 6228816 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 4,231.87 155428 7/9/2021 118136 PROTOUCH PAINTING,INC 3,550.00 DT LIQ-REQ#1 LABOR-PAINTING 195045 17250 6110 7020 OTHER CONSTRUCTION COSTS DOWNTOWN LIQUOR REV&EXP 06100 02 2,217.66 DTLIQ-REQ#1 MTRLS-PAINTING 195046 17251 6110 7020 OTHER CONSTRUCTION COSTS DOWNTOWN LIQUOR REV&EXP 06100 02 142.66- 195046 17251 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 5,625.00 155429 7/9/2021 103239 RCM SPECIALTIES INC 92.69 EMULSION 194998 8038 1072 6253 STREET MATERIALS STREET MAINTENANCE 01000 08 92.69 155430 7/9/2021 118132 RICHFIELD PLUMBING COMPANY 8,000.00 DT LIQ BUILD OUT 195041 82432 6110 7020 OTHER CONSTRUCTION COSTS DOWNTOWN LIQUOR REV&EXP 06100 02 8,000.00 R55CKS2 LOGIS600V CITY OF FARMINGTON 7/14/2021 9:33:37 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 31 6/16/2021 - 7/14/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept Div 155431 7/9/2021 117089 ROCK HARD LANDSCAPE SUPPLY 54.00 MULCH-2YD 194684 1016846 1090 6255 LANDSCAPING MATERIALS PARK MAINTENANCE 01000 09 40.00 MULCH-2YD 194689 1017645 1090 6255 LANDSCAPING MATERIALS PARK MAINTENANCE 01000 09 60.00 MULCH-3YD 194691 1017701 1090 6255 LANDSCAPING MATERIALS PARK MAINTENANCE 01000 09 135.00 MULCH-5YD 194775 1018678 1090 6255 LANDSCAPING MATERIALS PARK MAINTENANCE 01000 09 54.00 MULCH-2YD 194776 1018005 1090 6255 LANDSCAPING MATERIALS PARK MAINTENANCE 01000 09 189.00 MULCH-7YD 194781 1018334 1090 6255 LANDSCAPING MATERIALS PARK MAINTENANCE 01000 09 532.00 155432 7/9/2021 118118 SAFETYFIRST PLAYGROUND MAINTENANCE 2,653.00 PLAYGROUND WOOD FIBER 195108 7555 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 2,653.00 155433 7/9/2021 107018 SHAMROCK GROUP 83.51 ICE CUBE ORDER 195047 2640168 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 62.57 ICE CUBE ORDER 195048 2635068 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 243.30 ICE CUBE ORDER 195055 2640914 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 129.35 ICE CUBE ORDER 195056 2639909 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 35.96 ICE CUBE ORDER 195086 2635311 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 554.69 155434 7/9/2021 112051 SOUTHERN GLAZER'S OF MN 1,651.88 LIQUOR&SPIRITS ORDER 195084 2094061 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 8,441.21 LIQUOR&SPIRITS ORDER 195090 2096820 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,320.16 WINE ORDER 195091 2096819 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 11,413.25 155435 7/9/2021 100379 SPRINT-NEXTEL 28.18 JUN 2021 SOLID WASTE TRACKER 194977 875483313-235 6302 6412 CELLULAR SERVICES SOLID WASTE OPERATIONS 06300 08 1.81- 194977 875483313-235 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 26.37 155436 7/9/2021 118137 ST CROIX WALL SYSTEMS INC 8,236.00 DT LIQ BUILD OUT 195114 2258-1 6110 7020 OTHER CONSTRUCTION COSTS DOWNTOWN LIQUOR REV&EXP 06100 02 8,236.00 155437 7/9/2021 118133 TL ERICKSON ENTERPRISES,LLC 6,200.00 DT LIQ BUILD OUT 195042 27-3415 6110 7020 OTHER CONSTRUCTION COSTS DOWNTOWN LIQUOR REV&EXP 06100 02 6,200.00 155438 7/9/2021 118116 WENCL SERVICES 6,785.00 DT LIQ LOC -DUCTWORK REROUTE 195040 87137-F 6110 7020 OTHER CONSTRUCTION COSTS DOWNTOWN LIQUOR REV&EXP 06100 02 6,785.00 20210608 6/2/2021 117968 EBSO 71,097.76 JUN-21 HEALTH INS PREMIUM 194693 9029-072206-1000 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 R55CKS2 LOGIS600V CITY OF FARMINGTON 7/14/2021 9:33:37 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 32 6/16/2021 - 7/14/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 71,097.76 20210609 6/11/2021 115438 AMERITAS LIFE INSURANCE CORP 5,895.12 JUN-21 DENTAL INSURANCE 194343 010-44-445 JUNE'21 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 5,895.12 20210610 6/11/2021 108980 MINNESOTA ENERGY RESOURCES CORPORATION 30.66 MAY'21 GAS WELL#5 193919 0507120636 MAY'21 6502 6423 NATURAL GAS WATER UTILITY EXPENSE 06500 08 20.28 MAY'21 GAS VERM GROVE LIFT STN 193922 0503080372 MAY'21 6202 6423 NATURAL GAS SEWER OPERATIONS EXPENSE 06200 08 50.94 20210611 6/16/2021 108980 MINNESOTA ENERGY RESOURCES CORPORATION 167.27 MAY'21 GAS RRC 194177 0507948331 MAY'21 1093 6423 NATURAL GAS SENIOR CITIZEN SERVICES 01000 09 66.72 MAY'21 GAS DT LIQ STORE 194180 0503154879 MAY'21 6110 6422 ELECTRIC DOWNTOWN LIQUOR REV&EXP 06100 02 92.59 MAY'21 GAS FIRE STATION 1 194185 0506565319 MAY'21 1060 6423 NATURAL GAS FIRE SERVICES 01000 06 114.93 MAY'21 GAS FIRE STATION 2 194186 0505001779 MAY'21 1060 6423 NATURAL GAS FIRE SERVICES 01000 06 533.59 MAY'21 GAS POLICE DEPT 194187 0505974444 MAY'21 1050 6423 NATURAL GAS POLICE ADMINISTRATION 01000 05 25.93 MAY'21 GAS WELL HOUSE 1 OAK ST 194199 0506788875 MAY'21 6502 6423 NATURAL GAS WATER UTILITY EXPENSE 06500 08 1,047.43 MAY'21 GAS CITY HALL 194247 0505346885 MAY'21 1015 6423 NATURAL GAS CITY HALL 01000 01 101.81 MAY'21 GAS CMF 194248 0502362190 MAY'21 1072 6423 NATURAL GAS STREET MAINTENANCE 01000 08 101.83 MAY'21 GAS CMF 194248 0502362190 MAY'21 1090 6423 NATURAL GAS PARK MAINTENANCE 01000 09 7.00- 194248 0502362190 MAY'21 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 101.83 MAY'21 GAS CMF 194248 0502362190 MAY'21 6202 6423 NATURAL GAS SEWER OPERATIONS EXPENSE 06200 08 108.83 MAY'21 GAS CMF 194248 0502362190 MAY'21 6302 6423 NATURAL GAS SOLID WASTE OPERATIONS 06300 08 101.83 MAY'21 GAS CMF 194248 0502362190 MAY'21 6402 6423 NATURAL GAS STORM WATER UTILITY OPERA 06400 08 100.61 MAY'21 GAS CMF 194248 0502362190 MAY'21 6502 6423 NATURAL GAS WATER UTILITY EXPENSE 06500 08 23.00 MAY'21 GAS 1 ST STREET GARAGE 194249 0505547424 MAY'21 1072 6423 NATURAL GAS STREET MAINTENANCE 01000 08 23.00 MAY'21 GAS 1ST STREET GARAGE 194249 0505547424 MAY'21 1090 6423 NATURAL GAS PARK MAINTENANCE 01000 09 1.55- 194249 0505547424 MAY'21 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 23.00 MAY'21 GAS 1ST STREET GARAGE 194249 0505547424 MAY'21 6202 6423 NATURAL GAS SEWER OPERATIONS EXPENSE 06200 08 24.05 MAY'21 GAS 1ST STREET GARAGE 194249 0505547424 MAY'21 6302 6423 NATURAL GAS SOLID WASTE OPERATIONS 06300 08 22.00 MAY'21 GAS 1ST STREET GARAGE 194249 0505547424 MAY'21 6402 6423 NATURAL GAS STORM WATER UTILITY OPERA 06400 08 21.69 MAY'21 GAS 1ST STREET GARAGE 194249 0505547424 MAY'21 6502 6423 NATURAL GAS WATER UTILITY EXPENSE 06500 08 214.73 MAY'21 GAS ARENA 194250 0502346011 MAY'21 2502 6423 NATURAL GAS ICE ARENA OPERATIONS EXPE 02500 09 3,008.12 20210612 6/16/2021 117633 NOKOMIS ENERGY LLC 626.18 MAY'21 ELEC RRC 194320 AOR3YP-2021-05-31 1093 6422 ELECTRIC SENIOR CITIZEN SERVICES 01000 09 4,688.48 MAY-21 ELEC CITYHALL 194320 AOR3YP-2021-05-31 1015 6422 ELECTRIC CITY HALL 01000 01 6,333.72 MAY'21 ELEC ARENA 194320 AOR3YP-2021-05-31 2502 6422 ELECTRIC ICE ARENA OPERATIONS EXPE 02500 09 11,648.38 20210613 6/17/2021 111046 VOYAGER FLEET SYSTEMS INC 5.32 MAY'21 FUELJANITORIAL 194163 8690882372122 1015 6272 FUEL CITY HALL 01000 01 JANITORIAL R55CKS2 LOGIS600V CITY OF FARMINGTON 7/14/2021 9:33:37 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 33 6/16/2021 - 7/14/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 5.33 MAY'21 FUEL JANITORIAL 194163 8690882372122 1060 6272 FUEL FIRE SERVICES 01000 06 JANITORIAL .15- 194163 8690882372122 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 JANITORIAL 10.65 MAY'21 FUEL JANITORIAL 194163 8690882372122 1072 6272 FUEL STREET MAINTENANCE 01000 08 JANITORIAL 2.13 MAY'21 FUEL JANITORIAL 194163 8690882372122 1090 6272 FUEL PARK MAINTENANCE 01000 09 JANITORIAL 5.33 MAY'21 FUEL JANITORIAL 194163 8690882372122 1093 6272 FUEL SENIOR CITIZEN SERVICES 01000 09 JANITORIAL 5.33 MAY'21 FUEL JANITORIAL 194163 8690882372122 1050 6272 FUEL POLICE ADMINISTRATION 01000 05 JANITORIAL 2.13 MAY'21 FUEL JANITORIAL 194163 8690882372122 6202 6272 FUEL SEWER OPERATIONS EXPENSE 06200 08 JANITORIAL 2.28 MAY'21 FUEL JANITORIAL 194163 8690882372122 6302 6272 FUEL SOLID WASTE OPERATIONS 06300 08 JANITORIAL 2.13 MAY'21 FUEL JANITORIAL 194163 8690862372122 6402 6272 FUEL STORM WATER UTILITY OPERA 06400 08 JANITORIAL 2.13 MAY'21 FUEL JANITORIAL 194163 8690882372122 6502 6272 FUEL WATER UTILITY EXPENSE 06500 08 JANITORIAL 1,802.52 MAY-21 FUEL PARKS 194164 8690882372122 1090 6272 FUEL PARK MAINTENANCE 01000 09 PARKS 942.32 MAY'21 FUEL SOLID WASTE 194167 8690882372122 6302 6272 FUEL SOLID WASTE OPERATIONS 06300 08 SOLID WASTE 60.62- 194167 8690882372122 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 SOLID WASTE 130.59 MAY'21 FUEL BLDG INSP 194169 8690882372122 BLDG1031 6272 FUEL BUILDING INSPECTIONS 01000 07 INSP 53.50 MAY'21 FUEL CODE ENFORCEMENT 194170 8690882372122 1030 6272 FUEL PLANNING&ZONING 01000 03 PLAN/ZONE 5,232.20 MAY'21 FUEL POLICE 194175 8690882372122 1051 6272 FUEL PATROL SERVICES 01000 05 POLICE 28.04 MAY'20 FUEL RECREATION 194178 8690882372122 1094 6272 FUEL PARK&RECREATION ADMIN 01000 09 RECREATION 778.79 MAY'21 FUEL FIRE 194184 8690882372122 FIRE 1060 6272 FUEL FIRE SERVICES 01000 06 60.68 MAY'21 FUEL FLEET 194188 8690882372122 7200 6272 FUEL FLEET OPERATIONS 07200 08 FLEET 75.56 MAY'21 FUEL STORM 194192 8690882372122 6402 6272 FUEL STORM WATER UTILITY OPERA 06400 08 STORM 351.18 MAY'21 FUEL WATER 194193 8690882372122 6502 6272 FUEL WATER UTILITY EXPENSE 06500 08 WATER 1,100.77 MAY'21 FUEL SEWER 194194 8690882372122 6202 6272 FUEL SEWER OPERATIONS EXPENSE 06200 08 R55CKS2 LOGIS600V CITY OF FARMINGTON 7/14/2021 9:33:37 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 34 6/16/2021 - 7/14/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div SEWER 311.66 MAY'21 FUEL STREET 194195 8690882372122 1072 6272 FUEL STREET MAINTENANCE 01000 08 STREET/SNOW 191.59 MAY'21 FUEL ENGINEERING 194532 8690882372122 1070 6272 FUEL ENGINEERING SERVICES 01000 07 ENGINEERING 67.02 MAY'21 FUEL NAT RES 194533 8690882372122 NAT 1076 6272 FUEL NATURAL RESOURCES 01000 07 RESOURC 11,108.41 20210614 6/17/2021 108980 MINNESOTA ENERGY RESOURCES CORPORATION 57.97 MAY'21 GAS PK LIQ STORE 194211 0507026961 MAY'21 6115 6423 NATURAL GAS PILOT KNOB LIQUOR 06100 02 57.97 20210615 6/18/2021 115462 GROUP HEALTH INC.-WORKSITE 151.00 DEC'20 EAP PROGRAM 190795 W818227 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 151.00 20210616 6/18/2021 100135 PUBLIC EMPLOYEES RETIREMENT ASSN. 25,021.24 194669 0616211219071 7000 2113 PERA PAYABLE EMPLOYEE EXPENSE FUND 07000 02 33,478.30 194670 0616211219072 7000 6154 PERA EMPLOYEE EXPENSE FUND 07000 02 58,499.54 20210617 6/21/2021 100394 XCEL ENERGY 141.44 MAY'21 ELEC-190TH ST BRDG LTS 193916 51-9371130 MAY'21 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 157.44 MAY'21 ELEC-321 ELM ST LTS 193917 51-8608862 MAY'21 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 26.48 MAY'21 ELEC-LINDEN ST LFT STN 193918 51-6585658 MAY'21 6202 6422 ELECTRIC SEWER OPERATIONS EXPENSE 06200 08 1,247.88 MAY-21 ELEC-DT LIQ STORE 193965 51-4874008 MAY'21 6110 6422 ELECTRIC DOWNTOWN LIQUOR REV&EXP 06100 02 26.36 MAY'21 ELEC-5262 208TH ST LTS 193974 51-8391412 MAY'21 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 24.12 MAY'21 ELEC-DUNBRY AVE WRM HSE 194161 51-9027188 MAY'21 1090 6422 ELECTRIC PARK MAINTENANCE 01000 09 1,623.72 20210618 6/28/2021 100085 DAKOTA ELECTRIC ASSOCIATION 222.78 MAY'21 ELEC DNMRK/SPRCE ST LTS 194206 200004222477 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 MAY'21 19.74 MAY'21 ELEC SPRUCE ST MNMNT LT 194207 200004099123 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 MAY'21 55.42 MAY'21 ELEC WELL#9 194208 200010028004 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 MAY'21 19.86 MAY'21 ELEC 220TH ST LIFT STN 194209 200001405224 6202 6422 ELECTRIC SEWER OPERATIONS EXPENSE 06200 08 MAY'21 18.89 MAY'21 PK CITY SIGN NORTH ENTR 194267 200010011266 1090 6422 ELECTRIC PARK MAINTENANCE 01000 09 MAY'21 32.46 MAY'21 ELEC PARK&REC SIGN 194270 200002260479 1090 6422 ELECTRIC PARK MAINTENANCE 01000 09 MAY'21 331.04 MAY'21 ELEC FIRE STATION 1 194316 200001679489 1060 6422 ELECTRIC FIRE SERVICES 01000 06 R55CKS2 LOGIS600V CITY OF FARMINGTON 7/14/2021 9:33:37 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 35 6/16/2021 - 7/14/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept Div MAY'21 700.19 20210619 6/11/2021 117955 VSP INSURANCE CO. 295.50 JUN'21 VISION INS PREMIUM 194914 812375979 JUN'21 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 295.50 20210620 6/25/2021 116564 FP MAILING SOLUTIONS/POSTALIA 200.00 POSTAGE FOR POSTAGE METER 194921 61838575 20210623 1050 6445 POSTAGE/SHIPPING FEES POLICE ADMINISTRATION 01000 05 200.00 20210621 6/17/2021 114664 INVOICE CLOUD 528.10 MAY'21 IC PYMT PRCSSNG FEES 194797 819-2021_5 6202 6545 PYMT PROCESSING FEES SEWER OPERATIONS EXPENSE 06200 08 528.10 MAY'21 IC PYMT PRCSSNG FEES 194797 819-2021_5 6302 6545 PYMT PROCESSING FEES SOLID WASTE OPERATIONS 06300 08 528.10 MAY'21 IC PYMT PRCSSNG FEES 194797 819-2021_5 6402 6545 PYMT PROCESSING FEES STORM WATER UTILITY OPERA 06400 08 528.10 MAY'21 IC PYMT PRCSSNG FEES 194797 819-20215 6502 6545 PYMT PROCESSING FEES WATER UTILITY EXPENSE 06500 08 2,112.40 20210622 6/24/2021 117261 USPS POSTALONE 78.77 POSTAGE RRC 070821 194996 RRC NEWSLETTER 1014 6445 POSTAGE/SHIPPING FEES COMMUNICATIONS 01000 01 20210623 78.77 20210623 6/28/2021 100394 XCEL ENERGY 796.02 DT NEW LOC-SET UP ELEC SVS 194748 51-0013605389 SET 6110 7020 OTHER CONSTRUCTION COSTS DOWNTOWN LIQUOR REV&EXP 06100 02 UP 796.02 20210624 6/26/2021 102160 CARDMEMBER SERVICES 9.44 VOL RECOGNITION 194448 3544-3745-5/19 1093 6570 PROGRAMMING EXPENSE SENIOR CITIZEN SERVICES 01000 09 5.45 JUMP DRIVE 194449 3544-4768-5/14 1093 6220 EQUIP SUPPLIES&PARTS SENIOR CITIZEN SERVICES 01000 09 249.60 RRC 1 YEAR STRIB 194450 3544-7259-5/19 1093 6280 BOOKS&SUBSCRIPTIONS SENIOR CITIZEN SERVICES 01000 09 65.07 GAK INGREDIENTS 194451 3544-6601-5/28 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 7.00 GREEN PLATES:PUPPET WAGON 194452 3544-5113-5/24 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 41.98 FARADAY BAGS 194453 4021-4191-5/17 1052 6220 EQUIP SUPPLIES&PARTS INVESTIGATION SERVICES 01000 05 31.88 WIRLESS KEYBOARD MOUSE INT COM 194454 4021-3393-5/17 1052 6220 EQUIP SUPPLIES&PARTS INVESTIGATION SERVICES 01000 05 56.99 LUNCH ROOM DISH RACK 194455 4021-2842-5/17 1050 6960 FURNITURE,OFFICE EQUIP,IT POLICE ADMINISTRATION 01000 05 322.20 POPCORN FOR OPEN HOUSE 194456 4021-2613-5/11 1050 6570 PROGRAMMING EXPENSE POLICE ADMINISTRATION 01000 05 9.58 BATTERIES FOR DRY FIRE SYSTEM 194457 4021-2573-5/7 1051 6220 EQUIP SUPPLIES&PARTS PATROL SERVICES 01000 05 118.20 FUSE BLOCKS FOR SQUAD BUILDS 194458 4021-1573-5/10 1051 6230 VEHICLE SUPPLIES&PARTS PATROL SERVICES 01000 05 374.00 HELIUM FOR OPEN HOUSE BALLOONS 194459 4021-6935-5/14 1050 6570 PROGRAMMING EXPENSE POLICE ADMINISTRATION 01000 05 28.90 WOOTON NOTARY STAMP 194460 4021-9554-5/14 1050 6210 OFFICE SUPPLIES POLICE ADMINISTRATION 01000 05 51.04 WATER FOR OPEN HOUSE 194461 4021-8107-5/17 1050 6570 PROGRAMMING EXPENSE POLICE ADMINISTRATION 01000 05 750.00 HAGFORS ARRESTAND CONTROLTRN 194462 4021-7948-5/7 1051 6470 TRAINING&SUBSISTANCE PATROL SERVICES 01000 05 395.00 WOOTON CRIME ANALYST TRNG 194463 4021-8666-5/10 1050 6470 TRAINING&SUBSISTANCE POLICE ADMINISTRATION 01000 05 R55CKS2 LOGIS600V CITY OF FARMINGTON 7/14/2021 9:33:37 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 36 6/16/2021 - 7/14/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept Div 99.00 KANINE SOFTWARE ANNUAL FEE 194464 4021-9833-5/20 2200 6406 K-9 EXPENSE K-9(EFF.2019) 02200 05 818.54 BALLONS AND CUPS FOR OPEN HOUS 194465 4021-1096-5/10 1050 6570 PROGRAMMING EXPENSE POLICE ADMINISTRATION 01000 05 25.39 FLOOR MATS 194466 4021-8534-5/24 1072 6230 VEHICLE SUPPLIES&PARTS STREET MAINTENANCE 01000 08 50.78 FLOOR MATS 194466 4021-8534-5/24 1090 6230 VEHICLE SUPPLIES&PARTS PARK MAINTENANCE 01000 09 48.94 TRAINING BOOKS 194467 4021-8095-5/20 1060 6280 BOOKS&SUBSCRIPTIONS FIRE SERVICES 01000 06 48.00 TRAINING BOOKS 194468 4021-4094-5/19 1060 6280 BOOKS&SUBSCRIPTIONS FIRE SERVICES 01000 06 42.48 TRAINING BOOKS 194469 4021-0567-5/17 1060 6280 BOOKS&SUBSCRIPTIONS FIRE SERVICES 01000 06 77.98 CH 5 MEASURING WHEEL 194470 4021-0738-5/17 1060 6950 MACHINERY,EQUIPMENT&TOOLS FIRE SERVICES 01000 06 160.91 SPA SUPPLIES 194471 3544-8049-5/21 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 39.95 ZUMBA GOLD MAY 21 194472 3544-7944-5/24 1093 6570 PROGRAMMING EXPENSE SENIOR CITIZEN SERVICES 01000 09 530.00 2020 GFOA CERT OF EXCELLENCE 194473 6913-2278-5/25 1021 6460 MEMBER DUES&LICENSURE GENERAL ACCOUNTING 01000 02 1,487.08 MAY-21 VERIZON DATA SERVICE 194474 6913-3743-5/18 7400 6412 CELLULAR SERVICES INFORMATION TECHNOLOGY 07400 04 3,072.44 MAY'21 CELL PHONE SERVICE 194474 6913-3743-5/18 7400 6412 CELLULAR SERVICES INFORMATION TECHNOLOGY 07400 04 41.51 MAY'21 CELL PHONE SERVICE 194474 6913-3743-5/18 2000 6412 20 CELLULAR SERVICES-DBB HRA/ECONOMIC DEVELOPMENT 02000 03 57.50 TOASTMASTERS MEMBERSHIP 2021 194475 6913-4352-5/10 1014 6460 MEMBER DUES&LICENSURE COMMUNICATIONS 01000 01 390.00 2 SVR BATTERY REPLACEMENT 194476 0915-4579-5/21 7400 6220 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 25.95 MONITOR STAND FRONT DESK 194477 0915-1782-5/26 7400 6220 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 13.20 ANALOG PHONE TESTER-IT 194478 0915-2156-5/24 7400 6950 MACHINERY,EQUIPMENT&TOOLS INFORMATION TECHNOLOGY 07400 04 84.75 5 IPHONE CHARGERS-IT SPARE 194479 0915-9886-5/24 7400 6220 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 26.85 KEYBRD/MOUSE:PETE ZAJAC 194480 0915-4427-5/20 7400 6220 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 128.91 SURFACE/IPAD CHARGERS CCOUNCIL 194481 0915-8383-5/14 7400 6220 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 39.95 BUSY LIGHT FRONT DESK 194482 0915-3489-5/14 7400 6220 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 24.99 MONITOR STAND KERRY W. 194482 0915-3489-5/14 7400 6220 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 29.99 KEYBRD/MOUSE:GINA WOOTON 194483 0915-5267-5/10 7400 6220 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 26.99 USB HUB SONDRA BAAR 194484 0915-5326-5/10 7400 6220 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 175.95 SHELVING FOR IT SERVER ROOM 194485 0915-5768-5/10 7400 6950 MACHINERY,EQUIPMENT&TOOLS INFORMATION TECHNOLOGY 07400 04 19.96 CAM PRIVACY LID:KATY&TONY 194486 0915-8416-5/7 7400 6220 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 75.52 WEB CAMS:KATY&TONY 194486 0915-8416-5/7 7400 6220 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 .99 MAY'21 ICLOUD STRGE SIEBENALER 194487 6913-2925-5/7 1014 6412 CELLULAR SERVICES COMMUNICATIONS 01000 01 51.15 SPA SUPPLIES 194488 3544-3137-5/21 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 127.20 SPA SUPPLIES 194489 3544-3997-5/24 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 139.99 CANOPY SPA 194490 3544-6971-5/21 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 12.98 WEBSITE HOST 194491 5212-2094-5/27 2000 6505 20 EQUIPMENT REPAIR/MAINT-DBB HRA/ECONOMIC DEVELOPMENT 02000 03 26.85 ELECTRIC DOOR BELL-PK STORE 194492 0915-6474-5/21 6115 6950 MACHINERY,EQUIPMENT&TOOLS PILOT KNOB LIQUOR 06100 02 6.00 TOASTMASTERS LOCAL DUES 2021 194493 6913-5324-5/19 1014 6460 MEMBER DUES&LICENSURE COMMUNICATIONS 01000 01 12.00 GEOCACHING CONTAINERS 194498 6984-2108-5/27 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 15.54 COFFEE FLOW TESTING 194500 6125-0687-5/24 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01000 06 1,302.28 RECYCLING BARRELS 194501 6860-7214-5/19 6302 6950 MACHINERY,EQUIPMENT&TOOLS SOLID WASTE OPERATIONS 06300 08 83.77- 194501 6860-7214-5/19 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 118.63 SPA SUPPLIES 194503 3544-6230-5/21 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 86.75 PLAYGROUND SNACKS 194504 3544-6323-6/2 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 35.95 DINO PUPPET WAGON 194505 3544-3876-6/1 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 R55CKS2 LOGIS600V CITY OF FARMINGTON 7/14/2021 9:33:37 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 37 6/16/2021 - 7/14/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 1,410.75 RECYCLE LIDS 194506 6860-9706-6/3 6302 6950 J MACHINERY,EQUIPMENT&TOOLS SOLID WASTE OPERATIONS 06300 08 90.75- 194506 6860-9706-6/3 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 19.95 MAY'20 EPERMITS PAYPAL FEES 194511 6913-9668-6/4 1031 6545 PYMT PROCESSING FEES BUILDING INSPECTIONS 01000 07 58.91 JUN'21 ZOOM LICENSE 194607 0915-6774-6/1 7400 6505 EQUIPMENT REPAIR/MAINTENANCE INFORMATION TECHNOLOGY 07400 04 75.00 MAY'21 TLO SUBSCRIPTION 194613 4021-4627-6/2 1052 6401 PROFESSIONAL SERVICES INVESTIGATION SERVICES 01000 05 100.08 REC GEOCACHING PROG SUPPLIES 194614 4021-9525-6/1 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 211.80 REC GEOCACHING PROG SUPPLIES 194615 4021-0750-6/2 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 100.00 OPEN HOUSE FACEBOOK BOOST 194616 4021-6726-6/1 1050 6570 PROGRAMMING EXPENSE POLICE ADMINISTRATION 01000 05 361.50 50'CORD REEL&RECEP 194738 3387-8054-6/4 1060 6950 MACHINERY,EQUIPMENT&TOOLS FIRE SERVICES 01000 06 216.12 PLATES/COFFEE/SPOONS/ 194751 1228-1019-5/13 1060 6220 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 63.71 MEASURING WHEEL 194752 8801-9380-5/14 1060 6950 MACHINERY,EQUIPMENT&TOOLS FIRE SERVICES 01000 06 604.11- NEWDT LQ:RETURN FIREWALL 195174 0915-0542-6/14 6110 7020 OTHER CONSTRUCTION COSTS DOWNTOWN LIQUOR REV&EXP 06100 02 38.86 195174 0915-0542-6/14 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 52.26- NEWDT LQ:REFUND 1 PATCHPANELS 195176 0915-4948-6/22 6110 7020 OTHER CONSTRUCTION COSTS DOWNTOWN LIQUOR REV&EXP 06100 02 3.36 195176 0915-4948-6/22 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 13,947.30 20210701 7/1/2021 116063 109 ELM,LLC 12,394.58 JUL'21 DT LIQUOR STORE RENT 194699 JULY 2021 6110 6556 BUILDING RENTAL DOWNTOWN LIQUOR REV&EXP 06100 02 12,394.58 20210702 7/2/2021 117968 E13SO 61,091.57 JUL'21 HEALTH INS PREMIUM 195125 9029-072621-1000 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 61,091.57 20210703 7/2/2021 100394 XCEL ENERGY 7.65 MAY'21 ELEC CIV DEF SIREN 194608 51-4874006 MAY'21 1054 6422 ELECTRIC EMERGENCY MGMT SERVICES 01000 05 7.65 20210704 7/6/2021 100085 DAKOTA ELECTRIC ASSOCIATION 3,391.13 MAY'21 ELEC WELL#8 194434 200004199709 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 MAY'21 25.55 MAY'21 ELEC DAISY KNOLL TOWER 194435 200001318518 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 MAY'21 3,210.34 MAY'21 ELEC WELL#6 194436 200001550151 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 MAY'21 2,010.13 MAY'21 ELEC WELL#5 194437 200002785533 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 MAY'21 2,053.70 MAY-21 ELEC WELL#7 194438 200003490737 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 MAY'21 2,340.57 MAY-21 ELEC WELL#4 194439 200001318526 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 MAY'21 130.02 MAY'21 ELEC VERM GROVE LS 194440 200003215779 6202 6422 ELECTRIC SEWER OPERATIONS EXPENSE 06200 08 MAY'21 R55CKS2 LOGIS600V CITY OF FARMINGTON 7/14/2021 9:33:37 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 38 6/16/2021 - 7/14/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 6,370.58 MAY'21 ELEC 9TH ST STREET LTS 194441 200001038421 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 MAY'21 156.82 MAY'21 ELEC 195TH WATER TOWER 194442 200002587095 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 MAY'21 1,332.12 MAY'21 ELEC PK LIQ STORE 194446 200003759691 6115 6422 ELECTRIC PILOT KNOB LIQUOR 06100 02 MAY'21 34.81 MAY'21 ELEC TUNNEL LIGHT 194529 200005468327 1090 6422 ELECTRIC PARK MAINTENANCE 01000 09 MAY'21 339.95 MAY'21 ELEC FIRE STATN#2 194564 200003971959 1060 6422 ELECTRIC FIRE SERVICES 01000 06 MAY'21 5.00 MAY'21 ELEC CIV DEF SIREN 194609 200001982271 1054 6422 ELECTRIC EMERGENCY MGMT SERVICES 01000 05 MAY'21 5.00 MAY'21 ELEC CIV DEF SIREN 194610 200002260958 1054 6422 ELECTRIC EMERGENCY MGMT SERVICES 01000 05 MAY'21 21,405.72 20210705 7/6/2021 108980 MINNESOTA ENERGY RESOURCES CORPORATION 39.83 JUN'21 GAS 208TH ST WARM HOUSE 194821 0506537581 JUN'21 1090 6423 NATURAL GAS PARK MAINTENANCE 01000 09 39.83 20210706 7/6/2021 100135 PUBLIC EMPLOYEES RETIREMENTASSN. 25,908.81 194749 070121853221 7000 2113 PERA PAYABLE EMPLOYEE EXPENSE FUND 07000 02 34,386.30 194750 070121853222 7000 6154 PERA EMPLOYEE EXPENSE FUND 07000 02 60,295.11 20210707 7/6/2021 117261 USPS POSTALONE 245.00 2021 POSTAGE PERMIT FEE 193262 PRMT FEE'21 1014 6445 POSTAGE/SHIPPING FEES COMMUNICATIONS 01000 01 245.00 20210708 7/6/2021 100394 XCEL ENERGY 43.16 MAY'21 ELEC DOWNTOWN ST LTS 194733 51-4874005 MAY'21 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 1,718.16 MAY-21 ELEC WELL#1&3 194733 51-4874005 MAY'21 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 52.73 MAY'21 ELEC LIFT STATIONS 194733 51-4674005 MAY'21 6202 6422 ELECTRIC SEWER OPERATIONS EXPENSE 06200 08 52.57 MAY'21 ELEC TRAFFIC SIGNAL 194733 5111874005 MAY'21 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 142.28 MAY'21 ELEC ROUNDABOUT 194733 51-4874005 MAY'21 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 12.24 MAY'21 ELEC CITY GARAGE 194733 51-4874005 MAY'21 6202 6422 ELECTRIC SEWER OPERATIONS EXPENSE 06200 08 100.65 MAY'21 ELEC CITY GARAGE 194733 51-4874005 MAY'21 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 9.52 MAY'21 ELEC CITY GARAGE 194733 51-4874005 MAY'21 6302 6422 ELECTRIC SOLID WASTE OPERATIONS 06300 08 2.72 MAY'21 ELEC CITY GARAGE 194733 51-4874005 MAY'21 6402 6422 ELECTRIC STORM WATER UTILITY OPERA 06400 08 4.08 MAY'21 ELEC CITY GARAGE 194733 51-4874005 MAY'21 1072 6422 ELECTRIC STREET MAINTENANCE 01000 08 6.80 MAY'21 ELEC CITY GARAGE 194733 51-4874005 MAY'21 1090 6422 ELECTRIC PARK MAINTENANCE 01000 09 6,827.57 MAY'21 ELEC NOW METER ST LTS 194733 51-4874005 MAY'21 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 8,972.48 R55CKS2 LOGIS600V CITY OF FARMINGTON 7/14/2021 9:33:37 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 39 6/16/2021 - 7/14/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div Report Totals 1,485,217.94 APPROVALS: HOYT BERNHJELM � � PEARSON - e ? POR ER WILSON CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 Farmington MN.gov TO: Mayor, Councilmembers and City Administrator FROM: David McKnight, City Administrator SUBJECT: Presentation of School District 192 Community Survey Results DATE: July 19, 2021 INTRODUCTION The school district conducts a community survey every other year. The results of that survey will be shared with the city council and school board at the meeting. DISCUSSION The survey results from the every other year school district community survey will be shared at the meeting. BUDGET IMPACT NA ACTION REQUESTED Hear the results of the school district community survey and ask any questions you may have on the presentation. CITY 4F 0 430 Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 nuu rq Farmington MN.gov TO: Mayor, Councilmembers and City Administrator FROM: David McKnight, City Administrator SUBJECT: ISD 192 Update DATE: July 19, 2021 INTRODUCTION Superintendent Berg will be providing an update on school district activities. DISCUSSION NA BUDGET IMPACT NA ACTION REQUESTED NA CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 Farmington MN,gov TO: Mayor, Councilmembers and City Administrator FROM: David McKnight, City Administrator SUBJECT: City of Farmington and Development Update DATE: July 19, 2021 INTRODUCTION City staff will provide a development update for the city council and school board. DISCUSSION City staff will make a presentation updating the city council and school board on development that is occurring in Farmington, new businesses that have and will open and street projects that will occur in 2021 and 2022. BUDGET IMPACT NA ACTION REQUESTED Hear the presentation that is provided and ask any questions you may have on the topic.