Fort Walton Beach Council agenda — 08-16 & 17-2010 Special-FY 10/11 Budget — reading text

Debt Service 517 -7100 Principal Payments 30, 510 100. 00% 2005 Utility System Bond - year 6 of 30 73, 150 85, 428 517 -7200 Interest Expense 84, 511 - 1. 07% 2005 Utility System Bond - year 6 of 30 73,150 $ 85, 428 Total Debt Service $ 115,021 3  401 UTILITIES FUND - 1340 WATER DISTRIBUTION Actual Budget 2009 -10 2010 -11 2006 -07 2007 -08 2008. 09 Adopted City Manager Change Personal Services: 7.00 6.00 6.00 6.00 Number of Funded Employees (FTE's) 5.00 152, 824 203,312 192, 513 200,348 533 -1200 Salaries 129, 654 35.29% 14, 897 13, 213 8,609 9, 000 533 -1400 Salaries - Overtime 9, 000 0.00% 53 100 533 -1401 Salaries - Overtime Holiday Worked 100 0. 00% 10, 344 12, 549 11, 385 11, 135 533 -2100 FICA Taxes 7, 677 31. 06% 2, 419 2, 935 2, 663 2,604 533 -2101 Medicare 1, 796 31. 03% 24, 888 31, 038 33, 191 37,846 533. 2200 Retirement Contributions 21, 944 42. 02% 533 -2204 Retirement Contributions - DC Plan 1, 238 100. 00% 38, 671 45,389 50, 441 61, 774 533 -2300 Dental, Life & Health Insurance 26, 931 56. 40% 13, 032 14, 582 10,241 7,659 533 -2400 Worker's Compensation 6,526 14.79% 257,075 $ 323, 018 $ 309, 094 330,466 Total Personal Services 204,866 38.01 Operating Expenditures: 41 100 533. 3102 Employee Phys & Immun 200 100.00% 608 465 535 1, 275 533 -3400 Contractual Services 15, 495 1115.29% 100 250 380 900 533 -4000 Travel and Per Diem 450 50.00% 938 804 840 653 533 -4100 Communication Services 470 28. 02% 89 533. 4300 Utilities 785 100. 00% 7,215 3, 400 3, 019 2, 500 533 -4620 Vehicle Repair 2,500 0. 00% 6, 802 3, 561 3, 485 4, 250 533 -4630 Equipment Repair 4,250 0. 00% 57, 276 66,521 71, 286 55, 000 533 -4680 Plant & System Repair 60,500 10. 00% 564 699 683 800 533 -4905 Safety Programs /Supply 1, 150 43.75% 194 533 -5100 Office Supplies 4, 130 4,598 4,221 3, 965 533 -5200 Operating Supplies 3, 365 15. 13% 14,624 21, 421 9, 953 11, 675 533 -5204 Fuel & Oil 14, 555 24.67% 1, 200 1, 578 1, 379 1, 510 533. 5210 Uniform Expense 1, 070 29. 14% 4,947 5, 796 6, 824 6, 000 533 -5300 Road Materials & Supplies 7,000 16. 67% 147 174 75 533 -5400 Books, Dues & Publications 60 20.00% 533 -5500 Training 450 100. 00% 18, 208) 1, 164) 14, 015) 533 -9905 Capitalized Costs Allocation - Labor 0. 00% 9,430) 613) 7, 694) 533 -9906 Capitalized Costs Allocation - Benefits 0. 00% 2, 035) 196) 2, 391) 533 -9907 Capitalized Costs Allocation - Overhead 0. 00% 69,073 $ 107,335 $ 78,594 $ 88, 703 Total Operating Expenditures 112, 300 26. 60% Capital Outlay: 533 -6402 Equipment 66,365 100. 00% Replace 1990s Mueller Tapping Machine Water Valve Exercising System FDOT Compliant Solar Powered Arrow Board 12V DC Sump Pump (2) Total Capital Outlay 66, 365 100. 00% 326, 148 $ Total Personal Services, Operating 430,353 $ 387,688 $ 419, 169 Expenditures & Capital Outlay 383, 531 8. 50% Capital Improvements Program: 93, 145 15, 714 87, 860 5056 - Water Line Replacement 0. 00% 1, 258, 000 5367 - Water Meter Replacement 100. 00% 93, 145 $ 15,714 $ 87,860 $ 1, 258,000 Total Capital Improvements Program 100, 00% 6161  4oi UTILITIES FUND - 1340 WATER DISTRIBUTION Actual Budget 2009 -10 2010 -11 % 2006 -07 2007 -08 2008. 09 Adopted City Manager Change Debt Service 9, 823 517. 7100 Principal Payments 67, 331 585.44% Loader /Backhoe - year 7 of 7 2005 Utility System Bond - year 6 of 30 139,512 167, 722 517. 7200 Interest Expense 165, 540 - 1. 30% Loader /Backhoe - year 7 of 7 2005 Utility System Bond - year 6 of 30 139, 512 $ 177,545 Total Debt Service $ 232,871 31. 16% 67  401 UTILITIES FUND - 1350 SEWER COLLECTION & TREATMENT Actual Budget 2009. 10 2010 -11 % 2006 -07 2007 -08 2008 -09 Adopted City Manager Change Personal Services: 12.00 11. 00 11. 00 11. 00 Number of Funded Employees (FTE's) 11.11. 8080 346, 957 337, 502