Loading...
HomeMy WebLinkAbout09.21.20 Council Packet CITY OF Meeting Location: FARMINGTI AW N Farmington City Hall 430 Third Street .. � : �` Farmington, MN 55024 CITY COUNCIL REGULAR MEETING AGENDA September 21, 2020 7:00 P.M. Action Taken 1. CALL TO ORDER 7.00 P.M. 2. PLEDGE OFALLEGIANCE 3. ROLL CALL 4. APPROVEAGENDA 5. ANNOUNCEMENTS/COMMENDATIONS 6. CITIZEN COMMENTS/RESPONSES TO COMMENTS(This time is reserved for citizen comments regarding non-agenda items.No official action can be taken on these items. Speakers are limited to five minutes to address the city council during citizen comment time.) 7. CONSENT AGENDA a) Approve Minutes of the September 8, 2020, City Council Meeting— Administration Approved b) Approve Minutes of the September 14, 2020, City Council Work Session— Administration Approved c) Approve Contract with Labrash Plumbing and Heating for the Installation of Touchless Faucets and Bottle Filling Stations—Parks Approved d) Adopt Resolution Approving a Gambling Premise Permit for Farmington Youth Hockey Association—Community Development R38-20 e) Approve Recommendation for Hire Liquor—Human Resources Approved f) Approve Bills - Finance Approved REGULAR AGENDA 8. PUBLIC HEARINGS 9. AWARD OF CONTRACT 10. PETITIONS,REQUESTSAND COMMUNICATIONS 11. UNFINISHED BUSINESS a) Adopt Resolution Approving Reassessment of the County Road 50 Water and Sewer Utilities R39-20 12. NEW B USINESS a) Adopt Resolution Approving Preliminary 2021 General Fund Budget and Tax Levy R40-20 13. CITY COUNCIL ROUNDTABLE 14. ADJOURN CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 FarmingtonMN.gov TO: Mayor, Councilmembers and City Administrator FROM: David McKnight, City Administrator SUBJECT: Approve Minutes of the September 8, 2020 City Council Meeting-Administration DATE: September 21, 2020 INTRODUCTION Attached for your review are the minutes of the September 8, 2020 city council meeting. DISCUSSION NA BUDGET IMPACT NA ACTION REQUESTED Approve the minutes of the September 8, 2020 city council meeting. ATTACHMENTS: Type Description D Cover Memo September 8, 2020 Minutes CITY OF FARMINGTON CITY COUNCIL MINUTES REGULAR MEETING SEPTEMBER 8, 2020 1. Call to Order Mayor Larson called the meeting to order at 7:00 p.m. 2. Pledge of Allegiance Mayor Larson led those in attendance in the Pledge of Allegiance. 3. Roll Call Present-Larson, Craig, Donnelly and Hoyt Absent-Bernhjelm Staff Present-Administrator McKnight, Community Development Director Kienberger, Public Works Director Gehler, Finance Director Gehler and Attorney Jamnik. 4. Agenda Motion by Craig, second by Donnelly, to approve the agenda as presented. APIF, motion carried. S. Announcements/Commendations None 6. Citizen Comments None 7. Consent Agenda Motion by Craig, second by Hoyt, to approve the consent agenda: a) Approve Minutes of the August 17, 2020 City Council Meeting-Administration b) Adopt Resolution R36-2020 Declaring Constitution Week-Administration c) Approve Summary of City Administrator Annual Performance Evaluation and Updated Employment Agreement-Attorney d) Approve Out of State Travel-Fire e) Approve Recommendation for Hire Fire-Human Resources September 8, 2020 Minutes - 1 - f) Approve Memorandum of Understanding with LELS Patrol-Human Resources g) Approve Recommendation for Hire Community Development-Human Resources h) Approve Bills-Finance APIF, motion carried. 8. Public Hearings a) Assessment Hearing for the Reassessment of the County Road 50 Water and Sewer Assessments Public Works Director Gehler shared with the city council an update on the assessments that remain on properties from a 1990's era water and sewer project. In the late 1980's the city completed two projects to extend water and sanitary sewer trunk infrastructure along CR 50 from Akin Road to Pilot Knob. These trunk utilities helped to facilitate the development of the industrial park and provide future service to the surrounding areas. The cost of the improvement was assessed to benefitting properties. Areas within the first phase of the Industrial Park and Northern Natural Gas were assessed as well as agricultural areas south of CR 50. Given the green acres status of the southern properties, the assessments were deferred until development occurred while continuing to accrue interest at a rate over 8%. One parcel from the original assessment rolls is continuing to accrue interest on a deferred basis. This parcel is 80-acres located west of the Vermillion River Crossings development and was assessed a total of$192,000 for both projects. Given the time that has passed and the continued accrual of interest, the current amount of the assessment, principal and interest, is $698,577.31 that will be due upon sale or development of the parcel. This amount has raised concerns when put in context with other fees that are charged with development. For this 80-acre parcel, area charges for sewer and water that are paid at the time of platting would be approximately $500,000. Combined with the current assessment,the fees are cost prohibitive. At a work session last summer staff discussed how the city has funded trunk utility projects in the past that included the use of an area-wide assessment whereas today the city incorporates the cost of these in availability charges (SAC and WAC fees) collected as part of the development contract. Options were discussed to address the large assessments on this parcel that included adjustment to the current assessment through the 429 assessment process, waiver of development fees or a combination thereof. Consensus was to reassess to waive the previous assessment and collect the standard development fees as development occurs. This option relieves the significant financial burden on the parcel at the time of September 8, 2020 Minutes -2 - development, allows the city to collect amounts needed to support the development of these parcels while managing challenges that can be associated with assessments and providing consistency in how the city completes development. To complete the reassessment process,the city must follow Minnesota State Statute 429,which details the steps cities must follow when utilizing assessments. In this case,the city must call for an assessment hearing(public hearing on the assessment amount) by resolution, provide a 14-day notice, and hold the assessment hearing before acting on the proposed assessment. The City Council adopted Resolution 33-20 on August 3, 2020 calling for the assessment hearing on September 8, 2020. Notice was provided to the property owner on August 12, 2020 and it was published in the city's official paper on August 21, 2020 meeting the public notice requirements. Mayor Larson opened the public hearing. Councilmember Donnelly asked if we received any comments from the public. Gehler stated we did not. Donnelly stated this approach seems logical and the current assessment is prohibitive. Councilmember Hoyt asked how many other properties were assessed. Gehler stated it was several. Hoyt clarified that all of the other assessments have been paid. Gehler stated that they have all been paid along with the debt that was issued for the project. Donnelly asked if any other agriculture properties had been assessed. Gehler stated that there was one additional agriculture property that was assessed. With no one in attendance wishing to comment, a motion was made by Donnelly, and seconded by Craig, to close the public hearing. APIF, motion carried. Motion by Hoyt, second by Craig, to table this issue so it can be discussed at the September work session with all councilmembers present and another option reviewed. APIF, motion carried. 9. Award of Contract None 10. Petitions, Requests and Communications a) Commercial Rehabilitation Grant Request-306-312 Oak Street Community Development Director Kienberger presented a commercial rehabilitation grant request from Paul Otten who now owns a commercial building located at 306/312 Oak Street. September 8, 2020 Minutes -3- The grant request is for$27,141 for improvements to eliminate conditions detrimental to public health and safety. The Economic Development Authority (EDA) discussed this request at their last meeting and voted to recommend the allocation of Community Development Block Grant (CDBG) funds for this request. City staff has also worked with staff from the Dakota County CDA to ensure eligibility for this grant request. The community rehabilitation grant program is designed to assist local businesses and/or wners who are making qualified improvements to eligible commercial properties that eliminate conditions detrimental to public health and safety. Paul Otten thanked the city council, EDA and city staff for their assistance on this process. Councilmember Craig shared that she appreciated the investment by Mr. Otten in the downtown area. Motion by Hoyt, second by Craig, to approve the grant agreement for a commercial rehabilitation grant with W. Paul Otten for the 306/312 Oak Street building for$27,141. APIF, motion carried. 11. Unfinished Business None 12. New Business a) CARES Act Election Funding Finance Director Malecha shared that the Minnesota Office of the Secretary of State (SOS) received funding through the 2020 CARES Act to prevent, prepare for and respond to coronavirus for the 2020 federal election cycle. A portion of these funds has been distributed to counties and municipalities throughout the state. Due to the pandemic,the amount of work and preparation for both the Primary and General Elections in 2020 have cost more in terms of time and dollars. Dakota County received funding from the SOS and decided to use the default distribution formula which means Farmington is eligible for$7,828 in CARES Act funding to use in response to elections. The use of these CARES Act dollars is limited to specific election related measures. If the city accepts these dollars we are eligible to use no more than 74% of the total costs of purchasing an electronic roster system and necessary equipment and not more than 8-$ of the total cost of any other authorized activities. The 2020 election budget will be used as the city's portion of qualified purchases. September 8, 2020 Minutes -4- The city must enter into an agreement with the county for the allocation of CARES Act funding and report the allocation to the OSS by September 15, 2020. Motion by Hoyt, second by Craig, to adopt Resolution R38-2020 approving the agreement with Dakota County for the receipt of CARES Act funding. APIF, motion carried. b) COVID-19 Response Update Administrator McKnight updated the city council on recent activities related to the city's response to the COVID pandemic. ✓ Continued effort to communicate with city staff and the city council on activities that are occurring in this area. ✓ Much time has been spent on the business assistance grants that Adam Kienberger provided an update on. ✓ The Rambling River Center continues to slowly open programs to members. In October, we will be trying a limited opening of the facility to members. ✓ CARES Act projects are being completed in city facilities already from our share of the funding received from the federal government. 13. City Council Roundtable Hoyt-Noted a few items from the consent agenda including the city administrator evaluation and two hiring's that were approved. McKnight-Shared that residents can contact city hall if they have questions on absentee or early voting. Gehler-Shared that a mattress pick up and paper shredding event will be held on September 12, 2020 Larson-Encouraged residents to shop local. 14. Adjourn Motion by Hoyt, second by Donnelly, to adjourn the meeting at 7:28 p.m. APIF, motion carried. Respectfully Submitted D A "C'K,,,�*r David McKnight, City Administrator September 8, 2020 Minutes -5- CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 �/Y1�` O Farmington M N.gov TO: Mayor, Councilmembers and City Administrator FROM: David McKnight, City Administrator SUBJECT: Approve Minutes of the September 14, 2020 City Council Work Session- Administration DATE: September 21, 2020 INTRODUCTION Attached for your review are the minutes of the September 14, 2020 city council work session. DISCUSSION NA BUDGET IMPACT NA ACTION REQUESTED Approve the minutes of the September 14, 2020 work session. ATTACHMENTS: Type Description D Cover Memo Minutes of the September 14, 2020 Work Session CITY OF FARMINGTON CITY COUNCIL MINUTES WORK SESSION SEPTEMBER 14,2020 Call to Order Mayo Larson called the work session to order at 6:00 p.m. Roll Call Present-Larson, Bernhjelm,Craig, Donnelly, and Hoy Also Present-Administrator McKnight, Finance Director Malecha, Public Works Director Gehler, Community Development Director Kienberger, Police Chief Rutherford and Parks and Recreation Director Distad. Agenda Motion by Hoyt, second by Bernhjelm,to approve the agenda as presented.APIF, motion carried. 2021 Draft Budgets Finance Director Malecha presented the second draft of the 2021 General Fund budget and tax levy. Staff began working on the draft budgets in April.The first draft of the General Fund budget represented a 29.12 percent increase over 2020. An increase of that size is not feasible for the residents and businesses within Farmington. Department heads have reviewed and revised their respective department budgets multiple times. City Administrator McKnight and I have done the same with the department budgets and the operating transfers budget. The changes reduced the levy increase to 12.85 percent,then to 6 percent. Further reductions have been made to bring the levy increase down to the 4.9 percent. General Fund At the August 10, 2020 work session, staff presented city council with a 6 percent levy. It has since been decreased to 4.9 percent as shown below: 2020 Budget 2021 Proposed Increase(Decrease) Budget Revenues $3,411,161 $3,298,344 (3.31)% Expenditures 13,642,352 13,832,464 1.39% Fiscal Disparities 2,294,024 2,277,659 (0.71)% General Fund Levy 7,937,167 8,256,461 4.02% Debt Levy 2,805,387 3,012,093 7.37% Net Tax Levy $10,742,554 $11,268,554 4.90% Many changes have been made to reduce the levy increase for 2021. The city's Local Government Aid (LGA) and Fiscal Disparities funds have been reduced by$228,800 and $16,365, respectively, requiring further reductions. Below are numerous changes that have been made, but the list is not all-inclusive. Revenue increases: • A portion of the franchise fee revenue that is transferred to the General Fund has been increased $25,000 to $145,000 for 2021. • The building permit revenue has been increased $62,190. • Utility and Other permit revenue was increased $4,000. • Investment income for the General Fund was increased $5,000. • Fire revenue was increased $4,325. • A transfer of$25,000 from the liquor proceeds to the General Fund was added. Historically, the transfer was only from the liquor proceeds to the Park Improvement Fund. Expenditure Decreases: • EDA funding was decreased from $70,000 to $40,000. • Fleet replacement has been reduced from $380,000 to $143,989 for police vehicles only. No other vehicle replacements are accounted for. • Sealcoat was reduced $600,000 for the property tax levy. An additional $200,000 will come from liquor store proceeds resulting in a net reduction of$400,000. • The extension of 202nd Street into Farmington from Lakeville at the north end of Farmington High School was removed resulting in a $200,000 decrease to the property tax levy. • Downtown sidewalk replacement of$100,000 was removed. • The first year debt payment for the Highway 3 backage road has been moved to 2022. • Trail maintenance was decreased from $80,000 to $50,000. • The transfer to the Arena Capital Project fund has been removed for 2021. • The City Council budget was reduced $2,100 for legal expenses and mileage. • The Snow Removal budget has been reduced $10,000 in street materials, fuel, equipment supplies and parts, and sod damage repair. • The salary for Natural Resources has been reduced $10,000. • The Police budget has been reduced $10,000 in fuel, budgeted overtime, and training. • The Fire budget has been reduced $10,000 in fuel, training, utility costs for the fire stations, and uniforms. • The Engineering budget has been reduced by$1,500 for fuel, professional services, and legal expenses. • The Municipal Services budget has been reduced $5,500 for spray patch and fuel. • Administration has been reduced by$3,000 for training, citywide office supplies, and equipment parts and supplies. • Elections equipment maintenance has been reduced $1,000. • Building maintenance has been reduced $85,172. • The transfer to property insurance has been reduced $14,024. Expenses are supported by the transfers into the fund from the tax levy. The fund can likely support itself with this reduction for one year. The RFP completed by Human Resources for staff health insurance was successful resulting in over$100,000 savings that affects the General Fund. If the revenues and expenditures do not meet budget, the General Fund fund balance must be used to fund the difference. The General Fund balance at the end of 2019 was 42.2 percent. City policy requires a fund balance between 40 and 50 percent. Due to COVID-19, it is difficult to predict the fund balance for the end of 2020. The General Fund budget summary and operating transfers are included for your review. Debt Service Funds Levy The Debt Service Fund budget provides funding for scheduled debt principle and interest repayment obligations, as well as ongoing trustee, assessments, arbitrage, and post-issuance compliance fees related to the city's debt. The 2021 debt levy is $206,706 higher than 2020. Ladder One accounts for$268,013 of the debt levy. The Ladder One costs are new expenditures for the 2021 budget. The city's debt shows a decline starting in 2022 in the Financial Plan attached. The preliminary General Fund budget and tax levy will be adopted at your September 21, 2020 city council meeting. Once the preliminary levy is adopted it can be decreased, but it cannot be increased. Councilmember Craig asked how fuel could be cut. Malecha stated we look at historical averages. Councilmember Bernhjelm asked for clarification on the sealcoat funding coming from liquor revenues. Malecha stated it was liquor revenue already earned. Councilmember Donnelly asked for clarification on what the sealcoating account is used for. Public Works Director Gehler clarified that this account is used for a variety of street maintenance projects, particularly mill and overlay projects. Donnelly inquired about the Natural Resources salary reduction. Administrator McKnight stated that the starting salary in the budget was too high and could be reduced. McKnight also clarified that the additional revenue placed on building permits could potentially be taken from fund balance as a way to address the issue of the fund balance level raised by a few councilmembers. Councilmember Hoyt asked how we address the issue of the second year of the budget cycle being extremely high. McKnight stated that either the city needs to start doing some of the one-time projects that keep getting pushed back or we need to remove them from the budget. The preliminary budget will be presented to the city council for consideration on September 21, 2020. Assessment Hearing for the Reassessment of the County Road 50 Water and Sewer Utilities Public Works Director Gehler reminded the city council that they voted to table the County Road 50 reassessment at their last city council meeting so it could be discussed at a work session. Councilmember Craig asked if the way we are addressing this assessment is typical. Gehler stated originally this assessment was placed under the old approach and the reassessment would be done under the new approach. Councilmember Hoyt reviewed the history of the assessment stating that the taxpayers paid $192,000 over time for the project. He would like to keep the original $192,000 assessment on the property and credit it to the SAC and WAC fees once the property develops. This amount should not be prohibitive to the sale of the property. Councilmember Bernhjelm stated that development would occur when it is ready. Hoyt stated that the city should look at all commercial/industrial properties and have assessments to see if they should be eliminated. Councilmember Donnelly stated that is not the approach that is being discussed. Donnelly stated that removing the assessment would have a positive impact on the city. Bernhjelm asked why there was such a large gap of time between the original discussion on this topic and now. Gehler stated that that the pandemic was the primary reason. Donnelly brought up the concerns related to showing the actual benefit test if an assessment is left on the property. Councilmember Craig stated we need to stick with the original approach to reassess the property to zero. Councilmembers discussed various pros and cons to the approach on this issue and impacts on other properties in the city. The consensus of a majority of the city council was to move forward as originally discussed with the reassessment. Vermillion River Crossings Discussion Administrator McKnight shared the Councilmember Hoyt asked to place this item on the agenda so the city council could discuss options to spur development. Councilmember Hoyt stated that the city has options before September 2020 when the current deal with Hy-Vee is set to expire. He knows that they do not need to come to Farmington now. The city has leverage now with the assessment deal and we should contact Hy-Vee so they understand our situation of having no grocery store and minimal public transportation. Hoyt asked if we should contact Hy-Vee to discuss the issue. Councilmember Bernhjelm stated that she works with Hy-Vee in her professional capacity and has discussed the issue of their timeline with their representatives. She stated they will build when they want to build. They understand the market better than any of us do and the market has changed with the pandemic. Hoyt discussed the impact of doing nothing and potentially changing the way we approach city budgets and policies. Councilmember Craig shared that she believes we are growing at a rate where we may see Hy-Vee develop soon. After continued discussion,the direction of the city council was to have staff develop a letter to send to Hy-Vee making clear the city's desire to see them develop as soon as possible. City Owned Property Discussion Administrator McKnight shared that the city has been contacted about the availability of lot the city owns on Second Street. The city obtained the lot 12 years ago through the tax forfeiture process. The city does have the land designated in the downtown redevelopment plan as a future trail area. Councilmembers had thoughts on both options and this issue will continue to be reviewed. Ice Update Administrator McKnight shared that the city has been meeting with the school district and the Farmington Youth Hockey Association on ice needs in the community. Councilmembers Hoyt and Bernhjelm have been part of the meetings along with Parks and Recreation Director Distad and Administrator McKnight. At this point, it looks like if the issue moves forward it will need to be a city led initiative. The meetings will occur with the next scheduled meeting set for October. DCC Funding Task Force Recommendation Administrator McKnight updated the city council on the work of the DCC Funding Task Force. The issue of DCC ownership and funding have been discussed for the past five plus years. As a result of these discussions,the task force was put in place earlier this year and is recommending that the county take over between 50-100%of the fixed costs of the facility. The county is receptive to the idea of continuing these discussions. Councilmember Craig asked what determines the final percentage if we come to an agreement. McKnight stated it would a part of the negotiations if a deal can be worked out. Adjourn Motion by Hoyt,second by Craig,to adjourn the meeting at 7:29 p.m.APIF, motion carried. CITY OF 043o Third St., Farmington, MN 55024 FARMINGTON (s;) 651-28o-6800 ■IIIIII�II�.p� O Farmington M N.gov TO: Mayor, Councilmembers and City Administrator FROM: Randy Distad, Parks and Recreation Director SUBJECT: Approve Contract with Labrash Plumbing and Heating for the Installation of Touchless Faucets and Bottle Filling Stations-Parks DATE: September 21, 2020 INTRODUCTION The City of Farmington received a total allocation of$1,723,785 from CARES Act funding to be used towards COVI D-19 related expenses. DISCUSSION Previously the city council, at its August 3, 2020 meeting, had discussed and directed staff to spend CARES Act funding on COVI D-19 related expenses including the following: • replace the current sink faucets in the restrooms at the Rambling River Center in order to make them touchless faucets • retrofit the drinking fountains at city hall and the maintenance facility to include bottle filling stations Staff solicited quotes from two local plumbing companies who are capable of performing the work associated with completing these projects. Both plumbing companies were allowed to view the project locations and discuss project information with staff. Both plumbing companies submitted a quote for these projects and are shown on the attached tabulation form. Labrash Plumbing and Heating submitted the low quote in the amount of$10,059.00. The projects being completed are directly related to fighting the spread of COVI D-19. BUDGET IMPACT The$10,059.00 that the above projects will cost, will have minimal impact on the amount that city has available to spend from the allocation of funds it received through the CARES Act funding. ACTION REQUESTED Staff is requesting the city council approve the following: • a contract with Labrash Plumbing and Heating, LLC in the amount of$10,059.00 to replace the current Rambling River Center's restroom sink faucets with touchless faucets and retrofit the drinking fountains at city hall and the maintenance facility to include bottle filling stations • authorize the Mayor and City Administrator to sign the contract ATTACHMENTS: Type Description ❑ Backup Material Quote Tabulation Form 2020 RRC Touchless Faucet and Bottle Filling Station Project Quote Tabulation Form Name of Contractor Quote Submitted Labrash Plumbing and Heating $10,059.00 Peine Plumbing and Heating $22,120.00 AGRERME,NT AGREEMENT made this 21" day of September, 2020, between the CITY OF FARMINGTON, a Milmesota municipal corporation ("City"), and LABRASII PLUMBING AND BEATING,LLC a Minnesota corporation("Contractor"). IN CONSIDERATION OF TIE MUTUAL UNDERTAKINGS HEREIN CONTAINED,THE PARTIES AGREE AS FOLLOWS: I. CONTRACT DOCUMENTS. The following documents shall be referred to as the "Contract Documents", all of which shall be taken together as a whole as the contract between the parties as if they were set verbatim and in.full herein: A. This Agreement B. Contractor quote dated August 28,2020 attached.as Exhibit"A." In the event of conflict among the provisions of the Contract Documents, the order in which they are listed above shall control in resolving any such conflicts with Contract Document "A" having the first priority and Contract Document"B"having the last priority. 2. OBLIGATIONS OF THE CONTRACTOR. The Contractor shall provide the goods,services,and perform the work in accordance with the Contract Documents. 3. OBLIGATIONS OF THE CITY. The City shall pay the Contractor in accordance with the bid. 4. SOFTWARE LICENSE. If the equipment provided by the Contractor pursuant to this Contract contains software,including that which the manufacturer may have embedded into the hardware as ail integral part of the equipment, the Contractor shall pay all software licensing fees. The Contractor shall also pay for all software updating fees for a period of one year following cutover. The Contractor shall have no obligation to pay for such fees thereafter. Nothing in the software license or licensing agreement shall obligate the City to pay any additional fees as a condition for continuing to use the software. 5. ASSIGNMENT. Neither party may assign, sublet, or transfer any interest or obligation in this Contract without the prior written consent of the other party, and then only upon such terms and conditions as both parties may agree to and set forth in writing. 6. TIME OF PERFORMANCE. The Contractor shall complete its obligations by November 15,2020. 7. PAYMENT. a. When the obligations of the Contractor have been fulfilled,inspected,azid accepted, the City shall pay the Contractor$10,059.00. Such payment shall be made not later than thirty(30) days after completion,certification thereof,and invoicing by the Contractor. b. No final payment shall be made under this Contract until Contractor has satisfactorily established compliance with the provisions of Minn. Stat, Section 290.92. A certificate of the commissioner shall satisfy this requirement with respect to the Contractor or any subcontractor. g. EXTRA SERVICES. No claim will be honored for compensation for extra services or beyond the scope of this Agreement or the not-to-exceed price for the services identified in the proposal without written submittal by the Contractor, and approval of an amendment by the City, with specific estimates of type, time, and maximum costs, prior to commencement of the work. 9, PROMPT PAYMENT TO SUBCONTRACTORS. Pursuant to Minnesota Statute 471.25, Subdivision 4a, the Contractor must pay any subcontractor within ten (10) days of the Contractor's receipt of payment ftom the City for undisputed services provided by the subcontractor. The Contractor must pay interest of one and one-half percent(1% %)per month or any part of a month to subcontractor on any undisputed amount not paid on time to the subcontractor. The minimum monthly interest penalty payment for an unpaid balance of$100.00 or more is $10.00. For an unpaid balance of less tllazm $100.00, the Contractor shall pay the actual penalty due to the subcontractor. A subcontractor who prevails in a civil action to collect interest penalties from the Contractor shall be awarded its costs and disbursements, including attorney's fees,incurred in bringing the action. 10. WORI0R'S COMPENSATION. If Contractor does public work,time Contractor shall obtain and maintain for the duration of this Contract, statutory Worker's Compensation Insurance and Employer's Liability Insurance as required under the laws of the State of Minnesota. 11. COMPREHENSIVE GENERAL LIABILITY. Contractor shall obtain the following mizniniu m insurance coverage and maintain it at all th-nes throughout the life of the Contract,with the City included as an additional name insured by endorsement: Bodily Injury: $2,000,000 each occurrence $2,000,000 aggregate,products and completed operations Property Damage: $2,000,000 each occurrence $2,000,000 aggregate Products and Completed Operations Insurance shall be maintained for a minimtu�a period of three (3)years after final payment and Contractor shall continue to provide evidence of such coverage to 2 City on an annual basis during the aforementioned period;or if any reason Contractor's work ceases before final payment,for a minimum period of three(3)years from the date Contractor ceases work. Property Damage Liability insurance shall include coverage for the following hazards: X (Explosion) C (Collapse) U (Underground) Contractual Liability(identifying the contract): Bodily Injury. $2,000,000 each occurrence Property Damage: $2,000,000 each occurrence $2,000,000 aggregate Personal Injury,with Employment Exclusion deleted: $2,000,000 aggregate Comprehensive Automobile Liability(owned,non-owned,lured): Bodily Injiuy: $2,000,000 each occurrence $2,000,000 each accident Property Damage: $2,000,000 each occurrence Z2. MINNESOTA GOVERNMENT DATA PRACTICES ACT. Contractor must comply with the Minnesota Government Data Practices Act, Minnesota Statutes Chapter 13, as it applies to (1) all data provided by the City pursuant to this Agreement, and (2) all data, created, collected, received, stored, used, maintained, or disseminated by Contractor pursuant to this Agreement. Contractor is subject to all the provisions of the Minnesota Government Data Practices Act,including but not limited to the civil remedies of Minnesota Statutes Section 13.08,as if it were a government entity. In the event Contractor receives a request to release data, Contractor must immediately notify City. City will give Contractor instructions concerning the release of the data to the requesting party before the data is released. Contractor agrees to defend, indemnify, and hold City, its officials, officers, agents, employees, and volunteers harmless from any claims resulting from Contractor's Officers', agents', city's, partners', employees', volunteers', assigtiees' Or subcontractors' urdawful disclosure and/or use of protected data. The terms of this paragraph shall survive the cancellation or termination of this Agreement. 13. RE CORDS. Contractor shall maintaixn complete and accurate records of expenses involved in the performance of services. 14. WARRANTY. The Contractor guarantees that all new equipment warranties as specified within the bid shall be in Rill force and transferred to the City upon payment by the City. The Contractor shall be bald responsible fox any and all defects in worlcnnanslup, materials, and 3 equipment which may develop in any part of the contracted service,and upon proper notification by the City shall immediately replace, without cost to the City, any such faulty part or parts and damage done by reason of the same in accordance with the bid specifications. The Contractor further warrants to the City that all goods and services furnished under the Contract will be in conformance with Contract Documents and that the goods are of merchantable quality and are fit for the Ilse for which they are sold. This warranty is in addition to any manufactur'er's standard warranty y,and any warranty provided by law. 15. NONDISCRIMINATION. Alt Contractors and subcontractors employed shall comply with all applicable provisions of all federal, state and municipal laws which prohibit discrimination in employmerxt to members of a protected class and all rules and regulations, promulgated and adopted pursuant thereto. The Contractor will include a similar provision in all subcontracts entered into for the performance of this contract, 16. INDEMNITY. The Contractor agrees to defend,hold harmless, and indemnify the City, its officers,agents, and employees, for and against any and all claims, demands, actions, or causes of action, of whatever nature or character, arising fi•om the Consultant's performance of work or services provided for herein. The Contractor shall take all reasonable precautions for the safety of.all employees on the site and shall provide reasonable protection to prevent damage or loss to the property on the site or properties adjacent thereto and to work, materials and equipment under the Contractor's control, 17. W'AIVI+R. In the particular event that either party shall at any time or times waive any breach of this Contract by the other, such waiver shall not constitute a waiver of any other or any succeeding breach of this Contract by either party,whether of the same or any other covenant, condition,or obligation. 18. GOVERNING LAW. The laws of the State of Minnesota govern the interpretation of this Contract. 19.' SEVERABILITY. If any provision,term, or condition of this Contract is found to be or become unenforceable or invalid, it shall not effect the remaining provisions, terms, and conditions of this Contract, runless such invalid or unenforceable provision, term., or condition renders this Contract impossible to perform. Such remaiivng terms acrd conditions of the Contract shall continue in full force and effect and shall continue to operate as the patties'entire contract. 20. ENTIRE AGREEMENT. This Contract represents the entire agreement of the parties and is a final, complete,and all inclusive statement of the terms thereof, and supersedes and terminates any prior agreement(s), understandings, or written or verbal representations made between the parties with respect thereto. 21. TERMINATION. This Agreement may be terminated by the City for any reason or for convenience upon written notice to the Contractor. In the event of termination, the City shall be obligated to the Contractor for payment of amounts due and owing for materials provided or for services performed or furnished to the date and time of termination. 4 Dated: 2020 CITY OF FARMINGTON r By: Todd Larson,Mayor By; avid McKai gbt, it dininistrator Dated:— .C.3 ,202Q CONTRACTOR: LABRASH PLUMBING AND HEATING,LLC By; yan Ifs: y c o n t� s Labrash Phirrtbing&Beating Estimate 306 4th Street Date Estimate estimate#Farmington,MN 55024 8/28/2020 2174 Name/Address City of Farmington 430 Third Street Farmington, 1vlN 55024 Description Rate Total Estimate for the rambling River Center 4)Plumber provided cb ome,battery operated sensor 4"rough un sloan faucets 4)Watts,lead free thermostatic mixing valves 2,786 00 2,786.00 Estimate includes the materials and labor to complete the above scope of work GS l 444-G55S. Thank yout To accept bid or if you have any questions,please call Total $2,786.00 Labrash Plumbing&Heating Estimate 306 4th Street • Farmington,MN 55024 Date Estimate# 8/28/2020 2175 i Name/Address City of Farmington 430 Third Street Farmington, MN 55024 Description Rate Total Estimate for the City Hall Bottle Fillers Lower level single bottle filling station Lower rough in waste and water Hang single filler over existing panel Estimate includes the materials and labor to complete the above scope of work 4,506.00 4,506.00 To accept bid or if you have any questions,please call 651-444-6555. Thank you! Total $4,506.00 Labrash Plumbing&Heating Estimate306 4th Street Farmington,MN 55024 Date Estimate# aq 8/28/2020 2176 Name/Address City of Farmington 430 Third Street Farmington, MN 55024 Description Rate Total Maintenance Facility Bottle filling station,bi-level ADA cooler Change rough in elevation Estimate includes all the materials and labor to complete the scope of work 2,767.00 2,767.00 To accept bid or if you have any questions,please call 651-444-6555. Thank you! Total $2,767.00 CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 1111�11�1�� O Farmington M N.gov TO: Mayor, Councilmembers and City Administrator FROM: Cynthia Muller, Administrative Assistant SUBJECT: Adopt Resolution Approving a Gambling Premise Permit for Farmington Youth Hockey Association-Community Development DATE: September 21, 2020 INTRODUCTION Farmington Youth Hockey Association is requesting a Gambling Premise Permit at The Mug located at 18450 Pilot Knob Road. DISCUSSION Pursuant to state statute and pertinent city code, an organization must first obtain a resolution from the city,granting permission for gambling to occur at a specific location. Farmington Youth Hockey Association is requesting approval to conduct gambling activity at The Mug, 18450 Pilot Knob Road. The appropriate application and fees have been received. BUDGET IMPACT Gambling permit fees are included in the revenue estimates of the 2020 budget. ACTION REQUESTED Adopt the attached resolution approving a Gambling Premise Permit for Farmington Youth Hockey Association at The Mug located at 18450 Pilot Knob Road. ATTACHMENTS: Type Description ❑ Resolution Resolution RESOLUTION NO. R38-20 APPROVING A MINNESOTA LAWFUL GAMBLING PREMISE PERMIT APPLICATION FOR FARMINGTON YOUTH HOCKEY ASSOCIATION 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 21St day of September 2020 at 7:00 p.m. Members Present:Larson, Bernhj elm, Donnelly, Hoyt Members Absent: Craig Member Bernhj elm and Member Hoyt introduced and seconded the following: WHEREAS,pursuant to M.S. 349.166,the State of Minnesota Gambling Board may not issue or renew a Gambling Premise Permit unless the City Council adopts a resolution approving said permit; and, WHEREAS,Farmington Youth Hockey Association has submitted an application for a Gambling Premise Permit to be conducted at 18450 Pilot Knob Road, for Council consideration. NOW,THEREFORE,BE IT RESOLVED by the Farmington City Council that the Gambling Premise Permit for Farmington Youth Hockey Association at 18450 Pilot Knob Road,is hereby approved. This resolution adopted by recorded vote of the Farmington City Council in open session on the 21St day of September 2020. Mayor Attested to theme day of September 2020. City Administrat SEAL CITY OF O Q 430 Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 Farmington MN.gov TO: Mayor, Councilmembers and City Administrator FROM: Jennifer Gabbard, Human Resources Director SUBJECT: Approve Recommendation for Hire Liquor-Human Resources DATE: September 21, 2020 INTRODUCTION The recruitment and selection process for the appointment of a part-time liquor clerk position has been completed. DISCUSSION After a thorough review by the Liquor Operations Office, and the Human Resources Department, a contingent offer of employment has been made to Angie Reichert, subject to ratification by the city council. BUDGET IMPACT The funding for this position is authorized in the 2020 budget. ACTION REQUESTED Approve the appointment of Angie Reichert effective September 21, 2020. CITY OF 0 Q 430 Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 IIIwa O Farmington MN.gov TO: Mayor, Councilmembers and City Administrator FROM: Teah Malecha, Finance Director SUBJECT: Approve Bills - Finance DATE: September 21, 2020 INTRODUCTION Attached is the September 1, 2020 -September 16, 2020 city council check register and recently processed automatic payments for your consideration. DISCUSSION N/A BUDGET IMPACT N/A ACTION REQUESTED Approve the attached payments. ATTACHMENTS: Type Description D Backup Material Council Check Summary 9/1/2020-9/16/2020 R55CKS2 LOGIS600V COUNCIL MEETING SEPT 21 , 2020 CITY OF FARMINGTON 9/16/2020 9:42:50 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 1 9/1/2020 - 9/16/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 152372 9/4/2020 113303 ARTISAN BEER COMPANY 196.80 BEER ORDER 187345 3434357 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 307.40 BEER ORDER 187397 3434306 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 504.20 152373 9/4/2020 108446 ASPEN MILLS,INC. 32.58 UNIFORM ITEMS:MARTIN,R. 187205 260172 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 196.50 UNIFORM ITEMS:ZEIMET,T 187206 260134 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 229.08 152374 9/4/2020 100493 BELLBOY CORPORATION 120.61 LIQUOR SUPPLIES&MIXES ORDER 187381 101910600 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 115.55 IRISH MANOR ORDER 187382 0085539400 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 103.56 LIQUOR SUPPLIES&MIXES ORDER 187387 0101910400 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 157.60 LIQUOR&SPIRITS ORDER 187388 0085539300 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 497.32 152375 9/4/2020 109503 BIFFS,INC 155.00 JUL'20 PRTBLE RNTL-RRP EVENT 187341 W773830 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 215.00 JUL'20 PRTBLE RNTL-LK JUL EVNT 187342 W773829 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 370.00 152376 9/4/2020 114075 BLACKFIRE CREATIVE DESIGNS 252.60 DECALS:MAILBOX,BODY CAM,LOCKR 187426 4398 1050 6450 OUTSIDE PRINTING POLICE ADMINISTRATION 01000 05 660.00 0562 WINDOW TINTING 187430 4543 1051 6230 VEHICLE SUPPLIES&PARTS PATROL SERVICES 01000 05 912.60 152377 9/4/2020 115569 BOURGET IMPORTS,LLC 277.25 WINE ORDER 187371 172351 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 277.25 152378 9/4/2020 114472 BREAKTHRU BEVERAGE MN BEER,LLC 3,939.00 BEER ORDER 187369 1091164604 6100 1405 10 INVENTORY DOWNTOWN LIQUOR OPERATIONS 06100 02 232.00 BEER ORDER 187379 1091164606 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 13,449.35 BEER ORDER 187384 1091164605 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 10,511.55 BEER ORDER 187420 1091162387 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 28,131.90 152379 9/4/2020 114471 BREAKTHRU BEVERAGE MN WINE&SPIRITS 1,823.94 LIQUOR&SPIRITS ORDER 187368 1081172787 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 45.45 WINE ORDER 187370 1081172788 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,103.92 WINE ORDER 187380 1081172790 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,691.74 LIQUOR&SPIRITS ORDER 187385 1081172789 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 5,665.05 152380 9/4/2020 116118 CARLOS CREEK WINERY R55CKS2 LOGIS600V CITY OF FARMINGTON 9/16/2020 9:42:50 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 2 9/1/2020 - 9/16/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 279.00 WINE ORDER 187392 19720 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 279.00 152381 9/4/2020 108428 CDW GOVERNMENT LLC 1,413.55 SURFACE LAPTOP FOR BRUSH VH 186947 ZSR1991 1060 6960 00019 FURNITURE,OFFICE EQUIP,IT FIRE SERVICES 01000 06 82.11 SURFACE PEN FOR BRUSH TRK 186947 ZSR1991 1060 6220 00019 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 40.42 12V LAPT CHARGER FOR BRUSH TRK 186947 ZSR1991 1060 6220 00019 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 106.10 SURFACE KEYBOARD FOR BRUSH TRK 186947 ZSR1991 1060 6220 00019 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 1,642.18 152382 9/4/2020 100025 CINTAS CORP LOC 754 43.83 AUG'20 WEEKLY UNIFORM SERVICES 186745 4057855534 1072 6290 UNIFORMS&CLOTHING STREET MAINTENANCE 01000 08 43.84 AUG'20 WEEKLY UNIFORM SERVICES 186745 4057855534 1090 6290 UNIFORMS&CLOTHING PARK MAINTENANCE 01000 09 3.01- 186745 4057855534 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 43.84 AUG'20 WEEKLY UNIFORM SERVICES 186745 4057855534 6202 6290 UNIFORMS&CLOTHING SEWER OPERATIONS EXPENSE 06200 08 46.85 AUG'20 WEEKLY UNIFORM SERVICES 186745 4057855534 6302 6290 UNIFORMS&CLOTHING SOLID WASTE OPERATIONS 06300 08 43.84 AUG'20 WEEKLY UNIFORM SERVICES 186745 4057855534 6402 6290 UNIFORMS&CLOTHING STORM WATER UTILITY OPERA 06400 08 43.31 AUG'20 WEEKLY UNIFORM SERVICES 186745 4057855534 6502 6290 UNIFORMS&CLOTHING WATER UTILITY EXPENSE 06500 08 43.83 AUG'20 WEEKLY UNIFORM SERVICES 186988 4058488799 1072 6290 UNIFORMS&CLOTHING STREET MAINTENANCE 01000 08 43.84 AUG'20 WEEKLY UNIFORM SERVICES 186988 4058488799 1090 6290 UNIFORMS&CLOTHING PARK MAINTENANCE 01000 09 3.01- 186988 4058488799 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 43.84 AUG'20 WEEKLY UNIFORM SERVICES 186988 4058488799 6202 6290 UNIFORMS&CLOTHING SEWER OPERATIONS EXPENSE 06200 08 46.85 AUG'20 WEEKLY UNIFORM SERVICES 186988 4058488799 6302 6290 UNIFORMS&CLOTHING SOLID WASTE OPERATIONS 06300 08 43.84 AUG'20 WEEKLY UNIFORM SERVICES 186988 4058488799 6402 6290 UNIFORMS&CLOTHING STORM WATER UTILITY OPERA 06400 08 43.31 AUG'20 WEEKLY UNIFORM SERVICES 186988 4058488799 6502 6290 UNIFORMS&CLOTHING WATER UTILITY EXPENSE 06500 08 43.31 AUG'20 WEEKLY UNIFORM SERVICES 187249 4059171993 6502 6290 UNIFORMS&CLOTHING WATER UTILITY EXPENSE 06500 08 43.84 AUG'20 WEEKLY UNIFORM SERVICES 187249 4059171993 6402 6290 UNIFORMS&CLOTHING STORM WATER UTILITY OPERA 06400 08 3.01- 187249 4059171993 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 46.85 AUG'20 WEEKLY UNIFORM SERVICES 187249 4059171993 6302 6290 UNIFORMS&CLOTHING SOLID WASTE OPERATIONS 06300 08 43.84 AUG'20 WEEKLY UNIFORM SERVICES 187249 4059171993 6202 6290 UNIFORMS&CLOTHING SEWER OPERATIONS EXPENSE 06200 08 43.83 AUG'20 WEEKLY UNIFORM SERVICES 187249 4059171993 1090 6290 UNIFORMS&CLOTHING PARK MAINTENANCE 01000 09 43.84 AUG'20 WEEKLY UNIFORM SERVICES 187249 4059171993 1072 6290 UNIFORMS&CLOTHING STREET MAINTENANCE 01000 08 43.84 AUG'20 WEEKLY UNIFORM SERVICES 187332 4059774553 1072 6290 UNIFORMS&CLOTHING STREET MAINTENANCE 01000 08 43.83 AUG'20 WEEKLY UNIFORM SERVICES 187332 4059774553 1090 6290 UNIFORMS&CLOTHING PARK MAINTENANCE 01000 09 3.01- 187332 4059774553 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 43.84 AUG'20 WEEKLY UNIFORM SERVICES 187332 4059774553 6202 6290 UNIFORMS&CLOTHING SEWER OPERATIONS EXPENSE 06200 08 46.85 AUG'20 WEEKLY UNIFORM SERVICES 187332 4059774553 6302 6290 UNIFORMS&CLOTHING SOLID WASTE OPERATIONS 06300 08 43.84 AUG'20 WEEKLY UNIFORM SERVICES 187332 4059774553 6402 6290 UNIFORMS&CLOTHING STORM WATER UTILITY OPERA 06400 08 43.31 AUG'20 WEEKLY UNIFORM SERVICES 187332 4059774553 6502 6290 UNIFORMS&CLOTHING WATER UTILITY EXPENSE 06500 08 1,050.00 152383 9/4/2020 117735 CLEAR RIVER BEVERAGE 458.00 BEER ORDER 187398 548764 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 458.00 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/16/2020 9:42:50 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 3 9/1/2020 - 9/16/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 152384 9/4/2020 100071 COLLEGE CITY BEVERAGE INC 7,925.85 BEER ORDER 187393 729-02326 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 81.60- BEER ORDER CREDIT 187394 729-02328 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 10,751.55 BEER ORDER 187400 729-02325 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 18,595.80 152385 9/4/2020 100030 CORE&MAIN,LP 253.76 HYDRANT WRENCHES(2) 187134 M824170 6502 6950 MACHINERY,EQUIPMENT&TOOLS WATER UTILITY EXPENSE 06500 08 253.76 152386 9/4/2020 117766 CUSTOM REMODELERS 45.00 PART REFND BL PRMT46086 187423 PART REFND BL 1001 4305 BUILDING PERMITS GENERAL FUND REVENUES 01000 01 PRMT46086 45.00 152387 9/4/2020 111645 DALCO ENTERPRISES,INC 710.70 RESTROOM DISINFECTANT CHEMICAL 187034 3655500 1015 6242 00020 CLEANING SUPPLIES CITY HALL 01000 01 710.70 152388 9/4/2020 115062 DISTINCTIVE DESIGN BUILD,LLC 3,000.00 ER 6647 210TH ST W 187422 ER 6647 210TH ST W 4600 2255 DEPOSITS PAYABLE PRIVATE CAPITAL PROJECTS 04600 07 3,000.00 152389 9/4/2020 100270 EMERGENCY MEDICAL PRODUCTS INC 671.05 MEDICAL EQUIPMENT SUPPLIES 186840 2190373 1060 6220 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 671.05 152390 9/4/2020 109931 FACTORY MOTOR PARTS 313.58 BATTERIES FOR 0004 187073 1-6496884 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 59.87 STOCK FILTERS 187073 1-6496884 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 373.45 152391 9/4/2020 100077 FRONTIER COMMUNICATIONS 73.90 SEPT'20 ARENA ALARM LINE 187331 651-463-3016 2502 6411 TELEPHONE/CABLE SERVICES ICE ARENA OPERATIONS EXPE 02500 09 SEPT'20 73.90 152392 9/4/2020 111631 FULL SERVICE BATTERY,INC 219.90 BATTERIES:FLOOR SCRUBBER 187245 0021133 2502 6220 EQUIP SUPPLIES&PARTS ICE ARENA OPERATIONS EXPE 02500 09 219.90 152393 9/4/2020 100044 GRAINGER INC 2,954.72 TCHLSS PAPERTWL DISP(59) 187032 9619558712 1015 6960 00019 FURNITURE,OFFICE EQUIP,IT CITY HALL 01000 01 2,954.72 152394 9/4/2020 109232 HELM ELECTRIC INC 210.00 FIX LIGHT POLE ON 195TH 187319 140078 6602 6505 EQUIPMENT REPAIR/MAINTENANCE STREETLIGHT UTILITY EXPEN 06600 08 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/16/2020 9:42:50 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 4 9/1/2020 - 9/16/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 223.03 REPAIR OUTLETS AT WELLS 3/4 187320 14008B 6502 6505 EQUIPMENT REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 433.03 152395 9/4/2020 100074 HOHENSTEINS INC 260.00 BEER ORDER 187344 215372 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,052.90 BEER ORDER 187396 215373 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,312.90 152396 9/4/2020 100395 HOISINGTON KOEGLER GROUP INC 6,450.00 JUL'20 SVS:ZONING CODE UPDATE 187224 020-010-04 1030 6401 PROFESSIONAL SERVICES PLANNING&ZONING 01000 03 6,450.00 152397 9/4/2020 113417 INDEED BREWING COMPANY,LLC 330.50 BEER ORDER 187377 93082 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 330.50 152398 9/4/2020 107414 JEFFERSON FIRE&SAFETY INC 105.47 TRAINING HOSE ADAPTORS 187203 IN120897 1060 6220 00019 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 105.47 152399 9/4/2020 100031 JIRIK SOD FARMS,INC 40.00 EROSION BLANKET 187322 46068 6502 6255 LANDSCAPING MATERIALS WATER UTILITY EXPENSE 06500 08 40.00 152400 9/4/2020 109846 JJ TAYLOR DISTRIBUTING COMPANY OF MN INC 6,913.60 BEER ORDER 187343 3120834 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 4,783.50 BEER ORDER 187399 3120833 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 11,697.10 152401 9/4/2020 100033 JOHNSON BROTHERS LIQUOR COMPANY 3,621.17 LIQUOR&SPIRITS ORDER 187348 1626093 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,746.78 LIQUOR&SPIRITS ORDER 187349 1626094 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 269.44 WINE ORDER 187350 1626095 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 37.51 MASTER MIXES MARGARITA ORDER 187351 1626096 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,867.57 LIQUOR&SPIRITS ORDER 187352 1626097 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 3,026.72 SVEDKA VODKA ORDER 187353 1626098 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 410.81 WINE ORDER 187354 1626099 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,066.50 WINE ORDER 187357 1626029 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 461.33 WINE ORDER 187358 1626027 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 336.02 LIQUOR&SPIRITS ORDER 187359 1626026 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 41.51 REAL COCO ORDER 187360 1626025 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 529.14 WINE ORDER 187361 1626024 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,256.69 LIQUOR&SPIRITS ORDER 187362 1626023 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,337.80 LIQUOR&SPIRITS ORDER 187363 1626021 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 5.33- AGALIMA SWEET&SOUR CREDIT 187372 112315 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 14.63- RONDIAZ SPICED RUM CREDIT 187373 112314 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/16/2020 9:42:50 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 5 9/1/2020 - 9/16/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept D 14.63- RONDIAZ LEMON RUM CREDIT 187374 112313 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 7.84- HIGH NOON CREDIT 187389 112353 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 416.51- NEW AMSTERDAM VODKA CREDIT 187390 112352 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 258.51 CROWN ROYAL ORDER 187391 1626022 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 15,808.56 152402 9/4/2020 110766 JOHNSON CONTROLS FIRE PROTECTION LP 646.16 CITYHALLALRM MONITORING 187242 21774146 1015 6515 BUILDING REPAIR/MAINTENANCE CITY HALL 01000 01 40.71 1ST ST GARALARM MONITRNG 187243 21774062 6502 6515 BUILDING REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 40.69 1ST ST GAR ALARM MONITRNG 187243 21774062 6402 6515 BUILDING REPAIR/MAINTENANCE STORM WATER UTILITY OPERA 06400 08 2.80- 187243 21774062 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 43.49 1ST ST GARALARM MONITRNG 187243 21774062 6302 6515 BUILDING REPAIR/MAINTENANCE SOLID WASTE OPERATIONS 06300 08 40.69 1ST ST GARALARM MONITRNG 187243 21774062 6202 6515 BUILDING REPAIR/MAINTENANCE SEWER OPERATIONS EXPENSE 06200 08 40.69 1ST ST GAR ALARM MONITRNG 187243 21774062 1090 6515 BUILDING REPAIR/MAINTENANCE PARK MAINTENANCE 01000 09 40.69 1ST ST GARALARM MONITRNG 187243 21774062 1072 6515 BUILDING REPAIR/MAINTENANCE STREET MAINTENANCE 01000 08 890.32 152403 9/4/2020 117763 LEGACY TITLE 315.04 REF UTIL CR@18871 EMBLEM CT 187285 MN11805/58 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 315.04 152404 9/4/2020 100155 METROPOLITAN COUNCIL ENVIRO SERVICES 24.85 JUN'20 PRMT#46095 CANCELLED 187408 AUG'20 SAC FEES 6201 5030 SAC CHARGE RETAINER SEWER OPERATIONS REVENUE 06200 08 273.35- AUG'20 MCES FEES 187408 AUG'20 SAC FEES 6201 5030 SAC CHARGE RETAINER SEWER OPERATIONS REVENUE 06200 08 27,335.00 AUG'20 MCES FEES 187408 AUG'20 SAC FEES 6200 2425 MCES SAC(SWR AVAIL CHG) SEWER OPERATIONS 06200 08 27,086.50 152405 9/4/2020 112331 MIDWEST ELECTRICAL TECHNOLOGIES 2,918.55 JUL'20 ELEC PRMTS PYBLE 187284 JULY'20 ELEC PRMTS1000 2020 CONTRACTS PAYABLE GENERAL FUND BALANCE SHEE 01000 2,918.55 152406 9/4/2020 117764 MINNESOTA TITLE 296.78 REF UTIL CR@5126 187TH ST W 187286 MT-2007-1169-BV/79 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 296.78 152407 9/4/2020 100070 MINNESOTA VALLEY TESTING LABORATORIES 68.00 BAC-T SAMPLE(6)/MTHLY REPORT 186827 1045332 6502 6401 PROFESSIONAL SERVICES WATER UTILITY EXPENSE 06500 08 68.00 152408 9/4/2020 107932 MOOD MEDIA 93.25 SEPT 2020 RADIO SVS-LIQUOR 187402 55620180 6110 6401 PROFESSIONAL SERVICES DOWNTOWN LIQUOR REV&EXP 06100 02 93.25 SEPT 2020 RADIO SVS-LIQUOR 187402 55620180 6115 6401 PROFESSIONAL SERVICES PILOT KNOB LIQUOR 06100 02 186.50 152409 9/4/2020 116942 OMNI BREWING COMPANY,LLC 234.00 BEER ORDER 187383 E-7806 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/16/2020 9:42:50 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 6 9/1/2020 - 9/16/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 234.00 152410 9/4/2020 101254 ORKIN EXTERMINATING,LLC 20.42 JUL'20 PEST CONTROL CMF 187251 199394028/28367911 6502 6515 BUILDING REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 20.67 JUL'20 PEST CONTROL CMF 187251 199394028/28367911 6402 6515 BUILDING REPAIR/MAINTENANCE STORM WATER UTILITY OPERA 06400 08 1.42- 187251 199394028/28367911 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 22.09 JUL'20 PEST CONTROL CMF 187251 199394028/28367911 6302 6515 BUILDING REPAIR/MAINTENANCE SOLID WASTE OPERATIONS 06300 08 20.67 JUL'20 PEST CONTROL CMF 187251 199394028/28367911 6202 6515 BUILDING REPAIR/MAINTENANCE SEWER OPERATIONS EXPENSE 06200 08 20.67 JUL'20 PEST CONTROL CMF 187251 199394028/28367911 1090 6515 BUILDING REPAIR/MAINTENANCE PARK MAINTENANCE 01000 09 20.68 JUL'20 PEST CONTROL CMF 187251 199394028/28367911 1072 6515 BUILDING REPAIR/MAINTENANCE STREET MAINTENANCE 01000 08 107.10 JUL'20 PEST CONTROL CITY HALL 187252 199394473/28379954 1015 6515 BUILDING REPAIR/MAINTENANCE CITY HALL 01000 01 88.52 3RD QT 2020 PEST CONTROL 187294 199394292/28594962 1050 6515 BUILDING REPAIR/MAINTENANCE POLICE ADMINISTRATION 01000 05 319.40 152411 9/4/2020 100290 PAUSTIS&SONS WINE COMPANY 358.00 WINE ORDER 187421 99714 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 179.50 WINE ORDER 187431 99711 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 537.50 152412 9/4/2020 100093 PELLICCI HARDWARE&RENTAL 17.99 FLOOR LEVELING PATCH 186613 K37707/F 1093 6240 BUILDING SUPPLIES&PARTS SENIOR CITIZEN SERVICES 01000 09 53.98 TILE&STONE THINSET ENTRANCE 186615 K37723/F 1093 6240 BUILDING SUPPLIES&PARTS SENIOR CITIZEN SERVICES 01000 09 26.97 MSKNG TAPE AND BATTERIES 186618 K37748/F 1093 6220 EQUIP SUPPLIES&PARTS SENIOR CITIZEN SERVICES 01000 09 14.99 GLUE FOR TILE 186742 37761/F 1093 6240 BUILDING SUPPLIES&PARTS SENIOR CITIZEN SERVICES 01000 09 32.99 SQUEEGEE FOR CLEANING ICE 186743 K37751/F 2502 6242 CLEANING SUPPLIES ICE ARENA OPERATIONS EXPE 02500 09 39.97 GLASS CLEANER 186744 K37761/F 1015 6242 CLEANING SUPPLIES CITY HALL 01000 01 20.00 GLASS CLEANER 186744 K37761/F 1060 6242 CLEANING SUPPLIES FIRE SERVICES 01000 06 .55- 186744 K37761/F 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 39.99 GLASS CLEANER 186744 K37761/F 1072 6242 CLEANING SUPPLIES STREET MAINTENANCE 01000 08 8.00 GLASS CLEANER 186744 K37761/F 1090 6242 CLEANING SUPPLIES PARK MAINTENANCE 01000 09 20.00 GLASS CLEANER 186744 K37761/F 1093 6242 CLEANING SUPPLIES SENIOR CITIZEN SERVICES 01000 09 8.00 GLASS CLEANER 186744 K37761/F 6202 6242 CLEANING SUPPLIES SEWER OPERATIONS EXPENSE 06200 08 8.55 GLASS CLEANER 186744 K37761/F 6302 6242 CLEANING SUPPLIES SOLID WASTE OPERATIONS 06300 08 8.00 GLASS CLEANER 186744 K37761/F 6402 6242 CLEANING SUPPLIES STORM WATER UTILITY OPERA 06400 08 8.00 GLASS CLEANER 186744 K37761/F 6502 6242 CLEANING SUPPLIES WATER UTILITY EXPENSE 06500 08 25.95 2 GAL SPAYER/QT CONTNR(4) 186746 K37817/F 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 7.98 SPONGE FOR TILE 186747 K37831/F 1093 6240 BUILDING SUPPLIES&PARTS SENIOR CITIZEN SERVICES 01000 09 19.99 SAW BLADE FOR TILE 186748 K37848/F 1093 6220 EQUIP SUPPLIES&PARTS SENIOR CITIZEN SERVICES 01000 09 9.47 PNTBRSH/LINERS:DEPOT WAY 186749 K37790/F 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 17.97 PNTBRSH/DROPCLOTH/SHOECOVR 186750 K37792/F 1015 6240 BUILDING SUPPLIES&PARTS CITY HALL 01000 01 8.99 MAGNUM RAFTER SQUARE ALUM 7" 186751 37795/F 1093 6950 MACHINERY,EQUIPMENT&TOOLS SENIOR CITIZEN SERVICES 01000 09 12.99 GROUT FOR TILE 186752 K37791/F 1093 6240 BUILDING SUPPLIES&PARTS SENIOR CITIZEN SERVICES 01000 09 10.49 TAPE MEASURE-35' 186753 K37788/F 1015 6950 MACHINERY,EQUIPMENT&TOOLS CITY HALL 01000 01 4.37 TAPE MEASURE-35' 186753 K37788/F 1060 6950 MACHINERY,EQUIPMENT&TOOLS FIRE SERVICES 01000 06 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/16/2020 9:42:50 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 7 9/1/2020 - 9/16/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D .12- 186753 K37788/F 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 8.75 TAPE MEASURE-35' 186753 K37788/F 1072 6950 MACHINERY,EQUIPMENT&TOOLS STREET MAINTENANCE 01000 08 1.75 TAPE MEASURE-35' 186753 K37788/F 1090 6950 MACHINERY,EQUIPMENT&TOOLS PARK MAINTENANCE 01000 09 4.37 TAPE MEASURE-35' 186753 K37788/F 1093 6950 MACHINERY,EQUIPMENT&TOOLS SENIOR CITIZEN SERVICES 01000 09 .01 TAPE MEASURE-35' 186753 K37788/F 6202 6950 MACHINERY,EQUIPMENT&TOOLS SEWER OPERATIONS EXPENSE 06200 08 1.87 TAPE MEASURE-35' 186753 K37788/F 6302 6950 MACHINERY,EQUIPMENT&TOOLS SOLID WASTE OPERATIONS 06300 08 1.75 TAPE MEASURE-35' 186753 K37788/F 6402 6950 MACHINERY,EQUIPMENT&TOOLS STORM WATER UTILITY OPERA 06400 08 1.75 TAPE MEASURE-35' 186753 K37788/F 6502 6950 MACHINERY,EQUIPMENT&TOOLS WATER UTILITY EXPENSE 06500 08 46.91 PAINTING SUPPLIES DEPOT WAY 186756 K37782/F 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 1.49 WD 40 186757 37911/F 1015 6220 EQUIP SUPPLIES&PARTS CITY HALL 01000 01 .75 WD 40 186757 37911/F 1060 6242 CLEANING SUPPLIES FIRE SERVICES 01000 06 .02- 186757 37911/F 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 1.50 WD 40 186757 37911/F 1072 6220 EQUIP SUPPLIES&PARTS STREET MAINTENANCE 01000 08 .30 WD 40 186757 37911/F 1090 6242 CLEANING SUPPLIES PARK MAINTENANCE 01000 09 .75 WD 40 186757 37911/F 1093 6220 EQUIP SUPPLIES&PARTS SENIOR CITIZEN SERVICES 01000 09 .30 WD 40 186757 37911/F 6202 6220 EQUIP SUPPLIES&PARTS SEWER OPERATIONS EXPENSE 06200 08 .32 WD 40 186757 37911/F 6302 6220 EQUIP SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 .30 WD 40 186757 37911/F 6402 6220 EQUIP SUPPLIES&PARTS STORM WATER UTILITY OPERA 06400 08 .30 WD 40 186757 37911/F 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 6.99 CAULK 186758 K37907/F 1093 6240 BUILDING SUPPLIES&PARTS SENIOR CITIZEN SERVICES 01000 09 8.54 GREASE WHT LITHIUM 10 OZ. 186826 K37833/F 6302 6220 EQUIP SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 10.68 GARDEN HOE,48" 186826 K37833/F 6302 6950 MACHINERY,EQUIPMENT&TOOLS SOLID WASTE OPERATIONS 06300 08 1.24- 186826 K37833/F 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 16.06 13GAL TRASH BAGS 90CT 186971 K38023/F 6110 6242 CLEANING SUPPLIES DOWNTOWN LIQUOR REV&EXP 06100 02 1,214.92 HVAC FILTERS 186982 44202/1' 1015 6220 00019 EQUIP SUPPLIES&PARTS CITY HALL 01000 01 47.96 DEPOT WAY PARK PAINT 186985 37829/F'20 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 65.60 MARKING PAINT AND GLOVES 186987 K37982/F 1090 6254 SIGNS&STRIPING MATERIALS PARK MAINTENANCE 01000 09 9.50 FLOOR FINISH AND SUPPLIES 186989 46608/1' 6502 6240 BUILDING SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 9.50 FLOOR FINISH AND SUPPLIES 186989 46608/1' 6402 6240 BUILDING SUPPLIES&PARTS STORM WATER UTILITY OPERA 06400 08 .65- 186989 46608/1' 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 10.15 FLOOR FINISH AND SUPPLIES 186989 46608/1' 6302 6240 BUILDING SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 9.50 FLOOR FINISH AND SUPPLIES 186989 46608/1' 6202 6240 BUILDING SUPPLIES&PARTS SEWER OPERATIONS EXPENSE 06200 08 23.72 FLOOR FINISH AND SUPPLIES 186989 46608/F 1093 6240 BUILDING SUPPLIES&PARTS SENIOR CITIZEN SERVICES 01000 09 9.50 FLOOR FINISH AND SUPPLIES 186989 46608/F 1090 6240 BUILDING SUPPLIES&PARTS PARK MAINTENANCE 01000 09 47.49 FLOOR FINISH AND SUPPLIES 186989 46608/1' 1072 6240 BUILDING SUPPLIES&PARTS STREET MAINTENANCE 01000 08 23.75 FLOOR FINISH AND SUPPLIES 186989 46608/1' 1060 6240 BUILDING SUPPLIES&PARTS FIRE SERVICES 01000 06 47.50 FLOOR FINISH AND SUPPLIES 186989 46608/F 1015 6240 BUILDING SUPPLIES&PARTS CITY HALL 01000 01 68.97 WASP KILLER AND GARBAGE BAGS 186990 K37962/F 2502 6242 CLEANING SUPPLIES ICE ARENA OPERATIONS EXPE 02500 09 7.99 MARKING PAINT 187009 K37950/F 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 38.45 PAINT/TRAY/ROLLERS 187078 K38019/F 1072 6220 EQUIP SUPPLIES&PARTS STREET MAINTENANCE 01000 08 24.99 EXT CORD:CH TRN RM CMRA 187083 K38076/F 7400 6220 00019 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 34.96 HYDRANT PAINT SUPPLIES 187108 K38083/F 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/16/2020 9:42:50 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 8 9/1/2020 - 9/16/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 111.08 EAR PLUGS 187109 49077/F 1072 6290 UNIFORMS&CLOTHING STREET MAINTENANCE 01000 08 246.00 SANITIZER WIPES/TIDE POWDER 187142 44491/F'20 1060 6242 00019 CLEANING SUPPLIES FIRE SERVICES 01000 06 89.34 PAPER TOWELS/SOAP REFILLS 187199 K38268/F 6115 6242 CLEANING SUPPLIES PILOT KNOB LIQUOR 06100 02 709.92 LINERS FOR BLUE BARRELS 187207 46110/F'20 6302 6950 MACHINERY,EQUIPMENT&TOOLS SOLID WASTE OPERATIONS 06300 08 49.98 CHAIN SAW BLADES 187221 K38180/F 1060 6220 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 36.97 ANCHORS/BITS:DISP INSTALL 187236 K38107/F 1015 6220 EQUIP SUPPLIES&PARTS CITY HALL 01000 01 641.52 HVAC FILTERS CITY BLDGS 187237 47872/F 1015 6240 00019 BUILDING SUPPLIES&PARTS CITY HALL 01000 01 18.98 PAINT ROLLERS&COVERS 187238 K38091/F 1015 6240 BUILDING SUPPLIES&PARTS CITY HALL 01000 01 15.98 HVAC FILTERS CITY BLDGS 187239 K38089/F 1015 6240 BUILDING SUPPLIES&PARTS CITY HALL 01000 01 3.99 INSECTICIDE:WASP/HORNET 187240 K38078/F 1090 6260 CHEMICALS PARK MAINTENANCE 01000 09 3.99 INSECTICIDE:WASP/HORNET 187241 K38079/F 1090 6260 CHEMICALS PARK MAINTENANCE 01000 09 19.98 BATTERIES FOR EQUIPMENT 187244 K38115/1' 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 24.01 CATALYST PENETRT/DRY LUBE SPR 187246 38140/1''20 6302 6220 EQUIP SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 1.54- 187246 38140/F'20 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 9.98 BLADES FOR BATHROOM BASE 187250 K38146/F 2502 6220 EQUIP SUPPLIES&PARTS ICE ARENA OPERATIONS EXPE 02500 09 8.99 BOOT COVER FOR PAINTING RINKS 187253 K38154/F 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 92.92 PAINT SUPPLIES OUTDOOR RINKS 187257 K38257/F 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 11.94 WALL CLEANING PADS 187258 52180/1' 1015 6242 CLEANING SUPPLIES CITY HALL 01000 01 5.97 WALL CLEANING PADS 187258 52180/F 1060 6242 CLEANING SUPPLIES FIRE SERVICES 01000 06 .16- 187258 52180/F 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 11.94 ENTER EXPLANATION 187258 52180/F 1072 6242 CLEANING SUPPLIES STREET MAINTENANCE 01000 08 2.39 WALL CLEANING PADS 187258 52180/F 1090 6242 CLEANING SUPPLIES PARK MAINTENANCE 01000 09 5.97 WALL CLEANING PADS 187258 52180/F 1093 6242 CLEANING SUPPLIES SENIOR CITIZEN SERVICES 01000 09 2.39 WALL CLEANING PADS 187258 52180/F 6202 6242 CLEANING SUPPLIES SEWER OPERATIONS EXPENSE 06200 08 2.55 WALL CLEANING PADS 187258 52180/F 6302 6242 CLEANING SUPPLIES SOLID WASTE OPERATIONS 06300 08 2.39 WALL CLEANING PADS 187258 52180/F 6402 6242 CLEANING SUPPLIES STORM WATER UTILITY OPERA 06400 08 2.39 WALL CLEANING PADS 187258 52180/1' 6502 6242 CLEANING SUPPLIES WATER UTILITY EXPENSE 06500 08 174.94 PAPER TOWELS 187259 52408/F 1015 6242 CLEANING SUPPLIES CITY HALL 01000 01 87.49 PAPER TOWELS 187259 52408/F 1060 6242 CLEANING SUPPLIES FIRE SERVICES 01000 06 2.41- 187259 52408/F 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 174.98 PAPER TOWELS 187259 52408/F 1072 6242 CLEANING SUPPLIES STREET MAINTENANCE 01000 08 35.00 PAPER TOWELS 187259 52408/F 1090 6242 CLEANING SUPPLIES PARK MAINTENANCE 01000 09 87.49 PAPER TOWELS 187259 52408/F 1093 6242 CLEANING SUPPLIES SENIOR CITIZEN SERVICES 01000 09 35.00 PAPER TOWELS 187259 52408/1' 6202 6242 CLEANING SUPPLIES SEWER OPERATIONS EXPENSE 06200 08 37.41 PAPER TOWELS 187259 52408/1' 6302 6242 CLEANING SUPPLIES SOLID WASTE OPERATIONS 06300 08 35.00 PAPER TOWELS 187259 52408/1' 6402 6242 CLEANING SUPPLIES STORM WATER UTILITY OPERA 06400 08 35.00 PAPER TOWELS 187259 52408/F 6502 6242 CLEANING SUPPLIES WATER UTILITY EXPENSE 06500 08 88.94 PAINTAND SUPPLIES 187260 K38302/F 1015 6240 BUILDING SUPPLIES&PARTS CITY HALL 01000 01 9.99 TRAFFIC COUNTER TUBE TAPE 187267 K38086/F 1070 6220 EQUIP SUPPLIES&PARTS ENGINEERING SERVICES 01000 07 2,516.52 PAINTAND SUPPLIE OUTDOOR RINK 187282 46300/F'20 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 4,796.18 PAINT FOR OUTDOOR RINKS 187283 49872/F 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 3.99 WASP/HORNET SPRAY 187318 K38190/F 1076 6220 EQUIP SUPPLIES&PARTS NATURAL RESOURCES 01000 07 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/16/2020 9:42:50 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 9 9/1/2020 - 9/16/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 19.99 BATTERIES FOR SOAP DISPENSERS 187333 K38295/F 1015 6220 EQUIP SUPPLIES&PARTS CITY HALL 01000 01 19.98 MOUNTING GLUE:SOAP DISPENSERS 187335 38292/F 1015 6220 EQUIP SUPPLIES&PARTS CITY HALL 01000 01 3.00 WD40 187336 K38294/F 1015 6220 EQUIP SUPPLIES&PARTS CITY HALL 01000 01 1.48 WD40 187336 K38294/F 1060 6220 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 .04- 187336 K38294/F 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 3.00 WD40 187336 K38294/F 1072 6220 EQUIP SUPPLIES&PARTS STREET MAINTENANCE 01000 08 .60 WD40 187336 K38294/F 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 1.50 WD40 187336 K38294/F 1093 6220 EQUIP SUPPLIES&PARTS SENIOR CITIZEN SERVICES 01000 09 .60 WD40 187336 K38294/F 6202 6220 EQUIP SUPPLIES&PARTS SEWER OPERATIONS EXPENSE 06200 08 .64 WD40 187336 K38294/F 6302 6220 EQUIP SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 .60 WD40 187336 K38294/F 6402 6220 EQUIP SUPPLIES&PARTS STORM WATER UTILITY OPERA 06400 08 .60 WD40 187336 K38294/F 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 21.57 HVAC AIR FILTERS 187337 49397/F 1015 6220 00019 EQUIP SUPPLIES&PARTS CITY HALL 01000 01 997.68 FIELD MARKING PAINT 187340 52326/F 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 29.97 FLOOR CLEANER/RAGS IN A BOX 187403 K38308/F 6110 6242 CLEANING SUPPLIES DOWNTOWN LIQUOR REV&EXP 06100 02 7.99 PAINT ROLLER 187409 K38416/F 2502 6240 BUILDING SUPPLIES&PARTS ICE ARENA OPERATIONS EXPE 02500 09 25.34 TIDE 160 POWDER 187410 K38429/F 1015 6242 CLEANING SUPPLIES CITY HALL 01000 01 12.68 TIDE 160 POWDER 187410 K38429/F 1060 6242 CLEANING SUPPLIES FIRE SERVICES 01000 06 .35- 187410 K38429/F 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 25.35 TIDE 160 POWDER 187410 K38429/F 1072 6242 CLEANING SUPPLIES STREET MAINTENANCE 01000 08 5.07 TIDE 160 POWDER 187410 K38429/F 1090 6242 CLEANING SUPPLIES PARK MAINTENANCE 01000 09 12.68 TIDE 160 POWDER 187410 K38429/F 1093 6242 CLEANING SUPPLIES SENIOR CITIZEN SERVICES 01000 09 5.07 TIDE 160 POWDER 187410 K38429/F 6202 6242 CLEANING SUPPLIES SEWER OPERATIONS EXPENSE 06200 08 5.42 TIDE 160 POWDER 187410 K38429/F 6302 6242 CLEANING SUPPLIES SOLID WASTE OPERATIONS 06300 08 5.07 TIDE 160 POWDER 187410 K38429/F 6402 6242 CLEANING SUPPLIES STORM WATER UTILITY OPERA 06400 08 5.07 TIDE 160 POWDER 187410 K38429/F 6502 6242 CLEANING SUPPLIES WATER UTILITY EXPENSE 06500 08 13,688.88 152413 9/4/2020 100032 PEPSI COLA COMPANY 136.00 POP ORDER 187401 33792157 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 126.20 POP ORDER 187419 33792155 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 262.20 152414 9/4/2020 100034 PHILLIPS WINE AND SPIRITS,INC 300.58 LIQUOR&SPIRITS ORDER 187355 6080787 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 238.04 WINE ORDER 187356 6080788 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 712.40 LIQUOR&SPIRITS ORDER 187364 6080753 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 343.06 WINE ORDER 187365 6080754 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 83.82 ZING ZANG MIXES ORDER 187366 6080755 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 6.47- ZING ZANG BL MARY CREDIT 187375 612447 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1.58- DAILY'S POUCH CREDIT 187376 612446 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,669.85 152415 9/4/2020 103239 RCM SPECIALTIES INC R55CKS2 LOGIS600V CITY OF FARMINGTON 9/16/2020 9:42:50 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 10 9/1/2020 - 9/16/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 96.36 EMULSION 33 GALS 187321 7673 1072 6253 STREET MATERIALS STREET MAINTENANCE 01000 08 96.36 152416 9/4/2020 108826 RED WING,CITY OF 45.64 MAR'20 BAL TIPPING FEES 187234 45204-1 6302 6401 PROFESSIONAL SERVICES SOLID WASTE OPERATIONS 06300 08 45.64 152417 9/4/2020 112561 RICOH USA,INC 865.08 SEPT'20 COPIER LEASES 187299 104030110 1010 6555 RENTAL OF EQUIPMENT ADMINISTRATION 01000 01 22.03 SEPT'20 COPIER FAX CARD LEASE 187299 104030110 1010 6555 RENTAL OF EQUIPMENT ADMINISTRATION 01000 01 887.11 152418 9/4/2020 117727 SAPPHIRE LAKE DEVELOPMENT 60,000.00 ER SAPPHIRE LAKE 2ND 187304 ER SAPPHIRE LAKE 4600 2255 DEPOSITS PAYABLE PRIVATE CAPITAL PROJECTS 04600 07 2ND 60,000.00 152419 9/4/2020 107018 SHAMROCK GROUP 108.07 ICE CUBE ORDER 187395 2536243 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 108.07 152420 9/4/2020 112051 SOUTHERN GLAZER'S OF MN 61.28 WINE ORDER 187346 1987079 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,850.87 LIQUOR&SPIRITS ORDER 187347 1987078 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 165.84 WINE ORDER 187378 1987084 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,296.54 LIQUOR&SPIRITS ORDER 187386 1987083 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 4,374.53 152421 9/4/2020 100379 SPRINT-NEXTEL 28.18 AUG 2020 SOLID WASTE TRACKER 187297 875483313-225 6302 6412 CELLULAR SERVICES SOLID WASTE OPERATIONS 06300 08 1.81- 187297 875483313-225 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 26.37 152422 9/4/2020 100100 STRETCHER'S 15.98 TUKUA VEST NAMETAG 187292 11447119 1052 6290 UNIFORMS&CLOTHING INVESTIGATION SERVICES 01000 05 410.00 CHU GAS MASK 187295 11447574 1051 6290 UNIFORMS&CLOTHING PATROL SERVICES 01000 05 425.98 152423 9/4/2020 100519 TC CONSTRUCTION,INC 3,000.00 ER 6574 210TH ST W 187264 ER 6574 210TH ST W 4600 2255 DEPOSITS PAYABLE PRIVATE CAPITAL PROJECTS 04600 07 3,000.00 ER 6582 210TH ST W 187265 ER 6582 210TH ST W 4600 2255 DEPOSITS PAYABLE PRIVATE CAPITAL PROJECTS 04600 07 6,000.00 152424 9/4/2020 112307 T-MOBILE USA INC 6.67 AUG'20 GPS SERVICE 187303 823329497 AUG'20 6502 6412 CELLULAR SERVICES WATER UTILITY EXPENSE 06500 08 6.66 AUG'20 GPS SERVICE 187303 823329497 AUG'20 6202 6412 CELLULAR SERVICES SEWER OPERATIONS EXPENSE 06200 08 6.66 AUG'20 GPS SERVICE 187303 823329497 AUG'20 6402 6412 CELLULAR SERVICES STORM WATER UTILITY OPERA 06400 08 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/16/2020 9:42:50 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 11 9/1/2020 - 9/16/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 19.99 152425 9/4/2020 116302 TOWN SPORTS,LLC 1,103.73 GAITERS AND FACEMASKS 187293 20200819- 1050 6290 00019 UNIFORMS&CLOTHING POLICE ADMINISTRATION 01000 05 GAITERS/MASKS 1,103.73 152426 9/4/2020 112657 TSI INCORPORATED 218.99 FITTEST SMPLNG PROBE KIT-N95 187202 91239100 1060 6950 00019 MACHINERY,EQUIPMENT&TOOLS FIRE SERVICES 01000 06 218.99 152427 9/4/2020 111267 WATER CONSERVATION SERVICE,INC 403.10 LOCATE WATER LEAK 187305 10644 6502 6401 PROFESSIONAL SERVICES WATER UTILITY EXPENSE 06500 08 403.10 152428 9/4/2020 100334 WINE MERCHANTS 113.51 WINE ORDER 187367 7295608 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 113.51 152429 9/4/2020 113972 YOUNGFIELD HOMES 3,000.00 ER 6695 210TH ST W 187266 ER 6695 210TH ST W 4600 2255 DEPOSITS PAYABLE PRIVATE CAPITAL PROJECTS 04600 07 3,000.00 152430 9/4/2020 100182 ZEE MEDICAL SERVICE COMPANY 102.25 FIRSTAID SUPPLIES 187411 54116653 2502 6240 BUILDING SUPPLIES&PARTS ICE ARENA OPERATIONS EXPE 02500 09 102.25 152431 9/4/2020 100019 ZIEGLER INC 143.74 PARTS FOR 0725 187076 PCO02172472 1072 6220 EQUIP SUPPLIES&PARTS STREET MAINTENANCE 01000 08 11,172.73 GRADER REPAIRS 0725 187140 SW000224656 1073 6505 EQUIPMENT REPAIR/MAINTENANCE SNOW REMOVAL SERVICES 01000 08 11,316.47 152432 9/4/2020 100093 PELLICCI HARDWARE&RENTAL 150.00 15 YR EE REC:HENDRICKSON,M 187064 15 YR EE REC MATT 1011 7420 OTHER HUMAN RESOURCES 01000 04 H 150.00 152433 9/11/2020 114024 APPLE CHEVROLET BUICK-NORTHFIELD 55.15 WINDOW SWITCH FOR 0720 187300 CVW71560 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 224.19 REPAIR LIGHTS ON 3221 187302 CVCS205395 6302 6510 1 OUTSIDE VEHICLE REPAIR/MAINT SOLID WASTE OPERATIONS 06300 08 7.60- 187302 CVCS205395 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 271.74 152434 9/11/2020 113303 ARTISAN BEER COMPANY 656.90 BEER ORDER 187457 3435526 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 130.60 BEER ORDER 187492 3435576 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 787.50 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/16/2020 9:42:50 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 12 9/1/2020 - 9/16/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 152435 9/11/2020 100493 BELLBOY CORPORATION 134.83 LIQUOR SUPPLIES&MIXES ORDER 187477 0101952500 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 333.26 LIQUOR&SPIRITS ORDER 187479 0085660100 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 468.09 152436 9/11/2020 110290 BOLTON&MENK,INC 2,217.50 FAIRHILL 3RD ADD.ENGR.REVIEW 187506 0255635 4600 2256 70206 DEVELOPMENT ESCROWS PRIVATE CAPITAL PROJECTS 04600 07 2,217.50 152437 9/11/2020 114472 BREAKTHRU BEVERAGE MN BEER,LLC 7,079.65 BEER ORDER 187451 1091167061 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 580.00 BEER ORDER 187474 1091167063 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 7,884.00 BEER ORDER 187482 1091167062 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 15,543.65 152438 9/11/2020 114471 BREAKTHRU BEVERAGE MN WINE&SPIRITS 119.26- LIQUOR&SPIRITS CREDIT 187466 2080278501 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 45.45- WINE ORDER CREDIT 187467 2080283143 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 97.45- WINE ORDER CREDIT 187468 2080280404 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 194.90- WINE ORDER CREDIT 187469 2080279349 CR 6100 1405 15 INVENTORY PILOT KNOB LIQUOR OPERATIONS 06100 02 34.45- WINE ORDER CREDIT 187470 2080277342 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 86.95- LIQUOR&SPIRITS CREDIT 187471 2080276788 CR 6100 1405 15 INVENTORY PILOT KNOB LIQUOR OPERATIONS 06100 02 86.95- LIQUOR&SPIRITS CREDIT 187472 2080278872 CR 6100 1405 15 INVENTORY PILOT KNOB LIQUOR OPERATIONS 06100 02 1,971.72 WINE ORDER 187473 1081175652 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,265.80 LIQUOR&SPIRITS ORDER 187484 1081175651 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 65.45 WINE ORDER 187495 1081175650 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 971.44 LIQUOR&SPIRITS ORDER 187496 1081175649 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 3,609.00 152439 9/11/2020 111050 CASTLE ROCK KENNELS INC 140.00 AUG'20 ANIMAL CNTRL BRIDING FEE 187296 27894 1050 6401 PROFESSIONAL SERVICES POLICE ADMINISTRATION 01000 05 140.00 152440 9/11/2020 108428 CDW GOVERNMENT LLC 64.70 SURFACE CASE FOR BRUSH VEHICLE 186946 ZSW9732 1060 6220 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 1,614.10 SURFACE DOCKS(10)TELEWRK USRS 187287 ZTV3379 7400 6220 00019 EQUIP SUPPLIES&PARTS INFORMATION TECHNOLOGY 07400 04 1,678.80 152441 9/11/2020 117735 CLEAR RIVER BEVERAGE 792.00 BEER ORDER 187456 549701 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 792.00 152442 9/11/2020 100071 COLLEGE CITY BEVERAGE INC 13.90- BEER ORDER CREDIT 187461 729-02371 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 12,999.78 BEER ORDER 187463 729-02370 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 5,695.40 BEER ORDER 187489 729-02372 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/16/2020 9:42:50 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 13 9/1/2020 - 9/16/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 18,681.28 — — 152443 9/11/2020 100456 COMMERCIAL ASPHALT COMPANY 216.84- JUL'20 ASPHALT MIX 186778 200731 CR 1072 6253 STREET MATERIALS STREET MAINTENANCE 01000 08 991.22 AUG'20 ASPHALT ORDER 187136 200815 1072 6253 STREET MATERIALS STREET MAINTENANCE 01000 08 774.38 152444 9/11/2020 117768 COMMODITIES CREDIT CORP 1,000.00 ERROR NOT FGTN ACCOUNT 187501 ERROR NOT FGTN 6200 2010 1 ACCOUNTS PAYABLE MANUAL SEWER OPERATIONS 06200 08 ACCOUNT 1,000.00 152445 9/11/2020 100030 CORE&MAIN,LP 160.00 BLUE MARKING FLAGS 187139 M841874 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 160.00 152446 9/11/2020 100147 DAKOTA COUNTY TECHNICAL COLLEGE 650.00 HENDRICKSON/LUTZ PURSUIT TRNG 187499 694015 1051 6470 TRAINING&SUBSISTANCE PATROL SERVICES 01000 05 650.00 152447 9/11/2020 111645 DALCO ENTERPRISES,INC 9,812.40 RSTRM CLEANING EQUIP(3) 187033 3656249 1015 6950 00019 MACHINERY,EQUIPMENT&TOOLS CITY HALL 01000 01 9,812.40 152448 9/11/2020 107008 DISTAD,RANDY 8.30 EXPRS MAIL PMT ELECTRO SPRAYER 187502 20200831-DISTAD 1014 6401 00019 PROFESSIONAL SERVICES COMMUNICATIONS 01000 01 27.60 AUG'20 MILEAGE REIMBURSEMENT 187502 20200831-DISTAD 1090 6485 MILEAGE REIMBURSEMENT PARK MAINTENANCE 01000 09 27.60 AUG'20 MILEAGE REIMBURSEMENT 187502 20200831-DISTAD 1094 6485 MILEAGE REIMBURSEMENT PARK&RECREATION ADMIN 01000 09 63.50 152449 9/11/2020 115062 DISTINCTIVE DESIGN BUILD,LLC 3,000.00 ER 21041 FLETCHER WAY 187504 ER 21041 FLETCHER 4600 2255 DEPOSITS PAYABLE PRIVATE CAPITAL PROJECTS 04600 07 WAY 3,000.00 152450 9/11/2020 100022 FARMINGTON PRINTING INC 110.00 PROPERTY AND INVENTORY FORMS 187427 13663 1050 6450 OUTSIDE PRINTING POLICE ADMINISTRATION 01000 05 110.00 152451 9/11/2020 100027 GREAT LAKES COCA-COLA DISTRIBUTION,LLC 579.28 POP ORDER 187462 3608210998 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 579.28 152452 9/11/2020 100074 HOHENSTEINS INC 1,270.60 BEER ORDER 187458 216551 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 167.50 BEER ORDER 187491 216550 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,438.10 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/16/2020 9:42:50 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 14 9/1/2020 - 9/16/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 152453 9/11/2020 112669 HYDRAULIC COMPONENT REPAIR 623.20 CYLINDER REPAIR FOR 725 187227 10266 1072 6505 EQUIPMENT REPAIR/MAINTENANCE STREET MAINTENANCE 01000 08 623.20 152454 9/11/2020 112416 IMPACT MAILING OF MN,INC 50.66 AUG'20 UB MAIL PREP 187435 148961 6502 6401 PROFESSIONAL SERVICES WATER UTILITY EXPENSE 06500 08 50.67 AUG'20 UB MAIL PREP 187435 148961 6402 6401 PROFESSIONAL SERVICES STORM WATER UTILITY OPERA 06400 08 50.67 AUG'20 UB MAIL PREP 187435 148961 6302 6401 PROFESSIONAL SERVICES SOLID WASTE OPERATIONS 06300 08 50.67 AUG'20 UB MAIL PREP 187435 148961 6202 6401 PROFESSIONAL SERVICES SEWER OPERATIONS EXPENSE 06200 08 243.38 AUG'20 UB BILL POSTAGE 187435 148961 6202 6445 POSTAGE SEWER OPERATIONS EXPENSE 06200 08 243.38 AUG'20 UB BILL POSTAGE 187435 148961 6302 6445 POSTAGE SOLID WASTE OPERATIONS 06300 08 243.38 AUG'20 UB BILL POSTAGE 187435 148961 6402 6445 POSTAGE STORM WATER UTILITY OPERA 06400 08 243.38 AUG'20 UB BILL POSTAGE 187435 148961 6502 6445 POSTAGE WATER UTILITY EXPENSE 06500 08 1,176.19 152455 9/11/2020 117341 INBOUND BREWCO 279.00 BEER ORDER 187476 8037 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 279.00 152456 9/11/2020 111773 INNOVATIVE OFFICE SOLUTIONS,LLC 121.26 PENS,TAPE,MARKERS 187013 IN3068940 1010 6210 OFFICE SUPPLIES ADMINISTRATION 01000 01 121.26 152457 9/11/2020 109846 JJ TAYLOR DISTRIBUTING COMPANY OF MN INC 4,796.46 BEER ORDER 187464 3120878 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,956.70 BEER ORDER 187493 3120879 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 7,753.16 152458 9/11/2020 100033 JOHNSON BROTHERS LIQUOR COMPANY 33.51 AGALIMA MARGARITA ORDER 187441 1631204 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,548.99 LIQUOR&SPIRITS ORDER 187442 1631202 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 4,337.38 LIQUOR&SPIRITS ORDER 187443 1631205 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,448.76 WINE ORDER 187444 1631207 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 3,846.32 SVEDKA VODKA ORDER 187445 1631206 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 5,676.28 WINE ORDER 187483 1631203 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 3,267.62 LIQUOR&SPIRITS ORDER 187485 1631208 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 708.92 WINE ORDER 187486 1631209 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 22,867.78 152459 9/11/2020 100121 LEAGUE OF MINNESOTA CITIES 18,839.00 LMC 2021 DUES 187433 326462 1005 6460 MEMBER DUES&LICENSURE LEGISLATIVE CONTROL 01000 01 18,839.00 152460 9/11/2020 100354 LEAGUE OF MN CITIES INSURANCE TRUST 475.00 CLAIM 106162 BURGOYNE 187290 6080 7100 6430 INSURANCE DEDUCTIBLE INSURANCE 07100 02 475.00 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/16/2020 9:42:50 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 15 9/1/2020 - 9/16/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept D 152461 9/11/2020 107747 M.AMUNDSON LLP 1,034.00 CIGARETTES&POP ORDER 187475 307341 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,005.35 CIGARETTES&POP ORDER 187494 307342 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 2,039.35 152462 9/11/2020 100063 MACQUEEN EQUIPMENT,INC 1,316.46 RAPID RAIL SWITCHES(6) 187110 P29286 6302 6230 VEHICLE SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 84.68- 187110 P29286 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 362.63 CONNECTORS FOR 3212 187112 P29344 6302 6230 VEHICLE SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 23.33- 187112 P29344 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 1,192.66- RTRN:HD LIMIT SWITCH 187247 P29467 CR 6302 6230 VEHICLE SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 76.72 187247 P29467 CR 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 455.14 152463 9/11/2020 112843 MINNESOTA MAYORS ASSOCIATION 30.00 2021 MAYORS ASSOCIATION DUES 187437 MMA DUES SEPT'20 1005 6460 MEMBER DUES&LICENSURE LEGISLATIVE CONTROL 01000 01 30.00 152464 9/11/2020 100070 MINNESOTA VALLEY TESTING LABORATORIES 73.50 BAC-T SAMPLE(7) 187106 1046408 6502 6401 PROFESSIONAL SERVICES WATER UTILITY EXPENSE 06500 08 73.50 152465 9/11/2020 101249 MULLER,CYNTHIA 57.87 AUG'20 MILEAGE 187434 20200818-MULLER 1013 6485 MILEAGE REIMBURSEMENT ELECTIONS 01000 01 57.87 152466 9/11/2020 102644 NORTHERN SAFETY TECHNOLOGY,INC 493.03 #F0303 LAPT MNT:BLDG INSP 187082 50863 5602 6220 EQUIP SUPPLIES&PARTS GEN CAPITAL EQUIP FUND EX 05600 493.03 152467 9/11/2020 101254 ORKIN EXTERMINATING,LLC 107.10 AUG'20 PEST CONTROL CITY HALL 187261 200672667/28379954 1015 6515 BUILDING REPAIR/MAINTENANCE CITY HALL 01000 01 20.68 AUG'20 PEST CONTROL CMF 187334 200672222/28367911 1072 6515 BUILDING REPAIR/MAINTENANCE STREET MAINTENANCE 01000 08 20.67 AUG'20 PEST CONTROL CMF 187334 200672222/28367911 1090 6515 BUILDING REPAIR/MAINTENANCE PARK MAINTENANCE 01000 09 20.67 AUG'20 PEST CONTROL CMF 187334 200672222/28367911 6202 6515 BUILDING REPAIR/MAINTENANCE SEWER OPERATIONS EXPENSE 06200 08 20.67 AUG'20 PEST CONTROL CMF 187334 200672222/28367911 6302 6515 BUILDING REPAIR/MAINTENANCE SOLID WASTE OPERATIONS 06300 08 20.67 AUG'20 PEST CONTROL CMF 187334 200672222/28367911 6402 6515 BUILDING REPAIR/MAINTENANCE STORM WATER UTILITY OPERA 06400 08 20.42 AUG'20 PEST CONTROL CMF 187334 200672222/28367911 6502 6515 BUILDING REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 230.88 152468 9/11/2020 100290 PAUSTIS&SONS WINE COMPANY 122.25 WINE ORDER 187480 99982 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 114.25 WINE ORDER 187481 99984 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 155.50 WINE ORDER 187497 99981 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 114.25 WINE ORDER 187498 99983 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/16/2020 9:42:50 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 16 9/1/2020 - 9/16/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept D 506.25 152469 9/11/2020 100093 PELLICCI HARDWARE&RENTAL 49.98 CHAIN SAW BLADES-GUARDS 187500 K38077/F 1060 6250 OTHER SUPPLIES&PARTS FIRE SERVICES 01000 06 6.99 WIPES FOR TRUCKS 187509 K38366/F 1031 6230 VEHICLE SUPPLIES&PARTS BUILDING INSPECTIONS 01000 07 56.97 152470 9/11/2020 100034 PHILLIPS WINE AND SPIRITS,INC 1,945.40 LIQUOR&SPIRITS ORDER 187446 6084203 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 603.40 WINE ORDER 187447 6084204 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 157.33 WINE ORDER 187448 6084205 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,706.13 152471 9/11/2020 113896 PRO HYDRO-TESTING LLC 444.00 SCBA BOTTLE TESTING 187487 103587 1060 6505 EQUIPMENT REPAIR/MAINTENANCE FIRE SERVICES 01000 06 444.00 152472 9/11/2020 100415 RECYCLING ASSOCIATION OF MINNESOTA 300.00 MEMBER DUES:LARSON,L. 187079 510777 6302 6460 MEMBER DUES&LICENSURE SOLID WASTE OPERATIONS 06300 08 300.00 152473 9/11/2020 114619 RED BULL DISTRIBUTION COMPANY,INC 117.50 RED BULL ORDER 187488 K-37081387 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 117.50 152474 9/11/2020 107018 SHAMROCK GROUP 72.75 ICE CUBE ORDER 187450 2542691 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 68.79 ICE CUBE ORDER 187453 2543083 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 46.72 ICE CUBE ORDER 187454 2540717 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 36.53 ICE CUBE ORDER 187455 2542692 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 123.13 ICE CUBE ORDER 187459 2540316 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 71.83 ICE CUBE ORDER 187460 2543080 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 135.02 ICE CUBE ORDER 187490 2543849 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 554.77 152475 9/11/2020 108220 SOUTH METRO RENTAL INC 130.25 CHAIN SAW SUPPLIES 187107 107853 1076 6220 EQUIP SUPPLIES&PARTS NATURAL RESOURCES 01000 07 130.25 152476 9/11/2020 112051 SOUTHERN GLAZER'S OF MN 5,893.86 LIQUOR&SPIRITS ORDER 187452 1989587 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 10,358.30 LIQUOR&SPIRITS ORDER 187465 1989591 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 16,252.16 152477 9/11/2020 100519 TC CONSTRUCTION,INC 3,000.00 ER 6622 UPPER 210TH ST W 187503 ER 6622 UPPER 4600 2255 DEPOSITS PAYABLE PRIVATE CAPITAL PROJECTS 04600 07 210TH ST W R55CKS2 LOGIS600V CITY OF FARMINGTON 9/16/2020 9:42:50 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 17 9/1/2020 - 9/16/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept D 3,000.00 152478 9/11/2020 108808 VINOCOPIA,INC 279.50 WINE ORDER 187478 0262883-IN 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 279.50 152479 9/11/2020 100334 WINE MERCHANTS 582.55 WINE ORDER 187449 7296511 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 582.55 20200901 9/1/2020 116053 109 ELM,LLC 12,394.58 SEPT-20 DT LIQUOR STORE RENT 186763 SEPTEMBER 2020 6110 6556 BUILDING RENTAL DOWNTOWN LIQUOR REV&EXP 06100 02 12,394.58 20200902 9/2/2020 114654 INVOICE CLOUD 579.18 JUL'20 PAYMENT FEES 187407 819-20207 6202 6545 PYMT PROCESSING FEES SEWER OPERATIONS EXPENSE 06200 08 579.18 JUL'20 PAYMENT FEES 187407 819-20207 6302 6545 PYMT PROCESSING FEES SOLID WASTE OPERATIONS 06300 08 579.18 JUL'20 PAYMENT FEES 187407 819-20207 6402 6545 PYMT PROCESSING FEES STORM WATER UTILITY OPERA 06400 08 579.16 JUL'20 PAYMENT FEES 187407 819-20207 6502 6545 PYMT PROCESSING FEES WATER UTILITY EXPENSE 06500 08 2,316.70 20200903 9/2/2020 112399 DEARBORN LIFE INSURANCE COMPANY 1,154.60 SEPT-20 STD INSURANCE PREMIUMS 187417 019839-1 SEPT'20 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 1,154.60 20200904 9/2/2020 115445 HEALTH PARTNERS 80,442.50 SEPT'20 HEALTH INSURANCE 187425 99031871 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 80,442.50 20200905 9/2/2020 100394 XCEL ENERGY 41.67 JUL'20 ELEC DOWNTOWN ST LTS 186828 51-4874005-0 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 JULY'20 4,346.30 JUL'20 ELEC WELL#1 &3 186828 51-4874005-0 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 JULY'20 63.27 JUL'20 ELEC LIFT STATIONS 186828 51-4874005-0 6202 6422 ELECTRIC SEWER OPERATIONS EXPENSE 06200 08 JULY'20 57.33 JUL'20 ELEC TRAFFIC SIGNAL 186828 51-4874005-0 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 JULY'20 137.86 JUL'20 ELEC ROUNDABOUT 186828 51-4874005-0 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 JULY'20 15.78 JUL'20 ELEC CITY GARAGE 186828 51-4874005-0 6202 6422 ELECTRIC SEWER OPERATIONS EXPENSE 06200 08 JULY'20 129.72 JUL'20 ELEC CITY GARAGE 186828 51-4874005-0 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 JULY'20 12.27 JUL'20 ELEC CITY GARAGE 186828 51-4874005-0 6302 6422 ELECTRIC SOLID WASTE OPERATIONS 06300 08 JULY'20 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/16/2020 9:42:50 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 18 9/1/2020 - 9/16/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept D 3.51 JUL'20 ELEC CITY GARAGE 186828 51-4874005-0 6402 6422 ELECTRIC STORM WATER UTILITY OPERA 06400 08 JULY'20 5.26 JUL'20 ELEC CITY GARAGE 186828 51-4874005-0 1072 6422 ELECTRIC STREET MAINTENANCE 01000 08 JULY'20 8.77 JUL'20 ELEC CITY GARAGE 186828 51-4874005-0 1090 6422 ELECTRIC PARK MAINTENANCE 01000 09 JULY'20 6,705.97 JUL'20 ELEC NON-METER ST LTS 186828 51-4874005-0 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 JULY'20 11,527.71 20200906 9/8/2020 100085 DAKOTA ELECTRIC ASSOCIATION 35.66 JUL'20 ELEC TUNNEL LIGHT 186759 200005468327 1090 6422 ELECTRIC PARK MAINTENANCE 01000 09 JULY'20 1,844.37 JUL-20 ELEC PK LIQ STORE 186764 200003759891 6115 6422 ELECTRIC PILOT KNOB LIQUOR 06100 02 JULY'20 5.15 JUL'20 ELEC CIV DEF SIREN 186769 200001982271 1054 6422 ELECTRIC EMERGENCY MGMT SERVICES 01000 05 JULY'20 5.15 JUL'20 ELEC CIV DEF SIREN 186770 200002260958 1054 6422 ELECTRIC EMERGENCY MGMT SERVICES 01000 05 JULY'20 3,568.23 JUL'20 ELEC WELL#8 186780 200004199709 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 JULY'20 2,666.82 JUL'20 ELEC WELL#6 186781 200001550151 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 JULY'20 2,527.63 JUL-20 ELEC WELL#4 186782 200001318526 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 JULY'20 24.50 JUL'20 ELEC DAISY KNOLL TOWER 186783 200001318518 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 JULY'20 2,472.99 JUL'20 ELEC WELL#7 186784 200003490737 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 JULY'20 133.64 JUL'20 ELEC VERM GROVE LS 186785 200003215779 6202 6422 ELECTRIC SEWER OPERATIONS EXPENSE 06200 08 JULY'20 163.21 JUL'20 ELEC 195TH WATER TOWER 186786 200002587095 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 JULY'20 3,812.39 JUL'20 ELEC WELL#5 186787 200002785533 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 JULY'20 6,284.85 JUL-20 ELEC 9TH ST STREET LTS 186788 200001038421 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 JULY'20 584.45 JUL'20 ELEC FIRE STATN#2 187143 200003971959 1060 6422 ELECTRIC FIRE SERVICES 01000 06 JULY'20 24,129.04 20200907 9/8/2020 108980 MINNESOTA ENERGY RESOURCES CORPORATION 18.00 AUG'20 GAS 208TH ST WARM HOUSE 187254 0506537581-AUG'20 1090 6423 NATURAL GAS PARK MAINTENANCE 01000 09 R55CKS2 LOGIS600V CITY OF FARMINGTON 9/16/2020 9:42:50 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 19 9/1/2020 - 9/16/2020 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept D 18.00 Report Totals 514,162.83 APPROVALS: LARSON BERNHJELM CRAIG DONNELLY <11�rHOYT CITY OF 0 Q 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 ®Yryr� O Farmington M N.gov TO: Mayor, Councilmembers and City Administrator FROM: Katy Gehler, Public Works Director/City Engineer SUBJECT: Reassessment of the County Road 50 Water and Sewer Utilities DATE: September 21, 2020 INTRODUCTION The City Council has discussed this item at three different meetings and held a public hearing at the September 8, 2020 meeting. The city council is being asked to consider adoption of the assessment as presented in the attached resolution. The city council item from the September 8th agenda is attached for reference. DISCUSSION To complete the reassessment process,the city must follow Minnesota State Statute 429 which details the steps cities must follow when utilizing assessments. In this case,the city must call for an assessment hearing (public hearing on the assessment amount) by resolution, provide a 14-day notice,and hold the assessment hearing before acting on the proposed assessment. The City Council adopted Resolution 33-20 on August 3,2020 calling for the assessment hearing on September 8,2020. Notice was provided to the property owner on August 12,2020 and it was published in the city's official paper on August 21,2020 meeting the public notice requirements. The public hearing was held on September 8,2020 and there were no public comments or objections. BUDGET IMPACT The city has not planned or programmed the use of the assessments due to the uncertainty of the timing of deferment. Any amounts due in debt payments from the original project have long been satisfied.The city will collect the full development fees as part of the future development of the property which cover the property's "buy-in" to capacity of the overall utility systems. ACTION REQUESTED The city council is asked to consider adoption of the attached resolution reassessing the costs associated with the County Road 50 trunk water and sewer. ATTACHMENTS: Type Description ❑ Resolution Resolution Adopting Reassessment ❑ Backup Material Sept. 8th Agenda Report RESOLUTION NO. R39-20 A RESOLUTION ADOPTING THE REASSESSMENT OF THE COUNTY ROAD 50 WATER AND SEWER UTILITIES Pursuant to due call and notice thereof, a regular meeting of the City Council of the City of Farmington was held at City Hall of said city on the 21st day of September, 2020 at 7:00 PM. Members present: Larson, Bernhj elm, Donnelly, Hoyt Members absent: Craig Member Bernhj elm and Member Donnelly Introduced and seconded the following resolution: WHEREAS, pursuant to proper notice duly given as required by law, the council has met and heard and passed upon all objections to the proposed reassessment of the assessments previously levied on properties in conjunction with Improvements No.82-5 and 89-5,constructing trunk utilities under County Road 50 between Akin Road and Pilot Knob Road. NOW THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF FARMINGTON, MINNESOTA: 1. The proposed reassessment for the following parcel: Property ID: 14-03600-33-010 Owner: DONALD L PETERSON FAMILY LTD PTNSHP Owner Address: 14194 GARLAND AVE APPLE VALLEY MN 55124 Reassessment Amount: $0.00 is hereby accepted and shall constitute the special assessment against the land named therein, and each tract of land included is hereby found to be benefited by the proposed improvement in the amount of the assessment levied against it. 2. Such assessment shall be payable in equal annual installments extending over a period of one year, the first of the installments to be payable on or before the first Monday in January 2020, and shall bear interest at the rate of 0 percent per annum from the date of the adoption of this assessment resolution.To the first installment shall be added interest on the entire assessment from the date of this resolution until December 31, 2020. To each subsequent installment, when due, shall be added interest for one year on all unpaid installments. 3. The owner of any property so assessed may, at anytime prior to certification of the assessment to the county auditor, pay the whole of the assessment on such property, with interest accrued to the date of payment,to the city treasurer,except that no interest shall be charged if the entire assessment is paid within 30 days from the adoption of this resolution; and he/she may, at any time thereafter, pay to the city treasurer the entire amount of the assessment remaining unpaid,with interest accrued to December 31 of the year in which such payment is made.Such payment must be made before November 15 or interest will be charged through December 31 of the next succeedingyear. 4. The clerk shall forthwith transmit a certified duplicate of this assessment to the county auditor to be extended on the property tax lists of the county. Such assessments shall be collected and paid over in the same manner as other municipal taxes. Adopted by the council this 21st day of September, 2020. �fodarson, ayor d L Attested to the cel day of September 2020. bzvl/d McKnight, Ci A inistrator CITY OF 0 43o Third St.,Farmington,MN 55024 FARMINGTO N 651-28o-6800 FarmingtonMN.gov TO: Mayor,Councilmembers and City Administrator FROM: Katy Gehler,Public Works Director/City Engineer SUBJECT: CR 50 Utility Reassessment DATE: August 3,2020 INTRODUCTION I n the late 80s the city completed two projects to extend water and sanitary sewer trunk infrastructure along CR 50 from Akin Road to Pilot Knob. These trunk utilities helped to facilitate the development of the industrial park and provide future service to the surrounding areas.The cost of the improvement was assessed to benefiting properties.Areas within the first phase of the I ndustrial Park and Northern Natural Gas were assessed as well as agricultural areas south of CR 50.Given the green acres status of the southern properties,the assessments were deferred until development occurred while continuing to accrue interest at a rate over 8%. There is one parcel from the original assessment rolls that is continuing to accrue interest on a deferred basis.This parcel is 80-acres located west of the Vermillion River Crossings development and was assessed a total of$192,000 for both projects. Given the time that has passed and the continued accrual of interest,the current amount of the assessment,principal and interest,is$682,000 that will be due upon sale or development of the parcel.This amount has raised concerns when put in context with other fees that are charged with development.For this 80-acre parcel,area charges for sewer and water that are paid at the time of platting would be on the order of$500,000. Combined,the fees prohibit development of this parcel. DISCUSSION At a work session last summer staff discussed how the city has funded trunk utility projects in the past that included the use of an area-wide assessment whereas today the city incorporates the cost of these in availability charges(SAC and WAC fees)collected as part of the development contract. Options were discussed to address the large assessments on this parcel that included adjustment to the current assessment through the 429 assessment process,waiver of development fees or a combination thereof.General consensus was to reassess to waive the assessment and collect the standard development fees as development occurs. This options relieves the significant financial burden on the parcel at the time of development,allows the city to collect amounts needed to support the development of these parcels while managing challenges that can be associated with assessments and providing consistency in how the city completes development. To complete the reassessment process,the city must follow State Statute 429 which details the process when utilizing assessments. I n this case, the city must call for an assessment hearing(public hearing on the assessment amount)by resolution,provide a 14-day notice,and hold the assessment hearing before acting on the proposed assessment. BUDGET IMPACT The city has not planned or programmed the use of the assessments due to the uncertainty of the timing of deferment. Any amounts due in debt payments from the original project have long been satisfied. The city will collect development fees as part of the ACTION REQUESTED The council is asked to adopt the attached resolution as part of the consent agenda setting the assessment hearing date for September 8,2020 at 7 PM during the regularly scheduled council meeting. CITY OF O Q 430 Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 Farmington M N.gov TO: Mayor, Councilmembers and City Administrator FROM: Teah Malecha, Finance Director SUBJECT: Preliminary 2021 General Fund Budget and Tax Levy DATE: September 21, 2020 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 2021 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 2021 General Fund budget and tax levy at work sessions in May, July, August, and September.The proposed budget and tax levy are shown below. 2020 Budget 2021 Proposed Increase Budget (Decrease) Revenues $3,411,161 $3,298,344 (3.31)% Expenditures 13,642,352 13,832,464 1.39% Fiscal Disparities 2,294,024 2,277,659 (0.71)% General Fund Levy 7,937,167 8,256,461 4.02% Debt Levy 2,805,387 3,012,093 7.37% Net Tax Levy $10,742,554 $11,268,554 4.90% General Fund Revenues COVI D-19 has created challenging times for many businesses but also for the city. Some areas that have seen a decrease in revenue due to COVI D-19 are park and recreation, the Rambling River Center, and liquor licensing as part of the General Fund. The reduction is predicted to continue into 2021 resulting in lower revenue receipts rather than the typical annual increase shown in the budget.Through conservative budgeting there is an anticipated decrease in revenue of$112,817. The General Fund has revenues outside of the tax levy.These revenues come from a variety of sources shown below. 2020 Budget 2021 Proposed Increase Budget (Decrease) Licenses and Permits $473,115 $517,076 9.29% I ntergovernmental Revenue 922,294 667,912 (27.58)% Charge for Service 565,802 576,197 1.84% Fines and Forfeitures 49,000 49,000 0.00% I nvestment I ncome 38,800 29,100 (25.00)% Miscellaneous 54,580 79,370 45.42% Transfers In 1,307,570 1,379,689 5.52% Total Revenues 3,411,161 3,298,344 (3.31)% Revenue items of note in the draft 2021 budget: • Permit revenues are projected to increase by $47,691. They were initially anticipated to decline due to COVI D-19, but have remained steady. • Local Government Aid received from the State of Minnesota will decrease by$228,800 from $334,387 in 2020 to$105,587 in 2021. • A reduction of$31,000 in MSA maintenance is anticipated for 2021. • Investment income has been decreased based upon the city's portfolio. Using conservative budgeting,the city only accounts for investments that are non-callable in the next budget year.This amount is the General Fund's portion of the investment income and does not reflect all of the income received. • Miscellaneous revenue includes an increase to rental income and other items that may occur throughout the year and are unaccounted for in other areas. General Fund Expenditures There have been many reviews and revisions in an effort to lower the overall levy increase.The proposed 2021 expenditures are summarized below. 2020 Budget 2021 Proposed Increase Budget (Decrease) Administration $907,162 $889,300 (1.97)% Human Resource 349,226 361,658 3.56% Dakota Broadband 24,489 37,500 53.13% Finance& Risk Management 778,889 776,287 (0.33)% Police 4,677,813 4,853,870 3.76% Fire 1,445,410 1,441,226 (0.29)% Community Development 1,014,867 1,007,849 (0.69)% Engineering 794,635 813,895 2.42% Municipal Services 1,439,078 1,511,187 5.01% Parks & Recreation 1,278,576 1,317,341 3.03% Transfers Out 932,207 822,351 (11.78)% Total Expenditures $13,642,352 $13,832,464 1.39% 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.The union contracts were approved for 2019 through 2021 and include a three percent wage increase each year. Human Resources completed an RFP process for staff health insurance and was successful resulting in over $100,000 in savings that impacts the General Fund. 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. The transfers out are comprised of the LGA and tax levy. Those fund the public safety equipment, trail maintenance, EDA, and building maintenance among many other items. A detailed break-down of the transfers has been included as a separate exhibit in your packet. Fiscal Disparities This is a metro wide program that is used to balance the development of commercial and industrial growth through the region.The city has received a preliminary estimate of the final number which includes a decrease of$16,365. Debt Levy The Debt Service Funds budget provides funding for scheduled debt principle 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 I nterfund loans.The 2021 debt levy is 7.37 percent higher than the 2020 debt levy. The increase in debt is due to the purchase of Ladder One that will be arriving in early 2021. Detail on the debt levy obligations are included with this memo. Additional Notes There are still a number of items that are unfunded or underfunded that the city council is aware of including: • Pavement Management • Trail Maintenance • Building Maintenance Projects • Fleet Replacements The estimated market value of the average residential home in Farmington increased 6.39 percent from $268,723 in 2019 to$285,906 in 2020.The increase is lower than the 6.42 percent increase from $253,204 in 2018 to$268,723 in 2019. Keep in mind the values are one year behind and these are payable 2021 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 2021 preliminary tax levy as proposed • Set the public input meeting prior to the adoption of the final 2021 budget and tax levy for Monday, December 7, 2019 at 7:00 p.m. ATTACHMENTS: Type Description ❑ Resolution 2021 Preliminary Levy Resolution ❑ Backup Material 2021 General Fund Budget Summary ❑ Backup Material 2021 General Fund Revenue Summary ❑ Backup Material 2021 General Fund Expenditure Summary ❑ Backup Material 2021 Debt Levy ❑ Backup Material 2021 Operating Transfers RESOLUTION NO. R 4 0-2 0 A RESOLUTION APPROVING THE 2020 PROPOSED TAX LEVY COLLECTIBLE IN 2021 Pursuant to due call and notice thereof, a regular meeting of the City Council of the city of Farmington was held at the Farmington City Hall on the 21"day of September 2020 at 7:00 p.m. Members Present: Larson, Bernhj elm, Donnelly, Hoyt Members Absent: Craig Member Bernhj elm and Member Hoyt 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, 2020; and WHEREAS, the City Council of the City of Farmington, Minnesota is in receipt of the proposed 2021 revenue and expenditure budget. WHEREAS, the City Council shall use existing City revenues to meet the annual debt obligations for 2013A GO Improvement Refunding Bonds $56,025; thereby reducing the total debt levy issued and collected from property taxes of$443,000. WHEREAS,the City Council shall use existing City revenues to meet the annual debt obligations for 2016B GO Capital Improvement Plan Refunding Bonds $30,385; thereby reducing the total debt levy issued and collected from property taxes of$635,000. NOW, THEREFORE, BE IT RESOLVED by the Mayor and City Council of the City of Farmington that the following sums of money be levied in 2020, collectible in 2021, upon the taxable property in said City of Farmington for the following purposes: General Fund $10,534,120 Debt Levy + $3,012,093 Gross Levy $13,546,213 Fiscal Disparities - $2,277,659 Net Tax Levy $11,268,554 This resolution was adopted by recorded vote of the Farmington City Council in open session on the 21"day of September 2020. odd Larson, Mayor Attested to on the v?/ day of September 2020. C C.� David McKnight, i A inistrator SEAL 2021 BUDGET Summary of Debt Service levy to be attached and become part of this resolution. Fund Project Levy Amount 3091 2013A GO Improvement Refunding Bond $443,000 3093 2015A GO Improvement Bond $293,500 3094 2016A GO Refunding Bond $574,327 3136 2016B GO Refunding Bond $635,000 3138 2019A GO Street Reconstruction Bond $231,000 3139 2020A GO Equipment Certificates $268,013 Total Bond Financing $2,444,840 3130 2005C GO Capital Improvement Bond $275,000 3097 2010A GO Improvement Bond $292,253 Total Debt Levy $3,012,093 The amount levied is less than the required amounts from the payment schedule for some of the bonds. The bonds are listed on Form B which is part of this resolution. The city has sufficient revenues in the bond funds to meet the debt obligations. City of Farmington,Levy Certification,Debt Service Schedule. Form B Net Levy Original Amount Per Increase Certified B.U. Bond Issue Principal Date Issued Bond Book (Decrease) Debt Levy Notes 3091 GO Improvement Refunding 2013A $ 5,365,000 1/10/2013 $ 499,025 $ (56,025) $ 443,000 A 3093 GO Street Reconstruction 2015A $ 3,050,000 10/15/2015 $ 285,915 $ 7,585 $ 293,500 3094 GO Refunding 2016A $ 3,450,000 12/1/2016 $ - $ 574,327 $ 574,327 3136 Cap Imp Plan Refunding 2016B $ 4,540,000 12/1/2016 $ 665,385 $ (30,385) $ 635,000 A 3138 GO Street Reconstruction 2019A $ 1,645,000 5/15/2019 $ 231,000 $ $ 231,000 3139 GO Equipment Certificates 2020A $ 1,105,000 2/19/2020 $ 268,013 $ $ 268,013 Total Bond Financing $ 19,155,000 $ 1,949,337 $ 495,502 $ 2,444,840 3130 2005C GO Bonds Internal Loan Repayment $ 2,280,000 7/5/2005 $ - $ 275,000 $ 275,000 B 3097 2010A GO Cap Imp Internal Loan Repayment $ 3,850,000 1/11/2010 $ - $ 292,253 $ 292,253 B $ 6,130,000 Total Debt $ 25,285,000 $ 1,949,337 $ 1,062,755 $ 3,012,093 Agrees to I hereby certify that the above schedule of bond levies to be spread on the payable 2021 tax rolls agrees with the City preliminary debt records. A copy of the corresponding debt levy resolution is attached. levy adopted by � �� bP1Q council on 9/21/2020 9/21/2020. Finance Director Date (A)Existing revenues in the respective bond fund are being used to meet the annual debt obligations. (B)Bonds optionally redeemed with an internal loan from the city. Loan is being repaid with debt levy. City of Farmington Budget and Tax Levy 2020 Budget, 2021 Proposed and 2022 Proposed Company 2020 2021 Budget% 2022 Budget o/o Budget Proposed Change Proposed Change Non-Property Tax Revenues Licenses and Permits 473,115 517,076 9.29% 453,600 (12.28)% Intergovernmental Revenue 922,294 667,912 (27.58)%, 663,587 (0.65)%, Charge for Service 565,802 576,197 1.84% 589,285 2.27% Fines and Forfeitures 49,000 49,000 0.00%' 49,000 0.00% Investment Income 38,800 29,100 (25.00)% 15,400 (47.08)% Miscellaneous 54,580 79,370 45.42% 53,170 (33.01)%, Transfers In 1,307,570 1,379,689' 5.52% 1,408,874 2.12%' Total Revenues 3,411,161 ' 3,298,344' (3.31)% 3,232,916' (1.98)% Expenditures Administration 907,162 889,3001 (1.97)%'' 1,087,554: 22.29% Human Resource 349,226 361,658 3.56% 391,509 8.25% Dakota Broadband 24,489 37,500' 53.13%' 40,500 8.00% Finance and Risk Mgmt 778,889 776,287 (0.33)% 827,688 6.62% Police 4,677,813 4,853,870 3.76%' 5,321,825 9.64%' Fire 1,445,410 1,441,226 (0.29)% 1,573,4731 9.18% Community Development 1,014,867 1,007,849' (0.69)% 1,103,540 9.49% Engineering 794,635 813,895' 2.42% 889,172' 9.25% Municipal Services 1,439,078 1,519,187 5.01% 1,630,813 7.92% Parks and Recreation 1,278,576 1,317,341 3.03% 1,454,246 10.39%' Transfers Out 932,207 822,351 (11.78)% 3,381,534 311.20% Total Expenditures 13,642,352 13,832,464 1.39% 17,701,854 27.97% Revenues Over(Under)Expenditures (10,231,191)' (10,534,120) 2.96%' (14,468,938)', 37.35% Fiscal Disparities 2,294,024 2,277,659 (0.71)% 2,277,659 0.00% General Fund Levy 7,937,167' 8,256,461 4.02% 12,191,279 47.66% Debt Levy Bonds 2,222,950 2,444,840 9.98% 2,099,788 (14.11)% 2005C Loan Repay-Storm Water Tr Adv 166,000 275,000 65.66% 166,000 (39.64)%' 2010A Loan Repay-Storm Water Tr Adv 400,000 292,253 (26.94)% 0 (100.00)%'' 201 OD Loan Repay-Storm Water Tr Adv 16,437 0 (100.00)% Total Debt Levy 2,805,387' 3,012,093 7.37% 2,265,788 (24.78)% Use of Fund Balance to Lower Debt Levy 0 Net Debt Levy 2,805,387 3,012,093' 7.37% 2,265,788 (24.78)% Farmington Net Tax Levy 10,742,554' 11,268,554 4.90% 14,457,067 28.30% General Fund Detailed Non-Property Tax Revenue Summary 2019 Budget, 2020 Budget, 2021 Proposed and 2022 Proposed Object 2019 2020 2021 2022 Account Budget Budget Proposed Proposed LIQUOR LICENSES 42,000 41,700' 40,000 37,000 BEER&WINE LICENSES 1,750' 1,100 1,100 850' CLUB LICENSES _ 500' 500 500 500' MASSAGE LICENSE 150 350 300 100' GAMBLING LICENSE/PERMIT 250 450 250 250 OTHER LICENSE&PERMIT 1,700 1,900 1,700 _ 1,500 ANIMAL LICENSES 4,000' 4,080' 2,500' 3,000' Licenses 50,350', 50,080 46,350 43,200 BUILDING PERMITS 272,400' 330,000 380,876 325,000 REINSPECTION FEES 1,000 1,000' 1,500 1,000 CODE ENFORCEMENT FEES 1,000' 2,600' 1,500 1,500 PLUMBING&HEATING PERMITS 35,000 52,500' 50,000 50,000 SEWER PERMITS 5,000' 5,000! 0 0 ELECTRIC PERMITS 18,000 16,000 16,000 16,000' ISTS PERMITS 250 300 300 300' UTILITY PERMITS _ 6,130 6,420 10,500 7,500 SIGN PERMITS 570 790 800 800' BURNING PERMITS 1,710 1,425' 1,250 1,300 OTHER PERMITS 5,000 7,000 8,000 7,000 Permits 346,060 423,035' 470,726 410,400' Licenses and Permits 396410 473,115 517,076 453,600 FEDERAL GRANT 0 5,000' 5,000 5,000 FEDERAL AID LOCAL GOVERNMENT AID 314,725 328,374 105,587 105,587' MSA MAINTENANCE 215,000' 215,000 184,000 184,000' POLICE AID 196,000' 198,500 198,000' 198,000' POST TRAINING 15,160' 15,160' 15,160 15,160' FIRE AID 137,910 137,910 142,490 142,490 STATE GRANT _ 0 9,000 MARKET VALUE CREDIT 0 0 COUNTY MISCELLANEOUS 13,470' 13,350 13,350 13,350 Intergovernmental 892,265 922,294 663,587 663,587 CUSTOMER SERVICE TAXABLE CUSTOMER SERVICES NONTAXABLE 250 200 210 210 ZONING&SUBDIVISION FEES 2,000 3,050 2,600 2,600 ADMINISTRATION FEES-PROJECTS 4,000' 4,500 4,000 4,000 FIRE CHARGES 225,780 237,172' 239,227 260,940 POLICE SERVICE CHARGES 77,000 78,030 78,810 80,385 ENGINEERING FEES-PROJECTS EROSION &SEDIMENT CONTROL 9,900 8,100 8,100 8,100 RECREATION FEES-GENERAL 90,000 85,000' 75,000' 85,000' RECREATION FEES-SENIOR CTR 18,000' 19,000' 15,000' 18,000 MEMBERSHIP FEES-SENIOR CTR 9,000 8,000 6,000 7,500 MOBILE MEALS-SENIOR CTR ADVERTISING_ 750 950 750 750 ADVERTISING _ 2,200, 1,800 1,500 1,800' FRANCHISE FEE 120,000 120,000 145,000 120,000 Charges For Services 558,880 565,802 576,197 589,285 COURT FINES 42,000' 49,000: 49,000 49,000' Paae 1 of General Fund Detailed Non-Property Tax Revenue Summary 2019 Budget, 2020 Budget, 2021 Proposed and 2022 Proposed Object 2019 2020 2021 2022 Account Budget Budget Proposed Proposed CODE VIOLATIONS&ADMIN FINES 0 0', Fines&Forfeitures 42;000` 49,000 49,000 49,000' INTEREST ON INVESTMENTS 21,900 38,800 29,100 15,400, GAIN/LOSS INVEST MKT VALUE Investment Income 21,900' 38,800 29,100 15,400 MISCELLANEOUS REVENUE 5,000 1,500 31,700 1,500 CASH OVER&SHORT RENTAL INCOME-RRC 22,000 20,880 18,000' 20,000' RENTAL INCOME 16,775' 31,700 29,670 31,670' DONATIONS 0, _ 500 DAKOTA BROADBAND HUMAN RESOURCE 0 Misc Revenue 43;775: 54,580 79,370 53,170 OPERATING TRANSFERS 1,244,2561 1,307,570 1,379,689' 1,408,874' Transfers In 1,244,256 1,307,570 1,379,689 1,408,874 Total Revenues $3,199;486 $3,411,161 $3,294,019 $3,232,916 Paae 2 of General Fund Expenditure Detail Summary 2019 Budget, 2020 Budget 2021 Proposed and 2022 Proposed Company 2019 2020 2021 2022 Budget Budget Proposed Proposed Expenditures Administration Legislative(1005) 96,447 87,772 87,392 89,642' Administration(1010) 295,214 302,068 308,097 454,221 Elections(1013) 35,867 44,124 9,351 47,454 Communications(1014) 99,650 108,537 114,900' 124,057 City Hall(1015) 354,144 364,661 369,560 372,180 Administration 881,322 907,162 889,300 1,087,554' Human Resources 336,447' 349,226 361,658 391,509 Human Resource(1011) 336,447 349,226 361,658 391,509 Human Resources' 336,447 349,226 361,658 391,509 Dakota Broadband 24,489 37,500 40,500' Dakota Broadband 24,489 37,500 40,500 Dakota Broadband: . 24489 37,500 40,600, Finance and Risk Management Finance(1021) 569,926 609,079 603,097' 651,848 Risk Management(1022) 169,810 169,810 173,190 175,840 Finance and Risk Management 739,736 778,889 776,287 827,688 Police Police Administration(1050) 873,339 1,235,377 1,271,088 1,426,458'' Patrol Services(1051) 2,738,524 2,538,727' 2,639,752 2,880,295 Investigations(1052) 856,544 892,059 926,430 998,472 Emergency Management(1054) 11,650 11,650 16,600 16,600 Police 4,480,057 4;677;813 4,853,870 5,321,8251 Fire Fire(1060) 1,267,885 1,445,410 1,441,226 1,573,473' Fire 1,267,885 1,445,410 1,441,226 1,573,473 Community Development 908,890 1,014,867 1,007,849 1,103,540 Planning(1030) 521,062 591,133' 567,681 629,388 Building Inspection(1031) 387,828 423,734' 440,168 474,152 Community Development 908,890 1,014,867 1,007,849 1,103,540 Engineering Engineering(1070) 624,587 665,173 694,134 749,555 Natural Resources(1076) 122,583 129,462 119,761 139,617' Engineering 747,170 794,635 813,895 889,172 Municipal Services Streets(1072) 1,146,492 1,197,200' 1,268,832 1,367,9101 Snow Removal(1073) 227,064 241,878' 242,355 262,903 Municipal Services 1,373,556 1,439,078 1,511,187 1,630,813' Parks and Recreation Park Maintenance(1090) 671,357 700,111 733,607 780,897' Rambling River Center(1093) 182,287 190,822 185,054 218,149 Park&Rec Admin(1094) 271,145 287,925 304,383 347,473'. Recreation Programs(1095) 106,804 99,718 94,297 107,727 Parks and Recreation 1,231,593 1,278,576 1,317,341 1,454,246': Transfers Out 1,041,138.00 932,207.00' 822,351.00 3,381,534.00 Transfers Out 1,041,138.00 932,207.00 822,351.00 3,381,534.00 Total Expenditures 13,007,794 13,642,352 13,832,464 17,701,854' 2021 Proposed Debt Service Object Refunding Ash St., Refunding of Elm City Hall&First St. Account Fire Station 2 Police Station Spruce St.,&Hill 195th Street St.,195th St.,& Garage Westview Area Ladder One Dee Walnut St. 4000-REVENUE AND EXPENDITU 4001 -REVENUES 4011 -CURRENT PROPERTY TA 275,000 292,253 443,000 293,500 574,327 635,000 231,000 268,013 Property Taxes 275,000 292,253 443,000 293,500 574,327', 635,000 231,000 268,013 4110-SPEC ASSESS CURRENT 58,926 286,149 Special Assessments 58,926 286,149 4955-INTEREST ON INVESTM 3,100 1,400 5,300 300' 500 Investment Income 3,100' 1,400 5,300 300' 500 Total Revenues' $275,000 $292,253 $505,026 $294,900 $865,776 $635,300 $231,500 $268,013 6001 -EXPENDITURES 7110-DEBT PRINCIPAL 720,000 210,000 540,000 505,000 180,000 7120-DEBT INTEREST 17,600' 55,450 31,900 116,275 34,500 80,113 7130-FISCAL AGENT FEES 2,950' 2,950 5,915 2,950 2,950 2,950 7140-LEGAL&FISCAL FEES 1,100 1,100 Debt Service 741,650 268,400 578,915 624,225' 217,450 83,063 Total Exp 741,650 268,400 578,915 624,225', 217,450 83,063 7310-OPERATING TRANSFERS 275,000 292,253 6,900 Transfers Out 275,000 292,253 6,900 Other Financing Sources (275,000) (292,253) (6,900) Net Change in Fund Balance $0 $0 ($236,624) $26,500 $279,961 $11,075 $14,050 $184,950 B C D E F H M N O P Q R S T U 1 2021 OPERATING TRANSFERS 2 TRANSFERS IN (5205) General Capital General General General Equipment Capital Capital Storm Capital Fund Equip Fund Equip Fund General Water Arena Cap Equip Fund (Police (Police (Fire 3 Fund EDA Park Imp Trunk Pro'Fd Vehicles Vehicles) Equip) Equip Sealcoat Street Main Trail Mair 51 Fund 1000 2000 ' 2300 4400 4503 5600 5600.5 5600.5 5600.6 5701 5711 5721 6 572,775 1000 Tax Levy - - 75,000 91,545 331,208 20,00( 7 105,587 1000LGA 40,000 - - 30,00( 8 _ 1000 Future Street CIP Debt 9 _ 1000 Future Street CIP Cash _ 10 143,989 1000 Future Vehicle CIP Cash 143,989 11 _ 1000 Projects CIP Cash _ 12 _ 1000 Projects CIP Debt _ 13 2000 EDA 14 2500 Arena r 15 6,900 3094-2016A 6,900 16 292,253 3097-2010A 292,253 17 = - 3099-2011 A 18 O 275,000 3130-2005C 275,000 19 _ 3136-201613 20 _ 3137-2016C 21 LU _ 3300-2010D LL 22 0 _ 3139-2020A 23 Z 340,410 6100 Admin(GF) 63,910 75,000 200,000 24 25,000 6100 25,000 25 89,411 6202 Admin(GF) 86,911 26 243,692 6202 HR 236,880 27 87,411 6302 Admin(GF) 86,911 28 61,848 6302 HR 61,848 29 86,911 6402 Admin(GF) 86,911 30 315,665 6402 HR 308,853 31 86,911 6502 Admin(GF) 86,911 32 357,126 6502 HR 335,554 33 3,090,889 1,379,689 40,000 75,000 574,153 - 143,989 75,000 91,545 531,208 50,00( 34 310,534 35 - - - - - - - - - Cell:F6 Comment:Teah Malecha: Reduced$10k 7/13/2020 Cell:N6 Comment:Teah Malecha: Removed$1,024 8/31/2020 Cell:S6 Comment:Teah Malecha: Reduced$400k 6/30/2020,moved$200k to liquor proceeds 7/13/20 Cell:U6 Comment:Teah Malecha: Reduced$40k 6/30/2020,reduced$30k 8/4/2020 Cell:W6 Comment:Teah Malecha: Reduce$17,172 8/31/2020 Cell:Z6 Comment:Teah Malecha: Employer portion of T Daus's insurance premium Cell:AA6 Comment:Teah Malecha: Budgeted transfer for insurance deductible. Reduced by$10k 6/30/2020,Reduced$4,024 and moved to LGA. Cell:F7 Comment:Teah Malecha: Reduced$20k 7/13/2020 Cell:N7 Comment:Teah Malecha: Moved $3k moved to Township rd maint,$5,976 to prop ins 8/31/2020 Cell:S7 Comment:Teah Malecha: moved$156,208 to tax levy due to LGA cut Cell:W7 Comment:Teah Malecha: Reduced$60k to$82,958 6/30/2020.Moved$67,172 to tax levy due to LGA cut Cell:T8 Comment:Teah Malecha: debt payment for backage road-Moved$126k to 2022 Cell:T9 Comment:Teah Malecha: moved$350k to 2022,update to$300k per David 6/17/2020 202nd St.Move$100k to liquor store proceeds 6/30/2020,removed$200k per council 7/13 Cell:010 Comment:Teah Malecha: Reduced$100k 6/30/2020. Reduced to PD only per 4/20 CIP 8/4/2020 Represents annual debt service for 2010A which is used to repay Storm Water Trunk interfund loan. Actually doesn't flow through operating transfers,but is shown that way for budget purposes.Final pmt 2021 Cell:M18 Comment:Teah Malecha: Represents annual debt service for 2005C which is used to repay Storm Water Trunk interfund loan. Actually doesn't flow through operating transfers,but is shown that way for budget purposes. Cell:E23 Comment:Teah Malecha: Approx 4%increase rounded to be evenly divided by 12(i.e.monthly transfers) Cell:T23 Comment:Teah Malecha: $100k DT sidewalks moved from projects CIP cash&$100k from Future Street CIP cash FHS 6/30/2020,moved to sealcoat 7/13/20 Cell:AA23 Comment:Teah Malecha: Budgeted transfer for insurance deductible-Insurance Deductible Spreadsheet Cell:E25 Comment:Teah Malecha: Approx 4%increase rounded to be evenly divided by 12(i.e.monthly transfers) Cell:AA25 Comment:Teah Malecha: Budgeted transfer for insurance deductible-Insurance Deductible Spreadsheet Cell:E26 Comment:Teah Malecha: Amounts per worksheet in @H Drive-Budget 2021 Updated 2020 Salary Distribution Cell:Y26 Comment:Teah Malecha: Amounts per worksheet in @H Drive-Budget 2021 Updated 2020 Salary Distribution Cell:E27 Comment:Teah Malecha: Approx 4%increase rounded to be evenly divided by 12(i.e.monthly transfers) Cell:AA27 Comment:Teah Malecha: Budgeted transfer for insurance deductible-Insurance Deductible Spreadsheet Cell:E28 Comment:Teah Malecha: Amounts per worksheet in @H Drive-Budget 2021 Updated 2020 Salary Distribution Cell:E29 Comment:Teah Malecha: Approx 4%increase rounded to be evenly divided by 12(i.e.monthly transfers) Cell:E30 Comment:Teah Malecha: Amounts per worksheet in @H Drive-Budget 2021 Updated 2020 Salary Distribution Cell:Y30 Comment:Teah Malecha: