Loading...
HomeMy WebLinkAboutAgenda Packets - 2017/12/04 (3)CITY OF MOUNDS VIEW CITY COUNCIL WORK SESSION AGENDA MOUNDS VIEW CITY HALL Monday, December 4, 2017 7:00 p.m. ROLL CALL: Mueller, Gunn, Hull, Meehlhause, Bergeron PUBLIC COMMENT Citizens may speak to issues not on tonight's agenda. Before speaking, please give your full name and address for the minutes. Also, please limit your comments to three minutes. Agenda Items Discussed by Consensus 1. Review Community Center Proposals 2. Discussion of Comprehensive Plan 3. Review Predevelopment Agreement for INH Properties 4. 2018 Draft Municipal Budget Next Work Session: TUESDAY, January 2, 2018 immediately following the Special Council Meeting at 6 pm Next City Council Meeting: December 11, 2017 at 6 pm of Mounds View Staff R Item No: 1 Meeting Date: December 4, 2017 Type of Business: Work S ssion Administrator review: To: Honorable Mayor and City Council From: Mark Beer, Finance Director Item Title/Subject: Review Community Center Proposals Introduction: The Creative Kids Academy lease will expire at the end of July 2018. The City Council directed staff to seek proposals for use of the space from Creative Kids Academy and the YMCA of the Greater Twin Cities. City staff opened both proposals on Monday, November 20, 2017 with representatives from both interested parties present. Each representative was provided with copies of both proposals. Background: The lease space is approximately 8,300 square feet of space at the Community Center. The space is ideally suited for a child care operation as the original build -out of the space had such a use in mind. There has been a childcare business operating almost continuously in the Community Center since it opened in 1997. Children's Home Society, a nonprofit entity, was the original provider of services in that space. They closed their operations on short notice in 1999 or thereabouts, after which time the City considered other entities to fill the space. In 2001, the City entered into a five-year lease agreement with Creative Kids and renewed that lease in 2006. In 2008, the owner of Creative Kids indicated she had reached an agreement to sell the business and the City subsequently approved an assignment of the lease to Creative Kids Academy. Creative Kids Academy had subsequently renewed the lease for an additional 5 year term in 2013. Discussion: Representatives from Creative Kids Academy and the YMCA of the Greater Twin Cities are present and will be given 10 minutes each to present their respective proposals. Once both proposals have been presented the City Council can ask follow-up questions. Both parties agree that a decision sooner is better than later. Recommendation: Staff would like some input and feedback from the City Council as to how you would like to proceed. Attached is a summary of both proposal and the individual proposals for your consideration. Respectfully submitted, Mark Beer, Finance Di ctor Creative Kids Academy YMCA of the Greater Twin Cities City of Mounds View Community Center Proposals Proposed Proposed Pay Rent per Annual Lease Rent Property Janitorial Use of Month Rent Term Inflator Taxes Services Kitchen 11,000 132,000 5 years none noted Yes No Yes 7,437 89,244 5 years lessor of Yes Yes No inflation Proposed or 3% $15,000 3% inflator 2017 Rent 7,274.75 87,297 2017 Taxes 7,894 2018 Taxes preliminary B4 School Referendum 8,742 2017 Janitorial 16,207 Inflation for 2018 Rent 2.23% September 25111, 2017 Mr. Nyle Zikmund Interim City Administrator for City of Mounds View 2401 Highway 10 Mounds View, MN 55112 RE: Renewal of the Mounds View Community Center Lease for Creative Kids Academy Dear Mr. Zikmund, Mr. Ericson had requested our written proposal for renewing our current lease between the City of Mounds View and Creative Kids Academy (CKA). We are very interested in continuing to provide quality childcare and early education to the community and fostering our relationship with the city. We have been a committed partner with the City of Mounds View for over 15 years, a model tenant, have served over 2000 children as well as families, and have made significant investment in the community through this relationship. The following is our lease renewal proposal: • Rent would increase to $11,000 per month effective August 1, 2018, an increase of 52% from the current rent of $7274.75. • Creative Kids Academy would be financially responsible for the property tax for the portion of the building occupied by CKA. • Lease term of five years effective August 1, 2018. We provide these unique benefits to the community as a provider which should be considered: • Access to over $200,000 in reduced or free childcare grants. • FREE enrichment programs to children such as Yoga, Music, Spanish classes, Karate, Gardening, story telling and more. • FREE local transportation to and from schools for before and after school children. • FREE breakfast, snacks and lunch to all children. • Highest accreditation by NAEYC and MN parent aware that attests to our quality based early childhood education programming. • Continued vibrant participation in the Mounds View community by collaborating with local schools, and educating, employing, and housing the citizens of our community. Retaining us will ensure the continued access to quality child care without the resultant disruptions to families children staff and community. Any new provider would not have accreditation status or access to the scholarship grants. It is unlikely that a new provider would retain our free enrichment programming transportation, andfor nutritional meals. We sincerely appreciate our relationship with the city and hope we can continue to provide services that contribute to the prosperity to the famili of our community. -' - _J Rajiv Garg Sangeeta Jain EARLY CHILDHOOD CENTER EXECUTIVE SUMMARY Contact: Andy Thomas Mounds View 763-717-4036 Andrew.Thomas@YMCAMN.orq The YMCA of the Greater Twin Cities (YGTC) is proposing to lease the childcare center attached to the Community Center at 5394 Edgewood Drive. The terms would be similar to the current lease the city holds: Terms: August 1, 2018 thru July 31, 2023. Rent: Base rent plus utilities and maintenance is $87,297 per year (2017) increase based on CPI; within 0%-3%. Property taxes: The YMCA would agree to pay the property taxes until non-profit exemption goes into effect. Shared Space: YMCA would not need access to the licensed kitchen for feeding the youth. '►�I�Z�3Ilt`trt7 With the Early Childhood Learning Center (ECLC) operations, the YMCA is also proposing to provide custodial staffing operations for the entire building. We propose the YMCA would provide custodial services for the Mounds View Community Center and the ECLC. In return, the City of Mounds View would pay the YMCA $15,000 annually with a 3% increase in years 2-5. This would eliminate the need for a contracted custodial service the city is currently using in the Community Center. The Event Center staffing via the current Community Center contract would remain for hosting events. City Staff would focus on facility maintenance, lawn care, and snow removal. City staff would provide and control the chemicals and equipment used to clean its facility. YMCA custodial staff will be able to clean the building more efficiently following usage and programming closely. In addition, the YMCA can leverage a larger custodial staffing pool and change the structure of cleaning schedule based on seasonal needs of the building and programming. MovNns VfE—W City of Mounds View Staff R Item No: 2 Meeting Date: December 4, 2017 Type of Business: Work Session Administrator Review: To: Honorable Mayor and City Council From: Jon Sevald, City Planner/Supervisor Item Title/Subject: Discussion of Comprehensive Plan Introduction: The Comprehensive Plan (the Plan) is a 20 -year guide for land use and development, and is required to be updated every ten years. The Plan will be written by Staff and Stantec. The purpose of tonight's discussion is: 1. Discussion of Councilmember's vision for the Community 2. Discussion of the Comprehensive Plan Taskforce Discussion of Councilmember's vision for the Community Beth Elliot of Stantec will lead a discussion of the community's strengths and opportunities. Each Council member will be asked to tell their vision of the Community in six words or less (AKA "six word story"). The Six Word Story is a practice in writing, inspired by Ernest Hemmingway's "For sale: baby shoes, never worn". The intent is for the Council to think about their vision for Mounds View. This will set the tone for the Comprehensive Plan. Question: (1) In your opinion, what are the community's strengths & opportunities? (2) What is your six word story for Mounds View? Discussion of the Comprehensive Plan Taskforce At the December 11th City Council meeting, the Council will be asked to appoint a Comprehensive Plan Taskforce, representing (1) City Council, (2) Economic Development Commission; (2) Parks and Recreation, and Forestry Commission; (2) Planning Commission; and (2) At -Large Residents. The Council representative will be asked to Chair the Taskforce. Taskforce meetings will be scheduled twice per month, as needed. If the Council would like these meetings to be televised, the only regular dates available are the second and fourth Tuesdays of the month. Question: Does the Council want these meetings to be televised? Respectfully submitted, A-60... Jon Seval ICP City Planner/Supervisor 11111oll of Mounds View Staff R Item No: 3 Meeting Date: December 4, 2017 Type of Business: Work Session Administrator Review: To: Honorable Mayor and City Council From: Brian Beeman, Business Development Coordinator Item Title/Subject: Review Predevelopment Agreement with INH Properties Introduction: Crossroad Pointe is a 4.25 acre city owned redevelopment site that the City has been marketing for past few years in order to attract a developer that fits the highest and best use for the site. At the August 21, 2017 Council Worksession three developers presented their proposals to the City Council and the Council chose to work with INH Properties who is proposing to build an approximately 124 unit market rate apartment building and a stand- alone destination retail component. The Developer would prefer to start construction in 2018. Discussion As a next step in the redevelopment process a predevelopment agreement has been drafted. A predevelopment agreement allows the developer to have legal access to the site for one year in order to conduct its due diligence such as soil borings, site measurements, etc. The agreement also exclusively ensures INH Properties that the City won't sell the land from underneath the developer while they are trying to conduct their due diligence. A predevelopment agreement outlines the basic terms and conditions of a contract for private redevelopment to be entered into by the redeveloper and seller. The pre - development agreement is not deemed conclusive or binding upon either party except the section regarding due diligence or Exclusive Period, and fees. It does define the parties, specify the property to be developed, outline the conditions, allows time to negotiate a purchase price, due diligence, closing date, covenants, debt, fees, miscellaneous items, and termination. City staff and INH Properties have entered into several conversations and have arrived at a verbal consensus regarding the predevelopment agreement. The City Attorney has reviewed the predevelopment agreement and any recommended changes have been made. Any fees specified in the agreement have been collected and an escrow account has been established. Crossroad Pointe Staff Report December 4, 2017 Page 2 Recommendation Staff recommends the City Council review the attached predevelopment agreement and provide any additional changes if necessary. Staff will make the changes and prepare a resolution for consideration at the January 8, 2018 regular City Council meeting. Respectfully submitted, Brian Beeman Business Development Coordinator Attachments: 1. Predevelopment Agreement DRAFT NOT APPROVED MOUNDS VIEW ECONOMIC DEVELOPMENT AUTHORITY AND INH PROPERTIES PRELIMINARY DEVELOPMENT AGREEMENT THIS AGREEMENT, dated this day of , 2018 (the "Effective Date"), by and between the Mounds View Economic Development Authority, a public body corporate and politic under the laws of Minnesota ("EDA") and INH Property Management, Inc., a Minnesota corporation d/b/a INH Properties ("Developer") or its assigns: WITNESSETH: WHEREAS, EDA desires to promote development of certain property owned by the City of Mounds View Economic Development Authority known as Crossroad Pointe, located at 2390 and 2394 Mounds View Boulevard and 2400 County Road H2, in the City of Mounds View, State of Minnesota, which property is described and depicted in Exhibit A attached hereto ("Property"); and WHEREAS, Developer, or a special purpose entity to be formed by the Developer for the purpose of completing this project, has submitted or is in the process of submitting a proposal ("Proposal") for development of an approximately 124 unit (one hundred percent) market rate apartment building (subject to Section 10 of this Agreement) on a portion of the Property ("Multi- family Development"), which proposal is attached hereto as Exhibit C; and WHEREAS, Developer, or a special purpose entity to be formed by the Developer for the purpose of completing this project, has submitted or is in the process of submitting a proposal ("Proposal") for development of an approximately 124 unit (one Hundred percent) market rate apartment building (subject to Section 10 of this Agreement) on a portion of the Property ("Traditional Retail Development"), which proposal is attached hereto as Exhibit D; and WHEREAS, Developer, is proposing an approximately 15,000-20,000 square foot Heartland Gun Club & Range on a portion of the property ("Specialty Retail Development"), which proposal is attached hereto as Exhibit B; and WHEREAS, Developer, is proposing as an alternate or in conjunction with the special retail an approximately 3,000-5,000 square foot traditional retail portion of the development, which proposal is attached hereto as Exhibit D; and WHEREAS, the Development shall occur on the portion of the Property located at 2400 County Road H2 and legally described in Exhibit A attached hereto; and WHEREAS, EDA desires a retail and Heartland Gun Club & Range to be constructed on the remaining portion of the Property ("Traditional Retail and Specialty Retail Development"); and WHEREAS, EDA desires all three parcels, approximately 4.25 acres and all phases of development to be completed in its entirety by the end of 2020. DRAFT NOT APPROVED WHEREAS, EDA and Developer are interested in discussing and further planning for the Developer's proposal for the Development; and WHEREAS, Developer has indicated to the EDA that the Heartland Gun Club & Range component of the development will be 100% financed privately and is not asking for any business subsidies; and WHEREAS, Developer had indicated that it may seek business subsidy assistance from the City of Mounds View ("City") and/or the EDA to make the apartment and traditional retail portion of the Development feasible; and WHEREAS, the City or the EDA will need to determine if various studies as may be determined to be reasonably necessary should be conducted, including without limitation an environmental impact or related study (if determined by the City or EDA to be necessary for the Development), an infrastructure feasibility study (if determined by the City or EDA to be necessary for the Development), an economic impact study (if determined by the City or EDA to be necessary for the Development), and WHEREAS, the City and the EDA will continue to discuss and negotiate with Developer land costs and other fees required for the successful completion of the Development; and WHEREAS, the City and the EDA are willing to discuss with Developer available public subsidies for the Development; and WHEREAS, various ordinance, land use, zoning, and subdivision issues and actions related to the Development and the Property are required to be approved by the City in order to facilitate the Development by the Developer; and WHEREAS, EDA agrees to cooperate with the Developer to review and process various ordinance, land use, zoning, and subdivision issues and actions related to the Development and the Property in order to facilitate the Development by the Developer; and WHEREAS, EDA is willing to consider and Developer is desirous to undertake the Development if (i) a satisfactory agreement can be reached regarding EDA's commitment for public costs, if any, necessary for the Development; (ii) satisfactory mortgage and equity financing, or adequate cash resources for the Development can be secured by Developer; and (iii) the feasibility and soundness of the Development and other necessary preconditions have been determined to the satisfaction of the parties. NOW, THEREFORE, in consideration of the foregoing and of the mutual covenants and obligations set forth herein, the parties agree as follows: 1. Future Negotiations. The parties agree to continue negotiations in an attempt to formulate a definitive plan for review and approval of all land use, zoning and subdivision approvals and any necessary development agreements or contracts based on the following: 2 DRAFT NOT APPROVED (a) Developer's Proposal, which shows the scope of the proposed Development in its latest form as of the date of this Agreement, together with any changes or modifications required by City or EDA; (b) Mutually satisfactory development agreements or contracts to be negotiated and agreed upon in accordance with negotiations contemplated by this Agreement; (c) Mutually satisfactory terms for the Specialty Retail & Traditional Retail and Multi -family Developments that may be required for the Development (e.g. access and utility easements, allocation of infrastructure costs, identity of proposed retail use, etc.); and (d) Other terms and conditions of this Agreement. 2. Statement of Intent. Although not conclusive or binding on either party, it is the intention of the parties that this Agreement: (a) documents the present understanding and commitments of the parties; (b) will lead to negotiation and execution of a mutually satisfactory development agreement or contract prior to the termination date of this Agreement; and (c) will lead to an appropriate land use, zoning, and subdivision application or applications. The development agreement or contract (together with any other agreements entered into between the parties hereto contemporaneously therewith) when executed and any land use, zoning, and subdivision approvals, will supersede all obligations of the parties hereunder. 3. Term; Duties. (a) During the term of this Agreement, EDA agrees to: (i) Proceed to seek all necessary information with regard to the anticipated public costs, if any, associated with the Development. (ii) Should negotiations be successful, enter into a development agreement with the Developer for the Development. (b) During the term of this Agreement, Developer agrees to: (i) Develop and submit its detailed proposal, including the plans and specifications, for purchase and development of the Development. (ii) Conduct a due diligence review of the portion of the Property included in the Development, including without limitation, which must be acceptable to the Developer in its sole discretion: title, survey, environmental (Phase I & Phase 11 reports), soils, and market studies. (iii) Obtain approval by the EDA, City (including its Engineer, Planning and Inspection Department, and any other governing authority) for approval of the site plan, exterior elevations and finishes, PUD approval. DRAFT NOT APPROVED (iv) Obtain any other necessary governmental approval from any governing authority. (v) Obtain financing on terms acceptable to Developer, including but not limited to public subsidies (such as pay-as-you-go TIF in a mutually agreeable amount), private loans and equity investment. (vi) Should negotiations be successful, enter into a development agreement with the EDA for the Development. 4. Business Subsidies; TIF. (a) EDA understands that the Developer may be seeking business subsidy assistance from the City or the EDA. During the term of this Agreement, Developer shall: (i) Submit to EDA a design proposal to be reviewed by EDA showing the location, size, and nature of the proposed Development, including layouts, renderings, elevations, and other graphic or written explanations of the Development. The design proposal shall be accompanied by a proposed schedule for the starting and completion of the Development. (ii) Submit an over-all cost estimate for the design and construction of the Development. (iii) Submit a time schedule for the Development. (iv) Undertake and obtain such other preliminary economic feasibility studies, income and expense projections, and such other economic information as Developer may desire to further confirm the economic feasibility and soundness of the Development. (v) Submit to EDA the Developer's financing plan showing that the proposed Development is financially feasible. (vi) Furnish satisfactory, financial data to EDA evidencing Developer's ability to undertake the Development. (vii) Furnish information in its possession and assist the EDA with obtaining all available business subsidy assistance. (b) Developer understands that the Tax Increment Financing sought for the proposed Development must be obtained as outlined by law. The EDA agrees in any development agreement or contract entered into as contemplated herein that the EDA will review and consider such financing as allowed by law, but no provision shall be construed as an affirmative approval of such financing until such time that a separate Tax Increment Financing agreement is entered into by both parties. M DRAFT NOT APPROVED Feasibility. It is expressly understood that execution and implementation of any development agreement or contract (together with any other agreements entered into between the parties hereto contemporaneously therewith) and any land use, zoning and subdivision approvals shall be subject to: (a) A determination by EDA in its sole discretion that its undertakings are feasible based on (i) satisfaction of City Code requirements; (ii) the purposes and objectives of any development plan created or proposed for the Development; (iii) the Studies, if any; and (iv) the best interests of EDA. (b) A determination by Developer that the Development is feasible and in the best interests of Developer. 6. Effective Date; Expiration. This Agreement is effective from the Effective Date until one (1) year after the Effective Date. After such date, neither party shall have any obligation hereunder except as expressly set forth to the contrary herein. 7. Costs; Escrow. Developer shall be solely responsible for all costs incurred by Developer. In addition, upon the full execution of this Agreement the Developer will pay the EDA an initial non-refundable sum of $7,500 as reimbursement of its Administrative Costs (as defined below) for its evaluation of the Developer's proposal. For the purposes of this Agreement, the term "Administrative Costs" means out of pocket costs incurred by EDA together with staff and consultant (including engineering, legal, financial adviser, environmental advisor, planning advisor, etc.) costs of EDA, all attributable to or incurred in connection with the review of the development agreement or contracts (together with any other agreements entered into between the parties hereto contemporaneously therewith) and review and approvals of any land use, zoning and subdivision applications for the Property, the negotiation and preparation of this Agreement, and other documents and agreements in connection with the Development, excluding Studies that result in the Administrative Costs exceeding the initial $7,500 deposit, unless such excess costs are approved by the Developer as provided below. Developer acknowledges that the Developer's proposal will require review by and/or consultation with the EDA's financial advisors, engineers, legal advisors, and other advisors or consultants and staff. Additionally, the EDA may incur expenses of advisors, consultants and staff related to the preparation of the development agreement for said Development. If at any time after full execution and acceptance of this Agreement, the EDA determines that the amount deposited by Developer will be insufficient to pay the FDA's fees and expenses listed above, the EDA may notify the Developer in writing as to any additional amount required to be deposited. The Developer must deposit such additional funds within 10 business days after receipt of the EDA's notice. Any additional funds beyond the initial non- refundable $7,500 deposited by Developer and not expended by the EDA for its Administrative Costs will be returned to the Developer on the Closing Date. Any public subsidies applied for by the Developer will require separate application fees and deposits from the fees stated in this 5 DRAFT NOT APPROVED Preliminary Development Agreement as it pertains to the appropriate public subsidy application. The foregoing funds will not be credited towards the purchase price or returned if the transaction does not close. This Section 7 shall survive termination of this Agreement and shall be binding on the Developer and the EDA regardless of the enforceability of any other provision of this Agreement. 8. Termination. This Agreement may be terminated if Developer ceases to negotiate in good faith with the EDA, and such failure to negotiate in good faith is not cured after 30 days written notice of such failure by EDA to Developer. 9. Sole Developer. Developer is designated as sole developer and shall have exclusive rights of the Development of the Property for a period on one (1) year from the Effective Date. The EDA agrees not to market the Property or to make, accept, negotiate, or otherwise pursue any other offers for sale or purchase of the Development portion of the Property until this Agreement expires after such one (1) year period or is terminated pursuant to Section 8 herein. For purposes of clarity INH Properties or assigns whose Principal is James E. Illies will own the entire three parcels and will be developing the housing and general retail portion of the property. As an option, INH Properties reserves the right to sell a portion of the property to a specialty retail user. James E. Illies is designated as the point person and main contact for both the INH development and the Heartland Gun Club & Range (specialty retail) portion of the project. Greg Moore, will be representing the Heartland Gun Club & Range as a partner with Pat Egan and will receive notices as provided in Section 13. The address for the specialty retail is, Heartland Gun Club & Range, Pat Egan, 6503 Shadow Lane, Chanhassen, MN 55317. 10. Apartment Development. Notwithstanding anything herein to the contrary, EDA acknowledges that the number of units for the multi -family apartment developments have not been determined and that it is estimated to be between approximately 100 and 160 units. In addition, notwithstanding anything herein to the contrary, in the event the City or EDA does not allow or rejects any of the retail or specialty retail development contemplated hereunder, the proposed apartment development contemplated hereunder shall not be affected and the parties shall continue to proceed with the negotiations for the proposed apartment developments as provided in this Agreement. 11. Severability. If any portion of this Agreement is held invalid by a court of competent jurisdiction, such decision shall not affect the validity of any remaining portion of the Agreement. M DRAFT NOT APPROVED 12. Breach; Waiver. In the event any covenant contained in this Agreement should be breached by one party and subsequently waived by another party, such waiver shall be limited to the particular breach so waived and shall not be deemed to waive any other concurrent, previous or subsequent breach. 13. Notice. Notice or demand or other communication between or among the parties shall be sufficiently given if sent by mail, postage prepaid, return receipt requested or delivered personally: (a) As to EDA: Mounds View Economic Development Authority 2401 Mounds View Boulevard Mounds View, MN 55112 Attn: City Administrator (b) As to Developer (c) As to Developer: 14, Counterparts. INH Properties 1757 th Avenue South Waite Park, MN 56387 Attn: James E. Illies, Principal Heartland Gun Club & Range 6503 Shadow Lane Chanhassen, MN 55317 Attn: Pat Egan & Greg Moore This Agreement may be executed simultaneously in any number of counterparts, all of which shall constitute one and the same instrument. 15. Governing Law. This Agreement shall be governed by and construed in accordance with the laws of the state of Minnesota. Any disputes, controversies, or claims arising out of this Agreement shall be heard in the state or federal courts of Minnesota, and all parties to this Agreement waive any objection to the jurisdiction of these courts, whether based on convenience or otherwise. 16. Additional Actions. The parties hereto understand that additional and separate actions, for which no obligation is created hereunder, will be required before either the EDA or Developer is obligated to take various actions with respect to the Development. Those actions include, but are not limited to: (a) Zoning, comprehensive plan, and subdivision approvals for any land use or development proposed by Developer; and 7 DRAFT NOT APPROVED (b) Review of any Tax Increment Financing arrangement, or other business subsidy, as required by law. 17. Incorporation. The Recitals set forth in the preamble to this Agreement and the Exhibits attached to this Agreement are incorporated into this Agreement as if fully set forth herein. [REMAINDER OF PAGE INTENTIONALLY LEFT BLANK] 8 DRAFT NOT APPROVED IN WITNESS WHEREOF, the Developer has caused this Agreement to be duly executed in its name and behalf and the EDA has caused this Agreement to be duly executed in its name and behalf as of the day and year first above written. DEVELOPER: INH PROPERTIES M. Its: I �• MOUNDS VIEW ECONOMIC DEVELOPMENT AUTHORITY By: Carol Mueller Its: President By: Nyle Zikmund Its: (Interim) Executive Director 9 DRAFT NOT APPROVED EXHIBIT A DESCRIPTION/DEPICTION OF PROPERTY The property located at 2390 Mounds View Boulevard, 2394 Mounds View Boulevard, 2400 County Road H2, all in Mounds View, Minnesota, as depicted below. [Insert Description/Depiction] s A- I DRAFT NOT APPROVED EXHIBIT A DESCRIPTION/DEPICTION OF PROPERTY Ramsey County Parcel Report 2400 County Road H2 Parcel location within Ramsey County 2400 County Road H2 Mounds View Boulevard Mounds View, MN 55112-4709 Parcel I D : 0830 23310005 Owners: Mounds View Economic Development Authority Tax lot highlighted in red Plat Name: SECTION 8 TOWN 30 RANGE 23 Tax Description: The N 363 Ft Of W 330 Ft Of Ne 1/4 Of Sw 1/4 (subj To Roads) Of Sec 8 Tn 30 Rn 23 Area: 2.05 Acres Rice Creek Watershed A-1 DRAFT NOT APPROVED EXHIBIT A DESCRIPTION/DEPICTION OF PROPERTY Ramsey County Parcel Report 2394 Mounds View Boulevard 11' N � Fz Parcel location within Ramsey County 2394 Mounds View Boulevard Mounds View, MN 55112-4922 Parcel ID: 083023310071 Owners: Mounds View Economic Development Authority Plat Name: SECTION 8 TOWN 30 RANGE 23 Tax Description: Part Of Ne 1/4 Of Sw 1/4 Desc As Fol; Beg At A Point On The Centerline Of Greenfield Ave 365.46 Ft S Of The N Line Of Sd 1/4 1/4, Th N Along Centerline Of Sd Ave 255 Ft, Th E Par With N Line Of Sd 1/4 1/4 For 47.07ft Th Sely To A Pt 193.01ft S Of N Line & Area: 0.48 Acres Rice Creek Watershed A-1 DRAFT NOT APPROVED EXHIBIT A DESCRIPTION/DEPICTION OF PROPERTY Ramsey County Parcel Report 2390 Mounds View Boulevard <1 Parcel location within Ramsey County 2390 Mounds View Boulevard Mounds View, MN 55112-4922 Parcel ID: 083023310072 Owners: Mounds View Economic Development Authority Plat Name: SECTION 8 TOWN 30 RANGE 23 Tax Description: Part Of Ne 1/4 Of Sw 1/4 Desc As Fol; Beg On Center Line Of Greenfield Ave At A Point 110.46 Ft S Of The N Line Of Sd 1/4 1/4, Th E Par With Sd N Line 47.07 Ft, Th Sely To A Pt 193.01 Ft S Of N Line & 475 Ft E Of W Line Of Sd 1/4 1/4, Th S Along A Line 47 Area: 1.28 Acres Rice Creek Watershed The user of this report acknowledges that the City/County shall not be liable for any damages, and expressly waives all claims, and agrees to defend, indemnify, and hold harmless the City/County from any and all claims brought by the User, its employees or agents, or third parties which arise out of the User's access or use of data provided. *Total Tax includes special assessment due ifany. A-1 DRAFT NOT APPROVED EXHIBIT B DEVELOPMENT PROPERTY (SPECIALTY RETAIL) Approximately 20,000 square feet [Insert Development Property Description located at 2390 Mounds View Boulevard] Heartland Gun Club and Range Site & Floorplan Site Plan MY A'10 SUR>;.CItfG C300 N A A t3, Q A w rD c a) E Q N M LO O II II II 11 10 1 C) E E E 2' O O O O O O EO a) C < a) O a) O O •U QOF-- —w G G m U 0 a O N , N "CS N N �r O CS CdO R cn cn O 2 U �w ga La U m o 56 t�v Lli CL �Q a o n- ZW? � n 111 1 1 1 1 1 1 1 1 1 1 i -=ill" �w ga U O a v v� 0 ti rn rn In Or U m U O a v v� 0 ti rn rn In HE a) E O L c E a� O Z N c"T, Cl) culq) 06 O t6mZ) (if O O EO a) O OO (LS � "O -'O U a) () a) •X Cmmm N O -Y a) O O U fl 2 O W O 0 .o 0 cn cn O 2 0 a ,. -.022 w oa. � x w m W trNZ Q Q Q b I/ d � N ren vi i i i i i i i i i i iriwaw, 0 a ,. -.022 w U W 4 m x w DRAFT NOT APPROVED THIS PAGE LEFT INTENTIANALLY BLANK C-1 Meeting Date: December 4, 2017 Type of Business: Work Session Administrator Review: City of Mounds View Staff Report To: Honorable Mayor and City Council From: Mark Beer, Finance Director Item Title/Subject: 2018 Draft Municipal Budget Attached is the 2018 Draft Municipal Budget. The City Council has reviewed various portions of the municipal budget throughout the summer and fall and this is one last opportunity before considering final approval at the December 11, 2017 City Council meeting. The City Council adopted a preliminary General Fund levy increase of $196,463 or 4.3%, eliminated the street improvement levy of ($300,000) or (6.57%), adopted debt service levies of $423,376 or 9.28% increase, and voters approved an additional police officer which increased the General Fund levy by $85,200 or 1.86%. There was no increase in the EDA levy. The total overall increase is 8.87% for the combined levies. Staff welcomes any comments or questions. Respectfully Submitted, i L -2—r Mark Beer 1-4 City of Mounds View 2018 Budget Summary Expenditures: 2014 2015 2016 2017 2018 Change from 2017 General Fund: Actual Actual Actual Budget Request Dollar Percent Revenues: City Council 46,030 47,115 47,213 57,527 60,881 3,354 Property taxes - Base levy 3,363,602 3,651,411 3,700,381 3,833,967 4,025,429 191,462 4.99% Special tax levies, Bonds 156,348 154,119 154,119 90,835 99,177 8,342 9.18% Special tax levies, Operations 217,145 226,145 233,145 244,145 334,345 90,200 36.95% Franchise tax 336,711 309,039 296,173 280,000 290,000 10,000 3.57% Other taxes 109,002 47,877 27,556 29,000 29,000 - 0.00% Hotel/motel tax 66,367 69,109 67,408 65,000 65,000 - 0.00% Licenses and permits 246,969 204,845 184,499 180,522 183,172 2,650 1.47% Intergovernmental 941,697 1,038,060 1,090,100 976,636 1,054,754 78,118 8.00% Charges for services 14,933 18,942 40,988 16,325 16,825 500 3.06% Fines & forfeitures 40,239 36,338 29,278 39,000 36,600 (2,400) -6.15% Interest 521,224 112,669 104,985 115,000 115,000 - 0.00% Miscellaneous 355,678 321,188 342,547 295,826 282,696 (13,130) -4.44% Transfers: Parks, Recreation & Forestry: DARE Fund - 4,643 - - 115,487 - 0.00% Water Fund 69,393 - - 75,828 78,103 2,275 3.00% Sewer Fund 54,962 56,611 58,309 60,058 61,860 1,802 3.00% Storm Water Fund 7,168 7,383 7,604 7,832 8,067 235 3.00% Street Light Fund 2,462 2,536 2,612 2,690 2,771 81 3.01% Vehicle & Equipment Fund 38,316 21,000 22,000 21,600 22,000 400 1.85% Debt proceeds - 246,729 - - - - 0.00% Total revenues 6,542,216 6,528,644 6,361,704 6,334,264 6,704,799 370,535 5.85% Expenditures: Legislative Services: City Council 46,030 47,115 47,213 57,527 60,881 3,354 5.83% Advisory Commissions 14,315 8,720 15,520 15,500 17,000 1,500 9.68% Subtotal 60,345 55,835 62,733 73,027 77,881 4,854 6.65% Administrative Services: City Administrator 231,848 271,314 282,476 298,084 285,610 (12,474) -4.18% Elections 20,053 22,222 47,279 35,000 24,500 (10,500) -30.00% Finance 232,173 246,268 255,786 263,457 271,256 7,799 2.96% Central Services 207,551 216,482 237,713 255,645 282,474 26,829 10.49% Subtotal 691,625 756,286 823,254 852,186 863,840 11,654 1.37% Community Development 341,593 353,381 320,413 398,498 421,547 23,049 5.78% Police 2,481,263 2,710,053 2,719,071 2,751,241 2,970,719 219,478 7.98% Fire 511,231 567,934 592,181 567,196 603,383 36,187 6.38% Public Works Administration 141,537 113,779 135,670 143,944 148,962 5,018 3.49% Parks, Recreation & Forestry: Recreation 99,589 112,429 109,358 115,487 118,849 3,362 2.91% Parks 313,684 333,043 322,085 359,424 337,519 (21,905) -6.09% Forestry 17,379 34,478 29,474 47,486 42,173 (5,313) -11.19% Subtotal 430,652 479,950 460,917 522,397 498,541 (23,856) -4.57% Fleet Services: Building & Grounds Mtnce 126,707 391,909 116,217 132,657 130,876 (1,781) -1.34% Vehicle & Equipment Mtnce 116,011 84,331 86,966 108,167 113,448 5,281 4.88% Subtotal 242,718 476,240 203,183 240,824 244,324 3,500 1.45% Streets: Pavement Management 205,624 203,268 185,346 235,303 231,743 (3,560) -1.51% Snow & Ice Control 196,155 134,936 131,951 147,564 148,117 553 0.37% Sign Maintenance 37,342 40,315 37,082 63,877 67,248 3,371 5.28% Subtotal 439,121 378,519 354,379 446,744 447,108 364 0.08% Other Convention & Visitors Bureau 63,049 65,654 64,038 61,750 61,750 - 0.00% Social Service Coordination 19,763 20,178 20,259 20,461 20,748 287 1.40% Miscellaneous/contingency 4,926 4,975 5,061 6,500 6,500 - 0.00% Transfers to other funds 1,090,000 496,000 745,000 475,000 565,000 90,000 18.95% Debt service - 20,268 24,495 24,496 24,496 - 0.00% Subtotal 1,177,738 607,075 858,853 588,207 678,494 90,287 15.35% Total expenditures 6,517,823 6,499,052 6,530,654 6,584,264 6,954,799 370,535 5.63% Net change in fund balance 24,393 29,592 (168,950) (250,000) (250,000) - Beginning Fund Balance 9,560,579 9,584,972 9,614,564 9,445,614 9,195,614 Ending Fund Balance 9,584,972 9,614,564 9,445,614 9,195,614 8,945,614 00000 000a m � a � Vi N V1 O as 7 a, �fJ ri � a Ol N ( 1 Q � 00 64 O rWM V p� � a ,••� N ❑ E Oy G 00 N U N E a O Ur 00000 000a 69 6A MM m R V M Vi N V1 O V 7 a, �fJ ri � a Ol N ( 1 O l� Vi o0 00 64 M DD C m On 00 N U N M O 69 � 69 � � � M 10 O< O ;I- l� m N M N Da U Ut C V Oi oo N h M N r N 10 V 64 O � 1 O 10 ll .. � 00 69 0 (N V) [ m O\ ' m N W 10 C G t- t- �O N r t- .. 00 N N M C O O` C C M V «t V) V M Vl O T N K V � � 64 t 1 0 ' C O C V t C, O\ 000 o C 10 N 00 . W 00 V V .• � 69 6A MM m R V M W W 7 a, M O Ol N ( 1 V 7 64 64 On V N ry M � 69 � � � OO V1 Vl M O< O �O M N N.� P. h M N M 64 O � 1 O 10 ll .. � 00 M M 0 (N V) [ 000 M N d' 69 m R y W 7 a, V Ol N ( 1 M N N 64 On V N ry h N •u � :' " O 69 � � � o O y 3 L O �O M W HUF N.� P. h M N M 64 O � 1 O 10 ll .. � 00 00 a0 0 (N V) [ 64 \O M M 00 O DO r V1 M 0 t� 00 o O N N N M 00 O 00 C, Vl N N o �oc �oc o 0 00 0 m 0o0 t` m � N N V) Q\ 00 00 M � M DD 0 D\ l� t- N N It 00 0 <t O l� 00 M m N M 0 lc 'ITN rn �O W d' N 0 [- Cn o M r- N N 00 <r o 00 ll- O O � U C N M N ' N V) V1 O 00 �O C` vo m R y W O N o d i � U •u � :' " O A � � � o O y 3 L O UU W HUF N.� P. vo City of Mounds View 2018 Budget Summary 3 2014 2015 2016 2017 2018 Change from 2017 General Fund: Actual Actual Actual Budeet Request Dollar Percent Capital Outlays Legislative Services: City Council - - - - - - 0.00% Advisory Commissions - - - - - - 0.00% Subtotal - - - - - - 0.00% Administrative Services: City Administrator - - - - - - 0.00% Elections - - 28,112 - - - 0.00% Central Services - - - - - - 0.00% Finance - - - - - - 0.00% Subtotal - - 28,112 - - - 0.00% Community Development - - - - - - 0.00% Police - - - - - - 0.00% Fire 22,900 38,925 55,059 40,655 65,036 24,381 59.97% Public Works Administration - - - - - - 0.00% Parks, Recreation & Forestry: Recreation - - - - - - 0.00% Parks 6,145 14,124 - 6,000 - (6,000) -100.00% Forestry - - - - - - 0.00% Subtotal 6,145 14,124 - 6,000 - (6,000) -100.00% Fleet Services: Building & Grounds Mtnce - 246,729 - - - - 0.00% Vehicle & Equipment Mtnce 6,050 - - - - - 0.00% Subtotal 6,050 246,729 - - - - 0.00% Streets: Pavement Management - - - - - - 0.00% Snow & Iee Control 2,618 - - - - - 0.00% Sign Maintenance - - - - - - 0.00% Subtotal 2,618 - - - - - 0.00% Other Convention & Visitor's Bureau - - - - - - 0.00% Social Service Coordination - - - - - - 0.00% Miscellaneous/contingency - - - - - - 0.00% Transfers to other funds - - - - - - 0.00% Debt service - Fire Bonds - - - - - - 0.00% Subtotal - - - - - - 0.00% Total expenditures 37,713 299,778 83,171 46,655 65,036 18,381 39.40% 3 General Fund: Operating Expenditures: Legislative Services: City Council Advisory Commissions Subtotal Administrative Services: City Administrator Elections Central Services Finance Subtotal Community Development Police Fire Public Works Administration Parks, Recreation & Forestry: Recreation Parks Forestry Subtotal City of Mounds View 2018 Budget Summary 2014 2015 2016 2017 2018 Change from 2017 Actual Actual Actual Budget Request Dollar Percent 46,030 47,115 47,115 57,527 60,881 3,354 5.83% 14,315 8,720 8,720 15,500 17,000 1,500 9.68% 60,345 55,835 55,835 73,027 77,881 4,854 6.65% 231,848 271,314 271,314 298,084 285,610 (12,474) -4.18% 20,053 22,222 22,222 35,000 24,500 (10,500) -30.00% 207,551 216,482 216,482 255,645 282,474 26,829 10.49% 232,173 246,268 246,268 263,457 271,256 7,799 2.96% 691,625 756,286 756,286 852,186 863,840 11,654 1.37% 341,593 353,381 353,381 398,498 421,547 23,049 5.78% 2,481,263 2,710,053 2,710,053 2,751,241 2,970,719 219,478 7.98% 488,331 529,009 529,009 526,541 538,347 11,806 2.24% 141,537 113,779 113,779 143,944 148,962 5,018 3.49% 99,589 112,429 112,429 115,487 118,849 3,362 2.91% 307,539 318,919 318,919 353,424 337,519 (15,905) -4.50% 17,379 34,478 34,478 47,486 42,173 (5,313) -11.19% 424,507 465,826 465,826 516,397 498,541 (17,856) -3.46% Fleet Services: Building & Grounds Mtnce 126,707 145,180 145,180 132,657 130,876 (1,781) -1.34% Vehicle & Equipment Mtnce 109,961 84,331 84,331 108,167 113,448 5,281 4.88% Subtotal 236,668 229,511 229,511 240,824 244,324 3,500 1.45% Streets: Pavement Management 205,624 203,268 203,268 235,303 231,743 (3,560) -1.51% Snow & Ice Control 193,537 134,936 134,936 147,564 148,117 553 0.37% Sign Maintenance 37,342 40,315 40,315 63,877 67,248 3,371 5.28% Subtotal 436,503 378,519 378,519 446,744 447,108 364 0.08% Other Convention & Visitor's Bureau 63,049 65,654 65,654 61,750 61,750 - 0.00% Social Service Coordination 19,763 20,178 20,178 20,461 20,748 287 1.40% Miscellaneous/contingency 4,926 4,975 4,975 6,500 6,500 - 0.00% Transfers to other funds 1,090,000 496,000 496,000 475,000 565,000 90,000 18.95% Debt service - Lease payable - 20,268 20,268 24,496 24,496 - 0.00% Subtotal 1,177,738 607,075 607,075 588,207 678,494 90,287 15.35% Total expenditures 6,480,110 6,199,274 6,199,274 6,537,609 6,889,763 352,154 5.39% General Fund Revenue Detail - 2018 Budget Acct 2014 2015 2016 2017 2018 Change from 2017 # Description Actual Actual Actual Budget Request Dollar Percent 3101 3101 3101 3101 3102 3111 3112 3125 3180 3190 3192 3195 3211 3212 3215 3216 3221 3223 3231 3232 3233 3234 3235 3236 3238 3239 3240 3241 3242 3243 3250 3251 3252 3253 3254 3255 3256 3257 3258 3260 Taxes 16,800 17,290 16,800 16,800 - 0.00% 600 Current ad valorem property tax 3,363,602 3,651,411 3,700,381 3,833,967 4,025,429 191,462 4.99% Fire bonds 156,348 154,119 154,119 90,835 99,177 8,342 9.18% PERA rate increase property tax 39,145 39,145 39,145 39,145 39,145 - 0.00% Police Officer market rate tax 178,000 187,000 194,000 205,000 295,200 90,200 44.00% Delinquent ad valorem prop tax 12,324 17,266 - - - - 0.00% Manufact home tax - current 19,935 21,331 18,966 20,000 20,000 - 0.00% Manufact home tax - delinquent 8,500 9,280 8,590 9,000 9,000 - 0.00% Excess TIF 62,069 - - - - - 0.00% Franchise tax on utilities 336,711 309,039 296,173 280,000 290,000 10,000 3.57% Penalties & interest 5,817 - - - - - 0.00% Forfeited tax sales 357 - - - - - 0.00% Hotel/Motel tax 66,367 69,109 67,408 65,000 65,000 - 0.00% Total taxes 4,249,175 4,457,700 4,478,782 4,542,947 4,842,951 300,004 6.60% Licenses and Permits Liquor on -sale Liquor off -sale Malt on -sale license Malt off -sale Tobacco license Amusement devices Bowling alley Garbage hauling Gasoline station Used car sales Kennel Restraurant licenses Transient & solicitor Apartment Rental conversion Dog license Massage therapy Chickens and bees General contractor HVAC contractor Cement contractor Asphalt contractor Excavating contractor Sign & billboard contractor Sewer & water contractor Other contractor License check Fire permits Subtotal licenses 16,775 16,800 17,290 16,800 16,800 - 0.00% 600 1,477 2,095 600 800 200 33.33% 135 - 115 - - - 0.00% (15) - 135 100 100 - 0.00% 3,220 3,300 3,300 3,000 3,300 300 10.00% 1,072 720 704 700 700 - 0.00% 672 672 672 672 672 - 0.00% 3,150 2,558 3,373 3,000 3,000 - 0.00% 850 850 850 850 850 - 0.00% 204 204 204 200 200 - 0.00% 285 426 488 150 200 50 33.33% 3,025 3,806 3,641 3,100 3,200 100 3.23% 2,235 2,666 2,130 2,200 2,200 - 0.00% 26,331 28,967 25,715 26,000 26,000 - 0.00% 3,295 1,335 2,500 1,000 1,000 - 0.00% 3,454 1,428 7,119 1,200 1,400 200 16.67% - 899 - - - - 0.00% - 440 350 200 100 (100) -50.00% 1,340 760 1,400 1,100 1,100 - 0.00% 6,390 5,050 4,840 4,000 4,400 400 10.00% 160 - 40 100 100 - 0.00% 40 180 120 100 100 0.00% 60 - - 50 50 0.00% 680 60 100 300 100 (200) -66.67% - 100 - - - - 0.00% 2,230 3,430 2,800 1,500 2,000 500 33.33% 2,012 2,058 2,132 1,600 1,800 200 12.50% 1,320 950 1,780 900 900 - 0.00% 79,520 79,136 83,893 69,422 71,072 1,650 2.38% 5 General Fund Revenue Detail - 2018 Budget Acct # Description 2014 Actual 2015 Actual 2016 Actual 2017 Budget 2018 Request Change from 2017 Dollar Percent 3268 Plan check fee 37,926 23,141 13,751 18,000 18,000 - 0.00% 3270 Building permits 79,071 53,481 39,681 50,000 50,000 662,783 0.00% 3271 Fixed fee - building permits 18,592 18,421 20,146 18,000 18,500 500 2.78% 3273 HVAC permits 15,070 15,341 14,483 13,000 13,500 500 3.85% 3274 Plumbing permits 9,985 6,904 5,655 6,500 6,500 - 0.00% 3275 Non -building permits 5,921 7,679 5,314 5,000 5,000 145,000 0.00% 3278 Interim use permits - - 500 - - - 0.00% 3279 Conditional use permits 600 400 800 600 600 - 0.00% 3280 Building surcharge 144 1,052 99 - - 32,000 0.00% 3281 Fixed fee building surcharge 75 (921) (3) - - - 0.00% 3282 Mechanical/commercial surchar; 28 (38) 8 - - 70,000 0.00% 3283 HVAC surcharge 21 60 33 - - - 0.00% 3284 Plumbing surcharge 13 27 130 - - - 0.00% 3286 Water & sewer surcharge - 158 3 - - - 0.00% 3287 Commercial plmb surcharge 10 4 6 - - 1,000 0.00% 0.00% Subtotal permits 167,449 125,709 100,606 111,100 112,100 1,000 0.90% 0.00% Total licenses & permits 246,969 204,845 184,499 180,522 183,172 2,650 1.47% 6 Intergovernmental: 3318 Federal grant 1,088 350 2,902 - - - 0.00% 3341 Local Government Aid 597,024 655,531 666,792 604,365 662,783 58,418 9.67% 3345 Performance Aid - 1,742 1,821 - 1,800 1,800 0.00% 3346 PERA Aid 8,671 8,671 8,671 8,671 8,671 - 0.00% 3351 Street Aid - MSA maintenance 109,063 122,280 121,641 120,000 125,000 5,000 4.17% 3355 Police Aid 126,933 141,567 152,973 135,000 145,000 10,000 7.41% 3356 Police training 5,471 5,664 5,628 5,600 9,500 3,900 69.64% 3357 State police grant 1,088 389 455 - - - 0.00% 3359 Other state grants 27,409 36,522 31,298 37,000 32,000 (5,000) -13.51% 3370 Other local government revenue 2,000 1,230 593 - - - 0.00% 3371 IDS # 621 - SRO 62,950 64,114 75,839 66,000 70,000 4,000 6.06% 3375 State pension contribution - - 21,487 - - - 0.00% 3433 Total intergovernmental 941,697 1,038,060 1,090,100 976,636 1,054,754 78,118 8.00% 6 Charges for services 3410 Advertising revenue 1,620 205 530 700 500 (200) -28.57% 3415 Housing inspections - 190 1,771 50 100 50 100.00% 3418 HRA inspections 190 - - 500 200 (300) -60.00% 3419 Investigations 228 2,806 200 - 200 200 0.00% 3421 Police reports 1,723 1,165 1,742 1,200 1,200 - 0.00% 3422 Documents / copies 26 351 262 100 150 50 50.00% 3423 Customer service 281 595 525 300 300 - 0.00% 3425 Book sales - various 10 - 43 - - - 0.00% 3426 Reimbursed staff time 15 - - 500 200 (300) -60.00% 3430 Right-of-way 5,615 8,310 24,712 9,000 9,000 - 0.00% 3431 Street opening fee - 200 - - - - 0.00% 3432 Tree removal charges - 2,670 8,353 1,000 2,000 1,000 100.00% 3433 Overload permits 75 - 200 - - - 0.00% 3458 Zoning letter 300 150 500 75 75 - 0.00% 3461 Subdivision 2,100 - 1,050 1,000 1,000 - 0.00% 3462 Variance 1,800 1,800 1,100 1,000 1,000 - 0.00% 3463 Rezoning - 500 - 200 200 - 0.00% 3464 Development - non refund 450 - - 350 350 - 0.00% 3466 Comprehensive Plan Amendmet 500 - - - - - 0.00% 3467 PUD amendment - - - 350 350 - 0.00% Total charges for services 14,933 18,942 40,988 16,325 16,825 500 3.06% 6 THIS PAGE LEFT BLANK INTENTIONALLY General Fund Revenue Detail - 2018 Budget Acct 2014 2015 2016 2017 2018 Change from 2017 # Description Actual Actual Actual Budget Request Dollar Percent Fines and Forfeitures 3510 Ramsey County municipal court 3515 Mn Highway Patrol 3520 Administrative offenses 3525 False alarm charges Total fines & forfeitures Other Revenue 3550 Special assessments 3610 Investment income (charge) 3630 Billboard Lease 3631 Water tower rental 3634 Equipment and space rental 3639 Security 3650 Donations 3651 Donations - K9 3654 COPS events 3656 Tree sales 3665 Park site permit 3679 Vending machine commissions 3680 Other revenue 3685 Insurance reimbursements 3690 Cash over / short 3911 Sale of assets 3912 Resale of materials Total other revenue 35,010 32,019 25,527 34,000 32,000 (2,000) -5.88% 233 50 - 200 200 - 0.00% 2,621 2,144 801 2,500 2,100 (400) -16.00% 2,375 2,125 2,950 2,300 2,300 - 0.00% 40,239 36,338 29,278 39,000 36,600 (2,400) -6.15% 11,601 4,195 3,706 3,000 3,000 400 0.00% 521,224 112,669 104,985 115,000 115,000 - 0.00% 103,110 105,303 112,562 113,876 119,889 6,013 5.28% 98,855 101,639 110,529 114,950 90,807 (24,143) -21.00% 5,268 5,454 1,194 1,150 1,150 - 0.00% - 3,782 1,509 - - - 0.00% 11,485 5,100 4,080 - - - 0.00% 1,618 1,247 1,330 750 750 - 0.00% - - - - 5,000 5,000 0.00% - - 204 - - - 0.00% 12,497 14,940 14,613 14,000 14,000 0.00% 466 - 76 100 100 0.00% 46,993 10,584 20,812 11,000 11,000 - 0.00% 59,152 40,145 57,995 30,000 30,000 - 0.00% (22) - - - - - 0.00% 550 28,338 12,513 5,000 5,000 - 0.00% 4,105 461 1,424 2,000 2,000 - 0.00% 876,902 433,857 447,532 410,826 397,696 (13,130) -3.20% Transfers & Debt proceeds 3972 Transfers: Vehicle & Equip replacemen DARE fund Water Sewer Storm Water Street light 3993 Debt proceeds Total Transfers & Debt Total 38,316 21,000 22,000 21,600 22,000 400 1.85% - 4,643 - - - - 0.00% 69,393 - - 75,828 78,103 2,275 3.00% 54,962 56,611 58,309 60,058 61,860 1,802 3.00% 7,168 7,383 7,604 7,832 8,067 235 3.00% 2,462 2,536 2,612 2,690 2,771 81 3.01% - 246,729 - - - - 0.00% 172,301 338,902 90,525 168,008 172,801 4,793 2.85% 6,542,216 6,528,644 6,361,704 6,334,264 6,704,799 370,535 5.85% 8 2018 Budget Summary Materials & supplies 1600 Supplies, operating 1,690 1,635 2,239 2,600 2,600 - 0.00% Total materials & supplies 1,690 1,635 2,239 2,600 2,600 - 0.00% Contractual services 2014 2015 2016 2017 2018 Change from 2017 3630 Training & conferences Actual Actual Actual Budget Request Dollar Percent City Council (100 - 4100): 48.39% 3610 Memberships 2,801 5,161 5,429 5,681 Personnel services 35 0.62% 3630 Training & conferences 2,633 2,208 1,765 0100 Salaries, regular 29,292 29,292 29,292 34,596 34,596 - 0.00% 0300 Social Security 1,129 1,129 1,129 2,647 2,647 - 0.00% 0321 PERA 885 885 885 1,730 1,730 - 0.00% 0500 Workers compensation 111 148 132 173 142 (31) -17.92% Total personnel services 31,417 31,454 31,438 39,146 39,115 (31) -0.08% Materials & supplies 1600 Supplies, operating 1,690 1,635 2,239 2,600 2,600 - 0.00% Total materials & supplies 1,690 1,635 2,239 2,600 2,600 - 0.00% Contractual services 4,369 2,227 2,641 4,500 4,500 - 0.00% 3630 Training & conferences 3030 Other professional services 6,895 6,154 5,882 6,200 9,200 3,000 48.39% 3610 Memberships 2,801 5,161 5,429 5,681 5,716 35 0.62% 3630 Training & conferences 2,633 2,208 1,765 3,200 3,600 400 12.50% 4800 Bonding & insurance 594 503 460 700 650 (50) -7.14% Total contractual services 12,923 14,026 13,536 15,781 19,166 3,385 21.45% 0.00% Total City Council 46,030 47,115 47,213 57,527 60,881 3,354 5.83% 15,661 15,775 18,381 21,766 Advisory Commissions (100-4110): Materials & supplies 1600 Supplies, operating - 41 - 200 200 - 0.00% 2100 Books & periodicals - - - 100 100 - 0.00% Total materials & supplies - 41 - 300 300 - 0.00% Contractual services 3030 Other professional services 4,369 2,227 2,641 4,500 4,500 - 0.00% 3630 Training & conferences - - - 200 200 - 0.00% 3900 Festivities Commission 9,946 6,452 12,879 10,500 12,000 1,500 14.29% Total contractual services 14,315 8,679 15,520 15,200 16,700 1,500 9.87% 0.00% Total Advisory Commissions 14,315 8,720 15,520 15,500 17,000 1,500 9.68% 9 Fund: 100 Department: 4100 Account Description 2015 2016 City Council Account Description 2015 2016 2017 2018 Description 1600 Supplies, operating 900 500 900 1,000 600 1,000 1,000 600 1,000 1,000 600 1,000 Employee appreciation dinner Strategic planning session supplies Plaques and gift certificates for employee appreciation 2,300 2,600 2,600 2,600 3030 Other professional services 3,000 6,075 - 6,200 - 6,200 3,000 6,200 Strategic planning session(s) facilitator Contractual minutes for Council mtgs ( $225 x 24 reg, + 3 special) 9,075 6,200 6,200 9,200 3610 Memberships 30 5,770 30 5,570 30 5,651 30 5,686 Mn Mayor's Association North Metro Mayors (Evaluate for value and effectiveness) 5,800 5,600 5,681 5,716 3630 Conferences 2,000 3,200 3,200 3,600 Council training, LMC conference, RCCLG dinners & NLC conference 2,000 3,200 3,200 3,600 4800 Bonds & insurance 750 700 700 650 General property & liability 750 700 700 650 19,925 18,300 18,381 21'/00 7.99% -8.16% 0.44% 18.42% Fund: 100 ,Department: 4110 1 Advisory Commissions Account Description 2015 2016 2017 2018 Description 1600 Supplies, operating 60 140 60 140 60 140 60 140 Misc supplies for various commissions. Copies for Charter Commission 200 200 200 200 2100 Books & periodicals 100 100 100 100 Misc periodicals - Comp plan review, Ordinance revisions. 100 100 100 100 3030 Other professional services 500 2,000 2,500 500 2,000 2,500 500 1,750 2,250 500 1,750 2,250 Misc. consultant services. Charter commission legal fees Planning Commission meeting minutes 5,000 5,000 4,500 4,500 3630 Training 150 150 150 150 75 125 75 125 Misc training & conferences. Planning Commissioner training & conferences 300 300 200 200 3900 Festival in the Park 9,500 - - 4,500 - 5,000 5,500 - 5,000 5,500 1,500 5,000 City Festival in the Park (personnel, supplies) 60th Anniversery Fireworks 9,500 9,500 10,500 12,000 ll,Iuu 1J, 1 u 17,:)uv 1/,VVV 48.77% 48.77% 2.65% 12.58% 10 2018 Budget Summary Materials & supplies 1230 Supplies, equipment 340 179 - 1,200 2014 2015 2016 2017 2018 Change from 2017 2100 Books & periodicals - - - 35 Actual Actual Actual Budtet Request Dollar Percent Office of the City Administrator (100 - 4130): 1,335 3,709 1,490 5,850 2,650 (3,200) -54.70% Personnel services - - 375 375 - 0.00% 2,330 4,638 0100 Salaries, regular 177,671 212,471 216,175 224,486 200,898 (23,588) -10.51% 0110 Salaries, over -time - - - 896 909 13 1.45% 0150 Salaries, part-time - - - 988 16,903 15,915 1610.83% 0300 Social Security 12,871 15,417 15,115 17,127 16,540 (587) -3.43% 0321 PERA 12,692 15,622 15,518 16,716 14,948 (1,768) -10.58% 0400 Group insurance 24,479 20,649 20,981 26,007 27,090 1,083 4.16% 0500 Workers compensation 1,465 2,325 1,471 1,689 1,347 (342) -20.25% Total personnel services 229,178 266,484 269,260 287,909 278,635 (9,274) -3.22% Materials & supplies 1230 Supplies, equipment 340 179 - 1,200 1,200 - 0.00% 1600 Supplies, operating - 13 - 75 75 - 0.00% 2100 Books & periodicals - - - 35 35 - 0.00% Total materials & supplies 340 192 - 1,310 1,310 - 0.00% Contractual services 3030 Other professional services 3100 Communications 3610 Memberships 3630 Training & conferences 3800 Mileage - 0.00% Total contractual services Total City Administrator Elections (100 - 4140): Contractual services 3030 Other professional services Total contractual services 7030 Capital outlays Total Elections - - 10,447 - - - 0.00% 631 741 1,078 1,300 1,300 - 0.00% 142 188 201 1,340 1,340 - 0.00% 1,335 3,709 1,490 5,850 2,650 (3,200) -54.70% 222 - - 375 375 - 0.00% 2,330 4,638 13,216 8,865 5,665 (3,200) -36.10% 231,848 271,314 282,476 298,084 285,610 (12,474) -4.18% 4,830 13,216 10,175 6,975 20,053 22,222 19,167 35,000 24,500 (10,500) -30.00% 20,053 22,222 19,167 35,000 24,500 (10,500) -30.00% - 28,112 - - - 0.00% 20,053 22,222 47,279 35,000 24,500 (10,500) -30.00% Fund: 100 Department: 4130 ' Office of the City Administrator Account Description 2015 2016 2017 2018 Description 1230 Supplies, equipment < $5000 725 825 1,200 1,200 Equipment and phones under the $5,000 capitalization threshold 725 825 1,200 1,200 1600 Supplies, Operating 75 75 75 75 Miscellaneous supplies 75 75 75 75 2100 Books & Periodicals 35 35 35 35 Miscellaneous reference books 35 35 35 35 3100 Communications 760 1,300 1,300 1,300 Cell phone service (2) employees 760 1,300 1,300 1,300 3610 Memberships - - 150 40 - - 150 40 50 1,100 150 40 50 1,100 150 40 MAMA - (Administrator) Metro Area Managers Association ICMA- InternationalCityManagersAssociation Mn City County Managers Association Municipal Clerks & Finance Officers Association 190 190 1,340 1,340 3630 Training & conferences 100 500 100 850 850 100 3,000 100 500 100 1,000 850 100 - 100 500 100 1,000 850 100 3,200 100 500 100 1,000 850 100 - MAMA meetings LMC / miscellaneous training Chamber lunches LMC annual conference (2 attendees)(Asst. Adm. every other year) Mn City County Managers Assoc conference Mn Clerks and Finance Officers Association (MCFOA) institute training National ICMA or NLC conference (City Administrator)(every other year) 5,500 1 2,650 5,850 2,650 3800 Mileage 375 375 375 375 Miscellaneous mileage @ IRS rate. 375 375 375 375 /,nbU 5,45U tU,l/D 0"j /D -0.65% -29.31% 32.83% 27.98% Fund; 100 Department: 4140 Elections' Account Description 2015 2016 2017 2018 Description 3030 Other professional services 23,200 23,200 22,000 22,000 - - 10,500 - 2,500 2,500 2,500 Ramsey County elections contract Special election Equip. maint. service costs (voting equip.) 23,200 25,700 35,000 24,500 7030 Equipment 36,000 29,000 Voting equipment 36,000 29,000 59,2UU S4;/UU 35,VUU 24,SUU 5.71% -7.60% -36.01% -30.00% 12 2018 Budget Summary 13 2014 2015 2016 2017 2018 Change from 2017 Actual Actual Actual Budtet Request Dollar Percent Finance (100 - 4150): Personnel services 0100 Salaries, regular 166,330 177,754 186,467 187,327 192,483 5,156 2.75% 0300 Social Security 11,908 12,751 13,092 14,330 14,725 395 2.76% 0321 PERA 11,808 13,050 13,676 14,050 14,436 386 2.75% 0400 Group insurance 21,414 21,860 22,311 25,506 26,910 1,404 5.50% 0500 Workers compensation 1,273 1,850 1,415 1,615 1,367 (248) -15.36% 0990 Severence - - - - - - 0.00% Subtotal 212,733 227,265 236,961 242,828 249,921 7,093 2.92% Materials & supplies 1230 Supplies, equipment 17 - - 200 175 (25) -12.50% 1600 Supplies, operating 35 - - 75 75 - 0.00% 2100 Books & periodicals 181 185 227 450 350 (100) -22.22% Subtotal 233 185 227 725 600 (125) -17.24% Contractual services 3030 Other professional 9,811 9,738 9,519 9,615 9,780 165 1.72% 3100 Communications 480 480 480 480 480 - 0.00% 3430 Printing 1,179 551 735 700 700 - 0.00% 3610 Memberships 804 970 995 995 1,040 45 4.52% 3630 Training 2,635 2,477 2,037 2,700 3,050 350 12.96% 5130 Repairs & maint., equipment 4,298 4,602 4,832 5,414 5,685 271 5.01% Subtotal 19,207 18,818 18,598 19,904 20,735 831 4.18% Total Financial Services 232,173 246,268 255,786 263,457 271,256 7,799 2.96% 13 Fund: 100 Department: 4150 Finance Account Description 2015 2016 2017 2018 Description 1230 Supplies, equitpment < $5000 200 200 200 175 Furniture or equipment under the $5,000 capitalization threshold 200 200 200 175 1600 Supplies, operating 75 75 75 75 Mise supplies - planners, plaques, folders, files, etc. 75 75 75 75 2100 Books & periodicals 550 450 450 350 Misc computer & finance books & periodicals 550 450 450 350 3030 Other professional services 9,480 9,660 435 435 60 60 100 100 9,020 9,185 435 435 60 60 100 100 27.5% of audit (2016 - $32,200,2017 - $32,800,2018 - $33,400) GFOA financial reporting fee Safety deposit box rental Ramsey County overlapping debt, principal taxpayer reports 10,075 10,255 9,615 1 9,780 3100 Communications 480 480 480 480 cell phone ($40 month) 480 480 480 480 3430 Printing 350 350 350 350 350 350 350 350 Accts Payable & payroll checks & envelopes Invoices, receipts, & bank deposit slips 700 700 700 700 3610 Memberships 350 350 120 120 240 250 275 275 350 370 120 120 250 260 275 290 Government Finance Officer's Association (GFOA) Mn GFOA (2) AICPA Am. Institute of Certified Public Accts MNCPA Mn Society of Certified Public Accountants 985 995 995 1 1,040 3630 Training & conferences 75 75 1,450 1,600 - - 600 650 250 1 250 50 50 1,700 2,000 - - 650 700 300 300 Mn GFOA monthly meetings Seminars & training GFOA National conference (Defer)($2500) Accounting and software training Mileage 2,375 2,575 2,700 31050 5130 Equipment repairs 4,910 5,156 5,414 1 5,685 40% solhvare support charges (30% each in Water, Sanitary Sewer)(5% ann.) 4,910 5,156 5,414 1 5,685 2U,350 2U,88b 2U,bZV 21,33D -1.52% 2.63% -1.23% 3.42% 14 2018 Budget Summary Contractual services 2014 2015 2016 2017 2018 Change from 2017 Actual Actual Actual Budget Request Dollar Percent Central Services (100 - 4160): 0.00% 3030 Other professional services 5,154 9,643 22,423 22,446 Materials & supplies (1,346) -6.00% 3100 Telephone 7,078 6,160 2,613 0322 Pesion expense GASB 68 - - 2,031 - - - 0.00% 1110 Stationery 1,027 - 436 1,000 750 (250) -25.00% 1120 Copy materials - 830 1,799 1,500 1,500 - 0.00% 1230 Supplies, equipment 4,296 21,316 22,102 21,600 22,391 791 3.66% 1600 Supplies, operating 14,462 12,662 12,670 14,500 14,500 - 0.00% 2100 Books & periodicals 159 169 169 365 340 (25) -6.85% Total materials & supplies 19,944 34,977 39,207 38,965 39,481 516 1.32% Contractual services 3010 General legal 57,407 45,489 41,364 44,000 44,000 - 0.00% 3030 Other professional services 5,154 9,643 22,423 22,446 21,100 (1,346) -6.00% 3100 Telephone 7,078 6,160 2,613 2,400 2,200 (200) -8.33% 3300 Postage 8,366 8,273 4,238 7,800 7,800 - 0.00% 3410 Legal notices 2,395 4,168 3,499 3,000 3,000 - 0.00% 3420 Advertising 2,534 2,634 2,739 2,500 2,500 - 0.00% 3430 Printing 8,330 7,945 8,601 7,400 12,600 5,200 70.27% 3610 Memberships 13,424 19,253 20,049 20,556 20,752 196 0.95% 3630 Training & conferences 172 1,167 498 2,000 22,000 20,000 1000.00% 4010 Rental, equipment 1,431 1,407 1,424 1,750 2,050 300 17.14% 4800 Insurance & bonds 14,614 15,212 14,453 20,000 18,000 (2,000) -10.00% 5100 Repairs & maint, computers 64,347 56,507 76,605 82,228 86,391 4,163 5.06% 5130 Repairs, equipment 2,355 3,647 - 600 600 - 0.00% Total contractual services 187,607 181,505 198,506 216,680 242,993 26,313 12.14% Total central services 207,551 216,482 237,713 255,645 282,474 26,829 10.49% 15 Fund: 100 Department: 4160 Central Services Account Description 2015 2016 2017 2018 Description 1110 Stationery 1,000 1,000 1,000 750 Envelopes, labels, letterhead, etc. 1,000 1,000 1,000 750 1120 Copy materials 1,500 1,500 1,500 1,500 Copy paper 1,500 1,500 1,500 1,500 1230 Supplies, equipment < $5000 20,000 20,000 21,600 22,391 Comp & security equip under $5,000, pc's, software, switches, cameras.... Replace pc's @ $800 4 yr replacement cycle 20,000 20,000 21,600 22,391 1600 Supplies, operating 15,400 15,400 14,000 14,000 Toner, rug service, paper, pens, staples, desk supplies, etc. 500 500 500 500 Misc operating supplies 15,900 15,900 14,500 14,500 2100 Books & periodicals 175 175 175 150 Employment handbooks/publications 190 190 190 190 Star Tribune - $190 365 365 365 340 3010 General legal 26,400 24,000 24,000 24,000 Retainer for legal services 18,000 20,000 20,000 20,000 Legal fees outside scope of retainer. 44,400 44,000 44,000 44,000 3030 Other professional services 6,000 5,700 5,700 12,000 General labor assistance and staff development - - 10,000 - Personnel market study 3,086 3,100 Western Bank monthly fees 360 400 US Bank positive pay service 1,400 1,500 1,200 1,200 Section 125 (flex spending plan) & COBRA administration 900 1,000 1,000 2,000 Human resources items 1,000 1,100 1,100 2,400 Web hosting (Revize) (5% annual increase) 9,300 1 9,300 22,446 21,100 3100 Telephone 6,800 7,400 2,400 2,200 Basic telephone plus long distance 6,800 7,400 2,400 2,200 3300 Postage 300 300 300 300 Courier charges (delivery services) 7,500 7,500 7,500 7,500 General postage includes PW mailings for street projects. 7,800 7,800 7,800 7,800 3410 Legal notices 900 900 900 900 Truth in taxation notices and Ramsey County fees. 2,100 2,100 2,100 2,100 Legal notices and legal publications. 3,000 3,000 3,000 3,000 3420 Advertising 3,000 2,500 2,500 2,500 Job opening advertisements for vacant positions 3,000 2,500 2,500 2,500 3430 Printing 6,400 6,800 6,800 12,000 4 newsletters and postage, YMCA in Comm Ctr Fund. 200 200 200 200 Miscellaneous printing 400 400 400 400 City guides, directories & miscellaneous 7,000 7,400 7,400 12,600 3610 Memberships 605 600 625 625 Ramsey County League of Local Governments (RCLLG) - 2,850 2,850 2,850 1-35W Corridor Coalition 4,833 4,835 4,901 5,097 Metro Cities (1.00% increase for 2018) 10,813 11,637 12,180 1 12,180 League of Mn Cities (No increase 2018) 16,251 19,922 20,556 20,752 3630 Training & conferences 1,000 1,000 1,000 1,000 League training & seminars - - - 20,000 Staff development training (Martin-McAllister) 800 800 800 800 OSHA and blood borne pathogen training 200 200 200 200 Information technology training Misc 2,000 2,000 2,000 22,000 4010 Rental, equipment 150 150 150 150 1,600 1,600 1,600 1,900 Postage machine and scale rental 1,750 1 1,750 1,750 2,050 4800 Bonding & insurance 19,000 19,000 17,000 15,000 Insurance policy premiums 3,000 3,000 3,000 3,000 Allowance for insurance policy deductibles 22,000 22,000 20,000 18,000 5100 Repairs, computer 59,000 64,000 69,600 72,100 Computer, phone, network & technology assistance - City of Roseville 2,198 2,609 2,688 2,688 Laserfiche annual maintenance and storage - 1,603 Denial of Service protection contract (1.687% of $95,000) 5,750 5,750 5,750 6,000 Computer, printer, and networks repairs. 4,190 4,190 4,190 4,000 Copier maintenance + overages 2,040 - Hosted servers (included in technology assist.) 73,178 1 76,549 82,228 86,391 5130 Repairs, equipment 600 600 600 600 Postage meter, copy machine, fax, misc. 600 600 600 600 235,844 242,986 255,645 282,474 -0.09% 3.03% 5.21% 10.49% 16 Community Development (100 - 4180): Personnel services 0100 Salaries, regular 0110 Overtime, regular 0150 Salaries, part time 0300 Social Security 0321 PERA 0322 Pension expense GASB 68 0400 Group insurance 0500 Workers comp 1,482 Total personnel services Materials & supplies 1230 Supplies, equipment 1600 Supplies, operating 1700 Motor fuels & lubricants 2100 Books & periodicals 2400 Uniforms 699 Total materials & supplies Contractual services 2018 Budget Summary 2014 2015 2016 2017 2018 Change from 2017 Actual Actual Actual Budget Request Dollar Percent 245,039 259,655 236,428 263,096 280,198 17,102 6.50% 24 - - 548 699 151 27.55% 1,380 1,226 1,238 1,976 1,482 (494) -25.00% 17,745 18,069 16,801 20,320 21,602 1,282 6.31% 17,572 18,504 16,701 19,773 21,067 1,294 6.54% - - 1,604 - - - 0.00% 35,750 35,975 28,371 51,120 53,640 2,520 4.93% 2,177 2,859 1,660 1,834 1,632 (202) -11.01% 319,687 336,288 302,803 358,667 380,320 21,653 6.04% 510 - 62 500 500 - 0.00% - 110 48 300 300 - 0.00% 2,191 1,745 732 1,840 2,000 160 8.70% - 498 321 375 375 - 0.00% 296 - 82 200 200 - 0.00% 2,997 2,353 1,245 3,215 3,375 160 4.98% 3030 Other professional 12,869 9,431 11,749 27,200 28,906 1,706 6.27% 3040 Consultants, development review 2,085 822 1,575 3,000 3,000 - 0.00% 3100 Telephone 1,240 1,365 1,550 1,961 1,421 (540) -27.54% 3430 Printing 762 543 510 900 900 - 0.00% 3610 Memberships 870 1,180 120 1,630 1,200 (430) -26.38% 3630 Training and conferences 1,024 1,393 657 1,825 2,325 500 27.40% 3800 Mileage 59 6 204 100 100 - 0.00% Total contractual services 18,909 14,740 16,365 36,616 37,852 1,236 3.38% Total Community Development 341,593 353,381 320,413 398,498 421,547 23,049 5.78% 17 Fund: 100 Department: 4180 Community Development Account Description 2015 2016 2017 2018 Description 1230 Supplies, equipment < $5000 475 825 500 500 Miscellaneous equipment & computer peripherals 475 825 500 500 1600 Supplies, operating 100 100 100 100 Presentation supplies 200 200 200 200 Office supplies 300 300 300 300 1700 Motor fuels & lubs 1,788 2,200 1,840 2,000 Unleaded fuel: 800 gallons @ $2.50 (Gas for Comm Devlopment) 1,788 2,200 1,840 2,000 2100 Books & periodicals 100 100 100 100 Reference materials 100 100 100 100 Intl. Code Council Manuals and Code Updates 175 175 175 175 Manuals, pamphlets, etc. 375 375 375 375 2400 Uniforms 200 200 200 200 Clothing for inspections staff 200 200 200 200 3030 Other professional 1,300 1,300 1,300 1,300 Ramsey County JPA (geographic information system) 4,620 4,620 4,485 5,080 Permit Works system annual software support (includes busi. he. mod) 1,595 - 1,020 Permit works mobile inspector - 2,040 1,020 - Roseville Net Motion VPN 2 factor authentication 500 500 500 500 Filing fees (Ramsey County increased fees from $29 to $48) 1,971 2,110 2,195 2,306 Comcate Code Enforcement Mgr license 1,987 1,987 1,200 1,200 Comcate mobile access 500 500 500 500 GIS assistance - - - 5,000 Consulting Building Official services - - 12,000 8,000 Comp plan GIS assistance with maps 4,000 4,000 4,000 4,000 Abatements of nuisance properties 14,878 18,652 27,200 28,906 3040 Consulting - Development 750 750 750 750 Environmental reviews Review (reimbursable) 750 750 750 750 City attorney services 750 750 750 750 Development case reviews 750 750 750 750 Engineering services 3,000 3,000 3,000 3,000 3100 Telephone 1,300 1,300 1,000 1,000 Verizon Cell Accounts (2) for inspectors 481 481 961 421 network card for code enforcement (I cards a $35.01) 1,781 1,781 1,961 1,421 3430 Printing 1,300 1,000 900 900 Forms, flyers, etc. 1,300 1,000 900 900 3610 Memberships 300 300 245 265 American Planning Association (APA) - National (1) 50 50 American Planning Association (APA-MN) - State (1) 135 135 American Institute of Certified Planners (AICP) 750 300 Sensible Land Use Coalition (membership $250, monthly lunches (10 @ $50) 120 120 - - Assoc. of MN Building Officials 120 125 140 140 International Code Council (ICC) 60 95 100 100 10K Lakes Chapter of ICC 60 100 105 105 MN Assoc. Housing Code Officials (MARCO) 85 100 105 1 105 MN Building Permit Technicians Association (MBPTA) 745 840 1,630 1,200 3630 Training & conferences 600 600 800 850 APA state conference (one attendee) 225 225 ICC code seminars 300 300 300 300 Other sofhvare training 300 300 500 950 Other stafftmining & seminars 1,200 1 1,200 1 1,825 2,325 3800 Mileage 100 100 100 100 Misc. use of personal automobiles 100 100 100 100 26,142 30,473 39,831 41,227 -3.34% 16.57% 30.71% 3.50% 18 2018 Budget Summary 2014 2015 2016 2017 2018 Change from 2017 Actual Actual Actual Budget Reclues Dollar Percent Police (100 - 4200): Supplies, buildings & grounds - - - 500 - (500) Personnel services: 1230 Supplies, equipment 19,509 35,038 23,114 14,100 13,100 0100 Salaries, regular 1,542,874 1,570,903 1,631,402 1,639,030 1,773,491 134,461 8.20% 0110 Overtime 74,978 80,112 96,684 60,499 66,941 6,442 10.65% 0300 Social Security 26,023 27,501 29,230 32,822 34,650 1,828 5.57% 0321 PERA 226,087 254,166 256,686 263,847 299,812 35,965 13.63% 0322 Pension expense GASB 68 - - 14,949 - - - 0.00% 0400 Group insurance 205,941 220,722 231,125 259,560 284,520 24,960 9.62% 0500 Workers compensation 57,033 78,193 73,788 83,375 74,990 (8,385) -10.06% 0.00% Total personnel services 2,132,936 2,231,597 2,333,864 2,339,133 2,534,404 195,271 8.35% Materials & Supplies 1210 Supplies, buildings & grounds - - - 500 - (500) -100.00% 1230 Supplies, equipment 19,509 35,038 23,114 14,100 13,100 (1,000) -7.09% 1600 Supplies, operating 4,543 7,664 5,706 9,100 9,700 600 6.59% 1700 Motor, fuels & lubricants 43,608 39,643 24,716 33,293 36,750 3,457 10.38% 2100 Books & periodicals 811 1,031 723 900 300 (600) -66.67% 2400 Uniforms & clothing 16,974 15,168 20,682 20,805 20,820 15 0.07% Veternarian services Total materials & supplies 85,445 98,544 74,941 78,698 80,670 1,972 2.51% Contractual services 3020 Legal, prosecuting attorney 53,181 72,774 74,226 78,690 78,690 - 0.00% 3030 Other professional services 11,556 3,183 3,115 3,690 3,690 - 0.00% 3050 Dispatching 100,915 108,058 106,425 107,131 106,714 (417) -0.39% 3055 Information systems fees 2,540 2,565 4,907 4,955 4,955 - 0.00% 3070 COPS events 644 802 1,731 1,000 6,000 5,000 500.00% 3080 Veternarian services 2,951 5,449 1,199 1,500 2,000 500 33.33% 3100 Telephone 2,889 2,879 4,720 6,420 8,882 2,462 38.35% 3210 Electricity 290 280 289 320 320 - 0.00% 3430 Printing 339 149 168 500 400 (100) -20.00% 3610 Memberships 1,925 1,495 2,171 1,936 1,856 (80) -4.13% 3630 Training 9,166 11,387 15,045 12,470 17,770 5,300 42.50% 4010 Rental, equipment - - - - - - 0.00% 4800 Insurance & bonds 40,670 42,602 52,324 54,100 54,500 400 0.74% 5100 Technology maintenance 29,252 121,538 39,937 52,858 60,028 7,170 13.56% 5130 Maintenance, equipment 6,564 6,751 4,009 7,840 9,840 2,000 25.51% Total contractual services 262,882 379,912 310,266 333,410 355,645 22,235 6.67% Capital outlays 7030 Equipment Total capital outlays Total police - 0.00% - 0.00% 2,481,263 2,710,053 2,719,071 2,751,241 2,970,719 219,478 7.98% 19 Fund: 100 Department: 4200 "Police Account Description 2015 2016 2017 2018 Description 1210 Supplies, bldgs & grounds 800 800 500 Carpet cleaning & misc maintenance items 800 800 500 1230 Supplies, equipment < $5000 4,500 4,500 3,000 3,000 Miscellaneous office equip (eticket paper) 800 - - - Laptop - 800 1,000 SLR camera for Investigations add PSO camera $200 2,000 - Shredder 3,000 Rifle mounts (10@$300 $300 each) 4,000 - Bicycles and racks for park patrol (3) 4,000 - 800 800 Alco-sensor portable breath test (PBT's) ($800 each) 10,300 10,300 9,300 9,300 (2) squad computers $7,000, light bar $2,300 19,600 24,600 14,100 13,100 1600 Supplies, operating 3,750 3,400 3,000 3,000 Photo print supplies, fire extinguishers, gloves, inkjet cartridges, toner, etc. 700 700 600 1,200 K9 Food 500 500 500 500 Portable radio batteries (10) @ $50 2,500 2,500 5,000 5,000 Batteries, breathalyzer parts, DVD's & CD's, disinfectant, simulation ammo ammunition, crime scene tape, emergency blankets, etc. 7,450 7,100 9,100 9,700 1700 Motor, fuels, & lubs - 42,300 38,775 32,430 35,250 Unleaded gas 14,100 gallons @ $2.50/gal. 1,125 1,032 863 1,500 K9 take home car gas 600 gallons @ $2.50 43,425 39,807 33,293 36,750 2100 Books & periodicals 900 900 900 300 Traf law, crim. law, HR, employ. law, school year books, & misc. books 900 900 900 300 2400 Uniforms & clothing 710 710 775 775 Chief 710 710 775 775 Deputy Chief 4,000 4,000 4,000 4,000 Initial officer set-ups replacing up to two retiring officers 12,070 12,070 13,175 13,190 14 officers @ $775, 3 sgts @ $780 - 2018, $800 - 2019 1,080 1,080 1,080 1,080 Administrative assistant, Clerk-typist, Community Service Officer 3@$360 1,000 1,000 1,000 1,000 Traffic vests, Taser holsters, & misc items 19,570 19,570 20,805 20,820 3020 Legal, prosecuting attorney 74,214 76,398 78,690 78,690 Retainer ($6,430 per month)(misc charges $1,530) 74,214 76,398 78,690 78,690 3030 Other professional services 700 700 900 900 Tobacco compliance project 150 150 150 150 Hazardous material disposal fee 1,500 1,500 1,400 1,400 Lab fees, blood tests, physical tests, video, mise. 240 240 240 240 Automated Pawn service 1,000 1,000 1,000 1,000 Civil Service and medical testing for new officers 3,590 3,590 3,690 3,690 3050 Dispatching 109,819 106,426 107,131 106,714 Ramsey County dispatching 109,819 106,426 107,131 106,714 3055 Informational systems fees 2,101 2,101 2,080 2,080 State service fee - CJDN ($510 per quarter) - - 2,350 2,350 BCA connectivity charge thio Ramsey Cty for CAD (new) 515 525 525 525 IACP.net ($525 annual) 2,616 2,626 4,955 4,955 3070 COPS events 500 700 1,000 6,000 National night out, town hall meeting, child ID, stickers, shop, bowl, other outr 500 700 1,000 6,000 3080 Veterinarian services 4,200 4,500 1,000 1,000 Hillcrest Veterinary Hospital 1,000 1,000 500 1,000 K9 vet services 5,200 5,500 1,500 2,000 3100 Telephone 2,600 6,420 6,420 5,100 Verizon cell phones (12 phones)(8 smart, 4 basic)($420 accessories) - 3,782 Air cards for squads CAD (9) at $35.01 per month (moved from 5100) 2,600 6,420 6,420 8,882 3210 Electricity 320 320 320 320 Civil defense siren's electricity 320 320 320 320 20 THIS PAGE LEFT BLANK INTENTIONALLY 21 Fund: 100 Department: 4200 Police Account Description 2015 2016 2017 2018 Description 3430 Printing 800 500 500 400 Dept manual, Emergency management manual, business cards, 800 500 500 400 3610 Memberships 100 - - - Assoc. Metro Emergency Managers 50 50 50 - FBULEEDA Law Enfor. Execu. Devel. Assoc. 2@ $50 75 75 75 75 Tri -County Investigator Association 45 45 45 45 Mn Crime Prevention Association 100 130 130 - MN Emergency Managers Assoc. 420 420 420 420 Mn Police chiefs 129 129 150 150 IACP (International Association of Chief of Police) 36 36 36 36 MN Sex Crime Investigators Assoc. 30 30 30 30 Nall, Assoc. School Resource Officers 100 100 100 200 K9 memberships 200 200 200 200 Notary commission (3 year due in 2012)($120+$20) 630 630 630 630 POST license reimbursement 7 @ $90 30 30 35 35 Prof. Law Enforcement Admin. Assoc. 25 35 35 35 National Association of Town Watch 1,970 1,910 1,936 1,856 3630 Training 600 600 710 710 MN Chiefs conference 2@$355 200 200 400 400 BCA/CJDN training (new records tech) 320 320 450 450 Intox certification (6@$75) 1,000 1,000 1,000 1,000 Range Rental 400 400 400 400 MN Sex Crimes Investigators Assoc Conference 3,000 3,000 2,000 2,000 Tuition reimbursement 1,200 1,200 1,400 3,000 Supervisor training 1,500 1,400 1,400 2,800 K9 training 600 600 600 600 Emergency Management training 1,700 1,700 1,700 4,000 Employee development courses 1,615 1,615 1,615 1,615 Patrol on-line program 695 795 795 795 Post training for officers at Century College (1 officers) 12,830 12,830 12,470 17,770 4800 Insurance & bonds 25,000 25,000 25,000 25,000 Liability and automotive insurance 14,100 14,100 14,100 14,500 Insurance per MN Statute 299A.465 25,000 25,000 15,000 15,000 Allowance for insurance policy deductibles 64,100 64,100 54,100 54,500 5100 Technology - maintenance 2,000 2,000 2,000 2,000 Computer network & technology assistance - City of Roseville agreements & support 1,800 1,800 1,000 1,000 Copier maintenance+ overages 2,000 2,000 2,000 4,000 Automatic License plate reader maintenance - - - 2,500 Taser Maintenance - - - 2,500 Watch Guard body camera maintenance 3,840 3,840 3,782 - Air cards for squad CAD (9) at $35.01 per month (move to 3100) - 2,500 3,500 5,185 Milestone video maintenance and licenses 2,428 3,110 3,777 NetMotion 2 factor authentication (state required) - 313 313 CAD interface (Zuercher) 12,500 12,500 15,780 17,380 IT support for squad computers (Roseville) 129,894 20,355 21,373 21,373 Operating costs of police records management system and ticket writer 152,034 47,423 52,858 60,028 5130 Repairs, equipment 3,000 3,000 3,000 2,579 Misc. equipment repair - defibs, cameras, recorders, fax, printers. 450 450 400 800 Fire extinguisher recharging and inspection - - - 2,000 Body Camera Server maintenance 1,500 - - - Squad mobile digital computer repairs 1,000 1,000 1,000 1,000 Civil Defense siren repair & maint. (all 3 were replaced in 06,07,08)(upgraded 4,350 4,000 2,000 2,000 Radio repair (one-time reprogramming fee $50) 1,440 1,440 1,440 1,461 800 MHZ radio licenses fees 39 @ 3.12 per month 11,740 1 9,890 1 7,8401 9,840 7030 Equipment> $5000 5,000 5,000Video Recording system - Interview and breath test rooms 14,400 - AED replacement (9) @ $1,600 (grants of $2500, $3200,$1600) 19,400 51000 - 553,478 436,410 412,108 436,315 42.73% -21.15% -5.57% 5.87% 22 2018 Budget Summary 2014 2015 2016 2017 2018 Change from 2017 Actual Actual Actual Budtet Request Dollar Percent Contractual services 3030 Fire inspection services 5,249 17,412 12,763 15,500 15,500 - 0.00% 3032 Contractual fire services 334,179 356,039 372,284 379,163 423,393 44,230 11.67% 3050 Dispatching - 4,759 5,296 6,000 5,000 (1,000) -16.67% Total contractual services 339,428 378,210 390,343 400,663 443,893 43,230 10.79% Capital outlays: 7040 Vehicles & equipment 22,900 38,925 55,059 40,655 65,036 24,381 59.97% Total capital outlays 22,900 38,925 55,059 40,655 65,036 24,381 59.97% Debt Service: 8010 Principal 108,267 113,336 124,284 109,649 75,135 (34,514) -31.48% 8020 Interest 40,636 37,463 22,495 16,229 19,319 3,090 19.04% Total debt service 148,903 150,799 146,779 125,878 94,454 (31,424) -24.96% Total Fire 511,231 567,934 592,181 567,196 603,383 36,187 6.38% 1,073,769 1,185,775 1,261,488 1,040,831 1,064,568 45,689 1.41 2013 Fire Improvement Refunding Bonds will be retired in 2025 1,084,290 2.13 2017 Equipment Certificates will be retired in 2023 23 Fund: 100 Department: 4210 r Fire Account Description 2015 2016 2017 2018 Description 3030 Fire inspection services 15,500 15,500 15,500 15,500 Contractual fee for Fire Marshalling services (SBM) 15,500 15,500 15,500 15,500 3032 Contractual fire services 356,039 372,283 379,163 423,393 Share of joint fire dept. costs (15-16,424%, 16-16,099%, 17-15,819%, 18-16.158) 356,039 372,283 379,163 423,393 3050 Dispatching 4,355 4,900 6,000 5,000 Anoka County dispatching fee R8810 annual 3% increases 4,355 4,900 6,000 1 5,000 7040 Capital, vehicles & equipment 38,925 55,059 40,655 65,036 Share of joint fire department's capital costs 38,925 55,059 40,655 65,036 8010 8020 Principal - Fire bond Principal - Equip Certs Interest - Fire bond Interest - Equip Certs 63,232 52,557 33,629 1,381 73,251 50,712 22,081 736 74,056 35,593 12,453 3,776 75,135 - 12,127 7,192 16.158% of principal payment on 2013 refunding Fire bonds 16.158% of principal payment on 2017 Equipment Certificates 16.158% of interest payment on 2013 refunding Fire bonds 116.158% of interest payment on 2017 Equipment Certificates 150,799 146,780 1 125,878 94,454 565,618 594,522 567,196 603,383 7.67% 5.11% 4.60% 6.38% 24 2018 Budget Summary 2014 2015 2016 2017 2018 Change from 2017 Actual Actual Actual Budget Request Dollar Percent Recreation (100 - 4350): Contractual services: 3036 Contractual recreation 98,467 111,289 108,241 113,787 117,349 3,562 3.13% 4800 Bonding & insurance 1,122 1,140 1,117 1,700 1,500 (200) -11.76% Total contractual services 99,589 112,429 109,358 115,487 118,849 3,362 2.91% Total Recreation 99,589 112,429 109,358 115,487 118,849 3,362 2.91% 25 Fund: 100 Department: 4350 Recreation Account Description 2015 1 2016 2017 2018 Description 3036 Contractual recreation 102,200 103,713 105,787 110,349 8,700 9,000 8,000 7,000 YMCA Mgt contract (39.5% of $279,364)(est. inflation + 1.5%)(use 3.2%) Ice Skating supervision 110,900 112,713 113,787 117,349 4800 Bonding & insurance 1,700 1,700 1,700 1,500 Insurance & bonding cost. 1,700 1,700 1,700 1,500 112,600 114,413 115,487 118,849 5.04% 1.61% 0.94% 2.91% 26 2018 Budget Summary 2014 2015 2016 2017 2018 Change from 2017 Actual Actual Actual Budget Request Dollar Percent Parks (100 - 4360): Personnel services 0100 Salaries, regular 99,541 116,799 121,805 123,859 122,184 (1,675) -1.35% 0110 Overtime, regular 6,498 8,569 11,190 5,068 4,970 (98) -1.93% 0150 Salaries, part-time 35,701 29,448 24,469 33,180 33,180 - 0.00% 0300 Social Security 10,335 11,318 11,479 12,401 12,265 (136) -1.10% 0321 PERA 7,697 9,376 9,917 9,670 9,537 (133) -1.38% 0322 Pension expense GASB 68 - - 1,194 - - - 0.00% 0400 Group insurance 17,532 20,899 21,399 24,354 24,399 45 0.18% 0500 Workers compensation 7,274 9,129 8,864 10,148 8,270 (1,878) -18.51% 0600 Unemployment 2,701 3,275 3,806 - - - 0.00% Grants & subsidies Total personnel services 187,279 208,813 214,123 218,680 214,805 (3,875) -1.77% Materials & supplies: 1210 Supplies, bldgs & grnds 7,777 6,456 11,681 12,600 10,600 (2,000) -15.87% 1220 Supplies, vehicles & mowers 8,565 4,321 - 8,000 6,500 (1,500) -18.75% 1230 Supplies, equipment 9,803 6,693 6,583 8,500 6,250 (2,250) -26.47% 1600 Supplies, operating 8,131 14,461 9,788 10,900 10,900 - 0.00% 1700 Motor fuels & lubs 14,337 11,692 6,609 7,580 8,200 620 8.18% 2400 Uniforms & clothing 963 1,046 1,241 1,370 1,370 - 0.00% 2410 Mats & towels 479 609 704 728 728 - 0.00% Memberships Total materials & supplies 50,055 45,278 36,606 49,678 44,548 (5,130) -10.33% Contractual services: 3030 Other professional services 8,168 9,744 10,456 10,300 10,300 - 0.00% 3100 Telephone 1,272 1,575 2,014 2,056 2,056 - 0.00% 3200 Water & sewer 6,401 5,442 3,928 6,500 6,500 - 0.00% 3210 Electricity 9,689 10,214 9,711 10,000 10,000 - 0.00% 3220 Natural gas 9,121 4,546 4,057 4,800 4,800 - 0.00% 3530 Refuse collection - - 87 - 0.00% 3610 Memberships 65 - 40 90 90 - 0.00% 3630 Training & conferences 740 913 736 1,670 1,670 - 0.00% 3900 Grants & subsidies 10,608 11,500 11,500 11,500 11,500 - 0.00% 4010 Rental, equipment 1,260 1,096 705 3,900 2,000 (1,900) -48.72% 4030 Portable restrooms 5,642 4,884 6,306 5,000 5,000 - 0.00% 4800 Bonding & insurance 12,010 10,729 10,659 16,000 15,000 (1,000) -6.25% 5110 Repairs, bldg & grounds 5,229 4,185 9,567 13,250 9,250 (4,000) -30.19% 5130 Repairs, equipment - - 1,590 - - - 0.00% Total contractual services 70,205 64,828 71,356 85,066 78,166 (6,900) -8.11% Capital outlays 7030 Equipment 6,145 14,124 - 6,000 - (6,000) -100.00% Total capital outlays 6,145 14,124 - 6,000 - (6,000) -100.00% Total Parks 313,684 333,043 322,085 359,424 337,519 (21,905) -6.09% 110,106 107,962 140,744 122,714 27 Fund: 100 Deparhnent: 4360 Parks Account Description 2015 2016 2017 2018 Description 1210 Supplies, bldgs & grounds 200 200 200 200 Replace bleacher parts 200 200 200 200 Repair hockey boards, gates 300 300 300 300 Sod 3,000 2,000 2,000 2,000 County 10 trailway landscaping mulch, shrubs, and plants 500 500 500 500 Janitorial supplies 150 150 150 150 Snow shovels 200 200 200 200 Ice melt 500 500 500 500 Round up 500 500 500 500 Perennial flowers for park signs 1,500 1,500 1,500 1,500 Damaged building components (windows, locks, etc.) 300 300 300 300 Graffiti remover 500 250 250 250 Goose repellent 2,500 2,000 2,000 2,000 Replace irrigation heads - - 2,000 - City Hall Park sign (estimate) 2,500 2,000 2,000 2,000 Seed, fertilizer 12,850 10,600 12,600 10,600 1220 Supplies, vehicles 7,000 7,000 6,000 3,500 Oil filters, mower blades, tires, vehicle registration fees, 3,000 3,000 2,000 3,000 Miscellaneous repairs 10,000 10,000 8,000 6,500 1230 Supplies, equipment < $5000 250 250 250 250 Drinking fountain parts 250 250 250 250 Field Lights 250 250 250 250 Park signage 1,000 1,000 1,000 1,000 Bases, jox boxes, etc. - 2,000 - - Drag for ball fields - 1,750 Gutter broom attachment - - 500 Chain saw (emergency only)(every 2 years) 2,500 2,500 4,500 4,500 Replace park equipment, fixtures and misc parts 4,250 6,250 8,500 6,250 1600 Supplies, operating 2,000 2,000 2,500 2,500 Fiber fill for play lots & courts 200 200 200 200 Tri mix 1,700 2,000 2,000 2,000 Wood chips for trees 500 500 500 500 Ag -lime for fields 500 500 500 500 Surface drying compound 400 400 800 800 Nets 2,900 3,100 3,100 3,100 Field paint & chalk (partially reimb by school district) 800 800 800 800 Landscaping materials 500 500 500 500 Hand tools 9,500 10,000 10,900 10,900 1700 Motor fuels & lubes 4,500 4,500 5,060 5,500 2,200 gallons of unleaded gas @ $2.50 3,150 3,150 2,520 2,700 900 gallons ofdiesel fuel @ $3.00 7,650 7,650 7,580 8,200 2400 Uniforms & clothing 350 350 350 350 Clothing allowance 2.0 FTE 820 820 820 820 Uniforms 18.2% of $4,500 200 200 200 200 Safety glasses, masks, ear protection, etc. 1,370 1,370 1,370 1,370 2410 Mats & towels 910 728 728 728 Share of floor mats and shop towels 18.2% of $4,000 910 728 728 728 3030 Other professional services 240 240 240 240 Fire extinguisher inspection/maint. (2@ $120) 600 600 600 600 HVAC maintenance 840 840 960 960 Fire sprinkler testing (4@ $210) 120 120 120 120 Backflow prevention testing (2@ $60) 8,500 1 8,500 1 8,380 8,380 Broadleaf control 10,300 1 10,300 1 10,300 10,300 28 THIS PAGE LEFT BLANK INTENTIONALLY 29 Fund: 100 Department: 4360 Parks (continued) Account Description 2015 2016 2017 2018 Description 3100 Telephone 985 850 1,206 850 1,206 850 1,206 850 Cellular phones (13.1% of$9,200) GPS units for mowers (split with dept 4472) 1,835 2,056 2,056 2,056 3200 Water & wastewater 7,000 7,000 6,500 6,500 Parkland irrigation & park bathrooms 7,000 7,000 6,500 6,500 3210 Electricity 7,200 7,200 10,000 10,000 Est. 5 park buildings, park sec. lighting, court & field lighting & misc. 7,200 7,200 10,000 10,000 3220 Natural gas 4,800 4,800 4,800 4,800 Heating cost for Random, Hillview, Groveland, & Lambert Park bldgs. 4,800 4,800 4,800 4,800 3610 Memberships 40 50 60 40 50 - 40 50 - 40 50 - Minnesota Safety Council Playground inspector license Pesticide license renewal (every 2 years) 150 90 90 90 3630 Training & conferences 75 100 60 110 750 375 - 75 100 60 110 750 375 200 75 100 60 110 750 375 200 75 100 60 110 750 375 200 Computer classes Hearing tests/RTN training (2@$50) Maintenance EXPO Loss control workshops Playground inspection training (Certified Playground Safety Inspector CPSI) Equipment training (18.2% of $2,050) Pesticide application class (every 2 years) 1,470 1,670 1,670 1,670 3900 Grants & subsidies 11,500 11,500 11,500 11,500 Lakeside Park share of operating costs 11,500 11,500 11,500 11,500 4010 Rental, equipment 500 2,900 3,900 2,000 Tools and equipment (sod cutter, chipper, concrete mixer, etc...) 500 2,900 3,900 2,000 4030 Portable restrooms 4,850 4,850 5,000 5,000 For May thru Oct, plus special events such as tournaments, & extra cleanings and insurance 4,850 4,850 5,000 5,000 4800 Bonding & insurance 12,000 4,000 12,000 4,000 12,000 4,000 11,000 4,000 Insurance policy premiums Allowance for insurance policy deductibles 16,000 16,000 16,000 15,000 5110 Repairs, bldgs & grounds 750 - 1,000 1,500 1,000 - 2,500 750 - 1,000 7,750 1,000 2,500 2,500 750 4,000 1,000 1,500 1,000 2,500 2,500 750 - 1,000 1,500 1,000 2,500 2,500 Windows, doors, & lock repairs Sandblast trash cans and paint Building exterior repairs Irrigation system repairs (Silver View Park irrigation vault $6,250) Field light repairs Repairs to playground equipment Repairs to furnaces, plumbing, phones, electrical, etc 6,750 15,500 13,250 9,250 7030 Capital, equipment> $5000 6,000 Trencher (irrigation repairs and oak wilt treatments) 6,000 118,885 13U,464 140,744 112;/14 -14.74% 9.74% 7.88% -12.81% 30 2018 Budget Summary 2014 2015 2016 2017 2018 Change from 2017 Actual Actual Actual Budl4et Request Dollar Percent Forestry (100 - 4380): Personnel services 0100 Salaries, regular 2,820 3,006 2,928 2,721 (207) -7.07% 0110 Overtime, regular - 118 185 - - - 0.00% 0300 Social Security - 203 219 224 208 (16) -7.14% 0321 PERA - 221 238 220 204 (16) -7.27% 0400 Group insurance - 530 584 630 600 (30) -4.76% 0500 Workers compensation - 168 160 184 140 (44) -23.91% Total personnel services - 4,060 4,392 4,186 3,873 (313) -7.48% 0.00% Materials & supplies 1200 Supplies, landscaping Total materials & supplies Contractual services 3030 Professional services 3520 Tree removal 3630 Training & conferences Total contractual services Total Forestry 3,018 1,944 1,949 5,900 4,400 (1,500) -25.42% 3,018 1,944 1,949 5,900 4,400 (1,500) -25.42% 2,909 1,577 6,740 11,500 8,000 (3,500) -30.43% 11,437 26,727 15,965 25,000 25,000 - 0.00% 15 170 428 900 900 - 14,361 28,474 23,133 37,400 33,900 (3,500) -9.36% 17,379 34,478 29,474 47,486 42,173 (5,313) -11.19% 30,418 25,082 43,300 38,300 31 Fund: 100 Department: 4380 i Forestry Account Description 2015 2016 2017 2018 Description 1200 Supplies, landscaping 400 400 400 400 Landscaping materials 1,000 1,000 2,000 1,500 Small trees to replace damaged trees 2,000 2,000 3,000 2,500 Large trees - storm damage replacement 5,000 5,000 - - Ash tree replacement trees (MN DNR grant) 2,500 500 500 - EAB treatment supplies 10,900 8,900 5,900 4,400 2400 Uniforms & Clothing - - - - Uniforms/Clothing allowance 3030 Professional services 10,000 5,000 5,000 5,000 Tree trimming 500 500 500 500 Asset mgt. software 25,000 15,000 5,000 2,500 Forestry consulting 1,000 1,000 1,000 - Tree injections (Ash every 2 years) 36,500 1 21,500 11,500 8,000 3520 Tree removal 28,000 25,000 25,000 25,000 Remove or treat diseased trees 7,500 7,500 - - Ash tree removal (NIN DNR grant) 35,500 32,500 25,000 25,000 3630 Training & memberships 300 800 800 800 Tree Inspector training 100 100 100 100 Tree Inspector license 400 900 1 900 900 83,300 63,800 43,300 38,300 -14.12% -23.41% -32.13% -11.55% K& 2018 Budget Summary 2014 2015 2016 2017 2018 Change from 2017 Actual Actual Actual Budjzet Request Dollar Percent Public Works Administration (100-4410): 3030 Personnel services: 524 336 1,073 900 900 - 0.00% 3100 0100 Salaries, regular 107,821 86,232 101,413 106,006 109,738 3,732 3.52% 0110 Salaries, overtime 141 - - - - - 0.00% 0300 Social Security 7,782 5,856 7,223 8,109 8,395 286 3.53% 0321 PERA 7,753 5,843 7,562 7,950 8,230 280 3.52% 0400 Group insurance 13,202 11,422 14,579 16,416 17,483 1,067 6.50% 0500 Workers compensation 1,839 1,885 1,215 1,405 1,213 (192) -13.67% Total personnel services 138,538 111,238 131,992 139,886 145,059 5,173 3.70% Materials & supplies: 1230 Supplies, equipment 130 - - - - - 0.00% 1600 Operating supplies 297 300 45 300 230 (70) -23.33% 2400 Uniforms & clothing - 56 180 400 200 (200) -50.00% Total materials and supplies 427 356 225 700 430 (270) -38.57% Contractual services: 3030 Other professional services 524 336 1,073 900 900 - 0.00% 3100 Telephone 636 616 709 773 773 - 0.00% 3610 Memberships 632 430 507 490 755 265 54.08% 3630 Training & conferences 490 600 1,164 895 895 - 0.00% 3800 Mileage reimbursement 290 203 - 300 150 (150) -50.00% Total contractual services 2,572 2,185 3,453 3,358 3,473 115 3.42% Total public works administration 141,537 113,779 135,670 143,944 148,962 5,018 3.49% 2,541 3,678 4,058 3,903 33 Fund: 100 Department: 4410 Public Works Adminstration Account Description 2015 2016 2017 2018 Description 1600 Operating Supplies 230 230 230 230 Office supplies 70 70 70 - National Public Works Week posters 300 300 300 230 2400 Uniforms & clothing 400 400 400 200 33% of Supervisor's uniform cost. 400 400 400 200 3030 Other professional services 100 100 100 100 Physicals & drug testing - new employee 500 500 500 500 Asset mgt software 300 300 300 300 Drug & alcohol testing - federal mandate 900 900 900 900 3100 Telephone 630 773 773 773 Cellphone (8.4% of $9,200) 630 773 773 773 3610 Memberships/license fee 190 375 400 400 American Public Works Association memb. (APWA) (1/2 of $800) 60 60 60 60 City Engineer's Association of MN (CEAM) - - - - NASASP (National Assoc. of State Agencies for Surplus Property) 30 30 30 30 MN Safety Council - 265 - 265 MN Board of AELSLAGID (PE Renewal even years) 250 - - - American Society of Civil Engineers 530 730 490 755 3630 Training & conferences 500 1,500 500 500 CEAM / APWA conferences 50 50 50 50 Computer classes/Web training 15 15 15 15 Hearing tests/RTN training (34 FPE@$50) 30 30 30 30 Maintenance Expo 200 200 200 200 Required continuing education seminars 100 100 100 100 1 Supervisor training 895 11895 1 895 895 3800 Mileage reimbursement 300 300 300 150 vehicle mileage reimbursement 300 300 300 150 3,9» ),2925 4,V:) ?s .1,903 5.05% 33.96% -23.41% -3.82% 34 2018 Budget Summary Materials & supplies: 1210 2014 2015 2016 2017 2018 Change from 2017 Supplies, operating 2400 Actual Actual Actual Budget Request Dollar Percent Building & Grounds Maintenance (100 - 4460): Rental, equipment 4800 Insurance 5110 Repairs, bldgs & grounds 5130 Personnel services: 91 Total contractual services 117 117 - 0.00% 925 750 0100 Salaries, regular 12,389 13,885 14,106 14,141 11,481 (2,660) -18.81% 0110 Salaries, overtime 626 382 447 1,048 757 (291) -27.77% 0300 Social Security 946 1,052 1,065 1,161 936 (225) -19.38% 0321 PERA 934 1,053 1,071 1,140 918 (222) -19.47% 0400 Group insurance 2,943 2,413 2,468 2,952 2,850 (102) -3.46% 0500 Workers compensation 641 1,153 828 945 628 (317) -33.54% 89,573 Total personnel services 18,479 19,938 19,985 21,387 17,570 (3,817) -17.85% Materials & supplies: 1210 Supplies, building & grounds 1220 Supplies, vehicles 1230 Supplies, equipment 1600 Supplies, operating 2400 Uniforms & clothing 2410 Mats & towels 3610 Total materials & supplies Contractual services: 3030 Other professional services 3100 Telephone 3200 Water & sewer 3210 Electricity 3220 Natural gas 3530 Refuse collection 3610 Memberships 3630 Training & conferences 4010 Rental, equipment 4800 Insurance 5110 Repairs, bldgs & grounds 5130 Repairs, equipment 91 Total contractual services Capital outlays 7030 Equipment Total capital outlays Total buildings & grounds 2,283 3,762 2,065 2,000 2,000 - 0.00% - 68 - - - - 0.00% 825 209 90 1,300 1,000 (300) -23.08% 2,534 3,570 3,077 4,300 4,300 - 0.00% 103 91 132 117 117 - 0.00% 925 750 1,295 630 1,000 370 58.73% 6,670 8,450 6,659 8,347 8,417 70 0.84% 18,737 31,200 27,483 36,160 35,960 (200) -0.55% 112 97 117 129 129 - 0.00% 807 786 949 1,000 1,000 - 0.00% 28,341 27,793 26,149 14,000 20,000 6,000 42.86% 26,488 17,502 12,446 19,000 17,000 (2,000) -10.53% 7,806 7,611 7,954 9,334 8,500 (834) -8.94% 10 - - - - - 0.00% 19 10 19 - - - 0.00% - - - 200 200 - 0.00% 4,621 4,694 4,598 7,000 7,000 - 0.00% 10,208 24,920 3,129 11,100 10,100 (1,000) -9.01% 4,409 2,179 6,729 5,000 5,000 - 0.00% 101,558 116,792 89,573 102,923 104,889 1,966 1.91% 125,242 96,232 111,270 113,306 - 246,729 - - - - 0.00% - 246.729 - - - - 0.00% 126,707 391,909 116,217 132,657 130,876 (1,781) -1.34% 35 Fund: 100 Department: 4460 Building & Ground Maintenance Account Description 2015 2016 2017 2018 Description 1210 Supplies, bldgs & grounds 2,000 2,000 2,000 2,000 Bldg repairs, cleaningtheating supplies, batteries 2,000 2,000 2,000 2,000 1230 Supplies, equipment < $5000 1,300 1,300 1,300 1,000 Repair parts, filters, hoses, etc., office furniture 1,300 1,300 1,300 1,000 1600 Supplies, operating 500 1,500 1,500 1,500 Cleaning supplies 300 150 150 150 Lumber & fasteners 550 300 300 300 Repair items & hardware 300 100 100 100 First aid supplies 500 200 200 200 Light bulbs & ballasts 500 750 750 750 Paper supplies 500 400 400 400 Mechanical items, fans, motors, etc 100 - - - Goose repellent 200 - - Weed control - city hall 200 200 200 200 Office supplies 700 700 700 700 Paint & supplies - parking lot & building 4,350 4,300 4,300 4,300 2400 Uniforms & clothing 81 81 81 81 Uniforms (1.8%of$4,500) 36 36 36 36 Clothing & boot allowance (.20 @$175) 117 117 117 117 2410 Mats & towels 90 90 90 90 Share of floor mats and shop towels (1.8% of $5,000) 540 540 540 910 Floor mats at CH ($45/month) 630 630 630 1,000 3030 Other professional services 180 180 180 180 Backflow prevention testing (3@$60) 60 60 60 60 Boiler & pressure vessel registration program 5,500 5,520 5,520 5,520 HVAC maintenance (City Hall & PW facilities) 100 100 100 100 MN DOL operating permit - elevator (previously in acct. 5110) 18,000 19,500 19,500 19,500 City Hall cleaning contract (renews in 2016) 3,500 3,500 3,500 3,500 Carpet cleaning, floor striping & waxing (2 times) 680 680 680 680 Fire sprinkler testing 1,320 1,320 1,320 1,320 Pest control (12@$110) 200 200 200 - MDH Monitoring well maint. permit - PW bldg. (wells sealed) - - 4,500 4,500 Service contract for generator 600 600 600 600 Fire extingiusher inspection/service (30@$20) 30,140 31,660 36,160 35,960 3100 Telephone 120 129 129 129 Cellphone (1.6% of$7,500)($9,200) 120 129 129 129 3200 Water & Sewer 1,400 1,400 1,000 1,000 Service at City Hall and Public Works buildings 1,400 1,400 1,000 1,000 3210 Electricity 28,000 14,000 14,000 20,000 Electricity at City Hall and Public Works buildings 28,000 14,000 14,000 20,000 3220 Natural gas 20,000 20,000 19,000 17,000 Natural gas at City Hall and Public Works buildings 20,000 20,000 19,000 17,000 3530 Refuse collection 3,161 1,630 1,030 196 Hazardous waste disposal, Lamps $100, batteries $30 264 264 264 264 Hazardous waste annual fee (State of MN PCA) 230 90 90 90 Hazardous waste generator license fee (Ramsey County) 150 150 150 150 Used oil filters ($100 in vehicle maint.) 7,200 7,200 7,800 7,800 Facility dumpsters, city hall, public works 11,005 9,334 9,334 8,500 4010 Rental, equipment 200 200 200 200 Misc. rentals 200 200 200 200 4800 Bonding & insurance 5,500 5,500 5,500 5,500 Insurance policy premiums 1,500 1,500 1,500 1,500 Allowance for insurance policy deductibles 7,000 7,000 7,000 7,000 5110 Repairs, bldgs & grounds 2,500 2,500 2,500 1,500 Door & gate opener repairs 2,500 2,500 2,500 2,500 Building repairs 750 750 750 750 Elevator maintenance & repairs 350 350 350 350 Fire sprinklers & alarm repairs 5,000 5,000 5,000 5,000 General building & ground maintenance 11,100 11,100 11,100 10,100 5130 Repairs, equipment 5,000 51000 5,000 5,000 HVAC, plumbing & electrical repairs 5,000 5,000 5,000 5,000 122,362 108,1"/U 111,2'/U 113,306 7.17% -11.60% 2.87% 1.83% im 2018 Budget Summary Materials & supplies: 1220 2014 2015 2016 2017 2018 Change from 2017 Motor fuels & lubricants - unleadf 1701 Actual Actual Actual Budget Reuuest Dollar Percent Vehicle & Equipment Maintenance (100 - 4465): 3,359 3,260 3,260 - 0.00% 7,663 85 Personnel services: - - - 0.00% 414 878 654 375 0100 Salaries, regular 33,251 34,939 29,313 36,826 39,916 3,090 8.39% 0110 Salaries, overtime 1,110 - - 556 605 49 8.81% 0300 Social Security 2,492 2,540 2,133 2,860 3,099 239 8.36% 0321 PERA 2,490 2,579 2,188 2,804 3,038 234 8.35% 0400 Group insurance 5,565 4,635 4,767 7,344 7,650 306 4.17% 0500 Workers compensation 1,628 2,487 1,648 1,785 1,593 (192) -10.76% Total personnel services 46,536 47,180 40,049 52,175 55,901 3,726 7.14% Materials & supplies: 1220 Supplies, vehicles 1230 Supplies, equipment 1600 Supplies, operating 1700 Motor fuels & lubricants - unleadf 1701 Motor fuels & lubricants - diesel 2400 Uniforms & clothing 2410 Mats & towels 4,200 Total materials & supplies Contractual services: 16,616 9,522 17,722 19,950 19,950 - 0.00% 4,752 5,027 4,378 4,100 5,500 1,400 34.15% 3,771 6,404 6,065 4,200 4,650 450 10.71% 4,051 2,074 3,359 3,260 3,260 - 0.00% 7,663 85 - - - - 0.00% 414 878 654 375 375 - 0.00% 180 185 190 220 220 - 0.00% 37,447 24,175 32,368 32,105 33,955 1,850 5.76% 3030 Other professional services 18 17 25 - 0.00% 3100 Telephone 263 228 268 387 387 - 0.00% 3530 Refuse collection - - - 100 100 - 0.00% 3610 Memberships 606 - - 80 80 - 0.00% 3630 Training 283 54 203 920 625 (295) -32.07% 4010 Rental, equipment - - - 100 100 - 0.00% 5120 Repairs, vehicles 19,894 6,872 7,114 16,800 16,800 - 0.00% 5130 Repairs, equipment 4,914 5,805 6,939 5,500 5,500 - 0.00% Total contractual services 25,978 12,976 14,549 23,887 23,592 (295) -1.23% Capital outlays 7030 Equipment 6,050 - - - - - 0.00% Total capital outlays 6,050 - - - - - 0.00% Total vehicle & equipment maintenance 116,011 84,331 86,966 108,167 113,448 5,281 4.88% 37,151 46,917 55,992 57,547 37 Fund: 100 Department: 4465 Vehicle & Equipment Maintenance Account Description 2015 2016 2017 2018 Description 1220 Supplies, vehicles 200 200 200 200 Brake fluid 700 700 700 700 Misc parts, fastners 500 500 500 500 Antifreeze 300 300 300 300 Air conditioning gas 500 500 500 500 Headlamps, spots, & bulbs 800 800 800 800 Tune up items 500 500 500 500 Wiper blades & fluid 1,950 1,950 1,950 1,950 Minor repairs, rebuilds 1,500 1,500 1,500 1,500 Automotive parts 2,000 2,000 2,000 2,000 Filters: oil, air, fuel, transmission 2,000 2,000 2,000 2,000 Brake pads & shoes 9,000 9,000 9,000 9,000 Tires & batteries 19,950 19,950 19,950 19,950 1230 Supplies, equipment < $5000 200 200 200 1,000 Small equipment tune up items 400 400 400 1,000 Filters belts & hoses 1,000 1,000 1,000 1,000 Hydraulic system repair; 2,500 2,500 2,500 2,500 Vehicle Asset Management software 3,700 3,700 - - Tire mounting machine (defer to 2016)(bought code scanner in 2015) 2,000 2,000 - - Tires 9,800 9,800 4,100 5,500 1600 Supplies, operating 1,200 1,200 1,200 1,000 Battery charger, Load tester 350 350 350 350 Welding supplies 100 100 100 500 Chains, clevises, & hitch pins 700 700 700 700 Equipment & vehicle cleaning supplies 500 500 500 500 Steel for repairs & fabrication 350 350 350 350 License tabs 500 500 500 750 Solvents & degreasers 500 500 500 500 Fastners & electrical supplies 4,200 4,200 4,200 4,650 1700 Motor fuels & lubricants 60 60 60 60 Gear lube 200 200 200 200 ATF - 7 cases 500 500 500 500 Aftermarket additives 2,500 2,500 2,500 2,500 Engine oil: 150 gallons (synthetic) 3,260 31260 3,260 3,260 2400 Uniforms & clothing 249 249 270 270 Uniforms 6% of $4,500) 105 105 105 105 Clothing and boot allowance (.6@$175) 354 354 375 375 2410 Mats & towels 275 220 220 220 Share of floor mats and shop towels (5.5% of $4,000) 275 220 220 220 3100 Communications 308 387 387 387 Cellular telephone (4. 1 % of $9,200) 308 387 387 387 3530 Refuse collection 100 100 100 100 Oil filter recycling ($150 in 4460-3530) 100 100 100 100 3610 Memberships 60 60 60 60 Vehicle inspection license renewal (DOT required) 20 20 20 20 Minnesota Safety Council (6% of $465) 80 80 80 80 3630 Training 30 30 30 30 Hearing test/RTN training (.6@$50) 30 30 30 30 Maintenance Expo 200 200 495 200 Misc training 175 175 175 175 ASE certification 75 1 190 190 190 Vehicle inspection recertification (DOT required) 510 625 920 625 4010 Rental, equipment 100 100 100 100 Specialty tool & -equipment rental 100 100 100 100 5120 Repairs, vehicles 8,000 8,000 8,000 8,000 Accident repairs 750 750 750 750 Alignments 1,000 1,000 1,000 1,000 Glass replacement 400 400 400 400 Radiator repairs, replacement 2,000 2,000 1,960 1,960 Tire repairs 700 950 950 950 Ignition scanner sollware update 1,700 1,700 1,740 1,740 Mitchell On Demand Software 2,000 2,000 2,000 2,000 Transmission repairs 16,550 16,800 16,800 16,800 5130 Repairs, equipment 500 500 500 500 Accident repairs 3,000 3,000 3,000 3,000 Mechanical repairs 2,000 2,000 2,000 2,000 Motor repairs 5,500 5,500 5,500 5,500 7030 Capital, equipment > $5000 - - - - Hoist adaptor bu,gs / 01,3Yb »,`JYL D /,:)4 / 2.50% 0.64% -8.77% 2.78% 38 2018 Budget Summary Materials & supplies: 1230 Supplies, equipment 2014 2015 2016 2017 2018 Change from 2017 -49.15% 1240 Actual Actual Actual Budget Request Dollar Percent Street Pavement Management (100 - 4470): Supplies, traffic control 429 - 1,375 750 1,600 Personnel services: 113.33% 1600 Supplies, operating 2,815 2,250 1,479 1,000 0100 Salaries, regular 102,349 114,727 116,046 117,480 118,912 1,432 1.22% 0110 Salaries, overtime 3,470 3,154 2,982 3,379 3,487 108 3.20% 0150 Salaries, part-time 5,910 5,452 3,872 7,488 7,488 - 0.00% 0300 Social Security 8,253 8,938 8,935 9,817 9,936 119 1.21% 0321 PERA 7,527 8,541 8,465 9,064 9,180 116 1.28% 0322 Pension expense GASB 68 - - 1,709 - - - 0.00% 0400 Group insurance 11,703 13,953 14,585 18,972 19,832 860 4.53% 0500 Workers compensation 7,123 10,532 8,359 9,530 8,335 (1,195) -12.54% Total personnel services 146,335 165,297 164,953 175,730 177,170 1,440 0.82% Materials & supplies: 1230 Supplies, equipment 5,712 469 30 2,950 1,500 (1,450) -49.15% 1240 Supplies, streets 25,299 5,411 2,193 10,000 7,500 (2,500) -25.00% 1260 Supplies, traffic control 429 - 1,375 750 1,600 850 113.33% 1600 Supplies, operating 2,815 2,250 1,479 1,000 1,000 - 0.00% 1700 Motor fuels & lubricants 9,515 6,391 4,356 7,650 8,250 600 7.84% 2400 Uniforms & clothing 917 820 1,394 701 701 - 0.00% 2410 Mats & towels 351 397 399 436 436 - 0.00% Total materials & supplies 45,038 15,738 11,226 23,487 20,987 (2,500) -10.64% Contractual services: 3030 Other professional services 5,279 11,975 2,486 20,950 18,450 (2,500) -11.93% 3100 Telephone 756 641 718 966 966 - 0.00% 3610 Memberships 247 190 195 255 255 - 0.00% 3630 Training & conferences 583 760 838 1,115 1,115 - 0.00% 4010 Rental, equipment 1,125 4,500 850 6,100 6,100 - 0.00% 4800 Insurance 6,261 4,157 4,073 6,200 6,200 - 0.00% 5130 Repairs, equipment - 10 7 500 500 - 0.00% Total contractual supplies 14,251 22,233 9,167 36,086 33,586 (2,500) -6.93% Total street pavement management 205,624 203,268 185,346 235,303 231,743 (3,560) -1.51% 37,971 20,393 59,573 54,573 39 Fund: 100 Department: 4470 Pavement Management Account Description 2015 2016 2017 2018 Description 1230 Supplies, equipment < $5000 500 500 500 500 Safety vests and other safety equipment - - 1,000 1,000 Radio/hearingprotection 500 - Push mower 450 Chainsaw 500 Backpack blower 500 500 2,950 1,500 1240 Supplies, street repair 20,000 20,000 7,500 5,000 Asphalt & concrete for street patching & curb repair 1,000 1,000 1,000 1,000 Disposal 1,500 1,500 1,500 1,500 Bituminous tack coat/crack fill material 22,500 22,500 10,000 7,500 1260 Supplies, traffic control 400 400 250 725 Traffic cones/baracades 600 600 500 875 portable signs (traffic control) 1,000 1,000 750 1,600 1600 Supplies, operating 650 650 850 850 Asphalt hand tools, rakes, etc. 100 100 150 150 Batteries, shop supplies, etc. 750 750 1,000 1,000 1700 Motor fuels & lubricants 5,250 5,250 4,200 4,500 Diesel fuel: 1500 gallons @ $3.00 4,500 4,125 3,450 3,750 Unleaded fuel: 1500 gallons @ $2.50 9,750 9,375 7,650 8,250 2400 Uniforms & clothing 491 491 491 491 Uniforms (10.9% of $4,500) 210 210 210 1 210 Clothing and boot allowance (1.2@$175) 701 701 701 701 2410 Mats & towels 545 436 436 436 Share of floor mats and shop towels (10.9% of $4,000) 545 436 436 436 3030 Other professional services 1,800 1,800 1,800 1,800 Pavement Mgmt sofhvare annual maintenance. 2,500 2,500 2,500 2,500 Engineering services. 500 500 500 500 Asset management software annual maintenance 500 650 650 650 ROW weed control 1,500 1,500 1,500 - Material dump charges 2,000 2,000 2,000 1,000 Sidewalk joint corrections - - 12,000 12,000 CSAH 10 median and ROW maintenance (mowing and weed wipping) - - - - Striping of streets (Ramsey County)(move to 4475) 8,800 8,950 20,950 18,450 3100 Communications 893 966 966 966 Cellular telephones (10.5% of $9,200) 893 966 966 966 3610 Memberships 190 190 200 200 American Public Works Association memb. (APWA) (1/4 of $800) - 15 15 15 Pesticide license renewal (TF) 40 1 40 40 40 MN Safety Council 230 245 255 255 3630 Training & conferences 50 50 50 50 Computer classes 200 200 200 200 Electronics updates, other classes 60 60 60 60 Hearing test/RTN training (1. 16@$50) 60 60 60 60 Maintenance Expo 150 150 150 150 APWA/MN conferences. 250 250 250 250 Pavement, sealcoating, patching & sealcoating seminars. 210 210 210 210 Equipment operator training 60 60 60 60 Vehicle inspection license renewal 75 75 75 75 Vehicle inspection recertification 300 - - - Work zone traffic control (every 3 years) 1,415 1,115 1,115 11115 4010 Rentals, equipment 2,800 2,800 3,600 3,600 Annual trade-in of skidsteer loaders (no trade-in during 2017) 700 2,500 2,500 2,500 Specialized equip rental (chipper, crack sealing,) 3,500 5,300 6,100 6,100 4800 Bonding & insurance 4,800 4,800 4,800 4,800 Insurance policy premiums 1,400 1,400 1,400 1,400 Allowance for insumace policy deductibles 6,200 61200 6,200 6,200 5130 1 Repairs, equipment 500 5,000 500 - 500 - 500 - Misc. equipment repairs Repair crack filling machine (will not repair, rent instead)(see 4010) 5,500 500 500 500 6l,liS4 �2S,�S25 3v,:) /3 D4,5 /3 -8.10% -6.01% 1.77% -8.39% 40 2018 Budget Summary Materials & supplies: 1230 Supplies, equipment 2014 2015 2016 2017 2018 Change from 2017 1600 Supplies, operating Actual Actual Actual BudEet Request Dollar Percent Street Snow & Ice Control (100 - 4472): 3,586 3,215 2,980 3,180 200 6.71% 2400 Uniforms & clothing Personnel services: 397 487 528 528 - 0.00% 2410 Mats & towels 0100 Salaries, regular 62,998 60,902 62,061 60,224 62,355 2,131 3.54% 0110 Salaries, overtime 19,281 7,711 9,926 8,130 8,609 479 5.89% 0300 Social Security 5,944 5,016 5,164 5,229 5,429 200 3.82% 0321 PERA 5,855 4,852 5,431 5,127 5,323 196 3.82% 0400 Group insurance 11,550 7,972 8,513 11,520 12,000 480 4.17% 0500 Workers compensation 6,116 8,074 6,538 7,464 6,381 (1,083) -14.51% Total personnel services 111,744 94,527 97,633 97,694 100,097 2,403 2.46% Materials & supplies: 1230 Supplies, equipment 19,758 8,185 1,942 9,500 7,400 (2,100) -22.11% 1600 Supplies, operating 41,589 24,726 25,005 31,175 31,175 - 0.00% 1700 Motor fuels & lubricants 13,786 3,586 3,215 2,980 3,180 200 6.71% 2400 Uniforms & clothing 457 397 487 528 528 - 0.00% 2410 Mats & towels 331 341 356 328 328 - 0.00% Repairs, equipment Total materials & supplies 75,921 37,235 31,005 44,511 42,611 (1,900) -4.27% Contractual services: 3030 Other professional services 1,592 1,321 1,400 1,325 1,375 50 3.77% 3100 Telephone and data cards 753 1,713 907 1,179 1,179 - 0.00% 3610 Memberships 70 - - 70 70 - 0.00% 3630 Training & conferences 84 118 185 285 285 - 0.00% 5130 Repairs, equipment 3,373 22 821 2,500 2,500 - 0.00% Total contractual supplies 5,872 3,174 3,313 5,359 5,409 50 0.93% Capital outlays 7030 Equipment 2,618 - - - - - 0.00% Total capital outlays 2,618 - - - - - 0.00% Total streets snow & ice control 196,155 134,936 131,951 147,564 148,117 553 0.37% 40,409 34,318 49,870 48,020 41 Fund: 100 Department: 4472 Snow & 3ee Control Account Description 2015 2016 2017 2018 Description 1230 Supplies, equipment < $5000 250 - 1,800 250 - 1,800 500 3,000 4,000 - 2,000 500 4,500 - 400 2,000 Filters Skidsteer broom Snow blower for skid steer Chloride Tank Cutting edges, plow shoes 2,050 2,050 9,500 1 7,400 1600 Supplies, operating 800 2,250 28,000 800 2,250 28,125 800 2,250 28,125 800 2,250 28,125 Welding supplies, steel stock, sod for boulevards, etc. Liquid Mg Chloride: 1,500 gallons @ $1.50 per gallon. Salt: 375 tons @ $75 per ton. 31,050 31,175 31,175 31,175 1700 Motor fuels & lubricants 180 3,500 180 3,500 180 2,800 180 3,000 Engine oil: 30 gallons @ $6.00 per gallon. Diesel fuel: 1,000 gallons @ $3.00 per gallon. 3,680 3,680 2,980 1 3,180 2400 Uniforms & clothing 370 158 370 158 370 158 370 158 Uniforms (8.2% of $4,500) Clothes & boots allowance (.9@$175) 528 528 528 528 2410 Mats & towels 410 328 328 328 Cost share of mats & towels (8.2% of $4,000) 410 328 328 328 3030 Other professional services 1,200 1,200 1,325 1,375 Weather service reports 1,200 1,200 1,325 1,375 3100 Telephone 473 360 579 1,680 579 600 579 600 Cellphone (6.3% of $7,500)($9,200) GPS data cards 833 2,259 1,179 1,179 3610 Memberships 70 70 70 70 Minnesota Safety Council 70 70 70 70 3630 Training 75 400 75 400 85 200 85 200 Hearing tests/RTN training (1.1 @$XX) Defensive Driving class (2 staff) 475 475 285 285 5130 Repairs, equipment 2,500 2,500 2,500 2,500 Plow, blower, salt spreader repairs, paint plow assemblies 2,500 2,500 2,500 2,500 7030 Capital, equipment > $5000 5,600 8,350 - - - Plow control update (#445) GPS equipment for plow trucks 13,950 56,746 44,265 49,870 48,020 -10.64% -21.99% 12.66% -3.71% 42 2018 Budget Summary Materials & supplies: 2014 2015 2016 2017 2018 Change from 2017 1600 Supplies, operating 1,590 Actual Actual Actual Budget Request Dollar Percent Street Sign Maintenance (100 - 4475): 143 147 435 435 - 0.00% 2410 Mats & towels Personnel services: 122 125 160 160 - 0.00% Total materials & supplies 0100 Salaries, regular 23,579 18,442 18,377 18,721 18,333 (388) -2.07% 0110 Salaries, overtime 450 657 547 845 872 27 3.20% 0150 Salaries, part-time - - - 2,496 2,496 - 0.00% 0300 Social Security 1,787 1,399 1,365 1,689 1,661 (28) -1.66% 0321 PERA 1,696 1,399 1,369 1,467 1,441 (26) -1.77% 0400 Group insurance 2,698 2,526 2,467 3,456 3,600 144 4.17% 0500 Workers compensation 2,188 1,966 1,561 1,778 1,500 (278) -15.64% Total street sign maintenance Total personnel services 32,398 26,389 25,686 30,452 29,903 (549) -1.80% Materials & supplies: 1600 Supplies, operating 1,590 10,570 4,502 28,500 28,500 - 0.00% 2400 Uniforms & clothing 165 143 147 435 435 - 0.00% 2410 Mats & towels 119 122 125 160 160 - 0.00% Total materials & supplies 1,874 10,835 4,774 29,095 29,095 - 0.00% Contractual services: 3030 Other professional services - 11 3,762 500 4,500 4,000 800.00% 3100 Telephone 180 157 183 230 230 - 0.00% 3250 Electricity - traffic signals 2,569 2,906 2,647 3,000 3,000 - 0.00% 3630 Training & conferences 30 17 30 100 20 (80) -80.00% 5130 Repairs, equipment 291 - - 500 500 - 0.00% Total contractual supplies 3,070 3,091 6,622 4,330 8,250 3,920 90.53% Total street sign maintenance 37,342 40,315 37,082 63,877 67,248 3,371 5.28% 43 Fund: 100 Department: 4475 Street Sign Maintenance Account Description 2015 2016 2017 2018 Description 1600 Supplies, operating 17,500 7,500 1,750 500 500 - 17,500 7,500 1,750 500 500 750 17,500 7,500 1,750 500 500 750 17,500 7,500 1,750 500 500 750 Signs, posts, sign hardware, and supplies Street name sign panels, posts, hardware Pavement marking paint (moved from 4470) Shop supplies - fastners, degreasers, etc Graffitti remover (3) Traffic counters 27,750 28,500 28,500 28,500 2400 Uniforms & clothing 81 354 81 354 81 354 81 354 Uniforms (1.8% of $4,500) Clothes and boot allowance (.2@$175) 435 435 435 435 2410 Mats & towels 340 160 160 160 Cost share of mats & towels (4% of $4,000) 340 1 160 160 160 3030 Other professional services 5,000 500 5,000 500 - 500 4,000 500 Contract pavement marking (Ramsey Co)(moved from 4470) Asset management sofhvare annual maintenance 5,500 5,500 500 4,500 3100 Telephone 200 230 230 230 Cellphone (2.5% of $8,000)($9,200) 200 230 230 230 3250 Electricity -traffic signals 2,000 2,000 3,000 3,000 Electricity for traffic signals 2,000 21000 3,000 3,000 3630 Training & conferences 80 20 80 20 80 20 - 20 Equipment operator training Hearing test/RTN trainging (.4@$50) 100 100 100 20 5130 Repairs, equipment 500 500 500 500 Traffic signal repairs & maintenance 500 500 500 500 36,825 37,425 33,425 37,345 289.68% 1.63% -10.69% 11.73% Grand Total all PW Departments 343,159 315,072 314,188 314,694 7.86% -8.18% -0.28% 0.16% 44 2018 Budget Summary 2014 2015 2016 2017 2018 Change from 2017 Actual Actual Actual Budget Request Dollar Percent Convention & Visitor's Bureau (100-4653) Contractual services 3045 N Metro Convention Bureau 63,049 65,654 64,038 61,750 61,750 - 0.00% Total contractual services 63,049 65,654 64,038 61,750 61,750 - 0.00% Total Convention & Visitor's Bureau 63,049 65,654 64,038 61,750 61,750 - 0.00% Miscellaneous (100 - 4700): Debt Service ESP 8011 Lease payable Personnel services 8021 Interest - - 6,704 6,165 5,609 (556) -9.02% 9900 Transfers - EDA 0300 Social security 248 210 171 - - - 0.00% 0321 PERA 306 388 439 - - - 0.00% 0400 Group insurance 489 488 540 - - - 0.00% 0750 Fitness program 3,883 3,889 3,911 6,500 6,500 - 0.00% Total personnel services 4,926 4,975 5,061 6,500 6,500 - 0.00% Contractual services 3065 Family & youth social services 19,763 20,178 20,259 20,461 20,748 287 1.40% Total contractual services 19,763 20,178 20,259 20,461 20,748 287 1.40% Miscellaneous Debt Service ESP 8011 Lease payable - 20,268 17,791 18,331 18,887 556 3.03% 8021 Interest - - 6,704 6,165 5,609 (556) -9.02% 9900 Transfers - EDA - 16,000 50,000 50,000 50,000 - 0.00% 9900 Transfers - Vehicle & Equip. Funt 100,000 110,000 150,000 175,000 250,000 75,000 42.86% 9900 Transfers - Special Projects 825,000 200,000 375,000 75,000 75,000 - 0.00% 9900 Community Center 165,000 170,000 170,000 175,000 190,000 15,000 8.57% Total miscellaneous 1,090,000 496,000 745,000 475,000 565,000 90,000 18.95% 0.00% Total miscellaneous 1,114,689 521,153 770,320 501,961 592,248 90,287 17.99% Debt Service (100 - 4750): Debt Service ESP 8011 Lease payable - 20,268 17,791 18,331 18,887 556 3.03% 8021 Interest - - 6,704 6,165 5,609 (556) -9.02% 8030 Paying agent fees - - - - - - 0.00% Total debt service - 20,268 24,495 24,496 24,496 - 0.00% 45 Fund: 100 Department: 4653 Convention & Visitor's Bureau Account Description 2015 2016 2017 2018 Description 3045 N Metro Convention Bureau 53,200 60,800 61,750 61,750 Payment of 95% of hotel/motel tar collections to (3% tax on gross receipts) support the promotion of tourism. (City retains 5% for administration) 53,200 60,800 61,750 61,750 Fund: 100 Department: 4700 Debt Service Account Description Miscellaneous Account Description 2015 2016 2017 2018 Description 0750 Fitness program 6,500 6,500 6,500 6,500 Fitness program (maximum $55/month paid with employee sick leave time). 6,500 6,500 6,500 6,500 3065 Family & youth social services 20,178 20,783 20,461 20,748 Northeast Youth and Family Services (NYFS)(1.4%- 2018) 20,178 20,783 20,461 20,748 9900 Transfers - miscellaneous 10,000 50,122 50,000 75,000 50,000 75,000 50,000 75,000 Transfer to Economic Development Authority (EDA) Transfer to Special Projects fund 60,122 125,000 125,000 125,000 9900 Transfers - miscellaneous 110,000 150,000 175,000 250,000 Transfer to Vehicle & Equipment Fund 110,000 150,000 175,000 250,000 9990 Community Center 170,000 1 170,000 175,000 190,000 Subsidy for Community Center operating costs 170,000 170,000 175,000 190,000 P w//W%fl4I W-10 i1•//L KI Fund: 100 Department: 4750 Debt Service Account Description 2015 2016 1 2017 1 2018 Description 8011 8021 Lease payable Interest 24,323 18,331 18,887 Lease payable Energy Savings Program - 6,165 5,609 Interest 24,323 24,496 24,496 M. THIS PAGE LEFT BLANK INTENTIONALLY 47 CITY OF MOUNDS VIEW, MINNESOTA Special Revenue Funds 2018 Budgets Combining Statement of Revenues and Expenditures and Net Changes in Fund Balances 48 Cable Community Lakeside Recycling TIF Total TV Forfeiture EDA Center Park Grant District #5 2018 2017 Revenues: Taxes 130,000 100,000 - 1,670,873 1,900,873 1,857,162 Intergovernmental: County grants - - - - 31,455 - 31,455 32,284 Other local govt. - - 23,000 - - 23,000 23,000 Charges for services: Culture and recreation 257,414 - - 257,414 244,662 Miscellaneous: Fines 2,000 - - - - 2,000 5,500 Investment income - 300 300 - 3,000 3,600 4,300 Other - - - 250 - 250 250 Total revenues 130,000 2,000 100,000 257,714 23,550 31,455 1,673,873 2,218,592 2,167,158 Expenditures: Public safety Supplies 1,100 - - 1,100 17,200 Contractual services 500 - - 500 1,500 Capital outlay 5,500 - - 51500 - Sanitation Personal services - - 14,026 14,026 13,800 Supplies - - 500 500 500 Contractual services - 16,929 - 16,929 17,984 Culture and recreation: Personal services 93,152 47,160 4,152 - - 144,464 157,599 Supplies 4,250 19,970 2,457 - 26,677 22,520 Contractual services 49,529 322,910 16,941 - 389,380 368,769 Capital outlay 207,545 - - - - 207,545 10,000 Debt Service - 53,120 - - 53,120 53,120 Economic development Personal services - 108,665 - - - 108,665 105,517 Supplies - - 700 - - - 700 700 Contractual services - - 121,789 - - 1,573,527 1,695,316 1,588,068 Capital outlay - 50,000 - - - - 50,000 50,000 Total expenditures 354,476 7,100 281,154 443,160 23,550 31,455 1,573,527 2,714,422 2,407,277 Surplus of revenues over (under) expenditures (224,476) (5,100) (181,154) (185,446) - - 100,346 (495,830) (240,119) Other financing sources (uses) Transfers in 133,543 190,000 - - 323,543 304,498 Transfers out - - - - (83,543) (83,543) (79,498) Total other financing sources (uses) - 133,543 190,000 - - (83,543) 240,000 225,000 Net change in fund balance (224,476) (5,100) (47,611) 4,554 - - 16,803 (255,830) (15,119) Fund balance, January 1: 335,057 (3,302) 212,845 77,938 8,058 14,211 828,480 1,473,287 2,563,806 Fund balance, December 31 110,581 (8,402) 165,234 82,492 8,058 14,211 845,283 1,217,457 2,548,687 48 2018 Budget Summary Operating expenses 2014 2015 2016 2017 2018 Change from 2017 Actual Actual Actual Budget Request Dollar Percent Cable TV (Fund 210): 33.53% Personnel services 675 200 313 750 Revenues 200 26.67% 0100 Salaries, regular 63,790 65,002 66,948 3180 Franchise fee 126,980 126,182 134,883 126,000 130,000 4,000 3.17% 3680 Other revenue 2,400 2,400 1,200 - - - 0.00% Total revenue 129,380 128,582 136,083 126,000 130,000 4,000 3.17% Operating expenses Operations (4350) 3,942 3,900 5,714 6,000 8,012 2,012 33.53% Personnel services 675 200 313 750 950 200 26.67% 0100 Salaries, regular 63,790 65,002 66,948 68,174 69,769 1,595 2.34% 0300 Social security 4,697 4,813 4,884 5,215 5,338 123 2.36% 0321 PERA 4,599 4,850 4,975 5,113 5,233 120 2.35% 0400 Group insurance 10,570 10,747 11,099 12,096 12,600 504 4.17% 0500 Workers compensation 379 508 399 459 212 (247) -53.81% Total personnel services 84,035 85,920 88,305 91,057 93,152 2,095 2.30% Materials & supplies - - - 10,000 207,545 197,545 1975.45% 1230 Supplies, equipment 1,097 428 - 3,000 3,000 - 0.00% 1600 Supplies, operating 863 - - 1,250 1,250 - 0.00% Total materials & supplies 1,960 428 - 4,250 4,250 - 0.00% Contractual services 3030 Other professional services 3,942 3,900 5,714 6,000 8,012 2,012 33.53% 3630 Training & conferences 675 200 313 750 950 200 26.67% 3800 Mileage & parking 65 8 3 50 50 - 0.00% 3900 Grants & subsidies 28,390 28,560 28,765 29,628 30,517 889 3.00% 5130 Repairs, equipment - - - 10,000 10,000 - 0.00% Total contractual services 33,072 32,668 34,795 46,428 49,529 3,101 6.68% Capital 7030 Equipment - - - 10,000 207,545 197,545 1975.45% Total capital outlays - - - 10,000 207,545 197,545 1975.45% Total expenditures 119,067 119,016 123,100 151,735 354,476 202,741 133.62% Net change in fund balance 10,313 9,566 12,983 (25,735) (224,476) (198,741) 772.26% Fund balance, beginning year 327,930 338,243 347,809 360,792 335,057 (25,735) -7.13% Fund balance, end of year $ 338,243 $ 347,809 $ 360,792 $ 335,057 $ 110,581 $ (224,476) -67.00% 34,795 60,678 261,324 49 Fund: 210 Cable TV Revenues Operations 1230 Supplies, equipment < $5000 3,000 Account Description 2015 2016 2017 2018 Description 3180 Franchise fee revenue 118,000 118,000 122,000 122,000 126,000 130,000 Estimated collections 126,000 130,000 3680 Other revenue 2,400 2,400 2,400 2,400 - - Lease revenue from Library fiber connection Fund: 210 Department: 4350 Operations 1230 Supplies, equipment < $5000 3,000 3,000 3,000 3,000 Equipment costing less than $5,000 per item 3,000 3,000 3,000 3,000 1600 Supplies, operating 1,250 250 1,250 250 1,000 250 400 850 Recording media - tapes, DVD's Batteries, cables, bulbs, tapes, mise 1,500 11500 1,250 1,250 3030 Other professional services 7,200 - 7,200 7,200 - 7,200 6,000 - 6,000 6,012 2,000 8,012 Web streaming meetings $501 per month. (current $1457/qtr) Technical support (due to loss of 100 Ins program) 3630 Training & conferences 300 - 350 - 350 400 350 600 Attendance at local training ACM National Conference (free registration)(1/2 paid by Little Canada) 300 350 750 950 3800 Mileage & parking 50 50 50 50 Mileage 50 50 50 50 3900 Grants & subsidies 29,241 29,826 29,628 30,517 Share ofcosts of North Suburban Cable Commission 29,241 29,826 29,628 30,517 5130 Repairs, equipment 10,000 10,000 10,000 10,000 Repair and maintenance of equipment 10,000 10,000 10,000 10,000 7030 Capital, equipment > $5000 - - 10,000 - - 8,300 8,850 190,000 395 Supplemental duct worklair conditioning Video Camera Video storage (NAS) Control room/Council chambers replacement Bulletin Board 10,000 207,545 51,291 51,926 60,678 261,324 7.12% 1.24% 16.85% 330.67% 50 2018 Budget Summary 2014 2015 2016 2017 2018 Change from 2017 Actual Actual Actual Budget Request Dollar Percent Forfeiture (Fund 225): Revenues 3510 Ramsey Co Municipal Court 1,680 1,080 - - - - #DIV/0! 3514 Forfeitures 26,813 12,668 6,405 5,500 2,000 (3,500) -63.64% Total revenue 28,493 13,748 6,405 5,500 2,000 (3,500) -63.64% Operating expenses (4200): Materials & supplies 1230 Supplies, equipment 8,305 5,209 19,160 16,700 900 (15,800) -94.61% 1600 Supplies, operating 9,220 151 236 500 200 (300) -60.00% Total materials & supplies 17,525 5,360 19,396 17,200 1,100 (16,100) -93.60% Contractual services 3030 Other professional services 2,450 4,920 2,722 1,500 500 (1,000) -66.67% Total contractual services 2,450 4,920 2,722 1,500 500 (1,000) -66.67% Capital 7030 Equipment 12,914 10,240 21,665 - 5,500 5,500 #DIV/0! Total capital outlays 12,914 10,240 21,665 - 5,500 5,500 #DN/0! Total expenses 32,889 20,520 43,783 18,700 7,100 (11,600) -62.03% Net change in fund balance (4,396) (6,772) (37,378) (13,200) (5,100) 8,100 -61.36% Fund balance, beginning year 58,444 54,048 47,276 9,898 (3,302) (13,200) -133.36% Fund balance, end of year 54,048 47,276 9,898 (3,302) (8,402) (5,100) 154.45% 51 Fund: 225 Forfeiture Revenues Account Description 2015 2016 1 2017 2018 Description 3514 Forfeitures 5,500 5,500 5,500 2,000 1 Sale of forfeited vehicles at auction. 5,500 5,500 5,500 2,000 Fund: 225 Department: 4200 Operations 1230 Supplies - equipment < $5000 1,100 1,100 - Taser (4) 1,000 6,000 10,000 Body cameras and storage system - 2,000 - K-9 additional vehicle set-up costs - - - 900 Portable Breath Tester (PBT) 900 900 1,000 - Long rifle - 4,600 4,700 (2) Ballistic shields 1,500 1,500 1,000 Replacement Glock pistols (5) with trade-in 2,900 2,900 - Radar (included with vehicle purchase in equipment fund) 7,400 19,000 16,700 900 1600 Supplies - operating 500 500 500 200 Supplies to prepare vehicles for auction. (tows, title fees, batteries) 500 500 500 200 3030 Other professional services 1,500 1,500 1,500 500 Share ofauction costs. 1,500 1,500 1,500 500 7030 Equipment> $5000 10,000 10,000 - 5,500 (1) In -squad cameras 15,000 15,000 Stationary radar sign for County Rd I (Pinewood school) 25,000 25,000 57500 34,400 46,000 18,700 7,IUU 141.40% 33.72% -59.35% -62.03% 52 2018 Budget Summary Operating expenses Other professional services 2014 2015 2016 2017 2018 Change from 2017 Housing and Economic Development (4650): 3420 Actual Actual Actual Budget Request Dollar Percent EDA (Fund 230): 0.00% 3430 Printing - - - Revenues 0100 Salaries, regular 29,785 7,155 7,459 79,585 81,726 2,141 3101 Tax collections - - - 100,000 100,000 - 0.00% 3610 Investment income 4 - - - - - 0.00% 3615 Interest received on notes 546 515 439 - - - 0.00% 3680 Other revenue 5,547 - - - - - 0.00% 3972 Transfers 85,428 97,140 125,331 129,498 133,543 4,045 3.12% -14.91% Total revenue 91,525 97,655 125,770 229,498 233,543 4,045 1.76% Operating expenses Other professional services 28,844 19,978 9,915 34,240 36,670 2,430 Housing and Economic Development (4650): 3420 Advertisements 898 - - 1,500 1,500 Personnel services 0.00% 3430 Printing - - - 500 0100 Salaries, regular 29,785 7,155 7,459 79,585 81,726 2,141 2.69% 0150 Salaries, part-time 12,614 49,964 53,006 - - - 0.00% 0300 Social security 3,133 4,302 4,511 6,088 6,252 164 2.69% 0321 PERA 3,020 4,272 4,511 5,969 6,130 161 2.70% 0400 Group insurance 4,272 9,705 9,812 13,345 14,106 761 5.70% 0500 Workers compensation 513 626 465 530 451 (79) -14.91% Total personnel services 53,337 76,024 79,764 105,517 108,665 3,148 2.98% Materials & supplies 1600 Supplies, operating - - - 500 500 - 0.00% 2100 Book & periodicals 278 - 139 200 200 - 0.00% Total materials & supplies 278 - 139 700 700 - 0.00% Contractual services 3030 Other professional services 28,844 19,978 9,915 34,240 36,670 2,430 7.10% 3420 Advertisements 898 - - 1,500 1,500 - 0.00% 3430 Printing - - - 500 500 - 0.00% 3610 Memberships 3,501 510 595 710 710 - 0.00% 3630 Training & conferences 1,055 1,354 1,042 3,410 3,410 - 0.00% 3800 Mileage 25 316 265 350 350 - 0.00% 4800 Insurance 3,037 435 427 649 649 - 0.00% 5210 Housing improvement 144 144 559 50,000 50,000 0.00% 5220 Highway 10 redevelopment - - - 27,755 28,000 245 0.88% Total contractual services 37,504 22,737 12,803 69,114 121,789 52,675 76.21% Capital outlays 9300 Business subsidies - - - 50,000 50,000 - 0.00% Total expenditures 91,119 98,761 92,706 225,331 281,154 55,823 24.77% Net change in fund balance 406 (1,106) 33,064 4,167 (47,611) (51,778) -1242.57% Fund balance, beginning year 48,748 49,154 48,048 208,678 212,845 4,167 2.00% Adj for land held for resale 127,566 Fund balance, end of year 49,154 48,048 208,678 212,845 165,234 (47,611) -22.37% 53 Fund: 230 EDA Revenues Account Description 2015 2016 2017 2018 Description 3101 Tax revenue 100,000 100,000 EDA/HRA Levy 100,000 100,000 3972 Transfers 81,820 75,331 79,498 83,543 10,000 50,000 50,000 50,000 Transfers from TIF 5 Transfers from General Fund 91,820 1 125,331 129,498 1 133,543 )9 49N 253.54:1 Fund: 230 Department: 4650 Housing and Economic Development i 1600 Supplies, operating 100 100 500 500 Misc office supplies 100 100 500 500 2100 Books & periodicals 230 230 200 200 Misc. reports & periodicals (Finance & Commerce) 230 230 200 200 3030 Other professional services - 1,580 11,500 - - 4,500 1,610 11,500 - 4,000 5,000 14,500 1,640 2,100 7,000 4,000 5,000 14,500 1,670 4,500 7,000 Legal fees for development reviews Financial consultant fees (Ehlers) Special project consultant fees 5% audit fee (2016-$32,200, 2017-$32,800,2018-$33,400) Loan Program Consultant (TBD) replaces HRC Marketing Consultant fees 13,080 17,610 34,240 36,670 3420 Advertising - - 1,500 1,500 Targeted advertisements. 1,500 1,500 3430 Printing 500 100 500 100 400 100 400 100 Property ad printing Misc printing 600 600 500 500 3610 Memberships 400 250 60 400 250 60 400 250 60 400 250 60 Economic Development Assoc of MN (EDAM) Twin Cities North Chamber of Commerce dues MN Assoc. of Govt. Communicators (MAGC) 710 710 710 710 3630 Training & conferences - - 600 400 535 275 600 581 535 275 600 2,000 535 275 600 2,000 IEDC Conference Minneapolis Ehlers Finance Seminar EDAM summer conference Other miscellaneous training 1,000 1,991 3,410 3,410 3800 Mileage 100 350 350 350 Misc. mileage 4800 Insurance 649 649 649 649 Allocation ofthe Citys property & liability insurance 649 649 649 649 5210 Housing programs - - - 50,000 Housing Improvement programs - 50,000 5220 Highway 10 redevelopment 27,755 28,000 Trailways & lighting in highway corridor, Gateway Signage 27,755 28,000 9300 Business loans/subsidies 50,000 50,000 Business improvement partnership loans/subsidies 50,000 50,000 16,469 22,240 119,814 171,4259 -91.19% 35.04% 438.73% 43.96% 54 THIS PAGE LEFT BLANK INTENTIONALLY 55 Community Center (Fund 252): Building overhead (4350) Building overhead revenues Building overhead expenditure Net Building Overhead Operations Banquet Center (4730): Banquet revenues Banquet Center expenditures Net Banquet Center YMCA (4732): YMCA revenues YMCA expenditures Net YMCA Office/Chamber space (4734): Office/Chamber revenues Office/Chamber expenditures 2018 Budget Summary (4,003) 1,315 2,930 3,656 2014 2015 2016 2017 2018 Change from 2017 Actual Actual Actual Budget Request Dollar Percent 166,478 712,348 170,400 176,000 190,300 (700) -0.40% - 579,183 53,119 53,120 53,120 - 0.00% 41,779 44,618 49,586 54,674 55,097 423 0.77% 166,478 133,165 117,281 122,880 137,180 (700) -0.57% 94,423 88,935 90,750 91,000 92,500 1,500 1.65% 131,664 120,327 127,718 117,914 125,938 8,024 6.81% 4,554 5,720 -35.62% Fund balance, beginning year 126,111 134,804 124,298 (37,241) (31,392) (36,968) (26,914) (33,438) (6,524) 24.24% 70,463 81,812 72,952 57,700 67,200 9,500 16.46% 228,783 240,024 236,080 228,058 225,221 (2,836) -1.24% (158,320) (158,212) (163,128) (170,358) (158,021) 12,336 -7.24% 2,000 7,450 8,500 8,362 8,362 - 0.00% 6,003 6,135 5,570 4,706 4,625 (186) -3.95% Net Office/Chamber space (4,003) 1,315 2,930 3,656 3,737 186 5.08% Creative Kids Child Care Center (4736): Creative Kids revenues 83,135 84,854 85,635 87,600 89,352 1,752 2.00% Creative Kids expenditures 41,356 40,236 36,049 32,926 34,255 1,329 4.04% Net Creative Kids 41,779 44,618 49,586 54,674 55,097 423 0.77% Total revenue 416,499 975,399 428,237 420,662 447,714 12,052 2.87% Total expenditures 407,806 985,905 458,536 436,723 443,160 6,332 1.45% Net change in fund balance 8,693 (10,506) (30,299) (16,061) 4,554 5,720 -35.62% Fund balance, beginning year 126,111 134,804 124,298 93,999 77,938 (16,061) -17.09% Fund balance, end of year 134,804 124,298 93,999 77,938 82,492 4,554 5.84% (continued) IMP 2018 Budget Summary Operating expenses 2014 2015 2016 2017 2018 Change from 2017 Social Security Actual Actual Actual Budget Request Dollar Percent Community Center (continued): Training & conferences Total personnel services Allocation of utilities 5110 Repairs, building & grounds 5130 Repairs, equipment Building overhead (4350) Allocation of repairs 2,342 Total contractual services Capital 7030 Equipment 9,714 Building revenues: Debt service (480) 8011 Lease payable -principal 8021 Lease payable - interest 2,690 3610 Investment income 1,511 378 263 1,000 300 (700) -70.00% 3680 Miscellaneous (33) 6,943 137 - - - 0.00% 3972 Transfers 165,000 170,000 170,000 175,000 190,000 15,000 8.57% 3994 Capital lease proceeds - 535,027 - - - - 0.00% Total building overhead reve 166,478 712,348 170,400 176,000 190,300 (700) -0.40% Operating expenses Personnel services 0100 Salaries, regular 0110 Salaries,overtime 0300 Social Security 0321 PERA 0400 Group insurance 0500 Workers compensation 999 Allocation of salaries Training & conferences Total personnel services Materials & supplies 1210 Supplies, buildings & grounds 1230 Supplies, equipment 1600 Supplies, operating 2400 Uniforms 2410 Mats & towels 2999 Allocation of supplies 3610 Total materials & supplies Contractual services 3030 Other professional services 3100 Telephone 3200 Water & sewer 3210 Electricity 3220 Natural gas 3530 Refuse collection 3610 Memberships 3630 Training & conferences 3999 Allocation of utilities 5110 Repairs, building & grounds 5130 Repairs, equipment 5999 Allocation of repairs 2,342 Total contractual services Capital 7030 Equipment 9,714 Total capital outlays Debt service (480) 8011 Lease payable -principal 8021 Lease payable - interest 2,690 Total debt service Total Building overhead exp Total Building Overhead Net 37,181 40,341 41,258 41,531 30,010 (11,521) -27.74% 2,983 1,659 1,535 1,685 1,217 (468) -27.77% 2,925 3,050 3,083 3,306 2,389 (917) -27.74% 2,860 3,115 3,166 3,241 2,342 (899) -27.74% 9,089 9,599 9,714 10,080 9,600 (480) -4.76% 2,243 3,278 2,357 2,690 1,602 (1,088) -40.45% (57,281) (61,042) (61,113) (62,533) (47,160) 15,373 -24.58% 58 31 _ - - - 0.00% 2,916 1,026 415 1,150 1,150 - 0.00% 588 149 75 800 800 - 0.00% 7,534 8,191 8,120 7,500 7,800 300 4.00% 575 468 590 470 470 - 0.00% 3,053 2,157 2,129 1,250 1,750 500 40.00% (14,666) (11,991) (11,329) (11,170) (11,970) (800) 7.16% 3,299 3,114 4,144 4,024 (120) - 0.00% 343 12,480 13,930 13,750 13,750 - 0.00% 3,026 2,856 2,933 3,200 3,200 - 0.00% 8,720 10,196 8,709 9,000 9,000 - 0.00% 60,276 58,846 48,968 25,000 25,000 - 0.00% 13,977 14,859 14,062 9,000 14,000 5,000 55.56% 2,837 3,299 3,114 4,144 4,024 (120) -2.90% 30 - - - - - 0.00% 58 31 58 - - - 0.00% (89,267) (105,232) (91,774) (64,094) (68,974) (4,880) 7.61% 18,475 16,030 6,779 9,770 9,770 - 0.00% 21,892 14,220 16,153 12,500 16,000 3,500 28.00% (40,367) (27,585) (22,932) (22,270) (25,770) (3,500) 15.72% 0.00% 0.00% 0.00% - 31,205 38,582 39,752 40,957 1,205 3.03% - 12,951 14,537 13,368 12,163 (1,205) -9.01% - 44,156 53,119 53,120 53,120 - 0.00% 579,183 53,119 53,120 53,120 - 0.00% 166,478 133,165 117,281 122,880 137,180 (700) -0.57% (continued) 57 Fund: 252 Department: 4350 Community Center Building Overhead Expenditures Account Description 2015 2016 2017 2018 Description 1210 Supplies, bldgs & grounds 1,150 1,150 1,150 1,150 Lights, signs, fertilizer 1,150 1,150 1,150 1,150 1230 Supplies, equipment < $5000 800 800 800 800 Small tools & equipment 800 800 800 800 1600 Supplies, operating 7,000 7,500 7,500 7,800 Batteries, soap, paper towels, cleaning supplies for bathrooms Paper cups, plates, etc. for lounge & customer service events 7,000 7,500 7,500 7,800 2400 Uniforms 470 470 470 470 Uniforms/Clothing (7.3% of $4,500 +.8 FTE x $175) 470 470 470 470 2410 Mats & towels 1,000 250 1,000 250 1,000 250 1,500 250 Floor mats and cleaning towels to provide better protection of carpets Special events 1,250 11250 1,250 1,750 3030 Other professional services 800 200 9,000 1,750 800 200 11,000 1,750 800 200 11,000 1,750 800 200 11,000 1,750 Backflow inspection, alarm inspection, Sprinkler inspections Custodial services: 12 months $xxx Commercial carpet cleaning service (twice annually) 11,750 13,750 13,750 13,750 3100 Telephone & internet 3,200 3,200 3,200 3,200 Office & customer phones, internet, maintenance agreements, & repairs 3,200 3,200 3,200 3,200 3200 Water & Wastewater 9,000 9,000 9,000 9,000 Water & sewer charges for community center 9,000 9,000 9,000 9,000 3210 Electricity 58,000 25,000 25,000 25,000 Estimated electrice charges 58,000 25,000 25,000 25,000 3220 Natural gas 11,000 9,000 9,000 14,000 Estimated natural gas charges 11,000 9,000 9,000 14,000 3530 Refuse collection 3,280 600 100 3,280 600 100 3,444 600 100 31624 400 - Dumpsters $302 x 12 months Extra garbage pick-up charges Ramsey County recyclying fee 3,980 3,980 4,144 4,024 5110 Repairs, building & grounds - 4,500 770 1,500 1,300 500 - 4,500 770 1,500 1,300 500 1,200 4,500 770 1,500 1,300 500 1,200 4,500 770 1,500 1,300 500 Repair floor tiles Exterior building maintenance Exterminator: 12 months X 64.02 Fire alarm system service Parking lot & grounds maintenance Security system service 8,570 8,570 9,770 9,770 5130 Repairs, equipment 11,000 - 1,500 11,000 1,500 11,000 1,500 11,500 3,000 1,500 HVAC system maintenance contract HVAC repairs Plumbing, electrical, & misc. interior maintenance 12,500 12,500 12,500 16,000 8011 8021 Lease payable (ESP) Interest - 52,988 - 39,752 13,368 40,957 12,163 Lease payable for energy savings program 52,988 53,120 53,120 128,670 149,158 150,654 159,834 7.14% 15.92% 1.00% 6.09% 58 2018 Budget Summary 2014 2015 2016 2017 2018 Chaneefrom 2017 Actual Actual Actual Budget Request Dollar Percent Community Center (continued): Banquet Center (4730): Banquet Revenues 3634 Equipment rental 3,047 5,433 5,563 3,000 4,500 1,500 50.00% 3645 Rental - banquet facility 91,376 83,502 85,187 88,000 88,000 - 0.00% 0.00% Total banquet center revenui 94,423 88,935 90,750 91,000 92,500 1,500 1.65% Banquet Expenditures Personnel services 0999 Allocation of salaries 11,456 12,208 12,223 12,507 9,432 (3,075) -24.58% 64,958 Total personnel services 11,456 12,208 12,223 12,507 9,432 (3,075) -24.58% Materials & supplies 500 500 - 0.00% 3430 Printing - - 1210 Supplies, buildings & grounds 78 1,586 - - - 28,025 0.00% 1230 Supplies, equipment 59 79 2,745 2,500 2,500 1,380 0.00% 1600 Supplies, operating - - - - - - 0.00% 2999 Allocation of supplies 4,105 3,357 3,172 3,128 4,332 1,204 38.50% 0.00% Total materials & supplies 4,242 5,022 5,917 5,628 6,832 1,204 21.39% Contractual services 3030 Other professional services 64,958 63,944 74,815 64,411 76,252 11,841 18.38% 3420 Advertising - - - 500 500 - 0.00% 3430 Printing - - - 250 250 - 0.00% 3999 Allocation of utilities 24,736 28,025 24,347 17,690 19,057 1,366 7.72% 4800 Bonding & insurance 1,387 1,408 1,380 2,100 2,100 - 0.00% 5110 Repairs, building & grounds 11,601 1,615 1,517 6,500 2,700 (3,800) -58.46% 5130 Repairs, equipment 1,997 381 1,098 1,600 1,600 - 0.00% 5999 Allocation of repairs 11,287 7,724 6,421 6,728 7,216 488 7.25% Total contractual services 115,966 103,097 109,578 99,779 109,674 9,895 9.92% 105,407 116,506 Capital 7030 Equipment - - - - - - 0.00% Total capital outlays - - - - - - 0.00% Total banquet center exp 131,664 120,327 127,718 117,914 125,938 8,024 6.81% Total Banquet Center net (37,241) (31,392) (36,968) (26,914) (33,438) (6,524) 24.24% (continued) 59 Fund: 252 Community Center - 4730 Banquet Center Expenditures Account Description 2015 2016 2017 2018 Description 1230 Supplies, equipment 2,500 2,500 2,500 2,500 Tables, mirrors, microphones, projectors, etc. for Banquet Room 2,500 2,500 2,500 2,500 2999 Allocation of supplies 2,988 3,128 3,128 4,332 28% Allocation from overall building support 2,988 3,128 3,128 4,332 3030 Other professional services 790 2,000 54,551 1,250 3,600 500 790 2,000 55,139 1,250 3,600 500 820 2,000 56,241 1,250 3,600 500 835 2,500 58,667 1,750 12,000 500 2.5% of audit (17 - $32,800, 18 - $33,400) Miscellaneous professional services (linen service) Banquet facility management (21% of 279,364) Carpet cleaning 2 x year Extra staff for large events Legal costs 62,691 63,279 64,411 76,252 3420 Advertising & marketing 500 500 500 500 Website and traditional advertising, marketing 500 500 500 500 3430 Printing 250 250 250 250 Brochures, flyers, etc. 250 250 250 250 3999 Allocation of utilities 26,884 17,644 17,690 19,057 28% Allocation from overall building utilities 11 26,884 17,644 17,690 19,057 4800 Bonding & insurance 2,100 2,100 2,100 2,100 Insurance & bonding cost 2,100 2,100 2,100 2,100 5110 Repairs, building & grounds 1,200 1,500 1,200 1,500 5,000 1,500 1,200 1,500 Interior building repairs specific to the banquette center/center divider repairs Dance floor maintenance 2,700 2,700 6,500 2,700 5130 Repairs, equipment 1,600 1,600 1,600 1,600 Repairs to kitchen, audio system, and other banquette equipment 1,600 1,600 1,600 1,600 5999 Allocation of repairs 6,728 6,728 6,728 7,216 28% Allocation from overall building repairs 6,728 6,728 6,728 7,216 108,941 100,429 105,407 116,507 4.93% -7.81% 4.96% 10.53% 60 2018 Budget Summary Total YMCA revenues 70,463 81,812 72,952 57,700 67,200 9,500 16.46% YMCA Expenditures Personnel services 0999 2014 2015 2016 2017 2018 Change from 2017 (10,607) Actual Actual Actual Budget Request Dollar Percent Community Center (continued): (10,607) -24.58% Materials & supplies YMCA (4732): 1230 Supplies, equipment - - YMCA Revenues 2,000 2,000 - 0.00% 2999 Allocation of supplies 7,331 3405 Recreation profit 30,157 33,194 19,388 20,000 20,000 - 0.00% 3660 Gym & meeting room rental 19,683 26,607 30,113 20,000 27,000 7,000 35.00% 3661 Open gym participant fees 19,856 20,135 21,840 17,000 19,000 2,000 11.76% 3679 Commissions -vending 767 1,876 1,611 700 1,200 500 71.43% Total YMCA revenues 70,463 81,812 72,952 57,700 67,200 9,500 16.46% YMCA Expenditures Personnel services 0999 Allocation of salaries 39,524 42,119 42,168 43,148 32,540 (10,607) -24.58% Total personnel services 39,524 42,119 42,168 43,148 32,540 (10,607) -24.58% Materials & supplies 1230 Supplies, equipment - - 2,474 2,000 2,000 - 0.00% 2999 Allocation of supplies 7,331 5,996 5,665 5,585 7,735 2,150 38.50% Total materials & supplies 7,331 5,996 8,139 7,585 9,735 2,150 28.35% Contractual services 3030 Other professional services 100,808 106,225 107,786 111,182 115,789 4,607 4.14% 3300 Postage - - - 600 - (600) -100.00% 3430 Printing 6,042 6,298 7,056 6,600 7,200 600 9.09% 3999 Allocation of utilities 45,475 56,186 49,254 32,925 35,447 2,522 7.66% 4010 Rental, equipment - 184 - 250 250 - 0.00% 4800 Bonding & insurance 2,657 2,699 2,644 4,025 4,025 - 0.00% 5110 Repairs, building & grounds 4,512 5,391 7,271 7,000 6,000 (1,000) -14.29% 5130 Repairs, equipment 2,278 1,134 296 1,350 1,350 - 0.00% 5999 Allocation of repairs 20,156 13,792 11,466 13,393 12,885 (508) -3.79% Total contractual services 181,928 191,909 185,773 177,325 182,946 5,621 3.17% 184,910 192,681 Total YMCA exp 228,783 240,024 236,080 228,058 225,221 (2,836) -1.24% Total YMCA net (158,320) (158,212) (163,128) (170,358) (158,021) 12,336 -7.24% (continued) 61 Fund: 252 Community Center - 4732 YMCA Expenditures Account Description 2015 1 2016 2017 2018 Description 1230 Supplies, equipment 500 500 2,000 21000 Miscellaneous (Basketball portable hoop pads 2017) 500 500 2,000 2,000 2999 Allocation of supplies 5,655 5,585 5,585 7,735 50% Allocation from overall building support 5,655 5,585 5,585 7,735 3030 Other professional services 102,200 - 2,370 103,713 2,935 21370 105,787 2,935 2,460 110,349 2,935 2,505 YMCA mgt. contract (other half of fee in recreation)(39.5% of $279,364) Copier ($2,100) Computer ($835) per agreement 7.5% of audit (17 - $32,800, 18 - $33,400) 104,570 109,018 111,182 115,789 3300 Postage 600 600 600 50% of the cost of mailing the Mounds View Matters newsletter 600 600 600 3430 Printing 6,600 6,600 6,600 7,200 50% of the cost of printing and mailing the Mounds View Matters newsletter 6,600 6,600 6,600 7,200 3999 Allocation of utilities 52,237 32,925 32,925 35,447 50% Allocation from overall building utilities 52,237 32,925 32,925 35,447 4010 Rental, equipment 250 250 250 250 Scissor lift rental 250 250 250 250 4800 Bonding & insurance 4,025 4,025 4,025 4,025 Insurance & bonding cost. 4,025 4,025 4,025 4,025 5110 Repairs, building & grounds 3,000 2,000 2,000 3,000 2,000 2,000 3,000 2,000 2,000 1,500 1,000 3,500 General building repairs Interior improvements Gym floor resurfacing & maintenance 7,000 7,000 7,000 6,000 5130 Repairs, equipment 500 850 - 500 850 - 500 850 - 500 850 Copier maintenance contract Registration system support Repairs to other equipment 1,350 1,350 1,350 1,350 5999 1 Allocation of repairs 1 13,393 1 13,393 13,393 12,885 50% Allocation from overall building repairs 13,393 13,393 13,393 12,885 196,180 181,246 184,910 192,681 6.41% -7.61% 2.02% 4.20% W THIS PAGE LEFT BLANK INTENTIONALLY 63 2018 Budget Summary 2014 2015 2016 2017 2018 Change from 2017 Actual Actual Actual Budget Request Dollar Percent Office space (4734); Office space revenues 3633 Lease - Office/Chamber space 2,000 7,450 8,500 8,362 8,362 - 0.00% Total office space revenues 2,000 7,450 8,500 8,362 8,362 - 0.00% Office space expenditures Personnel services 3999 Allocation of utilities 2,635 3,116 2,709 1,827 1,973 0999 Allocation of salaries 1,719 1,831 1,833 1,876 1,415 (461) -24.58% Total personnel services 1,719 1,831 1,833 1,876 1,415 (461) -24.58% Materials & supplies 2,746 146 5.86% 1,400 - 0.00% 2999 Allocation of supplies 440 360 340 335 464 129 38.54% Total materials & supplies 440 360 340 335 464 129 38.54% Contractual services 3999 Allocation of utilities 2,635 3,116 2,709 1,827 1,973 146 8.00% 5999 Allocation of repairs 1,209 828 688 668 773 105 15.73% Total contractual services 3,844 3,944 3,397 2,495 2,746 146 5.86% 1,400 - 0.00% 5999 Allocation of repairs 7,659 5,241 0 Total office space exp 6,003 6,135 5,570 4,706 4,625 (186) -3.95% Total office space net (4,003) 1,315 2,930 3,656 3,737 186 5.08% (continued) 2018 Budget Summary 2014 2015 2016 2017 2018 Change from 2017 Actual Actual Actual Budget Request Dollar Percent Creative Kids Child Care (4736): Child Care Revenues 3632 Lease - Child Care 83,135 84,854 85,635 87,600 89,352 1,752 2.00% Total child care revenues 83,135 84,854 85,635 87,600 89,352 1,752 2.00% Child Care Ed Expenditures (19%) Personnel services 0999 Allocation of salaries 4,582 4,883 4,889 5,003 3,773 (1,230) -24.59% Total personnel services 4,582 4,883 4,889 5,003 3,773 (1,230) -24.59% Materials & supplies 1600 Supplies, operating - 344 - - - - 0.00% 2999 Allocation of supplies 2,785 2,278 2,152 2,122 2,939 817 38.52% Total materials & supplies 2,785 2,622 2,152 2,122 2,939 817 38.52% Contractual services 3999 Allocation of utilities 16,475 17,905 15,463 11,570 12,497 927 8.01% 4750 Taxes, licenses, & fees 8,930 8,646 8,268 8,600 8,750 150 1.74% 4800 Bonding & insurance 925 939 920 1,400 1,400 - 0.00% 5999 Allocation of repairs 7,659 5,241 4,357 4,231 4,896 665 15.72% Total contractual services 33,989 32,731 29,008 25,801 27,543 1,742 6.75% Total child care exp 41,356 40,236 36,049 32,926 34,255 1,329 4.04% Total child care net 41,779 44,618 49,586 54,674 55,097 423 0.77% 64 2018 Budget Summary Operating expenses (4350): Supplies, bldgs & grounds 2014 2015 2016 2017 2018 Change from 2017 Personnel services Supplies, operating Actual Actual Actual Budget Request Dollar Percent Lakeside Park (Fund 255): 3,528 2,079 2,805 3,520 3,680 160 Revenues 0300 Social security 270 159 214 269 282 13 3370 Spring Lake Pk contribution 10,608 11,500 11,500 11,500 11,500 - 0.00% 3370 Mounds View contribution 10,608 11,500 11,500 11,500 11,500 - 0.00% 3610 Investment income 729 132 142 300 300 - 0.00% 3665 Park site permit 678 921 789 250 250 - 0.00% 4030 Total revenue 22,623 24,053 23,931 23,550 23,550 - 0.00% Operating expenses (4350): Supplies, bldgs & grounds 237 - 1,612 1,100 1,100 - 0.00% Personnel services Supplies, operating 957 928 644 1,500 1,357 (143) -9.53% 0150 Salaries, part-time 3,528 2,079 2,805 3,520 3,680 160 4.55% 0300 Social security 270 159 214 269 282 13 4.83% 0500 Workers compensation 146 202 189 220 190 (30) -13.64% Total personnel services 3,944 2,440 3,208 4,009 4,152 143 3.57% Materials & supplies 1210 Supplies, bldgs & grounds 237 - 1,612 1,100 1,100 - 0.00% 1600 Supplies, operating 957 928 644 1,500 1,357 (143) -9.53% Total materials & supplies 1,194 928 2,256 2,600 2,457 (143) -5.50% Contractual services 3200 Water & sewer 1,869 2,090 2,812 1,800 1,800 - 0.00% 3210 Electricity 1,625 1,262 1,106 1,400 1,400 - 0.00% 3530 Refuse collection - - - 75 75 - 0.00% 4010 Equipment Contribution SLP 4,372 4,986 4,986 4,600 4,600 - 0.00% 4030 Satellites 875 1,487 819 650 650 - 0.00% 4800 Insurance 4,738 4,608 4,488 4,800 4,800 - 0.00% 5130 Repairs, equipment - 2,795 - 3,616 3,616 - 0.00% Total contractual services 13,479 17,228 14,211 16,941 16,941 - 0.00% Total expenses 18,617 20,596 19,675 23,550 23,550 - 0.00% Net change in fund balance 4,006 3,457 4,256 - - - 0.00% Fund balance, beginning year (3,661) 345 3,802 8,058 8,058 - 0.00% Fund balance, end of year 345 3,802 8,058 8,058 8,058 - 0.00% 65 Fund: 255 Lakeside Park Revenues Account Description 2015 2016 2017 2018 Description 3370 Contributions 11,500 11,500 11,500 11,500 Spring Lake Park contribution for half of cost for joint park 11,500 11,500 11,500 11,500 3370 Contributions 11,500 11,500 11,500 11,500 Mounds View contribution for half of cost for joint park 11,500 11,500 11,500 11,500 3610 Interest revenue 300 300 300 300 Estimated interest earnings at 1.25%. 300 300 300 300 3680 Park sit rental 250 250 250 250 Rental of the park by groups or individuals 250 250 250 250 Fund: 255 Department: 4350 + Expenditures 1210 Supplies, bldgs & grounds 1,200 1,200 1,100 1,100 Paper, sand, etc. 1,200 1,200 1,100 1,100 1600 Supplies, operating 1,800 1,800 1,500 1,357 Fertilizer & pesticides 1,800 1,800 1,500 1,357 3200 Water & sewer 1,600 1,600 1,800 1,800 Estimated water & sewer charges 1,600 1,600 1,800 1,800 3210 Electricity 1,600 1,600 1,400 1 1,400 Estimated electric charges 1,600 1,600 1,400 1,400 3530 Refuse collection 75 75 75 75 Six months service 75 75 75 75 4010 Equipment, capital charge 4,600 4,600 4,600 4,600 Capital charge for usage of SLP city equipment 4,600 4,600 4,600 4,600 4030 Satellites 500 500 650 650 Five months service 500 500 650 650 4800 Insurance & bonds 4,800 4,800 4,800 4,800 Property & liability insumace 4,800 4,800 4,800 4,800 5130 Repairs, equipment 3,592 3,592 3,616 3,616 Repair of equipment at the park 3,592 3,592 3,616 3,616 19,767 19,767 19,541 19,398 9.60% 0.00% -1.14% -0.73% 66 Recycling (Fund 290): Revenues 3360 Other County grants 3610 Investment income Total revenue Operating expenses Operations (4420) Personnel services 0100 Salaries, regular 0110 Salaries, overtime 0300 Social security 0321 PERA 0400 Group insurance 0500 Workers compensation Total personnel services Materials & supplies 1600 Supplies, operating 2018 Budget Summary 2014 2015 2016 2017 2018 Change from 2017 Actual Actual Actual Budget Request Dollar Percent 25,211 31,877 20,202 32,284 31,455 (829) -2.57% 321 51 3 - - - 0.00% 25,532 31,928 20,205 32,284 31,455 (829) -2.57% 8,939 10,036 8,997 10,436 10,583 147 1.41% 286 281 350 - - - 0.00% 612 772 636 798 810 12 1.50% 666 734 600 783 794 11 1.40% 2,480 524 431 1,693 1,764 71 4.19% 71 101 79 90 75 (15) -16.67% 13,054 12,448 11,093 13,800 14,026 226 1.64% 500 500 - 0.00% Contractual services 3300 Postage 6,722 5,069 5,154 5,000 2,200 (2,800) -56.00% 3420 Advertisements - - 1,208 - - - 0.00% 3430 Printing 1,936 2,912 655 1,500 2,500 1,000 66.67% 3530 Refuse collection 4,321 4,439 9,453 11,484 12,229 745 6.49% Total contractual services 12,979 12,420 16,470 17,984 16,929 (1,055) -5.87% Total expenses 26,033 24,868 27,563 32,284 31,455 (829) -2.57% Net change in fund balance (501) 7,060 (7,358) - - - 0.00% Fund balance, beginning year 15,010 14,509 21,569 14,211 14,211 - 0.00% Fund balance, end of year 14,509 21,569 14,211 14,211 14,211 - 0.00% 18,484 17,429 67 Fund: 290 Recycling Grant Revenues Account Description 2015 2016 2017 2018 Description 3360 Other grants & aid 31,877 30,220 32,284 31,455 Estimated Ramsey County recycling grant 31,877 30,220 32,284 31,455 Fund: 290 Department: 4420 Expenditures 1600 Supplies, operatin 3,000 11000 500 500 3,000 11000 500 500 3300 Postage 5,500 5,000 5,000 2,200 City wide mailing for Cleanup Day, Newsletter, organics 5,500 5,000 5,000 2,200 3430 Printing 1,000 500 500 500 1,000 500 1,000 2,000 Articles in City newsletter Clean-up Day and Organics printing of direct mailing items 2,000 1,000 1,500 2,500 3530 1 Refuse collection 1 8,789 9,751 11,484 12,229 1 Recycling collections CH, CC, Festival, and Parks, Spring Clean-up Day 8_,_78_9T_9,751 11,484 12,229 19,2259 to, /�.1 115,464 1 /,4LY 55.85% -13.16% 10.35% -5.71% 68 2018 Budget Summary Operating expenses (4650): 2014 2015 2016 2017 2018 Change from 2017 Contractual services Actual Actual Actual Budget Request Dollar Percent TIF # 5 (Fund 450): 1,178 2,924 5,095 5,060 5,060 0.00% Revenues 196,416 231,283 309,984 - - 0.00% 3101 Tax collections 1,415,212 1,441,945 1,555,581 1,631,162 1,670,873 39,711 2.43% 3610 Investment income 13,433 2,738 2,335 3,000 3,000 - 0.00% Total revenue 11428,645 1,444,683 1,557,916 1,634,162 1,673,873 39,711 2.43% Operating expenses (4650): Contractual services 3030 Other professional 1,178 2,924 5,095 5,060 5,060 0.00% 8010 Developer PAG, principal 196,416 231,283 309,984 - - 0.00% 8020 Developer PAG, interest 1,136,109 1,125,867 1,113,841 1,513,894 1,568,467 54,573 3.60% 9900 Transfers out to EDA 70,760 72,863 75,331 79,498 83,543 4,045 5.09% Total contractual services 1,404,463 1,432,937 1,504,251 1,598,452 1,657,070 58,618 3.67% Net change in fund balance 24,182 11,746 53,665 35,710 16,803 (18,907) -52.95% Fund balance, beginning year 703,177 727,359 739,105 792,770 828,480 35,710 4.50% Fund balance, end of year 727,359 739,105 792,770 828,480 845,283 16,803 2.03% 69 Fund: 450 TIF District#5 Revenues Account Description 2015 2016 2017 2018 Description 3101 Tar increment collections 1,457,260 1,555,982 1,631,162 1,670,873 Estimated collections of incremental tares on properties in the district 1,457,260 1,555,982 1,631,162 1,670,873 3610 Investment income 4,000 4,000 3,000 3,000 Estimated interest earnings at 1.00%. 4,000 4,000 3,000 3,000 Fund: 430 Department: 4650 Economic Development 3030 Other professional services 2,420 31420 3,420 3,420 1,580 1,580 1,640 1,640 TIF administration and reporting fees 5% audit fee (moved from EDA)(2017 - $32,800, 2018 - $33,400) 4,000 5,000 5,060 5,060 8010 Pay-as-you-go principal 1,364,425 1,431,290 1,513,894 1,568,467 Principal on a revenue note issued to promote a development. (Medtronic) 1,364,425 1,431,290 1,513,894 1,568,467 9900 Transfer out to EDA Fund 72,863 75,331 79,498 83,543 Transfer to cover the EDA operating budget. 72,863 75,331 79,498 83,543 70 2018 Budget Summary Operating expenses (4650): 2017 Y -T -D 2018 Change from 2017 Contractual services Budget 09/30/17 Reclues Dollar Percent GO Capital Imp. Plan Bonds of 2017A Debt Service (Fund 506): - 0.00% Revenues - 211,419 211,419 0.00% 8030 Paying agent - 3101 Property taxes - - 415,034 415,034 0.00% 3102 Delinquent taxes - - - - 0.00% 3121 Fiscal disparities - - - - 0.00% 3610 Investment income - - 200 200 0.00% 3680 Misc revenue - - - - 0.00% 3972 Transfers - - 126,284 126,284 0.00% 3993 Bond proceeds - - - - 0.00% Total revenue - - 541,518 541,518 0.00% Operating expenses (4650): Contractual services 8010 Debt, principal - - - - 0.00% 8020 Debt, interest - - 211,419 211,419 0.00% 8030 Paying agent - - 475 475 0.00% 8040 Continuing disclosure - - 1,000 1,000 0.00% Total contractual services - - 212,894 212,894 0.00% Net change in fund balance - - 328,624 328,624 0.00% Fund balance, beginning year - - - - 0.00% Fund balance, end of year - - 328,624 328,624 0.00% 71 CITY OF MOUNDS VIEW, MINNESOTA Capital Project Funds 2018 Budgets Combining Statement of Revenues and Expenditures 72 Park Vehicle and Special Street Total Budget Dedication Equipment Projects Improvement 2018 2017 Revenue: Taxes $ - $ - $ - $ - $ - $ 300,000 Franchise fees - - - 290,000 290,000 280,000 Special assessments - - - 20,000 20,000 20,000 Intergovernmental: State - - - 275,000 275,000 275,000 County - - - - - 39,300 Miscellaneous: Investment income 2,000 - 2,000 15,000 19,000 56,000 Other 3,000 - - - 3,000 3,000 Total revenue 5,000 - 2,000 600,000 607,000 973,300 Expenditures: General government - - 40,000 - 40,000 31,000 Public safety - 84,600 - - 84,600 77,300 Streets and highways - - 1,092,000 1,450,000 2,542,000 10,288,027 Culture and recreation 320,000 - - - 320,000 123,850 Total expenditures 320,000 84,600 1,132,000 1,450,000 2,986,600 10,520,177 Excess (deficiency) of revenue over expenditures (315,000) (84,600) (1,130,000) (850,000) (2,379,600) (9,546,877) Other financing sources (uses) Operating transfers Bonds issued - - - - - 7,500,000 Transfers in - 396,000 75,000 - 471,000 384,000 Transfers out - (22,000) (126,284) - (148,284) (56,600) Total other financing sources (uses) - 374,000 (51,284) - 322,716 7,827,400 Net change in fund balance (315,000) 289,400 (1,181,284) (850,000) (2,056,884) (1,719,477) Fund balance, January 1 292,257 1,358,486 1,363,512 1,127,785 4,142,040 5,643,337 Fund balance, December 31 $ (22,743) $ 1,647,886 $ 182,228 $ 277,785 $ 2,085,156 $ 3,923,860 72 2018 Budget Summary 2014 2015 2016 2017 2018 Change from 2017 Actual Actual Actual Budget Request Dollar Percent Park Dedication (Fund 451): 25,562 67,380 Revenues 2,235 - 23,307 - - 0.00% 3610 Investment income 17,648 5,037 4,334 2,000 2,000 - 0.00% 3650 Park donations 8,900 15,085 - - - - 0.00% 3652 Park dedication fees 213,529 - 1,082 3,000 3,000 - 0.00% Total revenue 240,077 20,122 5,416 5,000 5,000 - 0.00% Operating expenses Operations (4350): Materials & supplies 1230 Supplies, equip. < $5,000 15,367 - - - - 0.00% 1600 Supplies, operating - - 3,973 - - 0.00% Total materials & supplies 15,367 - 3,973 - - 0.00% Contractual services 25,562 67,380 3030 Other professional services 2,235 - 23,307 - - 0.00% 5110 Repairs, Buildings & Grounds - - 23,707 - - 0.00% Total contractual services 2,235 - 47,014 - - - 0.00% (315,000) (205,150) 186.75% Capital 280,421 494,936 7050 Construction 7,960 67,380 - 114,850 320,000 205,150 178.62% Total capital outlays 7,960 67,380 - 114,850 320,000 205,150 178.62% Total expenses 25,562 67,380 50,987 114,850 320,000 205,150 178.62% Net change in fund balance 214,515 (47,258) (45,571) (109,850) (315,000) (205,150) 186.75% Fund balance; beginning year 280,421 494,936 447,678 402,107 292,257 (109,850) -27.32% Fund balance, end of year $ 494,936 $ 447,678 $ 402,107 $ 292,257 $ (22,743) $ (315,000) -107.78% 73 Fund: 451 ParkDedication Fund Revenues Account Description 2015 2016 2017 2018 Description 3610 Investment income 2,000 2,000 2,000 2,000 Estimated interest earnings at 1%. 2,000 2,000 2,000 2,000 3652 Park dedication fees 6,000 6,000 3,000 3,000 Developer payments 6,000 6,000 1 3,000 3,000 Fund: 451 Department: 4470 Expenditures 7050 Construction > $25000 20,000 Random Park Building interior remodeling 25,000 Roofing shelters 100,000 - 70,000 City Hall Park redesign ? 220,000 50,000 - Groveland Park Improvements 25,000 - 25,000 Disk golf course improvements at Silverview Park - 15,000 Irrigation improvements Silverview Park 2,500 - Bike racks, Benches, Trash containers, Picknick tables, etc (BBC donations) - 60,000 250,000 Greenfield basketball and tennis courts - resurface - 14,850 - Hillview hockey rink 347,500 95,000 114,850 320,000 74 2018 Budget Summary Expenditures 0.00% 2014 2015 2016 2017 2018 Change from 2017 7040 Vehicles 96,622 - 15,519 159,000 - - 0.00% Actual Actual Actual Budget Request Dollar Percent Vehicle & Equipment (Fund 460): 1230 Supplies, equip < $5,000 2,897 - 2,402 35,000 - - 0.00% 3030 Other professional services Revenues - 2,535 - - - 0.00% 5120 Repairs, vehicles 4,542 - - 3972 Transfers in - General fund 100,000 110,000 150,000 175,000 250,000 75,000 42.86% 3972 Transfers in - Water 60,000 - - 64,000 66,000 2,000 3.13% 3972 Transfers in - Sewer 36,000 53,000 42,000 38,000 48,000 10,000 26.32% 3972 Transfers in - Storm Water 16,000 71,000 32,000 32,000 32,000 - 0.00% -2343.41% Total revenue 212,000 234,000 224,000 309,000 396,000 87,000 28.16% Expenditures 0.00% 1230 Supplies, equip < $5,000 4,215 - - - - - 0.00% Capital Police (4200): - 0.00% 7040 Vehicles 96,622 - 15,519 159,000 - - 0.00% Total PW Streets 100,837 - 15,519 179,000 - - 0.00% Materials & supplies 21,600 22,000 400 1.85% 0.00% 1230 Supplies, equip < $5,000 2,897 - 2,402 35,000 - - 0.00% 3030 Other professional services 941 - 2,535 - - - 0.00% 5120 Repairs, vehicles 4,542 - - - - - 0.00% Capital - 210,000 - 7030 Equipment - - - - - - 0.00% 7040 Vehicles 45,952 57,947 79,444 77,300 84,600 84,600 109.44% Total Police 54,332 57,947 84,381 77,300 84,600 84,600 109.44% Park and rec (4360): 48.31% Net change in fund balance (263,405) (148,596) Capital (12,900) 289,400 302,300 -2343.41% 7030 Equipment 183,224 93,649 10,931 9,000 - - 0.00% 7040 Vehicles 26,696 - - - - - 0.00% Total Park and rec 209,920 93,649 10,931 9,000 - - 0.00% PW Streets (4470): Materials & supplies 0.00% 1230 Supplies, equip < $5,000 4,215 - - - - - 0.00% Capital 7030 Equipment - - - 20,000 - - 0.00% 7040 Vehicles 96,622 - 15,519 159,000 - - 0.00% Total PW Streets 100,837 - 15,519 179,000 - - 0.00% Other (4160): 9900 Transfer out - General Fund 38,316 21,000 22,000 21,600 22,000 400 1.85% 9900 Transfer out - Water 72,000 - - 35,000 - (35,000) -100.00% 9900 Transfer out - Sewer - - 60,000 - - 0.00% 9900 Transfer out - Storm Water - 210,000 - 0.00% Total other 110,316 231,000 82,000 56,600 22,000 (34,600) -61.13% Total expenditures 475,405 382,596 192,831 321,900 106,600 50,000 48.31% Net change in fund balance (263,405) (148,596) 31,169 (12,900) 289,400 302,300 -2343.41% Fund balance, beginning year 1,752,218 1,488,813 1,340,217 1,371,386 1,358,486 (12,900) -0.94% Fund balance, end of year 1,488,813 1,340,217 1,371,386 1,358,486 1,647,886 289,400 21.30% 75 Fund: 460 Vehicle & EquipmentFund Revenues Account Description 2015 2016 2017 2018 Description 3961 Transfers in 110,000 58,000 53,000 71,000 150,000 175,000 250,000 64,000 64,000 66,000 42,000 38,000 48,000 32,000 32,000 32,000 From General Fund ($267,000 5yr Fin Plan) From Water Fund From Sanitary Sewer Fund From Storm Water Fund 292,000 1 288,000 309,000 396,000 Fund: 460 Department: 4200 Police Operations 7030 Equipment> $5000 10,000 Radar trailer 10,000 - 7040 Vehicles 65,000 74,000 77,300 84,600 (2)Sdan S27,500,(2)scrap S4,000,(2) ,di, S3,8W,(2)cm ras S5,500,(1) d,, 53,000 65,000 74,000 77,300 84,600 Fund: 460 Department: 4360 Parks Operations 7030 Equipment > $5000 - 8,000 9,000 - - 10,000 - 115,000 - - Utility cart Engine for parks mower Parks mower ($13,500 Walker MTGHS mower move to 2017) 115,000 18,000 9,000 7040 Vehicles - - - Parks - 3/4 ton pick-up Fund: 460 Department: 4470 Pavement Management Operations 7030 Equipment> $5000 20,000 Compactor 20,000 7040 Vehicles 34,000 125,000 Street maint 1/2 ton pick-up Dump truck ($160,000 net of trade-in $35,000) 159,000 9900 Transfers out 21,000 - 210,000 - 22,000 21,600 22,000 83,000 - - - - - 35,000 Various equipment purchases general fund Sewer - Generator lift station (natural gas) Storm Water - street sweeper (net of $40,000-$50,000 trade-in) Water - (1/2 ton truck 4x4 ($35,000) 231,000 105,000 56,600 22,000 iro 2018 Budget Summary 2014 2015 2016 2017 2018 Change from 2017 Actual Actual Actual Budget Request Dollar Percent Special Projects (Fund 480): Revenues 3553 Spec assessmt penalty & inter( - - 256 - - - 0.00% 3610 Investment income 33,985 12,483 11,171 4,000 2,000 (2,000) -50.00% 3680 Other revenue 4,000 - - - - - 0.00% 3972 Transfers in 912,000 200,000 375,000 75,000 75,000 - 0.00% 3993 Bond sales - - - 7,500,000 - (7,500,000) -100.00% Total revenue 949,985 212,483 386,427 7,579,000 77,000 (7,502,000) -98.98% Operating expenses Operations (4160): Materials & supplies 1230 Supplies, equipment < $5,000 11,881 - - - - 0.00% 1600 Supplies, operating 828 - - - - 0.00% Total materials & supplies 12,709 - - - - 0.00% Contractual services 3030 Other professional services 190 - - 0.00% 5130 Repairs; Equipment 3,189 - 3,679 - 0.00% Total contractual services 3,379 - 3,679 - - 0.00% Capital (4160) 7030 Capital equipment - - - - - 0.00% 7050 Construction - - 198,413 - - - 0.00% Total capital outlays - - 198,413 - - - 0.00% Operations (4180): Contractual services 3030 Other professional services 5,969 4,763 4,624 31,000 40,000 9,000 29.03% 5130 Repairs; Equipment 12,359 1,833 - - - - 0.00% Total contractual services 18,328 6,596 4,624 31,000 40,000 9,000 29.03% Capital (4180) 7030 Capital equipment 101,297 - 44,462 160,000 66,000 (94,000) -58.75% 7050 Construction 198,075 79,600 407,896 287,027 726,000 438,973 152.94% Total capital outlays 299,372 79,600 452,358 447,027 792,000 344,973 77.17% Capital (4470) 7050 Construction - - - 7,000,000 300,000 (6,700,000) -95.71% Total capital outlays - - - 7,000,000 300,000 (6,700,000) -95.71% Other 9900 Transfer out - - - - 126,284 126,284 0.00% Total other - - - - 126,284 126,284 0.00% Total expenses 317,700 86,196 456,982 7,478,027 1,258,284 (6,219,743) 10.49% Net change in fund balance 632,285 126,287 (70,555) 100,973 (1,181,284) (1,282,257) -1269.90% Fund balance, beginning year 574,522 1,206,807 1,333,094 1,262,539 1,363,512 100,973 8.00% Fund balance, end of year 1,206,807 1,333,094 1,262,539 1,363,512 182,228 (1,181,284) -86.64% 77 Fund: 480 Special Projects Department: 4180 Expenditures 3030 Revenues Account Description 2015 2016 2017 2018 Description 3610 Investment income 2,000 6,000 4,000 2,000 Estimated interest earnings at I%. 2,000 6,000 4,000 2,000 3972 Transfers in 50,122 75,000 75,000 75,000 Transfer from General Fund 50,122 75,000 75,000 75,000 3993 Bond proceeds - - 7,500,000 G.O. Bonds for PW facility - 7,500,000 4,500 Fund: 480 Department: 4180 Expenditures 3030 Other professional services - 20,000 Community Center upgrades (4 more cameras, dividers, bleechers, curtain reps 16,000 10,000 Siren upgrades (2 sirens)(Bronson, Mustang Circle) 15,000 - Security fence for PD parking lot 10,000 Roof management survey 4,500 - Interior painting Police Department 4,500 31,000 40,000 7030 Capital, equipment> $5000 - - - Purchase copiers (3) Main copier, police, comm dev/finance (replace 2019) 10,000 10,000 10,000 Park building video and door lock improvements 30,000 - - Video and Security improvements for CH and CC (BBC grant of $2,000) 8,250 - Road sensors 3 locations 11,450 18,000 Automatic Transfer switch (City Hall generator) 3,150 - Upgrade CH electrical panel - 38,000 Audio Visual upgrades for Banquet Center 100,000 City monument sign County H round -about gateway 50,000 - Website 62,850 160,000 66,000 7050 Construction> $25000 - 40,000 - - Comm. Center relocate entrance sign (carryover from 2007) 200,000 200,000 7,000,000 300,000 PW Building Project (design phase)(construction in 2017) 150,000 375,000 - - Pathway rehabilitation program (Silver View Park) - 200,000 250,000 483,000 Splash Pad - - - 218,000 City Hall Park redesign 25,000 37,027 - CC HVAC Improvements (RTU -4,7 and VAV's) 30,000 - - Remodel prep kitchen 25,000 CommCtr restrooms in gym locker rooms - 40,000 - Remodel /Expand exercise area ($40,000 to 2016) 8,000 Remodel Comm Ctr Admin offices 413,000 855,000 7,287,027 1,026,000 9900 Transfer to Debt Service Fund - 126,284 February Interest Payment on PW CIP Bonds 126,284 78 2018 Budget Summary 2014 2015 2016 2017 2018 Change from 2017 Actual Actual Actual Request Request Dollar Percent Street Improvement (Fund 485): Revenues 3101 Property taxes 302,356 302,050 211,317 300,000 - (300,000) -100.00% 3180 Franchise fee 336,711 309,039 296,173 280,000 290,000 10,000 3.57% 3352 MSA street construction 327,190 323,342 364,924 275,000 275,000 - 0.00% 3360 Other county grant - - - 39,300 - (39,300) -100.00% 3370 Other local government revem - - 126,323 - - 0.00% 3550 Spec assessmt prepayment 42,215 62,890 37,960 20,000 20,000 0.00% 3610 Investment income 363,537 70,636 48,172 50,000 15,000 (35,000) -70.00% 3680 Other revenue 42,670 3,235 5,306 - - 0.00% 3972 Transfer from other funds 215,000 215,000 218,125 - 0.00% Total revenue 1,629,679 1,286,192 1,308,300 964,300 600,000 (364,300) -37.78% Operating expenses Operations (4470): Contractual services 3030 Other professional services 5220 Mounds View Blvd Imp. Total contractual services Capital 7050 Construction Total capital outlays Total expenses Net change in fund balance Fund balance, beginning year Fund balance, end of year 2,564 17,918 0.00% - 27,128 - 0.00% 2,564 45,046 0.00% 1,663,718 3,031,842 3,881,294 2,662,000 1,450,000 (1,212,000) -45.53% 1,663,718 3,031,842 3,881,294 2,662,000 1,450,000 (1,212,000) -45.53% 1,666,282 3,031,842 3,926,340 2,662,000 1,450,000 (1,212,000) -45.53% (36,603) (1,745,650) (2,618,040) (1,697,700) (850,000) 847,700 -49.93% 7,225,778 7,189,175 5,443,525 2,825,485 1,127,785 (1,697,700) -60.09% $7,189,175 $5,443,525 $2,825,485 $1,127,785 $ 277,785 $ (850,000) -75.37% 79 Fund: 485 Street Improvement: Revenues Account Description 2015 2016 2017 2018 Description 3101 Property takes 300,000 300,000 300,000 - General tax levy for streets 300,000 300,000 300,000 3180 Franchise fee 255,000 265,000 280,000 290,000 Half of the 4% franchase fee on gas & electric utilities 255,000 265,000 280,000 290,000 3352 MSA Street Construction 315,000 275,000 275,000 275,000 State aid funds 315,000 275,000 275,000 275,000 3360 Other County grants - 39,300 39,300 County trail grants (carryover) - 39,300 39,300 3550 Special assessments 20,000 20,000 20,000 20,000 Special assessments on private improvements 20,000 20,000 20,000 20,000 3610 Investment income 75,000 75,000 50,000 15,000 Estimated interest earnings at 1%. 75,000 75,000 50,000 15,000 3972 Transfer in 240,000 240,000 - - Transfers from utility funds (water 25,000, sewer 140,000, storm 75,000) 240,000 240,000 Cty Rd I and Quincy Intersection street lights 1,2Ub,uuu 1,214,JUU 904,SUU ouu,uuu Fund: 485 Department: 4470 Expenditures 7050 Construction > $25000 96,770 2014 Area G Street & Utility project 1,856,049 373,885 312,000 - 2015 Area H Street & Utility project 348,644 3,964,115 1,461,000 300,000 2016 Area I Street & Utility project - - 75,000 1,000,000 Program Avenue CSAH 10 to CR H2 (design phase) 50,000 Bronson Dr from Edgewood to Long Lake 100,000 Mill and overlay Silver View parking lot 125,000 150,000 - Mill and overlay (CH & MVCC) 285,000 285,000 Cty Rd H/10 intersection (MSA eligible)(City share)(Ramsey Co is lead) 627,000 79,000 Trail segments 6 and 11 (County grant/match of $39,300) 125,000 125,000 Cty Rd I and Quincy Intersection street lights 50,000 75,000 - Other pavement improvements (Silver View parking lot and trails) 350,000 1 75,000 1 175,000 Seal coat projects 2,701,463 1 5,650,000 1 2,662,000 1,450,000 80 THIS PAGE LEFT BLANK INTENTIONALLY 81 Operating revenue: Operating revenues Special assessments Connection charges Total operating revenue Operating expenses: Personal services Supplies Contractual services Electricity & gas Disposal charges Contingency Depreciation Capital outlays Total operating expenses Net operating income (loss) Non-operating revenue (expenses): CITY OF MOUNDS VIEW, MINNESOTA Enterprise Funds 2018 Budgets Combining Statement of Revenues and Expenses Sanitary Street Storm Total Water Sewer Lighting Water 2018 2017 1,105,176 1,599,940 104,402 271,500 3,081,018 2,969,608 60,000 - - - 60,000 60,000 2,000 - - - 2,000 2,000 1,167,176 1,599,940 104,402 271,500 3,143,018 3,031,608 374,134 360,299 8,133 131,677 874,243 871,871 97,129 31,372 1,000 20,475 149,976 127,406 209,707 98,893 3,900 186,661 499,161 483,419 115,500 2,100 70,000 - 187,600 187,600 - 978,249 - - 978,249 918,137 15,000 15,000 - - 30,000 30,000 241,000 85,000 - 32,000 358,000 455,000 104,200 172,200 - 102,920 379,320 409,640 1,156,670 1,743,113 83,033 473,733 3,456,549 3,483,073 10,506 (143,173) 21,369 (202,233) (313,531) (451,465) Investment income 500 21,000 1,300 16,000 38,800 46,800 Principal payment on debt (ESP Lease) - - (7,133) - (7,133) (6,924) Interest on debt (ESP Lease) - - (2,119) - (2,119) (2,329) Total non-operating 500 21,000 (7,952) 16,000 29,548 37,547 Transfers Transfers in - - - - - 35,000 Transfers out (144,103) (109,860) (2,771) (40,067) (296,801) (280,408) Revenues over (under) expenditures (133,097) (232,033) 10,646 (226,300) (580,784) (659,326) Add back: Capital outlays 104,200 172,200 - 102,920 379,320 409,640 Principal on debt - - 7,133 - 7,133 6,924 Net income (loss) (28,897) (59,833) 17,779 (123,380) (194,331) (242,762) Net assets (deficit), January 1 3,748,892 3,638,339 75,689 3,057,595 10,520,514 10,790,777 Net assets (deficit), December 31 $3,719,995 $3,578,506 $ 93,468 $2,934,215 $10,326,183 $10,548,015 82 Water (Fund 700): Revenues 1,300 3375 State pension contribution 3551 Spec assessments -current 3552 Spec assessments -delinquent 3553 Spec assess. -penalty & interest 3610 Investment income 3680 Other revenues 3710 Water sales 3714 Water service insurance 3715 Utility connections 3716 Penalties 3913 Meter sales 3917 WAC/SWM charges 3972 Transfers - Vehicle & Equip - 0.00% Total revenue Operating expenses Billing Services (4820): Personnel services 0100 Salaries, regular 0300 Social security 0321 PERA 0322 GASB 68 Pension Exp 0400 Group insurance 0500 Workers compensation Total personnel services Materials & supplies 1600 Supplies, operating Total materials & supplies Contractual services 3030 Other professional services 3300 Postage 3430 Printing 3630 Training 5130 Repairs, equipment Total contractual services Capital outlays 7030 Equipment Total capital outlays Miscellaneous: 9900 Transfers out to General Fund 9900 Transfers out to Vehicle Fund Total capital outlays Total Billing 2017 Budget Summary 2014 2015 2016 2017 2018 Change from 2017 Actual Actual Actual Budge Request Dollar Percent - - 1,300 - - 0.00% 62,591 63,729 82,620 60,000 60,000 0.00% 3,133 3,212 7,972 2,500 2,500 0.00% 647 415 762 - - 0.00% 8,909 (1,995) (648) 500 500 - 0.00% 10,399 2,598 2,344 2,000 2,000 - 0.00% 768,838 783,857 866,184 956,876 1,009,676 52,800 5.52% 65,848 83,413 87,775 85,000 85,000 - 0.00% 3,750 4,050 2,150 2,000 2,000 0.00% 7,022 8,649 8,967 6,000 6,000 0.00% 855 3,208 1,564 - - 0.00% 53,680 6,000 3,000 - 0.00% 72,000 - - 35,000 - (35,000) -100.00% 1,057,672 957,136 1,063,990 1,149,876 1,167,676 17,800 1.55% 40,222 42,117 43,284 43,167 42,806 (361) -0.84% 2,911 3,055 3,071 3,302 3,274 (28) -0.85% 2,810 3,039 3,105 3,238 3,211 (27) -0.83% - 8,173 26,980 - - - 0.00% 3,722 3,286 3,325 5,407 5,652 245 4.53% 311 437 310 354 289 (65) -18.36% 49,976 60,107 80,075 55,468 55,232 (236) -0.43% 50 50 - 0.00% 50 50 - 0.00% 6,891 8,040 8,008 8,436 8,583 147 1.74% 3,330 3,430 3,513 4,352 4,352 - 0.00% - 271 - 900 900 - 0.00% - - - 1,500 1,500 - 0.00% 4,017 4,264 5,223 4,448 4,712 264 5.94% 14,238 16,005 16,744 19,636 20,047 411 2.09% - 4,200 4,200 0.00% - 4,200 4,200 0.00% 69,393 75,828 78,103 2,275 3.00% 60,000 64,000 66,000 2,000 3.13% 129,393 139,828 144,103 4,275 3.06% 193,607 76,112 96,819 214,982 223,632 8,650 4.02% 159,514 164,200 83 Fund: 700 Department; 4820 Billing Services Account Description 2015 2016 2017 2018 Description 1600 Supplies, operating 50 50 50 50 Utility billing supplies 50 50 50 50 3030 Other professional services 7,742 400 7,889 400 8,036 400 8,183 400 24.5% of audit fee (2017 - $32,800, 2018 - $33,400) County special assessment maintenance fee 8,142 8,289 8,436 8,583 3300 Postage 3,136 800 490 3,136 800 441 3,072 800 480 3,072 800 480 3200 bills X $0.48 postage X 4 billings X 1/2 cost Inserting & mailing bills (moved from 3030) Late notices: 500 bills X $0.48 postage X 4 billings X 1/2 cost 4,426 4,377 4,352 4,352 3430 Printing 450 450 450 450 450 450 450 450 Utility bills (1/2 cost) Envelopes 900 900 900 900 3630 Training 1,500 1,500 1,500 1,500 Seminars on new regulations, sofrivare updates, etc. INCODE training 1,500 1,500 1,500 1,500 5130 Repairs, equipment 3,682 475 388 3,866 475 388 4,060 - 408 4,264 - 448 Incode sofrivare support (30%)(5% annual increase per agreement) Neptune reader maintenance (1/2 in sewer)(2019 first year $610) Neptune software maintenance (1/2 in sewer)(every 3 years)(2019)($2500) Handheld interface support for meter readers (1/2 in sewer)(Incode) 4,545 4,729 4,468 4,712 7030 Capital, equipment - - - 4200, Meter reader (1/2 water 1/2 sewer) - - - 4,200 9900 Transfers out 71,475 58,000 73,619 64,000 75,828 64,000 78,103 66,000 Transfer to General Fund for administrative overhead costs Transfer to Vehicle & Equipment Fund to fund future purchases 129,475 137,619 139,828 144,103 149,038 157,464 159,534 168,400 84 2017 Budget Summary 2014 2015 2016 2017 2018 Change from 2017 Actual Actual Actual Bake t Request Dollar Percent Water (Fund 700): Supplies, bldg & gmds 833 1,347 70 2,750 2,750 Infrastructure & Equip Maintenance (4823): 1220 Supplies, vehicles 506 (488) 1,660 1,500 1,500 Personnel services 0.00% 1230 Supplies, equipment 21,853 8,041 778 1,625 0100 Salaries, regular 195,190 177,110 177,908 187,284 187,150 (134) -0.07% 0110 Salaries, overtime 12,053 10,701 6,988 9,911 10,228 317 3.20% 0150 Salaries, part-time 8,921 8,318 4,637 10,320 10,320 - 0.00% 0300 Social security 14,989 13,853 13,236 15,873 15,888 15 0.09% 0321 PERA 14,625 13,564 13,618 15,095 15,108 13 0.09% 0400 Group insurance 31,480 28,772 28,957 33,480 35,474 1,994 5.96% 0500 Workers compensation 8,784 9,304 6,886 7,835 6,667 (1,168) -14.91% Total personnel services 286,042 261,622 252,230 279,798 280,835 1,037 0.37% Materials & supplies 1210 Supplies, bldg & gmds 833 1,347 70 2,750 2,750 0.00% 1220 Supplies, vehicles 506 (488) 1,660 1,500 1,500 0.00% 0.00% 1230 Supplies, equipment 21,853 8,041 778 1,625 11,455 9,830 604.92% 1240 Supplies, streets 2,226 5,186 4,464 3,000 3,000 - 0.00% 1250 Supplies, utilities 17,265 17,350 21,114 15,000 27,000 12,000 80.00% 1260 Supplies, traffic control 200 - 200 200 200 - 0.00% 1600 Supplies, operating 8,615 8,770 3,676 7,000 7,000 - 0.00% 1700 Motor fuels 5,652 5,145 3,634 4,000 4,300 300 7.50% 2400 Uniforms 1,025 1,474 1,802 1,100 1,100 - 0.00% 2410 Mats & towels 634 697 714 620 620 - 0.00% Repairs, vehicles Total materials & supplies 58,809 47,522 38,112 36,795 58,925 22,130 60.14% Contractual services 3030 Other professional services 20,946 34,125 24,544 8,630 8,630 - 0.00% 3100 Communications - telephone 2,435 3,025 3,566 3,164 3,075 (89) -2.81% 3200 Water & wastewater charges 6,398 8,501 7,309 7,200 7,200 - 0.00% 3220 Natural gas 8,336 7,405 5,265 7,500 7,500 0.00% 3610 Memberships 527 - 26 290 290 0.00% 3630 Training 2,737 2,950 1,274 3,850 3,850 0.00% 4010 Equipment rental 7,117 2,905 728 4,500 4,500 0.00% 4800 Insurance 6,754 6,933 7,550 10,230 10,230 0.00% 5110 Repairs, bldgs & gmds 1,758 6,531 15,323 11,540 11,540 0.00% 5120 Repairs, vehicles - 20 1,265 1,000 1,000 0.00% 5130 Repairs, equipment 8,025 7,670 8,345 15,600 15,600 0.00% 5140 Repairs, streets 3,110 6,450 - 10,000 10,000 0.00% 5150 Repairs, utilities 14,516 19,415 25,821 17,500 17,500 0.00% 5155 Water service repair 121,561 71,104 82,048 80,000 80,000 0.00% 5160 Repairs, system maintenance 9,280 742 - 3,500 3,500 0.00% Total contractual services 213,500 177,776 183,064 184,504 184,415 (89) -0.05% Capital outlays 7030 Equipment - - - 127,640 50,000 (77,640) -60.83% 7050 Construction - - - 57,000 50,000 (7,000) -12.28% 7950 Depreciation 254,991 277,657 240,583 270,000 241,000 (29,000) -10.74% Total capital outlays 254,991 277,657 240,583 454,640 341,000 (113,640) -25.00% Miscellaneous: 9100 Contingency - - - 15,000 15,000 0.00% Total miscellaneous - - - 15,000 15,000 0.00% Total infrastructure & equip maint 813,342 764,577 713,989 970,737 880,175 (90,562) -9.33% 690,939 599,340 85 Fund: 700 Department: 4823! Water Infrastructure & Equipment Maintenance Account Description 2015 2016 2017 2018 Description 1210 Supplies, Bldgs & grounds 100 100 100 100 Mops, buckets, brooms 500 500 500 500 Light tubes & ballasts 200 200 200 200 Paper products 200 200 200 200 Paint, thinner, & brushes 750 750 750 750 Black dirt & sod/seed,landscaping materials 500 500 500 500 Misc. cleaners for well houses & % of shop 500 500 500 500 hrigation parts 2,750 2,750 2,750 2,750 1220 Supplies, vehicles 300 300 300 300 Air, oil, fuel, & transmission filters 100 100 100 100 Fluids 400 400 400 400 Batteries and tires 50 50 50 50 Paint sealant 150 150 150 150 Time ups 500 500 500 500 Misc repairs 1,500 1,500 1,500 1,500 1230 Supplies, equipment <$5000 100 100 100 100 Tune ups 100 100 100 100 Grounds maintenance equipment 100 100 100 100 Blades, suction hoses, filter screens 175 175 175 175 Hydraulic fluid: 35 gallons a $4.80 / gallon 200 200 200 200 Solvents & cleaning fluids 200 200 200 200 Air compressor & dehumidifier parts 500 500 500 500 Chemical equipment parts (fluoride pumps) - - - 4,830 Spin Doctor (battery operated valve operator) 5,000 Line locator (Metrotech) - Fluoride tank replacement (3 tanks every 3 years)(2018 next) 250 250 250 250 Air, oil, fuel, & trans filters (emergency generator) 1,625 1,625 1,625 11,455 1240 Supplies, streets 3,000 3,000 3,000 3,000 Asphalt/concrete/sod/seed for patching minor street, curb, driveway repairs. 3,000 3,000 3,000 3,000 1250 Supplies, utilities 2,000 2,500 2,500 2,500 Paint & sandblasting materials for hydrants 500 500 500 500 Copper, steel & PVC pipe 1,500 1,500 1,500 1,500 Valve box risers, main repair clamps 250 1,000 1,000 1,000 Hydrant markers - - 1,050 1,050 De -chlorinator - - - 12,000 Scales in treatment plants ($2118 each x 5 plus incidentals) 3,000 3,000 3,450 3,450 Hydrant parts (hydrant pump $450 - 2017) 3,000 3,000 5,000 5,000 Meter supplies, etc. (move from account 1600) 10,250 11,500 15,000 27,000 1260 Supplies, traffic control 200 200 200 200 Traffic cones / safety vests 200 200 200 200 1600 Supplies, operating 500 500 500 500 Propane, acetylene & oxygen supplies 400 400 400 400 Gloves, masks, & rags 650 650 1,850 1,850 Film, first aid supplies, & batteries (add hearing protection) 2,500 2,500 2,500 2,500 Location flags & paint (moved from account 1250) 250 250 250 250 Cleaning supplies 1,500 1,500 1,500 1,500 Additional & replacement hand tools 5,800 5,800 7,000 7,000 1700 Motor fuels & lubs 700 650 560 600 Diesel fuel - 200 gallons @ $3.00 450 450 450 450 Oil 2,700 2,475 2,990 3,250 Unleaded fuel: 1,300 gallons n $2.50 3,850 3,575 4,000 4,300 2400 Uniforms 995 1,100 1,100 1,100 Uniforms 15.5% of $4,500 and clothing 1.7 FTE x $175 per contract 995 1,100 1,100 1,100 2410 Mats & towels 775 620 620 620 Share of floor mats & shop towels (15.5% of $4,000) 775 620 620 620 3030 Other professional services 180 180 180 180 Backflow prevention testing (3 @ $60 per test) - 3,000 - - Water system leak survey (every 2 years, next in 2018) - 11,000 - - Production assessment ($312,000 defer) 500 500 500 500 Broadleaf control 1,000 1,000 1,000 1,000 Asset management sofhvare 250 250 250 250 Fire sprinkler inspections/testmg 200 200 200 200 Fire extinguisher inspection/service (10 @ $20) 1,500 1,500 1,500 1,500 Gopher State One -call locates 5,000 5,000 5,000 5,000 Arcview/GIS base map and engineering consulting 8,630 22,630 8,630 8,630 3100 Communications - telephone 400 400 400 400 Service & repair 1,505 1,846 1,954 1,954 Cellular phone service (20.06% of $9,200) 720 720 720 631 Data cards for SCADA (2)(75%)(35.01 per card) balance in Sewer 90 90 90 90 800 MHz license fee (33%)(5 radios @ $4.48 per month) 2,715 31056 3,164 3,075 3200 Water and wastewater charges 7,200 7200, 7,200 7,200 7,200 7,200 7,200 7,200 1 86 THIS PAGE LEFT BLANK INTENTIONALLY 87 Fund: 700 Department: 4823 Sinter Infrastructure & Equipment Maintenance Account Description 2015 2016 2017 2018 Description 3220 Natural gas 7,000 7,000 7,500 7,500 Heating fiuel 7,000 7,000 7,500 7,500 3610 Memberships 100 100 100 100 MN Rural Water Association (50%) 80 80 80 80 MN Safety Council (19% of $405) 50 50 50 50 Suburban Utility Superintendant Association (SUSA)(50% of $100) 60 60 60 60 Pressurized vessel license 290 290 290 290 3630 Training 250 250 250 250 Computer training/webinars 1,200 1,200 1,200 1,200 Trench safety/confined space alternate years 110 110 110 110 Hearing test/R2K (2.15 FTE * $50) 60 60 60 60 Maintenance Expo 820 820 820 820 Water operator class/exam/certificate ($205 per person) 200 200 200 200 Misc. training seminars 390 390 390 390 Equipment operator training 200 200 200 200 MRWA workshops 560 560 560 560 Tuition reimbursement 60 60 60 60 Work zone safety seminar (every 3 years) 3,850 3,850 3,850 3,850 4010 Rental, equipment 4,000 4,000 4,000 4,000 Skid steer - upgrade 300 300 300 300 Barricades & signs 200 200 200 200 Tools & equipment 4,500 4,500 4,500 4,500 4800 Insurance 10,230 10,230 10,230 10,230 Share of property/liability insurance 10,230 10,230 10,230 10,230 5110 Repairs, buildings & grounds 2,000 2,000 2,000 2,000 Door & lock repairs 1,000 1,000 1,000 1,000 Roof & wall repairs 3,000 3,000 7,540 7,540 Electrical & mechanical repairs (well #2 in 17 well #4 in 18 $4540) 1,000 1,000 1,000 1,000 Site repairs (pavement, fence, irrigation, etc...) 7,000 1 71000 11,540 11,540 5120 Repairs, vehicles 1,000 1,000 1,000 1,000 Utility truck repairs 1,000 1,000 1,000 1,000 5130 Repairs, equipment 1,500 1,500 1,500 1,500 Well and water treatment plant repairs 1,500 1,500 1,500 1,500 Miscellaneous repairs (Backhoe, Skid steer) 3,000 3,000 Repair boiler @ main plant 3,500 3,500 3,500 Generator service - Onan 2,500 2,500 2,500 VFD service 1,500 1,500 1,500 1,500 Meter and valve repairs 2,000 2,000 2,000 2,000 SCADA repairs 100 100 100 100 Radio repairs 6,600 12,600 15,600 15,600 5140 Repairs, streets 10,000 10,000 10,000 10,000 Contractor repairs to streets after water main breaks 10,000 10,000 10,000 10,000 5150 Repairs, utilities 5,000 5,000 5,000 5,000 Fire hydrant repairs 5,000 5,000 5,000 5,000 Gate valve repairs 7,500 7,500 7,500 7,500 Water main repairs 17,500 17,500 17,500 1 17,500 5155 Water service repairs 65,000 65,000 65,000 65,000 Contractor repairs to residential water services. 15,000 15,000 15,000 15,000 Pavement & curb repairs 80,000 80,000 80,000 80,000 5160 System maintenance 3,500 3,500 3,500 3,500 Water system maintenance & repair items - Well #4 perimeter fencing ($5000 well #5 fencing defer to 2018) 3,500 3,500 3,500 3,500 7030 Capital, equipment > $5000 15,000 15,000 15,000 15,000 Gate valves - 31,958 42,640 - SCADA system upgrades (automatic controls) 35,000 35,000 35,000 Booster station (pressure valve) 10,000 - - Water treatment plant (leaking valve) 14,000 14,000 Trench box 2,750 2,750 Electric rain gauges SCADA System (33%)(total cost $8,250) 25,000 25,000 Security cameras & card key access - - 35,000 - 3/4 ton pick -tip 56,750 133,708 127,640 50,000 7050 Construction > $25000 - 80,000 - 12,000 - Wells 96 building repairs (int. and exterior repairs) Well #5 repairs (design in 2017)($90,000 defer to 2018) 200,000 - - Reservoir & booster, station building and roof repairs (carryover from 10,11) - 25,000 - Water system upgrades wells 91,2 60,000 - 45,000 50,000 Well pump rehabilitation project (well no. 1 - 2017, 2 - 2018) 260,000 105,000 57,000 50,000 88 2017 Budget Summary 2014 2015 2016 2017 2018 Change from 2017 Actual Actual Actual Budget Request Dollar Percent Water (Fund 700): capital outlays Water Production (4825): 104,200 (80,440) 43.57% principal payment on debt - - - Personnel services 0.00% Change in net assets (82,915) (54,757) 63,244 (56,295) (28,897) 27,398 48.67% 0100 Salaries, regular 269 24,576 25,292 26,548 27,399 851 3.21% 0110 Salaries, overtime - 1,717 2,762 - - - 0.00% 0300 Social security 19 1,760 1,929 2,031 2,096 65 3.20% 0321 PERA 19 2,045 2,079 1,991 2,055 64 3.21% 0400 Group insurance 41 4,492 4,925 5,040 5,328 288 5.71% 0500 Workers compensation - 1,688 1,224 1,398 1,189 (209) -14.95% Total personnel services 348 36,278 38,211 37,008 38,067 1,059 2.86% Materials & supplies 1600 Supplies, operating 27,583 25,855 26,528 37,775 37,775 - 0.00% 2400 Uniforms - - - 235 235 0.00% 2410 Mats & towels - - - 144 144 0.00% Total materials & supplies 27,583 25,855 26,528 38,154 38,154 0.00% Contractual services 3030 Other professional services 2,155 7,154 11,984 21,930 12,745 (9,185) -41.88% 3210 Electricity 103,552 101,917 113,215 108,000 108,000 - 0.00% Total contractual services 105,707 109,071 125,199 129,930 120,745 (9,185) -7.07% Total water production 133,638 171,204 189,938 205,092 196,966 (8,126) -3.96% 168,084 158,899 Total expenditures 1,140,587 1,011,893 1,000,746 1,390,811 1,300,773 (90,038) -6.47% Revenues over(under)expenditures (82,915) (54,757) 63,244 (240,935) (133,097) 107,838 -44.76% Add back: capital outlays 184,640 104,200 (80,440) 43.57% principal payment on debt - - - - 0.00% Change in net assets (82,915) (54,757) 63,244 (56,295) (28,897) 27,398 48.67% Net Assets, beginning year 4,075,677 3,992,762 3,741,943 3,805,187 3,748,892 (56,295) -1.48% Accounting Change GASB 68 pension (196,062) Net Assets, end of year $ 3,992,762 $ 3,741,943 $ 3,805,187 $ 3,748,892 $ 3,719,995 $ (28,897) -0.77% 1,018,537 922,439 89 Fund: 700 Department: 4823 Water Infrastructure & Equipment Maintenance 7950 Depreciation 245,000 255,000 270,000 241,000 Estimated depreciation 245,000 255,000 270,000 241,000 9100 Contingency 15,000 15,000 15,000 15,000 Contingency 15,000 15,000 15,000 15,000 9900 Transfers out 25,000 25,000 - - Water system upgrades in conjunction with major roadway program 25,000 25,000 SU2.Mu 7»./S4 bYU.YSY DYY.J9U Fund: 700 Department: 4825 WaterProduetion Account Description 2015 2016 2017 2018 Description 1600 Supplies, operating 550 550 550 550 Computer supplies 800 800 800 800 Testing reagents 4,125 4,125 4,125 4,125 Sulfur dioxide: 25 150# cylinders@ $1.10 per pound 8,800 8,800 10,400 10,400 Chlorine: 8 - I ton cylinders @ .65 per pound 9,350 9,350 10,350 10,350 75 - 150 # cylinders @ $.92 per pound 7,400 7,400 7,400 7,400 Hydrofluosilic acid: 20,000 pounds @ $0.37 3,300 3,300 3,300 3,300 R-999 Buffer solution 2 - 55 gal drums @ $30 per gal. 850 850 850 850 Sand separator 35,175 35,175 37,775 37,775 2400 Uniforms 235 235 235 235 Uniforms 3.6% of $4,500 and clothing .4 FTE x $175 per contract 235 235 235 235 2410 Mats & towels 180 144 144 144 Share of floor mats & shop towels (3.6% of $4,000) 180 144 144 144 3030 Other professional services 960 960 960 1,200 Bacteria tests (10*$10*12 months) 800 800 800 800 Computer maintenance 1,000 1,000 1,000 - Consumer confidence report (on-line) 10,000 10,000 7,000 5,500 DNR water permit fee (annual surcliarge)(14 - $3826, 15 - $4462, 16 - $4532; 300 300 300 - Emergency Response Commission fees (same as MNDPS - EPCRA program) 1,120 1,120 1,120 1,120 Full scan tests -4 @ $280 600 600 600 600 Minimum contamination level (MCL) tests 1,000 1,000 1,000 1,000 Radon tests 800 800 800 800 Random sample tests 1,050 1,050 1,050 1,425 MCES discharge permits (3*$475) 300 300 300 300 MNDPS - EPCRA program ($100/WTP) 7,000 7,000 7,000 - Well head protection plan (req. by Dept. of Health)(] 1, 12, 13 Barr Eng.) 24,930 24,930 21,930 12,745 3210 Electricity 108,000 108,000 108,000108,000 Electricity for wells, tower & reservoir 108,000 108,000 108,000 108,000 168,)2U 168,454 ibS,US4 1DS,SYY 1,120,068 1,081,682 1,018,557 926,639 -16.47% -3.43% -5.84% -9.02% 90 2017 Budget Summary 2014 2015 2016 2017 2018 Change from 2017 Actual Actual Actual Budget Request Dollar Percent Sanitary Sewer (Fund 730): Revenues 3375 State pension contribution - 1,215 0.00% 3551 Spec. Assessments - 13,105 - 147 - Personnel services 0.00% 3610 Investment income 128,382 26,380 21,359 30,000 21,000 (9,000) -30.00% 3680 Other revenues 30,000 - - - - - 0.00% 3716 Penalties 9,117 10,936 12,225 6,000 8,000 2,000 33.33% 3720 Utility sales 1,301,911 1,375,522 1,456,900 1,501,830 1,591,940 90,110 6.00% 3721 SAC charges 13,170 (1,988) 149 - - - 0.00% 3725 Utility connections 1,200 1,900 1,202 - 293 (66) 0.00% 3726 Penalties & interest 603 612 825 - (237) -0.43% 0.00% 3972 Transfers from Vehicle Fund - - 60,000 - -1.95% 1600 Supplies, operating 0.00% - Total revenue 1,484,383 1,426,467 1,553,875 1,537,830 1,620,940 83,110 5.40% Operating expenses Billing Services (4820): 6,780 7,620 8,008 8,036 8,183 147 1.83% Personnel services 3,330 3,430 3,513 4,352 4,352 - 0.00% 0100 Salaries, regular 40,222 42,139 43,284 43,167 42,806 (361) -0.84% 0300 Social security 2,911 3,059 3,071 3,302 3,274 (28) -0.85% 0321 PERA 2,809 3,042 3,105 3,238 3,211 (27) -0.83% 0322 GASB 68 Pension expense - 7,871 25,217 - - - 0.00% 0400 Group insurance 3,721 3,289 3,325 5,407 5,652 245 4.53% 0500 Workers compensation 311 437 314 359 293 (66) -18.38% Total personnel services 49,974 59,837 78,316 55,473 55,236 (237) -0.43% Materials & supplies 267,159 270,245 263,656 311,125 305,063 (6,062) -1.95% 1600 Supplies, operating - - - 50 50 - 0.00% Total materials & supplies - 50 50 - 0.00% Contractual services 3030 Other professional services 6,780 7,620 8,008 8,036 8,183 147 1.83% 3300 Postage 3,330 3,430 3,513 4,352 4,352 - 0.00% 3430 Printing - 271 - 900 900 11,802 0.00% 3630 Training - - - 1,500 1,500 15,681 0.00% 5130 Repairs, equipment 4,017 4,264 5,223 4,943 4,712 (231) -4.67% Total contractual services 14,127 15,585 16,744 19,731 19,647 (84) -0.43% Capital outlays 16,723 16,278 (445) -2.66% 400 Group insurance 30,670 7030 Equipment 32,087 37,998 40,268 - 4,200 4,200 0.00% Total capital outlays 10,183 7,349 - 6,866 4,200 4,200 0.00% Miscellaneous: 9900 Transfers out to General Fund 54,962 56,611 58,309 60,058 61,860 1,802 3.00% 9900 Transfers out to Vehicle Fund 36,000 53,000 42,000 38,000 48,000 10,000 26.32% Total miscellaneous 90,962 109,611 100,309 98,058 109,860 11,802 12.04% Total Billing 155,063 185,033 195,369 173,312 188,993 15,681 9.05% 11,520 - 0.00% 300 117,839 133,757 14,237 13,746 Infrastructure & Equip Maintenance (4823): Personnel services 100 Salaries, regular 192,664 187,913 186,137 210,439 204,946 (5,493) -2.61% 110 Salaries, overtime 7,942 5,326 5,370 8,447 8,012 (435) -5.15% 150 Salaries, part-time - 8,318 4,637 11,520 11,520 - 0.00% 300 Social security 13,753 14,237 13,746 17,624 17,173 (451) -2.56% 321 PERA 13,885 14,010 14,330 16,723 16,278 (445) -2.66% 400 Group insurance 30,670 30,258 32,087 37,998 40,268 2,270 5.97% 500 Workers compensation 8,245 10,183 7,349 8,374 6,866 (1,508) -18.01% Total personnel services 267,159 270,245 263,656 311,125 305,063 (6,062) -1.95% 91 Fund: 730 Department: 4820 Billing Services Account Description 2015 2016 2017 2018 Description 1600 Supplies, operating 50 50 50 50 Utility billing supplies 50 50 50 50 3030 Other professional services 7,742 7,889 8,036 8,183 24.5% of audit fee (2017 - $32,800, 2018 - $33,400) 7,742 7,889 8,036 8,183 3300 Postage 3,136 800 490 3,136 800 490 3,072 800 480 3,072 800 480 3200 bills X $0.48 postage X 4 billings X 1/2 cost Inserting & mailing bills (moved from 3030) Late notices: 500 bills X $0.48 postage X 4 billings X 1/2 cost 4,426 4,426 4,352 4,352 3430 Printing 450 450 450 450 450 450 450 450 Envelopes Utility bills (1/2 cost) 900 900 900 9-00- 3630 Training 1,500 1,500 1,500 1,500 Seminars on new regulations, software updates, etc. INCODE training 1,500 1,500 1,500 1,500 5130 Repairs, equipment 3,681 - 475 388 3,866 - 475 388 4,060 - 475 408 4,264 - - 448 Incode sofhvare support (30%)(5% annual increase per agreement) Neptune reader maintenance (1/2 in waterx2019 first year $610) Neptune sofhvare maintenance (1/2 in water)(every 3 years)(2019)($2500) Handheld interface support for meter readers (50% water 50% sewer)(Incode) 4,544 4,729 4,943 4,712 7030 Capital, equipment - 4,200 IMeter reader (1/2 water 1/2 sewer) - - - 4,200 9900 Transfers out 56,611 53,000 58,309 42,000 60,058 38,000 61,860 48,000 Transfer to General Fund for admin costs Transfer to Vehicle & Equipment Fund for vehicle use 109,611 1 100,309 98,058 109,860 128,773 119,803 117,839 133,757 92 2017 Budget Summary 2014 2015 2016 2017 2018 Chaneefrom 2017 Actual Actual Actual Budeet Request Dollar Percent Sanitary Sewer (Fund 730): Materials & supplies 3030 Other professional services 6,697 1,341 4,075 8,200 1210 Supplies, bldg & gmds - - - 200 200 0.00% 1220 Supplies, vehicles 1,872 244 2,925 1,575 1,575 - 0.00% 1230 Supplies, equipment 7,895 4,963 6,214 8,350 8,350 - 0.00% 1240 Supplies, streets - - 1,307 2,500 2,500 0.00% 1250 Supplies, utilities 112 904 163 1,400 1,400 - 0.00% 1260 Supplies, traffic control 325 - 335 300 300 0.00% 1600 Supplies, operating 11,944 3,732 1,250 10,550 10,550 0.00% 1700 Motor fuels 4,789 5,061 2,307 4,290 4,550 260 6.06% 2400 Uniforms 1,168 1,007 1,162 1,169 1,169 - 0.00% 2410 Mats & towels 634 697 714 728 728 - 0.00% Total materials & supplies 28,739 16,608 16,377 31,062 31,322 260 0.84% Contractual services 3030 Other professional services 6,697 1,341 4,075 8,200 8,200 0.00% 0.00% 3100 Communications - telephone 1,492 1,575 1,736 2,086 2,086 7950 Depreciation 0.00% 3200 Water & sewer 3,301 3,335 3,514 3,300 3,300 165,752 0.00% 3210 Electricity 2,668 1,923 1,883 2,100 2,100 0.00% 3230 Wastewater disposal - MCES 822,568 832,084 898,621 912,137 972,249 60,112 6.59% 3231 Wastewater disposal - Strength chg 5,394 5,157 - 6,000 6,000 - 0.00% 3610 Memberships 153 - - 230 230 - 0.00% 3630 Training 2,258 1,693 1,951 4,430 4,880 450 10.16% 4010 Equipment rental - - 431 500 500 - 0.00% 4800 Insurance 9,024 7,451 4,796 7,300 7,300 - 0.00% 5130 Repairs, equipment 10,899 3,259 5,507 14,032 11,750 (2,282) -16.26% 5140 Repairs, streets - - 141 10,000 10,000 0.00% 5150 Repairs, utilities 3,941 719 13,774 17,500 17,500 (87,623) 0.00% 5155 Utility service repairs 10,827 - - - - - 0.00% 5160 Repairs, maintenance 9,665 2,418 4,279 13,500 13,500 - 0.00% Total contractual services 888,887 860,955 940,708 1,001,315 1,059,595 58,280 5.82% Capital outlays 7030 Equipment - - - - 0.00% 7050 Construction - - - 150,000 168,000 18,000 12.00% 7950 Depreciation 165,752 151,592 85,388 153,000 85,000 (68,000) -44.44% Total capital outlays 165,752 151,592 85,388 303,000 253,000 (50,000) -16.50% Miscellaneous: 9100 Contingency - - - 15,000 15,000 0.00% 9900 Transfer to Street fund 140,000 140,000 140,000 - - - 0.00% Total miscellaneous 140,000 140,000 140,000 15,000 15,000 0.00% 1,350,377 1,358,917 Total infrastructure & equip maint 1,490,537 1,439,400 1,446,129 1,661,502 1,663,980 2,478 0.15% Total expenditures 1,645,600 1,624,433 1,641,498 1,834,814 1,852,973 18,159 0.99% Revenues over (under) expenditures (161,217) (197,966) (87,623) (296,984) (232,033) 64,951 -21.87% Add back: capital outlays - - 150,000 172,200 22,200 14.80% Change in net assets (161,217) (197,966) (87,623) (146,984) (59,833) 87,151 -59.29% Net Assets, beginning of year 4,415,223 4,254,006 3,872,946 3,785,323 3,638,339 (146,984) -3.88% Accounting Change GASB 68 pension (183,094) Net Asset, end of ,year $ 4,254,006 $ 3,872,946 $ 3,785,323 $ 3,638,339 $ 3,578,506 $ 27,318 0.75% 1,468,216 1,492,674 93 Fund: 730 Department: 4823 Wastewater Infrastructure &' Equipment Maintenance Account Description 2015 2016 2017 2018 Description 1210 Supplies, bldgs & grounds 100 100 100 100 Paint, bulbs, fuses, etc 100 100 100 100 Seed, dirt, sod, etc 200 200 200 200 1220 Supplies, vehicles 75 75 75 75 Air, oil, fuel & transmission filters 775 775 775 775 Fluids 125 125 125 125 Repair & replacement parts 600 600 600 600 Tires & batteries 1,200 - - - Back-up camera for televising van 2,775 1,575 1,575 1,575 1230 Supplies, equipment < $5000 650 650 650 650 Tune up parts 500 500 500 500 Hydraulic fluids & hoses 200 200 200 200 Cutting edges (skid loader) 300 300 300 300 Misc. replacement & repair parts 300 300 300 300 Light equip misc replacement & repair parts 2,000 2,000 2,000 2,000 Camera track and parts (CCTV) 300 300 300 300 Minor repairs 100 100 100 100 Gas detection device parts and supplies 300 300 4,000 4,000 Vactor cleaning nozzle parts and supplies (nozzle 2017, hose 2018) 4,650 4,650 8,350 8,350 1240 Supplies, streets 200 200 200 200 Tack coat 300 300 300 300 Dewatering rock/agg. base 2,500 2,500 2,000 2,000 Asphalt mix 3,000 3,000 2,500 2,500 1250 Supplies, utilities 1,500 1,500 - - Replacement pumps & motors 100 100 100 100 Filters, packings, relays, etc 300 300 300 300 Speed crete (mortar) 700 700 700 700 Repair parts 2,500 - - - Portable flow meter 750 750 300 300 Manhole covers, adjust rings & bolts 5,850 3,350 1,400 1,400 1260 Supplies, traffic control 300 300 300 300 Traffic cones, work zone sign face, safety vests 300 300 300 300 1600 Supplies, operating 500 500 500 500 Additional & replacement hand tools 250 250 250 250 Glove & paper products 150 150 150 150 Disinfectant supplies 500 500 500 500 Camera supplies 200 200 1,500 1,500 First aid supplies, protective equip (add hearing equipment for 2017) 400 400 400 400 CD's, DVDs, software 250 250 250 250 Engineering supplies 700 700 700 700 Shop supplies, fastners, soap, degreasers, steet, batteries 500 500 500 500 Pipe, fittings, and accessories (connectors) 500 500 500 500 Locating supplies (paint, flags, markers, etc.) 8,000 10,000 5,000 5,000 Chemical blocks for lift stations 300 300 300 300 Filter replacement for sewer gas monitors 12,250 14,250 10,550 10,550 1700 Motor fuels & lubs 1 300 300 300 300 Fluids 600 600 600 600 Motor oil - 100 gallons $6 gal. 1,500 1,375 1,150 1,250 Unleaded fuel 500 gallons @ $2.50 2,800 2,600 2,240 2,400 Diesel fuel 800 gallons @ $3.00 5,200 4,875 4,290 4,550 2400 Uniforms 1,169 1,169 1,169 11169 Uniforms 18.2% of $4,500 and clothing 2.0 FTE x $175 per contract 1,169 1 1,169 1,169 11169 2410 Mats & towels 910 728 728 728 Share of floor mats & shop towels (18.2% of $4,000) 910 728 728 728 3030 Other professional services 1,500 1,500 1,500 1,500 Gopher State One Call locates 600 600 600 600 Consulting engineering services - annual lift station inspections 100 100 100 100 Fire extinguisher inspection/servcie (5 @ $20) 1,000 1,000 1,000 1,000 Asset management software 2,500 1 2,500 5,000 5,000 Arcview/GIS base map and engineering consulting (add comp plan maps 2017 5,700 5,700 8,200 8,200 3100 Communications -telephone 1,455 1,785 1,785 1,785 Cellular phone service (19.4% of$9,200) 240 240 211 211 Data cards for SCADA (2)(25%) balance in Water (35.01 per card per month) 90 90 90 90 800 Mhz radio license fee (33%)(5 radios @ $4.48 per month) 1,785 2,115 2,086 2,086 3200 Water & Sewer service 3,000 3,000 3,300 3,300 Estimated annual charge 3,000 3,000 3,300 3,300 3210 Electricity 2,300 2,300 2,100 2,100 Electricity for lift stations 2,300 2,300 2,100 2,100 49,V89 4/,LIZ 40,/425 4/,W8 94 THIS PAGE LEFT BLANK INTENTIONALLY 95 Fund: 730 Department: 4823 Wastewater Infrastructure & Equipment Maintenance (continued) Account Description 2015 2016 2017 2018 Description 3230 Met Council Environ. Servies MCI 832,084 892,571 912,137 972,249 Annual charge (1.57% increase for 2017)($76,011.37/mo) 832,084 892,571 912,137 972,249 3231 MCES Strength charges - 5,500 6,000 6,000 Strength Charge (new charge from MCES) 51500 6,000 6,000 3610 Memberships 100 100 100 100 MN Rural Water Assoc. (50%) 50 50 50 50 Suburban Utility Superintendant Association (SUSA)(50% of $100) 80 80 80 80 MN Safety Council (20%) 230 230 230 230 3630 Training 1,400 1,400 1,500 1,500 Collection operators training/renewal ($300 per person) 560 560 560 560 Tuition reimbursement (PW Mgt. Class - North Hennepin CC) 250 250 250 250 Computer training/webinars 110 110 110 110 Hearing tesMK (2.15 FTE * $50) 1,200 1,200 1,200 1,200 Confined space/trench safety alternate years) 120 120 - - Pesticide applicators license 300 300 300 750 Miscellaneous wastewater training (certified pipe inspector) 60 60 60 60 Maintenance Expo 390 390 390 390 Equipment operator training 60 60 60 60 Work zone safety seminar (every 3 years next 2020) 4,450 4,450 4,430 4,880 4010 Rental, equipment 500 500 500 500 Barricades & signs 500 500 500 500 4800 Insurance 7,300 7,300 7,300 7,300 Share ofproperty/liability insurance 7,300 7,300 7,300 7,300 5130 Repairs, equipment 2,500 2,500 - - Repairs to motors & pumps (in 5150) 7,782 - Move omni antenna at groveland lift station 2,500 2,500 2,500 8,000 Repairs to Vactor (jet truck) 2,500 2,500 2,500 2,500 Repairs to camera van and camera equipment 1,000 1,000 1,000 1,000 Repairs to utility truck 250 250 250 250 Misc repairs 8,750 8,750 14,032 11,750 5140 Repairs, streets 10,000 10,000 10,000 10,000 Contractor restoration of pavement, bwd., etc... 10,000 10,000 10,000 10,000 5150 Repairs, utilities 2,500 2,500 2,500 2,500 Lift station repairs 15,000 15,000 15,000 15,000 Sanitary collection system repairs 17,500 17,500 17,500 17,500 5160 System maintenance 25,000 25,000 5,000 5,000 Root control 4,500 4,500 4,500 4,500 Lift station maintenance/cleaning/pump service 4,000 4,000 4,000 4,000 Sewer debris disposal costs 33,500 33,500 13,500 13,500 7030 Capital, equipment > $5000 - 30,000 - - Generator - Bronson (natural gas)(New to replace mobile generator) 2,750 2,750 Electronic rain gauges for SCADA (33%)(total cost $8,250) 12,000 12,000 Grinder station for Bronson lift station 14,750 44,750 7050 Construction > $25000 250,000 250,000 150,000 150,000 Sewer pipe relining program 18,000 Upgrade panel Bronson lift station and nat gas generator 350,000 - - - Groveland lift station rehabilitation (with area H project) 600,000 250,000 150,000 1 168,000 7950 Depreciation 167,000 167,000 153,000 85,000 Estimated depreciation 167,000 167,000 153,000 85,000 9100 Contingency 15,000 15,000 15,000 15,000 Contingency - may include lift station impeller replacement at Bronson 15,000 15,000 15,000 15,000 9900 Transfer out 140,000 140,000 - - Sewer system upgrades in conjunction with major roadway program 140,000 140,000 1,900,153 1,644,263 1,350,377 1,358,917 96 Street Lighting (Fund 740): Revenues Other professional services 3610 Investment income 3716 Penalties 3740 Street lighting charges 5160 Total revenue Operating expenses Operations (4416) Personnel services 0100 Salaries, regular 0110 Salaries, overtime 0300 Social security 0321 PERA 0400 Group insurance 0500 Workers compensation Total personnel services Materials & supplies 1600 Supplies, operating Contractual services 3030 Other professional services 3210 Electricity 4800 Insurance 5150 Repairs, utilities 5160 Repairs, system maintenance 90,844 Total contractual services Other 8011 Lease payable - principal (ESP) 8021 Lease payable - interest (ESP) 9900 Transfer to General Fund Total other Total expenditures Revenues over (under) expenditures Add back: Capital outlays/Prin on debt Change in net assets Net assets, beginning year Net assets, end of year 2017 Budget Summary 2014 2015 2016 2017 2018 Chan2efrom 2017 Actual Actual Actual Budget Request Dollar Percent 5,251 1,250 1,164 1,300 1,300 - 0.00% 603 719 728 500 500 - 0.00% 87,449 90,844 97,031 103,902 103,902 - 0.00% 93,303 92,813 98,923 105,702 105,702 - 0.00% 2,768 8,430 7,014 6,765 6,286 (479) -7.08% - 115 119 - - - 0.00% 189 487 494 518 481 (37) -7.14% 202 504 515 434 396 (38) -8.76% 588 1,132 1,172 630 666 36 5.71% 22 346 240 294 304 10 3.40% 3,769 11,014 9,554 8,641 8,133 (508) -5.88% - - 25 1,000 1,000 - 0.00% - 796 35 - - - 0.00% 62,996 73,907 70,165 70,000 70,000 - 0.00% 594 603 591 900 900 - 0.00% 1,409 698 - 3,000 3,000 - 0.00% - 93,208 - - - - 0.00% 64,999 169,212 70,791 73,900 73,900 - 0.00% - - - 6,924 7,133 209 3.02% - 2,335 2,532 2,329 2,119 (210) -9.02% 2,462 2,536 2,612 2,690 2,771 81 3.01% 2,462 4,871 5,144 11,943 12,023 80 0.67% 0 71,230 185,097 85,514 95,484 95,056 (428) -0.45% 22,073 (92,284) 13,409 10,218 6 22,073 (92,284) 13,409 17,142 10,646 428 4.19% 7.133 209 3.02% 17,779 637 3.72% 115,349 137,422 45,138 58,547 75,689 17,142 29.28% $137,422 $ 45,138 $ 58,547 $ 75,689 $ 93,468 $ 17,779 23.49% 86,843 86,923 97 Fund: 740 Street Lighting Fund Revenues Account Description 2015 2016 2017 2018 Description 3610 Interest revenue 1,300 1,300 1,300 1,300 Estimated interest earnings at 1%. 1,300 1,300 1,300 1,300 3716 Penalties 500 500 500 500 Estimated late fees on street lighting charges. 500 500 500 500 3740 Street lighting charges 91,567 97,290 103,902 103,902 Estimated utility charges for street lighting. 91,567 1 97,290 1 103,902 1 103,902 Fund: '740 Department: 4416 Operations 1600 Supplies, operating 1,000 1,000 1,000 1,000 Bulbs, ballasts, covers, etc... 1,000 1,000 1,000 1,000 3210 Electricity 90,000 78,000 70,000 70,000 Estimate 90,000 78,000 70,000 70,000 4800 Insurance 900 900 900 900 Share ofproperty/liability insurance 900 900 900 900 5150 Repairs, utilities 3,000 3,000 3,000 3,000 Repairs to street and trail lighting. 3,000 3,000 3,000 3,000 8011 8021 Lease payable (principal) Lease payable (interest) 9,556 - 6,924 2,329 7,133 2,119 Energy savings program (LED trail lighting) Interest - 9,556 9,253 9,252 9900 Transfer out 2,536 2,612 2,690 2,771 Transfer to General Fund for administrative overhead costs 2,536 2,612 2,690 2,771 97,436 95,068 86,843 86,923 7.83% -2.43% -8.65% 0.09% 98 2017 Budget Summary Operating expenses Supplies, equipment 2014 2015 2016 2017 2018 Chan2efrom 2017 System Maintenance (4415): Supplies, streets Actual Actual Actual Request Re uest Dollar Percent Storm Water (Fund 745): Supplies, operating 3,297 3,478 1,296 4,725 4,725 Revenues 0100 Salaries, regular 61,400 70,056 72,358 74,708 79,041 4,333 3359 Other state grants - - 422 - - - 0.00% 3610 Investment income (charges) 85,811 18,137 18,216 15,000 16,000 1,000 6.67% 3716 Penalties & interest 1,706 1,990 1,918 1,500 1,500 - 0.00% 3718 hnpact charges - 848 1,128 - - 0.00% 3730 Surface water charges 276,652 263,254 261,021 270,000 270,000 - 0.00% 3972 Transfer from other funds - 210,000 - - - 0.00% 4.17% Total revenue 364,169 494,229 282,705 286,500 287,500 1,000 0.35% Operating expenses Supplies, equipment 1,201 1,382 3,981 2,750 2,750 0.00% System Maintenance (4415): Supplies, streets - - - - - 0.00% Personnel services Supplies, operating 3,297 3,478 1,296 4,725 4,725 0.00% 0100 Salaries, regular 61,400 70,056 72,358 74,708 79,041 4,333 5.80% 0110 Salaries, overtime 6,511 1,975 2,116 1,267 1,420 153 12.08% 0150 Salaries, part-time 5,910 5,452 3,871 2,640 2,640 - 0.00% 0300 Social security 5,553 5,629 5,807 6,014 6,357 343 5.70% 0321 PERA 4,780 5,109 5,406 5,697 6;035 338 5.93% 0322 GASB 68 Pension expens - 2,648 8,756 - - - 0.00% 0400 Group insurance 3,750 5,137 5,674 13,248 13,800 552 4.17% 0500 Workers compensation 5,608 6,652 2,495 2,851 2,599 (252) -8.84% Total personnel services 93,512 102,658 106,483 106,425 111,892 5,467 5.14% Materials & supplies 1230 Supplies, equipment 1,201 1,382 3,981 2,750 2,750 0.00% 1240 Supplies, streets - - - - - 0.00% 1600 Supplies, operating 3,297 3,478 1,296 4,725 4,725 0.00% 1700 Motor fuels 3,901 3,382 1,951 2,070 2,250 180 8.70% 2100 Books/Periodicals 39 - - - - - 0.00% 2400 Uniforms 393 577 727 470 470 0.00% 2410 Mats & towels 285 293 300 292 292 0.00% Repairs, vehicles Total materials & supplies 9,116 9,112 8,255 10,307 10,487 180 1.75% Contractual services 9900 Transfer out 82,168 82,383 82,604 7,832 8,067 3030 Other professional services 17,537 4,475 8,377 29,748 12,269 (17,479) -58.76% 3100 Telephone 645 949 736 872 872 0.00% 3610 Memberships 345 950 955 1,045 1,045 - 0.00% 3630 Training 1,534 697 500 1,695 1,695 - 0.00% 4010 Equipment rental - - 2,628 6,000 6,000 - 0.00% 4800 Insurance 4,027 5,613 32 4,000 4,000 0.00% 5120 Repairs, vehicles 192 46 1,838 1,500 1,500 - 0.00% 5150 Repairs, utilities 50,366 8,132 10,262 55,000 105,000 50,000 90.91% Total contractual services 74,646 20,862 25,328 99,860 132,381 32,521 32.57% Capital outlays 7030 Equipment - 27,920 27,920 0.00% 7050 Construction - - - 75,000 75,000 - 0.00% 7950 Depreciation 32,503 44,623 35,353 32,000 32,000 - 0.00% Total capital outlays 32,503 44,623 35,353 107,000 134,920 27,920 26.09% Miscellaneous: 9900 Transfer out 82,168 82,383 82,604 7,832 8,067 235 3.00% Total miscellaneous 82,168 82,383 82,604 7,832 8,067 235 3.00% Total System Maintenance 291,945 259,638 258,023 331,424 397,747 66,323 20.01% 224,999 285,855 0.00% 99 Fund: 745 +Storm Water Revenues' Account Description 2015 2016 2017 2018 Description 3610 Interest revenue 15,000 15,000 15,000 16,000 Estimated interest earnings at I%. 15,000 15,000 15,000 16,000 3716 Penalties - - 1,500 1,500 Estimated late payment fees. - - 1,500 1,500 3730 Utility sales 265,000 270,000 270,000 270,000 Estimated surface water charges. 265,000 1 270,000 270,0001 270,000 3972 1 Transfers - Vehicle & equip Fd 210,000 Transfer for capital equipment purchases 210,000 Fund; 745 !Department: 4415 System Maintenance 1230 Supplies, equipment < $5000 1,500 1,250 500 1,500 1,250 500 1,500 1,000 250 1,500 1,000 250 Miscellaneous equipment & parts (AEBI parts, pole camera parts) Filters, brakes, bulbs, wipers, tires, batteries, etc... Hoses & nozzles 3,250 3,250 2,750 21750 1240 Supplies, streets 300 300 - Bituminous mix 300 300 - 1600 Supplies, operating 250 2,450 175 150 150 2,500 250 3,500 175 150 150 2,500 250 2,000 175 150 150 2,000 250 2,000 175 150 150 1 2,000 Concrete Rain Garden mix, riprap, topsoil, seed and sod Concrete adjustment rings Hand tools CD's, DVDs, software upgrade for camera van Catch basin castings, pipe, approns, etc... 5,675 6,725 4,725 4,725 1700 Motor fuels 2,700 2,475 2,070 2,250 900 gallons unleaded @ $2.50 for utility truck 2,700 2,475 2,070 2,250 2100 Books/Periodicals 100 100 - Storm water books/periodicals 100 100 - 2400 Uniforms 470 1 470 470 470 Uniforms/clothing (7.3% of $4,500,.8 FTE x $175 per contract) 470 470 470 1 470 2410 Mats & towels 365 292 292 292 Share of floor mats & shop towels (7.3% of $4,000) 365 292 292 292 3030 Other professional services 7,500 2,500 1,000 100 1,106 7,500 2,500 1,000 100 1,127 25,000 2,500 1,000 100 1,148 1 7,500 2,500 1,000 100 1,169 Consulting engineers (SWPPP, comp plan, Proj Priority list) Arcview/GIS base map consulting Asset management software Fire extinguisher inspection/servcie (5 @ $20) Audit fees 3.5%(2017 - $32,800, 2018 - $33,400) 12,206 12,227 29,748 12,269 3100 Communications 635 90 782 90 782 90 782 90 Cell Phone (8.5% of $9,200) 800 Mhz radio license fee (33"/0)(5 radios @ $4.48 per month) 725 872 872 872 3610 Memberships 190 800 45 190 800 45 200 800 45 1 200 800 45 American Public Works Association (APWA)(25% of $800) Minnesota Cities Storm Water Coalition MN Safety Council (11% of $405) 1,035 1,035 1,045 1,045 3630 Training 200 55 350 500 750 270 220 100 200 55 350 500 750 270 220 100 200 55 350 500 - 270 220 100 200 55 350 500 - 270 220 100 Seminars & training sessions (Stormwater) Hearing test/R2K (1.1 FTE * $50) Safety training NPDES compliance training Tuition reimbursement Erosion & Stormwater Maint. Certification Equipment operator training Computer/webinar training 2,445 2,445 1,695 1,695 4010 Equipment rental - 6,000 6,000 6,000 Rent mini excavater for clean-outs - 6,000 6,000 6,000 4800 Insurance 2,500 1,500 2,500 1,500 2,500 1,500 2,500 1,500 Share of property/liability insurance Deductible 4,000 4,000 4,000 4,000 5120 Repairs, vehicles 1,500 1,500 1,500 1,500 Utility truck & equipment repairs 1,500 1 1,500 1,500 1,500 5150 Repairs & maint., utilities 50,000 - 44,000 - 30,000 - 25,000 30,000 50,000 25,000 Repair & maintain storm sewers, ponds, basins, and drainage issues Arden Ave Storm sewer cleaning Storm Sewer slip linning improvements 50,000 44,000 55,000 105,000 7030 Equipment > $5000 - - 2,750 12,975 - 2,750 - - 27,920 - Trailer for backhoe Salt Brine maker Electronic rain gauges for SCADA (33%)(total cost $8,250) 2,750 15,725 27,920 100 Storm Water (Fund 745): Street Sweeping (4417): Personnel services 0100 Salaries, regular 0110 Salaries, overtime 0300 Social security 0321 PERA 0400 Group insurance 0500 Workers compensation Total personnel services Materials & supplies 2017 Budget Summary 2014 2015 2016 2017 2018 Chaneefrom 2017 Actual Actual Actual Request Re uest Dollar Percent 8,695 11,787 12,028 11,713 13,128 1,415 12.08% 306 394 416 1,267 1,420 153 12.08% 637 904 921 993 1,113 120 12.08% 642 885 900 973 1,092 119 12.23% 1,220 936 952 2,304 21400 96 4.17% 929 1,623 598 683 632 (51) -7.47% 12,429 16,529 15,815 17,933 19,785 1,852 10.33% 1230 Supplies, equipment 2,129 1,131 749 2,500 2,500 0.00% 1600 Supplies, operating 2,002 2,939 18 3,500 3,500 0.00% 1700 Motor fuels 4,124 2,841 1,906 3,800 3,800 0.00% 2400 Uniforms 60 52 53 116 116 0.00% 2410 Mats & towels 44 44 46 72 72 0.00% Total materials & supplies 8,359 7,007 2,772 9,988 9,988 0.00% Contractual services 3030 Other professional services 3530 Disposal 3630 Training 5130 Repairs, equipment - 141 - 4,000 Total contractual services Capital outlays 7030 Equipment Total capital outlays Miscellaneous: 9900 Transfer out Total miscellaneous Total street sweeping Total expenditures Revenues over expenditures 4 4 6 - - 0.00% - - - 50,000 50,000 0.00% 11 6 141 280 280 0.00% - 141 - 4,000 4,000 0.00% 15 151 147 54,280 54,280 - 0.00% - - 0.00% 0.00% 16,000 71,000 32,000 32,000 32,000 0.00% 16,000 71,000 32,000 32,000 32,000 0.00% 36,803 94,687 50,734 114,201 116,053 1,852 1.62% 96,268 96,268 328,748 354,325 308,757 445,625 513,800 68,175 15.30% 35,421 139,904 (26,052) (159,125) (226,300) (67,175) 42.22% Add back: Capital outlays - - - 75,000 102,920 27,920 37.23% Change in net asssets 35,421 139,904 (26,052) (84,125) (123,380) (39,255) 46.66% Net assets, beginning year 3,055,920 3,091,341 3,167,772 3,141,720 3,057,595 (84,125) -2.68% Accounting Change GASB 68 pension (63,473) Net assets, end ofyear $3,091,341 $3,167,772 $3,141,720 $3,057,595 $2,934,215 $ (123,380) -4.04% 321,267 382,123 101 Fund: 745 Department: 4415 System Maintenance 7050 Construction > $25000 50,0002255 75,000 - 25,000 25,000 75,000 75,000 Lambert (pipe ditch)(possible matching grant from Rice Creek WSD) Mustang Drive improvements Storm water projects (Weir at Silverview Pond)(carryover to 2018) 100,000 75,000 75,000 75,000 7950 Depreciation 32,000 32,000 32,000 32,000 Estimated depreciation 32,000 32,000 32,000 32,000 9900 Transfer out 75,000 75,000 - - 7,383 7,604 7,832 8,067 Storm water system upgrades in conjunction with major roadway program General Fund 82,383 82,604 7,832 8,067 301.904 291.020 224.999 285.855 Fund: 745 Department: 4417 1 Street Cleaning 1230 Supplies, equipment < $5000 2,500 2,500 2,500 2,500 Misc. sweeper repairs - belts, pumps, hoses, filters, etc. 2,500 2,500 2,500 2,500 1600 Supplies, operating 2,300 700 100 400 2,300 700 100 400 2,300 700 100 400 2,300 700 100 400 Gutterbrooms Belts, pumps, hoses, filters, etc... for sweeper Gloves, hearing protection, etc... 2 dirt shoes 3,500 3,500 3,500 3,500 1700 Motor fuels 3,500 1,000 3,250 1,000 2,800 1,000 2,800 1,000 Diesel fuel - 1000 gallons @ $2.80/gallon Hydraulic oil - 4 changes 4,500 4,250 3,800 3,800 2400 Uniforms 116 116 116 116 Uniforms/clothing (1.8% of $4,500.2 FTE x $175 per contract) 116 116 116 116 2410 Mats & towels 90 72 72 72 Share of floor mats & shop towels (1.8% of $4,000) 90 72 72 72 3530 Disposal 5,000 50,000 50,000 50,000 Sweeping pile disposal (estimated 5 year project) 5,000 50,000 50,000 50,000 3630 Training 250 30 250 30 250 30 250 30 NPDES compliance training Maintenance Expo 280 280 280 280 5130 Repairs, equipment 4,000 4,000 4,000 4,000 Sweeper repairs 4,000 1 41000 4,000 4,000 7030 Equipment > $5000 000 - - - Street sweeper (250,000 - trade-in of 40,000) 000 - - - 9900 Transfer out to Vehicle & Equip ±71,000 32,000 32,000 32,000 Transfer to Vehicle & Equip Fund for future replacements 000 32,000 32,000 32,000 30U,986 96,718 96,268 96,268 602,890 387,738 321,267 382,123 64.67% -35.69% -17.14% 18.94% ION THIS PAGE LEFT BLANK INTENTIONALLY 103