Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Packet - Sewer
City of Otsego Enterprise Fund Budget - 2019 Department Requests Sanitary Sewer Utility 49450 - Sanitary Sewer Utilitv Fund Account Number Fund Department Source Account Description Revenues 602 49450 37200 SEWER SALES 602 49450 31900 PENALTIES AND INTEREST 602 49450 34000 CHARGES FOR SERVICES TOTAL - OPERATING 602 49450 33422 OTHER STATE AID GRANTS 602 49450 36200 MISCELLANEOUS REVENUES 602 49450 36210 INTEREST EARNINGS 602 49450 36213 NEY CHANGE IN INVESTMENT FMV 602 49450 36220 RENTAL INCOME 602 49450 36232 CAPITAL CONTRIB. DEVELOPERS 602 49450 38020 DONATIONS & CONTRIBUTIONS 602 49450 38991 REFUNDS & REIMBURSEMENTS 602 49450 39101 SALES OF FIXED ASSETS 602 49450 39200 TRANSFERS IN 602 49450 39250 TRANSFER IN - CAPITAL ASSETS TOTAL - NON OPERATING TOTAL - REVENUES Expenses 1,737,618 1,571,448 1,765,682 1,994,137 7,457 602 49450 101 FULL-TIME EMPLOYEES REGULAR 602 49450 102 WAGES - FT OVERTIME 602 49450 104 WAGES - PT EMPOYEES 602 49450 119 PAYROLL ALLOCATION 602 49450 121 PERA 602 49450 122 FICA AND MEDICARE 602 49450 123 HEALTH 602 49450 130 OTHER EMPLOYER PAID INS 602 49450 150 WORKERS COMPENSATION 602 49450 191 GERF PENSION EXPENSE TOTAL -PERSONAL SERVICES 4,495 3,242 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 REPAIRS/MAINTSUPPLIES 602 49450 225 UNIFORMS/CLOTHING ALLOWANCE 602 49450 227 SAFETY SUPPLIES 602 49450 240 SMALL TOOLS/EQUIPMENT 602 49450 298 W/S FLEET EXPENSES TOTAL - SUPPLIES 4,500 5,260 3,075 Requested Actual Actual Year -to -Date Budget Budget 2016 2017 2018 2018 2019 SEWER -1 Comments $ 1,527,633 $ 1,672,342 $ 1,511,642 $ 1,700,682 $ 1,928,137 Includes 8% Rate Increase - See Cash Flow 63,162 65,276 59,805 65,000 66,000 Estimated - Represents Average of Actuals for 2016-2018 (YTD) 1,590,795 1,737,618 1,571,448 1,765,682 1,994,137 7,457 - - - - 615 - 1,502 30,823 17,116 - (13,417) (7,116) 23,400 294,115 551,275 13,304 1,000 - - 1,305 6,449 8,382 - - 3,281 - 8,356 - 162,876 61,473 - 484,774 637,553 13,166 - - 2,075,569 2,375,171 1,584,613 1,765,682 1,994,137 189,082 205,579 166,429 213,190 229,970 8,799 8,373 11,350 9,000 11,250 - - 6,026 11,700 23,400 14,178 15,903 13,304 16,664 18,092 14,500 15,601 13,650 17,893 20,243 26,048 29,798 25,214 30,333 32,866 6,995 8,794 15,299 9,080 10,759 11,058 30,535 - - - 270,659 314,583 251,271 307,860 346,580 3,372 4,495 3,242 4,000 4,500 8,015 8,915 48 8,849 8,753 6,013 7,712 4,717 9,729 10,716 19,303 22,801 8,202 25,000 25,000 79,259 29,466 21,617 36,000 36,000 31,470 52,026 78,512 62,000 72,000 1,234 1,161 365 1,480 1,585 3,961 457 2,604 1,800 2,200 2,819 3,954 6,851 3,500 4,500 5,260 3,075 - 3,000 4,000 160,706 134,062 126,158 155,358 169,254 Allocated 75% of 4,095 Gallons (2017 Actual) at $2.85 (Same Rate as Fleet) Allocated 50% of Monthly Bill Mailings (3,800 Accounts at $0.47) See Detailed Attachment See Detailed Attachment See Detailed Attachment See Detailed Attachment X:\Budget\2019\Utility Funds\2019 UTILITY BUDGETS INPUT Sewer Fund City of Otsego Enterprise Fund Budget - 2019 Department Requests Sanitary Sewer Utility 49450 - Sanitary Sewer Utility Fund Requested Account Number Actual Actual Year -to -Date Budget Budget Fund Department Source Account Description 2016 2017 2018 2018 2019 602 49450 301 LEGAL SERVICES - - 1,000 1,000 602 49450 302 ENGINEERING FEES 439,623 93,671 53,260 59,670 1,152,000 602 49450 303 PLANNING FEES - - 200 1,000 1,000 602 49450 306 PERMIT & FEES 8,900 8,590 7,350 7,350 7,350 602 49450 315 GIS SERVICES 2,475 4,230 6,274 4,000 7,500 602 49450 320 TELEPHONE 5,419 6,360 5,621 7,200 7,200 602 49450 321 MILEAGE/TRAVEL 126 217 186 300 300 602 49450 322 UTILITIES 163,781 198,002 151,068 178,487 195,000 602 49450 325 GARBAGE SERVICE 7,661 8,328 12,027 8,400 24,000 602 49450 350 PRINT&PUBLISHING 72 - 168 300 300 602 49450 355 DUES & MEMBERSHIPS 69 323 402 350 440 602 49450 360 EDUCATION/TRAINING/CONFERENCES 3,451 2,231 1,759 3,520 4,066 602 49450 361 LIABILITY AND PROPERTY INSURAN 31,148 31,836 24,148 32,888 34,533 602 49450 390 CONTRACTED SERVICES 171,893 108,495 97,649 114,000 119,000 602 49450 402 REPAIRS/MAINT BUILDINGS 4,920 3,814 - - - 602 49450 410 RENTALS 2,904 1,020 1,099 1,465 1,465 602 49450 419 BIOSOLIDS HAULING 65,889 41,580 - 55,000 55,000 602 49450 437 BANK SERVICE CHARGES 14,565 22,528 20,867 20,860 23,100 TOTAL - SERVICES & OTHER CHARGES 922,896 531,226 382,077 495,790 1,633,254 602 49450 500 CAPITAL OUTLAY (GENERAL) 12,006 - 1,257 2,250 - 602 49450 501 EQUIPMENT 79,080 55,988 22,890 40,000 53,000 602 49450 530 IMPROVEMENTS OTHER THAN BLDG 1,900,556 11,250 47,600 443,912 602 49450 550 MOTOR VEHICLES - 32,115 110,071 83,231 - 602 49450 590 REHABILITATION & REPLACEMENT - - 150,000 280,000 602 49450 599 CAPITALIZED ASSET OFFSET (2,297,241) (83,023) - - - TOTAL - CAPITAL OUTLAY (305,599) 16,330 181,817 719,393 333,000 602 49450 420 DEPRECIATION 839,617 912,688 - 995,000 1,015,000 602 49450 610 BOND INTEREST - - - - - 602 49450 720 OPERATING TRANSFERS 143,316 255,481 325,070 325,070 328,411 TOTAL -OTHER 982,933 1,168,169 325,070 1,320,070 1,343,411 TOTAL -EXPENSES 2,031,595 2,164,371 1,266,393 2,998,471 3,825,499 NET INCOME / (LOSS) $ 43,974 $ 210,801 $ 318,220 $ (1,232,789) $ (1,831,362) SEWER - 2 Comments See Detailed Attachment See Detailed Attachment See Detailed Attachment Estimated - Represents Average of Actuals for 2017-2018 (YTD) Randy's Environmental Services ($800 Mth) / Waste Mgmt ($1,200 Mth) Statutory Publish Requirements (Budget & Financial Statements) MMUA Membership (75%) +Suburban Utility Association (50% See Detailed Attachment Based on Actual 2017-2018 Premiums + 5% Inflation See Detailed Attachment Lease Payments - Utility Bill Folding + Envelope Stuffing Machine Pumping of Storage Tanks w/ Land Application Estimated - Represents Average of Actuals for 2016-2018 (YTD) + 5% See Detailed Attachment Draft 2019-2028 CIP See Detailed Attachment Increase to account for depreciation on Developer Assets General Fund ($128,821) +Jet Vac Debt ($32,800) + SAC Debt ($166,790) X:\Budget\2019\Utility Funds\2019 UTILITY BUDGETS INPUT Sewer Fund City of Otsego Enterprise Fund Budget - 2019 Detail of Line Item Requests Sanitary Sewer Utility Budget Account No. & Descri 602-49450-210 Repair and maintenance related to aging equipment and infrastucture. $ 24,000 $ OPERATING SUPPLIES - Equipment + Components Maintenance - Influent Sampler East WWTF 1,000 25,000 $ 26,000 602-49450-225 $ $ 602-49450-216 CHEMICAL SUPPLIES 10,000 36,000 375 Boot Allowance = $150 x 5 Operate 75 602-49450-220 $ 15,000 R/M SUPPLIES 15,000 5,000 22,000 5,000 Requested Budget 2018 Item Detail / Description 24,000 Facility Operations & Preventative Maintenance Supplies 1,000 Collection System / Lift Stations Operations & Maintenance Su 25,000 26,000Ferric Chloride - Phosphorous Removal 10,000 Polymer - Belt Thickening Process SEWER - 3 Comments $ 15,000 East Wastewater Treatment Faciltiy Corrective Maintenance Repair and maintenance related to aging equipment and infrastucture. 15,000 West Wastewater Treatment Facility Corrective Maintenance 7,000 Lift Stations Corrective Maintenance 30,000 Collection System Corrective Maintenance (Ex. Chimney Replacements) - Equipment + Components Maintenance - Influent Sampler East WWTF 5,000 Equipment+ Components Maintenance- Drain Lift Station East WWTF 602-49450-302 $ 25,000 ENGINEERING FEES 34,670 59,670 602-49450-306 $ 5,900 $ PERMITS & FEES 1,450 7,350 602-49450-320 $ 3,225 TELEPHONE 1,920 450 960 630 15 0% Allocation Allocation) 25,000 lGeneral Sewer Engineering (Permit Review, Odor Mitigation, Instrumentation) 13,103 1 Hakanson Anderson - 85th Street & Maciver Avenue Forcemain Extension 1,112,000 TAE2S - East Solids Project Design 1,897 1 Rounding Contingency+ Inflationary Factor 1,152,000 5,900 MPCA - Municipal Permit Annual Fee -East WWTF 1,450 MPCA -Municipal Permit Annual Fee -West WWTF - East/ West WWTF Permit Renewal 0 $ 3,225 Employee Cell Phones ($55 x 5) + Replacement Phones ($1,000) - Allocated 75% 62,000 1,920 CenturyLink Internet+ Phone Lines at Facilities ($160 Per Month) 450 Answering Service ($75 Monthly) - Allocated 50% 72,000 630 IPAD's ($35 x 2) - Allocated 75% $ 1,000 602-49450-225 $ 1,000 Clothing Allowance = $400 x 5 Ope UNIFORMS/CLOTHING ALLOWANCE 375 375 Boot Allowance = $150 x 5 Operate 75 150 Clothing Allowance = $150 x 2 Sea! 30 60 Boot Allowance = $60 x 2 Seasonal 1,480 1,585 602-49450-302 $ 25,000 ENGINEERING FEES 34,670 59,670 602-49450-306 $ 5,900 $ PERMITS & FEES 1,450 7,350 602-49450-320 $ 3,225 TELEPHONE 1,920 450 960 630 15 0% Allocation Allocation) 25,000 lGeneral Sewer Engineering (Permit Review, Odor Mitigation, Instrumentation) 13,103 1 Hakanson Anderson - 85th Street & Maciver Avenue Forcemain Extension 1,112,000 TAE2S - East Solids Project Design 1,897 1 Rounding Contingency+ Inflationary Factor 1,152,000 5,900 MPCA - Municipal Permit Annual Fee -East WWTF 1,450 MPCA -Municipal Permit Annual Fee -West WWTF - East/ West WWTF Permit Renewal 0 $ 3,225 Employee Cell Phones ($55 x 5) + Replacement Phones ($1,000) - Allocated 75% 1,920 CenturyLink Internet+ Phone Lines at Facilities ($160 Per Month) 450 Answering Service ($75 Monthly) - Allocated 50% 960 Land Line Telephone Service ($80 Monthly) 630 IPAD's ($35 x 2) - Allocated 75% 15 Rounding Contingency+ Inflationary Factor 7,200 1 7,200 X:\Budget\2019\Utility Funds\2019 UTILITY BUDGETS INPUT 602 -Detail City of Otsego Enterprise Fund Budget - 2019 Detail of Line Item Requests Sanitary Sewer Utility Requested Budget Budget Account No. & Description 2017 2018 602-49450-360 EDUCATION /TRAINING/ CONFERENCE 1,600 3,520 602-49450-390 $ 44,000 CONTRACTED SERVICES 41,020 2,455 4,000 1,700 2,100 6,514 4,500 4,000 2,500 1,211 114,000 602-49450-402 $ REPAIR / MAINT BUILDINGS 602-49450-501 $ 17,000 EQUIPMENT 10,000 Electrical 23,000 2,200 Lawn Services - Spraying Pavement Management 4,500 Equipment inspections / Testing - Generators 5,000 Collection System Repairs 2,500 Mechanical - Heating & Air Conditioning 40,000 119,000 $ 100,000 602-49450-590 REHABILITATION & REPLACEMENT 50,000 150,000 Item Detail 2,066 IMinnesota Municiapl Utilities Association - Citywide Safety Training (16 Total Visits) 2,000 10perator Certification Licensing and Training ($400 x 5 Operators) SEWER - 4 Comments $ 44,000 East & West WWTF Permit Required Certified Lab Analysis 43,573 Locates (Hakanson) - Based on 2017 & 2018 YTD Monthly Average + 5% 4,924 Locates (Gopher One) - Based on 2017 & 2018 YTD Monthly Average 10,000 Electrical 1,700 Security Monitoring (2 WWTF) + Parts & Maintenance 2,200 Lawn Services - Spraying Pavement Management 4,500 Equipment inspections / Testing - Generators 5,000 Collection System Repairs 2,500 Mechanical - Heating & Air Conditioning 603 Rounding Contingency+ Inflationary Factor 119,000 $ WAS Level Sensors - Equipment, Installation and Instrumentation ISerial port controllers have meet life expectancies and will be 28,000 Lift Station #1- Pump Replacement (#2 Replaced in 2018 /#1 Budgeted for 2019) replaced with PLCs with ethernet capabilities matching recent 25,000 Lift Station #1- Programmable Logic Controller radio installations to provide fast and reliable operations $ 100,000 Ongoing investment for costs of R&R as identified in Wastewater Treatment Master Plan. - East WWTF - Pretreatment Mechanical Air Unit Replacement 100,000 East WWTF - Odor Control Unit Replacement 30,000 East WWTF - Pretreatment Channel Rehabilitation 50,000 WestWWTF- AeratorGearBoxReplacement 280,000 X:\Budget\2019\Utility Funds\2019 UTILITY BUDGETS INPUT 602 -Detail City of Otsego, Minnesota Capital Improvement Plan 2019 thru 2028 PROJECTS BY FUNDING SOURCE Source # Priority 2019 2020 2021 2022 2023 2024 602 - Sanitary Sewer Utility East WWTF - Dewatering & 602-2020-01 nla Chemical Stabilization Lift Station #3 - Pump Replacement 602-2021-01 nla West WWTF Liquids Capacity 602-2024-01 nla Expansion Lift Station - W2 District 602-2026-01 nla 602 - Sanitary Sewer Utility Total GRAND TOTAL SEWER - 5 2025 2026 2027 2028 Total 12,228,000 12,228,000 45,000 45,000 1,000,000 1,000,000 25,260,000 27,260,000 100,000 800,000 900,000 12,228,000 45,000 1,000,000 1,000,000 25,260,000 100,000 800,000 40,433,000 12,228,000 45,000 1,000,000 1,000,000 25,260,000 100,000 800,000 40,433,000 Monday October 15, 2018 City of Otsego Sewer Utility Fund Cash Flow Summary r Revised: October 16, 2018 Rate Increase 307,860 3.00% 4.00% 8.00% 5.00% 5.00% 3.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% Base Charge $ 9.12 $ 9.48 $ 10.24 $ 10.75 $ 11.29 $ 11.63 $ 11.86 $ 12.10 $ 12.34 $ 12.59 $ 12.84 $ 13.10 Consumption Charge $ 5.65 $ 5.88 $ 6.35 $ 6.67 $ 7.00 $ 7.21 $ 7.35 $ 7.50 $ 7.65 $ 7.80 $ 7.96 $ 8.12 Estimated Bill (Sk Gallons) $ 37.37 $ 38.88 $ 41.99 $ 44.10 $ 46.29 $ 47.68 $ 48.61 $ 49.60 $ 50.59 $ 51.59 $ 52.64 $ 53.70 - - Actual Forecast Budget I 42,250 53,000 - - Projected - 2,618,608 $ - - - 3,898,683 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 Operating Revenues 443,912 - - 45,000 - - 100,000 800,000 - - - - 150,000 Sewer Sales $ 1,672,342 $ 1,818,825 $ 1,928,137 $ 2,024,544 $ 2,125,771 $ 2,189,544 $ 2,233,335 $ 2,278,002 $ 2,323,562 $ 2,370,033 $ 2,417,434 $ 2,465,782 Charges for Services 140,766 - - - - - - - - - - - - Penalties and Interest 166,790 65,276 59,805 66,000 66,000 66,000 66,000 66,000 66,000 66,000 66,000 66,000 66,000 Other - - - - - - - - - - - - - Subtotal 3,067,871 1,737,618 1,878,630 1,994,137 2,090,544 2,191,771 2,255,544 2,299,335 2,344,002 2,389,562 2,436,033 2,483,434 2,531,782 Nonoperating Revenues Investment Interest (Net) Other Transfers In Tota I Expenses Personal Servcies Supplies Services & Other Charges Depreciation Capital Outlay Capital Outlay (General) Capital Outlay (Fleet) Capital Outlay (CIP) Capital Outlay (R&R) Transfers Out Transfers Out - Debt Service Transfers Out - Jet Vac Total Cash Balance - Beginning Balance Sheet Effects Revenues Expenditures Noncash - Depreciation Cash Balance - Ending 10,000 - 6,449 9,884 8,356 - - - - - - - - - - - 1,762,423 1,888,514 1,994,137 2,090,544 2,191,771 2,255,544 2,299,335 2,344,002 2,389,562 2,436,033 2,483,434 2,531,782 314,583 307,860 346,580 356,977 367,687 378,717 390,079 401,781 413,835 426,250 439,037 452,208 134,062 155,358 169,254 172,639 176,092 179,614 183,206 186,870 190,607 194,420 198,308 202,274 531,224 495,790 1,633,254 518,314 528,680 539,254 550,039 561,040 572,261 583,706 595,380 607,287 912,688 995,000 1,015,000 1,035,300 1,056,006 1,077,126 1,098,669 1,120,642 1,143,055 1,165,916 1,189,234 1,213,019 99,353 - - - - - - - - - - - - 42,250 53,000 - - 1,627,444 $ - 2,618,608 $ - - - 3,898,683 Percentage of Cash Reserve on Hand 83,231 - 35,250 35,250 94.30% 26,250 - 300,000 36,000 38,430 269.41% 443,912 - - 45,000 - - 100,000 800,000 - - - - 150,000 280,000 250,000 250,000 300,000 300,000 325,000 350,000 375,000 400,000 425,000 116,281 119,880 128,821 132,686 136,666 140,766 144,989 149,339 153,819 158,434 163,187 168,082 100,000 166,790 166,790 166,790 166,790 166,790 166,790 166,790 147,590 106,262 63,360 - 39,200 38,400 32,800 - - - - - - - - - 2,247,391 2,998,471 3,825,499 2,667,956 2,762,171 2,782,267 2,860,022 3,011,462 4,071,167 3,045,987 3,086,936 3,067,871 658,681 1,064,866 949,909 133,547 591,435 1,077,041 1,627,444 2,165,426 2,618,608 2,080,058 2,636,021 3,221,753 (21,535) 1,762,423 1,888,514 1,994,137 2,090,544 2,191,771 2,255,544 2,299,335 2,344,002 2,389,562 2,436,033 2,483,434 2,531,782 (2,247,391) (2,998,471) (3,825,499) (2,667,956) (2,762,171) (2,782,267) (2,860,022) (3,011,462) (4,071,167) (3,045,987) (3,086,936) (3,067,871) 912,688 995,000 1,015,000 1,035,300 1,056,006 1,077,126 1,098,669 1,120,642 1,143,055 1,165,916 1,189,234 1,213,019 $ 1,064,866 $ 949,909 $ 133,547 $ 591,435 $ 1,077,041 $ 1,627,444 $ 2,165,426 $ 2,618,608 $ 2,080,058 $ 2,636,021 $ 3,221,753 $ 3,898,683 M SEWER - 6 Comments 2019 Budget - Then 3% Inflation 2019 Budget - Then 2% Inflation 2019 Budget (Less Engineering) - Then 2% Inflation 2019 Budget - Then 2% Inflation DRAFT 2019-2028 CIP DRAFT 2019-2028 CIP (Not inlcuding Bond Projects) Ongoing R&R Investment - Identified in Master Plan Transfer to General Fund - Administrative Functions Transfer to SAC - Pays Interest on 2009A Debt Transfer to Debt Fund 399 - Jet Vac (80%) X:\Budget\2019\Cash Flows\Utility Funds 602 -Sewer Cash Reserve Amounts Operating (3.5 Months of Next Year) $ 604,884 $ 960,432 $ 646,309 $ 660,663 $ 675,348 $ 690,370 $ 705,738 $ 721,460 $ 737,545 $ 754,001 $ 770,837 Capital (100% of Next Year Less Bond Projects) 719,393 333,000 285,250 330,250 300,000 326,250 425,000 1,450,000 411,000 438,430 425,000 Debt Service (100% of Next Year) 205,190 199,590 166,790 166,790 166,790 166,790 166,790 147,590 106,262 63,360 - Total Cash Reserve Recommendation $ 1,529,467 $ 1,493,022 $ 1,098,349 $ 1,157,703 $ 1,142,138 $ 1,183,410 $ 1,297,528 $ 2,319,050 $ 1,254,807 $ 1,255,791 $ 1,195,837 Percentage of Cash Reserve on Hand 69.62% 63.62% 12.16% 51.09% 94.30% 137.52% 166.89% 112.92% 165.77% 209.91% 269.41% M SEWER - 6 Comments 2019 Budget - Then 3% Inflation 2019 Budget - Then 2% Inflation 2019 Budget (Less Engineering) - Then 2% Inflation 2019 Budget - Then 2% Inflation DRAFT 2019-2028 CIP DRAFT 2019-2028 CIP (Not inlcuding Bond Projects) Ongoing R&R Investment - Identified in Master Plan Transfer to General Fund - Administrative Functions Transfer to SAC - Pays Interest on 2009A Debt Transfer to Debt Fund 399 - Jet Vac (80%) X:\Budget\2019\Cash Flows\Utility Funds 602 -Sewer City of Otsego Sewer Access Charge Fund Cash Flow Summary Revised: October 16, 2018 Rate Increase 3.10% 4.10% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% Availability Charge $ 2,382.00 $ 2,480.00 $ 2,505.00 $ 2,530.00 $ 2,555.00 $ 2,581.00 $ 2,607.00 $ 2,633.00 $ 2,659.00 $ 2,686.00 $ 2,713.00 $ 2,740.00 Projected Final Plats - - - - - 106,180 100 100 100 100 100 100 100 100 100 100 Connection Charge $ 7,147.00 $ 7,440.00 $ 7,514.00 $ 7,589.00 $ 7,665.00 $ 7,742.00 $ 7,819.00 $ 7,897.00 $ 7,976.00 $ 8,056.00 $ 8,137.00 $ 8,218.00 Projected Building Permits 1,046,400 1,536,000 64% of Total Debt Service per Amortization 150 150 150 150 150 150 150 150 150 150 64% of Total Debt Service per Amortization Actual Forecast I 1,420,800 1,494,400 1,542,400 1,632,000 Projected 995,200 444,800 460,800 - 64% of Total Debt Service per Amortization - 399,424 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 Revenues SAC Fee Special Assessments Special Assessments (Levied) Investment Interest (Net) Transfer from Operating Total Expenses Debt Service - Principal Debt Service - Interest Debt Service - Fiscal Agent Fee's Capital Outlay Debt Principal (2009A) Debt Interest (2009A) Debt Principal (2010C) Debt Interest (2010C) Transfers to WAC Total Cash Balance - Beginning Balance Sheet Effects Revenues Expenditures Cash Balance - Ending Bonds Payable SEWER - 7 Comments $ 2,526,404 $ 2,608,722 $ 1,377,600 $ 1,391,350 $ 1,405,250 $ 1,419,400 $ 1,433,550 $ 1,447,850 $ 1,462,300 $ 1,477,000 $ 1,491,850 $ 1,506,700 13,716 - - - - - - - - - - - - 63,987 62,113 33,176 32,222 31,267 30,313 64,378 - - - - - - - - - - 106,180 166,790 166,790 166,790 166,790 166,790 166,790 166,790 147,590 106,262 63,360 - Transfer In - Pays Interest on 2009A Debt 2,710,678 2,839,499 1,606,503 1,591,316 1,604,262 1,617,457 1,630,653 1,614,640 1,609,890 1,583,262 1,555,210 1,506,700 1,302,400 6,811,672 7,721,757 7,395,774 7,037,836 6,689,676 6,342,231 5,993,758 5,724,298 5,332,585 Actuals 613,969 Actuals 991 2,839,499 1,606,503 1,591,316 1,604,262 1,617,457 1,630,653 1,614,640 1,609,890 1,583,262 Actuals 45,462 (1,929,414) (1,932,486) (1,949,254) (1,952,422) (1,964,902) (1,979,126) (1,884,100) (2,001,603) (2,017,242) Actuals - - - - - - - 480,000 1,008,000 1,046,400 1,536,000 64% of Total Debt Service per Amortization - 166,790 166,790 166,790 166,790 166,790 166,790 166,790 147,590 106,262 63,360 64% of Total Debt Service per Amortization - 1,363,200 1,420,800 1,494,400 1,542,400 1,632,000 1,696,000 995,200 444,800 460,800 - 64% of Total Debt Service per Amortization - 399,424 344,896 288,064 243,232 166,112 116,336 62,912 30,568 15,667 - 64% of Total Debt Service per Amortization 1,962,822 1,929,414 1,932,486 1,949,254 1,952,422 1,964,902 1,979,126 1,884,100 2,001,603 2,017,242 1,990,110 6,004,384 6,811,672 7,721,757 7,395,774 7,037,836 6,689,676 6,342,231 5,993,758 5,724,298 5,332,585 4,898,605 4,463,705 59,432 2,710,678 2,839,499 1,606,503 1,591,316 1,604,262 1,617,457 1,630,653 1,614,640 1,609,890 1,583,262 1,555,210 1,506,700 (1,962,822) (1,929,414) (1,932,486) (1,949,254) (1,952,422) (1,964,902) (1,979,126) (1,884,100) (2,001,603) (2,017,242) (1,990,110) - $ 6,811,672 $ 7,721,757 $ 7,395,774 $ 7,037,836 $ 6,689,676 $ 6,342,231 $ 5,993,758 $ 5,724,298 $ 5,332,585 $ 4,898,605 $ 4,463,705 $ 5,970,405 $ 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 $ - $ X:\Budget\2019\Cash Flows\Utility Funds 361 -SAC City of Otsego Sewer Utility Fund Cash Flow Summary Revised: October 16, 2018 Capital Update Estimate Construction Inflation Estimate Project $ 38.88 $ Current 3.00% 50.81 $ 52.84 $ East Biosolids 12,280,000 12,724,936 Year of Project Years of Additiona Future Cost West Liquid 22,300,000 23,107,986 1 -Jan -20 1.59 13,340,000 East Liquid 20,750,000 21,501,826 1 -Jan -24 5.59 27,260,000 ENR CCI Index 10681 11068 1 -Jan -35 16.60 35,120,000 ENR Basis 2017 1 -Jun -18 0.00% 0.00% -2.00% Estimated Bill (5k Gallons) $ 38.88 $ 41.99 $ 46.19 $ 50.81 $ 52.84 $ 53.90 $ 54.98 $ 56.07 $ 57.20 $ 58.34 $ 58.34 Rate Increase (Inflation) 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% Rate Increase (Adjustment) 2.00% 6.00% 8.00% 8.00% 2.00% 0.00% 0.00% 0.00% 0.00% 0.00% -2.00% Total Rate Increase 4.00% 8.00% 10.00% 10.00% 4.00% 2.00% 2.00% 2.00% 2.00% 2.00% 0.00% Connection Fee Inflation 4.10% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% New Customers 298 432 250 250 482 400 400 400 400 400 400 Capital Outlay (Fleet) Forecast Budget 35,250 35,250 - 26,250 Projected 300,000 36,000 38,430 Capital Outlay (Current CIP) 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 Sanitary Sewer Fund 1,304,361 1,252,400 1,264,924 1,277,573 2,003,840 2,023,878 2,044,117 2,064,558 2,085,204 2,106,056 2,127,117 Operating $ 1,878,630 $ 2,179,078 $ 2,636,432 $ 3,052,500 $ 3,333,122 $ 3,711,528 $ 4,049,641 $ 4,399,794 $ 4,762,333 $ 5,137,614 $ 5,417,648 Non -Operating 8,382 - - - - - - - - - - Transfers In - - - 906,378 906,530 905,828 - 2,907,761 2,910,225 2,909,273 2,905,365 Bond Proceeds - - 13,340,000 - - - 27,260,000 - - - - SAC Fund - - - - - - - Connection Fees 2,608,722 2,504,800 2,529,848 2,555,146 4,007,680 4,047,757 4,088,234 4,129,117 4,170,408 4,212,112 4,254,233 Investment Interest - - - - - - - - - - - Total 4,495,734 4,683,878 18,506,280 5,607,647 7,340,802 7,759,285 35,397,875 8,528,911 8,932,741 9,349,726 9,671,881 Expenses Personal Servcies 307,860 346,580 353,512 553,255 564,320 575,606 587,118 598,861 717,201 840,036 856,836 Supplies 155,358 169,254 174,199 477,517 504,911 530,113 556,121 582,958 610,646 736,727 771,759 Services & Other Charges 495,790 1,633,254 523,745 614,010 643,761 671,425 699,938 729,323 759,603 876,133 920,129 Depreciation 995,000 1,015,000 1,035, 300 1,056,006 1,077,126 1,098, 669 1,120, 642 1,143,055 1,165,916 1,189, 234 1,213,019 Capital Outlay - - - - - - - - - - - Capital Outlay (General) 42,250 53,000 - - 6,235,770 $ - 8,358,433 $ - - - 6,394,600 Capital Outlay (Fleet) 83,231 - 35,250 35,250 - 26,250 - 300,000 36,000 38,430 Capital Outlay (Current CIP) 443,912 - 12,228,000 45,000 1,000,000 1,000,000 25,260,000 100,000 800,000 - - Capital Outlay (Collection) 1,304,361 1,252,400 1,264,924 1,277,573 2,003,840 2,023,878 2,044,117 2,064,558 2,085,204 2,106,056 2,127,117 Capital Outlay (R & R Plan) 150,000 280,000 250,000 250,000 300,000 300,000 325,000 350,000 375,000 400,000 425,000 Debt Service (Existing) 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 - Debt Service (Projected) - - 195,529 906,378 906,530 905,828 1,384,207 2,907,761 2,910,225 2,909,273 2,905,365 Transfers Out - General Fund 119,880 128,821 131,397 134,025 136,706 139,440 142,229 145,073 147,975 150,934 153,953 Transfers Out - WAC - - - - - - - Transfers Out - Jet Vac 38,400 32,800 - - - - - - - - - Total 6,065,456 6,843,595 18,141,110 7,301,436 9,102,095 9,250,335 34,003,472 10,923,192 11,625,012 11,236,933 9,373,178 Cash Balance - Beginning 7,876,688 7,301,966 6,157,249 7,557,719 6,919,936 6,235,770 5,843,388 8,358,433 7,107,207 5,580,852 4,882,878 Balance Sheet Effects 1,585,400 1,550,174 1,607,823 3,303,840 3,350,128 2,369,117 2,814,558 3,296,204 2,544,486 2,552,117 2,573,388 Revenues 4,495,734 4,683,878 18,506,280 5,607,647 7,340,802 7,759,285 35,397,875 8,528,911 8,932,741 9,349,726 9,671,881 Expenditures (6,065,456) (6,843,595) (18,141,110) (7,301,436) (9,102,095) (9,250,335) (34,003,472) (10,923,192) (11,625,012) (11,236,933) (9,373,178) Noncash - Depreciation 995,000 1,015,000 1,035,300 1,056,006 1,077,126 1,098,669 1,120,642 1,143,055 1,165,916 1,189,234 1,213,019 Cash Balance - Ending $ 7,301,966 $ 6,157,249 $ 7,557,719 $ 6,919,936 $ 6,235,770 $ 5,843,388 $ 8,358,433 $ 7,107,207 $ 5,580,852 $ 4,882,878 $ 6,394,600 Cash Balance Reserve Operating (3.5 Months of Next Y 664,390 344,999 518,819 539,495 559,004 579,077 599,729 651,999 759,450 788,281 817,961 Capital (100% of Next Year Less E 1,585,400 1,550,174 1,607,823 3,303,840 3,350,128 2,369,117 2,814,558 3,296,204 2,544,486 2,552,117 2,573,388 Debt Service (100% of Next Year' 1,965,286 2,144,783 2,858,800 2,871,432 2,884,954 3,089,109 4,538,719 4,539,354 4,508,633 2,905,365 2,903,484 Total Cash Reserve Recommends 4,215,076 4,039,956 4,985,442 6,714,767 6,794,086 6,037,303 7,953,007 8,487,557 7,812,569 6,245,762 6,294,833 Percentage of Cash Reserve on H 173.23% 152.41% 151.60% 103.06% 91.78% 96.79% 105.10% 83.74% 71.43% 78.18% 101.58% SEWER - 8 Comments Assumes Inflation, Rate Adjustments & Customer Growth Assumes Inflation 2019 Budget -Then 2% Inflation 2019 Budget -Then 2% Inflation 2019 Budget (Engineering Reduced) - Then 2% Inflation 2019 Budget - Then 2% Inflation See Fleet CIP (Allocated 75%) See DRAFT 2019-2028 CIP Assumed at 50% of SAC Revenue Based on Master Plan Based on Existing Bond Issues Based on Master Plan General Fund - Administrative Functions (Inflates 3%) Transfer to Debt Fund 399 - Jet Vac (80%) X:\Budget\2019\Cash Flows\Utility Funds Combined Sewer & SAC City of Otsego Sewer Utility Fund Cash Flow Summary Revised: October 16, 2018 Capital Update Estimate Construction Inflation Estimate Project $ 38.88 $ Current 3.00% 49.87 $ 53.86 $ East Biosolids 12,280,000 12,724,936 Year of Project Years of Additiona Future Cost West Liquid 22,300,000 23,107,986 1 -Jan -20 1.59 13,340,000 East Liquid 20,750,000 21,501,826 1 -Jan -30 11.59 32,550,000 ENR CCI Index 10681 11068 1 -Jan -56 37.61 65,360,000 ENR Basis 2017 1 -Jun -18 0.00% 0.00% 0.00% Estimated Bill (5k Gallons) $ 38.88 $ 41.21 $ 45.33 $ 49.87 $ 53.86 $ 57.63 $ 58.78 $ 59.95 $ 61.15 $ 62.38 $ 63.62 Rate Increase (Inflation) 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% Rate Increase (Adjustment) 2.00% 4.00% 8.00% 8.00% 6.00% 5.00% 0.00% 0.00% 0.00% 0.00% 0.00% Total Rate Increase 4.00% 6.00% 10.00% 10.00% 8.00% 7.00% 2.00% 2.00% 2.00% 2.00% 2.00% Connection Fee Inflation 4.10% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% New Customers 298 432 150 150 232 150 150 150 150 150 150 Capital Outlay (Fleet) Forecast Budget 35,250 35,250 26,250 Projected 300,000 36,000 38,430 Capital Outlay (Current CIP) 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 Sanitary Sewer Fund 1,304,361 1,252,400 1,264,924 1,277,573 751,440 758,954 766,544 774,209 781,951 789,771 797,669 Operating $ 1,878,630 $ 2,138,725 $ 2,587,609 $ 2,936,132 $ 3,267,964 $ 3,657,155 $ 3,836,101 $ 4,020,742 $ 4,211,234 $ 4,407,738 $ 4,610,417 Non -Operating 8,382 - - - - - - - - - - Transfers In - - - 906,378 906,530 905,828 904,243 901,613 902,845 902,840 901,855 Bond Proceeds - - 13,340,000 - - - - - - - - SAC Fund - - - - - - - Connection Fees 2,608,722 2,504,800 2,529,848 2,555,146 1,502,880 1,517,909 1,533,088 1,548,419 1,563,903 1,579,542 1,595,337 Investment Interest - - - - - - - - - - - Total 4,495,734 4,643,525 18,457,457 5,491,278 4,770,844 5,175,064 5,369,189 5,569,161 5,775,137 5,987,280 6,205,755 Expenses Personal Servcies 307,860 346,580 353,512 553,255 564,320 575,606 587,118 598,861 717,201 840,036 856,836 Supplies 155,358 169,254 173,575 476,880 495,006 510,571 526,559 542,983 559,854 674,701 695,807 Services & Other Charges 495,790 1,633,254 521,572 616,198 636,931 655,216 673,977 693,226 712,976 818,568 844,867 Depreciation 995,000 1,015,000 1,035, 300 1,056,006 1,077,126 1,098, 669 1,120, 642 1,143,055 1,165,916 1,189, 234 1,213,019 Capital Outlay - - - - - - - - - - - Capital Outlay (General) 42,250 53,000 - - 5,730,644 $ - 4,614,136 $ - - - 3,411,478 Capital Outlay (Fleet) 83,231 - 35,250 35,250 26,250 300,000 36,000 38,430 Capital Outlay (Current CIP) 443,912 - 12,228,000 45,000 - - - 100,000 800,000 - - Capital Outlay (Collection) 1,304,361 1,252,400 1,264,924 1,277,573 751,440 758,954 766,544 774,209 781,951 789,771 797,669 Capital Outlay (R & R Plan) 150,000 280,000 250,000 250,000 300,000 300,000 325,000 350,000 375,000 400,000 425,000 Debt Service (Existing) 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 - Debt Service (Projected) - - 195,529 906,378 906,530 905,828 904,243 901,613 902,845 902,840 901,855 Transfers Out - General Fund 119,880 128,821 131,397 134,025 136,706 139,440 142,229 145,073 147,975 150,934 153,953 Transfers Out - WAC - - - - - - - Transfers Out - Jet Vac 38,400 32,800 - - - - - - - - - Total 6,065,456 6,843,595 18,138,314 7,302,988 6,832,962 6,949,660 6,930,412 7,550,624 8,216,960 7,794,625 5,889,006 Cash Balance - Beginning 7,876,688 7,301,966 6,116,896 7,471,339 6,715,636 5,730,644 5,054,717 4,614,136 3,775,728 2,499,821 1,881,711 Balance Sheet Effects 1,585,400 1,550,174 1,607,823 1,051,440 1,085,204 1,091,544 1,524,209 1,992,951 1,228,201 1,222,669 1,230,645 Revenues 4,495,734 4,643,525 18,457,457 5,491,278 4,770,844 5,175,064 5,369,189 5,569,161 5,775,137 5,987,280 6,205,755 Expenditures (6,065,456) (6,843,595) (18,138,314) (7,302,988) (6,832,962) (6,949,660) (6,930,412) (7,550,624) (8,216,960) (7,794,625) (5,889,006) Noncash - Depreciation 995,000 1,015,000 1,035,300 1,056,006 1,077,126 1,098,669 1,120,642 1,143,055 1,165,916 1,189,234 1,213,019 Cash Balance - Ending $ 7,301,966 $ 6,116,896 $ 7,471,339 $ 6,715,636 $ 5,730,644 $ 5,054,717 $ 4,614,136 $ 3,775,728 $ 2,499,821 $ 1,881,711 $ 3,411,478 Cash Balance Reserve Operating (3.5 Months of Next Y 664,390 344,183 519,271 534,614 548,576 562,883 577,542 623,585 724,570 744,177 764,278 Capital (100% of Next Year Less E 1,585,400 1,550,174 1,607,823 1,051,440 1,085,204 1,091,544 1,524,209 1,992,951 1,228,201 1,222,669 1,230,645 Debt Service (100% of Next Year' 1,965,286 2,144,783 2,858,800 2,871,432 2,884,954 2,609,145 2,532,571 2,531,974 2,502,200 901,855 900,008 Total Cash Reserve Recommends 4,215,076 4,039,140 4,985,894 4,457,486 4,518,735 4,263,572 4,634,322 5,148,510 4,454,971 2,868,700 2,894,932 Percentage of Cash Reserve on H 173.23% 151.44% 149.85% 150.66% 126.82% 118.56% 99.56% 73.34% 56.11% 65.59% 117.84% SEWER - 9 Comments Assumes Inflation, Rate Adjustments & Customer Growth Assumes Inflation 2019 Budget -Then 2% Inflation 2019 Budget -Then 2% Inflation 2019 Budget (Engineering Reduced) - Then 2% Inflation 2019 Budget - Then 2% Inflation See Fleet CIP (Allocated 75%) See DRAFT 2019-2028 CIP Assumed at 50% of SAC Revenue Based on Master Plan Based on Existing Bond Issues Based on Master Plan General Fund - Administrative Functions (Inflates 3%) Transfer to Debt Fund 399 - Jet Vac (80%) X:\Budget\2019\Cash Flows\Utility Funds Combined Sewer & SAC (SLOW)