Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Sewer Operating CIP
City of Otsego Sewer Utility Fund Budget Summary December 31, 2016 Fund Account Description REVENUES 602 37200 Sewer Sales 602 34000 Charges for Service 602 31900 Penalties and Interest OPERATING 602 36210 Investment Interest 602 36213 Change in Investments FMV 602 36220 Rental Income 602 36232 Developer Contributions 602 38991 Refunds and Reimbursements NONOPERATING TOTALREVENUES EXPENDITURES 602 49450 101 Full Time Employees 602 49450 102 FT Overtime 602 49450 104 Part -Time Employees 602 49450 119 Payroll Allocation 602 49450 121 PERA 602 49450 122 FICA and Medicare 602 49450 123 Health 602 49450 130 Other Emplolyee Insurance 602 49450 140 Unemployment Compensation 602 49450 150 Workers Compensation PERSONAL SERVICES 602 49450 201 Office Supplies and Expenses 602 49450 202 Fuel 602 49450 206 Postage 602 49450 210 Operating Supplies 602 49450 216 Chemical Supplies 602 49450 220 Repair/Maintenance Supplies 602 49450 225 Uniform/Clothing Allowance 602 49450 227 Safety Supplies 602 49450 240 Small Tools and Equipment 602 49450 298 W/S Fleet Expenses Actual Actual Actual Budget YTD - Sept Proposed 2012 2013 2014 2015 2015 2016 1,019,258 1,136,423 1,263,420 1,240,995 1,038,547 1,391,000 9,553 7,873 9,525 7,000 7,226 - 14,520 42,227 52,236 40,000 40,286 40,000 1,043,330 1,186,523 1,325,181 1,287,995 1,086,059 1,431,000 11,639 18,211 28,749 - - - - (23,260) - - - - 640 - - - 38,695 - - - 11,347 30 147 23,626 (5,049) 67,474 147 1,066,956 1,181,474 1,392,655 1,287,995 1,086,207 1,431,000 22,840 75,672 153,339 143,161 88,191 157,592 - - 4,018 3,300 3,045 3,750 - - 11,516 1,350 1,215 1,500 24,960 3,750 - - - - 1,647 4,785 11,789 10,985 8,966 12,101 1,539 5,408 11,819 12,914 6,926 12,457 1,456 5,257 17,496 26,038 - - 161 662 1,554 - 14,180 23,419 1,264 3,167 7,360 6,723 4,578 52,603 96,798 214,699 205,108 129,245 215,397 6,878 11,651 11,940 8,000 1,552 5,000 5,203 3,208 1,618 6,833 2,766 8,888 4,595 4,702 6,356 6,600 4,656 8,820 - 12,930 50,622 23,628 24,837 29,836 - - - 19,709 14,092 26,947 29,334 26,369 22,796 80,700 19,998 27,000 - 1,254 796 1,250 938 1,475 - 3,435 296 1,000 360 1,500 - 7,031 749 500 939 106,000 - - 10,402 2,600 1,621 2,600 SUPPLIES 46,010 70,580 105,574 150,820 71,759 218,066 2015 Comments 2016 Comments 5.0 % Rate Increase (2/11/13) Currently Flat - Ehler's Plan is 5.00 Septic Disposal No longer take waste from Riverbend MH Park. No change. 75 % of Utility Employees 75 % of Utility Employees Utility Total - $4,400 Utility Total - $5,000 Utility Total - $1,650 Utility Total - $2,000 7.50 % of Gross Wages 7.65 % of Gross Wages Health / Dental / LTD / STD / Life Based on 7/1/15 - 7/1/16 Invoice General Office / Printer Ink / Envelopes / Folding Machine Maintenance 50 % of 3,644 Gallons at $3.75 75 % of 3,950 Gallons at $3.00 50 % of 2,200 Monthly Bills at $0.49 50 % of 3,000 Monthly Bills at $0.49 See Attachment See Attachment See Attachment See Attachment See Attachment See Attachment 50 % of 4 Staff Allowances of $550 50 % of 5 Staff Allowances of $550; Additional $200 for New Staff Traffic Vests / Ear Plugs / Safety Glasses / Traffic Vests / Ear Plugs / Safety Glasses / 1 st Aid Kits / Arc Flash PPE / Cones / Life 1 st Aid Kits / Arc Flash PPE / Cones / Life Jacket Jacket See Attachment 8 oil changes@ $40e, 4 tire rotate @ $15e, Jet Vac oil $420, Crane truck cable, Air Filter, Light, Battery , Brakes, wheel well paint, trany flush@$200.(1/2) U:\Budget\2016\Utility Funds\Sewer Sewer Fund Summary 602 49450 301 Legal Fees 653 1,000 1,000 602 49450 302 Engineering Fees 10,404 6,849 5,963 10,000 31,822 100,000 Increase for West Digester Increase for West Digester 602 49450 303 Planning Fees 760 225 - 1,000 550 1,000 602 49450 306 Permits & Fees 4,142 4,140 7,350 7,700 7,350 7,750 East WWTF ($5,900) / West WWTF East WWTF ($5,900) / West WWTF ($1,450) / SWPP ($400) ($1,450) / SWPP ($400) 602 49450 315 GIS Services 190 57 1,938 4,000 281 4,000 PAID Costs / Mobile / Desktop 602 49450 320 Telephone - 2,834 2,593 2,301 2,786 3,420 2 hard lines @ 213.53/ mo=2562.36 50 % - Hard Lines ($220 Month) / Cell 4 cell = [(50+40(3)]x12=2040 Phones (5 @ $50 Month) / New Devices ($1,200) 602 49450 322 Utilities 124,947 150,225 144,513 160,000 105,299 160,000 602 49450 325 Garbage Service - 3,478 6,839 6,851 5,013 6,900 3 Yards per Week 3 Yards per Week ($378+$193) Monthly 602 49450 350 Print & Publishing 2,250 116 - 200 - 300 602 49450 355 Dues & Memberships - 25 - 340 83 92 MRWA=$225/2 MMUA $404/2; AW WA $25 50 % - MMUA ($400 / 3) / AW WA ($25) 602 49450 360 Education/Training/Conferences - 1,126 2,317 2,859 2,179 1,500 CEU (5 @ $300) 602 49450 361 Liability & Property Insurance 17,913 4,064 26,454 20,610 14,496 32,460 5% Increase + More In Depth Allocation 602 49450 390 Contracted Services 482,537 258,155 116,776 83,714 120,824 175,827 See Attachment See Attachment 602 49450 402 Repairs & Maintenance Services - 73,488 571 - - - 602 49450 419 Biosolids Removal 2,500 32,346 - 60,000 6,561 60,000 1.2 Million Gallons @ $0.05/per 1.2 Million Gallons @ $0.05/per 602 49450 437 Bank Service Charges - - - - 7,167 8,400 50 % - Credit Card Fees / PSN Online Payment Fees / ACH / Bank Service Charges @ $1,400 Monthly SERVICES & OTHER CHARGES 646,297 537,129 315,316 360,575 304,410 562,648 602 49450 420 Depreciation 826,242 824,492 823,122 860,117 - 880,000 Rough Estimate of 2 % Growth Rough Estimate of 2% over 2015 Budget. 602 49450 501 Equipment - 320 - - - 2,326,250 Based on Draft 2016 CIP 602 49450 610 Bond Interest - - - 755,400 - All Debt Service Paid from SAC Fund 602 49450 720 Operating Transfers 19,600 57,517 56,638 123,200 140,316 Reimburse General Fund ($56,638) Reimburse General Fund ($100,316) / Jet Vac, Debt Transfer ($40,000) OTHER 845,842 824,812 880,639 1,672,155 123,200 3,346,566 TOTAL EXPENDITURES 1,590,752 1,529,319 1,516,228 2,388,658 628,614 4,342,677 NET OPERATIONS (523,796) (347,845) (123,573) (1,100,663) 457,593 (2,911,677) Fund Cash Balance 1,127,629 1,558,600 2,203,977 2,553,697 U:\Budget\2016\Utility Funds\Sewer Sewer Fund Summary 210 Operating Supplies Attachment Preventative Maintenance Lubricants - oil / grease / oil analysis 3,000.00 Belts: Blowers/Transfer pumps/Mechanical Air Units/Odor Control/Exhaust Vents 600.00 Air Filters - blowers / compressors / furnace / dehumidifiers 300.00 Oil Filters - Aerators 300.00 Seal kits / gaskets / shim kits / mechanical seal 1,000.00 fuses/relays/starters/alternators/phase monitor 4,000.00 UV bulbs + disposal; $180/bulb EWWTF 48 total WWWTF 32 total 8,640.00 Batteries - UPS/Equipment Sensors/Flashlights/Gas Detector/Timers/pH/DO 300.00 Sampler Tubing East & West Influent/Effluent 100.00 20 Shop towels/glue/tape/screws bolts nuts/helicoil 150.00 West Auger liners 480.00 $17.50 each 24e + Delivery Disposable Gloves/Winter Gloves/Rubber Gloves/Leather Gloves 1,100.00 90 boxes Nitrile 11e + others Ferric Pump tubing - 1&2 size - supply/distribution replacement 150.00 $75/5pk#1, $75/5pk#2 Salt Bridges / Solution - Inf /Eff pH Meters EWWTF 500.00 Cable ties / fittings / torches / propane / plumbing supplies 100.00 shear pins / 1445 repairs / blades/auger/blower / cotter pins 200.00 Bulb replacement: Driveway lights/Building Exterior/Interior/WT/LED status lights 400.00 Outlet/ext chord 200.00 Bea rings/Desicant/Fine Screen Blades 700.00 Gravity Belt Thickener Blade -Plows -filter belt - Janitorial C Fold Towel s/Soa p/GoJ o/H and Sanitizer/Glass & Surface Cleaner 500.00 600 Garbage bags / mop / 4'-8' brushes / Bleach / Floor Cleaner 350.00 Pesticides / Herbicides / Sprayers - 8 Wasp Spray 5e / 4 Round up 80e 400.00 Paint & Paint Supplies / Floor Treatment 300.00 Pretreatment Building U/L/M Restroom Items - urinal = 50 Toilet paper=40, hand soap 100.00 Sidewalk/Driveway Salt; $20/5g 200.00 Concrete Sealer 200.00 Snow Markers; 20/yr @ $3 each 60.00 900 Plates=20/700 forks=30/700 spoons=30/30 rolls paper towels=36 116.00 Granite Chips Driveway - Site Application Markers 5/year 8each 40.00 Air Cans / Lock De icer / Ice Scrapers 25.00 Double Jacket Hydrant hose Q/C 50'; 50'@ 200each/garden hose 200.00 Oil Dry/algae brushes /3 entry rugs = 150 200.00 Collection System Lift Station Ultrasonic/Pressure Transmitter (1) life expectence 7year 820.00 Lift Station Cleaning 1,600.00 Lift Station Floats 2@100each 200.00 Lift Station Pump/Panel; alternator, phase monitor, relay, fuses 300.00 Sewer Plugs - lift station cleaning Air relief valve parts Leak Seals - Hydra Seal / Okra 600.00 Lift Station Seals / Hooks / Hangers / 700.00 Lab Filter pads-5 bx/yr=125; Kim Wipes 4bx/yr=70; Phosver 3 packets 4 units/yr=160 355.00 Process testing reagents/glassware/pipets / pipet bulb/pans 100.00 pH buffer and storage solution/20g DI water=19 100.00 pH meter replacement probe $100/yr /DO meter replacement probe $350/2yr 100.00 portable DO probe $345 (2017) Desicant Process Testing 50.00 Total 29,836.00 216 Chemical Supplies Attachment Chemical Related Total 6g/day x $2.7/g = $6000 Ferric Contingency high phosp Polymer 6 barrels EWWTF $919 per Polymer 7 barrels WWWTF $919 per Permangenate Total 2016 11,000.00 Ferric History 2,000.00 2009 E 6900 W 11500 = 18400 5,514.00 2010 E 8600 W 7900 = 16500 6,433.00 2011 E 4600 W 8200 = 12800 2,000.00 2012 E 25 W 5900 = 5925 26,947.00 2013 E 400 W 4500 = 4900 2014 E 5010 W 5541=10551 220 Repairs and Maintenance West WWTF 2016 Pretreatment Building RAS Pump 5,000 Control Building Generator PLC 4,000 ASCO Transfer Control Center Display Control Panel PLC/UPS/Program Card 4,000 Blower Building GBT Building Heater replacement Ferric room 500 UV Building UV-fans/ac/compressor/bulbs/cards/psi gauge 1,000 East = 48 bulbs 24 cards West 32 bulbs 16 cards Digester/Storage/Aeration/Other EWWTF Pretreatment Building MAU #1 motor replacement 800 Control Building Control Panel PLC/UPS/Program Card 4,000 Chemical Building Heater replacement Ferric room 500 GBT Building Blower Building UV Building UV fans/ac/compressor/bulbs/cards 3,000 East = 48 bulbs 24 cards West 32 bulbs 16 cards Digester/Storage/Aeration/Other Lift Stations Soft Starts (2) 4,000 Collection System Chimney Seals & replacements Total 26,800 Rounded up as this is an estimate anyway. 240 Small Tools and Equipment West WWTF 2016 Pretreatment Building Hi E Dry - dehumidifier 5,000 Control Building Blower Building GBT Building Poly Pump Ferric Pump 1,000 450 UV Building DO meter & Controller 5,500 Digester/Storage/Aeration/Other 5 tree/mulch North fence line Splitter box bar rack Aerator motor heat tape clarifiers 2,000 300 20,000 200 DO meter & Controller Ditches 5,000 TF� Pretreatment Building Inf channel concrete repair Odor Control HVAC Odor Control Activated Carbon Replacement 12,000 3,000 5,000 2250# Carbon Control Building Chemical Building Ferric Pump 450 GBT Building Poly pump / mixing chamber 1,000 Blower Building UV Building Discharge gate repair DO Controller 900 2,000 Digester/Storage/Aeration/Other Cranes for mixers DO/pH meter portable "i Grinders Otsego Preserve 11,600 3,200 1,000 Soft Starts (2) 4,000 Collection System Chimney Seals & replacements Chimney replacements 20,000 1 air relief valve 1,000 Jet Vac 1,000 grease cleaning nozzle 105,600 Rounded up as this is an estimate anyway. Total 390 Contract Services Attachment Page 1 of 2 2016 Generator Maintenance - 2 Portable and 2 Stationary 3,000 HVAC - Heating cooling preventative and corrective maintenance 3,000 Fall maint = 490W 340E Instrumentation services 9,000 IT - Computer/Software/Updates/Back Ups/ 3,000 Lawn Spraying 2,000 RPZ inspections 3 @ WWTF 150 $50/insp; rebuild $150 each(2017) Security monitoring; $350 / year x East WWTF and West WWTF 700 Civic Systems 4,700 Lift Station Corrective Maintenance & Inspection 5,000 8 trips 200 each + parts Meter Calibrations - permit required 2x/yr 1,240 620 per event; done 2x/yr Fire Extinguisher Annual Inspections 200 Electrical 10,000 Locates 26,000 Camera Inspections 1,500 On Call Answering Service 715 59.58/mo Hauling services from West WWTF Digester ($0.05/g) 14,080 8800gx0.05/gx32weeks Solids Processing Big Lake 42,426 $1326/wk x 32 UC Labs (Detail Page 2) 42,624 Pavement Management - FOG Seal / Seal Coat 1,042 Pavement Management Doc Alarm 4G upgrade ($350 per site) 700 Utility Billing machine repairs (neopost) 1,000 MMUA 3,750 5000 x 75% Total 175,827 390 Contract Services Attachment Page 2 of 2 Cost/Sam # SAMPLES Cost CBOD 6,318 20.25 312 6,318.00 TSS 3,861 12.38 312 3,861.00 T Phosp routine + average reduction 4,800 15.00 320 4,800.00 Total Mercury 2,700 135.00 20 2,700.00 Fecal 2,165 13.88 156 2,165.28 NH4 2,028 13.00 156 2,028.00 new permit requirements Dissolved Mercury 1,700 170.00 10 1,700.00 Total Mercury 1,620 135.00 12 1,620.00 Nitrite + Nitrate 297 12.38 24 297.12 Kjeldahl Nitrogen 441 18.38 24 441.12 Total Dissolved Solids 149 12.38 12 148.56 TSS 149 12.38 12 148.50 Total new 4,355 4,355.30 Laboratory West WWTF - UC Labs Cost/Sam # SMPLS Cost CBOD 2,106 20.25 104 2,106.00 TSS 1,287 12.38 104 1,287.00 T Phosp5 routine + average reduction 1,800 15.00 120 1,800.00 Fecal 428 13.38 32 428.16 Salty Discharge pH N/C Chloride 150 12.50 12 150.00 Calcium 221 18.38 12 220.56 Sodium 221 18.38 12 220.56 Magnesium 221 18.38 12 220.56 Potassium 221 18.38 12 220.56 Sample Prep Fee 207 17.25 12 207.00 Total Dissolved Solids 149 12.38 12 148.56 Sulfate 347 28.88 12 346.56 Alkalinity N/C Bicarbonate 180 15.00 12 180.00 Specific Conductance 140 11.63 12 139.56 Ammonia Nitrogen 30 15.00 2 30.00 Kjeldahl Nitrogen 37 18.38 2 36.76 Nitrite + Nitrate 25 12.38 2 24.76 Total Mercury 140 140.00 1 140.00 Biosolids 503 970 485.00 2 970.00 Pathogen Reduction MPN 910 65.00 14 910.00 Acute Toxicity 850 850.00 1 850.00 Soil Samples 0 62.00 0 - Priority Pollutants 951 951.00 1 951.00 Alkalinity - Digester Related 124 12.40 10 124.00 • Volatile Solids 165 16.50 10 165.00 %Total Solids 165 16.50 10 165.00 42,624 City of Otsego, Minnesota Capital Improvement Plan 2016 thru 2020 PROJECTS BY FUNDING SOURCE Source Project# Priority 2016 2017 2018 2019 2020 Total 602 - Sanitary Sewer Utility Fund SCADA Computer Replacement 602-2016-01 n/a 15,000 15,000 Digester Expansion - West WWTF 602-2016-02 n/a 2,000,000 21000,000 East WWTF - Oxidation Aeration Imp. 602-2016-03 n/a 235,000 235,000 Sanitary Sewer Master Study 602-2016-04 n/a 50,000 50,000 Lift Station #1 - Pump Replacement 602-2017-01 nla 20,000 20,000 20,000 60,000 West WWTF - Oxidation Aeration Imp. 602-2017-02 n/a 115,000 115,000 Lift Station #5 - Pump Replacement 602-2019-01 n/a 15,000 15,000 Lift Station #2 - Pump Replacement 602-2020-01 nla 7,000 7,000 Lift Station #6 - Pump Replacement 602-2020-02 nla 10,000 10,000 Lift Station #3 - Pump Replacement 602-2020-03 n/a 15,000 15,000 Ford F250 Extended + Plow FLEET-16-01 n/a 26,250 26,250 602 - Sanitary Sewer Utility Fund Total 2,326,250 135,000 20,000 15,000 52,000 2,548,250 GRAND TOTAL 2,326,250 135,000 20,000 15,000 52,000 2,548,250 Tuesday, October 20, 2015 2016 thrtt 2020 Capital Improvement Plan City of Otsego, Minnesota Project # 602-2016-01 Project Name SCADA Computer Replacement Description Department Sanitary Sewer Utility Contact Lead Utility Systems Operator Type Utility System Useful Life Category Sanitary Sewer Utility System Priority n/a Total Project Cost: $15,000 ilacement of the SCADA (Supervisory Control And Data Acquisition) systems for control of both the East and West Wastewater Treatment ilities. The project includes replacemnet of two computers, contract services to migrate the existing software to the new hardware, verify Rion of systems on the new hardware, and upgrade any systems not compatible with new operating systems. Justification SCADA computers provide remote monitoring for equipment at the EWWTF, WWWTF, lift stations and well houses. The information provided includes flow tranding, equipment ststus and run time, liquid levels, and call out to emergency responders in the event of equipment failure. Six years is the life expectance of these computers. Expenditures 2016 2017 2018 2019 2020 Total Utility System 15,000 15,000 Total 15,000 15,000 Funding Sources 2016 2017 2018 2019 2020 Total 602 - Sanitary Sewer Utility 15,000 15,000 Fund Total 15,000 15,000 Tuesday, October 20, 2015 Capital Improvement Plan City of Otsego, Minnesota Project # 602-2016-02 Project Name Digester Expansion - West WWTF Description xpansion of the digester at the West WWTF. 2016 thru 2020 Department Sanitary Sewer Utility Contact Lead Utility Systems Operator Type Utility System Useful Life Category Sanitary Sewer Utility System Priority n/a Total Project Cost: $2,000,000 Justification I 3ased on a study conducted in 2013, additional digestion space is needed prior to facility expansion. The digestion process ensures pathogen eduction requirements are maintained and aerobic conditions are met. Expenditures 2016 2017 2018 2019 2020 Total Utility System 2,000,000 2,000,000 Total 2,000,000 2,000,000 Funding Sources 2016 2017 2018 2019 2020 Total 602 - Sanitary Sewer Utility 2,000,000 2,000,000 Fund Total 2,000,000 2,000,000 Tuesday, October 20, 2015 2016 thrtt 2020 Capital Improvement Plan City of Otsego, Minnesota Department Sanitary Sewer Utility Contact Lead Utility Systems Operator Type Utility System Project # 602-2016-03 Useful Life Project Name East WWTF -Oxidation Aeration Imp. Category Sanitary Sewer Utility System Priority n/a Total Project Cost: $235,000 Description This is a planned conversion of existing storage areas to accommodate aeration equipment in order to increase liquid capacity Justification I 'base III of the East WWTF completed in 2007 provided solids storage tanks designed for future aeration as flows approached current process rapacity. It is anticipated with growth and increased flows the coversion of one of two storage tanks to aeration be completed. The conversion )rovides treatment capacity from xx gallons to xx gallons with redundancy for emergency purposes. Existing solids mixing equipment will be emoved and aeration equipment installed. The project will require engineer review, design and bid. Estimates are established in multiple years to ndicate engineering and construction costs. Using a projected growth of 100 homes per year the increase of flow is an additional 28,600 gallons )er day per year warranting project completion by 20xx. Expenditures 2016 2017 2018 2019 2020 Total Utility System 235,000 235,000 Total 235,000 235,000 Funding Sources 2016 2017 2018 2019 2020 Total 602 - Sanitary Sewer Utility 235,000 235,000 Fund Total 235,000 235,000 Tuesday, October 20, 2015 Capital Improvement Plan City of Otsego, Minnesota Project # 602-2016-04 Project Name Sanitary Sewer Master Study 2016 thrtt 2020 Department Sanitary Sewer Utility Contact Lead Utility Systems Operator Type Utility System Useful Life Category Sanitary Sewer Utility System Priority n/a Total Project Cost: $50,000 Description airing a consultant to perform a comprehensive study of the current Sanitary Sewer Facilities and the future of them. Justification I Fhe City is growing to the point where the capacity of the Sanitary Sewer Utility facilities need to be evaluated. Expenditures 2016 2017 2018 2019 2020 Total Utility System 50,000 50,000 Total 50,000 50,000 Funding Sources 2016 2017 2018 2019 2020 Total 602 - Sanitary Sewer Utility 50,000 50,000 Fund Total 50,000 50,000 Tuesday, October 20, 2015 Capital Improvement Plan City of Otsego, Minnesota Project # 602-2017-01 Project Name Lift Station #1- Pump Replacement Description Sump replacement at Lift Station #1 (Quaday). 2016 thrtt 2020 Department Sanitary Sewer Utility Contact Lead Utility Systems Operator Type Utility System Useful Life 10 Category Sanitary Sewer Utility System Priority n/a Total Project Cost: $60,000 Justification I k11 lift station submersible pumps are evaluated on an annual basis for replacement projections. These projections are based on inspections, pump :yc;ling, capacities, run time hours and repairs. Expenditures 2016 2017 2018 2019 2020 Total Utility System 20,000 20,000 20,000 60,000 Total Funding Sources 2016 20,000 2017 20,000 2018 2019 20,000 2020 60,000 Total 602 - Sanitary Sewer Utility Fund 20,000 20,000 20,000 60,000 Total 20,000 20,000 20,000 60,000 Tuesday, October 20, 2015 Capital Improvement Plan City of Otsego, Minnesota Project # 602-2017-02 Project Name West WWTF - Oxidation Aeration Imp. Description keration equipment purchace West WWTF . 2016 thrtt 2020 Department Sanitary Sewer Utility Contact Lead Utility Systems Operator Type Utility System Useful Life Category Sanitary Sewer Utility System Priority n/a Total Project Cost: $115,000 Justification I Fhe 2015 Liquid Re Rate Review of the West Wastewater Treatment Facility by AE2S Engineering identified the need for aeration equipment to neet Minnesota Pollution Control Reduncey Standards. The costs includes equipment purchase only, providing availability to install with minimal lowntime in the event of failure. The equipment provides mixing and aeration to the Oxidation Ditch used for biological treatment of the facility. Expenditures 2016 2017 2018 2019 2020 Total Utility System 115,000 115,000 Total 115,000 115,000 Funding Sources 2016 2017 2018 2019 2020 Total 602 - Sanitary Sewer Utility 115,000 115,000 Fund Total 115,000 115,000 Tuesday, October 20, 2015 Capital Improvement Plan City of Otsego, Minnesota Project # 602-2019-01 Project Name Lift Station #5 - Pump Replacement Description Sump replacement at Lift Station #5 (Riverplace). 2016 thrtt 2020 Department Sanitary Sewer Utility Contact Lead Utility Systems Operator Type Utility System Useful Life 10 Category Sanitary Sewer Utility System Priority n/a Total Project Cost: $15,000 Justification I k11 lift station submersible pumps are evaluated on an annual basis for replacement projections. These projections are based on inspections, pump :yc;ling, capacities, run time hours and repairs. Expenditures 2016 2017 2018 2019 2020 Total Utility System 15,000 15,000 Total 15,000 15,000 Funding Sources 2016 2017 2018 2019 2020 Total 602 - Sanitary Sewer Utility 15,000 15,000 Fund Total 15,000 15,000 Tuesday, October 20, 2015 Capital Improvement Plan City of Otsego, Minnesota Project # 602-2020-01 Project Name Lift Station #2 -Pump Replacement Description Sump replacement at Lift Station #2 (Riverpointe). 2016 thrtt 2020 Department Sanitary Sewer Utility Contact Lead Utility Systems Operator Type Utility System Useful Life 10 Category Sanitary Sewer Utility System Priority n/a Total Project Cost: $14,000 Justification I k11 lift station submersible pumps are evaluated on an annual basis for replacement projections. These projections are based on inspections, pump :yc;ling, capacities, run time hours and repairs. Expenditures 2016 2017 2018 2019 2020 Total Utility System 7,000 7,000 Total Funding Sources 2016 7,000 2017 2018 2019 2020 7,000 Total 602 - Sanitary Sewer Utility Fund 7,000 7,000 Total 7,000 7,000 Tuesday, October 20, 2015 Capital Improvement Plan City of Otsego, Minnesota Project # 602-2020-02 Project Name Lift Station #6 - Pump Replacement Description Sump replacement at Lift Station #6 (Riverwood National). 2016 thrtt 2020 Department Sanitary Sewer Utility Contact Lead Utility Systems Operator Type Utility System Useful Life 10 Category Sanitary Sewer Utility System Priority n/a Total Project Cost: $20,000 Justification k11 lift station submersible pumps are evaluated on an annual basis for replacement projections. These projections are based on inspections, pump :yc;ling, capacities, run time hours and repairs. Expenditures 2016 2017 2018 2019 2020 Total Utility System 10.000 10,000 Total Funding Sources 2016 10,000 2017 2018 2019 2020 10,000 Total 602 - Sanitary Sewer Utility Fund 10,000 10,000 Total 10,000 10,000 Tuesday, October 20, 2015 Capital Improvement Plan City of Otsego, Minnesota Project # 602-2020-03 Project Name Lift Station #3 - Pump Replacement Description Sump replacement at Lift Station #3 (West WWTF). 2016 thrtt 2020 Department Sanitary Sewer Utility Contact Lead Utility Systems Operator Type Utility System Useful Life 10 Category Sanitary Sewer Utility System Priority n/a Total Project Cost: $15,000 Justification k11 lift station submersible pumps are evaluated on an annual basis for replacement projections. These projections are based on inspections, pump :yc;ling, capacities, run time hours and repairs. Expenditures 2016 2017 2018 2019 2020 Total Utility System 15,000 15,000 Total Funding Sources 2016 15,000 2017 2018 2019 2020 15,000 Total 602 - Sanitary Sewer Utility Fund 15,000 15,000 Total 15,000 15,000 Tuesday, October 20, 2015 Capital Improvement Plan City of Otsego, Minnesota Project # FLEET-16-01 Project Name Ford F250 Extended + Plow Description 'W#18 - Chevy 1/2 ton extended cab with 3/4 ton Ford extended cab. 2016 thrtt 2020 Department Fleet Contact Lead Utility Systems Operator Type Vehicles Useful Life 10 Category Vehicles Priority n/a Total Project Cost: $35,000 Justification 1W#18 is a 2005 Chevy extended -cab 4x4 with a rating of 16 out of 17. Vehicle mileage as of July 2015 is 81,719 with concerning oil :onsumption. Staff recommends replacement of the vehicle with a 3/4 ton Ford extended Cab 4x4 w/plow package. The anticipated trade in 7alue of the 2005 vehicle is approximately $5000 for a total 3/4 ton purchase price of $35,000. Expenditures 2016 2017 2018 2019 2020 Total Vehicles 35,000 35,000 Total 35,000 35,000 Funding Sources 2016 2017 2018 2019 2020 Total 601 - Water Utility Fund 8,750 8,750 602 - Sanitary Sewer Utility 26,250 26,250 Fund Total 35,000 35,000 Tuesday, October 20, 2015 City of Otsego Sewer Utility F Cash Flow Sum and mary Revised: October 20, 2015 Rate Increase 5.00% 5.00% 0.00% 0.00% 0.00% 0.00% 0.00% Base Charge $ 5.00 $ 7.88 $ 8.27 $ 8.68 $ 8.68 $ 8.68 $ 8.68 $ 8.68 $ 8.68 Consumption Charge $ 5.00 $ 4.88 $ 5.13 $ 5.38 $ 5.38 $ 5.38 $ 5.38 $ 5.38 $ 5.38 Actual Actual Actual Projected Projected Projected Projected Projected Projected 2012 2013 2014 2015 2016 2017 2018 2019 2020 Comments Operating Revenues Sewer Sales $ 1,019,258 $ 1,136,423 $ 1,263,420 $ 1,391,000 $ 1,391,000 $ 1,391,000 $ 1,391,000 $ 1,391,000 $ 1,391,000 2015 Budget was $1,240,995 Charges for Services 9,553 7,873 9,525 7,000 - - - - - Mobile Home Disposal - 2015 Was Final Year Penalties and Interest 14,520 42,227 52,236 40,000 40,000 40,000 40,000 40,000 40,000 Flat Other Subtotal 1,043,331 1,186,523 1,325,181 1,438,000 1,431,000 1,431,000 1,431,000 1,431,000 1,431,000 Nonoperating Revenues Investment Interest (Net) 11,639 (5,049) 28,749 - - - - - - Other 11,987 38,725 Total 1,066,957 1,181,474 1,392,655 1,438,000 1,431,000 1,431,000 1,431,000 1,431,000 1,431,000 Expenses Personal Servcies 52,603 96,798 214,699 205,108 215,397 219,705 224,099 228,581 233,153 2016 Prelim Budget - Then 2% Inflation Supplies 46,010 70,580 105,574 150,820 218,066 222,427 226,876 231,413 236,042 2016 Prelim Budget - Then 2% Inflation Services & Other Charges 646,297 537,129 315,316 360,575 562,648 430,081 438,683 447,456 456,405 2016 Prelim Budget - Reduced Eng/Solids - Then 2% Inflation Depreciation 826,242 824,492 823,122 860,117 880,000 880,000 880,000 880,000 880,000 2016 Projection - Then Flat Capital Outlay 8,550 - 26,593 - - - - - - Capital Outlay (CIP) - - - - 2,326,250 135,000 20,000 15,000 52,000 Based on Draft 2016 CIP Nonoperating - - - - - - - - - Transfers Out - - 57,517 56,638 100,316 110,000 110,000 110,000 110,000 Transfer to General Fund for staff reimbursement. Transfers Out - Jet Vac 19,600 123,200 40,000 39,200 38,400 32,800 Transfer to Debt Fund 399for Jet Vac Total 1,599,302 1,528,999 1,542,821 1,756,458 4,342,677 2,036,413 1,938,057 1,945,251 1,967,600 Cash Balance- Beginning 803,364 1,127,628 1,558,600 2,203,977 2,745,636 713,959 988,546 1,361,489 1,727,238 Balance Sheet Effects 30,367 (45,995) (27,579) Revenues 1,066,957 1,181,474 1,392,655 1,438,000 1,431,000 1,431,000 1,431,000 1,431,000 1,431,000 Expenditures (1,599,302) (1,528,999) (1,542,821) (1,756,458) (4,342,677) (2,036,413) (1,938,057) (1,945,251) (1,967,600) Noncash- Depreciation 826,242 824,492 823,122 860,117 880,000 880,000 880,000 880,000 880,000 Cash Balance- Ending $ 1,127,628 $ 1,558,600 $ 2,203,977 $ 2,745,636 $ 713,959 $ 988,546 $ 1,361,489 $ 1,727,238 $ 2,070,639 Current Cash = $2,646,923 City of Otsego Sewer Access Charge Fund Cash Flaw Summary k YTD Revised: October 16, 2015 $ 920,348 Rate Increase 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Availability Charge $ 2,265.00 $ 2,265.00 $ 2,265.00 $ 2,265.00 $ 2,265.00 $ 2,265.00 $ 2,265.00 $ 2,265.00 $ 2,265.00 $ 2,265.00 $ 2,265.00 $ 2,265.00 $ 2,265.00 $ 2,265.00 Connection Charge $ 6,796.00 $ 6,796.00 $ 6,796.00 $ 6,796.00 $ 6,796.00 $ 6,796.00 $ 6,796.00 $ 6,796.00 $ 6,796.00 $ 6,796.00 $ 6,796.00 $ 6,796.00 $ 6,796.00 $ 6,796.00 Estimated Hookups 150 110 120 130 145 150 160 170 170 170 170 170 170 170 Actual Actual Actual Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 Revenues SAC Fee $ 562,698 $ 745,791 $ 1,684,899 $ 1,359,150 $ 996,710 $ 1,087,320 $ 1,177,930 $ 1,313,845 $ 1,359,150 $ 1,449,760 $ 1,540,370 $ 1,540,370 $ 1,540,370 $ 1,540,370 $ 1,540,370 $ 1,540,370 $ 1,540,370 Special Assessments 15,796 - - 31,776 30,852 29,929 29,005 28,082 - - - - - - - - - Investmentlnterest(Net) 79,974 (12,269) 51,312 - - - - - - - - - - - - - - Miscellaneous - - - - - - - - - - - - - - - - - Total 658,468 733,522 1,736,211 1,390,926 1,027,562 1,117,249 1,206,935 1,341,927 1,359,150 1,449,760 1,540,370 1,540,370 1,540,370 1,540,370 1,540,37C 1,540,370 1,540,370 Expenses Debt Service - Principal 4,375,700 - - - - - - - - - - - - - - - - Debt Service - Interest 755,400 594,060 593,779 - - - - - - - - - - - - - - Debt Principal (2009A) - - - - - - - - - - - - 480,000 1,008,000 1,046,400 1,536,000 - Debt Interest (2009A) - - - 166,790 166,790 166,790 166,790 166,790 166,790 166,790 166,790 166,790 166,790 147,590 106,262 63,360 - Debt Principal (2010C) - - - - 1,280,000 1,302,400 1,363,200 1,420,800 1,494,400 1,542,400 1,632,000 1,696,000 995,200 444,800 460,800 - - Debt Interest (2010C) - - - 477,120 477,120 451,520 399,424 344,896 288,064 243,232 166,112 116,336 62,912 30,568 15,667 - - Transfers Out - - - - - - - - - - - - - - - - - Total 5,131,100 594,060 593,779 643,910 1,923,910 1,920,710 1,929,414 1,932,486 1,949,254 1,952,422 1,964,902 1,979,126 1,704,902 1,630,958 1,629,129 1,599,360 Cash Balance - Beginning 7,861,007 3,436,514 3,512,048 4,481,928 5,228,944 4,332,596 3,529,135 2,806,656 2,216,097 1,625,993 1,123,331 698,799 260,043 95,511 4,923 (83,836) (142,826) Balance Sheet Effects 48,139 (63,928) (172,552) Revenues 658,468 733,522 1,736,211 1,390,926 1,027,562 1,117,249 1,206,935 1,341,927 1,359,150 1,449,760 1,540,370 1,540,370 1,540,370 1,540,370 1,540,370 1,540,370 1,540,370 Expenditures (5,131,100) (594,060) (593,779) (643,910) (1,923,910) (1,920,710) (1,929,414) (1,932,486) (1,949,254) (1,952,422) (1,964,902) (1,979,126) (1,704,902) (1,630,958) (1,629,129) (1,599,360) Cash Balance - Ending $ 3,436,514 $ 3,512,048 $ 4,481,928 $ 5,228,944 $ 4,332,596 $ 3,529,135 $ 2,806,656 $ 2,216,097 $ 1,625,993 $ 1,123,331 $ 698,799 $ 260,043 $ 95,511 $ 4,923 $ (83,836) $ (142,826) $ 1,397,544 Bonds Payable $ 17,702,400 $ 17,702,400 $ 17,702,400 $ 17,702,400 $ 16,422,400 $ 15,120,000 $ 13,756,800 $ 12,336,000 $ 10,841,600 $ 9,299,200 $ 7,667,200 $ 5,971,200 $ 4,496,000 $ 3,043,200 $ 1,536,000 $ - $ - Sewer Access Charges Fund $20,000,000 $18,000,000 $16,000,000 $14,000,000 $12,000,000 $10,000,000 $8,000,000 $6,000,000 $4,000,000 $2,000,000 $- 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028. $(2,000,000) Bonds Payable -*--Cash Balance - Ending