Loading...
HomeMy WebLinkAboutITEM IV-C-5 ; SANITARY SEWER UTILITY D1VlSlUN . MtSSION STATEMENT . Provide for efficient, environmenfally sound, and safe management of the existing and future sanitary sewer waste needs of. the City of Auburn: ' DEPARTMENT OVERVIEWSome of the key administrative and engineering -dutles inciude comprehensive system planning, ; interaction . and regttla#ton of devetapment, implertzenting Capital lmprovement Projects, and system : budget management. Operational duties incfucle general system maintenance, rriinor repair and construdion, -and day-to-day operation. The Cify is - responsibte fpr the coliection and transmission of effluent to King County *trunk lines. Auburn contr~acts with King Coun#y,for efftuent treatment and disposal. 2009 & 2010 ACCOMPUSHMENTS ■ Completed and adopted the updated Sanitary Sewer Comprehensive Plan,in December, 2009 . . . , . ■ Completed construction on . the.third phase of the Auburn Way South; sanitary sewer replacement.program , , ■ Replaced the Dogwood Pump Station , ■ Completed plans far the replacement of ihe E1lingsonrPump siation • ■ Began the installation of upgrades to the SCADA rystem ■ Continued to establish the use of Flexidata to manage remote CCTt1 inspection videos and information . ■ lmplemenied the case of Cartegraph, as a work order management systems and continued to develop SOP's for updating databases for Cartegraph and GiS m Continued to irriplement the fats, oils, and grease (FOG) reduction program Completed u#ility revenue and expense analysis 2011 & 2012 OBJECTIVES ' o Complete Rainier Shadows and White Mountain Trails Pump' Station " decommissioning project . ' • Complete replacement-qf the Ellingson Pump Station ■ Continue to upgrade the asset management databases through records evaluation and field investigation ~ Add backup power to four additional pump station's . Continue planning and preparation for emergencies induding potentiaC flooding due fo Howard Hanson Dam issues Compiete manhole ring and cover replacement project ■ Complete 2011-12 repair and replacement project ~ Complete the replacmen# of the Dogwood Pump Station . - Review a11 city properties with Finance & 15 to assure each developEd property connected to the system has a sewer billing in Springbrook . ■ Enhance uti►ity business practices and policies to insure consistent revenue collection for the sewer utiliiy _ \ SEWER Ft1ND ' 2011-2012 WORKING CAPITAL BUDGE[' 2008 2009 2010 2011 2012 • item Adual Actuai Adj Budget Budge3 Budget Operattng Budget - OPerafing Revenue 343.500 Services $ i3,601,391 14,902,464 S 15,337,800 ~ 17,570.300' 3 17.978.600 Total Operating Revenue 13,601,391 14,902,464 15,337,800 17,570,300 17,978,600 . Operating Expense . 535.000.10 SalarfesandWaAes (1,375;187) (1,481,407) (1,524,900) (1,500,370) (2,520,710) 535.000.20 Personnel Benefits (516,492) (545,539) (535,709) (628,520) (695,290) 535 000.30 3upplies (50.816) (95.981) (157;200) (98,700) 003,800) 535 000.40 Services & Charges (1,378,043) (1,727,288) (1,773,300) (1,835.690) (1.842,400) 535.000.50 IRtergoverrtmental (8,949.543) (11A15,596) (10,911,600) (13,493,390) (13,493,390) 535:000.90 Interfund Payments for ServEces (607,575) _ (677,538) (489,280) , (788,650) (794,000) 535.000.00 Depreciation & Amortizatlon (1.282 599) (1390 b60) 0102 000) (1-378 000) -.(1:378,000) Total Operating Expenses (I4158 ?55) {16.934A09) (16.493.980) (14.723.320) (19,827,590) Operating Income (Loss) (556>8b4) (2,031,545j (1.156,180) (2,153,020) (1,8481940) Non Operattng.Revenue (Exp) 361310 Investrnent lncome 426,168 . 137J96 135,000 36,000 33,000 374:10 M1T Contributtons 0 0 0 0 0 •369.900 Miscellaneous Revenue (Expense) (1,180) 17,048 0 0 0 535.10b.80 Debt Service Interest : (20.807) (21.255) (336.400) (248,400) 1240.100) 7ota1 Non Oper. Rev (Exp) 404J81 133.589 (201,400) (212.440) f207,1001- . Nef Income (Loss) (152,683) (1,897,956) (1.357,580) (2,365,420) (2,056,890) Add/Dedud [tems Not • Affecttng Working Capitai {WK) 535:801.00 Depreclation & Amortizatlon 1,282,599 090.660 1,102.000 1,378.060 1.378,000 = Net W/C Prom Operations 1.129,916 (507.296) (255,580) (987,420) • (b78,090) Other Resources and Uses Budget Resources Other Than Operatloru 391.800 Pubtic works Tnust Fund Loan 0 0 0 0 0 396.101 Contributed Cap-Sys Dev 357,289 583,614 350.000 350,000 350.000 ' 34b.102 Contributed Cap-Area Assez 13.755 81763 0 d 0 396.104 Contrlbuted Cap-Outside Dev 6,724,789 • 0 0 0 0 382.200 Revenue 8ond Proceeds 0' 0 6,493,200 0 0 397.100 Transfer In 0 89,425 0 0 0 399300 lncrease in Restrided Nei Assets 252,761 59,235 0 0 0 399.000 Other 5ources 101.117 22,500 0 0 _ 0 Total Refources 7,449.711 723,537 6,843,200 350.000 350,000 Uses Other 7han Operattons . ` 590.100. Other Uses , (6.687,694) (437,223) 0 0 Q 590.10041 Inc in Fixed Assets-Sataries/Wages (116,416) . (154,504) (109,700) (151,500) (153,600) 590.100.21 - Inc in F1xed Assets-Benefits (40,366) (50.448) (41,400) (53.100) (53,800) ' 597.100.55 Transfer Out (50.000) (50.000) f$8.260J (50.000) (50,008) 590.100:63 Inrin Fixed Assets-Improvements (19,389) (15,543) (57,400) (30.000) 0 590.100,64 lnrin Ftxed Assets-EquEpment (49,050) (20,481) (16,000) 0 0. 590.160.65 Inc in Fixed Assets-Constnudion (1,237,340) (3,084,999) (3,786,100) (5,908.900) (925,500) 590.106.66, .lnc in Fixed Assefs-Capital Lease 0 0 0 0 Q 590:100.78 Debt Service Principaf (236,791) (236,791) (244,000) `(5]8,200) (524500)_ Total Uses (8.437.546) f4.050,489) (4,312.800) (6,711,700) (1,707,4001 Net Change (n W/C 142.081 13.834,2491 2.274.820 f7349_1201 f2.035.4401 Beginning W/C i/] 14.443.192 ,58 ,273 12,218,392 14,493,212 7. ,092 - Ending W/C 12/31 14.585 273 10 75I 024 t4,493.212 7144 092 _ 5108 602. Net Change in W/C , Note: ' Interfund Payment & Servtces lncludes $250K for Annex lease ' Prelfminary - indudes estimated revenue & expenses related to 2010 revenue bond lssuance 8/19t2010 1:59 PM 2 glWkSheetObj:rpt Budget Flex UVorksheet by Ubject: Sewer Fund 431 . Page: 18 08/1912010 9:41AM • City of Auburn 431 SEWER Title/Object 2009 Acfuals 2010 Adj Budge! 2010 YTD Actuals 2011 2012 00 CAFR ONLY 05 NET INCftEASE RESTRICTED CASH 437,220.00 0.00 2,240.00 0.00 0.00 06 WORKING CAPI7AL 10,751;020.00 2,746;940.00 11,083,360.00 7,144,090.00 5,108;600.00 ` Total CAFR ONLY 11,188,240.00 2,746,940.00 71.085,600.00 7,144,090.00 5,108,600.00 • 10 SAIARIES & WAGES . 11 REGULAR SALARIES & WAGES 1,616,440:00 1,576,000.00 871,990.00 1,596,370.00 1,61010A0 12 OVERTIME 17,810.00 28,600.00. 10,060.00 30,600.00 30;600.00 . 13 OTHER WAGES 1,660.00 30,OOD.00 , 0.00 24;900.00 24;900.00 , Total SALARIES & WAGES 1,635,910.00 1,634,600c00 882,050.00 1,651,870.00 1,674,310:00 20 PERSONNEL BENEFITS 21 F:1,C.A 121,400.00 570,100.00 65,930.00 126;000,00 119,920.00 22 UNIFORMS 6,320:00 7,000.00 , 2;820.00 12,900.00. 121900.00 23 PENSfQNS 110,500.00 0.00 46;480.00 84,760,00 85;780.00 24 INDUSTRIAL.:INSURANCE 21,120100 0.00 ' 14;260.00 30150.00.. 30,74000 25 MEDICAL & UFE INSURANCE 397,920.00 0.00 192,40060 427;210.00 499,7SO.00 28 UNEMPLOYMHNT CLAIMS, 0.00 0.00 7,$30.00 0.00 0:00 Total ' pERSONNEL BENEFI7S 577,260.00 577,100.00 329,720.00 681,620.00 749,090.00 30 SUPPLIES 31 OFFICE & OPERATING SUPPLIES 54,720.00 124,700.00 9,050.00 76,200.00 84,800.00 35 SMALL TOOLS AND EQUfPMENT 41;260.00 33,400.00 12,900.00 22;500.00 19,000.00 7otdl , SUPPLIES 95,980:00 158,100.00 21,950.00 98,700.00 103;800.00 40 07HER SERVICES A CHARGES ' 41 PROFESSIONAL SERVICES • 151,750.00 ' 187,600.00 88;850.00 233,540.00 236700.00 42 COMMUNICATIQN 41,790.00 38,00000 ' 23;570.00 46;800.00 48;600.00. 43.7RAVEL " 3,140.00 6;300.00 680.00 7,000.00 • 7,60O:00 45 :OPERA'fING RENTALS & LEASES 750.00 ° 5,000.00 660.00 5,000A0 5,000.00 46 INSURANCE 82,770.00 98;500.00 " 57;110.00 84,400.00 861100:04 47 UTIUTIES 40,830.00 38,600:00 . 19,850.00 43;600.00 43,600.00 48 REPAIRS & MAJN7ENANCE 171,030.00 159,000.00 93,010.00 183,600.00 183,600.00 49 MISCEILANEOUS 1,235;250.00 1,263,400.00 682,800.00 1,231,750:00 1;231,800:00 . Tptal O7HER SERVICES & CHARGES 1,727;310.00 1,796;400.00 966;530.00 1,835;690.00 1,842,400.00 50, INTERGOVERNMENTAUINTERFUND ' 51 INTERGOVERNMENTAL SERVICES 11,015,600.00 11,200,000.60 6,995,080.00 13,493;390.00 13,493,380.00 55 OPERATING TRANSFERS OUT 50,000.00 ' 58,200.00 58,200.00 -50;000.00 50,000.00 • Total INTERGOVERNMENTAUINTERFUND 11,065,600.00 11,258,200.00 7,053;280.00 13,543;390:00 13,543,390.00 ' 60 CAPITAlOUTLAY ` 63 IMPROVEMENTS OTHER 7NAN BUILDING 15,540.00 57,400.00 0.00 30.000.00 0.00 64 MACHINERY & EQUIPMENT 20,480.00 16;000,00 9.150.00 0.00 0:00 65 CONSTRUCTION PROJECTS 3,087,870.00 7,322;200.00 792,310,00 , 0:00 0.00 TOt81 CAPITAC OUTLAY. 3,123,890.00 7,395,600.00 809,460.011 30;000.00_: 0.00 , 70 DEBT SERVICE PRINCIPAL 72 REVENUE BONDS 0.00 0.00 0:00 230,00100 236;300.00 W . Page:`18 glWkSheetObj.rpt - Budget Flex Worksheet by Objecfi: Sewer Fund 431 Page: 99 08/1912010 9:41AM City of Auburn , 431 SEWER . , Title/Object 2009 Actuais 2010 Adj Budgef 2090 YTD Actua/s 2091 2012 78 INTERGOVERNMENTAL LOAN 236,780.00 244,000:00 268,260:00 288,200.00 288,200.00 Total DEBT SERVIGE PRINCIPAL ' 236,790.00 244,000.00 288,260.00 518,200:00 524,500.00 80 DE67 SERVICE INTEREST - 83 SPECtAtASSESSMENT IMEREST 21,260.00 273,600:00 120,050:00 248,400:00 240,100.00 1'ptal DE67 SERVICE.INTERE57 21,260.00 273;600.00 120,050:00 248,400.00 240,100.00 90 INTERFUND PAYMENTS FOR SERVICES 93 EQUIPMEN7 REN7Al CHARGE-FUEL 24,440.00 19,400.00 11,480:00 31,000.00 32,600.00 " 94 7iUe Not Found 20,480:00 • 0:00 '0:00 0.00 0.00 95 INTERFUND.OPERATING,RENTALS & LEASES 169;400:00 118;700.00 69,240.00 114,400.00 120;100:00 97 INTERFUNO PRINTING SERVICES 38,900.00 3,600.00 2,100.00 . 3,700.00 3,700.00 98 INTERFUND FACILITIES 46,700:00 72,680:00 42;400:00 317,500.00 310;300:00 99 INTERFUNO IS SERVICES 377,600.00 274,900.00 160,360.00 322,050.00 327,300.00 Total INTERFUND PAYMEN7S FOR SERVICES 677,520.00 489,280.00 285,500.00 788,650.00 794,000.00 Total SPWER 30,349,760.00 26,573,820.60 21,834,400.00 26,540,610.00 24,580,790.00 . , .P F 19 g1WkSheetObj.rpt Budget Flex Worksheet by Object: Sewer Administration page: A 0811912010 3:59PM City of Auburn ' - 431 SEWER _ 00. SEWER 535 UTlLITIES 100 GENERAL ADMINISTRATiON Title/Object 2009 Actuals 2010 lldj Budget 2010 YT'D Actuals 2011 2012 90. SALARIES & WAGES 11 REGULAR SALARIES & WAGES 574,210A0 608,200.40 347,980.00 599,610:00 609,700.00 12' OVERTIME 1,120.00 1,500.00 300.00 1,500.00 1,500.00 13 OTHER WAGES 0.00 `8,000.40 0.00 0.00 0:00 Total . SALARIES & WAGES 575,330.00 617,700.00 348,280.00 601,110.00 611,200.00 20. RERSOPtNEt BENEFITS . 21 F.I:C:A. 42,400:00 217,200.00 25,930.00 44,870.00 46,420.00 ' 22 UNIFORMS 40.00 1,000.00 80:00 11000.00 100:00 23 PENSIONS 38,330.00 0:00 18;460.00 '32180.00 33,250:00 24 (NDUSTRIAL INSURANCE ' 6;2$0.00 0.00 ' 4,904.00 9,660.00 . 9,860:00 , 25 NiEDICAL & UFE INSURANCE 102,970.00 0.00 66,859.00 138,490.00 464,440.00 28 UNEMPLOYMENT CLAIMS 0.00 0.00 3,100.00 0.00 0.00 Total PERSONNEL BENEFITS 190,020.00 218,200.00 119,320.00 226,200.00 254,670.00 . 30 $UPPCIES • 31 OFFIGE & OPERATING SUPPUES 770.00 10,000.00 0.00 5,000.00 5,000.00 35 SMALL TO.OCS AND EQUIPMENT 480.00 10,000:00 170.00 5,000.00 . 5,000.00 'To61 SUPPGIES 1;250.00 20,000:00 170.00 10,000.00 10,040.00 40 OTHER SERVICES & CHARGES -41 PROFESSIONAL SERVICES 61,610.00 26,600.00 29,870.00 45;200.00 45,400.00 42 COMMUNICATION 1,440.00 0.00 650.00 2,000.00 2,000.00 43 TRAVEL . 0.00 2,000.00 0.00 2,000.002,000.00 46 INSURAMCE . 82,770.00 98,500:00 57,110.00 84,400.00 86,100.00 48 REPAIRS & MAINTENANCE 0.00 0.00 2,820.00 0:00 0.00 49 MISCELLANEOUS 1,820.00 30,000.00 15,17000 6,000.00 6,000.00 Total OTHER SERVICE$ & CHARGES 147,640.40 157,100:00 105,620.00 139,600.40 141,500.00 80 DEBT SERVICE INTEREST - 83 SPECIAL ASSESSMENT IN7EREST 21,260.00 23,600.00 20,050:00 ` 248,400.00 240100.00 . Total DEBT SERVICE INTEREST 21,260.00 . 23,600.00 20,050:00 . 248,400.00 240,100.00 90 INTERFUND PAYMENTS FOR SERVICES 97 INTERFUND:PRtN71NG SERVICES. _ 38,900.00 3,600.00 2,100.00 3,700.00:, 3,700.00 98 INTERFUNDFACILI7IES 46,740.00 72,680.00 42,400.00 317,500.00 310,300.00 " 99 IN°fERFUND IS SERVICES 377,600.00 274,800.00 160,360.00 322,050.00 327;300.00 Total INTERFUND PAXMENTS FOR SERVICES 463,200:00 351,180:00 204,860.00 643,250.00 641,300.00 Total GENERALADMINISTRATION 1,398,700.00 1,387,780.00 798,300.00 1,888;560.00 , 1,898,770.00 cn : . ~ Page: 1. - yiwrksheet.rpt Sewer Administration Page: 4 08/1912010 3:57PM City of Auburn Account Number 2009 Actuals 2010 Adj Budget 2010 YTD Actuals 2099 2012 431 SEWER ' 00 SEWER 535 UTILITIES. 535.100 GENERAL-ADMINISTRA710N _ - , 535.100.11 REGULAR SAlAR1ES & WAGES 574,210.00 608;200.00 347,980.00 599,610:00 609;700,00 535.100.12 OVERTIME & OTtIER WAGES 1.120.00 1,500.00 300.00 1,500:00 1,500.00 535.100.13 OTHER WAGES 0.00 8,000.00 , 0:00 0.00. _ 0.00 Total SALARIES &'WAGES 575,330.00 617;700.00 348,280:00 - 601,110.00 . 611,204.00 535.100.21 F.I.C.A. 42,400.00 217,200.00 25,930.00 44;870.00 46,420.00 535.100.22 UNIFORMS & CLOTHING 40.00 , 1,000.00 80.00 1,000.00 1,000.00 535.100.23 PENSIONS 38,330.00 0,00 18,460,00 32,180.00 33,250.00 535.100.24 INDUSTRIAL INSURANCE 6,280.00 0.00 4,900.00 9,660.00 900.00 535.100.25 MEDICAL & LIFE INSURANCE 102,970.00 0:00 66,850.00 138,490.00 164,140.00 535.100.28 UNEMPLOYMENT ClA1MS 0.00 0.00 3,100.00 0:00 • 0.00 ' Total PERSONNEL BENEFITS 190,020.00 218,200.00 119,320:00 226,200.00 254,670.00 535.100.31 OFFICE & OPERA7ING SUPPLIES 770.00 • 10,400.00 0:00 5,000.00 5,800.00 535.100.35 SMALL TOOLS & MINOR EQUIPMENT 480.00 10,000.00 170.00 5,000.00 5,000.00. 7ota) SUPPLIES 1,250.00 20,000.00 170.00 10,000.00, 10,000.00 535.100.41 PROFESSIONALSERVICES 61,610.00 26,600.00 29,870.00 45,200A0 45,400.00 535:100.42 COMMUNICATION 1,440,00 0.00 650.00 2,000.00, 2,000.00 535.100.43 TRAVEL 0.00 2,000.00 0.00 2.000.00 2,000.00 535.100.46 INSURANCE 82,770.00 98;500.00 57,110.00 84,400.00 86,100.00 535.100.48 REPAIRS & MAINTENANCE 0.00 0.00 2;620.00 ' 0.00 0.00 535.100.49 MtSCELLANEQUS 1,820.00 30,000.00 15,170.00 6,000.00 6,040.00 ' " TOta( OTIIERSERVICES:& CHARGES 147,640:00 157,100.00 105,620.00 139;600:00 141,500.00 535.100.83 DE67 SERVICE INTEREST . '21,260.00 23,800.00 20,050.00 246;400:00 240,900:00 ~ : . , Page: 1 glWrkSfieet.rpt - Sewer Admintstration Page: 7 0811912010 3:57PM City of Auburn , - . Account Number 2009 Acfua/s 2010 AdJ Budget 2010 YTD Actuals 2019 2012 ; Total DEBT SERVICE INTEREST 21,260A0 23,600.00 20,050.00 248,400.00 240,100.00 535.100.97 INTERFUND PRINTING SERVICES 38,900.00 3,600.00 2,100.00 3,700.00 3,700.00 535:100.98 IN7ERFUND FACIUTIES 46,700.00 7200:00 42,400.00 317,500.00 310,300.00 535.100.99 INTERFUND IS SERVICES 377,600.00 274,900:00. 160,360.00 , 322,050.00- 327,300.06 Total INTERFUND PAYMENTS FOR SERVICES 463,200.00 351,780.00 204,860s00 643,250:00 " 641,300:00 Total GENERALADMINISTRATION 1,398,700.00 . 1,387,780.00 798,300.00 1,868,560.00 1,898,770.00 Total U71U'TIE$ 1,398,700.00 1,387,780.00 798,300.00 1,868,560.00 ,1,898,770,00 ' Total SEVNER 1,388,700.00 1,387,780:00 . 798,300:00 1;868,560.00 - 1;898,770.00 - Totai SEVIIER 1,398,700.00 1,387,780.00 798,300.00 1;868,560.00 1,898,770.00 , Grand Total 1,398,700.00 1,387,780.00 798,300.00 1,888,560.00 1,898,770.00 - . . ~ - - Page: 2 Budget Detail Report ~ Page: 9 0812712010 8:14AM ~ City of Auburn 431 SEWER 00 SEWER 535 UTILITIES 535.100 GENERALADMINIS7RA?'ION 535.100.10 SALARIES & WAGES u~...e~.~~..~.~......r........-...w~.~.. ...~...`a..~.+......,..~......~..~.a. 2010 2011 2012 1 Administrative Overtime 1,500.00 1 Administrative Overtime 1,500.00 1 Admfnistrative Overtime 1,500.40 Line Items 7otal 1;500,00 Line Items 7ota1 1,500.00 Line Items Tota1 1,500.00 ~ Change in Budget 0.00 Change in Budget 0.00 , . . , . , , 335.10013 ~THER WAGES ..v:- i..... ~ ~ . _.:....i!_ i.t..! ..~.....1.:: . . ,_.u::........ . . . . 2010 2011 2012 1 Facility Management Intem 8,000.00 ' Line ltems Total 8,000.00 Line Items Total 0.00 line items Tota! 0.00 • Change in Budget -8,000.00 Change in Budget 0.00 535.100.20 PERSONNIEL BENEFITS ~ 535:10Q 22~UNIFORMS ~iCLOTHING _ ` _....~w_::~. _._...i.._.~..... . , 2010 • ~ 2011 2012 . 1 Uniforms (Engineering) 1,000.00 1 Unfforrns (Engineering) 1,000.00 1 Uniforms (Engineering) • 1,000.00 Line Items Total 1,000.00 • Line Items Totat 1,000.00 Line Items Total 1,000.00 Change in Budget 0.00 Change in Budget 0.00 535.100 30 SUPPLIES C & OP.EATING' 535100 3~ OFFIE _ ~ 2014 2019 2012 1 Office Supplies-Engineering 10,040.00 1 Office Supplies-Engineering -(Note: 5,000.00 1 Office Supplies-Engineering -(Note: 5,040.00 Line Items Total 10,000.00 Reduced based on previous years' use.) Reduced based on previous.years' use.) Line Items Total 5,000.00 Line Itams Total 5,000.00 Change in Budget -5,000_00 Change in Budget 0.00 , %l.i :~u.v~~-..,lr',:~.,.~. 535:100 35 ~MALl.700LS B;:aU11NOR;EQUIP,MENT 2010 2011 2012 1 Smali 7ools-Engineering 10,000.00 1 Small Tools-Engineering -(Note: Reduced 5,000.00 1 Small Tools-Enginee(ng -(Note: Reduced 5,000.00 Line Items Total 10,000.00 based on previous years' use.) based on previous years' use.) , Line items Total 5,000.00 Line Items 7otal 5,000.00 ' Change in Budget -51000.00 Chenge in Budget 0.00 535.100.•l0 OTHER SERVICES 8 CHARGES . . _ : . . . M1 -_,i:r-' . . .~,..,.r ^r~.!. ....,..-r..-. r „ ~ . ^~••~.r~,^~:'.".,, , ~ ~~"°t~"- 7 7 ~ FESSIONAL_SER1/ICES,. ` L.+a~i:n.Ca.+ :.:v~e.:...-..• ~~.r.» . . 535.100 41 PRO ...;i;n y ~ ~:...s.a.._i.~A,.....,.,.a...;,,:..~r.~~ v-- ~.t ~ ~.~.~.:.._._~.,._..._.::.~_.~_,,._.._.~...,:......,.:......._..._W......_~ r~( . ~ ~ irt .~...,~1 t 2010 2011 2092 1 State Auditor Payment 8,600.00 1 State Auditor Paymeirt 10,200.00 9 State Aud'rtor Payment 10,400.00 2 Professional Services (Engineering) 18,000.00 2 On-call Engineering Services 20,000.00 2 On-call Engineering Services 20,000.00 ~ Line Items Total 26,600.00 3 On-call modeling senrices 15,000.00 3 On-call Modeling Services 15,000.00 Line Items Total 45,200,00 Line Items Total 45,400.00 Change ln Budget 18,600.00 Change in Budget 200.00 ~ P=ae: 1 Budget Detail Report Page: 2 08/2712010 8:14AM City of Auburn 431 SEWER 00 SEWER 535 UTILITIES . 535.100 GENERAL ADMIMISTRATION 535.100.40 OTHER SERVICES & CHARGES ' ~35100 42 ,.....s . . ~ }L..:,.~..w.,u,... ..LW ......w,.".,.,..w......~.,.« , w ,....u .w .t~~__ . ~.....,..W W ~,w...A.~......._,.......~..,....:.~,:I.:,,...,ti:,.~L.~.`~~,'_.a„„1 0... ~ ~ - --..U 2010 2011 2012 . 1 [ncreased based on previous years use. 2,000.00.._.1 .._1ncrQased based on previous years use. 2,000.00 Line items 7otal 0.00 Line ltems Total Z,ppp,pp Line Items Total • 2,000.00 Change In Budget 2,000.00Change In Budget 0.00 -,~r 535:100.43...'fF2AVEL_ .,......,.~.~,k.... . ~.......,..W_1_, - ._,...u.,.w.....~,v~_..Y..r..._._~ . 2010 2011 2012 1 Travel Charges (Enginee(ng} 2,000.00 1 Travel Charges (Engineering) , 2,000.00 1 Travel Charges (Engineering) 2,000.00 Line Items Totat 2,000.00 Line Items Total 2,000.00 Une Items Total 2,000,00 Change In Budget 0.00 Change in Budget 0.00 , 53S ...__.~_.._~.,.._....~.~.:..............1....~._....,....:,.....-..~.........~~..,....u.........,~.i..~.....i.. .:L,;..... .t. . .t...:,~.....v....;d.~..:.:....~.....:..-.tv:...~...-..::...~„t...s.~.•..d.t~.aK t.. ~ :i ia -.:~..r .................~w..... = -.:..s".«..~...:..J.t.~.. 2090 2011 2012 ' 1 Distributed Insurance 98,500.00 1 Distri6uted Insurance 84,400.00 1 D'isbibuted Insurance . 86,100.00 Line Items Total 98,500,00 Line Items Total 84,400.00 Line Items Total 86,100.00 Change In Budget -14,100.00 ~ Cbange In Budget 1,700.00 535100,49,~_ MI5CELLANEOl15: .,w...._........,w....W...~._... _...,..,.~..,,.,._w~._.~_.w.. '~..~..~.._..._.~.nw~..~, ,......,.,~.._.,...._..y....w~.'_;...._....:...,.» ~ ` ~ : . ..A..,. ' .J~ ..to-:.. ; < :_..~.'~;.....:W;~...~,..:.:. . a...~....t ..W.;W.~....;:...,,,a ; 2010 - 2011 2012 1 7rainfng (Engineering) 5,000.00 1 Tratning (Engineering) 5,000.00 1 7raining (Engineering) 5,000.00 2 Publications-WW Design 500.00 2 Publications-WW Design 500.00 2 Publications-WW Design 500.00 3 Recording Fees (Engineering) 500.00 3 Recording Fees (Engineering) 500.00 3 Recording Fees (Engineering) 500.00 4 June Mayor D/C reailocate for Cartegraph & 24,000.00 Line Items 7otai 6,000.00 Line ltems Total 6,000.00 Hydraufic modeling soflware Line Items Total 30,000.00 Change In Budget -24,000.00 Change in Budget 0.00 535.100.80 DEBT SERVICE INTEREST 535;,1~00:83 ;DEBT SERVICE;iNl'~REST' ' ' •S ' ~ ~ . ,.~.w.w.........vr«.u...w..:..W...~w..eu....~.............i.r.,.~.~.-,aw..iwl.~.~..i.,.w.~..u..i...J .r...wrWaw.a..uu.w.w.ua.uur~u..~ul+..v....u...~.w..w[....r....~..,,.v.D.~...~.y.r..+afu"~' .uw.r.ur..w~w.~i.W..t'.i+:+rw.r..wrr. - 2010 2011 2012 1 04691-001 PWfF Loan-AWS Sewer 8,100.00 1 04-691-001 F'WfF Loan-AWS Sewer 7,500.00 1 04-691-009 PWTF Loan-AWS Sewer 7,000.00 Replacement Phase i- Interest Replacement Phase I- Interest Repfacement Phase I- interest 2 06-962-003 PWTF Loan-AWS Sewer 10,900.00 2 06-962-003 PWTF Loan-AWS Sewer 14,400.00 2 06-962-003 PWfF Loan-HWS Sewer 13,500.00 Replacement Phase II - lnterest Replacement Phase II - Interest Repiacement Phase II - lnterest 3 08-951-002 PVYfF l.oan AWS 5ewer - 4,600.00 3 2010 Revenue Bond Interest 226,500.00 3 2010 Revenue Bond Interest 219,600.00 Interest Line ltems Tofal 23,600.00 Line Items Total 248.400,00 Line Items Total 240,100.00 Change in Budget 224,800.00 Change in Budget -81300.00 535.100.90 1NTERFUND PAYMENTS FOR SERVICES ' S3S '[0.0~97 1NTERFUND,~PRINT1NGySERV1CES - ____._~~..._...__~:..~._.._~__._...._.._._._._.._.._._..w..~_.......___.,.v_ _.a...~...._,._.._ ~ ._...u.:;~.._.:.:~:~~:_..::...a~:....:...~ 2010 2411 . 2012 se Page: 2 Budget Detail Report ~ Page: 3 08/27/2010 8:14AM City of Auburn 431 SEWER 00 SEWER 535 UTILITIES ~ 535.100 GENERAL ADMINISTRATION ~ 535.100 90 INTERFUND PAYMENTS FOR SERVICES ffi 535:~00 97.....;INTERFUNDLPRfIVTING SERVICES ,.w_...~........,~.,;:~.~:Y..,.~...~~„~:~.~..x,~.,,..._.,~...._.~..,,_...,.,_~.»~~.v.~~~..~..,... .,_....,~.~..~....~..,.~~..~W~ j ~ . . ,_,.,.,~.w..,..~.u,:..;;:~.. ,~:~.::.~,..~:....~.:..~..~ti,..u::d~«. v; 2010 ~ 2011 2012 1 Muftimedia Services 3,600.00 1 Muftimedia Services 3,700.09 1 Mukimedia Services 3,700.00 Line Items Total 3,600.00 Une Items Total 3,700.00 Une Items Total 3,700.00 Change In Budget . 100.00 Change in Budget 0.00 :r ~35:100 98~ :INTERFUND-FACtLITIES . , ; . ....__~,.,.,..__,_.,,_,~.._....,_.s::..~......... ....::~.r. .,...'.:.;...r,.i.~..,.,,.s:;~....,..,...~ , ......:w.;... ,w..,....:.....,......_ ~...~~...,.~....,.....~...~,..~.,..r .............w`r.L.J....~,.W~~~.~,.:,,~.,,.....o...~..,,..y..:+~..........~..~..~....,..w.._ 2010 2091 2012 1 Facilities Services 72,680.00 1 Facilfties Services 67,500.00 1 Facilities Services 60,300.00 Line items Total 72,680.00 2 Annex Rent 250,000.00 2 Annex Rent ~ 250,000.00 Une Items Total 317,800.00 Une items Total 310,300.00 Change 1n Budget 244,820.00 Change in Budget 7,200.00 535.100 99 : 1NTERFUND IS:SERVICES . ».~....,~..._...._.....!...L..-:,::...c..,u:.v;-...1......._..~.-.~._i~....__.~...~.,..._...,._........... - ..........._..._._..,.........._.W... _-,..:,..~:..a....~-..::3.. _,s;. . ~ y 2010 2011 2012 1 IS Services 274,900.00 1 IS Services 322,050.00 1 IS Services . 327,300.00 Line Items Total 274,900.00 Une Itams Total 322,050.00 Line Items Total 327,300.00 Chan e in Budget 47,150.00 Change in Budget 5,250.00 Total Line Items 562,380.00 Total Line Items 1,043,750.00 Total Une Items 1,035,400.00 Total Change in Budget 489,370.00 Total Change in Budget -8,350.00 ~ C> P--e: 3 , ylwksheetobj.rpt Budget FIex,Worksheet by:Object; Sewer!Finance Admin Page: 081191201.0 3:58PM City.of Auburn 431 : SEWER 00 3EWER . 535 UTtLITIES - . ~ 110 GENERAL ADM(NISTRATION Title/Object 2009 Actuals 2010 Adj Budget 2090 Actuals 2011 2092 10 SALARIES & WAGES 11 REGULAR SALARtES & WAGES 330,190.00 289,300.00 -184,350.00 285,160.00 290,160.00 ' 12 OVER7IME 300.00 0.00 460.00 1;000.00 1,000.00 13 OTHER WAGES.. 1,660.00 0.00 0.00 0.00 0.00 Tota! , SAIARIES & WAGES 332,150.00 281,300.00 184,810:00 286,160.00 291;160.00 20 PERSONNEL BENEFITS . 21 F.I:C.A. ' 24,160:00 100;800.00 13,680.00 20;700.00 21,070.00 23 PENSlONS 22,170c00. 0.00 . 9,690.00 75140.00 _ 15,410.00 24 IND.USTRIAL INSURANCE 11,480:00 0.00 1;030.00 " 1,420.00 1,420:00 . 25 MEDICAL & LIFE INSURANCE . • 64,940.00 0.00 38,180.00 71,060.00 83;060.00 _ 28 UNEMPIOYMEN7 CLAIMS 0.00 0.00 4,730.00 0.00 0.00 Total PERSONNEL BENEFITS 112,750.00 100,800.00 67,310.00 108,320.00 120,960.00 30 SUPPUES 31 OFFICE & OPERATING SUPPUES 11100.00 1,700.00 640.00 1,700.00 1;800.00 35 SMALL TOOLS AND EQUIPMENT . 0.00 900.00 0.00 1,000.00 1;000.00 Total , SUPPUES 1,190.00 2,600_00 640.00 2,700.00 2,800.00 40 OTHER SERVICES A CHARGES ' 41° PROFESSIONAL SERVICES 69,420:00 49,000.00 49;870.00 78;340.00 81;300A0 • - 42 COMMl3NICATION- 19,370:00 20,000.00 11,790.00 21,300.00 23;100.00 43 TRAVEL . 390.00 1,600.00 380.00 1,500.00 11500.00 49 MISCELLANEOUS 490.00 4,500:00 270.00 1,750.00 1,800.00 Total OTHER SERVICES & CHARGES . 89,670.00 75,100.00 54,310.00 102,890.00 107,700.00 - 60 CAPITAL OUTLAY . • Total CAPITAL OUTLAY 0.00 ; 0.00 0.00 0.00 0.00 - 90 INTERFUND PAYMENTS FOR SERVICES Total INTERFUND PAYMEN7S FOR SERVICES 0.00 0.00 0.00 0.00 0.00 Total GENERAL ADMINISTRATION 535,670.00 459,800.00 307,070.00 500,070.00° 522,620.00 • ~ . . . . ' . ' ' . ' . . . . . . ' . . . - Page: 1 glWrkSheet.rpt Sewer Finance Admin Page: 0811912010 3:57PM Clty of Au6urn , Account Nu►nber 2009 Actuals 2010 AdJ Budget 2010 Acfuals 2019 - 2092 ' 431 SEWER • 00 SEWER 535 UTILtT1ES . 535.110 GENERAL ADMINISTRATION . . 535.110.11 REGULAR SALARIES & WAGES 330,190.00 281,300.00 184,350.00 285,160.00 290,160.00 535.110.12 OVERTIME & OTHER 1NAGES - 300.00 0:00 460.00 1,000.00 1,000.00 535.110.13 OTHER WAGES. 1,660,00 0.00 0.00 0.00 0.00, Tptal SALARIE5 8 WAGES 332,150.00 281,300.00 184,810.00 286,160.00 . 291,160.00 535.110.21 F.I.C.A. 24,160.00 100,800.00. 13,680.00 20,700.00 21,070.00 535.110:23 PEFlSIQNS 22,170.00 0.00 9,690.00 15,140:00 15,410.00 535.910:24 INDUSTRIAL INSURANCE 1,480.00 0.00 1,030.00 1,420.00 1,420.00 535.110.25 MEDICAL & L1FE INSURANCE 64,940.00 0.00 38,180.00 71;060.00 83,080.00 535.11018 UNEMPLOYMEN7 CLAIMS 0.00 0.00, 4,730.00 0.00 0:00 _ . , 7ota) PERSONNEL BENEFITS 112,750.00 100,800.00 67,310:00 108;320.00 120,960.00 535.110.31 OFFICE 8 OPERATING SUPPLIES 1,100.00 1,700.00 ' 640.00 1,700.00 1,800.00 535.110.35 ' SMALL TOOLS AND EQUIPMEN7 0.00 ' 900.00 0.00 1,000:00 1,000.00 Total SUPPLIES 1,100.00 2,600.00. 640.00 2,700.00 2,800.00 _ 535.110.41 PROFESSIONAL SERVICES 69,420.00 49;000.00 41,870.00 78,340:00 81,300:00 535.110.42 COMMUNICATION 19,370.00 ' . 20;000.00 11,790.00 " 21,306A0 23100.00 535.110.43 TFLAVEL 390.60 1,600.00 380.00 1,500a00 1,500.00 - 535.110.49 MISCELLANEOUS 490.00 4,500.00 270.00 1,750:00 1,804.00 Total. OTHER SERVICES & CHARGES 89,670.00 75000.00 -54,310.00 102,890.00 107,700A0 Total CAP17Al;0UTLAY 0.00 0.00 0.00 0;00 0.00 ~ , Tota) INTERFUND~PAYMENTS FOR SERVICES 0.00 0:00 4.00 0:00 0.00. N ' _ _ . Page: 1 giwrksheet.rpt . , Sewer Finance Admin ~Nage: ' 2 , 0811912010 3:57PM !City of Auburn . . Accounf Nurnber . 2009 Actuals 2010 Adj Budget 2010,Acfuals • 2094 2012 ` Total GENERALADMINIS7RATION 535,670:00 459,800.00 307;070.00 500;070:00 522,620:00 Total UTILITIES 535,670.00 459,800.00 307;070.00; 500,070.00 522;820:00 Total SEWER 535,670.00 459;800.00 307,070.00 . 500;070.00 522,620:00 . Total SEWER 535,670:00 459;800.00 307,070.40 500,074:00 522,620.00 Grand Totat 535;670,D0 ~459;800.00 307,070:00 _ 500,070:00 522,620.00 , . . Pager 2 Budget Detait Report Page: 1 08120/2010 8:26AM City of Auburn 431 SEWER 00 SEWER 535 UTILITIES _ 535.970 GENERALADflfllNIS7RATION 535.910.10 SALARIES & WAGES . •,-..-----..----r , . :r •,.----m- , r--, ; 53591012 OVERTiME & 07FlER;WAGES ~ , _ ' , ..____.r..___....__.___~..._._.~...~..w.,......_..~,. _..._~_.....~;~.~....~.:w._~.._,___,..4.._~~.....~:.:_......~:.:<.:~__..._.._.~..,_._..y..:.~...~__:~..,.L..._..~...:.~__..M_~. ._s.. . _ 2010 20 ~1 2012 1 Overtime - Finanae - Udlities - Projects 1,000.00 1 Overtime - Finance - Utilrdes - ProJects 1,000.00 Line Items Total 0.00 Line Items Total 1,000.00 Line Items Total 1,000.00 - Change in Budget 1,000.0011 Changa in Budget 0.00 535.970.30 SUPPLIES - - .i,?, ;,,x. : n•~,'-?''~;"_ -7-7 ~ : $351:10 31 OFFICE 8~ OPERATJNG SUPPUES _ .w_.a_.....» . , , . . i ioi o 2011 2012 1 Office Supplies-Finaace 1,700.00 1 Office Supplies-Finance 1,700.00 1 Office Supplies-F(nance 1,800.00 Line Items Total 1,700.00 Line Items Total 1,700.00 Line Items Total 1,800.00 Change in Budget 0.00 Change in Budget 100.00 _ . _ _ ~ ~..~:.:y~...... ..::~._~„~..:,.~ya.~.:~:;.~..r.:... 2010 2011 2012 ' 1 Small Toois and Equipment-Finance 900.00 1 Small Tools - Finance - replacement - 1,000.00 1 Small Toois - Financs - replacement - 1,000.00 Line Items Total 900.00 phone headsets, chairs phone headsets, chairs . Line Items Total 1,000.00 Une Items Total 1,000.00 Change in Budget 100.00 Change [n Budget 0.00 535.910.40 OTWER SERVICES & CHARGES 535:110.41 PROFES510NAL .~,,!~w~_ ~~'.c,.}It: i.....,~ .~s........__..._._,.~.,._~.. _ ~`t~:;:'t r , ,xu i ;.i i 2010 2011 2012 1 Dataprose - Print & Process Utility Bills for 13,000.00 1 CSG (Dataprose) - Print & Process Utility 10,140.00 1 CSG (DaWprose) - Print & Process U61ity 11,000.00 Billing Bills for Billing Bills for Billing 2 PSE - lockbox Transactions 7,400.00 2 PSE - Lockbox Transacdons 7,400.00 2 PSE - Lodcbox Transactions 7,400.00 3 Collection Svcs. & Credit Card Fees 28,600.00 3 Bank Credft Card Fees 45,500.00 3 Bank Credit Card Fees 46,500.00 Line Items Total 49,000.00 4 Bank Charges 7,000.00 4 Bank Charges 7,500.00 5 5pringbrook Web upgrade 1,500.00 S Springbrrokweb programming 1,500.00 6 Springbrook programming fa 300_00 6 Springbrook programming fix 300.00 7 Temporary Hetp coverage of phones and 5,000.00 7 Temporary Help - coverage of phones and 5,500.00 utility front desk utifity front desk 8 Webcheck Fees - escrow estimates 1,500.00 8 Webcheck Fees - escrow estimates 1,600.00 Line Items Total 78,344,00 Une Items Total 81,300.00 Change ln Budget 29,340.00 Change in Budget 2,960.00 , 535:1.10.42. COMMUNICATION L _ ._ur...uo..w.,............-...w.,.....'.u.....,...... _..._.✓.......:::::..a._........::ti:...._.... _ i . . _.y~~ i~-. -`:31 ' •:i::~t..t.•_ .~~..,~.i...~ .~,.~r.,....,:M.t.`.~..~..~ . , • 2010 2071 2012 1 Utility Billing Postage 20,000.00 1 CSG (Dataprose) Utility Billing Postage ' 21,200.00 1 CSG (Dataprose) t)titity Billing Postage 23,000.00 Line ltems Total 20,000.00 2 Phones - Nextel 100.00 2 Phones - Mextel 100.00 Line Items Total 27,300.00 Line ttems Total 23,100,00 • , Change in Budget 1,300.00 Change in Budget 1,800.00 ~ . P-e: 1 ~ Budget Detail Report ~ Page: 2 0812012010 8:26AM Cityr of Auburn 439 SEWER 00 SEWER 535 UTILtTIES • 535.190 GENERAL ADMIN{STRATION 535.110.40 OTHER SERVICES & CHARGES b35 91 Q 43 TRA1/E.L ....i.. ~ ,.~.W...,...........,......,.. ~....~....,...._..J,,....., t,. ~~,~....~r..,..-....L..,... ..>o.v. ~.,.,.,r.....,...._......ra ~...4..l~.,ev.u . ~,..,..,e..,.....,...v.::w.~.w..,.~.uar.u..w...3...'.;~...,.~ua....:ahc.m.,.....~n.:.: 2010 2011 2092 • i Travel Charges (Fnance) 1,600.00 4 Travel Charges (Finance) 1,500.00 1 7ravel Charges (Finance) . 1,500.00 Line Items Total 1,600.00 Une Items Total 1,500.00 Une Items Total 1,500.00 Change in Budget -100.00 Change in Budget 0.00 LANEOUS ~35110.49 MISCELT . 1.:; . , „ - . . , _ K.. . w..w.,......,.. ,.~w . _ . ...~d~.....k.... . _ _ 2010 2011 2012 pw 1 Training (Finance) 1,600.00 1 Training (Finance) 1,500.00 1 Training (Finance) • 1,500.00. 2 Miscelfaneous 2,900.00 2 Springbrook conference 250.00 2 Springbrook Conference 300.00 Une Items 7otal 4,500.00 line Items Total 1.750,00 Une Items Total 1,800.00 Change in Budget -2,750.00 Change in Budget 50.00 7otal Line Items 77,700.00 . Total Une ltems 106,590.00 Total Llne ttems 111,500.00 • ' Total Change in Budget 28,890.00 Total Change in Budget 4,910.00 ~ tn Page: 2 glWkSheetObj.rpt ' Budget Flex Worksheet by Objecfi: Sewer Operations Page: 1 08199/2010 3:59PM City of Auburn , 431 SEWER 00 SEWER 535 UTILITIE5 800 OPERATIOfVS - TitleJObject 2009 Actuals 2010 Adj Budget 2010 YTD Actuals 2011 2012 00 CAFR ONLY - 01 DEPRECiATION 1,390,660.00 1,102,000.00 805,220.00 9,378,000.00 1,378,000.00 Total CAFR ONLY 1;390,660.00 1,102,000.00 805,220.00 1,378,000:00 1,378,000.00 • 10 SRLARIES & WAGES 11 REGULAR SALARIES & WAGES 557,540.00 576,800.00 320,310.00 560,100.00 565,350.00 12 OVERTIME 16;390.00 27,100.00 10,470.00 28,100.00 28,100.00 13 OTHER WAGES 0.00 22;000.00 0:00 24,$00.00 24;900,00 TOtal SALARIES & WAGES 573,930.00 625,900.00 . 330,780.00 613,100.00 818,350.00 20 PERSONNEL BENEFITS 21 F.I.C.A 43,340.00 210,704.00 24,990.00 49,730.00 421530.00. 22 UNIFORMS 6,280.00 6,000.00 2,740:00 11,900.00 11;900.00 23 PENSIONS 39,170.04 0.40 17,360.00 29,740.00 . 30,020.00 24 INDUSTRIAL INSURANCE 11,070.00 0.00 8,030.00. 17;360.00 25 MEDICAL & LIFE IP[SURANCE 123,680.00 0.00 73,420.00 185260.00 217,850.00 - Total PERSONNEL BENEFITS 223;540.00 216,700.00 126,540s00 294;000.00 319,660.00 30 SUPPUES • 31 OFFICE R OPERATWG SUPPUES 52,850.00. 113;000.00 - 8,41.0.00 69,500.00 78;000.00 35 SMALL TOOLS AND EQUIPMENIT 40,780.00 22,500.00 12,730.00 16,500.00 13,000.00 Total. SUPPI,IES 93;630.00 135,500.00 21,140.00 86,000.00 91,000.00 40 OTHER SERVICES & CHARGES • 41 PROFESSIONAL SERVICES 20,720.00 112,000.00 ' 17,110.00 110,000.00 1101000.00 42 COMMUNICATION 20,980.00 18,000.00 11,130.00 23,500.00 23;500.00 43 TRAVEL 2,750.00 2,700.00 300:00 3,500.00 3,500.00 45 OPERATING RENTALS & LEASES 750.00 5,000:00 660.00 51000.00 , 5,000:00 47 UT1L111ES 40,830:00 38,600:00 19,850.00 43;600A0 43;600.00 " 48 REPAIRS & MAINTENANCE 171,030:00 159,000:00 90,190.00 183;600.00 183,600.00 49 MISCELLANEOUS 11,120:00 18,900.00 9,900.00 14;000.00 14;000.00 Totaf OTHER SERVICES & CHARGES 268,180:00 354;200.00 141,140.00 383,200.00 383;200.00 50 INTERGOVERNMENTAI.lINTERFUND . 51 INTERGOVERNMENTAL SERVICES 11,015,600.00 11,200,000:00 6,995,080:00 13,493;390.00 13,493,390:00 Tptal INTERGOVERNMEN'PAUINTERFUND 19,015600:00 11,200;000;00 6,995,080.00 13,493;390.00 13,493,390:00 90 INTERFUND~PAYMENTSFORSERVICES. 93 EQUIPMENI"RENTAL CHARGE=FUEL, 24,440.00 19,400:00 11,400.00 31,000:00 32,600.00 94 TiUe Not Found20;480.00 0,00 0.00 0:00 0:00 95 INTERFUND OPERATING RENTALS & LFASES' 169,400.00 118,700.00 69,240.00 114,400:00 120,100.00 Total INTERFUND. PAYMEN7S FOR SERVICES 214,320:00 738,100.00 80,640.00 145,400.00 152,700:00 W . . F 1 glWkSheetObj.rpt Budget Flex Worksheet by vbject: Sewer operations Nage: 2 08/1912010 3:59PM City of Aubum 431 SEWER 00 SEWER 535 UTtLITIES TOtal OPERATIONS 93,779,860.00 13,772,400.00 8,500,540.00 96,393,090.00 16,436,300.00 ~ Page: 2 glWrksheet.rpt , Sewer Operations Page: 1 08/19/2010 3:57PM City of Auburn Account Number 2009 Acfuals 2010 Adj Budget 2010 YTD Actua/s 2011 2012 431 SEWER 00 SEWER 535 UTILl7iES 535.800 OPERAT'lONS 535.800.01 DEFREGIATION 1,390,660.00 1,102,000.00 805,220.00 1,378,000.00 1,378,000.00 Total CAFR ONLY 1,390,660:00 9,102,000.00 805,220.00 1,378,000:00 9,378,000.00 535.800.11 REGULAR SALARIES &WAGES 557,540.00 576,800.00 320;310.00 560,100,00 565,350.00 . 535.800.12 OVERTIME & aTHER WAGES 16,390.00 27,100.00 10,470.00 28,100.00 28;100.00 535.800.13 OTHER WAGES 0.00 22,000,00 0.00 24,900.00 24,900.00 Total SALARIES & WAGES 573,930.00 625,900.00 330,780.00 61 3,100.00 618,350,00 535.800.21 F.I.C.A. 43,340.00 210,700.00 ' 24,990.00 49,730.00 42,530.00 535.800.22 UNIFORMS & CL07H1NG 6,280.00 6,000.00 2,740.00 . 11,900.00 91;900.00 535.800.23 PENSIONS 39;170.00 • 0.00 17,360;00 29,740.00 30,020.04 535:600.24 JNDUSTRIALJNSURANCE 11,070.00 0.00 8,030:00 17,370.00 17;360.00 , 535:800.25 MEDICAL & UFE INSURANCE 123,680.00 0.00 73,424.00 185,260.00 217,850.00 Total PERSONNEL BENEFI7S 223,540.00 216,700.00 126,540.00 294,000:00 319,660.00 535.800.31 OFFICE & OPERATING SUPPLIES 52;850.00 113,000.00 8,490.00 69,500.00 78,000.00 535.800.35 SMALL TOOLS & MINOR EQUIPMENT 40,780.00 22,500.00 12,730.00" 46;500.00 13;000.00 Total SUPPUE& 93,630.00 135,500.00 21,140:00 86,000.00 •91,000.00. 535.800.41 PROFESSIONAL SERVICES 20,720.00 912,000.00 17,110.00 110,000.00 710,000.00 535.800.42 COMMUNICATION 20,980.00 18;000.00 11,130.00 23;500.00 23,500:00 535.800.43 TRAVEL 2,750.00 2;700.00 300.00 3;500.00 3,500:00 535.800.45 OPERA7ING RENTALS & LEASES 750.00 . 5.000:00 660.00 5;000.00 5,000:00 535.800.47 PUBUC UTlLITY SERVICE 40;830:00 ' 38,600:00 19,850.00 43;600.00 43;800:00 536.800.48 REPAIRS:& MAINTENANCE 171;030.00 159,000:00 90,190.00 183;600:00, 183,600:00 535:800.48 MISCECLANEOUS 11,,120.00 18,900.00 1,900.00 14,000:00 14,000A0 OD . . Page: 1 giWrkSheet.rpt . SeWer Opel°dt[ons . Page: 2 -0811912010 3:57PM City of Auburn, Account Number 2009 Actuals 2010 Adj 8udget 2010 YTD Actua/s 2011 ' • 2012 Total OTHER SERVICES & CHARGES _ 268,180:00 . 354;20100 , 141,140:00 ~ 383;200.00 383,200.00 535.800.51 INTERGOVERNMENTAL SERVICES 11;015,600.00 11,200;000.00 6,995,080.00 13;493,390.00 ,13,4931390.00 ' Tota) INTERGOVERNMENTAUINTERFUND 17,015,600:00 11,200,000.00 6,995,080.00 13,493,390.00 13,493,390.00 535.800.93 INTERFUND SUPPL[ES 24,440.00 19,400.00 11,400:00 31,000.00 32,600.00 535:800.94 INTERFUND CAPI7AL OUTIAY 20,480.00 0.00 0:00 0.00 0.00 535.800.95 INTRFUND OPER RENTALSILFASES 169,400.00 ; 118;700.00 69,240.00 114,400.00 120,100.00 TOt2i1 INTERFUND PAYMENTS FOR SERVICES 214,320.00 138;100.00 80,640.00 145,400.00 152,700.00 Total OPEF2A71QNS 13;779,860.00 13;772,400.00 8,500,540.00 16;393,090.00 16,436;300.00 Total UTILITIES 13,779,860.00 13,772,400.00 8,500,540:00- 16;393,090.00 16,436;300.00 Total SEWER 13,779,860.00 13,772,400.00 8,500,540.00 16,393,090.00 16,436,300.00 Tot81 SEWER 13,779,860.00 13,772,400:00 8,500,540.00 16;393,090.00 16,436,300.00 , Grand Total . 13,779,860.00 13,772;400.00 _ 8,500,540.00 16,393;090A0 16,436,300.00 , cfl Page: 2 Budget Detail Report Page: 9 08120/2010 8:26AM City of Auburn 431 SEWER 00 SEWER 535 UTILITIES 535.800 OPERATIONS ' 535.800.00 CAFR ONLY . . . -:^-~-rM. ..-.-i . ,+--rm-. _.n.- .-r .i,'*--•~vr---'--~^ ~ i nrrr-+-~^,T--.+f ~ . . t, ra ~,..-'.~f +E,+. Tl : 535;:800 ....__.._..._.._._.,_...y......._....~..~~....._...y.........s,r+.................. .....N, ~,..~_...:.i...l..t_. _..~_...a.....~__.....__ .u._._w...,. .........i ~i.. ~~.~..<....eLa.u..~v~v...,-.~~.i:u`-=`»...........-....t.~ ..~~L::; u..~.uj.u ...J....L.~~{ •~s.w..:.... ..r..:S.i::tr'~~: ;`1 2010 2011 2012 1 Original budget 1,102,000.00 1 Deprecia6on 1,378,000.00 1 Depreciation 1,378,000.00 Line Items Total 1,102,000.00 Line Items Total 1,378,000.00 Line ltems Total 1,378,000.00 ' Change in Budget 276,000.00 Change in Budget 0.00 535.800.10 SALARIES & WAGES ;535:80012 : :OVERTIME OTHER:-WAGES . . . , r 2010 2011 2012 1 Regular Emptoyee Overtime 9,500.00 1 Regular Employee Overtime 10,500.00 1 Regular Employee Overtime 10,500.00 2 Standby Pay , .17,600.00 2 Standby Pay 17,600.00 2 Standby Pay 17,600.00 Une Items Total 27,100.00 Line Items Totat 28,100.00 Line ftems 7otal 28,100.00 Change in Budget 1,000.00 • Change in Budget 0.00 2010 + v 2011 2092 1 Temporary maintenance woricer 22,000.00 1 Temporary maintenance workers (3) at 24,900.00 S Temporary maintenance workers (9) at 24,900.00 Une Items Total 22,000.00 three months. three months. Une Items Total 24,900.00 Une Items Total 24,900.00 • Change in Budget 2,900.00 Change in Budget 0.00 535.800.20 PERSONNEL BENEFITS ' 535 800,22... UN1F0„RMSa& CLOTFiING.~_:;~_ ......_w.~...,...._.,~~..........~,L.~.~.:..~,__,...,~..~-..~~.~ZLL~L.4.w,.M.wL .~,......._ME R~~uu..~._,~....._L...~a~..:.,~.~.A,:s:a..,~........~.... s•-~,.:..,..._ 2010 2091 2012 1 Uniforms (M & O) 6,000.00 1 Uniforms (M & O) 7,000.00 1 Uniforms (M & O) • 11,900.00 Une Items Total 6,000.00 2 laundry Service (moved from 49) 4,800.00 Une Items Totai 11,900.00 Une Items Total 11,900.00 Change in Budget 5,900.00 Change 96 Budget 0.00 535.800.30 SUPPLIES . -„--b-- -~--~-------r 'S35:80031 2090 w 2011 2012 1 Bioxide (Odor Control) 45,000.00 1 Bioxide (Odor Control) 25,000.00 1 Bioxlde (Odor Contron 25,000.00 2 Microcat (Grease Contron 18,000.00 2 Microcat (Grease Control) 18,000.00 2 MicrocaE (Grease Controi) 18,000.00 3 Fittings Inventory 5,000.00 3 Fittings Inventory 5,000.00 3 Fittings lrrventory 5,000.00 4 General Operations Supplies 20,000.00 4 General Operations Supplies 20,000,00 4 General Operalions Supplies 20,000.00 5 BA# 5 Carry forward fittings inventory 25,000.00 5 Gas detedion sensors 1,500.00 5 Generators battery reptacement 3yr cycle 4,000.90 Line Items Total 113,000.00 Une Items 7otal 69,500.00 6 Pump station drywell dehumidifier 4,500.00 repiacement . 7 Gas detection sensors 11500.00 • Une ltems Total 78,000.00 . , Change in Budget -43,500.00 Change in Badget 8,500.00 N O ' Pnqe: 1 Budget Detail Report Page: 2 08l20/2010 8:26AM City of Auburn 431 SEWER 00 SEWER 535 UTILITIES ' 535.800 OPERATIONS 535.800.30 SUPPLIES ~ S35800 35 SMA LL'TOO_.LS MINOR ....,..~_k__.~..._ .w._.w~._.:..:_.._..,,.~..~....~...~..._...,...._...__..~.e__...._..v..~u,w. ..:,.~..,...,.w..,.;...~._....ww.~ , ~ Y.y.....~.... ,w~:.. ~..4._:....,. ~.w...~~,.:.M_,...~.......,~..~;~.,...~:.:..Y.;.w::~=. .W~= 2040 • 2011 2012 1 SmaU 7ools-OperaUons 8,000.00 1 Small Toois-Operations - replacement of 6,000.00 1 Smail Tools-0perations - replacemerrt of 6,000.00 2 Crew Quarters Upgrade (Fumiture) 10,000.00 existing service vehide tools, chain saw, existing senrice vehicle tools, chain saw, 3 BA# 5 Carry forward gas detector & 4,500.00 impact wrench, metai detedors, mainline impact wrench, metal detedots, mainline pneumatic plugs repair equipment & sewer mainline repair equipment & sewer mainline Line Items TotaJ 22,500.00 cleaning nozzles cleaning noales 2 Crew Quarters replacement (Fumiture) 2,500.00 2 Fall protection - confined space equipment 2,500.00 3 Fall proteciion - confined space equipment •4,000.00 requirement • requiremerrt 3 Sewer mainllne repairs - Trenching & 2,500.00 4 Sewer mainline repairs - Trenching & 2,500.00 HxcavaGan hydraulic shoring equipment Excavation hydraulic shoring equipment requirement requlrement 4 Gas detection monitors - required for 1,000.00 5 Gas detedion monitors - required for 2,000.00 confined space entry confined space entry 5 Sewer mainline pipe repair cut off saw 11000.00 6 Sewer mainline pipe repair wt off saw 1,000.00 6 Metal detedor 600.00 7 Metal detector 600.00 7 lmpact wrertch 400.00 . 8 Impact wrench 400.00 8 Sewer mainline pipe repair cut off saw -1,000.00 9 Crew Quarters replacement (Fumiture) -2,500.00 Line Items Total 13,000.00 Line Items Total 16,500.00 Change in Budget -6,000.00 Change in Budget -3,500.00 535.800.40 OTHER SERVICES & CHARGES . -7 -777 '83'S 800 41 PROF. ESS O A',S T' 77777, - - I N L~. ~R5/1GES ' 2010 T..y...._.._.._._.__.. _...._._..,.ti.~.~..,W_,_...,.....~_..._..__._.~. 2011 F 2012 .V.. 1 Professional Services (M & O) 112,000.00 1 Professional Services (M & O) SCADA, 40,009.00 1 Professional Services (M & O) SCADA, 40,000.00 Line ltems Total 112,000.00 Wondervvare & TelemeUy Support Comract Wonderware & Telemetry Support CoMtact 2 Easement malnline de-roodng / cleaning 50,000.00 2 Easemenf mainline de-rooting / cleaning 50,000.00 Pro9ram program 3 Annual electrical pump station testing 10,400.00 3 Annual electrical pump statlon testing 10,000.00 4 Cathodic Protection Equipment testing & 10,000.00 4 Cathodic Protection Equipment testing & 10,000.00 malntenance maintenance Line ltems Total 110,000.00 Line Items Total 110,000.0() Change !n Budget -2,000.00 Change in Budget 0.00 - 535.800i42 COMMUNICATION .....~...,......,....~.._,.w._ _ _.....w.........i....., v... .........1:~.,....~. .~...~<...+.wu....~..~..~..+..........,.+..,.v....~ .......^.~.•.x.w.....w~..wl..~ 4 .o, ~ 2010 2011 2012 1 Telemetry, Line Locates, Cell Phones 18,000.00 1 Leased telephone lines for pump sta6ons, 23,500.00 1 Leased telephone lines for pump stations, 23,500.00 Line Items Total 18,000.00 cell Phones & fleld lap tops oommunicaNon cell phones & fleld lap tops communication sprint cards • sprint cards Line Items Total 23,500.00 Line Items Total 23,500,00 Change in Budget 5,500.0011 Change in Budget 0.00 535:$OQ:43 TRAVEL : , ~ . f ~ ~ , : • } ; ~ f ~ r. . . r. .6 .~...Y..~t .....w+..~....w..+..i..r..~~....~. f..~..tiW.~ ...~~.'i.:.:1.~.L....J.~..~.'.::~...,~...4..:.L.1'.'...a...4~.i..:rl:...:.1J..4.:::~....~.. '....r.~..Y~.' ' : . 2010 2014 2012 N • ~ Page: 2 Budget Detail Report Page: 3 08/2012010 8:26AM CityofAuburn. 431 SEWER 00 SEWER 535 UTlUTIES 535.800 OPERATIONS 535.800 40 OTHER SERVICES & CNARGES ^°.z^°^ari-q .._.~....r._ ~ TRA 77 7 ..r. r....4 , ,....w,...,., , ~ . . ~r.. . y, . 2090 2019 ~ 2012 1 7ravel Charges (M & O Operations) 2,700.00 1 Trave[ Charges (M & O Operations) 3,500.00 1 Travel Charges (M & O Operatiuns) 3,500.00 Line Items Total 2,700.00 P+ofessional Affiliation Committee meetings • Professional Affiliation Committee meeUngs Line Ifems Total 3,500.00 Line Items Total 3,500.00 Change ln Budget 800.00 Change in Budget 0.00 - 535 800 45 OPERATING REN~'ALS & LEASES a _ t r , _ j`i~;1 2070 2011 2012 1 Operating Rentais 5,000.00 1 Operating Rentals - Emergency equipment, 5,000.00 1 Operating Rerrtals - Emergency equipment, 5,000.00 Line Items Total 5,000.00 pumps, ect pumps, ecL Lfne Items Total 5.000.00 Line Items Total 51000.00 Change in Budget 0.00 Change in Budget 0.00 , - , . . a 535:800 47_,_ . . PUBUC UTIU'TY:SEtiYICE :tJ , : ~ ~ ' , - _ _ _ • ~ ' t - - . __..~.~..._r,.......__._._.........~~...... ~ . _ _ " 2010 2011 . 2012 1 Utilities 38,600.00 1 Utilities- (Increased based on 2009 actuafs) 43,600.00 1 Util'rties- (Inereased based on 2009 actuals) 43,600.00 Line Items Total 38,600.00 Line Items Total 43,600.00 Line items Total 43,600.00 Change in Budget 5,000.00 Change in Budget 0.00 535.$00 48 ; REPAIRS & MAINTENANGE, .....a_._.. ..~..,_:,.~.~._....'....,_~..,:._a_,.____a_.._...L... ._..a..a_~~.,.,...i, : ~.,.~..y__.z._...__,~.~~.,_..~..~.~,..`....._~..:..~........:~~w,:~._.,..~_ ,..:ui.. 2010 2011 2012 1 Pump Station Repair 40,600.00 1 Pump Statlon Repair - pumps, motors, 40,600.00 1 Pump Statton Repair - pumps, motors, 40,600.00 2 Small Equipment 1,440.00 controls controls 3 Contracted Repair (emergency situations) 75,000.00 2 Small Equipmen! 1,400.40 2 5mall Equipment 1,400.00 4 Generator Mafntenance 8,800.00 3 Cor►tracted Repair (emergency sRuations) 85.000.00 3 Contracted Repair (emergency s'duations) 85,000.00 5 Crawler Camera Maintenance 16,600.00 Force mains, Mainlines or stubs in the Right Force mains and mainline repairs of Way 4 Generator MaiMenance & repairs 20,000.00 6 Wet Well Cleaning 16,640.00 4 Generator Maintenance 20,000.00 5 Crawler Camera MaiMenance 16,600.00 Line Items Total 159,000.00 5 Crawler Camera Maintenance 16,600.00 g Wet We11 Cleaning 20,000.00 6 Wet Wel{ Cleaning 20,000.00 Line Items Total 183,600.00 Line ftems Total 183,600.00 Change in Budget 24,600.00 Change in Budget 0.00 535:800.49; • MISGELLATJEOUS ; ' ; , , " , , , .»....._._._.._.:_._~.:_._,'.,......'_....:.,.'~t.~.~i;..;. , , .:...:J.:lltG..i....:... f. }.,_..~:::...::r::.,.::.:_:....._.:.. 2010 2011 2012 1 Laundry Service 4,900.00 1 Training (M & O) SCADA, Wondervvare, 13.000.00 1 Training (M & O) SCADA, Wondervware, 13,000.00 2 Training (M & O) 13,006.00 Telemetry, PNCWA, WOW 8 WWCPA. TelemetryPNCWA, WOW & WWCPA. 3 King County ROW permits 1,000.00 2 Laundry Services 4,900.00 2 King County ROW permits , 1,000.00 Line Items Total 18,900.00 3 King County ROW permits 1,000.00 Line Items Total 14,000.00 4 Laundry Services (moved to 22) -4,900.00 Line Items Total 14,090.00 ' Change in Budget -4,900.00 Change 1n Budget 0.00 N P-qe: 3 Budget Detai! Report Page: 4 0812012010 8:26AM City of Au6urn 431 SEWER 00 SEWER 535 UTILITIES 535.800 OPERATIONS 535.800.50 lNTERGOVERNMENTAUIN7ERFUND 535:800:51 INTERGO\%ERNMENTAL SERVICES ..........-.a..._...... . . ...~.....~.........._~...._..._..~......._..wv,3.. v.7.....,_~1....~ ..,a..u~ .._i..~.... r......._ ..r~.... ~_.~....~I.:. _w..~.~... .......w.v....«..L.~.........,..........~.........w...3....1'J~.i...w...:i.:li:J.~:Jla4ii'n'..J:L::u.c.i..iui: 2010 2041 2012 1 Metro Payment 10,903,600.00 1 Metro Payment 13,485;385.00 1 Metro Payment 13,485,385.00 . 2 Waste Dump Fees to King County 8,000.00 2 Waste Dump Fees to King County 8,000.00 2 Waste Dump Fees to King County 8,000.00 3 BA# 7- Increase to reflect Metro's rate 288,400.00 Une Items'Cotal 13,493,385.04 Une Items Total 13,493,385.00 fncrease . Une Items Total 11,200,000.00 • Change in Budget 2,293,385.00 Change ln Budget 0.00 535.800.90 [NTERFUND PAYMENTS FOR SERVICES t53580093 . INTERF.,UNDySUPPLIES _._..w_...,..~.~...._.._~:~ ._U__..__..,.....~.,_...._~~..,.__._.._....~,~,_._.~_...,~.~~..,.w:::.~.~ ~ W.~..~.._. ~~,.,..~.Y.,. ' : I .f . ' f t •r .r.. ..uA:.f i..k,.t.i. . ~ul'"'f' . . . .-...a hwL.:ir'.......w...slw~~.~ 2010 ^ 2019 2012 1 Equipment Rental - Fuel 18,400.00 1 Equipment Rental - Fuel 31,000.00 i Equipment Rental- Fuel 32,600.00 . Une Items Total 19,400.00 Une Rems Total 31,000.00 Une ttems Total 32,600.00 • Change fn 8udget 111.600.001 Change in Budget 1,600.00 r 535.800:95 IN7RFUND OR~R"REN7ALSlL`•EASES : ' ` i _ , ' • ---~...._..w_. : u.....,_. . w a_,:.,,~ M : • f . _~....L.~_~ 2010 2017 2072 1 Equipment Rental - VehiGes 118,700.00 1 Equipment Rental - Vehides 194,400.00 1 Equipment Rental - VehiGes 120,100.00 Une Items Tofal 118,700.00 Une ltems Total 114,400.00 Line Items Total 120,100.00 Change in Budget -4,300.00 Change in Budget 5,700.00 Total Line Items 12,984,900.00 Total Line Items 15,550,885.00 Total Une Items 15,563,185.00 Totat Change in Budget 2,565,985.00 ' Total Change in Budget 12,300.00 N cia.._ • Page: 4 gtWksheetObj.rpt Budget Flex Worksheet by Object: Sewer- Other Page: 10 08119/2010 3:59PM . Ctty of Auburn 431 SEWER TiflelObject 2009 Actua/s 2010 Adj. Budget 2010 YTD Actuals 2011 2012 00 CAFR ONIY 01 CONTRA DEPRECIA710N 9,390,660.00- • 1,102,000:00- 805.220:00- 1;378,000.00- 1,378,000.00- 05 NET INGREASE RESTRICTED CASH 437,220.00 0:00 2,240.00 0.00 0.00 06 WORKING CAPITAL 10,7511,020.00 2,746,940:00 11,083,360.00 - 7,144,090.00 5,108,600.00 Total CAFR ONLY 9,797,580,00 1,644,940.00 10,280,380.00 5,766,090.00 3,730,600.00 110 SALARIES.& WAGES 11 REGULAR SALARIES & WAGES 154,590.00 109,700.00 74,900.00 151,500.00 153,600.00 '[ptaJ SALARIES & WAGES 154,500:00 109,700:00 . 74,800.04 151,500:00 153;600.40 20 PERSONNEt BENEFITS 21 F.I.G.A • 11,500:00 41,440.00 ' 5,590.00 . 10,700.00 9,900.00 23 PENSIONS 10,830.00 0.00 3,980.00 7,700.00 7,100.00 24 INDUSTRIAL INSURANCE 2,290.00 0:00 1,100.00 2;300.00 2,100.00 25 MEDICAL & UFE INSURANCE 26,330.00 0.00 15,100.00 32,400.00 34;700.00 TOtal PERSONNEL BENEFITS 50,950.00 41,400:00 25,770.00 53,100.00 53;800.00 40 OTHER SERVICES & CHARGES , 49 MISCELLANEOUS 1,221,820.00 1,210,000.00 . 665,460.00 -1;210;000.00 1,210,000:00 Tptal OTHER SERVICES & CHARGES 1,221,820.00 . 9;210,000.00 665,460.00 1,210,000,00 1,210,000.00 50 IN7ERGOVERNMENTAUINTERFUND , 55 OPERAl'ING TRANSFERS QUT 5D,000.00 58,200.00 58200.00 50;000.00 . 50,000:00 . Total INTERGOVERNMENTALJINTERFUND 50,000.00 ' 58,200.00 58,200.00 50,000.00 50,000.00 60 CAPITAIOUTLAY ~ 63 IMPROVEMENTS OTHER THAIV BUILDING 15,540.00 57,400.00 0.00 30,000.00 0.00 64 MACMINERY & EQUIPMENT 20,480.00 16,000,00 9,150.00 0.00 0.00 65 GONSTRUCTION PROJECTS 3,087,870.00 7,322,200.00 792,310.00 0.00 0.00 Total CAPITAL OUTIAY 3,123,880.00 • 7,395,600.00 801,460A0 30,000.00 . 0.00 70 DEBT SERVICE PRINCIPAL " 72 REVENUE BONDS . 0.00 ' 0.00 0:00 230,000.00 236,300:00 ' 78 1NTERGOVERNMENTAL LOAN 236;790.00 244,000.00 288;260.00 - 288;200.00 288,200:00- " Tptal DEBT SERVICE PRINCIPAL 236,790.00 244,000:00 288;260.00 , 518,200.00 524,500.00. Total SEWER 14,635,530.00 10,703,840.00 12,194,430.00 7,778;890.00 5,722,500.00 . N .A . ~t 10 glwrksheet.rpt Sewer- Other., Page: 1. . 08/19/2010 3:57PM City,of Auburn : Account Number 2009,Actuals 2010 AdJ:Budget 201.0 YTD Acfuals 2011 2012 . 431 SEWER 00 SEWER . , 535 U7ILITIES . " 535:801 DEPWAMORT/INV CONTRA & TAXES . • 535:801.01 CONTRA DEPRECIA7fON 1,390,660.00- 1,102,000.00- 805,220.00- 1,378,000.00- 1,378,000.00- Total . CAFR ONLY 1,390,660.00- 1,102,000.00- 805,220.00- 1,378,000.00- 1,378,000.00- 535.801,49 . MISCELLANEOUS 1,221,820.00 . 1,210,000:00 ` 665,460.00 11210,000.00 1,210,000.00 . 7ot81 OTHER:SERVIGES & GHARGES 1,221;820:00 1;210;000:00 665;460.00 1,210,000.00 1,210,000.00 ; Tptal bEPR1AMORT1INV CONTRA & TAXES 168,840:00- 108,000.00 139,760.00- 168,000.00- 168,000:00- Tatal UTILiTIES 168,840.00. 108,000.00 139,760.00- 168,000.00- 168,000.00- 590 CAPITAL OUTLAY 590.100. CAPITAL EXPEPtDITURES 590.100.05 NET INC. RESTRICTED ASSETS 437,220.00 0.00 2,240.00 0.00 0.00 590.100.06 ENDING WORKING CAPITAL . 10,751,020.00 2,746,940.00 11,083,360.00 7,944,090.00 5,108,600.00 • Total CAFR ONLY 11,188,240.00 2,748,940.00 11,085,600.00 7,144,090.00 5,108,600.00 . 590.100.11 REGULAR SALARIES & WAGES 154,500.00 109,700.00 74,900.00 151,500.00 153,600.00 TOtal SALARIES & WAGES 154,500.00 109,700.00 74,900.00 151,500.00 153,600.00 590.100.21 F.I.C.A. 17,500.00 41,400.00 5,590.00 10,740.00 900.00. 590:100:23 PENS[ONS 10,830.00 0.00 3;980.00 7,700.00 7,100:00 590.100.24 INDUSTRIAL (NSURANCE 2;280.00 0.00 1,100.00 2,300.00 2,100.00 590.100.25 HEALTN INSURANCE 26,330.00 0.00 15,100.00 32,400.60 34,700.00 . ,Totd1 'PERSONNEL BENEFITS 50,950.00 ` 41,400.00 25,770.00 53,100.00 53,800.00 . 590.100.63 IMPR0VEMENTS OTWER THAN BLDG. 15,540.00 57,400.00 0.00 30,000.00 0.00 . N v, Page: 1 glWrkSheet.rpt SeWer-.O.ther Page: 2 08199/2010 3:57PM. City o#Aubum Account Number ' 2009 Actuals. 2010 Adj Budget ' 2010 YTD Actuals 2019 2012 590.100.64 MACHINERY &'EQUIPMENT . 20,480.00 16,000:00 9,150.00 _ 0.00 0.00 590.100.65 GONSTRUCTIOPI PROJECTS 3;085,000.09 7,322,200.00 792,31000 0.00 0.00 Tptal CAPI7AL OUTLAY ` 3,121;020.00 7,395,600:00 801,460.00 30,000.00 0.00 590.100.72 DEB7SERVICE PRINC{PAL REVENUE BC 0.00 0.00 0.00 230,000.00 236;300.00 596.100.78 INTERGOVERNMENTAI. LOAN 236,790.00 244,000.00, 288,260.00 288,200.00 288,200.00 Total DEBT SERVICH' PRINCIPAL 236,790.00 244,000.00 288,260.00 518,200.00 524,500.00 TOtal CAPITAL EXPENDITURES 14,751,500.00 10,537,640.00 12,275,990.00 7,896,890:00 5,840,500.00 590.101 NON-CAPITAL OUTLAY 590.101.65 CONSTRUCTION PROJECTS 2,870.00 0.00 0.00 0.00 0.00 7ota1 CAPITAL OUTLAY 2,870.00 0.00 OAO 0.00 0.00 TOtal NON-CAPITAL OOTIAY 2,870.00 0.00 0.00 0.00 0.00 590.800, CAPITAL OUTLAY - M& 0 ' TOtal CAPITAL OUTLAY 0.00 0.00 0.00 0.00 0,00 Totdl CAPITAL OUTLAY - M& O 0.00 0.00 . 0.00 0.00 0;00 Total . CAPITAL OUTLAY 14,754,370.00 10;537,640.00 12,275;990.00 7,896,890A0 5,840,500.00 597 07HER FINANCING , 597.100 OPERATtNG TRANSFER OUT , . - 597.100.55 OPERATING1F2ANSFER OUT 50,000.00 58;200.00 58.200:00 . 50,000.00 50,000.00 Tota) INTERGOVERNMENTAUINTERFUND 50;000.00 58,200.00 58;200:00 , 50,009.00 50,000.00 Total OPERA7ING 7RANSFER OUT 50,000:00,,,. 58,200.00 58,200.00 50,000:00 50,000.90 " -7otal' ' 07HER FINANCING • ;50,000:00 58,200.00 58,200.00 50,000.00 50,000.00 CO. . Page: 2 glWrkSheet;rpt Sewe1'- vther rage: 3 . 081.1912010 3:57PM City of Auburn . account Number 2009 Actuals 2010 Adj Budget 2010 YTD Actuals 2099 2012 , Total SEWER 14,635,530.00 10,703,840.60 12,194,430.00 7,778,890.00 5,722,500.00 ' Total SEWER . 14,635,530.00 10,703,840.00 12.194,430.00 7;778,890.00 . 5,722,500.00 Grand Total 14,635,530.00 10;703;840.00 12,194,430.00 _ 7,778,890.00 5,722,500.00 ~ . Page: 3 Budget Detail Report Page: 1 0812012010 8:27AM City of Auburn 431 • SEWEit 00 SEWER • 535 UTILITIES . 535.801 DEPR/AMOR7ANV CONTRA & TAXES 535.801 00 CAFR ONLY . . _._....~_.__z:. . 2010 2011 • ~ 2012 1 Original budget -1,102,004.00 1 Depreciation -1,378,000.00 1 Depreciation -1,378,000.00 Line Items Total .1,102,000.00 Line Items 7otal _1,378,000.00 L'ine ttems Total _1,378,000.00 Change in Budget -276,000.00 Change in Budget 0.00 535.801.40 OTHER SERVICES & CHARGES r -r-~- ~ 835:801 49 i ' MISCELI.ANEOUS , i ~ ~..__W r..........~.:.~.~.._W_ - .~,..,.w.~.:.._. • 2010 ' • 2011 2012 1 Taxes 1,210,000.00 1 Taxes 1,210,000.00 1 Taxes 1,210,000.00 Line Items Total 1,210,000.00 Line Items Total 1,210,000.00 Line ItemsTotal 1,210,000.00 Change in Budget 0.00 Change in Budget 0.00 Total Line ltems 108,000.00 Total Line Items -168,000.00- Totd1 Line Items -168,000.00 Total Change in Budget -2767000.00 Total Change in Budget 0.00 N P''Q@: ~ Budget Detail Report Page: 1 08/2712010 8:95AM City of Aubum ' 431 SEWER OU SEWER 590, CAPITAL OU7LAY 590.100 CAPITAL EXPENDITURES 590.100.00 CAFR ONLY 17.7 2010 2011 2012 1 Original budget 1.660,192.00 1 Estimated Ending Working Cap'dal 7,144,092.90 1 Estimated Ending Working Capital 5,108,602.00 2 BA# 4 Adjust W/C 2,784,220.00 . Une ttems Totel 7,144,092.00 Une Items Total 5,108,602.00 3 BA# 5 Adjust W/C 58,300.00 4 BA# 6 Adjust W/C -1,467,388.00 5 BA# 7- Adjust Ending Working Capital -288,400.00 Une items Total 2,746,944.00 Change in Budget 4,397,148.00 Change in Budget 2,035,490.00 590.100.60 CAPiTAL OllTLAY ' __e_ - __-,-....__,.E r . . .-rr -~xT- c T - t' ' . . ' . -i ~ : . . ~ . - I ~ 590100 63 :<]MPROVEMEN S;OTHR:THANBLDG ' _..,.`:~...r_,..._._ .i,,._-.:....,..,.._, ....:;:.:..............:~,.e.~•.:.~.,....-...~~...s...t - , . ..a:.f ~ ..._...~_<:...........,..._-.......:_.~.w..._.. ..:'..:t...v_...:-.'>z , , ~ . 1,....., 2010 2011 2012 1 Sump Pump Replacement ' 5,000.00 1 Amp Meter project completion 20,000.00 2 BA# 5 Carry forvaard 2009 Improvements 52,400.00 2 Green River Sfphon Valve Chamber 10,000.00 Une Items Total 0.00 Line Items Total 57,400.00 Removal Line Items Total 30,000.00 Change in Budget -27,400.0011 Change in Budget -30,OQ0.00 r-._..-. I . .I ~ . . 590 900 64 MACHINERYEQUIPMEN7 ' ` ...~~..`a_s_.. ""..+._...~..._..._....ui~~.....s.....__~...~..........._..L_...:.uwa~~r.:s:::<..r..«w...w:...._.w.s...~.i.:..a...J_...~x.rln~...v..w..a...%~...y✓.-C:.~:~~.`,.:..~wiWla..l...~...~:iv_n.wt_u:~.:....::.....~..w.~...:~._.:~.~~_...~x..~:~__.~....-.u~:.u~~~~! ...u.l.u..... -'.i..~ n i ...I ~ .~W.~.~._.~ 2010 2011 2012 1 BA# 5 Carry forward mini camera & trench 16,000.00 shoring Line Items Totai 16,000,00 Une Items Total 0.00 Line items Total 0.00 Change in Budget -16,000.00 Change in Budget 0.00 ~90100:65 CONSTRUCTION;PROJECTS ' ~ ' ' ' ' ' ; • ' ; ~ ~ , i F _._.~___...~~.~.~:~i.__.~..~...~._~,..._~__:.~._...__.....,___w...._..___.~.._._,......._~:~.._~_._..-.~_.__._..._...~.' .._~..._..._...~;::~::::._._..w._...__,..- 2010 2091 ~2012 l Repairs and Replacements 3,916,300.00 Une Items Total 0.00 2 Improvements 2,180,600.00 Line Items Total 0.00 3 BA# 5 Carry forward 2009 projects 1,249,300.00 4 June Mayor D/C reallocate for Cartegraph & -24,000.00 Hydraulic modeling software . Line Items Total 7,322,200.00 Change in Budget -7,322,200.0011 Change in Budget 0.00 ~90'90.0:66 2010 2011 2042 1 Capital Lease 250,000.00 2 Feb Iviayor D/C move to object 83 -250,000.00 Une Items Total 0.00 Une Items 7ota1 0,00 Line ItemsTotal 0.00 Change in Sudget 0.00 Change in Budget 0.00 590.100.70 DEBT SERVICE PRINCIPAL N f~ Page: 1 Budget Detail Report Page: 2 08127/2010 8:15AM City of Auburn 431 SEWER 00 SEWER 590 CAPITAL OUTLAY 590.100 CAPfI'AL EXPENDI7URES 590.100 70 DEBT SERVICE PRIRfCIPAL 59010 70 2..i;DEB~TS~RVIGEPFZiNCIPAI.7-REVENUE~°BONDS_.. ,~_~..u..~.~.:~......U...,,.,..~.~.._~.......~,,.y..'..:;:., 2010 2011 2012 1 2010 Revenue Bonds 230,000.00 i 2010 Revenue Bond§ 238,300.00 Line Items Total 0.00 Line [tems Total . 230,000.00 Line Items Total 236,300.00 Change in Budget 230,000.00 Change in Budget 6,300.00 , 590:10Q 78 , JNTER60\LERNMENTAL LOAN ' ; ' : ' ' .w.... w~. w w,_w..~ ....~.Y ...w...~,~. . s ~ y ....,_.,_,:ti ..................W..v......,.......,...~..a............. .....,.1y.,........,..,.+.:.,,..,..~,..._ _«,..«,..,.w,.._,......-_... M..a......... . . . _',.Ll.,.... ~......b;,... 2010 2011 2012 1 04691-001 PWTF Loan-AWS Sewer 107,900.00 1 04-691-001 PWTF Loan-AWS Sewer 107,800.00 9 04-691-001 PWTF Loan-AWS Sewer 107,800.00 Replacement Phase I- Principal Replacement Phase I- Pdncipal ReplacemeM Phase I- Pdncipal 2 06-962-003 PWTF Loan AWS Sewer 136,100.00 2 06-962-003 PWTF Loan-AWS Sewer 180,400.00 2 06-862-003 PWTF Loan-AWS Sewer 180,400.00 Repfacement Phase II - Pdncipal Replacement Phase II - Pdncipal Replacement Phase il - Pdncipal Line items Total 244,000.00 ' Line Items Total 288,200.00 Line Items 7oWl 288,200.00 Change in Budget 44,200.00 Change in Budget 0.00 W O ^~C~@: 2 Budget Detail Report . Page: 3 0812712090 8:15AM Gity of Auburn 431 SEWER ' 00 SEWEFi 597 07HEI2 FINANCING 597.100 OPERATING TRANSFER OUT • 597.100.50 I NTERGOVERNMENTAUINTERFUND 597~100:55 OPERAiiNG TRANSFER:OUT Ai: ...,........,_..-_...-..._....,,.._C»...>..-.,-....,._..........c..,__............ .,.w.,............_.....-....... , . ,....V.~.J...t.,.~...-i.._ ...,......,.,u..,..,.4e:.~.,...~.w.,.c.v ...r...-..~.:-........+4-.5.:,u..........-..,w..u,1..M. _.L,..:.i...y«w.......i.4......c~....,....~.+.+.....wuwww...~,..:....a 2010 2041 2012 1 Transfers out !o Fund 103 for Utility 7rench 50,000.00 1 Transfers out to Fund 103 for Utility Trench 50,000.00 1 Transfers out to Fund 103 for Utility Trench 50,000.00 Mitigation Mitigation Mitigation 2 BA# 5 T/O for unemptoyment costs 8,200,00 Line Items Total 50,000.00 Line Items Total 50,000.00 Line Items Totai 58,200.00 Change in Budget -8,200.00 Change in Budget 0.00 Total Lineitems 10,444,744.00 ~ Total Line ltems 7,742,292.00 Total Line Items 5,683,102.00 Tota[ Change in Budget -2,702,452.00 Total Change in Budget -2,059,190.00 W ' ~l Page: 3 ; TABLE S-2 . CAPITAL FACILITIES PLAN PROJECTS ANQ FWANCtNG SEWER FUND . 2011 , 2012 2013 2014 - 2076 ~ 2018 7otal Capacitv Profects: None Non-Canacttv Prolects: i 1 San{tary Sewer Repalr & Replacement Cap'stal Casts 1,320,100 590,160 1,890,900 2,724,300' 1,480,000 1,680,000 , 5,885,400 ' Funding Sources: • Sewer Fund 1,328,100 590,100 1,890,900 2,724,300 1,480.000 1,680,000 9,686,400 Bond Proceeds - - - - - - - 2 StreetUtility lmprovements Capital Costs 115,040 115,000 115,000 115,000 115,000, 115,000 690,000 . Funding 5ources: SewerFund 115,000 115,000 ~ 195,000 115,000 . 115,000. 915,000. 690,000 Bond Proceeds - - - - - ~ ' 3 Power Generators ' Capital Casfs 318,300 327,800 337,700 - - - 94800 Funding Sources: ' ' Sewer Fund 318,300 327,840 337,700 - - 983,800 - Bond Froceeds _ _ _ 4 Lea Hili Pymp Station Decommissioning Capita! Costs 469,700 - - - - - 469,700. " •Funding Sources: . Sewer Fund 469,700 - _ _ _ , _ - 469,700 Bond Proceeds - - - - - - . 5 SCADA (Tetemetry) UP9rades • , , Capital Casts 842,000 100,000 942,000 " Funding Sources: Sewer Fund 26,400 100,000 - - - - 126.400 Bonc{ Proceeds 815,600 - - - - - 815,600 6 Eliingson Pump Staiion Repfacement Capitsl Costs 2,798,400 - - - - - ` 2,798,400 ` Funding Sources: SewerFund - - - - . - ' - Bond Prooeeds 2,798.400 - - - - - 2,798;400 7 Vactor DecantFac[lity Capital Costs 280,000 - - - - 260,000 Funding Sources: , Sewer Furid 250,000 - - - - - 260,000. Bond Proceeds - - - - - - 8 Maintenance and Operatlons Facflity Expansion . Capitai Costs - - 300,000 300,000 Funding Sources: : Sewer Fund - - 300,000 - ` - . 300,000 Bond Proceeds - - - - - - ' 32 SUMMARY: 2011 2612 2013 2014 2015 2016 Total CAPITAL C03TS • Capadty Projeds ' - - - - - - - Non-CapadtyProJects 6,113,500 1,132,90D 2,643,600 2,839,300 1,595,000 1,795,000 16,119,300 Total Cosb 6,113,500 1,132,900 2,543,600 2,839,300 7,596,000 1,785,000 16,119,300 FUNDINC3 SOURCES: Utiiity Funds (Sewer) 2,499,500 1,132,900 2,643,600 2,839,300 1,595,000 1,795,000 12,505,300 Bond Proceeds 3,614,000 - - - - - 3,614,000 Other - - - - - - - Total Funding 6,713,500 1,132,900 2,643,600 2,839,300 1,596,000 1,795,000 46,919,300 . ~ 33 SEWER FUND (431) capital Faciiities.Ptan Slx Year Capltal FaelilUes Plan, 2011-2016 . _ Enterprlse Funds ProtectTiUe: Sanitary Sewer Repair & ReplacementlSystem Improvements - Project {do: cpxxxx ProjectType: Non-Capacity (Repalr and Replacement) ' Project Manager: Elwel! Description• Repair and repiaoe broken sawer mains and other faafities. These tines wifl be Identified through televisEon inspedion and - routfrte cteanfng. _ This particular program indudes proposed projects which do nofhave an approved Projeet Management Plan, or are not associated with the SOS or other transporta6on improvemerds. Anticipafed projects indude, bi-annual, stand- alone, repafr and replaoement projects for sewer fnes which are broken, misaligned, "bellied" ar otherwise requir.e an inordinafe amount of maintenance effort or present a risk of backup or trench failure. _ Additionatly, system €mpravements which enhance the abiEity to maintain service are included here. ' Progress Summary: . , Projecfed projects Inolude: 1. Pump Station wef well rehabilitation 4: Manhole frame and cover replacement 2. Sth Street Pump Staiion replacement 5: Easement aooess improvements 3. 2011-12 Repair and Rep4acementProJect 6. Force main access improvemeMs Future Impact on Operatfng Budget: • This should decrease the operaUng budget by correcting the problems that reguire aperations attention. BUdget: , 2010 YTD Actuel 2011 10 Budget Budget Expenditures ' Budget Balance Adopted Budget - - - • Budget Amendmenis - - . Ad%usted Budget - - - - Activity: (Prevlous 2 Yrs) 2070 YE 2011,Year Ead Funding Sources: Prtor to 2010 Estimate 2071 Bud et 2012 Bud et Pro eetTotel Unrestricfed SewerRevenue 7,483,600 885,100 1,320,100 590,100 3,698,800 , Grants (Fed,State,Loca!} - ' " ' - Bond Proceetls - - - - - Ofher - Tolal Funding Sources: 1,483,600 885,100 1,320,100 590,100 3,698,800 Capital Expenditurea: Design 314,000 120,100 198,015 88,500 632,715 Right of W8y - - - - Construcfion 1,179,600 765,000 1,122 085 501,600 3,066 685 Totat Expenditures: 1,483,600 865,100 1,320,100 590,400 3,698,800 Forecasted Project Cost: Total 2013 2014 2096 2016 • 2011•2016 Funding Sources: Unrestricted Sewer ReVenue 1,890,900 2,724,300 1,480,000 9,880,000 9,685,400 Gran[s (Fed,State,Loceq - - - - - Bond Proceeds - - - - - Other • Tota) Funding Sources: 1,890,900 2,724,300 1,480,000 11680,000 9,685,400 Capital Expenditures: . Dasign 283,600 408,600 222,000 252,000 1,452,715 RtghtolWay - - - - - Construclion 1,607.300 2,315,700 1,258,000 1,428.000 8 232,685 7otal ExpendiWres: 1,890,900 2,724,300 7,480,000 1,680,000 , 9,685,400 Grants / Olher Sources: ~ 34 SEWER FUND (439) capital Factiities P1an Six Year Cap[tal Facilities Plan, 2011-2046 Enterpr[se Funds Project Tifle: Street Utility lmprovements Project No: cpxxxc Project Type: Non Capacity , Project Manager: TBD Qescrlption: Sewer ltne replacement !n coordination with SOS and Arterial improvements. - Progress Summary: Ongoing ' Future Impact on Operating Budget: No significant Impact Budget: 2010 YTfl Aetua! 2011 10 Budget Budget Expendltures Budget Baiance Adopted Budget - _ - ' ' Budgat Amendments ' AdJusted 8udget - • - ' ACtiV[ty: . 2010 yE 2011 Year End Funding Sources: Prior to 2010 Estimate 2011 Bud ot 2012 Budget Pro ect Total UnresfrictedSewerRevenue - 200,000 115,000 115,000 315,000 Grants (Fed,State,Lxeo - - ' " - 6ond Proceeds - . - - ' - Olher " Total Fundtng Sources: - 200,000 915,000 115,000 315,000 Capital Expend[tures: Des/gn - 30,000 15,000 15,000 45,000 Rfghtof►Nay - - - ' - Construcfion 170,000 100,000 100,006 270,000 Total Expendttures: - 200,000 115,000 115,006 315,040 Forecasted Project Gost: Total 2013 2014 2015 2016 2011-2016 Funding Sources: Uniestdcfed SewetRevenue 115,000 115,000 115,000 115,000 690,000 Grents (Fed,Stafe,tocaf} - - - ' " Bond Proceads - - - ' ' Other ' Total Funding Souress: 115,000 115,000 115,400 115,006 680,000 Capital Expendttures: Design 15,000 15,000 15,000 15,000 90,000 " Rfghl of Way - ~ - ' - • • Conshuclion 100 000 100 000 900 000 100,000 600,000 Total Expenditures: 775,000 115,000 115,000 116,000 690,000 Grants / Other Sources: 35 SEWER FUND (431) . capitai Faciiifies Qian - Six Yea"r Capifat Faclltties Plan, 2011-2016 Enterprfse Funds • Project TiUe: Power Generators' Project No: cpxxxx Project Type: Non-Capacity Project Manager. TBD Descriptlon: The purpose of this program_is to systematically instafl backqp power for all af Aubum's sewer pump station. Insta[lation at individual statians may be separaie projects, may be in conjunction with other upgrades to fhe pump station, or may be included with another City project. Project to be initiated in 2010 indudes permanent generators at RiVerside, 22nd Straat, and `D' StreeF Pump Statiorss. Progress Sum►nary: i . , The 2009/10 installation of backup power has,included the instafiation of a permanent generator at the "F" Street pump, sfation, ihe temporary installation of a mobile generator and security fencing at the Riverside pump sfation, and the design for . generators to beinstalled as part of the E11ingSon and Dogwood Pump Station reptacement proJects. Future Impact on Operating Budget: Budget: 2010 YTD ActuaR 2071 10 Budget • ' ' ' Budget Expendifures Budget Balance_ Adopfed Budget - - ~ Budget Ar+iendmerits - - - AdJusteaf Budget Ac#ivity: - - 2810 YE 2011 Year End FundingSouroes: Prior to20'!0 Estimate 2011 Bud Budget 20126ud Budget _ProectTotai UnrestrictedSetiverRevenue - 309,000 318,300 327,800 627,300 Granls (FeO,Stete,tocal) Bond Proceeds - - - - - Other - Total Furtding 5ources: - 309,000 318,300 327,800 , 627.300 Capital Expenditures: • Desfgn - 50,000 50,000 50,000 • 100.000 Right of Way - 50,000 50,000 50,OQ0 150,000 Conshudlon 209,000 218,300 227,800 427 3U0 Total Expenditdres: - 309,000 318,300 327,800 827,300 Forecasted ProJect Cast: . ' • Total . . 2013 2014 2016 2016 2011•2016 Funding Sources:. UnrestrictedSetiverRevenue 337,700 - - - 983,800 , _ Grants (FedState.Loca!} - - - - - 8ond Proceeds - - - - - ` Other • Total Funding Sources: 337,700 • - - 983,800 ' Capttai Expenditures: Design' 50,400 - - 184,000 Right of Way 501000 - 150,000 40 Consfnrctlon 237,700 683,8 7otal Expendltures: 337,700 - • • 983,800 • Grants / Other Sources: 38 SEWER FUND (431) Capltai Facilities Plan Six Year Capftal Fac[littes Plan, 2011-2416 Enterprise Funds Protect7itle: Lea Hill Pump Station Decommissioning Project No: cp0756 Project Type: Non-Capacity (Improvements) Praject Manager: Sweeting Description: This project aitows two existing City wastewater pump stations (Rainier Shadows and White Mountain Trails) to be decommissioned. Phase 1(CP0724) is compiete and extended gravity sewer lines from the existing pump stations towards the Verdana Pump Station. Phase 2(CP0756) will complete the cannections to fhe Verdana Pump Station and decommission the Rainier Shadows and White Mountain 7rails pump stations. The Verdana Pump Station has been designed to pu►np sewage from the two existing stations as welf as the new Verdana (aka "Bridges") development. rogress Summary: While the Verdana Pump Station is substantially complete, the entire project is on hold, and the station has not been turned over to the City. This sheet reflects carrying over all of ttte designated funds from 2010 to 2011. Future Impact on Operating Budget: No significant impact. While two stations are to be rernovad, a larger station will require maintenance and operations attention. Budget: 2010 YTO Actual 2011 70 Budget Budget ExpendTtures Budget Balance Adopfed 8udget - - - - Budget Amendments - - ' Adjusted 8udget - - - - Activtty: 2010 YE 2011 Year End Funding Sources: Prior to 2010 Estlmate 2011 Budget 2812 Bud et Pro ect Total Unrestricted SewerRevenue 892,200 - 469,700 - 1,361,800 Granfs (Fed,State,LoCaf) - - - - ' 8ond Proceeds - - Total Funding Sources: 692,200 - 469,700 - 1,361,900 Capital Expenditures: Desfgn 61,200 - - - 61,200 Right of Way - - - - ' ' Construction 830,400 469,700 - 1 300.100 Total Expenditures: 891,600 - 469,700 - 1,361,300 Forecasted Project Cost: Total 2013 2014 2016 2016 2011-2016 Funding Sources: Unresbicted SewerRevenue - - - - 469,700 Grants (Fea;State,tocaq - - - - ' Bond Proceeds - - ' Total Funding Sources: - - - - 469,700 Capital Expenditures: Desfgn - - - - - Right of Way - 469,700 Co»structlon - - - Total Expenditures: 469,700 Grants / Other Sources: 37 ~ SEUUER FUND (431) . caPitat Fadiitdas pian Six Year Capital FaciflHes Plan, 2011-2096 Enterprise.Funds Project Ti#le: SCADA Upgrades , Project No: c524a0 Project7ype: Non-Capacity (improvements) Project Manager: Lee , Desaription: _ TheBupervisory Contral and Data Acquisition (SCADA aEso known as the'Telemefry" system) is in need af upgradfng, 7he existtng system, based on an independ.ent SCADA Assessmen# Studyand the vulnerabiliiy study, has numerous obsolefe companents and does not allow oontrot of the Sewer and Starm U6[ity sta6ons.. The nsw system will util'rze an open . architecture so the Cify is no longer reliant on one vendor for repairs and maintenance. . ~ ' Progress Summary: The design poition of the desfgNbuild began in 2010, wlth significani construction expected also in 2010. The remainder of ' the construction is planned for2011. Future Impact on Operatfng,Budget: No significant impact. Budget: 2010 YTD Actual 2011 10 Budget Budget Expenditures Budget Balance - Adopted Budget - , - - - Budget Amendments - - - - Adjusted Budget Activ[ty: . , . 2010 YE . 2011 Year End FandingSources: Prlarto2010 EstTmate 2011Bud et 2012Bud Budget ProJectTOWI Unrestricted SewerRevenua 133,200 537,100 28,408 100,040 896,700 Granfs (Fec/,State,ixal} - - - • - 8ond Proceeds - - 815,600, - 615,600 . Olher Tota1 Funding Sources: ' 133,200 637,100 842,000 100,000 1,572,300 Capita[ Expenditures: , DBSign 133,200 298,070 - - 431,270 - Right of Way - - - Constnrction - 239,030 842,000 100,000 1,081,030 ' Totaf Expenditures: 133,200 537,100 842,006 180,000 1,612,300 Forecasted Project Cost: Totai 2013 2014 2846 2018 2011-2018 Funding Sources: , Unreshicted 5ewer Revenua - - - - 126,400 Grants (Fed,State,Locai) - - - - - • 8ond Proceeds - - - 815,600 Other - - - - - Total Funding 5ources: - - - ' - 942,000' Gapftal Expenditures: • - Desfgn - - - - Rrght of Way - - - - - ' Constructlon - 942,000 Totai Expenditures: - - - - 942,000 Grants / Other Sources: ' 38 SEWER FUND (431) capttai Facnittes Pian . „ ` SixYe.arCapltal Factlitles Plan, 2019-2076 Enterprlse;Funds ` ProjectTitfe: Eilingson & Dogwood Pump Sta#ton Replacements Project No; cpfl817 - Project 7ype: Rlon Capacity Project Manager. Sweeting . Description: Projecf to replace fhe Ellingson and Dogwood Pump Stations. - Progress Summary: . . The constructian con#ract for pogwood has been awarded and construciion wilf begin in 2010'and end fn 2071. The , Ellingson. station is currently at the 90% stage, wil{ be bid in the fa11 of 2010 and constructed in 2011. Future Impact on Dperating Budget: The project shauld decrease rttaintenance casts compared to ihe existing pump stations.' Budget: aoto . - YTD Actual 2011 10 8udget. Budget Expenditares Budget Balance Adopted Budget ' - - - = BudgelAmendmants - - Adjusted Budget - - - - Activity: 2010 YE 2017 Year End - Fundfng Sources: Prlor to 2040 Estimate . 2011 Bud et 2012 Bud et Pro ect Totat UnrestrictedSewerRevenue 521,600 " - 524,600 Granfs (Fed,State,LocaQ - - - - Bond Proceeds - 1,386,000 2,788,400 - • 4,184,400 ' Olher Total FundTng Sources: 521,600 7,386,000 2,798;400 - 4,706,000 ' Capital Expenditures: Design 521,600 503,500 1.025;100 RighfofWay - 50,000 - - 50,080 Constiuction • 832,500 . 2.798,400 3,630,900 Total Expenditures: 521,600 7,386,000 2,796,400 - 4,706,000. Forecasted ProJect Cost: Totat 2013 2014 2015 2016 2011-2016 Fvnding Sources: Unrestricted SewarRevenue - - - - Grents (Fed,State,tocal) - - - - • - Bond Proceeds - - - 2,798,400 Other Total Funding Sources: - - - - 2,798,460 Capita! Expenditures: Dasign - - - - - Rrght o1 Way - - - - - ConsUvction 2 798 400 Total Expenditures: - - - - 2,798,400 Grants ! Other Sources: 39 SEWER fUND (431) . . ' " Capita) FaciiFttes Ptan . . . SlxYear Capitai Pacilittes Plan, 20994096 Enterprlse Funds . , ProjectTitle: Vactor Decant Faciftty , Project No: cpxxxx Project Type: Non-Capacity (Improvements) Project Manager. TBD DesCription: Funds allocated to construct a decant facitity for sewer vacfor waste. Progress Summary:: i . ' . ~ Initiatian Stage i Puture lmpact on bperating 8udget: $Udget: 2010 YTDActual 2011 10 Budget ~ Budget Expenditures . Budget Batance__ Adopted Budget . Budget Amendments ' - - - - Adjusted Budget. QCf1Y(hl: - 2010 YE 2011 Year End Fanding 8ources: Prtor to 2010 Estimate 2019 Bud et 2012 Bud et : Pro ect Total Unrestricfed SewerRevenbe - - 250,000 - - 250,000 Grants (Fed,State,Localj - - - - - Bond ProceeCs - - - - . Ofher Total.Funding Sources: - 250,000 - 250,000 Capital Expenditures: Design - - 50,000 - 50,000 Right of Way - - - - - • CanstrucGon 200,000 200,000 Totaf Expenditurss: - - 250,000 - 250,000 Forecasted Project Cost: 7ota1 2013 2014 2015 2016 2011`-2018 . Funding Sources: Unresthcted Sewer Revenue - - - - 250,000 Grdnts (Fed,State,LocatJ - Bond Proceeds - - - - fliher 7otal Funding Sources: - - - 250,000 Capital Expendifures: , Deslgn 50,000 Right. of Wey - - - - - Coostrucfion 200,000 , Total Expenditures: • - _ - - 250,000 , Gtanis7 0lher Sources 40 SEWER FUND (431) capital Facilittes Qlan 31x Year Capita.l Facilities Plan, 20114016 Entetprtse Funds _ ProjectTltle: . Maintenance and Operattons Facility Expansion Project No: Cpxxxx Projed Type: Non-Capacity,(Irriprovements) Project Manager. TBD Description: . Funds allocated to expand the existing M&O building into a more functional and maintainabte facafity. ; Progress Summary: . ! Inibation Stage . Future.lmpact on Operating Budget: SUd$et: ' 2010 YTD Actuat 2011 10 Budget Budget Expenditures 8udgeE Balance Adopled Budget , - - . Budge! Amendments AdJusfed Budgel - - - - Activity: . 2010 YE 2011 Year End Fund3ng Sources: Priorto 2090 Estlmate 2011 Budget 2012 Budget Projeet Tofal Unresfdcted Sewer Revenue Grents (Fed,Siale,Loca!} - - - - - Sond Pioceeds - - - - - Ofher Tota1 Funding Sources: Capitat Expenditures: Desf9n Rlght of INaY - - • - - _ Conslruction Total Expendltures: Foreca'sted Project Cost: , . Total 2013 2014. 2095 2016 2011-2016. Funding 3ources: Unres(Acled Sewer Revenue 300,000 - - - 300,000 Gre»fs (Fed,Slete,Locaq - - - - Bond Proceeds - - - - - Ofder . Total Funding Sources: 308,060 - - - 300,000 Capital Expenditures: Design 100,000 100,000 Right of Way - - - - - Conatrucflon 200,000 200,000 Total Expanditures: 300,000 - - - 300,800 Grants / Other SourGes: 41