Loading...
6. Public UtilitiesPUBLIC UTILITIES Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department Public Utilities Department Total Full-Time Equivalents (FTE) = 524.00 Organizational Chart County Water-Sewer District Total Full-Time Equivalents (FTE) = 414.00 Solid & Hazardous Waste Management Division Total Full-Time Equivalents (FTE) = 46.00 Facilities Management Division Total Full-Time Equivalents (FTE) = 64.00 Fiscal Year 2018 1 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department George Yilmaz, Department Head The mission of the Public Utilities Department (Department) is to deliver best value, high quality, sustainable services that meet the expectations of our customers, citizens and visitors in an operationally excellent environment. The Department is composed of two enterprise funds, including the Collier County Water-Sewer District (CCWSD) and Solid and Hazardous Waste Management, as well as the Facilities Management Division which is funded through ad valorem taxes. To meet the requirements of providing both demand and compliance driven essential services, the Department must maintain an appropriate level of both physical and financial resources. The Department prioritizes resource requirements through a unified focus on revenue-centric, risk-based decision making to ensure the most critical infrastructure receives the rehabilitation and maintenance necessary to meet operational and compliance requirements. The Department comprises eight Divisions: Department Administration, Financial and Operations Support, Utilities Engineering and Project Management, department wide Technical Support and Logistics, Water, Wastewater (collectively the CCWSD), Solid and Hazardous Waste Management and Facilities Management. Collier County Water-Sewer District The Collier County Water-Sewer District is an independent special district created by the Florida Legislature, with the Board of County Commissioners (Board) serving as Ex-officio the Governing Board of the Collier County Water-Sewer District. Charges for services received for potable drinking water production and distribution, wastewater collection and treatment and Irrigation Quality (IQ) water provide the sole financial resources required to pay for operational and maintenance expenses, the renewal and replacement of existing infrastructure capital improvement program (CIP), meet existing debt service requirements and bond covenants, and to sustain compliance with stringent environmental and public health regulations. Leading indicators point to increasing resource needs to meet service level demands. Growth in the CCWSD infrastructure conveyed by developers increased rapidly in FY16, and has been sustained into FY17. Continuation of these trends into FY18 will place additional compliance and service demands on resources. Increasing needs to repair and rehabilitate aging utility infrastructure has increased the proposed FY18 Capital Improvement Program by more than 36 percent. In lieu of a formal user rate study, the user rates for water, wastewater and IQ water services will be adjusted by 2.9% in accordance with Board approved budget guidelines for consumer price index adjustments. Gradual rate adjustments keep pace with inflation and prevent future rate shock. A formal request for these adjustments will be brought to the Board at future scheduled meetings for advertisement and approval. There is no income from taxpayer general revenues. The CCWSD delivers basic, indispensable life sustaining services on demand 24 hours a day, 365 days a year, including holidays. Appropriate resourcing of the Department’s mission ensures services are delivered timely, at a level that meets consumer demand, and is in compliance with regulatory standards, permit requirements, and the collective mandates of various federal, state, and local regulations (e.g., the Clean Water Act, the Safe Drinking Water Act, Department of Homeland Security, etc.). The CCWSD is assessed a revenue-based, industry standard Payment in Lieu of Property Taxes (PILT) transfer to the General Fund of approximately $6.5 million and Indirect Charges for services provided by support organizations (e.g., County Attorney’s Office, Procurement Services, Human Resources, Fleet Maintenance, and other general local government services) of approximately $2.9 million. Information Technology, Fleet, Facilities, and HR direct allocations total $3.4 million. Combined, the CCWSD contributes $12.8 million to the General Fund. The District’s FY18 Proposed Operating Budget is revenue centric and meets all Board approved budget guidelines. The total Proposed Budget of $163.9 million funds 414 FTEs, the Capital Improvement Program of $76.9 million that will address those water and wastewater rehabilitation and renewal projects with the highest risk assessment, debt service of $17.9 million and $26.7 million in unrestricted reserves. Administration This Division provides management, policy oversight, administrative and process improvement to the operations and capital improvement programs of the Department. The Administration Division works in concert with the County Manager’s Office and other Departments in support of the county’s strategic goals as they relate to revising the Growth Management Plan and Land Development Code to improve the county’s ability to manage and control the rate and quality of future development. The Division has 5 budgeted FTEs for FY18. The net operating budget is $0.9 million. Financial and Operations Support This Division provides sound fiscal management to Division Departments’ operations and capital expenditure programs, maintains internal controls, manages centralized Department inventory, bills and manages Departmental accounts Fiscal Year 2018 2 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department receivable and payables, and processes vendor payments associated with the compliant operations of the Department’s enterprise entities. The Division also provides call center customer service for all water-sewer utility customers and solid waste residential curbside customers to meet the demands of customer quality assurance / quality control initiatives. The Division has a staff of 58 budgeted FTEs for FY18. The net operating budget is $16.3 million including CCWSD PILT and Indirect Cost Allocations. Utilities Engineering and Project Management This Division is responsible for the proactive and efficient planning and project management of the CCWSD’s capital improvement program, and for supporting the county’s strategic goal of developing reliable public infrastructure and asset management processes. The Division has a staff of 27 budgeted FTEs for FY18 to manage over $77 million in new utility infrastructure capital improvements and continue multi-year project execution in support of approximately $1.3 billion in gross assets. The net operating budget is $3.5 million. PUD Technical Support and Logistics This Division provides underground utility locating services, technical support for applications specific to utility operations and integrated Geographic Information Systems (GIS) based support for the Department’s asset management. The Division has a staff of 32 FTEs for FY18 and a $4.6 million net operating budget. Water Treatment and Distribution This Division provides compliant potable (drinking) water treatment and distribution services to approximately 66,000 accounts within the CCWSD. The Division currently operates two regulatory compliant regional water treatment facilities and one sub-regional facility with a combined constructed capacity to treat and deliver 52.7 million gallons of water per day to efficiently meet an anticipated service level demand of approximately 9.1 billion gallons in FY18. Efficient wellfield management provides the necessary raw water to meet production demand. Cross connection control, meter services, hydrant maintenance, and regulatory monitoring and compliance are essential Division programs to maintain the reliability of the public water supply. The Division has a staff of 142 budgeted FTEs for FY18 with a net operating budget of $30.5 million. Wastewater Collections, Treatment, and IQ Water Delivery This Division provides effective management, operation, and maintenance of the Collier County wastewater system to ensure all facilities operate in regulatory compliance, provide a safe work environment, and efficiently meet service level demands. The Division currently operates two regional water reclamation facilities and one sub-regional facility with a combined constructed capacity to treat approximately 40.7 million gallons of wastewater per day. The Division delivers approximately 5.5 billion gallons of irrigation quality water per year to the community for beneficial reuse. The Division has a staff of 150 budgeted FTEs for FY17. The net operating budget is $30.9 million. Solid and Hazardous Waste Management Division The FY18 Proposed Budget for Solid and Hazardous Waste revenue includes a 2.9 percent rate adjustment to both residential and commercial tipping fee rates to generate revenues to fund planned operational, maintenance, and capital investment activities in accordance with the Board approved budget guidelines for consumer price index adjustments. The annual assessment for curbside collection in District 1 will be $207.40 ($201.18 after the discount for payments in November, or a $1.42 per month increase over FY17) and will be $198.41 in District 2 ($193.45 after discount, a $1.41 per month increase over FY17). No new debt is anticipated in FY18 as the enterprise operation remains cash and carry. As an enterprise fund that charges fees for services, the Division is revenue centric in FY18 and meets all Board approved budget policy guidelines. This Division is responsible for the efficient and economical balance of public and private services to meet federal, state, and local requirements for solid waste management and disposal. The Division ensures public health, safety, and preservation of natural resources by utilizing a customer centric, environmentally sound and cost-effective operational approach that provides best value services for approximately 126,300 residential curbside collection accounts, over 76,600 recycling center visitors, and 4,500 commercial accounts. The Collier County Landfill provides disposal services for 441,400 peak season residents and visitors of Collier County with over 333,700 revenue generating tons across the scales expected in FY18. This includes the proper collection and disposal of municipal solid and hazardous wastes, waste reduction to extend the life of the landfill and meet the state recycling goal of 75 percent by 2020, residential and non-residential recycling programs, and landfill operations. The Division is responsible for the county’s debris recovery mission in the event of a major disaster, and the administration of the Board-approved Integrated Solid Waste Management Strategy. The Division will operate six recycling/hazardous waste drop off centers in FY18, and two scale houses; administer solid and household hazardous waste collection and disposal contracts; and manage and maintain a fund for the county’s landfill Fiscal Year 2018 3 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department closures. The Division will fund 46 FTEs in FY18, including a field base customer education and contract compliance section. Significant capital program initiatives include completion of the Northeast Recycling Center and a Deep Injection Well (DIW) which will provide the primary disposal for landfill leachate. The Collier County Landfill is the only landfill in the state to operate without a DIW as the primary disposal resource. The Division’s net operating budget is $43.3 million, which is funded through landfill tipping fees, recycling drop-off center fees, residential curbside collection assessments, franchise fees and state grants. The Division manages a design/build/operate landfill contract and two solid waste collection and disposal contracts with a combined workforce of approximately 400 contract employees. The private-public partnership continues to support the Integrated Solid Waste Management Strategy initiatives to increase recycling and divert recyclables and hazardous waste from the Collier County Landfill, reaching a milestone as one of the highest recyclers in the state by achieving a 65% recycling goal in 2015, as reported by FDEP. Facilities Management Division The Division is responsible for providing secure, clean and comfortable facilities for our citizens, visitors and staff. All buildings, offices, grounds and property acquisitions are managed and maintained to the highest standards through operational excellence and preventative and predictive maintenance. Regular maintenance functions for electrical, plumbing, heating, ventilation and air conditioning, structural repairs, physical energy plant, fire systems compliance, pest control and landscaping for the county’s 900+ structures with an estimated value of $850 million in vertical assets. The Division maintains a total of 4,600,000 square feet of building space while completing over 25,000 work orders per year. They operate and maintain a cemetery while selling roughly 55 plots per year. The Divisions Government Security section protects the assets, both physical and human, at 9 posts throughout the Agency including; Courthouse, Courthouse Annex, Building F, Building H, Emergency Services Center, Immokalee Government Services Center, North Collier Government Services Center, Operations Center, and Growth Management Division. Security provides the necessary resources to detect contraband entering secured locations, physical security presents and employee protection services. The Division provides the maintenance, construction, and capital renovation for the County’s complex structures including three Government Services Centers, CCSO substations, two Jail Detention Centers, the Emergency Services Center, two Courthouses, EMS Stations, Parks facilities, museums, libraries, and general office space for the Board of County Commissioners and the Constitutional Officers including the Supervisor of Elections, Tax Collector, Property Appraiser, Clerk of the Courts, along with the Judicial Officers. The Division is also responsible for providing professional property acquisition, management and leasing services through expeditious, professional and knowledgeable handling of real estate transactions. These activities provide services for all County Divisions, including right-of-way acquisition for all utility projects, sites for parks, libraries, water and wastewater treatment facilities, EMS facilities and administrative offices, cemetery plots, as well as for sites under the Conservation Collier program. Funding for the Division activities comes primarily from the General Fund (001). The total net operating budget for FY18 is $15.1 million with $14.3 million funded through the general fund, which supports a staff of 64 FTEs, supplemented by 150+ contracted employees for security, pest control, landscaping and grounds maintenance, janitorial services and other maintenance services. The Division also manages the GAC Land Trust for effective marketing of county owned lots in Golden Gate Estates and the Freedom Memorial, which are funded by charges for services. Revenues from the county government complex snack bar fund handicapped and general accessibility improvements to government facilities. The Capital Improvement Program of $5.3 million, a 15.6 percent increase over the prior year, will be focused on air conditioning, heating and ventilation repairs, reroofing projects and general building repairs. Project management for capital improvement projects in FY18 are focused primarily on the jail ($2.3 million) and structural improvements ($1.2 million) for other CCSO facilities. Reserves Reserves for the CCWSD and the Solid and Hazardous Waste Enterprise operations are funded in accordance with the FY18 Budget Policy Guidelines adopted by the Board on February 28, 2017, including the Board-approved Reserve Policy. The management of reserves across multiple funds enables the CCWSD to maintain a strong investment credit rating with the Fiscal Year 2018 4 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department Fitch (AAA) and Moody’s (Aa1) rating agencies. Department unrestricted reserves in FY18 total $35.9 million, an increase from FY17 of $7.4 million. The CCWSD unrestricted reserve balance of $26.7. million represents 59 days of operating and capital, within the budget policy guidelines of 45 to 90 days. Solid Waste unrestricted reserves of $9.3 million represent 65 days of operating and capital, within the budget guidelines of 60 to 90 days necessary for a debris disaster recovery. Restricted reserves for the CCWSD total $32.0 million, including the water impact fee fund reserves of $12.4 million, wastewater impact fee fund reserves of $6.9 million, and debt reserves of $12.7 million in accordance with all bond covenants. Debt Service At the beginning of FY18, the CCWSD outstanding principal debt will approximate $165 million, of which $113 million is growth related debt and $52 million is user fee debt. Annual debt service for FY18 totals $17.9 million, with water and wastewater repair and replacement capital projects comprising approximately $6.3 million of the total and an additional $11.6 million in annual debt service incurred in the impact fee funds for debt related to growth projects. Capital projects for repair and rehabilitation, as outlined in the Board-approved Capital Improvement Program in the User Rate Study and the Annual Update Inventory Report, are prioritized on a risk based approach, with the most critical projects being those with unfavorable impacts to compliance with regulatory agency operating requirements. The CCWSD is also positioned to meet the demands of growth based on prudent reserve levels and the ability to borrow at favorable rates given Fitch’s AAA rating and Moody’s rating upgrade in April 2016 from Aa2 to Aa1. The CCWSD maintains strong debt ratios as one of the key ratios rating agencies review. Key ratings drivers also include an excellent financial profile, competitive user charges, and sustainable capacity. Fiscal Year 2018 5 Public Utilities Department General Fund (001) ‐ Public Utilities  Department Operating Divisions  FY 17 General  Fund Net Cost ‐  Adopted  Adjustment   FY 17 Adjusted  Compliance Base   FY 18 Proposed  Budget Request   Variance to  Adjusted Base % Variance  Expanded  requests   FTE  Additions  Facilities Management Department 13,644,200             ‐                     13,644,200                14,030,900      386,700              2.8%‐             Real Property Management 341,500                  ‐                     341,500                      313,600            (27,900)                ‐8.2%‐               ‐                ‐               Total Net Cost to General Fund 001 13,985,700             ‐                      13,985,700                  14,344,500        358,800                2.6%‐                ‐               Total General Fund 001 13,985,700             ‐                      13,985,700                  14,344,500        358,800                2.6%‐                ‐               358,800                              Target Compliance ‐ 2.5% Increase 349,600$              2.5% Actual Change for Division with Expanded 358,800$              2.6% Positive number is Compliance for the Division (9,200)$                 ‐0.1%‐$             ‐             Fiscal Year 2018 5a Public Utilities Department Collier County Government Fiscal Year 2018 Recommended Budget Net Cost to General Fund 001 and MSTD General Fund 111 Public Utilities Department  Compliance View H:\Budget Files FY 18\June BCC Workshops Info\Compliance Worksheets\Compliance Worksheet June BCC WS Facilities PUD FY18.xlsx Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department ForecastAdopted Recom'd ChangeExpandedDivision Budgetary Cost Summary Current FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 Actual 35,587,909 40,863,500 43,956,300 562,800 44,519,100 39,833,000 8.9%Personal Services 72,145,651 83,906,000 88,807,800 131,700 88,939,500 84,413,900 6.0%Operating Expense 2,600,800 3,138,500 3,394,200 - 3,394,200 3,138,500 8.1%Indirect Cost Reimburs 5,571,700 6,389,200 6,803,100 - 6,803,100 6,389,200 6.5%Payment In Lieu of Taxes 2,425,855 884,400 1,466,800 156,400 1,623,200 1,060,200 83.5%Capital Outlay - - - - - 68,800 Remittances na Total Net Budget 118,331,916 135,181,600 144,428,200 850,900 145,279,100 134,903,600 7.5 % 630,000 630,000 325,000 - 325,000 630,000 (48.4%)Advance/Repay to 390 Gov't Fac - - 3,900,000 - 3,900,000 - Advance/Repay to 470 S Waste na 311,661 316,500 344,200 - 344,200 328,700 8.8%Trans to Property Appraiser 109,190 120,900 124,800 - 124,800 112,200 3.2%Trans to Tax Collector - 220,200 196,300 - 196,300 220,200 (10.9%)Trans to 001 General Fund 218,500 218,500 218,500 - 218,500 218,500 0.0%Trans to 107 Impact Fee Admin 49,136 - - - - - Trans to 301 Co Wide Cap Fd na 2,151,000 2,524,300 1,821,700 - 1,821,700 2,524,300 (27.8%)Trans to 408 Water/Sewer Fd 1,795,200 2,707,300 811,500 - 811,500 2,887,300 (70.0%)Trans to 409 W/S MP Fd 5,095,568 3,870,500 6,830,300 - 6,830,300 3,870,500 76.5%Trans to 410 W/S Debt Serv Fd 16,988,600 17,194,400 20,343,500 - 20,343,500 17,436,200 18.3%Trans to 412 W User Fee Cap Fd 33,883,000 32,432,500 33,542,900 - 33,542,900 32,895,600 3.4%Trans to 414 S User Fee Cap Fd 448,800 315,300 145,200 - 145,200 315,300 (53.9%)Trans to 470 Solid Waste Fd 240,000 98,500 274,300 - 274,300 98,500 178.5%Trans to 472 Sol Waste MP - - 510,600 - 510,600 - Trans to 473 Mand Trash Coll na 1,956,000 4,116,400 9,544,100 - 9,544,100 4,116,400 131.9%Trans to 474 Solid Waste Cap Fd - - 245,900 - 245,900 - Trans to 505 IT Ops na - - 302,500 - 302,500 - Trans to 506 IT Capital na - 7,859,200 8,478,900 - 8,478,900 - 7.9%Reserves for Contingencies - 4,440,800 911,600 - 911,600 - (79.5%)Reserves for Capital - 11,541,200 14,265,400 - 14,265,400 - 23.6%Reserves for Cash Flow - (571,800)(595,200) - (595,200) - 4.1%Reserves for Attrition 182,208,571 223,216,300 246,970,200 850,900 247,821,100 11.0% 200,557,300 Total Budget ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 Appropriations by Department County Water-Sewer District 67,503,307 81,028,200 86,331,200 473,200 86,804,400 81,923,600 7.1% Solid & Hazardous Waste Management Division 35,624,960 40,002,100 42,970,900 377,700 43,348,600 38,645,000 8.4% Facilities Management Division 15,203,649 14,151,300 15,126,100 - 15,126,100 14,335,000 6.9% 118,331,916 135,181,600 144,428,200 850,900 145,279,100 7.5% 134,903,600 Total Net Budget County Water-Sewer District 58,167,422 66,714,400 77,101,700 - 77,101,700 57,667,900 15.6% Solid & Hazardous Waste Management Division 5,079,234 19,816,900 24,228,400 - 24,228,400 7,355,800 22.3% Facilities Management Division 630,000 1,503,400 1,211,900 - 1,211,900 630,000 (19.4%) 63,876,656 88,034,700 102,542,000 - 102,542,000 16.5% 65,653,700 Total Transfers and Reserves 182,208,571 223,216,300 246,970,200 850,900 247,821,100 11.0% 200,557,300 Total Budget Fiscal Year 2018 6 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department Division Funding Sources ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 1,736,191 1,617,000 1,747,000 - 1,747,000 8.0% 1,709,600 Franchise Fees 1,886 - - - - - Special Assessments na 112,552 100,000 100,000 - 100,000 0.0% 100,000 Intergovernmental Revenues 14,817,629 15,968,900 15,790,600 - 15,790,600 (1.1%) 15,310,445 Charges For Services 54,652,645 56,803,000 62,000,000 - 62,000,000 9.1% 59,700,000 Water Revenue 62,944,341 66,046,000 71,700,000 - 71,700,000 8.6% 68,160,000 Sewer Revenue 3,219,452 3,361,000 3,600,000 - 3,600,000 7.1% 3,600,000 Effluent Revenue 21,552,619 22,970,500 25,051,300 - 25,051,300 9.1% 22,943,600 Mandatory Collection Fees 38,506 10,000 15,000 - 15,000 50.0% 16,800 Fines & Forfeitures 857,213 468,900 597,600 - 597,600 27.4% 643,355 Miscellaneous Revenues 481,768 258,600 410,700 - 410,700 58.8% 373,200 Interest/Misc - - 3,900,000 - 3,900,000 - Advance/Repay fm 471 Solid Waste na 7,223,218 8,108,100 8,584,000 - 8,584,000 5.9% 7,795,500 Reimb From Other Depts 42,499 - - - - - Trans frm Tax Collector na 13,456,503 13,985,700 14,344,500 - 14,344,500 2.6% 13,907,000 Net Cost General Fund (30,051,829) - - - - (28,331,600)Net Cost Co Water/Sewer Op na 14,200 13,600 13,600 - 13,600 0.0% 13,600 Trans fm 109 Pel Bay MSTBU - 85,200 85,200 - 85,200 0.0% 85,200 Trans fm 113 Comm Dev Fd 1,130,000 1,130,000 835,000 - 835,000 (26.1%) 1,130,000 Trans fm 390 Gen Gov Fac Cap Fd 138,400 252,800 785,800 - 785,800 210.8% 252,800 Trans fm 408 Water / Sewer Fd 4,800 - - - - - Trans fm 409 W/S MP Fd na 527,500 534,400 572,200 - 572,200 7.1% 534,400 Trans fm 470 Solid Waste Fd 1,933,900 2,165,600 1,249,500 - 1,249,500 (42.3%) 2,165,600 Trans fm 473 Mand Collct Fd 44,861,500 38,096,600 45,029,700 850,900 45,880,600 20.4% 47,996,800 Carry Forward - (8,759,600)(9,441,500) - (9,441,500) 7.8% - Less 5% Required By Law Total Funding 247,821,100 199,695,495 223,216,300 246,970,200 850,900 11.0% 218,106,300 Division Position Summary Forecast FY 2017 Adopted Recom'd ChangeExpandedActualCurrent FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 382.00 407.00 407.00 7.00 414.00 1.7% 416.00 County Water-Sewer District 31.00 34.00 43.00 3.00 46.00 35.3% 34.00 Solid & Hazardous Waste Management Division 57.00 66.00 64.00 - 64.00 (3.0%) 64.00 Facilities Management Division 470.00 507.00 514.00 10.00 524.00 3.4%Total FTE 514.00 Fiscal Year 2018 7 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department County Water-Sewer District ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 Department Budgetary Cost Summary 28,439,401 32,513,800 33,883,700 389,900 34,273,600 31,394,600 5.4%Personal Services 30,610,730 39,082,900 41,803,300 4,500 41,807,800 40,893,400 7.0%Operating Expense 2,278,000 2,678,300 2,898,600 - 2,898,600 2,678,300 8.2%Indirect Cost Reimburs 5,351,100 6,093,700 6,482,800 - 6,482,800 6,093,700 6.4%Payment In Lieu of Taxes 824,077 659,500 1,262,800 78,800 1,341,600 863,600 103.4%Capital Outlay 67,503,307 81,028,200 86,331,200 473,200 86,804,400 81,923,600 Net Operating Budget 7.1% - 220,200 196,300 - 196,300 220,200 (10.9%)Trans to 001 General Fund 218,500 218,500 218,500 - 218,500 218,500 0.0%Trans to 107 Impact Fee Admin 48,153 - - - - - Trans to 301 Co Wide Cap Fd na 1,795,200 2,707,300 811,500 - 811,500 2,887,300 (70.0%)Trans to 409 W/S MP Fd 5,095,568 3,870,500 6,830,300 - 6,830,300 3,870,500 76.5%Trans to 410 W/S Debt Serv Fd 16,988,600 17,194,400 20,343,500 - 20,343,500 17,436,200 18.3%Trans to 412 W User Fee Cap Fd 33,883,000 32,432,500 33,542,900 - 33,542,900 32,895,600 3.4%Trans to 414 S User Fee Cap Fd 138,400 139,600 145,200 - 145,200 139,600 4.0%Trans to 470 Solid Waste Fd - - 510,600 - 510,600 - Trans to 473 Mand Trash Coll na - - 245,900 - 245,900 - Trans to 505 IT Ops na - - 258,800 - 258,800 - Trans to 506 IT Capital na - 4,158,600 4,340,200 - 4,340,200 - 4.4%Reserves for Contingencies - 6,300,000 10,202,300 - 10,202,300 - 61.9%Reserves for Cash Flow - (527,200)(544,300) - (544,300) - 3.2%Reserves for Attrition 125,670,729 147,742,600 163,432,900 473,200 163,906,100 10.9% 139,591,500 Total Budget ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 Appropriations by Program 597,425 852,400 942,400 - 942,400 921,400 10.6%Public Utilities Administration (408) 2,643,212 3,249,800 3,478,800 4,000 3,482,800 3,207,000 7.2%Public Utilities Engineering & Project Management Division (408) 14,169,896 16,291,900 16,322,700 2,800 16,325,500 16,223,800 0.2%Public Utilities Operations Support Division (408) 3,103,799 4,474,600 4,551,300 22,000 4,573,300 4,066,200 2.2%Technical Support, Logistics and Operations (408) 23,076,663 27,570,800 30,744,200 188,400 30,932,600 29,064,900 12.2%Wastewater Division (408) 23,912,313 28,588,700 30,291,800 256,000 30,547,800 28,440,300 6.9%Water Division (408) Total Net Budget 125,670,729 147,742,600 163,432,900 473,200 163,906,100 10.9% 139,591,500 Total Budget Total Transfers and Reserves 67,503,307 81,028,200 81,923,600 86,331,200 473,200 86,804,400 58,167,422 66,714,400 57,667,900 77,101,700 - 77,101,700 7.1% 15.6% Fiscal Year 2018 8 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department County Water-Sewer District Department Funding Sources ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 (10) - - - - - Special Assessments na 2,770,656 2,504,400 2,287,500 - 2,287,500 (8.7%) 2,336,245 Charges For Services 54,652,645 56,803,000 62,000,000 - 62,000,000 9.1% 59,700,000 Water Revenue 62,944,341 66,046,000 71,700,000 - 71,700,000 8.6% 68,160,000 Sewer Revenue 3,219,452 3,361,000 3,600,000 - 3,600,000 7.1% 3,600,000 Effluent Revenue 38,506 10,000 - - - (100.0%) 16,800 Fines & Forfeitures 556,330 327,400 367,300 - 367,300 12.2% 416,255 Miscellaneous Revenues 261,936 155,100 283,000 - 283,000 82.5% 218,000 Interest/Misc (30,051,829) - - - - (28,331,600)Net Cost Co Water/Sewer Op na 14,200 13,600 13,600 - 13,600 0.0% 13,600 Trans fm 109 Pel Bay MSTBU 500,000 500,000 510,000 - 510,000 2.0% 500,000 Trans fm 390 Gen Gov Fac Cap Fd 4,800 - - - - - Trans fm 409 W/S MP Fd na 527,500 534,400 572,200 - 572,200 7.1% 534,400 Trans fm 470 Solid Waste Fd 1,623,500 1,989,900 1,249,500 - 1,249,500 (37.2%) 1,989,900 Trans fm 473 Mand Collct Fd 28,608,700 21,958,100 27,858,400 473,200 28,331,600 29.0% 30,437,900 Carry Forward - (6,460,300)(7,008,600) - (7,008,600) 8.5% - Less 5% Required By Law Total Funding 163,906,100 125,670,729 147,742,600 163,432,900 473,200 10.9% 139,591,500 Department Position Summary Forecast FY 2017 Adopted Recom'd ChangeExpandedActualCurrent FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 4.00 4.00 5.00 - 5.00 25.0%Public Utilities Administration (408) 4.00 62.00 68.00 58.00 - 58.00 (14.7%)Public Utilities Operations Support Division (408) 67.00 24.00 27.00 27.00 - 27.00 0.0%Public Utilities Engineering & Project Management Division (408) 27.00 27.00 32.00 32.00 - 32.00 0.0%Technical Support, Logistics and Operations (408) 32.00 128.00 134.00 138.00 4.00 142.00 6.0%Water Division (408) 139.00 137.00 142.00 147.00 3.00 150.00 5.6%Wastewater Division (408) 147.00 382.00 407.00 407.00 7.00 414.00 1.7% 416.00 Total FTE Fiscal Year 2018 9 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department County Water-Sewer District Public Utilities Administration (408) Mission Statement The mission of the Public Utilities Department (Department) is to deliver best value, high quality, and sustainable services that meet customers' expectations in an operationally excellent environment. Public Utilities Administration provides policy oversight and operational support to the operations and capital improvement programs of the Department, including Utilities Engineering & Project Management; Wastewater Division; Water Division; Solid and Hazardous Waste Management Division; Facilities Management Division; and Financial and Operations Support, including Utility Billing and Customer Service. Public Utilities Administration facilitates efforts to operate in regulatory compliance, efficiently meet demand levels, build and empower the workforce, and provide services that meet customers' expectations. FY 2018 Budget FY 2018 Total FTE FY 2018 Revenues FY 2018 Net CostProgram Summary Divisional Administration 942,400 - 942,400 5.00 Provides executive level management, administrative and policy oversight, and process improvement to the divisions and employees within the Public Utilities Department, including division reception and customer support. Also responsible for the expansion and continued maintenance of all strategic/business planning for the Public Utilities Department, inter-local and developer agreements, and Growth Management Plan compliance. 5.00 942,400 - 942,400Current Level of Service Budget ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 Program Budgetary Cost Summary 473,157 528,500 637,500 - 637,500 568,500 20.6%Personal Services 122,632 318,800 297,300 - 297,300 345,500 (6.7%)Operating Expense 1,636 5,100 7,600 - 7,600 7,400 49.0%Capital Outlay Net Operating Budget 597,425 852,400 942,400 - 942,400 921,400 10.6% 597,425 852,400 942,400 - 942,400 10.6% 921,400 Total Budget 4.00 4.00 5.00 - 5.00 25.0% 4.00 Total FTE Program Funding Sources ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 (10) - - - - - Special Assessments na 22,309 - - - - - Miscellaneous Revenues na 575,125 852,400 942,400 - 942,400 10.6% 921,400 Net Cost Co Water/Sewer Op Total Funding 942,400 597,425 852,400 942,400 - 10.6% 921,400 Forecast FY 2017: Increases from the FY 17 budget are anticipated in Personal Services for the mid-year addition of a Security Professional and in Operating for utility legal support somewhat offset by a decrease in Organizational Development. Current FY 2018: The increase in Personal Services is due to the the addition of a Security Professional position to the Public Utilities Admin budget. Position 50027581 was transferred in with the offsetting position reduction reflected in the Water Division budget. Decreased operating costs are anticipated for utility legal support. Capital Outlay $4,200 - 3 Laptop Replacements $2,400 - 1 Portable Radio Replacement $1,000 - 1 iPad Replacement $7,600 - Total Capital Outlay Fiscal Year 2018 10 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department County Water-Sewer District Public Utilities Operations Support Division (408) Mission Statement The Financial and Operations Support Division provides sound financial analysis, assessment and management to the operations and capital expenditure programs of the two enterprise entities in the Public Utilities Department (PUD), the Collier County Water-Sewer District (CCWSD), and Solid and Hazardous Waste Management, and to Facilities Management. This Division must ensure optimal internal and external financing is available to support department wide funding needs, while supporting the county’s strategic goal of improving financial planning, management, reporting, and internal controls processes. FY 2018 Budget FY 2018 Total FTE FY 2018 Revenues FY 2018 Net CostProgram Summary PUD Financial Planning and Oversight 1,214,282 - 1,214,282 9.00 This program provides financial planning, management, and oversight of the Public Utilities Department (PUD) financial operations. Responsibilities include policy and management oversight for utility billing and accounts receivable, solid and hazardous waste disposal and mandatory collections revenues, the county’s estoppel program, fiscal payables, capital and debt expenditures, water-sewer user and impact fee rate setting, centralized department materials procurement and inventory management, and internal controls. Additional responsibilities include cash planning and management, identifying and securing optimal funding sources, administration of external financing for the PUD including compliance with bond covenants and Florida Department of Environmental Protection agreements, and development of the financial feasibility portion of the Annual Update and Inventory Report. Other program functions include development of inter-agency agreements, ordinance development, contract administration (including the solid waste franchise hauler contract), financial and management reporting, department budgeting and forecasting, and fiscal and technical oversight for five full scale implementation projects under the PUD’s Enterprise Asset management program. Public Utilities Department Fiscal Support 381,287 - 381,287 5.00 This program provides fiscal guidance, analysis, and payables functions for the Public Utilities Department (PUD) enterprise operations. Functions include materials and services requisition review, purchase order tracking, invoice audit, payment approval, purchase card transactions, travel request packages, as well as coordination between divisions, the Procurement Services Division, Clerk’s Finance, and vendors for resolution of payment issues. Reporting functions ensure payables are processed accurately, efficiently, and timely in compliance with the Prompt Payment Act, and enforce consistency of practice and process controls across the PUD. Collier County Water - Sewer District Inventory Management 856,542 - 856,542 10.00 This program provides management and control of centralized parts inventory for the Collier County Water-Sewer District (CCWSD). Responsibilities include utility parts contract administration, materials procurement and management, parts receiving/stocking/picking in multiple warehouse facilities, mobile truck inventories, and quarterly physical inventory counts. This program is responsible for the implementation of the City Works Store Rooms software application as an integrated element of the Public Utilities Division’s Enterprise Asset Management program. . Fiscal Year 2018 11 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department County Water-Sewer District Public Utilities Operations Support Division (408) FY 2018 Budget FY 2018 Total FTE FY 2018 Revenues FY 2018 Net CostProgram Summary Collier County Water - Sewer District Billing 993,362 389,700 1,383,062 8.00 This program provides billing of all water, sewer, and irrigation quality water services as well as cross connection control device installation charges and fats/oils/grease program charges for the Collier County Water-Sewer District (CCWSD). Core functions include establishing new service accounts, monthly service invoicing including deferred pay plan management, impact fee financing, special assessment financing, customer account maintenance, application of late payment penalties and debit or credit adjustments, and production of final bills that result from property sales or transfers of ownership. This program also provides the lock list for delinquent accounts and miscellaneous billing for CCWSD-owned property damaged by private contractors and individuals. Public Utilities Department Financial Functions 1,929,550 23,000 1,952,550 12.00 This program provides receipting, recording, and safeguarding of all customer cash, check and credit card payments for all Public Utilities Department (PUD) enterprise services. Core functions include daily administration of the county’s estoppel program, service roll administration for the Municipal Service Benefit Unit special annual assessments for the mandatory solid waste residential curbside collection program, cashiering and daily balancing, processing lock box and online credit card payments, bank draft processing, bank deposits, and accounts receivable management for water-sewer utility customer accounts and landfill scale house and recycling center facilities. This program also reviews and audits customer billing adjustment requests, provides payroll review and data entry, and monthly invoice processing for the county’s two solid waste franchise haulers. Public Utilities Department Customer Service 1,153,577 - 1,153,577 14.00 This program provides customer service to all Public Utilities Department (PUD) enterprise customers. The customer base served includes residential curbside trash collection and water/sewer/irrigation quality water customers. Core functions include research and response to customer inquiries, initiation of new service requests, and initiation of final meter reads on pending property sales or transfers. Call center technology provides efficient and prompt responses to customer requests. Collier County Water - Sewer District Indirect Cost Reimbursemen 2,898,600 - 2,898,600 - Collier County Water - Sewer District Payment in Lieu of Taxes 6,482,800 - 6,482,800 - 58.00 16,322,700 412,700 15,910,000Current Level of Service Budget FY 2018BudgetFY 2018Total FTE FY 2018Revenues FY 2018Net CostProgram Enhancements Two Additional Computers/Laptops 2,800 - 2,800 - The 2 in 1 laptop tablets will enable Inventory Control staff to utilize CityWorks Asset Management software to simultaneously pick materials and complete corresponding transactions and material counts. - 2,800 - 2,800Expanded Services Budget Fiscal Year 2018 12 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department County Water-Sewer District Public Utilities Operations Support Division (408) 58.00 16,325,500 412,700 15,912,800Total Recom'd Budget FY 2017 FY 2018FY 2016 FY 2017 BudgetForecastBudgetActualProgram Performance Measures 17,829 17,388 17,450 17,116# Curbside Accounts per FTE 11,262 10,996 10,558 10,305# Water/Sewer Accounts per FTE 99.80 99.80 99.50 99.50% of Bills Mailed Within 5 Business Days of Meter Reads 21,000 20,700 19,600 20,100Accounts Payable # of Invoices / Pay Apps Processed 14,052 14,592 19,600 16,009Customer Service Annual Calls per FTE 1 1 1 1Customer Service Average Abandon Call Rate (%) ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 Program Budgetary Cost Summary 4,388,411 4,967,000 4,479,400 - 4,479,400 4,863,600 (9.8%)Personal Services 2,128,675 2,510,100 2,431,300 - 2,431,300 2,538,800 (3.1%)Operating Expense 2,278,000 2,678,300 2,898,600 - 2,898,600 2,678,300 8.2%Indirect Cost Reimburs 5,351,100 6,093,700 6,482,800 - 6,482,800 6,093,700 6.4%Payment In Lieu of Taxes 23,711 42,800 30,600 2,800 33,400 49,400 (22.0%)Capital Outlay Net Operating Budget 14,169,896 16,291,900 16,322,700 2,800 16,325,500 16,223,800 0.2% 14,169,896 16,291,900 16,322,700 2,800 16,325,500 0.2% 16,223,800 Total Budget 62.00 68.00 58.00 - 58.00 (14.7%) 67.00 Total FTE Program Funding Sources ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 237,907 200,200 183,000 - 183,000 (8.6%) 200,800 Charges For Services 38,506 10,000 - - - (100.0%) 16,800 Fines & Forfeitures 230,265 228,100 229,700 - 229,700 0.7% 225,500 Miscellaneous Revenues 13,663,218 15,853,600 15,910,000 2,800 15,912,800 0.4% 15,780,700 Net Cost Co Water/Sewer Op Total Funding 16,325,500 14,169,896 16,291,900 16,322,700 2,800 0.2% 16,223,800 Forecast FY 2017: Personal services are forecast below the adopted budget due to savings in job bank labor to supplement FTEs in PUD Accounting, Customer Service, and Utility Ordinance Education and Compliance. Operating expenses are forecast above the adopted budget due to increased Bank Fees. The forecast position count reflects the transfer out of three position to Internal Controls in Fund (001) and the mid-year addition of two Northeast Service Area (Orange Tree) positions. Current FY 2018: Personal Services will decrease as Utility Ordinance Education and Compliance (UOEC) moves to fund 473. Operating expenses are budgeted higher due to PILT, Indirect Cost Allocation, and Bank Fees, offset partially by the UOEC move. The FY 18 budgeted position count reflects the transfer out of three position to Internal Controls in Fund (001), the mid FY 17 addition of two Northeast Service Area (Orange Tree) positions and the transfer out of nine Ordinance Education & Enforcement positions to Solid Waste Mandatory Collection Fund (473). Current Level of Service Capital Outlay items: $21,000 - 15 Replacement Laptops $ 9,600 - 4 Replacement Radios $30,600 - Total Current Level of Service (Replacement) Capital Outlay Fiscal Year 2018 13 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department County Water-Sewer District Public Utilities Operations Support Division (408) Expanded Level of Service Capital Outlay items: $ 2,800 - 2 Laptops for Warehouse Inventory $ 2,800 - Total Expanded Level of Service (New) Capital Outlay $33,400 – Division Capital Outlay this budget page The purchase of new and replacement vehicles is budgeted in the Water/Sewer Motor Pool Fund (409). Fiscal Year 2018 14 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department County Water-Sewer District Public Utilities Engineering & Project Management Division (408) Mission Statement To deliver projects that meet requirements on-time, on-budget, at best-value to the satisfaction of our Water and Wastewater clients. Our focus is to sustain regulatory compliance and mechanical/structural integrity throughout the installed base of approximately $1.3 billion of assets. FY 2018 Budget FY 2018 Total FTE FY 2018 Revenues FY 2018 Net CostProgram Summary CCWSD Management, Planning, & Quality Assurance 1,205,266 - 1,205,266 8.00 This program is responsible for the management, control, and oversight of planning and project management functions for the Water and Wastewater Divisions of the Collier County Water-Sewer District (CCWSD). Responsibilities include updates to the Master Plan, the Annual Update and Inventory Report, and other long-term planning initiatives as well as tracking capacity, analyzing trends, and reviewing new development plans to ensure concurrency and master plan compliance. Core functions are defined by the Project Management Institute and implemented through Project Management Professional training and internal standard operating procedures. Quality assurance / quality control services are provided for projects within all operating divisions. Collier County Water - Sewer District Project Management 1,813,821 - 1,813,821 15.00 This program provides project and program management services for planning, designing, and implementing projects that meet the demand of the all-encompassing utility capital improvements as related to the Water and Wastewater Divisions of the Collier County Water-Sewer District (CCWSD). This includes wellfields, regional water plants, the potable water distribution system, collections system, regional wastewater plants, and the irrigation quality reuse water distribution system. Collier County Water - Sewer District Automation Systems Project 459,713 - 459,713 4.00 This program develops systems that ensure sustainable business processes, provides project and program management for supervisory control and data acquisition (SCADA) projects, and is responsible for implementing the Enterprise Asset Management program for the Collier County Water-Sewer District (CCWSD) that will result in more efficient and effective use of funds. The goal of this program is to achieve optimal balance of operational and capital costs relative to defined levels of service, operating risks, and compliance requirements. 27.00 3,478,800 - 3,478,800Current Level of Service Budget FY 2018 Budget FY 2018 Total FTE FY 2018 Revenues FY 2018 Net CostProgram Enhancements Additional Radio and Laptop for Job Bank PM 4,000 - 4,000 - These items will equip a Senior Project Manager Job Bank position focused on the execution of the Wastewater Capital Improvement Program (CIP) including maintenance of CCWSD assets at a manageable and sustainable risk level. The CIP supports uninterrupted operation of critical services and compliance with all applicable codes, laws, rules, regulations, standards, policies, and procedures. - 4,000 - 4,000Expanded Services Budget 27.00 3,482,800 - 3,482,800Total Recom'd Budget Fiscal Year 2018 15 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department County Water-Sewer District Public Utilities Engineering & Project Management Division (408) FY 2017 FY 2018FY 2016 FY 2017 BudgetForecastBudgetActualProgram Performance Measures 85 75 70 68CIP Commitments, ($M) 100 100 100 100Contract Compliance, (%) 1,100 1,000 700 989Purchase Order Volume, (#) 100 100 100 100Work Order Compliance, (%) ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 Program Budgetary Cost Summary 2,342,981 2,863,000 3,075,700 - 3,075,700 2,833,700 7.4%Personal Services 257,655 364,100 383,700 - 383,700 350,600 5.4%Operating Expense 42,575 22,700 19,400 4,000 23,400 22,700 3.1%Capital Outlay Net Operating Budget 2,643,212 3,249,800 3,478,800 4,000 3,482,800 3,207,000 7.2% 2,643,212 3,249,800 3,478,800 4,000 3,482,800 7.2% 3,207,000 Total Budget 24.00 27.00 27.00 - 27.00 0.0% 27.00 Total FTE Program Funding Sources ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 32,895 - - - - - Miscellaneous Revenues na 2,610,316 3,249,800 3,478,800 4,000 3,482,800 7.2% 3,207,000 Net Cost Co Water/Sewer Op Total Funding 3,482,800 2,643,212 3,249,800 3,478,800 4,000 7.2% 3,207,000 Forecast FY 2017: Personal Services are forecast modestly lower as a result of temporary vacancies. Current FY 2018: Personal Services increase due to the shift of an Inspector position into the division and addition of a Job Bank Senior Project Manager. Operating expenses will increase marginally. Current Level of Service Capital Outlay items: $14,400 - 9 Replacement Laptops $ 5,000 - 1 Replacement High Speed Scanner $19,400 - Total Current Level of Service (Replacement) Capital Outlay Expanded Level of Service Capital Outlay items: $ 2,400 - 1 Portable Radio for Job Bank Senior Project Manager $ 1,600 - 1 Laptop for Job Bank Senior Project Manager $ 4,000 - Total Expanded Level of Service (New) Capital Outlay $23,400 - Division Capital Outlay this budget page The purchase of new and replacement vehicles is budgeted in the Water/Sewer Motor Pool Fund (409). Fiscal Year 2018 16 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department County Water-Sewer District Technical Support, Logistics and Operations (408) Mission Statement Provide management oversight and technical and operational services that support sustainability and compliance of the water-sewer district operations. These services include underground utility locate services and damage prevention education, dedicated support of the PUD’s Geographic Information System (GIS)-centric asset management program and the GIS data repository of assets, dedicated technical services for PUD-specific applications and databases, planning services, and infrastructure rehabilitation and enhancement projects for the Public Utilities Department’s (PUD) manned and unmanned structures. FY 2018 Budget FY 2018 Total FTE FY 2018 Revenues FY 2018 Net CostProgram Summary Logistics & Operations 1,384,534 - 1,384,534 6.00 Provides infrastructure-related services for manned and unmanned structures operated 24/7/365 including office space for employees that directly support the water-sewer district operations responsible for potable water production and distribution, compliant sanitary sewer collection and treatment, and reuse water distribution. This program ensures that the core facilities that support these public facing products are secure and well maintained structures. The program provides infrastructure short- and long-range planning, physical site assessments, planned and emergency maintenance and rehabilitation of structures, inspections, and project management. Technical Support - Utility Locates 1,398,444 - 1,398,444 14.00 Provides responsive and accurate location services for the water-sewer district in compliance with the two-day response time mandated by Florida State Statute 556, the Underground Damage Prevention and Safety Act. This service is critical to protect utility infrastructure in the ground and protect the well being of excavation crews working near buried utilities. Locate Services provides education and damage prevention coordination in alignment with Sunshine 811 and actively promotes the call-before-you-dig campaign throughout the district. This program has expanded its scope to include project data management with a focus on centralized repository of critical project documentation and an electronic utility print room available in the field or office as a reference for operations and engineering staff. Technical Support - Dedicated Applications & Geographic Informat 1,071,207 - 1,071,207 5.00 Provides dedicated application support for utility-specific applications and databases; technical analysis services that add value to the operations through compliance reporting, centralized documentation, real time monitoring, and automation for accuracy and time savings; and dedicated utility Geographic Information System (GIS) support for reuse assets, water assets, wastewater assets, and wellfield assets. Technical Support - Asset Management 697,115 - 697,115 7.00 This program is in alignment with utility best practices of implementing a life cycle asset management program for all linear and vertical assets. This section provides direction and application support for the utility Geographic Information System (GIS)-centric asset management system designed to manage assets from cradle to grave. This includes technical expertise to provide complex programming for GIS and the suite of asset management applications that support this program, and oversight of the integrations between systems to streamline the application to support office and field operation end-users, while maintaining the asset information from multiple repositories. 32.00 4,551,300 - 4,551,300Current Level of Service Budget Fiscal Year 2018 17 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department County Water-Sewer District Technical Support, Logistics and Operations (408) FY 2018BudgetFY 2018Total FTE FY 2018Revenues FY 2018Net CostProgram Enhancements Drone & 2 Additional Laptops 22,000 - 22,000 - A fixed wing UAS drone will enable the section to remotely sense data regarding large project sites, such as the proposed resource recovery park, SHWMD preserves, large acquisitions such as the Orange Tree Utility, and the County landfill, in a more cost effective manner than a vertical takeoff and landing (VTOL) system. The fixed wing system will be able to collect data on these large sites in a single flight, which will allow for more time for QA/QC of data and post processing of deliverables. Without the drone, large project sites will need to be outsourced at significantly higher cost. The laptops will be utilized for development testing for GIS / Enterprise Asset Management / Workforce / CityWorks. - 22,000 - 22,000Expanded Services Budget 32.00 4,573,300 - 4,573,300Total Recom'd Budget FY 2017 FY 2018FY 2016 FY 2017 BudgetForecastBudgetActualProgram Performance Measures 43,000 41,000 42,000 39,196# Locates Performed 4,300 4,100 4,200 5,599# Locates Performed per FTE 80 80 80 74# Supported PUD Applications 126,290 122,655 114,413 119,108Asset Mgmt/GIS Create/Maintain Linear Assets 18,000 16,000 40,000 10,259Asset Mgmt/GIS Create/Maintain Vertical Assets ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 Program Budgetary Cost Summary 1,819,847 2,598,700 2,552,000 - 2,552,000 2,267,900 (1.8%)Personal Services 1,175,942 1,797,100 1,934,300 - 1,934,300 1,719,500 7.6%Operating Expense 108,009 78,800 65,000 22,000 87,000 78,800 10.4%Capital Outlay Net Operating Budget 3,103,799 4,474,600 4,551,300 22,000 4,573,300 4,066,200 2.2% 3,103,799 4,474,600 4,551,300 22,000 4,573,300 2.2% 4,066,200 Total Budget 27.00 32.00 32.00 - 32.00 0.0% 32.00 Total FTE Program Funding Sources ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 3,103,799 4,474,600 4,551,300 22,000 4,573,300 2.2% 4,066,200 Net Cost Co Water/Sewer Op Total Funding 4,573,300 3,103,799 4,474,600 4,551,300 22,000 2.2% 4,066,200 Forecast FY 2017: Personal services are forecast below the adopted budget due to temporary vacancies and lower than anticipated special pay adjustments for certifications. Current FY 2018: Personal Services will decrease due to realignment of special pay adjustments for certifications. Operating costs are proposed to increase for PUD asset security and computer software for Enterprise Asset Management. Current Level of Service Capital Outlay items: $31,000 - 2 Replacement Ground Penetrating Radar Fiscal Year 2018 18 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department County Water-Sewer District Technical Support, Logistics and Operations (408) $14,000 - 2 Replacement Radio Detection Devices $12,800 - 8 Replacement Laptops $ 7,200 - 3 Replacement Portable Radios $65,000 - Total Current Level of Service (Replacement) Capital Outlay Expanded Level of Service Capital Outlay items: $18,000 - 1 Fixed Wing UAS Drone $ 4,000 - 2 Surface Pro Tablets $22,000 - Total Expanded Level of Service (New) Capital Outlay $87,000 - Division Capital Outlay this budget page The purchase of new and replacement vehicles is budgeted in the Water/Sewer Motor Pool Fund (409). Fiscal Year 2018 19 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department County Water-Sewer District Water Division (408) Mission Statement To deliver best value, high quality, and sustainable water services that meet customers' expectations in an operationally excellent environment. FY 2018 Budget FY 2018 Total FTE FY 2018 Revenues FY 2018 Net CostProgram Summary Water Management & Oversight -60,279,202 62,000,000 1,720,798 4.00 Provides overall management and direction for the Water Division. Provides support for all facilities and day-to-day operations, safety trainings and inspections, budget development and guidance, and special projects. Wellfield - General and Remote Station Maintenance 4,379,556 5,000 4,384,556 12.00 Performs required inspections per FDEP and South Florida Water Management District permits. Performs preventative maintenance and repairs to maintain operability of wells, remote repump stations, and the aquifer storage and recovery system. North County Regional Water Treatment Plant 4,632,734 500 4,633,234 16.00 Provides on-site supervision and production management for the treatment of potable water utilizing the membrane treatment process and the reverse osmosis treatment process. Northeast County Regional Water Treatment Plant 745,514 - 745,514 4.00 Provides on-site supervision and production management for the treatment of potable water utilizing the reverse osmosis treatment process. South County Regional Water Treatment Plant 6,061,883 1,000 6,062,883 22.00 Provides on-site supervision and production management for the treatment of potable water utilizing the lime softening process and the reverse osmosis treatment process. Water Distribution 6,396,690 165,000 6,561,690 39.00 Performs system-wide maintenance on the transmission and distribution systems. Provides for the maintenance and mapping of system assets to ensure reliability. Provides for the maintenance of all distribution system appurtenances including fire hydrants, sample stations, and air release valves. Provides for installation, inspection, and repair of cross connection control assemblies maintained by the Water District. Provides for inspection services for new construction of watermains and services by outside contractors. Provides for response to service requests from customers. Meter Operations 2,447,009 1,372,500 3,819,509 26.00 Provides data collection for usage from potable, irrigation quality, and fire meters. Responsible for the repair and maintenance of all system components of the meter reading system. Provides for the calibration and repair of large meters and the backflow assemblies associated with the large meters to ensure accuracy and compliance. Performs annual audit program of meters designed to improve asset visibility and internal controls. Provides for installation of new water meters and completes State mandated testing of all cross-connection control devices maintained by the County (3/4” to 2”). . Fiscal Year 2018 20 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department County Water-Sewer District Water Division (408) FY 2018 Budget FY 2018 Total FTE FY 2018 Revenues FY 2018 Net CostProgram Summary Water Power Systems & Instrumentation 1,248,281 - 1,248,281 8.00 Provides day-to-day management of the water power systems including electrical and instrumentation operations and all associated preventive maintenance and regulatory compliance. Coordinates with contractors and Project Managers to ensure successful completion of ongoing Capital Improvement Projects (CIPs). Provides input to water CIPs, Master Planning, and Rate Studies. Performs preventive maintenance and operates water power systems including the electrical, instrumentation, telemetry, and Supervisory Control and Data Acquisition (SCADA) for the wellfields and plants to ensure sustained compliance and preserve power system assets. Water Laboratory 1,115,335 - 1,115,335 7.00 Provides State drinking water certification and on-site supervision and quality control for the division’s laboratory services, protects the public from disease causing micro-organisms by monitoring source and finished water, and protects the public from chemical contaminants. 138.00 30,291,800 63,544,000 -33,252,200Current Level of Service Budget FY 2018BudgetFY 2018Total FTE FY 2018Revenues FY 2018Net CostProgram Enhancements Instrumentation & Electrical Technician 63,600 - 63,600 1.00 One Instrumentation/Electrical Technician is requested for the maintenance, calibration, and repair of all water production facilities, booster stations and wellfield systems to ensure compliance with SFWMD standards and perform preventative maintenance, work orders, and repairs to maintain operational reliability and compliance with South Florida Water Management District standards. The requested position will help ensure uninterrupted operation of critical services and compliance with all applicable codes, laws, rules, regulations, standards, policies and procedures. Maintenance Specialist (2) 108,800 - 108,800 2.00 Two Maintenance Specialists requested to maintain equipment, piping, pumps and process streams at the North County Regional Water Treatment Plant and South County Regional Water Treatment Plant. The duties of these positions include but are not limited to asset management, preventative maintenance and repairs, building and site regulations, policies, and procedures. Crew Leader 56,800 - 56,800 1.00 One Crew Leader to supervise team members assigned to the maintenance section of Distribution. The Crew Leader ensures all assets are maintained in compliance with local, state, and federal rules and regulations. As a result of an increasing number of conveyed assets in the potable water distribution network, including but not limited to valves, air release valves, services, flushing stations, blow offs, miles of pipeline and sample stations, additional state licensed staff are required to maintain compliance per Florida Administrative Code 62-555. Additional Radio - Water Administration 2,400 - 2,400 - The radio is needed for the Director’s vehicle to facilitate regular and emergency communication in the field. Fiscal Year 2018 21 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department County Water-Sewer District Water Division (408) FY 2018 Budget FY 2018 Total FTE FY 2018 Revenues FY 2018 Net CostProgram Enhancements Additional Power Washer 4,000 - 4,000 - The power washer is needed to clean pipes, structures, and buildings in preparation for protective coating application. Data Logging Equipment - Water Usage Analysis 4,400 - 4,400 - A Hersey Street Machine will provide a meter reading vehicle with the capability to extract hourly and daily meter reads for improved response to customer requests. Fluke Hart Calibration and Diagnostic Equipment 16,000 - 16,000 - This equipment tests the availability of power supply and ensures motor efficiencies to operate various electrical equipment including pumps and blowers. It is needed for plant, booster station, and field testing and calibration of equipment. 4.00 256,000 - 256,000Expanded Services Budget 142.00 30,547,800 63,544,000 -32,996,200Total Recom'd Budget FY 2017 FY 2018FY 2016 FY 2017 BudgetForecastBudgetActualProgram Performance Measures 65,000 63,000 62,000 58,000Compliance - Analyses Conducted 67,751 65,976 65,800 63,700Customer - Connection Points 3.33 3.14 3.18 2.98Production - Cost per 1,000 Gallons 9.10 9.05 9.10 8.90Production - Total Water (billions of gallons) ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 Program Budgetary Cost Summary 9,486,533 10,528,300 11,269,600 221,900 11,491,500 10,115,300 9.1%Personal Services 13,999,789 17,860,900 18,705,300 4,500 18,709,800 18,082,800 4.8%Operating Expense 425,990 199,500 316,900 29,600 346,500 242,200 73.7%Capital Outlay Net Operating Budget 23,912,313 28,588,700 30,291,800 256,000 30,547,800 28,440,300 6.9% 23,912,313 28,588,700 30,291,800 256,000 30,547,800 6.9% 28,440,300 Total Budget 128.00 134.00 138.00 4.00 142.00 6.0% 139.00 Total FTE Program Funding Sources ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 1,792,324 1,641,000 1,440,800 - 1,440,800 (12.2%) 1,401,745 Charges For Services 54,652,645 56,803,000 62,000,000 - 62,000,000 9.1% 59,700,000 Water Revenue 224,532 70,100 103,200 - 103,200 47.2% 103,555 Miscellaneous Revenues (32,757,188)(29,925,400)(33,252,200) 256,000 (32,996,200) 10.3%(32,765,000)Net Cost Co Water/Sewer Op Total Funding 30,547,800 23,912,313 28,588,700 30,291,800 256,000 6.9% 28,440,300 Forecast FY 2017: Personal services are forecast modestly below the adopted budget reflecting attrition savings. Operating costs are projected somewhat above budget primarily due to the mid-year addition of the Northeast Service Area (Orange Tree) and Other Contractual costs that rolled over from FY 16. The forecast position count reflects the mid-year addition of five Northeast Service Area (Orange Tree) related positions. Fiscal Year 2018 22 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department County Water-Sewer District Water Division (408) Revenue: Forecast FY 17 water revenue is 5% higher than budgeted and includes the mid-year addition of the Northeast Service Area. Current FY 2018: Personal Services and Operating expenses increase due to the first full year of the Northeast Service Area. Operating Expenses also increase due to Utility Parts, Contractual Services, and Rental Equipment, somewhat offset by decreases in Chemicals and Electricity made possible by Capital Improvement Projects. The FY 18 budgeted position count reflects the transfer out of one position related to the Security Professional position added to Public Utilities Admin and addition of five Northeast Service Area (Orange Tree) related positions. Current Level of Service Capital Outlay items: $124,800 - 52 Replacement Portable Radios $ 60,000 - 1 Replacement Skid Steer $ 38,000 - 1 Replacement Warehouse Fork Lift $ 25,000 - Replacement Machinery for the Northeast Service Area (Orange Tree) $ 15,000 - 1 Replacement Solar-Power Arrow Board $ 12,000 - 3 Replacement Mud Hog Pumps $ 11,200 - 8 Replacement Laptops $ 8,000 - 2 Replacement Turbidimeters $ 5,500 - 1 Replacement Base Radio $ 4,000 - 1 Replacement Trash Pump $ 3,400 - 1 Replacement Mobile Radio $ 3,000 - 1 Replacement Target Saw $ 3,000 - 1 Replacement Ammonia Meter $ 2,500 - 1 Replacement Fluke Wireless Meter $ 1,500 - 1 Replacement Ion Chromatography Column $316,900 - Total Current Level of Service (Replacement) Capital Outlay Expanded Level of Service Capital Outlay items: $ 16,000 - 1 Hart / Fluke Calibration Test Equipment $ 4,400 - 1 Data Logger $ 4,000 - 1 High Pressure Washer $ 2,800 - 2 Laptops – 1 for Crew Leader, 1 for I/E Tech $ 2,400 - 1 Portable Radio $ 29,600 - Total Expanded Level of Service (New) Capital Outlay $346,500 - Division Capital Outlay this budget page The purchase of new and replacement vehicles is budgeted in the Water/Sewer Motor Pool Fund (409). Revenues: Budgeted FY 2018 water revenue is 9.1% higher than the FY 2017 budget due to a 2.9% CPI rate increase, the first full year of the Northeast Service Area, and anticipated customer growth. Charges for Services revenue decrease 12.2% from FY 17 primarily due to lower Utilities Cutoff fees. Fiscal Year 2018 23 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department County Water-Sewer District Wastewater Division (408) Mission Statement To deliver best value, high quality, and sustainable wastewater and irrigation quality reclaimed water services that meet customers' expectations in an operationally compliant environment. FY 2018 Budget FY 2018 Total FTE FY 2018 Revenues FY 2018 Net CostProgram Summary Wastewater Management & Oversight -70,222,352 71,700,000 1,477,648 4.00 Provides overall management and direction for the Wastewater Division within County and State guidelines. Performs safety inspections, conducts training programs, and evaluates all safety incidents. North County Water Reclamation Facility 7,968,507 23,200 7,991,707 27.00 Provides day to day management of Plant operations and all associated preventive maintenance and regulatory compliance, and coordinates with contractors and Project Managers to successfully complete ongoing Capital Improvement Projects (CIPs). Provides input to wastewater CIPs, Master Plan, and Rate Studies. Provides effective wastewater treatment for reliable reuse production in accordance with all Florida Administrative Code (FAC) and United States Environmental Protection Agency (USEPA) rules. Provides residual management for activated sludge operations including treatment and compliant disposal in accordance with USEPA Rule 503 and FAC rules 17-7 and 17-640. Performs operations, preventive maintenance, and pro-active management of odor control and containment for both the North and South Water Reuse Facilities Odor Control Units. Northeast County Water Reclamation Facility 589,708 - 589,708 3.00 Provides day to day management of Plant operations and all associated preventive maintenance and regulatory compliance, and coordinates with contractors and Project Managers to successfully complete ongoing Capital Improvement Projects (CIPs). Provides input to wastewater CIPs, Master Plan, and Rate Studies. Provides residual management for activated sludge operations including treatment and compliant disposal in accordance with USEPA Rule 503 and FAC rules 17-7 and 17-640. South County Water Reclamation Facility 5,832,680 200 5,832,880 23.00 Provides day to day management of Plant operations and all associated preventive maintenance and regulatory compliance, and coordinates with contractors and Project Managers to successfully complete ongoing Capital Improvement Projects (CIPs). Provides input to wastewater CIPs, Master Plan, and Rate Studies. Provides effective wastewater treatment for reliable reuse production in accordance with all Florida Administrative Code (FAC) and United States Environmental Protection Agency (USEPA) rules. Provides residual management for activated sludge operations including treatment and compliant disposal in accordance with USEPA Rule 503 and FAC rules 17-7 and 17-640. Wastewater Collections 9,951,101 6,000 9,957,101 59.00 Fiscal Year 2018 24 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department County Water-Sewer District Wastewater Division (408) FY 2018 Budget FY 2018 Total FTE FY 2018 Revenues FY 2018 Net CostProgram Summary Provides day to day management of the wastewater collections system operations and all associated preventive maintenance and regulatory compliance. Coordinates with contractors and Project Managers and provides input to wastewater Capital Improvement Projects (CIPs), Master Planning, and Rate Studies. Maintains and operates transmission systems including force-mains, gravity-mains, laterals, and clean-outs. Performs in-house repairs for County-owned pumps and pro-active management of odor control and containment for both the wastewater lift stations and wastewater transmission systems in accordance with specific wastewater collections operations protocols to ensure sustained compliance and preserve the wastewater collection system assets for reliable and sustainable wastewater service to customers. Wastewater Reuse -1,589,366 3,601,700 2,012,334 6.00 Provides for transmission of irrigation quality (IQ) reuse water, reuse contracts administration, contractual and regulatory compliance, and coordinates with contractors and Project Managers to successfully complete Capital Improvement Projects (CIPs) for the reuse program. Provides input to reuse Master Planning and Rate Studies. Performs preventive maintenance to preserve reuse assets and ensure sustained delivery of reuse water to customers in compliance with the Florida Department of Environmental Protection (FDEP). Wastewater Power Systems & Instrumentation 1,666,265 5,000 1,671,265 14.00 Provides day to day management of the wastewater power systems including electrical and instrumentation operations and all associated preventive maintenance and regulatory compliance. Coordinates with contractors and Project Managers to successfully complete ongoing Capital Improvement Projects (CIPs). Provides input to wastewater CIPs, Master Planning, and Rate Studies. Performs preventive maintenance and operates wastewater power systems including the electrical, instrumentation, telemetry, and Supervisory Control and Data Acquisition (SCADA) for wastewater collections and the plants to ensure sustained compliance and preserve power system assets. Wastewater Environmental Compliance 549,557 662,000 1,211,557 11.00 Provides management of the laboratory certified through the Florida Department of Health and National Environmental Laboratory Accreditation Conference (NELAC) and compliance administration for the wastewater division including the Industrial Pretreatment Program. Provides for regulatory compliance through facility compliance analyses, groundwater sampling, injection and supplemental well monitoring, certification, and Quality Assurance/Quality Control pursuant to Florida Department of Environmental Protection (FDEP) Operating Permits. Performs industrial pretreatment and Fats Oil Grease programs to protect and preserve wastewater assets including transmission systems, lift stations, and treatment plants. Ensures regulatory compliance by performing facility audits pursuant to FDEP Operating Permit Pre-treatment requirements. 147.00 30,744,200 75,998,100 -45,253,900Current Level of Service Budget FY 2018 Budget FY 2018 Total FTE FY 2018 Revenues FY 2018 Net CostProgram Enhancements Fiscal Year 2018 25 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department County Water-Sewer District Wastewater Division (408) FY 2018 Budget FY 2018 Total FTE FY 2018 Revenues FY 2018 Net CostProgram Enhancements Instrumentation & Electrical Technician 63,600 - 63,600 1.00 Request converting one current job banker position (unbudgeted) to a full-time Instrumentation and Electrical Technician (I&E Tech) for the repair, maintenance, troubleshooting, preventative maintenance and calibration of electrical equipment and components in the Collections, water reclamation facilities and Irrigation Quality systems to maintain operational compliance with all local, state and federal rules and regulations, Maintenance Specialist (2) 107,800 - 107,800 2.00 Request two Maintenance Specialists to provide mission-critical front line service delivery, prevent sanitary sewer overflows and ensure the health, safety and welfare of all ratepayers. Maintenance Specialists are the first responders of the collections system and must ensure prompt, professional service during all calls. Miller Welder & Leak Detection Equipment 17,000 - 17,000 - Request the purchase of a truck-mounted welder and a leak detection unit for preventative and regular maintenance of mission-critical IQ equipment and repair of pump stations, assemblies, and service lines to adhere to compliance guidelines under FAC 62-610 for all permits under the Wastewater Division. 3.00 188,400 - 188,400Expanded Services Budget 150.00 30,932,600 75,998,100 -45,065,500Total Recom'd Budget FY 2017 FY 2018FY 2016 FY 2017 BudgetForecastBudgetActualProgram Performance Measures 42,948 42,607 42,948 41,938Compliance - Analysis with QAQC 68,300 66,832 63,700 62,425Customer - Sewer Connection Points 5.65 5.40 5.20 4.03Distribution - IQ Water Billions of Gallons 4.78 4.60 3.98 3.57Treatment - Cost per 1,000 Gallons 6.62 6.28 7.01 6.72Treatment - Wastewater Billions of Gallons ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 Program Budgetary Cost Summary 9,928,472 11,028,300 11,869,500 168,000 12,037,500 10,745,600 9.2%Personal Services 12,926,036 16,231,900 18,051,400 - 18,051,400 17,856,200 11.2%Operating Expense 222,155 310,600 823,300 20,400 843,700 463,100 171.6%Capital Outlay Net Operating Budget 23,076,663 27,570,800 30,744,200 188,400 30,932,600 29,064,900 12.2% 23,076,663 27,570,800 30,744,200 188,400 30,932,600 12.2% 29,064,900 Total Budget 137.00 142.00 147.00 3.00 150.00 5.6% 147.00 Total FTE Fiscal Year 2018 26 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department County Water-Sewer District Wastewater Division (408) Program Funding Sources ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 740,425 663,200 663,700 - 663,700 0.1% 733,700 Charges For Services 62,944,341 66,046,000 71,700,000 - 71,700,000 8.6% 68,160,000 Sewer Revenue 3,219,452 3,361,000 3,600,000 - 3,600,000 7.1% 3,600,000 Effluent Revenue 46,329 29,200 34,400 - 34,400 17.8% 87,200 Miscellaneous Revenues (43,873,884)(42,528,600)(45,253,900) 188,400 (45,065,500) 6.0%(43,516,000)Net Cost Co Water/Sewer Op Total Funding 30,932,600 23,076,663 27,570,800 30,744,200 188,400 12.2% 29,064,900 Forecast FY 2017: Personal services are forecast modestly below the adopted budget reflecting attrition savings. Operating costs are projected somewhat above budget primarily due to the mid-year addition of the Northeast Service Area (Orange Tree), Emergency Maintenance, and Chemicals. The FY 17 forecast position count reflects the addition of five Northeast Service Area (Orange Tree) related positions. Revenue: Forecast FY 17 wastewater revenue is 3% higher than budgeted and includes the mid-year addition of the Northeast Service Area. Current FY 2018: Personal Services and Operating expenses increase due to the first full year of the Northeast Service Area. Operating Expenses also increase due to Contractual Services and Utility Repairs. The FY 18 budgeted position count reflects the addition of five Northeast Service Area (Orange Tree) related positions. Current Level of Service Capital Outlay items: $ 200,000 - 30 Replacement 3 hp, 5 hp, & 10 hp Pumps $ 175,000 - 1 Replacement Tractor w/ Slope Mower with Side Arm Mower $ 60,000 - 1 Replacement Diesel Pump $ 54,400 - 16 Replacement Mobile Radios $ 48,200 - 26 Replacement Laptops $ 38,500 - 6 Replacement Refrigerator Samplers $ 38,000 - 1 Replacement Light Backhoe / Loader with Light Trackhoe $ 33,600 - 15 Replacement Portable Radios $ 32,000 - 1 Replacement Variable Frequency Devices $ 25,000 - 2 Replacement A/C Units $ 25,000 - Replacement Machinery for the Northeast Service Area (Orange Tree) $ 24,000 - 1 Replacement Autosamplers $ 16,000 - 4 Replacement Pipe Inspection Cameras $ 12,800 - 1 Replacement Utility Vehicle $ 12,000 - 1 Replacement BOD Incubator $ 7,000 - 1 Replacement Fluke Process Calibrator $ 6,000 - 2 Replacement Base Radios $ 5,600 - 3 Replacement Desktops $ 3,000 - 2 Replacement Concrete Saws $ 2,600 - 2 Replacement Poly Phase Testers $ 2,000 - 2 Replacement Voltage Testers $ 1,400 - 1 Replacement High Powered Scanner $ 1,200 - 1 Replacement Process Clamp Meter $823,300 - Total Current Level of Service (Replacement) Capital Outlay Expanded Level of Service Capital Outlay items: $ 13,500 - 1 Air Pak Welder $ 3,500 - 1 Leak Detection Unit Fiscal Year 2018 27 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department County Water-Sewer District Wastewater Division (408) $ 3,400 - 1 Mobile Radio $ 20,400 - Total Expanded Level of Service (New) Capital Outlay $843,700 - Division Capital Outlay this budget page The purchase of new and replacement vehicles is budgeted in the Water/Sewer Motor Pool Fund (409). Revenues: Budgeted FY 2018 sewer revenue is 8.6% higher than FY 2017 due to a 2.9% CPI rate increase, the first full year of the Northeast Service Area, and anticipated customer growth. Budgeted FY 2018 effluent revenue is 7.1% higher than FY 2017 including a 2.9% CPI rate increase. Charges for Services will not vary significantly. Fiscal Year 2018 28 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department County Water-Sewer District Reserves, Interest, and Transfers (408) FY 2018 Budget FY 2018 Total FTE FY 2018 Revenues FY 2018 Net CostProgram Summary Transfers 53,751,200 9,352,300 63,103,500 - Reserves -127,600 14,125,800 13,998,200 - - 77,101,700 23,478,100 53,623,600Current Level of Service Budget FY 2018BudgetFY 2018Total FTE FY 2018Revenues FY 2018Net CostProgram Enhancements Instrumentation & Electrical Technician -63,600 63,600 - - Request converting one current job banker position (unbudgeted) to a full-time Instrumentation and Electrical Technician (I&E Tech) for the repair, maintenance, troubleshooting, preventative maintenance and calibration of electrical equipment and components in the Collections, water reclamation facilities and Irrigation Quality systems to maintain operational compliance with all local, state and federal rules and regulations, Maintenance Specialist (2)-107,800 107,800 - - Request two Maintenance Specialists to provide mission-critical front line service delivery, prevent sanitary sewer overflows and ensure the health, safety and welfare of all ratepayers. Maintenance Specialists are the first responders of the collections system and must ensure prompt, professional service during all calls. Instrumentation & Electrical Technician -63,600 63,600 - - One Instrumentation/Electrical Technician is requested for the maintenance, calibration, and repair of all water production facilities, booster stations and wellfield systems to ensure compliance with SFWMD standards and perform preventative maintenance, work orders, and repairs to maintain operational reliability and compliance with South Florida Water Management District standards. The requested position will help ensure uninterrupted operation of critical services and compliance with all applicable codes, laws, rules, regulations, standards, policies and procedures. Maintenance Specialist (2)-108,800 108,800 - - Two Maintenance Specialists requested to maintain equipment, piping, pumps and process streams at the North County Regional Water Treatment Plant and South County Regional Water Treatment Plant. The duties of these positions include but are not limited to asset management, preventative maintenance and repairs, building and site regulations, policies, and procedures. Crew Leader -56,800 56,800 - - Fiscal Year 2018 29 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department County Water-Sewer District Reserves, Interest, and Transfers (408) FY 2018 Budget FY 2018 Total FTE FY 2018 Revenues FY 2018 Net CostProgram Enhancements One Crew Leader to supervise team members assigned to the maintenance section of Distribution. The Crew Leader ensures all assets are maintained in compliance with local, state, and federal rules and regulations. As a result of an increasing number of conveyed assets in the potable water distribution network, including but not limited to valves, air release valves, services, flushing stations, blow offs, miles of pipeline and sample stations, additional state licensed staff are required to maintain compliance per Florida Administrative Code 62-555. Two Additional Computers/Laptops -2,800 2,800 - - The 2 in 1 laptop tablets will enable Inventory Control staff to utilize CityWorks Asset Management software to simultaneously pick materials and complete corresponding transactions and material counts. Additional Radio and Laptop for Job Bank PM -4,000 4,000 - - These items will equip a Senior Project Manager Job Bank position focused on the execution of the Wastewater Capital Improvement Program (CIP) including maintenance of CCWSD assets at a manageable and sustainable risk level. The CIP supports uninterrupted operation of critical services and compliance with all applicable codes, laws, rules, regulations, standards, policies, and procedures. Additional Radio - Water Administration -2,400 2,400 - - The radio is needed for the Director’s vehicle to facilitate regular and emergency communication in the field. Additional Power Washer -4,000 4,000 - - The power washer is needed to clean pipes, structures, and buildings in preparation for protective coating application. Data Logging Equipment - Water Usage Analysis -4,400 4,400 - - A Hersey Street Machine will provide a meter reading vehicle with the capability to extract hourly and daily meter reads for improved response to customer requests. Fluke Hart Calibration and Diagnostic Equipment -16,000 16,000 - - This equipment tests the availability of power supply and ensures motor efficiencies to operate various electrical equipment including pumps and blowers. It is needed for plant, booster station, and field testing and calibration of equipment. Miller Welder & Leak Detection Equipment -17,000 17,000 - - Request the purchase of a truck-mounted welder and a leak detection unit for preventative and regular maintenance of mission-critical IQ equipment and repair of pump stations, assemblies, and service lines to adhere to compliance guidelines under FAC 62-610 for all permits under the Wastewater Division. Drone & 2 Additional Laptops -22,000 22,000 - - Fiscal Year 2018 30 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department County Water-Sewer District Reserves, Interest, and Transfers (408) FY 2018 Budget FY 2018 Total FTE FY 2018 Revenues FY 2018 Net CostProgram Enhancements A fixed wing UAS drone will enable the section to remotely sense data regarding large project sites, such as the proposed resource recovery park, SHWMD preserves, large acquisitions such as the Orange Tree Utility, and the County landfill, in a more cost effective manner than a vertical takeoff and landing (VTOL) system. The fixed wing system will be able to collect data on these large sites in a single flight, which will allow for more time for QA/QC of data and post processing of deliverables. Without the drone, large project sites will need to be outsourced at significantly higher cost. The laptops will be utilized for development testing for GIS / Enterprise Asset Management / Workforce / CityWorks. - - 473,200 -473,200Expanded Services Budget - 77,101,700 23,951,300 53,150,400Total Recom'd Budget ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 Program Budgetary Cost Summary - 220,200 196,300 - 196,300 220,200 (10.9%)Trans to 001 General Fund 218,500 218,500 218,500 - 218,500 218,500 0.0%Trans to 107 Impact Fee Admin 48,153 - - - - - Trans to 301 Co Wide Cap Fd na 1,795,200 2,707,300 811,500 - 811,500 2,887,300 (70.0%)Trans to 409 W/S MP Fd 5,095,568 3,870,500 6,830,300 - 6,830,300 3,870,500 76.5%Trans to 410 W/S Debt Serv Fd 16,988,600 17,194,400 20,343,500 - 20,343,500 17,436,200 18.3%Trans to 412 W User Fee Cap Fd 33,883,000 32,432,500 33,542,900 - 33,542,900 32,895,600 3.4%Trans to 414 S User Fee Cap Fd 138,400 139,600 145,200 - 145,200 139,600 4.0%Trans to 470 Solid Waste Fd - - 510,600 - 510,600 - Trans to 473 Mand Trash Coll na - - 245,900 - 245,900 - Trans to 505 IT Ops na - - 258,800 - 258,800 - Trans to 506 IT Capital na - 4,158,600 4,340,200 - 4,340,200 - 4.4%Reserves for Contingencies - 6,300,000 10,202,300 - 10,202,300 - 61.9%Reserves for Cash Flow - (527,200)(544,300) - (544,300) - 3.2%Reserves for Attrition 58,167,422 66,714,400 77,101,700 - 77,101,700 15.6% 57,667,900 Total Budget Program Funding Sources ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 261,936 155,100 283,000 - 283,000 82.5% 218,000 Interest/Misc 26,626,785 48,023,600 53,623,600 (473,200) 53,150,400 10.7% 23,974,100 Net Cost Co Water/Sewer Op 14,200 13,600 13,600 - 13,600 0.0% 13,600 Trans fm 109 Pel Bay MSTBU 500,000 500,000 510,000 - 510,000 2.0% 500,000 Trans fm 390 Gen Gov Fac Cap Fd 4,800 - - - - - Trans fm 409 W/S MP Fd na 527,500 534,400 572,200 - 572,200 7.1% 534,400 Trans fm 470 Solid Waste Fd 1,623,500 1,989,900 1,249,500 - 1,249,500 (37.2%) 1,989,900 Trans fm 473 Mand Collct Fd 28,608,700 21,958,100 27,858,400 473,200 28,331,600 29.0% 30,437,900 Carry Forward - (6,460,300)(7,008,600) - (7,008,600) 8.5% - Less 5% Required By Law Total Funding 77,101,700 58,167,422 66,714,400 77,101,700 - 15.6% 57,667,900 Notes: The Collier County Water-Sewer District manages its debt, reserves and transfers to optimize its cash position. User fees that customers pay for services fund the District’s operations (Fund 408), the repair and replacement (R&R) capital improvement projects (Funds 412 and 414), and the debt related to these projects (Fund 410). These user fees are deposited in the Operating Fund (408) and transferred to the other funds based on need and risk. Reserves and transfer for the District therefore must be viewed as a family Fiscal Year 2018 31 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department County Water-Sewer District Reserves, Interest, and Transfers (408) of funds. The linkage between these funds enables the utility to seek and obtain the best value funding for projects and facilitate a revenue-centric approach to optimize transfers between these funds. A risk based approach enable the District to defer projects based on measured risk and reduce that risk by executing projects at the appropriate time. Reserves for the District are categorized as either restricted (can be utilized for specific purposes, including impact fee related growth and to meet bond covenants) or unrestricted (considered discretionary, used only as and when needed). One of the financial metrics rating agencies such as Fitch and Moody’s review when determining credit ratings is unrestricted cash and liquidity. Maintaining a good credit rating allows the utility to borrow at favorable interest rates. The District currently has an investment grade of AAA from Fitch and an Aa1 rating from Moody’s. Unrestricted District reserves have been established based on the FY18 adopted reserve policy and on management’s perceived risk in operations and the R&R capital improvement projects. Unrestricted reserves for the Solid and Hazardous Waste Management Division must be adequate to meet the debris recovery mission in the event of a major disaster, and have been established in the FY18 proposed budget to meet the adopted reserve policy. Combined, the Public Utilities Department proposed FY18 budgeted unrestricted reserves reflect management’s commitment to ensuring operational continuity and compliance with regulatory agency requirements for unplanned and unanticipated events beyond the control of the Department’s enterprise operations. Operating Funds (408, 470, 473) – contingency reserves are established to meet unanticipated increases in commodity prices essential to the efficient production and delivery of services; cash flow reserves are funded in the event of a disaster that delays receipt of revenues necessary to fund operations. Capital R&R Funds (412, 414) – contingency reserves are established in the event that planned, critical project costs exceed budgeted costs in an environment where demand for contractor’s services is increasing; capital reserves are established to fund unanticipated projects that result from regulatory agency mandates and/or natural disasters. The District has approximately $1.3 billion of gross fixed assets. At the beginning of FY18, District principal outstanding debt will be approximately $165 million (comprised of $113 million in growth related debt and $52 million of user fee debt). Total budgeted FY18 debt service is $17.9 million. Fiscal Year 2018 32 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department Solid & Hazardous Waste Management Division ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 Department Budgetary Cost Summary 2,419,447 2,751,700 3,924,500 172,900 4,097,400 2,706,700 48.9%Personal Services 32,549,794 36,427,300 38,113,100 127,200 38,240,300 35,083,800 5.0%Operating Expense 322,800 460,200 495,600 - 495,600 460,200 7.7%Indirect Cost Reimburs 220,600 295,500 320,300 - 320,300 295,500 8.4%Payment In Lieu of Taxes 112,319 67,400 117,400 77,600 195,000 98,800 189.3%Capital Outlay 35,624,960 40,002,100 42,970,900 377,700 43,348,600 38,645,000 Net Operating Budget 8.4% - - 3,900,000 - 3,900,000 - Advance/Repay to 470 S Waste na 311,661 316,500 344,200 - 344,200 328,700 8.8%Trans to Property Appraiser 109,190 120,900 124,800 - 124,800 112,200 3.2%Trans to Tax Collector 983 - - - - - Trans to 301 Co Wide Cap Fd na 2,151,000 2,524,300 1,821,700 - 1,821,700 2,524,300 (27.8%)Trans to 408 Water/Sewer Fd 310,400 175,700 - - - 175,700 (100.0%)Trans to 470 Solid Waste Fd 240,000 98,500 274,300 - 274,300 98,500 178.5%Trans to 472 Sol Waste MP 1,956,000 4,116,400 9,544,100 - 9,544,100 4,116,400 131.9%Trans to 474 Solid Waste Cap Fd - - 43,700 - 43,700 - Trans to 506 IT Capital na - 3,700,600 4,138,700 - 4,138,700 - 11.8%Reserves for Contingencies - 3,567,400 24,700 - 24,700 - (99.3%)Reserves for Capital - 5,241,200 4,063,100 - 4,063,100 - (22.5%)Reserves for Cash Flow - (44,600)(50,900) - (50,900) - 14.1%Reserves for Attrition 40,704,194 59,819,000 67,199,300 377,700 67,577,000 13.0% 46,000,800 Total Budget ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 Appropriations by Program 19,904,815 20,558,200 23,636,800 7,600 23,644,400 20,913,400 15.0%Mandatory Trash Collection Fund (473) 15,720,145 19,443,900 19,334,100 370,100 19,704,200 17,731,600 1.3%Solid Waste Disposal Fund (470) Total Net Budget 40,704,194 59,819,000 67,199,300 377,700 67,577,000 13.0% 46,000,800 Total Budget Total Transfers and Reserves 35,624,960 40,002,100 38,645,000 42,970,900 377,700 43,348,600 5,079,234 19,816,900 7,355,800 24,228,400 - 24,228,400 8.4% 22.3% Department Funding Sources ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 1,736,191 1,617,000 1,747,000 - 1,747,000 8.0% 1,709,600 Franchise Fees 1,895 - - - - - Special Assessments na 112,552 100,000 100,000 - 100,000 0.0% 100,000 Intergovernmental Revenues 12,032,974 13,447,400 13,483,900 - 13,483,900 0.3% 12,964,200 Charges For Services 21,552,619 22,970,500 25,051,300 - 25,051,300 9.1% 22,943,600 Mandatory Collection Fees - - 15,000 - 15,000 - Fines & Forfeitures na 134,826 104,800 153,600 - 153,600 46.6% 149,300 Miscellaneous Revenues 196,681 98,000 124,200 - 124,200 26.7% 151,000 Interest/Misc - - 3,900,000 - 3,900,000 - Advance/Repay fm 471 Solid Waste na 6,450,528 7,633,500 7,841,300 - 7,841,300 2.7% 7,122,100 Reimb From Other Depts 42,499 - - - - - Trans frm Tax Collector na 630,000 630,000 325,000 - 325,000 (48.4%) 630,000 Trans fm 390 Gen Gov Fac Cap Fd 138,400 139,600 655,800 - 655,800 369.8% 139,600 Trans fm 408 Water / Sewer Fd 310,400 175,700 - - - (100.0%) 175,700 Trans fm 473 Mand Collct Fd 13,819,100 15,200,000 16,233,000 377,700 16,610,700 9.3% 16,526,400 Carry Forward - (2,297,500)(2,430,800) - (2,430,800) 5.8% - Less 5% Required By Law Total Funding 67,577,000 57,158,667 59,819,000 67,199,300 377,700 13.0% 62,611,500 Fiscal Year 2018 33 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department Solid & Hazardous Waste Management Division Department Position Summary Forecast FY 2017 Adopted Recom'd ChangeExpandedActualCurrent FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 31.00 34.00 34.00 3.00 37.00 8.8%Solid Waste Disposal Fund (470) 34.00 - - 9.00 - 9.00 Mandatory Trash Collection Fund (473) - na 31.00 34.00 43.00 3.00 46.00 35.3% 34.00 Total FTE Fiscal Year 2018 34 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department Solid & Hazardous Waste Management Division Solid Waste Disposal Fund (470) Mission Statement Provide an efficient and economical balance of public and private services to meet federal, state, and local regulations for solid waste disposal in a manner that ensures public health and safety, reduces the solid waste stream, increases public awareness of recycling, and adheres to the guiding principles of environmental and growth management compliance, airspace preservation, operational excellence, and best value service. FY 2018 Budget FY 2018 Total FTE FY 2018 Revenues FY 2018 Net CostProgram Summary Management & Oversight 1,215,376 - 1,215,376 4.00 Responsible for the management and implementation of the Board approved Integrated Solid Waste Management Strategy. The core components of this section encompass the program’s vision and objectives through the utilization of short- and long-term strategic, financial, and emergency management planning, landfill-gas-to-energy, community development, solid waste capital project management, annual update and inventory reporting, and environmental compliance of all Solid & Hazardous Waste Management Division (SHWMD) programs. Solid Waste Operations -7,643,783 21,489,000 13,845,217 14.00 Responsible for the logistical management, environmental permitting, financial compliance, sustainability, and program growth of the Collier County Landfill, Eustis Landfill, Scalehouse, Immokalee Transfer Station, and the Naples, Marco Island, North Collier, North East, and Carnestown Recycling Drop-off Centers. The mission is to provide safe and efficient centralized facilities throughout the community for collection and proper disposal of materials to mitigate the solid waste stream. These collection and disposal facilities maintain compliance with local, state, and federal regulations through scheduled inspection audits that ensure execution of active permits, Florida Department of Environmental Protection (DEP) regulations, and the Landfill Operating Agreement. Waste Reduction & Recycling 1,071,926 - 1,071,926 5.00 Responsible for preserving valuable landfill disposal airspace by developing and implementing innovative waste reduction, reuse, and recycling programs while protecting natural resources at best value. Raises, maintains, and reinforces awareness related to the importance of waste reduction, reuse, and recycling through collaborative business partnerships, strategic marketing and advertising campaigns, and educational outreach to businesses, government agencies, schools, single and multi-family residents, and events. Monitors, maintains, and promotes compliance with Recycling Ordinance No. 2009-56 and Florida’s 75% recycling goal by 2020. Environmental Compliance 2,493,063 - 2,493,063 8.00 Provides environmental compliance measures to support and adhere to federal, state, and local regulations for the Hazardous Materials Collection Center and Hazardous Materials Management Program. Ensures the Center and Program are managed properly for compliant and financially efficient hazardous materials transport, storage, and disposal by private disposal contractors. Protects public health, safety, and the environment from improper management of commercially generated hazardous waste through performance of regular Small Quantity Generator compliance assistance verification inspections at county-registered businesses that have the potential to generate, store, transport, or dispose of hazardous materials. Petroleum Storage Tanks Compliance & Management 209,618 178,600 388,218 3.00 Fiscal Year 2018 35 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department Solid & Hazardous Waste Management Division Solid Waste Disposal Fund (470) FY 2018 Budget FY 2018 Total FTE FY 2018 Revenues FY 2018 Net CostProgram Summary Protects the county’s groundwater, surface water, and soils from pollutant releases through regular inspections of state-registered pollutant storage tank facilities under contract with the Florida Department of Environmental Protection (FDEP) Petroleum Storage Tanks Program, and through monitoring of county-owned storage tanks on behalf of the Risk Management Division for the individual county divisions that own the tanks (Interdivisional Tanks Program). Ensures compliance with state and federal regulations and lessens the risk of hazardous releases from both private commercial and county-owned and insured storage tanks. Quantifies the exposure to risk and insurance coverage for county-owned tanks. Verifies and assures, through effective communications and onsite inspections, consistent compliance with state law. Educates and trains county team members to maintain compliance. Avoids costly cleanups resulting from preventable releases. Solid & Hazardous Waste Mgt Division Payment in Lieu of Taxes 320,300 - 320,300 - Transfers 2,333,500 5,626,500 7,960,000 - Reserves - 4,078,200 4,078,200 - The Solid and Hazardous Waste division is responsible for the right of way disaster debris removal on County roads and monitoring project for Collier County in the event of a natural disaster. Reserves are provided in part to ensure the maintenance of services to the public during non-routine and unforeseen disaster situations such as hurricanes and other weather-related events, as well as other environment or natural disasters that cause disruptions in public services. 34.00 31,372,300 31,372,300 -Current Level of Service Budget FY 2018 Budget FY 2018 Total FTE FY 2018 Revenues FY 2018 Net CostProgram Enhancements NE Recycling Center Staffing (3), Operating Expenses and Equipment - 329,900 329,900 3.00 Staffing and related operating expenses and equipment to support the North East Recycling Center. Positions Include: Crew Leader, Solid Waste Specialist and a Recycling Specialist. Equipment includes three roll-off containers and a bulb crusher. Equipment for Environmental Compliance Section - 18,000 18,000 - Palletizer Wrapping System and Ride-On Floor Cleaner North Collier Recycling Center - Bulb Crusher - 5,000 5,000 - Additional Bulb Crusher Machine Additional Computers & Radios - 17,200 17,200 - Fiscal Year 2018 36 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department Solid & Hazardous Waste Management Division Solid Waste Disposal Fund (470) FY 2018 Budget FY 2018 Total FTE FY 2018 Revenues FY 2018 Net CostProgram Enhancements Solid Waste Admin. - two additional radios, North Collier Recycling Center - one additional laptop, Waste Reduction - three additional radios and two additional laptops for job bank Recycling Specialists. The radios are to support routine and emergency communications. The laptop at the North Collier Recycling Center will be integrated to SMS Turbo and utilized to generate mobile tickets. The laptops for Waste Reduction will enable Recycling Specialist Job Bank positions to perform data collection and verification for recycling programs between office and field work and provide public outreach and education to the residential community, schools, local businesses, and local government in support of the Integrated Solid Waste Management Strategy adopted by the Board of County Commissioners on December 5, 2006 and the state’s 75% recycling goal. 3.00 370,100 370,100 -Expanded Services Budget 37.00 31,742,400 31,742,400 -Total Recom'd Budget FY 2017 FY 2018FY 2016 FY 2017 BudgetForecastBudgetActualProgram Performance Measures 76,672 63,500 63,500 53,658Customer Served at the Recycling Centers 87 87 87 86Diversion Rate (%) 68 67 67 65FDEP Recycling Rate (%) 2,280,040 2,072,764 2,398,307 2,010,723Hazardous Waste (Pounds) 300 280 250 180Number of Interdepartmental Tank Inspections 360 350 340 320Number of Petroleum Storage Tank Facility Inspections 630 600 600 560Number of Petroleum Storage Tank Inspections 2,100 2,000 1,700 1,600Number of Small Quantity Generator Compliance Inspections ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 Program Budgetary Cost Summary 2,419,447 2,751,700 2,970,400 172,900 3,143,300 2,706,700 14.2%Personal Services 12,733,479 15,976,000 15,547,100 127,200 15,674,300 14,277,300 (1.9%)Operating Expense 234,300 353,300 378,900 - 378,900 353,300 7.2%Indirect Cost Reimburs 220,600 295,500 320,300 - 320,300 295,500 8.4%Payment In Lieu of Taxes 112,319 67,400 117,400 70,000 187,400 98,800 178.0%Capital Outlay Net Operating Budget 15,720,145 19,443,900 19,334,100 370,100 19,704,200 17,731,600 1.3% 983 - - - - - Trans to 301 Co Wide Cap Fd na 527,500 534,400 572,200 - 572,200 534,400 7.1%Trans to 408 Water/Sewer Fd 240,000 98,500 236,900 - 236,900 98,500 140.5%Trans to 472 Sol Waste MP 906,000 1,915,900 7,344,100 - 7,344,100 1,915,900 283.3%Trans to 474 Solid Waste Cap Fd - - 43,700 - 43,700 - Trans to 506 IT Capital na - 1,644,800 1,970,400 - 1,970,400 - 19.8%Reserves for Contingencies - 2,135,400 1,921,800 - 1,921,800 - (10.0%)Reserves for Cash Flow - (44,600)(50,900) - (50,900) - 14.1%Reserves for Attrition 17,394,627 25,728,300 31,372,300 370,100 31,742,400 23.4% 20,280,400 Total Budget 31.00 34.00 34.00 3.00 37.00 8.8% 34.00 Total FTE Fiscal Year 2018 37 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department Solid & Hazardous Waste Management Division Solid Waste Disposal Fund (470) Program Funding Sources ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 112,552 100,000 100,000 - 100,000 0.0% 100,000 Intergovernmental Revenues 11,824,956 13,236,200 13,482,500 - 13,482,500 1.9% 12,756,100 Charges For Services 79,824 49,800 98,600 - 98,600 98.0% 94,300 Miscellaneous Revenues 50,291 36,000 51,000 - 51,000 41.7% 51,000 Interest/Misc - - 3,900,000 - 3,900,000 - Advance/Repay fm 471 Solid Waste na 6,450,528 7,633,500 7,841,300 - 7,841,300 2.7% 7,122,100 Reimb From Other Depts 138,400 139,600 145,200 - 145,200 4.0% 139,600 Trans fm 408 Water / Sewer Fd 310,400 175,700 - - - (100.0%) 175,700 Trans fm 473 Mand Collct Fd 5,399,100 5,409,200 6,832,400 370,100 7,202,500 33.2% 7,044,100 Carry Forward - (1,051,700)(1,078,700) - (1,078,700) 2.6% - Less 5% Required By Law Total Funding 31,742,400 24,366,052 25,728,300 31,372,300 370,100 23.4% 27,482,900 Forecast FY 2017: Personal service expenses are forecast consistent with the adopted budget. Operating expenses are projected lower for the Landfill Contract and Contractual Services to dispose of electronics and household hazardous waste. Current FY 2018: The current services personal services budget is increased by $113,600 for additional job bank staffing as well as a $21,200 increase in worker's compensation insurance. Reduced landfill tonnage projections all the landfill operating contract budget to be established approximately $619,000 lower than the FY 17 budgeted level. Current Level of Service Capital Outlay items: $ 80,400 - 32 Replacement Radios $ 18,500 - 11 Replacement Computers $ 8,000 - 1 Replacement Riding Lawn Mower $ 5,500 - 1 Replacement Used Oil Storage Tank $ 5,000 - 1 Replacement Bulb Crusher $117,400 - Total Current Level of Service Capital Outlay Expanded Level of Service Capital Outlay items: $ 21,000 - 3 30 Yard Roll Off Containers $ 14,000 - 1 Ride On Floor Cleaner $ 12,000 - 5 Radios $ 10,000 - 2 Bulb Crushers $ 4,000 - 1 Palletizer Wrapping System $ 9,000 - 5 Computers $ 70,000 - Total Expanded Level of Service Capital Outlay $187,400 - Division Capital Outlay this budget page The purchase of new and replacement vehicles is budgeted in the Solid Waste Motor Pool Fund (472). The transfer to Solid Waste Motor Pool Fund (472) is increased from $98,500 to $236,900. The Transfer to Solid Waste Capital Fund (474) is established at $7,344,100 primarily to fund the Landfill Leachate Deep Injection Well project. Revenues: The budget is primarily supported by landfill tipping fees. Tipping fees are increased 2.9% for both residential and commercial. The Charges for Services category includes landfill tipping fees of $13,060,500, Recycling Drop-off Center fees of $92,800, and Landfill Gas-to-Energy Facility revenue of $240,400. The Landfill tipping fee cost for the Mandatory Trash Collection program is budgeted at $7,762,700 and is included in the Reimbursement from Other Departments category. The Petroleum Storage Tanks Inspection Program contributes $100,000 from private tank inspections and $78,600 from County owned tank inspections. Other sources include Fiscal Year 2018 38 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department Solid & Hazardous Waste Management Division Solid Waste Disposal Fund (470) a reimbursement from Water/Sewer Fund (408), scrap sales and carryforward. Fiscal Year 2018 39 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department Solid & Hazardous Waste Management Division Solid Waste Landfill Closure Costs Fund (471) Mission Statement To comply with the Florida Department of Environmental Protection's landfill closure requirements. Funds are held in a restricted reserve for post closure liabilities and compliance requirements, to include long-term monitoring. FY 2018 Budget FY 2018 Total FTE FY 2018 Revenues FY 2018 Net CostProgram Summary Solid & Hazardous Waste Landfill Closure Costs - 3,924,700 3,924,700 - Closure assessment and long term monitoring. - 3,924,700 3,924,700 -Current Level of Service Budget ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 Program Budgetary Cost Summary - - 3,900,000 - 3,900,000 - Advance/Repay to 470 S Waste na - 3,567,400 24,700 - 24,700 - (99.3%)Reserves for Capital - 3,567,400 3,924,700 - 3,924,700 10.0% - Total Budget Program Funding Sources ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 26,301 15,000 15,000 - 15,000 0.0% 20,000 Interest/Misc 630,000 630,000 325,000 - 325,000 (48.4%) 630,000 Trans fm 390 Gen Gov Fac Cap Fd 2,279,200 2,923,200 3,585,500 - 3,585,500 22.7% 2,935,500 Carry Forward - (800)(800) - (800) 0.0% - Less 5% Required By Law Total Funding 3,924,700 2,935,501 3,567,400 3,924,700 - 10.0% 3,585,500 Forecast FY 2017: The Solid Waste Landfill Closure Fund is a reserve for closure of the current, and future, closed landfill cells within the county’s responsibility, including Immokalee, and the Collier County Landfill (cells three and four). Managing and maintaining a closed landfill is expensive and potentially risky, especially in an environmentally sensitive area. On March 10, 2009, the Board of County Commissioners approved a transfer in the amount of $4,618,891 to the General Government Facilities Impact Fee Fund (390) for the purchase of the Elks Club building to reduce the number of county agencies operating out of leased space. To date, the fund has received $4,252,500 from Fund (390). Current FY 2018: The final of eight planned repayments from the 2009 loan is anticipated from Fund (390) during FY 18 to Fund (471). In FY 18, $3,900,000 will be advanced to Fund 470 to contribute to funding the construction of a deep injection well for leachate disposal. The deep injection well is planned to be operational in FY 2020, and savings on leachate disposal expenses will then be used to repay the loan. Fiscal Year 2018 40 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department Solid & Hazardous Waste Management Division Mandatory Trash Collection Fund (473) Mission Statement Protect the health and safety of citizens of Collier County by providing collection, disposal, and code education and compliance activities related to the solid waste stream generated in the county. FY 2018 Budget FY 2018 Total FTE FY 2018 Revenues FY 2018 Net CostProgram Summary Solid Waste Residential Collections Operations -2,835,100 25,107,700 22,272,600 - Administration of the Solid Waste Collections System that includes contract administration, short and long term financial planning, and growth management planning. Provides sound accounting standards to the financial operations within the trash collection program. Public Utilities Ordinance Education & Compliance Enforcement 1,232,500 15,000 1,247,500 9.00 This program provides education and compliance activities for all Public Utilities Department (PUD) enterprise-related ordinances through recognition and containment of situations that pose direct threats to public health and safety. Core functions include education about water-sewer and solid waste disposal and collection ordinances, irrigation regulations, on-site response to residential and commercial customer inquiries about solid waste collection and disposal issues, and investigation and resolution of utility ordinance and standards violations including meter tampering and illegal connections to the potable public water supply. This program also includes monitoring the contractors’ execution of solid waste collection services in accordance with the Franchise Agreements, inspection of franchised hauler vehicles, issuance of exemption certificates and vehicle inspections for self-hauling trash on county roadways, review of site development plans to ensure adequate solid waste collection facilities are included in the design, and unit sweeps to determine the correct number of units per parcel for the residential curbside solid waste assessment rolls. These activities are concentrated in the unincorporated area of Collier County, the City of Marco Island, and Everglades City. Solid Waste Residential Collections Franchisees -1,747,000 1,747,000 - - Provides payment to Mandatory Trash Collection franchisees in accordance with the Mandatory Trash Collection Ordinance and the Solid Waste Franchisee agreements for the number of units served curbside. Solid Waste Residential Collections Indirect Cost Reimbursement 116,700 - 116,700 - Transfers 3,445,300 510,600 3,955,900 - Reserves -212,400 4,522,000 4,309,600 - 9.00 31,902,300 31,902,300 -Current Level of Service Budget FY 2018 Budget FY 2018 Total FTE FY 2018 Revenues FY 2018 Net CostProgram Enhancements Additional Computers & Radios - 7,600 7,600 - Fiscal Year 2018 41 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department Solid & Hazardous Waste Management Division Mandatory Trash Collection Fund (473) FY 2018 Budget FY 2018 Total FTE FY 2018 Revenues FY 2018 Net CostProgram Enhancements Utilities Education and Ordinance Compliance - two additional radios and two additional laptops This equipment will enable Code Enforcement Investigator Job Bank positions to maintain the level of service to water-sewer and solid waste customers in the growing northeast section of Collier County. - 7,600 7,600 -Expanded Services Budget 9.00 31,909,900 31,909,900 -Total Recom'd Budget FY 2017 FY 2018FY 2016 FY 2017 BudgetForecastBudgetActualProgram Performance Measures 128,771 123,690 125,163 118,943Curbside Tons Collected 207.40 190.31 190.31 188.29District 1 - Mandatory Trash Collection Rate 8.98 1.07 1.07 3.25District 1 - Percentage of Rate Change Over Previous Year 198.41 181.45 181.45 177.34District 2 - Mandatory Trash Collection Rate 9.35 2.32 2.32 4.10District 2 - Percentage of Rate Change Over Previous Year 126,300 123,275 121,716 119,809No. of Residential Curbside Accounts at Year End ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 Program Budgetary Cost Summary - - 954,100 - 954,100 - Personal Services na 19,816,315 20,451,300 22,566,000 - 22,566,000 20,806,500 10.3%Operating Expense 88,500 106,900 116,700 - 116,700 106,900 9.2%Indirect Cost Reimburs - - - 7,600 7,600 - Capital Outlay na Net Operating Budget 19,904,815 20,558,200 23,636,800 7,600 23,644,400 20,913,400 15.0% 311,661 316,500 344,200 - 344,200 328,700 8.8%Trans to Property Appraiser 109,190 120,900 124,800 - 124,800 112,200 3.2%Trans to Tax Collector 1,623,500 1,989,900 1,249,500 - 1,249,500 1,989,900 (37.2%)Trans to 408 Water/Sewer Fd 310,400 175,700 - - - 175,700 (100.0%)Trans to 470 Solid Waste Fd - - 37,400 - 37,400 - Trans to 472 Sol Waste MP na 1,050,000 2,200,500 2,200,000 - 2,200,000 2,200,500 0.0%Trans to 474 Solid Waste Cap Fd - 2,055,800 2,168,300 - 2,168,300 - 5.5%Reserves for Contingencies - 3,105,800 2,141,300 - 2,141,300 - (31.1%)Reserves for Cash Flow 23,309,566 30,523,300 31,902,300 7,600 31,909,900 4.5% 25,720,400 Total Budget - - 9.00 - 9.00 - Total FTE na Fiscal Year 2018 42 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department Solid & Hazardous Waste Management Division Mandatory Trash Collection Fund (473) Program Funding Sources ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 1,736,191 1,617,000 1,747,000 - 1,747,000 8.0% 1,709,600 Franchise Fees 1,895 - - - - - Special Assessments na 208,019 211,200 1,400 - 1,400 (99.3%) 208,100 Charges For Services 21,552,619 22,970,500 25,051,300 - 25,051,300 9.1% 22,943,600 Mandatory Collection Fees - - 15,000 - 15,000 - Fines & Forfeitures na 55,002 55,000 55,000 - 55,000 0.0% 55,000 Miscellaneous Revenues 120,089 47,000 58,200 - 58,200 23.8% 80,000 Interest/Misc 42,499 - - - - - Trans frm Tax Collector na - - 510,600 - 510,600 - Trans fm 408 Water / Sewer Fd na 6,140,800 6,867,600 5,815,100 7,600 5,822,700 (15.2%) 6,546,800 Carry Forward - (1,245,000)(1,351,300) - (1,351,300) 8.5% - Less 5% Required By Law Total Funding 31,909,900 29,857,114 30,523,300 31,902,300 7,600 4.5% 31,543,100 Forecast FY 2017: Operating expenses are somewhat higher than budget due to approximately 600 more customers than budgeted resulting in higher costs for disposal charges. Forecast Revenue for Mandatory Collections is in line with budget. Current FY 2018: The most visible budget change is the movement into this budget of nine positions associated with the Public Utilities Ordinance Education & Compliance function previously budgeted in Collier County Water-Sewer District (CCWSD) Fund (408). Also provided is an increased job bank employee allowance of $255,800 which is critical to maintain the level of service to all solid waste and water-sewer customers in the growing northeast area of Collier County. This budget has been relocated to Fund 473 because the majority of work performed supports the Solid Waste Collections program. A cost transfer is included in the budget to ensure the CCWSD continues to bear the proportionate cost associated with the respective services received. To support the CCWSD component of Ordinance Education & Enforcement function, a transfer from CCWSD Fund (408) for $510,600 is provided. The mandatory collection franchisee contractual CPI increase is 1.43%. The residential tipping fee rate increase is 2.9%. Increased expense driven by rate is anticipated at $185,000. An estimated 3,900 or additional 3.2% new residential accounts are anticipated. Increased expense driven by volume is anticipated at $418,000. Expanded Level of Service Capital Outlay items: $ 4,800 - 2 Portable Radios $ 2,800 - 2 Surface Pros $ 7,600 - Total Expanded Level of Service Capital Outlay $ 7,600 - Division Capital Outlay this budget page The purchase of new and replacement vehicles is budgeted in the Solid Waste Motor Pool Fund (472). The transfer to Solid Waste Capital Fund (474) is maintained at $2,200,000 in part to support the Landfill Leachate Deep Injection Well project. Revenues: Driven by the contractual CPI adjustment to collection franchisees, landfill tipping fee increases, and operating expenses to ensure level of service to the growing customer base, the mandatory solid waste residential assessment fee is budgeted to increase. The mandatory solid waste residential assessment fee for customers in District I is budgeted to increase from $190.31 to $207.40 or 8.98% which equates to $1.42 per month. The mandatory solid waste residential assessment fee for customers in District II is budgeted to increase from $181.45 to $198.41 or 9.35%, or $1.41 per month. These assessment fee increases and the addition of an estimated 3,900 customer accounts in FY 2018 result in a total budgeted revenue increase of 9.1%. This is lower than the district rate changes because the assessments may be discounted up to 4% depending on the month the tax bill is paid. Fiscal Year 2018 43 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department Facilities Management Division ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 Department Budgetary Cost Summary 4,729,061 5,598,000 6,148,100 - 6,148,100 5,731,700 9.8%Personal Services 8,985,128 8,395,800 8,891,400 - 8,891,400 8,436,700 5.9%Operating Expense 1,489,460 157,500 86,600 - 86,600 97,800 (45.0%)Capital Outlay - - - - - 68,800 Remittances na 15,203,649 14,151,300 15,126,100 - 15,126,100 14,335,000 Net Operating Budget 6.9% 630,000 630,000 325,000 - 325,000 630,000 (48.4%)Advance/Repay to 390 Gov't Fac - 873,400 886,900 - 886,900 - 1.5%Reserves for Capital 15,833,649 15,654,700 16,338,000 - 16,338,000 4.4% 14,965,000 Total Budget ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 Appropriations by Program 27,418 23,000 67,700 - 67,700 23,000 194.3%Americans with Disabilities Act (190) 13,067,673 13,312,600 14,309,100 - 14,309,100 13,536,000 7.5%Facilities Management (001) 1,442,444 79,200 20,600 - 20,600 29,500 (74.0%)Freedom Memorial (620) 13 700 700 - 700 68,900 0.0%GAC Land Trust Fund (605) 666,101 735,800 728,000 - 728,000 677,600 (1.1%)Real Property Management (001) Total Net Budget 15,833,649 15,654,700 16,338,000 - 16,338,000 4.4% 14,965,000 Total Budget Total Transfers and Reserves 15,203,649 14,151,300 14,335,000 15,126,100 - 15,126,100 630,000 1,503,400 630,000 1,211,900 - 1,211,900 6.9% (19.4%) Department Funding Sources ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 13,999 17,100 19,200 - 19,200 12.3% 10,000 Charges For Services 166,057 36,700 76,700 - 76,700 109.0% 77,800 Miscellaneous Revenues 23,151 5,500 3,500 - 3,500 (36.4%) 4,200 Interest/Misc 772,690 474,600 742,700 - 742,700 56.5% 673,400 Reimb From Other Depts 13,456,503 13,985,700 14,344,500 - 14,344,500 2.6% 13,907,000 Net Cost General Fund - 85,200 85,200 - 85,200 0.0% 85,200 Trans fm 113 Comm Dev Fd - 113,200 130,000 - 130,000 14.8% 113,200 Trans fm 408 Water / Sewer Fd 2,433,700 938,500 938,300 - 938,300 0.0% 1,032,500 Carry Forward - (1,800)(2,100) - (2,100) 16.7% - Less 5% Required By Law Total Funding 16,338,000 16,866,099 15,654,700 16,338,000 - 4.4% 15,903,300 Department Position Summary Forecast FY 2017 Adopted Recom'd ChangeExpandedActualCurrent FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 50.00 59.00 57.00 - 57.00 (3.4%)Facilities Management (001) 57.00 7.00 7.00 7.00 - 7.00 0.0%Real Property Management (001) 7.00 57.00 66.00 64.00 - 64.00 (3.0%) 64.00 Total FTE Fiscal Year 2018 44 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department Facilities Management Division Facilities Management (001) Mission Statement To provide safe, secure, clean, and comfortable facilities for our citizens and employees by ensuring all buildings, grounds, and property acquisitions are managed, maintained, and operated to the highest standards; through asset preservation and operational excellence, while ensuring public health and safety. FY 2018 Budget FY 2018 Total FTE FY 2018 Revenues FY 2018 Net CostProgram Summary Management & Oversight 1,031,480 - 1,031,480 3.00 Responsible for the overall management and direction for the Facilities Management Division. This program drives the Division’s vision and objectives through the utilization of short and long term strategic planning, financial planning, energy management, annual update and inventory reporting, master space planning, and emergency management planning. Directs the functions and activities of the Division, including Building Management, Construction Management, Real Property Management, and Government Security. . Building Repair and Maintenance: 8,137,773 603,200 8,740,973 44.00 Responsible for the logistical management, maintenance, financial compliance, sustainability and condition assessment of Collier County government buildings and structures. Through continuously improving preventative and predictive maintenance programs, Facilities Management strives to provide safe, secure and well maintained facilities that are accessible to all persons . This section manages the maintenance functions and activities of the Division, including electrical, low-voltage, plumbing, heating, ventilation and air conditioning (HVAC), structural repairs, physical energy plant, pest control, as well as fire systems maintenance and compliance; Coordinates the preventative maintenance programs for the County’s structures and building related assets, which in return avoids emergency repairs and prevents loss of public services and County staff productivity; Ensures County facilities are clean, safe, and productive through indoor air quality services, which include investigations and remediation. Building management cost includes operating, personnel, and capital expenses . . Capital Construction/Renovation 1,017,264 - 1,017,264 9.00 Responsible for the management of Collier County vertical construction and renovation projects that provide high-quality, best-value government facilities to residents, visitors, and staff; Delivers project management services to the Board of County Commissioners as well as the constitutional offices that include the Clerk of the Courts, Supervisor of Elections, Property Appraiser, Tax Collector, and the Collier County Sheriff’s Office; Provides in-house construction administration services and project management for BCC owned and leased facilities, including new vertical construction, space renovations, roof replacements, HVAC system replacements and warranty work. Campus Utilities 309,100 - 309,100 - Provide funds for payments to utility companies for portions of electrical, trash, water and sewer costs for County facilities. Contract Services 2,208,233 - 2,208,233 1.00 Fiscal Year 2018 45 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department Facilities Management Division Facilities Management (001) FY 2018 Budget FY 2018 Total FTE FY 2018 Revenues FY 2018 Net CostProgram Summary Provides clean, safe, and productive work environment for the residents, visitors, and staff, through collaboration between County staff and contracted vendors. Custodial services deliver competitive janitorial cleaning, trash removal, and recycling services to 132 buildings. Grounds maintenance provides competitive landscape services to the County’s main campus and 47 satellite properties, including irrigation, fertilization, and mulching. Government security delivers the necessary resources for the detection of contraband and the protection of residents, visitors, employees, judges, and elected officials. Government Security is comprised of security checkpoint staffing, interior and exterior patrols, along with security building audits for Main Courthouse and Government Center, Building F, Building H, Immokalee Government Center, North Collier Government Center, GMD Planning and Regulation, and the Emergency Services Center. The Division additionally provides contract maintenance services for, HVAC preventative maintenance, water system maintenance, pest control, elevator maintenance, air filter replacements, and fire system certifications. . Government Security 1,327,050 - 1,327,050 - Provides the necessary resources for detection of contraband and the protection of judiciary, elected officials, employees, and visitors with optimum customer service. This includes, but is not limited to, security checkpoint staffing as well as interior and exterior foot patrols at county facilities, specifically the Main Courthouse and Government Center, Building F, Building H, Immokalee Government Building, North Collier Government Center and the Emergency Service Center. 57.00 14,634,100 603,200 14,030,900Current Level of Service Budget FY 2018 Budget FY 2018 Total FTE FY 2018 Revenues FY 2018 Net CostProgram Enhancements - - - -Expanded Services Budget 57.00 14,634,100 603,200 14,030,900Total Recom'd Budget FY 2017 FY 2018FY 2016 FY 2017 BudgetForecastBudgetActualProgram Performance Measures 11 13 13 13Average Days to Complete Work Orders 3.14 3.04 2.97 2.87Cost per square foot 550,000 553,000 600,000 570,000Persons scanned 10 12 10 10Security surveys conducted 4,390,000 4,382,000 4,365,000 4,357,000Total square feet maintained 30,000 29,100 35,000 30,000Total Work Orders Fiscal Year 2018 46 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department Facilities Management Division Facilities Management (001) ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 Program Budgetary Cost Summary 4,097,080 4,923,500 5,487,200 - 5,487,200 5,113,500 11.4%Personal Services 8,930,798 8,310,800 8,745,900 - 8,745,900 8,344,200 5.2%Operating Expense 39,795 78,300 76,000 - 76,000 78,300 (2.9%)Capital Outlay Net Operating Budget 13,067,673 13,312,600 14,309,100 - 14,309,100 13,536,000 7.5% 630,000 630,000 325,000 - 325,000 630,000 (48.4%)Advance/Repay to 390 Gov't Fac 13,697,673 13,942,600 14,634,100 - 14,634,100 5.0% 14,166,000 Total Budget 50.00 59.00 57.00 - 57.00 (3.4%) 57.00 Total FTE Program Funding Sources ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 10 - - - - - Charges For Services na 107,220 - 38,000 - 38,000 38,000 Miscellaneous Revenues na 375,303 100,000 350,000 - 350,000 250.0% 285,400 Reimb From Other Depts 13,215,140 13,644,200 14,030,900 - 14,030,900 2.8% 13,644,200 Net Cost General Fund - 85,200 85,200 - 85,200 0.0% 85,200 Trans fm 113 Comm Dev Fd - 113,200 130,000 - 130,000 14.8% 113,200 Trans fm 408 Water / Sewer Fd Total Funding 14,634,100 13,697,673 13,942,600 14,634,100 - 5.0% 14,166,000 Forecast FY 2017: The overall budget forecast is somewhat higher than the adopted budget reflecting the addition of revenue and expenditures from special services performed on a reimbursement basis. The forecast for Personal services is greater than budgeted reflecting the conversion of contracted staff, budgeted as an operating expense, to job bank positions which are budgeted as personal services. The FY 17 position count forecast is reduced by two FTEs reflecting the transfer of position 50002354 to Administrative Services Administration and position 50003744 to Procurement Services. The budget forecast has a neutral impact relative to the net cost to the General Fund. Current FY 2018: The FY 18 personnel count for Facilities Management is reduced by two reflecting the movement of personnel to Administrative Services Administration and the Procurement Division. The personal services budget has increased 11% relative to the FY 17 adopted budget. This increase reflects the addition of ten full time job bank positions and associated payroll taxes and fringe benefits. The budgeted cost is $584,600. The operating expense budget is increased by 5.2% or $219,300. There are a large number of changes both up and down in individual line items. These changes reflect current priorities and recent cost experience. For example, as discussed above, contractual labor has been reduced but IT and Fleet costs absorb the savings. Certain other contractual budgets are reduced while HVAC contract services, Pest Control and Grounds Maintenance are increased. In the case of Pest Control and Grounds Maintenance, the increases reflect new competitively procured contracts. In the case of HVAC contract services, the increase reflects current priorities and utilization trends. Capital outlay includes: $10,000 – Security cameras and card access upgrades and replacements $30,000 – Network Video Recorder Equipment upgrades and replacements (decoders and encoders) $3,000 – Computer Replacements $13,000 – Replacement Maintenance Equipment $10,000 – HVAC Equipment $10,000 – IP Camera Equipment $76,000 – Total Current Level of Service Capital Outlay In addition to the operating budget reflected on this page, the Facilities Management Division is responsible for managing a $5,250,000 capital appropriation in County-Wide Capital Improvement Fund (301) for roof replacements, HVAC replacements, general Fiscal Year 2018 47 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department Facilities Management Division Facilities Management (001) building and life safety upgrades, security improvements, painting, and ADA mitigation. This budget also includes the final payment of $325,000 for repaying the internal loan from Solid Waste Landfill Closure Fund (471) incurred to purchase the Property Appraiser's building. Relative to the prior adopted budget, the payment budget is reduced by $305,000. Revenues: The budget includes $350,000 in revenues from special services performed on a reimbursement basis. These services fall outside of core maintenance functions. Examples include: special maintenance requests, fingerprint & background checks and security services. The overall Facilities Management Division net cost to the general is in compliance with budget guidance at 2.4%. The ability to remain in compliance with budget guidance with a 4.8% increase in total budget is attributable to the net cost offsets provided by the reduced loan payment discussed above and the inclusion in the budget of $250,000 in special service reimbursement revenue. Fiscal Year 2018 48 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department Facilities Management Division Real Property Management (001) Mission Statement To provide professional property acquisition and management services which exceed customer expectations through courteous, expeditious and knowledgeable handling of real estate transactions. FY 2018 Budget FY 2018 Total FTE FY 2018 Revenues FY 2018 Net CostProgram Summary Section Administration/Overhead 100,398 - 100,398 0.50 This program provides for the general administration of the Section and fixed overhead. Property Acquisition 127,571 392,700 520,271 5.75 This program provides for the acquisition and appraisal of land and land rights for all County divisions. Some examples are right-of-way for all utility projects, sites for parks, libraries, water treatment facilities, wastewater treatment facilities, EMS facilities, sites under the Conservation Collier program, and sites for administrative offices. Property Management and Leasing 54,820 - 54,820 0.50 This program includes the leasing of both improved and unimproved property for County uses, as well as the leasing of County owned property to others for compatible uses and the issuance of licenses to not-for-profit organizations to hold special events on County owned property. Resolving ordinance violations on vacant County owned property also falls within this program. Lake Trafford Cemetery 3,400 21,700 25,100 - This program provides for daily administration of the cemetery, selling burial plots, assigning pre-need plots, arranging for the flagging of plots for all burials, process payment of utilities and other associated costs. GAC Land Trust Property 27,411 - 27,411 0.25 This program includes administering the GAC Land Trust Fund, negotiating and processing sales of trust property, and processing requests from divisions for use of trust funds for capital projects that will benefit the residents of Golden Gate Estates. Revenue is from processing fees for sales requests. Sales revenue and expenses are shown in GAC Land Trust Fund (605). 7.00 728,000 414,400 313,600Current Level of Service Budget FY 2017 FY 2018FY 2016 FY 2017 BudgetForecastBudgetActualProgram Performance Measures 74 74 74 74Average number of days to close real estate transactions 44 44 44 44Average number of days to complete lease requests 300 215 175 714Interest in land aquired 80 80 80 66Number of appraisals prepared & review 1,600 1,650 1,600 1,625Number of informational requests responded to 171,858 171,858 172,280 172,280Square feet of leased space managed Fiscal Year 2018 49 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department Facilities Management Division Real Property Management (001) ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 Program Budgetary Cost Summary 631,981 674,500 660,900 - 660,900 618,200 (2.0%)Personal Services 34,119 61,300 67,100 - 67,100 59,400 9.5%Operating Expense Net Operating Budget 666,101 735,800 728,000 - 728,000 677,600 (1.1%) 666,101 735,800 728,000 - 728,000 (1.1%) 677,600 Total Budget 7.00 7.00 7.00 - 7.00 0.0% 7.00 Total FTE Program Funding Sources ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 27,351 19,700 21,700 - 21,700 10.2% 26,800 Miscellaneous Revenues 397,387 374,600 392,700 - 392,700 4.8% 388,000 Reimb From Other Depts 241,363 341,500 313,600 - 313,600 (8.2%) 262,800 Net Cost General Fund Total Funding 728,000 666,101 735,800 728,000 - (1.1%) 677,600 Forecast FY 2017: Forecast personal services are modestly below budget due to staff turnover. Reimbursements from other departments are attributed to the continuation of project work performed by staff for Public Utilities Department, Public Services Department, Administrative Services Department, and other client departments. Current FY 2018: The increase to operating expenses is primarily due to a rise in the IT automation allocation and staff training. Revenues: FY18 Revenues (reimbursements from other departments) is increased based on confirmed projects. Reimbursements from other departments is attributed to the continuation of project work for the Public Utilities Department, Public Services Department, Administrative Services Department, and other client departments. Miscellaneous revenue is for the anticipated sale of 55 burial plots at Lake Trafford Cemetery. Fiscal Year 2018 50 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department Facilities Management Division GAC Land Trust Fund (605) Mission Statement To efficiently and effectively market Golden Gate Estates lots currently owned by Collier County, and identify needs for services within the Golden Gate Estates area and to set priorities for the funding of necessary improvements and/or support equipment to provide these services. FY 2018 Budget FY 2018 Total FTE FY 2018 Revenues FY 2018 Net CostProgram Summary Gulf American Corp (GAC) Land Sales - 887,600 887,600 - Expenses associated with selling Golden Gate Estates lots. This program is pursuant to an agreement dated November 15, 1983, between Avatar Properties, Inc. and Collier County. As of April 7, 2017 there remain 85.64 acres available for future sales. The expenses shown below do not include payroll and associated expenses allocated in General Fund (001). - 887,600 887,600 -Current Level of Service Budget ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 Program Budgetary Cost Summary 13 700 700 - 700 100 0.0%Operating Expense - - - - - 68,800 Remittances na Net Operating Budget 13 700 700 - 700 68,900 0.0% - 873,400 886,900 - 886,900 - 1.5%Reserves for Capital 13 874,100 887,600 - 887,600 1.5% 68,900 Total Budget Program Funding Sources ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 - 17,000 17,000 - 17,000 0.0% - Miscellaneous Revenues 9,912 3,500 3,500 - 3,500 0.0% 3,000 Interest/Misc 924,200 854,500 868,200 - 868,200 1.6% 934,100 Carry Forward - (900)(1,100) - (1,100) 22.2% - Less 5% Required By Law Total Funding 887,600 934,112 874,100 887,600 - 1.5% 937,100 Forecast FY 2017: Expenditure of $68,818.64 approved by the Board on February 28, 2017, Agenda Item 16E7 to complete the $150,000 allocation to Golden Gate Fire Control & Rescue District for equipment on fire fighting apparatus approved by the Board on May 27, 2014, Agenda Item 16E4 and BCC approved re-appropriating funds on January 13, 2015, Agenda Item 16E1 BCC approved extending contract time frame on June 9, 2015. There are no anticipated land sales in FY17. Current FY 2018: There are no planned funding requests for FY18 and any new requests will be brought before the Board of County Commissioners for approval. Revenues: Due to the continued fluctuating nature of the real estate market, land sales have proved very difficult to predict. However, the FY18 budget proposes revenues and expenditures associated with one (1) land sale sized conservatively at current sale trends. Fiscal Year 2018 51 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department Facilities Management Division Americans with Disabilities Act (190) Mission Statement Revenues generated by concession fees from the County’s Government Complex Snack Bar are used to improve handicapped and general accessibility to government facilities and to ensure County employees with special needs have the proper equipment to function in the workplace. FY 2018 Budget FY 2018 Total FTE FY 2018 Revenues FY 2018 Net CostProgram Summary Americans with Disabilities Act (ADA) - 67,700 67,700 - Upgrade County facilities to improve handicapped access to government facilities and purchase equipment for County employees with special needs. - 67,700 67,700 -Current Level of Service Budget ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 Program Budgetary Cost Summary 20,123 23,000 67,700 - 67,700 23,000 194.3%Operating Expense 7,295 - - - - - Capital Outlay na Net Operating Budget 27,418 23,000 67,700 - 67,700 23,000 194.3% 27,418 23,000 67,700 - 67,700 194.3% 23,000 Total Budget Program Funding Sources ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 13,989 17,100 19,200 - 19,200 12.3% 10,000 Charges For Services 732 - - - - 200 Interest/Misc na 75,000 6,800 49,500 - 49,500 627.9% 62,300 Carry Forward - (900)(1,000) - (1,000) 11.1% - Less 5% Required By Law Total Funding 67,700 89,721 23,000 67,700 - 194.3% 72,500 Forecast FY 2017: Updated or created ADA accessible entrances at the following locations: C-1 Tax Collector, Central Library, Clam Pass Park, East Naples Community Park, East Naples Library, Golden Gate Community Center, Immokalee Library, North Collier Regional Park, and Veteran’s Park. Current FY 2018: Updating or creating ADA accessible signage at the following locations: Building B, Building C1, Building E, Building G, Building H, Building M, Central Library, Eagle Lakes Community Park, East Naples Community Park, East Naples Library, Golden Gate Estates Library, Immokalee Library, North Collier Government Service Center, North Collier Regional Park, Veteran’s Park, and Vineyards Park. Fiscal Year 2018 52 Public Utilities Department Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Department Facilities Management Division Freedom Memorial (620) FY 2018 Budget FY 2018 Total FTE FY 2018 Revenues FY 2018 Net CostProgram Summary Memorial Design & Construction - 20,600 20,600 - - 20,600 20,600 -Current Level of Service Budget ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 Program Budgetary Cost Summary 75 - 10,000 - 10,000 10,000 Operating Expense na 1,442,369 79,200 10,600 - 10,600 19,500 (86.6%)Capital Outlay Net Operating Budget 1,442,444 79,200 20,600 - 20,600 29,500 (74.0%) 1,442,444 79,200 20,600 - 20,600 (74.0%) 29,500 Total Budget Program Funding Sources ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 31,486 - - - - 13,000 Miscellaneous Revenues na 12,507 2,000 - - - (100.0%) 1,000 Interest/Misc 1,434,500 77,200 20,600 - 20,600 (73.3%) 36,100 Carry Forward Total Funding 20,600 1,478,492 79,200 20,600 - (74.0%) 50,100 Notes: The Freedom Memorial is located at the Freedom Park, also known as the Gordon River Water Quality Park, located on the northeast side of Golden Gate Parkway and Goodlette Road. Forecast FY 2017: On February 10, 2015 via Agenda Item 10A, the Board of County Commissioners approved to match future private contributions in order to finish the Freedom Memorial. The current estimate to complete the project is $1.2M. A transfer totaling $600,000 was appropriated in FY15 from the County-wide Capital fund (301). Capital outlay is for the construction of the Memorial, including flag portions and the walkway. Current FY 2018: Capital outlay is budgeted for the anticipated wrap-up of the Memorial. Fiscal Year 2018 53 Public Utilities Department Public Utilities Capital Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Capital Public Utilities Capital Total Full-Time Equivalents (FTE) = 0.00 Organizational Chart County Water / Sewer Divisions Capital Total Full-Time Equivalents (FTE) = 0.00 Solid & Hazardous Waste Mgt Division Capital Total Full-Time Equivalents (FTE) = 0.00 Facilities Management Division Capital Total Full-Time Equivalents (FTE) = 0.00 Fiscal Year 2018 Capital - 1 Public Utilities Capital Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Capital ForecastAdopted Recom'd ChangeExpandedDivision Budgetary Cost Summary Current FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 Actual 63,981 65,800 700 - 700 - (98.9%)Personal Services 46,262,541 4,246,900 18,089,000 - 18,089,000 56,735,800 325.9%Operating Expense 7,289,469 60,502,600 73,265,300 - 73,265,300 98,938,700 21.1%Capital Outlay Total Net Budget 53,615,992 64,815,300 91,355,000 - 91,355,000 155,674,500 40.9 % 3,435,600 2,063,900 3,032,400 - 3,032,400 2,063,900 46.9%Advance/Repay to 390 Gov't Fac 500,000 500,000 510,000 - 510,000 500,000 2.0%Advance/Repay to 408 W-S Ops 1,000,000 2,000,000 6,000,000 - 6,000,000 2,000,000 200.0%Advance/Repay to 414 Sewer Cap 630,000 630,000 325,000 - 325,000 630,000 (48.4%)Advance/Repay to 471 S Waste 5,169,400 5,169,500 5,705,200 - 5,705,200 5,169,500 10.4%Trans to 298 Sp Ob Bd '10 10,097,312 13,770,800 13,267,600 - 13,267,600 9,565,000 (3.7%)Trans to 410 W/S Debt Serv Fd - 6,822,400 9,410,500 - 9,410,500 - 37.9%Reserves for Contingencies - 2,812,900 2,859,800 - 2,859,800 - 1.7%Reserves for Debt Service - 19,271,200 24,539,700 - 24,539,700 - 27.3%Reserves for Capital 74,448,304 117,856,000 157,005,200 - 157,005,200 33.2% 175,602,900 Total Budget ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 Appropriations by Department County Water / Sewer Divisions Capital 47,613,389 56,199,500 77,055,000 - 77,055,000 136,120,400 37.1% Solid & Hazardous Waste Mgt Division Capital 2,590,468 4,075,300 9,050,000 - 9,050,000 13,620,700 122.1% Facilities Management Division Capital 3,412,135 4,540,500 5,250,000 - 5,250,000 5,933,400 15.6% 53,615,992 64,815,300 91,355,000 - 91,355,000 40.9% 155,674,500 Total Net Budget County Water / Sewer Divisions Capital 11,097,312 40,636,800 51,302,000 - 51,302,000 11,565,000 26.2% Solid & Hazardous Waste Mgt Division Capital - 427,600 1,115,800 - 1,115,800 - 160.9% Facilities Management Division Capital 9,735,000 11,976,300 13,232,400 - 13,232,400 8,363,400 10.5% 20,832,312 53,040,700 65,650,200 - 65,650,200 23.8% 19,928,400 Total Transfers and Reserves 74,448,304 117,856,000 157,005,200 - 157,005,200 33.2% 175,602,900 Total Budget Fiscal Year 2018 Capital - 2 Public Utilities Capital Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Capital Division Funding Sources ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 - - - - - 750,000 Intergovernmental Revenues na 93,409 - - - - - Miscellaneous Revenues na 1,652,854 807,000 949,000 - 949,000 17.6% 1,294,000 Interest/Misc 16,579,906 15,700,000 17,399,000 - 17,399,000 10.8% 17,574,000 Impact Fees 20,545 - - - - - Deferred Impact Fees na 630,000 630,000 325,000 - 325,000 (48.4%) 630,000 Advance/Repay fm 001 Gen Fd 3,435,600 2,063,900 3,032,400 - 3,032,400 46.9% 2,063,900 Advance/Repay fm 301 Cap Proj 1,000,000 2,000,000 6,000,000 - 6,000,000 200.0% 2,000,000 Advance/Repay fm 413 Sewer Im Fee 5,455,200 6,741,900 7,891,400 - 7,891,400 17.1% 6,741,900 Trans fm 001 Gen Fund 87,664 - - - - - Trans fm 113 Comm Dev Fd na 50,919,753 49,626,900 53,886,400 - 53,886,400 8.6% 50,331,800 Trans fm 408 Water / Sewer Fd 906,983 1,915,900 7,344,100 - 7,344,100 283.3% 1,915,900 Trans fm 470 Solid Waste Fd 1,050,000 2,200,500 2,200,000 - 2,200,000 0.0% 2,200,500 Trans fm 473 Mand Collct Fd - 450,000 - - - (100.0%) 450,000 Trans fm 517 Health Ins 141,370,700 36,545,200 58,895,400 - 58,895,400 61.2% 148,546,300 Carry Forward - (825,300)(917,500) - (917,500) 11.2% - Less 5% Required By Law Total Funding 157,005,200 223,202,615 117,856,000 157,005,200 - 33.2% 234,498,300 Division Position Summary Forecast FY 2017 Adopted Recom'd ChangeExpandedActualCurrent FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 0.0%na 0.0%Total FTE na CIP Summary by Project Category Adopted ForecastedAmended BudgetBudgetBudgetBudgetBudget FY 2017 FY 2017FY 2017 FY 2022FY 2021FY 2020FY 2019FY 2018 - - - - 18,482,400 14,249,400 17,512,259 16,516,800Facilities Management - - - - 10,165,800 13,486,900 13,927,773 4,427,600Solid Waste Capital - - - - - 47,400 47,468 -Supervisor of Elections - - - - 128,357,000 147,819,200 195,407,958 96,911,600Water / Sewer District Capital Total Project Budget 117,856,000 - - - - 157,005,200 175,602,900 226,895,458 Fiscal Year 2018 Capital - 3 Public Utilities Capital Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Capital County Water / Sewer Divisions Capital ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 Department Budgetary Cost Summary 60,254 65,800 700 - 700 - (98.9%)Personal Services 42,106,243 640,100 12,605,000 - 12,605,000 51,303,600 1,869.2%Operating Expense 5,446,892 55,493,600 64,449,300 - 64,449,300 84,816,800 16.1%Capital Outlay 47,613,389 56,199,500 77,055,000 - 77,055,000 136,120,400 Net Operating Budget 37.1% 1,000,000 2,000,000 6,000,000 - 6,000,000 2,000,000 200.0%Advance/Repay to 414 Sewer Cap 10,097,312 13,770,800 13,267,600 - 13,267,600 9,565,000 (3.7%)Trans to 410 W/S Debt Serv Fd - 5,614,900 7,705,500 - 7,705,500 - 37.2%Reserves for Contingencies - 19,251,100 24,328,900 - 24,328,900 - 26.4%Reserves for Capital 58,710,701 96,836,300 128,357,000 - 128,357,000 32.6% 147,685,400 Total Budget ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 Appropriations by Program 23,169,662 38,271,300 55,780,000 - 55,780,000 83,566,800 45.7%County Sewer Capital Projects (414) 21,871 - - - - 967,800 County Sewer System Development Capital Fund (413) na 24,383,647 17,878,200 21,275,000 - 21,275,000 50,513,900 19.0%County Water Capital Projects (412) - - - - - 750,000 County Water Sewer Grants (416/417)na 38,208 50,000 - - - 321,900 (100.0%)County Water System Development Capital Fund (411) Total Net Budget 58,710,701 96,836,300 128,357,000 - 128,357,000 32.6% 147,685,400 Total Budget Total Transfers and Reserves 47,613,389 56,199,500 136,120,400 77,055,000 - 77,055,000 11,097,312 40,636,800 11,565,000 51,302,000 - 51,302,000 37.1% 26.2% Department Funding Sources ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 - - - - - 750,000 Intergovernmental Revenues na 39,914 - - - - - Miscellaneous Revenues na 1,383,858 697,000 778,000 - 778,000 11.6% 1,115,000 Interest/Misc 13,628,832 13,300,000 14,599,000 - 14,599,000 9.8% 14,924,000 Impact Fees 16,415 - - - - - Deferred Impact Fees na 1,000,000 2,000,000 6,000,000 - 6,000,000 200.0% 2,000,000 Advance/Repay fm 413 Sewer Im Fee 50,871,600 49,626,900 53,886,400 - 53,886,400 8.6% 50,331,800 Trans fm 408 Water / Sewer Fd 124,180,500 31,912,300 53,862,500 - 53,862,500 68.8% 132,427,100 Carry Forward - (699,900)(768,900) - (768,900) 9.9% - Less 5% Required By Law Total Funding 128,357,000 191,121,119 96,836,300 128,357,000 - 32.6% 201,547,900 Fiscal Year 2018 Capital - 4 Public Utilities Capital Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Capital County Water / Sewer Divisions Capital CIP Category / Project Title Adopted ForecastedAmended BudgetBudgetBudgetBudgetBudget FY 2017 FY 2017FY 2017 FY 2022FY 2021FY 2020FY 2019FY 2018 Water / Sewer District Capital 10 Year Water Supply Plan - - - - - 14,400 14,443 - 8th Street Interceptor Sewer - - - - 2,000,000 - - - Airport Rd Water Main Replacement - - - - - - - 1,250,000 Barron Collier HS Water Main Repl - - - - - 1,000,000 1,000,000 600,000 Biosolids Reuse Facility - - - - - 3,172,000 3,171,993 2,000,000 Collections Power Systems TSP - - - - - 683,800 683,798 - Collections Power Systems TSP-Ops - - - - - 250,000 250,000 500,000 Collier County Utility Standards - - - - 45,000 134,900 134,999 20,000 County-wide Utility Projects-Water - - - - 150,000 1,726,600 1,726,661 - County-wide Utility Projects-WW - - - - 200,000 756,400 756,331 100,000 Creekside Phase 2 Force Main - - - - 2,000,000 - - - Cross Connections Program - - - - 300,000 1,028,400 1,028,416 500,000 Cyber Security SCADA - - - - 200,000 - - - Distribution Repump Station TSP - - - - 300,000 924,100 924,078 100,000 Facility Infrastructure Maintenance - - - - 350,000 307,000 307,007 - Facility Infrastructure Maintenance - WW - - - - 350,000 358,800 358,825 - FDOT Utility Projects-Water - - - - 150,000 414,700 414,648 - FDOT Utility Projects-WW - - - - - 318,800 318,774 200,000 Financial Services - - - - 60,000 294,500 294,558 60,000 Fire Hydrant Replacement - - - - 300,000 502,600 502,598 - FM Immokalee Rd and Logan Blvd - - - - 300,000 - - - FM Transmission Systems TSP - - - - - 6,522,300 6,522,227 - FM Transmission Systems TSP-Ops - - - - - 500,000 500,000 1,000,000 FM Twin Eagles - - - - 750,000 - - - General Legal Services - - - - 100,000 428,200 428,105 - Glades AC Pipe Rehab - - - - 1,250,000 - - - GM Comprehensive Plan - - - - - 100,500 100,467 - Goodland Dr Water Main Replacement - - - - - 1,100,000 1,100,000 - Goodlette Road IQ Water Main - - - - - 2,484,500 2,484,523 - Grant Applications - - - - - 2,300 2,336 - Gravity Transmission System TSP-Ops - - - - - 100,000 100,000 100,000 Gravity Transmission Systems TSP - - - - - 1,633,100 1,633,112 - Gulfshore Dr AC WM (cap) - - - - 500,000 50,000 50,000 - Hydraulic Modeling - - - - 150,000 443,900 443,900 150,000 Imperial GC Blvd Water Main Repl - - - - - 1,400,000 1,400,000 1,400,000 Infrastructure TSP Field Ops - Water - - - - 100,000 616,300 616,333 225,000 Infrastructure TSP Water Plants - - - - 500,000 772,800 772,722 225,000 Integrated Asset Management - - - - 1,000,000 3,945,200 3,945,155 1,334,400 Inventory Warehouse - S. Serv. Area - - - - - 84,600 84,595 - IQ Aquifer Storage and Recovery - - - - 350,000 - - - IQ Aquifer Storage and Recovery-Ops - - - - - 849,300 849,276 700,000 IQ Power Systems TSP - - - - - 62,200 62,238 - IQ Systems SCADA TSP Ops - - - - 200,000 364,200 364,194 - IQ Systems SCADA TSP-Cap - - - - - 368,600 368,600 368,600 IQ Water System TSP - - - - - 587,300 587,344 300,000 IQ Water System TSP-Ops - - - - 600,000 700,000 700,000 700,000 Large Meters Renewal & Replacement - - - - 200,000 1,000,000 1,000,000 1,000,000 Lift Station Mechanical Improvements - - - - - 39,700 39,727 - Lightning, Surge, & Grounding - - - - - 229,100 229,060 - Lime Treatment TSP - - - - 100,000 619,700 619,694 100,000 Master Pump Station TSP - - - - - 9,714,200 9,714,233 - Fiscal Year 2018 Capital - 5 Public Utilities Capital Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Capital County Water / Sewer Divisions Capital CIP Category / Project Title Adopted ForecastedAmended BudgetBudgetBudgetBudgetBudget FY 2017 FY 2017FY 2017 FY 2022FY 2021FY 2020FY 2019FY 2018 Water / Sewer District Capital Master Pump Station TSP-Ops - - - - 500,000 1,000,000 1,000,000 1,000,000 Membrane Treatment TSP - - - - - 1,260,300 1,260,361 - Meter Renewal and Replacement - - - - 2,300,000 3,245,100 3,245,242 2,770,000 MPS 101 Basin Prog (Naples Pk area) - - - - - 3,100,000 3,100,000 10,000,000 MPS 101.12 Naples Pk - - - - 4,500,000 - - - MPS 107 Reconfig, Quail Creek - - - - 300,000 - - - MPS 300 Rehab, SCWRF - - - - 250,000 - - - MPS 300.06 St. Andrews Blvd - - - - 1,000,000 - - - MPS 301 Rehab, SCWRF - - - - 2,000,000 - - - MPS 302, Reconfig (Santa Barbara Blvd) - - - - 500,000 - - - MPS 305 Basin Program - - - - - 2,000,000 2,000,000 2,500,000 MPS 305, Group 1; Glades - - - - 2,500,000 - - - MPS 306 Group 3 (Bayshore/Thomasson) - - - - 3,000,000 - - - MPS 306 MPS Lely - - - - 4,000,000 6,183,500 6,183,500 6,000,000 MPS 308 Replace (Shadowlawn-Linwood) - - - - 100,000 - - - MPS 309 (E Naples Middle School) - - - - 100,000 - - - MPS 321 Force Main to SCWRF - - - - 100,000 - - - MPS 321, Rehab, Lely - - - - 200,000 - - - Naples Park Basin Opt - - - - - 8,900,000 8,900,000 - Naples Park Gravity Sewer Replacement - - - - 4,000,000 - - - Naples Park Water Main Replacement - - - - 4,000,000 420,000 420,000 2,400,000 NCRWTP Infrastructure - - - - - 23,400 23,435 - NCRWTP SCADA Support Ops - - - - 150,000 108,700 108,766 - NCRWTP SCADA TSP - - - - - 343,600 343,600 343,600 NCRWTP TSP Operating - - - - 600,000 1,740,100 1,739,987 400,000 NCWRF Bridge the Gap and 30.6 MGD - - - - - 891,100 891,073 - NCWRF Headwork & IQ Pump Station - - - - 1,000,000 - - 500,000 NCWRF Infrastructure - - - - - 53,100 53,144 - NCWRF Power Systems TSP-Cap - - - - - 538,100 538,061 360,000 NCWRF SCADA Support Op - - - - 300,000 92,100 92,124 - NCWRF SCADA TSP-Cap - - - - - 301,800 301,800 301,800 NCWRF Sludge Holding Tank Replace - - - - - 5,000 5,041 - NCWRF Technical Support Program-Cap - - - - - 2,924,400 2,924,396 1,500,000 NE Regional WRF - - - - - 23,700 23,710 - NE Service Area Integr & Reliab - - - - - 921,900 921,979 - NERWTP Design and Construction - - - - - 23,700 23,662 - Northeast Project Mgmt/Oversight - - - - - 40,500 40,519 - Old Lely AC Pipe Rehab - - - - 2,000,000 - - - Operating Project 411 - - - - - 298,200 298,233 50,000 Operating Project 413 - - - - - 356,200 356,205 - Orangetree Compliance - - - - 2,000,000 704,900 704,900 - PS 302.07 Gravity Sewers, Lely - - - - 250,000 - - - PS Twin Eagle Community - - - - 500,000 - - - PUD Operations Center Infrastructure - - - - - 28,300 28,241 - PUD Operations Center TSP - - - - - 15,400 15,407 - PUD Operations/Collection Facilities - - - - 4,000,000 200,000 200,000 200,000 Quarry/Hrt Bay Water Main Replacement - - - - - 950,000 950,000 1,000,000 Real Property/Infrastructure Audit - - - - 50,000 133,900 133,857 - SCADA Compliance - Water - - - - 70,000 397,800 397,778 267,000 SCADA Compliance - WW - - - - 75,000 322,000 321,926 267,000 SCRWTP Capital TSP - - - - - 200,000 200,000 200,000 SCRWTP Deep Injection Well - - - - - 141,400 141,439 - Fiscal Year 2018 Capital - 6 Public Utilities Capital Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Capital County Water / Sewer Divisions Capital CIP Category / Project Title Adopted ForecastedAmended BudgetBudgetBudgetBudgetBudget FY 2017 FY 2017FY 2017 FY 2022FY 2021FY 2020FY 2019FY 2018 Water / Sewer District Capital SCRWTP Infrastructure - - - - - 34,600 34,572 - SCRWTP Power Systems Reliability - - - - - 250,000 250,000 250,000 SCRWTP Reactor #4 - - - - - 200,000 200,000 200,000 SCRWTP SCADA Support - Ops - - - - 150,000 282,900 282,939 - SCRWTP SCADA TSP - - - - - 230,400 230,400 230,400 SCRWTP TSP Operating - - - - 450,000 1,150,800 1,150,885 300,000 SCWRF Compliance Assurance Project - - - - - 42,300 42,315 - SCWRF Infrastructure - - - - - 19,200 19,177 - SCWRF IQ Storage Improvements - - - - 1,000,000 - - - SCWRF Power Systems TSP-Cap - - - - - 383,400 383,353 250,000 SCWRF SCADA Support Op - - - - 200,000 166,900 166,938 - SCWRF SCADA TSP-Cap - - - - - 301,800 301,800 301,800 SCWRF Technical Support Program-Cap - - - - - 2,507,600 2,507,638 1,660,400 SCWRF Turbo Blowers - - - - 1,800,000 - - - Security Upgrades - - - - 300,000 857,200 857,173 300,000 South RO Wellfield Restoration - - - - - 691,400 691,456 - State Revolving Fund - - - - - 6,500 6,414 - System Improvements-Bill/Cust Svc. - - - - - 36,700 36,728 - Tamiami Wellfield - 2 Wells - - - - 1,500,000 - - - Trail Blvd WM Replacement - - - - 300,000 - - - Utilities Master Plan - - - - 5,000 80,100 80,058 - Utility Billing Customer Serv Software - - - - 3,000,000 500,000 500,000 1,000,000 Utility Billing Customer Serv-Sys Imp - - - - - 50,000 50,022 - Vanderbilt Bch Rd WM Rpl-Airpot to 41 - - - - - 650,000 650,000 650,000 Vanderbilt Dr Cul-de-sacs, Basin 101 - - - - - 16,171,300 16,171,345 - Vanderbilt Dr Water Main - - - - - 607,100 607,053 400,000 Warren St Looping - - - - 100,000 - - - Wastewater Pump Station TSP - - - - - 3,329,400 3,329,352 - Wastewater Pump Stations TSP-Ops - - - - 1,200,000 100,000 100,000 100,000 Wastewater Remote Sites TSP - - - - 250,000 417,500 417,522 300,000 Wastewater Security Systems - - - - 500,000 688,300 688,278 350,000 Water Distribution System TSP - - - - 1,000,000 5,564,300 5,564,258 - Water Plant Compliance Assurance Proj - - - - - 2,129,000 2,128,930 - Water Plant Structural Rehab - - - - 250,000 309,800 309,871 125,000 Water Plant-Variable Frequency Drives - - - - 150,000 688,100 688,065 300,000 Water Reclamation Facilities TSP-Ops - - - - 6,000,000 4,550,000 4,550,000 4,550,000 Well/Plant Power System - - - - - 888,900 888,896 - Well/Water Booster Station TSP - - - - - 650,000 650,000 650,000 Wellfield Management Program - - - - 100,000 378,700 378,583 - Wellfield SCADA Support - Operating - - - - 100,000 537,900 537,953 225,000 Wellfield/Raw W Booster TSP - Ops - - - - 300,000 1,907,400 1,907,351 100,000 Western Interconnect - - - - 4,800,000 2,346,700 2,346,700 - Western Interconnect MPS - - - - 100,000 - - - Willoughby Pump Station 133.09 - - - - - 547,400 547,400 - WW Collections SCADA Telemetry - - - - - 364,500 364,500 364,500 WW Collections SCADA/Telemetry - - - - 100,000 55,800 55,829 - WW Treatment Plants TSP - - - - 550,000 953,300 953,303 600,000 X-Transfers/Reserves/Interest - Fd 411 - - - - 20,275,200 4,022,700 14,954,900 14,954,900 X-Transfers/Reserves/Interest - Fd 412 - - - - 3,497,300 - 3,820,800 2,920,800 X-Transfers/Reserves/Interest - Fd 413 - - - - 18,360,200 7,542,300 15,884,200 16,431,600 X-Transfers/Reserves/Interest - Fd 414 - - - - 9,169,300 - 24,493,830 6,329,500 Fiscal Year 2018 Capital - 7 Public Utilities Capital Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Capital County Water / Sewer Divisions Capital CIP Category / Project Title Adopted ForecastedAmended BudgetBudgetBudgetBudgetBudget FY 2017 FY 2017FY 2017 FY 2022FY 2021FY 2020FY 2019FY 2018 - - - - 128,357,000 147,685,400 195,274,143 96,836,300Water / Sewer District Capital 96,836,300 - - - - 128,357,000 147,685,400 195,274,143Department Total Project Budget Fiscal Year 2018 Capital - 8 Public Utilities Capital Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Capital County Water / Sewer Divisions Capital County Water System Development Capital Fund (411) ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 Program Budgetary Cost Summary 38,208 50,000 - - - 321,900 (100.0%)Operating Expense Net Operating Budget 38,208 50,000 - - - 321,900 (100.0%) 5,568,492 8,123,600 7,831,300 - 7,831,300 4,022,700 (3.6%)Trans to 410 W/S Debt Serv Fd - 6,831,300 12,443,900 - 12,443,900 - 82.2%Reserves for Capital 5,606,700 15,004,900 20,275,200 - 20,275,200 35.1% 4,344,600 Total Budget Program Funding Sources ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 99,732 42,000 98,000 - 98,000 133.3% 98,000 Interest/Misc 6,709,827 6,800,000 7,300,000 - 7,300,000 7.4% 7,415,000 Impact Fees 7,810 - - - - - Deferred Impact Fees na 8,868,000 8,505,000 13,247,100 - 13,247,100 55.8% 10,078,700 Carry Forward - (342,100)(369,900) - (369,900) 8.1% - Less 5% Required By Law Total Funding 20,275,200 15,685,370 15,004,900 20,275,200 - 35.1% 17,591,700 CIP Category / Project Title Adopted ForecastedAmended BudgetBudgetBudgetBudgetBudget FY 2017 FY 2017FY 2017 FY 2022FY 2021FY 2020FY 2019FY 2018 Water / Sewer District Capital - 23,662 23,700 - - - - -NERWTP Design and Construction 50,000 298,233 298,200 - - - - -Operating Project 411 14,954,900 14,954,900 4,022,700 20,275,200 - - - -X-Transfers/Reserves/Interest - Fd 411 - - - - 20,275,200 4,344,600 15,276,795 15,004,900Water / Sewer District Capital 15,004,900 - - - - 20,275,200 4,344,600 15,276,795Program Total Project Budget Fiscal Year 2018 Capital - 9 Public Utilities Capital Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Capital County Water / Sewer Divisions Capital County Water Capital Projects (412) ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 Program Budgetary Cost Summary 57,517 65,800 700 - 700 - (98.9%)Personal Services 22,107,984 208,700 4,225,000 - 4,225,000 18,599,700 1,924.4%Operating Expense 2,218,146 17,603,700 17,049,300 - 17,049,300 31,914,200 (3.1%)Capital Outlay Net Operating Budget 24,383,647 17,878,200 21,275,000 - 21,275,000 50,513,900 19.0% - 1,787,800 2,127,500 - 2,127,500 - 19.0%Reserves for Contingencies - 1,133,000 1,369,800 - 1,369,800 - 20.9%Reserves for Capital 24,383,647 20,799,000 24,772,300 - 24,772,300 19.1% 50,513,900 Total Budget Program Funding Sources ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 18,119 - - - - - Miscellaneous Revenues na 473,258 250,000 320,000 - 320,000 28.0% 300,000 Interest/Misc 16,988,600 17,194,400 20,343,500 - 20,343,500 18.3% 17,436,200 Trans fm 408 Water / Sewer Fd 43,806,300 3,367,100 4,124,800 - 4,124,800 22.5% 36,902,500 Carry Forward - (12,500)(16,000) - (16,000) 28.0% - Less 5% Required By Law Total Funding 24,772,300 61,286,277 20,799,000 24,772,300 - 19.1% 54,638,700 Fiscal Year 2018 Capital - 10 Public Utilities Capital Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Capital County Water / Sewer Divisions Capital County Water Capital Projects (412) CIP Category / Project Title Adopted ForecastedAmended BudgetBudgetBudgetBudgetBudget FY 2017 FY 2017FY 2017 FY 2022FY 2021FY 2020FY 2019FY 2018 Water / Sewer District Capital - 14,443 14,400 - - - - -10 Year Water Supply Plan 1,250,000 - 0 - - - - -Airport Rd Water Main Replacement 600,000 1,000,000 1,000,000 - - - - -Barron Collier HS Water Main Repl 20,000 69,959 69,900 20,000 - - - -Collier County Utility Standards - 1,726,661 1,726,600 150,000 - - - -County-wide Utility Projects-Water 500,000 1,028,416 1,028,400 300,000 - - - -Cross Connections Program - - 0 100,000 - - - -Cyber Security SCADA 100,000 924,078 924,100 300,000 - - - -Distribution Repump Station TSP - 307,007 307,000 350,000 - - - -Facility Infrastructure Maintenance - 414,648 414,700 150,000 - - - -FDOT Utility Projects-Water 30,000 137,913 137,900 30,000 - - - -Financial Services - 502,598 502,600 300,000 - - - -Fire Hydrant Replacement - 338,233 338,300 - - - - -General Legal Services - - 0 1,250,000 - - - -Glades AC Pipe Rehab - 48,701 48,700 - - - - -GM Comprehensive Plan - 1,100,000 1,100,000 - - - - -Goodland Dr Water Main Replacement - 50,000 50,000 500,000 - - - -Gulfshore Dr AC WM (cap) 50,000 223,876 223,900 50,000 - - - -Hydraulic Modeling 1,400,000 1,400,000 1,400,000 - - - - -Imperial GC Blvd Water Main Repl 225,000 616,333 616,300 100,000 - - - -Infrastructure TSP Field Ops - Water 225,000 772,722 772,800 500,000 - - - -Infrastructure TSP Water Plants 767,200 2,594,497 2,594,500 500,000 - - - -Integrated Asset Management 1,000,000 1,000,000 1,000,000 200,000 - - - -Large Meters Renewal & Replacement - 229,060 229,100 - - - - -Lightning, Surge, & Grounding 100,000 619,694 619,700 100,000 - - - -Lime Treatment TSP - 1,260,361 1,260,300 - - - - -Membrane Treatment TSP 2,770,000 3,245,242 3,245,100 2,300,000 - - - -Meter Renewal and Replacement - 3,050,000 3,050,000 - - - - -Naples Park Basin Opt 2,400,000 420,000 420,000 4,000,000 - - - -Naples Park Water Main Replacement - 23,435 23,400 - - - - -NCRWTP Infrastructure - 108,766 108,700 150,000 - - - -NCRWTP SCADA Support Ops 343,600 343,600 343,600 - - - - -NCRWTP SCADA TSP 400,000 1,739,987 1,740,100 600,000 - - - -NCRWTP TSP Operating - 320,350 320,300 - - - - -NE Service Area Integr & Reliab - - 0 2,000,000 - - - -Old Lely AC Pipe Rehab - 241,800 241,800 1,000,000 - - - -Orangetree Compliance - 28,241 28,300 - - - - -PUD Operations Center Infrastructure - 15,407 15,400 - - - - -PUD Operations Center TSP 1,000,000 950,000 950,000 - - - - -Quarry/Hrt Bay Water Main Replacement - 88,798 88,800 50,000 - - - -Real Property/Infrastructure Audit 267,000 397,778 397,800 70,000 - - - -SCADA Compliance - Water 200,000 200,000 200,000 - - - - -SCRWTP Capital TSP - 141,439 141,400 - - - - -SCRWTP Deep Injection Well - 34,572 34,600 - - - - -SCRWTP Infrastructure 250,000 250,000 250,000 - - - - -SCRWTP Power Systems Reliability 200,000 200,000 200,000 - - - - -SCRWTP Reactor #4 - 282,939 282,900 150,000 - - - -SCRWTP SCADA Support - Ops 230,400 230,400 230,400 - - - - -SCRWTP SCADA TSP 300,000 1,150,885 1,150,800 450,000 - - - -SCRWTP TSP Operating 300,000 857,173 857,200 300,000 - - - -Security Upgrades - 691,456 691,400 - - - - -South RO Wellfield Restoration - 3,864 3,900 - - - - -State Revolving Fund - - 0 1,500,000 - - - -Tamiami Wellfield - 2 Wells - - 0 300,000 - - - -Trail Blvd WM Replacement - 29,961 30,000 5,000 - - - -Utilities Master Plan Fiscal Year 2018 Capital - 11 Public Utilities Capital Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Capital County Water / Sewer Divisions Capital County Water Capital Projects (412) CIP Category / Project Title Adopted ForecastedAmended BudgetBudgetBudgetBudgetBudget FY 2017 FY 2017FY 2017 FY 2022FY 2021FY 2020FY 2019FY 2018 Water / Sewer District Capital 500,000 500,000 500,000 1,500,000 - - - -Utility Billing Customer Serv Software - 50,022 50,000 - - - - -Utility Billing Customer Serv-Sys Imp 650,000 650,000 650,000 - - - - -Vanderbilt Bch Rd WM Rpl-Airpot to 41 - 4,227,645 4,227,600 - - - - -Vanderbilt Dr Cul-de-sacs, Basin 101 400,000 607,053 607,100 - - - - -Vanderbilt Dr Water Main - - 0 100,000 - - - -Warren St Looping - 5,564,258 5,564,300 1,000,000 - - - -Water Distribution System TSP - 2,128,930 2,129,000 - - - - -Water Plant Compliance Assurance Proj 125,000 309,871 309,800 250,000 - - - -Water Plant Structural Rehab 300,000 688,065 688,100 150,000 - - - -Water Plant-Variable Frequency Drives - 888,896 888,900 - - - - -Well/Plant Power System 650,000 650,000 650,000 - - - - -Well/Water Booster Station TSP - 378,583 378,700 100,000 - - - -Wellfield Management Program 225,000 537,953 537,900 100,000 - - - -Wellfield SCADA Support - Operating 100,000 1,907,351 1,907,400 300,000 - - - -Wellfield/Raw W Booster TSP - Ops 2,920,800 3,820,800 0 3,497,300 - - - -X-Transfers/Reserves/Interest - Fd 412 - - - - 24,772,300 50,513,900 54,334,720 20,799,000Water / Sewer District Capital 20,799,000 - - - - 24,772,300 50,513,900 54,334,720Program Total Project Budget Fiscal Year 2018 Capital - 12 Public Utilities Capital Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Capital County Water / Sewer Divisions Capital County Sewer System Development Capital Fund (413) ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 Program Budgetary Cost Summary 21,871 - - - - 400,400 Operating Expense na - - - - - 567,400 Capital Outlay na Net Operating Budget 21,871 - - - - 967,800 na 1,000,000 2,000,000 6,000,000 - 6,000,000 2,000,000 200.0%Advance/Repay to 414 Sewer Cap 4,528,820 5,647,200 5,436,300 - 5,436,300 5,542,300 (3.7%)Trans to 410 W/S Debt Serv Fd - 8,784,400 6,923,900 - 6,923,900 - (21.2%)Reserves for Capital 5,550,692 16,431,600 18,360,200 - 18,360,200 11.7% 8,510,100 Total Budget Program Funding Sources ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 120,960 55,000 60,000 - 60,000 9.1% 117,000 Interest/Misc 6,919,005 6,500,000 7,299,000 - 7,299,000 12.3% 7,509,000 Impact Fees 8,605 - - - - - Deferred Impact Fees na 10,737,500 10,204,400 11,369,200 - 11,369,200 11.4% 12,253,300 Carry Forward - (327,800)(368,000) - (368,000) 12.3% - Less 5% Required By Law Total Funding 18,360,200 17,786,069 16,431,600 18,360,200 - 11.7% 19,879,300 CIP Category / Project Title Adopted ForecastedAmended BudgetBudgetBudgetBudgetBudget FY 2017 FY 2017FY 2017 FY 2022FY 2021FY 2020FY 2019FY 2018 Water / Sewer District Capital - 23,710 23,700 - - - - -NE Regional WRF - 40,519 40,500 - - - - -Northeast Project Mgmt/Oversight - 356,205 356,200 - - - - -Operating Project 413 - 547,400 547,400 - - - - -Willoughby Pump Station 133.09 16,431,600 15,884,200 7,542,300 18,360,200 - - - -X-Transfers/Reserves/Interest - Fd 413 - - - - 18,360,200 8,510,100 16,852,034 16,431,600Water / Sewer District Capital 16,431,600 - - - - 18,360,200 8,510,100 16,852,034Program Total Project Budget Fiscal Year 2018 Capital - 13 Public Utilities Capital Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Capital County Water / Sewer Divisions Capital County Sewer Capital Projects (414) ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 Program Budgetary Cost Summary 2,737 - - - - - Personal Services na 19,938,180 381,400 8,380,000 - 8,380,000 31,981,600 2,097.2%Operating Expense 3,228,746 37,889,900 47,400,000 - 47,400,000 51,585,200 25.1%Capital Outlay Net Operating Budget 23,169,662 38,271,300 55,780,000 - 55,780,000 83,566,800 45.7% - 3,827,100 5,578,000 - 5,578,000 - 45.8%Reserves for Contingencies - 2,502,400 3,591,300 - 3,591,300 - 43.5%Reserves for Capital 23,169,662 44,600,800 64,949,300 - 64,949,300 45.6% 83,566,800 Total Budget Program Funding Sources ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 21,795 - - - - - Miscellaneous Revenues na 689,907 350,000 300,000 - 300,000 (14.3%) 600,000 Interest/Misc 1,000,000 2,000,000 6,000,000 - 6,000,000 200.0% 2,000,000 Advance/Repay fm 413 Sewer Im Fee 33,883,000 32,432,500 33,542,900 - 33,542,900 3.4% 32,895,600 Trans fm 408 Water / Sewer Fd 60,768,700 9,835,800 25,121,400 - 25,121,400 155.4% 73,192,600 Carry Forward - (17,500)(15,000) - (15,000)(14.3%) - Less 5% Required By Law Total Funding 64,949,300 96,363,402 44,600,800 64,949,300 - 45.6% 108,688,200 Fiscal Year 2018 Capital - 14 Public Utilities Capital Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Capital County Water / Sewer Divisions Capital County Sewer Capital Projects (414) CIP Category / Project Title Adopted ForecastedAmended BudgetBudgetBudgetBudgetBudget FY 2017 FY 2017FY 2017 FY 2022FY 2021FY 2020FY 2019FY 2018 Water / Sewer District Capital - - 0 2,000,000 - - - -8th Street Interceptor Sewer 2,000,000 3,171,993 3,172,000 - - - - -Biosolids Reuse Facility - 683,798 683,800 - - - - -Collections Power Systems TSP 500,000 250,000 250,000 - - - - -Collections Power Systems TSP-Ops - 65,040 65,000 25,000 - - - -Collier County Utility Standards 100,000 756,331 756,400 200,000 - - - -County-wide Utility Projects-WW - - 0 2,000,000 - - - -Creekside Phase 2 Force Main - - 0 100,000 - - - -Cyber Security SCADA - 358,825 358,800 350,000 - - - -Facility Infrastructure Maintenance - WW 200,000 318,774 318,800 - - - - -FDOT Utility Projects-WW 30,000 156,645 156,600 30,000 - - - -Financial Services - - 0 300,000 - - - -FM Immokalee Rd and Logan Blvd - 6,522,227 6,522,300 - - - - -FM Transmission Systems TSP 1,000,000 500,000 500,000 - - - - -FM Transmission Systems TSP-Ops - - 0 750,000 - - - -FM Twin Eagles - 89,872 89,900 100,000 - - - -General Legal Services - 51,766 51,800 - - - - -GM Comprehensive Plan - 2,484,523 2,484,500 - - - - -Goodlette Road IQ Water Main - 2,336 2,300 - - - - -Grant Applications 100,000 100,000 100,000 - - - - -Gravity Transmission System TSP-Ops - 1,633,112 1,633,100 - - - - -Gravity Transmission Systems TSP 100,000 220,024 220,000 100,000 - - - -Hydraulic Modeling 567,200 1,350,658 1,350,700 500,000 - - - -Integrated Asset Management - 84,595 84,600 - - - - -Inventory Warehouse - S. Serv. Area - - 0 350,000 - - - -IQ Aquifer Storage and Recovery 700,000 849,276 849,300 - - - - -IQ Aquifer Storage and Recovery-Ops - 62,238 62,200 - - - - -IQ Power Systems TSP - 364,194 364,200 200,000 - - - -IQ Systems SCADA TSP Ops 368,600 368,600 368,600 - - - - -IQ Systems SCADA TSP-Cap 300,000 587,344 587,300 - - - - -IQ Water System TSP 700,000 700,000 700,000 600,000 - - - -IQ Water System TSP-Ops - 39,727 39,700 - - - - -Lift Station Mechanical Improvements - 9,714,233 9,714,200 - - - - -Master Pump Station TSP 1,000,000 1,000,000 1,000,000 500,000 - - - -Master Pump Station TSP-Ops 10,000,000 3,100,000 3,100,000 - - - - -MPS 101 Basin Prog (Naples Pk area) - - 0 4,500,000 - - - -MPS 101.12 Naples Pk - - 0 300,000 - - - -MPS 107 Reconfig, Quail Creek - - 0 250,000 - - - -MPS 300 Rehab, SCWRF - - 0 1,000,000 - - - -MPS 300.06 St. Andrews Blvd - - 0 2,000,000 - - - -MPS 301 Rehab, SCWRF - - 0 500,000 - - - -MPS 302, Reconfig (Santa Barbara Blvd) 2,500,000 2,000,000 2,000,000 - - - - -MPS 305 Basin Program - - 0 2,500,000 - - - -MPS 305, Group 1; Glades - - 0 3,000,000 - - - -MPS 306 Group 3 (Bayshore/Thomasson) 6,000,000 6,183,500 6,183,500 4,000,000 - - - -MPS 306 MPS Lely - - 0 100,000 - - - -MPS 308 Replace (Shadowlawn-Linwood) - - 0 100,000 - - - -MPS 309 (E Naples Middle School) - - 0 100,000 - - - -MPS 321 Force Main to SCWRF - - 0 200,000 - - - -MPS 321, Rehab, Lely - 5,100,000 5,100,000 - - - - -Naples Park Basin Opt - - 0 4,000,000 - - - -Naples Park Gravity Sewer Replacement - 891,073 891,100 - - - - -NCWRF Bridge the Gap and 30.6 MGD 500,000 - 0 1,000,000 - - - -NCWRF Headwork & IQ Pump Station - 53,144 53,100 - - - - -NCWRF Infrastructure Fiscal Year 2018 Capital - 15 Public Utilities Capital Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Capital County Water / Sewer Divisions Capital County Sewer Capital Projects (414) CIP Category / Project Title Adopted ForecastedAmended BudgetBudgetBudgetBudgetBudget FY 2017 FY 2017FY 2017 FY 2022FY 2021FY 2020FY 2019FY 2018 Water / Sewer District Capital 360,000 538,061 538,100 - - - - -NCWRF Power Systems TSP-Cap - 92,124 92,100 300,000 - - - -NCWRF SCADA Support Op 301,800 301,800 301,800 - - - - -NCWRF SCADA TSP-Cap - 5,041 5,000 - - - - -NCWRF Sludge Holding Tank Replace 1,500,000 2,924,396 2,924,400 - - - - -NCWRF Technical Support Program-Cap - 601,629 601,600 - - - - -NE Service Area Integr & Reliab - 463,100 463,100 1,000,000 - - - -Orangetree Compliance - - 0 250,000 - - - -PS 302.07 Gravity Sewers, Lely - - 0 500,000 - - - -PS Twin Eagle Community 200,000 200,000 200,000 4,000,000 - - - -PUD Operations/Collection Facilities - 45,059 45,100 - - - - -Real Property/Infrastructure Audit 267,000 321,926 322,000 75,000 - - - -SCADA Compliance - WW - 42,315 42,300 - - - - -SCWRF Compliance Assurance Project - 19,177 19,200 - - - - -SCWRF Infrastructure - - 0 1,000,000 - - - -SCWRF IQ Storage Improvements 250,000 383,353 383,400 - - - - -SCWRF Power Systems TSP-Cap - 166,938 166,900 200,000 - - - -SCWRF SCADA Support Op 301,800 301,800 301,800 - - - - -SCWRF SCADA TSP-Cap 1,660,400 2,507,638 2,507,600 - - - - -SCWRF Technical Support Program-Cap - - 0 1,800,000 - - - -SCWRF Turbo Blowers - 2,550 2,600 - - - - -State Revolving Fund - 36,728 36,700 - - - - -System Improvements-Bill/Cust Svc. - 50,097 50,100 - - - - -Utilities Master Plan 500,000 - 0 1,500,000 - - - -Utility Billing Customer Serv Software - 11,943,700 11,943,700 - - - - -Vanderbilt Dr Cul-de-sacs, Basin 101 - 3,329,352 3,329,400 - - - - -Wastewater Pump Station TSP 100,000 100,000 100,000 1,200,000 - - - -Wastewater Pump Stations TSP-Ops 300,000 417,522 417,500 250,000 - - - -Wastewater Remote Sites TSP 350,000 688,278 688,300 500,000 - - - -Wastewater Security Systems 4,550,000 4,550,000 4,550,000 6,000,000 - - - -Water Reclamation Facilities TSP-Ops - 2,346,700 2,346,700 4,800,000 - - - -Western Interconnect - - 0 100,000 - - - -Western Interconnect MPS 364,500 364,500 364,500 - - - - -WW Collections SCADA Telemetry - 55,829 55,800 100,000 - - - -WW Collections SCADA/Telemetry 600,000 953,303 953,300 550,000 - - - -WW Treatment Plants TSP 6,329,500 24,493,830 0 9,169,300 - - - -X-Transfers/Reserves/Interest - Fd 414 - - - - 64,949,300 83,566,800 108,060,594 44,600,800Water / Sewer District Capital 44,600,800 - - - - 64,949,300 83,566,800 108,060,594Program Total Project Budget Fiscal Year 2018 Capital - 16 Public Utilities Capital Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Capital County Water / Sewer Divisions Capital County Water Sewer Grants (416/417) ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 Program Budgetary Cost Summary - - - - - 750,000 Capital Outlay na Net Operating Budget - - - - - 750,000 na - - - - - 750,000 Total Budget na Program Funding Sources ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 - - - - - 750,000 Intergovernmental Revenues na Total Funding - - - - - 750,000 na CIP Category / Project Title Adopted ForecastedAmended BudgetBudgetBudgetBudgetBudget FY 2017 FY 2017FY 2017 FY 2022FY 2021FY 2020FY 2019FY 2018 Water / Sewer District Capital - 750,000 750,000 - - - - -Naples Park Basin Opt - - - - - - 750,000 750,000Program Total Project Budget Notes: Upon receipt, new grant programs are brought before the Board of County Commissioners for approval and acceptance. At that time, budgets are added to the financial accounting and grant management system. Fiscal Year 2018 Capital - 17 Public Utilities Capital Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Capital Solid & Hazardous Waste Mgt Division Capital ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 Department Budgetary Cost Summary 3,728 - - - - - Personal Services na 2,582,245 75,300 600,000 - 600,000 969,500 696.8%Operating Expense 4,496 4,000,000 8,450,000 - 8,450,000 12,651,200 111.3%Capital Outlay 2,590,468 4,075,300 9,050,000 - 9,050,000 13,620,700 Net Operating Budget 122.1% - 407,500 905,000 - 905,000 - 122.1%Reserves for Contingencies - 20,100 210,800 - 210,800 - 948.8%Reserves for Capital 2,590,468 4,502,900 10,165,800 - 10,165,800 125.8% 13,620,700 Total Budget ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 Appropriations by Program 2,590,468 4,075,300 9,050,000 - 9,050,000 13,620,700 122.1%Solid Waste Capital Improvements (474) Total Net Budget 2,590,468 4,502,900 10,165,800 - 10,165,800 125.8% 13,620,700 Total Budget Total Transfers and Reserves 2,590,468 4,075,300 13,620,700 9,050,000 - 9,050,000 - 427,600 - 1,115,800 - 1,115,800 122.1% 160.9% Department Funding Sources ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 110,794 50,000 86,000 - 86,000 72.0% 86,000 Interest/Misc 906,000 1,915,900 7,344,100 - 7,344,100 283.3% 1,915,900 Trans fm 470 Solid Waste Fd 1,050,000 2,200,500 2,200,000 - 2,200,000 0.0% 2,200,500 Trans fm 473 Mand Collct Fd 10,482,000 339,000 540,000 - 540,000 59.3% 9,958,300 Carry Forward - (2,500)(4,300) - (4,300) 72.0% - Less 5% Required By Law Total Funding 10,165,800 12,548,794 4,502,900 10,165,800 - 125.8% 14,160,700 Fiscal Year 2018 Capital - 18 Public Utilities Capital Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Capital Solid & Hazardous Waste Mgt Division Capital CIP Category / Project Title Adopted ForecastedAmended BudgetBudgetBudgetBudgetBudget FY 2017 FY 2017FY 2017 FY 2022FY 2021FY 2020FY 2019FY 2018 Solid Waste Capital Compliance Assurance Program - - - - - 1,278,300 1,278,284 1,150,000 County 305 Masterplan - - - - - 150,000 150,000 150,000 Driveway Turn-Around Program - - - - - 290,900 290,888 100,000 E Naples Recycling Drop Off Center - - - - - 75,000 75,000 75,000 Expansion of Landfill - - - - - 102,000 101,955 100,000 Hammerhead Turn-around Program - - - - - 1,451,400 1,451,447 750,000 Infrastructure Maintenance - - - - - 79,200 79,208 50,000 Infrastructure TSP - ITS - - - - - 51,200 51,229 25,000 Infrastructure TSP - Landfill - - - - - 149,600 149,617 75,000 Infrastructure TSP - Recycling Centers - - - - - 177,900 177,859 75,000 Landfill Airspace Recovery - - - - - 14,100 14,074 300,000 Landfill Leachate Deep Injection Well - - - - 7,200,000 - - - Landfill Technical Support - - - - - 487,700 487,751 250,000 N Collier Hazardous Waste Storage Exp - - - - - 150,000 150,000 150,000 Northeast Recycling Drop-off Center - - - - 600,000 7,898,300 7,898,262 - Physical/Cyber Security - - - - - 83,200 83,166 50,000 Recycling Center Technical Support - - - - - 291,000 290,997 200,000 Resource Recovery Business Park - - - - 1,250,000 757,100 757,099 500,000 X-Transfer/Reserve/Interest-Fd 474 - - - - 1,115,800 - 440,937 427,600 - - - - 10,165,800 13,486,900 13,927,773 4,427,600Solid Waste Capital Water / Sewer District Capital Integrated Asset Management - - - - - 133,800 133,815 75,300 4,502,900 - - - - 10,165,800 13,620,700 14,061,588Department Total Project Budget Fiscal Year 2018 Capital - 19 Public Utilities Capital Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Capital Solid & Hazardous Waste Mgt Division Capital Solid Waste Capital Improvements (474) ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 Program Budgetary Cost Summary 3,728 - - - - - Personal Services na 2,582,245 75,300 600,000 - 600,000 969,500 696.8%Operating Expense 4,496 4,000,000 8,450,000 - 8,450,000 12,651,200 111.3%Capital Outlay Net Operating Budget 2,590,468 4,075,300 9,050,000 - 9,050,000 13,620,700 122.1% - 407,500 905,000 - 905,000 - 122.1%Reserves for Contingencies - 20,100 210,800 - 210,800 - 948.8%Reserves for Capital 2,590,468 4,502,900 10,165,800 - 10,165,800 125.8% 13,620,700 Total Budget Program Funding Sources ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 110,794 50,000 86,000 - 86,000 72.0% 86,000 Interest/Misc 906,000 1,915,900 7,344,100 - 7,344,100 283.3% 1,915,900 Trans fm 470 Solid Waste Fd 1,050,000 2,200,500 2,200,000 - 2,200,000 0.0% 2,200,500 Trans fm 473 Mand Collct Fd 10,482,000 339,000 540,000 - 540,000 59.3% 9,958,300 Carry Forward - (2,500)(4,300) - (4,300) 72.0% - Less 5% Required By Law Total Funding 10,165,800 12,548,794 4,502,900 10,165,800 - 125.8% 14,160,700 CIP Category / Project Title Adopted ForecastedAmended BudgetBudgetBudgetBudgetBudget FY 2017 FY 2017FY 2017 FY 2022FY 2021FY 2020FY 2019FY 2018 Solid Waste Capital 1,150,000 1,278,284 1,278,300 - - - - -Compliance Assurance Program 150,000 150,000 150,000 - - - - -County 305 Masterplan 100,000 290,888 290,900 - - - - -Driveway Turn-Around Program 75,000 75,000 75,000 - - - - -E Naples Recycling Drop Off Center 100,000 101,955 102,000 - - - - -Expansion of Landfill 750,000 1,451,447 1,451,400 - - - - -Hammerhead Turn-around Program 50,000 79,208 79,200 - - - - -Infrastructure Maintenance 25,000 51,229 51,200 - - - - -Infrastructure TSP - ITS 75,000 149,617 149,600 - - - - -Infrastructure TSP - Landfill 75,000 177,859 177,900 - - - - -Infrastructure TSP - Recycling Centers 300,000 14,074 14,100 - - - - -Landfill Airspace Recovery - - 0 7,200,000 - - - -Landfill Leachate Deep Injection Well 250,000 487,751 487,700 - - - - -Landfill Technical Support 150,000 150,000 150,000 - - - - -N Collier Hazardous Waste Storage Exp - 7,898,262 7,898,300 600,000 - - - -Northeast Recycling Drop-off Center 50,000 83,166 83,200 - - - - -Physical/Cyber Security 200,000 290,997 291,000 - - - - -Recycling Center Technical Support 500,000 757,099 757,100 1,250,000 - - - -Resource Recovery Business Park 427,600 440,937 0 1,115,800 - - - -X-Transfer/Reserve/Interest-Fd 474 - - - - 10,165,800 13,486,900 13,927,773 4,427,600Solid Waste Capital Water / Sewer District Capital 75,300 133,815 133,800 - - - - -Integrated Asset Management 4,502,900 - - - - 10,165,800 13,620,700 14,061,588Program Total Project Budget Fiscal Year 2018 Capital - 20 Public Utilities Capital Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Capital Facilities Management Division Capital ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 Department Budgetary Cost Summary 1,574,053 3,531,500 4,884,000 - 4,884,000 4,462,700 38.3%Operating Expense 1,838,081 1,009,000 366,000 - 366,000 1,470,700 (63.7%)Capital Outlay 3,412,135 4,540,500 5,250,000 - 5,250,000 5,933,400 Net Operating Budget 15.6% 3,435,600 2,063,900 3,032,400 - 3,032,400 2,063,900 46.9%Advance/Repay to 390 Gov't Fac 500,000 500,000 510,000 - 510,000 500,000 2.0%Advance/Repay to 408 W-S Ops 630,000 630,000 325,000 - 325,000 630,000 (48.4%)Advance/Repay to 471 S Waste 5,169,400 5,169,500 5,705,200 - 5,705,200 5,169,500 10.4%Trans to 298 Sp Ob Bd '10 - 800,000 800,000 - 800,000 - 0.0%Reserves for Contingencies - 2,812,900 2,859,800 - 2,859,800 - 1.7%Reserves for Debt Service 13,147,135 16,516,800 18,482,400 - 18,482,400 11.9% 14,296,800 Total Budget ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 Appropriations by Program 1,406,198 4,540,500 5,250,000 - 5,250,000 5,739,000 15.6%County Wide Capital Project Fund (301) 2,005,937 - - - - 194,400 General Governmental Buildings Impact Fee (390) na Total Net Budget 13,147,135 16,516,800 18,482,400 - 18,482,400 11.9% 14,296,800 Total Budget Total Transfers and Reserves 3,412,135 4,540,500 5,933,400 5,250,000 - 5,250,000 9,735,000 11,976,300 8,363,400 13,232,400 - 13,232,400 15.6% 10.5% Department Funding Sources ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 53,496 - - - - - Miscellaneous Revenues na 158,202 60,000 85,000 - 85,000 41.7% 93,000 Interest/Misc 2,951,074 2,400,000 2,800,000 - 2,800,000 16.7% 2,650,000 Impact Fees 4,130 - - - - - Deferred Impact Fees na 630,000 630,000 325,000 - 325,000 (48.4%) 630,000 Advance/Repay fm 001 Gen Fd 3,435,600 2,063,900 3,032,400 - 3,032,400 46.9% 2,063,900 Advance/Repay fm 301 Cap Proj 5,455,200 6,741,900 7,891,400 - 7,891,400 17.1% 6,741,900 Trans fm 001 Gen Fund 87,664 - - - - - Trans fm 113 Comm Dev Fd na 48,153 - - - - - Trans fm 408 Water / Sewer Fd na 983 - - - - - Trans fm 470 Solid Waste Fd na - 450,000 - - - (100.0%) 450,000 Trans fm 517 Health Ins 6,708,200 4,293,900 4,492,900 - 4,492,900 4.6% 6,160,900 Carry Forward - (122,900)(144,300) - (144,300) 17.4% - Less 5% Required By Law Total Funding 18,482,400 19,532,702 16,516,800 18,482,400 - 11.9% 18,789,700 Fiscal Year 2018 Capital - 21 Public Utilities Capital Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Capital Facilities Management Division Capital CIP Category / Project Title Adopted ForecastedAmended BudgetBudgetBudgetBudgetBudget FY 2017 FY 2017FY 2017 FY 2022FY 2021FY 2020FY 2019FY 2018 Facilities Management A/C, Heating, & Ventilation Repairs - - - - 2,520,000 1,019,600 1,019,567 791,000 ADA Compliance - - - - 116,000 100,000 100,000 100,000 Asset Management - - - - 300,000 150,000 150,000 150,000 Bldg G Renov-Wellness Ctr - - - - - 450,000 450,000 450,000 Building C-2 Renovations - - - - - 372,600 372,605 - DAS Shelter Repairs - - - - - 8,500 8,522 - Fire Alarms/Life Safety - - - - 207,500 459,000 459,000 459,000 General Building Repairs - - - - 553,000 1,987,400 1,987,315 1,786,600 Gov't Center Master Plan - - - - - 356,800 356,849 - Operating Project 390 - - - - - 147,000 146,994 - Paint Plan - - - - 162,000 9,100 9,150 - Reroofing Projects - - - - 1,391,500 826,000 826,042 803,900 X-fers/Reserves - Fund 301 - Public Utilities - - - - 3,832,400 2,063,900 2,513,815 2,863,900 X-fers/Reserves - Fund 390 - - - - 9,400,000 6,299,500 9,112,400 9,112,400 - - - - 18,482,400 14,249,400 17,512,259 16,516,800Facilities Management Supervisor of Elections SOE Building - - - - - 47,400 47,468 - 16,516,800 - - - - 18,482,400 14,296,800 17,559,727Department Total Project Budget Fiscal Year 2018 Capital - 22 Public Utilities Capital Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Capital Facilities Management Division Capital General Governmental Buildings Impact Fee (390) ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 Program Budgetary Cost Summary 192,906 - - - - 148,900 Operating Expense na 1,813,030 - - - - 45,500 Capital Outlay na Net Operating Budget 2,005,937 - - - - 194,400 na 500,000 500,000 510,000 - 510,000 500,000 2.0%Advance/Repay to 408 W-S Ops 630,000 630,000 325,000 - 325,000 630,000 (48.4%)Advance/Repay to 471 S Waste 5,169,400 5,169,500 5,705,200 - 5,705,200 5,169,500 10.4%Trans to 298 Sp Ob Bd '10 - 2,812,900 2,859,800 - 2,859,800 - 1.7%Reserves for Debt Service 8,305,337 9,112,400 9,400,000 - 9,400,000 3.2% 6,493,900 Total Budget Program Funding Sources ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 55,553 25,000 20,000 - 20,000 (20.0%) 28,000 Interest/Misc 2,951,074 2,400,000 2,800,000 - 2,800,000 16.7% 2,650,000 Impact Fees 4,130 - - - - - Deferred Impact Fees na 630,000 630,000 325,000 - 325,000 (48.4%) 630,000 Advance/Repay fm 001 Gen Fd 3,435,600 2,063,900 3,032,400 - 3,032,400 46.9% 2,063,900 Advance/Repay fm 301 Cap Proj 5,748,900 4,114,700 3,363,600 - 3,363,600 (18.3%) 4,485,600 Carry Forward - (121,200)(141,000) - (141,000) 16.3% - Less 5% Required By Law Total Funding 9,400,000 12,825,257 9,112,400 9,400,000 - 3.2% 9,857,500 CIP Category / Project Title Adopted ForecastedAmended BudgetBudgetBudgetBudgetBudget FY 2017 FY 2017FY 2017 FY 2022FY 2021FY 2020FY 2019FY 2018 Facilities Management - 146,994 147,000 - - - - -Operating Project 390 9,112,400 9,112,400 6,299,500 9,400,000 - - - -X-fers/Reserves - Fund 390 - - - - 9,400,000 6,446,500 9,259,394 9,112,400Facilities Management Supervisor of Elections - 47,468 47,400 - - - - -SOE Building 9,112,400 - - - - 9,400,000 6,493,900 9,306,862Program Total Project Budget Fiscal Year 2018 Capital - 23 Public Utilities Capital Collier County Government Fiscal Year 2018 Recom'd Budget Public Utilities Capital Facilities Management Division Capital County Wide Capital Project Fund (301) ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 Program Budgetary Cost Summary 1,381,147 3,531,500 4,884,000 - 4,884,000 4,313,800 38.3%Operating Expense 25,051 1,009,000 366,000 - 366,000 1,425,200 (63.7%)Capital Outlay Net Operating Budget 1,406,198 4,540,500 5,250,000 - 5,250,000 5,739,000 15.6% 3,435,600 2,063,900 3,032,400 - 3,032,400 2,063,900 46.9%Advance/Repay to 390 Gov't Fac - 800,000 800,000 - 800,000 - 0.0%Reserves for Contingencies 4,841,798 7,404,400 9,082,400 - 9,082,400 22.7% 7,802,900 Total Budget Program Funding Sources ForecastAdopted Recom'd ChangeExpandedActualCurrent FY 2017 FY 2018FY 2018FY 2018FY 2017FY 2016 FY 2018 53,496 - - - - - Miscellaneous Revenues na 102,650 35,000 65,000 - 65,000 85.7% 65,000 Interest/Misc 5,455,200 6,741,900 7,891,400 - 7,891,400 17.1% 6,741,900 Trans fm 001 Gen Fund 87,664 - - - - - Trans fm 113 Comm Dev Fd na 48,153 - - - - - Trans fm 408 Water / Sewer Fd na 983 - - - - - Trans fm 470 Solid Waste Fd na - 450,000 - - - (100.0%) 450,000 Trans fm 517 Health Ins 959,300 179,200 1,129,300 - 1,129,300 530.2% 1,675,300 Carry Forward - (1,700)(3,300) - (3,300) 94.1% - Less 5% Required By Law Total Funding 9,082,400 6,707,445 7,404,400 9,082,400 - 22.7% 8,932,200 CIP Category / Project Title Adopted ForecastedAmended BudgetBudgetBudgetBudgetBudget FY 2017 FY 2017FY 2017 FY 2022FY 2021FY 2020FY 2019FY 2018 Facilities Management 791,000 1,019,567 1,019,600 2,520,000 - - - -A/C, Heating, & Ventilation Repairs 100,000 100,000 100,000 116,000 - - - -ADA Compliance 150,000 150,000 150,000 300,000 - - - -Asset Management 450,000 450,000 450,000 - - - - -Bldg G Renov-Wellness Ctr - 372,605 372,600 - - - - -Building C-2 Renovations - 8,522 8,500 - - - - -DAS Shelter Repairs 459,000 459,000 459,000 207,500 - - - -Fire Alarms/Life Safety 1,786,600 1,987,315 1,987,400 553,000 - - - -General Building Repairs - 356,849 356,800 - - - - -Gov't Center Master Plan - 9,150 9,100 162,000 - - - -Paint Plan 803,900 826,042 826,000 1,391,500 - - - -Reroofing Projects 2,863,900 2,513,815 2,063,900 3,832,400 - - - -X-fers/Reserves - Fund 301 - Public Utilities - - - - 9,082,400 7,802,900 8,252,865 7,404,400Facilities Management 7,404,400 - - - - 9,082,400 7,802,900 8,252,865Program Total Project Budget Fiscal Year 2018 Capital - 24 Public Utilities Capital FY 2018 Fiscal Year 2018 thru 2022 Capital Improvement Program - Project Descriptions by CIP Category Collier County Government Project Title / Description Recom'dProject# Facilities Management 2,520,00052162A/C, Heating, & Ventilation Repairs Major maintenance, repair, or replacement of air conditioning, heating, and ventilation equipment to all Governmental buildings. Enterprise Facilities (Water/Sewer District, Solid Waste, Community Development, etc) or Facilities supported by something 'other than the General Fund' (TDC, Courts, etc) shall provide funding for all repairs, replacements, or maintenance of the equipment. 116,00052169ADA Compliance Renovate the facilities to ensure access to buildings for people with disabilities in accordance with Americans with Disabilities Act (ADA). The ADA Standards establish design requirements for the construction and alteration of facilities subject to the law. These enforceable standards apply to places of public accommodation, commercial facilities, and state and local government facilities. 300,00050149Asset Management Facilities Management is next in implementing Asset Management. Asset Management is an enterprise-wide integrated program to manage Collier County's capital assets. 207,50052163Fire Alarms/Life Safety General maintenance, repair, or replacement of electrical infrastructure, fire alarms and life safety items to all Governmental buildings. If the building is occupied by an Enterprise Facilities (Water/Sewer District, Solid Waste, Community Development, etc) or Facilities supported by something 'other than the General Fund' (TDC, Courts, etc) shall provide the necessary funding. 553,00052525General Building Repairs General maintenance, repair, refurbishment, or renovations to all Governmental buildings (work involved is not water/sewer, reroofing, A/C repairs, fire alarms, life safety, or painting). Enterprise Facilities (Water/Sewer District, Solid Waste, Community Development, etc) or Facilities supported by something 'other than the General Fund' (TDC, Courts, etc) shall provide funding for all repairs, replacements, or maintenance projects. 162,00052506Paint Plan Major painting all Governmental buildings (interior and exterior). Enterprise Facilities (Water/Sewer District, Solid Waste, Community Development, etc) or Facilities supported by something 'other than the General Fund' (TDC, Courts, etc) shall provide funding for all painting projects. 1,391,50052161Reroofing Projects Major maintenance/repair or replacement of roofs to all Governmental buildings. Enterprise Facilities (Water/Sewer District, Solid Waste, Community Development, etc) or Facilities supported by something 'other than the General Fund' (TDC, Courts, etc) shall provide funding for all repairs, replacements, or maintenance of roof replacement projects. 3,832,40099301puX-fers/Reserves - Fund 301 - Public Utilities The Interfund Transfers and Reserves for Countywide Capital Projects Fund 301 - Public Utilities Department portion are for the following items: $3,032,400 General Governmental Facilities Impact Fee Fund (390) requires a loan for the payment of next year's debt service obligations. $ 800,000 has been set aside in Reserves for Contingencies for any unexpected or emergency repairs. Fiscal Year 2018 CIP Summary ReportsCapital - 25 FY 2018 Fiscal Year 2018 thru 2022 Capital Improvement Program - Project Descriptions by CIP Category Collier County Government Project Title / Description Recom'dProject# Facilities Management 9,400,00099390X-fers/Reserves - Fund 390 The Interfund Transfers and Reserves for the General Governmental Facilities Impact Fee Fund 390 are for the following items: $ 510,000 Supervisor of Election's Building (Loan from Water~Sewer Operations Fund 408) $ 325,000 Property Appraiser's Building on Radio Road (Loan from Solid Waste Fund 471) $1,888,700 Series 2010 Bond debt service payment for the additional funding for the Emergency Services Center (ESC), Courthouse Annex and Fleet Facility (growth portion)-Transfer to 298. $ 208,600 Series 2010B Bond debt service payment for the North Naples Government Satellite Offices -Transfer to 298. $2,249,500 Series 2011 Bond debt service payment for Fleet, Annex, Parking Garage, and ESC-Transfer to 298. $1,358,400 Series 2013 Bond debt service payment for Fleet, Annex, Parking Garage, and ESC-Transfer to 298. $ 196,500 Reserve for Debt Service on the Series 2010B Bond $1,984,100 Reserve for Debt Service on the Series 2011 Bond $ 679,200 Reserve for Debt Service on the Series 2013 Bond The Series 2010B, 2011 and the 2013 Bonds debt service payments (transfer to fund 298) have principal and interest payments due on October 1. The Reserve for Debt Service insures that there is sufficient cash on October 1 to make the required debt service payment. 18,482,400Total Facilities Management Fiscal Year 2018 CIP Summary ReportsCapital - 26 FY 2018 Fiscal Year 2018 thru 2022 Capital Improvement Program - Project Descriptions by CIP Category Collier County Government Project Title / Description Recom'dProject# Solid Waste Capital 7,200,000SW474_1 Landfill Leachate Deep Injection Well Purpose: To construct a Deep Injection Well (DIW) for long term disposal of leachate. Leachate disposal is required in the Solid Waste Sub-Element (Policy 2.2) of the land Development Code and as regulated by FAC 62-701.500 Landfill Construction Requirements, and FAC 62-701.510 Leachate Monitoring Requirements. Due to the large volume of leachate generated by the landfill, and potential impacts from tropical storms, an improved disposal and/or treatment system is needed. Method: Fixed-term contracts and competitive construction bids. End State: A fully compliant landfill program that will meet all rules, regulations, and future disposal demands as well as community expectations. 600,00059009Northeast Recycling Drop-off Center Purpose: Provide a safe, convenient, neighborhood recycling center in northeast Collier County to serve the needs of the residents in that area as defined in the Solid Waste Sub-Element (Policy 1.3) of the Land Development Code. This recycling center follows the Integrated Solid Waste Management Strategy of providing additional Recycling Drop-off Centers in the intermediate time frame. Development of this new center will augment overall recycling efforts, save valuable landfill space and, most importantly, remove hazardous waste from the environment. In doing so, it will help protect ground water and other environmental resources. The location is an 11-acre site just off Immokalee Road, east of the Collier County Fairgrounds. Funding for FY18 includes building construction, fire main, utilities and security. Method: Fixed-term contracts will be used to design and permit the facility; construction will be through the competitive construction bid process. End State: Extend the life of the Collier County Landfill by diverting hazardous and recyclable materials from the landfill. 1,250,00059007Resource Recovery Business Park Purpose: Provide for critical functions such as staging sites for storm debris recovery operations, construction and demolition materials recycling, yard waste recycling, bio-solids processing, Leachate management, special materials recycling, and a materials recovery facility in a centrally located facility north of the Collier County Landfill. The project envisions a public/private mix of investment and operations to meet the goal of providing emerging and proven technology at best value. The facility is located on a 344-acre parcel immediately north of the existing Collier County Landfill. Fifty percent of the parcel will be set aside as preserve, consistent with the county’s good neighbor policy. Funding for FY18 includes mitigation, clearing, utility and roadway construction, and platting. Method: Competitive construction bid for initial site construction services. End State: A comprehensive resource recovery business park that will service the solid waste management operations, provide public/private partnership opportunities, and extend the life of the landfill by reducing the solid waste stream being land filled. 1,115,80099474X-Transfer/Reserve/Interest-Fd 474 Reserves for Contingencies and future Capital Projects are recorded in this project. 10,165,800Total Solid Waste Capital Fiscal Year 2018 CIP Summary ReportsCapital - 27 FY 2018 Fiscal Year 2018 thru 2022 Capital Improvement Program - Project Descriptions by CIP Category Collier County Government Project Title / Description Recom'dProject# Water / Sewer District Capital 2,000,000N414_11 8th Street Interceptor Sewer Purpose: This project is part of a multi-year program (FY2018 - 20) that restores, rehabilitates and replaces aging wastewater collection system within the Naples Park area of the Collier County Water-Sewer District and significantly extends its useful life beyond that originally estimated. It will help to maintain compliance and to meet operational needs. Program goals include the minimization of infiltration and inflow of storm and ground water into the wastewater collections system by replacing manholes and underground pipes and service laterals, including the renewal of gravity wastewater sewers on a prioritized basis. Wastewater basin design analyses were performed to evaluate existing conditions, assess condition of wastewater assets, identify system deficiencies, and recommend collection system improvements on a bundled basis. The main focus of FY18 budget will be the construction of a new 8th Street Interceptor Sewer. Method: Fixed-term contracts and competitive bids. End State: Maintain compliance and meet operational demands throughout the wastewater system. 45,00070202Collier County Utility Standards Purpose: Utilize design consultants to provide independent peer review of specific Collier County Water-Sewer District infrastructure detail drawings based on input and feedback from County staff and specific advisory committees. The Board of County Commissioners annually approves the Utility Standards Manual update. Method: Meet with the Utilities Discussion Group and Public Utilities Operating Divisions to update the Utility Standards Manual. End State: That the Utility Standards Manual, as the Public Utilities principal technical guidance document, ensures that all utility-related construction meets county standards, that consistency is maintained, and that the utility continues to stay compliant with all state and federal regulations. 150,00070071County-wide Utility Projects-Water Purpose: Plan, design, and construct Collier County Water-Sewer District (CCWSD) infrastructure driven by intra-county divisions. Project activities generally include: engineering review, plan development or deconflicting for various intersection improvements, lighting improvements, traffic signal upgrades and installations throughout the CCWSD service area. Method: Fixed-term contracts and competitive bids or Joint Project Agreements with the Growth Management Division. End State: Interdivisional coordination with utility construction projects to maintain compliance and provide reliable services with minimal impact to the community. 200,00073065County-wide Utility Projects-WW Purpose: Plan, design, and construct Collier County Water-Sewer District infrastructure driven by intra-county divisions. Upcoming projects include utility relocations driven by the Lely Area Stormwater Improvement Project (LASIP) project and improvements to intersections and stormwater systems. Method: Fixed-term contracts and competitive bids or Joint Project Agreements with the Growth Management Division. End State: Interdivisional coordination with utility construction projects to maintain compliance and provide reliable services with minimal impact to the community. 2,000,000N414_12 Creekside Phase 2 Force Main Purpose: This is a multi-year program (FY2018 - 19) that will restore, rehabilitate and replace aging wastewater collection system within the Naples Park area of the Collier County Water-Sewer District to maintain compliance and to meet operational needs. This replacement program is geared specifically towards extending the useful life of the sewer system beyond its original estimated life span. Program goals include the minimization of infiltration and inflow of storm and ground water into the wastewater collections system by replacing manholes and underground pipes and service laterals, including the renewal of gravity wastewater sewers on a prioritized basis. Wastewater basin design analyses were performed to evaluate existing conditions, assess condition of wastewater assets, identify system deficiencies, and recommend collection system improvements on a bundled basis. FY18 budget will focus primarily on the construction of the Creekside Phase 2 Force Main. Method: Fixed-term contracts and competitive bids. End State: Maintain compliance and meet operational demands throughout the wastewater system. 300,00070019Cross Connections Program Purpose: To maintain compliance with Rule 62-555 of the Florida Administrative Code and the Collier County Cross Connection Control Ordinance. The rule requires all community water systems to establish and implement a routine cross-connection control program to detect and control cross-connections and prevent backflow of contaminants into the public water supply. Approximately 5,000 devices in various neighborhoods throughout the County are planned for overhaul or replacement in FY18. Method: Procure the devices through existing contracts and provide installation through a bid process or by staff as determined by the operating department. End State: Fully compliant and protected water supply system. Fiscal Year 2018 CIP Summary ReportsCapital - 28 FY 2018 Fiscal Year 2018 thru 2022 Capital Improvement Program - Project Descriptions by CIP Category Collier County Government Project Title / Description Recom'dProject# Water / Sewer District Capital 200,000W412_7 Cyber Security SCADA Purpose: Implement heightened security measures on stand-alone supervisory control and data acquisition (SCADA) systems to prevent accidental or malicious loss through cyber threats such as network intrusion and hacking that could directly impact operations. Evaluate and prioritize mitigation to resolve risk and exposure to maintain compliance with Department of Homeland Security requirements for public water supply systems and sustainability of existing levels of service. Method: Fixed-term contracts. End State: Compliant and secure infrastructure. 300,00071067Distribution Repump Station TSP Purpose: This is a multi-year program that addresses prioritized needs. It provides annual Technical Support Program (TSP) funding for repairs and modifications to the secondary water distribution stations to meet demand and to remain in compliance. These stations include the following booster stations and storage tanks: Carica, Manatee, Isles of Capri, Goodland and Vanderbilt. FY18 projects include Carica tank west rehab, emergency generator refurbishment, tank/structure weather proofing, process building roofing, chemical process rehab, and pump appurtenance rehab. Method: Fixed-term contracts and competitive bids. End State: Meet demand, remain in compliance and maintain reliability and safety. 350,00070113Facility Infrastructure Maintenance Purpose: Operational and preventative maintenance program which performs regular preventative maintenance on water facilities including inspections of roofs, gates, garage doors, fences, HVAC (heating, ventilation, air conditioning), site and fire sprinklers. Method: Fixed term services contracts and/or competitive construction bids. End State: An enhanced and fully compliant water department that will extend the life cycle of the facility and its vertical assets. 350,00072013Facility Infrastructure Maintenance - WW Purpose: To optimize the operating efficiency and increase the safety of the Wastewater Plants by completing maintenance service projects (MSP) relating to rehabilitation, replacements, and optimizations of HVAC (heating, ventilation, air conditioning) systems, roofs, electrical and fire systems, and other vertical assets existing at the South and North County Regional Wastewater Treatment Plants (SCWRF and NCWRF). This will enhance the utilization and life cycle expectancy of the SCWRF and NCWRF by maintaining the Plants in satisfactory operating condition by providing systematic inspection, detection, and correction of incipient failures either before they occur or before they develop into major defects. Planned FY18 projects include preventive maintenance inspections of both Wastewater Plant assets and HVAC replacement, roof replacements and light-emitting diode (LED) lighting at both Wastewater Plants. Method: Fixed term services contracts and/or competitive construction bids. End State: An enhanced and fully compliant SCWRF and NCWRF that will ensure safety for employees, and extend the life cycle of the Plants and its vertical assets. 150,00070045FDOT Utility Projects-Water Purpose: Plan, design, and construct Collier County Water-Sewer District (CCWSD) infrastructure driven by Florida Department of Transportation (FDOT) construction projects. Long-range upcoming FDOT projects that require utility relocations include: US41 from Greenway Road to Six L’s Farm Road and potentially I-75 at CR951 Ultimate Build Out. Project activities generally include: engineering review, plan development or reduction of risk of collision for various intersection improvements, lighting improvements, traffic signal upgrades and installations throughout the CCWSD service area. Method: Fixed-term contracts and competitive bids or Joint Project Agreements with the FDOT. End State: Coordinated utility construction to maintain compliance and provide reliable services. 60,00075018Financial Services Purpose: Utilize outside consultants to prepare feasibility reports, perform rate studies, asset valuations, and acquisitions. Method: Utilize a financial consultant to perform these required studies. The external consultants are utilized in situations where an independent perspective is required or specialized financial analysis is needed. End State: Provide independent financial assessments to aid in business decision-making. 300,00070023Fire Hydrant Replacement Purpose: This on-going program replaces fire hydrants that have reached the end of their useful life. There are approximately 10,000 fire hydrants in the distribution system; 40 hydrants are planned to be replaced each year beyond those replaced with water main rehabilitation projects. The areas targeted for replacement will be primarily based on input from the Fire Districts and areas of concern identified during annual flushing exercises. Method: Utilize existing underground services contracts. End State: Replace hydrants to ensure compliance with fire protection codes and ordinances, and provide a point to flush the water distribution system when necessary to comply with state and federal water quality standards. Fiscal Year 2018 CIP Summary ReportsCapital - 29 FY 2018 Fiscal Year 2018 thru 2022 Capital Improvement Program - Project Descriptions by CIP Category Collier County Government Project Title / Description Recom'dProject# Water / Sewer District Capital 300,000N414_22 FM Immokalee Rd and Logan Blvd Purpose: This multi-year project (FY2018 - 20) will provide for capital addition of a wastewater force main (FM) in order to enable the efficient conveyance of wastewater from the new Heritage Bay Master Pump Station. FY18 budget will provide funds specifically for the design of a new force main along Immokalee Road and Logan Blvd in order to provide additional capacity for the growing area of Northeastern portions of the service area. Method: Fixed-term contracts and competitive bids. End State: Maintain compliance and meet operational demands of wastewater transmission system. 750,000N414_24 FM Twin Eagles Purpose: This one-year project will provide funding for capital addition of a wastewater force main (FM) in order to enable the efficient conveyance of wastewater from Twin Eagles to the new Heritage Bay Master Pump Station. The main focus of the current FY18 budget is to add a new wastewater force main to be generally located along 8th Street NW from the existing Community pump station at Twin Eagles to the exiting wastewater force main along Immokalee Road. Twin Eagles force main ties into 16" force main on Immokalee Road which flow to the Hermitage Bay master pump station, which will flow to the Immokalee Rd/Logan Blvd force main. This will flow to either mater pump station (MPS) 107 or the North County Water Reclamation Facility (NCWRF). Method: Fixed-term contracts and competitive bids. End State: Maintain compliance and meet operational demands of wastewater transmission system. 100,00071058General Legal Services Purpose: Obtain expert legal counsel for wastewater, and reuse issues. Provide appropriate legal representation for various complex or specialized wastewater related matters to stay in compliance. Method: Issue work orders under a competitive agreement for legal services for complex or specialized legal tasks. End State: Provide appropriate legal representation for various complex or specialized wastewater related matters to stay in compliance. 1,250,000W412_3 Glades AC Pipe Rehab Purpose: Remove asbestos-concrete (AC) pipe in The Glades that has reached the end of useful life. The project will include moving existing services off of the failing water main and connect them to a newer adjacent water main, and then removing the old pipe. Method: Utilize existing fixed-term underground contracts or competitive bidding for installation and fixed-term engineering services contracts for design. End State: Sustain compliance and meet demand with reliability through continued proactive maintenance and replacement of the water distribution system assets. 500,00070172Gulfshore Dr AC WM (cap) Purpose: Abandon asbestos-concrete (AC) pipe along Gulfshore Drive that has reached the end of its useful life. The project will include moving existing services off of the failing water main and connect them to a newer adjacent water main. The asbestos-concrete pipe is being grouted in place because underground conditions are too congested with other utilities to allow removal without damage. Method: Utilize existing fixed-term underground contracts or competitive bidding for installation and fixed-term engineering services contracts for design. End State: Sustain compliance and meet demand with reliability through continued proactive maintenance and replacement of the water distribution system assets. 150,00075017Hydraulic Modeling Purpose: Provide hydraulic evaluation and analysis of all water, wastewater and irrigation quality water infrastructure. Hydraulic models are used to verify availability for Planned Unit Developments, concurrency, and master planning. Models are also used by operations to predict pressures, flow rates, and water quality under varying conditions. These data points are essential for determining the appropriate emergency response in the event of pipe breakage. Flows can be modeled and redirected with minimum disruption to the community. Hydraulic analysis will identify opportunities for cost-savings resulting from pump station operations, diurnal curve management, pressure management, and pipe sizing. For FY18 the plan is to update the model, synchronize the model to geographical information system (GIS), evaluate scenarios and develop operating criteria and strategies based on system growth. Method: Fixed-term contracts. End State: Maintained compliance and operations through this current year execution of a multi-year program. Fiscal Year 2018 CIP Summary ReportsCapital - 30 FY 2018 Fiscal Year 2018 thru 2022 Capital Improvement Program - Project Descriptions by CIP Category Collier County Government Project Title / Description Recom'dProject# Water / Sewer District Capital 100,00070114Infrastructure TSP Field Ops - Water Purpose: A technical support program (TSP) to optimize the operating efficiency and increase the safety of the Public Utility Operations Center (PUOC) and Collier County wellfield structures by completing projects relating to rehabilitation, replacements, and optimizations of HVAC (heating, ventilation, air conditioning) systems, roofs, electrical and fire systems, and other vertical assets existing in the PUOC and Public Utilities Wellfield. This will enhance the utilization and life cycle expectancy of the PUOC and wellfield by maintaining structures in satisfactory operating condition by providing systematic inspection, detection, and correction of incipient failures either before they occur or before they develop into major defects. Planned FY18 projects include preventive maintenance inspections of PUOC and wellfield assets and HVAC replacement and roof replacements at the PUOC. Method: Fixed term services contracts and/or competitive construction bids. End State: An enhanced and fully compliant PUOC and wellfield that will ensure safety for employees, and extend the life cycle of the facility and its vertical assets. 500,00070118Infrastructure TSP Water Plants Purpose: A technical support program (TSP) to optimize the operating efficiency and increase the safety of the Water Plants by completing maintenance service projects (MSP) relating to rehabilitation, replacements, and optimizations of HVAC (heating, ventilation, air conditioning) systems, roofs, electrical and fire systems, and other vertical assets existing at the South and North County Regional Water Treatment Plant (SCRWTP & NCRWTP). This will enhance the utilization and life cycle expectancy of the SCRWTP and NCRWTP by maintaining the Plants in satisfactory operating condition by providing systematic inspection, detection, and correction of incipient failures either before they occur or before they develop into major defects. Planned FY18 projects include preventive maintenance inspections of both Water Plant assets, roof replacements and LED lighting at both Water Plants. Method: Fixed term services contracts and/or competitive construction bids. End State: An enhanced and fully compliant SCRWTP and NCRWTP that will ensure safety for employees, and extend the life cycle of the Plants and its vertical assets. 1,000,00050105Integrated Asset Management Purpose: Implement an Enterprise-wide Integrated Asset Management Program within the Public Utilities Department (PUD) to more cost-effectively manage PUD assets. This multiyear program has three phases. Phase One (PUD pilot) is complete. Phase Two (Request for Proposal (RFP) solicitation and vendor selection) is complete. Phase Three is in progress and is focused on implementation and integration of the selected Cityworks software application with existing Agency wide systems of GIS (geographic information system), SAP (County's accounting program), SCADA (supervisory control and data acquisition) and many interdivisional processes including procurement and finance spanning five full scale implementation projects (FSIP) . Cityworks go-live occurred in May 2016 for FSIP 1, 2, & 3, and FSIP 5 is anticipated to go-live in June 2017. Technical Support is anticipated to continue into FY18. Method: Through competitive Request for Proposal process. End State: A tangible GIS-based asset and work management system to guide predictive and preventative maintenance and consistent sustainable work practices that occur in a systematic manner, at less cost, and with less operational impact versus catastrophic failure. 350,000N414_10 IQ Aquifer Storage and Recovery Purpose: This two year project (FY2018 - 19) will plan, design, construct and test the Aquifer Storage and Recovery (ASR) system located at the Livingston Road well field north of Immokalee Road. Construction of Well #1 and Well #2 are complete. FY18 budget will be used to support Wells #1 and #2 cycle testing to determine how much irrigation quality (IQ) water can be recovered from the ASR system and to establish the initial ASR operations protocol. Current FY18 budget will also be used to initiate the design for Wells #3 through #5. Method: Utilize existing fixed term contracts to provide professional engineering guidance. End State: Reliable Irrigation Quality ASR system compliant with the Florida Department of Environmental Protection rules. 200,00070062IQ Systems SCADA TSP Ops Purpose: This is a multiple year operational program to restore and rehabilitate and support enhanced telemetry communications and Supervisory Control and Data Acquisition (SCADA) systems through a Technical Support Program (TSP) to eliminate obsolescence of existing programmable logic controllers (PLCs), communication networks and protocol limitations and various pieces of instrumentation used to monitor and control the process. There are 51 PLCs in the irrigation quality (IQ) system with an average of five being replaced per year with a replacement priority based on fiber optic network availability. Method: Fixed-term contracts and competitive bids. End State: Maintain compliance and reliability throughout the IQ SCADA system. Fiscal Year 2018 CIP Summary ReportsCapital - 31 FY 2018 Fiscal Year 2018 thru 2022 Capital Improvement Program - Project Descriptions by CIP Category Collier County Government Project Title / Description Recom'dProject# Water / Sewer District Capital 600,00070166IQ Water System TSP-Ops Purpose: This is a multi-year Technical Support Program (TSP) to restore, rehabilitate and maintain infrastructure of the Irrigation Quality (IQ) water system needed to meet customer demand, and contractual and regulatory compliance, including the rehabilitation of IQ pump stations, isolation valves, and air release valves, as well as meters, pumps, and motors. This program allows operations to accurately measure water sold, ensuring accurate revenue generation; delivers water to the customer per contractual agreements; and allows for system isolation for regulatory compliance. As the reclaimed water system is more than 20 years old, these operational projects are necessary to maintain the distribution system in working condition. FY18 budget will focus on flow meter and valve replacement, Point of Delivery equipment installations, and Eagle Lakes pond site maintenance. Method: Fixed-term contracts and competitive bids. End State: Remain in contractual and regulatory compliance, meet customer demand, and improve system efficiency. 200,00070131Large Meters Renewal & Replacement Purpose: Remove and replace 20 large meters as part of a multi-year program to replace water meters that have reached the end of their useful life. There are approximately 600 large meters in the system that record water usage, and are thus the source of revenue for the utility. All meters three inch and larger are tested and calibrated annually with replacements scheduled on a rotating basis. In general, this project replaces large water meters that have reached the end of their useful life, and meters that have been identified during the meter audit program as being non-compliant. Method: Fixed term contracts for purchases and replacements with a portion of installation by staff. End State: Remain in compliance with Florida Administrative Code 62-555, Ordinance 201-73, and sustain an accurate measurement of customer water usage for accurate billing. 100,00070109Lime Treatment TSP Purpose: A technical support program (TSP) to design and construct improvements to the lime softening treatment process at the South County Regional Water Treatment Plant utilizing technology improvements that have occurred since the initial plant design in the early 1980's. Work in FY18 includes repair and rehabilitation of components related to the sludge thickening & dewatering system and polymer feed equipment. Method: Through fixed-term contracts and competitive bids. End State: Meet demand and remain in compliance, achieve energy efficiency, and maintain reliability. 500,00070146Master Pump Station TSP-Ops Purpose: Restore and/or rehabilitate high-priority wastewater master pump stations within the installed-base of 22 locations through a Technical Support Program (TSP) to maintain compliance and meet operational needs. Rehabilitations include mechanical, electrical, and structural components such as pumps, motors, pipes, wet wells, odor control, containment, structures, lighting, and fencing. End State: Maintain compliance and meet operational demands of wastewater master pump stations. 2,300,00070010Meter Renewal and Replacement Purpose: This multi-year program consists of replacing water meters that have reached the end of their useful life. There are over 60,000 meters in the system that record water usage, and are thus the source of revenue for the utility. In FY18, approximately 10,000 small meters (3/4" - 2") are to be replaced depending on age and service life. Scheduled replacement will be modified as needed to remain consistent with the results of the meter audit. This project also replaces meters that have been identified during the meter audit program as being non-compliant. Method: Fixed term contracts for purchases and replacements with a portion of installation by staff. End State: Remain in compliance with Florida Administrative Code 62-555, Ordinance 201-73, and sustain an accurate measurement of customer water usage for accurate billing. Fiscal Year 2018 CIP Summary ReportsCapital - 32 FY 2018 Fiscal Year 2018 thru 2022 Capital Improvement Program - Project Descriptions by CIP Category Collier County Government Project Title / Description Recom'dProject# Water / Sewer District Capital 4,500,000N414_1 MPS 101.12 Naples Pk Purpose: A multi-year program (FY 2018 - 19) that restores, rehabilitates and replaces aging wastewater collection system within the Naples Park area of the Collier County Water-Sewer District. These are improvements that include extraordinary repairs/replacements which are major replacements made, not to keep the County Water-Sewer District in its normal state of repair, but to extend its useful life beyond that originally estimated. These rehabilitations will help to maintain compliance and to meet operational needs. Program goals include the minimization of infiltration and inflow of storm and ground water into the wastewater collections system by replacing manholes and underground pipes and service laterals, including the renewal of gravity wastewater sewers on a prioritized basis. Wastewater basin design analyses were performed to evaluate existing conditions, assess condition of wastewater assets, identify system deficiencies, and recommend collection system improvements on a bundled basis. FY18 budget will focus on the construction of a new Master Pump Station MPS 101.12 at the corner of 110th Avenue North and 8th Street North. Method: Fixed-term contracts and competitive bids. End State: Maintain compliance and meet operational demands throughout the wastewater system. 300,000N414_8 MPS 107 Reconfig, Quail Creek Purpose: A multi-year project (FY2018 - 20) geared towards capital restoration, rehabilitation, installation of this high-priority wastewater master pump station (MPS) within the installed-base of 22 locations to maintain compliance and meet operational needs. Rehabilitations include mechanical, electrical, and structural components i.e. - pumps, motors, pipes, wet wells, odor control, containment, structures, lighting, and fencing. FY18 budget will address the re-construction of MPS 107 at Immokalee Road, east of I-75 in Quail Creek. Method: Fixed-term contracts and competitive bids. End State: Reconstruction of MPS 107 that will maintain compliance and meet operational demands of wastewater master pump station. 250,000N414_9 MPS 300 Rehab, SCWRF Purpose: This multi-year project (FY2018 - 20) is aimed at replacing aging wastewater Master Pump Station (MPS) 300 at the South County Water Reclamation Facility (SCWRF) and it will help to maintain compliance and meet operational needs. Design analyses were performed to evaluate existing conditions, assess condition of wastewater assets, identify system deficiencies, and recommend collection system improvements. FY18 budget will focus on the reconstruction of MPS 300, that will include new controls, new pumps, piping and major site improvements. Method: Construction contracts based on competitive bids. End State: Maintain compliance and meet operational demands throughout the wastewater basin. 1,000,000N414_15 MPS 300.06 St. Andrews Blvd Purpose: A one year project that provides for capital addition of a wastewater master pump station (MPS) in order to enable the safe operation and maintenance of wastewater pump station that is currently located in the median of St. Andrews Boulevard. This new addition will significantly increase the value and the useful life of the original asset. Method: Fixed-term contracts and competitive bids. End State: Maintain compliance and meet operational demands of wastewater pump stations. 2,000,000N414_17 MPS 301 Rehab, SCWRF Purpose: This is a multi-year project (FY2018 - 19) that will provide capital restoration, rehabilitation, and installation of this high-priority wastewater master pump station within the installed-base of 22 locations to maintain compliance and meet operational needs. This extraordinary rehabilitation will significantly increase the estimated useful life of the master pump station (MPS) beyond its original estimated useful life. Rehabilitations include mechanical, electrical, and structural components such as pumps, motors, pipes, wet wells, odor control, containment, structures, lighting, and fencing. FY18 budget will focus mainly on significantly upgrading this Master Pump Station built 30 years ago, as it handles wastewater flows from the south into the South County Water Reclamation Facility (SCWRF). Method: Fixed-term contracts and competitive bids. End State: Maintain compliance and meet operational demands of wastewater master pump stations. Fiscal Year 2018 CIP Summary ReportsCapital - 33 FY 2018 Fiscal Year 2018 thru 2022 Capital Improvement Program - Project Descriptions by CIP Category Collier County Government Project Title / Description Recom'dProject# Water / Sewer District Capital 500,000N414_6 MPS 302, Reconfig (Santa Barbara Blvd) Purpose: This multi-year project (FY2018 - 19) will reconfigure Master Pump Station (MPS) 302 site and piping to enable flow transfer to MPS 306 in the event that the force main leaving MPS 302 requires maintenance and/or replacement. Traffic safety will also be improved by adding an access off Santa Barbara Boulevard. FY18 budget will provide for the rehabilitation of mechanical, electrical, and structural components that will help maintain compliance and meet operational needs. Additionally, the easement will be expanded, the perimeter wall will be expanded and a new driveway will be added. Method: Fixed term contracts and competitive bids. End State: Maintain compliance and meet operational demands of wastewater master pump stations. 2,500,000N414_2 MPS 305, Group 1; Glades Purpose: This is a multi-year program (FY2018 - 19) that restores, rehabilitates and replaces aging wastewater collection system within the Glades, Lakewood, Gateway Triangle, Flamingo Estates and Naples Industrial Park area of the Collier County Water-Sewer District to maintain compliance and to meet operational needs. The rehabilitation program is specifically targeted to significantly increase the expected useful life of these assets. Program goals include the upgrade of meter pump stations (MPS), significant improvements to the new Western Interconnect Master Pump Station and the construction of MPS 305 force main. Wastewater basin design analyses were performed to evaluate existing conditions, assess condition of wastewater assets, identify system deficiencies, and recommend collection system improvements on a bundled basis. The FY18 budget provides for the relocation of MPS 305 and partial rehabilitation of ten pump stations. Method: Fixed-term contracts and competitive bids. End State: Maintain compliance and meet operational demands throughout the gravity system. 3,000,000N414_14 MPS 306 Group 3 (Bayshore/Thomasson) Purpose: This project is part of a multi-year program that restores, rehabilitates and replaces aging wastewater collection system within the Bayshore Drive/Thomasson Boulevard area of the Collier County Water-Sewer District to maintain compliance and to meet operational needs. This rehabilitation is specifically designed to significantly increase the useful life of the wastewater collection system beyond that originally estimated. Wastewater basin design analyses were performed to evaluate existing conditions, assess condition of wastewater assets, identify system deficiencies, and recommend collection system improvements on a bundled basis. FY18 budget will focus primarily on 10 master pump station (MPS) partial rehabilitations. Method: Design contracts and competitive bids. End State: Maintain compliance and meet operational demands throughout the gravity system. 4,000,00070142MPS 306 MPS Lely Purpose: This project replaces aging wastewater Master Pump Station (MPS) 306 to maintain compliance and to meet operational needs. These extraordinary replacements significantly increase the useful life of the original assets beyond their estimated useful life. Wastewater basin design analyses were performed to evaluate existing conditions, assess condition of wastewater assets, identify system deficiencies, and recommend collection system improvements on a bundled basis. The FY18 budget focus is the replacement of MPS 306. Method: Construction contracts based on competitive bids. End State: Maintain compliance and meet operational demands throughout the wastewater basin. 100,000N414_3 MPS 308 Replace (Shadowlawn-Linwood) Purpose: A multi-year project (FY2018 -20) that will replace aging wastewater Master Pump Station (MPS) 308 to maintain compliance and to meet operational needs. Wastewater basin design analyses were performed to evaluate existing conditions, assess condition of wastewater assets, identify system deficiencies, and recommend collection system improvements on a bundled basis. The primary focus of the current FY18 budget is to provide for the design costs associated with the replacement of MPS 308. Method: Construction contracts based on competitive bids. End State: Maintain compliance and meet operational demands throughout the wastewater 308 basin. 100,000N414_4 MPS 309 (E Naples Middle School) Purpose: A multi-year project (FY2018 -20) that will replace aging wastewater Master Pump Station (MPS) 309 to maintain compliance and to meet operational needs. Wastewater basin design analyses were performed to evaluate existing conditions, assess condition of wastewater assets, identify system deficiencies, and recommend collection system improvements on a bundled basis. The primary focus of the current FY18 budget is to provide for the design costs associated with the replacement of MPS 309. Method: Construction contracts based on competitive bids. End State: Maintain compliance and meet operational demands throughout the wastewater 309 basin. Fiscal Year 2018 CIP Summary ReportsCapital - 34 FY 2018 Fiscal Year 2018 thru 2022 Capital Improvement Program - Project Descriptions by CIP Category Collier County Government Project Title / Description Recom'dProject# Water / Sewer District Capital 100,000N414_19 MPS 321 Force Main to SCWRF Purpose: This one-year project will provide for capital addition of a parallel wastewater force main in order to enable the efficient conveyance of wastewater from existing master pump station (MPS) 321 to the South County Water Reclamation Facility (SCWRF). Specifically, FY18 budget will provide funding for the design costs for an additional force main that will be built along Wildflower Way in Lely Resort to increase the wastewater conveyance from MPS 321 to the SCWRF Method: Fixed-term contracts and competitive bids. End State: Maintain compliance and meet operational demands of wastewater transmission system. 200,000N414_18 MPS 321, Rehab, Lely Purpose: Capital restoration, rehabilitation, installation of the high-priority wastewater master pump station (MPS) within the installed-base of 22 locations to maintain compliance and meet operational needs. The current FY18 budget will provide funding for the rehabilitation of the MPS located at Wildflower Way in Lely Resort which will include mechanical, electrical, and structural components such as pumps, motors, pipes, wet wells, odor control, containment, structures, lighting, and fencing. Method: Fixed-term contracts and competitive bids. End State: Maintain compliance and meet operational demands of wastewater master pump stations. 4,000,000N414_7 Naples Park Gravity Sewer Replacement Purpose: A multi-year program (FY2017-22) that provides replacement of wastewater clay pipe in Naples Park that has reached the end of its useful life. The replacement program constitutes major repairs/replacements made, not to keep the sewer system in its normal state of repair, but to extend its useful life beyond that originally estimated. Replacement rate is approximately 2 miles per year. Method: Utilize RFPs (request for proposals) for design and competitive bidding for installation. End State: Sustain compliance and meet demand with reliability through continued proactive maintenance and replacement of the water distribution system assets. 4,000,00070123Naples Park Water Main Replacement Purpose: A multi-year program (FY2017-22) that provides replacement of water distribution asbestos-cement (AC) pipe in Naples Park that has reached the end of its useful life. The program installs fire hydrants, water mains and other appurtenances that improve fire protection and water quality. Replacement rate is approximately 2 miles per year. Method: Utilize request for proposals (RFP) for design and competitive bidding for installation. End State: Sustain compliance and meet demand with reliability through continued proactive maintenance and replacement of the water distribution system assets. 150,00071055NCRWTP SCADA Support Ops Purpose: Restore and rehabilitate the supervisory control and data acquisition (SCADA) systems for the North County Regional Water Treatment Plant (NCRWTP) through a multi-year Technical Support Program (TSP). This program eliminates obsolescence of existing programmable logic controllers (PLCs), and various instrumentation used to monitor and control plant processes and communicate throughout the plant. Includes the modernization of existing instrumentation to utilize standard protocols in support of asset management initiatives, as well as enhancing communication networks and related hardware. Primary focus of the instrumentation and communications enhancements will be on critical treatment processes. Method: Through fixed-term contracts and competitive bids. End State: Maintain compliance and reliable operation of the treatment process. 600,00071066NCRWTP TSP Operating Purpose: This is a multi-year program that addresses prioritized needs. It provides annual Technical Support Program (TSP) funding for safety related projects, repairs and modifications needed to meet demand and to remain in compliance at the North County Regional Water Treatment Plant (NCRWTP). This facility has been producing approximately 4 billion gallons of treated water annually. The major pieces of equipment needed to be kept operational are: 8 cartridge filters, 6 transfer pumps, 6 high service pumps, 10 treatment skids, 3 concentrate wet well pumps, 4 degasification and odor control trains, and 4 generator sets. Projects in FY18 include the replacement of various piping elements, valves, meters, pumps and other components, chemical process replacement, weatherproofing, rust proofing, corrosion control and coatings, material storage areas, and safety-driven projects. Method: Fixed-term contracts and competitive bids. End State: Meet demand, maintain reliability, ensure safety of plant staff, and remain in compliance. Fiscal Year 2018 CIP Summary ReportsCapital - 35 FY 2018 Fiscal Year 2018 thru 2022 Capital Improvement Program - Project Descriptions by CIP Category Collier County Government Project Title / Description Recom'dProject# Water / Sewer District Capital 1,000,00070149NCWRF Headwork & IQ Pump Station Purpose: Replace existing head works and Irrigation Quality (IQ pump) station that are approximately 30 years old and have reached the end of their useful life's. The project will also include installation of structures, screens, grit removal equipment, flow splitting chambers, IQ Water pumps, electrical controls and a new electrical service. Method: Due to the critical nature of the needed facilities, issue a Request for Proposal (RFP) for a progressive design/build contract for both engineering and construction services. End State: Sustain compliance and meet demand with reliability through the upgrading of critical wastewater treatment components. 300,00070060NCWRF SCADA Support Op Purpose: This is a multi-year program to restore and rehabilitate the Supervisory Control and Data Acquisition (SCADA) systems for the North County Water Reclamation Facility (NCWRF) through a Technical Support Program (TSP) to eliminate obsolescence of existing 25 programmable logic controllers (PLCs) and various instrumentation used to constantly monitor and control the treatment process. This program will increase reliability, sustainability, and operational efficiency. Method: Fixed-term contracts and competitive bids. End State: Maintain compliance and reliability throughout the NCWRF SCADA system. 2,000,000W412_5 Old Lely AC Pipe Rehab Purpose: A multi-year program that provides replacement of water distribution asbestos-cement (AC) pipe in Old Lely that has reached the end of its useful life. The program installs fire hydrants, water mains and other appurtenances that improve fire protection and water quality. Method: Utilize RFPs for design and competitive bidding for installation. End State: Sustain compliance and meet demand with reliability through continued proactive maintenance and replacement of the water distribution system assets. 2,000,00070173Orangetree Compliance Purpose: A multi-year Technical Support Program (TSP) that provides repair of aging utility system assets that have failed throughout the former Orangetree Utility service area. Method: Utilize existing fixed-term underground contracts or competitive bidding for installation and fixed-term engineering services contracts for design. End State: Sustain compliance and meet demand with reliability through continued proactive maintenance and replacement of the potable water and wastewater system assets. 250,000N414_16 PS 302.07 Gravity Sewers, Lely Purpose: This is a one year project that will provide for a capital addition of a wastewater gravity sewer in order to eliminate a wastewater pump station (PS) that is currently located very close to a residential back patio near the Lely Canal. FY18 budget will provide funds to add a new gravity sewer between Rattlesnake Hammock Road and US 41 just west of the Lely canal. Method: Fixed-term contracts and competitive bids. End State: Maintain compliance and meet operational demands of wastewater pump stations. 500,000N414_23 PS Twin Eagle Community Purpose: This one-year project will provide funding for significant improvements that include: capital restoration, rehabilitation, and the installation of a high-priority wastewater community pump station (PS) within Twin Eagles to maintain compliance and meet operational needs. FY18 budget will focus on major construction and rehabilitation work that will take place at the intersection of Bramble Court and 33rd Avenue SW; these include mechanical, electrical, and structural components such as pumps, motors, pipes, wet wells, odor control, containment, structures, lighting, and fencing. Method: Fixed-term contracts and competitive bids. End State: Maintain compliance and meet operational demands of wastewater master pump stations. 4,000,00070167PUD Operations/Collection Facilities Purpose: To design, permit, and construct a centrally located multi-division complex for operations, support, parts distribution and storage. This new facility will provide a central location for shared infrastructure maximizing government resources. The plan for FY18 is to select an architect and complete design, and then move into permitting and construction. The new facility will contain operations and administrative offices, repair workshops, generator storage/testing facilities, SCADA (supervisory control and data acquisition) operations center, SCADA Tower facility, employee common areas (locker rooms, break rooms, work spaces), equipment storage, employee and county vehicle parking. Method: A solicitation for a general contractor for construction would be required through fixed term contracts and competitive bids. End State: To meet current compliance and vertical standards while addressing current and future County space needs while maintaining our level of service standards to our community. Fiscal Year 2018 CIP Summary ReportsCapital - 36 FY 2018 Fiscal Year 2018 thru 2022 Capital Improvement Program - Project Descriptions by CIP Category Collier County Government Project Title / Description Recom'dProject# Water / Sewer District Capital 50,00070014Real Property/Infrastructure Audit Purpose: Ensure that all Collier County Water-Sewer District assets are located within County Utility Easements. Where this is not the case, the County does not have the legal right to construct projects or perform maintenance required to remain in compliance and to serve the District’s customers. Method: Coordinate with appropriate divisions to verify asset locations in existing geographical information system (GIS) layers. Coordinate with Real Property Management to locate easement interest documents, upload into the document management system (DMS), and plot locations in GIS. Compare easement interests with asset locations on GIS to determine if additional easements are required. End State: Confirm all assets reside within appropriate easements, and obtain additional easements where needed. 70,00071056SCADA Compliance - Water Purpose: Multi-year program to acquire, manage and maintain 7 software applications, 4 licenses and 2 support agreements for Supervisory Control and Data Acquisition (SCADA) systems used throughout the Water Division. Method: Through fixed-term contracts and competitive bids. End State: All critical control systems are maintained, compliant and secure to facilitate continued production of quality products. 75,00072541SCADA Compliance - WW Purpose: This is a multi-year program to acquire, manage and maintain 7 software applications, 4 licenses and 2 support agreements for Supervisory Control and Data Acquisition (SCADA) systems used throughout the Wastewater Division. Method: Through fixed-term contracts and competitive bids. End State: All critical control systems are maintained, compliant and secure to facilitate continued production of quality products. 150,00070102SCRWTP SCADA Support - Ops Purpose: Restore and rehabilitate the Supervisory Control and Data Acquisition (SCADA) systems for the South County Regional Water Treatment Plant (SCRWTP) through a multi-year technical support program. This program is needed to eliminate obsolescence of existing programmable logic controllers (PLCs) and various instrumentation used to constantly monitor and control the many processes and communicate throughout the water treatment plant. There are 28 PLCs at this facility with 5 PLCs and associated instrumentation planned to be replaced per year focusing on management and modernizing of the core communication networks and PLC platform. Method: Through fixed-term contracts and competitive bids. End State: Maintain compliance and reliable operations. 450,00071065SCRWTP TSP Operating Purpose: Provide annual Technical Support Program (TSP) funding for safety related projects, repairs and modifications needed to meet demand and to remain in compliance at the South County Regional Water Treatment Plant (SCRWTP). This facility has been producing approximately 5 billion gallons of treated water annually. The major pieces of equipment needed to be kept operational are: 8 cartridge filters, 5 transfer/blend pumps, 10 high service pumps, 10 treatment skids, 8 degasification towers, 4 odor control trains, 6 generator sets, 3 lime reactors, 6 media filters, sludge thickener and belt press. Projects planned for FY18 include the replacement of chemical feed lines and components, check valves, valves, pumps and piping appurtenances, conduits and wiring, waterproofing of various chemical storage tanks and impoundment areas, repair and/or replacement of odor control pumps and components, site improvements repair, and safety-driven projects. This is a multi-year program that addresses ongoing prioritized needs. Method: Fixed-term contracts and competitive bids. End State: Meet demand, maintain reliability, ensure safety of plant staff, and remain in compliance. 1,000,000N414_20 SCWRF IQ Storage Improvements Purpose: A multi-year project (FY2018 - 19) that will provide for the addition of plant piping and valves to optimize the storage of irrigation quality (IQ) water by converting the existing outer rings of the IQ reject water storage to high quality IQ water storage. The capital improvement significantly improves the efficiency of the facility; this project increases the ability of the South County Water Reclamation Facility (SCWRF) to reuse more treated water for irrigation. Method: Fixed-term contracts and competitive bids. End State: Maintain compliance and meet operational demands of wastewater treatment system. Fiscal Year 2018 CIP Summary ReportsCapital - 37 FY 2018 Fiscal Year 2018 thru 2022 Capital Improvement Program - Project Descriptions by CIP Category Collier County Government Project Title / Description Recom'dProject# Water / Sewer District Capital 200,00070061SCWRF SCADA Support Op Purpose: This is a multi-year program to restore and rehabilitate the Supervisory Control and Data Acquisition (SCADA) systems for the South County Water Reclamation Facility (SCWRF) through a Technical Support Program (TSP) to eliminate obsolescence of existing 17 programmable logic controllers (PLCs) and various instrumentation used to constantly monitor and control the treatment process. This program will increase reliability, sustainability, and operational efficiency. Method: Fixed-term contracts and competitive bids. End State: Maintain compliance and reliability throughout the SCWRF SCADA system. 1,800,000N414_21 SCWRF Turbo Blowers Purpose: This multi-year project (FY2018 - 19) will provide funds to replace old air blowers that have reached the end of their useful life with new high-efficiency Turbo blowers that perform the same function using much less power. The primary focus for FY18 budget will be to replace four process air blowers and controls at the South County Water Reclamation Facility (SCWRF); these blowers play a critical role in the wastewater treatment process as they are required to aerate wastewater continuously - 24/7. Method: Fixed-term contracts and competitive bids. End State: Maintain compliance and meet operational demands of wastewater treatment system. 300,00071009Security Upgrades Purpose: Multi-year program to provide both physical and virtual protection of assets that are imbedded in critical compliance-driven operations, including physical access points such as gates, fences, card access and recording devices, as well as cyber threats such as network intrusion and cyber hacking that could directly impact operations. Evaluate and prioritize mitigation to resolve risk and exposure to maintain compliance with Department of Homeland Security requirements for public water supply systems and sustainability of existing levels of service. Planned FY18 projects include replacement and addition of cameras, perimeter fencing improvements and card access in critical infrastructure throughout the Water Division. Method: Internal resources and through fixed-term contracts. End State: Compliant and secure infrastructure. 1,500,000W412_6 Tamiami Wellfield - 2 Wells Purpose: Construct two new Tamiami raw water wells, piping electrical and all appurtenances. Several of the existing Tamiami wells have decreased yield and need to be replaced to meet demand and remain in compliance. Method: Fixed-term contracts. End State: Meet demand and remain in compliance, maintain production capabilities and reliability. 300,00070181Trail Blvd WM Replacement Purpose: Replacement of approximately 4,200 LF of 6” and 8” cast iron water main (WM) that has reached the end of its useful life and is located along Trail Boulevard, between Pine Ridge Road and Banyan Road in Naples. Method: Utilize existing fixed-term underground contracts or competitive bidding for installation and fixed-term engineering services contracts for design. End State: Sustain compliance and meet demand with reliability through continued proactive maintenance and replacement of the water distribution system assets. 5,00070031Utilities Master Plan Purpose: Utilize consultants to assist with updates to the Utilities Master Plan, including coordination with the rate study program, and the annual capital improvement program (CIP) update aimed at responsible system growth, maintenance and preservation. Method: Utilization of request for proposal (RFP) and existing fixed term contracts; retain a qualified consultant to prepare and update master plans, rate study collaboration and CIP validation. End State: The Master Plans, CIP and rate study will remain concurrent with the latest population trends concurrent with Growth Management Department Comprehensive Planning guidance and the needs of all Public Utilities Operating Divisions. 3,000,00070121Utility Billing Customer Serv Software Purpose: Purchase a new billing and customer service software system for water/sewer/IQ (irrigation quality) base and usage charges, pretreatment monthly and application fees, miscellaneous billing for meter tapping, miscellaneous billing for damage to Collier County Water/Sewer District (CCWSD) assets, capital special assessment for water/sewer and miscellaneous billing for financed impact fees. This software system will replace the legacy Harris ICIS water/sewer billing system, the SAP (Collier's accounting system) miscellaneous billing system, and the current capital module within the legacy Special Assessment System. Method: Through request for proposal (RFP) and competitive procurement and fixed term contracts. End State: Comprehensive integrated GIS (geographic information system) based billing system across all product lines. Fiscal Year 2018 CIP Summary ReportsCapital - 38 FY 2018 Fiscal Year 2018 thru 2022 Capital Improvement Program - Project Descriptions by CIP Category Collier County Government Project Title / Description Recom'dProject# Water / Sewer District Capital 100,00070180Warren St Looping Purpose: Removal and replacement of existing asbestos cement (AC) water main piping. The County has identified the removal and replacement of AC water mains along Warren Street from Carolina Avenue to the County’s South Collier County Water Reclamation Facility, approximately 550 feet; and along Carolina Avenue from McCarty Street to Sholtz Street, a distance of approximately 1,450 feet. This project will include the installation of a new water main under the drainage canal south of the South County Water Reclamation Facility's entrance drive to connect two dead end water mains and provide looping capability thereby increasing reliability and improving water quality. Method: Utilize existing fixed-term underground contracts or competitive bidding for installation and fixed-term engineering services contracts for design. End State: Sustain compliance and meet demand with reliability through continued proactive maintenance and replacement of the water distribution system assets. 1,200,00070145Wastewater Pump Stations TSP-Ops Purpose: Restore and/or rehabilitate wastewater pump stations and community pump stations within the installed-base of more than 800 locations. This is a multi-year Technical Support Program (TSP) that includes the renewal of multiple pump stations each year, including mechanical, electrical, and structural components such as pumps, motors, pipes, valves, wet wells, odor control, electrical controls, containment, structures, lighting, and fencing. Method: Fixed-term contracts and competitive bids. End State: Maintain compliance and meet operational demands of wastewater pump stations. 250,00070117Wastewater Remote Sites TSP Purpose: A technical support program (TSP) to optimize the operating efficiency and increase the safety of Public Utilities Department (PUD) Wastewater structures by completing projects relating to rehabilitation, replacement, and optimizations of HVAC (heating, ventilation, air conditioning) Systems, roofs, electrical and fire systems, and other vertical assets existing in the Collections, Irrigation Quality and Master Pump Station Facilities (IQ/MPS) . Also, to implement a program to enhance the utilization and life cycle expectancy of the IQ/MPS by maintaining facilities in satisfactory operating condition by providing systematic inspection, detection, and correction of incipient failures either before they occur or before they develop into major defects. Planned FY18 projects include preventive maintenance inspections of IQ and MPS assets and HVAC replacement and roof replacements at master pump stations. Method: Fixed term services contracts and/or competitive construction bids. End State: An enhanced and fully compliant IQ/MPS that will ensure safety for employees, and extend the life cycle of the facility and its vertical assets. 500,00072505Wastewater Security Systems Purpose: This is a multi-year program to provide both physical and virtual assessments of assets that are imbedded in critical compliance-driven operations, including physical access points such as gates, fences, card access and recording devices, as well as cyber threats such as network intrusion and cyber hacking that could directly impact operations. Evaluate and prioritize mitigation to resolve risk and exposure to maintain compliance with Department of Homeland Security requirements and sustainability of existing levels of service. Planned FY18 projects include replacement and addition of cameras, perimeter fencing improvements and card access in critical infrastructure throughout the Wastewater Division. Method: Internal resources and through fixed-term contracts. End State: Compliant and secure infrastructure. 1,000,00071010Water Distribution System TSP Purpose: A multi-year Technical Support Program (TSP) that provides repair of aging water distribution system assets that have failed throughout the installed base of approximately 960 miles of water piping. Method: Utilize existing fixed-term underground contracts or competitive bidding for installation and fixed-term engineering services contracts for design. End State: Sustain compliance and meet demand with reliability through continued proactive maintenance and replacement of the water distribution system assets. 250,00070034Water Plant Structural Rehab Purpose: Rehabilitate concrete structures at the two Regional Water Treatment Plants. Portions of the plants are aging and their concrete structures have started to exhibit failure. Planned projects in FY18 focus on rehabilitation of structures at the South County Regional Water Treatment Plant. Method: Utilize existing fixed-term contracts for design and contract for construction through fixed-term contracts. End State: Maintain compliance with regulatory requirements and meet demand throughout the water system. Fiscal Year 2018 CIP Summary ReportsCapital - 39 FY 2018 Fiscal Year 2018 thru 2022 Capital Improvement Program - Project Descriptions by CIP Category Collier County Government Project Title / Description Recom'dProject# Water / Sewer District Capital 150,00071063Water Plant-Variable Frequency Drives Purpose: Systematically replace obsolete variable frequency drives (VFDs) at the Water Plants and secondary stations. For FY17, the second of four phases of VFD replacements at the South County Regional Water Treatment Plant will take place. Method: Through fixed-term contracts and competitive bids. End State: Meet demand and remain in compliance, achieve energy efficiencies, and maintain reliability. 6,000,00070148Water Reclamation Facilities TSP-Ops Purpose: A multi-year Technical Support Program (TSP) to provide planned extraordinary repairs and modifications that will significantly extend the useful life of these assets beyond their estimated useful life. The extraordinary repairs are needed to meet demand and remain in compliance at the North and South County Water Reclamation Facilities. These facilities are densely packed on their respective sites and treat approximately 6 billion gallons of wastewater per year. The various treatment processes Modified Ludzack-Ettinger (MLE) and Orbal produce high quality Irrigation Quality (IQ) water. The major pieces of equipment that need to be kept operational include the pretreatment structure with bar screens, grit removal mechanisms and in-fluent channels, MLE aeration basins, Orbal oxidation ditches, clarifiers, effluent filters, and disinfection chambers. There are also mechanical screens and grit chambers, odor control units, blowers, pumps, valves, flow meters, chemical analyzers, chemical storage/distribution systems, IQ water storage ponds, sludge belt presses, and sludge holding tanks. Project needs identified in FY18 include the restoration and rehabilitation of effluent filters, treatment plant structures, return and waste activated sludge pumps and variable frequency drive replacements, meter, valve and sludge holding tank renovations. Method: Fixed-term contracts and competitive bids. End State: Maintain compliance, meet demand, achieve energy efficiencies, and maintain sustainability. 100,00075005Wellfield Management Program Purpose: This is a multi-year program that will be needed throughout the life of the wells which provides consultant engineering support to assist in the monitoring of the aquifer conditions in the existing wellfields (the Tamiami, the North Reverse Osmosis, and the South Reverse Osmosis, with a total of 102 production wells and 24 monitoring wells in the system), and planning for future wellfields. This program provides assistance with review of regulatory changes to water withdrawal permits, regulatory reporting, permit modification and renewal, and hydro geological expertise and support. The Wellfield Management Program also provides engineering design for necessary repairs and rehab projects to maintain a reliable and sustainable raw water supply. Method: Through the existing wellfield contract. End State: Ensure sustainable aquifer yield while planning for future system demand. 100,00070084Wellfield SCADA Support - Operating Purpose: Rehabilitate the Supervisory Control and Data Acquisition systems (SCADA) for the wellfields that supply raw water to the north and south treatment plants through a multi-year Technical Support Program (TSP) to increase reliability and operational efficiency. This program is needed to eliminate obsolescence of existing programmable logic controllers (PLCs) and various instrumentation used to constantly monitor and control the process and communicate with the regional water treatment plants. There are 102 well sites with 72 PLCs and communication networks throughout the wellfield. This program will upgrade communication methods to more consistent and reliable standards. Focus is on communication and control hardware in the South Hawthorne and Lower Tamiami wellfields. Method: Through fixed-term contracts and competitive bids. End State: Maintain compliance and reliability throughout the wellfield SCADA system. 300,00070085Wellfield/Raw W Booster TSP - Ops Purpose: Provide annual Technical Support Program (TSP) funding for repairs and modifications needed to meet demand and to remain in compliance. Projects include ongoing restoration and rehab to maintain water production capabilities at 102 individual production wells (well pump replacement, casing and tubing replacement, metering, electrical and mechanical rehab); within the 41 miles of raw water piping system (valve and main rehab, air release valve installation); and at both raw water booster pump stations (pump and control rehab, building maintenance). Projects for FY18 include one well repair, one well replacement and various process improvements including well pump replacement. Method: Fixed-term contracts and competitive bids. End State: Meet demand and remain in compliance, maintain production capabilities and reliability. Fiscal Year 2018 CIP Summary ReportsCapital - 40 FY 2018 Fiscal Year 2018 thru 2022 Capital Improvement Program - Project Descriptions by CIP Category Collier County Government Project Title / Description Recom'dProject# Water / Sewer District Capital 4,800,00072009Western Interconnect Purpose: Construction of a western interconnect is needed to manage growth in the south service area and to allow for the maintenance of existing force mains. The SCWRF (South County Water Reclamation Facility) does not have space for capacity expansion given current technologies. A series of force mains (FM) and pump station improvements are therefore needed to move wastewater flows from the south service area to the north service area where there is available capacity. Construction will occur in several phases. The main focus of FY18 budget is the construction of Phases 2 and 6 that consists of 2.3 miles of FM between Golden Gate Parkway and Pine Ridge Road and Phase 7; this consists of approximately 2 miles of FM between Pine Ridge Road and Vanderbilt Beach Road. Method: Fixed-term contracts and competitive bids. End State: The ability to reliably shift wastewater flows from the south service area to the north service area while remaining in compliance and meeting demand. 100,000N414_5 Western Interconnect MPS Purpose: This is a multi-year project (FY2018 - 20) that replaces the existing wastewater Western Interconnect Master Pump Station (MPS) to maintain compliance and to meet operational needs. Wastewater basin design analyses were performed to evaluate existing conditions, assess condition of wastewater assets, identify system deficiencies, and recommend collection system improvements on a bundled basis. The primary focus of the current FY18 budget is to provide for the design costs associated with the replacement of Western Interconnect Master Pump Station. Method: Construction contracts based on competitive bids. End State: Maintain compliance and meet operational demands throughout the Western Interconnect Master Pump Station. 100,00073922WW Collections SCADA/Telemetry Purpose: Restore and rehabilitate the Supervisory Control and Data Acquisition (SCADA) systems for the Collections System through a Technical Support Program (TSP) to ensure compliance and provide operational control. SCADA upgrades are being implemented to control variable frequency drives (VFDs) within the wastewater collection system. The program includes repair and replacement of SCADA equipment including transmitter control units (TCUs) and antennas at more than 800 pump stations, and storm-hardening of the central SCADA systems at the Wastewater Collections office on Shirley Street, and providing a resilient mission critical system that maintains compliance of the entire county's wastewater infrastructure. Method: Fixed-term contracts and competitive bids. End State: Maintain compliance and reliability throughout the Collections SCADA system. 550,00070119WW Treatment Plants TSP Purpose: A technical support program (TSP) which performs regular preventative maintenance on wastewater facilities including inspections of roofs, gates, garage doors, fences, HVAC (heating, ventilation, air conditioning), site and fire sprinklers. Method: Fixed term services contracts and/or competitive construction bids. End State: An enhanced and fully compliant waste water department that will extend the life cycle of the facility and its vertical assets. 20,275,20099411X-Transfers/Reserves/Interest - Fd 411 The Interfund Transfers and Reserves are recorded in this project. Transfer to the Water-Sewer Debt Service Fund is for the payment of various growth related water capital improvements paid from State Revolving Fund (SRF) Loans and Bonds. The balance of funds is in Reserves. 3,497,30099412X-Transfers/Reserves/Interest - Fd 412 Reserve for Contingencies and Reserves for Future Capital Projects are recorded in this project. 18,360,20099413X-Transfers/Reserves/Interest - Fd 413 The Interfund Transfers and Reserves are recorded in this project. Transfer to the Water-Sewer Debt Service Fund is for the payment of various growth related wastewater capital improvements paid from State Revolving Fund (SRF) Loans and Bonds. The balance of funds is in Reserves. 9,169,30099414X-Transfers/Reserves/Interest - Fd 414 Reserve for Contingencies and Reserve for Future Capital Projects are recorded in this project. 128,357,000Total Water / Sewer District Capital Fiscal Year 2018 CIP Summary ReportsCapital - 41