Okaloosa County BOCC — July 26, 2016 — Agenda Packet — reading text

Work Orders for BCC Departments/Constitutional Offices 2,117 2,237 1,974 Voice over Internet Protocol (VoIP) Phone Installations 130 41 59 Output County Web Page Visits 2,379,772 1,260,908 695,698 Library Co-Op Web Page Visits* 262,894 194,792 0 Efficiency Ratio of Work Orders to Staff 706 744 658 Effectiveness Percentage of Phone Service Availability 99 99 100 Percentage of Full Web Availability 99.1 99.2 99 Percentage of iSeries (AS/400) Server Availability 99 99.5 100 *The Library Co-Op no longer utilizes the County’s server for their web page. HISTORICAL STAFFING SUMMARY: Category FY14 FY15 FY16 FY17 Full-time Administrative & Support 1 1 1 1 Full-time Management & Professional 4 4 4 4 Total 5 5 5 5 EXPENDITURES: Expenditures Budget FY14 FY15 FY16 FY17 FY16/FY17 Increase/ Category Actual Actual Approved Proposed +/- Decrease Personnel Services $415,387 $438,908 $441,528 $438,114 ($3,414) (0.8%) Operating Expenses $77,626 $63,968 $109,072 $95,313 ($13,759) (12.6%) Capital Outlay $0 $0 $4,000 $0 ($4,000) (100.0%) Total $493,013 $502,876 $554,600 $533,427 ($21,173) (3.8%) Packet Pg. 95 ACCOUNTS: FY15 FY16 FY17 FY16/FY17 Increase/ Code Category Approved Approved Proposed +/- Decrease 10 Salaries & Wages $329,118 $331,614 $330,290 ($1,324) (0.4%) 20 Benefits $100,614 $109,914 $107,824 ($2,090) (1.9%) 31 Professional Services $25,000 $20,000 $5,000 ($15,000) (75.0%) Reduction of consultant services based on historical usage. 40 Travel & Per Diem $3,500 $3,500 $3,500 $0 0.0% 41 Communications Services $29,700 $29,500 $29,500 $0 0.0% 42 Freight & Postage $0 $0 $150 $150 0.0% 44 Rent & Leases $46,057 $0 $0 $0 0.0% 45 Risk Management Allocation $5,189 $8,260 $8,253 ($7) (0.1%) 46 Repair & Maintenance $43,310 $45,532 $46,800 $1,268 2.8% 49 Miscellaneous Charges $0 $950 $950 $0 0.0% 51 Office Supplies $400 $600 $600 $0 0.0% 52 Operating Supplies $396 $670 $500 ($170) (25.4%) 55 Training & Education Expenses $60 $60 $60 $0 0.0% 60 Capital Outlay $0 $4,000 $0 ($4,000) (100.0%) Elimination of capital funding based on the division’s request. TOTAL $583,344 $554,600 $533,427 ($21,173) (3.8%) Packet Pg. 96  BOARD OF COUNTY COMMISSIONERS AGENDA REQUEST DATE: July 26, 2016 TO: Honorable Chairman and Members of the Board FROM: John Hofstad, County Administrator SUBJECT: Telecommunications The attached Telecommunications performance based budget documents Packet Pg. 97  BOARD OF COUNTY COMMISSIONERS OKALOOSA COUNTY, FLORIDA SERVICE AREA: GENERAL GOVERNMENT DEPARTMENT/PROGRAM: INFORMATION TECHNOLOGY/TELECOMMUNICATIONS PROGRAM DESCRIPTION: Provides for the engineering, operation, maintenance and sustainability of the County Fiber Optic Telecommunication Utility System and related critical assets. REVENUE: Telecommunications is funded from agreements with paying customers of the fiber network. MAJOR ACCOMPLISHMENTS LAST YEAR:  Expanded Okaloosa County Fiber Optic Network to Camp Rudder and Plew Lift Station on Eglin AFB.  Completed Eglin fiber buildout to building 9400 on Eglin Reservation resulting in revenue to the county.  Relocated a major fiber optic splice at the north end of the Mid Bay Bridge.  Developed plan to reach Wright Landfill and Hwy 85 North of 7SFG, both requiring Eglin easements.  Relocated fiber at TDD Visitor Center.  Conducted Fiber Optic site surveys for Okaloosa Schools.  Crestview Courthouse telecommunications relocation to include Courthouse, Pagenet, Guardian Ad Litem and Traffic Operations. Extended Sheriff and Judicial networks to OCWS Admin Bldg.  12th Ave Traffic relocation and move to county fiber network.  Extended Conduit System and Fiber Optic Network to the following locations: a. Cavalier Dr. for EMS and OCT b. Del Cerro Well c. West Tank d. Sheriff Admin ring out e. Primrose I-10 crossing PROGRAM GOAL: To provide a reliable and cost effective telecommunications infrastructure. KEY OBJECTIVES: 1. Work with federal, state and local governments to create and facilitate cost-sharing strategies. 2. Increase access to the county fiber optic network by extending critical infrastructure to more partners. 3. Find ways to more effectively operate and maintain outside plant telecommunication infrastructure. 4. Save money, increase level of service and meet current and future voice and data communication needs. 5. Expand utilization by reaching Okaloosa County School District. 6. Continue to leverage dark fiber revenue opportunities. 7. Protect the critical infrastructure from damage. 8. Increase efficiency with technological innovation. 9. Develop and sustain preventative maintenance procedures. Packet Pg. 98 PERFORMANCE MEASURES: Actual Estimated Adopted Performance Measures FY14/15 FY15/16 FY16/17 Sunshine One Locate Tickets (call before you dig) 3,184 4,915 4,900 Miles Located for Sunshine One 98 106 115 Miles of Maintained Conduit 200 217 250 Miles of Maintained Fiber Optic Cable 150 170 185 Output Miles of Fiber Optic Strands 30,000 32,000 34,000 Number of Hand Holes / Pull Boxes 1,300 1,364 1,500 Number of Fiber Optic Splice Enclosures 300 307 327 Number of Physical Locations Reached 120 129 140 Efficiency Weekly Ratio of Sunshine One Locates to Staff (2) 61 95 94 Effectiveness Percentage of late positive responses to ticket 1.9% 0.2% 0.2% EXPENDITURES: Expenditures Budget FY14 FY15 FY16 FY17 FY16/FY17 Increase/ Category Actual Actual Approved Proposed +/- Decrease Operating Expenses $296,833 $168,440 $257,950 $236,200 ($21,750) (8.4%) Capital Outlay $0 $0 $0 $10,000 $10,000 0.0% Total $296,833 $168,440 $257,950 $246,200 ($11,750) (4.6%) Packet Pg. 99 ACCOUNTS: FY15 FY16 FY17 FY16/FY17 Increase/ Code Category Approved Approved Proposed +/- Decrease 31 Professional Services $50,000 $40,000 $40,000 $0 0.0% 34 Contract Services $100,000 $125,000 $100,000 ($25,000) (20.0%) Reduction is due moving more maintenance in house and normal maintenance cycles. 40 Travel & Per Diem $200 $500 $500 $0 0.0% 41 Communications Services $1,500 $2,000 $2,000 $0 0.0% 42 Freight & Postage $200 $200 $200 $0 0.0% 46 Repair & Maintenance $115,000 $50,000 $25,000 ($25,000) (50.0%) Decrease is due to gradual completion of required maintenance for older infrastructure. 49 Miscellaneous Charges $25,000 $25,000 $15,000 ($10,000) (40.0%) Reduction is due to refinement of budget since