Fort Walton Beach — Fiscal Year 2022-23 Adopted Budget — reading text

538-1216 Final Leave Pay 500 0.00% - 3,392 2,267 - 538-1250 Compensated Absences - 0.00% - 258 172 - 538-2150 FICA - Compensated Absences - 0.00% - - 37,512 - 538-2299 Acturial Pension Expense - 0.00% $ - $ 3,650 $ 41,332 $ 500 Total Personnel Services $ 500 0.00% Operating Expenditures: 3,995 11,636 528 - 538-3100 Professional Services - 0.00% - - - 125 538-4911 Holiday Gift Certificates 125 0.00% - 2,842 4,857 - 538-4924 Bad Debt Expense - 0.00% - - - 9,817 538-4995 Contingencies 9,817 0.00% - 720 - 390 538-5231 Computer Hardware/Software 390 0.00% 159,843 201,006 410,092 - 538-5900 Depreciation - 0.00% $ 163,838 $ 216,204 $ 415,477 $ 10,332 Total Operating Expenditures $ 10,332 0.00% Capital Outlay - - - 900 538-6420 Computer Hardware/Software - -100.00% $ - $ - $ - $ 900 Total Capital Outlay $ - -100.00% Other Financing Activity (66,954) (976,211) (87,157) - 590-9900 Reclassify Capital Outlay - 0.00% 168,507 172,214 226,003 229,875 538-9901 Cost Allocation Reimbursement to General Fund 208,037 -9.50% 58,251 60,816 196,228 83,650 581-9102 Transfer to General Fund - Franchise Fee 62,116 -25.74% $ 159,804 $ (743,181) $ 335,074 $ 313,525 Total Other Financing Activity $ 270,153 -13.83% $ 323,642 $ (523,327) $ 791,883 $ 325,257 TOTAL EXPENSES $ 280,985 -13.61% 6.00 6.00 6.00 6.00 Number of Funded Employees (FTE's) 6.00 0.00% 448,860 1,516,735 517,137 1,400,991 Stormwater 815,070 -41.82% 390,596 452,884 791,883 325,257 Non-Departmental 280,985 -13.61% (66,954) (976,211) (87,157) - Reclassification of Capital Outlay - 0.00% $ 772,502 $ 993,409 $ 1,221,863 $ 1,726,249 TOTAL FUND EXPENSES $ 1,096,057 -36.51% $ 146,589 $ 212,531 $ (177,040) $ - NET REVENUE / (EXPENSE) $ 0 0.00% 166 1500-NonDept_405 8/30/2022 7:36 AM  Beal Memorial Cemetery Fund The Beal Memorial Cemetery Perpetual Care Fund encompasses 0.01% of the City’s activities and services and accounts for a portion of revenues from lot, crypt, and niche sales that are being reserved for perpetual care. Cemetery operations are currently funded in the General Fund, but interest earnings on the reserves will be used for maintaining the cemetery once all spaces have been sold. Revenue Highlights $1,600,000 Budget. $1,400,000 …… 2022-23 $ Change % Change $1,200,000 Interest & Other 300 0 0% $1,000,000 Interfund Transfers In 84,697 (300,320) (354.6)% $800,000 $84,997 (300,320) (353.3)% $600,000 $400,000 $200,000 $0 Actual Actual Budget Budget Budget 2018-19 2019-20 2020-21 2021-22 2022-23 Interest & Other Interfund Transfers  Transfers In reflects the transfer of 20% of cemetery lot sales from the General Fund to fund perpetual care, as established by Ordinance 526. Expenditure Highlights $450,000 $400,000 Budget. $350,000 2021-22 …… $ Change % Change Operations & Maintenance 14,919 0 0% $300,000 $250,000 Interfund Transfers 49,680 (300,320) (604.5)% $200,000 Replenish Reserves 20,398 0 0% $150,000 $84,997 (300,320) (353.3)% $100,000 $50,000 $0 Actual Actual Budget Budget Budget 2018-19 2019-20 2020-21 2021-22 2022-23 Operations & Maintenance Interfund Transfers Replenish Reserves  Operations & maintenance includes the annual investment portfolio management fee.  The decrease in interfund transfers is a result funds being allocated in the GF for construction of projects. 167  602 BEAL MEMORIAL CEMETERY CARE FUND Actual Budget 2021-22 2022-23 % 2018-19 2019-20 2020-21 Adopted Adopted Change 284 279 73 300 1500-361-1000 Interest Income 300 0.00% 70,576 66,711 65,718 - 1500-361-2000 Dividend Income - 0.00% (337,562) 210,396 296,601 - 1500-361-3000 Unrealized Gain/(Loss) - 0.00% 396,378 34,869 300,404 - 1500-361-4000 Realized Gain/(Loss) - 0.00% $ 129,676 $ 312,256 $ 662,796 $ 300 Total Interest Income $ 300 0.00% $ 129,676 $ 312,256 $ 662,796 $ 300 TOTAL INTEREST & OTHER REVENUES $ 300 0.00% 32,070 28,676 55,167 35,017 2200-381-0100 Transfer from General Fund 38,400 9.66% $ 32,070 $ 28,676 $ 55,167 $ 35,017 Total Interfund Transfers $ 38,400 9.66% - - - 350,000 1600-389-9100 Appropriation from Fund Balance 46,297 -86.77% $ - $ - $ - $ 350,000 Total Non-Operating Sources $ 46,297 -86.77% $ 32,070 $ 28,676 $ 55,167 $ 385,017 TOTAL TRANSFERS IN $ 84,697 -78.00% $ 161,747 $ 340,932 $ 717,963 $ 385,317 TOTAL FUND REVENUES $ 84,997 -77.94% Operating Expenditures: 15,168 9,877 15,413 14,919 2200-539-3100 Professional Services 14,919 0.00% $ 15,168 $ 9,877 $ 15,413 $ 14,919 Total Operating Expenditures $ 14,919 0.00% Other Financing Activity: - - - 350,000 1600-581-9102 Transfer to General Fund 49,680 -85.81% - - - 20,398 1600-581-9920 Reserve for Future Cemetery Perpetual Care 20,398 0.00% $ - $ - $ - $ 370,398 Total Other Financing Activity $ 70,078 -81.08% $ 15,168 $ 9,877 $ 15,413 $ 385,317 TOTAL FUND EXPENSES $ 84,997 -77.94% $ 146,579 $ 331,056 $