The URL can be used to link to this page

06. Public WorksPage No. Fund No. 1 1000 Public Works Administration , 5 8 3 1000 Central Garage 544,4 400 Light Maintenance 387,536 8 2420 Gas Tax + ! 2, 11 2500 Special Street Maintenance 2,3 5,311 18 2825 MAGI Grant -sweepers 74' 3 19 4290 Sidewalk & Curb Construction 251000 20 435 SID 345 The Willows 39,55 1 5210 Water Fund ,84958 31 5310 Sewer Operating/Wastewater Treatment 8,1 562 1 5349 Stop Sewer 510 , '75 46 5510 Solid Waste 890,627 Total Public Works 1 �031,3 PLTBL.IC WORKS - ADIiVIS1'RATION FUND: GENERAL 1000-110-430100 Personal Services Materials &. Services EXPENDITURE SUMMARY ACTUATE BUDGET ACTUAL BUDGET FY10/11 FY11/12 1FY11/12 FY12/13 22,43 $24P313 $23,004 $22,33 $2,636 $4,125 $5, 27 $ ,225 2570 2 $28,438 $2 ,031 $29,058 i PROGRAM DESCRIPTION The responsibility of the Public Works Administration/Engineering Department is the design, construction, maintenance, and administration of the ity's infrastructure. These areas include streets, curbs, sidewalks, traffic signals, signage, water production and distribution, storm water drainage, sewage collection, wastewater treatment, and equipment maintenance. Y 2013 BUDGE`` HIGHLIGHTS Line Item Detail: PUBLIC 'WORKS 10 Office Supplies, Equip., and Other Supplies Increased line item for 1 additional file for record engineering drawings. Y 2012 ACCOMPLISHMENTS Provided administrative and support services for management of WateT, Sewer Collection, Storm Drainage, Wastewater Treatment, Solid Waste enterprise funds, Street Maintenance, equipment maintenance and supporting administrative and engineering assistance to all other General Fund departments of the City. * Developed a Street Maintenance Management program to establish budget and actual cost of street operations to support decision making and reduce casts. Provided administrative support to the Solid Waste Division with the legislative changes to the solid waste garbage service law which allowed the City to serve garbage customers without the petition process. "rained 42 city employees as part of the Pollution Prevention Good Housekeeping Progr2€m. for Municipal Activities and Facilities. • Contributed to the drafting, writing, and collection of information for Public Works for the it 's new website. * Prepared and submitted a completed grant application to the Montana Department of Emergency Services for the installation of two (2) back-up power supply generators for the crater production division. Continue to monitor the SfA bonds, and warranty and maintenance bands to ensure compliance, - Collaborated in the development and implementation of the 2012 Montana Stormwater Conference. Gage a presentation at the MAGIP 2012 Intermountain GIS Conference on the ity' P / 1S word.. I �u-BLic WORKS - ADMINISTRATION FUND: GENERAL 1000-410-430100 Personal Services: l 10 Salaries and payroll costs 112 Severance 153 Health Insurance 155 Retirement. Total Personal Services Materials & Services: 10 0 #fi ce SuppIies, equip, and other supplies 345 Telephone & Communications 354 Contract Services (temp) 373 loxes & Training Subtotal EXPENDITURE I)E'I'AIL ACTUAL BUDGET ACTUAL BUDGET FY10/11 FY11/12 FY11/12 FY12/13 0.25 0.25 0.25 0.25 $16,656 $17,430 $16,634 $17,740 $1,32 $,000 $1,90 0 $2,858 $3,755 $3,123 $3,45 $1,090 $1,1128 $1,266 $1,248 $22,436 $24,313 $23,004 $22, 33 $2,06 $2,025 S2, 194 $4,025 $7 200 $285 $200 1 $750 $1,755 0 $267 $1,150 $794 $1,150 $2,636 $4,15 $5,027 $,225 TOTAL $25,072 $28,438 $2,031 $29,05 2 PUBLIC WORKS -CENTRAL FUND: GENERAL 1000-414-431330 EXPENDITURE SUMMARY ACTUAL BUDGET ACTUAL BUDGET FY10/I1 FY11/I2 FY11/12 FY12/3 Personal Services $197,91 Maintenance & Operations $9,19 Capital Outlay $192,947 $1,99 $19743 $340,900 $33,71 $349,703 $5 7,0 9 $.53 , 47 $519, 0 $544594 PROGRAM DESCRIPTION The Central Garage is responsible for maintaining all city vehicles and equipment in a safe and dependable condition at the lowest cast per mile, or hour, with the least inconvenience to each department. An extensive record keeping system for repairs and maintenance is maintained, and recommendations are provided to insure the City is receiving cost effective use of vehicles and equipment. FY 2013 BUDGET HIGHLIGHTS Line Item Detail: CENTRAL GARAGE 9 Equipment (iron Capital), Safety Equip., Other Supplies - S19,603 Increased $4,053 for Truck Fire Service ,lacks. Current air jack has been rebuilt by€ce and still loses air and creeps down, frame on the otherjack is beat. $1,000 for a lathe milling drilling machine combo- 362 Equipment M int. Radios, Building Maintenance - $2,550 Increase to fix leaking roof on the Central Garage building. 2013 BUDGET CONSTRAINTS - UNFUNDED Capital Outlay: Building Remodel - $20,000 UNFUNDED Remodel restroom and current office/storage area into a two floor facility, utilizing the same square footage of area for a parts zoom with sufficient shelving which allows for better control and organization of parts inventory. This is a high priority item, the current restroom facility is unsuitable for use and the storage area is inadequate. FY 2012ACCOMPLISHMENTS Provided passenger vehicle and equipment repair- and maintenance services for 273 equipment items for emergency services, park rnaint., street maint., water, sewer, wastewater treatment, and construction, in 14 City General Fund Departments and Enterprise Fund Operating Divisions, a total of 755 repair orders. * Evaluated shop operations and implemented several improvements including: cleaned up and reorganized inventory area, purchased bolt bins, setup weekly scheduling board, improved lighting (rebate program), installed oil dispensing reels, and set up a hose fabricating area. • Implemented a Fleet Management Program and purchased a fleet diagnostic scanner enabling us to diagnose repairs in-house resulting in significant cost savings to the City. The scanner is also able to clear computer and electronic faults that previously had to he contracted out- 3 'PUBLIC WORKS -CENTRAL GARAGE FUND: GENERAL I000-410-431330 EXPENDITURE AETAII, Personal Services; F'' 110 Salaries and payroll costs amended 112 Severance 121 Overtime 153 Health Insurance 155 Retirement Total Personal Services Maintenance & Operations; 210 Office supplies, computer supplies 229 Equipment (Non Capital);safety equip, other supplies 231 Gas and Oil 32 Motor Vehicle Farts 233 Tires 238 Filters 241 Consumable Tools, Books 341 Electricity 344 Natural Gas 354 Contract Services -Repairs 362 Equipment t aint., Radios, Building 11 aint. 73 Dues & Training 388 Medical Services Fatal 1& TOTAL BUDGET ACTUAL FY10/11 BUDGET FYI 1/12 ACTUAL FY1I/12 BUDGET FY12/13 $153,77 $150,25 $147,496 $152,379 $5,379 $0 $0 $0 $25072 $1,700 $1,143 $2,000 $26,662 31,170 $29,110 $31,516 $9,991 $9,252 $9,240 $9,341 $197, 91 $192,947 $1 8 6,99 $195,243 $1,043 $3,300 $3,260 $1,200 $6,988 $6,50 $6,702 $10,603 $146,74 $153,500 $15,7 73 $156,500 $91,461 $92,000 $ 6,300 $93,000 $35,494 $30,600 $35,955 $3,07 $6,053 $6,200 $6,444 $6,70 $279 $2,0 $2,523 $17500 $17616 $1,700 $17617 $11700 $7,1156 $7,00 $6,160 $7,400 $30,1 9 $3 ,900 $27,335 $35,000 $1,740 $1,450 $15432 $2,50 $10 $900 $991 $1,200 $12 $350 $379 $275 $329,198 $340,900 $332,71 $349,703 $527,089 $ 33, 47 $519,860 $544,946 4 LIGHT MAINTENANCE FUND: 2400-410-430253 PROJECTED REVENUE AND FUND SUMMARY BEGINNING CASH 10100 CASH - REVENUES 363 010 Maintenance Assessments 363040 Penalty Interest 364030 Misc. 381050 Inception of Loan 71010 Interest Eamings TOTAL AVAILABLE EXPENDITURES Street Lighting ENDING CASH 10100 CASH: ACTUAL BUDGET ACTUAL BUDGET FY10/11 1FY11/12 FY11/12 1FY12/13 $139, 65 $150, 29 $150, 29 $160,503 $230,848 $2,03 $3,440 $0 $1,366 $230,000 $1,500 $0 0 $1,200 $233,535 $1,665 $1,000 $0 $1,342 $236,000 $1,500 $0 $115,000 $1,200 $237,727 $232,700 $237, 42 $353, 700 $377,592 $3 3,5 9 $388,371 $514,203 $26,73 $262,722 $227,868 $37,536 $150,29 $120,07 $160,0 $126,66? 5 Materials and Services Capital Outlay $181,130 $212,578 $181,666 $208,838 Debt Service 0 $0 $ $1 ,71 $2261763 $262,722 $227,868 $3 7,536 PROGRAM DESCRIPTION The Street Lighting District is provided to improve visibility during darkness and to promote safe and efficient use of street facilities. This is accomplished by reducing pedestrian accidents at night, by reducing vandalism, and by reducing other crimes. Budget provides for maintenance and payment of electricity for City street lights, FY 2013 BUDGET HIGHLIGHTS Line Item detail: LIGHT MAINTENANCE Capital Outlay: (Financed 5 yr) 0 Machinery & Equipment - $115,000 Replacing 1.8 yr old boom truck. Cuffent boom truck is not able to reach all of the ity's luminary lights. New boon height will enable crew to reach all of the City owned lights. FY 2012BUDGET ACCOMPLISHMENTS * 1 eball steel over head luminaries on Center St. to meet dark sky ordinance. R LIGHT MAINTENANCE FUND: 2400-410-430263 PersonalServices; 110 Salaries 112 Salaries - Severance 153 Health insurance 155 Retirement Total Personal Services Materials and Services: 244 Lighting Supplies 341 Electricity 360 Repair & Mai t Services 510 Insurance 522 Administrative Transfer Total M &. Capital Outlay 940 Boom Truck Total Capital Outlay Debt Service: load repairmen Principal -5 year -final p mt 2018 Interest -1.25% Total Debt Total EXPENDITURE DETAIL ACTUAL FYI/11 BUDGET I'Y11/I2 ACTUAL FYII/12 BUDGET FY12/13 rE 0.80 0.75 0.75 0.7 $33,512 $381477 $3 ,678 $38,893 $1,836 $0 $0 $0 $8,140 $9,295 $7,198 $,69 $2,145 $27372 $2,327 $2,391 $45,633 $50,144 $46,203 $50,980 $17,756 $13,000 $14,575 WOO $1 49,746 $163,000 $151,064 $163,000 $5,3 8,000 $7,552 $20,000 $975 $975 $872 $1,07 7,121 $77603 $7,603 $8,73 $181,130 $212,578 $1 81,666 $208,838 o so $0 $115,000 0 $ $0 $115,000 $0 $0 $0 $12,000 0 $0 $0 $718 $0 $0 $ 0 $1, 718 $226,763 $262,722 $227,868 $387,536 7 GXAS TAX FUND: 2420-421-43 024ti PROJECTED REVENUE AND FUND SUMMARY BEGINNING CASH 10100 CASH REVENUE 335040 Gras Tax Apportionment 371010 Interest Total Revenue TOTAL AVAILABLE EXPENDITURES trect Department GASH ACTUAL BUDGET ACTUAL BUDGET FY10/11 FY21/12 FYII/12 FY12/13 310,011 $344,885 $344,885 $464,352 66,04 57150 $366,904 $4,000 $361,157 $4,7034,000 $366,904 372,054 $370,904 $365,860 $370,904 6,05 $715,789 S710,745 $835,1256 337,1 S0 $602,682 $246,393 $732,855 34405 $113,107 $464,352 1 2,4 1 Section 15-70-1 1 MCA requires the State to allocate gas tax revenues to cities, towns and counties. One-half of the city's allocation is based on population and one-half on street and alley mileage. The funds may be used for construction, reconstruction, maintenance and repair of streets, right of ways and alleys. The funds cannot be spent for equipment purchases. 8 ACTUAL BUDGET ACTUAL BUDGET FYI0/11 FY11/12 FY11/12 FY12/13 Materials and Services $273,739 $522,1682 $174,099 $641,555 Capital Outlay 3,442 $90,000 $72,293 $91,300 337,180 $602,682 $246,393 $732,855 PROGRAM DESCRIPTION Funds received from Gas 'fax will be used to support the street and alley maintenance/construction program, This program is accomplished by prioritizing construction and maintenance projects through the use of the pavement manaaernent information system. tp Y 2013 BUDGET HIGHLIGHTS Line Item Detail: 354 Contract Services/Striping City Streets T $300,400 Carryover $200,400 / New Appropriation $100,000 368 Overlay & Chipseals - $201,455 - Carryover Over $101,455 - New Appropriation $100,000 956 Sidewalk Replacement - Carryover $1,500 - New Appropriation S35,000 3 ,500 - To be used for a snatching program to assist homeowners with replacing bad sidewalks. 57 Alley Paving - Carryover $9,800 - New Appropriation S45,000 Pave approximately 10-12 alleys a year and overlay existing alleys with remaining funds. FY 2 BUDGET ACCOMPLISHMENTS • 50150 Sidewalk Replacement program - A total of 18 residents participated in the program, replacing 5.2 blocks. • Paved 10 alleys. 2011 Chipseal Project - Chip Sealed 93 blocks M G"AS TAX FUND: 242 Q-42 I -43 0240 EXPEIVDITiJRE DETAII. 430240 materials and Services -Streets 231 bras & Oil 344 Natural Gas 354 Contract Services -striping 360 Contract Services/Snow remove Constr. Support 368 Overlays & Chipseals 69 Radio Maintenance 452 Gravel 453 Materials -Contract Preparation 471 1 c-lcer/Komi Oil 472 Asphalt 473 Crack Sealing Material Total Materials & Services Streets 430234 Sidewalks l Alleys: 956 Sidewalk Construction 97 Alley Paging Total Capital Total ACTUAL BUDGET ACTUAL BUDGET FYI 0/1 FY11/I2 FY11/12 FY12/13 $37,220 $35,000 S33P389 $3,000 $2,962 S3P500 $0 $3,500 $2146 $247,575 $47,343 $300,400 $0 $15,500 $269 $7,500 $162,593 $132,407 3079 $201,455 0 $700 $1,000 700 $0 $3,000 677 $3,000 $71 $5,000 so DnOOO $46,479 $45,000 $31,90 $47,000 21,927 $30,000 $19, 874 $30,000 $0 500 $8,694 $7,000 273,738 $522,682 $174,099 $641,555 C $31,53 $3 5,000 S3703 $36,500 32,1 9 $45,000 $35,200 $54,800 $63,442 $80,000 7 , 93 $ 1,300 37,180 $602,682 $246,393 7321P855 Carryover Projects Total $303,355 SPECIAL STREET MAINTENANCE FUND: 2500-421-430240 PROJECTED REVENUE AND FUND SUMMARY ACTUAL BUDGET ACTUAL BUDGE' 1 11 FY 11112 11/1 1 /13 BEGINNING CASH 1010 ASH: Operating $ 79,029 $767,070 $7 7,070 $ 5 ,95 0120 Cash, Transportation Impact Fees* $65PO88 S103,535 $103,535 $0 10107 Cash, Designated Equip. Replacement" $3 ,974 $15,474 $15,474 $3 , 799 10108 Cash, Designated S & C repair *** $44,936 $47,517 $47,517 $47,517 10109 Cash, Designated Pavement Replacement $178,908 $170,75 $170,753 $217,062 Total Cash $1 }004,935 $111045349 $12104,349 $1,15 ,33 REVENUE 343010 Transportation impact fees* $42,739 $40,000 $36,918 $0 343011 S idewalk repair penalty $2,581 $ $0 $ 343012 Public Works Charges $1874 $31000 $575 $1,000 363010 Maintenance Assessments $11460,394 $174335,000 $1,451,853 $1,420,000 -designated for pavement replacement $280,000 $2 0,000 $2 0,000 $2 01000 -designated for equipment replacement $35,000 $35,000 $35,000 $35,000 363040 Penalty & Interest $21,255 $12,50 $12,648 $1,500 364030 Sale of Misc./auction $ , 49 $1,200 $3,934 $1,200 371010 Investment $9, 08 $7,0 0 $9,315 $9,000 1050 Inception of Loan $ $172,000 $170,793 $195,0 0 Total Revenue $1,861,10 $1,985,700 $2,0 1, 36 $1,953,700 Total Available $27 6 3035 $3,09 , 49 $3,105,3 5 $3,112,036 1' 1 RE EXPENDITURES Street Department/TSS $1,4151.1944 $11.172,023 $1,55,611 $1,14,270 Capital Equip. Replacement $5 ,500 $10,000 $13,675 $0 Repair funds *** $o $31,041 $0 $31,041 Refund Transportation Impact Fees $0 $1441072 $144,072 $0 Pavement Replacement program S2 ,155 $4 0,0 0 $233, 91 $53 ,000 Total Expenditures $1,7 0,599 $2,361,136 $1,947,049 $2,375,311 ENDING CASH 10100 Cash, OPERATING $763,65 $671,747 $85,95 $811P3 10120 Cash, Transportation Impact Fees* $107,27 $14,535 0 $0 10107 Cash, Designated Equip. Replacement $157474 S401474 $36,799 $71,799 10108 Cash, Designated S & C repair *** $47,517 $16547 $4,17 $16,47 10109 Cask Designated Pavement Replacement $170,753 $753 $217,0 $32,93 Total Cash $11105,43 $ 72,9 5 $1,158,336 $73 ,725 ' Adding $35,000 per year to equipment replacement ` $2 0,000 pavement replacement annually (appropriated) SPECIAL STREET MAINTENANCE FUND: 2500-42]-430240 EXPENDITURE SUMMARY Personal Services Materials and Services Debt Service Transportation Impact. Fee Reimbursement Capital Outlay from assessments TOTAL EXPENDITURES FOR OPERATIONS Pavement Replacement Funds * * * * Eq uiprnent Rep] Funds ** Sidewalk & Curb repair Funds ACTUAL BUDGET ACTUAL BUDGET ]FY10/11 1FY11/12 FYII/12 FY12/13 $958,420 $991,685 $884,087 $9 7,761 $440,978 $484,584 $437,898 $510,90 16,546 $37,754 $16,200 $46,119 0 $144,072 $144,072 $0 0 $212,000 $217,436 S270,000 1,41 ,9 4 1187%095 $156995683 $1,8143270 2,155 450100 $233,691 530,000 $56,500 110 $13175 so $ 31,41 0 $31,041 1}760,599 2,361,16 1}947,4 2,375,311 Special Street Maintenance funds will be primarily used for street sweeping, flushing, leaf pier -up, sanding, deicing, snow plowing and snow removal. The overall goal is to maintain all city streets in a clew, safe and drivable condition during all seasons. The Special Street Maintenance funds also supports Traffic Signs & Signals. Traffic Signs & Signals is responsible for determining proper sign location, maintenance of signs, striping of crosswalks and streets, maintenance of traffic signals and placement of emergency sigage where needed to provide the safe and orderly passage of vehicles and pedestrians in the City of Kalispell. This division supports the police Department for emergency traffic control and street blockage for parades and other unique events. Current rates vacant land _012 0 9 % non-residential .01803 residential .012220 100% commercial .01900 SPECIAL, STREET MAINTENANCE FUND: 2500-421-430240 FY 2013 BUDGET HIGIiLIGIiTS Line Item Detail: Street Division 218 Equipment- Non Capital - $ ,0001 Safety Equipment & Supplies $ , 00 4,500 - Sweep Pickup Broom attachment for Skid Steer 3,500 - Jumping Jack Compactor 366 Building Maintenance - S4,000 Increase to fix leaking roof on the Street Equipment building. Capital Outlay: Operating Fund 1.0 00 840 MAGI Grant Mateo - $ 7 ,000 - operating transfer to AIACI grant The State is once again proposing to provide local Bove .meats the opportunity to purchase air quality management equipment, like street sweepers, through the Montana Air & Congestion Initiative MA i . The City is proposing to purchase one new Flush truck (Cab & Chassis truck w/ ,000 gallon tank wfunder body plow) and one new street sweeper. There is a chance we will only receive one item, priority would be to replace our current 1995 flush truck which is very poor condition, 430244 44 Capital Outlay: Pavernent Replacement 1.010 354 Pavement Maintenance funds - $530,000 Carryover $250,000, New Appropriation $280,000 ASB 34 rules now require accounting for the value of public infrastructure so that adequate steps may be taken to ensure the on going costs of operation, maintenance and replacement of these facilities may be adequately budgeted. The FY 2007/08 budget included a 10% rate increase that is reflected in this line item. The funds derived are reserved solely for pavement maintenance and replacement of existing streets. 40 Machinery & Equipment - $1 5,000 CapitalOutlay: (Financed 5 yr) 45,000 - Leaf Machine 150,000 - ( Used Single Axle Dump Trucks Debt Service: Board of Investment loans 61.0 $53,900 Principal 60 $4,3731nterest FY 2012 BUDGET ACCOMPLISHMENTS Street Division • Street Division maintained 148.3 miles of streets and alleys. • Purchased an asphalt roller and clump and plow truck. • City Street crew paved eight overlay projects. 13 SPECIAL STREET MAINT'ENAli'CE FUND: 2500-02I-430240 F'Y 2013 BUDGET HIGHLIGHTS - 'I`SS Line Item Detail; Traffic Signs & Signals 243 Traffic Signals - S33,500 (increased ,500 10,000 - In order to comply with safety regulations service disconnects will be installed on the city owned traffic signals (7), Gives us the ability to disconnect the power to the our traffic signals. � his is a critical item that is essentially the same as an electrical breaker in a building. 9,000 - Upgrade three of the seven 3,000 each) 35+ year old traffic controllers on the city owned signals to the new state contract controller. ,500 - Continue program to install LED countdown pedestrian crosswalk beads. 0,000 - Disc mainten ncelrepair /replacement. pants, etc. Y 2012 BUDGET ACCOMPLISHMENTS -SS Traffic Signs & Signals * Implemented FEC rebate program and updated lighting fixtures throughout City of Kalispell maintenance shags. • Installed countdown LED PE 's throughout half of the City of alispell's traffic signals (other hall` of town scheduled for net . Completed yellow LED signal lamp changes on all of City of alispell's traffic signals. SPECIAL STREET MAINTENANCE eurrD: zsoo-aziasozao EXPENDITURE DETAIL ACTUAL BUDGET ACTUAL BUDGET FY10/11 lF"Y11/12 FYII/12 FY12/13 STREET DIVISION Personal Services: T 's 12.65 12. 12.35 12.25 110 Salaries and payroll costs $559,204 $5 3,9 5 $527,1 9 $ 70,667 112 Severance L. Hogan) $6,4 5 $ : 00 $19, 30 $25,000 121 Overtime $23,703 $30,000 $4,160 $30,000 153 Health Insurance $1,370 $155,620 $136,126 $157,34 155 Retirement ent $36,145 $36,3 $34,049 $35,393 Total Personal Services $753,907 $ 14,493 $721,324 $ 1 ,444 Materials and Services: 210 Computer Eguip ent/Softv4fare/Supplies $4,031 $5,000 $3,519 $5,000 218 Equipment /safety equipment & supplies $2,173 $2,200 $3,467 $10,200 220 Other supplies, Janitorial, consurnable tools $4,127 $3,900 $4,5 7 $400 231 Gas & Oil $37157 $40,000 $33,72 $42,000 341 Electric $1,42 $1,400 $1,173 $1,400 345 Telephone $959 $1,000 $1,092 $1,000 354 Contract Services $15,313 $12,500 $12,131 $151000 355 Transportation Traffic Reviews $77 $51.1000 $0 $0 57 Rate Study $0 $,000 $3,06 $0 358 Impact Fee Study $0 $141.1000 $0 $0 362 Equipment Maint_ parts & supplies, includes radios $27773 $2 ,000 $30,589 $2 ,000 36 Building taint.. $1,509 $1,500 $3,13 $400 373 Dues & Training $700 $2,500 $3,081 $3,500 388 Medical services/drug test $7 7 $1,100 $1,423 $1,100 510 Property & Liability Insurance $2,919 $85,000 $7,797 $7,000 512 Uninsured Loss -deductible $5,1 2 $1 0,000 $52 $10,000 521 Central Garage Transfer $66,000 66,000 $66,000 $70,000 522 Administrative Transfer $56,741 $64,77 $64,707 $67,420 528 Data Processing Transfer $10,69 $10,6 99 $10,7689 $12,12 Subtotal M & 0 $31 ,374 $3621.1496 $321, 8 7 $361, 02 6101620 Debt Service -Principal & Interest $16,546 $ 7,754 $16,200 $462119 720 Transportation Impact Fee Reimbursement $0 $144,072 $144,072 $0 15 SPECIAL STREET MAINTENANCE FUND: 2500-421-430240 EXENTUDETAIL -con' to Capital Outlay: 40 NIACI Grant Match 940 Machinery & Equipment offset with inception of loan) Subtotal capital outlay 430244 354 Pavement Maintenance funds 430245 Replacement Funds; 40 Machinery & Equipment Subtotal Replacement 430248 Sidewalk & Curb Repay- funds 354 contract services (carryover) TOTAL STREET DIVISION 430264 TRAFFIC SIGN & SIGNALS Personal Services: FTE's 110 Salaries 112 Salaries - Severance 121 Overtime 153 Health Insurance 155 Retirement Total Personal Services Maintenance & Operations: 210 Computer Equipment/Software/supplies 218 Equipment /safety equipment & supplies 220 Other supplies, Janitorial, consumable tools 242 Street Signs 243 Traffic Signals 245 Barricade Materials 341 Electricity 345 Tele. & Communications ACTUAL BUDGET ACTUAL BUDGET FY1.0/I1 FY11/12 FY11/12 FY12/13 0 $40,000 $40,000 $75,000 $0 $172,000 $177,436 $195,000 $0 $212, 000 $217,436 $270,000 $288,155 $45 ,000 $233,691 $5 0,000 56,500 $10,000 $13,675 $0 $56,500 $10,000 $1,675 $0 $0 $31,41 $0 $1,041 $114 ,4 $2^1,856 $1,668,285 $25057,50 2.5 2.5 2.5 2.5 $146, 39 $140, 06 $12 ,3 1 $132,645 2,70 $0 $0 $,105 $,500 SSP483 $9,500 $15570 $19,524 $17,413 $1 ,270 $10,991 $8, 62 $ ,4 6 $8,902 $204,513 $177,192 $162,73 $1 9, 17 $569 $1,500 $3 $1,500 $,437 $5,600 $9,052 $4,500 $3,311 $2,250 $3,386 $3,500 $47,499 $40,000 $35,590 $44,000 $9,730 $10,000 $13,593 $3 ,500 $2,708 $4,500 $4,455 $4,700 $,99 $9,000 $4,49 $,500 $70 $700 $713 $70 SPECIAL, STREET MAIN'I'ENANCE FUND- 2500-+121-430240; 430264 EXPENDITURE DETAIL -con'. ACTUAL BUDGET ACTUAL BUDGET FYI/I1 FY11/12 FY11/12 FY12/13 Maintenance & Operations; Cont. 354 Contract Services $22,173 $10,000 $18,602 $15,000 362 Equipment Maintenance Parts, includes radios $3,196 $2,500 $2,155 $3,000 366 Building Maintenance $1,551 $1,500 $4,920 $2,000 373 School & Travel $2,218 $2,500 $2,619 43000 428 Paint Materials 9 4 $15,000 $4,445 $9,000 510 Property & Liability Insurance $3, 74 $3,700 $3,749 $4,200 512 UninsuredLoss-deductible property $2,059 $2,500 0 $2,500 532 Office Rent $7P838 $7,8387,3 7,3 Subtotal M 122,04 1220 11,1 $148P488 Total Traffic Sign & Signals S327,117 S2995280 $278,764 317980 Grand Total - STREETS & SIGNS 1J609 99 $2,3619136 $199473,049 $29375,311 17 MT. AIR & CONGESTION GRANT FUND: 2825... STREET .... 421.—FUNCTION .... 43024Q PROJECTED REVENUE AND FiJ10']) SUMMARY BEGINNING CASH CASH: Operating REVENUES 331055 l AC1 Grant for weepers/Hush Trks 383012 Transfer from Street Maintenance (match) FY 11/12 Sweeper CARRYOVER FY 12/13 Flush Track/Sweeper Total Revenue TOTAL AVAILABLE EXPENDITURES 40 CAPITAL EQUIPMENT - ENDING CASH CAI: Operating ACTUAL FY10/l1 BUDGET FY11/12 ACTUAL FY11/12 BUDGET FY12/13 $0 so $0 $407000 $0 o $0 $0 $1 0,000 $40,000 0 $0 $40,000 $0 $45 ,373 $0 $757000 $0 $0000 $40,000 $3,373 $0 00,000 $40,000 $574,373 $0 S200,000 0 $74173 $0 $0 $40,000 0 The State has approved requests for equipment purchased through the Montana Air & Congestion Initiative MACI grant. The grant includes a 13 ,4% match. The City is currently Nvaiting for the sweeper budgeted in FY 11/12 and carried over $40,000 in matching funds. A new appropriation of $7 ,000 is for FY 12/13 MACI grant request for a new Flush Truck with a 3,000 gallon tank and underody plow, and another new sweeper. Where is a chance we will only receive one item, priority would he to replace our current 1995 flush truck which is very poor condition. Total cost of the FY 12 Sweeper $ 0 ,373; FY 13 estimated cost of Flush Truck $15 ,000, estimated cost. of FY 13 Sweeper $215,000. SIIDEVVAI,I{ & CURB CONSTRUCTION FUND: 4290-410-430234-937 PROJECTED REVENUE AND FUND SUMMARY BEGINNING CASH 1010 CASH: REVENUES 1004 Proceeds S & C Warrants Total Revenue TOTAL AVAILABLE EXPENDITURES 97 Sidewalk Construction Costs 10100CASH: ACTUAL BUDGET ACTUAL BUDGET FY10/11 FYI1/12 lFY11/12 FYI2/13 0 $0 0 942 $25,000 $5,793 $25,000 $942 $25,000 $5,793 $25,000 $942 $25,000 $5,793 $25,000 942 $25,000 $5,793 $25,000 0 so 0 0 PROGRAM DESCRIPTION The sidewalk and curb construction fund is used to record expenditures for replacing sidewalks and curbs which residents request or which the City orders in. The costs are paid for by the property owner. They are billed for the cost of construction plus 5% for administration, The property owner can have the cost put on the tax notice for a period of 8 years. The City issues sidewalk curb warrants to fund_ 19 SII3 345 THE WILLOWS CAD:4345-453-430246 PROJECTED REVENUE AND FUND SUMMARY BUDGET ". ........... .. . . .. V, 1 11 BEGINNING CASH 10100 CASH: 4zn 'VI71M1X7TTIr, LN 381004 Proceeds SID BONDS $392,556 Total. Revenue $392,556 TOTAL AVAILABLE EXPENDITURES 950 STORM SEVER Construction Costs ENDING CASH 10100CASH: 101 ;; TA PROGRAM DE9CRIPTION The SID STORM SEVVER construction fund is used to record proceeds of the SID bonds and related expenditures for the Storm sewer improvements requested by die property owners in, the district. 20 WATER FUND (Operations & Billing) Ft.rrrD: 5210-447-430550 PROJECTED REVENUE AND FUND SUMMARY BEGINNING CASH 10100 Operating Cash 10120 Impact Fee Cash 10125 Meter Replacement Cash 10107 Capital & Emergency Reserve -target $400,000 1 130 Bond Reserves (restricted cash) Adj. to Cash/ AARl omp. Abs. ACTUAL BUDGET ACTUAL BUDGET I+`Y10/11 FYI.I/12 FY11/12 F'Y12/13 $2,485,858 $213213,299 $2,321,299 $ ,595,133 $778,004 $448,354 $448,354 $472,801 $240, 00 $266,434 $2661434 $2631273 $ 10,000 $3407000 $340>000 $ 70,000 $5157449 $5153449 $515,449 $460,119 ($5,093) $2,102 $4,325,018 $3,91,536 $3,893,638 $4,161,326 REVENUES 343210 Metered Water Sales (billed) 10100 $2,156,34 $2,203,000 $2,283,278 $200,000 343230 Meter Replacement Fee (10125) $96,167 $95,000 $96,385 $95,000 343225 Impact Fees 10120 (adj for receivable- $4,094) $ 30,724 $225,000 $197,484 $225,000 343365 Impact fee Adrnin 10100 $25, 96 $13,000 $9,138 $13,000 343260 Misr-.-Installation/Reconnect/Tag Fees 10100 $65,508 $40,000 $41,579 $40,000 371010 Interest Earnings (10100) $44,635 $4,000 $40,206 $40,000 Interest Earnings -Impact Fee Cash 10120 $10,719 $10,000 $4,847 $10,000 Total Revenue $2,630,483 $2,631,000 $2, 72,917 $3,023,00 Total Available $6,955,501 $6,522,536 $6,56 , 55 $7,184,326 EXPENSES EXPENSES FROM RATES $2,422,3 9 $3,2 0,759 $2,127,799 $3,614,782 Expenses from Meter cash 10125 $71,118 $100,000 $ 9,546 $136,500 Capital Outlay - from Impact Fees 10120 $471,093 161,D00 $77,884 $15,000 Debt Service -from Impact Fees 10120) $1001000 $100,000 $100,000 $100,000 Depreciation $825,000 $825,000 $825,000 $840,000 Total All Departments $3,899,550 $4,416,759 $V30, .29 $4,849,2 2 add back depreciation $25,000 $85,000 $825,000 $840,000 ENDING CASH 10100 Operating Cali $2,321,299 $1,361,540 $2,59,133 $1,64,351 10120 Impact Fee Cash $448,354 $422,354 $472, 01 $449, 01 10125 Meter Replacement Cash $266,434 $21,434 $263,273 $221,773 10107 Capital GEC. Emergency Reserve -target $400,000 3407000 $370,000 $370,000 $400,000 10130 Bond Reserves (restricted cash) $515,449 $515,449 $460,119 $460,119 Total cash $3,891,536 $2,930,777 $4,161,26 $3,175,044 *Capital & Emergency reserve funded $30,000 from operations 10100, Target will be met 2013, 1 ACTUAL BUDGET ACTUAL BUDGET FYI0/11 FY11/12 FY1/12 FY12/13 Personal Services: Water bilfing $111,1 2 $132,7 2 $1 ,425 $110,766 Water Operations $72,30 $65,77 $820,990 $924,405 Total PERSONA, SERVICES $984,112 $99 1469 $ 51,415 $1,035,171 Maintenance & Operations: Water Billing services $72,617 $75, 40 $7 ,577 $84,3 6 Water Operations $642,612 $73 ,1 4 $600,968 $72 ,9 5 Total M & 0 from rates $715,229 $1204 $6 74,-5 455 $11,21 Capital Outlay from rates: Water Operations 31127 $1,104.800 $186,353 $1,417,21 Total CAPITAL from rates $311,786 $1,104, 00 $1 6,353 $1,41752 1 Debt Service from rates: Water W 1 1 15 4RA 1015 AR Q119I n o Total DEBT from rates $411,21.2 $315,4 6 $315,4 6 $ 51,059 TOTAL EXPENSES FROM RATES 242, 52 ,7 9 $ ,12737$3fiI41782 Capital Outlay - Meter Replacement funds:(11012 ) Capital Outlay - from Impact Fee Funds: 10120 Debt Service -from impact Fees: 1 120 Depreciation non -cash item) Grand Total $71JIS $100,000 $99,546 $136,500 $471,093 $1 1, 00 $77,884 $15 ,000 100,000 $100,000 $100,000 $1 0, 0 $ 25,000 $ 2.5,000 $ 25,000 $ 40, 00 39889, 0 S4,4169759 $ ,230,229 $41,4%212 22 WATER OPERATIONS FUND: 5210-447-430550/560 PROGRAM DESCRIPTION The water facilities budget accounts for the costs associated with providing safe, potable and palatable water for the needs of the domestic, institutional, industrial and commercial consumers and to provide adequate pressure and flow to meet fire fighting and irrigation needs. Maintenance of the live Nvells and Noffsinger Spring as water sources along with maintenance of the distribution system, storage facilities, fire hydrants, valves, meters and related controls is an integral part of the function of this department. This budget is responsible for pumping and treating millions of gallons annually. FY 2013 BUDGET HIGHI,IGH'PS Line, Item Detail: Water Fund 226 Chlorine & Chemical - $38,000 Funds include $3,500 to purchase a chlorine analyzer. 354 Contract Services - $55,000 This line item covers the cost of annual contracts, i.e., U-dig fees, generator testing and maintenance, coveralls, and estimated electrical and system repairs. Capital Outlay: Operating Funds (dates) 5 Armory Well Generator Replacement - CARRYOVER $90,000 9000 - This project will replace the 1920's generator at the Armory Well site. The existing generator has a failing injector pump and pars to replace and repair the injector pump are no longer made. Armory Well was the largest production well in 2009. During power outages it is essential to have A inry Well online during peak demand. The ability to provide water during emergencies is compromised when the backup generator is failing. A. new diesel generator will allow the City to provide water from this well site during power outages. New appropriation of $30,000 is required for the well house demo and repair, landscaping removal and installation, the crane and equipment to remove and install the generator, and the licensed electrician required for electrical connection. Arniory Well Replacement Generator Construction Bids are clue on April 26, 2011 The contractor selected to install the Generator will be presented to council on May 7th. The contractor will then have 120 day to complete the required generator scope of work. Project completion is anticipated in the late summer of 2012 W - - 150). 936 Noffsinger Spring Emergency Generator- Replacement - $90,000 Replace the old emergency generator which is currently inside the shop area, with a new emergency generator located outside and above flood stage elevation. luring our 2010 safety/building/fire audit many deficiencies were pointed out about the generator being at its current location, with no containment area for either the generator or the fuel system, proper venting is a large problem, no seismic bracing to prevent roll over, fire protection and accessibility. The age of the generator make it more and more difficult to find replacement parts. By replacinZn g this generator it reduces chances of fire and safety of workers from inside the shop area and meets the Fire Department safety audit requirements. A new generator also increases efficiency and reliability. A Grant application has been submitted to supplement the funding of the replacement generator. The Emergency Backup Grant, if received, will contribute 7 % of the replacement cost -1 X-160 . 23 WATER OPE1kATIONS ,FUND: 1-447-41 FY 2013 BUDGET HIGHLIGHTS - con't. Line Item Detail: continued Capital Outlay: Operating Funds (Rates) Cont. 937 Sheepherder Tank Backup Power - S16,000 Provide backup power for the S ADA. system at Sheepherder Reservoir. Currently there is no backup power at Sheepherder Reservoir, ir, Power frequently goes out at this location, when the power is out the water level in the tank is € nknown and signals are not being sent to activate pumps. A Grant application has been submitted to supplement the funding of the replacement generator. The Emergency Backup Grant, if received, will contribute 75% of the replacement cost (W-E -161). 938 Lover Zone Reservoir Improvements - $120,000 An inspection of the lower zone reservoirs identified structural and potential water quality risk inadequacies. The structural improvements include pressure epoxy injection for the vertical cracking in perimeter walls. Surface concrete improvements involve replacing and sealing areas of extreme spalling, chipping, and voids/gaps to the outside. Eaves and screen venting will be improved to meet DEQ Standards and prevent degradation ofthe roof structu re(VLF- X-15 . 940 Machinery& Equipment- Carryover $6,500 -New Appropriation $70,000 6150 - (Carryover) - Plow for 1 Ton Service Truck 10,000 - Hydraulic Submersible Pump $60,000 - 'Valve Maintenance Trailer - replacing 21 yr old valve maint. Trailer 941 Utility Asset Management Program - S34,000 Asset Management Program for Water, Sewer, and Storrmwater Utilities. The Asset Management Program works in conjunction with all other IS -centric applications to manage utility assets in the geodatabase. Service requests, Nvork orders, inspections, and projects are used to track municipal types of work activities with their associated costs. Map layers can be created to display information on each utility. Asset Management Programs involve field -workers, call takers, and administration, to get the inforr ation they need to perform th e it jobs efficiently and make -vise use of the precious resources entrusted to thern to manage their assets as they provide the necessary services, Currently the City of Kalispell manages utilities through historic knowledge and paper trails, making it difficult to assess utility maintenance or replacement needs, cost spending or savings and overall management of the utility system. Asset Management Programs enable cities to perform conditional utility assessments, tracking, material management, work orders, repair tracking, budget planning, data usage in the field, database historical reference, and reports. Costs shared w/ terra - Total Cost $72,476 (W-EX-15 951 S ADA System Upgrade/improvements T CARRYOVER S, 6X System improvements to include installing programmable logic controllers which monitor and control individual well sites in conjunction with the SCADA system. SCADA updates also include the installation of 8 submersible water level sensors at each well site. City operators will be able to review the recorded well activities and corresponding daily water level data, and perform long term trend analysis essential to the ity's water operations. The transducers were selected and ordered in April of 012. Once received the follow-up installation and programming will be complete in the late surer er of2012. -EX-15 ). 24 WATER OPE1dATIONS FUND: 5210-447-430550/560 FY 2013 BUDGET HIGddLIGHTS - con't. Line Item Detail: continued Capital Outlay: Operating Funds (Rates) Cont. 958 Loop Project - CARRYOVER $165,000 16 ,000 - First Avenue NE - north of Arizona cast of North Main Street is currently provided water service with a two inch water pipe. This piping is inadequate for providing water service and provides no fire protection. An eight inch water main with fire hydrant will be installed to provide adequate fire protection to this area. An eight inch water main will be installed in First Avenue EN from East Arizona to North Main Street l-E -30 . Engineering plans and bid packets are scheduled to be complete by May of2012. The project i scheduled to be bid in June and constructed in the late summer or early fall of 2012. 962 Kelly Rd to Woodland Ave - $311,900 This project upgrades the fire flows b y replacing the existing 6" and 4" water line to 8 "water line in S 'woodland Ave, Lehi Lane, Greendale Ct. and Rogers Ct. The project improves fire protection to 30 residential and commercial living units, Existing 6" and 4" water line only provides fine flows up to 63 0 to I 100 gpm. Fire code requires fire flows to maintain 1,000 gpm for residential areas and 1,500 gpm for commercial areas W-EX- 4 . 963 Abandon " Water Line - CARRYOVER $45,000 Abandon "# line between 3rd Avenue West and 5th Avenue West. ,reconnect existing services to existing main. Work to be completed by City Crew W-EX-153 . 964 2nd Avenue WN Waterline Replacement - CARRYOVER $248,000 This project will replace the corroded 6" rvat.er main on 2nd Ave WT between Washington St and California St. The project would install 0" of " C900 rater main and appurtenances on the cast side of 2nd Aare VL, reconnect services and fire hydrants, and includes pavement repair (W-E-1 54). 965 Last Arizona WipeUp-Size - CARRYOVER $195,000 Replace 2" and 4" pipe in E. Arizona and 1st Avenue EMI with 6" and 8 " pipe. The current water mains 2" and 4") are inadequate to provide fire protection. The project would install approximately 1,100" of " C900 water main and appurtenances including pavement repair W-EX-13 . Capital [outlay - Impact Fee funds 10120) 930 Contract Main Upsize - $50,000 Funds required for small city requested upsizing of private development infrastructure (W-EX-119). 941 Meters - $65,000 953 Develop Water Supply for Section 36 Well - CARRYOVER $43,000 This project includes pump testing the existing well to determine dra down and feasible pumping rates. The project also includes the time and materials necessary to prepare a water right change application (-E-147, 25 FUND.5210-447-430550/560 Line Item Detail. continued Capital Outlay - Meter funds(010125) 948 Deters - S130,000 Replacing approximately 400 residential and (2 commercial meters. Meter Pits - S6,500 11. S6,500 - Includes materials cost to purchase 10) 3/4" meter pits to install in residents where access to meter is unavailable. FY zotz BUDGET AccoMrLrsHMErrTs * Operated and maintained 132 miles of water mains, 4 water storage tanks, and 10 water wells. Completed die installation of the Upper and Lower Water System Zones Interconnect project. * Prepared and bid the replacement of the backup power suPply generator at Armory Well. Installation to be completed summer 2012, * Prepared and bid the Colorado Street Water System Improvement Project. Tentatively scheduled to be completed by end of current F . * Completed the South Woodland Dar. water project, which included removing numerous water services from a faulty, undersized 2" water line, and reconnecting them to a suitable 8" water main- * Completed the inspection and cleaning of the two buffalo hill reservoirs. * Replaced security fence at Buffalo Hill Reservoir. * Implemented a backflow prevention program, which involves locating, inspecting, testing, and inventorying all backflow prevention assemblies located in city owned facilities.. * Purchased new 1 ton service truck for water production. Repaired 28 leaking water mains, and service Iines saving approximately 12 gallons' per minute in unbilled water, * Conducted 240 bacteriological water samples. Samples are taken at strategic locations throughout the city, Additionally all 20 samples were absent for bacteria and no violations were issued by Montana DES. * Performed 8 new service line taps and installations and 3 new water main taps for fire suppression. * Repaired in excess of 5 0 water service s hut -off v alves to aid operators during after hours cal I -outs. Continued ongoing fire hydrant replacement, and flushing program. 3 aging dire hydrants were replaced? and 137 hydrants were flushed to remove air, and clew dead -ends, 26 WATER FUND: 5210-447-434550 P-11001-1-ah"12-62 R-1-11,0213-01Y Personal Services-, F` 's 110 Salaries & 'images III Seasonal Salaries 112 Severance 121 Overtime/Call Outs 153 Health Insurance 155 Retirement - PERIL Total Personal Services Maintenance & Operations: 210 Office Supplies/ quip/Computers/ GIS 18 Equip. (non-capital/Safety Equip & Supplies 226 Chlorine & Chemical 229 Other Supplies/janitorial/consumable tools 231 Gas & Oil 312 Postage & printing 336 Public Water Supply Fee 341 Electricity 344 Natural Gas 345 Communications 349 Lab Services 3 Auditing 54 Contract Services 56 Consultants -Water Rights Acquisition / Water Modelin 357 Facility Plan Date Study /Impact Review 62 Repair & Maint../Eq ip. maint.7radios/equip rental 366 Building Maintenance 373 Dues & Training 388 Medical/DrugMedical/Drug Vesting 410 Construction Materials 422 Hydrants 423 Materials - Mains 44 Materials - Service lines 425 Materials - Wells/Pumps 510 Property & Liability Ins. 12 Uninsured Loss -Deductible & Goodwill Expenditures ACTUAL BUDGET ACTUAL BUDGET FY10/11 FYII/12 FY11/12 ]FY1Z/13 19.60 13.25 13.25 12.9 $665,155 $11,897 $25,54 $12 ,031 $44,283 $648,785 $1,770 $77000 $2000 $14 ,924 $41,289 $601,033 $1,712 $17,545 $20,97 $139,939 $39,835 $6647242 $5,000 $35,000 $20,000 $155,842 $44,321 $872,930 $8651767 $82.0,990 $924,405 $6,415 $12,450 $6, 718 $101000 $16,649 $19,500 $16,274 $9,500 $ 7,1 4 $39,000 $29,4 8 $3 ,000 $2,571 $4,800 $2,832 $4,800 $31,480 $297000 $31,624 $35,000 $3,98 $4,00 $31.1660 $4,500 15,299 $19,000 $15,206 $19,000 $121,13 $143,000 $12,393 $143,000 $12,984 $13,000 $11,691 $13,000 $7,095 $8,000 $8,464 $8,000 $1,20 $25,500 $11,480 $22,00 $2,550 $300 $2,500 $3,000 $41, 18 $70,000 $59,953 $551000 26,378 $25,000 $17,92 $25,000 $3,921 $a $0 $6,500 $10,108 $14,950 S1 I,723 $14,950 11,8 2 $17,000 $7,049 $17,000 $10,309 $7,200 $7,467 $9,2.00 $673 700 75 $700 $37,452 $30,000 $29,612 $32,000 $3,057 $1500 $9,037 $101000 $8,117 $1 I,000 $8,770 $11,000 $8,301 $9, 00 $111639 $11,000 $24,008 $36,000 $7,302 $0,000 $3,829 $34,500 $,193 $36,500 $26,9 $1,000 $,132 $24,000 7 WATER OPERATIONS 5210-447-43 0550 EXPENSE DETAIL Maintenance & Operations -continued: 521 Central Garage Transfer 22 Administrative Transfer 528 Data Processing Transfer 532 Office rent Total Maintenance & Operations 40200 Debt Service- ALL BONDS & LOANS: 101620 Principal, Interest, fiscal fees CAPITAL OUTIAY Capital Outlay: Operating funds (BATES) 95 Armory Well Generator 936 1 of1'singer Spring Generator 937 Sheepherder Reservoir SCADA Backup Power 938 Lover Zone Reservoir Improvements 40 Equipment 41 Utility Asset Management Program 944 Meter Maintenance 'Vehicle: 948 Meter (Meter Funds) 010125 950 1 Ith St E Water Main fyl 1 951 Security Upgrades FYI17 SCADA Upgrades F 956 [upper one/Lower Zone Interconnection 958 Loop projects carryover 962 Kelly Rd to Woodland Ave 963 Abandon 2" vaster Iine (carryover) 964 2nd Aare WN Waterline Replacement (carryover) 965 East Arizona Pipe Tip -Size (carryover) Subtotal capital from operating fund 430555 Capital Outlay-1inpact Fee Funds (1 120 941 Meter 930 Contract Main Upsx e (Impact fee inv. Acct) 53 Develop Water Supply for Section 36 Well (earn Subtotal capital from Impact Investment fees 430550 Settlement from Impact Fees 1010 358 Owl Corporation ACTUAL BUDGET ACTUAL. BUDGET `Y10/11 F'Y11/12 FYII/12 FY12/13 $7,500 $8,000 $8,000 $,000 $94,723 $91,1 5 $91,1 5 $96,825 $20,041 $20,041 $20,041 $21,172 $7, 5 7, 3 $7, 38 7783 642,612 $736,164 $600,968 $76,95 511,2.12. $415,4 6 $415,4 6 $4517059 $0 $90,000 $,473 $0,000 .$0 $0 0 $90,000 $0 $0 so $16,000 $0 0 so $120,000 $1067232 $45,000 $33,948 $76,500 0 0 0 $4,000 0 $0 $24,156 $0 0 0 $75,390 0 $167,942 0 $0 0 $ 1,2.86 $40,000 $14,139 $2501 $6,326 $30,000 $ 2,241 $ $0 $411,00 0 $165,000 $0 $0 $0 $311,900 0 $45,000 $0 $45,000 0 $24,000 $0 248,000 $0 $195,000 0 $195,000 311,76 $1,104,800 $16,353 $1,417,261 $5,000 $65,000 $65,000 $5,000 $0 $507000 $0 $ 0,000 $92,626 $4,000 $12,84 $4,000 157,626 $161,000 $77,4 $15,000 $313,467 0 $0 $0 Capital Outlay: 430550 Capital Outlay-1 eter F unds 01012 411 Meter Pit - Materials 944 Meter Maintenance Vehicle 948 Meters -Replacement $ subtotal 510400 Depreciation 31 Depreciation expense Total Water Facilities 430560 'CATER BILLING Personal Services: 110 Salaries & Waves 112 Severance 153 H aldi Insurance 155 PE D Total personal Services Maintenance & Operations: 210 Office.Supplies/computers 3 Auditing 34 Contract Services 55 Postage/Other Billing Costs 373 Dues & Training 522 Administrative Transfer 529 Data Processing Transfer 532 Office rent Total Maintenance & Operations Total Water Billing ACTUAL BUDGET ACTUAL BUDGET FY10/I1 TY1I/12 i+Y11/I2 FY12/13 $0 $ $0 $6,500 $0 $2.5,0 $24,156 $0 $71,118 $75,000 $75,390 $13,000 $71?118 $100,000 $99,546 $136,500 $825,000 $ 25,0 0 $825NO $840,00 $3,705,751 $4,208,17 $,026,27 $4,654,210 TE's 2 2 2 2 85,02 $89,596 $7,680 $82,42 $0 $11000 $12,000 $0 $20,305 $5,2.3 $24,597 $22,343 $5,575 $5,823 $62148 $5,4 1 $111,182 $132,702 $1 01425 $11 ,76 $495 $3,225 $1435 $3,000 $1,500 $1,500 $1,500 $1,500 $3,56 $5100 $2,2 $41>000 $29,953 $27,5775 $30,098 $35, 00 $1,046 $1,500 1.,41 1,500 $6,178 $6,961 $6,961 $7,103 $25041 $22,041 $22,041 $4,365 $7,3 $71838 $7,838 $7,138 $72,617 $75,840 $7,577 $84,30 $13,799 $208P542 $204,002 $195,072 GRANDTOTAL WATER FUND $3,8 , 0 $49416,759 $3,230,229 S4,84%282 WATER FUND 52 i 0-447-49QXXX DEBT SERVICE DETAIL ACTUAL BUDGET ACTUAL BUDGET FYI0/11 FYII/12 FYI1/12 FY12/13 REVENUE BONDS 490250 Debt Service-2001 WRF Loan - 4% (Maim & Idaho Project) 10 Principal $38,000 $39,000 620 Interest. $181 i860 $17,340 490204 Debt Service-20 4 Revenue Bond:( includes refunding 1996)(H y 93 S 610 Principal $145,000 $55,000 20 Interest $46,630 $41,195 630 Fiscal Agent Fees $300 $300 490206 Debt Service-2007 W F loan 3.75% A Refunding B 1 loans meters & hydrants 10 Principal $157,000 $163,000 620 Interest $30,262 $24,319 490206 Debt Service- 007 W F loan 3.75% B Water Reservoir project 610 Principal $22,000 620 Interest $53,160 Subtotal Operations $11,2 l $39,000 $41,000 $17,340 $15,50 $55,000 $55,000 $41,195 $38,995 $300 00 $163, 00 $169,000 $4,319 $17,150 $23,000 $2,332 $23,000 $52,332 $63,000 $51,094 $415,486 $415,486 $451,059 30 SEWER- SANITARY OPERATIONS, BILLING, WASTEWATER TREATMENT FUND: 531 p PROJECTED REVENUE AND FUND SUMMARY ACTUAL BUDGET ACTUALBUDGET BEGINNING CASE 10100 Operating $519,622 510,822 $102,822 $353,470 10123 SANITARY Sewer Impact Fee Inv. Account S1,623,691 $1,752,917 $1,752,917 $1,862,927 10124 WW` P Impact Fee Inv. Account $447,048 $398,388 $398,388$334,230 10125 WVnT Equipment I epi/Evergreen 532.8,970 $6645597 $664,597 $969,880 1013x Bond Icservesl Operating reserve $1,584,162 $1,561,162 $1,522,469 S1,522,469 Adjrnts to Cash (comp abs., receivables, bond preserve) 104,468 538,693 4939%025 $4479,886 S4479,886 �04 �976 REVENUES 343310 SEWER SERVICE -billed (10100) $3,274,532 $3,730,000 53,707, 93 S4,115,000 343360 Misc. ; (10100) $24,408 $2,000 517,910 $2,000 43330 Impact Feellloolcup-Sanitary 10123) $140,629 $112,954 $116,051 $87,400 43330 Admin Impact Fees Sanitary (10100) $6,92.7 $5,643 $6,546 $4,600 343335 Impact Fee[Hookup-WWTP (10124) $170,791 5150,642 $156,538 $117,800 343335 Admire Impact Fees WWTP 10100) 58,749 $7,500 $8,781 $6,200 Bonded Debt $865,000 371010 Interest -operations 10100) $24,376 $30,000 519,627 S20,700 Interest-1 WTPIEvergreen 10125 $6,535 $6,250 $9,301 $4,050 Interest-WWT,p Impact Fee Aw, (10124) $5,549 $5,750 $4,304 $3,600 1 nterest- Sani tary Impact Fee Invest. Acet. (10123) $21,625 $23,000 $18,959 $16,650 Total Revenue $304,121 $4,073,639 $4,066,010 $5,243,000 Total Available 58,083,146 $85553,525 $815455896 S10,2851976 ]EXPENSES EXPE NSES FROM RATES 3,674,324 $3,833,158 $3,549,902 $3,786,614 Capital Outlay City/Evergreen Funds 1012 92,507 5253,500 $115,617 $731,948 Capital Outlay 7 Bonded Debt $865,000 Capital Outlay - from Impact Fee funds: Capital from impact fee funds Sanitary10123 8,028 $45,000 S0 $245,000 Debt Service From Impact. fees: Portion of debt from impact Sanitary 10123 525,000 $25,000 $25,000 $25,000 Portion of debt fi um impact WWTP 10124 225,000 $225,000 $225,000 522,000 Depreciation n (non cash expense) $2,215,855 $2,240,000 $2,240,000 $2,245,000 Total Expenses 56130,71 $6,6 156 8 $6,1549519 8,1239562 Add depreciation to cash $2,215,855 $2,240,000 $2,240,000 $2,245,000 Add cash distribution to Evergreen) ity 10125 from 10100 5411,59 $411,599 $411,599 $411,599 ]ENDING CASH 10100 Operating $102,822 $44,807 $353,470 $715,355 10123 SANITARY Impact Fee Inv. Account $1,752,917 $1, 1 ,771 $1,862,927 $1,696,977 10124 *** WWTP Impact. Fee ,Inv. Account $398,388 $329,780 $334,230 $230,630 10125 ** WWTP Equipment Rep) $6 4,597 $828,946 $969, 80 $653,581 1013x Bead Reserves (restricted funds) S1,561,162 S110561,162 S 1522,469 S1,S22,470 49479, 56 S4,593,466 5 ,042,976 S4,81%013 Budget to fund debt service with Impact fee charges for $25 ,000 { wwtp $225,000; sanitary $25,000 ; bond reserve lowered $23,000 31 ACTUAL BUDGET ACTUAL BUDGET FY10/11 FY11/12 FYI1/12 FI'12/13 Personal Services: Sewer billing $91,3 6 $106,795 $106,551 S92,651 Sanitary Sever S365,900 $347,797 $249,577 312,344 WWTP & LAB $575,515 $609,372 S562,860 $597,402 Total PERSONAL SERVICES $1,032,751 $1, 63,9 4 $918,988 $1,002,396 Maintenance & Operations: Sewer Billing services $73,570 $74, 2 $71,041 $82,076 Sanitary Sewer $614,281 $373,4 1 $57,500 $391,122 WWTP & Lab $ 85,198 $7/ 7,353 $656,624 79 ,03 Total IM & 0 from rates $1,123,049 1,224, 66 $1,085,165 $1,272,281 / Out lay utla 1`,Fom rates: Sanitary Sewer Operation so $o $0 $36,500 WWTP & Lab $0 $ 0,000 $ 0,420 $110,000 Total CAPITAL from rat $0 $30,000 $30,420 $146,500 Debt Service from rates: Sanitary Sewer $90,075 $ 0,9 4 S80,995 $81,500 WWTP $1,026,850 $1,021,735 $1,021,735 $872,338 Total DEBT from rates $1,106,95 $1.,102,729 $1,102,730 $53,838 City/Evergreen Replacement funded from rates: S411,599 $411,599 $411,599 S411,599 TOTAL EXPENSES FROM RATES Capital Outlay - Other funds.- WWTP Bonded Debt WWTP (10125) CityMvergreen account Capital Outlay - from Impact Fee funds: Sanitary Sewer 1012 Debt Service -from Impact Fees Sanitary Sewer 10123 WWTP 10124 Depreciation (non -cash item) Sanitary WWTP $3,6749324 $3,833,158$39, 3,7 , 1 0 so so $865,000 $2,507 $253,500 $115,617 $7 1,948 ,028 $45,000 so $245,000 25,000 $25,000 S25,000 $25,000 $2 5,000 $225,000 S225,000 $225,000 $800,0 0 $815,000 S815,000 S820,000 $1,415,855 S1,425,000 S1,425,000 $1,425,000 Grand Total S6,230,714 $6,621,658 $6,154,519 $8,123,562 32 SEWER - OPERATIONS FUND: 53 t 0-454-430630 EXPENDITURE DETAIL ACTUAI. BUDGET ACTUAL BUDGET FYIO/ll FY11/12 FYI 1/12 FY12/13 Personal Services: TE's 6.95 6.05 6.05 5.50 110 Salaries & Wages 257,425 $255,962 S181,096 $233,8 8 112 Severance $25,843 $5,000 $10,558 $2,500 121 Overtime S5,930 $7,500 S1,976 S7,500 153 Health Insurance $57,509 $62,496 $43,908 $ 3,882 155 Retirement. - P RD SM193 $16,839 $12,039 S14,593 Total Personal Services $365,900 $3147,797 $249,577 $312,344 Maintenance & Operations: 210 Office Supplies/equip/ computer supplies/ xfS 218 Equipment (Ion Capital)/Safety equip &, supplies 229 Other Supplies/ lanjtorial/consumable tools 231 Gas & Oil 312 Postage &. Shipping f Printing 341 Electricity 344 Natural Gas 45 Telephone & Comm., alarms 353 Auditing 354 Contract Services 356 Consultants 357 Impact Fee Study/Review Impact Fees 362 EquipmentMaintenance/buildings & radios 373 Dues & Training, licenses 388 Medical Services 410 Construction Materials 425 Materials - Pumps/Lift Stations 510 Prope y & Liability Ins 512 Uninsured loss/goodwill expenditures 521 Central Garage Transfer 522 Administrative Transfer 528 Data Processing Transfer 532 Office Rent 535 Usage charge for 100,000 gallons -Trur ble Creek Total Maintenance & Operations 33 $3,035 $6,200 $4,079 $6,200 ,160 $8,500 $2,934 S9,500 1,926 $2,300 1,313 $2,000 $9,216 $9,500 $9,395 $9,500 480 300 $114 $300 $46,918 $43,175 $45,197 $48,500 $13,014 $13,000 $12.,482 S13,500 21, 92 $21,700 $23,108 $21,700 S2,000 S2,000 $2,000 $ ,000 S29,743 $26,000 S28,788 $21,000 77 $7,500 $3,928 $7,500 $ ,921 $0 so S6,500 6,787 $6,800 $3,250 $6,800 1,600 $2,00 $2,264 $2,500 $841 950 508 800 1,74 $9,000 $2,099 $9,000 32,873 $15,000 $20,154 $20,000 $50,621 $6 7,000 $65,059 $73,700 18, 813 $18,000 $15,602 $16,000 $2,500 $2,500 $2,500 $2,500 63,374 $63,571 S63,571 $61,533 $14,697 $14,697 $14,697 $16,751 7,838 $7,838 $7,838 $7,8 8 $25,581 $25,500 $26,620 $2,500 $36,281 $373,431 $357,500 $1,12 SEWER - OPERATIONS & B FUND: 5310-454-430630 EXPENDITURE DETAIL Capital [outlay: from rates 90 Install lift Station .enclosure 954 LDS 93 S. Bypass 'F 10; Sanitary ,Liquid Disposal Site TY 13 960 Manhole Rehabilitation /Sewer Main Replacemn nts Total Capitial Outlay 430635 Capital Outlay -Impact Fee funds (101 3) 955 Main & Lift Station Upsi e 957 Grandview Pump Sta./gravity main Fatal Capital from Zinpact fee funds 610 Debt Service -Principal, Interest, fiscal agent fees 510400 31 Depreciation expense Total Sanitary Sewer- budget 430620 +`E'ER BILLIAG F 110 Salaries & Napes 112 Severance 153 Health Insurance 155 Retirement - PERD Total Personal Services Materials and Services: 215 Office supplies/computers 353 Auditing and other contract services 355 Billing CosWposlage 373 Dues & Training 522 Administrative transfer 528 Data Processing 532 Office Rent Total Materials and Services Total Billing Budget ACTUAL BUDGET ACTUAI, BUDGET FY10/11 TY11/12 FY11/12 F"YI2/13 $6, 00 $0 0 $0 $15,000 4 so $0 $1,000 0 0 so $3,500 $0 S45,000 $0 $245,000 $8,028 $0 so $0 $8,028 $45,000 so $45,000 $1051075 S105,994 $ € 05,995 $106, 00 800,000 $815,000 $815,000 $820,000 $1,643,284 $1,687,2.22 $1,528,072 $1,911,466 $72,179 $73,305 $72,337 $67,647 $12,000 $12,000 so $14,616 S16,805 17,067 $20,675 4,41 $4,65 $5,147 $4,39 $91,336 $106,795 $106,551 $92,651 583 $2,225 $1,379 $3,000 2,0 7 $4,000 $ .,500 $4,000 $32,870 $30,775 $30,954 $5,000 907 $1,400 $26 S1,500 $7,24 $,803 $5,803 S6,373 $2.2,041 $22,041 $22,041 $4,365 7,838 $7,83 $7138 $7,838 73,570 $74,082 $71,04 l $82,076 164, 06 $180,877 $177, 92. $174,727 34 SEWER - OPERATIONS FUND: 531 b-454-43 0630 PROGRAM DESCRIPTION It is the responsibility of the Sewer Maintenance Division to operate and maintain the sewer collection and transmission system, Maintenance procedures include jet rodding, flushing, TV inspection, mechanical and chemical cleaning methods as required. FY 2013 BUDGET HIGHLIGHTS Line Item Detail: SANITARY SEWER 218 Equipment- Non Capital - $4,7001Safety Equipment & Supplies S4,800 4,700 - Push. Camera wlSelf Leveling Head 2,000 - Confined Space Tripod 354 Contract Services 421,000 Covers the cost of annual contracts, i.e., U-dig fees, generator testing and maintenance, coveralls, and estimated system repairs. Our maintenance costs have increased clue to the age of some of the pumps and generators. Capital Outlay: from Rates 920 Sanitary Lift Station Enclosure - $6,500 Building structure to protect lift station equipment. Enclosures provide weather protection and covering during winter maintenance activities, as well as reduces heating costs. Covered lift stations protect the equipment and allows maintenance to be performed efficiently and in a safer environment (SEMI-3). 954 Sanitary Liquid Disposal Site - S15,000 This is a structure located near the WWTP which would allow the ity's sewer maintenance jet trucks to discharge the solid and liquid waste collected during sanitary sewer cleaning operations. The liquid waste will be treated in the WWTP. The solids gravel, mud, sticks, debris, etc.) will be removed from the structure and placed with the other solid waste collected at the VAWP for off -site disposal (SEW- ). 960 Manhole & Sewer Main Rehabilitation & Replacement - $15,000 This project would allow for the reconstmction or replacement of sanitary sewer manholes and mains that have deteriorated and are approaching a potential failure. The surer crews continually review and record the function of manholes and mains. During this review, the crews prioritize the potential projects according to the severity of the deterioration SEW-33 . Capital Outlay - Impact Fee funds 101 3) 955 Main & Lift Station Upsize - $245,000 4 ,000 Misc. surer contract main upsi e, and or facility enlargements. $200,000 Regional Lift Station (SEEN- 2). BUDGET ACCOMPLISHMENTS • Operated and maintained 115 rnil r, of gravity sewer mains, 19 miles of sewer force rains and 41 sewage lift stations. • Major repairs included replacing pump at Lift Station #21, rebuilding pumps at Lift Stations #31, 929, rlp2g, 43, replacing motors at lift stations 44, and #24, and reroofing lift station #1 .. i Maintenance included video and inspected 5,000 ft of line, rooted 9,600 ft of lire, and cleaned and flushed 12,000 ft of grease lines. 35 WASTEWATER TREATMENT PLANT FUND: 5310-455-430640 EXPENSE DETAIL ACTUAL BUDGET ACTUAL BUDGET ]FYlfl/11 FYI1/12 FY11/12 FY12/13 Personal Services: FTE's 6.05 5.90 5.90 5.55 110 Salaries & Wages $326,265 $361,807 $324,306 $346,972 III Seasonal Salaries $0 $0 $1,712 $5,000 112 Severance $121160 0 $1,078 $0 121 Overtime $20,292 $21,000 $1 ,522 $21,000 153 Health Insurance $56,957 $65,761 $56,929 $61,570 155 Retirement - PERD $23,199 $22,469 $21,584 $21,473 Total Personal Services $438,873 $471,037 $424,131 $4 6,015 Maintenance & Operations: 210 Office Supplies/equip/computers $2,410 $5,000 $4,283 $5,000 218 Safety Equipment & Supply $3,017 $2,500 $2,797 $2,500 225 Alum $15,368 $30,000 $3,2 3 $2 ,000 226 Chemicals $14,65 M,000 $9,717 $12,000 229 Other Supplies/janitorial/consumable tools/equip rental $6,130 $ ,500 5790 $7,000 231 Gas & Oil $10,527 $11,000 $14,731 $15,000 312 Postage & Shipping $367 $300 $29 $35 336 Licenses and Pees $6,646 101-000 $7,325 $11,000 341 Electricity 342 'water 344 Natural Gas 345 Telephone & Alarms 353 Auditing 354 Contract Services -Glacier Gold 355 Other Contract Services 356 Consultant - Electrical Engineer/& Permit Assistance 357 Impact Fee Study/Review Impact Fees 58 Consultant - T DL 360 Maintenance Service -misc. 66 Building MaintCDance 373 Dues, Training & Training Materials 388 Medical Services 510 Property & Liability Insurance 521 Central Garage Transfer 522 Administrative Transfer 528 Data Processing Transfer Total Maintenance &{operations $15,46 $170,000 $ 1 58,225 $170,000 5,475 $6,500 $5,036,000 $52,717 $55,000 $50,405 $5,000 $4,22 $5,500 $4,851 $5,500 $2,750 $2,750 $2,750 $2,750 $106,814 $123,000 $114,009 $118,000 $34112 38,000 31,26 $30,000 190 $25,000 $5,820 $5,000 $0 0 so $0 $0 $15,000 0 $15,000 12,19 $18,000 $14,373 $28,000 2,053 $2,300 $1,973 $,000 $8,528 $9,100 $5,243 $8,500 $ 06 $550 $196 $ 50 $51,379 $4,500 $41,680 $46,750 $,500 $4,000 $41000 $5,500 105,424 $122,599 $122,598 $126,734 185705 $18,705 $18,705 $20,899 $ 47,003 $735,803 $630,069 $755,033 3 WASTEWATER TREATMENT PLANT FUND: 5310-455-030640 EXPENSE DETAIL ACTUAL BUDGET ACTUAL BUDGET 1 /11 1111 11 1 I2/13 430640 Capital Outlay: Operating Funds 920 Rout' Replacement on Main Building 0 $0 0 $ l 10,000 940 Nitrogen Removal Improvements $0 $30,000 30,42 $0 Total Outlay Funds so $30,000 $307420 $1 I0,000 430644 Capital Outlay: BONDED PROJECT 935 Plant insp ct.F 09110; Design c Constr Digester Ltd $10, 95 $0 $0 $ 65,000 Total WWTP CONSTRUCTION $10, 95 $0 $0 $865,000 430645 WWTP Replacement Fund . V (10125 62 Equipment Maintenance 933 Solids 1 ewat ring Design & Construction 940 Equipment Capital - CARRYOVER Total Replacement Funds 4010 610/620 Debt Service (see debt page) 831 Replacement Reserve -Evergreen Depreciation expense (nary cash) Subtotal WWTP 430646 LABRATORY OPERATIONS TE' Personal Services: 110 Salaries & Wages 153 Health Insurance: 155 Retirement - PERD Total Lab Personal Services 430646 Laboratory Maint. & Operations: 210 Office Supplies/Computers/other supplies/shipping 218 Equipment 222 Lab Supplies 349 Lab services Newly Mandated Pretreatment Testing 62 Equipment Maintenance 373 Dues & Training, licenses Subtotal Laboratory M $57,024 $80,000 $44,065 $70,000 $0 $ $0 $ 607000 $14, 88 $173,5 0 $71,552 $101,948 $71,612 $253,500 $115,617 $731,948 $1,2517S50 $1,246,735 $1,246,735 $1,097,338 411,599 $411,599 $411,599 $411,599 $1,415,855 $1,425,000 $1,425,000 $1,45,000 4,24717 $4,5731674 S492839571 $,851,9 2.0 2.0 2.0 2.0 $11 ,134 $11 ,243 $113, 05 $115,328 $16,505 $18,095 $18,035 $1 ,912 $7,003 $ ,997 $7,0 9 $7,147 $136,642 $13,335 $138279 $141,397 $27309 $2,350 $466 $7,350 $7,20 S37000 $1,696 $3,000 7,347 $9,000 $'77940 $7,500 $14,885 $20,000 $11,264 $20,000 $3,923 $4,00 $4,197 $3,500 $1,811 $2,700 $992 $2,700 81195 415550 $2 ,555 S44,050 TOTAL SEWER TREATIMENT & LAB $4,422,524 417 3� 5 4�44 , 5 $690375,370 3 WASTEWATER TREATMENT PLANT FUND:5310-455-430640 PROGRAM OF SERVICES The Wastewater Treatment Plant Facility is responsible for treatng domestic wastewater to meet the discharge pennit issued by the Montanan Department of Environmental Quality, The treated wastewater is discharged to Ashley Creek in accordance with specific limitations, requirements, and conditions_ Facility Maintenance- 9 buildings, 55 pumps, 1.4 gear reducers, 24 mixers, ers, large & 12 small submersible pumps, 1 scum buster pump, 210 valves of all sizes, 5 air compressors, I electric generator, 2 gas boilers, 4 make-up air units, 8 ventilation fans, 16 electric beaters, 3 air conditioners, 3 gas beaters, 16 sand filters, 5 125 lip air blowers, 17 auto electric valves, 20 flow meters, 15 gas detectors, 4 programmable logic controllers, 2 ultraviolet light disinfection units, 5 clarifiers, 13 bio-cells, 1 equalization tank, 3 digesters, 1 feTmenter tank, 2 dissolved air floatation tanks, 2 belt presses, 15,000 gal. Alum. tank, 2 pickups and 3 sludge trucks. Y 2013 BUDGET HIGHLIGHTS Line Item Detail - Wastewater Treatment Plant 355 Other Contract Services - $30,000 Rag /grit and landfill biosolids disposal fees and other contract services. 356 Consultant- Electrical Engineer &Permit Assistance - $ 5,000 Continue to update the 1992 antiquated computer, control programming for operations of the modernized equipment in the current plant. Ongoing trouble shooting when failures occur in communications and the computer control program. $15,000 for ity's discharge permit renewal work and negotiation assistance with DEQ. 358 Consultants - Total Maximum Daily Load (TT DL) 1 Permit - $15,000 The State of Montana is under Federal Court order to develop a TMDL for pollutants flowing fro€. the Flathead basin into Flathead Labe. These TMDL restrictions have potentially very serious consequences for the CiVs, Historical ability to drains storm waters to Flathead tributaries and its conununity wastewater to Ashley creek. TMDL, that is unreasonably restrictive could greatly impair the ity`s ability to grow and would greatly raise the cost of treating community wastewater and storm water discharges, We Have engaged an experienced consultant to provide assistance to the City for working with MDEQ to develop a satisfactory TMDL This budget item also includes funds for potential legal costs related to the TMDL issue. 60 Maintenance nance Service - 2 000 ,Increase of $10,000 in this line item is offset with a $10,000 decrease in the Kalispell/Evergreen replacement account. Only equipment on the K atispell vergreen replacement list can be charged to that account. More repairs and replacements are occurring for items not on the list. 3044 Capital Outlay -Bonded 935 Digester Lid Design & Construction - $865,000 This project is to replace the failing Primary Digester Lid and mixing equipment. The Primary Digester Lid is bulging in cracked areas which indicate methane gases are being released. The unstable condition of the lid creates safety hazards for the VAVTP Operation Staff' and for surrounding facility. A consultant engineer was hired in, 2011 to perform an analysis and complete the design and bid documents ,for the replacement lid and mixing equipment. The design and bid process is scheduled to be complete in the summer of 2012. Construction is anticipated to start in the fall of 2012. 3 WASTEWATER TREATMENT PLANT FUND: 53I0-455-430640 430645 Capital Outlay - Replacement Funds 933 Solids Dewatering Design & Construction - $ 60,000 The 2008 Facility Plan Update included $1.9 million to update the Solids Dewa erin.g in Phase 3 ofthe AWITP Expansion. The installation of f new screw press is a. portion of the suggested improvements to replace 1 of 2 belt filter press. U Machinery & Equipment Replacement Fund - Carryover $10Y, 4 $101,948 Primary Digester Lid Engineering - CARRYOVER Line Item Detail -,laboratory Operations: 10 Office upplles/Computerslother supplies - $6,850 To assist the Pretreatment Program the Lab will need to purchase a computer program "Arc View O.I.S." which gives the pretreatment coordinator the ability to see all city utilities & view property boundaries &, business owners. OBJECTIVES: WWTP 1. Monitor and adjust the wastewater treatment process to meet the discharge permit; monitor Ashley Creek for flow above the plant and dissolved oxygen agave and below the plant. . Perform a minimum of 6,200 laboratory analyses per year to monitor and control the biological nutrient removal process; perform analyses of specific parameters to meet the discharge pernn.it requirements. . Continue efforts to reduce the inflow into the Plant which occurs during rainfall and snow melt events. 4. Continue work on the Pretreatment Program, to control wastewater duality; monitor the sludge for heavy metals and nutrients to insure that it is acceptable for disposal. 5. Perform work orders approximately 1500 per realer to keep equipment and processes functioning properly; perform equipment repairs and respond to alarms quickly so the treatment process is not interrupted, . Continue public relations (tours and articles) to educate the public on this unique process and the excellent duality of the treated wastewater. 7. Continued optimization of nitrogen removal in the main anoxic is one preceding the new Nitrogen Limits imposed on Januaiy 1, 2012, Y 2012 BUDGET ACCOMPLISHMENTS * Continued fine turfing operations following the Wastewater- Treatment Plant expansion. Expansion increased the plant capacity 7J% from 3.1 MD to 5.4 MOD. • Maintained & corrected equipment information to the new electronic Operations and Maintenance manuals on plant server. • Replaced 1" & 8" plug value in 2nd Digester. Installed backup influent & ef`flucnt flaw monitoring equipment, * Overhauled the B.F.P. sludge conveyor belt, and made repairs to aging Belt Filter Presses. • Contracted with an engineering fli to complete design of the Primary Digester Lid replacement Project. Continued efforts on the Total Maximum Daily Load (Ti MQ development with the Montana State DEQ and U EPA. • Continued Pretreatment Program development & completed Laboratory Quality Assurance plan. Lab proficiency rating 1-- 100% • Purehased a new micro balance for the plant laboratory. • Continued updating S . C .A.D. system to optimize plant operations. Started "Nitrogen Improvement Project" to optimize nitrogen removal in main anoxic zone. • Reduced plant rag & grit disposal costs by using city solid waste department to haul to landfill. 39 ACTUAL BUDGET ACTUAL. BUDGET FYI0/11 FY1I/12 FY11/12 FY12/l3 SANITARY SEWER 490204 Debt Service- 0 4 bonds: (HWY 93 So,) 610 Principal 631000 $66,000 6,0D0 $69,000 20 Interest/fiscal agent fees $42,075 $39,695 $39,694 $ 7, 00 30 Fiscal Agent Fees 00 300 300 Total Debt Service Sanitary Sever S105,075 $105,995 $105,994 $106,500 WASTEWATER TREATMENT PLANT 490210 Debt Service-2002 bonds 10 Principal $230,000 0 so 0 20 Interest 9r430 $0 so 0 30 Fiscal Agent Fees 00 0 0 $0 490215 Debt Servlc -Sl " Loan 1991 10 Principal $ 61,000 $271,000 $2 1700 $140,000 0 Interest 4,300 $13,760 $13,760 $2.800 490227 Debt Service-S F Loan (new construction 610 Principal 151000 $460,000 $460,000 $470,000 620 Interest. $511,820 $501,975 $501,975 $484,538 Total Debt Service WWTP $1,251,850 $120246,735 $1.2461735 $15097,338 Total Sewer Fund Debt Service $1,356,925 $15352,730 $1,352,729 $1,203,838 0 STORM SEWER FUND: 5349-453-43 024& i'R0J]ECTED REVENUE AND FUND SUMMARY BEGINNING CASH ACTUAL FYI0/11 BUDGET FYI1/12 ACTUAL FY11/12 BUDGET FY12/I3 10100 CASH: Operating $9 , 8 $13-205,923 $1,205,923 $1,390,822 10120 Cash, Impact Fees $454,67 $573,50 $573,530 $671,921 10122 Cash, Capital Reserve $140,000 $140,000 $140,000 $140,000 10127 Cash, Emergency Reserve $25,000 $25,000 $25,000 $25,000 10190 Cash, Designated for.Equipment Replacement ment $160,000 $200,000 $200,000 $ l 8,31 10193 Cash, Designated Capital Projects $315, 44 $365,844 $365,844 $415, 44 Adjustments to Cash - A1R, Comp Abs. $1 , 91 Total Cash $2,07 ,589 $2,510,297 $2751O1297 $2,841,90 REVENUES 343370 Storm Assessments -billed 10100 $727,689 $730,000 $732,838 $730,000 Assessments -designated for equipment 10190 40,000 $40,000 $40,000 $40,000 Assessments -designated for capital projects 10193 $50,000 $507000 $501000 $50,000 334040 Petro TankJMon i toryej mburs em ent 1010 $ .1,4 $0 $2,416 $2,415 343035 Pe an it fees & other Charges for Service (10100) $5,003 $1,500 $1,5 0 $420 3040 Penalty & lntcrest 10100 $9,1 $7,500 $5,266 $5,000 371010 Interest 10100 $26P389 $22,000 $27,445 $2,000 343033 Impact Fees 10120 $118,863 $100,000 $9871 $50,000 Impact Fee % Ad in 10100 $6,25 $5,000 $5,037 $2,500 Total Revenue $1,005,48' $95,000 $2,953 $02,35 Total Available $ ,081,075 $ ,46 ,297 $3,473, 5O $3,7441238 EXPENSES EXPE NSES FROM RATES 1010) $570,778 $1,0341.1101 $599, 63 $1,589,775 Capital Outlay -impact fee 10120 $0 $30,000 so $0,000 Capital Equipment - replacement 10190 $45,000 $41,54 $201,500 Depreciation (non -cash. expense) $225,000 $260,000 $260,000 $2 5,000 Total Expenses $795,778 $1, 6971 O1 $ 91334'7 $2,10 ,2 5 acid back depreciation $225,000 $20,000 $260,000 $285100 ENDING CASH 10100 Cash, Operating $1,205,23 $9371.5822 $1,390,822 $563,382 10120 Cash, Impact Fees $ 737530 $ 43,530 $ 71,921 $691,921 10122 Cash, Capital Reserve (target $140,000) $140,000 $1.40,000 $140,000 $140,000 10127 Cash, Emergency Reserve (target $25,000) $25,000 $25,000 $25,000 $25,000 10190 Cash, Designated Equipment Replacement $200,000 $195,000 $198,316 $36, 1 10193 Cash, Designated Capital Projects $365,844 $415,844 $415, 44 $465,844 $2,510, 97 $ .,357,196 $2,841,903 $1,922, 63 $40,000 designated for equipment replacement; $50,000 designated to Capital projects 1 STORM SEWER FUND: 5349-453-430246 EXPENSE SUMMARY ACTUAL BUDGET ACTUAL BUDGET FY10/11 FYI1/12 ............ I FYII/12 FY12/13 Personal Services $409,523 $4412443 $ 73,393 $422,951 Materials and Services $155,955 $1 7,958 $115,12 $198,461 Capital Improvements -rates $ ,300 S404,700 $101,138 $968,363 Total Expenses from Rates $570,778 $1, 34,101 $589,6 3 $1,589,775 Capital Outlay - Impact Fees 1012) $0 $30,000 $0 $30,000 Capital Equipment -Replacement $ 10190 $0 $4500 $41,684 $201,500 Depreciation $2251§000 $2 0,000 $ 60,000 $28 ,000 GRANDTOTAL $795,778 $1,369,101 $891,347 $2,106,275 PROGRAM DESCRIPTION The Storm Sewer Maintenance Division is responsible for the maintenance and operation of the Storm water collection, transmission, detention and disposal facilities of the City of Kalispell. The purpose o this system is to collect and properly dispose of storm water from snow melt, rainfall and other sources without going through the wastewater treatment plant. The division maintains over 34 miles of storm water ;facilities including catch basins, inlet, culverts, storm drains, detention basins and outfalls. Rates 2011-2012 (no change) VACANT T LAND 0.002880 capped at $250,90 RESIDENTIAL I Tl..L PROPERTY 0.005569 capped at $121.29 Non-residential unproved: p to 90% Covered 0.009990 100% Covered 0.01248 4 STORM SEWER FAD: 5349-453-430246 FY 2013 BUDGET FdIGHLYGHTS Line Item Detail: STORM SEWER FUND 356 Storm Water Regulatory Compliance Program/Permit Fees - $30,000 The Stonnwater M 4 Permit requires the City to implement a Stormwater Management Program S fP). The SWMP outlines and defines Best Management Practice (BMPs) and Programs the City will implement and maintain to meet the regulatory requirements. Programs to implement and/or maintain are outlined and require yearly funding, these include 1) Erosion and sediment control annul training, ) Public education and participation handouts and advertising, 3) Strom drain ID decals, 4 Car wash equipment, Good housekeeping BMPs, 7) Site inspection and enforcement for post construction. structural BMPs, 7RedevelopmentWater Quality Implementation Assistance (new 01 )* policy to be developed to provide financial assistance to businesses for smaller redevelopment projects. 430246 Capital Outlay: from rates 101 0 940 Utility Asset Management Program k $38,738 Asset Management Program for Water, Sewer, and Stormwater Utilities, The Asset Management Program works in conjunction with all other IS -centric applications to manage utility assets in the geodatabase. Service requests, work- orders, inspections, and projects are used to track municipal types of work activities with their associated casts, flap layers can be created to display infoanation on each utility. Asset Management Programs involve field workers, call takers, and administration, to get the information they need to perform their jobs efficiently and make wise use of the precious resources entrusted to them to manage their assets as they provide the necessary services. Currently the City of Kalispell manages utilities through historic knowledge and paper trails, making it difficult to assess utility maintenance or replacement needs, cost spending or savings and overall management of the utility system. Asset Management Programs enable el ties to perform conditional utility assessments, tracking, material man ag m nt, work orders, repair tracking, budget planning, data usage in the field, database historical reference, and reports, Costs shared wl ater - Total Cost $7,47 952 Storm Drain Correction R $100,000(Carryover $95,000, New Appropriation ,000 The goal of this project is to provide design and construction for areas in the City that are in need ofstonn drainage systems and storm drainage system upgrades. Some of these areas had old storm sewers draining into the sanitary sewer. Areas in sections of the City that have extensive ponding at the intersection caused from minor rain events. 954 South Meadows Phase I Design & Construction & Phase ff - Carryover $206,125, New Appropriation S500,000 The purpose ofthis proj cot is to relieve compoun d ing drainage issues due to drainage areas (ditches, swales, outfalIs) being eliminated by residential use. This is phase I of a three phase project that when completed will relieve the flooding and ponding in the subdivision. Engineering designs for Phase 1 is scheduled to be complete by June 30, 2012. The project will be hid with schedules and constructed in the summer/fall of 2012 and spring 2013. 43 249 Capital Outlay: $123,500 from rates (10100) and $201,500 from replacement (101.90) 44 Machinery & Equipment - $325,000 $325,000 Vacuum Jet Truck - replacing 19 year old vacuum truck. 3 STORM SEWER FUND: 5349-453-430246 EXPENSE DETAIL ACTUAL BUDGET ACTUAL BUDGET[' FY10/1I ]F'Y11/12 FY11/I2 FY12/I3 Personal Services: 6.4 6.45 6.45 6.20 110 Salaries & Wages $314,949 $333,163 $2 1, 44 $324,215 112 Severance $13,004 $7,000 $12,539 $2,500 121 Overtime $938 $5,000 $1,934 $5,000 153 Health Insurance $59,817 $751239 $59,118 $70,795 155 Retirement $20,915 $21V041 $18,458 $20,441 Subtotal Personal Services $409,523 $441,443 $37,93 $42,951 Maintenance & Operations: 210 Office Supplies/Equip./computer/IS 218 Equipment non capital)/ Safety Equip &, Supplies 229 Other Supplies/Consumable tools 231 Gas & Oil 345 Telephone & Communication 3 Auditing 354 Contract Services 356 Storm water Reg Compliance Program/Permit 357 Facility Plan Phase 11 '08 l Impact Fee Update ' 1 358 Consultants 359 Consultants/TMDL 7 Permit 360 Repair & faint. Services 362 Groundwater Monitoring 371 Curb & Gutter 373 Dues & Training 38 Medical Services 410 Construction materials 510 Liability Ins. ,000; $5,500 uninsured loss) 521 Central Garage Transfer 22 Administrative Transfer 528 Data Processing Transfer 30 Lease Payrnents/BNSF 52 Office rent Subtotal materials & services 952 $9,1 00 $9,746 $9,100 $186 $3,500 $2,321 $3,500 $559 $2,200 21621 $2,200 $8,410 $10,500 $9,320 $10,0 $53 $80 $8 $950 $500 $00 $550 600 $1,517 $6,200 $2,162 $,2.00 $26,638 $20,000 $5,853 $30,0 $0 $8,00 $0 $,000 10,689 $7,000 $0 $7,000 $22,071 $15,000 $51169 $15,000 $2,358 $1,500 $1,117 $1,500 $11,530 $25,000 $6,677 $17,000 $5, 27 $5,000 $ 10 $5,000 3,113 $3,500 $2, 4 $3,500 15 $20 $0 $200 $ 53 $107000 $2,470 $10,000 $7,57 $,50 $12,307 $1,500 $2,500 $2,500 $2,500 $3,000 31,957 $30,376 $30,376 $32,704 $,344 $5,344 $5,44 $,9 5,018 $5,200 $4,902 $5,200 $7,838 $7,838 $7,838 $7,938 $1 5, 55 $187,958 $11 ,132 $198,461 44 430246 Capital Outlay: From rates (10100 941 Utility Asset Management Program 944 Vacuum Jet Truck - 3 8 % 952 Storm Drain Correction funds 954 South Meadows Phase 1 Desi l onstr_ & Phase 11 Subtotal Capital from rates 430248 Capital Outlay: Impact Fee (1 12 960 Stormwater Facility Dpsizing Subtotal from Impact fee funds 43049 Capital Outlay; from replacement 10190 944 'Vacuum Jet Truck - 62% 10400 Depreciation: 31 Depreciation: TOTAL Storm Sewer ACTUAL BUDGET ACTUAL BUDGET LJY10111 I FYI1/12 I FYI1/12 FY12/13 9161 $0 $0 $0 $3,73 $0 so $0 $123,500 $0 $ 1 00,000 $2,3 $100,0 $5,30 $304,700 $9,575 $706,125 . . ... .......... - $5,300 $404,700 $101,138 $968,363 $ $307000 $0 $30, 00 0 $30,000 $0 $3,000 $0 $45,000 $4104 $2 1, 500 $0 $45,000 $41,64 $201,500 $225,000 $260,000 $260,000 $2 5,000 $795,778 $1,3697101 $ 91,347 $2710 ,275 SOLID WASTE FUND: 5 5 I 0-460-43 0840;43 0845 PROJECTED REVENUE AND FUND SUMMARY ACTUAL BUDGET ACTUAL BUDGET FY1U/11 FY11/12 FYI 1/12 FYI2/13 BEGINNING CASH 10100 CASH: operating $275,3 $40,30 $400,30 $573,37 10120 *Replacement Account $135,624 $235, 4 $2351624 $130,240 Total Cash 411,47 $3,254 63,54 $703,616 REVENUES 343360 misc. $0 17790 0 343410 Assessments s800,1 2 $ 0 ,00 111610 $ 43,000 343420 garbage collections billed (part year) $0 0 $29,688 $15,000 363040 Penalty & Interest $5,451 $3,500 $7,875 $5,5 0 371010 Interest Ea€-nings $4,413 $3,500 53242 $5100 Change in AIR, Comp. Abs. $1,131 $ $2,274 $0 Total Revenue $793, 95 $815,000 $ 95,579 $868,500 Total Available $11215,3 2 $1,451,254 $1, 31, 33 $1,572,11 EXPENSES Total Expenses From Rates (10100) $569,128 $71 ,4 9 $597, 33 $ 95, 27 Capital Outlay -replacement 10120 $0 $220,000 $230,314 $45,000 *Depreciation/ eplacement Frond $1001.1000 $125, 00 $125,000 $150,000 'fatal Expenses $669,128 $1,061,4 9 $953,217 $890, 27 add back transfer to replacement account $100,000 $125,000 $125 NO $150,000 ENDING CASH 10100 Operating $400,30 $3741141 S5731376 $596,249 10120 *Replacement Account $2 57624 $1407624 13072.40 235724 Total Cash $66,254 $514,765 $703,16 $531,49 FY 12113 - Increased designated replacement from $15,000 10 $150,000. 46 SOLID WASTE FUND: 5 5 I 0-460-43 Q 840;43 0845 EXPENSE SUMMARY ACTUAL BUDGET ACTUAL BUDGET FYI 0/11 FYII/12 FYI 1/12 FY12/13 Personal Services $39 , 53 $460,9 3 $3 9, 131 $ S 1,42 Materials and Services $173, 75 $215,526 $208,702 $214,205 Capital Outlay $0,00 $ 0 Total M & 0 from Rates $569,128 $71,48 $597,833 $695,627 Capital Outlay from Replacement Funds $0 220:000 $2307384 $4 ;00O Depreciation Expense (non -cash) $10 ,0 0 $125,000 1250 $15000 $669,128 $1,0 1,4 9 $953,217 $890,627 PROGRAM DESCRIPTION The Solid Waste Operating Division is responsible for the collection, conveyance, and disposal of all refuse accumulated within the city in an efficient and sanitary manner. The City currently collects refuse from 5,958 residential and commercial accounts. The garbage rates. sidenti l: S111.00peryear Non -Residential: 300 Gal. 350 Gal 400 Gal. Current Current Current DUMPSTER Pick up Mates Rates Rates I Weekly $338.00 $375.00 $411.00 2 Weekly $558.00 $631.00 $704.00 Weekly $828.00 $938.00 $1,047.00 47 SOLID WASTE FUND: SS I0-460-43fl840;430$45 EXPENSE IDETAIL ACTUAL BUDGET ACTUAL BUDGET I+Y10/1I FY11/12 FY11/12 FY12/13 110 Salaries & Wages $303,958 $351,409 $303,309 $355,936 112 Severance $4,789 $5,500 5,940 $12,500 121 Overtime/Call outs 27802 7,500 $2,059 $5,000 153 Health Insurance $64,477 $74,749 $58,483 $85,902 155 Retirement - P l $19,627 $21,805 $19,339 $22,0 4 Total Personal Services $395,653 $460,963 $3 9,131 $481,422 Materials and Services: 213 Office Equip/ computer equip & supplies $2,424 $3,500 $2,566 $3,500 218 Non Capital quip.- Garbage Containers ,$12,212 $20,000 $331082 $20NO 229 Other Supplies/Safety equip/Consumable tool $4,196 5,500 $1,614 $5,500 231 Gas and Oil $41,466 $50,X0 $4 ,953 $5 ,000 341 Electricity 176 1 $1,700 $1,328 $1,700 44 Natural Gas $3,304 $4,000 $3,570 $4,000 345 Telephone 424 70 $678 $700 354 Contract Services $3,373 $12,000 $7,531 $12,000 62 Equipment Malnt. & Supplies/radios $5, 75 $5,7 0 $4,1 8 $5,700 366 Building Maintenance 11437 $2,500 $3,099 $2,50 373 Dues & Training 449 $2,500 $3,338 $2,500 38 Medical services 313 $500 51 $500 510 Property & Liability Ins. $10,008 $12, 00 10,036 $12,500 12 Uninsured Loss - Deductible $0 6,500 $230 $6,500 521 Central Garage Transfer $26,000 $267000 $26,000 $2 ,500 522 Administrative Transfer $29,995 $29,835 $29,835 $27,73 528 Data processing Transfer $9,353 $9,35 9,353 7,614 532 Office Rent $7,838 $7,838 $7,838 $7,83 Total M & 0 $160,148 $200,626 $193,829 $199,35 430845 Wash bay/Materials & Services 224 Janitorial Supplies 41 Electricity 342 Water 344 Natural Gas 360 Repair & Maint Services/building main# $6 $30 $200 $3,261 $,200 $3,366 3,20 491 $50 $759 500 $,870 $8,500 $8,911 $,500 37 $2,500 $1,87 $2,00 13,327 $14,900 S14,873 $14,900 SOLID WASTE FUND: 551 Q-460-430840;430845 EXPENSE DETAIL ACTUAL BUDGET ACTUAL BUDGET FYIO/11 FYI 1/12 FYI l/12 FY12/13 430840 Capital Outlay: 110 from rates 944 Garbage Truck 1 % $0 $4000 so $0 $0 $40,000 $0 $0 430840 Capital Outlay: Replacement funds 101 0 940 Machinery & Equipment $0 0 0 $45,000 944 Garbage Truck 85% $ . 0,000 $ 30, 84 0 Subtotal Capital Outlay $0,000 $30,84 $45,000 1040 Depreciation (.fund Replacement account $1,000 831 Depreciation expense $100,000 $15,000 $15,000 $150,00 Total SolidWaste 9,1 8 $1.01,489 $953,217 $ 90, '7 FY 23 BUDGET HIGHLIGHTS Dine Item Detail : Solid Waste Fund Replacement Funds 101 0 940 11 aebinery & Equipment - $45,000 4 ,000 - 3/4 Ton 4x4 Pickup w/Plow & Sander Y 2012 BUDGET ACCOMPLISHMENTS * Notified residents in Ashley Park and Stratford Village subdivision of their eligibility for City Garbage Service, resulting in numerous responses from, the area requesting City service. * Added Kalispell School District to our commercial route. * P€ rehased a Sidearm Garbage Truck. * Continued to restructure routes in an effort to limit trips to the county landfill, improve customer service, and lover costs. 4