Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
ITEM IV-C-4
WATER UTILITY `D,lV1S1ON MISSION STATEMENT ' ' Provide for the effcient, environmentally sound and safe management of the existing and future water system within Auburn's service area. ' bEPARTMENT OVERViE1X1 The Water.Utility is respansible for providing potable water to Auburn's customers that : meets. or exceeds the r.egulations "and recognized standards of today and into the future by efficiently administering, operating, and- maintaining the water supply system. The utility , will also continue to.enhance its customer service thraugh publit education and information. . A primary responsibility of the utility is implementing the Comprehensive Water Plan. . 2009 & 2010 ACCOMPLiSHMENTS . ■ Completed the update to the Cityof Auburn's Comprehensive Water Plan ' - a Compteted Utility Rate Study` ` ' ■ Completed consiruction of the Les Gove Neighborhood Improvements project 0- Developer construction-of the Lakeland Hills West (aka Terrace View) Booster Pump Station ~ tl Completed design and. construction, of the B Street NW Intertie to l'acoma Pipeline 5 ■ Compieted design of tHe Lakeland Hills 8ooster Pump Station project ~ Completed design of ihe Vilell 1 Improvements project ■ Completed design of the 2009 AC Watermain Replacement project ~ Cotnpletecl SCADA systern design to improve comrriunication between and M&O, and to enhance worker safety and security ■ lnitiated design of the Lakeland Hills Reservoir b project _ lnitiated design of the Academy Booster Pump S#ation pro}ect . ' * lnitiated design of the Well 4 Improvements project = tnitiated design af the Green River Pump Station Emergency Power project ■ Initiated faci}ities evaluation :study ~ lnitiate design of the,Lea HiII PRV S#ation lmprovements project : ~ tnitiate design of the Deduct Meter Replacement project - ~ Coniinued to implement conservation initiatives such as ihe toilet rebate program ~ Continued coordination with .other programs capital impcovement ptans R Continued to replace undersized pipes for fire flow improvements in conjunction wlth • transportatian and utiiity projects . ~ Continued monitoring rystem losses and fixing leaks when found 2011 & 2012 OBJECTIVES lmplement projects and programs identified in the Comprehensive Water Plan ~ lmplement the use of .Cartegraph as a work order management system and continue to develap SOP's for updating databases in Cartegraph and GIS and Springbrook ■ Complete construction of Well .1 lmprovements project , . 1 e Complete construc#ion of the Lakeland Hilis Booster. Pump 5#ation project ■ Complete. construction of the Green River Pump Station Emergency Power projECt ■ Compiete design and cons#ruction of the [:akeland Hills Reseryoir 6 project ~ Complete design and construction ofthe 132^d Ave SE lntertie to Tacoma Pipeline 5 -o Complete design and construc#ion of the Academy Booster Pump Station project a Complete design, and construction of the Lea Hifl PRV Station Improvements. project n Complete design and eonstruction of the Deduct Meter Replacement project ■ Complete utiiity revenue and expense anafysis to determine'if rate adjustments are needed - ° p Continue to upgrade the asset management databases ttirough records evaluat[on and fleld investigation ~ Continue planning and preparation for emergencies including potential fiooding due to Howard Hanson Dam issues ~ s Continue to implement conservation inifiatives ~ ■ Continue coordination with other programs capital improvement'plans ~ Continue to replace understzed pipes for fire flow improvements in conjunction With transportation and utility projects ~ Continue system improvements by monitoring system losses . . ■ Review al6 city properties with Finance & IS to assure:each developed property connected to the system has a water biliing in Spcingbrook artd that ihe status of use is accurately refiected as the occupancy status changes to address issues such as forectosure, fire, meth house,.etc. . ■ Enhance bilting process and policies to ensure consistent revenue collection for the Utilities . , 2: " WATFR Ft1ND • ' . 2071=2012 WORKING GAPITAL BUDGET 2088 2009 2010 2011 2012 Item Aduat Actval Adj Budget Budget Budget Operating Budget Operattng Revenue ' 343,400 Water Sales $ 7,552.844 $ 8,717.191 $ 9,556.800 $ 10.288,400 $ 10,988,000 ' 343.431 . Uametered Water Sates 29,517 26,582 ' 49,300 31,400 33,500 343,433 Water Application 82,082 82,751 106,800 47.100 50,400 343.44 Payback Adm(n Fee 0 0 0 41.500 41.500 Total Opereting Revenue 7.664.443 8.825,924 9.712,900 10.408,400 11J13,400 Operaiing Expense 534.000.10Salaries and Wages (2,036.689) (2.127.253) (2,238,500) (2.242,940) (2,276,900) 534.000.20 Personnel Benefts (795.770) i (648,934) (777J00) (907.650) (1.016,330) 534:000.30 Supplies (243.866) (188J96) (533.600) (516,900) (521,300) 534.000.40 Servtces & Charges (2,410.608) : (2.630.781) (3;507,300) (3,672,890) (3,821,520) . 534A00;50 lnterAovernmen#al 00 0 0 0. 534.000.90 Interfund Aayments tor Services (839,596) (955.548) (679J80) {1,051.750) _ (1,066J00)' 534.000.00 Depreciatton & Amortization (2 098 916) (2,104,554) (2.117 i00) (2.1 17,000) (2,117.000) Total Operatfng Expenses (8.425.445) (8,855.226) (9,852.780) (10,509.130) (I0:819,150) Operating lncome (Loss) (761,002) (29,302) . (139,880) , p00.730) 294.250 Non Operattng Revenue (Exp) 36f,17o lnvestment income 383,491 88.079 120,000 60.000 61,000 369.900 ' Miscellaneous Revenue (Expense) 53,417 92,604 0. ` 0 0.. • 534.100.80 bebt Servlce [nteresi (137 855) (114 306) (645,900) (698.200) (668,100) ' Tota! Non Oper. Rev (Exp) 299,053 66.377 (525,400) (638,200) (607,I00) Net income (Loss) {461,444} 37.075 (665,780) p36.930) (312.850) Add/Dedud Items Not . Affecting Workfng Capftat (W/C) , • 534.801.00 Depreciattan & AmorttzatEon Z098.916 2,104,554 2.717100 2,117.000 2,117.000 , Nef W/C Prom Operattons 1;636;967 2,141.629 1:451,320 1.378.070 1,804,150 Other Resources and Uses Budget . Resourte; Other Than Operattons 337.064 trttertocat Grenis 0 0 0 0 0 396.101 Cantributed Cap-Sys Dev . 639.516 323,764 450.000 450,000 450.000 396.102 Contributed Cap-Area Asses 0 0 0 0 0 396.104 Contributed Cap-Qutside Dev 2,014.367 325.978 0 0 0 382.200 ' Revenue Bond Proceeds 0 0 17,315,100 0 0 397.100 Transferln 0 0 0. 0. 0 399.500 Nei CfianRe in Restricted Asseis. 23.923 112,561 0 Q. 0 399.000 Other Sources . 24,858 65,329 0 _ Q 0 Total Resources 2,702,664 827.632 -17J65,100 450:000 450,000 Uses Other Than Operaiions 590.100.00. Other Uses (2.003,802) (307.478) 0 0 0 590.100.11 [nc In Fixed Assett-Safartes/WaRes (100,972) (141,346) (150.400) (I53.100) (154,700) 590.100.21 Inc iri Fixed Assets-6eneftts (32.917) (94.806) (53,900) (53.500) (54,200) 597.100:55 Transfer Out , (50,000) (166,100) (58.600) (50,000) (50.000) 590.100.63 lnc in Fixed Assets-Improvements (208.456) (173168) 0 Q d 590.100.64 inc In Fixed Assets-Equipment (3A96) (20,484) 0 (227.000) (55,000) 590.100.65 inc In Fixed Assets-Constructfon (711.559) (2J28,258) (7,373,500) (15.571,800) (2,733.600) • 590.100.66 1tic In Fixed Assets•Cepital Lease 0 6 0 0 0 590.100.70!' Debt 5erv(ce Principa! 0332,068) . (639 068) (695,800) (1.263.900) f1,291.300} Total Uses.. (4.442.870) (3 620 808) (8 332 200) (17.318,800) (4.338,800) Net Change In W/C (103 239) l651 548) 10,884,220 (15,49093g) - . f2.084.6501 Beginning W/C 1/1 10.470,266 . 8.081.466 1 - '007 W/C 12131 10,367 027 9,715,479 18,965.686 3474956 1390 30b " Net ChanRe In W/C . 2 Note: lnterfund Paymeni & Servtces indudes $250K for Annex lease - Preliminary lrtdudes ertimated revenue & expensesrelated to 2010 revenue bond tssuance E/Bud07-081 Public Works/NVated 11 SS430.XLS {Working Capitai}. _ 8/30/2010 1:15 PM glWk3heet0bj.rpt Budget Flex Worksheet by Object: Water Fund 430 Page: 20 08/30/2010 1:22PM City of Auburn 430 WATER 7'itle/Object - 2009 Actua/s 2010 Adj Budget 2010 YTp Actuals ° 2011 2012 00 CAFR ONI.Y 05 NET INCREASE RESTRICTED CASH 307,480.00 0.00 66,010.00- 0.00 0.00 06 WORKING CAPITAL 9,715,480:00 2,483,900.00 9,883;770.00 3,474;960.00. 1,390,310.00 Total CAFR.ONLY . 10,022,960.00 2,493,900:00 9,817,760.00 3,474;960.00 1,390,310.00 10 SALARIES & WAGES 11 REGULAR SALARIES & WAGES 2,214,460.00 2,272,900.00 1,386,610.00 2;279,040:00 2,314,600.00 12 OVERTIME , 51,640.00 88;500.00 33,760.00 89,500:00 89,500.00 13 OTHER WAGES 2,990.00 21,500.00. 0:00 27,500.00 . 27,500.00 Total SALARIES & WAGES 2,268;590.00 2,388;900:00 1,420;370.00 2,396,040.00 2,433,600:00 20 PERSONNEL BENEFITS 21 F.I.C.A 168,270.00 822;500.00 106,060.00 ; 168,620:00 171,150:00 22 UNIFORMS 7;980.00 8,500.00 6,640:00 . 9,500.00 10;500.00 23 PENSIONS 153,720.00 0.00 75,270:00 120,920.00 122,770.00 24 INDUSTRIACINSURANCE 34,030.00 0.00 26,730:00 49,480.00 49,460.00 25 MEDICAL & LIFE INSURANCE 464,420:00 0.00 306,280.00 612,630.00 716,650:00 28 IiNEMPLOYMENT CLAIMS 0:00 0.00 7;100!00 0.00 0.00. Total PERSONNEL BENEFITS 828,420.00 831,000.00 525,080.00 961,150:00 1,070,530A0 30 SUPPUES 31 OFFICE & OPERATING SUPPLIES 48,680.00 • 132,700:00 28,340.00 132,700.00 132;800.00` . 35 SMACL TOOLS AND EQUIPMENT . 139,510.00 365,900:00 120;750.00 384,200:00 368;500.00 Tot81 SUPPUES 188,190.00 498,600:00 - 149,090.00 516,900.00 521,300.00. 40 OTHER SERVICES & CHARGES . 41 PROFESSIONAL SERVICES 385000.00 618,800.00 267,660.00 641,340.00 593,300.00 42 COMMUNICA710N 49,520.00 55,500.00 30,600.00 58,400.00 64,320.00 43 TRAVEL 3,200.00 23,600.00 3,070.00 23;500.00 25,800.00 45 OPERATING RENTALS & LEASES 0.00 37,000.00 10,210.00 2,000.00 2,000.00 46 INSURANCE 73,460.00 87,400.00 50;640.00 74,700.00 76,200.00 47 UTIUTIES 748,820,00 1,014,000.00 537,670.00 1,167;000_00 1,343,000:00. ' 48 REPAIRS& AAAINTENANCE 287;540:00 445,800.00 147230.00 456,800.00 462,600.00 49 MISCELlANEOUS • 11083;260A0 1,260,400.00 634;250.00 1,249,350.00 1,254,500.00. Totdl 07HER,SERViCES & CHARGES 2,630.800.00 . ,3;542,300:00 1,681,330.00 3,672,896.00 3,821,520.00 _ 50 INTERGOVERNMENTAUIM'ERFUND - 55 OPERATWG TRANSFERS OUT 166,100.00 58;600.00 58;600.00 50,000:00 50,000.00 Total INTERGOVERNMEtdTAVIN7ERFUND 166,100.00 58,600.00 58;600.00 50,000:00 50;000.00 60 CAPITAL OUTLAY _ . , 63 IMPROVEMEN7S OYHER THAN BUILDING 173,270.00 0.00 62,850:00 ' O.OQ 0.00 • 64 MACHINERY & EQUIFMENT . . 20;480.00 om- 3,42Q;00 56,000.00 55;000.00 65 CONSTRUCTION PROJECTS ` 2,128,940:00 ' 12,377,800.00 704,4201.00 0.00 0.00 Total CA'RA- OUTLAY. 2,322;690.00- 12,377;800.00 : 770.490:00 ~ 56,000.00 ' 55.400.00 70 DEBT SERVICE'PRINCIPAL 72 REVENUE BONDS 203,500:00 260,100:00 0.00 827;800.00856;700•00. 78 INTERGOVERNMENTAL LOAN ~ 435;570:00 435,700:00 435,570.00 435;600.00 435',600.00 . Pa '.0 giwksheetobj.rpt Budget Fiex Worksheet by Object: Water Fund 430 Page: 21 0813012010 1:22PM City of Auburn 430 WATER TifieJObject 2009 Acfuals 2090 Adf Budget 2010 YTD actuals 2011 2012 1'a{g( DEB7 SERVICE PRtNCIpAL 639,070.00 695,800.00 435,570.00 1,263,400.00 1,299,300.00 80 DEBT SERVICE INTERES7 82 REVENUE BOND INTEREST 70,190.00 192,900.00 0.00 62,200.00 53,600.00 83 SPECIALASSESSMENT IN7'ERES7 44,110.00 285,400.00 135,260.00 636,000.00 614,500.00 Total DEBT SERVICE INTEREST 914,300.00 478,300.00 135,260.00 698,200.00 668,100.00 90 INTERFUND PAYMENTS FOR SERVICES 93 EQUIPMEM' RENTAL CHARGE-FUEL 56,430.00 46,400.00 27,340.00 61,100.00 64,200.00 94 Tdle Not Found 20,480.00 0.00 0.00 0.00 0.00 95 INTERFUND OPERA7IN6 RENTALS & LEASES 281,500.00 210,900.00 123,030.00 260,200.00 273,200.00 97 INTERFUND PRINTING SERVICES 48,900.00 7,700.00 4,490.00 8,300.00 8,500.00 98 INTERFUND FACILI7IES 56,800.00 81,880.00 47,760.00 329,300.00 320,900.00 99 INTERFUND IS SERVICES 481,400.00 332,300.00 193,840.00 392,850:00 399,300.00 Total INTERFUND PAYMENTS FOR SERVICES 955,510.00 679,180.00 396,460.00 1,051,750.00 1,066,900.00 Total WATER 20,136,630.00 24,044,380.00 15,393,090.00 14,141,290.00 12,365,760.00 01 Page: 21 glWkSheetObj.rpt ' Budget.Flex Worksheet by. Object: Water Administration - - Page: 1 08/30/2010 1:23PM City of Auburn 430 WATER 00 WATER 534 WATER'UTILITIES 100 ADMINISTRATION Title/Object 2009 Actuals 2090 Adj Budget 2010 YTD Actuals 2011 2092 90 SALARIES & WAGES 11 REGULAR SALARIES & WAGES 683,410.00, 704,300.00 ' 443;670.00 755,530.00 771,570.00 12 OVERTIME 490.00 3,000.00 1,400.00 3,000.00 3,000.00 Total SALARIES & WAGES 683,900.00 707,300.00 445,070.00 758,530.00 7,74;570.00 20 PERSONNEL BENEFITS 21 F.66 :A : ' . 50,350.00 249,800.00 33;080.00 55;840.00 57,810:00 22 UNIFORMS 320:00 1,000.00 170.00 1,000.00 1,000.00 23 PENSIONS 45:910.00, 0.00 23;610A0 40,450.00 41,840.00 24 INDUSTRIAL INSURANCE 7;440.06 0.00 61290.00 12,120A0 12,250:00 25 MEDICAL & LIFE INSURANCE 120,900.00 0.00 84;070.00 165;040,00 193,690:00 • 28 UNEMPLOYMENT Cl.AIMS 0.00. 0.00 2,370.00 0:00 0.00 Tota! PERSONNEL BENEFITS 224;920.00 250,800.00 149;590.00 274;450.00 306,590.00 30 SUPPLIES " 31 OFFICE & OPERATING SUPPI,IES 1,850.00 5;000.00 320:00 5;000;00 5,000.00 35 SMALL TOOLS AND EQUIPMENT 1.720.00 7;000.00 130.00 10,200:00 14,500.00 Total SUPPLIES 3,570.00 12,000.00 450.00 15,200.00 19,506.00 40 OTHER SERVIGES & CHARGES 41 PROFESSIONAL SERVICES 185,550.00 309,500.00 124,260.00 323,200.00 267;400.00 42 GOMMUNICA710N 2,090.00 1,500.00 1,000.00 2,000.00 2,000.00 43 TRAVEC 0.00 4,000.00 20:00 4;000:00 4,000.00 45 OPERATING RENTALS & LEASES 0.00 1,000:00_ 4.00 . 1,000.00 1,000.00 46 INSURANCE 73,46000 87,400:00 50,640.00 74,700.00 76,200.00 49 MISCELLANEOUS 36,340.00 53,900.00 55,750.00 56,000.00 88,100.00 ` Total OTNER SERVICES & CHARGES. 297,440'00 457,300.00 231,670.00, 460,900.00. 408,700.00 50 INTERGOVERNMENT'AUIN7ERFUW D 7otal. INTERGOVERNMENTAL/IN7'ERFUND 0:00 0.00 0.00 0.00 0:00 80 DEBT SERVICE INTEREST ~ 82 REVENUE BOND INTEREST 70,990.00 192.900.00, 0,00 62,200.00 53600.00 - 83 SRECIAL ASSESSMENT INTEREST 44,110.00 35,400.00 35,260.00 636,000.00 614,500.00 Total 'DEBT SERVlCE;INTEREST 114,300:00 228;300:00 35,260.00 698,200.00 , 666;100:00. 90 INTERFUND PAYMENTS FOR SERVICES • 97 INTERFUND PRINTINGSERV{CES 48,900.00 7,700:00 ` 4,490.00 - 81300.00 8,500:00 98 IM'ERFUND FACILf7;lES 56;800.00 81,880.00 . 47;760,00 3291300.00 320;900100 99 1PiTERFUND IS SERVICES 491,400.00 332,300.00 183;840.00, 392;850:00 399,300:00 . `Tofal 1NTERFIIND PAYMENTS+`FOR SERVICES 597;100.00 421,880.00 246,090.00 730,450.00 728,700.00 ~ . . : Pa 9 glWkSheetObj.rpt Budget Flex Worksheet by Object: Water Administration Page: 2 0813012010 1:23PM City of Auburn 430 WATER 00 WATER 534 WATER UTILITIES . Total ADMINISTRATION 1,921,230.00 2,077,880.00 1,108,130.00 2,937,730.00 2,906,160.00 J . Page: 2 glwrkSheet.rpt Water Administration Page: 1 0813012010 1:24PM City of Auburn Account Number 2009 actuals 2010 Adj Budget 2010 XTD Actuals 2011. 2012 430 WA7ER , - 00 WATER ' ~ 534 WATER U71LIl'iES 534:100 ADMINISTRA710N • 534:100.11 REGULAR SALARIES & WAGES 683,410,00 704,300.04 443,670.00 755,530.00 771,570.00 534:100.12 OVERTIME & 07HER':WAGES 490.00 3,000>00 1,440.00 3,000.00 3,000.00 Total SALARIES & WAGES 683,900.00 707,300.00 445,070.00 758,530.00 774,570.00 534.100:21 F.I.CA 50,350.00 249,800.00 33;080.00 55,840.00 57,810:00 534.100.22 UNIFORMS & GLOTHING 320.00 . 1,000.00 . 170.00 1,000:00 1,000.00 534.100.23 PENSIONS 45,910.00 0.00 23,610.00 40,450:00 . 41,840.00 534.100.24 1NOUSTRIAL INSURANCE 7,440.00 0.00 6,290.00 12,120'.00 12,250.00 . 534.100.25 MEDICAL & LIFE INSURAfVCE 120,900.00 0.00 84;070.00 165,040.00 193,690.00 534.100.28 UNEMPLOYMENT CLAIMS 0.00 0.00 2,370.00. 0:00 0.40 Total PERSONNEL BENEFRS 224,920.00 250,800.00 149,590.00 274,450.00 306,590.00 534.100.31 OFFICE & OPERATING SUPPLIES 1,850.00 5,000.00 320.00 5,000,00 5.000.00 • 534.100.35 SMALL 700LS & MINOR EQUIPMENT 9,720.00 7,000.00 130.00 10,200.00 14;500.00 Tot1l SUPPLIES 3,570.00 12,000:00 450.00 15,200.00 19,500.00 534.700.41 PROFESSIONAL SERVlGES 185,550.00 309.500.00 124,260.00 323,200.00 267,400.00 534.100:42 COMMUNICATION 2,090.00.. 1,500.00 1,000.00 2,000.00 2,000.00 534.100.43 TRAVEL 0.00 . 4,000.00 20.00 4,000.00 000.00 534.100.45 OPERATING RENTALS & LEASES 0.00 1;000.00 0.00 1,000:00 1,000.00 534.100.46 INSURANCE 73,460.00 87,400:00 50,640.00 74;700.00 76,200.00 534.900.49 MISCELLANEOUS 36,340.00 53,900.00 55;750.00 ' 56,000.00 58,100.00 Total OTHER SERVICES & CHARGES 297,440.00 457,300:00 _ 231,670.00 460;900.00_ 408,700.00 Tptal INTERGOVERNMENTAUIN7ERFUND 0.00 0.00 - 0.00 0.00 0.00 534.900.82 REVENIIE BOND•IIVTERES7 ' 70,190.00 192,900.00 - 0:00 62,200.00 53,600.00 ~ _ _ Page: 1 glWrkSheet.rpt - - - Water Administration . 2 Page: 0813072010 1:24PM City_ of Aubum Account Number 2009 Acfuals - 209,0 Adj Budget 2010 .YTD Actuals 2019 2012 534.100.83 DEBT SERVICE INTERE$T 44,110.00' . 35;400.00 35,260:00 636,000.00 614;500'.00, Total DE67 SERVICE [NTEREST 114,300.00 . 228;300.00 35,260.00 698,200.00 668,100:00 . 534100s97 INTERFUND PRINTING SERVICES 48,900.00 7,700.00 4,490.00 8,300.00 8,500.00 534.100:98 INTERFUND FACIUTES , 56,800:00 81,880.00 47,760.00 329,300.00 320,900.00 534.i00:99 INTERFUND IS SERVICES 491,40000 332,300.00 193,840:00 392,850.00 . 399,300.00 Total INTERFUND PAYAAENTS FOR SERVICES 597,100.00 421,880.00 246,490.00 730,450.00 728,700.00 Total ADMINISTRATION . 1,921,230:00 2,077,580.00 „ 1,108,130.00 2;937;730.00 2,906,160.00 Total WATER.UTILfTIES 1,921,230.00 2,077,580.90 1,108,930.00 2,937,730.00 21806;160.00 Total WATER . 1;921,230.00 2,077,580.00 1,108,130.00 2,937,730.00 - 2,906,160.00 - Total WATER 1,921,230.00 2,077,580.40 1,908,130.00 2,937,730.00 2,906,160.00 Grand Total 1,921,230.00 2,077,580.00 1,108,130.00 2,937,730:00 2,906.160.00 ~ Page: 2 Budget Detail Report Page: 1 08130/2010 9:37PM City of Aubum 430 WATER 00 WATER 534 WATER UTIUTIES 534.100 ADMINISTRATlON 534.100.10 SALARIES &WAGES , ;g. y:•` f';f..: . 7 - . i . .rfx. i a . - . t.. : ~ r.x -:.ir mr !{?~y., i . :1.t~:, . r. : r , . :.:W , .._v__:- :r ~:a:u:.l:..~_:~::. 2010 2011 2012 1 Overtime- Engineering 3,000.00 1 Overtime- Engineering 3,000.00 1 Qvertime- Englneering 3,000.00 Une Items Total 3,000.00 Line Items Total 3,000.00 Line Items Total 3,000.00 Change in Budget 0.00 Chaoge in Budget 0.00 534.100 20 PERSONNEL BENEFI7S t F Pt< - F ~"t r I f ~i a r 1 r.ft,i 1 I tF i- • - t t i . 2010 " 2017 2012 1 Uniforms 1,000.00 i Uniforms 1,000.00 1 Uniforms , 1,000.00 Une Items Total 1,000.00 Une Items Total 1,000,0p Une Items Tolal 1,000.00 Change in Budget 0.00 Change in'Budget 0.00 534.100.30 SUPPLIES . 'S341;00 31 :;OFFICE„$~f,OPERATiNG;SUP.,PLIES a2010 2011 2012 1 Office Supplies-Engineering 5,000.00 1 Office Supplies-Engineering 5,000.00 7 Office Supplies-Engineering 5,000.00 Une Items 7otal 5,000.00 line Items Total 5,000.00 Line items Total 5,000.00 . Change in Budget 0.00 Change M Budget 0.00 f , , r----- „ , :x i+asTx:. 0.0:35 ~:::SMAL•L ,TOOLS...8~sMINOR>~EQUIPMENT.,, 534.,r - . ._..2010 2411 2012 1 Smaif Tools - Engineedng 7,000.00 1 Small Tools - Engineering 5,000.00 1 Small Tools - Engineeflng 5,000.00 Line Items Total 7,000.00 2 Groundwater Monitoring Equipment 5,200.00 2 Groundwater Monitoring Equipment 9,500.00 Une Items Total 10,200.00 Une Items Total 14,500.00 Change in Budget 3,200.00 Change in Budgei 4,300.00 534.100.40 OTHER SERVICES & CHARGES , : . ~ . ~ERVlCES r . _ . K31. '1.00 41 `PROFESSI ON~L, 2010 - • 2019 2012 1 State Auditor Payment 8,600.00 1 State Auditor Payment 10,200.00 1 State Auditor PaymeM 10,400.00 2 Conse►vation Public Education OM-101 19,000.00 2 Conservation Public Education OM-901 19,000.00 2 Conservation Public Education OM-101 20,000.00 (annuai) (annual) (annuaq 3-Water Legal Counsel 60,000.00 3 Water Legal Counsel 20,000.00 3 Water Legal Counsel 20,000.00 4 Rate Study 48,000.00 4 Conservation Technicai Assishance OM-103• 19,000.00 4... Canse►vaUon Technical Assishance OM-103 20,000.00 5 Conservation TQChnical Assistance OM-103 19,000.00 (annuan (annuaQ (annual) 5 Uniditedional Flushing Program 35,000.00 5 Suppiy Evaluatlon 50,000.00 6 Unidirectional Ftushing Program 34,500.00 6 DOE Study 60,000.00 6 Conservation Incentives OM-104 20,000.00 7 DOE Study 60,000.00 7 Suppty Evalua6on 50,000.00 7 Future Regulatory RequiremeMs OM-111 20,000.00 8 N.W. Land & Water 50,000.00 8 Thompson Consultant 60,000,00 (annuaq 9 Thompson Consultant 60,000.00 9 Conse►vation Incentives OM-104 19,000.00 Corrosion Control Monftoring Program 2,000.00 OM-708 10 Conservation tncentives OM-104 19,000.00 9 Annual Hydraulic Model Update & Tasks 70,000.00 ~ o . Pa9e: 1 Budget Detail Report ~ Page: 2 0813012010 1:37PM City of Aubum 430 WATER ~ 00 WATER 534 WATER UTtL.I71ES 534.100 ADMIIVISTRATION 534.100 40 OTHER SERViCES & CHARGES ` ' t --^^--^-rm..!r^ :i 1 '~,..e.'n--~-~r 1 f "r^"t^r t fh ?a V ! s ) •I 534,1004PROFESSIONAL:SERVICES...V_.~.......~....W...~.~.:~._w~,...,,_._..~..,.~;.:.~.::_W~.~>,. ::N<~._.:~.:~.:~,~,~...~,:~:~~~.,~_,...~...::~...:~.w~i:~..~:.~,.:~:-V:..~:..:~.Y.~:,~_ 2010 2011 2012 11 Future Regulatory Requirements OM-111 19,000.00 10 Future Regulatory. Requirements ON1-111 19,000.00 10 Professionat Sen+ices (Engineering) 35,000.00 (annual) ~ (annual) Une Items Tota1 267,400.00 12 Corrosion Control Monitoring Program 1,900.00 11 Corrosion Control Monftoring Program 2,000.00 . OM-t 08 OM-108 13 Annual Hydraulic Modei Update & Tasks 25,000.00 12 Annual Hydraulic Model Update & 7asks 60,000.00 14 Professional Services (Engineering) 5,000.00 13 Professional Services (Engineering) 30,000.90 15 BA# 6 Facilities evaluation study 80,000.00 14 Stage 2 Disinfectant By-Product Ru(e (Plan 75,000.00 16 BA# 7- Reduce budget per 2011-2012 -199,500.00 Devetopment) budget 15 Unidirectional Ftushing Program -35,000.00 Line Items Total 309,500.00 16 QOE Study -60,000.00 17 7hompson Consultant -60,000.00 Line Items Total 323,200,00 Change in Budget 13,700.0011 Change in Budget -55,800.00 ,...-....~r^~^r~ ...m-^• . : t t I ,p, ~T i < <4 . ~ Et"l.f li. k ~ i ~Ts ~ ~ 2010 2011 2012 t Phones 1,500.00 1 Phones 2.000.00 - 1- Phcnes 2,000.00 Line Items Totai 1,500.00 Line Items Total 2,000.00 Line Items Total 2,000.00 Change [n Budget 500.0011 Change in Budget 0.00 ...~-n . .'S?. r:.. . . : . ' k.it . t..- . 'i^".:...,,. .._...'3:i.`a..,i . .6 . .1: ;n~ . , i,~..,n.,,. ,.,..ai., ~ ! rJJ4:~0~~., 1.4.si irt , .L~,. Y .1,.,~at s I~.~iu~~.t .Jt~k~y~1.Y.a~V. ~4',;r~;>!:•a.~ y:.........~~...._....~_....u....ls._....,...:.._.:~........,..~._.:.~,_..~...,_.w.......~..~..........«_..<~~..,.~.,....~..- :.s;:~:~..i.....w_,..:.:.:a~....,......u.Lni».._.k.[.~.~~.........Mw..,,a+w.o....;v.,::~L.u,.l.,iu:i,.'«:~o,.,~.:::s:t'~°` 2010 2011 2012 1 Travel Charges (Engineeting) 4,000.00 1 Travel Charges (Engineering) 4,000.00 1 7ravel Charges (Engineering) 4,000.00 - Line Items Total 4,000.00 line Items Total 4,000.00 Line Items Total 4,000.00 Change in Budget 0.00 Change ln Budget 0.00 , ~ . . . : . 534:10045 :OP_.ERATJNGrREN~'ALS8~LEASES ; ~ ~ ~ y_..~..~._...,..:.~.. ~ E ~~~.u.'..,.'•w::..~.~~,..w,~..~.,,....~.~»~...~.e:,~s~..~.. .~,iL ,;,~,,,,w ~n ~x 2010 2071 2012 1 Large Format Copy Machine 1,000.00 1 Large Forrnat Copy Machine 1,000.00 1 Large Format Copy Nlachine 1,000.00 Line Items Total 1,000.00 Line Items Yotal 1,000.00 Line Items Total 1,000.00 Change In Budget 0.001 Change in Budget 0 00 ...,...l...,...~...__...,r.. . - .~i.... i. .~i-,:•:r::r.,:~r:" -+isrr.r *'~r;--:,~ 534:10046 ,_:IN.SURANCE r, : . f.x _ .w_..~,~J.,.~:~.~,:?~.~ _,._~,~L - U.t~,.r -..,.....w- 2010 ,~,..._....w.......~.,~~..~.~,..~,,....,~._...y,.,..~.~..._.. 2011 2012 . 1 DisVibuted Insurance 87,400.00 1 Distributed Insurance 74,700.00 1 Distributed Insurance 76,200.00 Line Items Total 87,400.00 Une Items 7otal 74,700.00 Line Items Total 76,200.00 Change fn Budget -12,700.00 Change tn Budget 1,500.00 i e I tiz~: ~ -iia ~ .Y; {C n[r~l,S`•'e~txtie_,-iaZ.~.~, ~ F A.,. .;3y 534:10049,: MISCEWNEOUS W~~~~~.~ 2010 2011 2012 1 King County Wght-of-Way permits 1,900.00 1 King Counry Right-of-Way permtts 2,000.00 1 King County Right-of-Way pertniirts 2,100.00 ~ ~ ~ Page: 2 Budget Detail Report Page: 3 08/30/2010 1:37PM City of Auburn 430 WATER 00 WATER 534 WATER UTILITIES 534.100 ADMINISTRATION . 534.100.40 OTHER SERVICES & CHARGES ' f .4t - i 3 I.i • 1 1~ , iY t i ( y.,,t 1 i! ~ t ti ~ 534 ,^100 ,Y-' 49....::MISCEtLANEOUS ,.~...._.~.~:~.~V.,1..~'~.~.~.~..w..~.,_,..~.~.W,.:..;;~...~..~...,.::~,.<~,.. ....~..~,_.ww..._~...~. ~w~.....,~ :,.._.y~.,.~.:::L,..v.y.:,:::~;..,~.<~,.~..~._,.~.~~._.~..w.~.~., . . . 2010 2011 2012 2 Regional Organ'a:ation Dues 46,000.00 2 Regional Organization Dues 47,000.00 2 Regional Organ'ization Dues 48,000.00 3 7raining (Engineering) 6.000.00 3 Training (Engineering) 7,000.00 3 Training (Engineering) 8,000.00 Line Items Total 53,900.00 Line Items Total 56,000.00 Line (tems Total 38,100,00 Change in Budget 2,100.Od Change in Budget 2,100.00 534.100.80 DEBT SERVICE {NTEREST 534``1 0082~~ REVENUEaBOND INTEREST 2010 .M J 2011 J---Y-~ ' 2012 1 05 Refi Revenue Bonds 82,000.00 t 05 Refi Revenue Bonds 62,200.00 1 05 Reft Revenue Bonds 53,600.00 2 10 Revenue Bond issue - Interest 110,900.00 , Une Items Total 62,200.00 Line Items Total 53,600.00 ~ Line Items Total 192,900.00 Change in Hudget -130,700.00 • Change in Budget -8,600.00 77 , , ~ n' s d a.,. { t,~1Y~. l4.:M5~1i , rT. ~ ..s~r$•.~7.r4i(;(•.~e~ S; . . . . x ~t e .fi;i. . 't ~i i ..-..t . t t ..~Vu. y L j•`J 534100.83. rDEBT~SERVICEINTEREST~_...:..' .....,...,,.....„.._J.~.._.....____._._,._~..~.._.._.....~.....~.. s ..~a:L - 2010 ~ 2011 2012 1 99 Pubiic Works 7rust fund loan - Interest 18,300.00 1 99-791-003 Public Works Trust fund loan - 16,400.00 1 99-791-003 Public Works Trost fund loan - 14,600.00 2 01 Public Works Trust fund loan - Interest 13,700.00 Interest . ' Interest 3 02 Public Works Trust fund loan - Interest 3,400.00 2 01-691-006 Publ(c Wodcs Trust fund loan - 12,500.00 2 01-691-006 Public Wodcs Trust fund loan - 11,400.00 Line Items Total Interest Interest 35,400.00 3 02-691-002 Public Works Trust fund loan - 3,100.00 3 02-691-002 Pubflc Works Trust fund loan - 2,800.00 interest Interest 4 2010 Revenue 8ond Interest 604,000.00 4 2010 Revenue Bond interest 585,600.00 Line Items Totai 636,000.00 Line ltems Total • 614,500.00 Change in Budget 600,600.00 Change in Budget -21,500.00 534.100 90 INTHRFUND PAYMENTS FOR SERVICES ~ , S ; 1 ~ , , , ° ,y ~•~.:,t~.w._...._._.._........._._._.::;.~_~._~:~.~. ~,;.~.~..:~~..+..~:~.;.~;x: t;. ,,.,,i ',~•.~''~~•-`..._~~,,s:,,..,.....~... t34:100 97 INTERFUIVDrP.RINTING.SERVICE 2090• ..•_._...__~,________~.v..........._....._.........~_..J._._,..____..~_._,._._,....2011 2012 1 Multimedia Services 7,700.00 1 Multimedia Services 8,300.00 1 Multimedia Services 8,500.00 Line Items 7otal 7,700.00 Line Items Total 8,300.00 Line Items 7otal 8,500.00 Change in Budget 600.00 Change in Budget 200.00 534:100 98 •~INTERFl1ND:FACILITES~~...,.,.._.~...._.._.._.__._.u. A, 2010 2019 ~ 2012 ~ 1 Facilities Senrices 81,880.00 1 Facilities Services 79,300.00 1 Facilities Services 70,900.00 Line Items Total 81,880.00 2 Annex Rent 250,000.00 2 Annex Rent 250,000.00 Line Items Total 329,300.00 Une Items Total 320,900.00 Change in Budget 247,420.00 Change In Budget -8,400.00 __,,.,,r,.,--•-~----°v•----'*' . , . ~ ~ ; :.ri ` i ~ . 1 ~ ft { ~r i . t _1, ~~t, r. .W_,.,.~~_..~.,.~._.~.~....~....~._.,.2070 ..~.,.....w.~.....,...,....,...,~...~. ..~...w..w..~..> 2011 2012 Page: 3 Budget Detail Report Page: 4 08I3012010 1 c37PM CityY of: Auburn 430 WATER • - _ 00 WATER. , 534 . WATER UTILITIES 534.100 ADMINISTRATION' . . 534:100:90. IN7ERFUND PAYMENTS FOR SERV[CES' ' - r^ eT.~•;•"""_"^',"^T"' i~-~ ~ ,C, ~ n t. y i r.. ~4 7 1: • t.ix t 3Tf" ' ~s , 534:1. 0.99. :,1NTEREUNDsl3:SER1/:IC.ES~ :~i ......,....,,.Q..~..................l,.:..._,.....2i..~._ .w. ..................~<c.;,,.._w._.:...,... ..,,....,..,..WU.,_.. .......I~..:a.:u,aet..J....,,.u...iw::-a:~..-.....:.~:~a-W..,f.~..s~,~:..~...~sr..`.:ucW,...u.w.,.~de~...s.wu:u..,.._....w-~,- .~::.cu•.~::i:t:~w.i;s;~xi..~.,:,~s~.a.,~,.~,.v.,i~.. I.. 2011 2012 2010 1 IS Services 332,300.00 1 IS Servlces 392;850.00 1 IS Senrices 398,300.00 Line ltems Total 332,300.00 Line Items Total 392,850.00 Line items Total 399,300.00 - • Change in Budget 60,550.00 ~ Change in'Budget _ 6,450.00 Total Line Items 1,923,480.00 -Total klne ltems 1,908,750.00 Total'Line.ltems • 1,829,000.00, Total Change in Budget 785,270:00 Total Change in Budget `-79,750A0 ~ • . W , , . . Page:. 4 glWkSheetObi.rpt Budget Flex Worksheet.by, Object: Water Finance Admin Page: ~ 08130/2010 1:38PM City!of Auburn - 430 WATER 00 WATER 534 WATER UTILITIES 110- ADMlN GENERAL COST . Title/Object 2009 Actuals 2010 Adj Budget 2010 Actuals 2011 2012 . 10 SALARfES & WAGES 11 REGULAR SALARIES & WAGES 370,800.00 299,600.08 209,740.00 301,680.00 306,880.00 12 OVERTIME 320.00 0:00 600.00 1,000.00 1,000.00 13 OTHER WAGES 2;490.00 0.00 0.00 0.00 0;00 TOtal SALARIES & WAGES. 373,610.00 299,600.00 210,340.00 302,680.00 307,880.00 20 PERSONNEL BENEFITS 21 F.1.C.A 27,200.00 107,300.00 15,590.00 21;910.00 22,300.00 23 PENSIONS 2060.00 0.00 11,040.00 16,020.00 16,300.00 24 INDUSTRIAL INSl1RANCE 1,914.06 0.00 1,360.00 1.,520.00. 1,520.00 25 MEDICAL & LIFE INSURANCE 73;360.00 0.00 42,740.00 74,180.00 86,630.00 28 UNEMPl.OYMENT CLAIMS 0.00 0.00 . 4,730.00 0.00 0.00 TOt81 PERSONNEL BENEFITS 127,430.00 107,300.00 75,460.00 • 113,630.00 126,750:00 30 SUPPUES 31 OFFICE & OPERATING SUPPUES 1,090.00 1,700.00 740.00 1,700.00 1,800.00 35 SMALL TOOLS AND EQUIPMENT 30.00 900:00 0:00 1,000.00 1,000.00 Total SUPPUES 1,120.00 2,600.00 740.00 2,700.00 2,800.00 40 OTHER SERVICES & CHARGES 41 PROFESSIONAL SERVICES 89,060.00 99,000.00 62,460.00 107,840.00 111,000.00 42 COMMLINICATION 20,490.00 ' 20,000.00 12,320.00 22,400.00 24,320A0 43 TRAVEL ' 390.00 1.600.00 340.00 1,500.00 1,600.00 . 49 MISCELIANEOUS 490.00 11,100:00 . 270.00 1,750.00 1,800.00 'r'p}al OTMER SERVICES & CHARGES 110,430.00 131,700.00 75,390.00 133,490.00 138,720:00 60 CAPITAL OUTLAY ' TOtai CAPITAL OU7LAY . 0.00 0:00 0.00 0.00 0.00 . 90 INTERFUND PAYMENTS FOR SERVICES • Tota) INTERFUND PAYMENTSfOR SERVICES 0.00 0.00 - 0.00 0.00 0.00 Total ADMIN GEIVERAL CQST 612,590,00 , 541,200.00 361,930.00 _552,500:00 576,150.00 ~ , 4~k • . Pe% 1 glWrkSheet.rpt Water Finance Admin Page: 1 0813012090 1:26PM ; City of Auburn Account Number 2009 Actuals 2010 Adj Budget - 2010 Actuals 2011 2012 430 WATER 00 WATER . 534 WA7ER UTILITIES 534.110 ADMIN GENERAL COS7 • , ~ 534.110.11 REGULAR SALARIES & WAGES 370,800.00 299,600.00 209,740:00 301;680:00 306;880.00 534.110:12 OVERTiME & OTHER WAGES 320:00 0.00 600.00 1,000.00. 1,000.00 534.110.13 OTHER WAGES 2,490400 0.00 • 0.00 0.00 0.00 Tobtl SALARIES & WAGES 373;610.00 299,600.00 210;340.00 302,680.00 307,880.00 534.110,21 F:I:CA. ' 27,200.00 107,300.00 15,590.00 21,910:00 22,300.00 534.110.23 PENSIONS' , 24,960.09 0.00 79,040.00 . 16,020.00 161300,00 534.110.24 INDUSTRIAL INSURANCE 1,910.00 0.00 1,360.00 1;520.00 1;520.00 534.110.25 MEDICAL 8 UFE INSURANCE 73,360.00 0.00 42,740.00 74,180.00 86,630:00 534.110.28 UNEMPLOYMENT CLAIMS 0.00 0.00 4,730:00 0.00 0.00 Total PERSONNEL BHNEFITS 127,430.00 107,300.00 75,460.00 113,630.00 126,750.00 , 534.110.34 OFFICE 8i OPERATING SUPPCIES 1,090.40 1,700.00 740.00 1,700.00 1,800.00 534.110.35 SMALL 700CS & MINOR EQUIPMENT 30.00_ 900.00 ' 0.00 1,000.00 1,000.00 Total 8UPPUES. 1,120.00 2;600.00. 740,00 2;700.00 2,800.00 534.110.49 PROFESSIONAL SERVICES 89;060.00 99;000.00 62,460.00 107,840.00 111,000.00 534.110.42 COMMUNICATION , 20,490.00' 20,000.00 12,320.00 22,400.00 24,320.00 534:110.43 TRAVEL 390.00 1,600.00 340.00 1,500.00 1,600.00 534.110.49 MISCELtANEOUS 490A0 'I1.,100.00 270.00 1,750.00 1,800.00 Total QTMER SERVICES & CHARGES 110;430.00 131,700.00 75,390.00 '133,490.00 138,720.00 Total CAPf't'AL OUTLAY . 0.00 , 0.00 0.00 0.00 0.00 Total ItJTERFUND PAYMENTS FOR SERVICES 0.00 0:00 0.00 0,00 0.00 C, Page: 1 I glWrkSheet.rpt Water Finance Admin Page: 2 0813012010 1 s26PM City of Auburn - Account Number 2009 Actua/s 2090 Adj Budget 2010 Actuals 2019 2012 Total ADMIN GENERAL COST 612,590:00 549,200:00 369,930:00 : 552,500.00 576,150.00 Total INATER UTILITIES 612,590.00 541,200.00 361,930:00 552,500.00 576,150.00 jptal WATER 612,590.00 541,200.00 361,930.00 552,500.00 576.150.00 Total WA7ER 612,590.00 541,200.00 361,930.00 552;500.00 576,150.00 ;J Grand Total 612,590.00 541,200.00 361,930.00 552;500.00 576,150.00 `Page: 2 rn . , Budget Detail Report Page: 1 0813012010 1:27PM City of Auburn . 430 . WATER 00 WA7ER 534 WATER UTILITIES 534.190 ADMfPI GfiNERAL COST 534.110.10 SALARIES WAGES 534!1:4012_ r..:..u :1.u,x.... ~:•<t. , a- F.l,~..::~e.,`..~.~:'W 2010 • 20192012 1 Oveitime - Finance - Utility Department - 1,000.00 1 Overtime - Finance - Utility Department - 1,000.00 Line Items Total 0.00 Projeds projects Line ltems Total 11000.00 Line ftems Total 1,000.00 Change in Budget 1,000.00 Change in Budget 0.00 534.110.30 SUPPLIES ' m v34.1;10 31 OFFIC 8~E .~:OP,ERATIWG ~._.._.._.._.._._...y..__..._.V.~....~.~..._._._.~_._.._.._._...~~...__.......~._.._......_ .._.._.:..1.~~..._~_ ~l 2010 2091 2012 1 Office Supplies-Finance 1,700.00 1 Otfice Supplies-Finance 1,700.00 1 Office Supplies-Finance 1,800.00 Line Items Total 7,700.00 Line Items Totai 1,700.04 Line Items Total 1,800.00 Change in Budget 0.00 Change in Budget 100.00 t 534.111 2010 2011 2012 1 Smali 7ools - Finance 900.00 7 Small Tools - Finance - replacement - 1,000.00 1 Small 7ools - Finance - replacement - 1,000,00 Line Items Total 900.00 Phone headsets, chairs phone headsets, chairs Line Items Total 1,000.00 line Items Totai 1,000.00 ' Change in Budget 100.00 Change in Budget , 0.00 534.110 40 OT'HER SERVICES & CHARGES .;s { . , ~ « . . 3"4:t10.41' ;;;P_;ROFESS~OhTAL.SERV[CES,.•„ ~ , s., ~Jt.,i <<.: ~~~a:l•z,~~ ~,r u.~ ~',j a,~,.. .:F.:.u::_.._..~~w........,.. 2010 2011 2012 1 Dataprose - Print & Process Utility Bills for 13,000.00 1 CSG (Dataprose) - Print & Process Udlity 10,140.00 1 CSG (Oataprose) - Print & Process Utility 11,000.00 Mailing Bills for Mailing Bills for Maiting 2'PSE - Lockbox Transactions 7,400.00 2 PSE - Lockbox 7ransactions 6,600.00 2 PSE - Lockbox Transactions 6,800.00 3 AMR Program 50,000.00 3 Bank Credit Card Fees 45,500.00 3 Bank Credit Card Fees 46,500.00 4 Bank Card Fees 28,800.00 4 Bank Charges 7,000.00 4 Bank Charges 7,500.00 Line Items Total 99,000.00. 5 Springbrook - Web Upgrade 1,500.00 5 Springbrook - Web Upgrdde 1,500.00 6 Springbrook - programming fix 300.00 6 Springbrook - programming fix 300.00 ' 7 Webchedc fees - escrow es6mates 1,500.00 7 Temporary Help coverage of phones and 5,500.00 8 Legal fees - misc. 300.00 front desk 9 Lien filing fees 30,000.00 8 Webchedc fees - escrow estimates 1,600.00 • 10 Temporary Help coverage of phones and 5,000,00 9 Legal fees - misc. 300.00 front desk 10 Lien filing fees 30,000.00 Line Items Total 107,840.00 Line Items Total 191,000.00 Change tn Budget 8,840.00 ' Change in Budget 3,180.00 . . '~"'i . _ .r , . u. ..s .t i. u tS.f r_. . r s~.•,~ { _ ; .i;+.3l'AtYa t ° ,~......~-.-r-.MU-_.,-- ..T"'.__. ~.d.. . Y~O~., ~34.11042~,:._;C.NI rr..w...~...,...,..w:.._~...._._....._._ 2010 2011 2072 1 Postage for Utility Billing Statements 18,800.00 1 Postage for Utility Billing Statements (CSG) 21,200.00 1 Postage tor Utilityr Biiling Statements (CSG) 23,000.00 2 Phones . 1,200.00 2 Phones - Nextel 1,200.00 2 Phones - Nextel 1,320.00 ~ v ' Page: 1 Budget Detail Report Page: 2 0813012010 1:27PM City of Auburn 430 WATER 00 WATER 534 WATER UTILITIES 534.110 ADMIN GENERAl, COST 534.110.40 OTHER SERVICES & CHARGES -T r r r^rC +*+•-ay^ ^...^^~n.^."}.~"1"""'r"'^~*'^^~,*- ~-.'i'...~."`ii~ 'T :L . ' ' . : - . 534110~42 ~ A, . ..it.;a.....::ia ' e ,...i:n...,..~.<.~.. ~ . -.c,,.,.....::,.ao::.a. ' .,.i....:.7.,~:..• ` - 2010 2091 2012 Line Items Total 20,000.00 Line Items Totai 22,400.00 Line Items Total 24,320.00 Change in Budget 2,400.00 Change in Budget 1,920.00 . , . . ,i t-. 'i _ ' .:i~ ...:i i ..:i . . .i. , ~ . : .1. J. 1 . ' 4 : ~•~51~ ;YH 1 :!f C - ` `L,' Af t~M•.. N:r,T~. ~ : . . 'T :7.1..,,. (r. l.~x,.. .:~.rv„.VJ- I.: ,.d.r . J~... .~:r .4.. 4-. .t„ . l,.J _ ~ I: ~ : ..a „e,. - - n r YU F 1.. `.`:•~I~:' i .~N .i 53411U.43 A ..:TRVE6 2010 2011 2012 1 Travel Charges (Finance) 9,600.00 9 Travel Charges (Fnance) 1,500.00 1 Travel Charges (Finance) 1,600.00 LfneltemsTotal 1,600.00 LineltemsTotal 1,500.00 ~ Lineltems7otal 1,600.00 Change in Budget -100.00 Change in Budget 100.00 ---~--v--~--~ ~ . ~ 9i AN " ' 5341'~10.49 ::MISCEL•LEOUS _ . •::.:.~.~:;~.:~:~,..~:.:::~...~.____,_v_..~._.~.~~::.~.,~_.~.,~~.._..~.x.w..:Y:a:~~,.::~.r:~.:`:•.:..'!, 2010 2011 2012 1 Training (Finance) 1,600.00 1 Training (Finance) 1,500.00 1 Trafning (Flnance) 1,500.00 2 Miscellaneous 9,500.00 2 Springbrook Conference (Einance) 250.00 2 Springbrook Conference (Fnance) 300.00 Line Items Tota1 11,100.00 Llne Items Total 1,750.00 Lina Items Total 1,800.00 Change•in Budget -9,350.00 Change in Budget 50.00 , Total Line Items 134,300.00 Total Line Items 137,190.00 Total Line Items 142,520.00 Total Change in eudget 2,890.00 Total Change [n Budget 5,330.00 _So - PagP• 2 : glWkSheetObj.rpt - Budget FIex;Worksheet by Object: Water.Operations Page: 1 . 08/30/2010 1:27PM City of Aubum _ 430 WATER '00. - WATER . . 534 . WATER UTILITIES. 800 OPERATIONS . Trtle/Object 2009 Actuals 2010 Adj'Budget 2010:YTD Acfrials 2019 2092 00 . CAFR ONLY 01 DEPREGIATION 2,104,550.00 2,117,100.00 1,234;980.00 2,117,004:00 2,117,000.40 Total CAFR ONLY 2,104,550.00 2,1:17;100.00 1,234;980.00 2,117,000:60 2,117;000.00' 10 SALARIES & WAGES . 17 ,REGUTAR SALARIES & WAGES 1,021,230.00 1,118;600A0 ' 642,100:00 11068;730:00 1,081,450.00 12 OYERTIME, • 48,500.00 85;500:00 30;290:00 85,500;00 85;500,00 13 OTHER WAGES 0.00 . 27;500.00 0:00 `27,500.00 271500:00 Total' SALARIES&V1lAGES 1;069,730.00 1,231;600:00' 672;390.00 1,181;730:00 1,194;450.00 20 PERSONNEL BENEFITS 21 F.I.GA ` 80;220.00 411,500.00 50,470:00 80,070.00 81,040:00 - 22 UNIFORfUIS 7,660.00 7,500.00 6,470:00 8,500.00 9,500.00 23 'PENSIONS 72,560.00 0.00 _ 35,700.00 56,750.00 57,430.00 24 1NDUSTRIAL INSURANCE 22,620.00 0.00 17,650.00 33,540.00 33,590.00. 25 MEDICAL & LIFE INSURANCE 248,200:00 0.00 161,620.00 340,710.00 401,430.00 Totdl PERSONNEL BENEFITS • 431,260.00 419,000.00 . 271,910.00 519,570.00 582,990.00 30 SUPPLIES 31 OFFICE & OPERATiNG SUPPLIES 45,740.00 126,000.00 27,280:00 126,000.00. . 126;000.00 35,SMALLTOOLSAND.EQUIPMENT 937,760.00 358,000:00 - 120;620.00 , 373;000:00 373,000.00 Total SUPPUES . 483,500:00 484,000:00 147,900.00 499,000.00 499,000.00 40 OTHER SERVICES & CHARGES - ' 41 PROFESSIONAL SERVICES . . 910,390.00 210,30D,00 80,940.00 210;300,00 214;900.00, ' ' . 42 COMMUNICATION 26,940.00 34,000:00 17;280.00 34;000.00 38;000.00 43 7RAVEL 2,810.00 18,000.04 2,710.00 18.000.00 20;000.00 45 OPERATWG RENTALS & LEASES 0.00 36,000.60 10,210.00 1,000.00 7,000.00 47 U711.171ES 748,820.00 1,,014,000.00 537,670.00 " 1,967,000.00 11343;000.00 48 REPAIRS & MAINTENANCE 287,540.00 445,606.00 147;230.00 456,600.00 462;600.00 49 MISCELLANEQUS'. 43,360.00 45,800.00 13;930.00 42,000.00 45,000.00 Total OTHER SERVICES & CHARGES 1,219,880.00 1,803,700.00 809,970.00 1,928,900.00 2,124400.00 90 INTERFUND PAYMEN7S FOR SERVICES 93 EQUIPMENT RENTAL CHARGE-FUEL 56,430.00 46,400.00 27,340.00 61,100.00 64,200.00 94 Title IVot Found 20,480.00 _ 0.00 0.00 000 0.00 . 95 INTERFUND OPERATING RENTALS & LEASES 281,500.00 210,900:00 123,030.40 260,240.00 273,200:00 _ Total lNTERFUND PAYMENTS FOR SERVICES 358,410.00 257,300.00 150,370:00 " 321,300.00 337,400:00 Tot2il OPERATIONS 5,367,310.00 6,312,700.00 3,287,520.00 6,567,500.00' 6,$55,340i00 ~ c~ . Page: 1 ' glWrkSheet.rpt Water Operations Page: 1 0813012010 1:28PM _ City of Auburn Account Number 2009 Actuals . 2010 Adj•Budget 2090 YTD Acfuats' 2011 2012 430 WATER . 00 WATER - . • 534 WATER UTILITlES . 534.800 OPERA710NS . 534:800.01 DEPRECIA710N , 2,104,550.00 2,117,100.00. 1,234,980.00 2,117,000.00 2,117,000.00 Total CAFRONLY 2,104,550.00_ 2,117,100.00 1,234,980.00 2,117,000.00, 2,117,000.00 , . . 534.800:11 REGl7LAR SALARIES & WAGES 1;021,230.00 1,118,600,00 642.100.00 1,068,730.00 1,081,450.00 534.800.12 OVERTIME & OTFIER WAGES 48,500.00 85,500.00 . 30,290.00 _ 85,500.00 85,500.00 534.800.13 OTWER WAGES 0.00 27,500.00 0.00 27;500.00 27,500.00 . ~ Total . SALARIES & WAGES 1,069,730:00 1,231,600.00 672,390.00 1,181;730:00 1,194;450:00 534.800.21 F.I.C.A. 80,220.00 411,500.00 50,470.00 80,070.00 81,040.00 534.800.22 UNIFORMS & CLOTHING 7,660.00 7,500:00 6,470:00. 8,500.00 8,500.00 534.800.23 RENSIONS ` . 72,560.00 0:00 • 35,700:00 56,750.00 •57,430.00 534:800.24 INDUSTRIAL INSURANCE 22,620.00 0.00 17,650.00 33,540.00 33,590.00 534:800.25 MEDICAL & LIFE INSURANCE 248,200.00 0.00 161,620.00 340,710.00 401,430.00 . ' TOta[ PERSONNEL BENEFITS 431,260.00 419,000.00 271,910.00 519,570.00: 582;990.00 534.800.31 OFFICE & OPERATING SUPPLIES 45,740.00 126,000.00. 27,280.00 126;000.00 ' 126,000.00 534.800.35 SMALL TOOL.S & MINOR EQUIPMENT 137,760.00 358,000.00 ,120;620.00 3731000.00 373,000.00 Total SUPPUES 183,500:00 484,000.00 1471900.00 499;000.00 499,000.00 . 534:800.41 PROFESSIONAL SERVICES . 110,390.00 21.0.300.00 80,940.00 210.300:00 214,900.00 534.800.42 COMMUNICATION 26;940.00 34;000.00 17,280:00 34,000.00 38,000.00 534:800.43 TRAVEL ~ 2,810.00 18;000.00 2,710.00 18,000.00 20,000.00 534.800.45 OPERATING REN7ALS &.LEASES ' 0.00 36;000.00 10.210.00 1,000.00 1,000.40 . 534.800.47 PUBLIG U'i'ILI7Y SERVICE ' 748,820:00 1,014;000.00 537,670.00 1067,000.00 1,343,000U0 534:800.48 REPAIRS & MAIN'iENANCE 287,540.00 445,600:00 147,230.00 456,600.00 462,600.00 534.800.49 MISCELLANEOUS 43,360:00 451800:00 c;13,930.00 , 42;000.00? 45;000.00 N - . 0 Page: 1 91WrkSheet.rpt Wate[' Operatlons Pagec 2 0813012010 1:28PM ` City of Aubum A'ccounfNumber 2009:Acfuals 2010Adj;Budget 2010YLD.Actuals 2011 2012 Total OTHER SERVICES & CHARGES 1,219;860.00 1,803,700.00 809;970.00 1,928,900.00 2,124,500:00 ' - 534;800.93 INTERFUND SUPPLIES 56;430.00 46,400:00 27,340:00 61,100.00 64,200.00 534.800:94 INTSRFUND CAPITAL OUTLAY 20;480.00 0:00 0:00 0.00 0.00 534.800:95 INTRFUND OPER RENTALSILEASES 281,500.00 230,900:00 123;030,00 260,200.00 278;200.00 Total INTERFUND PAYMENTS FOR SERVICES 358;410:00 257,300.00 150,370.00 327,300.00 337,400.00 Total OPERATIONS 5,367,310.00 6,312,700.00 3,287,520.00 6,567,500.00 6,855,340.00 Total WATER UTlLITIES 5,367,310.00 6,312,700.00 . 3;287,520.00 6,567,500.00 6,855;340.00. Total WATER 5,367,310.00 6,312,700:00 3,287,520.00 6.567,500.00 6,855,340.00 Total WATER 5,367,310.00 6,312,700.00 3,287,520.00 6,567,500.00 6,855,340.00 Grand Totat 5,367,310.00 6,312,700.00 3,287;520.00 6,567;500:00 6,655,340.00 r , ~ - . ; . Page: 2 ~ Budget Detail Report ~ Page: 7 08/3012010 1:28PM City of Aubum 430 WATER 00 WATER 534 WA7ER UTILII7ES 534.800 OPERATIONS 534.800.00 CAFR ONI.Y , . . _ . , . r,~ . -mc .^t c 77'. t. . , r : . _ •7.. r""~""^";r. -~~.r.-i:n .:.al .1, .i. q . { ~z ~ :,Lk.n IeAl3f~ •d.}r,~~"1•;Ziri+~'~( 3 t . ~It. •x ~ ~ 1 . ~34i806:01:: ~ ;DEPRECIATION t .-J._..+._..~...........,..._..__r......~, ._~....._:._:.:~.~i:~~_.ua,~~...~...:•.a..,.,....s:,..~..u..... ' '__w....u...""~.._..if.:~ , ...~_.:3..._.u._: . . . ...:.Su::~~j.. u.., aLu:::;~a..+,.~~:.:~:s+:~ - .~:t;cw::i,u1 • . 2010 2011 ' 2012 1 Original budget 2,117,100.00 1 Depreciation • 2,117,000.00 1 Depreciation 2,117,000.00 Line Items Total 2,117,100.00 Une Items 7otal 2,117,000.00 Une Items Total 2,117,000.00 ~ Chartge in Budget -100.00 Change in Budget 0.00 534.800.10 SALARIES & WAGES : f .i.~~su'""'"`"""'°'?r . t 534s800:12.. .~.QVERTIME°8~;07HER~;WAGESe 2090 T 2011 2012 1 Regular Employee Overtime 44,000.00 1 Regular Hmployee OverUme 44,000.00 1 Regular Employee Overtime 44,000.00 2 Standby Pay 41,500.00 2 Standby Pay 41,500.00 2 Standby Pay 41.500.00 Line ltems Tota! 85,500.00 Une Items Total 85,500.00 Line Items Total 85,500.00 Change in Budget 0.007 Change In Budget 0.00 . r -I . ..i~'.t: ..l`3+;.~.4, . ...Y }.h n. 534:800 13 ,;07HER.WAGES: L_..,~_~ ..:..~.,:..v,,, y. x,~:;,,e ,ti. - 2010 2011 2012 1 Temporary Maintenance Staff 27,500.00 1 Temporary Maintenance Staff 27,500.00 1 Temporary Mairttenance Staff 27,500.00 Une Items Total 27,500.00 Une Items Total 27,500.00 Une Items Totai 27,500.00 Change in Budget. 0.00 Change in Budget ' 0.00 534.800.20 . PERSONNEL BENEFITS , . . „ ~ - - t ,.5 .;.i11.. ~_.,;~r 1.. i ~ ~ t:.~ ~I ~ {L tJh Lr .'4 ,y. yi ~ , E r rlt,~ s~ ~ xr ~ ,,,~~s ra~~~nt,,.,F, ~i~~•~= , .:L:.~,w:s.? 201o 2011 2012 1 Un'rforms 7,500.00 1 Unfforms , 8,500.00 1 Uniforms 9,500.00 Line Items 7otal 7,500.00 Une Items Total 8,500.00 Une Items Total 9,500.00 Change in Budget 1,000.00 Change in Budget 1,000.00 534.800.30 SUPPLIES ~ : -Tl~'^'~"""--' ..•--~-~-r . ~ .?---r^rn`..-.c•- x•----~r-~-rt-~^^rr--n+^^-?tr'-?`~-~r--^-.~,~ - . _ . . ~ 5~ 800 31 . ;:OFFICE;:&'Al?.ERANGrSU.PPLIES 2010 ~ 2011 2012 1 Operations Supplies 126,000.00 1 Operations Supplies 126,000.00 1 Operations Supplies 126,000.00 Une Items Total 126,000.00 Line Items Totat 126,000.00 Line ltems Total 126,000.00 Change in Budget 0.00 Change in Budget 0•00 , ,c : 534:800 35 <SMALLa700t.,S;&:::MINOREQUIPII~ENT!~ + s,~:'• ~ ; =..x;u~r,,.,~:,,; ~ . , . ,:,~i? vY I , ~ . t~,,. ,..y 2070 2011 ~ 2012 • 1 Radio Read MeterAddkional Casts 200,000.00 1 Radio Read MeterAddiNonal Costs 200,000.00 1 Radio Read MeterAdditional Costs 200,000.00 2 Small Toois - Operations 113,000.00 2 Small Tools - Operations 113,000.00 2 Smalt Toals - Opera6ons 113,000.00 3 Crew Quarters Upgrade (Fumiture) ~ 10,000.00 3 Crew Quarters Upgrade (Fumfture) 10,000.00 S Pump Station Components 60,000.00 4 Pump Station Components 60,000.00 In the 2010 budget we spent this money on Une Items Total 373,000.00 5 BA# 5 CF Crew quarters upgrades 10,001100 new chairs for aU the crews. 4 Pump Station Components 60,000.00 6 Ju1y Mayor D/C move to rerttais & feases 35,000.00 N Page: 1 Budget Detail Report Page: 2 0813012010 1:29PM City of Auburn 430 WATER 00 WATER 534 WA7ER UTILITIES 534.800 OPERATIONS 534.800 30 SUPPLIES -r -----M--T-.- ----~-~--~---T , ~ ? ; . . 7~ ,..f>,"" rf ii. ~ .1' _ ~ir i 1.~4.u£ `.•~9ti' 77 7 534:800 35..~.::~MALL.TOOLS;~~:,NOR;E4UIP MENT...~.....u.W,..S.uLL,~_w,~..y..,.~~s_.vf....'.:...~_,... 2010 ~ 2019 w ~ 2012 Line ttems Tofal 358,000.00 5 Crew QuaRers Upgrade (Fumiture) -10,000.00 In the 2010 budget we spent this money on new chairs for all the crews. Line kems Total 393,000.00 Change in Budget 15,000.00 Change in Budget 0.00 634.800.40 OTHER SERVICES & CHARGES ~ ~ ~ Jt- 534_800'41 :PROFESSION AL;SERVICESn 2010 2011 2012 9 Chemical Analysis 46,000.00 1 Chemical Analysis 46,000.00 1 Chemical Matysis 50,000.00 2 UCMR - Unregulated Contaminar►t 19,000.00 2 UCMR - Unregulated Contaminant 19,000.00 2•UCMR - Unreguiated Contaminant 21,000.00 Monitoring Rule Monitoring Rule Monftoring Rule 3 Hazardous Waste Disposat 1,300.00 3 Hazardous Waste Disposal 1,300.00 S Hazardous Waste Disposa[ 1,500.00 4 Cathodic Protection Testing 3,500.00 4 Cathodic Protection 7esting. 3,500.00 4- Cathodic Protection Testing 3,900.00 5 Qive Clean/lnspect Facilities 18,000.00 5 Dive CleaMnspect Facilities 18,000.00 5 Dive CleaMnspect FaciliUes 18,000.00 6 Stage 1 Disinfectants/ Disinfedion 14,000.00 6 Stage 1 Disinfectants/ Disinfection 14,000.00 6 Stage 1 Disinfectants/ Disinfection -14,000.00 Byproduct Rule Byproduct Rule Byproduct Rule 7 locating Service 18,000.00 7 Locating Service 18,000.00 Stage 1 Disinfectant is complete. Md now 8 Leak Detection & Repair OM-102 & OM 28,000.00 8 Leak Detection & Repair OM-102 & OM 28,000.00 going to Stage 2 Disinfection -103 -103 7 Locating Service 19,000.00 9 PF2V Maintenance & Repair Program 35,000.00 9 PRV Maintenance & Repair Program 35,000.04 8 Leak Detectian & Repair OM-102 & OM 31,000.00 10 Control Panel lnspection & Maint 10,500.00 10 Controi Panel lnspection & Mafnt 10,500.00 -103 , 11 Vegetation Control 5,000.00 11 Vegetadon Control 5,000.00 9 PRV Maimenance & Repair Program 39,000.04 12 Specialized Training ' 12,000.00 12 Specialized Training 12,000.00 10 Control Panel Inspection & M.aint 11,500.00 . Line Items Total 210,300.00 Line Items Total 210,300.00 ~ 1 Vegetation Control . 5,500.00 12 Specialized Trainiog 12,000.00 13 Stage 2 Disinfection. 16.500.00 Line Items Total 214,900.00 Change in Budget 0.00 Change in Budget 4,600.00 , . . k ~„n.<.,;,' d}T a , ~.;=:.CU,:,: ::......:.-..u: 'e',?;?i , e~,y,. i~ . s, i 1: i I - q~ ~E.-;.,. ~ . F~~~ ' 534:80Q 42 ,COMMUNIC AT ON . • ..~r _.....___i~.~._..._.~.i..~....,,~,~__,.. ..3.. - ~.u..~_._.w_T__ ...~..1.. .._1 ..:...:.....w:.LM...:::;....so: ) i t ~ i_ + - 2010 _y..L.W. 2011 2012 1 Telemetry Data Circuits 19,000.00 1 Telemetry Data Cirwits 19,000.00 1 Telemetry Data Cirwits 23,000.00 2 Cellular Phones & Pagers (M & O) 13,000.00 2 Cellular Phones & Pagers (M & O) 13,000.00 2 Cellular Phones & Pagers (M & O) 13,000.00 3 One Call Line Locator 2,000.00 3 One Caii Llne Locator 2,000.00 3 One Call Line Lxator 2,000.00 Line Items Totai 34,000.00 Line Items Total 34,000.00 I.ine Items Total 38,000.00 Change in Budget D.UO Change in Budget 4,000.00 C34:-..,.~-800..- 'r-;: ~ -r^.- • t : i . i 1 . . . r -t : z }1 t i i il. y J~}i;. ~ ~ i +.t Si t ~ r 2010 2011 2012 1 Travel Charges (M & O Operations) 18,000.00 1 Travel Charges (M & O Operations) 18,000.00 1 Travel Charges (M & O Operations) 20,000.00 N W Page: 2 Budget Detail Repot't Page: 3 08/3012010 1:29PM City of Auburn • 430 WATER 00 WATER 534 WATER UTILITIES 534.800 OPERATIONS 534.800.40 OTHER SERVICES & CHARGES ..e-.:...•. . :I^Ol"r'I Tf'1. ii - w~.ne....vi ...i : fy.. . . , , . . i.e. , r- .__'..^~.7. ..,~.W .~.t,... 2010 . •2011 2072 Line Items Tatat • 1 g,000.40 Line Items 7otai 18,000.00 Line Items Total zi;pp Change in Budget 0.00 Change in Budget 2,000.00 , . ~ , . . . . . . . , . , _ . . . . 54800:45 2040 2011 2012 1 Specialty Repair Equipment (M &O) 1,000.00 1 Speaalty Repair Equipment (M &O) 1,000.00 9 Specialty Repair Equipment (M &O) 1,000.00 2 July Mayor D/C move from small tools & 35,000.00 Une Items Total 1,000.00 Line ftems Total 1,000.00 minor equip. . Line Items Total 36,000.00 Ghange in Budget -35,000.00 Change in Budget 0.00 53 , r.._.-_. . . . i.: t lf~.. e. ,r}„k~F , . . . . - t t _ 4 . . } rz ' t I ~_x .r,.~ . ii -.,I•Sr~ sx,~(!::1~'i.,?,4£' . 4:800:47 CrUTILITI(SERVIGE ...,.u.,,.;:,.a.,..,.....~~..t.~....: , ..:~:~..:.,.,..s;_ ".:;.,~..,..H.~...!...';,..~~.,i,~::~. ~ . v.r._':....:~..;...~:,.~:.a~- ........'__._.y.....~..::....~.~~ 2010 2011 2012 1 Utilities 1,014,000.00 1 Utilities 1,167,000.00 1 Utilities 1,343,000.00 LineltemsTotal 1,014,000.00 LineltemsTotal 1,167,000.00 LineltemsTotat 1,343,000,00 Change in Budget 153,000.00 Change in Budget 176,000,001 , . ------R--r'^""r`-^-' I~ ~ a4`r~ fr ~ ?534:800:48~ 'REPAIRS&.MAfNi'ENANCE , < , _ s, i c; , t, r : , ~ t'.. ~ ~ • !f:.u..:'1:.::.~.v.~~ u-_::;:~..c ~'r.~.d~..~,dl,.,°r,.>s,w," _.~.`..~.._...J,.~._._ . t 'r.i;.....«.. ~...,,...~..,.+..«.....li,?..na._._......~... - - „ iA,.~ .__~._.._~.~...~._,.._...~.~.W._.._.2090 ~ 2011 2012 1 Meter Reading Maintenance Contract 2,600.00 1 Meter Readmg Mairrtenance Contract 2,600.00 1 Meter Reading Maintenance Contract 2,600.00 2 Repair & Maint. - Pumps/Equip 48,000.00 2 Repair & Maint. - PumpslEquip 53,000.00 2 Repair & Maint. - PumpslEqu(p 58,000.00 3 Large Meter Radio Read Retrofrt 100,004.00 3 Large Meter Radio Read Retrofd 100,000.00 3 L.arge Meter Radio Read Retrofit 100,000.00 4 Hot Patch Streef Restoration 195,000.00 4 Hot Patch Street Restoration 195,000.00 4 Hot Patch Sireet Restoration 195,000.00 5 Fence repair 8,000.00 5 Fence repair 9,000.00 5 Fence repair 10,000.00 6 PRV Vauk Repairs 10,000.00 6 PRV Vault Repairs 10,000.00 6 PRV Vault Repairs 10,000.00 7 Large Meter RepairiTesGng OM-9 02/103 55,000.00 7 Large Meter RepairlTes6ng OM-102/103 55,000.00 7 Large Meter RepaidTesting OM-102l103 55,000.00 8 Generator Maintenance 90,000.00 8 Generator Maintenance 15,000.00 8 Generator Maintenance 15,000.00 9 Chlorine Feed & Analyzer Maintenance 17,000.00 9 Chiorfne Feed & Analyzer Mainienance 17,000.00 9 Chlorine Feed & Analyzer Maintenance 97,000.00 ' Line ltems Total 445,600.00 Line Items Total 456,600.00 Une Items Total 462,600.00 Change in Budget 11,666.661 hange in udge 6,000.001 _ _ . , " Y• 5_, t... . W ' . . 12 34:800:49 <:MISCELLi4NEDUSt „ . - = _ ~,...1 r..~. r -u 2010 2011 20 1 Wash St D. O. H. Operating Permit • 8,400.00 1 Wash St D. O. H. OperaOng Permit 9,000.00 1 Wash St D. O. H. Operating Permit 9,500.00 2 Laundry Seroice 7,000.00 2 Laundry Service 7,000.00 2 Staff Operating Pertnits/Certs 9,500.00 3 Staff Operating PerrnitslCerts 8,400.00 3 Staff Operating Permits/CeRs 9,000.00 3 Professtonal Organization Dues 5,000.00 4 Professional Organization Dues 4,000.00 4 Professional Organization Dues 4,500.00 4 Training (M & O) 21,000.00 5 Training (M 8 0) 18,000.00 5 Training (M & 0) 19,500.00 Line Items Total 45,000.00 Line Items Total 45,800.00 6 Laundry Service -7,000.00 • Line Items Total 42,000.00 N • Page: 3 ~ Budget Detail Report Page: a 08I3012010 1:29PM . ~ City of Auburn 430 WATER ~ 00 WATER 534 WATER UTlLITIES 534.800 OPERATIONS ' 534.800.40 OTHER SERVICES 8 CHARGES . . . , . : _ . . r . . ~'._..r"~- _ i: ~.T, 3-'-'` , ; . i::, ; t : 534~s800.49~~..~MISCELLANEOUS ...,:~_~.~„~~..._.w_~._.~..:.~.~._.~._...._.._. _..~.,......~.w...W.~...~~...w_wW..~.::~~~.~..W,.~.~..~,.,....~..~..•~.~..~~w,,..~~,.,.~....~:~:~~.:~s~.,..;::~»w..,~.:. :.~..W::y..:,:~- ~L.....~..,.~.~;< 2010 2011 2012 . Change in Budget 7,800.00 Change in Sudget 3,000.00 534.800.90 INTERFUND PAYMEN7S FOR SERVICES 534: 08 93 ,;INTERFUND'iSUPPUES !1 , ' 'I'.i r` ' ~ ...~r~ .,i . ':f ~:,~~"~tr ;r, ^j .._._.....~...~....+...........o+.....__,...~.~....~ .........~....~..c....~.~u.~_.~..~....-...,.,..,....~w......_....si~.•..-~.,...~..._.~..._v.._....._.~.sLLa:i::li..~~~.i...u..~lu...... ' ( w.. ~ ia.+cwatu{~iG~:.w 9 i+_ul+a'• Y y; ..y 2010 2011 2012 1 Equipment Rentai - Fuel 46,404.00 1 Equipment Rental - Fuel 61,100.00 1 Equipment Ren#al - Fuel 64,200.00 Line ltems Total 46,400.00 Line Items Total 61,100.00 Line Items Total 64,200.00 ' Change in Budget 14,700.04 Change in Budget 3,100.00 . , il !t f.iil i.. ~ I{. ~S', 1 t.i.: T) ~ t.' '.i '1S3.i~i2iFj~?.rR~~.~.t`ll'..~Y.:~1•Y~'.~ 534:8d0'95 ,.,INTRFUND OPER RENTAGS/LEAS~S:: "j . _ .t,..7. f..~ - _•_.~___..._....~.~.~.._.,..~.........,.__.....a..~.~:;u,.:,.~.,....,.:.~..,.~....u~r_... r...,.a,.~:..~..c.......__:~„w_.~.,.._..:.:` .::_.......c...:.,:~.. 2010 ~ 2011 2012 1 Equipment Rental - VehiGes 210,900.00 1 Equipment Rental - Vehfcles 260,200.00 1 Equipment Rental - Vehicles 273,200,00 Line ltems Total 210,900.00 Line Items Total 760,200.00 Line Items Total 273,200.00 Change in Budget 49,300.00 Change in Budget 13,000.00 Total Line Items 4,782,600.00 Total Line Items 4,887,700.00 Total Line ltems 5,200,400.00 Total Change in Budget 205,100.00 Total Change in Budget 212,700.00 N Page: 4 glWkSheetObj.rpt Budget Flex Worksheet by Object: Water -Other Page: 11 0813012090 1:30PM ` City of Auburn 430 WATER ' Title/Objec! 2009 Acfuals 2010 Adj Budget 2090 YTD Actuals 2011 2012 00 CAFR ONLY . • 01 CONTRA.DEPRECIATION 2,104,550:00- 2,1171100:00- 1,234,980.00. 2,117,000:00- 2,117,000.00-. 05 NET INCREASE RESTRICTED CASH 307,480:00 0:00 66,010:00- OAO 0.00 06 WORKING CAPITAL . 9,715,480:00 2,493,900.00 9,883,770:00 3,474,960.00 1,390,310.00 Total CAFR ONLY 7,918,410.00 376;800:00 8,582,780:00 1,357,960.00 726,690.00. 10 SALARIES & WAGES 11 REGULAR SALARIES & WAGES 139,020.00 150,400.00 . 91,100.00 153,100.00 154,700.00 12 OVERTiME 2,330.00 0.00. 1,470.00 0.00 0.00 7otal SALARIES & WAGES 141,350.00 150,400.00 92,570.00 153,100.00 154,700:00 20, FERSONNEL BENEFtTS 21 F.I:G:A 10,500.00 53,900.00 6,920.00 10;800.00 10,000.00 23 PENSIONS 10;290.00 0.00 4,920.00 7,700.00 7,200.00 24 INDUSTRIAL INSURANCE 2,060.00 0.00 1,430.00 2:300.00 2,100.00 25 MEDICAL & UFE INSURANCE 21,960.00 0.00 1700.00 . 32,700.00 34,900.00 Totat PERSONNEL BENEFITS 44,810.00 53,900.00 31,120.00 53,500.00 54,200.00 40 OTHER SERVICES & GHARGES 49 MISCELLANEOUS 1,003,070.00 1,149,600.00 564,300.00 1,149,600.00 1,149;600.00 Total OTHER'SERVICES & CHARGES 1,003,070.00 1,149,600.00 564;300.00 1,149,600.00 1,149,600.00 50 I NTERGOVERNMENTAUI NTERFUND 55 OPERATING TRANSFERS OUT . 166,100:00 58,600.00 58,600.00 50,000.00 50,000.00 TOt2l INT'ERGOVERNMENTAUINTERFUND 166,100.00 58;600.00 58;600.00 ,50,000.00 50,000.00 60 CAPITAL OUTLAY 63 IMPROVEMENTS OTHER THAN BUILDING 173,270.00 0.00 62,650.00 0.00 0.00 64 MACHINERY &,EQUIPMENT 20,480.00 0.00 3,420.00 56,000.00 55,000.00 65 CONSTRUC710N PROJECTS 2,128,940.00 92,377,800.00 704,420.00 0.00 0.00 Total CAPITAL OU7lAY 2,322,690:00 12,377,800.00 770,490:00 56,000.00 55,000.00 70 DE$T SERVICE.PRINCIPAL 72 REVENUE BONOS 203,500.00 260,100.00 6.00. ' 827,800A0 855;700.00 78 INTERGOVERNMENTAL LOAN 435,570.00 435,700.00 435,570.00 435,600.00 435,600.00 1'otal aEBT SERVICE RftINCIPAt 639,070.00 695,800.00 435,570.00 1,263,400.00 1,291,300.00 TOta) WATER 12,235,500.00 14,862,900,00 10,535,430.00 . 4,083;560.00 2,028,110.00 N . . C" Pag- .1 ~ glUUrkSheet.rpt W1t@C -0t1GC . . Page: 1 0813012010 1:31PM ` CityofAuburn ' . , Account Number 2009 Actua/s 2010 Adj Budget 2070 YTA Acfuals 2011 2012 430 WATER - , 00 WATER . 534 WA7ER UTIUTIES , 534:801 CONTRA DEARECIATION, ' 534:801.01 CONTRA DEPRECIATION 2,104,550.00- 2.117,100.00- 1,234,980.00. , 2,117,000.00- 2,117,000.00- Totaf CAFR ONLY 2,104,550.00- 2,117,100.00- 7,234,984:00. 2,117,000.00- 2,117,000.00- 534.801.49 MISCELLANEOUS 1,003,070.00 1,149,600.00 564,300.00 1,149,600.00 1,149;600.00 Total bTHER SERVtCE5 & CHQRGES 1,003,070:00 1,149,600.00 564,300.00 1,149,600.00 1,149,600.00 Taql CONTRA DEPRECIATION 1,101,480.00- 967,500.00- 670;680.00. 9~7,40b.00- 967,400.00-, Total. WATER UTILITIES 1,101,480.00- 967,500.00. 670,680:00. 967,400.00- 967,400.00- . 590 CAPITAL OUi'LAY 590:100 CAPITAL EXPENUI7URES 590:100.05 NETING: ,RESTR(CTED ASSEI'S 307,480.00 0.40 66,010.00- 0.00 0.00 590.100.06 ENDWG 1NORKING CAPITAL 9,715,480:40 2,493,900:00 9,883,770:00 - 3;474,960.00 1;390,310.00 7otal CAFR.ONLY 10,022;960.00 ' 2,493;900:00 9,817,760.00 3;474,960:00 1;390,310.00 590.100:11 REGUCAR SAIARIES & WAGES 139.020:00 150,400.00 91,100.00 153,100.00 154,700.00 590.100.12 OVERTIME & 07HER WAGES 2,330:00 0:00 1;470.00 , 0.00 0.00 Total' . SALARIES & WAGES ' 149,350.00 150,400.00 92,570.00 153,100.00 154,700.00 590.100.21 F.I.C.A. 10.500.00 53,900A0 6,920.00; 10,800.00 10,000.00 ' 590.900.23' PENSIONS 10,290.00 0.00 4,920.00 7;700.00 7,200:00 590;100.24 INDUSTRIAL INSURANCE 2,060.00 0.00 , 1,430:00 2,300.00 21100:00 590:100.25 MEDICAL & LIFE INSURANCE 21,960.00 0.00 • 17,850.00 32,700.00 34,900.00 • Total PERSONNEI BENHFITS 44,810.00 53,900.00 31,720.00 53,500.00 64,200.00 Page: glWrkSheet.rpt Wate1' -Othe1' Page: 2 08J3012010 _ 1:31PM CityofAuburrt Account Number 2009 Acfuals 2010 Adf Sudget 2010 YTD Actua/s 2011 2012. 590.100.64 MACHINERY & EQUIPMENT 20,480.00 0.00 0,00 561000.00 55,000.00 590.100:65 CONSTRUCTION PROJECTS 2,128,260.00 12,377.800.00 704,420.00 0.00 0.00 TOtal CAPITAL OU7LAY 2,148,740.00 12,377;800.00 704,420.00 56,000.00 55,000.00 590.100.72 REVENUE BONDS 203;500.00 260;100.00 0.00 827;80d.00 855,700:00 590.100.78 INTERGOVERNMEIVTAL'LOAW 435;570.00 435,700.00 435,570.00 435,600.00 435,800.00 7'pta) DEBT SERVIGE PRINCIPAI 639,470.00 6950800.00 435;570.00 1,263;400:00 1,291,300.00 Total CAPITAL EXPENDITURES 12,996,930.00 , 15,771,800.00 11,481,4.40A0 5,000,960:00 2,945,510.00 590.101 NON-CAPITAL OUTLAY 590.101.65 CONSTRUCTION PROJEC7S 680.00 0.00 0.00 ' 0,00 . 0.00 Total CAPITAL OUTLAY 680.00 0.00 0.00 0.00 0.00 Total NON-CAPtTAL OUTLRY 680.00 0:00 ' 0.00 0.00 0.00 590.110 ENGINEERING • Total CAP1TAlOUTIAY 0.00 0.00 0.00 0.00 0.00 Total ENGINEERING ' 0.00 0.00 0.00 0.00 0.00 590.800 CAPITAL OUTLAY - M & O Total SALARIES & WAGES 0.00 0.00 0.00 0.00 0.00 Total PERSONNEL BEMEFITS 0.00 0.40 0.00 0.00 0.00 590.800.63 07HER IMPROVEMENTS _ • 173,270:00 0.00 62,650.00 0.00 0.00 590.800.64 MACHINERY & EQUIPMEM" 0.00 0.00 3,420.00 0.00 0.00 Total CAPITAL OUTLAY . 173,270:00 0:00 66,070:00 0.00 0.00 Total CAPITAL OUTLAY - M& O . 773,270.00 0:00 - 66,070.00 0.00 0•00 co Page: 2 ; glWrkSheet:rpt WafeC -Other _ .Page:' 0813012010 1:34PM City of Auburn Account Number 2009 Actuals 2010 AdJBudget 2090 YTD Actuals 2019 2012 TOtal CAPITAL OUTLAY 13,170,880.00 15,771,800A0 11,147,510.00 5,000,960.00 2,945,510A0 597 OTHER FINANCING ` - 597.100 OPERATING TRANSFER OUT 597.1 00.55 OPEFtAT1NG TRANSFER OUT 166,100.00 58,600.00 :58,600.00 501!000.00 50,000.00 Total IN7ERGOVERNMENTAUINTERFUND 166,100.00 58,600.00 58,600.00 50;000.00 50,000.00 Tota) OPERATING 7RAN$FER OU7 166,100:00 58,600.00 58,600.00 50,000.00 50,000.00 Total OTHERFIIJANCING 166,100.00 58,600.00 58;600.00= 50,000.00 - 50,000.00 TOtal WATER - 12;235,500.00 14,862,900.00 10,535,480.00 4,083;560:00 2,028,110:00 Total WATER 12,235,500.00 14,862,900.00 10,535,430.00 4,083,560.00 2,428,110.00 Grand Total 12.235,500.00 14,862,900:00 10,535,430:00 4,083,560.00 2,028,110.00 co . ;Page: 3 Budget Detail Report Page: 1 0813012010 1:31 PM City of Auburn 430 WATER . 00 WATER ' 534 WATER UTILITIES 534.801 CON7RA DEPRECIATION 534.801.00 CAFR ONLY ; . . r r i 4 _ , i .L....,_~..`._ y.,..._ _,::r:_...u._ _...~.~..~::..~_....._:.~..,.a........._..~...,._., 534 801t01 CQNTRA,,DEPRECIATfON . :.,..W...~....._ 2010 2011 2012 1 Original budget -2,117,100.00 1 Depreciation -2,117,000.00 1. Depreciation -2,117,000.00 Line ltems Totai _2,117,140.00 Une Items Total _2,117,000.00 Une Items Total _2,117,000,00 Change in Budget 100.00 Char9e in Budget 0.00 534.801.40 OTHER SER1fICES & CHARGES 77, ~--"T - C ; ~OUS ' ( : s~ t . e ~ . i ti : I . i , {-i .:~(L.tiL 1L ~ 1, :,,~i r r . l f~~`i;~d •.k...!'51 . 5i ~ J~, .::..t ?i: ~a34.801:49 T 2010 2011 2012 1 Taxes 1,149,600.00 1 Taxes 1,149,600.00 1 Taxes . 1,949,600.00 Une Items Total 1,149,600.00 Une Items Total 1,149,60p,pp Une Items Total 1,149,600.00 Change In Budget 0.00 Change tn Budget 0.00 Total Line Items -967,500.00 ' 7ota[ L'sne ltems -967,400.00 ' Total Une Items -967,400.00 Total Change in Budget 100.00 Total Change in Budget 0.00 W O Page: ' 1 Budget Detail Report Page: 1 0813012010 1:32PM City of Aubum 430 WATER 00 WATEFt - 590 CAPITAL OUTLAY • 590.100 CAPI7AL EXPENDITURES 590.100 00 CAFR ONLY , . . 59 00 1 0 06 ENDING-W...:.._.ORKING~CAPITAL ._.._...._........_.._Y ..w ` _W..__._._.,.~.~,..,u_.......,..._...~'ir~~:...~.... -',;~_i.. ~::~.~..y.:,~.~~~a ,t Si: r ~ 'u._'•.~`-,,i';~: 2010 ' 2011 2012 • 1 Original budget 1,356,566.00 1 Estimated Ending Working Capital 3,474,956.00 1 Estimated Ending Working Capital 1,390,308.00 2 BA# 4 Adjust W!C -186,180.00 Line Items Total 3,474,956.00 ' Line Items Total 1,390,306.00 3 BA# 5 Adjust W/C 44,000.00 4 BA# 6 Adjust W/C 1,080,013.00 . 5 BA# 7- Adjust Ending Working Capital 199,500.00 . Line Items Tatal 2,493,899.00 , Change in Budget 981,057.00 Change in Budget -2,084,650.00 590.100.60 CAPITAl.OUTLAY 90:100 1.......- , _ . .....r ~ . _ . . _ . . , 2010 2011 2012 1 Station water analyzers 6 each. 6,000.00 1 Booster MAG Meters 8 each. 30,000.00 Line Items Total 0.00 2 Production MAG meters 7 each. 25,000.00 2 Cyber Locks for water stations. 25,000.00 3 Cyber Locks for water stations. 25,000.00 3 Station water analyzers 6 each 6,000,40 ' Line ifems Total • 56,000.00 4 Station water analyzers 6 each -6,000.00 Line Items Total 55,000.00 Change [n Budget 56,000.00 Change in Budget -1,000.00 . . m z :.1 iY:.:• J-s::,a;._. a ~f.~..f 7 it e» -nt3'- . . r. , f . i.,., 4 . )....:t•. _ .,:.,:..'~Sd:,. e?~~.1.. 1 ,:i :~4 f~. . t.t , r; 6 ?i . , :~CONSTRUCTIQNiPROJECTS~° - 2010 2011 2092 1 Repairs and Replacements 3,086,200.00 2 Improvements 4,392,800.00 Line ltems Totai 0.00 Line ftems Total 0.00 3 Expansion 2,821,600.00 • 4 SA# 5 Carry forward 2009 projects 1,557,200.00 5 BA# 6 move forward from 2011-7acoma . 600,000.00 , pipelfne 5 B Street NW Intertie . 6 BA# 6 Reduce Les Gove Waterline -80,000.00 replacements project cp0762 . Line Items Total 12,377,800.00 Change in Budget 12 377 80Q OD Change in Budget 0.00 T.~ . ' ..c, . 'f.1 - . . yf : IY . T~.k" . . , r . _ . . , . . , 2090 2011 2012 1 Capital Lease 250,000.00 2 Feb Mayor D/C move to object 83 -250,000.00 Line Items Total 0.00 Line items Total 0.00 Line Items Total 0.00 Change in Budget 0.00 Change in Budget 0.00 590.100 70 DEBT SERVfGE PRINCIPAL . 590t10072.::.REVENUE'BQNDS . 2010 - 2099 2012 t . ' ~ Page: 1 ~ Budget Detail Report Page: 2 08l30/2010. 1:32PM City of Auburri 430 WA7ER 00 WATER • 590 CAPITAL OUTLAY 590.100 CAPI7AL BXPENDITURES 590.940.70 DEST SERVICE PRINCIPAL . . (~...~U~ i.;, ..i hit r.u ~.t:841 t S 1h.~lF r-~i.}. .•,At fl-F~1;: ~90,:1 00 72 . . ....:'RE\/E~1.UE'~$ONDS t . >t g :.,u...ra~::s::..x.....r .......:....._.w.;:...~ -•...~,.-•..:m:Ss'.dl.:v.uit....o.::a.-.~,.......~....~w:~.;:e,u wL'v:.,~..w4::,u.~:~,::,:..:,r st 3i~:Li flr~-7 ~tG,. w..w....- ~ a::.~..r~. ............w.....b......e.. . 2010 2011 2012 1 05 Refi Revenue Bonds 203,500.00 1 05 Refi Revenue Bonds 214,600.00 1 05 Refi Revenue Bonds 225,700.00 2'10 Revenue Bond Issue - Principal 56,600.00 2 2010 Revenue Bonds 613,200.00 2 2010 Revenue Bonds 630,000.00 Line Items 7otal 260,100.00 Line Items Total 827,800.00 Line Items Total 855,700.00 Change in Budget 667,700.00 ~ Change in Budget 27,900.00 ~-r~ „ . i . , 1 - :.7.1~.: ! :1 lx ni: 1.: ~ Z 1:. i . . k . •~5t'liy:.Uyi•':l"i': i C, ~4 ' ' t l - y -1'.1tT .'^'r?^ ,-+~t"".r'I'_""!'7 t, ' - u a-. i 3 r. t r i t . f ~„E. , t ,,.t at t ~ ~1. { -1~ ~ r . . . n .,t~~ : x. ~ • , r ~s:;+ ~ i:i(i ",7 r!11.~~F,,, i, r ~.1 f'', ..i.:5 S s:, n~c~ 1~ .f• r~l: ~ 590100 78..._:,..tNTERGOVERNMENTALiyL'OA~.i:....-.~.~'~"_:_.`• ~.L.UiL..~•....-.. ~ ._....._.~.~:L•:.....k..:..t....,...,_ ...~...e..,r.._..s~-=i-_.~_.:i.«J.:~.....us..,_.:r ` }.:...i...~..~....~; tiy.7.r{n~:~!•~.rn~ir:.tl:,r.r~l' .,r.~i1:~~~~1,i~,~~.~~~, „rz~,, ~ : t ~ ;1~~j,~G,.~,.,.~~i~ 2010 2019 2012 1 99 Public Works Trust Fund Loan-Principal 182,400.00 1 99-791-003 Public Wodcs Trust Fund 182,400.00 1 99-781-003 Public Works Tnust Fund 182,400.00 2 01 Public Works Trust Fund L.oan-Prirtcipal 227,100.00 Loan-Principal Loan-Principal 3 02 Pubtic Worlcs Trust Fund Loan-Principal 26,200.00 2 01-691-006 Public Works Trust Fund 227,100.00 2 01-691-006 Pubiic WorCS Trust Fund 227,100.00 Line Items Total Loan-Principal LoaM'rincipal 435,700.00 3 02-691-002 Public Works Trust Fand 26,100.00 3 02-691-002 Public Works Trust Fund 26,100.00 Loan-Prinapal Loan-Principal l.ine items Total 435,600.00 Line Items Total 435,600.00 Change in Budget -100.00 Change in Sudge! 0.00 W ~ p8p@: 2 Budget Detait Report Page; 3 0813012010 1:32PM . City of Auburn 430 WATER 00 WATER • . . 597 OTMER FINANClNG . 597:100. OPERATING'TRANSFER OUT - 597:100.50 INTERGOVERNMBNTALlINTERFUND ~ 3971.00 S5, ? OPERA'I~NG TRAf~SFER 0U7- _~..........t. .....w.....................-. .....»....~.r..u....,..L,_.1:~........,_....~.t.:v ,...,.~.,~..,....,W......w....~..w... „u-......s,.w........_,......... ~ a.~. . f i~:, ~ 7 . S:LVii:J:~1 2010~ 2011 ~ 2012 1 7ransfers out to Fund 103 for Utility Trench 50,000.00 i Transfers out to Fund 103 for Utility Trench 50,000.00 1 Transfers out to Fund 103 far Utility Trench 50,000.00 MiUgation Mitfgation ' MitigaGon 2 BA# S T/O for unemployment costs 8,600.00 Line Items 7otal 50,000.00 Line Items Total 50,000.00 Line Items Total 58,600.00 Change fn Budget -8,600.00 Change [n BudgeY 0.00 7otal L.ine Items 15,626,099.00 Total l.ine Items 4,844,35fi.00 Total Line Items 2,786,608.00 Total Change in Budget -10,781,743.40 Total Change fn Budget -2,057,750.00 ~ ,W 6r? Page: 3 Decision Padcages Approved in First Round of Mayor Meetings Package # Priority Title Additionaf . Funding Non GeneraI Fund. Pro ram Cost Source Fundin +Source Fund . Descri 'on of Fundin Im act 201! 2012 2011 2012 Staffina Other wfR:0001 1 U rade Vactor 258,000 - 171,000 4 0 Usin Fund 430 Water WOr1dn Ca ital 87 000 . 550 lJsin Fund 5 O E ui merrt Rental Work n Ca 1 i 1 Total 258,000 258`800 ca ~ • ' ~ F:1P ` pirectory12411 2012 SudgetlDecision Padcages\Deasion Packages Master Ust.xlsA •ed Water ` • 8130/2010 7:55 gIDPBdgtRpt Decision Package Budget Report 813012010 7:56:29AM City of AuBum . . Date Budget Year Group Version Prioriiy Durafion Approval Status 06/17/2010 2012 . cjordis 1 1 One-T9me Pending Title Vactor Upgrade to a Special trench excavator to match #he type of work our three utility crews need #o pertorm for routine emergency repairs. , Descriqtton of improvement . Our current Vactor is scheduled for replacement in 2011; this request is ta upgrade our vactor from a standard duty machine to a hydro excavator which is a heavy duty machine that is designed to process large abrasive debris such as rock withaut damage to tha suction fan. This feature is not inctuded in a conventional vactor because most users do not at#empt to utilize a conventional vactor to dig trenches. The. befaw website is a youtube presentation of this type of Special Excavator. The cast far the new machine is approximately $550,000 which is considerably higher than the avaifabte $320,000 in the equipment rentat fund for this vactor replacement. The additiona) cast hydro excavator will be offset using the follawing funding sources. • Hydro Excavatar Price $550,000 Vactor Replace (-292,000) Money in ERR Fund 550 6505 Truck not replaced(- 87,000 Money in ERR Fund 550 Amount Remaining , Water Working Capital http:!lwww.youtube.comlwatch?v=yblrtk9CjJg Alternatives The afternative to purchasing the heavy duty hydro sxcavator is to purchase a standard duty vactor. The standard duty vactor is not designed for excavation tasks consequenfly the vactor machinery wears out much faster. This results in extensive down for repairs which reduces work crew production rates. Additionally the repairs often invoive replacing specialized vacuum pump and piping equipment which typically very expensrve. In other words using a standard duty vactor for excavation work results in high maintenance and repair costs and reduces sfaff work efficiencies. Advantaaes of Auproval The goal of this proposal is to obfain the proper #ype of squipment for the type of work intended to be performed. The city's conventional vactors are not designed to excavate trenches even. though using them saves our crews time and ofken avoids damage to other underground utifities when we are involved in an emergency repair of water, sewer or stormfacilities. A vactor is also safer for our crews than digging to expase an underground utility with our back hoes & shovels since the excavation can be near naturaf gas or energized electrical conduits. We have retained one of the city's oldest vactors for this purpose; however, due to its design it is often in the shop and not 100% available as we would expect the new type of excavator to be. Having a better built excavator will help cut down on down time, save money on restoration of other ufliities in the trench and on maintenance of the vactor and will be more efficient on jobs. New hydro excavator trucks are built stronger and are designed to be use as trench excavators. Since this item wiil be used most of #he time by any of the city utilities that need ta perform an emergency trench excavation if it is procured and available, this will extend the useful life of our other three conventional vactors by freeing them of ti7is fype of work that they are not designed to perforrn. Imqlications of Denia( Purchasing a Hydro-Excavator that is designed for excavation will cut down on vehicle repairs and wiil be more efficient on projects. The new Hydro-Excavators are built stronger, more durable and are designed for the work we do with them. Continuing to re(y on older vactors will defer an improvement in productivity that is now made feasibte by this new type of excavator that is intentiona[ly designed for the purpose of performing emergency trench excavatiort. Staffin-ci Narrative Not Defined , 35 gIDPBdgtRpt Deciston Package Budget Report 8130l2090 7:56:29AM Ci#y of Aubum - - ..._..--~.....---,--.z-----........_-,....,- ..-.T.:~~-•.-:-~:<v:-------..T.:-. . - c.,.x.:;~-- UPGRADE-~VA~TOR . Date Budget Year ' . Group Ve_rsion Priority DuratEon Approvaf Status 06117/2010 2012 cjordis 1 1 One-Time - ' Pending Eauiqment Make & Model ~ Narrative Not Defined ' FISCAL DETAILS 2011 . 2012 Capital Expendltures 0.00 . 430.00:596.100.64 MACHINERY & EQUIPMENT ' 171,000.0.0 Total Capital Expenditures 971,000A0 0.00 " Total Expenditures 971 QOOAO 0.00 ' NetBudget 171,000A6O.QO - ; - . - j . , QR TABLE W-2 CAPITAL FACILlT1ES PLAN PROJECTS AND FiNANClNG IIVATHR DIVISION 2611 2012 2093 2044 . 2015 2016 Total . Capacitv Protects: ' 1 Lea Ni[I Booster Pump Station ' Capital Gosts - - - - 260,800 900,000 1,160,000 Funding Sources: Water Fund 284,000 900,000 1;180,000 Bond Proceeds - - - - - - 2 We1i 1 Improvernents . ~ Capital Costs 1,784,400 - - - - - 1,794,400 . : Fundfng Sources: " Water Fund . Bond Proceeds 1,794,400 1,784,400 ; 3 Green River P3 Emergeney Power " Capitai Costs 232,000 , - - - ' 232,000 : Funding Sources: Water Fund - - - - - - - 8ond Proceeds 232,000 - ' ~ - - - - 232,000 4 Jntertie Infrastructure ' Capital Costs 490,000 490,000 Funding Sources: Water Fund - - - - ' ' Bortd Proceeds 490 000 - ' - - ` 490,000 _ 5 Water Supply Gharges cap(tal costs 7,000,000 - - - - 7,000,000 Furid[ng Sources: Water Fund - - - - " " Bond Proceeds 7,000,000 - - - - 7,000,000 6 Mnua{ Distribut[on ImprovemenEs ' Capital Cosls 116,000• 199,000 123,000 127,000 ' 139,000 135,000: 751,000 Funding Sources: Water Fund - 916,000 119,000 123,000 127,000 131,000 135,000 759,000 Bond Proceeds - - - - - - ' SubEotal. Capac(N Prolects: • Capital Costs 9,632,440 119,000 923,000 127,000 . 391,000 1,035,000 91,427,400 Non-Capacitv Proiects: • 7 Lakeland Hills Reservolr 6 Capital Costs 2,105,040 - - - - 2,105,080 Funding 5ources: Water Fund - - - , - - ' 6ond Procseds 2105 000 - - - - - 2,105,000 8 Well lnspection and Redevelopment Program Capital Costs 430,500 246,400 562;800 579,600 597,000 614,900 3,031,200 fonding Sources: ~INatee Fund . 430,500 246,400 562,800 • 579,600 597,000 614,900 3,031,200 BondProceeds - - - - - - - 9 Water Repair & Replacements Capital Costs ` 140,000 140,000 1,350,000 150,000 2,960,000 -3,050,000 7,750,000 . Funding Sources: . {IVaterFund 140,000 100,000 1,350,000 150,000 2,960,000 3,050,600 7;750,000 , Bond Proceeds . 31 Non-CaaacityPrQjects: . 2011 2072 2013 2014 2015 2016 Total 10 Academy 8 Lekefand Hilis Booster Pump StafEons ' Capttai Costs 997,800 1,600,000 - - - - 2,897,600 Funding Saurces: Water Fund 1,600,040 - - - - 11800,000 . Bond Proceeds 997,600 - - - - 997.600 t i Academy Pump Stadon , Capital Costs - 250,000 830,000 - - 11080,000 Funding Sources:. . . Waier Fund - - 250,000 830,000 - - 1,080,000 Bond Proceeds - - - - - - 12 Lakeland Hflls Reservair Painting ~ . Capital Costs - - 700,000 - - 740,000 Fund(ng Sources: Water Fund - - 700,006 - - - 700,000 Bond Proceeds i3 Compreheneive Water Ptan Capita) Costs - , , - 100,000 - - 100,000 Funding Saurces: Water Fund - - - 100,000 - - 400,000 Borxl Proceeds ~ - - - - 14 Well 4 and.lntertie Pump Station tmprovements Capital Costs 219,900 - - - - - 219,900, Funding Sources: Water Fund - - - - - - ' BondProceeds 218,900 - - - - - 219,900 . 15 Wefl S Upgrade . Capital Costs - - 200,400 680,000 890,000 funding Sources: , Water Fund - - - 200,000 690,000 890,000 Bond Proceeds 16 Wei! 7 Emergency Power . Capital Costs 70,000 240,000 - - 310,000 Funding Sources: WaterFund - - 70,000 240,000 - - 310,000 . Bortii Proceeds 17 Maintenancs and Operations Expansion . . Capilal Costs - - 300.000 - - - 300,000 Funding Sources: ' Water Fund - - 300,000 - - - ~300,000 ' • Bond Proceeds - - - - - ' . 18 M1T Master Meters Capital Cosls 80,000 200,000 - - - - 280,000 Funding Sources: Water Fund 80,000 200,000 • - - 280,000 _Bond.Proceeds 19 Street Utility lmprovements Capital Costs 100,000 100,000 200,000 200,000 200,000 200,000 000,000 Funding Sources: Water Fund 100,000 100,000 200,000 206,000 200,O60 200,000 1,0000000 Bond Broceeds - - - - - - - 20 WaterResoutces ProtectionProgram Capital Costs 21,900 22,500 . 23,200 23,900 24,600 25,400, 1411540 Funding Sources: - Water. Fund 21,900 22,500 23.200 23,900 24,600 25,400 " 149,500 Bond Proceetls' - - - - - 38 Non-Cabacltv Prolects: 2041 2012 2013 2044 2016 2016 Total 21 Annual Resenrotr Repatr & Replacement Program ' • Capital Costs 53,100 54,600 56,300 56,000 59,700 61,500 343000 ' Fundfig Sources: Water Fund 53,100 54,600 56,300 56,000 59,700 61,500 343,200 Bond Proceeds ' - - - 22 SCADAUpgrades Capital Costs 778,000 200,000 - - - - ~ 978,000 Funding Sources: Water Fund 280,000 - - - 200,000 Bond Proceeds 778,000 - - - - 778,000 23 FulmerWeU Ffeld Improvements Capitai Cosis 100,000 300,600 - - - - 400,000 Funding Sources: Water Fund - ~ 300,000 - - - - 300,000 . Bond Proceeds 100,000 - - 100,000 24: M Street Gratle Separation Capital Costs 120,004 - - - ' • - - 120,000 Fund[ng Sources: ' Water Fund _ 120,000 - - - - - 120,000 Bond Proceeds _ , 25 L.ea HtU PRV Sffition Improvements • Gapital Costs 250,000 - - - - - 250,060 Funding Sources: Water Fund - - - - - Bond Proceeds 250,000. - - - - 280,000 28 Deduct Meter Replacemenk Project ` Capitat Costs 400,000 - - - - - 400,000 Funding Sources: Nlater'Fund - - - - - - - Bond Proceeds 400,000 . - - 400,000 27.A Slteef NW Co"rrtdor Capi{aI Costs 350,000 - - - - - 350,000 Funding Sources: 11VatecFund - - - - - - - Bond Proceeds 350,000 - - - - 350,000 ' Subtotal: Non-Caoacitv Proiects: ~ Capital Co.sts - 6,146,000 2,823,500 3,812,300 2,181i500 - 4,041,300 4,641,800 23,346,400 SUMMARY: CAPf7AL COSTS Capacity Projecls 9,632,400.. 118,000 123,000 127,000 391,000 1,035,000 11,427,400 Non-Capaciry Projects 6,146,000 2 823 500 3,512,304 , 2,1811,500 4,041,300 4,641;800 23,346,400 Totaf Costs 15,778,400 2,842,500 3,635,300 2,308,800 4,432,300 5,676,800 34,773,800 FUNDING SOURCES: ' Water Fund 1,061,590 2,942,500 3,635,300 2,308,500 4,432,300 5,678,800 20,056,900 Bond Proceeds 14,716,900__._ 14,718,900 Total Funding 15,778,400 2,942,500 3,635,300 2,308,500 4,432,300 5,676,800 34,773,800 39 WATER FUND (430) Capttal Factnttes Pian Six Year Capltal Facillttes P1an, 2017-2016 " Enterprtse Funds Pro)ectTitie: Lea Hi11 BPS Expansion & Rezone Praject No: cp0801 . PtoJect Type: Capacity - Pinject Manager. 7BD . Descrlption: . fncrease the pumping capaaty and recanfigure the boosted zone to encompass additional hydrants in oMer to provide adequate fire flow.• . ; i Progress Summary: Future Impact on Operating Budget: . No sign(ficant impact $udget: 2010 YTDActaal 2011 18Budget Budget Expenditures Bddget Balance _ AdoAfed Budget Budget Amendments - - - ' AdJusted Budget Activity: ~ 2010 YE :2011 Year End Fundfng 3ources: Prior to 2810 Estimate 2011 Bud et 2012 Bud et Pro ect 7otat Uorestdcted WaterRevenua - - - - - Grants (Fed State,Local) 8ond Proceeds - - - - - - Other - - - Total Funding 8ourees: - - - - • - q Capital Expenditures: Design - - - - - Rig6t of Way Consfroction - - Total Expenditures: - - - - Forecasted Project Cost Total 2013 2014 2016 2016 2079-2016 ; . Funding Sources: UnresbicfedWaterRevenue - - • 280,000 900,000 1;160,000 Grerits(Fetl,State,Laca!) - - ' - - - 8ond Praceeds ' - - - , - . _ Otfier- - - Total Funding Sources: - - 260,000 900,000 41160,000 Capital Expenditures: - . Design - - 260,000 - 260,000 Rrght of Way - - - - . - ' , Construction 900,000 900,000 Tota! Expendltures: - - 260,000 900,000 1;160,000 Grants / Other Sources: - . 40 ~ • WATER FUND (430) capttat Eacilities Plan Six Year Capttal Facilities Plan, 2011-2016 'EnEerprise Funds ProjectTiiie: We1l 1. tmprovements , . Project No: cp0916 . Projecf Type: Capacity Project Manager. Lee . Description: Hydrogeologic evaluation of existing welf conditions, rehabilita#ion or re-cirilling of the well to maximum well production, and construction ' af bullding improvements to house chlorine disinfection, equipment and an emergency generator: Progress Summary: ~ . i . . ~ " Future lmpact on Qperattng Budget: ' Sudget: 2010 YTD Actuai ' 2419 10 Budget Budget, Expenditures Budflet Balance ' Adopted 8udget - - ' 8udget Amendmeirts . AdjnstedBudgst - , - _ _ - Activity: . 2010 YE 2011 Year End Funding Sources: Prior to 2010 Estimate 2011 Bud'get 2012 Budget Proect Totai ~ Unresficted tNaterRevenue 10,600 575,000 - - 585,600 Grants (FBd,Stefe,LOCaQ ' BondProceeds 1,794,400 - 1.794,400 Other. - - - - Total Funding Sources: 10,600 576,000 1,794,400 - 2,380,000 Capita! Expend[tures: pes7gn 10,600 284,500 - - 305,100 Righf of YVay - - - - - Construction 281,600 1,794,400 2,075.400 Total Expenditures: 10,800 576,600 ' 1,784,400 - 2,360,600 Forecasted Project Cost: Totai 2013 2014 2016 ~ 2016 2019-2016 , ' Funding Sources: , UnrestrictedWaterRevenue • - . - - - _ Grants (Fed,SYste,Locao - ' " - " Band Pfoceeds 1,794.400 ' Other Total Fund)rig 3ourcesc - - _ , - 1,794,400 Capitai Expenditures: , Deslgn Right of Way - • Constnrction - - 1794,400 ' Total Expendttures: ` - - - - 1,794;400 ' Grants I Other SourCes: . 4 1: _ WATER FUND (430) cap[tar FacnF~es eran Six Year Ca.PItal Facftifies Plan, 2011-2Qt6 Enterprise Funde • . Project'ritie: Green River PS Emergency Power . Praject No: CpxXxx Project Type: Capaciry Project Manager. TBD ~ Description: Construction of facility improvements to hause an emergency generator and assocfated elecMcal equipment. ' Progress Summary: i , Future [mpacE on Operattng Budgetc BUdg@t: 2040 Y7D Actual _2011 10 Budget. : Budget Expenditures Budget Batance . Adopted 8udge! Budget,4mendments - - - " " Adjusted Budget ACtivity: ' '2010 YE 2019 Year End Fundtng Sources: Prtor to 2010 Estimate 2011 Bud et 2012 Bud et Proect Totai Unrestrrcted INeterRevenue 48,Oa0 48.000 - - - - " ' Grants (Fed,State,Loca!) 8ond Procoeds , 232,000 - 232.000 Other - ' . Total Funding 3ources: - 481000 232,000 _ 280,800 Capital Expenditures: Deslgn - 48.000 - - 48,000 Right of Way , 232 000 232 000 Constrocti0n - Total Expenditures: - 48,000 232,000 284,000 . Forecasted Project Cost: , Total 2013 2014 2015 2016 2011-2016 . Funding Sources: Unrestricled WaterRevertue - - - ' Grants (Fed,State,Locaf) - - - ' _ " Bond Pmceeds - - - - 232.000 Other - - " Tota1 Funding Sources: - • - . 232,000 Capitai Expenditures: Design - - " ' lWght of Way - " 292 000 QonstrucUon - - ' ' Total Expenditures: - - - - 232,0C0 Grants / Other Saurces: 42 _ WATER FUND (430) Capitat Faaitittes Ptan Six Year Capita( Factlittes Plan, 2011 20t6 Entecprise Funds Project Tiue: intertie Infrastructure . . Project Na: cp1011 Projecf Type: Capacity Project Manager: TBD Description: Construciion of two intertle infrasiructures required for purchased water and for long term emergency interties_ Progress Summary: i Future lmpact on Operating Budget: BUdget: 2010 YTD Actuai 2019 10 Budget Budget Expenditures Budget Balanee Adopted Bvdget - - - ' Budget Amendments - - - ' Adjusted Budget - - - ' Activity: 2070 YE 2011 Year Hnd Funding 3ources; Prior to 2010 EsUmate 2011 Bud et 2012 Sud et Pro ect Total UnrestriCted WaterRevenue - 600,060 - - 600,000 Grants (Fed,State,LoCa1) - - - - " 8ond Proceeds - - 490,000 - 490,000 Other ' Total Funding Saurces: - 600,000 490,040 - 1,090,000 Capital Expenditures: Design - 105.000 80,000 - 185,000 Righi of Way - - - - - Construction 495,000 410,000 905,000 Tota1 Expenditures: - 600,000 480,000 - 1,090,000 ForecasEed Project Cost: - Total 2013 2014 . 2016 2016 2011-2016 Funding Sources: • UnresttfctsdWaferRevenue - - - • - " Granls (Fed,State,LOCaI) - - - - " Bond Proceeds - - - - 490,000 Olhar - - Total Funding Sources: - - - - 490,000 Capital Expend(tures: Design - - - - 80,000 Right of Way - - - - ' Cor+shuction - - 470,000 Total Expenditures: 490,000 Grants i Othar Sources: 43 ' WATER FUND ~430j Capltal.Facllittes Plan _Six YeaT Capital Faciifties Plan, 2011-2016 , Enterprise Funds - Project Tdle: ' Water Supply Charges - Project No: cpxxxx Project Type: Capacity - Project Manager. TBD . ' , Descriptionc . ; Financing 4o purchase water #rom adjacent purveyors to meet projected demand. ; ' Progress Summary: • P.lanned . ~ Future lmpact on Operating Budget: None_ BUdg@t: 2016 YTD Actual 2011 10 Budget ' • Budget Expenditures Budget Balance . - Adopted Budget _ - _ - : . " Budget Arttendments - - ` - ' - Ad/usted Budget • Activity: • , . 2010 YE 2011 Year End Punc[ing Sources: Prior to 2010 E§timate 2011 Bud et 2012'Bud Budget _ Proeet Tofel _ Unresfrfcted Water Rsvertue Grents (Fed,Stete,Loca!) - - ' - . Bond Pmceeds - - 7,000.000 - 7,000,000 Other Total Fundtng So.urces: - - 7,000,000 - 7,000,000 CapIIal Expenditures: . Water Suppty Charges - - 7;000,000 - 7,000,000 . . Righf of Way - - - - , - ° Qonstruofion - Total Expenditures: - - 7,000,000 71000,000, Forecasted Project Cost: • . ro.tai ' • 2013 2014 2016 2016 2079 -2016 Funding Sources: Unrestricfed 4VaterRevenue - - - ' Grants (~ed,Stats,Cxalj - - - - - Bond Proceeds - - - 7,000,00.0 Qther Total Punding Sources: - - - ' - 7,000,000 Capital Expenditures: . Water Supply Ci+arges - - - - 7,000,00 Right of Way - - - - ' Construcfion - - - Total Expenditures: - - • - 7,000,000 Grants I OtherSources: . 44 - ; WATER fUND (430) . capotai Faciiities Pian Six„Year Capital, Facitifies Plan, 20114016 Enterprise Funds .Praject Titte: Annuat Distribution tmprovements Program . Project No: cpxxxx Rroject Type: Capaclty Project Manager. Vat'lous , Description:. Dtstritiufion §jistem lmprovements needed to support anticapated growth. ProJects will be coordinated with the LocalStreet Program and other utility projec.ts. Progress Summary: i ; Future lmpact on Operattng Budget: No signifcant impact. Budget: 2010 -YTD Actual 2011 10 Budget Budget Expenditures Budget Balance - " . Adopted 8udget - - - - . Budget Rmendmenls - . Adjusted Budget - - - - Actlviry: - 2090 YE - 2011 Year End Funding Sources: Prior to 2010 Esttmafe 2011 Bud et . 2012 Bud et Pro ect Total Un(sstrictedWaterRevenue - 113,000 116,000 - 119,OOQ 228,000 Grants (Fed,State,LocafJ - BoRd ProCeeds : - - - - - Ottier Total Funding Sources: 113,000 116,000 979,000 229,000 Capital Expenditures: ' . Design - 26,000 28,060 27,000 52,090 Right of Way ' - - - - - Construction 87,000 90 000 92,000 177,008 ' Total Expenditures: • 113,000 118,000 119,000 229,000 Forecasted Project Cost: • Total 2813 2014 _ 2016 2016 2011 - 2016 . . Funding 5ources: . . Unrestricted Water Revenue 123,000 127,000 131,000 135,000 751,000 Grants (Fecl,State,Locaf) - - - - Bond Proceeds - Other - _ 7otal Funding Sources: 123,060 127,000 _ 131,000 138,000 751,000 Capital Expanditures: Deslgn 28,000 29,000 30,000 ` 31,000 171,000 Rrghf of WaY - - - - ConstructJon 95,000 98,600 101,000 ~ 104,000 580,000 Total Expenditnres: 123,000 127,000 131,000 - 136,000 751,000 Grants / Other Sources: - , 45 WATER FUND.(430) Cap(tal FacU[t;es Plan Six Year Capital Facflities Ptan, 2011-2016 Enterpr{se Fun_ds Rroject Titte: Lakeland Hills Reservoir 6 ' Project No: Cp4006 PrajectType: Non-Capacity , Project Manager: TBD _ Descriptfon: : Construct a second reservoir in the Lakeland Hi[Is area to meetpeak hour demand and fire demand. • Progress Summary: ~ Future lmpact on Operating Budget: Project vulll require routina inspections by water operations staff. The annual maintenance cost is estimated to be approximateiy $1,200. Budget: 2010 YTO Actual 2017 10 8udget Budget Experiditures Budget Balance ' - - - ' Adopted Budget 8udget Amendments Ad%usted Budge! - - - ' Activity: 2070 YE 2011 Year End Funding Sources: Priorto2010 Estimate - 2011 Budget . 2012 Bud et Pro eatTotal Unrestricfed WaterReverrue - 235,000 235,000 Grants (Fed,'Stafe.toca/) - - - - - Bond Pfooeeds - 2.105,000 - 2.105,000 . Other . - - - Totai Funding Sources: - 236,000 2,106,000 - 2,340,000 Capitai Expenditures: Design - 235,000 45,000 - 260.000 R/ght of Way ConstnrctTOn 2,060,000 2,D60,000 ToWI Expend[turea: - 236,000 2,106,000 - 2,340,000 Forecasted Project Cost: 7ota1 ' 2013 2094 _ 2016. 2016 2077-2016 _ Funding Sources: , Unrestricted Water Revenue - - - ' " Grants (feii,State,Locaq - - - ~ " 8ond Proceads - - - - 2;105;000 Other. _ 7otai Funding Sources: - - - 2,106,000 Capitai Expenditures: • Design - - - - 45,000 . Right oPWay - . Construction - - 2 060 U00 Total Expenditures: - - - - 2,105,000 Grants / Other Sources: 46 WATER FUND: (430) : . capjtai Facnities Plan - , I.- Six Year Cap[tal Fac1[Ities Plan, 2011-2076_ ' _ Enferprtse Funds Project Title: - Well Inspection and Redevelopment Program Project No: CpxxXx. , Pro3ecrTVpec; Non-Capacity _ Project Manager:. , TBD Descrtption: . ' . . ' Program for inspeciion and redevelopment of supply wells and springs necessary to ehsure productEon at mazimum capaaty forefficient utilizatlon. ' Rrogress Summary: , . Planned ' ' Future Impact on OperaEing Budget • . None Budget 2010 YTD Actual 2019 90 Budget Budget Expendltures Budget ' Balance . . Adopted Budget - - - Budgeti4mendmenfs - Adjusted Budget - - - - ACtiyity: . 2010 YB 2011 Year End • Funding 3ources: RrFOr to 2010 Estimate 2011 Bud et 2012 Bud et Pro ect Total Unrestdcted WaterRevenue - 100,000 430,500 ' 246,400 530,500 Grants (Fed,Stale,LocaQ _ 8ond Pioceeds - - - - O?hei - Total Funding Sources: - 100,000 430,600 246,400 . 530,600 CapItal Expenditures: Ds§Tgn - 30,000 100,500 80,000 130,500 Right of Way _ - - . Constnrction - 70 000 330,OQ0 166,400 400.000 Total.Expend[tures: - 100,000 430,500 246,400 630,600 Forecasted Project Cost: :Total 2013 ~ 2014 2016 2016 2011' - 2016 Funding Sources: . - " UnreslrictedWaferRevenue 562,800 579,600 " 597,000 614,900 3,031,200 Granfs (Fed,State,Local) 8ond Proceeds - - - - - Other Total Funding Sources: 662,800 5791600 587,000 614,900 3,031,200 Capltal Expenditures: . Desfgn 129,900 133,700 137,700 141,400 723,200 RFghtof Way. _ _ _ _ _ Construcfion 432,900 445,900 459,390 473,500 2,308,00Q Totat Expenditures: 562,800 579,600 597,000 614,900 3,031,200 Grants / Olher Sources: . . 47 WATER FUND (430) Capital Facilittes Plan Six Yeac Capital Facilitfes P1an, 2011-2876 • Enterprise Funds ProjectTiee: Annual Distribution Repair & Replacements , Pro)ect No: Cpxxxx Project.TyPe: Non-Capacity (R&R) . Projeat Manager. V11'iouS ' Description: . . Distribution system repair and replacement projects requ3red for meeting peak demands and reducing system losses. Frojeds wiU be coordinated with the Local Street Program and other utiliiy pro)ects. . i Progress $ummary: Future ImpacE on Operating Budget: No significaM impact. , . BUdget: . 2010 YTD Actual • 2011 10 Budget _ Budget Expenditures Budget Balance Adopted Budget Buctgat Amendments " Adjusted Bodgei - - - Activify: 2011 Year End (Prior 2 Years) . 2018 YE • ' Funding Soqrces: Prtor to 2010 Estimate 2011 Bud et 2012 Bud et Pro ect Total Urtrestricted Water Revenue 876,700 . 200,000 140,000 . 100,000 1:216,700 . Grents (Fed,State,Local} - - - - - 8ond Proceeds - - - ' - Other - ' Total Fundiog 8ources: , 875,740 200,000 140,000 100,000 1,216,700 Capital Expendituie"s: Dasrgn 175,300 40,000 30,040 20,000 245;300 Right of Way - - - " " ConsUuctian 701,400 160,000 110,000 80,000 ' 971400 • Total ExpendiWres: 876,700 200,000 940;000 100,000 1,216,700 Forecasted ProJect Cost: ' Totat . 2013 2014 2095 • 2018 2011 -2016 Funding Sources: ' Unresbrcted Water Revenue 1,350,000 150,000 2,950,000 3,050,000 7,750;000 • Grants (Fed,State,Loca!} - - - ' " Bond Proceeds - - ' " . - - - ' _ , - .OiFier. Totai Funding Sources: 1,350,000 150,000 2,960,400 3,050,000 - 7,760,000 Capital Expendltures: Desrgn 270,000 30,000 590,000 610,000 . 1,550,000 Right of Way - - - - - Consfruction 1,080 000 120.000 2,370,000 2 440.000 . 6,200,000 Tota( Expenditures: 1,350,000 160,000 2,960,000 3,050,000 7,760,000, Grants t Other Sources: 48 WATER'FUND (434) . . Capital Faci.lities Plan . StxYear_Capi,ta! Facilitfes;Plan, 2091-2016 Enterprise Funds ~.ProjectTitle: Academy & Lakeland'H(Ils Baoster Pump Stations ~ Project tVo: cp0909 . Project Type: Non-CapaCity Project Manager: Vondrak.. Description: , Construct two new booster purrfp stations. A new Academystatfon wlll be constructed a# a si4e to be deteRnined, to repiace the Janssen's Addition pump station, to meet fire flow demands and' provide emergencypower. A new Lakeland Hills station Hrfll also be oonstructed at the existing station site to meet peak demand and 6re flow. Progress Summary: . , Future impact on Operating Budget: ' No sisanificant impaci zoit ~o Budget . Budget: . 2010 Yro actual . Budget Expenditures Budget Ba}ance - - - - . Adopted Budget " Budget Amendments - - Adjusled Budget - - ' Actiyity; 2010 YE 2011 Year End . , . Funding Sources: Prlor Eo 2010 EsfimaEe 2011 Bud et 20128ud Budget Prolect Total ' UmestiictedWaterRevenue 148,500 3;279,600 - 1,600,000- 3,428,100 . Grants (Fed,State.Local) - - - - - Bond ProCeeds - - 997,660 - 997,600 Other - Total Funding Sources: 148,800 3,279,600 ' 997,600 1,600,000 4,425,700 Capttat Expenditures: - ' ' Design 148,50U 525,000 282,700 - 956,200 Right of Way - - - - - Construction - 2,754 600 714,900 1,600,000 3,469 500 Totai Expendttures: 148,600 3,275,600 987,600 1,600,000 4,425,700 , Forecasted Proje,ct Cost: . . ' . Total . 2013 2014. , 2016 2016 2011 - 20i6 , Funding Sauroes: 'Unrestricted Water Revenue - - - - 1.600,000 Grants (FedState,Local) Bond Proceeds - - - 997.600 Ofher _ Total Funding Sources: - - - 2,597,600 Capital Expenditures: Design - - , - - 282,700 Right of Way Constnlction 2,314,900 - Total Expendilures: - - - - 2,697,600 Grants / Other Sources: 49 WATER FUND (430) Capt.tal Faciltties.Plah Six Year Capital Facitities Plan, 2049-2096 Enterprise Funds • Project Title: Academy Pump Station #1 Project No: cpxxxX Project Type: Non-Capacity . Project Manager ' TBD , Description• improvements to tfie statinn inc►ude reptac(ng the existing pumps whicii are at fhe end of their'useful liie, electrical modiftcatidns and emergency power. . Progress Summary: ' - ~ Fvture impact on Operating Budget: No sianificant Impact BUdg@t: . 2010 YTD Actual 2071 70 Budget : Budget Expenditures Budget Balance. , - Adopted 8udget - - - " ' 8udget Amendments - - Adjusted Budget - - - Activity: 2010 YE 2091 Year Ead Funding Sources: Prior to 2010 Esttmate 2011 Bud et 2012 Bud et Proeet Total UnresMctedYVaferReve»ue - - , - ' - - Qrents (Fed,Sfate,Loca!) - - - - - - 8ond Proceeds - - - - Other - - Total Funding Sources: - - - - - Capital Expenditures: Design - - - - - RighloftNay ConsbuCtion - - Total Expenditures: - - - - Forecasted Praject Cost: , Totaf 2013 2814 2016 2016 2011-2416 Funding Sources: " UnrestrlcfedWaterRevenue 250,000 830,000 - - 1,080,000 . Granfs fFedSfate,LocaQ , . 8ond Plooeeds - - - - - Other - - - , _ Totai Funding Sources: 260,000 830,000 - 4,080,000 Capital Expenditures: . Design 250.000 - - - 250,008 ' Right of Way - - - - - - Constructlon - 830,000 - - 830 OUO I Total Expendifures: 250,000 830,000 ' - 1,080,000 Gran?s i 0ther Sources: 50 - - WATER FUND (430) . . . . capital FaciEZties pian ` Sfx Year Capitai FacUities P[an, 2011-2016 . Enterprise Funds . ProjectTitle: Lakeland Hii1s Reservoir Painting - Project No: CpXXXX Project Type: Non-Capacity Project Manager. TBD Descrfption: Paint the interior and ezterior to preserve the life of the reservoir. Progress Surrtmary: Future impact on Operating Budget: . No sianificant lmAact Budget: 2010 . YTDActual, _ 2011 10BUdget, ` Budget Ex end(tures Budget Batance - - - " Adopted Budget ' Budget Amendmants - " AcUlusted Budget - , - - " Activity: - Z090 YE 2011 Year End Funding Sources: Prior to 2010 Estlmate 2011 Budget 2012 Sud et Pro ect Totai , Unresfricted INatef Revenue - - - " " Granls (Fed,State,Loca/) Bond Proceeds - Ofher - - TotalFunding Sources: - • ' ' " Capital Expenditares: Design - - ' ' Right of Way - - - - - Construction - - Tofal Expenditures: , Forecasted Project osf; Tofal 2813 2094 . 2016 2018 2011-2018 Fundtng Sources: UnrestrictedWaterRevenua 700,000 700,604 ' Granfs (Fed State,LocalJ - - - - ' 8ond Proceeds - - - - ' Other. - - ' Total FundingSources: 700,006 700,000 Cap(ta1 Expenditures: Deslgn 90.000 - - - 90,000 Right of Way ' • - - - - ' Construction 610,000 - - 610,000 Total Expenditures: 700,000 - - - 700,000 Grants / dlher Sourcxs: - 51 :WA7ER FUND (430) " Capltai Faciiities;Ptan , SixYear Gapital Faci)lties Plan, 2011-2016 Enterprise Funds ProJectTitle: Comprehensive Water Plan . Project No: Cp0704 ProJect Type: Non-Capacity • Projecf Manager. Lamothe Description: , - Update ihe Comprehensive Water Plan as required by Washington State DepartmeM ofNeatth. ; Ptogress Summary: Plan update in progress Future Impact.on Operating'Budget: . ' No signiflcant impact. Budget: 2010 YTD Actual 2011 10 8udgef Budget Expenditures Budget Balance AdoptedBudget - " - - Budget Amendments - Adjusted Budget - - - Activity: . ' - 2016 YE 2011 Ysar End Funding Sources: Prior to 2010 Estimate 2011 Bud eY 2012 Bud et Proect Totat • UnreslrictedWaterRevenue 498,700 25;900 - 524,600 cra„ts fFed,srare,Loca1~ - Botrd PrvCeeds Other - - Total Funding Sources: 498,700 25,900 - • - 624,600' CaplEal Expenditures: ' Design 498,700 25,800 - - 524,600 Right of Way. - - - - - Construction - - Totai Expenditures: 498,700 26,300 - - 524,600 Foreca"sted Project Gost: ' Totai 2013 2074 2015 2016 2011 -2016 Funding Sources: UnrestrictedWaterReVenue - 100,000 - - 100,000 Granfs (Fec%State,Loca!) - - - • - Sond Proceeds - - - - - Other - ' Total Fund(ng Sources: - 100,000 - 100,000 Capftal Expenditures: Deslgn - 100.000 - - 900,000 • Right of Way Construction - " ~ Total ExpeadRures: - 100,000 - - - 106,000. - Grants / Other Sources: . . 52 WATER FUND (430) Capital Facil[ties Plan Six Year Capttai FacititEea Plan, 2011-2016 Enterprise Funds . Projeat Tifle: Wei14 and Intertie Pump Statfon Improvements Project No: c512a0 Project Type: NOn-Capacity . . Project Manager. Lamothe . . . Descriptlon: Construct a new building at the Weff 4 site to house a dlesel-fueled standby generator, new hypxhlnrite dis[nfection equipment, and restroom facflities accessible from inside and autside the building. Determine the cost and feasibility of Enstatting standby power io the Lea Hill Booster Pump Station. Progress Summary: ; Future Impact on Operating Budget: BUdget: 2010 YTD Actual 2017 10 Budget Budget Expenditures Budget Balanae Adopted Budget - - - ' Budget Amendments - - - - - - Adjusted Budget Activity: 2010 YE 2041 Year Snd Funding Sources: Prior to 2010 Estimate 2011 Bud et 2012 Bud et Pro ect Total ' llnrestrfctedWaterRevenue 6,700 400,000 - - 408,700 Grants (Fed,Slafe,Locaf) - - - - ' BondProceeds - - 219,980 - 218.900 Ofhar - ' ' Total Funding Sources: 6,700 400,000 238,800 - 626,600 Capital Expenditures: Das/gn 6,700 400,000 - - 406,706 Right of Way - - • - - ' Construction 219,900 219,900 Total Expendltures: 6,700 400,000 219,900 - 628,600 Forecasted ProJect Cost: Total 2013. 2074 2016 2016 2011-2016 Fundfng Sonrces: Unrestricfed Water Revenue - - - - ' Grants (Fed,Sfate,Loca1) - - - - ` 8ond Proceeds - - - - 219,940 Other Tota! Funding Sources: - - - - 219,980 Capltat Expenditures: Design - - - - ' Right of Way - - - - ' . Construcfion - - 219 900 Total Expenditures: - - - - 219,900 Granis / Other Saurces: • 53 . . WATER FUND (430) ' CapitaEFaciudes Pian Six Year Gapital Faeilities PEan, 2071-2818 ' Enterprfae Funds Project Title: Well 5 Upgrade Projecf No: cp0624 _ Project 7ype: Non-Capacity . . Projed Manager: Lamothe Descriptionc - - - Construct a new w+ell faciliiy meeting cument electrical and safety codes. The project will tnclude emecgency badcup power and disinfeciion capabiEity. ' Progress Summary: ; Future Impact on Operating Budget: No slgnificant impact. . BUdgef: . . 2010 Y7DActuai 2019 ; 90Budget Budget . Expenditures Budget - Balanee Adopted Budget _ - ' 8udget Amendments - Adjusted Budget Activity: 2010 YE 2011 Year End • Funding Sources: Prior to 2010 EsNmate 2011 Budget 2812 Bud et Pro ect Totaf `tlnrestdcted Water Revenue 55.900 55,900 , `Grants(Fed,Stele.LocalJ . Bond Proceeds - - ' Other • - - ' Total Funding Sources: 65,940 - - 55,900 CapitalExPenditures: . • Dsslgn 2.600 - - - 2,600' - RJgflf Of INey - - - 53,300 ' Conslrucilon 53,360 - - - Tofal Expenditures: 65,900 - - - 55,800 ~ Forecasted Project Cost: Total 2013 2014 2016 2016 2011 •'2016,. Funding Sources: Unrestricted Water Revenue - - 200,000 690,000 890,000. - - - - ' Grants (Fed, State, Local) Bond Proceeds Other - - - 7otal Funding Sources: - - 200,000 690,000 890,000 . Capital Expenditures: . . Daslgn - - 200,000 - , 200,040 Rr hFofiNe 9 Y - Construclion 690.000 .690000 Total Expendttures• - - 200,000 690,000 . 890,000 Grants / Othet Sources , 54 WATER FUND (430) capttai Facittcies P[an Six.Year Capital Facilftles Pian; 2011-2016 _ . Enterprise Funds Project Tiue: . Well 7 Emergency Power ; Project No: cpxxxx project'rype: Non-Capacity Project Manager: TBD Descriptfon: Provide a generator for backup power to reiiably meet demands in the Valiey servicer area. • Progress Summary: . • . i. i Future Impact on Operating Sudget: No s9gnificant impact. ' - BudgeE: 2018 YTD Actual 2011 10 Budget Budget Expenditurea Budget Balance , Adopted Budget . Budget Amendments - - Adjusted Budget " - , - - - Activity: . 2010 YE 2017 Year End Funding Sources: Prior to 2010 Eslimate _ 2011 Bud et 2012 Bud et Pro'ect Totai • Unresfrloted Wafer Revenue , _ . Giants (Fed,State,Loca1) - . ` - Bond PruceBds ' Other - - - 7otal Funding Sources: - - - ' " Capital Expenditures: ` Design - - - _ " Right of Way Construction , - - - - ' Total Expenditures: - - - " Forecasted Projecf Cost: ' Totaf 2013 2014. 2016 2046 2017 - 2016_ . Fund(ng Sources: Unrestricted Water Revenue 70.000 240,000 - - • 310.000 . Grants (Fed,State,LocaQ 8ond Proceeds , - - - _ ' Other - - ' Total Funding Sources: 70,004 240,000.. - - 310,000 " Capitai Expenditures: . Design 70,000 - - - 7%000 Right of Way - - . . ~ - 240.000 Constnrclion 240,000 - - - • Total Expenditures: 70,000 240,000 310,000 Grants / Olher Sources: 55 WATER FUND (430) Cap[tal Facqitfes Plan - Six Year Capitai FactlitEes Plan, 2011-201 B Enterprtse Funds ProjectTifle: Maintenance & Operations Facility Improvements Project No: cpxxxx . . Project Type: Non-Capacity Project Manager: TBD ' Descriptionr lmproVements to M&O faalitfes and oparations inctuding remodet the ebsting bullding. ~ . Progress Summary: Futilre Impact on Operattng Budget , BudgBt: 2010 YTD Aetuai 2011 10 Budget Budget Expenditures Budget Balance Adopted Budget Budget Amendments , Adjusled Budget - - - - Activity:. . . . - 2040 YE 2015 Ysar End Funding Sources: Prtor to 2010 Estlmate 2011 Budget 2012 Bud et Proect Tota[ UnrestricledWaferRevenue - - - = . - - - - - - Grants (Feaf,Stale,Local) 8ond Proceeds - - - - ' • Other - - ' Total Funding Sources. - - - . ' Capital Expenditures: . Design Rlght of Way • Construction - ' - Total Expenditures: - - - - Forecasted Project.Cost: . Tofal 2013 2014 2016 2016 2011r.2016 Funding Sources: Unreslricted Water Revenue. 300,000 - - - 300,000 Grants(Fed,State,Locai) - - - - - Bond Proceeds - - - , ~ Other - 7otai Funding 3ources: 340,000 300,000 Capital Expenditures: ' Design 70,000 - - - 70,000 Rfght of 4Yay - - - - CORSfIpCtIOR 230,000 ~ - 230000 Total Expenditures: 300,000 300,OOd Grants / Oiher Sourcas: 56 • WATER FUND (430) - Capitat Faciiities Ptan Six Year Capita) Faclltfies Plan, 2019-2076' Ente.rptise Funds Projec# Title: MIT Master Meters , Project No: cpxxzx , Project i'ype: NOn-Capacity Project Manager: TBD , Descriptton: tnstall master meters to Mudcieshoot lndian Tnbe proper#fes to ease account administra6on. Progress Summary: i Fu.ture Impact on Operating eudget: ' Budget 2010 Y70 Aciuai 2011 10 Budget , Budget Expenditures Budget Ba(ance Adopted Budget • - - - - Budget Amerrdments - - - - - - . Adjusted Budget Activity: . 2010YE 2011 YearEnd Funding Sources: Prior to 2010 Eatimate 2011 Sdd et 2012 Bud et Pro ecf Total Unrestdcted Water Revenue - - 80,000 200,000 80,000 Grants (Fed,Stafe;Loca!) 8ond Proceeds ' - , - - - - ' Qthsr _ Total Fu.nding Sources: 801000 200,000 50,000 ' Capital Expenditures: ' Design - - 80,000 - 80,600 Right of tNsy - - - - - Constructinn - - 200,000 - ' Tota1 Expendltures: - - 80,000 200,000 80,000 Forecasted Project Cost: , . . Totat 2013 2014 . 2016 2016 2077-2016 , - Fundtng Sources: • UnresMcted Water Revenue - - - - 280,000 Grenls (Fed,Sfate,Local) - - - - Bond Proceeds - - - - - - Ofher _ Total Funding Sources: - - - - - 280,000 - Capitaf Expend(tures: . Deslgn 80,000 Right of Way - - - - - Constnuction - 200,000 Total Expenditures: - = - - 280,000 " Grants / Other Sources: 57 . ' WATER FUND (434) cap►tai Fec,ltees Pian Six Year Capltai Facillties Plan, 2011-2016 Enterp.r[se Funds . Praject Titie: Street Utility i.mprovements Rtoject No: CpXxxx . Project Type: Non-CapaCity ' Praject Manager. TBD Descripttan: ' • . Water main improvements in coordination with 50S and generai arterial sireet improvements. Progress Summary: ; Future lmpact on Operating Budget: No sionifcant lmqact . Budget: 2010 Y70 Actual 2019 40 Budget Budget ` Expenditures Budget Belance • Adopted Budget - - ' Budget Amendments - - - - Adjusted Bvdget - - - " Activity: 2010 YE 2091. Year End Funding Sources: Prtor to 2010 Estirnate 2011 Bud et 2012 Budget Pro ect Total Unrestricted WaterRevenue 200,000 100,000 100,000 300,000 Grants{Fed,State,Locaf) - - - - ' 8ond Proceeds - - - - ' Other Total Funding 3ources: - 200,000 100,000 100,000 300,000 Capital Expenditures: • pesjqq - 20,000 15,000 15,000 35,000 - Rlght of Wey - - - - ' Construction 180 000 85 000 85,000 265.000 Total Expenditures: - 200,000 100,000 10,000 . 300,000 Forecasted Project Cost: . Total 2013 2014 2016 2016 2011-2016 Funding 5ources: Unres(riCtedWaferRevanue 200,000 200,000 200,000 200,000 9,000,000 Grents (Fed,State,Loca!) - - - - - 8ond Proceeds - - - • - Other - - Total Fundlrtg Sources: 200,000 200,000 200,000 200,000 1,000.000 Capital Expendlture§: , Design 20,000 20,000 .20,000 20,000 110,000 Right of Way - - - - - Construction 180 000 180,000 180,060 # 80 000 890,000 Total Expenditures: 200,000 200,000 200;000 200,000-:- 1,000,000 Grants / Other Sources: 58 WATER FUND (430) Capital Facitities Pian Six Year Capita[ Factlities Plan, 2014-2016 Enterpr[se Funds !'rojeotTifle: Water Resources Protection Pragram Project No: c10130 Project Type: Non-Capacity (Improvements) Project Manager: Thot'11 Descriptlon: Implement straiegies identifted in the Weflhead Protection Program to protect City water sources. Progress Summary: Future Impact on Operating Budget: IVo significant impact. . Budget: 2010 YTD Actua! 2019 10 Budget Budget Expendilures Budget ealance Adopted Sudget - - ~ 8udget Amendments Adjusfed 8udget ' - ' ACtiVity: 2010 YE 2011 Year End Funding Sources: Prlor to 2010 Esttmate 2011 Budget 2072 Budget Pro ect Total Unrestricted Water Revenue 35,800 - 21,900 22,500 57,700 Grants (FedState,Loca!) . - ' - Bond Proc:eeds - Other - Total Funding Souress: 35,800 - 21,900 22,500 57,700 Gapitat Expendltures: _ 35,800 Design 35.800 - ' RighfofWay ' 21.900 22,500 21,900 Ca~struction ' - Total Expenditures: 35,800 - 24,960 22,500 57,700 Forecasted Project CosE: Total 2013 2814 2015 ' 2016 2011 -2016 Funding Sources: UnrestricfedWaterRevenva 23,200 23,900 24,600 25,400 141,500 Grants (Feri,State,Loca!) ' ' Bond Proceeds - - • Other ' " Total Fonding Sources: 23,200 23,908 24,600 26,400 141,540 Capital Expenditures: Design - ' _ Right of Way - " Conslruction 23,2D0 23,900 24,600 25,404 141500 Total Expend(tures: 23,200 23,900 24,600 26,440 141,600 Grants ! Other Sources: 59 - WATER FUND (430) capttal FactIitles Plan . . Six Year Gapifal Facilities,Plan, 201 t-2Q16 Enterprise Funds Projectl`it[e: Annual Reservoir Repair & Replacement Program' . , Project No: Cpx7aX ` Project Type: Notl- Capacity Project Manager. TBD . Description: • . Periorm reservoir mainfenance such evaiuetion of facility conditton and installation sampte ports "and sefsmlc isolafion valves on inteUouflel piping. ~ . ~ ; Progress Summary: Future Impacf on Operating Budget: ' $udget: 2010 YTD Actual 2011 10 eudget - Budget _ Expend[tures Budget Balance Adopted Butlget - - - ' 8udget Amendments - - Ad%usted Budget - ' ' - Aotivity: 2010 YE 2019 Year End Funding Sources: Prlorto 2090 Estimate 2011 Bud et_ 2012 Bud et ProectTotal Unrestri6tedWaferRevenue - - 530 60 54,600 53,100 . Gianfs (Fed,Stale,Loca!) - ' - ' - 8and Proceeds - - . ' " Othet - ' ' Tota1 Funding Sources: - - 53,100 64,600 63,900 Capital Expendituras: - Desrgn - - 8,800. 9,100 8,800 ,Right of Way - ' " Construction - - 44,300 45;500 (44,300 . Total Expenditures: - - 63,100 54,600 53,100 , Forecasted Project Cost: Total 2013 2014 2015 2016 2011_-2016 Funding Sources: UnrastrictedWaterRevenue 56,300 58;000 59,700 61,500 343;200 Grants {Fed,Stata;CacaJJ Bond Proceeds - - - - Other - - - - - " Totai Funding Sources: 56,300 58,000 59;700 61,500 343,200 Capital Ezpenditures: , Desrgn 9,400 9,700 10,040 10,300 57,300 R1ght of Way - - _ " . - . Construction 96,800 48,300 49.700 51,200 285,900 . ToEal Expendlfures:. 56,300 58,000 59,700 61,500 343,200 Grants / Other Sources: 60 ~ WATER.FUND (430) capitai Facilities Pian . Six Year Capital Facilities Plan, 2011-2096. : Enterprfse Funds Projec#Title: SCADA Upgrades " ProJect No: C524a0 Project Type: Non-Capacity {Improvements} Project Manager: Lee Descr[ptlon: Upgrade. the existing Supervisory Control and Daia Acqoisition (SCADA) system, also known as the Telemetry system, to replace . 66solete componenfs and allow for control of the of the water utility facilities:- • Progress Summary. , Future lrripact on Operating Budget: ' No significant impad. _ Budget` 2010' ' Y7D Actual 2041 10 Budget : Budget Expendltures Budget Ba[ance _ Adopted Budget : - - - _ Budget Amendments ' Adjusted Budget . - - " - Activity: _ 2010 YE. 2011 YearEnd Funding Sources: Prlor to 2010 Esfimate 2011 Bvdgat 2012 Bud et . Pro ect Total • UnresfficledWatet Reve.nue 89,404 281,300 - 200,000 570,700 Grants (Fed,State,Loca!} - Bor+d Proceeds. 778,000 - 778,000 Other - " _ Total Funding Sources: 89,400 281,300 778,000 200;000 9,348,700 Capltai Expenditures: Design 89.400 50,000 - - 138,400 Right of Way - - Construction - 231,300 778,400 200,000 1 209 300 7otai Expenditures: 89,400 281,300 778,000 200,000 1,148,700 Forecasted Project Cost: . Total 2013 20i4 2015 2816 2011-2016 Funding,Sources: Unrestricted Water Revenue - - - - 200,000 Grants (Fed,Stafe,Loca!) - - ' " Bond Proceeds 778,000 . Other - - - Total F,unding Sources: - • - - 978,000 Capital Expenditures: _ Desfgn Right of Way ' - 978000 Construction _ Total Expenditures: _ • - - 978,000 Grants / Other Sources: • 61 , WATER FUND (430) cap3tal. Fa_.ci[Ities P►an Six Year Capital Facilities Plan, 2011-2016 ° Enterprise Funds Project7ttle: Fulmer WeII Field Improvements Project No: Cpxxxx Project Type: Project Manager: TBD " Description: • ` , Conduct an evaluation of the Wef{s 2, 6 and 7 faciliUes and the Fulmer Fie1d Carrosion Controf Treatment Facility fo assess,the suppfy and treatment capacity of ihe exis6ng faciliUes and infrastructure. Tha evaluation will indude an assessment of individuat and total wefi ' suppiy capacities, a review of the treatmentiaality operating and control paremeters, and recommendations for factlity artd controT fmprovements based on the evaluaGon. ; Progress Summary:- ~ Future Impact on Operat[ng Budget: Budget: 2010 YTD Actual 2011 10 Budget . Budget Expenditures Budget Sat_ance _ Adopted Budget . . ~ _ Budget Amendments ' . - - Adjusted,Badget Activitjr: 2010 YE - 2011 Year End- ` Funding Sources: Priar to 2010 Estimate 2011 Bud et 2012 Bud et Project Tatal UnrestrictedWaterRevenue . - - - • 300,000 - • Grants (Fed,State,locaJ) - • ' " Bond ProcBec/s - - 100,000 - 100,000 Ofher Total Funding 3ources• - - 100,000 300.000' - 100,000 • Capitai Expendifures: ' Design - - 100,000 300,000 100,000 Right ofWay - - - Construction - - - - - - Total Expenditures• - - 100,000 300,000 100,000 Forecasted Project Cost Tota( 2013 2014 2015 2018 2011 = 2016. Punding Sourees: • Unieshicted Wafer Revenue - - - 360,040 Grants (Fed,State,toceO - - ' ' _ Bond Proceeds ` - - - - , 100,000 Other. ' , Total Funding Sources: - • - 400,000 Capital fxpendttures: . Des(gn 400,000 Righf ot Way - - - - ' Construciron - - - Tota1 Expenditures: - - - - 400,000 Grants / Othee Sources: 62 WATER. FUND .(430) Capital Factlltfes Plan S1x Yeac Capital Facilities Plan, 2011-2016 Enterprise Funds project Title: M Street Grade Separation Pro}ect No: C201a Projeci Type: NOn-Capacity Prajecl Manager: $Weetirlg DescripEion: . . Construct distribution system improvements idenGfied in the 2009 Comprehensive Water Pfan Capital Improvements Program in conjunction with the M Street Grade Separaton project. • ~ Progress Summary: ; . Future Impact on Operating Budget: - Budget: 2010 YTD Actual ` 2011 10 Budget Budget Expenditures Budget 8alance . - ' - Adopted Budget , Budget Amendments - " , Adjusted Budget - - - ' Actlvity: 2010YE 2011 Year End Funding Sources: Prior to 2010 • Estlmate 2811 Budget 2012 Budget Pro)ect Total ' . UnrestdctedWaferRevenue 120.0O0 - 726,000 • Grants(Fed,State,Loca1) - - - ' - 8ond Proceeds - - , - - " Other - - - - ' Total Fund(ng Sources: - - - 120,000 - 120,000 Capitai Expenditures: ' Design - - - - - . Right oiWay - - ' ' " Constructlon - 120,000 120,000 • 7ota1 Expenditures: - - 120,000• - 920,000 Forecasted Froject Cost: Total , 2013 2014 2016 2016 2011-2016 Funding Sources: , . . ' UnrestrictedWaterRevertue - - - - 120,000 Grants (Fed;State,Locaq - - - , ' Sond Proceeds - - - ~ Qfher - - " Totat Funding 5ources: - - - - 120,000 Capital Expenditures: Design - - - - ' RigbtofWay - ' 120,000 Construction - - 7otat Expenditures: - . - - • 120,000 Grants ! Othar Sources: ' • 63 .WATER FUND (430) Capital Factltties Plan . Six Year Capital Facilities Plan, 2011-2016 Enterprise Funds Project Title: Lea Hili PRV Station Improvements ProJect No: cpXxxx . Projeci Type: Non-Capacity ~ - Project Manager TBD - Description: Repface pressure reducing valve stations in the Lea Hill area. • . Progress Summary: ' Future lmpact on Operating Budget: • BudgBt: 2010 YTD Actual 2011 • 10 Budget , Budget Expenditures Budget • Balanee Adopted Budget - - Budget Amendmenls Adjusted Budget - Act(vity: . 2010 YE 2041 Year End Funding Sources: Prior to 2010 Estimate 2011 Bud et 2012 Bud et Proect TotaL Unrestdcted WaterRevenue - 100,000 - - , 100,000 Grants (Fad,State,tocalJ - - - ' - BoRd Proceeds 250,000 - 250,000 ' . Olher - - TotalFundingSources: - 100,000 250.000, - 380,000 ' Gapitalfxpenditures: Deslgn - 70,000 - - 70.000 f3ght otWay - - • - - Constfucfion 30,000 250,000 280,000 Totat Expendttures: - 100,000 250,000 - 360,000 Forecasted Projebt Cost: Total 2013 2014 2015 2018 ° 2011-2076. . Funding Sources. Unrestdcted WalerRevenue - - - Grents (Fetl,Stete,Local} - - - - ' , ' Borrd Pmceeds - - - - 250.00' Other - - - - Total Funding Sources: - - - 260,000- - Capital Expenditures: - • Desigrt - - - • - ' Right of Way - - - 254 000. Constructlon - Total'Expend(tures: - - - - 269,000 Grants ! Other Sources: -64 WATER FUND (430) capital FacuEties ptan Sfx Year Capital Facilities Plan, 2011-2016 Enterprlse Funds Project 7itle: Deduct Meter Replacement Project Project No: cpxxxx Praject Type: NOn-Capacity • Project Manager: TBD Description: Fteplace mefers, assoaated piptng and surface restoration at high votume services where domestic water is currently used for irrigatfon purposes. Progress Sammary: ' i Future Impact on Operating Budget: Budget: 2070 YTD Actual 2041. 90 Budget . Budget Expenditures Budget Balance Adopted Budget - - - ' Budget Amendments - - Ad%usted Budget - - - ' ACtivity: . 2010 YE 2091 Year End Funding Sovrces: Prior to 2010 Esttmate 2019 'Budget 2012 Bud et Project Total Unrestricted INaterRevenue - 150,040 - - 150,060 ' Grants(Fed,State,toca!) - - - - ' Bond Proceeds - - 400,000 - 400,000 Other - ' Totai Funding Sources: - 150,000 400,000 - 550,000 Capita[ Expendltures: DesTgn - 100,000 - - 400,000 Rtght of Way - - - - " ConstrucEion - 50,004 400,000 - 450,000 Total Expenditures: - 180,000 400,000 - 560,000 Forecas#ed Project Cost: Total 2013 2014 2015 2095 2014-2016 Fundtng Sources: UnrestrictedWaterRevenue - - - - ' Grants (Fed,Slate,Locsl) - - - ' ' Bond Proceeds - - - - 400,000 Other ' Tofal Funding Sources: - - - - 400,000 Capital Ezpenditures: Design - Righl of Way - - - - " Consirucfion - - - 400,000 Totat Expenditures: - - - - 400,080 Grants ! Ofher Sources: 65 ` WATER FUND (430) ` Capitat Facilitles Plan' • Six Year Capital! Facilities Plan, 2011-2096 Enterprlse Funds Project'riue: A Street NW Corridor Project No: C207A Project Type: Non-Capacity , Project Manager. TBD Descriptlon: . _ , Constnrd water system impravements in conjunc6on with the new arterial street corridor of A Street NW beiween 14th Street MJV anii 3rd Street NW. Progress,Summary: ~ • . _ - . . Future lmpact on OperaEing Budget: • Budget: 2010 YTD Actuat 2011 10 Budget Budge! Expenditures SuQget Batance ' - Adopted Budget. - - - - . Budget Amendmsnts - - - • Adjusted Budget AcdVity:`' . 2010 YE 2011 Year End Funding Saurces: - Priorto 2010 Estimate 2011 Bud et 2012Bud Budget ProJect Total Unrestdcted Water Revenue 50,000 - 54,000 Grants (Fed,Stafe,Loca!) - - _ _ , Bond Proceeds - - 350,000 - 35Q,000 Othsr Total Funding Sources: - 50,000 350,000 - ` 400,000 CapitafExpend[tures: ' Design - 50,000 - - 50,000, , . Righf of Way _ _ _ _ Constructton 350,000 - 350,000 Total Expendltuies: - 50,000 350,000 - -400,000 Forecasted Project Cost: . ` 7ota1 2013 ~ 2014 2015 2078 ' 20111. 2016 Funding Sources: _ Unrastricted Water Revenue - - - - Grants (Fed,Sfate,Locaq - - - _ : 8ond Proceeds - - - 350,000 Oiher Total Fundtng Sourees: 360,000 . - ' Capffa( Expenditures: Desfgn - - - - - Right of Way - - - ' _ _ Consfruction - - 350,000 7ota1 Expenditures: , - - • - . 350,000 Grants COther Sources. 66