The URL can be used to link to this page

Home My WebLink About11-13-2017 Council Work Session PacketOrono City Council Work Session Monday, November 13, 2017 Council Chambers 5:00 p.m. AGENDA 1. Open Meeting Law 2. Enterprise Funds Annual: • Budget: Part of June, All of July, August and October. • City Administrator & Police Chief Update (3 times per year for 15 minutes) Additional topics: • Variance Training Previous Work Session Topics October 23, 2017 • Wetland Buffer / Setback Clarification September 11, 2017 • Discuss and Prepare 2018 Budget August 28, 2017 • 2018 General Fund Budget MANAGING RISK: OPEN MEETING LAW, DATA PRACTICES ANDMAKING SOUND PLANNING DECISIONS Soren M. Mattick Open Meeting Law • Applies to City Council, Planning Commission Meetings and Committee Meetings Data Practices Act • Applies to all government data collected, created, stored, maintained and disseminated regardless of format or storage media. • Government data is presumed public. Gifts • Local officials may not receive gifts from interested persons. 4 Conflict of Interest • Contracts • Non -contractual situations — Quasi-judicial decisions —Self -judgment — Family connections — Business connections — Land use Municipal Authority to Plan • Municipal Land Use Planning Act —Authority to conduct and implement municipal planning Metropolitan Land Use Planning Act — Only applies to cities in the seven -county metro area — Requires adoption of a comprehensive plan prior to zoning Zoning: Important Tool to Implement Comprehensive Plan • What can a zoning ordinance regulate? — Location, height, size, etc. of buildings and structures — Percentage of a lot that can be occupied / size of open spaces — Density and distribution of population — Use of buildings and structures — Use of land • Must be uniformity within each zoning district, with respect to each class of building, structure, land use etc. Planning Decision -Making Can Be Contentious • Private property rights & expectations — Do what I want with my property —Grounded in constitution • Public rights & expectations —Maintain neighborhoods &protect property values Contentious You can't build your dream house. Contentious Ei, Your neighbor is allowed to block your view. Planning Decision -Making Can Be Confusing • Differing amounts of discretion • Making law — Legislative authority • Applying law —Quasi-judicial authority Legislative • Make rules that apply to everyone • Lots of discretion • Lots of deference by court • Accountable to voters Quasi-judicial • Apply rules that already exist • Apply to specific facts • Limited deference by court • Less oversight by vote r Pyramid of Discretion Variances A. y,, " Conditional I`0 ' It Use Permits Subdivision Applications -kl Zoning/Subdivision Ordinances Comprehensive Plan Making Law Ve k Conditional Use Permits Subdivision Applications Zoning/Subdivision Ordinances Comprehensive Plan Making Law • Comprehensive Plan • Subdivision Ordinance • Zoning Ordinance aofW%A"� y� �: Applying Law a Review Variances Conditional Use permits Subdivision Applications Ike ZoningiSubdivi on Ordinances , * Comprehensive Plan" Applying Law Quasi-judicial decisionmaking Conditional Uses Variances Creating the record You be the quasi -judge — Rules are already written in ordinance — Apply them fairly — Open process — Timely process Applying Law to Facts • Law is established in statute or ordinance • Applicant presents a set of facts • Role of city is to — (1) find facts, and — (2) apply law to facts Public Contact • Avoid ex parte communications • Avoid statements that indicate bias Conditional Uses • Uses that are generally allowed in particular district • But only if they meet standards because of special concerns • As set forth in the ordinance both general and specific standards Conditional Use Permits • Conditional uses are allowed by permit • Permit is approved/denied after public hearing • Public body has limited discretion to approve/deny • Reasonable conditions may be attached based upon factual evidence contained in public record • There must be a connection between the problem and condition • No time limit on CUP Conditional Uses • CUPs are sometimes misunderstood — If proposed use meets standards, council must grant CUP Don't list as conditional use if belief is that use is inappropriate in district Interim Uses • A temporary use of property until a particular date, until the occurrence of a particular event, or until zoning regulations no longer permit it • Should be provided for in ordinance • Landowner enters into agreement • Passed in 1989, interim use permits remain an underutilized zoning tool Variances • Exception to literal application of zoning ordinance • Allow a structure to be built or altered in a manner not allowed under ordinance — Deviations from required setbacks, frontage requirements, height limitations, lot size restrictions, density regulations • Use variances are generally prohibited Variance Standard 1. Variance is in harmony with general intent and purpose of zoning ordinance 2. Variance is consistent with the comprehensive plan 3. "Practical difficulties" with complying with the zoning ordinance a. Propose to use property in a reasonable manner b. Plight of landowner due to circumstances that are: i. unique to the property ii. not created by the landowner c. Variance will not alter the essential character of the locality 4. Economic problems alone are not enough Denying a Variance • Broad discretion, but must be legally sufficient reason • Cannot be "arbitrary and carpricious" • Written findings • Must not deny if landowner cannot put the land to any beneficial use • Applicant bears to burden of proving practical difficulties • Be consistent and follow your code Creating a record • City must create record to support decision • If decision is challenged, courts will review the public record • Record should demonstrate —city exercised appropriate level of discretion —applied relevant standards in a reasonable fashion Public Hearings • A chance to explain and educate • Develop a record • Ask questions • Respect citizens — Calm and reassure — Explain procedures — Pay attention —Avoid hostile confrontations Not a Sporting Event • Control the hearing — No cheering — No applause • Immediately correct any inappropriate statements Public Hearings • Statutorily required public hearings: —Adopt Zoning Ordinance —Amend Zoning Ordinance —Approve Preliminary Plats —CUP's — IUP's • Follow statutory notice requirements Public Hearing Procedure 1. Staff presentation 2. Applicant's presentation 3. Statements from the public 4. Conclude the public hearing 5. Commission/Council action Neighborhood Opposition • Can't be sole basis for decision • Distinguish between quantity and quality e.g., well supported testimony vs. unsupported emotional opposition • Can have more impact when making law, than when applying law Timely Decision -Making *,A 60 Day Rule • Approve/deny written request related to zoning within 60 days • Clock does not start if application is incomplete provided applicant is notified in writing within 15 days of submittal • City can grant itself one 60 day extension • Applicant may agree to extend the 60 days in writing • State reasons for denial in writing Written Statement • Adopt a single written statement whenever a city makes aquasi-judicial decision • "Findings of fact and conclusions of law" — identify relevant legal criteria • statutory standards or code provisions — explain relevant facts relating to application —then apply legal criteria to facts found Appeals Quasi-judicial v. Real -judicial Arbitrary and Capricious • Deferential Standard • Review is on the record —Unless the record was incomplete • City decision will be upheld if it has any rational basis Stricter Review • First Amendment — Religion — Speech • Sign Regulations • Adult Use Ordinances • Discrimination of protected class — Housing Statutory Rights • Manufactured Homes & Home Parks • State Licensed Residential Facilities • Feedlots • Telecom Towers • Solar Energy Systems • Large Wind Energy Systems • Small Wireless Facilities Questions ? Contact us at: SMattick@ck-law.com TO: Mayor Walsh and Council Members FROM: Ron Olson, Finance Director DATE: November 13, 2017 SUBJECT: 2018 Enterprise Fund Budgets Attachments: 1. Enterprise Funds Summary 2. Enterprise Fund Line Items 3. CIP Pages The enterprise fund budgets consist of the Water, Sewer, Stormwater, Recycling and Cable TV Funds. Unlike the General Fund, the accounting in the enterprise funds is similar to the accounting practices of private enterprise. The goal of the enterprise funds is to operate independent of tax support. 2012 was the first year that a formal budget was adopted for the enterprise funds. Prior to 2010, the enterprise funds did not attempt to cover depreciation expenses. Beginning with the completion of the 2009 rate study, the suggested rate increases were designed to cover depreciation. The rate study was reviewed in 2014 and the suggested rate increases are used to set the annual revenue budget. Staff will be updating thee rate study in 2018. Water Fund The water fund has historically been operating at a loss. Because depreciation is a non-cash expenditure, the fund has had a positive operating cash flow since 2009. In most years, the operating loss has been covered by the revenue received from antenna leases on the water towers. Due to consolidations in the cellular industry and changing technologies, the lease revenue is not guaranteed to continue indefinitely. For the last four years, water rates have been increased by 11% annually. The 2018 budget is being presented with a 5% rate increase with future increases projected to be in the 3% range. As presented, the operating budget for 2018 will break even. The expenditure budget is increasing by $25,310 (2.1%). $9,000 of the increase is in maintenance supplies and maintenance. As a result of recently completed water system improvements, the depreciation expense is also increasing by $10,000. The operating transfer of $55,000 is to the debt service fund supporting the Casco Point Bonds ($55,000). The non-operating interest expense is for the interest on the 2014 Water Bonds. A total of $428,000 of capital expenditures as identified in the 2018 draft CIP and include a Scada Upgrade for the North Wellhouse ($61,200), north tower maintenance ($62,500), OCB Road Main Replacement ($210,000), and well #3 inspection and maintenance ($20,000). The Water Fund's current cash balance is $977,699.82. Sewer Fund In recent years, the sewer fund has mostly operated at a loss. Non-operating revenues however, have consistently offset the operating losses. This has resulted in a positive operating cash flow for the fund. The 2018 budget is being presented with a rate increase of 4%. The single largest expense for the sewer fund is the Met Council disposal charges. The past two years have seen increases in the amounts of $37,410 (9.5%) and 41,277 (9.6%) respectively. As has been discussed with the Council during previous budget processes, heavy rains and high water tables increase the flow through the MCES lift stations and increase our disposal charges. The total operating expenditure budget is increasing by $78,881 (5.8%) The major increases are the previously mentioned MCES charges ($41,277), repairs and maintenance for sewer lines ($13,220) and the non-cash expense of depreciation ($15,000). The revenues are calculated with a 4% increase in the sewer rates as called for in the 2014 rate study. The operating transfer is to cover the sewer improvements that were part of the Casco Point project and will continue for another six years. Upcoming capital expenditures can be covered by the fund's current cash balances. Projects identified in the CIP for 2018 include: Annual sewer rehabilitation ($273,182), Sewer televising ($47,272), additional generators ($75,000), lift station updates ($112,000); lift station monitoring improvements ($26,000), sewer main replacements ($353,740), and a generator rehabilitation ($10,000), for a total of $972,194. The current cash balance for the fund is $2,800,000. Ctarm Water The Stormwater Fund is for the most part project based. Operating expenditures are mainly limited to engineering associated with NPDES, SWPPP and other state and federal requirements. Public Works time and materials spent on culvert cleaning/replacement are also charged to this fund. The purpose of this fund is to collect money for the larger Stormwater projects that will be required in the future. The revenue in the attached budget is calculated with a 10% increase in the rates. This is the annual increase required to avoid future special assessments for stormwater projects. Potential CIP projects in 2018 include: Long Lake Ravine Stabilization (SWMP 7); System improvements performed with road projects; TMDL Updates. The capital expenditures total $308,080. The funds current cash balance is $1,700,000. Recycling The recycling fund was newly created in 2013. Its major expenditure line is for contracted recycling charges. The current contract with Waste Management is capped at a 2.8% increase. In November of 2016 and continuing through 2017, the City has been receiving a Recycling Materials Offset. In previous years, this offset had not been paid because there was no market for the recycled materials. With the return of the offset, the budget has been prepared with no increase in recycling rates. The full time wages that are charged to the fund represent 10% of the City Clerks wages. The current cash balance is $49,673. Cable The Cable fund was new for the 2015 budget. The projected revenues are based on current subscriber information and rates. The line item for Internet/Other communications covers the costs associated with streaming and online access of council meetings. It has been increased to pay for the increased cost of our fiber internet connection. Revenue for the fund is in the from franchise fees that are set by the City's franchise agreement with Mediacom. The 2017 CIP includes updates to the City Council presentation equipment. The current cash balance of the fund is $106,660. Water Operating Fund 2012 Actual Operating Revenue Sales and User Fees 498,953 Operating Expenses Personnel Services 151,932 Professional Services 15,388 Operating and Maint Supplies 31,978 Utilities 65,614 Depreciation 90,464 Maintenance and Repairs 41,744 Admin Charges - General Fund 16,000 Insurance 10,000 Other Expenses 44,778 Total Operating Expenses 467,898 Operating Income (Loss) 31,055 Non -Operating Revenue (Expenses) 185,738 Connection Fee 233 Water Tower Rental 107,386 Special Assessments 9,123 Investment Earnings 13,264 Interest Expense (1,900) Misc Revenue 6,173 Total Non -Operating Revenue 134,279 Income (Loss) Before Transfers/CIP 165,334 Operating Transfers (55,000) Enterprise Budget - Summary 2013 2014 2015 2016 2017 2018 Actual Actual Actual Actual Budget Budget 439,616 482,816 503,945 524,806 605,000 635,000 148,460 150,591 167,221 199,006 182,138 185,738 49,863 61,098 33,199 46,043 23,000 24,900 33,483 34,064 21,383 34,071 43,900 43,900 73,037 68,342 69,161 63,690 74,100 74,100 94,451 92,645 98,516 126,234 120,000 130,000 64,521 90,725 85,709 78,965 95,800 99,800 16,000 16,000 15,923 16,000 16,000 16,000 9,990 7,050 10,280 10,280 10,280 10,000 34,951 32,952 41,988 49,964 44,410 50,500 524,756 553,467 543,380 624,253 609,628 634,938 (85,140) (70,651) (39,435) (99,447) (4,628) 62 - 8,460 - 60,500 85,729 90,016 92,916 95,549 105,000 100,000 7,979 6,285 - - - - 5,822 37,455 18,632 14,264 10,000 15,000 (899) (23,977) (33,940) - - - 414 113 76 11,341 - - 99,045 118,352 77,684 181,654 115,000 115,000 13,905 47,701 38,249 82,207 110,372 115,062 (55,000) (55,000) (158,000) (158,000) (55,000) (55,000) Enterprise Budget Summary Sewer Operating Fund 2012 2013 2014 2015 2016 2017 2018 Acutal Actual Actual Actual Actual Budget Budget Operating Revenue Sales and User Fees 1,107,357 1,142,534 1,204,554 1,284,521 1,411,424 1,319,240 1,435,000 Operating Expenses Personnel Services 248,776 258,097 259,881 276,127 342,750 309,360 315,394 Professional Services 16,869 30,027 14,175 19,116 31,495 25,500 25,500 Operating and Maint Supplies 9,448 10,779 13,532 11,663 3,465 25,900 25,900 Utilities 31,398 36,322 39,505 30,539 31,273 40,000 35,000 Depreciation 256,217 261,217 270,819 304,437 311,135 305,000 320,000 Maintenance and Repairs 68,275 90,801 86,838 98,222 187,854 112,050 127,270 Admin Charges - General Fund 32,000 32,000 32,000 32,000 32,000 32,000 32,000 Insurance 10,000 10,000 10,000 18,930 18,930 18,930 18,930 Met Council Env Services 424,202 359,863 398,991 487,307 394,530 431,940 473,217 Other Expenses 58,886 58,378 55,418 49,930 47,846 69,150 75,500 Total Operating Expenses 1,156,071 1,147,484 1,181,159 1,328,271 1,401,278 1,369,830 1,448,711 Operating Income (Loss) (48,714) (4,950) 23,395 (43,750) 10,146 (50,590) (13,711) Non -Operating Revenue (Expenses) Connection Fee - - 21,253 39,705 122,120 - - Special Assessments 46,181 30,402 143,070 - - - - Investment Earnings 36,749 (33,405) 55,178 30,984 28,211 35,000 35,000 Interest Expense - - - - - - - Misc Revenue 34,471 97,074 39,138 7,130 3,662 20,000 20,000 Total Non -Operating Revenue 117,401 94,071 258,639 77,819 153,993 55,000 55,000 Income (Loss) Before Transfers\CIP 68,687 89,121 282,034 34,069 164,139 4,410 41,289 Operating Transfers (111,000) (111,000) (111,300) (113,575) (113,575) (110,000) (110,000) Enterprise Budget Summary Storm Water Operating Fund Non -Operating Revenue (Expenses) Trunk Charges 46,519 107,860 State Grant - - Investment Earnings 8,500 (11,254) Loss on Sale of Assets - - Misc Rev 2,500 - Total Non -Operating Revenue 57,519 90,874 275,213 273,927 - - 20,553 14,154 13,309 15,000 15,000 - - (59,110) - - - - 3,638 - - 96,606 111,427 289,367 231,764 15,000 15,000 Income (Loss) Before Transfers\CIP 150,289 160,158 159,381 381,207 330,871 105,061 71,036 2012 2013 2014 2015 2016 2017 2018 Actual Actual Actual Actual Actual Budget Budget Operating Revenue Sales and User Fees 196,000 209,459 234,673 255,587 265,110 255,600 255,600 Operating Expenses Personnel Services 45,000 72,298 61,030 54,743 42,209 47,369 49,094 Professional Services 10,000 13,646 25,579 38,746 18,220 19,500 19,500 Operating and Maint Supplies 1,250 1,538 3,032 1,569 1,532 1,000 2,300 Utilities - - - - - - - Depreciation 20,000 27,885 32,092 32,465 35,817 31,000 38,000 Maintanence and Repairs 8,780 11,631 47,003 19,095 44,677 43,000 67,000 Admin Charges - General Fund 16,000 16,000 16,000 16,000 16,000 16,000 16,000 Insurance 1,500 1,500 1,125 720 720 1,970 1,970 Other Expenses 700 1,409 858 409 6,828 5,700 5,700 Total Operating Expenses 103,230 145,907 186,719 163,747 166,003 165,539 199,564 Operating Income (Loss) 92,770 63,552 47,954 91,840 99,107 90,061 56,036 Non -Operating Revenue (Expenses) Trunk Charges 46,519 107,860 State Grant - - Investment Earnings 8,500 (11,254) Loss on Sale of Assets - - Misc Rev 2,500 - Total Non -Operating Revenue 57,519 90,874 275,213 273,927 - - 20,553 14,154 13,309 15,000 15,000 - - (59,110) - - - - 3,638 - - 96,606 111,427 289,367 231,764 15,000 15,000 Income (Loss) Before Transfers\CIP 150,289 160,158 159,381 381,207 330,871 105,061 71,036 Recycling Operating Fund 2013 2014 Actual Actual Operating Revenue Sales and User Fees 86,632 88,708 Operating Expenses Actual Actual Personnel Services 9,992 9,177 Professional Services 99,457 98,281 Operating and Maint Supplies - - Utilities - - Depreciation - - Maintanence and Repairs 1,500 - Admin Charges - General Fund - 1,500 Insurance - - Other Expenses 3,888 6,025 Total Operating Expenses 114,837 114,983 Operating Income (Loss) (28,205) (26,275) Non -Operating Revenue (Expenses) 15,074 5,510 County Grant 24,280 24,793 Investment Earnings (819) (3) Misc Rev (RMO and Penalty) 8,589 2,957 Total Non -Operating Revenue 32,050 27,747 Income (Loss) Before Transfers 3,845 1,472 Enterprise Budget Summary 2015 2016 2017 2018 Actual Actual Budget Budget 96,660 104,500 107,902 107,600 5,374 6,490 6,830 6,980 104,674 110,500 110,500 115,000 1,532 1,000 1,000 1,500 2,500 2,500 2,500 2,500 - 500 500 500 2,526 7,000 3,670 3,670 116,606 127,990 125,000 130,150 (19,946) (23,490) (17,098) (22,550) 30,190 25,000 25,000 25,000 41 - - 4,789 4,000 4,000 10,000 35,020 29,000 29,000 35,000 15,074 5,510 11,902 12,450 Cable TV Fund 2013 Actual Operating Revenue Peg Fees Franchise Fees (Q1 $18,942; Q2 $19,488) Operating Expenses Personnel Services Professional Services Operating and Maint Supplies Utilities Depreciation Maintanence and Repairs Admin Charges - General Fund Insurance Other Expenses _ Total Operating Expenses Operating Income (Loss) Non -Operating Revenue (Expenses) Investment Earnings Misc Rev (Includes Penalty) _ Total Non -Operating Revenue Income (Loss) Before Transfers\CIP Enterprise Budget Summary 2014 2015 2016 2017 2018 Actual Actual Actual Budget Budget 18,402 - - - - 76,493 77,674 77,510 76,000 77,000 50 11,831 8,899 13,660 30,415 8,393 3,385 1,465 4,500 2,000 247 47 - - - - 4,314 4,600 4,600 4,600 3,985 - 500 500 2,000 - 2,500 2,500 2,500 2,500 - 9,099 15,000 15,000 20,000 _ 12,675 31,176 32,964 40,760 61,515 - 63,818 46,498 44,546 35,240 15,485 55 550 1,000 1,000 1,000 55 550 1,000 1,000 1,000 - 63,873 47,048 45,546 36,240 16,485 City of Orono 2018 Line Item Budget Water 49400 Enterprise Budget Line Item Dollar % 2015 2016 2017 Y -T -D 2018 Increase Increase Actual Actual Budget Sep 30, 2017 Draft Budget Decrease Decrease 99,843 Personal Services 601-49400-101 101 Full -Time Employees Regular 601-49400-102 102 Full -Time Employees Overtime 601-49400-103 103 Part -Time Employees 601-49400-121 121 PERA 601-49400-122 122 FICA 601-49400-135 135 City Benefit Contribution 601-49400-143 143 OPEB Expense 601-49400-151 151 Worker's Comp Insurance Prem City of Orono 2018 Line Item Budget Water 49400 Enterprise Budget Line Item Dollar % 2015 2016 2017 Y -T -D 2018 Increase Increase Actual Actual Budget Sep 30, 2017 Draft Budget Decrease Decrease 99,843 116,806 114,240 82,945 115,441 1,201 1.05% 12,418 9,971 10,000 10,528 10,000 0 0.00% 10,684 9,749 11,260 8,678 11,594 334 2.97% 9,168 9,975 10,160 7,587 10,277 117 1.15% 9,778 10,209 10,370 7,644 10,483 113 1.09% 14,877 15,130 21,680 17,026 21,676 (4) -0.02% 0 0 0 0 11800 1,800 N/A 6,647 3,670 4,440 3,330 4,466 26 0.59% Total Personal Services 163,416 175,510 182,150 137,738 185,737 3,587 1.97% Total Supplies & Maintenance 108,601 130,866 139,700 97,040 148,700 9,000 6.44% Page 1 Supplies & Maintenance 601-49400-201 201 Office supplies 299 0 200 0 200 0 0.00% 601-49400-212 212 Motor Fuels & Lubricants 3,894 0 4,500 0 4,500 0 0.00% 601-49400-216 216 Chemicals and Chem Products 15,577 32,417 35,000 26,548 35,000 0 0.00% 601-49400-221 221 Equipment Parts & Accessories 226 68 0 272 0 0 N/A 601-49400-222 222 Vehicle Equipment & Parts 0 0 1,000 23 1,000 0 0.00% 601-49400-223 223 Bldg/Grounds Maint. Supplies 129 336 200 1,233 200 0 0.00% 601-49400-226 226 Clothing & personal equipment 872 699 1,000 296 1,000 0 0.00% 601-49400-227 227 Utility System Maint. Supplies 34,509 15,283 35,000 17,380 35,000 0 0.00% 601-49400-240 240 Small Tools and Minor Equip 2,473 2,049 2,000 398 2,500 500 25.00% 601-49400-401 401 Repairs/Maint-Office Equip 1,532 0 2,300 0 2,300 0 0.00% 601-49400-402 402 Repairs/Maint-Auto Equip 0 688 0 1,271 0 0 N/A 601-49400-403 403 Repairs/Maint-Misc. Equip 6,487 7,030 3,500 300 7,000 3,500 100.00% 601-49400-404 404 Repairs/Maint-Bldgs/Grounds 3,477 4,080 0 16,727 4,000 4,000 N/A 601-49400-405 405 Repairs/Maint-Watermains/plant 36,876 61,534 51,000 29,620 51,000 0 0.00% 601-49400-416 416 Software Licensing 2,250 6,682 4,000 2,972 5,000 1,000 25.00% Total Supplies & Maintenance 108,601 130,866 139,700 97,040 148,700 9,000 6.44% Page 1 City of Orono 2018 Line Item Budget Water cont. 49400 Enterprise Budget Line Item Total Insurances 10,280 10,280 10,280 7,710 10,280 0 0.00% Page 2 Insurances Dollar % 601-49400-361 361 General Liability Ins 2015 2016 2017 Y -T -D 2018 Increase Increase 601-49400-362 362 Umbrella Liability Ins Actual Actual Budget Sep 30, 2017 Draft Budget Decrease Decrease 601-49400-366 Professional Services 3,800 3,800 3,800 21850 3,800 0 0.00% 601-49400-301 301 Auditing and Acct'g Services 4,000 5,775 4,500 0 5,000 500 11.11% 601-49400-304 304 Engineering -Consulting 25,915 22,801 15,000 5,471 15,000 0 0.00% 601-49400-307 307 Legal -Consulting 977 21891 1,500 2,430 2,000 500 33.33% 601-49400-312 312 Bank Fees 2,307 2,473 1,200 941 2,400 1,200 100.00% 601-49400-319 319 Professional Services 0 0 500 2,410 500 0 0.00% Total Professional Services 33,198 33,939 22,700 11,251 24,900 2,200 9.69% Total Insurances 10,280 10,280 10,280 7,710 10,280 0 0.00% Page 2 Insurances 601-49400-361 361 General Liability Ins 4,000 4,000 4,000 3,000 4,000 0 0.00% 601-49400-362 362 Umbrella Liability Ins 1,800 1,800 1,800 1,350 1,800 0 0.00% 601-49400-366 366 Property Insurance 3,800 3,800 3,800 21850 3,800 0 0.00% 601-49400-367 367 Equipment Floaters Ins 380 380 380 285 380 0 0.00% 601-49400-368 368 Automotive Insurance 300 300 300 225 300 0 0.00% Total Insurances 10,280 10,280 10,280 7,710 10,280 0 0.00% Page 2 City of Orono 2018 Line Item Budget Water cont. 49400 Enterprise Budget Line Item Total Operating Expenses 532,465 600,752 609,630 337,406 635,217 25,587 4.20% Non -Operating Expenses Dollar % 0 (1,486) 2015 2016 2017 Y -T -D 2018 Increase Increase 0 0 Actual Actual Budget Sep 30, 2017 Draft Budget Decrease Decrease 55,000 Other Expenses 55,000 0 0.00% Total Non -Operating Expenses 158,000 53,514 55,000 601-49400-321 321 Telephone 2,232 2,046 3,000 11820 2,500 (500) -16.67% 601-49400-322 322 Postage 304 358 350 581 350 0 0.00% 601-49400-340 340 General Advertising 0 0 0 0 0 0 N/A 601-49400-352 352 Printing & Publishing 0 0 1,000 0 1,000 0 0.00% 601-49400-381 381 Gas & Electric 66,119 60,251 73,000 51,224 73,000 0 0.00% 601-49400-382 382 Water Utilities 810 1,393 1,100 0 1,100 0 0.00% 601-49400-387 387 Intergovernmental Services 29,127 25,171 30,000 10,738 30,000 0 0.00% 601-49400-409 409 Depreciation & Amortization 92,630 133,177 120,000 0 130,000 10,000 8.33% 601-49400-415 415 Other Equipment Rentals 0 0 200 0 0 (200) -100.00% 601-49400-433 433 Memberships 437 596 650 455 650 0 0.00% 601-49400-437 437 Training & Development 2,319 2,878 3,500 3,010 3,500 0 0.00% 601-49400-438 438 Administrative Charge 15,923 16,000 16,000 12,000 16,000 0 0.00% 601-49400-441 441 Licenses & Taxes 3,554 3,011 2,000 11455 3,500 1,500 75.00% 601-49400-489 489 Other Miscellaneous Charges 3,515 5,275 4,000 2,384 4,000 0 0.00% Total Other Expenses 216,969 250,157 254,800 83,666 265,600 10,800 4.24% Total Operating Expenses 532,465 600,752 609,630 337,406 635,217 25,587 4.20% Non -Operating Expenses 601-49400-612 612 Other Long -Term Oblig Interest 0 (1,486) 0 0 0 0 N/A 601-49400-613 613 Other Interest Expense 0 0 0 0 0 0 N/A 601-49400-720 720 Operating Transfers 158,000 55,000 55,000 0 55,000 0 0.00% Total Non -Operating Expenses 158,000 53,514 55,000 0 55,000 0 0.00% Total Water Fund 690,465 654,266 664,630 337,406 690,217 25,587 3.85% Page 3 Total Personal Services City of Orono 2018 Line Item Budget Sewer 49450 Enterprise Budget Line Item Dollar % 2015 2016 2017 Y -T -D 2018 Increase Increase Actual Actual Budget Sep 30, 2017 Draft Budget Decrease Decrease 169,084 Personal Services 602-49450-101 101 Full -Time Employees Regular 602-49450-102 102 Full -Time Employees Overtime 602-49450-103 103 Part -Time Employees 602-49450-104 104 Temporary Employees Regular 602-49450-121 121 PERA 602-49450-122 122 FICA 602-49450-135 135 City Benefit Contribution 602-49450-143 143 OPEB Expense 602-49450-151 151 Worker's Comp Insurance Prem Total Personal Services City of Orono 2018 Line Item Budget Sewer 49450 Enterprise Budget Line Item Dollar % 2015 2016 2017 Y -T -D 2018 Increase Increase Actual Actual Budget Sep 30, 2017 Draft Budget Decrease Decrease 169,084 190,246 190,220 146,297 192,415 2,195 1.15% 16,852 18,766 12,000 15,405 12,000 0 0.00% 10,684 9,749 11,260 8,678 11,594 334 2.97% 0 0 10,000 0 10,000 0 0.00% 14,496 16,018 16,010 12,778 16,200 190 1.19% 14,524 16,053 17,100 12,786 17,290 190 1.11% 31,993 34,873 36,580 28,096 37,379 799 2.18% 0 0 0 0 21200 2,200 N/A 9,805 12,210 16,190 12,143 16,316 126 0.78% 267,439 297,915 309,360 236,184 315,394 6,034 1.95% Page 4 Supplies & Maintenance 602-49450-201 201 Office supplies 142 387 400 0 400 0 0.00% 602-49450-212 212 Motor Fuels & Lubricants 9,066 0 9,000 0 9,000 0 0.00% 602-49450-221 221 Equipment Parts & Accessories 48 1,946 1,500 410 1,500 0 0.00% 602-49450-222 222 Vehicle Equipment & Parts 494 328 2,500 0 2,500 0 0.00% 602-49450-223 223 Bldg/Grounds Maint. Supplies 0 424 0 3,295 0 0 N/A 602-49450-226 226 Clothing & personal equipment 886 867 1,000 2,519 1,000 0 0.00% 602-49450-227 227 Utility System Maint. Supplies 3,586 1,457 9,000 31936 9,000 0 0.00% 602-49450-240 240 Small Tools and Minor Equip 2,299 2,024 2,500 366 2,500 0 0.00% 602-49450-401 401 Repairs/Maint-Office Equip 2,342 2,392 3,050 51,056 3,050 0 0.00% 602-49450-402 402 Repairs/Maint-Auto Equip 225 5,356 1,500 5,545 3,000 1,500 100.00% 602-49450-403 403 Repairs/Maint-Mise. Equip 5,031 5,119 4,500 1,629 5,000 500 11.11% 602-49450-404 404 Repairs/Maint-Bldgs/Grounds 5,467 0 1,500 0 1,500 0 0.00% 602-49450-406 406 Repairs/Maint-Swr lines/lifts 78,451 151,267 76,500 79,962 89,720 13,220 17.28% 602-49450-443 443 Repairs/Maint-I&I Reduction 280 17,616 25,000 33,425 25,000 0 0.00% Total Supplies & Maintenance 108,316 189,183 137,950 182,142 153,170 15,220 11.03% Page 4 City of Orono Enterprise Budget Line Item 2018 Line Item Budget Sewer cont. 49450 Dollar % 2015 2016 2017 Y -T -D 2018 Increase Increase Actual Actual Budget Sep 30, 2017 Draft Budget Decrease Decrease Page 5 Professional Services 602-49450-301 301 Auditing and Acct'g Services 6,000 7,000 6,500 0 6,500 0 0.00% 602-49450-304 304 Engineering -Consulting 10,543 17,498 15,000 51080 15,000 0 0.00% 602-49450-307 307 Legal -Consulting 266 3,689 1,000 0 1,000 0 0.00% 602-49450-312 312 Bank Fees 2,307 3,308 3,000 11904 3,000 0 0.00% 602-49450-319 319 Professional Services 0 0 0 288 0 0 N/A Total Professional Services 19,115 31,494 25,500 7,272 25,500 0 0.00% Page 5 Insurances 602-49450-361 361 General Liability Ins 8,000 8,000 8,000 6,000 8,000 0 0.00% 602-49450-362 362 Umbrella Liability Ins 3,600 3,600 3,600 2,700 3,600 0 0.00% 602-49450-366 366 Property Insurance 3,200 3,200 3,200 2,400 3,200 0 0.00% 602-49450-367 367 Equipment Floaters Ins 1,230 1,230 1,230 923 1,230 0 0.00% 602-49450-368 368 Automotive Insurance 2,900 2,900 2,900 2,175 2,900 0 0.00% Total Insurances 18,930 18,930 18,930 14,198 18,930 0 0.00% Page 5 City of Orono 2018 Line Item Budget Sewer cont. 49450 Enterprise Budget Line Item Dollar % 2015 2016 2017 Y -T -D 2018 Increase Increase Actual Actual Budget Sep 30, 2017 Draft Budget Decrease Decrease 2,888 Other Expenses 602-49450-321 321 Telephone 602-49450-322 322 Postage 602-49450-331 331 Travel Expenses 602-49450-340 340 General Advertising 602-49450-352 352 Printing & Publishing 602-49450-381 381 Gas & Electric 602-49450-382 382 Water Utilities 602-49450-383 383 MCES-Sewer 602-49450-387 387 Intergovernmental Services 602-49450-409 409 Depreciation & Amortization 602-49450-415 415 Other Equipment Rentals 602-49450-416 416 Software Licensing 602-49450-433 433 Memberships 602-49450-437 437 Training & Development 602-49450-438 438 Administrative Charge 602-49450-439 439 Meeting Expenses 602-49450-440 440 Special Equipment Replacement 602-49450-441 441 Licenses & Taxes 602-49450-489 489 Other Miscellaneous Charges City of Orono 2018 Line Item Budget Sewer cont. 49450 Enterprise Budget Line Item Dollar % 2015 2016 2017 Y -T -D 2018 Increase Increase Actual Actual Budget Sep 30, 2017 Draft Budget Decrease Decrease 2,888 2,953 5,000 3,302 5,000 0 0.00% 1,569 1,787 1,500 1,200 1,600 100 6.67% 0 0 100 0 100 0 0.00% 0 0 300 0 300 0 0.00% 0 0 0 704 0 0 N/A 27,651 28,320 40,000 10,871 35,000 (5,000) -12.50% 0 0 0 0 0 0 N/A 487,307 395,680 431,940 323,956 473,217 41,277 9.56% 44,445 36,005 45,000 21,412 45,000 0 0.00% 175 311,135 305,000 0 320,000 15,000 4.92% 0 347 2,500 0 2,500 0 0.00% 700 7,198 4,500 3,457 10,752 6,252 138.93% 0 155 1,250 63 1,250 0 0.00% 2,455 4,679 4,500 1,470 4,500 0 0.00% 32,000 32,000 32,000 24,000 32,000 0 0.00% 0 0 0 0 0 0 N/A 0 0 0 0 0 0 N/A 392 417 1,000 23 1,000 0 0.00% 3,484 2,923 3,500 2,130 3,500 0 0.00% Total Other Expenses 603,065 823,599 878,090 392,587 935,719 57,629 6.56% Total Operating Expenses 1,016,864 1,361,122 1,369,830 832,382 1,448,713 78,883 5.76% Page 6 602-49450-613 602-49450-720 City of Orono 2018 Line Item Budget Sewer cont. 49450 Enterprise Budget Line Item Dollar % 2015 2016 2017 Y -T -D 2018 Increase Increase Actual Actual Budget Sep 30, 2017 Draft Budget Decrease Decrease Non -Operating Expenses 613 Other Interest Expense 0 0 0 720 Operating Transfers 113,575 100,000 110,000 Total Non -Operating Expenses 113,575 100,000 110,000 Total Sewer Fund 1,130,439 1,461,122 1,479,830 0 0 0 N/A 0 110,000 0 0.00% 0 110,000 832,382 1,558,713 0 0.00% 78,883 5.33% Page 7 City of Orono 2018 Line Item Budget Recycling 49500 Enterprise Budget Line Item Page 8 Supplies & Maintenance Dollar % 603-49500-221 221 Equipment Parts & Accessories 2015 2016 2017 Y -T -D 2018 Increase Increase 603-49500-401 401 Repairs/Maint-Office Equip Actual Actual Budget Sep 30, 2017 Draft Budget Decrease Decrease Personal Services 1,532 0 1,000 0 1,500 500 50.00% 603-49500-101 101 Full -Time Employees Regular 4,650 3,488 5,900 0 6,030 130 2.20% 603-49500-102 102 Full -Time Employees Overtime 0 0 0 0 0 0 N/A 603-49500-103 103 Part -Time Employees 0 0 0 0 0 0 N/A 603-49500-104 104 Temporary Employees Regular 0 0 0 0 0 0 N/A 603-49500-121 121 PERA 336 252 440 0 450 10 2.27% 603-49500-122 122 FICA 356 267 450 0 460 10 2.22% 603-49500-135 135 City Benefit Contribution 0 0 0 0 0 0 N/A 603-49500-151 151 Worker's Comp Insurance Prem 32 30 40 0 40 0 0.00% Total Personal Services 5,374 4,037 6,830 0 6,980 150 2.20% Page 8 Supplies & Maintenance 603-49500-221 221 Equipment Parts & Accessories 0 1,695 0 0 0 0 N/A 603-49500-401 401 Repairs/Maint-Office Equip 1,532 0 1,000 0 1,500 500 50.00% Total Supplies & Maintenance 1,532 0 1,000 0 1,500 500 50.00% Professional Services 603-49500-316 316 Contract Recycling Pickup 104,674 101,942 110,500 0 115,000 4,500 4.07% 603-49500-319 319 Professional Services 0 1,301 0 0 0 0 N/A Total Professional Services 104,674 103,243 110,500 0 115,000 4,500 4.07% Page 8 City of Orono 2018 Line Item Budget Recycling cont. 49500 Enterprise Budget Line Item Page 9 Dollar % 2015 2016 2017 Y -T -D 2018 Increase Increase Actual Actual Budget Sep 30, 2017 Draft Budget Decrease Decrease Other Expenses 603-49500-352 352 Printing & Publishing 0 0 0 0 0 0 N/A 603-49500-361 361 General Liability Ins 0 125 500 0 500 0 0.00% 603-49500-438 438 Administrative Charge 2,500 625 2,500 0 2,500 0 0.00% 603-49500-442 442 Spring, FaII,X-mas Cleanup 2,526 0 3,670 1,590 3,670 0 0.00% 603-49500-444 444 Organics Recycling 0 0 0 0 0 0 N/A Total Other Expenses 5,026 750 6,670 1,590 6,670 0 0.00% Recycling Total 116,606 108,030 125,000 1,590 130,150 5,150 4.12% Page 9 City of Orono 2018 Line Item Budget Storm Water 49910 Enterprise Budget Line Item Page 10 Dollar 2015 2016 2017 Y -T -D 2018 Increase Increase Actual Actual Budget Sep 30, 2017 Draft Budget Decrease Decrease Personal Services 651-49910-101 101 Full -Time Employees Regular 43,775 35,017 35,670 26,373 36,562 892 2.50% 651-49910-102 102 Full -Time Employees Overtime 453 1,115 0 96 0 0 N/A 651-49910-121 121 PERA 3,137 2,534 2,680 1,985 2,747 67 2.50% 651-49910-122 122 FICA 3,287 2,611 2,730 2,070 2,798 68 2.49% 651-49910-135 135 City Benefit Contribution 21952 2,752 5,250 2,789 5,381 131 2.50% 651-49910-143 143 OPEB Expense 0 0 0 0 530 530 N/A 651-49910-151 151 Worker's Comp Insurance Prem 809 870 1,050 788 1,076 26 2.48% Total Personal Services 54,413 44,900 47,380 34,100 49,094 1,714 3.62% Supplies & Maintenance 651-49910-201 201 Office supplies 0 0 0 0 0 0 N/A 651-49910-221 221 Equipment Parts & Accessories 0 0 0 0 1,300 1,300 N/A 651-49910-227 227 Utility System Maint. Supplies 17,128 10,020 9,500 657 9,500 0 0.00% 651-49910-240 240 Small Tools and Minor Equip 72 4,278 1,000 0 1,000 0 0.00% 651-49910-401 401 Repairs/Maint-Office Equip 1,370 0 1,500 0 1,500 0 0.00% 651-49910-402 402 Repairs/Maint-Auto Equip 135 875 4,000 31768 4,000 0 0.00% 651-49910-404 404 Repairs/Maint-Bldgs/Grounds 390 27,682 0 0 0 0 N/A 651-49910-406 406 Repairs/Maint-Swr lines/lifts 0 1,821 14,000 14 14,000 0 0.00% Total Supplies & Maintenance 19,095 44,676 30,000 4,439 31,300 1,300 4.33% Page 10 City of Orono 2018 Line Item Budget Storm Water cont. 49910 Enterprise Budget Line Item Page 11 Dollar % 2015 2016 2017 Y -T -D 2018 Increase Increase Actual Actual Budget Sep 30, 2017 Draft Budget Decrease Decrease Professional Services 651-49910-301 301 Auditing and Acct'g Services 2,725 3,500 3,500 0 3,500 0 0.00% 651-49910-304 304 Engineering -Consulting 35,211 13,470 15,000 34,686 15,000 0 0.00% 651-49910-307 307 Legal -Consulting 811 0 1,000 0 1,000 0 0.00% 651-49910-319 319 Professional Services 0 0 0 0 0 0 N/A Total Professional Services 38,747 16,970 19,500 34,686 19,500 0 0.00% Insurances 651-49910-361 361 General Liability Ins 500 500 500 375 500 0 0.00% 651-49910-362 362 Umbrella Liability Ins 220 220 220 165 220 0 0.00% 651-49910-367 367 Equipment Floaters Ins 0 1,250 1,250 938 1,250 0 0.00% 651-49910-370 370 Insurance Agent of Record 0 0 0 0 0 0 N/A 651-49910-379 379 Insurance Deductibles 0 0 0 0 0 0 N/A Total Insurances 720 1,970 1,970 1,478 1,970 0 0.00% Page 11 City of Orono 2018 Line Item Budget Storm Water cont. 49910 Enterprise Budget Line Item Dollar % 2015 2016 2017 Y -T -D 2018 Increase Increase Actual Actual Budget Sep 30, 2017 Draft Budget Decrease Decrease Page 12 Other Expenses 651-49910-322 322 Postage 1,569 1,532 1,700 1,200 1,700 0 0.00% 651-49910-331 331 Travel Expenses 0 0 0 0 0 0 N/A 651-49910-352 352 Printing & Publishing 0 0 0 0 0 0 N/A 651-49910-409 409 Depreciation & Amortization 32,465 35,817 31,000 0 38,000 7,000 22.58% 651-49910-415 415 Other Equipment Rentals 0 0 0 0 0 0 N/A 651-49910-416 416 Software Licensing 0 6,518 4,000 2,052 4,000 0 0.00% 651-49910-433 433 Memberships 0 0 0 0 0 0 N/A 651-49910-437 437 Training & Development 0 310 0 0 0 0 N/A 651-49910-438 438 Administrative Charge 16,000 16,000 16,000 12,000 16,000 0 0.00% 651-49910-441 441 Licenses & Taxes 0 0 0 0 0 0 N/A 651-49910-489 489 Other Miscellaneous Charges 0 0 0 0 0 0 N/A Total Other Expenses 50,034 60,177 52,700 15,252 59,700 7,000 13.28% Total Operating Expenses 163,009 168,694 151,550 89,953 161,564 10,014 6.61% Non -Operating Expenses 651-49910-513 513 Easements & Rights of Way 0 0 0 0 0 0 N/A 651-49910-592 592 Storm Sewer Utility Const 0 0 0 0 0 0 N/A Total Non -Operating Expenses 0 0 0 0 0 0 N/A Total Stormwater Fund 163,009 168,694 151,550 89,953 161,564 10,014 6.61% Page 12 City of Orono 2018 Line Item Budget Cable Franchise 49840 Enterprise Budget Line Item Total Personal Services 11,831 8,899 13,660 8,968 30,415 16,755 122.66% Professional Services 614-49840-301 301 Auditing and Acct'g Services 1,625 0 2,000 0 2,000 0 0.00% 614-49840-307 307 Legal -Consulting 0 0 500 0 0 (500) -100.00% 614-49840-319 319 Professional Services 1,760 1,465 2,000 21555 0 (2,000) -100.00% Total Professional Services 3,385 1,465 4,500 2,555 2,000 (2,500) -55.56% Other Expenses Dollar % 614-49840-329 329 Internet/Other Communications 2015 2016 2017 Y -T -D 2018 Increase Increase 614-49840-401 401 Repairs/Maint-Office Equip Actual Actual Budget Sep 30, 2017 Draft Budget Decrease Decrease 614-49840-409 Personal Services 4,314 4,314 4,600 0 4,600 0 0.00% 614-49840-101 101 Full -Time Employees Regular 10,248 7,686 11,800 7,700 28,440 16,640 141.02% 614-49840-102 102 Full -Time Employees Overtime 0 0 0 0 0 0 N/A 614-49840-121 121 PERA 740 555 880 660 935 55 6.25% 614-49840-122 122 FICA 784 588 900 548 954 54 6.00% 614-49840-135 135 City Benefit Contribution 0 0 0 0 0 0 N/A 614-49840-151 151 Worker's Comp Insurance Prem 59 70 80 60 86 6 7.50% Total Personal Services 11,831 8,899 13,660 8,968 30,415 16,755 122.66% Professional Services 614-49840-301 301 Auditing and Acct'g Services 1,625 0 2,000 0 2,000 0 0.00% 614-49840-307 307 Legal -Consulting 0 0 500 0 0 (500) -100.00% 614-49840-319 319 Professional Services 1,760 1,465 2,000 21555 0 (2,000) -100.00% Total Professional Services 3,385 1,465 4,500 2,555 2,000 (2,500) -55.56% Total Other Expenses 15,913 22,516 22,600 10,828 29,100 6,500 28.76% Total Operating Expenses 31,129 32,880 40,760 22,350 61,515 20,755 50.92% Total Cable TV Fund 31,129 32,880 40,760 22,350 61,515 20,755 50.92% Page 13 Other Expenses 614-49840-329 329 Internet/Other Communications 9,099 13,728 15,000 7,968 20,000 5,000 33.33% 614-49840-401 401 Repairs/Maint-Office Equip 0 1,974 500 985 2,000 1,500 300.00% 614-49840-409 409 Depreciation & Amortization 4,314 4,314 4,600 0 4,600 0 0.00% 614-49840-438 438 Administrative Charge 2,500 2,500 2,500 1,875 2,500 0 0.00% Total Other Expenses 15,913 22,516 22,600 10,828 29,100 6,500 28.76% Total Operating Expenses 31,129 32,880 40,760 22,350 61,515 20,755 50.92% Total Cable TV Fund 31,129 32,880 40,760 22,350 61,515 20,755 50.92% Page 13 Water Fund Current Balance: $977,700 Table 6-6 Project 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Annual Operation and Maintenance (1) $505,000 $517,625 $530,566 $543,830 $557,426 $571,361 $585,645 $600,286 $615,293 $630,676 $646,443 $662,604 $679,169 $696,148 Debt Service $156,000 $160,000 $157,000 $156,000 $155,000 $158,000 $101,500 $100,000 $100,000 $100,500 $104,000 $100,600 $103,000 $0 CIP Expenditures $428,700 $391,000 $720,000 $145,200 $471,750 $388,885 $375,113 $425,935 $710,854 $275,871 $330,988 $286,208 $291,532 $341,963 Total Expenses $1,089,700 $1,068,625 $1,407,566 $845,030 $1,184,176 $1,118,246 $1,062,258 $1,126,221 $1,426,147 $1,007,047 $1,081,431 $1,049,412 $1,073,701 $1,038,111 Total Expenses $2,399,220 $1,910,121 $2,211,808 $2,003,565 $2,135,569 $2,361,227 $1,848,099 $1,931,217 $1,919,615 $1,970,327 $2,022,389 $2,075,837 $2,130,707 $2,267,038 Revenues (1) $750,000 $772,500 $795,675 $819,545 $844,132 $869,456 $895,539 $922,405 $950,078 $978,580 $1,007,937 $1,038,175 $1,079,702 $1,112,093 Assessments $10,387 $10,387 $10,387 $10,387 $10,387 $10,387 $10,387 $10,387 $10,387 $0 $0 $0 $0 $0 Annual Balance ($329,313) ($285,738) ($601,504) ($15,098) ($329,657) ($238,404) ($156,332) ($193,429) ($465,683) ($28,467) ($73,494) ($11,236) $6,002 $73,983 Year End Cash Balance $648,387 $362,649 ($238,855) ($253,952) ($583,609) ($822,013) ($978,344) ($1,171,773) ($1,637,456) ($1,665,922) ($1,739,416) ($1,750,652) ($1,744,651) ($1,670,668) Sewer Fund Current Balance: $2,800,000 Table 6-7 Project 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Operation and Maintenance (1) $1,128,700 $1,156,918 $1,185,840 $1,215,486 $1,245,874 $1,277,020 $1,308,946 $1,341,670 $1,375,211 $1,409,592 $1,444,831 $1,480,952 $1,517,976 $1,555,925 Debt Service $110,000 $110,000 $110,000 $110,000 $110,000 $110,000 $0 $0 $0 $0 $0 $0 $0 $0 CIP Expenditures $1,140,520 $643,204 1 $815,967 $646,578 $779,696 $524,206 $539,153 $554,547 $544,404 $560,736 $577,558 $594,885 $612,731 $631,113 Transfer to Equipment Fund for Sewer Equip $20,000 $0 $100,000 $31,500 $0 $450,000 $0 $35,000 $0 $0 $0 $0 $0 $80,000 Total Expenses $2,399,220 $1,910,121 $2,211,808 $2,003,565 $2,135,569 $2,361,227 $1,848,099 $1,931,217 $1,919,615 $1,970,327 $2,022,389 $2,075,837 $2,130,707 $2,267,038 Revenues (1) $255,600 $268,380 $281,799 $295,889 $310,683 $326,218 $342,528 $359,655 $377,638 $396,519 $416,345 $437,163 $459,021 $481,972 Revenues (1) $1,308,898 $1,361,254 $1,415,704 $1,472,333 $1,531,226 $1,592,475 $1,656,174 $1,722,421 $1,791,318 $1,862,970 $1,862,970.33 $1,909,545 $1,957,283 $2,006,215 Assessments $35,349 $35,349 $35,349 $30,368 $26,934 $24,902 $17,569 $17,569 $10,939 $2,000 $0 $0 $0 $0 Annual Balance ($1,054,973) ($513,518) ($760,754) ($500,864) ($577,409) ($743,850) ($174,356) ($191,227) ($117,358) ($105,357) ($159,419) ($166,292) ($173,424) ($260,823) Year End Cash Balance $1,745,027 $1,231,509 $470,755 ($30,109) ($607,519) ($1,351,369) ($1,525,724) ($1,716,951) ($1,834,310) ($1,939,667) ($2,099,086) ($2,265,378) ($2,438,802) ($2,699,625) Storm Water Fund Current Balance: $1,700,000 Table 6-8 Project 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Operation and Maintenance (1) $161,564 $165,603 $169,743 $173,987 $178,336 $182,795 $187,365 $192,049 $196,850 $201,771 $206,816 $211,986 $217,286 $222,718 CIP Expenditures $308,080 $222,160 1 $306,260 $381,122 $390,044 $399,190$408,565 �$0 $418,175 $428,027 $438,127 $448,480 $459,095 $469,977 $469,977 Transfer to Equipment Fund for Storm Equip $0 $0 $100,000 $0 $75,000 $0 $12,000 $600,000 $0 $0 $0 $0 $0 Total Expenses $469,644 $387,763 1 $576,004 $555,108 $643,380 $581,985 $595,930 $622,224 $1,224,877 $639,898 $655,296 $671,081 $687,262 $692,695 Revenues (1) $255,600 $268,380 $281,799 $295,889 $310,683 $326,218 $342,528 $359,655 $377,638 $396,519 $416,345 $437,163 $459,021 $481,972 Annual Balance ($214,044) ($119,383) ($294,205) ($259,219) ($332,697) ($255,767) ($253,401) ($262,569) ($847,240) ($243,378) ($238,950) ($233,918) ($228,242) ($210,723) Year End Cash Balance $1,485,956 $1,366,573 $1,072,368 $813,149 $480,452 $224,685 ($28,717) ($291,286) ($1,138,526) ($1,381,904) ($1,620,855) ($1,854,773) ($2,083,014) ($2,293,737) Public Works - Water CIP Table A-61 5 -Year CIP I Planning Period Project 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 Upgrade Scada Computers and software and Cellular $181,000 North Wellhouse Scada Upgrade $61,200 $50,000 Navarre Plant Control Upgrade $230,000 $55,200 North Water Tower Maintenance $62,500 $62,500 $70,000 Install Well #4 $231,750 $236,385 $241,113 $245,935 $250,854 $255,871 $260,988 $266,208 $271,532 $276,963 $282,502 North Distribution Extension (West of OCB) $120,000 $20,000 Well #1 Rehabilitation $150,000 $20,000 Well #2 Rehabilitation $20,000 $160,000 $20,000 Well #3 Rehabilitation $134,000 $20,000 South Treatment Plant Chem. Rm. Upgrade $75,000 So. Treatment Plant Salt Brine Tank Rehab. $90,000 $90,000 $90,000 $90,000 $90,000 $400,000 South Tower Repaint and Rehabilitation $350,000 $60,000 $65,000 Watermain replacement Old Crystal Bay Road $210,000 Watermain replacement CSAH 19 S of CSAH 15 $181,000 Watermain replacement Waltersport Road $50,000 Watermain Loop Concordia $230,000 North Water Tower Mixer Watermain Improvement Planning $231,750 $236,385 $241,113 $245,935 $250,854 $255,871 $260,988 $266,208 $271,532 $276,963 $282,502 Well #1 Inspection and Maintenance $20,000 Well 42 Inspection and Maintenance $20,000 Well #3 Inspection & Maintenance $20,000 $20,000 Well 44 Inspection & Maintenance $20,000 West Lafeyette Main Replacement (w/Road) $75,000 Water Meter Replacement (every 15yr) $90,000 $90,000 $90,000 $90,000 $90,000 Generator, 250KW 1992 Totals $428,700 $391,000 $720,000 $145,200 $471,750 $388,885 $375,113 $425,935 $710,854 $275,871 $330,988 $286,208 $291,532 $341,963 $282,502 Public Works - Sanitary Sewer CIP Table A-7 5-Year CIP Planning Period Project 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2034 2035 2036 2037 Sewer Rehabilitation $273,182 $281,377 $289,819 $298,513 $307,468 $316,693 $326,193 $335,979 $346,058 $356,440 $367,133 $378,147 $389,492 Annual Sewer Televising (1/5 of City Each Year) $47,272 $48,690 $50,151 $51,655 $53,205 $54,801 $56,445 1 $58,138 $59,883 $61,679 $63,529 $65,435 $67,398 Lift Station #5 Generator $75,000 Lift Station #15 Generator $75,000 Lift Station #1 Generator $75,000 Lift Station #9 Generator $75,000 Lift Station #11 Generator $75,000 Lift Station #3 Generator $75,000 Lift Station #4 Generator $75,000 Lift Station #16 Generator $75,000 Lift Station #25 Generator $75,000 Grinder Station #2 Rehab $56,000 Lift Station #9 Rehab $56,000 Lift Station #5 Rehab $58,000 Lift Station #11 Rehab $58,000 Lift Station #3 Rehab $60,000 Lift Station #4 Rehab $60,000 Lift Station #16 Rehab $62,000 Lift Station #25 Rehab $62,000 Lift Station #28 Rehab $64,000 Lift Station #25 Rehab $64,000 Lift Station Rehab (2 per year) $130,066 $133,968 $137,987 $142,127 $146,390 $150,782 $155,306 $159,965 $180,042 $185,443 $191,006 $196,736 Generator Rehabilitation $10,000 $10,300 $10,609 $10,927 $11,255 $11,593 $11,941 $12,299 $12,668 $13,048 $13,439 $13,843 $14,258 $16,047 $16,529 $17,025 $17,535 Northern Utilities Expansion $436,000 Lift Station Monitoring $26,000 $26,000 $26,000 $26,000 $26,000 $26,000 $26,000 Forest Arms Main Replacement w/ rd $92,400 Lyric Avenue Main Replacement w/ road $33,000 Windjammer Main Replacement with road $24,750 West Laffayette Main Replacement with Road construction $44,000 Public Works - Sanitary Sewer CIP Table A-7 5 -Year CIP Planning Period Project 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2034 2035 2036 2037 Old Crystal Bay Road N Main Replacement $184,340 Navarre Garage Siding Totals $972,194 $1,168,117 $646,578 $661,096 $525,928 $539,153 $554,547 $544,404 $560,736 $577,558 $594,884 $612,731 $631,113 $196,089 $201,972 $208,031 $214,272 Public Works - Storm Sewer CIP Table A-8 5 -Year CIP Planning Period Project 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2036 2037 Storm Watershed Deliniation and Pond Assessments $ 10,000 $ 10,000 $ 10,000 Fox Street Stormwater (w/road reconstruct) Forest Arms Lane (w/road reconstruct) $ 59,720 Windjammer, Garden Lane Storm awater (w/road reconstruct) $ 17,000 West Lafeyete Stormwater (w/road reconstruct) $ 25,800 Tonka Ave (W/ road reconstruct E.Lake St. (w/road reconstruct) Lyric Avenue (w/ Road reconstruct) $ 5,000 Wildhurst Trail (w/ Road reconstruct) $ 89,000 Minnetonka Highlands (w/Road reconstruct) $ 28,000 Vine place (w/ Road reconstruct) $ 1,000 East Long Lake (w/ Road reconstruct) $ 77,000 Garden Lane (w/ Road reconstruct) 13200 Windjamer (North Arm to End) (w/ Road reconstruct) $ 7,200 Lyman Avenue (w/ Road reconstruct) $ 4,600 Tonkaview Lane (w/ Road reconstruct) $ 9,000 Chevy Chase Drive (w/ Road reconstruct) $ 17,500 Kenwood Way (w/ Road reconstruct) $ 2,300 Casco Circle (w/ Road reconstruct) $ 12,000 East Navarre Roads (w/ Road reconstruct) $ 18,000 Kelley Parkway - OCB Rd to StoneBay (w/ Road reconstruct) $ 7,200 Dickenson Street (w/ Road reconstruct) $ 5,700 Glendale Drive (w/ Road reconstruct) $ 3,400 Orchard Park Road (w/ Road reconstruct) $ 14,200 Rest Point Lane (w/ Road reconstruct) $ 2,800 Park Lane (w/ Road reconstruct) $ 2,900 North Arm Drive (w/ Road reconstruct) $ 29,900 Willow Dr (Fox -Brown) (w/ Road reconstruct) $ 24,200 Stubbs Bay Wetland Restoration (SWMP 2) $ 80,000 Fox St @ OCB Road Quality Imp (SWMP 4) Long Lake Ravine Stabalization (SWMP 7) $ 100,000 Shoreline Stabilization (SWMP 13) $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 $10,000 Storm Sewer Improvements $ 157,080 $ 160,140 $ 163,200 $ 167,000 $ 170,340 $ 173,747 $ 177,222 $ 180,766 $ 184,381 $ 188,069 $ 191,831 $ 195,667 $ 199,580 $205,568 $211,735 $238,310 $245,459 Pond Cleaning/Maintenance (5/year) $ 150,000 $ 154,500 $ 159,135 $ 163,909 $ 168,826 $ 173,891 $ 179,108 $ 184,481 $ 190,016 $ 195,716 $201,587 $207,635 $233,695 $240,706 TMDL Updates I $ 51,000 1 $ 52,020 1 $ 53,060 1 $ 54,122 1 $ 55,204 1 $ 56,308 $ 57,434 $ 58,583 $ 59,755 $ 60,950 $ 62,169 $ 63,412 $ 64,680 $66,621 1 $68,619 $77,232 1 $79,549 Kelly Avenue Drainage Improvements Totals $ 308,080 $ 222,160 $ 306,260 $ 381,122 $ 390,044 $ 391,1.907r$ 408,565 $ 418,175 $ 428,027 $ 438,127 $ 448,480 $ 459,095 $ 469,977 $483,776 $497,989 $559,236 $575,713