The URL can be used to link to this page

OUA FY23 - Approved Budget8l31/2022 Okeechobee Utility Authority FY23 Budget Table of Contents Tab A L3 C 7 E F G H J K 0 N O R FY23 t Document A-1 A-2 to A3 A-4 to A-7 e-t B-2 B3 to B-4 G1 C-2 C-3 C-4 to C-17 C-18 to C-19 D-t D-2 E-1 F-1 G-1 H-1 J-1 K-1 K-2 K-3 l.-1 L-2 N-t O-1 R-1 Significant Budgetary Assumptions Notes lo the Budget Summary of Sources & Uses Funds Statement Budget Summary of Sources & Uses Funds Statement Notes to Revenue Summary Comparative Revenue Summary Revenue Detail Notes to Operating Expense Summary Comparative Expense Summary Operating Expense Summary by Department Operating Expenses Delail 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 RR&I Fund (Required 5% Prev Fiscal Yr Sys Oper Rev) Analysis of Emergency Reserve Fund Transfer (Req 30 Days of O&M) Analysis of Operating Reserve Fund Transfer (Strive for 60 Days of O&M) Analysis of Fire Hydrant Fund Analysis of CIP (Capital Improvement) Fund Debt Service Summary Truist Bank (formerty BB&T) and SRF Combined Truist Bank (formerly BB&T) 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: Water CCC, WW CCC & Install Fees Projected Fund Balances and Expenditures for Capital Projects BudgetRecapforNewspaper PREIIMINARY BUDGET 9/19/2022 10:25 AM Okeechobee Utility Authority FY23 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 exaenses: FY23 water and sewer utility revenue have been projected utilizing OUA's actual revenues for 10-1-21 to 7-31-22 and budgeted revenues for 8-01-22 to 9- Water and wastewater utility revenue inciudes the additional revenue from the projected customer infill qrowth of: n summary FST revenue as Rate Increase for Revenue: Ievel i he tiectnc (r-N�), chemicai � Fueisic�as�uiesei expenses may be sua�ect to marKet voiam & have been adjusted to refiect projected changes. Electric percentage change is from FPL. Electric (FPLI Services: & diesel �Total change of O&M Expenses, incluc Labor related expenses reflect the following: Total for Cost of Total cost for En Total cost for En Merit Increase: labor FICA Total cost for Employee Health Care: Current Monthly Health Care Cost Per Employee FY23 Monthly Health Care Cost Per Employee Increase in Labor Cost for Employees by $1.00/hr. to meet minimum wage adjustment. Annual Pension Contribution Budget & Rate from Actuaries Total labor expense is hiqher (less) than the previous year I PRELIMINARY BUDGET 9/19/2022 10:25 AM 1 815,123 � $531,000 $123,968 m 8/3112022 FY23 0.26% 3.5% 3.5% 7.0% 16.10°/ 58.70°/ 12.60°/ 10.21 °/ 0.00% 0.00% 1.50°/ 7.1 % $1.0/hour 0.00°/ -0.28% � Okeechobee Utility Authority FY23 Budget Notes to the Budget Summary of Sources & Uses Funds Statement (Pages A4-A6) 8/31 /2022 Page Line A-4 � General Utility Operating Revenue not includinq incremental $ 10,941,659 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 $ 1,020,069 Funds and is projected to total: Total operati�g revenues are greater than the previous year's �.0% $ 777,668 budgeted amount by: Total Operating Expenses is composed of five departmental A-4 10 totals as is shown in Expenditures Summary C-2 lines 6 $ 8,797,708 through 26. Tolal operating expenses (inciuding labor) as presented is �Q Z1% $815,123 higher than the previous years' budgeted amount by: A-4 13 Senior Debt Service consists Truist series 2020A & series $ 1,749,143 20208 bank Promissory Notes. See Tab K for the detail for each debt issue. A-4 33 & 34 The remaining capital connection revenue in the amount of: $ 20,831 is derived from 25 new water and 12 wastewater capital i�) connection charges that are from projected in-fill. A-4 g As presented, the Budget projects utilization of Rate $ 335,501 Stabilization Funds in the amount of: A-4 26 Annual Junior Debt Service consists of the SRF #1 loan: $ 682,862 See Tab K pages K-3 for the detail on each indebted�ess. (1) Resolution 22 - 04 (dated Aug. 18, 2022) which approved a 75% discount on Capital Connection Charges (CCC) and Instailation Fees, reduce budgeted in-fill CCC and install fees by $102,423. A-2 PRELIMINARY BUDGET 9/19/2022 1025 AM Okeechobee Utility Authority FY23 Budget Notes to the Budget Summary of Sources & Uses Funds Statement (Pages A4-A6) Total interest income revenue on restricted account balances has been projected based on the extremely low current yields A-4 39 on qualified public funds accounts and with the expectation that these Iow,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 vear total: $ 32,433 $ 147,469 As prese�ted, the Budget Summary anticipates that the A-4 45 Portion of the projected additional revenue derived from both g 1,020,069 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 $ 491,073 Stabilization Fund: As presented the Budget projects utilization of Operating A-4 62 Funds to increase the Emergency Reserve Fund to its $ (31,274) minimum requirement by subtraling funds in the amount of: A-5 I 115 See worksheet in section O row 6 for a detailed analysis of the projected balances Net Additions to Fund Balances From Transfers in FY23 This amount represents the expected transfers to the individual funds as further detailed in the worksheet in tab O. A-6 172 Proposed Capital Improvement Project and Departmental Capital Expenditures for FY23 total: Proposed capital expenditures are found listed on A-6 (rows 123-154),and also on Tab D sheets D-1 and D-2 and Tab O The proposed expenditures are not listed in any order of priority. �cted Fund Balances at September 30, 2023 >heet in Tab O for a detailed analysis of the balances :xi:� $ 879,482 $ 20,948,109 A-3 PRELIMINARY BUDGET 9/19/2022 1025 AM PRELIMINARY BUDGET 9/19/2022 1025 AM A e C D E F G H 7fi FUNDING SOURCES: FY23 Budgel 77 Fund Balance a[ Octo6er 1, 2022 (Pro�ectcd): 70 Restricted b eond Covenants/Loan Documents: 79 RR&IFund�M�s�eema�n�a�neaa�srorrnorrearsys�emkevenue) 537,896 80 Ca ital Conneclion Fund-Water 470,733 87 Ca ifal Connection Fund-Sewer 392,268 82 Ca ital Connection Fund-Sewer 10/20 Plan �eesmaea mrwwrv os� 289,�82 e4 Debt Servicin Reserve 497,449 85 Sub-Total 2,187 527 86 Desi naled b Board Resolution: 89 Emer enc ReserveFund(m�stnemaima�neaa�aoaayove«pl 657,201 90 O efa�in ReServeFund(sNvemrsooaysotoperExp) 1,327,476 st Pire H drant Pund 289,501 92 Rate S�a6ilization Fund 1,482,146 93 Sub-Total 3,750,324 94 Not Restricted: 95 General O eiatin Funds 1,210,854 96 PTO ACCOUnt Fund 234,500 97 FuWreCIPFundin (Sinvebmainlainate;'ootPnorYearSystemRevenue) 1,376,731 98 Sub-To�al 2,822,085 99 Total Fund Balance at October 1, 2022 (aro�ecied) 8,759,936 t00 1�1 Ch2n 2S l0 FUntl 8313nCe (From Transfers Projected fot PY2J: �p2 Transfer into RR&I Fund (rnusibe mainiainea a� sd, of Pnorven�sys�am ae�e��e) (2,582) 103 Transfer into CCC Fund-Waler ((rom in-fip 10,775 104 Tfanste� into CCC Fund-Water (from 10/20 Plan) 0 105 Trans(er inlo CCC Funtl-Sewer (from in-fil) 10,056 106 Trenster into CCC Fund-Sewer 10/20 Plan 0 107 Transfer into Pire Hydrant Pund 94,205 708 Transfer inlo PTO Account Fund (Net of withdrawals) 0 �pg TransferintoEmergencyReserveFund�n�usibemaimaineaaiaoaay:operE.p) (31,274) ��0 TransferintoOperatingReserveFund(smveiomam�a�naieoaay:oroann� 44,590 �� TransferintoFutureClPFunding�smveiomamiemaiassoranorvearcrossae.) 23Q207 7�2 Transfer into Discretionary Rate Stabilization Funds 491,073 ��3 Tf2nSf2f inlo FUNre CIP Fund Earmaifeed: 0 114 Trans(ers into Restricted Accounts from Interest Income 32,493 115 Tolal Adtlitlons inlo Fund Balance (From Trans(ers in FY23) 879,482 116 ��7 Total Funtl Balances (Pro7ected) 9,659,419 118 Fundin Sources for Pro osed Construction Pro ect Ex entlitures: ��g AdvancedMe�erinfresWCWreProjecl(SONhfloridaWalerManagementDistnc�) 100�000 �Zp AdvancedMe�erintrastrucfureProject(Ioan�obeobtainetlfromSR�) 1�835�075 �p� SRF Loan -0zone Generator 0 �22 FDEP Grant-Treasure Cost Waste Water Project 3,000,000 �23 US�AGranlPrajecl2-Conswctian 4,850,000 724 FDEP Pro'ect t(oesign Construction) 4,064,219 �25 FDEPGrantOkee-Tantie 1,030,449 126 FDEP Grant Pine Ridge Park Wastewater �,947,102 127 Total Funding Sources from Gran[s & Loans 16,620,845 128 TOTAL FUNDS AVAILABLE FOR CAPITAL EXPENDITURES & FUND BALANCES z6,460,264 i2� A-5 PRELIMINARY BUDGET 9/19/2022 10:25 AM PREUMINARY BUDGET 9/19/2022 1025 AM A B C D E F G H 201 Okeecho6ee Utility Authority 2a2 FY23 Budget 203 BudgetSummary sls7/2o2z 204 Debt Service Coverage Tests 205 206 Senio� Lien Debf Service Covera e Anal sis 770% Re uiretl 207 208 General Utility Operating Revenue p�na s aeo�e� 71,277 760 20s LessTotal 0 er Ex ti�ne io anovel 8 797,70a 210 Funds needed irom Ra�e S�abiliza(ion Fund 0 211 Net Genefal U�ili O eratin Revenue 2 479 452 212 273 Tolai Currenl Year O e�alin Revenue for Senior Lien Covera e Tes� 2,479,452 214 275 SeniorLienDebtService 1749,143 141.8% 216 217 Remainin General U�ili O er Rev After Truist Bank Debt Service 730 308 218 219 Senio� Lien Coverage 220 FOR SRF 221 Junior Lien Debt Covere e Anal sis 115% for SRF 120% for RSF COVERAGE 222 223 Remainin Generel Ulili O er Revenue Afler Truist eank Debt Service 710 308 224 Less Senior Lien Coverd e Factor at 10 % 174,914 225 Less Junior Lien Covera e Faclor at 20% 226 InCremZnlal Rate Revenue from FY10 & R'i i rale increases aaaetl abova 684,568 227 Available Revenue for SRF (Junior Lien) �SC Calculation 1,239,962 167.6% 228 231 SRF (Junior Lien) Debl Service 682,862 232 Dollars required to satisry SRF (Junior Lien Coverage) per Board Policy of 120 % 136 572 233 Total Operating Funds required to meet SRF �unior lien) tlebt coverege ratio 819,435 234 235 /�-7 PRELIMINARY BUDGET 9/19/20221025 AM Okeechobee Utility Authority FY23 Budget Notes to Revenue Summary FY23 water and sewer utility revenue have been projected utilizing actual revenues for 10-1-21 to 07-31-22 and budgeted revenues for 08-1- 22 to 09-30-22 fl131/2022 Page Line B-2 8 to 12 Grand Total Operating Revenue is composed of four classifications of � 1,961,728 operating income shown in Revenue Summary tab B2 lines 8 through 11. B-3 18 Total Water Utility Revenue 7,335,575 B-3 15 Total water utility revenue above includes the ongoing effect from the FY10 rate increase with projected incremental water utility revenue totaling: 390,484 B-3 16 Also, total water utility revenue includes the ongoing effect from the FY11 rate increase with projected incremental water utility revenue totaling: 241,449 B-3 29 Total Sewer Utility Revenue 4,425,602 B-3 26 Total sewer utility revenue above includes the ongoing effect from the FY10 rate increase with projected incremental sewer utility revenue totaling: 239,836 B-3 27 Also, total sewer utility revenue includes the ongoing effect from the FY11 rate increase with projected incremental sewer utility revenue totaling: 148,299 B-3 31 Penalties & Late Char es 124,619 B-3 34 Miscellaneous 75,931 B-4 63 Total Ca ital Connection Char es 20,831 As previously noted on Page A, the growth rate in new capital connections 0.26% from in-fill is projected at approximately: B-1 PRELIMINARY BUDGET 9/19/2022 10:26 AM � A 1 Okeechobee Utility Authority 2 FY23 Budget 3 Revenue Summary 4 5 6 7 Operating Revenue; 8 Total Water Utility Revenue (see B3 �ine 18) 9 Total Sewer Utility Revenue (see e3 Line 2s) 10 Penalties & Late Charges 11 Miscellaneous Revenue 13 Grand Total Operating Revenue (see B-3 Line 40) 14 . 15 Non-Operatinq Revenue: 16 Gain/Loss Sale of Fixed Assets 17 Fire Hydrant Fund Fees 18 Total Restricted Interest (see B-4 Line 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 24 25 Grants. Loans & CIP Fundina: 27 28 29 30 31 32 33 31 Funding for CIP & Departmental Capital Expenditures �I Funding (Rate Stabilization Fund) for SRF Debt Service + g for Operating Reserve and for Emergency Reserve Funds ial Funding for Construction Projects Grants, Loans & CIP Funding (see B-a Line 80) GRAND TOTAL REVENUE (see B-4 �ine 82) Ce7 FY22 Budget 6,851,513 4.161.360 42,324 11,184,060 8,235, 10,648, 21,975, I: 3.50°/ 3.50°/ 8/3112022 FY23 iU 75,931 11,961,728 G 0 147,469 17,156,346 19,935,121 32,044,317 PRELIMINARY BUDGET 9/19/2022 1026 AM A H N O P 1 Okeechobee Utility Authority L � s�39/2022 ! 2 FY23 Budget � � � _ __ , 3 Revenue Detail . -- 4 FY22 FY23 (1) revenue budget assumes capital connection charges and 5 installation fees will remain at 75% discount levels. Budget Budget 6 Amount Amount 7 OPERATING REVENUE _ - 8 Water Utilit Revenue 6,071,945 6,508,071 ._ 9 Wate� AGRC Revenue (trom in-fill connections) 0 0 _.._.....__---- ---- 10 WaterGRCRevenue 21,912 24,742 11 Install Fees Water 6,625 6,650 (1) 12 Private Fire Protection 81,189 89,671 13 Turn On/Off Fees 63,551 59,580 . _-- -- 14 Other Revenue Water 16,705 14,928 15 Increme�tal Water Rev From 6.0% Rate Increase in FY-10 364,317 390,484 .. - -- 16 Incremental Water Rev From 3.5% Rate Increase in FY-11 225,269 241,449 18 Total Water Utilit Revenue � 6,851,513 7,335,575 19 I � 20 Wastewater Utility Revenue 3,760,831 3,997,274 21 Wastewater AGRC Revenue (trom �r,-rn �o��e�tions� 0 0 . 22 Wastewater GRC Revenue 15,705 11,214 23 Install Fees Wastewater 6,360 6,660 (1) . _- 24 Kin s Ba Wastewater Maintenance Fee 10,840 20,251 . 25 Other Revenue Wastewater 2,447 2,068 _ _____ 26 Incremental Wastewater Rev From 6.0% Rate Increase in FY-10 225,650 239,836 - -- 27 Incremental Wastewater Rev From 3.5% Rate Increase in FY-11 139,527 148,299 29 Total Wastewater Utility Revenue 4,161,360 4,425,602 30 I � . -- -- 31 Penalties & Late Charges 128,863 124,619 32 Merchant Revenue I 51,006 -- - i - - 33 A Land Lease 3,515 34 Miscellaneous Revenue 42,324 75,931 - - --- 35 I 41 GRAND TOTAL FROM OPERATING REVENUE 11,184,060 11,961,728 --- Resolution 22 - 04 (dated Aug. 18, 2022) which approved a 75% � discount on Capital Connection Charges (CCC) and Installation �� I 42 Fees, reduce budgeted in-fill CCC and install fees by $102,423. PRELIMINARY BUDGET 9/19/2022 1026 AM B-3 A H N O P 1 Okeechobee Utility Authority_ � I s/3v2o22 _ . — — -- 2 FY23 Budget � — . .-- — _ 3 Revenue Detail . _ --- 4 FY22 FY23 -- — — _ . ___ __ (1) revenue budget assumes capital connection charges and 5 installation fees will remain at 75% discount levels. Budget Budget --- — — -- -- 43 NON-OPERATING REVENUE Amount Amount 44 Gain/Loss Sale of Fixed Asset 0 0 _ -- — 45 I 46 Fire Hydrant Fund Fees 87,240 94,205 47 i - i 49 Interest Operating Account 19,619 16,175 -- 50 Interest Pa roll Account 542 522 51 Interest-RR&I Fundin Required 2,340 2,889 54 Interest-Rate Stabilization Fund & Debt Service Fund 2,025 3,338 55 Interest-Operating Reserve Fund (60 day O&M) accrued 8,325 6,332 56 Interest-Emergency Reserve Fund (30 da O&M) accrued 2,790 3,176 57 Total Restricted Interest 35,641 32,433 58 I � _ 59 Water CCC from in-fill 10,425 10,775 (1) 60 Waslewater CCC from in-fill 9,720 10,056 (1) 61 Water CCC ffom 10/20 Plan (Net assessment received from developer) 0�� 0 62 WWTP CCC 10/20 Plan (Net assessment received from developer) 0 0�� 63 Total Water & WW CCC Revenue (Direct) 20,145 20,831 73 GRAND TOTAL NON-OPERATING REVENUE 143,026 147,469 74 . � I 75 GRANTS, LOANS & CIP FUNDING i 76 Internal Fundin for CIP Expenditures 1,184,250 1,254,175 77 Internal Funding for SRF Debt Service (from Restricted Funds) 0 0 78 Internal Fundin for Departmental Capital Expenditures 1,229,300 1,524,600 . 79 Extemal Funding-State Programs 7,035,097 16,125,897 80 Extemal Funding from loans/grants to obtain 1,200,000 1,030,449 81 GRAND TOTAL GRANTS & INTERNAL FUNDING 10,648,647 19,935,121 82 I 83 GRAND TOTAL SOURCES OF FUNDS 21,975,733 32,044,317 84 I i .. -- — Resolution 22 - 04 (dated Aug. 18, 2022) which approved a 75% ' �' discount on Capital Connection Charges (CCC) and Installation �� 85 Fees, reduce budgeted in-fill CCC and install fees by $102,423. ' i - -- � __ i PRELIMINARY BUDGET 9/19/2022 1026 AM B-4 FY23 Budget Notes to Operating Expense Summary: Paqe Line 813112022 C-2 � 26 �Total Departmental Operating Expense: � $8,797,708 Operating expense (including labor) as presented is higher $ g15,123 10.21% 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 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 o A-1 2� an adjusted amount based on a projected rate increase of: 16.10 /o A-1 Zg Chemicals are assigned a specific budgetary value and a percent 58.70% chan e based on su lier's rice ad'ustments '21-'22 : Fuel, gas, diesel & general petroieum based commodities have A-1 31 been assigned a specific budgetary value and a percent change 12.60% based on inflation estimates: PRELIMINARY BUDGET 9/1912022 10:26 AM C-1 I1 1 Okeechobee Utility Authority 2 FY23 Budget 3 Expenditures Summary 4 5 Operating Expenses 6 Admin/Exec. Labor, (includes $27, 7 Admin/Exec. O & M 8 Total Administration / Executive 9 10 Maintenance Labor 11 Maintenance O & M 12 Total Maintenance Expenses 13 14 Water Labor 15 Water O & M 16 Total Water Expenses 17 18 Wastewater Labor 22 Meter Labor 23 Meter O & M 24 Total Meter Reader 25 26 27 28 Non-Operatina E� Grand Total 31 Depreciation Expense 32 Grand Total 33 34 Transfers 35 Debt Service Principal Payments 36 Required Transfers to Restricted Revenue Funds Transfers Grand Total Transfers GRAND TOTAL EXPENDITURES C FY22 Budget 1, 276,484 1,147, 780 2,424,264 1, 388,184 1,061,409 2,449,593 617,335 1,074,750 1,692,085 605,492 533,610 1,139,102 246, 761 30,780 277,541 7,982,585 356,854 12,600 2,700,000 3,069,454 24,688,335 ' I 4q I NON-CASH AMORTIZATION & DEPRECIATION EXPENSE L_ 21 PRELIMINARY BUDGET 9/19/2022 10:26 AM G 8131/2022 FY23 Budget 1, 239, 98� 1,267,18� 2,507,173 1,384,916 1,156,406 2,541,322 1,459,02: 2,101,509 609,266 742,500 1,351,766 245,988 49,950 8,797,708 2,113,25: 147,469 1, 067, 515 19,599,620 34,756,917 A B D E L � Okeechobee Utility Authority � z FY23 Budget ' ._-� -, I 8/31/2022 - — . .. s Operating Expense Summary by Department I � � 4 I I e . .- — � FY22 FY23 . -- - - 6 — I--- - � Budget _ � Budget � JDepartment � Amount s Summa Labor: IAdministration 1,276,484 1,239,984 s �Maintenance I 1,388,184� 1,384,916 �o �Water j 617,335� 642,484 11 Wastewater 605,492� 609,266 �2 I Meter 246,761 I 245,988 �s � Total Labor � 4,134,256� 4,122,638 74 I I � 15 � � � �s Summary O& M: Administration � 1,147,780� 1,267,189 �� Maintenance 1,061,409 1,156,406 � a � Water I 1,074,750 1,459,025 19 �Wastewater � 533,610 742,500 Zo Meter � 30,780 � 49,950 z� � Total O& M j 3,848,329� 4,675,070 22 I 23 I 24 I I z5 Summary Dept Total: Administration � 2,424,264� 2,507,173 zs �Maintenance 2,449,593� 2,541,322 z� Water ; 1,692,085j 2,101,509 Zs �Wastewater � 1,139,102) 1,351,766 29 Meter � 277,541� 295,938 so Total Department Expenses � 7,982,585� 8,797,708 31 ( I 32 I 33 ( II � 34 I �i ( 35 FY23 Operating Expense Budget higher than Final FY22, as amended j ( 815,123 36 Percent chan e � � � � 10.21 % ', 37 � � 38 I '. 39 I PRELIMINARY BUDGET 9/19/2022 10:24 AM C-3 q B D E L ao Okeechobee Utility Authority '� --- - a� FY23 Budget � I 8/31/2022 .-- _ 1 — az Operating Expense ; Detail by Department and Account i aa � � � aa � l FY22 FY23 45 Administration Labor: � � Budget Budget - _ --- _ _ _ as Account Number � Account Description � Amount 0 a7 401-3-513-1100-100 �Executive Salaries 115,890I 146,328 as 401-3-513-1101-100 Supervisor salaries I 128,690; 124,072 as 401-3-513-1200-100 IRegularSalaries � 387,338� 409,614 so 401-3-513-1201-100 Non-pension admin � 284,575I 260,000 51 401-3-513-1202-100 IBonusPayAdmin 12,706� 14,100 s2 401-3-513-1300-100 IAccrued Pa out PTO (cash pa men; 15,189) 0 53 401-3-513-1400-100 �Overtime � 7,303 7,195 ea 401-3-513-1600-100 �Accured Wages and FICA OI 0 55 401-3-513-1610-100 Accrued Benefits & FICA (vacation/' Oi 17,437 ss 401-3-513-2100-100 FICA I 72,804� 74,874 e� 401-3-513-2200-100 jRetirement �i 78,394 0 sa 401-3-513-2300-100 �Health Insurance i 134,400I 144,000 59 401-3-513-2301-100 IDisability Insurance � 2,982� 3,085 so 401-3-513-2302-100 Life Insurance 3,264 3,684 61 401-3-513-2400-100 iWorkmens Compensation I 1,598� 1,543 sz 401-3-513-2500-100 �UnemploymentCom ensation ; OI 0 i 63 401-3-513-3400-213 Urgent Care Services 27,851 27,851 sa 401-3-513-2400-101 �COLA Increase 0� 0 se 401-3-513-1620-100 �Accrued OPEB � 3,500 1,000 66 401-3-513-1201-102 �Janitorial Services ; 0� 5,200 6� I I o 68 � 69 I I � ' �o �Admin Labor Subtotal 1,276,484 1,239,984 ' �� I � ',, 72 � i � PRELIMINARY BUDGET 9/19/2022 10:24 AM C-4 PRELIMINARY BUDGET 9/19/2022 10:24 AM C-5 A B D E L � � a I FY22 FY23 _ _ __ - - _ ��s Administration 0&M: 1 Budget Budget �Zo Account Number � Account Description� Amount � 0 �z� 401-3-513-4400-101 �Pitney Bowes Post Mach Lease ( 1,100� ( 1,100 �zz 401-3-513-4400-102 �Copier Usa e Costs 5,000� � 5,000 �2s 401-3-513-4500-200 �Insurance-Prop, Cas & Gen Liab I 398,000� � 386,812 �2a401-3-513-4500-201 ;Insurance-Pollution Polic �, 12,777� i 12,777 �zs 401-3-513-4500-202 � Insurance-Storage Tank Polic � 2,000 2,000 �2s401-3-513-4600-100 IR&MVehicles 1,500I � 2,500 �2� 401-3-513-4609-100 �R&M Building Admin II 25,OOOI 10,000 �za 401-3-513-4611-100 �R&M Equipment � 1,250) � 1,250 �zs 401-3-513-4612-100 IR&M Comp Equipment 1,500I 1,500 �so 401-3-513-4613-100 I R&M Comp Software (Springbrk) � 36,796I I, 40,000 �s� 401-3-513-4613-101 jComp Sys, HW/SW Upgrades& IT �i 7,500i ; 7,500 �sz 401-3-513-4613-102 � IT Outsourced Services 10,800 11,400 �ss 401-3-513-4615-100 I Lawn Service Admin 750I I 750 �sa401-3-513-5208-101 I,Shrinka eExpense II, 0� I 0 �se 401-3-513-4700-200 Printing and Binding � 17,500) j 25,000 �ss 401-3-513-4901-100 Education-Sprin brook & General � 3,500� � 3,500 �a� 401-3-513-4902-200 Advertising I 3,500 I 10,000 �se 401-3-513-4902-201 �Website/Webhosting Exp E-billing � 1,500� � - �ss401-3-513-4905-200 'Bad DebtExpense j 30,000� ' - �ao 401-3-513-4909-100 �Staff Awards & Luncheon � 24,000) 10,000 �a� 401-3-513-5100-100 IOffice Supplies I 7,500I 7,500 �az 401-3-513-5201-100 I Fuel Gas & Diesel - Vehides I 1,632� 2,000 �as401-3-513-5203-100 jUniforms � 1,500; 1,500 �aa 401-3-513-5207-100 Tools j 250) 250 �ae 401-3-513-5208-100 Supplies Administration 7,500� 7,500 �as 401-3-513-5400-100 �Books, Dues and Publications I 10,000� 7,500 �n� 401-3-513-6400-100 �Capital Outlay Admin I 15,5001 13,200 �as 401-3-513-9000-200 �Contingencies j 150,000� 200,000 �as 401-3-513-9000-200 �Contingencies - FY22 � 0) 64,791 ' �ao 401-3-513-4907-100 I Loan Cost of Issuance 0� 0 '' �5� �Admin O& M Subtotal I 1,147,780 I 1,267,189 ' �sz �Admin De t Totals 2,424,264 � 2,507,173 PRELIMINARY BUDGET 9/19/2022 1024 AM C-6 q B D E L �es I, i FY22 FY23 — --� -- — �s� Maintenance Labor: � � Budget Budget _---- ..— �sa Account Number � Account Description � Amount � 0 aes 401-4-536-1101-100 ISupervisor Salaries Maint ; 77,480j 79,560 �so 401-4-536-1200-100 !Regular Sa�aries � 780,853 823,402 �s� 401-4-536-1201-100 Non- ension 68,609I 70,000 �s2 401-4-536-1201-101 I On Call � 12,561 � 13,200 �ss 401-4-536-1400-100 �Overtime Maint 41,412� 40,800 �sa 401-4-536-1600-100 �Accured Wages and FICA Maint I OI 0 �se 401-4-536-1610-100 Accrued Benefits & FICA (vacation/; 0; 10,000 �ss 401-4-536-2100-100 I FICA Maint � 77,222� 80,046 �s� 401-4-536-2200-100 �Retirement Maint 78,108 0 �sa 401-4-536-2300-100 Health Insurance Maint 176,400I 189,000 �s9401-4-536-2301-100 IDisabilit InsuranceMaint i 3,028� 3,142 ��0 401-4-536-2302-100 I Life Insurance Maint � 4,284 4,434 t�� 401-4-536-2400-100 �Workmens Compensation Maint 36,194I 46,867 ��z 401-4-536-2500-100 �Unemployment Comp Maint I OI 1,000 ��s 401-4-536-1300-100 Accrued Payout PTO (cash paymen' 15,426� 7,871 ��a401-4-536-1202-100 IBonusPay-Maint � 13,107� 14,594 ��5 401-4-536-2601-100 �Accrued OPEB Maint 3,500I 1,000 176 I I I �� IMaintenanceLaborSubtotal � 1,388,184i 1,384,916 � �a I 179 I I 180 � 181 � 182 ! 183 � � 184 j � 185 � I I 186 I I I 187 I i 188 � � 189 I I I 190 � I I PRELIMINARY BUDGET 9/19/2022 10:24 AM C-7 PRELIMINARY BUDGET 9/19/2022 1024 AM C-8 A B D E L zsa � Budget - - — -- - zss Maintenance O& � I Budget j 0 — _ ---- - zao Account Number Account Description j Amount � za� 401-4-536-5201-100 IFuel: Gas, Diesel -Vehicles 38,080I 55,000 zaz 401-4-536-5202-100 I Fuel Other Maint 8,160j 15,000 2as401-4-536-5203-100 jUniformsMaint 7,500) 5,500 zaa 401-4-536-5206-100 �Meters and Meter Boxes 175,OOOI 200,000 Za5 401-4-536-5207-100 ITools Maint I 17,500i 12,500 Zns 401-4-536-5207-200 IToois Pump Stations � 1,250 1,000 Za� 401-4-536-5207-300 jTools Air Vac � 500 500 zaa 401-4-536-5207-400 Tools Water Dist Maint 750I 500 zas 401-4-536-5207-500 ITools Sewer Collection Maint 500; 500 Zso 401-4-536-5207-600 ITools Kings Bay Maint � 500� 500 Ze� 401-4-536-5208-100 (Supplies Maint � 17,500I 30,000 Ze2 401-4-536-5208-200 �Supplies Pump Stations � 1,250I 1,000 zss 401-4-536-5208-300 Supplies Air Vac 500� 1,250 zsa 401-4-536-5208-400 Supplies Water Dist Maint I 7,500j 7,500 2sa 401-4-536-5208-500 ISupplies Sewer Collection Main ; 2,250 1,500 Zes 401-4-536-5208-600 ;Suppiies Kings Ba Maint j 250 250 Ze� 401-4-536-5209-200 Chemicals Pump Stations � 94,500I 96,000 2ss 401-4-536-5215-100 Safety Supplies 15,000� 12,500 zes 401-4-536-5400-100 Books, Dues and Publ Maint 500 750 Zso 401-4-536-6400-100 ICapital Outlay Maint � 0) 20,406 zs� 40'-4-536-9000-100 �;Contingency-Maint j 25,OOOI 25,000 zsz 401-4-536-9999-100 jReturn To Stock � 0 0 263 I I i Zsa Maintenance O& M Subtotal 1,061,409; 1,156,406 zs5 IMaintenance DeptTotals I 2,449,593 2,541,322 267 268 i I 269 i � I 270 � � � 271 I I 272 I 273 I PRELIMINARY BUDGET 9/19/2022 10:24 AM C-9 A B D E L 2�a ' I ._ _ FY22 � _ FY23 . - -- -- _ 2�5 Water Labor: � Budget ___ Budget _ -- --- - — z�s Account Number Account Description Amount � 0 2�� 401-5-533-1101-100 �Supervisor Salaries SWTP I 48,805 50,261 Z�a 401-5-533-1101-200 �Supervisor Salaries GWTP I, 20,917� 21,540 2�9 401-5-533-1200-100 � Regular Salaries SWTP j 304,159� 283,840 zao 401-5-533-1200-200 I Regular Salaries GWTP � 39,894) 42,598 zs� 401-5-533-1300-100 (Accrued Payout SWTP 6,606� 7,260 zsz 401-5-533-1300-200 Accrued Payout GWTP I 0� 0 zas 401-5-533-1201-103 Part Time Employee SWTP �, 0; 0 zsa 401-5-533-1201-100 Non Pension Employee SWTP � 0) 50,000 Zss401-5-533-1202-100 IBonusPa SWTP � 5,697� 6,400 Zss 401-5-533-1202-200 I Bonus Pay GWTP 609 323 zs� 401-5-533-1400-100 �Overtime SWTP 11,817I 11,642 zss 401-5-533-1400-200 ;Overtime GWTP �, 1,860i 1,833 zas 401-5-533-1610-100 �Accured Benefits and FICA SWTP ; 0; 20,000 z90 401-5-533-1610-200 �Accured Benefits and FICA GWTP � 0 0 zs� 401-5-533-2500-100 I Unemployment Comp SWTP 0� 0 2s2 401-5-533-2500-200 I Unemployment Com GWTP I 0 0 zss 401-5-533-2100-100 �FICA SWTP I 30,392I 31,320 zsa 401-5-533-2100-200 � FICA GWTP 3,295I 5,071 zse 401-5-533-2200-100 i Retirement SWTP 34,023! 0 Zss 401-5-533-2200-200 ( Retirement GWTP i 3,630) 0 Ze� 401-5-533-2300-100 � Health Insurance SWTP � 75,600) 81,000 Zsa 401-5-533-2300-200 Health Insurance GWTP 8,400I 9,000 zss 401-5-533-2301-100 Disability Insurance SWTP 1,221 1,341 soo 401-5-533-2301-200 I Disability Insurance GWTP I 138I 130 so� 401-5-533-2302-100 I Life Insurance SWTP I 1,8361, 1,866 soz 401-5-533-2302-200 �Life Insurance GWTP 204I, 204 sos 401-5-533-2400-100 jWorkmens Comp SWTP ; 14,142; 13,138 soa 401-5-533-2400-200 �Workmens Comp GWTP ( 1,540� 1,165 so5 401-5-533-1600-100 IAccured Wages and FICA SWTP � 0� 0 sos 401-5-533-1600-200 IAccured Wages and FICA GWTP � 0 0 so� 401-5-533-2601-100 Accured OPEB SWTP 2,100 2,100 sos 401-5-533-2601-200 Accured OPEB GWTP 450I 450 sos I Water Labor Subtotal 617,335I 642,484 PRELIMINARY BUDGET 9/19/2022 1024 AM C-10 PRELIMINARY BUDGET 9/19/2022 10:24 AM C-11 A B D E L 366 as� Water O& M: � Description I Budget Budget -- — - --- sss Account Number Amount 0 sss 401-5-533-4909-100 �Staff Awards & Luncheon I 1,250I 1,500 s7o 401-5-533-4909-200 (Miscellaneous GWTP ! 250I 250 s��401-5-533-4950-100 �PermitsSWTP j 250�i 250 s�z 401-5-533-4950-200 I Permits GWTP 250; 250 s�s 401-5-533-5100-100 Office Supplies SWTP 2,500 1,250 s�a 401-5-533-5100-200 Office Su plies GWTP I 250 250 s�s 401-5-533-5201-100 I Fuel: Gas, Diesel - Vehicles SWTP I 3,808I 3,800 s�s 401-5-533-5201-200 ;Fuel: Gas, Diesei - Vehicles GWTPI, 272 300 s�� 401-5-533-5202-100 ( Fuel Other Equipment SWTP i 9,248 15,000 s�s 401-5-533-5202-200 � Fuel Other Equipment GWTP � 3,536I 3,000 s�s 401-5-533-5203-100 Uniforms SWTP 1,250�i 750 sso 401-5-533-5203-200 Uniforms GWTP � 250I 250 ss� 401-5-533-5204-100 Lab Supplies SWTP I 8,500i 10,000 ssz 401-5-533-5204-200 Lab Supplies GWTP I 1,OOOi 1,500 sss 401-5-533-5207-100 ITools SWTP I 750) 500 ssa 401-5-533-5207-200 ITools GWTP 250) 250 sss 401-5-533-5208-100 ISupplies SWTP I 2,250� 2,250 sss 401-5-533-5208-200 Supplies GWTP I 250 250 3a7 401-5-533-5209-100 IChemicals SWTP 420,OOOI 750,000 sss 401-5-533-5209-200 IChemicals GWTP 18,375 15,000 sss 401-5-533-5209-700 IChemicals PRP 0 0 sso 401-5-533-5215-100 �Safety suppliesSWTP i 2,500 1,250 ss� 401-5-533-5215-200 ;Safety supplies GWTP ( 250 250 ss2 401-5-533-5400-100 iBooks, Dues and Pub SWTP i 250I 250 s9s 401-5-533-5400-200 �Books, Dues and Pub GWTP j 150I 125 sss 401-5-533-6400-100 �Capital Outlay SWTP � 4,OOOI 9,500 sss 401-5-533-6400-200 Capital Outlay GWTP � 0 0 ss� 401-5-533-9000-100 �Contingency-Water � 50,000� 50,000 398 �Water O& M Subtotal � 1,074,750I 1,459,025 399 �WaterDeptTotals � 1,692,085� 2,101,509 PRELIMINARY BUDGET 9/19(2022 1024 AM C-12 A B D E L ao2 � FY22 � FY23 aos Wastewater Labor: � Budget Budget — _ — -- aoa Account Number Account Description j Amount 0 aos 401-6-535-1101-100 I,Supervisor Salaries WW � 71,136; 73,216 aos 401-6-535-1200-100 j Regular Salaries WW I 330,741 � 366,527 ao� 401-6-535-1201-103 �Part-time Salaries WW I 20,186I 12,000 aoe 401-6-535-1201-100 IOn Call WW wages j 0�� 0 aos 401-6-535-1202-100 �Bonus Pa WW I 6,441 j 6,596 a�o 401-6-535-1300-100 iAccrued Payout WW I 7,296 7,728 a�� 401-6-535-1400-100 �Overtime WW � 15,166I 14,942 a�2 401-6-535-1600-100 IAccured Wages and FICA WW 0�� 0 a�s 401-6-535-1610-100 IAccured Benefits and FICA WW 0; 0 ata 401-6-535-2100-100 ;FICA WW 34,499� 35,879 a�s 401-6-535-2200-100 � Retirement WW I 36,571 I 0 a�s 401-6-535-2300-100 I Health Insurance WW i 67,200 75,000 a�� 401-6-535-2301-100 I Disability Insurance WW � 1,248I, 1,800 a�s 401-6-535-2302-100 ILife Insurance WW 1,632) 2,040 a�s 401-6-535-2400-100 iWorkmens Compensation WW I 11,076� 11,237 azo 401-6-535-1620-100 Accured OPEB WW I, 2,300 2,300 421 j DI � 422 j OI 0 423 � �� 424 � I 0 � 425 � I I azs 401-6-535-2500-100 �Unemployment Comp WW � OI 0 427 azs Wastewater Labor Subtotal i 605,492I I 609,266 429 I i 430 � I I 431 � I I 432 I I I 433 ; 434 � I 435 � � 436 � 437 I I � 438 I I I ' 439 ( I I 440 j I I '', 441 � I � PRELIMINARY BUDGET 9/19/2022 10:24 AM C-13 PRELIMINARY BUDGET 9/19/2022 1024 AM C-14 A B D E L aa9 I FY22 � FY23 r-.._ _.._ - ..__.. .._- - j __..__- .__._ . aso Wastewater O& M: i � Budget L Budget — _ _-- – -- as� Account Number � Account Description , Amount � 0 asz 401-6-535-4616-100 ITesting and Lab Service WWTP � 22,500� 20,000 ass 401-6-535-4616-400 'iTesting and Lab Services ETP 1,250� 1,500 asa 401-6-535-4616-500 jTesting and Lab Services KBTP 1,250 1,500 a9a 401-6-535-4616-700 Testing and Lab Services PRP � 0� ! 0 a9s 401-6-535-4617-100 I Residual Management WWTP 45,OOOI 70,000 as� 401-6-535-4901-100 �,Education WW 2,OOOi 1,500 ass 401-6-535-4909-100 iStaff Awards & Luncheon 1,500) 1,500 ass 401-6-535-4950-100 � Permits WW Cemeter Rd i 5,000� 148,500 aoo 401-6-535-4950-200 I Permits LVTP � OI 0 50� 401-6-535-4950-300 IPermits OTTP 0�� 0 502401-6-535-4950-400 �Permits ETP I Oj 0 eos401-6-535-4950-500 ;PermitsKBTP I 0� 0 aoa 401-6-535-4950-600 j Permits - Injection � 0 0 aos 401-6-535-5100-100 �Office Supplies WW 1,250I 1,250 5os 401-6-535-5201-100 I FueL Gas, Diesel - Vehicles 5,440�i 6,000 50� 401-6-535-5202-100 Fuel Other WW 9,248i 5,000 5oa 401-6-535-5203-100 IUniforms WW 2,250� 1,500 sos401-6-535-5204-100 iLab Su lies WW 'I 2,500 2,000 s�o 401-6-535-5207-100 Tools WW i 1,500 2,500 s�� 401-6-535-5208-100 Supplies WW � 2,500I 3,500 a�2401-6-535-5209-100 IChemicals WWTP � 55,650�, 75,000 5�s 401-6-535-5209-200 IChemicals LVTP 2,625; 4,500 5�a 401-6-535-5209-300 �Chemicals OTTP I 1,838� 2,000 s�5401-6-535-5209-400 !Chemicals ETP 1,575 1,750 s�s 401-6-535-5209-500 'Chemicals KBTP ; 2,625 3,500 a�� 401-6-535-5209-600 Chemicals PRP TP i 0 e�s 401-6-536-5215-100 ISafety Supplies � 2,250 2,250 s�9 401-6-535-5400-100 Books, Dues and Publications � 250� 250 szo 401-6-535-6400-100 Capital Outlay WW � 26,600� 12,600 sz2401-6-535-9000-100 I,Contingenc -WW I 50,000) 50,000 szs iWastewater O& M Subtotal 533,610 � 742,500 524 (Wastewater Dept Totals � 1,139,102 1,351,766 531 I I I PRELIMINARY BUDGET 9/19/2022 1024 AM C-15 A B D E � 5sz � j FY22� FY23 _ - ess Meter Labor: I - ... I Budget I Budget esa Account Number Account Description � Amount � 0 5sa 40 -7-5 3-1101-100 I upervisor Salaries MR I 55,9941, 58,074 5ss 401-7-513-1200-100 �Regular Salaries MR i, 98,176� 103,326 es�401-7-513-1202-100 �BonusPay i 2,354) 2,447 sss 401-7-513-1300-100 Accrued Pa out � 2,749 2,977 5a9401-7-513-1201-100 INonPensionwagesMR I 0� 0 eao 401-7-513-1201-102 ICustodial services I 16,166; 18,720 5a� 401-7-513-1400-100 iOvertime � 2,192) 2,160 saz 401-7-513-1600-100 iAccured Wages and FICA i OI 0 eas 401-7-513-1610-100 �Accured Benefits and FICA OI 0 eaa 401-7-513-2100-100 I FI A I 13,589I 14,359 5ae 40 -7-513-2200-100 I Retirement I 14,029j 0 5as401-7-513-2300-100 IHealthlnsurance i, 33,600) 36,000 54� 401-7-513-2301-100 �Disabilit Insurance � 511 � 535 eas 401-7-513-2302-100 ILife Insurance j 816I 846 eas 401-7-513-2400-100 �Workmens Compensation 5,485 5,545 eao 401-7-513-2500-100 � Unemployment Comp MR I OI 551 0 552 I j � 553 I I � 554 �� j sss 401-7-513-1620-100 iAccrued OPEB MR � 1,100 1,000 556 Meter Labor Subtotal 246,761 245,988 557 558 i 559 j 560 561 � � � 562 � � I 563 � � I 564 I I I 565 �I 566 ! 567 I I � 568 � 569 i � 570 � � 571 ( � � 572 � 573 I 574 � I I 575 I PRELIMINARY BUDGET 9/19/2022 10:24 AM C-16 A B D E L 576 I FY23 - -- - - r -- 8�� Meter O& M: � Budget _ � _ Budget s�a Account Number { Account Description � Amount � 0 a�s 401-7-513-3400-209 '�,GPS Tracking I 1,500I 1,500 eso 401-7-513-4618-100 � Backflow recalibration fees&repairs I 0; 0 5s� 401-7-513-4000-100 �Travel and Per Diem i 250) 250 esz 401-7-513-4200-100 I Posta e, Freight & Shipping MR 150 150 eas 401-7-513-4200-100 �iSLERS Radio Service Fee MR (8x$�, OI 1,000 eaa 401-7-513-4100-106 �SLERS Tower Maint Fee MR (8x$9;, 900; 1,000 5ss 401-7-513-4100-107 �SLERS Tower Service Fee j 0� 0 sss401-7-513-4100-108 ISLERS R&M � OI 750 es� 401-7-513-4600-100 R&M Vehicles 2,750I 10,000 sea 401-7-513-4611-100 iR&M Meter Reading Equipment I 1,500�, 2,500 eas 401-7-513-4613-100 �R&M omputer Software Sensus ; 3,870� 4,250 5so 401-7-513-4618-100 BackFlow Equipment Testing 0 0 ssi 401-7-513-4901-100 Education 500� 500 ssz 401-7-513-4909-100 IStaffAwards & Luncheon 0 800 sss 401-7-513-5201-100 'iFuel: Gas, Diesel - Vehicles 8,160I 15,000 esa401-7-513-5203-100 jUniforms � 1,200� 1,000 s9a 401-7-513-5207-100 �Tools � 850j 1,000 sss 401-7-513-5208-100 Su plies 1,250) 2,500 ss� 401-7-513-5400-100 I Books, Dues and Publications 500� 500 sss 401-7-513-6400-100 ICapital Outlay I OI 3500 5ss 401-7-513-6399-100 ;Insect Services 3,OOOI 3,000 soo 401-7-513-5215-100 i Safety � 900 j 750 so� 401-7-535-6400-100 Capital Outlay MR i 3,500i 0 soz Meter O& M Subtotal 30,780j 49,950 sos I Meter Dept Totals � 277,541 � 295,938 soa I I I PRE�IMINARY BUDGET 9/19/2022 10:24 AM C-17 A B C D E F H 1 Okeechobee Utility Authority 2 FY23 Budget 8131/2022 3 NON-OPERATING EXPENSES AND TRANSFERS 4 5 FY22 FY23 6 Budget Budget 7 NON-OPERATING EXPENSES: Amount Amount 8 Debt Service Interest Expense: 11 SRF 1 Interest Expense 85,767 74,609 12 SRF 2 Interest Expense 0 0 14 Truist Bank 2020A Interest Expense 90,995 67,331 15 Truist Bank 2020B Interest Expense 180,093 176,813 16 Total 356,854 318,753 17 18 Amortization Expense: 31 Amortize Organizational Costs 0 0 32 Amortize Lon -Term Lease 12,600 12,600 33 Total 12,600 12,600 34 35 Depreciation Expense: 2,700,000 2,700,000 36 37 TOTAL NON-OPERATING EXPENSES 3,069,454 3,031,353 38 39 PRELIMINARY BUDGET 9/19/2022 1026 AM C-18 A B C D E F H 40 NON-OPERATING TRANSFERS: FY22 FY23 41 Required Transfers: 42 Debt Service Principal Payments: 45 SRF 1 Principai 597,096 608,253 46 SRF 2 Principal 0 0 52 Truist Bank 2020A Principal 1,316,000 1,340,000 53 Truist Bank 2020B Principal 160,000 165,000 54 Total 2,073,096 2,113,253 55 UnrestrictedlRestricted Revenue Transfers to Restricted Accts: 56 57 Restricted Interest to Restricted Accts. 15,480 32,433 58 Cap Conn Fund Water (infill) 10,425 10,775 59 Cap Conn Fund WW (infill) 9,720 10,056 61 Fire Hydrant Fund 87,240 94,205 62 Emergency Reserve Fund 0 0 63 Total 122,865 147,469 64 72 Discretionary Transfers: 73 Net Transfer to Rate Stabilization Fund 791,688 $ 491,073 74 Funds Earmarked for General Operating Fund 0 346,235 75 Future CIP Funding 0 230,207 76 Total 791,688 1,067,515 77 OtherTransfers: 78 Internal Transfer for CIP Expenditures & Capital Assets 1,184,250 1,254,175 79 Internal Transfer for Departmentai Ca ital Expenditures 1,229,300 1,524,600 80 External Fundin from State 8,235,097 16,820,845 81 Total 10,648,647 19,599,620 82 83 TOTAL NON-OPERATING EXPENSES AND TRANSFERS 16,705,750 25,959,209 84 PRELIMINARY BUDGET 9/19/2022 1026 AM C-19 D-1 PRELIMINARY BUDGET 9/19/2022 10:56 AM r � 0 > � ¢ z � w tt n 1 Okeechobee Utility Au1 2 FY23 Budget 3 Analysis of RR&I Fund 4 Funding is required to be maintained at 5% of Previous Year System 5 Operatina Revenue. 7 8 FY22 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 17 18 Remaining Fund Surplus (Deficit) 19 20 3 8/31/2022 $11,184, 060 559,203 561,785 2,582 $2, 582 PRELIMINARY BUDGET 9/19/2022 10:27 AM E-1 1 Okeechobee Utility Authority 2 FY23 Budget 3 Analysis of Emergency Reserve Fund 5 �(Maintained at 30 days of current year System O& M) 7 8 FY22 System Operating Expenses (Budgeted) 9 10 FY22 30 Days O& M Expenses (Fund Balance Required) 11 12 Fund Balance at September 30, 2023 (Projected) 13 14 Fund Surplus (Deficit) 15 16 17 18 Remaining Fund Surplus (deficit) 19 20 30 calendar davs of the precedina vear O& M(FY � 8/31 /2022 $7,982,585 656,103 687, 377 31,274 $31,274 PRELIMINARY BUDGET 9/19/2022 10:27 AM F-1 � 1 Okeechobee Utility Authority 2 FY23 Budget 3 Analysis of Operating Reserve Fund �(Maintain at 60 days expenses of current year System O& M) 7 8 FY23 System Operating Expenses (Budgeted) 9 10 FY23 60 Days O& M Expenses 11 12 Fund Balance at September 30, 2023 (Projected) 13 14 Fund Surplus (Shortage) 16 17 18 ution 22 - 05 lowered requirement to Fund � 8/31/2022 $8,797,708 1,446,199 1,401,608 (44,590) PRELIMINARY BUDGET 9/19/2022 10:27 AM G-1 Okeechobee Utility Authority FY23 Budget Analysis of Fire Hydrant Fund fire hydrant fund receive the following revenue monthly lential - $0.57/meter Residential - $1.71/meter �r - $0.57/meter Fund Balance at September 30, 2022 (Projected) Budgeted Additional Revenue in FY23 Interest Earnings Added to Fund Balance (Projected) Budgeted Hydrant Replacement Expenditures in FY23 Projects (TBD) Projected Fire Hydrant Fund Balance at September 30, 2023 8(3112022 $289,501 $94,205 $0 ($25,000) $0 $358,706 PRELIMINARY BUDGET 9/19/2022 1027 AM H-1 PRELIMINARY BUDGET 9/19/2022 10:28 AM J-1 Okeechobee Utility Authority Debt Service Summary FYE 9130123 9/30/24 9I30/25 9(30/26 9/30/27 9I30/28 9/30/29 9/30/30 Totals Last Updated 08/31/22 Truist DIS Sub Totai SRF D!S Sub Totai Total Annual 244,143 1,505,000 74,609 608,253 2,432,006 216,616 1,534,000 63,243 619,619 2,433,479 188,506 1,581,000 51,665 631,198 2,452,368 159,029 1,540,000 39,870 642,993 2,381,891 127,254 1,580,000 27,854 655,008 2,390,116 94,556 1,635,000 15,615 667,248 2,412,419 60,885 1,670,000 3,146 338,285 2,072,316 26,445 1,715,000 0 0 1,741,445 1,117,434 12,760,000 276,001 4,162,604 18,316,040 K-1 Okeechobee Utility Authority Debt Service Summary - Truist Bank Debt FYE Truist 2020A Ending Int.1.79% Prin. Refunded $16,390,000 on 411/2020 41112023 36,650.25 667,000.00 913012023 30,680.60 673,000.00 4/1(2024 24,657.25 679,000.00 9/30/2024 18,580.20 685,000.00 4l1/2025 12,449.45 691,000.00 9I30I2025 6,265.00 700,000.00 4/1I2026 9/30/2026 4/1/2027 9/30/2027 4/1l2028 9/30I2028 4/1l2029 9/30/2029 4/7/2030 9/30/2030 TOTAl.O/S 129,282.75 4,095,000.00 Truist 20206 Int.2.05% Prin. 87,996.25 87,125.00 86,253.75 85,382.50 84,408.75 83,435.00 75,593.75 67,650.00 59,603.75 51,455.00 43,101.25 34,696.25 26,188.75 17,578.75 8,866.25 988,151.25 � �. 775,000.00 785,000.00 795,000.00 815,000.00 820,000.00 830,000.00 9I19I2022 11:03 AM Last Updated 08/31/22 Truist Totai Debt Service 831. 673. 850,593. 863,101.25 864,696.25 866,188.75 867,578.75 873,866.25 13,877,434.00 K-2 Okeechobee Utility Authority Debt Service Summary - SRF Debt FYE Ending 9/30/23 9/30/24 9/30/25 9/30/26 9/30/27 9/30/28 9l30/29 9/30/30 Totals SRF#1 Int.1.86% Prin. 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 9/19/2022 11:03 AM Last Updated 08131122 SRF Total Debt Service � 682,862 682,862 341,431 0 K-3 Okeechobee Utility Authority FY23 Budget Notes to Labor Costs Page Line L-2 � Z 150 �Total Budgeted Labor costs as presented: ie above amount includes labor costs for all positions expected to be utilized fiscal year. 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 Labor Cost for Employees by $1.00/hr. to meet minimum wage change in Budgeted Labor cost vs. previous year's budget. Pension Contribution for the year total: 8/31/2022 $4,066,754 $0 $0 $47,862 $531,000 $123,968 (11,618) L-1 P R E LI M I NARY B U DG ET 9/19/2022 10:28 AM A B C D E F G H I � Okeechobee Utility Authority FY23 Budget 1 ! � _ _ i � _-- - - _ . � � z Projected General In-Fill Revenue I � aisvzozz _ — ,_ L -- - . � 3 Approved Rates from Resolution 22-04, Effective October 1, 2022 i � a _ __I � . __ i _ I _ _ __ - 5 WATER WASTEWATER 6 �i . li _ � I � - - _ ._ 7 � Capital Connection Charge Revenue —� Connections Revenue _ TotaI.CC � ..._CAddedtin S � Revenue Total CC. � $ Addedin I 10 _ � F253 � Per�431.00 .. $10,775.00� F123 I Pe$838.00I $10,056.00I 11 �_ I_ 1 _ f _ . � i. I- 12 ' I Install Fee Revenue I 13 � Revenue Per Total Instali I I Revenue Per ._ Total Install I�� 14 �� Residential Mtr � Fee Revenu��. �onnection �� Pee Revenue�� j . _ 15 25 I $266.00i $6,650.00I j 12 1 $555.00) $6,660.00 16 I � - I� ' � 1__ I . __ 17 � _ I 19 � �� _ Connection �� Revenue .�. �� Connection � Total AGRC �� I �� 18 � �I AGRC Per 1 ERC Total AGRC AGRC Per 1 ERC ... �Revenue ._I ... 20 Oct 19 2 1 0 00 0.00 1 i 0.00 0.00� 21 Nov 19 2 I 0.00 0.00� 1 � 0.00 �I O.00j 22 Dec- 9 .� 0.0� 0.0 � 1--- � 0.0� _ 0.00 1 0.00 O.00i 1 0.00 O.00I, 23 Jan-20; 2 I 2 0.00 0.00 1 26 A r 20 P � o.00 �_ o.00 I � o.00 � o.00 25 Mar 20i 2 I_" 0.00 j 0.00 i 1 0.00 � 0.00 27 May-20 2 i 0 00 , 0.00 i 1 0.00 ( 0.00� .__ .. __, : 28 Jun-20 2 i 0.00 I 0.00 1�0.00 � 0.00� _ 29 Jul-20 2 j 0.0� 0.00 I 1 I 0.00 � 0.00) 32 _� I _ � � I 0.00� 0.00! 31 Sep-20 3 I 0.00 0.00� � i 30 Aug 20 2 0.00 I 0.0 � 34 Totals 25 r $O.00j� 12 �i $0.00 . � I - �— � 35 ,. I �� Statict�cal Data: _.. ._ i � 36 i _ i '. Water Wastewater � 37 Pro�ected Number of adive connections � - � _ 38 �� Beginning of previous Fiscal Year �602 __ � 4483 � --_ __. --- _.. , --- i .__ ._ _... 39 � Beginning of Fiscal Yean I 9649 � � 4492 � _ _--- .___- -- - i - 40 i Pro�ected In-hli Growth rate I � 0 259 % 0.267 % � 41 � � .__ �� Average cost per new connection $697 �� $1,393 �� 'i 42 I � . __ - - .. I_ I. _ ! _ � a3 * AGRC was discontinued by OUA Board action on Sept. 13, 2021 j PRELIMINARY BUDGET 9/19/2022 10:40 AM N-1 Okeechobee Utility Authority Budget Summary Fiscal Year Octo6er 1, 2022 to September 30, 2023 REVENUES WATER UTILITY REVENUE WASTEWATER UTILITY REVENUE OTHER GENER,4L REVENUE RATE STABILIZATION FUNDS CAPITAI CONNECTION REVENUE CAPITAL ASSET/CAPITAL IMPROVEMENT PROJECTS-INTERNAI FUNDING CAPITA� IMPROVEMENT PROJECTS-GRANTlLOAN 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 OPER,4TING EXPENSES-METER READER DEPT DEBT SERVICE-INTEREST PAYMENTS DEBT SERVICE-PRINCIPAL PAYMENTS TRANSFERS & RESTRICTIONS GRANT & LOAN FUNDED CIP EXPENDITURES TOTALEXPENSES BUDGETED SURPLUS OR (DEFICIT) $ 7,335,575 4,425,602 327,188 0 20,831 2,778,775 17,156, 346 $ 32,044,317 $ 2,101,509 2, 541, 322 1,351,766 2,507,173 295,938 318,753 2,113,253 3,993,758 16,820,845 $ 32,044 317 $ PRELIMINARY BUDGET 9/19/2022 10:41 AM News - R