Fort Walton Beach — Fiscal Year 2021-22 Adopted Budget — reading text

0.5% DESCRIPTION GIS maintains an accurate and complete spatial geodatabase of City assets using a Geographic Information System (GIS); provides detailed drafting and design drawing packages for sidewalk, water, sewer, stormwater, and reuse projects; and prepares maps for internal use, annexation, Comprehensive Plan amendments and newspaper ads. MISSION Provide high quality, timely, and cost effective drafting, data analysis, mapping, and web application services. Actual YTD thru 03/31 Budget CURRENT GOALS, OBJECTIVES, & METRICS (FY22) 2017-18 2018-19 2019-20 2020-21 2020-21 2021-22 Maintain and Further Develop GIS System to Track & Monitor City Assets Street Data Accurately Entered in GIS - Changes and additions implemented 100% 80% 100% 60% 100% 100% Water Features Accurately Entered in GIS - Changes and additions implemented 100% 115% 100% 30% 100% 100% Sanitary Sewer Features Accurately Entered in GIS - Changes and additions implemented 100% 125% 100% 60% 100% 100% Stormwater Features Accurately Entered in GIS - Changes and additions implemented 100% 80% 100% 50% 100% 100%  Maintain and keep an extensive GIS geodatabase with information from as-builts and utility work orders.  Continue to develop and expand the GIS Web Applications for public use via the internet and for employee use via the intranet. Create construction plans for street, sidewalk, water, sewer and stormwater projects on time. Create other drawings as needed by other  Departments of the City.  Perform extensive street light survey every six (6) months in order to keep an accurate database.  Review site plans and building permits as required for developments within the City. FUTURE GOALS (FY23 & FY24) Continue mapping City infrastructure in GIS with a strong emphasis on disaster preparedness and recovery and performing duties more  efficiently. Conduct annual disaster recovery exercise.  Continue to expand the use of GIS users internally and externally.  Complete 100% of the quality control check of the water and sewer systems GIS data.  Convert hand drawn Water and Sewer references to digital AutoCAD drawings. PRIOR YEAR ACCOMPLISHMENTS (FY21)  Kept the GIS database for the City's water and sewer infrastructure up to date. Performed disaster preparedness exercise.  Continued to improve and add available data to the GIS Web Map Application for all City employees on the City intranet.  Completed 90% of the quality control check of the water and sewer systems GIS data. Completed City of Fort Walton Beach Cemeteries web application which allows citizens to look up the location of a relative interred at Beal  Memorial or Brooks Memorial Cemetery. 137  401 UTILITIES FUND - 1310 WATER OPERATIONS Actual Budget 2020-21 2021-22 % 2017-18 2018-19 2019-20 Adopted Adopted Change Personal Services: 9.00 8.00 8.00 8.00 Number of Funded Employees (FTE's) 9.00 263,441 238,089 272,379 300,907 533-1200 Regular Salaries 379,437 26.10% 162 - 150 161 533-1201 Service Awards - 0.00% 500 - - - 533-1202 Incentive/Merit Pay - 0.00% 6,402 9,231 20,046 12,500 533-1400 Salaries - Overtime 12,500 0.00% 1,286 1,499 1,184 1,850 533-1401 Salaries - Overtime Holiday Worked 1,850 0.00% 15,722 13,648 16,770 17,690 533-2100 FICA Taxes 21,785 23.15% 3,677 3,192 3,922 4,137 533-2101 Medicare 5,095 0.00% 67,144 25,016 19,777 17,360 533-2200 Retirement Contributions 10,401 -40.08% 8,220 6,788 8,741 10,527 533-2204 Retirement Contributions - DC Plan 14,914 41.67% 32,636 44,639 51,687 73,993 533-2300 Dental, Life & Health Insurance 92,068 24.43% 11,591 11,617 9,391 14,543 533-2400 Worker's Compensation 14,282 -1.80% $ 410,781 $ 353,719 $ 404,047 $ 453,668 Total Personal Services $ 552,331 21.75% Operating Expenditures: 12,485 23,803 19,640 24,060 533-3100 Professional Services 23,710 -1.45% - - - 100 533-3400 Other Services 100 0.00% 612 - 80 500 533-4000 Travel and Per Diem 500 0.00% 2,724 3,047 3,493 4,263 533-4100 Communication Services 3,577 -16.09% 188,729 181,394 180,967 180,000 533-4300 Utilities 185,400 3.00% 7,956 7,569 4,575 7,730 533-4610 Maintenance Contracts 10,335 33.70% 3,076 7,313 5,986 5,000 533-4620 Vehicle Repair 5,000 0.00% 806 437 3,720 1,100 533-4630 Equipment Repair 5,100 363.64% 208 645 922 800 533-4640 Building Maintenance 800 0.00% 53,723 620,906 170,649 379,225 533-4680 Plant & System Repair 149,750 -60.51% - - - 950 533-4700 Printing & Binding 950 0.00% 28,252 21,961 23,565 27,070 533-5200 Operating Supplies 29,405 8.63% 11,953 13,007 10,668 11,000 533-5204 Fuel & Oil 11,330 3.00% 718 800 859 1,080 533-5210 Uniform Expense 1,215 12.50% 1,622 880 56 - 533-5231 Computer Hardware/Software - 0.00% 1,990 1,169 3,749 2,000 533-5233 Tools 4,000 100.00% 737 759 795 1,840 533-5234 Safety Supplies/Equipment 2,070 12.50% 6,860 4,935 4,760 6,285 533-5400 Books, Dues & Publications 6,285 0.00% 2,455 1,614 605 3,205 533-5500 Training 4,750 48.21% - - (829) - 533-9905 Capitalized Costs Allocation - Labor - 0.00% - - (366) - 533-9906 Capitalized Costs Allocation - Benefits - 0.00% - - (67) - 533-9907 Capitalized Costs Allocation - Overhead - 0.00% $ 324,906 $ 890,239 $ 434,260 $ 656,208 Total Operating Expenditures $ 444,277 -32.30% Capital Outlay: - - - 20,000 533-6362 Water Well Improvements - -100.00% - - 11,032 - 533-6402 Equipment - 0.00% - 24,278 - - 533-6404 Trucks - 0.00% $ - $ 24,278 $ 11,032 $ 20,000 Total Capital Outlay $ - -100.00% Capital Improvements Program: 2,940 98,251 233,497 - 533-6368 Prior Years Capital Improvement Program - 0.00% $ 2,940 $ 98,251 $ 233,497 $ - Total Capital Improvements Program $ - 0.00% Debt Service - 75,899 78,189 80,302 590-7100 Principal Payments 82,767 3.07% 42,588 40,972 38,756 36,473 591-7200 Interest Expense 34,128 -6.43% $ 42,588 $ 116,871 $ 116,945 $ 116,775 Total Debt Service $ 116,895 0.10% $ 781,216 $ 1,483,358 $ 1,199,781 $ 1,246,651 TOTAL EXPENSES $ 1,113,503 -10.68% 1310 - Water Ops 8/19/2021 11:52 AM