Loading...
HomeMy WebLinkAbout09.20.21 Council Packet OF QTY Meeting Location: FARMINGTICJ N Farmington City Hall 430 Third Street NEW Farmington,MN 55024 CITY COUNCIL REGULAR MEETING AGENDA September 20, 2021 7:00 P.M. Action Taken 1. CALL TO ORDER 7.00 P.M. 2. PLEDGE OFALLEGIANCE 3. ROLL CALL 4. APPROVE AGENDA 5. ANNOUNCEMENTS I COMMENDATIONS a) Adopt Resolution Accepting K9 Program Donation R45-21 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 September 7, 2021, City Council Meeting— Administration Approved b) Approve Minutes of the September 7, 2021, City Council Work Session— Administration Approved c) Approve Joint Powers Agreement Establishing the Criminal Justice Network Board—Administration Pulled d) Approve 2022 Fire Relief Association Pension Increase—Administration Approved e) Approve Temporary On-Sale Liquor License Farmington Liquors— Administration Approved I) Acknowledge City Administrator Performance Review Summary—City Council Acknowledged g) Adopt Resolution Accepting Donation from Happy Harry's Furniture to the Rambling River Center- Parks R46-21 h) Approve Bills - Finance Approved REGULAR AGENDA 8. PUBLIC HEARINGS 9. AWARD OF CONTRACT 10. PETITIONS, REQUESTSAND COMMUNICATIONS 11. UNFINISHED BUSINESS 12. NEW B USINESS a) Adopt Resolution Approving Preliminary 2022 General Fund Budget and Tax Levy R47-21 13. CITY COUNCIL ROUNDTABLE 14. ADJOURN CITY OF 0 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 _®a + Farmington M N.gov TO: Mayor, Councilmembers and City Administrator FROM: Gary Rutherford-Chief of Police SUBJECT: K9 Program Donation DATE: September 20, 2021 INTRODUCTION On July 22nd, 2021,the Farmington Police Department was contacted by a Amy Schiemer on behalf of her 7 year old son, Ben. We were informed that Ben was going to have a lemonade stand that weekend and wanted to donate his proceeds to our K9 program. She didn't believe at the time that it would be very much money, but she wanted to verify that we would accept it for our K9 program. DISCUSSION That Friday, Ben's Yummy Yum Lemonade Stand commenced operation. His effort was warmly embraced by the residents of Farmington and then the business community got involved. A number of businesses pledged matching donations and somejust donated outright. The effort was so successful and in such demand,that Ben opened his lemonade stand the following weekend as well. BUDGET IMPACT Ben's Yummy Yum Lemonade Stand raised a total of$9,900.00 for the Farmington Police Department K9 program. Of that total, $2,561.35 was in sales and direct donations to Ben's Yummy Yum Lemonade Stand. Additional donations came from KD Burton Enterprises LLC dba Sno-Mow Services in the amount of$500.00, Fritz Mechanical LLC in the amount of$750.00, Becky Stanley of Perrysville, OH in the amount of$500.00, BTD Manufacturing in the amount of$1,000.00 and RS Executive Protection in the amount of$4,588.65. These donations will be used exclusively to fund and support the Farmington Police Department K9 program. ACTION REQUESTED Make any remarks and ask any questions that you may have. Staff recommends that you adopt the attached resolution accepting donations in the total amount of$9,900.00 from Ben Schiemer and family, and the other aforementioned donors. ATTACHMENTS: Type Description D Resolution Donation Resolution RESOLUTION NO. R45-21 ACCEPT DONATION OF $9,900.00 FOR THE FARMINGTON POLICE DEPARTMENT K9 PROGRAM Pursuant to due call and notice thereof, a regular meeting of the City Council of the Cityof Farmington was held at the Farmington City Hall on the 20th day of September 2021. Members Present: Hoyt, Bernhj elm, Pearson, Porter, Wilson Members Absent: hone Member Porter and Member Bernhj elm introduced and seconded the following: WHEREAS, Ben Schiemer and family have donated $2,561.35; and WHEREAS, RS Executive Protection has donated $4,588.65; and WHEREAS, BTD Manufacturing has donated $1,000.00; and WHEREAS, Fritz Mechanical LLC has donated $750.00; and WHEREAS, KD Burton Enterprises LLC DBA Sno-Mow Services has donated $500.00; and WHEREAS, Becky Stanley has donated $500.00; and WHEREAS, the Police Department will utilize these donations to fund and support the Farmington Police Department K9 program; and WHEREAS, it is required by state statute that such donations be formally accepted; and WHEREAS, it is in the best interest of the city to accept these donations. NOW,THEREFORE, BE IT RESOLVED by the Mayor and City Council of the City of Farmington that the City of Farmington hereby accepts with sincere gratitude the generous donations totaling$9,900.00 for the Farmington Police Department K9 program. This resolution was adopted by recorded vote of t armington Cit ouncil in opensession on the 20th day of September 2021. oshua Hoyt, ayor Attested to the �h day of September 2021. Da cKnight, City Adm or SEAL CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-280-6800 FarmingtonMN.gov TO: Mayor, Councilmembers and City Administrator FROM: David McKnight, City Administrator SUBJECT: Approve Minutes of the September 7, 2021 City Council Meeting-Administration DATE: September 20, 2021 INTRODUCTION Attached for your review are the minutes of the September 7, 2021 city council meeting. DISCUSSION NA BUDGET IMPACT NA ACTION REQUESTED Approve the minutes of the September 7, 2021 city council meeting. ATTACHMENTS: Type Description D Backup Material September 7, 2021 City Council Minutes CITY OF FARMINGTON CITY COUNCIL MINUTES REGULAR MEETING SEPTEMBER 7, 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, and Wilson Absent-None Staff Present-Administrator McKnight, Assistant Administrator Gorski, Parks and Recreation Director Omlid, Police Chief Rutherford, Fire Chief Elvestad, Finance Director Regis, Liquor Operations Manager Solinger and Attorney Koch. 4) Agenda Motion by Wilson, second by Bernhjelm, to approve the agenda as presented. APIF, motion carried. 5) Announcement/Commendations a) Introduction of New Staff Administrator McKnight introduced Finance Director Regis and Liquor Operations Manager Solinger. Both recently started work with the city. The city council welcomed both new members to the team and looks forward to what they will do for the city. 6) Citizen Comments a) Eric Jezierski, 18297 Dunbury Avenue-Shared his thoughts with the city council on the possible change of structure on the EDA to be made up of all city councilmembers. He thought split decision making was a good thing and offered his thoughts on other options the city council should consider. September 7,2021 Minutes 7) Consent Agenda Motion by Porter, second by Bernhjelm, to approve the consent agenda: a) Approve Minutes of the August 16, 2021 City Council Meeting-Administration b) Approve Appointment to Parks and Recreation Commission-City Council c) Approve Out of State Training-Police d) Approve Adoption of Summary Ordinance 2021-761 Zoning Code Update- Community Development-Community Development e) Approve Request for Early Termination of Metropolitan Agriculture Preserve Program-JMA Devney Family LLP-Community Development f) Approve Promotion to Captain Fire-Human Resources g) Approve Promotion to Lieutenant Fire-Human Resources h) Approve Agreement with Northern Natural Gas for Use of Their Pipeline Easement- Public Works i) Approve Out of State Training for Dakota County Special Operations Team-Fire j) Approve Bills-Finance 8) Public Hearing a) Economic Development Authority Composition Revision Administrative Assistant Muller shared that the Economic Development Authority (EDA) is currently comprised of two city councilmembers and five residents. The city council discussed the makeup at a recent work session and requested that the makeup of the EDA be changed to the five sitting city councilmembers. The terms would coincide with the city councilmembers terms. Councilmember Pearson shared some of the discussion that got the city council to this point tonight. She clarified that there has been no quorum for two of the past three EDA meetings. Councilmember Bernhjelm stated this has been an issue throughout 2021. Councilmember Bernhjelm shared that she has served on the EDA for a number of years. The EDA is grossly underfunded and it limits their decision-making authority. The full city council will be more involved and that will benefit the entire city. Councilmember Pearson asked if the current EDA members had shared their thoughts. It was shared that two of the current members had emailed comments to two city councilmembers. September 7,2021 Minutes Councilmember Wilson stated that since 2004 the city has had a number of different makeups of the EDA. Feels that the city councilmember makeup makes the most sense. Feels there has been tension between the city council and the EDA. Feels that previous city council's have not been as assertive as they could have been and this change is in line with the priorities established by the city council. Councilmember Bernhjelm felt this change will bring more visibility to what the EDA does on a monthly basis. Mayor Hoyt shared that the EDA has met four times in eight months. When this issue was brought up by staff, he looked at the pros and cons of different set ups and more. BR and E visits is the only 2021 achieved. Changing to the city council is the best decision at this point. Councilmember Pearson was disappointed to current EDA members were in attendance. She is not a fan of group thinking but is disappointed she has not seen more communication from members. Mayor Hoyt asked for any additional comments from those in attendance. There were no additional comments from the public. Motion by Wilson, second by Porter,to close the public hearing. APIF, motion carried. Motion by Wilson, second by Bernhjelm, to amend the enabling resolution R44-2021 and adopt Ordinance 2021-763 revising the composition of the Economic Development Authority to the five sitting city councilmembers effective September 7, 2021. APIF, motion carried. 9) Award of Contract None 10) Petitions, Requests and Communications None 11) Unfinished Business None 12) New Business None September 7, 2021 Minutes 13) City Council Roundtable Bernhjelm-Encou raged Farmington Business nominations for the upcoming chamber Business Excellence Awards that she is chairing. Pearson-School is back in session so please watch out the kids. Encouraged everyone to attend Dew Days on September 18tH Wilson-Congratulated two of our fire department staff for their promotions approved tonight. McKnight-Updated the city council on the downtown sidewalk project and planned maintenance on all three railroad crossings next week. Omlid-Welcomed Katie Putt to the Parks and Recreation Commission. Shared information on an upcoming celebration in recognition of National Senior Center Week. Encouraged everyone to donate to the Kiss the Pig contest. Gorski-Welcome Josh Solinger to the team and looks forward to what he will do for our liquor stores. Regis-Shared that he is excited to be here in Farmington. Koch-Shared that Judge Meserich will be retiring soon and that the courts backlog is estimated to be cleared up by spring 2023. Rutherford-School is in session and asked everyone to look out for the busses and kids. Elvestad-Shared that the new group of candidates started their academy training tonight and apparatus testing continues in the department. Hoyt-School is in session so please watch out for the kids. 13. Closed Session Motion by Wilson,second by Porter,to go into closed session as allowed under M.S. 13D to conduct the annual performance review of City Administrator McKnight. APIF, motion passed. Present in the closed session were all five city councilmembers,the city attorney and the city administrator. The closed session began at 7:42 p.m. September 7,2021 Minutes 14. Adjourn Motion by Wilson,second by Bernhjelm,to adjourn the meeting at 8:17 p.m. APIF, motion carried. Respectfully Submitted Da4-vd Y. "C'1 nvli' David McKnight, City Administrator September 7,2021 Minutes CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 p, O Farmington M N.gov TO: Mayor, Councilmembers and City Administrator FROM: David McKnight, City Administrator SUBJECT: Approve Minutes of the September 7, 2021 City Council Work Session- Administration DATE: September 20, 2021 INTRODUCTION Attached for your review are the minutes of the September 7, 2021 city council work session. DISCUSSION NA BUDGET IMPACT NA ACTION REQUESTED Approve the minutes of the September 7, 2021 city council work session. ATTACHMENTS: Type Description ❑ Cover Memo September 7, 2021 Work Session Minutes CITY OF FARMINGTON CITY COUNCIL MINUTES WORK SESSION SEPTEMBER 7,2021 Call to Order Mayor Hoyt called the work session to order at 5:45 p.m. Roll Call Present-Hoyt, Bernhjelm, Pearson, Porter and Wilson Absent-None Also Present-Administrator McKnight,Assistant City Administrator Gorski, Finance Director Regis, Parks and Recreation Director Omlid and Assistant Fire Chief Albee. Agenda Motion by Wilson,second by Bernhjelm,to approve the agenda as presented.APIF, motion carried. Fire Relief Association Request Fire Relief Association President Albee appeared before the city council to both explain how the Farmington Fire Department Relief Association (FFRA)operates and to ask for an increase in the pension contribution for 2022. The FFRA is requesting an increase in the annual pension contribution from $6,500 per year to$7,500 per year. The FFRA had a funding status of 152%at the end of 2020 and it is estimated to be at 180% funded today. If the requested increased was awarded,the FFRA estimates the funding status would be at 142%. Councilmember Wilson stated he was comfortable with the request and asked how financial projections were used to determine their funding status. Albee shared that it was assumed that all members would be paid out 100% based on their years of service if all payouts had to be made today. Wilson asked how the FFRA looks at the market in the future. Albee stated that the FFRA uses its own financial advisor and has to follow investment rules established by the state. Wilson asked Administrator McKnight how he felt about the request. McKnight stated he is in support of the increase and has watched how the FFRA board has changed over the years to set itself up for long-term success. Mayor Hoyt asked what the increase in funding status to 180%was a result of. Albee stated it was the stock market. The consensus of the city council was to support the requested increase effective January 1, 2022. 2022 Budget Update Administrator McKnight provided an update on the 2022 budget development. The city council discussed the 2022 General Fund budget and tax levy at work session in July, August and September 2021. The city council discussed matching the three priorities that were set for 2021 and 2022 represented in any growth in the tax levy. The three priorities set by the city council include- 1. Business Growth 2. Community Engagement 3. Infrastructure Support During the budget work session discussions, the city council asked that any increase in the tax levy be focused on the priorities set by the city council and as visible as possible to the community. The proposed budget and tax levy are shown below- 2021 Budget 2022 Proposed Increase Budget (Decrease) Revenues $3,298,344 $3,711,583 12.53% Expenditures $13,832,464 $15,829,719 14.44% Fiscal Disparities $2,277,659 $2,351,400 3.24% General Fund Levy $8,256,461 $9,766,736 18.29% Debt Levy $3,012,093 $ 2,265,788 (24.78%) Net Tax Levy $11,268,554 $12,032,524 6.78% General Fund Revenues Revenues have continued to move in a positive direction overall since the start of the pandemic. The current draft of the budget has revenues at$3,711,583 which represents a 12.53%increase over 2021. The General Fund has revenues outside of the tax levy. These revenues come from a variety of sources shown below. 2021 Budget 2022 Proposed Increase Budget (Decrease) Licenses and Permits $517,076 $736700 42.47% Intergovernmental Revenue $667,912 $672,087 0.63% Charges for Service $576,197 $602,460 4.56% Fine and Forfeitures $49,000 $50,000 2.04% Investment Income $29,100 $41,600 42.66% Miscellaneous $79,370 $180,878 127.89% Transfers In $1,379,689 $1,427,858 3.49% Total Revenues $3,298,344 $3,711,583 12.53% Revenue items of note for the proposed 2022 budget include: • Permit revenue is projected to increase by$219,624. This increase is attributed both to the increased number of homes being built in Farmington and the continued permit revenue from items such as new decks, basements, bathrooms, etc. • Investment income is proposed to increase by$12,500. This is based upon our historical returns the past few years. • Miscellaneous revenue is proposed to increase by$101,508 based upon our historical average. General Fund Expenditures There have been a number of reviews and revisions in an effort to lower the overall levy increase. The proposed 2022 expenditures are summarized below- 2021 Budget 2022 Proposed Increase Budget (Decrease) Administration $902,915 $1,099,249 21.74% Human Resources $361,658 $402,112 11.19% Dakota Broadband $37,500 $45,500 21.33% Finance/Risk Management $776,287 $818,759 5.47% Police $4,845,796 $5,279,810 8.96% Fire $1,435,685 $1,592,646 10.93% Community Development $1,007,849 $1,059,182 5.09% Engineering $813,895 $850,411 4.49% Municipal Services $1,511,187 $1,609,704 6.52% Parks and Recreation $1,317,341 $1,329,737 0.94% Transfers Out $822,351 $1,742,609 111.91% Total Expenditures $13,832,464 $15,829,719 14.44% Human Resources Costs All of the budgets include estimated human resources costs based upon estimated union contract negotiations/settlements and estimates for employee benefits and workers compensation premiums. Union contract negotiations are currently underway with all four of our unions. We have also been notified that we will receive a 5%increase in our health insurance premiums for 2022. Expenditure items of note in the draft 2022 budget include- • The Administration budget includes budgeted dollars for the Assistant City Administrator position that was added in mid-2021. • The three police budgets have a variety of smaller increase that make up the majority of their proposed increase for 2022. There is a larger increase in the benefits line item that may be able to be reduced depending on the outcome of current negotiations. • The Fire budget also has a number of smaller increases that make up for their proposed increase for 2022. Two of these increases include dollars for looking at future station needs of the department and dollars to start to replace tables and chairs that are used on a regular basis. Operating Transfers The operating transfers portion of the proposed General Fund budget represents the largest dollar increase for 2022. This budget is used for a variety of items that current and previous city councils have listed as priorities, are projects that funding carries over from year to year and/or items that the city council/staff want to emphasize for a variety of reasons. The proposed 2022 General Fund Transfers budget is proposed to increase from $822,351 in 2021 to$1,742,609 in 2022. The significant increases in this budget include- • Increase in the mill and overlay line item of$318,792 to a total of$650,000 to complete the mill and overlay of Akin Road in 2022. • Trail maintenance line item increase of$65,000 to a total of$135,000 to continue to address and improve the condition of our trail system on an annual basis. • The addition of$175,000 as a portion of the first debt repayment that will be associated with the Spruce and Division Streets/Parking Lot project in 2022. • The General Fund has not had a realistic and dedicated line item for vehicle and equipment replacement for a number of years. The 2022 draft budget includes $475,000 for vehicle purchases. This is a $331,011 increase over 2021. This line item has some significant purchases lining up in future years including a grader, vac truck and more. Fiscal Disparities This is a metro wide program that is used to balance the development of commercial and industrial growth throughout the region. The city has received a preliminary estimate of the final number which includes an increase of$73,741. Debt Levy The Debt Service Fund budget provides funding for scheduled debt service and interest repayment obligations, as well as ongoing trustee, assessments, arbitrage and post-issuance compliance fees related to the city's debt. The levy includes both general obligation bonds and interfund loans. The 2022 debt levy is 24.78% lower than the 2021 debt levy. The reduction is due to paying off debt including that associated with the police station construction. Details on the debt levy obligations are included with this memo. Additional Note The city continues to make progress to reach adequate funding levels in a number of areas including pavement management, trail maintenance, building maintenance and fleet replacement. I have tried to achieve as many of the priorities that individual city councilmembers shared during work session discussions. While I think this budget achieves a lot of the priorities, in reality not all of them can be met in 2022. One item that is not yet reflected in the budget, but will be included in the final version in December is the use of the "additional" dollars we expect from the Hy-Vee assessments. In analyzing the options for the use of the dollars, I am proposing that we purchase three lawn mowers for the Parks and Recreation Department that are in need of replacement. This expenditure will use all of these potential one-time dollars and not impact the proposed tax levy. The estimated market value of the average residential property in Farmington will be$282,815 in 2022. This is up 3.95%from the 2021 average residential property. The current proposed 2022 tax levy amount would increase the city tax on the average property by$76 per year. Councilmember Wilson asked about the future fire engine replacement dollars. McKnight shared that this amount was taken out of the budget at this point. There is$50,000 that could be set aside for this purpose. Councilmember Bernhjelm reminded all that this issue was discussed,and we will still have to bond for the engine at this rate and might want to consider using these dollars elsewhere. Wilson asked about a potential cost per home to operate city government. McKnight stated that staff can look at this to see if it feasible. Wilson shared his thoughts on how to market the increase to show residents why it is needed. Councilmember Porter shared that we should consider multiple avenues when it comes to education tools for residents. Councilmember Pearson still does not think this number will go over well. We need to focus on the$76 and not the percentage. She has concerns with the permit numbers as well. Mayor Hoyt shared that he is happy we moved away arbitrary percentage numbers and are focusing on the needs that have been pushed off for years. Pearson shared that businesses are coming to Farmington,they are just not the big box businesses. The city council would like the budget presentations and information to focus on the priorities and where potential tax levy increases will impact the community. City Administrator Update Administrator McKnight updated the city council on the following items- Vita Attiva development ✓ Employee picnic scheduled for Wednesday ✓ Upcoming conference attendance Adjourn Motion by Bernhjelm,second by Porter,to adjourn the meeting at 6:29 p.m. APIF, motion carried. CITY OF 0 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 t Farmington MN.gov TO: Mayor, Councilmembers and City Administrator FROM: David McKnight, City Administrator SUBJECT: Approve Joint Powers Agreement Establishing the Criminal Justice Network Board- Administration DATE: September 20, 2021 INTRODUCTION Over the course of the past year, a number of cities in the county, along with Dakota County, have been in discussions about creating a new joint powers group to handle the operation and maintenance of technology systems to support criminal justice agencies and information management systems for the use and benefit of the parties involved. DISCUSSION The purpose of the proposed joint powers agreement is to establish the Criminal Justice Network(CJM), a joint powers entity to provide information management systems and technology service to support criminal justice agencies for the use and benefit of the members and others;to provide personnel benefits for the employees of CJ N;to define the rights and obligations of the members with respect to the establishment, operation and maintenance of CJ and to provide a forum for discussion,study, development and implementation of recommendations of mutual interest regarding criminal justice processes, information systems and integration of criminal justice information systems. This work used to occur under the Criminal Justice I nformation and I N that was housed under the direction of Dakota County. The county is looking to get out of the current setup and have this work be housed under a joint powers agreement. I was a part of the work group that negotiated the draft joint powers agreement you are being asked to consider. The group included the county attorney,the police chiefs from Hastings and South St. Paul,the chief deputy sheriff.,the Burnsville city manager and the CA I N executive director. This agreement is what would call a best case scenario in terms of getting what we can at this point and giving the members time to prepare for the financial realities of the future. The highlights of the proposed joint powers agreement include- 1. 1 nitial Members-Dakota County, Burnsville, Farmington, Hastings, I nver Grove Heights, Mendota Heights, Rosemount, South St. Paul and West St. Paul. 2. Effective Date-January 1, 2022. 3. 1 nitial Term-Five Years (January 1, 2022 through December 31, 2026) 4. Board Composition-The board for the JPO will consist of one board representative for each member who is appointed by the head of the members law enforcement agency. I n addition,the County Board is entitled to appoint one representative to the board. 5. Financial Contributions-The CJN annual budget will be comprised of the following funding components- • Operations-The city members and and Sheriffs Office will contribute to the Operations Fund in proportional share based on the population of the geographical areas for which it provides law enforcement services. The J PA sets out the contribution percentages for 2022. • Records Management Systems (RMS)-This funding component will be utilized to pay for costs associated with the following items; (1) RMS maintenance and support of ProPhoenix; (2)The development fund; (3) escrow to maintain ProPhoenix RMS code in a secure location; and (4) staff support. The City members and Sheriff's Office will contribute equally to the RMS fund for the costs associated with items (1)through (3). City members and the Sheriff's Office will contribute to staff support based on their proportional total number of CJN users. The JPA sets out the contribution percentages for 2022 related to staff support. • The CJN Board may authorize an additional funding component as necessary to generate reserve funds. • The County will contribute a fixed annual subsidy in the amount of$472,642. This is an addition to the separate contributions made by the Sheriff's Office. 6. CJN Fund Balance-The County shall transfer to CJN all funds in the County's CJN Operations and CJN Records Management accounts. 7. 1 n-Kind Contributions-The County will provide in-kind services at no cost as follows: • Employee Relations services for one year. • Fiscal agent for two years • I T desktop support for two years • Risk management assistance for two years • Payroll and benefits administration for five years • Legal services for five years. CJN will be required to pay the DCAO for costs of litigation. 8.Member Withdrawal-No member may withdraw from the agreement during the initial term. 9.Assignment of CJ N Software-The county will assign all rights,title and interest in the CJN software to the CJ N JPO. If the J PO is disbanded or terminated during the initial term, CJ N is required to reassign all rights,title and interest in the software to the county. BUDGET IMPACT The joint powers agreement has minimal impact on the city for the first five years. After year five,the county subsidy will go away and the remaining members will need to make up those dollars. Each city has the five years to start to prepare for this needed additional funding. ACTION REQUESTED Ask any questions you may have on the proposed joint powers agreement. Once the city council is comfortable, a motion should be made to approve the Joint Powers Agreement Establishing the Criminal Justice Network Board. ATTACHMENTS: Type Description ❑ Cover Memo CJN Joint Powers Agreement Joint Powers Agreement Establishing the Criminal Justice Network Board Table of Contents Contents RECITALS.......................................................................................................................................................................4 ARTICLE 1 Statement of Purpose and Powers to be Exercised............................................................................4 ARTICLE2 Definitions............................................................................................................................................4 ARTICLE 3 Term and Effective Date ......................................................................................................................5 ARTICLE 4 Manner of Exercising Powers..............................................................................................................5 ARTICLE5 Membership.........................................................................................................................................5 5.1 Initial Members.............................................................................................................................................5 5.2 Additional Members.....................................................................................................................................5 5.3 Requirement of Good Standing....................................................................................................................6 ARTICLE6 Joint Powers Board ..............................................................................................................................6 6.1 Establishment of the Board..........................................................................................................................6 6.2 Powers of the Board.....................................................................................................................................6 6.3 Board Representatives and Vacancies..........................................................................................................7 6.4 Board Governance—Officers........................................................................................................................7 6.5 Board Governance—Voting..........................................................................................................................8 6.6 Board Committees........................................................................................................................................8 6.7 Board Meetings.............................................................................................................................................8 ARTICLE7 Executive Director................................................................................................................................8 ARTICLE 8 Budget And Funding.............................................................................................................................8 8.1 Fiscal Year.....................................................................................................................................................8 8.2 Recommended Annual Budget.....................................................................................................................8 8.3 Member Contributions to Adopted Budget .................................................................................................9 8.4 Expenditure of the Annual Budget.............................................................................................................10 8.5 Criminal Justice Network Fund Balance Transfer.......................................................................................10 8.6 In-Kind Contributions..................................................................................................................................10 8.7 Legal Services..............................................................................................................................................10 8.8 Credit or Payment to Members for Services..............................................................................................10 ARTICLE9 Audit...................................................................................................................................................10 ARTICLE 10 Termination And Dissolution.............................................................................................................11 10.1 Termination. ...............................................................................................................................................11 10.2 Effect of Termination..................................................................................................................................11 CJN JPA Page 2 of 22 07.14.21 10.3 Distribution of Assets..................................................................................................................................11 ARTICLE 11 Withdrawal Of A Member.................................................................................................................11 11.1 Unilateral Withdrawal.................................................................................................................................11 11.2 Effect of Withdrawal...................................................................................................................................11 ARTICLE 12 Insurance And Indemnification .........................................................................................................12 12.1 Responsibility for Own Acts and Omissions................................................................................................12 12.2 No Waiver...................................................................................................................................................12 12.3 Indemnification...........................................................................................................................................12 12.4 Insurance ....................................................................................................................................................12 12.5 Uninsured Liability......................................................................................................................................13 ARTICLE 13 Intellectual Property..........................................................................................................................13 ARTICLE 14 Miscellaneous Provisions.................................................................................................................134 14.1 Amendments. .............................................................................................................................................14 14.2 Governing Law and Venue..........................................................................................................................14 14.3 Counterparts...............................................................................................................................................14 CJN JPA Page 3 of 22 07.14.21 This Joint Powers Agreement (as amended from time to time, this "Agreement") is entered into between the undersigned parties (also referred to herein as "Members"), all being political subdivisions of the State of Minnesota, by and through their respective governing bodies. RECITALS WHEREAS, pursuant to Minn. Stat § 471.59, political subdivisions in the State of Minnesota are empowered to provide assistance to, and act in coordination with, other political subdivisions as deemed necessary to benefit the public; and WHEREAS, the parties to this Agreement wish to jointly and cooperatively provide for the establishment, operation and maintenance of technology systems and services to support criminal justice agencies and information management systems for the use and benefit of the parties and others; and WHEREAS, the parties to this Agreement wish to create and establish a joint powers entity and joint powers board referred to as the Criminal Justice Network to collaboratively accomplish their mutual goals of improving and supporting criminal justice agency information management systems and capabilities. NOW, THEREFORE, in consideration of the mutual promises and benefits that each Party shall derive here from, the parties agree as follows: ARTICLE 1 Statement of Purpose and Powers to be Exercised The purpose of this Agreement is: (1) to establish CJN, a joint powers entity to provide information management systems and technology services to support criminal justice agencies for the use and benefit of the Members and others; (2) to provide personnel benefits for the employees of CJN; (3) to define the rights and obligations of the Members with respect to the establishment, operation and maintenance of CJN; and (4) to provide a forum for discussion, study, development and implementation of recommendations of mutual interest regarding criminal justice processes, information systems and integration of criminal justice information systems. ARTICLE 2 Definitions 2.1 'Board" means the Criminal Justice (CJN)joint powers board formed by this Agreement. 2.2 "Criminal Justice Network" or "CJN" means the joint powers entity formed by this Agreement. 2.3 "Initial Member" is a governmental unit that executed this Agreement as of the Effective Date and created the Criminal Justice Network (CJN) Board. 2.4 "Law Enforcement Agency" means a unit of state, local government, or federally-recognized tribe that is authorized by law to grant full powers of arrest and to charge a person with the duties of preventing and detecting crime and enforcing the general criminal laws of any state, and/or incarcerating individuals.This includes, without limitation: municipal police departments, CJN JPA Page 4 of 22 07.14.21 county sheriff departments (both patrol and jail functions), the Minnesota Department of Corrections, the Minnesota Bureau of Criminal Apprehension, and the Minnesota State Patrol. 2.5 "Member" means an Initial Member and each additional governmental unit satisfying the requirements of Section 5.2 after the Effective Date of this Agreement but excluding any governmental unit that has withdrawn from the Agreement pursuant to Article 11 hereof. 2.6 "Membership Fee" means the amount of the operating and capital costs of ON that is charged to an individual Member for a fiscal year. 2.7 "Supermajority" means two-thirds (66.7°/x)of the Board representatives. 2.8 "System Fees" means the amount of money a Member or non-Member pays to access and use the systems and applications developed or purchased by ON or services provided by ON. ON shall not charge System Fees to the County for its non-Law Enforcement Agency users during the Initial Term of this Agreement.A Member's System Fee is in addition to the Member's annual Membership Fee. 2.9 "Total Membership Fees" means the total amount of the operating and capital costs of ON that is approved by the Board and charged to all Members for each fiscal year to assist in funding the total costs of ON. 2.10 "Withdrawing Member" means a Member that has given notice of its intent to withdraw from the Agreement pursuant to Section 11.1. ARTICLE 3 Term and Effective Date This Agreement is effective, and the joint powers entity is established, on January 1, 2022, referred to herein as the Effective Date, and shall continue until December 31, 2027, or until terminated as provided in Article 10 or as required by law or court order("Initial Term"). ARTICLE 4 Manner of Exercising Powers The joint powers of the Members will be exercised through the Board having the powers and duties described herein. The Board is authorized to exercise the joint powers on behalf of and in cooperation with the Members as provided herein. ARTICLE 5 Membership 5.1 Initial Members.The Initial Members are the County of Dakota ("County"), the City of Burnsville, the City of Farmington, the City of Hastings,the City of Inver Grove Heights, the City of Mendota Heights, the City of Rosemount, the City of South St. Paul, and the City of West St. Paul. 5.2 Additional Members. In addition to the Initial Members, any governmental unit as defined in Minn. Stat. § 471.59 that maintains a Law Enforcement Agency is eligible to become a Member, subject to the prior approval of the Board, by: ON JPA Page 5 of 22 07.14.21 A. Executing and delivering to the Board a counterpart signature page to this Agreement, indicating its acceptance of the terms and conditions hereof; and B. Satisfying such other conditions mandated by the Board at the time as a condition to becoming a Member, and payment of a Membership Fee. 5.3 Requirement of Good Standing. Continued membership in ON is contingent upon the payment by each Member of the annual Membership Fees as determined by the Board. After being given notice and 30 calendar days to cure any default for non-payment of fees, Members who are not in good standing may be terminated from this Agreement by a Supermajority vote of the Board. Members who are involuntarily terminated by the Board shall not act to discharge any liability incurred or chargeable to the Members before the effective date of termination, and the terminated Member is not entitled to any distribution of assets or fees paid, all as stated in Section 11.2. ARTICLE 6 Joint Powers Board 6.1 Establishment of the Board.The parties hereby establish the Board as a joint powers board, which shall jointly exercise such powers and authorities as are necessary to achieve its purposes as provided in Article 1. The Board shall be an entity separate from the parties and shall not be deemed to be an agent or partner of the parties to this Agreement. 6.2 Powers of the Board.The Board shall have the following powers and duties: A. To take actions necessary and convenient to discharge the duty to implement, maintain and operate the systems and applications necessary for the continuation of ON and its integration of information systems for criminal justice agencies; B. To adopt bylaws and rules or policies consistent with this Agreement that are required to effectively exercise the powers or accomplish the objective of CJN; C. To adopt an annual operating and capital budget, including a statement of sources of funding and allocation of costs to the Members; D. To enter into contracts in its own name, including contracts to purchase materials, goods, or services and contracts to provide its Members and non-Members with access and use of systems and applications developed or purchased by ON and other services provided by CJN; E. To establish processes for setting and charging System Fees; F. To acquire, lease, hold and dispose of property, both real and personal including transfer of property from a Member to CJN; G. To arrange with one or more of the Members to incur debt or issue bonds for the benefit of ON, as permitted by law; H. To develop, acquire, operate and maintain applications and systems for criminal justice agencies to improve operational efficiencies, integrate information between criminal justice agencies, including those systems acquired jointly and cooperatively for the benefit of the Members; I. To hire, discipline, or discharge employees required to accomplish the purposes of this Agreement, including employing an Executive Director and delegating personnel authority to the Executive Director; ON JPA Page 6 of 22 07.14.21 J. To purchase any insurance or indemnity or surety bonds as necessary to carry out this Agreement and purpose of CJN; K. To seek, apply for, and accept appropriations,grants, gifts, loans of money, or other assistance as permitted by law from any person or entity, whether public or private; L. To commence any type of legal action or proceeding permitted by law to protect CJN's property and interests; M. To exercise all powers necessary and incidental to carrying out the purposes set forth in Article 1 of this Agreement; N. To contract with a Member or third party for auditing, financial, human resources, information technology, risk management, legal, and other services as needed for CJN; and 0. To approve contracting and purchasing policies for ON. 6.3 Board Representatives and Vacancies. A. Board Creation and Composition. The Board shall consist of one Board representative from each of the Members who is appointed by the respective head of the Member's Law Enforcement Agency. Each Member shall also be entitled to appoint an alternate Board representative, who shall act for the Board representative during that individual's absence. In addition, for the Initial Term of this Agreement,the County's Board of Commissioners is entitled to appoint one Board representative and one alternate. This Agreement at times uses the term "Board representative" to refer to both a Board representative and that representative's alternate. B. Board Compensation. Board representatives shall serve without compensation from ON, but this shall not prevent a Member from providing compensation for a Board representative if such compensation is authorized by the Member and by law. C. Representative Terms. The terms of each Board representative will be established in the Board's bylaws. Any Board representative shall be subject to removal by the appointing Member at any time, with or without cause. If any Board representative is removed by the appointing Member,the vacancy shall be filled by that appointing Member. A Board representative's term terminates at such time as the individual ceases to be a member of the governing body of the applicable Member or an employee of the applicable Member. 6.4 Board Governance—Officers. At its first meeting, and its first regular meeting of each subsequent year, the Board shall elect a Chair and Vice Chair from among the Board representatives. The Chair and Vice Chair shall be elected by the Board for one-year terms. The Chair shall preside at all meetings of the Board and shall perform other duties and functions as may be determined by the Board. The Vice Chair shall preside over and act for the Board during the absence of the Chair. 6.5 Board Governance—Voting. A. Actions of the Board will be taken by vote of the Board in which each Board representative shall have one equal vote. Proxy voting is not permitted.The Board shall function by a majority of the Board representatives present at the time of the vote. B. Decisions of the Board will be made by a majority of the votes cast except where a Supermajority is required. ON JPA Page 7 of 22 07.14.21 C. A Board representative shall not be entitled to vote on behalf of the Member during the time that such Member is in default on any contribution to CJN or on any contract with CJN. During the existence of such default, the vote or votes of such Member shall not be counted as eligible votes. 6.6 Board Committees. The Board may appoint standing committees, ad hoc committees and workgroups, with the powers described in the Board's bylaws or in resolutions adopted to establish the committee or workgroup. 6.7 Board Meetings.The Board shall meet as set forth in the bylaws adopted by the Board or upon a call of the Board Chair. All meetings of the Board shall comply with Minnesota Statutes Ch. 13D, the Minnesota Open Meeting Law. ARTICLE 7 Executive Director CJN shall have a chief operating officer with the title Executive Director. The Executive Director shall be the administrative head of CJN and shall report to the Board and the Executive Committee, if the Board creates one,for the administration and operation of CJN. The Executive Director shall be an employee of CJN. Any vacancy in the office of the Executive Director shall be filled as soon as possible after the effective date of such vacancy. In the case of absence or disability of the Executive Director,the Board may designate any other qualified person to carry out the duties of the Executive Director during such absence or disability. ARTICLE 8 Budget and Funding 8.1 Fiscal Year.The fiscal year for CJN shall be the calendar year. 8.2 Recommended Annual Budget. The annual budget of CJN must be adopted in the following manner: A. The Executive Director shall prepare a proposed annual operating and capital budget for the following fiscal year for consideration by the Board no later than April 1St of each year; B. Annually, prior to April 11 the Executive Director shall deliver to each Board representative a copy of the proposed budget; C. Annually prior to May 1st, the Board will supply each Member with a proposed budget for the following fiscal year; and D. The annual budget for the following fiscal year shall be adopted at a meeting of the Board in June. If the Board fails to adopt a budget by July 11t, the budget from the current fiscal year shall be deemed approved for the next fiscal year. This requirement to adopt a budget at a regular meeting of the Board by July 1St does not apply to the calendar year in which this Agreement is first executed; however,the Board shall adopt a budget for the first fiscal year of this Agreement at its first Board meeting in 2022. CJN JPA Page 8 of 22 07.14.21 8.3 Member Contributions to Adopted Budget. A. The Board shall have the authority to fix cost sharing charges for all Members in an amount sufficient to provide the funds required for CJN's operational and capital costs in the budget. B. The CJN annual budget (Total Membership Fees) will be comprised of a minimum of two funding components: Operations and Records Management System (RMS). During the Initial Term, the County will contribute a fixed annual subsidy in the amount of $472,642.00, which shall constitute the County's annual Total Membership Fees, except for Membership Fees assessed to the Dakota County Sheriff's Office pursuant to this section.There will be no annual adjustment of the subsidy amount. C. City Members and the Dakota County Sheriff's Office shall contribute to the Operations fund in proportional share based on the population of the geographical areas for which it provides law enforcement services determined as of July 1 of the previous fiscal year, except for fiscal year 2022. For purposes of this section,the geographical area for which the Sheriff's Office provides law enforcement services means that area outside the boundaries of all cities located within Dakota County, but includes the area within the boundaries of the cities of Coates, Hampton, Miesville, New Trier, Randolph and Vermillion. For fiscal year 2022, the contribution from each of those Members for the Operations fund shall be: City of Burnsville 20.0% City of Farmington 6.0% City of Hastings 7.6% City of Inver Grove Heights 8.9% City of Mendota Heights 6.2% City of South St Paul 7.0% City of West St Paul 12.4% Dakota County Sheriff's Office 25.6% City of Rosemount 6.2% County of Dakota 0.0% D. The RMS funding component of the CJN annual budget is to be utilized to pay for costs associated with the following items: (1) RMS maintenance and support of ProPhoenix; (2) the development fund; (3) escrow to maintain ProPhoenix RMS code in a secure location; and (4) staff support. The City Members and the Dakota County Sheriff's Office shall contribute equally to the RMS fund for the costs associated with items (1) through (3). For costs associated with staff support, the City Members and the Dakota County Sheriff's Office shall contribute to the RMS fund based on their proportional total number of users determined as of July 1 of the previous fiscal year, except for fiscal year 2022. For fiscal year 2022, the contribution from each of those Members for the RMS fund shall be as follows: City of Burnsville 29% City of Farmington 10% City of Hastings 10% City of Inver Grove Heights 16% City of Mendota Heights 5% City of South St Paul 10% City of West St Paul 10% ON JPA Page 9 of 22 07.14.21 Dakota County Sheriff's Office 10% City of Rosemount 9% County of Dakota 0% E. The Board may authorize an additional funding component as necessary to generate reserve funds in the event the Members amend the term of this Agreement beyond the Initial Term. F. Upon adoption of the budget by the Board, each Member is obligated to make payments to CJN for the Member's Membership Fees for the following fiscal year in accordance with this Article, except as adjusted to account for withdrawal of a Member consistent with Article 11. 8.4 Expenditure of the Annual Budget. A. The Board may establish procedures and limitations as may be necessary to preserve the integrity and purpose of the approved operating and capital budget (Total Membership Fees). After adoption of the annual operating and capital budget by the Board,the Executive Director shall make all expenditures in accordance with such budget. Purchases and letting contracts shall be done in accordance with procedural guidelines established by resolution of the Board, consistent with Minnesota law. B. The Executive Director shall have the power to transfer funds within the total annual operating budget in order to meet unanticipated needs or changed situations. The Executive Director shall not transfer funds within the total annual capital budget or between the operating budget and capital budget. The Executive Director shall report any transfer of funds within the annual operating budget to the Board in the next report. 8.5 Criminal Justice Network Fund Balance Transfer. The County will transfer to CJN all funds in the County's CJN Operations (CJN-OPS) account and in the County's CJN Records Management System (CJN-RMS) account. 8.6 In-Kind Contributions.The Board may accept in-kind contributions from any Member. The County will provide CJN with certain in-kind contributions,which will be subject to, and governed by, the terms of one or more contracts with CJN. 8.7 Legal Services.The Dakota County Attorney's Office ("DCAO") will provide CJN with general legal advice on issues such as JPA governance, data practices, and contract and policy review at no cost during the Initial Term, except that during the Initial Term, CJN shall pay the DCAO for the costs of litigation at the DCAO's current hourly rate for paralegals and attorneys, and for actual costs incurred associated with litigation.The DCAO's provision of legal services to CJN will be subject to the terms of a separate legal services agreement. 8.8 Credit or Payment to Members for Services.The Board may approve annual fee payment or cost allocation credits to any Member that provides in-kind contributions to CJN. ARTICLE 9 Audit The Board shall call for an annual audit of the financial affairs of CJN, to be performed by an independent Certified Public Accountant and completed in accordance with generally accepted auditing CJN JPA Page 10 of 22 07.14.21 principles. The Board shall provide a copy of the audit report to the Members. CJN's books, reports and records shall be available for and open to inspection by the Members at all reasonable times. ARTICLE 10 Termination and Dissolution 10.1 Termination. This Agreement shall terminate upon the occurrence of any one of the following events: A. When Members withdraw pursuant to Article 11 so that in the judgment of the Board it becomes impractical or uneconomical to continue to operate under this Agreement; B. When necessitated by operation of law or as a result of a decision by a court of competent jurisdiction; or C. When a Supermajority agrees, pursuant to a resolution of the governing bodies of the Members, to terminate this Agreement. 10.2 Effect of Termination. Termination shall not discharge any liability incurred by the Board or by the Members during the term of this Agreement. Each Member shall be liable for its own acts and for the acts of the Board to the extent provided by law. Property or surplus money acquired by the Board shall be distributed to the Members in proportion to their contributions. The Board shall approve a final report of its activities and affairs. 10.3 Distribution of Assets. Prior to termination of this Agreement or if ON is otherwise disbanded, the Board shall first adopt a plan providing for the orderly disposition of assets and unwinding of agreements of the Board. Such plan shall provide that following the disposition of any assets owned by the Board and the payment of all obligations of the Board, any funds remaining shall be distributed to the remaining Members who have not previously withdrawn consistent with the approved plan. ARTICLE 11 Withdrawal of a Member 11.1 Unilateral Withdrawal. A. No Member may withdraw from this Agreement during the Initial Term. If the term of the Agreement is extended, a Member may withdraw by providing notice to withdraw to the Board Chair at least eighteen (18) months prior to the withdrawal date, with a copy of a resolution of its governing body indicating its intent to withdraw from this Agreement. B. Upon receipt of the notice to withdraw and the resolution of the governing body of a Member authorizing withdrawal, the Board Chair shall forward a copy of the resolution to all other Members. C. The notice to withdraw shall be made by Registered or Certified Mail to CJN's primary office, in each case, return receipt requested and postage prepaid, which is deemed to have been provided upon receipt as indicated by the date on the signed receipt, certification, or affidavit.The Board Chair may accept notice of withdrawal by more informal means, only if authorized in writing signed by the Board Chair. 11.2 Effect of Withdrawal. Withdrawal of any Member shall not terminate this Agreement except as provided in Section 10.1. Withdrawal shall not act to discharge any liability incurred or ON JPA Page 11 of 22 07.14.21 chargeable to any withdrawing Member before the effective date of withdrawal. Such liability shall continue until appropriately discharged by law or agreement. No withdrawing Member shall be entitled to a refund or distribution of Membership Fees, administrative or operating fees or funds paid, reimbursement or repayment of in-kind contributions, or forgiveness of fees owed to the Board. ARTICLE 12 Insurance and Indemnification 12.1 Responsibility for Own Acts and Omissions. No Member shall be liable for the acts or omissions of another Member, unless it has specifically agreed in writing to be responsible for the same. Each Member acknowledges and agrees that it is insured or self-insured consistent with the limits established in Minnesota State Statutes. Each Member agrees to promptly notify all Members if it becomes aware of any potential Board-related claims or facts that are likely to give rise to such claims. Neither the Board nor any Member shall have the power to do any act or thing the effect of which is to create a charge or lien against the property or revenues of the Board or another Member, except as expressly provided herein or in any of the documents authorized herein. 12.2 No Waiver. Notwithstanding the foregoing, the terms of this Agreement are not to be construed as, nor operate as, waivers of a Member's statutory or common law immunities or limitations on liability, including but not limited to, Minnesota Statutes Chapter 466. Further, the Members' obligations set forth in this Agreement are expressly limited by the provisions of Minnesota Statutes Chapter 466 and Minnesota Statutes section 471.59, and any other applicable law or regulation providing limitations, defenses or immunities to the Members and the Board. For purposes of determining total liability for tort damages, each Member and the Board are considered a single governmental unit and the total liability for all of the Members and the Board shall not exceed the limits on governmental liability for a single governmental unit as specified under Minnesota Statutes Section 466.04, Subd. 1, or as waived or extended by the Board or all Members under Minnesota Statutes Sections 466.06 or 471.981. 12.3 Indemnification.The Board shall be considered a separate and distinct government joint powers entity to which the Members have transferred all responsibility and control for actions taken pursuant to this Agreement. The Board shall comply with all laws and rules that govern a public entity in the State of Minnesota and shall be entitled to the protections of Minnesota Statutes Chapter 466. Without limiting the application of Section 12.1, to the extent of any liability insurance carried by the Board and available for such purpose, and any tail coverage carried by the Board,the Board shall defend, indemnify and hold harmless each Member from any and all liability arising from or as a result of: (i) any accident, injury to or death of any person or loss or damage to tangible or intangible property that may be directly or indirectly caused by the acts or omissions of the Board; (ii) any act of the Board in the observation or performance of any of its responsibilities, or any failure by the Board to perform any such responsibilities; and/or (iii) any actions or inactions of Members taken as a result of their membership on the Board. Nothing in this Agreement shall be construed to provide liability coverage or indemnification to an officer, employee, or volunteer of any Member for any act or omission for which the officer, employee, or volunteer is guilty of malfeasance in office, willful neglect of duty, or bad faith. ON JPA Page 12 of 22 07.14.21 12.4 Insurance.The Board shall provide for worker's compensation benefits for all CJN employees in the amount consistent with state statutes. The Board may also carry additional policies of insurance as it deems appropriate. 12.5 Uninsured Liability. If the Board incurs liability that is in excess of the insurance obtained by the Board, or incurs liability that is outside the coverage of such insurance, the liability shall be distributed among the Members on the basis of each Member's proportional Membership Fee in the year in which the action or inaction giving rise to the liability occurred. ARTICLE 13 Intellectual Property A. The County, through its existing Criminal Justice Network Department, has developed and owns all right, title and interest to software (hereafter "Software") enabling web-based information sharing and tracking between authorized criminal justice agencies. These criminal justice agencies include law enforcement agencies, the Dakota County Attorney's Office, Dakota County Community Corrections, Dakota Communications Center,judicial organizations and related agencies as well as their authorized users. The Software is accessed and implemented through a number of applications including, but not limited to: • Administration • Case Management • eBriefing • eForms • Gun Permits • Integration Services • Jail Transportation Management System • Scheduling • Search • Subscription B. Concurrent with the execution of the Agreement and formation of the new CJN, the County, acknowledging that it has received sufficient consideration from CJN, agrees to assign all rights, title and interest in the Software to CJN. This assignment specifically includes all intellectual property (hereafter"IP") related to the Software including, but not limited to, any copyrights, source code, proprietary databases, online forms, user interfaces, user lists, fee sheets, trade secrets and trademarks, presently owned by the County that are related to and exclusive to implementation and use of the Software. This IP includes any registered or unregistered IP and includes IP arising out of state or federal law. The assignment specifically excludes any third-party databases and non- transferrable licenses to which the County lacks sole ownership or the ability to transfer ownership. The assignment also excludes any County owned databases that are non- exclusive to the implementation and use of the Software. C. Following execution of the Agreement, CJN shall be responsible for entering into any third-party agreements including licensing or other related agreements related to third- party databases and related third-party tools necessary for full implementation and use of the Software. ON JPA Page 13 of 22 07.14.21 D. CJN acknowledges its familiarity with the Software and that as of the execution of the Agreement, the Software is in usable condition, satisfies all operational conditions and accomplishes its intended purpose. E. Upon assignment of the Software to CJN, CJN will assume responsibility for all future costs and expenses related to maintenance, revisions, updates and future developments of the Software as well as any on-going support of third-party users of the Software. F. Upon assignment of the Software, CJN will assume responsibility for any and all costs related to ensuring and monitoring compliance and proper use of the Software by the Members, authorized third parties and their designated users. G. CJN agrees to establish and implement policies and procedures so as to ensure that use of the Software by the Members,third-party users and their authorized users complies with all applicable Federal, State and Local laws. H. Upon assignment of the Software to CJN, CJN will assume all liabilities and responsibilities, both criminal and civil, regarding use of the Software by the Members, third-party users and all of their authorized users. I. CJN agrees to utilize best industry practices in maintaining the on-going confidentiality and security of the Software so as to prevent unreasonable access to all portions of the Software by non-authorized users. J. In the event that CJN is otherwise disbanded or terminated during the Initial Term, CJN agrees, absent any other agreement,to reassign all rights, title and interest in the Software to the County. ARTICLE 14 Miscellaneous Provisions 14.1 Amendments. This Agreement may be amended at any time and from time to time by agreement of all Members that have not previously withdrawn pursuant to Article 11. 14.2 Governing Law and Venue. The laws of the State of Minnesota govern all matters related to this Agreement, without giving effect to the principles of conflict of law. Venue and jurisdiction for any litigation related to this Agreement must be in those courts located within Dakota County, State of Minnesota or U.S. District Court, District of Minnesota. 14.3 Counterparts. This Agreement may be executed by the Members in any number of counterparts. IN WITNESS WHEREOF, each of the Members has caused this agreement to be executed on its behalf as of the date(s) written below. COUNTY OF DAKOTA, MINNESOTA By Its Approved as to form Assistant County Attorney Date File No. KS-21-16 CJN JPA Page 14 of 22 07.14.21 CITY OF BURNSVILLE, MINNESOTA By: Its: Date: ON JPA Page 15 of 22 07.14.21 CITY OF FARMINGTON, MINNESOTA By: Its: Date: ON JPA Page 16 of 22 07.14.21 CITY OF HASTINGS, MINNESOTA By: Its: Date: ON JPA Page 17 of 22 07.14.21 CITY OF INVER GROVE HEIGHTS, MINNESOTA By: Its: Date: ON JPA Page 18 of 22 07.14.21 CITY OF MENDOTA HEIGHTS, MINNESOTA By: Its: Date: ON JPA Page 19 of 22 07.14.21 CITY OF ROSEMOUNT, MINNESOTA By: Its: Date: ON JPA Page 20 of 22 07.14.21 CITY OF SOUTH ST. PAUL, MINNESOTA By: Its: Date: ON JPA Page 21 of 22 07.14.21 CITY OF WEST ST. PAUL, MINNESOTA By: Its: Date: ON JPA Page 22 of 22 07.14.21 CITY OF 0 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 4 FarmingtonMN.gov TO: Mayor, Councilmembers and City Administrator FROM: David McKnight, City Administrator SUBJECT: Approve 2022 Fire Relief Association Pension I ncrease-Administration DATE: September 20, 2021 INTRODUCTION The Farmington Fire Relief Association has requested on increase in the annual contribution amount effective January 1, 2022. DISCUSSION The Farmington Fire Relief Association met with the city council at the September 7, 2021 work session to request an increase in the annual contribution amount effective January 1, 2022. Fire Relief Association President Jeff Allbee presented the request along with information on the financial health of the relief association. The Fire Relief Association is requesting that the annual contribution amount be increased from $7,500 per year to$8,500 year effective January 1, 2022. The association currently has a fund balance of 152%. If the proposed increase is granted,the fund balance would change to 138%. The association goal is to keep the fund balance above 115%. The city council discussed this issue at the September 2021 work session. A number of questions were asked and a discussion took place about the fire relief goal to eventually get the annual amount to $10,000. BUDGET IMPACT The annual contribution that the city makes to the fire relief association of$150,000 is not impacted by this request. ACTION REQUESTED Ask any questions you may have on this issue. If the city council is comfortable, a motion should be made to increase the annual Farmington Fire Relief Association contribution amount from $7,500 to $8,500 effective January 1, 2022. CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 OFarmington MN.gov TO: Mayor, Councilmembers and City Administrator FROM: Cynthia Muller, Administrative Assistant SUBJECT: Approve Temporary On-Sale Liquor License Farmington Liquors-Administration DATE: September 20, 2021 INTRODUCTION Farmington Liquors is requesting a Temporary On-Sale Liquor License for a wine tasting event to be held October 1, 2021. DISCUSSION This event will be held outside at Farmington Liquors, 923 8th Street, Suite 945. Per State Statute, a Temporary Liquor license must first be approved by the city and then forwarded to the state for approval. BUDGET IMPACT The state of Minnesota waives all fees for Temporary Liquor Licenses for non-profit organizations. Therefore,the city has not established a fee for a Temporary On-Sale Liquor License. ACTION REQUESTED Approve the attached application for a Temporary On-Sale Liquor License for Farmington Liquors,for a wine tasting to be held outside at Farmington Liquors,923 8th Street, on October 1, 2021. ATTACHMENTS: Type Description ❑ Exhibit Temporary On-Sale Liquor Application i Minnesota Department of Public Safety Alcohol and Gambling Enforcement Division 445 Minnesota Street,Suite 222,St.Paul,MN 55101 651-201-7500 Fax 651-297-5259 TTY 651-282-6555 Alaohoi&Gambling Enforcement APPLICATION AND PERMIT FOR A 9 DAY TO 4 DAY TEMPORARY ON-SALE LIQUOR LICENSE Name of organization Date organized Tax exempt number err-yin �O�n l,� VorC> 151 Address City State Zip Code Qa3 8 s e ej �yrAtIri� n lFminnesota 556 Name of person making application Business phone Home phone Incl Mc.Y\k\\e..v1 X51-ase-1o`b�S� Date(s)of event Type of organization n(.-A-0bt-r` 70 7, ❑ Club ❑ Charitable ❑ Religious ❑ Other non-profit Organization officer's name City State - Zip Code 65h I Minnesota 5 56 Organization officer's name City State Zip Code I Iminnesota Organization officer's name City State Zip Code Minnesota Organization officer's name City State Zip Code Minnesota Location where permit will be used. if an outdoor area,describe. S1dtv.��l+Jlt. un �M nt OA 't`nwn�e�p oma! U ltiar yore. If the applicant will contract for intoxicating liquor service give the name and address of the liquor license providing the service. If the applicant will carry liquor liability Insurance please provide the carrier's name and amount of coverage. APPROVAL APPLICATION MUST BE APPROVED BY CITY OR COUNTY BEFORE SUBMITTING TO ALCOHOL AND GAMBLING ENFORCEMENT City or County approving the license Date Approved Fee Amount Permit Date Date Fee Paid City or County E-mail Address City or County Phone Number Signature City Clerk or County Official Approved Director Alcohol and Gambling Enforcement CLERKS NOTICE:Submit this form to Alcohol and Gambling Enforcement Division 30 days prior to event. ONE SUBMISSION PER EMAIL,APPLICATION ONLY. PLEASE PROVIDE A VALID E-MAIL ADDRESS FOR THE CITY/COUNTY AS ALL TEMPORARY PERMIT APPROVALS WILL BE SENT BACK VIA EMAIL. E-MAIL THE APPLICATION SIGNED BY CITY/COUNTY TO AGE TEMPORARYAPPLICATIONPSTATE.MN.US CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 Farmington M N.gov TO: Mayor, Councilmembers and City Administrator FROM: Leah Koch,Assistant City Attorney SUBJECT: Acknowledge City Administrator Performance Review Summary-City Council DATE: September 20, 2021 INTRODUCTION Pursuant to state statute, a summary of the performance review conducted of the city administrator by the city council in closed session at the last city council meeting must be included in the packet at the next meeting. DISCUSSION The city council conducted the annual performance review of City Administrator David McKnight in a closed session on September 7, 2021. Pursuant to state statute, a summary of the performance evaluation must be included in the packet at the next meeting. The performance review summary is attached for your review. BUDGET IMPACT NA ACTION REQUESTED Review and acknowledge the performance review summary of City Administrator David McKnight. ATTACHMENTS: Type Description ❑ Cover Memo Performance Review Summary CK CAMPBELL KNUTSON PROFESSIONAL TO: Mayor and City Councilmembers David McKnight, City Administrator Elliott B. Knetsch Joel J.Jamnik FROM: Leah Koch, Assistant City Attorney Andrea McDowell Poehler Soren M.Mattick David S. Kendall DATE: September 20, 2021 Henry A.Schaeffer,III Alina Schwartz RE: City Administrator Evaluation Summary Report Shana N. Conklin James J.Monge,III Jerome M.Porter Leah C.M.Koch Meagan K. Kelley Pursuant to the State's Open Meeting Law, Minn. Stat. Section 13D.05, Subd. 3(a), Benjamin J. Colburn Jared D.Shepherd the City Council conducted a closed meeting for approximately 30 minutes as part of its September 7th Regular Council Meeting to evaluate the performance of City Thomas J. Campbell* Administrator David McKnight. The Mayor and all City Councilmembers, Roger N.Knutson* Administrator McKnight and I attended the closed session. *Retired State law requires that, at its next open meeting,the public body shall summarize its conclusions regarding the evaluation. The following is submitted for Council review and approval as a summary of the evaluation conducted on September 7th. The primary focus and intent of the meeting was to continue the annual performance evaluation around the anniversary of Administrator McKnight's hiring.This meeting is meant to review and modify, as necessary, any of the established personal goals for Administrator McKnight. There was an additional performance evaluation in January 2021. At the meeting, the Council received a brief summary report regarding the most recent evaluation and that the conclusion of that evaluation Administrator McKnight was meeting or exceeding expectations of all the Councilmembers in the following categories: Leadership, Communication, Quality of Work, City Council/City Administrator Relationship,and Overall Rating. In Organizational Culture there was one mark for "Needs Improvement." Each of the Councilmembers indicated that aside from some suggestions on Organizational Culture, there were no deficiencies or problem areas as needing improvement. Administrator McKnight provided Council with a summary of his personal Grand oak otlice Center I performance goals and continued challenges arising from the COVID-19 pandemic 860 Blue Gentian Road including staff turnover and the disbursement of federal COVID-19 relief funds. He Suite 290 also discussed future performance and career goals and his personal work plan for Eagan,Minnesota S 3512 2022 and beyond,which will focus on positive city employment culture,streamlining Main:6S1-4S2-5000 development processes,prioritizing professional or career development,and crafting Fax:6S1-234-6237 the next city budget. www.ck-law.com 217871v1 Page 2 September 20,2021 Mayor, Councilmembers, Administrator The Council fully supports the City Administrator and has confidence in his efforts to execute the goals of the Council for the benefit of the City. Several Councilmembers credited the City Administrator on successfully navigating the City during the pandemic. Unlike the typical annual evaluation, the Council did not discuss changes to the Administrator's terms and conditions of employment as a performance evaluation occurred in January 2021 resulting in a compensation adjustment. Action Requested Approve this summary of the performance evaluation. Reslyctfully submitted, Leah Koch 217871v1 CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-280-6800 FarmingtonMN.gov TO: Mayor, Councilmembers and City Administrator FROM: Kellee Omlid, Parks and Recreation Director SUBJECT: Adopt Resolution Accepting Donation from Happy Harry's Furniture to the Rambling River Center-Parks DATE: September 20, 2021 INTRODUCTION_ A donation was recently made to the Rambling River Center(RRC) by Happy Harry's Furniture. DISCUSSION A donation in the amount of$89 was recently made by Happy Harry's Furniture to the RRC. The donation was made through a program created in 2011 in which a customer of Happy Harry's Furniture 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,816.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. The donation has been deposited into the RRC Capital Improvement Fund to fund future building improvements and/or purchase new equipment and furniture. Staff will communicate the City's appreciation on behalf of the City Council to Happy Harry's Furniture for their generous donation to the RRC. BUDGET IMPACT NA ACTION REQUESTED Adopt the attached resolution accepting the donation of$89 from Happy Harry's Furniture to the RRC. ATTACHMENTS: Type Description D Resolution Donation Resolution RESOLUTION NO. R46-21 ACCEPT DONATION OF $89 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 201h day of September, 2021 at 7:00 p.m. Members Present: Hoyt, Bernhj elm, Pearson, Porter, Wilson Members Absent: None MembeBernhj elm and Member Wilson introduced and seconded the following: WHEREAS, a donation of$89 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$89 from Happy Harry's Furniture to the Rambling River Center. This resolution adopted by recorded vote of the Farmington Cit o in o session on the 20th day of September, 2021. a Attested to the .2044 day of September, 2021. City Administrator SEAL CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-280-6800 FarmingtonMN.gov TO: Mayor, Councilmembers and City Administrator FROM: Chris Regis, Finance Director SUBJECT: Approve Bills-Finance DATE: September 20, 2021 INTRODUCTION Attached is the August 23, 2021 -September 13, 2021 city council check register and recently processed automatic payments for your review. DISCUSSION N/A BUDGET IMPACT N/A ACTION REQUESTED Approve the attached payments. ATTACHMENTS: Type Description ❑ Backup Material Check Register 9/13/2021 R55CKS2 LOGIS600V COUNCIL MEETING SEPT 20, 2021 CITY OF FARMINGTON 9/13/202112:38:09 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 1 8/12/2021 - 9/13/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 100140 9/3/2021 100493 BELLBOY CORPORATION 18.00- LIQUOR SUPPLIES&MIXES CREDIT 196412 0103730800 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 102.55 LIQUOR&SPIRITS ORDER 196413 0090878800 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 273.95 LIQUOR MIXES&SUPPLIES ORDER 196414 0103800700 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 492.25 LIQUOR&SPIRITS ORDER 196415 0090877100 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 74.33 LIQUOR SUPPLIES&MIXES ORDER 196551 0103837900 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 111.15 BAG ORDER 196551 0103837900 6110 6250 OTHER SUPPLIES&PARTS DOWNTOWN LIQUOR REV&EXP 06100 02 208.10 LIQUOR&SPIRITS ORDER 196552 0090982500 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 114.55 LIQUOR SUPPLIES&MIXES ORDER 196590 0103756800 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 58.55 BAG ORDER 196590 0103756800 6115 6250 OTHER SUPPLIES&PARTS PILOT KNOB LIQUOR 06100 02 67.44 LIQUOR SUPPLIES&MIXES ORDER 196591 0103800900 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 95.20 BAG ORDER 196591 0103800900 6115 6250 OTHER SUPPLIES&PARTS PILOT KNOB LIQUOR 06100 02 1,580.07 100141 9/3/2021 113887 CLEANLITES RECYLING,INC 97.90 ELECTRONICS RECYCLING IT 196095 IN0063860 7400 6401 PROFESSIONAL SERVICES INFORMATION TECHNOLOGY 07400 04 97.90 100142 9/3/2021 117735 CLEAR RIVER BEVERAGE 296.00 BEER ORDER 196433 594464 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 333.58 BEER ORDER 196434 593420 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 408.50 BEER ORDER 196435 593419 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 162.75 BEER ORDER 196549 595559 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,200.83 100143 9/3/2021 100071 COLLEGE CITY BEVERAGE INC 7.75- BEER ORDER CREDIT 196395 722158 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 70.25 WINE ORDER 196396 722159 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 061 DD 02 117.00 BEER ORDER 196436 719901 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 12,425.90 BEER ORDER 196437 722160 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 10,609.39 BEER ORDER 196438 719902 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 193.99 BEER ORDER 196439 720067 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,324.85 BEER ORDER 196440 722287 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 25,445.29 BEER ORDER 196441 720002 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 99.00- BEER ORDER CREDIT 196442 722286 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 89.99 BEER ORDER 196547 724286 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 63.00- BEER ORDER CREDIT 196548 724285 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 5,242.24 BEER ORDER 196550 724287 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 55,349.15 100144 9/3/2021 100022 FARMINGTON PRINTING INC 566.00 PAPER,ENVELOPES 195970 14031 1010 6210 OFFICE SUPPLIES ADMINISTRATION 01000 01 566.00 100145 9/3/2021 113199 LUBE-TECH&PARTNERS,LLC R55CKS2 LOGIS600V CITY OF FARMINGTON 9/13/2021 12:38:09 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 2 8/12/2021 - 9/13/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 1,932.15 HYDRAULIC OIL 196117 2685657 7200 6274 LUBRICANTS&ADDITIVES FLEET OPERATIONS 07200 08 1,932.15 100146 9/3/2021 107747 M.AMUNDSON LLP 1,059.50 CIGARETTES&POP ORDER 196478 326756 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,059.50 100147 9/3/2021 116337 MIDWEST SAFETY COUNSELORS,INC 760.00 INSTRCTOR:AUG'21 SAFETY TRNG 196521 IVC43595 7000 6401 PROFESSIONAL SERVICES EMPLOYEE EXPENSE FUND 07000 02 760.00 100148 9/3/2021 100070 MINNESOTA VALLEY TESTING LABORATORIES 71.00 BAC-T SAMPLE(6)&MTHLY REPRT 195955 1101546 6502 6535 OTHER REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 71.00 100149 9/3/2021 108225 MUNICIPAL EMERGENCY SERVICES,INC 373.51 SAFETY ROPE FOR LADDER TRUCK 195939 IN1607056 4301 6950 MACHINERY,EQUIPMENT&TOOLS FIRE CAPITAL PROJECTS 04300 06 373.51 100150 9/3/2021 117491 POMP'S TIRE SERVICE,INC 153.90 TIRE MOUNTING SERVICE FOR 3215 196091 210543862 6302 6510 1 OUTSIDE VEHICLE REPAIR/MAINT SOLID WASTE OPERATIONS 06300 08 44.50 VALVE STEMS FOR 3215 196091 210543862 6302 6230 VEHICLE SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 12.76- 196091 210543862 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 24.05 VALVE STEMS FOR 3215 196116 210544112 6302 6230 VEHICLE SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 76.95 TIRE MOUNTING SERVICE FOR 3215 196116 210544112 6302 6510 1 OUTSIDE VEHICLE REPAIR/MAINT SOLID WASTE OPERATIONS 06300 08 6.50- 196116 210544112 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 1,614.24 TIRES FOR 0502 196198 210545429 7200 6232 VEHICLE/EQUIPMENT TIRES FLEET OPERATIONS 07200 08 343.36 TIRES FOR T902 196520 210546268 7200 6232 VEHICLE/EQUIPMENT TIRES FLEET OPERATIONS 07200 08 2,237.74 100151 9/3/2021 117381 SHARPER HOMES INC 3,000.00 ER 224 15TH ST 196563 ER 224 15TH ST 4600 2255 DEPOSITS PAYABLE PRIVATE CAPITAL PROJECTS 04600 07 3,000.00 100152 9/3/2021 102247 SUNDGREN,MARK 23.82 APACH RTRN 8-27-2021 196568 20210831 APACH 1000 2255 DEPOSITS PAYABLE GENERAL FUND BALANCE SHEE 01000 RETURN 23.82 100153 9/3/2021 108808 VINOCOPIA,INC 181.00 WINE ORDER 196503 0285076-IN 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 181.00 100154 9/3/2021 108450 WSB&ASSOCIATES INC 7,000.00 JUN-21 CODE ENFORCEMENT SERVIC 196064 R-017977-000-3 1030 6401 PROFESSIONAL SERVICES PLANNING&ZONING 01000 03 7,000.00 156799 9/3/2021 110282 ALLSTATE PETERBILT OF SO ST PAUL R55CKS2 LOGIS600V CITY OF FARMINGTON 9/13/2021 12:38:09 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 3 8/12/2021 - 9/13/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 399.43 ALTERNATOR FOR 3211 196321 3004426624 6302 6230 VEHICLE SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 25.69- 196321 3004426624 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 373.74 155800 9/3/2021 102159 ANCOM TECHNICAL CENTER,INC 150.00 RADIO REBROADCAST REPAIR 196245 103413 1050 6505 EQUIPMENT REPAIR/MAINTENANCE POLICE ADMINISTRATION 01000 05 150.00 155801 9/3/2021 113303 ARTISAN BEER COMPANY 532.25 BEER ORDER 196408 3489654 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 380.00 BEER ORDER 196409 3490994 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,884.75 BEER ORDER 196410 3489701 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 55.40 BEER ORDER 196411 3492336 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 2,852.40 155802 9/3/2021 108446 ASPEN MILLS,INC. 86.49 UNIFORM ITEMS:HANSON,B 196298 278692 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 86.49 155803 9/3/2021 100112 BADGER METER INC 418.44 AUG'21 BEACON MBL HOSTING SERV 196564 80080902 6502 6505 EQUIPMENT REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 418.44 155804 9/3/2021 114472 BREAKTHRU BEVERAGE MN BEER,LLC 13,551.70 BEER ORDER 196416 340580209 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 14,060.50 BEER ORDER 196417 340665130 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 37.75 BEER ORDER 196418 340665132 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 37.75 BEER ORDER 196419 340665131 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 29.50 BEER ORDER 196420 340580210 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 51.90 BEER ORDER 196421 340647595 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 336.00- BEER ORDER CREDIT 196422 408908988 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 40.00- BEER ORDER CREDIT 196553 408443763 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 4,365.05 BEER ORDER 196555 340761622 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 20,922.20 BEER ORDER 196596 340647594 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 52,680.35 155805 9/3/2021 114471 BREAKTHRU BEVERAGE MN WINE&SPIRITS 201.45- WINE ORDER CREDIT 195880 408871451 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 97.45- WINE ORDER CREDIT 195881 408852794 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 189.45- LIQUOR ORDER CREDIT 195882 408840010 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 328.35- WINE ORDER CREDIT 195883 4D8815249 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 881.69- LIQUOR ORDER CREDIT 195884 408815248 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 104.59- LIQUOR ORDER CREDIT 195885 408702390 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 104.59- LIQUOR ORDER CREDIT 195886 408673198 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 455.00 WINE ORDER 196348 340519270 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/13/2021 12:38:09 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 4 8/12/2021 - 9/13/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 1,217.00 LIQUOR&SPIRITS ORDER 196353 340519269 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 8,029.62 LIQUOR&SPIRITS ORDER 196423 340605190 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,494.95 LIQUOR&SPIRITS ORDER 196424 340690290 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 455.00 WINE ORDER 196425 340690291 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 159.02 WINE ORDER 196426 340605191 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 122.75 LIQUOR&SPIRITS ORDER 196427 340690292 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 7,112.33 LIQUOR&SPIRITS ORDER 196428 340732646 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 455.00 WINE ORDER 196429 340732648 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 474.27 WINE ORDER 196430 340732647 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 19,067.37 155806 9/3/2021 108360 CANNON RIVER WINERY 144.00 WINE ORDER 196431 12092 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 300.00 WINE ORDER 196432 12091 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 444.00 155807 9/3/2021 100025 CINTAS CORP LOC 754 44.59 AUG'21 WEEKLY UNIFORM SERVICES 195858 4091935042 1072 6290 UNIFORMS&CLOTHING STREET MAINTENANCE 01000 08 44.57 AUG'21 WEEKLY UNIFORM SERVICES 195858 4091935042 1090 6290 UNIFORMS&CLOTHING PARK MAINTENANCE 01000 09 3.07- 195858 4091935042 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 44.59 AUG'21 WEEKLY UNIFORM SERVICES 195858 4091935042 6202 6290 UNIFORMS&CLOTHING SEWER OPERATIONS EXPENSE 06200 08 47.66 AUG'21 WEEKLY UNIFORM SERVICES 195858 4091935042 6302 6290 UNIFORMS&CLOTHING SOLID WASTE OPERATIONS 06300 08 44.59 AUG'21 WEEKLY UNIFORM SERVICES 195858 4091935042 6402 6290 UNIFORMS&CLOTHING STORM WATER UTILITY OPERA 06400 08 44.05 AUG'21 WEEKLY UNIFORM SERVICES 195858 4091935042 6502 6290 UNIFORMS&CLOTHING WATER UTILITY EXPENSE 06500 08 44.57 AUG'21 WEEKLY UNIFORM SERVICES 196149 4092579642 1072 6290 UNIFORMS&CLOTHING STREET MAINTENANCE 01000 08 44.59 AUG'21 WEEKLY UNIFORM SERVICES 196149 4092579842 1090 6290 UNIFORMS&CLOTHING PARK MAINTENANCE 01000 09 3.07- 196149 4092579842 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 44.59 AUG'21 WEEKLY UNIFORM SERVICES 196149 4092579842 6202 6290 UNIFORMS&CLOTHING SEWER OPERATIONS EXPENSE 06200 08 47.66 AUG'21 WEEKLY UNIFORM SERVICES 196149 4092579842 6302 6290 UNIFORMS&CLOTHING SOLID WASTE OPERATIONS 06300 08 44.59 AUG'21 WEEKLY UNIFORM SERVICES 196149 4092579842 6402 6290 UNIFORMS&CLOTHING STORM WATER UTILITY OPERA 06400 08 44.05 AUG'21 WEEKLY UNIFORM SERVICES 196149 4092579842 6502 6290 UNIFORMS&CLOTHING WATER UTILITY EXPENSE 06500 08 44.57 AUG'21 WEEKLY UNIFORM SERVICES 196257 4093248978 1072 6290 UNIFORMS&CLOTHING STREET MAINTENANCE 01000 08 44.59 AUG'21 WEEKLY UNIFORM SERVICES 196257 4093248978 1090 6290 UNIFORMS&CLOTHING PARK MAINTENANCE 01000 09 3.07- 196257 4093248978 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 44.59 AUG'21 WEEKLY UNIFORM SERVICES 196257 4093248978 6202 6290 UNIFORMS&CLOTHING SEWER OPERATIONS EXPENSE 06200 08 47.66 AUG'21 WEEKLY UNIFORM SERVICES 196257 4093248978 6302 6290 UNIFORMS&CLOTHING SOLID WASTE OPERATIONS 06300 08 44.59 AUG'21 WEEKLY UNIFORM SERVICES 196257 4093248978 6402 6290 UNIFORMS&CLOTHING STORM WATER UTILITY OPERA 06400 08 44.05 AUG'21 WEEKLY UNIFORM SERVICES 196257 4093248978 6502 6290 UNIFORMS&CLOTHING WATER UTILITY EXPENSE 06500 08 44.59 AUG'21 WEEKLY UNIFORM SERVICES 196577 4093923691 1072 6290 UNIFORMS&CLOTHING STREET MAINTENANCE 01000 08 44.59 AUG'21 WEEKLY UNIFORM SERVICES 196577 4093923691 1090 6290 UNIFORMS&CLOTHING PARK MAINTENANCE 01000 09 3.06- 196577 4093923691 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 44.59 AUG'21 WEEKLY UNIFORM SERVICES 196577 4093923691 6202 6290 UNIFORMS&CLOTHING SEWER OPERATIONS EXPENSE 06200 08 47.63 AUG'21 WEEKLY UNIFORM SERVICES 196577 4093923691 6302 6290 UNIFORMS&CLOTHING SOLID WASTE OPERATIONS 06300 08 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/13/2021 12:38:09 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 5 8/12/2021 - 9/13/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 44.59 AUG'21 WEEKLY UNIFORM SERVICES 196577 4093923691 6402 6290 UNIFORMS&CLOTHING STORM WATER UTILITY OPERA 06400 08 44.05 AUG'21 WEEKLY UNIFORM SERVICES 196577 4093923691 6502 6290 UNIFORMS&CLOTHING WATER UTILITY EXPENSE 06500 08 1,067.92 155808 9/3/2021 100081 DAKOTA COUNTY LUMBER COMPANY 5.49 SURROUND BOARD 196580 2108-816244 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 5.49 155809 9/3/2021 109931 FACTORY MOTOR PARTS 40.16 STOCK FILTERS 196122 1-7078411 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 40.16 155810 9/3/2021 111431 FERGUSON WATERWORKS 3,281.75 HYDRANT MODIFY KIT 195923 0477787 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 3,281.75 155811 9/3/2021 100077 FRONTIER COMMUNICATIONS 82.95 SEPT'21 ARENAALARM LINE 196583 651-463-3016 2502 6411 TELEPHONE/CABLE SERVICES ICE ARENA OPERATIONS EXPE 02500 09 SEPT'21 82.95 155812 9/3/2021 100027 GREAT LAKES COCA-COLA DISTRIBUTION,LLC 760.54 POP ORDER 196443 3608213938 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 760.54 155813 9/3/2021 100074 HOHENSTEINS INC 3,485.00 BEER ORDER 196444 433442 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 473.40 BEER ORDER 196445 435290 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,144.80 BEER ORDER 196446 433443 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 129.70 BEER ORDER 196447 437020 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 523.50 BEER ORDER 196594 439108 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 6,756.40 155814 9/3/2021 113417 INDEED BREWING COMPANY,LLC 313.15 BEER ORDER 196448 104101 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 313.15 155815 9/3/2021 109846 JJ TAYLOR DISTRIBUTING COMPANY OF MN INC 8,478.20 BEER ORDER 196449 3209738 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 6,130.25 BEER ORDER 196450 3209707 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 14,014.50 BEER ORDER 196451 3209693 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 2,043.25 BEER ORDER 196508 3209779 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 2,754.80 BEER ORDER 196509 3209739 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 33,421.00 155816 9/3/2021 100033 JOHNSON BROTHERS LIQUOR COMPANY 3,761.16 WINE ORDER 196452 1862729 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/13/2021 12:38:09 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 6 6/12/2021 - 9/13/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 2,016.77 LIQUOR&SPIRITS ORDER 196453 1862727 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 29.51 COCKTAIL ESTNL SIM SYRUP ORDER 196454 1862728 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 269.77 LIQUOR&SPIRITS ORDER 196455 1867731 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,328.92 WINE ORDER 196456 1867730 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 563.94 WINE ORDER 196457 1867729 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 77.02 CUERVO MIX MARG ORDER 196458 1867728 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 999.19 LIQUOR&SPIRITS ORDER 196459 1867727 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 4,299.57 LIQUOR&SPIRITS ORDER 196460 1867726 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 104.37- WINE ORDER CREDIT 196461 157927 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 344.89 WINE ORDER 196462 1862060 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,127.89 LIQUOR&SPIRITS ORDER 196463 1662059 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 6,733.71 LIQUOR&SPIRITS ORDER 196464 1862722 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 47.50 CUERVO MIX MARG ORDER 196465 1865032 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 98.00 KINKY COCKTAILS ORDER 196466 1862724 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 3,886.21 LIQUOR&SPIRITS ORDER 196467 1862725 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,017.16 WINE ORDER 196468 1862726 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 3,616.24 LIQUOR&SPIRITS ORDER 196469 1867936 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 38.51 CUREVO MIX MARG ORDER 196470 1867935 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 4,320.04 LIQUOR&SPIRITS ORDER 196471 1862926 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,041.86 WINE ORDER 196472 1862929 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 24.50 KINKY COCKTAILS ORDER 196473 1862928 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 4,296.89 LIQUOR&SPIRITS ORDER 196474 1862927 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 2,741.04 LIQUOR&SPIRITS ORDER 196475 1862930 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 2,518.97 WINE ORDER 196476 1862932 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 167.55 LIQUOR MIXES ORDER 196477 1862931 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,792.09 LIQUOR&SPIRITS ORDER 196514 1872795 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 343.16 WINE ORDER 196515 1872793 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 51.20 KINKY COCKTAILS ORDER 196516 1872794 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,183.98 LIQUOR&SPIRITS ORDER 196517 1872792 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 926.20 WINE ORDER 196518 1872791 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 207.52 LIQUOR&SPIRITS ORDER 196519 1872790 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 51,766.59 155817 9/3/2021 102732 KOHLBECK,MISSIE 19.33 FUN FRIDAY 082021 196567 20210820 KOHLBECK1093 6570 PROGRAMMING EXPENSE SENIOR CITIZEN SERVICES 01000 09 19.33 155818 9/3/2021 114625 MASTER MECHANICAL,INC 996.93 HVAC REPAIR 196582 60265 1015 6515 BUILDING REPAIR/MAINTENANCE CITY HALL 01000 01 996.93 155819 9/3/2021 108980 MINNESOTA ENERGY RESOURCES CORPORATION 24.96 AUG'21 GAS DT LIQ STORE 196403 0731950432AUG'21 6110 6423 NATURAL GAS DOWNTOWN LIQUOR REV&EXP 06100 02 24.96 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/13/2021 12:38:09 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 7 8/12/2021 - 9/13/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 155820 9/3/2021 110248 MINNESOTA MUNICIPAL BEVERAGE ASSN 1,850.00 MMBAANNUAL DUES 196398 ANNUAL DUES 2021 6110 6460 MEMBER DUES&LICENSURE DOWNTOWN LIQUOR REV&EXP 06100 02 1,850.00 MMBAANNUAL DUES 196398 ANNUAL DUES 2021 6115 6460 MEMBER DUES&LICENSURE PILOT KNOB LIQUOR 06100 02 3,700.00 155821 9/3/2021 118244 NEUMANN,LACEY 47.08 AUG'21 MEAL REIMB 196566 20210811 NEUMANN 1052 6470 TRAINING&SUBSISTANCE INVESTIGATION SERVICES 01000 05 47.08 155822 9/3/2021 116926 NORTHERN STAR COUNCIL BSA 360.00 21 ADVENTURE CP BOY SCOUTS 196531 FARMINGTON PARKS1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 210826 360.00 155823 9/3/2021 100290 PAUSTIS&SONS WINE COMPANY 276.25 WINE ORDER 196479 136860 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 246.25 WINE ORDER 196480 136082 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 918.25 WINE ORDER 196481 136854 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,442.75 155824 9/3/2021 100093 PELLICCI HARDWARE&RENTAL 31.96 HOSE COUPLER 195781 K45790/F 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 21.25 BATTERIES FOR DRILL 195828 K45811/F 1015 6220 EQUIP SUPPLIES&PARTS CITY HALL 01000 01 21.24 BATTERIES FOR DRILL 195828 K45811/F 1060 6220 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 .58- 195828 K45811/F 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 42.50 BATTERIES FOR DRILL 195828 K45811/1' 1072 6220 EQUIP SUPPLIES&PARTS STREET MAINTENANCE 01000 08 8.50 BATTERIES FOR DRILL 195828 K45811/1' 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 21.25 BATTERIES FOR DRILL 195828 K45811/F 1093 6220 EQUIP SUPPLIES&PARTS SENIOR CITIZEN SERVICES 01000 09 21.25 BATTERIES FOR DRILL 195828 K45811/F 1050 6220 EQUIP SUPPLIES&PARTS POLICE ADMINISTRATION 01000 05 8.50 BATTERIES FOR DRILL 195828 K45811/F 6202 6220 EQUIP SUPPLIES&PARTS SEWER OPERATIONS EXPENSE 06200 08 9.08 BATTERIES FOR DRILL 195828 K45811/F 6302 6220 EQUIP SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 6.50 BATTERIES FOR DRILL 195828 K45811/1' 6402 6220 EQUIP SUPPLIES&PARTS STORM WATER UTILITY OPERA 06400 08 8.50 BATTERIES FOR DRILL 195628 K45811/F 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 65.97 TIE DOWN STRAPS 195830 K45810/F 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 14.97 MASKING TAPE 195859 K45821/F 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 15.98 SAND PAPER 195860 K45859/F 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 45.42 SHRINK WRAP FOR DT STORE 195906 45856/1' 6110 6250 OTHER SUPPLIES&PARTS DOWNTOWN LIQUOR REV&EXP 06100 02 16.06 BATTERY ALKLN RAYO C PK 12 195907 K45860/F 6110 6220 EQUIP SUPPLIES&PARTS DOWNTOWN LIQUOR REV&EXP 06100 02 96.35 CLEANING TOWELS(200 BX)X 6 195907 K45860/F 6110 6242 CLEANING SUPPLIES DOWNTOWN LIQUOR REV&EXP 06100 02 53.54 SHRINK WRAP FOR DT STORE 195908 K45873/F 6110 6250 OTHER SUPPLIES&PARTS DOWNTOWN LIQUOR REV&EXP 06100 02 24.99 EVIDENCE ROOM POWER STRIP 195911 45839/F'21 1052 6220 EQUIP SUPPLIES&PARTS INVESTIGATION SERVICES 01000 05 252.00 WATER FOR BOTH STATIONS 195938 58532/F 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01000 06 13.98 CASCADE SOAP 195954 K45826/F 1072 6242 CLEANING SUPPLIES STREET MAINTENANCE 01000 08 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/13/2021 12:38:09 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 8 8/12/2021 - 9/13/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept Div 16.06 CLEANING TOWELS(200 BX) 195957 K45924/F 6110 6242 CLEANING SUPPLIES DOWNTOWN LIQUOR REV&EXP 06100 02 114.58 SCRPRlWNDW CLNR KIT/SQUGEE/BKT 195958 K45923/F 6110 6950 MACHINERY,EQUIPMENT&TOOLS DOWNTOWN LIQUOR REV&EXP 06100 02 38.30 CLNRS/SWFFR SWEEP/SCOURPDS/BAG 195958 K45923/F 6110 6242 CLEANING SUPPLIES DOWNTOWN LIQUOR REV&EXP 06100 02 9.98 DOUBLE SIDED TAPE FOR TROPHYS 195967 K45858/F 1095 6210 OFFICE SUPPLIES RECREATION PROGRAM SERVIC 01000 09 6.99 9V BATTERY 196070 K45827/F 1070 6220 EQUIP SUPPLIES&PARTS ENGINEERING SERVICES 01000 07 7.99 HOSE NOZZLE 196112 46051/F'21 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 14.99 GLOVES,LEATHER XL 196113 K46090/F 1072 6290 UNIFORMS&CLOTHING STREET MAINTENANCE 01000 08 11.99 K-9 DOG FOOD CONTAINER 196127 K46034/F 2200 6220 EQUIP SUPPLIES&PARTS K-9(EFF.2019) 02200 05 3.99 MASKING TAPE FOR TRAINING 196131 K46088/F 1051 6220 EQUIP SUPPLIES&PARTS PATROL SERVICES 01000 05 55.96 BATTERIES AND SCREWS 196135 45876/F 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 4.36 BATHROOM CLEANER 196136 K63726/F 1015 6242 CLEANING SUPPLIES CITY HALL 01000 01 4.38 BATHROOM CLEANER 196136 K63726/F 1060 6242 CLEANING SUPPLIES FIRE SERVICES 01000 06 .12- 196136 K63726/F 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 8.75 BATHROOM CLEANER 196136 K63726/F 1072 6242 CLEANING SUPPLIES STREET MAINTENANCE 01000 08 1.75 BATHROOM CLEANER 196136 K63726/F 1090 6242 CLEANING SUPPLIES PARK MAINTENANCE 01000 09 4.38 BATHROOM CLEANER 196136 K63726/F 1093 6242 CLEANING SUPPLIES SENIOR CITIZEN SERVICES 01000 09 4.38 BATHROOM CLEANER 196136 K63726/F 1050 6242 CLEANING SUPPLIES POLICE ADMINISTRATION 01000 05 1.75 BATHROOM CLEANER 196136 K63726/F 6202 6242 CLEANING SUPPLIES SEWER OPERATIONS EXPENSE 06200 08 1.87 BATHROOM CLEANER 196136 K63726/F 6302 6242 CLEANING SUPPLIES SOLID WASTE OPERATIONS 06300 08 1.75 BATHROOM CLEANER 196136 K63726/F 6402 6242 CLEANING SUPPLIES STORM WATER UTILITY OPERA 06400 08 1.75 BATHROOM CLEANER 196136 K63726/F 6502 6242 CLEANING SUPPLIES WATER UTILITY EXPENSE 06500 08 6.49- BATHROOM CLEANER&MOP HEAD 196137 K63725/F CR 1015 6242 CLEANING SUPPLIES CITY HALL 01000 01 6.50- BATHROOM CLEANER&MOP HEAD 196137 K63725/F CR 1060 6242 CLEANING SUPPLIES FIRE SERVICES 01000 06 .18 196137 K63725/F CR 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 13.00- BATHROOM CLEANER&MOP HEAD 196137 K63725/F CR 1072 6242 CLEANING SUPPLIES STREET MAINTENANCE 01000 08 2.60- BATHROOM CLEANER&MOP HEAD 196137 K63725/F CR 1090 6242 CLEANING SUPPLIES PARK MAINTENANCE 01000 09 6.50- BATHROOM CLEANER&MOP HEAD 196137 K63725/F CR 1093 6242 CLEANING SUPPLIES SENIOR CITIZEN SERVICES 01000 09 6.50- BATHROOM CLEANER&MOP HEAD 196137 K63725/F CR 1050 6242 CLEANING SUPPLIES POLICE ADMINISTRATION 01000 05 2.60- BATHROOM CLEANER&MOP HEAD 196137 K63725/F CR 6202 6242 CLEANING SUPPLIES SEWER OPERATIONS EXPENSE 06200 08 2.78- BATHROOM CLEANER&MOP HEAD 196137 K63725/F CR 6302 6242 CLEANING SUPPLIES SOLID WASTE OPERATIONS 06300 08 2.60- BATHROOM CLEANER&MOP HEAD 196137 K63725/F CR 6402 6242 CLEANING SUPPLIES STORM WATER UTILITY OPERA 06400 08 2.60- BATHROOM CLEANER&MOP HEAD 196137 K63725/F CR 6502 6242 CLEANING SUPPLIES WATER UTILITY EXPENSE 06500 08 9.49 FLAT WASHERS:BRIDGES 196139 K45912/F 1090 6250 OTHER SUPPLIES&PARTS PARK MAINTENANCE 01000 09 12.97 SISSOR BLADE REPLACEMENT 196141 K45940/F 1015 6220 EQUIP SUPPLIES&PARTS CITY HALL 01000 01 5.98 PAINTING SUPPLIES 196142 K45944/F 1015 6240 BUILDING SUPPLIES&PARTS CITY HALL 01D00 01 3.99 PAINT ROLLERS 196143 45946/1'CR 1015 6240 BUILDING SUPPLIES&PARTS CITY HALL 01000 01 4.99- RTRN:PAINT ROLLERS 196143 45946/F CR 1015 6240 BUILDING SUPPLIES&PARTS CITY HALL 01000 01 22.56 BOWL CLEANER AND DISP GLOVES 196144 K45949/F 1015 6242 CLEANING SUPPLIES CITY HALL 01000 01 22.55 BOWL CLEANER AND DISP GLOVES 196144 K45949/F 1060 6242 CLEANING SUPPLIES FIRE SERVICES 01000 06 .62- 196144 K45949/F 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 45.11 BOWL CLEANERAND DISP GLOVES 196144 K45949/F 1072 6242 CLEANING SUPPLIES STREET MAINTENANCE 01000 08 9.02 BOWL CLEANERAND DISP GLOVES 196144 K45949/F 1090 6242 CLEANING SUPPLIES PARK MAINTENANCE 01000 09 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/13/2021 12:38:09 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 9 8/12/2021 - 9/13/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 22.55 BOWL CLEANER AND DISP GLOVES 196144 K45949/F 1093 6242 CLEANING SUPPLIES SENIOR CITIZEN SERVICES 01000 09 22.55 BOWL CLEANER AND DISP GLOVES 196144 K45949/F 1050 6242 CLEANING SUPPLIES POLICE ADMINISTRATION 01000 05 9.02 BOWL CLEANER AND DISP GLOVES 196144 K45949/F 6202 6242 CLEANING SUPPLIES SEWER OPERATIONS EXPENSE 06200 08 9.64 BOWL CLEANER AND DISP GLOVES 196144 K45949/F 6302 6242 CLEANING SUPPLIES SOLID WASTE OPERATIONS 06300 08 9.02 BOWL CLEANER AND DISP GLOVES 196144 K45949/F 6402 6242 CLEANING SUPPLIES STORM WATER UTILITY OPERA 06400 08 9.02 BOWL CLEANER AND DISP GLOVES 196144 K45949/F 6502 6242 CLEANING SUPPLIES WATER UTILITY EXPENSE 06500 08 .99 HAIR REMOVER 196145 K45946/F 1015 6242 CLEANING SUPPLIES CITY HALL 01000 01 1.00 HAIR REMOVER 196145 K45946/F 1060 6242 CLEANING SUPPLIES FIRE SERVICES 01000 06 .03- 196145 K45946/F 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 2.00 HAIR REMOVER 196145 K45946/F 1072 6242 CLEANING SUPPLIES STREET MAINTENANCE 01000 08 .40 HAIR REMOVER 196145 K45946/F 1090 6242 CLEANING SUPPLIES PARK MAINTENANCE 01000 09 1.00 HAIR REMOVER 196145 K459461F 1093 6242 CLEANING SUPPLIES SENIOR CITIZEN SERVICES 01000 09 1.00 HAIR REMOVER 196145 K45946/F 1050 6242 CLEANING SUPPLIES POLICE ADMINISTRATION 01000 05 .40 HAIR REMOVER 196145 K45946/F 6202 6242 CLEANING SUPPLIES SEWER OPERATIONS EXPENSE 06200 08 .43 HAIR REMOVER 196145 K45946/F 6302 6242 CLEANING SUPPLIES SOLID WASTE OPERATIONS 06300 08 .40 HAIR REMOVER 196145 K45946/F 6402 6242 CLEANING SUPPLIES STORM WATER UTILITY OPERA 06400 08 .40 HAIR REMOVER 196145 K45946/F 6502 6242 CLEANING SUPPLIES WATER UTILITY EXPENSE 06500 08 4.48 CARPET CLEANER 196146 K45984/F 1015 6242 CLEANING SUPPLIES CITY HALL 01000 01 4.50 CARPET CLEANER 196146 K45984/F 1060 6242 CLEANING SUPPLIES FIRE SERVICES 01000 06 .12- 196146 K45984/F 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 8.99 CARPET CLEANER 196146 K45984/F 1072 6242 CLEANING SUPPLIES STREET MAINTENANCE 01000 08 1.80 CARPET CLEANER 196146 K45984/F 1090 6242 CLEANING SUPPLIES PARK MAINTENANCE 01000 09 4.50 CARPET CLEANER 196146 K45984/F 1093 6242 CLEANING SUPPLIES SENIOR CITIZEN SERVICES 01000 09 4.50 CARPET CLEANER 196146 K45984/F 1050 6242 CLEANING SUPPLIES POLICE ADMINISTRATION 01000 05 1.80 CARPET CLEANER 196146 K45984/F 6202 6242 CLEANING SUPPLIES SEWER OPERATIONS EXPENSE 06200 08 1.92 CARPET CLEANER 196146 K45984/F 6302 6242 CLEANING SUPPLIES SOLID WASTE OPERATIONS 06300 08 1.80 CARPET CLEANER 196146 K45984/F 6402 6242 CLEANING SUPPLIES STORM WATER UTILITY OPERA 06400 08 1.80 CARPET CLEANER 196146 K45984/F 6502 6242 CLEANING SUPPLIES WATER UTILITY EXPENSE 06500 08 35.88 TOILET BOWL CLEANER 196147 K45998/F 2502 6242 CLEANING SUPPLIES ICE ARENA OPERATIONS EXPE 02500 09 2.16 8"BENT NOSE PLIERS 196148 K45999/F 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 16.99 8"BENT NOSE PLIERS 196148 K45999/F 1090 6950 MACHINERY,EQUIPMENT&TOOLS PARK MAINTENANCE 01000 09 5.00 WASP KILLER 196148 K45999/F 1090 6260 CHEMICALS PARK MAINTENANCE 01000 09 2.49 PLAYGROUND BOLT 196150 K46022/F 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 31.96 STRIPING PAINT 196151 K46025/F 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 56.25 TRASH BAGS&TOILET PAPER 196168 65099/F 1015 6242 CLEANING SUPPLIES CITY HALL 01000 01 56.26 TRASH BAGS&TOILET PAPER 196168 65099/1' 1060 6242 CLEANING SUPPLIES FIRE SERVICES 01000 06 1.55- 196168 65099/1' 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 112.53 TRASH BAGS&TOILET PAPER 196168 65099/F 1072 6242 CLEANING SUPPLIES STREET MAINTENANCE 01000 08 22.51 TRASH BAGS&TOILET PAPER 196168 65099/1' 1090 6242 CLEANING SUPPLIES PARK MAINTENANCE 01000 09 56.26 TRASH BAGS&TOILET PAPER 196168 65099/F 1093 6242 CLEANING SUPPLIES SENIOR CITIZEN SERVICES 01000 09 56.26 TRASH BAGS&TOILET PAPER 196168 65099/F 1050 6242 CLEANING SUPPLIES POLICE ADMINISTRATION 01000 05 22.51 TRASH BAGS&TOILET PAPER 196168 65099/F 6202 6242 CLEANING SUPPLIES SEWER OPERATIONS EXPENSE 06200 08 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/13/2021 12:38:09 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 10 8/12/2021 - 9/13/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 24.06 TRASH BAGS&TOILET PAPER 196168 65099/1' 6302 6242 CLEANING SUPPLIES SOLID WASTE OPERATIONS 06300 08 22.51 TRASH BAGS&TOILET PAPER 196168 65099/1' 6402 6242 CLEANING SUPPLIES STORM WATER UTILITY OPERA 06400 08 22.51 TRASH BAGS&TOILET PAPER 196168 65099/1' 6502 6242 CLEANING SUPPLIES WATER UTILITY EXPENSE 06500 08 16.24 GRINDER 196170 K46056/F 1015 6950 MACHINERY,EQUIPMENT&TOOLS CITY HALL 01000 01 16.25 GRINDER 196170 K46056/F 1060 6950 MACHINERY,EQUIPMENT&TOOLS FIRE SERVICES 01000 06 .45- 196170 K46056/F 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 32.50 GRINDER 196170 K46056/F 1072 6950 MACHINERY,EQUIPMENT&TOOLS STREET MAINTENANCE 01000 08 6.50 GRINDER 196170 K46056/F 1090 6950 MACHINERY,EQUIPMENT&TOOLS PARK MAINTENANCE 01000 09 16.25 GRINDER 196170 K46056/F 1093 6950 MACHINERY,EQUIPMENT&TOOLS SENIOR CITIZEN SERVICES 01000 09 16.25 GRINDER 196170 K46056/F 2502 6950 MACHINERY,EQUIPMENT&TOOLS ICE ARENA OPERATIONS EXPE 02500 09 6.50 GRINDER 196170 K46056/F 6202 6950 MACHINERY,EQUIPMENT&TOOLS SEWER OPERATIONS EXPENSE 06200 08 6.95 GRINDER 196170 K46056/F 6302 6950 MACHINERY,EQUIPMENT&TOOLS SOLID WASTE OPERATIONS 06300 08 6.50 GRINDER 196170 K46056/F 6402 6950 MACHINERY,EQUIPMENT&TOOLS STORM WATER UTILITY OPERA 06400 08 6.50 GRINDER 196170 K46056/F 6502 6950 MACHINERY,EQUIPMENT&TOOLS WATER UTILITY EXPENSE 06500 08 69.98 TRASH BAGS 196172 K46060/F 2502 6242 CLEANING SUPPLIES ICE ARENA OPERATIONS EXPE 02500 09 9.99 BARACADE TAPE 196173 46011/1''21 1090 6250 OTHER SUPPLIES&PARTS PARK MAINTENANCE 01000 09 69.97 PAPER TOWELS 196174 65096/F'21 1015 6242 CLEANING SUPPLIES CITY HALL 01000 01 69.99 PAPER TOWELS 196174 65096/1'21 1060 6242 CLEANING SUPPLIES FIRE SERVICES 01000 06 1.93- 196174 65096/1'21 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 139.98 PAPER TOWELS 196174 65096/1''21 1072 6242 CLEANING SUPPLIES STREET MAINTENANCE 01000 08 28.00 PAPER TOWELS 196174 65096/1''21 1090 6242 CLEANING SUPPLIES PARK MAINTENANCE 01000 09 69.99 PAPER TOWELS 196174 65096/F'21 1093 6242 CLEANING SUPPLIES SENIOR CITIZEN SERVICES 01000 09 69.99 PAPER TOWELS 196174 65096/F'21 1050 6242 CLEANING SUPPLIES POLICE ADMINISTRATION 01D00 05 28.00 PAPER TOWELS 196174 65096/1''21 6202 6242 CLEANING SUPPLIES SEWER OPERATIONS EXPENSE 06200 08 29.93 PAPER TOWELS 196174 65096/1''21 6302 6242 CLEANING SUPPLIES SOLID WASTE OPERATIONS 06300 08 28.00 PAPER TOWELS 196174 65096/1''21 6402 6242 CLEANING SUPPLIES STORM WATER UTILITY OPERA 06400 08 28.00 PAPER TOWELS 196174 65096/1''21 6502 6242 CLEANING SUPPLIES WATER UTILITY EXPENSE 06500 08 39.99 SPADE DRAIN FIBER 196175 46100/1' 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 24.99 GLOVES,LEATHER XL 196176 K46111/F 1090 6290 UNIFORMS&CLOTHING PARK MAINTENANCE 01000 09 12.97 DRILL BITS 196176 K46111/F 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 21.99 ROTO DIGGER 196177 K46119/F 1090 6950 MACHINERY,EQUIPMENT&TOOLS PARK MAINTENANCE 01000 09 11.99 MAP PRO GAS CYLINDER 196184 K46116/F 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 16.99 1/2"X 60"PIPE 196190 K46120/F 1072 6220 EQUIP SUPPLIES&PARTS STREET MAINTENANCE 01000 08 19.99 GARDEN SPRAYER 2 GAL 196251 45870/1' 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 24.98 MGNTC ANGLE LOC/LEAF FLR GAGE 196256 K45974/F 1090 6950 MACHINERY,EQUIPMENT&TOOLS PARK MAINTENANCE 01000 09 7.99 CAULK FOR CONCRETE PAD 196256 K45974/F 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 14.99 PLANT FOOD 196262 K46220/17 1090 6255 LANDSCAPING MATERIALS PARK MAINTENANCE 01000 09 123.88 PAINT SUPPLIES FOR BRIDGES 196263 K46238/F 1090 6250 OTHER SUPPLIES&PARTS PARK MAINTENANCE 01000 09 1.50 KEY RETRIEVER 196265 K46236/1' 1015 6220 EQUIP SUPPLIES&PARTS CITY HALL 01000 01 1.50 KEY RETRIEVER 196265 K46236/F 1060 6220 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 .04- 196265 K46236/F 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 3.00 KEY RETRIEVER 196265 K46236/F 1072 6220 EQUIP SUPPLIES&PARTS STREET MAINTENANCE 01000 08 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/13/2021 12:38:09 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 11 8/12/2021 - 9/13/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div .59 KEY RETRIEVER 196265 K46236/F 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 1.50 KEY RETRIEVER 196265 K46236/F 1093 6220 EQUIP SUPPLIES&PARTS SENIOR CITIZEN SERVICES 01000 09 1.50 KEY RETRIEVER 196265 K46236/F 1050 6220 EQUIP SUPPLIES&PARTS POLICE ADMINISTRATION 01000 05 .60 KEY RETRIEVER 196265 K46236/F 6202 6220 EQUIP SUPPLIES&PARTS SEWER OPERATIONS EXPENSE 06200 08 .64 KEY RETRIEVER 196265 K46236/F 6302 6220 EQUIP SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 .60 KEY RETRIEVER 196265 K46236/F 6402 6220 EQUIP SUPPLIES&PARTS STORM WATER UTILITY OPERA 06400 08 .60 KEY RETRIEVER 196265 K46236/F 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 4.99 BATTERY FOR THERMOMETER 196266 K46261/F 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 114.96 ALL PRPSE VINEGAR 196289 65014/F 1060 6242 CLEANING SUPPLIES FIRE SERVICES 01000 06 2.49 MENDER HOSE FOR GARDEN HOSE 196290 46132/1' 1060 6220 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 5.99 12V 2PK BATTERIES 196291 K46099/F 1060 6220 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 10.49 LIGHTER/CAKE PAN:DEMO SPPLYS 196292 K46240/F 1060 6250 OTHER SUPPLIES&PARTS FIRE SERVICES D1D00 06 23.94 STEEL WOOL PADS/SCRB SPONGES 196293 K46245/F 1060 6242 CLEANING SUPPLIES FIRE SERVICES 01000 06 4.99 THREADED CLEAN OUT PLUG 196301 K46270/F 6202 6220 EQUIP SUPPLIES&PARTS SEWER OPERATIONS EXPENSE 06200 08 27.96 CABLE TIES 196323 K46279/F 1052 6220 EQUIP SUPPLIES&PARTS INVESTIGATION SERVICES 01000 05 28.83 KEYS&KEY RINGS FOR DT STORE 196397 K46065/F 6110 6240 BUILDING SUPPLIES&PARTS DOWNTOWN LIQUOR REV&EXP 06100 02 96.68 CNTRPULL TWLS/SOAP REFILLS 196404 K46003/F 6115 6242 CLEANING SUPPLIES PILOT KNOB LIQUOR 06100 02 60.79 PLEXI FOR SANDWICH BOARD SIGN 196405 K46185/F 6110 6220 EQUIP SUPPLIES&PARTS DOWNTOWN LIQUOR REV&EXP 06100 02 49.23 RZR BLDS/MOPHDS/TRSH BAGS 196406 K46214/F 6115 6242 CLEANING SUPPLIES PILOT KNOB LIQUOR 06100 02 52.47 LABEL MAKER/LABEL TAPE 196407 K46297/F 6110 6960 FURNITURE,OFFICE EQUIP,IT DOWNTOWN LIQUOR REV&EXP 06100 02 29.37 KEYS NEEDED FOR FIRE DEPT 196529 K46323/F 6110 6240 BUILDING SUPPLIES&PARTS DOWNTOWN LIQUOR REV&EXP 06100 02 21.38 SHELVING:BACK ROOM STORAGE 196544 46362/F 6110 6960 FURNITURE,OFFICE EQUIP,IT DOWNTOWN LIQUOR REV&EXP 06100 02 1.38- 196544 46362/1' 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 3.20 KEY FOR FIRE DEPT 196546 K46336/F 6110 6240 BUILDING SUPPLIES&PARTS DOWNTOWN LIQUOR REV&EXP 06100 02 45.95 BOWL BRUSH/PLUNGER 196573 69748/F 1015 6242 CLEANING SUPPLIES CITY HALL 01000 01 45.95 BOWL BRUSH/PLUNGER 196573 69748/F 1060 6242 CLEANING SUPPLIES FIRE SERVICES 01000 06 1.26- 196573 69748/F 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 91.90 BOWL BRUSH/PLUNGER 196573 69748/F 1072 6242 CLEANING SUPPLIES STREET MAINTENANCE 01000 08 18.37 BOWL BRUSH/PLUNGER 196573 69748/F 1090 6242 CLEANING SUPPLIES PARK MAINTENANCE 01000 09 45.95 BOWL BRUSH/PLUNGER 196573 69748/F 1093 6242 CLEANING SUPPLIES SENIOR CITIZEN SERVICES 01000 09 45.95 BOWL BRUSH/PLUNGER 196573 69748/1' 1050 6242 CLEANING SUPPLIES POLICE ADMINISTRATION 01000 05 18.38 BOWL BRUSH/PLUNGER 196573 69748/F 6202 6242 CLEANING SUPPLIES SEWER OPERATIONS EXPENSE 06200 08 19.64 BOWL BRUSH/PLUNGER 196573 69748/F 6302 6242 CLEANING SUPPLIES SOLID WASTE OPERATIONS 06300 08 18.38 BOWL BRUSH/PLUNGER 196573 69748/F 6402 6242 CLEANING SUPPLIES STORM WATER UTILITY OPERA 06400 08 18.38 BOWL BRUSH/PLUNGER 196573 69748/1' 6502 6242 CLEANING SUPPLIES WATER UTILITY EXPENSE 06500 08 11.96 BOLTS FOR SURROUNDS 196579 K46295/F 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 14.99 SURROUND SCREWS 196581 K46306/F 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 3,895.00 155826 9/3/2021 100032 PEPSI COLA COMPANY 136.70 POP ORDER 196394 48728405 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 136.70 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/13/2021 12:38:09 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 12 8/12/2021 - 9/13/2021 Check# Date Amount Supplier I Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 155826 9/3/2021 100034 PHILLIPS WINE AND SPIRITS,INC 88.35 ZING ZANG BL MARY MIXES ORDER 196482 6251250 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 864.92 WINE ORDER 196483 6251249 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,853.44 LIQUOR&SPIRITS ORDER 196484 6255026 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 6,058.75 LIQUOR&SPIRITS ORDER 196485 6251248 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 73.51 WINE ORDER 196486 6255028 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 218.04 WINE ORDER 196487 6255027 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 34.38- SVEDKA VODKA CREDIT 196488 638393 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 11.27- LIQUOR&SPIRITS ORDER CREDIT 196489 639173 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 14.33- SVEDKA VODKA CREDIT 196490 639174 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 30.99- WINE ORDER CREDIT 196491 639172 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 102.30 ZING ZANG BL MARY MIXES ORDER 196492 6251400 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 4,900.57 LIQUOR&SPIRITS ORDER 196493 6251398 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 796.67 WINE ORDER 196494 6251399 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 193.28 WINE ORDER 196512 6258961 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 593.71 LIQUOR&SPIRITS ORDER 196513 6258960 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 16,652.57 155827 9/3/2021 100196 QUALITY REFRIGERATION INC 742.33 BEER WALK IN COOLER REPAIR 196399 0093168 6110 6505 EQUIPMENT REPAIR/MAINTENANCE DOWNTOWN LIQUOR REV&EXP 06100 02 3,500.99 BEER WALK IN COOLER REPAIR 196400 0093324 6110 6505 EQUIPMENT REPAIR/MAINTENANCE DOWNTOWN LIQUOR REV&EXP 06100 02 4,243.32 155828 9/3/2021 114619 RED BULL DISTRIBUTION COMPANY,INC 85.00 RED BULL ORDER 196593 K-7250274 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 85.00 155829 9/3/2021 112561 RICOH USA,INC 865.08 SEPT'21 COPIER LEASE 196357 105284093 1010 6555 RENTAL OF EQUIPMENT ADMINISTRATION 01000 01 22.03 SEPT'21 COPIER FAX CARD LEASE 196357 105284093 1010 6555 RENTAL OF EQUIPMENT ADMINISTRATION 01000 01 887.11 155830 9/312021 112011 ROSEMOUNT,CITY OF 292.50 SKATE CAMP REGISTRATION 196556 20210809 LAIR 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 SKTBD CAMP 292.50 155831 9/3/2021 107018 SHAMROCK GROUP 126.53 ICE CUBE ORDER 196495 2658222 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 41.62 ICE CUBE ORDER 196496 2660461 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 139.55 ICE CUBE ORDER 196497 2660726 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 148.04 ICE CUBE ORDER 196498 2660463 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 74.86 ICE CUBE ORDER 196499 2663016 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 73.32 ICE CUBE ORDER 196500 2663279 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 7.20- ICE CUBE ORDER CREDIT 196507 2668717 CR 6100 1406 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/13/2021 12:38:09 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection.. Council Check Summary Page- 13 8/12/2021 - 9/13/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 99.36 ICE CUBE ORDER 196592 2667799 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 95.05 ICE CUBE ORDER 196595 2669732-A 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 791.13 155832 9/3/2021 112051 SOUTHERN GLAZER'S OF MN 14.43- WINE ORDER CREDIT 195866 9272035 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 44.65- WINE ORDER CREDIT 195867 9264506 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 36.00- LIQUOR ORDER CREDIT 195868 9273558 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 25.85- WINE ORDER CREDIT 195869 9256772 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 72.00- LIQUOR ORDER CREDIT 195870 9255865 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 39.95- WINE ORDER CREDIT 195871 9251884 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 11.31- WINE ORDER CREDIT 195872 9246712 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 432.00- LIQUOR ORDER CREDIT 195873 9273559 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 25.53- WINE ORDER CREDIT 195874 9272036 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 12.00- WINE ORDER CREDIT 195875 9265401 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 84.60- WINE ORDER CREDIT 195876 9264507 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 96.35- WINE ORDER CREDIT 195877 9256773 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 66.00- LIQUOR ORDER CREDIT 195878 9255866 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 84.60- WINE ORDER CREDIT 195879 9251885 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 289.62 WINE ORDER 196355 2110044 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 4,101.47 LIQUOR&SPIRITS ORDER 196393 2110043 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 7,276.98 LIQUOR&SPIRITS ORDER 196501 2112757 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 5,491.18 LIQUOR&SPIRITS ORDER 196502 2115640 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 7,437.91 LIQUOR&SPIRITS ORDER 196510 2115635 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,175.65 LIQUOR&SPIRITS ORDER 196554 2118139 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 24,727.54 155833 9/3/2021 100379 SPRINT-NEXTEL 28.18 AUG'21 GPS SERVICE 196247 875483313-237 6302 6412 CELLULAR SERVICES SOLID WASTE OPERATIONS 06300 08 1.81- 196247 875483313-237 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 26.37 155834 9/3/2021 116302 TOWN SPORTS,LLC 210.00 SAFETY CAMP SHIRTS 196570 2021 SAFETY CAMP 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 TEES 210.00 155835 9/3/2021 118157 W.L.HALL COMPANY 1,260.00 ELEVATOR REPAIR 196260 9017 1015 6515 BUILDING REPAIR/MAINTENANCE CITY HALL 01000 01 1,260.00 155836 9/3/2021 100334 WINE MERCHANTS 538.57 WINE ORDER 196505 7341612 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,040.09 WINE ORDER 196506 7341654 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 113.51 WINE ORDER 196511 7343565 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/13/2021 12:38:09 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 14 8/12/2021 - 9/13/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 1,692.17 — 155837 9/3/2021 110868 ZEROREZ-MPLS 1,200.00 DUCTCLEANING 196578 530491 1050 6515 BUILDING REPAIR/MAINTENANCE POLICE ADMINISTRATION 01000 05 1,200.00 155838 9/10/2021 114024 APPLE CHEVROLET BUICK-NORTHFIELD 115.88 DOOR LATCH FOR 4784 196690 77564 CVW 1060 6230 VEHICLE SUPPLIES&PARTS FIRE SERVICES 01000 06 115.88 155839 9/10/2021 113303 ARTISAN BEER COMPANY 1,332.35 BEER ORDER 196619 3493590 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,096.30 BEER ORDER 196669 3492283 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,428.65 155840 9/10/2021 108446 ASPEN MILLS,INC. 334.75 UNIFORM ITEMS:GARVER,B. 196282 278946 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 339.70 UNIFORM ITEMS:KARSTEN,S. 196283 278948 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 339.70 UNIFORM ITEMS:BEAUNE,T. 196284 278999 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 334.74 UNIFORM ITEMS:REED,N. 196285 278985 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 240.75 UNIFORM ITEMS:JACOBSON,T. 196286 279001 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 185.94 UNIFORM ITEMS:CHRISTENSEN,A 196287 279002 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 234.75 UNIFORM ITEMS:GREEN,J 196288 278943 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 2,010.33 155841 9/10/2021 114472 BREAKTHRU BEVERAGE MN BEER,LLC 10,508.45 BEER ORDER 196631 340761485 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 13.08- BEER ORDER CREDIT 196632 408699471 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2.20- MIKES HARD LEMONADE CREDIT 196633 408699472 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 16.50- BEER ORDER CREDIT 196634 408740506 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 8.81- BEER ORDER CREDIT 196635 408754858 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2.18- BEER ORDER CREDIT 196636 408754856 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1.98- BEER ORDER CREDIT 196637 408754859 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 4.95- BEER ORDER CREDIT 196638 408754855 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 48.58- BEER ORDER CREDIT 196639 408786429 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 58.42- BEER ORDER CREDIT 196640 408818751 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 6.78- BEER ORDER CREDIT 196641 408818750 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 14.40- BEER ORDER CREDIT 196642 408847204 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 55.40 BEER ORDER 196644 340761486 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 10,385.97 155842 9/10/2021 114471 BREAKTHRU BEVERAGE MN WINE&SPIRITS 255.20 LIQUOR&SPIRITS ORDER 196643 340774445 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 105.57 WINE ORDER 196645 340774447 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,553.31 LIQUOR&SPIRITS ORDER 196646 340774446 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/13/2021 12:38:09 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 15 8/12/2021 - 9/13/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 126.20- LIQUOR&SPIRITS ORDER 196647 408902127 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 10.62- LIQUOR&SPIRITS ORDER CREDIT 196648 408938657 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 5.82- LIQUOR&SPIRITS ORDER CREDTI 196649 408938656 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,771.44 155843 9/10/2021 108360 CANNON RIVER WINERY 312.00 WINE ORDER 196666 12115 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 312.00 155844 9/10/2021 100578 GEMSTONE CONCRETE MATERIALS,LLC 594.00 CONCRETE FOR SURROUNDS 196584 C2400107 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 594.00 155845 9/10/2021 118044 CHARTER COMMUNICATIONS OPERATING,LLC 50.00 CHARTER SUBPOENA 21000285 196694 21-155214 1052 6401 PROFESSIONAL SERVICES INVESTIGATION SERVICES 01000 05 50.00 155846 9/10/2021 113067 CLEAR STREAM RECYCLING 285.00 CLEAR STREAM CONTAINERS 196308 8066 6302 6950 MACHINERY,EQUIPMENT&TOOLS SOLID WASTE OPERATIONS 06300 08 285.00 155847 9/10/2021 100456 COMMERCIAL ASPHALT COMPANY 1,177.86 ASPHALT 196192 210815 1072 6253 STREET MATERIALS STREET MAINTENANCE 01000 08 1,177.86 155848 9/10/2021 100030 CORE&MAIN,LP 274.12 CURB STOP REPAIR LIDS 196299 P411461 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 249.20 CURB STOP REPAIR LIDS 196319 P411479 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 1,520.00 DRIVE WAY CASTINGS 196526 P442524 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 77.56 CURB BOX/ROD 196527 P429670 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 2,120.88 155849 9/10/2021 100057 DICK'S SANITATION SERVICE 14,014.18 AUG'21 RECYCLING COMMERCIAL 196677 DT0004166447 6302 6560 CONTRACTUAL SERVICES SOLID WASTE OPERATIONS 06300 08 1,053.75 AUG-21 RECYCLING SCHOOLS 196678 DT0004144575 6302 6560 CONTRACTUAL SERVICES SOLID WASTE OPERATIONS 06300 08 46,877.88 AUG-21 RECYCLING RESIDENTIAL 196679 DT0004166448 6302 6560 CONTRACTUAL SERVICES SOLID WASTE OPERATIONS 06300 08 7,680.00 AUG-21 WASTE HAULING FEES 196680 DT0004175366 6302 6560 CONTRACTUAL SERVICES SOLID WASTE OPERATIONS 06300 08 69,625.81 155850 9/10/2021 109931 FACTORY MOTOR PARTS 11.14 STOCK FILTERS 196194 1-7092247 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 3.18 STOCK FILTERS 196196 54-313757 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 3.18 STOCK FILTERS 196197 158-055972 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 17.50 165851 9/10/2021 100027 GREAT LAKES COCA-COLA DISTRIBUTION,LLC 432.73 POP ORDER 196625 3573200040 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/13/2021 12:38:09 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 16 8/12/2021 - 9/13/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept Div 432.73 155852 9/10/2021 100074 HOHENSTEINS INC 485.20 BEER ORDER 196623 437019 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 781.80 BEER ORDER 196624 439103 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,267.00 155853 9/10/2021 113417 INDEED BREWING COMPANY,LLC 231.55 BEER ORDER 196668 104602 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 231.55 155854 9/10/2021 111773 INNOVATIVE OFFICE SOLUTIONS,LLC 9.60 POST IT FLAGS 196125 IN3450679 1010 6210 OFFICE SUPPLIES ADMINISTRATION 01000 01 291.85 CHAIR/RLR/LTR OPNR/STPLR/DISP 196125 IN3450679 1010 6960 FURNITURE,OFFICE EQUIP,IT ADMINISTRATION 01000 01 2.04 SCISSORS 196126 IN3451136 1010 6960 FURNITURE,OFFICE EQUIP,IT ADMINISTRATION 01000 01 8.00 FILE FOLDERS 196126 IN3451136 1010 6210 OFFICE SUPPLIES ADMINISTRATION 01000 01 311.49 155855 9/10/2021 110525 IN-SITU INC 50.00 SEPT'21 CELL SVS:WTR LVS SFTW 196704 5635 6502 6412 CELLULAR SERVICES WATER UTILITY EXPENSE 06500 08 50.00 155856 9/10/2021 109846 JJ TAYLOR DISTRIBUTING COMPANY OF MN INC 3,858.60 BEER ORDER 196618 3224019 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 5,350.85 BEER ORDER 196626 3209778 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 8,194.14 BEER ORDER 196627 3224016 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 17,403.59 155857 9/10/2021 100033 JOHNSON BROTHERS LIQUOR COMPANY 1,089.57 LIQUOR&SPIRITS ORDER 196653 1872610 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 463.23 WINE ORDER 196654 1872609 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 691.08 CUERVO RTD GOLD MARG ORDER 196655 1872608 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 521.19 LIQUOR&SPIRITS ORDER 196656 1872607 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 812.77 WINE ORDER 196657 1872606 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 32.66- LIQUOR&SPIRITS ORDER CREDIT 196660 159553 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 3,545.18 155858 9/10/2021 107427 KROMER CO 215.14 SOLENOID-VALVE FOR KROMER 196602 580417 1090 6505 EQUIPMENT REPAIR/MAINTENANCE PARK MAINTENANCE 01000 09 215.14 155859 9/10/2021 106011 KROOG,RACHAEL 1,200.00 POLLUTION PREVENTION DAY 196676 20210910 6302 6570 PROGRAMMING EXPENSE SOLID WASTE OPERATIONS 06300 08 -POLLUTION PREV 1,200.00 166860 9/10/2021 100086 KWIK TRIP,INC R55CKS2 LOGIS600V CITY OF FARMINGTON 9/13/2021 12:38:09 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 17 8/12/2021 - 9/13/2021 . Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 100.00 10 YR EE REC MCKNIGHT 196597 10 YR EE REC 1011 7420 OTHER HUMAN RESOURCES 01000 04 MCKNIGHT 100.00 155861 9/10/2021 100155 METROPOLITAN COUNCIL ENVIRO SERVICES 34,790.00 AUG-21 MCES SAC FEES 196728 AUG'21 SAC FEES 6200 2425 MCES SAC(SWR AVAIL CHG) SEWER OPERATIONS 06200 08 347.90- AUG'21 MCES SAC FEES 196728 AUG'21 SAC FEES 6201 5030 SAC CHARGE RETAINER SEWER OPERATIONS REVENUE 06200 08 34,442.10 155862 9/10/2021 113415 MILLNER HERITAGE VINEYARD&WINERY 105.00 WINE ORDER 196667 3687 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 105.00 155863 9/10/2021 100153 MINNESOTA STATE FIRE CHIEFS ASSOCIATION 300.00 FIRE CHIEF CONF REG:SCHMITZ, 196711 2752 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01000 06 300.00 FIRE CHIEF CONF REG:ELVESTAD 196714 2788 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01000 06 600.00 155864 9/10/2021 102249 MN FIRE SERVICE CERTIFICATION BOARD 25.00 FIRE CERT TESTING FEE 196713 9315 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01000 06 25.00 155865 9/10/2021 102936 NORTHERN DOOR COMPANY 306.28 CMF DOOR REPAIR 196610 69355 1072 6515 BUILDING REPAIR/MAINTENANCE STREET MAINTENANCE 01000 08 306.27 CMF DOOR REPAIR 196610 69355 1090 6515 BUILDING REPAIR/MAINTENANCE PARK MAINTENANCE 01000 09 21.06- 196610 69355 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 306.28 CMF DOOR REPAIR 196610 69355 6202 6515 BUILDING REPAIR/MAINTENANCE SEWER OPERATIONS EXPENSE 06200 08 327.34 CMF DOOR REPAIR 196610 69355 6302 6515 BUILDING REPAIR/MAINTENANCE SOLID WASTE OPERATIONS 06300 08 306.28 CMF DOOR REPAIR 196610 69355 6402 6515 BUILDING REPAIR/MAINTENANCE STORM WATER UTILITY OPERA 06400 08 302.61 CMF DOOR REPAIR 196610 69355 6502 6515 BUILDING REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 1,834.00 155866 9/10/2021 101254 ORKIN EXTERMINATING,LLC 109.00 AUG'21 PEST CONTROL CITY HALL 196261 214282931 1015 6515 BUILDING REPAIR/MAINTENANCE CITY HALL 01000 01 13.36 AUG'21 PEST CONTROL-1ST ST G 196264 217836667 1072 6515 BUILDING REPAIR/MAINTENANCE STREET MAINTENANCE 01000 08 13.36 AUG'21 PEST CONTROL-1ST ST G 196264 217836667 1090 6515 BUILDING REPAIR/MAINTENANCE PARK MAINTENANCE 01000 09 .92- 196264 217836667 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 13.36 AUG'21 PEST CONTROL-1ST ST G 196264 217836667 6202 6515 BUILDING REPAIR/MAINTENANCE SEWER OPERATIONS EXPENSE 06200 08 14.28 AUG'21 PEST CONTROL-IST ST G 196264 217836667 6302 6515 BUILDING REPAIR/MAINTENANCE SOLID WASTE OPERATIONS 06300 08 13.36 AUG'21 PEST CONTROL-1ST ST G 196264 217836667 6402 6515 BUILDING REPAIR/MAINTENANCE STORM WATER UTILITY OPERA 06400 08 13.20 AUG'21 PEST CONTROL-1ST ST G 196264 217836667 6502 6515 BUILDING REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 20.80 AUG'21 PEST CONTROL CMF 196572 214282532 6502 6515 BUILDING REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 21.04 AUG'21 PEST CONTROL CMF 196572 214282532 6402 6515 BUILDING REPAIR/MAINTENANCE STORM WATER UTILITY OPERA 06400 08 1.45- 196572 214282532 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 22.49 AUG'21 PEST CONTROL CMF 196572 214282532 6302 6515 BUILDING REPAIR/MAINTENANCE SOLID WASTE OPERATIONS 06300 08 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/13/2021 12:38:09 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 18 8/12/2021 - 9/13/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 21.04 AUG'21 PEST CONTROL CMF 196572 214282532 6202 6515 BUILDING REPAIR/MAINTENANCE SEWER OPERATIONS EXPENSE 06200 08 21.04 AUG'21 PESTCONTROL CMF 196572 214282532 1090 6515 BUILDING REPAIR/MAINTENANCE PARK MAINTENANCE 01000 09 21.04 AUG'21 PEST CONTROL CMF 196572 214282532 1072 6515 BUILDING REPAIR/MAINTENANCE STREET MAINTENANCE 01000 08 315.00 155867 9/10/2021 100290 PAUSTIS&SONS WINE COMPANY 485.75 WINE ORDER 196662 137540 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 485.75 155868 9/10/2021 100557 PEARSON BROTHERS INC 4,720.00 TRAIL MAINT.-FOG SEAL 196705 5414 5721 6560 CONTRACTUAL SERVICES TRAIL MAINTENANCE 05700 4,720.00 155869 9/10/2021 100093 PELLICCI HARDWARE&RENTAL 4.99 MOUSE TRAPS 196601 K46333/F 1093 6220 EQUIP SUPPLIES&PARTS SENIOR CITIZEN SERVICES 01000 09 11.99 SPRAY NOZZLE 196603 K46355/F 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 10.76 MOUSE TRAPS 196608 K46393/F 1093 6240 BUILDING SUPPLIES&PARTS SENIOR CITIZEN SERVICES 01000 09 59.95 EAST FARM ROOF SUPPLIES 196609 46378/1' 1090 6240 BUILDING SUPPLIES&PARTS PARK MAINTENANCE 01000 09 17.99 ROOF REPLACEMENT PROJECT 196611 K46384/F 1090 6240 BUILDING SUPPLIES&PARTS PARK MAINTENANCE 01000 09 19.98 KNEE PADS 196612 K46379/F 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 24.99 WEED KILLER FOR BOTH STATIONS 196709 K46370/F 1060 6255 LANDSCAPING MATERIALS FIRE SERVICES 01000 06 150.65 155870 9/10/2021 100034 PHILLIPS WINE AND SPIRITS,INC 221.04 WINE ORDER 196658 6258800 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 688.17 LIQUOR&SPIRITS ORDER 196659 6258799 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 909.21 155871 9/10/2021 100416 RECYCLING ASSOCIATION OF MINNESOTA 300.00 RECYCLNG ASSOC MN MEMBER DUES 196124 511098 6302 6460 MEMBER DUES&LICENSURE SOLID WASTE OPERATIONS 06300 08 300.00 155872 9/10/2021 112632 RICOH USA,INC 12.97 AUG'21 COPIER MAINTENANCE 196616 5062664833 1010 6505 EQUIPMENT REPAIR/MAINTENANCE ADMINISTRATION 01000 01 12.97 155873 9/10/2021 100151 SAUBER PLUMBING&HEATING COMPANY 1,560.00 CURB STOP REPAIRS 196688 23428 6502 6505 EQUIPMENT REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 1,560.00 155874 9/10/2021 107018 SHAMROCK GROUP 110.12 ICE CUBE ORDER 196620 2663014 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 77.85 ICE CUBE ORDER 196621 2663275 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 187.97 155875 9/10/2021 112051 SOUTHERN GLAZER'S OF MN 4,883.67 LIQUOR&SPIRITS ORDER 196630 2118143 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/13/2021 12:38:09 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 19 8/12/2021 - 9/13/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 40.00- WINE ORDER CREDIT 196650 9282493 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 305.75- LIQUOR&SPIRITS ORDER 196651 9285057 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1.28- DELIVERY CHARGE CREDIT 196652 9285065 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 4,536.64 155876 9/10/2021 112307 T-MOBILE USA INC 6.66 AUG'21 GPS SERVICE 196559 823329497 AUG'21 6502 6412 CELLULAR SERVICES WATER UTILITY EXPENSE 06500 08 6.67 AUG'21 GPS SERVICE 196559 823329497 AUG'21 6202 6412 CELLULAR SERVICES SEWER OPERATIONS EXPENSE 06200 08 6.66 AUG'21 GPS SERVICE 196559 823329497 AUG'21 6402 6412 CELLULAR SERVICES STORM WATER UTILITY OPERA 06400 08 19.99 20210816 8/23/2021 100085 DAKOTA ELECTRIC ASSOCIATION 206.46 JUL'21 ELEC DNMRK/SPRCE ST LTS 195692 200004222477 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 JUL'21 19.46 JUL'21 ELEC SPRUCE ST MNMNT LT 195693 200004099123 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 JUL'21 20.28 JUL'21 ELEC 220TH ST LIFT STN 195694 200001405224 6202 6422 ELECTRIC SEWER OPERATIONS EXPENSE 06200 08 JUL'21 3,326.19 JUL-21 ELEC WELL#9 195697 200010026004 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 JUL'21 16.78 JUL'21 PK CITY SIGN NORTH ENTR 195763 200010011266 1090 6422 ELECTRIC PARK MAINTENANCE 01000 09 JUL'21 34.17 JUL'21 ELEC PARK&REC SIGN 195764 200002260479 1090 6422 ELECTRIC PARK MAINTENANCE 01000 09 JUL'21 266.45 JUL'21 ELEC FIRE STATION 1 195934 200001679489 1060 6422 ELECTRIC FIRE SERVICES 01000 06 JUL'21 3,891.79 20210817 8/23/2021 100394 XCEL ENERGY 21.65 JUL'21 ELEC-DUNBRY AVE WRM HSE 195745 51-9027188 JUL'21 1090 6422 ELECTRIC PARK MAINTENANCE 01000 09 21.65 20210818 8/23/2021 100135 PUBLIC EMPLOYEES RETIREMENT ASSN. 25,857.96 196340 082621913171 7000 2113 PERA PAYABLE EMPLOYEE EXPENSE FUND 07000 02 34,492.39 196341 082621913172 7000 6154 PERA EMPLOYEE EXPENSE FUND 07000 02 60,350.35 20210819 8/27/2021 117261 USPS POSTALONE 83.33 AUG 21 RIVER POSTAGE 196530 RRC NEWSLETTER 1014 6445 POSTAGE/SHIPPING FEES COMMUNICATIONS 01000 01 20210826 83.33 20210820 6/31/2021 100394 XCEL ENERGY 7.99 JUL'21 ELEC CIV DEF SIREN 195951 51-4874006 JUL'21 1054 6422 ELECTRIC EMERGENCY MGMT SERVICES 01000 05 7.99 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/13/2021 12:38:09 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 20 8/12/2021 - 9/13/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 20210821 8/20/2021 116564 FP MAILING SOLUTIONS/POSTALIA 500.00 08/18/2021 POSTAGE METER RESET 196697 61858118 20210818 1014 6445 POSTAGE/SHIPPING FEES COMMUNICATIONS 01000 01 500.00 20210822 8/30/2021 102160 CARDMEMBER SERVICES 123.05 ANNAUL MUSIC COPYRIGHT LICENSE 195840 6607-6744-7/22 2502 6280 BOOKS&SUBSCRIPTIONS ICE ARENA OPERATIONS EXPE 02500 09 123.06 ANNAUL MUSIC COPYRIGHT LICENSE 195840 6607-6744-7/22 1093 6280 BOOKS&SUBSCRIPTIONS SENIOR CITIZEN SERVICES 01000 09 123.06 ANNAUL MUSIC COPYRIGHT LICENSE 195840 6607-6744-7/22 1095 6280 BOOKS&SUBSCRIPTIONS RECREATION PROGRAM SERVIC 01000 09 680.00 2021 FALL EDAM CONF:DIMAGGIO 195841 3082-6952-7/15 2000 6470 TRAINING&SUBSISTANCE HRA/ECONOMIC DEVELOPMENT 02000 03 75.00 MAWB CONFERENCE:DIMAGGIO,S 195842 3082-3804-7/23 2000 6470 TRAINING&SUBSISTANCE HRA/ECONOMIC DEVELOPMENT 02000 03 80.00 BUSINESS JOURNAL SUSCRIPTION 195643 3082-3986-7/20 2D00 6280 BOOKS&SUBSCRIPTIONS HRA/ECONOMIC DEVELOPMENT 02000 03 30.00 EDAM SUMMER NETWRK EVNT:SWIFT 195844 3082-4567-7/9 2000 647D TRAINING&SUBSISTANCE HRA/ECONOMIC DEVELOPMENT 02000 03 30.00 EDAM SMMR NTWRK EVNT:DIMAGGIO 195845 3082-4853-7/9 2000 6470 TRAINING&SUBSISTANCE HRA/ECONOMIC DEVELOPMENT 02000 03 114.78 PALLET JACK RNTL 7/5-7/11/21 195861 6913-9148-7/12 6110 6555 RENTAL OF EQUIPMENT DOWNTOWN LIQUOR REV&EXP 06100 02 857.91 CONFERENCE LODGING 195971 5212-3579-7/30 2000 647D 20 TRAINING&SUBSISTANCE-DBB HRA/ECONOMIC DEVELOPMENT 02000 03 12.98 AUG'21 WEBHOSTING SVS 195972 5212-6264-7/27 2000 6505 20 EQUIPMENT REPAIR/MAINT-DBB HRA/ECONOMIC DEVELOPMENT 02000 03 25.70 PEN HOLDER FOR REG1CARD READER 195973 0915-8056-8/2 6110 7020 OTHER CONSTRUCTION COSTS DOWNTOWN LIQUOR REV&EXP 06100 02 1,422.04 JUL21 VERIZON DATA SERVICE 195974 6913-6794-7/19 7400 6412 CELLULAR SERVICES INFORMATION TECHNOLOGY 07400 04 41.50 JUL'21 CELL PHONE SERVICE 195974 6913-6794-7/19 2000 6412 20 CELLULAR SERVICES-DBB HRA/ECONOMIC DEVELOPMENT 02000 03 3,151.37 JUL'21 CELL PHONE SERVICE 195974 6913-6794-7/19 7400 6412 CELLULAR SERVICES INFORMATION TECHNOLOGY 07400 04 58.91 AUG'21 ZOOM SUB 195975 0915-0464-8/2 7400 6505 EQUIPMENT REPAIR/MAINTENANCE INFORMATION TECHNOLOGY 07400 04 117.82 MICROWAVE FOR DT LIQ 195976 6913-7464-7/28 6110 6960 FURNITURE,OFFICE EQUIP,IT DOWNTOWN LIQUOR REV&EXP 06100 02 848.42 NEW LIQ REFRIDGERATOR 195977 6913-1754-7/27 6110 6960 FURNITURE,OFFICE EQUIP,IT DOWNTOWN LIQUOR REV&EXP 06100 02 426.20 HOTEL LADDER TRAINING FISCHER 195978 6133-4831-7/16 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01000 06 426.20 HOTEL LADDER TRAINING HOPPE 195979 6133-8379-7/16 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01000 06 102.20 PART FOR MOWER 0008 195980 2145-8458-7/14 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 60.00 CAKE GRADUATION 195981 6133-6002-7/29 1060 6480 MEETING EXPENSE FIRE SERVICES 01000 06 70.00 CAKE LADDER CEREMONY 195982 6133-5669-7/22 1060 6480 MEETING EXPENSE FIRE SERVICES 01000 06 26.36 ICE CREAM FOR GRADUATION 195983 6133-3558-7/23 1060 6480 MEETING EXPENSE FIRE SERVICES 01000 06 20.22 FOOD FOR LADDER TRAINING 195984 8801-6921-7/14 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01000 06 34.81 FOOD FOR LADDER TRAINING 195985 8601-1691-7/13 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01000 06 32.22 FOOD FOR LADDER TRAINING 195986 8801-6082-7/15 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01000 06 34.67 FOOD FOR LADDER TRAINING 195987 8801-0841-7/15 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01000 06 37.93 FOOD FOR LADDER TRAINING 195988 8801-2502-7/16 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01000 06 10.98 SOAP/BKNG SODA:POPCRN MCH CLN 195989 3544-8169-8/2 1095 6242 CLEANING SUPPLIES RECREATION PROGRAM SERVIC 01000 09 21.08 PARTY PARK 2 195990 3544-3040-7/30 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 40.00 PARTY PARK 1 195991 3544-0965-7/29 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 2.00 MSRNG CPS/SPRAY BTTLE;PUP WGN 195992 3544-7512-8/2 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 7.00 PARTY PARK 2 195993 3544-0850-8/2 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 9.95 PARTY PARK 2 195994 3544-1915-8/2 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 8.98 DBL SIDED TAPE 195995 3544-3755-7/29 1095 6210 OFFICE SUPPLIES RECREATION PROGRAM SERVIC 01000 09 55.48 DVDS/MARKERS 195996 3544-1725-7/27 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 49.90 JUL'21 ZUMBA GOLD INST MBRSHP 195997 3544-7107-7/23 1093 6460 MEMBER DUES&LICENSURE SENIOR CITIZEN SERVICES 01000 09 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/13/2021 12:38:09 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 21 8/12/2021 - 9/13/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept Div 22.00 STORYTIME SUPPLIES 195998 3544-5209-7/21 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 19.99 MICROPHONE:PUPPET WAGON 195999 3544-9264-7/19 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 15.51 LITTLE CAMP SUPPLIES 196000 3544-0393-7/15 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 14.97 SPRAY PAINT 196001 3544-1144-7/27 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 19.95 JUL'21 EPRMT PAYPAL FEES 196002 6913-9175-8/4 1031 6545 PYMT PROCESSING FEES BUILDING INSPECTIONS 01000 07 49.95 NEW LIQ 50OFT SPEAKER WIRE 196003 0915-1089-7/8 6110 7020 OTHER CONSTRUCTION COSTS DOWNTOWN LIQUOR REV&EXP 06100 02 42.99 NEW LIQ DOORBELL BCKDR AND REG 196004 0915-2239-8/5 6110 7020 OTHER CONSTRUCTION COSTS DOWNTOWN LIQUOR REV&EXP 06100 02 799.95 5 27"MONITORS-IT SUPPLY 196005 0915-2393-7/9 7400 6960 FURNITURE,OFFICE EQUIP,IT INFORMATION TECHNOLOGY 07400 04 4.99 NEW LIQ CABLE TIES 196006 0915-9668-7/12 6110 7020 OTHER CONSTRUCTION COSTS DOWNTOWN LIQUOR REV&EXP 06100 02 67.02 30-3FT ETHERNET CBLES SVR RM 196006 0915-9668-7/12 6110 7020 OTHER CONSTRUCTION COSTS DOWNTOWN LIQUOR REV&EXP 06100 02 69.84 30-3FT ETHERNET CBLES SVR RM 196006 0915-9668-7/12 6110 7020 OTHER CONSTRUCTION COSTS DOWNTOWN LIQUOR REV&EXP 06100 02 39.95 KERRY BUSYLIGHT 196007 0915-2245-7/12 7400 6220 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 14.99 1 SAMSUNG PHONE CASE 196008 6913-0208-7/13 7400 6220 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 155.82 6(PHONE 12 CASE 196008 6913-0208-7/13 7400 6220 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 780.00 60]PHONE 11 CASE 196008 6913-0208-7/13 7400 6220 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 176.85 5 IPHONE 11 OTTERBOX CASE 196008 6913-0208-7/13 7400 6220 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 33.78 3 IPHONE 12 SCREEN PROTECTR 196009 0915-5215-7/13 7400 6220 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 259.80 20 IPHONE 11 SCREEN PROTECTOR 196010 6913-0145-7/14 7400 6220 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 35.50 1]PHONE 11 OTTERBOX CASE 196011 0915-3250-7/15 7400 6220 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 38.97 3 IPHONE 11 SCREEN PROTECTR 196012 0915-5683-7/19 7400 6220 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 16.99 1 SAMSUNG PHONE SCRN PROT 196013 0915-2780-7/21 7400 6220 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 16.47 APPLE USB-C PWR BRICK-JMURPH 196014 6913-6436-7/22 7400 6220 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 14.49 USB HUB-FIRE 1 TV TRAININGRM 196014 6913-6436-7/22 1060 6220 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 5.98 HDMI CABLE EXTNDR-FIRE1 196014 6913-6436-7/22 1060 6220 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 619.99 CCHAMBER PODIUM PC 196015 6913-3531-7/22 4005 6960 FURNITURE,OFFICE EQUIP,IT CABLE/COMMUNICATIONS PROJ 04000 01 17.99 NEW LIQ EXT CORD MNTED TV 196016 0915-6688-7/28 6110 6220 EQUIP SUPPLIES&PARTS DOWNTOWN LIQUOR REV&EXP 06100 02 59.97 3 HEADSETS FOR PC 196017 0915-2223-7/28 1021 6220 EQUIP SUPPLIES&PARTS GENERAL ACCOUNTING 01000 02 67.90 2 MNTR STANDS REGISTERS 196018 0915-0865-8/2 6110 6220 EQUIP SUPPLIES&PARTS DOWNTOWN LIQUOR REV&EXP 06100 02 116.97 3 UPS BATTERIES-POS AND SVR 196019 0915-6328-8/2 6110 6220 EQUIP SUPPLIES&PARTS DOWNTOWN LIQUOR REV&EXP 06100 02 135.00 TUKUA FORENSIC SCIENCE CONE 196020 4021-0117-8/2 1052 6470 TRAINING&SUBSISTANCE INVESTIGATION SERVICES 01000 05 602.00 EVIDENCE FREEZER 196021 4021-8272-7/19 1052 6950 MACHINERY,EQUIPMENT&TOOLS INVESTIGATION SERVICES 01000 05 125.00 VAN DORN WARRANT PREP TRNG 196022 4021-8661-7/19 1051 6470 TRAINING&SUBSISTANCE PATROL SERVICES 01000 05 125.00 HAGFORS WARRANT PREP TRNG 196023 4021-1561-8/2 1051 6470 TRAINING&SUBSISTANCE PATROL SERVICES 01000 05 92.00 JUL'21 TLO SUBSCRIPTION 196024 4021-9215-8/3 1052 6401 PROFESSIONAL SERVICES INVESTIGATION SERVICES 01000 05 32.39- CAR PHONE HOLDER RETURN 196025 4021-5333-8/2 1050 6220 EQUIP SUPPLIES&PARTS POLICE ADMINISTRATION 01000 05 32.39 CAR PHONE HOLDER 196026 4021-2718-7/23 1050 6220 EQUIP SUPPLIES&PARTS POLICE ADMINISTRATION 01000 05 34.98 CAR PHONE HOLDER 196027 4021-0636-7/30 1050 6220 EQUIP SUPPLIES&PARTS POLICE ADMINISTRATION 01000 05 225.99 OUTDOOR POPUP CANOPY TENT 196028 4021-6495-7/30 1051 6950 MACHINERY,EQUIPMENT&TOOLS PATROL SERVICES 01000 05 13.85 SQUAD ROOM COMPUTER CABLES 196029 4021-2643-7/29 1050 6220 EQUIP SUPPLIES&PARTS POLICE ADMINISTRATION 01000 05 899.85 DEHUMIDIFIERS(5) 196030 4021-9268-7/28 6502 6950 MACHINERY,EQUIPMENT&TOOLS WATER UTILITY EXPENSE 06500 08 24.95 SQD ROOM COMP MONITOR BRKT 196031 4021-2365-7/26 1050 6220 EQUIP SUPPLIES&PARTS POLICE ADMINISTRATION 01000 05 22.94 IPAD CASE AND SCRN PROT 196032 4021-9153-7/22 1052 6220 EQUIP SUPPLIES&PARTS INVESTIGATION SERVICES 01000 05 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/13/2021 12:38:09 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 22 8/12/2021 - 9/13/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 20.95 FIREARMS CANOPY SAND BAGS 196033 4021-8820-7/20 1051 6220 EQUIP SUPPLIES&PARTS PATROL SERVICES 01000 05 31.24 CERTIFICATE HOLDERS 196034 4021-9759-7/19 1060 6220 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 99.99 TRAILER REPL FENDERS 196035 4021-6927-7/19 1051 6220 EQUIP SUPPLIES&PARTS PATROL SERVICES 01000 05 1B.99 BLANK CERTIFICATES 196036 4021-3215-7/19 1060 6210 OFFICE SUPPLIES FIRE SERVICES 01000 06 79.43 CARBOURATOR REPAIR KIT 196037 4021-6576-7/15 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 11.99 DOG WASTE BAGS 196038 4021-6572-7/12 2200 6220 EQUIP SUPPLIES&PARTS K-9(EFF.2019) 02200 05 699.00 AIR CONDITIONER 196039 4021-6017-7/12 6502 6950 MACHINERY,EQUIPMENT&TOOLS WATER UTILITY EXPENSE 06500 08 500.00 REDMOND LEADERSHIP TRAINING 196040 4021-4598-7/8 1051 6470 TRAINING&SUBSISTANCE PATROL SERVICES 01000 05 259.00 REUBEN STREET SURVIVAL SEM 196041 4021-0012-7/9 1051 6470 TRAINING&SUBSISTANCE PATROL SERVICES 01000 05 299.00 HAGFORS: STREET COP TRNG 196042 4021-0679-8/2 1051 6470 TRAINING&SUBSISTANCE PATROL SERVICES 01000 05 114.78 PALLET JACK RNTL 7/12-7/18/21 196043 6913-2148-7/15 6110 6555 RENTAL OF EQUIPMENT DOWNTOWN LIQUOR REV&EXP 06100 02 114.78 PALLET JACK RNTL 7/20-7/26/21 196046 69134375-7/27 6110 6555 RENTAL OF EQUIPMENT DOWNTOWN LIQUOR REV&EXP 06100 02 114.79 PALLET JACK RNTL 7/13-7/19/21 196047 6913-6430-7/20 6110 6555 RENTAL OF EQUIPMENT DOWNTOWN LIQUOR REV&EXP 06100 02 114.78 PALLET JACK RNTL 7/27-8/2/21 196048 6913-4871-8/3 6110 6555 RENTAL OF EQUIPMENT DOWNTOWN LIQUOR REV&EXP 06100 02 8.56 SKATE CAMP SUPPLIES 196049 6984-5922-8/2 2502 6570 PROGRAMMING EXPENSE ICE ARENA OPERATIONS EXPE 02500 09 42.15 SKATE CAMP SUPPLIES 196050 6984-5838-8/2 2502 6570 PROGRAMMING EXPENSE ICE ARENA OPERATIONS EXPE 02500 09 8.02 SKATE CAMP SUPPLIES 196051 6984-5748-8/2 2502 6570 PROGRAMMING EXPENSE ICE ARENA OPERATIONS EXPE 02500 09 8.02 SKATE CAMP SUPPLIES 196052 6984-7017-8/2 2502 6570 PROGRAMMING EXPENSE ICE ARENA OPERATIONS EXPE 02500 09 17.25 INSTRUCTOR MEMBERSHIP FEE 196053 6984-0431-7/26 2502 6460 MEMBER DUES&LICENSURE ICE ARENA OPERATIONS EXPE 02500 09 31.00 INSTRUCTOR MEMBERSHIP FEE 196054 6984-0597-7/26 2502 6460 MEMBER DUES&LICENSURE ICE ARENA OPERATIONS EXPE 02500 09 57.40 TBALL SOCCER EQUIPMENT 196055 6984-9961-7/15 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 6.81 TENT FASTNERS 196056 6984-2860-7/16 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 6.41 3 HOLE PUNCH 196057 6984-8107-7/19 1095 6210 OFFICE SUPPLIES RECREATION PROGRAM SERVIC 01000 09 83.68 MOVIE IN PARK SUPPLIES 196058 6984-2944-7/16 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 119.97 TBALL SOFTBALL EQUIPMENT 196059 6984-3719-7/15 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 79.98 TBALL EQUIPMENT 196060 6984-0532-7/15 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 34.50 SKATE CAMP ACTIVITY SUPPLIES 196061 6984-2351-7/29 2502 6570 PROGRAMMING EXPENSE ICE ARENA OPERATIONS EXPE 02500 09 172.82- RTRN:DRUM DOLLY(15) 196317 3387-0783-7/30 1072 6220 EQUIP SUPPLIES&PARTS STREET MAINTENANCE 01000 08 172.82- RTRN:DRUM DOLLY(15) 196317 3387-0783-7/30 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 11.88 196317 3387-0783-7/30 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 172.82- RTRN:DRUM DOLLY(15) 196317 3387-0783-7/30 6202 6220 EQUIP SUPPLIES&PARTS SEWER OPERATIONS EXPENSE 06200 08 184.70- RTRN:DRUM DOLLY(15) 196317 3387-0783-7/30 6302 6220 EQUIP SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 OB 172.82- RTRN:DRUM DOLLY(15) 196317 3387-0783-7/30 6402 6220 EQUIP SUPPLIES&PARTS STORM WATER UTILITY OPERA 06400 08 170.75- RTRN:DRUM DOLLY(15) 196317 3387-0783-7/30 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 198.00 DRUM DOLLY(15) 196318 3387-3825-7/22 1072 6220 EQUIP SUPPLIES&PARTS STREET MAINTENANCE 01000 08 198.00 DRUM DOLLY(15) 196318 3387-3825-7/22 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 13.61- 196318 3387-3825-7/22 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 198.00 DRUM DOLLY(15) 196318 3387-3825-7/22 6202 6220 EQUIP SUPPLIES&PARTS SEWER OPERATIONS EXPENSE 06200 08 211.61 DRUM DOLLY(15) 196318 3387-3825-7/22 6302 6220 EQUIP SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 198.00 DRUM DOLLY(15) 196318 3387-3825-7/22 6402 6220 EQUIP SUPPLIES&PARTS STORM WATER UTILITY OPERA 06400 08 195.63 DRUM DOLLY(15) 196318 3387-3825-7/22 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 1,200.00 SOURCELINK SOFTWARE 196363 3082-7560-8/4 2000 6505 EQUIPMENT REPAIR/MAINTENANCE HRA/ECONOMIC DEVELOPMENT 02000 03 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/13/2021 12:38:09 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 23 8/12/2021 - 9/13/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 16.10 COFFEE:FLOW TESTING 196364 6125-3806-8/3 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01000 06 4.99 DONUTS:FLOW TESTING 196365 6125-3822-8/3 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01000 06 193.40 SUPPLIES FOR PARTY IN THE PARK 196366 6984-9608-7/30 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 93.88 CAMSHAFT FOR MOWER 0008 196367 2145-8769-7/14 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 200.00 MIAMACONFERENCE:PIRE,J 196368 3387-0660-8/4 2502 6470 TRAINING&SUBSISTANCE ICE ARENA OPERATIONS EXPE 02500 09 119.70 RRP LOCKS EXT SVS PLAN(6) 196370 3387-0763-8/2 1090 6515 BUILDING REPAIR/MAINTENANCE PARK MAINTENANCE 01000 09 25.32 FOOD FOR LADDER TRAINING 196732 8801-1490-7/15 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01DD0 06 20,279.55 20210901 9/2/2021 117968 EBSO 71,487.86 SEPT-21 HEALTH INS PREMIUM 196200 9029-073206-1000 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 71,487.86 20210902 9/2/2021 117955 VSP INSURANCE CO. 320.97 SEPT'21 VISION INS PREMIUM 196186 813039247 SEPT'21 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 320.97 20210903 9/2/2021 100394 XCEL ENERGY 6,949.59 JUL'21 ELEC NOW METER ST LTS 196134 51-4874005 JUL'21 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 7.27 JUL'21 ELEC CITY GARAGE 196134 51-4874005 JUL'21 1090 6422 ELECTRIC PARK MAINTENANCE 01000 09 4.36 JUL'21 ELEC CITY GARAGE 196134 514874005 JUL'21 1072 6422 ELECTRIC STREET MAINTENANCE 01000 08 2.91 JUL'21 ELEC CITY GARAGE 196134 514874005 JUL'21 6402 6422 ELECTRIC STORM WATER UTILITY OPERA 06400 08 10.18 JUL'21 ELEC CITY GARAGE 196134 51-4874005 JUL'21 6302 6422 ELECTRIC SOLID WASTE OPERATIONS 06300 08 107.62 JUL'21 ELEC CITY GARAGE 196134 51-4874005 JUL'21 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 13.09 JUL'21 ELEC CITY GARAGE 196134 514874005 JUL'21 6202 6422 ELECTRIC SEWER OPERATIONS EXPENSE 06200 08 143.28 JUL'21 ELEC ROUNDABOUT 196134 51-4874005 JUL'21 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 60.66 JUL'21 ELEC TRAFFIC SIGNAL 196134 51-4874005 JUL'21 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 54.79 JUL'21 ELEC LIFT STATIONS 196134 51-4874005 JUL'21 6202 6422 ELECTRIC SEWER OPERATIONS EXPENSE 06200 08 3,808.85 JUL'21 ELEC WELL#1&3 196134 514874005 JUL'21 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 44.07 JUL'21 ELEC DOWNTOWN ST LTS 196134 51-4874005 JUL'21 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 11,206.67 20210904 9/7/2021 100085 DAKOTA ELECTRIC ASSOCIATION 6,370.58 JUL'21 ELEC 9TH ST STREET LTS 195890 200001038421 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 JUL'21 123.82 JUL'21 ELEC VERM GROVELS 195891 200003215779 6202 6422 ELECTRIC SEWER OPERATIONS EXPENSE 06200 08 JUL'21 137.99 JUL'21 ELEC 195TH WATER TOWER 195892 200002587095 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 JUL'21 2,331.03 JUL'21 ELEC WELL#7 195893 200003490737 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 JUL'21 2,724.00 JUL-21 ELEC WELL#5 195894 200002785533 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 JUL'21 2,012.46 JUL21 ELEC WELL#4 195895 200001318526 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/13/2021 12:38:09 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 24 8/12/2021 - 9/13/2021 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div JUL'21 25.10 JUL'21 ELEC DAISY KNOLL TOWER 195896 200001318518 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 JUL'21 4,214.31 JUL-21 ELEC WELL#6 195897 200001550151 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 JUL'21 4,435.51 JUL-21 ELEC WELL#8 195899 200004199709 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 JUL'21 1,561.03 JUL'21 ELEC PK LIQ STORE 195904 200003759891 6115 6422 ELECTRIC PILOT KNOB LIQUOR 06100 02 JUL'21 409.09 JUL'21 ELEC FIRE STATN#2 195942 200003971959 1060 6422 ELECTRIC FIRE SERVICES 01000 06 JUL'21 5.00 JUL'21 ELEC CIV DEF SIREN 195949 200002260958 1054 6422 ELECTRIC EMERGENCY MGMT SERVICES 01000 05 JUL'21 5.00 JUL'21 ELEC CIV DEF SIREN 195950 200001982271 1054 6422 ELECTRIC EMERGENCY MGMT SERVICES 01000 05 JUL'21 35.54 JUL'21 ELEC TUNNEL LIGHT 196252 200005468327 1090 6422 ELECTRIC PARK MAINTENANCE 01000 09 JUL'21 24,390.46 20210905 917/2021 108980 MINNESOTA ENERGY RESOURCES CORPORATION 18.00 AUG'21 GAS 208TH ST WARM HOUSE 196258 3816997294 AUG'21 1090 6422 ELECTRIC PARK MAINTENANCE 01000 09 18.00 20210906 9/8/2021 114654 INVOICE CLOUD 519.19 AUG'21 IC PYMT FEES 196707 819-2021_8 6202 6545 PYMT PROCESSING FEES SEWER OPERATIONS EXPENSE 06200 08 519.19 AUG'21 IC PYMT FEES 196707 819-2021_8 6302 6545 PYMT PROCESSING FEES SOLID WASTE OPERATIONS 06300 08 519.19 AUG'21 IC PYMT FEES 196707 819-2021_8 6402 6545 PYMT PROCESSING FEES STORM WATER UTILITY OPERA 06400 08 519.18 AUG'21 IC PYMT FEES 196707 819-20218 6502 6545 PYMT PROCESSING FEES WATER UTILITY EXPENSE 06500 08 2,076.75 APPR VALS: Report Totals 672,183.52 HOYT BERNHJELM PEARSON VLSOORR N CITY OF O 430 Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 Farmington M N.gov TO: Mayor, Councilmembers and City Administrator FROM: Chris Regis, Finance Director SUBJECT: Preliminary 2022 General Fund Budget and Tax Levy DATE: September 20, 2021 INTRODUCTION See attached City Council memo. DISCUSSION See attached Council Memo. BUDGET IMPACT See attached Council Memo. ACTION REQUESTED See attached Council Memo. ATTACHMENTS: Type Description D Cover Memo 2022 Memo Preliminary Budget and Tax Levy D Resolution 2022 Preliminary Levy Resolution D Backup Material 2022 General Fund Budget Summary D Backup Material 2022 General Fund Revenue Summary D Backup Material 2022 General Fund Expenditure Summary D Backup Material 2022 Debt Levy D Backup Material 2022 Operating Transfers ---CITY OF 0 43o Third St.,Farmington,MN 55024 FA R M I N GTO N © 651-280-6800 FarmingtonMN.gov TO: Mayor, Councilmembers and City Administrator FROM: Chris Regis, Finance Director SUBJECT: Preliminary 2022 General Fund Budget and Tax Levy DATE: September 20, 2021 INTRODUCTION State statute requires that the proposed property tax levy for the upcoming year be certified to Dakota County on or before September 30th each year.The city council is being asked to adopt the 2022 proposed property tax levy which will be included in the proposed property tax statements that are mailed to taxpayers in November. DISCUSSION The city council discussed the 2022 General Fund budget and tax levy at work sessions in July, August, and September. The proposed budget and tax levy are shown below. 2021 Budget 2022 Increase Proposed (Decrease) Budget Revenues $3,298,34411, 9.SUTO Expenditures 13,832,464 15,729,719 13.7 6 Fiscal Disparities— ,6 1,4 3.24% General Fund Levy 8,256,461 9,766,736 18.29% Debt evy 1 3,012,093 2,2 2 o et ax evy 4 512,032,524 b.780 General Fund Revenues Revenues for the General Fund continue to move in a positive direction reflecting a 9.50%increase from 2021. The General Fund has revenues outside of the tax levy. These revenues come from a variety of sources shown below. 2 2022 Increase 021 Budget Proposed (Decrease) Budget Licenses and Permits 5 7, 7 5736,700 42. 7 o Intergovernmental Revenue o Charge for Service 57 702,4 0 4.5 o Ines and Forfeitures 49,000 50,000 2.04% Investment Income 29,100 41, 00 4 T6 0 isce aneous ,3 o Transfers In 1,379,689 1,427,858 3.49% Tota Revenues 44S11—,5-93— .5000 Revenue items of note in the draft 2022 budget: • Permit revenue reflects an increase of$219,624 due to an increase in single family home construction and continued revenue from home remodeling projects such as new decks,kitchens,bathrooms,etc. • There was no change in Local Government Aid revenue from 2021,it will remain at the 2021 level of$105,587. • Intergovernmental revenues will also reflect slight increases in Police and Fire State Aid revenues in 2022. • Charges for Service revenue has increased primarily due to an increase in Fire Charges revenue. • Investment income is estimated to increase by$12,500 in 2022.This is based on prior historical returns. General Fund Expenditures There have been many reviews and revisions in an effort to lower the overall levy increase.The proposed 2022 expenditures are summarized below. 2 2022 Increase 021 Budget g Proposed (Decrease) Budget Administration $902,915 1,099,249 21.74% Human Resource 361,658 402,112 1.19% Dakota Broadband ° Finance& Risk Management 776,287 818,759 5.47% Police5,279,810 ° Fire 1,435,685 1,592,646 10.93% ommunity Development 1,007,84 1, Engineering 813,895 850,411 4.49°0 Municipal Services 1,511,187 1,609,704 6.52% Pars & Recreation 1,317, 41 1,329,737 4 ° rans ers Out ° Tota Expen itures 513,832,464 15,729,719 13.7 Human Resource Costs All of the budgets include estimated human resource costs based on approved union contracts and estimates for employee benefits and worker's compensation premiums. Union contract negotiations are currently underway with all four unions.In addition,the City has been notified that we will receive a 5%increase in our health insurance premiums for 2022. Expenditure items of note in the preliminary 2022 budget include: • The Administration budget has increased due to the Assistant City Administrator position that was added in mid-2021. • The police budget has increased by 8.96%.This increase is comprised of several small increases throughout the police budget, with the largest increase being seen in the benefits line item. • The fire budget also reflects an increase due to dollars being included to address future station needs of the department and to replace tables and chairs that are in need of replacement. • Purchase of three new lawn mowers for the Parks&Recreation department. • The construction of the Highway 3/County Road 66 Roundabout. • Funding increase for street maintenance of 96%. Operating Transfers There are transfers in and out shown in the General Fund budget. The transfers into the General Fund are from the enterprise funds to reimburse the General Fund for human resource and administrative costs which benefit the enterprise funds. Transfers out reflect a significant increase in 2022 over 2021 by$820,258.The transfers out are comprised of the LGA and tax levy.The increase can be attributed to the following: • Provide for future debt service for the Spruce/Division Street reconstruction project in the amount of$175,000. a Increase in mill and overlay of$318,792 for a total of$650,000 for the Akin Road Mill&Overlay project. • Increase of trail maintenance funding of$65,000 for a total of$135,000. • An increase of 375,000 or 72%for the Vehicle and Equipment Replacement Plan. A detailed break-down of the transfers has been included as a separate exhibit in your packet. Fiscal Disparities This is a metro wide program that is used to balance the development of commercial and industrial growth through the region.The city has received a preliminary estimate of the final number which includes an increase of$73,741. Debt Levy The Debt Service Funds budget provides funding for scheduled debt principal and interest repayment obligations,as well as ongoing trustee,assessments, arbitrage, and post-issuance compliance fees related to the city's debt. The levy includes both General Obligation bonds and Interfund loans.The 2022 debt levy is 24.73 percent lower than the 2021 debt levy. The decrease in debt is due to the reduction in the debt service loans for the 2005C bonds and paying off debt related to the police station construction.Detail on the debt levy obligations is included with this memo. Additional Notes The City continues to make progress to reach adequate funding levels in several areas including pavement management,trail maintenance, building maintenance and fleet replacement. The taxable market value of the average residential property in Farmington will be$282,815 in 2022.This is a 3.95%increase from the 2021 average residential property.The current proposed 2022 tax levy amount would increase the city tax on the average property by$76 peryear. Keep in mind the values are one year behind and these are payable 2022 values. BUDGET IMPACT The budget impact is summarized with the content of this memo. ACTION REQUESTED Hear the presentation that will be made by city staff and ask any questions you may have. Once the city council is comfortable, a motion should be made to: • Adopt the attached resolution establishing the 2022 preliminary tax levy as proposed • Set the public input meeting prior to the adoption of the final 2022 budget and tax levy for Monday, December 6,2021 at 7:00 p.m. ATTACHMENTS: Type Description Discussion City Council Memo 2022 Budget&Tax Levy ❑ Resolution 2022 Preliminary Levy Resolution ❑ Backup Material 2022 General Fund Budget Summary ❑ Backup Material 2022 General Fund Revenue Summary ❑ Backup Material 2022 General Fund Expenditure Summary ❑ Backup Material 2022 Debt Levy ❑ Backup Material 2022 Operating Transfers RESOLUTION NO. R47-21 A RESOLUTION APPROVING THE 2021 PROPOSED TAX LEVY COLLECTIBLE IN 2022 Pursuant to due call and notice thereof, a regular meeting of the City Council of the city of Farmington was held at the Farmington City Hall on the 20th day of September 2021 at 7:00 p.m. Members Present: Hoyt, Bernhj elm, Pearson, Porter, Wilson Members Absent: None Member Wilson and Member Bernhj elm introduced and seconded the following: WHEREAS, Minnesota State Statute currently in force requires certification of the proposed tax levy to the Dakota County Auditor on or before September 30, 2021; and WHEREAS, the City Council of the City of Farmington, Minnesota is in receipt of the proposed 2022 revenue and expenditure budget. WHEREAS, the City Council shall use existing City revenues to meet the annual debt obligations for 2016B GO Capital Improvement Plan Refunding Bonds $29,848; thereby reducing the total debt levy issued and collected from property taxes of$640,000. NOW, THEREFORE, BE IT RESOLVED by the Mayor and City Council of the City of Farmington that the following sums of money be levied in 2021, collectible in 2022, upon the taxable property in said City of Farmington for the following purposes: General Fund $12,118,136 Debt Levy + $2,265,788 Gross Levy $14,383,924 Fiscal Disparities - $2,351,400 Net Tax Levy $12,032,524 This resolution was adopted by recorded vote of the Fannin it—Co in open session on the 201h day of September 2021. Jo a Hoyt,Mayor Attested to on the � day of September 2021. Dav' McKnight,, City Aknidstrator SEAL 2022 BUDGET Summary of Debt Service levy to be attached and become part of this resolution. Fund Project Lew Amount 3093 2015A GO Improvement Bond $335,500 3094 2016A GO Refunding Bond $624,750 3136 2016B GO Refunding Bond $640,000 3138 2019A GO Street Reconstruction Bond $231,525 3139 2020A GO Equipment Certificates $268,013 Total Bond Financing $2,099,788 3130 2005C GO Capital Improvement Bond $166,000 Total Debt Levy $2,265,788 The amount levied is less than the required amounts from the payment schedule for some of the bonds. The bonds are listed on Form B which is part of this resolution. The city has sufficient revenues in the bond funds to meet the debt obligations. City of Farmington,Levy Certification,Debt Service Schedule. Form B Net Levy Original Amount Per Increase Certified B.U. Bond Issue Principal Date Issued Bond Book (Decrease) Debt Levy Notes 3093 GO Street Reconstruction 2015A $ 3,050,000 10/15/2015 $ 284,235 $ 51,265 $ 335,500 3094 GO Refunding 2016A $ 3,450,000 12/1/2016 $ - $ 624,750 $ 624,750 3136 Cap Imp Plan Refunding 2016B $ 4,540,000 12/1/2016 $ 669,848 $ (29,848) $ 640,000 A 3138 GO Street Reconstruction 2019A $ 1,645,000 5/15/2019 $ 231,525 $ $ 231,525 3139 GO Equipment Certificates 2020A $ 1,105,000 2/19/2020 $ 268,013 $ $ 268,013 Total Bond Financing $ 13,790,000 $ 1,453,620 $ 646,168 $ 2,099,788 3130 2005C GO Bonds Internal Loan Repayment $ 2,280,000 7/5/2005 $ - $ - $ 166,000 B Total Debt $ 16,070,000 $ 1,453,620 $ 646,168 $ 2,265,788 Agrees to I hereby certify that the above schedule of bond levies to be spread on the payable 2021 tax rolls agrees with the City preliminary debt records. A copy of the corresponding debt levy resolution is attached. levy adopted by council on 9/20/2021 9/20/2021. Finance Director Date t (A)Existing revenues in the respective bond fund are being used to meet the annual debt obligations. (B)Bonds optionally redeemed with an internal loan from the city. Loan is being repaid with debt levy. City of Farmington Budget and Tax Levy 2021 Budget,2022 Proposed and 2023 Proposed 2021 2022 Budget% 2023 Budget Company Budget Proposed Change Proposed Change% Non-Property Tax Revenues Licenses and Permits 517,076 736,700 42.47% 718,100 (2.52)%' Intergovernmental Revenue 667,912 672,087 0.63% 677,087 0.74%' Charge for Service 576,197 602,460 4.56% 583,804 (3.10)% Fines and Forfeitures 49,000 50,000 2.04% 50,000 0.00% Investment Income 29,100 41,600 42.96% 27,700 (33.41)% Miscellaneous 79,370 80,8781.90% 50,878 (37.09)% -Transfers In 1,379,689 1,427,858 3.49%0 1,484,973 4.00% Total Revenues 3,298,344 3,611,583 9.50% 3,592,542 (0.53)% Expenditures Administration 902,915 1,099,249 21.74% 1,097,067 (0.20)% Human Resource 361,658 402,112 11.19% 403,181 0.27%' Dakota Broadband 37,500 45,500 21.33% 55,500 21.98%' Finance and Risk Mgmt 776,287 818,759 5.47% 843,271 2.99% Police 4,845,796 5,279,810 8.96% 5,625,633 6.55% Fire 1,435,685 1,592,646 10.93% 1,608,221 0.98% Community Development 1,007,849 1,059,182 5.09% 1,101,722 4.02% Engineering 813,895 850,411 4.49% 874,953 2.89% Municipal Services 1,511,187 1,609,704 6.52% 1,732,967 7.66% Parks and Recreation 1,317,341 1,329,737 0.94% 1,378,512 3.67% Transfers Out 822,351 1,642,609 99.75% 2,756,609 67.82% Total Expenditures 13,832,464 15,729,719 13.72% 17,477,636 11.11% Revenues Over(Under)Expenditures (10,534,120) (12,118,136) 15.04% (13,885,094) 14.58% Fiscal Disparities 2,277,659 2,351,400 3.24% 2,351,400 0.00% General Fund Levy 8,256,461 9,766,736 18.29% 11,533,694 18.09% Debt Levy _ Bonds 2,444,840 2,099,788 (14.11)% 1707,263 (18.69)% 2005C Loan Repay-Storm Water Tr Adv 275,000 166,000 (39.64)% 166,000 0.00% 2010A Loan Repay-Storm Water Tr Adv 292,253' 0 (100.00)% 201 OD Loan Repay-Storm Water Tr Adv 0 0 Total Debt Levy 3,012,093 2,265,788 (24.78)% 1,873,263' (17.32)% Use of Fund Balance to Lower Debt Levy 0 Net Debt Levy 3,012,093 2,265,788 (24.78)% 1,873,263' (17.32)%' Farmington Net Tax Levy 11,268,554 12,032,524 6.78% 13,406,957 11.42%' Location: Documents\FARMINGTON\Budget 2022-2023\1 General Fund Budget Summary Page 2021 Base w/DBB Amend 9/10/2021 12:42:49 PM General Fund Detailed Non-Property Tax Revenue Summary 2020 Budget,2021 Budget, 2022 Proposed and 2023 Proposed Object 2020 2021 2022 2023 Account Budget Budget Proposed Proposed LIQUOR LICENSES 41,700 40,000 40,00040,000 BEER&WINE LICENSES 1,100 1,100 800 800 CLUB LICENSES 500 500 500' 5001 MASSAGE LICENSE 350 300' 50 50 GAMBLING LICENSE/PERMIT 450 250 150, 150 OTHER LICENSE&PERMIT 1,900 1,700 1,400 1,400 ANIMAL LICENSES 4,080 2,500 2,000 1,700' Licenses 50,080 46,350 44,900 44,600' BUILDING PERMITS 330,000 380,876 590,000 572,250 REINSPECTION FEES 1,000 1,500 1,200 1,200 CODE ENFORCEMENT FEES 2,600 1,500 900 900 PLUMBING&HEATING PERMITS 52,500 50,000 60,000 60,000 SEWER PERMITS 5,000 0 0 0' ELECTRIC PERMITS 16,000 16,000 20,000 20,000' ISTS PERMITS 300 300 250 250 UTILITY PERMITS 6,420 10,500 10,500 10,000 SIGN PERMITS 790 800 700 700 BURNING PERMITS 1,425 1,250 1,250 1,200 OTHER PERMITS 7,000 8,000 7,000 7,000 Permits 423,035 470,726 691,800 673,500' Licenses and Permits 473,115 517,076 736;700 718,100 FEDERAL GRANT 5,000 5,000 5,000 5,000' FEDERAL AID _ LOCAL GOVERNMENT AI D 328,374 105,587 105,587 105,587 MSA MAINTENANCE 215,000 184,000 184,000 184,000 POLICE AID 198,500 198,000 205,000 205,000 POST TRAINING 15,160 15,160 15,000 15,000 FIRE AID 137,910 142,490 150,000 155,000' STATE GRANT 9,0000 MARKET VALUE CREDIT 0 _ 0 COUNTY MISCELLANEOUS 1 13,350 13,350 7,500 7,500 Intergovernmental 922,294'; 663,587 672,087 677,087 CUSTOMER SERVICE TAXABLE CUSTOMER SERVICES NONTAXABLE 200 210 135 135 ZONING&SUBDIVISION FEES 3,050 2,600 3,000 3,000 ADMINISTRATION FEES-PROJECTS 4,500 4,000 4,000 4,000 FIRE CHARGES 237,172 239,227 258,940 264,177 POLICE SERVICE CHARGES 78,030 78,810 80,385 81,992 ENGINEERING FEES-PROJECTS EROSION&SEDIMENT CONTROL 8,100 8,100 9,500 9,000' RECREATION FEES-GENERAL 85,000 75,000 75,000' 75,000' RECREATION FEES-SENIOR CTR 19,000 15,000 17,000 17,000 MEMBERSHIP FEES-SENIOR CTR 8,000 6,000 7,500 7,500 MOBILE MEALS-SENIOR CTR ADVERTISING 950 750 500 500 ADVERTISING 1,800 1,500 1,500 1,500 SALES OF ASSETS 0 0 FRANCHISE FEE 120,000 145,000 145,000 120,000 Charges For Services 565,802 576,197 602,460 583,804 Page 1 of 2 General Fund Detailed Non-Property Tax Revenue Summary 2020 Budget,2021 Budget, 2022 Proposed and 2023 Proposed Object 2020 2021 2022 2023 Account Budget Budget Proposed Proposed COURT FINES 49,000 49,000 50,000 50,000 Fines&Forfeitures 49,000 49,000 50,000 50,000' INTEREST ON INVESTMENTS 38,800 29,100 41,600 27,700 GAIN/LOSS INVEST MKT VALUE Investment Income 38,800 29,100 41,600 27,700 MISCELLANEOUS REVENUE 1,500 31,700 34,200 4,200 CASH OVER&SHORT RENTAL INCOME-RRC 20,880 18,000 18,000 18,000 RENTAL INCOME 31,700 29,670 28,678 28,678 DONATIONS _ 500 0 Misc Revenue 54,580 79,370 80,878 50,878' OPERATING TRANSFERS 1,307,570 1,379,689 1,427,858 1,484,973 Transfers In 1,307,570` 1,379,689 1,427,858 1,484,973 Total Revenues $3,411,161 $3,294,019 $3,611,583 $3,592,542 Page 2 of 2 General Fund Expenditure Detail Summary 2020 Budget,2021 Budget 2022 Proposed and 2023 Proposed Company 2020 2021 2022 2023 Budget Budget Proposed Proposed Expenditures Administration Legislative(1005) 87,772 87,392 87,259 91,483' Administration(1010) 302,068 321,712 469,641 486,372 Elections(1013) 44,124 9,351 47,948 8,250 Communications(1014) 108,537 114,900 132,916 136,582 City Hall(1015) 364,661 369,560 361,485 374,380 Administration 907,162 902,915 1,099,249 1,097,067' Human Resources 349,226 361,658 402,112 403,181 Human Resource(1011) 349,226 361,658 402,112 403,181 Human Resources 349,226 361,658' 402,112 403,181' Dakota Broadband 24,489 37,500 45,500 55,500 Dakota Broadband 24,489 37,500 45,500 55,500 Dakota Broadband 24,4891 37,500 45,500 55,500 Finance and Risk Management Finance(1021) 609,079 603,097 648,309 670,161 Risk Management(1022) 169,810 173,190' 170,450 173,110 Finance and Risk Management 778,889 776,287 818,759 843,271' Police Police Administration(1050) 1,235,377 1,263,014 1,356,642 1,377,907 Patrol Services(1051) 2,538,727 2,639,752 2,929,249 3,233,168 Investigations(1052) 892,059 926,430 974,019 993,158 Emergency Management(1054) 11,650' 16,600 19,900 21,400 Police 4,677,813' 4,845,796 5,279,810' 5,625,633 Fire Fire(1060) 1,445,410 1,435,685 1,592,646' 1,608,221 Fire 1,445,410 1,435,685 1,592,646' 1,608,221 Community Development 1,014,867 1,007,849 1,059,182 1,101,722 Planning(1030) 591,133 567,681 624,475 648,368 Building Inspection(1031) 423,734 440,168 434,707 453,354 Community Development 1,014,867 1,007,849 1,059,182' 1,101,722 Engineering Engineering(1070) 665,173 694,134 725,816' 746,721 Natural Resources(1076) 129,462 119,761 124,595 128,232 Engineering 794,635 813,895 850,411 874,953' Municipal Services Streets(1072) 1,197,200 1,268,832 1,358,489 1,472,837 Snow Removal(1073) 241,878' 242,355 251,215 260,130 Municipal Services 1,439,078 1,511,187 1,609,704 1,732,967' Parks and Recreation Park Maintenance(1090) 700,111 733,607 677,974' 694,448 Rambling River Center(1093) 190,822 185,054 227,731 259,333 Park&Rec Admin(1094) 287,925 304,383 324,745' 321,093 Recreation Programs(1095) 99,718 94,297 99,287' 103,638 Parks and Recreation 1,278,576 1,317,341 1,329,737 1,378,512' Transfers Out 932,207.00 822,351.00 1,642,609.00 2,756,609.00 Transfers Out 932,207.00 822,351.00 1,642,609.00 2,756,609.00' Total Expenditures 13,642,352 13,832,464 15,729,719' 17,477,636 9/10/2021 12:48:26 PM Page 1 of 1 B I C D I E I F I H I L I M I N 1 O 1 P I O I R I S I T I U I V I W I X I Y I Z I AA I AS AC I AD 1 2022 OPERATING TRANSFERS 2 TRANSFERS IN 5205 General Capital General General General Equipment Capital Capital Emp Exp Storm Capital Fund Equip Fund Equip Fund Fund T-1-11.A Water Arena Cap Equip Fund (Police (Police (Fire Township Solid Emp Exp (Comp Prop Ins 3 Park lm Fire Ca Trunk Pr j Fd (Vehicles) Vehicles) Equip) Equip) Sealcoat Street..in Trail..in EAB SId Main Road Main. Waste Fund Abs ISF 51 Fund1000 2000 2300 4300 4400 4503 5600 5600.5 5600.5 5600.6 5701 5711 5721 5751 5731 5741 6301 7000 7000 7100 Totals Difference 6 987,022 1000 Tax Levy 50 D00 0 20,000 110 000 25 000 1M,0110 MOM 1.[)0[) 9.0210 13,022 20,000 987,M - 7 105,587 1000LGA 50.000 10 000 45,587 105,587 - 8 175,000 1000 Future Street ClP Debt 1 175,000 1 175,000 - 9 - 1000 Future Street CIP Cash _ 10 375,000 1000 Future Vehicle CIP Cash 199,000 176,000 375,000 - 11 - 1000 Projects CIP Cash - 12 _ 1000 Projects CIP Debt - 13 _ - 2000 EDA - 14 O - 2500 Arena t 3094-2016A 15 M 306,800 306,900 306,900 - 16 .~.. - 3097-2010A 17 - 3099-2011A 18 O 166,000 3130-2005C 166,000 166,000 - 19 7n - 3136-20168 _ 20 M - 3137-2016C 21 w - 3300-2010DLL 22 (n - 3139-2020A 23 Z 142,966 6100 Admin(GF) 66,466 1 75,000 1 1.5001 142,966 - 24 - 6100 1 _ 25 92,887 6202 Admin(GF) 90,387 2,500 92,887 - 26 257,240 5202 HR 250,051 7,189 257,240 - 27 90,887 6302 Admin(GF) 90,3137 500 90 887 - 28 68,612 6302 HR 65,612 65,612 - 29 90,387 6402 Admin(GF) 90,387 90,387 - 30 3311654 6482 HR 324,665 7.189 331854 - 31 90,387 6502 Admin(GF) 90,3871 90,387 - 32 382,281 6502 HR 359,516 22,765 382,281 - 33 3,66D,DlD 1 1,427,858 50 000 75,000 472,900 20,000 199,000 176,000 110,000 25 000 650 000 175.000 135 D00 10,000 50,587 9,000 37,143 13,022 24,500 3,660,010 - 34 510,000 1,019,587 3,660,010 35 3,660,010