Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
03/09/2017 Meeting
••••• Meeting Location: Municipal Center • Apple 7100 147th Street West Valley Apple Valley, Minnesota 55124 March 9, 2017 CITY COUNCIL INFORMAL MEETING TENTATIVE DISCUSSION ITEMS 5:30 PM 1. Council Discussion Items (5 min.) 2. Discuss County Highway Cost-Participation Policy (45 min.) 3. Update on City Building Energy-Efficiency Projects (5 min.) 4. Naming of Cortland Neighborhood Park (20 min.) 5. Adjourn CITY COUNCIL REGULAR MEETING TENTATIVE AGENDA 7:00 PM 1. Call to Order and Pledge 2. Approve Agenda 3. Audience - 10 Minutes Total Time Limit - For Items NOT on this Agenda 4. Approve Consent Agenda Items Consent Agenda Items are considered routine and will be enacted with a single motion, without discussion, unless a councilmember or citizen requests to have any item separately considered. It will then be moved to the regular agenda for consideration. A. Approve Minutes of February 23, 2017, Regular Meeting B. Adopt Resolution Accepting Donations of Cash from Various Businesses for Mid-Winter Fest Activities C. Approve State Gambling Exempt Permit for Minnesota Section American Water Works Association, at Bogart's/Apple Place Bowl, 14917 Garrett Avenue, on April 29, 2017 D. Approve Special Outdoor Promotion/Temporary Sign Permit for 2017 Home and Garden Expo E. Appoint Malloy, Montague, Karnowski, Radosevich & Co., P.A., as Auditors for Fiscal Years 2016, 2017, and 2018 E Adopt Resolution Changing Bid Date for Project 2016-101, Water Meter Replacement, and Authorizing Receipt of Bids at 10:00 a.m. on April 6, 2017 G. Approve Grant Agreement with Minnesota Board of Water and Soil Resources for Keller Lake Subwatershed Assessment H. Approve Change Order No. 2 on Agreement with Structural Glass Products, Inc., for Apple Valley City Hall - 2015 Exterior Repairs Part 1 Project, and Approve Acceptance and Final Payment I. Set Special Informal City Council Meeting on April 27, 2017, at 6:00 p.m. at Cortland Development Park J. Approve Personnel Report K, Approve Claims and Bills 5. Regular Agenda Items A. Firefighter Introductions and Oaths of Office B. Proclaim April 28, 2017, as "Arbor Day" and May 2017 as "Arbor Month" 6. Staff and Council Communications 7. Approve Calendar of Upcoming Events 8. Adjourn Regular meetings are broadcast, live, on Charter Communications Cable Channel 180 and on the City's website at www.cityofapplevalley.org 0000: ITEM: 2. :0:: Apple COUNCIL MEETING DATE: March 9, 2017 Valley SECTION: Informal Agenda Item Description: Discuss County Highway Cost-Participation Policy (45 min.) Staff Contact: Department/ Division: Matt Saam, Public Works Director Public Works Department ACTION REQUESTED: N/A SUMMARY: The County Engineer, Mark Krebsbach, will be in attendance at the Informal Meeting to provide a presentation to the City Council on the County's Cost Participation Policy. This policy applies to County road and signal projects that occur within the City limits and provides a cost share formula of 55% County and 45% City. BACKGROUND: Last November, the Council was considering a resolution of concurrence regarding the County's proposed CIP (Capital Improvement Plan). Questions were raised during that discussion about the current Cost Participation Policy. A request was made at that time to have the County provide a background on the history of the Cost Participation Policy. BUDGET IMPACT: N/A ATTACHMENTS: Presentation 3/9/2017 Dakota County Transportation Cost Sharing Policies Apple Valley City Council Work Session March 9, 2017 Mark Krebsbach, P.E. Transportation Director/County Engineer transportation we get you there T Dakota County Transportation Cost Sharing Policies History • Policies date back to 1967 • Many policies — Currently 18 policies and over 4 pages in 2030 Transportation Plan o http://www.co.dakota.mn.us/Transportation/Planning Programs/Documents/2030TransportationPlan.pdf • Have changed overtime transportation we qet you there 1 3/9/2017 Dakota County Transportation Cost Sharing Policies 55% County / 45% City is just part of the story: • Only applies to cities over 5,000 • Does not apply to Transitways, maintenance, or safety projects • County participates in City utilities • Federal and State funds are deducted • 25% cap on "regional" projects trans ortation we get you there Dakota County Transportation Cost Sharing Policies Many other policies such as: • Drainage • Utilities • Traffic Signals and Roundabouts • Transit/transitways • Aesthetics • Left turn lanes , trans ortation we get Vou there 2 3/9/2017 Dakota County Transportation Cost Sharing Policies County can participate up to 55% in City streets: • Access consolidation/elimination • Frontage and backage roads • Detoured traffic • In lieu of county highway projects • Future county highways trans ortation we get you there Dakota County Transportation Cost Sharing Policies Some rationale for 55% / 45% Policy: • City land use control dictates trip generation • Lack of supporting road network and desire for access • Often a high percentage of "local" trips • Improvements often require additional lanes to address these issues — typical expansion 2 to 4 lanes • Agreement on need for projects trans ortation we get Vou there 3 3/9/2017 Dakota County Transportation Cost Sharing Policies Benefits of Cost Sharing: • Shared priorities and project scope • Increased funding = increased investments • Transportation system better able to meet planned growth • Ability to get to expansion needs - lowest priority in adopted Transportation Plan trans ortation we get you there County Highway Needs and Revenues Dakota County Highway Needs and Revenues 2016-2030 1242 '200 Ezpawu 728 000 p 800 746 c 0 f � ssa Replacement asa 212 'IrtCI++dC5 somng p land Met"W trans arta#ion we get you there Needs Revenue ' 4 3/9/2017 Dakota County Transportation Cost Sharing Policies Changes in 2030 Transportation Plan Update (2012): • 100% for small safety and management • Transit policies • Storm sewer maintenance • 25% cap for "Regional" projects • Roundabouts • Participation in local roadways • Upgrades to future county roads • Advance funding trans ortation we get you there Dakota County Transportation Cost Sharing Policies Historic city share of adopted County Transportation CIP: 35.0 31.4 30.0 • .� 25.0 • •26.5 22.5 7qn • • 20.1 • 19.7 20.0 a 15.5 15.0 13.5 • • • • 15.5 10.0 13 3 91 • 5.0 0.0 2000 2005 2010 2015 2020 IVYear trans ortation Average is 19% we get you theme 5 3/9/2017 Dakota County Transportation Cost Sharing Policies City of Apple Valley projects since 2005: • Total Expense: $74.82 m • City Share*: $5.52 m (7.4%) * Includes 100%City aesthetic portion of Cedar BRT Project • County Share: $18.22 m (24.4%x) • Remainder: Federal, State, CTIB trans ortation we get you there Dakota County Transportation Cost Sharing Policies Future Cost Share topics: • Possible Revisions with Transportation Plan update 2018/2019 • Replacement projects • Pedestrian scale lighting • "Regional" Transportation projects (possible application to sales tax projects) • 6 Lane County Highways • Principal Arterials • 10 ton highway expansion • Interchanges ' trans ortation • Trunk Highways we get Vou there 6 3/9/2017 Dakota County Transportation Cost Sharing Policies Questions / Discussion trans ortatim we get you there 7 0000: ITEM: 3. :0:: Apple COUNCIL MEETING DATE: March 9, 2017 Valley SECTION: Informal Agenda Item Description: Update on City Building Energy-Efficiency Projects (5 min.) Staff Contact: Department/ Division: Charles Grawe,Assistant City Administrator Administration/ Information Technologies ACTION REQUESTED: N/A SUMMARY: The City has an ongoing practice of looking to improve energy efficiency when updating and replacing building infrastructure and equipment. In the recent past, the City successfully conducted a number of improvement projects under a single contract with Ameresco. There are a number of upcoming building projects in several departments that might be a good fit for a similar contract with Ameresco. Staff would like to discuss the specific projects with Ameresco to see if a viable project could be proposed to the Council at a later date. BACKGROUND: N/A BUDGET IMPACT: N/A *00 *000 *000 09000 ITEM: 4. 000 Apple COUNCIL MEETING DATE: March 9, 2017 Valley SECTION: Informal Agenda Item Description: Naming of Cortland Neighborhood Park (20 min.) Staff Contact: Department/ Division: Barry Bernstein, Director of Parks & Recreation Parks and Recreation Department ACTION REQUESTED: N/A SUMMARY: The public park property within Cortland Development has been accepted and Staff is seeking City Council selection of an official park name. The working name has been Cortland Neighborhood Park or Cortland Park. By unanimous vote, the Parks and Recreation Advisory Committee has recommended City Council approval of the name "Kohls Farm Park" and to include an interpretive sign that highlights the history of the Kohls Farm property. BACKGROUND: The Cortland development site, most recently a sand and gravel mining operation area, is located in the southeast corner of Embry Path and County Road 42. The preliminary plat designated 88 acres to create single-family residential lots, a storm water retention pond area, and a 5.56 acre public park. The public park property has been accepted and Staff is seeking City Council selection of an official park name. The working name has been Cortland Neighborhood Park or Cortland Park. Alan and Ron Kohls have addressed the Parks and Recreation Advisory Committee, suggesting the park name "Kohls Farm Park" in honor of their family farm, previously located on the property. Prior to the January Parks and Recreation Advisory Committee meeting, Staff met with Alan Kohls to discuss the possibility of an interpretive sign within the park as an alternative to naming the park. At that time, Mr. Kohls was agreeable to the idea. The Committee has reviewed the 2010 Park Naming Policy and determined "Kohls Farm Park" fits the parameters of the policy. By unanimous vote at their January 5, 2017 meeting, the Parks and Recreation Advisory Committee has recommended City Council approval of the name "Kohls Farm Park" for the property formerly referred to as Cortland Park. BUDGET IMPACT: N/A ATTACHMENTS: Background Material City of Apple Valley Parks and Recreation Advisory Committee Park Naming Policy adopted September 2, 2010 1. Parks may be named for the deceased after one year has elapsed from the time of death. The deceased may include local or national heroes and national, state, or local officials. 2. Parks may be named for streets, neighborhoods, historical events and characters, trees, flowers, places, mythological and descriptive names. These names should be indigenous to Apple Valley. 3. Parks should not be named for civic organizations in order to avoid community conflicts. 4. Park or facility names should not be changed without good cause. They should be named carefully and with permanent intent. 5. The criteria should be reviewed from time to time, and if necessary, periodically revised to offer the naming committee a practical, up-to-date and helpful tool through which practical decisions may be reached and by which difficult situations may be amicably reconciled. S:Park,4dmn:ParkNaming.doe 0000: ITEM: 4.A. :0:: Apple COUNCIL MEETING DATE: March 9, 2017 Valley SECTION: Consent Agenda Description: Approve Minutes of February 23, 2017, Regular Meeting Staff Contact: Department/ Division: Pamela J. Gackstetter, City Clerk City Clerk's Office ACTION REQUESTED: Approve the minutes of the regular meeting of February 23, 2017. SUMMARY: The minutes from the last regular City Council meeting are attached for your review and approval. BACKGROUND: State statute requires the creation and preservation of meeting minutes which document the official actions and proceedings of public governing bodies. BUDGET IMPACT: N/A ATTACHMENTS: Minutes CITY OF APPLE VALLEY Dakota County, Minnesota February 23, 2017 Minutes of the regular meeting of the City Council of Apple Valley, Dakota County, Minnesota, held February 23, 2017, at 7:00 o'clock p.m., at Apple Valley Municipal Center. PRESENT: Mayor Hamann-Roland; Councilmembers Bergman, Goodwin, Grendahl, and Hooppaw. ABSENT: None. City staff members present were: City Administrator Lawell, City Clerk Gackstetter, City Attorney Hills, City Engineer Anderson, Police Captain Bermel, Police Captain Francis, Assistant City Administrator Grawe, Human Resources Manager Haas, Finance Director Hedberg, City Planner Lovelace, Recreation Manager Muelken, Police Chief Rechtzigel, Public Works Director Saam, and Fire Chief Thompson. Mayor Hamann-Roland called the meeting to order at 7:00 p.m. Everyone took part in the Pledge of Allegiance led by Boy Scouts Chase Nord and Phillip Nord from Troop 204. APPROVAL OF AGENDA MOTION: of Hooppaw, seconded by Grendahl, removing item 4.G-Delegard Apple Villa Apartments, Lot 1, Block 1, Apple Villa Second Addition (7800 to 7822 Whitney Drive) from the agenda and approving the agenda for tonight's meeting, as amended. Ayes - 5 -Nays - 0. AUDIENCE Mayor Hamann-Roland asked if anyone was present to address the Council, at this time, on any item not on this meeting's agenda. Mr. Michael Boerboon, student at Apple Valley High School, said the Performing Arts Department is presenting Broadway 2017: Planes, Trains, and Automobiles, and he invited everyone to attend. Ms. Dorianne Lillemo, 14112 Heywood Path, encouraged the City Council to consider passing an ordinance requiring City inspections when homes go on the market and annually on rental units, both to be paid for by the property owner. Police Chief Rechtzigel provided a brief summary regarding the City's rental registration program. CONSENT AGENDA Mayor Hamann-Roland asked if the Council or anyone in the audience wished to pull any item from the consent agenda. There were no requests. CITY OF APPLE VALLEY Dakota County, Minnesota February 23, 2017 Page 2 MOTION: of Bergman, seconded by Goodwin, approving all items on the consent agenda with no exceptions. Ayes - 5 -Nays - 0. CONSENT AGENDA ITEMS MOTION: of Bergman, seconded by Goodwin, approving the minutes of the regular meeting of February 9, 2017, as written. Ayes - 5 -Nays - 0. MOTION: of Bergman, seconded by Goodwin, approving a change in manager for Apple Valley American Legion, Post 1776, in connection with the On-Sale Club License and Special License for Sunday Liquor Sales, at 14521 Granada Drive, naming Linsey Love Green as General Manager, as described in the City Clerk's memo. Ayes - 5 -Nays - 0. MOTION: of Bergman, seconded by Goodwin, approving the 2017 excavation permit for commercial sand and gravel mining operations by Fischer Sand&Aggregate, LLP, as described in the City Planner's memo. Ayes - 5 -Nays - 0. MOTION: of Bergman, seconded by Goodwin, approving the letter of support for Velvet Tones' application for the Metropolitan Regional Arts Council (MRAC)Arts Achievement Award. Ayes - 5 -Nays - 0. MOTION: of Bergman, seconded by Goodwin, adopting Resolution No. 2017-36 approving changes to the Public Works Department Policy Manual, by adding Section 1.10 - Street Improvement Project Items. Ayes - 5 -Nays - 0. MOTION: of Bergman, seconded by Goodwin, approving the release of financial guarantees for Hunter Forrest, as listed in the Community Development Department Assistant's memo. Ayes - 5 -Nays - 0. MOTION: of Bergman, seconded by Goodwin, adopting Resolution No. 2017-37 approving the Master Subscriber Agreement for Minnesota Court Data Services for Government Agencies, and authorizing the Police Chief to sign the same. Ayes - 5 -Nays - 0. MOTION: of Bergman, seconded by Goodwin, approving the Agreement for Project 2017- 125, Park Trail Overlay, with Pine Bend Paving, Inc., in the amount of$25,800.00, and authorizing the Mayor and City Clerk to sign the same. Ayes - 5 -Nays - 0. MOTION: of Bergman, seconded by Goodwin, approving the Agreement for Project 2017- 123, Chain Link Fencing -Hayes Field#7, with Midwest Fence &Mfg. Company, in the amount of$21,740.00, and authorizing the Mayor and City Clerk to sign the same. Ayes - 5 -Nays - 0. CITY OF APPLE VALLEY Dakota County, Minnesota February 23, 2017 Page 3 MOTION: of Bergman, seconded by Goodwin, approving hiring the seasonal and full time employees, termination of employees, and promotion of employee, as listed in the Personnel Report dated February 23, 2017. Ayes - 5 -Nays - 0. MOTION: of Bergman, seconded by Goodwin, to pay the claims and bills, check registers dated February 2, 2017 in the amount of$959,715.18, and February 9, 2017, in the amount of$1,100,789.49. Ayes - 5 -Nays - 0. MOTION: of Bergman, seconded by Goodwin, adopting Resolution No. 2017-38 authorizing execution of Apple Valley Villa Apartments Master Subordination Agreement and Estoppel Certificate. Ayes -4 -Nays- 0 -Abstain - 1 (Hooppaw). END OF CONSENT AGENDA STORK PIN PRESENTATION Fire Chief Thompson said several employees were involved in providing direct support and service for a pre-hospital birth and provided a brief summary. Mr. Kurt Weidner, Allina Health EMS Manager, presented Stork Pins to Firefighters Colleen Elvin and Marisa Holman and Police Officers Karen Shaw and Kasey DeJonker for their professional involvement with the birth. The City Council congratulated all involved. CERTIFICATE OF ACHIEVEMENT FOR EXCELLENCE IN FINANCIAL REPORTING Mr. Hedberg introduced Ms. Sue Virnig, Minnesota Government Finance Officers Association representative. Ms. Virnig presented the City with a Certificate of Achievement for Excellence in Financial Reporting for its comprehensive annual financial report for the fiscal year ending December 31, 2015. The City Council commended Mr. Hedberg and the Finance Department for achieving this prestigious award. ORDINANCE REGULATING PREDATORY OFFENDER RESIDENCY Police Captain Francis gave the first reading of an ordinance amending Chapter 130 of the City Code, regulating predatory offender residency. MOTION: of Bergman, seconded by Hooppaw, waiving the provision for a second reading and passing Ordinance No. 1026 amending Chapter 130 of the City Code, regulating predatory offender residency. Ayes - 5 -Nays - 0. CITY OF APPLE VALLEY Dakota County, Minnesota February 23, 2017 Page 4 APPOINT PARKS AND RECREATION ADVISORY COMMITTEE MEMBERS Ms. Gackstetter reviewed her memo listing the applicants for the Parks and Recreation Advisory Committee. There are two vacancies, each with a term expiring March 1, 2020. Councilmember Bergman suggested taking action on reappointing commissioners and committee members while the City Council votes on the applicants for the Parks and Recreation Advisory Committee. The City Council agreed. REAPPOINT COMMISSIONERS & COMMITTEE MEMBERS Ms. Gackstetter reviewed her memo regarding the reappointment of Commissioners and Committee Members with terms expiring March 1, 2017. She noted all members have indicated their interest in serving an additional term. MOTION: of Bergman, seconded by Grendahl, adopting Resolution No. 2017-40 reappointing Nancy Anderson, David Brueshoff, and Alan Kohls to the Cemetery Advisory Committee for a term expiring March 1, 2020; No. 2017-41 reappointing Keith Diekmann, Jodi Kurtz, and David Schindler to the Planning Commission for a term expiring March 1, 2020; No. 2017-42 reappointing David Cherner and Dale Rodell to the Telecommunications Advisory Committee for a term expiring March 1, 2020; No. 2017-43 reappointing Nick Francis and Arthur Zimmerman to the Traffic Safety Advisory Committee for a term expiring March 1, 2020; and No. 2017-44 reappointing Pamela Sohlberg and John Vegter to the Urban Affairs Advisory Committee for a term expiring March 1, 2020. Ayes - 5 -Nays - 0. APPOINT PARKS AND RECREATION ADVISORY COMMITTEE MEMBERS - Continued The Mayor called for nominations for the vacancy. Councilmember Hooppaw nominated Erik Anderson, Matthew Hinrichs, Mark Schori, Jonathan Sharpe, and Ben Van Gundy. There being no further nominations, the Mayor declared the nominations closed. MOTION: of Hooppaw, seconded by Goodwin, accepting the five nominations for the Parks and Recreation Advisory Committee. Ayes - 5 -Nays - 0. The City Clerk prepared ballots and the City Attorney distributed them to the Council who were asked to each select four names from the five nominees. After selections were made, they were tallied and the City Attorney announced that four names remained. The City Clerk prepared ballots and the City Attorney distributed them to the Council who were asked to each select three names. After selections were made, they were tallied and the City Attorney announced that three names remained. CITY OF APPLE VALLEY Dakota County, Minnesota February 23, 2017 Page 5 The City Clerk prepared ballots and the City Attorney distributed them to the Council who were asked to each select two names. After selections were made, they were tallied and the City Attorney announced that Matthew Hinrichs and Ben Van Gundy received the majority of votes. MOTION: of Goodwin, seconded by Grendahl, adopting Resolution No. 2017-39 appointing Matthew Hinrichs and Ben Van Gundy to the Parks and Recreation Advisory Committee for a term expiring March 1, 2020. Ayes - 5 -Nays - 0. Mayor Hamann-Roland thanked all the applicants who applied and expressed interest in the position. She also congratulated the reappointees and extended thanks to all Commissioners and Committee Members for their valuable services. CALENDAR OF UPCOMING EVENTS MOTION: of Grendahl, seconded by Hooppaw, approving the calendar of upcoming events as included in the Deputy City Clerk's memo, and noting that each event listed is hereby deemed a Special Meeting of the City Council. Ayes - 5 -Nays - 0. MOTION: of Bergman, seconded by Grendahl, to adjourn. Ayes - 5 -Nays - 0. The meeting was adjourned at 7:45 o'clock p.m. Respectfully Submitted, /s/Pamela J. Gackstetter Pamela J. Gackstetter, City Clerk Approved by the Apple Valley City Council on Mary Hamann-Roland, Mayor 0000: ITEM: 4.13. :0:: Apple COUNCIL MEETING DATE: March 9, 2017 Valley SECTION: Consent Agenda Description: Adopt Resolution Accepting Donations of Cash from Various Businesses for Mid-Winter Fest Activities Staff Contact: Department/ Division: Director, Barry Bernstein Parks and Recreation Department ACTION REQUESTED: Adopt the resolution accepting donations of cash from various businesses for 2017 Mid- Winter Fest activities. SUMMARY: Staff is seeking by resolution acceptance of various cash from area business to be used by the Parks and Recreation Department toward the 2017 Apple Valley Mid-Winter Fest activities. BACKGROUND: Various area businesses have generously offered to provide cash toward the sponsorship of the annual Mid-Winter Fest activities. Staff recommends accepting these donations and thanking the businesses for their generosity. BUDGET IMPACT: N/A ATTACHMENTS: Resolution Exhibit CITY OF APPLE VALLEY RESOLUTION NO. 2017 - A RESOLUTION ACCEPTING DONATIONS WHEREAS,the City Council of Apple Valley encourages public donations to help defray costs to the general public of providing services and improve the quality of life in Apple Valley; and WHEREAS, several businesses have offered to donate cash for use by the Apple Valley Parks and Recreation Department toward the sponsorship of the annual Mid-Winter Fest; and WHEREAS,Minnesota Statues 465.03 requires that all gifts and donations of real or personal property be accepted only with the adoption of a resolution approved by two-thirds of the members of the City Council. NOW, THEREFORE,BE IT RESOLVED by the City Council of the City of Apple Valley, Dakota County, Minnesota,that the donations listed in Exhibit A are hereby accepted for use by the City. BE IT FURTHER RESOLVED that the City sincerely thanks these businesses for their gracious donations. ADOPTED this 9th day of March, 2017 Mary Hamann-Roland, Mayor ATTEST: Pamela J. Gackstetter, City Clerk Exhibit A 2017 MID-WINTER FEST DONATIONS March 9, 2017 CASH DONATIONS AND SPONSORSHIP: Bischel Building, Inc.; $50.00 donation Centennial House of Apple Valley; $125.00 activity sponsorship The Seasons at Apple Valley; $125.00 donation 0000: ITEM: 4.C. :0:: Apple COUNCIL MEETING DATE: March 9, 2017 Valley SECTION: Consent Agenda Description: Approve State Gambling Exempt Permit for Minnesota Section American Water Works Association, at Bogart's/Apple Place Bowl, 14917 Garrett Avenue, on April 29, 2017 Staff Contact: Department/ Division: Pamela J. Gackstetter, City Clerk City Clerk's Office ACTION REQUESTED: Approve issuance of a lawful gambling exempt permit, by the State Gambling Control Board, to Minnesota Section American Water Works Association, for use on April 29, 2017, at Bogart's/Apple Place Bowl, 14917 Garrett Avenue, and waiving any waiting period for State approval. SUMMARY: Minnesota Section American Water Works Association, submitted an application for a gambling event to be held at Bogart's/Apple Place Bowl, 14917 Garrett Avenue, on April 29, 2017. The application is on file should you wish to review it. BACKGROUND: Exempt permits to conduct lawful gambling activities, on five or fewer days in a calendar year, for qualified nonprofit organizations, are issued by the State Gambling Control Board. Issuance is subject to approval or denial by the city in which the gambling activity is to be conducted. BUDGET IMPACT: N/A 0000: ITEM: 4.D. :0:: Apple COUNCIL MEETING DATE: March 9, 2017 Valley SECTION: Consent Agenda Description: Approve Special Outdoor Promotion/Temporary Sign Permit for 2017 Home and Garden Expo Staff Contact: Department/ Division: Joan Murphy, Department Assistant Community Development Department Applicant: Apple Valley Chamber of Commerce Project Number: Applicant Date: 60 Days: 120 Days: ACTION REQUESTED: Approve a Special Outdoor Promotion/Temporary Sign permit application for signage for the 2017 Home & Garden Expo to be placed on City property as shown on the attached plan from March 10 through April 8, 2017. SUMMARY: The Apple Valley Chamber of Commerce has submitted an application for the 2017 Home & Garden Expo to be held April 8, 2017, at the Dakota County Western Service Center, 14955 Galaxie Ave. This event draws upwards of 5,000 people and has been well received in the community. The Chamber is proposing to install two banner signs on City property at the southwest corner of Galaxie Avenue and 147th Street W. The signs would be installed on March 10, 2017, and removed the day of the event. The City has approved similar requests from the Chamber in past years. BACKGROUND: N/A BUDGET IMPACT: N/A ATTACHMENTS: Background Material CITY OF APPLE VALLEY SPECIAL OUTDOOR PROMOTION/TEMPORARY SIGN PERMIT APPLICATION 7100147th Street West Apple Valley, MN 55124 Phone: (952)953-2575 FAX: (952) 953-2515 email: commdev(a)ci.aw)Ie-vallev.mn,us *Please allow 5 days for processing This is an application for: (check which ever applies; see reverse side for explanation of terms) ❑ SPECIAL OUTDOOR PROMOTION OR SIDEWALK SALE-No Charge(City Code Sec. 155.358). Permitted in commercial zoning districts,limited to once a year,not to exceed 10 days,per business. Sidewalk sales are allowed two times a year,not to exceed 10 days each. Tents for all tent sales must be inspected by the City's Fire Marshal, and documentation for the tent will need to be reviewed by the Fire Marshal prior to issuance of the permit. Please adjust your schedule accordingly. 2v TEMPORARY SIGNAGE-No Charge(City Code Sec. 154.04(1)).Banners,balloons,streamers,and other similar temporary professionally made signs are permitted for grand openings,holidays,and special sales. Limited to two times per year, not to exceed 15 days each time. Temporary signage may not exceed a total of 30 days per calendar year. Note: The City Code strictly prohibits portable signs,flashing signs and electronic signs, Name of Applicant: (/ s Mailing Address: 1719MM9 //6ui/0 � O AW �Q / /&& Vl 5-57 Z (�J Phone Number: 9572 — 7�Z 9*//!ZZ _ Fax: Address or legal description of property where business will be conducted: �Ae, Purpose of application, description of items to be sold, location on lot of sale(Please note if this is a tent sale): T" L 3 /D17 - u f7 Dates of events and/or signage: CYGy/7 / / g , Application Date: 7 / Signature of Applicant: _ Printed Name of Applicant:_ Consent and approval of property owner if other than applicant: I hereby consent to the above desc ed use of my property and agree to comply with the regulations imposed by the Apple Valley City Code if so approved. Date: Signature of Property Owner: Printed Name of Property Owner: Address of Property Owner if Other Than Applicant: Property Owner's Phone No.: Fax: Attach a site plan, survey or scaled drawing showing existing and proposed structures, driveways, parking areas,signage and similar details. Also show or describe location of promotional items(banners,tables, merchandise, etc.) All information, including signatures,must be included with the aoolication request before the City can Process the aoolication! You may use the back of this form to illustrate the requested 4oKormatlon.� r f� FOR INTERNAL CITY USE ONLY ate,Received: Permit No Approved by: Approval Date: Rr/d n- I 1 87/12 EXPLANATION OF TERMS Special Outdoor Promotion—Outdoor promotional events such as tent sales, carnivals, fireworks sales,or any other sale that occurs outdoors. Promotional events are limited to one(1)time per calendar year not to exceed 10 days. Tents for all tent sales must be inspected by the City's Fire Marshal, and documentation for the tent will need to be reviewed by the Fire Marshal prior to issuance of the permit. Please adjust your schedule accordingly. Sidewalk Sale—Outdoor display and sales of products limited to the area immediately adjacent to the front of the store on the sidewalk or parking lot. Sidewalk sales are limited to two times per year, not to exceed 10 days per sale per business per calendar year. The two sidewalk sales may run consecutively not to exceed 20 days per calendar year. Temporary Signage—Any signs,banners, balloons, streamers, pennants, sandwich boards, bandit signs, employment signs,grand opening signs,and the like which may be used to direct attention to a special sale or event. Temporary signs must be placed on the property where the event or sale is being held. Any commercial or institutional property is entitled to place temporary signs on the property two times per year for a period not to exceed 15 days, or once per calendar year for a period not to exceed 30 days. PLEASE NOTE THAT PORTABLE SIGNS WITH CHANGEABLE COPY, ALL FLASHING SIGNS AND ELECTRONIC SIGNS ARE STRICTLY PROHIBITED! Please use the space below to draw a site plan showing the existing and proposed structure (tents, canopies, etc.) on the site where the special promotion will occur. Please show the location of driveways, parking areas, signage and similar detail,as well as the location of promotional items (banners, tables, merchandise, etc.) l� v / L/ � n` f�MrK M VM 14 P AI- �"TC4 Form Revision_ 1127/13 0000: ITEM: 4.E. :0:: Apple COUNCIL MEETING DATE: March 9, 2017 Valley SECTION: Consent Agenda Description: Appoint Malloy, Montague, Karnowski, Radosevich & Co., P.A., as Auditors for Fiscal Years 2016, 2017, and 2018 Staff Contact: Department/ Division: Ron Hedberg, Finance Director Finance Department ACTION REQUESTED: Appoint Malloy, Montague, Karnowski, Radosevich (NMKR) and Co., PA, as auditors for 2016, 2017, 2018 fiscal year audits. SUMMARY: The City Council is asked to approve 1VMKR as auditors for the 2016, 2017, and 2018 fiscal years. The estimated fees for the three years for the Basic Audit are $44,000, 44,600 and $45,000. The $44,000 amount for the 2016 fiscal year is a 1.3% increase over the 2015 base audit fee. The City selected MMKR following an RFP process for audit services in 2013 at which time NEVIKR and Co., PA was selected. The attached proposal also includes a cost estimate for a Single Audit which would be required if the City were to expend more than $750,000 in federal funds in a given year. At this time it is not expected that the City will receive federal dollars requiring a Single Audit. BACKGROUND: N/A BUDGET IMPACT: N/A ATTACHMENTS: Agreement Exhibit PRINCIPALS Thomas A.Karnowski,CPA Paul A.Radosevich,CPA MMKRWilliam J.Lauer,CPA James H.Eichten,CPA C, R RT 1 F I L U PUBLIC Aaron J.Nielsen,CPA ACCOUNTANTS Victoria L.Holinka,CPA/CMA February 28,2017 To the City Council and Management of the City of Apple Valley 7100—147th Street West Apple Valley,MN 55124 Dear Councilmembers and Management: We are pleased to confirm our understanding of the services we are to provide the City of Apple Valley (the City) for the year ended December 31, 2016. We will audit the financial statements of the governmental activities, the business-type activities, each major fund, and the aggregate remaining fund information, including the related notes to the financial statements, including the related notes to the financial statements, which collectively comprise the basic financial statements of the City as of and for the year ended December 31, 2016. Accounting standards generally accepted in the United States of America provide for certain required supplementary information(RSI), such as Management's Discussion and Analysis (MD&A), to supplement the City's basic financial statements. Such information, although not a part of the basic financial statements, is required by the Governmental Accounting Standards Board (GASB) who considers it to be an essential part of financial reporting for placing the basic financial statements in an appropriate operational, economic, or historical context. As part of our engagement, we will apply certain limited procedures to the City's RSI in accordance with auditing standards generally accepted in the United States of America. These limited procedures will consist of inquiries of management regarding the methods of preparing the information and comparing the information for consistency with management's responses to our inquiries, the basic financial statements, and other knowledge we obtained during our audit of the basic financial statements. We will not express an opinion or provide any assurance on the information because the limited procedures do not provide us with sufficient evidence to express an opinion or provide any assurance. The following RSI is required by accounting principles generally accepted in the United States of America and will be subjected to certain limited procedures,but will not be audited: 1) MD&A 2) GASB-required supplementary pension and other post-employment benefits information We have also been engaged to report on supplementary information other than RSI that accompanies the City's financial statements. We will subject the following supplementary information to the auditing procedures applied in our audit of the financial statements and certain additional procedures, including comparing and reconciling such information directly to the underlying accounting and other records used to prepare the financial statements or to the financial statements themselves, and other additional procedures in accordance with auditing standards generally accepted in the United States of America, and we will provide an opinion on it in relation to the financial statements as a whole, in a separate written report accompanying our auditor's report on the financial statements OR in a report combined with our auditor's report on the financial statements: 1) Combining and individual fund statements and schedules, presented as supplemental information Malloy, Montague, Karnowski, Radosevich & Co., P.A. 5353 Wayzata Boulevard • Suite 410 * Minneapolis, MN 55416 • Pbone: 952-545-0424 • Fax: 952-545-0569 • www.mmkr.com City of Apple Valley Page 2 February 28,2017 The following other information accompanying the financial statements will not be subjected to the auditing procedures applied in our audit of the financial statements, and our auditor's report will not provide an opinion or any assurance on that other information: 1) Introductory information 2) Statistical section We will perform the required State Legal Compliance Audit conducted in accordance with auditing standards generally accepted in the United States of America and the provisions of the Legal Compliance Audit Guide, promulgated by the State Auditor pursuant to Minnesota Statute § 6.65, and will include such tests of the accounting records and other procedures we consider necessary to enable us to conclude that, for the items tested, the City has complied with the material terms and conditions of applicable legal provisions. We will also prepare a management report for the City Council and administration. This report will communicate such things as our concerns regarding accounting procedures or policies brought to our attention during our audit, along with recommendations for improvements. The report will also contain certain financial comparisons and analysis, and a summary of legislative activity affecting Minnesota cities. Our services will not include an audit in accordance with the Single Audit Act Amendments of 1996 and Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), which would only be required if the City expended $750,000 or more in federal assistance funds during the year. If the City is required to have a Single Audit of federal assistance funds, this engagement letter would need to be modified. Audit Objectives The objective of our audit is the expression of opinions as to whether your financial statements are fairly presented, in all material respects, in conformity with accounting principles generally accepted in the United States of America and to report on the fairness of the supplementary information referred to in the second paragraph when considered in relation to the financial statements as a whole. Our audit will be conducted in accordance with auditing standards generally accepted in the United States of America and the standards for financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States, and will include tests of the accounting records of the City and other procedures we consider necessary to enable us to express such opinions. We will make reference to another auditor's audit of required components if necessary in our report on your financial statements. We will issue a written report upon completion of our audit of the City's financial statements. Our report will be addressed to management and the City Council of the City. We cannot provide assurance that unmodified opinions will be expressed. Circumstances may arise in which it is necessary for us to modify our opinions or add emphasis-of-matter or other-matter paragraphs. If our opinions on the financial statements are other than unmodified,we will discuss the reasons with you in advance. If, for any reason, we are unable to complete the audit or are unable to form or have not formed opinions,we may decline to express opinions or issue reports, or may withdraw from this engagement. City of Apple Valley Page 3 February 28,2017 We will also provide a report(that does not include an opinion) on internal control related to the financial statements and compliance with the provisions of laws, regulations, contracts, and grant agreements, noncompliance with which could have a material effect on the financial statements as required by Government Auditing Standards. The report on internal control and on compliance and other matters will include a paragraph that states (1) that the purpose of the report is solely to describe the scope of testing of internal control and compliance, and the results of that testing, and not to provide an opinion on the effectiveness of the entity's internal control on compliance, and(2)that the report is an integral part of an audit performed in accordance with Government Auditing Standards in considering the entity's internal control and compliance. The paragraph will also state that the report is not suitable for any other purpose. If during our audit we become aware that the City is subject to an audit requirement that is not encompassed in the terms of this engagement, we will communicate to management and those charged with governance that an audit in accordance with auditing standards generally accepted in the United States of America and the standards for financial audits contained in Government Auditing Standards may not satisfy the relevant legal,regulatory, or contractual requirements. Audit Procedures—General An audit includes examining, on a test basis, evidence supporting the amounts and disclosures in the financial statements; therefore, our audit will involve judgment about the number of transactions to be examined and the areas to be tested. An audit also includes evaluating the appropriateness of accounting policies used and the reasonableness of significant accounting estimates made by management, as well as evaluating the overall presentation of the financial statements. We will plan and perform the audit to obtain reasonable rather than absolute assurance about whether the financial statements are free of material misstatement, whether from(1) errors, (2) fraudulent financial reporting, (3) misappropriation of assets, or (4) violations of laws or governmental regulations that are attributable to the government or to acts by management or employees acting on behalf of the government. Because the determination of abuse is subjective, Government Auditing Standards do not expect auditors to provide reasonable assurance of detecting abuse. Because of the inherent limitations of an audit, combined with the inherent limitations of internal control, and because we will not perform a detailed examination of all transactions, there is a risk that material misstatements may exist and not be detected by us, even though the audit is properly planned and performed in accordance with auditing standards generally accepted in the United States of America and Government Auditing Standards. In addition, an audit is not designed to detect immaterial misstatements or violations of laws or governmental regulations that do not have a direct and material effect on the financial statements. However, we will inform the appropriate level of city or group management of any material errors, any fraudulent financial reporting, or misappropriation of assets that come to our attention. We will also inform the appropriate level of city or group management of any violations of laws or governmental regulations that come to our attention, unless clearly inconsequential, and of any material abuse that comes to our attention. Our responsibility as auditors is limited to the period covered by our audit and does not extend to later periods for which we are not engaged as auditors. Our procedures will include tests of documentary evidence supporting the transactions recorded in the accounts, and may include tests of the physical existence of inventories, and direct confirmation of receivables and certain other assets and liabilities by correspondence with selected individuals, funding sources, creditors, and financial institutions. We will request written representations from your attorneys as part of the engagement, and they may bill you for responding to this inquiry. At the conclusion of our audit, we will require certain written representations from you about your responsibilities for the financial statements; compliance with laws, regulations, contracts, and grant agreements; and other responsibilities required by auditing standards generally accepted in the United States of America. City of Apple Valley Page 4 February 28,2017 If information from a component unit is required to be included in the City's financial statements,we will not audit the financial statements of components of which we were not engaged as auditors as of and for the year ended December 31, 2016. Those financial statements will be audited by other auditors whose reports thereon will be furnished to us. We will communicate with the other auditors and reference their audit of the component(s) as necessary. Information from the group component audit will be included in the City's financial statements based on materiality, significance to the audit, and auditor judgement. Audit Procedures—Internal Control Our audit will include obtaining an understanding of the government and its environment, including internal control, sufficient to assess the risks of material misstatement of the financial statements and to design the nature, timing, and extent of further audit procedures. Tests of controls may be performed to test the effectiveness of certain controls that we consider relevant to preventing and detecting errors and fraud that are material to the financial statements and to preventing and detecting misstatements resulting from illegal acts and other noncompliance matters that have a direct and material effect on the financial statements. Our tests, if performed, will be less in scope than would be necessary to render an opinion on internal control and, accordingly, no opinion will be expressed in our report on internal control issued pursuant to Government Auditing Standards. An audit is not designed to provide assurance on internal control or to identify significant deficiencies or material weaknesses. However, during the audit, we will communicate to city or group management and those charged with governance of the city or group, internal control-related matters that are required to be communicated under American Institute of Certified Public Accountants (AICPA) professional standards and Government Auditing Standards. Audit Procedures—Compliance As part of obtaining reasonable assurance about whether the financial statements are free of material misstatement, we will perform tests of the City's compliance with the provisions of applicable laws, regulations, contracts, agreements, and grants. However, the objective of our audit will not be to provide an opinion on overall compliance and we will not express such an opinion in our report on compliance issued pursuant to Government Auditing Standards. Management Responsibilities Management is responsible for establishing and maintaining effective internal controls, including evaluating and monitoring ongoing activities, to help ensure that appropriate goals and objectives are met; following laws and regulations; and ensuring that management and financial information is reliable and properly reported. Management is also responsible for implementing systems designed to achieve compliance with applicable laws, regulations, contracts, and grant agreements. You are also responsible for the selection and application of accounting principles, for the preparation and fair presentation of the financial statements and all accompanying information in conformity with accounting principles general accepted in the United States of America, and for compliance with applicable laws and regulations and the provisions of contracts and grant agreements. Management is also responsible for making all financial records and related information available to us and for the accuracy and completeness of that information. You are also responsible for providing us with (1) access to all information of which you are aware that is relevant to the preparation and fair presentation of the financial statements, (2) additional information that we may request for the purpose of the audit, and (3) unrestricted access to persons within the government from whom we determine it necessary to obtain audit evidence. City of Apple Valley Page 5 February 28,2017 Your responsibilities include adjusting the financial statements to correct material misstatements and for confirming to us in the written representation letter that the effects of any uncorrected misstatements aggregated by us during the current engagement and pertaining to the latest period presented are immaterial,both individually and in the aggregate,to the financial statements taken as a whole. You are responsible for the design and implementation of programs and controls to prevent and detect fraud, and for informing us about all known or suspected fraud affecting the government involving (1)management, (2) employees who have significant roles in internal control, and (3) others where the fraud could have a material effect on the financial statements. Your responsibilities include informing us of your knowledge of any allegations of fraud or suspected fraud affecting the government received in communications from employees, former employees, grantors, regulators, or others. In addition, you are responsible for identifying and ensuring that the government complies with applicable laws, regulations, contracts, agreements, and grants and for taking timely and appropriate steps to remedy fraud and noncompliance with provisions of laws, regulations, contracts or grant agreements, or abuse that we report. You are responsible for the preparation of the supplementary information, which we have been engaged to report on, in conformity with accounting principles generally accepted in the United States of America. You agree to include our report on the supplementary information in any document that contains and indicates that we have reported on the supplementary information. You also agree to include the audited financial statements with any presentation of the supplementary information that includes our report thereon OR make the audited financial statements readily available to users of the supplementary information no later than the date the supplementary information is issued with our report thereon. Your responsibilities include acknowledging to us in the written representation letter that (1) you are responsible for presentation of the supplementary information in accordance with accounting principles generally accepted in the United States of America; (2) you believe the supplementary information, including its form and content, is fairly presented in accordance with accounting principles generally accepted in the United States of America; (3) the methods of measurement or presentation have not changed from those used in the prior period (or, if they have changed, the reasons for such changes); and (4)you have disclosed to us any significant assumptions or interpretations underlying the measurement or presentation of the supplementary information. Management is responsible for establishing and maintaining a process for tracking the status of audit findings and recommendations. Management is also responsible for identifying and providing report copies of previous financial audits, attestation engagements,performance audits or other studies related to the objectives discussed in the Audit Objectives section of this letter. This responsibility includes relaying to us corrective actions taken to address significant findings and recommendations resulting from those audits, attestation engagements, performance audits, or other studies. You are also responsible for providing management's views on our current findings, conclusions, and recommendations, as well as your planned corrective actions, for the report, and for the timing and format for providing that information. Engagement Administration,Fees,and Other We understand that your employees will prepare all cash or other confirmations we request and will locate any documents selected by us for testing. The assistance to be supplied by your personnel, including the preparation of schedules and analysis of accounts, typing all cash or other confirmations we request, and locating any invoices selected by us for testing,will be discussed and coordinated with you. City of Apple Valley Page 6 February 28,2017 We will provide copies of our reports to the City; however, management is responsible for distribution of the reports and the financial statements. Unless restricted by law or regulation, or containing privileged and confidential information, copies of our reports are to be made available for public inspection. The audit documentation for this engagement is the property of Malloy, Montague, Karnowski, Radosevich & Co., P.A. (MMKR) and constitutes confidential information. However, subject to applicable laws and regulations, audit documentation and appropriate individuals will be made available upon request and in a timely manner to a regulatory agency or its designee, a federal agency providing direct or indirect funding, or the U.S. Government Accountability Office for purposes of a quality review of the audit, to resolve audit findings, or to carryout oversight responsibilities. We will notify you of any such request. If requested, access to such audit documentation will be provided under the supervision of MMKR personnel. Furthermore,upon request,we may provide copies of selected audit documentation to the aforementioned parties. These parties may intend, or decide, to distribute the copies or information contained therein to others,including other governmental agencies. The audit documentation for this engagement will be retained for a minimum of five years after the report release date or for any additional period requested by the regulatory agency. If we are aware that a federal awarding agency or auditee is contesting an audit finding, we will contact the party(ies) contesting the audit finding for guidance prior to destroying the audit documentation. We expect to begin our audit shortly after the end of your fiscal year and to issue our reports prior to June 30, 2017. James H. Eichten, CPA is the engagement partner and is responsible for supervising the engagement and signing the reports. Our fees for these services will be at our standard hourly rates plus out-of-pocket costs (such as report reproduction,word processing,postage,travel, copies, telephone, etc.) except that we agree that our gross fee, including expenses, will be as described in the Dollar Cost Bid Proposal for Professional Auditing Services. Our standard hourly rates vary according to the degree of responsibility involved and the experience level of the personnel assigned to your audit. Our invoices for these fees will be rendered each month as work progresses and are payable on presentation. In accordance with our firm policies, work may be suspended if your account becomes 60 days or more overdue and may not be resumed until your account is paid in full. If we elect to terminate our services for nonpayment, our engagement will be deemed to have been completed upon written notification of termination, even if we have not completed our report. You will be obligated to compensate us for all time expended and to reimburse us for all out-of-pocket costs through the date of termination. Our fees are based on anticipated cooperation from your personnel and the assumption that unexpected circumstances will not be encountered during the audit. If we find that additional audit procedures are required, or if additional services are requested by the City, those services will be billed at our standard hourly rates. Additional audit procedures might be required for certain accounting issues or events, such as new contractual agreements, transactions and legal requirements of new bond issues, new funds, major capital projects, new tax increment districts, if there is an indication of misappropriation or misuse of public funds, or if significant difficulties are encountered due to the lack of accounting records, incomplete records, or turnover in the City's staff. If significant additional time is necessary, we will discuss it with you before we incur the additional costs. City of Apple Valley Page 7 February 28,2017 With regard to the electronic dissemination of audited financial statements, including financial statements published electronically on your website, you understand that electronic sites are a means to distribute information and, therefore, we are not required to read the information contained in these sites or to consider the consistency of other information in the electronic site with the original document. If you intend to publish or otherwise reproduce the financial statements, such as in a bond statement, and make reference to our firm name, you agree to provide us with printers' proofs or masters for our review and approval before printing. You also agree to provide us with a copy of the final reproduced material for our approval before it is distributed. During the year, you might request additional services such as routine advice, assistance in implementing audit recommendations, review of your projections or budgets, and other similar projects. Independence standards allow us to perform these routine services; however, it is important that you understand that we are not allowed to make management decisions, perform management functions, nor can we audit our own work or provide nonaudit services that are significant to the subject matter of the audit. Please be aware that e-mail is not a secure method of transmitting data. It can be intercepted, read, and possibly changed. Due to the large volume of e-mails sent daily, the likelihood of someone intercepting your e-mail is relatively small, but it does exist. We will communicate with you via e-mail, if you are willing to accept this risk. To ensure that MMKR's independence is not impaired under the AICPA Code of Professional Conduct, you agree to inform the engagement partner before entering into any substantive employment discussions with any of our personnel. If a dispute occurs related in any way to our services, our firm and the City agree to discuss the dispute and, if necessary,to promptly mediate in a good faith effort to resolve it. We will agree on a mediator,but if we cannot, either of us may apply to a court having personal jurisdiction over the parties for appointment of a mediator. We will share the mediator's fees and expenses equally, but otherwise will bear our own attorney fees and costs of the mediation. Participation in such mediation shall be a condition to either of us initiating litigation. To allow time for the mediation, any applicable statute of limitations shall be tolled for a period not to exceed 120 days from the date either of us first requests in writing to mediate the dispute. The mediation shall be confidential in all respects, as allowed or required by law, except that our final settlement positions at mediation shall be admissible in litigation solely to determine the identity of the prevailing party for purposes of the awarding of attorney fees. We both recognize the importance of performing our obligations under this agreement in a timely way and fully cooperating with the other. In the event that either of us fails to timely perform or fully cooperate, the other party may, in its sole discretion, elect to suspend performance or terminate the agreement regardless of the prejudice to the other person. We agree we will give 10 days' written notice of an intent to suspend or terminate, specifying the grounds for our decision, and will give the other an opportunity to cure the circumstances cited as grounds for that decision. In the event of suspension or termination, all fees and costs are immediately due on billing. City of Apple Valley Page 8 February 28,2017 We agree that it is important that disputes be discussed and resolved promptly. For that reason, we agree that,notwithstanding any other statutes of limitations or court decisions concerning them, all claims either of us may have will be barred unless brought within one year of the date the complaining party first incurs any damage of any kind, whether discovered or not, related in any way to acts or omissions of the other party, whether or not the complaining party seeks recovery for that first damage and whether or not we have continued to maintain a business relationship after the first damage occurred. Notwithstanding anything in this letter to the contrary, we agree that regardless of where the City is located, or where this agreement is physically signed, this agreement shall have been deemed to have been entered into at our office in Hennepin County, Minnesota, and Hennepin County shall be the exclusive venue and jurisdiction for resolving disputes related to this agreement. This agreement shall be interpreted and governed under the laws of Minnesota. When requested, Government Auditing Standards require that we provide you with a copy of our most recent external peer review report and any letter of comment, and any subsequent peer review reports and letters of comment received during the period of the contract. Our most recent peer review report accompanies this letter. We appreciate the opportunity to be of service to the City and believe this letter accurately summarizes the significant terms of our engagement. If you have any questions, please let us know. If you agree with the terms of our engagement as described in this letter,please sign the enclosed copy and return it to us. Sincerely, MALLOY,MONTAGUE,KARNOWSKI, RADOSEVICH & CO., P.A. J#ies H. Eichten, CPA ncipal JHE:lmb Response: This letter correctly sets forth the understanding of the City of Apple Valley. By: Title: Date: I "000 i ..1.65990 8 � 1I 1.240.000 240,00 9 903 i,8g0 0003 i 11 7.734 32 .663 4�8 ©0 11-32,6 3� b f po 6"511, 124 0® 0 .370-69 / .2�?8 5� S,812,632 Q0 0 1,496 57 t--- 4,8S i i � !� 1,34 Q'S 7S r 00-S4 r`'� C� 11,842.s ' S,03 i 11..288 cv d 69 4,4 S3 �- 4 .346 72 .51 e-- X80 SO i 307.35 4 7 84 2,.2na 2.64 DOLLAR COST BID PROPOSAL SCHEDULE OF PROFESSIONAL FEES AND EXPENSES FOR CITY OF APPLE VALLEY, MINNESOTA FOR PROFESSIONAL AUDITING SERVICES FOR FISCAL YEARS ENDING DECEMBER 31, 2016, 2017, AND 2018 MALLOY MMKR MONTAGUE KARNuws m CERTIFIED PUBLIC RAD05EVICH JAMES H. EICHTEN, PRINCIPAL ACCOUNTANTS &CO., P.A. E—MAIL: JEICHTEN@MMKR.COM 5353 Wayzata Boulevard - suite 410 • Minneapolis, MRI 55416 952.545.0424 Telephone:952-545-0424 wehsiFax: 1)52-545-0569 re:www.mmkr.cam City of Apple Valley, Minnesota Schedule of Professional Fees and Expenses For Professional Auditing Services Estimated fees for the years ending December 31, 2016, 2017, and 2018: Single Year Ending Basic Audit December 31, Audit Estimate 2016 $ 44,000 $ 3,500 2017 44,600 3,500 2018 45,000 3,500 Total $ 133,600 $ 10,500 1 certify that I am entitled to represent Malloy, Montague, Karnowski, Radosevich & Co., P.A., (MMKR), empowered to submit the bid, and authorized to sign a ntract,,4vith the City of Apple Valley, Minnesota (the City). Signed: Ja H. Eichten, CPA Pri,'ipal Additional services hourly rates: If it should become necessary for the City to request the auditor to render any additional service to either supplement the services requested in this proposal or to perform additional work as a result of the specific recommendations included in any report issued on this engagement or as a result of new standards, then such additional work shall be performed only if set forth in an addendum to the contract between the City and MMKR. Any such additional work agreed to between the City and MMKR shall be performed at the same rates set forth in the Schedule of Professional Fees and Expenses included in this Dollar Cost Bid Proposal. MMKR does not charge its audit clients for inquiries and technical assistance during the year that are minor in nature (those that would not require a significant amount of research or result in the issuance of a separate report letter or letter). City of Apple Valley, Minnesota Schedule of Professional Fees and Expenses For Professional Auditing Services Estimated fees for the year ending December 31, 2016: Standard Quoted Hourly Hourly Hours Rates Total Total Basic audit Principals 29 $ 275 $ 245 $ 7,105 Managers 41 215 195 7,995 Senior Associates 161 120 110 17,710 Associates and Staff Accountants 114 95 85 9,690 Other—clerical 30 55 50 1,500 Total base fee for the 2016 audit 375 $ 44,000 Single Audit estimate (if necessary) 30 $ 3,500 City of Apple Valley, Minnesota Schedule of Professional Fees and Expenses For Professional Auditing Services Estimated fees for the year ending December 31, 2017: Standard Quoted Hourly Hourly Hours Rates Total Total Basic audit Principals 29 $ 275 $ 245 $ 7,105 Managers 41 215 190 7,790 Senior Associates 161 120 115 18,515 Associates and Staff Accountants 114 95 85 9,690 Other—clerical 30 55 50 1,500 Total base fee for the 2017 audit 375 $ 44,600 Single Audit estimate (if necessary) 30 $ 3,500 City of Apple Valley, Minnesota Schedule of Professional Fees and Expenses For Professional Auditing Services Estimated fees for the year ending December 31, 2018: Standard Quoted Hourly Hourly Hours Rates Total Total Basic audit Principals 30 $ 275 $ 246 $ 7,380 Managers 40 215 191 7,640 Senior Associates 155 120 110 17,050 Associates and Staff Accountants 120 95 95 11,400 Other—clerical 30 55 51 1,530 Total base fee for the 2018 audit 375 $ 45,000 Single Audit estimate (if necessary) 30 $ 3,500 *00 *000 *000 09000 ITEM: 4.F. 000 Apple COUNCIL MEETING DATE: March 9, 2017 Valley SECTION: Consent Agenda Description: Adopt Resolution Changing Bid Date for Project 2016-101, Water Meter Replacement, and Authorizing Receipt of Bids at 10:00 a.m. on April 6, 2017 Staff Contact: Department/ Division: Carol Blommel Johnson, Public Works Superintendent- Utilities Utilities Division ACTION REQUESTED: Adopt the resolution changing the bid date for Project 2016-101, Water Meter Replacement, and authorizing receipt of bids at 10 a.m. on April 6, 2017. SUMMARY: The plans and specifications for the water meter replacement project were released on February 10, 2017. Since that time, Staff has received numerous requests to extend the bid opening for two additional weeks due to the specialized nature and detailed bid response requirements of this project. After meeting with SL serco and the City attorney it was determined that extending the bid opening date would be advantageous to the project. The original bid opening date was March 23, 2017. BACKGROUND: The water meter replacement program will replace the aging water meters and meter reading system with new accurate water meters and Advanced Metering Infrastructure (AMI) technology. Advanced Metering Infrastructure (AMI) is a system where a meter is read by a signal sent to a data collection system which transmits it to a central location. Automatic Meter Reading (AMR) is where a vehicle mounted device interrogates the meter and the reading is transmitted to the recording unit while driving a route designed to collect the meter readings. This project bid is for the AMI system with the AMR system as an alternate. The AMI system would require ongoing network maintenance, software support and data hosting charges. The bid documents require the vendors provide the cost for these services. Benefits of the meter replacement program include: • Address the City's aging water meter and meter reading system. • Address commercial meters of the incorrect size (right sizing). • Inspection of sump pumps to identify areas of inflow and infiltration. • Improve customer service with both billing and maintenance staff. • Ability to provide more accurate and timely information to customers regarding water usage. • Reduction of non-revenue water loss by water resource management and conservation. • Reduce the number of truck rolls to improve carbon footprint. Plans and specifications are available for viewing in the office of the Public Works Superintendent - Utilities. BUDGET IMPACT: The change in bid opening date will not have an impact on the budget for this project. ATTACHMENTS: Resolution Exhibit CITY OF APPLE VALLEY RESOLUTION NO. 2017- RESOLUTION CHANGING DATE FOR RECEIPT OF SEALED BIDS FOR PROJECT 2016-101, WATER METER REPLACEMENT PROGRAM WHEREAS, the City Council believes that the interests of the City would be best served by changing the date for receiving sealed bids based on said plans and specifications. NOW, THEREFORE, BE IT RESOLVED by the City Council of the City of Apple Valley, Dakota County, Minnesota, as follows: 1. The City Clerk is hereby authorized to receive sealed bids at the time and place specified in the form of notice attached hereto as Exhibit A. ADOPTED this 9th day of March, 2017 Mary Hamann-Roland, Mayor ATTEST: Pamela J. Gackstetter, City Clerk Exhibit A ADVERTISEMENT FOR BIDS Sealed Bids will be received by the City of Apple Valley, Minnesota, in the Apple Valley Municipal Center 7100 147th Street West, until 10:00 AM, Central Time, Thursday, April 6, 2017, at which time they will be publicly opened and read aloud for the furnishing of all labor, materials, and all else necessary for the following: City Proiect 2016-101, Water Meter Replacement Proiect Bidders desiring Bidding Documents may purchase them for a non-refundable fee of$20 by visiting www.cityofapplevalley.org or www.questcdn.com. Contact Cheryl Groves at (952) 953-2400 for questions about ordering. The Bidding Documents may be viewed at the office of the City Clerk, 7100 147th Street West, Apple Valley, MN. Direct inquiries to Public Works Superintendent— Utilities, Carol Blommel Johnson at (952) 953- 2441 or cblommel@ci.apple-valley.mn.us. Bid Security in the amount of 5 percent of the amount of the Bid must accompany each Bid in accordance with the Instructions to Bidders. The Owner reserves the right to retain the deposits of the 3 highest scoring responsible Bidders for a period not to exceed 60 days after the date and time set for the Opening of Bids. No Bids may be withdrawn for a period of 60 days after the date and time set for the Opening of Bids. The Owner reserves the right to reject any and all Bids, to waive irregularities and informalities therein, and further reserves the right to award the Contract to the best interests of the Owner. A full and complete copy of all solicitations of bids is disseminated on the City's website at www.cilyofapplevalley.org. 0000: ITEM: 4.G. :0:: Apple COUNCIL MEETING DATE: March 9, 2017 Valley SECTION: Consent Agenda Description: Approve Grant Agreement with Minnesota Board of Water and Soil Resources for Keller Lake Subwatershed Assessment Staff Contact: Department/ Division: Jessica Schaum, Natural Resources Coordinator Natural Resources Division ACTION REQUESTED: Approve Grant Agreement with Minnesota Board of Water and Soil Resources for Keller Lake subwatershed assessment. SUMMARY: The Public Works Department was notified in December 2016 by the Minnesota Board of Water and Soil Resources (BWSR) of a successful Clean Water Fund Grant application. The City was awarded $30,000 for accelerated water quality planning in the Keller Lake subwatershed area. BACKGROUND: N/A BUDGET IMPACT: The grant requires 25% matching funds from the City. Matching funds can include staff oversight and project coordination up to $7,500. If the 25% match is not reached, funds for TMDL Coordination are included in the 2017 Stormwater Utility. ATTACHMENTS: Agreement Background Material FY 2017 STATE OF MINNESOTA BOARD OF WATER and SOIL RESOURCES min COMPETITIVE GRANTS PROGRAM Ig�UAGRANT AGREEMENT A&AR , 0000199149 3000007741 This Grant Agreement is between the State of Minnesota, acting through its Board of Water and Soil Resources (Board) and Apple Valley,City of,7100 W 147th St Apple Valley Minnesota 55124 (Grantee). C17-7645 Keller Lake Subwatershed Assessment $30,000 Total Grant Awarded: $30,000 Recitals 1. Minnesota Statutes 10313.101, subd. 9 (1), and 103B.3369, authorize the Board to award this grant. 2. The Laws of Minnesota 2015, 1st Special Session, Chapter 2,Article 2, Section 7(b—Projects and Practices) (c— Accelerated Implementation) (h—Community Partners) and (k—multi-purpose drainage), appropriated Clean Water Fund (CWF)funds to the Board for the FY 2017 Competitive Grants Program. 3. The Minnesota Department of Health transferred funds to the Board for the Well Sealing Grant Program. 4. The Board adopted the FY 2017 Clean Water Fund Competitive Grants Policy and authorized the FY 2017 Competitive Grants Program in Board Resolution 16-52. 5. The Board adopted Board Resolution 16-98 to allocate funds for the FY 2017 Competitive Grants Programs. 6. The Grantee has submitted a BWSR approved work plan for this Program which is incorporated into this agreement by reference. 7. The Grantee represents that it is duly qualified and agrees to perform all services described in this grant agreement to the satisfaction of the State. 8. As a condition of the grant, Grantee agrees to minimize administration costs. Authorized Representative The State's Authorized Representative is Marcey Westrick, Clean Water Coordinator, BWSR, 520 Lafayette Road North, Saint Paul, MN 55155, 651-284-4153, or her successor, and has the responsibility to monitor the Grantee's performance and the authority to accept the services and performance provided under this Grant Agreement. The Grantee's Authorized Representative is: TITLE Matt Saam, Public Works Director ADDRESS 7100147 th Street W CITY Apple Valley, MN 55124 TELEPHONE NUMBER 952-953-2412 If the Grantee's Authorized Representative changes at any time during this Grant Agreement,the Grantee must immediately notify the Board. Grant Agreement 1. Term of Grant Agreement 1.1. Effective date: The date the Board obtains all required signatures under Minn.Stat. § 166.98,Subd.S.The State's Authorized Representative will notify the Grantee when this grant agreement has been executed. The Grantee must not begin work under this grant agreement until it is executed. Page 1 of 5 1.2. Expiration date: December 31,2019,or until all obligations have been satisfactorily fulfilled,whichever comes first. 1.3. Survival of Terms: The following clauses survive the expiration or cancellation of this Agreement: 7. Liability; 8.State Audits;9.Government Data Practices; 11. Publicity and Endorsement; 12. Governing Law,Jurisdiction, and Venue; 14. Data Disclosure;and 18. Intellectual Property Rights. 2. Grantee's Duties The Grantee will comply with required grants management policies and procedures set forth through Minn.Stat. § 1613.97, Subd.4(a)(1).The Grantee is responsible for the specific duties for the Program as follows: 2.1. Implementation: The Grantee will implement their work plan,which is incorporated into this Agreement by reference. 2.2. Reporting: All data and information provided in a Grantee's report shall be considered public. 2.2.1. The Grantee will submit an annual progress report to the Board by February 1 of each year on the status of program implementation by the Grantee. Information provided must conform to the requirements and formats set by the Board. 2.2.2.The Grantee will display on its website the previous calendar year's detailed information on the expenditure of these State grant funds and measurable outcomes as a result of the expenditure of these State grant funds according to the format specified by the BWSR, by March 15 of each year. 2.2.3. Final Progress Report: The Grantee will submit a final progress report to the Board by February 1,2020 or within 30 days of completion of the project,whichever occurs sooner. Information provided must conform to the requirements and formats set by the Board. 2.3. Match:The Grantee will ensure any local match requirement will be provided as stated in Grantee's approved work plan. 3. Time The Grantee must comply with all the time requirements described in this Grant Agreement. In the performance of this Grant Agreement,time is of the essence. 4. Terms of Payment 4.1. Grant funds will be distributed in three installments: 1)The first payment of 50%will be distributed after the execution of the Grant Agreement. 2)The second payment of 40%will be distributed after the first payment of 50%has been expended and reporting requirements have been met. An eLINK Interim Financial Report that summarizes expenditures of the first 50% must be signed by the Grantee and approved by BWSR. Selected grantees may be required at this point to submit documentation of the expenditures reported on the Interim Financial Report for verification. 3)The third payment of 10%will be distributed after the grant has been fully expended and reporting requirements are met. The final, 10%payment must be requested within 30 days of the expiration date of the Grant Agreement. An eLINK Final Financial Report that summarizes final expenditures for the grant must be signed by the grantee and approved by BWSR. 4.2. All costs must be incurred within the grant period. 4.3. All incurred costs must be paid before the amount of unspent grant funds is determined. Unspent grant funds must be returned within 30 days of the expiration date of the Grant Agreement. 4.4. The obligation of the State under this Grant Agreement will not exceed the amount stated above. 4.5. This grant includes an advance payment of 50 percent of the grant's total amount. Advance payments allow the grantee to have adequate operating capital for start-up costs,ensure their financial commitment to landowners and contractors, and to better schedule work into the future. 4.6. Contracting and Bidding Requirements per Minn.Stat. §471.345,Grantees that are municipalities as defined in Subd. 1 must do the following if contracting funds from this grant contract agreement for any supplies, materials,equipment or the rental thereof, or the construction,alteration, repair or maintenance of real or personal property. 4.6.1. If the amount of the contract is estimated to exceed$100,000,a formal notice and bidding process must be conducted in which sealed bids shall be solicited by public notice. Municipalities may, as a best value alternative, award a contract for construction, alteration, repair,or maintenance work to the vendor or contractor offering the best value under a request for proposals as described in Minn.Stat.§16C.28,Subd. 1, paragraph (a),clause(2). 4.6.2. If the amount of the contract is estimated to exceed$25,000 but not$100,000,the contract may be made either upon sealed bids or by direct negotiation, by obtaining two or more quotations for the purchase or sale when possible,and without advertising for bids or otherwise complying with the requirements of competitive bidding. All quotations obtained shall be kept on file for a period of at least one year after receipt thereof. Municipalities may, as a best value alternative, award a contract for construction,alteration, repair,or maintenance work to the vendor or contractor offering the best value under a request for proposals as described in Minn.Stat.§16C.28, Page 2 of 5 Subd. 1, paragraph (a),clause(2)and paragraph (c). 4.6.3. If the amount of the contract is estimated to be$25,000 or less,the contract may be made either upon quotation or in the open market, in the discretion of the governing body. If the contract is made upon quotation, it shall be based,so far as practicable,on at least two quotations which shall be kept on file for a period of at least one year after their receipt.Alternatively, municipalities may award a contract for construction,alteration, repair,or maintenance work to the vendor or contractor offering the best value under a request for proposals as described in Minn.Stat.§16C.28,Subd. 1, paragraph (a),clause(2). 4.6.4. Support documentation of the bidding process utilized to contract services must be included in the Grantee's financial records, including support documentation justifying a single/sole source bid, if applicable. 4.6.5. For projects that include construction work of$25,000 or more, prevailing wage rules apply per Minn.Stat. §§177.41 through 177.44. Consequently,the bid request must state the project is subject to prevailing wage. These rules require that the wages of laborers and workers should be comparable to wages paid for similar work in the community as a whole.A prevailing wage form should accompany these bid submittals. S. Conditions of Payment All services provided by the Grantee under this Grant Agreement must be performed to the State's satisfaction,as set forth in this Agreement and in the BWSR approved work plan for this program. Compliance will be determined at the sole discretion of the State's Authorized Representative and in accordance with all applicable federal,State,and local laws, policies, ordinances, rules, FY 2017 Clean Water Fund Competitive Grants Policy,and regulations. All Grantees must follow the Grants Administration manual policy. Minnesota Statutes§103C.401(2014)establishes BWSR's obligation to assure program compliance. If the noncompliance is severe, or if work under the grant agreement is found by BWSR to be unsatisfactory or performed in violation of federal, state,or local law, BWSR has the authority to require the repayment of grant funds, or an additional penalty. Penalties can be assessed at a rate up to 150%of the grant agreement. The Minnesota Department of Administration's Office of Grants Management Policy on Grant Closeout Evaluation (Policy 08 —13) requires the Board to consider a grant applicant's past performance before awarding subsequent grants to them.The Board must consider a grant applicant's performance on prior grants before making a new grant award of over$5,000. The Board may withhold payment on this and grants from other programs if the Grantee is not in compliance with all Board reporting requirements. 6. Assignment,Amendments,and Waiver 6.1.Assignment.The Grantee may neither assign nor transfer any rights or obligations under this Grant Agreement without the prior consent of the State and a fully executed Assignment Agreement, executed and approved by the same parties who executed and approved this Grant Agreement,or their successors in office. 6.2. Amendments.Any amendment to this Grant Agreement must be in writing and will not be effective until it has been executed and approved by the same parties who executed and approved the original Grant Agreement,or their successors in office.Amendments must be executed prior to the expiration of the original agreement or any amendments thereto. 6.3. Waiver. If the State fails to enforce any provision of this Grant Agreement,that failure does not waive the provision or its right to enforce it. 7. Liability The Grantee must indemnify,save,and hold the State, its agents, and employees harmless from any claims or causes of action, including attorney's fees incurred by the State, arising from the performance of this Grant Agreement by the Grantee or the Grantee's agents or employees.This clause will not be construed to bar any legal remedies the Grantee may have for the State's failure to fulfill its obligations under this Grant Agreement. 8. State Audits Under Minn.Stat. § 16B.98,subd. 8,the Grantee's books, records,documents, and accounting procedures and practices of the Grantee or other party relevant to this Grant Agreement or transaction are subject to examination by the Board and/or the State Auditor or Legislative Auditor, as appropriate,for a minimum of six years from the end of this Grant Agreement, receipt and approval of all final reports,or the required period of time to satisfy all State and program retention requirements,whichever is later. 8.1. The books, records,documents,accounting procedures and practices of the Grantee and its designated local units of government and contractors relevant to this grant, may be examined at any time by the Board or Board's designee and are subject to verification.The Grantee or delegated local unit of government will maintain records relating to the Page 3 of 5 receipt and expenditure of grant funds. 8.2. The Grantee or designated local unit of government implementing this Agreement will provide for an audit that meets the standards of the Office of State Auditor.The audit must cover the duration of the Agreement Period and be performed within one year after the end of the Agreement Period or when routinely audited,whichever occurs first. Copies of the audit report must be provided to the Board if requested. 9. Government Data Practices The Grantee and State must comply with the Minnesota Government Data Practices Act, Minn.Stat. Ch. 13, as it applies to all data provided by the State under this Agreement, and as it applies to all data created, collected, received, stored, used, maintained, or disseminated by the Grantee under this Grant Agreement. The civil remedies of Minn. Stat. § 13.08 apply to the release of the data referred to in this clause by either the Grantee or the State. 10. Workers'Compensation The Grantee certifies that it is in compliance with Minn.Stat. § 176.181,subd. 2, pertaining to workers'compensation insurance coverage.The Grantee's employees and agents will not be considered State employees.Any claims that may arise under the Minnesota Workers'Compensation Act on behalf of these employees and any claims made by any third party as a consequence of any act or omission on the part of these employees are in no way the State's obligation or responsibility. 11. Publicity and Endorsement 11.1.Publicity.Any publicity regarding the subject matter of this Grant Agreement must identify the Board as the sponsoring agency. For purposes of this provision, publicity includes notices, informational pamphlets, press releases, research, reports,signs,and similar public notices prepared by or for the Grantee individually or jointly with others, or any subcontractors,with respect to the program, publications,or services provided resulting from this Grant Agreement. 11.2.Endorsement.The Grantee must not claim that the State endorses its products or services. 12. Governing Law,Jurisdiction,and Venue Minnesota law, without regard to its choice-of-law provisions, governs this Grant Agreement.Venue for all legal proceedings out of this Agreement, or its breach, must be in the appropriate State or federal court with competent jurisdiction in Ramsey County, Minnesota. 13. Termination 13.1.The State may cancel this Grant Agreement at anytime,with or without cause, upon 30 days'written notice to the Grantee. Upon termination,the Grantee will be entitled to payment,determined on a pro rata basis,for services satisfactorily performed. 13.2.In the event of a lawsuit, an appropriation from a Clean Water Fund is canceled to the extent that a court determines that the appropriation unconstitutionally substitutes for a traditional source of funding. 14. Data Disclosure Under Minn.Stat. §270C.65,Subd. 3, and other applicable law,the Grantee consents to disclosure of its social security number,federal employer tax identification number,and/or Minnesota tax identification number,already provided to the State,to federal and State tax agencies and State personnel involved in the payment of State obligations.These identification numbers may be used in the enforcement of federal and State tax laws which could result in action requiring the Grantee to file State tax returns and pay delinquent State tax liabilities, if any. 15. Prevailing Wage It is the responsibility of the Grantee or contractor to pay prevailing wages on construction projects to which State prevailing wage laws apply(Minn.Stat. 177.42—177.44).All laborers and mechanics employed by grant recipients and subcontractors funded in whole or in part with these State funds shall be paid wages at rates not less than those prevailing on projects of a character similar in the locality. 16. Constitutional Compliance It is the responsibility of the Grantee to comply with requirements of the Minnesota Constitution regarding use of Clean Water Funds to supplement traditional sources of funding. 17. Signage It is the responsibility of the Grantee to comply with requirements for project signage as provided in Minnesota Laws 2010, Page 4 of 5 Chapter 361,article 3,section 5(b)for Clean Water Fund projects. 18. Intellectual Property Rights The State owns all rights,title,and interest in all of the intellectual property rights, including copyrights, patents,trade secrets,trademarks,and service marks in the Works and Documents created and paid for under this grant. Works means all inventions, improvements, discoveries(whether or not patentable), databases,computer programs, reports, notes,studies, photographs, negatives,designs, drawings,specifications, materials,tapes, and disks conceived, reduced to practice, created or originated by the Grantee, its employees, agents, and subcontractors,either individually orjointly with others in the performance of this grant.Works includes"Documents." Documents are the originals of any databases,computer programs, reports, notes,studies, photographs, negatives, designs, drawings,specifications, materials,tapes, disks,or other materials, whether in tangible or electronic forms, prepared by the Grantee, its employees, agents, or subcontractors, in the performance of this grant.The Documents will be the exclusive property of the State and all such Documents must be immediately returned to the State by the Grantee upon completion or cancellation of this grant at the State's request.To the extent possible,those Works eligible for copyright protection under the United States Copyright Act will be deemed to be "works made for hire."The Grantee assigns all right,title,and interest it may have in the Works and the Documents to the State.The Grantee must,at the request of the State,execute all papers and perform all other acts necessary to transfer or record the State's ownership interest in the Works and Documents. IN WITNESS WHEREOF, the parties have caused this Grant Agreement to be duly executed intending to be bound thereby. Approved: Apple Valley,City of Board of Water and Soil Resources By: By: (print) (signature) Title: Title: Date: Date: Page 5 of 5 Accelerated Implementation Grant Application Grant Name - Keller Lake Subwatershed Assessment Grant ID - C17-7645 Organization -Apple Valley, City of Accelerated Implementation Grant 2017 Jane Byron $30,000.00 Dakota $7,500 070200121109 25% Apple Valley, City of 25% • s�e., $0 The City proposes to conduct a subwatershed assessment on the sections of Apple Valley draining to Keller Lake to target potential projects to meet the City's WLA using P8 models. The goal is to identify potential cost effective retrofit projects and operations improvements capable of fulfilling needed phosphorus reductions ahead of a number of planned infrastructure projects tentatively scheduled for 2018-2022 (subwatershed assessments will not be limited to planned infrastructure improvement areas). The information gathered will be used to explore which efforts are worth pursuing further and will provide some cost efficiencies by having potential projects identified ahead of infrastructure improvement project feasibility studies, design and installation. Narrative What organization will serve as the Fiscal Agent for this grant? The City of Apple Valley Did your organization receive CWF grant dollars in FY 2014, FY 2015 and/or FY 2016? If less than 50%of the total grant amount awarded from FY 2014, FY 2015 and FY 2016 grants have been spent, please explain your organization's capacity(including available FTEs or contracted resources)to effectively implement additional Clean Water Fund grant dollars. No; however, the City of Apple Valley did receive a grant in 2013 where the installation deadline was extended to end of the year 2016. The project is nearing completion. Greater than 50% of grant funds have been spent; however, the City has not yet requested reimbursement and not all information has been updated in e-link yet. The City is anticipating closing the grant out in Fall of 2016. By delaying project installation by 1 year,the City is managing to save approximately$100,000. Clarity of Program Goals and Projected Impact: 1. (10 points) Explain the project,the changes that will result from the successful completion of your project,and the rationale for the need. How will the proposed project go above and beyond existing controls or operations? The project is a subwatershed assessment. The assessment will produce a list of potential projects and operational improvements with estimated costs and phosphorus reductions. By having an assessment or analysis of what the best projects may be, the City will be able to achieve accelerated TMDL implementation and cost efficiencies. Information within the subwatershed assessment will be used in development of the City's CIP. Were the City to limit itself to studying improvements as only related to individual infrastructure projects and not the subwatershed as a whole (the normal operating procedure), we may miss opportunities outside of upcoming projects, the ability to budget accordingly,the ability to prep accordingly, and staging and treatment train efficiencies. Clarity of Program Goals and Projected Impact: 2. (15 points) Describe the process,technology,or tools your project would use to accelerate on-the ground projects and practices. The City will contract out with an engineering consultant to develop the subwatershed assessment. P8 models will be used to determine likely phosphorus removal of potential projects. A list of potential projects with locations, projected phosphorus removal, and expected installation costs will be generated, which will then be used in developing the City CIP and infrastructure improvement planning. The City has currently realized about 37%of the watershed phosphorus reductions it needs to meet its WLA and has captured the phosphorus that is easiest to get at (lowest hanging fruit). Now that space and resources are at a premium,the subwatershed assessment will help guide the City on the next phase of its implementation. This project is a midway step between the generalization of the TMDL Implementation Plan and the detail of a feasibility study. Clarity of Program Goals and Projected Impact: 3. (15 points) How will this project benefit the general public? Describe the benefits from a local, regional and state perspective. At the local level, time and cost savings will be achieved. The list generated by the study will lead to cost effective use of tax payer dollars by providing an idea of which projects provide better opportunities for achieving the City's WLA. Inclusion of the assessment findings in capital improvement planning will reduce the likelihood that quality opportunities for cost efficiencies are missed when planning other infrastructure improvement projects. Delays in project installation will be less likely to occur with greater lead time to study feasibility and allow for Report created on: 6/21/2016 Page 2 of 8 i appropriate budgeting. Water quality in Keller Lake will improve more quickly and efficiently. At the regional and state levels, Keller Lake feeds into other waters impaired for nutrients (phosphorus): Crystal Lake in Burnsville, the Minnesota River(2016 draft impaired waters list), Mississippi River Pool 2 (2016 draft impaired waters list), and Lake Pepin. Reductions in loading to Keller Lake will benefit downstream waterbodies as well. Relationship to Plan: 4a. (25 points) Identify the specific water management plan reference by plan organization, plan title,section and page number. If applicable, also identify specific supporting plans such as a TMDL Implementation Plan, a WRAPS document, or Clean Water Partnership Diagnostic Study. In addition to the plan language, provide a brief description regarding how the activities in this application relate to the plan reference(s). Crystal, Keller, and Lee Lakes Nutrient Impairment Total Maximum Daily Load Report and Earley Lake Water Quality Assessment The TMDL lists Apple Valley's WLA, includes maps of untreated areas, and discusses the need to study large scale infiltration carefully to prevent impacts on lake levels. Specific references are as follows: p. vi-x,TMDL Summary Table p. 13, Section 2.2 p. 78,Table 5-6 p. 80, Figure 5-4 p. 96, Section 7.1.2 p. 98-100,Table 7.1 Crystal, Keller, and Lee Lakes Nutrient Impairment Total Maximum Daily Load Implementation Plan and Earley Lake Protection Plan The Implementation Plan reviews the TMDL, discusses treatment options, and includes maps that show the drainage area from Apple Valley proposed to be studied in the grant. Specific references are as follows: p. 14,Table 2.2 p. 15, Figure 2.2 p. 20, Section 3.2, ¶ 1 p. 22-23, Section 3.2.2.1, ¶ 1-4 p. 41-46, Section 3.4.1 p. 49, table 3-3 Black Dog Watershed Management Organization 2012-2022 Watershed Management Plan Report created on: 6/21/2016 Page 3 of 8 The plan states member communities will be responsible for implementing BMPs to clean up impaired waters, encourages looking at redevelopment as an opportunity for water quality improvement, states the intension of cooperating with communities on TMDL compliance, and lists potential BMP retrofit options to meet WLAs. Specific references are as follows: p. 3-10, Section 3.1.3.2 p. 4-1, Section 4.1.1 p. 4-4 to 4-5, Section 4.1.2,#s 10, 11, & 19 p. 4-6, Section 4.2.2, #3 p. 4-20, Section 4.9.1,#19 Section 5 Tables,Table 5-3, items 9-12 City of Apple Valley 2007 Surface Water Management Plan The SWMP states the intensions of the City to perform project identifying studies to improve water quality in impaired lakes, to comply with/participate in TMDLs, and to exceed the requirements of the Clean Water Act. Specific references are as follows: p. ix, Summary, System Improvement Program, Water Quality Section p. 18, Policy 2.1 p. 112, Section 8, ¶ 1 p. 118-119, Section 8.4 Relationship to Plan: 4b. Provide web links to all plans referenced. Crystal, Keller, and Lee Lakes Nutrient Impairment Total Maximum Daily Load Report and Earley Lake Water Quality Assessment https://www.pca.state.mn.us/sites/default/files/wq-iw11-10e.pdf Crystal, Keller, and Lee Lakes Nutrient Impairment Total Maximum Daily Load Implementation Plan and Earley Lake Protection Plan https://www.pca.state.mn.us/sites/default/files/wq-iw11-10c.pdf Black Dog Watershed Management Organization 2012-2022 Watershed Management Plan http://www.blackdogwmo.org/pdfs/2012_Watershed_Mgmt_Plan.pdf City of Apple Valley 2007 Surface Water Management Plan http://www.ci.apple-valley.mn.us/index.aspx?nid=371 Means and Measures: S. (10 points) Describe how the outcomes of your project would be integrated into day-to-day operations and become the new normal standard of operation or procedure. What are the anticipated results? The watershed assessment will be used to help develop the City's Capital Improvement Program (CIP). Not only will it speed up installation of Report created on: 6/21/2016 Page 4 of 8 I stand alone projects by giving us a starting point for lists of projects that warrant further investigation and lead time for adequate budgeting, but it will also ensure that opportunities are not missed when other infrastructure improvements are planned (road reconstruction, watermain replacement, trail improvements, etc.). A good chunk of the watershed is scheduled for road reconstruction during the next 5 years, a large portion of which currently drains to Keller Lake untreated. By knowing ahead of time which opportunities are best worth pursuing further, we ensure we don't miss the window to save money by only opening a road up once for stormwater infrastructure redirection or underground BMP installation. Means and Measures: 6. (5 points) How will the outputs of this project lead to more effective or efficient implementation of on-the-ground water quality projects and practices? The subwatershed assessment will act as a first level screening for potential projects within the drainage area. It will provide the basis for further investigations into the feasibility of projects. This in turn will allow for better coordination with other infrastructure projects and appropriate lead time for planning and budgeting. By completing the assessment, we will not miss out on opportunities that present themselves when road reconstruction and other projects occur; an economy of scale can be achieved. Means and Measures: 7. (5 points)What evaluation procedures will you use to assess the results of your project? The product the City will be developing is a subwatershed assessment for the areas within Apple Valley that contribute stormwater to Keller Lake. The assessment will provide the City with a starting point from which to further evaluate and budget for future projects. Ultimately over time, the goal is to be able to meet the City's WLA with savings in budget and time. The City anticipates that this study will allow achievement of our goal about 10 years faster than otherwise. As far as getting the quality assessment that the City wants, we will be pulling staff with experience in engineering and water resources for consultant oversight. Consultants in our consultant engineering pool have already been screened for qualifications and experience in performing these sorts of analysis. Timeline for Implementation: 8. (15 points) Provide an anticipated timeline for completion of application activities, including important milestones for your project. The City is looking to complete an aggressive turn around on this project. Some road reconstruction projects within the watershed are scheduled to begin as early as the summer of 2018 (although that is subject to change and we are willing to delay start if assessment completion is delayed). In order to not miss our window for subsequent feasibility studies and project design, we're hoping to have the project completed by late fall of 2017. This will require the City to select a contractor ASAP after the grant work plan would be approved. The City has a consultant pool that was recently updated to allow for a quick turn around time of this aspect. Most of the data necessary to do the analysis already exists, so we think that the aggressive timeline is feasible. The Constitutional Amendment requires that Amendment funding must not substitute traditional state funding. Briefly describe how this project will provide water quality benefits to the State of Minnesota without substituting existing funding. Funding for the project match will come out of the City's stormwater utility fee paid by residents and commercial entities in the City of Apple Report created on: 6/21/2016 Page 5 of 8 Valley. Should the City not receive a grant,the total project cost would come out of the stormwater utility fee. This is a one time project. Failure to receive a grant would not stop the project; however, it could delay the project until enough funds have been accumulated from the fee to pay for the study. The City will not be decreasing or increasing its stormwater utility fee in response to whether or not the grant is received. Application Budget Project Coordination Staff time allocated to grant administration and reporting ADMINISTRATION $1,000.00 /COORDINATION Staff Oversight of Bid, RFP, and contract preparation; oversight and coordination ADMINISTRATION $3,000.00 Project with consultants/contractors; general staff activities to ensure /COORDINATION the assessment meets needs. Subwatershed Costs associated with developing the subwatershed assessment. TECHNICAL/ENGI $26,000.00 Assessment The City intends to contract with an engineering consultant to NEERING Development complete the assessment. I ASSISTANCE Report created on: 6/21/2016 Page 6 of 8 • 1 1 1 � �� a.t e ��3..� � 4 .t fit.. ri. �` `�� ! ��` • s , ............ ml too - i _ 2 .................. z. +, '. Keller L a k c .QX$ , CrystalLake SL _ Lac Lavon _ rtrMll .. _ , r a 4 � r - , h, br ,�e "w, s, k i ,e, •Ie.,r. t� , a , t s a' lid �1-I i y _ J 1 .i -' -r -YYJ.� .. �JJ Jj 1{'r.,]^l r�s_J'J'?15.Y -.-: 3 r _ 0000: ITEM: 4.H. :0:: Apple COUNCIL MEETING DATE: March 9, 2017 Valley SECTION: Consent Agenda Description: Approve Change Order No. 2 on Agreement with Structural Glass Products, Inc., forApple Valley City Hall - 2015 Exterior Repairs Part 1 Project, and Approve Acceptance and Final Payment Staff Contact: Department/ Division: Charles Grawe,Assistant City Administrator Administration/ Information Technologies ACTION REQUESTED: Approve Change Order No. 2 to the agreement with Structural Glass Products, Inc., for Apple Valley City Hall - 2015 Exterior Repairs Part 1 Project, in the additional amount of $5,630.39, and approve acceptance and final payment in the amount of$13,902.49. SUMMARY: In 2015, the City worked with a forensic engineering firm to identify the source of water infiltration around several windows. This project corrected those problems and prevents future infiltration. The total cost of the project was $69,120.00. There were two change orders for an addition of$5,630.39. The final cost of the project is $74,750.39. BACKGROUND: The City anticipated this expense and identified funds in the Municipal Building Fund to use for this project. At the time the contract was approved, the engineer estimated an additional $12,000.00 in various smaller related contracts, including roofing, permits, drywall repair, inspections, and testing could be necessary. Change Order Item 2: Some of the repairs required alterations to the roofing system. This change reflects the costs to have a roofing subcontractor make the necessary roofing changes and repairs. Staff recommends the City Council approve Change Order No. 2 and acceptance and final payment on agreement with Structural Glass Products, Inc., for Apple Valley City Hall - 2015 Exterior Repairs Part 1 Project in the amount of$13,902.49. BUDGET IMPACT: Item 1: Addition $5,630.39 ATTACHMENTS: Final Pay Documents Change Order Document(s) CITY OF APPLE VALLEY, MINNESOTA APPLICATION FOR PAYMENT DATE: �- 2Z - (zO t1 FOR PERIOD: PROJECT: ACQ\e. Uq\1Eti t\� C A From I To kSV C 20 7x13 IR14 vkoz':r CONTRACTOR: S�m\ �'1uss�tr s REQUEST FOR PAYMENT NO. ADDRESS: Sol Secoca �o �w Ss 3t3 SUMMARY: 1. Original Contract Amount $ 4A, no, 2. Change Order- ADDITION $ 3. Change Order- DEDUCTION $ 4. Revised Contract Amount $ 5. Total Completed and Stored to Date $ ') 750, 35 6. Less Retainage % $ 7. Total Earned Less Retainage 8. Less Amount Paid Previously $ Le))C64-7, `'10 9. AMOUNT DUE THIS CURRENT REQUEST $ 3� a `-I a The undersigned Contractor certifies that to the best of his knowledge, information and belief, the work covered by this application for payment has been completed in accordance with the contract documents, that all amounts have been paid by him for work for which previous payments were received from the City and that current payment shown herein is now due. Contractor: < �x�urA Gloss ce�ckk�s 17 By: �T v an�� Recommended for Payment By: ATTACH ITEMIZED INVOICE Title: Date: Invoice Structural Glass Products Inc. 507 Second.A,e. \.I. Buffalo,MN 55313Dat" Ine"ae; i_ I 136-625 - I Phone: 763-69?-5430 tlanieesgp-usa.com Fax e 763-654-7951 Bin To City of Apple VAlley i 7100 West 147th Street Apple Valley,MN 55124 i I j i i Y.O.No. j Terms Project I I I Quantity Description Rate i Amount ~Final Billing Per Contract 6,379.39 6,379.39 f � 11 i I i I � I t i i I � i it i f I I Total $6,379.39 Structural Glass Products Inc. Invoice 307 Second Ave.N,F. Buffale,MN 55313 Date Invoice: _ 8/11/2016 2236-503 phone= 463-682-5930 tlmziea sgp-usa.<nm - '-' Fax= 763-664-1451 Bill To Citr of Apple VAllev 7100 Vilest 147th SI ret _Apple Vallev,ATN 55124 i I P.O.No. i Terms Project 1 Quanhh :� Descriphon Rate Amount ity Hall 5kylitc replacement Apple Valle}•Cin Hall 2,707.00 1,707.00 I � I i I. i i I Total 52✓07 Ori Structural Glass Products Inc. Invoice 507 Second Ave.N.E. Buffalo,PON 55313 IDate —___-�.--- ,[nvoice? 6/22/2016 2236478 Phone: 763-682-5430 tlaniee s'SP-usamm Fax r 763-684-1931 Bill To j City of Apple VAliey 7100 Fest 147th Street Apple Valley,N1N 55124 I P.O.No. Terms i Pm]ect Quanh6 llescnhon P - Rate Amount —I 20155kylile repairs partial billingper Contract 42,83260 42,8160 i 1 P C) 5 i Total Change Order No. 2R Date of Issuance: Revised 2/16/2017 Effective Date: Revised 2/16/2017 Project:Apple Valley City Hall-2015 Exterior Repair Owner.City of Apple Valley,MN,a Minnesota municipal corporation Owners Contract No.: Project,Part 1 Contract: Date of Contract: Contractor:Structural Glass Products,Inc. Engineer's Project No.: 15-5768-003 The Contract Documents are modified as follows upon execution of this Change Order: Description: Additional cost for roofing work by Central Roofing.Structural Glass hired Central roofing to perform work necessary to execute work.The roofing work performed by Central was not included in original Structural Glass Bid. Adjustment of final Miscellaneous Labor quantity of hours. A total of 38 miscellaneous labor hours were used and approved by Encompass. CHANGE IN CONTRACT PRICE: CHANGE IN CONTRACT TIMES: Original Contract Price: Original Contract Times: ❑ Working days ❑ Calendar days Substantial completion(days or date): $69,120 Ready for final payment(days or date): [Increase][Decrease]from previously approved Change [Increase][Decrease] from previously approved Change Orders Orders No.—1—to No. No. to No. Substantial completion(days): $0.00 Ready for final payment(days): Contract Price prior to this Change Order: Contract Times prior to this Change Order: Substantial completion(days or date): $69,120 Ready for final payment(days or date): Increase of this Change Order: [Increase][Decrease]of this Change Order: Substantial completion(days or date): $5,630.39 Ready for final payment(days or date): Contract Price incorporating this Change Order: Contract Times with all approved Change Orders: Substantial completion(days or date): $74,750.39 Ready for final payment(days or date): RECOMM� ED: ACCEPTED: By F/ By By-. ngineer(Aut zed Signature) Owner(Authorized Signature) CnontZQ "ractor(Authorized Signature) L Date: � �{lr r--� Date: Date: - 2-(:) / Approved by Funding Agency(if applicable): Date: EJCDC No.C-941(2002 Edition) Page 1 of 1 Prepared by the Engineers'Joint Contract Documents Committee and endorsed by the Associated General Contractors of America and the Construction Specifications Institute. 0000: ITEM: 4.1. :0:: Apple COUNCIL MEETING DATE: March 9, 2017 Valley SECTION: Consent Agenda Description: Set Special Informal City Council Meeting on April 27, 2017, at 6:00 p.m. at Cortland Development Park Staff Contact: Department/ Division: Pamela J. Gackstetter, City Clerk City Clerk's Office ACTION REQUESTED: Set a Special Informal City Council Meeting on April 27, 2017, at 6:00 p.m. at Cortland Development Park, for the Arbor Day tree planting ceremony. SUMMARY: The City Council is being asked to set a special informal meeting at 6:00 p.m. on Thursday, April 27, 2017, for the ceremonial tree planting at Cortland Development Park in observance of Arbor Day. The Cortland Development Park is located on the east side of Embry Path and north of 155th Street (North of the Cobblestone Lake Target Store). BACKGROUND: N/A BUDGET IMPACT: N/A 0000: ITEM: 4.J. :0:: Apple COUNCIL MEETING DATE: March 9, 2017 Valley SECTION: Consent Agenda Description: Approve Personnel Report Staff Contact: Department/ Division: Melissa Haas, Human Resources Manager Human Resources Division ACTION REQUESTED: Approve the personnel report. SUMMARY: The employment actions attached to this memo are recommended for City Council approval. BACKGROUND: The City Council's approval of the Personnel Report includes the ratification of the City Administrator's actions in carrying out the terms and conditions of the employment of the City personnel. BUDGET IMPACT: Budgeted positions. ATTACHMENTS: Personnel Report PERSONNEL REPORT City of Apple Valley March 9,2017 Human Resources EMPLOYMENT ACTIONS The following employment actions are recommended for City Council approval: First Last Base Pay Pay Pay Date Name Name Action Position Status Dept. Rate Type Scale (on or about) James DeWall Rehire Maintenance I Seasonal 5105 $ 12.54 Hourly SM1 4/15/2017 Part-Time, Francine Doran-Wrycza Hire Clerical Assistant Variable 5105 $ 14.05 Hourly C-10 3/1/2017 Food&Beverage Part-Time, Trevin Fitzgerald Hire Support Variable 5105 $ 9.75 Hourly C-01 4/15/2017 Austin Getting Rehire Maintenance I Seasonal 1710 $ 12.15 Hourly SM1 5/15/2017 John Hart Rehire Maintenance I Seasonal 5105 $ 12.89 Hourly SM1 4/15/2017 Rachel Hoffman Rehire Maintenance I Seasonal 1710 $ 12.15 Hourly SM1 5/15/2017 Food&Beverage Part-Time, Ryan Huling Hire Support Variable 5105 $ 9.75 Hourly C-01 4/15/2017 Golf Outside Service Mark Jendro Hire Attendant Seasonal 5105 $ 9.75 Hourly C-01 4/15/2017 Edward Kunkel Rehire Maintenance I Seasonal 5105 $ 12.89 Hourly SM1 4/15/2017 Andrew Larson Rehire Maintenance I Seasonal 1710 $ 12.54 Hourly SM1 5/15/2017 Sam Liggett' Rehire Maintenance I Seasonal 1710 $ 12.89 Hourly SM1 5/15/2017 Justin Louis Rehire Maintenance II Seasonal 1710 $ 14.28 Hourly SM2 5/15/2017 Robert MacDonald Rehire Maintenance I Seasonal 5105 $ 12.54 Hourly SM1 4/15/2017 Recreation Facility Mike Nelson Rehire Assistant Seasonal 5105 $ 12.20 Hourly C-03 4/15/2017 Robert Nelson Rehire Maintenance I Seasonal 5105 $ 12.89 Hourly SM1 4/15/2017 Blake Opseth Rehire Maintenance I Seasonal 1710 $ 12.15 Hourly SM1 5/15/2017 Golf Outside Service Blair Pointras Rehire Attendant Seasonal 5105 $ 10.00 Hourly C-01 4/15/2017 Golf Outside Service Jack Ritacco Hire Attendant Seasonal 5105 $ 9.75 Hourly C-01 4/15/2017 Kelly Smith Hire Food&Beverage Server Seasonal 5105 $ 9.75 Hourly C-01 4/15/2017 Golf Outside Service Terrence Storey Hire Attendant Seasonal 5105 $ 9.75 Hourly C-01 4/15/2017 Part-Time, Celeste Van Klein Hire Food&Beverage Cook Variable 5105 $ 11.30 Hourly C-04 4/15/2017 The Council's approval of the Personnel Report includes the ratification of the City Administrator's actions in carrying out the terms and conditions of the employment of the City personnel. Page 1 of 1 0000: ITEM: 4.K. :0:: Apple COUNCIL MEETING DATE: March 9, 2017 Valley SECTION: Consent Agenda Description: Approve Claims and Bills Staff Contact: Department/ Division: Ron Hedberg, Finance Director Finance Department ACTION REQUESTED: Approve claims and bills. SUMMARY: Attached for City Council review and approval are check registers for recent claims and bills. BACKGROUND: N/A BUDGET IMPACT: Check registers dated February 16, 2017, and February 22, 2017 in the amounts of 775,473.74,and $718,654.44, respectively. ATTACHMENTS: Claims and Bills Claims and Bills R55CKR2 L_ S101 CITY OF API. ,ALLEY 2/16,. _/ 83839 Council Check Register by GL Page- 1 Cotmcil Check Register by Invoice&Summary 1/19/2017 -- 2/172017 Check# Dale Amount Supplier/Explanation PO# Doc No Inv No Account No Subledger Account Description Business Unit 11951 2/17/2017 100101 ACE HARDWARE .80- DISCOUNT 304229 101310728921 1330.6333 GENERAL-CASH DISCOUNTS FIRE OPERATIONS 17.98 CONTRACTOR BAGS FOR TRUCKS 304229 101310728921 1330.6229 GENERAL SUPPLIES FIRE OPERATIONS 1 ON DISCOUNT 304232 101310729061 1340.6333 GENERAL-CASH DISCOUNTS FIRE BLDG&GROUNDS MNTC 14.98 STATION SUPPLIES 304232 101310729061 1340.6229 GENERAL SUPPLIES FIRE BLDG&GROUNDS MNTC .26- DISCOUNT .304225 101360728661 19206333 GENERAL-CASH DISCOUNTS SENIOR CENTER 2.58 FIX PIPE©S CENTER 304225 101360728661 1920.6229 GENERAL SUPPLIES SENIOR CENTER 100- DISCOUNT 304227 101400727811 5345.6333 GENERAL-CASH DISCOUNTS WATER EQUIPNEHICLE/MISC.MNTC 9.99 MISC SUPPLIES 304227 101400727811 5345.6229 GENERAL SUPPLIES WATER EQUIPNEHICLE/MISC MNTC 5.77- DISCOUNT 304235 729321 1900.6333 GENERAL-CASH DISCOUNTS AV COMMUNITY CENTER 57.68 PAINTING SUPPLIES 304235 729321 1900.6229 GENERAL SUPPLIES AV COMMUNITY CENTER 94.38 11952 2/17/2017 100058 BELLBOY CORPORATION 12933 WINE#1 00004928 304656 57433700 5015.6520 WINE LIQUOR 01 STOCK PURCHASES 85.40 LIQ41 00004928 304657 57433700 5015.6510 LIQUOR LIQUOR#1 STOCK PURCHASES 2.92 FREIGHT41 00004928 304658 57433700 50156550 FREIGHT ON RESALE MDSE LIQUOR#1 STOCK PURCHASES 2,414.20 LIQ#I 00004928 304659 57525500 5015.6510 LIQUOR LIQUOR#1 STOCK PURCHASES 33.75 FREIGHT#I 00004928 304660 57525500 5015.6550 FREIGHT ON RESALE MDSE LIQUOR#1 STOCK PURCHASES 1,017.95 LIQ92 00004928 304661 57525600 5055.6510 LIQUOR LIQUOR 92 STOCK PURCHASES 8.10 FREIGHT#2 00004928 304662 57525600 5055.6550 FREIGHT ON RESALE MDSE LIQUOR 92 STOCK PURCHASES 2,867.80 LIQ#3 00004928 304663 57525700 5085.6510 LIQUOR LIQUOR#3 STOCK PURCHASES 176.00 WINE93 00004928 304664 57525700 5085.6520 WINE LIQUOR#3 STOCK PURCHASES 32.40 FREIGHT#3 00004928 304665 57525700 5085.6550 FREIGHT ON RESALE MDSE LIQUOR 93 STOCK PURCHASES 4165 NOTAX#1 00004928 304654 95342500 5055.6545 NON-TAXABLE MISC FOR RESALE LIQUOR 92 STOCK PURCHASES 6200 NOTAX#3 00004928 304655 95342600 50856545 NON-TAXABLE MISC FOR RESALE LIQUOR A3 STOCK PURCHASES 6,871.50 11953 2/172017 100071 BOYERTRUCKS 1,109.64 4381 FAN CLUTCH 304153 1119147X1 1630.6215 EQUIPMENT-PARTS STREET EQUIPMENT MAINTENANCE 34.34 344 TAIL LT ASSY 304185 1121200 1630.6215 EQUIPMENT-PARTS STREET EQUIPMENT MAINTENANCE 500.00- 9381 CLUTCH CORE(CREDIT) 304039 CM1119147XI 1630.6215 EQUIPMENT-PARTS STREET EQUIPMENT MAINTENANCE 643.98 11954 2/172017 143314 CLEAR RIVER BEVERAGE CO 192.00 BEER#1 00051160 304631 671393 50156530 BEER LIQUOR 91 STOCK PURCHASES 192.00 11955 2/17/2017 141474 COLE PAPERS INC. 8.29 PAPER PRODUCTS 304700 9286719 1940.6229 GENERAL SUPPLIES AQUATIC SWIM CENTER 24.88 PAPER PRODUCTS 304700 9286719 1540.6229 GENERAL SUPPLIES CMF BUILDINGS&GROUNDS MNTC R55CKR2 LOGIS101 CITY OF APPLE VALLEY 2/16/2017 8:3839 Council Check Register by GL Page- 2 Council Check Regicler by Invoice&Summary 1/19/2017 - 2/172017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No Account No Subledger Account Description Business Unit 11955 2/17/2017 141474 COLE PAPERS INC. Continued... 24.88 PAPER PRODUCTS 304700 9286719 17306229 GENERAL SUPPLIES PARK BUILDING MAINTENANCE 33.18 PAPER PRODUCTS 304700 9286719 13406229 GENERAL SUPPLIES FIRE BLDG&GROUNDS MNTC 66.35 PAPERPRODUCTS 304700 9286719 1060.6229 GENERAL SUPPLIES MUNICIPAL BLDG&GROUNDS MNTC .57- GOLF USE TAX 304700 9286719 5100 2330 DUE TO OTHER GOVERNMENT GOLF FUND BALANCE SHEET .57 GOLF USE TAX 304700 9286719 51456229 GENERAL SUPPLIES GOLF SHOP BUILDING MAINTENANCE 829 PAPER PRODUCTS 304700 9286719 51456229 GENERAL SUPPLIES GOLF SHOP BUILDING MAINTENANCE 165.87 11956 2/17/2017 100102 COLLEGE CITY BEVERAGE 6.15- CMBEER#3 00000114 304318 2536 50856530 BEER LIQUOR 43 STOCK PURCHASES 3000- CMBEER#1 00000114 304291 2558 5015.6530 BEER LIQUOR 41 STOCK PURCHASES 189.00 BEER#2 entered in 2016 00000114 304262 265355 5055.6530 BEER LIQUOR#2 STOCK PURCHASES 3,185.70 BEER#1 00000114 304274 269833 5015.6530 BEER LIQUOR#1 STOCK PURCHASES 2045 TAX#1 00000114 304275 269833 5015.6540 TAXABLE MISC FOR RESALE LIQUOR#I STOCK PURCHASES 27010 BEER#2 00000114 304297 269834 5055.6530 BEER LIQUOR#2 STOCK PURCHASES 1,755.90 BEER#3 00000114 304321 269835 5085.6530 BEER LIQUOR#3 STOCK PURCHASES 5&00 TAX#3 00000114 304322 269835 5085 6540 TAXABLE MISC FOR RESALE LIQUOR#3 STOCK PURCHASES 7,466.90 BEER#1 00000114 304278 272779 50156530 BEER LIQUOR#I STOCK PURCHASES 18.85 TAX#1 00000114 304279 272779 5015.6540 TAXABLE MISC FOR RESALE LIQUOR#I STOCK PURCHASES 5,902.90 BEER#1 00000114 304285 275434 5015.6530 BEER LIQUOR#1 STOCK PURCHASES 37.70 TAX#1 00000114 304286 275434 5015.6540 TAXABLE MISC FOR RESALE LIQUOR#1 STOCK PURCHASES 2,132.90 BEER#2 00000114 304299 275435 50556530 BEER LIQUOR 42 STOCK PURCHASES 36.70 TAX#2 00000114 304300 275435 5055.6540 TAXABLE MISC FOR RESALE LIQUOR 92 STOCK PURCHASES 7,933.95 BEER43 00000114 304326 275436 50856530 BEER LIQUOR 93 STOCK PURCHASES 5,430.35 BEER91 00000114 304289 278277 5015.6530 BEER LIQUOR 41 STOCK PURCHASES 36.00 TAXM 00000114 304290 278277 5015.6540 TAXABLE MISC FOR RESALE LIQUOR 41 STOCK PURCHASES 3,249.25 BEER92 00000114 304305 278278 5055.6530 BEER LIQUOR#2 STOCK PURCHASES 20.45 BEER92 00000114 304306 278278 5055 6530 BEER LIQUOR#2 STOCK PURCHASES 2,773.29 BEER#3 00000114 304327 278279 5085 6530 BEER LIQUOR#3 STOCK PURCHASES 2045 TAX#3 00000114 304328 278279 5085 6540 TAXABLE MISC FOR RESALE LIQUOR#3 STOCK PURCHASES 36405 BEER92 00000114 304301 278568 5055.6530 BEER LIQUOR#2 STOCK PURCHASES 425.35- CMBEER#2 00000114 304302 278568 5055.6530 BEER LIQUOR#2 STOCK PURCHASES 6,268.85 BEER#2 00000114 304307 280912 5055.6530 BEER LIQUOR#2 STOCK PURCHASES 39.30 TAX#2 00000114 304308 280912 5055 6540 TAXABLE MISC FOR RESALE LIQUOR#2 STOCK PURCHASES 89.70- CMBEER#2 00000114 304309 280912 50556530 BEER LIQUOR#2 STOCK PURCHASES 4,36405 BEER93 00000114 304331 280913 5085.6530 BEER LIQUOR#3 STOCK PURCHASES 48.75 TAX93 00000114 304332 280913 5085.6540 TAXABLE MISC FOR RESALE LIQUOR 03 STOCK PURCHASES 22160 BEER#1 00000114 304280 284426 5015.6530 BEER LIQUOR#1 STOCK PURCHASES 225.20- CMBEER#I 00000114 304281 284426 5015.6530 BEER LIQUOR#1 STM"PURCHASES 2,097.75 BEER#2 00000114 304312 284441 50556530 BEER LIQUOR*2 S9 'URCHASES R55CKR2 L, ,,5101 CITY OF APF- ALLEY 2/16, 83839 Council Check Regisua by GL Page- 3 Cotmcil Check Register by Invoice&Summary 1/19/2017 -- 2/17/2017 Check# Date Amomrt Supplier/Explanation PO# Doc No Im No Acwunt No Subledger Account Description Business Unit 11956 2/172017 100102 COLLEGE CITY BEVERAGE Confirmed... 53.95 TAX92 00000114 304313 284441 50556540 TAXABLE MISC FOR RESALE LIQUOR 02 STOCK PURCHASES 368.70- CMBEER#2 00000114 304314 284441 5055.6530 BEER LIQUOR#2 STOCK PURCHASES 303.70 BEER02 00000114 304310 284444 50556530 BEER LIQUOR#2 STOCK PURCHASES 306.20- BEER#2 00000114 304311 284444 50556530 BEER LIQUOR#2 STOCK PURCHASES 245.60 BEER#1 00000114 304270 284464 5015.6530 BEER LIQUOR#1 STOCK PURCHASES 95.40- CMBEER#I 00000114 304271 284464 50156530 BEER LIQUOR#I STOCK PURCHASES 81.60 BEER#1 00000114 304272 284467 50156530 BEER LIQUOR#1 STOCK PURCHASES 246.60- CMBEER#1 00000114 304273 284467 5015.6530 BEER LIQUOR#1 STOCK PURCHASES 518.50 BEER#3 00000114 304333 285071 5085.6530 BEER LIQUOR#3 STOCK PURCHASES 20.45 TAX#3 00000114 304334 285071 5085 6540 TAXABLE MISC FOR RESALE LIQUOR#3 STOCK PURCHASES 142.25- CMBEER#3 00000114 304335 285071 5085.6530 BEER LIQUOR#3 STOCK PURCHASES 118.50- CMBEER#I paid too much 00000114 304261 32507 5015.6530 BEER LIQUOR 41 STOCK PURCHASES 185.50 BEER#3 00000114 304315 421 5085.6530 BEER LIQUOR 43 STOCK PURCHASES 325.90- CMBEER#3 00000114 304316 421 5085.6530 BEER LIQUOR#3 STOCK PURCHASES 375.60- CMBEER#I 00000114 304265 423 5015.6530 BEER LIQUOR#1 STOCK PURCHASES 21.60- CMBEER93 00000114 304323 6010 5085.6530 BEER LIQUOR#3 STOCK PURCHASES 82.76- CMBEER#1 00000114 304276 608 50156530 BEER LIQUOR#1 STOCK PURCHASES 58.11- CMBEER42 00000114 304298 609 50556530 BEER LIQUOR#2 STOCK PURCHASES 2,757.25 BEER92 entered m 2016 00000114 304263 63949 5055.6530 BEER LIQUOR#2 STOCK PURCHASES 16.25 TAX#2 entered in 2016 00000114 304264 63949 5055.6540 TAXABLE MISC FOR RESALE LIQUOR#2 STOCK PURCHASES 3,383.20 BEERO 00000114 304266 66745 50156530 BEER LIQUOR#1 STOCK PURCHASES 40.90 TAX#1 00000114 304267 66745 5015.6540 TAXABLE MISC FOR RESALE LIQUOR#I STOCK PURCHASES 1,485.00 BEER#2 00000114 304294 66746 5055.6530 BEER LIQUOR#2 STOCK PURCHASES 2,905.80 BEER#3 00000114 304317 66747 50856530 BEER LIQUOR#3 STOCK PURCHASES 95.40 BEER#1 00000114 304268 8427 5015.6530 BEER LIQUOR 41 STOCK PURCHASES 245.60- CMBEER#I 00000114 304269 8427 50156530 BEER LIQUOR#I STOCK PURCHASES 177.90 BEER#2 00000114 304295 8428 5055.6530 BEER LIQUOR 42 STOCK PURCHASES 269.62- CMBEER#2 00000114 304296 8428 50556530 BEER LIQUOR 92 STOCK PURCHASES 120.00 BEERM 00000114 304277 8430 50156530 BEER LIQUOR#1 STOCK PURCHASES 90.00 BEER#1 00000114 304282 8432 50156530 BEER LIQUOR 91 STOCK PURCHASES 156.30 BEER#1 00000114 304283 8433 5015.6530 BEER LIQUOR 91 STOCK PURCHASES 220.11- CMBEER#I 00000114 304284 8433 5015.6530 BEER LIQUOR 91 STOCK PURCHASES 59.30- CMBEER#3 00000114 304324 8435 5085,6530 BEER LIQUOR 93 STOCK PURCHASES 9.43- CMTAX#3 00000114 304325 8435 50856540 TAXABLE MISC FOR.RESALE LIQUOR 43 STOCK PURCHASES 122.80 BEER#I 00000114 304287 8436 5015.6530 BEER LIQUOR 91 STOCK PURCHASES 33836- CMBEER#1 00000114 304288 8436 5015.6530 BEER LIQUOR#I STOCK PURCHASES 338.40 BEER#2 00000114 304303 8437 5055.6530 BEER LIQUOR#2 STOCK PURCHASES 514.83- BEER#2 000001/4 304304 8437 5055.6530 BEER LIQUOR#2 STOCK PURCHASES 33150 BEER#I 00000114 304292 8438 50156530 BEER LIQUOR#1 STOCK PURCHASES R55CKR2. LOGISI01 CITY OF APPLE VALLEY 2/16/2017 8:3839 Council Check Register by GL Page- 4 Council Check Register by Invoice&Summary 1/19/2017 -- 2/17/2017 Check# Date Amount Supplier/Explanation POO Doc No Inv No Account No Subledger Account Description Business Unit 11956 2/17/2017 100102 COLLEGE CITY BEVERAGE Confinued... 30.00- CMBEER#I 00000114 304293 8438 50156530 BEER LIQUOR#1 STOCK PURCHASES 128.80 BEER#3 00000114 304329 8441 50856530 BEER LIQUOR#3 STOCK PURCHASES 164.64- CMBEER#3 00000114 304330 8441 50856530 BEER LIQUOR#3 STOCK PURCHASES 62,733.68 11957 2/17/2017 101365 ECM PUBLISHERS INC 602.14 2017 MWF SUN INSERT-PRINTCHARG 304161 453700 1845.6239 PRINTING REC SELF SUPPORT PROD GENERAL 401.42 MWF SUN INSERT-DELIVERY 304160 453701 18456239 PRINTING REC SELF SUPPORT PROG GENERAL 003.56 11958 2/1712017 100233 HOTSYMINNESOTA.COM 251.69 RPA WEST PRESS.WASHER 304701 54537 1540.6265 REPAIRS-EQUIPMENT CMF BUILDINGS&GROUNDS MNTC 251.69 11959 2/17/2017 136639 IMPACT PROVEN SOLUTIONS 39.70 NATURAL RES INSERT 304195 121331 15206238 POSTAGENPS/FEDEX NATURAL RESOURCES 39.70 UTIL METER CHO INSERT 304195 121331 53036238 POSTAGE/UPS/FEDEX UTILITY BILLING 584.84 UB PRINT/MAIL BILLS IAN 304195 121331 53036249 OTHER CONTRACTUAL SERVICES UTILITY BILLING 1,859.82 UB POSTAGE JAN 304195 121331 5303.6238 POSTAGE/UPS/FEDEX UTILITY BILLING 2,524,06 11960 2/17/2017 103314 INNOVATIVE OFFICE SOLUTIONS 10.82 OFFICE SUPPLIES AVSC 304171 IN1492569 1920.6210 OFFICE SUPPLIES SENIOR CENTER 1.05 BUSINESS CARD HOLDERS 304174 IN1496326 1920.6210 OFFICE SUPPLIES SENIOR CENTER 6.21 CDR DISCS-EXERCISE PROG 304174 IN1496326 1920.6229 GENERAL SUPPLIES SENIOR CENTER 13.24 CD SLEEVES AVSC 304175 IN1497728 1920.6229 GENERAL SUPPLIES SENIOR CENTER 8.19 LIQ I CLEANING SUPPLIES 304247 IN1500102 5025.6229 GENERAL SUPPLIES LIQUOR#1 OPERATIONS 17.19 LIQ I CLEANING SUPPLIES 304248 IN1500103 5025.6229 GENERAL SUPPLIES LIQUOR#1 OPERATIONS 4825 LIQ I PRICEMARKER 304249 IN1500104 5025.6229 GENERAL SUPPLIES LIQUOR#1 OPERATIONS 59.59 DIST WATER,TOILET CLRTAPE GUN 304499 IN1500105 5095.6229 GENERAL SUPPLIES LIQUOR#3 OPERATIONS 138.45 CALCULATOR,PENS,POST-ITS,ETC 304499 1N1500105 50956210 OFFICE SUPPLIES LIQUOR 43 OPERATIONS 37.70 FILE BOXES 304708 IN1505318 1900.6210 OFFICE SUPPLIES AV COMMUNITY CENTER 15.09 OFFICE SUPPLIES 304707 IN 1505319 1900.6210 OFFICE SUPPLIES AV COMMUNITY CENTER 71.10 OFFICE SUPPLIES 304706 IN1505320 1900.6210 OFFICE SUPPLIES AV COMMUNITY CENTER 426.88 11961 2/17/2017 100348 MTI DISTRIBUTING CO 23.04 MOWERPARTS 3046D2 110300500 5155.6215 EQUIPMENT-PARTS GOLF EQUIPMENT MAINTENANCE 85.88 MOWER PARTS 304603 110300501 51556215 EQUIPMENT-PARTS GOLF EQUIPMENT MAINTENANCE 108.92 R55CKR2 . ISI01 CITY OF AN .ALLEY 2/10. / 83839 Council Check Register by GL Page- 5 Council Check Register by Invoice&Summary 1/19/2017 — 2/17/2017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No Account No Subledger Account Description Business Unit 11961 2/172017 100348 MTI DISTRIBUTING CO CoaEaaed... 11962 2/17/2017 103014 PADGETT,MARCIE D 71.82 JAN.MILEAGE-PADGET 304222 20170203 1700.6277 MILEAGE/AUTO ALLOWANCE PARK&RECREATION MANAGEMENT 71.82 11%3 2/17/2017 100393 PUMPAND METER SERVICE INC 9,792.58 FUEL TANK MONITOR SYSTEM 304152 1150071/ 1530.6715 CAPITAL OUTLAY-BUILDINGS FLEET&BUILDINGS-CMF H 792.58 11964 2/17/2017 145515 SCHUFT,STEVE 11.23 JAN MILEAGE-SCHUFT 304162 20170127 5025.6277 MILEAGE/AUTO ALLOWANCE LIQUOR 41 OPERATIONS 11.23 11965 2/17/2017 100486 TWIN CITY GARAGE DOOR CO 399.00 REPLACE SPRINGS PD 304685 476635 1060.6266 REPAIRS-BUILDING MUNICIPAL BLDG&GROUNDS MNTC 399.00 11966 2/17/2017 100496 VANPAPERCO 47299 BAGS#I 00008795 304466 415345 50256229 GENERAL SUPPLIES LIQUOR#1 OPERATIONS 4.78- DISCT#I 00008795 304467 415345 50256333 GENERAL-CASH DISCOUNTS LIQUOR 91 OPERATIONS 473,21 11967 2/17/2017 100520 WINECOMPANY,THE 1,012.50 WINE#3 000/5926 304636 27002 5085.6520 WINE LIQUOR#3 STOCK PURCHASES 10.50 FREIGHT93 00015926 304637 27002 50856540 TAXABLE MISC FOR RESALE LIQUOR#3 STOCK PURCHASES 424.00 WINE#3 00015926 304638 28198 5085.6520 WINE LIQUOR 43 STOCK PURCHASES 10.50 FREIGHT#3 00015926 304639 28198 5085.6540 TAXABLE MISC FOR RESALE LIQUOR#3 STOCK PURCHASES 1,457.50 272815 2/152017 101588 IST LINE LEWEES VENTURES LLC 94.10 POPCORN FOR MWF 304211 124110 1845.6229 GENERAL SUPPLIES REC SELF SUPPORT FROG GENERAL 94.10 272816 2//52017 114540 ALEX AIR APPARATUS INC 147.50 AFS]SCBA COMPRESSOR TEST 304199 31748 1330.6265 REPAIRS-EQUIPMENT FIRE OPERATIONS 147.50 AFS2 SCBA COMPRESSOR TEST 304197 31749 1330.6265 REPAIRS-EQUIPMENT FIRE OPERATIONS 147.50 AFS3 SCBA COMPRESSOR TEST 304198 31750 1330.6265 REPAIRS-EQUIPMENT FIRE OPERATIONS 442.50 272817 2/152017 100018 AMERICAN PLANNING ASSN R55CKR2 LOGISI01 CITY OF APPLE VALLEY 2/16/2017 83839 Council Check Register by.GL Page- 6 Council Check Register by Invoice&Summary 1/19/2017 -- 2/17/2017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No Account No Subledger Account Description Business Unit 272817 2/152017 100018 AMERICAN PLANNING ASSN Continued... 260.00 APA SHARPE MEMBERSHIP 304176 300070/71/ 11006280 DUES&SUBSCRIPTIONS DEV MANAGEMENT 27200 APA NORDQUIST PAS 304177 6502016102 1100.6280 DUES&SUBSCRIPTIONS DEV MANAGEMENT 532 00 272818 2/15/2017 150585 ANDERSON,BENJAMIN 4142 UB REFUND 201 PALOMINO DR 304598 2DI70208D 5301.4997 WATER/SEWER ACCT REFUNDS WATER&SEWER FUND REVENUE 4L42 272819 2/152017 100039 APPLE VALLEV FORD 293.91 POL VEHICLE LEASE-FEB 304590 201702/0 12156310 RENTAL EXPENSE POLICE DETECTIVE UNIT 293.91 272820 2/152017 100041 APPLE VALLEY MEDICAL CLINIC LTD 89.00 R KRINGS DOT TESTING 304695 711673 5365.6235 CONSULTANT SERVICES SEWER MGMT/REPORTS/DATA ENTRY 89.00 272821 2/15/2017 127073 APPLE VALLEY SENIORS 390A0 DECEMBER 2016 CC REIMB. 304165 20173101 1001 4359 REC SENIOR REVENUE-REIMB GENERAL FUND REVENUE 390.00 272822 2/15/2017 100747 ARAMARK UNIFORM SERVICES INC 32.15 UNIFORM SERVICE 304693 1718637337 1710.6281 UNHORM/CLOTHING ALLOWANCE PARK MAINTENANCE MANAGEMENT 3266 UNIFORM SERVICE 304693 1718637337 1530.6281 UNIFORM/CLOTHING ALLOWANCE FLEET&BUILDINGS-CMF 54.39 UNIFORM SERVICE 304693 1718637337 16006281 UNIFORM/CLOTHING ALLOWANCE STREET MANAGEMENT 32.15 UNIFORM SERVICE 304702 1718641766 1710.6281 UNIFORM/CLOTHING ALLOWANCE PARK MAINTENANCE MANAGEMENT 3266 UNIFORM SERVICE 304702 171864/766 1530.6281 UNIFORM/CLOTHING ALLOWANCE FLEET&BUILDINGS-CMF 54.39 UNIFORM SERVICE 304702 1718641766 1600.6281 UNIFORM/CLOTHING ALLOWANCE STREET MANAGEMENT 238.40 272923 2/15/2017 100360 ARCTIC GLACIER INC 6.88 NO TAX#2 00002202 304351 1914701302 5055.6545 NON-TAXABLE MISC FOR RESALE LIQUOR#2 STOCK PURCHASES 25.76 NOTAX#I 00002202 304349 1921701804 50156545 NON-TAXABLE MISC FOR RESALE LIQUOR#1 STOCK PURCHASES 127.76 NOTAX93 CAME IN 2016 ENTERED 1 00002202 304355 1927636507 5085.6545 NON-TAXABLE MISC FOR RESALE LIQUOR#3 STOCK PURCHASES 90.40- CNINO TAX#2 00002202 304354 1929628101 DEC 5055.6545 NON-TAXABLE.MISC FOR RESALE LIQUOR#2 STOCK PURCHASES 56.34 NOTAX#3 00002202 304353 1929701004 5085.6545 NON-TAXABLE MISC FOR RESALE LIQUOR#3 STOCK PURCHASES 2264 NOTAX#1 00002202 304348 /929701007 5015.6545 NON-TAXABLE MISC FOR RESALE LIQUOR#1 STOCK PURCHASES 31.82 NOTAX#I 00002202 304350 1989702402 5015.6545 NON-TAXABLE MISC FOR RESALE LIQUOR#1 STOCK PURCHASES 89.76 NO TAX#2 00002202 304352 1989702409 5055.6545 NON-TAXABLE MISC FOR RESALE LIQUOR 42 STOCK PURCHASES 275.56 i R55CKR2 -.-.ISI01 CITY OF AP. !ALLEY 2/Ic. ./ 8:3839 Council Check Register by GL Page- 7 Council Check Register by Invoice.@ Snnmary 1/192017 -- 2/17/2017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No Account No Subledgcr Account Description Business Unit 272824 2/15/2017 125174 ARTISAN BEER COMPANY Continued... 509.00 BEER#2 00047806 304470 3153798 5055.6530 BEER LIQUOR#2 STOCK PURCHASES 47000 BEER#1 00047806 304468 3155216 5015.6530 BEER LIQUOR#1 STOCK PURCHASES 604.75 BEER#3 00047806 304476 3155217 50856530 BEER LIQUOR 43 STOCK PURCHASES 2,86920 BEER#1 00047806 304469 3156697 5015.6530 BEER LIQUOR 91 STOCK PURCHASES 526.00 BEER#2 00047806 304471 3156698 5055.6530 BEER LIQUOR#2 STOCK PURCHASES 563.50 CMBEER#2 00047806 304473 3156700 50556530 BEER LIQUOR#2 STOCK PURCHASES 848.90 BEER#3 00047806 304477 3156701 50856530 BEER LIQUOR 93 STOCK PURCHASES 37.18 BEER43 PAYBACK CREDIT 2016 00047806 304474 370381 5085 6530 BEER LIQUOR 93 STOCK PURCHASES 7.72 BEER#3 PAYBACK CREDIT 2016 00047806 304475 370382 50856530 BEER LIQUOR#3 STOCK PURCHASES 98.00- CMBEER#2 00047806 304472 374849 50556530 BEER LIQUOR#2 STOCK PURCHASES 6,338.25 272825 2/1520/7 100609 ASPEN EQUIPMENT CO 134.00 240 GLOW PLUG 304683 10173782 17656215 EQUIPMENT-PARTS PARK EQUIPMENT MAINTENANCE 134.00 272826 2/15/2017 145004 BARRIS,JODIE 7200 ZUMBA INSTRUCTOR PAYMENT 304168 20170203 19206249 OTHER CONTRACTUAL SERVICES SENIOR CENTER 72.00 272827 2//52017 100054 BAIIERBUILTINC 347.50 203 MT TIRES 304184 180203222 17656265 REPAIRS-EQUIPMENT PARK EQUIPMENT MAINTENANCE 347.50 272828 2/15/2017 100055 BECKERARENAPRODUCTS INC 136.71 HAYES SHARPENER SUPPLIES 304605 1005511 5260.6229 GENERAL SUPPLIES ARENA 2 MANAGEMENT--HAYES 136.71 AVSA SHARPENER SUPPLIES 304605 1005511 5205.6229 GENERALSUPPLIES ARENA IMANAGEMENT 237.16 AVSA SHARPENER SUPPLIES 304607 1006397 52056229 GENERAL SUPPLIES ARENA I MANAGEMENT 510.58 272829 2/15/2017 138336 BERNICK'S BEVERAGE 685 90 BEER#3 00050356 304346 340495 5085.6530 BEER LIQUOR#3 STOCK PURCHASES 20.00 TAX#2 00050356 304341 340514 5055.6540 TAXABLE MISC FOR RESALE LIQUOR#2 STOCK PURCHASES 57.00 BEER#2 00050356 304342 340515 5055.6530 BEER LIQUOR#2 STOCK PURCHASES 1.00- CMBEER#2 00050356 304343 340515 5055.6530 BEER LIQUOR#2 STOCK PURCHASES 6080 TAXI 00050356 304336 341717 5015.6540 TAXABLE MISC FOR RESALE LIQUOR#1 STOCK PURCHASES 40.00 NOTAX#I 00050356 304337 341717 5015.6545 NON-TAXABLE MISC FOR RESALE LIQUOR I STOCK PURCHASES 1.67- CMTAX41 00050356 304338 341717 5015.6540 TAXABLE MISC FOR RESALE LIQUOR#1 STOCKPURCHASES 402.55 BEER#I 00050356 304339 341718 5015.6530 BEER LIQUOR#I STOCK PURCHASES 305.44- CMBEER#I 00050356 304340 341718 5015.6530 BEER LIQUOR 91 STOCK PURCHASES R55CKR2 LOGISHU CITY OF APPLE VALLEY 2/16/2017 8:38:39 Council Check Register by GL Page- 8 Council Check Register by Invoice&Summary 1/19/2017 -- 2/172017 Check# Date Amount Supplier/Explanation PO# Doe No Inv No Account No Subledger Account Description Business Unit 272829 2/15/2017 138336 BERNICK'S BEVERAGE Confiuued... 20.00 TAX93 00050356 304344 342834 5085 6540 TAXABLE MISC FOR RESALE LIQUOR#3 STOCK PURCHASES 20.00 NOTAX#3 00050356 304345 342834 5085 6545 NON-TAXABLE MISC FOR RESALE LIQUOR#3 STOCK PURCHASES 649.10 BEER#3 00050356 304347 342835 5085.6530 BEER LIQUOR#3 STOCK PURCHASES 1,64724 - 272830 2/15/2017 147558 BOREALIS FERMENTERV 12000 BEER93 00081915 304630 97619 5085.6530 BEER LIQUOR$3 STOCK PURCHASES 120.00 272831 2/15/2017 100072 BRAUN INTERTEC CORPORATION 2,060.00 GEOTECHNICAL EXPLORATION 304148 B083954 2027.6235 20171025 CONSULTANT SERVICES ROADESCROW 2,060.00 272832 2/1.512017 100152 BREAKTHRII BEVERAGE MINNESOTA WINE&SPIR 1,008.25 WINE#2 00001930 304578 1080590239 5055.6520 WINE LIQUOR#2 STOCK PURCHASES 9.39 FREIGHT#2 00001930 304579 1080590239 5055.6550 FREIGHT ON RESALE MDSE LIQUOR#2 STOCK PURCHASES 28.59 TAX#I 00001930 304549 1080590242 5015.6540 TAXABLE MISC FOR RESALE LIQUOR#1 STOCK PURCHASES 246.75 LIQ#I 00001930 304550 1080590242 5015.6510 LIQUOR LIQUOR#1 STOCK PURCHASES 3.45 FREIGHT#1 00001930 304551 1080590242 50156550 FREIGHT ON RESALE MDSE LIQUOR#I STOCK PURCHASES 28.59- CMTAX41 00001930 304552 1080590242 50156540 TAXABLE MISC FOR RESALE LIQUOR#1 STOCK PURCHASES 1.15- CMFREIGHT#1 00001930 304553 1080590242 5015.6550 FREIGHT ON RESALE MDSE LIQUOR#1 STOCK PURCHASES 28.00- CMLIQ#1 00001930 304554 1080590242 5015.6510 LIQUOR LIQUOR#1 STOCK PURCHASES 4,145.65 LIQ#I 00001930 304555 /080590242 5015.6510 LIQUOR LIQUOR#1 STOCK PURCHASES Supplier 100219 BREAKTHRU BEVERAGE WINE 129.99 WINE#I 00001930 304576 1080590243 5015.6520 WINE LIQUOR 91 STOCK PURCHASES 3.45 FREIGHT#1 00001930 304577 1080590243 5015.6550 FREIGHT ON RESALE MDSE LIQUOR 91 STOCK PURCHASES 6,235.59 LIQ93 00001930 304569 1080593475 50856510 LIQUOR LIQUOR#3 STOCK PURCHASES 35.12 TAX#3 00001930 304570 1080593475 5085.6540 TAXABLE MISC FOR RESALE LIQUOR#3 STOCK PURCHASES 141,96 N0TAX#3 00001930 304571 1080593475 5085.6545 NON-TAXABLE MISC FOR RESALE LIQUOR 43 STOCK PURCHASES 33.35 FREIGHT93 00001930 304572 1080593475 5085.6550 FREIGHT ON RESALE MDSE LIQUOR 43 STOCK PURCHASES 330.50- CMLIQ#3 00001930 304573 1080593475 5085 6510 LIQUOR LIQUOR#3 STOCK PURCHASES 5.00- CMTAX#3 00001930 304574 1080593475 5085.6540 TAXABLE MISC FOR RESALE LIQUOR#3 STOCK PURCHASES 2500- CMNOTAX#3 00001930 304575 1080593475 5085.6545 NON-TAXABLE MISC FOR RESALE LIQUOR#3 STOCK PURCHASES - Supplier 100219 BREAKTHRUBEVERAGEWME 559.33 WINE#3 00001930 304580 1080593476 5085.6520 WINE LIQUOR#3 STOCK PURCHASES 460 FREIGHT03 00001930 304581 /080593476 5085.6550 FREIGHT ON RESALE MDSE LIQUOR#3 STOCK PURCHASES 166.00 TAX#2 00001930 304562 1080593548 5055 6540 TAXABLE MISC FOR RESALE LIQUOR 42 STOCK PURCHASES 150.37 NOTAX42 00001930 304563 1080593548 5055.6545 NON-TAXABLE MISC FOR RESALE LIQUOR#2 STOCK PURCHASES 2,402.27 LIQ#2 00001930 304564 1080593548 5055.6510 LIQUOR LIQUOR 42 STP PURCHASES 33.35 FREIGHT#2 00001930 304565 1080593548 50556550 FREIGHT ON RESALE MDSE LIQUOR#25i 'URCHASES R55CKR2 -,ISIOI CITY OF AR ✓ALLEY 2/Iv / 838:39 Conncil Check Register by GL Page- 9 Conncil Check Register by Invoice&Summary 1/19/2017 -- 2/172017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No Account No Subledger Account Description Business Unit 272832 2/152017 100152 BREAKTHRII BEVERAGE MINNESOTA WINE&SPIR Continued... 170.82- CMLIQ#2 00001930 304566 1080593548 50556510 LIQUOR LIQUOR 92 STOCK PURCHASES 25.00- CMTAX92 00001930 304567 1080593548 5055 6540 TAXABLE MISC FOR RESALE LIQUOR#2 STOCK PURCHASES 2500- CMNOTAX#2 00001930 304568 1080593548 5055.6545 NON-TAXABLE MISC FOR RESALE LIQUOR#2 STOCK PURCHASES 125.54 TAXA 00001930 304556 1080593549 5015.6540 TAXABLE MISC FOR RESALE LIQUOR 41 STOCK PURCHASES 132.07 NOTAX#I 00001930 304557 1080593549 5015.6545 NON-TAXABLE MISC FOR RESALE LIQUOR I STOCK PURCHASES 37,95 FREIGHT#1 00001930 304558 1080593549 5015.6550 FREIGHT ON RESALE MDSE LIQUOR I STOCK PURCHASES 210.82- CMLIQ#1 00001930 304559 1080593549 5015.6510 LIQUOR LIQUOR I STOCK PURCHASES 1500- CMTAX#I 00001930 304560 1080593549 5015.6540 TAXABLE MISC FOR RESALE LIQUOR#1 STOCK PURCHASES 20.00- CMNOTAX#I 00001930 304561 1080593549 5015.6545 NON-TAXABLE MISC FOR RESALE LIQUOR#1 STOCK PURCHASES Supplier 100219 BREAKTHRU BEVERAGE WINE 14,748.14 272833 2/15/2017 121014 BUCKEYE CLEANING CENTER 127.74 VACUUM BAG&FILTER AVSC 304169 117155 1920.6229 GENERALSUPPLIES SENIORCENTER 127,74 272834 2/152017 100634 C L BENSEN CO INC 246.72 FURNACE FILTERS AVSC 304170 91794 19206229 GENERAL SUPPLIES SENIORCENTER 246.72 272835 2/152017 122371 CANNON RIVER WINERY 132.00 WINE#1 00046665 304611 2750 50156520 WINE LIQUOR#1 STOCK PURCHASES 132.00 272836 2/1520/7 100089 CARQUEST 26.34 4990 STEERING STABILIZER 303991 1594284556 13506215 EQUIPMENT-PARTS FIRE VEHICLE MAINTENANCE 30.59 4990 STEERING STABLIZER 303992 1594284564 1350.6215 EQUIPMENT-PARTS FIRE VEHICLE MAINTENANCE 30.59- STEERING STABILIZER(CREDIT) 303993 1594284577 1350.6215 EQUIPMENT-PARTS FIRE VEHICLE MAINTENANCE 30,59- STEERING STABILIZER(CREDIT) 303994 1594284632 1350.6215 EQUIPMENT-PARTS FIRE VEHICLE MAINTENANCE 3.56 CLAMP FUEL LINE RETURN HOSE 303999 1594284885 5345.6215 EQUIPMENT-PARTS WATER EQUIPNEHICLEMIISC MNTC 34.12 4984 APPARATUS LAMPS 304203 1594284895 1350.6215 EQUIPMENT-PARTS FIRE VEHICLE MAINTENANCE 23.46 HEAD LT BULBS SQD CARS 304186 1594285003 1210.6215 EQUIPMENT-PARTS POLICE FIELD OPERATIONS/PATROL 8.99 TIRE GAUGE 304228 1594285009 1765.6211 SMALL TOOLS&EQUIPMENT PARK EQUIPMENT MAINTENANCE 11.02 272 AIR FILTER 304691 1594285489 1765.6215 EQUIPMENT-PARTS PARK EQUIPMENT MAINTENANCE 19.99 272 OIL 304691 1594285489 1765.6212 MOTOR FUELS/OILS PARK EQUIPMENT MAINTENANCE 14.71 DASH LT BULB-9340 304687 1594285507 16306215 EQUIPMENT-PARTS STREET EQUIPMENT MAINTENANCE 111.60 272837 2/15/2017 148786 CHANKASKACREEK 16800 WINE#1 00052008 304610 210671 5015.6520 WINE LIQUOR#1 STOCK PURCHASES R55CKR2 LOOISUH CITY OF APPLE VALLEY 2/16/2017 838:39 Council Check Register by GL Page- 10 Council Check Register by Invoice&Summary 1/19/2017 -- 2/17/2017 Check 9 Data Amount Supplier/Explanation PO H Doc No Inv No Account No Subledger Account Description Business Unit 272837 2//52017 148786 CHANKASKA CREEK Continued... 168.00 272838 2//52017 100878 CHARTER COMMUNICATIONS 80.00 TC WIFI-FEB 304164 835230604053166 1840.6237 TELEPHONEIPAGERS REC TEEN PROGRAMS 5FEB17 80.00 272839 2//52017 102381 CLAUSEN,RICHARD S 17500 REFUND FOR CANCELLED CONCERT 304167 20173101 1001.5116 RENTS-HAYES SENIOR CENTER GENERAL FUND REVENUE 175.00 272840 2/15/2017 122019 CROWN RENTAL-BURNSVILLE 17.79 WEED WHIP PLUGS JC-EAST 304246 2386375 1765.6215 EQUIPMENT-PARTS PARK EQUIPMENT MAINTENANCE 17.79 272841 2/15/2017 100114 CUB FOODS 240- FIRE USE TAX 304201 201701261621 1000.2330 DUE TO OTHER GOVERNMENT GENERAL FUND BALANCE SHEET 240 FIRE USE TAX 304201 201701261621 1330 6229 GENERAL SUPPLIES FIRE OPERATIONS 50.91 FIREFIGHTER REHAB SUPPLIES 304201 201701261621 1330.6229 GENERAL SUPPLIES FIRE OPERATIONS .68- POL USE TAX 304204 201701301124 1000.2330 DUE TO OTHER GOVERNMENT GENERAL FUND BALANCE SHEET .68 POL USE TAX 304204 201701301124 /2756229 GENERAL SUPPLIES POL COMMON OUTREACH/CRIME PREV 34.73 SNACKS FOR TEEN ACADEMY 304204 201701301124 1275.6229 GENERAL SUPPLIES POL COMMON OUTREACH/CRIME PREV 85 64 272842 2/152017 143882 CULLIGAN 105.35 HAYES WATER SOFTENER SALT 304606 157985475324JAN 5260.6229 GENERALSUPPLIES ARENA 2 MANAGEMENT-HAYES 17 105.35 HAYES WATER SOFTENER SALT 304681 157985539939JAN 5260.6229 GENERAL SUPPLIES ARENA 2 MANAGEMENT-HAYES 17 210,70 272843 2//52017 100129 DAKOTAAWARDS&ENGRAVING 97590 MWF-300 HOCKEY JAMBOREE AWARDS 304677 16548 1845.6229 GENERAL SUPPLIES REC SELF SUPPORT FROG GENERAL 975.00 272844 2/152017 100123 DAKOTA COUNTY FINANCIAL SERVICES 8,948.36 3RD QTR SIGNAL MTNC PYMT 304151 23108A 1680.6249 OTHER CONTRACTUAL SERVICES TRAFFIC SIGNS/SIGNALS/MARKERS 15,302 51 2017 DCDPC DUES 304675 23660 1290.6249 OTHER CONTRACTUAL SERVICES CIVIL DEFENSE MANAGEMENT 59,474.36 PROGRESS PAYMENT FOR 42 TRAIL 304147 23714 4932.6735 2015113G CAPITAL OUTLAY-OTHER IMPROVEME FUTURE CAPITAL PROJECTS 83,725.23 R55CKR2 L_,ISIOI CITY OF AN (ALLEY 2/Ic. .7 83839 Council Check Register by GL Page- II Council Check Register by Invoice&Summary 1/19/2017 -- 2/17/2017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No Account No Subledger Account Description Business Unit 272844 2/152017 100123 DAKOTA COUNTY FINANCIAL SERVICES Continued... 272845 2/152017 100139 DAKOTA COUNTY LICENSE CENTER 41.75 STR LIC/REG'17 KENWORTH4381 304194 20170208 16306215 EQUIPMENT-PARTS STREET EQUIPMENT MAINTENANCE 4,780.10 STR TAX'17 KENWORTH-#381 304194 20170208 2007.6730 CAPITAL OUTLAY-TRANSPORTATION LGA/EQUIP CERTIFICATES 4,821.85 272846 2/152017 100128 DAKOTA ELECTRIC ASSOCIATION 18.35 COBBLESTONE N 2ND ADDITION 304465 5663463JAN17 45026255 UTILITIES-ELECTRIC IMPROVEMENTS-ASSESSED 18.99 COBBLESTONE N 2ND ADDITION 304464 5663471JAN17 4502.6255 UTILITIES-ELECTRIC IMPROVEMENTS-ASSESSED 498.82 R.R.LIGHT HIT ON 147 BY PAIDEI 304150 71860670 7205.6399 OTHER CHARGES INSURANCE CLAIMS 3,848.74 R.R.LIGHT HIT GAL/N 147 W SIDE 304150 71860670 72056399 OTHER CHARGES INSURANCE CLAIMS 4,384.90 272847 2/1520/7 100777 DEX MEDIA EAST LLC 24.50 WEST METRO AD-FEB 304682 110115110FES17 5105.6239 PRINTING GOLF MANAGEMENT 24.50 272848 2/152017 100976 DICK'S LAKEVILLE SANITATION INC 82.36 LIQ I TRASH FEB 304457 DT0001683297 50256240 CLEANING SERVICE/GARBAGE REMOV LIQUOR#1 OPERATIONS 59.25 LIQ 2 TRASH FEB 304456 DT0001683298 5065.6240 CLEANING SERVICE/GARBAGE REMOV LIQUOR#2 OPERATIONS 90.58 FIRE STA 1 TRASH FEB 304455 DT0001683299 1340 6240 CLEANING SERVICE/GARBAGE REMOV FIRE BLDG&GROUNDS MNTC 38.95 FIRE STA 2 TRASH FEB 304451 DT0001683300 1340.6240 CLEANING SERVICE/GARBAGE REMOV FIRE BLDG&GROUNDS MNTC 39.95 FIRE STA3 TRASH FEB 304450 DT0001683301 1340.6240 CLEANING SERVICE/GARBAGE REMOV FIRE BLDG&GROUNDS MNTC 105.46 HCSC TRASH FEB 304449 D170001683302 1920.6240 CLEANING SERVICE/GARBAGE REMOV SENIOR CENTER 32L65 AVCC TRASH FEB 304449 DT0001683302 19006240 CLEANING SERVICE/GARBAGE REMOV AV COMMUNITY CENTER 163.22 IA2 TRASH FEB 304449 DT0001683302 5265.6240 CLEANING SERVICE/GARBAGE REMOV ARENA 2 BLDG MAINTENANCE-HAYES 555.66 CMF TRASH FEB 304454 DT0001683303 1540.6240 CLEANING SERVICE/GARBAGE REMOV CMF BUILDINGS&GROUNDS MNTC 233.84 CH TRASH FEB 304448 DT0001683304 1060.6240 CLEANING SERVICE/GARBAGE REMOV MUNICIPAL BLDG&GROUNDS MNTC 162.87 JCR PK TRASH FEB 304447 DT0001683305 1730.6240 CLEANING SERVICF/GARBAGE REMOV PARK BUILDING MAINTENANCE 252.04 GOLFTRASHFEB 304463 DT0001683306 5145.6240 CLEANING SERVICFIGARBAGE REMOV GOLF SHOP BUILDING MAINTENANCE 263.50 TEEN CTR TRASH FEB 304462 DT0001684751 1730.6240 CLEANING SERVICE/GARBAGE REMOV PARK BUILDING MAINTENANCE 58.02 VM PK TRASH FEB 304461 DT0001686165 1730.6240 CLEANING SERVICE/GARBAGE REMOV PARK BUILDING MAINTENANCE 58.88 LIQ 3 TRASH FEB 304460 DT0001687315 5095.6240 CLEANING SERVICE/GARBAGE REMOV LIQUOR#3 OPERATIONS 58.03 QPTRASHFEB 304459 DT0001687451 1945.6240 CLEANING SERVICE/GARBAGEREMOV QUARRY POINTE 87.15 OLD CH TRASH FEB 304458 DT0001693363 20926240 CLEANING SERVICE/GARBAGE 14200 CEDAR AVE-OLD CITY HALL 75.00 PK CLIPPING DISPOSAL FEB 304453 DT0001696687 1720.6240 CLEANING SERVICE/GARBAGE REMOV PARK GROUNDS MAINTENANCE 72.81 REDWOOD TRASH FEB 304452 DT0001696953 1730.6240 CLEANING SERVICE/GARBAGE REMOV PARK BUILDING MAINTENANCE 2,779.22 272349 2/15/2017 100434 DOUGHERTY MOLENDA SOLFEST HILLS&BAUER R55CKR2 LOGISHU CITY OF APPLE VALLEY 2/16/2017 8:38:39 Council Check Register by GL Page- 12 Council Check Register by Invoice&Sunnnary 1/19/2017 -- 2/172017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No Account No Subledger Account Description Business Unit 272849 2/152017 100434 DOUGHERTY MOLENDA SOLFEST HILLS&BAUER Continued... 403.25 157TH ST ACQUIS AT QUARRY POND 304424 160501 4502.6231 2013149G LEGAL SERVICES IMPROVEMENTS-ASSESSED 1,217.39 AV VILLA 2ND ADDN-DELEGARD 304425 160502 4502.6231 2016157G LEGAL SERVICES IMPROVEMENTS-ASSESSED 32156 AT&T REVIEW OF ASSIGN-CMF-CROW 304426 160503 1050.6231 2005 LEGAL SERVICES LEGAL GENERAL SERVICES 149.36 LAWSUITA.B. 304427 160504 1050.6231 LEGAL SERVICES LEGAL GENERAL SERVICES 1,607.84 BIGGS GABELLA TRANSFER 304428 160505 4502.6231 2016194G LEGAL SERVICES IMPROVEMENTS-ASSESSED 91.88 COBBLESTONE LK 7TH ADDN 304429 160506 4502.6231 2015138G LEGAL SERVICES IMPROVEMENTS-ASSESSED 150.38 CODE VIOLATIONS-MISC 304430 160507 1050.6231 LEGAL SERVICES LEGAL GENERAL SERVICES 687.03 COMMUNITY CARES UTIL INSTALL 304431 160508 1050.6231 LEGAL SERVICES LEGAL GENERAL SERVICES 964.70 EMBRY PLACE 2NDADDN 304432 160509 4502.6231 2015143G LEGAL SERVICES IMPROVEMENTS-ASSESSED 8962 FARQUAR LAKE/LONG LAKE EASEMEN 304433 160510 5505.6231 2009116D LEGALSERVICES STORM DRAIN MNTC/RPR/SUMPS 149.35 FOUNDERS CIRCLE/PARKING LOT 304434 160511 21026231 2016154G LEGAL SERVICES FOUNDERS CIRLCE PARKING LOT 206.73 GISELLES CORNER(7525 CEDAR) 304435 160512 45026231 201612OG LEGAL SERVICES IMPROVEMENTS-ASSESSED 675.06 HUDSON DIVISION/AV LEASED HOUS 304436 160513 4502.6231 2016136G LEGAL SERVICES IMPROVEMENTS-ASSESSED 968.38 MENARDS-HANSON CONCRETE REDEVE 304437 160514 4502.6231 2016139G LEGAL SERVICES IMPROVEMENTS-ASSESSED 477.93 MET COUNCIL EASEMENTS-PARK PRO 304438 160515 55056231 20141295 LEGAL SERVICES STORM DRAIN MNTC/RPR/SUMPS 82.50 PARKSIDE VILLAGE(IMH)GALANTE 304439 160516 45026231 2015167G LEGAL SERVICES IMPROVEMENTS-ASSESSED 815.43 QUARRY PONDS 4TH ADDN/PALM REA 304440 160517 49026231 20151750 LEGAL SERVICES PHYSICAL IMPROVEMENTS ESCROW 209.10 MOTOR VEHICLE ACCIDENT-S.E. 304441 160518 10556231 LEGAL SERVICES LEGAL PROSECUTING ATTORNEY 253.90 UPONOR ANEX ADDITION 304442 160519 4502.6231 2016173G LEGAL SERVICES IMPROVEMENTS-ASSESSED 584.00 VALLEY OAKS ESTATES 304443 160520 15106231 2016183G LEGAL SERVICES PW ENGINEERING&TECHNICAL 10,105.39 272850 2/15/2017 117768 DRAIN PRO PLUMBING 3,560.00 REPLACE MC HOT WATER HEATER 304146 47582 1060.6266 REPAIRS-BUILDING MUNICIPAL BLDG&GROUNDS MNTC 3,560.00 172851 2/152017 150,584 ELWOOD,NANCY 7879 UB REFUND 14476 GANNON WAY 304597 20170208C 53014997 WATER/SEWER ACCT REFUNDS WATER&SEWER FUND REVENUE 78.79 272952 2/15/2017 145163 EMERGENCY RESPONSE SOLUTIONS 8,419.00 GEAR RACKS AFSI 304674 8038 1330.6211 SMALL TOOLS&EQUIPMENT FIRE OPERATIONS 8,419 00 272853 2/15/2017 144557 EXECUTIVE OUTDOOR SERVICES LLC 2,355.00 JAN SNOWPLOW&SALT ST MARYS 304192 248 2092.6249 OTHER CONTRACTUAL SERVICES 14200 CEDAR AVE-OLD CITY HALL 2,305.00 JAN SNOW PLOW&SALT CITY LOT 304192 248 2097.6249 OTHER CONTRACTUAL SERVICES CENTRAL VILLAGE PARKING LOT 4,660.00 272854 2/H 100157 FACTORY MOTOR PARTS CO R55CKR2 .._,ISIOI CITY OF AP. VALLEY 2/Ic .7 838:39 Council Check Register by GL - Page- 13 Council Check Register by Invoice&Summary 1/19/2017 - 2/17/2017 Check Data Amount Supplier/Explanation PO Doc No Inv No Account No Subledger Account Description Business Unit 272854 2/15/2017 100157 FACTORY MOTOR PARTS CO Continued... 142.26 HYD.FITTINGS 304155 15169886 1765.6215 EQUIPMENT-PARTS PARK EQUIPMENT MAINTENANCE 14227 HYD.FITTINGS 304155 15169886 1630.6215 EQUIPMENT-PARTS STREET EQUIPMENT MAINTENANCE 142.26 HYD.FITTINGS 304155 15169886 5390.6215 EQUIPMENT-PARTS SWR EQUIPNEHICLE MISC MNTC/RP 20.27 CONN FOR CHEV 304690 15177612 16306215 EQUIPMENT-PARTS STREET EQUIPMENT MAINTENANCE 1806 TRUCK 415 PART 304699 75249796 5390.6215 EQUIPMENT-PARTS SWR EQUIP/VEHICLE MISC MNTC/RP 2027 PLUG CONNECTOR HEAD LT 415 304689 75249844 5345.6215 EQUIPMENT-PARTS WATER EQUIPNEHICLF/MISC MNTC 485,39 272855 2/15/2017 120313 FASTENALCOMPANY 99.59 SIDEWALK GRINDER 304686 MNLAK139728 1630.6211 SMALL TOOLS&EQUIPMENT STREET EQUIPMENT MAINTENANCE 6.03 FASTENERS 304601 MNLAK139895 1720.6229 GENERAL SUPPLIES PARK GROUNDS MAINTENANCE 105.62 272856 2/15/2017 109951 FIRST STATE TIRE RECYCLING 114.15 SCRAP TIRE RECYCLING 304694 103576 15306240 CLEANING SERVICFJGAR13AGE REMOV FLEET&BUILDINGS-CMF 114.15 272857 2/15/2017 100177 FLUEGEL ELEVATOR INC 81.00 STRAW FOR MIDWINTER FEST 304244 2726700 19006229 GENERAL SUPPLIES AV COMMUNITY CENTER 81.00 272858 2/15/2017 150560 FRV DAVID 500.00 304582 20170127 12256275 SCHOOLS/CONFERENCES/EXP LOCAL POLICE TRAINING 500.00 272859 2/15/2017 100282 G&K SERVICES 34.56 CHEF SHIRTS 304182 1013327714 5120624U CLEANING SERVICE/GARBAGE REMOV GOLF KITCHEN 3.84 ENTRY RUG SERVICE AVSC 304172 1182322351 19206240 CLEANING SERVICE/GARBAGEREMOV SENIOR CENTER .46- IA2 SALES TAX ADJUST 304498 1182333610 52656240 CLEANING SERVICE/GARBAGE REMOV ARENA 2 BLDG MAINTENANCE-HAYES .46 IA2 SALES TAX ADJUST 304498 1182333610 52002330 DUE TO OTHER GOVERNMENT ARENA FUND BALANCE SHEET 6.86 RUGS FOR ENTRY 304498 1182333610 5265 6240 CLEANING SERVICE/GARBAGE REMOV ARENA 2 BLDG MAINTENANCE-HAYES 86- IAI SALES TAX ADJUST 304497 1182333611 5210.6240 CLEANING SERVICE/GARBAGE REMOV ARENA I BUILDING MAINTENANCE 86 IAI SALES TAX ADJUST 304497 1182333611 5200.2330 DUE TO OTHER GOVERNMENT ARENA FUND BALANCE SHEET 12.86 RUGS FOR ENTRY 304497 1182333611 5210.6240 CLEANING SERVICE/GARBAGE REMOV ARENA 1 BUILDING MAINTENANCE 19.84 RUG SERVICE 304666 1182333613 19006240 CLEANING SERVICE/GARBAGE REMOV AV COMMUNITY CENTER 77.96 272860 2/15/2017 129789 GENERAL SECURITY SERVICES CORP 176.00 REPAIR TO ALARM PANEL 304196 356015 1340.6266 REPAIRS-BUILDING FIRE BLDG&GROUNDS MNTC 12.96 REDWOOD ALARM(-FEB 304212 356319 1930.6237 TELEPHONE/PAGERS REDWOOD POOL R55CKR2 LOGISI01 CITY OF APPLE VALLEY 2/16/2017 83839 Council Check Register by GL Page- 14 Council Check Register by Invoice&Summary 1/19/2017 -- 2/17/2017 Check# Date Amomt Supplier/Enplanatlon PO# Doc No Inv No Account No Subledeer Account Description Business Unit 272860 2/152017 129789 GENERAL SECURITY SERVICES CORP Continued... 188.96 272861 2/15/2017 150583 GEORGE,JASON 15.93 UB REFUND 8390134TH ST CT W 304596 201702088 53014997 WATER/SEWER ACCT REFUNDS WATER&SEWER FUND REVENUE 15.93 272862 2/152017 148989 GERVING,.IOSHIIA 372.87 MNJOA-DULUTH-GERVING 304589 20170213 1225.6276 SCHOOLS/CONFERENCES/EXP OTHER POLICE TRAINING 372.87 272863 2/152017 100198 GETTING,.IONA 42.97 BOOTS-1 GETTING 304236 20170130 16006281 UNIFORM/CLOTHING ALLOWANCE STREET MANAGEMENT 42.97 272864 2252017 100314 GREAT LAKES COCA-COLA DISTRIBUTION 544.76 TAX#1 00000122 304254 3595202609 50156540 TAXABLE MISC FOR RESALE LIQUOR 91 STOCK PURCHASES. 28.56 NOTAX#I 00000122 .304255 3595202609 5015.6545 NON-TAXABLE MISC FOR RESALE LIQUOR#1 STOCK PURCHASES 9.36- CMTAX41 00000122 304256 3595202609 50156540 TAXABLE MISC FOR RESALE LIQUOR 1H STOCK PURCHASES 24.00- CMTAX#I 00000122 304257 3595202610 50156540 TAXABLE MISC FOR RESALE LIQUOR 91 STOCK PURCHASES 244,24 TAX93 00000122 304258 3616201818 5085.6540 TAXABLE MISC FOR RESALE LIQUOR#3 STOCK PURCHASES 19.20 NOTAX#3 00000122 304259 3616201818 5085.6545 NON-TAXABLE MISC FOR RESALE LIQUOR 93 STOCK PURCHASES 19.05- CMTAX#3 00000122 304260 3616201819 50856540 TAXABLE MISC FOR RESALE LIQUOR 43 STOCK PURCHASES 784.35 272865 2/15/2017 101169 HAWKINS INC 2,28420 CHEMICALS 304159 4DI9929RI 5325.6214 CHEMICALS WATER TREATMENT FCLTY MNTC/RPR 2,284.20 272866 2/15/2017 140680 HONSA LIGHTING SALES&SERVICE .60- FIRE SALES TAX ADJUST 304200 77874 13506215 EQUIPMENT-PARTS FIRE VEHICLE MAINTENANCE 60 FIRE SALES TAX ADJUST 304200 77874 1000.2330 DUE TO OTHER GOVERNMENT GENERAL FUND BALANCE SHEET 9.37 APPARATUS LIGHT BULBS 304200 77874 1350.6215 EQUIPMENT-PARTS FIRE VEHICLE MAINTENANCE 9.37 272867 2/15/2017 144088 INDEED BREWING CO 452.70 BEER#1 00051420 304632 47735 5015.6530 BEER LIQUOR#1 STOCK PURCHASES 161.50 BEER#2 00051420 304633 47809 5055.6530 BEER LIQUOR 92 STOCK PURCHASES 614.20 272868 2/1! 100013 J J TAYLOR DISTRIBUTING CO OF MN R55CKR2 -ASIOI CITY OF AP. VALLEY 2/Ic. ./ 83839 Council Check Register by OL Page- 15 Council Check Register by Invoice&Summary 1/1920/7 -- 2/17/2017 Check# Data Amount Supplier/Explanation PO# Doc No Inv No Account No Subledger Account Description Business Unit 272868 2/152017 100013 J J TAYLOR DISTRIBUTING CO OF MN Confined... 2,759.80 BEER#2 00000116 304379 2627269 50556530 BEER LIQUOR#2 STOCK PURCHASES 40.00 NOTAXN2 00000116 304380 2627269 5055.6545 NON-TAXABLE MISC FOR RESALE LIQUOR 92 STOCK PURCHASES 39.04- CMBEER#2 00000116 304381 2627269 5055.6530 BEER LIQUOR#2 STOCK PURCHASES 3.00 FREIGHT#2 00000116 304382 2627269 5055.6550 FREIGHT ON RESALE MDSE LIQUOR#2 STOCK PURCHASES 3.00- CMFREIGHT92 00000116 304383 2627269 5055.6550 FREIGHT ON RESALE MDSE LIQUOR#2 STOCK PURCHASES 7,557.35 BEER#1 00000116 304357 2627277 5015.6530 BEER LIQUOR#1 STOCK PURCHASES 97.95 TAX#1 00000116 304358 2627277 5015.6540 TAXABLE MISC FOR RESALE LIQUOR#1 STOCK PURCHASES 78.80 NOTAX#I 00000116 304359 2627277 5015.6545 NON-TAXABLE MISC FOR RESALE LIQUOR 41 STOCK PURCHASES 140.74- CMBEERM 00000116 304360 2627277 5015.6530 BEER LIQUOR#1 STOCK PURCHASES 3.00 FREIGHT#1 00000116 304361 2627277 5015.6550 FREIGHT ON RESALE MDSE LIQUOR#1 STOCK PURCHASES 3.00- CMFREIGHTNI 00000116 304362 2627277 5015.6550 FREIGHT ON RESALE MDSE LIQUOR 91 STOCK PURCHASES 2,350.80 BEER#3 000001/6 304398 2627278 5085.6530 BEER LIQUOR 93 STOCK PURCHASES 77.84 TAX#3 000001/6 304399 2627278 5085.6540 TAXABLE MISC FOR RESALE LIQUOR#3 STOCK PURCHASES 38.80 NOTAX43 000001/6 304400 2627278 50856545 NON-TAXABLE MISC FOR RESALE LIQUOR#3 STOCK PURCHASES 35.73- CMBEER#3 00000116 304401 2627278 50856530 BEER LIQUOR#3 STOCK PURCHASES 3.00 FREIGHT#3 00000116 304402 2627278 5085.6550 FREIGHT ON RESALE MDSE LIQUOR#3 STOCK PURCHASES 3.00- CMFREIGHT93 00000116 304403 2627278 5085 6550 FREIGHT ON RESALE MDSE LIQUOR#3 STOCK PURCHASES 1,335.20 BEER#2 00000116 304384 2627297 50556530 BEER LIQUOR#2 STOCK PURCHASES 36.80 TAX#2 00000116 304385 2627297 5055.6540 TAXABLE MISC FOR RESALE LIQUOR 42 STOCK PURCHASES 50.90- CMBEER#2 00000116 304386 2627297 5055.6530 BEER LIQUOR 42 STOCK PURCHASES 3.00 FREIGHT#2 00000116 304387 2627297 5055.6550 FREIGHT ON RESALE MDSE LIQUOR#2 STOCK PURCHASES 3.00- CMFREIGHT#2 00000116 304388 2627297 5055.6550 FREIGHT ON RESALE MDSE LIQUOR 42 STOCK PURCHASES 4,582.00 BEER#1 00000116 304363 2627304 5015.6530 BEER LIQUOR#1 STOCK PURCHASES 49.20 TAX#1 00000116 304364 26273D4 5015.6540 TAXABLE MISC FOR RESALE LIQUOR 91 STOCK PURCHASES 51.17- CMBEER#1 00000116 304365 2627304 5015.6530 BEER LIQUOR 91 STOCK PURCHASES 3.00 FREIGHTH 00000116 304366 2627304 5015.6550 FREIGHT ON RESALE MDSE LIQUOR#1 STOCK PURCHASES 3.00- CMFREIGHT#I 00000116 304367 2627304 50156550 FREIGHT ON RESALE MDSE LIQU0R#1 STOCK PURCHASES 2,468.75 BEER#3 00000116 304404 2627305 50856530 BEER LIQUOR#3 STOCK PURCHASES 64.69 TAX#3 00000116 304405 2627305 5085.6540 TAXABLE MISC FOR RESALE LIQUOR#3 STOCK PURCHASES 36.56- CMBEER#3 00000116 304406 2627305 50856530 BEER LIQUOR#3 STOCK PURCHASES 3.00 FREIGHT#3 00000116 304407 2627305 50856550 FREIGHT ON RESALE MDSE LIQUOR 03 STOCK PURCHASES 3.00- CMFREIGHT#3 00000116 304408 2627305 5085.6550 FREIGHT ON RESALE MDSE LIQUOR#3 STOCK PURCHASES 4,678.50 BEER#3 00000116 304409 2627322 5085.6530 BEER LIQUOR 43 STOCK PURCHASES 64.50- CMBEER#3 00000116 304410 2627322 50856530 BEER LIQUOR 03 STOCK PURCHASES 3.00 FREIGHT43 00000116 304411 2627322 50856550 FREIGHT ON RESALE MDSE LIQUOR#3 STOCK PURCHASES 3.00- CMFREIGHT#3 00000116 304412 2627322 5085.6550 FREIGHT ON RESALE MDSE LIQUOR#3 STOCK PURCHASES 1,585.55 BEER#2 00000116 304389 2627326 5055.6530 BEER LIQUOR#2 STOCK PURCHASES 24.60 TAX#2 00000116 304390 2627326 5055.6540 TAXABLE MISC FOR RESALE LIQUOR#2 STOCK PURCHASES 67.18- CMBEER#2 00000116 304391 2627326 5055.6530 BEER LIQUOR#2 STOCK PURCHASES R55CKR2 LOGISI01 CITY OF APPLE VALLEY 2/16/2017 8:3839 Council Check Register by GL Page- 16 Council Check Register by Invoice&Summary 1/19/2017 -- 2/172017 Check# Use Amount Supplier/Explanation PO Doc.No Inv No Account No Subledger Account Description Business Unit 272868 2/15/2017 100013 JJTAVL0R DISTRIBUTING COOFMN Continued... 3.00 FREIGHT92 00000116 304392 2627326 50556550 FREIGHT ON RESALE MDSE LIQUOR#2 STOCK PURCHASES 3.00- CMFREIGHT#2 00000116 304393 2627326 50556550 FREIGHT ON RESALE MDSE LIQUOR#2 STOCK PURCHASES 7,73895 BEER#1 00000116 304368 2627336 5015.6530 BEER LIQUORO STOCK PURCHASES 49.20 TAX41 00000116 304369 2627336 5015.6540 TAXABLE MISC FOR RESALE LIQUORM STOCK PURCHASES 38.80 NOTAX41 00000116 304370 2627336 5015.6545 NON-TAXABLE MISC FOR RESALE LIQUOR#I STOCK PURCHASES 112.96- CMBEER#1 00000116 304371 2627336 50156530 BEER LIQUOR#1 STOCK PURCHASES 3.00 FREIGHT#I 00000116 304372 2627336 5015.6550 FREIGHT ON RESALE MDSE LIQUORO STOCK PURCHASES 3.00- CMFREIGHT#I 00000116 304373 2627336 5015.6550 FREIGHT ON RESALE MDSE LIQUOR 91 STOCK PURCHASES 1,243.00 BEER92 00000116 304394 2627362 5055.6530 BEER LIQUOR#2 STOCK PURCHASES 76.25- CMBEER#2 00000116 304395 2627362 5055.6530 BEER LIQUOR#2 STOCK PURCHASES 3.00 FREIGHT#2 000001/6 304396 2627362 5055.6550 FREIGHT ON RESALE MDSE LIQUOR#2 STOCK PURCHASES 3.00- CMFREIGHT#2 00000116 304397 2627362 5055.6550 FREIGHT ON RESALE MDSE LIQUOR 92 STOCK PURCHASES 6,279.40 BEER#I 00000116 304374 2627368 5015.6530 BEER LIQUOR 91 STOCK PURCHASES 13.60 TAX#1 000001/6 304375 2627368 5015.6540 TAXABLE MISC FOR RESALE LIQUOR 91 STOCK PURCHASES 130.75- CMBEER#1 00000116 304376 2627368 5015.6530 BEER LIQUOR 91 STOCK PURCHASES 3.00 FREIGHT#1 00000116 304377 2627368 5015.6550 FREIGHT ON RESALE MDSE LIQUOR#1 STOCK PURCHASES 3.00- CMFREIGHT#I 00000116 304378 2627368 5015.6550 FREIGHT ON RESALE MDSE LIQUOR#1 STOCK PURCHASES 1,483.20 BEER#3 00000116 304413 2627369 5085.6530 BEER LIQUOR#3 STOCK PURCHASES 38.80 NOTAX#3 00000116 304414 2627369 50856545 NON-TAXABLE MISC FOR RESALE LIQUOR#3 STOCK PURCHASES 135.75- CMBEER#3 00000116 304415 2627369 5085.6530 BEER LIQUOR 93 STOCK PURCHASES 300 FREIGHT43 00000116 304416 2627369 5085.6550 FREIGHT ON RESALE MDSE LIQUOR#3 STOCK PURCHASES 300- CMFREIGHT#3 00000116 304417 2627369 5085"6550 FREIGHT ON RESALE MDSE LIQUOR 93 STOCK PURCHASES 4380 BEER 304183 2655202 5120.6419 GOLF-BEER GOLF KITCHEN 43,813.85 272869 2/15/2017 118232 JOHN DEERE FINANCIAL 94.68 TRACTOR AIR FILTERS4231 304231 P82451 17656215 EQUIPMENT-PARTS PARK EQUIPMENT MAINTENANCE 4.68- AIR FILTERS 304233 P82452 17656215 EQUIPMENT-PARTS PARK EQUIPMENT MAINTENANCE Supplier 100608 FRONTIER AG&TURF 90.00 272870 2/15/2017 100255 JOHNSON BROTHERS LIQUOR 180.00- CMLIQ#1 00000109 304507 122111 50156510 LIQUOR LIQUORM STOCK PURCHASES 106.50 LIQ#3 00000109 304522 5641869 5085.6510 LIQUOR LIQUOR#3 STOCK PURCHASES 639.00 LIQ91 00000109 304503 5644548 5015.6510 LIQUOR LIQUOR#1 STOCK PURCHASES 36000 WINE#I 00000109 304526 5644549 5015.6520 WINE LIQUOR#1 STOCK PURCHASES 319.50 LIQ42 00000109 304513 5644550 5055.6510 LIQUOR LIQUOR 42 STOCK PURCHASES 213.00 LIQ#3 00000109 304521 5644551 5085.6510 LIQUOR LIQUOR#3 STOCK PURCHASES 414.50 LIQ#1 00000109 304504 5646826 50156510 LIQUOR LIQUOR#1 STOlF(PURCHASES 1,407.35 WINE#1 00000109 304527 5646827 50156520 WINE LIQUORO S PURCHASES R55CKR2 .....ISI01 CITY OF APS /ALLEY" 2/10... ./ 8:38:39 Council Check Register by GL Page- 17 Council Check Register by Iavoice&Summary 1/19/2017 -- 2/17/2017 Check# Data Amount Supplier/Explanation PO# Doc No Inv No Account No Subledger Account Description Business Unit 272870 2/152017 100255 JOHNSON BROTHERS LIQUOR Continued... 1505.65 WINE91 00000109 304528 5646828 5015.6520 WINE LIQUOR 41 STOCK PURCHASES 868.52 WINE#3 00000109 304540 5646829 5085.6520 WINE LIQUOR#3 STOCK PURCHASES 3.42- CMWINE#3 00000109 304541 5646829 5085.6520 WINE LIQUOR 43 STOCK PURCHASES 124.40 LIQ#1 00000109 304505 5646830 5015.6510 LIQUOR LIQUOR 41 STOCK PURCHASES 776.39 WINE#I 00000109 304529 5646831 5015.6520 WINE LIQUOR#I STOCK PURCHASES 109.95 BEER#1 00000109 304500 5646832 50156530 BEER LIQUOR#I STOCK PURCHASES 151.00 LIQ92 00000109 304514 5646833 50556510 LIQUOR LIQUOR#2 STOCK PURCHASES 546.45 WINE92 00000109 304533 5646834 50556520 WINE LIQUOR#2 STOCK PURCHASES 612.35 WINE#2 00000109 304534 5646835 5055.6520 WINE LIQUOR 02 STOCK PURCHASES 44928 WINE92 00000109 304536 5646836 50556520 WINE LIQUOR N2 STOCK PURCHASES 579.25 WINE#3 00000109 304543 5646838 5085.6520 WINE LIQUOR 93 STOCK PURCHASES 365.20 WINE93 00000109 304544 5646839 5085.6520 WINE LIQUOR#3 STOCK PURCHASES 579.00 WINE#2 00000109 304537 5647180 5055.6520 WINE LIQUOR#2 STOCK PURCHASES 11,34277 LIQ41 00000109 304506 5651860 50156510 LIQUOR LIQUOR 1 STOCK PURCHASES 3,249.03 LIQ#1 00000109 304508 5651861 5015.6510 LIQUOR LIQUOR#I STOCK PURCHASES 1,424.95 WINE#I 00000109 304530 5651862 5015.6520 WINE LIQUOR#I STOCK PURCHASES 121.80 BEER#I 00000109 304501 5651863 5015.6530 BEER LIQUOR#I STOCK PURCHASES 150.00 LIQ#I 00000109 304509 5651864 5015.6510 LIQUOR LIQUOR#I STOCK PURCHASES 1,56427 LIQ#I 00000109 304510 5651865 50156510 LIQUOR LIQUOR I STOCK PURCHASES 409.43 WINE41 00000109 304531 5651866 5015.6520 WINE LIQUOR#1 STOCK PURCHASES 188.70 TAM 00000109 304502 5651867 5015.6540 TAXABLE MISC FOR RESALE LIQUOR#1 STOCK PURCHASES 532.50 LIQ#2 00000109 304515 5651868 50556510 LIQUOR LIQUOR#2 STOCK PURCHASES 299.50 LIQ#1 00000109 304511 5651870 5015.6510 LIQUOR LIQUOR#I STOCK PURCHASES 9,936.84 LIQ#2 00000109 304516 5651871 5055.6510 LIQUOR LIQUOR 92 STOCK PURCHASES 1,165.95 LIQ#2 00000109 304517 5651872 50556510 LIQUOR LIQUOR 42 STOCK PURCHASES 830.80 WINE92 00000109 304538 5651873 5055.6520 WINE LIQUOR#2 STOCK PURCHASES 43175 LIQ#2 00000109 304518 5651874 5055.6510 LIQUOR LIQUOR#2 STOCK PURCHASES 1,16731 LIQ92 00000109 304519 5651875 50556510 LIQUOR LIQUOR#2 STOCK PURCHASES 146.32 WINE#2 00000109 304539 5651876 50556520 WINE LIQUOR#2 STOCK PURCHASES 4,723.74 LIQ#3 00000109 304523 5651877 5085.6510 LIQUOR LIQUOR#3 STOCK PURCHASES 879.84 LIQ43 00000109 304524 5651878 5085.6510 LIQUOR LIQUOR 03 STOCK PURCHASES 652.95 WINE#3 00000109 304545 5651879 5085.6520 - WINE LIQUOR#3 STOCK PURCHASES 552.37 LIQ#3 00000109 304525 5651880 5085.6510 LIQUOR LIQUOR 93 STOCK PURCHASES 502.10 WINE#3 00000109 304546 5651881 5085.6520 WINE LIQUOR#3 STOCK PURCHASES 43.98 BEER#3 00000109 304520 5651882 50856530 BEER LIQUOR 93 STOCK PURCHASES 155.00 LIQ#I 00000109 304512 5652127 5015.6510 LIQUOR LIQUOR 91 STOCK PURCHASES 26.30- CMWINE#1 00000109 304532 613012 5015.6520 WINE LIQUOR#1 STOCK PURCHASES 115.85- CMWINE#2 00000109 304535 613157 5055.6520 WINE LIQUOR 02 STOCK PURCHASES 57.90- CMWINE#3 00000109 304542 613159 5085.6520 WINE LIQUOR#3 STOCK PURCHASES R55CKR2 LOGISEH - CITY OF APPLE VALLEY 2/16/2017 8:38:39 Council Check Register by GL Page- I8 Council Check Register by Invoice&Summary 1/19/2017 -- 2/17/2017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No Account No Subledger Account Description Business Unit 272870 2/152017 1002.55 JOHNSON BROTHERS LIQUOR Continued... 50,214.72 272871 2//52017 138642 KABAT,JOHN 5000 MN FIRE SCH-NO MANKATO-KABAT 304591 20170213 13106278 SUBSISTENCE ALLOWANCE FIRE TRAINING 50,00 272872 2/152017 143535 KIDCREATE STUDIO 2400 KIDCREATE.WORKAGRE&MESSY TIME 304219 6970 1845.6249 OTHER CONTRACTUAL SERVICES REC SELF SUPPORT FROG GENERAL 24.00 272873 2/15/2017 145176 KIESLER'S POLICE SUPPLY INC 5,173.20 2017 AMMO ORDER-.223 PRAC. 304679 817484 1210 6229 GENERAL SUPPLIES POLICE FIELD OPERATIONS/PATROL 5,173.20 272874 2/15/2017 150561 KUKLOCK.JIM 2726 JAN MILEAGE/PKG-KUKLOCK 304163 20170125 5025.6277 MILEAGE/AUTO ALLOWANCE LIQUOR#1 OPERATIONS 27.26 272875 2/15/2017 148879 LA ROCHE'S INC 295.00 PUMP HUNTINGTON SEPTIC 304600 20201 1730.6249 OTHER CONTRACTUAL SERVICES PARK BUILDING MAINTENANCE 295.00 272876 2/15/2017 102246 LERUM,TIMOTHYM 5.00 PARKING-PESTICIDE EXAM 304230 20170201 1775.6275 SCHOOLS/CONFERENCES/EXP LOCAL PARK MAINTENANCE TRAINING 5.00 272877 2/15/2017 150575 LITTLEFIELD,MATTHEW 250.00 MWF MEDALLION HUNT PRIZE 304705 20170204 18456229 GENERAL SUPPLIES REC SELF SUPPORT PROG GENERAL 250.00 272878 2/152017 100021 MAMUNDSONLLP 77,05 TAX#2 00044390 304252 231796 5055.6540 TAXABLE MISC FOR RESALE LIQUOR 92 STOCK PURCHASES 662.09 NOTAX#2 00044390 304253 231796 5055.6545 NON-TAXABLE MISC FOR RESALE LIQUOR#2 STOCK PURCHASES 739.14 272879 2/1.5/2017 100293 MACQUEEN EQUIPMENT 1,100.00 SEWER NOZZLE 304154 P03553 53906211 SMALL TOOLS&EQUIPMENT SWR EQUIP/VEHICLE MISC MNTC/RP 1,100.00 272880 2/15 119353 MADISON NATIONAL LIFE INS CO INC R55CKR2 L-SI01 CITY OF APF. ALLEY 2/16,_ 8:3839 Council Check Register by GL Page- 19 Council Check Register by Invoice&Summary 1119/2017 - 2/17/2017 Check Date Amount Supplier/Explanation PO Doc No Inv No Account No Subledger Account Description Business Unit 272880 2/152017 119353 MADISON NATIONAL LIFE INS CO INC Continued... 232.70 STD FEES FEB 304609 20170201 1020.6235 CONSULTANT SERVICES HUMAN RESOURCES .15 LTD INSURANCE ADJ T BOOTH JAN. 304609 20170201 9000.2113 ACCRUED LTD PAYROLL CLEARING BAL SHEET 71 LTD INSURANCE AD]ENGEL JAN, 304609 20170201 9000 2113 ACCRUED LTD PAYROLL CLEARING BAL SHEET 2,283.19 LTD INSURANCE 304609 20170201 9000.2113 ACCRUED LTD PAYROLL CLEARING BAL SHEET 2,516.75 272881 2/15/2017 148903 MARCO TECHNOLOGIES LLC 5,490.36 IF PHONE SYSTEM PROJECT 304671 INV3743102 4002.6810 CONSTRUCTION IN PROGRESS MUNICIPAL BUILDINGS 5,490.36 272882 2/15/2017 122121 MARGRON SKOGLUND WINE IMPORTS 256.00 WINE#1 00046453 304614 20020776 5015.6520 WINE LIQUOR#1 STOCK PURCHASES 5.00 FREIGHT#1 00046453 304615 20020776 5015.6550 FREIGHT ON RESALE MDSE LIQUOR#I STOCK PURCHASES 261.00 272883 2/15/2017 140620 MEDIAUSA 265.00 LEGION AD 304245 20170127 5105.6239 PRINTING GOLFMANAGEMENT 265.00 272884 2/15/2017 100309 MENARDS 6.48 SUMP PUMP DRAIN TUBING 304697 11896 5380.6229 GENERAL SUPPLIES SEWER LIFT STN REPAIR&MNTC 8.98 AVCC PAINT PROJECT 304238 12467 19006229 GENERAL SUPPLIES AV COMMUNITY CENTER 24.48 SUPPLIES SIGN CONSTRUCTION 304243 12498 1720.6229 GENERAL SUPPLIES PARK GROUNDS MAINTENANCE HAS SUPPLIES 304680 12546 1720.6229 GENERAL SUPPLIES PARK GROUNDS MAINTENANCE 101.97 CORNER GAURDS 304711 12578 19006229 GENERAL SUPPLIES AV COMMUNITY CENTER 32.39 CORTLAND VB 304712 12619 1745.6229 GENERAL SUPPLIES PARK CRT/GAME AREA MAINTENANCE 4.47 PKLIGHTBULBS 304670 12647 17306229 GENERAL SUPPLIES PARK BUILDING MAINTENANCE 10.73 PK MISC SUPPLIES 304669 12687 17656229 GENERAL SUPPLIES PARK EQUIPMENT MAINTENANCE 9.58 GARAGE DOOR SCREWS 304703 12690A 1540.6229 GENERAL SUPPLIES CMF BUILDINGS&GROUNDS MNTC 210.96 272885 2/13/2017 100849 METRO VOLLEYBALL OFFICIALS ASSN 256.50 VB OFFICIALS I-24-17 304166 5111 18606235 CONSULTANT SERVICES REC VOLLEYBALL 256.50 272886 2/152017 100705 MGCSA 150.00 AD FOR FOREMAN POSITION 304234 1344 5105u239 PRINTING GOLF MANAGEMENT 150.00 272887 2/15/2017 110599 MN AW WA R55CKR2 LOGISI01 CITY OF APPLE VALLEY 2/16/2017 8.38:39 Council Check Register by GL Page- 20 Council Check Register by Invoice&Summary 1/19/2017 -- 2/17/2017 Check Date Amount Supplier/Explanation PO# Doc No Inv No Account No Subledgcr Account Desctiptlon Business Unit 272887 2/15/2017 110598 MNAWWA Continued... 225.00 AWWAOPERATORS-MANN 304599 200001991 5315.6275 SCHOOLS/CONFERENCES/EXP LOCAL WATER TRAINING/SCHOOL/MEETINGS 225.00 AWWA OPERATORS-WILLMAN 304599 200001991 5315.6275 SCHOOLS/CONFERENCES/EXP LOCAL WATER TRAINING/SCHOOL/MEETINGS 225.00 AWWAOPERATORS-KRINGS 304599 200001991 53156275 SCHOOLS/CONFERENCES/EXP LOCAL WATER TRAINING/SCHOOL/MEETINGS 675.00 272888 2/15/2017 123091 MN CIT OFFICERS ASSOCIATION 625.00 CITTRAINMG-DEJONKER 304193 20170206 1225.6275 SCHOOLS/CONFERENCES/EXP LOCAL POLICE TRAINING 625.00 CIT TRAINING-GERVING 304193 20170206 12256275 SCHOOLS/CONFERENCES/EXP LOCAL POLICE TRAINING 1,250.00 272889 2/152017 114686 MN POLLUTION CONTROLAGENCY 345.00 COLLECTION OPERATOR-MCWILLIAMS 304583 20170209 5370.6275 SCHOOLS/CONFERENCES/EXP LOCAL SEWER TRAINING/SCHOOL/MEETINGS 345.00 COLLECTION OPERATORS-BESSE 304584 20170209A 5370.6275 SCHOOLS/CONFERENCES/EXP LOCAL SEWER TRAINING/SCHOOL/MEETINGS 690.00 272890 2//52017 122714 MN POLUTION CONTROLAGENCY 55.00 PBORASH EXAM FEE 304704 20170213 5365.6280 DUES&SUBSCRIPTIONS SEWER MGMT/REPORTS/DATA ENTRY 55.00 272891 2/152017 148952 MN RURALWATER ASSOCIATION 230.00 MRWA CONFST CLOUD-BORASH 304585 20170209 53156276 SCHOOLS/CONFERENCES/EXP OTHER WATER TRAINING/SCHOOL/MEETINGS 23000 MRWA CONF-ST CLOUD-ZIMMERMAN 304586 20170209A 5315.6276 SCHOOLS/CONFERENCES/EXP OTHER WATER TRAINING/SCHOOL/MEETINGS 230.00 MRWA CONF-ST CLOUD-BREITUNG 304587 20170209B 53156276 SCHOOLS/CONFERENCES/EXP OTHER WATER TRAINING/SCHOOL/MEETINGS 23000 MRWA CONF-ST CLOUD-NELSON 304588 20/702090 53156276 SCHOOLS/CONFERENCES/EXP OTHER WATER TRAINMG/SCHOOL/MEETINGS 920.00 272892 2/15/2017 150578 MORGAN,DAVID 50.00 MN FIRE SCH-NO MANKATO-MORGAN 304593 20170213 1310.6278 SUBSISTENCE ALLOWANCE FIRE TRAINING 50.00 272893 2//52017 101579 MUELKEN,SUSAN M 60.99 JAN/FEB MILEAGE-MUELKEN 304667 20170203 1700.6277 MILEAGE/AUTO ALLOWANCE PARK&RECREATION MANAGEMENT 60.99 272894 2/15/2017 148126 MUSKIE MAIDEN LURES 134.64 NOTAX#I 00051957 304612 113 5015.6545 NON-TAXABLE MISC FOR RESALE LIQUOR#1 STOCK PURCHASES 134.64 272895 2/152017 137637 NFPA 134550 2017 NFPA SUBSCRIPTION RENEWAL 304672 6837997X 13006280 DUES&SUBSCRIPTIONS FIRE MANAGF R55CKR2 L—SI01 CITY OF APF. ALLEY 2/16,_ . 8:3839 Council Check Register by GL Page- 21 Council Check Register by Invoice&Summary 1/19/2017 — 2/17/2017 Check Date Amount Supplier/Explanation PO Doc No Inv No Account No Subledger Account Description Business Unit 272895 2//52017 137637 NFPA Continued... 1,345.50 272896 2/15/2017 122005 NORTHLAND CHEMICAL CO 145.46 GLASS CLEANER 304709 5063650 1900.6229 GENERAL SUPPLIES AV COMMUNITY CENTER 145.46 272897 2/152017 150580 OLIPHANT BREWING LLC 600.00 BEER#3 00052161 304356 843 5085.6530 BEER LIQUOR 93 STOCK PURCHASES 600.00 272898 2/15/2017 110957 O'REILLY AUTOMOTIVE INC. 30.02- STEERING STABILIZER(CREDIT) 303990 3245263522 1350.6215 EQUIPMENT-PARTS FIRE VEHICLE MAINTENANCE 2.34- POL DISCOUNT 304688 3245265132 1210.6333 GENERAL-CASH DISCOUNTS POLICE FIELD OPERATIONS/PATROL 116.91 LONG LIFE OIL FILTERS 304688 3245265132 1210.6215 EQUIPMENT-PARTS POLICE FIELD OPERATIONS/PATROL 84.55 272899 2/152017 150582 OTTO,MARTIN 20.01 UB REFUND 5291149TH ST W 304594 20170208A 53014997 WATER/SEWER ACCT REFUNDS WATER&SEWER FUND REVENUE 20.01 272900 2/15/2017 100886 PARK SUPPLY OFAMERICA INC 1167 WRENCH 304420 211382601 1900.6211 SMALL TOOLS&EQUIPMENT AV COMMUNITY CENTER 11 67 272901 2//52017 150.574 PEARMAN,DIANNE 21.00 HOLIDAY PARTY REFUND 304173 20173101 1001 4355 RECREATION USER FEES GENERAL FUND REVENUE 21.00 272902 2/152017 148951 PERFORMANCE PLUS LLC 10,03100 FIREFIGHTERANNUAL PHYSICALS 304673 458OLF 1330.6235 CONSULTANT SERVICES FIRE OPERATIONS 143.00 MURPHY ANNUAL FF PHYSICAL 304202 4585LF 13306235 CONSULTANT SERVICES FIRE OPERATIONS 10,174.00 272903 2/15/2017 100751 PHILLIPS WINE&SPIRITS INC 602.00 WINE#Icameio&entered2016 00000106 304487 2090165 5015.6520 WINE LIQUOR#I STOCK PURCHASES 1,268.96 WINE#1 camein&entered2016 00000106 304486 2090167 5015.6520 WINE LIQUOR 41 STOCK PURCHASES 83000 WINE#1 00000106 304488 2114451 5015.6520 WINE LIQUOR 91 STOCK PURCHASES 78.00 WINE#2 00000106 304490 2114452 50556520 WINE LIQUOR 92 STOCK PURCHASES 10.18- CMWINE#2 00000106 304491 2114452 50556520 WINE LIQUOR#2 STOCK PURCHASES 1,514.75 LIQ#I 00000106 304480 2117958 50156510 LIQUOR LIQUOR#1 STOCK PURCHASES R55CKR2 LOOTS101 CITY OF APPLE VALLEY 2/162017 8:38:39 Council Check Register by GL Page- 22 Council Check Register by Invoice&Summary 1/192017 -- 2/17/2017 Check# Data Amount Supplier/Explanation PO# Doc No Inv No Account No Subledger Account Description Business Unit 272903 2//52017 100751 PHILLIPS WINE&SPIRITS INC Conduued... 1419.09 WINE#1 00000106 304489 2117959 50156520 WINE LIQUOR#1 STOCK PURCHASES 8800 TAX#1 00000106 304478 2117960 5015.6540 TAXABLE MISC FOR RESALE LIQUOR#1 STOCK PURCHASES 109.08 NOTAX#I 00000106 304479 2117960 50156545 NON-TAXABLE MISC FOR RESALE LIQUOR#1 STOCK PURCHASES 126.50 LIQ#2 00000106 304482 2117961 5055.6510 LIQUOR LIQUOR#2 STOCK PURCHASES 15600 WINE#2 00000106 304492 2117962 5055.6520 WINE LIQUOR 92 STOCK PURCHASES 20.36- CMWINE#2 00000106 304493 2117962 50556520 WINE LIQUOR 92 STOCK PURCHASES 26.00 TAX#2 00000106 304481 2117963 5055 6540 TAXABLE MISC FOR RESALE LIQUOR#2 STOCK PURCHASES 4100 WINE93 00000106 304494 2117964 50856520 WINE LIQUOR#3 STOCK PURCHASES 1,126.75 LIQ93 00000106 304485 2117965 50856510 LIQUOR LIQUOR#3 STOCK PURCHASES 389.70 CMWINE#3 00000106 304495 2117966 50856520 WINE LIQUOR#3 STOCK PURCHASES HT00 TAX#3 00000106 304483 2117967 5085.6540 TAXABLE MISC FOR RESALE LIQUOR 43 STOCK PURCHASES 1800 NOTAX#3 00000106 304484 2117967 5085.6545 NON-TAXABLE MISC FOR RESALE LIQUOR 43 STOCK PURCHASES 7,877.29 272904 2/15/2017 144083 PIONEER MANUFACTURING COMPANY 254.00 ATHLETIC FIELD LAYOUT 304496 IN V625368 1715.6211 SMALL TOOLS&EQUIPMENT PARK ATHLETIC FIELD MAINTENANC 254.00 272905 2/15/2017 143336 PREMIER LOCATING INC 340,00 GSOC LOCATES ELEC-JAN 304698 38980 5805 6249 OTHER CONTRACTUAL SERVICES STREET LIGHT UTILITY FUND 340.00 272906 2/15/2017 101500 PREMIUM WATERS INC 641 WATER 304181 6182510117 5120.6421 GOLF-NON ALCOHOLIC BEVERAGES GOLF KITCHEN 641 272907 2/15/2017 137785 PROPERTY TAXATION&RECORDS 46.00 CUPCHRISTCHURCH 304190 43 45026239 2016177G PRINTING IMPROVEMENTS-ASSESSED 46.00 CUPMOUNTOLIVET 304190 43 4502.6239 2016176G PRINTING IMPROVEMENTS-ASSESSED 8600 VACATION-PALOMINOMIGHLANDS 304190 43 4502.6239 2016181G PRINTING IMPROVEMENTS-ASSESSED 178,00 272908 2/152017 111665 PRZYBYLSKI,JOSEPH E 28.49 JEANS-IPR-PRZYBYLSKI 304237 20170125A 1600.6281 UNIFORM/CLOTHING ALLOWANCE STREET MANAGEMENT 29A9 272909 2/15/2017 129265 RAINBOW PARTY ARTS 160.00 WORKAGREE-MWF BALLOON ANIMALS 304223 4744 18456249 OTHER CONTRACTUAL SERVICES REC SELF SUPPORT PROG GENERAL 160.00 CITYOFAPP. ALLEY R55CKR2 L.,_,3101 2/I6,_ 8:3839 Council Check Register by GL Page- 23 Council Check Register by Invoice&&nnmary 1/19/2017 -- 2/172017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No Account No Subledger Account Descrip0on Business Unit 272910 2/15/2017 149126 RED BULLDISTRIBUTIONCOMPANY Confinued... 26800 TAX#2 00052064 304635 K22199122 5055.6540 TAXABLE MISC FOR RESALE LIQUOR 42 STOCK PURCHASES 32625 TAX#1 00052064 304634 K22820468 50156540 TAXABLE MISC FOR RESALE LIQUOR#1 STOCK PURCHASES 594.25 272911 2/152017 150581 SCHUMACHER,DONNA 60.00 UB REFUND 7915147TH ST W 304595 20170208 5301.4997 WATER/SEWER ACCT REFUNDS WATER&SEWER FUND REVENUE 60.00 272912 2/15/2017 111161 SHRED IT USA LLC 73.60 SHREDDING SERVICE-DEC 304180 8121653238 1250.6240 CLEANINGSERVICE/GARBAGEREMOV POLICE FACILITY 73.60 272913 2/15/2017 150390 SIDESHOW BLOODY MARY 144.00 TAX#1 00052127 304613 1026 5015.6540 TAXABLE MISC FOR RESALE LIQUOR 91 STOCK PURCHASES 144.00 272914 2/15/2017 102293 SKINNER,STEPHAN C 90.94 JAN MILEAGE-SKINNER 304421 20170131 1700.6277 MILEAGE/AUTO ALLOWANCE PARK&RECREATION MANAGEMENT 90.94 272915 2/152017 144495 SMALLLOTMN 104.04 WINE91 00051469 304616 12042 5015.6520 WINE LIQUORH STOCK PURCHASES 5.00 FREIGHT#I 00051469 304617 12042 5015.6550 FREIGHT ON RESALE MDSE LIQUOR#1 STOCK PURCHASES 591.96 WINE93 00051469 304618 12197 5085.6520 WINE LIQUOR 03 STOCK PURCHASES 10.25 FREIGHT#3 00051469 304619 12197 5085.6550 FREIGHT ON RESALE MDSE LIQUOR 93 STOCK PURCHASES 711.25 272916 2/152017 148902 SOLE,JOHN 5000 MN FIRE SCH-NO MANKATO-SOLE 304592 20170213 13106278 SUBSISTENCE ALLOWANCE FIRE TRAINING 50,00 272917 2/15/2017 100447 SOUTH RIVER HEATING&COOLING INC 262.50 ST MARYS WEEKLY BOILER CK-124 304178 1717428 2092.6266 REPAIRS-BUILDING 14200 CEDAR AVE-OLD CITY HALL 262.50 ST MARYS WEEKLY BOILER CK-1/31 304179 1717434 2092.6266 REPAIRS-BUILDING 14200 CEDAR AVE-OLD CITY HALL 63385 BOILER CHEMICAL ADDITION 304156 1717436 5325.6265 REPAIRS-EQUIPMENT WATER TREATMENT FCLTY MNTC/RPR 1,158.85 272918 2/15/2017 100524 SOUTHERN WINE&SPIRITS OF MN LLC 4,082.35 LIQ#1 00050756 304640 1504979 5015.6510 LIQUOR LIQUOR#1 STOCK PURCHASES 2,090.53 WINE#I 00050756 304645 1504984 50156520 WINE LIQUOR 41 STOCK PURCHASES R55CKR2 LOGIS101 CITY OF APPLE VALLEY 2/16/2017 83839 Council Check Register by GL Page- 24 Cotmcil Check Register by Invoice&Summary 1/19/2017 -- 2/17/2017 Check# Date Amount Supplier/Explanation PO# Doc No Im No Account No Subledger Account Description Business Unit 272918 2/152017 100524 SOUTHERN WINE&SPIRITS OF MN LLC Continued... 45.00 LIQ#I 00050756 304641 1504985 50156510 LIQUOR LIQUOR#1 STOCK PURCHASES 276.00 WINE#1 00050756 304644 1504986 50156520 WINE LIQUOR#1 STOCK PURCHASES 76200 WINE#2 00050756 304650 1504989 5055.6520 WINE. LIQUOR 92 STOCK PURCHASES 5,413.65 LIQ#I 00050756 304642 1507368 50156510 LIQUOR LIQUOR 41 STOCK PURCHASES 392.00 WINE#I 00050756 304646 1507369 5015.6520 WINE LIQUOR 41 STOCK PURCHASES 520.00 WINE91 00050756 304647 1507371 5015.6520 WINE LIQUOR#1 STOCK PURCHASES 1,318.03 LIQ42 00050756 304648 1507372 5055.6510 LIQUOR LIQUOR#2 STOCK PURCHASES 4,014.81 LIQ#3 00050756 304651 1507393 5085.6510 LIQUOR LIQUOR#3 STOCK PURCHASES 1,916.00 WINE#3 00050756 304653 1507394 50856520 WINE LIQUOR 03 STOCK PURCHASES 254.00- CMLIQ#1 00050756 304643 9096718 50156510 LIQUOR LIQUOR 91 STOCK PURCHASES 101.00- CMLIQ#2 . 00050756 304649 9096719 50556510 LIQUOR LIQUOR#2 STOCK PURCHASES 175.00- CMLIQ#3 00050756 304652 9096720 50856510 LIQUOR LIQUOR 93 STOCK PURCHASES 20,300.37 272919 2/15/2017 149062 SPECIALIZED ENVIRONMENTALTECH-MSW 131.04 PARK GARBAGE DISPOSAL-JAN 304668 21083 17206240 CLEANING SERVICE/GARBAGE REMOV PARK GROUNDS MAINTENANCE 131.04 272920 2/15/2017 149707 SUMMITCOMPANIES 25963 FIRE SYSTEM INSPECTION 304604 1164871 5110.6266 REPAIRS-BUILDING GOLF CLUBHOUSE BUILDING 259.63 272921 2/15/2017 147332 SUNLIFE 94.50 BASIC LIFE INSURANCE 304608 20170201 9000.2117 ACCRUED LIFE INSUR-BASIC PAYROLL CLEARING HAL SHEET 10,608.50 SUPP/DEP LIFE INSURANCE 304608 20170201 90002118 ACCRUED LIFE INSUR-SUPP/DEPEND PAYROLL CLEARING BAL SHEET 10,703.00 272922 2/15/2017 120105 SWANSON,SCOTT F 2803 JAN MILEAGE-SWANSON 304191 20170131 5005.6277 MILEAGE/AUTO ALLOWANCE LIQUOR GENERAL OPERATIONS 2903 272923 2/15/2017 101753 SYSCO MINNESOTA,INC 108741 FOOD 304676 147097103 5120.6420 GOLF-FOOD GOLF KITCHEN 1,097.41 272924 2/152017 100476 TOWN&COUNTRY GLASS 379.92 WINDSHIELD 921 304684 57787 1210.6265 REPAIRS-EQUIPMENT POLICE FIELD.OPERATIONS/PATROL 37992 272925 2/15/ 101587 TWIN CITY WATER CLINIC INC R55CKR2 L, _,SI01 CITY OF APF. ALLEY 2/16,_ , 838.39 Council Check Register by GL Page- 25 Council Check Register by Invoice&Summary 1/19/2017 -- 2/172017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No Account No Subledger Account Description Business Unit 272925 2//52017 101587 TWIN CITY WATER CLINIC INC Continued... 510.00 BACT SAMPLES-JAN 304157 9229 5305.6249 OTHER CONTRACTUAL SERVICES WATER MGMT/REPORT/DATA ENTRY 510.00 272926 2/152017 141699 ULTRAMAX 1,320.00 2017 AMMO ORDER.308 304678 162576 1210.6229 GENERAL SUPPLIES POLICE FIELD OPERATIONS/PATROL 1,320.00 272927 2/15/2017 148526 US BANK EQUIPMENT FINANCE 360.42 COPIER LEASE 304242 322726399 1500.6310 RENTAL EXPENSE PW MANAGEMENT 360.42 272928 2/15/2017 100493 VALLEY BUICK GMC INC 3354 4341 DIAG.NO START COND. 304187 94042 1630.6265 REPAIRS-EQUIPMENT STREET EQUIPMENT MAINTENANCE 3354 272929 2/15/2017 100839 VALLEY-RICH COMPANY INC 560.40 WATER BREAK 13065 EVELETH 304158 23777 53306269 REPAIRS-OTHER WTR MAIN/HYDRANT/CURB STOP MNT 560.40 272930 2/15/2017 123538 VARITECH INDUSTRIES INC 416.02 ELECTRICVALVES 304149 N0601009690 1630.6215 EQUIPMENT-PARTS STREET EQUIPMENT MAINTENANCE 416.02 272931 2/1520/7 122010 VINOCOPIA 250.75 LIQ93 00046257 304625 172767 50856510 LIQUOR LIQUOR*3 STOCK PURCHASES 1.50 FREIGHT0 00046257 304626 172767 5085.6550 FREIGHT ON RESALE MDSE LIQUOR R3 STOCK PURCHASES 120.00 TAX#1 00046257 304620 172768 5015.6540 TAXABLE MISC FOR RESALE LIQUOR 91 STOCK PURCHASES 184.00 WINE#I 00046257 304621 172768 5015.6520 WINE LIQUOR#1 STOCK PURCHASES 13.50 FREIGHT41 00046257 304622 172768 5015.6550 FREIGHT ON RESALE MDSE LIQUOR 91 STOCK PURCHASES 12000 TAX#2 00046257 304623 172769 5055.6540 TAXABLE MISC FOR RESALE LIQUOR#2 STOCK PURCHASES 9.00 FREIGHT#2 00046257 304624 172769 50556550 FREIGHT ON RESALE MDSE LIQUOR#2 STOCK PURCHASES 218.25 LIQ#3 00046257 304627 173140 5085.6510 LIQUOR LIQUOR 93 STOCK PURCHASES 120.00 TAX#3 00046257 304628 173140 5085.6540 TAXABLE MISC FOR RESALE LIQUOR#3 STOCK PURCHASES 16.00 FREIGHT#3 00046257 304629 173140 5085.6550 FREIGHT ON RESALE MDSE LIQUOR 93 STOCK PURCHASES 053.00 272931 2/15/2017 100504 VOSS LIGHTING 279.90 BULBS FOR HOCKEY RINKS 304239 15297/7200 17256229 GENERALSUPPLIES PARK ICE RINK MAINTENANCE 279.90 R55CKR2 LOGIS101 CITY OF APPLE VALLEY 2/16/2017 8:3839 Council Check Register by GL Page- 26 Council Check Register by Invoice&Summary 1/19/2017 - 2/17/2017 Cheek# Date Amount Supplier/Explanation PO# One,No Inv No Account No Subledger Account Description Business Unit 272933 2/152017 126509 WATER CONSERVATION SERVICE Continued... 364.25 LEAK DETECTION-JAN 304696 7364 5330.6249 OTHER CONTRACTUAL SERVICES WTR MAINMYDRANT/CURB STOP MNT 364.25 272934 2/15/2017 117062 WEISS,TODDR 38.52 JAN MILEAGE-WEISS 304224 20170130 1700.6277 MILEAGE/AUTO ALLOWANCE PARK&RECREATION MANAGEMENT 79.99 BOOTS-TODD WEISS 304710 20170202 1900.6281 UNIFORM/CLOTHING ALLOWANCE AV COMMUNITY CENTER 118.51 272935 2/15/2017 142204 WERNER IMPLEMENT CO.,ENC 177.55- CREDIT RETURNED 304692 72420 1630.6215 EQUIPMENT-PARTS STREET EQUIPMENT MAINTENANCE 21.00 PARTS FOR 9251 304226 72483 1765.6215 EQUIPMENT-PARTS PARK EQUIPMENT MAINTENANCE 170.00 350 LIFT LINK 3 POINT 304188 72550 1630.6215 EQUIPMENT-PARTS STREET EQUIPMENT MAINTENANCE 13.45 272936 2/15/2017 100521 WINE MERCHANTS 716.00 WINE#1 00022992 304547 7119152 5015.6520 WINE LIQUOR 91 STOCK PURCHASES 216.00 WINE#2 00022992 304548 7119153 50556520 WINE LIQUOR#2 STOCK PURCHASES 932.00 272937 2/152017 100363 XCELENERGY 162.25 STREET LIGHTS ELECTRIC 304189 533857147 58056545 NON-TAXABLE MISC FOR RESALE STREET LIGHT UTILITY FUND 162.25 20170154 1/19/2017 142866 HEALTHPARTNERS 4.95- CANCEL LOCKLING DENTAL-RETIRE 304422 70441980 7105.6146 DENTAL INSURANCE INSURANCE TRUST DENTAL 4.95 ADD NEW HIRE C NELSON DENTAL 304422 70441980 7105.6146 DENTAL INSURANCE INSURANCE TRUST DENTAL 495 ADD NEW HIRE J NOVOTNY DENTAL 304422 7044/980 71056146 DENTAL INSURANCE INSURANCE TRUST DENTAL 1069.20 CONSULT/ADMIN FEES-JANUARY 201 304422 70441980 71056146 DENTAL INSURANCE INSURANCE TRUST DENTAL 1,669.50- CANCEL LOCKLING MEDICAL-RETIRE 304422 70441980 9000.2115 .ACCRUED MEDICAL INSURANCE PAYROLL CLEARING HAL SHEET 524.50. FRUECHTEL DIFF IN COST-MEDICAL 304422 70441980 9000.2115 ACCRUED MEDICAL INSURANCE PAYROLL CLEARING BAL SHEET 524.50 ADD NEW HIRE J NOVOTNY MEDICAL 304422 70441980 90002115 ACCRUED MEDICAL INSURANCE PAYROLL CLEARING BAL SHEET 574.50 FRUECHTEL ON WRONG PLAN IN JAN 304422 70441980 90002115 ACCRUED MEDICAL INSURANCE PAYROLL CLEARING BAL SHEET 1,337.00 ADD NEW HIRE C NELSON MEDICAL 304422 70441980 9000.2115 ACCRUED MEDICAL INSURANCE PAYROLL CLEARING BAL SHEET 168,039.50 MEDICAL-FEBRUARY 2017 304422 70441980 9000.2115 ACCRUED MEDICAL INSURANCE PAYROLL CLEARING BAL SHEET 169,355.65 20170155 1/192017 142866 HEALTHPARTNERS 4.95- B SHEA CANCEL COVERAGE 304423 701582/0 71056146 DENTAL INSURANCE INSURANCE TRUST DENTAL 9.90 NEW HIRES R ZELLMER&K HINKLE 304423 70158210 71056146 DENTAL INSURANCE INSURANCE TRUST DENTAL 9.90 P GORDON OWE FOR NOV&DEC 16 304423 70158210 71056146 DENTAL INSURANCE INSURANCEI DENTAL R55CKR2 L.._.6101 CITYOFAPF. ALLEY 2/16,. 8:38:39 Council Check Register by GL Page- 27 Council Check Register by Invoice&Summary 1/192017 — 2/17/2017 Check# Data Amount Supplier/Explanation PO# Doc No Inv No Account No Subledger Account Description Business Unit 20170/55 1/192017 142866 HEALTHPARTNERS Continued... 1,064.25 CONSULT/ADMIN FEES-FEBRUARY 17 304423 70158210 71056146 DENTAL INSURANCE INSURANCE TRUST DENTAL 167,797.50 MEDICAL JANUARY 2017 304423 70158210 9000.2115 ACCRUED MEDICAL INSURANCE PAYROLL CLEARING HAL SHEET 168,876.60 20170218 2/172017 102664 ANCHORBANK 520.01 EMPLOYEE MEDICARE 304210 210171437176 9000.2111 ACCRUED FEDERAL/FICA PAYROLL CLEARING BAL SHEET 520.01 CITY SHARE MEDICARE 304210 210171437176 9000.2111 ACCRUED FEDERAL/FICA PAYROLL CLEARING BAL SHEET 2,075.12 FEDERAL TAXES PR 304210 210171437176 90002111 ACCRUED FEDERAL/FICA PAYROLL CLEARING BAL SHEET 3,115.14 20170219 2/16/2017 101238 MINNESOTA CHILD SUPPORT PAYMENT CENTER 187.86 CHILD SUPPORT DEDUCTIONS 304209 210171437175 90002120 ACCRUED BENEFIT LIABILITY PAYROLL CLEARING BAL SHEET 187.86 20170220 2/172017 100657 MNDEPTOFREVENUE 1,404.02 STATE TAX WITHHOLDING 304206 210171437174 9000.2112 ACCRUED STATE W/H PAYROLL CLEARING BAL SHEET 1,404.02 20170221 2/16/2017 100038 APPLE VALLEY FIREFIGHTERS RELIEFASSN 921.00 FIRE RELIEF DUES 304205 210171437171 9000.2120 ACCRUED BENEFIT LIABILITY PAYROLL CLEARING BAL SHEET 921.00 20170222 2//62017 100240 VANTAGEPOINT TRANSFER AGENTS-457 FT 1,275.00 ICMA-PLAN 4301171 304206 210171437172 9000.2120 ACCRUED BENEFIT LIABILITY PAYROLL CLEARING BAL SHEET 1,27500 20170223 2/162017 100241 VANTAGEPOINT TRANSFER AGENTS-457 PT 1,265.19 ICMA-PLAN#306561 304207 210171437173 90002120 ACCRUED BENEFIT LIABILITY PAYROLL CLEARING BAL SHEET 1,265.19 20170224 2/152017 148841 SELECTACCOUNT 30.00 FLEX SPENDING MEDICA1.2017 304251 38357269 90002119 ACCRUED FLEX SPENDING PAYROLL CLEARING BAL SHEET 30.00 20170225 2/15/2017 148841 SELECTACCOUNT 520.00 FLEX SPENDING DAYCARE-2016 304250 38357269 9000.2119 ACCRUED FLEX SPENDING PAYROLL CLEARING BAL SHEET 520.00 20170226 2/62017 100873 HEALTHPARTNERS(DENTAL CLAIMS-EFT) 5450.00 DENTAL CLAIMS 126-2/1/17 304419 20170214 7105.6146 DENTAL INSURANCE INSURANCE TRUST DENTAL R55CKR2 LOGISI01 CITY OF APPLE VALLEY 2/16/2017 83839 Council Check Register by GL Page- 28 Connell Check Register by Invoice&Summary, 1/19!2017 -- 2/17/2017 Check M Date Amount Supplier/Explanation POM Doc No Inv No Account No 8ubledger Account Description Business Unit 20170226 2/6/2017 100873 HEALTHPARTNERS(DENTAL CLAIMS-EFT) Continued... 5,450 00 775,473.74 Grand Total Payment Instrument Totals Checks 336,851 42 EFT Payments 352,40046 A/P ACH Payment 86,22186 Total Payments 775,473.74 eI 1 1 R55CKS2 L.,u1SI0U CITYOFAPP. .ALLEY 2/16r....r 8:3849 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Pete- 1 1/19/2017 - 2/17/2017 Company Amount 01000 GENERALFUND 81,587.52 02005 LGA/EQUIPMENT CERTIFICATE 4,780.10 02025 ROAD ESCROW FUND 2,060.00 02090 14200 CEDAR AVE-OLD CITY HALL 2,967,15 02095 CENTRAL VILLAGE PARKING LOT 2,305.00 02105 FOUNDERS CIRCLE PARKING LOT 149.35 04000 MUNICIPAL BUILDING FUND 5,490.36 04500 CONSTRUCTION PROJECTS 6,686.97 04900 PHYSICAL IMPROVEMENTS ESCROW F 815.43 04930 FUTURE CAPITAL PROJECTS 59,474.36 05000 LIQUOR FUND 224,426.02 05100 GOLFFUND 2,240.56 05200 ARENA FUND 90422 05300 WATER&SEWER FUND 10,781.83 05500 STORM DRAINAGE UTILITY FUND 567.55 05800 STREET LIGHT UTIL FUND 50225 07100 INSURANCE TRUST DENTAL FUND 7,60325 07200 RISK MANAGEMENT/INSURANCE FUND 4,347.56 09000 PAYROLL CLEARING FUND 357,784.26 Report Totals 775,473.74 R55CKR2 LOGISI01 CITY OF APPLE VALLEY 2/22/2017 15:3936 Council Check Register by GL Page- 1 Council Check Register by Invoice&Summary 1/30/2017 — 2/272017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No Account No Subledger Account Description Business Unit 11968 2242017 100101 ACE HARDWARE 150 BOLTMUT FOR HYD POLE SAW 304744 101390730141 16306215 EQUIPMENT-PARTS STREET EQUIPMENT MAINTENANCE 50 11969 2242017 100037 APPLE VALLEY COLLISION INC 1,252.53 #18 REPAIR BODY DAMAGE 304769 41131 7205.6399 OTHER CHARGES INSURANCE CLAIMS 1,252.53 11970 2242017 100709 BATTERIES PLUS BULBS 38.88 BATTERIES FOR SCBA 304715 17392165 1330.6215 EQUIPMENT-PARTS FIRE OPERATIONS 38.88 11971 2/24/2017 142897 BOLTON&MENK,INC. 809.50 DESIGN 304827 198899 45026235 2015175G CONSULTANT SERVICES IMPROVEMENTS-ASSESSED 2,972.00 SURVEYING 304826 198900 20276235 20151036 CONSULTANT SERVICES ROAD ESCROW 43,961.50 SURVEYING 304819 198901 20276235 2017104G CONSULTANT SERVICES ROAD ESCROW 2,418.00 SURVEYING 304823 198902 2027.6235 2017105G CONSULTANT SERVICES ROAD ESCROW 744.00 RECORD PLANS 304821 198903 45026235 2016123G CONSULTANT SERVICES IMPROVEMENTS-ASSESSED 2,040.00 RECORD PLANS 304820 198904 45026235 2016134G CONSULTANT SERVICES IMPROVEMENTS-ASSESSED 1,62400 RECORD PLANS 304818 198906 4502.6235 2015143G CONSULTANT SERVICES IMPROVEMENTS-ASSESSED 6,530.50 CONSTRUCTION OBSERVATION 304817 198908 2027.6235 2015103G CONSULTANT SERVICES ROAD ESCROW 2,00800 RECORD PLANS 304816 198909 20276235 2016104G CONSULTANT SERVICES ROADESCROW 1,689.89 SURVEY PLAT 304815 198910 20276235 2015159G CONSULTANT SERVICES ROAD ESCROW 1,142.00 CONSTRUCTION OBSERVATION 304814 198911 45026235 2015175G CONSULTANT SERVICES IMPROVEMENTS-ASSESSED 1,624.00 RECORD PLANS 304813 198912 4502.6235 2015153G CONSULTANT SERVICES IMPROVEMENTS-ASSESSED 67,563.39 11972 2242017 143618 DAVIS EQUIPMENT CORPORATION 46.62 CAPS FOR TEE BRINE TANKS 304735 E199495 16306215 EQUIPMENT-PARTS STREET EQUIPMENT MAINTENANCE 46.62 11973 224/2017 100491 GREATER TWIN CITIES UNITED WAY 43.27 CHARITABLE GIVING 304803 22217928225 9000.2120 ACCRUED BENEFIT LIABILITY PAYROLL CLEARING BAL SHEET 43.27 11974 2242017 103314 INNOVATIVE OFFICE SOLUTIONS 47.83 OFFICE SUPPLIES 304830 INI503856 1200.6210 OFFICE SUPPLIES POLICE MANAGEMENT 47.83 11975 224/20/7 118099 JEFFERSON FIRE&SAFETY INC 19387 NOZZLES FOR WASHBAY 304822 234280 1630.6229 GENERAL SUPPLIES STREET EQUIPMENT MAINTENANCE R55CKR2 LOGISI01 CITY OF APPLE VALLEY 2/22/2017 15:39:36 Council Check Register by GL - Page- 2 Council Check Register by Invoice&Summary 1/30/2017 -- 2/27/2017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No Account No Subledger Account Description Business Unit 11975 2/2420/7 118099 JEFFERSON FIRE&SAFETY INC Coati nued... 193.87 11976 2/142017 100289 LOGIS 20,645J)8 JAN LOGIS SERV 304832 42975 1040.6399 OTHER CHARGES DATAPROCESSING 716.14 JAN LOGIS SERV 304832 42975 5005.6399 OTHER CHARGES LIQUOR GENERAL OPERATIONS 255.38 JAN LOGIS SERV 304832 42975 5205.6399 OTHER CHARGES ARENA 1 MANAGEMENT 6,18420 JAN LOGIS SERV 304832 42975 5305.6399 OTHER CHARGES WATER MGMT/REPORT/DATA ENTRY 6,184.20 JAN LOGIS SERV 304832 42975 53656399 OTHER CHARGES SEWER MGMT/REPORTS/DATA ENTRY 9,040.00 LOGIS ANNUAL SYSTEM DEVELOP 304757 43037 10406399 OTHER CHARGES DATAPROCESSING 2,141.00 LOGIS ANNUAL SYSTEM DEVELOP 304757 43037 5005.6399 OTHER CHARGES LIQUOR GENERAL OPERATIONS 71400 LOGIS ANNUAL SYSTEM DEVELOP 304757 43037 5205.6399 OTHER CHARGES ARENA (MANAGEMENT 5,947.00 LOGIS ANNUAL SYSTEM DEVELOP 304757 43037 5305.6399 OTHER CHARGES WATER MGMT/REPORT/DATA ENTRY 5,947.00 LOGIS ANNUAL SYSTEM DEVELOP 304757 43037 5365.6399 OTHER CHARGES SEWER MGMT/REPORTS/DATA ENTRY 57,774.00 11977 224/2017 138249 MINNESOTA ENVIRONMENTAL FUND 37.50 CHARITABLE GIVING 304796 222179282213 90002120 ACCRUED BENEFIT LIABILITY PAYROLL CLEARING HAL SHEET 37.50 11978 224/2017 111219 NORTHERN SAFETY TECHNOLOGY INC 6,224.44 LIGHTBARS 902 304808 43026 7400.1750.048 TRANSPOR EQUIPMNT-4 YRS VERF-POLICE BAL SHEET 6,224.44 11979 2242017 118834 OPENYOURHEARTS 95.20 CHARITABLE GIVING 304794 222179282211 9000.2120 ACCRUED BENEFIT LIABILITY PAYROLL CLEARING HAL SHEET 95.20 11980 2/2420/7 100486 TWIN CITY GARAGE DOOR CO 1,707.60 RPL.SPRINGS SE DOOR SOUTHFORK 304774 476984 1540.6266 REPAIRS-BUILDING CMF BUILDINGS&GROUNDS MNTC 1,707.60 11981 2242017 118830 UHLCOMPANV,INC. 4,222.79 REPAIRS TO HVAC SYSTEMS 304786 49044 1900 6266 REPAIRS-BUILDING AV COMMUNITY CENTER 753.00 HVAC CONTROL PROGRAMMING 304847 49052 1060.6266 REPAIRS-BUILDMG MUNICIPAL BLDG&GROUNDS MNTC 4,975.79 272938 2222017 101588 IST LINE LEWEES VENTURES LLC 420.89 AVSA CONCESSION PRODUCT 304765 124167 52056540 TAXABLE MISC FOR RESALE ARENA I MANAGEMENT 420.89 R55CKR2 LOGISI01 CITY OF APPLE VALLEY 2/22/2017 15:39:36 Council Check Register by GL Page- 3 Council Check Register by Invoice&Summary 1/30/2017 — 227/2017 - Check M Date Amount Supplier/Explanation PO 4 Doc No Inv No Account No Subledger Account Description Business Unit 272939 2/22/2017 144459 ADVANCED IMAGING SOLUTIONS(LEASE) Continued... 8401 LATE PAYMENT CHARGE 304758 323302992 1030.6349 LATE FEES/FINANCE CHARGES INFORMATION TECHNOLOGY 457.89 COPIER LEASE 304758 323302992 1700 6310 RENTAL EXPENSE PARK&RECREATION MANAGEMENT 565.08 COPIER LEASE 304758 323302992 1200.6310 RENTAL EXPENSE POLICE MANAGEMENT 657.16 COPIER LEASE 304758 323302992 1030.6310 RENTAL EXPENSE INFORMATION TECHNOLOGY 1,764.14 272940 2/2220/7 100009 AFSCMECOUNCILk5 1,182.93 UNION DUES 303953 207171500131 9000.2120 ACCRUED BENEFIT LIABILITY PAYROLL CLEARING HAL SHEET 38.78 FAIR SHARE DUES AFSCME 304792 22217928221 9000.2120 ACCRUED BENEFIT LIABILITY PAYROLL CLEARING HAL SHEET 1,144.15 UNION DUES AFSCME 304792 22217928221 9000.2120 ACCRUED BENEFIT LIABILITY PAYROLL CLEARING HAL SHEET 2,365.86 272941 2222017 120949 AIRGAS USA LLC 6875 ACETYLENE UTILITIES 304838 9060210866 5345.6229 GENERAL SUPPLIES WATER EQUIPNEHICLE/MISC MNTC 68.75 272942 2222017 150576 ALL SONS EXTERIORS 2.00 REFUND AV062728-7700145TH 304731 20170213A 10014072 STATE SURTAX COLLECTED GENERAL FUND REVENUE 100.98 REFUND AV062728-7700 145TH 304731 20170213A 1001.4060 PERMIT-BUILDING PERMIT GENERAL FUND REVENUE 102.98 272943 2222017 110903 AMERICAN LEGAL PUBLISHING CORP 495.00 MN ORDINANCE INTERNET RENEWAL 304788 114554 1015.6249 OTHER CONTRACTUAL SERVICES CITY CLERK/ELECTIONS 495.00 272944 2/22/2017 101318 AUTOMATIC SYSTEMS COMPANY 1,394.92 C KNOLLS TRANSDCUER REPLACMENT 304777 307775 5506.6215 EQUIPMENT-PARTS STORM LIFT STN MNTC/RPR 1,394.92 272945 2222017 145004 BARRIS,dODIE 188.00 JANUARY ZUMBA INST,PAYMENT 304737 20170131 1920.6249 OTHER CONTRACTUAL SERVICES SENIOR CENTER 199,00 272946 2/22/2017 100054 BAUERBUILTINC 1,481.16 TIRES FOR CHIEF'S VEHICLES 304773 180203916 1350.6216 VEHICLES-TIRES/BATTERIES FIRE VEHICLE MAINTENANCE 447.74 #419 TIRES 304772 180206244 5345.6216 VEHICLES-TIRES/BATTERIES WATER EQUIPNEHICLEMIISC MNTC 1,928.90 272947 222/2017 100683 BEACONATHLETICS 1,531.00 BALLFIELDTOOLS 304759 4706591N 1715.6211 SMALL TOOLS&EQUIPMENT PARK ATHLETIC FIELD MAINTENANC R55CKR2 LOGIS101 CITY OF APPLE VALLEY 2/222017 15:39:36 Council Check Register by GL Page- 4 Council Check Register by Invoice&Summary 1/30/2017 -- 2/27/2017 Check# Date Amount Supplier/Explanation PON Doc No Inv No Account No Subledger Account Description Business Unit 272947 2/22/2017 100683 BEACONATHLETICS Continued... 1,531.00 272948 2/2220/7 144003 BERNSTEIN,BARRY 131.60 JAN MILEAGE-BERNSTEIN 304724 20170205 1700.6277 MILEAGE/AUTO ALLOWANCE PARK&RECREATION MANAGEMENT 131.60 272949 2222017 100089 CARQUEST 5241 OIL QTS MOWERS 304839 1594285282 17656212 MOTOR FUELS/OILS PARK EQUIPMENT MAINTENANCE 16.80 347 FILTER 304835 1594285488 1630.6215 EQUIPMENT-PARTS STREET EQUIPMENT MAINTENANCE 132.56 PTS FOR UNITS 256&272 304809 1594285490 17656215 EQUIPMENT-PARTS PARK EQUIPMENT MAINTENANCE 31.98 PTS FOR UNITS 256&272 304810 1594285492 17656215 EQUIPMENT-PARTS PARK EQUIPMENT MAINTENANCE T56 340 DASH LIGHTS 304836 1594285589 1630.6215 EQUIPMENT-PARTS STREET EQUIPMENT MAINTENANCE 241,31 272950 2222017 100878 CHARTER COMMUNICATIONS 84.64 CABLE TV-FEB 304714 835230604052429 5110.6237 TELEPHONE/PAGERS GOLF CLUBHOUSE BUILDING 8FEB17 429.29 GOLF WIFI MONTHLY FEE-FEB 304766 835230604053823 51106237 TELEPHONE/PAGERS GOLF CLUBHOUSE BUILDING IFEB17 400.74 GOLF WIFI MONTHLY FEE-FEB 304767 835230604053824 5110.6237 TELEPHONE/PAGERS GOLF CLUBHOUSE BUILDING 9FEB17 914.67 272951 2/2220/7 150038 COLDSPRING GRANITE COMPANY 22,560.50 COLUMBARIA PORCH PMT#3 FINAL 304763 1050559 5605.6740 201617OG CAPITAL OUTLAY-MACH/EQ/OTHER CEMETERY 22,560.50 272952 2/22/2017 101431 COMMUNITY HEALTH CHARITIES 108.89 CHARITABLE GIVING 304807 22217928229 9000.2120 ACCRUED BENEFIT LIABILITY PAYROLL CLEARING BAL SHEET 108.89 272953 2/22/2017 122019 CROWN RENTAL-BURNSVILLE 36.74 FORWEEDTRIMMERS 304811 2388155 1765.6215 EQUIPMENT-PARTS PARK EQUIPMENT MAINTENANCE 36.74 272954 2/222017 100129 DAKOTAAWARDS&ENGRAVING 102.00 PARTAGS 304718 16579 1330.6229 GENERAL SUPPLIES FIRE OPERATIONS 102.00 272955 2/22201' 100128 DAKOTA ELECTRIC ASSOCIATION R55CKR2 LOGIS 101 CITY OF APPLE VALLEY 2/222017 15,39 36 Council Check Register by GL Page- 5 Council Check Register by Invoice&Summary 1/30/2017 -- 2/27/2017 Check N Data Amount Supplier/Explanation PO 9 Doc No Inv No Account No Subledger Account Description Business Unit 272955 2/222017 100128 DAKOTA ELECTRIC ASSOCIATION Continued... 376.15 VALLEYWOOD MAINT BLDG 304752 211924 5145.6255 UTILITIES-ELECTRIC GOLF SHOP BUILDING MAINTENANCE 1,693.14 VALLEYWOOD CLUBHOUSE 304752 211924 5110.6255 UTILITIES-ELECTRIC GOLF CLUBHOUSE BUILDING 108.12 VALLEYWOOD RESERVOIR 304752 211924 5320.6255 UTILITIES-ELECTRIC WATER WELLBOOSTER STN MNT/RPR 164.96 QUARRY POINT WATER TOWER 304752 211924 53206255 UTILITIES-ELECTRIC WATER WELLBOOSTER STN MNT/RPR 22.85 158TH/DIAMOND PATH MOONLIGHT 304752 211924 58056545 NON-TAXABLE MISC FOR RESALE STREET LIGHT UTILITY FUND 63.87 COBBLESTONE LK PKWY LTS 304752 211924 5805 6545 NON-TAXABLE MISC FOR RESALE STREET LIGHT UTILITY FUND 7125 COBBLESTONE PK PKWY LTS 304752 211924 5805.6545 NON-TAXABLE MISC FOR RESALE STREET LIGHT UTILITY FUND 74.34 15761 COBBLESTONE LK PKWY LTS 304752 211924 5805.6545 NON-TAXABLE MISC FOR RESALE STREET LIGHT UTILITY FUND 81.59 15750 DIAMOND WAY LIGHTS 304752 211924 5805.6545 NON-TAXABLE MISC FOR RESALE STREET LIGHT UTILITY FUND 100.03 15850 DRAWSTONE TRL LIGHTS 304752 211924 5805.6545 NON-TAXABLE MISC FOR RESALE STREET LIGHT UTILITY FUND 55931 15298153RD STREET LIGHT 304752 211924 5805.6545 NON-TAXABLE MISC FOR RESALE STREET LIGHT UTILITY FUND 3,315.61 272956 122/2017 147049 DORN,GEORGE 36.38 FEB MILEAGE-DORN 304741 20170211 1400.6277 MILEAGE/AUTO ALLOWANCE INSPECTIONS MANAGEMENT 36.38 272957 2/2220/7 /00989 DRIVERS.LICENSE GUIDE CO 20.95 ID GUIDE 304725 703650 5025.6280 DUES&SUBSCRIPTIONS LIQUOR k1 OPERATIONS 20.95 ID GUIDE 304725 703650 5065.6280 DUES&SUBSCRIPTIONS LIQUOR 42 OPERATIONS 20.95 ID GUIDE 304725 703650 5095.6280 DUES&SUBSCRIPTIONS LIQUOR 43 OPERATIONS 62.85 272958 2/222017 120698 DURAND MANUFACTURING 150.00 MACHINE SWEEPER HUBS 304742 26027 1630.6215 EQUIPMENT-PARTS STREET EQUIPMENT MAINTENANCE 150.00 272959 222/20/7 145240 ECOLAR PEST FLIM DIV 69.63 ST MARYS MONTHLY PEST CONTROL 304728 9199821 20926249 OTHER CONTRACTUAL SERVICES 14200 CEDAR AVE-OLD CITY HALL 69.63 272960 222/2017 145163 EMERGENCY RESPONSE SOLUTIONS 10,330.05 FIREFIGHTING HOODS(BARRIER) 304761 7945 7611.6281 UNIFORM/CLOTHING ALLOWANCE FIRE GRANTS-GENERAL 10,330.05 272%1 222/20/7 100157 FACTORY MOTOR PARTS CO 7,400.00 BOSCH ESI 3824 HD SCAN TOOL 304771 15176761 1530.6211 SMALL TOOLS&EQUIPMENT FLEET&BUILDINGS-CMF 23.93 907 VALVE 304834 75249904 1210.6215 EQUIPMENT-PARTS POLICE FIELD OPERATIONS/PATROL 17.28 BULBS 304775 75250183 1210.6215 EQUIPMENT-PARTS POLICE FIELD OPERATIONS/PATROL 198.75 HYD.HOSE 304775 75250183 1765 6215 EQUIPMENT-PARTS PARK EQUIPMENT MAINTENANCE R55CKR2 LOGISI01 CITY OF APPLE VALLEY 2/22/2017 15:39:36 Council Check Register by GL Page- 6 Council Check Register by Invoice&Summary 1/3012017 -- 2/27/2017 Check# Date Amount Supplier/Explanation PON Doc No Inv No Account No Subledger Account Description Business Unit 272961 2/22/2017 100157 FACTORY MOTOR PARTS CO Continued... 39970 BULBS&HYD.HOSE 304775 75250/83 1630.6215 EQUIPMENT-PARTS STREET EQUIPMENT MAINTENANCE 19875 HYD.HOSE 304775 75250/83 5390.6215 EQUIPMENT-PARTS SWR EQUIP/VEHICLE MISC MNTC/RP 8,238.41 272962 2222017 120313 FASTENALCOMPANY 246.33 RESTOCK BOLTS FOR SHOP 304736 MNLAK139779 1610 6229 GENERAL SUPPLIES STREET/BOULEVARD REPAIR&MNTC 246.33 272963 2222017 100282 G&KSERVICES 2.22- LIQ3 USE TAX 304755 1182340120 5000.2330 DUE TO OTHER GOVERNMENT LIQUOR BALANCE SHEET 2.22 LIQ3 USE TAX 304755 1/82340120 5095.6240 CLEANING SERVICE/GARBAGE REMOV LIQUOR#3 OPERATIONS 32.28 MATS&MOP HEADS 304755 1182340120 50956240 CLEANING SERVICE/GARBAGE REMOV LIQUOR#3 OPERATIONS 32.28 272964 2222017 100206 GOODWiN,THOMASC 15228 JULY-DEC MILEAGE-GOODWIN 304756 20161214 10056277 MILEAGE/AUTO ALLOWANCE MAYOR/CITY COUNCIL 15228 272%5 2222017 100216 GRAFLX SHOPPE 415.00 4992 GRAPHICS NEW VEHICLE 304779 112781 13506265 REPAIRS-EQUIPMENT FIRE VEHICLE MAINTENANCE 415.00 272966 222/2017 100510 HD SUPPLY WATERWORKS LTD 524.37 METER FOR RESALE. CONTRACT 304825 G385960 5310.6540 TAXABLE MISC FOR RESALE WATER METER RPR/REPLACE/READNG 804.96 CHERNE BALL PARTS 304776 G700435 5375.6211 SMALL TOOLS&EQUIPMENT SEWER MAINTENANCE AND REPAIR 1,329.33 272967 2/222017 137419 HEDBERG,RON 1.00 EXP'D JUICE IN VENDING MACHINE 304726 20161213 1001.5320 POP MACHINE CITY HALL GENERAL FUND REVENUE 1.00 272968 2/22/2017 101105 HPINC 7,932.60 WORKSTATIONS(12) 304781 58147489 1030.6725 CAPITAL OUTLAY-OFFICE EQUIP INFORMATION TECHNOLOGY 7,932.60 272969 2/22/2017 116698 INSIGHT PUBLIC SECTOR 661.72 COMPUTER MONITORS(4) 304782 1100517756 15006211 SMALL TOOLS&EQUIPMENT PW MANAGEMENT 992.58 COMPUTER MONITORS(6) 304782 1100517756 1400.6725 CAPITAL OUTLAY-OFFICE EQUIP INSPECTIONS MANAGEMENT 1,654.30 R55CKR2 LOGISI01 CITY OF APPLE VALLEY 2/22/2017 15:39;36 Council Check Register by GL Page- 7 Council Check Register by Invoice&Summery 1/30/2017 -- 2272017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No Account No Subledger Account Description Business Unit 272970 222/2017 150577 JESSE TREBIL FOUNDATION SYSTEMS Continued... 1.00 REFUND AV062965 304732 20170213B 1001 4072 STATE SURTAX COLLECTED GENERAL FUND REVENUE 70.95 REFUNDAV062965 304732 201702/38 1001.4060 PERMIT-BUILDING PERMIT GENERAL FUND REVENUE 71.95 272971 21222017 145176 KIESLER'S POLICE SUPPLY INC 472.00 FORCE ON FORCE AMMO-BLANK 304812 818849 1210,6229 GENERAL SUPPLIES POLICE FIELD OPERATIONS/PATROL 472.00 272972 222/20/7 132646 KWIK KOPY BUSINESS CENTER 4.60- CABLE SALES TAX ADJUST 304721 20724 2012.6239 PRINTING CABLETV JOINTPOWERS 4.60 CABLE SALES TAX ADJUST 304721 20724 20102330 DUE TO OTHER GOVERNMENT CABLE TV RESERVE BALANCE SHEET 69,10 BUSINESS CARDS-KLAUSLER 304721 20724 2012.6239 PRINTING CABLE TV JOINT POWERS 314.86 2017 STATUTE GUIDE 304749 20757 1200.6239 PRINTING POLICE MANAGEMENT 383.96 272973 2/22/2017 101616 LMC INSURANCE TRUST 745.34 WC DED WILLIAMS FEB 2017 304768 20170201 7205.6315 WORKERS COMP-DEDUCTIBLE INSURANCE CLAIMS 842.25 WC DED REINER FEB 2017 304768 20170201 7205.6315 WORKERS COMP-DEDUCTIBLE INSURANCE CLAIMS 1,647.30 WC DED REILLY FEB 2017 304768 20170201 72056315 WORKERS COMP-DEDUCTIBLE INSURANCE CLAIMS 3,157.49 WC DED MCWILLIAMS FEB 2017 304768 20170201 7205.6315 WORKERS COMP-DEDUCTIBLE INSURANCE CLAIMS 6,392.38 272974 2222017 116371 LOFFLER COMPANIES INC(CONT INV) 708.52 COPIER MAINT 304783 2446996 1030.6265 REPAIRS-EQUIPMENT INFORMATION TECHNOLOGY 26,25 COPIER MAINT. 304723 2448190 1900.6265 REPAIRS-EQUIPMENT AV COMMUNITY CENTER 197.40 COPIER MAINT. 304722 2448191 1500.6265 REPAIRS-EQUIPMENT PW MANAGEMENT 932.17 272975 22212017 100565 MACTA 1,840.00 MACTA MEMBERSHIP DUES 304780 300000153 2012.6280 DUES&SUBSCRIPTIONS CABLETV JOINTPOWERS 840.00 272976 22212017 100309 MENARDS 399 PAN 304740 12625A 53256229 GENERAL SUPPLIES WATER TREATMENT FCLTY MNTC/RPR 42.63 SHOP SUPPLIES 304743 12644 16306229 GENERAL SUPPLIES STREET EQUIPMENT MAINTENANCE 32.32 UTILITY MAT 304713 12648 5265.6229 GENERAL SUPPLIES ARENA2 BLDG MAINTENANCE-HAVES 66.52 NORDIC PIPE LEAKING ON COOLING 304844 12861 5320 6229 GENERAL SUPPLIES WATER WELL/BOOSTER STN MNT/RPR 145.46 272977 2/22/2017 100849 METRO VOLLEYBALL OFFICIALS ASSN R55CKR2 LOGIS101 CITY OF APPLE VALLEY 2/22/2017 15:39:36 Council Check Register by GL Page- 8 Council Check Register by Invoice&Summary 1/30/2017 -- 2/27/2017 Check k Date Amount Supplier/Explanation PO k Doc No Inv No Account No Subledger Account Description Business Unit 272977 2/22/2017 100849 METRO VOLLEYBALL OFFICIALS ASSN Continued... 2,368.00 MWF VB OFFICIALS 304764 5114 1860.6235 CONSULTANT SERVICES REC VOLLEYBALL 2,36800 272978 2/22/2017 101734 MEYER,JAMES 131.72 JAN/FEB MILEAGE-MEYER 304733 201702/0 14006277 MILEAGE/AUTO ALLOWANCE INSPECTIONS MANAGEMENT 131.72 272979 2222017 141669 MIDWEST ELECTRICALTECHNOLOGIES,INC. 33,114.70 ELECTRICAL INSPECTION FEES 304751 20170213A 1445.6243 ELECTRICAL PERMIT FEES INSPECTIONS ELECTRICAL 33,114.70 272980 2222017 118973 MIKE'S SHOE REPAIR INC 85.00 REPAIR TO TURNOUT GEAR 304719 2082017 1330.6265 REPAIRS-EQUIPMENT - FIRE OPERATIONS 85.00 272981 2/222017 147490 MINNESOTA PUMPWORKS 1920.00 LIFT 9 REPLACE DISCHARGE VALVE 304770 10309 5380.6265 REPAIRS-EQUIPMENT SEWER LIFT STN REPAIR&MNTC 112,D6 SUMP PUMP RBLD PARTS 304829 10424 5375.6215 EQUIPMENT-PARTS SEWER MAINTENANCE AND REPAIR 1,124.64 PUMP OUT PRESSURE RED STA OR M 304790 10458 5320.6211 SMALL TOOLS&EQUIPMENT WATER WELLBOOSTERSTN MNT/RPR 3,156.70 272982 222/2017 100334 MNDEPTOFHEALTH 150.00 MDH PERMIT REVIEW 304824 20170221 45026399 2017104G OTHER CHARGES IMPROVEMENTS-ASSESSED 150.00 172983 2222017 114229 MNDEPTOFTRANSPORTATION 363.46 MATERIALS TESTING 304754 P00007741 2027.6249 2015103G OTHER CONTRACTUAL SERVICES ROAD ESCROW 363.46 272984 2222017 123322 MNFIAMBOOKSALES 60.00 FIRE LIFE SAFETY EDUC BOOK 304717 2374 1310.6275 SCHOOLS/CONFERENCES/EXP LOCAL FIRETRAINING 60.00 272985 2222017 128699 MUNICIPAL EMERGENCY SERVICES 379.51 FIREFIGHTING BOOTS 304720 IN1104604 1330.6281 UNIFORM/CLOTHING ALLOWANCE FIRE OPERATIONS 37%51 272986 2/22/2017 100995 NAPAAUTOPARTS 11,98 FOUR CYCLE FUEL SMALL ENGINES 304716 672676 1330 6212 MOTOR FUELS/OILS FIRE OPERATIONS 1198 R55CKR2 LOGISI01 CITY OF APPLE VALLEY 2/222017 1539:36 Council Check Register by GL Page- 9 Council Check Register by Invoice&Summary 1/302017 -- 227/2017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No Account No Subledger Account Description Business Unit 272986 2/22/2017 100995 NAPAAUTOPARTS Continued... 272987 2/22/2017 100704 NOKOMIS SHOE SHOP 129.95 INSPBOOTS-DEVERY 304843 669905 14006281 UNIFORM/CLOTHING ALLOWANCE INSPECTIONS MANAGEMENT 129.95 272988 222/2017 126254 ODD COMPANY 1,752.20 PARTS FOR ALL 4 SWEEPERS 304791 101260IN 1630.6215 EQUIPMENT-PARTS STREET EQUIPMENT MAINTENANCE 1,752.20 272989 222/2017 114590 OPG-3 INC(FORMERLYCRABTREE COMPANIES) 37,072.36 SOFTWARE LICENSING 304784 1227C 1400.6399 OTHER CHARGES INSPECTIONS MANAGEMENT 37,072.36 272990 2222017 143908 OWL ENGINEERING&EMC TEST LABS,INC. 6,500.00 CHRIST CHURCH CELL TOWER 304846 3625 4502.6235 20161770 CONSULTANT SERVICES IMPROVEMENTS-ASSESSED 6,500.00 MT OLIVET CELL TOWER 304845 3626 4502.6235 2016176G CONSULTANT SERVICES IMPROVEMENTS-ASSESSED 13,OO(TOD 272991 2/22/2017 100374 PEPSI-COLA COMPANY 351.67 VENDING MACHINE-POP 304753 24559865 1540.6540 TAXABLE MISC FOR RESALE CMF BUILDINGS&GROUNDS MNTC 351.67 272992 2222017 148951 PERFORMANCE PLUS LLC 27.00 RESPIRATOR MASK 304730 4581LF 1200.6229 GENERAL SUPPLIES POLICE MANAGEMENT 27,00 272993 2/22/2017 147437 PRECISION LANDSCAPE AND TREE INC 7,995.00 ASH REMOVAL 2017-120 304789 6307 1520.6249 201712OG OTHER CONTRACTUAL SERVICES NATURAL RESOURCES 7,995.00 272994 222/2017 122110 REINDERS INC 1,068.0) LIMESTONE FOR TURF 304760 304413900 1720.6213 FERTILIZER PARK GROUNDS MAINTENANCE 1,068.0D 272995 2222017 147110 RITE 553.62 POSMAINTAGMT 304785 5109 5065.6265 REPAIRS-EQUIPMENT LIQUOR 02 OPERATIONS 1,107.20 POSMAINTAGMT 304785 5109 5095.6265 REPAIRS-EQUIPMENT LIQUOR#3 OPERATIONS 1,107.24 POSMAINTAGMT 304785 5109 5025.6265 REPAIRS-EQUIPMENT LIQUOR#1 OPERATIONS 2,768.06 R55CKR2 LOGISI01 CITY OF APPLE VALLEY 2/22/2017 15:39:36 Council Check Register by GL Page- 10 Council Check Register by Invoice&Summary 1/30/2017 -- 2/27/2017 Check N Date Amount Supplier/Explanation PON Doc No Inv No Account No Subledger Account Description Business Unit 272996 2/222017 100165 RIVER COUNTRY COOPERATIVE Continued... 81.98- GOLF USE TAX 304787 12155 5100.2330 DUE TO OTHER GOVERNMENT GOLF FUND BALANCE SHEET 81.98 GOLF USE TAX 304787 12155 51456257 UTILITIES-PROPANDWATER/SEWER GOLF SHOP BUILDING MAINTENANCE 1,192.45 PROPANE FOR MAINTENANCE 304787 12155 5145.6257 UTILITIES-PROPANE/WATER/SEWER GOLF SHOP BUILDING MAINTENANCE 3.85- CEMETERY SALES TAX ADJUST 304746 201612150113 5605.6257 UTILITIES.PROPANE/WATER/SEWER CEMETERY 3.85 CEMETERY SALES TAX ADJUST 304746 201612150113 5600.2330 DUE TO OTHER GOVERNMENT CEMETERY BALANCE SHEET 57.83 LP FOR THAWING GROUND 304746 201612150113 56056257 UTILITIES-PROPANE/WATER/SEWER CEMETERY 57.83 LP FOR THAWING GROUND 304745 201701040104 56056257 UTILITIES-PROPANE/WATER/SEWER CEMETERY 2.42- CEMETERY SALES TAX ADJUST 304748 201701060900 5605.6257 UTILITIES-PROPANE/WATER/SEWER CEMETERY 2.42 CEMETERY SALES TAX ADJUST 304748 201701060900 5600.2330 DUE TO OTHER GOVERNMENT CEMETERY BALANCE SHEET 36.40 LP FOR THAWING GROUND 304748 201701060900 56056257 UTILITIES-PROPANE/WATER/SEWER CEMETERY 1.21- CEMETERY SALES TAX ADJUST 304747 201701061054 5605.6257 UTILITIES-PROPANE/WATER/SEWER CEMETERY 1.21 CEMETERY SALES TAX ADJUST 304747 201701061054 5600.2330 DUE TO OTHER GOVERNMENT CEMETERY BALANCE SHEET 18.20 LP FOR THAWING GROUND 304747 201701061054 5605.6257 UTILITIES-PROPANE/WATER/SEWER CEMETERY 18.20 20N PROPANE TANK FILL. 304739 201701100125 5330.6212 MOTOR FUELS/OILS WTR MAIN/HYDRANT/CURB STOP MNT 1,380.91 272997 222/2017 100042 ROTARY CLUB OFAPPLE VALLEY 60.00 ROTARY DUES NORDQUIST IST QTR 304750 1381 11011.6280 DUES&SUBSCRIPTIONS DEV MANAGEMENT 162.50 ROTARY MEALS NORDQUIST I ST QTR 304750 1381 11006275 SCHOOLS/CONFERENCES/EXP LOCAL DEV MANAGEMENT 222.50 272998 222/20/7 142329 SMITH MANUFACTURING CO INC 17.56 REPLC NUT FOR GRINDER 304734 71330 1630.6211 SMALL TOOLS&EQUIPMENT STREET EQUIPMENT MAINTENANCE 17.56 272999 222/2017 100447 SOUTH RIVER HEATING&COOLING INC 262.50 ST MARYS WEEKLY BOILER CK-2/6 304727 1717444 20926266 REPAIRS-BUILDING 14200 CEDAR AVE-OLD CITY HALL 262.50 273000 2222017 121897 TERMINAL SUPPLY CO 78.46 ELECT SUPPLIES SOD 304833 8707200 1210.6215 EQUIPMENT-PARTS POLICE FIELD OPERATIONS/PATROL 78.46 273001 222/2017 101342 THOMSON REUTERS-WEST 141.75 WEST CHARGES-JAN 304831 835556484 1215.6249 OTHER CONTRACTUAL SERVICES POLICE DETECTIVE UNIT 141.75 273002 2/2220/7 100489 UNIFORMS UNLIMITED 99.90 COF INSTRUCTOR SHIRTS 304738 562851 1200.6281 UNIFORM/CLOTHING ALLOWANCE POLICE MANAGEMENT 99.90 R55CKR2 LOGISI01 CITY OF APPLE VALLEY 2/22/2017 15:39:36 Council Check Register by GL Page- II Council Check Register by Invoice&Summary 1/30/2017 -- 2/27/2017 CheckDate Amount Supplier/Explanation PO k Doc No Inv No Account No Subledger Account Dcuription Business Unit 273002 2/22/2017 100489 UNIFORMS UNLIMITED Continued... 273003 2/22/2017 101123 USABLUEBOOK 220.38 HYDRANT BACKFLOW PREVENTER. 304828 175131 5330.6215 EQUIPMENT-PARTS WTR MAIN/HYDRANT/CURE STOP MINT 22038 273004 2/222017 123538 VARITECH INDUSTRIES INC 145.34 301 BRINE VAVLE 304837 IN0601009833 1630.6215 EQUIPMENT-PARTS STREET EQUIPMENT MAINTENANCE 145.34 273005 222/2017 100631 VERIZONWIRELESS 37.49 GEORGE PHONE CASE 304841 52522/4001 1400.6211 SMALL TOOLS&EQUIPMENT INSPECTIONS MANAGEMENT 11.24 UTILITIES ON CALL CAR CHARGER 304842 5259348001 5365.6211 SMALL TOOLS&EQUIPMENT SEWER MGMT/REPORTS/DATA ENTRY 11.25 UTILITIES ON CALL CAR CHARGER 304842 5259348001 5305.6211 SMALL TOOLS&EQUIPMENT WATER MGMT/REPORT/DATA ENTRY 3,086.54 MONTHLY CELL PHONE BILL 304762 9779653198 12006237 TELEPHONE/PAGERS POLICE MANAGEMENT 4001 SIR WIRELESS DATA FEB 304729 9779822367 1600.6237 TELEPHONE/PAGERS STREET MANAGEMENT 4001 IT WIRELESS DATA FEB 304729 9779822367 10306237 TELEPHONE/PAGERS INFORMATION TECHNOLOGY 4001 PK WIRELESS DATA FEB 304729 9779822367 1710.6237 TELEPHONE/PAGERS PARK MAINTENANCE MANAGEMENT 50.66 PW CELL PHONE FEB 304729 9779822367 1500.6237 TELEPHONE/PAGERS PW MANAGEMENT 101.32 ADM CELL PHONE FEB 304729 9779822367 1010.6237 TELEPHONE/PAGERS ADMINISTRATION 101.32 CODE CELL PHONE FEB 304729 9779822367 1013.6237 TELEPHONE/PAGERS CODE ENFORCEMENT 107.68 SIR CELL PHONE FEB 304729 9779822367 1600.6237 TELEPHONE/PAGERS STREET MANAGEMENT 107.78 NR CELL PHONE FEB 304729 9779822367 1520.6237 TELEPHONE/PAGERS NATURAL RESOURCES 149.97 PK CELL PHONE FEB 304729 9779822367 1710.6237 TELEPHONE/PAGERS PARK MAINTENANCE MANAGEMENT 160.04 INSPWIRELESS DATAFEB 304729 9779822367 1400.6237 TELEPHONE/PAGERS INSPECTIONS MANAGEMENT 214.60 ENG CELL PHONE FEB 304729 9779822367 15186237 TELEPHONE/PAGERS PW ENGINEERING&TECHNICAL 226.74 IT CELL PHONE FEB 304729 9779822367 1030.6237 TELEPHONE/PAGERS INFORMATION TECHNOLOGY 270.17 REC CELL PHONE FEB 304729 9779822367 1700.6237 TELEPHONE/PAGERS PARK&RECREATION MANAGEMENT 312.48 INSP CELL PHONE FEB 304729 9779822367 14006237 TELEPHONE/PAGERS INSPECTIONS MANAGEMENT 520.13 FIRE WIRELESS DATA FEB 304729 9779822367 1330.6237 TELEPHONE/PAGERS FIRE OPERATIONS 1,437.86 POL WIRELESS DATA FEB 304729 9779822367 12056237 TELEPHONE/PAGERS POLICE RECORDS UNIT 3628- CABLE CELL PHONE FEB 304729 9779822367 2012.6237 TELEPHONE/PAGERS CABLE TV JOINT POWERS 4001 GOLF WIRELESS DATA FEB 304729 9779822367 51056237 TELEPHONE/PAGERS GOLFMANAGEMENT 219.00 GOLF CELL PHONE FEB 304729 9779822367 5105.6237 TELEPHONE/PAGERS GOLF MANAGEMENT 25.33 UTIL ON-CALL CELL PHONE FEB 304729 9779822367 5305.6237 TELEPHONE/PAGERS WATER MGMT/REPORT/DATA ENTRY 25.33 UTIL ON-CALL CELL PHONE FEB 304729 9779822367 53656237 TELEPHONE/PAGERS SEWER MGMT/REPORTS/DATA ENTRY 200.05 UTIL WIRELESS DATA FEB 304729 9779822367 5305.6237 TELEPHONE/PAGERS WATER MGMT/REPORT/DATA ENTRY 242.88 UTIL CELL PHONE FEB 304729 9779822367 5305.6237 TELEPHONE/PAGERS WATER MGMT/REPORT/DATA ENTRY 7,74L62 273006 2222017 100529 ZIEGLER INC R55CKR2 LOGISI01 CITY OF APPLE VALLEY 2/222017 15.39:36 Council Check Register by GL Page- 12 Council Check Register by Invoice&Summary 1/30/2017 -- 2/27/2017 Check M Date Amount Supplier/Explanation POM Doc No Inv No Account No Subledger Account Description Business Unit 273006 2/22/2017 100528 ZIEGLER INC Confinued... 520.99 WELL S N GAS ENGINE 304778 SWO50271063 5320.6265 REPAIRS-EQUIPMENT WATER WELLBOOSTER STN MNT/RPR 520.99 20170156 1/30/2017 120679 USBANKPCARD 15363 10 HATS FOR FIREFIGHTERS 303825 240133970120016 13306281 UNIFORM/CLOTHING ALLOWANCE FIRE OPERATIONS 79141910 Supplier 137957 AMARIL UNIFORM COMPANY(PCARD) 287.50 50%PAYMENT FOR MWF JUMPERS 303823 240133970190026 1845 6249 OTHER CONTRACTUAL SERVICES REC SELF SUPPORT PROD GENERAL 54002617 Supplier 150377 FUN JUMPS ENTERTAINMENT(PCARD) 85.00 2017 DUES-FRANCIS 303803 240731470139000 1200.6280 DUES&SUBSCRIPTIONS POLICE MANAGEMENT 14745084 85.00 2017 FBINNA DUES-RECHTZIGEL 303804 240731470139000 1200.6280 DUES&SUBSCRIPTIONS POLICE MANAGEMENT /4747700 Supplier 148074 FBI NATLACADEMY ASSOC(PCARD) 22.20 SMALL EQUIPMENT FUEL 304213 241640770066910 5345.6212 MOTOR FUELS/OILS WATER EQUIPNEHICLEMIISC MNTC 06361190 Supplier 103023 KWIK TRIP INC(PCARD) 92- IA I SALES TAX ADJUST 303816 241640770120910 52056229 GENERAL SUPPLIES ARENA IMANAGEMENT 17106977 92 TAI SALES TAX ADJUST 303816 241640770120910 52002330 DUE TO OTHER GOVERNMENT ARENA FUND BALANCE SHEET 17106977 17.18 LTS SUPPLIES 303816 241640770120910 52056229 GENERAL SUPPLIES ARENA 1 MANAGEMENT 17106977 Supplier 100463 TARGET STORES(PCARD) 10.75 FLASHLIGHTS FOR REPAIR 303939 241640770167412 1210.6238 POSTAGENPS/FEDEX POLICE FIELD OPERATIONS/PATROL 07226466 Supplier 143773 FEDEX OFFICE(PCARD) .I0. POL SALES TAX ADJUST 303933 241640770183470 1200.6275 SCHOOLS/CONFERENCES/EXP LOCAL POLICE MANAGEMENT 01947352 10 POL SALES TAX ADJUST 303933 241640770183470 1000.2330 DUE TO OTHER GOVERNMENT GENERAL FUND BALANCE SHEET 01947352 40.64 ETD SCENARIO DAY-LUNCH 303933 241640770183470 12006275 SCHOOLS/CONFERENCES/EXP LOCAL POLICE MANAGEMENT 01947352 Supplier 130667 PILOT(PCARD) .52- HR SALES TAX ADJUST 303940 242244370121010 10206399 OTHER CHARGES HUMAN RESOURCES 55741389 .52 HR SALES TAX ADJUST 303940 242244370121010 1000.2330 DUE TO OTHER GOVERNMENT GENERAL FUND BALANCE SHEET 55741389 222.55 MEAT FOR SAFETY KICKOFF EVENT 303940 242244370121010 1020.6399 OTHER CHARGES HUMAN RESOI R55CKR2 LOGISI01 CITY OF APPLE VALLEY 2/22/2017 15:39:36 Council Check Register by GL Page- 13 Council Check Register by Invoice&Summary 1/30/2017 -- 2/27/2017 Check X Date Amount Supplier/Explanation PO N Doc No Inv No Account No Subledger Account Description Business Unit 20170/56 1/30/2017 120679 USBANKPCARD Continued... 55741389 Supplier 149661 HY VEE(PCARD) 9.99 FLASHLIGHT BATTERIES 303799 242244370121040 2012.6215 EQUIPMENT-PARTS CABLE TV JOINT POWERS 08987265 Supplier 148066 BATTERIES PLUS BULBS(PCARD) 11.44 AVSA CONCESSION PRODUCT 303817 242263870130910 5205.6540 TAXABLE MISC FOR RESALE ARENA (MANAGEMENT 01493504 1.19- IAI SALES TAX ADJUST 304446 242263870190910 5260.6229 GENERAL SUPPLIES ARENA 2 MANAGEMENT-HAYES 03300487 1.19 IAI SALES TAX ADJUST 304446 242263870190910 5200.2330 DUE TO OTHER GOVERNMENT ARENA FUND BALANCE SHEET 03300487 10.56 AVSA CONCESSION PRODUCT 304446 242263870190910 52056540 TAXABLE MISC FOR RESALE ARENA IMANAGEMENT 03300487 1787 HAYES SUPPLIES 304446 242263870190910 5260.6229 GENERAL SUPPLIES ARENA 2 MANAGEMENT-HAYES 03300487 Supplier 102101 WAL-MART(PCARD) 66.85 LIZ-JACKET 303813 242476070145006 52056281 UNIFORNVCLOTHING ALLOWANCE ARENA I MANAGEMENT 72626627 Supplier 150538 MAIN EVENT MERCHANDISE(PCARD) 2.85- UTIL SALES TAX ADJUST 304216 243990070102950 53256211 SMALL TOOLS&EQUIPMENT WATER TREATMENT FCLTY MNTC/RPR 02034377 2.85 UTIL SALES TAX ADJUST 304216 243990070102950 5300.2330 DUE TO OTHER GOVERNMENT WATER&SEWER FUND BAL SHEET 02034377 42.84 WTP PHONE PROTECTOR 304216 243990070102950 5325.6211 SMALL TOOLS&EQUIPMENT WATER TREATMENT FCLTY MNTC/RPR 02034377 Supplier 113057 BESTBUY(PCARD) 20.57 BREAKFAST FOR INV-17000302 303932 244273370147200 1200.6229 GENERAL SUPPLIES POLICE MANAGEMENT 080/2377 Supplier 110472 PANERA BREAD(PCARD) 45.48 FOOD FOR PLOW DRIVERS 303822 244273370177200 1665.6229 GENERAL SUPPLIES STREET SNOW&ICE MATERIALS 14002435 Supplier 148071 CUB FOODS(PCARD) .41- GOLF SALES TAX ADJUST 303795 244310570179318 5145.6211 SMALL TOOLS&EQUIPMENT GOLF SHOP BUILDING MAINTENANCE 02815486 .41 GOLF SALES TAX ADJUST 303795 244310570179318 5100.2330 DUE TO OTHER GOVERNMENT GOLF FUND BALANCE SHEET 02815486 85.88 WORK LIGHTS 303795 244310570179318 51456211 SMALL TOOLS&EQUIPMENT GOLF SHOP BUILDING MAINTENANCE 02815486 Supplier 148128 NAPA PRIOR LAKE(PCARD) R55CKR2 LOGISI01 CITY OF APPLE VALLEY 2/22/2017 15:39:36 Council Check Register by GL Page- 14 Council Check Register by Invoice&Summary 1/30/2017 -- 2/27/2017 Check k Data Amount Supplier/Explanation Pop Doc No Inv No Account No Subledger Account Description Business Unit 20170156 1/30/2017 120679 U S BANK P CARD Continued... 200.00 M/NPELRA 2017 DUES-HAAS 303801 244310670090140 1020.6280 DUES&SUBSCRIPTIONS HUMAN RESOURCES 00542555 Supplier 150539 NATL PUBLIC EMPL(PCARD) 19.31 LUNCH-DAHLSTROMHINKLE RANGE 303938 244310670128380 1210.6275 SCHOOLS/CONFERENCES/EXP LOCAL POLICE FIELD OPERATIONS/PATROL 00040631 Supplier 149664 PANDA EXPRESS(PCARD) 234.31 CONFERENCE ROOM PERIPHERALS 303809 244310670190833 1030.6211 SMALL TOOLS&EQUIPMENT INFORMATION TECHNOLOGY 07550064 Supplier 140339 AMAZON.COM(PCARD) 42.98 RECIRC LINE WTP 304444 244351470120040 5325.6229 GENERAL SUPPLIES WATER TREATMENT FCLTY MNTC/RPR 00090649 2.66- UTIL SALES TAX ADJUST 304221 244351470130040 5325.6269 REPAIRS-OTHER WATER TREATMENT FCLTY MNTC/RPR 00094764 2.66 UTIL SALES TAX ADJUST 304221 244351470130040 53002330 DUE TO OTHER GOVERNMENT WATER&SEWER FUND HAL SHEET 00094764 39.99 RECIRCULATING LINE 304221 244351470130040 53256269 REPAIRS-OTHER WATER TREATMENT FCLTY MNTC/RPR. 00094764 Supplier 150415 FERGUSON(PCARD) 74.50 DOT STICKERS 303821 244450070125004 1530.6399 OTHER CHARGES FLEET&BUILDINGS-CMF 12099460 Supplier 149267 MN STATE PATROL(PCARD) 117.00 FUELEDUPNEW381 303797 244450070133003 16306212 MOTOR FUELS/OILS STREET EQUIPMENT MAINTENANCE 78/16245 1.72- STR SALES TAX ADJUST 303798 244450070133003 1630.6212 MOTOR FUELS/OILS STREET EQUIPMENT MAINTENANCE 78/16328 1.72 STR SALES TAX ADJUST 303798 244450070133003 1000.2330 DUE TO OTHER GOVERNMENT GENERAL FUND BALANCE SHEET 78116328 26.70 NEW#381 DEF 303798 244450070133003 16306212 MOTOR FUELS/OILS STREET EQUIPMENT MAINTENANCE 78116328 Supplier 147211 CASEY'S GENERAL STORE(PCARD) 11.44 AVSA CONCESSION PRODUCT 303818 244450070144001 52056540 TAXABLE MISC FOR RESALE ARENA I MANAGEMENT 35947483 Supplier 102101 WAL-MART(PCARD) 30.53 SCHOOL SHOOTINGS-KEELERNIRDEN 304840 244450070145004 1225.6275 SCHOOLS/CONFERENCES/EXP LOCAL POLICE TRAINING 77252838 Supplier 150535 CADILLAC RANCH MOA(PCARD) 48.15 POL PIZZA 303807 244450070155005 1200.6229 GENERAL SUPPLIES POLICE MANAGEMENT 47700161 Supplier 100286 LITTLE CAESARS PIZZA(PCARD) R55CKR2 LOGISEM CITY OF APPLE VALLEY 2/22/2017 15:3996 Council Check Register by GL Page- 15 Council Check Register by Invoice&Summary 1/30/2017 -- 2/272017 Check N Date Amount Supplier/Explanation PON Doc No Inv No Account No Subledger Account Description Business Unit 20170156 1202017 120679 U S BANK P CARD Continued... 3.56- CEMETERY SALES TAX ADJUST 303819 244457470091001 56056229 GENERAL SUPPLIES CEMETERY 38183635 3.56 CEMETERY SALES TAX ADJUST 303819 244457470091001 56002330 DUE TO OTHER GOVERNMENT CEMETERY BALANCE SHEET 38183635 53.53 CERTIFICATE&BROCHURE PAPER 303819 244457470091001 5605.6229 GENERAL SUPPLIES CEMETERY 38183635 1590- IAI SALES TAX ADJUST 303815 244457470135004 52056210 OFFICE SUPPLIES ARENA I MANAGEMENT 26171883 1590 IAI SALES TAX ADJUST 303815 244457470135004 5200.2330 DUE TO OTHER GOVERNMENT ARENA FUND BALANCE SHEET 26171883 239.07 AVSASUPPLIES 303815 244457470135004 5205.6210 OFFICE SUPPLIES ARENA I MANAGEMENT 26/7/883 Supplier 100577 OFFICE MAX(PCARD) 160,00 2017 ICC IOK LAKES-DORN 303808 244921570067178 1400.6280 DUES&SUBSCRIPTIONS INSPECTIONS MANAGEMENT 26683209 Supplier 144171 ACT-IOKLAKES BUILD(PCARD) 400.00 AMBO MEMBERSHIP DUES 2017-DORN 303899 244921570067178 1400.6280 DUES&SUBSCRIPTIONS INSPECTIONS MANAGEMENT 29732862 Supplier 150536 EB 2017 AMBO CHAPTER(PCARD) 26.62 SHARPEAPAEVENT 303917 244921570068945 1100.6275 SCHOOLS/CONFERENCES/EXP LOCAL DEV MANAGEMENT 36975793 Supplier 139988 PAYPAL(PCARD) 95.00 BIZIOURNAL SUBSCR-NORDQUIST 303915 244921570107159 1100.6280 DUES&SUBSCRIPTIONS DEV MANAGEMENT 40571809 Supplier 150534 BIZBOOKSLLC(PCARD 175.00 MIAMAMEMBERSHIP-AVSA 303814 244921570118946 52056280 DUES&SUBSCRIPTIONS ARENA IMANAGEMENT 65203507 Supplier 139988 PAYPAL(PCARD) 29.98 SOUND FORMAT CONVERTER SOFTWAR 303805 244921570128946 12006210 OFFICE SUPPLIES POLICE MANAGEMENT 81302191 Supplier 150540 NCH SOFTWARE(PCARD) 300.00 ROOM RESERVATION GOAL SETTING 303802 244939870102007 1005.6310 RENTAL EXPENSE MAYOR/CITY COUNCIL 17700112 Supplier 101132 DAKOTA COUNTY PARKS DEPT(PCARD) 340.00 GOLF MEDIAAD 304217 244939870122008 5105.6239 PRINTING GOLF MANAGEMENT 92600192 340.00 GOLF MEDIAAD 304218 244939870122008 5105.6239 PRINTING GOLF MANAGEMENT 92600218 Supplier 141722 TDS MEDIA DIRECT INC(PCARD) R55CKR2 LOGIS101 CITY OF APPLE VALLEY 2/22/2017 15:39:36 Council Check Register by GL Page- 16 Council Check Register by Invoice&Summary 1/302017 .- 2/272017 Check# Dale Amount Supplier/Explanation PO 9 Doc No Inv No Account No Sublodger Account Description Business Unit 20170156 1/30/2017 120679 USBANKPCARD Confined... 44.00 NORDQUIST SLUC EVENT 303918 245593070099000 11006275 SCHOOLS/CONFERENCES/EXP LOCAL DEV MANAGEMENT 19045877 250.00 2017 SLUC MEMBERSHIP NORDQUIST 303919 245593070109000 1100.6280 DUES&SUBSCRIPTIONS DEV MANAGEMENT 19145880 Supplier 148115 SENSIBLE LAND USE(PCARD) 1:42- UTIL SALES TAX ADJUST 304214 246104370070101 5345.6211 SMALL TOOLS&EQUIPMENT WATER EQUIPNEHICLE/MISC MNTC 83590114 1.42 UTIL SALES TAX ADJUST 304214 246104370070101 53002330 DUE TO OTHER GOVERNMENT WATER&SEWER FUND BAL SHEET 83590114 21.39 BMS FOR BRETS TRUCK 304214 246104370070101 5345 6211 SMALL TOOLS&EQUIPMENT WATER EQUIPNEHICLE/MISC MNTC 83590114 12.65- UTIL SALES TAX ADJUST 304220 246104370130101 5325.6266 REPAIRS-BUILDING. WATER TREATMENT FCLTY MNTC/RPR 85633666 12.65 UTIL SALES TAX ADJUST 304220 246104370130101 53002330 DUE TO OTHER GOVERNMENT WATER&SEWER FUND HAL SHEET 85633666 190.18 RECIRC LINE WTP 304220 246104370130101 53256266 REPAIRS-BUILDING WATER TREATMENT FCLTY MNTC/RPR 85633666 38.50 SCREWDRIVERS 303796 246104370140101 5155.6211 SMALL TOOLS&EQUIPMENT GOLF EQUIPMENT MAINTENANCE 88801830 Supplier 143525 HOME DEPOT STORE 92833(PCARD) 240.00 INSP CODE BOOKS 303806 246921670070002 14006229 GENERAL SUPPLIES INSPECTIONS MANAGEMENT 42293440 Supplier 100249 MTL CODE COUNCIL INC(PCARD) 512.00 HELPDESK ANNUAL SOFTWARE LIC 303886 246921670100003 10306249 OTHER CONTRACTUAL SERVICES INFORMATION TECHNOLOGY 22892900 Supplier 143931 SOLARWINDS(PCARD) 1499 MONTHLY SOFTWARE SUBSCRIPTION 303810 246921670110007 1030.6249 OTHER CONTRACTUAL SERVICES INFORMATION TECHNOLOGY 47585922 Supplier 150048 HOOTSUITE MEDIA INC(PCARD) 25.00 MONTHLY SOFTWARE SUBSCRIPTION 303811 246921670170002 1030.6249 OTHER CONTRACTUAL SERVICES INFORMATION TECHNOLOGY 75403104 Supplier 141272 MAILCHIMP(PCARD) 1025 APPLICATOR LICENSE-BROCK 303793 247170570061600 5105 6280 DUES&SUBSCRIPTIONS GOLF MANAGEMENT 60013331 1025 APPLICATOR LICENSE-OTTO 303794 247170570061600 5105 6280 DUES&SUBSCRIPTIONS GOLF MANAGEMENT 60013349 Supplier 148091 MN DEPT OF AGRICULTURE(PCARD) 114.00 4 MNDOT 2016 STDS 303820 247170570061700 1510.6280 DUES&SUBSCRIPTIONS PW ENGINEERING&TECHNICAL 61140629 Supplier R55CKR2 LOGISI01 CITY OF APPLE VALLEY 2/22/2017 15:39:36 Council Check Register by GL Page- 17 Council Check Register by Invoice&Summary 1/302017 — 2/27/2017 Check4 Dat, Amount Supplier/Explanation PO Doc No Inv No Account No Subledger Account Description Business Unit 20170156 1/30/2017 120679 USBANKPCARD Continued... 100333 MINNESOTA'S BOOKSTORE(PCARD) 375.00 DMT RECERT-FRY 304445 247170570181201 1225.6275 SCHOOLS/CONFERENCES/EXP LOCAL POLICE TRAINING 82857409 Supplier 150045 BCATRAINING EDUCATION IPCARD) 135.00 IEDC WEBINAR-NORDQUIST 303916 247554270191201 11006275 SCHOOLS/CONFERENCES/EXP LOCAL DEV MANAGEMENT 94611353 Supplier 145314 IEDCONLINE(PCARD) 300.00 360 COMMUNITIES LUNCH 303930 247606270133734 1200.6275 SCHOOLS/CONFERENCES/EXP LOCAL POLICE MANAGEMENT 00154841 Supplier 148978 360 COMMUNITIES(PCARD) .16- FIRE SALES TAX ADJUST 303824 248019770152077 1310.6275 SCHOOLS/CONFERENCES/EXP LOCAL FIRE TRAINING 88700049 .16 FIRE SALES TAX ADJUST 303824 248019770152077 1000.2330 DUE TO OTHER GOVERNMENT GENERAL FUND BALANCE SHEET 88700049 80.28 MEALS FOR EMT TRAINING 303824 248019770152077 1310.6275 SCHOOLS/CONFERENCES/EXP LOCAL FIRE TRAINING 88700049 Supplier 150537 ELAZTECA(PCARD) 29.95 MONTHLY SOFTWARE SUBSCRIPTION 303812 249064170080344 1030.6249 OTHER CONTRACTUAL SERVICES INFORMATION TECHNOLOGY 57791129 Supplier 139978 WUFOO.COM(PCARD) 326.10 HOME&GARDEN SHOW 304215 249064170090344 5365.6239 PRINTING SEWER MGMT/REPORTS/DATA ENTRY 91891850 Supplier 148145 41MPRINT(PCARD) 1,295.98 75"MONTIORS CORTLAND&HARALS 303920 249064170140346 1030.6725 CAPITAL OUTLAY-OFFICE EQUIP INFORMATION TECHNOLOGY 91169845 3,000.00 75"MONITORS CORTLAND&HARALS 303920 249064170140346 1060.6211 SMALL TOOLS&EQUIPMENT MUNICIPAL BLDG&GROUNDS MNTC 91169845 Supplier 131979 B&H PHOTO(PCARD) 60.00- REFUND FROM 360 COMMUNITIES 303931 747606270143747 1200 6275 SCHOOLS/CONFERENCES/EXP LOCAL POLICE MANAGEMENT 00181801 Supplier 148978 360 COMMUNITIES(PCARD) 11,192.91 20170227 2/24/2017 149015 EMPOWER 1,200.00 MN DCP-PLAN#650251 304797 222179282214 90002120 ACCRUED BENEFIT LIABILITY PAYROLL CLEARING BAL SHEET 1.200.00 20/70228 2/24/2017 148869 EMPOWER(HCSP) 60.44 SERGEANT HCSP FUNDING-ANNUALL 304799 222179282216 9000.2120 ACCRUED BENEFIT LIABILITY PAYROLL CLEARING BAL SHEET 261.82 SERGEANT HCSP FUNDING-GROSS WA 304799 222179282216 9000.2120 ACCRUED BENEFIT LIABILITY PAYROLL CLEARING BAL SHEET R55CKR2 LOGISHU CITY OF APPLE VALLEY 2/22/2017 15.39:36 Council Check Register by GL Page- 18 Council Check Register by Invoice&Summary 1/302017 -- 2/27/2017 Check# Data Amount Supplier/Explanation PON Doc No Inv No Account No Subledger Account Description Business Unit 20/70228 2242017 148969 EMPOWER(HCSP) Combined... 1,211.19 POLICE HCSP FUNDING-GROSS WAGE 304799 222179282216 90002120 ACCRUED BENEFIT LIABILITY PAYROLL CLEARING HAL SHEET 1,434.49 POLICE HCSP FUNDING-COMP 304799 222179282216 90002120 ACCRUED BENEFIT LIABILITY PAYROLL CLEARING HAL SHEET 2,967 94 20170229 2/27/2017 102664 ANCHORBANK 8,397.52 EMPLOYEE MEDICARE 304793 222119282210 9000.2111 ACCRUED FEDERAL/FICA PAYROLL CLEARING HAL SHEET 8,397.52 CITY SHARE MEDICARE 304793 222179282210 90002111 ACCRUED FEDERAL/FICA PAYROLL CLEARING DAL SHEET 24,851.20 EMPLOYEE FICA 304793 222179282210 90002111 ACCRUED FEDERAL/FICA PAYROLL CLEARING HAL SHEET 24,85120 CITY SHARE FICA 304793 222179282210 90002111 ACCRUED FEDERAL/FICA PAYROLL CLEARING BAL SHEET 65,034.47 FEDERAL TAXES PR 304793 222179282210 90002111 ACCRUED FEDERALTICA PAYROLL CLEARING BAL SHEET 131,531.91 20170230 2/24/2017 101238 MINNESOTA CHILD SUPPORT PAYMENT CENTER 507.50 CHILD SUPPORT DEDUCTIONS 304805 22217928227 9000.2120 ACCRUED BENEFIT LIABILITY PAYROLL CLEARING BAL SHEET 459.50 CHILD SUPPORT DEDUCTIONS 304806 22217928228 9000.2120 ACCRUED BENEFIT LIABILITY PAYROLL CLEARING DAL SHEET 967,00 20170231 2/27/2017 100657 MNDEPTOFREVENUE 25,634.39 STATE TAX WITHHOLDING 304804 22217928226 9000.2112 ACCRUED STATE W/H PAYROLL CLEARING BAL SHEET 25,634.39 20170232 2/24/2017 100392 PUBLIC EMPLOYEES RETIREMENT ASSOCIATION 45,286.04 EMPLOYEE SHARE PERA 304801 22217928223 90002114 ACCRUEDPERA PAYROLL CLEARING BAL SHEET 59,292.83 CITY SHARE PERA 304801 22217928223 90002114 ACCRUEDPERA PAYROLL CLEARING BAL SHEET 104,578.87 20170233 2/24/2017 148841 SELECTACCOUNT 3,936.82 HSA EMPLOYEE FUNDING 304798 222179282215 9000.2125 ACCRUED HSA/HRA BENEFIT PAYROLL CLEARING BAL SHEET 3,936.82 20170234 2/24/2017 100455 AFFINITY PLUS FEDERAL CREDIT UNION 1,195.00 EMPLOYEE DEDUCTIONS 304802 22217928224 9000.2120 ACCRUED BENEFIT LIABILITY PAYROLL CLEARING BAL SHEET 1,195 00 20/70235 2/24/2017 100240 VANTAGEPOINT TRANSFER AGENTS-457 FT 27,743.40 ICMA-PLAN#301171 304800 22217928222 9000.2120 ACCRUED BENEFIT LIABILITY PAYROLL CLEARING BAL SHEET 27,743.40 20170236 2/24/2017 126459 VANTAGEPOINT TRANSFER AGENTS-ROTH 2,014.06 ROTH IRA-PLAN#705481 304795 222179282212 9000.2120 ACCRUED BENEFIT LIABILITY PAYROLL CLEARr^'G BAL SHEET R55CKR2 LOUIS 101 CITY OF APPLE VALLEY 2/22/2017 15:39:36 Council Check Register by GL Page- 19 Council Check Register by Invoice&Summary 1/30/2017 -- 227/2017 Check# Date Amount Supplier/Explanation PO# Doc No Inv No Account No Subledger Account Description Business Unit 20170236 224/2017 126459 VANTAGEPOINTTRANSFERAGENTS-ROTH Continued... 2,014 06 20/70237 2222017 148841 SELECTACCOUNT 216.88 FLEX SPENDING MEDICAL-2016 304848 38359165 9000.2119 ACCRUED FLEX SPENDING PAYROLL CLEARING BAL SHEET 576.87 FLEX SPENDING DAYCARE-2016 304848 38359165 90002119 ACCRUED FLEX SPENDING PAYROLL CLEARING BAL SHEET 793.75 20170238 2222017 148841 SELECTACCOUNT 111.67 FLEX SPENDING MEDICAL-2017 304849 38359165 90002119 ACCRUED FLEX SPENDING PAYROLL CLEARING BAL SHEET 179.24 FLEX SPENDING DAYCARE-2017 304849 38359165 90002119 ACCRUED FLEX SPENDING PAYROLL CLEARING BAL SHEET 290.91 20170239 2212017 100873 HEALTHPARTNERS(DENTALCLAIMS-EFT) 3,209.13 DENTAL CLAIMS 2/9-2/15/17 304850 20170222 71056146 DENTAL INSURANCE INSURANCE TRUST DENTAL 3,209.13 20170240 2/13/2017 100873 HEALTHPARTNERS(DENTAL CLAIMS-EFT) 3,006.39 DENTAL CLAIMS 22-2/8/17 304851 20170222 71056146 DENTAL INSURANCE INSURANCE TRUST DENTAL 3,006.39 20170241 2/17/2017 101671 MN DEFT OF REVENUE 63.12 DIESEL TAX-PARKS 304852 20170217 1765.6212 MOTOR FUELS/OILS PARK EQUIPMENT MAINTENANCE 948.81 DIESEL TAX-STREETS 304852 20170217 1630.6212 MOTOR FUELS/OILS STREET EQUIPMENT MAINTENANCE 15.57 DIESELTAX-WATER 304852 20170217 5345.6212 MOTOR FUELS/OILS WATER EQUIPNEHICLEAUSC MNTC 3470 DIESEL TAX-SEWER 304852 20170217 5390.6212 MOTOR FUELS/OILS SWR EQUIP/VEHICLE MISC MNTC/RP 1,062.20 20170242 2/16/2017 100000 MN DEPT OF REVENUE 57.00 SALESNSE TAX-CASH ACCOUNT 304853 20170215 999.2330 DUE TO OTHER GOVERNMENT CASH COMPANY BALANCE SHEET 1548.00 SALESNSE TAX-GENERAL FUND 304853 20170215 1000.2330 DUE TO OTHER GOVERNMENT GENERAL FUND BALANCE SHEET 10,24000 SALESNSE TAX-LIQUOR#2 304853 20170215 5000.2330 DUE TO OTHER GOVERNMENT LIQUOR BALANCE SHEET 16,48000 SALESNSE TAX-LIQUOR 95 304853 20170215 5000.2330 DUE TO OTHER GOVERNMENT LIQUOR BALANCE SHEET 28,040.00 SALES/USE TAX-LIQUOR#1 304853 20170215 5000.2330 DUE TO OTHER GOVERNMENT LIQUOR BALANCE SHEET 401.00 SALES/USE TAX-GOLF 304853 20170215 5100.2330 DUE TO OTHER GOVERNMENT GOLF FUND BALANCE SHEET 4,41800 SALESNSE TAX-ARENA 304853 20170215 5200.2330 DUE TO OTHER GOVERNMENT ARENA FUND BALANCE SHEET 1,497.00 SALES/USE TAX-WATER&SWR 304853 20170215 5300.2330 DUE TO OTHER GOVERNMENT WATER&SEWER FUND BAL SHEET 38.00- SALES/USE TAX-STORM DRAM 304853 20170215 5500.2330 DUE TO OTHER GOVERNMENT STORM DRAIN UTIL BALANCE SHEET 4.00- SALES/USE TAX-CEMETERY 304853 20170215 5600.2330 DUE TO OTHER GOVERNMENT CEMETERY BALANCE SHEET 197.00- SALESNSE TAX-FIRE GRANT 304853 20170215 7600.2330 DUE TO OTHER GOVERNMENT FIRE GRANTS BALANCE SHEET 62,442.00 R55CKR2 LOGISI01 CITY OF APPLE VALLEY 2/22/2017 15:39:36 Council Check Register by GL Page- 20 Council Check Register by Invoice&Summary 1/30/2017 -- 2/27/2017 Check Date Amount Supplier/Explanation PO4 Doc No Inv No Account No Subledger Account Description Business Unit 20170242 2/1620/7 100000 MNDEPTOFREVENUE Continued... 20170243 2/222017 148841 SELECTACCOUNT 1,508.00 PARTICIPANT FEES JAN-FEB 2017 304418 1177794 7205.6235 CONSULTANT SERVICES INSURANCE CLAIMS 1,50a 00 718,65444 Land Total Payment Instrument Totals Checks 193,377.34 EFT Payments 385,274.68 A/PACH Payment 140,002.42 Total Payments 718,654.44 2I yz'Il R55CKS2 LOGISI00 CITY OF APPLE VALLEY 2/22/2017 15:39:42 Note: Payment amount one,not reflect the actual amount due to data sequencing andtor data selection Cotoont Check Summmy Page- 1 1/30/2017 - 2127/2017 Company Amount 00999 CASH COMPANY 57.00 01000 GENERALFUND 167,119.02 02010 CABLE TV RESERVE FUND 1.880.81 02025 ROAD ESCROW FUND 59,943.35 02090 14200 CEDAR AVE-OLD CITY HALL 332.13 04500 CONSTRUCTION PROJECTS 21,133.50 05000 LIQUOR FUND 60,480.33 05100 GOLF FUND 5,661.30 05200 ARENA FUND 6,390.00 05300 WATER&SEWER FUND 33,315.86 D5500 STORM DRAINAGE UTILITY FUND 1,356.92 05600 CEMETERY FUND LEVEL PROGRAM 22,780.29 05800 STREET LIGHT UTIL FUND 973.24 D7100 INSURANCE TRUST DENTAL FUND 6,215.52 07200 RISK MANAGEMENT/INSURANCE FUND 9,152.91 07400 VERF-POLICE 6,22444 07600 FIRE GRANTS 10,13305 09D00 PAYROLL CLEARING FUND 305,504.77 Report Totals 718,654.44 *00 *000 *000 09000 ITEM: 5.A. 000 Apple COUNCIL MEETING DATE: March 9, 2017 Valley SECTION: Regular Agenda Description: Firefighter Introductions and Oaths of Office Staff Contact: Department/ Division: Nealon P. Thompson, Fire Chief Fire Department ACTION REQUESTED: City Clerk Pamela Gackstetter to administer the Oath of Office to Firefighters who recently completed probation, which will be immediately followed by the pinning of the Firefighter's Badge. Each Firefighter has chosen someone special to them to bestow the honor of pinning on their badge for the first time. SUMMARY: Hired in 2015 Probationary Firefighters Steven Boerner, Paul Bostel, Josh Gaffke, Stephen Grass Jr., Gerald Johnson, and Robert Morris began their service with the Apple Valley Fire Department. The six of them attended a recruit academy for seven months, completing course work online and one day a week learning the practical skills of firefighting, rescue, apparatus operator, hazardous materials, and emergency medical services. In total they received more then 210 hours of training. That training provided the knowledge, skills, and abilities to successfully pass four certification tests (written and practical) Firefighter 1 and 2, Hazardous Materials Operations, and Emergency Medical Responder. Following the initial training period (academy) they have been responding as probationary firefighters for the past twelve months, continuing their education and gaining hands-on experience. We would like to mark the end of their eighteen month probationary period with this introduction, oath of office, and badge presentation. Please join me in congratulating Steven Boemer, Paul Bostel, Josh Gaffke, Stephen Grass Jr., Gerald Johnson, and Robert Morris on the presentation of their Firefighter's badge. Immediately following, Firefighters and their families will convene to the McIntosh room for a light reception. BACKGROUND: N/A BUDGET IMPACT: N/A *00 *000 *000 09000 ITEM: 5.B. 000 Apple COUNCIL MEETING DATE: March 9, 2017 Valley SECTION: Regular Agenda Description: Proclaim April 28, 2017, as "Arbor Day" and May 2017 as "Arbor Month" Staff Contact: Department/ Division: Jessica Schaum, Natural Resources Coordinator Natural Resources Division ACTION REQUESTED: Proclaim April 28, 2017, as Arbor Day and May 2017 as Arbor Month. SUMMARY: Attached is a proclamation for Arbor Day and Arbor Month in the City of Apple Valley. In observance of the proclamation, a tree planting event is scheduled to begin at 6:00 p.m. on Thursday, April 27, 2017, at Cortland Development Park. Dakota Electric Association has offered to donate a tree for the planting ceremony. Members of the Apple Valley City Council and Dakota Electric Association Board will participate in the tree planting. All interested parties are welcome to attend. As further observance of Arbor Day and Arbor Month and to promote reforestation in Apple Valley, Public Works staff has implemented the fourteenth annual tree and shrub sale. Trees and shrubs have been available for ordering and will be available for pickup on Saturday, April 29, at the Central Maintenance Facility. For further details, visit the City's website or contact the Natural Resources Division at 952-953-2461. BACKGROUND: N/A BUDGET IMPACT: N/A ATTACHMENTS: Proclamation Map CITY OF APPLE VALLEY PROCLAMATION WHEREAS,trees are a highly valued resource because they beautify the landscape and have been shown to increase property values and reduce crime; and WHEREAS, trees purify our air and water, reduce heating and cooling costs, serve as recreational settings,providing habitat for wildlife, and enrich our lives in many ways; and WHEREAS, Apple Valley has been designated as a "Tree City USA" for 33 consecutive years by the National Arbor Day Foundation; and WHEREAS, each year during Arbor Month the people of Apple Valley pay special attention to the gift that our trees represent and dedicate themselves to the continued health of our City's urban forest. NOW, THEREFORE, the City Council of the City of Apple Valley, Dakota County, Minnesota, does hereby proclaim the following in Apple Valley: April 28, 2017-ARBOR DAY May 2017 -ARBOR MONTH FURTHER, this Council urges citizens to become more aware of the importance of trees and to participate in tree planting programs that will ensure a green Apple Valley in the decades to come and to nurture and protect Apple Valley's treasure of trees. PROCLAIMED this 9th day of March, 2017. Mary Hamann-Roland, Mayor ATTEST: Pamela J. Gackstetter, City Clerk � . n aLale W. 4L 44, ling I 49H pjF CORTLANDs ..., j �� DEVELOPMENTtv . �. PARK NA �.. lie Now �. ilk�. ►�L k WILLE Fib "�• ITEM: 7. ••• COUNCIL MEETING DATE: March 9, 2017 Apple Valley SECTION: Calendar of Upcoming Events Description: Approve Calendar of Upcoming Events Staff Contact: Department/Division: Stephanie Marschall, Deputy City Clerk City Clerk's Office ACTION REQUESTED: Approve the calendar of upcoming events as listed in the summary below, and noting each event listed is hereby deemed a Special Meeting of the City Council. SUMMARY: Day/Date Time Location Event Mon./Mar. 6 7:00 p.m. Municipal Center Telecommunications Advisory Committee Meeting Tue./Mar. 7 7:30-9:00 a.m. Pure Barre Chamber Coffee Connection Dakota County County Board Public Hearing on Sales Tue./Mar. 7 9:00 a.m. Administration Center, and Use Tax Hastings Wed./Mar. 8 7:00 p.m. Municipal Center Traffic Safety Advisory Committee Meeting Thur./Mar. 9 5:30 p.m. Municipal Center Informal City Council Meeting Thur./Mar. 9 7:00 p.m. Municipal Center Regular City Council Meeting Mar. 11-15 Washington D.C. National League of Cities Annual Congressional City Conference Sat./Mar. 11 5:00-9:00 p.m. Valleywood Clubhouse Apple Valley Arts Foundation Frozen Apple Concert Series Wed./Mar. 15 9:00 a.m. Municipal Center Firefighters Relief Association Meeting Wed./Mar. 15 7:00 p.m. Municipal Center Planning Commission Meeting Thur./Mar. 16 3:30 p.m. AT&T AuthorizedRetailer Store Ribbon Cutting Ceremony Thur./Mar. 16 5:00-7:00 p.m. Think Mutual Bank Chamber Business After Hours Mon./Mar. 20 11:30 a.m. Foliage Medical Ribbon Cutting Ceremony Building Wed./Mar. 22 11:00 a.m. On-Site Title Ribbon Cutting Ceremony Thur./Mar. 23 8:00 a.m.-4:00 p.m. Best Western Capitol 2017 LMC Legislative Conference Ridge, St. Paul for Cities Thur./Mar. 23 6:00 p.m. Municipal Center EDA Meeting Thur./Mar. 23 7:00 p.m Municipal Center Regular City Council Meeting Thur./Mar. 30 4:30-7:30 p.m. Municipal Center Special Informal Planning Commission Meeting Fri./Mar. 31 1:00 p.m. Legends of Apple Ground Breaking Ceremony Valley BACKGROUND: Each event is hereby deemed a Special Meeting of the City Council, the purpose being informational or social gathering. Only at events marked with an asterisk will any action of the Council take place. BUDGET IMPACT: N/A