The URL can be used to link to this page

Home My WebLink About12.04.17 Council Packet Meeting Location: Farmington Farmington City Hall Minnesota 430 Third Street Farmington,MN 55024 CITY COUNCIL REGULAR MEETING AGENDA DECEMBER 4, 2017 7:00 P.M. Action Taken 1. CALL TO ORDER 7:00 P.M. 2. PLEDGE OF ALLEGIANCE 3. ROLL CALL 4. APPROVE AGENDA 5. ANNOUNCEMENTS/COMMENDATIONS a) Farmington Liquors 360 Communities Farmington Food Shelf Presentation Information Received b) Promotion Ceremony for Sergeant Andrew Bellows Acknowledged 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 November 20, 2017 City Council Meeting— Administration Approved b) Accept Resignation Parks and Recreation Advisory Commission-Parks Accepted c) Approve 2017 Tree City USA Recertification—Engineering Approved d) Approve Various License and Permit Renewals— Community Development Approved e) Appointment Recommendation Finance Director—Human Resources Approved f) Approve Seasonal Hiring—Human Resources Approved g) Approve Out-of-State Training—Police Approved h) Approve Dakota County Electronics Crimes Task Force Joint Powers Agreement—Police Approved i) Approve City Credit Card Changes - Finance Approved j) Approve Bills - Finance Approved REGULAR AGENDA 8. PUBLIC HEARINGS a) 2018 License Renewals Approved 9. AWARD OF CONTRACT 10. PETITIONS, REQUESTS AND COMMUNICATIONS 11. UNFINISHED BUSINESS 12. NEW BUSINESS a) 2018 Final Budget and Tax Levy R56-17 13. CITY COUNCIL ROUNDTABLE 14. ADJOURN , p�EpRA!%,gip City ofoFarmington iw y Street Farmington, Minnesota 651.280.6800 -Fax 651.280.6899 co. +n.AARO* � www.ci.farmington.mn.us TO: Mayor, Councilmembers and City Administrator FROM: David McKnight, City Administrator SUBJECT: Farmington Liquors 360 Communities Farmington Food Shelf Presentation DATE: December 4, 2017 INTRODUCTION Liquor Operations Manager Blair Peterson will be present at the city council meeting to make a presentation to the 360 Communities Farmington Food Shelf from a recent fundraising event held at our stores. DISCUSSION NA BUDGET IMPACT NA ACTION REQUESTED Hear the presentation that Mr. Peterson has to make and ask any questions that you may have. p�pRM%~ City of Farmington Uy 430 Third Street Farmington, Minnesota . � 651.280.6800 - Fax 651.280.6899 41..A.,tea www.c i.farmingto n.mn.us TO: Mayor, Councilmembers and City Administrator FROM: Brian A. Lindquist, Police Chief SUBJECT: Promotion Ceremony for Sergeant Andrew Bellows DATE: December 4, 2017 INTRODUCTION Officer Andrew Bellows joined the Farmington Police Department in October of 2002. During this time Officer Bellows has been a Field Training Officer, an agent with the Dakota County Drug Task Force, a use of force instructor and received his bachelors degree at St. Mary's and will soon complete his master's degree in Public Safety Administration from St. Thomas. DISCUSSION Several members of Sgt. Bellow's family and police officers will be present for the pinning on of Sergeant stripes by Andrews father, Former Dakota County Sheriff David Bellows. BUDGET IMPACT The position is a replacement and is part of the 2018 budget. ACTION REQUESTED The promotion was approved at the previous city council meeting. No action necessary. Y�EEARA%%6 City of Farmington ,U 430 Third Street Farmington, Minnesota �� 651.280.6800 - Fax 651.280.6899 14'.A novo www.ci.farmington.mn.us TO: Mayor, Councilmembers and City Administrator FROM: David McKnight, City Administrator SUBJECT: Approve Minutes of the November 20, 2017 City Council Meeting-Administration DATE: December 4, 2017 INTRODUCTION Attached for your review are the minutes of the November 20, 2017 city council meeting. DISCUSSION NA BUDGET IMPACT NA ACTION REQUESTED Approve the minutes of the November 20, 2017 city council meeting. ATTACHMENTS: Type Description D Backup Material November 20, 2017 City Council Minutes CITY OF FARMINGTON CITY COUNCIL MINUTES REGULAR MEETING NOVEMBER 20, 2017 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, Bartholomay, Bernhjelm and Craig Absent-Donnelly Staff Present-Administrator McKnight, Public Works Director Gehler, Parks and Recreation Director Distad, Human Resources Director Wendlandt, Planning Manager Wippler and Attorney Mongue. 4. Agenda Motion by Bartholomay, second by Bernhjelm, to approve the agenda as amended removing item 12a. APIF, motion carried. 5. Announcements/Commendations a) Dakota County Commissioner Mike Slavik Dakota County Commissioner Slavik provided an update on activities in Dakota County. Commissioner Slavik discussed a number of issues including CTIB exit/local transportation sales tax, road projects, 2018 budget and more. Mayor Larson inquired about the timing of the county shop leaving Farmington. Slavik stated that there were a number of other steps that needed to be completed first. Councilmember Craig asked about the location of the homeless shelter in Dakota County. Slavik stated it was located in the northern portion of the county. All councilmembers thanked Commissioner Slavik for his update to the city. 6. Citizen Comments November 20, 2017 Minutes - 1- a) Jay Haugen, PO Box 412, addressed the city council on the issue of tiny homes. Mr. Haugen requested that the city council look into the issue of allowing tiny homes in Farmington and shared his history on the subject and the experience he has had since purchasing a tiny home. 7. Consent Agenda Motion by Bartholomay, second by Craig,to approve the consent agenda: a) Approve Minutes of the November 6, 2017 City Council Meeting-Administration b) Approve Minutes of the November 13, 2017 City Council Work Session-Administration c) Adopt Resolution R52-2017 Approving Polling Places for the 2018 Elections-Community Development d) Adopt Resolution R53-2017 Approving a Gambling Event Permit for the Knights of Columbus-Community Development e) Approve Seasonal Hiring-Human Resources f) Approve Out of State School and Conference-IT g) Approve Sergeant Promotion Police-Human Resources h) Approve Bills-Finance APIF, motion carried. Councilmember Bartholomay asked if we will need to purchase additional portions of the laser fiche system related to the training request in item 7f. Human Resources Director Wendlandt stated that we already own the entire package and the training will allow us to utilize more of this system. Councilmember Craig asked if the additional knowledge on the system will make us more efficient. Wendlandt stated it would. 8. Public Hearings None 9. Award of Contract None 10. Petitions, Requests and Communications a) Final Plat and Approval of Development Contract for Regetta Fields November 20, 2017 Minutes -2- Planning Manager Wippler presented the revised final plat for the Regetta Fields subdivision along with the development contract for this project. The preliminary and final plats were approved by the city council on August 21, 2017. The approved final plat consists of 61 lots over 24.08 acres. The developer initially requested that the development be phased, with the first phase consisting of 32 single-family residential lots. The developer has since decided not to phase the development but to final plat the entire 61 lots. The new final plat now consists of 61 single-family residential lots. The proposed development has not changed beyond the elimination of the phasing. The Planning Commission reviewed the revised final plat on November 4, 2017 and recommended approval of the final plat with contingencies on a vote of 4-0. The proposed development contract spells out the requirements for development of this parcel including timelines to complete the platting process, defining development charges and addressing construction of the public infrastructure required to serve the development together with the associated sureties. The following funds will receive contributions based on the 2017 area charges with the development: Water Fund $167,056 Storm Water Fund $169,737 Sanitary Sewer Fund $56,612 Park Improvement Fund $149,290 General Fund $3,355 Street Maintenance Fund $12,085 Credits paid from: Sanitary Sewer Trunk Fund $162,103 Park Improvement Fund $32,010 The city council and the developer had no questions or comments to add to the topic. Motion by Bernhjelm, second by Craig, to adopt resolution R54-2017 approving the final plat for Regetta Fields subject to the following conditions: 1. The satisfaction of all engineering comments related to the construction plans for grading and utilities. November 20, 2017 Minutes -3- 2. A development contract between the applicant and the city shall be executed and security,fees and costs shall be paid. Submission of all other documents required under the development contract shall be required. APIF, motion carried. Motion by Bartholomay, second by Craig, to approve the development contract between the City of Farmington and Giles Properties, Inc. APIF, motion carried. 11. Unfinished Business None 12. New Business None 13. City Council Roundtable Bernhjelm-Thanked ULI for the work session they held with the city council last week and wished everyone a happy Thanksgiving. Craig-Thanked Commissioner Slavik for presenting at the meeting. Bartholomay-Asked the city council to discuss the tiny homes issues at an upcoming work session, wished everyone a happy Thanksgiving and thanked all of those who make serving and working with the city a possibility. Larson-Thanked the community for their support of the recent hurricane relief project, reminded residents about Toys for Town, reminded residents to check the holiday garbage schedule, shared that Dazzle Day will return on December 2nd, shared that Small Business Saturday is November 25th, invited residents to Comp Plan meetings scheduled for December 5th and 7th and encouraged residents to shop local. 14. Adjourn Motion by Bernhjelm, second by Bartholomay,to adjourn the meeting at 7:48 p.m. APIF, motion carried. Respectfully Submitted David McKnight, City Administrator November 20, 2017 Minutes -4- oEA�M%� City of Farmington � 430 Third Street Farmington, Minnesota 651.280.6800 - Fax 651.280.6899 "'1.4.A„a0."° www.ci.farmington.mn.us TO: Mayor, Councilmembers and City Administrator FROM: Cynthia Muller,Administrative Assistant SUBJECT: Accept Resignation Parks and Recreation Advisory Commission-Parks DATE: December 4, 2017 INTRODUCTION A member of the Parks and Recreation Commission has resigned. DISCUSSION Ms. Hannah Simmons has submitted her resignation from her position on the Parks and Recreation Commission. Her term on the board runs through January 31, 2020. A copy of her resignation is attached. This seat will be advertised with the annual vacancies. BUDGET IMPACT None. ACTION REQUESTED Accept the resignation of Hannah Simmons from the Parks and Recreation Commission effective November 17, 2017. ATTACHMENTS: Type Description D Exhibit Resignation Cindy Muller From: Hannah Simmons • • Sent: Friday, November 17, 2017 2:56 PM To: Dustin Johnson; David McMillen; Laurie Suchanek;John Moore _ Cc: Randy Distad;Cindy Muller Subject: Resignation Dear City Council and PRC members, I'm afraid that I find myself overextended in my volunteer work. While I care deeply about parks and recreation programming in Farmington,the community deserves a representative who can be more consistently available for the Parks and Recreation Commission meetings.As such, I am resigning my appointment on the PRC.Thank you for the opportunity to serve on this Commission. It was a pleasure. I look forward to engaging with this great group as a citizen. Sincerely, Hannah Simmons 1 Yo FpRMj City of Farmington (cap a 430 Third Street Farmington, Minnesota 45� 651.280.6800 - Fax 651.280.6899 "'nyfi�� .A„� ° www.c i.farmingto n.mn.us TO: Mayor, Councilmembers and City Administrator FROM: Katy Gehler, Public Works Director SUBJECT: Approve 2017 Tree City USA Recertification-Engineering DATE: December 4, 2017 INTRODUCTION For the past 27 years, the City of Farmington has been recognized as a Tree City USA community through the Arbor Day Foundation. The four standards that must be met to qualify as a Tree City are; a tree board or tree department, a tree care ordinance, a community forestry program with an annual budget of at least$2 per capita, and an Arbor Day observance and proclamation. DISCUSSION The City of Farmington continues to meet the qualifications of Tree City USA and is requesting authorization to apply for 2017 recertification. BUDGET IMPACT There is no budget impact. ACTION REQUESTED Approve the city applying for 2017 Tree City USA recertification. ATTACHMENTS: Type Description ❑ Backup Material 2017 Application Certification Print this page Tree City USA 0.4 2017 Application for Certification TREE CITY USA The Tree City USA award is in recognition of work completed by the community during the 2017 calendar year. As Mayor or Equivalent of the Community of Farmington I herewith make application for this community to be officially certified/recertified as a Tree City USA for 2017,having achieved the standards set forth by the Arbor Day Foundation as noted below. Standard 1: A Tree Board or Department Community has a Department Chair or City Manager/Official Department Chair/City Manager Katy Gehler Public Works Director 641-280-6841 kgehler@ci.farminton.mn.us Standard 2:A Community Tree Ordinance M Our community ordinance is on record Standard 3: A Community Forestry Program with an Annual Budget of at Least$2 Per Capita Total Community Forestry Expenditures $123571 Community Population 23000 Per Capita Spending $5.37 Standard 4:An Arbor Day Observance and Proclamation 1� Official Arbor Day proclamatn is on record Mayor or Equivalent Signature ;/ Title Date Application Certification To Be Completed By The State Forester: Farmington The above named community has made formal application to this office. I am pleased to advise you that we reviewed the application and have concluded that,based on the information contained herein,said community is eligible to be certified as a Tree City USA community, for the 2017 calendar year,having in my opinion met the four standards required for recognition. State Forester Signature Title Date Arbor Day Foundation* tory Print this page --0-1+-14)1- City of Farmington `4... 430 Third Street 0 Farmington, Minnesota s 651.280.6800 -Fax 651.280.6899 6 ..41'.A pacol, www.ci.farmington.mn.us TO: Mayor, Councilmembers and City Administrator FROM: Cynthia Muller,Administrative Assistant SUBJECT: Approve Various License and Permit Renewals-Community Development DATE: December 4, 2017 INTRODUCTION Per city code the city council has the authority to approve on-sale and off-sale beer licenses and tobacco licenses. DISCUSSION The following establishments have submitted their applications for renewal: 3.2 Beer On-Sale Fountain Valley Golf Course, 2830 220th Street West Weng's Kitchen, 115 Elm Street 3.2 Beer Off-Sale Fountain Valley Golf Course, 2830 220th Street West Kwik Trip, 217 Elm Street Kwik Trip, 18290 Pilot Knob Road SuperAmerica#4534, 18520 Pilot Knob Road Cigarette License Family Fresh Market#326, 115 Elm Street Farmington Amcon, 957 8th Street Farmington Municipal Liquor Store, 18350 Pilot Knob Road Farmington Municipal Liquor Store, 109 Elm Street Farmington Tobacco, Inc., 115 Elm Street, Suite E Kwik Trip #693, 217 Elm Street Kwik Trip #443, 18290 Pilot Knob Road SuperAmerica#4534, 18520 Pilot Knob Road The appropriate forms, fees and insurance information have been submitted with the applications. The applications have also been reviewed and approved by the Police Department. BUDGET IMPACT The fees collected are included in the revenue estimates of the 2018 budget. ACTION REQUESTED Approve licenses for the above mentioned applicants. AikRifi� City of Farmington ,_ c 430 Third Street W Farmington, Minnesota iit s , 651.280.6800 Fax 651.280.6899 '44.A„ � www.c i.farmington.mn.us TO: Mayor, Councilmembers and City Administrator FROM: Brenda Wendlandt, Human Resources Director SUBJECT: Appointment Recommendation Finance Director-Human Resources DATE: December 4, 2017 INTRODUCTION The recruitment and selection process for the appointment of the Finance Director position has been completed. DISCUSSION After a thorough review by the City Administrator and the Human Resources Office, a contingent offer of employment has been made to Teah Malecha, subject to the completion of the background investigation, pre-employment drug test and ratification by the city council. Ms. Malecha is currently the Finance Officer for the city of Excelsior. Her experience meets the qualifications for this position. BUDGET IMPACT Ms. Malecha's starting salary will be$90,173.00 which is the first step of the salary range for this position (salary range: $90,173 - $112,717.00). Additionally, Ms. Malecha will start with a beginning paid time off (PTO) balance of 80 hours; however, she will accrue time according to the PTO schedule. Funding for this position is authorized in the 2018 budget. ACTION REQUESTED Approve the appointment of Teah Malecha effective on January 8, 2018. oAR %, City of Farmington /44":- 430 Third Street Farmington, Minnesota 651.280.6800 - Fax 651.280.6899 '44.A PROVO* www.ci.farmington.mn.us TO: Mayor, Councilmembers and City Administrator FROM: Brenda Wendlandt, Human Resources Director SUBJECT: Approve Seasonal Hiring-Human Resouces DATE: December 4, 2017 INTRODUCTION The recruitment and selection process for the appointment of the attached list of fall/winter seasonal staff has been completed. DISCUSSION After a thorough review by the Parks and Recreation Department and the Human Resources Office, offers of employment have been made to the individuals show on the attached spreadsheet, subject to a pre- employment drug test and ratification by city council. BUDGET IMPACT These positions are included in various departmental budgets. ACTION REQUESTED By motion approve the attached seasonal employment recommendations. ATTACHMENTS: Type Description D Backup Material Winter S casonal S taffing 2017 Fall/Winter Seasonal Staff 2016-17 Name Pay Rate Position/Step Adam Roschen $ 13.11 Step 1 -Arena Supervisor Luke Johnston $ 13.11 Step 1 -Arena Supervisor Zachary Olson $ 9.65 Step 1 -Warming House Attendant Alex Lyons $ 9.65 Step 1 -Warming House Attendant p�pRAI%� City of Farmington C7 430 Third Street Farmington, Minnesota 651.280.6800 - Fax 651.280.6899 44 ' .APRO*. nwww.ci.farmington.mn.us TO: Mayor, Councilmembers and City Administrator FROM: Brian A. Lindquist, Police Chief SUBJECT: Approve Out-of-State Training-Police DATE: December 4, 2017 INTRODUCTION Sergeant Bob Sauter has bee the lead use-of-force instructor for the department for the past 18 years. The Force Science Institute is considered a world leader in this area and provides much of our instructional concepts. DISCUSSION The use-of-force by police officers is the number one topic of concern for both law enforcement officials and the public. The Farmington Police Department takes this responsibility most seriously and dedicates considerable training to ensure all officers are familiar with best practices. Several years ago the Farmington Police Department began training with Force Sciences Institute and has several instructors within the department. I have attached a copy of the five day Certification Course agenda. BUDGET IMPACT The Certification Course is held only 12 times in 2018, none of them are in Minnesota. The course cost is $1,500.00. Hotel costs are estimated at$1,000.00 and air costs are estimated at$800. The cost of this training is budgeted for in the 2018 budget. ACTION REQUESTED Approve Sgt. Sauter attendance at the Force Science Institute Certification course on February 12-16, 2018 in Scottsdale,AZ. ATTACHMENTS: Type Description o Cover Memo Course Agenda As with all Force Science Certification courses, the program will be conducted by the impressive team of renowned experts who make up the elite Force Science Institute instructional team. These groundbreaking professionals, whose personal work directly impacts our understanding of the complex areas we explore in the course, will instruct on a wide variety of crucial dynamics that impact the analysis and investigation of force encounters and will lead to a new certification for investigators of force-related incidents. Through the groundbreaking work of Dr. Bill Lewinski, who personally serves as the lead instructor throughout the week, and the Force Science Cert Course team, you'll learn: • How to practically apply the training you receive--directly from the Force Science Institute--to your investigations and force evaluations to ensure that vital elements of controversial uses of force are not overlooked. • Skills to help determine whether an officer is being honest when he swears his recollection of an incident is true...even though his account directly conflicts with forensic evidence. • Techniques for helping officers accurately & thoroughly recall details of force encounters, shared directly from the developmental source. • Why a site visit and/or video review may or may not be advisable before a statement. • Whether shots to the back really reflect what an officer saw when he pulled the trigger. • How to avoid critical mistakes some investigators make during post-incident interviews. • The truth about time: How long it really takes officers to start—and stop—shooting. • What ready position is really best for reducing lag time...and much more! Attendees who successfully complete the program will be certified in "Force Science Analysis." This designation attests that the holder has been trained to recognize and articulate important psychological, biological, and physiological factors that can influence human behavior and memory in force encounters and pursuit situations. The training will be based on solidly documented findings about human dynamics by the Institute's Force Science Research Center and other world-acclaimed research sources that are commonly misunderstood or ignored in law enforcement investigations, according to Dr. Bill Lewinski, coordinator of the new program and executive director of the Force Science Institute. "There's a tremendous need for the application of human science in force investigations," he says. "Without it, controversial officer-involved shootings and other uses of force--even pursuits, which also involve split-second decision-making in highly stressful, rapidly evolving circumstances--can easily be misjudged, with devastating consequences. "In some cases officers have gone to prison and agencies have suffered crushing losses in civil suits because the factors in how humans perform under stress were not properly assessed by uninformed investigators." Like persons trained in accident reconstruction, blood-spatter analysis, and other science-based disciplines, investigators certified in Force Science Analysis will be able to apply their grasp of human dynamics to interpret how and why a force confrontation evolved as it did, Lewinski said. They will also know how to "best mine the memories of those involved for relevant recollections." This information can be vital to authorities who ultimately must judge the encounter, such as administrators, I.A. chiefs, review board members, prosecutors, judges, and jurors. Among other things, the backgrounds of the instructors will include world-class expertise in: • how the brain and body work together to form psychomotor skills; • the latest cognitive interviewing techniques for law enforcement; • officer and suspect behaviors in deadly assaults on LEOs; • motor performance, visual attention, and memory; • how stress and trauma affect memory; • the effect of low-light levels on perception; • contextual cues; • the dynamics of action and reaction in force encounters; • decision-making variables during pursuits; •judgment and psycho-physiological responses under extreme stress. Most of the faculty are medical doctors or hold PhDs in specialized disciplines of psychology and some have authored the leading textbooks in their fields. A few have worked closely with law enforcement and/or the military in the past, but "some will be adapting their findings on human behavior to a law enforcement context for the first time," Lewinski said. As course coordinator, as well as a presenter himself, it will be his job, he said, to assure that "all information is conveyed in terms that are understandable and have practical application for the attendees seeking certification." Question-and-answer opportunities will supplement the formal instruction. The schedule: The Force Science Certification Course Program Daily Instruction Each day the course will consist of sessions in which the instructors will identify and explain in detail certain physical and psychological phenomena associated with human behavior and demonstrate how these can impact performance under stress. "These are things like reaction times, perceptual distortions, narrowed vision, language limitations, and memory gaps--factors that investigators need to be aware of and fully understand, especially in controversial or puzzling cases," Lewinski said. "They also need to be able to articulate in reports and testimony how these factors may have influenced an event, to give as complete a picture as possible of what happened. And they need to understand how the traumatized brain functions so they can adapt their interviewing techniques to recover a maximum amount of valid material from the participants." What the students will come to understand during these initial days, Lewinski said, is "a protocol for investigating and interviewing that will best assure a fair, balanced, impartial, and comprehensive explanation of the encounter in question. "It is not an investigator's job to determine if an officer's behavior, let's say, was right or wrong in a use-of-force situation. But it is the investigator's job to clearly and objectively present all the potentially relevant facts to the person or person responsible for that decision. "Without this training, it is highly likely that pivotal truths related to human performance will be misinterpreted or missed entirely in high-profile cases where the stakes are life-changing." Day 4 will include a written examination prior to lunch. Group Participation An important part of the Force Science Certification process is interactive participation with students. At registration, class participants will receive a large course binder that in addition to materials related to each block of instruction, will include detailed evidentiary information related to an actual officer-involved shooting case students will "investigate." Each night immediately following class, Dr. Lewinski will personally facilitate an intensive group discussion exercise in the classroom with the entire student body centered on applying the information taught each day to that case. Dr. Lewinski will pose compelling questions related to the case in a Socratic, "guided discovery" fashion designed to help students tap into their newly acquired knowledge and apply it in a practical, real-world fashion likely to be mirrored in their own professional activities. This exercise will also allow Dr. Lewinski, and potentially other members of the teaching staff, to further elaborate on a number of the topics covered that day in class. "This will be a highly interactive experience and will allow the trainees to make practical applications of what they've learned,just as they would in a real investigative setting," Lewinski said. "They will need to be open-minded and unbiased in their approach. The point will not be to advocate but to inform a decision-maker of the dynamic elements that need to be understood and considered." oaR�yi , City of Farmington U430 Third Street 1 . Farmington, Minnesota 651.280.6800 - Fax 651.280.6899 4487..A KO, www.ci.farmington.mn.us TO: Mayor, Councilmembers and City Administrator FROM: Brian A. Lindquist, Police Chief SUBJECT: Approve Dakota County Electronics Crimes Task Force Joint Powers Agreement- Police DATE: December 4, 2017 INTRODUCTION In December of 2014 the city council approved the initial Electronics Crimes Task Force Joint Powers Agreement. That agreement is up for renewal. DISCUSSION The Farmington Police Department along with several other law enforcement agencies have combined resources to combat electronic crimes and invest in equipment and training allowing for the successful investigation of prosecution of those crimes. The task force has been in existence since 2014 and has had many success. It is of great value to continue with this program. BUDGET IMPACT The cost is $18,000 per year and is budgeted for in the 2018 budget. ACTION REQUESTED Approve the Electronics Crimes Task Force Joint Powers Agreement. ATTACHMENTS: Type Description ❑ Backup Material Joint Powers Agreement DAKOTA COUNTY ELECTRONIC CRIMES TASK FORCE JOINT POWERS AGREEMENT The parties to this Agreement are units of government responsible for the enforcement of criminal laws in their respective jurisdictions. This Agreement is made pursuant to the authority conferred upon the parties by Minnesota Statutes, Section 471.59. NOW THEREFORE, the undersigned governmental units, in the joint and mutual exercise of their powers, agree as follows: 1. Name. The parties hereby establish the Dakota County Electronic Crimes Task Force ("Task Force"). 2. General Purpose. The purpose of this Agreement is to establish an organization to coordinate efforts to investigate illegal activities related to the use of electronic devices, the Internet, and materials transmitted or used in electronic form and the prosecution of those conducting such illegal activities. 3. Parties. The parties to this Agreement are the following units of government: City of Apple Valley City of Mendota Heights City of Burnsville City of Rosemount City of Farmington City of South St. Paul City of Hastings City of West St. Paul City of Inver Grove Heights County of Dakota City of Lakeville Dakota County Drug Task Force (Individually or collectively "member(s)" or"party(ies)") 4. Administrative Board. 4.1 Creation and Composition. A joint powers board, known as the Electronic Crimes Task Force Administrative Board ("Board"), is established for the purposes contained herein with the powers and duties set forth in this Agreement. The Board shall consist of one member from each of the law enforcement units of government that participates in the Task Force, appointed by their respective police chief or sheriff. Board members appointed by police chiefs and the sheriff must be full-time supervisory peace officers of their jurisdiction or office. The police chief or sheriff may appoint an alternative member to attend Board meetings if the appointed member is unavailable. Alternates must be full-time supervisory peace officers from their jurisdiction or office. Board members shall not be deemed employees of the Task Force and shall not be compensated by it. At the discretion of the Dakota County Attorneys, the Dakota County Attorney's Office shall serve the Board in an advisory capacity and shall be designated legal counsel on behalf of the Board and Task Force. The fiscal agent shall maintain a roster of current Board members and appointed alternates. 4.2 Terms. Board members and alternates shall serve at the pleasure of their respective police chief or sheriff. In the event that any Board member shall be removed by the appointing agency, the vacancy shall be filled by the appropriate appointing agency. 4.3 Officers. At its initial meeting in January 2018, the Board shall elect from its members (but not alternates) a chair, a vice-chair and a secretary/treasurer, and such other officers as it deems necessary to conduct its meetings and affairs. In January of each subsequent year the Board shall meet and elect from its members a chair, a vice-chair, a secretary/treasurer, and such other officers as Page 1 of 19 it deems necessary to conduct its meetings and affairs. Officers shall serve for a term of one (1) year or until the officer ceases to be a board member, whichever is shorter. 4.4 Meetings. The Board shall meet in January of each year and shall have other regular and special meetings at such times and places as the Board shall determine. Special meetings may be held on three (3) days' notice by the chair or any two (2) board members; except that a special meeting to consider adoption of or amendments to the Board's operating rules pursuant to Section 6.1 shall require ten (10) days' notice. The presence of two-thirds(2/3) of the Board members at a meeting shall constitute a quorum. 4.5 Voting. Each Board member shall be entitled to one vote. If a Board member is unable to attend a meeting, the duly appointed alternative may attend and vote. Proxy voting is not permitted. The Board shall function by a majority vote of the board members, or alternates, present. 5. Duties of the Administrative Board. 5.1 The Board shall formulate a program to carry out its purpose. 5.2 The Board shall coordinate intelligence between the members and the Task Force and cooperate with other local, state, and federal law enforcement agencies to accomplish the purpose for which it is organized. 5.3 The Board shall keep proper and adequate books of accounts showing all its receipts and disbursements by date, source, and amount. It shall have prepared an independent audit of the books and accounts of the Task Force and shall provide an audit report to its members if any member requests a financial audit of the Task Force. 5.4 The Board shall keep proper minutes of all its proceedings. 5.5 The Sheriff's Office shall provide annually a year-end review/expenditure report of the Task Force's activities. 5.6 The Board shall establish performance and quality control measures and periodically monitor those measures, to include Task Force investigatory practices and policies. 6. Powers of the Administrative Board. 6.1 The Board may adopt and amend such bylaws that it may deem necessary or desirable for the conduct of the business of the Board. Such bylaws shall be consistent with the terms of this Agreement and any applicable laws or regulations. 6.2 The Board may enter into any contract necessary or proper for the exercise of its powers or the fulfillment of its duties and enforce such contracts to the extent available in equity or at law. The Board may authorize the chair of the Board to enter into and execute those contracts. 6.3 The Board may sue and be sued. 6.4 The Board may disburse funds in a manner which is consistent with this Agreement and with the method provided by law for the disbursement of funds by the parties to this Agreement. 6.5 The Board may apply for and accept gifts, grants or loans of money or other property or assistance from the United States Government, the State of Minnesota, or any person, association or agency for any of its purposes; enter into any agreement in connection therewith; and hold, use and Page 2 of 19 dispose of such money, property or assistance in accordance with the terms of the gift, grant or loan relating thereto. 6.6 The Board may cooperate with other federal, state and local law enforcement agencies to accomplish the purpose for which it is organized. 6.7 The Board shall purchase and maintain public liability insurance coverage, with a limit of at least $1,500,000 per occurrence, under standard liability coverage forms, and such other bonds and insurance as is deemed necessary for the protections of the Board, its members, representatives, officers, agents and employees. The exercise of such authority by the Board shall not be construed as a waiver or modification of the limitations, defenses and immunities of liability contained in Minnesota Statutes, Chapter 466, Minnesota Statutes, Section 471.59, subd. la or other applicable law. 6.8 The Board may hold such other property as may be required to accomplish the purposes of this Agreement and upon termination of this Agreement make distribution of such property as provided for in this Agreement. 6.9 To the extent allowed by law, establish and collect fees, including user fees, for services performed by the Task Force, the Board or its members. 6.10 The Board may create a policies and procedures manual for use by the Task Force and review the same annually. If a policy or procedure adopted by the Board conflicts with a policy or procedure of a member, that member's policy or procedure shall apply to any agent assigned by that member to the Task Force. 6.11 The Board may retain legal counsel to advise the Board and provide civil legal services. 6.12 The Board may recommend changes in this Agreement to its members. 7. Budgeting and Funding. 7.1 By April 30 of each year the Board shall prepare and adopt a budget for the following year and may amend the same from time to time. 7.2 The members intend to fund the cost of operating the Task Force through member contributions of funds, officers and staff and by obtaining grant funds and restitution, if available. For 2018, the cities of Hastings, Farmington, Inver Grove Heights, Mendota Heights, Rosemount, South St. Paul and West St. Paul and the Dakota County Drug Task Force each shall pay $18,000 to the Task Force fiscal agent to be deposited in the Task Force account. Members may also contribute the services of a licensed peace officer(s) and staff as determined by the Board. For 2018, the cities of Apple Valley and Burnsville shall contribute the services of one full-time licensed peace officer and the city of Lakeville shall contribute the services of a license peace officer as determined by the Board. For 2018, Dakota County shall contribute the services of one full-time and one part-time (50%) licensed peace officers and two full-time staff and shall commit to housing the Task Force within a County facility. By April 1 of each subsequent year, prior to the adoption of an annual budget for the following year, the Board will determine the amount of financial contribution by each member so that the adopted budget will be adequately funded. Any member may object to a proposed payment as excessive relative to the adopted budget. If a member's objection cannot be resolved, the Board may adopt a revised budget to accommodate the member's objection or an amendment to this Agreement approved by all members shall be executed by each member's governing body. The Board shall determine the amount of financial contribution and/or contribution of services by members and any new members. Page 3 of 19 7.3 If the Board incurs any liability for damages arising from the services performed under this Agreement, the amount of damages shall be assessed equally amongst the members. Nothing herein shall be construed as a waiver or modification of the limitations, defenses and immunities as fully described in Section 10. 7.4 The Board shall adopt a budget based upon grant funds received, member financial contributions and money made available from other sources. The Board may amend the budget as needed to reflect revenue and expenditure changes. 7.5 Dakota County shall serve as the fiscal agent of the Task Force and shall account for all funds received pursuant to this Agreement according to generally accepted accounting principles. The fiscal agent shall forward reports on Task Force receipts and disbursements to the members on a regular basis. Fiscal agent responsibilities shall include, but not be limited to: management of all funds, including member contributions and grant monies, payment for contracted services and relevant bookkeeping and recordkeeping. No payment on any invoice for services performed by any person providing services in connection with this Agreement shall be authorized unless approved by the Board chair, vice-chair or secretary/treasurer. 7.6 The members agree to contribute their financial contributions, grant funds and dedicated licensed peace officers required to operate the Task Force. 7.7 All funds shall be accounted for according to generally accepted accounting principles. The secretary/treasurer shall make a quarterly financial report of all expenditures and receipts, and current fund balances to the Board. 7.8 The Board may not incur debt. 7.9 The Board's obligation to reimburse members for any expense, furnish equipment, pay for staffing and the like is contingent upon the receipt of grant funds for that purpose. If insufficient grant funds are received, the Board may reduce the level of reimbursement, staffing and/or other expenditures. 8. Agents. 8.1 Each member shall inform the Board in December of each year of the identity of the licensed peace officers to serve as Agents for the Task Force ("Agents") for the following calendar year. The chief law enforcement officer for that member shall have the responsibility for determining the identity of their assigned officer(s). The number of licensed peace officer(s) per member allowed to serve as Agents for the Task Force must be approved in advance by the Board. 8.2 Agents will be responsible for the investigation of illegal activities related to or involving the use of electronic devices, the Internet, and materials transmitted or used in electronic form, including case development and handling and processing of evidence. To the extent permitted by law, Agents will work cooperatively with assisting agencies, including sharing information acquired by Agents pursuant to this Agreement. 8.3 Agents are not employees of the Task Force. Agents shall remain employees of the member that has assigned them to the Task Force and shall be compensated by that member. Each party to this Agreement shall be responsible for injuries to or death of its own personnel. Each party shall maintain workers' compensation coverage or self-insurance coverage covering its own personnel while they are providing assistance as a member of the Task Force. Each party to this Agreement waives its right to sue any other party for any workers' compensation benefits paid to its own employee or their Page 4 of 19 dependents, even if the injury is caused wholly or partially by the negligence of any other party, or its officers, employees or agents. 8.4 The member appointing the Agent shall furnish the Agent with all standard department issued equipment necessary to perform all functions of the Agent. Agents' computers must meet Dakota County standards. Each member shall be responsible for damages to or loss of its own equipment. Each member waives the right to sue any other member for any damages to or loss of its equipment, even if the damages or loss were caused wholly or partially by the negligence of any other member or its officers, employees or agents. 8.5 The members shall maintain the officer positions hired to replace the officer assigned to the Task Force, or maintain the full-time equivalent or half-time equivalent staffing assigned to the Task Force as described in Sections 7.2 and 8.1. 9. Indemnification. The Task Force is a separate and distinct public entity to which the parties have transferred all responsibility and control for actions taken pursuant to this Agreement. The Task Force shall defend and indemnify the parties, and their officers, employees, and agents, from and against all claims, damages, losses, and expenses, including attorney fees, arising from Task Force activities or operations, and decisions of the Board. Nothing in this Agreement shall constitute a waiver of the statutory limits on liability set forth in Minnesota Statutes, Chapter 466, or a waiver of any available immunities or defenses. To the fullest extent permitted by law, action by the parties to this Agreement are intended to be and shall be construed as a "cooperative activity"and it is the intent of the parties that they shall be deemed a "single governmental unit" for the purposes of liability, as set forth in Minnesota Statutes, Section 471.59, subd. 1 a(a), provided further that for purposes of that statute, each party to this Agreement expressly declines responsibility for the acts or omissions of another party. Nothing herein shall be construed to provide insurance coverage or indemnification to an officer, employee, or agents of any party for any act or omission for which the officer, employee, or agent is guilty of malfeasance in office, willful neglect of duty, or bad faith. Any excess or uninsured liability shall be borne equally by all the parties, but this does not include the liability of any individual officer, employee, or agent which arises from his or her own malfeasance, willful neglect of duty, or bad faith. 10. Insurance. The Board shall purchase general liability insurance for activities of the Task Force as described in Section 2. Such insurance shall name each member as an additional insured. By purchasing insurance, the members do not intend to waive, and this Agreement shall not be interpreted to constitute a waiver by any member of limitations on liability or immunities provided by any applicable Minnesota law, including Minnesota Statutes, Chs. 466 and 471. The cost of the general liability insurance shall be paid from funds of the Task Force. 11. Task Force Supervisory Oversight. The Dakota County Sheriffs Office will provide supervisory oversight of Task Force operations including case assignments, record keeping, intelligence management, management of all property seized, and the execution of stings, arrests, search warrants and similar operations performed by the Agents. The members of this Agreement are not liable for the acts or omissions of the other members of this Agreement except to the extent to which they have agreed in writing to be responsible for acts or omissions of the other members. Page 5 of 19 12. Additional Parties. Any additional unit of government may become a party to this Agreement by adopting a resolution declaring its intention to do so and by entering into this Agreement, as it may be amended from time to time, provided that the parties have entered into an amendment pursuant to Section 13 approving such additional member. Such amendment shall be substantially in form of Exhibit A, attached hereto and incorporated by reference. 13. Amendments. Any amendment to this Agreement must be in writing and executed by all of the parties. 14. Counterparts. This Agreement may be executed in two or more counterparts, each of which shall be deemed an original but all of which shall constitute one and the same instrument. All counterparts and amendments shall be filed with the fiscal agent. 16. Effective Date. This Agreement shall take full effect on January 1, 2018. Members may execute this Agreement in counterparts and need not sign the same original document. The signed Agreement shall be filed with the Board's designated fiscal agent, who shall notify all members in writing of its effective date. The fiscal agent shall also notify all parties of additional parties added pursuant to Section 12 and parties withdrawing pursuant to Section 16.3. 16. Termination and Withdrawal. 16.1 Termination Date. This Agreement shall terminate upon the occurrence of any one of the following events, whichever occurs first: • When necessitated by operation of law or as a result of a decision by a court of competent jurisdiction; or • When a majority of members agree by resolution to terminate the agreement upon a date certain; or • On December 31, 2022, unless extended by agreement of all of the members. 16.2 Effect of Termination. Termination shall not discharge any liability incurred by the Board or by the members during the term of this Agreement. Each member shall be liable for its own acts and for the acts of the Board to extent provided by law. With the exclusion of technology equipment contributed and owned by any member, upon termination of this Agreement all property of the Task Force shall be sold or distributed to the members in proportion to their respective financial and staff contributions to the Task Force since its inception. Parties who effectively withdraw from this Agreement will not be entitled to any return of their financial contributions. 16.3 Withdrawal. Without the necessity of approval from the parties' governing bodies, any party may withdraw from this Agreement upon 60 days' written notice to the Board. The Board shall notify the members pursuant to Section 17 of the receipt of a withdrawal notice. Equipment acquired by an Agent or member as a result of training or other activities paid or sponsored by the Task Force shall remain the property of the Task Force upon withdrawal of that member from the Task Force. 16.4 Effect of Withdrawal. Withdrawal by any member shall not terminate this Agreement except as provided in Section 16.1. Withdrawal shall not act to discharge any liability incurred by or chargeable to the member prior to the effective date of withdrawal. Such liability shall continue until discharged by law or agreement. No member shall be entitled to a refund of administrative or operating funds paid or forgiveness of such funds owed to the Board. Page 6 of 19 17. Notice. Notice of withdrawal shall be provided by first class mail to the following and to any additional members added pursuant to Section 12: Apple Valley Chief of Police Mendota Heights Chief of Police 7100 147th Street West 1101 Victoria Curve Apple Valley, MN 55124 Mendota Heights, MN 55118 Burnsville Chief of Police Rosemount Chief of Police 100 Civic Center Parkway 2875 145th Street West Burnsville, MN 55337 Rosemount, MN 55068 Farmington Chief of Police South St. Paul Chief of Police 19500 Municipal Drive 125 3rd Avenue North Farmington, MN 55024 South St. Paul, MN 55075 Hastings Chief of Police West St. Paul Chief of Police 150 3rd Street East 1616 Humboldt Avenue Hastings, MN 55033 West St. Paul, MN 55118 Inver Grove Heights Chief of Police Dakota County Sheriff 8150 Barbara Avenue Law Enforcement Center Inver Grove Heights, MN 55044 1580 Highway 55 Hastings, MN 55033 Lakeville Chief of Police 9237 183`d Street Dakota County Drug Task Force Lakeville, MN 55044 P.O. Box 21304 Eagan, MN 55121-0304 IN WITNESS WHEREOF, the undersigned governmental units, by action of their governing bodies, have caused this Agreement to be executed in accordance with the authority of Minnesota Statutes, Section 471.59. Approved by the City Council CITY OF APPLE VALLEY Date: By: Date of Signature: Attest: Date of Signature: Page 7of19 Approved by the City Council CITY OF FARMINGTON Date: %_/y%e=/? By: �J Date of ignature: i,J Attest: 1(30.— Date of Signature: /c2- as/7 • Page 9 of 19 EXHIBIT A Amendment to Dakota County Electronic Crimes Task Force Joint Powers Agreement Whereas, on or about January 1, 2018, the County of Dakota, the Dakota County Drug Task Force and the cities of Apple Valley, Burnsville, Farmington, Hastings, Inver Grove Heights, Lakeville, Mendota Heights, Rosemount, South St. Paul and West St. Paul ("Parties") entered into a joint powers agreement establishing the Dakota County Electronic Crimes Task Force ("Agreement"); and Whereas, the Parties desire to amend the Agreement to add as a party to the Agreement; and Whereas, as a governmental unit of the State of Minnesota, through its duly elected governing body, has adopted a resolution approving the Agreement and authorizing its to execute the same; and Whereas, the Agreement provides that any amendments to the Agreement must be in writing and executed by all of the Parties. Now, therefore, in consideration of the mutual promises contained herein, the Parties agree to amend the Agreement as follows: 1. Section 3 Parties to include as a party to the Agreement. 2. Section 7.2 Budgeting and Funding to provide that shall contribute for the initial calendar year of membership. 3. All other terms of the Agreement shall remain in force and effect unless otherwise amended in accordance with the terms of the Agreement. In Witness Whereof, the Parties have executed this Amendment to the Agreement on the dates indicated below. Page 19 of 19 Ut City of Farmington 430 Third Street Farmington, Minnesota 651.280.6800 - Fax 651.280.6899 WWW.ci.farmington.mn.us TO: Mayor, Councilmembers and City Administrator FROM: Robin Hanson, Finance Director SUBJECT: Approve City Credit Card Changes-Finance DATE: December 4, 2017 INTRODUCTION The city provides business credit cards to staff, as needed DISCUSSION Staff is requesting approval for a business credit card with a$1,500 credit limit for Cory Harmening, Network Administrator. The number of city issued credit cards and the utilization of those cards has expanded over the past five years as this has become a more common form of payment. As a result, staff is also requesting city council approval to request an increase in the city's credit card limit from$25,000 to $40,000 to minimize the number of times staff are denied use of the city credit card because the city has reached its credit card limit prior to the next scheduled payment being made. BUDGET IMPACT NA ACTION REQUESTED City staff recommends that a motion be made to: 1-Authorize staff to obtain a city business credit card for the individual indicated above with a$1,500 credit card limit. 2-Authorize staff to request an increase in the city's overall credit card limit to $40,000. ,:oEEAR, j \ City of Farmington 430 Third Street 1 . W Farmington, Minnesota 651.280.6800 -Fax 651.280.6899 ++�. „a www.ci.farmington.mn.us TO: Mayor, Councilmembers and City Administrator FROM: David McKnight, City Administrator SUBJECT: Approve Bills-Finance DATE: December 4, 2017 INTRODUCTION Attached for your review are the list of bills for the period of November 16, 2017 through November 29, 2017. DISCUSSION NA BUDGET IMPACT NA ACTION REQUESTED Approve the bills for the period of November 16, 2017 through November 29, 2017. ATTACHMENTS: Type Description D Backup Material List of Bills R55CKS2 LOGIS601V CITY OF FARMINGTON 11/29/2017 9:16:08 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 1 10/1/2017 - 11/29/2017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 141940 11/17/2017 115966 ANDERSON,PAT 24.00 KINGS ROOM CANCEL 160804 100617 1001 4670 RECREATION FEES-SENIOR CTR GENERAL FUND REVENUES 01000 01 24.00 141941 11/17/2017 114024 APPLE CHEVROLET BUICK,NORTHFIELD 120.00 REPROGRAM TURN SIGNALS 900 160589 CVCS389938 1090 6230 VEHICLE SUPPLIES&PARTS PARK MAINTENANCE 01000 09 120.00 141943 11/17/2017 108446 ASPEN MILLS 1,817.74 HARRISON INITIAL ISSUE UNIFORM 160769 205899 1051 6290 UNIFORMS&CLOTHING PATROL SERVICES 01000 05 2,085.99 REUBEN INITIAL ISSUE UNIFORM 160770 205969 1051 6290 UNIFORMS&CLOTHING PATROL SERVICES 01000 05 59.83 HARRISON TOURNQUETE ISSUE 160780 205546 1051 6290 UNIFORMS&CLOTHING PATROL SERVICES 01000 05 3,963.56 141944 11/17/2017 108482 AXON ENTERPRISE,INC 1,282.20 TASER TRAINING CARTRIDGES 160785 SI1506856 1051 6250 OTHER SUPPLIES&PARTS PATROL SERVICES 01000 05 1,282.20 141949 11/17/2017 109117 BRIESACHER,MARILYN 24.00 KINGS ROOM CANCEL 160753 100617 1001 4670 RECREATION FEES-SENIOR CTR GENERAL FUND REVENUES 01000 01 24.00 141953 11/17/2017 109182 DAKOTA COMMUNICATIONS CENTER 18,533.34 DEC 17 DCC FEES 160752 FA2017-12 1051 6560 CONTRACTUAL SERVICES PATROL SERVICES 01000 05 9,266.66 DEC 17 DCC FEES 160752 FA2017-12 1060 6560 CONTRACTUAL SERVICES FIRE SERVICES 01000 06 27,800.00 141954 11/17/2017 110844 DAKOTA COUNTY FINANCIAL SRVS 249.21 SEPT'17 DIESEL FUEL 160758 00027672 1060 6272 FUEL FIRE SERVICES 01000 06 251.25 SEPT'17 DIESEL FUEL 160758 00027672 1072 6272 FUEL STREET MAINTENANCE 01000 08 108.48 SEPT'17 DIESEL FUEL 160758 00027672 1076 6272 FUEL NATURAL RESOURCES 01000 07 608.94 141955 11/17/2017 100147 DAKOTA COUNTY TECHNICAL COLLEGE 300.00 KUYPER PURSUIT REFRESHER 160635 184967 1051 6470 TRAINING&SUBSISTANCE PATROL SERVICES 01000 05 300.00 141956 11/17/2017 115754 DEAF INTERPRETER SERVICES,INC 318.75 SIGN LANGUAGE INTERPRETER 160750 17-22904 1095 6401 PROFESSIONAL SERVICES RECREATION PROGRAM SERVIID1000 09 1,402.50 SIGN LANGUAGE INTERPRETER 160751 17-22709 1095 6401 PROFESSIONAL SERVICES RECREATION PROGRAM SERVItD1000 09 1,721.25 141957 11/17/2017 100022 FARMINGTON PRINTING INC 261.00 OFFICE SUPPLIES 160775 11956 1010 6210 OFFICE SUPPLIES ADMINISTRATION 01000 01 261.00 141958 11/17/2017 110864 FASCHINGBAUER,BARB 24.00 KINGS ROOM CANCEL 160803 100617 1001 4670 RECREATION FEES-SENIOR CTR GENERAL FUND REVENUES 01000 01 R55CKS2 LOGIS601V CITY OF FARMINGTON 11/29/2017 9:16:08 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 2 10/1/2017 - 11/29/2017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 24.00 141962 11/17/2017 115967 HAAN,MARY 18.00 KINGS ROOM CANCEL 160805 100617 1001 4670 RECREATION FEES-SENIOR CTR GENERAL FUND REVENUES 01000 01 18.00 141964 11/17/2017 103329 HOTSY EQUIPMENT OF MINNESOTA 15.34 PRESSURE WASHER SOAP 160772 57287 1072 6220 EQUIP SUPPLIES&PARTS STREET MAINTENANCE 01000 08 194.04 PRESSURE WASHER SOAP 160772 57287 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 209.38 141966 11/17/2017 111773 INNOVATIVE OFFICE SOLUTIONS,LLC 1.64 OFFICE SUPPLIES 160783 IN1796148 1010 6210 OFFICE SUPPLIES ADMINISTRATION 01000 01 266.80 OFFICE SUPPLIES 160784 IN1795865 1010 6210 OFFICE SUPPLIES ADMINISTRATION 01000 01 249.96 COFFEE ORDER 160782 IN1796002 1093 6570 PROGRAMMING EXPENSE SENIOR CITIZEN SERVICES 01000 09 518.40 141967 11/17/2017 102895 I N TOXIMETERS 20.00 PBT MOUTHPIECE PRICE DIFF 160765 578898A 1051 6250 OTHER SUPPLIES&PARTS PATROL SERVICES 01000 05 20.00 141969 11/17/2017 115869 JEWELL,MARIA HOLLY 220.00 XABEAT CLASS SEPT'17 160798 XALITE OCT'17 1093 6401 PROFESSIONAL SERVICES SENIOR CITIZEN SERVICES 01000 09 220.00 141971 11/17/2017 115066 JOHNSON,LONELL 50.00 BUILDING OFFICIALS APPLICATION 160856 20171115-JOHNSON 1031 6470 TRAINING&SUBSISTANCE BUILDING INSPECTIONS 01000 07 50.00 141972 11/17/2017 113700 KINARD,SHARON 12.00 KINGS ROOM CANCEL 160754 100617 1001 467D RECREATION FEES-SENIOR CTR GENERAL FUND REVENUES 01000 01 12.00 141973 11/17/2017 106880 KOSKI,MARJORIE 12.00 KINGS ROOM CANCEL 160755 100617 1001 4670 RECREATION FEES-SENIOR CTR GENERAL FUND REVENUES 01000 01 12.00 141975 11/17/2017 114625 MASTER MECHANICAL,INC 501.00 FAN&THERMOSTAT REPAIR 160776 49037 1015 6505 EQUIPMENT REPAIR SERVICE CITY HALL 01000 01 1,567.73 FAN&THERMOSTAT REPAIR 160776 49037 1093 6505 EQUIPMENT REPAIR SERVICE SENIOR CITIZEN SERVICES 01000 09 2,068.73 141978 11/17/2017 108225 MUNICIPAL EMERGENCY SERVICES,INC 285.38- CREDIT FOR TURNOUT GEAR 160796 IN1113879 CR 1060 6290 1 TURNOUT GEAR FIRE SERVICES 01000 06 1,521.48 RENTED TURNOUT GEAR 160797 IN1159583 1060 6290 1 TURNOUT GEAR FIRE SERVICES 01000 06 1,236.10 141980 11/17/2017 102644 NORTHERN SAFETY TECHNOLOGY R55CKS2 LOGIS601V CITY OF FARMINGTON 11/29/2017 9:16:08 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 3 10/1/2017 - 11/29/2017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 49.50 SIREN CONTROL REPAIR 160786 44647 1051 6505 EQUIPMENT REPAIR SERVICE PATROL SERVICES 01000 05 49.50 141981 11/17/2017 115334 OLSON,BRUCE 100.00 SANTA TRAIN TREATS 160878 112517 1093 6401 PROFESSIONAL SERVICES SENIOR CITIZEN SERVICES 01000 09 100.00 141985 11/17/2017 115647 PERFECTION PLUS,INC. 75.00 EXTRA CLEANING SEPT&OCT'17 160756 1128378 1093 6401 PROFESSIONAL SERVICES SENIOR CITIZEN SERVICES 01000 09 75.00 141987 11/17/2017 103766 PITNEY BOWES-PURCHASE POWER 32.80 POSTAGE METER FEE&SUPPLIES 160767 8000....2569A 1010 6555 RENTAL OF EQUIPMENT ADMINISTRATION 01000 01 POSTAGE 32.80 141988 11/17/2017 113267 PROPHOENIX CORPORATION 525.00 CONSTANTINEAU PROPHOENIX CONF 160779 2017342 1050 6470 TRAINING&SUBSISTANCE POLICE ADMINISTRATION 01000 05 525.00 141989 11/17/2017 110760 PRO-TECH DESIGN SECURITY SOLUTIONS 2,060.20 PROPERTY ROOM CAMERAS 160787 82400 1052 6220 EQUIP SUPPLIES&PARTS INVESTIGATION SERVICES 01000 05 2,060.20 141992 11/17/2017 112561 RICOH USA,INC 963.43 COPIER LEASES NOV-DEC'17 160778 99608763 1010 6555 RENTAL OF EQUIPMENT ADMINISTRATION 01000 01 963.43 141993 11/17/2017 115982 RIPLEY,AMBER 36.50 SORR CONTRACT MOM&SON 160879 110417 1095 6401 PROFESSIONAL SERVICES RECREATION PROGRAM SERVIm1000 09 36.50 141998 11/17/2017 113850 SWANTEK,MARLENE 36.00 COMOAND KINGS ROOM CANCEL 160802 100617 1001 4670 RECREATION FEES-SENIOR CTR GENERAL FUND REVENUES 01000 01 36.00 142000 11/17/2017 100336 TOM'S MOBILE LOCK SERVICE 4.94 LOCK REPAIR 160799 20171009-MNT 1072 6515 BUILDING REPAIR SERVICE STREET MAINTENANCE 01000 08 BLDG 4.93 LOCK REPAIR 160799 20171009-MNT 1090 6515 BUILDING REPAIR SERVICE PARK MAINTENANCE 01000 09 BLDG 9.87 142004 11/17/2017 109457 WHEELER HARDWARE COMPANY 566.50 NORTHEAST DOOR REPAIR 160766 SP180773 1015 6515 BUILDING REPAIR SERVICE CITY HALL 01000 01 566.50 142009 11/22/2017 100058 ADVANCE AUTO PARTS R55CKS2 LOGIS601V CITY OF FARMINGTON 11/29/2017 9:16:08 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 4 10/1/2017 - 11/29/2017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 7.06 HVAC BELTS 160960 2131-ID-454831 1015 6240 BUILDING SUPPLIES&PARTS CITY HALL 01000 01 13.42 HVAC BELTS 160962 2131-ID-454996 1050 6505 EQUIPMENT REPAIR SERVICE POLICE ADMINISTRATION 01000 05 12.66 HVAC BELTS 160963 2131-ID-455199 1050 6505 EQUIPMENT REPAIR SERVICE POLICE ADMINISTRATION 01000 05 44.09 CIRCUIT BREAKER FOR SQUAD 71 160970 2131-ID-455796 1051 6230 VEHICLE SUPPLIES&PARTS PATROL SERVICES 01000 05 17.26 WIPER BLADES FOR 724 160969 2131-ID-455540 1070 6230 VEHICLE SUPPLIES&PARTS ENGINEERING SERVICES 01000 07 13.59 U-JOINT FOR 719 160967 2131-ID-454847 1072 6230 VEHICLE SUPPLIES&PARTS STREET MAINTENANCE 01000 08 2.17 HVAC BELTS 160961 2131-ID-454867 1072 6240 BUILDING SUPPLIES&PARTS STREET MAINTENANCE 01000 08 69.04 WIPER BLADES FOR PLOW TRUCKS 160972 2131-ID-456145 1073 6230 VEHICLE SUPPLIES&PARTS SNOW REMOVAL SERVICES 01000 08 26.59 02 SENSOR FOR DURANGO 160968 2131-ID-455502 1090 6230 VEHICLE SUPPLIES&PARTS PARK MAINTENANCE 01000 09 25.89 WIPER BLADES FOR 900 160969 2131-ID-455540 1090 6230 VEHICLE SUPPLIES&PARTS PARK MAINTENANCE 01000 09 6.83 HVAC BELTS 160961 2131-ID-454867 1090 6240 BUILDING SUPPLIES&PARTS PARK MAINTENANCE 01000 09 7.76 BELT FOR CHROMER 160966 2131-ID-454207 1090 6230 VEHICLE SUPPLIES&PARTS PARK MAINTENANCE 01000 09 37.83 FAN FOR WORKMAN 160949 2131-ID-456384 1090 6230 VEHICLE SUPPLIES&PARTS PARK MAINTENANCE 01000 09 19.08 HVAC BELTS 160964 2131-ID-455677 1093 6240 BUILDING SUPPLIES&PARTS SENIOR CITIZEN SERVICES 01000 09 303.27 142010 11/22/2017 103861 ALEX AIR APPARATUS INC 130.00 SCBAAIR TESTING 160906 34432 1060 6401 PROFESSIONAL SERVICES FIRE SERVICES 01000 06 130.00 SCBAAIR TESTING 160907 34431 1060 6401 PROFESSIONAL SERVICES FIRE SERVICES 01000 06 260.00 142011 11/22/2017 109681 AMUNDSON,JASON 8.54 MAAG ALL DAY TRAINING MEALS 161055 20171116- 1051 6470 TRAINING&SUBSISTANCE PATROL SERVICES 01000 05 AMUNDSON 8.54 142015 11/22/2017 110290 BOLTON&MENK,INC 780.00 ALDI SITE PLAN REVIEW 160905 0209457 1070 6401 PROFESSIONAL SERVICES ENGINEERING SERVICES 01000 07 780.00 142020 11/22/2017 100253 CAMPBELL KNUTSON 500.40 LEGAL BILL-OCT'17 160979 1852-000G OCT'17 1005 6403 LEGAL LEGISLATIVE CONTROL 01000 01 245.20 LEGAL BILL-OCT'17 160979 1852-000G OCT'17 1010 6403 LEGAL ADMINISTRATION 01000 01 238.50 LEGAL BILL-OCT'17 160979 1852-000G OCT'17 1011 6403 LEGAL HUMAN RESOURCES 01000 04 159.00 LEGAL BILL-OCT'17 160979 1852-000G OCT'17 1030 6403 LEGAL PLANNING&ZONING 01000 03 6,737.69 LEGAL BILL-OCT'17 160978 1852-999G OCT'17 1050 6403 LEGAL POLICE ADMINISTRATION 01000 05 757.10 LEGAL BILL-OCT'17 160979 1852-000G OCT'17 1050 6403 LEGAL POLICE ADMINISTRATION 01000 05 427.20 LEGAL BILL-OCT'17 160979 1852-000G OCT'17 1070 6403 LEGAL ENGINEERING SERVICES 01000 07 95.40 LEGAL BILL-OCT'17 160979 1852-000G OCT'17 1090 6403 LEGAL PARK MAINTENANCE 01000 09 9,160.49 142024 11/22/2017 100456 COMMERCIAL ASPHALT CO 129.58 ASPHALT 160759 171031 1072 6253 STREET MATERIALS STREET MAINTENANCE 01000 08 129.58 R55CKS2 LOGIS601V CITY OF FARMINGTON 11/29/2017 9:16:08 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 5 10/1/2017 - 11/29/2017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 142026 11/22/2017 103925 CONSTANTINEAU,JAMES 106.33 BOXES FOR CUBE&OFFICE MOVE 161056 20171108- 1050 6250 OTHER SUPPLIES&PARTS POLICE ADMINISTRATION 01000 05 CONSTANTINEAU 106.33 142027 11/22/2017 100581 CRAWFORD DOOR SALES CO 19.24 WASH BAY DOOR 160985 27738 1072 6515 BUILDING REPAIR SERVICE STREET MAINTENANCE 01000 08 19.24 WASH BAY DOOR 160985 27738 1090 6515 BUILDING REPAIR SERVICE PARK MAINTENANCE 01000 09 38.48 142028 11/22/2017 100081 DAKOTA COUNTY LUMBER COMPANY 154.44 RRP RINK BOARDS 160997 1710-681096 1090 6250 OTHER SUPPLIES&PARTS PARK MAINTENANCE 01000 09 154.44 142032 11/22/2017 100737 FARMINGTON PLUMBING&HEATING INC 1,070.00 WARMING HOUSE WATER HEATER 161025 15663 1090 6505 EQUIPMENT REPAIR SERVICE PARK MAINTENANCE 01000 09 1,070.00 142033 11/22/2017 108760 FIRE SAFETY USA INC 55.00 LEATHER FRONT HELMET-WISE 160973 104945 1060 6290 1 TURNOUT GEAR FIRE SERVICES 01000 06 55.00 142036 11/22/2017 102071 GOODYEAR TIRE&RUBBER COMPANY,THE 602.95 LABOR TO CHANGE GRADER TIRES 160994 124-1086746 1072 6230 VEHICLE SUPPLIES&PARTS STREET MAINTENANCE 01000 08 602.95 142042 11/22/2017 100597 INDEPENDENT BLACK DIRT CO INC 289.00 DIRT FOR BALL FIELDS 160984 22524-22618 1090 6255 LANDSCAPING MATERIALS PARK MAINTENANCE 01000 09 289.00 142043 11/22/2017 111773 INNOVATIVE OFFICE SOLUTIONS,LLC 12.09 OFFICE SUPPLIES 160986 IN1810067 1010 6210 OFFICE SUPPLIES ADMINISTRATION 01000 01 397.61 OFFICE SUPPLIES 160987 IN1809918 1010 6210 OFFICE SUPPLIES ADMINISTRATION 01000 01 133.08 OFFICE SUPPLIES 160995 IN1809927 1050 6210 OFFICE SUPPLIES POLICE ADMINISTRATION 01000 05 542.78 142047 11/22/2017 102732 KOHLBECK,MISSIE 168.01 RRC HOLIDAY SHOP SUPPLIES 161057 20171121- 1093 6570 PROGRAMMING EXPENSE SENIOR CITIZEN SERVICES 01000 09 KOHLBECK 168.01 142051 11/22/2017 114625 MASTER MECHANICAL,INC 1,476.91 HEATING SYSTEM REPAIRS 160996 49144 1050 6515 BUILDING REPAIR SERVICE POLICE ADMINISTRATION 01000 05 760.00 HVAC SERVICE 161014 49358 1060 6515 BUILDING REPAIR SERVICE FIRE SERVICES 01000 06 2,236.91 142053 11/22/2017 112331 MIDWEST ELECTRICAL TECHNOLOGIES 4,573.34 NOV'17 PAY REQUEST 161031 NOV'17 PAY REQUES11000 2020 CONTRACTS PAYABLE GENERAL FUND BALANCE SHE®1000 R55CKS2 LOGIS601V CITY OF FARMINGTON 11/29/2017 9:16:08 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 6 10/1/2017 - 11/29/2017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 4,573.34 142054 11/22/2017 101313 MN DEPT OF LABOR&INDUSTRY 100.00 ELEVATOR PERMIT 160974 ALR00787001 1015 6515 BUILDING REPAIR SERVICE CITY HALL 01000 01 100.00 142056 11/22/2017 115981 MONTERREL,EGAR 150.00 RENTAL DEPOSIT RETURN 160893 111117 1000 2255 DEPOSITS PAYABLE GENERAL FUND BALANCE SHE®1000 150.00 142057 11/22/2017 113031 NRG RELIABILITY SOLUTIONS LLC 1,611.48 LAW ENFORCE CNTR ELEC OCT'17 160930 3346-1711 1050 6422 ELECTRIC POLICE ADMINISTRATION 01000 05 60.17 CMF ELEC OCT'17 160959 3347-1711 1072 6422 ELECTRIC STREET MAINTENANCE 01000 08 120.30 CMF ELEC OCT'17 160959 3347-1711 1090 6422 ELECTRIC PARK MAINTENANCE 01000 09 1,791.95 142060 11/22/2017 100093 PELLICCI HARDWARE&RENTAL 169.94 INVESTIGATION RESPERATORS 160901 16989A 1060 6220 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 169.94 142062 11/22/2017 110398 PITNEY BOWES GLOBAL FINANCIAL SRV LLC 379.00 POSTAGE METER DEC'17 160768 3101689181 1010 6555 RENTAL OF EQUIPMENT ADMINISTRATION 01000 01 379.00 142066 11/22/2017 114603 RED RIVER FLAGS 90.89 FLAGS 161016 2647 1015 6240 BUILDING SUPPLIES&PARTS CITY HALL 01000 01 43.28 FLAGS 161016 2647 1050 6250 OTHER SUPPLIES&PARTS POLICE ADMINISTRATION 01000 05 108.20 FLAGS 161016 2647 1060 6240 BUILDING SUPPLIES&PARTS FIRE SERVICES 01000 06 15.15 FLAGS 161016 2647 1072 6240 BUILDING SUPPLIES&PARTS STREET MAINTENANCE 01000 08 47.61 FLAGS 161016 2647 1090 6240 BUILDING SUPPLIES&PARTS PARK MAINTENANCE 01000 09 21.64 FLAGS 161016 2647 1093 6240 BUILDING SUPPLIES&PARTS SENIOR CITIZEN SERVICES 01000 09 326.77 142067 11/22/2017 112561 RICOH USA,INC 187.39 COPIER LEASES NOV-DEC'17 160900 99658996 1010 6555 RENTAL OF EQUIPMENT ADMINISTRATION 01000 01 187.39 142068 11/22/2017 112632 RICOH USA,INC 689.58 COPIER MAINTENANCE OCT-NOV'17 161017 5051268299 1011 6505 EQUIPMENT REPAIR SERVICE HUMAN RESOURCES 01000 04 689.58 142069 11/22/2017 115968 RIVERTOWN MULTIMEDIA 49.45 LEGAL NOTICE 160999 CL20092517 1010 6455 LEGAL NOTICES PUBLICATIONS ADMINISTRATION 01000 01 22.48 LEGAL NOTICE 161000 CL20091999 1010 6455 LEGAL NOTICES PUBLICATIONS ADMINISTRATION 01000 01 22.48 LEGAL NOTICE 161001 CL20091996 1010 6455 LEGAL NOTICES PUBLICATIONS ADMINISTRATION 01000 01 26.97 PUBLIC HEARING NOTICE 160902 CL20091936 1030 6455 LEGAL NOTICES PUBLICATIONS PLANNING&ZONING 01000 03 26.97 PUBLIC HEARING NOTICE 160903 CL20091935 1030 6455 LEGAL NOTICES PUBLICATIONS PLANNING&ZONING 01000 03 R55CKS2 LOGIS601V CITY OF FARMINGTON 11/29/2017 9:16:08 Note. Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 7 10/1/2017 - 11/29/2017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 26.97 PUBLIC HEARING NOTICE 160904 CL20091934 1030 6455 LEGAL NOTICES PUBLICATIONS PLANNING&ZONING 01000 03 175.32 142070 11/22/2017 113189 SCHLOMKA'S PORTABLE RSTRMS&WASH 220.00 PORTABLE RESTROOM 161013 3950 1090 6250 OTHER SUPPLIES&PARTS PARK MAINTENANCE 01000 09 200.00 PORTABLE RESTROOM 161015 3951 1090 6250 OTHER SUPPLIES&PARTS PARK MAINTENANCE 01000 09 420.00 142071 11/22/2017 115905 SEYFERT,SAM 36.50 SORR INSTRUCTOR-MOM&SON 160892 110417 1095 6401 PROFESSIONAL SERVICES RECREATION PROGRAM SERVIO1000 09 36.50 142074 11/22/2017 100286 THOMSON REUTERS-WEST 137.81 PD CLEAR SUBSCRIPTION OCT'17 160975 837131217 1052 6401 PROFESSIONAL SERVICES INVESTIGATION SERVICES 01000 05 137.81 142084 11/22/2017 108446 ASPEN MILLS 152.36 UNIFORM ALLOWANCE R.FISCHER 161063 206251 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 200.00 UNIFORM ALLOWANCE SCHMITZ 161064 206250 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 199.15 UNIFORM ALLOWANCE STRUMBERG 161065 206245 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 198.65 UNIFORM ALLOWANCE MARTIN 161067 206252 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 124.95 UNIFORM ALLOWANCE BOLTON 161068 206249 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 200.00 UNIFORM ALLOWANCE D.SATHER 161069 206247 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 200.00 UNIFORM ALLOWANCE MURPHREE 161070 206248 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 79.95 UNIFORM ALLOWANCE KEVIN ROACH 161071 206246 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 35.00 UNIFORM ALLOWANCE GREINER 161072 206253 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 1,390.06 142090 11/22/2017 107414 JEFFERSON FIRE&SAFETY INC 2,060.90 NEW HOSE 161058 239673 1060 6220 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 2,060.90 142092 11/22/2017 114625 MASTER MECHANICAL,INC 176.00 STATION 2 HEAT REPAIR 161081 49145 1060 6505 EQUIPMENT REPAIR SERVICE FIRE SERVICES 01000 06 176.00 142095 11/22/2017 113266 UNIVERSAL ATHLETIC SERVICE,INC 191.15 TENNIS CAMP T-SHIRTS 161060 150-0031760-02 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIm1000 09 191.15 142096 11/22/2017 113269 UNIVERSITY OF MN,REGENTS OF 400.00 NOV'17 RANGE USE FOR PD 161073 0430003601 1051 6470 TRAINING&SUBSISTANCE PATROL SERVICES 01000 05 400.00 20171021 10/30/2017 102160 CARDMEMBER SERVICES 19.92 AUG'17 CELL PHONE SERVICE 160155 7444-4820-9/26 1011 6412 CELLULAR PHONES HUMAN RESOURCES 01000 04 159.00 EXCEL MACRO CLASS 160006 7444-6552-10/2 1021 6470 TRAINING&SUBSISTANCE GENERALACCOUNTING 01000 02 R55CKS2 LOGIS601V CITY OF FARMINGTON 11/29/2017 9:16:08 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 8 10/1/2017 - 11/29/2017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 14.65 MEET THE MAYORS REAL ESTATE 160104 8032-8888-9/20 1030 6470 TRAINING&SUBSISTANCE PLANNING&ZONING 01000 03 172.14 AUG'17 CELL PHONE SERVICE 160155 7444-4820-9/26 1031 6412 CELLULAR PHONES BUILDING INSPECTIONS 01000 07 12.95 ECLOTH CLEANING CLOTH 160095 1726-5636-9/29 1050 6250 OTHER SUPPLIES&PARTS POLICE ADMINISTRATION 01000 05 25.00 LINDQUIST SEX TRAFFICKING TRNG 160084 1726-9920-9/21 1050 6470 TRAINING&SUBSISTANCE POLICE ADMINISTRATION 01000 05 92.05 PROPHOENIX CONF HOTEL CONSTANT 160086 1726-7920-9/20 1050 6470 TRAINING&SUBSISTANCE POLICE ADMINISTRATION 01000 05 92.05 PROPHOENIX CONF HOTEL CONSTANT 160087 1726-7896-9/20 1050 6470 TRAINING&SUBSISTANCE POLICE ADMINISTRATION 01000 05 92.05 PROPHOENIX CONF HOTEL MAILHOT 160088 1726-7904-9/20 1050 6470 TRAINING&SUBSISTANCE POLICE ADMINISTRATION 01000 05 35.99 PROJECTOR BULB 160080 1726-1898-9/12 1050 6250 OTHER SUPPLIES&PARTS POLICE ADMINISTRATION 01000 05 6.41- RETIREMENT PARTY SUPPLIES CM 160762 1726-8011-10/20 1050 6250 OTHER SUPPLIES&PARTS POLICE ADMINISTRATION 01000 05 560.16 AUG'17 DATA CARDS 160156 7444-8283-9/18 1051 6412 CELLULAR PHONES PATROL SERVICES 01000 05 1,302.43 AUG'17 CELL PHONE SERVICE 160155 7444-4820-9/26 1051 6412 CELLULAR PHONES PATROL SERVICES 01000 05 728.00 FIREARMS CLEARING TRAP 160176 4021-0783-9/13 1051 6250 OTHER SUPPLIES&PARTS PATROL SERVICES 01000 05 58.82 GUN OIL 160177 4021-8840-9/11 1051 6250 OTHER SUPPLIES&PARTS PATROL SERVICES 01000 05 75.00 BELLOWS DMT REFRESHER 160179 1726-6593-9/27 1051 6470 TRAINING&SUBSISTANCE PATROL SERVICES 01000 05 75.00 HENDRICKSON DMT REFRESHER 160180 1726-6585-9/27 1051 6470 TRAINING&SUBSISTANCE PATROL SERVICES 01000 05 57.79 SPIT SHIELDS 160081 1726-5218-9/11 1051 6250 OTHER SUPPLIES&PARTS PATROL SERVICES 01000 05 75.00 ZAJAC DMT REFRESHER 160082 1726-9698-9/19 1051 6470 TRAINING&SUBSISTANCE PATROL SERVICES 01000 05 75.00 SAUTER DMT REFRESHER 160083 1726-9680-9/19 1051 6470 TRAINING&SUBSISTANCE PATROL SERVICES 01000 05 250.00 SAUTER IMPACT/INFLUENCE TRNG 160085 1726-6635-9/27 1051 6470 TRAINING&SUBSISTANCE PATROL SERVICES 01000 05 78.95 NEW OFFICER CARDS LAMBERT 160077 1726-8207-9/27 1051 6290 UNIFORMS&CLOTHING PATROL SERVICES 01000 05 29.98 (PHONE CASES 160078 1726-0509-9/20 1051 6412 CELLULAR PHONES PATROL SERVICES 01000 05 90.00 HARRISON LICENSE 160090 1726-4158-10/5 1051 6460 SUBSCRIPTIONS&DUES PATROL SERVICES 01000 05 2.24 HARRISON LICENSE FEE 160092 1726-4892-10/5 1051 6460 SUBSCRIPTIONS&DUES PATROL SERVICES 01000 05 1 90.00 REUBEN LICENSE 160093 1726-4166-10/5 1051 6460 SUBSCRIPTIONS&DUES PATROL SERVICES 01000 05 2.24 REUBEN LICENSE FEE 160094 1726-4900-10/5 1051 6460 SUBSCRIPTIONS&DUES PATROL SERVICES 01000 05 35.97 SHIPPING LABELS 160079 1726-8832-9/13 1052 6250 OTHER SUPPLIES&PARTS INVESTIGATION SERVICES 01000 05 15.95 FIRE STAMPS 160089 1726-6370-9/28 1060 6250 OTHER SUPPLIES&PARTS FIRE SERVICES 01000 06 50.74 AUG'17 CELL PHONE SERVICE 160155 7444-4820-9/26 1060 6412 CELLULAR PHONES FIRE SERVICES 01000 06 149.98 SCBA FIT TEST SUPPLIES 160009 6125-0406-9/15 1060 6220 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 315.11 AUG'17 DATA CARDS 160156 7444-8283-9/18 1060 6412 CELLULAR PHONES FIRE SERVICES 01000 06 300.00 MNDOT TRAINGING CLASS-RICH 160070 6976-2087-10/5 1070 6470 TRAINING&SUBSISTANCE ENGINEERING SERVICES 01000 07 230.86 AUG'17 CELL PHONE SERVICE 160155 7444-4820-9/26 1070 6412 CELLULAR PHONES ENGINEERING SERVICES 01000 07 21.28 FILTERS 159997 1734-4613-9/20 1072 6220 EQUIP SUPPLIES&PARTS STREET MAINTENANCE 01000 08 269.29 FILTERS 159997 1734-4613-9/20 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 450.76 KROMER PUMP 160067 1734-6764-9/8 1090 6505 EQUIPMENT REPAIR SERVICE PARK MAINTENANCE 01000 09 342.40 AUG'17 CELL PHONE SERVICE 160155 7444-4820-9/26 1090 6412 CELLULAR PHONES PARK MAINTENANCE 01000 09 6.32 BAKING SODA 160014 3893-6370-9/15 1093 6242 CLEANING SUPPLIES SENIOR CITIZEN SERVICES 01000 09 10.71 35TH ANNIVERSARY 159998 3893-1267-9/15 1093 6570 PROGRAMMING EXPENSE SENIOR CITIZEN SERVICES 01000 09 69.47 35TH ANNIVERSARY CAKE 160000 3893-5942-9/11 1093 6570 PROGRAMMING EXPENSE SENIOR CITIZEN SERVICES 01000 09 15.00 35TH ANNIVERSARY SUPPLIES 160001 3893-5453-9/8 1093 6570 PROGRAMMING EXPENSE SENIOR CITIZEN SERVICES 01000 09 34.35 35TH ANNIVERSARY PINNEAPPLES 160002 3893-5747-9/11 1093 6570 PROGRAMMING EXPENSE SENIOR CITIZEN SERVICES 01000 09 77.65 35TH ANNIVERSARY SUPPLIES 160003 3893-3567-9/8 1093 6570 PROGRAMMING EXPENSE SENIOR CITIZEN SERVICES 01000 09 R55CKS2 LOGIS601V CITY OF FARMINGTON 11/29/2017 9:16:08 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 9 10/1/2017 - 11/29/2017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 22.19 35TH ANNIVERSARY BEVERAGES 160004 3893-4430-9/8 1093 6570 PROGRAMMING EXPENSE SENIOR CITIZEN SERVICES 01000 09 86.94 AUG'17 CELL PHONE SERVICE 160155 7444-4820-9/26 1094 6412 CELLULAR PHONES PARK&RECREATION ADMIN 01000 09 70.02 AUG'17 DATA CARDS 160156 7444-8283-9/18 1094 6412 CELLULAR PHONES PARK&RECREATION ADMIN 01000 09 19.48 FALL PROGRAMS 160013 3893-8701-10/4 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIO1000 09 347.58 FLAG FOOTBALL AWARDS 160007 6984-1295-9/26 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIO1000 09 7,202.05 20171103 11/3/2017 100085 DAKOTA ELECTRIC ASSOCIATION 5.00 CIV DEF SIREN ELEC SEPT'17 160017 198227-1 SEPT'17 1054 6422 ELECTRIC EMERGENCY MGMT SERVICES 01000 05 5.00 CIV DEF SIREN ELEC SEPT'17 160018 226095-8 SEPT'17 1054 6422 ELECTRIC EMERGENCY MGMT SERVICES 01000 05 580.14 FIRE DEPT 2 ELEC SEPT'17 159926 397195-9 SEPT'17 1060 6422 ELECTRIC FIRE SERVICES 01000 06 30.20 TUNNEL LIGHT ELEC SEPT'17 160020 546832-7 SEPT'17 1090 6422 ELECTRIC PARK MAINTENANCE 01000 09 620.34 20171104 11/1/2017 100394 XCEL ENERGY 4.30 CITY GARAGE ELEC SEPT'17 160076 51-4874005-0 1072 6422 ELECTRIC STREET MAINTENANCE 01000 08 SEPT'17 7.17 CITY GARAGE ELEC SEPT'17 160076 51-4874005-0 1090 6422 ELECTRIC PARK MAINTENANCE 01000 09 SEPT'17 11.47 20171105 11/7/2017 108980 MINNESOTA ENERGY RESOURCES CORPORATION 27.91 208TH ST WARM HOUSE GAS OCT'17 160452 0506537581 OCT'17 1090 6422 ELECTRIC PARK MAINTENANCE 01000 09 27.91 20171108 11/10/2017 100394 XCEL ENERGY 2,918.95 CTY HALL/FRT BLDG ELEC OCT'17 160475 51-4874007-2 1015 6422 ELECTRIC CITY HALL 01000 01 OCT'17 526.03 PARK/WARM HOUSE ELEC OCT'17 160475 51-4874007-2 1090 6422 ELECTRIC PARK MAINTENANCE 01000 09 OCT'17 865.70 SENIOR CENTER ELEC OCT'17 160475 51-4874007-2 1093 6422 ELECTRIC SENIOR CITIZEN SERVICES 01000 09 OCT'17 112.07 POOL 160475 51-4874007-2 1097 6422 ELECTRIC SWIMMING POOL OPERATIONS 01000 09 OCT'17 4,422.75 20171109 11/17/2017 100394 XCEL ENERGY 24.02 DUNB AVE WARM HOUS ELEC OCT'17 160378 51-9027188-0 1090 6422 ELECTRIC PARK MAINTENANCE 01000 09 OCT'17 24.02 20171110 11/20/2017 108980 MINNESOTA ENERGY RESOURCES CORPORATION 441.08 POLICE DEPT GAS OCT'17 160690 0505974444 OCT'17 1050 6421 MUNICIPAL SERVICES POLICE ADMINISTRATION 01000 05 112.78 FIRE DEPT STATION 1 GAS OCT'17 161083 0506565319 OCT'17 1060 6423 NATURAL GAS FIRE SERVICES 01000 06 244.02 FIRE DEPT STATION 2 GAS OCT'17 161084 0505001779 OCT'17 1060 6423 NATURAL GAS FIRE SERVICES 01000 06 R55CKS2 LOGIS601V CITY OF FARMINGTON 11/29/2017 9:16:08 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 10 10/1/2017 - 11/29/2017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 61.11 CMF GAS OCT'17 160576 0502362190 OCT'17 1072 6423 NATURAL GAS STREET MAINTENANCE 01000 08 4.48 1ST STREET GARAGE GAS OCT'17 160577 0505547424 OCT'17 1072 6423 NATURAL GAS STREET MAINTENANCE 01000 08 6.97 1ST STREET GARAGE GAS OCT'17 160577 0505547424 OCT'17 1090 6423 NATURAL GAS PARK MAINTENANCE 01000 09 95.06 CMF GAS OCT'17 160576 0502362190 OCT'17 1090 6423 NATURAL GAS PARK MAINTENANCE 01000 09 189.58 RRC GAS OCT'17 160455 0507948331 OCT'17 1093 6423 NATURAL GAS SENIOR CITIZEN SERVICES 01000 09 1,155.08 20171111 11/22/2017 108980 MINNESOTA ENERGY RESOURCES CORPORATION 45.00 MUNICIPAL POOL GAS OCT'17 160579 0506104181 OCT'17 1097 6423 NATURAL GAS SWIMMING POOL OPERATIONS 01000 09 12.60 MUNICIPAL POOL GAS OCT'17 160580 0504796591 OCT'17 1097 6423 NATURAL GAS SWIMMING POOL OPERATIONS 01000 09 57.60 20171112 11/20/2017 111046 VOYAGER FLEET SYSTEMS INC 3.63 OCT'17 FUEL BLDG MAINT 160570 OCT'17 869088237 1015 6272 FUEL CITY HALL 01000 01 BLDG MNT 68.35 OCT'17 FUEL BLDG INSP 160530 OCT'17 869088237 1031 6272 FUEL BUILDING INSPECTIONS 01000 07 BLDG INS 2.18 OCT'17 FUEL BLDG MAINT 160570 OCT'17 869088237 1050 6272 FUEL POLICE ADMINISTRATION 01000 05 BLDG MNT 2,771.51 OCT'17 FUEL POLICE 160581 OCT'17 869088237 1051 6272 FUEL PATROL SERVICES 01000 05 POLICE 35.57 OCT'17 FUEL BLDG MAINT 160570 OCT'17 869088237 1060 6272 FUEL FIRE SERVICES 01000 06 BLDG MNT 1,088.91 OCT'17 FUEL FIRE 161082 OCT'17 869088237 1060 6272 FUEL FIRE SERVICES 01000 06 FIRE 162.46 OCT'17 FUEL ENGINEERING 160453 OCT'17 869088237 1070 6272 FUEL ENGINEERING SERVICES 01000 07 ENGIN .73 OCT'17 FUEL BLDG MAINT 160570 OCT'17 869088237 1072 6272 FUEL STREET MAINTENANCE 01000 08 BLDG MNT 501.73 OCT'17 FUEL ST/SNOW 160593 OCT'17 869088237 1072 6272 FUEL STREET MAINTENANCE 01000 08 ST/SNOW 47.11 OCT'17 FUEL NAT RES 160454 OCT'17 869088237 1076 6272 FUEL NATURAL RESOURCES 01000 07 NAT RES 9.18 OCT'17 FUEL BLDG MAINT 160570 OCT'17 869088237 1090 6272 FUEL PARK MAINTENANCE 01000 09 BLDG MNT 734.08 OCT'17 FUEL PARKS 160571 OCT'17 869088237 1090 6272 FUEL PARK MAINTENANCE 01000 09 PARKS 61.61 OCT'17 FUEL RECREATION 160456 OCT'17 869088237 1093 6272 FUEL SENIOR CITIZEN SERVICES 01000 09 REC 6.53 OCT'17 FUEL BLDG MAINT 160570 OCT'17 869088237 1093 6272 FUEL SENIOR CITIZEN SERVICES 01000 09 BLDG MNT 47.34 OCT'17 FUEL RECREATION 160456 OCT'17 869088237 1094 6272 FUEL PARK&RECREATION ADMIN 01000 09 REC R55CKS2 LOGIS601V CITY OF FARMINGTON 11/29/2017 9:16:08 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 11 10/1/2017 - 11/29/2017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 5,540.92 01000 GENERAL FUND 93,271.99 20171021 10/30/2017 102160 CARDMEMBER SERVICES 544.50 XCELIGENT 4TH QTR 2017 160091 8032-8889-9/18 2000 6570 PROGRAMMING EXPENSE HRA/ECONOMIC DEVELOPMENTJ2000 03 40.00 DCR GOOD DAY DAKOTA COUNTY OCT 160103 8032-8169-9/20 2000 6470 TRAINING&SUBSISTANCE HRA/ECONOMIC DEVELOPMENT12000 03 45.00 MNCAR EXPO 2017 160105 8032-3546-9/19 2000 6470 TRAINING&SUBSISTANCE HRA/ECONOMIC DEVELOPMENO2000 03 629.50 20171109 11/17/2017 100394 XCEL ENERGY 19.72 ELM ST EDA SIGN ELEC OCT'17 160340 51-4874009-4 2000 6422 ELECTRIC HRA/ECONOMIC DEVELOPMEN D2000 03 OCT'17 19.72 02000 HRA/ECONOMIC DEVELOPMENT 649.22 142020 11/22/2017 100253 CAMPBELL KNUTSON 27.80 LEGAL BILL-OCT'17 160977 1852-003G OCT'17 2100 6403 LEGAL POLICE FORFEITURES 02100 05 27.80 02100 POLICE DONATIONS&FORFEITURES 27.80 141952 11/17/2017 112888 COOL AIR MECHANICAL,INC 683.39 WATER TANK REPAIR 160800 8336 2502 6505 EQUIPMENT REPAIR SERVICE ICE ARENA OPERATIONS EXPE 02500 09 683.39 141975 11/17/2017 114626 MASTER MECHANICAL,INC 3,094.01 FAN&THERMOSTAT REPAIR 160776 49037 2502 6505 EQUIPMENT REPAIR SERVICE ICE ARENA OPERATIONS EXPE 02500 09 220.00 HVAC REPAIR 160801 49277 2502 6505 EQUIPMENT REPAIR SERVICE ICE ARENA OPERATIONS EXPE 02500 09 3,314.01 141982 11/17/2017 108094 PAPCO INC 123.00 FLOOR SCRUBBER DISK 160771 103685 2502 6505 EQUIPMENT REPAIR SERVICE ICE ARENA OPERATIONS EXPE 02500 09 123.00 142066 11/22/2017 114603 RED RIVER FLAGS 97.38 FLAGS 161016 2647 2502 6240 BUILDING SUPPLIES&PARTS ICE ARENA OPERATIONS EXPE 02500 09 97.38 142085 11/22/2017 100013 BECKER ARENA PRODUCTS INC 271.03 BOARD CLOSER PARTS 161066 1010463 2502 6505 EQUIPMENT REPAIR SERVICE ICE ARENA OPERATIONS EXPE 02500 09 271.03 20171108 11/10/2017 100394 XCEL ENERGY R55CKS2 LOGIS601V CITY OF FARMINGTON 11/29/2017 9:16:08 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 12 10/1/2017 - 11/29/2017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 5,124.07 ICE ARENA ELEC OCT'17 160475 51-4874007-2 2502 6422 ELECTRIC ICE ARENA OPERATIONS EXPE 02500 09 OCT'17 5,124.07 20171110 11/20/2017 108980 MINNESOTA ENERGY RESOURCES CORPORATION 1,074.03 ARENA GAS OCT'17 160578 0502346011 OCT'17 2502 6423 NATURAL GAS ICE ARENA OPERATIONS EXPE 02500 09 1,074.03 20171112 11/20/2017 111046 VOYAGER FLEET SYSTEMS INC 7.26 OCT'17 FUEL BLDG MAINT 160570 OCT'17 869088237 2502 6272 FUEL ICE ARENA OPERATIONS EXPE 02500 09 BLDG MNT 7.26 02500 ICE ARENA 10,694.17 20171021 10/30/2017 102160 CARDMEMBER SERVICES 118.00 EMS RECERT CLASS DINNER 160005 8040-0038-10/3 4302 6470 TRAINING&SUBSISTANCE FIRE RELIEF 04300 06 138.24 MONTHLY OFFICER MEETING 160010 6125-9069-9/18 4302 6470 TRAINING&SUBSISTANCE FIRE RELIEF 04300 06 68.00 NIMS 300 CLASS DINNER 160011 6125-6769-9/29 4302 6470 TRAINING&SUBSISTANCE FIRE RELIEF 04300 06 157.06 BULK ICE BAGS 160012 1228-1143-9/28 4302 6470 TRAINING&SUBSISTANCE FIRE RELIEF 04300 06 73.91 EMS RECERT CLASS DINNER 160102 8040-0011-10/4 4302 6470 TRAINING&SUBSISTANCE FIRE RELIEF 04300 06 555.21 04300 FIRE CAPITAL PROJECTS 555.21 20171021 10/30/2017 102160 CARDMEMBER SERVICES 100.00 GARAGE SALE CLASSIFIED AD 159999 3893-4517-9/14 4502 6570 PROGRAMMING EXPENSE RRC CAPITAL IMPROVEMENT F 04500 09 100.00 04500 RECREATION CAPITAL PROJECTS 100.00 142015 11/22/2017 110290 BOLTON&MENK,INC 200.00 FAIRHILL ENGINEERING REVIEW 160894 0209455 4600 2256 70201 DEVELOPMENT ESCROWS PRIVATE CAPITAL PROJECTS 04600 07 560.00 REGETTA PLAT REVIEW 160895 0209456 4600 2256 70101 DEVELOPMENT ESCROWS PRIVATE CAPITAL PROJECTS 04600 07 760.00 142020 11/22/2017 100253 CAMPBELL KNUTSON 1,641.20 LEGAL BILL-OCT'17 161024 1852-055G OCT'17 4600 2256 70201 DEVELOPMENT ESCROWS PRIVATE CAPITAL PROJECTS 04600 07 1,641.20 04600 PRIVATE CAPITAL PROJECTS 2,401.20 142015 11/22/2017 110290 BOLTON&MENK,INC 1,678.50 TRANSPORTATION PLAN UPDATE 160896 0209468 5711 6401 10001 PROFESSIONAL SERVICES STREET MAINTENANCE 05700 R55CKS2 LOGIS601V CITY OF FARMINGTON 11/29/2017 9:16:08 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 13 10/1/2017 - 11/29/2017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 1,678.50 05700 MAINTENANCE FUND 1,678.50 141939 11/17/2017 112653 360 COMMUNITIES 4,749.65 OCT'17 360 COMM FUNDRSR 160764 OCT'17 360 COMM 6100 2255 DEPOSITS PAYABLE LIQUOR OPERATIONS 06100 02 FUNDRSR 4,749.65 141942 11/17/2017 113303 ARTISAN BEER COMPANY 647.00 BEER ORDER 160691 3219887 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 32.00 BENT PADDLE BEER ORDER 160692 3219888 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 64.00 BENT PADDLE BEER ORDER 160722 3219978 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 203.75 BEER ORDER 160723 3219977 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 622.00 BEER ORDER 160839 3221434 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 188.75 BEER ORDER 160857 3221554 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 205.00 BENT PADDLE BEER ORDER 160858 3221433 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,962.50 141945 11/17/2017 111280 BERNICK'S WINE 152.35 BEER ORDER 160693 391643 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 152.35 141946 11/17/2017 115569 BOURGET IMPORTS,LLC 780.00 WINE ORDER 160724 146252 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 780.00 141947 11/17/2017 114472 BREAKTHRU BEVERAGE MN BEER,LLC 2,859.35 BEER ORDER 160694 1090783712 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,460.20 BEER ORDER 160725 1090783711 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 9,142.60 BEER ORDER 160859 1090786272 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 14,462.15 141948 11/17/2017 114471 BREAKTHRU BEVERAGE MN WINE&SPIRITS 1,161.56 LIQUOR&SPIRITS ORDER 160695 1080715481 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 607.25 WINE ORDER 160696 1080715482 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 863.15 LIQUOR&SPIRITS ORDER 160726 1080715480 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 2,090.75 LIQUOR&SPIRITS ORDER 160727 1080715479 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,084.41 LIQUOR&SPIRITS ORDER 160860 1080718891 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 5,807.12 141951 11/17/2017 100071 COLLEGE CITY BEVERAGE INC 502.95 GREY GOOSE LIQUOR ORDER 160697 367651 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 522.95- GREY GOOSE LIQUOR CREDIT 160698 367650 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 5,242.15 BEER ORDER 160699 100-1259 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 R55CKS2 LOGIS601V CITY OF FARMINGTON 11/29/2017 9:16:08 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 14 10/1/2017 - 11/29/2017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 30.00- BEER ORDER&CREDIT 160700 100-1260 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 5,246.50 BEER ORDER 160728 100-1243 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 42.00- BEER ORDER&CREDIT 160729 100-1261 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 17.60- BUD LIGHT LIME CREDIT 160730 21-0314 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 10,379.05 141959 11/17/2017 108507 FLAHERTY'S HAPPY TYME COMPANY 19.00- LIQUOR MIXES&SUPPLIES CREDIT 160840 32883 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 114.00 LIQUOR MIXES&SUPPLIES 160841 33875 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 114.00 LIQUOR MIXES&SUPPLIES 160861 33876 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 209.00 141961 11/17/2017 100027 GREAT LAKES COCA-COLA DISTRIBUTION,LLC 558.52 POP ORDER 160682 3608204357 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 558.52 141963 11/17/2017 100074 HOHENSTEINS INC 379.75 BEER ORDER 160701 928275 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 587.35 BEER ORDER 160731 928274 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 423.00 BEER ORDER 160842 929860 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 290.00 BEER ORDER 160863 929859 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,680.10 141965 11/17/2017 113417 INDEED BREWING COMPANY 140.00 DAY TRIPPER BEER ORDER 160702 57620 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 140.00 141968 11/17/2017 109846 J J TAYLOR DISTRIBUTING CO OF MN INC 4,256.55 BEER ORDER 160703 2753348 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,588.90 BEER ORDER 160732 2753349 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 3,019.45 BEER ORDER 160843 2753379 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,509.15 BEER ORDER 160864 2753380 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 11,374.05 141970 11/17/2017 100033 JOHNSON BROTHERS LIQUOR CO 2,482.96 LIQUOR&SPIRITS ORDER 160704 5862738 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 3,735.23 WINE ORDER 160705 5862737 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 211.02 LIQUOR&SPIRITS ORDER 160706 5862736 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 176.84 WINE ORDER 160707 5862735 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 96.32 LIQUOR&SPIRITS ORDER 160708 5862734 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 800.59 LIQUOR&SPIRITS ORDER 160709 5862733 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 203.02 TIPPY COW LIQUOR ORDER 160710 5862732 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,244.04 WINE ORDER 160711 5862731 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 536.55 SVEDKA VODKA VARIETY ORDER 160712 5862730 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 316.03 SVEDKA VODKA VARIETY ORDER 160733 5862840 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 R55CKS2 LOGIS601V CITY OF FARMINGTON 11/29/2017 9:16:08 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 15 10/1/2017 - 11/29/2017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 1,100.16 WINE ORDER 160734 5862841 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,916.67 LIQUOR&SPIRITS ORDER 160735 5862842 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 38.51 CUERVO MIX MARG LIME 160736 5862843 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 687.48 WINE ORDER 160737 5862844 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 226.02 LIQUOR&SPIRITS ORDER 160738 5862845 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 3,374.92 WINE ORDER 160739 5862846 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 33.51 MASTER MIXES MARGARITA 160740 5862847 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,423.07 LIQUOR&SPIRITS ORDER 160741 5862848 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 338.35 WINE ORDER 160844 5868233 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,775.94 LIQUOR&SPIRITS ORDER 160845 5868234 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 112.51 DURANGO TEQUILLA GOLD 160846 5868235 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 405.28 WINE ORDER 160847 5868236 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 287.51 THE DALMORE SCOTCH 160848 5868237 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 513.12 WINE ORDER 160849 5868238 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 71.02 WINE ORDER 160865 5868338 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 308.53 LIQUOR&SPIRITS ORDER 160866 5868337 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 148.58 FRANZIA WINE ORDER 160867 5868336 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 103.01 RON DIAZ GOLD RUM 160868 5868335 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 25.60 KINKY COCKTAILS BLUE 160869 5868334 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 954.84 LIQUOR&SPIRITS ORDER 160870 5868333 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 99.51 SVEDKAVODKA ORDER 160872 5868331 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 23,746.74 141977 11/17/2017 107932 MOOD MEDIA 80.96 LIQUOR STORE NOV'17 RADIO 160881 53552573 6110 6401 PROFESSIONAL SERVICES DOWNTOWN LIQUOR REV&EXI06100 02 80.96 LIQUOR STORE NOV'17 RADIO 160881 53552573 6115 6401 PROFESSIONAL SERVICES PILOT KNOB LIQUOR 06100 02 161.92 141983 11/17/2017 100290 PAUSTIS&SONS WINE COMPANY 771.75 WINE ORDER 160714 8609962-IN 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 99.50 WINE ORDER 160742 8609966-IN 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 871.25 141984 11/17/2017 100032 PEPSI COLA COMPANY 117.60 POP ORDER 160500 28503361 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 117.60 141986 11/17/2017 100034 PHILLIPS WINE AND SPIRITS INC 66.46- PHILLIPS VODKA CREDIT 160716 277047 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 479.33 WINE ORDER 160717 2257923 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,363.33 LIQUOR&SPIRITS ORDER 160718 2257922 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 203.02 TIPPY COW LIQUOR ORDER 160743 2257921 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,630.65 LIQUOR&SPIRITS ORDER 160744 2257982 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 242.80 WINE ORDER 160745 2257983 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 R55CKS2 LOGIS601V CITY OF FARMINGTON 11/29/2017 9:16:08 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 16 10/1/2017 - 11/29/2017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 442.04 LIQUOR&SPIRITS ORDER 160850 2261815 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 865.28 WINE ORDER 160851 2261816 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 150.77 WINE ORDER 160873 2261868 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,043.19 LIQUOR&SPIRITS ORDER 160874 2261867 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 6,353.95 141990 11/17/2017 100196 QUALITY REFRIGERATION INC 386.88 REPAIR PK DOOR COOLER 160880 0045041 6115 6505 EQUIPMENT REPAIR SERVICE PILOT KNOB LIQUOR 06100 02 386.88 141995 11/17/2017 107018 SHAMROCK GROUP 60.88 ICE CUBE ORDER 160746 2179928 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 60.88 141996 11/17/2017 112051 SOUTHERN GLAZER'S OF MN 4,316.83 WINE&LIQUOR ORDER 160719 1610539 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 3.09 LIQUOR&SPIRITS ORDER 160720 1610538 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 4,177.19 WINE&LIQUOR ORDER 160747 1610536 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 2.35 LIQUOR&SPIRITS ORDER 160748 1610535 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 2,181.18 WINE&LIQUOR ORDER 160852 1613257 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 4,007.20 WINE&LIQUOR ORDER 160875 1613255 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 14,687.84 142001 11/17/2017 113871 VAN PAPER COMPANY 39.33- DT RETURNED BAGS 160613 441839 CM 6110 6250 OTHER SUPPLIES&PARTS DOWNTOWN LIQUOR REV&EX106100 02 169.58 LIQUOR STORE BAGS&TRASH BAGS 160883 441397-00 6110 6250 OTHER SUPPLIES&PARTS DOWNTOWN LIQUOR REV&EX106100 02 92.23 LIQUOR STORE BAGS&TRASH BAGS 160882 441395-00 6115 6250 OTHER SUPPLIES&PARTS PILOT KNOB LIQUOR 06100 02 222.48 142002 11/17/2017 108808 VINOCOPIA 503.67 WINE,BEER,&LIQUOR ORDER 160721 0193068-IN 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 415.50 WINE&LIQUOR ORDER 160749 0193079-IN 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 106.50 WINE ORDER 160853 0193568-IN 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 106.50 WINE ORDER 160854 0193567-IN 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 106.50 WINE ORDER 160876 0193566-IN 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 213.00 WINE ORDER 160877 0193565-IN 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,451.67 142007 11/17/2017 103627 ZAHL-PETROLEUM MAINTENANCE CO 63.59 REGISTER TAPE 160791 0230681-IN 6110 6250 OTHER SUPPLIES&PARTS DOWNTOWN LIQUOR REV&EXI06100 02 63.59 REGISTER TAPE 160791 0230681-IN 6115 6250 OTHER SUPPLIES&PARTS PILOT KNOB LIQUOR 06100 02 127.18 142012 11/22/2017 113303 ARTISAN BEER COMPANY 128.00 BENT PADDLE BEER ORDER 161026 3223255 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 281.00 SURLY VARIETY BEER ORDER 161027 3223254 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 R55CKS2 LOGIS601V CITY OF FARMINGTON 11/29/2017 9:16:08 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 17 10/1/2017 - 11/29/2017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 409.00 142013 11/22/2017 100493 BELLBOY CORPORATION 88.35 LIQUOR SUPPLIES&MIXES 160885 96771000 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 213.60 LIQUOR&BLODDY MARY MIX 160886 61658300 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 301.95 142014 11/22/2017 111280 BERNICK'S WINE 1 20.00 MP ORANGE 161028 392969 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 452.00 BEER ORDER 161029 392970 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 472.00 142016 11/22/2017 114472 BREAKTHRU BEVERAGE MN BEER,LLC 4,523.45 BEER ORDER 161030 1090789037 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 4,523.45 142017 11/22/2017 114471 BREAKTHRU BEVERAGE MN WINE&SPIRITS 97.45 LITTLE BLACK DRESS MERLOT 161032 1080721696 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,920.98 LIQUOR&SPIRITS ORDER 161033 1080721695 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 2,018.43 142023 11/22/2017 100071 COLLEGE CITY BEVERAGE INC 137.32- BEER ORDER CREDIT 161034 100-1296 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 9,865.20 BEER ORDER 161035 100-1295 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 9,727.88 142038 11/22/2017 100330 GRAPE BEGINNINGS INC 913.50 WINE ORDER 161036 MN00030916 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 913.50 142041 11/22/2017 100074 HOHENSTEINS INC 534.90 BEER ORDER 161037 930977 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 534.90 142045 11/22/2017 109846 J J TAYLOR DISTRIBUTING CO OF MN INC 7,411.05 BEER ORDER 161038 2769811 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 7,411.05 142046 11/22/2017 100033 JOHNSON BROTHERS LIQUOR CO 105.51- E&J BRANDY CREDIT 160887 650549 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 25.60- KINKY COCKTAILS BLUE CREDIT 160888 648633 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 525.06- BLACK BOX VARIETY WINE CREDIT 160889 651032 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 72.00 LIBERTY CREEK CHARD TETRA 160890 5869369 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,687.04 WINE ORDER 161039 5873698 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,491.14 NEWAMSTERDAM GIN&VODKA 161040 5873697 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,654.01 LIQUOR&SPIRITS ORDER 161041 5873696 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 837.37 WINE ORDER 161042 5873695 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 R55CKS2 LOGIS601V CITY OF FARMINGTON 11/29/2017 9:16:08 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 18 10/1/2017 - 11/29/2017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 38.51 CUERVO MIX MARG LIME 161043 5873694 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 2,086.84 LIQUOR&SPIRITS ORDER 161044 5873693 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,088.88 WINE ORDER 161045 5873692 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,346.63 LIQUOR&SPIRITS ORDER 161046 5873691 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 9,646.25 142059 11/22/2017 100290 PAUSTIS&SONS WINE COMPANY 331.75 WINE ORDER 161047 8611740-IN 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 331.75 142061 11/22/2017 100034 PHILLIPS WINE AND SPIRITS INC 99.51- UV VODKA CREDIT 160891 278389 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 301.56 WINE ORDER 161048 2265514 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 2,325.21 LIQUOR&SPIRITS ORDER 161049 2265513 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 2,527.26 142065 11/22/2017 114619 RED BULL DISTRIBUTION CO INC 346.50 RED BULL ORDER 161050 K-35452446 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 346.50 142072 11/22/2017 112051 SOUTHERN GLAZER'S OF MN 4,565.74 WINE&LIQUOR ORDER 161051 1616070 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 188.75 LIQUOR&SPIRITS ORDER 161052 1614036 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 4,754.49 142081 11/22/2017 102592 WINE COMPANY,THE 117.00 WINE ORDER 161053 54617 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 117.00 142082 11/22/2017 100334 WINE MERCHANTS 97.51 WINE ORDER 161054 71590125 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 97.51 20171021 10/30/2017 102160 CARDMEMBER SERVICES 64.97 FLOOR MAT 159995 1734-1804-9/8 6110 6250 OTHER SUPPLIES&PARTS DOWNTOWN LIQUOR REV&EXI86100 02 32.49 FLOOR MAT 159996 1734-5640-9/14 6110 6250 OTHER SUPPLIES&PARTS DOWNTOWN LIQUOR REV&EX186100 02 32.48 FLOOR MAT 159996 1734-5640-9/14 6115 6250 OTHER SUPPLIES&PARTS PILOT KNOB LIQUOR 06100 02 64.97 FLOOR MAT 159995 1734-1804-9/8 6115 6250 OTHER SUPPLIES&PARTS PILOT KNOB LIQUOR 06100 02 194.91 20171103 11/3/2017 100085 DAKOTA ELECTRIC ASSOCIATION 1,394.27 PK LIQ STORE ELEC SEPT'17 159925 375989-1 SEPT'17 6115 6422 ELECTRIC PILOT KNOB LIQUOR 06100 02 1,394.27 20171109 11/17/2017 100394 XCEL ENERGY 1,318.49 DT LIQ STORE ELEC NOV'17 160336 51-4874008-3 6110 6422 ELECTRIC DOWNTOWN LIQUOR REV&EXI86100 02 OCT'17 R55CKS2 LOGIS601V CITY OF FARMINGTON 11/29/2017 9:16:08 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 19 10/1/2017 - 11/29/2017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 1,318.49 20171110 11/20/2017 108980 MINNESOTA ENERGY RESOURCES CORPORATION 73.75 DT LIQ STORE GAS OCT'17 160458 0503154879 OCT'17 6110 6423 NATURAL GAS DOWNTOWN LIQUOR REV&EXI86100 02 73.75 20171111 11/22/2017 108980 MINNESOTA ENERGY RESOURCES CORPORATION 99.24 PK LIQ STORE GAS OCT'17 160575 0507026961 OCT'17 6115 6423 NATURAL GAS PILOT KNOB LIQUOR 06100 02 — 99.24 06100 LIQUOR OPERATIONS 147,656.46 141964 11/17/2017 103329 HOTSY EQUIPMENT OF MINNESOTA 53.69 PRESSURE WASHER SOAP 160772 57287 6202 6220 EQUIP SUPPLIES&PARTS SEWER OPERATIONS EXPENSE06200 08 53.69 141976 11/17/2017 115946 MOLDENHAUER,MICHELLE 16.93 REF UTIL CR @5129 LOWER 183 ST 160763 5129 LOWER 183RD 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 ST W 16.93 141997 11/17/2017 109843 SPOK,INC. 3.94 PAGER CONTRACT NOV'17 160777 A0317419W 6202 6412 CELLULAR PHONES SEWER OPERATIONS EXPENSE06200 08 3.94 142000 11/17/2017 100336 TOM'S MOBILE LOCK SERVICE 16.78 LOCK REPAIR 160799 20171009-MNT 6202 6515 BUILDING REPAIR SERVICE SEWER OPERATIONS EXPENSE06200 08 BLDG 16.78 142009 11/22/2017 100058 ADVANCE AUTO PARTS 5.44 HVAC BELTS 160961 2131-ID-454867 6202 6240 BUILDING SUPPLIES&PARTS SEWER OPERATIONS EXPENSE06200 08 5.44 142018 11/22/2017 115980 BUE,ROBERT C 200.48 REF UTIL CR @5363 UPPER 183 ST 160945 5363 UPPER 183RD 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 ST W 200.48 142019 11/22/2017 110218 BURNET TITLE 286.39 REF UTIL CR @ 19857 DEERBROOKE 160944 19857 DEERBROOKE6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 PATH 126.73 REF UTIL CR @ 5287 186TH ST W 160958 5287 186TH STW 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 413.12 142027 11/22/2017 100581 CRAWFORD DOOR SALES CO 65.43 WASH BAY DOOR 160985 27738 6202 6515 BUILDING REPAIR SERVICE SEWER OPERATIONS EXPENSE06200 08 R55CKS2 LOGIS601V CITY OF FARMINGTON 11/29/2017 9:16:08 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 20 10/1/2017 - 11/29/2017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 65.43 142030 11/22/2017 110986 DCA TITLE 57.28 REF UTIL CR @ 809 9TH ST 160955 809 9TH ST 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 57.28 142034 11/22/2017 110878 FIRST AMERICAN TITLE 621.18 REF UTIL CR @ 19648 ESTES PATH 160943 19648 ESTES PATH 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 621.18 142035 11/22/2017 110576 GIBRALTAR TITLE AGENCY LLC 17.30 REF UTIL CR@19645 EVEREST PATH 160942 19645 EVEREST PATH6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 358.56 REF UTIL CR @ 4832 189TH ST W 160957 4832 189TH ST W 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 375.86 142037 11/22/2017 100024 GOPHER STATE ONE-CALL INC 186.30 OCTOBER 2017 LOCATES 160990 7100368 6202 6401 PROFESSIONAL SERVICES SEWER OPERATIONS EXPENSE06200 08 186.30 142040 11/22/2017 115983 HIRD,CHAD M&NICOLE C 53.55 REF UTIL CR @1408 LWR HERITAGE 160952 1408 LOWER 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 HERITAGE WAY 53.55 142052 11/22/2017 100095 METROPOLITAN COUNCIL ENVIRONMENTAL SVS 111,517.85 DEC'17 WASTE WATER MCES FEES 160981 0001073779 6202 6565 MCES FEES SEWER OPERATIONS EXPENSE06200 08 111,517.85 142057 11/22/2017 113031 NRG RELIABILITY SOLUTIONS LLC 194.51 CMF ELEC OCT'17 160959 3347-1711 6202 6422 ELECTRIC SEWER OPERATIONS EXPENSE06200 08 194.51 142066 11/22/2017 114603 RED RIVER FLAGS 37.87 FLAGS 161016 2647 6202 6240 BUILDING SUPPLIES&PARTS SEWER OPERATIONS EXPENSE06200 08 37.87 142075 11/22/2017 110545 TRADEMARK TITLE SERVICES INC 54.48 REF UTIL CR @ 4215 206TH ST W 160956 4215 206TH ST W 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 54.48 142076 11/22/2017 112117 VIKING TITLE,LLC 128.74 REF UTIL CR @ 19 LILAC LN 160954 19 LILAC LANE 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 128.74 142080 11/22/2017 113123 WATERMARK TITLE AGENCY,LLC 235.53 REF UTIL CR @ 14 HICKORY CT 160953 14 HICKORY ST W 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 235.53 142083 11/22/2017 110959 ANCONA TITLE&ESCROW R55CKS2 LOGIS601V CITY OF FARMINGTON 11/29/2017 9:16:08 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 21 10/1/2017 - 11/29/2017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 110.80 REF UTIL CR @20341 ENRIGHT WAY 161078 20341 ENRIGHT WAY 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 110.80 142086 11/22/2017 113296 EDINA REALTY TITLE 345.72 REF UTIL CR @ 18101 ECHO TER 161075 18101 ECHO TER 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 345.72 142089 11/22/2017 110576 GIBRALTAR TITLE AGENCY LLC 74.09 REF UTIL CR @ 1108 LARCH ST 161074 1108 LARCH STREET 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 74.09 142091 11/22/2017 115989 JONES,KALENE L 97.04 REF UTIL CR @ 1205 WILLOW TRL 161076 1205 WILLOW TRL 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 97.04 142093 11/22/2017 110664 PREMIER TITLE INSURANCE AGENCY INC 100.00 REF UTIL CR @ 3079 224TH ST W 161077 3079 224TH STREET 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 W 100.00 20171021 10/30/2017 102160 CARDMEMBER SERVICES 74.51 FILTERS 159997 1734-4613-9/20 6202 6220 EQUIP SUPPLIES&PARTS SEWER OPERATIONS EXPENSE06200 08 92.12 AUG'17 CELL PHONE SERVICE 160155 7444-4820-9/26 6202 6412 CELLULAR PHONES SEWER OPERATIONS EXPENSE06200 08 35.01 AUG'17 DATA CARDS 160156 7444-8283-9/18 6202 6412 CELLULAR PHONES SEWER OPERATIONS EXPENSE06200 08 201.64 20171103 11/3/2017 100085 DAKOTA ELECTRIC ASSOCIATION 106.58 VERM GROVE LS ELEC SEPT'17 159929 321577-9 SEPT'17 6202 6422 ELECTRIC SEWER OPERATIONS EXPENSE06200 08 106.58 20171104 11/1/2017 100394 XCEL ENERGY 107.36 LIFT STATIONS ELEC SEPT'17 160076 51-4874005-0 6202 6422 ELECTRIC SEWER OPERATIONS EXPENSE06200 08 SEPT'17 12.91 CITY GARAGE ELEC SEPT'17 160076 51-4874005-0 6202 6422 ELECTRIC SEWER OPERATIONS EXPENSE06200 08 SEPT'17 120.27 20171106 11/15/2017 108980 MINNESOTA ENERGY RESOURCES CORPORATION 20.82 VERM GROVE LIFT STA GAS OCT'17 160450 0503080372 OCT'17 6202 6423 NATURAL GAS SEWER OPERATIONS EXPENSE06200 08 20.82 20171107 11/6/2017 114654 INVOICE CLOUD 68.04 AUG'17 IC&OBD FEES 159406 819-2017_8 6202 6545 PYMT PROCESSING FEES SEWER OPERATIONS EXPENSE06200 08 68.04 20171109 11/17/2017 100394 XCEL ENERGY 14.35 LINDEN ST LFT STAT ELEC OCT'17 160338 51-6585658-8 6202 6422 ELECTRIC SEWER OPERATIONS EXPENSE06200 08 OCT'17 R55CKS2 LOGIS601V CITY OF FARMINGTON 11/29/2017 9:16:08 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 22 10/1/2017 - 11/29/2017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 14.35 20171110 11/20/2017 108980 MINNESOTA ENERGY RESOURCES CORPORATION 185.38 CMF GAS OCT'17 160576 0502362190 OCT'17 6202 6423 NATURAL GAS SEWER OPERATIONS EXPENSE06200 08 13.59 1ST STREET GARAGE GAS OCT'17 160577 0505547424 OCT'17 6202 6423 NATURAL GAS SEWER OPERATIONS EXPENSE06200 08 198.97 20171112 11/20/2017 111046 VOYAGER FLEET SYSTEMS INC 6.53 OCT'17 FUEL BLDG MAINT 160570 OCT'17 869088237 6202 6272 FUEL SEWER OPERATIONS EXPENSE06200 08 BLDG MNT 659.28 OCT'17 FUEL SEWER 160591 OCT'17 869088237 6202 6272 FUEL SEWER OPERATIONS EXPENSE06200 08 SEWER 665.81 06200 SEWER OPERATIONS 116,363.09 141954 11/17/2017 110844 DAKOTA COUNTY FINANCIAL SRVS 3,197.44 SEPT'17 DIESEL FUEL 160758 00027672 6302 6272 FUEL SOLID WASTE OPERATIONS 06300 08 3,197.44 141964 11/17/2017 103329 HOTSY EQUIPMENT OF MINNESOTA 55.74 PRESSURE WASHER SOAP 160772 57287 6302 6220 EQUIP SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 55.74 141974 11/17/2017 101407 LARSON,LENA 118.36 MILEAGE JAN'17 TO OCT'17 160855 20171017-LARSON 6302 6485 MILEAGE REIMBURSEMENT SOLID WASTE OPERATIONS 06300 08 118.36 141991 11/17/2017 114582 RAMSEY-WASHINGTON RECYCLING&ENERGY 46,666.90 TIPPING FEES OCT'17 160806 RESFA-001691 6302 6401 PROFESSIONAL SERVICES SOLID WASTE OPERATIONS 06300 08 46,666.90 142000 11/17/2017 100336 TOM'S MOBILE LOCK SERVICE 26.37 LOCK REPAIR 160799 20171009-MNT 6302 6515 BUILDING REPAIR SERVICE SOLID WASTE OPERATIONS 06300 08 BLDG 26.37 142009 11/22/2017 100058 ADVANCE AUTO PARTS 55.50 SANITATION SUPPLIES 160948 2131-ID-456337 6302 6230 VEHICLE SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 18.63- SANITATION SUPPLIES 160950 2131-IC-456340 6302 6230 VEHICLE SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 5.64 HVAC BELTS 160961 2131-ID-454867 6302 6240 BUILDING SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 42.51 142022 11/22/2017 113887 CLEANLITES RECYLING,INC MN 20.18 ELECTRONICS RECYCLING 160951 +IN0012553 6302 6401 PROFESSIONAL SERVICES SOLID WASTE OPERATIONS 06300 08 20.18 R55CKS2 LOGIS601V CITY OF FARMINGTON 11/29/2017 9:16:08 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 23 10/1/2017 - 11/29/2017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 142027 11/22/2017 100581 CRAWFORD DOOR SALES CO 102.84 WASH BAY DOOR 160985 27738 6302 6515 BUILDING REPAIR SERVICE SOLID WASTE OPERATIONS 06300 08 102.84 142050 11/22/2017 112658 LOCATION TECHNOLOGIES,INC 43.25 GPS SERVICE NOV'17 160992 15216 6302 6401 PROFESSIONAL SERVICES SOLID WASTE OPERATIONS 06300 08 43.25 142057 11/22/2017 113031 NRG RELIABILITY SOLUTIONS LLC 157.92 CMF ELEC OCT'17 160959 3347-1711 6302 6422 ELECTRIC SOLID WASTE OPERATIONS 06300 08 157.92 142066 11/22/2017 114603 RED RIVER FLAGS 36.79 FLAGS 161016 2647 6302 6240 BUILDING SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 36.79 142087 11/22/2017 100022 FARMINGTON PRINTING INC 71.00 PAPER 161061 11987 6302 6450 OUTSIDE PRINTING SOLID WASTE OPERATIONS 06300 08 71.00 142088 11/22/2017 115086 FULL SOURCE,LLC 100.37 REFLECTIVE SWEATSHIRTS 161062 FS4136445-IN 6302 6290 UNIFORMS&CLOTHING SOLID WASTE OPERATIONS 06300 08 100.37 20171021 10/30/2017 102160 CARDMEMBER SERVICES 77.36 FILTERS 159997 1734-4613-9/20 6302 6220 EQUIP SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 134.96 SUBWAY FOR P2 DAY PRESENTERS 160008 6984-8826-9/15 6302 6570 PROGRAMMING EXPENSE SOLID WASTE OPERATIONS 06300 08 119.52 AUG'17 CELL PHONE SERVICE 160155 7444-4820-9/26 6302 6412 CELLULAR PHONES SOLID WASTE OPERATIONS 06300 08 128.35 SUPPLIES FOR P2 DAY&HHW DROP 160178 1734-8254-9/11 6302 6250 OTHER SUPPLIES&PARTS SOLID WASTE OPERATIONS 06300 08 460.19 20171104 11/1/2017 100394 XCEL ENERGY 10.73 CITY GARAGE ELEC SEPT'17 160076 51-4874005-0 6302 6422 ELECTRIC SOLID WASTE OPERATIONS 06300 08 SEPT'17 10.73 20171107 11/6/2017 114654 INVOICE CLOUD 68.04 AUG'17 IC&OBD FEES 159406 819-2017_8 6302 6545 PYMT PROCESSING FEES SOLID WASTE OPERATIONS 06300 08 68.04 20171110 11/20/2017 108980 MINNESOTA ENERGY RESOURCES CORPORATION 174.17 CMF GAS OCT'17 160576 0502362190 OCT'17 6302 6423 NATURAL GAS SOLID WASTE OPERATIONS 06300 08 12.77 1ST STREET GARAGE GAS OCT'17 160577 0505547424 OCT'17 6302 6423 NATURAL GAS SOLID WASTE OPERATIONS 06300 08 186.94 20171112 11/20/2017 111046 VOYAGER FLEET SYSTEMS INC 2.18 OCT'17 FUEL BLDG MAINT 160570 OCT'17 869088237 6302 6272 FUEL SOLID WASTE OPERATIONS 06300 08 BLDG MNT R55CKS2 LOGIS601V CITY OF FARMINGTON 11/29/2017 9:16:08 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 24 10/1/2017 - 11/29/2017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 147.77 OCT'17 FUEL SOLID WASTE 160590 OCT'17 869088237 6302 6272 FUEL SOLID WASTE OPERATIONS 06300 08 SLD WST 149.95 06300 SOLID WASTE OPERATIONS 51,515.52 141954 11/17/2017 110844 DAKOTA COUNTY FINANCIAL SRVS 33.37 SEPT'17 DIESEL FUEL 160758 00027672 6402 6272 FUEL STORM WATER UTILITY OPERA 06400 08 33.37 141964 11/17/2017 103329 HOTSY EQUIPMENT OF MINNESOTA 15.34 PRESSURE WASHER SOAP 160772 57287 6402 6220 EQUIP SUPPLIES&PARTS STORM WATER UTILITY OPERA 06400 08 15.34 142000 11/17/2017 100336 TOM'S MOBILE LOCK SERVICE 7.40 LOCK REPAIR 160799 20171009-MNT 6402 6515 BUILDING REPAIR SERVICE STORM WATER UTILITY OPERA 06400 08 BLDG 7.40 142008 11/17/2017 100020 ZARNOTH BRUSH WORKS INC 436.00 SWEEPER BROOM 160773 0167335 6402 623D VEHICLE SUPPLIES&PARTS STORM WATER UTILITY OPERA 06400 08 436.00 142009 11/22/2017 100058 ADVANCE AUTO PARTS 1.55 HVAC BELTS 160961 2131-ID-454867 6402 6240 BUILDING SUPPLIES&PARTS STORM WATER UTILITY OPERA 06400 08 1.55 142015 11/22/2017 110290 BOLTON&MENK,INC 360.50 WATER PLAN UPDATE 160896 0209468 6402 6401 10001 PROFESSIONAL SERVICES STORM WATER UTILITY OPERA 06400 08 360.50 142027 11/22/2017 100581 CRAWFORD DOOR SALES CO 28.87 WASH BAY DOOR 160985 27738 6402 6515 BUILDING REPAIR SERVICE STORM WATER UTILITY OPERA 06400 08 28.87 142057 11/22/2017 113031 NRG RELIABILITY SOLUTIONS LLC 41.11 CMF ELEC OCT'17 160959 3347-1711 6402 6422 ELECTRIC STORM WATER UTILITY OPERA 06400 08 41.11 142063 11/22/2017 102455 PRAIRIE RESTORATIONS INC 550.00 MUNICIPAL BLDG POND MAINT 160988 9862 6402 6401 PROFESSIONAL SERVICES STORM WATER UTILITY OPERA 06400 08 550.00 142066 11/22/2017 114603 RED RIVER FLAGS 10.82 FLAGS 161016 2647 6402 6240 BUILDING SUPPLIES&PARTS STORM WATER UTILITY OPERA 06400 08 10.82 20171021 10/30/2017 102160 CARDMEMBER SERVICES R55CKS2 LOGIS601V CITY OF FARMINGTON 11/29/2017 9:16:08 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 25 10/1/2017 - 11/29/2017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 21.29 FILTERS 159997 1734-4613-9/20 6402 6220 EQUIP SUPPLIES&PARTS STORM WATER UTILITY OPERA 06400 08 21.29 20171104 11/1/2017 100394 XCEL ENERGY 2.87 CITY GARAGE ELEC SEPT'17 160076 51-4874005-0 6402 6422 ELECTRIC STORM WATER UTILITY OPERA 06400 08 SEPT'17 2.87 20171107 11/6/2017 114654 INVOICE CLOUD 68.04 AUG'17 IC&OBD FEES 159406 819-2017_8 6402 6545 PYMT PROCESSING FEES STORM WATER UTILITY OPERA 06400 08 68.04 20171110 11/20/2017 108980 MINNESOTA ENERGY RESOURCES CORPORATION 42.78 CMF GAS OCT'17 160576 0502362190 OCT'17 6402 6423 NATURAL GAS STORM WATER UTILITY OPERA 06400 08 3.14 1ST STREET GARAGE GAS OCT'17 160577 0505547424 OCT'17 6402 6423 NATURAL GAS STORM WATER UTILITY OPERA 06400 08 45.92 20171112 11/20/2017 111046 VOYAGER FLEET SYSTEMS INC 1.45 OCT'17 FUEL BLDG MAINT 160570 OCT'17 869088237 6402 6272 FUEL STORM WATER UTILITY OPERA 06400 08 BLDG MNT 221.61 OCT'17 FUEL STORM 160592 OCT'17 869088237 6402 6272 FUEL STORM WATER UTILITY OPERA 06400 08 STORM 223.06 06400 STORM WATER UTILITY 1,846.14 141964 11/17/2017 103329 HOTSY EQUIPMENT OF MINNESOTA 53.69 PRESSURE WASHER SOAP 160772 57287 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 53.69 141979 11/17/2017 100070 MVTL-MINN VALLEY TESTING LABS 43.75 COLIFORM COLILERT BAC-T SAMPLE 160790 889127 6502 6401 PROFESSIONAL SERVICES WATER UTILITY EXPENSE 06500 08 43.75 141994 11/17/2017 100357 RIVERTOWN MULTIMEDIA 22.48 PUBLIC HEARING NOTICE-WHPP 160757 CL20092472 6502 6455 LEGAL NOTICES PUBLICATIONS WATER UTILITY EXPENSE 06500 08 22.48 141997 11/17/2017 109843 SPOK,INC. 3.94 PAGER CONTRACT NOV'17 160777 A0317419W 6502 6412 CELLULAR PHONES WATER UTILITY EXPENSE 06500 08 3.94 142000 11/17/2017 100336 TOM'S MOBILE LOCK SERVICE 16.28 LOCK REPAIR 160799 20171009-MNT 6502 6515 BUILDING REPAIR SERVICE WATER UTILITY EXPENSE 06500 08 BLDG 16.28 R55CKS2 LOGIS601V CITY OF FARMINGTON 11/29/2017 9:16:08 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 26 10/1/2017 - 11/29/2017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 142003 11/17/2017 111267 WATER CONSERVATION SERVICE,INC 307.45 WATER LEAK LOCATE UPPER 182ND 160760 7960 6502 6401 PROFESSIONAL SERVICES WATER UTILITY EXPENSE 06500 08 307.45 142009 11/22/2017 100058 ADVANCE AUTO PARTS 5.44 HVAC BELTS 160961 2131-ID-454867 6502 6240 BUILDING SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 5.44 142027 11/22/2017 100581 CRAWFORD DOOR SALES CO 63.50 WASH BAY DOOR 160985 27738 6502 6515 BUILDING REPAIR SERVICE WATER UTILITY EXPENSE 06500 08 63.50 142037 11/22/2017 100024 GOPHER STATE ONE-CALL INC 186.30 OCTOBER 2017 LOCATES 160990 7100368 6502 6401 PROFESSIONAL SERVICES WATER UTILITY EXPENSE 06500 08 186.30 142057 11/22/2017 113031 NRG RELIABILITY SOLUTIONS LLC 1,704.48 CMF ELEC OCT'17 160959 3347-1711 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 1,704.48 142058 11/22/2017 101254 ORKIN EXTERMINATING 103.97 PEST CONTROL NOV'17 160989 163331565/28454299 6502 6401 PROFESSIONAL SERVICES WATER UTILITY EXPENSE 06500 08 103.97 142066 11/22/2017 114603 RED RIVER FLAGS 37.87 FLAGS 161016 2647 6502 6240 BUILDING SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 37.87 20171021 10/30/2017 102160 CARDMEMBER SERVICES 74.51 FILTERS 159997 1734-4613-9/20 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 98.13 AUG'17 CELL PHONE SERVICE 160155 7444-4820-9/26 6502 6412 CELLULAR PHONES WATER UTILITY EXPENSE 06500 08 35.01 AUG'17 DATA CARDS 160156 7444-8283-9/18 6502 6412 CELLULAR PHONES WATER UTILITY EXPENSE 06500 08 207.65 20171103 11/3/2017 100085 DAKOTA ELECTRIC ASSOCIATION 45.37 195TH WATER TOWER ELEC SEPT'17 159927 258709-5 SEPT'17 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 1,552.30 WELL#5 ELEC SEPT'17 159928 278553-3 SEPT'17 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 2,031.95 WELL#4 ELEC SEPT'17 159930 131852-6 SEPT'17 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 2,486.33 WELL#6 ELEC SEPT'17 159931 155015-1 SEPT'17 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 18.43 DAISY KNOLL TOWER ELEC SEPT'17 159933 131851-8 SEPT'17 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 3,111.28 WELL#8 ELEC SEPT'17 159934 419970-9 SEPT'17 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 2,478.38 WELL#7 ELEC SEPT'17 159935 349073-7 SEPT'17 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 11,724.04 20171104 11/1/2017 100394 XCEL ENERGY 1,848.39 WELL#3 ELEC SEPT'17 160076 51-4874005-0 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 SEPT'17 R55CKS2 LOGIS601V CITY OF FARMINGTON 11/29/2017 9:16:08 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 27 10/1/2017 - 11/29/2017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 2,374.68 WELL#1 ELEC SEPT'17 160076 51-4874005-0 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 SEPT'17 106.17 CITY GARAGE ELEC SEPT'17 160076 51-4874005-0 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 SEPT'17 4,329.24 20171106 11/15/2017 108980 MINNESOTA ENERGY RESOURCES CORPORATION 20.10 WELL#5 GAS OCT'17 160451 0507120636 OCT'17 6502 6423 NATURAL GAS WATER UTILITY EXPENSE 06500 08 20.10 20171107 11/6/2017 114654 INVOICE CLOUD 68.03 AUG'17 IC&OBD FEES 159406 819-2017_8 6502 6545 PYMT PROCESSING FEES WATER UTILITY EXPENSE 06500 08 68.03 20171110 11/20/2017 108980 MINNESOTA ENERGY RESOURCES CORPORATION 237.66 CMF GAS OCT'17 160576 0502362190 OCT'17 6502 6423 NATURAL GAS WATER UTILITY EXPENSE 06500 08 17.42 1ST STREET GARAGE GAS OCT'17 160577 0505547424 OCT'17 6502 6423 NATURAL GAS WATER UTILITY EXPENSE 06500 08 18.73 WELL HOUSE 1 OAK ST GAS OCT'17 160586 0506788875 OCT'17 6502 6423 NATURAL GAS WATER UTILITY EXPENSE 06500 08 273.81 20171112 11/20/2017 111046 VOYAGER FLEET SYSTEMS INC 79.84 OCT'17 FUEL BLDG MAINT 160570 OCT'17 869088237 6502 6272 FUEL WATER UTILITY EXPENSE 06500 08 BLDG MNT 273.26 OCT'17 FUEL WATER 160594 OCT'17 869088237 6502 6272 FUEL WATER UTILITY EXPENSE 06500 08 WATER 353.10 06500 WATER UTILITY 19,525.12 142029 11/22/2017 115282 DAKOTA ELECTRIC ASSOCIATION 687.06 REPLACE LIGHT SPRUCE/DUSHANE 160824 75089380 6602 6401 PROFESSIONAL SERVICES STREETLIGHT UTILITY EXPEN 06600 08 687.06 REPLACE ST LITE/POLE VRC APTS 160982 75017920 6602 6401 PROFESSIONAL SERVICES STREETLIGHT UTILITY EXPEN 06600 08 1,374.12 142039 11/22/2017 103373 GRAYBAR ELECTRIC CO INC 666.69 STREET LIGHT FIXTURE 160983 9300774134 6602 6220 EQUIP SUPPLIES&PARTS STREETLIGHT UTILITY EXPEN 06600 08 666.69 20171103 11/3/2017 100085 DAKOTA ELECTRIC ASSOCIATION 6,303.51 9TH ST STREET LTS ELEC SEPT'17 159932 103842-1 SEPT'17 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 6,303.51 20171104 11/1/2017 100394 XCEL ENERGY 45.71 DOWNTOWN ST LTS ELEC SEPT'17 160076 51-4874005-0 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 SEPT'17 54.25 TRAFFIC SIGNAL ELEC SEPT'17 160076 51-4874005-0 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 R55CKS2 LOGIS601V CITY OF FARMINGTON 11/29/2017 9:16:08 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 28 10/1/2017 - 11/29/2017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div SEPT'17 169.29 ROUND ABOUT ELEC SEPT'17 160076 51-4874005-0 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 SEPT'17 6,474.33 NON-METER ST LTS ELEC SEPT'17 160076 51-4874005-0 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 SEPT'17 6,743.58 20171109 11/17/2017 100394 XCEL ENERGY 28.81 5262 208TH ST LTS ELEC OCT'17 160337 51-8391412-3 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 OCT'17 182.23 321 ELM ST LTS ELEC OCT'17 160339 51-8608862-8 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 OCT'17 211.04 20171113 11/21/2017 100394 XCEL ENERGY 176.70 190TH ST BRDG LTS ELEC OCT'17 160341 51-9371130-1 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 OCT'17 176.70 06600 STREETLIGHT UTILITY 15,475.64 142048 11/22/2017 100164 LAW ENFORCEMENT LABOR SERVICES 563.50 161011 1121171109203 7000 2116 LELS DUES PAYABLE EMPLOYEE EXPENSE FUND 07000 02 563.50 142049 11/22/2017 115466 LIFE INSURANCE COMPANY OF NORTH AMERICA 361.80 ACCIDENT&CI INSURANCE NOV'17 160897 A1960331 NOV'17 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 361.80 142055 11/22/2017 100322 MN NCPERS LIFE INSURANCE 16.00 161012 1121171109204 7000 2119 PERA LIFE INS PAYABLE EMPLOYEE EXPENSE FUND 07000 02 16.00 142064 11/22/2017 100135 PUBLIC EMPLOYEES RETIREMENT ASSN. 18,712.58 161009 1121171109201 7000 2113 PERA PAYABLE EMPLOYEE EXPENSE FUND 07000 02 24,702.94 161010 1121171109202 7000 6154 PERA EMPLOYEE EXPENSE FUND 07000 02 43,415.52 142073 11/22/2017 114206 SUN LIFE FINANCIAL 2,954.10 LIFE INSURANCE NOV'17 160899 237780 NOV'17 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 2,954.10 142094 11/22/2017 114206 SUN LIFE FINANCIAL 985.40 LTD INSURANCE NOV'17 160898 237780 NOV'17 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 985.40 R55CKS2 LOGIS601V CITY OF FARMINGTON 11/29/2017 9:16:08 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 29 10/1/2017 - 11/29/2017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 20171102 11/3/2017 115445 HEALTH PARTNERS 57,264.00 HEALTH INSURANCE NOV'17 160654 75992733 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 57,264.00 07000 EMPLOYEE EXPENSE FUND 105,560.32 141960 11/17/2017 102071 GOODYEAR TIRE&RUBBER COMPANY,THE 1,220.60 TIRES FOR 750 AND STOCK 160774 124-1086714 7200 6232 VEHICLE TIRES FLEET OPERATIONS 07200 08 1,220.60 141999 11/17/2017 108670 TERMINAL SUPPLY CO. 128.84 ELECTRICAL TERMINAL SUPPLIES 160789 62134-00 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 128.84 142009 11/22/2017 100058 ADVANCE AUTO PARTS 30.45 STOCK FILTER 160965 2131-ID-454172 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 10.48 STOCK BULBS 160966 2131-ID-454207 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 61.69 TIRE REPAIR AND WHEEL WEIGHTS 160971 2131-I0-456010 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 102.62 142036 11/22/2017 102071 GOODYEAR TIRE&RUBBER COMPANY,THE 100.00 GRADER TIRE DISPOSAL 160991 124-1086769 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 3,100.00 TIRES FOR GRADER 160994 124-1086746 7200 6232 VEHICLE TIRES FLEET OPERATIONS 07200 08 3,200.00 20171021 10/30/2017 102160 CARDMEMBER SERVICES 39.84 AUG'17 CELL PHONE SERVICE 160155 7444-4820-9/26 7200 6412 CELLULAR PHONES FLEET OPERATIONS 07200 08 39.84 20171112 11/20/2017 111046 VOYAGER FLEET SYSTEMS INC 102.86 OCT'17 FUEL FLEET 160457 OCT'17 869088237 7200 6272 FUEL FLEET OPERATIONS 07200 08 FLEET 102.86 07200 FLEET OPERATIONS 4,794.76 142021 11/22/2017 108428 CDW GOVERNMENT INC 111.60 SAN COMPONENTS 160941 KQV7961 7400 6960 FURNITURE&OFFICE E INFORMATION TECHNOLOGY 07400 04 111.60 142025 11/22/2017 110591 CONSOLIDATED COMMUNICATIONS 1,965.86 PHONE LINES-OCT'17 160976 738246 OCT'17 7400 6411 TELEPHONE INFORMATION TECHNOLOGY 07400 04 1,965.86 20171021 10/30/2017 102160 CARDMEMBER SERVICES 178.15 SWITCH FOR 1ST GARAGE. 160015 1759-6678-9/20 7400 6210 OFFICE SUPPLIES INFORMATION TECHNOLOGY 07400 04 R55CKS2 LOGIS601V CITY OF FARMINGTON 11/29/2017 9:16:08 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 30 10/1/2017 - 11/29/2017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 37.10 WIRELESS KEYBOARD 4 SMARTBOARD 160016 1759-3171-9/13 7400 6210 OFFICE SUPPLIES INFORMATION TECHNOLOGY 07400 04 114.63 AUG'17 CELL PHONE SERVICE 160155 7444-4820-9/26 7400 6412 CELLULAR PHONES INFORMATION TECHNOLOGY 07400 04 329.88 07400 INFORMATION TECHNOLOGY 2,407.34 141950 11/17/2017 115948 CEDARLINE CONSTRUCTION 3,000.00 ER 224305 CARINA COURT 160761 ER 22405 CARINA 7500 2255 DEPOSITS PAYABLE ESCROW FUND 07500 02 COURT 3,000.00 142031 11/22/2017 115062 DISTINCTIVE DESIGN BUILD,LLC 3,000.00 ER 3015 224TH ST W 160937 ER 3015 224TH ST W 7500 2255 DEPOSITS PAYABLE ESCROW FUND 07500 02 3,000.00 142044 11/22/2017 115988 ISPIRI 4,650.00 ER BLDG PERMIT 41770 160998 ER BLDG PERMIT 7500 2255 DEPOSITS PAYABLE ESCROW FUND 07500 02 41770 4,650.00 07500 ESCROW FUND 10,650.00 141964 11/17/2017 103329 HOTSY EQUIPMENT OF MINNESOTA 3.59- 160772 57287 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 3.59- 142000 11/17/2017 100336 TOM'S MOBILE LOCK SERVICE 1.70- 160799 20171009-MNT 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 BLDG 1.70- 142009 11/22/2017 100058 ADVANCE AUTO PARTS 3.57- 160948 2131-ID-456337 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 1.20 160950 2131-IC-456340 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 .36- 160961 2131-ID-454867 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 2.73- 142027 11/22/2017 100581 CRAWFORD DOOR SALES CO 6.62- 160985 27738 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 6.62- 20171021 10/30/2017 102160 CARDMEMBER SERVICES 4.98- 159997 1734-4613-9/20 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 4.98- 20171104 11/1/2017 100394 XCEL ENERGY R55CKS2 LOGIS601V CITY OF FARMINGTON 11/29/2017 9:16:08 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 31 10/1/2017 - 11/29/2017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div .69- 160076 51-4874005-0 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 SEPT'17 .69- 20171110 11/20/2017 108980 MINNESOTA ENERGY RESOURCES CORPORATION 11.20- 160576 0502362190 OCT'17 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 .82- 160577 0505547424 OCT'17 9999 2415 MN SALES TAX DUE CASH COMPANY 09999 12.02- 09999 CASH COMPANY 32.33- APPROVALS: Report Totals 585,140.15 LARSON 7/5 BARTHOLOMAY BERNHJELM .....ca... CRAIG I ID DONNELLY o�c0ARM City of Farmington �/A Os 430 Third Street W Farmington, Minnesota 651.280.6800 Fax 651.280.6899 14,...„0004) www.ci.farmington.mn.us TO: Mayor, Councilmembers and City Administrator FROM: Cynthia Muller,Administrative Assistant SUBJECT: 2018 License Renewals DATE: December 4, 2017 INTRODUCTION Per city code, a public hearing must be held to issue or renew on-sale liquor licenses, on-sale Sunday liquor licenses, on-sale wine licenses, club licenses and therapeutic massage licenses. DISCUSSION The required applications, fees and insurance information have been submitted for renewal and have been reviewed and approved by the Police Department for the following establishments: On-Sale Liquor and On-Sale Sunday: This Little Piggy Catering Inc, 22280 Chippendale Avenue W Bourbon Butcher, 20700 Chippendale Avenue W, Suite 15 Carbone's Pizza& Sports Bar, 10 N 8th Street Celt's Pub & Grill, 200 3rd Street El Charro Mexican Restaurant, 122 Elm Street Farmington Lanes, 27 5th Street Gossips Bar and Grill, 309 3rd Street, Suite 1 Las Enchiladas, 18500 Pilot Knob Road, Suite A Long Branch Saloon and Eatery, 309 3rd Street Pizza Man, 409 3rd Street Rebel Chef, 953 8th Street The Mug, 18450 Pilot Knob Road Club License and On-Sale Sunday: VFW Club Post#7662, 421 3rd Street On-Sale Wine & On-Sale Intoxicating Malt Liquor: Weng's Kitchen, 115 Elm Street Therapeutic Massage: Denson Malone, Touch of Soul Massage Therapy, 18556 Pilot Knob Road, Suite 202 BUDGET IMPACT The fees collected are included in the revenue estimates of the 2018 budget. ACTION REQUESTED Conduct the public hearing and accept any continents that are received. If the city council is comfortable, a motion should be made to approve the on-sale liquor, on-sale Sunday liquor, on-sale intoxicating malt liquor and on-sale wine, club, and therapeutic massage licenses for the businesses listed above. 4itkRM% City of Farmington 430 Third Street Farmington, Minnesota 11/4 / 651.280.6800 - Fax 651.280.6899 --r•,,,,O,.a ' www.ci.farmington.mn.us TO: Mayor, Councilmembers and City Administrator FROM: David McKnight, City Administrator SUBJECT: 2018 Final Budget and Tax Levy DATE: December 4, 2017 INTRODUCTION After six months of work including reviewing, discussing and revising the draft 2018 budget and tax levy, the city council will consider approving all of the 2018 budgets and the 2018 final tax levy at the December 4, 2017 city council meeting. DISCUSSION The city council has met in open session and discussed the 2018 budget and tax levy at work sessions held on: • May 8, 2017 • June 12, 2017 • July 10, 2017 • August 14, 2017 • October 30, 2017 The city council approved the preliminary 2018 tax levy on September 5, 2017 and set that amount at $10,494,185. This amount represents a 4.98% increase over the 2017 tax levy. It should be noted the city council made a decision to use $150,000 in fund balance to lower the proposed 2018 property tax levy to this amount. The proposed 2018 tax levy is proposed to increase$647,363 before the use of$150,000 in fund balance. The net proposed increase is $497,363. The proposed increase is a result of the following issues: Issue Change HR Cost Increases* $227,101 Debt Levy Increases $325,470 Miscellaneous Increases . $94,883 Use of Fund Balance ($150,000) TOTAL $497,363 *The HR increases include the cost of four settled union contracts for 2018 and similar changes to non-union wage schedules, a 14% increase in health insurance premiums and an 8% increase in dental insurance premiums. Departmental Changes The changes in the proposed general fund budget by department are listed below. The reasoning for the larger changes are detailed below the chart. 2017 2018 Change Administration $726,999 $825486 13.55 % HR/IT $294,176 $330,831 12.46% Finance $740,102 $732,495 -1.03% Police $4,330,234 $4,451,333 2.80% Fire $1,145,404 $1,188,352 3.75% Comm. Dev. $725,021 $801,427 10.54% Engineering $685,908 $705,474 2.85% Municipal Services $1,278,532 $1,313,175 2.71% Parks/Recreation $1,324,772 $1,282,696 -3.18% Transfers $952.342 $999,744 4.98% TOTAL $12,203,490 $12,631,013 3.50% • The Administration budget initially had dollars for potential new positions in 2017. At this point there is still$70,000 included in this budget that will be used for a to be determined item; most likely either a new position, use for building fund projects or a combination of both. • The HR/IT budget has increased funding included in 2018 to address needed safety expenditures to meet OSHA safety requirements and additional funding in the legal line item for union contract negotiations and other legal needs. • The Community Development budget shows an increase in 2018 due to the decision in 2017 to increase a building inspector position from part-time to full-time. Revenues Revenues for 2018 are projected to increase 1.78%. The revenues by category for 2018 include: 2017 2018 Change Licenses/Permits $397,615 $410,411 3.22% Intergovernmental $847,432 $886,636 4.63% Charges for Services $601,950 $560,000 -6.97% Fines/Forfeitures $40,000 $35,000 -12.50% Investments $23,005 $31,000 34.75% Miscellaneous $47,385 $43,775 -7.62% Transfers $1,150,350 $1,196,376 4.00% TOTAL $3,107,737 $3,163,198 1.78% Transfers Budget A number of years ago the city started to place funding for ongoing projects in the Transfers budget. These are projects that are worked on over a number of years and the funding for these projects stays in the Transfers budget. Examples of projects included in the Transfers budget include seal coating, the 2019 fire department engine purchase, police vehicles, police and fire equipment, building maintenance, trail maintenance, park improvements and more. Debt The city continues to carry a large amount of debt. This debt has been incurred from previous city street projects and facilities construction. The city council and city staff have worked over the past five years to pay down, pay off and refinance as much of our debt as possible. The 2018 tax levy includes $3,363,373 for debt repayment on nine different bonds. This amount includes the 2018 repayment of$521,000 for the 2013 street project bond that was set up with repayment amounts that increased each year until 2018. This payment reflects the high point of repayment and this bond will be paid in full in 2019. Next year also represents the peak of debt repayments of current debt. Currently the 2019 debt repayment levy is estimated at$3,261,460. While we anticipate issuing new debt in 2019 and future years we will continue our efforts to start to pay for projects through a combination of debt and cash. The good news in the debt area is that significant amounts of debt reach repayment in full in the years 2020 and 2022. Tax Impact The proposed tax levy for 2018 impacts each property differently depending on a number of factors. The average residential property in Farmington has a market value increase of 6.69% for 2018 with the average value standing at $236,107. The proposed tax levy for 2018 would mean an increase of$48.62 on the average home. City staff estimates on the proposed levy increase for 2018 on a number of homes showed an actual range of changes from a$206 reduction to a$98 increase. This range is from a handful of homes we monitor each year and there are properties that exist outside of this range as well. Other Budgets While most of the work of the city council focuses on the general fund each year, the city council has also reviewed the proposed budgets in all other funds for 2018. Some of the highlights for these budget for next year include: • EDA-Similar to previous years budgets but does not include a transfer from the General Fund for 2018 due to a healthy fund balance. • Park Improvement-This budget will received $85,000 in funding including$10,000 in local government aid and $75,000 in liquor store profits in 2018. The projects scheduled to be completed in this budget include fence/backstop replacement of Feely Fields field#2, resurfacing of basketball courts at Evergreen Knoll and Dakota Estates Parks and Prairie Pines Park facility improvements. • Liquor Stores-Similar to previous years with estimated net profits being similar to 2017. • Storm Water-A planned fee increase of 3% is included for 2018 as a part of the three year rates cycle between storm water, water and sanitary sewer. A planned purchase of a new street sweeper at a cost of$160,000 is included to replace the 1999 street sweeper. • Water-A planned purchase of a plow/dump truck that is a part of advancing the overall fleet replacement program with funding from the water, storm water, solid waste and general funds is included in 2018. • Sanitary Sewer-Similar budget to 2017 with estimated fees from the Met Council being less than anticipated in 2018. • Solid Waste-A planned purchase of a waste hauler at an estimated cost of$360,000 is included in the 2018 budget. These items were reviewed in detail at the October 30, 2017 city council work session. If you have questions specific to these budget please let me know. Financial Health Continues to Improve Over the past seven years the city has spent significant time focusing on improving the financial health of the organization while laying out numerous plans for the future. Due to this planning we have witnessed the following in recent years: • General Fund balance reaching 40% at the end of the year for the first time in decades. • Bond rating upgrade for the city in 2015 from AA-to AA. • Multiple capital improvement plans developed to address large scale infrastructure issues. While we have done many good things we are still not including funding or full funding for projects like pavement management, trail maintenance, building maintenance and more. We realize it takes time to establish long term funding solutions for issues that have not been addressed for years. City staff is very thankful for the willingness of the city council to address these issues. BUDGET IMPACT The passage of this item will set the 2018 city budgets and tax levy. ACTION REQUESTED Hear the presentation on the 2018 budget and tax levy and listen to the comments that residents may wish to share with the city council. Once the city council is comfortable, city staff recommends that separate motions be made to: 1. Adopt the resolutions adopting the tax levy for 2018; and 2. Approve the 2018 budget. Initially it was assumed that not all of the city council would be in attendance at the December 4, 2017 meeting. This does not appear to be the case any longer. City staff does need the budget and tax levy to be approved on December 4, 2017 because of the reports that have to be filed with the state and the county and the limited amount of work days that our temporary finance director has left to work in December. ATTACHMENTS: Type Description ❑ Resolution 2018 Tax Levy Resolution O Backup Material 2018 Budgets RESOLUTION NO. R56-17 A RESOLUTION ADOPTING THE TAX LEVY FOR COLLECTION IN 2018 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 4th day of December 2017 at 7:00 p.m. Members Present: Larson, Bartholomay, Bernhjelm, Craig, Donnelly Members Absent: None Member Bernhjelm introduced and Member Donnelly seconded the following: WHEREAS, the city of Farmington is annually required by state law to approve a resolution setting forth an annual tax levy to the Dakota County Auditor; and WHEREAS, Minnesota State Statute currently in force requires certification of the proposed tax levy to the Dakota County Auditor on or before December 27, 2017; and WHEREAS, summary details of the proposed budgets are contained in the budgets submitted to the City Council. 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 2017, collectible in 2018, upon the taxable property in said city of Farmington for the following purposes: General Fund $9,467,815 Debt Fund + $3,213,373 Gross Levy $12,681,188 Fiscal Disparities - $2,187,003 Net Tax Levy $10,494,185 This resolution was adopted by recorded vote of the Farmington City Council in open session on the 4th day of December 2017. f /� Todd Larson, Mayor Attested to on the iY /1' day of December 2017. cKniYg , AdministratorMr 2018 BUDGET Summary of Debt Service Levy to be attached and become a part of resolution R56-17. Fund Project Levy Amount 3091 2013A GO Improvement Refunding Bonds $444,000 (Refunding of 2005B and 2006A) 3092 2013B GO Street Reconstruction Bonds $521,000 (Akin East and West Project) 3093 2015A GO Improvement Bonds $293,500 (195th Street Reconstruction Project) 3094 2016A GO Refunding Bonds $591,000 3136 2016B GO Refunding Bonds $124,000 3137 2016C GO Refunding Bonds $551,000 TOTAL BOND FINANCING $2,524,500 3130 2005C GO Capital Improvement Bond $166,000 (Fire Station#2) 3097 2010A GO Improvement Bonds $383,873 (Police Station) 3300 2010D GO Equipment Certificates $139,000 (Ice Arena Improvements) SUB TOTAL $688,873 TOTAL DEBT LEVY $3,213,373 The amount levied is less than the required amounts from the payment schedules for some of the bonds. The bonds are listed on Form B which is part of this resolution. The city has sufficient sources to pay the bonds. City of Farmington Budget and Tax Levy 2017 Budget,2018 Proposed and 2019 Proposed Company 2017 2018 Budget% 2019 Budget Budget Proposed Change Proposed Change% I Non-Property Tax Revenues Licenses and Permits 397,615 410,411 3.22% 363,6461 (11.39)% Intergovernmental Revenue 847,4321 886,636 i 4.63% 886,636 0.00% . ......... . Charge for Service 601,950 1 560,0001 (8.97)% 543,000 (3.04)% Fines and Forfeitures 40,0001 35,000] (12.50)% 30,0001 (14.29)% Investment Income 23,0051 31,0001 34 .75%[ 31,0001 000%J Miscellaneous I 47,3851 43,775 (762)%1 43,7751 0.00%� Transfers in 1,150,350 1,196,376 4.00%I 1,244,256; 4.00% Total Revenues 3,107,7371 3163,1981 1.78%1 3,142,3131 (0 66)%1 Expenditures Administration 7269991 825,4861 13.55%i 875 0881 6.01% Human Resource 294,1761 330,831 12.46% 360,4861 8.96% Finance and Risk Mgmt 740,1021 732,495, -(1.03)% 769,9811 5.12% Police 4,330,2341 4,451,3331 280% 4,588 651 3.04% Fire 1,145,4041 1,188,3521 3.75% 1,220 513 2.71% CommunityDevelopment 1 -__.-__ p 725,021 801,4271 10.54% 842,124 5.08% Engineering 885,8081 705,4741 285%1 734,4871 411%; Municipal Services 1 1,278,532 1,313,175 2.71%1 1,337,6761 1.87%I Parks and Recreation 1,324,772 1,282,696 (3.18)%1 1,342,2691 4.64% Transfers Out 952,3421 999,7441 4.98%1 1,064,7751 6.50%1 Total Expenditures 12,203,490] 12,631,0131 3.50%I 13,134,0501 3.98%1 1 Revenues Over(Under)Expenditures (9,095,753); (9,467,815) 4.09% (9,991.737)1 5.53%1 1 Fiscal Disparities 2,136,834; 2,187,0031 2.35%( 2,094,3111 (4.24)% 1 General Fund Levy6,958 919 7,280,8121 4.63%l 7,897.4261.. 8.47%1 Debt Levy I 1 I I Bondsi. _ 2,738 903 . 3,058,3731 11.68% 3,046 4391 (0.39)% 2005C Loan Repay-Storm Water Tr Adv 166,000, 186,0001 0.00% 166,000 0.00%1 2010D Loan Repay-Storm Water Tr Adv 1 133,0001 139,0001 4.51%1 240,000 72,68%1 Total Debt Levy3,037,9031 3,363,3731 10.71%1 3,452,439 2.65%1 Use of Fund Balance to Lower Debt Levy 01 (150,000)1 1 0 (100.00)% Net Debt Levy 3,037,9031 3,213,3731 5.78%1 3,452,4391 7.44% Farmington Net Tax Levy 1 9,996,8221 10,494,1851 4,98%I 11,349,8651 8.15%1 Location: Documents\FARMINGTON1Budget 2018-2019\1 General Fund Budget Summary Page 2017 Base 10/16/2017 10:11:41 AM General Fund Detailed Non-Property Tax Revenue Summary 2016 Budget,2017 Budget, 2018 Proposed and 2019 Proposed Object 2016 2017 2018 2019 Account Budget Budget Proposed Proposed LIQUOR LICENSES 31,0001 29,600 40,700 40,700 BEER&WINE LICENSES 2,200 2,200 1,7501 1,750 CLUB LICENSES . _-.--- 3001 5001 5001 500 ARCADE LICENSE 655 5401- - °L 01 - - - - - - - MASSAGE UCENSE 100 1001 50 50 ___. GAMBLING LICENSE/PERMIT .--- 2001 200 200_--_-_200 _ OTHER LICENSE&PERMIT 1,9001 - -1,2001 1,500 _ 1,500 ANIMAL LICENSES 5,00014,000; 4,0001 1,4001 Licenses 41,355 38,3401 48,700 46,1001 _- BUILDING PERMITS _ 265,298 - 301,0751 300,000 255,8351 REINSPECTION FEES 600 6001 800 800 Code Enforcement Fees _ (1) _ _ (1) PLUMBING&HEATING_PERMITS 32,0001 30,0001 30,000 30,000 SEWER PERMITS 5,0001 5,0001 5,000 5,000 ELECTRIC PERMITS 12,000 12,0014,0001 14,000 ISTS PERMITS 350 3501 - 2501 --- 250 COUNTY SEPTIC FEE i _ UTILITY PERMITS 5,500L 55001 6,1301 6,130 SIGN PERMITS 5001 5001 570 _570 BURNING PERMITS 1,000 ,00 1,710 1,710 OTHER PERMITS -- - 4,100} 13,2501 3,250 3,2501 Permits --- 326,3481 359,2751 381,7111 317,546 Licenses and Permits 367,703 397,615 410,411 363,646., FEDERAL GRANT _ _ _ 0 0; I- _ LOCAL GOVERNMENT AID 284,884; 287,4321- 313,6401---313,640 r MSA MAINTENANCE 190,0001 220,000 215,000 215,000 POLICE AID180,0001 180,0001 190,400 190,400, POST TRAINING 31,000 17,0001 15,3711 15,371 _-_. -FIRE AID i10,0001 127,000 134,461 134,4611 STATE GRANT 2,0001 0 MARKET VALUE CREDIT 0 01 _ STATE AID MISCELLANEOUS I i 1I 1 COUNTY MISCELLANEOUS 5,250, 16,0001_ 17,7641-- 17,764; OTHER MISCELLANEOUS 01 0;1 Intergovernmental 803,134 847,432 886,636 886,636 1 - CUSTOMER SERVICES NONTAXABLE 01- - 0 l - - 3501 -3501 ZONING&SUBDIVISION FEES 0 0 1,250 1,250 ADMINISTRATION FEES-PROJECTS 01-- 01- 4501 4501 FIRE CHARGES - - 215,000; 212,0001_ 228,000; 231,000 POLICE SERVICE CHARGES 75,000; 75,0001 75,000 75,000 ENGINEERING FEES-PROJECTS - I -..., 1 __ EROSION&SEDIMENT CONTROL 12,0001 12,000 12,000; 12,0001 G.I.S.FEES 01 01 PUBLIC WORKS MISC CHARGES 01 0/ - - -_ RECREATION FEES-GENERAL 96,000 j 93,000_1 93,000 93,000 POOL ADMISSIONS 37,0001 37,000 0 0 SWIM LESSON FEES 13,000 11,000; 0 01 CONCESSIONS - 11'000[-- 11,000; 01 01 Location: Documents\FARMINGTON\Budget 2018-201911,1 Gen'l Fund Revenue Summary 2017 Base Page 1 of 2 General Fund Detailed Non-Property Tax Revenue Summary 2016 Budget,2017 Budget, 2018 Proposed and 2019 Proposed Object 2016 2017 2018 2019 Account Budget Budget Proposed Proposed RECREATION FEES-SENIOR CTR 18,0001 19,000 18,000 18,000 MEMBERSHIP FEES-SENIOR CTR Y _ 12,000/ --9,000 _ 9,000_ 9,000 MOBILE MEALS-SENIOR CTR I_-._--J - ADVERTISING 5001 750L - 750 750/ LESSONS I ADVERTISING ^------- 2,200 2,200((� 2,200 _ 2,2001 FRANCHISE FEE 100,000r 120,000, 120,000 100,000 Charges For Services ,. 591,700 • 601,950 560,000;.•••:''..;'_-;54.3,000 COURT FINES 65,000: 40,0001 35,000 30,0001 i FInes&Forfeitures 65 000 40,000 .35,000 30 000. - INTEREST ON INVESTMENTS 18,4621 23,0051 31,000 31,0001 GAIN/LOSS INVEST MKT VALUE -- --- I 1 I I ,Investment Income 18,462 '23,005 .` 31,000 31,000; MISCELLANEOUS REVENUE 15,0.00 5,000 5,000 5,000 CASH OVER&SHORT _ [ ( - j I RENTAL INCOME-RRC -- 20,0001 21,0001 -22,000` 22,000 1 -_ RENTAL INCOME-POOL 2,000[ 2,2001 0 0 RENTAL INCOME ___ _...-____�. - "19,685 -- 19,185+ 16,775_ 16,7751 - DONATIONS - -- - �--- 0i __ 1-----J Placedholder-UseOfFundBalance-DebtLev 01 01 150,0001 01 isRevenue 56,685 ., { ; Mc _: 47,385 193;175 ‘i-‘-- 43,775 OPERATING TRANSFERS 1,148,3711 1,150,3501 1 196 376 I 1,244,2561 Transfers In 1,148,371 1;100,350:;:.-:•:-..'.:1,100;376. 1,244,256., Total Revenues $3,051 055• 107 737 .$3,3131.98'1.:$3 142 313. • 1 Location: Documents\FARMINGTON1Budget 2018-201911.1 Gen1 Fund Revenue Summary 2017 Base I Page 2 of 2 j 1 General Fund Expenditure Detail Summary 2016 Budget,2017 Budget 2018 Proposed and 2019 Proposed Company 2016 2017 2018 2019 Budget Budget Proposed Proposed Expendituresi 1 T� 1 Administration Legislative(1005) 88,906 90,1211 89,3791 96,1061 Historical Preservation(1006) 3,855 01 Administration(1010) 376,379 295,408 366 5501 422,8561 Elections(1013) 57,548' 34,370 35,821 29,548`- Communications(1014) 102 1051 109,072 109341 114,995 City Hall(1015) 195,3211 198,028 224,395 211,5831 Administration 822,114 726,999 825,486 875,088 Human Resources 279,035 294,176 330,831 I 360,486 Human Resource(1011) 279,035 294,1761 330,831 I 360,486 Human Resources 279,035 294,176 330,831 360,486. Finance and Risk Management I I I 1 Finance(1021) I 563,802 566 0151 600 1711 Risk Management(1022) 190,0001 176,300 166,4801 189,810 Finance and Risk Management 681,973 740,102 732,495 769,9813 Police 1 Police Administration(1050) 840,955 823,992 850,566 894,030 Patrol Services(1051) 2,679 435 2,680,419 2,750 258 2,811,677 - 1 investigations(1052) 682,472 820,923• 843,859 874,294 Emergency Management(1054) 4,9001 4,9001 6,650 6,8501 Police; 4,187,762 ';4,330,234 4,451,333 4,586,6511 Fire 1 Fire(1060) 1,140,0071 1,145,404 1,188,352 1,220,513 Rescue(1061) 0 0 Fire 1 140,007 1,145,404 1,188 352 1,220,513! Community Development 604,4981 725,021 801,4271 842,1241 Planning(1030) 347,774 420,914 433,575 465,878 Building inspection(1031) 258,724 304,1071 367,852 376,448 Community.Development 604,498 725,021 801,427 842,124. Engineering 1. 1 Engineering(1070) 531,1121 543,757' 568 5731 594,210 Natural Resources(1076) 125,5761 142,1511 136,901 1 140,277 Engineering 656,688 685,908 705,474 734,487 Municipal Services 1 1 1 Streets(1072) 1,018,6041 1047 9931 1,085,7981 1,112,261, Snow Removal(1073) 226 8951 230,5391 227,3771 225,415; '`. Municipal Services 1,245,499 1,278,532 1,313,175 '';1,337,6761 Parks and Recreation I._-_ ___._ 1...._ Park Maintenance(1090) 608,700' 631,213 653,873 769,608 Rambling River Center(1093) 149,166 171,358 177,225 191,828 Park&Rec Admin(1094) 262,158 271,0401 264,004 267,522 Recreation Programs(1095) 113,407 113 822, 112,861 113,311 Swimming Pool(1097) I 137,339: 74,733 Parks and Recreation 1,268,663 1,324,772 1,282,696 ;:; 1,342;269; Perm Levy AdJ(2015&2018)and 113 Delq Exp(2016) 5,379 01 i 1 Transfers Out 1 906,607.00! 952,342.00, 999,744.001 1,064,775.00 Transfers Out 906,607 00 952,342.00: 999,744 00 1,064,775,00. Total Expenditures 11,798,225 12,203,490 12,637 013 13134,0501 10/16/2017 10:12:23 AM Page 1 of 1 Debt Service Funds Summary 2016 Actual,2017 Budget, 2018 Proposed and 2019 Proposed Company Actual Budget Proposed Proposed 2016 2017 2018 2019 I ;Revenues Property Taxes(i.e.Debt Levy) 2,752,1221 1 3,037,9031 3,363,3731 3 452 4391 Special Assessments j 454,065 436,4401 418,235! 403,7811 Deferred Assessments(VRC) 23,545 0i j 1 MSA Construction 200,0001 01 j Interest on Investments 41,0611 4,160] 8,50018,5001 Total Revenues 3,470,793 i 3,478,503 3 790,1081 3,864 720 1 Expenditures I 1 i Principal Repayment 4,411,533: 16 511,459 4,758,8151 3,408 4721 Interest on Debt 950,0361 720 7561 451,6091 354,3941 Debt-Fiscal Charges 1 144,1631 46,9051 25,005; 86,505 Total Expenditures 5,505,732 17,279,120 I 5,235,4291 3,847 3711 Other Financing Sources I 1 Bond Proceeds 9,620,000. 0' 1 2,460000 Transfers in 1 11 799,261 12,607,1671 180,0001 45,000 Transfers Out j (9,991,812)1 (10,590,850); (695,773)1 (3,353,577) Total Transfers 1 11,427,4491 2,016,3171 (515,773)1 (848,577)1 Change in Fund Balance 9,392,5111 (11,784,300)1 (1,961,094)1 (831,228)1 10/161201710:12:44 AM Page 1 of 1 Special Revenue Funds Budget Summary 2016 Actual,2017 Budget, 2018 Proposed and 2019 Proposed Company 2016 2017 2018 2019 Actual Budget Proposed Proposed Revenues EDA(2000) 45,0141 2,374 3,100 3,1001 TIF-City Center(2050) 56049; 0 TIF-Trident(2054) Police Donations 8 Forfeitures(2100) ; 7,899' 5,0821 5,1001 5,1001 Park Improvement Fund(2300) 127,771 9,000I 10,4871 3,4001 Ice Arena(2500) 330,1261 333,7861 343,0001 342 0001 Total Revenues 1 566,860 350,242 361,6871 353,600i 1 Expenditures I EDA(2000) 69,1741 45,255 51,407 51,890 TIF-City Center(2050) 114,536 0� i TIF-Trident(2054) 8272,850] 2,850 Police Donations 8 Forfeitures(2100) 5,763 6,500 6,5001 6,500 Park Improvement Fund(2300) 76,985, 150,000 74,5001 274,5001 Ice Arena(2500) 316,995; 313,9521 319,4211 329,6241 i Total Expenditures 1584,2791 I 515,7071 454,6781 665,184' Transfers Transfers In 1 95,0131 80,000E 87,8501 97,850 ; Transfers Out ] (60,000)1 01 (22,850)1 (12,850) • Total Transfers 1 35,0131 80,0001 65,0001 85,000] Change In Fund Balance 1 17,5931 (85,465)1 (27,991)1 (226,584)) 10/16/2017 10:13:07 AM Page 1 of 1 Capital Projects Funds Summary 2016 Actual,2017 Budget, 2018 Proposed and 2019 Proposed Company 2016 2017 2018 2019 Actual Budget Proposed Proposed Revenues 11 1 Sanitary Sewer Trunk(3900) 79,98112,981 3,7001 3,700] - Cable Communications Fund(4000) 183 8711 174,347� 176,000 176,000 Road and Bridge/Street Reconstruction Fund(4100) ( 156 7121 9,465 9,1791 8848 Fire Capital Projects Fund(4300) 59,4261 1,293� 2,500 2,500! - Storm Water Trunk(4400) 155,7681 31,1731 8,904 89031 RRC&Youth Hockey Cap Proj Donations(Rec Cap Proj Fund 4500) 34,9421 17,012j 21,900 i 21,900 Private Capital Projects(4600) 26,5381 22,8921 23,000 23,000 Permanent imp Revolving Fund(4900) 15,9881 1,0021 1,300 1,300 Gen'I Cap Equip Fund(5600) 16,1321 441 9,500 1,500 Maintenance Fund5700 �_ _._..__..__. ..._.._. ( ) j 476,614] 560,7821 355,6001 15,8001 Total Revenues 1 1,205 9731 821,3881 611,583 263,2511 1 Expenditures 1 _ Sanitary Sewer Trunk 64,751 01 Cable Communications Fund 82,4871 81,0001 140 0001 115,0001 Road and Bridge/Street Reconstruction Fund(4100) 1961 01 01 Fire Capital Projects Fund(4300) 1 256,749 01 1 870,000 Storm Water Trunk Fund 1631 01 RRC&Youth Hockey Cap Proj Donations(Rec Cap Proj Fund-4500) 178,530 14,2501 11,600 116001 Private Capital Projects 22,097 20,0001 20,000 20.0001 Permanent Imp Revolving Fund 386 01 Gen'I Cap Equip Fund(5600) 139,368 157,5461 207 6001 251,665' Maintenance Fund i 1,972,2551 719,179' 903,719; 3,401,626 Total Expenditures 1 2,716,9611 991,975 1,282,919 4,669,891 1 Transfers 1 Transfers In 1,334,6361 1630,170 1,996,287 5,155,330 Transfers Out (1,501,000)1 (2,642,615) (520,000) Total Transfers (166,364)1 (1,012,445)1 1,476,2871 5,155,3301 Change in Fund Balance (1,677,351)1 (1,183,032)1 804,9511 748,6901 • 10/16/2017 10:13:34 AM Page 1 of 1 Enterprise Funds Budget Summary 2016 Actual,2017 Budget, 2018 Proposed and 2019 Proposed Company 2016 2017 2018 2019 Actual Budget Proposed Proposed Revenues Liquor Stores Net of Cost of Goods Sold(6100:6115) 1,216,009 1,172,471 1,177,8481 1,181,760 Sewer Operations(6200:6205) 2,069 783, 2,060,0121 2, 070 3571 2,332,605 Solid Waste(6300:6302) 2,1024661 1 986,203E 2,183,3621 2,185,062 Storm Water(6400:6405) 654,666; 650,0031 744,7871 748,459 Water(6500:6508) 1,704,6401 1 813,099 1,527 4751 1,086,4401 Streetlights(6600:6602) 1 226,4641 220,8381 225,3001 225,3001 Total Revenues 7,974,0281 7,902,6261 7,909,129; 7,759,626] Expenditures Liquor Stores 1 911 0751 962,953 965,8291 965,415 1 Sewer Operations 1 2,051,1521 2,231,750,1 2,003,644 L 2,441,820 Solid Waste 1,775 1621 i,905,0111 2,387,984 Z083,949 949 Storm Water 534,9621 690,9951 852,487 673,500 Water 1,359,211 1506,0241 1,775,5871 1,217,914 Streetlights I 288,925 266,2001 209,200; 216,500 Total Expenditures 6,920,5071 7,562,9331 8,194,7311 7,599,0981 Transfers 1 1— I [ Transfers In 1 01 63,849; 66,8461 69,5201 Transfers Out I (1,428,106)1 (1,384,861)1 (1,344,332); (2,209,886) Total Transfers (1,428,106)1 (1,321,012)1 (1,277,486)1 (2,140,386) !Change in Fund Balance i (374,585)1 (981,319)1 (1,563,088)1 (1,979,838) 1 • • 10/16/2017 10:13:58 AM Page 1 of 1 I