The URL can be used to link to this page

Home My WebLink About11.21.11 Council Packet City of Farmington 430 Third Street Farmington, MN 55024 Mission Statement Through teamwork and cooperation, the City of Farmington provides quality services that preserve our proud past and foster a promisingfuture. FARMINGTON CITY COUNCIL Todd Larson, Mayor Jason Bartholomay Christy Fogarty Terry Donnelly Julie May AGENDA REGULAR CITY COUNCIL MEETING NOVEMBER 21, 2011 7:00 P.M. CITY COUNCIL CHAMBERS 1. CALL TO ORDER 7:00 P.M. 2. PLEDGE OF ALLEGIANCE 3. ROLL CALL 4. APPROVEAGENDA 5. ANNOUNCEMENTS/COMMENDATIONS a) Introduce Promoted Employee - Parks and Recreation b) Introduce New Employee - Parks and Recreation c) Library Update - Mary Scheide 6. CITIZEN COMMENTS / RESPONSES TO COMMENTS (This time is reservedfor citizen comments regarding non-agenda items. No official Council action can be taken on these items. Speakers are limited to frve minutes to address the Council during "Citizen Comment" time.) 7. CONSENT AGENDA a) Approve Council Minutes (1117111 Regular) b) Adopt Resolution - Accepting Donated Trees Meadowview Park - Parks and Recreation c) Amend Ordinance - 2012 Fee Schedule - Engineering d) Approve Various 2012 License Renewals - Administration e) Amend Ordinance - Subsurface Sewage Treatment System - Building Inspections t) Approve Master Engineering Services Agreement Assignment - Engineering g) Approve Bills REGULAR AGENDA (The Council takes a separate action on each item on the Regular Agenda. If you wish to address the Council regarding any or all of the items on the Regular Agenda, please address the item when the item is discussed. Spea;kers will be given at least three minutes to speak per item. Additional time may be granted to speakers representing two or more persons.) Action Taken Introduced Introduced IY1formation Received Approved R54-11 Approved Approved Ord 011-641 Approved Approved 8. PUBLIC HEARINGS a) Approve Various 2012 License Renewals - Administration Approved 9. AWARDOFCONTRACT 10. PETITIONS, REQUESTS AND COMMUNICATIONS a) October 2012 Financial Report - Finance Information Received 11. UNFINISHED BUSINESS 12. NEW BUSINESS 13. COUNCIL ROUNDTABLE 14. ADJOURN Persons with a disability may request a reasonable accommodation by contacting the City Administrator's office at 65 J -280-6803. Request should be made 24 hours in advance or as early as possible to allow time to arrange accommodation. Table of Contents Agenda. . . . . . . . . . . . . . . . . . . . . 2 Approve Council Minutes (11n111 Regular) Council Minutes. . . . . . . . . . . . 4 Adopt Resolution Accept Donation of Six Planted Trees in Meadowview Park memo . . . . . . . . . . . . . . 11 resolution . . . . . . . . . . . . 12 Amend Ordinance-2012 Fee Schedule 2012 Fee Schedule Ammendment 112111 . . 13 SAC Increase_0001. . . . . . . . . 14 Approve Various 2012 License Renewals Memo . . . . . . . . . . . . . . . . 15 Amend Ordinance - Subsurface Sewage Treatment System Memo . . . . . . . . . . . . . . . . . . . . . . . . . . 17 Ordinance. . . . . . . . . . . . . . . . . . . . . . . . 18 Approve Master Engineering Services Agreement Assignment Master Engineering Services Agreement Assignment 112111. . . . . . . . . . . . . . . . . . . . . . . . . . 23 Master Engineering Services Agreement Assignment 112111. . . .24 Approve Bills List of Bills. . 25 Approve Various 2012 License Renewals Memo . . . . . . . . . . 47 October 2012 Financial Report Memo . . . . . 49 Spreadsheet. . . . . . . 52 1 Tax Comparison between Farmington and Neighboring Cities Based on Proposed 2012 Taxes Source: Dakota County website Notes: (1) Assumes property owner has 2012 City of Farmington median value house of $175,800 in other city. (2) Total tax including County/City/School District/Other local taxing jurisdictions City Tax Amount Amount lOWER than % lOWER than Farmington Farmington Farmington $2,753.10 N/A N/A Apple Valley $2,162.36 $590.74 (-27.31%) Burnsville $2,128.39 $624.71 (-29.35%) Eagan $1,962.21 $790.89 (-40.26%) Empire Twp $2,143.49 $609.61 (-28.44%) Hastings $2,253.54 $499.56 (-22.17%) lakeville (Farmington Schools) $2,313.02 $440.08 (-19.03%) lakeville (lakeville Schools) $2,031.84 $721.26 (-35.49%) Rosemount $2,133.37 $619.73 (-29.05%) South St. Paul $2,283.45 $469.65 (-20.57%) ~!f . '~'.~" .'~~ . ~ City of Farmington Budget Suggestions """ '-~ ______..._.....m___m_____ _____________________m_____m_____ ---- - --------- _______mmm____ 0 ------:-:----:~----:--::--- :-:::------:----------------------------------------------:------ · Cost/Benefit analysis of merging Police & Fire · Bring annual sealcoat into the general fund · Get out of liquor business · Outside engineering consultant to evaluate historical contracts and determine Farmington's needs over the short/mid-range and long-term. · Continue to bond for necessary projects while planning for longer term projects. With the economic climate we cannot afford to tax residents to build up a large pile of money for future use. ~~"'" ..r _, ~4 · f. d.. ~: ,~. CIty 0 FarmIngton Bu get SuggestIons ~ -------------------------------------------------------------------------------------------------------0--------------------~---------------------------------------------:--:-----------~---~-~-:::--- ... · Vigorously determine any and all available funding sources for legitimate infrastructure needs (State/Federal, others) · Voluntary resident "Adopt a Trail" whereby a resident can contribute a dollar amount annually for overall trail maintenance · Stronger partnership with school district to evaluate community wide park and rec. needs and costs · Citizen Budget Commission composed of residents, business owners and 1 or 2 appointed Councilmembers 7a.- COUNCIL MINUTES REGULAR November 7, 2011 1. CALL TO ORDER The meeting was called to order by Mayor Larson at 7:00 p.m. 2. PLEDGE OF ALLEGIANCE Mayor Larson led the audience and Council in the Pledge of Allegiance. 3. ROLL CALL Members Present: Members Absent: Also Present: Audience: Larson, Bartholomay, Donnelly, Fogarty, May None Andrea Poehler, City Attorney; David McKnight, City Administrator; Teresa Walters, Finance Director; Randy Distad, Parks and Recreation Director; Kevin Schorzman, City Engineer; Brenda Wendlandt, Human Resources Director; Tony Wippler, Assistant City Planner; Cynthia Muller, Executive Assistant Zacharia Ailabouni, Jen Morical, Deb Richter, Tracy Giese, Ted Novak, Randy Bach, Lenny Hall, Dave Metzger, Don Gamer, Rich Schimmel 4. APPROVE AGENDA Councilmember May noted staffwas going to check the totals on the list of bills. MOTION by Fogarty, second by May to approve the Agenda. APIF, MOTION CARRIED. 5. ANNOUNCEMENTS 6. CITIZEN COMMENTS 7. CONSENT AGENDA MOTION by Fogarty, second by May to approve the Consent Agenda as follows: a) Approved Council Minutes (10/17/11 Regular)(10/24/11 Workshop) b) Approved Fund Balance Policy Change - Finance c) Approved School and Licensing - Building Inspections d) Approved Appointment Recommendation Parks and Recreation - Human Resources e) Approved Appointment Recommendation Parks and Recreation - Human Resources f) Approved Enventis Contract for Dial Tone Phone Service - Human Resources Councilmember May asked for more information on staff's conversations with other providers. Staff is recommending extending the contract with the current provider. Human Resources Director Wendlandt spoke with two different vendors regarding the dial tone. One would provide more savings, but it does 4 Council Minutes (Regular) November 7, 2011 Page 2 require porting over the phone numbers and staff was not comfortable with moving in that direction at this time. The City has had good service with Enventis and they recently bought CP Telecom. Enventis lowered their rates for the next year so staff can evaluate the service and ifwe can successfully port our numbers over to a new carrier without a lot of labor costs. g) Approved Pellicci Ace Hardware Commercial Rehabilitation Grant Application - Economic Development h) Acknowledged Receipt of Letter from AFSCME i) Approved Bills APIF, MOTION CARRIED. 8. PUBLIC HEARINGS 9. AWARD OF CONTRACT 10. PETITIONS, REQUESTS AND COMMUNICATIONS a) Adopt Ordinance - Amending Zoning Defmitions, Zoning Map and Floodplain Overlay District of the City Code - Planning A flood insurance study was recently completed for Dakota County which changes the floodplain line for some properties. Flood insurance rate maps will be effective December 2, 2011. Some properties will be included in the floodplain and some will be removed from the floodplain. Property owners will be notified by December 2, 2011. Councilmember May asked about notifying the property owners and the fact there is not much time for them to buy flood insurance. Assistant City Planner Wippler stated the majority of the properties are in the downtown area by the Vermillion River. Councilmember May asked if it was the City's responsibility to notify the owners or FEMA's. City Engineer Schorzman explained everyone that is affected by the map changes has been made aware ofthe process. The City is taking the responsibility to notify people. There are a few left to contact. The ones who do not have changes were contacted last winter and given copies ofthe information from FEMA. He wanted to wait on the downtown properties where elevations changed, to make sure the changes are final. MOTION by Fogarty, second by Bartholomay to adopt ORDINANCE 011-640 approving the ordinance amendment to sections 10-2-1, 10-5-1 and 10-5-25 ofthe zoning code. APIF, MOTION CARRIED. b) Adopt Resolution - 2012-2016 Dakota County CIP - Engineering The City's 195th Street project between Flagstaffand Diamond Path is included in Dakota County's 2012-2016 CIP. Due to pavement condition and enhancements identified in the transportation study, the County is interested in doing this project. The project would include turn lanes with a 3-lane section for left turns, shoulders and curb and gutter, trails along both sides of the road, a pedestrian underpass at Meadowview Elementary from north to south, and a roundabout at Pilot Knob Road and 195th Street. This project is included in staff's budget CIP 5 Council Minutes (Regular) November 7, 2011 Page 3 plan which is currently being discussed by Council. The City applied for $1.6 million of federal funding. If that is approved, the City's share ofthe project will be $2.8 - $3 million. If the federal funding is not approved, the City's share would be $3.5 - $3.75 million. The County will fund 55% and the City 45% of the cost. If the CIP is approved in the City's budget, the first two $400,000 payments were designated to cover the design and right-of-way costs on this project. The construction of the project will be bonded whether Council approves the CIP budget or not. If Council chooses not to approve the funding for the CIP pIan, then we would need to bond for the $800,000. Staff recommended Council approve the project to be in the County's CIP. The project design would be done in 2012, right-of-way and final design in 2013, and construction in 2014. If Council does not want to approve the project now, then staff should be directed to inform the County and the project will be removed from their CIP and the funds would be used by the County for other projects. Councilmember May asked ifwe say no, are we put on a schedule further out or does it go away? City Engineer Schorzman stated staff can ask if the County is willing to push it out to 2016 rather than 2014, but unless Council is willing to do it within 2012-2016, it would free up the money, the County would use it for other projects, and we would have to try to get back on the list. Councilmember May noted 195th Street is a County road and the County is concerned about it, so the project will not go away. It is a big number and we are not in a strong growth mode. We have other budget constraints and we would be adding more to the debt sooner. City Engineer Schorzman stated the debt for the construction part, whether we go with the CIP plan or just this project, it was planned bonded debt. The difference in bonding would be $800,000. Mayor Larson asked how it affects our CIP plan if we delay the project. Staff noted it depends on the ultimate direction of Council on the overall plan. As it is included, it will not change the big picture; it will change when the debt is incurred. Mayor Larson noted the biggest downfall would be construction costs increasing. Councilmember Bartholomay noted we are dealing with safety as well. He would not throw out safety because the budget is tough right now Councilmember Fogarty supported the project, as it is important to transportation. Councilmember Donnelly asked if there was any consideration for a roundabout at Flagstaff and 195th Street. City Engineer Schorzman stated it was not included in this project as the study showed the need for that is further into the future. That will be considered when there is a connection from Flagstaff to Cedar Avenue. MOTION by Fogarty, second by Donnelly to adopt RESOLUTION R53-11 approving inclusion of construction projects in the Dakota County 2012-2016 CIP. Voting for: Larson, Bartholomay, Donnelly, Fogarty. Voting against: May. MOTION CARRIED. 6 Council Minutes (Regular) November 7, 2011 Page 4 c) Approve Request to Construct a Veteran's Memorial in Rambling River Park - Parks and Recreation Parks and Recreation Director Distad gave some background information on the Veteran's Memorial Committee, various sites, etc. Mr. Leon Orr stated the committee has been working on this for quite awhile. They feel the purpose for a memorial is appropriate. The process has produced the right product for installation at the west end of Rambling River Park. Mr. Dave Metzger presented the reasons why a memorial is needed. Mr. Orr explained the plan. The focal point is a replicate of a folded flag on top of a concrete wall. Below the flag is a slanted granite tablet that will contain the names, service branch and dates of Farmington area people killed in service. On either side will be names of those injured in service. On pavers surrounding the entire memorial will be the names of other veterans in the Farmington area. In front of this will be a life size bronze statute ofa saluting soldier with an American flag and POW MIA flag flying on either side. The plan is to have this installed by Veteran's Day 2012. The have launched a fund appeal, and will be making presentations to various organizations requesting they support the committee's efforts, soliciting donations from businesses and others in the community. The model ofthe memorial was made by a Lakeville resident. They have received a major donation of$10,000 from outside the community. The location of the memorial is consistent with the master plan for Rambling River Park. Mr. Ron Ersfeld stated this project is necessary for the community. Other civic organizations are fully backing them. This memorial is something a lot of residents have looked forward to and people are willing to work with them. Councilmember May stated she is in support of the project and asked what is the total anticipated cost and does it include the amount being requested of the City. Mr. Orr stated the estimated cost is $189,000 plus 10% contingency which brings it to $207,000. They are working on refming the costs. Councilmember May asked if that total includes the sidewalk: and lighting. Mr. Orr stated that is the committee's cost for installing the memorial. There would be an ongoing committee responsible for adding names or repairing any damage. As far as the City's costs that is not included in the total. The committee sees this as a major addition to a public community park. The City would have some involvement on their own to accommodate it. Councilmember May stated her only issue is the timing. We are still in budget discussions. She was in favor of the memorial, but had issues with whether the City should dedicate certain amounts of money aside from the land at this point. Councilmember Bartholomay agreed it would be nice to have all the numbers, but completely supports the project. Councilmember Fogarty also supported the project. She noted we cannot bind future Councils, so picnic shelters and restrooms will have to be in phase two with better economic times. She felt funds could be found within the park and rec budget or the general fund for trails and lighting. Councilmember Donnelly fully supports the project. The biggest share 7 Council Minutes (Regular) November 7, 201] Page 5 of the costs outside of the picnic shelter would be 2012 money. He asked if there are park funds available to support this. Parks and Recreation Director Distad stated if the plan is approved, there is $125,000 earmarked for Lake Julia Park improvements and beyond that there is another $100,000 in the park improvement fund. Part ofthe electrical costs will benefIt the City as we have been trying to upgrade the service on the west side for the shelter and tennis court lights. Staff has received an estimate from Xcel for approximately $11,000 to run electrical to a future service area south of the shelter where there will be a new panel and then run new electrical lines to the tennis courts and shelter. From the new service, we would have to put in underground wire to the memorial which runs another $11,000 - $12,000. The overall electrical cost is about $33,000. Because Xcel supplies the power, staffhas considered contacting Dakota Electric to work out an arrangement to do the electrical to the memorial. Regarding the street lights, there are opportunities to work with a local vendor to reduce the costs. The trail would connect from the trail along hwy 50 to the parking lot in Rambling River Park. Staff requested approval to allow the committee to go ahead with construction in the park and then work out other details with lighting and electrical and to work out costs. Those items would be in a more formal agreement along with maintenance. Mayor Larson also supported the project, but agreed we are not in a position right now to designate funds because of timing. Councilmember May asked ifthe Park and Rec Commission was willing to set aside those funds as it would have to be an item in the budget for next week. Parks and Recreation Director Distad stated there is a Park and Rec meeting this week where that can be discussed and he will bring the commission's recommendation to the workshop. MOTION by Fogarty, second by Bartholomay to approve the land located in the west end of Rambling River Park and north ofCSAH 50 to locate Phase lA of the Veteran's Memorial and construct the walkway from the existing path along hwy 50 through the memorial and to the west side of the parking lot. The lighting, picnic shelter construction with restrooms and electrical service should be brought back to Council once more information is received and feedback from the Park and Rec Commission. APIF, MOTION CARRIED. 11. UNFINISHED BUSINESS 12. NEW BUSINESS a) Approve Change Order #2 and Final Pay Request 2009 Tmnk Utility Project - Engineering The project was awarded at the May 18, 2009, City Council meeting and these items will fmalize the project. There is a cost savings based on a change of construction method at a reduction of $2,000, and three items that adjusted the bid quantities to the amount actually used on the project at a reduction of $186,001.40. The fmal contract amount is $1,188,009.40. The final payment 8 Council Minutes (Regular) November 7, 2011 Page 6 amount is $9,900.09. MOTION by Fogarty, second by Bartholomay to approve change order #2 for the 2009 Trunk Utility Project in the amount of -$188,001.40 and approve the fmal pay request for the project in the amount of$9,900.09. APIF, MOTION CARRIED. b) Approve Change Order #3 and Final Pay Request Walnut Street Project - Engineering This project was awarded at the February 16,2010 City Council meeting. Staff has reviewed the seeding in the boulevards. The plan is to overseed and fertilize the boulevards next year. This should resolve the issue as long as they are watered. Residents will be notified of this plan. The material did meet the specifications on the plan. There are four items on the change order: - Additional walkway near New Heights Christian Church $452.03 - Additional hydrant extension $721.74 - Additional traffic control along TH3 as required by MnDOT $5,593.50 - Adjusting existing bid quantities to actual quantities used -$88,123.88 The total change order amount is -$81,356.61. The fmal contract amount is $1,823,102.86. The fmal payment to the contractor is $1,169.49. Councilmember May asked if the work to be done next spring is included in this amount. City Engineer Schorzman stated the overseeding next year will be done by City staff. That money is still available in the project. The bond amount was approximately $2.4 million. Councilmember May asked after a project is completed, when do the excess bond funds go back to the bond. Finance Director Walters explained once the project is completed, the money is transferred. The City Engineer will inform fmance once the project is complete which will be done after the seeding next year. City Administrator McKnight noted staff has also been in contact with Mr. Rotty regarding his driveway. Councilmember May asked ifthere is an advantage to getting the excess funds paid towards the bond. Finance Director Walters stated right now we cannot pay it towards the bond, because you cannot pay the bond early. In the spring, the capital projects fund will be closed and transferred to the debt service fund. We could utilize the funds to pay the annual bond payment so you would not have to levy as soon for the Walnut Street payment. There would be enough for a couple years. Councilmember Donnelly noted we cannot use the excess bond money for anything else; it can only be used for debt service. There is a pre-payment penalty and you have to pay according to the schedule. If we refund, we can refund at a lower level and then use the excess amount. You have to bond for a little more than the project, to make sure costs are covered. MOTION by Bartholomay, second by Fogarty to approve change order #3 for the Walnut Street reconstruction project in the amount of -$81,356.61 and approve the final pay request for the project in the amount of$I,169.49. APIF, MOTION CARRIED. 13. COUNCIL ROUNDTABLE 9 Council Minutes (Regular) November 7,2011 Page 7 Councilmember Fogarty: Winter parking is in effect, so no parking on the streets overnight. Thanked those involved with Patriotic Day. We served over 1200 meals and it was a fantastic program. Councilmember Bartholomay: how things impact the budget. Thanked Councilmember May for her questions on Councilmember May: who organized the event. Patriotic Day was a fun event and congratulations to those City Administrator McKnight: The City is accepting applications for boards and commissions for 2012. Applications are available at City Hall or on the website and are due December 30, 2011. Staff proposed to hold interviews on January 9, 2012. This Saturday is the Fire Department's Turkey Bingo at Fire Station 1. Mayor Larson: Veteran's Day is Friday and the American Legion will be having a breakfast for veterans. Patriotic Day was a fun event and a great way to volunteer. He urged residents to support Farmington businesses. 14. EXECUTIVE SESSION a) Preliminary Consideration for Purchase of Property at 416 Elm Street MOTION by Fogarty, second by Bartholomay to adjourn into Executive Session at 8:10 p.m. APIF, MOTION CARRIED. 15. ADJOURN MOTION by Fogarty, second by Donnelly to adjourn at 9:05 p.m. APIF, MOTION CARRIED. Respectfully submitted, Cynthia Muller Executive Assistant 76 City of Farmington 430 Third Street Farmington, Minnesota 651.280_6800. Fax 651.280.6899 www.ci.larmillgtlll1_TIlll_L1..1 TO: Mayor, Councilmembers, and City Administrator FROM: Randy Distad, Parks and Recreation Director SUBJECT: Adopt Resolution Accepting Donation of Six Planted Trees in Meadowview Park DATE: November 21,2011 INTRODUCTION A donation has been made by Steve Zweber to the Parks and Recreation Department. DISCUSSION Recently Mr. Zweber planted six trees in Meadowview Park. The total value of the six trees is $300. Staffwill communicate the City's appreciation on behalfofthe Council to Mr. Zweber for his generous donation. ACTION REOUESTED Approve the attached resolution accepting the donation of six planted trees in Meadowview Park that was made by Steve Zweber to the Parks and Recreation Department. Respectfully Submitted, Randy Distad Parks and Recreation Director 11 RESOLUTION No. R54-11 ACCEPT DONATION OF SIX TREES PLANTED IN MEADOWVIEW PARK FROM STEVE ZWEBER AT A TOTAL VALUE OF $300 Pursuant to due call and notice thereof, a regular meeting of the City Council of the City of Farmington, Minnesota, was held in the Council Chambers of said City on the 21st day of November, 2011 at 7:00 p.m. Members Present: Larson, Bartholomay, Donnelly, Fogarty, May Members Absent: None Member Fogarty introduced and Member May seconded the following: WHEREAS, a donation of six planted trees in Meadowview Park was recently made by Steve Zweber at a total value of $300; and, WHEREAS, it is required by State statute and it is in the best interest of the City to accept such donation. NOW, THEREFORE, BE IT RESOLVED that the City of Farmington hereby accepts with gratitude the generous donation of six trees valued at $300 and planted in Meadowview Park by Steve Zweber. This resolution adopted by recorded vote of the Farmington City Council in open session on the 21 st day of November 2011. ~~~~ Mayor - Attested to the .:>> nd day of November 2011. (},.W r:tf.4Jf City Administr tor SEAL 7c,. City of Farmington 430 Third Street Farmington, .l\.1innesota 651.280_6800. Fax 651.280.6899 w\....w.ci .farmingtll11_ n11l_L1.'1 TO: Mayor, Councilmembers, City Administrator FROM: Kevin Schorzman, P.E., City Engineer SUBJECT: Amend Ordinance-2012 Fee Schedule DATE: November 21,2011 INTRODUCTIONIDISCUSSION Council approved the 2012 Fee Schedule at the October 17,2011 City Council meeting. The fee schedule did not incorporate the Sewer Availability Charge (SAC) Rate increase that the Metropolitan Council is imposing on cities beginning on January I, 2012. As indicated in the attached letter, the fee charged by the Met Council is increasing $135 next year. BUDGET IMPACT None. This fee is collected by the city and passed on to the Met Council. ACTION REOUESTED By motion, approve the following amendment to the 2012 Fee Schedule under the "Municipal Services" heading: Sewer Metro Sewer Avail. Chg. (SAC) $2,365 ~/single unit Respectfully Submitted, Kevin Schorzman, P .E. City Engineer cc: file 13 ~~Ad Metropolitan .council ~"" Environmental Services August 1,2011 TO: FINANCE OFFICIALS, BUILDING AND INSPECTION DEPARTMENTS SUBJECT: SEWER AVAILABILITY CHARGE (SAC) RATE FOR 2012 The Metropolitan Council has adopted a $135 increase in the base metropolitan SAC rate effective January 1,2012. At and after that date, the new base metropolitan SAC rate will he $2,365 for all urban local governments connected to our system. Note that the SAC rate is the rate in effect at the time of payment on the building or sewer connection permit issuance, regardless of when the permitting process began. A metropolitan ( or wholesale) SAC is paid by your municipality to the Council (MCES) as users connect to the metropolitan wastewater system for the first time or as a user's maximum demand for sewer capacity increases. Note that these fees are for the availability of capacity (not the actual use) as demanded by development or changes "in use on specific properties in your community . Your community may bave different retail SAC rates; different credits may apply and/or yo~ may collect the fees in a different manner than the metropolitan SAC, pursuant, to Minn. Statutes sections 473.521 (3),444.075 (3) or other authorities. Details of our SAC program procedures are available in hard copy (by request) or on the web at: http://www.metrocouncil.orglenvironmentlRatesBillinglSAC_Program.htm As you may know, the SAC system was implemented metro-wide in 1973. The metropolitan SAC funds we collect pay for the reserve capacity (unused) portion of the capital costs of the metropolitan wastewater system as authorized in Minn. Statutes sections 473.517 (3). The SAC program provides funds to support the award winning regional sanitary sewer system worth billions of dollars, and facilitates equity by imposing the costs of building reserve capacity on cities proportionate to the new capacity demand rather than on existing users. Moreover, the regional pooling of development risk and the SAC pay-as-you-build'system has largely relieved cities of the economic risk of.building major new wastewater infrastructure. If you have any financial questions, please feel free to co~tact me at (651) 602-1196. For SAC procedural questions, please contact Jessie Nye at (651) 602-1378 qr readtbe SAC procedute manual on"OUr web site at: www.metrocouncil.orglenvironment/RatesBilIinglSACYrogram.htm. As always, your cooperation is appreciated. s~._ /../ (/~ Jason M. Willett MCES Finance Director cc: :> ~01-1805 . (651) 602-1005 0 Fax (651) 602-1477 . TIY (651) 291-0904 11/1 Eqllr.l Opp44i1Y Employer 7v/ City of Farmington 430 Third Street Farmington, Minnesota 651.280_6800. Fax 651_280.6899 www.ci.fdrmington_mn_L1s TO: Mayor, Councilmembers, City Administrator FROM: Cynthia Muller, Executive Assistant SUBJECT: Various Licenses and Permit Renewals DATE: November 21,2011 INTRODUCTION/ DISCUSSION Per City Code the City Council has the authority to approve On-Sale and Off-Sale Beer Licenses, Cigarette Licenses, Billiards Licenses and Gaming Device Licenses. The following establishments have submitted their applications for renewal: Beer On-Sale - Fountain Valley Golf Course, 2830 220th Street West Pilot Knob Pizzeria, 18500 Pilot Knob Road Farmington Billiards, 933 8th Street Dunn Bros Coffee, 20700 Chippendale W B & B Pizza, 216 Elm Street Weng's Kitchen, 115 Elm Street Beer Off-Sale - Kwik Trip, 217 Elm Street Kwik Trip, 18290 Pilot Knob Road Fountain Valley Golf Course, 2830 220th Street West SuperAmerica #4534, 18520 Pilot Knob Road Cigarette License - Farmington Municipal Liquor Store, 18350 Pilot Knob Road Farmington Municipal Liquor Store, 109 Elm Street Farmington Amcon, 957 8th Street Kwik Trip #693, 217 Elm Street Kwik Trip #443, 18290 Pilot Knob Road CVS Pharmacy #241, 19605 Pilot Knob Road Savers Choice, 115 Elm Street American Legion Post #189, 10 North 8th Street Billiards License- Farmington Billiards, 933 8th Street 15 Gaming Device License - Farmington Lanes, 27 5th Street B & B Pizza, 216 Elm Street Farmington Billiards, 933 8th Street The appropriate forms, fees and insurance information have been submitted with the applications. The applications have also been reviewed and approved by the Police Department. BUDGET IMPACT The fees collected are included in the revenue estimates of the 2012 budget. ACTION REOUESTED Approve licenses for the above mentioned applicants. Respectfully submitted, Cynthia Muller Executive Assistant 16 7~ City of Farmington 430 Third Street l;armington, Minnesota 651.280_6800. Fax 651.280.6899 www.ci.tarmingtI111_n11l_LL.I TO: Mayor, Councilmembers and City Administrator FROM: Ken Lewis, Building Official SUBJECT: SSTS (Subsurface Sewage Treatment System) Code Amendment DATE: November 21,2011 INTRODUCTION I DISCUSSION On February 4, 2008, in accordance with the authority granted in Minnesota Statutes, the Minnesota Pollution Control Agency (MPCS) promulgated revised rules for the regulation of SSTS. These rules provide minimum environmental protection standards for SSTS to protect the public health, safety and general welfare by regulating the discharge of adequately treated sewage to groundwater. The Minnesota Rules chapters 7080, 7081, 7082 and 7083 relate to the proper location, design, installation, use and maintenance of SSTS and the adoption of county ordinances that reasonably ensure proper location, design, installation, use and maintenance of SSTS and the adoption of county ordinances that reasonably ensure proper permitting, inspection and operation of SSTS. Dakota County adopted a new septic system Ordinance No. 113 on November 17, 2010. State Rules require that cities adopt the minimum County Ordinance standards into their own local septic system ordinances within one year after the County's ordinance adoption. BUDGET IMPACT None ACTION REOUESTED Approve the amendment to the Ordinance to bring the City into compliance with County Ordinance 113, Subsurface Sewage Treatment Systems (SSTS) as required by State rules. 17 ., j.~ CITY OF FARMINGTON DAKOTA COUNTY, MINNESOTA ORDINANCE NO. 011-641 AN ORDINANCE REGULATING THE DESIGN, INSTALLATION AND MAINTENANCE OF ON-SITE INDIVIDUAL SEWAGE TREATMENT SYSTEMS (ISTS) THE CITY COUNCIL OF THE CITY OF FARMINGTON ORDAINS: SECTION 1. Title 7, Chapter 3 of the Farmington City Code is amended by deleting current sections 7-3-1 through 7-3-13 and replacing them with new sections to read as follows: 7-3-1: ADOPTION BY REFERENCE. Subject to the amendments set forth in this section, Dakota County Subsurface Sewage Treatment System Ordinance No. 113, as amended, is hereby adopted by reference. A copy of the Ordinance shall be kept on file in the City offices. The following references in Ordinance No. 113 are replaced: 1. replace "County" with "City of Farmington" 2. replace "County Board" with "City Council" 3. replace "Dakota County Attorney" with "City Attorney" In the ordinance the following definitions shall apply: "DEPARTMENT" means the Building Inspection Department of the City of Farmington, its staff and designated agents." "CITY" means the City of Farmington. "SHORELAND/FLOODPLAIN AREA" means those areas defined by City Ordinance. 7-3-2: HEARINGS. Section 13.00 of Ordinance No. 113 is amended to provide: SECTION 13.00 HEARINGS Hearings requested under this ordinance shall be held before a hearing examiner as provided below, and shall be open to the public. A. TIMEFRAME FOR HEARING. Unless an extension of time is requested by the appellant in writing directed to the City Administrator and is granted, the hearing will be held no later than 45 calendar days after the date of service of request for a 153105v02 RNK:rlO/Ol/2010 hearing, exclusive of the date of such service. In any event, such hearing shall be held no later than 90 calendar days after the date of service of request for a hearing, exclusive of the date of such service. B. NOTICE OF HEARING. The City Administrator shall mail notice of the hearing to the appellant at least 15 working days prior to the hearing. Such notice shall include: 1. A statement of time, place and nature of the hearing. 2. A statement of the legal authority and jurisdiction under which the hearing is to be held. 3. A reference to the particular section of the ordinance and rules involved. C. HEARING EXAMINER. The City Administrator or Administrator's designee shall be the hearing examiner, to conduct the hearing and to make findings of fact, conclusions and recommendations to the City Council. The hearing examiner shall submit the findings of fact, conclusions and recommendations to the City Council in a written report and the City Council may adopt, modify or reject the report. D. CONDUCT OF THE HEARING. The appellant and the department may be represented by counsel. The department, the appellant, and additional parties, as determined by the hearing examiner, in that order, shall present evidence. All parties shall have full opportunity to respond to and present evidence, cross-examine witnesses, and present argument. The hearing examiner may also examine witnesses. E. BURDEN OF PROOF. The department shall have the burden of proving its position by a preponderance of the evidence, unless a different burden is provided by substantive law, and all findings of fact, conclusions, and decision shall be based on evidence presented and matters officially notices. F. ADMISSION OF EVIDENCE. All evidence that possesses probative value, including hearsay, may be admitted if it is the type of evidence on which prudent persons are accustomed to rely in the conduct of their serious affairs. Evidence that is incompetent, irrelevant, immaterial or unduly repetitious may be excluded. The hearing shall be confined to matters raised in the department's written notice of suspension, summary suspension, revocation, or denial of a permit, or in the written request for a hearing. G. PRE-HEARING CONFERENCE. At the written request of any party, a pre- hearing conference shall be held. The pre-hearing conference shall be conducted by the hearing examiner. The pre-hearing conference shall be held no later than five working days before the hearing. The purpose of the pre-hearing conference is to: 1. Clarify the issues to be determined at the hearing. 153105v02 2 RNK:r 10/0 1/20 1 0 './: " :\tIl -"'I' 2. Provide an opportunity for discovery of all relevant documentary, photographic or other demonstrative evidence in the possession of each party. The hearing examiner may require each party to supply a reasonable number of copies of relevant evidence capable of reproduction. 3. Provide an opportunity for discovery of the full name and address of all witnesses who will be called at the hearing and a brief description of the facts and opinions to which each is expected to testify. If the names and addresses are not known, the party shall describe them thoroughly by job duties and involvement with the facts at issue. 4. If a pre-hearing conference is held, evidence not divulged as provided above shall be excluded at the hearing unless the party advancing the evidence took all reasonable steps to divulge it to the adverse party prior to the hearing and: a. The evidence was not known to the party at the time of the pre- hearing conference; or b. The evidence is in rebuttal to matters raised for the first time at or subsequent to the pre-hearing conference. H. FAILURE TO APPEAR. If the appellant fails to appear at the hearing, appellant shall forfeit any right to a hearing before the City Council or hearing examiner. Appellant's failure to appear shall also be deemed as a waiver of appellant's right to appeal the department's decision and the department's decision shall stand. 1. APPEAL OF CITY COUNCIL DECISION. Any appellant aggrieved by the decision of the City Council may appeal that decision to any court with appropriate jurisdiction. SECTION 2. EFFECTIVE DATE. This ordinance shall be effective immediately upon its passage and publication according to law. ADOPTED this 21 st day of November 2011, by the City Council of the City of Farmington. CITY OF FARMINGTON ~~ Todd Larson, Mayor 153105v02 RNK:rlO/Ol/2010 3 Attest: ~ Ji.1d '{j David McKnight, City f\dministrator SEAL Approved as to form the ~ day of 7'/?;)A..b-~ , 2011. 9~ Summary published in the Farmington Independent the /~ day of ~~U' 2011. 153105v02 RNK:rl %l/201 0 4 '< . ~, ... .t., ."'.... CITY OF FARMINGTON DAKOTA COUNTY, MINNESOTA SUMMARY OF ORDINANCE NO. 011-641, AN ORDINANCE AMENDING TITLE 7 CHAPTER 3 OF THE FARMINGTON CITY CODE CONCERNING SEPTIC SYSTEMS This ordinance adopts by reference the Dakota County Subsurface Sewage Treatment System Ordinance No. 113, as amended, with additional amendment by the City. Ordinance No. 113 adopts regulations for these types of systems authorized and required by the MPCA Sewage System Rules (Chapter 7082 and successor rules) and other standards and requirements that are more restrictive. The Ordinance contains standards and regulations for the siting, design, construction, installation, operation, maintenance, repair, reconstruction, inspection and permanent abandonment of septic systems. A printed copy of the Ordinance is available for inspection by any person during regular office hours at the office of the City Clerk. APPROVED FOR PUBLICATION this 21st day of November, 2011, by the City Council of the City of Farmington, Minnesota. CITY OF FARMINGTON BY~~ Todd Larson, Mayor ATTEST: Approved as to form the clrI~ ~ l f David McKni ht, CIty Administrator day of J/?,~ 2011. ~~. BY:? . '- oel J ., Ci Attorney BY: Published in the Farmington Independent the /.....v<= day of D~<~oe.-cJ 2011. 153105v02 RNK:rl0/0l/201O 5 7f' City of Farmington 430 Third Street Farmington, Minnesota 651.280_6800. Fax 651.280.6899 www.ci.tanningtll11_mll.L1..1 TO: Mayor, Councilmembers, City Administrator FROM: Kevin Schorzman, P.E., City Engineer SUBJECT: Approve Assignment of Master Engineering Services Agreement DATE: November 21,2011 INTRODUCTIONIDISCUSSION On September 2, 2011, Bonestroo was acquired by Stantec Consulting Services. As a result, all contracts with Bonestroo need to be assigned to Stantec. The City currently has a Master Engineering Services agreement with Bonestroo that needs to be assigned to Stantec. This is a change in name only. The personnel providing service to the City will remain the same, and this assignment does not change anything in the current arrangement we have regarding engineering servIces. BUDGET IMPACT None. ACTION REOUESTED By motion, approve the assignment of the Master Engineering Services Agreement from Bonestroo to Stantec. Respectfully Submitted, Kevin Schorzman, P .E. City Engineer cc: file 23 Stantec Stantec Consulting Services Inc. 2335 Highway 36 West St. Paul MN 55113 Tel: (651) 636-4600 Fax: (651) 636-1311 ... Bonestroo November 14, 2011 City of Farmington Kevin Schorzman 430 Third Street Farmington, MN 55024-1374 Reference: Master Services Agreement Dear Kevin: On September 2, 2011, Bonestroo, Inc. ("Bonestroo") joined Stantec Consulting Services Inc., ("Stantec") with the result that Bonestroo operations will be carried on through Stantec. Stantec will maintain Bonestroo's present office locations with no interruption in operations or client services. All future projects and operations will be under the Stantec name. Stantec's vision includes working with the best clients on the best projects and providing the best services. Accordingly, please be assured that the continuity of your current project(s) will be unaffected by this new arrangement. The personnel currently working on your project(s) will not change and, except for the assignment requested herein, no other aspect will be affected. In this regard, we request your approval to assign all existing contracts in the name of Bonestroo to Stantec. Kindly indicate your consent to the request for assignment by returning a duplicate copy of this letter, executed on behalf of the City of Farmington to Dave Sanocki. Sincerely, gj'RLL Dave Sanocki Client Service Manager The undersigned hereby consents to the assignment of the Contract noted above to Stantec Consulting Services Inc. effective September 2, 2011. City of Farmington 24 R55CKSUM LOGlSOO1V COUNCIL MEETING NOVEMBER 21, 201qfYOFFARMINGTON NOTE: Check Amount may not rel1eot actual check tolaJ due to sequenclng of data. Council Check SUmmaIy Check# Date -- 1180liS 11/10/2011 Amount SUpplier / Explanation 1OO2S1 AFLAC 3,002.66 N0V'11 PREMIUMS 3,002.66 PO# 000 No Inv No 104676 686631 118070 1111012011 118071 11/1012011 100011 ANDERSEN INC, EARL F 509_79 STOP SIGNS 217_68 SIGN POSTS 727.47 104273 0097342-IN 104274 0097303-lN 111712011 - 1112012011 BU ObJ SUb SUbledger Account Desl:rfptlon BU Desc::riptlon 11/17120111 0:35:49 Page - Co Dept DiY 07000 02 01000 08 01000 08 06200 08 118072 11/10/2011 100204 APPLE VAllEY FORD 19.39 VEHICLE EQUIP,HTR 104450 254008 1051 6230 VEHICLE SUPPUES & PARTS PATROL SERVICES 01000 05 704.56 VEHICLE PARTS 104541 254621 1051 6230 VEHICLE SUPPUES & PARTS PATROL SERVICES . 01000 05 723.95 118073 11/10/2011 112354 ARRIGONI, SCOiT 45.00 REFUND SOUCITORS PERMIT 104636 11012011 1001 4370 OTHER PERMITS GENERAL FUND REVENUES 01000 01 45.00 118074 11/1012011 100294 ASSURANT EMPLOYEE BENEFITS 971_83 NOV'11 LTC PREMIUMS 104677 4014985-1 NOV1 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 971_83 11807& 1111012011 118076 11110/2011 118077 11/10/2011 118078 1111012011 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 1072 6254 1072 6254 SIGNS & STRIPPING MATERIALS STREET MAINTENANCE SIGNS & STRIPPING MATERIALS STREET MAINTENANCE 112356 ANDERSON, JAMES G 568_84 18540ENGUSHAVEOVRPYMr 104592 18540ENGUSHA 6200 13103 566_84 110575 AT HOME TITLE LLC 937.26 641 PARKDROVRPYMT 937.26 104633 641 PARK DR 100176 BELZER'S CHEVIDODGEIKIA, JEFF 31.64 VEHICLE PART, HANDLE 104530 297475 31.64 109503 BIFF'S, INC 3.17- 9/2-10118 SRVS, EVRGRN KNL PRK 3.17- 9121-10118 SRVS, MEADVW PRK 1.31- 9121-10118 SRVS, RR PRK-TENNIS 193..84 9/21-10118 SRVS, FEELY FIELDS 186.19 104455 W447860 CR 104457 W447859 CR 104458 W447858 CR 104459 W447857 110218 BURNETTITLE ACCOUNTS RECENABLE UTIUT1 SEWER OPERATIONS 6200 13103 ACCOUNTS RECBVABLE UTILITI SEWER OPERATIONS 1070 6230 VEHICLE SUPPUES & PARTS ENGINEERING SERVICES 1090 1090 1090 1090 PROFESSIONAL SERVICES PROFESSIONAL SERVICES PROFESSIONAL SERVICES PROFESSIONAL SERVICES PARK MAINTENANCE PARK MAINTENANCE PARK MAINTENANCE PARK MAINTENANCE 6401 6401 6401 6401 25 \ 06200 08 01000 07 01000 09 01000 09 01000 09 01000 09 u'J R55CKSUM LOGISCOW CITY OF FARMINGTON 11/171201110:35:49 NOTE: Check Amount may not reflect actual check total clue to sequencing of dala. eouncU Chel;k SUmmary Page - 2 11"12011 - 11J2OJ2011 'Check # Date Amount SUpplier I Explanallon PO# Doc No Inv No ~ Obj Sub Subledger Account Descriplion BU Description Co Dept DIY -- 5_79 5189 203RO c:rW OVRPYMT 104632 5189 203RD c:rW 6200 1310 3 ACCOUNTS RECBVABLE UTIUT1 SEWER OPERATIONS 08200 08 5.79 1180711 11/1 0/2011 100058 CARQUEST AUTO PARTS 29.13 HO RBR TRK&VAN ARE 104573 2131-260359 1060 6230 VEHICLE SUPPUES & PARTS ARE SERVICES 01000 08 138.73 BRAKE ROTORlPAD fI0303 104569 2131-260910 1070 6230 VEHICLESUPPUES & PARTS ENGINEERING SERVICES 01000 r:JT 25.47 STNDRD lJ.JOINT#0905 104575 2131-258985 1090 6230 VEHICLE SUPPUES & PARTS PARK MAINTENANCE 01000 09 84.63- 01 SHAFT #0915 104568 2131-261332 1090 6230 VEHICLE SUPPUES & PARTS PARK MAINTENANCE 01000 09 14.99 NYLON GSKTSIOIL PLUG #0915 104570 2131-260m 1090 6230 VEHICLE SUPPUES & PARTS PARK MAINTENANCE 01000 09 139.55 01 SHAFT #0915 104571 2131-260718 1090 6230 VEHICLE SUPPUES & PARTS PARK MAINTENANCE 01000 09 21_00 HYD FmlNGS #0928 104572 2131-260471 1090 6230 VEHICLE SUPPUES & PARTS PARK MAINTENANCE 01000 09 7.39 FUSE 104564 2131-261984 6202 6230 VEHICLE SUPPUES & PARTS SEWER OPERATIONS EXPENSE 06200 08 74_71 BRAKE PAD CERAMIC #0718 104565 2131-261547 6202 6230 VEHICLE SUPPUES & PARTS SEWER OPERATIONS EXPENSE 06200 08 7_61 OVAl LAMP-STOCK 104574 2131-259339 6302 6230 VEHICLE SUPPUES & PARTS SCUD WASTE OPERATIONS 06300 08 53_42 ATTINGSlHOSE #0730 104565 2131-261688 6402 6230 VEHICLE SUPPUES & PARTS STORM WATER UTIUTY OPERA 06400 08 70.34 OIL FIL TERSlCOOLANT FILTERS 104567 2131-261402 7200 6230 VEHICLE SUPPUES & PARTS FLEET OPERATIONS 07200 08 102.67 ALTERS -STOCK 104576 2131-258899 7200 6230 VEHICLE SUPPUES & PARTS FLEET OPERATIONS 07200 08 600.38 118080 11/1012011 111050 CASTLE ROCK KENNB.S INC 314.71 10J04-11 IMPOUND SRVS 104490 14857 1050 6401 PROFESSIONAL SERVICES POuce ADMINISTRATION 01000 05 117.84 9I27-1OJ11 IMPOUND SRVS 104491 14856 1050 6401 PROFESSIONAL SERVICES POuce ADMINISTRATION 01000 05 432.55 118081 11/1012011 100117 CATCO PARTS SERVICE 123.38 VEHICLE PARTS, SUPPUES 104050 17-46105 1072 6230 VEHICLE SUPPUES & PARTS STREET MAINTENANCE 01000 08 136.50 REF 17-46117, VEHICLE PRT 104051 7-37593 1072 6230 VEHICLE SUPPUES & PARTS STREET MAINTENANCE 01000 08 66.18- REF 1745713, CORE CR 104119 17-46333 CM 1072 6230 VEHICLE SUPPUES & PARTS STREET MAINTENANCE 01000 08 874.40 VEHICLE EQUIP PRTS 10436S 1747015 1072 6230 VEHICLE SUPPUES & PARTS STREET MAINTENANCE 01000 08 123.38- REF17-46105, CRPARTS 104367 17-46773 CM 1072 6230 VEHICLE SUPPUES & PARTS STREET MAINTENANCE 01000 08 108.48 VEHICle, EQUIP PRTS 10436S 17-46770 1072 6230 VEHICLE SUPPUES & PARTS STREET MAINTENANCE 01000 08 111.51 VEHICLE EQUIP PRTS,FITTlNG 104370 17-46817 6302 6230 VEHICLE SUPPUES & PARTS SOUD WASTE OPERATIONS 06300 08 37.51 VEHICle, EQUIP PRTS 104369 3-18818 6402 6230 VEHICLESUPPUES & PARTS STORM WATER UTIUTY OPERA 06400 08 1,202.22 118082 11/10/2011 110511 CHAR1'ER COMMUNICATIONS 113.21 0CT'11 PHONE SERVICES 104538 835230680000179 2410 6411 TELEPHONE SENIOR CENTER PROGRAMS 02400 09 .'Sf 0CT'11 PHONE SERVICES 104538 835230680000179 2415 6411 TELEPHONE SWIMMING POOL OPERATIONS 02400 09 746.80 0CT'11 PHONE SERVICES 104538 835230680000179 7400 6411 TELEPHONE INFORMATION TECHNOLOGY r:JT4OO 04 880.38 118083 11/1012011 100027 COCA.coLA B01TLING CO 26 . ~. ~-'---"--_.'~'~'" "'-"'--"-- -----~--- --------------"' .---- ...."....~_._.~.. - ----_.~._- R55CKSUM LOGISOO1V NOTE: Checl< Amount may not reflect aotual check totaJ due to sequencing of data. Check# Date 118084 1111012011 118085 11/10/2011 118086 11/1012011 118087 11110/2011 118088 11/10/2011 118089 11/10/2011 118080 11110/2011 Amount Supplier / Explanalion 331.20 SODA POP 331.20 PO# Doc No Inv No -- 104637 0198447708 100071 7,066_15 BEER 4,256_65 BEER 11,322.80 COLLEGE CITY BEVERAGS lNe 104638 ZI0627 104652 270628 112150 COVERALL OF THE TWIN CITIES. I 2,929.02 N0V'11 ClEANING SERVICES 104667 7070171766 366.20 N0V'11 ClEANING SERVICES 104667 7070171766 54.93 N0V'11 ClEANING SERVICES 104667 7070171766 54.93 N0V'11 ClEANING SERVICES 104667 7070171766 732.94 N0V'11 ClEANING SeRVICES 104667 7070171766 137.33 NOV'11 ClEANING SeRVICES 104667 7070171766 137.33 NOV'11 ClEANING SERVICES 104667 7070171766 27.45 N0V'11 ClEANING SERVICES 104667 7070171766 137.33 N0V'11 ClEANING SERVICES 104667 7070171766 4,577.46 109886 CUMMINS NPOWER LLC 667.29 SERY CALL FOR PETERBIl T 246.75 VEHICLE PRTS, TUR SPD SENS 914.04 104518 100.56719 104529 400-8134 CITY OF FARMINGTON Council Check SummaJY 11/7/2011 - 11/2012011 au ObJ SUb SUbledger Account Description 6110 5502 COST OF GOODS SOLD 6110 5502 6115 5502 COST OF GOODS SOLD COST OF GOODS SOLD 1015 6401 1080 6401 1072 6401 1090 6401 2410 6401 6202 6401 6302 6401 6402 6401 6502 6401 PROFESSIONAL SERVICES PROFESSIONAL SERVICES PROFESSIONAL. SERVICES PROFESSIONAL SERVICES PROFESSIONAL. SERVICES PROFESSIONAL. SERVICES PROFESSIONAL SERVICES PROFESSIONAL. SERVICES PROFESSIONAL. SERVICES 6302 6230 6302 6230 VEHICLE SUPPUES & PARTS VEHICLE SUPPUES & PARTS 100172 DAKOTA COUNTY FIRE CHIEFS ASSO 75_00 2011 MEMBER DUES 104582 2011 MEMBER DUE 1080 6460 75_00 100118 DAKOTACOUNTYTREASURER-AUDI 1.056.88 RADIOSUBSCRlBERFEES 104589 OCT-11 1,056.88 RADIOSUBSCRlBERFEES 104589 OCT-11 2,113.76 100072 377.70 BEER 2,552.15 BEER 2,929.85 DAY DISTRIBUTING CO 104541 624532 104649 624533 110482 DENNISON TECHNOLOGY GROUP, INC 1,669.92 NETWORK ISSUES 104594 2~42 1,669.92 SUBSCRIPTIONS & DUES 1051 6560 1080 6560 CONTRACTUAL SERVICES CONTRACTUAL SERVICES 6110 5502 6115 5502 COST OF GOODS SOLD COST OF GOODS SOLD 7400 6402 DATA PROCESSING 27 11117/201110:35:49 Page - 3 au Desorlplion ~ Dept Dlv DOWNTOWN UQUOR REV & EXP 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 PILOT KNOB UQUOR 06100 02 CIlY HALl 01000 01 RRE SERVICES 01000 06 STREET MAINTENANCE 01000 08 PARK MAINTENANCE 01000 09 SENIOR CENTER PROGRAMS 02400 09 SEWER OPERATIONS EXPENSE 06200 08 SOUD WASTE OPERATIONS 06300 08 STORM WATER UTILITY OPERA 06400 08 WATER UTILITY EXPENSE 06500 08 SOUD WASTE OPERATIONS SOUD WASTE OPERATIONS 06300 08 06300 08 RRE SERVICES 01000 06 PATROL SERVICES RRE SERVICES 01000 05 01000 06 DOWNTOWN UQUOR REV & EXP 06100 02 PILOT KNOB UQUOR 06100 02 INFORMATION TECHNOLOGY 07400 04 R55CKSUM LOGI$OO1V NOTE: Check Amount may not refIeot actual check tolaI clue to sequencing of data. CITY OF FARMINGTON CouncIJ Check: SWllI1IaJy 11nl2011 - 11/20/2011 ; Check # Date 118091 1111012011 118082 11/1012011 118093 11/1012011 118084 1111012011 118086 1111 012011 118086 11/1012011 118097 11/10/2011 118098 1111012011 118099 11/1012011 Amount Supplier I Explanation PO# Doll No lnv No 8U Obi Sub Subledger Account Descriptlon 109433 DIRKS, BREANNA 40_34 MEAlS-MN SEX CRIMES CONFERENCIB459O OCTOBER 2011 40.34 1052 6470 100115 DSG-DAKOTASUPPLYGROUP 1,168.46 ORION WATER METERS 00014314 104271 70905891REF70 309.52 WlR METER EQUIP 104272 7092539 . 1,477.98 6502 6220 6502 6220 100240 DYNAMEX 66.65 DELIVERY CHARGE 1011912011 66.65 104699 1018418 6502 6401 112a48 ECRS CORPORATION 2.003.90 SUPPORT,UPGRADE RENEWAL 1,603.12 SFfWR UPDT UC, UQ STR 3,607.02 104449 QT#FLES1101111 6110 6505 104448 QT#FLPK110111SR 6115 6505 102808 EDINA REALTY 74.65 20900 CATALINA WAY OVERPYMT 104631 20900 CATALINA 6200 13103 74.65 100022 FARMINGTON PRINTING INC 74.81 OFFICE SUPPUES. PAPER 104285 8819 74.81 1010 6210 100104 FARMINGTON, CITY OF 12.89 PETIY CASH R8MB 104664 PETIY CASH REM 1021 6485 12.00 PET1Y CASH R8MB 104664 PET1Y CASH REM 1031 6470 9.ffl PETIY CASH R8MB 104664 PETIY CASH REM 1051 6470 5.00 PETIY CASH REIMB 104664 PET1Y CASH REM 1076 6470 26.93 PETIY CASH REIMB 104664 PETIY CASH REM 1095 6570 2.01 PETIY CASH REIMB 104664 PETIY CASH REM 2000 7420 5_67 PETIY CASH REIMB 104664 PETTY CASH REM 6502 6250 134.17 111431 FERGUSON WATERWORKS 220.27 SERVICE REPAIR 104270 $01335763.001 6502 6250 220.27 101354 FIREHOUSE 28 TRAINING &SUBSlSTANCE EQUIP SUPPUES & PARTS EQUIP SUPPUES & PARTS PROFESSIONAL SERVICES EQUIPMENT REPAIR SERVICE EQUIPMENT REPAIR SERVICE 8UDescription INVESTIGATION SERVICES WATER UllUTY EXPENSE WATER UllUTY EXPENSE WATER UTILITY EXPENSE 11/171201110:35:49 Page - 4 co Dept DlV 01000 05 08500 08 08500 08 06500 08 DOWNTOWN UQUOR REV & EXP 08100 02 PILOT KN08 UQUOR 06100 02 ACCOUNTS RECEIVABLE UllUTI SEWER OPERATIONS OFFICE SUPPUES MILEAGE R8MBURSEMENT TRAINING & SUBSISTANCE TRAINING & SUBSISTANCE TRAINING & SUBSISTANCE PROGRAMMING EXPENSE OTHER OTHER SUPPLIES & PARTS OTHERSUPPUES & PARTS ADMINISTRATION 06200 08 01000 01 GENERAL ACCOUNTING 01000 02 BUILDING INSPECTIONS 01000 07 PATROL SERVICES 01000 05 NATURAL RESOURCES 01000 07 RECREATION PROGRAM SERVIC 01000 09 HRAIECONOMIC DEVaOPMENT 02000 03 WATER UTILITY EXPENSE 06500 08 WATER UTILITY EXPENSE 06500 08 R55CKSUM LOGISOO1V NOTE: Check Amount may not reflect actual check tola! due to sequencing of data. Check# Date 118100 11110/2011 118101 11/10J2ll11 118102 11/10J2ll11 118103 1111012011 118104 11110/2011 118105 11/10/2011 118105 11/10/2011 118107 11110/2011 Amount Supplier I Explanation ~ Doc No ~ 2.9.95 SUBSCRIPTION RENEWAL AREH0USlD4581 143286 2.9.95 11113& FORMS & SYSTEMS OF MINNESOTA 373.00 THERMAL ROLLS WI PERF 104591 124210 373.00 2,265.81 2,265.81 112296 FRATTALONEAND ASSOCIATES.INC ICE ARENA SOUND SYSTEM 104688 13472 111087 FRONTIERAG&TURF 40_16 BARLUBE 104276 P23680 40_16 CITY OF FARMINGTON CoundI Check SlIIl1lIlllIy 11n/2011 - 11/2012011 BU Obj Sub 1060 6460 1051 6210 4501 6401 1090 6220 100276 HARTFORD UFE 838.50 2012 SPECIAL RISK POLCY RNWL 104655 POUCY#41-VP-24 1000 1505 838..50 71,695.91 71,695.91 100281 HEALTHPARTNERS NOV'11 INSURANCE PREMIUMS 104678 38730440 N0V'11 7000 6158 107688 HENTGES AND SONS 1Ne, S.M. 1,169_49 PYMT#101F1NAL WALNUT ST PROJEC104634 PYMT#101F1NAL W 4119 7010 1,169.49 100074 HOHENSTEJNS INC 81.00 WlNElSPIRITS 135..00 WINE 216_00 104651 578541 104624 578540 109846 J J TAYLOR DISTRIBUTING CO OF 48.00- CM PROMOTION HALlOWEEN 104587 1617487 2,900.10 BEER 104644 1651067 53.00- CM PROMOTION HALlOWEEN 104586 1617486 3,353.05 BEER 104653 1651066 6,152.15 118108 1111012011 100031 JIRIK SOD FARMS!NC 1,650.00 MISC ESCROW REPAIRS 500_00 ASBUIlT REPAIR 104609 26387 104610 24849 6110 5502 6115 5502 6110 5502 6110 5502 6115 5502 6115 5502 7500 2255 7500 2255 29 Subledger Account Description SUBSCRIPTIONS & DUES OFFICE SUPPUES PROFESSIONAL SERVICES EQUIP SUPPUES & PARTS PREPAID EXPENSES EMPLOYEE BENEFITS CONSTRUCTION CONTRACTS COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD DEPOSITS PAYABLE DEPOSITS PAYABLE 11/17/201110:35:49 Page - 5 BUDescrIptlon ARE SERVICES Co Dept DIY 01000 06 PATROL SERVICES 01000 05 ARENA EQUIPMENT BOND 2010 04500 09 PARK MAINTENANCE 01000 09 GENERAL FUND BAlANCE SHEE 01000 EMPLOYEE EXPENSE FUND 07000 02 WALNUTSTRECONSTRUCTlON 04100 07 DOWNTOWN UQUOR REV & EXP 06100 02 PILOT KNOB UQUOR 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 PILOT KNOB UQUOR 06100 02 PILOT KNOB UQUOR 06100 02 ESCROW FUND ESCROW FUND 07500 02 07500 02 R55CKSUM LOGISOO1V NOTE: Check Amount may not reflect actual check tolaI clue to sequencing of data. ,Check # Date 118108 1111012011 118110 11/1012011 118111 11/10/2011 118112 11110/2011 118113 11/10/2011 118114 11/10/2011 118115 11/10/2011 Amount SUppUer 1 ExplanatIon 2,150.00 PO# Doc No Jnv No 100033 JOHNSON BROTHERS UQUOR CO 22.46 B&J STRAW DAQ 104597 1165482 1,137.64 WINElSPIRITS 104598 1165481 1,070.57 SPIRITS 104699 1165480 886.99 WINElSPIRITS 104600 1165479 28.92 SAUZA MARG MIX 104601 1165478 29.25 MISSISSIPPI MUD BEER 104602 11654n 736.48 WINE 104603 1165476 1,803.36 SPIRITS 104604 1165475 1.47 RM WB CHARDONNAY 104605 1165240 12,314.18 SPIRITS 104622 1167674 214.70 WINE 104623 1167675 12,003_39 SPIRITS 104627 1167286 92..69 WINE 104628 1167287 30,342.10 100490 KEYLAND HOMES 751.60 19862 DOVER DR OVRPYMNT 751.60 104715 19862 DOVER DR 6200 13103 ACCOUNTS RECEIVABLE UTlUTI SEWER OPERATIONS 06200 08 100121 LEAGUE OF MINNESOTA cmES 875.00 STRMWTRCOAL9/1/11-8/31/12 104578 155478 875.00 101275 UBERTY TIRE RECYCUNG, LLC 196.80 TlRERECYCUNGSRVS 104194 63457 196.80 108715 LUBRICATION TECHNOLOGIES,INC 876.21 OIL,l.UBRlCATlON 104500 1968938 876.21 100063 MACQUEEN EQUIPMENT, INC 3,558.26 VEHICLE PRTS 104492 5-11434 41.31 VEHICLE PRTS 104493 2115755 3,599.57 100075 2,759.22 BEER 60.20 BEER NA MARK VII DISTRIBUTORS INC 104650 B20280 104645 820284 Cl1Y OF FARMINGTON CouncIl Check Summary 11/712011 - 11/20/2011 BU Obj SUb SubJedger Account Description 6110 5502 6110 5502 6110 5502 6110 5502 6110 5502 6110 5502 6110 5502 6110 5502 6110 5502 6110 5502 6110 5502 6115 5502 6115 5502 COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD 64Q5. 6401 PROFESSIONAL SERVICES 6302 6401 PROFESSIONAL SERVICES 7200 6274 LUBRICANTS & ADDITIVES 6202 6230 6402 6230 VEHICLE SUPPUES & PARTS VEHICLE SUPPUES & PARTS 6110 5502 6115 5502 COST OF GOODS SOLD COST OF GOODS SOLD 30 11/17/20111 0:35:49 Page - 6 BU Description Co Dept Dlv DOWNTOWN UQUOR REV & EXP 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 PILOT KNOB UQUOR 06100 02 PILOT KNOB UQUOR 06100 02 NPDes Phase II 06400 08 SOUD WASTE OPERATIONS 06300 08 FLEET OPERATIONS 07200 08 SEWER OPERATIONS EXPENSE 06200 08 STORM WATER UTILITY OPERA 06400 08 DOWNTOWN UQUOR REV & EXP 06100 02 PILOT KNOB UQUOR 06100 02 R55CKSUM LOGISOO1V NOTE: Check Amount may not reflect aclual check tolaI clue to sequencing of data. CITY OF FARMINGTON Council Cheok 5ummaJy Check,. Date 11n/2011 - 11/20/2011 Amount SuppRer / ExpfanaIlon 5,096_35 BEER 7,915.77 PO# Doc No Inv No -- 104646 820283 ~ Obj Sub 6115 5502 118116 11/10/2011 118117 11/1012011 118118 11/10/2011 118119 11/1012011 118120 11/1012011 118121 11/10/2011 118122 11/10/2011 118124 1111012011 118125 11/1012011 100527 METRO ALARM CONTRACTORS INC 256.34 N0V'11 MONITORING FEES 104621 014175 256.34 N0V'11 MONITORING FEES 104620 014176 N0V11 512.68 6110 6401 6115 6401 100165 METROPOUTAN COUNCIL ENVIRO SS 15,453.90 0Cl'11 SAC FEES 104611 OCT'11 SAC CHAR 6201 5030 15,453.90 100084 MINNESOTA DIiPT OF PUBUC SAFET 20.00 APPL FOR BUYER'S CARD 2012 104657 6517 MooFSL 201 6100 1505 20.00 APPL FOR BUYER'S CARD 2012 104658 8143 MOOFSL 6100 1505 40.00 100070 MVTL- MlNN VALLEY TESTING LABS 31.25 10114 WATER TEST REPORT 104142 573446 31.25 6502 6401 112030 NAPA AUTO PARTS 73_72 SERP BELTIORIVE BELT 73.72 104563 018082 1051 6230 110937 NODLAND CONSTRUCTION CO..INC 9,900.09 PYMT#8/FINAL 2009 TRNK U1lL 1M 104635 PYMT#SlFINAL 20 4400 7010 9,900.09 101254 ORKIN EXTSRMJNATING 91_13 PEST CONTROL-5446 195TH ST 104700 68187328 91_13 6502 6401 2,751.42 1.47 2,090.66 33.72 4,877.27 100034 UQUOR FREIGHT CHARGE-VODKA WINE CUERVO MARG MIX 5502 5502 5502 5502 PHILUPS WINE AND SPIRITS INC 104595 2147065 104596 2146948 104606 2147066 104607 2147057 6110 6110 6110 6110 1D246S PRAIRIE RESTORATIONS INC 863.40 OCT3,10WEEDCTRL 104308 0018432 1090 6401 31 Subledger AccoW'lt DesorIption COST OF GOODS SOLD PROFESSIONAL SERVICES PROFESSIONAL SERVICES SAC CHARGE RETAINER PREPAID EXPENSES PREPAID EXPENSES PROFESSIONAL SERVICES VEHICLE SUPPUES & PARTS CONSTRUCTION CONTRACTS PROFESSIONAL SERVICES COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD PROFESSIONAL SERVICES BUDescription PILOT KNOB UQUOR 11/17/201110:35:49 Page - 7 ~ Dept Dlv 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 PILOT KNOB UQUOR 06100 02 SEWER OPERATIONS REVENUE 06200 08 UQUOR OPERATIONS UQUOR OPERATIONS WATER UTIUlY EXPENSE PATROL SERVICES STORM WATER TRUNK WATER UTILITY EXPENSE 06100 02 06100 02 06500 08 01000 05 04400 07 055D0 08 DOWNTOWN UQUOR REV & EXP 08100 02 DOWNTOWN UQUOR REV & EX? 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 DOWNTOWN UQUOR REV & EX? 06100 02 PARK MAINTENANCE 01000 09 R55CKSUM LOGISOO1V NOTE: Checlc AmOunt may not reflect actual checlc to1aJ due to Gequencing of data. : Check # Date 118126 1111012011 118127 1111012011 118128 1111012011 118129 1111012D11 118130 1111012011 118131 11/1012011 118132 1111012011 118133 1111012011 118134 1111Df2D11 Amount suppner / Explanation 863.40 PO# Doc No Inv No 100076 QUALITY WINE AND SPIRITS CO 1,440.10 WINE 104583 515520-00 18.50 SEAGRAMBLACKCHERRY 104618 531179-CO 196.41 BARTON VODKAlTOOTER RAINBOW 104619 531179-00 902.46 SPIRITS 104629 531205-00 1,584.10 WINE 104588 515521-00 4,141.57 100125 R&R SPECIALTIES OF WISCONSIN I 538.69 OLYMPIA BLADES, 84" 104277 0048491-IN 538.69 100738 SMICK, LEE 25.00 SEMINAR FEElMILEAGE REIMB 27.14 SEMINAR FEElMlLEAGE RaMB 52.14 CITY OF FARMINGTON CoW'lC!l Checlc SUmmaly 1117/2011 - 1112012011 BU Obj SUb SUbIecIger Acoount Description 6110 5502 6110 5502 6110 5502 6115 5502 6115 5502 COST OF GOODS SOW COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD 2502 6220 EQUIP SUPPUES & PARTS 104630 11082011 EX? RE 1030 6470 104630 11082011 EX? RE 1030 6485 TRAINING & SUBSlSTANCE MIlEAGE RaMBURSEMENT 112051 SOUTHERN WINE & SPIRITS OF MHo 1,852.68 WlNElSPIRITS 104642 1617817 .29 WlNElSPIRlTS 104643 1617800 677.90 WINE 104654 1617801 2,530_87 6110 5502 6110 5502 6115 5502 COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD 112346 TRANS ALARM SECURITY SERVICES 162.00 LOCK SERVICES 104675 SVLllS2542 2502 6401 162.00 PROFESSIONAL SERVICES 1D0114 UNlVERSlTY OF MINNESOTA 600.00 2012 CONFERENCE REGISTRATION 10465S 11082011 2012 C 1000 1505 600.00 103478 WENDLANDT, BRENDA 293.76 MILEAGE REIMBURSEMENT 104593 JUL-OCT 2011 293.76 100334 WlNEMERCHANTS 259_68 WINE 259.68 104608 383321 102071 W1NGFOOT COMMERCIAL TIRE PREPAID EXPENSES 1011 6485 MILEAGE REIMBURSEMENT 6110 5502 COST OF GOODS SOLD 32 11117/201110:35:49 Page - 8 BUDescrlpllon Co Dept Dlv DOWNTOWN UQUOR REV & EX? 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 PILOT KNOB UQUOR 06100 02 PILOT KNOB UQUOR 06100 02 ICE ARENA OPERATIONS EXPE 02500 09 PLANNING & ZONING PLANNING & ZONING 01000 03 01000 03 DOWNTOWN UQUOR REV & EXP 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 PILOT KNOB UQUOR 06100 02 ICE ARENA OPERATIONS EXPE 02500 09 GENERAL FUND BALANCE SHEE 01000 HUMAN RESOURCES 01000 04 DOWNTOWN UQUOR REV & EXP 08100 02 R55CKSUM LOGlSOO1V NOTE: Check Amount may not reflect actual check totaJ due to sequenclng of data. Check # Date 118135 1111012011 118136 11/18J2011 118137 11118/2011 118138 11118/2011 118138 11118/2011 118140 1111812011 118141 11118/2011 118142 11118/2011 Amount Supplier I ExplanatIon 204.41 VEHICLE WHL MTG 204.41 PO# Doc No Inv No -- 104494 124-1059328 110892 WIRTZ BEVERAGE MINNESOTA 2,040.03 SPIRITS (SHIPPED 11l2J2011) 104647 653472 578.96 WINE 104648 654614 425.69 WINE 104625 654615 2,651_11 SPIRITS 104626 653475 5,695_79 100160 AFFINITY PLUS FEDERAL CREDIT U 104746 111611931023 1,635.00 1,635.00 100182 AGGREGATE INDUSTRIES /HC 40.72 10128 CL5 SAND/GRVL, SEWER 104754 2038216 40.72 100424 ARCTIC GLACIER ICE 59.44 ICE CUBE ORDER 59.44 104830 396131107 112190 BARR ENGINEERING COMPANY 6,158.64 PH 1 HYDROLGCMDLNGNRTI-I CRK 104710 23191116_.0Q.5 6,158.64 310.21 2.15- 94.49 568.25 105_70 1,076_50 100483 BaJ.BOY CORPORA nON WINE & SPIRITS ORDER DOLE PINE, DEFECTIVE JUICE,MIX, BAR SUPPUES WINE & SPIRITS ORDER JUICE,M1X, BAR SUPPUES 70839200 85958300 CM 85990400 70839300 85990500 104845 104848 104849 104846 104847 103.91 103_91 100176 BELZER'S CHEVlDODGEIKIA, JEFF HOSE KIT 104704 297691 111280 BERNICK'S WINE 112.00 BOXER BEER ORDER 32.00 UQ ICE BEER ORDER 280_00 ax LG BEER ORDER 104835 37174 104835 37173 104833 37176 CITY OF FARMINGTON COUnclI Check Summary 111712011 - 1112Ol2011 BU Obj SUb 6302 6230 6110 5502 6110 5502 6115 5502 6115 5502 7000 2130 6202 6250 6110 5502 6402 6401 6110 6110 6110 6115 6115 5502 5502 5502 5502 5502 6202 6230 6110 5502 6110 5502 6115 5502 33 Subledger Account DescrlptIon VEHICLE SUPPUES & PARTS COST OF GOODS SOLO COST OF GOODS SOLO COST OF GOODS SOLO COST OF GOODS SOLO CREDIT UNION PAYABLE OTHER SUPPUES & PARTS COST OF GOODS SOLO PROFESSIONAL SERVICES COST OF GOODS SOLO COST OF GOODS SOLO COST OF GOODS SOLO COST OF GOODS SOLD COST OF GOODS SOLD VEHICLE SUPPUES & PARTS COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLO 11/171201110:35:49 Page- 9 BU Descrlptlon SOUD WASTE OPERA nONS Co Dept Dlv 06300 08 DOWNTOWN UQUOR REV & EXP 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 PILOT KNOB UQUOR 06100 02 PILOT KNOB UQUOR 06100 02 EMPLOYEE EXPENSE FUND 07000 02 SEWER OPERA nONS EXPENSE 06200 08 DOWNTOWN UQUOR REV & EXP 08100 02 STORM WATER UTILITY OPERA 06400 08 DOWNTOWN UQUOR REV & EXP 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 PILOT KNOB UQUOR 06100 02 PILOT KNOB UQUOR 06100 02 SEWER OPERATIONS EXPENSE 06200 08 DOWNTOWN UQUOR REV & EXP 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 PILOT KNOB UQUOR 08100 02 R55CKSUM L.OGISOO1V NOTE: Check Amount may not reflect aduaJ check total due to sequenclng ot data.. . Check # Date 118143 11/1812011 118144 11/1812011 . 118148 11/1812D11 118144 11/1812D11 118147 11/1812011 118148 11/1812011 Amount SUppUer 1 ExpIanaIIon 32.00 UQ ICE BEER ORDER 456.00 PO# Doc No Inv No -- 104834 37175 1D8380 CANNON RIVER WINERY 738_00 WINE ORDER 104850 3898 738.00 CITY OF FARMINGTON CouncR Check SUmmaIy 11n12011 - 11I20I2011 BU ObJ SUb SUbledger Account DescrIptlon 6115 5502 COST OF GOODS SOW 6110 5502 COST OF GOODS SOW 100418 CNH CAPITAL 457.43 NOV'11 LEASEPYMT -NEWHOL.SKlD 104673 06045001 NOV'11 1072 6555 457_43 100071 COLLEGE CITY BEVERAGE INC 4,471.40 BEER,At.ES,MAL.TUQ 10482B 271841 5,555.55 BEER,At.ES,MAL.T UQ 104829 271848 10,026.95 107406 CONBOY, WENDY 18.90 JURY DTY MILEAGE REMB 18.90 RENTAl. OF EQUIPMENT 6110 5502 6115 5502 COST OF GOODS SOW COST OF GOODS SOW 104811 NOV2,3 MILEAGE 1031 6485 M/LEAGE REIMBURSEMENT 103925 CONSTANTINEAU, JAMES 48.20 REMB PP PH CRO, INVSTGTN 104814 NOV 11 EXP RaM 1052 6250 48.20 109729 CRESCENT ELECTRIC SUPPLY CO 95.69 LEe GE SUM-LN lAMPS (36) 104734 024-231961-00 82.16 GE MH LAMPS (12) 104733 024-231619-00 143.19 Ft.UOR BUl.BS 104732 024-231878-00 53.84 Ft.UOR BUl.BS 104731 024-232000-00 26.92 Ft.UOR BUl.BS 104731 024-232000-00 .71.59 Ft.UORBUl.BS 104732 024-231878-00 41.08 GE MH LAMPS (12) 104733 024-231619-00 47.84 LEC GE SUM-LN lAMPS (as) 104734 024-231961-00 8.97 Ft.UOR BUl.BS 104731 024-232000-00 23.86 Ft.UOR BUl.BS 104732 024-231878-00 15.95 LEe GESUM-LN lAMPS (36) 104734 024-231961-00 13.69 GE MH LAMPS (12) 104733 024-231619-00 8.22 GE MH lAMPS (12) 104733 024-231619-00 9.57 LEe GE SUM-LN LAMPS (36) 104734 024-231961-00 14.32 Ft.UOR BUl.BS 104732 024-231878-00 5.38 Ft.UOR BUl.BS 104731 024-232000-00 5_38 Ft.UOR BUl.BS 104731 024-232000-00 OTHER SUPPUES & PARTS 1015 6240 1015 6240 1015 6240 1015 6240 1050 6250 1050 6250 1050 6250 1050 6250 1060 6240 1060 6240 1080 6240 1060 6240 1072 6240 1072 6240 1072 6240 1072 6240 1090 6240 BUIWING SUPPUES & PARTS BUIWING SUPPUES & PARTS BUIWING SUPPUES & PARTS BUIWING SUPPUES & PARTS OTHER SUPPUES & PARTS OTHER SUPPUES & PARTS OTHER SUPPUES & PARTS OTHER SUPPUES & PARTS BUIWING SUPPUES & PARTS BUIWING SUPPUES & PARTS BUIWING SUPPUES & PARTS BUIWING SUPPLIES & PARTS BUIW/NG SUPPUES & PARTS BUIWING SUPPUES & PARTS BU/WING SUPPUES & PARTS BUIWING SUPPUES & PARTS BUIWING SUPPUES & PARTS 34 BU Description PIt.OT KNOB UQUOR 11117120111 0:35:49 Page- 10 Co Dept Div 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 STREET MAINTENANCE 01000 08 DOWNTOWN UQUOR REV & EXP 06100 02 PIt.OT KNOB UQUOR 06100 02 BUIWING INSPECTIONS INVESTIGATION SERVICES CITY HALL CITY HALL CITY HALL CITY HALL POUCE ADMINISTRATION POUCE ADMINISTRATION POUCE ADMINISTRATION POUCE ADMINISTRATION ARE SERVICES ARE SERVICES ARE SERVICES ARE SERVICES STREET MAINTENANCE STREET MAINTENANCE STREET MAINTENANCE STREET MAINTENANCE PARK MAINTENANCE 01000 'Jl 01000 05 01000 01 01000 01 01000 01 01000 01 01000 05 01000 05 01000 05 01000 05 01000 06 01000 06 01000 06 01000 08 01000 08 01000 08 01000 08 01000 08 01000 09 R55CKSUM LOGISOO1V NOTE: Check Amount may not reflect actual check total due to sequencing of data CITY OF FARMINGTON COUncil Check SUmmaIy 11/17/201110:35:49 Page - 11 11/7/2011 - 11120/2011 Check # Date Amount Supplier / explanation PO# Doc No Inv No au Obj Sub Subleclger Account DescrIption BUDescrIptlon CODept DiY -- 14.32 FLUOR BULBS 104732 024-231878-00 1090 6240 BUILDING SUPPUES & PARTS PARK MAINTENANCE 01000 09 9.57 LEC GE SUM-LN LAMPS (36) 104734 024-231961..00 1090 6240 BUILDING SUPPUES & PARTS PARK MAINTENANCE 01000 09 8.22 GE MH LAMPS (12) 104733 024-231619-00 1090 6240 BUILDING SUPPUES & PARTS PARK MAINTENANCE 01000 09 27_39 GE MH LAMPS (12) 104733 024-231619-00 2410 6240 BUILDING SUPPUES & PARTS SENIOR CENTER PROGRAMS 02400 09 47.73 FLUOR BULBS 104732 024-231878-00 2410 6240 BUILDING SUPPUES & PARTS SENIOR CENTER PROGRAMS 02400 09 31.90 LEC GE SUM-LN lAMPS (36) 104734 024-231961-00 2410 6240 BUILDING SUPPUES & PARTS SENIOR CENTER PROGRAMS 02400 09 17.95 FLUOR BULBS 104731 024-232000-00 2410 6240 BUILDING SUPPUES & PARTS SENIOR CENTER PROGRAMS 02400 09 31_90 LEC GE SUM-LN LAMPS (36) 104734 024-231961..00 2502 6240 BUILDING SUPPUES & PARTS ICE ARENA OPERATIONS EXPE 02500 09 47.73 FLUOR BULBS 104732 024-231878-00 2502 6240 BUILDING SUPPUES & PARTS ICE ARENA OPERATIONS EXPE 02500 09 27.39 GE MH LAMPS (12) 104733 024-231619-00 2502 6240 BUILDING SUPPUES & PARTS ICE ARENA OPERATIONS EXPE 02500 09 17.95 FLUOR BULBS 104731 024-232000-00 2502 6240 BUILDING SUPPUES & PARTS ICE ARENA OPERATIONS EXPE 02500 09 13.46 FLUOR BULBS 104731 024-232000-00 6202 6240 BUILDING SUPPUES & PARTS SEWER OPERATIONS EXPENSE 06200 08 23.92 LEe GE SUM-LN LAMPS (36) 104734 024-231961..00 6202 6240 BUILDING SUPPUES & PARTS SEWER OPERATIONS EXPENSE 06200 08 20.54 GE MH LAMPS (12) 104733 024-231619-00 6202 6240 BUILDING SUPPUES & PARTS SEWER OPERATIONS EXPENSE 06200 08 35.80 FLUOR BULBS 104732 024-231878-00 6202 6240 BUILDING SUPPUES & PARTS SEWER OPERATIONS EXPENSE 06200 08 13.46 FLUOR BULBS 104731 024-232000..00 6302 6240 BUILDING SUPPUES & PARTS SOUD WASTE OPERATIONS 08300 08 36.80 FLUOR BULBS 104732 024-231878-00 6302 6240 BUILDING SUPPUES & PARTS SOUD W~ OPERATIONS 06300 08 20.54 GE MH LAMPS (12) 104733 024-231619-00 6302 6240 BUILDING SU?PUES & PARTS SOUD WASTE OPERATIONS 08300 08 23_92 LEC GE SUM-LN LAMPS (36) 104734 024-231961-00 6302 6240 BUILDING SUPPUES & PARTS SOUD WASTE OPERATIONS 06300 08 4.77 LEC GE SUM-LN LAMPS (36) 104734 024-231961..00 6402 6240 BUILDING SUPPUES & PARTS STORM WATER UTILITY OPERA 06400 08 4_10 GE MH LAMPS (12) 104733 024-231619-00 6402 6240 BUILDING SUPPUES & PARTS STORM WATER UTILITY OPERA 06400 08 2.71 FLUOR BULBS 104731 024-232000-00 6402 6240 BUILDING SUPPUES & PARTS STORM WATER UTILITY OPERA 06400 08 7.15 FLUOR BULBS 104732 024-231878-00 6402 6240 BUILDING SUPPUES & PARTS STORM WATER UTILITY OPERA 06400 08 35.80 FLUOR BULBS 104732 024-231878-00 8502 6240 BUILDING SUPPUES & PARTS WATER UTILITY EXPENSE 06500 08 13.46 FLUOR BULBS 104731 024-232000-00 8502 6240 BUILDING SUPPUES & PARTS WATER UTILITY EXPENSE 06500 08 20.54 GE MH LAMPS (12) 104733 024-231619-00 6502 6240 BUILDING SUPPUES & PARTS WATER UTILITY EXPENSE 06500 08 23.92 LEe GE SUM-LN LAMPS (36) 104734 024-231961..00 6502 6240 BUILDING SUPPUES & PARTS WATER UTILITY EXPENSE 06500 08 1,249.59 118149 11/18/2011 100072 DAY DISTRIBUTING co 204_95 BEER,ALES, MALT UQ 104852 625300 6110 5502 COST OF GOODS SOLD DOWNTOWN UQUOR REV & EXP 06100 02 137_75 BEER,ALES, MALT UQ 104851 625301 6115 5502 COST OF GOODS SOLD PILOT KNOB UQUOR 08100 02 342.70 118160 11/18/2011 112364 DOKKEN, NELS & CHRISTEN 80.00 REF DUP PERMIT 104813 PRMT 31732 REF 1001 4327 ELECTRIC PERMITS GENERAL FUND REVENUES 01000 01 80.00 118161 11118/2011 109772 DONNELLY JR. ROBERT J. 390.00 REIMB STRM SEWER CLEANING 104756 JUL29 DRAIN SR 6402 6401 PROFESSIONAL SERVICES STORM WATER UTILITY OPERA 06400 08 390.00 35 ... . ......--........-....-.------.. . _ __n______._~_,____ ...--.----.--.---- . R55CKSUM LOGISOO1V NOTE: Check Amount may not reflect actual check tolaJ due to sequencing of data. CITY OF FARMINGTON CouncIJ Check Swrnnary 11fl/2011 - 11l2012D11 'Check # Date .-- 118152 1111812011 118163 1111812011 118154 11/1812011 118155 11/1812011 118156 11/1812011 118157 11/1812011 118158 11/1812011 118158 11/1812011 . 118160 11/1812011 Amount SuppDer / ExplanatIon PO# Doc No ~ 100115 DSG-DAKOTASUPPLYGROUP FLANGE SETS 104707 7100996 BU ObJ Sub Subledger Account Description 171.55 171.55 6502 6220 EQUIP SUPPUES & PARTS 100149 ECM PUBUSHERS lNC 139.50 THJSWEEK COUPON SPECIALS AD 104584 TI 00383205 139.50 THJSWEEKCOUPON SPECIALS AD 104584 TI 00383205 279.00 6110 6492 6115 6492 ADVERTISING ADVERTISING 100364 EHLERS & ASSOCIATES lNC 7,000.00 AMS,HRA PUB PR.l RV BD, 2001A 104760 61905 HRA RV BD 3097 7120 7,000.00 DEBT INTEREST 107128 EXTREME BEVERAGE LLC 212.00 REDBULL ENERGY DRNJ<S 104832 124-14 157.50 REDBULL ENERGY DRNKS 104831 W-454770 369.50 6110 5502 6115 5502 COST OF GOODS SOLD COST OF GOODS SOLD 100042 FARMINGTON COMMUNITY EDUCATION 136.00 NOV 1-15 NTES GYM USAGE 104815 PERMIT#1107-D14 1095 6570 136.00 PROGRAMMING EXPENSE 100168 FARMINGTON EMPLOYEE CLUB 104740 1116119370211 EMPLOYEE CLUB 40.00 40.00 7000 2121 100022 FARMINGTON PRINTING lNC 642.50 NEWSLEifERS 104702 8831 642.50 NEWSLETTERS 104702 8831 642.50 NEWSLETTERS 104702 6831 642.50 NEWSLEifERS 104702 6831 2,570.00 6202 6450 6302 6450 6402 6450 6502 6450 OUTSIDE PRINTING OUTSIDE PRINTING OUTSIDE PRINTING OUTSIDE PRINTING 108507 FLAHERTrS HAPPYTYME COMPANY 92.40 UQ&BEVMIXORDER 104839 24826 92.40 UQ & BEV MIX ORDER 104840 24825 184_80 6110 5502 6115 5502 COST OF GOODS SOLD COST OF GOODS SOLD 100077 FRONTIER COMMUNICATIONS 17.76 N0V11 FAX UNE, PO 104773 6514633122 NOV' 7400 6411 17_76 TELEPHONE 36 11/171201110:35:49 Page - 12 BU Descripllon Co Dept Div WATER UTIUlY EXPENSE 06500 08 DOWNTOWN UQUOR REV & EXP 06100 02 PILOT KNOB UQUOR 06100 02 PUBUC PROJECT REFUND BD 03097 02 DOWNTOWN UQUOR REV & EXP 06100 02 PILOT KNOB UQUOR 06100 02 RECREATION PROGRAM SERVlC 01000 09 EMPLOYEE EXPENSE FUND 07000 02 SEWER OPERATIONS EXPENSE 06200 08 SOUD WASTE OPERATIONS 06300 08 STORM WATER UTIUlY OPERA 06400 08 WATER UTIUlY EXPENSE 06500 08 DOWNTOWN UQUOR REV & EXP 06100 02 PILOT KNOB UQUOR 06100 02 INFORMATION TECHNOLOGY 07400 04 R55CKSUM LOGlSOO1V CITY OF FARMINGTON 11/171201110:35:49 NOTE: Check Amount may not reflect actual check tataI due to sequencing of data. CotmOil Check SWnmary Page - 13 11"12011 - 11120/2011 Check # Date Amount SUppDer I explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept DIv -- 118181 11/18/2011 100018 GERSTER JEWElERS 2.Q&. 104769 MAY'11 ADMIN PL 1000 2415 MN SALES TAX DUE GENERAl.. FUND BALANCE SHEE 01000 32.06 HERLOFSKY PLAQUE 104769 MAY'11 ADMIN PL 1011 7420 OTHER HUMAN RESOURCES 01000 04 30.00 118182 11/18/2011 102248 GILMEREXCAVATlNG,INC 224.43 10126 BRUSH PILE CLEANUP 104396 102611 4600 6401 PROFESSIONAL SERVICES PRIVATE CAPITAL PROJECTS 04600 07 136.80 1OlO5MOWINGSRVS,184TH,187TH 104397 100511 4600 6401 PROFESSIONAL SERVICES PRIVATE CAPITAL PROJECTS 04600 m 361.23 1181&3 11/18/2011 111738 GREAT AMERICAN MARINE INC 425_55 REPAIRS TO FIRE EQUIP 104792 110711 1060 6505 EQUIPMENT REPAIR SERVICE FIRE SERVICES 01000 06 425_55 118184 11/18/2011 112381 HANSON, BRIAN 1,000_00 CURB/BRK SURETY REFND 104720 REFR CK 5805 7500 2255 DEPOSITS PAYABLE ESCROW FUND m500 02 1.000_00 118185 11/18/2011 100739 HENNEPIN TECHNICAL COLLEGE 20_00 APPL FEE-TRAVIS PUGUESE 104548 00239753 1060 6470 TRAINING & SUBSISTANCE ARE SERVICES 01000 06 20_00 APPL FEE-AASA JUST 104549 00239749 1060 6470 TRAINING & SUBSISTANCE ARE SERVICES 01 000 06 20.00 APPL FEE-UNOA THELEN 104550 00239750 1060 6470 TRAINING & SUBSlSTANCE ARE SERVICES 01000 06 20.00 APPL FEE-DANla KUYKENDALl 104551 00239752 1060 6470 TRAINING & SUBSISTANCE FIRE SERVICES 01000 06 80.00 118185 11/18/2011 100074 HOHENSTElNS INC 485_80 BEER,ALES, MALT UQ 104854 579609 6110 5502 COST OF GOODS SOLD DOWNTOWN UQUOR REV & EXP 06100 02 85.50 BEER,ALES, MALTUQ 104855 579608 6110 5502 COST OF GOODS SOLD DOWNTOWN UQUOR REV & EXP 06100 02 269.40 BEER,ALES, MALT UQ 104853 579606 6115 5502 COST OF GOODS SOLD PILOT KNOB UQUOR 06100 02 840_70 118167 11/18/2011 110008 HUNTING SHACK INC, THE 314.50- 104822 49665 1000 2415 MN SALES TAX DUE GENERAL FUND BALANCE SHEE 01000 4,889.11 REMAN AMMO 104822 49665 1051 6250 OTHER SUPPUES & PARTS PATROL SERVICES 01000 05 4,574.81 1181&8 11/18/2011 100181 leMA RETlREMENTTRUST-457 6,009.12 104747 111611937024 7000 2114 ICMAPAYABLE EMPLOYEE EXPENSE FUND mooD 02 2,856.50 104748 111611937025 7000 5325 ICMA EMPLOYEE EXPENSE FUND mooo 02 8,865.62 118169 11/18/2011 107897 IKON OFFICE SOLUTIONS 37 -- - .-..".~------_._, Y""-'---.-.-. _~________'_'~M* ~_"" . ..-..--'--.- R55CKSUM LOGISOO1V NOTE: Check Amount may not reflect actua1 check total due to sequencing of data. Check# Date 118170 11/1812011 118171 11/1812011 118172 11/1812011 118174 11/1812011 Amount Supplier, ExpIanallon 418.96 N0V11 EQUIP SRVS 418.96 PO/I. Doc No Inv No -- 104770 5021244142 103957 INTERNAL REVENUE SERVICE 104742 1116119370213 670.20 670.20 285.00 124.00 285.00 507_00 1,201.00 100128 .J G WEAR SHIRTS FOR PARKS SWTSHIRTS, PARKS SHIRTS FOR ARENA SWTSHIRTS, ARENA 104788 98223 104789 98224 104788 98223 104789 98224 109846 .J.J TAYLOR DISTRIBUTING CO OF 1,121.00 BEER,AL.ES, MALT UQ 104837 1651106 2,452.90 8EER,A1..ES, MALT UQ 104838 1651105 3.573.90 100033 .JOHNSON BROnlERS UQUOR CO 254.70- VENDWHTZlN,WRNGSZ 104868 615901 CM 127.14- CPT MRGN, SHORT 104869 616874 CM 22..46 B&J UQ ORDER 104857 1170049 739.73 WlNEORDER 104868 1170048 73.47 E&J BRANDY ORDER 104859 1170047 262.04 WINE ORDER 104860 1170046 120.39 WINE ORDER 104861 1170046 1,182.46 SPIRITS, UQUEURS 104862 1170044 1,403.55 SPIRITS, UQUEURS 104871 1174635 788.47 WINE ORDER 104872 1174636 29.26 MISS MUD BEER ORDER 104873 1174637 202.66 E&J BRANDY ORDER 104874 1174838 1,976.94 WINE ORDER 104875 1174639 44.92 B&J UQ ORDER 104876 1174640 1.47 MALBEC WINE FRT CHRG 104877 1174407 882.69 WlNEORDER 104878 1174641 68.72- MOSCATO WINE, WRNG SZ 1114866 614997 CM 874.79 WlNEORDER 104870 1169868 326.43- CPT MRGN,SMRNF DAMAGED 104863 616246 CM 174.61 WINE ORDER 104864 1169864 1,778.89 SPIRITS, UQUEURS 104865 1169855 41.47 CABSAUVWlNEORDER 104866 1169866 CITY OF FARMINGTON Council Check SUmmary 11"12011 - 11/2012011 BU Obj SUb SUbledger Account Description 1010 6505 EQUIPMENTREPAlRSERVlCE 7000 2128 GARNISHMENT PAYABLE 1090 1090 2602 2502 6290 6290 6290 6290 UNIFORMS & CLOTHING UNIFORMS & CLOTHING UNIFORMS & CLOTHING UNIFORMS & CLOnllNG 6110 5502 6116 5502 COST OF GOODS SOLD COST OF GOODS SOLD 6110 5502 6110 5502 6110 5502 6110 5502 6110 5502 6110 5502 6110 5502 6110 5502 6110 5502 6110 5502 6110 5502 6110 5502 6110 5502 6110 5502 6110 5502 6110 5502 6116 5502 6116 5502 6116 5502 6116 5502 6115 5502 6115 5502 COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD 38 11/171201110:35:49 Page - 14 BU Descripllon ADMINISTRATION Co Dept DIv 01000 01 EMPLOYEE EXPENSE FUND 07000 02 PARK MAINTENANCE PARK MAINTENANCE ICE ARENA OPERATIONS EXPE ICE ARENA OPERATIONS EXPE 01000 09 01000 09 02500 09 02500 09 DOWNTOWN UQUOR REV & EXP 06100 02 PILOT KNOB UQUOR 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 PILOT KNOB UQUOR 06100 02 PILOT KNOB UQUOR 06100 02 PILOT KNOB UQUOR 06100 02 PILOT KNOB UQUOR 06100 02 PILOT KNOB UQUOR 06100 02 PILOT KNOB UQUOR 06100 02 R55CKSUM LOGISOO1V NOTE: Check Amount may not reflect aotual check total due to sequencing of data. Check # Date 118175 1111812011 118176 1111812011 118177 1111812011 118178 1111812011 118179 1111812011 118180 1111812011 118181 11/1812011 118182 11/1812011 Amount SUppDer 1 ExplanatIon 29.25 MISS MUD BEER ORDER 9,853.44 PO# Doc No lnv No -- 104867 1169857 CITY OF FARMINGTON CouncIl Check SUmmaIy 1117/2011 - 11I20I2011 BU ObJ Sub 6115 5502 10049tl KEYLAND HOMES 2,000.00 ANAL GRADE, LS,B5 PRKVIEW PND 104717 19862 DOVER DRI 7500 2255 2,000.00 ANALGRADE,L17,B2PRKVIEWPD 104719 19785DOVERDRI 7500 2255 4.000_00 100164 LAW ENFORCEMENT LABOR SERVICES 104750 111611937027 378.00 378.00 112363 LPS FIELD SERVICES 160.25 REF OVRPYMT ON UTIL ACCT 160.25 7000 2116 104816 19401 EVEREST P 6200 13103 109715 LUBRICATION TECHNOLOGIES,INC 1,462.20 MOBIL DaVAC SYN ATF 104703 1971637 737.08 MOBIL TRANS HD 104711 1971662 2, 199.28 107747 M.AMUNDSON LLP 563_30 TOBACCO PRDCT, BEY ORDER 147_60 BAGS FOR UQ SALES 585.67 TOBACCO PRDCT, BEY ORDER 119_70 BAGS FOR UQ SALES 1,416.27 104891 120344 104892 120345 104889 120342 104890 120343 100m MARKW DISTRIBUTORS INC 4,542.80 BEERORDER 104841 823036 15.20 COORS NlA BEER ORDER 104842 823044 8.00.. COORS LT CORRECTION 104843 000691 /REF 809 5.917_85 BEER ORDER 104844 823043 10,467.85 7200 6274 7200 6274 6110 5502 6110 6250 6115 5502 8115 6250 6110 5502 8115 5502 6115 5502 6115 5502 109425 MATTAMY (MINNESOTA) PARTNERSHI 2,000.00 ANAL GRADE, L9.B5 RlVRBEND 104718 18564 DUNBURY A 7500 2255 2,000.00 100163 MINNESOTA AFSCME COUNCIU5 104749 111611937026 808.28 808.28 7000 2115 39 SUbledger Account Description COST OF GOODS SOLD DEPOSITS PAYABLE DEPOSITS PAYABLE L.E..S DUES PAYABLE 11/17/201110:35:49 Page - 15 BU Description PILOT KNOB UQUOR Co Dept DIv 06100 02 ESCROW FUND ESCROW FUND 07500 02 07500 02 EMPLOYEE EXPENSE FUND 07000 02 ACCOUNTS RECEIVABLE UTIUT1 SEWER OPERATIONS lUBRICANTS 8. ADDITIVES LUBRICANTS 8. ADDITIVES COST OF GOODS SOLD OTHER SUPPUES 8. PARTS COST OF GOODS SOLD OTHER SUPPUES 8. PARTS COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD DEPOSITS PAYABLE 06200 08 FLEET OPERATIONS FLEET OPERATIONS 07200 08 07200 08 DOWNTOWN UQUOR REV 8. EXP 06100 02 DOWNTOWN UQUOR REV 8. EXP 06100 02 PILOT KNOB UQUOR 06100 02 PILOT KNOB UQUOR 06100 02 DOWNTOWN UQUOR REV 8. EXP 06100 02 PILOT KNOB UQUOR 06100 02 PILOT KNOB UQUOR 06100 02 PILOT KNOB UQUOR 06100 02 ESCROW FUND 07500 02 AFSCME UNION DUES PAYABLE EMPLOYEE EXPENSE FUND 07000 02 R55CKSUM LOGlSOO1V NOTE: Check Amount may not reflect actual check totaJ due to sequencing of cIala. : Check # Date . 118183 11/1812011 118184 11/1812011 118185 11/1812011 118188 11/1812011 118187 11/1812011 118188 11/1812011 118189 11/1812011 118180 1111812011 118181 11/1812011 Amount Supplier / Explanation PO#- Doc No lnv No CITY OF FARMINGTON Council Check Summary 11n/2011 - 11/20/2011 BU Obj Sub Subledger Account Description 100258 MINNESOTA DEPT OF EMPLOYMENT 7,132.37 3RD QTR UNEMPL INSUR 104146 7371762/0798874 7000 6158 7,132..37 EMPLOYEE BENEFITS 101:$1:$ MINNESOTA DEPTOF LABOR & INDU 10.00 PRESSURE VESSEL TEST, 710 1ST 104787 ABR00334171/0 1015 6401 10.00 PROFESSIONAL SERVICES 101287 MINNESOTA HOCKEY DISTRICT 8 115.00 PRGRM, RULESBKADVERT 104821 NOV'11 PRGRMIRL 2502 6450 115.00 1001611 MN CHILD SUPPORT PAYMENT CENTE 104739 1116119370210 104751 111611937028 104752 111611937028 238_11 296.72 241.80 776.63 OUTSIDE PRINTING 7000 2118 7000 2118 7000 2118 CHIlD SUPPORT PAYABLE CHIlD SUPPORT PAYABLE CHILD SUPPORT PAYABLE 1~851 MND~OF~R&mD~ 45.00 APPL BOILER UC FEE 104m BOILER UC FEE 1015 6460 45.00 100322 MN NCPERS UFE INSURANCE 16.00 104741 1116119370212 16_00 100070 MVTL- MINN VALLEY TESTING LABS 31.25 SAMPLETESTlNG 104708 574645 31.25 107597 OFFlCEMAX - A BOISE COMPANY 32..05 OFFICE SUPPUES 104763 266979 342.90 OFFICE SUPPUES 104764 266862 374.95 92.03 92.03 10.63 10.63 26.59 101254 ORKIN EXTERMINATING 10128 PST CNTRL SRVS, CITYHL 9123 PEST CTRlSRVS. CH 10128 PEST CTRLSRV, CMF 10128 PEST CTRl SRV, CMF 10128 PESTCTRLSRV, CMF 104725 69043516/7200 104726 68188426/7200 104727 69043511/7200 104727 69043511/7200 104727 69043511/7200 SUBSCRIPTIONS & DUES 7000 2119 PERA UFE INS PAYABLE 6502 6401 PROFESSIONAL SERVICES 1010 6210 1010 6210 OFFICE SUPPUES OFFICE SUPPUES 1015 1015 1072 1090 6202 6401 6401 6401 6401 6401 PROFESSIONAL SERVICES PROFESSIONAL SERVICES PROFESSIONAL SERVICES PROFESSIONAL SERVICES PROFESSIONAL SERVICES 40 11/17/201110:35:49 Page- 16 BU Desc:riptlon Co Dept Div EMPLOYEE EXPENSE FUND 07000 02 CITY HAll. 01000 01 ICE ARENA OPERATIONS EXPE 02500 09 EMPLOYEE EXPENSE FUND EMPLOYEE EXPENSE FUND EMPLOYEE EXPENSE FUND 07000 02 07000 02 07000 02 CITY HAll. 01000 01 EMPLOYEE EXPENSE FUND 07000 02 WATER UTlUlY EXPENSE 06600 08 ADMINISTRATION ADMINISTRATION 01000 01 01000 01 CITY HAll. 01000 01 CITY HAll. 01000 01 STREET MAINTENANCE 01000 08 PARK MAINTENANCE 01000 09 SEWER OPERATIONS EXPENSE 062D0 08 R55CKSUM LOGISOO1V NOTE: Check Amount may not reflect actual check total due to sequenclng of data. CITY OF FARMINGTON CouncIl Check SUmmary 11/17/201110:35;49 Page - 17 11"/2011 - 11/2012011 Check # Date Amount Supplier / Explanation PO# Doc No Inv No ~ Obj Sub Subledger Account Description BU Descrlptlon CO Dept Dlv -- 26.59 10/28 PEST CTRL SRV, CMF 104727 69043511/7200 6302 6401 PROFESSIONAL SERVICES SOUD WASTE OPERATIONS 06300 08 5.33 10128 PEST CTRL SRV, CMF 104727 69043511/7200 6402 6401 PROFESSIONAL SERVICES STORM WATER UTJUTY OPERA 08400 08 26.59 10/28 PEST CTRL SRV, CMF 104727 69043511/7200 6502 6401 PROFESSIONAL SERVICES WATER UTILITY EXPENSE 06500 08 91.13 10131 PESTCTRLSRV, WTRTWR 104737 69042107/2687 6502 6401 PROFESSIONAL SERVICES WATER UTILITY EXPENSE 06500 08 381.55 118192 1111812011 1002110 PAUSTIS & SONS WINE COMPANY 644.51 WlNEORDER 104893 8326307-IN 644.51 6115 5502 COST OF GOODS SOLD PILOT KNOB UQUOR 06100 02 118193 1111812011 103217 PERFORMANCE PLUMBING AND HTG, 188.00 SRV CALl, RR SR CTR 104526 1798 188.00 2410 6515 BUILDING REPAIR SERVICE SENIOR CENTER PROGRAMS 02400 09 118194 1111812011 100034 PHILLIPS WINE AND SPIRITS INC 3,651.64 SPIRITS, UQUEURS 104883 2153655 6110 5502 COST OF GOODS SOLD DOWNTOWN UQUOR REV & EXP 06100 02 Tl2.2.6 WINE ORDER 104884 2153656 6110 5502 COST OF GOODS SOLD DOWNTOWN UQUOR REV & EXP 06100 02 344.27 WINE ORDER 104879 2150287 6110 5502 COST OF GOODS SOLD DOWNTOWN UQUOR REV & EXP 06100 02 712.n SPIRITS, UQUEURS 104880 2150286 DUP INV 6110 5502 COST OF GOODS SOLD DOWNTOWN UQUOR REV & EXP 06100 02 182.41 WINE ORDER 104881 2150165 6115 5502 COST OF GOODS SOLD PILOT KNOB UQUOR 06100 02 521.48 SPIRITS, UQUEURS 104882 2150164 6115 5502 COST OF GOODS SOLD PILOT KNOB LIQUOR 06100 02 6,164.83 118195 1111812011 111359 PHRANER, DEBBIE 140.00 OCT11 ,18,25 NOV 1 SERVICES 104819 118 2410 6401 PROFESSIONAL SERVICES SENIOR CENTER PROGRAMS 02400 09 155.00 SEP13,20,27, OCT 4 SERVICES 104820 117 2410 6401 PROFESSIONAL SERVICES SENIOR CENTER PROGRAMS 02400 09 295.00 118198 1111812011 100152 POSTMASTER 2,000.00 PRK1REC BROCHURE PSTG 104825 PERMIT#38 PRKI 1094 6445 POSTAGE PARK & RECREATION ADMIN 01000 09 2,000.00 118197 1111812011 100135 PUBUC EMPLOYEES RETIREMENT AS 16,707.72 104738 111611937021 7000 2113 PERA PAYABLE EMPLOYEE EXPENSE FUND 07000 02 21,957.24 104745 111611937022 7000 6154 PERA EMPLOYEE EXPENSE FUND 07000 02 38,664.96 118198 1111812011 110597 PUBUC SAFETY EQUIPMENT LLC 345.00 RADAR,LASER UNITS CAUBR 104489 3116 1051 6230 VEHICLE SUPPUES & PARTS PATROL SERVICES 01000 05 345.00 118199 1111812011 100076 QUALITY WINE AND SPIRITS CO 41 R55CKSUM LOGISoo1V NOTE: Check Amount may not reflect actual check total due to sequenclng of data. ; Check # Date Amount 18.50 3,062.39 18.50 2,653.97 5,753.35 SUppfier / Explanallon PO# SEAGRAM SANGRIA ORDER SPIRITS, UQUEURS SEAGRAM UQ ORDER SPIRITS, UQUEURS Doc No Inv No -- 104897 534119-CO 104894 534119-00 104895 53412O-CO 104896 534120-00 CIlY OF FARMINGTON Council Check Summary 11"'2011 - 1112012011 BU ObJ Sub 6110 5502 6110 5502 6115 5502 6115 5502 Subledger Acoount Description COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD 11/17/201110:35:49 Page- 18 BU Descrlp1Ion ~ Dept DIv DOWNTOWN UQUOR REV & EXP 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 PILOT KNOB UQUOR 06100 02 PILOT KNOB UQUOR 06100 02 118200 1111812011 109332 RESOURCE RECOVERY TECHNOLOGIES 32,877.96 OC1'11 MSW FEES 104539 20168435 001'11 6302 6401 PROFESSIONAl.. SERVICES SOLID WASTE OPERATIONS 06300 08 32,877.96 " 118201 11/1812011 103092 ROCKMOUNT RESEARCH AND ALLOYS 183.84- BlADES 104706 1168597 7200 6230 VEHICLE suppues & PARTS FLEET OPERATIONS 07200 08 183.84 118202 11/1812011 112362 SAFE STEP LLC 11,837.21 2011 SIOEWLK PROJ, 9TH-13TH ST 104758 1306 1072 6401 PROFESSIONAl.. SERVICES STREET MAINTENANCE 01000 08 3,124.94 2011 SIOEWLK PROJ, 3-5TH ST 104759 1317 1072 6401 PROFESSIONAl.. SERVICES STREET MAINTENANCE 01000 08 14,962.15 118203 1111812011 112227 SAVERS CHOICE STORE # 328 6.38 RRST AID SUPPUES, POOL 104761 TRX271 TERM4 2415 6250 OTHER SUPPUES & PARTS SWIMMING POOL OPERATIONS 02400 09 5.97 SLUSH CUPS, POOL 104762 TRX222TERM6 2415 5502 COST OF GOODS SOLD SWIMMING POOL OPERATIONS 02400 09 12.35 118204 1111812011 118205 11/1812011 118205 11/1812011 118207 1111812011 112051 SOUTHERN WINE & SPIRITS OF MN, 26D.48 SPIRITS, UQUEURS 104827 1637716 317.27 SPIRITS, UQUEURS 104826 1637717 577_75 110798 SPECIALIZED ENVIRONMENTAL TECH 1,972.00 0CT'11 CMPSTHAULSRVS 104577 10437oor11 1,972.00 1057llO TOTAL MEDIA INC 130.43 DVD+RIT-12OHQ VHS 130.43 104557 314300D-IN 11234& TRANS ALARM SECURITY SERVICES 15.98 DUP KEYS FOR MAlNT FACIL 104527 SVL092524 15.98 DUP KEYS FOR MAlNT FACIL 104527 SVL092524 39.94 OUP KEYS FOR MAlNT FACIL 104527 SVL092524 39.94 CUP KEYS FOR MAlNT FACIL 104527 SVL092524 6110 5502 6115 5502 COST OF GOODS SOLD COST OF GOODS SOLD 6402 6401 PROFESSIONAl.. SERVICES 1052 6250 OTHER SUPPUES & PARTS 1072 6240 1090 6240 6202 6240 6302 6240 BUILDING SUPPUES & PARTS BUILDING SUPPUES & PARTS BUILDING SUPPUES & PARTS BUILDING SUPPUES & PARTS 42 DOWNTOWN UQUOR REV & EXP 06100 02 PILOT KNOB UQUOR 08100 02 STORMWATERUTlUlYOPERA 06400 08 INVESTIGATION SERVICES 01000 05 STREET MAINTENANCE 01000 08 PARK MAINTENANCE 01000 09 SEWER OPERATIONS EXPENSE 06200 08 SOUD WASTE OPERATIONS 06300 08 R55CKSUM LOGISOOW NOTE: Check AmOWlt may not reflect actual check total due to sequencing of data. Check # Date Amount SuppDer 1 Explanation PO# Doc No Inv No 7_97 DUP KEYS FOR MAlNT FACIL 104527 SVl092524 39.94 DUP KEYS FOR MAlNT FACIL 104527 SVL092524 159.75 118208 11/1812011 109026 TR1 COUNTY BEVERAGE & SUPPLY 208.00 BEER ORDER 104898 249591 208.00 CITY OF FARMINGTON Councll Check SUll\lllillY 11"12011 - 11/20/2011 ~ Obj Sub 6402 6240 6502 6240 6110 5502 118209 11/1812011 102642 UNITED PARCEL SERVICE 7.83 11103 DaV SRV 104804 O5OY04R461 NOV 1050 6401 7.83 118210 11/1812011 112080 VERMlWON KENNELS 128.55 OCT 14,16,27 NOV 1, K-9 SRV 104824 3670 1051 6406 128.55 118211 1111812011 108808 V1NOCOPIA 544.00 WINE ORDER 104899 0047025-IN 6115 5502 544.00 118212 11/1812011 102592 WINE COMPANY, THE 517.90 WINE ORDER 104900 2S4$2..OQ 517_90 118213 1111812011 100334 WINE MERCHANTS 2.94 BlK ax CHRD FRTCHRG 104886 384255 606.86 WINE ORDER 104887 384315 291.66 WINE ORDER 104888 385353 525.20 WINE ORDER 104885 384256 1,426.66 118214 1111812011 102071 WlNGFOOT COMMERCIAL nRE 172.29 TIRES 104705 124-1059373 1,467.30 TIRES 104705 124-1059373 1.639.59 118215 1111812011 110892 WIRTZ BEVERAGE MINNESOTA 3,506.95 SPIRITS, UQUEURS 104903 657674 126.81- REF 653472, MCGILL SHRT 104904 846469 CM 3,505_11 SPIRITS, UQUEURS 104901 657675 436.85 WINE ORDER 104902 657676 7,322..10 6110 5502 6110 5502 6110 5502 6110 5502 6115 5502 1060 6230 7200 6232 6110 5502 6110 5502 6115 5502 6115 5502 43 Subledger Account Description BUILDING SUPPUES & PARTS BUILDING SUPPLIES & PARTS COST OF GOODS SOLD PROFESSIONAL SERVICES K-9 EXPENSE COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD V8-\ICLE SUPPUES & PARTS V8-\ICLE TIRES COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD COST OF GOODS SOLD 11/171201110:35:49 Page- 19 BU Description Co Dept Div STORM WATER UTIUTY OPERA 06400 08 WATER UTIUTY EXPENSE 06500 08 DOWNTOWN UQUOR REV & EXP 08100 02 POUCEADMINISTRAnON 01000 05 PATROLSERVlCES 01000 05 PILOT KNOB UQUOR 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 PILOT KNOB UQUOR 06100 02 FIRE SERVICES FLEET OPERAnONS 01000 06 07200 08 DOWNTOWN UQUOR REV & EXP 06100 02 DOWNTOWN UQUOR REV & EXP 06100 02 PILOT KNOB UQUOR 06100 02 PILOT KNOB UQUOR 06100 02 R55CKSUM LOGISOO1V NOTE: Check Amount may not reflect actual check total due to sequencing of data. 'Check it Date Amount Supplier I Explanallon Report Totals PO# Doc No Inv No 428.329_43 CITY OF FARMINGTON CouncD Check SUmmary 111712011 - 11I20I2011 au Obj SUb Subledger Account DescrIptlon 44 au DescrIptlon 11/171201110:35:49 Page - 20 Co Dept DIY R55CKSUM L0G23000VO Vendor PELLlCCI HARDWARE & RENTAL Business Unit CITY HALL CITY HALL FIRE SERVICES STREET MAINTENANCE PARK MAINTENANCE SENIOR CENTER PROGRAMS ICE ARENA OPERATIONS EXPENSE SEWER OPERATIONS EXPENSE APPROVALS: LARSO~<--~ BARTHOLOMA~ ;?>ONNELL~ ~O y'-'- SIO CITY OF FARMINGTON Council Check swnmary 111712011 - 1112012011 Object EQUIP SUPPLIES & PARTS BUILDING SUPPLIES & PARTS BUILDING SUPPLIES & PARTS OTHER SUPPLIES & PARTS OTHER SUPPLIES & PARTS EQUIP SUPPLIES & PARTS OTHER SUPPLIES & PARTS OTHER SUPPLIES & PARTS Report Totals 11/17/20111 0:40:06 Page - Amount 293.22 4.80 72.32 51.33 23.18 35.00 10.20 5.34 495.39 495.39 ?fa... City of Farmington 430 Third Street larmington, Minnesota 651.280_6800. Fax 651.280.6899 www.ci.tarmingtll11_TIlll_Ll.'1 TO: Mayor, Councilmembers, City Administrator FROM: Cynthia Muller, Executive Assistant SUBJECT: 2012 License Renewal Public Hearing DATE: November 21 2011 INTRODUCTIONIDISCUSSION Per City Code, a public hearing must be held to issue or renew On-Sale Liquor Licenses, On- Sale Sunday Liquor Licenses, On-Sale Wine Licenses, Club Licenses and Therapeutic Massage Licenses. The required applications, fees and insurance information have been submitted for renewal and have been reviewed and approved by the Police Department for the following establishments: On-Sale Liquor: Farmington Lanes, 27 5th Street Long Branch Saloon and Eatery, 309 3rd Street Big Sombrero Mexican Restaurant, 953 8th Street American Legion Post #189, 10 N 8th Street Blondie's Tavern, 20700 Chippendale Avenue Celt's Pub & Grill, 200 3rd Street The Ugly Mug, 18450 Pilot Knob Road On-Sale Sunday: Farmington Lanes, 27 5th Street Long Branch Saloon and Eatery, 309 3rd Street Big Sombrero Mexican Restaurant, 953 8th Street American Legion Post #189, 10 N 8th Street Blondie's Tavern, 20700 Chippendale Avenue Celt's Pub & Grill, 200 3rd Street The Ugly Mug, 18450 Pilot Knob Road VFW Club Post #7662, 421 3rd Street VFW Club Post #7662, 421 3rd Street Club Licenses: 47 On-Sale Wine & On-Sale Intoxicating Malt Liquor: Therapeutic Massage: BUDGET IMPACT B & B Pizza, 216 Elm Street Weng's Kitchen, 115 Elm Street Pilot Knob Pizzeria, 18500 Pilot Knob Road Dunn Bros Coffee, 20700 Chippendale Avenue Debbi Odegard, 923 S 8th Street Jill Loosbrock:, 625 8th Street Denson Malone, 1212 Oak Street Shannon Koch, 19685 Pilot Knob Road Michelle Connors, 324 3rd Street The fees collected are included in the revenue estimates ofthe 2012 budget. ACTION REOUESTED Approve the On-Sale Liquor, On-Sale Sunday Liquor, On-Sale Intoxicating Malt Liquor and On- Sale Wine, Club, and Therapeutic Massage Licenses for the businesses listed above. Respectfully submitted, Cynthia Muller Executive Assistant 48 lOa- City of Farmington 430 Third Street hrmington, Minnesota 651.280_6800. Fax 651.280.6899 www.ci.tanningtI111_n11l_L1..1 TO: Mayor, Councilmembers, and City Administrator FROM: Teresa Walters, Finance Director SUBJECT: October Financial Report DATE: November 21,2011 Enclosed is the financial report for the month of October 2011. Below is an explanation for variations from the budget as well as differences from last year at this time. If you have any questions prior to the meeting, please e-mail meattwalters@cLfarmington.mn.us or call me at 651-280-6880. General Fund Overall General Fund Revenues are at 55% of the budget. This includes our tax revenue for the fIrst half of the year. Expenditures are at 78.9% of the budget. 83% ofthe year has passed. REVENUES All revenues are within budget except the following: Property Taxes: We received the fIrst half of our property taxes. The other half will be received in December. Charges for services are at approximately 56.2% ofthe budget. Fire Service charges are not received until closer to the end ofthe year. We are working on Fire Services contracts that will require payment on a quarterly basis rather than at year-end. Interest: At approximately 43% ofthe budget, interest revenue is still low compared to budget. We have adjusted the budget for 2012 to ensure this does not happen again next year. Miscellaneous: is at approximately 44% of the budget. This line item is for everything that does not fall into any of the other categories: Sale of assets, cash over/short, refunds/reimbursements, donations, etc. Without taxes all other revenues combined are at 80.6% of the budget. 49 EXPENDITURES At 78.9%, overall General Fund expenditures are in line with the budget. 83% ofthe budget year has passed. Suecial Revenue Funds: The Special Revenue funds are established to account for specific revenue sources (grants) or to fInance a specific activity. Plans to eliminate defIcits have been discussed during the budget process and will be implemented in 2012, provided they are approved by Council. The following is a summary of each special revenue fund: EDA: The EDA defIcit grew by $855 bringing it to $165,971 at the end of October. Rambling River Center Operations (Senior Center): Revenue for the Senior Center was $2,136. Expenditures totaled $7,331. With the General Fund transfer, the deficit was reduced by $6,531, bringing the fund balance from a negative $12,825 in September to a negative $6,294 in October. Rambling River Center Renovations: October revenues exceeded expenditures by $1,432, bringing the fund balance from a negative $149,414 in September to a negative $147,982 in October. Swimming Pool: The pool is currently closed. During October expenditures exceeded revenues by $2,118. The current fund balance is $43,414. Ice Arena: In October, the Council approved moving over $16,000 in expenditures from the Ice Arena operations to the Ice Arena capital project. This caused expenditures to go negative since we only had approximately $11,000 in expenditures during the month. Ice Arena revenues exceeded expenditures by $11,055. Without this adjustment, expenditures would have exceeded revenues by approximately $4,973, adding to the defIcit. Because of the adjustment, the defIcit fund balance was reduced from a negative $343,090 in September to a negative $332,035 in October. Entemrise funds: The Enterprise funds are self supporting and should not need fmancial assistance from the General fund. Liquor: Liquor expenditures exceeded revenues by $38,446 this month. With the transfer, the fund balance shows a reduction of$44,280. Street Lights: The Street light utility expenditures exceeded revenues by $9,471 this month. A plan to eliminate the defIcit will be implemented in 2012. Solid Waste: Expenditures exceeded revenues by $53,022. This was a result of receiving two sanitation bills during the month of October. If this stays consistent with prior years, we should not receive one in November. Sewer. Water. and Storm Water. are all in line with the budget for the year. 50 Grauh: The graph shows that the overall 2011 YTD fund balance is slightly higher than the 2010 fund balance at this time. From the graph you can also see that November is typically a month when the General Fund starts to borrow from other funds. This is a result of our low fund balance. Respectfully submitted, Teresa Walters, Finance Director 51 CIly 01 Farmington Bud9et Summary 2008 Fund BaJ 1,728,910 1,144,798 505,410 (16,438) (579,770) 1,194,488 1,380,217 788,487 38,652 (195,850) (988,597) $ 1,987,775 2009 Fund BaJ 1,448,414 908.221 348,825 (190,293) (983,071) 441,205 1.579,394 1,167,880 673,253 288,845 (537,502) $ 2,157,860 2010 Fund BaJ 1,643,301 1,176,859 577,370 111,482 (661,411) 1,532,883 1 .666,003 1,3Oll,961 725,203 59,838 (548,029) $ 2,216,642 2011 Adopled % Account D Bud et Jan F8b Mar June Oel Nov Dee Total - Received Fund Batance $ 2,216,842 .BmnilIlI Property T..... 7,084,547 $ 3,438,090 4,424 $3,440,515 3,644,032 48.56% Ucenses 32,155 11,845 148 5,690 167 176 7,195 152 197 6,532 1,007 $ 33.228 (1,073) 103.34% Pennlls 389,300 14.855 17,231 23,177 23,947 38,939 112,614 26,666 21,901 34,728 65,951 $ 3811,208 19,092 95.22% FIne8 70,000 5,_ 6,308 6,295 6,160 7,053 5,967 7,893 10,060 6,122 $ 63,660 6,340 90.94% Inlergovemmenlal Revenue 405,590 67,488 797 695 1,666 67,826 5,551 12,496 256,110 9,081 $ 483,915 (58.325) 114.38% Charge lor_ 503,678 2,035 3,198 12,133 62,981 15,740 19.142 6,996 63,244 7,670 69,679 $ 282,629 220,649 56.15% Franchise Fees 75,000 22,537 52,389 $ 74,926 74 99.90% Investmentlnlereet 200,000 6,170 7,281 9,955 5,254 4,434 6,731 7,923 13.365 11,957 6,548 $ 95,616 114,394 42.81 % MIsoeIJeneous 69 000 1489 6410 613 012 6934 711 1 838 6147 993 $ 30193 38 607 43.76% Total 6,839,270 38,464 127,526 56,673 121,281 76,375 3,701,699 59,m 172,321 335,192 163,381 $ 4,955,090 3,984,160 54.93% 2011 edop1ed % De Bud et Jan F8b Mar June JuI Oel Nov Dee Total - ended ExDltftdltures 1005 Leglsletlve 77,652 3,531 3,328 5,691 4,172 3,781 6,039 6,448 3,295 20,049 5,652 $ 61,992 15,850 79.83% 1006 H_ PreservetIon 7,460 1.500 1,500 1,500 1,600 30 $ 6,130 1,380 61.95% 1010 Admlnlstretlon 522,254 28,706 37.855 39,051 38,427 32,847 106,568 21,584 21,906 28,841 44,667 $ 398,654 128,610 76.95% 1013 8ec11ona 1,926 1,925 398 $ 2,323 (398) 120.68% 1014 ComlTllJl1!oetlona 84,438 5,148 6,186 5,990 5,996 6,016 6,904 5,161 7,576 6,529 6,859 $ 67,387 17,069 78.78% 1015 CIly Hall 148,142 14,049 6,932 13,920 13,616 6,686 10,811 10,017 12,657 15,519 22,177 $ 130,766 14,376 90.10% 1035 Communlly Development 93,298 6,259 7,841 8,003 7,821 7,748 11,487 7,022 7,748 7,710 3,353 $ 74,971 16,327 80.36% 1011 Human ROIlClllroOS 238,159 15,239 20,741 16,462 18,947 18,600 32,606 19,603 18,298 19,360 18,488 $ 198,444 39,715 93.32% 1022 FJnence 429,686 32,845 66,145 39,241 34,009 32,219 47,661 27.382 32,392 32,948 22,281 $ 356,202 73,488 82.90% 1060 PoUce Admlnls1retlon 505,574 54,486 61,057 67,145 56,172 54,652 66,663 62,132 47,451 66,584 84,511 $ 643,254 162,310 79.85% 1051 Petrol ServIoes 2,290,812 160,529 162,429 176,612 167.654 174,067 294,993 169,360 174,079 184,843 162,661 $ 1,617,423 473,189 79.34% 1052 Inveetlgetlon SeIVioes 787,906 51,003 60,702 60,332 60,191 61,413 90,503 65,956 60,036 62,307 65,808 $ 628,055 139,653 81.79% 1054 Emergenoy Management 4,900 302 166 18 11 228 18 16 447 $ 1,2lll1 3,691 24.67% 1060 FIre 686,254 26,269 36,515 43,131 42,432 42,460 36,603 34,570 135,362 124,077 43,689 $ 666,977 101,267 84.84% 1061 Resale 48,821 3,984 1,963 2,337 2,21 0 3,007 3,371 3,391 3,160 2,348 2,361 $ 28,040 17,761 61.19% 1070 Engu-Jng 282,075 12,584 28,616 22,292 21,634 23,710 24,301 15,351 20,957 23,843 7,840 $ 198,130 63,845 75.60% 1030 Planning 232,353 14,030 17,620 17,360 17,197 20,151 28,662 16,416 35,666 15,675 11,660 $ 191,677 40,676 82.49% 1031 BuIlding Inspecllon 308,239 16.oz4 24,410 23,481 22,956 21,211 34,372 20,968 23,572 23,229 24,771 $ 237,015 71.224 78.69% 1078 NaturaJ ROIlClllroOS 94,199 520 1,503 2,913 6,839 1,129 3,692 3,601 4,990 7.654 3,722 $ 38,552 57,637 38.81% 1072 Streets 597,248 21,408 29,484 40,029 42,21 0 48,721 70,247 37,842 36,367 39,847 35,240 $ 402,292 194,956 67.36% 1073 Snow RemoveI 205,104 37,319 65,560 48,635 17,132 2,915 1,933 288 298 586 $ 174,686 30,416 95.17% 1090 Perk MaInIenanoe 519,677 33,059 34,139 38,044 38,051 68,548 78,360 54,030 56,544 51,655 20,728 $ 481,076 38,499 92.59% 1094 Perk & Roc Admin 250,882 10,533 4,826 14,727 11,210 16,476 14,674 13,199 24,421 12,739 21,984 $ 144,671 106,311 57.63% 1095 RecreaIIon Programs 118,022 2,325 12,622 9,767 6,514 6,672 16,162 24,268 (14,676) 6,216 1,674 $ 69.365 48,637 59.80% 1099 Dew Deye $ 0.00% Total ExpendIturee $ 6,768,792 643,345 682,501 697,256 632,616 653,695 $ 1.007,980 610,017 723,613 750,623 613,358 6,915,213 1,653,579 78.88% Excess 01 RlMlIlUO over (under) ExpendIturee $ 70,478 (504,681) $ (654,975) $ (838,362) $ (511,335) $ (577.320) $ 2,893,919 (550,240) $ (561,492) $ (415,431) $ (449,987) $ (2,060,123) Other FInancIng Souroee (Useo) Trensler81n $ 83.33% 1001 Trensler8 (OUt) $ 93.74% Total Other Ananclng Souroee (.....) $ $ Net change In Fund_ $ (487,436) $ (537,530) $ (520,837) $ (483,890) $ (569,675) $ 2,711,384 (632,785) $ (584,047) $ (631,959) $ (432,542) $ (2,119,948) Pund Balanoe 1,731,406 1,193,676 572,939 78,050 (460,825) 2,230,539 1,697,744 1,163,697 531,738 99,196 152 pjh CIIy 01 FarmIng1Dn Acoount lion 8aoolat Revenue Funds BDA ODOratlna - Expondllurea $ Excess 01 Revenue over (under) ExpendJIurea $ Other f'InancIng Sources (UBeS) Transfers In Transfers (0Ul) ToIaI Other AnanoIng Sources (uses) Net chang. In Fund BeIance $ 2011 Adopled BuxI et Jan Fob 19,086 19086 1.369 1335 34 IFundBIllna. . .,~~--=-_-$ Poilu PorfGltul1l9 - Expandllures i Fund BIJlftoe Park ImDrDVement - Expondllurea 2,000 4000 --4,429 2Q,4lIlI 26 000 4,429 :_ 8,479 _$_~ 14,861 190 Mar 2,819 1721 1,098 (4,821) $ Budget SUmmary A r June Sol Cot Nov Dee ToIaI (4,821) $ 98S 716 281 434 1,295 112,223 12,288 287 208 854 133,025 38 452 6787 8143 683 2442 1710 (8,848) $ 99,079 (398) $ (2,234) $ 11,081 (865) % BeIance ReoeIved (113,939) 898.97% 17388 190.99% 98,572 434 (8,848) $ 99,079 (865) 98,572 (130.072) (398) (2,234) $ 11.081 (266.232) $ (286,798) $ (272,645) $. (173,686) $ (1~ (162,882) $ (185,116) $ (185,971ll___ - $=_-::=-, 4.717 687 609 955 487 2,002 609 6,690 1474 1198 394 210 291 102 418 8.331 8.121--T63f--~-9;731 t=__9J!1S -=-~~13-$ _,@~"::$ c::-:":;:.....J_ 1,182 3.160 1,280 17,731 305 1,328 1,430 8898 1,976 1468 802 481 1458 Fund's.i.li.. -J::;';~![$ c- 21.3,992 $=-l?8~~:T.2@.1IC$ -229,8431.-231,636 $ 232,816 $ 250~::-L~5fLL~,999---.l_ 248.s1.Ll_____~~3_=_:_=::._=:.. _-L----- Rearutton ODerattna Senior Center Revenues 2410 SenIor C8nler 37,200 8,459 3,623 2,139 1,988 683 2,304 1,102 947 1,782 2,138 Expandllures 2410 SenIor Canter $ 157481 1 307 10932 1 928 13421 11179 14422 11687 11 4 10423 7331 Excess 01 REMlllllll over (under) Expandllures $ (120,291) $ (3,848) $ (7,309) $ (10.787) $ (11.453) $ (10,288) $ (12,118) $ (10,668) $ (10,277) $ (8,841) $ (6,194) $ 26,363 116,822 (90,489) 16,262 4762 (13,262) 782.68% 118.80% 44,226 (23,826) 216.79% 10 7 41.91% 16103 11,947 41,869 68.15% 73.54% Other f'InancIng Souroes (UBeS) Transfers In 11,725 11,726 11,726 11,726 11,725 11,725 11,726 11,726 11,726 11,725 117,260 23,450 83.33% Transfers (0Ul) $ ToIaI Other AnanoIng Sources (uses) 11, 11,726 11, 1, 11, 1, 11,726 11,725 117,260 3,450 97.14% Net chang. In Fund BeIance $ 938 272 1,439 (393) $ 1,189 1,448 3,084 6,631 28,781 (28,372) : Pund 1a-'lnH $ --1'1~,133) $ J1ZMIl $ $ --------- (6,294) (19,572) (16,626) $ (16,909) (12,826) (~~-------L:.-=-----i $ l53 pjh CIly 01 Farmington Budget SUmmary 2011 Adopted Acoounl lion Bud et Jan Fob Mar A r JUI18 JuI 001 Nov Deo Rambling River Center Renovation ROV8llUllS 2411 RambDng RIver Canter Ranoval 1,297 6,192 368 294 191 1.446 100 113 454 2,679 Expenditures 2411 RambDng RIver Canter Ranoval $ 63 216 22 1 47 Excess 01 RlMlIllI8 over (under) Expenditures $ 1,234 6,192 368 294 191 1,228 79 113 454 1,432 Other FInanolng Sources (Uses) Trensferaln $ Trensfera(OUI) $ ToIaI Other F1nano1ng Sources (uses) Netohangeln Fund BaIanoe $ 1,234 6,192 368 294 191 1,228 79 113 454 1,432 FundBII.... .. . .~,.. L:--:Il@~ !Jlg-~1Ll.:~5~.L115lcilll..1-.l1~,~77)$ (1~h~LIJ1~~j!114!~r114s..~t:}={1~~14[1-(14f.982L!__ __-:::_1"-:.. ____ $ SWimming Pool Rev8llUllS 2416 SwbnmIng Pool Expenditures 2415 Swimming Pool Excess 01 Revenue over (under) Expenditures $ 70.000 132 2,543 3,749 21,718 26.281 11,749 (35) 312 119793 1660 1027 1610 5341 444 26 633 25 073 4835 430 (49,793) $ (1,660) $ (1,027) $ (1,479) $ (2,798) $ (4,497) $ (726) $ (2,372) $ (13,327) $ (4,870) $ (2,116) $ Other FInanolng Sources (Uses) Trensferaln $ Trensfera(OUI) $ ToIaI Other F1nano1ng Sources (uses) 20.000 6,667 6,667 6,667 20,000 Netohangeln Fund BaIanoe $ (29,793) $ (1,660) $ (1,027) $ (1,479) (2,798) $ (4,487) $ 5,941 4.295 (6.660) $ (4,870) $ (2,116) $ iPunciiiOl.ii.. --c-.--- $__-=58-;27( t.5M1L$ ~~9fT-s4;f13-J_~,~B:_} 46;B28~-$- 52;'168$ -=6t__~_-$--~4ll3 $ . 45,533 $ _ 4:jJf4$ ______::: $ -==-- TOTAL RECREATION FUND BALANCE (134.362) $ (126,931) $ (117,350) $ (117,502) $ (119,734) $ (122,592) $ (115,816) $ (110,274) $ (115,374) $ (116,706) $ (110,661) $ IaAmDi R8Y8llUllS 309,700 64,_ (664) $ 69,925 1.208 15 $ 11,059 3,145 ZT 7,614 6,027 Expenditures 305147 33 31669 26 25785 Excess 01 RlMlIllI8 over (under) Expenditures $ 4,553 31,041 (33,793) $ 33,715 (30,683) $ (28,211) $ (17,968) $ (9,702) $ (25,758) $ (4.838) $ 11,055 rFiindBoflii...._::_:___ _-__~__~903 $ (225,662LL(~~,~_L(225,93ijC$-(256,6j~T~~I::~792f$-(312,494) $ (338,252) $ (343,090) $ (332,035) $ 3/54 % ToIaI IleIenoe ReoeIYed 13,154 (13,154) 1,661 (1.551) flDlVIOI 11,603 flDlVlOl flDlVlOl 11,603 (147,662) 66,42lI 3,574 94.66% 101,290 16,603 84.55% (34,665) 20,001 (1) 100.01% 20,001 (14,664) $ (14,929) 513,646 162,479 62,45% 147.221 237,611 n.6?''!. 57,536 (75,132) (332.035) pJh city of Farmington BUllget Summary Account 2011 Adopted BUll et Jan Fob Mar A r June JuI Bel 001 Nov Dee Total % BaIanoe ReoeIved Entennlsa Funds L1auar ODerDtlans Revenues 4,441,250 262.010 273,155 290,061 342.560 354,565 3ll4,675 417,127 378,928 380,708 348,574 3,422,383 1,018,887 77.06% Expenditures 4 897 255897 278559 277786 313409 369858 428542 335 4117842 298 367021 3357757 830 76.48% Excess of Revenue over (under) Expenditures $ 50,553 (3,577) S (3,404) S 12.288 29,181 (15,093) $ (31,867) S 81,857 (26,713) S 82,424 (38,448) S 84,598 (13,943) Other FInancIng Souroes (U...) TIllI1SIeraIn S TIllI1SIera(OUl) S 87.04% Total Other F1nano1ng Souroes (1lS8S) Net change In Fund BaIanoe $ (39,354) S (9,411) S 8,431 23,317 (20,927) $ (44,388) S 89,388 (34,847) S 49,924 (44,280) S (13,744) : FuncrB.I8na.---~IIj~-'---i~~~4 L 258,Il83_--1-~7,725 S _254,168 ~"473 258,646 $ 212.178 S 261,534 246,988 296,910 252.830 $ ~-:-~ $ -=--~-_ S 252.830 !I.tIuI: Revenues 1,835,000 83,409 33,575 180,711 75,853 128,786 249,107 89,288 139,259 138,4Illl 136,182 1,232,379 4ll2,821 75.37010 Expenditures 1 684 957 98 409 95 949 99745 101 7 97121 120 805 98 889 106 305 10 18 104 345 1 025 062 659 895 84.57% Excess of Revenue over (under) 207,3171 $ Expenditures S 60,043 (18,001) S (82,374) S 80,988 (25,943) $ 29,885 128,501 (29,380) S 32,984 36,082 31,838 (157,274) Other FInancIng Souroes (U...) TIllI1SIeraIn TIllI1SIera(OUl) S 88.62% Total Other FInanoIng Souroes (1lS8S) 88.52% Net change In Fund BaIanoe S (61,574) $ 75,132 (31,777) S 23,831 122,887 (35,214) $ 27,1311 311,249 117,367 ~uncfB.I.noe ~-- --~ - ~r_~-~1J~ E~lO$CI 1,54~D87$.1,617.219.- _n,585M2__]~~~_lhT.l..i94ij_:n~~-=-_n.~~:I-=-~~CM_=I_1.J~M@J~T~Ty_~____ ._(- 1,746,497 llllllll!lalI. Revenuee 1,878,903 109,215 311,102 210,64IJ 109,053 183,230 197,698 109,739 157,728 194,503 110,347 1,4112.050 474,853 74.70% Expenditures 1813946 81103 105517 118029 146 945 281 786 101734 149 938 83 802 128 978 183 9 1 357 201 456 746 74.82% Excess of Rovonuo over (under) Expenditures S 82,957 28,112 (75,415) $ 94,611 (37,893) $ (118,658) S 95,882 (411,200) $ 83,924 57,525 (63,022) $ 44,849 Other FInancIng Souroes (U...) TIllI1SIeraIn TIllI1SIera(OUl) S 90.08% Total Other F1nano1ng Souroes (1lS8S) NeI change In Fund BaIanoe $ (84,468) $ 88,577 (43,727) S (124,390) $ 90,028 (46,034) S 78,090 81,681 ~.I.nae -----s- - -563,892 $ 588;170$ 604,921s-5!l3,6S8 $ -849,871 $ 425,461 $ 616,610 469,478 $ 647,686 - 609,257$- 602.985 $~--S--- 602.985 't;5 p)h City of FarmingIDn Acalunt DescrI tItm I!lII:m.YlIIIt ROV8I1IJ8S Expenditures Exoess 01 Reverwe over (under) Expendllures $ other FInancIng Sources (Uses) T_1n T_(CuI) Total other FInanoIng Sources (uses) Net chango In Fund _ $ 2011 Adoplod Bud 454,000 431902 22,098 Jan Fob Mer A r 74,018 136 (13,895) $ 8,4ll3 18,917 30813 JIDlO 25,630 19147 Bud9et Summery 74,383 17,811 25396 25,920 Oct NOY Doc Total 348,914 S9,BS2 % _ RocoIvod 105,086 17,042 18881 6,053 (1,619) $ (16,413) $ 51,879 WJIII: ROV8I1IJ8S IPund 881"'.- __~~L13~~____1__ __~ (63,715) $ (7,453) $ 610 B40 656~BB!i~~ 637,356 Expendllures Exoess 01_ over (under) Expendllures $ other FInancIng Sources (Uses) T_1n Tronoforo (CuI) ToIaI other Ananclng Sources (uses) Net chango In Fund _ $ 1,542.500 1 095 324 447,176 633 067 116,729 38 947 24,941 60601 79,762 (38,160) $ 47,924 48,045 (19,529) $ 949 m 37608 83,760 57 054 25,726 31 ,592 (7,785) $ (11,667) 213,447 88 454 125,984 74,176 17,181 25 607 635,076 1,201,294 740 572 480,721 (4,484) 341,205 354 752 ~- Fund ii1.n~ 345,559 73,948 (41,984) $ 96,695 771 76,668 635,005 $ _~~l _~144 25,756 34,719 632,523 $'_~~ $ n~Jl76 $ i";'L____rr.":. -__ 060 22,627 16,793 20,692 147,625 68 832 146,278 114 155,026 106421 121,150 33 625 40.553 (9,625) $ 58,796 31,676 48,608 138,382 624 53.553 16,114 -lf~-_~,mL500 ! 5,181MLs _$,~~"$5;181~ $ M~[t5,219,229=:l];272.19T= $ 5jij8~- $ 5,341,llo7T5,482,157= $ 5,47WL L 11,794 _ Llaht Utility ROV8I1IJ8S Expenditures Not chango In Fund _ 175,039 169,323 11,604 16,025 2,448 1,456 16,632 29,298 11,632 15,142 15,481 14,948 52.962 25,044 42,772 ==-1.. 15,742 14,613 21 ,265 16,774 14,652 11,948 15,405 5,716 $ (4,221) $ 990 $ (12,668) $ (3,309) $ 605 2,122 4,211 6,952 2,125 (9,471) $ _$=J34~=-~~]=_13t&O~050;f74) $-l53aI-=~~78U J$02$"/LL~5@=-j-.--i3Jl.$.93l=LW;-~..$ -_i46~L$ $ :-PLntd iI.-i.nee - - ~~~ 7,636 6,453 156 370,771 5,476,271 130,728 143,387 (12,659) (48,836) 76.65% 64.65% 86.40% 77.88% 67.61% 88.52% 44,311 74.69% 25,836 84.68% PI" " City of Farmington Budget Summary 2011 Adopted % Account Oescri lion Bud at Jan Fob Mar A r Ma June Jul Auc Seot Oct Nov Dee 1 Total Balance Received I City of Farmington General Fund Cash Flow $2,500,000 $2,000,000 . $1,500,000 Ql $1,000,000 . CJ c::: III c; $500,000 . ED 'C c::: ~ $0 u.. I 1 2 3 4' 11.1 6 7 8 9 10 - 111' 12 -$500,000 -$1,000,000 -$1,500,000 02011 02010 _2009 02008 f57 pjh