Loading...
HomeMy WebLinkAboutHandout Tab 1a_23-24 Proposed Operating Budget-Detail updated Updated Tab la - 1/2 CLAY COUNTY UTILITY AUTHORITY 2023/2024 PROPOSED OPERATING BUDGET 2017/2018 2018/2019 2019/2020 2020/2021 2021/2022 Approved Seven Months Annualized Proposed Increase Tab FINAL FINAL FINAL FINAL FINAL 2022/2023 @ 4/30/2023 Estimate 2023/2024 (Decrease) Percent Ref Brief Description Revenues: Last Budget 1 Water Revenue $13,480,830 $14,772,659 $15,575,743 $15,633,038 $17,766,794 $19,537,747 $11,100,186 WkSht $19,028,890 $21,289,458 $1,751,711 8.97% 2a Per Wtr Rev Wkst-Growth-1,440,8.1%Water base&flow charge rate increase 2 Sewer Revenue 24,114,041 25,100,142 26,598,414 27,663,388 29,199,222 30,970,932 17,746,925 WkSht 30,423,300 34,062,233 3,091,301 9.98% 2b Per Sewer Rev Worksheet-Growth-1,440,8.1%base&flow charge rate increase 3 Reclaimed Revenue 3,422,306 4,076,432 4,435,248 4,484,455 5,163,891 5,576,935 3,049,411 WkSht 5,227,562 6,585,636 1,008,701 18.09% 2c Per Reclaim Rev Worksheet-Growth-1,440,8.1%base&flow charge rate increase 4 Alternative Water Supply(AWS)Fees-Existing Customers 550,916 575,433 603,454 635,846 669,580 721,747 410,626 WkSht 703,930 762,920 41,173 5.70% 2a Per Wtr Rev Worksheet-Growth-1,440,3.0%rate increase 4a St.Johns River Water District Fees-Customers at 10/1/21 707,501 645,108 433,180 WkSht 742,594 (645,108) -100.00% 2a Two Year fee,no charges FY 2023/2024 5 Capacity Fees,AWS&DEP Grants 1,546,916 1,784,071 4,852,037 11,207,316 11,471,511 6,208,269 7,523,420 8,897,291 7,642,248 1,433,979 23.10% 3 22.6%estimated of new capacity fees plus 1,015 homes from prior year deferral plus$1.5M grants 6 Miscellaneous Revenue 1,198,677 1,309,953 1,496,475 1,658,718 1,797,611 2,066,040 1,467,489 2,515,695 1,948,323 (117,717) -5.70% 3a Per Worksheet 7 Capital Fund-Const.Dept.Labor,OH,&Equipment 479,979 739,179 407,557 265,507 230,165 545,662 93,365 160,055 526,841 (18,821) -3.45% Estimated Const Dept Expenses below 8 Interest-Restricted 3,746 21,617 286,353 125,171 53 2,335 0 0 2,397 62 2.63% 4 Per Worksheet 9 Interest-Non Restricted 413,142 722,764 820,553 601,009 674,637 584,214 560,670 961,148 853,229 269,015 46.05% 4 Per Worksheet Total Revenues $45,210,553 $49,102,250 $55,075,834 $62,274,448 $67,680,965 $66,858,989 $42,385,271 $68,660,465 $73,673,284 $6,814,295 10.19% Expenditures: Budget Carryforward ($589,667) 10 Debt Service-Interest $1,930,932 $1,984,826 $2,620,858 $2,484,113 $2,285,685 $1,920,828 Bdgt $1,920,828 $2,914,754 $993,926 51.74% 5 Per Worksheet 11 Debt Service-Principal 4,296,795 4,886,210 6,919,315 6,919,568 7,093,418 7,317,257 Bdgt 7,317,257 7,004,373 (312,884) -4.28% 5 Per Worksheet 12 Debt Service-Reserve/Stabilization 149,212 145,995 - - - 5a No current requirement 13 Restricted Interest Income 3,746 21,617 286,353 125,171 53 2,335 Est 0 2,397 62 2.66% 4 Per Worksheet 14 Renewal&Replacement Fund 2,106,362 2,143,605 2,150,452 2,414,518 2,414,518 2,615,873 Bdgt 2,615,873 2,844,521 228,648 8.74% 6 Per Worksheet 15 Environmental Reuse Capital Fund 925,569 928,325 1,024,899 1,046,954 1,046,954 1,211,727 Bdgt 1,211,727 1,396,297 184,570 15.23% 6a Per Worksheet 16 Capacity Fee Fund,AWS&DEP Grants 2,097,832 2,359,504 5,455,491 11,843,162 12,848,592 7,575,124 Est 9,601,221 8,405,168 830,044 10.96% 2&3 22.6%estimated of new capacity fees plus 1,015 homes from prior year deferral plus$1.5M grants 17 Departmental Capital Fund 640,013 2,108,218 618,836 597,925 1,318,067 1,386,263 Bdgt 1,386,263 1,275,500 (110,763) -7.99% 7 Per Worksheet 19 Capital Reserve 3,489,301 3,418,131 2,150,452 2,414,518 2,414,518 1,224,600 Bdgt 1,224,600 2,844,521 1,619,921 132.28% Match of Renewal&Replacement Fund Surplus Transfer To Capital Fund 892,531 1,448,119 2,946,435 1,919,424 2,562,397 3,779,430 - Operation Expenses: 20 Wages $9,248,756 $10,003,974 $10,783,385 $11,178,751 $11,917,982 $13,989,746 $7,454,685 $12,779,461 $15,290,634 $1,300,888 9.30% 11 Per Worksheet-6 New Full-Time positions,1.0%Merit and 2.5%COLA 21 Capitalized Operating Wages (569,540) - - (588,050) (18,510) 3.25% Capitalized Engineering Wages(%of 8 employees) 22 Health Insurance 2,029,743 1,996,434 2,050,486 2,092,455 2,411,135 2,583,745 1,423,007 2,439,441 2,924,776 341,031 13.20% 11 Estimated 9%Health insurance rate increase plus additional employees 23 Retirement 1,039,720 1,211,868 1,210,930 1,254,477 1,377,443 1,369,526 809,512 1,387,734 1,559,819 190,293 13.89% 11 10%of Wages plus misc.costs 24 Licenses,Education,&Uniforms 23,520 99,185 56,317 76,756 130,606 322,835 120,809 207,101 338,639 15,804 4.90% Employee training 25 Payroll Taxes 671,058 750,246 796,503 822,076 885,802 960,124 545,472 935,094 1,097,023 136,899 14.26% 11 7.65%of Wages 26 Workers Compensation ins. 189,824 164,411 168,932 153,434 158,187 189,447 155,889 267,238 199,205 9,758 5.15% 11 Estimate based upon current year audit 27 General Liability&Property Insurance 673,031 674,658 716,411 793,773 873,931 966,619 595,158 1,020,270 1,617,963 651,344 67.38% Increased property to insure+increased rates 28 Transportation Expense 491,505 593,162 549,298 612,963 711,800 723,366 346,289 593,639 732,940 9,574 1.32% In-house labor for repairs,higher gas prices 29 Rental Space 16,103 19,712 22,428 26,158 32,079 49,706 22,427 38,446 62,767 13,061 26.28% 30 Communication Expense-WTP 2,695 2,739 2,683 2,743 2,749 3,000 1,642 2,815 3,300 300 10.00% 31 Communication Expense-WWTP 32,491 34,238 27,091 27,755 24,509 31,100 7,017 12,028 28,000 (3,100) -9.97% 32 Communication Expense-D&C 22,330 20,802 23,082 20,804 21,898 23,000 13,829 23,707 23,000 - 0.00% 33 Communication Expense-Office 241,195 252,145 328,572 315,290 341,965 417,579 209,116 358,485 410,890 (6,689) -1.60% Increase in number of devices,lower SCADA costs 34 Electric&Fuel-W/P 630,518 691,961 671,805 660,194 803,839 744,000 525,427 900,732 1,057,800 313,800 42.18% Per Superintendent 35 Electric&Fuel-L/S 354,642 367,350 359,980 373,210 459,051 440,000 306,801 525,945 540,000 100,000 22.73% Per Superintendent 36 Electric&Fuel-STP 1,217,942 1,221,514 1,262,088 1,295,104 1,543,423 1,466,000 961,273 1,647,896 1,781,000 315,000 21.49% Per Superintendent 37 Electric&Fuel-Office 33,076 35,635 34,525 34,965 45,809 39,374 26,010 44,589 46,066 6,692 17.00% Per Superintendent 38 Chemicals Water 147,442 185,483 185,230 163,487 194,344 233,400 134,995 231,420 245,000 11,600 4.97% Per Superintendent 39 Chemicals Sewer 759,638 745,921 760,125 697,376 847,750 950,000 612,580 1,050,137 998,000 48,000 5.05% Per Superintendent 40 Supplies-Water Treatment Plant 362,002 295,291 391,077 343,922 405,184 418,900 170,353 292,033 465,375 46,475 11.09% Per Superintendent 41 Supplies-Water Field 695,191 831,979 954,448 1,041,989 839,421 1,427,915 940,684 1,612,601 986,800 (441,115) -30.89% Per Dept Heads,decreased meter costs due to Retro Meter Program 42 Supplies-Sewage Treatment Plant 708,938 705,464 638,667 658,898 636,692 668,934 425,507 729,441 696,850 27,916 4.17% Per Superintendent 43 Supplies-Sewage Field 190,346 252,173 256,662 198,505 27,309 17,700 7,474 12,812 17,700 - 0.00% Per Superintendent 44 Supplies-Sewage D&C Lift Stations 652,928 566,353 487,475 516,777 504,501 554,050 414,766 711,027 614,050 60,000 10.83% Per Superintendent 45 Supplies Office 388,815 454,856 476,365 456,729 555,866 619,841 325,831 558,567 666,733 46,892 7.57% 46 Software 737,669 457,668 413,698 552,107 899,219 1,032,152 615,032 1,054,340 1,516,845 484,693 46.96% Increased costs for Billing and Human Resources software 47 Engineering Expenses 406,381 111,145 123,991 308,350 923,923 386,000 226,447 388,195 265,000 (121,000) -31.35% More projects capitalized in FY 24 48 Legal Expenses 233,837 349,871 309,856 393,043 399,883 537,126 314,890 539,811 661,000 123,874 23.06% Per ED,Bachara Const Law$300K,BOS General Counsel$112K,misc 49 Audit Expenses 29,100 35,000 24,500 42,500 23,500 34,000 34,000 34,000 34,500 500 1.47% Per CFO-James Moore&Co audit fees 50 Subcontractors-Water Treatment Plants 406,319 284,592 377,080 446,642 523,216 802,552 389,853 668,320 975,200 172,648 21.51% Per Superintendent 51 Subcontractors-Water Testing 78,150 63,477 89,471 59,380 72,495 108,000 53,137 91,092 143,000 35,000 32.41% Per Superintendent 52 Subcontractors-Water Lines - - - - - - - - Per Superintendent 53 Subcontractors-AWS 105,984 36,953 31,858 48,749 - - - - - - AWS projects in capital costs 54 Subcontractors-Sewage Treatment Plant 459,566 351,003 444,969 374,219 498,341 873,929 404,714 693,796 1,562,500 688,571 78.79% Per Superintendent 55 Subcontractors-Sewage Testing 117,178 133,007 155,292 150,752 168,020 190,500 85,510 146,589 207,000 16,500 8.66% Per Superintendent 56 Subcontractors-Trash Service 69,754 76,768 89,378 109,819 113,145 123,119 81,485 139,688 157,022 33,903 27.54% Per Superintendent-Trash included here 57 Subcontractors-Sewage D&C Lines 331,910 102,008 109,633 453,182 - - - - - - Combined D&C New install water&sewer 58 Subcontractors-Sewage Lift Stations 335,942 175,155 195,849 207,705 238,272 235,000 125,214 214,653 237,000 2,000 0.85% Per Superintendent 59 Subcontractors General 293,252 593,673 880,095 838,453 905,219 3,820,283 633,252 1,085,575 1,741,151 (2,079,132) -54.42% Admin$315K,IT$305K,SCADA$60K,Environmental Compliance$212K Tab la-1/2 Updated Tab la - 2/2 CLAY COUNTY UTILITY AUTHORITY 2023/2024 PROPOSED OPERATING BUDGET 2017/2018 2018/2019 2019/2020 2020/2021 2021/2022 Approved Seven Months Annualized Proposed Increase Tab FINAL FINAL FINAL FINAL FINAL 2022/2023 @ 4/30/2023 Estimate 2023/2024 (Decrease) Percent Ref Brief Description 60 Sludge Removal&Treatment 1,858,187 1,778,259 1,723,236 2,137,068 2,287,833 2,684,753 1,556,727 2,668,676 2,805,750 120,997 4.51% Per Superintendent 61 Bad Debt Expenses 35,228 26,189 41,827 (9,555) 25,705 500 (3,485) 26 500 - 0.00% Per CFO 62 Miscellaneous (22,885) 154,769 138,395 110,249 236,515 565,076 136,428 233,876 460,981 (104,095) -18.42% Per Department Heads 63 Contingency - - - - - 1,039,583 - - 1,035,810 (3,773) -0.36% Authorized per Enabling Legislation,pg.18"margin of safety"we use 5%Of Operating Expenses excluding wages 64 Board Of Directors Compensation 47,107 40,171 45,670 52,194 52,194 52,194 30,136 51,662 52,194 0 0.00% 24 Payments @$310.68=$7,456.32 times 7 Supervisors=$52,194 65 Due in Lieu of Taxes 1,845,421 1,977,716 2,097,421 2,150,140 2,345,846 2,523,853 1,435,343 2,460,589 2,787,180 263,327 10.43% 4.5%ofrecurringWater,WastewaterandReclaimRevenue Total Operations Expense $28,191,549 $28,924,978 $30,506,784 $32,243,588 $35,466,597 $43,648,987 $22,675,234 $38,853,544 $46,458,912 $2,809,925 6.44% Construction Department Expenses: 66 Wages $144,519 $297,427 $127,494 $48,302 $32,486 $176,342 $5,161 $8,847 $156,166 ($20,176) -11.44% 11 PayrollWorksheet 67 Health Insurance 47,124 75,712 32,500 9,520 7,777 46,857 1,425 2,443 39,012 (7,845) -16.74% 11 Payroll Worksheet 68 Retirement 17,389 33,562 15,604 5,840 5,442 21,713 1,146 1,964 19,956 (1,757) -8.09% 11 10%ofWages-PerWorksheet 69 Payroll Taxes 23,766 21,527 9,339 3,573 2,422 - 372 637 14,205 14,205 11 7.65%ofWages-PerWorksheet 70 Workmen's'Compensation Insurance 7,370 10,769 3,097 697 807 15,282 174 298 4,727 (10,555) -69.07% 11 Per Payroll Worksheet 71 Property/Liability Insurance 41,702 43,063 45,728 50,666 56,082 6,216 37,989 65,124 90,387 84,171 1354.10% 72 Communication 54,000 (54,000) -100.00% Accounted for in Line 33 above 73 Equipment Fuel,Repairs&Maintenance 56,572 130,492 67,056 46,839 39,510 30,000 8,537 14,635 20,000 (10,000) -33.33% 74 Field Supplies&Small Tools 20,431 4,612 3,869 4,744 8,733 12,700 4,980 8,538 12,700 - 0.00% 75 Office Supplies 609 995 - - 146 250 43 73 250 - 0.00% 76 Material&Subcontractors 3,029 978 327 4,981 170 2,100 - - 2,100 - 0.00% 77 Miscellaneous Expenses&Employee Training 13,083 19,711 15,929 21,042 35,620 30,484 19,192 32,901 28,384 (2,100) -6.89% 78 Contingency Reserve - - - - - 45,333 - - 34,570 (10,763) -23.74% 9%of Construction Operating Exp&Depreciation 79 Depreciation 104,385 100,331 86,614 69,303 40,970 104,385 14,346 24,593 104,385 - 0.00% Per CFO Total Construction Department Costs 479,979 739,179 407,557 265,507 230,165 545,662 93,365 160,055 526,841 (18,821) -3.45% Reserve for Cash Balance 9/30 - - Total Expenditures $45,203,821 $49,108,707 $55,087,432 $62,274,448 $67,680,965 $66,858,989 $22,768,599 $68,070,798 $73,673,284 $6,814,295 10.19% Tab 1 a-2/2