Loading...
11. Enterprise Funds 2018 Prelim BudgetENTERPRISE FUNDS Page Fund Dept 1-2 5160 Airport $ 166,329 3-9 5210 Water $ 8,027,649 10-16 5310 454 Sewer Operations & Billing $ 11,394,501 17-21 5310 455 Waste Water Treatment Plant $ 6,476,319 22-26 5349 Storm Sewer $ 2,479,885 27-30 5510 Solid Waste $ 1,217,488 Total $ 29,762,171 AIRPORT ACCOUNT # 5160-430 PURPOSE OF THIS DEPARTMENT: Why does this department exist? The Kalispell City Airport is part of the overall transportation system for the City of Kalispell, serving both recreational and commercial interests with an optional mode of transportation. DEPARTMENT PERSONNEL: GOALS OF THIS DEPARTMENT: What are the departmental goals that support the purpose? INTENDED OUTCOMES FROM BUDGET EXPENDITURES In fiscal year 2014, municipal voters rejected a ballot issue to move forward with improvements to the airport as identified in the adopted airport master plan. That action has initiated an effort to update the Urban Renewal Plan from which the improvments were originally identified. The outcome of this plan will likely guide future decisions related to airport maintenance and development efforts. AIRPORT ENTERPRISE FUND -operations FUND: 5160-430-43 0310 PROJECTED REVENUE AND FUND SUMMARY BEGINNING CASH 10100 Cash - Operations REVENUES 343062 Commercial Fees 343069 Hangar Leases 343071 Hangar Site Leases (3%) 343101 FBO Lease - Red Eagle Aviation (2%) 343102 Ground Leases (Hilton) (3%) 343620 Fuel Tax 371010 Investment Earnings Total Revenue Total Available Airport Operations Depreciation Total Expenses add back unfunded depreciation ENDING CASH 10100 Cash: Operating estimated proposed ACTUAL BUDGET ACTUAL BUDGET FV15/16 FY16/17 FV16/17 FY17/18 $125,851 $147,071 $147,071 $159,754 $125,851 $147,071 $147,071 $159,754 $11,032 $10,000 $10,000 $10,000 $12,000 $11,000 $12,000 $12,000 $18,627 $17,510 $19,132 $18,035 $18,150 $19,145 $18,000 $19,145 $12,814 $13,198 $13,198 $13,594 $5,226 $5,000 $3,000 $5,000 $1,084 $1,000 $1,500 $1,200 $78,933 $76,853 $76,830 $78,974 $204,784 $223,924 $223,901 $238,728 $57,713 $68,147 $64,147 $68,411 $97,918 $97,918 $97,918 $97,918 $155,631 $166,065 $162,065 $166,329 $97,918 $97,918 $97,918 $97,918 $147,071 $155,777 $159,754 $170,317 1 AIRPORT ENTERPRISE FUND -operations FUND: 5160-430-43 0310 EXPENSE DETAIL proposed ACTUAL ACTUAL BUDGET BUDGET FY14/15 FY15/16 FY16/17 FY17118 Maintenance & Operations: 210 Supplies, postage, small equip $0 $0 $1,000 $1,000 341 Electricity $1,605 $1,505 $1,500 $1,600 354 Contract Services - Airport Management $36,000 $36,000 $36,000 $36,000 356 Contract Services - Other $5,395 $4,700 $7,500 $7,500 362 Repair & Maintenance -Equip/Lights, etc $1,096 $2,836 $10,000 $10,000 390 Equipment Rental $835 $840 $1,000 $1,000 510 Property & Liability Ins. $6,418 $6,418 $6,500 $6,500 522 Administrative Transfer $5,469 $3,320 $2,562 $2,726 528 Information Tech Transfer $1,429 $2,094 $2,085 $2,085 Subtotal $58,247 $57,713 $68,147 $68,411 820 Depreciation (unfunded) $97,918 $97,918 $97,918 $97,918 Total $156,165 $155,631 $166,065 $166,329 N WATER ACCOUNT # 5210-447 PURPOSE OF THIS DEPARTMENT: Why does this department exist? To provide safe, potable and palatable water for the needs of the domestic, commercial and industrial consumers. DEPARTMENT PERSONNEL: (15.30 FTE) .20 Public Works Director .25 City Engineer .15 Budget Resource Manager .25 Construction Manager .20 Administrative Coordinator .20 Engineer H .05 Road and Fleet Superintendent .20 Administrative Assistant .10 General Laborer .60 Utility Management Superintendent .40 Engineer II .25 Engineering Tech/GIS/IT Support 1 Water Meter Maintenance Supervisor 1 Water Meter Maintenance Technician 1 Water Maintenance Supervisor 4 Water Maintenance Operators 1 Water Production Supervisor 2 Water Production Operators .50 Meter Reader 1.25 Utility Billing Clerk .25 Finance Director .15 City Accountant .05 Assessment Coordinator .25 Accounts Payable Clerk GOALS OF THIS DEPARTMENT: What are the departmental goals that support the purpose? 1. To operate the distribution and production facilities to meet Public Drinking Water Standards. 2. Provide drinking water that is safe to drink and palatable. 3. Maintain the system to achieve adequate pressure, minimize leaks, and provide flows for fire emergencies. 4. Replace old, deteriorated, water mains to promote safe drinking water and fiscal efficiencies for the water system customers. INTENDED OUTCOMES FROM BUDGET EXPENDITURES: This year's budget continues the replacement of aging and leaking mains throughout the water system to improve delivery of domestic water and fire flows. 4th Ave E. water main replacement project will be in coordination with a street reconstruct and drainage improvements enabling cost savings for one major infrastructure project. A new well will be placed into operations and the water facility plan will be updated, providing location and sizing of infrastructure to meet the need of new growth in Kalispell. WATER FUND (Operations & Billing) FUND: 5210-447-430550 BEGINNING CASH 10100 Operating Cash 10120 Impact Fee Cash 10125 Meter Replacement Cash 10127 Capital & Emergency Reserve -Target $400,000 10130 Bond Reserves (restricted cash) REVENUES 343210 Metered Water Sales (billed) (10100) 343230 Meter Replacement Fee (10125) 343225 Impact Fees (10120) 343365 Impact Fee Admin (10100) 343260 Mise.-Installation/Reconnect/Tag fees (10100) 371010 Interest Earnings (10100) Interest Earnings -Impact Fee Cash (10120) Bonded Debt - 4th Ave E main repl. Total Revenue Total Available EXPENSES EXPENSES FROM RATES Expenses from Meter Cash (10125) Capital Outlay - from Impact Fees (10120) Capital Outlay / Bonded Debt - 4th Ave E main rep]. Debt Service -from Impact Fees (10120) Depreciation (other non cash exp) Total All Departments add back depreciation/other noncash exp, (rent fy17-18) ENDING CASH 10100 Operating Cash 10120 Impact Fee Cash 10125 Meter Replacement Cash 10127 Capital & Emergency Reserve -Target $400,000 10130 Bond Reserves (restricted cash) Total cash estimated proposed ACTUAL BUDGET ACTUAL BUDGET FY15/16 FY16/17 FY16/17 FY17/18 $3,659,909 $5,158,898 $5,158,898 $6,265,753 $910,706 $1,063,170 $1,063,170 $1,308,170 $298,802 $362,329 $362,329 $400,329 $400,000 $400,000 $400,000 $400,000 $358,400 $358,400 $358,400 $358,400 $5,627,817 $7,342,797 $7,342,797 $8,732,652 $3,249,861 $2,850,000 $2,950,000 $2,900,000 $105,950 $98,000 $98,000 $98,000 $396,998 $285,000 $513,000 $323,000 $20,895 $15,000 $27,000 $17,000 $137,229 $74,000 $115,000 $100,000 $41,500 $41,500 $68,000 $68,000 $7,468 $4,500 $12,000 $12,000 $0 $2,435,627 $608,907 $2,097,796 $3,959,901 $5,803,627 $4,391,907 $5,615,796 $9,587,718 $13,146,424 $11,734,704 $14,348,448 $1,950,496 $2,305,466 $2,053,145 $3,753,904 $42,423 $110,000 $60,000 $110,000 $52,002 $835,346 $100,000 $1,207,346 $0 $2,435,627 $608,907 $1,923,555 $200,000 $200,000 $180,000 $180,000 $840,000 $852,844 $852,844 $852,844 $3,084,921 $6,739,282 $3,854,896 $8,027,649 $840,000 $852,844 $852,844 $852,844 $5,158,898 $5,833,932 $6,265,753 $5,780,851 $1,063,170 $317,324 $1,308,170 $255,824 $362,329 $350,329 $400,329 $388,329 $400,000 $400,000 $400,000 $400,000 $358,400 $358,400 $358,400 $348,640 $7,342,797 $7,259,986 $8,732,652 $7,173,644 3 WATER FUND SUMMARY EXPENDITURE SUMMARY Personal Services: Water Billing Water Operations Subtotal Maintenance & Operations: Water Billing Services Water Operations Subtotal Capital Outlay from Rates: Water Operations Subtotal Debt Service from Rates: Water Subtotal Total Capital Outlay - Bonded Project Capital Outlay - Meter Replacement funds:(10125) Capital Outlay - from Impact Fee Funds: (10120) Debt Service -from Impact Fees: (10120) Depreciation (non -cash item) Total proposed ACTUAL ACTUAL BUDGET BUDGET FY14/15 FY15/16 FY16/17 FY17118 $107,260 $133,218 $153,887 $151,767 $798,662 $862,654 $946,521 $957,559 $905,922 $995,872 $1,100,408 $1,109,326 $72,370 $107,014 $127,372 $127,873 $589,071 $536,041 $769,096 $1,074,572 $661,441 $643,055 $896,468 $1,202,445 $889,916 $256,939 $269,448 $1,201,600 $889,916 $256,939 $269,448 $1,201,600 $232,600 $54,630 $51,986 $253,377 $232,600 $54,630 $51,986 $253,377 $2,689,879 $1,950,496 $2,318,310 $3,766,748 $0 $0 $2,435,627 $1,923,555 $6,760 $42,423 $110,000 $110,000 $16,577 $52,002 $835,346 $1,207,346 $200,000 $200,000 $200,000 $180,000 $840,000 $840,000 $840,000 $840,000 $3,753,216 $3,084,921 $6,739,283 $8,027,649 4 WATER OPERATIONS FUND: 5210-447-4305 50 EXPENSE DETAIL Personal Services: FTE's 110 Salaries & Wages III Seasonal Salaries 121 Overtime/Call Outs 153 Health Insurance 155 Retirement - PERD Subtotal Maintenance & Operations: 210 Office Supplies/Equip/Computers/ GIS 218 Equip. (non-capital)/Safety Equip & Supplies 226 Chlorine & Chemical 229 Other Supplies/JanitoriaVConsumable Tools 231 Gas & Oil 312 Postage & Printing 336 Licenses / Public Water Supply Fee 341 Electricity 344 Natural Gas 345 Communications 349 Lab Services 353 Auditing 354 Contract Services 356 Consultants-Wtr Rights/Modeling/Facility Plan 362 Repair & Maint./Equip Maint/Radios/Equip Rental 366 Building & Grounds Maintenance 373 Dues & Training 388 Medical/DrugTesting 410 Construction Materials 422 Hydrants 423 Materials - Mains 424 Materials - Service lines 425 Materials - Wells/Pumps proposed ACTUAL ACTUAL BUDGET BUDGET FY14/15 FY15/16 FY16/17 FY17/18 12.80 12.80 12.80 12.80 $625,620 $673,814 $702,293 $717,155 $687 $0 $5,000 $5,000 $15,474 $7,161 $20,000 $20,000 $110,945 $132,362 $I68,225 $162,626 $45,936 $49,317 $51,002 $52,778 $798,662 $862,654 $946,521 $957,559 $10,507 $7,466 $11,000 $12,000 $6,008 $5,698 $8,500 $8,500 $36,287 $27,180 $38,000 $38,000 $3,645 $2,709 $4,500 $4,500 $27,347 $19,437 $38,000 $35,000 $528 $315 $4,000 $1,000 $16,621 $15,680 $18,500 $18,500 $137,007 $144,055 $150,000 $150,000 $10,813 $8,254 $15,500 $15,500 $8,535 $10,164 $9,000 $10,500 $11,473 $8,337 $26,000 $20,000 $5,000 $5,000 $5,000 $5,000 $42,800 $25,715 $65,000 $55,000 $11,200 $14,934 $25,000 $325,000 $7,787 $3,575 $15,000 $15,000 $1,303 $2,600 $12,000 $12,000 $8,141 $7,152 $9,000 $9,000 $435 $255 $800 $600 $29,553 $16,332 $35,000 $35,000 $12,243 $7,049 $8,000 $10,000 $7,690 $8,686 $14,000 $14,000 $13,572 $4,389 $14,000 $12,000 $6,469 $3,122 $45,000 $45,000 5 WATER OPERATIONS 5210-447-430550 EXPENSE DETAIL proposed ACTUAL ACTUAL BUDGET BUDGET FY14/15 FY15/16 FY16/17 FY17/18 Maintenance & Operations Continued: 510 Property & Liability Ins. $23,144 $22,452 $ I 5,468 $30,000 512 Uninsured Loss -Deductible & Goodwill Expendil $145 $8,354 $10,000 $10,000 521 Central Garage Transfer $14,248 $18,130 $23,855 $23,750 522 Administrative Transfer $104,561 $98,426 $103,473 $114,222 528 Information Tech. Transfer $22,864 $33,500 $36,000 $36,000 532 Office Rent/Lease Pymnt (Silverbrook Well) $9,145 $7,076 $9,500 $9,500 Subtotal $589,071 $536,041 $769,096 $1,074,572 490200 610/620 Principal, Interest, Fiscal Fees $432,600 $254,630 $251,986 $433,377 Capital Outlay - Operating funds (rates): 921 Sand/Cold Mix Storage Shed $0 $0 $25,771 $0 922 USES Bldg & Property Acquisition/Repair $0 $0 $32,978 $0 935 Sheepherders Tank Mixer $10,509 $0 $0 $0 936 Noffsinger Spring Generator $0 $0 $90,000 $0 937 Sheepherder Backup Power $10,694 $179 $0 $0 938 Old School Well Frequency Drives $0 $0 $0 $45,000 940 Machinery & Equipment $0 $0 $0 $32,400 947 US 93 N. Utility Relocate $15,709 $2,175 $0 $0 950 4th Ave EN Wtr Main Replc $651,990 $0 $0 $0 951 SCADA Upgrades $5,283 $10,307 $15,000 $15,000 953 Shop Complex Pavemnt Restoration- Carry & Ne $0 $0 $30,552 $38,200 958 2nd Ave. E. Main $0 $171,829 $45,147 $0 959 Parks Metering Phase II $0 $0 $30,000 $30,000 962 9th Ave West Water Main Replacement $0 $0 $0 $625,000 963 8th Street West Water Main Replacement $0 $0 $0 $416,000 967 2nd Ave WN Main -MT to WA $190,409 $26,688 $0 $0 968 Depot Well Revitalization $5,322 $0 $0 $0 970 Old School Well Sand Separator $0 $15,392 $0 $0 971 Westview Well VFD Upgrade $0 $30,369 $0 $0 Subtotal $889,916 $256,939 $269,448 $1,201,600 6 WATER OPERATIONS 5210-447-430550 EXPENSE DET'A,IL proposed ACTUAL ACTUAL BUDGET BUDGET FY14115 FY15/16 FY16/17 FY17/18 Capital Outlay -Bonded: 969 4th Ave E. Main Replc (Carryover & New A $0 $0 $2,435,627 $1,923,555 430555 Capital Outlay -Impact Fee Funds (010120) 941 Meters $16,577 $42,223 $45,600 $45,600 930 Contract Main Upsize (Impact fee Acet) $0 $9,779 $150,000 $200,000 953 Develop Wtr Supply Section 36 Well-CarryoN $0 $0 $639,746 $961,746 Subtotal $16,577 $52,002 $835,346 $1,207,346 430550 Capital Outlay -Meter Funds (010125): 948 Meters -Replacement $ subtotal $6,760 $42,423 $110,000 $110,000 Subtotal $6,760 $42,423 $110,000 $110,000 510400-831 Depreciation Expense $840,000 $840,000 $840,000 $840,000 Total Water Facilities $3,573,586 $2,844,689 $6,458,024 $7,748,009 430560 Water Billing Personal Services: FIFs 2 2.5 2.5 2.5 110 Salaries & Wages $85,114 $98,092 $108,823 $111,417 153 Health Insurance $15,817 $27,754 $36,839 $31,823 155 PERD $6,330 $7,372 $8,225 $8,527 Subtotal $107,261 $133,218 $153,887 $15I,767 Maintenance & Operations: 210 Office Supplies/Computers $1,839 $6,112 $2,500 $2,500 353 Auditing $2,020 $2,000 $2,000 $2,000 354 Billing Costs/Grizzly See. & postage $0 $0 $3,000 $45,000 355 Billing Costs bank & cc fees, CenturyLink $29,813 $49,003 $70,000 $22,000 356 Billing costs/printing $0 $0 $0 $3,000 373 Dues & Training $485 $2,246 $2,500 $2,500 522 Administrative Transfer $7,511 $7,731 $7,950 $11,451 528 Information Tech. Transfer $22,864 $33,500 $33,000 $33,000 532 Office Rent $7,838 $6,422 $6,422 $6,422 Subtotal $72,370 $107,014 $127,372 $127,873 Total Billing $179,631 $240,232 $281,259 $279,640 Grand Total Water Fund $3,753,217 $3,084,921 $6,739,283 $8,027,649 7 WATER OPERATIONS FUND: 5210-447-430550/560 FY 2018 BUDGET HIGHLIGHTS Line Item Detail: Water Fund 210 Office Supplies/Equip/Computers/ GIS - $14,000 Increase needed to meet the computer replacement schedule, annual software needs, and includes funds to upgrade cabling, switches, and fiber for the network at the City shops. 349 Lab Services & Sampling Supplies - $16,000 (reduced $6,000) In FY 17, the line item was increased to purchase nine sampling stations for bac-T and chlorine residual testing. The sampling stations have been purchased so the line item has been reduced for the FYI 8 budget. 354 Contract Services - $55,000 (reduced $10,000) In FY 17, the line item was increased $10,000 to complete a water storage tank inspection and cleaning. The inspection and cleaning have been completed and the line item has been reduced by $10,000 for FY 18 budget. This line item also covers the cost of annual contracts, i.e„ U-dig fees, generator testing and maintenance, coveralls, and estimated electrical and system repairs. 356 Consultants - $325,000 $300,000 Facility Plan Update $25,000 - Water Rights Acquisition and Water Modeling Capital Outlay: Operating Funds (Rates) 938 Old School Well Frequency Drives - $45,000 This project upgrades Old School Well motor starters to variable frequency drives (VFD's). VFD's provide adjustment for motor speed control when operating submersible pumps. Controlling motor starting and stopping speeds minimizes water hammer while lowering operational speeds to match water system demands (W-EX-I82). 940 Machinery & Equipment - $32,400 $25,000 - All Wheel Drive Meter Reader Vehicle_ Scheduled replacement of 2005 Colorado pickup with 49,500 miles. This vehicle will be replaced with a an all wheel drive to better meet the needs of meter reading.. $7,400 Robotic Total Station Costs shared btwn Water, Public Works, Streets, Storm, Sewer and Water. Total Cost $32,400 951 SCADA System Upgrade/Improvements - $15,000 Lip The SCADA system utilizes complex software to operate, control, and monitor water system facilities. This continued allocation ensures funding for all unforeseen upgrades and maintenance to the SCADA system and supporting equipment (W-EX-155). 953 Shop Complex Pavement Restoration - Carryover $30,552, New Appropriation $7,648 The project involves replacement of the degraded asphalt surface inside the fenced area of the City Shop Complex and the installation of a new storm water quality treatment device. The asphalt at the City Shop Complex is deteriorated beyond simple patch work and necessitates replacement. The asphalt replacement triggers storm water treatment requirements stipulated by the MS4 permit and promotes good stewardship for clean water discharges to Ashley Creek. Cost shared between Water, Sewer, Storm, Streets, & Solid Waste - Total Project Cost $191,000 8 WATER OPERATIONS FUND: 5210-447-430550/560 FY 2018 BUDGET HIGHLIGHTS - con't. Line Item Detail: continued Capital Outlay: Operating Funds (Rates) Cont. 959 Parks Metering - Phase II - Carryover $20,000, New Appropriation $10,000 Installation of water meters, meter pits, and backflow prevention in the City's parks. Metering City parks irrigation will allow for analysis of production and demand of water production system. The data will enhance our cost of service analysis and the need for implementation of new water production wells. The project will be completed over two phases. (W-EX-176). 962 9th Avenue West Water Main Replacement - $625,000 This project involves replacement of approximately 1,600' of 1920's era 6" cast iron water main with 8" PVC. The project scope begins at the intersection of 9th Ave. W. and 6th St. and continues south on 9th Ave. W. to the intersection at 8th St. The new main will then T and loop together 8th Ave. W. and 1 Oth Ave. W. The existing main has ruptured at 5 different locations within the last 24 months (W-EX-172). 963 8th Street West Water Main Replacement - $416,000 This project replaces approximately 860' of 6" cast iron water main with 8" PVC. The existing water main was installed in the 1920's and has experienced multiple breaks due to aging pipes (W-EX-178). Capital Outlay: BONDED PROJECT 969 4th Avenue East Main Replacement - Carryover $1,826,720 and New Appropriation $96,835 This bonded project constitutes replacement of 14 blocks of water main from Center St to 10 St E. The existing 8"/6" cast iron water main was installed between 1925 and 1930, and is at the end of its design service life. The 85 plus year old pipe is corroding, creating multiple main breaks throughout this section of pipe in the past several years. The water project will be coordinated with the street and storm CIPs for road and drainage improvements (W-EX-21). Capital Outlay - Impact Fee funds (10120) 930 Contract Main Upsize - $200,000 $200,000 -Funds required for small city requested upsizing of private development infrastructure. Increase due to potential new development projects in North and South Kalispell (W EX-119). 941 Meters - $45,600 New Services (W-EX-123) 953 Construct Grossweiler Well -Carryover $639,746; New Appropriation $322,000 As growth and water demand increase, new wells and mains are required to meet the firm and peak demands of the City. The development of Grossweiler well, would be sufficient to meet the projected growth demand and Public Water Supply requirements stipulated by MDEQ. The Grossweiler well is located adjacent to the DNRC/DEQ/911 Center complex on Stillwater Road. This project is funded 100%n with impact fees (W-EX-147). Capital Outlay - Meter funds (010125) 948 Meters - $110,000 Meter replacement (W-EX-124) i SEWER DEPARTMENT ACCOUNT # 5310 PURPOSE OF THIS DEPARTMENT: Why does this department exist? Maintain and operate the wastewater collection and treatment facility to have a minimum impact on the environment and enhance the quality of life for the community. WWTP DEPARTMENT PERSONNEL: (8.55 FTE) .20 Public Works Director 1 WWTP Manager .10 City Engineer I Assistant WWTP Manager .15 Budget Resource Manager 4 WWTP Operators .10 Administrative Coordinator 2 WWTP Chemists SEWER DEPARTMENT PERSONNEL: (6.55 FTE & 1 Unfunded FTE) .15 Public Works Director .25 Engineering Tech/GIS/IT Support .15 City Engineer 2.5 Sewer Maintenance Technician .15 Budget Resource Manager 1 Vacant/Unfunded Swr Maint. Technician .25 Construction Manager .50 Storm/Sewer Maintenance Supervisor .20 Administrative Coordinator .05 Assessment Coordinator .20 Engineer H .20 Administrative Assistant .05 Road and Fleet Superintendent .25 Accounts Payable Clerk .50 Meter Reader .75 Utility Billing Clerk .25 Finance Director .15 City Accountant GOALS OF THIS DEPARTMENT: What are the departmental goals that support the purpose? WWTP 1. To protect the health of the community by discharging wastewater that meets state and federal regulations. 2. Economically maintain facilities to ensure maximum operational functions and equipment longevity. 3. Maximize secondary use of treatment biosolids. SEWER COLLECTION 1. To ensure conveyance of wastewater in the community to the WWTP 2. Economically maintain facilities for maximum operational functions and equipment longevity. Perform preventative maintenance on sewer conveyance and facilities to ensure optimum system operations. INTENDED OUTCOMES FROM BUDGET EXPENDITURES The wastewater budget provides for routine maintenance and replacement of equipment and piping within the collection system and wastewater treatment plant (WWTP). This year's budget continues the collection system improvements necessary to improve conveyance, lift station communication, collection system reliability, and new equipment to perform cost saving in-house pipe repairs. The WWTP allows for the execution of building maintenance projects, inspections and replacement or repair projects for the secondary digesters, permit compliance for Temperature TMDL and WQ Standards, and alternative review for future bio-solids disposal. SEWER- SANITARY OPERATIONS, BILLING, WASTEWATER TREATMENT FUND: 5310 PROJECTED REVENUE AND FUND SUMMARY estimated proposed ACTUAL BUDGET ACTUAL BUDGET FY15/16 FY16/17 FY15/16 FY17/18 BEGINNING CASH 10100 Operating $2,102,614 $3,101,221 $3,101,221 $3,394,151 10123 SANITARY Sewer Impact Fee Inv. Account $1,646,778 $1,867,844 $1,867,844 $2,373,026 10124 WWTP Impact Fee Inv. Account $463,469 $471,378 $471,378 $607,037W 10125 WTPEquipment Repl/Evergreen $1,221,608 $1,448,800 $1,448,800 $1,548,100 1013x Bond Reserves/Operating reserve $1,299,313 $1,299,313 $1,299,313 $1,156,731 $6,733,782 $8,188,556 $8,188,556 $9,079,045 REVENUES 343310 SEWER SERVICE -billed (10100) $4,642,075 $4,400,000 $4,450,000 $4,425,000 343360 Misc. ; (10100) $20,308 $15,000 $5,000 $10,000 343330 Impact Fee/Hookup-Sanitary (10123) $695,702 $209,000 $703,000 $513,000 343330 Admin Impact Fees Sanitary(10100) $36,616 $11,000 $37,000 $27,000 343335 Impact Fee/Hookup-WWTP (10124) $370,362 $285,000 $494,000 $304,000 343335 Admin Impact Fees WWTP(10100) $19,493 $15,000 $26,000 $16,000 Sanitary Bonded Debt - Westside Interceptor $0 $0 $0 $7,873,808 371010 Interest -operations (10100) $28,000 $30,000 $51,000 $51,000 Interest-WWTP/Evergreen(10125) $10,500 $7,500 $15,500 $15,500 Interest-WWTP Impact Fee Acct. (10124) $4,388 $2,500 $8,500 $8,500 Interest -Sanitary Impact Fee Invest. Acct. (10123) $14,000 $10,000 $25,000 $25,000 Total Revenue $5,841,444 $4,985,000 $5,815,000 $13,268,808 Total Available $12,575,226 $13,173,556 $14,003,556 $22,347,853 EXPENSES EXPENSES FROM RATES Capital Outlay City/Evergreen Funds (10125) Capital Outlay / Bonded Debt - Westside Interceptor Capital Outlay - from Sanitary Impact Fee funds (10123): Debt Service From Sanitary Impact fees (10123): Debt Service From Treatment Impact fees (10124): Depreciation (non cash expense)/Rent FYI Total Expenses Add depreciation other non cash exp 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) $3,747,885 $4,759,515 $4,418,652 $5,069,394 $209,810 $1,452,678 $366,200 $1,577,000 $0 $0 $0 $7,086,427 $535,477 $1,168,232 $269,659 $1,573,000 $95,000 $95,000 $95,000 $95,000 $225,000 $225,000 $225,000 $225,000 $2,245,000 $2,257,844 $2,257,844 $2,245,000 $7,058,172 $9,958,269 $7,632,355 $17,870,822 $2,245,000 $2,257,844 $2,257,844 $2,257,844 $426,502 $450,000 $450,000 $450,000 $3,101,221 $2,812,706 $3,394,151 $2,866,600 $1,867,844 $823,612 $2,373,026 $1,243,026 $471,378 $533,878 $607,037 $694,537 $1,448,800 $453,622 $1,548,100 $436,600 $1,299,313 $1,299,313 $1,156,731 $1,944,112 $8,188,556 $5,923,131 $9,079,045 $7,184,875 10 SEWER - WWTP - BILLING FUND SUMMARY FUND: 5310-454-430620-63 0/455-430640 Personal Services: Sewer billing Sanitary Sewer WWTP & LAB Subtotal Maintenance & Operations: Sewer Billing services Sanitary Sewer WWTP & Lab Subtotal Capital Outlay from rates: Sanitary Sewer Operation WWTP & Lab Subtotal Debt Service from rates: Sanitary Sewer WWTP Subtotal EXPENSE SUMMARY proposed ACTUAL ACTUAL BUDGET BUDGET FY14/15 FY15/16 FY16/17 FY17/18 $87,913 $113,518 $128,760 $126,634 $309,008 $324,710 $341,569 $343,134 $611,199 $649,989 $732,667 $732,116 $1,008,120 $1,088,217 $1,202,998 $1,201,885 $72,476 $106,606 $123,477 $126,938 $352,051 $307,937 $372,304 $595,907 $742,073 $781,324 $933,684 $1,099,L44 $1,166,600 $1,195,867 $1,429,465 $1,821,989 $312,534 $176,196 $788,195 $625,600 $72,288 $0 $40,000 $107,000 $384,822 $176,196 $828,195 $732,600 $1,889 $1,134 $1,646 $1,861 $866,265 $859,967 $860,055 $861,059 $868,154 $861,101 $861,701 $862,920 City/Evergreen Replacement funded from rates: $411,599 $426,502 $450,000 $450,000 Total $3,839,295 $3,747,885 $4,772,359 $5,069,394 Capital Outlay - Other funds: WWTP Bonded Debt $7,823 $0 $0 $0 WWTP (10125) City/Evergreen account $729,364 $209,810 $1,452,678 $1,577,000 Sanitary Bonded Debt $0 $0 $0 $7,086,427 Capital Outlay -from Impact Fee funds: Sanitary Sewer(101<- $664,162 $535,477 $1,168,232 $1,573,000 Debt Service -from Impact Fees SanitarySewer (10123) $95,000 $95,000 $95,000 $95,000 WWTP (10124) $225,000 $225,000 $225,000 $225,000 Depreciation (non-eash item) Sanitary $820,000 $820,000 $820,000 $820,000 Depreciation (non -cash item) WWTP $1,425,000 $1,425,000 $1,425,000 $1,425,000 Total $7,805,645 $7,058,172 $9,958,269 $17,870,822 SEWER - OPERATIONS FUND: 5310-454-430630 EXPENDITURE DETAIL proposed ACTUAL ACTUAL BUDGET BUDGET FY14/15 FY15/16 FY16/17 FY17/18 Personal Services: FTL-'s 5.55 5.55 5.55 5.55 110 Salaries & Wages $239,427 $245,205 $251,377 $252,466 121 Overtime $1,068 $587 $5,500 $5,500 153 Health Insurance $51,223 $58,803 $66,327 $66,485 155 Retirement -PERD $17,290 $20,115 $18,365 $18,683 Subtotal $309,008 $324,710 $341,569 $343,134 Maintenance & Operations: 210 Office Supplies/Equip/ Computer Supplies/GIS 218 Equipment (Non Capital)/Safety Equip & Supplies 229 Other Supplies/Janitorial/Consumable Tools 231 Gas & Oil 312 Postage, Printing & Advertising 341 Electricity 344 Natural Gas 345 Telephone & Comm., Alarms 353 Auditing 354 Contract Services 356 Consultants - Facility Plan/Rate Analysis 362 Equipment Maintenance/Buildings & Radios 373 Dues & Training, Licenses 388 Medical Services 410 Construction Materials 425 Materials - Pumps/Lift Stations 510 Property & Liability Ins 512 $10,000 Uninsured Loss/$15,000 Goodwill Expenditures 521 Central Garage Transfer 522 Administrative Transfer 528 Information Tech. Transfer 532 Office Rent 535 Usage Charge for 100,000 Gallons -Trumble Creek Subtotal $8,290 $6,571 $9,200 $10,200 $6,841 $8,375 $8,350 $8,350 $2,084 $2,308 $2,000 $2,300 $10,831 $7,183 $13,500 $12,000 $50 $489 $400 $500 $49,299 $49,198 $54,500 $54,500 $13,942 $14,010 $16,500 $16,500 $20,793 $22,536 $23,000 $24,000 $3,000 $3,500 $3,000 $3,000 $7,210 $6,873 $24,000 $24,000 $0 $7,500 $8,000 $208,000 $4,613 $2,042 $5,000 $7,000 $1,301 $3,739 $5,500 $5,500 $308 $547 $500 $500 $6,506 $18,458 $9,000 $10,000 $22,196 $9,322 $50,000 $50,000 $58,359 $50,032 $15,791 $36,500 $18,308 $2,438 $25,000 $25,000 $7,287 $7,911 $9,180 $8,575 $59,205 $61,733 $64,461 $64,060 $11,432 $16,750 $19,000 $19,000 $7,838 $6,422 $6,422 $6,422 $32,368 $0 $0 $0 $352,051 $307,937 $372,304 $595,907 12 SEWER - OPERATIONS & Billing FUND: 5310-454-430630 EXPENDITURE DETAIL Capital Outlay: from Rates (10100) 920 Install Lift Station Enclosure 921 Sand/Cold Mix Storage Shed 922 USFS Bldg & Property Acquisition/Repair 940 Machinery & Equipment 947 Hwy 93 N Bypass Utility Relocate 950 Back Up Generator for L.S. 11 951 1st Alley EN Pipe Upsize (34% rate 66% impact fees) 952 Peterson School Alley Replacement 953 Shop Complex Pavement Restoration Carryover 954 Grandview L.S. Relocation & Upsize (50% rate 50% impact fee) 956 Lift Station Communication Upgrade 959 2nd Alley E Replacement 960 Manhole Rehabilitation /Sewer Main Repairs 961 2nd Alley WN -Mont to Calf (66% rates 34% impact fee) 962 Sewer Main Slip Lining Total Capital Outlay 430635 Capital Outlay -Impact Fee funds (10123) 951 1st Alley EN Pipe Upsize (34% rate 66% impact fees) 954 Grandview L.S. Relocation & Upsize (50% rate 50% impact fee) 955 Main & Lift Station Upsize 957 West Side Interceptor Phase I - Carryover &New Appr. 961 2nd Alley WN -Mont to Calf (66% rates 34% impact fee) Total Capital from Impact Fee Funds Capital Outlay: Bonded 957 West Side Interceptor Phase I Debt Service 490204-6xx Debt Service -Principal, Interest, Fiscal Agent Fees 510400-831 Depreciation Expense proposed ACTUAL ACTUAL BUDGET BUDGET FY14/15 FY15/16 FY16/17 FY17/18 $10,688 $3,309 $0 $0 $0 $0 $25,771 $0 $0 $0 $32,978 $0 $0 $0 $0 $92,400 $1,997 $0 $0 $0 $5,765 $0 $0 $0 $87,192 $0 $20,528 $0 $0 $0 $284,000 $0 $0 $0 $30,552 $38,200 $0 $0 $0 $230,000 $16,315 $15,911 $20,000 $20,000 $177,694 $6,253 $0 $0 $12,883 $9,740 $50,000 $50,000 $0 $140,983 $324,366 $0 $0 $0 $0 $195,000 $312,534 $176,196 $788,195 $625,600 $173,965 $0 $34,035 $0 $0 $0 $0 $230,000 $21,777 $0 $100,000 $200,000 $468,420 $462,861 $867,087 $1,143,000 $0 $72,616 $167,110 $0 $664,162 $535,477 $1,168,232 $1,573,000 $0 $0 $0 $7,086,427 $96,889 $96,134 $96,646 $96,861 $820,000 $820,000 $820,000 $820,000 Total Sanitary Sewer Operating Budget $2,554,644 $2,260,454 $3,586,946 $11,140,929 13 SEWER - OPERATIONS & Billing FUND: 5 310-45 4-43 063 0 EXPENDITURE DETAIL proposed ACTUAL ACTUAL BUDGET BUDGET FY14/15 FY15/16 FY16/17 FY17/18 Personal Services: FTE's 1.5 2.0 2.0 2.0 430620 Sewer Billing 110 Salaries & Wages $70,175 $83,974 $91,956 $94,168 153 Health Insurance $12,524 $23,247 $29,868 $25,275 155 Retirement - PERD $5,214 $6,297 $6,936 $7,190 Subtotal $87,913 $113,518 $128,760 $126,634 Materials and Services: 215 Office Supplies/Computers $1,842 $6,112 $2,500 $2,500 353 Auditing $2,920 $2,000 $2,000 $2,000 354 Billing Costs/Grizzly Sec. & Postage $0 $0 $0 $45,000 355 Billing Costs/bank & cc fees, CenturyLink $29,850 $49,593 $70,000 $22,000 356 Billing Costs/Printing $0 $0 $0 $3,000 373 Dues & Training $485 $2,122 $2,500 $2,500 522 Administrative Transfer $6,677 $6,857 $7,055 $10,516 528 Information Tech. Transfer $22,864 $33,500 $33,000 $33,000 532 Office Rent $7,838 $6,422 $6,422 $6,422 Subtotal $72,476 $106,606 $123,477 $126,938 Total Sanitary Sewer Billing Budget $160,389 $220,124 $252,237 $253,572 14 SEWER - OPERATIONS FUND: 5310-454-430630 FY 2018 BUDGET HIGHLIGHTS Line Item Detail: SANITARY SEWER 354 Contract Services-$24,000: Cost of annual contracts; U-dig fees, generator testing/maintenance, coveralls, estimated system repairs. 356 Consultants - $208,000 $8,000 Modeling and reviews $200,000 Facility Plan/Rate Analysis: Update will provide analysis to ensure planning and fund is in place to met growth and regulatory compliance of the sewer collection system. 362 Equipment Maintenance/Iluildings & Radios - $7,000 Increased $2,000 to repair section of security fence at shop complex. Cost shared with Solid Waste, Water, Street, Parks - Total Cost $10,000 373 Dues & Training - $5,500 Proposed technical trainings include, FVCC electrical courses, methods and techniques for grout application in manholes, and sewer camera transporter fundamentals and rebuild course. 425 Materials - Pumps/Lift Stations - $50,000 The City maintains 40 sewer lift stations which contain 80 pumps and motors, numerous drives, check valves and controls. Many of our pumps have reached the end of their service life cycle. In addition to routine maintenance, repairs were mostly associated with pump and motor failures, or level transmission and control malfunctions. This budget accommodates 5-6 major pump replacements a year. W Capital Outlay: from Rates (10100) 940 Machinery & Equipment - $92,400 lik $65,000 Excavator Costs shared w/storm - Total Cost $130,000 $20,000 3/4 Ton Pickup w/Plow and Pipe Rack Scheduled replacement of 2000 Dodge Dakota with 87,000 miles. Costs shared w/storm - Total Cost $40,000 r. $7,400 Robotic Total Station - Costs shared btwn Sewer, Streets, Storm, Public Works, and Water. Total Cost $37,000 -, • r�1 953 Shop Complex Pavement Restoration - Carryover $30,552, New Appropriation $7,648 The project involves replacement of the degraded asphalt surface inside the fenced area of the City Shop Complex and the installation of a new storm water quality treatment device. The asphalt at the City Shop Complex is deteriorated beyond simple patch work and necessitates replacement. The asphalt replacement triggers storm water treatment requirements stipulated by the MS4 permit and promotes good stewardship for clean water discharges to Ashley Creek. Cost shared between/Water, Sewer, Storm, Streets, & Solid Waste - Total Project Cost $191,000 956 Lift Station Communication. Upgrade - $20,000 This multi -year project replaces up to five lift station landline based alarm systems with cell phone web based alarm and data collection. Currently, operators are alerted of lift station failures through landline phones. The proposed Mission Communication System collects necessary facility data that is published through a web based program reviewed daily by operators_ 19 mission units are currently installed and additional units will be purchased and phased into the operational system over the next 5 years (SEW-72). 15 SEWER - OPERATIONS FUND: 5 310-454-430630 FY 2018 BUDGET HIGHLIGHTS Line Item Detail: SANITARY SEWER Capital Outlay: from Rates (10100) Cont. 960 Manhole & Sewer Main Rehabilitation & Replacement - $50,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 review and record the function of manholes and mains. During this review, crews prioritize the potential projects according to the severity of the deterioration. This project also includes allocation to purchase a sectional point repair system to slip line short sections of failing sewer mains. This system utilizes trenchless technology to reline collapsed sections of sewer main under 7 feet in length. The proposed system will reduce contractor costs by performing small repairs in-house with no subsurface excavation (SEW-33). 962 Sewer Main Slip Lining Projects - $195,000 This project involves re -lining failing sewer mains in 5th Alley East from 7th St. to 10th St., 3rd Alley West from 10th St. to 1 lth St., I Ith St. W. from 2nd Alley to 3rd Alley, and 6th Alley WN from Wyoming to Colorado (SEW-19, SEW-30, SEW-69). Capital Outlay - $230,000 from Rates (10100) and $230,000 from Impact Fee Funds (10123) 954 $460,000 - Grandview Lift Station Relocation and Upsize - This project involves relocation, rebuild, and capsizing of the Grandview Lift Station. The relocation of the station will allow for improved layout and an additional pump and motor to ensure station redundancies. Currently this station handles all conveyance flows from the northern portion of the City with no redundant pump availability. The layout is not conducive to efficient operations due to an extremely deep configuration, which does not promote an effective redesign at the current location (SEW-74 - 50% Rate & 50% Growth). Capital Outlay - Impact Fee Funds (10123) 955 Main & Lift Station Upsize -Carryover 100,000 & New Appropriation $100,000 $200,000 - Misc. sewer contract main upsize, facility enlargements, or regional lift station. Increased for potential new development projects in North and South Kalispell (SEW-52). Capital Outlay - from Bond and Impact Fee Funds (10123) Impact Fee Funds -Carryover $750,000 & New Appropriation $393,000 Bonded Debt - $7,086,427 957 West Side Interceptor Phase 1 This project is for the design engineering and construction to install approximately 20,000 lineal feet of sanitary gravity sewer main, a rail road crossing, a highway crossing and other related items. This is the proposed first phase of the West Side Interceptor, extending new main from a connection at 10th Street West and 5th Ave West, west and then north across Three Mite Drive to an area south of Section 35. The design for the project will include growth forecasts; sanitary sewer modeling; topographic, property, and utility surveys; development and negotiations for easements and land acquisition; development of project design plans and specifications; and bidding and negotiation services (SEW-55). WASTEWATER TREATMENT PLANT FUND: 5 310-455-430640 Personal Services: 110 Salaries & Wages 111 Seasonal Salaries 121 Overtime 153 Health Insurance 155 Retirement - PERD Subtotal EXPENSE DETAIL proposed ACTUAL ACTUAL BUDGET BUDGET FY14/15 FY15/16 FY16/17 FY17/18 FTE's 5.55 6.55 6.55 6.55 $346,238 $403,296 $448,865 $448,827 $687 $2,024 $5,000 $5,000 $21,115 $22,961 $22,500 $22,500 $59,423 $74,318 $88,992 $89,216 $26,608 $31,233 $32,463 $32,959 $454,071 $533,832 $597,820 $598,502 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 Consult-Elec Eng/Permit Asst /Optimization & Bio Solid Studies 358 Consultant - TMDL & Facility Plan/Rate Analysis 360 Maintenance Service -Misc. 366 Building Maintenance 373 Dues, Training & Training Materials 388 Medical Services 510 Property & Liability Insurance 521 Central Garage Transfer 522 Administrative Transfer 528 Information Tech. Transfer Subtotal $6,413 $7,603 $10,000 $10,000 $1,362 $839 $2,700 $2,700 $11,324 $11,784 $20,000 $20,000 $15,964 $17,739 $19,000 $45,000 $3,570 $4,259 $7,000 $7,000 $11,807 $8,289 $18,500 $16,000 $259 $197 $350 $350 $6,457 $7,193 $10,000 $10,000 $169,944 $166,497 $178,500 $180,000 $7,549 $6,330 $7,500 $7,500 $47,458 $39,931 $65,000 $60,000 $5,219 $6,171 $5,500 $6,500 $4,000 $2,750 $4,000 $4,000 $123,822 $112,116 $124,000 $124,000 $29,678 $29,473 $30,000 $30,000 $21,575 $57,999 $100,000 $100,000 $6,687 $1,366 $15,000 $125,000 $19,624 $15,371 $30,000 $30,000 $24,590 $48,905 $36,000 $50,000 $3,841 $5,550 $7,500 $7,500 $220 $402 $500 $500 $37,695 $40,699 $34,985 $39,233 $17,519 $12,822 $13,212 $13,842 $116,638 $104,138 $112,237 $122,819 $17,148 $25,125 $27,500 $27,500 $710,363 $733,548 $878,984 $1,039,444 17 WASTEWATER TREATMENT PLANT FUND: 5310-455-430640 EXPENSE DETAIL proposed ACTUAL ACTUAL BUDGET BUDGET FY14/15 FY15/16 FY16/17 FY17/18 430640 Capital Outlay: Operating Funds 920 Roof & Lighting FY15; T-Was Roof Replc FYI 921 Evergreen Sewer Sampling Equipment & Bid 940 Coat Basin FY15; Boiler/Heat Exchange Overhaul Subtotal 430644 Capital Outlay: Bonded 935 Construction Digester Lid 430645 WWTP Replacement Funds:Evg (10125) 362 Equipment Maintenance 920 R.A.S Bid & Storage Warehouse Roof Replcmnt 933 Solid Dewatering Carryover 934 Secondary Digester Lid FY16 Inspection;FY17 Design 936 Digested Sludge Line Replacement 937 Sand Filter Maintenance & Replacement Carry 940 Machinery & Equipment Subtotal. 4902xx-6x Debt Service 831 Replacement Reserve -Evergreen Depreciation Expense (non cash) Subtotal WWTP 430646 Laboratory Operations Personal Services: FTE's 110 Salaries & Wages 153 Health Insurance 155 Retirement - PERD Subtotal Maintenance & Operations: 210 Office Supplies/Computers/other Supplies/Shipping 218 Equipment 222 Lab Supplies 349 Lab services /Permit & Pretreatment Testing 362 Equipment Maintenance 373 Dues & Training, Licenses Subtotal Subtotal Laboratory Total Treatment Plant $55,783 $0 $0 $32,000 $0 $0 $40,000 $0 $16,505 $0 $0 $75,000 $72,288 $0 $40,000 $107,000 $7,823 $0 $0 $0 $58,454 $74,328 $100,000 $100,000 $0 $0 $40,000 $0 $508,383 $82,426 $100,000 $99,000 $0 $0 $531,500 $900,000 $0 $1,322 $298,678 $0 $0 $0 $200,000 $200,000 $162,527 $51,734 $182,500 $278,000 $729,364 $209,810 $1,452,678 $1,577,000 $1,091,265 $1,084,967 $1,085,055 $1,086,059 $411,599 $426,502 $450,000 $450,000 $1,425,000 $1,425,000 $1,425,000 $1,425,000 $4,901,773 $4,413,659 $5,929,537 $6,283,005 2.0 2.0 2.0 2.0 $121,616 $92,285 $106,284 $108,136 $26,744 $17,375 $20,932 $17,614 $8,769 $6,497 $7,630 $7,864 $157,129 $116,157 $134,947 $133,614 $1,724 $2,1 l5 $4,500 $4.500 $1,769 $688 $2,500 $2,500 $8,058 $14,346 $9,500 $14,500 $16,382 $24,429 $29,000 $29,000 $2,141 $4,480 $5,500 $5,500 $1,636 $1,718 $3,700 $3,700 $31,710 $47,776 $54,700 $59,700 $188,839 $163,933 $189,547 $193,314 $5,090,612 $4,577,592 $6,119,085 $6,476,319 18 WASTEWATER TREATMENT PLANT FUND: 5 310-45 5 -4 3 064 0 FY 2018 BUDGET HIGHLIGHTS Line Item Detail - Wastewater Treatment Plant 226 Chemicals - $45,000 The increase is needed for additional polymer usage. Smooth and consistent solids balance in plant operations is achieved by sustained dewatering operation. Changing dewatering operation from 6 hrs. per day/5 days per week to 12 hrs. per dayn days per week has resulted in additional polymer usage. 344 Natural Gas - $60,000 Reduced $5,000. Additional funds were allocated until we could see the impact new equipment had on the operations of the plant. 355 Other Contract Services - $30,000 Rag /grit and landfill biosolids disposal fees and other contract services. 356 Consultant -Electrical Engineer, Permit Compliance & Bin Solids Study - $100,000 $20,000 Electrical Engineer - 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. $50,000 - Permit Compliance: Optimization Study &Temperature Monitoring/Evaluation - The future implementation of numeric water quality standards and Flathead Lake TMDL by MDEQ will limit the amount of nutrients discharged from the WWTP. Kalispell is unable to meet the required nutrient limits, and was issued a general nutrient standard variance as outlined in SB 367. The new permit requires dischargers receiving a variance to perform an optimizing study. The optimization study requires evaluation of the current facility operation to optimize nutrient reduction with existing infrastructure and analyzes cost-effective methods of reducing nutrient loading, including but not limited to nutrient trading without substantial investment in new infrastructure. The analysis is to include cost-effective methods of reducing nutrient loading without substantial investment in new infrastructure, there should not be structural changes, and there should not be an increase in rates. MDEQ's expectation is the study be performed by a third party professional engineer specializing in wastewater nutrient removal processes, and includes modeling of alternative plant configuration and operation scenarios to determine if operational modification could be made to achieve better nutrient removal performance. The study must also explore the feasibly of nutrient trading within the watershed. Temperature Monitoring: The city of Kalispell has been issued a new waste water discharge permit from MT. D.E.Q. in Aug. 2015. The permit mandates the development of a temperature and flow monitoring plan for instream and effluent discharge. The monitoring plan has been submitted, approved, and implementation of the plan will begin on July 1, 2016. This new mandate is in response to the state adopted Temperature TMDL for Ashley Creek. $30,000 - Bio Solids Disposal Study - As the City approaches the capacity of the Glacier Gold Composting facility of 600 dry/tons per year we need to explore alternative means of sludge disposal. These funds would be used to research alternative disposal options. 358 Consultants- Total Maximum Daily Load (TMDL) / Permit - $25,000 and Facility Plan Update - $100,000 The State of Montana is under Federal Court order to develop a TMDL for pollutants flowing from the Flathead basin into Flathead lake. TMDL restrictions will have some consequences for the City's historical ability to discharge waters to Flathead tributaries and its community wastewater to Ashley creek. 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 a WWTP Facility Plan Update and Rate Analysis. The last Facility Plan Update for WWTP is 9 years old, an update is needed to review planning, alternatives to meet Kalispell's 20 year nutrient variance for DEQ. a WASTEWATER TREATMENT PLANT FUND: 5 310-4 5 5 -4 3 0640 FY 2018 BUDGET HIGHLIGHTS Line Item Detail - Wastewater Treatment Plant 366 Building Maintenance - $50,000 $30,000 - Lift Station Interior Building Painting . The Lift Station was part of the 1992 plant upgrade and to date the interior walls have never been painted. The last 25 years have taken a toll on the walls as the paint is peeling and the piping is rusting. $10,000 - Primary Digester Stairway. The access ladder to the primary digester roof is very difficult to climb while performing regular maintenance creating a potential safety concern. The addition of a stairway would allow safe access. $10,000 - Misc. building repairs and maintenance to multiple WWT buildings. 430640 Capital Outlay - Operating Funds 920 T-WAS Tank Roofing Replacement - $32,000 The T-Was Tank roofing liner was originally installed in 1992 and the roof liner is completely destroyed by U.V. and no longer provides rain/weather protection to the shared electrical equipment in the digester basement. 940 Digester Sludge Heat Exchanger Overhaul and Main Boiler Replacement-$75,000 The heat exchanger is used to heat the primary digester sludge. It was originally installed in 1984 and is in need of repairs. The last 32 years of pumping sludge has wom out the internal piping. This project is for the overhaul of internal piping. The main boiler internal fire tubes are leaking due to the corrosive environment of the methane gas. The boiler is thirteen years old and replacement parts are obsolete. 430645 Capital Outlay - Replacement Funds 362 Equipment Maintenance - $100,000 -The WWT plant maintains along list of equipment some of which includes 76 pumps, 210 valves, air compressors, gas boilers, sand filters, air blowers, fans, motors etc. The original 1992 plant is reaching the expected life span of 25 years and therefore increases in equipment replacement, rehabilitation, and maintenance is expected. Most of the smaller pump replacement costs range in $12,000 - $15,000 range. The larger digester mixer pumps cost $50,000 and an air blower replacement costs would exceed the $125,000 range. 933 Solids Dewatering Design & Construction - Carryover $99,000 The 2008 Facility Plan Update included $1.9 million to update the Solids Dewatering in Phase 3 of the AWWTP Expansion. The installation of 1 new screw press is a portion of the suggested improvements to replace 1 of 2 belt filter press. The carryover would purchase a 3rd screw for our current 2 screw dewatering equipment. After several years of operation we have been able to determine that extended operations of the new screw press is more beneficial to plant solids management. The addition of a 3rd screw to our new screw press would allow for smoother continuous operations resulting in higher percent solids removal (WWTP-1715). 934 Secondary Digester Lids Replacement - FY18 Carryover 500,000; New Appropriation $400,000 The Secondary Digester lids were originally installed in 1992. The steel floating lids were protective coated in 1997 due to the corrosive environment. The coatings were designed to last 10 + years, and the coating/metal are now showing signs of rusting. An inspection by a qualified coating and structural expert was performed. Budget for this project includes design and coating of the TWAS and secondary digesters as determined from the inspection analysis report (WWTP-1711). a WASTEWATER TREATMENT PLANT FUND: 5310-455-430640 FY 2018 BUDGET HIGHLIGHTS Line Item Detail - Wastewater Treatment Plant 430645 Capital Outlay - Replacement Funds Continued 937 Sand Filters Maintenance and Replacement - FY18 Carryover $200,000 This project involves replacement of eroded away and displaced sand, and the replacement and rehabilitation of the filter units in order to improve functionality. After 24 years of service the sand filters are worn, cracked, and no longer operate at optimum capacities. Engineering support will be required for rehabilitation which will be detemuned once the filters are inspected (WWTP-1608). 940 Machinery & Equipment Replacement Fund - FY18 Carryover 178,000; New Appropriation $100,000 $33,000 Lift Pump Replacements 4 $15,000 Digested Sludge Valve - 3 Way i; $200,000 - Secondary Clarifier Covers - North & South to eliminate algae growth (WWTP-1607)_ Carryover $100,000; New Appropriation $100,000 $30,000 - Primary Digester Inspection and cleaning Laboratory Operations: 222 Lab Supplies - $14,500 Increased $5,000 to meet actual costs. The increased costs is due to additional testing and sampling requirements by DEQ. We are also replacing older glassware and equipment. 349 Lab Services/Permit & Pretreatment Testing - $29,000 Pretreatment Program: The City of Kalispell was issued a wastewater discharge permit from the Department of Environmental Quality in 2015. The permit mandates increased sampling parameters and analysis from the treatment facility influent and effluent for the presence of toxic pollutants as a part of the pretreatment program. 21 STORM SEWER ACCOUNT # 5349-453 PURPOSE OF THIS DEPARTMENT: Why does this department exist? The purpose of this department is to provide for a means of storm water conveyance to designated storm water management areas and outfalls, thus reducing the localized and undesirable occurrence of storm water ponding. Responsibilities also include implementation of the Storm Water Management Program to minimize pollutant run off to waterbodies in accordance with State and Federal Regulations. DEPARTMENT PERSONNEL: (6.20 FTE) .10 Public Works Director .25 Senior Civil Engineer (City Engineer) .15 Budget Resource Manager .25 Construction Manager .10 Administrative Coordinator .20 Project Manager (Engineer H) .05 Road and Fleet Superintendent .20 Assessment Coordinator .60 Assistant Civil Engineer (Engineer 11) .25 Engineering Tech/GIS/IT Support .20 Administrative Assistant .50 Storm/Sewer Maintenance Supervisor 2.5 Storm Maintenance .25 Special Street Maintenance Operator .20 General Laborer .40 Utility Management Superintendent GOALS OF THIS DEPARTMENT: What are the departmental goals that support the purpose? 1. To maintain and operate the storm water collection, detention, and treatment facilities for the conveyance of storm water. 2. Implement requirements of the Municipal Separate Storm Sewer System Discharge Permit (MS4). INTENDED OUTCOMES FROM BUDGET EXPENDITURES The FYI budget for Storm Sewer recommends continuation of capital projects to improve conveyance of a deteriorated system, improve water quality, and improve the function of a regional detention facility. The budget also provides for several improvements for storm water conveyance systems within the community, at the City's Shop Complex and supports the development/implementation of the MS4 Storm Water Management Permit requirements. STORM SEWER FUND: 5349-453-430246 PROJECTED REVENUE AND FUND SUMMARY BEGINNING CASH 10I00 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 Total Cash REVENUES 343370 Storm Assessments -billed (10100) Assessments -designated for equipment (10190) Assessments -designated for capital projects (10193) Bonded Debt 334040 Petro Tank/Monitory Reimbursement (10100). 343035 Permit fees & other Charges for Service (10100) 362010 Litigation Settlement 363040 Penalty & Interest (10100) 371010 Interest (10100) 343033 Impact Fees (10120) Impact Fee 5% Admin (10100) Total Revenue Total Available EXPENSES EXPENSES FROM RATES (10100) Capital Outlay -impact fee (10120) Capital Equipment -replacement (10190) Capital Outlay - Bonded Debt Depreciation (non -cash expense) Total Expenses add back depreciation/other 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 estimated proposed ACTUAL BUDGET ACTUAL BUDGET FY15/16 FY16/17 FY16/17 FY17118 $1,107,326 $1,448,231 $1,448,231 $1,217,046 $1,160,924 $1,337,938 $1,337,938 $1,580,438 $140,000 $140,000 $140,000 $140,000 $25,000 $25,000 $25,000 $25,000 $91,186 $131,186 $131,186 $171,186 $65,844 $115,844 $115,844 $0 $2,590,280 $3,198,199 $3,198,199 $3,133,670 $761, I45 $760,000 $777,000 $780,000 $40,000 $40,000 $40,000 $40,000 $50,000 $50,000 $50,000 $50,000 $0 $382,000 $59,806 $227,536 $4,800 $2,500 $4,100 $2,500 $9,425 $1,000 $1,000 $1,000 $135,390 $0 $0 $0 $1,568 $1,000 $1,800 $1,200 $19,290 $18,000 $25,000 $18,000 $254,761 $142,500 $237,500 $237,500 $13,408 $7,500 $12,500 $12,500 $1,289,787 $1,404,500 $1,208,706 $1,370,236 $3,880,067 $4,602,699 $4,406,905 $4,503,906 $599,121 $1,472,303 $1,219,851 $1,621,007 $82,747 $130,000 $0 $230,000 $0 $43,000 $0 $135,400 $0 $382,000 $59,806 $208,478 $285,000 $285,000 $285,000 $285,000 $966,868 $2,312,303 $1,564,657 $2,479,885 $285,000 $291,422 $291,422 $291,422 $1,448,231 $938,194 $1,217,046 $436,718 $1,337,938 $1,350,438 $1,580,438 $1,587,938 $140,000 $140,000 $140,000 $140,000 $25,000 $25,000 $25,000 $25,000 $131,186 $128,186 $171,186 $75,786 $115,844 $0 $0 $50,000 $3,198,199 $2,581,817 $3,133,670 $2,315,442 22 STORM SEWER FUND: 5349-453-430246 EXPENSE DETAIL proposed ACTUAL ACTUAL BUDGET BUDGET FY14/15 FY15/16 FY16/17 FY17/18 Personal Services: 6.20 6.20 6.20 6.20 110 Salaries & Wages $322,178 $349,017 $360,758 $363,928 121 Overtime $946 $618 $4,000 $4,000 153 Health Insurance $63,729 $71,255 $81,030 $80,874 155 Retirement $23,408 $25,629 $26,448 $27,008 Subtotal $410,261 $446,519 $472,236 $475,810 Maintenance & Operations: 210 Office Supplies/Equip/Computer/GIS $8,038 $4,602 $10,100 $12,100 218 Equipment (non capital)/ Safety Equip & Supplies $4,151 $2,559 $6,550 $6,550 229 Other Supplies/Consumable Tools $550 $36 $2,200 $2,200 231 Gas & Oil $10,670 $6,900 $11,500 $11,500 345 Telephone & Communication $504 $862 $800 $900 353 Auditing $2,340 $1,650 $2,340 $1,150 354 Contract Services $2,351 $4,107 $6,000 $6,000 356 Stormwater Reg Compliance Program/Permit $14,057 $25,312 $35,000 $35,000 357 Impact Fee Update (Carryover) $0 $8,704 $50,000 $15,000 358 Consultants $0 $0 $7,000 $7,000 359 GonsultantsfrMDL / Permit $6,687 $9,603 $15,000 $15,000 360 Repair & Maint Services $1,912 $1,780 $2,500 $2,500 362 Groundwater Monitoring $2,181 $4,606 $6,500 $5,000 371 Curb & Gutter $4,316 $3,949 $7,000 $7,000 373 Dues & Training $896 $3,307 $5,500 $5,500 388 Medical Services $0 $196 $100 $100 410 Construction Materials $3,047 $1,770 $10,000 $10,000 510 Liability Ins. ($15,000; $5,000 uninsured loss) $4,918 $5,554 $10,000 $20,000 521 Central Garage Transfer $7,287 $7,911 $9,180 $8,575 522 Administrative Transfer $34,352 $35,523 $39,752 $44,3.50 528 Information Tech Transfer $8,574 $12,562 $13,000 $13,000 530 Lease PaymentsBNSF $5,541 $4,688 $5,900 $5,900 532 Office Rent $7.838 $6,422 $6,422 $6,422 Subtotal $110,210 $152,602 $262,344 $240,747 Debt Service 6I0/620 Principal, Interest, Fiscal Fees $0 $0 $0 $30,000 23 STORM SEWER FUND: 5349-453-430246 EXPENSE DETAIL-Con't. proposed ACTUAL ACTUAL BUDGET BUDGET FY14/15 FY15/16 FY16/17 FY17/18 430246 Capital Outlay: from rates (10100) 921 Sand/Cold Mix Storage Shed 951 9th St. E. Impry FY15; 2 Mi. Dr. Drainage Impr FY18 952 Storm Drain Correction Funds 953 Willows Prj FYI 5; Shop Complex Pavement Restoration Car. 954 S. Meadows Phase 1-Fy12; Phase2-FY I 3,Phase3 -FY 14 955 Sylvan Dr Repair Phase 1 -FYI 8 Carryover & New Appr. 969 4th Ave East Replace - Non Bonded Portion Subtotal Capital Outlay: Bonded 969 4th Ave East Replace - FYI Carryover 430248 Capital Outlay: Impact Fee $ (10120) 960 Stormwater Facility Upsizing Subtotal 430249 Capital Outlay: from Replacement $ (10190) 840 Machinery & Equipment-MAC1 Match FY 18 Carryover 940 Machinery & Equipment Subtotal 510400 831 Depreciation: Total $0 $0 $25,771 $0 $204,672 $0 $0 $250,000 $90,352 $0 $100,000 $100,000 $5,067 $0 $30,552 $38,200 $231,026 $0 $0 $0 $0 $0 $581,400 $390,000 $0 $0 $0 $96,250 $531,117 $0 $737,723 $874,450 $0 $0 $382,000 $208,478 $0 $0 $130,000 $230,000 $0 $0 $130,000 $230,000 $3,796 $0 $0 $0 $43,000 $0 $43,000 $92,400 $3,796 $0 $43,000 $135,400 $285,000 $285,000 $285,000 $285,000 $1,360,384 $884,121 $2,312,303 $2,479,885 24 STORM SEWER FUND: 5349-453-430246 FY 2018 BUDGET HIGHLIGHTS Line Item Detail: STORM SEWER FUND 210 Office Supplies/Equip/Computer/GIS - $12,100 Increase is needed to meet the computer replacement schedule, annual software needs, and includes funds to upgrade cabling, switches, and fiber for the network at the City shops. 356 Stormwater Regulatory Compliance Program/Permit Fees - $35,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) Storm drain ID decals, 4) Car wash equipment, 5) Good housekeeping BMPs, 6) Site inspection and enforcement for post construction structural BMPs, 7) Illicit discharge monitoring and removal. Stormwater permit consultant fee provides technical support with the MS4 required implementation and Kalispell's portion to develop the MS4 Water Quality.. 430246 Capital Outlay: from Rates (10100) 951 Two Mile Drive Drainage Improvement from Hawthorn to Meridian - $250,000 This project replaces approximately 360' of varying sized culverts and 750' of ditch restoration along 2 Mile Dr. The project begins at a storm inlet in the west intersection of Hawthorn Dr. continues east in the north ROW until ditch flow is piped under 2 Mile and Glenwood. Ditch flow is resumed on the east side of Glenwood until the point of a CMP inlet at the FWP parking lot entrance. Existing culverts and drainage ditches are improperly graded and undersized. This project will provide proper conveyance of stormwater from the ROW and property to the stormwater system in Meridian, and alleviate flooding issues with residents (STX-43). 952 Storm Drain Correction - $100,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. Projects include: • Areas in sections of the City that have extensive ponding at the intersection caused from rain events. Improve curb and gutter flow to eliminate ponding and deterioration of pavement. 953 Shop Complex Pavement Restoration - Carryover $30,552, New Appropriation $7,648 The project involves replacement of the degraded asphalt surface inside the fenced area of the City Shop Complex and the installation of a new storm water quality treatment device. The asphalt at the City Shop Complex is deteriorated beyond simple patch work and necessitates replacement. The asphalt replacement triggers storm water treatment requirements stipulated by the MS4 permit and promotes good stewardship for clean water discharges to Ashley Creek. Cost shared between/Water, Sewer, Storm, Streets, & Solid Waste - Total Project Cost $191,000 25 STORM SEWER FUND: 5349-45 3-430246 FY 2018 BUDGET HIGHLIGHTS 430246 Capital Outlay: from Rates (10100) Continued 955 Sylvan Drive Stormwater Repair Phase 2 -New Appropriation $390,000 The Sylvan Drive stormwater system services a large drainage basin in the west and northwest areas of Kalispell. The system consists of large stormwater pipes, manholes and a detention facility that discharges to the natural drainage backwater channel of the Stillwater River. This project continues from phase 1 and rehabilitates the detention facility, slope stabilization, and outfall structure to ensure compliai with the MS4 Stormwater permit (STX-39). Capital Outlay: from Bonded Debt and Rates 969 4th Avenue East Stormwater Replacement - Carryover $208,478 Bonded Debt and $96,250 Rates This is a stormwater drainage improvement project which will be designed in-house and the construction coordinated with the 14 block water main and road reconstruction on 4th Ave E from Center St to 14 St E. 4th Ave E's storm drain and piping infrastructure is deteriorated and the conditions necessitate reconstruction and additional stormwater piping/manhole improvements (STX-54). 430248 Capital Outlay: from Impact Fees (10120) 960 Stormwater Facility Upsizing - $230,000 $230,000 - Misc. Stormwater contract main upsize, and or facility enlargements. Increase due to potential new development in West Kalispell. 430249 Capital Outlay: from Replacement (10190) 840 MACI Grant Match - $43,000- operating transfer to MACI grant - FY18 Carryover 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 a new street sweeper (replacing a 2009 model) in order to continue to support the City's Stormwater Management Program. As a permitted Municipal Separate Storm Sewer System (MS4), the City of Kalispell is required to develop controls in order to reduce or eliminate the discharge of pollutants from streets, roads, highways, municipal parking lots, maintenance and storage yards, vehicle fleet or maintenance shops with outdoor storage areas, salt/sand storage locations, and snow disposal areas operated by the permittee. As part of the Stormwater Management Program, a Street Sweeping Program has been developed to meet permit requirements. By implementing the Street Sweeping Program and performing routine street sweeping, the City is able to meet permit requirements by collecting sediments, metals, organics, and oil and grease wastes that would otherwise be transported by stormwater runoff to surface waters. 940 Machinery & Equipment - $92,400 $65,000 Excavator for sewer/storm. Cost shared with sewer - Total Cost $130,000_; $20,000 Service Truck w/Plow for sewer/storm. Cost shared with sewer - Total Cost $40,000 tZi $7,400 Robotic Total Station. Costs shared btwn Storm, Streets, Public Works, Sewer, and Water. Total Cost $37,000 26 SOLID WASTE ACCOUNT # 5510-460 PURPOSE OF THIS DEPARTMENT: Why does this department exist? The Solid Waste Department collects and disposes of solid waste material from residential and commercial entities to provide a cleaner and healthier condition for the City of Kalispell. DEPARTMENT PERSONNEL: (7.40 FTE) .10 Public Works Director .15 Budget Resource Manager .20 Assessment Coordinator .20 Administrative Coordinator .30 Road and Fleet Superintendent .20 Administrative Assistant .15 Project Manager (Engineer II) 5 Solid Waste Operators 1 Solid Waste Supervisor .10 General Laborer GOALS OF THIS DEPARTMENT: What are the departmental goals that support the purpose? Collect, handle, and transport solid waste in a safe and effective manner. 2. Provide solid waste services to the community of Kalispell in a respectable and reliable manner. INTENDED OUTCOMES FROM BUDGET EXPENDITURES The FY18 expenditures promotes the continuation of solid waste collection and transport operations to service existing and new residential/commercial customers while maintaining a high level of service. Equipment replacement expenditures include the repair of the backup rear loader to extend it's service life until it's schedule replacement. This years budget includes GPS tracking units on three solid waste trucks that will track daily traveling, routes, and speed. Real time location and route tracking by receptionists/supervisors enhances customer service response and improves operation efficiency. SOLID WASTE FUND: 5 510-460-430840;430845 PROJECTED REVENUE AND FUND SUMMARY BEGINNING CASH 10100 Cash: Operating 10120 Replacement Account Total Cash REVENUES 343410 Assessments 343420 garbage collections billed (part year) 363040 Penalty & Interest 371010 Interest Earnings 343360 Misc./Sale of Asset(fyl7) Total Revenue Total Available EXPENSES Total Expenses from Rates (10100) CapitalOutlay-Replacement (10120) *Depreciation/Replacement Fund Total Expenses add back transfer to replacement account add back prepaid rent ENDING CASH 10100 Operating 10120 Replacement Account Total Cash estimated proposed ACTUAL BUDGET ACTUAL BUDGET FY15/16 FY16/17 F'Y16/17 FY17/18 $828,089 $849,758 $849,758 $863,780 $230,839 $117,480 $117,480 $219,480 $1,058,928 $967,238 $967,238 $1,083,260 $944,444 $955,000 $974,000 $975,000 $21,837 $21,500 $30,000 $25,000 $2,086 $2,100 $2,800 $2,100 $6,109 $6,000 $8,000 $8,000 $7,696 $0 $15,800 $0 $982,172 $984,600 $1,030,600 $1,010,100 $2,041,100 $1,951,838 $1,997,838 $2,093,360 $810,503 $1,048,620 $973,000 $1,047,488 $263,359 $48,000 $48,000 $20,000 $150,000 $150,000 $150,000 $150,000 $1,223,862 $1,246,620 $1,071,000 $1,217,488 $150,000 $150,000 $150,000 $150,000 $6,422 $6,422 $6,422 $849,758 $642,160 $863,780 $682,814 $117,480 $219,480 $219,480 $349,480 $967,239 $861,640 $1,083,260 $1,032,294 27 SOLID WASTE FUND: 5510-460-430840:4 30845 EXPENSE DETAIL proposed ACTUAL ACTUAL BUDGET BUDGET FY14/15 FY15/16 FY16/17 FY17/18 Personal Services: FTE's 110 Salaries & Wages 112 Severance 121 Overtime/Call Outs 153 Health Insurance 155 Retirement - PERD Subtotal Materials and Services: 213 Office Equip/ Computer Equip & Supplies 218 Non Capital Equip.- Garbage Containers 229 Other Supplies/Safety Equip/Consumable Toe 231 Gas and Oil 341 Electricity 344 Natural Gas 345 Telephone 354 Contract Services 362 Equipment Maint. & Supplies/Radios 366 Building Maintenance 373 Dues & Training 388 Medical Services 510 Property & Liability Ins. 512 Uninsured Loss - Deductible 521 Central Garage Transfer 522 Administrative Transfer 528 Information Tech. Transfer 532 Office Rent Subtotal 430845 Wash Bay/Materials & Services 224 Janitorial Supplies 341 Electricity 342 Water 344 ]Natural Gas 360 Repair/Maint Services/Building Maint Subtotal 7.40 7.40 7.40 7.40 $372,599 $392,983 $399,776 $409,153 $0 $0 $60,455 $60,455 $4,863 $4,490 $5,500 $6,500 $80,796 $90,146 $106,280 $96,542 $26,942 $28,718 $28,993 $30,045 $485,200 $516,327 $601,004 $602,695 $5,970 $4,510 $9,500 $9,500 $28,282 $19,480 $35,000 $37,500 $3,035 $2,586 $5,500 $5,500 $47,761 $31,223 $60,000 $55,000 $1,353 $1,341 $1,950 $2,050 $3,211 $2,632 $4,900 $4,500 $695 $1,246 $850 $1,250 $5,008 $11,283 $9,000 $11,500 $2,206 $1,245 $5,700 $5,700 $119 $1,186 $2,500 $4,500 $722 $3,856 $3,500 $3,500 $835 $373 $650 $650 $9,218 $10,570 $6,799 $13,500 $700 $4,927 $4,000 $4,000 $59,786 $61,388 $76,104 $69,786 $33,484 $33,186 $37,311 $43,247 $8,574 $12,562 $12,513 $12,513 $7,838 $6,422 $6,422 $6,422 $218,797 $210,016 $282,199 $290,618 $74 $79 $250 $300 $2,097 $2,107 $3,500 $3,500 $241 $1,372 $2,000 $2,000 $3,529 $3,061 $6,500 $6,000 $501 $2,771 $3,500 $23,500 $6,4442 $9,390 $15,750 $35,300 28 SOLID WASTE FUND: 5510-460-430840;430845 EXPENSE DETAIL proposed ACTUAL ACTUAL BUDGET BUDGET FY14/15 FY15/16 FY16/17 FY17/18 430840 Capital Outlay 820 Alley Paving - transfer to Gas Tax $25,000 $35,000 $35,000 $40,000 922 USFS Bldg & Property Acquisition/Rep. $0 $0 $43,971 $0 953 Shop Complex Pavement Restoration $0 $0 $30,552 $38,200 Subtotal $25,000 $35,000 $109,523 $78,200 430840 Capital Outlay: Replacement Funds (10120) 940 Machinery & Equipment $0 $0 $48,000 $0 944 Refurbish Garbage Truck Floor $80,598 $263,359 $0 $20,000 Subtotal $80,598 $263,359 $48,000 $20,000 600 Debt Service - Garbage Truck $20,003 $39,770 $40,144 $40,675 510400 Depreciation (fund Replacement account $150,000) 831 Depreciation Expense $150,000 $150,000 $150,000 $150,000 Total $986,040 $1,223,862 $1,246,620 $1,217,488 m SOLID WASTE FUND: 5510-460-430840430845 FY 2018 BUDGET HIGHLIGHTS Line Item Detail: Solid Waste 218 Non -Capital Equipment - $37,500 $35,000 Garbage Containers $2,500 GPS Vehicle Tracking. GPS tracking will enable the City to provide better customer service, evaluate our routes and manage our system in a more efficient manner. 231 Gas & Oil - $55,000 Reduced $5,000 to reflect actuals and an estimated diesel fuel increase for FY 18. 366 Building Maintenance - $4,500 Increased $2,000 to repair a damaged section of security fence at shop complex. Cost shared with Sewer, Water, Street, Parks. Total Cost $10,000 Capital Outlay: 820 Alley Paving - $40,000 Increased $5,000 - Pave approximately six alleys and perform maintenance on existing paved alleys. Paved alleys enable garbage trucks better access to containers, improving operation efficiency, and the alleys are easier to maintain in the winter and summer months. 953 Shop Complex Pavement Restoration - Carryover $30,552, New Appropriation $7,648 The project involves replacement of the degraded asphalt surface inside the fenced area of the City Shop Complex and the installation of a new storm water quality treatment device. The asphalt at the City Shop Complex is deteriorated beyond simple patch work and necessitates replacement. The asphalt replacement triggers storm water treatment requirements stipulated by the MS4 permit and promotes good stewardship for clean water discharges to Ashley Creek. Cost shared between/Water, Sewer, Storm, Streets, & Solid Waste - Total Project Cost $191,000 430845 Line Item Detail: Solid Waste Wash Bay 360 Repair/Maintenance Services/Building Maintenance - $23,500 $20,000 Increase Height on Wash Bay Door by 2'. It is important to keep equipment clean for appearance and maintenance purposes. There are several pieces of City equipment that either do not fit or barely fit into the wash bay. Increasing the height 2' would allow for safer access and enable all of our equipment to utilize the facility. $3,500 - Misc Maintenance Capital Outlay: Replacement funds (10120) 944 Refurbish Garbage Truck Floor - $20,000 The back half of the rear loader's floor has rusted thru and is leaking. The rear loader has been in the fleet for seventeen years and is not scheduled to be replaced until 2020. Replacing the floor will extend the life of this unit to its scheduled replacement and will provide a higher resale value, enabling us to recoup most of our investment. The chassis on this unit is in good shape and is worth running for a few more years. 30