Loading...
12-11-17 CC Reg Mtg AgendaCITY OF SHOREWOOD CITY COUNCIL REGULAR MEETING MONDAY, DECEMBER 11, 2017 AGENDA 1. CONVENE CITY COUNCIL MEETING A. Roll Call B. Review Agenda 5755 COUNTRY CLUB ROAD COUNCIL CHAMBERS 7:00 P.M. Mayor Zerby Johnson Labadie Siakel Sundberg Attachments 2. CONSENT AGENDA — Motion to approve items on the Consent Agenda & Adopt Resolutions Therein: A. City Council Regular Meeting Minutes of November 27, 2017 Minutes B. Approval of the Verified Claims List Claims List C. 2018 Non -union Wage Recommendation City Administrator Memo D. 2018 Open Book Meeting Date Approval City Clerk Memo Resolution E. Accept 2018 Arctic Fever Donations City Clerk Memo Resolution F. Authorize Expenditure: Dehumidification System S.E. Area Well. PW Director Memo G. Approval of Updates to 2018 Standard Specifications and Detail Plates City Engineer Memo Resolution H. City Council Truth -In- Taxation Minutes of December 4, 2017 Minutes 3. MATTERS FROM THE FLOOR (No Council Action will be taken) 4. PUBLIC HEARING 5. REPORTS AND PRESENTATIONS A. Employee Recognition: Years of Service Awards B. Deborah Zorn — City Representative on the Lake Minnetonka Conservation District CITY COUNCIL REGULAR MEETING AGENDA — December 11, 2017 Page 2 C. Year -end report from Metropolitan Mosquito Control District Letter from MMCD D. 2017 Year -end Deer Management Program Report City Administrator Memo 6. PARKS 7. PLANNING 8. ENGINEERING /PUBLIC WORKS A. Accept Professional Services Agreement AE2S: Boulder Bridge Well Controls PW Director Memo Resolution B. Accept Bids and Award Contract for 2017 I & I Project City Engineer Memo Resolution 9. GENERAL /NEW BUSINESS A. Bunker Indoor Golf New Wine /Strong Beer Liquor License City Clerk Memo Resolution B. Adopting 2018 Budget/Levy Finance Director Memo Resolution C. Adopting 2018 CIP, Enterprise Funds and SSC Budgets Finance Director Memo Resolution 10. STAFF AND COUNCIL REPORTS A. Administrator and Staff 1. Setting Council -Staff Retreat Date City Administrator B. Mayor and City Council 11. ADJOURN CITY OF SHOREWOOD CITY COUNCIL REGULAR MEETING MONDAY, NOVEMBER 27, 2017 MINUTES 1. CONVENE CITY COUNCIL REGULAR MEETING 2A 5755 COUNTRY CLUB ROAD COUNCIL CHAMBERS 7:00 P.M. Mayor Zerby called the meeting to order at 7:00 P.M. A. Roll Call Present: Mayor Zerby; Councilmembers Johnson, Labadie, Siaket, Keane; City Administrator Lerud; Planning Director Darling; Brown; and, City Engineer Fauske Absent: None. B. Review Agenda Sundberg; Attorney for of Public Works Labadie moved, Johnson seconded, approving the agenda as presented. Motion passed 510. 2. CONSENT AGENDA Mayor Zerby reviewed the items on the Consent Sundberg moved, Labadie seconded, Approving the Motions Contained on the Consent Agenda and Adopting the Resolutions Therein. A. City Council Regular Meeting Minutes of November 13, 2017 the Verified Claims Li Approve Memorandum of`'Understanding between the City of Shorewood and AFSCME regarding the 2018 contract reopener. D. Approving Revised ORDINANCE NO. 549, "An Ordinance of the City of Shorewood Implementing a Natural Gas Service Franchise Fee for Providing Natural .Gas Service within the City of Shorewood, Hennepin County, Minnesota" and Adopting RESOLUTION NO. 17 -100, "A Resolution Approving the Publication of Ordinance 549 by Title and Summary." E. Adopting RESOLUTION NO. 17 -101, "A Resolution Approving Assessment for 21986 Bracketts Road, Shorewood." F. Adopting RESOLUTION NO. 17 -102, "A Resolution Accepting Donations to the City of Shorewood 2018 Arctic Fever Event." G. Approve Regular Full Time Appointment of Light Equipment Operator CITY OF SHOREWOOD REGULAR COUNCIL MEETING MINUTES November 27, 2017 Page 2 of 10 H. Approve Regular Full Time Appointment of City Clerk and Planning Director Councilmember Labadie noted that the American Legion Post 9259 made a $200 donation, Mediacom a $100 donation, RedFin a $75 donation, and Clarence Clofer Auxiliary Unit 259 a $150 donation to the 2018 Arctic Fever event. The City greatly appreciates the donations. Motion passed 510. 3. MATTERS FROM THE FLOOR There were no matters from the floor presented this evening. 4. PUBLIC HEARING A. Vacate a Portion of Drainage and Utility EaGsom Applicant: Jack and Gretchen Norqu�al Location: 27964 & 27968 Smithtown Road Mayor Zerby opened the Public Hearing at 7:03 P.M. Director Darling explained that Schroeder Management, on behalf, of Jack and Gretchen Norqual, has requested the vacation of standard drainage and utility easements for the property located at 27964 Smithtown Road. The property is located near the intersection of Smithtown Road and Virginia Cove. This request is related to Item 7.0 on the agenda which includes a, request to adjust the lot line between the 27964 and 27968 Smithtown Road properties which are both owned by the Norquals. The lot line adjustment would provide the land, locked parcel (the 27968 property) with enough land to have a separate driveway access to Smithtown Road. A small portion of the 27968 property would be transferred to the 27964 property. , If the lot line is adjusted the existing 'easements would remain in their current location unless they are vacated by Counc& If the easements are not vacated each of the two properties would end up with easements that have no purpose. If Council approves the vacation of the existing easements the easements would be rededicated when Item 7.0 is abnroved. Darling noted that staff recommends approval of the vacation of easements. Michael Schroeder, with Schroeder Management, noted he was hired by the Norquals to help them through this process. He stated the existing easements would be vacated off of one plat and then reinstalled on the new plat to follow the new property line. Councilmember Sundberg asked if any of the Norquals' neighbors have a concern with what has been proposed. Mr. Schroeder stated a letter was sent to the neighbors and no objections were received. Seeing no one present to comment on the case, Mayor Zerby opened and closed the Public Testimony of the Public Hearing at 7:08 P.M. CITY OF SHOREWOOD REGULAR COUNCIL MEETING MINUTES November 27, 2017 Page 3 of 10 Sundberg moved, Siakel seconded, Adopting RESOLUTION NO. 17 -103, "A Resolution Vacating Drainage and Utility easements for 27964 Smithtown Road." Motion passed 510. Mayor Zerby closed the Public Hearing at 7:09 P.M. 5. REPORTS AND PRESENTATIONS 6. PARKS 7. PLANNING A. Report by Commissioner Davis on the November '7 ?, 2017, Planning Commission Meeting Planning Commissioner Davis reported on matters considered- and actions taken during the November 7, 2017, Planning Commission meeting (as detailed in'`the minutes of that meeting). B. Planned Unit Development Amendment Regarding Signage Applicant: Shorewood Landing Senior Living Location: 6000 Chaska Road Director Darling explained that KTJ 285, LLC has requested an amendment to the Shorewood Landing Senior Living Planned Unit Development (PUD),in order to add two additional wall signs. One would be located near the northeast corner of the building. The other would be located over the main entrance into the building. Two other signs had previously, been approved as part of the permit. One sign is installed on the west side of the building. The other is a free - standing sign and it is installed on the berm adjacent to Chaska Road. Staff and the Planning Commission concluded that the sign proposed for the northeast corner of the building would provide some wayfinding assistance and that the sign proposed for over the main entrance would not be as effective. The Commission ultimately recommended approval for one additional sign for the corner of the building subject to the conditions listed in draft resolution. The conditions include obtaining permits for the signage and prohibiting illumination of the wall sign. Darling noted the Planning Commission did receive one letter which expressed opposition to the request. Two residents lung along Chaska Road spoke during the public hearing for this request and expressed their concerns about traffic volumes and speeds on Chaska Road. Councilmember Sundberg asked if the primary concern about the sign proposed over the entry was that it would just grant extra branding. Director Darling confirmed that. Sundberg then asked what the concern is about extra branding. 'Darling explained that originally the applicant had stated the additional signs were proposed for wayfinding. The sign above the entrance would not be visible until someone was in front of it. Councilmember Johnson explained the Planning Commission thought that the existing sign on top of the berm which is visible from Highway 7 provides sufficient branding and wayfinding and that the one proposed for over the entry would not provide wayfinding. Sundberg went on to ask if the signage proposed for over the entry would be obtrusive to residents in the area. Darling responded no. Director Darling stated she does not recommend illuminating the wall signs. CITY OF SHOREWOOD REGULAR COUNCIL MEETING MINUTES November 27, 2017 Page 4 of 10 Councilmember Johnson stated the Planning Commission had discussed that people that would see sign proposed for over the main entry would be residents. That sign would not be able to be seen until after turning on to the site. Councilmember Siakel inquired why the applicant wanted a total of four signs. Shannon Rusk, with Oppidan Investment Company, explained the rationale for the additional sign for on the corner of the building was for wayfinding. During the construction process there was a lot of traffic to and from the site and many drivers would turn their vehicles around on residents' driveways. The rationale for the second additional sign was for branding and for aesthetics. Mayor Zerby asked if there are any entrance /exit signs at the driveway on the site. Ms. Rusk stated there currently are none. She explained the driveway is wide enough to support ingress and egress traffic. Zerby then asked if there is, for example, a sign directing drivers to the receiving areas Ms. Rusk responded no and noted there is an underground parking garage. Zerby noted that he agreed with the Planning Commission's x additional sign. He stated he does not think the lack of signage over Councilmember Sundberg stated that she thought the signage' aesthetically pleasing. She personally did not have issue with allowi Councilmember Siakel expressed her one additional sign. dation to approve just one entry would be problematic. )posed over the entry would be both additional signs. recommendation for just Councilmember Johnson stated there is another way to have a sign near the entry (e.g.; there could be etching on the door. He expressed,his support for the Planning Commission's recommendation. Councilmember Labad e'expressed her support for the Planning Commission's recommendation as well. Johnson moved, Labadie seconded, Adoptng,RESOLUTION NO. 17 -104. `A Resolution Granting an Amendment to, the Shorewood Senior Living Planned Unit Development Located at 6000 Chaska Road" as outlined by the Planning Commission. Motion passed 510. C. Preliminary and Final Plat and Lot Width Variance - Norqual Addition Applicant: Michael Schroeder (representing Jack and Gretchen Norqual) Location: 2 964 and 27968 Smithtown Road Director Darling explained Schroeder Management, on behalf of Jack and Gretchen Norqual, has requested approval of the preliminary and final plat and a lot width variance for the Norqual Addition on the Norquals' properties located at 27964 and 27968 Smithtown Road. The subdivision is related to the vacation request for Item 4.A on the agenda. The applicant has proposed a lot line adjustment to allow both properties to have a separate access to Smithtown Road. After the proposed transfer of land the width of the 27968 property would be 50 feet at the front setback which is short of the 120 -foot requirement thereby necessitating a lot width variance. If approved the new driveway and water service would be provided to the 27968 property. Darling noted staff and the Planning Commission recommend approval of the request. She also noted no members of the public requested to speak during the public hearing for this item. CITY OF SHOREWOOD REGULAR COUNCIL MEETING MINUTES November 27, 2017 Page 5 of 10 In response to a question from Mayor Zerby, Director Darling explained no changes are proposed to the existing driveway on the 27964 property. Sundberg moved, Labadie seconded, Adopting RESOLUTION NO. 17 -105. `A Resolution Approving Preliminary and Final Plat and Variance for Norqual Addition Located at 27968 and 27964 Smithtown Road." Motion passed 510. D. Side Yard Setback Variance Applicant: William and Melanie Keegan Location: 25830 Birch Bluff Road Director Darling explained that William and Melanie Keegan, 25830 Birch Bluff Road, have requested a side yard variance to place an air conditioner within the 10 -foot side yard setback The Zoning Code specifically states that air conditioning equipment may not be located less than 10 feet from the side property line. The proposed location for the conditioner is directly opposite of the Keegans' neighbors' two air conditioners and generator. The applicants have chosen a quieter air conditioner in order to avoid raising concerns with their neighbors. The applicants believe that by clustering all of the equipment in one area it would reduce noise along the rest of the property line. She noted staff determined that the applicants had met the findings for the variance and recommends approval and that the Planning Commission unanimously recommended approval. She then noted the Commission had received two letters of support for the application;, one from the owner of the adjacent property and the other from the owner of a property several properties away. Darling showed photographs of the area where the neighbors' mechanical equipment is located and the proposed location for the applicants' air conditioner. William Keegan, 25830 Birch Bluff, 'Road, expressed his appreciation for Council considering their application. He stated their neighbors' immediately next door support the location that has been proposed; the neighbors did not want it to be located on the lake side. He clarified that the other property owners that wrote a letter of support live three properties down from theirs. He had not solicited a letter from then. He stated he and his wife believe the location they proposed is the best. He noted their old home used to be located four feet from the side property line and the new one is located 10 feet from the side property line. Their lot is only 60 feet wide. Councilmen7ber Johnson commented that it was unfortunate that this was not included with the applicants' 2016 application for variances for the redevelopment of their nonconforming lot. Labadie moved, Johnson seconded, Adopting RESOLUTION NO. 17 -106. `A Resolution Granting a Setback Variance for William and Melanie Keegan for Property Located at 25830 Birch Bluff Road." Motion passed 5/4. E. Front Yard Setback Variance Applicant: Channing and Jessica Scott Location: 5915 Galpin Lake Road Director Darling explained that Channing and Jessica Scott, 5915 Galpin Lake Road, have requested a front yard setback variance so they can build a second story addition on their home and attached garage. The property is located along Galpin Lake and Galpin Lake Road. The existing garage was constructed with a front setback of 25.1 feet rather than the required 35 feet. The Zoning Ordinance does require that CITY OF SHOREWOOD REGULAR COUNCIL MEETING MINUTES November 27, 2017 Page 6 of 10 a nonconforming single - family house can only be expanded if the expansion does not increase the nonconformity. Adding a second story to a nonconforming structure would expand the nonconformity. Therefore, a variance is required for the expansion. The proposed new living area over the garage would be for a parents' suite for their aging parents. The addition was designed to improve the appearance of house from the street. Staff determined the applicant met some of the variance standards better than others. The increase in height would not cast a shadow over another property. There are a wide variety of setbacks of the houses along the street. What has been proposed would not negatively impact the neighborhood. But, it would increase the nonconformity. Darling noted the Planning Commission voted to recommend approval of the request. One of the four Commissioners in attendance opposed it. Councilmember Sundberg stated she thought what has been proposed would be a,very nice enhancement. Councilmember Johnson provided some context for the no vote by one Planning Commissioner. He stated there was concern that approving this application could potentially establish precedent for increasing nonconformity. He noted Director Darling had explained that- from her, vantage point each variance is unique on its own and people should not take what has been approved for one variance application and automatically apply it to another variance application. Sundberg moved, Siakel seconded, Adopting RESOLUTION NO. 17 -107A Resolution Granting a Setback Variance to Channing and Jessica Scott on Property Located at 5915 Galpin Lake Road." Motion passed 510. 8. ENGINEERING /PUBLIC WORKS A. Agreenient to Purchase Jet Vac Sewer Truck Director Brown explained Shorewood currently owns a vacuum trailer and a jetter trailer. Those units are used to clear obstructions in the sanitary sewer system. During his 25 -year tenure with Shorewood the Cities of Excelsior and Tonka Bay have jointly owned and operated a jet/vac sewer truck. Excelsior and Tonka Bay are going to replace their trdek. Shorewood staff had asked the other two cities if Shorewood could,participate in that joint purchase of new truck. The Public Works Director /Superintendents drafted a Joint Purchase, Agreement (the Agreement). The Cities' Attorneys have reviewed and revised it. The Agreement stipulates that each city will pay one -third of the total purchase cost. It also stipulates that Tonka Bay will perform the administrative tasks. Tonka Bay will be compensated for its staff's time to do that; it will invoice the other two cities semiannually. The cost for those services should be minor. Excelsior will store the new jet/vac truck. Each city will have access to the stored unit around the clock. Shorewood and Tonka Bay will each pay Excelsior $100 a month for storage costs. That will also help pay for the cost of the modifications (e.g.; a larger door) Excelsior will have to make to its storage unit to accommodate the new truck. There are provisions in the Agreement regarding disposal of the equipment once it reaches its maturity date. The total purchase cost of the equipment is $353,998. Each of the three cities will pay one -third (or approximately $117,996) of that cost. Shorewood would get a $25,000 credit for the trade in of its two pieces of existing equipment. CITY OF SHOREWOOD REGULAR COUNCIL MEETING MINUTES November 27, 2017 Page 7 of 10 Brown noted that staff recommends approval of the Agreement. Mayor Zerby stated keeping the sanitary sewer system properly maintained and functioning is extremely important. He asked if the new truck would be fully utilized by the three cities or would there be an opportunity to bring a fourth city into the joint purchase and use of the truck. Director Brown stated the three cities would max out the use of the truck. Zerby asked if there would be a scheduling calendar for planned use of the truck. Brown responded yes. Brown explained it is likely Shorewood will use the truck more because it has more sewer pipe than the other two cities. Shorewood tries to maintain one -fifth of its system annuallyas,required by its insurance carrier. Each city understands that if there is an emergency in one city that city can use the equipment to address the problem and then return it to which ever city had been using ii, Councilmember Johnson asked how prioritization of use would work if there was, for example, a storm that causes problems in the three cities. Director Brown stated it is going to be up to the Public Works Director /Superintendents to work that out; they have worked together cooperativelyin the past. Councilmember Siakel asked how many people are licensed to operate that type of truck. Director Brown stated all of Shorewood's light equipment operators are licensed to drive that truck. Mayor Zerby asked if the jet/vac equipment replacement is planned for in the Capital Improvement Program (CIP). Director Brown stated it is slated for replacement in the 2018 CIP. Brown noted it will take about three months to build out the new truck,once it has been ordered and clarified that the funding would come out of Sanitary Sewer Fund. Councilmember Sundberg asked what the condition is of Shorewood's existing two trucks and what their trade -in value is. Director Brown explained, the proble' of Shorewood's equipment not being strong enough to clear an obstruction is becoming more common. The proposed jet/vac truck will have more power than Shorewood's trailered units. horewood's getter unit (it clears the pipe) was purchased as a used demo unit 15 to 20 years ago and its service life has about reached the end. The vacuum unit is fairly new but it does not have the power that is needed: He reiterated Shorewood will receive a combined $25,000 trade - in credit'for its two units. He thought that credit is fair. Councilmember Sundberg asked if weather events create emergency needs for j et/vac equipment. Director Brown clarified the main use of (about 80 percent) the jet/vac equipment is for preventative maintenance. It will also be used to help clean out debris in sump catch basins. He stated the most recent emergency Shorewood had with its sanitary sewer system was an obstruction caused by a mop head. He then stated if there is a failure of a Metropolitan Council Environmental Services (MCES) lift station that could affect a wide area and that is up to MCES to fix. Mayor Zerby stated he recently heard that pouring cooking grease down a drain can clog the sewer pipes. He suggested putting something on the city's website or publishing it in the newsletter encouraging residents not to do that or other things that could clog the pipes. Director Brown stated the biggest sanitary sewer system obstruction issue nationwide is caused by things like flushable wipes. He explained that on some products the packaging states those products are flushable when in reality they can jam up a wastewater pump quickly. The City Engineers Association CITY OF SHOREWOOD REGULAR COUNCIL MEETING MINUTES November 27, 2017 Page 8 of 10 and the Public Works Association have attempted to get legislation changed to address that issue. He agreed that an education piece on the website would be helpful. Councilmember Johnson noted he supports Shorewood making an effort to try and educate people about what should not be flushed into or drained into the sanitary sewer system and why. Johnson asked what type of signage would be placed on the new jointly owned jet/vac truck and should that be specified in the Agreement. Director Brown stated that in the past Excelsior and Tonka Bay routinely had both their names on the truck. He assumed all three cities will have their name on the new truck. Director Brown acknowledged that this opportunity is an example together cooperatively to the benefit of all three. Councilmember Siakel stated she fully supports moving with how it is working out. Director Brown noted the Excelsior City Council the three cities can work this Agreement on N sed her pleasure Siakel moved, Johnson seconded, approving the Joint Purchase Agreement between the City of Tonka Bay, the City of Excelsior and the City of Shorewoodfor, the cooperative purchase and use of public works equipment. Motion passed 510. 9. 10. GENERAL /NEW BUSINESS STAFF AND COUN A. A 1. Mayor Zerby note, budgeted Budget a_ Other �IL REPORTS r and,.Staff hly Budget Report eting °packet c of the October 2017 Monthly Budget Report. Lerud stated he thought the Interim Finance Director's memorandum included in the t was self - explanatory. He noted that year -to -date licenses and permits exceeded the ant by about 10 percent and General Fund expenditures are up about 2.6 percent. The to be on track. Director Brown stated the two speed awareness display signs along Country Club Road are both functioning correctly. He then stated the South Lake Minnetonka Police Department (SLMPD) Chief of Police has conducted one speed survey along Mill Street and second will be conducted on November 28 at the other end of the corridor. Mayor Zerby stated it is his understanding that that the flashing stops signs will be put up that week at the Country Club Road and Lake Linden Drive intersections with Yellowstone Trail. Engineer Fauske confirmed that. CITY OF SHOREWOOD REGULAR COUNCIL MEETING MINUTES November 27, 2017 Page 9 of 10 Director Brown stated that the contractor has stabilized the site for Badger Park in preparation for snow. He explained the ball field lights will continue to stay on later than normal until the new parking lot lights are installed. Mayor Zerby asked when the warming house in Badger Park will be demolished. Director Brown stated per the contractor it will not be demolished until spring 2018. Zerby stated it needs to be secured noting that a number of windows are broken. Brown stated Public Works intends to board the windows up. Administrator Lerud stated reroofing of the Southshore Center had been started the previous week; the contractor hopes to finish it by the end of the current week. He then stated he had received estimates back from contractors for the cosmetic changes that need to be made to the Center. His goal is to bring that information to Council along with a budget and work plan in December, . B. Mayor and City Council Councilmember Labadie asked Administrator Lerud if he had received any feedback from Minnesota Representative City Pugh about concerns brought up to her by Council. Lerud noted he, had not. Labadie explained that during a September 25, 2017, work session Council met with Representative Pugh who is a representative for Shorewood at the State Legislature. During that work session Council raised several issues including but not limited to:, l) aquatic invasive species (AIS) — specifically Eurasian watermilfoil, curl leaf pondweed and zebra mussels; 2) the lack of stoplights from the intersection of Smithtown Road /Rolling Acres and Highway 7 to the intersection of Highway °7 and Highway 41; and, 3) pan handling and begging done by people who, stand in the County /State Highway right -of -way (ROW) near the intersection of Highway 7 and Highway 41. The City has been told that it cannot do anything about the pan handlers because they stand in the State median/ROW. During the work session Representative Pugh told Council that this was a wonderful time of the year to address those issues because the Legislature was not in session and that she would be happy to look into those issues. During Council's October 9, 2017, regular meeting Administrator Lerud was asked if the City had heard back from Representative Pugh and Council learned the City had not. On October 11 Lerud, on behalf of the City of Shorewood, sent a'follow up letter to Representative Pugh. During Council's October 25 regular meeting Lerud,was,asked if�RepresentativePugh had responded to his letter and Council learned she had not. Labadie noted the City needs to rely on Representative Pugh to bring the City's concerns forward to the State Legislature. Therefore, she Mends to continue to pursue Representative Pugh until she addresses the issues that were presented by Shorewood's elected officials; valid issues raised by Shorewood residents. She stated she considered Representative Pugh's lack of follow through to be in complete disregard of the residents. She then stated she thought the lack of stoplights on that section of Highway 7 as well as the vagrancy and begging being done in the median can impact safety. And, AIS is on everyone's mind. She intends on continuing to update the residents on the response or lack thereof from Representative Pugh. Councilmember Sundberg suggested Council invite Representative Pugh to come back before Council to address those same issues. She also suggested those same issues be conveyed to Shorewood's representative to the Minnesota Senate. Councilmember Labadie thanked Administrator Lerud for continuing to voice Council's concerns to Representative Pugh. CITY OF SHOREWOOD REGULAR COUNCIL MEETING MINUTES November 27, 2017 Page 10 of 10 Councilmember Sundberg noted she had attended the most recent meeting on Hennepin County Comprehensive Plan. She stated some progress has been made on that Plan but not enough to report back to Council on it. She has been trying to bring some focus to the smaller outer ring cities' issues. In the past the focus has been mainly on inner cities' issues. She then stated she thought the League of Minnesota Cities (LMC) annual meeting was scheduled for November 29, 2017, and noted that she planned on attending it. Mayor Zerby noted that on November 14, 2017 he attended a meeting hosted as a mayors' meeting. LMA Executive Director PLM Lake and Land Management Corp., both presented about discussion about how effective the treatment of AIS has been i n funded. Treatments have proven to be effective but they must be There was a short discussion about how to eliminate Eurasian w that would require substantial funding. He commented that only c attended the meeting; other cities had sent staff to the meeting. 11. ADJOURN Sundberg moved, Labadie seconded, Adjourning the 27, 2017, at 8:06 P.M. Motion passed 510. RESPECTFULLY SUBMITTED, Christine Freeman, Recorder ATTEST: Sandie Thone, City Cler Lake Minnetonka Association (LMA) Eric Evenson and Patrick Selter, with AIS control. He explained there was direct; correlation to how it has been kept up with some degree of frequency. atermilfoil from Lake Minnetonka but other Zerby, Mayor area mayor of November ® #2B MEETING TYPE City of Shorewood nib Meeting Item Regular Meeting Title / Subject: Verified Claims Meeting Date: December 11, 2017 Prepared by: Michelle Nguyen, Senior Accountant Greg Lerud, City Administrator Attachments: Claims lists Policy Consideration: Should the attached claims against the City of Shorewood be paid? Background: Claims for council authorization. 64139— 64171 & ACH 214,791.40 Total Claims $214,791.40 We have also included a payroll summary for the payroll period ending November 26, 2017. Financial or Budget Considerations: These expenditures are reasonable and necessary to provide services to our residents and funds are budgeted and available for these purposes. Options: The City Council is may accept the staff recommendation to pay these claims or may reject any expenditure it deems not in the best interest of the city. Recommendation / Action Requested: Staff recommends approval of the claims list as presented. Next Steps and Timelines: Checks will be distributed following approval. Account Number Debit Amount Credit Amount Description FUND 101 General Fund 101 -00- 1010 -0000 0.00 52,473.09 CASH AND INVESTMENTS 101 -11- 4103 -0000 1,716.64 0.00 PART -TIME 101 -11- 4122 -0000 131.31 0.00 FICA CONTRIB - CITY SHARE 101 -13- 4101 -0000 10,364.74 0.00 FULL -TIME REGULAR 101 -13- 4103 -0000 295.21 0.00 PART -TIME 101 -13- 4121 -0000 799.49 0.00 PERA CONTRIB - CITY SHARE 101 -13 -4122 -0000 810.39 0.00 FICA CONTRIB - CITY SHARE 101 -13- 4131 -0000 1,601.63 0.00 EMPLOYEE INSURANCE - CITY 101 -13- 4151 -0000 81.56 0.00 WORKERS COMPENSATION 101 -15- 4101 -0000 1,824.50 0.00 FULL -TIME REGULAR 101 -15- 4121 -0000 136.85 0.00 PERA CONTRIB - CITY SHARE 101 -15 -4122 -0000 137.05 0.00 FICA CONTRIB - CITY SHARE 101 -15- 4131 -0000 156.00 0.00 EMPLOYEE INSURANCE - CITY 101 -15- 4151 -0000 6.43 0.00 WORKERS COMPENSATION 101 -18- 4101 -0000 5,535.92 0.00 FULL -TIME REGULAR 101 -18- 4121 -0000 415.19 0.00 PERA CONTRIB - CITY SHARE 101 -18 -4122 -0000 416.41 0.00 FICA CONTRIB - CITY SHARE 101 -18- 4131 -0000 462.12 0.00 EMPLOYEE INSURANCE - CITY 101 -18- 4151 -0000 23.32 0.00 WORKERS COMPENSATION 101 -24- 4101 -0000 4,124.41 0.00 FULL-TIME REGULAR 101 -24- 4121 -0000 309.34 0.00 PERA CONTRIB - CITY SHARE 101 -24 -4122 -0000 261.03 0.00 FICA CONTRIB - CITY SHARE 101 -24- 4131 -0000 515.00 0.00 EMPLOYEE INSURANCE - CITY 101 -24- 4151 -0000 24.18 0.00 WORKERS COMPENSATION 101 -32 -4101 -0000 10,233.18 0.00 FULL -TIME REGULAR 101 -32 -4102 -0000 46.67 0.00 OVERTIME 101 -32 -4121 -0000 770.99 0.00 PERA CONTRIB - CITY SHARE 101 -32 -4122 -0000 755.76 0.00 FICA CONTRIB - CITY SHARE 101 -32 -4131 -0000 1,899.66 0.00 EMPLOYEE INSURANCE - CITY 101 -32 -4151 -0000 413.45 0.00 WORKERS COMPENSATION 101 -33- 4101 -0000 39.32 0.00 FULL -TIME REGULAR 101 -33- 4121 -0000 2.96 0.00 PERA CONTRIB - CITY SHARE 101 -33 -4122 -0000 2.59 0.00 FICA CONTRIB - CITY SHARE 101 -33- 4151 -0000 0.48 0.00 WORKERS COMPENSATION PR - G/L Distribution Report (11/27/2017 - 12:31 PM) Page 1 Account Number Debit Amount Credit Amount Description 101 -52 -4101 -0000 4,810.00 0.00 FULL -TIME REGULAR 101 -52 -4121 -0000 360.75 0.00 PERA CONTRIB - CITY SHARE 101 -52 -4122 -0000 376.71 0.00 FICA CONTRIB - CITY SHARE 101 -52 -4131 -0000 1,086.61 0.00 EMPLOYEE INSURANCE - CITY 101 -52 -4151 -0000 250.48 0.00 WORKERS COMPENSATION 101 -53- 4101 -0000 1,064.30 0.00 FULL -TIME REGULAR 101 -53- 4121 -0000 79.84 0.00 PERA CONTRIB - CITY SHARE 101 -53 -4122 -0000 79.76 0.00 FICA CONTRIB - CITY SHARE 101 -53- 4131 -0000 22.28 0.00 EMPLOYEE INSURANCE - CITY 101 -53- 4151 -0000 28.58 0.00 WORKERS COMPENSATION FUND Total: 52,473.09 52,473.09 FUND 201 Southshore Center 201 -00- 1010 -0000 0.00 1,620.94 CASH AND INVESTMENTS 201 -00- 4101 -0000 847.97 0.00 FULL -TIME REGULAR 201 -00 -4102 -0000 218.40 0.00 OVERTIME 201 -00- 4103 -0000 372.50 0.00 PART -TIME 201 -00- 4121 -0000 63.59 0.00 PERA CONTRIB - CITY SHARE 201 -00 -4122 -0000 88.60 0.00 FICA CONTRIB - CITY SHARE 201 -00- 4151 -0000 29.88 0.00 WORKERS COMPENSATION FUND Total: 1,620.94 1,620.94 FUND 601 Water Utility 601 -00- 1010 -0000 0.00 4,759.39 CASH AND INVESTMENTS 601 -00- 4101 -0000 3,579.80 0.00 FULL -TIME REGULAR 601 -00- 4121 -0000 268.46 0.00 PERA CONTRIB - CITY SHARE 601 -00 -4122 -0000 256.11 0.00 FICA CONTRIB - CITY SHARE 601 -00- 4131 -0000 588.79 0.00 EMPLOYEE INSURANCE - CITY 601 -00- 4151 -0000 66.23 0.00 WORKERS COMPENSATION FUND Total: 4,759.39 4,759.39 FUND 611 Sanitary Sewer Utility 611 -00- 1010 -0000 0.00 6,448.22 CASH AND INVESTMENTS 611 -00- 4101 -0000 4,967.86 0.00 FULL -TIME REGULAR 611 -00 -4102 -0000 90.87 0.00 OVERTIME 611 -00- 4121 -0000 379.41 0.00 PERA CONTRIB - CITY SHARE 611 -00 -4122 -0000 335.08 0.00 FICA CONTRIB - CITY SHARE 611 -00- 4131 -0000 588.79 0.00 EMPLOYEE INSURANCE - CITY 611 -00- 4151 -0000 86.21 0.00 WORKERS COMPENSATION FUND Total: 6,448.22 6,448.22 PR - G/L Distribution Report (11/27/2017 - 12:31 PM) Page 2 Account Number Debit Amount Credit Amount Description FUND 621 Recycling Utility 621 -00- 1010 -0000 0.00 470.83 CASH AND INVESTMENTS 621 -00- 4101 -0000 346.35 0.00 FULL -TIME REGULAR 621 -00- 4121 -0000 25.97 0.00 PERA CONTRIB - CITY SHARE 621 -00 -4122 -0000 25.11 0.00 FICA CONTRIB - CITY SHARE 621 -00- 4131 -0000 71.73 0.00 EMPLOYEE INSURANCE - CITY 621 -00- 4151 -0000 1.67 0.00 WORKERS COMPENSATION FUND Total: 470.83 470.83 FUND 631 Storm Water Utility 631 -00- 1010 -0000 0.00 717.96 CASH AND INVESTMENTS 631 -00- 4101 -0000 579.89 0.00 FULL -TIME REGULAR 631 -00- 4121 -0000 43.50 0.00 PERA CONTRIB - CITY SHARE 631 -00 -4122 -0000 42.85 0.00 FICA CONTRIB - CITY SHARE 631 -00- 4131 -0000 48.02 0.00 EMPLOYEE INSURANCE - CITY 631 -00- 4151 -0000 3.70 0.00 WORKERS COMPENSATION FUND Total: 717.96 717.96 FUND 700 Payroll Clearing Fund 700 -00- 1010 -0000 66,490.43 0.00 CASH AND INVESTMENTS 700 -00- 2170 -0000 0.00 33,609.22 GROSS PAYROLL CLEARING 700 -00- 2171 -0000 0.00 6,575.64 HEALTH INSURANCE PAYABLE 700 -00 -2172 -0000 0.00 4,641.07 FEDERAL WITHHOLDING PAYABLE 700 -00- 2173 -0000 0.00 1,992.53 STATE WITHHOLDING PAYABLE 700 -00- 2174 -0000 0.00 7,437.52 FICA/MEDICARE TAX PAYABLE 700 -00- 2175 -0000 0.00 6,825.17 PERA WITHHOLDING PAYABLE 700 -00- 2176 -0000 0.00 1,699.52 DEFERRED COMPENSATION 700 -00- 2177 -0000 0.00 1,016.17 WORKERS COMPENSATION 700 -00- 2181 -0000 0.00 1,098.62 DISABILITY INSURANCE 700 -00- 2183 -0000 0.00 735.77 HEALTH SAVINGS ACCOUNT 700 -00- 2184 -0000 0.00 502.20 DENTAL DELTA 700 -00- 2185 -0000 0.00 357.00 DENTAL - UNION FUND Total: 66,490.43 66,490.43 Report Total: 132,980.86 132,980.86 PR - G/L Distribution Report (11/27/2017 - 12:31 PM) Page 3 Accounts Payable Computer Check Proof List by Vendor User: mnguyen Printed: 11/27/2017- 1:51PM Batch: 00004.11.2017 - PR -11 -27 -2017 Invoice No Description Amount Payment Date Acct Number Vendor: 4 AFSCME CO 5 MEMBER HEALTH FUND Check Sequence: 1 November -2017 PR Batch 00002.11.2017 Dental - Union 357.00 11/27/2017 700 -00- 2185 -0000 Check Total: 357.00 Vendor: 111 AMERICAN ENGINEERING TESTING, INC. Check Sequence: 2 99242 MCC- 1st Addition 2,276.40 11/27/2017 450 -00- 4302 -0016 99243 Badger Park Phase 2 2,580.50 11/27/2017 402 -00- 4680 -0000 Check Total: 4,856.90 Vendor: 3 DELTA DENTAL OF MINNESOTA Check Sequence: 3 Nov - 2017 -COBRA November - COBRA - Jean Panchysynh 44.55 11/27/2017 700 -00- 2184 -0000 November -2017 PR Batch 00002.11.2017 Dental - Non Union 502.20 11/27/2017 700 -00- 2184 -0000 Check Total: 546.75 Vendor: 167 ECM PUBLISHERS INC Check Sequence: 4 548691 Ord. No. 549 46.26 11/27/2017 101 -13- 4351 -0000 548692 Ord. No. 548 65.54 11/27/2017 101 -13- 4351 -0000 550836 Ord. No. 549 70.50 11/27/2017 101 -13- 4351 -0000 550837 Ord. No. 548 99.88 11/27/2017 101 -13- 4351 -0000 Check Total: 282.18 Vendor: 5 EFTPS - FEDERAL W/H Check Sequence: 5 PR -11 -27 -2017 PR Batch 00002.11.2017 Federal Income Tax 4,641.07 11/27/2017 700 -00- 2172 -0000 PR -11 -27 -2017 PR Batch 00002.11.2017 FICA Employee Portio 3,013.91 11/27/2017 700 -00- 2174 -0000 PR -11 -27 -2017 PR Batch 00002.11.2017 FICA Employer Portioi 3,013.91 11/27/2017 700 -00- 2174 -0000 PR -11 -27 -2017 PR Batch 00002.11.2017 Medicare Employee Pc 704.85 11/27/2017 700 -00- 2174 -0000 PR -11 -27 -2017 PR Batch 00002.11.2017 Medicare Employer Po 704.85 11/27/2017 700 -00- 2174 -0000 Check Total: 12,078.59 Reference ACH Enabled: True PR Batch 00002.11.2017 Dental - Union ACH Enabled: False ACH Enabled: True PR Batch 00002.11.2017 Dental - Non Uni PR Batch 00002.11.2017 Dental - Non Uni ACH Enabled: True ACH Enabled: True PR Batch 00002.11.2017 Federal Income 'I PR Batch 00002.11.2017 FICA Employee PR Batch 00002.11.2017 FICA Employer I PR Batch 00002.11.2017 Medicare Emplo, PR Batch 00002.11.2017 Medicare Emplo, AP- Computer Check Proof List by Vendor (11/27/2017 - 1:51 PM) Page 1 Invoice No Description Amount Payment Date Acct Number Reference Vendor: 6 HEALTH PARTNERS -GROUP Check Sequence: 6 ACH Enabled: False Nov - 2017 -COBRA Nov -COBRA - Jean Panchysynh 569.54 11/13/2017 700 -00- 2171 -0000 PR Batch 00001.11.2017 Health Insurance Nov - 2017 -COBRA Nov -COBRA - Bruce DeJong 1,595.75 11/13/2017 700 -00- 2171 -0000 PR Batch 00001.11.2017 Health Insurance November -2017 PR Batch 00002.11.2017 Health Ins - CoPay 2,201.64 11/27/2017 700 -00- 2171 -0000 PR Batch 00002.11.2017 Health Ins - Cop, November -2017 PR Batch 00002.11.2017 Health Insurance -HSA 4,374.00 11/27/2017 700 -00- 2171 -0000 PR Batch 00002.11.2017 Health Insurance November -2017 PR Batch 00001.11.2017 Health Ins - CoPay 2,201.64 11/13/2017 700 -00- 2171 -0000 PR Batch 00001.11.2017 Health Ins - Cop, November -2017 PR Batch 00001.11.2017 Health Insurance -HSA 4,374.00 11/13/2017 700 -00- 2171 -0000 PR Batch 00001.11.2017 Health Insurance Check Total: 15,316.57 Vendor: 2 ICMA RETIREMENT TRUST - 302131 -457 Check Sequence: 7 ACH Enabled: False PR -11 -27 -2017 PR Batch 00002.11.2017 Deferred Comp Flat Ar 1,550.00 11/27/2017 700 -00- 2176 -0000 PR Batch 00002.11.2017 Deferred Comp F PR -11 -27 -2017 PR Batch 00002.11.2017 Deferred Comp Percen 149.52 11/27/2017 700 -00- 2176 -0000 PR Batch 00002.11.2017 Deferred Comp F Check Total: 1,699.52 Vendor: 686 KANSAS CITY LIFE INSURANCE COMPAN' Check Sequence: 8 ACH Enabled: True November -2017 PR Batch 00002.11.2017 Long Term Disability 507.32 11/27/2017 700 -00- 2181 -0000 PR Batch 00002.11.2017 Long Term Disat November -2017 PR Batch 00002.11.2017 Short Term Disability 591.30 11/27/2017 700 -00- 2181 -0000 PR Batch 00002.11.2017 Short Term Disat November -2017 PR Batch 00002.11.2017 Long Term Disability 84.34 11/27/2017 700 -00- 2181 -0000 PR Batch 00002.11.2017 Long Term Disat Check Total: 1,182.96 Vendor: 482 KUTAK ROCK LLP Check Sequence: 9 ACH Enabled: True 2360165 General Corporate 1,850.00 11/27/2017 101 -16- 4304 -0000 2360166 Public Improvement Project 869.50 11/27/2017 404 -00- 4620 -0014 2360173 Administrative Code 1,202.50 11/27/2017 101 -16- 4304 -0000 2360284 Minnetonka Country Club 55.50 11/27/2017 450 -00- 4302 -0016 2360913 Utility Franchise Ord- CtrPoint 1,350.50 11/27/2017 101 -16- 4304 -0000 2361274 Franchise Utility Fees -Gas 425.50 11/27/2017 101 -16- 4304 -0000 2362222 Cathcart Park 851.00 11/27/2017 402 -00- 4304 -0000 Check Total: 6,604.50 Vendor: 286 MIDWEST MAILING SYSTEMS INC Check Sequence: 10 ACH Enabled: True 76845 Newsletter Svc - December 424.28 11/27/2017 101 -13- 4400 -0000 76845 Newsletter Postages- December 454.33 11/27/2017 101 -13- 4208 -0000 Check Total: 878.61 Vendor: 11 MINNESOTA DEPARTMENT OF REVENUE Check Sequence: 11 ACH Enabled: True PR -11 -27 -2017 PR Batch 00002.11.2017 State Income Tax 1,992.53 11/27/2017 700 -00- 2173 -0000 PR Batch 00002.11.2017 State Income Tax AP- Computer Check Proof List by Vendor (11/27/2017 - 1:51 PM) Page 2 Invoice No Description Amount Payment Date Acct Number Reference AP- Computer Check Proof List by Vendor (11/27/2017 - 1:51 PM) ACH Enabled: True PR Batch 00002.11.2017 HSA - OPTUM B. ACH Enabled: True PR Batch 00002.11.2017 MN -PERA Dedu PR Batch 00002.11.2017 MN PERA Benel ACH Enabled: False ACH Enabled: False Page 3 Check Total: 1,992.53 Vendor: 665 OPTUM BANK Check Sequence: 12 PR -11 -27 -2017 PR Batch 00002.11.2017 HSA - OPTUM BANK 735.77 11/27/2017 700 -00- 2183 -0000 Check Total: 735.77 Vendor: 9 PERA Check Sequence: 13 PR -11 -27 -2017 PR Batch 00002.11.2017 MN -PERA Deduction 3,168.83 11/27/2017 700 -00- 2175 -0000 PR -11 -27 -2017 PR Batch 00002.11.2017 MN PERA Benefit Em 3,656.34 11/27/2017 700 -00- 2175 -0000 Check Total: 6,825.17 Vendor: 840 RANDY'S ENVIRONMENTAL SERVICES Check Sequence: 14 5675StarCir 5675 Star Circle 59.00 11/27/2017 621 -00- 4400 -0026 Check Total: 59.00 Vendor: 384 TOTAL PRINTING SERVICES Check Sequence: 15 11752 Arctic Fever Inserts 438.50 11/27/2017 101 -53- 4441 -0000 11752 Dog License Inserts 150.00 11/27/2017 101 -13- 4351 -0000 11752 Newsletter - December 794.50 11/27/2017 101 -13- 4351 -0000 Check Total: 1,383.00 Total for Check Run: 54,799.05 Total of Number of Checks: 15 AP- Computer Check Proof List by Vendor (11/27/2017 - 1:51 PM) ACH Enabled: True PR Batch 00002.11.2017 HSA - OPTUM B. ACH Enabled: True PR Batch 00002.11.2017 MN -PERA Dedu PR Batch 00002.11.2017 MN PERA Benel ACH Enabled: False ACH Enabled: False Page 3 Accounts Payable Computer Check Proof List by Vendor User: mnguyen Printed: 12/06/2017 - 3:35PM Batch: 0000 1. 12.2017 - CC -12 -11 -2017 Invoice No Description Amount Payment Date Acct Number Reference Vendor: 105 ADVANCED IMAGING SOLUTIONS Check Sequence: 1 ACH Enabled: True INV151749 Black Toner 67.70 12/11/2017 101 -13- 4200 -0000 Check Total: 67.70 Vendor: 455 BERGAN -KDV Check Sequence: 2 ACH Enabled: False 978270 Finance Service 5,985.00 12/11/2017 101 -15- 4400 -0000 978270 Finance Service 855.00 12/11/2017 601 -00- 4400 -0000 978270 Finance Service 855.00 12/11/2017 611 -00- 4400 -0000 978270 Finance Service 855.00 12/11/2017 631 -00- 4400 -0000 Check Total: 8,550.00 Vendor: 508 BRYAN ROCK PRODUCTS, INC. Check Sequence: 3 ACH Enabled: False 26581 Ice Rink - Freeman Park 412.57 12/11/2017 101 -52- 4245 -0000 Check Total: 412.57 Vendor: 136 CENTERPOINT ENERGY Check Sequence: 4 ACH Enabled: False 11 -29 -2017 20405 Knighsbridge Rd 54.87 12/11/2017 601 -00- 4394 -0000 11 -29 -2017 28125 Boulder Bridge 160.72 12/11/2017 601 -00- 4396 -0000 11 -29 -2017 24200 Smithtown Rd 338.61 12/11/2017 101 -32- 4380 -0000 11 -29 -2017 5745 Ctry Club & 25200 Hwy 7 129.33 12/11/2017 101 -52- 4380 -0000 11 -29 -2017 5755 Country Club Rd 208.03 12/11/2017 101 -19- 4380 -0000 Check Total: 891.56 Vendor: 137 CENTURY LINK Check Sequence: 5 ACH Enabled: False 9524702294 -No17 952 - 470 - 2294 -PW 59.56 12/11/2017 101 -32- 4321 -0000 9524706340 -No17 952 - 474 - 6340 -CH 242.82 12/11/2017 101 -19- 4321 -0000 9524707819 -No17 952 - 470 - 7819 -SSCC 115.67 12/11/2017 201 -00- 4321 -0000 New Line 9524709605 -No17 952 - 474 - 9605 - Amesbury 223.73 12/11/2017 601 -00- 4394 -0000 9524709606 -No17 952 - 474 - 9606 - Amesbury 147.98 12/11/2017 601 -00- 4394 -0000 AP- Computer Check Proof List by Vendor (12/06/2017 - 3:35 PM) Page 1 Invoice No Description Amount Payment Date Acct Number Reference AP- Computer Check Proof List by Vendor (12/06/2017 - 3:35 PM) Page 2 Check Total: 789.76 Vendor: 828 CROWN TROPHY Check Sequence: 6 ACH Enabled: False 20430 Service Award - Janet Sylvester 70.00 12/11/2017 101 -11- 4245 -0000 Check Total: 70.00 Vendor: 219 ELLY PIEPER Check Sequence: 7 ACH Enabled: False 11 -29 -2017 SSC- Tablecloths 96.00 12/11/2017 201 -00- 4400 -0000 Check Total: 96.00 Vendor: 186 FERGUSON WATERWORKS No.2516 Check Sequence: 8 ACH Enabled: False 0267086 Water Meters 666.70 12/11/2017 601 -00- 4265 -0000 Check Total: 666.70 Vendor: 200 GOPHER STATE ONE CALL Check Sequence: 9 ACH Enabled: True 7110718 Monthly Rental 64.35 12/11/2017 601 -00- 4400 -0000 7110718 Monthly Rental 64.35 12/11/2017 611 -00- 4400 -0000 7110718 Monthly Rental 64.35 12/11/2017 631 -00- 4400 -0000 Check Total: 193.05 Vendor: 202 GRAINGER INC Check Sequence: 10 ACH Enabled: True 9634868609 Voltage Detector 127.60 12/11/2017 101 -32- 4245 -0000 Check Total: 127.60 Vendor: 803 GRANITE LEDGE ELECTRIC Check Sequence: 11 ACH Enabled: False L17685 Relamp Signals - Cty Rd 41 & Hwy 7 489.27 12/11/2017 101 -32- 4400 -0000 Check Total: 489.27 Vendor: 206 TWILA GROUT Check Sequence: 12 ACH Enabled: True 2017 - Reward 20 Years of Service 100.00 12/11/2017 101 -11- 4245 -0000 Check Total: 100.00 Vendor: 879 GRUSSING ROOFING, INC. Check Sequence: 13 ACH Enabled: False 27580Brynmawr Refund Building Permit Fees -27580 Brynmawr 37.50 12/11/2017 101 -00- 3221 -0000 Check Total: 37.50 AP- Computer Check Proof List by Vendor (12/06/2017 - 3:35 PM) Page 2 Invoice No Description Amount Payment Date Acct Number Reference Vendor: 216 HENNEPIN COUNTY - RECORDER/REGIST] Check Sequence: 14 ACH Enabled: False 165896 -1711 EASE Record - User ID - EGQA69 67.00 12/11/2017 101 -31- 4400 -0000 Res17 -104 Resolution Recording 46.00 12/11/2017 101 -18- 4400 -0000 Res17 -106 Resolution Recording 46.00 12/11/2017 101 -18- 4400 -0000 Res17 -107 Resolution Recording 46.00 12/11/2017 101 -18- 4400 -0000 Check Total: 205.00 Vendor: 563 HENNEPIN COUNTY TREASURER Check Sequence: 15 ACH Enabled: False 2018- TruthInTax 2018 Truth In Tax Notices 628.37 12/11/2017 101 -16- 4400 -0000 Check Total: 628.37 Vendor: 247 DREW KRIESEL Check Sequence: 16 ACH Enabled: False November -2017 Building Maint. Services 400.00 12/11/2017 201 -00- 4400 -0000 November -2017 Building General Supplies Exp 29.96 12/11/2017 201 -00- 4245 -0000 November -2017 Events Program/Class Services 879.00 12/11/2017 201 -00- 4248 -0000 Check Total: 1,308.96 Vendor: 531 LEAGUE OF MINNESOTA CITIES Check Sequence: 17 ACH Enabled: False 257987 City of Shorewood Annual Due - 2017 -2018 7,499.00 12/11/2017 101 -11- 4433 -0000 265947 Regional Meeting - Kris Sundberg 30.00 12/11/2017 101 -11- 4331 -0000 Check Total: 7,529.00 Vendor: 841 GREGORY LERUD Check Sequence: 18 ACH Enabled: False Lunch- Sept17 Lunch Meeting with Kristi 22.07 12/11/2017 101 -13- 4331 -0000 Mileage -Dec17 Sept to Dec Mileage 53.23 12/11/2017 101 -13- 4331 -0000 Sams -Dec17 Sam's Exp 79.62 12/11/2017 101 -13- 4245 -0000 Sams -Dec17 Sam's Exp 79.63 12/11/2017 201 -00- 4245 -0000 Check Total: 234.55 Vendor: 262 LUBE -TECH Check Sequence: 19 ACH Enabled: True 1064685 Lube 100.00 12/11/2017 101 -32- 4212 -0000 Check Total: 100.00 Vendor: 263 JOSEPH LUGOWSKI Check Sequence: 20 ACH Enabled: False 2017 - Reward 30 Years of Service 150.00 12/11/2017 101 -11- 4245 -0000 Check Total: 150.00 Vendor: 620 MANGOLD HORTICULTURE Check Sequence: 21 ACH Enabled: True AP- Computer Check Proof List by Vendor (12/06/2017 - 3:35 PM) Page 3 Invoice No Description Amount Payment Date Acct Number Reference 4985 Monthly City Landscape 440.00 12/11/2017 101 -19- 4400 -0000 5064 Monthly SSCC Landscape 340.00 12/11/2017 201 -00- 4400 -0000 Check Total: 780.00 Vendor: 453 METROPOLITAN COUNCIL (SAC) Check Sequence: 22 ACH Enabled: False November -2017 Monthly SAC Report 2,460.15 12/11/2017 611 -00- 2082 -0000 Check Total: 2,460.15 Vendor: 880 MINNESOTA DEPARTMENT OF HEALTH Check Sequence: 23 ACH Enabled: False 2017 -Lic Food Manager Certification Renewal 35.00 12/11/2017 201 -00- 4437 -0000 Check Total: 35.00 Vendor: 456 MINNESOTA PIPE & EQUIP Check Sequence: 24 ACH Enabled: False 0388379 Hytech Supermag Anode Bag 476.47 12/11/2017 601 -00- 4245 -0000 Check Total: 476.47 Vendor: 881 JOSEPH & PAMELA MUELLER Check Sequence: 25 ACH Enabled: False 23310Academy Escrow Refund - 23310 Academy Ave 30,000.00 12/11/2017 880 -00- 2200 -0000 Check Total: 30,000.00 Vendor: 313 MICHELLE THAO NGUYEN Check Sequence: 26 ACH Enabled: True November -2017 Mileage Reimbursement 88.77 12/11/2017 101 -15- 4331 -0000 Check Total: 88.77 Vendor: 325 ON SITE SANITATION -TWIN CITIES Check Sequence: 27 ACH Enabled: True 514847 Freeman Park -88.45 11/27/2017 101 -52- 4410 -0000 515118 Southshore Skate -43.73 11/27/2017 101 -52- 4410 -0000 525263 Badger Pk-5745 Country Club Rd 56.98 12/11/2017 101 -52- 4410 -0000 525264 Cathcart Park -26655 W- 62nd ST 56.98 12/11/2017 101 -52- 4410 -0000 525265 Freeman Park -6000 Eureka Rd 56.98 12/11/2017 101 -52- 4410 -0000 525266 Silverwood Pk -5755 Covington R 56.98 12/11/2017 101 -52- 4410 -0000 525267 Christmas Lk Rd -5625 Merry Ln 236.50 12/11/2017 101 -52- 4410 -0000 Check Total: 332.24 Vendor: 333 PITNEY BOWES GLOBAL FINANCIAL SERA Check Sequence: 28 ACH Enabled: False 3101758232 Quarterly Meter Lease Postage 197.00 12/11/2017 101 -19- 4410 -0000 Acct - 5440954 AP- Computer Check Proof List by Vendor (12/06/2017 - 3:35 PM) Page 4 Invoice No Description Amount Payment Date Acct Number Reference AP- Computer Check Proof List by Vendor (12/06/2017 - 3:35 PM) Page 5 Check Total: 197.00 Vendor: 240 KENNETH POTTS, PA Check Sequence: 29 ACH Enabled: True Feldick- 2009VW Forfeiture - Mary Feldick- 2009 Volkswagen 600.00 12/11/2017 101 -16- 4304 -0000 November -2017 Prosectution Monthly Services 2,500.00 12/11/2017 101 -16- 4304 -0000 Check Total: 3,100.00 Vendor: 883 THOMAS & BRENNA RAMY Check Sequence: 30 ACH Enabled: False 5825CtryClubRd Refund of Rental Housing Application - 5705 Ec 60.00 12/11/2017 101 -24- 3217 -0000 Check Total: 60.00 Vendor: 355 SHRED -N -GO INC Check Sequence: 31 ACH Enabled: False 71263 Shredded Svc 35.83 12/11/2017 101 -13- 4400 -0000 72199 Shredded Svc 35.83 12/11/2017 101 -13- 4400 -0000 73160 Shredded Svc 35.83 12/11/2017 101 -13- 4400 -0000 Check Total: 107.49 Vendor: 360 SOUTH LAKE MINNETONKA POLICE DEPA Check Sequence: 32 ACH Enabled: False 2017- BPVest 2017 Bulletproof Vest 1,328.30 12/11/2017 101 -21- 4245 -0000 Refund -2017 Street Lighting Repair Overpaid Refund 400.00 12/11/2017 101 -32- 4400 -0000 Check Total: 1,728.30 Vendor: 821 SANDRA LEE THONE Check Sequence: 33 ACH Enabled: False Aug- Dec - 2017- Wellnc Wellness Reimbursement- Aug to Dec 200.00 12/11/2017 101 -13- 4101 -0000 Nov - 2017 - Mileag Reimbursement- Nov Mileage 74.90 12/11/2017 101 -13- 4331 -0000 Check Total: 274.90 Vendor: 882 TREE TRUST Check Sequence: 34 ACH Enabled: False 17796 Trees Removal 2,067.49 12/11/2017 101 -32- 4400 -0000 Check Total: 2,067.49 Vendor: 386 TWIN CITY WATER CLINIC Check Sequence: 35 ACH Enabled: False 10814 Monthly Bacteria Svc 120.00 12/11/2017 601 -00- 4400 -0000 Check Total: 120.00 Vendor: 415 WARNER CONNECT Check Sequence: 36 ACH Enabled: True 29935132 Additional Services Charge - Nov Svc 2,092.50 12/11/2017 101 -19- 4321 -0000 AP- Computer Check Proof List by Vendor (12/06/2017 - 3:35 PM) Page 5 Invoice No Description Amount Payment Date Acct Number Reference Check Total: 2,092.50 Vendor: 402 WATER CONSERVATION SERVICES, INC. Check Sequence: 37 7661 Watermain Svc - Sweetwater Cur & Cir 291.40 12/11/2017 601 -00- 4400 -0000 Check Total: 291.40 Vendor: 878 WATSON VINEHILL, LLC Check Sequence: 38 CUP - Refund Conditional Use Permit Application Refund 54.00 12/11/2017 101 -00- 3413 -0000 Check Total: 54.00 Vendor: 408 WM MUELLER & SONS INC Check Sequence: 39 230753 Road Maint 912.00 12/11/2017 101 -32- 4250 -0000 230956 Road Maint 913.71 12/11/2017 101 -32- 4250 -0000 231056 Road Maint 916.56 12/11/2017 101 -32- 4250 -0000 Check Total: 2,742.27 Vendor: 410 WSB AND ASSOCIATES INC Check Sequence: 40 0- 001459 -540 -7 Smithtown Way 306.00 12/11/2017 101 -31- 4303 -0000 0- 001459 - 740 -18 Ashland Woods Utility & Street 76.00 12/11/2017 101 -00- 3414 -0000 0- 001608 - 080 -20 Freeman Park Drainage Analysis 636.50 12/11/2017 631 -00- 4303 -0000 0- 002092 - 710 -32 MS4 Svcs 172.50 12/11/2017 631 -00- 4302 -0009 0- 002925 -020 -3 Shorewood Ln Ravine Restoration 1,080.00 12/11/2017 601 -00- 4303 -0000 0- 002925 - 052 -10 Gen Eng Svc 4,000.00 12/11/2017 101 -31- 4400 -0000 0- 002925 -100 -9 Traffic Committee 380.00 12/11/2017 101 -31- 4303 -0000 0- 002925 - 120 -24 Minnetonka Country Club 1,403.75 12/11/2017 450 -00- 4302 -0016 0- 002925 - 150 -18 Oppidan Senior Living Dvlmt 160.00 12/11/2017 450 -00- 4400 -0019 0- 002925 - 160 -18 Water Main- TIF- Oppidan 785.75 12/11/2017 470 -00- 4303 -0000 0- 002925 - 180 -14 Public Work Ravine Restoration 147.75 12/11/2017 631 -00- 4303 -0000 0- 002925 - 200 -12 Water Supply Plan 189.50 12/11/2017 601 -00- 4303 -0000 0- 002925 -240 -9 Riviera Land & Shorewood Ln St 11,291.50 12/11/2017 404 -00- 4680 -0020 0- 002925 - 260 -10 Pavement Marking 205.75 12/11/2017 404 -00- 4620 -0007 0- 002925 - 270 -10 Misc. Engineering Support 1,345.21 12/11/2017 101 -31- 4303 -0000 0- 002925 -290 -9 Sealcoat Project 1,954.75 12/11/2017 404 -00- 4620 -0006 0- 002925 -300 -8 Badger Park Phase 2 14,063.75 12/11/2017 402 -00- 4680 -0000 0- 002925 -360 -5 2040 Comp Plan Eng. Support 8,181.25 12/11/2017 101 -31- 4303 -0000 0- 002925 -370 -7 Minnetonka Cntry Club 2nd Addn 21,963.75 12/11/2017 450 -00- 4302 -0016 0- 002925 -390 -7 Freeman Park Parking Paving 76.50 12/11/2017 101 -52- 4303 -0000 0- 002925 -400 -6 Street Reclamation Improvement 14,677.00 12/11/2017 404 -00- 4680 -0027 0- 003539 -000 -7 Well No. 5 Rehab 170.00 12/11/2017 601 -00- 4303 -0000 R- 010868 -000 -2 LRIP GRant -Cty Rd /Yellowstone /Lk Linden 2,375.25 12/11/2017 101 -31- 4303 -0000 ACH Enabled: False ACH Enabled: False ACH Enabled: True ACH Enabled: True AP- Computer Check Proof List by Vendor (12/06/2017 - 3:35 PM) Page 6 Invoice No Description Amount Payment Date Acct Number Reference R-010930-000-1 Shorewood Ln Ravine Stabilization 3,530.75 12/11/2017 601 -00- 4303 -0000 R-010954-000-1 Maple Street Vacation 274.00 12/11/2017 101 -31- 4303 -0000 R- 011017 -000 -1 Sanitary Sewer Lining 569.50 12/11/2017 611 -00- 4303 -0000 Check Total: 90,016.71 Vendor: 411 XCEL ENERGY, INC. Check Sequence: 41 570793863 - 112717 5700 County Rd 19 30.40 12/11/2017 101 -32- 4399 -0000 570793863 - 112717 5700 County Rd 19 - Unit Light 229.67 12/11/2017 101 -32- 4399 -0000 Check Total: 260.07 Vendor: 413 ZEE MEDICAL SERVICE Check Sequence: 42 54096529 First Aid Supplies 60.00 12/11/2017 101 -32- 4245 -0000 Check Total: 60.00 Total for Check Run: 159,992.35 Total of Number of Checks: 42 AP- Computer Check Proof List by Vendor (12/06/2017 - 3:35 PM) ACH Enabled: True 5700 County Rd 19 5700 County Rd 19 - Unit Light ACH Enabled: True Page 7 #zC MEETING TYPE City of Shorewood Council Meeting Item REGULAR Title / Subject: Non -Union Wage Adjustments for 2018 Meeting Date: December 11, 2017 Prepared by: Greg Lerud Reviewed by: Joe Rigdon Attachments: 2018 salary calculations and 2018 salary budget estimate Financial or Budget Considerations: The contract with the public works union approved by the City Council includes a 3.0% increase for 2018, and the 2018 includes a 3.0% increase for all non -union employees. One of the goals of Administration staff for 2018 is to re- examine the salary study that was done in late 2016 and see how that plan along with a performance incentive can be implemented. The total salary cost for 2018 is budgeted to be $1,356,193. In addition, the budget calls for an increase of $50 per month per employee toward insurances. Recommendation / Action Requested: The recommend approving the salary adjustments as proposed in this memo and on the attached sheet. Mission Statement: The City of Shorewood is committed to providing residents quality public services, a healthy environment, a variety of attractive amenities, a sustainable tax base, and sound financial management through effective, efficient, and visionary leadership. Page 1 2018 Non -Union Compensation Proposal for Full -time Employee Calculations 2017 2018 Position Actual Proposed Director of Public Works 107,514 110,750 Rec. Coord /Admin. Asst. 60,555 62,300 Asst. Planner 70,589 72,705 Communications /Recycling 59,119 60,900 Coordinator Sr. Acct. 67,762 68,000 Planning Director 96,000 City Clerk 80,100 Bldg. Official 831780 86,300 Admin. Asst. 54,517 59,259 oLans" ON , City of Shorewood Council Meeting Item Title /Subject: Resolution Setting 2018 Open Book Meeting Date Meeting Date: Monday, December 11, 2017 Prepared by: Sandie Thone, City Clerk Reviewed by: Brenda Pricco, Administrative Assistant Attachments: Resolution 2D MEETING TYPE Regular Policy Consideration: Pursuant to Minnesota Statute 274.01, Subdivision 1, the County Assessor must set the date and time for the Local Board of Appeal and Equalization (LBAE) Meeting. Background: The City of Shorewood has opted for an Open Book meeting in place of a Local Board of Appeal and Equalization (LBAE) meeting. Hennepin County on behalf of the County Assessor has proposed the date and time for this meeting of Monday, April 30, 2018 from 5:00 p.m. to 7:00 p.m. in the evening. We are required to set the date and confirm with the county on or before January 26, 2018 so that they may prepare the Notice of Valuation and Classification to the property owners in the city, which will include the date and time for this meeting, in a timely manner. Action Requested: Staff respectfully recommends the city council approve the attached Resolution Setting the Date and Time for the 2018 Open Book Meeting of Monday, April 30, 2018 from 5:00 p.m. to 7:00 p.m. in the evening. Motion, second and simple majority vote required. Connection to Vision /Mission: Consistency in providing residents quality public services, a healthy environment, a variety of attractive amenities, a sustainable tax base, and sound financial management through effective, efficient, and visionary leadership. Mission Statement: The City of Shorewood is committed to providing residents quality public services, a healthy environment, a variety of attractive amenities, a sustainable tax base, and sound financial management through effective, efficient, and visionary leadership. Page 1 RESOLUTION 17 -XX A RESOLUTION SETTING THE 2018 OPEN BOOK MEETING WHEREAS, pursuant to Minnesota Statute 274.01, Subdivision 1, the County Assessor must set the date and time for the Local Board of Appeal and Equalization (LBAE) Meeting; and WHEREAS, the City of Shorewood has opted for an Open Book meeting in place of a Local Board of Appeal and Equalization (LBAE) meeting; and WHEREAS, Hennepin County on behalf of the County Assessor has proposed the date and time for this meeting of Monday, April 30, 2018 from 5:00 p.m. to 7:00 p.m. in the evening; and WHEREAS, the city is required to set the date and confirm with the county on or before January 26, 2018 so that they may prepare the Notice of Valuation and Classification to the property owners in the city, which will include the date and time for this meeting, in a timely manner. NOW THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF SHOREWOOD, MINNESOTA AS FOLLOWS: The 2018 Open Book Meeting will be held on Monday, April 30, 2018 from 5:00 p.m. to 7:00 p.m. in the City Hall Chambers located at 5755 Country Club Road in Shorewood, Minnesota. Passed by the City Council of Shorewood, Minnesota this 1 lth day of December 2017. Scott Zerby, Mayor Attest: Sandie Thone, City Clerk I M M City of Shorewood Council Meeting Item Title / Subject: Resolution Accepting Donations to Arctic Fever Event 2 E :::] Meeting Date: Monday, December 11, 2017 MEETING TYPE Prepared by: Sandie Thone, City Clerk Regular Meeting Reviewed by: Twila Grout, Park and Recreation Coordinator Attachments: Resolution Policy Consideration: Pursuant to Minnesota State Statutes sections §465.03 and §471.17 all donations or gifts of real and personal property, including donations for the benefit of public recreational services, must be accepted by the city council. Background: The following persons or entities have offered to contribute the cash amounts set forth below, for the purpose of the 2018 Arctic Fever Event being held on January 12 to January 14, 2018: Name of Donor Wakefield Investments, LLC Kelly Bosworth D.D.S., Inc. Amount $50.00 $75.00 Financial Considerations: This donation will help to cover expenses incurred for the 2018 Arctic Fever Event. Action Requested: Staff respectfully recommends the city council approve the Resolution Accepting Donations as Delineated in the Resolution to the 2018 Arctic Fever Event and direct staff to send a thank you note to all donors. Motion, second and two - thirds majority vote required. Connection to Vision /Mission: Consistency in providing residents quality public services, a healthy environment, a variety of attractive amenities, a sustainable tax base, and sound financial management through effective, efficient, and visionary leadership. Mission Statement: The City of Shorewood is committed to providing residents quality public services, a healthy environment, a variety of attractive amenities, a sustainable tax base, and sound financial management through effective, efficient, and visionary leadership. Page 1 RESOLUTION 17 -XX A RESOLUTION ACCEPTING DONATIONS TO THE CITY OF SHOREWOOD 2018 ARCTIC FEVER EVENT WHEREAS, the City of Shorewood is generally authorized to accept donations of real and personal property pursuant to Minnesota Statutes Section 465.03 for the benefit of its citizens, and is specifically authorized to accept gifts and is authorized to accept gifts for the benefit of their public recreational services pursuant to Minnesota Statutes section 471.17. WHEREAS, the following persons and entities have offered to contribute the cash amounts set forth below to the city: Name of Donor Amount Wakefield Investment, LLC $50.00 Kelly Bosworth D.D.S., Inc. $75.00 WHEREAS, the terms or conditions of the donations are to be used for the 2018 Arctic Fever Event; and WHEREAS, all such donations have been contributed to the city for the benefit of its citizens, as allowed by law; and WHEREAS, the City Council finds that it is appropriate to accept the donations offered. NOW THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF SHOREWOOD, MINNESOTA AS FOLLOWS: 1. The donations described above are accepted and shall be used to establish and /or operate services either alone or in cooperation with others, as allowed by law. 2. The city clerk is hereby directed to issue receipts to each donor acknowledging the city's receipt of the donor's donation. Passed by the City Council of Shorewood, Minnesota this 1 lth day of December 2017. Scott Zerby, Mayor Attest: Sandie Thone, City Clerk ® 2F MEETING TYPE City of Shorewood nl Meeting Item Regular Meeting Title / Subject: Authorization of Expenditure - Dehumidification System SE Area Well Meeting Date: December 11, 2017 Prepared by: Larry Brown, Director of Public Works Attachments: 2017 CIP Excerpt Policy Consideration: None Background / Previous Action: The 2017 Capital Improvement Program has funds dedicated to the addition of a commercial dehumidifying system for the SE Area Well, as shown in Attachment 1. These systems are commercial sized units that are standalone cabinets for controlling humidity in larger spaces. One of the challenges in maintaining well houses is the moisture that is formed on all of the interior piping during the non - winter months. The water that is pumped from the ground is approximately 55 degrees, year round. Condensation in the tanks and pipes collects, deteriorates the paint and is cause for corrosion of pipes and equipment. Often, the condensation is enough to constantly be running across the floors of the facility. This high moisture content harms pipes and equipment, and the structure and perpetuates considerable corrosion. When the Badger Well was reconstructed, a "HI -E -Dry dehumidifier" was specified for the new structure. Staff has been very impressed as to the performance of this unit. Staff has obtained a quote for a unit sized for the SE Area Well space, at a cost of $3,150, including spare filters. This amount is well under the budgeted amount shown in the CIP. Financial Consideration: Adequate funds exist for this expenditure from the Municipal Water Fund. Recommendation: Staff is recommending approval of the motion that authorizes the expenditure of funds in the amount of $3,150 for a dehumidification system for the SE Area Well. Mission Statement: The City of Shorewood is committed to providing residents quality public services, a healthy environment, a variety of attractive amenities, a sustainable tax base, and sound financial management through effective, efficient, and visionary leadership. Page 1 soum Projecta Privrity 2017 1-418 290 2014) 2021 Total pick- U-n AN I ISO RA4n I azm Jinit RID SO 1 2 1 , 70 0 _"7 5LI�j flLukAm IIKRt� Nuildilly vv- �m? Tf dd 5[-UfAJ PAVOLe' a 1900 ACA-A—w--ter Jeters: VV- 7412 Lift SUS-u-mi 2C R�-ab 26;&�C' Rix4d 0.00, J v A S i a lisui 1 7 RU 14- - f-TO '.OT'qj,,j Lh� 0 v Rifu d 5, 01 00 I 1200DLB' S T U_ 15 -4 211 GO 45 a" Baader Oewmidifiu 06!0 n 15 000 5 00 fifil - Walev Funid Tmilal 192450 61,Dm 44J%0 61000 20,11010 13 a -9150 611 SunxtarvSewerFund Dum .4 npTrui* repi3r—e�in-t7' 47V 1 gel .1"51) A5500 k6 45A A 3 W 12 R 1 C, Re I - wil - 4' T 73 Ld K"i%sr T K. i �aix Tf dd 5[-UfAJ PAVOLe' a 90 'JOG 2H ON 0 90- Lift SUS-u-mi 2C R�-ab 26;&�C' Rix4d J 1 A S i a lisui 1 7 RU 14- - f-TO '.OT'qj,,j Lh� 0 v Rifu d G 73 _2 I 1200DLB' S T U_ 15 -4 211 W000 St 1 � RGhab - 49%'_' Sharzl� 06!0 10 U00 GI-Am R4,t.-d -teaw_ 3 TM fl- kfFIRI abulal d _111ww Ra wLbu, ?0 CIG 70.E CKI -9 a CI -"-IC TG DO 35;[v 00 611 - Sanimr�. SoAer Fum! to 4 a7 oe_f N0,460 1 HMO MAD 70,000 A11,0010 m-s 6JI Starmwater MainaL-emeint Fund Il' piLanp riap lac-- wi 11 -0 0 6&1 A5500 tal 5" Tf dd 5[-UfAJ PAVOLe' 2H ON .Ar&-g pGad .1 78 m 7a 0M N&JIliwU Lire S T U_ 15 -4 211 4 06!0 GI-Am R4,t.-d -teaw_ 3 TM fl- 2-1-1 Oce- Y1 -_�ivznm 1_ 'E s 0 4 a7 oe_f U om N I l- T. _ .o f 4 �9 110N AD'In L-m _S T-11 f & 0 4 1 06,911KI IV5 OL S, A 2 4 14 AM 74 f-AkI =-ackn Roud N s;, f- 4�-o 1 4 4E2 ',1 46 a a_9 S 0 0 0 4 ,631 - Stor=m water Manzagement Fund 196'1 IIA�_NO • 4SZ13-013 193,500 am, 0110 iaxu.wo TDIRI GM AND TOTAL 3,464,009 4,442M0 2,405,600 1,002,600 257$6;,400 15 ors 1po ATTACHMENT 1 #2G MEETING TYPE City of Shorewood Council Meeting Item Regular Meeting Title / Subject: Resolution Adopting Standard Specifications and Standard Detail Plates for Street and Utility Construction, dated 2018 Meeting Date: 12/11/2017 Prepared by: Alyson Fauske, City Engineer Reviewed by: Larry Brown, Director of Public Works Attachments: Resolution Adopting Standard Specifications and Standard Detail Plates for Street and Utility Construction Background: Periodic updates to the Standard Specifications and Standard Detail Plates for Street and Utility Construction, for the City of Shorewood, are necessary to comply with revisions made to the Standard Specifications for Construction by the Minnesota Department of Transportation (MnDOT). The City's current edition of the Standard Specifications and Standard Detail Plates for Street and Utility Construction is dated 2016. Since this time, MnDOT has published a revision to their Standard Specifications for Construction (2018). Given the number of updates completed since the last revision to the City's Standard Specifications and Standard Detail Plates for Street and Utility Construction, it is necessary to update the specifications and detail plates to meet current standards. Options: 1. Approve the resolution Adopting Standard Specifications and Standard Detail Plates for Street and Utility Construction contingent on final review by the Director of Public Works and the City Attorney 2. Take no action on this item at this time. A Resolution has been provided with this agenda item for Council consideration of adopting the 2018 Standard Specifications and Standard Detail Plates for Street and Utility Construction. Recommendation / Action Requested: Staff recommends Council approve the attached resolution Adopting Standard Specifications and Standard Detail Plates for Street and Utility Construction for the City of Shorewood contingent on final review by the Director of Public Works and the City Attorney. Mission Statement: The City of Shorewood is committed to providing residents quality public services, a healthy environment, a variety of attractive amenities, a sustainable tax base, and sound financial management through effective, efficient, and visionary leadership. Page 1 CITY OF SHOREWOOD RESOLUTION NO. 17 - A RESOLUTION ADOPTING THE CITY STANDARD SPECIFICATIONS AND DETAIL PLATES FOR STREET AND UTILITY CONSTRUCTION, DATED 2018 WHEREAS, recent updates to the Minnesota Department of Transportation (MnDOT) standard specifications necessitate update of the City of Shorewood Standard Specifications and Detail Plates for Street and Utility Construction; and WHEREAS, the City Engineer has updated the City of Shorewood Standard Specifications and Detail Plates for Street and Utility Construction in accordance with the MnDOT, City Engineers Association of Minnesota (CEAM) standard specifications, and Supplementary General Conditions to the Engineers Joint Contract Documents Committee (EJCDC) documents. NOW, THEREFORE, BE IT RESOLVED, by the City Council of the City of Shorewood as follows: 1. That the Mayor and City Clerk are hereby authorized and directed to adopt the resolution accepting Standard Specifications and Detail Plates for Street and Utility Construction, dated 2018, for the City of Shorewood. ADOPTED BY THE CITY COUNCIL OF THE CITY OF SHOREWOOD this 1 l'' day of December, 2017. ATTEST: Sandie Thone, City Clerk Scott Zerby, Mayor CITY OF SHOREWOOD CITY COUNCIL SPECIAL MEETING MONDAY, DECEMBER 4, 2017 MINUTES 1. CONVENE CITY COUNCIL SPECIAL MEETING Mayor Zerby called the meeting to order at 7:01 P.M. Present. Absent: Mayor Zerby; Councilmembers Johnson, Interim Finance Director Rigdon Councilmember Sundberg Review Agenda Johnson moved, Siakel seconded, TRUTH -IN- TAXATION Staff Presentation Interim Finance Director The Truth -in- Taxation i 2018 property tax levy, asked to adopt a propert The City' They are parks and The assumpti 2H 5755 COUNTRY CLUB ROAD COUNCIL CHAMBERS 7:00 P.M. Lerud; and Motion passed 4/0. s 2018 General Fund Operating Budget and id to take public comment. Council will be its December 11 meeting. pay for a number of services funded out of the General Fund. -eas -- administration (including finance, planning and zoning, s );public safety (police and fire protection); public works;; and, the 2018 General Fund Operating Budget are as follows. A 4.0 percent tax levy increase over 2017 for General Fund operations. The original proposal was 2.9 percent increase. One new full -tithe Public Works position which would be allocated 90 percent to Public Works and 10 percent to Ice & Snow Removal. Other staffing levels remain the same from 2017. An approximate 10 percent increase in the City's contribution toward employee health insurance. A 2.5 — 3.0 percent increase in wages. The use of $117,106 in General Fund balance reserves to balance the Budget; down $75,779 from 2017. The City's General Fund 2018 combined revenues and transfers total $6,078,526 reflecting an increase of $229,999 (or 3.9 percent) when compared to 2017. Property tax revenues are $5,388,236 reflecting an CITY OF SHOREWOOD SPECIAL MEETING MINUTES December 4, 2017 Page 2 of 6 increase of $207,240 (or 4.0 percent) when compared to 2017. The breakout of the revenues and transfers is 89 percent from property taxes, 4 percent from licenses and permits, 4 percent from miscellaneous revenues, 1 percent from intergovernmental, 1 percent from fines and forfeitures, and 1 percent from charges for services. The City's General Fund 2018 combined budgeted expenditures and transfers out total $6,195,632 reflecting a $154,320 (or 2.6 percent increase) when compared to 2017. Total operating expenditures reflect a $133,338 (or 2.7 percent) increase. Total transfers out (Southshore Center, City Hall debt service and capital) reflect a $20,982 (or 1.9 percent) increase. Transfers to the Street Improvement Fund and the Equipment Replacement Fund were each increased by $15,000. The transfer to pay the City Hall debt service reflects a decrease of $9,018 due to the 2017 bond refunding. The breakout of those expenditures and transfers out by program is 36 percent is for public safety services (police and fire), 35 percent for streets, 23 percent for general government services, and 6 percent for parks, and recreation. The breakout of those expenditures and transfers out by type is 42 percent for other services,and charges, 25 percent for personal services, 19 percent for transfers out, 9 percent for capital outlay, and'5 percent for supplies. The property tax assessment and levy timeline for property taxes payable in 2018 was as follows. The market values were established on January 2, 2017. Valuation notices were sent out inMarcl 2017. The Board of Review process to hear appeals on property "values took place during April and May 2017. Council discussed the 2018 General Fund Budget and property tax'levy from July through September 2017. The City certified its maximum tax levy increase of 4 percent for 2018 to Hennepin County in September 2017. The County mailed out Truth -in- Taxation notices, to property owners in November 2017. The Truth -in- Taxation hearing was being held that evening. The City will certify its final tax levy to the County by the end of 2017. He clarified that this presentation is about the City approximately 27 percent. He highlighted some trenc increased 6.1 percent when compared to 2017. The determined by applying a, class rate to the market vale in calculating tax rates and tax dollars to the property percent levy increase over the 2017 levy. The levy rai years. The City local tax capacity rate has been goii market value was �4oina ut) at a hi�y-hcr rate than the ta: if Shorewood's portion of total tax bill which is graphs. The taxable market value payable in 2018 ax capacity is a derivation of market value; it is t of a property. The tax capacity is ultimately used 4ners. The property tax levy graph reflected the 4 ;ed from 1.5 percent to 3 percent over the past few down for at least the last four years because the levy was going up. It is not that way in all cities. The 2418 total City local property tax percent change compared to the 2017 total tax for properties in the City` based on statistics from the Hennepin County Assessor's Office is as follows. Approximately 23.5 percent of the parcels (573) will see a decrease. Approximately 40.6 percent of the parcels (989) will see an increase of $4 T $300. Approximately 18.4 percent of the parcels (449) will see an increase of $301 — $600. Approximately 7; 8 percent of the parcels (19 1) will see an increase of $601 — $900. Approximately 9.7 percent of the parcels; (237 ),will see an increase of more than $900. That full property tax bill includes city, county, school district and other taxing jurisdictions. The City local tax capacity rate for taxes payable in 2017 was 29.45 percent. The 2018 local tax capacity rate went down to 28.745 percent. If there was no change in the market value from 2017 to 2018 there would have be a 2.4 percent decrease in the property tax paid. If the market value increased by 5 percent for 2018 the property taxes would increase from 2.8 to 3.5 percent. There are three tax relief programs available through Hennepin County and the State. There is a homestead credit refund (circuit breaker) which is based on household income and property taxes paid. There is a targeting property tax refund available if taxes increase more than 12 percent and the increase is over $100. There is a senior citizens CITY OF SHOREWOOD SPECIAL MEETING MINUTES December 4, 2017 Page 3 of 6 property tax deferral program; the specifics of that program can be found the Minnesota Department of Revenue website. Fund balance is another term for net worth, retained earnings, or net position. Fund balance is a term used in governmental accounting. Each city fund has an equity position and sometimes those can be considered as reserves depending where they are at. Shorewood has a General Fund Balance Policy. The Policy's goal is to maintain a reserve level of 55 — 60 percent of the next year's budgeted operating expenditures and transfers out. A General Fund Balance chart for 2013 — 2016 actual showed the year -end balance for each of those four years was above 70 percent. The 2017 year -end balance is estimated to be 59.9 percent. The chart shows a deficit in 2017 of $892,785. That reflects the planned use of $192,785 in reserves to balance the 2017 budget and $700,000 in transfers out to capital approved by Council early in 2017. Based on the current year -to -date budget, numbers he assumed the balance would not be lower than 60 percent at 2017 year -end. Rigdon noted Council will be asked adopt the 2018 General Fund December 11 meeting. Council will also be asked to approve the 20 Capital Improvement Program during that same meeting. Councilmember Siakel stated she thought the additional his presentation when compared to other years was very 1 B. Public Comment Mayor Zerby opened the public comment George Greenfield, 24715 Yellowstone Trail, stated if the assessed value of all of the homes in Shorewood went up 5 percent. Interim Finance Director Rigdon clarified it deper explained the City budgets for what it needs; the levy is, Zerby clarified it budgets for the dollars it needs. Mr. G assessed value increased 5 percent he asked if Shorewood previous year. Rigdon driven by the assessed Councilmember Siakel c valuation. She stated she rate than the tax levy for City needs. Mayor Zerby stated p the taxes they pay. He the at 7:18 P ty tax levy during its Budgets and the 2018 Finance Director Riadon'nrovided in ty's tax levy remained the same and the cumulative cent he asked if Shorewood's revenue would go up 5 on what Council wants to levy. Administrator Lerud based just on the total taxable market value. Mayor nfield stated if the levy remained the same and the auld collect 5 percent more in taxes than it did in the ty budgets for the dollars it needs; the budget is not is not the same for all properties; it is based on a property's rector Rigdon say that the market value has gone up at a faster She then stated she thought Council has taxed for only what the role is to try and ensure residents are receiving a good value from the City for 1 has been reasonable with its spending. Councilmember Siakel stated when Council made a decision during its September 11 meeting to set the maximum levy at 4 percent that was done because there were a number of unknowns about projected funding needs. The levy could always be decreased once the funding needs were better known. The levy increase to 4 percent would amount to an additional approximate $50,000 in the tax revenue. Interim Finance Director Rigdon explained the 4 percent levy would bring in about an extra $56,000 over the 2.9 percent levy originally proposed by staff. For every 1 percent increase in the tax levy amounts to about an additional $50,000 in tax revenue. Administrator Lerud explained that when the preliminary levy was set in September the cost to make needed cosmetic improvements to the SSC were not known. The recent quotes he received to do that work came in at just under $100,000. The Building Official thought the City could do that work for considerably less if it served as its CITY OF SHOREWOOD SPECIAL MEETING MINUTES December 4, 2017 Page 4 of 6 own construction manager. There is some of the cosmetic work already budgeted for in the Capital Improvement Program (CIP) over the next five years. He thought if the maximum tax levy was lowered by almost $19,000 (to about 3.5 percent) he thought the City would have sufficient funds to do those improvements. If Council supports doing that then staff will update the Budget and CIP accordingly and have the revised documents ready for Council to take action on during its December 11 meeting. Councilmember Johnson asked who would serve as the construction manager for the City. Administrator Lerud stated Building Official Pazandak would. Johnson asked what would have to be taken off of Pazandak's work load. Lerud stated there may be some additional expense for building inspections. Mayor Zerby noted that Pazandak had served in that capacity when the shelter in Manor Park was built. Mr. Greenfield stated he had a couple of questions /concerns about taxation in general in Shorewood. His questions /concerns were as follows. 1. Inflation in the United States went up 1.8 percent in the last fiscal, year. The proposed 2018 tax levy for Shorewood is 4.0 percent. The quarterly assessment for the storm water utility rate went up 20 percent. He asked why the expenses for Shorewood are so much greater than the rest of the country.,,, He found it disconcerting that the preliminary tax" levy o 4 percent wa'spassed during a meeting when only three members of Council were in attendance. It did not provide the two absent members of Council with an opportunity to perhaps offer dissenting opinions. He also found it disconcerting that Council decided to do that at a time when it did not have all of the relative information. r He did not think there is any fixed principal of ta neighborhood where there is no storm sewer, and rate as someone who does have that. On the other that if property owners living along an unpaved: have to pay the initial cost of having that street pa which he believes it should be, or every person principal. 4. He wished some member, of Counc Over the last two years the City h,- and put money into the coffers of, the added burden. Mr. Greenfield thanked Council for its time. in in Shorewood -On one hand if a person lives in a pecial grading they pay the same storm water utility d it was Lade clear during a recent Council meeting street wanted it paved the property owners would He asked if the principal is all for one or one for all, themselves. He thought there should be a uniform or even all of them could justify why the tax levy increase is possible. taken two large properties essentially off the City's property tax rolls ivate corporations while asking the citizens of Shorewood to assume Mayor Zerby stated he thought the one for all and all for one is something Council considers often. It is typically considered for small projects that benefit only a small number of property owners. He then stated the preliminary /maximum 4 percent tax levy is what was earmarked by Hennepin County for the City should the City need it. Based on the discussion during the meeting it appears the 2018 tax levy will be closer to 3.5 percent than 4 percent. The initial proposal was for 2.9 percent. There had been improvement projects (e.g.; the SSC) that will cost more than anticipated. Administrator Lerud explained the 2018 budget process started in June 2017. At that time there was only six months' worth of data available so staff had to estimate more. He noted all members of Council were in attendance during an August work session when the preliminary budget and tax levy were discussed. All of them had a say in the budget and the levy. Since the preliminary 4 percent tax levy was certified in September staff has gathered a lot more information needed to refine the 2018 budget and tax levy. CITY OF SHOREWOOD SPECIAL MEETING MINUTES December 4, 2017 Page 5 of 6 Lerud then explained Shorewood will receive some portion, approximately 16 percent of the property taxes the City of Excelsior collects from The Waters of Excelsior project over the life of the tax increment financing (TIF) District. The taxes would be based on the property value before the site was redeveloped. At the end of the TIF District Shorewood will receive 70 percent of the taxes generated by the Waters Project. He then explained that for the Oppidan Shorewood Landing Senior Living project Shorewood will receive the taxes paid to the City based on the property value before the site was redeveloped until that TIF District is decertified; after that the City will collect taxes on the full taxable value. There may be some additional public service costs (e.g.; for example for public safety) going forward. He noted that he did not think the impact of having those two TID Districts would be a significant burden to Shorewood. Mr. Greenfield stated if Shorewood's tax levy went up 4 percent each year in 20 years it would have gone up 80 percent. Administrator Lerud clarified that what the City captures from the TIP District is taxes on the original assessed value. The City can still collect on increases in its levies based on that original value of the property. Councilmember Siakel stated it is doubtful that anything else would have been done to the. Oppidan site; she did not know what else could have been done. The City is still going to collect the tax. At the end of the life of the TIF District the property will be taxed at that new assessed value. Council had repeatedly heard from residents about the need for advanced care for seniors. Mr. Greenfield noted there have been extremely expensive houses built on some``large parcels of land along Chaska Road. If those same types of houses had been built on the Oppidan site then they would have been taxed based on the then current value of the property over the 20 years. Mr. Greenfield thanked Council for its answers Mayor Zerby stated Council appreciates hearing Mr. Greenfield's °views and he thanked him for coming. Mayor Zerby closed the public comment portion of the hearing at 7:35 P.M. C. Council Deliberation - Discussion of the 2018 Enterprise Fund Budgets and the 2018 Capital Mayor Zerby again noted that Council will not take action on the 2018 General Fund Budget and tax levy this evening. The purpose of this hearing was to gather information and to give staff direction for the December 11 meeting: 1e thanked staff for the good job they did on preparing the documents. Councilmember Labadie stated she found the documents to be very helpful and easy to understand. They were an improvement over the last few years. She thanked staff for their efforts. Mayor Zerby stated going forward it he thought it would be helpful to see an inflationary line on the trend graphs. Administrator Lerud asked if Council had any comments about the 2018 Enterprise Fund Budgets or the 2018 CIP. Lerud stated the biggest takeaway on the Enterprise Budgets is what appeared to be a significant increase in the water revenue but that is only because the numbers in the past were not realistic. He then stated there will be a 3 percent increase proposed for the water and utility rates and a 10 percent increase proposed for the storm sewer utility rate. Council will be asked to consider those increases in February 2018. Councilmember Siakel stated she would like staff to find out how Shorewood's' storm water utility rate compares to those in other communities. She questioned if the City's rate is high enough. CITY OF SHOREWOOD SPECIAL MEETING MINUTES December 4,2017 Page 6 of 6 3. ADJOURN Siakel moved, Labadie seconded, Adjourning the City Council Special Meeting of December 4, 2017, at 7:37 P.M. Motion passed 4/0. RESPECTFULLY SUBMITTED, Christine Freeman, Recorder Scott Zerby, Mayor ATTEST: Sandie Thone, City Clerk November, 2017 GregLe0d 5755 Country Club Road Shorewood, K4N55331 Dear Mr. Lerud, Enclosed is@ summary Of work done bv the Metropolitan Mosquito Control District /yWMC[DiDthe city of Shorewood during the 2017 mosquito control season. Precipitation in 2017 was re|@UVe|V |OVV in K48[Ch. Anh[ June and July. Precipitation was higher in May and especially August with more precipitation in the southern parts of the District. This resulted in high DlOSqUitU |eVe|G in June and late August. High nDloUDtS of cattail mosquito production in sites that remain flooded by heavy precipitation in 2014 through 2016 [8SU|ted in high mosquito levels iD early July. Overall, VV8 treated about 2O0.O0U acres iO2O17 which iSsignificantly less than 2O10 and closer tO values iO years with more typical precipitation patterns /2U11and |n2O17 the Minnesota Department UfHealth reported 23 human West Nile virus illnesses; five Of those cases were reported iO people who live within our District. NO cases OfL3Crosse encephalitis were confirmed in Minnesota as of November first. Mosquito-borne disease pr8V8OtiOO work continues as |0Dg as staff are in the field with the recycling of tires and 8|i[UiD@tiOn of other VVBt8Fh0|diOg containers. &1MCD employees also CODtKoU8d i[DDl8tUne black flies in SOOoU steams and large rivers throughout the metropolitan 8[88. These treatments have neeU|bad in significantly fewer adult black flies when compared tOa time before vve conducted treatments. W1MC[}staff also continued to monitor the distribution of ticks capable of transmitting disease, and worked with the Minnesota Department Of Health to provide information designed to reduce the risk of tick transmitted diseases. If you have any questions, or would like to meet to discuss our agency's activities within Shorewood, please contact me. Since Ste P D A. K8mDVV8i|8[' K4K4CD Executive Director Phone: (651) 843-8365 Email: mmcd_sam@mmcd.org Metropolitan Mosquito 2017 Activity Summary — Shorewood Freeman Park #5D MEETING TYPE City of Shorewood Council Meeting Item REGULAR Title / Subject: 2017 Year -end Deer Management Program Report Meeting Date: December 11, 2017 Prepared by: Greg Lerud, City Administrator Attachments: Report from Metro Bowhunters Resource Base Background: Following this memo is a report from Gary Anderson from Metro Bowhunters Resource Base for 2017. There were five and a half weekend in this year's program, and over 25 property owners requested their parcels be included in this year's program. The city will continue to examine the annual program to ensure that it meets the city's needs as well as balance the need to manage the deer population in Shorewood and protecting private property, with those property owners who do not wish to participate in the program or who do not want any hunting done. Abbreviations for the attached report: AB = Adult Buck, AD = Adult Doe, BF = Buck Fawn, DF = Doe Fawn Financial or Budget Considerations: This program does not cost the city or participating property owners any money. Recommendation / Action Requested: This memo is informational only and no action is needed on the part of the City Council. Next Steps and Timeline: If the council has questions about the program that I am not able to answer, I would be happy to get answers from the program coordinator. On a related note, Three River's Park District contacted staff to see if there was interest in including the city in the Park District's 2018 aerial deer survey (should it happen.) There has been not aerial deer count the past two years due to lack of snow. Mission Statement: The City of Shorewood is committed to providing residents quality public services, a healthy environment, a variety of attractive amenities, a sustainable tax base, and sound financial management through effective, efficient, and visionary leadership. Page 1 2017 SHOREWOOD DEER REMOVAL BY METRO BOWHUNTERS RESOURCE BASE A total of 32 deer were taken by 17 hunters over the course of 12.5 days (5 weekends, % day on Friday). This year three hunters were put on probation as per MBRB's shot proficiency policy. Two hunters were removed from the hunt because of MBRB rule violations. One hunter was removed at the request of the city. Again this year as in the past, we were approached by residents not included in the hunt asking us to remove deer from their property. They were directed to the city to be considered for future hunts. Below are 2 charts showing the breakdown of deer taken by hunt period and hunt area (refer to map provided by city). Hunt Period Shots Taken Deer Hit Deer Recovered 1 8 8 6 2 8 8 7 3 9 9 8 4 8 8 7 5 4 4 4 Total 37 37 32 Hunt Area 1 2 3 4 5 6 7 8 9 10 11 12 13 14 Deer 2AD AB 2AD 2AD AD Deer AD 0 0 0 0 0 0 0 0 3AD 0 0 taken 0 2DF 0 3AD 0 AD AB DF BF 0 taken 213F BF Total 0 4 0 0 0 0 0 3 0 0 3 3 0 2 Hunt Area 15 16 17 18 19 20 21 22 23 24 25 26 27 AB 2AD Deer AB 0 0 0 2AB 0 3AD 0 AD AB 2AB BF 0 taken DF BF DF Total 2 0 0 0 2 0 5 0 1 1 2 4 0 Recommendations: Continue searching for new areas with high deer concentration. Look for properties in the northeast corner around Manor Road. Look for additional properties on Enchanted Island. CITY OF S OREWOOD Goose Island Gale Island Mccet� �f rtlen.Ra '�aJl® Spray g Shady Islannd. m m mm Island e9 m , 1 Enchant. ?9�l" 0 0 R m•• lY .�, ea° . Shad ,a�Rd a PaasVO � a J .boa �0'a•. O` �0n E�sa evd 1 Spring Cir 2 St Albans 49,x, BayLClr Enchanted aL a q Island O 3 ro Duek Fro q 5 H�Ra m° es1P" g Island Iris^la\nd `/ IElgew°°tlRtl <tm (11�` O 1 a 3 15 � \II/vva)) OO `Ridge Valley aad w o a�O Myt{teld G'ir • . Oa Clr Gir O 'F. 9rrilee Rtl \ • 3a adla i„� P a O ater p^ T Noble Rtl _-Dr fgr lie,J O�O • Yv e Glen Rtl Ga C9 a 1i tetzna uewRd � OD � son � � ` Snore e'• w date:-. plsi Pine 1° Marsh Pt '4N°r Creek l P J I La 19 Rd Wootlsitle oatl Marsh pt t - q 5 Smithtown �O Ct Pdtne a o arc _ v hedw°/Y • - 10 a°aea E IKatryleen erynmawr_RI � �o w� � al cl � smimmwn Roaa r� a � �Mci In Rd � O 4 °aa Smithtown La eCo E��2 0 — O �1 ae,age m f to ^ Man La• URirl9e Pdint p Q E 1 L Cir o:Academy — v9 Park St e SrnithtOWa Roaa Rtl �Q°' ��ma � � i Q� 4 Rou er_Cir � � J od •. � q4 Oi Bra°kart s Rtl � T � �D . ` `` u••` ew 0 d Beverly Df m �G . w E � a� "Y 2 X95 Maple oodJ JOaks� Or ®m � � Yellowstone Tr RamParl Po me Rtl e 9 3� m/ Swee�hn�` 1 -<e `c� . . sd°raw ® ,=_ �t °., 5m, _ • ` mL t .,P,r �, MaPI — Ave ® n�^°od Dr m/ Murray-St GhPima s� •ur P- Cye RId9a o G &'{`¢QJJ� Oak1 fTr D �� m a� c .) �. Ord PI 1 °e a�. ttc �c: Ct 62ntl St O Park Lane omr 1 Lane olly_Lane dN Pom view Dr V 1 2017 Deer Management Plan 1 Private (4485 Enchanted Point) 15 City Property (Eureka Road Wetland) Selected Sites 2 Private (27920, 27930 & 27940 Smithtown Road) 16 Private (25165 Glen Road) 3 Private (27990 Smithtown Road) 17 City Property (East end of Wedgewood Drive) 4 Private (27410, 27420 & 27430 Pine Bend + 5705 Brentridge Dr) 18 Private (24800 Smithtown Road) 5 City Property (Marsh Pt Wetland) 19 City Property (Gideon Glen) 6 Private (27180 & 27200 West 62nd Street) 20 Private (5835 Minnetonka Drive) N 7 Private (26960 West 62nd Street) 21 Private (6200 Cardinal Drive) 8 Private (6035 Cathcart Drive) 22 Private ( 22275, 22315, & 22345 Bracketts Road) 9 Private (27015 Edgewood Road) 23 Private (6070 & 6080 Mill Street; plus City parcel) 10 Private (26860 Edgewood Road) 24 Private (21355 Christmas Lane) 0 1,000 2,000 4,000 11 Private (26745 Edgewood Road) 25 Private (6005 Christmas Lake Road) Feet 12 Private (25865 & 26075 Birch Bluff Road) 26 Private (5775 Ridge Road) Shorewood Planning Department 13 Private (25755 Maple View Court) 27 Private (20015 Vine Street) 09/17 14 City Property (Freeman Park) X Deer Processing - 24200 Smithtown Road (Shorewood Public Works) ® 8A MEETING TYPE City of Shorewood Council Meeting Item Regular Meeting Title / Subject: Accept Proposal for Professional Services Agreement, AE2S — Boulder Bridge Well Motor Control Center Meeting Date: December 12, 2017 Prepared by: Larry Brown, Director of Public Works Attachments: Excerpt CIP, Site Location Map, and Proposal by AE2S, Resolution Policy Consideration: None Background / Previous Action: The 2018 Capital Improvement Program has funds dedicated to replacement of what is known as the Motor Control Center (MCC) for the Boulder Bridge Well, located at 28125 Boulder Bridge Drive. Attachment 1 is an excerpt from the CIP, with Attachment 2 being a site location map. In an attempt at hitting the prime bidding season, staff determined it is best to commence with the design in 2017, with construction to take place in 2018. It is noted that the existing MCC is the original control center that was installed when the wells were initially constructed in 1981. The MCC and SCADA controls are pieces of infrastructure where the design, implementation, and documentation are very critical to the operation of the municipal water system. The MCC controls the distribution of power, startup and operation of the pumps and interfaces with the SCADA (i.e. electronic process control, monitoring, and communication) systems to monitor processes in the well houses. Staff has had to weather through some tough experiences with controls for the water system. When the west water tower was erected, the controls and MCC redesign for the Boulder Bridge MCC modifications were based on a low bid portion of the overall construction contract. The consequences of a poor programming and implementation of controls was cause for years of frustration for the operations. Since that time, staff has relied upon the services of a firm known as Instrument Control Systems (ICS). While this firm was able to resolve many of the headaches and has provided top notch service for many years, ICS has recently been purchased by another firm. Unfortunately, the responsiveness for troubleshooting issues from the new firm is not as it has been in the past. Staff has invited three firms to submit proposals for the design of the Boulder Bridge MCC project. One firm, known as AE2S far exceeds the requirements and comes to the table with high praise and recommendations. The Cities of Minnetonka and Chanhassen also utilize this Mission Statement: The City of Shorewood is committed to providing residents quality public services, a healthy environment, a variety of attractive amenities, a sustainable tax base, and sound financial management through effective, efficient, and visionary leadership. Page 1 firm for design and implementation of well and electronic controls. AE2S was the only firm that submitted a proposal. The first firm stated that their current workload exceeded their current capacity. The second firm stated that since the City of Shorewood had recently moved to "Mission SCADA Systems" for telemetry and communication, that they would not submit a proposal, as this was one of their competitors. The last firm, AE2S knows and works on the Mission systems, eagerly met with staff to discuss the Boulder Bridge project to determine what was expected, and submitted their design proposal on time. As noted above, the MCC is the main power distribution system for the wells and is key to keeping the infrastructure in operating condition. AE2S submitted their proposal which has been included to this report as Attachment 3. As requested, the proposal includes the following phases: • Design $ 22,240 • Bidding $ 2,200 • Construction $ 8,900 • Startup and Programming 9,840 Total $ 43,180 The Water Fund Capital Improvement Program has a budgeted amount of $200,000 for the design, bidding, construction and startup. Staff has reviewed the proposal submitted and finds this to be in order. Financial Consideration As mentioned above, this project is funded from the Municipal Water Fund. The amount budgeted for the entire project has programmed in the adequate resources for this project. Recommendation Staff is recommending approval of the motion that accepts the proposal provided from AE2S for an amount of $43,180. Source # Priority 2018 2014 2020 2021 202' 2023 2024 2025 2026 202? Iota] Birch Bluff Road LP.2am r9a 311.737 Excelsior BMA ux.xirz rVa 436,521 Seamans drive tR.aam rVa 184.556 West Lane LAMM rVa 73,187 Christmas Lane E LR.3j.o rVa 26,434 Christmas Lake Rand tR.3f.a7 rVa 295,963 Country Club Road tR.31.0 rVa 267,45D Shady Isurrd arde, Poini h Road L+23-G1 rVa 284,733 Shady Isurd Trail L'' 23.G2 rVa 32,191 dellwaod Lane u7.2c0 rVa 95,461 Enchanted Cave 0.3+ra rVa 35,104 Enchanted Drive ux.acos rVa 185,468 Endwnted Lane LRa4o4 rVa 352,870 Sveei Sign Replaoement L999M rVa TOM 8,140 9,400 11.700 9,DOD 9,304 9.60 Mainienanre- Biturrinous5ealooadng ureafaa rVa 275.000 280.040 285.00D 29DpOD 295,DOD 300,070 3D5,0D0 404 - S tWLLer Reconstruction Fund Iotal 1,7K735 28E,100 V14,53d 1,30d,K1 2,302,762 1r9d,913 314,500 406 - rujib Gain Lake Rd Sidewalk .90 rVa 1,33D.00D Stawberry Lane & W 62nd . x.' rVa 8520OD 406 -Trails Total 2,182,006 601- Water Fund Air Compressor- Replace unit 36 osa rVa 2D,DOD I]odge Caravan - repfam Limit-.7 OR rVa 28.000 Ford F150 Flduup OU rVa 27.500 Balder Bridge 1Wel 3uidiry W -rXof rVa WON Residing & Rxfing Well House Wa -ar Meters W.rXu rVa 6.000 12A40 HOD Boudde. 45pOD BaLddL- 3ndge lWel War Contrd W f V2 rVa 200.OD0 Center SE a GPS utility Lxate System W ff EL4 rVa S.ODO (Proportion) Bolder Bridge --eh midfier W Hal rVa 5.000 Amesbury Well Anti Corrosion and WNW rVa 30.000 Pipe Coatirys 311.:3; 436,521 (84,656 73,167 20.434 295,463 267.450 264.733 32,161 95,461 85,100 18,5440 3.52'6 a 60.900 2.030.060 8,d8d,d15 1.330.070 852'060 �1A 00 20,0017 2V�W7 27.570 60.060 24,000 45,000 260.0016 45r WO 5,0617 5,0617 30.000 Tavcak*. gtnembim 28. 201: ATTACHMENT 1 26070 27860 _ V V 5730 D• JD 28085 27540. 5735 5745 28090 5725 S7 S4 5755 ��_'Bt�fRrn &Wty�I r. ` 27865 2s1aa 28115 5755 5760 5765 5735 5775 5745 27825 f N N E P k �`� ,779]5 5785 5776 28125 a 5785 28170 't 28180 26 5790 5795 28096 26660 28070 28190 26104 2$460 5864 5di5 5845 26192 5870 5650 4 5810 � 5815 28154 5680 5645 26050 5635 Boa. 28210 28110.1 5865 5975 5830 26040 28105 5890 5675 5835 28065 � 36220 _ 5905 5955 5845 28120 28115 28045 5970 5905 5935 5855 ti,� - - SITE LOCATION 28125 5910 � 5900 ��`� "# ��•� ��� 596D 5935 27289 28124 28130 28025 28010 5920 5930 5940 5950 I 38135 9�1i6tt 28255 28140 i 28145 28005 28245 27430 2720 27354 27235 28153 28241 28155 5950 4Y_ 28200 2816D 26 28235 27425 27340 5020 26225 Bo��deT�Cir 27225 28215 26135 �$ 27995 279756 26 60.50 27324 27910 6G70 q 6105 27930 27944 F e1-. ov 27954 r Silo 27940 27630 r ¢ 6125 2775D 2772027690 _ - 27780 ff 127410 .q 27960 27460 I ." Ed X15 27600 27961 �������� -�w�, 27565 -1 27968 27125 276 ATTACHMENT 2 4001t 27970 27985 27665 Oki n www.ae2s,com December 5, 2017 Mr. Larry Brown Director of Public Works City of Shorewood 5755 Country Club Road Shorewood, MN 55331 RE: Engineering Services Proposal Boulder Bridge Well Facility Improvements City of Shorewood, Minnesota Dear Mr. Brown: Thank you for this opportunity to provide this professional services proposal for the Boulder Bridge Well Facility Improvements Project. The following letter provides a general overview of our project understanding and the proposed scope of services, anticipated timeline, and estimate of associated professional fees. Proiect Understandin The project generally consists of providing engineering services to the City of Shorewood (Owner) related to the electrical rehabilitation of the Boulder Bridge Well Facility including new electrical service gear, motor control center, pump VFDs with bypass, starters, electrical distribution and lighting replacement as required to support the upgrade. It is understood that electrically, we will generally be demolishing all existing wiring /conduit systems, lighting systems, and replacing them with new systems. Scoae of Services Design Phase ■ We will provide an initial visit to the site to discuss the project details with the Owner and to take notes /photos to assist us with completing the project. We will provide any necessary follow -up site visits to gather any missing information as required. ■ We will coordinate exact project details with the Owner during design to ensure that all required details are correctly incorporated into the project construction documents. ■ We will prepare plans and specifications that incorporate project demolition requirements, new construction requirements, scope coordination requirements, construction specifications and any additional scope and construction information required for completing the project. ■ We will prepare a construction cost estimate for the project. ■ We will provide electrical service coordination with the Utility as required. E -100 03/2016 Advanced Engineering and Environmental Services, Inc. 6901 East Fish Lake Road, Suite 184 • Water Tower Place Business Center • Maple Grove, MN 55369 • 763 - 463 -5036 Mr. Larry Brown Director of Public Works RE: Engineering Services Proposal Boulder Bridge Well Facility Improvements December 5, 2017 Page 2 of 5 fi! ■ We will prepare and issue a 90% set of plans to the Owner and will meet with the Owner to review and incorporate any comments or revisions that may be required prior to bidding. ■ We will prepare final plans, specifications and complete request for proposal (RFP) documents on behalf of the City for the project. We will sent out the final RFP documents to City - preferred electrical Contractors for quotes. Request for Proposals (Bidding Phase) ■ We will act as the Owner's representative in distributing RFP Documents to Contractors ■ We will attend and direct a Pre - Proposal Conference at the Site with potential Contractors prior to receiving proposals. ■ We will answer Contractor questions during bidding and will issue any necessary bid addendum items. ■ We will review the quotes once received and make a recommendation for award by the Owner. Construction Phase ■ We will assist the Owner during construction by administering the contract documents on behalf of the Owner; directing a preconstruction meeting; and answering Contractor questions that arise during construction. We will respond to Contractor RFIs and will issue work directives and Change Orders that may be required on behalf of the Owner. ■ We will provide routine construction observation site visits at the request of the Owner (up to two visits are included) and will visit the site for the development of a final punchlist at the completion of construction. If the Owner determines that additional site observations services are required from AE2S, the costs for such services would be in addition to those presented herein. ■ We will provide a punchlist follow -up site visit to confirm that all items have been completed to the satisfaction of the Engineer and the Owner. ■ We will provide review of Contractor - submitted operation and maintenance (O &M) manuals. ■ We will provide as- constructed record drawings for the project at project completion that incorporate Engineer, Contractor and Owner mark -ups from construction. Advanced Engineering and Environmental Services, Inc. 6901 East Fish Lake Road, Suite 184 • Water Tower Place Business Center • Maple Grove, MN 55369 . 763 -463 -5036 Mr. Larry Brown Director of Public Works RE: Engineering Services Proposal Boulder Bridge Well Facility Improvements December 5, 2017 Page 3 of 5 Professional Programming and Startup Services Programming PLC and OIT for local control and monitoring of the following equipment: • Two Well Pumps • Primary control from remote tower level received from Mission SCADA system, compared to start and stop setpoints • Vertical turbine pump speed control based on local system pressure. • Backup control from local pressure transmitter compared to start and stop setpoints • Building status: • Flood float switch • Low temperature • Entry door switches • Alarming (shown locally on OIT and hardwired to Mission SCADA system via output from PLC) • High Tower Level • Low Tower Level • Heartbeat • Intrusion • Low Temperature • Flood Alarm • Pump Failure Coordination of I/O with Mission SCADA, as outlined above, and confirmation of operations Onsite startup, operation demonstration, and two hours of operator training for system programming outlined above OWNER Responsibilities OWNER will be responsible for the following: 1. Designate a contact person to act as OWNER's representative with respect to the professional services to be rendered with complete authority to transmit instructions, receive information, and interpret and define the OWNER'S policies and decisions with respect to professional engineering services. 2. Provide access to water system infrastructure as necessary to complete the scope of the project. 3. Provide copies of existing Boulder Bridge Well design and construction documents (as are available) to AE2S for use during the project. 4. Bear all costs associated with required regulatory review and permitting. 5. Bear all costs associated with publishing the Advertisement for Construction Bids. (If required) Exclusions 1. Mechanical Engineering services (HVAC or plumbing) are not included in this proposal. 2. The design of separately monitored security and /or access control systems are not included in this proposal. 3. Any additional modifications that may be required by the Minnesota Department of Health, other than improvements specifically identified in this proposal, are not included. Advanced Engineering and Environmental Services, Inc. 6901 East Fish Lake Road, Suite 184 • Water Tower Place Business Center • Maple Grove, MN 55369 . 763 -463 -5036 Mr. Larry Brown Director of Public Works RE: Engineering Services Proposal Boulder Bridge Well Facility Improvements December 5, 2017 Page 4 of 5 Proposed Professional Fees AE2S proposes to provide the professional services consistent with the Scope of Work outlined above on an estimated hourly (plus expenses) basis in amount of Fourty Three Thousand One Hundred and Eighty Dollars ($43,180) including design, RFP solitation, construction, programming and start -up services. ■ $22,240 Design ■ $2,200 RFP (Bidding) ■ $8,900 Construction ■ $9,840 Professional Programming and start -up Services All professional services and expenses will be in accordance with the AE2S Hourly Fee and Expense Schedule (Attachment A). We will invoice the Owner monthly for services performed. Compensation shall not exceed $43,180 without written authorization from the OWNER. We propose to provide the above professional engineering services in accordance with the Standard Terms and Conditions, dated November 8, 2017. Anticipated Project Schedule AE2S proposes to complete of the proposed Scope of Services in accordance with the following proposed schedule: ■ Plans and Specifications Complete (Send RFQs) June 4, 2018 ■ Receive Construction Quotes July 10, 2018 ■ Substantial Completion Dec 21, 2018 ■ Final Completion Jan 11, 2019 Contract Documents This Agreement between the City of Shorewood (Client) and AE2S includes the following documents, incorporated herein by reference: 1. Exhibit A - Terms and Conditions; 2. Exhibit B - Hourly Fee and Expense Schedule; 3. All other attached Exhibits referenced in this Agreement; 4. Any drawings or specifications provided by the City of Shorewood (Client) in writing; and 5. Any duly executed written amendments. There are no contract documents other than this Agreement and those documents listed above. If this Agreement sets forth your understanding of our agreement, including the scope of work desired, fees, terms, and conditions, please sign in the space provided and return a copy to AE2S. Thank you for the opportunity to assist in this project and we look forward to working with you. Sincerely, Charles Haupert, PE Advanced Engineering and Environmental Services, Inc. 6901 East Fish Lake Road, Suite 184 • water Tower Place Business Center - Maple Grove, MN 55369 • 763 - 463 -5036 Mr. Larry Brown Director of Public Works RE: Engineering Services Proposal Boulder Bridge Well Facility Improvements December 5, 2017 Page 5 of 5 AE2S By: /V �'t:n1�'�% Damon Chmela, PE CLIENT Accepted this day of By: Name (Print): Title: 20 9% Advanced Engineering and Environmental Services, Inc. 6901 East Fish Lake Road, Suite 184 • Water Tower Place Business Center - Maple Grove, MN 55369 • 763 - 453 -5036 Standard Terms and Conditions The Agreement is supplemented to include the following terms and conditions: 1. Standard of Care a. The standard of care for all professional services performed or furnished by AE2S under this Agreement will be the care and skill ordinarily used by members of AE2S's profession practicing under similar circumstances at the same time and in the same locality. AE2S makes no warranties, express or implied, under this Agreement or otherwise, in connection with AE2S's services. 2. 3. 4. b. CLIENT shall be responsible for, and AE2S may rely upon, the accuracy and completeness of all requirements, programs, instructions, reports, data, and other information furnished by CLIENT to AE2S pursuant to this Agreement. AE2S may use such requirements, reports, data, and information in performing or furnishing services under this Agreement. Payments to AE2S Invoices will be prepared in accordance with AE2S's standard invoicing practices and will be submitted to CLIENT by AE2S monthly, unless otherwise agreed. Invoices are due and payable within 30 days. If CLIENT fails to make any payment due AE2S for services and expenses within 30 days, the amounts due AE2S will be increased at the rate of 1.75% per month (or the maximum rate of interest permitted bylaw, if less) from said thirtieth day. In addition, AE2S may, after giving seven days written notice to CLIENT, suspend services under this Agreement until AE2S has been paid in full all amounts due for services, expenses, and other related charges. All payments shall be made in United States Dollars. Insurance AE2S will maintain insurance coverage for Workers' Compensation, Professional Liability, General Liability, and Automobile Liability and will provide certificates of insurance to CLIENT upon request. Indemnification and Allocation of Risk a. To the fullest extent permitted by law, AE2S shall indemnify and hold harmless CLIENT and CLIENT's officers, directors, members, and employees from any and all costs, losses, and damages (including but not limited to all reasonable fees and charges of engineers, architects, attorneys, and other professionals, and all court, arbitration, or other dispute resolution costs) arising out of or relating to the Project, provided that any such cost, loss, or damage is attributable to bodily injury, sickness, disease, or death, or to injury to or destruction of tangible property (other than the Work itself), including the loss of use resulting therefrom, but only to the extent caused by any negligent act or omission of AE2S or AE2S's officers, directors, members, partners, employees, or Consultants. The parties expressly agree that AE2S or AE2S's officers, directors, members, partners, or employees have no duty to defend CLIENT and CLIENT's officers, directors, members, and employees against any claims, causes of action, demands, lawsuits, or proceedings of any kind. b. To the fullest extent permitted by law, CLIENT shall indemnify and hold harmless AE2S, AE2S's officers, directors, partners, employees, and consultants from and against costs, losses, and damages (including but not limited to reasonable fees and charges of engineers, architects, attorneys, and other professionals, and reasonable court or arbitration or other dispute resolution costs) to the extent caused by the negligent acts or omissions of CLIENT or CLIENT's officers, directors, partners, employees, and consultants with respect to this Agreement. c. In addition to the indemnity provided under paragraph 4.b. of this Exhibit, and to the fullest extent permitted by law, CLIENT shall indemnify and hold harmless AE2S and AE2S's officers, directors, partners, employees, and consultants from and against injuries, losses, damages and expenses (including but not limited to all reasonable fees and charges of engineers, architects, attorneys, and other professionals, and all court or arbitration or other disputes resolution costs) caused by, arising This is EXHIBIT A, consisting of 2 pages, referred to in and part of the Agreement between CLIENT and AE2S dated [11/8/17]. out of, or resulting from Hazardous Environmental Condition, provided that (i) any such injuries, losses, damages and expenses are attributable to bodily injury, sickness, disease, or death, or to injury to or destruction of tangible property, including the loss of use resulting therefrom, and (ii) nothing in this paragraph 4.c. shall obligate CLIENT to indemnify any individual or entity to the extent of that individual or entity's own negligence or willful misconduct. d. To the fullest extent permitted by law, AE2S's total liability to CLIENT and anyone claiming by, through, or under CLIENT for any injuries, losses, damages and expenses caused in part by the negligence of AE2S and in part by the negligence of CLIENT or any other negligent entity or individual, shall not exceed the percentage share that AE2S's negligence bears to the total negligence of CLIENT, AE2S, and all other negligent entities and individuals. 5. Exclusion of Special, Incidental, Indirect, and Consequential Damages To the fullest extent permitted by law, and notwithstanding any other provision in the Agreement, AE2S and AE2S's officers, directors, partners, employees, agents, and Consultants, or any of them, shall not be liable to CLIENT or anyone claiming by, through, or under CLIENT for any special, incidental, indirect, or consequential damages whatsoever arising out of, resulting from, or in any way related to the Assignment or this Agreement, from any cause or causes, including but not limited to any such damages caused by the negligence, professional errors or omissions, strict liability, breach of contract or warranties, express or implied, of AE2S or AE2S's officers, directors, partners, employees, agents, or AE2S's Consultants, or any of them. 6. Limit of Liability To the fullest extent permitted by law, notwithstanding any other provision of this Agreement, the total liability, in the aggregate, of AE2S and AE2S's officers, directors, partners, employees, agents, and AE2S's Consultants, and any of them, to CLIENT and anyone claiming by, through, or under CLIENT for any and all claims, losses, costs, or damages whatsoever arising out of, resulting from or in any way related to the Project or the Agreement from any cause or causes, including but not limited to the negligence, professional errors or omissions, strict liability or breach of contract, or warranty express or implied of AE2S or AE2S's officers, directors, partners, employees, agents, or AE2S's Consultants, or any of them, shall not exceed total compensation received by AE2S as part of this agreement. 7. Termination of Contract Either party may at any time, upon seven days prior written notice to the other party, terminate this Agreement. Upon such termination, CLIENT shall pay to AE2S all amounts owing to AE2S under this Agreement, for all work performed up to the effective date of termination, plus reasonable termination costs. 8. Access CLIENT shall arrange for safe access to and make all provisions for AE2S and AE2S's Consultants to enter upon public and private property as required for AE2S to perform services under this Agreement. 9. Hazardous Environmental Conditions It is acknowledged by both parties that AE2S's scope of services does not include any services related to a "Hazardous Environmental Condition," i.e. the presence at the site of asbestos, PCBs, petroleum, hazardous waste, or radioactive materials in such quantities or circumstances that may present a substantial danger to persons or property exposed thereto in connection with the Assignment. In the event AE2S or any other party encounters a Hazardous Environmental Condition, AE2S may, at its option and without liability for consequential or any other damages, suspend performance of services on the portion of the Assignment affected thereby until CLIENT: (i) retains appropriate specialist consultant(s) or Contractor(s) to identify and, as appropriate, abate, remediate, or remove Exhibit A - Standard Terms and Conditions Page 1 of 2 the Hazardous Environmental Condition; and (ii) warrants that the site is in full compliance with applicable laws and regulations. CLIENT acknowledges that AE2S is performing professional services for CLIENT and that AE2S is not and shall not be required to become an "arranger," "operator," "generator," or "transporter" of hazardous substances, as defined in the Comprehensive Environmental Response, Compensation, and Liability Act of 1990 (CERCLA), which are or may be encountered at or near the site in connection with AE2S's activities under this Agreement. fi 14. Force Majeure AE2S shall not be liable for any loss or damage due to failure or delay in rendering any service called for under this Agreement resulting from any cause beyond AE2S's reasonable control. 15. 10. Patents AE2S shall not conduct patent searches in connection with its services under this Agreement and assumes no responsibility for any patent or copyright infringement arising therefrom. Nothing in this Agreement shall be construed as a warranty or representation that anything made, used, or sold arising out of the services performed under this Agreement will be free from infringement of patents or copyrights. 16. 11. Ownership and Reuse of Documents All documents prepared or furnished by AE2S pursuant to this Agreement are instruments of service, and AE2S shall retain an ownership and property interest therein. Reuse of any such documents by CLIENT shall be at CLIENT's sole risk; and CLIENT agrees to indemnify, and hold AE2S harmless from all claims, damages, and expenses including attorney's fees arising out of such reuse of documents by CLIENT or by others acting through CLIENT. 12. Use of Electronic Media a. Copies of Documents that may be relied upon by CLIENT are limited to the printed copies (also known as hard copies) that are signed or sealed by the AE2S. Files in electronic media format of text, data, graphics, or of other types that are furnished by AE2S to CLIENT are only for convenience of CLIENT. Any conclusion or information obtained or derived from such electronic files will be at the user's sole risk. No Third Party Beneficiaries All duties and responsibilities undertaken pursuant to this Agreement will be for the sole and exclusive benefit of CLIENT and AE2S and not for the benefit of any other party. Nothing contained in this Agreement shall create a contractual relationship with or a cause of action in favor of a third party against either CLIENT or AE2S. AE2S's services under this Agreement are being performed solely for CLIENT's benefit, and no other entity shall have any claim against AE2S because of this Agreement or the performance or nonperformance of services hereunder. Assignment Neither party shall assign its rights, interests or obligations under this Agreement without the express written consent of the other party. 17. Binding Effect This Agreement shall bind, and the benefits thereof shall inure to the respective parties hereto, their legal representatives, executors, administrators, successors, and assigns. 18. Severability and Waiver of Provisions Any provision or part of the Agreement held to be void or unenforceable under any laws or regulations shall be deemed stricken, and all remaining provisions shall continue to be valid and binding upon CLIENT and AE2S, who agree that the Agreement shall be reformed to replace such stricken provision or part thereof with a valid and enforceable provision that comes as close as possible to expressing the intention of the stricken provision. Non - enforcement of any provision by either party shall not constitute a waiver of that provision, nor shall it affect the enforceability of that provision or of the remainder of this Agreement. b. When transferring documents in electronic media format, AE2S makes no representations as to long -term compatibility, usability, or readability of 19. Survival documents resulting from the use of software application packages, All express representations, indemnifications, or limitations of liability operating systems, or computer hardware differing from those used by included in this Agreement will survive its completion or termination for AE2S at the beginning of this Assignment. any reason. c. If there is a discrepancy between the electronic files and the hard copies, the hard copies govern. d. Because data stored in electronic media format can deteriorate or be modified inadvertently or otherwise without authorization of the data's creator, the party receiving electronic files agrees that it will perform acceptance tests or procedures within 60 days, after which the receiving party shall be deemed to have accepted the data thus transferred. Any errors detected within the 60 -day acceptance period will be corrected by the party delivering the electronic files. AE2S shall not be responsible to maintain documents stored in electronic media format after acceptance by CLIENT. 13. Contractors AE2S shall not at any time supervise, direct, control, or have authority over any Contractor's work, nor shall AE2S have authority over or be responsible for the means, methods, techniques, sequences, or procedures of construction selected or used by any Contractor, or the safety precautions and programs incident thereto, for security or safety at aproject site, nor for any failure of a Contractor to comply with laws and regulations applicable to such Contractor's furnishing and performing of its work AE2S neither guarantees the performance of any Contractor nor assumes responsibility for any Contractor's failure to furnish and perform its work in accordance with the contract between CLIENT and such Contractor. AE2S shall not be responsible for the acts or omissions of any Contractor, subContractor, or supplier, or of any of their agents or employees or of any other persons (except AE2S's own employees) at a project site or otherwise furnishing or performing any construction work; or for any decision made regarding the construction contract requirements, or any application, interpretation, or clarification of the construction contract other than those made by AE2S. 20. Headings The headings used in this Agreement are for general reference only and do not have special significance. 21. Controlling Law This Agreement is to be governed by the law of the State of Minnesota without regard to its conflicts of laws principles. 22. Notices Any notice required under this Agreement will be in writing, addressed to the appropriate party at its address on the signature page and given personally, or by registered or certified mail postage prepaid, or by a commercial courier service. All notices shall be effective upon the date of receipt. 23. Executed in Counterparts This Agreement may be executed in counterparts, each of which together will constitute one and the same instrument. Delivery of an executed counterpart of this Agreement shall constitute effective delivery of this Agreement. Each party agrees that the delivery of the Agreement by facsimile or electronic mail shall have the same force and effect as delivery of original signature and that each Party may use such facsimile or electronic mail signatures as evidence of the execution and delivery of the Agreement by the parties to the same extent that an original signature could be used. Exhibit A - Standard Terms and Conditions Page 2 of 2 5� This is EXHIBIT B, consisting of 2 pages, referred to in and part of the Agreement between CLIENT and AE2S dated [11/8/17]. Hourly Fee and Expense Schedule Reimbursable Expenses and Standard Hourly rates in effect on the date of the Agreement are set forth below. Rates are subject to annual adjustment effective January 1. Labor Rates* Administrative I $56.00 I &C Technician I $94.00 Administrative II $69.00 I &C Technician II $106.00 Administrative 111 $82.00 I &C Technician 111 $120.00 Administrative IV $94.00 I &C Technician IV $132.00 I &C Technician V $145.00 Communications Specialist $84.00 I &C Specialist $156.00 Communications Specialist 11 $97.00 I &C Senior Specialist $165.00 Communications Specialist III $111.00 I &C Manager $174.00 Communications Specialist IV $134.00 IT I $94.00 Construction Services Manager I $128.00 IT II $116.00 Construction Services Manager II $139.00 IT 111 $131.00 Construction Services Manager 111 $156.00 IT IV $148.00 Construction Services Manager IV $173.00 IT V $163.00 Construction Services Manager V $189.00 IT VI $173.00 1'F Manager $191.00 Construction Services Rep I $79.00 Construction Services Rep 11 $94.00 Land Surveyor 1 $93.00 Construction Services Rep 111 $110.00 Land Surveyor 11 $112.00 Land Surveyor 111 $124.00 Engineer 1 $100.00 Land Surveyor IV $138.00 Engineer 11 $124.00 Engineer III $148.00 Marketing Consultant I $79.00 Engineer IV $168.00 Marketing Consultant II $99.00 Engineer V $183.00 Marketing Consultant III $121.00 Engineer VI $206.00 Marketing Consultant IV $139.00 Engineer VII $220.00 Engineer VIII $230.00 Operations Specialist I $79.00 Operations Specialist II $94.00 Engineering Technician 1 $64.00 Operations Specialist 111 $118.00 Engineering Technician 11 $82.00 Operations Specialist IV $134.00 Engineering Technician III $97.00 Operations Specialist V $155.00 Engineering Technician IV $113.00 Engineering Technician V $128.00 Program Coordinator I $168.00 Engineering Technician VI $143.00 Program Coordinator 11 $179.00 Program Coordinator 111 $190.00 Financial Analyst I $84.00 Financial Analyst II $99.00 Project Coordinator I $100.00 Financial Analyst III $116.00 Project Coordinator II $113.00 Financial Analyst IV $131.00 Financial Analyst V $148.00 Project Manager I $158.00 Financial Analyst VI $168.00 Project Manager II $173.00 Financial Analyst VII $183.00 Project Manager 111 $190.00 Financial Analyst VIII $200.00 Project Manager IV $205.00 GIS Specialist $82.00 Senior Designer $179.00 GIS Specialist II $99.00 Senior Consultant I $200.00 GIS Specialist III $118.00 Senior Consultant 11 $220.00 GIS Specialist IV $133.00 Technical Expert I $236.00 Technical Expert II $256.00 Technical Expert III Negotiable Exhibit B - Hourly Fee and Expense Schedule Page 1 of 2 Reimbursable Expense Rates fi Transportation $0.65 /mile Survey Vehicle $0.70 /mile B &W Photocopies 8'/z" x11" $0.10 /copy B &W Laser Printouts 8'/z" x11" $0.20 /page Color Laser Printouts /Copies 8'/z" x11" $0.68 /page Plots — Color Bond $1.25 /s.f. Plots — Monochrome Bond/Vellum $0.75 /s.f. Plots — Film/Photo High Gloss $2.00 /s.f. Total Station — Robotic $35.00 /hour Pro -XR GPS $15.00 /hour Fast Static/RTK GPS $50.00 /hour Sonar Mite $50.00 /day All- Terrain Vehicle/Boat $100.00 /day Air Transportation - Pilatus $1,600 /hour Air Transportation — Cirrus $700 /hour In -house Lodging $150.00 /day Legal Services Reimbursement $211.00/hour Outside Services ** cost *1.15 Geotechnical Services cost *1.30 Out of Pocket Expenses * ** cost *1.15 Rental Car cost *1.20 * Position titles are for labor rate grade purposes only. ** Includes laboratory testing, architectural and engineering consultants, surveying, etc. * ** Includes toll telephone, shipping, postage, subsistence, technical literature, equipment rental, etc. Exhibit B — Hourly Fee and Expense Schedule Page 2 of 2 �J F]E,!Fb* THINK BIG. GO BEYOND. ADVANCED ENGINEERING AND ENVIRONMENTAL SERVICES, : INC. (AE2S) is a specialized environmental consulting engineering firm that provides professional services and our unique brand of extreme client service to municipal, rural, and industrial clients. Our primary service is water - meaning drinking water, wastewater, and water resources consulting, which represents over 70 percent of our annual revenues. We have 18 office locations with a staff of over 300 professionals who are experts in their field and passionate about what they do. In addition to the more traditional consulting services, we also provide value -added services as stand -alone services or in support of our primary services which are listed to the right. • • • • • • • Q We've assembled a team of experts that are solely dedicated to GIS, modeling, instrumentation and controls, and financial services. Their specialized expertise results in high quality service in a cost effective manner. `a OFFICE LOCATIONS Not shown: Salt Lake City, UT .I CORE ENGINEERING SERVICES Drinking Water Wastewater Water Resources /Stormwater SPECIALTY SUPPORT SERVICES GIS Services I &I Flow Monitoring Modeling Trenchless Technology Asset Management Master Planning Capital Improvement Planning AE2S Nexus /Financial Planning Instrumentation & Controls Structural Engineering Electrical Engineering Energy Management Arc Flash Hazard Analysis Information Technology Electrical Construction Contracting Treatment Optimization Operations OpWorks" Public Relations /Outreach Permitting Services Program Management 0000 www.ae2s.com i Instrumentation &Controls a, E p A Think Big. Go Beyond. tlT7lii0 11tgN0 !`178010 Iiiiiiiiiiiiiiii �urili rimf WN .Z Stapp t M5935 ConbAm NISWI fad 4AC �+w QW R7, 9t& Rdte Web wimml m PPP RW PW 11 RK9ck flil W" Fii6 lf��avK! 1 O ADVANCED ENGINEERING AND ENVIRONMENTAL SERVICES, INC. (AE2S) is a civil and environmental engineering and geomatics firm. Since 1991, AE2S has successfully completed thousands of projects establishing itself as a premier water /wastewater engineering consultant in the upper Midwest. AE2S has a staff of approximately 280 instrumentation and controls engineers and technicians, programmers, civil and environmental engineers, GIS professionals, surveyors and mappers, technicians, financial analysts, public relations and communications specialists, and administrative personnel. We offer specialized services for Instrumentation and Control Systems, particularly with respect to the water and wastewater industries. Our control system engineers and technicians are classroom trained, field experienced, and dedicated to bringing you high quality service. INSTRUMENTATION & CONTROL SERVICES • System Evaluations Computer Networking Schematics • Needs Assessments Training Construction • System Upgrade Report Documents Coordination Planning and Factory Acceptance Process and Implementation Testing Instrumentation • System Design Operations Manuals Diagrams • Programming System On -Call Service • Hardware and Documentation Software Support Control Panel Wiring �MV vrrrrrr� f 0 Min TTTUM ,�♦ '� �''f'rTT'7ti', i iT � . F i w �� E MAKING YOUR OPERATIONS EFFICIENT WITH SCADA A well- designed and properly - utilized SCADA system can dramatically effect the efficiency and effectiveness of a water or wastewater utility. SCADA can help you on a daily basis with monitoring, but SCADA is much more than displaying flows and pumps on a computer screen. It's taking all of the data that is available to you and using it to your advantage. The ability to monitor and instantly retrieve data is critical to efficient operations. Whether you need real -time or historical data, a properly designed and implemented SCADA system can manage these demands for you, saving you tremendous amounts of time and effort. AW r t ........... 0 is L; MEETING REGULATORY REQUIREMENTS Regulations and associated reporting requirements are a way of life for water and wastewater utilities. At AE2S, we not only understand current regulations, but constantly keep our eye on potential regulations that may impact our clients in the future. Armed with this knowledge, we help clients create powerful tools customized for their specific utilities. We can set up systems to automatically generate monthly, quarterly, and annual regulatory forms from data that's already available. Whether you need to add instrumentation, automate process control, or need an all - new SCADA system, our engineers and programmers are experts in customizing your system to most efficiently help you achieve regulatory compliance - both now and in the future. .1 t*I .N .......... 0 THE PROCESS Our process focuses on truly understanding your system, opportunities, and particular preferences. We work with you to develop a solution custom - tailored to your exact needs. 1. First, your AE2S control system engineer will meet with you to discuss exactly what your needs and expectations are. This first step is critical to ensure that the right direction is established to achieve the results you desire. 2. Next, an evaluation of the system is required to assess the components that are available and what is needed. From this evaluation, a report will be prepared to illustrate: • system needs • proposed solutions • schedules • funding possibilities 3. Once you decide on which recommendations to implement, we can get started right away. A phased approach may allow you to manage costs while realizing results immediately. 4. Training is an integral process of start-up. This normally includes computer and software training, as well as electrical and instrumentation troubleshooting. Backwash F�� ST6J5t sT•J•• P7010 P6350 P6340 -330 P6321 P6310 Remote 0.emol cowl Remote Renwtc Yla�d �1 hee C12 azlmo/1 Wonderware System rata to iotal02 L16mp/t Platform qF B.SOp aaMfl a.r ®mV1 Cimplicity Microsoft SQL Server ... WonderWare InSQL �V,jevAl RSView ® .. WeA Sutts+"ct �lccze LTC&JO TAGGadgets 11--16310 .......... 0 SYSTEM EXPERTISE We have extensive experience working efficiently with various systems and have helped many clients move to non - proprietary systems. INSTRUMENTATION & CONTROL SERVICES Wonderware System Data Acquisition and PLC Platforms Platform Reporting Allen - Bradley Cimplicity Microsoft SQL Server • PLC /5 Series WonderWare InSQL • SLC /500 Series RSView • ControlLogix Series PanelView Crystal Reports • MicroLogix Series QuickPanel /Data Microsoft Access Panel Microsoft Excel GE Fanuc Fix32 /!Fix • VersaMax Telemetry • Series 90/30 Distributed 10 Networks Serial Radios • Series 90/70 Ethernet Ethernet Radios • Modicon Quantum ControlNet Fiber Optics • DeviceNet HMI Software Profibus . Wonderware InTouch Modbus O EXPERIENCE AE2S' experience includes providing control system programming and field support for a wide variety of infrastructure. Below is a sampling of project types we typically work on. Water Treatment • Surface and Ground Water • Iron and Manganese Removal • Lime Softening • Nitrate Removal Automated Chemical Feed System Integration • Radio Telemetry • Fiber Optics • Instrumentation Configuration CLIENTELE • City of Fargo, ND • City of Bismarck, ND • City of Grand Forks, ND • City of Williston, ND • City of Mandan, ND • City of Grafton, ND • City of Eden Prairie, MN • City of Burnsville, MN • Advanced Motor Control Center Integration Distribution Systems • Lift Station Monitoring and Control Distribution Systems • Water Tower Monitoring and Control • City of Otsego, MN • City of St. Cloud, MN • City of Fairmont, MN • City of Savage, MN • Alexandria Light and Power, Alexandria, MN • Marshall Municipal Utilities • Booster Pump Station Monitoring and Control Rural Water Systems • Supervisory Control • Data Acquisition Pressure Sustaining Pumping Systems • Reservoir Monitoring and Control • Radio Telemetry • Langdon Rural Water District • Walsh Rural Water District • North Valley Water District Electrical Engineering mm O ELECTRICAL ENGINEERING EMPOWERING. More than just circuit design and wiring, electrical engineering is essential to make facilities run smoothly and operate efficiently. Our electrical engineering group brings a powerful combination of design, bidding and construction experience in numerous aspects of electrical projects, including water treatment and distribution, wastewater treatment and collection, power generation, power distribution, lighting, controls, instrumentation and Supervisory Control and Data Acquisition (SCADA). Even down to the details - from computer - generated load -flow analysis to short- circuit studies, our team can make sure your systems are performing at the optimum level. ELECTRICAL ENGINEERING SERVICES Power Distribution and Switchgear thru 15kV Instrumentation & Controls Supervisory and Data Acquisition Radio, Cellular and Satellite Telemetry Fiber Optics Motor Controls and Variable Frequency Drives (VFDs) Power Generation • Paralleling Generation Switchgear thru 15kV • Uninterruptible Power Supplies • Lighting and Lighting Control Systems • Telecommunication Systems, Intercom and Data Networks • Security, Video Surveillance and Access Control Systems • Fire Alarm Systems • Electrical System Studies (Short Circuit, Coordination, Arc Flash, Load Flow) • Feasibility Studies • Energy Audits and Energy Conservation Studies • Photovoltaic Systems • Street, Roadway, and Parking Lot Lighting INFRARED INSPECTION : Infrared Thermography is an ideal inspection technique for scanning electrical equipment for defective components. Normal wear, chemical « • contamination, corrosion, fatigue and faulty installation (loose or dirty : connections) may lower the conductivity and raise the component resistance level. This in turn will cause an increase in temperatures of the component. Routine infrared scanning of electrical components is a valuable predictive maintenance tool whereby early corrective action may be taken to prevent costly breakdowns, outages, and /or building hazards. • • • • • • • • • • • • • • • • 0 WHAT IS AN ELECTRICAL THERMAL IMAGING STUDY? A study of electrical equipment using an infared camera to detect: • REPORT CONTENTS: Loose connections • Overloaded circuits • List and description Insulation failures of all equipment Hot spots items scanned • Visible light and infrared version WHY PERFORM AN ELECTRICAL THERMAL IMAGING STUDY? of the equipment • Identify failing equipment early, before it fails. images Results, Reduced insurance premiums for annual studies. recommendations, Reduce risk of management by lowering contingency budgets. and potential Ensure your equipment is operating properly and effectively. problems noted Increase overall safety for personnel. 'O ARC FLASH RISK ANALYSIS An Arc Flash incident is a violent eruption of energy from an arcing fault that results in extreme heat, ear damaging sound levels, shrapnel, pressure waves and eye damaging light levels. WHAT CAUSES AN ARC FLASH? The breakdown of the insulation barrier between an exposed live part and the ground or between two exposed live parts. Common causes include: • Dust, impurities, and corrosion • Dropped tools on energized parts • Accidental contact with a live part • Improper work procedures • Conductor insulation failure WHY PERFORM AN ARC FLASH HAZARD ANALYSIS • National Electric Code (NEC) 110.16 states "switchboards, panel boards, industrial control panels, meter socket enclosures, and motor control centers that are in other than dwelling occupancies and are likely to require examination, adjustment servicing, or maintenance while energized shall be field marked to warn qualified persons of potential Arc Flash Hazards" • Determine the proper PPE (Personal Protective Equipment) level workers should wear when servicing energized equipment. • Make your electrical system safe and reliable through proper coordination and evaluations of equipment Kiloampere Interrupting Current (KAIC) ratings. • Reduce the potential of fines being assessed by OSHA for non - compliance to NFPA 70, 70E and OSHA 1910, Subpart S. ARC FLASH INCIDENT FACTS • The resulting sound from the explosion can exceed 160dB. • 80% of all electrical burns result from ignition of clothing. Force of the pressure wave can be as much as 2,000 lbs per square foot. In the United States, five workers per day on the average are sent to a burn center with electrical burns, resulting in 1 -2 deaths per day. • Copper expands to 67,000 times its solid volume when transitioning from solid to a vapor during an Arc Flash. Air temperature can reach 35,000 °F. A WARNING Arc Flash and Shock Hazard Appropriate PPE Required 33inches Flash Hazard Boundary 3.2 cal.'cm ^2 Flash Hazard at 18 inches Category 1 Arc -rated FR Shirt & Pants 480 VAC Shock Hazard when cover is removed 00 Glove Class 42inche5 Limited Approach 12 inches Restricted Approach 1 inches ProhibitedApproach Location: MCC -13 BUS Advanced Engineering and Enviromental Services, Inc. 0 6901 East Fish Lake Road Suite 184., Maple Grove, MN 55369 (763)463-5036 Jobs: Po5354 Prepared on: _T M By:1 CDH Warning: Changes in equipment settings or system configuration will invalidate the calculated values and PPE requirements ARC FLASH RISK ANALYSIS COMPONENTS CREATING THE COMPUTER MODEL Data required: • Transformer characteristics • Feeder characteristics • Motor characteristics • MCC and equipment information Circuit breaker - Model number, ampere rating, frame type, electronic trip unit type, trip unit settings • Fuses - Model number, size, fuse type • Equipment ratings SHORT CIRCUIT ANALYSIS Calculates the magnitude of bolted fault current available at each piece of electrical equipment in an electrical system to determine inadequate KAIC ratings PROTECTIVE DEVICE COORDINATION STUDY Verifies that the over - current devices in the building trip in the proper order. Verifies that the over - current device located closest to the fault clears the fault before the next device upstream. • Establishes the time that it takes for the over - current device to clear the fault. ARC FLASH RISK ASSESSMENT • Establishes the Arc Flash Hazard /Risk Category for each piece of equipment. • Establishes recommended ratings for Personal Protective Equipment (PPE) requirements based on the incident energy level. • Defines the Arc Flash Hazard Boundary. Resistance (in Megohms) O MEGOHM INSULATION TESTING Every electrical wire in your facility is carefully covered with some form of electrical insulation. This insulation is meant to resist the current and to keep the current flowing along the internal wires to the required electrical equipment. However, no Insulation is perfect. Electricity does not always flow along the insulation. Deviant currents may only be millionths of an ampere, but can create problems in cases of deteriorated insulation. HOW INSULATION RESISTANCE IS MEASURED Insulation resistance is measured with a small portable instrument, generally referred to as a "Megohm" tester. The instrument gives you a direct reading of insulation resistance in ohms or more commonly, megohms (millions of ohms). For electrical insulation, the higher the resistance the better the insulation. 0 Time (in seconds) 60 sec 1000 500 -d Value gohms) 100 Resistance 50 [in Megohms) 10 Periodic Testing can help 5 predict impending failures Initial Aging Acceptance of After 'lest Insulation Rewinding Year Insulation Failure WHY HAVE AN INSULATION TESTING PROGRAM? • Assure safety of personnel • Detect premature failures to prevent downtime • Prevent electrical shocks • Evaluate the quality of repairs prior to equipment being put back into operation WHY DOES INSULATION DEGRADE AND FAIL? Even with improved, modern insulation designs, insulation systems are often exposed susceptible environments that can cause failure. Some of these include, but are not limited to: • Mechanical damage Vibration : Excessive heat or cold • Dirt • Oil : Corrosive vapors • Moisture and humidity • , • • A ROUTINE, PERIODIC INSULATION RESISTANCE TESTING PROGRAM PROVIDES THE FOLLOWING: • Proactive equipment replacement schedules. • Peace of mind that insulation systems are reliable and not "on the brink of failure" • Personnel safety. • Detection of premature failures and limits unscheduled downtime. THINK BIG. GO BEYOND. FOR MORE INFORMATION Damon Chmela, PE Damon.ChmelaCdae2s.com 605 - 275 -5620 =f* I nXTY�u;l www.ae2s.com To: Patrick Johnson Cc: Greg Lerud; Marie Darling; Scott Zerby; Jennifer Labadie; Debbie Siakel; Kristine Sundberg; Alyson Fauske; Joe M. Rigdon; Tim Keane (tim.keane c� }kutakrackmmcor) Subject: RE: Boulder Bridge Well Patrick: I should clarify that the original controls were installed as a standalone system within the Boulder Bridge subdivision in 1981. When the west tower was constructed, the well controls were modified significantly under the tower construction project, for the addition of the water tower, such that the wells at this site would feed into the water tower and work in tandem with the Badger well. The modification of the main controls was very poorly executed. Now that the controls are over 36 years old, the entire control system needs to be replaced, as parts are obsolete for the controls. Larry Brown Director of :liiii N From: Larry Brown Sent: Monday, December 11, 2017 3:11 PM To: Patrick Johnson <PJohnson ci.shorewood.mn.us> Cc: Greg Lerud <tJLerud ci.shorewood.rrn.us >; Marie Darling <mdarlin ci.shorewood.mn . us >; Scott Zerby <SZerb ci.shorewood.mn.us >; Jennifer Labadie <JLaadie ci.shorewood.mn.us >; Debbie Siakel <DSiakel ci.shorewood.mn.us >; Kristine Sundberg <KSur�dber ci.shorewood.mn . us >; ' Alyson Fauske' <AFauske wsben .com >; Joe M. Rigdon <Joe.Ri dopj« anKDV.carn >; Tim Keane (tim.keane kutakrock.com) <tim.keanekutakrock.com> Subject: RE: Boulder Bridge Well Patrick: Thank you for the question! Those are all great points /details. Yes, the control center was installed with the initial well facility. Back at that time, it was Shorewood's practice that the developer would install the utilities, and then turn them over to the City for perpetual ownership and maintenance. Such is the case here. You are correct. The well house and wells are owned by the City. However, they are located on the HOA common property. This well facility pumps water to the water tower located on the Minnewashta School property, as does the well located in Badger Park. Therefore, all of the connected users on the west side benefit from this well. When the west water tower was constructed, the control portion of contract was a very small portion of the contract, and did not get the scrutiny it deserved. This is analogous to a company building a beautiful sports car and stating that we will just add the ignition system when the time comes due at the end. It sure is pretty to look at, but when it does not work, it certainly leads one to wonder what good the piece of metal is! The controls distribute power when the SCADA system tells the pumps to run. For many years staff was called out (sometimes many times in the middle of the night) due to failure of the pumps to start and run. I can tell you from personal experience, that showing up in the middle of the night for the third time for a failed control system gets very wearing. Iq Thus we, as did many communities during the era learn the hard way that the control piece of the contract was never to be lumped in with a general construction contract; That they were to be designed separately under a high amount of scrutiny by a well- practiced firm. Such is the case here. Lorry Brown Director of Public Worksotherwise you end up For the City of Shorewood irecte 52-960 -7913 From: Patrick Johnson Sent: Monday, December 11, 2017 2:55 PM To: Larry Brown <Ibrownshorewoodpw,corr�> Cc: Greg Lerud <GLerud : ct Shorewood mn.us >; Marie Darling <MDarlin;ci.sharewood.rnn.us >; Scott Zerby <SZerb ci.shorewood.mn.us> Subject: Boulder Bridge Well Larry, Could you provide some larger context for the proposal we are discussing tonight? The background says that the control center was installed in 1981. Was that when the development was constructed? Who was originally responsible for maintenance? From the Hennepin County Tax map, I see that this parcel is owned by the Boulder Bridge Farm Association. Is that a HOA? And from a high level what does the well provide and who all benefits from it as well as some detail about how the water tower construction required modifications. Other council members may have more background so if I am the only one, I assume we could do offline rather than take up time during the meeting. Patrick R. Johnson 612.217.4704 3 CITY OF SHOREWOOD RESOLUTION NO. 17 - A RESOLUTION ACCEPTING THE PROPOSAL FOR PROFESSIONAL DESIGN SERVICES WITH AE2S FOR THE BOULDER BRIDGE WELL MOTOR CONTROL PROJECT, CITY PROJECT 18 -01 WHEREAS, the 2018 Municipal Water Capital Improvement Program has programmed an improvement known as the Boulder Bridge Well Motor Control Center, City Project 18- ; and WHEREAS, staff has solicited Professional Design Service proposals for design, bidding and construction services for said project; and WHEREAS, the Director of Public Works has reviewed the proposal submitted by the firm of AE2S, included as Exhibit A, and finds it to be in order. NOW, THEREFORE, BE IT RESOLVED by the City Council of the City of Shorewood, Minnesota: The proposal for Professional Design Services, as submitted by the firm of AE2S, dated December 5th, 2017, and attached hereto as Exhibit A is hereby approved. ADOPTED BY THE CITY COUNCIL OF THE CITY OF SHOREWOOD this 1 lth day of December, 2017. ATTEST: Sandie Thone, City Clerk Scott Zerby, Mayor #8B MEETING TYPE City of Shorewood Council Meeting Item Regular Meeting Title / Subject: Accept Bids and Award Contract for the 2017 Inflow & Infiltration Abatement Project, City Project 17 -16 Meeting Date: December 11, 2017 Prepared by: Alyson Fauske, City Engineer Reviewed by: Larry Brown, Public Works Director Attachments: Resolution, Bid Results Letter, Bid Summary Background: The city budgeted $70,000 for and I &I abatement project in 2017 and can participate in the Metropolitan Council's 2017 1 &1 grant program to offset a portion of the cost. This is a joint project with the City of Tonka Bay and includes lining 1,966 linear feet of sanitary sewer within Shorewood. Bids were opened Tuesday, December 5, 2017; a summary of the bid results are attached. The lowest responsible bidder is Visu- Sewer, Inc., Pewaukee, Wisconsin with a total of $83,776.00. The total for work within the City of Shorewood is $51,643.00. The Engineer's estimate for the project was $66,200. Financial or Budget Considerations: The City is participating in the Metropolitan Council's Inflow and Infiltration Grant program. Therefore, once the project is complete, staff will request reimbursement for eligible project costs. Options: Staff recommends Council consider the following actions: 1. Approve the resolution Accepting the Bids and Awarding the Contract for the 2017 Inflow and Infiltration Abatement Project, City Project 17 -16. 2. Reject all bids for the 2017 Inflow and Infiltration Abatement Project, City Project 17 -16. 3. Take no action at this time. Recommendation: Staff recommends the City Council approve the attached resolution "Accepting the bids and awarding the contract for the 2017 Inflow and Infiltration Abatement Project, City Project 17- 16" Mission Statement: The City of Shorewood is committed to providing residents quality public services, a healthy environment, a variety of attractive amenities, a sustainable tax base, and sound financial management through effective, efficient, and visionary leadership. Page 1 CITY OF SHOREWOOD RESOLUTION NO. 17 - A RESOLUTION ACCEPTING BIDS AND AWARDING CONTRACT FOR THE 2017 INFLOW AND INFILTRATION ABATEMENT PROJECT CITY PROJECT NO. 17 -16 WHEREAS, pursuant to an advertisement for bids for local improvements designated as the 2017 Inflow and Infiltration Abatement Project, City Project 17 -16, bids were received, and opened on December 5, 2017, and tabulated according to law, and such tabulation is attached hereto and made a part hereof as Exhibit A; and WHEREAS, the City Council has determined that Visu- Sewer, Inc. is the lowest bidder in compliance with the bid documents. NOW, THEREFORE, BE IT RESOLVED, by the City Council of the City of Shorewood as follows: 1. That the Mayor and City Clerk are hereby authorized and directed to enter into a contract with Visu- Sewer, Inc. in the name of the City of Shorewood, Project No. 17 -16, according to the plans and specifications therefore approved by the City Council on file in the office of the City Clerk. 2. That the City Clerk is hereby authorized and directed to return forthwith to all bidders the deposits made with their bids, except for the deposits of the successful bidder and the next two lowest bidders, which shall be retained until a contract has been signed. ADOPTED BY THE CITY COUNCIL OF THE CITY OF SHOREWOOD this 11'' day of December, 2017. Scott Zerby, Mayor ATTEST: Sandie Thone, City Clerk ■r ,ter 178 East 9t" Street, Suite 2001 St. Paul, MN 55101 1 (651) 286 -8450 December 5, 2017 Honorable Mayor and City Council Honorable Mayor and City Council City of Tonka Bay City of Shorewood 4901 Manitou Road 5755 Country Club Road Tonka Bay, MN 55331 Shorewood, MN 55331 Re: 2017 Sanitary Sewer Lining Project City of Tonka Bay, MN and City of Shorewood, MN WSB Project Nos. R- 011018 -000 and R- 011017 -000 Dear Mayors and Council Members: Bids were received for the above - referenced project on Tuesday, December 5, 2017, and were opened and read aloud. Six bids were received. The bids were checked for mathematical accuracy. Please find enclosed the bid summary indicating the low Base Bid and Alternate No. 1, as submitted by Visu- Sewer, Inc, Pewaukee, Wisconsin, in the amount of $83,776.00. The Engineer's Estimate was $101,201.00. This project is a cooperative effort between the City of Tonka Bay and the City of Shorewood including sanitary sewer lining improvements in both communities with each community responsible for only funding improvements to their respective sanitary sewer systems. The total amount is broken into two separate schedules for improvements in each city, with the bid for Tonka Bay improvements totaling $32,133.00 and the bid and alternate for Shorewood improvements totaling $51,643.00 as shown below. TONKA BAY — SCHEDULE A BASE BID $32,133.00 SHOREWOOD — SCHEDULE B BASE BID $49,078.00 ALTERNATE 1 —SHOREWOOD ALTERNATE 1 $ 2,565.00 SHOREWOOD BASE BID PLUS ALTERNATE 1 $51,643.00 TOTAL BASE BID PLUS ALTERNATE $83,776.00 We recommend that the City Councils consider these bids and award a contract in the amount of $83,776.00 to Visu- Sewer, Inc. based on the results of the bids received. Sincerely, WSB & Associates, Inc. 5 Nick Preisler, PE Project Manager Attachment kkp Building a legacy —your legacy. Equal Opportunity Employer I wsbeng.com K: \011 01 8- 0 00\Admin \Construction Admin \Bidding \011 01 8 -0 00 LOR 120517.docx 011018 -00 -Project Bid Abstract Page 1 of 2 12/5/2017 Project: 011018 -00 - 2017 Sanitary Sewer Lining Project L Engineers Estimate Visu- Sewer, Inc. Hydro - Klean, LLC Insituform Technologies USA, LLC - MO Line No. Item ts Quantity I Unit Price I Total Price Unit Price Total Price Unit Price JTotal Price Unit Price JTotal Price SCHEDULE A - TONKA BAY 1 2021.501 MOBILIZATION LS 1 $2,000.00 $2,000.00 $565.00 $565.00 $2,000.00 $2,000.00 $658.10 $658.10 2 2503.603 LINING SEWER PIPE 8" L F 629 $25.00 $15,725.00 $25.00 $15,725.00 $21.70 $13,649.30 $31.40 $19,750.60 3 2503.603 LINING SEWER PIPE 9" L F 626 $26.00 $16,276.00 $23.00 $14,398.00 $22.40 $14,022.40 $27.20 $17,027.20 4 2563.601 TRAFFIC CONTROL LS 1 $1,000.00 $1,000.00 $1,445.00 $1,445.00 $250.00 $250.00 $1,315.30 $1,315.30 Total SCHEDULE A - TONKA BAY: $35,001.00 $32,133.00 $29,921.70 $38,751.20 SCHEDULE B - SHOREWOOD 5 2021.501 MOBILIZATION LS 1 $2,000.00 $2,000.00 $960.00 $960.00 $2,000.00 $2,000.00 $658.10 $658.10 6 2503.603 LINING SEWER PIPE 9" L F 1076 $25.00 $26,900.00 $23.00 $24,748.00 $22.40 $24,102.40 $26.00 $27,976.00 7 2503.603 LINING SEWER PIPE 12" L F 880 $35.00 $30,800.00 $24.00 $21,120.00 $30.70 $27,016.00 $28.50 $25,080.00 8 2563.601 TRAFFIC CONTROL LS 1 $1,000.00 $1,000.00 $2,250.00 $2,250.00 $250.00 $250.00 $771.00 $771.00 Total SCHEDULE B - SHOREWOOD: $60,700.00 $49,078.00 $53,368.40 $54,485.10 ALTERNATE 1 - SHOREWOOD 9 2021.501 MOBILIZATION LS 1 $1,500.00 $1,500.00 $165.00 $165.00 $1,647.00 $1,647.00 $1,069.10 $1,069.10 10 2503.603 LINING SEWER PIPE 8" L F ILS 10 $350.00 $3,500.00 $230.00 $2,300.00 $318.40 $3,184.00 $620.10 $6,201.00 11 2563.601 TRAFFIC CONTROL 1 $500.00 $500.00 $100.00 $100.00 $100.00 $100.00 $106.90 $106.90 Total ALTERNATE 1 - SHOREWOOD: $5,500.00 $2,565.00 $4,931.00 $7,377.00 Total SCHEDULE A - TONKA BAY: $35,001.00 $32,133.00 $29,921.70 $38,751.20 Total SCHEDULE B - SHOREWOOD: $60,700.00 $49,078.00 $53,368.40 $54,485.10 Total ALTERNATE 1 - SHOREWOOD: $5,500.00 $2,565.00 $4,931.00 $7,377.00 Totals for Project 011018 -00 1 1$101,201.001 $83,776.001 1 $88,221.101 1$100,613.30 of Estimate for Project 011018 -00 1 1 1 1 - 17.22% - 12.83% -0.58% 011018 -00 -Project Bid Abstract Page 2 of 2 I hereby certify that this is an exact reproduction of bids received. f Certified By: r` License No. 54902 Date: December 5, 2017 Project: 011018 -00 - 2017 Sanitary Sewer Lining Project Engineers Estimate Michels Pipe Services - Brownsville Veit & Company, Inc. Lametti & Sons, Inc. Line No. Item Units Quantity Unit Price JTotal Price Unit Price Total Price Unit Price JTotal Price Unit Price Total Price SCHEDULE A - TONKA BAY 1 2021.501 MOBILIZATION LS 1 $2,000.00 $2,000.00 $2,360.00 $2,360.00 $2,850.00 $2,850.00 $2,200.00 $2,200.00 2 2503.603 LINING SEWER PIPE 8" L F 629 $25.00 $15,725.00 $37.50 $23,587.50 $28.00 $17,612.00 $47.00 $29,563.00 3 2503.603 LINING SEWER PIPE 9" L F 626 $26.00 $16,276.00 $28.50 $17,841.00 $28.00 $17,528.00 $34.00 $21,284.00 4 2563.601 TRAFFIC CONTROL LS 1 $1,000.00 $1,000.00 $1,436.00 $1,436.00 $550.00 $550.00 $1,000.00 $1,000.00 Total SCHEDULE A - TONKA BAY: $35,001.00 $45,224.50 $38,540.00 $54,047.00 SCHEDULE B - SHOREWOOD 5 2021.501 MOBILIZATION LS 1 $2,000.00 $2,000.00 $2,360.00 $2,360.00 $2,850.00 $2,850.00 $1,500.00 $1,500.00 6 2503.603 LINING SEWER PIPE 9" L F 1076 $25.00 $26,900.00 $26.50 $28,514.00 $28.00 $30,128.00 $30.00 $32,280.00 7 2503.603 LINING SEWER PIPE 12" L F 880 $35.00 $30,800.00 $27.00 $23,760.00 $33.00 $29,040.00 $32.00 $28,160.00 8 2563.601 TRAFFIC CONTROL LS 1 $1,000.00 $1,000.00 $1,436.00 $1,436.00 $550.00 $550.00 $1,000.00 $1,000.00 Total SCHEDULE B - SHOREWOOD: $60,700.00 $56,070.00 $62,568.00 $62,940.00 ALTERNATE 1 - SHOREWOOD 9 2021.501 MOBILIZATION LS 1 $1,500.00 $1,500.00 $1,985.00 $1,985.00 $1,450.00 $1,450.00 $1,000.00 $1,000.00 10 2503.603 LINING SEWER PIPE 8" L F ILS 10 $350.00 $3,500.00 $375.00 $3,750.00 $725.00 $7,250.00 $380.00 $3,800.00 11 2563.601 TRAFFIC CONTROL 1 $500.00 $500.00 $187.00 $187.00 $250.00 $250.00 $500.00 $500.00 Total ALTERNATE 1 - SHOREWOOD: $5,500.00 $5,922.00 $8,950.00 $5,300.00 Total SCHEDULE A - TONKA BAY: $35,001.00 $45,224.50 $38,540.00 $54,047.00 Total SCHEDULE B - SHOREWOOD: $60,700.00 $56,070.00 $62,568.00 $62,940.00 Total ALTERNATE 1 - SHOREWOOD: $5,500.00 $5,922.00 $8,950.00 $5,300.00 Totals for Project 011018 -00 $101,201.00 1 1$107,216.50 $110,058.00 1 1$122,287.00 of Estimate for Project 011018 -00 1 5.94% 8.75% 1 20.84% I hereby certify that this is an exact reproduction of bids received. f Certified By: r` License No. 54902 Date: December 5, 2017 I M M City of Shorewood Council Meeting Item Title / Subject: Resolution Liquor License Bunker Indoor Golf MEETING TYPE Meeting Date: Monday, December 11, 2017 Regular Meeting Prepared by: Sandie Thone, City Clerk Reviewed by: Greg Lerud, City Administrator Attachments: Resolution Policy Consideration: Approval of New Liquor License: Wine /Strong Beer and Special Sunday Sales to Bunker Indoor Golf: Shorewood City Code Chapter 401, Liquor Regulations provides for consideration of licensing establishments to sell on and off -sale liquor in the city limits. Background: The following establishment is requesting council consideration in issuing a new liquor license: Applicant Address License Edward Boeve 23720 State Highway 7 Wine /Strong Beer dba Bunker Indoor Golf Shorewood, MN 55331 Special Sunday Sales The applicant, Edward Boeve /Bunker Indoor Golf, previously ran this business in neighboring city Minnetonka at 14900 Hwy 7 and has recently secured lease space at the Shorewood Shopping Center. The business will cater to golf enthusiasts and serve food and wine /strong beer. The applicant, Edward Boeve /Bunker Indoor Golf, has successfully passed a background investigation performed by the South Lake Minnetonka Police Department, has successfully submitted all the required documentation, met the insurance liability requirements, submitted the required city licensing fee of $2,000 for the Wine /Strong Beer License, and $200 for the Special Sunday Sales and met the preliminary State of Minnesota, Department of Public Safety, Alcohol and Gambling Enforcement requirements as well. Once the city council has approved the license it will be forwarded to the State of Minnesota, Department of Public Safety, Alcohol and Gambling Enforcement department who will perform a premises inspection pursuant to the requirements for obtaining a new liquor license issued in the state. Financial or Budget Considerations: Licensing fees as set forth in the City's fee schedule collected. Recommendation /Action Requested: Staff respectfully recommends the city council approve a new liquor license effective upon the State of Minnesota, Department of Public Safety, Alcohol and Gambling Enforcement approval for a Wine /Strong Beer Liquor License with Special Sunday Sales for Edward Boeve dba Bunker Indoor Golf located at 23720 State Highway 7 in Shorewood. Motion, second, and simple majority vote required. Connection to Vision /Mission: Consistency in providing the community with quality public services and a variety of attractive amenities. Mission Statement: The City of Shorewood is committed to providing residents quality public services, a healthy environment, a variety of attractive amenities, a sustainable tax base, and sound financial management through effective, efficient, and visionary leadership. Page 1 CITY OF SHOREWOOD COUNTY OF HENNEPIN STATE OF MINNESOTA RESOLUTION 17 -XX BUNKER INDOOR GOLF WINE /STRONG BEER AND SPECIAL SUNDAY SALES LIQUOR LICENSE WHEREAS, Shorewood City Code, Chapter 401 provides that no person may directly or indirectly, on any pretense or by any device, sell, barter, keep for sale, charge for possession, or otherwise dispose of alcoholic beverages as part of a commercial transaction without having obtained the required license or permit; and WHEREAS, in addition to the requirements set forth by the Minnesota Department of Public Safety, Alcohol and Gambling Enforcement Division, Shorewood City Code provides that the applicant shall complete an application for a liquor license, pay the required licensing fee, fulfill insurance coverage requirements and complete a successful background investigation; and WHEREAS, Bunker Indoor Golf and owner Edward Boeve has successfully completed the application process, satisfying the requirements as delineated above for the issuance of a wine /strong beer liquor license with special Sunday sales for the City of Shorewood, conditional approval will be granted for the period of one year, effective on the date the Minnesota Department of Public Safety, Alcohol and Gambling Enforcement Division certifies that the applicant has passed the new license inspection and met all criteria for approval by the State agency as well as being consistent with the requirements and provisions of Chapter 401 of the Shorewood City Code. We anticipate this license period to be effective January 1, 2018 to May 31, 2018 at which time the applicant/license holder will be provided a pro -rated rate to coincide with Shorewood's liquor license renewal terms of June V to May 31st of each year. NOW, THEREFORE, BE IT RESOLVED by the City Council of the City of Shorewood, the following license is issued to the applicant as follows is approved: Applicant Address License Edward Boeve 23720 State Highway 7 Wine /Strong Beer dba/Bunker Indoor Golf Shorewood, MN 55331 Special Sunday Sales ADOPTED BY THE CITY COUNCIL of the City of Shorewood this 1 lth day of December 2017. ATTEST: Sandie Thone, City Clerk Scott Zerby, Mayor ••: MEETING TYPE REGULAR City of Shorewood Council Meeting Item Title / Subject: Adoption of the 2018 General Fund Budget and Property Tax Levy Collectible in 2018 Meeting Date: December 11, 2017 Prepared by: Joe Rigdon, Interim Finance Director Reviewed by: Greg Lerud, City Administrator Attachment: Resolution 2018 General Fund Summary Budget Policy Consideration: Adoption of this resolution will allow staff to certify the budget and property tax levy to Hennepin County as required by state law. Background: On September 11, 2017, the City of Shorewood adopted the proposed 2018 General Fund budget of $6,195,632 expenditures and transfers out. At the meeting, the Council changed the proposed property tax levy increase from 2.9% to 4.0% to account for unforeseen expenditures. The city adopted the "2018 Proposed Levy Certification" of $5,388,236, or $56,991 higher than the original proposed levy. At the December 4, 2017 truth in taxation meeting, the Council considered keeping $38,000 of the $56,991 contingency increase approved at the September 11, 2017 meeting within the final 2018 tax levy. The $38,000 amount is intended to assist with Southshore Center improvements. The remaining tax levy contingency increase of $18,991 was suggested to be removed from the 2018 tax levy. Overall proposed 2018 General Fund revised expenditures and transfers out are budgeted at $6,233,632 or a 3.2% increase from the 2017 General Fund budget. Included is an increase to operating expenditures of $133,338, or 2.7 %. Total transfers out are budgeted to increase by $58,982, or 5.3 %. This includes $15,000 increases for both streets and capital equipment, and a $9,018 decrease for the City Hall debt service transfer that resulted from the 2017 bond refinancing. Additionally, the transfer of $38,000 for Southshore Center improvements has been included. General Fund 2018 revised revenues and transfers in are budgeted at $6,059,535, or a 3.6% increase over the 2017 budget. Of the $211,008 increase in revenues and transfers in, $188,249 is proposed to be generated from the property tax levy. To balance the 2018 General Fund budget, a "use of reserves" of $174,097 is proposed. This compares favorably to a budgeted use of General Fund reserves of $192,785 in the 2017 budget. The City's 2018 preliminary revised property tax levy of $5,369,245 is 3.6% higher than the 2017 total levy of $5,180,996. The City is proposing to decrease the payable 2018 City tax rate by 2.7% from 29.450% in 2017 to 28.641% in 2018. In other words, property owners with no change in market values from payable 2017 to payable 2018 should experience a 2.7% decrease in the City portion of their Mission Statement: The City of Shorewood is committed to providing residents quality public services, a healthy environment, a variety of attractive amenities, a sustainable tax base, and sound financial management through effective, efficient, and visionary leadership. Page 1 overall property tax bill. In the event of a market value decrease or increase from payable 2017 to payable 2018, City property taxes would change proportionately. Financial or Budget Considerations: The adoption of this resolution records the City Council's spending priorities for 2018 and the amount of property taxes to be raised. Options: The City Council may choose to: 1. Adopt the General Fund budget and property tax levy as presented at the 3.6% tax levy increase level. 2. Make additional changes to the budget and /or tax levy and adopt the amended budget and levy. Recommendation / Action Requested: Staff recommends that the City Council adopt the resolution as submitted. Next Steps and Timelines: The final tax levy will be applied by Hennepin County to create property tax statements that will be mailed in April, 2018, for collection on May 15 and October 15, 2018. Connection to Vision / Mission: This process contributes to sound financial management by providing financial resources to pay for desired city services. CITY OF SHOREWOOD RESOLUTION NO. 17- A RESOLUTION ADOPTING THE 2018 GENERAL FUND OPERATING BUDGET AND APPROVING THE PROPERTY TAX LEVY COLLECTIBLE IN 2018 WHEREAS, the 2018 Budget and property tax levies collectible in 2018 for the City of Shorewood have been prepared and reviewed by the City Council; and, WHEREAS, the budget has been modified by the City Council to meet service delivery goals; and, WHEREAS, the City Council held a Truth -in- Taxation public meeting on December 4, 2017, to receive public comment regarding the adoption of such budgets and property tax levies; NOW, THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF SHOREWOOD AS FOLLOWS: 1. That a budget of $6,233,632 is adopted to pay for 2018 General Fund operations. 2. That the sum of $5,369,245 is levied for 2017, collectible in 2018, upon taxable property in the City of Shorewood. 3. That the City Administrator is hereby instructed to transmit a certified copy of this resolution to the County Auditor of Hennepin County, Minnesota. ADOPTED BY THE CITY COUNCIL OF THE CITY OF SHOREWOOD this l lth day of December, 2017. ATTEST: Sandie Thone, City Clerk Scott Zerby, Mayor General Fund 2018 Budget Summary YTD Preliminary Budget Percentage Budget Actual Budget Actual Budget 11/27/17 Budget Change Change Account Number 2015 2015 2016 2016 2017 2017 2018 2018 2018 Taxes 4,931,464 4,949,125 5,079,408 5,129,619 5,180,996 2,654,194 5,369,245 188,249 3.6% Licenses & Permits 147,770 275,567 169,180 340,111 239,180 284,819 245,155 5,975 2.5% Intergovernmental 87,251 103,795 90,751 172,806 90,751 89,959 91,250 499 0.5% Charges for Services 42,200 58,709 42,200 51,318 42,200 58,437 53,885 11,685 27.7% Fines & Forfeitures 57,000 65,234 60,000 48,868 60,000 51,401 60,000 0 0.0% Special Assessments 0 0 0 0 0 0 0 0 N/A Miscellaneous 210,400 279,178 210,400 299,374 210,400 185,735 215,000 4,600 2.2% TOTAL REVENUES 5,476,085 5,731,608 5,651,939 6,042,096 5,823,527 3,324,545 6,034,535 211,008 3.6% OTHER FINANCING SOURCES Sales of Capital Assets 0 0 0 0 0 0 0 0 N/A Transfers In 25,000 25,000 25,000 25,000 25,000 25,000 25,000 0 0.0% TOTAL OTHER FINANCING SOURCES 25,000 25,000 25,000 25,000 25,000 25,000 25,000 0 0.0% TOTAL REVENUES AND OTHER FINANCING SOURCES 5,501,085 5,756,608 5,676,939 6,067,096 5,848,527 3,349,545 6,059,535 211,008 3.6% EXPENDITURES GENERAL GOVERNMENT Council 134,950 91,545 158,100 162,138 141,100 65,651 84,100 (57,000) -40.4% Administration 417,553 409,030 477,604 420,783 465,604 399,994 447,024 (18,580) -4.0% Elections 0 0 0 12,409 0 0 21,975 21,975 N/A Finance 160,808 183,517 172,773 181,343 175,173 164,094 172,483 (2,690) -1.5% Professional Services 215,060 200,096 226,400 252,052 236,400 246,811 240,000 3,600 1.5% Planning 184,457 212,952 191,097 195,958 276,247 257,140 190,361 (85,886) -31.1% Municipal Buildings 194,200 149,961 196,100 188,644 201,300 217,573 207,600 6,300 3.1% TOTAL GENERAL GOVERNMENT 1,307,028 1,247,100 1,422,074 1,413,326 1,495,824 1,351,263 1,363,543 (132,281) -8.8% PUBLIC SAFETY Police 1,297,826 1,307,309 1,336,165 1,323,751 1,394,050 1,396,578 1,449,930 55,880 4.0% Fire 637,471 636,800 640,334 639,088 629,624 629,587 625,953 (3,671) -0.6% Protective Inspections 129,223 136,627 134,549 142,259 137,049 147,840 144,263 7,214 5.3% TO TAL PUBLIC SA FE TY 2,064,520 2,080,736 2,111,048 2,105,098 2,160,723 2,174,005 2,220,146 59,423 2.8% General Fund 2018 Budget Summary Account Number STREETS Engineer Public Works Ice and Snow Removal TOTAL STREETS PARKS AND RECREATION Park Maintenance Recreation TOTAL PARKS AND RECREATION TOTAL EXPENDITURES OTHER FINANCING USES Transfers Out TOTAL EXPENDITURES AND OTHER FINANCING USES EXCESS (DEFICIENCY) OF REVENUES AND OTHER SOURCES OVER (UNDER) EXPENDITURES AND OTHER USES YTD Preliminary Budget Percentage Budget Actual Budget Actual Budget 11/27/17 Budget Change Change 2015 2015 2016 2016 2017 2017 2018 2018 2018 87,900 91,100 89,725 100,561 89,725 61,702 89,500 (225) -0.3% 804,847 580,131 810,465 620,286 842,665 535,001 1,019,797 177,132 21.0% 103,339 41,503 105,465 50,928 105,465 41,784 113,931 8,466 8.0% 232,116 255,826 241,997 283,567 241,997 236,302 262,820 20,823 8.6% 996,086 712,734 1,005,655 771,775 1,037,855 638,487 1,223,228 185,373 17.9% 170,773 202,137 178,822 232,111 178,822 188,948 196,932 18,110 10.1% 61,343 53,689 63,175 51,456 63,175 47,354 65,889 2,714 4.3% 232,116 255,826 241,997 283,567 241,997 236,302 262,820 20,823 8.6% 4,599,750 4,296,397 4,780,774 4,573,766 4,936,399 4,400,057 5,069,737 133,338 2.7% 1,043,513 1,043,513 1,076,313 1,387,313 1,104,913 1,804,913 1,163,895 58,982 5.3% 5,643,263 5,339,910 5,857,087 5,961,079 6,041,312 6,204,970 6,233,632 192,320 3.2% (142,178) 416,698 (180,148) 106,017 (192,785) (2,855,425) (174,097) 18,688 -9.7% 2 General Fund 2018 Budget Revenues by Line Item YTD Preliminary Budget Percentage Budget Actual Budget Actual Budget 11/27/17 Budget Change Change Account Number Description 2015 2015 2016 2016 2017 2017 2018 2018 2018 REVENUES I IkR14 & 101 -00- 3010 -0000 CURRENT AD VALOREM TAXES 4,931,464 4,783,936 5,079,408 4,972,519 5,180,996 2,648,984 5,369,245 188,249 3.6% 101 -00- 3011 -0000 DELINQUENT AD VALOREM TAXES 0 38,198 0 30,155 0 0 0 0 N/A 101 -00- 3100 -0000 FISCAL DISPARITIES 0 123,634 0 119,405 0 0 0 0 N/A 101 -00- 3180 -0000 OTHER TAXES 0 0 0 0 0 0 0 0 N/A 101 -00- 3191 -0000 PENALTIES & INT. ON AD VALOREM 0 3,358 0 7,541 0 0 0 0 N/A 101 -00- 3192 -0000 TAX FORFEIT SALE 0 0 0 0 0 5,210 0 0 N/A 101 -00- 3343 -0000 Total Taxes 4,931,464 4,949,125 5,079,408 5,129,619 5,180,996 2,654,194 5,369,245 188,249 3.6% 101 -00- 3344 -0000 PERA AID 4,751 4,751 4,751 4,751 4,751 2,376 4,750 LICENSES & PERMITS 0.0% 101 -00- 3345 -0000 MUNICIPAL STATE AID FOR STREET 70,000 84,206 73,000 88,022 73,000 86,868 101 -00- 3211 -0000 LIQUOR LICENSES 8,820 1,430 1,430 1,430 1,430 3,430 1,430 0 0.0% 101 -00- 3212 -0000 TOBACCO LICENSES 500 1,250 500 1,350 500 1,250 500 0 0.0% 101 -00- 3215 -0000 REFUSE COLLECTION LICENSES 0 1,525 0 1,375 0 150 1,375 1,375 N/A 101 -00- 3216 -0000 TREE TRIMMING LICENSES 500 840 500 790 500 450 500 0 0.0% 101 -00- 3217 -0000 RENTAL HOUSING LICENSES 1,000 0 1,000 0 1,000 0 0 (1,000) - 100.0% 101 -24- 3217 -0000 RENTAL HOUSING LICENSES 0 1,020 0 1,380 0 1,140 2,400 2,400 N/A 101 -00- 3218 -0000 OTHER BUSINESS LICENSES &PEN 3,500 934 3,500 734 3,500 576 750 (2,750) -78.6% 101 -00- 3219 -0000 LAWN FERTILIZER LICENSE 0 210 0 240 0 180 200 200 N/A 101 -00- 3221 -0000 BUILDING PERMITS 110,000 6,742 130,000 17,400 190,000 7,623 190,000 0 0.0% 101 -24- 3221 -0000 BUILDING PERMITS 0 191,422 0 226,476 0 216,708 0 0 N/A 101 -00- 3222 -0000 PLAN CHECK FEES 20,000 0 30,000 0 40,000 0 0 (40,000) - 100.0% 101 -24- 3222 -0000 PLAN CHECK FEES 0 66,151 0 86,516 0 50,506 45,000 45,000 N/A 101 -00- 3223 -0000 DOG LICENSES 3,300 3,643 2,000 2,246 2,000 1,681 2,000 0 0.0% 101 -00- 3224 -0000 FARM ANIMAL PERMIT 100 200 250 50 250 50 0 (250) - 100.0% 101 -00- 3225 -0000 HORSE PERMITS 50 50 0 25 0 25 0 0 N/A 101 -00- 3226 -0000 OTHER NON-BUSINESS LICENSES AN 0 50 0 0 0 0 0 0 N/A 101 -00- 3230 -0000 DOMESTIC PARTNERSHIP REG 0 0 0 0 0 0 0 0 N/A 101 -00- 3235 -0000 SOLICITOR PERMIT 0 100 0 100 0 1,050 1,000 1,000 N/A Total Licenses & Penn its 147,770 275,567 169,180 340,111 239,180 284,819 245,155 5,975 2.5% INTERGOVERNMENTAL 101 -00- 3313 -0000 FEDERAL GRANTS - COMMUNITY DEV 0 0 0 0 0 0 0 0 N/A 101 -00- 3314 -0000 BULLETPROOF VEST GRANT 0 1,590 500 2,011 500 0 0 (500) - 100.0% 101 -21- 3314 -0000 BULLET -PROOF VEST GRANT 0 0 0 0 0 0 0 0 N/A 101 -00- 3316 -0000 FEMA STORM DISASTER AID 0 0 0 1,858 0 715 0 0 N/A 101 -00- 3341 -0000 LOCAL PERFORMANCE AID 1,000 1,040 1,000 1,044 1,000 0 0 (1,000) - 100.0% 101 -00- 3342 -0000 HACA 0 0 0 0 0 0 0 0 N/A 101 -00- 3343 -0000 MKT VALUE CREDIT AID 0 49 0 49 0 0 0 0 N/A 101 -00- 3344 -0000 PERA AID 4,751 4,751 4,751 4,751 4,751 2,376 4,750 (1) 0.0% 101 -00- 3345 -0000 MUNICIPAL STATE AID FOR STREET 70,000 84,206 73,000 88,022 73,000 86,868 75,000 2,000 2.7% 101 -00- 3346 -0000 STATE SNOW /STORM DISASTER AID 0 0 0 0 0 0 0 0 N/A 101 -00- 3347 -0000 MNDOT COOPERATIVE AGREEMENT 0 0 0 0 0 0 0 0 N/A 101 -00- 3362 -0000 MISCGRANTS 11,500 12,159 11,500 75,070 11,500 0 11,500 0 0.0% Total Intergovemmental 87,251 103,795 90,751 172,806 90,751 89,959 91,250 499 0.5% 3 General Fund 2018 Budget Revenues by Line Item Account Number Description Budget 2016 Actual 2016 CHARGES FOR SERVICES 101 -00- 3400 -0000 CHARGES FOR SERVICES 101 -00- 3410 -0000 RENTAL INCOME 101 -00- 3413 -0000 ZONING AND SUBDIVISION FEES 101 -18- 3413 -0000 ZONING & SUBDIVISION FEES 101 -00- 3414 -0000 PASS -THRU CHARGES 101 -00- 3415 -0000 SALE OF COPIES 101 -00- 3417 -0000 SPECIAL ASSESSMENT SEARCHES 101 -00- 3420 -0000 ELECTION FILING FEES 101 -00- 3470 -0000 PARK DEDICATION FEES 101 -00- 3471 -0000 PARK FEES & RENTALS 101 -53- 3471 -0000 PARK FEES & RENTALS 101 -00- 3472 -0000 TREE SALES 101 -00- 3473 -0000 PARK PROGRAM FEES 101 -53- 3473 -0000 PARK PROGRAM FEES 101 -00- 3474 -0000 ARCTIC FEVER DONATIONS 101 -00- 3475 -0000 ARCTIC FEVER TEA PARTY DONATIO 101 -53- 3475 -0000 ARCTIC FEVER TEA PARTY 101 -53- 3476 -0000 COMM GARDEN PLOT RENTAL 101 -53- 3478 -0000 SAFETY CAMP 101 -53- 3479 -0000 MUSIC IN THE PARK 101 -00- 3480 -0000 PROGRAM (CLASS) FEES 101 -53- 3481 -0000 GARDEN FAIR 101 -00- 3482 -0000 Special Event Permit Fees 0 Total Charges for Services FINES & FORFEITURES 101 -00- 3510 -0000 FINES & FORFEITS 101 -00- 3511 -0000 IMPOUND FEES 500 Total Fines & Forfeitures SPECIAL ASSESSMENTS 101 -00- 3610 -0000 SPECIAL ASSESSMENT - CURRENT 101 -00- 3611 -0000 SPECIAL ASSESSMENT - DELINQUENT 101 -00- 3614 -0000 SPECIAL ASSESSMENT - INTEREST MISCELLANEOUS 101 -00- 3620 -0000 101 -00- 3621 -0000 101 -00- 3623 -0000 101 -53- 3623 -0000 101 -00- 3624 -0000 101 -00- 3625 -0000 101 -00- 3626 -0000 101 -00- 3627 -0000 Total Special Assessments Budget 2015 Actual 2015 Budget 2016 Actual 2016 Budget 2017 YTD 11/27/17 2017 Preliminary Budget 2018 Budget Change 2018 Percentage Change 2018 0 0 0 0 4,500 0 0 (4,500) - 100.0% 0 0 0 0 0 0 0 0 N/A 4,500 10,812 4,500 14,645 0 10,475 11,000 11,000 N/A 0 0 0 0 0 0 0 0 N/A 0 2,928 0 (1,280) 0 3,840 0 0 N/A 500 311 500 207 500 208 250 (250) -50.0% 200 200 200 25 200 25 25 (175) -87.5% 0 0 0 6 0 0 10 10 N/A 0 0 0 0 0 0 0 0 N/A 1,500 33,925 1,500 32,650 1,500 38,109 35,000 33,500 2233.3% 0 0 0 0 0 0 0 0 N/A 0 6,957 0 1,925 0 2,557 3,000 3,000 N/A 32,000 0 32,000 0 32,000 0 0 (32,000) - 100.0% 0 0 0 0 0 0 0 0 N/A 3,500 3,250 3,500 3,269 3,500 2,225 3,000 (500) -14.3% 0 0 0 0 0 0 0 0 N/A 0 0 0 0 0 0 0 0 N/A 0 885 0 1,185 0 1,230 1,200 1,200 N/A 0 (501) 0 (489) 0 112 0 0 N/A 0 0 0 (1,045) 0 (800) 0 0 N/A 0 0 0 0 0 0 0 0 N/A 0 (58) 0 (30) 0 (24) 0 0 N/A 0 0 0 250 0 480 400 400 N/A 42,200 58,709 42,200 51,318 42,200 58,437 53,885 11,685 27.7% 57,000 65,084 60,000 48,868 60,000 50,961 60,000 0 0.0% 0 150 0 0 0 440 0 0 N/A 57,000 65,234 60,000 48,868 60,000 51,401 60,000 0 0.0% 0 0 0 0 0 0 0 0 N/A 0 0 0 0 0 0 0 0 N/A 0 0 0 0 0 0 0 0 N/A 0 0 0 0 0 0 0 0 N/A INTEREST EARNINGS 35,000 35,182 35,000 59,413 35,000 73 35,000 0 0.0% GAIN /(LOSS) ON INVESTMENTS 0 0 0 0 0 0 0 0 N/A CONTRIBUTIONS AND DONATIONS 0 300 0 300 0 0 0 0 N/A PARK DONATIONS 0 20 0 250 0 2,000 0 0 N/A REFUNDS & REIMBURSEMENTS 10,000 63,574 10,000 61,591 10,000 14,468 15,000 5,000 50.0% POP MACHINE REVENUE 0 0 0 0 0 0 0 0 N/A DRY HYDRANT CHARGES 0 940 0 263 0 0 0 0 N/A CELLULAR ANTENNA REVENUE 150,000 177,215 150,000 159,121 150,000 162,745 150,000 0 0.0% 4 General Fund 2018 Budget Revenues by Line Item 5 YTD Preliminary Budget Percentage Budget Actual Budget Actual Budget 11/27/17 Budget Change Change Account Number Description 2015 2015 2016 2016 2017 2017 2018 2018 2018 101 -00- 3630 -0000 LEASE REVENUE 0 (787) 0 394 0 0 0 0 N/A 101 -00- 3670 -0000 MISCELLANEOUS REVENUE 15,400 2,734 15,400 18,042 15,400 6,449 15,000 (400) -2.6% Total Miscellaneous 210,400 279,178 210,400 299,374 210,400 185,735 215,000 4,600 2.2% TOTAL REVENUES 5,476,085 5,731,608 5,651,939 6,042,096 5,823,527 3,324,545 6,034,535 211,008 3.6% OTHER FINANCING SOURCES 101 -00- 3910 -0000 SALES OF CAPITAL ASSETS 0 0 0 0 0 0 0 0 N/A 101 -00- 3920 -0000 TRANSFERS IN 25,000 25,000 25,000 25,000 25,000 25,000 25,000 0 0.0% TOTAL OTHER FINANCING SOURCES 25,000 25,000 25,000 25,000 25,000 25,000 25,000 0 0.0% TOTAL REVENUES AND OTHER FINANCING SOURCES 5.501.085 5.756.608 5.676.939 6067.096 5.848527 3349545 6.059.535 211.008 36 5 General Fund 2018 Budget Expenditures by Line Item Account Number Description Budget 2015 Actual 2015 Budget 2016 Actual 2016 Budget 2017 YTD 11/27/17 2017 Preliminary Budget 2018 Budget Change 2018 Percentage Change 2018 EXPENDITURES OTHER SERVICES AND CHARGES 101 -11- 4331 -0000 TRAVEL, CONFERENCE & SCHOOL 101 -11- 4351 -0000 PRINTING AND PUBLISHING 101 DEPT 11 COUNCIL CONTRACTUAL SERVICES 101 -11- 4410 -0000 RENTALS 101 -11- 4433 -0000 DUES AND SUBSCRIPTIONS PERSONAL SERVICES -11- 4440 -0000 MISC SERVICES /CONTINGENCY 43,613 52,000 39,886 Total Other Services and Charges 30,723 52,000 101 -11- 4103 -0000 PART -TIME 21,000 20,600 21,000 20,600 21,000 18,883 21,000 (60,000) 0 0.0% 101 -11- 4121 -0000 PERA CONTRIB - CITY SHARE 0 0 0 0 0 0 0 0 N/A 101 -11- 4122 -0000 FICA CONTRIB - CITY SHARE 1,600 1,576 1,600 1,576 1,600 1,444 1,600 0 0.0% 101 -11- 4151 -0000 WORKERS COMPENSATION 0 0 0 0 0 0 0 0 N/A Total Personal Services 22,600 22,175 22,600 22,175 22,600 20,327 22,600 0 0.0% ANNUMM 101 -11- 4245 -0000 GENERAL SUPPLIES 101 -11- 4302 -0000 CONSULTING FEES 66.7% 0 0 Total Supplies OTHER SERVICES AND CHARGES 101 -11- 4331 -0000 TRAVEL, CONFERENCE & SCHOOL 101 -11- 4351 -0000 PRINTING AND PUBLISHING 101 -11- 4400 -0000 CONTRACTUAL SERVICES 101 -11- 4410 -0000 RENTALS 101 -11- 4433 -0000 DUES AND SUBSCRIPTIONS 101 -11- 4440 -0000 MISC SERVICES /CONTINGENCY 43,613 52,000 39,886 Total Other Services and Charges CAPITAL OUTLAY 101 -11- 4620 -0000 Buildings & Structures Total Council 2,000 1,751 2,000 1,330 2,000 2,147 2,000 0 0.0% 0 0 0 0 0 0 0 0 N/A 2,000 1,751 2,000 1,330 2,000 2,147 2,000 0 0.0% 4,500 11,191 4,500 10,959 4,500 11,644 7,500 3,000 66.7% 0 0 0 0 0 0 0 0 N/A 0 12,814 50,000 87,789 0 810 0 0 N/A 0 0 0 0 0 0 0 0 N/A 49,000 43,613 52,000 39,886 52,000 30,723 52,000 0 0.0% 56,850 0 27,000 0 60,000 0 0 (60,000) - 100.0% 110,350 67,618 133,500 138,633 116,500 43,177 59,500 (57,000) -48.9% 0 0 0 0 0 0 0 0 N/A 134,950 91,545 158,100 162,138 141,100 65,651 84,100 (57,000) -40.4% 6 General Fund 2018 Budget Expenditures by Line Item YTD Preliminary Budget Percentage Budget Actual Budget Actual Budget 11/27/17 Budget Change Change Account Number Description 2015 2015 2016 2016 2017 2017 2018 2018 2018 DEPT 13 ADMINISTRATION 101 -13- 4101 -0000 FULL -TIME REGULAR 187,866 181,408 304,996 185,933 304,996 255,930 281,719 (23,277) -7.6% 101 -13- 4102 -0000 OVERTIME 0 0 0 0 0 0 0 0 N/A 101 -13- 4103 -0000 PART -TIME 12,520 5,258 25,000 8,693 13,000 7,822 13,718 718 5.5% 101 -13- 4107 -0000 ELECTION JUDGE 0 0 0 0 0 0 0 0 N/A 101 -13- 4111 -0000 SEVERANCE PAY 0 0 0 0 0 0 0 0 N/A 101 -13- 4121 -0000 PERA CONTRIB - CITY SHARE 14,450 13,296 22,962 14,147 22,962 19,096 22,158 (804) -3.5% 101 -13- 4122 -0000 FICA CONTRIB - CITY SHARE 15,330 13,693 24,327 18,547 24,327 20,165 22,601 (1,726) -7.1 101 -13- 4131 -0000 EMPLOYEE INSURANCE - CITY 20,987 34,821 36,869 32,684 36,869 42,446 39,915 3,046 8.3% 101 -13- 4141 -0000 UNEMPLOYMENT COMPENSATION 0 0 0 0 0 0 0 0 N/A 101 -13- 4151 -0000 WORKERS COMPENSATION 0 763 0 2,427 0 2,080 2,363 2,363 N/A Total Personal Services 251,153 249,239 414,154 262,431 402,154 347,539 382,474 (19,680) -4.9% ANNUMeW 101 -13- 4200 -0000 OFFICE SUPPLIES 5,000 2,134 5,000 5,065 5,000 3,834 5,000 0 0.0% 101 -13- 4208 -0000 POSTAGE 11,000 7,901 11,000 9,469 11,000 11,755 11,000 0 0.0% 101 -13- 4221 -0000 MAINTENANCE OF EQUIPMENT 4,000 2,785 4,000 965 4,000 1,011 4,000 0 0.0% 101 -13- 4245 -0000 GENERAL SUPPLIES 900 468 900 1,799 900 383 1,000 100 11.1% Total Supplies 20,900 13,288 20,900 17,298 20,900 16,983 21,000 100 0.5% OTHER SERVICES AND CHARGES 101 -13- 4321 -0000 COMMUNICATIONS - VOICE/DATA 0 0 900 0 900 360 0 (900) - 100.0% 101 -13- 4331 -0000 TRAVEL, CONFERENCE & SCHOOL 6,500 4,195 7,000 4,056 7,000 3,594 7,800 800 11.4% 101 -13- 4351 -0000 PRINTING AND PUBLISHING 1,500 1,319 2,000 4,128 2,000 3,124 3,000 1,000 50.0% 101 -13- 4400 -0000 CONTRACTUAL SERVICES 137,000 140,551 32,000 132,380 32,000 26,781 32,000 0 0.0% 101 -13- 4433 -0000 DUES AND SUBSCRIPTIONS 500 439 650 490 650 1,613 750 100 15.4% 101 -13- 4440 -0000 MISC SERVICES /CONTINGENCY 0 0 0 0 0 0 0 0 N/A Total Other Services and Charges 145,500 146,503 42,550 141,053 42,550 35,472 43,550 1,000 2.4% Total Administration 417,553 409,030 477,604 420,783 465,604 399,994 447,024 (18,580) -4.0% 7 General Fund 2018 Budget Expenditures by Line Item YTD Preliminary Budget Percentage Budget Actual Budget Actual Budget 11/27/17 Budget Change Change Account Number Description 2015 2015 2016 2016 2017 2017 2018 2018 2018 DEPT 14 ELECTIONS PERSONAL SERVICES 101 -14- 4107 -0000 ELECTION JUDGE 0 0 0 12,409 0 0 14,700 14,700 N/A Total Personal Services 0 0 0 12,409 0 0 14,700 14,700 N/A SUPPLIES 0 0 101 -14- 4200 -0000 OFFICE SUPPLIES 101 -14- 4221 -0000 MAINTENANCE OF EQUIPMENT 101 -14- 4245 -0000 GENERAL SUPPLIES 0 0 Total Supplies OTHER SERVICES AND CHARGES 101 -14- 4351 -0000 PRINTING AND PUBLISHING 101 -14- 4440 -0000 MISC SERVICES /CONTINGENCY 0 1,410 Total Other Services and Charges N/A Total Elections 0 0 0 0 0 0 790 790 N/A 0 0 0 0 0 0 1,900 1,900 N/A 0 0 0 0 0 0 1,410 1,410 N/A 0 0 0 0 0 0 4,100 4,100 N/A 0 N/A 2,500 2,500 N/A 0 0 0 0 0 0 675 675 N/A 0 0 0 0 0 0 3,175 3,175 N/A 0 0 0 12,409 0 0 21,975 21,975 N/A 8 General Fund 2018 Budget Expenditures by Line Item YTD Preliminary Budget Percentage Budget Actual Budget Actual Budget 11/27/17 Budget Change Change Account Number Description 2015 2015 2016 2016 2017 2017 2018 2018 2018 DEPT 15 FINANCE 101 -15- 4101 -0000 FULL -TIME REGULAR 107,669 112,461 112,021 114,756 112,021 73,461 49,344 (62,677) -56.0% 101 -15- 4102 -0000 OVERTIME 0 0 0 0 0 0 0 0 N/A 101 -15- 4103 -0000 PART -TIME 0 0 0 0 0 0 0 0 N/A 101 -15- 4106 -0000 OTHER 0 0 0 0 0 0 0 0 N/A 101 -15- 4111 -0000 SEVERANCE PAY 0 0 0 0 0 0 0 0 N/A 101 -15- 4121 -0000 PERA CONTRIB - CITY SHARE 7,806 8,400 8,122 8,738 8,122 5,210 3,701 (4,421) -54.4% 101 -15- 4122 -0000 FICA CONTRIB - CITY SHARE 8,237 8,078 8,570 8,364 8,570 5,425 3,775 (4,795) -56.0% 101 -15- 4131 -0000 EMPLOYEE INSURANCE - CITY 11,046 13,817 13,560 13,760 13,560 8,787 5,768 (7,792) -57.5% 101 -15- 4141 -0000 UNEMPLOYMENT COMPENSATION 0 0 0 0 0 5,342 0 0 N/A 101 -15- 4151 -0000 WORKERS COMPENSATION 0 492 0 780 0 415 395 395 N/A Total Personal Services 134,758 143,248 142,273 146,398 142,273 98,640 62,983 (79,290) -55.7% SUPPLIES 101 -15- 4200 -0000 OFFICE SUPPLIES 250 872 600 1,283 600 198 600 0 0.0% 101 -15- 4221 -0000 MAINTENANCE OF EQUIPMENT 9,500 18,381 14,000 13,697 15,000 7,362 15,000 0 0.0% 101 -15- 4245 -0000 GENERAL SUPPLIES 300 0 0 0 0 0 0 0 N/A Total Supplies 10,050 19,253 14,600 14,980 15,600 7,560 15,600 0 0.0% OTHER SERVICES AND CHARGES 101 -15- 4301 -0000 AUDITING & ACCOUNTING 3,600 10,520 3,600 11,175 5,000 0 0 (5,000) - 100.0% 101 -15- 4331 -0000 TRAVEL, CONFERENCE & SCHOOL 4,000 1,706 4,000 1,758 4,000 1,068 2,000 (2,000) -50.0% 101 -15- 4351 -0000 PRINTING AND PUBLISHING 900 0 900 109 900 (109) 1,000 100 11.1 101 -15- 4360 -0000 INSURANCE 0 0 0 0 0 0 0 0 N/A 101 -15- 4400 -0000 CONTRACTUAL SERVICES 1,000 798 1,000 0 1,000 51,366 84,000 83,000 8300.0% 101 -15- 4433 -0000 DUES AND SUBSCRIPTIONS 500 280 400 220 400 50 400 0 0.0% 101 -15- 4440 -0000 MISC SERVICES /CONTINGENCY 0 0 0 0 0 0 0 0 N/A 101 -15- 4450 -0000 BANK SERVICE CHARGES 6,000 7,714 6,000 6,703 6,000 5,519 6,500 500 8.3% Total Other Services and Charges 16,000 21,017 15,900 19,965 17,300 57,894 93,900 76,600 442.8% Total Finance 160,808 183,517 172,773 181,343 175,173 164,094 172,483 (2,690) -1.5% 9 General Fund 2018 Budget Expenditures by Line Item 10 YTD Preliminary Budget Percentage Budget Actual Budget Actual Budget 11/27/17 Budget Change Change Account Number Description 2015 2015 2016 2016 2017 2017 2018 2018 2018 DEPT 16 PROFESSIONAL SERVICES SUPPLIES 101 -16- 4200 -0000 OFFICE SUPPLIES 0 0 0 0 0 0 0 0 N/A OTHER SERVICES AND CHARGES 101 -16- 4301 -0000 AUDITING & ACCOUNTING 26,660 21,700 27,000 31,769 28,000 29,547 30,000 2,000 7.1% 101 -16- 4303 -0000 ENGINEERING FEES 0 0 0 0 0 0 0 0 N/A 101 -16- 4304 -0000 LEGAL FEES 78,400 65,623 82,400 102,206 86,400 95,264 90,000 3,600 4.2% 101 -16- 4400 -0000 CONTRACTUAL SERVICES 110,000 112,773 117,000 118,077 122,000 122,000 120,000 (2,000) -1.6% 101 -16- 4440 -0000 NIISC SERVICES /CONTINGENCY 0 0 0 0 0 0 0 0 N/A Total Other Services and Charges 215,060 200,096 226,400 252,052 236,400 246,811 240,000 3,600 1.5% Total Professional Services 215,060 200,096 226,400 252,052 236,400 246,811 240,000 3,600 1.5% 10 General Fund 2018 Budget Expenditures by Line Item YTD Preliminary Budget Percentage Budget Actual Budget Actual Budget 11/27/17 Budget Change Change Account Number Description 2015 2015 2016 2016 2017 2017 2018 2018 2018 DEPT 18 PLANNING 101 -18- 4101 -0000 FULL -TIME REGULAR 135,193 138,835 139,240 137,309 139,240 167,700 143,665 4,425 3.2% 101 -18- 4102 -0000 OVERTIME 0 0 0 0 0 0 0 0 N/A 101 -18- 4103 -0000 PART -TIME 0 0 0 0 0 0 0 0 N/A 101 -18- 4106 -0000 OTHER 0 0 0 0 0 0 0 0 N/A 101 -18- 4111 -0000 SEVERANCE PAY 0 0 0 0 0 0 0 0 N/A 101 -18- 4121 -0000 PERA CONTRIB - CITY SHARE 9,802 10,355 10,095 10,493 10,095 8,094 10,775 680 6.7% 101 -18- 4122 -0000 FICA CONTRIB - CITY SHARE 10,342 10,314 10,652 10,557 10,652 12,840 10,990 338 3.2% 101 -18- 4131 -0000 EMPLOYEE INSURANCE - CITY 17,820 24,154 18,810 24,177 18,810 18,884 11,136 (7,674) -40.8% 101 -18- 4141 -0000 UNEMPLOYMENT COMPENSATION 0 0 0 0 0 0 0 0 N/A 101 -18- 4151 -0000 WORKERS COMPENSATION 0 747 0 1,081 0 807 945 945 N/A Total Personal Services 173,157 184,405 178,797 183,617 178,797 208,325 177,511 (1,286) -0.7% AwwwNeW 101 -18- 4200 -0000 OFFICE SUPPLIES 101 -18- 4208 -0000 POSTAGE 101 -18- 4221 -0000 MAINTENANCE OF EQUIPMENT 101 -18- 4245 -0000 GENERAL SUPPLIES Total Supplies OTHER SERVICES AND CHARGES 0 0 0 0 0 0 0 0 N/A 0 0 0 7 0 30 0 0 N/A 0 400 0 400 0 400 0 0 N/A 300 23 300 0 450 19 450 0 0.0% 300 423 300 407 450 449 450 0 0.0% 101 -18- 4304 -0000 LEGAL FEES 0 13,863 0 1,779 0 5,693 0 0 N/A 101 -18- 4321 -0000 COMMUNICATIONS - VOICE/DATA 1,000 666 1,000 625 1,000 489 1,000 0 0.0% 101 -18- 4331 -0000 TRAVEL, CONFERENCE & SCHOOL 4,200 1,803 4,200 3,207 4,200 937 4,200 0 0.0% 101 -18- 4351 -0000 PRINTING AND PUBLISHING 1,100 1,624 1,200 2,189 1,200 2,673 2,000 800 66.7% 101 -18- 4400 -0000 CONTRACTUAL SERVICES 3,500 9,536 4,400 3,466 89,400 37,692 4,000 (85,400) -95.5% 101 -18- 4433 -0000 DUES AND SUBSCRIPTIONS 1,200 633 1,200 668 1,200 724 1,200 0 0.0% 101 -18- 4440 -0000 MISC SERVICES /CONTINGENCY 0 0 0 0 0 158 0 0 N/A Total Other Services and Charges 11,000 28,124 12,000 11,934 97,000 48,366 12,400 (84,600) -87.2% Total Planning 184,457 212,952 191,097 195,958 276,247 257,140 190,361 (85,886) -31.1% General Fund 2018 Budget Expenditures by Line Item 101 -19- 4302 -0000 CONSULTING FEES 0 0 0 0 0 YTD Preliminary Budget Percentage 101 -19- 4304 -0000 LEGAL FEES Budget Actual Budget Actual Budget 11/27/17 Budget Change Change Account Number Description 2015 2015 2016 2016 2017 2017 2018 2018 2018 101 -19- 4331 -0000 TRAVEL, CONFERENCE & SCHOOL 0 0 0 0 0 0 0 0 N/A DEPT 19 MUNICIPAL BUILDINGS 113,000 71,404 116,000 83,340 116,000 144,378 116,000 0 0.0% SUPPLIES INSURANCE DEDUCTIBLE 0 2,500 0 0 0 0 0 0 N/A 101 -19- 4221 -0000 MAINTENANCE OF EQUIPMENT 11,400 48,474 9,000 28,171 9,000 7,305 10,000 1,000 11.1% 101 -19- 4223 -0000 MAINTENANCE OF BUILDINGS 10,000 4,558 10,300 3,518 10,300 2,210 10,000 (300) -2.9% 101 -19- 4245 -0000 GENERAL SUPPLIES 2,000 1,559 2,000 2,161 2,000 1,671 2,000 0 0.0% 101 -19- 4433 -0000 DUES AND SUBSCRIPTIONS 0 354 0 534 0 172 500 500 Total Supplies 23,400 54,592 21,300 33,850 21,300 11,186 22,000 700 3.3% 0 N/A 101 -19- 4440 -0000 MISC SERVICES /CONTINGENCY 0 113 0 0 0 OTHER SERVICES AND CHARGES 0 N/A 101 -19- 4701 -0000 BOND PRINCIPAL 0 0 0 0 101 -19- 4302 -0000 CONSULTING FEES 0 0 0 0 0 0 0 0 N/A 101 -19- 4304 -0000 LEGAL FEES 0 0 0 0 0 0 0 0 N/A 101 -19- 4321 -0000 COMMUNICATIONS - VOICE/DATA 36,000 3,670 38,000 42,402 42,000 41,542 44,000 2,000 4.8% 101 -19- 4331 -0000 TRAVEL, CONFERENCE & SCHOOL 0 0 0 0 0 0 0 0 N/A 101 -19- 4360 -0000 INSURANCE 113,000 71,404 116,000 83,340 116,000 144,378 116,000 0 0.0% 101 -19- 4361 -0000 INSURANCE DEDUCTIBLE 0 2,500 0 0 0 0 0 0 N/A 101 -19- 4380 -0000 UTILITY SERVICES 11,000 7,045 10,000 14,888 10,000 5,900 11,000 1,000 10.0% 101 -19- 4400 -0000 CONTRACTUAL SERVICES 9,800 9,403 9,800 13,039 11,000 13,585 13,100 2,100 19.1% 101 -19- 4410 -0000 RENTALS 1,000 881 1,000 591 1,000 788 1,000 0 0.0% 101 -19- 4433 -0000 DUES AND SUBSCRIPTIONS 0 354 0 534 0 172 500 500 N/A 101 -19- 4437 -0000 TAXES/LICENSES 0 0 0 0 0 0 0 N/A 101 -19- 4440 -0000 MISC SERVICES /CONTINGENCY 0 113 0 0 0 22 0 N/A 101 -19- 4701 -0000 BOND PRINCIPAL 0 0 0 0 0 0 0 N/A 101 -19- 4711 -0000 BOND INTEREST 0 0 0 0 0 0 0 N/A Total Other Services and Charges 170,800 95,369 174,800 154,794 180,000 206,387 185,600 5,600 3.1 Total Municipal Buildings 194,200 149,961 196,100 188,644 201,300 217,573 207,600 6,300 3.1 TOTAL GENERAL GOVERNMENT 1,307,028 1,247,100 1,422,074 1,413,326 1,495,824 1,351,263 1,363,543 (132,281) -8.8% 12 General Fund 2018 Budget Expenditures by Line Item Account Number Description Budget 2015 Actual Budget 2015 2016 Actual 2016 Budget 2017 YTD Preliminary 11/27/17 Budget 2017 2018 Budget Change 2018 Percentage Change 2018 DEPT 21 POLICE FISCAL AGENT FEES 0 Total Other Services and Charges 500 0 0 N/A SUPPLIES 0 0 0 0 0 0 0 N/A 101 -21- 4212 -0000 MOTOR FUELS & LUBRICANTS 0 0 0 0 0 0 0 0 N/A 101 -21- 4221 -0000 MAINTENANCE OF EQUIPMENT 0 0 0 0 0 0 0 0 N/A 101 -21- 4245 -0000 GENERAL SUPPLIES 0 0 0 3,601 0 0 0 0 N/A Total Supplies 0 0 0 1601 0 0 0 0 N/A OTHER SERVICES AND CHARGES 101 -21- 4304 -0000 LEGAL FEES 101 -21- 4360 -0000 INSURANCE 101 -21- 4380 -0000 UTILITY SERVICES 101 -21- 4400 -0000 CONTRACTUAL SERVICES 101 -21- 4440 -0000 MISC SERVICES /CONTINGENCY 101 -21- 4720 -0000 FISCAL AGENT FEES 0 Total Other Services and Charges CAPITAL OUTLAY 101 -21- 4620 -0000 BUILDINGS & STRUCTURES Total Police 0 0 0 0 0 0 0 0 N/A 0 0 0 0 0 500 0 0 N/A 0 0 0 0 0 0 0 0 N/A 1,070,145 1,079,556 1,103,665 1,105,804 1,177,550 1,179,544 1,234,633 57,083 4.8% 2,500 2,573 2,500 3,616 2,500 2,727 2,500 0 0.0% 0 0 0 0 0 0 0 0 N/A 1,072,645 1,082,129 1,106,165 1,109,419 1,180,050 1,182,771 1,237,133 57,083 4.8% 225,181 225,180 230,000 214,332 214,000 213,807 212,797 (1,203) -0.6% 1,297,826 1,307,309 1,336,165 1,323,751 1,394,050 1,396,578 1,449,930 55,880 4.0% 13 General Fund 2018 Budget Expenditures by Line Item CAPITAL OUTLAY 101 -22- 4620 -0000 BUILDINGS & STRUCTURES Total Fire 276,156 276,156 270,620 270,620 256,648 256,648 271,955 15,307 6.0% 637,471 636,800 640,334 639,088 629,624 629,587 625,953 (3,671) -0.6% 14 YTD Preliminary Budget Percentage Budget Actual Budget Actual Budget 11/27/17 Budget Change Change Account Number Description 2015 2015 2016 2016 2017 2017 2018 2018 2018 DEPT 22 FIRE OTHER SERVICES AND CHARGES 101 -22- 4400 -0000 CONTRACTUAL SERVICES 361,315 360,644 369,714 368,468 372,976 372,939 353,998 (18,978) -5.1% 101 -22- 4440 -0000 NIISC SERVICES /CONTINGENCY 0 0 0 0 0 0 0 0 N/A Total Other Services and Charges 361,315 360,644 369,714 368,468 372,976 372,939 353,998 (18,978) -5.1 CAPITAL OUTLAY 101 -22- 4620 -0000 BUILDINGS & STRUCTURES Total Fire 276,156 276,156 270,620 270,620 256,648 256,648 271,955 15,307 6.0% 637,471 636,800 640,334 639,088 629,624 629,587 625,953 (3,671) -0.6% 14 General Fund 2018 Budget Expenditures by Line Item YTD Preliminary Budget Percentage Budget Actual Budget Actual Budget 11/27/17 Budget Change Change Account Number Description 2015 2015 2016 2016 2017 2017 2018 2018 2018 DEPT 24 PROTECTIVE INSPECTIONS 101 -24- 4101 -0000 FULL -TIME REGULAR 93,902 99,993 97,519 106,568 97,519 100,397 98,015 496 0.5% 101 -24- 4102 -0000 OVERTIME 0 0 0 0 0 0 0 0 N/A 101 -24- 4103 -0000 PART -TIME 0 0 0 0 0 0 0 0 N/A 101 -24- 4106 -0000 OTHER 0 0 0 0 0 0 0 0 N/A 101 -24- 4111 -0000 SEVERANCE PAY 0 0 0 0 0 0 0 0 N/A 101 -24- 4121 -0000 PERA CONTRIB - CITY SHARE 6,808 7,462 7,070 8,109 7,070 7,487 7,351 281 4.0% 101 -24- 4122 -0000 FICA CONTRIB - CITY SHARE 7,183 6,390 7,460 6,936 7,460 6,488 7,498 38 0.5% 101 -24- 4131 -0000 EMPLOYEE INSURANCE - CITY 13,430 12,157 14,250 12,000 14,250 11,330 14,365 115 0.8% 101 -24- 4141 -0000 UNEMPLOYMENT COMPENSATION 0 0 0 0 0 0 0 0 N/A 101 -24- 4151 -0000 WORKERS COMPENSATION 0 665 0 898 0 640 584 584 N/A Total Personal Services 121,323 126,666 126,299 134,511 126,299 126,342 127,813 1,514 1.2% AwwwNeW 101 -24- 4200 -0000 OFFICE SUPPLIES 0 73 0 245 0 0 0 0 N/A 101 -24- 4212 -0000 MOTOR FUELS & LUBRICANTS 0 0 0 0 0 0 0 0 N/A 101 -24- 4221 -0000 MAINTENANCE OF EQUIPMENT 0 0 0 0 0 0 0 0 N/A 101 -24- 4240 -0000 SMALL TOOLS/IvIINOREQUIPMENT 0 0 0 0 0 0 0 0 N/A 101 -24- 4245 -0000 GENERAL SUPPLIES 200 0 200 0 200 0 0 (200) - 100.0% Total Supplies 200 73 200 245 200 0 0 (200) - 100.0% OTHER SERVICES AND CHARGES 101 -24- 4304 -0000 LEGAL FEES 0 0 0 389 0 0 0 0 N/A 101 -24- 4321 -0000 COMMUNICATIONS - VOICE/DATA 400 0 400 0 400 0 0 (400) - 100.0% 101 -24- 4331 -0000 TRAVEL, CONFERENCE & SCHOOL 3,500 3,722 3,800 3,544 3,800 2,273 3,800 0 0.0% 101 -24- 4351 -0000 PRINTING AND PUBLISHING 150 210 200 146 200 330 500 300 150.0% 101 -24- 4400 -0000 CONTRACTUAL SERVICES 3,500 5,740 3,500 3,290 6,000 18,760 12,000 6,000 100.0% 101 -24- 4433 -0000 DUES AND SUBSCRIPTIONS 150 215 150 135 150 135 150 0 0.0% 101 -24- 4440 -0000 MISC SERVICES /CONTINGENCY 0 0 0 0 0 0 0 0 N/A Total Other Services and Charges 7,700 9,888 8,050 7,503 10,550 21,498 16,450 5,900 55.9% Total Protective Inspections 129,223 136,627 134,549 142,259 137,049 147,840 144,263 7,214 5.3% TOTAL PUBLIC SAFETY 2,064,520 2,080,736 2,111,048 2,105,098 2,160,723 2,174,005 2,220,146 59,423 2.8% 15 General Fund 2018 Budget Expenditures by Line Item 16 YTD Preliminary Budget Percentage Budget Actual Budget Actual Budget 11/27/17 Budget Change Change Account Number Description 2015 2015 2016 2016 2017 2017 2018 2018 2018 DEPT 31 CITY ENGINEER OTHER SERVICES AND CHARGES 101 -31- 4303 -0000 ENGINEERING FEES 37,500 43,100 38,625 52,161 38,625 25,047 40,000 1,375 3.6% 101 -31- 4321 -0000 CONINIONICATIONS - VOICE/DATA 0 0 0 0 0 0 0 0 N/A 101 -31- 4331 -0000 TRAVEL, CONFERENCE & SCHOOL 0 0 0 0 0 0 0 0 N/A 101 -31- 4351 -0000 PRINTING AND PUBLISHING 300 0 0 0 0 0 0 0 N/A 101 -31- 4400 -0000 CONTRACTUAL SERVICES 48,000 48,000 49,500 48,400 49,500 36,247 49,500 0 0.0% 101 -31- 4410 -0000 RENTALS 0 0 0 0 0 0 0 0 N/A 101 -31- 4433 -0000 DUES AND SUBSCRIPTIONS 2,100 0 1,600 0 1,600 408 0 (1,600) - 100.0% 101 -31- 4437 -0000 TAXES/LICENSES 0 0 0 0 0 0 0 0 N/A Total Other Services and Charges 87,900 91,100 89,725 100,561 89,725 61,702 89,500 (225) -0.3% Total City Engineer 87,900 91,100 89,725 100,561 89,725 61,702 89,500 (225) -0.3% 16 General Fund 2018 Budget Expenditures by Line Item YTD Preliminary Budget Percentage Budget Actual Budget Actual Budget 11/27/17 Budget Change Change Account Number Description 2015 2015 2016 2016 2017 2017 2018 2018 2018 DEPT 32 PUBLIC WORKS 101 -32- 4101 -0000 FULL -TIME REGULAR 334,078 262,855 349,720 233,844 349,720 223,267 438,584 88,864 25.4% 101 -32- 4102 -0000 OVERTIME 2,500 2,040 2,500 2,580 2,500 5,223 2,500 0 0.0% 101 -32- 4103 -0000 PART -TIME 40,000 0 40,000 0 40,000 0 0 (40,000) - 100.0% 101 -32- 4104 -0000 TEMPORARY REGULAR 0 0 0 0 0 0 0 0 N/A 101 -32- 4105 -0000 STREET PAGER PAY 0 8,169 7,000 8,936 7,000 6,668 9,000 2,000 28.6% 101 -32- 4106 -0000 OTHER 0 0 0 0 0 0 0 0 N/A 101 -32- 4111 -0000 SEVERANCE PAY 0 0 0 0 0 0 0 0 N/A 101 -32- 4121 -0000 PERA CONTRIB - CITY SHARE 27,302 20,408 28,255 18,672 28,255 17,601 33,082 4,827 17.1% 101 -32- 4122 -0000 FICA CONTRIB - CITY SHARE 28,808 19,467 30,540 18,332 30,540 17,344 33,743 3,203 10.5% 101 -32- 4131 -0000 EMPLOYEE INSURANCE - CITY 61,859 45,236 58,350 45,260 58,350 43,336 80,240 21,890 37.5% 101 -32- 4141 -0000 UNEMPLOYMENT COMPENSATION 0 0 0 0 0 0 0 0 N/A 101 -32- 4151 -0000 WORKERS COMPENSATION 0 15,018 0 15,263 0 11,605 25,848 25,848 N/A Total Personal Services 494,547 373,193 516,365 342,887 516,365 325,044 622,997 106,632 20.7% SUPPLIES 101 -32- 4200 -0000 OFFICE SUPPLIES 200 633 300 235 500 26 400 (100) -20.0% 101 -32- 4208 -0000 POSTAGE 0 0 0 0 0 94 0 0 N/A 101 -32- 4212 -0000 MOTOR FUELS & LUBRICANTS 51,000 26,634 51,000 23,109 48,000 16,816 40,000 (8,000) -16.7% 101 -32- 4221 -0000 MAINTENANCE OF EQUIPMENT 18,000 10,020 17,000 35,206 17,000 10,166 20,000 3,000 17.6% 101 -32- 4223 -0000 MAINTENANCE OF BUILDINGS 7,000 2,117 3,500 1,108 3,500 2,215 3,500 0 0.0% 101 -32- 4240 -0000 SMALL TOOLS/NIINOREQUIPMENT 1,500 713 1,200 116 1,200 1,767 1,600 400 33.3% 101 -32- 4245 -0000 GENERAL SUPPLIES 90,000 11,453 90,000 15,314 90,000 8,288 16,000 (74,000) -82.2% 101 -32- 4250 -0000 ROAD MAINT MATERIALS 0 52,312 0 68,047 0 41,871 75,000 75,000 N/A Total Supplies 167,700 103,881 163,000 143,135 160,200 81,243 156,500 (3,700) -2.3% OTHER SERVICES AND CHARGES 101 -32- 4303 -0000 ENGINEERING FEES 0 2,525 0 0 0 2,695 0 0 N/A 101 -32- 4305 -0000 DRUG TESTING 1,800 50 1,800 152 1,800 725 2,350 550 30.6% 101 -32- 4321 -0000 COMMUNICATIONS - VOICE/DATA 2,700 2,570 2,700 2,899 2,700 4,533 3,350 650 24.1 101 -32- 4331 -0000 TRAVEL, CONFERENCE & SCHOOL 6,500 150 6,500 2,256 6,500 8,382 6,500 0 0.0% 101 -32- 4351 -0000 PRINTING AND PUBLISHING 0 0 0 0 0 0 0 0 N/A 101 -32- 4380 -0000 UTILITY SERVICES 16,000 10,086 15,000 8,991 15,000 6,612 14,000 (1,000) -6.7% 101 -32- 4399 -0000 UTILITIES - STREET LIGHTS 44,000 40,180 43,000 38,340 43,000 37,495 42,000 (1,000) -2.3% 101 -32- 4400 -0000 CONTRACTUAL SERVICES 64,000 44,116 55,000 78,652 90,000 65,307 165,000 75,000 83.3% 101 -32- 4410 -0000 RENTALS 1,000 825 1,500 400 1,500 32 1,500 0 0.0% 101 -32- 4433 -0000 DUES AND SUBSCRIPTIONS 1,700 1,675 1,700 1,578 1,700 2,083 1,700 0 0.0% 101 -32- 4437 -0000 TAXES/LICENSES 900 534 900 975 900 850 900 0 0.0% 101 -32- 4440 -0000 MISC SERVICES /CONTINGENCY 4,000 347 3,000 22 3,000 0 3,000 0 0.0% 101 -32- 4499 -0000 FEMA ELIGLIBLE EXPENSES 0 0 0 0 0 0 0 0 N/A Total Other Services and Charges 142,600 103,057 131,100 134,265 166,100 128,714 240,300 74,200 44.7% Total Public Works 804,847 580,131 810,465 620,286 842,665 535,001 1,019,797 177,132 21.0% 17 General Fund 2018 Budget Expenditures by Line Item Account Number Description Budget 2015 Actual 2015 Budget 2016 Actual 2016 Budget 2017 YTD 11/27/17 2017 Preliminary Budget 2018 Budget Change 2018 Percentage Change 2018 DEPT 33 ICE AND SNOW REMOVAL PERSONAL SERVICES 101 -33- 4101 -0000 FULL -TIME REGULAR 37,455 17,265 39,805 18,208 39,805 11,180 46,439 6,634 16.7% 101 -33- 4102 -0000 OVERTIME 7,500 3,721 7,500 4,914 7,500 1,594 7,500 0 0.0% 101 -33- 4103 -0000 PART -TIME 0 0 0 0 0 0 0 0 N/A 101 -33- 4106 -0000 OTHER 0 0 0 0 0 0 0 0 N/A 101 -33- 4111 -0000 SEVERANCE PAY 0 0 0 0 0 0 0 0 N/A 101 -33- 4121 -0000 PERA CONTRIB - CITY SHARE 3,259 1,424 3,311 1,950 3,311 958 4,046 735 22.2% 101 -33- 4122 -0000 FICACONTRIB - CITYSHARE 3,439 1,145 3,619 1,615 3,619 782 4,127 508 14.0% 101 -33- 4131 -0000 EMPLOYEE INSURANCE - CITY 6,686 0 7,230 0 7,230 0 9,204 1,974 27.3% 101 -33- 4141 -0000 UNEMPLOYMENT COMPENSATION 0 0 0 0 0 0 0 0 N/A 101 -33- 4151 -0000 WORKERS COMPENSATION 0 1,719 0 1,234 0 509 2,616 2,616 N/A Total Personal Services 58,339 25,274 61,465 27,920 61,465 15,023 73,931 12,466 20.3% SUPPLIES 101 -33- 4245 -0000 GENERAL SUPPLIES 45,000 16,229 44,000 23,008 44,000 26,761 40,000 (4,000) -9.1% OTHER SERVICES AND CHARGES 101 -33- 4331 -0000 TRAVEL, CONFERENCE & SCHOOL 0 0 0 0 0 0 0 0 N/A Total Ice and Snow Removal 103,339 41,503 105,465 50,928 105,465 41,784 113,931 8,466 8.0% TOTAL STREETS 996,086 712,734 1,005,655 771,775 1,037,855 638,487 1,223,228 185,373 17.9% 18 General Fund 2018 Budget Expenditures by Line Item YTD Preliminary Budget Percentage Budget Actual Budget Actual Budget 11/27/17 Budget Change Change Account Number Description 2015 2015 2016 2016 2017 2017 2018 2018 2018 DEPT 52 PARK MAINTENANCE 101 -52- 4101 -0000 FULL -TIME REGULAR 69,784 98,959 74,119 104,960 74,119 102,068 79,599 5,480 7.4% 101 -52- 4102 -0000 OVERTIME 2,500 0 2,500 0 2,500 0 2,500 0 0.0% 101 -52- 4103 -0000 PART -TIME 12,000 8,179 12,000 6,199 12,000 0 12,000 0 0.0% 101 -52- 4104 -0000 TEMPORARY REGULAR 0 0 0 0 0 0 0 0 N/A 101 -52- 4106 -0000 OTHER 0 0 0 0 0 0 0 0 N/A 101 -52- 4111 -0000 SEVERANCE PAY 0 0 0 0 0 0 0 0 N/A 101 -52- 4121 -0000 PERA CONTRIB - CITY SHARE 5,241 7,471 5,374 8,324 5,374 7,655 6,158 784 14.6% 101 -52- 4122 -0000 FICA CONTRIB - CITY SHARE 6,448 8,044 6,779 8,449 6,779 8,222 7,198 419 6.2% 101 -52- 4131 -0000 EMPLOYEE INSURANCE - CITY 13,500 21,474 14,250 21,601 14,250 24,963 16,200 1,950 13.7% 101 -52- 4141 -0000 UNEMPLOYMENT COMPENSATION 0 0 0 0 0 0 0 0 N/A 101 -52- 4151 -0000 WORKERS COMPENSATION 0 4,611 0 6,023 0 4,682 4,777 4,777 N/A Total Personal Services 109,473 148,737 115,022 155,556 115,022 147,590 128,432 13,410 11.7% SUPPLIES 101 -52- 4208 -0000 POSTAGE 0 0 0 19 0 0 0 0 N/A 101 -52- 4221 -0000 MAINTENANCE OF EQUIPMENT 6,000 0 6,000 18,971 6,000 844 6,000 0 0.0% 101 -52- 4223 -0000 MAINTENANCE OF BUILDINGS 7,000 2,530 7,000 3,457 7,000 0 7,000 0 0.0% 101 -52- 4240 -0000 SMALL TOOLS/NIINOREQUIPMENT 800 546 800 130 800 711 1,000 200 25.0% 101 -52- 4245 -0000 GENERAL SUPPLIES 9,500 7,775 9,500 8,783 9,500 8,335 9,500 0 0.0% 101 -52- 4246 -0000 PROGRAM SUPPLIES 0 0 0 0 0 0 0 0 N/A 101 -52- 4247 -0000 TREES PURCHASED 0 7,056 0 2,275 0 2,693 0 0 N/A Total Supplies 23,300 17,907 23,300 33,635 23,300 12,583 23,500 200 0.9% OTHER SERVICES AND CHARGES 101 -52- 4302 -0000 CONSULTING FEES 0 0 0 12,446 0 0 0 0 N/A 101 -52- 4303 -0000 ENGINEERING FEES 0 0 0 0 0 0 5,000 5,000 N/A 101 -52- 4304 -0000 LEGAL FEES 0 0 0 0 0 0 0 0 N/A 101 -52- 4321 -0000 COMMUNICATIONS - VOICE/DATA 2,000 1,959 2,000 1,959 2,000 1,472 2,000 0 0.0% 101 -52- 4331 -0000 TRAVEL, CONFERENCE & SCHOOL 1,000 188 2,000 0 2,000 795 2,000 0 0.0% 101 -52- 4351 -0000 PRINTING AND PUBLISHING 0 0 0 137 0 0 0 0 N/A 101 -52- 4380 -0000 UTILITY SERVICES 11,000 8,206 10,000 8,288 10,000 7,974 10,000 0 0.0% 101 -52- 4400 -0000 CONTRACTUAL SERVICES 13,000 17,808 16,500 11,831 16,500 10,758 12,000 (4,500) -27.3% 101 -52- 4401 -0000 LAKE MINNETONKA TREATMENT 0 0 0 0 0 0 5,000 5,000 N/A 101 -52- 4402 -0000 CHRISTMAS LAKE AIS INSPECTIONS 0 96 0 0 0 0 0 0 N/A 101 -52- 4410 -0000 RENTALS 11,000 7,195 10,000 8,259 10,000 7,551 9,000 (1,000) -10.0% 101 -52- 4433 -0000 DUES AND SUBSCRIPTIONS 0 40 0 0 0 225 0 0 N/A 101 -52- 4440 -0000 MISC SERVICES /CONTINGENCY 0 0 0 0 0 0 0 0 N/A 101 -52- 4450 -0000 BANK SERVICE CHARGES 0 0 0 0 0 0 0 0 N/A Total Other Services and Charges 38,000 35,494 40,500 42,920 40,500 28,775 45,000 4,500 11.1 Total Park Maintenance 170.773 201137 178.822 231111 178.822 188.948 196.932 18.110 10.1 19 General Fund 2018 Budget Expenditures by Line Item YTD Preliminary Budget Percentage Budget Actual Budget Actual Budget 11/27/17 Budget Change Change Account Number Description 2015 2015 2016 2016 2017 2017 2018 2018 2018 DEPT 53 RECREATION 101 -53- 4101 -0000 FULL -TIME REGULAR 22,211 27,531 23,168 25,137 23,168 24,339 25,251 2,083 9.0% 101 -53- 4102 -0000 OVERTIME 0 209 0 623 0 308 0 0 N/A 101 -53- 4103 -0000 PART -TIME 10,000 10,137 13,000 6,595 13,000 3,899 13,000 0 0.0% 101 -53- 4121 -0000 PERA CONTRIB - CITY SHARE 1,610 2,063 1,680 1,935 1,680 1,834 1,894 214 12.7% 101 -53- 4122 -0000 FICA CONTRIB - CITY SHARE 2,464 2,834 2,767 2,447 2,767 2,145 2,927 160 5.8% 101 -53- 4131 -0000 EMPLOYEE INSURANCE - CITY 458 463 960 511 960 490 1,015 55 5.7% 101 -53- 4151 -0000 WORKERS COMPENSATION 0 131 0 958 0 695 202 202 N/A 101 -53- 4438 -0000 Total Personal Services 36,743 43,369 41,575 38,206 41,575 33,710 44,289 2,714 6.5% 101 -53- 4441 -0000 ARCTIC FEVER PROGRAMS 7,000 2,517 7,000 5,342 7,000 6,359 7,000 SUPPLIES 0.0% 101 -53- 4442 -0000 SNOW PRINCESS TEA PARTY 0 154 0 294 0 0 0 101 -53- 4245 -0000 GENERAL SUPPLIES 0 1,190 700 704 700 500 700 0 0.0% 101 -53- 4246 -0000 PROGRAM SUPPLIES 5,800 2,066 7,000 403 7,000 869 7,000 0 0.0% 101 -53- 4247 -0000 TREES PURCHASED 0 0 0 0 0 0 0 0 N/A 101 -53- 4248 -0000 OTHER PROGRAMS FEE 0 2,425 0 2,575 0 2,580 0 0 N/A Total Supplies 5,800 5,680 7,700 3,681 7,700 3,949 7,700 0 0.0% OTHER SERVICES AND CHARGES 101 -53- 4302 -0000 CONSULTING FEES 0 0 0 0 0 0 0 0 N/A 101 -53- 4321 -0000 COMMUNICATIONS - VOICE/DATA 0 0 0 0 0 0 0 0 N/A 101 -53- 4331 -0000 TRAVEL, CONFERENCE & SCHOOL 200 0 100 0 100 0 100 0 0.0% 101 -53- 4351 -0000 PRINTING AND PUBLISHING 850 0 0 382 0 450 0 0 N/A 101 -53- 4400 -0000 CONTRACTUAL SERVICES 10,500 709 6,500 1,859 6,500 1,298 6,500 0 0.0% 101 -53- 4433 -0000 DUES AND SUBSCRIPTIONS 250 190 200 190 200 209 200 0 0.0% 101 -53- 4437 -0000 TAXES/LICENSES 0 49 0 (26) 0 (7) 0 0 N/A 101 -53- 4438 -0000 OKTOBERFEST 0 1,021 0 1,527 0 1,386 0 0 N/A 101 -53- 4441 -0000 ARCTIC FEVER PROGRAMS 7,000 2,517 7,000 5,342 7,000 6,359 7,000 0 0.0% 101 -53- 4442 -0000 SNOW PRINCESS TEA PARTY 0 154 0 294 0 0 0 0 N/A 101 -53- 4450 -0000 BANK SERVICE CHARGES 0 0 100 0 100 0 100 0 0.0% Total Other Services and Charges 18,800 4,640 13,900 9,568 13,900 9,695 13,900 0 0.0% Total Recreation 61,343 53,689 63,175 51,456 63,175 47,354 65,889 2,714 4.3% TOTAL PARKS AND RECREATION 232,116 255,826 241,997 283,567 241,997 236,302 262,820 20,823 8.6% TOTAL EXPENDITURES 4,599,750 4,296,397 4,780,774 4,573,766 4,936,399 4,400,057 5,069,737 133,338 2.7% 20 General Fund 2018 Budget Expenditures by Line Item YTD Preliminary Budget Percentage Budget Actual Budget Actual Budget 11/27/17 Budget Change Change Account Number Description 2015 2015 2016 2016 2017 2017 2018 2018 2018 OTHER FINANCING USES IM"EMMIyM"MOINI 101 -00- 4820 -0000 SOUTHSHORE CENTER - BUILDING 0 0 0 311,000 0 0 38,000 38,000 N/A 101 -11- 4820 -0000 SOUTHSHORE CENTER- OPERATIONS 70,000 70,000 70,000 70,000 70,000 95,000 70,000 0 0.0% 101 -19- 4820 -0000 CITY HALL DEBT SERVICE 101,513 101,513 104,313 104,313 102,913 102,913 93,895 (9,018) -8.8% 101 -32- 4820 -0000 EQUIPMENT REPLACEMENT 90,000 90,000 105,000 105,000 120,000 120,000 135,000 15,000 12.5% 101 -32- 4820 -0000 STREET IMPROVEMENTS 740,000 740,000 755,000 755,000 770,000 1,245,000 785,000 15,000 1.9% 101 -53- 4820 -0000 PARK IMPROVEMENTS 42,000 42,000 42,000 42,000 42,000 242,000 42,000 0 0.0% Total Transfers Out 1,043,513 1,043,513 1,076,313 1,387,313 1,104,913 1,804,913 1,163,895 58,982 5.3% TOTAL EXPENDITURES AND OTHER FINANCING USES 5,643,263 5,339,910 5,857,087 5,961,079 6,041,312 6,204,970 6,233,632 192,320 3.2% 21 #9C MEETING TYPE City of Shorewood Council Meeting Item Regular Meeting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Title / Subject: Adopting the 2018 -2024 Capital Improvement Plan and 2018 Budgets For the Southshore Center, Capital Project Funds, and Enterprise Funds Meeting Date: December 11, 2017 Prepared by: Joe Rigdon, Interim Finance Director Reviewed by: Greg Lerud, City Administrator Attachments: Resolution CIP Projects by Funding Source Southshore Center CIP Detail Capital Project Fund Projections Southshore Center 2018 Budget Enterprise Funds 2018 Budgets Please find attached for your approval the recommended 2018 -2024 Capital Improvement Plan, and 2018 budgets for the Southshore Center, enterprise funds, and capital project funds. Background: Capital Improvement Plan 2018 -2024 The Capital Improvement Plan is unchanged from the previous presentation, with the exception of the Southshore Center fund, which has been updated to include building capital improvements. The CIP provides an estimation of the timing and cost of future projects. Future fund balance surplus (deficit) projections for the City's various capital project funds are included to assist in financial planning. The 2018 amounts in the capital project fund projections are considered to be the 2018 budgets. Southshore Center Budget The 2018 Southshore Center budget has been updated to include $158,250 of capital improvements. Also, a $38,000 transfer from the General Fund has been included to assist with financing of the building improvements. Enterprise Fund Budgets The Enterprise Fund budgets have not changed since the last presentation. The budget format is one in which the enterprise full accrual accounting method is utilized. For example, depreciation expense is listed as a line item, while capital outlays are not. This format tracks the City's annual financial reporting process to maintain comparability. An approximation of each utility enterprise fund's change in overall cash is included (Water, Sewer, and Storm Water). Financial or Budget Considerations: The adoption of these budgets does not limit the City Council's ability to modify spending priorities or authorizations throughout the year. Mission Statement: The City of Shorewood is committed to providing residents quality public services, a healthy environment, a variety of attractive amenities, a sustainable tax base, and sound financial management through effective, efficient, and visionary leadership. Page 1 Options: The City Council may choose to: 1. Adopt the 2018 -2024 Capital Improvement Plan and 2018 budgets for the Southshore Center, Capital Project funds, and Enterprise funds as presented; 2. Make additional changes and adopt the amended Capital Improvement Plan and budgets. Recommendation / Action Requested: Staff recommends that the City Council adopt the Capital Improvement Plan and budgets resolution as submitted by staff. Next Steps: It is recommended that the City Council periodically review the Capital Improvement Plan and long - range financial plan funding projections. CITY OF SHOREWOOD RESOLUTION NO. 17- ADOPTING THE 2018 -2024 CAPITAL IMPROVEMENT PLAN, 2018 SOUTHSHORE CENTER BUDGET, 2018 CAPITAL PROJECT FUND BUDGETS, AND 2018 ENTERPRISE FUND BUDGETS WHEREAS, City staff have presented the preliminary CIP and 2018 budgets at meetings through December, 2017; and WHEREAS, the City Council has reviewed the CIP and budgets and made modifications to each that reflect desired community service levels; and WHEREAS, these budgets represent a reasonable estimate of what needs to be spent to provide the desired service level; NOW, THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF SHOREWOOD AS FOLLOWS: 1. The 2018 -2024 Capital Improvement Plan is hereby adopted as presented. 2. The Southshore Center, Park Improvement, Equipment Replacement, Street Reconstruction, MSA, Trail Construction, and Community Infrastructure budgets are hereby adopted as presented. 3. The Water, Sewer, Storm Water, and Recycling budgets are hereby adopted as presented. ADOPTED BY THE CITY COUNCIL OF THE CITY OF SHOREWOOD this 11th day of December, 2017. ATTEST: Sandie Thone, City Clerk Scott Zerby, Mayor City of Shorewood, Minnesota Capital Improvement Program 2018 thm 2027 PROJECTS BY FUNDING SOURCE Source # Priority 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 Total 201 - Southshore Center South Shore Community Center PF -11 -01 n/a 158,250 28,500 38,750 41,000 47,250 17,000 330,750 201 - Southshore Center Total 158,250 28,500 38,750 41,000 47,250 17,000 330,750 402 - Park Imurovements Freeman Plaza Table Replacement P0100 2 5,000 5,000 Freeman South Playground P0102 2 100,000 100,000 Equipment Freeman Park Overlay Trails P0105 3 200,000 200,000 Cathcart Park Resurface Tennis P0200 1 9,000 9,000 10,000 28,000 Court Cathcart Park Hockey Boards P0201 3 150,000 150,000 Cathcart Park Playground Equipment P0202 4 100,000 100,000 Badger Park Tennis Courts P0301 2 325,000 9,500 10,000 344,500 Badger Park P0302 1 375,000 375,000 Playground /Shelter /Trail Ext/Electric Manor Park Shelter Outside P0402 3 5,400 51400 Concrete Improvements Silverwood Park Resurface 1/2 court P0500 1 2,500 2,500 3,000 8,000 Silverwood Park Playground P0501 5 100,000 100,000 Equipment Silverwood Park Retaining Walls P0502 5 93,000 93,000 Replacement South Shore Park Master Plan P0700 2 10,000 10,000 South Shore Park Reconstruction P0701 3 90,000 90,000 Project 402 - Park Improvements Total 386,500 440,000 295,400 271,000 193,000 23,000 1,608,900 403 - Equipment Replacement Fund Cub Cadet Utility Vehicle 034 n/a 14,100 14,100 Tuesday, December 05, 2017 Source # Priority 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 Total Ford F350 Flatbed (Multi Use Body) 049 n/a 39,200 39,200 Trailer 18' replace unit 59 059 n/a 15,700 15,700 Toro Sand Pro 3000 064 n/a 9,000 9,000 FellingTrailer FT3 12' 069 n/a 5,000 5,000 Ford F250 Pickup 078 n/a 27,800 27,800 Toro Groundsmaster 086 n/a 32,000 32,000 2010 44 Ford F350 090 n/a 33,600 33,600 Case Skid Steer - SV185 097 n/a 37,600 37,600 Skid Steer Grapple A02 n/a 7,600 7,600 Plow for Skid /Multi One A08 n/a 6,200 6,200 Engine/Transmission Diag Software A09 n/a 4,500 4,500 Upgrade Skid Steer Snow Bucket All n/a 3,400 31400 Forestry Bucket /Chip Truck (Used) A21 n/a 58,000 58,000 Brush Chipper A22 n/a 55,000 55,000 Engine Diagnostic Scanner A23 n/a 6,000 6,000 Case Skid Steer SV 185 A24 n/a 43,288 43,288 Public Works Roof PF -12 -01 n/a 81,000 81,000 Color Copier Replacement T -13 -03 n/a 15,000 10,000 25,000 Computer Server T -18 -01 n/a 15,000 15,000 800 Mhz Radio Replacement T -19 -01 n/a 9,500 9,800 10,100 29,400 Computer Upgrades T -99 -99 n/a 10,000 10,000 10,000 10,000 10,000 10,000 10,000 70,000 403 - Equipment Replacement Fund Total 183,300 164,500 88,200 142,988 10,000 19,400 10,000 618,388 404 - Street Reconstruction Fund Amlee Road LR -16 -01 n/a 457,213 457,213 Manitou Lane LR -16 -04 n/a 244,472 244,472 Glen Road East LR -16 -07 n/a 705,230 705,230 Riviera Lane LR -17 -05 n/a 511,985 511,985 Shorewood Lane LR -17 -06 n/a 551,783 551,783 Mann Lane LR -18 -01 n/a 304,860 304,860 Maple Street LR -18 -02 n/a 113,307 113,307 Bayswater Road LR -19 -01 n/a 100,394 100,394 Boulder Circle LR -19 -02 n/a 114,128 114,128 Christmas Lane W LR -19 -03 n/a 70,257 70,257 Lilac Lane LR -19 -05 n/a 282,411 282,411 Vine Street LR -19 -07 n/a 78,680 78,680 Eureka Road N LR -19 -08 n/a 275,264 275,264 Tuesday, December 05, 2017 Source # Priority 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 Total Birch Bluff Road LR -20 -01 n/a 311,737 311,737 Excelsior Blvd LR -20 -02 n/a 436,521 436,521 Seamans Drive LR -20 -03 n/a 184,656 184,656 West Lane LR -20 -04 n/a 73,187 73,187 Christmas Lane E LR -21 -01 n/a 28,434 28,434 Christmas Lake Road LR -21 -02 n/a 295,963 295,963 Country Club Road LR -21 -03 n/a 267,450 267,450 Shady Island Circle, Point & Road LR -23 -01 n/a 284,733 284,733 Shady Island Trail LR -23 -02 n/a 32,181 32,181 Dellwood Lane LR -24 -01 n/a 95,461 95,461 Enchanted Cove LR -24 -02 n/a 35,100 35,100 Enchanted Drive LR -24 -03 n/a 185,468 185,468 Enchanted Lane LR -24 -04 n/a 352,670 352,670 Street Sign Replacement LR -99 -001 n/a 7,800 8,100 8,400 8,700 9,000 9,300 9,600 60,900 Maintenance - Bituminous Sealcoating LR -99 -100 n/a 275,000 280,000 285,000 290,000 295,000 300,000 305,000 2,030,000 404 - Street Reconstruction Fund Total 1,764,735 288,100 1,214,534 1,304,801 2,302,762 1,294,913 314,600 8,484,445 406 - Trails Galpin Lake Rd Sidewalk 7003 n/a 1,330,000 1,330,000 Strawberry Lane & W 62nd T007 n/a 852,000 852,000 406 - Trails Total 2,182,000 2,182,000 601 - Water Fund Air Compressor - Replace unit 38 038 n/a 20,000 20,000 Dodge Caravan - replace unit 77 077 n/a 28,000 28,000 Ford F150 Pickup 080 n/a 27,500 27,500 Boulder Bridge Well Building W -17 -01 n/a 60,000 60,000 Residing & Roofing Well House Water Meters W -17 -02 n/a 6,000 12,000 6,000 24,000 Boulder Bridge Well Motor W -18 -01 n/a 45,000 45,000 Boulder Bridge Well Motor Control W -18 -02 n/a 200,000 200,000 Center SE Area Well Residing W -18 -03 n/a 45,000 45,000 GPS Utillity Locate System W -18 -04 n/a 5,000 5,000 (Proportion) Boulder Bridge Dehumidifier W -19 -01 n/a 5,000 5,000 Amesbury Well Anti Corrosion and W -19 -02 n/a 30,000 30,000 Pipe Coatings Tuesday, December 05, 2017 Source # Priority 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 Total Boulder Bridge Anti Corrosion and w -20 -01 n/a 30,000 Pipe Coatings Water- Streets CIP W -99 -99 n/a 750,000 601 - Water Fund Total 1,066,000 102,500 81,000 20,000 611 - Sanitary Sewer Fund Generator- Generac 163 KW Trailer 071 n/a 80,144 Mtd Lift Station 10 Rehab - 4773 SS -15 -01 n/a 140,000 Lakeway Terrace Lift Station 20 Rehab - 26550 Noble SS -16 -01 n/a 135,000 Road Lift Station 7 Rehab - 5600 SS -16 -02 n/a 120,000 Woodside Road GPS Utility Locate System SS -18 -01 n/a 5,000 (Proportion) Sewer Vactor Truck Shared with TB SS -18 -02 n/a 125,000 and Exc Infiltration and Inflow Reduction SS -99 -05 n/a 70,000 70,000 70,000 70,000 70,000 611 - Sanitary Sewer Fund Total 200,000 205,000 190,000 210,000 150,144 631 - Stormwater Management Fund 4" pump replace unit 50 050 n/a 45,500 Amlee Road LR -16 -01 n/a 115,498 Manitou Lane LR -16 -04 n/a 61,749 Glen Road East LR -16 -07 n/a 178,126 Riviera Lane LR -17 -05 n/a 139,396 Shorewood Lane LR -17 -06 n/a 150,257 Mann Lane LR -18 -01 n/a 83,006 Maple Street LR -18 -02 n/a 32,451 Galpin Lake Rd Trail Stormwater SS003 n/a 230,000 Storm Water- Streets CIP STM -99 -99 n/a 4,500,000 631 - Stormwater Management Fund Total 635,110 4,500,000 45,500 355,373 30,000 750,000 1,269,500 80,144 140,000 135,000 120,000 5,000 125,000 70,000 70,000 490,000 70,000 70,000 1,095,144 GRAND TOTAL 4,393,895 5,728,600 4,135,384 1,989,789 2,865,529 1,594,313 417,600 45,500 115,498 61,749 178,126 139,396 150,257 83,006 32,451 230,000 4,500,000 5,535,983 21,125,110 Tuesday, December 05, 2017 SOUTHSHORE CENTER PROPOSED CAPITAL IMPROVEMENT PLAN Dec -17 BUILDING COMPONENT /PROJECT Roof replacement & gutters Siding Exterior painting and caulking Doors, exterior Windows Mechanical systems (Furnace and AC) Electrical systems, Plumbing systems, plumbing fixtures Water heater Water softener Kitchen exhaust system Fire Suppression attic system Retaining walls & patio Fence Interior painting & trim 200 chairs for dining room Upgrade interior lighting (incl. ceiling tile) Reception counter replacement Refinish Deck Grout on restroom /kitchen floors Library carpet replacement Hallway carpet replacement Correct heaving floor in dining room Remove wallpaper & paint library Replace carpet in office /closet Replace counter tops and sinks in library activty room, and bathrooms Window treatments Replace dining room carpet Replace commercial kitchen equipment Cosmetic Improvements 2017 2018 2019 2020 2021 2022 2023 2024 44,000 2,000 2,000 14,500 5,000 5,000 5,000 10,000 10,000 10,000 10,000 10,000 10,000 40,000 6,000 5,000 2,500 7,500 7,500 7,500 7,500 23,000 10,000 11250 6,000 27,000 24,000 750 1,000 1,000 4,000 2,000 1,500 2,000 5,000 6,250 1,000 16,000 5,000 5,000 5,000 38,000 TOTAL 75,000 158,250 28,500 38,750 41,000 47,250 17,000 0 PARK CAPITAL IMPROVEMENT FUND Fund: 402- Park Capital Outlay REVENUES Park Dedication Fees - Mattamy Park Dedication Fees - Oppidan Park Dedication Fees - Other Interest Earnings Contributions /donations - Minnetonka Youth lacrosse Contributions /donations - Tonka football Grants - Hennepin County Lacrosse Grants Miscellaneous revenue Transfers in - Budget Transfers in - Excess Reserves TOTALREVENUES EXPENDITURES Other Improvements TOTAL EXPENDITURES Revenues Over /(Under) Expenditures Beginning Fund Balance Ending Fund Balance YTD & Est. Actual 2017 Budget Budget Budget Budget Budget Budget Budget 2016 10/31/2017 2018 2019 2020 2021 2022 2023 2024 400,986 291,127 87,887 88,400 - - 13,000 6,500 - - 7,122 6,128 5,080 2,564 (1,390) (3,938) (6,267) (5,910) (7,479) 203,167 - - - 25,000 - - 200,000 42,000 42,000 42,000 42,000 42,000 42,000 42,000 42,000 42,000 - 200,000 - - - - - - - 779,675 745,755 134,967 44,564 40,610 38,062 35,733 36,090 34,521 709,135 850,617 386,500 440,000 295,400 271,000 193,000 23,000 709,135 850,617 386,500 440,000 295,400 271,000 193,000 23,000 70,540 (104,862) (251,533) (395,436) (254,790) (232,938) 35,733 (156,910) 11,521 542,278 612,818 507,956 256,423 (139,013) (393,803) (626,741) (591,009) (747,919) 612,818 507,956 256,423 (139,013) (393,803) (626,741) (591,009) (747,919) (736,398) Badger Park Phase 2 Bid 582,448 Park Capital Fund portion of 623,778 total bid Change Orders 41,522 Soft Costs Est. 20% 133,060 Soft costs based on 20% of 665,300 revised total contract 757,030 Freeman Park Parking Lot, Rink, Lights 93,587 850,617 EQUIPMENT REPLACEMENT FUND Fund: 403 - Equipment Replacement REVENUES Interest Earnings Grants Miscellaneous revenue Transfers in - Budget Transfers in - Excess Reserves TOTAL REVENUES Administration TOTAL EXPENDITURES Revenues Over /(Under) Expenditures Beginning Fund Balance Ending Fund Balance 136,270 YTD & Est. 141,053 155,630 170,542 186,365 201,799 218,717 235,710 Actual 2017 Budget Budget Budget Budget Budget Budget Budget 2016 10/31/2017 2018 2019 2020 2021 2022 2023 2024 35,676 10,000 40,000 10,000 10,000 20,000 10,000 10,000 10,000 8,470 5,485 6,053 5,630 5,542 6,365 6,799 8,717 10,710 22,800 705 - - - - - - - 105,000 120,000 135,000 150,000 165,000 180,000 195,000 210,000 225,000 136,270 126,190 141,053 155,630 170,542 186,365 201,799 218,717 235,710 67,535 59,405 143,300 154,500 78,200 122,988 - 9,400 - 35,676 10,000 40,000 10,000 10,000 20,000 10,000 10,000 10,000 103,211 69,405 183,300 164,500 88,200 142,988 10,000 19,400 10,000 33,059 56,785 (42,247) (8,870) 82,342 43,377 191,799 199,317 225,710 515,436 548,495 605,280 563,033 554,163 636,505 679,882 871,681 1,070,997 548,495 605,280 563,033 554,163 636,505 679,882 871,681 1,070,997 1,296,707 STREET RECONSTRUCTION FUND Fund: 404 - Street Capital Outlay REVENUES Franchise Fees - Electric (6 months in 2018) Franchise Fees- Gas (8 months in 2018) Interest Earnings G ra nts Miscellaneous revenue Transfers in - Budget Transfers in - Excess Reserves TOTAL REVENUES EXPENDITURES CIP Street Program Less: Storm Sewer portion of CIP Street Program Street Sign Replacement Sealcoating/Overlay & Other TOTAL EXPENDITURES Revenues Over /(Under) Expenditures Beginning Fund Balance Ending Fund Balance YTD & Est. Actual 2017 Budget Budget Budget Budget Budget Budget Budget 2016 10/31/2017 2018 2019 2020 2021 2022 2023 2024 81,858 163,716 163,716 163,716 163,716 163,716 163,716 - - 95,144 142,716 142,716 142,716 142,716 142,716 142,716 19,166 15,953 16,776 8,917 17,189 16,430 14,911 3,547 2,297 755,000 770,000 785,000 800,000 815,000 830,000 845,000 860,000 875,000 - 475,000 - - - - - - - 774,166 1,260,953 978,778 1,115,349 1,138,621 1,152,862 1,166,343 1,169,979 1,183,729 900,331 * 1,887,045 921,134 1,006,101 2,354,135 985,613 - - (405,110) - - - (355,373) - - 6,586 10,295 7,800 8,100 8,400 8,700 9,000 9,300 9,600 625,355 267,962 275,000 280,000 285,000 290,000 295,000 300,000 305,000 631,941 1,178,588 1,764,735 288,100 1,214,534 1,304,801 2,302,762 1,294,913 314,600 142,225 82,365 (785,957) 827,249 (75,913) (151,939) (1,136,419) (124,934) 869,129 1,453,048 1,595,273 1,677,638 891,681 1,718,930 1,643,017 1,491,078 354,659 229,725 1,595,273 1,677,638 891,681 1,718,930 1,643,017 1,491,078 354,659 229,725 1,098,854 * $900,331 was the estimate of the 2017 street projects; likely to be incurred over 2017 and 2018 MSA STREET CONSTRUCTION FUND Fund: 405 - MSA Capital Outlay REVENUES Interest Earnings MSA Miscellaneous revenue Transfers in - Budget Transfers in - Excess Reserves TOTALREVENUES EXPENDITURES Other Improvements TOTAL EXPENDITURES Revenues Over /(Under) Expenditures Beginning Fund Balance Ending Fund Balance YTD & Est. Actual 2017 Budget Budget Budget Budget Budget Budget Budget 2016 10/31/2017 2018 2019 2020 2021 2022 2023 2024 1,724 1,287 1,300 1,313 1,326 1,340 1,353 1,367 1,380 - 116,711 - - - - - - - 1,724 117,998 1,300 1,313 1,326 1,340 1,353 1,367 1,380 - 116,711 - - - - - - - - 116,711 - - - - - - - 1,724 1,287 1,300 1,313 1,326 1,340 1,353 1,367 1,380 127,019 128,743 130,030 131,331 132,644 133,970 13 5, 310 136,663 138,030_ 128,743 130,030 131,331 132,644 133,970 13 5, 310 136,663 138,030 139,410 TRAIL CONSTRUCTION FUND Fund: 406 - Trail Capital Outlay REVENUES Interest Earnings Grants Miscellaneous revenue Transfers in - Budget Transfers in - Excess Reserves TOTALREVENUES EXPENDITURES Other Improvements TOTAL EXPENDITURES Revenues Over /(Under) Expenditures Beginning Fund Balance Ending Fund Balance YTD & Est. Actual 2017 Budget Budget Budget Budget Budget Budget Budget 2016 10/31/2017 2018 2019 2020 2021 2022 2023 2024 (4,561) (6,974) (7,578) (7,654) (7,730) (29,628) (29,924) (30,223) (30,526) (4,561) (6,974) (7,578) (7,654) (7,730) (29,628) (29,924) (30,223) (30,526) 994,570 53,406 2,182,000 994,570 53,406 2,182,000 (999,131) (60,380) (7,578) (7,654) (2,189,730) (29,628) (29,924) (30,223) (30,526) 301,698 (697,433) (757,813) (765,391) (773,045) (2,962,776) (2,992,404) (3,022,328) (3,052,551) (697,433) (757,813) (765,391) (773,045) (2,962,776) (2,992,404) (3,022,328) (3,052,551) (3,083,076) COMMUNITY INFRASTRUCTURE FUND Fund: 450 - Community -wide Capital Outlay REVENUES Interest Earnings Grants Miscellaneous revenue Transfers in - Budget Transfers in - Excess Reserves TOTALREVENUES EXPENDITURES Other Improvements TOTAL EXPENDITURES Revenues Over /(Under) Expenditures Beginning Fund Balance Ending Fund Balance YTD & Est. Actual 2017 Budget Budget Budget Budget Budget Budget Budget 2016 10/31/2017 2018 2019 2020 2021 2022 2023 2024 (433) 3,063 2,876 2,904 2,934 2,963 2,992 3,022 3,053 298,992 104,352 298,559 107,415 2,876 2,904 2,934 2,963 2,992 3,022 3,053 303,452 126,158 - - - - - - - 303,452 126,158 - - - - - - - (4,893) (18,743) 2,876 2,904 2,934 2,963 2,992 3,022 3,053 311,206 306,313 287,570 290,446 293,350 296,284 299,247 302,239 305,261 306,313 287,570 290,446 293,350 296,284 299,247 302,239 305,261 308,314 Southshore Community Center 2018 Budget YTD Preliminary Budget Percentaee Budget Actual Budget Actual Budget 10/31/17 Budget Change Change Account Number Description 2015 2015 2016 2016 2017 2017 2018 2018 2018 FUND 201 REVENUE 201 -00- 3362 -0000 201 -00- 3400 -0000 201 -00- 3410 -0000 201 -00- 3470 -0000 201 -00- 3471 -0000 201 -00- 3473 -0000 201 -00- 3477 -0000 201 -00- 3480 -0000 201 -00- 3620 -0000 201 -00- 3621 -0000 201 -00- 3623 -0000 201 -00- 3630 -0000 201 -00- 3670 -0000 201 -00- 3732 -0000 201 -00- 3790 -0000 201 -00- 3920 -0000 EXPENDITURES Southshore Center MISC GRANTS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 N/A CHARGES FOR SERVICES 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 N/A RENTAL INCOME 0.00 16,178.00 0.00 42,546.24 0.00 36,837.75 44,000.00 44,000 N/A PARK DEDICATION FEES 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 N/A PARK FEES & RENTALS 40,000.00 0.00 40,000.00 0.00 40,000.00 0.00 0.00 (40,000) - 100.0% EVENT PROGRAM FEES 0.00 26,820.75 0.00 889.00 0.00 665.00 0.00 0 N/A METRO DINING CARDS 0.00 212.00 0.00 506.00 0.00 2,500.00 0.00 0 N/A PROGRAM (CLASS) FEES 15,000.00 5,508.00 15,000.00 2,339.00 15,000.00 2,395.00 5,000.00 (10,000) -66.7% INTEREST EARNINGS 0.00 546.00 0.00 808.70 0.00 0.00 250.00 250 N/A GAIN / (LOSS) ON INVESTMENTS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 N/A CONTRIBUTIONS AND DONATIO 1,000.00 254.00 1,000.00 426.00 1,000.00 225.00 0.00 (1,000) - 100.0% LEASE REVENUE 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 N/A MISCELLANEOUS REVENUE 1,500.00 298.00 1,500.00 473.88 1,500.00 0.00 1,000.00 (500) -33.3% CITY CLEANUP CHARGES 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 N/A CASH OVER 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 N/A TRANSFERS IN 70,000.00 70,000.00 70,000.00 381,000.00 70,000.00 95,000.00 108,000.00 38,000 54.3% REVENUE Totals: 127,500.00 119,816.75 127,500.00 428,988.82 127,500.00 137,622.75 158,250.00 30,750.00 24.1% PERSONAL SERVICES 201 -00- 4101 -0000 FULL -TIME REGULAR 55,000.00 19,992.92 55,000.00 17,776.83 55,000.00 17,023.54 18,938.00 (36,062) -65.6% 201 -00- 4102 -0000 OVERTIME 3,000.00 4,177.76 3,000.00 4,500.22 3,000.00 2,057.54 4,000.00 1,000 33.3% 201 -00- 4103 -0000 PART -TIME 0.00 9,100.50 0.00 9,318.00 0.00 7,611.50 10,000.00 10,000 N/A 201 -00- 4121 -0000 PERA CONTRIB - CITY SHARE 4,060.00 1,520.59 4,060.00 1,371.46 4,060.00 1,284.23 1,420.00 (2,640) -65.0% 201 -00- 4122 -0000 FICA CONTRIB - CITY SHARE 4,208.00 2,197.50 4,208.00 2,055.01 4,208.00 1,846.66 2,214.00 (1,994) -47.4% 201 -00- 4131 -0000 EMPLOYEE INSURANCE - CITY 4,500.00 0.00 4,500.00 0.00 4,500.00 0.00 761.00 (3,739) -83.1% 201 -00- 4151 -0000 WORKERS COMPENSATION 300.00 174.53 300.00 767.98 300.00 662.22 152.00 (148) -49.3% Total Personal Services 71,068.00 37,163.80 71,068.00 35,789.50 71,068.00 30,485.69 37,485.00 - 33,583.00 -47.3% SUPPLIES 201 -00- 4223 -0000 MAINTENANCE OF BUILDINGS 3,000.00 7,997.25 3,000.00 1,595.00 3,000.00 2,064.83 3,000.00 0 0.0% 201 -00- 4245 -0000 GENERAL SUPPLIES 800.00 4,235.43 800.00 2,928.28 800.00 2,550.01 2,500.00 1,700 212.5% 201 -00- 4246 -0000 EVENT SUPPLIES EXPENSE 13,000.00 805.02 13,000.00 38.06 13,000.00 0.00 500.00 (12,500) -96.2% 201 -00- 4247 -0000 COMMUNITY EVENT EXPENSE 4,000.00 0.00 4,000.00 0.00 4,000.00 2,000.00 0.00 (4,000) - 100.0% 201 -00- 4248 -0000 PROGRAM (CLASS) EXPENSES 0.00 9,199.63 0.00 8,457.26 0.00 7,367.14 5,000.00 5,000 N/A Total Supplies OTHER SERVICES AND CHARGES 201 -00- 4302 -0000 CONSULTING FEES 201 -00- 4304 -0000 LEGAL FEES 20,800.00 22,237.33 20,800.00 13,018.60 20,800.00 13,981.98 11,000.00 - 9,800.00 -47.1% 0.00 4,500.00 0.00 0.00 0.00 810.00 0.00 0.00 21,214.68 0.00 24,276.71 0.00 1,091.50 0.00 N/A N/A Southshore Community Center 2018 Budget YTD Preliminary Budget Percentaee Budget Actual Budget Actual Budget 10/31/17 Budget Change Change Account Number Descriution 2015 2015 2016 2016 2017 2017 2018 2018 2018 201 -00- 4321 -0000 COMMUNICATIONS - VOICE/DA7 3,300.00 0.00 3,300.00 1,292.82 3,300.00 1,052.38 3,000.00 (300) -9.1% 201 -00- 4331 -0000 TRAVEL, CONFERENCE & SCHO( 0.00 302.14 0.00 14.04 0.00 11.77 0.00 0 N/A 201 -00- 4351 -0000 PRINTING AND PUBLISHING 1,500.00 1,230.26 1,500.00 2,694.88 1,500.00 3,682.37 3,000.00 1,500 100.0% 201 -00- 4360 -0000 INSURANCE 1,000.00 0.00 1,000.00 0.00 1,000.00 0.00 1,000.00 0 0.0% 201 -00- 4380 -0000 UTILITY SERVICES 11,000.00 10,281.06 11,000.00 11,082.53 11,000.00 9,513.04 11,000.00 0 0.0% 201 -00- 4400 -0000 CONTRACTUAL SERVICES 15,000.00 12,122.36 15,000.00 12,902.01 15,000.00 10,889.69 15,000.00 0 0.0% 201 -00- 4433 -0000 DUES AND SUBSCRIPTIONS 200.00 0.00 200.00 0.00 200.00 0.00 0.00 (200) - 100.0% 201 -00- 4437 -0000 TAXES/LICENSES 1,200.00 760.00 1,200.00 767.00 1,200.00 773.00 1,200.00 0 0.0% 201 -00- 4440 -0000 MISC SERVICES 2,000.00 87.50 2,000.00 0.00 2,000.00 0.00 1,000.00 (1,000) -50.0% 201 -00- 4441 -0000 ARCTIC FEVER PROGRAMS 0.00 281.28 0.00 0.00 0.00 0.00 0.00 0 N/A 201 -00- 4442 -0000 SNOW PRINCESS TEA PARTY 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 N/A 201 -00- 4450 -0000 BANK SERVICE CHARGES 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 N/A Total Other Services and Charges 35,200.00 50,779.28 35,200.00 53,029.99 35,200.00 27,823.75 35,200.00 0.00 0.0% CAPITAL OUTLAY 201 -00- 4620 -0000 BUILDINGS & STRUCTURES 0.00 0.00 0.00 311,000.00 0.00 0.00 158,250.00 158,250 N/A EXPENDITURES TOTAL 127,068.00 110,180.41 127,068.00 412,838.09 127,068.00 72,291.42 241,935.00 114,867.00 90.4% CHANGE IN FUND BALANCE 432.00 9.636.34 432.00 16.150.73 432.00 65331.33 - 83.685.00 -84-117.00 - 19471.5% Water Fund 2018 Budget YTD Preliminary Budget Percentage Budget Actual Budget Actual Budget 10/17/17 Budget Change Change Account Number Description 2015 2015 2016 2016 2017 2017 2018 2018 2018 FUND 601 Water Utility REVENUE 601 -00- 3353 -0000 PERA PENSION OTHER REVENUE 601 -00- 3362 -0000 MISC GRANTS 601 -00- 3610 -0000 SPECIAL ASSESSMENTS - CURRENT 601 -00- 3611 -0000 SPECIAL ASSESSMENTS - DELINQUENT 601 -00- 3614 -0000 SPECIAL ASSESSMENTS - INTEREST 601 -00- 3620 -0000 INTEREST EARNINGS 601 -00- 3621 -0000 GAIN /(LOSS) ON INVESTMENTS 601 -00- 3624 -0000 REFUNDS & REIMURSEMENTS 601 -00- 3670 -0000 MISCELLANEOUS REVENUE 601 -00- 3710 -0000 UTILITY REVENUE 601 -00- 3711 -0000 WATER CONNECTION FEES 601 -00- 3712 -0000 UTILITY PERMIT FEES 601 -00- 3713 -0000 WATERMETERSALES 601 -00- 3715 -0000 STATE SURCHARGE 601 -00- 3717 -0000 Water Meter Permit 601 -00- 3720 -0000 WATERPENALTIES 601 -00- 3725 -0000 LOCAL SAC CHARGES 601 -00- 3910 -0000 SALES OF CAPITAL ASSETS 601 -00- 3920 -0000 TRANSFERS IN REVENUE Totals EXPENSE PERSONAL SERVICES 601 -00- 4101 -0000 FULL -TIME REGULAR 601 -00- 4102 -0000 OVERTIME 601 -00- 4103 -0000 PART -TIME 601 -00- 4104 -0000 TEMPORARY REGULAR 601 -00- 4105 -0000 WATER PAGER PAY 601 -00- 4106 -0000 OTHER 601 -00- 4111 -0000 SEVERANCE PAY 601 -00- 4121 -0000 PERA CONTRIB - CITY SHARE 601 -00- 4122 -0000 FICA CONTRIB - CITY SHARE 601 -00- 4131 -0000 EMPLOYEE INSURANCE - CITY 601 -00- 4141 -0000 UNEMPLOYMENT COMPENSATION 601 -00- 4151 -0000 WORKERS COMPENSATION 601 -00- 4161 -0000 PENSION EXPENSE Total Personal Services SUPPLIES 601 -00- 4200 -0000 OFFICE SUPPLIES 601 -00- 4208 -0000 POSTAGE 601 -00- 4212 -0000 MOTOR FUELS & LUBRICANTS 601 -00- 4215 -0000 SHOP MATERIALS 0 0 0 749 0 0 0 0 N/A 0 0 0 0 0 8,087 0 0 N/A 35,000 136,699 55,000 8,490 35,000 14,353 5,000 (30,000) -85.7% 0 1,502 0 1,012 0 0 0 0 N/A 0 0 0 0 0 0 0 0 N/A 25,000 33,635 25,000 25,818 25,000 0 25,000 0 0.0% 0 0 0 0 0 0 0 0 N/A 0 0 0 2,127 0 0 0 0 N/A 0 0 0 0 0 0 0 0 N/A 600,000 402,293 500,000 404,156 500,000 343,927 417,150 (82,850) -16.6% 25,000 2,728 25,000 278,972 25,000 264,883 25,000 0 0.0% 0 400 0 750 0 530 500 500 N/A 2,500 3,855 2,500 4,755 2,500 2,347 2,000 (500) -20.0% 0 0 0 0 0 0 0 0 N/A 0 370 0 300 0 120 100 100 N/A 0 0 0 0 0 0 0 0 N/A 0 0 0 0 0 0 0 0 N/A 0 0 0 0 0 0 0 0 N/A 0 0 0 0 0 0 0 0 N/A 687.500 581.483 607.500 727.129 587.500 634.247 474.750 (111750) -19.2% 79,796 121,359 87,451 149,803 89,271 108,584 77,620 (11,651) -13.1% 3,000 5,277 3,000 4,205 3,000 5,874 5,000 2,000 66.7% 0 0 0 0 0 0 0 0 N/A 0 0 0 0 0 0 0 0 N/A 0 4,261 0 5,532 0 4,395 5,500 5,500 N/A 0 200 0 0 0 0 0 0 N/A 0 0 0 0 0 0 0 0 N/A 6,003 9,810 6,340 11,518 6,472 8,861 5,821 (651) -10.1% 6,334 9,291 6,690 11,427 6,829 8,104 5,938 (891) -13.0% 12,726 21,434 13,998 21,166 13,998 12,541 13,640 (358) -2.6% 0 0 0 0 0 0 0 0 N/A 0 5,303 4,378 4,679 4,466 3,260 3,521 (945) -21.2% 0 7,275 0 23,128 0 0 24,000 24,000 N/A 107.859 184.211 121.857 231.457 124.036 151.619 141.040 17.004 13.7% 0 615 0 152 0 163 200 200 N/A 1,400 1,055 1,400 1,417 1,400 1,095 1,400 0 0.0% 0 0 0 0 0 0 0 0 N/A 0 0 0 0 0 0 0 0 N/A Water Fund 2018 Budget Account Number Description Budget 2015 Actual 2015 Budget 2016 Actual 2016 Budget 2017 YTD 10/17/17 2017 Preliminary Budget 2018 Budget Change 2018 Percentage Change 2018 601 -00- 4221 -0000 MAINTENANCE OF EQUIPMENT 6,500 972 6,500 19,635 6,500 2,334 26,000 19,500 300.0% 601 -00- 4223 -0000 MAINTENANCE OF BUILDINGS 1,000 111 1,000 107 1,000 4,397 60,000 59,000 5900.0% 601 -00- 4240 -0000 SMALL T OOLS/M]NOR EQUIPMENT 600 1,193 600 243 600 218 800 200 33.3% 601 -00- 4245 -0000 GENERAL SUPPLIES 12,000 10,949 12,000 8,376 12,000 7,300 11,000 (1,000) -8.3% 601 -00- 4260 -0000 WATER PURCHASES - TONKA BAY 3,500 2,979 3,500 2,585 3,500 1,704 3,500 0 0.0% 601 -00- 4261 -0000 WATER PURCHASES - EXCELSIOR 22,000 16,051 22,000 17,169 22,000 12,924 18,000 (4,000) -18.2% 601 -00- 4262 -0000 WATER PURCHASES - MINNETONKA 1,500 882 1,500 1,059 1,500 649 1,500 0 0.0% 601 -00- 4263 -0000 WATER PURCHASES- CHANHASSEN 16,000 9,322 16,000 8,282 16,000 7,583 10,000 (6,000) -37.5% 601 -00- 4265 -0000 WATER METER PURCHASES 15,000 3,756 15,000 11,385 15,000 6,967 13,000 (2,000) -13.3% Total Supplies 79,500 47,884 79,500 70,411 79,500 45,334 145,400 65,900 82.9% OTHER SERVICES AND CHARGES 601 -00- 4301 -0000 AUDITING & ACCOUNTING 2,500 0 2,500 0 2,500 0 2,500 0 0.0% 601 -00- 4302 -0000 CONSULTING FEES 0 0 0 0 0 0 0 0 N/A 601 -00- 4303 -0000 ENGINEERING FEES 5,000 31,582 5,000 15,454 5,000 15,158 20,000 15,000 300.0% 601 -00- 4304 -0000 LEGAL FEES 0 0 0 0 0 1,943 0 0 N/A 601 -00- 4312 -0000 ENGINEERING 0 0 0 0 0 0 0 0 N/A 601 -00- 4321 -0000 COMMUNICATIONS - VOICE/DATA 2,800 1,265 8,000 1,268 8,000 1,008 4,000 (4,000) -50.0% 601 -00- 4331 -0000 TRAVEL, CONFERENCE & SCHOOL 800 1,500 800 700 800 955 1,400 600 75.0% 601 -00- 4351 -0000 PRINTING AND PUBLISHING 1,100 638 1,100 901 1,100 0 1,100 0 0.0% 601 -00- 4360 -0000 INSURANCE 8,000 0 8,000 0 8,000 0 8,000 0 0.0% 601 -00- 4380 -0000 UTILITY SERVICES 0 0 0 0 0 (306) 0 0 N/A 601 -00- 4394 -0000 UTILITIES - AMESBURYWELL 12,000 11,758 12,000 10,192 12,000 7,484 12,000 0 0.0% 601 -00- 4395 -0000 UTILITIES - BADGER WELL 12,500 10,514 12,500 6,711 12,500 4,848 12,500 0 0.0% 601 -00- 4396 -0000 UTILITIES - BOULDER BRIDGE 20,000 16,132 20,000 19,068 20,000 13,550 20,000 0 0.0% 601 -00- 4397 -0000 UTILITIES - WOODHAVEN WELL 0 0 0 0 0 0 0 0 N/A 601 -00- 4398 -0000 UTILITIES - SE AREA WELL 34,000 33,944 34,000 34,987 34,000 13,529 34,000 0 0.0% 601 -00- 4400 -0000 CONTRACTUAL SERVICES 30,000 71,394 60,000 42,666 60,000 38,937 72,000 12,000 20.0% 601 -00- 4410 -0000 RENTALS 0 0 0 0 0 0 0 0 N/A 601 -00- 4420 -0000 DEPRECIATION 290,000 289,740 280,000 317,882 290,000 0 320,000 30,000 10.3% 601 -00- 4433 -0000 DUES AND SUBSCRIPTIONS 0 33 0 33 0 633 10,000 10,000 N/A 601 -00- 4437 -0000 TAXES/LICENSES 3,000 1,666 3,000 2,350 3,000 2,244 3,000 0 0.0% 601 -00- 4440 -0000 MISC SERVICES /CONTINGENCY 200 0 200 235 200 0 200 0 0.0% 601 -00- 4450 -0000 BANK SERVICE CHARGES 1,000 0 1,000 2,004 1,000 753 1,000 0 0.0% 601 -00- 4499 -0000 FEMA ELIGLIBLE EXPENSES 0 0 0 0 0 0 0 0 N/A 601 -00- 4620 -0000 BUILDINGS & STRUCTURES 0 0 0 0 0 4,470 0 0 N/A 601 -00- 4640 -0000 MACHINERY & EQUIPMENT 0 0 0 1,000 0 48,656 0 0 N/A 601 -00- 4680 -0000 OTHER IMPROVEMENTS 0 125 0 300 0 5,325 0 0 N/A Total Other Services and Charges 422,900 470,291 448,100 455,753 458,100 159,187 521,700 63,600 13.9% NON - OPERATING EXPENSES 601 -00- 4711 -0000 BOND INTEREST 77,796 18,303 17,000 16,978 17,000 16,183 14,375 (2,625) -15.4% 601 -00- 4720 -0000 FISCAL AGENT FEES 800 495 800 1,205 800 495 500 (300) -37.5% 601 -00- 4810 -0000 RESIDUAL EQUITY TRANSFERS 0 0 0 0 0 0 0 0 N/A 601 -00- 4820 -0000 OPERATING TRANSFERS 12,500 98,099 12,500 12,500 12,500 12,500 12,500 0 0.0% Total Non-Operating Expenses 91,096 116,897 30,300 30,683 30,300 29,178 27,375 (2,925) -9.7% Water Fund 2018 Budget YTD Preliminary Budget Percentage Budget Actual Budget Actual Budget 10/17/17 Budget Change Change Account Number Description 2015 2015 2016 2016 2017 2017 2018 2018 2018 Total Expenses 701,355 819,283 679,757 788,304 691,936 385,318 835,515 143,579 20.8% Change in Net Position (13,855) (237,800) (72,257) (61,175) (104,436) 248,929 (360,765) (256,329) 245.4% Depreciation 320,000 Non -Cash Bond Principal (270,000) Capital Acquisitions (1,066,000) including 750,000 potential streets CIP Principal Payment Received on 2017 Ladder Truck Lease 148,862 Payments Received on TIF Loan 0 first payment 2019 Change in Cash (1.227.9031 Sewer Fund 2018 Budget YTD Preliminary Budget Percentage Budget Actual Budget Actual Budget 10/17/17 Budget Change Change Account Number Description 2015 2015 2016 2016 2017 2017 2018 2018 2018 FUND 611 Sanitary Sewer Utility REVENUE 611 -00- 3353 -0000 PERA PENSION OTHER REVENUE 0 0 0 670 0 0 0 0 N/A 611 -00- 3362 -0000 MISC GRANTS 0 0 0 20,206 0 0 0 0 N/A 611 -00- 3400 -0000 CHARGES FOR SERVICES 6,000 0 50,000 0 50,000 0 0 (50,000) - 100.0% 611 -00- 3610 -0000 SPECIAL ASSESSMENTS - CURRENT 0 19,245 20,000 19,941 20,000 9,455 1,000 (19,000) -95.0% 611 -00- 3611 -0000 SPECIAL ASSESSMENTS - DELINQUENT 0 3,891 0 1,081 0 0 0 0 N/A 611 -00- 3614 -0000 SPECIAL ASSESSMENTS - INTEREST 0 0 0 0 0 0 0 0 N/A 611 -00- 3620 -0000 INTEREST EARNINGS 25,000 31,087 25,000 33,936 25,000 0 25,000 0 0.0% 611 -00- 3621 -0000 GAIN /(LOSS) ON INVESTMENTS 0 0 0 0 0 0 0 0 N/A 611 -00- 3670 -0000 MISCELLANEOUS REVENUE 0 0 0 0 0 0 0 0 N/A 611 -00- 3710 -0000 UTILITY REVENUE 860,050 832,830 860,050 855,527 860,050 678,586 910,000 49,950 5.8% 611 -00- 3712 -0000 UTILITY PERMIT FEES 700 0 14,000 1,400 14,000 2,100 2,000 (12,000) -85.7% 611 -00- 3720 -0000 SEWER PENALTIES 0 0 0 0 0 0 0 0 N/A 611 -00- 3725 -0000 LOCAL SAC CHARGES PAYABLE 0 2,608 0 108,805 0 74,740 5,000 5,000 N/A 611 -00- 3727 -0000 OUTSIDE SEWER REPAIR 0 2,100 0 1,050 0 1,050 600 600 N/A 611 -00- 3910 -0000 SALES OF CAPITAL ASSETS 0 0 0 0 0 0 0 0 N/A 611 -00- 3920 -0000 TRANSFERS IN 0 0 0 0 0 0 0 0 N/A REVENUE Totals: 891,750 891,761 969,050 1,042,616 969,050 765,931 943,600 (25,450) -2.6% EXPENSE 611 -00- 4101 -0000 FULL -TIME REGULAR 69,186 99,606 75,753 135,343 77,277 71,772 64,641 (12,636) -16.4% 611 -00- 4102 -0000 OVERTIME 2,500 2,500 2,500 2,580 2,500 1,752 2,500 0 0.0% 611 -00- 4103 -0000 PART -TIME 0 0 5,800 0 5,800 0 0 (5,800) - 100.0% 611 -00- 4104 -0000 TEMPORARY REGULAR 0 0 0 0 0 0 0 0 N/A 611 -00- 4105 -0000 SEWERPAGERPAY 0 4,430 0 5,532 0 4,244 5,500 5,500 N/A 611 -00- 4106 -0000 OTHER 0 0 0 0 0 0 0 0 N/A 611 -00- 4111 -0000 SEVERANCE PAY 0 0 0 0 0 0 0 0 N/A 611 -00- 4121 -0000 PERA CONTRIB - CITY SHARE 5,197 7,943 5,492 10,307 5,603 5,789 4,848 (755) -13.5% 611 -00- 4122 -0000 FICA CONTRIB - CITY SHARE 5,484 7,850 6,239 10,411 5,912 5,522 4,945 (967) -16.4% 611 -00- 4131 -0000 EMPLOYEE INSURANCE - CITY 10,787 21,434 12,072 21,166 12,072 12,541 11,048 (1,024) -8.5% 611 -00- 4141 -0000 UNEMPLOYMENT COMPENSATION 0 0 0 0 0 0 0 0 N/A 611 -00- 4151 -0000 WORKERS COMPENSATION 2,500 3,518 3,935 3,290 4,011 1,924 3,047 (964) -24.0% 611 -00- 4161 -0000 PENSION EXPENSE 0 6,573 0 31,737 0 0 32,000 32,000 N/A 4 Total Personal Services 95,654 153,854 111,791 220,366 113,175 103,544 128,529 15,354 13.6% SUPPLIES 611 -00- 4200 -0000 OFFICE SUPPLIES 150 579 200 152 200 163 200 0 0.0% 611 -00- 4208 -0000 POSTAGE 1,500 938 1,500 1,386 1,500 1,017 1,500 0 0.0% 611 -00- 4212 -0000 MOTOR FUELS & LUBRICANTS 0 0 0 0 0 0 0 0 N/A 611 -00- 4215 -0000 SHOP MATERIALS 0 0 0 0 0 0 0 0 N/A 611 -00- 4221 -0000 MAINTENANCE OF EQUIPMENT 5,000 3,060 5,000 0 5,000 311 5,000 0 0.0% 611 -00- 4223 -0000 MAINTENANCE OF BUILDINGS 0 0 0 0 0 0 0 0 N/A 611 -00- 4240 -0000 SMALL TOOLS/NIINOREQUIPMENT 550 255 550 50 550 0 550 0 0.0% 4 Sewer Fund 2018 Budget YTD Preliminary Budget Percentage Budget Actual Budget Actual Budget 10/17/17 Budget Change Change Account Number Description 2015 2015 2016 2016 2017 2017 2018 2018 2018 611 -00- 4245 -0000 GENERAL SUPPLIES Total Supplies OTHER SERVICES AND CHARGES 611 -00- 4301 -0000 AUDITING & ACCOUNTING 611 -00- 4302 -0000 CONSULTING FEES 611 -00- 4303 -0000 ENGINEERING FEES 611 -00- 4304 -0000 LEGAL FEES 611 -00- 4312 -0000 ENGINEERING 611 -00- 4321 -0000 COMMUNICATIONS - VOICE/DATA 611 -00- 4331 -0000 TRAVEL, CONFERENCE & SCHOOL 611 -00- 4351 -0000 PRINTING AND PUBLISHING 611 -00- 4360 -0000 INSURANCE 611 -00- 4380 -0000 UTILITY SERVICES 611 -00- 4385 -0000 MCES SAC Payables Charges 611 -00- 4386 -0000 Excelsior Sewer Charges 611 -00- 4400 -0000 CONTRACTUAL SERVICES 611 -00- 4410 -0000 RENTALS 611 -00- 4420 -0000 DEPRECIATION 611 -00- 4433 -0000 DUES AND SUBSCRIPTIONS 611 -00- 4437 -0000 TAXES/LICENSES 611 -00- 4440 -0000 MISC SERVICES /CONTINGENCY 611 -00- 4450 -0000 BANK SERVICE CHARGES 611 -00- 4499 -0000 FEMA ELIGLIBLE EXPENSES 611 -00- 4620 -0000 BUILDINGS & STRUCTURES 611 -00- 4640 -0000 MACHINERY & EQUIPMENT 611 -00- 4680 -0000 OTHER IMPROVEMENTS 611 -00- 4680 -0001 MCES Forcemain(DO NOT USE) 611 -00- 4680 -0011 MCES FORCEMAIN IMPROVEMENT Total Other Services and Charges NON - OPERATING EXPENSES 611 -00- 4711 -0000 BOND INTEREST 611 -00- 4720 -0000 FISCAL AGENT FEES 611 -00- 4810 -0000 RESIDUAL EQUITY TRANSFERS 611 -00- 4820 -0000 OPERATING TRANSFERS 5,000 1,289 5,000 67 Total Non - Operating Expenses 0 0.0% 1,500 4,240 Total Expenses 1,721 1,500 315 1,500 Change in Net Position 100 524 1100 366 1100 0 0.0% 9,300 4,484 9,350 2,112 9,350 1,857 9,350 0 0.0% 2,500 0 2,500 0 2,500 0 2,500 0 0.0% 0 0 0 0 0 0 0 0 N/A 5,000 (3,445) 5,000 1,289 5,000 67 5,000 0 0.0% 1,500 4,240 1,500 1,721 1,500 315 1,500 0 0.0% 5,000 0 5,000 0 5,000 0 5,000 0 0.0% 5,500 2,909 5,500 2,905 5,500 2,769 3,000 (2,500) -45.5% 1,500 0 1,500 1,310 1,500 0 1,600 100 6.7% 0 609 0 330 0 0 0 0 N/A 7,000 0 7,000 0 7,000 0 7,000 0 0.0% 7,500 (1,419) 7,500 9 7,500 (1,395) 7,500 0 0.0% 609,180 609,180 590,000 588,636 691,000 575,583 723,500 32,500 4.7% 31,000 41,976 40,000 49,366 40,000 36,982 40,000 0 0.0% 20,000 16,319 20,000 29,881 20,000 22,331 32,000 12,000 60.0% 0 0 0 0 0 0 0 0 N/A 225,000 85,424 100,000 88,236 100,000 0 100,000 0 0.0% 0 33 0 33 0 633 10,000 10,000 N/A 0 0 0 195 0 0 0 0 N/A 150 0 150 0 150 0 150 0 0.0% 1,500 0 1,500 93 1,500 753 1,500 0 0.0% 0 0 0 0 0 0 0 0 N/A 0 0 0 0 0 0 0 0 N/A 0 0 0 0 0 72,984 0 0 N/A 0 25,619 0 2,665 0 0 0 0 N/A 0 0 0 0 0 0 0 0 N/A 0 4,479 0 0 0 0 0 0 N/A 782150 766.667 888.150 711.022 940.250 51100 5.9% 0 0 0 0 0 0 0 0 N/A 0 0 0 0 0 0 0 0 N/A 0 0 0 0 0 0 0 0 N/A 239,200 598,098 239,200 12,500 239,200 12,500 12,500 (226,700) -94.8% 239,200 598,098 239,200 12,500 239,200 12,500 12,500 (226,700) -94.8% 1,266,484 1,542,362 1,147,491 1,001,645 1,249,875 828,923 1,090,629 (159,246) -12.7% (374,734) (650,601) (178,441) 40,971 (280,825) (62,992) (147,029) 133,796 -47.6% Depreciation 100,000 Non -Cash Bond Principal 0 Capital Acquisitions (200,000) Jet Vac Truck, other Change in Cash 247 0291 Stormwater Management Fund 2018 Budget YTD Preliminary Budget Percentage Budget Actual Budget Actual Budget 10/17/17 Budget Change Change Account Number Description 2015 2015 2016 2016 2017 2017 2018 2018 2018 FUND 631 Storm Water Utility REVENUE 631 -00- 3353 -0000 PERA PENSION OTHER REVENUE 0 0 0 138 0 0 0 0 N/A 631 -00- 3362 -0000 MISC GRANTS 0 0 0 0 0 0 0 0 N/A 631 -00- 3400 -0000 CHARGES FOR SERVICES 0 0 0 0 0 0 0 0 N/A 631 -00- 3610 -0000 SPECIAL ASSESSMENTS - CURRENT 7,400 5,632 7,400 5,421 7,400 2,740 500 (6,900) -93.2% 631 -00- 3611 -0000 SPECIAL ASSESSMENTS - DELINQUENT 0 939 0 790 0 0 0 0 N/A 631 -00- 3614 -0000 SPECIAL ASSESSMENTS - INTEREST 0 0 0 0 0 0 0 0 N/A 631 -00- 3620 -0000 INTEREST EARNINGS 1,200 2,242 1,200 10,421 1,200 0 5,000 3,800 316.7% 631 -00- 3621 -0000 GAIN /(LOSS) ON INVESTMENTS 0 0 0 0 0 0 0 0 N/A 631 -00- 3670 -0000 MISCELLANEOUS REVENUE 0 0 0 0 0 0 0 0 N/A 631 -00- 3710 -0000 UTILITY REVENUE 224,352 221,105 235,000 268,959 235,000 251,198 387,000 152,000 64.7% 631 -00- 3712 -0000 UTILITY PERMIT FEES 0 0 0 0 0 0 0 0 N/A 631 -00- 3720 -0000 STORM WATER PENALTIES 0 0 0 0 0 0 0 0 N/A 631 -00- 3910 -0000 SALES OF CAPITAL ASSETS 0 0 0 0 0 0 0 0 N/A 631 -00- 3920 -0000 TRANSFERS IN 226,700 500,000 226,700 0 0 0 0 0 N/A REVENUE Totals: 459,652 729,919 470,300 285,728 243,600 253,938 392,500 148,900 61.1 EXPENSE PERSONAL SERVICES 631 -00- 4101 -0000 FULL -TIME REGULAR 20,523 36,745 21,673 27,584 22,001 21,975 12,550 (9,451) -43.0% 631 -00- 4102 -0000 OVERTIME 0 65 0 332 0 749 500 500 N/A 631 -00- 4103 -0000 PART -TIME 0 0 0 0 0 0 0 0 N/A 631 -00- 4104 -0000 TEMPORARY REGULAR 0 0 0 0 0 0 0 0 N/A 631 -00- 4106 -0000 OTHER 0 0 0 0 0 0 0 0 N/A 631 -00- 4111 -0000 SEVERANCE PAY 0 0 0 0 0 0 0 0 N/A 631 -00- 4121 -0000 PERA CONTRIB - CITY SHARE 1,500 2,753 1,571 2,120 429 1,662 941 512 119.3% 631 -00- 4122 -0000 FICA CONTRIB - CITY SHARE 1,570 2,522 1,658 1,992 452 1,623 960 508 112.4% 631 -00- 4131 -0000 EMPLOYEE INSURANCE - CITY 2,059 2,568 2,850 2,566 2,850 1,726 1,472 (1,378) -48.4% 631 -00- 4141 -0000 UNEMPLOYMENT COMPENSATION 0 0 0 0 0 0 0 0 N/A 631 -00- 4151 -0000 WORKERS COMPENSATION 0 2,009 0 1,080 0 467 490 490 N/A 631 -00- 4161 -0000 PENSION EXPENSE 0 (21,346) 0 (8,261) 0 0 0 0 N/A Total Personal Services 25,652 25,316 27,752 27,413 25,732 28,202 16,913 (8,819) -34.3% SUPPLIES 631 -00- 4200 -0000 OFFICE SUPPLIES 100 304 0 152 0 163 200 200 N/A 631 -00- 4208 -0000 POSTAGE 1,400 1,215 1,400 1,386 1,400 1,017 1,400 0 0.0% 631 -00- 4212 -0000 MOTOR FUELS & LUBRICANTS 0 0 0 0 0 0 0 0 N/A 631 -00- 4215 -0000 SHOP MATERIALS 0 0 0 0 0 0 0 0 N/A 631 -00- 4221 -0000 MAINTENANCE OF EQUIPMENT 5,500 4 4,500 0 4,500 0 30,000 25,500 566.7% 631 -00- 4223 -0000 MAINTENANCE OF BUILDINGS 0 0 0 0 0 0 0 0 N/A 631 -00- 4240 -0000 SMALL TOOLS/NIINOREQUIPMENT 300 0 300 0 300 0 500 200 66.7% 631 -00- 4245 -0000 GENERAL SUPPLIES 3,000 71 2,000 370 2,000 0 3,000 1,000 50.0% Total Supplies 10,300 1,594 8,200 1,909 8,200 1,180 35,100 26,900 328.0% 6 Stormwater Management Fund 2018 Budget YTD Preliminary Budget Percentage Budget Actual Budget Actual Budget 10/17/17 Budget Change Change Account Number Description 2015 2015 2016 2016 2017 2017 2018 2018 2018 631 -00- 4301 -0000 AUDITING & ACCOUNTING 0 0 0 0 0 0 0 0 N/A 631 -00- 4302 -0000 CONSULTING FEES 0 0 0 0 0 0 0 0 N/A 631 -00- 4302 -0005 MS4 (DO NOT USE) 0 0 0 0 0 0 0 0 N/A 631 -00- 4302 -0009 MS4 SERVICES 0 5,901 0 3,869 0 1,460 0 0 N/A 631 -00- 4303 -0000 ENGINEERING FEES 20,000 19,224 20,000 27,552 20,000 14,457 35,000 15,000 75.0% 631 -00- 4304 -0000 LEGAL FEES 1,000 0 1,000 0 1,000 0 10,000 9,000 900.0% 631 -00- 4312 -0000 ENGINEERING 5,000 0 5,000 0 5,000 0 0 (5,000) - 100.0% 631 -00- 4321 -0000 COMMUNICATIONS - VOICE/DATA 500 603 500 605 500 511 500 0 0.0% 631 -00- 4331 -0000 TRAVEL, CONFERENCE & SCHOOL 0 0 0 0 0 0 800 800 N/A 631 -00- 4351 -0000 PRINTING AND PUBLISHING 100 142 100 0 100 41 100 0 0.0% 631 -00- 4360 -0000 INSURANCE 0 0 0 0 0 0 0 0 N/A 631 -00- 4380 -0000 UTILITY SERVICES 0 0 0 0 0 0 0 0 N/A 631 -00- 4400 -0000 CONTRACTUAL SERVICES 71,500 2,164 71,500 5,883 71,500 8,771 83,500 12,000 16.8% 631 -00- 4410 -0000 RENTALS 0 226 0 0 0 0 0 0 N/A 631 -00- 4420 -0000 DEPRECIATION 34,000 44,109 40,000 44,110 45,000 0 46,000 1,000 2.2% 631 -00- 4433 -0000 DUES AND SUBSCRIPTIONS 6,600 33 6,600 33 6,600 633 10,000 3,400 51.5% 631 -00- 4437 -0000 TAXES/LICENSES 0 0 0 0 0 0 0 0 N/A 631 -00- 4440 -0000 MISC SERVICES /CONTINGENCY 1,100 0 1,100 0 1,100 0 0 (1,100) - 100.0% 631 -00- 4450 -0000 BANK SERVICE CHARGES 1,000 0 1,000 0 1,000 0 1,000 0 0.0% 631 -00- 4499 -0000 FEMA ELIGLIBLE EXPENSES 0 0 0 0 0 0 0 0 N/A 631 -00- 4620 -0000 BUILDINGS & STRUCTURES 0 0 0 0 0 0 0 0 N/A 631 -00- 4640 -0000 MACHINERY & EQUIPMENT 0 0 0 0 0 0 0 0 N/A 631 -00- 4680 -0000 OTHER IMPROVEMENTS 0 0 0 0 0 0 0 0 N/A Total Other Services and Charges 140,800 72,402 146,800 82,051 151,800 25,873 186,900 35,100 23.1 NON - OPERATING EXPENSES 631 -00- 4810 -0000 RESIDUAL EQUITY TRANSFERS 0 0 0 0 0 0 0 0 N/A 631 -00- 4820 -0000 OPERATING TRANSFERS 0 73,924 0 0 0 0 0 0 N/A Total Non-Operating Expenses 0 73,924 0 0 0 0 0 0 N/A Total Expenses 176,752 173,236 182,752 111,373 185,732 55,255 238,913 53,181 28.6% Change in Net Position 282,900 556,683 287,548 174,355 57,868 198,683 153,587 95,719 165.4% Depreciation 46,000 Non -Cash Bond Principal 0 Capital Acquisitions (635,110) Change in Cash (4355231 7 Recycling Fund 2018 Budget YTD Preliminary Budget Percentage Budget Actual Budget Actual Budget 10/17/17 Budget Change Change Account Number Description 2015 2015 2016 2016 2017 2017 2018 2018 2018 FUND 621 Recycling Utility REVENUE 621 -00- 3353 -0000 PERA PENSION OTHER REVENUE 0 0 0 49 0 0 0 0 N/A 621 -00- 3362 -0000 MISC GRANTS 23,000 26,198 23,000 26,912 23,000 23,235 20,100 (2,900) -12.6% 621 -00- 3400 -0000 CHARGES FOR SERVICES 0 0 0 0 0 0 0 0 N/A 621 -00- 3610 -0000 SPECIAL ASSESSMENTS - CURRENT 0 3,932 0 3,867 0 1,847 300 300 N/A 621 -00- 3611 -0000 SPECIAL ASSESSMENTS - DELINQUENT 0 681 0 194 0 0 0 0 N/A 621 -00- 3614 -0000 SPECIAL ASSESSMENTS - INTEREST 0 0 0 0 0 0 0 0 N/A 621 -00- 3620 -0000 INTEREST EARNINGS 350 1,150 350 2,407 350 0 1,000 650 185.7% 621 -00- 3621 -0000 GAIN /(LOSS) ON INVESTMENTS 0 0 0 0 0 0 0 0 N/A 621 -00- 3623 -0000 CONTRIBUTIONS AND DONATIONS 0 0 0 0 0 0 0 0 N/A 621 -00- 3670 -0000 MISCELLANEOUS REVENUE 0 0 0 0 0 120 0 0 N/A 621 -00- 3710 -0000 UTILITY REVENUE 155,000 155,250 155,000 154,550 155,000 119,803 155,000 0 0.0% 621 -00- 3720 -0000 RECYCLING PENALTIES 0 0 0 0 0 0 0 0 N/A 621 -00- 3732 -0000 CITY CLEANUP CHARGES 8,000 (4,934) 8,000 (4,431) 8,000 (4,390) 8,000 0 0.0% 621 -00- 3920 -0000 TRANSFERS IN 0 0 0 0 0 0 0 0 N/A REVENUE Totals: 186,350 182,277 186,350 183,549 186,350 140,615 184,400 (1,950) -1.0% EXPENSE PERSONAL SERVICES 621 -00- 4101 -0000 FULL -TIME REGULAR 5,410 8,548 5,796 9,344 5,912 8,570 6,111 199 3.4% 621 -00- 4102 -0000 OVERTIME 1,000 887 1,000 661 1,000 712 0 (1,000) - 100.0% 621 -00- 4103 -0000 PART -TIME 0 198 0 0 0 68 0 0 N/A 621 -00- 4104 -0000 TEMPORARY REGULAR 0 0 0 0 0 0 0 0 N/A 621 -00- 4106 -0000 OTHER 0 0 0 0 0 0 0 0 N/A 621 -00- 4111 -0000 SEVERANCE PAY 0 0 0 0 0 0 0 0 N/A 621 -00- 4121 -0000 PERA CONTRIB - CITY SHARE 475 708 420 757 429 696 458 29 6.8% 621 -00- 4122 -0000 FICA CONTRIB - CITY SHARE 500 562 443 670 452 656 467 15 3.3% 621 -00- 4131 -0000 EMPLOYEE INSURANCE - CITY 717 1,530 1,140 1,687 1,140 1,438 1,296 156 13.7% 621 -00- 4141 -0000 UNEMPLOYMENT COMPENSATION 0 0 0 0 0 0 0 0 N/A 621 -00- 4151 -0000 WORKERS COMPENSATION 0 21 46 69 47 78 49 2 4.3% 621 -00- 4161 -0000 PENSION EXPENSE 0 1,221 0 684 0 0 0 0 N/A Total Personal Services 8,102 13,675 8,845 13,872 8,980 12,218 8,381 (599) -6.7% SUPPLIES 621 -00- 4200 -0000 OFFICE SUPPLIES 100 304 100 152 100 163 100 0 0.0% 621 -00- 4208 -0000 POSTAGE 1,400 1,215 1,400 1,386 1,400 1,017 1,400 0 0.0% 621 -00- 4221 -0000 MAINTENANCE OF EQUIPMENT 0 0 0 0 0 0 0 0 N/A 621 -00- 4223 -0000 MAINTENANCE OF BUILDINGS 0 0 0 0 0 0 0 0 N/A 621 -00- 4240 -0000 SMALL TOOLS/NIINOREQUIPMENT 0 0 0 0 0 0 0 0 N/A 621 -00- 4245 -0000 GENERAL SUPPLIES 200 0 200 0 200 0 200 0 0.0% Total Supplies 1,700 1,519 1,700 1,538 1,700 1,180 1,700 0 0.0% OTHER SERVICES AND CHARGES 8 Recycling Fund 2018 Budget YTD Preliminary Budget Percentage Budget Actual Budget Actual Budget 10/17/17 Budget Change Change Account Number Description 2015 2015 2016 2016 2017 2017 2018 2018 2018 621 -00- 4301 -0000 AUDITING & ACCOUNTING 621 -00- 4302 -0000 CONSULTING FEES 621 -00- 4303 -0000 ENGINEERING FEES 621 -00- 4304 -0000 LEGAL FEES 621 -00- 4312 -0000 ENGINEERING 621 -00- 4321 -0000 CONINIONICATIONS - VOICE/DATA 621 -00- 4331 -0000 TRAVEL, CONFERENCE & SCHOOL 621 -00- 4351 -0000 PRINTING AND PUBLISHING 621 -00- 4360 -0000 INSURANCE 621 -00- 4380 -0000 UTILITY SERVICES 621 -00- 4400 -0000 CONTRACTUAL SERVICES 621 -00- 4400 -0026 ORGANIC GARBAGE 621 -00- 4410 -0000 RENTALS 621 -00- 4420 -0000 DEPRECIATION 621 -00- 4433 -0000 DUES AND SUBSCRIPTIONS 621 -00- 4437 -0000 TAXES/LICENSES 621 -00- 4440 -0000 NIISC SERVICES /CONTINGENCY 621 -00- 4450 -0000 BANK SERVICE CHARGES 0 0 0 Total Other Services and Charges NON - OPERATING EXPENSES 621 -00- 4810 -0000 RESIDUAL EQUITY TRANSFERS 621 -00- 4820 -0000 OPERATING TRANSFERS 0 0 0 Total Non - Operating Expenses N/A 117,000 115,742 Total Expenses 116,967 117,000 98,829 Change in Net Position 0 0 0 0 0 0 0 0 N/A 0 0 0 0 0 0 0 0 N/A 0 0 0 0 0 0 0 0 N/A 0 0 0 0 0 0 0 0 N/A 0 0 0 0 0 0 0 0 N/A 0 0 0 0 0 0 0 0 N/A 0 0 0 65 0 58 0 0 N/A 0 103 0 137 0 420 150 150 N/A 0 0 0 0 0 0 0 0 N/A 0 0 0 0 0 0 0 0 N/A 117,000 115,742 117,000 116,967 117,000 98,829 117,000 0 0.0% 0 0 0 0 0 177 0 0 N/A 0 0 0 0 0 0 0 0 N/A 0 0 0 0 0 0 0 0 N/A 0 0 0 75 0 0 0 0 N/A 0 0 0 0 0 0 0 0 N/A 8,500 146 8,500 0 8,500 160 8,500 0 0.0% 0 0 0 0 0 0 0 0 N/A 125.500 115.991 125.500 117.244 125.500 99.644 125.650 150 0.1 0 0 0 0 0 0 0 0 N/A 0 0 0 0 0 0 0 0 N/A 0 0 0 0 0 0 0 0 N/A 135,302 131,185 136,045 132,654 136,180 113,042 135,731 (449) -0.3% 51,048 51,092 50,305 50,895 50,170 27,573 48,669 (1,501) -3.0% 9