Loading...
OUA Annual Budget FY 2019-208/26/2019 Okeechobee Utility Authority FY20 Budget Table of Contents FY20 Budget Doc. Tab Pages A A-1 Significant Budgetary Assumptions A-2 to A-3 Notes to the Budget Summary of Sources & Uses Funds Statement A-4 to A-7 Budget Summary of Sources & Uses Funds Statement A-8 Summary of Debt Service Coverage Ratio Calculation and RSF Funding Required B B-1 Notes to Revenue Summary B-2 Revenue Summary B-3 to B-4 Revenue Detail C C-1 Notes to Expenditures Summary C-2 Expenditures Summary C-3 Operating Expense Summary by Department C-4 to c-17 Operating Expenses Detail by Department and Account C-18 to C-19 Non Operating Expenditures and Transfers D D-1 Additional Departmental O&M and Capital Expenditures D-2 Five Year Capital Improvement Plan Expenditure Detail (CIP) E E-1 Analysis of R R & I Fund Transfer (5% Prev FY Sys Oper Rev) F F-1 Analysis of Emergency Reserve Fund Transfer (Req 30 Days of O&M) G G-1 Analysis of Operating Reserve Fund Transfer (Strive for 90 Days of O&M) H H-1 Analysis of Fire Hydrant Fund K K-1 Debt Service Summary BB&T and SRF Combined K-2 BB&T Debt Service Summary Series 2017 A & 2017 B K-3 SRF Debt Service Summary L L-1 Notes to Labor Costs L-2 Projected Labor Costs by Department N 14-1 Projected General In -fill revenue from: WCC, WWCC & Install Fees 0 0-1 Projected Fund Balances and Expenditures for Capital Projects P P-2 10/20 Plan Developer CC Revenue R R-1 Budget Recap for Newspaper FINAL BUDGET 8/22/2019 7:23 AM Okeechobee Utility Authority FY20 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: Water and wastewater utility revenue has been projected using a weighted average model. The underlying data in this model utilizes actual revenue levels from the previous four fiscal years to determine the weighted average. Water and wastewater utility revenue includes the additional revenue from the projected customer infill growth of: Proposed Rate Increase for Water Utility Revenue: Proposed Rate Increase for Wastewater Utility Revenue: In summary, total operating revenue as presented is greater than the previous years budgeted levels by: O & M expense which may be subject to market volatility have been adjusted to reflect projected changes. Per cent change from FY19 budget is given below. Electric Services $ (1,500) Chemical Expenses (50,000) Fuels, Gas & Diesel Expenses $ 18,500 O&M Expenses (excluding labor) $ (124,058) Labor related expenses reflect the following: Total for Cost of Living Adjustment: $26,374 Total cost for Employee Merit Increase: $52,386 Total cost for Employee Bonus: $46,894 Total cost for Employee Health Care Increase: $70,560 Total cost of Urgent Care Services Increase: $0 Pension Contribution Annual Budget & Rate $349,248 In summary, total labor expense as presented is higher than the previous year budget by: FINAL BUDGET 8/29/2019 10:59 AM 8/29/2019 FY20 0.27% 0.0% 0.0% 0.55% -0.3% -7.9% 28.7% -3.33% 1.0% 1.5% 1.5% 14.5% 0.0% 14.2% 3.36% A-1 Okeechobee Utility Authority FY20 Budget Notes to the Budget Summary of Sources & Uses Funds Statement (Pages A4 -A6) Page Line 8/29/2019 A 4 7 General Utility Operating Revenue not including incremental $ 9,501,112 revenue from the FY10 & FY11 rate increases shown below: 8 totals as is shown in Expenditures Summary C-2 lines 5 through 24. The Incremental Rate Revenue from both the FY10 and FY11 A-4 40 rate increases is shown separately under Other Sources of $ 879,121 0 Funds and is projected to total: 28 & 29 The remaining capital connection revenue in the amount of: Total operating revenue is greater than the previous year's 0.55% budgeted amount by: $ 67,760 A 4 10 Total Operating Expenses is composed of five departmental $ 1,734,303 A-4 8 totals as is shown in Expenditures Summary C-2 lines 5 through 24. $ 7,587,851 Total operating expense (including labor) as presented is 0.07% higher than the previous years budgeted amount by: $ 5,595 A 4 10 Senior Debt Service consists of both BB&T series 2017A & series 20178 Bank Loans. $ 1,734,303 See Tab K pages K-3 for the detail on each indebtedness. See Tab K for the detail for each debt issue. 31 A 4 12 Approximately 48% of the restricted revenue category is $ 75,000 See Tab K pages K-3 for the detail on each indebtedness. A 4 31 derived from the scheduled non ad valorem special assessments from developers' in the 10/20 plan for wastewater capital connection charges of: $ 150,058 A-4 30 And for water capital connection charges of: 0 A-4 28 & 29 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. (1) $ 18,258 A 4 12 As presented, the Budget projects utilization of Rate Stabilization Funds in the amount of: $ 75,000 A-4 22 Annual Junior Debt Service consists of one SRF loan: $ 682,862 See Tab K pages K-3 for the detail on each indebtedness. (1) Assumes Capital Connection Charges (CCC) and Installation Fees stay at 75% discount levels. The FY20 budget at 100% would have $83,562 greater budgeted revenue from in -fill CCC and install fees.. FINAL BUDGET A-2 8/29/2019 10:56 AM Okeechobee Utility Authority FY20 Budget Notes to the Budget Summary of Sources & Uses Funds Statement (Pages A4 -A6) Pane Line A-4 38 Total interest income revenue on restricted account balances has been projected based on the extremely low current yields $ 318,132 A-4 37 on qualified public funds accounts and with the expectation that these low yield levels will likely continue through the proposed budget cycle. $ 65,821 A-4 38 Restricted revenues are credited to their respective fund 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: $ 318,132 A-5 91 Total Projected Fund Balances at September 30, 2019 $ 6,609,531 As presented, the Budget Summary anticipates that the $ 18 588,831 A 4 43 portion of the projected additional revenue derived from both the FY10 and FY11 rate increases that will be used for current year SRF Debt Service totals: $ 879,121 A 4 66 The remaining revenue will be transferred to the Rate Stabilization Fund at year end: $ 232,658 As presented the Budget projects utilization of Operating A-4 60 Funds to increase the Emergency Reserve Fund to its $ 1,044 minimum requirement by adding funds in the amount of: A-5 91 Total Projected Fund Balances at September 30, 2019 $ 6,609,531 See worksheet in section 0 for a detailed analysis of the projected balances $ 18 588,831 A-5 107 Projected Net Additions to Fund Balances From Transfers in FY20 $ 768,350 $ 18 588,831 This amount represents the expected transfers to the individual funds as further detailed in the worksheet in tab O. Proposed capital expenditures are found listed in Tab D, sheet D-2 and Tab 0 A-6 153 Proposed Capital Improvement Project and departmental capital request expenditures for FY19 total: $ 18 588,831 Proposed capital expenditures are found listed in Tab D, sheet D-2 and Tab 0 The proposed expenditures are not listed in any order of priority. A-6 172 FINAL BUDGET Total Projected Fund Balances at September 30, 2020 $ 3,781,885 See worksheet in Tab 0 for a detailed analysis of the projected balances A-3 8/29/2019 10:56 AM FINAL BUDGET 8/29/2019 10:53 AM AIBICI D I E 1 F G H 1 Okeechobee Utility Authority FY20 Budget Budget Summary Sources & Uses of Funds Statement Water 0.00% 0.00% 2 Sewer 3 4 6/29/2019 5 6 FUNDS FROM GENERAL UTILITY OPERATING REVENUE SOURCES: FY20 Budget 7 General Utility Operating Revenue (Not including revenue from Fria & 11 rate Inueases) 9,501,112 8 Total Operating Expenses (7,587,851) 9 Funds needed from Rate Stabilization Fund 75,000 10 Net General Utility Operating Revenue (Available for Bear ors) 1,988,261 11 Total BB&T Debt Service Payments and Budgeted DSc Ratio (1,734,303) 115% 12 Remaining General Utility Oper Rev (After BB&T 0/9 Available for SRF o/S) 253,958 13 FUNDS PROVIDED FROM RESTRICTED REVENUE SOURCES: 14 Transfers In From Restricted Funds to Meet SRF Debt Service: 15 Transfer In From 10/20 W W CCC Fund 0 16 Transfer In from RR&I Fund Surplus (See Tab 9, cell 919) 0 17 Transfer In from Emergency Reserve Fund Surplus (See Tab F. cell B16) 0 18 Transfer In from Operating Reserve Fund Surplus (Sae Tab G, cell ale) 0 19 FY10 & FY11 Rate Increase Revenue used for current SRF Debt Service 879,121 20 I Total Restricted Funds used for SRF Debt Service 879,121 21 Less Senior Lien Coverage Factor at 10% (only utilized in DSC calculation) (173,430) 22 Less Junior Lien Coverage Factor at 20% (only utilized in DSC calculation) (136,572), 23 Sub -Total 823,076 24 Total SRF Debt Payments and Budgeted DSC Ratio (682,862) 121% 25 Sub -Total 140,214 26 27 Remaining General Operating Revenue and Funds from both DCoverage Factors 450,217 28 29 OTHER SOURCES OF FUNDS; 30 Restricted Revenue: 31 Water Capital Connection Charge Revenue From Will 9,450 32 Wastewater Captial Connection Charge Revenue From Infill 8,008 33 Water Capital Connection Charge Revenue From 10/20 Developers 0 34 Wastewater Capital Connection Charge Revenue 10/2o Developers 150,058 35 WW Capital Connection Revenue (Indirectly Through Tax Cenifcate Process) 0 36 Fire Hydrant Fund Fees 83,996 37 Restricted Interest Income 65,821 38 Sub -Total Restricted Revenue 318,132 39 40 Incremental Rate Revenue from FY10 & FY11 Rate Increases: 41 Continuing Revenue From FY10, 6% Rale Increase 543,226 42 Continuing Revenue From FY11, 3.5% Rate Increase 335,895 43 Total Incremental Revenue from FY10 & FY11 Rate Increases 879,121 44 Amount earmarked towards current SRF Debt Service Payments (879,121) 45 Subtotal 0 46 Funds Transferred to Future CIP, earmarked 0 47 Remaining Rate Increase Revenue 0 4B 49 Total Funds Available for Required & Discretionary Capital Transfers 768,349 50 51 Requ red Capital Transfers: 52 Transfer Into Fire Hydrant Fund (83,996) 53 Transfer of Interest Income Shown Above Into Respective Restricted Funds (65,821) 54 Transfer to Operating Reserve Fund (strive to maintain 90 days of D&M)sheet G cell B14 (154,358) 55 Transfer Into Water CCC Fund (from Water In -fill Revenue) (9,450) 56 Transfer Into Water CCC Fund (from Water 10/20 Plan) 0 57 Transfer Into W W CCC Fund (from W W In -fill Revenue) (8,808) 58 Transfer Into WW CCC Fund (from 10/20 Plan After SRF Debt Service Payments) (150,058) 59 Transfer Into RR&I Fund (to be maintained at 5% of Pam. Year System Revenue) (12,157) 60 Transfer Into Emergency Reserve Fund (to be malmalned at 30 days Oper Exp) (1,044) 61 Total funds used for Required Capital Transfers (485,692) 62 63 Discretionary Capital Transfers: 64 Transfer to Operating Reserve Fund (strive to maintain 90 days of o&M) 65 - Inter -fund Transfer to Future CIP (50,000) 66 Inter -fund Transfer to Rate Stabilization Fund (232,658) 67 Transfer into Future CIP Fund Earmarked for 68 Total funds used for Discretionary Capital Transfers (282,658) 69 70 Total funds used for Required & Discretionary Capital Transfers (768,350) 71 72 REMAINING REVENUE FUNDS AVAILABLE FOR OTHER LAWFUL PURPOSES (0) 73 A4 FINAL BUDGET 8/29/2019 10:53 AM FINAL BUDGET 8/29/2019 10:53 AM AIB CI D E 1 F 1 G H 74 FUNDING SOURCES: .1 FY20 Budget 75 Fund Balance Reserves at October 1, 2019 (Projected): 76 Restricted by Bond Covenants/Loan Documents: 77 RR&I Fund (Must be maintained at 5% or Prior Year System Revenue) 504,013 78 Capital Connection Fund -Water 476,826 79 Capital Connection Fund -Sewer 314,843 80 Capital Connection Fund -Sewer 10/20 Plan (Restricted for W WIP os) 643,090 61 Fire Hydrant Fund 58,146 82 Sub -Total 1,996,919 83 Restricted by Board Policy: 84 General Operating & Payroll & Account Funds 619,285 85 PTO Account Fund 234,50D 86 Emergency Reserve Fund (Must be maintained at so day Oper Exp.) 622,615 87 Operating Reserve Fund (Stave for 90 Days or Oper Exp) 1,716,619 88 Future CIP Funding (Strive to maintain at 5% of Prior Year System Revenue) 506,713 89 Rate Stabilization Fund 912,880 90 Sub -Total 4,612,612 91 Total Fund Balance Reserves at October 1, 2019 (Projected) 6,609,531 92 93 Charles to Fund Balance Reserves (From Transfers during FY2D): 94 Transfer into RR&I Fund (Must he maintained at 5% of Prior Year System Revenue) 12,157 95 Transfer into CCC Fund -Water (from in -fill) 9,450 96 Transfer Into CCC Fund-Water(from10/20 Plan) 0 97 Transfer Into CCC Fund -Sewer (from in -fill) 8,808 98 Transfer Into CCC Fund -Sewer 10/20 Plan (Net of SRF Debt Service Payments) 150,058 99 Transfer Into Fire Hydrant Fund 83,996 100 Transfer into PTO Account Fund (Net of withdrawals) 0 101 Transfer into Emergency Reserve Fund (Must be maintained at 30 days Oper Exp) 1,044 102 Transfer into Operating Reserve Fund (Stdvo to maintain at 90 days oro & M) 154,358 103 Transfer into Future CIP Funding (strive to maintain at 5% of Pdor Year Gross Rev) 50,000 104 Transfer into Discretionary Rate Stabilization Funds 232,658 105 Transfer Into Future CIP Fund Earmarked for 106 Transfers into Restricted Accounts from Interest Income 65,821 107 Total Additions into Fund Balance Reserves (From Transfers In FY20) 768,350 108 109 Total Fund Balance Reserves (Projected) 7,377,881 110 Funding Sources for proposed Construction Project Expenditures: 111 Water conservation grant to obtain 360,041 112 Funding From State Appropdatlon for Lakeview Estates WWTF 1,000,000 113 Funding From Stale Appropriation for SW section WW (Septic to Sewer Project) 523,867 114 Funding From loan/grants to be obtained for SW section WW (Septic to Sewer Project) 13,183,928 115 Total Funding Sources from Grants & Loans 15,067,836 116 117 TOTAL FUNDS AVAILABLE FOR CAPITAL EXPENDITURES & FUND BALANCE RESERVES 22,445,716 110 A-5 FINAL BUDGET 8/29/2019 10:53 AM FINAL BUDGET 8/29/2019 10:53 AM AJBIC1 0 E 1 F 1 G 1 H 119 PROPOSED CAPITAL EXPENDITURES DURING FY20: FY20 Budget 120 Funds from Rate Stabilization Fund used as Operating Revenue State funding for Lakeview Estates: experimental WWTF 75,000 121 1,000,000 122 Proposed SW Section WW Project (septic to sewer project) Capital Improvement Project Expenditures: 13,950,000 123 124 FLDOT: U5441 SE © SE 18th Terrace (TCI) traffic circle 391,000 125 SE 8th Ave Water Main Installation 500,000 126 SE 28th St Water Main Install 275,000 127 Generator- Vac Station 112150Kw 125,000 128 Water Main Installation (System Wide) 150,000 129 AMI Meter Installation project In Buckhead & SW 720,081 130 Sub -total 2,161,081 131 CIP Expenditures and Maintenance & Rehab Proposed for FY20: 132 Lift Station Pump Replacements 32,000_ 133 Scada System 25,000 134 Gravity Sewer Repair& Rehabilitation 100,000 135 Generator -Lift Stations 50,000 136 LIR Station Rehabilitation NW18; 5W13; & NE2 50,000 137 Vacuum Pump Replacement 25,000 138 Water Main Repair & Replacement (System Wide) 150,000 139 Manhole Rehabilitations (30 x $2,400 each) 72,000 140 LIR Station Electrical Panels - 7 Stations 110,000 141 Fire Hydrant Replacements (nominal) 25,000 142 Sub -total 639,000 143 144 Total Proposed Capital Improvement Project Expenditures 2,800,001 145 146 Proposed Departmental Capital Expenditures: (Detail on D-1) 147 Administration (water and wastewater master plans) 350,000 148 Maintenance 340,250 149 Water 42,000 150 Wastewater 106,500 151 Meter 0 152 Total Proposed Departmental Capital Expenditures 038,750 153 154 Grand Total of Proposed Capital Funds Expenditures 18,588,831 155 156 PROJECTED RESERVES END OF FISCAL YEAR 157 Fund Balance Reserves at September 30, 2020 (Projected): 158 Restricted by Bond Covenants/Loan Documents: 159 RR&I Fund (Must be maintained at 5% of Prior Year System Revenue) 526,170 160 Capital Connection Charge Fund -Water 11,276 161 Capital Connection Charge Fund -Sewer 16,651 162 Capital Connection Charge Fund -Sewer 10/20 Plan (Restricted for VWyrP DS) 486,648 163 Fire Hydrant Fund 117,142 164 Sub -Total 1,157,888 165 Restricted by Board Policy & General Operating Funds 166 General Operating & Payroll Account Funds 1,494 167 PTO Account Fund 500 168 Emergency Reserve Fund (Must be maintained at 30 day Oper Exp.) 636,059 169 Operating Reserve Fund (Strive for 90 Days of Oper lap) 1,897,627 170 Future CIP Funding (seive to maintain at 5% of Prior Year System Revenue) 34,213 171 Rate Stabilization Fund 54,104 172 Sub -Total 2,623,997 173 Fund Balance Reserves at September 30, 2020 (Projected) 3,781,885 174 175 TOTAL PROPOSED CAPITAL EXPENDITURES AND FUND BALANCES 22,370,716 176 177 REMAINING FUNDS $0 A-6 181 FINAL BUDGET 8/29/2019 10:53 AM FINAL BUDGET 8/29/2019 10:53 AM AIBICI D 1 E 1 F 1 G 1 H 182 Okeechobee Utility Authority 183 FY20 Budget 184 Budget Summary 6/29/2018 185 Debt Service Coverage Tests 186 187 Senior Lien Debt Service Coverage Analysis (110% Required) 188 189 General Utility Operating Revenue (line 7 above) 9,501,112 190 LessTotal Oper Exp (line a above) (7,507,051) 191 Funds needed from Rate Stabilization Fund 75,000 192 Net General Utility Operating Revenue 1,988,261 193 194 Total Current Year Operating Revenue for Senior Lien Coverage Test 1,988,261 195 196 Senior Lien Debt Service (1,734,303) 115% 197 198 Remaining General Utility Oper Rev After BB&T Debt Service 253.950 199 200 Senior Lien Coverage 201 FOR SRF 202 Junior Lien Debt Coverage Analysis (115% for SRF)J120 % for RSF). COVERAGE 203 204 Remaining General Utility Oper Revenue After BB&T Debt Service 253,956 205 Less Senior Lien Coverage Factor at 10% (173,430) 206 Less Junior Lien Coverage Factor at 20% (136,5721 207 Less Incremental Rate Revenue from FY10 s FY11 rate Increases added above 879,121 208 Available Revenue for Junior Lien DSC Calculation 823,076 121% 209 210 Junior Lien Revenue Requirement Per SRF Coverage at 115%: 211 Junior Lien Debt Service 682,862 212 Add Junior Lien Coverage for SRF 136 572 213 Total Operating Funds required to meet SRF debt coverage ratio 819,435 214 215 A-7 FINAL BUDGET 8/29/2019 10:53 AM Okeechobee Utility Authority FY20 Budget Notes to Revenue Summary Page Line 0/29/2019 B-2 8 to 12 Grand Total Operating Revenue is composed of five classifications of operating income shown in Revenue Summary tab B lines 8 through 12. 10,380,233 B-3 18 Total Water Utility Revenue 6,289,975 B-3 15 Total water utility revenue above includes the ongoing effect from the FY10 6.0% rate increase with projected incremental water utility revenue totaling: 334,783 B-3 16 Also, total water utility revenue includes the ongoing effect from the FY11 3.5% rate increase with projected incremental water utility revenue totaling: 207,007 FY19 water utility revenue has been projected utilizing OUA's 4 year weighted average model. B-3 29 Total Sewer Utility Revenue 3,853,686 B-3 26 Total sewer utility revenue above includes the ongoing effect from the FY10 6.0% rate increase with projected incremental sewer utility revenue totaling: 208,443 B-3 27 Also, total sewer utility revenue includes the ongoing effect from the FY11 3.5% rate increase with projected incremental sewer utility revenue totaling: 128,887 FY15 sewer utility revenue has been projected utilizing OUA's 4 year weighted average model. 8-3 31 Penalties & Late Charges 110,750 B-4 62 Total Capital Connection Charges 168,316 As previously noted, other than the scheduled 10/20 developer special assessments, the growth rate in new capital connections from in -fill is projected at approximately: 0.27% FINAL BUDGET 8/29/2019 10:46 AM B-1 A G H J K 1 2 3 4 5 6 7 Okeechobee Utility Authority FY20 Budget Revenue Summary Operating Revenue: FY19 Budget 8 Total Water Utility Revenue (see B-3 Line 18) 6,203,693 9 Total Sewer Utility Revenue (see B-3 Line 29) 3,901,194 10 Penalties & Late Charges (see B-3 Line 31) 109,348 11 Miscellaneous Revenue (see B-3 Line 33) 39,438 12 Total Other Operating Revenue (see B-3 Line 38) 69,734 13 Grand Total Operating Revenue (see B-3 Line 40) 10,323,407 14 15 Non -Operating Revenue: 16 Gain/Loss Sale of Fixed Assets (see B-4 Line 43) 0 17 Fire Hydrant Fund Fees (see B-4 Line 45) 73,062 18 Total Restricted Interest (see B-4 Line 56) 34,360 19 Total CCC Revenue (Direct) (see B-4 Line 62) 78,805 20 Total CCC Revenue (Indirect) (see B-4 Line 65) 0 21 Total Contributed Capital (see B-4 Line 69) 0 22 Rate Stabilization Fund Transfer 0 23 Grand Total Non -Operating Revenue (see B-4 Line 72) 186,227 24 25 Grants, Loans & CIP Funding: 26 Internal Funding for CIP & Departmental Capital Expenditures 8,505,756 27 Internal Funding (Rate Stabilization Fund) for SRF Debt Service + funding for Operating Reserve and for Emergency Reserve Funds 183,898 28 External Funding for Construction Projects 957,741 29 Total Grants, Loans & CIP Funding (see B-4 Line 80) 9,647,395 30 31 GRAND TOTAL REVENUE (see B-4 Line 82) 20,157,029 34 0.00% 0.00% 8/29/2019 FY20 Budget 6,289,975 3,853,686 110,750 48,624 77,198 10,380,233 0 83,996 65,821 168,316 0 0 75,000 393,132 3,638,831 0 15,067,836 18,706,667 29,480,032 B-2 FINAL BUDGET 8/29/2019 10:08 AM FINAL BUDGET 8/29/2019 10:03 AM B-3 A H N 0 _ P 1 Okeechobee Utility Authority 8/29/2019 2 FY20 Budget 3 Revenue Detail 4 FINAL FY19 FY20 5 (1) revenue budget assumes capital connection charges and related installation fees will remain at 75% discount levels. Budget Budget 6 Amount Amount 7 OPERATING REVENUE 8 Water Utility Revenue 5,509,401 5,579,713 (2) 9 Water AGRC Revenue (from in -fill connections) 3,783 6,250 (1) 10 Water GRC Revenue 16,956 25,216 11 Install Fees Water 5,300 6,250 (1) 12 Private Fire Protection 66,612 68,166 13 Tum On/Off Fees 49,920 48,854 14 Other Revenue Water 16,758 13,736 15 Incremental Water Rev From 6.0% Rate Increase in FY -10 330,564 334,783 (2) 16 Incremental Water Rev From 3.5% Rate Increase in FY -11 204,399 207,007 (2) 18 Total Water Utility Revenue 6,203,693 6,289,975 19 20 Wastewater Utility Revenue 3,525,522 3,474,053 (3) 21 Wastewater AGRC Revenue (from In -fill connections) 2,622 6,000 (1) 22 Wastewater GRC Revenue 11,186 8,114 23 Install Fees Wastewater 5,844 6,000 (1) 24 Kings Bay Wastewater Maintenance Fee 12,462 11,612 25 Other Revenue Wastewater 1,230 10,576 26 Incremental Wastewater Rev From 6.0% Rate Increase in FY -10 211,531 208,443 (3) 27 Incremental Wastewater Rev From 3.5% Rate Increase in FY -11 130,797 128,887 (3) 29 Total Wastewater Utility Revenue 3,901,194 3,853,686 30 31 Penalties & Late Charges 109,348 110,750 32 33 Miscellaneous Revenue 39,438 48,624 34 35 Interest Operating Account 69,566 76,804 36 Interest on 10/20 Extended Payment Plan 0 0 37 Interest Payroll Account 168 394 38 Total Unrestricted Interest Revenue 69,734 77,198 39 40 GRAND TOTAL FROM OPERATING REVENUE 10,323,407 10,380,233 41 FINAL BUDGET 8/29/2019 10:03 AM B-3 FINAL BUDGET 8/29/2019 10:03 AM B-4 A H N 0 P 1 Okeechobee Utility Authority 8/29/2019 2 FY20 Budget 3 Revenue Detail 4 FINAL FY19 FY20 5 (1) revenue budget assumes capital connection charges and related installation fees will remain at 75% discount levels. Budget Budget 42 NON-OPERATING REVENUE Amount Amount 45 Fire Hydrant Fund Fees 73,062 83,996 46 47 Interest -Water CCC Fund 0 0 48 Interest -Wastewater CCC Fund 0 0 49 Interest -10/20 WWTP Expansion Fund 0 0 50 Interest-RR&I Funding Required accrued 6,268 10,000 51 Interest -Fire Hydrant Fund 0 0 52 Interest -Future CIP Funding 0 0 53 Interest -Rate Stabilization Fund & Debt Service Fund 4,560 16,771 54 Interest -Operating Reserve Fund (90 day O&M) accrued 16,384 26,650 55 Interest -Emergency Reserve Fund (30 day O&M) accrued 7,148 12,400 56 Total Restricted Interest 34,360 65,821 57 58 Water CCC from in -fill 9,450 9,450 (1) 59 Wastewater CCC from in -fill 8,808 8,808 (1) 60 Water CCC from 10/20 Plan (Net assessment received from developer) 0 0 61 WWTP CCC 10/20 Plan (Net assessment received from developer) 60,547 150,058 62 Total W&WW CCC Revenue (Direct) 78,805 168,316 63 Water CCC from 10/20 Plan (Assesments through Tax Cert process) 0 0 64 WWTP CCC from 10/20 Plan (Assessments through Tax Cert process) 0 0 65 Total CCC Revenue (Indirect) 0 0 66 67 Contributed Capital 0 68 Kings Bay Contributed Capital 0 69 Total Contributed Capital 0 70 71 Internal Funding from RSF 75,000 72 GRAND TOTAL NON-OPERATING REVENUE 186,227 393,132 73 74 GRANTS, LOANS & CIP FUNDING 75 Internal Funding for CIP Expenditures 7,036,840 2,800,081 76 Internal Funding for SRF Debt Service (from Restricted Funds) 183,898 0 77 Internal Funding for Departmental Capital Expenditures 1,468,916 838,750 78 External Funding -State Programs 523,867 1,523,867 79 External Funding from loans/grants to obtain 433,874 13,543,969 80 GRAND TOTAL GRANTS & INTERNAL FUNDING 9,647,395 18,706,667 81 82 GRAND TOTAL SOURCES OF FUNDS 20,157,029 29,480,032 83 (1) revenue budget assumes capital connection charges and related installation fees will remain at 75% discount levels. 84 (2) increase in water consumption from replacement of meters 85 (3) decrease in usage of wastewater services FINAL BUDGET 8/29/2019 10:03 AM B-4 Okeechobee Utility Authority FY20 Budget Notes to Expenditures Summary: Page Line 8/29/2019 C-2 26 Total Departmental Operating Expense: $7,587,851 Total Operating expense (including labor) as presented is higher 0.07% than the previous years budgeted amount by: $5,595 C-4 to C-17 In the detailed expense listing shown on pages C-4 through C-17, most expense classifications have been assigned a budgetary value based on either a specific contract amount or an analysis of the current year to date operating expenses projected to year end. However, several selected O&M expense classifications in each department has been historically subject to market fluctuations have been assigned a specific projected inflation factor. For example: Electrical expenses are assigned a specific budgetary value or an adjusted amount based on a projected inflation factor of: -0.31 Chemicals are assigned a specific budgetary value or an adjusted amount based on a percent change FY19 budget: -7.94% Fuel, gas, diesel & general petroleum based commodities have been assigned a specific budgetary value or an adjusted amount based on a percent change from FY19 budget: 28.72% Many other expense classifications have been assigned a specific budgetary amount for an increase of: -3.33% C-1 FINAL BUDGET 8/29/2019 9:57 AM G 1 2 3 4 5 6 7 8 Okeechobee Utility Authority FY20 Budget Expenditures Summary Operating Expenses Admin/Exec. Labor, (includes $27,851 for Urgent Care Services) Admin/Exec. 0 & M Total Administration / Executive Expenses 9 10 11 Maintenance Labor Maintenance 0 & M 12 Total Maintenance Expenses 13 14 15 16 Water Labor Water O & M Total Water Expenses 17 18 19 Wastewater Labor Wastewater 0 & M 20 Total Wastewater Expenses 21 22 23 24 Meter Labor Meter 0 & M Total Meter Reader Expenses 25 26 Grand Total Operating Expenses 27 28 Non -Operating Expenses 29 Debt Service Interest Expense 30 Amortization Expense 31 Depreciation Expense 32 Grand Total Non -Operating Expenses 33 34 Transfers 35 Debt Service Principal Payments 36 37 38 39 Required Transfers to Funds from Restricted Revenue Required Transfers Into Funds from Pledged Revenue net of Junior Debt Service Discretionary Transfers From Restricted Funds Other Transfers 40 Grand Total Transfers 41 42 GRAND TOTAL EXPENDITURES 4.3 44 GRAND TOTAL EXPENDITURES WITHOUT NON-CASH AMORTIZATION & DEPRECIATION EXPENSE FY19 Budget 1,089,285 1,315,840 2,405,125 1,398,532 854,150 2,252,682 531,652 1,067,243 1,598,895 609,620 458,330 1,067,950 226,686 30,918 257,604 7,582,256 640,486 22,200 2,660,000 3,322,686 2,096,900 125,680 60,547 187,662 9,463,497 11,934,286 22,839,228 20,157,028 0/29/2019 FY20 Budget 1,155,062 965,854 2,120,916 1,388,899 1,074,350 2,463,249 595,520 1,032,585 1,628,105 613,278 493,730 1,107,008 232,668 35,904 268,572 7,587,851 531,775 22,200 2,660,000 3,213,975 1,885,391 168,075 150,058 450,217 18,706,667 21,360,406 32,162,232 29,480,032 C-2 FINAL BUDGET 8/29/2019 9:54 AM FINAL BUDGET 8/29/2019 9:48 AM C-3 A 1 B 1 D I E I L Okeechobee Utility Authority FY20 Budget 8/29/2019 Operating Expense Summary by Department 2 3 4 FY19 FY19 Budget Department Amount 5 FY20 FY 20 Budget Amount 6 7 8 Summary Labor: Administration 1,089,285 1,155,062 g Maintenance 1,398,532 1,388,899 10 Water 531,652 595,520 11 Wastewater 609,620 613,278 12 Meter 226,686 232,668 13 Total Labor 3,855,775 3,985,428 14 15 16 Summary 0 & M: Administration 1,315,840 965,854 17 Maintenance 854,150 1,074,350 18 Water 1,067,243 1,032,585 19 Wastewater 458,330 493,730 20 Meter 30,918 35,904 21 Total 0 & M 3,726,481 3,602,423 22 23 24 25 Summary Dept Total: Administration 2,405,125 2,120,916 26 Maintenance 2,252,682 2,463,249 27 Water 1,598,895 1,628,105 28 Wastewater 1,067,950 1,107,008 29 Meter 257,604 268,572 30 Total Department Expenses 7,582,256 7,587,851 37 38 39 FINAL BUDGET 8/29/2019 9:48 AM C-3 FINAL BUDGET 8/29/2019 9:48 AM C-4 A I B I D I E I L 40 Okeechobee Utility Authority FY20 Budget Operating Expense Detail by Department and Account 8/29/2019 41 42 43 Administration Labor: Account Number Account Description FY19 FY19 Budget Amount 44 FY20 FY 20 Budget Amount 4s 46 47 401-3-513-1100-100 Executive Salaries 296,002 307,953 46 401-3-513-1101-100 Supervisors 130,832 134,102 49 401-3-513-1200-100 Regular Salaries 324,407 361,667 so 401-3-513-1201-100 On Call non -pension admin 0 0 51 401-3-513-1202-100 Bonus Pay Admin 0 0 52 401-3-513-1300-100 Accrued Payout Ad min (PTO) 13,880 14,849 53 401-3-513-1400-100 Overtime 7,152 7,485 54 401-3-513-1600-100 Accured Wages and FICA 0 0 55 401-3-513-1610-100 Accrued Benefits and FICA 0 0 56 401-3-513-2100-100 FICA 59,079 63,193 57 401-3-513-2200-100 Retirement 118,433 103,977 56 401-3-513-2300-100 Health Insurance 104,160 126,000 59 401-3-513-2301-100 Disability Insurance 3,020 2,840 60 401-3-513-2302-100 Life Insurance 2,520 3,060 61 401-3-513-2400-100 Workmens Compensation 1,949 2,085 62 401-3-513-2500-100 Unemployment Compensation 0 0 63 401-3-513-3400-213 Urgent Care Services 27,851 27,851 69 70 Admin Labor Subtotal 1,089,285 1,155,062 71 72 FINAL BUDGET 8/29/2019 9:48 AM C-4 FINAL BUDGET 8/29/2019 9:48 AM C-5 A 1 B ( D J E L 73 74 7s 76 FY19 Administration O&M: FY19 Budget Account Number Account Description Amount FY20 FY 20 Budget Amount 401-3-513-5100-101 Office Equipment 1,500 3,350 77 401-3-513-1620-100 Accrued OPEB 4,900 3,500 78 401-3-513-3100-200 Legal Service -General Counsel 35,000 35,000 79 401-3-513-3100-202 Legal Sery-Dev Matters -Other 2,500 1,500 80 401-3-513-3100-203 Legal Serv-Easement Matters 2,500 2,500 81 401-3-513-3100-204 Legal Sery-EEOC 0 0 82 401-3-513-3100-205 Legal Sery-Dev Matters -Royal 0 0 83 401-3-513-3100-206 Legal Serv-Dev Matters-CIB Marine(LVA) 0 0 84 401-3-513-3100-207 Legal Serv-Dev Matters -Seacoast (Freshwat 0 0 85 401-3-513-3100-208 Board Meeting Compensation ($250 x 12) 0 3,000 86 401-3-513-3100-204 Legal Serv-Land Trust v OUA 0 25,000- 5,00087 87 401-3-513-3101-200 Engineering Fees 25,000 25,000 88 401-3-513-3101-201 Enq Fees -Water General 5,000 5,000 as 401-3-513-3101-202 Enq Fees -Water Quality Improv. 30,000 30,000 90 401-3-513-3101-203 Eng Fees -WW General 10,000 10,000 91 401-3-513-3200-200 Accounting & Auditing 25,000 25,000 92 401-3-513-3400-200 Other contract serv(surveys, 1095C, Misc.) 20,000 20,000 93 401-3-513-3400-201 Utility Sery Co (Moved to Water Dept) 0 0 94 401-3-513-3400-202 Financial Advisor 2,500 2,500 95 401-3-513-3400-203 PRMG-Consultant Services 15,000 15,000 96 401-3-513-3400-204 CAS & Assoc -Legislative Sery 36,000 36,000 97 401-3-513-3400-205 Thorn Run -Legislative Sery 40,000 0 98 401-3-513-3400-206 One -Call Sery 7,500 6,500 99 401-3-513-3400-207 ADP -Payroll Services 23,500 24,500 100 401-3-513-3400-212 ADP -Easy Labor Management Fees 4,000 4,000 101 401-3-513-3400-208 Random Drug Program Costs 3,000 2,000 102 401-3-513-3400-210 Safety Matters -Consulting Serv. & Supplies 4,000 3,000 103 401-3-513-3400-211 Pension Related Matters 10,000 5,000 104 401-3-513-3400-216 Bank Service Fee CSB 9,400 9,400 los 401-3-513-4000-100 Travel and Per Diem 3,000 2,000 166 401-3-513-4100-100 Communication Service 250 250 107 401-3-513-4100-101 Com Serv-Comcast Embarq 7,500 7,500 108 401-3-513-4100-102 Com Serv-Verizon Cellular 1,000 1,000 los 401-3-513-4100-104 Com Serv-Reimbursements 1,500 1,500 110 401-3-513-4100-105 Com Serv-Ans Services 0 0 111 401-3-513-4100-106 SLERS Radio Maint Fee (7x$9x12) 750 750 112 401-3-513-4100-107 SLERS Antenna Maint Fee (7x$9x12) 750 0 113 401-3-513-4675-100 SLERS R&M -Admin 0 0 114 401-3-513-5215-100 Safety Supplies 750 1,750 115 401-3-513-4200-100 Postage and Transportation 40,000 45,000 116 401-3-513-4300-100 Utilities -FPL 8,500 7,500 117 401-3-513-4301-100 Utilities Waste Management 1,400 1,400 FINAL BUDGET 8/29/2019 9:48 AM C-5 FINAL BUDGET 8/29/2019 9:48 AM C-6 A I B I 0 L E L 118 Administration O&M: Account Number Account Description FY19 FY19 Budget Amount FY20 FY 20 Budget Amount 119 12o 121 401-3-513-4400-101 Pitney Bowes Post Mach Lease 1,100 1,105 122 401-3-513-4400-102 Copier Leases & Usage Costs 6,000 6,000 123 401-3-513-4500-200 Insurance -Prop, Cas & Gen Liab 315,000 330,000 124 401-3-513-4500-201 Insurance -Pollution Policy 12,944 14,944 125 401-3-513-4500-202 Insurance -Storage Tank Policy 1,679 2,000 126 401-3-513-4600-100 R&M Vehicles 1,500 1,500 127 401-3-513-4609-100 R&M Building Admin 10,000 10,000 128401-3-513-4611-100 R&M Equipment 1,500 1,250 129 401-3-513-4612-100 R&M Comp Equipment 1,500 1,500 130 401-3-513-4613-100 R&M Comp Software (Springbrk) 35,000 35,000 131 401-3-513-4613-101 Comp Sys, HW / SW Upgrades & IT Sery 10,000 12,500 132 401-3-513-4613-102 IT Outsourced Services 9,000 9,000 133 401-3-513-4615-100 Lawn Service Admin 2,520 750 134 401-3-513-4675-100 Shrinkage Expense 0 0 135 401-3-513-4700-200 Printing and Binding 18,000 20,000 136 401-3-513-4901-100 Education-Springbrook & General 8,000 9,000 137 401-3-513-4902-200 Advertising 4,000 4,000 138 401-3-513-4902-201 Website/Webhosting Exp E -billing 2,000 2,000 139 401-3-513-4905-200 Bad Debt Expense 1,500 42,500 140 401-3-513-4909-100 Miscellaneous 12,500 12,500 141 401-3-513-5100-100 Office Supplies 8,500 8,500 142 401-3-513-5201-100 Fuel Gas & Diesel - Vehicles 2,160 2,160 143401-3-513-5203-100 Uniforms 2,500 1,500 144401-3-513-5207-100 Tools 250 250 145 401-3-513-5208-100 Supplies 2,500 2,500 146 401-3-513-5400-100 Books, Dues and Publications 10,000 10,000 147 401-3-513-6400-100 Department Expenditure (See D-1) 0 0 148 401-3-513-9000-200 Contingencies 60,000 60,000 149 401-3-513-4908-100 Hurricane Expenditures 394,487 0 150 401-3-513-4907-100 Loan Cost of Issuance 0 0 151 Admin 0 & M Subtotal 1,315,840 965,854 152 Admin Dept Totals 2,405,125 2,120,916 ..J FINAL BUDGET 8/29/2019 9:48 AM C-6 FINAL BUDGET 8/29/2019 9:48 AM C-7 A I B I 0 I E L 156 Maintenance Labor: Account Number Account Description FY19 FY19 Budget Amount FY20 FY 20 Budget Amount 157 158 159 401-4-536-1101-100 Supervisor Salaries Maint 73,156 74,888 160 401-4-536-1200-100 Regular employees 813,962 820,804 161 401-4-536-1201-100 On Call non -pension 12,588 12,588 162 401-4-536-1300-100 Accrued Payout 16,390 16,548 163 401-4-536-1400-100 Overtime Maint 56,742 42,444 164 401-4-536-1600-100 Accured Wages and FICA Maint 0 0 165 401-4-536-1610-100 Accured Benefits and FICA Main 0 0 166 401-4-536-2100-100 FICA Maint 74,422 73,996 167 401-4-536-2200-100 Retirement Maint 139,995 116,457 166 401-4-536-2300-100 Health Insurance Maint 156,240 176,400 169 401-4-536-2301-100 Disability Insurance Maint 3,654 3,159 170 401-4-536-2302-100 Life Insurance Maint 3,780 4,284 171 401-4-536-2400-100 Workmens Compensation Maint 47,603 47,331 172 401-4-536-2500-100 Unemployment Comp Maint 0 0 177 Maintenance Labor Subtotal 1,398,532 1,388,899 178 179 180 181 182 183 184 185 186 187 188 189 190 FINAL BUDGET 8/29/2019 9:48 AM C-7 FINAL BUDGET 8/29/2019 9:48 AM C-8 A 1 B 1 D 1 E L 194 195 196 FY19 Maintenance O&M: FY19 Budget Account Number Account Description Amount FY20 FY 20 Budget Amount 197 401-4-536-4100-108 SLERS R&M Maintenance 0 0 198 401-4-536-1620-100 Accrued OPEB Maint 5,700 3,500 199 401-4-536-3400-209 GPS Tracking 7,000 7,000 zoo 401-4-536-4000-100 Travel and Per Diem Maint 1,000 1,000 201 401-4-536-4100-101 Com Sery-Embarq/Comcast Maint 5,000 5,000 202 401-4-536-4100-102 Com Serv-Nextel Cellular Maint 1,500 1,500 203 401-4-536-4100-103 Com Serv-Sprint Maint 0 0 2a4 401-4-536-4100-300 Communications AirVac 1,250 1,250 zoo 401-4-536-4100-106 SLERS Radio Maint Fee-Maint (31x$9x12) 3,500 3,500 zoo 401-4-513-4100-107 SLERS Tower Maint Fee-Maint (31x$9x12) 3,500 0 207 401-4-536-4200-100 Postage Transportation Maint 500 500 zo8 401-4-536-4300-100 Utilities -FPL Maintenance 5,500 5,500 zos 401-4-536-4300-200 Utilities -FPL Pump Stations 60,000 55,000 210 401-4-536-4300-300 Utilities AirVac 46,000 41,000 211 401-4-536-4301-100 Utilities Waste Management Maint 3,000 3,500 212 401-4-536-4301-101 Utilities Waste Mngmt-tipping fees 3,000 1,500 213 401-4-536-4400-100 Equipment Rental Maint 1,000 2,500 214 401-4-536-4600-100 R&M Vehicles Maint 25,000 32,500 215 401-4-536-4605-200 R&M Pump Stations 50,000 95,000 216 401-4-536-4605-201 R&M Pump Stations Electrical 25,000 20,000 217 401-4-536-4605-300 R&M Air Vac 100,000 85,000 218 401-4-536-4605-400 R&M Water Distribution Maint 90,000 125,000 219 401-4-536-4605-500 R&M Sewer Collection Maint 20,000 25,000 220 401-4-536-4605-600 R&M Kings Bay 7,500 7,500 221 401-4-536-4605-700 R&M SCADA 5,000 15,000 222 401-4-536-4609-100 R&M Building Maintenance 2,500 2,500 223 401-4-536-4611-100 R&M Equipment Maintenance 35,000 24,000 224 401-4-536-4611-200 R&M Equipment Pump Stations 15,000 10,000 225 401-4-536-4611-300 R&M Generators 25,000 27,500 226 401-4-536-4612-100 R&M Computer Equipment Maint 750 750 227 401-4-536-4613-100 R&M Computer Software Maint 500 500 228 401-4-536-4614-100 R&M Copier Usage Maint 1,000 1,000 229 401-4-536-4615-200 Lawn Sery Pump Stations 1,980 1,980 230 401-4-536-4615-300 Lawn Sery Air Vac 1,620 1,620 231 401-4-536-4616-100 Testing and Lab Service 5,000 5,000 232 401-4-536-4901-100 Education maint 5,000 6,250 233 401-4-536-4909-100 Miscellaneous Maint 1,000 1,000 234 401-4-536-4501-100 Small Equipment 3,000 2,500 235 401-4-536-5100-100 Office Supplies Maint 2,600 3,000 236 237 FINAL BUDGET 8/29/2019 9:48 AM C-8 FINAL BUDGET 8/29/2019 9:48 AM C-9 A j 6 I D I E L 238 Maintenance O&M: Account Number Account Description FY19 Budget Amount FY 20 Budget Amount 239 240 241 401-4-536-5201-100 Fuel: Gas, Diesel - Vehicles 35,000 35,000 242 401-4-536-5202-100 Fuel Other Maint 7,500 7,500 243 401-4-536-5203-100 Uniforms Maint 5,000 6,500 244 401-4-536-5206-100 Meters and Meter Boxes 50,000 200,000 245 401-4-536-5207-100 Tools Maint 15,000 18,000 246 401-4-536-5207-200 Tools Pump Stations 1,500 1,500 247 401-4-536-5207-300 Tools Air Vac 1,500 500 248 401-4-536-5207-400 Tools Water Dist Maint 1,500 500 249 401-4-536-5207-500 Tools Sewer Collection Maint 2,500 1,500 250 401-4-536-5207-600 Tools Kings Bay Maint 250 250 251 401-4-536-5208-100 Supplies Maint 12,500 12,500 252 401-4-536-5208-200 Supplies Pump Stations 1,000 2,500 253 401-4-536-5208-300 Supplies Air Vac 1,000 750 254 401-4-536-5208-400 Supplies Water Dist Maint 6,000 11,500 255 401-4-536-5208-500 Supplies Sewer Collection Main 3,000 3,000 256 401-4-536-5208-600 Supplies Kings Bay Maint 500 500 257 401-4-536-5209-200 Chemicals Pump Stations 105,000 105,000 258 401-4-536-5215-100 Safety Supplies 10,000 10,000 259 401-4-536-5400-100 Books, Dues and Publ Maint 500 500 260 401-4-536-6400-100 Dept Expend: copier 2 desktop computers 0 7,000 261 40'-4-536-9000-100 Contingency-Maint 25,000 25,000 262 401-4-536-9999-100 Return To Stock 0 0 263 264 Maintenance 0 & M Subtotal 854,150 1,074,350 265 Maintenance Dept Totals 2,252,682 2,463,249 267 266 269 270 271 272 273 FINAL BUDGET 8/29/2019 9:48 AM C-9 FINAL BUDGET 8/29/2019 9:48 AM C-10 A 1 B I 0 1 E L 274 Account Description FY19 FY19 Budget Amount FY20 FY 20 Budget Amount 27s Water Labor: 276 Account Number 277 401-5-533-1101-100 Supervisor Salaries SWTP 45,466 46,663 278 401-5-533-1101-200 Supervisor Salaries GWTP 19,485 19,998 279 401-5-533-1200-100 Regular Salaries SWTP 237,979 283,466 280 401-5-533-1200-200 Regular Salaries GWTP 38,992 33,298 281 401-5-533-1300-100 Accrued Payout SWTP 6,317 6,342 262 401-5-533-1300-200 Accrued Payout GWTP 0 0 283 401-5-533-1201-101 On Call/NonPension SWTP 0 0 284 401-5-533-1201-201 On Call/NonPension GWTP 0 0 28s 401-5-533-1202-100 Bonus Pay SWTP 0 0 286 401-5-533-1202-200 Bonus Pay GWTP 0 0 287 401-5-533-1400-100 Overtime SWTP 12,111 12,111 zee 401-5-533-1400-200 Overtime GWTP 1,907 1,907 289 401-5-533-1610-100 Accured Benefits and FICA SWTP 0 0 zoo 401-5-533-1610-200 Accured Benefits and FICA GWTP 0 0 291 401-5-533-2500-100 Unemployment Comp SWI P 0 0 292 401-5-533-2500-200 Unemployment Comp GWTP 0 0 293 401-5-533-2100-100 FICA SWTP 23,641 26,509 294 401-5-533-2100-200 FICA GWTP 4,072 4,380 295 401-5-533-2200-100 Retirement SWTP 47,783 49,011 296 401-5-533-2200-200 Retirement GWTP 6,146 4,658 297 401-5-533-2300-100 Health Insurance SWTP 59,520 75,600 298 401-5-533-2300-200 Health Insurance GWTP 7,440 8,400 299 401-5-533-2301-100 Disability Insurance SWTP 1,276 1,252 300 401-5-533-2301-200 Disability Insurance GWTP 171 125 301 401-5-533-2302-100 Life Insurance SWTP 1,440 1,836 302 401-5-533-2302-200 Life Insurance GWTP 180 204 303 401-5-533-2400-100 Workmens Comp SWTP 15,783 18,099 304 401-5-533-2400-200 Workmens Comp GWTP 1,943 1,659 305 401-5-533-1600-100 Accured Wages and FICA SWTP 0 0 3os 401-5-533-1600-200 Accured Wages and FICA GWTP 0 0 307 401-5-533-1201-103 Part Time Employee SWTP 0 0 308 401-5-533-1201-203 Part Time Employee GWTP 0 0 309 Water Labor Subtotal 531,652 595,520 312 313 314 315 FINAL BUDGET 8/29/2019 9:48 AM C-10 FINAL BUDGET 8/29/2019 9:48 AM C-11 A 1 8 I 0 I E L 316 317 318 FY19 Water 0 & M: FY79 Budget Account Number Account Description Amount FY20 FY 20 Budget Amount 319 401-5-533-3400-201 American Tank / Elev Strq Tank RM 16,966 16,964 320 401-5-533-1620-100 Accured OPEB SWTP 2,100 2,100 321 401-5-533-1620-200 Accured OPEB GWTP 450 450 322 401-5-533-3400-209 GPS Tracking 1,650 1,650 323 401-5-533-4000-100 Travel and Per Diem SWTP 350 350 324 401-5-533-4000-200 Travel and Per Diem GWTP 150 150 325 401-5-533-4100-101 Com Sery-Embarq/Centurylink SWTP 6,000 4,500 326 401-5-533-4100-103 Com Serv-Sprint SWTP 175 175 327 401-5-533-4100-104 Com Serv-Reimburse. SWTP 650 650 326 401-5-533-4100-200 Com Serv-Embarq GWTP 2,200 2,400 329 401-5-533-4100-106 SLERS Radio Maint Fee SWTP (5x$9x12) 540 540 330 401-5-533-4100-206 SLERS Radio Maint Fee GWTP (2x$9x12) 216 216 331 401-5-533-4100-107 SLERS Tower Maint Fee SWTP (5x$9x12) 540 0 332 401-5-533-4100-207 SLERS Tower Maint Fee GWTP (2x$9x12) 216 0 333 401-5-533-4200-100 Postage Transportation SWTP 1,000 750 334 401-5-533-4200-200 Postage Transportation GWTP 0 0 335 401-5-533-4300-100 Utilities -FPL SWTP 155,000 165,000 336 401-5-533-4300-200 Utilities -FPL GWTP 40,000 40,000 337 401-5-533-4300-700 Utilities -FPL PRP 0 0 338 401-5-533-4301-100 Utilities Waste Mgmt SWTP 3,000 3,000 339 401-5-533-4301-200 Utilities Waste Mgmt GWTP 0 650 340 401-5-533-4400-100 Equipment Rental SWTP 750 1,000 341 401-5-533-4400-200 Equipment Rental GWTP 250 250 342 401-5-533-4600-100 R&M Vehicles SWTP 5,000 3,500 343 401-5-533-4600-200 R&M Vehicles GWTP 0 0 344 401-5-533-4602-100 R&M SWTP 25,000 25,000 345 401-5-533-4602-200 R&M GWTP 15,000 7,500 346 401-5-533-4602-201 SWTP Backwash pond clean & diversion 0 347 401-5-533-4602-700 R&M PRP 0 0 348 401-5-533-4611-100 R&M Equipment SWTP 125,000 100,000 349 401-5-533-4611-200 R&M Equipment GWTP 30,000 18,000 350 401-5-533-4611-201 R&M Generators GWTP 0 2,250 351 401-5-533-4612-100 R&M Computer Equip SWTP 500 1,500 352 401-5-533-4612-200 R&M Computer Equip GWTP 500 500 353 401-5-533-4613-100 R&M Computer Software SWTP 500 500 354 401-5-533-4613-200 R&M Computer Software GWTP 500 500 355 401-5-533-4615-100 Lawn Service SWTP 10,440 10,440 356 401-5-533-4615-200 Lawn Service GWTP 7,200 7,200 357 401-5-533-4615-700 Lawn Service PRP 900 900 358 401-5-533-4616-100 Testing and Lab Service SWTP 36,000 36,000 359 401-5-533-4616-200 Testing and Lab Service GWTP 500 500 360 401-5-533-4616-700 Testing and Lab Service PRP 0 0 361 401-5-533-4619-100 C2i Annual Maintenance 10,000 7,500 362 401-5-533-4620-100 R&M Ozone Water System Inc. SWTP 30,000 40,000 363 401-5-533-4901-100 Education SWTP 1,500 2,500 364 401-5-533-4901-200 Education GWTP 500 500 365 401-5-533-4611-101 R&M Generator SWTP 0 15,000 366 FINAL BUDGET 8/29/2019 9:48 AM C-11 FINAL BUDGET 8/29/2019 9:48 AM C-12 A ) B 1 D 1 E L 367 Water 0 & M: Account Number Description FY19 Budget Amount FY 20 Budget Amount 368 369 401-5-533-4909-100 Miscellaneous SWTP 1,250 1,250 370 401-5-533-4909-200 Miscellaneous GWTP 500 500 371 401-5-533-4950-100 Permits SWTP 1,500 1,500 372 401-5-533-4950-200 Permits GWTP 5,500 1,500 373 401-5-533-5100-100 Office Supplies SWTP 1,500 1,500 374 401-5-533-5100-200 Office Supplies GWTP 350 350 375 401-5-533-5201-100 Fuel: Gas, Diesel - Vehicles SWTP 4,000 4,000 376 401-5-533-5201-200 Fuel: Gas, Diesel - Vehicles GWTP 500 500 377 401-5-533-5202-100 Fuel Other Equipment SWTP 1,500 8,500 378 401-5-533-5202-200 Fuel Other Equipment GWTP 500 3,250 379 401-5-533-5203-100 Uniforms SWTP 1,500 1,500 380 401-5-533-5203-200 Uniforms GWTP 400 400 381 401-5-533-5204-100 Lab Supplies SWTP 15,000 10,000 382 401-5-533-5204-200 Lab Supplies GWTP 500 1,250 383 401-5-533-5207-100 Tools SWTP 500 500 384 401-5-533-5207-200 Tools GWTP 250 250 385 401-5-533-5208-100 Supplies SWTP 2,500 2,500 386 401-5-533-5208-200 Supplies GWTP 500 500 387 401-5-533-5209-100 Chemicals SWTP 450,000 400,000 388 401-5-533-5209-200 Chemicals GWTP 20,000 20,000 389 401-5-533-5209-700 Chemicals PRP 0 0 390 401-5-533-5215-100 Safety suppliesSWTP 1,500 1,500 391 401-5-533-5215-200 Safety supplies GWTP 100 100 392 401-5-533-5400-100 Books, Dues and Pub SWTP 1,000 500 393 401-5-533-5400-200 Books, Dues and Pub GWTP 150 150 394 401-5-533-4100-108 SLERS R & M SWTP 0 0 395 401-5-533-4100-208 SLERS R & M GWTP 0 0 396 401-5-533-6400-100 Departmental Expenditure (See D-1) 0 0 397 401-5-533-9000-100 Contingency -Water 25,000 50,000 398 Water 0 & NI Subtotal 1,067,243 1,032,585 399 Water Dept Totals 1,598,895 1,628,105 FINAL BUDGET 8/29/2019 9:48 AM C-12 FINAL BUDGET 8/29/2019 9:48 AM C-13 A 1 B I D I E L 402 Wastewater Labor: Account Number Account Description FY19 FY19 Budget Amount FY20 FY 20 Budget Amount 403 404 a05 401-6-535-1101-100 Supervisor Salaries WW 66,704 68,415 406 401-6-535-1200-100 Regular Salaries WW 345,905 346,489 407 401-6-535-1200-101 Part-time Salaries WW 0 408 401-6-535-1201-100 On Call Non pension WW wages 0 0 409 401-6-535-1202-100 Bonus Pay WW 0 0 410 401-6-535-1300-100 Accrued Payout WW 7,228 7,271 411 401-6-535-1400-100 Overtime WW 15,544 15,544 412 401-6-535-1600-100 Accured Wages and FICA WW 0 0 413 401-6-535-1610-100 Accured Benefits and FICA WW 0 0 414 401-6-535-2100-100 FICA WW 33,307 33,486 415 401-6-535-2200-100 Retirement WW 61,756 55,130 416 401-6-535-2300-100 Health Insurance WW 59,520 67,200 417 401-6-535-2301-100 Disability Insurance WW 1,562 1,368 418 401-6-535-2302-100 Life Insurance WW 1,440 1,632 419 401-6-535-2400-100 Workmens Compensation WW 16,654 16,744 420 425 426 401-6-535-2500-100 Unemployment Comp WW 0 0 427 428 Wastewater Labor Subtotal 609,620 613,278 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 FINAL BUDGET 8/29/2019 9:48 AM C-13 FINAL BUDGET 8/29/2019 9:48 AM C-14 A 1 6 1 0 I E L 444 44s 446 FY19 Wastewater 0 & M: FY19 Budget Account Number Account Description Amount FY20 FY 20 Budget Amount 447 401-6-535-3400-209 GPS Tracking 2,240 2,240 448 449 401-6-535-4000-100 Travel and Per Diem WW 1,500 750 450 401-6-535-4100-108 SLERS R&M WWTP 0 0 451 401-6-535-4100-101 Com Serv-Embarq/Centuyrylink WW 5,750 5,750 452 401-6-535-4100-104 Com Serv-Reimbursements WW 650 650 453 401-6-535-4100-106 SLERS Radio Maint Fee WW (10x$9x12) 1,080 1,080 454 401-6-535-4100-107 SLERS Tower Maint Fee WW 10x$9x12) 0 0 455 401-6-535-4200-100 Postage Transportation WW 250 250 456 401-6-535-4300-100 Utilities WW 160,000 160,000 457 401-6-535-4300-200 Utilities LVTP 2,750 2,750 456 401-6-535-4300-300 Utilities OTTP 1,750 2,750 459 401-6-535-4300-400 Utilities ETP 2,500 2,250 460 401-6-535-4300-500 Utilities KBTP 2,000 2,750 461 401-6-535-4300-700 Utilities PRPTP 2,500 500 462 401-6-535-4301-100 Utilities Waste Mgmt WW 5,000 6,250 463 401-6-535-4400-100 Equipment Rental WW 1,000 750 464 401-6-535-4600-100 R&M Vehicles WW 4,000 2,500 465401-6-535-4602-100 R&M WWTP 24,000 24,000 466 401-6-535-4602-200 R&M LVTP 2,500 2,500 467 401-6-535-4602-300 R&M OTTP 750 750 468 401-6-535-4602-400 R&M ETP 1,500 1,250 469 401-6-535-4602-500 R&M KB TP 1,500 1,250 470 401-6-535-4602-700 R&M PRP TP 0 0 471 401-6-535-4609-100 R&M Building WWTP 6,000 3,500 472 401-6-535-4611-100 R&M Equipment WWTP 22,500 22,500 473 401-6-535-4611-200 R&M Equipment LVTP 500 500 474 401-6-535-4611-300 R&M Equipment OTTP 500 500 475 401-6-535-4611-400 R&M Equipment ETP 500 500 476 401-6-535-4611-500 R&M Equipment KBTP 2,500 1,500 477 401-6-535-4611-600 R&M Equipment PRTP 0 0 478 401-6-535-4612-100 R&M Computer & Office Equip WW 1,100 1,750 479 401-6-535-4613-100 R&M Computer Software WW 2,500 3,500 480 401-6-535-4613-101 R&M Computer BCI Technologies WW 0 0 481 401-6-535-4615-100 Lawn Service WWTP 13,500 13,500 482 401-6-535-4615-200 Lawn Service LVTP 900 900 483 401-6-535-4615-300 Lawn Service OTTP 1,800 1,800 484 401-6-535-4615-400 Lawn Service ETP 1,260 1,260 485 401-6-535-4615-500 Lawn Service KBTP 0 0 485 401-6-535-4615-600 Lawn Service PRP TP 0 0 487 488 FINAL BUDGET 8/29/2019 9:48 AM C-14 FINAL BUDGET 8/29/2019 9:48 AM C-15 A I B 1 D I E L 469 Account Description FY19 FY19 Budget Amount FY20 FY 20 Budget Amount Oso Wastewater 0 & M: 491 Account Number 492 401-6-535-4616-100 Testing and Lab Service WWTP 30,000 _ 28,000 493 401-6-535-4616-400 Testing and Lab Services ETP 1,500 1,250 494 401-6-535-4616-500 Testing and Lab Services KBTP 1,500 1,250 495 401-6-535-4616-700 Testing and Lab Services PRP 750 0 496 401-6-535-4617-100 Residual Management WWTP 30,000 35,000 497 401-6-535-4901-100 Education WW 2,000 2,000 496401-6-535-4909-100 Misc WW 2,500 1,500 499 401-6-535-4950-100 Permits WW Cemetery Rd 0 12,000 500 401-6-535-4950-200 Permits LVTP 10,000 0 501 401-6-535-4950-300 Permits OTTP 0 0 502 401-6-535-4950-400 Permits ETP 0 10,000 503 401-6-535-4950-500 Permits KBTP 0 10,000 504 401-6-535-4950-600 Permits PRP 0 0 505 401-6-535-5100-100 Office Supplies WW 1,500 1,250 506 401-6-535-5201-100 Fuel: Gas, Diesel - Vehicles 5,000 6,000 507401-6-535-5202-100 Fuel Other WW 1,250 7,500 508 401-6-535-5203-100 Uniforms WW 1,500 2,250 509 401-6-535-5204-100 Lab Supplies WW 4,500 3,500 510 401-6-535-5207-100 Tools WW 1,500 1,500 511 401-6-535-5208-100 Supplies WW 4,000 4,000 512401-6-535-5209-100 ChemicalsWWTP 45,000 45,000 513 401-6-535-5209-200 Chemicals LVTP 3,000 3,000 514 401-6-535-5209-300 Chemicals OTTP 2,250 2,250 515 401-6-535-5209-400 Chemicals ETP 2,000 2,000 516 401-6-535-5209-500 Chemicals KBTP 2,500 2,500 517 401-6-535-5209-600 Chemicals PRP TP 0 0 518 401-6-536-5215-100 Safety Supplies 1,500 1,500 519 401-6-535-5400-100 Books, Dues and Publications 500 500 520 401-6-535-6400-100 Departmental Expenditure (See D-1) 0 0 521 401-6-535-1620-100 Accured OPEB WW 2,300 2,300 522 401-6-535-9000-100 Contingency -WW 25,000 35,000 523 Wastewater 0 & M Subtotal 458,330 493,730 524 Wastewater Dept Totals 1,067,950 1,107,008 FINAL BUDGET 8/29/2019 9:48 AM C-15 FINAL BUDGET 8/29/2019 9:48 AM C-16 A 1 B I D I E L 531 Meter Labor: Account Number FY19 FY19 Budget Account Description Amount FY20 FY 20 Budget Amount 532 533 534 401-7-513-1101-100 Supervisor Salaries 51,896 53,195 535 401-7-513-1200-100 Regular Salaries 88,052 89,848 536 401-7-513-1202-100 Bonus Pay 0 0 537 401-7-513-1300-100 Accrued Payout 2,586 2,643 538 401-7-513-1201-101 On Call Non Pension wages 0 0 539 401-7-513-1201-102 Non -pension wages custodial services 9,724 9,970 540 401-7-513-1400-100 Overtime 1,907 2,247 541 401-7-513-1600-100 Accured Wages and FICA 0 0 542 401-7-513-1610-100 Accured Benefits and FICA 0 0 543 401-7-513-2100-100 FICA 11,793 12,080 544 401-7-513-2200-100 Retirement 22,087 20,015 545 401-7-513-2300-100 Health Insurance 29,760 33,600 546 401-7-513-2301-100 Disability Insurance 617 528 547 401-7-513-2302-100 Life Insurance 720 816 548 401-7-513-2400-100 Workmens Compensation 7,544 7,727 555 Meter Labor Subtotal 226,686 232,668 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 FINAL BUDGET 8/29/2019 9:48 AM C-16 FINAL BUDGET 8/29/2019 9:48 AM C-17 A 1 B I D I E L 575 Meter 0 & M: Account Number Account Description FY19 FY19 Budget Amount FY20 FY 20 Budget Amount 576 522 578 401-7-513-3400-209 GPS Tracking 2,240 2,240 579 401-7-513-1610-101 Accrued OPEB MR 1,100 1,100 580 401-7-513-4000-100 Travel and Per Diem 500 500 561 401-7-513-4200-100 Postage, Freight & Shipping MR 100 150 582 401-7-513-4100-106 SLERS Radio Maint Fee MR (8x$9x12) 864 864 583 401-7-513-4100-107 SLERS Tower Maint Fee MR (8x$9x12) 864 0 564 401-7-513-4400-100 Equipment Rental MR 0 0 565 401-7-513-4600-100 R&M Vehicles 2,500 2,500 586 401-7-513-4611-100 R&M Meter Reading Equipment 500 4,500 587 401-7-513-4613-100 R&M Computer Software Sensus 3,500 3,500 see 401-7-513-4618-100 R&M Meter and Testing BackFlow 500 800 589401-7-513-4901-100 Education 500 500 590 401-7-513-5201-100 Fuel: Gas, Diesel - Vehicles 7,000 8,500 591401-7-513-5203-100 Uniforms 750 750 592401-7-513-5207-100 Tools 500 500 593 401-7-513-5208-100 Supplies 3,500 2,500 594 401-7-513-5400-100 Books, Dues and Publications 500 500 595 401-7-513-6400-100 Department Expenditure: extra handhell 0 3,500 596 Insect Services 5,000 2,500 597 401-7-513-2500-100 Unemployment Comp MR 0 0 596 401-7-536-5215-100 Safety 500 500 599 Meter 0 & M Subtotal 30,918 35,904 600 Meter Dept Totals 257,604 268,572 FINAL BUDGET 8/29/2019 9:48 AM C-17 FINAL BUDGET 8/29/2019 9:20 AM C-18 A B C DI E F G H 1 Okeechobee Utility Authority 2 FY20 Budget 8/29/2019 3 NON-OPERATING EXPENDITURES AND TRANSFERS 4 5 FY19 FY20 6 Budget Budget 7 NON-OPERATING EXPENSES: Amount Amount 8 Debt Service Interest Expense: 11 SRF 1 Interest Expense 118,027 107,472 12 SRF 2 Interest Expense 66,579 0 14 BB&T 2017A Interest Expense 196,440 169,320 15 BB&T 20178 Interest Expense 259,440 254,983 16 Total 640,486 531,775 17 18 Amortization Expense: 31 Amortize Organizational Costs 9,600 9,600 32 Amortize Long-Term Lease 12,600 12,600 33 Total 22,200 22,200 34 35 Depreciation Expense: 2,660,000 2,660,000 36 37 TOTAL NON-OPERATING EXPENSES 3,322,686 3,213,975 38 39 FINAL BUDGET 8/29/2019 9:20 AM C-18 FINAL BUDGET 8/29/2019 9:20 AM C-19 A B C I D E F G H 40 NON-OPERATING TRANSFERS: FY19 FY20 41 Required Transfers: 42 Debt Service Principal Payment & Loan Fee Transfers: 45 SRF 1 Principal 564,836 575,391 46 SRF 2 Principal 252,064 0 52 BB&T 2017A Principal 1,125,000 1,150,000 53 BB&T 20178 Principal 155,000 160,000 54 Total 2,096,900 1,885,391 55 Unrestricted/Restricted Revenue Transfers to Restricted Accts: 56 Operating Reserve Fund 0 0 57 Restricted Interest to Restricted Accts. 34,360 65,821 58 Cap Conn Fund Water (infill) 9,450 9,450 59 Cap Conn Fund WW (infill) 8,808 8,808 60 Cap Conn Fund Water 10/20 0 0 61 Fire Hydrant Fund 73,062 83,996 62 Emergency Reserve Fund 0 0 63 Total 125,680 168,075 64 65 Pledged Restricted Revenue Transferred to Restricted Fund Acct: 66 Cap Conn Fund WWTP 10/20 (Direct) 60,547 150,058 67 Cap Conn Fund WWTP 10/20 (Indirect) 0 0 68 Sub -Total 60,547 150,058 69 Less Amount Used Towards Junior Debt Service 0 0 70 Total 60,547 150,058 71 72 Discretionary Transfers -From Restricted Funds: 73 Net Transfer to Rate Stabilization Fund 187,662 $ 450,217 74 Funds Earmarked for 0 0 75 Future CIP Funding 0 $ - 76 Total 187,662 450,217 77 Other Transfers: 78 Intemal Transfer for CIP Expenditures 7,036,840 2,800,081 79 Internal Transfer for Departmental Capital Expenditures 1,468,916 838,750 80 External Funding from State 957,741 15,067,836 81 Total 9,463,497 18,706,667 82 83 TOTAL NON-OPERATING EXPENDITURES AND TRANSFERS 15,256,972 $- 24,574,381 FINAL BUDGET 8/29/2019 9:20 AM C-19 D-1 FINAL BUDGET 8/29/2019 9:13 AM A B C D E G 1 Okeechobee Utility Authority 8/29/2019 2 FY20 Budget 3 Proposed Additional Departmental Capital Expenditures 4 ( Capital 5 DEPARTMENT TOTALS 6 ADMINISTRATION 350,000 7 MAINTENANCE 340,250 8 WATER 42,000 9 WASTEWATER 106,500 10 METER 0 11 TOTALS 838,750 12 Administration 13 Water master plan 175,000 14 WasteWater master plan 175,000 15 Administration Office Restoration 0 16 20 Sub Total Administration 350,000 21 Maintenance 22 Maintenance barn roof 47000 23 Gravity Sewer Installation SE 5th St 75,000 24 Replace Truck 501 with 1/2Ton 2WD Truck 28,000 25 Replace Truck 532 with 1/2Ton 2WD Truck 28,000 26 Bypass pump at NW15 147,500 27 Big Tex 70SR dump trailer 5,250 29 New Utility bed for trick 516 9,500 32 Sub Total Maintenance 340,250 33 Water 34 Krebs Fittings (4 sets) Actiflo 12,000 35 Replace Caustic Tank 30000 37 Sub Total Water 42,000 38 Wastewater 41 Entrance road paving work 106,500 42 Sub Total Wastewater 106,500 43 Meter 44 47 Sub Total Meter 0 D-1 FINAL BUDGET 8/29/2019 9:13 AM N 0 8/29/2019 9:07 AM FINAL BUDGET m a o m 1FY20-FY24 1 125,000 150 150.1 0001 400,000 I- 350.000 110,000 1 360.000 160.000 1- 125.000 750.000 750,000 100.000 500.000 275,000 390.000 540.2501 206,500 20,000 5,678,7501 has been appropriated in the FY19 budget a } LL 25,000 O o 0 O 100,000 72,000 32,000 O O N F 150,000 150,000 25,0001 O O0 i0 50,0001 O O 25,0001 5,0001 819,0001 0 6 r 50,00011 50,0001 1 1 50,000 25,00011 25,000 0 Vi �819,000H 769,00011 dLL 0 ILL 1 25,00011 25,000 1 50,000 100,00011 50,000 0 O 72,0001 72,000 32,00011 32,000 25,000 25,000 150,000 150,000 1 25,000 Z z N } LL 0 0 CD O O 0 0 0 dtoto 0 0 0 0 N 0 r0 0 0N 6 0 O t0 25,00011 25,0001 1 50,0001 50,00011 50,0001 72,0001172,000 32,0001132,000 25,00011 25,0001 150,000 150,0001 150,000 150,00011 42,00011 50,0001 106,500)1 25,0001 O m 769,000 This Project 13,950,0001 1 11 J r } LL 125,00011 100,0001 50,000 110,0001 O 500,000 1 275,00011 350,00011 10,0001 O O IO 523,86711 co N LL 0 co OCo m O co N O O r 0 N O OO CO r t0 M r Ohl M 0 'OkeeOkeechobee Utility Authority chobee Budget Five Year Capital Improvement Plan Expenditure Detail WASTEWATER: ISCADA System Generator - Lift Stations (General) Generator - Vac Station #2 150Kw - Gravity Sewer Repair & Rehabilitation N W Z M c0 coco Z 0 C O 0 -.7_ 0 L N IY c O m 6-3t Lift Station Electrical Panels - 7 Stations Manhole Rehabs (30 x $2,400) Lift Station Pump Replacements Vacuum Pump Replacement 'ATER: Water Main Installation (System Wide) Water Main Repair & Replacement (System Wide) Fire Hydrant Installations & Replacements SE 8th Ave Water Main Install (balance of $900k project) SE 28th St Water Main Installation EPARTMENTAL CAPITAL REQUESTS: Administration (See D-1) Maintenance (See D-1) Water (See D-1) Wastewater (See D-1) Meter Reader (See D-1) TOTAL Surface Water Treatment Plant Storage Tank 3M gal SW Wastewater Service Area $13,950,000 State Appropriation (Septic to Sewer Project) G 0 0 J s of D-2 r N M v} t0 m N m p) O r r r N r M r t t0 r m r r r m r O) r O N N N N M N d' N t0 N m N I- N m N O) N O M M N M M M V M t0 M m M 1- M N 0 8/29/2019 9:07 AM FINAL BUDGET FINAL BUDGET 8/29/2019 9:04 AM E-1 A B 1 Okeechobee Utility Authority 2 FY20 Budget 8/29/2019 3 Analysis of RR&I Fund 4 Funding is required to be maintained at 5% of Previous Year System 5 Operating Revenue. 6 7 8 FY19 System Operating Revenue (Projected) $10,323,407 9 10 FY20 Funding Required at 5% (Fund Balance Required) 516,170 11 12 Fund Balance at September 30, 2019 (Projected) 504,013 13 14 Fund Surplus (Deficit) -12,157 15 16 Funds to be Transferred Back for SRF Debt Payment 0 17 18 Remaining Fund Surplus ($12,157) 19 20 FY20 Funding Budgeted 1 $12,157 FINAL BUDGET 8/29/2019 9:04 AM E-1 FINAL BUDGET 8/29/2019 9:01 AM F-1 A B 1 Okeechobee Utility Authority 2 FY20 Budget 8/29/2019 3 Analysis of Emergency Reserve Fund 4 5 (Maintained at 30 days of current year System 0 & M) 6 7 8 FY20 System Operating Expenses (Budgeted) $7,587,851 9 10 FY20 30 Days 0 & M Expenses (Fund Balance Required) 623,659 11 12 Fund Balance at September 30, 2019 (Projected) 622,615 13 14 Fund Surplus (Deficit) (1,044) 15 16 Funds to be Transferred Back for SRF Debt Payment 0 17 18 Remaining Fund Surplus (deficit) ($1,044) 19 20 FY20 Funding Budgeted 9 $1,044 FINAL BUDGET 8/29/2019 9:01 AM F-1 FINAL BUDGET 8/29/2019 9:00 AM 0-1 A B 1 Okeechobee Utility Authority 2 FY20 Budget 8/29/2019 3 Analysis of Operating Reserve Fund 4 5 (Maintain at 90 days expenses of current year System 0 & M) 6 7 8 FY20 System Operating Expenses (Budgeted) $7,587,851 9 10 FY20 90 Days O & M Expenses 1,870,977 11 12 Fund Balance at September 30, 2020 (Projected) 1,716,619 13 14 Fund Surplus (Shortage) (154,358) 15 16 Funds to be Transferred Back for SRF Debt Payment 0 17 18 Remaining Fund Surplus (154,358) 19 20 FY20 Funding Budgeted I $154,358 21 FINAL BUDGET 8/29/2019 9:00 AM 0-1 Okeechobee Utility Authority FY20 Budget Analysis of Fire Hydrant Fund Fund Balance at September 30, 2019 (Projected) Budgeted Additional Revenue in FY20 Interest Earnings Added to Fund Balance (Projected) Budgeted Hydrant Replacement Expenditures in FY20 Budgeted Repair and Maintenance Expenses in FY20 Projects (TBD) Projected Fire Hydrant Fund Balance at September 30, 2020 8/29/2019 $58,146 $83,996 $0 $0 $0 $0 $117,142 FINAL BUDGET 8/29/2019 8:58 AM H-1 Okeechobee Utility Authority Debt Service Summary FYE Ending 9/30/12 9/30/13 9/30/14 BB&T D/S Sub Total Int. Prin. 811,949 1,005,000 782,014 1,035,000 751,170 1,065,000 SRF 'XS Sub Total Int. Prin. 446,067 1,058,847 424,304 1,080,610 332,906 920,304 Prepayments included with March 15, 2014 payments 9/30/15 ' 9/30/16 Totals 719,455 1,095,000 686,831 1,130,000 6,422,932 246,958 754,548 231,836 769,670 3,751,419 5,330,000 1,682,071 Paid $530,000 and refunded $19,425,000 on 3/29/2017 9/30/17 9/30/18 9/30/19 9/30/20 9/30/21 9/30/22 9/30/23 9/30/24 9/30/25 9/30/26 9/30/27 9/30/28 9/30/29 9/30/30 Totals 256,179 510,000 486,585 1,245,000 455,880 1,280,000 424,303 1,310,000 391,995 1,340,000 358,896 1,375,000 325,007 1,410,000 290,164 1,445,000 254,530 1,480,000 216,566 1,520,000 173,267 1,560,000 128,836 1,605,000 83,061 1,650,000 36,083 1,695,000 3,881,350 19,425,000 4,583,978 216,407 785,099 200,666 800,840 118,027 564,836 107,472 575,391 96,720 586,143 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 1,101,059 8,072,008 Future P&I payments at beginning of FY20 $ 25,559,898 P&I payments budgeted to be paid in FY20 $ 2,417,165 Future P&I payments at end of FY20 $ 23,142,733 6/5/2019 2:03 PM Last Updated 06/05/19 Total Annual Debt Service 3,321,863 3,321,928 3,069,380 2,815,961 2,818,337 15,347,468 1,767,685 2,733,091 2,418,743 2,417,165 2,414,857 2,416,759 2,417,869 2,418,026 2,417,392 2,419,428 2,416,129 2,416,698 2,074,492 1,731,083 32,479,417 K-1 Okeechobee Utility Authority Debt Service Summary - BB&T Bank Debt FYE Ending BB&T 2017A Int. 2.40% Prin. BB&T 2017B Int. 2.83% Prin. Paid $530,000 and refunded $19,425,000 on 3/29/2017 9/30/2017 4/1/2018 9/30/2018 4/1/2019 9/30/2019 4/1/2020 9/30/2020 4/1/2021 9/30/2021 4/1/2022 9/30/2022 4/1/2023 9/30/2023 4/1/2024 9/30/2024 4/1/2025 9/30/2025 4/1/2026 9/30/2026 4/1/2027 9/30/2027 4/1/2028 9/30/2028 4/1/2029 9/30/2029 4/1/2030 9/30/2030 121,333.33 440,000.00 114,720.00 545,000 108,180.00 550,000 101,580.00 560,000 94,860.00 565,000 88,080.00 570,000 81,240.00 580,000 74,280.00 585,000 67,260.00 595,000 60,120.00 600,000 52,920.00 610,000 45,600.00 615,000 38,220.00 620,000 30,780.00 630,000 23,220.00 635,000 15,600.00 645,000 7,860.00 655,000 Last Updated 06/05/19 BB&T Total Debt Service 134,845.57 70,000.00 766,178.90 132,373.25 75,000.00 867,093.25 131,312.00 75,000.00 864,492.00 130,250.75 75,000.00 866,830.75 129,189.50 80,000.00 869,049.50 128,057.50 80,000.00 866,137.50 126,925.50 80,000.00 868,165.50 125,793.50 80,000.00 865,073.50 124,661.50 80,000.00 866,921.50 123,529.50 85,000.00 868,649.50 122,326.75 80,000.00 865,246.75 121,194.75 85,000.00 866,794.75 119,992.00 90,000.00 868,212.00 118,718.50 90,000.00 869,498.50 117,445.00 90,000.00 865,665.00 116,171.50 90,000.00 866,771.50 114,898.00 90,000.00 867,758.00 113,624.50 755,000.00 868,624.50 102,941.25 765,000.00 867,941.25 92,116.50 775,000.00 867,116.50 81,150.25 785,000.00 866,150.25 70,042.50 795,000.00 865,042.50 58,793.25 810,000.00 868,793.25 47,331.75 820,000.00 867,331.75 35,728.75 830,000.00 865,728.75 23,984.25 840,000.00 863,984.25 12,098.25 855,000.00 867,098.25 1,125,853.33 10,000,000.00 2,755,496.32 9,425,000.00 23,306,349.65 Future P&I payments at beginning of FY20 $ 19,072,705 P&I payments budgeted to be paid in FY20 $ 1,734,303 Future P&I payments at end of FY20 $ 17,338,402 K-2 Okeechobee Utility Authority Debt Service Summary - SRF Debt FYE Ending 9/30/09 9/30/10 9/30/11 9/30/12 9/30/13 9/30/14 Last Updated 06105/19 SRF # 1 SRF # 2 SRF # 3 SRF Total Debt Service Int. 1.86% Prin. Int. 2.3% Prin. Int. 1.91% Prin. 94,955 1,190 95,151 224,518 0 0 415,814 189,876 2,414 222,466 414,686 46,564 145,126 1,021,132 191,207 246,369 214,572 422,839 53,499 134,536 1,263,023 186,683 496,179 207,717 429,526 51,666 133,142 1,504,914 177,412 505,451 197,781 439,461 49,111 135,698 1,504,914 167,966 514,896 141,358 336,586 23,582 68,822 1,253,210 Prepayments included with March 15, 2014 payments 9/30/15 9/30/16 9/30/17 9/30/18 9/30/19 9/30/21 9/30/22 9/30/23 9/30/24 9/30/25 9/30/26 9/30/27 9/30/28 9/30/29 Totals 4,022,441 2,400,491 6,422,932 158,345 524,518 88,614 230,030 0 0 1,001,506 148,543 534,319 83,292 235,351 0 0 1,001,506 138,559 544,304 77,848 240,795 0 0 1,001,506 128,388 554,475 72,278 246,365 0 0 1,001,506 Paid off Feb 12, 2019 118,027 564,836 $ 6,487,193 P&I payments budgeted to be paid in FY20 682,862 682,862 107,472 575,391 i ' 682,862 96,720 586,143 682,862 85,767 597,096 682,862 74,609 608,253 682,862 63,243 619,619 682,862 51,665 631,198 682,862 39,870 642,993 682,862 27,854 655,008 682,862 15,615 667,248 682,862 3,146 338,285 341,431 2,265,920 10,410,183 1,401,077 7,242,599 224,422 3,017,815 24,562,017 Future P&I payments at beginning of FY20 $ - $ 6,487,193 P&I payments budgeted to be paid in FY20 682,862 Future P&I payments at end of FY20 $ - $ 5,804,330 K-3 Okeechobee Utility Authority FY20 Budget Notes to Labor Costs Page Line 0/29/2019 L-2 X 145 Total Budgeted Labor costs as presented: $3,985,428 The above amount includes labor costs for all positions expected to be utilized in fiscal year. A 1.0% Cost of Living Allowance has been included in the accompanying Budget totaling: $26,374 A 1.5% Merit increase has been included in the accompanying Budget totaling: $52,386 A 1.5% Bonus has been included in the accompanying Budget totaling: $46,894 An increase in Health Care Cost to OUA has been included in the accompanying Budget totaling: $70,560 An increase in the urgent care services contract has been included in the accompanying Budget totaling: $0 A 1.8% decrease in the Pension Contribution rate totaling: -$46,951 L-1 FINAL BUDGET 8/29/2019 8:55 AM } 1 Grand Total Labor FV20 0 a N i... 'n ° _ ° ry '� r'l a r e T n in U a i n - _ N n 0 n _ r 0 r Nm a e I L G v .. n ^ _ m o 9 -r a. 0"e i...m N m b S. - nee - O O o 0 G re a y vF Pt. n .. v� .. ^t ' 4 n _ - 46,4371 in z n a 474,4291 — n co ^ ¢ < L a r T r = n r Mi n 0 m a ry N a _N _ m - ,.I nr. _ _ n m in r m m m T 4 ^ L T _ T m o ti cc _ a a .. a cN n — a 0 n a 44. t a e n G O C n N n _ m t. i.C O O 9 rt a Z 0 ❑ < n e n _ _ n e a .. : N n 'n n _ e a _ Ein s r n a N n: r n v a.S .. n in n et _ Y ° c - y P. 1-04-01-43080140co o n ° m . 74,050 h_a n 3 e a n'�' N c 15,091 424,970 n 0 0 392,0251 0 n n m rt ..1_ a _ m r - _ in _ 0 o om n V — pn U ry _ 0 r n a .. r ," c e n m — c _ Curenl Salary 295,059 0 120,035 347,464 7,195 779,353 51,106 95,904 0 2,160 149,169 r 1 727,043'.. e_ a le)n . n e 304,3461 m - n _ w 8 A ,d EE Subtotal Executive Department! Subtotal Executive Su , port Subtotal Admin Supervisor Subtotal Admin Su ort Adm -Support Overtime Urgent Care Services Ada Subtotal Meter Render Supervisor Subtotal Meter Reader Support On Call Overtive Mei Subtotal Mnint Supervieorl Subtotal Mobil Support a u - 0 U c C _ .n y _ `.' r 9 Subtotal Wastewater Support' 3 U 0 Overtime WW1 N Subtotal Water Supervisor Subtotal Water Support) i> _ O U 0 0 N E L O O E _ O o o O__.___.__ m N N N N N N N N N N n n n n i Cn1 Cr) n n n P< P ol C P 0 FINAL BUDGE 0/29/2019 0:44 AM A B C D E F G H 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 Okeechobee Utility Authority FY20 Budget Projected General In -Fill Revenue Approved Rates from Resolution 18-06, Effective October 1, 2018 WATER 0/29/2019 WASTEWATER Capital Connection Charge Revenue Projected Connections Added in FY20 25 Revenue Per CC Total CC Revenue $378.00 $9,450.00 Projected Connections Added in FY20 Revenue Per CC Total CC Revenue 12 $734.00 $8,808.00 Install Fee Revenue Revenue Per Residential Mtr Total Install Fee Revenue 25 $250.00 $6,250.00 Revenue Per Total Install Connection Fee Revenue 12 $500.00 $6,000.00 Accrued Garanteed Revenue Charges (AGRC) Oct -18 2 Nov -18 2 Dec -18 2 Jan -19 2 Feb -19 2 Mar -19 2 Apr -19 2 May -19 2 Jun -19 2 Jul -19 2 Aug -19 2 Sep -19 3 Totals 25 AGRC Per 1 ERC Connection (1) 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 Total AGRC AGRC Per 1 ERC Total AGRC Revenue Connection (2) Revenue 500.00 1 500.00 500.00 500.00 1 500.00 500.00 500.00 1 500.00 500.00 500.00 1 500.00 500.00 500.00 1 500.00 500.00 500.00 1 500.00 500.00 500.00 1 500.00 500.00 500.00 1 500.00 500.00 500.00 1 500.00 500.00 500.00 1 500.00 500.00 500.00 1 500.00 500.00 750.00 1 500.00 500.00 $6,250.00 12 $6,000.00 Statictical Data: Projected Number of active connections Beginning of previous Fiscal Year Beginning of Fiscal Year In -fill Growth rate Average cost per new connection Water 9230 9262 0.270% $878 Wastewater 4216 4384 0.274% $1,734 11) AGRC for water was capped at $250.00 effective 10-1-18 as part of the 75% discount 12) AGRC for wastewater was capped at $500.00 effective 10-1-18 as part of the 75% discount ANAL BUDGET 8/29/2019 8:36 AM N-1 J Cm '°0=00001-000N-0001-00FS m !Il. C m (50,000) (7, nnnl ry g o LL E LL 00 0 Er1 (Inn n 0 ry0 i� EndLL=VLL m C ¢ �- m� 0 - to 0 0 93 n a C V2 g _ a a uP0 0 � 0 0 m 00 0 0 a 3 m O 0051 Min 5% or PrevYre Rev 504,013 12,157 0 0 - 0 n z "2 E., oa_ 26,650 m Emergency_ Rory Fd 20 doye) 622,615 12,400 0 0 oz aQHOD 0 n 0 u aa" m 1,000,000 523,667 1 360,041 234,000 0 0 (50,000) C� _ (117,750)1 (42,000) C 566,46 `ySV CIS J� mmm��� gQ §H§R GI °$88888888 N0'm^.- - N ?Aon' mm rwjectee Fund Bal Reserves at beet 40, 2020 -- l = Jm m 'm m 0 0 Oo 0c'40 0 o m o - O o m nn__ Qin -n _ 00 af mn - LL0 uno a e tom L v w 'Q' r 1) Okeechobee Ulillty Authority nee aualler Projected Funtl Balances III Projected Fund Balance Reserves at Sept 30, 2019 before t mien -tea 0//00100 fund balances tram FY20 Operellons: !Net General Ulillty Operating Revenue l RBST Debt Service Payments c E v 2 8 a u a ° c? E o = o= -oma 2 u E o 3cercu Ittele novenae Imre YYID d FY1 1 Rate Increases !SRF Debt SentIce Payments (requited) :state funding for Lakeview Estates: experimental WPM SW section WWProjoct (Septic to sewer stale appmprlmlon) SW section WWPro)ect (gmntllnan to be obtained) Infer -fund transfer to Future CIF Fund Inter -fund transfers 10 restricted funds 1 IAMI Meter Installation grant I linter -Red transfers to Operating Budget I linter -fund transfer from FY19 Budoel Surplus Not source of Funds from Operations aver debt service, excluding r JI Fund Balances Before Capital Expenditures Inds from Rata Stabilization Fund used as Operating Revenue FLOOT: US441 SE ei SE 10th Torrace (TCI) traffic circle Use of Funds for ;Rotor capital Projects: Water fir a s c °'_ E 3 mye�� m Nu =33c„'F _ E E c K _v a < a m'`g�e" u amt `ot E b g m n 3 SLL E a o ` e @" 2`'` u c>E�irc=wiaw Hu�uu�s»>9—a'af v oa 0o c i c a o as m¢= ems= v = n 0 6 n 9rca.m°. a e cc -sae. ° e E 6 E 0.¢ E o o a c a �a e� YES maintenance Wastewater Meter MI Mater Installatlan project In thickhead P. SW TOTAL 7 �Nt7 <+1Nr0 -������ ((VV -mNNIVNNNNNNNmmI1111�1�N F.-0:PPVCC00.000ufuiu..00.-=nc FINAL BUDGET 9/0/2019 3:55 PM Okeechobee Utility Authority FY19 through FY20 Future 10/20 Plan Developer CC Revenue FY19 FY19 FY20 Northshore Village, Inc. $ 24,272.64 $ 24,272.64 Interest due per May 24, 2010 mediated settlement agreement $ 40,252.13 Stephen E. Myers, Sr. $ 32,175.36 $ 32,175.36 Interest due per May 24, 2010 mediated settlement agreement $ 53,357.47 Awesome Ranch, LLC $ - $ - Prior year tax collector fee received 5-31-18 by County Awesome Ranch, LLC $ 2,234.63 $ - $ - Interest on assessment balance 1,864.55 Total $ 4,099.18 I $ 56,448.00 $ 150,057.60 FINAL BUDGET P-2 8/29/2019 8:02 AM Okeechobee Utility Authority Budget Summary Fiscal Year October 1, 2019 to September 30, 2020 REVENUES WATER UTILITY REVENUE $ 6,289,975 WASTEWATER UTILITY REVENUE 3,853,686 OTHER GENERAL REVENUE 386,388 RATE STABILIZATION FUNDS 75,000 CAPITAL CONNECTION REVENUE 168,316 CAPITAL IMPROVEMENT PROJECT/CAPITAL ASSET FUNDING 3,638,831 CAPITAL IMPROVEMENT PROJECT-STATE/GRANT FUNDING 15,067,836 TOTAL REVENUES $ 29,480,032 EXPENSES (Not Including Depreciation or Amortization) OPERATING EXPENSES -WATER DEPT $ 1,628,105 OPERATING EXPENSES -MAINTENANCE DEPT 2,463,249 OPERATING EXPENSES -WASTEWATER DEPT 1,107,008 OPERATING EXPENSES -ADMINISTRATIVE DEPT 2,120,916 OPERATING EXPENSES -METER READER DEPT 268,572 DEBT SERVICE -INTEREST PAYMENTS 531,775 DEBT SERVICE -PRINCIPAL PAYMENTS 1,885,391 TRANSFERS & RESTRICTIONS 4,407,180 GRANT FUNDED CIP EXPENDITURES 15,067,836 TOTAL EXPENSES $ 29,480,032 BUDGETED SURPLUS OR (DEFICIT) $ FINAL BUDGET News - R