The URL can be used to link to this page

Home My WebLink AboutDocuments Presented at the Meeting City of Au bu rn ~-~-,~~ti~-.-`~'~'-c `7 ` VVater Utility Rate Study - 12.12 Scenario ~ Summary capital Projec_s I Priority 1 Capacity Projects 3 PS04 Lea Hill Boosler Pump Station This projecf deleted per C. Lamolhe - d S01 Well #1 Rehahilitation 610,000 2,070,000 2,680,000 5 PS03 Green River Pump Station backup power 280,000 280,000 SOS Intertie Infrastructure 1,090,000 1,090,000 - S04 Water Supply Emergency Intertie 7,000,000 7,000,000 ~ ~Non Capacity Projects 10 D03 SCADA Upgrades 450,000 450,000 1'I R02 Lakeland Hills New Reservoir 530.000 1.810,000 2,340,000 12 PS01 Lal<eland Hills Booster Pimp Station 390.000 1,770,000 2,160,000 13 S07 Well Irspection and Redevelopment Program 500,000 515,000 530,450 546,364 562,754 579,637 3,234,205 14 D01 Annual Distribution Improvements Proyram 50,000 1,100,000 140,000 1,250,000 150,000 1,350,000 4,039,999 15 G01 Facililies Evaluation Study 80,000 80,000 IG D04 Les Gove Waterline Replacement 1,000,000 700,000 1,700,000 17 D05 AWS Sewer - R Street SE Improvemenls 990,000 990,000 18 PS02 Neev Flcademy Boosler Pump Station 580,000 400,000 1,600,000 2,580,000 1q PS07 Academy PS #1 Improvements 250,000 830,000 1,080,000 20 Priority 2 21 Capacity Projects 21 D02 Annual Distribution Improvements Program 109,000 113,000 116,000 119,000 123,000 127,000 707,000 ~2 Non Capacity Projects 23 R01 Lakeland Flills Reservoir Faintfng 700,000 700,000 24 G03 Comprehensive Water Plan Update 160,000 100,000 260,000 502 WeII 94 and Intertie PS Improvements 120,000 500,000 620A00 18 506 Wcll #5 Upgrades This proJecf de.lefed perC. Lamothe - 27 503 Well #7 f3ackup Power 70,000 240,000 310,000 28 G05 M80 Faciliry Improvements (no inflation) 300,000 300,000 29 GOG MIT Master Meters 130,000 400,000 530.000 30 Priority 3 31 Non Capacity Projects 32 DOfi 505 8 Arlerial Utility Improvements 200,000 200,000 200,000 200,000 200.000 200,000 1,200,000 :;3 G02 Rate Stud,v 100,000 48,000 148,000 34 S08 Water Resources Protection Program 21,855 22.510 23,185 23.881 91,431 25 R03 Annual Reservoir R&R Program - - 53.045 54,636 56,275 57.964 221,920 36 Total Capital Projects 4,759,000 8,406,002 11,491,348 4,192.510 2,435,215 3,508,482 34,792,557 17 Gity planned 2010 rPVenue bonds - 4.000,000 - - - - 4,000,000 38 New Revenue f3ond Proceeds - 1,147,584 10,937.388 3,682,536 1,585,084 2,279,216 19,631,808 39 Use of System Development Charges 450,000 472,500 496,125 520,931 546,978 574,327 3,060,861 :0 Use of!(contribulion to) Capital Fund Balance 4,309,000 2,785,918 57.835 (10,957) 303,153 654,939 8,099,889 !1 Total Funding Sources S 4,759,000 $ 8,406,002 $ 11,491.348 5 4,192,510 $ 2.435,215 $ 3,508,482 S 34,792,557 42 % of 2009-14 CIP debt financed 67,9o/ ~ Revenues ~4 P.at^ 4ever,ues Under Ex,siirg Rales S c,031 .07 ~ ' 44,2=19 ~ ~~3~ S ~ ~~c1.052 $ 9,109 67 3 i S',291,867 45 Non-Ftaie Revenues 1,139,193 9.1~1.~53 1.261,295 1,:/5,229 1,284,106 1,292,533 ~ 46 Total Revenues $ 9,170,200 S 9,775,701 5 10,017,229 $ 10,206,281 $ 10,393,779 $ 10,584,400 47 Expenses 48 Cash Operating Expenses $ 7,924,045 $ 8,123.816 $ 8.396,895 $ 8,726,565 S 9,119,985 $ 9,427,757 49 Existing Debt Service 748,354 994,690 994,430 993,726 985,177 983,881 50 Debt Service - City planned 2010 revenue bonds - 167,372 334,744 334,744 334,744 334,744 51 Debt Service - New Revenue Bond Proceeds - 112,063 1.180,113 1,539,717 1,694,503 1,917,071 52 RaLe Funded System Reinvestment - - - 316,451 661.034 979,869 53 Total Expenses $ 8,672,400 $ 9,397.941 $ 10.906,182 $ 11,911,202 5 12,795,443 $ 13.643,321 54 Annual Surplus I (Deficiency) $ 497,801 $ 377,760 $ (688,953) 5 (1,704,921) $ (2,401,664) $ (3.058,921) 55 Net Revenue from Rate Increases - 67,965 605,693 1,202,441 1,864,074 2,596,566 `j5 Net Surplus / (Deficiency) 5 497,801 $ 445.725 $ (283.360) 5 (502.480) $ (537,590) $ (462,355) 57 Percent Increase to SFR bill r~8 Currently authorized 59 Adclitional Proposed _ ,5{) Total percentage increase to SFR bill , 1 Calculated Monthly SFR billing (7.5cco Monthly Increase to SFR bill r'i 3 Days of O&M (target: 00 to 90) 170 186 168 141 De6t Service Coverage - incl SDCs (target: a: least 1.25) 1.86 4.13 1.57 1.57 1.72 1.86 65 SvstemReinves'mentPhasine 0% 0% iCl`Y 20% 30 . , . . . . . . , . . . . . . . . .in: ~ses throi:qh 2010. ~ ~ ~ _ . ~1 r 66 Operating F!and $ 3,697,801 $ 4,143,525 S 3,860,165 $ 3,357,685 $ 2,820,095 S 2.324,652 67 Capilal Fund 3,258.418 553,960 509,974 8`0,13'I 1,229,266 9.618,014 ,,8 Debt Reser~es 1,472,240 1,584,303 2.652,353 3.011.957 3,166.743 3,389,311 69 Total $ 8,428.459 S 6,281,789 $ 7,022,492 $ 7,219,773 $ 7,216,103 $ 7,331,977 r_,o;,~hinadle:,nimumTargelF..alance $ 1,884.318 $ 2,113,731 S 3,341,633 3 3,793,436 T 4,041,165 $ 4,349,410 ! haL~ncr , r. f" ! v lED FY FG~, GROUP ' i4111, Pd~t Jcl 1-. Summa v ` f City ofi Auburn ' Sewer Utility Rate Study - 12.12 Scenario Summary I Capital Projects Priority 1 3 SCADA Telemetry Upgrades $ 849,598 $ 849,598 Repair & ReplacementiSystem Improvement Projects 500,000 154,500 785,066 349,673 1,057,978 1,130,292 3,977,509 Ellingson Pump SIation ReplacemenUUpgrade 796,550 1,133,000 106,090 2,035,640 c Les Gove Area Improvemen,s 610,000 10,300 620,300 Emergency Power Generators 300,000 309,000 318,270 327,818 337,653 1,592,741 Priority 2 Repair & ReplacemenUSystem Improvement Projects 500,000 154,500 785,066 240,400 832,877 1,594,002 4,106,844 'C Dogwood Pump Station Replacement 346,550 154,500 1,591,350 2,092,400 Nl&O Faciliiy Improvements 318,270 318,270 Priority 3 Repair & Replacement associated with Transp Projccts 900,000 927,000 1,827,000 Lea Hill PLu-np Station Decommissioning 470,879 - - - - - 470,875 15 Total Capital Projects $ 5,273,577 $ 2.842,800 $ 3,904,112 $ 917.891 $ 2.228.507 $ 2,724,294 $ 17,891,181 1u New Revenue 8ond Proceeds - 2,435,097 3,543,919 541,386 1,702,851 2,042,595 10,265,849 Use of System Development Charges 200,000 350,000 367,500 385,875 405,169 425,427 7,133,971 Use o(i(contribution to) Capital Fund Balance 5,073,577 57.703 (7,307) (9370) 120.487 250,272 5.491.361 i~~ Total Fundiny Sources $ 5,273,577 $ 2,842,800 $ 3,904,112 $ 917,891 $ 2.228,507 $ 2.724.294 3 17,891,181 % of 2009-14 CIP debt financed 57.4°/a Revenues ?2 Rate Revenues Under Existinc~ Ratas ~ 3 16 5,'~.~ I5~,53~ .~69 ~_48 $ -i 5 C.$ ~1,441,7~~5 ~ -'1,,=;0 5G~ 23 Metro Rate Revenues 10,949.625 11,059,121 12,839,743 14,423,866 16,011,032 16,518,882 24 Non-Rate Revenues 298,750 167,003 143,67G 113,203 85.237 55,798 25 Total Revenues 5 15,034,313 $ 15,411,661 $ 17,252,667 $ 18,892,302 $ 20,537,995 $ 21,105,240 26 Expenses 27 Cash Operating Expenses $ 4,898,935 $ 4,679,605 $ 4,958,273 $ 5,235,059 $ 5,549,243 $ 5,735,386 28 Metro Audit Payment (one time) 991,477 - - - - . 29 Metro wastewater treatment payments 10,949,625 11.059,121 12,839,743 14,423,866 16,011,032 16,518,882 30 Exis[ing Debt Service 264,152 517,485 613,749 612,061 610,373 608,685 31 New Debt Service - 237,790 583,859 636,726 803,011 1,002,473 Rate Funded System Reinvestment - - - 130,368 263,389 376,913 Total Expenses $ 17,104,189 $ 16,494,001 $ 18,995,624 $ 21,038,080 $ 23,237,048 $ 24,242,339 34 Annual Surplus / (Deficiency) $ (2,069,876) $ (1,082,340) $ (1,742,957) $ (2,145,778) $ (2,699,053) $ (3,137,100) :;b Nei Revenue from Rate Increases - 149.253 548.057 1,003,126 1,521,479 2.110,989 36 Net Surplus ! (Deficiency) $ (2,069,876) $ (933,088) $ (1,194,900) $ (1,142,652) $ (1,177,574) $ (9,026,110) 37 Percent Increase to SFR bill 33 Currently authorized ~i ~ • ~ ~ ' , . . . nhil 39 Additional Proposed i~~' , 0 i i' , i i0' , i i 40 Total percentage increase to SFR bill I Y ~ ~ ~ , ~ ~ ~ ~ ~ ~ , ~ ~ ~ • , ~ ~ , , i 1 1 Calculated Monthly 5FR billing 4.~ Monthly Increase to SFR bill over adopted rate -1 Days of O&M (target: 45 to 60) 414 448 335 238 147 60 44 Coverage After Rate Increases - ind SDCs (target: at least 1.25) n!a 0.84 0.76 1.18 1.37 I,66 Sysfem Reinvestment Phasin 0% 0% 0% 10% 20% 30% : C<itili opernting expen~;ey lowererl per adji.istments providrd by M Colemtm: C~ve;:7cac te_;l rnet on a comhined util!ty har,is I Operating Fund W 6 080,"24 ; 5 747,0~7 .i; . tc;=, _ ~ 17 CapI:aIFUnd -4077i:i 36C.1S:, 376.505 52 S,6 5t3 681,69if 08:,380 48 Debt Reserves - 237.790 583.859 636,726 803,011 1,002,473 ,t9 Total $ 7,087,827 $ 6,345,020 $ 5,512,500 $ 4,571,867 $ 3,716,621 $ 3,027,656 50 Combined Minimum Target Balance $ 1,305,955 $ 1,422,896 $ 1,842.362 $ 1,936,769 $ 2,165,838 y 2,415,492 . ' . . . . _ . ; . II' LJ 1( 1R, iJU{D I~~! C . ~ , . ~ City of ,Auburn Stormwater Utility Rate Study - 12.12 Scenario Summary . , . „ , . . t. ' . . . 1 CapitallProjects 2 Priority 1 3 R Stree: SE 5toirndrain Irnprovr.nients `p 77[7,U00 770.000 4 SCADA Telemetry Upgrades 100,000 240,000 340,000 5 White Rrver Storm PS Replacement - Ph 1 300,000 300,000 6 Peasley Canyon Culvert Repiacement 300,000 700,000 1,000,600 7 5torm Drainage Infrastructure RepaidReplacement 400,000 412,000 424,360 437,091 450,204 463,710 2,587,364 3 Relieve Auburn Way S. Flooding - Phase 1 175,000 175,000 9 Relieve 30th Street NE Area Flooding - Phase 1 1,543,000 1.543,000 10 Relieve 30th 5treet NE Area Flooding - Phase 2 1,054,000 1,054,000 11 S. 296th Street South Pond Expansion - Phase 1 453,800 453,800 12 Port of Seattle Mitigaiion Agreement Project 600,000 600000 13 Priority 2 14 1Nhite River Storm PS Replacement - Ph 2 2.200.000 2,200,000 15 M Street NE/Harvey RdBth Str Srorm Draining Improv 100,000 100,000 16 Bypass at 2nd and G street SE 453,000 453.000 17 Relieve Auburn Way S Flooding - Phase 2 1,63$,000 1.635.000 18 West Main Street Upgrade 1,135,000 1.135,000 19 S. 296th Street South Pond Expansion - Phase 2 This projecr scneduled in 2015 - 20 Bry's Cove Pond Expansion - Phase 1 113.000 113,000 2" Bry's Cove Pond Expansion - Phase 2 445,000 445,000 2 ? b1&O Facility Improvements 300,000 300,000 23 Priority 3 24 Artenal Utility Improvements 200,000 206,000 212,180 218.545 225.102 231.855 1,293,682 25 SOS Utility Improvements 500,000 400,000 900,000 26 Les Gove Neighborhood Improvement 175.000 25,000 200,000 27 Regional Drainage Improvement Projects 500,000 500,000 28 W Valley Highway improvement - - 1.500.000 - - - 1.500.000 30 Total Capital Projects $ 2,845,000 $ 4.509,800 $ 4,914,540 S 1,108,636 S 3,353,305 5 2.869.564 5 19,600,846 3' 2010 CYty Planned Revenue Bond - 2,500,000 - - - - 2,500,000 32 New Revenue Sond Proceeds - 4.217,343 381,039 2,460,024 1,826,467 8,884,879 33 Use of System Development Charges "_'OD 000 210,000 220,500 231,525 243,10' 255,256 1,360,393 34 Use ofI(contribution to) Capital Func Balance 2 645.000 1.799 800 476.692 496.072 050.180 787,841 0.855 585 35 Total Funding Sources S 2,845,000 $ 4,509.800 $ 4.914,540 $ 1.108.636 S 3.353.305 S 2,869,564 $ 19,600,846 36 % of 2009-14 CIP debt financed 5$•1% :;,I' J,,_LD ~'-R CII hJC CIP IPJ(=LAI'I' i'i I' ii)'J - .!7 1_: - Rd,f'i:~`JEiIIE!'~TS ;,ND STORf'UR;',If~r,Gi_ ,Nf F:,~STRUCTUii~ Ih9PF:'~;V _~,I""1[~i:UJcCI;;. Revenues ~ I G Rat,- R..v~nuas _ ~1cE.<isting f:ates $ 5,321,000 781, 5 6'?3' 2' $ 6,i57.957 3y Non-RiIFK~v:nu~s 75.000 331 81,024 ~i~lUti 1-,3 874 36.273 40 Total Revenues $ 5,396,000 5 5,765,331 $ 5,883,804 $ 5,985,942 5 6,091,087 S 6,194,230 41 Expenses I 42 Cash Operating Expenses $ 5,246,385 $ 5,007,420 $ 5,062,890 $ 5.266,795 S 5,509,518 ~ 5.701,459 I 43 NPDES Compliance Expenses - 121,400 210,392 203,208 211,336 219,789 44 Existing Debt Service 96,379 346,223 347,263 348,147 346,275 346,951 45 Debt Service - City planned 2010 revenue bonds - 102,583 205,166 205,166 205,166 205,16e 46 Debt Service - New Revenue BonC Proceeds - - 411,829 449,038 689,263 867,620 47 Rate Funded System Reinvestment - - 489,667 643,566 777,664 868,273 48 Total Expenses $ 5,342,764 $ 5,577,626 $ 6,727,206 $ 7,115,919 $ 7,739,221 $ 8,209,258 49 Annual Surplus ! (Deficiency) $ 53,236 S 187,705 $ (843,403) $ (1,129,977) $ (1,648,134) $ (2,015,029) 50 Net Revcnuc irom katc Increases - - 286,715 600,692 94,1.090 1.319.237 51 Net Surplus /(Deflclency) $ 53,236 s 187,705 $ (556,688) $ (529,286J $ (704,044) $ (695.791) 52 Percent Increase to SFR bill 53 Currentiy authorized 54 Adclitional Proposed ' "IIIG nta % 55 Total percentage increase to SFR bill ; 0, ' , I 56 Calculated Monthly SFR billing 0 57 Monthly Increase to SFR bill over adopted rate 0.00 $0.80 $0.77 1041 ' 191 58 Days o( O&M (targrt 30 ko 45) 212 231 186 144 93 45 59 Debt Service Coverage - incl SDCs (targei at I~.ast 1.25) 1 Oi 4.56 3.84 4.69 5.53 661 60 S stem Reinvestmr.nt Phasinq 0 r. 0 40% 50% 609b 70°/, lowcrcd 1>,- nr revOr.ucs undUr e>ci:tirig rates i; ~,rcvioi.i;;lv 2010. 61 O{-erating FL;n-; $ 3.053,236 $ .:3 240,94? $ 2.684.254 S 2,154,968 F.~'450.924 $ 730,017 62 Capit~,l Fund 2,416.OJO 697.192 727.597 893,281 1,043,097 1.174,723 63 De,Lt Reserves - 411.E29 449,038 689 ,26' 867,620 64 Total $ 5,489,326 $ 3.938,134 $ 3.823,680 $ 3,497,288 $ 3,183,284 $ 2,772,360 65 Combined Minimum Target Balance $ 772.379 S 807.814 $ 1,280.662 S 1.343.893 5 1.6z9 502 $ 1,863,025 ~u~~c' balancc cyual lo J.;y.. :OL:M (IA,1 I1r, Li~ll'u:]Iaf1GC II'1CIudCS JCC „VSiciti i_ii e.:.", i.:. :_i IUlii pi-ni"ii;.,l Debt reserves equai to annual revenue bond debt principal PREPARED BY FCS GROUP Auburn Stormwaler Nlodel - 12_9 Summary (425)567-1802 ",2;14",009 948 A"1 Page 1 of 1 I , City of Auburra Water, Sewer and Stormwater Utility Rate Studies - 12_12 Scenarios Combined Utility CIP Spending and Funding Program and Debt 5crvice Cover; qe Tcsi CaIciilotions ~ I ,nnual UP Sprnd!n~; Pl;ui ~ LVater utility y ~~.OOU _ 1' 5 ,43~,21:1 Sewer U:ility 5,273,577 2.842,800 3.90-1,112 M 917,891 2,228,507 2,724,294 17,891.131 Smrrnwatcr Utility 2,845,000 4,509,400 n,q 14,54 o 1,103,63t; 3.353,305 2,369,564 19,600,946 Totai - all utilitics $ 12,877,577 $ 15,758,602 $ 20,310,000 $ 6,219,037 $ 8,017,028 $ 9,102,340 5 72,284.585 Sources of CIP Funding City planned 2010 revenue bonds $ - S 6,500.000 ; 5 ~ - 5 G.500,000 Plew Revewe !iond Proceeds - 3,582,681 18,698,655 4,604,962 5.747,960 6,148,279 38J82.536 Use ot SVStcm Devclopmen[ Chargc, 850,000 1.032,500 1,084,125 1,138,331 1.195,248 1,255,010 6,555,214 U;c w/(contri5iitinn tol Capital Fund 8alanr.r 12.027,577 4,643,421 527,220 475,74ti 1,073,320 1,699,051 20,446.834 Total Funding Sources $ 12,877,577 5 15,758,602 $ 20,330,000 $ 6,219,037 $ 8,017.028 $ 9,102,340 $ 72,284.585 ' . . . . _ . _ - . . . . . . . ' ~.~-c.,..:.. i Expenses - combined utilities i0.010.467 S 78.991.363 $ 31,468,193 5 33.525,403 37.602.274 Cash 0Perating ExPen;es [Bi 5 Fevenuc flond Deb! Service [C) 1,453,215 989,896 2,677,969 3,093.840 3,407,711 3,832,341 kevenuc Rond Cnvrrage Requirement 363,304 247,474 669,492 773,460 851,928 958.085 Total Expcnses 5 31,826,989 $ 30,228,732 $ 34,815,654 $ 37,722,792 ,S 40,660,752 $ 42,393,700 Aliowable revenues - combined utilities Ra!e Revenue after mcreases 5 28.167,570 5 29,762,586 5 33,284.2Z7 S 36,776,977 $ 40,457,089 5 43,260,630 SDC Revrnue 850,000 1,032,500 1,084,72; 1,138,331 1,195.248 1,255,010 Qther Revenue 1,059,193 1,099,008 1,157.70; 1,179,725 1,200,164 ,27.7.O;S InterestFamings AllFunds 815,440 4$8,334 369,;71 317J56 279.780 136,425 Total Revenue (AJ $ 30,892,703 $ 32,382,428 $ 35,894,630 $ 39,411,800 $ 43,132,280 $ 45,974,096 Cakula:ed covrrigc, (after rate increases) I(A-Li)/Cl 0.61 3.43 1..6 5 1.80 1.92 2.18 Revenue bond drtrt service indudes boYh principal and interest. Rate revenue a(ter incrrases indudr previ0usly approved Ci,ry rate adjus;mrnts as mdi[ated in detailcd suppartinp, worksheets. Opera:ing expense, reflect reduccd Ievclc a; indicated in detailed supportinp workshee*.s.