The URL can be used to link to this page

OUA Annual Budget FY 2021-22s�isreo29 Okeechobee Utility Authority FY22 Budget Table of Contents Tab A f•7 C n E F G H J K � C � FY22 t Document A-1 A-2 to A-3 A-4 to A-7 B-1 6-2 B-3 to B-4 C-1 C-2 C3 C-4 to C-17 C-18 to C-19 D-1 D-2 E-1 F-1 G-1 H-1 J-1 K-1 K-2 K3 L-1 L-2 N-1 O-i R-1 Significant Budgetary Assumptions Notes to the Budget Summary of Sources & Uses Funds Statement Budget Summary of Sources & Uses Funds Statement Notes to Revenue Summary Revenue Summary Revenue Detail Notes to Operating Expense Summary Expenditures Summary Operating Expense Summary 6y Department Operating Expenses Detail by Department and Account Non Operating Expenditures and Transfers Additional Departmental O&M and Capital Expenditures Five Year Capital Improvement Plan Expenditure Detail (CIP) Analysis of R R& I Fund Transfer (5% Prev FY Sys Oper Rev) Analysis of Emergency Reserve Fund Transfer (Req 30 Days of O&M) Analysis of Operating Reserve Fund Transfer (Strive for 90 Days of 08M) Analysis of Fire Hydrant Fund Analysis of CIP (Capital Improvement) Fund Debt Service Summary Truist Bank (formerly BBB� and SRF Combined Truist Bank (formerly BB&� Debt Service Summary Series 2020 A& 2020 B SRF Debt Service Summary Notes to Labor Costs Projected Labor Costs by Department Projected General In-fill revenue from: WCC, WWCC & Install Fees Projected Fund Balances and 6cpenditures for Capital Projects BudgetRecapforNewspaper FINAL BUDGET 9/15/2021 9:40 AM Okeechobee Utility Authority FY22 Budget Significant Budgetary Assumptions In developing the accompanying annual budget, the following significant assumptions and estimates have been used in the projection of operating revenues and expenses: FY22 water and sewer utility revenue have been projected utilizing OUA's budgeted revenues for 4-7-21 to 9-30-21 and actual revenues for 10-1-20 to 3-31- 21 Water and wastewater utiliry revenue includes the additional revenue from the projected customer infill growth of: Proposed Rate Increase for Water Utiliry Revenue: Proposed Rate Increase for Wastewater Utility Revenue: summary, total operating revenue as 9/13/2021 FY22 0.27% 3.0% 3.0% us years 4.0°/a level by: i ne ciecmc �rr��, cnemicai � rueisituasiuiesei expenses may oe suo�ect ro marKet voianu & have been adjusted to reflect projected changes. Electric percentage change is from FPL. Chemicals and fuels/aasoline/diesel are estimates. Electric (FPL) Services: 3% increase $ 14,643 Chemical Expenses: 5% increase $ 29,213 3.00% Fuels, gasoline & diesel expense: 8.8% increase $ 7,296 8.80% in $'s &% for O&M Expenses, including labor $ 27 related expenses reflect the following: Total for Cost of Living Adjustment: $0 Total cost for Employee Merit Increase: $0 Total cost for Employee Bonus: $47,948 Total cost for Emolovee Health Care: Health Care Cost Per Employ Vlonthly Health Care Cost Per Increase in Base Labor Cost for Employees of a$1.35 gq 99,006 minimum wage adjustment, excluding Christmas bonus Annual Pension Contribution Budget & Rate from Actuaries $244,756 Total labor expense is higher (less) than the previous year budget by: 2.74% �.0�°�a 0.00% 1.50% 0.0% $1.35/hour 9.10% 4.22% A-1 FINAL BUDGET 9/15I2021 9:41 AM Okeechobee Utility Authority FY22 Budget Notes to the Budget Summary of Sources � Uses Funds Statement (Pages A4-A6) A� ( � IGeneral Utility Operating Revenue not includinq incremental revenue from the FY10 & FY11 rate increases shown below: The Incremental Rate Revenue from both the FY10 and FY11 A-4 45 rate increases is shown separately under Other Sources of Funds and is projected to total: Total operating revenues are greater than the previous years o budgeted amount by: 4.0 /o Total Operating Expenses is composed of five departmental A-4 1D totals as is shown in Expenditures Summary C-2 lines 6 through 26. Total operating expenses (including la6or) as presented is $ 212,747 higher than the previous years' budgeted amount by: A-4 I 13 ISenior Debt Service consists Truist series 2020A & series 20206 bank Promissorv Notes. Tab K for the detail for each debt issue. A-4 33 & 34 The remaining capital connection revenue in the amount of: is derived from 25 new water and 12 wastewater capital connection charges that are from projected in-fill. A-4 11 IAs presented, the Budget projects utilization of Rate Stabilization Funds in the amount of: See Tab K pages K-3 for the detail on each indebtedness. (1) Assumes Capital Connection Charges (CCC) and Installation Fees stay at 75°/o discount levels. The FY22 budget at 100% would have $98,802 greater budgeted revenue from in-fill CCC and install fees.. iU 9113/2021 $ 10,249,458 $ 954,763 $ 429,498 $ 7,982,583 2.74°/a $ 1,747,087 $ 20,145 A-2 FINAL BUDGET 9/�5/2021 9:41 AM Okeechobee Utility Authority FY22 Budget Notes to the Budget Summary of Sources & Uses Funds Statement (Pages A4-A6) GE! Total interest income revenue on restricted account balances has been projected based on the extremely low current yields 39 0� qualified public funds accounts and with the expectation that these low yield levels will likely continue through the proposed budget cycle. Restricted revenues are credited to their respective fund A-4 40 balances during the fiscal year. They are detailed in the Other Sources of Funds section of the Budget Summary and for the fiscal year total: $ 15,480 $ 122,865 As presented, the Budget Summary anticipates that the A-4 45 Portion of the projected additional revenue derived from both g g54,763 the FY10 and FY11 rate increases that will be used for current year SRF Debt Service totals: A-4 68 The remaining revenue may be transferred to the Rate g 753,672 Stabilization Fund: As presented the Budget projects utilization of Operating A-4 62 Funds to increase the Emergency Reserve Fund to its $ 7,092 minimum requirement by adding funds in the amount of: A-5 � 114 A-6 163 31 Projected Fund Balances at October 1, 2021 : worksheet in section O row 6 for a detailed analysis of projected balances �iected Net Additions to Fund Balances From Transfers in FY22 is amount represents the expected transfers to the lividual funds as further detailed in the worksheet in tab O. Proposed Capital Improvement Project and Departmental Capital Expenditures for FY22 total: Proposed capital expenditures are found listed on A-6 (rows 123-954).and also on Tab D sheets D-1 and D-2 and Tab O The proposed expenditures are not listed in any order of Total Projected Fund Balances at September 30, 2022 See worksheet in Tab O for a detailed analysis of the proiected balances $ 914,552 $ 11,548,647 A-3 FINAL BUDGET 9/15/2021 9:41 AM FINAL BUDGET 9/15/2021 9:41 AM A B C D E F G H 76 FUNDINGSOURCES: FY228utlge[ 77 Funtl Balance at October 1 2021 Pro�ectetl : 78 Restricted h Bond Covenants/Loan Oacumentr: 79 RR81Puntl(Mustbemaimainecat5'I6ofPnorVearSystemRevenue) 533,143 0� Ca ital Connecfion Funtl-Water 229,070 et Ca ital Connection Fund-Sewer 218,D26 B2 Ca ital Connection Funtl-Sewer 10/20 Plan �evsmc�ea mr wwra os1 657,150 94 Su6-Totai 7 630 989 B5 Desi nated 6 Board Resolutlon: 88 Emerenc ReServeFund�nn�sinem�m��m�a�iaoaayoper�p.� 646,227 89 O eralin ReserveFuntl�s�nwmrsooaysorocer�al 7,932,190 90 Fire H tlrant Funtl 242,033 91 Rate Sta6ilization Fund 1,79J,J30 92 Su6-Total 4,613,774 93 Not Restricted: 94 General O eratin Funds 674,218 95 PTO Acwunt Fund 234,50U 96 FuW�eCIPFundin (Stnvelomainlainatfi%otPnorYear5yslemRevenue� 672,776 97 Suh-Total 1 541 094 98 Total Fund Balance at Octo6er 7, 2027 (Pmjecled� 7,793,857 99 70� Chan es to Fund BalanCe Fmm Tmnsfers Pm ectetl for FV22: 101 Trens(er Into RR81 Fund (nnust te maimainea at svo ai anorvear5ysmm Revenue� 3�253 �pp Transfer into CCC Fund-Water (Bom in-Fili) 10,425 103 Transfer into CCC Fund-Water (fmm 1a/2o Pian) 0 104 Transfer into CCC Fund-Sewer (from in-fill) 9,720 105 Transfer inlo CCC Pund-Sewer 10/20 Plan 0 1�b Transferinto Flre HydrantFund 67,24U 707 Transfer into PTO Account Fund (Net of withdrawals) 0 1 �8 Transfer into Emergency Reserve Fund �m�si be ma�mainee ai so aays oper �p) 7,092 � p9 Transfer Into Operating Reserve Fund �smve m ma�m��n a� so a�y: oro a M) 27,793 ��p TransferinioFuWreCIPFunding�smv�mm�mi�m�is�arp�o.ve�rcrossae.7 (123) � � 7 Transfer in�o Discrelionary Rate Stahilizalion Funds 753,672 � �z T�ansfe� Inlo Future CIP Funtl Earmarketl: 0 113 Transfers into Resincted Accounts from Interest Income 15,480 � �q To1a1 Atltlltions inlo Fund 9alance (From Transfers in PY22) 914,552 115 716 TotaiPund Balances�PraJecma) 0,708,410 777 Fundio Sources for Pm osed ConsWction Pra ect Ex entlitures: � �8 Advanced Meler Infrdslruclure Pmlect (Saulh Flonda Water Management �islricl) 50,000 � �g Ativancetl Meler InfrdsimcWre Pm�ect (loan lo be oblainetl Gom SRF) 2,130,423 12� FDEP GranLs (orSW 5eclion W W Se tic 10 5ewer Pm ecp 4,254,674 ip� F�EPGran[Okee-Tantie 7,200,000 722 F�EP Grant Pine Ridge Park Waslewater 600,000 123 Total Funding Sources from GranLs 8 Loans 8,235,097 724 TOTAL FUNDS AVAILABLE FOR CAP�TAL EXPEN�ITURES 8 Fl1N� BALANCES 16,943,507 i25 A-5 FINAL BU�GET 9/15/2027 9:47 AM FINAL BUDGET 9/15/2021 9:41 AM A 8 C D E F G H 191 Okeechohee Uttlity Autharity 192 FY22 Butlge[ 193 BudgetSummary 9�7]Izo2i 194 �e6t Service Coverage Tests 195 196 Senior Lien Debt Service Covera e Anal sts 110 h Re uirea 197 19B General U�ility Ope2�ing Revenue liine 5 anove) 70 249 458 199 LessTotal O er F� p�ne io anw� 7 902 583 200 Funds needed fmm Rate Stabilization Fund 0 2a1 Net General Utili O eratin Revenue 2,266,875 zaz 203 Total Current Year O eratin Revenue for Senior Lien Covera e Test 2 266 WS 204 205 Seniar Lien �ebt Service 1 747,007 129.8 % zas 207 Remainin General Utili O er Rev After Truist Bank �ebt Service 519 788 20B 209 Sentor Lien Cave2ge 210 FOR SRF 211 JuniorLienOeb[Covera eAnal sis 775%forSRF 72a%forRSF COVERAGE 212 213 Remainin General Utili O er Revenue Afler Truisl Bank Debt Service 519,768 214 Less Senior Lien Covera e Factor at 10 % 774,709 276 I�eremen121 Rele Revenue (mm FYID 6 FY11 am inveases atltletl above 954,763 217 Availahle Revenue for SRF (Junlor Lien) DSC Calculatlon 1,299,042 190.4% 218 221 SRF (Juniar Lien) De6t Service 682 062 222 �ollars required lo satisfy SRP (Junior Lien Coverage) per Boartl Policy oF 120 % 136 572 223 Total Operatlng Funtls requiretl to meet SRF Quntor Ilen) tleh[ coverage retlo 819,435 224 225 A-7 FINAL BU�GET 9/15/2021 9:47 AM Okeechobee Utility Authority FY22 Budget Notes to Revenue Summary FY22 water and sewer utility revenue have been projected utilizing OUA's budgeted revenues for 4-1-21 to 9-30-21 and actual revenues for 10-1-20 to 3-31-21 I:b] � e�e� � � Line 8 to 12 Grand Total Operating Revenue is composed of five classifications of operating income shown in Revenue Summary tab 82 lines 8 through 12. 18 Total Water Utility Revenue 15 Total water utility revenue above includes the ongoing effect from the FY10 rate increase with projected incremental water utility revenue totaling: 16 Also, total water utility revenue includes the ongoing effect from the FY11 rate increase with projected incremental water utility revenue totaling: 29 Total Sewer Utility Revenue 26 Total sewef utility fevenue above includes the ongoing effect from the FY10 rate increase with projected incremental sewer utility revenue totaling: B-3 � 27 �Also, total sewer utility revenue includes the ongoing effect from the FY11 increase with projected incremental sewer utility revenue totaling: 9/13/2021 11,204,221 6,851,513 6.0% 364, 317 3.5% 225,269 4,161, 360 6.0% 225,650 3.5% 139,527 B-3 31 Penalties & Late Char es 128,863 As previously noted, the growth rate in new capital connections from in-fill is projected at approximately: B-1 FINAL BUDGET 9/15/2021 9:41 AM 1 Okeechobee Utility Authority 2 FY22 Budget 3 Revenue Summary 5 6 7 Operatinq Revenue: 8 Total Water Utility Revenue (see B-3 Line 18) 9 Total Sewer Utility Revenue (see B-3 Line 29) 10 Penalties & Late Charges 11 Miscellaneous Revenue 12 Total Other Operating Revenue (see B-3 �ine 3a) 13 Grand Total Operatin4 Revenue (see B-3 Line 15 Non-Operatinq Revenue: 16 Gain/Loss Sale of Fixed Assets 18 Total Restricted Interest (see B-4 �ine 56) 19 Total CCC Revenue (Direct) (see B-4 Line 62) 22 Rate Stabilization Fund Transfer (see B-4 Line 71) 23 Grand Total Non-Operating Revenue (see B-4 Line 72) 24 25 Grants. Loans � CIP Fundinq: 26 Internal Funding for CIP & De artmental Capital Expenditures Internal Funding (Rate Stabilization Fund) for SRF Debt Service + 27 funding for Operating Reserve and for Emergency Reserve Funds 28 External Funding for Construction Projects Zg Total Grents, Loans & CIP Funding (see B-4 Line s0) 3D 3� GRAfVD TOTAL REVEPlUE (see e-a �ine s2) 32 33 FY21 Budget 1 558 � 85,1 18,1 18.E 15,297 19,587 3.D0% 3.00% 9/13/2021 FY22 21 11 :b'S 1 161 87 15 13.550 0 8,235,097 FINAL BUDGET 9/15/2021 9:41 AM A H N O P 1 Okeechobee Utility Authority 9/13I2021 ' ___-- --._._.. _ _ 2 FY22 Budget _. _ _.__ 3 Revenue Detail ___._--_------ 4 FY21 FY22 (9) revenue budget assumes capital connection charges and 5 installation fees will remain at 75°/a discount levels. Budget Budget (2) interest income from restricted funds on page B-4 is 6 inconsequential and is included in opereting interest icome Amount Amount 7 OPERATING REVENUE 8 Water Utility Revenue 5,829,071 6,071,945 9 WaterAGRC Revenue (from in-fll connections) 6,250 0 10 WaterGRCRevenue 17,480 21,912 11 Install Fees Water 6,375 6,625 (1) 12 Private Fire Protection 70,685 81,189 13 Turn ONOfF Fees 47,606 63,551 14 OtherRevenue Water 14,535 16,705 15 Incremental Water Rev From 6.0% Rate Increase in FY-10 349,744 364,317 16 Incremental Water Rev From 3.5% Rate Increase in FY-11 216,259 225,269 17 0 0 18 Total Water Utili Revenue 6,558,005 6,851,513 19 � j 20 Wastewater Utili Revenue 3,640,674 3,760,831 21 Wastewatef AGRC Revenue (fram in-fill connections) 6,000 0 22 Wastewater GRC Revenue 14,646 15,705 23 Install Fees Wastewater 6,120 6,360 (1) 24 Kings Ba Wastewater Maintenance Fee 11,022 10,840 25 Other Revenue Wastewater 2,014 2,447 26 Incremental Wastewater Rev From 6.0% Rate Increase in FY-10 218,440 225,650 27 Incremental Wastewater Rev From 3.5°/a Rate Increase in FY-11 135,069 139,527 29 Total Wastewater Utility Revenue 4,033,985 4,161,360 30 , i 31 Penalties & Late Charges 117,408 128,863 32 � ' �i 33 Miscellaneous Revenue 39,330 42,324 34 � I � 35 Interest Operating Account 25,523 19,619 37 Interest Payroll Account 472 542 38 Total Unrestricted Interest Revenue 25,995 20,161 39 i � --.--I � 40 GRAND TOTAL FROM OPERATING REVENUE 10,774,723 11,204,221 41 � � ' j FINAL BUDGET 9/15/2021 9:41 AM B-3 A H N O P 1 Okeechobee Utility Authority 9113I2021 I 2 FY22 Budge[ 3 Revenue Detail �I 4 FY21 FY22 (1) revenue budget assumes capital connection charges and 5 installation fees will remain at 75% discount levels. Budget Budget 42 NON-OPERATING REVENUE Amount Amount 43 Gain/Loss Sale of Fixed Asset 0 0 44 ' I � — 45 Fire H drant Fund Fees 85,134 87,240 46 I I 47 Interest-Water CCC Fund 0 0(2) 48 Interest-Wastewater CCC Fund 0 0(2) 49 Interest-CCC WWTP Expansion Fund 0 0(2) 50 Interest-RR&I Fundin Required 2,340 2,340 51 Interest-Fire H drant Fund 0 0(2) 52 Interest-Future CIP Funding 0 0(2) 53 Interest-Rate Stabilization Fund & Debt Service Fund 4,739 2,025 54 Interest-Operating Reserve Fund 90 da O&M) accrued 8,325 8,325 55 Interest-Emergency Reserve Fund (30 day O&M) accrued 2,790 2,790 56 Total Restricted Interest 18,194 15,480 57 I I I 58 Water CCC from in-fill 9,650 10,425 (1) 59 Wastewater CCC from in-fill 9,000 9,720 (1) 62 Total Water 8 WW CCC Revenue (Direcq 18,650 20,145 70 71 Internal Funding from Rate Stabilization Fund 0 0 72 GRAND TOTAL NON-OPERATING REVENUE 121,978 122,865 73 i � 74 GRANTS, LOANS & CIP FUNDING �, 75 Internal Funding for CIP Ex enditures 3,343,762 1,184,250I 76 Internal Funding for SRF Debt Service (from Restricted Funds) 0 0 77 Internal Fundin for Departmental Capital Expenditures 946,060 1,229,300 78 External Funding-State Programs 8,371,795 7,035,097 79 External Funding from loans/grants to obtain 6,926,133 1,2D0,000 80 GRAND TOTAL GRANTS & INTERNAL FUNDIfVG 19,587,750 10,648,647 81 ' I 82 GRAND TOTAL SOURCES OF FUNDS 30,484,451 21,975,733 FINAL BUDGET 9/15/2021 9:41 AM B-4 FY22 Budget Notes to Operating Expense Summary: Paqe Line 9/13/2027 C-2 ( 26 �Total Departmental Operating Expense: � $7,982,583 Total Operating expense (including labor) as presented is higher $ 212 �4� I 2 �4% than the previous years budgeted amount by: In the detailed expense listing shown on pages C-4 through C-17, most expense classifications have been assigned a budgetary C-4 to value based on either a specific contract amount or an analysis of �� the current year to date operating expenses. However, several selected O&M expense classifications in each department have been historically subject to market fluctuations. Examples are electric (FPL); chemical; and fuel, gas, diesel and petroleum. Electric (FPL) expenses are assigned a specific budgetary value or A-1 27 an adjusted amount based on a projected rate increase from FPL 3.00% of: A_i Z9 Chemicals are assigned a specific budgetary value and a percent 5.00% chan e based on inflation estimates: Fuel, gas, diesel & general petroleum based commodities have A-1 31 been assigned a specific budgetary value and a percent change 8.80% based on inflation estimates: FINAL BUDGET 9/15/2021 9:42 AM C-1 � � � e Okeechobee Utility Authority FY22 Budget Expenditures Summary dExec. Labor, (ini ✓Exec. 0 & M Administration / 11 Maintenance 0 & M 12 Total Maintenance 13 14 Water Labor 15 Water O & M 16 Total Water Expen 19 Wastewater O & M 20 Total Wastewater E: 21 22 Meter Labor 23 Meter O & M 24 TOWI Meter Reader I 25 26 27 28 Non-Operating Exl 29 Debt Service Interest 30 Amortization Expense 31 Depreciation ExpensE 32 35 36 39 40 � 42 1 for Urqent Care Grand Total Grand Total Service Principal Payme�ts ired Transfers to Restricted Revenue Funds et Amendment #1 ationary Transfers From Restricted Funds � Transfers Grand Total Trensfers GRAND TOTAL EXPENDITURES 44 I NON-CASH AMORTIZATIOPd 8 DEPRECIATION EXPENSE FINAL BUDGET 9/15/2021 9:42 AM C 9113/2021 FY21 FY22 Budget Budget 1,170,981 1,276,484 992,598 1,147,780 2,163,579 2,424,264 1,370,234 1,388,184 1, 047, 350 1, 061,409 2,417,584 2,449,593 602,750 617,335 1,041,085 1,074,750 7,643,835 1,692,085 594,347 605,492 692,150 533,609 1,286,497 1,139,100 228.727 246,761 29,614 30,780 258,341 277,541 7,769,836 7,982,583 394,167 356,854 22,200 12,600 2,660,000 2,700,000 3,076,367 3,069,454 33,166,651 24,688,333 30,484,451 21,975,733 C-2 A B D E L i Okeechobee Utility Authorit I ' --- - -- __Y _ _ ------- ---- -- z FY22 Budget ' I I 9/13/2021 ____ - ---- -- s Operatin Ex ense Summa b De artment ' ' 4 --._..--.._.___--- --- � , s FY21 � FY22 s ' Budget I Budget � De artment ' Amount I, Amount a Summa Labor: 'Administration ' 1,170,981I 1,276,484 s ilNaintenance 1,370,234� 1,388,184 io IWater ' 602,750� 617,335 ii �Wastewater 594,347� 605,492 �z I Meter I 228,7271 246,761 is ' Total Labor 3,967,039': 4,134,256 �a �I l is I I I �s Summa O� M: �Administration 992,598j 1,147,780 n IMaintenance i 1,047,3501 1,061,409 ie !Water 1,041,085; 1,074,750 7s 'Wastewater 692,150' 533,609 zo ;Meter 29,614i 30,780 z� � Total O� M 3,802,797I 3,848,328 zz � � 2s ' � za I � ze Summa De tTotal: IAdministration j 2,163,579� 2,424,264 zs IMaintenance �, 2,417,584 2,449,593 z� �Water 1,643,835� 1,692,085 ze IWastewater i 1,286,497� 1,139,100 zs � Meter 258,341 � 277,549 so j Total Department Ex enses ' 7,769,836� 7,982,583 31 ' I 32 I I 33 ' 34 i I I ss FY22 O eratin Ex ense Bud et hi her than Final FY21, as amended � � 212,747 ss Percent chan e I i � I 2.74% 37 I I 38 I I 3s I 1 FINAL BUDGET 9/15/2021 9:42 AM C-3 A B D E L ao Okeechobee Utility Authority ' ' ! — -- - --... -- a7 FY22 Budget---- ---_ ' ' 9/13/2021 a2 O eratin Ex ense Detail b De artment and Account ' 43 I ' aa ----- �I FY21 I FY22 as Administration Labor. ' I Budget I Budget as Account Mumber Account Descri tion I Amount Amount a� 401-3-513-1100-100 Executive Salaries I, 228,462��, 403,773 aa 401-3-513-1101-100 Su ervisorsalaries I 136,678j 130,655 as 401-3-513-1200-100 'Re ular Salaries I 360,908I 393,251 so 401-3-513-1201-100 �Non- ension admin I 85,256I 0 s� 401-3-513-1202-100 iBonus Pa Admin � 14,788� 0 sz 401-3-513-1300-100 Accrued Pa out PTO cash a ments ', 15,320', 16,708 ss 401-3-513-1400-100 i Overtime I 7,412 j 7,303 sa 401-3-513-1600-100 jAccured Wa es and FICA � 01 0 es 401-3-513-1610-100 �Accrued Benefits & FICA vacation/sick � 0� 0 ss 401-3-513-2100-100 �,FICA � 64,935; 72,804 s� 401-3-513-2200-100 IRetirement i 92,292'. 78,394 sa 401-3-513-2300-100 IHealth Insurance (, 126,000! 134,400 ss 401-3-513-2301-100 'Disabilit Insurance ! 2,605; 2,982 so 401-3-513-2302-100 ILifelnsurance i 3,060� 3,264 si 401-3-513-2400-100 IWorkmens Com ensation i 1,914� 1,598 sz 401-3-513-2500-100 'iUnem lo mentCom ensation � 0� 0 ss 401-3-513-3400-213 I'iUr ent Care Services 27,851 27,851 sa 401-3-513-2400-101 ICOLA Increase � 0� 0 ss 401-3-513-1620-100 IAccrued OPEB I 3,500I 3,500 ss 401-3-513-1201-102 IJanitoriai Services 0� 0 s� 'Em lo ee Bonus I 0 0 sa IHealth ins increase � 0� 0 ss ' I I �o IAdmin Labor Subtotal I 1,170,981 � 1,276,484 �i I I I �z I I � FINAL BUDGET 9/15/2021 9:42 AM C-4 FINAL BUDGET 9/15/2021 9:42 AM C-5 Administration O�IVI: — _. - —__ Account P�umber Account Description 401-3-513-4400-101 Pitney Bowes Post Mach Lease 401-3-513-4400-102 Copier Leases & Usage Costs 401-3-513-4500-200 ' Insurance-Prop, Cas & Gen Liab 401-3-513-4500-201 insurance-Pollution Policy 401-3-513-4500-202 Insurance-Storage Tank Policy 401-3-513-4600-100 R&M Vehicles 401-3-513-4609-100 R&M Building Admin 401-3-513-4611-100 'R&M Equipment 401-3-513-4612-100 'R&M Comp Equipment 401-3-513-4613-100 R&M Comp Software (Springbrk) 401-3-513-4613-101 Comp Sys, HW/SW Upgrades & IT Serv 401-3-513-4613-102 IT Outsourced Services 401-3-513-4615-100 !lawn Service Admin 401-3-513-4700-200 401-3-513-4901-100 401-3-513-4902-200 401-3-513-4902-201 401-3-513-4905-200 401-3-513-4909-100 401-3-513-5100-100 401-3-513-5201-100 401-3-513-5203-100 401-3-513-5207-100 401-3-513-5208-100 401-3-513-5400-100 401-3-513-6400-100 401-3-513-9000-200 401-3-513-4908-100 401-3-513-4907-100 ' Bad Debt Expense Miscellaneous 'O�ce Supplies ', Fuel Gas & Diesel - Vehicles ' Uniforms Tools Supplies Administration Books, Dues and Publications Hurricane Expenditures Loan Cost of Issuance Admin O & M Subtotal �Admin Dept Totals I � I ' FY21 ' Budget ' Amount ' 9.100 1 � FY22 777 1,500 25,000 1,250 9,500 36,796 7,500 10.800 17 1 7,500 1,632 1,500 250 7,500 10,000 15,500 150,000 0 0 147,780 FINAL BUDGET 9/15/2021 9:42 AM C-6 A B D E L 7ss ' FY21 ' FY22 __. _ __. __ -- is� IUlaintenance Labor , Budget_ Budget �sa Account Number Account Descri tion Amount Amount iss 401-4-536-1101-100 ISu ervisor Salaries Maint 76,184', 78,664 �so401-4-536-1200-100 IRe ularSalaries 735,426� 860,162 isi 401-4-536-1201-100 !Non- ension ; 64,8661 0 iez 401-4-536-1201-101 IOn Call ' 92,465' 92,561 isa 401-4-536-1400-100 IOvertime Maint ' 42,032' 41,412 isa 401-4-536-1600-100 iAccured Wa es and FICA Maint ' 0 0 ies 401-4-536-1610-100 IAccrued Benefits & FICA vacation/sick ' 0 0 iss 401-4-536-2100-100 � FICA Maint 73,779I 77,223 �s� 401-4-536-2200-100 ! Retirement Maint 100,670I 78,108 �sa 401-4-536-2300-100 Health Insurance Maint ' 176,400, 176,400 iss401-4-536-2301-100 �Disabili InsuranceMaint 2,824i 3,028 no 401-4-536-2302-100 (Life Insurance Maint 4,2841, 4,284 n� 401-4-536-2400-100 �Workmens Com ensation Maint 44,345� 36,194 n2401-4-536-2500-100 �Unem lo mentCom Maint I 0�, 0 ns 401-4-536-1300-100 �Accrued Pa out PTO cash a ments �, 16,668'; 16,649 na 401-4-536-1202-100 ! Bonus Pa -Maint ' 16,791' 0 i7s 401-4-536-1620-100 iAccrued OPEB Maint ' 3,500i 3,500 176 � m �Maintenance LaborSubtotal 1,370,234', 7,388,784 178 179 180 I � 181 � � 182 � �'� �'�� 783 184 ' '. �..: 185 � I 186 187 ! 188 II 189 I 180 f � � FINAL BUDGET 9/15/2021 9:42 AM C-7 FINAL BUDGET 9/15/2021 9:42 AM C-8 A B D E L zae ' ' Budget --- --- -- — --- ----- zss Maintenance O&M: ' ' Budget Amount zao Account Number Account Descri tion ' Amount zai 401-4-536-5201-100 ', Fuel: Gas, Diesel - Vehicles ' 35,000', 38,080 zaz 401-4-536-5202-100 'Fuel Other Maint ' 7,500'. 8,160 2as 401-4-536-5203-100 Uniforms Maint I 7,000; 7,500 zaa 401-4-536-5206-100 'Meters and Meter Boxes 175,000' 175,000 zas 401-4-536-5207-100 ITools Maint 18,000' 17,500 zas 401-4-536-5207-200 iTools Pum Stations 1,500' 1,250 2a� 401-4-536-5207-300 jTools Air Vac I 500! 500 zaa 401-4-536-5207-400 �ITools Water Dist Maint I 1,000: 750 zas 401-4-536-5207-500 �Tools Sewer Collection Maint ', 750� 500 Zso 401-4-536-5207-600 jTools Kin s Ba Maint 250' 500 zsi 401-4-536-5208-100 �Su lies Maint I 12,500� 17,500 zsz 401-4-536-5208-200 �Su lies Pum Stations � 1,000� 1,250 zss 401-4-536-5208-300 �Su Iies Air Vac � 750i 500 zsa 401-4-536-5208-400 �Su lies Water Dist Maint j 7,500! 7,500 zss 401-4-536-5208-500 �Su lies Sewer Collection Main j 2,500; 2,250 2ss 401-4-536-5208-600 �Su lies Kin s Ba Maint 500�, 250 zs� 401-4-536-5209-200 �Chemicals Pum Stations ; 105,OOOi 94,500 zse 401-4-536-5215-100 I Safe Su lies 15,000 � 15,000 2ss 401-4-536-5400-100 �Books, Dues and Publ Maint i 500� 500 2so401-4-536-6400-100 �Ca italOutla Maint i 7,000� 0 zs� 40'-4-536-9000-100 �Contin enc -Maint i 25,000� 25,000 zsz 401-4-536-9999-100 I Retum To Stock i 0 � 0 263 I zsa IMaintenance O� M Subtotal 1,047,350� � 1,061,409 zss �Maintenance De t Totals 2,417,584I 2,449,593 zs� I � 2fi8 269 II II 270 I I 271 I I 272 I �I � 273 I ( I FINAL BUDGET 9/75/2021 9:42 AM C-9 A B D E L 2�a ! ' FY21 FY22 _._ . _ ---- ----- — ----- --- z�s Water Labor: � I Budget Budget z�s Account Number Account Descri tion ' Amount Amount zn 401-5-533-1101-100 iSu ervisor Salaries SWTP ' 47,792' 49,551 z�a 401-5-533-1101-200 'iSu ervisor Salaries GWTP 20,482', 21,236 z�s 401-5-533-1200-100 �Re ular Salaries SWTP 280,647' 308,790 zao 401-5-533-1200-200 IRe ular Salaries GWTP 37,079', 40,504 zei 401-5-533-1300-100 IAccrued Pa out SWTP i 6,547' 6,606 2az 401-5-533-1300-200 IAccrued Pa out GWTP 0' 0 zea 401-5-533-1201-103 I Part Time Em lo ee SWTP 0' 0 zea 401-5-533-1201-203 � Part Time Em lo ee GWTP � 01 0 2as401-5-533-1202-100 jBonusPa SWTP � 7,095; 0 zas 401-5-533-1202-200 iBonus Pa GWTP ' 756 0 za� 401-5-533-1400-100 jOvertime SWTP j 11,994; 11,817 2aa 401-5-533-1400-200 �Overtime GWTP j 1,888� 1,860 zas 401-5-533-1610-100 IAccured Benefits and FICA SWTP i 0� 0 zso 401-5-533-1610-200 �Accured Benefits and FICA GWTP � 0� 0 zsi 401-5-533-2500-100 I Unem lo ment Com SWTP I OI 0 zsz 4-5- 3-2 0- I nem o ment om ' 01 0 zsa401-5-533-2100-100 �FICASI/VTP � 27,748�i 28,881 zsa 401-5-533-2100-200 �FICA GWTP I 4,545I 4,807 zss401-5-533-2200-100 !RetirementSWTP I 43,858� 34,487 zss 401-5-533-2200-200 ';Retirement GWTP � 4,006� 3,967 2s� 401-5-533-2300-100 jHealth Insurance SWTP � 75,600� 75,600 zse 401-5-533-2300-200 iHealth Insurance GWTP � 8,400i 8,400 zss 401-5-533-2301-100 �Disabili Insurance SWTP � 1,162i 1,238 soo 401-5-533-2301-200 �Disabilit Insurance GWTP i 112; 120 soi 401-5-533-2302-100 ILife Insurance SWTP ' 1,836i 1,836 soz 401-5-533-2302-200 'i Life Insurance GWTP ' 2041 204 soa 401-5-533-2400-100 � Workmens Com SWTP 17,505i 14,414 soa 401-5-533-2400-200 IWorkmens Com GWTP 1,544' 1,268 sos 401-5-533-1600-100 ;Accured Wa es and FICA SWTP I� 01 0 soe 401-5-533-1600-200 Accured Wa es and FICA GWTP I OI 0 so� 401-5-533-1620-100 IAccured OPEB SWTP � 2,100I 2,100 soa 401-5-533-1620-200 IAccured OPEB GWTP � 450� 450 sos �WaterLaborSubtotal I 602,750� 617,335 FINAL BUDGET 9/'15/2021 9:42 AM C-10 FINAL BUDGET 9/15/2021 9:42 AM C-11 Water O & M: Account Number 401-5-533-4909-100 401-5-533-4909-200 401-5-533-4950-100 401-5-533-4950-200 401-5-533-5100-100 401-5-533-5100-200 401-5-533-5201-100 401-5-533-5201-200 401-5-533-5202-100 401-5-533-5202-200 401-5-533-5203-100 401-5-533-5204-200 401-5-533-5207-100 401-5-533-5207-200 401-5-533-5208-100 401-5-533-5208-200 401-5-533-5209-100 401-5-533-5209-200 401-5-533-5209-700 401-5-533-5215-100 401-5-533-5215-200 401-5-533-5400-100 401-5-533-5400-200 401-5-533-6400-100 401-5-533-6400-200 401-5-533-9000-100 Miscellaneous SWTP Miscellaneous GWTP Permits SWTP -0ffice Supplies SWTP 'Office Supplies GWTP ' Fuel: Gas, Diesel - Vehicles S Fuel: Gas, Diesel - Vehicles G ' Fuei Other Equipment SWTP ' Fuel Other Equipment GWTP I Uniforms SWTP IUniforms GWTP �Lab Supplies SWTP �Lab Supplies GWTP ��Tools SWTP ,Tools GWTP Supplies SWTP Supplies GWTP IChemicals SWTP IChemicais GWTP 'Chemicals PRP i, Books, Dues and Pub SWTP !Books, Dues and Pub GWTP Capital Outlay SWTP Capital Outlay GWTP Water O & NI Subt Water Deot Totals Amount 1,250 500 500. 500; 1,500'' 350' 4,000' 500' 8,5001 1,250 1,250 250 2,500 500 ount 1,250 250 250 250 1,250 250 1,500 9,000 750 250 2,250 250 20,OOOj 18,375 01 0 3,5001 2,500 250' 250 500' 250 150j 150 10,000 I 4,000 0� 0 50,000' 50,000 1,041,085i 1,074,750 1.643, 835 'I 1.692.085 FINAL BUDGET 9/15/2021 9:42 AM C-12 A B D E L aoz I FY21 ' _ FY22 —_. .— - -- aos Wastewater Labor: Budget ' Budget aoa Account Number ' Account Descri tion ' Amount ' Amount aos 401-6-535-1101-100 jSu ervisor Salaries WW 69,710I 72,223 aos 401-6-535-1200-100 j Re ular 5alaries WW 328,852', 356,281 ao� 401-6-535-1201-103 ;Part-time Salaries VW1/ ' OI 0 4oe 401-6-535-1201-100 On Call WW wa es ' OI 0 aos 401-6-535-1202-100 �,Bonus Pa WW ' 7,732' 0 aio 401-6-535-1300-100 iAccrued Pa out WW 7,224i 7,296 ai� 401-6-535-1400-100 jOvertime WW 15,393; 75,166 aiz 401-6-535-1600-100 IAccured Wa es and FICA WW ' 0; 0 ais 401-6-535-1610-100 �Accured Benefits and FICA W1N ' 0� 0 ata 401-6-535-2100-100 I FICA WW ' 32,812I 34,499 a�s 401-6-535-2200-100 iRetirement WW 47,046I 36,571 ats 401-6-535-2300-100 jHealth Insurance WW I 67,200I 67,200 ai� 401-6-535-2301-100 �Disabili Insurance WW I 1,200� 1,248 aia 401-6-535-2302-100 �Life Insurance WW 1,632� 1,632 ais 401-6-535-2400-100 �Workmens Com ensation WW ' 13,246'i 11,076 azo 401-6-535-1620-100 IAccured OPEB WW ' 2,300' � 2,300 az� ICOLA Increase-WW 0!: 0 azz IMerit Increase-1NW 0'; 0 azs � Em lo ee Bonus-W1N 0 j 0 aza �Health Insurance Increase-WW ' OI 0 425 I azs 401-6-535-2500-100 jUnem lo ment Com 1NW j OI 0 az� I I a2a I Wastewater Labor Subtotal ' 594,347I � 605,492 azs I ' 430 � I ..�'� 431 ...'� �� . 432 ' 433 434 � '�, ''� 435 i I 436 � I 437 I ' I 438 I 439 I 440 I II ; 441 � ( FINAL BUDGET 9/15/2021 9:42 AM C-13 FINAL BUDGET 9/15/2021 9:42 AM C-14 �stewater O & M: count Number 1-6-535-4616-100 1-6-535-4616-400 1-6-535-4616-500 1-6-535-4616-700 1-6-535-4617-100 1-6-535-4901-100 1-6-535-4909-100 1-6-535-4950-100 1-6-535-4950-200 1-6-535-4950-300 1-6-535-4950-400 1-6-535-4950-500 1-6-535-4950-600 1-6-535-5100-100 1-6-535-5201-100 1-6-535-5202-100 1-6-535-5203-100 1-6-535-5204-100 1-6-535-5207-100 1-6-535-5208-100 1-6-535-5209-100 1-6-535-5209-200 1-6-535-5209-300 1-6-535-5209-400 1-6-535-5209-500 1-6-536-5215-100 Account Descriptfon �Testing and Lab Service WWTP ;Testing and Lab Services ETP ITesting and Lab Services KBTP �iTesting and Lab Services PRP I Residual Management WWTP iEducation WW j Misc VWV I Permits W1N Cemetery Rd �Permits LVTP I Permits Ol7P j Permits ETP �Permits KBTP �Permits PRP �Office Supplies WW � Fuel: Gas, Diesei - Vehicles ; Fuel Other VWV � Uniforms W1N �Lab Supplies WW �Tools WW �Supplies WW IChemicals WWTP �Chemicals LVTP (Chemicals OTTP ',Chemicals ETP iChemicals KBTP 00 iBooks, Dues and Publications 00 Capital Outlay 1NW 00 ;Contingency-WW ;Wastewater O & M Subtotal i Wastewater Deut Totals FY29 Budget Amount , 28,� 1.: 1 1 7 � � 0 Budget Amount OI 22,500 0; 1,250 0' 1,250 0' � 0 0 45,000 0: 2,000 0% 1,500 � 51,500 1,500 1.750 1,1 � � � � 1,250 5,440 9.248 1 FINAL BUDGET 9/15/2021 9:42 AM C-15 1,57: !,625 !.250 A B D E L ssz ' ' FY27 FY22 ssa Nleter Labor: I Budget Budget sa4 Account Number Account Descri tion ' Amount Amount sas 40 -7-513-1 0- 00 ; u ervisor a anes R 54, 76 5,849 sss 4-7-513- 200- 00 i e u ar a anes ,483' 9,039 ss� 401-7-513-1202-100 iBonus Pa � 3,113'i 0 ssa 4--5 3- 300- 00 � ccrue a out ; 2,7 �, 2,74 sss 40 --5 3- 20 - 00 : on ension wa es Oi 0 sao 40 -7-5 3-120 - 0 on- ension wa es custo ia services , 7'� 7,802 sai 401-7-513-1400-100 IOvertime ' 2,225' 2,192 saz 40 -7-5 - 0- 0 I ccure a es an i Oi 0 sas 401-7-513-1610-100 �Accured Benefits and FICA I ��I 0 saa 40 -7-5 3-2 - I j ,927� 3,589 sas 40 -7-5 3- - 0 etirement i 7,727' 4,029 sas 40 -7-5 3- - , ea t nsurance 'i 33,600' 33,600 ea� 40 -7-5 - - I isa i it nsurance � 482', 5 eae 40 -7-5 3- - � i e nsurance � 8 6� 8 6 sas 40 -7-5 - 4 - � or mens om ensation ( 7, 69� 5,485 sso 4-7-5 - - � nem o ment om � 0; ss� I ncrease- eter � 0! 0 552 I erit ncrease- eter � 0��, 0 553 I � 554 �i � sss 401-7-513-1620-100 iAccrued OPEB MR � 1,100' 1,100 ees I Meter Labor Subtotal � 228,727' 246,761 557 � � 558 � I 559 j 560 � I I 561 , I 562 I I �i 563 i ; i 564 'I I ��. 565 ' ! ! 566 I � I 567 �i 568 I 569 i II 570 I � I 571 I � I 572 � � I 573 � I I 574 � � I 575 � FINAL BUDGET 9/15/2021 9:42 AM C-76 A B D E L s�s FY21 ' FY22 sn Meter O& M: ' Budget Budget -- -. .._..--- - - — — — -- s�a Account Number Account Descri tion Amount Amount s�s 401-7-513-3400-209 GPS Trackin ' 1,750 1,500 sao 401-7-513-4618-100 Backflow recalibration fees and re airs 800 0 sai 401-7-513-4000-100 'Travel and Per Diem I 250' 250 saz 401-7-513-4200-100 ' Posta e, Frei ht & Shi in MR 150', 150 sss 401-7-513-4200-100 'SLERS Radio Service Fee MR 8x$9x12 II 864' 900 sea 401-7-513-4100-106 SLERS Tower Maint Fee MR 8x$9x12 ' 0 0 sas 401-7-513-4100-107 SLERS Tower Service Fee 0' 0 eas 401-7-513-4100-108 ISLERS R&M 0' sa� 401-7-513-4600-100 ';R&M Vehicies ! 2,500; 2,750 saa 401-7-513-4611-100 ' R&M Meter Readin E ui ment 3,500, 1,500 ses 0-7-5 3-46 3- 0 � om uter o are ensus � 3,500i 3,870 sso 401-7-513-4618-100 j R&M Meter and BackFlow E ui Testin � 800 � 0 ssi 401-7-513-4901-100 �Education I 500I 500 ssz 401-7-513-5201-100 I Fuel: Gas, Diesei - Vehicles � 8,500I 8,160 ess401-7-513-5203-100 'Uniforms I 7501 1,200 ssa 401-7-513-5207-100 'ITools 500', 850 sss 401-7-513-5208-100 Su lies i 7,750' 1,250 sss 401-7-513-5400-100 !Books, Dues and Publications � 500i 500 ss�401-7-513-6400-100 'Ca italOutla I 0; 0 ssa 401-7-513-6399-100 'i Insect Services 2,500'i 3,000 sss 401-7-513-5215-100 ! Safet I 500 �� 900 soo 401-7-535-6400-100 Ca ital Outla MR I 3,500 so� !IVleter O� M Subtotal � 29,614j 30,780 soz I Meter De t Totals I 258,349 ! 277,541 FINAL BUDGET 9/15/2021 9:42 AM C-17 B C D E F G H 1 Okeechobee Utility Authority 2 FY22 Budget 9/13/2021 3 NON-OPERATING EXPENSES AND TRANSFERS 4 5 FY21 FY22 6 Budge[ 8udget 7 NON-OPERATING EXPENSES: Amoun[ Amount 8 Debt Service Interest Expense: ti SRF 1 Interest Expense 96,720 85,767 12 SRF 2 Interest Expense 0 0 14 Truist Bank 2020A Interest Ex ense 114,229 90,995 15 Truist Bank 20208 Interest Ex ense 183,219 180,093 16 Total 394,167 356,854 17 18 Amortization Expense: 31 Amortize Organizational Costs 9,600 0 32 Amortize Lon -Term Lease 12,600 12,600 33 Total 22,200 12,600 34 35 Depreciation Expense: 2,660,000 2,700,000 36 37 TOTAL NON-OPERATING EXPENSES 3,076,367 3,069,454 38 39 FINAL BUDGET 9/15/2021 9:42 AM C-18 8 C D E F G H 40 NON-OPERATING TRANSFERS: FY2� FY22 41 Required Transfers: 42 Debt Service Principal Payments: 45 SRF 1 Principal 586,143 597,096 46 SRF 2 Principal 0 0 52 Truist Bank 2D20A Principal 1,292,000 1,316,000 53 Truist Bank 2020B Principal 150,000 160,000 54 Total 2,028,143 2,073,096 55 Unrestricted/Restricted Revenue Transfers to Restricted Accts: 56 O eralin Reserve Fund 0 0 57 Restricted Interest to Restricted Accts. 18,194 15,480 58 Ca Conn Fund Water (infll) 9,650 10,425 59 Ca Conn Fund WW (infll) 9,000 9,720 61 Fire H drant Fund 85,134 87,240 62 Emergency Reserve Fund 0 0 63 Total 121,978 122,865 64 72 Discretiona Transfers-From Restricted Funds: 73 Net Transfer to Rate Sta6ilization Fund 440,897 $ 791,688 74 Funds Earmarked for 0 0 75 Future CIP Fundin 0 0 76 Total 440,897 791,688 77 Other Transfers: 78 InternalTransferfor CIP Expenditures & Ca ital Assets 1,319,000 1,184,250 79 Internal Transfer for Departmental Ca ital Expenditures 946,060 1,229,300 80 6cternal Fundin from State 15,297,928 8,235,097 61 Total 17,562,988 10,648,647 82 83 TOTAL NON-OPERATING EXPENSES AND TRANSFERS 23,230,373 16,705,749 FINAL BUDGET 9/15/2021 9:42 AM C-19 A B C D E F G 1 Okeechobee Utili Authority '� �� 9/13/2021 2 FY22 Budget � � �� 3 Proposed Departmental Capital Expenditures � 4 ' ' Operating Capital 5 DEPARTMENTTOTALS 6 ADMINISTRATION 15,500 700,000 7 —� MAINTENANCE 0 125,000 8 I, WATER 4 000 4Q000 9 j WASTEWATER 26,600 364,300 �a i METER 3 500 0 � � I i I TOTALS 49 600 1 229 300 12 __�I Administration � j 13 � � Watermaster lan 175,000 14 I I WasteWatermaster lan 175,000 15 j � Administretion Office Restoration 350,000 16 I 5 rin bmok Online Pa ment Portal 15,500 19 ; 'i 20 �—; Sub Total Administretion 15,500 700,000 2'I Maintenance 27 � Lift Station Rehabilitations NW4; SE7, NW18, SW13 inClUded On SChedule D2 28 New forklik 75,000 29 � 33 Re lace maintenance utili truck $ 50,000 34 I I 35 I � Sub Total Maintenance 0 125,000 36 —� Water 37 I 38 I I 2 Filter valve actuators 30,000 2 panel-view plus HMI (ozone generator 3g I I contrallers) 10,000 40 j' Krebs fittin s ActiFlo H drac clones 4,000 41 Sub Total Water 4,000 40,000 42 � Wastewater 43 � j Clarifier rebuild 227,800 44 I �� Bar Screen Au er re air 7,600 45 �', Re lace retum activated slud e valve 16,000 46 ' Olcee-Tantie Lift Station new um & rails 10,000 47 - Okee-Tantie Ca aci Anal sis re ort 3,000 50 ''��. � Kin 's Ba Lift Station 20,000 51 I Entranceroad avin work 106,500 52 I Sub Total Wastewater 26,600 364,300 53 I Meter 54 � ; E�ra Hand held 3,500 55 I 56 ! Sub Total Meter 3,500 0 D-1 FINAL BUDGET 9/15/2021 9:42 AM N ❑ � Q N P m N O N h 1 Okeechobee Utility Au1 2 FY22 Budget 3 ,4nalvsis of RR�I Fund Funding is required to be maintained at 5% of Previous Year System 5 Operating Revenue. 7 8 FY21 System Operating Revenue (Projected) 9 10 FY22 Funding Required at 5% (Fund Balance Required) 11 12 Fund Balance at September 30, 2022 (Projected) 13 14 Fund Surplus (Deficit) 15 16 Funds to be Transferred Back for SRF Debt Payment 17 18 Remaining Fund Surplus (Deficit) 19 20 � 9/13/2021 $10,774,723 538,736 535,483 (3,253) 0 ($3,253) FINAL BUDGET 9/15/2021 9:42 AM E-1 A 1 Okeechobee Utility Authority 2 FY22 Budget 3 Analysis of Emergency Reserve Fund 4 (Maintained at 30 days of current year System O& M) � 8 FY22 System Operating Expenses (Budgeted) 9 10 FY22 30 Days O& M Expenses (Fund Balance Required) 11 12 Fund Balance at September 30, 2022 (Projected) 13 14 Fund Surplus (Deficit) 15 16 Funds to be Transferred Back for SRF Debt Payment 17 18 Remaining Fund Surplus (deficit) 19 20 � 9/13/2021 $7,982,583 656,103 649,011 (7,092) 0 ($7,092) FINAL BUDGET 9/15/2021 9:43 AM F-1 0 1 Okeechobee Utility Authority 2 FY22 Budget 3 Analysis of Operating Reserve Fund 4 5(Maintain at 90 days expenses of current year System O� M) 6 7 8 FY22 System Operating Expenses (Budgeted) 9 10 FY22 90 Days O& M Expenses 11 12 Fund Balance at September 30, 2022 (Projected) 13 14 Fund Surplus (Shortage) 15 16 Funds to be Transferred Back for SRF Debt Payment 17 18 Remainina Fund Surolus (deficitl 911 312 0 2 1 $7,982,583 1, 968,308 1,940, 515 (27,793) 0 FINAL BUDGET 9/15/2021 9:43 AM G-1 Okeechobee Utility Authority FY22 Budget Analysis of Fire Hydrant Fund The fire hydrant fund receives revenue of $ 0.55 per residential meter per month. Fund Bala�ce at September 30, 2021 (Projected) Budgeted Additional Revenue in FY22 Interest Earnings Added to Fund Balance (Projected) Budgeted Hydrant Repiacement Expenditures in FY22 Projects (TBD) Projected Fire Hydrant Fund Balance at September 30, 2022 9113/2021 $242,033 $87,240 $0 ' ($25,000) $0 $304,273 FINAL BUDGET 9/15/2021 9:43 AM H-1 FINAL BUDGET 9/15I2021 9:43 AM J-1 Okeechobee l)tility /authority Last Updated Debt Senrice Summary osisiizo FYE Truist D/S Sub Total SRF D/S Sub Totai Totai Annual Ending Int_ Prin. Int. Prin. Debt Service ' 9/30/12 811,949 1,005,000 446,067 1,058,847 3,321,863 9/30l13 782,094 1,035,000 424,304 1,080,610 3,321,928 3/15/14 Principal prepayment 6,422,932 9/30/14 751,�70 1,065,000 332,906 920,304 3,069,380 9/30/15 719,455 1,095,000 246;958 754,548 2,815,961 9/30/16 686,831 1,130,000 231,836 769,670 2,818,337 Totais 3,751,419 5,330,000 1,682,071 4,583,978 15,347,468 3/29/17 530,000 3l29/17 Refunded $19,425,000 9/30/17 256,179 5'IQ,000 216,407 785,099 1,767,685 --9<30l-1-8 _247�Q93- 620,0�0 _____20�,666 _ 80D,�40 _1r8S8,599 - 9/30/19 239,492 625,000 '145,980 3,522,237 4,532,709 4/1//20 216,138 0 55,076 286,364 557,578 Truist Bank formerly BB&T 4/1//20 Refunded $16,390,000 9/30/20 158,456 712,000 52,404 289,027 1,211,887 9/30/21 297,448 1,442,000 96,720 586,143 2,422,310 9/30/22 271,087 1,476,000 85,767 597,096 2,429,950 9/30/23 244,143 1,505,000 74,609 608,253 2,432,006 9>30/24 216,616 1,534,000 63,243 618;679 2,433,479 9/30/25 188,506 1,581,000 59,665 631,198 2,452,368 9/30/26 159,029 1,540,000 39,870 642,993 2,381,891 9/30/27 127,254 1,580,000 27,854 655,008 2,390,116 9/30/28 94,556 1,635,000 15,615 667,248 2,412,419 9/30/29 60,885 1,670,000 3,146 338,285 2,072,316 9/30/30 26,445 1,715,000 0 0 1,747,445 Totals 1,844,424 76,39q000 510;892 5,634,870 24,380,186 K-9 '�keechobee Utility Authority --..ebt Service Summary - Truist Bank Debt FYE Truist 2020A Ending Int.1.79% Prin. Refunded $16,390,000 on 4/1/2020 . 9/30/2020 65,693.00 637,000.00 4/7/2021 59,991.85 643,000.00 9/30/2021 54,237.00 649,000.00 A/1/2022 48,428.45 655,000.00 9/30/2022 42,566.20 661,000.00 4/1/2023 36,65025 667,000.00 9/30/2023 30,680.60 673,D00.00 4/1/2024 24,657.25 679,D00.00 _ ____ 9/30/2024 18,58020 685,000.00 4/1/2025 12,449.45 691,000.00 9l30l2025 6,265.00 700,000.00 - 4/1/2026 9/30/2026 4/�/2027 9/30/2027 4/1/2028 9/30/2028 411 /2029 9/30/2029 4/1/2030 9/30/2030 Truist 2020B Int.2.05% Pein. 87,996.25 85,000.00 87,125.00 85,000.00 86,253.75 85,000.00 85,382.50 95,000.00 84,408.75 95,000.00 83,435.00 765,000.00 75,593.75 775,0OO.OD 67,65D_00 785,D00.00 59,603.75 795,000.00 51,455.00 815,000.00 _ ___._.._. _. .------- 43,10125 820,000_00 34,696_25 83�,0OO.OD 26,188.75 840,000.00 i7.578.75 850.000.00 Last Updated 08/37/20 Truist Total Debt Service 70 �:i�Sl 863, 7 01 866,188.75 867,578.75 400,199.25 7,340,000.00 1,444,225.00 9,05D,000.00 18,234,424.25 K-2 Okeechobee Uti7ity Authority Debt Service Summary - SRF Debt FYE SRF # 1 Ending Int 1.86% Prin. 9/30/09 94, 955 1,190 9/30/10 189,876 2,414 9/30/1'I 191,207 246,369 9/30/12 186,683 496,179 9/30/13 177,412 505,45� 3('15/'14 9/30/14 167,966 514,896 9/30/15 158,345 524,518 9/30/16 148,543 534,319 9/30/77 138,559 544,304 Z/12/19 9/30/19 9130/20 9130/21 9/30/22 9/30123 9/30/24 9/30/25 9l30/26 9l30/27 9/30/28 9/30/29 9/30/30 Totals 175,027 564,836 107,472 575,391 96,i20 586,1�3 85,767 597,096 74,609 608,253 63,243 619,619 51,665 631,198 39,870 642,993 27,854 655,008 15,615 667,248 3,146 338,285 0 0 1 SRF#2 Int. 2.3% Prin. 95,151 224,518 222,466 414,686 214,572 422,839 207,717 429,526 197,789 439,461 4,022,441 141,358 336,586 88,614 230,030 83,292 235,351 77,848 240,795 27,954 2,957,401 0 0 9,429,039 1 SRF # 3 Int 9.91% Prin. 0 0 46,564 145,126 53,499 134,536 51,666 133,142 49,111 135,698 2,400,491 23,582 68,822 0 0 0 0 0 0 � _ _---p 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 LastUpdated 0$/31/20 SRF Total Debt Service 415,814 '1,021,132 '�s 1,263,023 1,504,914 1,504,914 6,422,g32 1,253,2'10 1,OOi,506 1,001,506 1,001,506 � 682,862 682,862 682,862 682,862 341,431 Okeechobee Utility Authority FY22 Budget Notes to Labor Costs Page Line L-2 I Z 150 Budgeted Labor costs as presented: The above amount includes labor costs for all positions expected to be utilized in fiscal year. A Cost of Living Allowance has been included in the accompanying Budget A 0% Merit increase has been included in the accompanying Budget totaling: A 1.5% Bonus has been included in the accompanying Budget totaling: The Health Care Cost per employee per month to OUA has been included in the accompanying Budget totaling: Increase in Base Labor Cost for Employees of a$1.35 minimum wage adjustment, excluding Christmas bo�us Total change in Budgeted Labor cost vs. previous year's budget. decrease in the Pension Contribution funding (from 12.4% to 9.1 %) totaling: FINAL BUDGET 9/15/2021 9:43 AM 91131202'I $4,1 $0 $0 $47,948 $8,400 $199,006 167,217 L-1 � w � 0 � m J Q Z LL A B C D E F G H I 1 Okeechobee Utility Authority FY22 Budget � i --_ _ ..__ _-------- 2 Projected General In-Fill Revenue ' j 9/73/2021 3 Approved Rates from Resolution 20-06, Effective October 1, 2020 ' 4 � - I ---- �' � 5 WATER WASTEWATER 6 , � 7 II Capital Connection Charge Revenue 'i �, Projected j �i I Projected ' � Connecttons I '�� '�� Connections �. $ � Added in � Revenue �' ToTal CC �� '�. Addetl in � Revenue Total CC I 9 FY22 I PerCC �I Revenue '. '.... PY22 '�. PerCC Revenue I i � , � �, 10 ' 25 $417.00'� $10,425.00 12 $810.00 $9,720.00' 11 � I �i �-� 12 � � Install Fee Revenue � � 13 I � Revenue Per j Total Install I I j Revenue Per � Total Install 14 � j Residential Mtr I Fee Revenue '�� ' �� Connection � Fee Revenue 15 i 25 _ $265.00�� $6,625.00 �� 12 � _ $530_OOI $6,360.00I 16 � �I � I --� �- 17 � Accrued Garanteed Revenue Charges (AGRC) ; � 8 I I AGRC Per 9 ERC I Total AGRC �I. '. 'i AGRC Per t ERC Total AGRC 19 � Connection �� Revenue �' '��, Connection �2� Revenue 20 Oct-19� 2 � 0.00 '�� 0.00�� 1 ' 0.00 0.00 zi No�-is', z j o.00 o.00' i ' o.00 � o.00� 22 Dec-19j 2 ( 0.00 I 0.00' 1 0.00 � 0.00� 23 Jan-20i 2 � 0.00 -�--j 0.00�'.. ��' 1 ' 0.00 '; 0.001 24 Feb-201 Z 0.00 I 0.00' ' 1 � 0.00 � 0.00;� zs Ma�-zoj z o.00____� o.00' ' � o.00 I o.00l 26 Apr-20I 2 �� 0.00 0.00 ' 1 ' 0.00 � 0.00�i 27 May-20I 2 � 0.00---I O.00I ' 1 0.00 O.00i 28 Jun-20j 2 j 0.00 0.00' 1 0.00 O.00j 29 Jul-20', 2 �' 0.00 0.00��, � 1 �'�. 0.00 0.00� 30 Aug-20; 2 � 0.00 �'� 0.00'.. �'� 1 �'� 0.00 � 0.00 31 Sep-20� 3 0.00 I 0.00'I j 1 0.00 � 0.00� 32 � I � � 33 Totals� 25 $0.00' I 12 I� I, $O.00j 34 � � �; I i � 35 � Statictical Data � '�� ''� ''�� I 36 i � ', �� Water Wastewater � 37 i Projected Num6er of active connectionsl � � 38 I Beginning of previous Fiscal Yearl ' 9505 � 4424 � 39 � Beginning of Fiscal Yearl i 9569 j 4453 � 40 � In-fill Growth rate�'; ', 0.261% I 0.269% � 41 � Average wst per new connection �'�, �� $682 �� $1,340 -� a2 ', I I I I 43 �� AGRC for water was capped at $250.00 effective 10-1-18 i I I I _i.-- 44 �2� AGRC for wastewater was capped at $500.00 effective 10-1-18 I ; ( FINAL BUDGET 9/15/2021 9:43 AM N-1 e' � Okeechobee Utility Authority Budget Summary Fiscal Year October 1, 2021 to Septem6er 30, 2022 REVENUES WATER UTILITY REVENUE WASTEWATER UTILITY REVENUE OTHER GENERAL REVENUE RATE STABILIZATION FUNDS CAPITAL CONNECTION REVENUE CAPITAL ASSET/CAPITAL IMPROVEMENT PROJECTS-INTERNAL FUNDING CAPITAL IMPROVEMENT PROJECTS-GRANT/LOAN FUNDING TOTAL REVENUES EXPENSES (Not Including Depreciation or Amortization) OPERATING EXPENSES-WATER DEPT OPERATING EXPENSES-MAINTENANCE DEPT OPERATING EXPENSES-WASTEWATER DEPT OPERATING EXPENSES-ADMINISTRATIVE DEPT OPERATING EXPENSES-METER READER DEPT DEBT SERVICE-INTEREST PAYMENTS DEBT SERVICE-PRINCIPAL PAYMENTS TRANSFERS & RESTRICTIONS GRANT & LOAN FUNDED CIP EXPENDITURES TOTAL EXPENSES BUDGETED SURPLUS OR (DEFICIT) $ 6,851,513 4,161,360 294, 068 0 20,145 2,413,550 8,235,097 $ 21,975,733 $ 1,692,085 2,449,593 1,139,100 2,424,264 277, 541 356,854 2,073,096 3,328,103 8,235,097 $ 21,975,733 0 FINAL BUDGET 9/15/2021 9:44 AM News - R