Loading...
06. Public WorksPage No. Fund No. 1 1000 Public Works Administration $ 29,058 3 1000 Central Garage $ 544,946 5 2400 Light Maintenance $ 387,536 8 2420 Gas Tax $ 723,055 11 2500 Special Street Maintenance $ 2,387,465 18 2825 MACI Grant -sweepers $ 574,373 19 4290 Sidewalk & Curb Construction $ 25,000 20 5210 Water Fund $ 4,826,921 30 5310 Sewer Operating/Wastewater Treatment $ 8,060,614 40 5349 Storm Sewer $ 2,100,150 45 5510 Solid Waste $ 890,627 Total Public Works $ 20,549,745 PERSONNEL SCHEDULES: 49 Admin., Central Garage & Light Maintenance 50 Street Maintenance and Traffic Sign & Signal 51 Water and billing 52 Sewer Operations & billing 53 Waste Water Treatment Plant & Lab 54 Storm Sewer & Solid Waste GENERAL011 1 1 11 Personal Services Materials & Services ACTUAL ACTUAL BUDGET BUDGET FY09/10 FY10/11 FY11/12 FY12/13 $13,114 $22,436 $24,313 $22,833 $3,288 $2,636 $4,125 $6,225 $16,402 $25,072 $28,438 $29,058 The responsibility of the Public Works Administration/Engineering Department is the design, construction, maintenance, and administration of the City's infrastructure. These areas include streets, curb, sidewalks, traffic signals, signage, water production and distribution, storm water drainage, sewage collection, wastewater treatment, and equipment maintenance. Line Item Detail:PUBLIC WORKS 210 Office Supplies, Equip., and Other Supplies Increased line item for (1) additional file for record engineering drawings. I"10-111��T ill' ■lLs Provided administrative and support services for management of Water, 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 costs. • 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. • Trained 42 city employees as part of the Pollution Prevention Good Housekeeping Program for Municipal Activities and Facilities. • Contributed to the drafting, writing, and collection of information for Public Works for the City's new website. • Prepared and submitted a completed grant application to the Montana Department of Emergency Services for the installation of two (2) backup power supply generators for the water production division. • Continue to monitor the SIA bonds, and warranty and maintenance bonds to ensure compliance. • Collaborated in the development and implementation of the 2012 Montana Stormwater Conference. • Gave a presentation at the MAGIP 2012 Intermountain GIS Conference on the City's GPS/GIS work. 1 PUBLIC OR O4� I ' i 11 i 1 11 Personal Services: 110 Salaries and payroll costs 112 Severance 153 Health Insurance 155 Retirement Total Personal Services Materials & Services: 210 Office Supplies, equip, and other supplies 345 Telephone & Communications 354 Contract Services (temp) 373 Dues & Training Subtotal TOTAL ACTUAL ACTUAL BUDGET BUDGET FY09/10 FY10/11 FY11/12 FY12/13 0.15 0.25 0.25 0.25 $10,787 $16,656 $17,430 $17,740 $1,832 $2,000 $0 $1,630 $2,858 $3,755 $3,845 $697 $1,090 $1,128 $1,248 $13,114 $22,436 $24,313 $22,833 $2,208 $2,096 $2,025 $4,025 $29 $78 $200 $200 $122 $195 $750 $850 $929 $267 $1,150 $1,150 $3,288 $2,636 $4,125 $6,225 $16,402 $25,072 $28,438 $29,058 K GENERALPUBLIC WORKS -CENTRAL GARAGE 111 1 i Personal Services Maintenance & Operations Capital Outlay ACTUAL ACTUAL BUDGET BUDGET FY09/10 FY10/11 FY11/12 FY12/13 $166,972 $197,891 $192,947 $195,243 $299,844 $329,198 $340,900 $349,703 $466,816 $527,089 $533,847 $544,946 The Central Garage is responsible for maintaining all city vehicles and equipment in a safe and dependable condition at the lowest cost 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 229 Equipment (Non Capital), Safety Equip., Other Supplies - $10,603 Increased $4,053 for Truck Tire Service Jacks. Current air jack has been rebuilt twice and still loses air and creeps down, frame on the other jack is bent. $1,000 for a lathe milling drilling machine combo. 362 Equipment Maint. 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 room 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 2012 ACCOMPLISHMENTS • Provided passenger vehicle and equipment repair and maintenance services for 273 equipment items for emergency services, park maint., 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 be contracted out. 3 FUND:PUBLIC WORKS -CENTRAL GARAGE iil ! i Personal Services: FTE'S 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 232 Motor Vehicle Parts 233 Tires 238 Filters 241 Consumable Tools, Books 341 Electricity 344 Natural Gas 354 Contract Services -Repairs 362 Equipment Maint., Radios, Building Maint. 373 Dues & Training 388 Medical Services Total M&O Capital Outlay 920 Building Remodel Total Capital Outlay TOTALBUDGET ACTUAL ACTUAL BUDGET BUDGET FY09/10 FY10/11 FY11/12 FY12/13 3 3 3 3 $131,615 $153,787 $150,825 $152,379 $5,379 $0 $0 $1,642 $2,072 $1,700 $2,000 $25,464 $26,662 $31,170 $31,516 $8251 $9,991 $9,252 $9,348 $166,972 $197,891 $192,947 $195,243 $273 $1,043 $3,300 $1,200 $8,910 $6,988 $6,850 $10,603 $110,140 $146,874 $153,500 $156,500 $78,639 $91,461 $92,000 $93,000 $22,307 $35,494 $30,600 $32,075 $3,714 $6,053 $6,200 $6,700 $890 $279 $2,550 $1,500 $1,637 $1,616 $1,700 $1,700 $6,388 $7,156 $7,600 $7,400 $65,553 $30,189 $33,900 $35,000 $1,008 $1,740 $1,450 $2,550 $255 $180 $900 $1,200 $130 $125 $350 $275 $299,844 $329,198 $340,900 $349,703 $466,816 $527,089 $533,847 $544,946 4 LIGHT MAINTENANCE FUND: 2400-410430263 BEGINNING CASH 10100 CASH: REVENUES 363010 Maintenance Assessments 363040 Penalty & Interest 364030 Misc. 381050 Inception of Loan 371010 Interest Earnings TOTAL AVAILABLE EXPENDITURES Street Lighting ENDING CASH 10100 CASH: Estimated ACTUAL BUDGET ACTUAL BUDGET FY10/11 FY11/12 FY11/12 FY12/13 $139,865 $150,829 $150,829 $188,529 $230,848 $230,000 $235,000 $236,000 $2,073 $1,500 $1,500 $1,500 $3,440 $o $0 $0 $115,000 $1,366 $1,200 $1,200 $1,200 $237,727 $232,700 $237,700 $353,700 $377,592 $383,529 $388,529 $542,229 $226,763 $262,722 $200,000 $387,536 $150,829 $120,807 $188,529 $154,693 5 LIGHT MAINTENANCE FUND: 2400-410-430263 1 ' U- ACTUAL ACTUAL BUDGET BUDGET FY09/10 FY10/11 FY11/12 FY12/13 Personal Services $33,207 $45,633 $50,144 $50,980 Materials and Services $170,810 $181,130 $212,578 $208,838 Capital Outlay $115,000 Debt Service $14,341 $0 $0 $12,718 $218,358 $226,763 $262,722 $387,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) 940 Machinery & Equipment - $115,000 Replacing 18 yr old boom trick. Current boom truck is not able to reach all of the City's luminary lights. New boom height will enable crew to reach all of the City owned lights. FY 2012 BUDGET ACCOMPLISHMENTS MENTS • Reballasted over head luminaries on Center St. to meet dark sky ordinance. 2 LIGHT MAINTENANCE FUND: 2400-410-43 02 63 ACTUAL ACTUAL BUDGET BUDGET FY09/10 FY10/11 FY11/12 FY12/13 Personal Services: FTE 0.60 0.80 0.75 0.75 110 Salaries $25,456 $33,512 $38,477 $38,893 112 Salaries - Severance $1,836 $0 $0 153 Health insurance $6,171 $8,140 $9,295 $9,696 155 Retirement $1,580 $2,145 $2,372 $2,391 Total Personal Services $33,207 $45,633 $50,144 $50,980 Materials and Services: 244 Lighting Supplies $6,780 $17,756 $13,000 $16,000 341 Electricity $145,426 $149,746 $163,000 $163,000 360 Repair & Maint Services $10,927 $5,532 $28,000 $20,000 510 Insurance $0 $975 $975 $1,075 522 Administrative Transfer $7,677 $7,121 $7,603 $8,763 Total M & S $170,810 $181,130 $212,578 $208,838 Capital Outlay 940 Boom Truck $115,000 Total Capital Outlay $115,000 Debt Service: loan repayment Principal -5 year -final pyint 2018 $14,000 $0 $0 $12,000 Interest-1.25%V $341 $0 $0 $718 Total Debt $14,341 $0 $0 $12,718 Total $218,358 $226,763 $262,722 $387,536 7 GAS TAX FUND: 2420-421-430240 BEGINNING CASH 10100 CASH REVENUE 335040 Gas Tax Apportionment 371010 Interest Total Revenue TOTAL AVAILABLE EXPENDITURES Street Department ENDING CASH CASH Estimated ACTUAL BUDGET ACTUAL BUDGET FY10/11 FY11/12 FY11/12 FY12/13 $310,011 $344,885 $344,885 $445,713 $366,904 $5,150 $366,904 $4,000 $366,904 $4,000 $366,904 $4,000 $372,054 $370,904 $370,904 $370,904 $682,065 $715,789 $715,789 $816,617 $337,180 $602,682 $270,076 $723,055 $344,885 $113,107 $445,713 $93,562 Section 15-70-101 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-balf 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. 0 GASTAX FUND: 2420-421430240 ACTUAL ACTUAL BUDGET BUDGET FY09/10 FY10/11 FY11/12 FY12/13 Materials and Services $407,070 $273,738 $522,682 $641,555 Capital Outlay $55,365 $63,442 $80,000 $81,500 $462,435 $337,180 S602,682 $723,055 Funds received from Gas Tax 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 management information system. FY 2013 BUDGET HIGHLIGHTS Line Item Detail: 354 Contract Services/Striping City Streets - $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 $35,000 $36,500 - To be used for a matching program to assist homeowners with replacing bad sidewalks. 957 Alley Paving - $45,000 Pave approximately 10-12 alleys a year and overlay existing alleys with remaining funds. FY 2012 BUDGET ACCOMPLISHMENTS e 50150 Sidewalk Replacement Program - A total of 18 residents participated in the program, replacing 5.2 blocks. • Paved 10 alleys. e 2011 Chipseal Project = Chip Sealed 93 blocks 61 FUND: 2420421-430240 ACTUAL ACTUAL BUDGET BUDGET FY09/10 FY10/11 FY11/12 FY12/13 430240 Materials and Services -Streets 231 Gas & Oil $22,224 $37,220 $35,000 $38,000 344 Natural Gas $6,817 $2,962 $3,500 $3,500 354 Contract Services -striping $50,337 $2,486 $247,575 $300,400 360 Contract Services/Snow remove & Constr. Support $1,772 $0 $15,500 $7,500 368 Overlays & Chipseals $250,000 $162,593 $132,407 $201,455 369 Radio Maintenance $0 $0 $700 $700 452 Gravel $308 $0 $3,000 $3,000 453 Materials -Contract Preparation $1,245 $71 $5,000 $3,000 471 De-Icer/Road Oil $37,935 $46,479 $45,000 $47,000 472 Asphalt $32,019 $21,927 $30,000 $30,000 473 Crack Sealing Material $4,413 $0 $5,000 $7,000 Total Materials & Services Streets $407,070 $273,738 $522,682 $641,555 430234 Sidewalks / Alleys: 956 Sidewalk Construction $30,035 $31,253 $35,000 $36,500 957 Alley Paving $25,330 $32,189 $45,000 $45,000 Total Capital $55,365 $63,442 $80,000 $81,500 Total $462,435 $337,180 $602,682 $723,055 Carryover Projects Total $303,355 10 SPECIAL STREET MAINTENANCE FUND:ii 40 Estimated ACTUAL BUDGET ACTUAL BUDGET FY10/11 FY11/12 FY11/12 FY12/13 BEGINNING CASH 10100 CASH: Operating $679,029 $767,070 $767,070 $812,225 10120 Cash, Transportation impact Fees* $65,088 $103,535 $103,535 $0 10107 Cash, Designated Equip. Replacement ** $36,974 $15,474 $15,474 $36,799 10108 Cash, Designated S & C repair *** $44,936 $47,517 $47,517 $47,517 10109 Cash, Designated Pavement Replacement **** $178,908 $170,753 $170,753 $250,753 Total Cash $1,004,935 $1,104,349 $1,104,349 $1,147,294 VENUE 343010 Transportation impact fees* $42,739 $40,000 $36,918 $0 343011 Sidewalk repair penalty*** $2,581 $0 $0 $0 343012 Public Works Charges $6,874 $3,000 $500 $1,000 363010 Maintenance Assessments $1,460,394 $1,435,000 $1,435,000 $1,420,000 -designated for pavement replacement **** $280,000 $280,000 $280,000 $280,000 -designated for equipment replacement ** $35,000 $35,000 $35,000 $35,000 363040 Penalty & Interest $21,255 $12,500 $12,500 $12,500 364030 Sale ofMisc./auction $2,649 $1,200 $3,528 $1,200 371010 Investment $9,608 $7,000 $9,000 $9,000 381050 Inception of Loan $0 $172,000 $172,000 $195,000 Total Revenue $1,861,100 $1,985,700 $1,984,446 $1,953,700 Total Available $2,866,035 $3,090,049 $3,088,795 $3,100,994 EXPENDITURES Street Department/TSS $1,415,944 $1,726,023 $1,583,754 $1,826,424 Capital Equip. Replacement ** $56,500 $10,000 $13,675 $0 S & C Repair funds *** $0 $31,041 $0 $31,041 Refund Transportation impact Fees $0 $144,072 $144,072 $0 Pavement Replacement program **** $288,155 $450,000 $200,000 $530,000 Total Expenditures $1,760,599 $2,361,136 $1,941,501 $2,387,465 ENDING CASH 10100 Cash, OPERATING $763,865 $671,747 $812,225 $624,501 10120 Cash, Transportation Impact Fees* $107,827 $143,535 $0 $0 10107 Cash, Designated Equip. Replacement ** $15,474 $40,474 $36,799 $71,799 10108 Cash, Designated S & C repair *** $47,517 $16,476 $47,517 $16,476 10109 Cash, Designated Pavement Replacement **** $170,753 $753 $250,753 $753 Total Cash $1,105,436 $872,985 $1,147,294 $713,529 * Adding $35,000 per year to equipment replacement ** $280,000 pavement replacement annually (appropriated) 11 SPECIAL STREET MAINTENANCE FUND: 25 00-421-430240 1 "' M, \ "1 ll ll Personal Services Materials and Services Debt Service Transportation Impact Fee Reimbursement Capital Outlay from assessments TOTAL EXPENDITURES FOR OPERATIONS Pavement Replacement Funds **** Equipment Replacement Funds ** Sidewalk & Curb Repair Funds *** ACTUAL ACTUAL BUDGET BUDGET FY09/10 FY10/11 FY11/12 FY12/13 $877,329 $958,420 $991,685 $987,761 $376,758 $440,978 $484,584 $510,390 $17,430 $16,546 $37,754 $58,273 $0 $0 $144,072 $0 $29,563 $0 $212,000 $270,000 $1,301,080 $1,415,944 $1,870,095 $1,826,424 5407,080 $288,155 $450,000 $530,000 $70,177 $56,500 $I0,000 $0 $6,296 $0 $31,041 $31,041 $1,784,633 $1,760,599 $2,361,136 $2,387,465 Special Street Maintenance funds will be primarily used for street sweeping, flushing, leaf pick-up, sanding, deicing, snow plowing and snow removal. The overall goal is to maintain all city streets in a clean, 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 signage 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 .012220 90% non-residential .01803 residential .012220 100% commercial .01900 12 FUND:SPECIAL STREET MAINTENANCE !1 1 i Line Item Detail: Street Division 218 Equipment - Non Capital - $8,000 / Safety Equipment & Supplies $2,200 $4,500 - Sweep Pickup Broom attachment for Skid Steer $3,500 - Jumping Jack Compactor 366 Building Maintenance - $4,000 Increase to fix leaking roof on the Street Equipment building. Capital Outlay: Operating Funds (10100) 840 MACI Grant Match-$75,000 - operating transfer to MACI grant The State is once again proposing to provide local governments the opportunity to purchase air quality management equipment, like street sweepers, through the Montana Air & Congestion Initiative (MACI). The City is proposing to purchase one new Flush truck (Cab & Chassis truck w/3,000 gallon tank w/under 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 trick which is very poor condition. Capital Outlay: Pavement Replacement (10109) 935 Pavement Maintenance funds - $530,000 Carryover $250,000, New Appropriation $280,000 GASB 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. Costs to replace existing pavements and street reconstruction are now clearly separate from those related to growth -related costs funded by impact fees. 940 Machinery & Equipment - $195,000 Capital Outlay: (Financed 5 yr) $45,000 - Leaf Machine $150,000 - (2) Used Single Axle Dump Trucks Debt Service: Board of Investment loans 610 $53,900 Principal 620 $4,373Interest Street Division • Street Division maintained 148.3 miles of streets and alleys. • Purchased an asphalt roller and dump and plow truck. • City Street crew paved eight overlay projects. 13 SPECIAL STREET MAINTENANCE FUND: 2500-421430240 Line Item Detail: Traffic Signs & Signals 243 Traffic Signals - $33,500 (increased $23,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. This 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. $4,500 - Continue program to install LED countdown pedestrian crosswalk heads. $10,000 - Misc maintenance/repairs/replacement parts, etc. Traffic Signs & Signals • Implemented FEC rebate program and updated lighting fixtures throughout City of Kalispell maintenance shops. • Installed countdown LED PED's throughout half of the City of Kalispell's traffic signals (other half of town scheduled for next FY). • Completed yellow LED signal lamp changes on all of City of Kalispell's traffic signals. 14 SPECIAL STREET MAINTENANCE I 11 i 41 STREET DIVISION Personal Services: FTE's 110 Salaries and payroll costs 112 Severance (L. Hogan) 121 Overtime 153 Health Insurance 155 Retirement Total Personal Services Materials and Services: 210 Computer Equipment/Software/Supplies 218 Equipment /safety equipment & supplies 220 Other supplies, Janitorial, consumable tools 231 Gas & Oil 341 Electric 345 Telephone 354 Contract Services 355 Transportation Traffic Reviews 357 Rate Study 358 Impact Fee Study 362 Equipment Maint. parts & supplies, includes radios 366 Building Maint. 373 Dues & Training 388 Medical services/drug test 510 Property & Liability Insurance $4,575 / $74,225 512 Uninsured Loss -deductible 521 Central Garage Transfer 522 Administrative Transfer 528 Data Processing Transfer Subtotal M & O 610/620 Debt Service -Principal & Interest 720 Transportation Impact Fee Reimbursement ACTUAL ACTUAL BUDGET BUDGET FY09/10 FY10/11 FY11/12 FY12/13 12.30 12.65 12.35 12.25 $537,563 $559,204 $583,985 $570,667 $4,588 $6,485 $8,500 $25,000 $19,808 $23,703 $30,000 $30,000 $107,860 $128,370 $155,620 $157,384 $34,921 $36,145 $36,388 $35,393 $704,740 $753,907 $814,493 $818,444 $2,876 $4,031 $5,000 $5,000 $2,251 $2,173 $2,200 $10,200 $3,884 $4,127 $3,900 $4,100 $22,776 $37,587 $40,000 $42,000 $1,222 $1,842 $1,400 $1,400 $954 $959 $1,000 $1,000 $8,933 $15,313 $12,500 $15,000 $127 $77 $5,000 $0 $16,034 $0 $8,000 $0 $0 $0 $14,000 $0 $29,101 $27,738 $28,000 $28,000 $1,163 $1,509 $1,500 $4,000 $1,081 $700 $2,500 $3,500 $1,602 $787 $1,100 $1,100 $65,037 $82,919 $85,000 $87,000 $2,096 $5,182 $10,000 $10,000 $63,000 $66,000 $66,000 $70,000 $50,339 $56,741 $64,707 $67,420 $11,145 $10,689 $10,689 $12,182 $283,621 $318,374 $362,496 $361,902 $17,430 $16,546 $37,754 $58,273 $0 $0 $144,072 $0 15 SPECIAL STREET MAINTENANCE FUND: 2500-421-430240 EXPENDITURE DETAIL-c®n'te Capital Outlay: 840 MACI Grant Match 940 Machinery & Equipment (offset with inception of loan) Subtotal capital outlay 430244 354 Pavement Maintenance funds 430245 Replacement Funds: 940 Machinery & Equipment Subtotal Replacement 430248 Sidewalk & Curb Repair 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 ACTUAL BUDGET BUDGET FY09/10 FY10/11 FY11/12 FY12/13 $29,563 $0 $40,000 $75,000 $0 $0 $172,000 $195,000 $29,563 $0 $212,000 $270,000 $407,080 $288,155 $450,000 $530,000 $70,177 $56,500 $10,000 $0 $70,177 $56,500 $10,000 $0 $6,296 $0 $31,041 $31,041 $1,518,907 $1,433,482 $2,061,856 $2,069,660 2.5 2.5 2.5 2.5 $137,547 $146,839 $140,306 $132,645 $0 $22,708 $0 $0 $9,025 $8,105 $8,500 $9,500 $16,971 $15,870 $19,524 $18,270 $9,046 $10,991 $8,862 $8,902 $172,589 $204,513 $177,192 $169,317 $257 $569 $1,500 $1,500 $4,306 $8,437 $8,600 $4,500 $2,471 $3,311 $2,250 $3,500 $39,252 $47,499 $40,000 $44,000 $1,656 $8,730 $10,000 $33,500 $4,646 $2,708 $4,500 $4,700 $7,888 $6,969 $9,000 $8,500 $719 $708 $700 $750 16 SPECIAL STREET MAINTENANCE FUND: 2500421-430240; 430264 ACTUAL ACTUAL BUDGET BUDGET FY09/10 FY10/11 FY11/12 FY12/13 Maintenance & Operations: Cont. 354 Contract Services $5,963 $22,173 $10,000 $15,000 362 Equipment Maintenance Parts, includes radios $1,898 $3,196 $2,500 $3,000 366 Building Maintenance $1,275 $1,551 $1,500 $2,000 373 School & Travel $1,434 $2,218 $2,500 $4,000 428 Paint Materials $6,412 $964 $15,000 $9,000 510 Property & Liability Insurance $841/$2908 $5,205 S3,674 $3,700 $4,200 512 Uninsured Loss -deductible property $1,917 $2,059 $2,500 $2,500 532 Office Rent $7,838 $7,838 $7,838 $7,838 Subtotal M&O $93,137 $122,604 $122,088 $148,488 Total Traffic Sign & Signals $265,726 $327,117 $299,280 $317,805 Grand Total - STREETS & SIGNS $1,784,633 $1,760,599 $2,361,136 $2,387,465 17 MT. AIR & CONGESTION GRANT FUND: 2825... STREET .... 421....FUNCTION.... 430240 BEGINNING CASH CASH: Operating REVENUES 331055 MACI Grant for Sweepers/Flush Trks 383012 Transfer from Street Maintenance (match) FY 11/12 Sweeper CARRYOVER FY 12/13 Flush Truck/Sweeper Total Revenue TOTAL AVAILABLE EXPENDITURES 940 CAPITAL EQUIPMENT - ENDING CASH CASH: Operating ESTIMATED ACTUAL BUDGET ACTUAL. BUDGET FY09/10 FY11/12 FY11/12 FY12/13 $0 $0 $0 $40,000 $150,917 $160,000 $0 $459,373 $29,563 $40,000 $40,000 $0 $75,000 $180,480 $200,000 $40,000 $534,373 $180,480 $200,000 $40,000 $574,373 $180,480 $200,000 $0 $574,373 The MACI grant is a program to help solve Air Quality problems. $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 waiting for the sweeper budgeted in FY 11/12 and carried over $40,000 in matching funds. A new appropriation of $75,000 is for FY 12/13 MACI grant request for a new Flush Truck with a 3,000 gallon tank and underbody plow, and another new 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. Total est. cost of Flush Truck $155,000. FY12 Sweeper $204,373; FYI est. cost of Sweeper $215,000. 18 SIDEWALK & CURB CONSTRUCTION FUND: 4290-410-430234-937 PROJECTED REVENUE AND FUND SUMMARY BEGINNING CASH 10100 CASH: REVENUES 381004 Proceeds S &C Warrants Total Revenue TOTAL AVAILABLE EXPENDITURES 937 Sidewalk Construction Costs ENDING CASH 10100 CASH: Estimated ACTUAL BUDGET ACTUAL BUDGET FY10/11 FY11/12 FY11/12 FY12/13 $0 $o $o $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 $o $o $o $0 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 WATER FUND (Operations FUND: 5 210-447-43 05 5 0 PROJECTED Estimated ACTUAL BUDGET ACTUAL BUDGET FY10/11 FY11/12 FY11/12 FY12/13 BEGINNING CASH 10100 Operating Cash $2,485,858 $2,321,299 $2,321,299 $2,486,401 10120 Impact Fee Cash $778,004 $448,354 $448,354 $516,354 10125 Meter Replacement Cash $240,800 $266,434 $266,434 $261,434 10107 Capital & Emergency Reserve -target $400,000 $310,000 $340,000 $340,000 $370,000 10130 Bond Reserves (restricted cash) $515,449 $515,449 $515,449 $515,449 Adj. to Cash/ A/R/Comp. Abs. ($5,093) $2,102 $4,325,018 $3,891,536 $3,893,638 $4,149,638 REVENUES 343210 Metered Water Sales (billed) (10100) $2,156,834 $2,203,000 $2,300,000 $2,600,000 343230 Meter Replacement Fee (10125) $96,167 $95,000 $95,000 $95,000 343225 Impact Fees (10120) (adj for receivable- $4,094) $230,724 $225,000 $225,000 $225,000 343365 ImpactfeeAdmin (10100) $25,896 $13,000 $13,000 $13,000 343260 Misc.-Installation/Reconnect/Tag fees (10100) $65,508 $40,000 $40,000 $40,000 371010 Interest Earnings (10100) $44,635 $45,000 $40,000 $40,000 Interest Earnings - Impact Fee Cash (10120) $10,719 $10,000 $10,000 $10,000 Total Revenue $2,630,483 $2,631,000 $2,723,000 $3,023,000 Total Available $6,955,501 $6,522,536 $6,616,638 $7,172,638 EXPENSES EXPENSES FROM RATES $2,422,339 $3,230,759 $2,200,000 $3,592,421 Expenses from Meter cash (10125) $71,118 $100,000 $100,000 $136,500 Capital Outlay - from Impact Fees (10120) $471,093 $161,000 $67,000 $158,000 Debt Service -from Impact Fees (10120) $100,000 $100,000 $100,000 $100,000 Depreciation $825,000 $825,000 $840,000 $840,000 Total All Departments $3,889,550 $4,416,759 $3,307,000 $4,826,921 add back depreciation $825,000 $825,000 $840,000 $840,000 ENDING CASH 10100 Operating Cash $2,321,299 $1,361,540 $2,486,401 $1,556,980 10120 Impact Fee Cash $448,354 $422,354 $516,354 $493,354 10125 Meter Replacement Cash $266,434 $261,434 $261,434 $219,934 10107 Capital & Emergency Reserve -target $400,000 $340,000 $370,000 $370,000 $400,000 10130 Bond Reserves (restricted cash) $515,449 $515,449 $515,449 $515,449 Total cash $3,891,536 $2,930,777 $4,149,638 $3,185,717 *Capital & Emergency reserve funded $30,000 from operations 10100. Target will be met 2013. 20 WATER FUND SUMMARY FUND: 5310-454-430620-630/455-430640 ACTUAL ACTUAL BUDGET BUDGET FY09/10 FY10/11 FY11/12 FY12/13_ Personal Services: Water billing $114,906 $111,182 $132,702 $110,766 Water Operations $872,840 $872,930 $865,767 $924,405 Total PERSONAL SERVICES $987,746 $984,112 $998,469 $1,035,171 Maintenance & Operations: Water Billing services $72,191 $72,617 $75,840 $84,306 Water Operations $573,840 $642,612 $736,164 $726,985 Total M & 0 from rates $646,031 $715,229 $812,004 $811,291 Capital Outlay from rates: Water Operations $397,775 $311,786 $1,104,800 $1,394,900 Total CAPITAL from rates $397,775 $311,786 $1,104,800 $1,394,900 Debt Service from rates: Water $411,115 $411,212 $315,486 $351,059 Total DEBT from rates $411,115 $411212 $315,486 $351,059 TOTAL EXPENSES FROM RATES $2,442,667 $2,422,339 $3,230,759 $3,592,421 Capital Outlay- Meter Replacement funds:(I 0125) $72,542 $71,118 $100,000 $136,500 Capital Outlay - from Impact Fee funds: (10120) $54,739 $471,093 $161,000 $158,000 Debt Service -from Impact Fees: (10120) $100,000 $100,000 $100,000 $100,000 Depreciation (non -cash item) $700,000 $825,000 $825,000 $840,000 Grand Total $3,369,948 $3,889,550 $4,416,759 $4,826,921 21 FUND: 5210-447-430550/5 60 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 five wells 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. Line Item Detail: Water Fund 226 Chlorine & Chemical - $33,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 (Rates) 935 Armory Well Generator Replacement - CARRYOVER $90,000 $90,000 - This project would replace the 1920's generator at the Armory Well site. The existing generator has a failing injector pump and parts 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 Armory 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 derno and repair, landscaping removal and installation, the crane and equipment to remove and install the generator, and the licensed electrician required for electrical connection. Armory Well Replacement Generator Construction Bids are due on April 26, 2012. 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-EX-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. During 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 replacing 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 75% of the replacement cost (W-EX-160). 22 FUND: 5210-447-43 05 50/5 60 Line Item Detail: continued Capital Outlay: Operating Funds (Rates) Cont. 937 Sheepherder Tank Backup Power - $16,000 Provide backup power for the SCADA system at Sheepherder Reservoir. Currently there is no backup power at Sheepherder Reservoir. Power frequently goes out at this location, when the power is out the water level in the tank is unknown 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-EX-161). 938 Lower 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 of the roof structure (W-EX-158). 940 Machinery & Equipment - $70,000 $10,000 - Hydraulic Submersible Pump $60,000 - Valve Maintenance Trailer 941 Utility Asset Management Program - $34,000 Asset Management Program for Water, Sewer, and Stormwater Utilities. The Asset Management Program works in conjunction with all other GIS-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 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 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 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/Storm - Total Cost $72,476 (W-EX-159) 951 SCADA System Upgrade/Improvements - CARRYOVER $10,000 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 City's water operations. The transducers were selected and ordered in April of 2012. Once received the follow-up installation and programming will be complete in the late summer of 2012 (W-EX-155). 23 FUND: 5210-447-43 05 50/5 60 Line Item Detail: continued Capital Outlay: Operating Funds (Rates) Cont. 958 Loop Project - CARRYOVER $165,000 $165,000 - First Avenue NE - north of Arizona east 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 (W-EX-30). Engineering plans and bid packets are scheduled to be complete by May of 2012. The project is 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 by 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 fire flows up to 630 to 1100 gpm. Fire code requires fire flows to maintain 1,000 gpm for residential areas and 1,500 gpm for commercial areas (W-EX-24). 963 Abandon 2" Water Line - CARRYOVER $45,000 Abandon 2" 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" water main on 2nd Ave WN between Washington St and California St. The project would install 800' of 8" C900 water main and appurtenances on the east side of 2nd Ave WN, reconnect services and fire hydrants, and includes pavement repair (W-EX-154) . 965 East Arizona Pipe Up -Size - CARRYOVER $195,000 Replace 2" and 4" pipe in E. Arizona and 1 st Avenue EN 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 8" C900 water main and appurtenances including pavement repair (W-EX-132). 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 drawdown and feasible pumping rates. The project also includes the time and materials necessary to prepare a water right change application (W-EX-147). 24 FUND: 5 210-447-4305 50/560 Line Item Detail: continued Capital Outlay - Meter funds (010125) 948 Meters - $130,000 Replacing approximately (400) residential and (25) commercial meters. Meter Pits - $6,500 411 $6,500 - Includes materials cost to purchase (10) 3/4" meter pits to install in residents where access to meter is unavailable. * Operated and maintained 132 miles of water mains, 4 water storage tanks, and 10 water wells. * Completed the 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 FY. * Completed the South Woodland Dr. 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 baekflow prevention assemblies located in city owned facilities. * Purchased new I ton service truck for water production. * Repaired 28 leaking water mains, and service lines saving approximately 125 gallons per minute in unbilled water. m Conducted 240 bacteriological water samples. Samples are taken at strategic locations throughout the city. Additionally all 240 samples were absent for bacteria and no violations were issued by Montana DEQ. * Performed 8 new service line taps and installations and 3 new water main taps for fire suppression. * Repaired in excess of 50 water service shut-off valves to aid operators during after hours call outs. * Continued ongoing fire hydrant replacement, and flushing program. 3 aging fire hydrants were replaced, and 137 hydrants were flushed to remove air, and clean dead -ends. No WATER OPERATIONS 5210-447430550 Personal Services: FTE's 110 Salaries & Wages III Seasonal Salaries 112 Severance 121 Overtime/Call Outs 153 Health Insurance 155 Retirement - PERD Total Personal Services Maintenance & Operations: 210 Office Supplies/Equip/Computers/ GIS 218 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 353 Auditing 354 Contract Services 356 Consultants -Water Rights Acquisition / Water Modeling 357 Facility Plan /Rate Study /Impact Review 362 Repair & Maint./Equip. maint./radios/equip rental 366 Building Maintenance 373 Dues & Training 388 Medical/Drug Testing 410 Construction Materials 422 Hydrants 423 Materials - Mains 424 Materials - Service lines 425 Materials - Wells/Pumps 510 Property & Liability Ins. $9,840/ 23,353 512 Uninsured Loss -Deductible & Goodwill Expenditures ACTUAL ACTUAL BUDGET BUDGET FY09/10 FY10/11 FY11/12 FY12/13 13.95 19.60 13.25 12.90 $684,980 $665,155 $648,785 $664,243 $1,770 $5,000 $11,897 $7,000 $35,000 $17,695 $25,564 $20,000 $20,000 $126,546 $126,031 $146,924 $155,841 $43,619 $44,283 $41,289 $44,321 $872,840 $872,930 $865,767 $924,405 $9,737 $6,415 $12,450 $10,000 $7,339 $16,649 $19,500 $9,500 $23,896 $27,104 $38,000 $38,000 $4,799 $2,571 $4,800 $4,800 $19,303 $31,480 $29,000 $35,000 $4,524 $3,698 $4,500 $4,500 $16,477 $15,299 $19,000 $19,000 $137,459 $121,103 $143,000 $143,000 $9,644 $12,984 $13,000 $13,000 $8,003 $7,095 $8,000 $8,000 $20,069 $19,290 $25,500 $22,500 $3,000 $2,550 $3,000 $3,000 $32,861 $41,618 $70,000 $55,000 $10,754 $26,378 $25,000 $25,000 $9,400 $3,921 $0 $6,500 $3,235 $10,108 $14,950 $14,950 $5,486 $11,832 $17,000 $17,000 $5,925 $10,309 $7,200 $9,200 $635 $673 $700 $700 $24,238 $37,452 $30,000 $32,000 $2,560 $3,057 $15,000 $10,000 $5,179 $8,117 $11,000 $11,000 $6,163 $8,301 $9,000 $11,000 $25,925 $24,008 $36,000 $30,000 $37,905 $33,829 $34,500 $36,500 $11,933 $26,669 $19,000 $24,000 26 WATER OPERATIONS 5210-447430550 I ACTUAL ACTUAL BUDGET BUDGET FY09/10 FY10/11 FY11/12 FY12/13 Maintenance & Operations -continued: 521 Central Garage Transfer $8,50C 522 Administrative Transfer $90,15( 528 Data Processing Transfer $20,89-1 532 Office rent $7,838 Total Maintenance & Operations $573,840 490200 Debt Service- ALL BONDS & LOANS: 610/620 Principal, Interest, fiscal fees $511,115 CAPITAL OUTLAY Capital Outlay: Operating funds (RATES) 935 Armory Well Generator 936 Noffsinger Spring Generator 937 Sheepherder Reservoir SCADA Back-up Power 938 Lower Zone Reservoir Improvements 940 Equipment $45,001 941 Utility Asset Management Program $0 950 11 th St E Water Main (fy 11) $69,818 951 Security Upgrades FYI I/ SCADA Upgrades FY 12 (carryover) 954 US 93 S. Bypass Relocation $219,169 956 Upper Zone/Lower Zone Interconnection $31,402 958 Loop Projects (carryover) $0 962 Kelly Rd to Woodland Ave $32,385 963 Abandon 2" water line (carryover) 964 2nd Ave WN Waterline Replacement (carryover) 965 East Arizona Pipe Up -Size (canyover) Subtotal capital from operating ftmd $397,775 430555 Capital Outlay -impact Fee Funds (010120) 941 Meters $54,739 930 Contract Main Upsize (Impact fee inv. Acct) 953 Develop Water Supply for Section 36 Well Subtotal capital from Impact Investment fees $54,739 430550 Settlement from Impact Fees (10120) 358 Owl Corporation $0 $7,500 $8,000 $8,000 $94,723 $91,185 $96,825 $20,041 $20,041 $21,172 $7,838 $7,838 $7,838 $642,612 $736,164 $726,985 $511,212 $415,486 $451,059 $o $90,000 $90,000 $90,000 $16,000 $120,000 $106,232 $45,000 $70,000 $0 $0 $34,000 $167,942 $0 $31,286 $40,000 $10,000 $o $0 $6,326 $30,000 $o $0 $411,800 $165,000 $0 $311,900 $45,000 $45,000 $248,000 $248,000 $195,000 $195,000 S311,786 $1,104,800 $1,394,900 $65,000 $65,000 $65,000 $o $50,000 $50,000 $92,626 $46,000 $43,000 $157,626 $161,000 $158,000 $313,467 $0 $0 27 WATER OPERATIONS 5210-447-430550 ............ . ACTUAL ACTUAL BUDGET BUDGET FY09/10 FY10/11 FY11/12 FY12/13 Capital Outlay: 430550 Capital Outlay -Meter Funds (010125) 411 Meter Pit - Materials $6,500 944 Meter Maintenance Vehicle $0 $0 $25,000 $0 948 Meters -Replacement S subtotal $72,542 $71,118 $75,000 $130,000 $72,542 $71,118 $100,000 $136,500 510400 Depreciation 831 Depreciation expense Total Water Facilities 430560 WATER BILLING Personal Services: FTE's 110 Salaries & Wages 112 Severance 153 Health Insurance 155 PERD Total Personal Services Maintenance & Operations: 210 Office Supplies/computers 353 Auditing 354 Contract Services 355 Postage/Other Billing Costs 373 Dues & Training 522 Administrative Transfer 528 Data Processing Transfer 532 Office rent Total Maintenance & Operations $700,000 $825,000 $825,000 $840,000 $3,182,851 $3,705,751 $4,208,217 $4,631,849 2 2 2 2 $91,233 $85,302 $89,596 $82,942 $12,000 $0 $17,934 $20,305 $25,283 $22,343 $5,739 $5,575 $5,823 $5,481 $114,906 $111,182 $132,702 $110,766 $275 $495 $3,225 $3,000 $1,875 $1,500 $1,500 $1,500 $3,847 $3,566 $5,000 $4,000 $28,373 $29,953 $27,775 $35,000 $913 $1,046 $1,500 $1,500 $6,173 $6,178 $6,961 $7,103 $22,897 $22,041 $22,041 $24,365 $7,838 $7,838 $7,838 $7,838 $72,191 $72,617 $75,840 $84,306 Total Water Billing $187,097 $183,799 $208,542 $195,072 GRAND TOTAL WATER FUND $3,369,948 $3,889,550 $4,416,759 $4,8265921 28 WATERFUND 5210447-49OXXX ACTUAL ACTUAL BUDGET BUDGET FY09/10 FY10/11 FY11/12 FY12/13 17 91 ► : T]►i 1ky 490250 Debt Service-2001 WRF Loan - 4% (Main & Idaho Project) 610 Principal $36,000 $38,000 $39,000 S41,000 620 Interest $20,320 $18,860 $17,340 $15,520 490204 Debt Service-2004 Revenue Bond:( includes Refunding 1996)(Hwy 93 S) 610 Principal $140,000 $145,000 $55,000 $55,000 620 Interest $51,533 $46,630 $41,195 $38,995 630 Fiscal Agent Fees $300 $300 $300 $300 490206 Debt Service-2007 WRF loan 3.75% A Refunding BOI loans meters & hydrants 610 Principal $151,000 $157,000 $163,000 $169,000 620 Interest $35,627 $30,262 $24,319 $17,150 490206 Debt Service-2007 WRF loan 3.75% B Water Reservoir project 610 Principal $22,000 $22,000 $23,000 $63,000 620 Interest $54,335 $53,160 $52,332 $51,094 Subtotal Operations $511,115 $511,212 $415,486 $451,059 WE EWER- TREATMENT 1 FY10/11 FY11/12 FY11/12 BEGINNING CASH 10100 Operating $519,622 $102,822 $102,822 10123 SANITARY Sewer Impact Fee Inv. Account $1,623,691 $1,752,917 $1,752,917 10124 WWTP Impact Fee Inv. Account $447,048 $398,388 $398,388 10125 WWTP Equipment Rep]/Evergreen $328,970 $664,597 $664,597 1013x Bond Reserves/ Operating reserve $1,584,162 $1,561,162 $1,522,469 Adjmts to Cash (comp abs., receivables, bond reserve) ($104,468) $38,693 REVENUES 343310 SEWER SERVICE -billed (10100) 343360 Misc. ; (10100) 343330 Impact Fee/Hookup-Sanitary (10123) 343330 Admin Impact Fees Sanitary (10100) 343335 Impact Fee/Hookup-WWTP (10124) 343335 Admin Impact Fees WWTP (10100) Bonded Debt 371010 Interest -operations (10100) Interest-WWTP/Evergreen (10125) Interest-WWTP Impact Fee Acet. (10124) Interest -Sanitary Impact Fee Invest. Acct. (10123) Total Revenue Total Available EXPENSES EXPENSES FROM RATES Capital Outlay City/Evergreen Funds (10125) Capital Outlay / Bonded Debt Capital Outlay - from Impact Fee funds: Capital from impact fee funds Sanitary (10123) Debt Service From Impact fees: Portion ofdebt from impact Sanitary (10123) Portion of debt from impact WWTP (10124) Depreciation (non cash expense) Total Expenses Add depreciation to cash Add cash distribution to Evergreen/City 10125 from 10100 ENDING CASH 10100 Operating 10123 * SANITARY Impact Fee Inv. Account 10124 *** WWTP Impact Fee Inv. Account 10125 ** WWTP Equipment Replacement/Evergreen 1013x Bond Reserves (restricted funds) $315,556 $1,831,967 $294,788 $892,246 $1,522,469 $4,399,025 REVENUES 343310 SEWER SERVICE -billed (10100) 343360 Misc. ; (10100) 343330 Impact Fee/Hookup-Sanitary (10123) 343330 Admin Impact Fees Sanitary (10100) 343335 Impact Fee/Hookup-WWTP (10124) 343335 Admin Impact Fees WWTP (10100) Bonded Debt 371010 Interest -operations (10100) Interest-WWTP/Evergreen (10125) Interest-WWTP Impact Fee Acet. (10124) Interest -Sanitary Impact Fee Invest. Acct. (10123) Total Revenue Total Available EXPENSES EXPENSES FROM RATES Capital Outlay City/Evergreen Funds (10125) Capital Outlay / Bonded Debt Capital Outlay - from Impact Fee funds: Capital from impact fee funds Sanitary (10123) Debt Service From Impact fees: Portion ofdebt from impact Sanitary (10123) Portion of debt from impact WWTP (10124) Depreciation (non cash expense) Total Expenses Add depreciation to cash Add cash distribution to Evergreen/City 10125 from 10100 ENDING CASH 10100 Operating 10123 * SANITARY Impact Fee Inv. Account 10124 *** WWTP Impact Fee Inv. Account 10125 ** WWTP Equipment Replacement/Evergreen 1013x Bond Reserves (restricted funds) $315,556 $1,831,967 $294,788 $892,246 $1,522,469 $4,399,025 Interest -Sanitary Impact Fee Invest. Acct. (10123) Total Revenue Total Available EXPENSES EXPENSES FROM RATES Capital Outlay City/Evergreen Funds (10125) Capital Outlay / Bonded Debt Capital Outlay - from Impact Fee funds: Capital from impact fee funds Sanitary (10123) Debt Service From Impact fees: Portion ofdebt from impact Sanitary (10123) Portion of debt from impact WWTP (10124) Depreciation (non cash expense) Total Expenses Add depreciation to cash Add cash distribution to Evergreen/City 10125 from 10100 ENDING CASH 10100 Operating 10123 * SANITARY Impact Fee Inv. Account 10124 *** WWTP Impact Fee Inv. Account 10125 ** WWTP Equipment Replacement/Evergreen 1013x Bond Reserves (restricted funds) $315,556 $1,831,967 $294,788 $892,246 $1,522,469 $4,399,025 $4,479,886 $4,479,886 $4,857,026 $3,274,532 $3,730,000 $3,750,000 $4,115,000 $24,408 $2,000 $18,000 $2,000 $140,629 $112,854 $87,400 $87,400 $6,927 $5,643 $4,600 $4,600 $170,791 $150,642 $117,800 $117,800 $8,749 $7,500 $6,200 $6,200 $865,000 $24,376 $30,000 $20,700 $20,700 $6,535 $6,250 $4,050 $4,050 $5,549 $5,750 $3,600 $3,600 $21,625 $23,000 $16,650 $16,650 $3,684,121 $4,073,639 $4,029,000 $5,243,000 $8,083,146 $8,553,525 $8,508,886 $10,100,026 $3,674,324 $3,833,159 $3,625,459 $3,786,614 $82,507 $253,500 $188,000 $669,000 $865,000 $8,028 $45,000 $0 $245,000 $25,000 $25,000 $25,000 $25,000 $225,000 $225,000 $225,000 $225,000 $2,215,855 $2,240,000 $2,245,000 $2,245,000 $6,230,714 $6,621,659 $6,308,459 $8,060,614 $2,215,855 $2,240,000 $2,245,000 $2,245,000 $411,599 $411,599 $411,599 S411,599 $102,822 $44,806 $315,556 $677,441 $1,752,917 $1,818,771 $1,831,967 $1,666,017 $398,388 $329,780 $294,788 $191,188 $664,597 $828,946 $892,246 $638,895 $1,561,162 $1,561,162 $1,522,469 $1,522,470 $4,479,886 $4,583,465 S4,857,026 $4,696,011 Budget to fund debt service with Impact fee charges for $250,000 ( wwtp $225,000; sanitary $25,000); bond reserve lowered $23,000 30 SEWER - WWTP - BILLING FUND SUMMARY FUND: 5310-454-430620-630/455-430640 ACTUAL ACTUAL BUDGET I BUDGET FY09/10 FY10/11 FY11/12 FY12/13 Personal Services: Sewerbilling $83,159 $91,336 $106,795 $92,651 Sanitary Sewer $452,412 $365,900 $347,797 $312,344 WWTP & LAB $637,449 $575,515 $609,372 $597,402 Total PERSONAL SERVICES $1,173,020 $1,032,751 $1,063,964 $1,002,396 Maintenance & Operations: Sewer Billing services $75,764 $73,570 $74,082 $82,076 Sanitary Sewer $294,853 $364,281 $373,431 $391,122 WWTP &Lab $696,718 $685,198 $777,353 $799,083 Total M & O from rates $1,067,335 $1,123,049 $1,224,866 $1,272,281 Capital Outlay from rates: Sanitary Sewer Operation $183,105 $0 $0 $36,500 WWTP &Lab $0 $0 $30,000 $110,000 Total CAPITAL from rates $183,105 $0 $30,000 $146,500 Debt Service from rates: Sanitary Sewer $80,700 $80,075 $80,995 $81,500 WWTP $1,024,268 $1,026,850 S1,021,735 $872,338 Total DEBT from rates $1,104,968 $1,106,925 $1,102,730 $953,838 City/Evergreen Replacement funded from rates: $419,375 $411,599 $411,599 $411,599 TOTAL EXPENSES FROM RATES $3,947,803 $3,674,324 $3,833,159 $3,786,614 Capital Outlay - Other funds: WWTP Bonded Debt $19,815 $0 $0 $865,000 WWTP (10125) City/Evergreen account $484,268 $82,507 $253,500 $669,000 Capital Outlay - from Impact Fee funds: SanitarySewer (10123) $553,710 $8,028 $45,000 $245,000 WWTP (10124) $119,090 $0 $0 $0 Debt Service -from Impact Fees SanitarySewer (10123) $25,000 $25,000 $25,000 $25,000 WWTP (10124) $225,000 $225,000 $225,000 $225,000 Depreciation (non -cash item) Sanitary $813,425 $800,000 $819,586 $820,000 WWTP $1,424,368 $1,415,855 $1,425,000 $1,425,000 Grand Total $7,612,479 $6,230,714 $6,626,245 $8,060,614 31 SEWER - OPERATIONS 5310-454430630 a01011113V11111A _10 ACTUAL ACTUAL BUDGET BUDGET FY09/10 FY10/11 FY11/12 FY12/13 Personal Services: FTE's 6.9 6.95 6.05 5.50 110 Salaries & Wages $356,535 $257,425 $255,962 $233,868 112 Severance $25,843 $5,000 $2,500 121 Overtime $8,334 $5,930 $7,500 $7,500 153 Health Insurance $64,763 $57,509 $62,496 $53,882 155 Retirement - PERD $22,780 $19,193 $16,839 $14,593 Total Personal Services $452,412 $365,900 $347,797 $312,344 Maintenance & Operations: 210 Office Supplies/equip/ computer supplies/GIS $5,226 $3,035 $6,200 $6,200 218 Equipment (Non Capital)/Safety equip & supplies $3,488 $6,160 $8,500 $9,500 229 Other Supplies/Janitorial/consumable tools $2,320 $1,826 $2,300 $2,000 231 Gas & Oil $8,200 $9,216 $9,500 $9,500 312 Postage & Shipping / Printing $148 S480 $300 $300 341 Electricity $39,987 $46,918 $43,175 $48,500 344 Natural Gas $12,984 $13,014 $13,000 $13,500 345 Telephone & Comm., alarms $21,676 $21,392 $21,700 $21,700 353 Auditing $2,000 $2,000 $2,000 $2,000 354 Contract Services $19,588 $28,743 $26,000 $21,000 356 Consultants $8,930 $77 $7,500 $7,500 357 Impact Fee Study/Review Impact Fees $2,268 $3,921 $0 $6,500 362 Equipment Maintenance/buildings & radios $4,833 $6,787 $6,800 $6,800 373 Dues & Training, licenses $2,514 $1,600 $2,500 $2,500 388 Medical Services $811 $841 $850 $800 410 Construction Materials $6,121 $1,974 $9,000 $9,000 425 Materials - Pumps/Lift Stations $7,936 $32,873 $15,000 $20,000 510 Property & Liability Ins $5,900/$59,155 $25,027 $50,621 $67,000 $73,700 512 Uninsured loss/goodwill expenditures $16,692 $18,813 $18,000 $16,000 521 Central Garage Transfer $3,000 $2,500 $2,500 $2,500 522 Administrative Transfer $54,771 $63,374 $63,571 $61,533 528 Data Processing Transfer $15,325 $14,697 $14,697 $16,751 532 Office Rent $7,838 $7,838 $7,838 $7,838 535 Usage charge for 100,000 gallons-Tmmble Creek $23,170 $25,581 $25,500 $25,500 Total Maintenance & Operations $294,853 $364,281 $373,431 $391,122 SEWER - OPERATIONS & Billinl! FUND:5310-454-430630 EXPENDITURE DET'AIL ACTUAL ACTUAL BUDGET BUDGET FY09/10 FY10/11 FY011/12 FY12/13 Capital Outlay: from rates 920 Install Lift Station Enclosure $6,500 954 US 93 S. Bypass'FY 10; Sanitary Liquid Disposal Site'FY 13 $183,105 $0 $0 $15,000 960 Manhole Rehabilitation /Sewer Main Replacements $19,815 $0 $0 $15,000 Total Capital Outlay $202,920 $0 $0 $36,500 430635 Capital Outlay -Impact Fee funds (10123) 955 Main & Lift Station Upsize $0 $0 $45,000 $245,000 957 Grandview Pump Sta./gravity main $553,710 $8,028 $0 $0 Total Capital from Impact fee funds $553,710 $8,028 $45,000 $245,000 610 Debt Service -Principal, Interest, fiscal agent fees $105,700 $105,075 $105,995 $106,500 510400 831 Depreciation expense $813,425 $800,000 $819,586 $820,000 Total Sanitary Sewer Budget $2,423,020 $1,643,284 $1,691,809 $1,911,466 430620 SEWER 1BLLIM; FTE's 1.5 1.5 1.5 1.5 110 Salaries & Wages $65,223 $72,179 $73,305 $67,647 112 Severance $12,000 $0 153 Health Insurance $13,608 $14,616 $16,805 $20,675 155 Retirement - PERD $4,328 $4,541 $4,685 $4,329 Total Personal Services Materials and Services: 215 Office supplies/computers 353 Auditing and other contract services 355 Billing Costs/postage 373 Dues & Training 522 Administrative transfer 528 Data Processing 532 Office Rent Total Materials and Services $83,159 $91,336 $106,795 $92,651 $339 $583 $2,225 $3,000 $2,952 $2,097 $4,000 $4,000 $33,877 $32,870 $30,775 $35,000 $977 $907 $1,400 $1,500 $6,884 $7,234 $5,803 $6,373 $22,897 $22,041 $22,041 $24,365 $7,838 $7,838 $7,838 $7,838 $75,764 $73,570 $74,082 $82,076 Total Billing Budget $158,923 $164,906 $180,877 $174,727 33 FUND: 5310-45443063 0 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. Line Item Detail: SANITARY SEWER 218 Equipment - Non Capital - $4,700 / Safety Equipment & Supplies $4,800 $4,700 - Push Camera w/Self Leveling Head $2,000 - Confined Space Tripod 354 Contract Services-$21,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 due 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 (SEW-63). 954 Sanitary Liquid Disposal Site - $15,000 This is a structure located near the WWTP which would allow the City'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 WWTP for off -site disposal (SEW-59). 960 Manhole & Sewer Main Rehabilitation & Replacement - $15,000 This project would allow for the reconstruction or replacement of sanitary sewer manholes and mains that have deteriorated and are approaching a potential failure. The sewer 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 (10123) 955 Main & Lift Station Upsize - $245,000 $245,000 Regional Lift Station (SEW-52). • Operated and maintained 115 miles of gravity sewer mains, 19 miles of sewer force mains and 41 sewage lift stations. • Major repairs included replacing pump at Lift Station #21, rebuilding pumps at Lift Stations #31, #29, #28, #3, replacing motors at lift stations #4, and #24, and reroofing lift station #16.. • Maintenance included video and inspected 5,000 It of line, rooted 9,600 ft of line, and cleaned and flushed 12,000 ft of grease lines. 34 ASTEWATER TREATMENT PLANJ / 41 Personal Services: FTE's 110 Salaries & Wages III Seasonal Salaries 112 Severance 121 Overtime 153 Health Insurance 155 Retirement - PERD Total Personal Services Maintenance & Operations: 210 Office Supplies/equip/computers 218 Safety Equipment & Supply 225 Alum 226 Chemicals 229 Other Supplies/janitorial/consumable tools/equip rental 231 Gas & Oil 312 Postage & Shipping 336 Licenses and Fees 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 358 Consultant -TMDL 360 Maintenance Service -misc. 366 Building Maintenance 373 Dues, Training & Training Materials 388 Medical Services 510 Property & Liability Insurance $32,492 / 9,182 521 Central Garage Transfer 522 Administrative Transfer 528 Data Processing Transfer Total Maintenance & Operations ACTUAL ACTUAL BUDGET BUDGET FY09/10 FY10/11 FY011/12 FY012/13 7.2 6.05 5.90 5.55 $373,817 $326,265 $361,807 $346,972 $5,000 $12,160 $0 $0 $20,877 $20292 $21,000 $21,000 $64,914 $56,957 $65,761 $61,570 $24,874 $23,199 $22,469 $21,473 $484,482 $438,873 $471,037 $456,015 $3,560 $2,410 $5,000 $5,000 $1,714 $3,017 $2,500 $2,500 $20,156 $15,368 $30,000 $25,000 $7,738 $14,659 $12,000 $12,000 $5,533 $6,130 $6,500 $7,000 $12,545 $10,527 $11,000 $15,000 $231 $367 $300 $350 $6,703 $6,646 $10,000 $11,000 $168,619 $159,496 $170,000 $170,000 $5,344 $5,475 $6,500 $6,000 $50,002 $52,717 $55,000 $55,000 $5,179 $4,292 $5,500 $5,500 $2,750 $2,750 $2,750 $2,750 $128,712 $106,814 $123,000 $118,000 $36,164 $34,162 $38,000 $30,000 $13,674 $19,609 $25,000 $35,000 $8,930 $0 $0 $0 $1,075 $0 $15,000 $15,000 $7,042 $12,169 $18,000 $28,000 $2,246 $2,053 $2,300 $3,000 $5,689 $8,528 $9,100 $8,500 $482 $806 $550 $550 $46,941 $51,379 $42,500 $46,750 $4,000 $3,500 $4,000 $5,500 $95,228 $105,424 $122,598 $126,734 $19,504 $18,705 $18,705 $20,899 $659,761 $647,003 $735,803 $755,033 35 WASTEWATER TREATMENT PLANFj i < i.4 i 430640 Capital Outlay: Operating Funds 920 Roof Replacement on Main Building 940 Nitrogen Removal Improvements Total Outlay Funds 430644 Capital Outlay: BONDED PROJECT 933 WWTP -eng, constrAmpact fee (10124) 935 Plant inspeet.FY 09/10; Design & Constr Digester Lid Total WWTP CONSTRUCTION 430645 WWTP Replacement Funds:Evg (10125) ACTUAL ACTUAL BUDGET BUDGET FY09/10 FY10/11 FY011/12 FY012/13 $110,000 $0 $0 $30,000 $0 $0 $0 $30,000 $110,000 $119,090 $0 $0 $400,000 $10,895 $0 $865,000 $519,090 $10,895 $0 $865,000 362 Equipment Maintenance $57,901 $57,024 $80,000 $70,000 933 Solids Dewatering Design & Construction $560,000 940 Machinery & Equipment Capital - CARRYOVER $26,367 $14,588 $173,500 $39,000 Total Replacement Funds $84,268 $71,612 $253,500 $669,000 490210 610/620 Debt Service (see debt page) 831 Replacement Reserve -Evergreen Depreciation expense (non cash) Subtotal WWTP 430646 LABRATORY OPERATIONS FTE's 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 362 Equipment Maintenance 373 Dues & Training, licenses Subtotal Laboratory M & O $1,249,268 $1251,850 $1246,735 $1,097,338 $419,375 $1,424,368 $411,599 $1,415,855 $411,599 $1,425,000 $411,599 $1,425,000 $4,840,612 $4,247,687 $4,573,674 $5,788,985 2.2 2.0 2.0 2.0 $127,328 $113,134 $113,243 $115,328 $17,702 $16,505 $18,095 $18,912 $7,937 $7,003 $6,997 $7,147 $152,967 $136,642 $138,335 $141,387 $98 $2,309 $2,350 $7,350 $7,597 $7,920 $3,000 $3,000 $8,211 $7,347 $9,000 $7,500 $16,315 $14,885 $20,000 $20,000 $1,742 $3,923 $4,500 $3,500 $2,994 $1,811 $2,700 $2 700 $36,957 $38,195 $41,550 $44,050 TOTAL SEWER TREATMENT & LAB $5,030,536 $4,422,524 $4,753,559 $5,974,422 36 FUND: 5310-4 5 5-43 0640 The Wastewater Treatment Plant Facility is responsible for treating domestic wastewater to meet the discharge permit issued by the Montana 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, 14 gear reducers, 24 mixers, 6 large & 12 small submersible pumps, I 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 heaters, 3 air conditioners, 3 gas heaters, 16 sand filters, (5) 125 hp 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, I equalization tank, 3 digesters, I fermenter tank, 2 dissolved air floatation tanks, 2 belt presses, 15,000 gal. Alum tank, 2 pickups and 3 sludge trucks. FY 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 - $35,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 City's discharge permit renewal work and negotiation assistance with DEQ. 358 Consultants -Total Maximum Daily Load (TMDL) / Permit - $15,000 The State of Montana is under Federal Court order to develop a TMDL for pollutants flowing from the Flathead basin into Flathead Lake. These TMDL restrictions have potentially very serious consequences for the City's historical ability to drain storm waters to Flathead tributaries and its community wastewater to Ashley creek. A TMDL that is unreasonably restrictive could greatly impair the City'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. 360 Maintenance Service - $28,000 Increase of $10,000 in this line itern is offset with a $10,000 decrease in the Kalispell/Evergreen replacement account. Only equipment on the Kalispell/Evergreen replacement list can be charged to that account. More repairs and replacements are occurring for items not on the list. 430644 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 W WTP Operation Staffand 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 sununer of 2012. Construction is anticipated to start in the fall of 2012. 37 WASTEWATER TREATMENT PLAN i • 0..0 430645 Capital Outlay - Replacement Funds 933 Solids Dewatering Design & Construction - $560,000 The 2008 Facility Plan Update included $1.9 million to update the Solids Dewatering in Phase 3 ofthe AW WTP Expansion. The installation of 1 new screw press is a portion ofthe suggested improvements to replace 1 of2 belt filter press. 940 Machinery & Equipment Replacement Fund - Carryover $39,000 $39,000 Primary Digester Lid Engineering - CARRYOVER Line Item Detail -Laboratory Operations: 210 Office Supplies/Computers/other supplies - $6,850 To assist the Pretreatment Program the Lab will need to purchase a computer program "Arc View G.IS." which gives the Pretreatment coordinator the ability to see all city utilities & view properly boundaries & business owners. OBJECTIVES: WWlrP 1. Monitor and adjust the wastewater treatment process to meet the discharge permit; monitor Ashley Creek for flow above the plant and dissolved oxygen above and below the plant. 2. Perform a minimum of 6,200 laboratory analyses per year to monitor and control the biological nutrient removal process; perform analyses ofspecific parameters to meet the discharge permit requirements. 3. 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 quality; monitor the sludge for heavy metals and nutrients to insure that it is acceptable for disposal. 5. Perform work orders (approximately 1500 per year) to keep equipment and processes functioning properly; perform equipment repairs and respond to alarms quickly so the treatment process is not interrupted. 6. Continue public relations (touts and articles) to educate the public on this unique process and the excellent quality ofthe treated wastewater. 7. Continued optimization of nitrogen removal in the main anoxic zone preceding the new Nitrogen Limits imposed on January 1, 2012, FY 2012 BUDGET ACCOMPLISHMENTS • Continued fine tuning operations following the Wastewater Treatment Plant expansion. Expansion increased the plant capacity 75% from 3.1 MGD to 5.4 MGD. • Maintained & corrected equipment information to the new electronic Operations and Maintenance manuals on plant server. • Replaced 12" & 8" plug valve in 2nd Digester. Installed backup influent & effluent flow monitoring equipment. • Overhauled the B.F.P. sludge conveyor belt, and made repairs to aging Belt Filter Presses. • Contracted with an engineering firm to complete design ofthe Primary Digester Lid Replacement Project. • Continued efforts on the Total Maximum Daily Load (TMDL) development with the Montana State DEQ and USEPA. • Continued Pretreatment Program development & completed Laboratory Quality Assurance plan. Lab proficiency rating = 100% • Purchased 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. 38 SEWER- OPERATIONS, BILLING, WASTEWATER TREATMENT ACTUAL ACTUAL BUDGET BUDGET FY09/10 FY10/11 FY11/12 FY12/13 490204 Debt Service-2004 bonds: (HWY 93 So.) 610 Principal $61,000 $63,000 $66,000 $69,000 620 Interest/fiscal agent fees $44,400 $42,075 $39,695 $37,200 630 Fiscal Agent Fees $300 $0 $300 $300 Total Debt Service Sanitary Sewer $105,700 $105,075 $105,995 $106,500 WASTEWATERTREATMENT PLANT 490210 Debt Service-2002 bonds 610 Principal $220,000 $230,000 $0 $0 620 Interest $18,230 $9,430 $0 $0 630 Fiscal Agent Fees $0 $300 $0 $0 490215 Debt Service-SRF Loan 1991 610 Principal $250,000 $261,000 $271,000 $140,000 620 Interest $34,400 $24,300 $13,760 $2,800 490227 Debt Service-SRF Loan (new construction) 610 Principal $207,000 $215,000 $460,000 $470,000 620 Interest $519,638 $511,820 $501,975 $484,538 Total Debt Service WWTP $1,249,268 $1,251,850 $1,246,735 $1,097,338 Total Sewer Fund Debt Service $1,354,968 $1,356,925 $1,352,730 $1,203,838 SCHEDULE TO BE REVISE PENDING REFINANCING 39 STORM SEWER FUND: 5 349-453-430246 BEGINNING CASH 10100 CASH: Operating 10120 Cash, Impact Fees 10122 Cash, Capital Reserve 10127 Cash, Emergency Reserve 10190 Cash, Designated for Equipment Replacement 10193 Cash, Designated Capital Projects Adjustments to Cash - A/R, Comp Abs. Total Cash REVENUES 343370 Storm Assessments -billed (10100) Assessments -designated for equipment (10190) Assessments -designated for capital projects (10193) 334040 Petro Tank/Monitory Reimbursement (10100) 343035 Pennit fees & other Charges for Service (10100) 363040 Penalty & Interest (10100) 371010 Interest (10100) 343033 Impact Fees (10120) Impact Fee 5% Admin (10100) Total Revenue Total Available Estimated ACTUAL BUDGET ACTUAL BUDGET FY10/11 FY11/12 FY11/12 FY12/13 $966,686 $1,205,923 $1,205,923 $1,324,258 S454,667 $573,530 $573,530 $623,530 $140,000 $140,000 $140,000 $140,000 $25,000 $25,000 $25,000 $25,000 $160,000 $200,000 $200,000 $196,000 $315,844 $365,844 $365,844 $415,844 $13,391 $2,075,588 $2,510,297 $2,510,297 $2,724,632 $727,689 $730,000 $730,000 $730,000 $40,000 $40,000 $40,000 $40,000 $50,000 $50,000 $50,000 $50,000 $21,469 $0 $2,415 $2,415 $5,003 $1,500 $420 $420 $9,818 $7,500 $5,000 $5,000 $26,389 $22,000 $22,000 $22,000 $118,863 $100,000 $50,000 $50,000 $6,256 $5,000 $2,500 $2,500 $1,005,487 $956,000 $902,335 $902,335 $3,081,075 $3,466,297 $3,412,632 $3,626,967 EXPENSES EXPENSES FROM RATES (10100) $570,778 $1,034,101 $644,000 $1,583,650 Capital Outlay -impact fee (10120) $0 $30,000 $0 $30,000 Capital Equipment - replacement (10190) $45,000 $44,000 $201,500 Depreciation (non -cash expense) $225,000 $260,000 $280,000 $285,000 Total Expenses $795,778 $1,369,101 $968,000 $2,100,150 add back depreciation $225,000 $260,000 $280,000 $285,000 ENDING CASH 10100 Cash, Operating 10120 Cash, Impact Fees 10122 Cash, Capital Reserve (target $140,000) 10127 Cash, Emergency Reserve (target $25,000) 10190 Cash, Designated Equipment Replacement 10193 Cash, Designated Capital Projects $1,205,923 $937,822 $1,324,258 $502,943 $573,530 $643,530 $623,530 $643,530 $140,000 $140,000 $140,000 $140,000 $25,000 $25,000 $25,000 $25,000 $200,000 $195,000 $196,000 $34,500 $365,844 $415,844 S415,844 $465,844 $2,510,297 $2,357,196 $2,724,632 $1,811,817 $40,000 designated for equipment replacement; $50,000 designated to Capital Projects 40 STORM SEWER FUND: 5 349-45 3 -43 0246 ACTUAL ACTUAL BUDGET BUDGET FY09/10 FY10/11 FY11/12 FY12/13 Personal Services $406,938 $409,523 $441,443 $422,951 Materials and Services $160,001 $155,955 $187,958 $198,461 Capital Improvements -rates $88,611 $5,300 $404,700 $962,238 Total Expenses from Rates $655,550 $570,778 $1,034,101 $1,583,650 Capital Outlay - Impact Fees ( 10 120) $409,282 $0 $30,000 $30,000 Capital Equipment -Replacement $ (10190) $0 $0 $45,000 $201,500 Depreciation $225,000 $225,000 $260,000 $285,000 GRAND TOTAL $1,289,832 $795,778 $1,369,101 $2,100,150 PROGRAM ESC PTI N 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 of 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 LAND 0.002880 capped at $250.90 RESIDENTIAL PROPERTY 0.005569 capped at $121.29 Non-residential improved: up to 90% Covered 0.009990 100% Covered 0.012488 41 ayll TV I!i FUND: 5349-45 3-430246 Line Item Detail: STORM SEWER FUND 356 Storm Water Regulatory Compliance Program/Permit Fees - $30,000 The Stormwater MS4 Permit requires the City to implement a Stormwater Management Program (SWMP). 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 annual training, 2) Public education and participation handouts and advertising, 3) Strom drain ID decals, 4) Car wash equipment, 5) Good housekeeping BMPs, 7) Site inspection and enforcement for post construction structural BMPs, 7) Redevelopment Water Quality Implementation Assistance (new 2012)-policy to be developed to provide financial assistance to businesses for smaller redevelopment projects. 430246 Capital Outlay: from rates (10100) 940 Utility Asset Management Program - $38,738 Asset Management Program for Water, Sewer, and Stormwater Utilities. The Asset Management Program works in conjunction with all other GIS-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 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 infonnation 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 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/Water - Total Cost $72,476 952 Storm Drain Correction - $100,000 (Carryover $95,000, New Appropriation $5,000) The goal of this project is to provide design and construction for areas in the City that are in need of storm 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 II - Carryover $200,000, New Appropriation $500,000 The purpose of this project is to relieve compounding drainage issues due to drainage areas (ditches, swales, outfalls) 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 design for Phase I is scheduled to be complete by June 30, 2012. The project will be bid with schedules and constructed in the summer/fall of 2012 and spring 2013. 430249 Capital Outlay: $123,500 from rates (10100) and $201,500 from replacement (10190) 944 Machinery & Equipment - $325,000 Vacuum Jet Truck 42 STORM SEWER FUND: 5349453-430246 ACTUAL ACTUAL BUDGET BUDGET FY09/10 FY10/11 FY11/12 FY12/13 Personal Services: 6.20 6.4 6.45 6.20 110 Salaries & Wages $325,179 $314,949 $333,163 $324,215 112 Severance $13,004 $7,000 $2,500 121 Overtime $3,666 $938 $5,000 $5,000 153 Health Insurance $56,978 $59,817 $75,239 $70,795 155 Retirement $21,115 $20,815 $21,041 $20,441 Subtotal Personal Services $406,938 $409,523 $441,443 $422,951 Maintenance & Operations: 210 Office Supplies/Equip./computer/GIS $8,285 $952 $9,100 $9,100 218 Equipment (non capital)/ Safety Equip & Supplies $3,370 $186 $3,500 $3,500 229 Other Supplies/Consumable tools $930 $559 $2,200 $2,200 231 Gas &Oil $8,103 $8,410 $10,500 $10,500 345 Telephone & Communication $832 $853 $850 $950 353 Auditing $600 $500 $600 $600 354 Contract Services $4,342 $1,517 $6,200 $6,200 356 Storm water Reg Compliance Program/Permit $17,672 $26,638 $20,000 $30,000 357 Facility Plan Phase 11'08 / Impact Fee Update'13 $16,034 $0 $8,000 $8,000 358 Consultants $0 $10,689 $7,000 $7,000 359 Consultants/TMDL/Permit $0 $22,071 $15,000 $15,000 360 Repair & Maint. Services $1,850 $2,358 $1,500 $1,500 362 Groundwater Monitoring $24,654 $11,530 $25,000 $17,000 371 Curb & Gutter $7,504 $5,827 $5,000 $5,000 373 Dues & Training $2,560 $3,113 $3,500 $3,500 388 Medical Services $0 $185 $250 $200 410 Construction materials $105 $353 $10,000 $10,000 510 Liability Ins. $8,000; $5,500 uninsured loss) $9,282 $7,557 $8,500 $13,500 521 Central Garage Transfer $2,500 $2,500 $2,500 $3,000 522 Administrative Transfer $32,848 $31,957 $30,376 $32,704 528 Data Processing Transfer $5,573 $5,344 $5,344 $5,969 530 Lease Payments/BNSF $5,119 $5,018 $5,200 $5,200 532 Office rent $7,838 $7,838 $7,838 $7,838 Subtotal materials & services $160,001 $155,955 $187,958 $198,461 43 STORM SEWER FUND: 5349-453-430246 EXPENSE ETAIL-C®ntt. 430246 Capital Outlay: from rates (10100) 941 Utility Asset Management Program 944 Vacuum Jet Truck - 38% 952 Stoma Drain Correction funds 954 South Meadows Phase I Design/Constr. & Phase I1 958 Stillwater & Willow Glen Construction Subtotal Capital from rates 430248 Capital Outlay: Impact Fee $ (10120) 958 Stillwater & Willow Glen Construction 959 Southeast Storm Drain Improvements Phase 1 960 Stonnwater Facility Upsizing Subtotal from Impact fee funds 430249 Capital Outlay: from replacement $ (10190) 944 Vacuum Jet Truck - 62% 510400 Depreciation: 831 Depreciation: TOTAL Storm Sewer ACTUAL ACTUAL BUDGET BUDGET FY09/10 FY10/11 FY11/12 FY12/13 $38,738 $0 $0 $0 $123,500 $15,000 $0 $100,000 $100,000 $0 $5,300 $304,700 $700,000 $73,611 $0 $0 $0 $88,611 $5,300 $404,700 $962,238 $246,868 $0 $0 $0 $162,414 $0 $0 $0 $0 $0 $30,000 $30,000 $409,282 $0 $30,000 $30,000 $0 $0 $45,000 $201,500 $0 $0 $45,000 $201,500 $225,000 $225,000 $260,000 $285,000 $1,289,832 $795,778 $1,369,101 $2,100,150 44 SOLID WASTE FUND: 5510-460430840;430845 PROJECTED VE AND FUND SUMMARY Estimated ACTUAL BUDGET ACTUAL BUDGET FY10/11 FY11/12 FY11/12 FY12/13 BEGINNING CASH 10100 CASH: operating $275,863 $400,630 $400,630 $479,130 10120 *Replacement Account $135,624 $235,624 $235,624 $131,490 Total Cash $411,487 $636,254 $636,254 $610,620 ]REVENUES 343410 Assessments $800,162 $808,000 $813,000 $843,000 343420 garbage collections billed (part year) $30,000 $15,000 363040 Penalty & Interest $5,451 $3,500 $5,500 $5,500 371010 Interest Earnings $4,413 $3,500 $5,000 $5,000 Change in A/R, Comp. Abs. ($16,131) $0 $0 $0 Total Revenue $793,895 $815,000 $853,500 $868,500 Total Available $1,205,382 $1,451,254 $1,489,754 $1,479,120 EXPENSES Total Expenses from Rates (10100) $569,128 $716,489 $650,000 $695,627 CapitalOutlay-replacement (10120) $0 $220,000 $229,134 $45,000 *Depreciation/ReplacementFund $100,000 $125,000 $125,000 $150,000 Total Expenses $669,128 $1,061,489 $1,004,134 $890,627 add back transfer to replacement account $100,000 $125,000 $125,000 $150,000 ENDING CASH 10100 Operating $400,630 $374,141 $479,130 $502,003 10120 *Replacement Account $235,624 $140,624 $131,490 $236,490 Total Cash $636,254 $514,765 $610,620 $738,493 FY 12/13 - Increased designated replacement from $125,000 t0 $150,000 45 SOLID WASTE FUND: 5510-46043 0840;43 0845 r � z ACTUAL ACTUAL BUDGET BUDGET FY09/10 FY10/11 FY11/12 FY12/13 Personal Services $448,966 $395,653 $460,963 $481,422 Materials and Services $161,891 $173,475 $215,526 $214,205 Capital Outlay $0 $0 $40,000 $0 Total M & O from Rates $610,857 $569,128 $716,489 $695,627 Capital Outlay from Replacement Funds $0 $0 $220,000 $45,000 Depreciation Expense (non -cash) $100,000 $100,000 $125,000 $150,000 $710,857 $669,128 $1,061,489 $890,627 19 MT" 01.1] x.Y* aflA "110 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,582 residential and commercial accounts. GARBAGE RATES The garbage rates: Residential: $111.00 per year Non -Residential: 300 Gal. 350 Gal 400 Gal. Current Current Current DUMPSTER Pick up Rates Rates Rates 1 Weekly $338.00 $375.00 $411.00 2 Weekly $558.00 $631.00 $704.00 3 Weekly $828.00 $938.00 $1,047.00 46 SOLID WASTE FUND: 5510460-430840;430845 ACTUAL ACTUAL BUDGET BUDGET FY09/10 FY10/11 FY11/12 FY12/13 Personal Services: FTE's 7.60 7.35 7.25 7.35 110 Salaries & Wages $358,158 $303,958 $351,409 $355,935 112 Severance $4,789 $5,500 $12,500 121 Overtime/Call outs $3,686 $2,802 $7,500 $5,000 153 Health Insurance $64,743 $64,477 $74,749 $85,902 155 Retirement - PERD $22,379 $19,627 $21,805 $22,084 Total Personal Services $448,966 $395,653 $460,963 5481,422 Materials and Services: 213 Office Equip/ computer equip & supplies $461 $2,424 $3,500 $3,500 218 Non Capital Equip.- Garbage Containers $4,206 $12,212 $20,000 $20,000 229 Other Supplies/Safety equip/Consumable tool $2,470 $4,196 $5,500 $5,500 231 Gas and Oil $32,806 $41,466 $50,000 $50,000 341 Electricity $1,593 $1,681 $1,700 $1,700 344 Natural Gas $1,477 $3,304 $4,000 $4,000 345 Telephone $625 $424 $700 $700 354 Contract Services $10,758 $3,373 $12,000 $12,000 362 Equipment Maint. & Supplies/radios $6,155 $5,675 $5,700 $5,700 366 Building Maintenance $1,667 $1,437 $2,500 $2,500 373 Dues & Training $777 $449 $2,500 $2,500 388 Medical services $606 $313 $500 S500 510 Property & Liability Ins. $1,500/$9,000 $13,749 $10,008 $12,500 $12,500 512 Uninsured Loss- Deductible $0 $0 $6,500 $6,500 521 Central Garage Transfer $26,000 $26,000 $26,000 $28,500 522 Administrative Transfer $30,683 $29,995 $29,835 $27,753 528 Data Processing Transfer $11,145 $9,353 $9,353 $7,614 532 Office Rent $7,838 $7,838 $7,838 $7,838 Total M & O $153,016 $160,148 $200,626 $199,305 430845 Wash bay/Materials & Services 224 Janitorial Supplies $0 $68 $350 $200 341 Electricity $3,139 $3,261 $3,200 $3,200 342 Water $438 $491 $350 $500 344 Natural Gas $3,627 $8,870 $8,500 $8,500 360 Repair & Maint Services/building maint $1,671 $637 $2,500 $2,500 $8,875 $13,327 $14,900 $14,900 47 SOLID WASTE FUND: 5 510-460-43 0840;430845 .............. EXPENSE ETAIL ACTUAL ACTUAL BUDGET BUDGET FY09/10 FY10/11 FY11/12 FY12/13 430840 Capital Outlay: (10100) from rates 944 Garbage Truck 15% $0 $0 $40,000 $0 $0 $0 $40,000 $0 430840 Capital Outlay: Replacement funds (10120) 940 Machinery & Equipment $0 $0 $0 $45,000 944 Garbage Truck 85% $0 $0 $220,000 $0 Subtotal Capital Outlay $0 $0 $220,000 $45,000 510400 Depreciation (fund Replacement account $125,000) 831 Depreciation expense $100,000 $100,000 $125,000 $150,000 Total Solid Waste $710,857 $669,128 $1,061,489 $890,627 FY 2013 BUDGET HIGHLIGHTS Line Item Detail: Solid Waste Fund Replacement Funds (10120) 940 Machinery & Equipment - $45,000 $45,000 - 3/4 Ton 4x4 Pickup w/Plow & Sander FY 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. * Purchased a Sidearm Garbage Truck. * Continued to restructure routes in an effort to limit trips to the county landfill, improve customer service, and lower costs. 48 PERSONNEL FTE BUDGET POSITION TITLE - Administration FY12/13 Public Works Director 0.05 $4,306 Budget Resource Manager 0.05 $3,017 Administrative Coordinator 0.05 $2,270 Assessment Coordinator 0.05 $2,548 Project Manager 0.05 $3,100 contingency $1,000 Subtotal 0.25 $16,241 PAYROLL TAXES $1,498 Total line item 110 $17,739 POSITION TITLE - Central Garage Foreman I $43,493 Mechanics 2 $86,757 tool allowance $1,500 contingency $500 Subtotal 3 $132,250 PAYROLL TAXES $20,894 Total line item I10 $153,144 POSITION TITLE - Liaht Maintenance Budget Resource Manager 0.05 $3,017 Assessments Coordinator 0.20 $10,192 Maintenance & Repair 0.50 $19,115 Pager Pay/Clothing Allowance/Longevity /Step Increases $1,500 Subtotal 0.75 $33,824 PAYROLL TAXES $5,363 Total line item 110 $39,187 49 PERSONNEL POSITION TITLE - Street Maintenance Public Works Director Budget Resource Manager Administrative Coordinator Deputy Public Works Director Project Manager Assistant City Engineer Construction Managers Surveyor Assessments Coordinator Maintenance Clerk Superintendent Foreman Maintenance & Repair clothing allowance cross fund budget/step/ longevity Subtotal PAYROLL TAXES Total line item 110 POSITION TITLE - Traficc Svstem Maintenance Foreman Maintenance & Repair pager pay/clothing allowance step longevity Subtotal PAYROLLTAXES Total line item 110 FTE BUDGET FY12/13 0.20 $17,222 0.15 $9,051 0.15 $6,811 0.00 $0 0.25 $15,501 0.25 $16,791 0.25 $13,442 0.25 $9,240 0.20 $10,192 0.10 $3,380 0.20 $6,768 0.50 $29,432 1.00 $46,488 8.75 $310,294 $1,000 $5,000 12.25 $500,612 $74,246 $574,858 1.00 $49,192 1.50 $57,554 $5,235 $3,000 2.50 $114,981 $18,786 $133,767 50 PERSONNEL SCHEDULE POSITION TITLE - Water Operations Public Works Director Budget Resource Manager Administrative Coordinator Deputy Public Works Director Project Manager Assistant City Engineer Senior Civil Engineer Assistant Civil Engineer Construction Managers (2 .25 He) Water Resource Manager Maintenance and Construction Superintendent Surveyor Clerk Engineering Tech Maintenance Foreman Assessment Coordinator Maintenance & Repair clothing allowance/boots Longevity/Step Increases per Contract Subtotal PAYROLLTAXES Total line item 110 POSITION TITLE - Water Billing Finance Director Assistant Finance Director Administrative Coordinator Water Clerk (vacant.5) Meter Reader Vacancy savings Subtotal PAYROLLTAXES Total line item 110 FTE BUDGET FY12/13 0.20 $17,222 0.15 $9,051 0.10 $4,541 0.00 $0 0.20 $12,401 0.25 $16,791 0.60 $44,129 0.40 $18,437 0.25 $13,442 0.00 $0 0.15 $8,830 0.00 $0 0.20 $6,768 0.25 $9,240 0.10 $3,380 2.00 $93,392 0.05 $2,548 8.00 $316,014 $1,200 $4,200 12.90 $581,586 $87,709 $669,295 0.15 $12,917 0.25 $16,515 0.10 $4,541 1.00 $28,699 0.50 $16,505 (S4,000) 2.00 $75,177 $7,903 $83,080 51 PERSONNEL POSITION TITLE - Sewer Operations Public Works Director Budget Resource Manager Administrative Coordinator Deputy Public Works Director Project Manager Assistant City Engineer Construction Manager Assessments Coordinator Water Resource Manager Surveyor Superintendent Clerk Engineering Tech Foreman Maintenance & Repair Personnel (I vacant -unfunded) clothing allowance Longevity/ step increases per contract Vacancy savings Subtotal PAYROLL TAXES Total line item 110 POSITION TITLE - Sewer Billing Finance Director Assistant Finance Director Administrative Coordinator Sewer Clerk Meter Reader Vacancy savings Subtotal PAYROLL TAXES Total line item 110 FTE BUDGET FY12/13 0.15 $12,917 0.15 $9,051 0.10 $4,541 0.00 $0 0.15 $9,301 0.15 $10,074 0.25 $13,442 0.05 $2,548 0.00 $0 0.00 $0 0.05 $2,943 0.20 $6,552 0.25 $9,240 0.50 $22,360 3.50 $101,015 $800 $1,625 5.50 $206,409 $28,935 $235,344 0.15 $12,917 0.25 $16,515 0.10 $4,541 0.50 $14,752 0.50 $16,505 ($4,000) 1.50 $61,230 $6,524 $67,754 52 (_ i':�': PERSONNEL °SCHEDULE POSITION TITLE - Wastewater Treatment Plant Public Works Director Budget Resource Manager Administrative Coordinator Deputy Public Works Director Water Resource Manager Assistant City Engineer Waste Water Treatment Plant Manager Operators working foreman differential Pager pay clothing allowance/boots Longevity/ step increases/ AFSCME contract Subtotal PAYROLL TAXES Total line item 110 POSITION TITLE - Wastewater Treatment Plant Lab Chemist II Longevity/ step increases per contract Subtotal PAYROLL TAXES Total line item 110 53 FTE BUDGET FY12/13 0.20 $17,222 0.15 $9,051 0.10 $4,541 0.00 $0 0.00 $0 0.10 $6,716 1.00 $55,994 4.00 $201,344 $1,070 $4,940 $500 $2,500 5.90 $303,878 $45,728 $349,606 2.00 $98,592 $2,500 2.00 $101,092 $15,708 $116,800 FTE BUDGET POSITION TITLE - Storm Water Operations FY12/13 Public Works Director 0.10 $8,611 Water Resource Manager 0.40 $29,420 Senior Civil Engineer 0.25 $16,791 Budget Resource Manager 0.15 $9,051 Administrative Coordinator 0.10 $4,541 Project Manager 0.20 $12,401 Construction Manages 0.25 $13,442 Foreman 0.50 $22,360 Assessments Coordinator 0.20 $10,192 Superintendent 0.05 $2,943 Assistant Civil Engineer 0.60 $27,656 Clerk 0.20 $6,768 Engineering Tech 0.25 $9,240 Maintenance & Repair 2.75 $104,246 Maintenance 0.20 $6,760 boots allowance $1,200 contingency $3,500 Subtotal 6.20 $289,122 PAYROLL TAXES $36,685 Total line item 110 $325,807 POSITION TITLE - Solid Waste Public Works Director 0.10 $8,611 Budget Resource Manager 0.15 $9,051 Administrative Coordinator 0.20 $9,081 Project Manager 0.15 $9,301 Superintendent 0.25 $14,716 Assessments Coordinator 0.20 $10,192 Clerk 0.20 $6,768 Foreman 1.00 $45,240 Solid Waste Operator 5.00 $188,926 Maintenance 0.10 $3,380 boots $600 contingency/street employee help $6,500 Subtotal 7.35 $312,366 PAYROLL TAXES $46,231 Total line item 110 $358,597 54