Fort Walton Beach — Fiscal Year 2023-24 Adopted Budget — reading text

12.68% (25,557) (12,996) - - 535-9905 Capitalized Costs Allocation - Labor - 0.00% (8,905) (5,511) - - 535-9906 Capitalized Costs Allocation - Benefits - 0.00% (5,581) (2,109) - - 535-9907 Capitalized Costs Allocation - Overhead - 0.00% $ 2,916,940 $ 3,825,679 $ 3,487,064 $ 3,518,553 Total Operating Expenditures $ 3,633,140 3.26% Capital Outlay: 879 - - - 535-6300 Improvements Other Than Buildings - 0.00% 13,665 1,912 - - 535-6402 Equipment - 0.00% 36,376 - - - 535-6404 Trucks - 0.00% $ 50,920 $ 1,912 $ - $ - Total Capital Outlay $ - 0.00% Capital Improvements Program: 1,833 - - - Refer to CIP for Specific Locations 11,418 98,048 15,920 50,000 535-6361 5032 - Sewer System Grouting & Lining 100,000 100.00% - - 6,543 - 535-6310 5048 - Construction of New Lift Station #2 750,000 100.00% - - - 750,000 535-6310 5062 - Brooks Bridge Sewer Relocation - -100.00% $ 13,250 $ 98,048 $ 22,464 $ 800,000 Total Capital Improvements Program $ 850,000 6.25% 145 1350-Sewer 9/5/2023 8:25 AM  401 UTILITIES FUND - 1350 SEWER COLLECTION & TREATMENT Actual Budget 2022-23 2023-24 % 2019-20 2020-21 2021-22 Adopted Adopted Change Debt Service 952,259 - - 1,015,621 590-7100 Principal Payments 1,037,639 2.17% SRF PS & FS Year 10 of 20 2015 Utility System Revenue Note Year 9 of 18 351,312 330,849 313,649 294,515 591-7200 Interest Expense 286,709 -2.65% SRF PS & FS Year 10 of 20 2015 Utility System Revenue Note Year 9 of 18 5,613 5,613 5,613 - 590-7320 Amortization Discount - Interest Expense - 0.00% $ 1,309,184 $ 336,462 $ 319,262 $ 1,310,136 Total Debt Service $ 1,324,348 1.08% $ 5,011,646 $ 4,960,823 $ 4,597,114 $ 6,508,980 TOTAL EXPENSES $ 6,763,464 3.91% 146 1350-Sewer 9/5/2023 8:25 AM  401 UTILITIES FUND - 1500 NON-DEPARTMENTAL Actual Budget 2022-23 2023-24 % 2019-20 2020-21 2021-22 Adopted Adpoted Change Personnel Services: 9,609 23,235 38,842 10,000 536-1216 Final Leave Pay 10,000 0.00% 20,059 (11,780) 12,536 - 536-1250 Compensated Absences - 0.00% 1,534 (902) 960 - 536-2150 FICA - Compensated Absences - 0.00% - 41,142 - - 533-2299 Acturial Pension Expense - 0.00% $ 31,202 $ 51,695 $ 52,338 $ 10,000 Total Personnel Services $ 10,000 0.00% Operating Expenditures: 37,765 9,247 11,389 - 536-3100 Professional Services - 0.00% - - 2,700 950 536-4911 Holiday Gift Certificates 950 0.00% 29,639 65,674 28,351 - 536-4924 Bad Debt Expense - 0.00% - - - 115,099 536-4995 Contingencies 120,636 4.81% 8,894 8,140 14,830 - 536-4999 Amortization Expense - 0.00% 1,080 6,677 1,830 2,340 536-5231 Computer Hardware/Software 9,515 306.62% 1,847,894 1,743,086 1,691,358 - 536-5900 Depreciation - 0.00% 16,794 16,794 16,794 - 536-5910 Depreciation on Contributed Capital - 0.00% $ 1,942,066 $ 1,849,618 $ 1,767,252 $ 118,389 Total Operating Expenditures $ 131,101 10.74% Capital Outlay - - 3,356 - 536-6420 Computer Hardware/Software - 0.00% $ - $ - $ 3,356 $ 559,033 Total Capital Outlay $ - -100.00% Other Financing Activity (536,014) (248,485) - - 590-9900 Reclassify Capital Outlay - 0.00% 1,155,411 1,319,296 1,345,351 1,220,627 536-9901 Cost Allocation Reimbursement to General Fund 1,264,192 3.57% 675,889 1,238,095 1,229,877 703,751 581-9102 6% Franchise/Right-of-Way Access Fee 723,817 2.85% $ 1,831,300 $ 2,557,391 $ 2,575,228 $ 1,924,378 Total Other Financing Activity $ 1,988,009 3.31% $ 3,804,568 $ 4,458,704 $ 4,398,175 $ 2,611,800 TOTAL EXPENSES $ 2,129,110 -18.48% 40.50 39.50 39.50 39.50 Number of Funded Employees (FTE's) 41.37 4.73% 501,262 506,915 535,860 586,877 Customer Service 671,872 14.48% 1,111,219 604,433 588,414 1,174,862 Utility Services 1,085,692 -7.59% 218,833 263,520 262,827 269,673 GIS 284,831 5.62% 1,199,781 1,129,117 996,681 1,226,866 Water Operations 1,927,376 57.10% 651,525 511,047 462,884 2,612,118 Water Distribution 702,504 -73.11% 5,011,646 4,960,823 4,565,559 6,508,980 Sewer Collection & Treatment 6,763,464 3.91% 3,804,568 4,458,704 4,398,175 2,611,800 Non-Departmental 2,129,110 -18.48% (536,014) (248,485) (252,685) - Reclassification of Capital Outlay - 0.00% $ 11,962,820 $ 12,186,074 $ 11,557,716 $ 14,991,176 TOTAL FUND EXPENSES $ 13,564,849 -9.51% $ (282,633) $ - $ - $ - NET REVENUE / (EXPENSE) $ (0) 0.00% 147 1500-NonDept_401 9/19/2023 1:05 PM  Sanitation Fund The Sanitation Fund encompasses 9.07% of the City’s activities and services and accounts for solid waste and recycling operations that are financed and operated in a manner similar to a private business – where the intent is that the cost (expenses, including depreciation) of providing the services be financed and recovered primarily through user charges. The City provides residential and commercial garbage collection, as well as yard waste and household goods collection. Commercial and residential recycling programs are also available. Revenue Highlights $6.0 Budget 2023-24 $ Change % Change $5.0