Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
08.d EDB 2024-07 Board Financial Package
(CONATIM-Dcl. cot/A/ Clay County Utility Authorityworking together to 3176 Old Jennings Road protect public health, Middleburg,FL 32068-3907 conserve our natural Telephone(904)272-5999 resources,and create AintA www.clayutility.org long-term value for our ratepayers. October 28, 2024 To: Board of Supervisors From: Karen Osborne Re: July 2024 Financial Package I have enclosed the following financial information: A) Comparative Financial Statements for the ten months of fiscal years 2023/2024 and 2022/2023. Comparative Balance Sheet Revenue & Expenditure Report Cash-flow Statement B) Cash &Cash Equivalents Report as of July 31, 2024 C) Budget Reports for the ten months of Fiscal Year 2023/2024 Operating and Interest Revenue Detail Budget Report Operating Expense Detail Budget Report D) Contributions In Aid of Construction (CIAC) Reports: Summary of total CIAC through July 31, 2024 Alternative Water Supply Details E) Capital Projects Reports: Capital Projects Budget Report F) Operating Detail by Month Operating Revenues Detail by Month Revenue Analysis Summary Operating Expense Detail by Month G) Other Reports Construction Department Budget—Work in Progress Operating income is$4,300,669 (30%) over budget due to a favorable revenue and favorable expense variance. Operating revenue is$1,521,382 (3%) over budget and Operating expenses are $2,779,287 (7%) under budget. Itemized operating expense variances are in Section C. We gained 1,407 active (Residential 1,379, General Service 28) water accounts and 1,391 active sewer(1,362 Residential, General Service 29) accounts for the fiscal year 2023/2024 as compared to an increase of 1,238 active water accounts and an increase of 1,249 active sewer accounts for the same time in fiscal year 2022/2023. 1 CLAY COUNTY UTILITY AUTHORITY COMPARATIVE FINANCIAL STATEMENTS FISCAL YEAR 2023/2024 Section A CCUA Balance Sheet - Update 04:58 PM 10/25/2024 Page 1 of 1 Period: FY2024-Jul Ledger Account Summary Current Year YTD Prior Year YTD Assets Cash 32,249,168.53 23,645,027.23 Investments 62,322,339.47 116,458,282.66 Accounts Receivable 6,817,563.62 3,557,773.93 Current Receivables 80,879.07 43,369.77 Other Current Assets 825,282.87 720,355.37 Inventory 809,277.89 776,517.69 Net Fixed Assets 352,600,441.75 307,101,580.82 Construction in Progress 152,928,246.79 82,272,779.36 Other Long-Term Assets 299,169.77 301,709.88 Deferred Outflow of Resources 1,322,925.22 1,518,988.26 Total Assets 610,255,294.98 536,396,384.97 Liabilities Current Liabilities 28,453,052.49 24,312,268.83 Long-Term Liabilities 175,480,848.97 152,503,885.84 Total Liabilities 203,933,901.46 176,816,154.67 Fund Balance Retained Earnings- Unreserved 62,657,550.17 57,795,484.23 Investment in Capital Assets 340,189,417.47 298,621,858.71 Total Fund Balance 402,846,967.64 356,417,342.94 Net of Revenues&Expenditures 3,474,425.88 3,162,887.36 Total Liabilities&Fund Balance 610,255,294.98 536,396,384.97 3 Page 1 of 3 CCUA Balance Sheet - Detail Period: FY2024 -Jul Ledger Account Summary Current Year YTD Prior Year YTD Assets Cash 1000:Cash 31,901,758.53 23,641,873.26 1015:Cash in Transit 55,406.00 0.00 1016:Cash in Transit-Billing 289,098.09 0.00 1050:Petty Cash 2,905.91 3,153.97 Total Cash 32,249,168.53 23,645,027.23 Investments 1500:Investments 41,465,574.17 46,437,858.00 1501:Truist Escrow Investment Account 35,005.86 70,020,424.66 1502:Investments- LAMPA 20,821,759.44 0.00 Total Investments 62,322,339.47 116,458,282.66 Accounts Receivable 1100:Accounts Receivable W&S Cust 1,739,702.27 1,244,092.72 1101:Unbilled Receivables 5,188,237.36 897,707.21 1102:Accrued Accounts Receivable 0.00 1,023,999.55 1103:Accounts Receivable Unbilled Reuse Revenue 0.00 201,022.94 1104:A/R CIAC & Misc Repair Invs 82,812.46 410,789.68 1105:Accounts Receivable Clearing Account 466.08 (862.25) 1150:Allowance for Doubtful Accounts (193,654.55) (218,975.92) Total Accounts Receivable 6,817,563.62 3,557,773.93 Current Receivables 1620:Unused Postage 50,017.44 23,468.54 1630:Loans To Customers 30,861.63 19,901.23 Total Current Receivables 80,879.07 43,369.77 Other Current Assets 1160:Interest Receivable 152,785.72 324,159.40 1170:Prepaid Assets 672,497.15 396,195.97 1250:Other Receivable 0.00 0.00 Total Other Current Assets 825,282.87 720,355.37 Inventory 1600:Inventory 809,277.89 776,517.69 Total Inventory 809,277.89 776,517.69 Net Fixed Assets 1700:Buildings 15,588,674.68 11,016,436.58 1701:Intangible Assets 7,511,306.90 3,866,031.40 1702:Land 5,268,724.07 5,268,724.07 1703:Machinery& Equipment 535,202,985.14 482,792,395.21 1790:Accumulated Depreciation (210,698,816.19) (195,842,006.44) 1791:Accumulated Amortization (272,432.85) 0.00 Total Net Fixed Assets 352,600,441.75 307,101,580.82 Construction in Progress 1750:Construction in Progress 152,928,246.79 82,272,779.36 Total Construction in Progress 152,928,246.79 82,272,779.36 Other Long-Term Assets 1800:Loan to Customers_Long-term 299,169.77 301,709.88 Total Other Long-Term Assets 299,169.77 301,709.88 4 Page 2 of 3 CCUA Balance Sheet - Detail Period: FY2024 -Jul _ Ledger Account Summary Current Year YTD Prior Year YTD Deferred Outflow of Resources 1200: Deferred Outflow of Resources 1,322,925.22 1,518,988.26 Total Deferred Outflow of Resources 1,322,925.22 1,518,988.26 Total Assets 610,255,294.98 536,396,384.97 Liabilities Current Liabilities 2000:Accounts Payable 10,296,784.57 8,927,435.17 2004:AP- Customer Refunds Clearing 81.47 0.00 2310:Retainage Payable 3,336,265.88 1,542,697.65 2005:Due to Eagle Harbor (49.21) 0.00 2011:Procurement Card Payable 44,893.08 0.00 2012:Expenses Payable 939.00 0.00 2014:Virtual Card Payable 591,431.66 0.00 2020:Accrued Electric Expense Due 129,063.77 131,366.93 2030:Accrued Interest 1,457,931.44 724,146.39 2280:Florida Unemployment/Abandoned Property (50.62) 0.00 2290:JAX Public Service Tax Collected 369.66 271.56 2100:Accrued Pension Due 0.00 127,623.14 2101:Accrued Sick and Vacation Payable 801,913.69 726,341.31 2102:Payroll Liabilities Payable 78,081.94 6,159.92 2103:Accrued Worker's Comp Insurance Due 0.00 31,522.90 2104:Accrued Wages Payable 0.00 549,889.89 2108:Employee FIT, FICA, Medicare Withholding 0.00 97,631.67 2109:Employee Fund Withheld 0.00 2,071.48 2060:Due to Lend a Helping Hand 4,096.30 95.09 2117:Net Payroll Payable 0.00 0.00 2118:Payroll Forward Accrual 170,121.88 0.00 2200:Bond Deposits 162,192.17 105,169.84 2210:Current Bond Principal Due 7,059,376.15 7,092,768.01 2220:Cleaning Water Deposits 161,802.60 139,419.31 2300:Refundable Development Agreements 9,453.72 4,608.41 2330:W&S Customer Deposits 4,139,193.78 3,761,630.06 2340:Keystone Public Service Tax (2,000.11) 15.25 9999:Cash Conversion Clearing 11,159.67 0.00 2240:Deferred Reuse Revenue 0.00 40,814.96 2250:Deferred Revenue Sewer 0.00 202,807.14 2260:Deferred Revenue Water 0.00 97,782.75 Total Current Liabilities 28,453,052.49 24,312,268.83 Long-Term Liabilities 2500:2012 BBVA Compass Loan 0.00 1,901,056.00 2501:2014 DEP Payable 522,165.71 622,497.36 2502:2018 Revenue Bonds Payable DEP 10,147,814.41 10,774,922.49 2504:Contra Current Bond Principal (7,059,376.15) (7,092,768.01) 2505:Dell Financing Lease 0.00 0.00 2506:SunTrust 2015 Adv Ref 2007 Bonds 31,575,245.00 33,133,178.00 2507:Suntrust 2019 Loan & Refinance 35,295,000.00 38,165,000.00 2508:2023 Truist Revenue Bond 75,000,000.00 75,000,000.00 2510:2024 Webster Revenue Bond 30,000,000.00 0.00 Total Long-Term Liabilities 175,480,848.97 152,503,885.84 5 Page 3 of 3 CCUA Balance Sheet - Detail Period: FY2024 -Jul Ledger Account Summary Current Year YTD Prior Year YTD Total Liabilities 203,933,901.46 176,816,154.67 Fund Balance Retained Earnings- Unreserved 62,657,550.17 57,795,484.23 Investment in Capital Assets 2710:Grants 28,248,778.30 27,771,803.52 2720:AWS CIAC 9,619,293.86 8,304,401.91 2721:Debt Service Charges 2,053,310.01 1,636,014.46 2722:Fire Capacity Charges 2,227,641.82 2,103,720.00 2723:Sewer Capacity Charges 61,917,508.54 54,521,681.00 2724:Sewer Contributed Assets 139,052,631.28 117,910,714.53 2725:Sewer Main Extension Charge 6,325,518.38 5,532,751.75 2726:Sewer TAP in Charge 2,707,816.41 2,576,095.30 2727:SJRWMD Black Creek CIAC 1,566,515.04 1,317,509.10 2728:Water Capacity Charges 12,433,140.84 11,785,035.41 2729:Water Contributed Assets 67,804,810.73 59,319,200.61 2730:Water Main Extension Charge 3,664,634.54 3,376,345.49 2731:Water Tap in Charge 2,567,817.72 2,466,585.63 Total Investment in Capital Assets 340,189,417.47 298,621,858.71 Total Fund Balance 402,846,967.64 356,417,342.94 Net of Revenues & Expenditures 3,474,425.88 3,162,887.36 Total Liabilities & Fund Balance 610,255,294.98 536,396,384.97 6 CCUA Income Statement 04:53 PM 10/25/2024 Page 1 of 1 Period: FY2024-Jul Ledger Account Current Year YTD Prior Year YTD Revenue Water Revenues 24,155,168.74 20,925,987.19 Sewer Revenue 28,634,821.94 25,555,729.90 Miscellaneous Revenue 1,785,449.83 1,990,765.44 Interest Unrestricted 2,283,961.53 1,082,998.13 Sale of Assets 0 96,625.00 Construction Income 50,256.75 50,153.09 Total Revenue 56,909,658.79 49,702,258.75 Expenditures Salary&Benefits Salaries 12,344,566.14 10,834,402.54 Benefits 4,697,958.45 4,329,244.99 Project Labor Recovery (62,657.97) 0 Total Salary&Benefits 16,979,866.62 15,163,647.53 General&Administrative Expenditures Bad Debt (2,110.29) (4,303.30) Communications 337,584.17 324,791.21 Due in Lieu of Taxes 2,373,478.83 2,091,677.16 Electric& Fuel Expenses 2,348,830.10 2,531,897.29 Miscellaneous Expense 566,663.01 223,943.38 Property&Liability Insurance 1,496,676.95 848,749.32 Professional Services 584,600.83 911,914.88 Sludge Treatment& Disposal 2,352,419.36 2,240,387.95 Subcontractors 2,711,001.52 2,779,092.67 Suppliers 5,671,337.47 5,169,656.03 Transportation 614,436.48 521,314.21 Depreciation 12,452,495.95 11,420,295.69 Amortization 272,432.85 0 Interest Expense 4,467,852.07 2,013,787.42 Construction Expense 167,366.99 161,269.95 Debt Issuance Costs 40,300.00 141,250.00 Total G&A Expenditures 36,455,366.29 31,375,723.86, Total Expenditrues 53,435,232.91 46,539,371.39 Net of Revenue&Expenditures 3,474,425.88 3,162,887.36 7 CLAY COUNTY UTILITY AUTHORITY STATEMENTS OF CASH FLOWS FOR THE TEN MONTHS ENDED JULY 31,2023 AND 2024 July 31,2024 July 31,2023 Cash flows from operating activities $ 17,022,648 $ 19,336,276 Net cash provided by operating activities 17,022,648 19,336,276 Cash flows from capital and related financing activities Proceeds from issuance of bonds and loans 30,000,000 75,000,000 Principal paid on long-term debt (6,743,610) (6,875,967) Interest paid on long-term debt (4,301,931) (1,919,604) Payments to acquire and construct plant property (83,263,024) (40,113,848) Capital contributions 9,552,369 9,252,210 Grants 590,573 1,805,521 Net cash used in capital and related financing activities (54,165,623) 37,148,312 Cash flows from investing activities Purchases of investments (22,822,179) (70,830,300) Sales of investments 61,536,290 7,000,000 Interest income 2,283,962 1,082,998 Net cash provided by investing activities 40,998,073 (62,747,302) Net increase(decrease)in cash and cash equivalents 3,855,098 (6,262,714) Cash and cash equivalents,beginning of period 28,049,566 29,907,741 Cash and cash equivalents,end of period $ 31,904,664 $ 23,645,027 Reconciliation of operating income to net cash provided by operating activities Cash flows from operating activities Operating income $ 5,658,316 $ 3,997,052 Adjustments to reconcile operating income to net cash provided by operating activities: Depreciation and Amortization expense 12,751,400 11,441,557 Changes in assets and liabilities Decrease(Increase)in notes and accounts receivable (2,371,245) 1,018,277 Decrease(Increase)in prepaid items and inventory (187,132) (260,852) Decrease(Increase)in interest receivable 157,317 (163,582) Increase(Decrease)in accounts payable 1,292,290 3,118,082 Increase(Decrease)in accrued expenses (238,865) 201,434 Increase(Decrease)in unearned revenue (444,785) (161,291) Increase(Decrease)in customer deposits 405,352 145,600 Total adjustments 11,364,331 15,339,224 Net cash provided by operating activities $ 17,022,648 $ 19,336,276 Supplemental schedule of noncash investing,capital,and financing activities Utility plant property contributed by developers $ 23,480,500 $ 20,956,387 8 Cumulative Cash Flow $160,000,000 $140,000,000 $120,000,000 $100,000,000 $80,000,000 II I$60,000,000 $40,000,000 7- $20,000,000 • $0 — — , �e o°� °, Oec �a� <<e'so. \.\\ P�� �a� ��� �s\ P°� cpe� o°� °, Oec Sao Few Cash Investments 9 CLAY COUNTY UTILITY AUTHORITY CASH AND CASH EQUIVALENTS REPORT As of July 31, 2024 Truist Ameris SBA Investments Total Lend A Helping Hand Fund $469 $469 Operating Accounts ** $15,875,574 $15,875,574 FSA Account $20,750 $20,750 Emergency Accounts $15,066 $15,066 Petty Cash $2,906 $2,906 Total Operating Funds $15,914,296 $15,914,296 Public Funds Now: Water Plant Connection Fund $162,017 * $162,017 R Water Line Connection Fund $35,606 * $35,606 R Sewer Plant Connection Fund $915,174 * $915,174 R Sewer Lines Connection Fund $456,919 * $456,919 R Alternative Water Supply Fund $1,356,135 * $1,356,135 R Renewal&Replacement Fund $884,509 * $884,509 R Debt Stabilization and Reserve Account_Unrestricted $1,237,705 * $1,237,705 Truist Escrow Investment Account $35,006 $35,006 R LAMPA Investment Account $20,821,759 $20,821,759 R Surplus Fund $1,505,700 $447,211 $116,311 $41,465,574 $43,534,796 Available For Construction $6,553,766 $447,211 $116,311 $62,322,339 $69,439,627 Debt Service Sinking Funds: 2015 Refunding Sinking Fund $3,921,169 * $3,921,169 R DEP Loan Debt Service Sinking Acct $34,117 * $34,117 R 2018 Bond Sinking Fund $417,971 * $417,971 R Debt Stabilization and Reserve Account_Restricted Letter of Credit_Financial Responsible Officer $102,449 $102,449 R Customer Deposits&Self Insurance Fund Customer Deposits $3,871,906 $3,871,906 R Self Insurance Fund Sewage Backups $500,000 $500,000 Unemployment $25,000 $25,000 TOTAL Funds $4,475,705 $4,396,906 - - $8,872,612 TOTAL CASH&CASH EQUIVALENTS $26,944,236 $4,844,117 $116,311 $62,322,339 $94,227,004 Investment Accounts Maturity Date Balance APY US Bank Various $41,465,574 3.51% US Bank-LAMPA Immediate $20,821,759 4.91% Truist Escrow Investment Account Monthly $35,006 3.55% $62,322,339 * BB&T Public Funds Money Checking Accounts $9,421,322 0.25% BB&T Public Funds Money Checking Accounts $15,875,574 0.25% Ameris Public Funds Money Checking Accounts $4,844,117 1.20% SBA $116,311 4.84% Construction Balance $69,439,627 Operating Cash $13,875,574 Available Construction Balance: $83,315,201 "R"indicates fund is Restricted by Bond Resolution,Enabling Legislation or Board Resolution. Section B Printed 10/28/2024 CLAY COUNTY UTILITY AUTHORITY BUDGET REPORTS FISCAL YEAR 2023/2024 Section C CCUA Operating Budget Report 05:06 PM 10/25/2024 Page 1 of 1 Organization: Fund: General Fund Plan Structure:Amended Budget by Period Time Period: Current Year Period: FY2024-Jul Ledger Account Budget Current Year YTD Available Balance % Budget Used Operating Revenues Water Revenues Water Base Charges 9,149,204.00 7,456,256.84 1,692,947.16 81.50% Water Use Charges 12,140,254.00 10,976,708.56 1,163,545.44 90.42% Reuse Water Base Charges 3,758,600.00 3,195,710.23 562,889.77 85.02% Reuse Water Use Charges 2,827,035.00 2,526,493.11 300,541.89 89.37% Total Water Revenues 27,875,093.00 24,155,168.74 3,719,924.26 86.66% Sewer Revenues Sewer Base Charges 18,609,426.00 16,092,855.67 2,516,570.33 86.48% Sewer Use Charges 15,452,807.00 12,541,966.27 2,910,840.73 81.16% Total Sewer Revenues 34,062,233.00 28,634,821.94 5,427,411.06 84.07% Miscellaneous Revenue 1,948,323.00 1,785,449.83 162,873.17 91.64% Total Operating Revenues 63,885,649.00 54,575,440.51 9,310,208.49 85.43% Interest Income 855,625.56 2,283,961.53 (1,428,335.97) 266.93% Operating Expenses Salary&Benefits Salaries&Wages 14,855,843.19 12,344,566.14 2,511,277.05 83.10% Employee Benefits 5,677,562.75 4,697,958.45 979,604.30 82.75% Project Labor Recovery 0 (62,657.97) 62,657.97 0.00% Bad Debt 500.00 (2,110.29) 2,610.29 (422.06%) Communications 445,190.00 337,584.17 107,605.83 75.83% Due in Lieu of Taxes 2,787,180.00 2,373,478.83 413,701.17 85.16% Electric& Fuel Expenses 3,424,866.00 2,348,830.10 1,076,035.90 68.58% Miscellaneous Expense 508,598.00 566,663.01 (58,065.01) 111.42% Property&Liability Insurance 1,715,193.00 1,496,676.95 218,516.05 87.26% Professional Services 1,372,189.24 584,600.83 787,588.41 42.60% Sludge Treatment& Disposal 2,805,750.00 2,352,419.36 453,330.64 83.84% Subcontractors 5,264,150.56 2,711,001.52 2,553,149.04 51.50% Supplies 6,221,646.64 5,671,337.47 550,309.17 91.15% Transportation 732,940.00 614,436.48 118,503.52 83.83% Total Operating Expenses 45,811,609.38 36,034,785.05 9,776,824.33 78.66% Non-Operating Expenses Depreciation 13,615,661.00 12,452,495.95 1,163,165.05 91.46% Amortization 0 272,432.85 (272,432.85) 0.00% Interest Expense 2,914,754.00 4,467,852.07 (1,553,098.07) 153.28% Sale of Assets 0 0 0.00 0.00% Debt Issuance Costs 0 40,300.00 (40,300.00) 0.00% Total Non-Operating Expenses 16,530,415.00 17,233,080.87 (702,665.87) 104.25% Construction Income 526,841.00 50,256.75 476,584.25 9.54% Construction Expense 526,841.46 167,366.99 359,474.47 31.77% Contingency 775,383.00 0 775,383.00 0.00% Net of RP.yAnI P.f3 Expenditures 1,693,866 79 3,474,425 RR (1 R50.559.16) 213 96% 12 CCUA Operating Expense Report - Board 05:08 PM 10/25/2024 Page 1 of 2 Organization: Fund: General Fund Plan Structure:Amended Budget by Period Time Period: Current Year Period: FY2024-Jul Ledger Account Budget Current Year YTD Available Balance % Budget Used SALARIES&WAGES Accrued wages 0 (276,119.72) 276,119.72 0.00% Capitalized Wages 0 (16,790.83) 16,790.83 0.00% Emergency Pay 0 9,102.78 (9,102.78) 0.00% Employee Wages 0 690.00 (690.00) 0.00% Overtime Wages 670,966.84 585,995.55 84,971.29 87.34% Tuition Reimbursement 0 8,257.29 (8,257.29) 0.00% Wages Hourly 8,945,500.59 4,334,408.92 4,611,091.67 48.45% Wages Salary 5,239,375.76 6,576,833.06 (1,337,457.30) 125.53% (Blank) 0 1,122,189.09 (1,122,189.09) 0.00% SUBTOTAL 14,855,843.19 12,344,566.14 2,511,277.05 83.10% EMPLOYEE BENEFITS Employee Health and Life Insurance 2,850,793.41 2,156,526.68 694,266.73 75.65% Employee Retirement and Benefits 1,516,339.47 722,238.15 794,101.32 47.63% Employer Fica Payroll Taxes 1,063,761.30 768,172.29 295,589.01 72.21% Job Pension Expense 0 410,914.24 (410,914.24) 0.00% Wellness 50,000.00 28,456.41 21,543.59 56.91% Workers Comp Insurance 196,668.57 160,669.95 35,998.62 81.70% (Blank) 0 450,980.73 (450,980.73) 0.00% SUBTOTAL 5,677,562.75 4,697,958.45 979,604.30 82.75% PROJECT LABOR RECOVERY Employee Health and Life Insurance 0 (10,072.75) 10,072.75 0.00% Employer Fica Payroll Taxes 0 (3,287.26) 3,287.26 0.00% Job Pension Expense 0 (3,504.16) 3,504.16 0.00% Overtime Wages 0 (495.87) 495.87 0.00% Wages Salary 0 (44,381.18) 44,381.18 0.00% Workers Comp Insurance 0 (916.75) 916.75 0.00% SUBTOTAL 0 (62,657.97) 62,657.97 0.00% BAD DEBT Bad Debt Expense 500.00 (2,110.29) 2,610.29 (422.06%) SUBTOTAL 500.00 (2,110.29) 2,610.29 (422.06%) COMMUNICATIONS Communication Expenses 445,190.00 337,584.17 107,605.83 75.83% SUBTOTAL 445,190.00 337,584.17 107,605.83 75.83% DUE IN LIEU OF TAXES Due in Lieu of Taxes 2,787,180.00 2,373,478.83 413,701.17 85.16% SUBTOTAL 2,787,180.00 2,373,478.83 413,701.17 85.16% ELECTRIC&FUEL EXPENSES Electric and Fuel 3,424,866.00 2,348,830.10 1,076,035.90 68.58% SUBTOTAL 3,424,866.00 2,348,830.10 1,076,035.90 68.58% MISCELLANEOUS EXPENSE Advertising Expense 76,137.00 27,421.63 48,715.37 36.02% Bank Fees 57,625.00 39,772.80 17,852.20 69.02% Miscellaneous Expense 312,069.00 482,117.72 (170,048.72) 154.49% Rental Expense 62,767.00 17,350.86 45,416.14 27.64% SUBTOTAL 508,598.00 566,663.01 (58,065.01) 111.42% PROPERTY&LIABILITY INSURANCE Property Insurance 1,715,193.00 1,496,676.95 218,516.05 87.26% SUBTOTAL 1,715,193.00 1,496,676.95 218,516.05 87.26% PROFESSIONAL SERVICES 13 CCUA Operating Expense Report - Board 05:08 PM 10/25/2024 Page 2 of 2 Ledger Account Budget Current Year YTD Available Balance % Budget Used Accounting Audit Expense 34,500.00 27,500.00 7,000.00 79.71% Employee Training and Travel 359,495.00 122,741.83 236,753.17 34.14% Engineering Expense 265,000.00 194,073.14 70,926.86 73.24% Legal Expenses 661,000.00 197,101.34 463,898.66 29.82% Salaries for Board Members 52,194.24 43,184.52 9,009.72 82.74% SUBTOTAL 1,372,189.24 584,600.83 787,588.41 42.60% SLUDGE TREATMENT& DISPOSAL Sludge Removal 2,220,000.00 1,863,379.26 356,620.74 83.94% Sludge Treatment 585,750.00 489,040.10 96,709.90 83.49% SUBTOTAL 2,805,750.00 2,352,419.36 453,330.64 83.84% SUBCONTRACTORS Subcontractors 4,757,128.56 2,387,446.84 2,369,681.72 50.19% Subcontractors Testing 350,000.00 197,187.69 152,812.31 56.34% Trash Service 157,022.00 126,366.99 30,655.01 80.48% SUBTOTAL 5,264,150.56 2,711,001.52 2,553,149.04 51.50% SUPPLIES Brass Fittings 0 73,594.47 (73,594.47) 0.00% Chemicals 1,243,000.00 1,395,569.91 (152,569.91) 112.27% Furniture 15,150.00 3,716.91 11,433.09 24.53% Inventory 0 1,842.00 (1,842.00) 0.00% Software 1,516,844.93 814,256.51 702,588.42 53.68% Supplies Field 2,847,084.71 2,984,561.97 (137,477.26) 104.83% Supplies Office 599,567.00 394,194.51 205,372.49 65.75% Tools and Supplies 0 3,601.19 (3,601.19) 0.00% SUBTOTAL 6,221,646.64 5,671,337.47 550,309.17 91.15% TRANSPORTATION Fleet Repair and Maintenance 0 188,749.45 (188,749.45) 0.00% Transportation Expenses 732,940.00 425,687.03 307,252.97 58.08% SUBTOTAL 732,940.00 614,436.48 118,503.52 83.83% Total Operating Expenses 45,811,609.38 36,034,785.05 9,776,824.33 78.66%i 14 CLAY COUNTY UTILITY AUTHORITY CIAC REPORTS FISCAL YEAR 2023/2024 Section D CCUA CIAC Report 05:09 PM 10/25/2024 Page 1 of 1 Period: FY2024-Jul Ledger Account Beginning Year Balance Activity for the Month Year To Date Ending Balance Contributions in Aid of Construction Grants 27,658,205.44 500,000.00 590,572.86 28,248,778.30 Water Capacity Charges 11,856,865.36 35,735.96 576,275.48 12,433,140.84 Sewer Capacity Charges 55,213,975.78 265,301.54 6,703,532.76 61,917,508.54 Fire Capacity Charges 2,132,781.82 0 94,860.00 2,227,641.82 Alternative Water Supply Charge 8,498,767.35 92,965.00 1,120,526.51 9,619,293.86 SJRWMD Black Creek Charge 1,445,756.11 7,617.15 120,758.93 1,566,515.04 Debt Service Charge 1,720,422.96 5,999.93 332,887.05 2,053,310.01 Water Tap-In Charge 2,479,403.92 4,026.77 88,413.80 2,567,817.72 Sewer Tap-In Charge 2,605,628.70 32,007.64 102,187.71 2,707,816.41 Water Main Extension Charge 3,547,145.50 13,405.76 117,489.04 3,664,634.54 Sewer Main Extension Charge 6,030,080.52 26,222.17 295,437.86 6,325,518.38 Water Contributed Assets 61,270,367.19 136,424.13 6,534,443.54 67,804,810.73 Sewer Contributed Assets 122,106,574.49 73,433.82 16,946,056.79 139,052,631.28 Total Contributions in Aid of 306,565,975.14 1,193,139.87 33,623,442.33 340,189,417.47 Construction 16 CLAY COUNTY UTILITY AUTHORITY 2023/2024 Alternative Water Supply Surcharges Beginning October November December January February March April May June July August September Balance Established 10/1/2015 Balance 2023 2023 2023 2024 2024 2024 2024 2024 2024 2024 2024 2024 9/30/2024 Expenditures: Job 991_FCOB Stormwater Harvesting Pilot Project 883,128.55 883,128.55 Stormwater Harvesting Study 49,842.66 49,842.66 Job 00119WP Aquifer Storage&Recovery(ASR) 1,580,081.04 1,580,081.04 Project Development Advisor 212,388.00 212,388.00 Horizontal Well Feasibility Study 38,788.00 38,788.00 Aquifer Recharge Feasibility Study&Siting 138,059.36 138,059.36 Lake Agresti Reservoir Feasibility Study 5,798.00 5,798.00 Job 20022WL Treatability Pilot Project-AWS Development 3,411,323.27 520,551.78 647,811.06 249,458.91 201,618.69 220,833.08 131,777.30 169,693.32 6,724.19 58,879.85 101,673.26 5,720,344.71 New Development: - Total Expenditures 6,319,408.88 520,551.78 647,811.06 249,458.91 201,618.69 220,833.08 131,777.30 169,693.32 6,724.19 58,879.85 101,673.26 0.00 0.00 8,628,430.32 Existing Customers: Revenue: Surcharge Fund(Existing Customers) 4,816,047.72 59,942.60 61,597.18 61,691.58 61,874.48 61,909.88 61,925.22 62,027.88 62,043.22 63,987.86 63,889.92 5,436,937.54 Connection Charge Fund(Growth) 3,556,606.86 88,008.65 101,083.96 8,912.93 16,301.14 29,876.78 40,802.51 108,593.05 63,584.08 83,810.18 99,621.57 4,197,201.71 Interest Income 40,273.79 40,273.79 Total Revenue 8,412,928.37 147,951.25 162,681.14 70,604.51 78,175.62 91,786.66 102,727.73 170,620.93 125,627.30 147,798.04 163,511.49 0.00 0.00 9,674,413.04 Balance 2,093,519.49 (372,600.53)(485,129.92) (178,854.40) (123,443.07) (129,046.42) (29,049.57) 927.61 118,903.11 88,918.19 61,838.23 0.00 0.00 1,045,982.72 Cash Balance 1,356,134.91 Done in following Month: Less Construction Costs transferred after month close (101,673.26) J/E-Adjustment True Up for Move-Ins/Move-Outs J/E-Interfund Transfer (208,478.93) 1,045,982.72 Page D-la 17 CLAY COUNTY UTILITY AUTHORITY CAPITAL PROJECT BUDGET REPORT FISCAL YEAR 2023/2024 Section E Clay County Utility Authority References Capital Projects Budget Report Prior Years Current Fiscal for Transfers Current Fiscal Financial Carry Over Current Fiscal Year Year Combined Transfers and Funds Spent @ Job Cost and Year Job Costs Job Description Project Phase Job Number Budget Adopted Budget Budgets Amendments 07/31/24 Balances To Fund Amendments 2023/2024 Departmental Capital 100 1,202,917.71 1,275,500.00 2,478,417.71 1,312,721.95 1,165,695.76 2,478,417.71 Upgrade Lift station 9-Meadowbrook Design 755 93,844.52 6,155.48 100,000.00 8,365.93 91,634.07 100,000.00 Engineering Cost Allocation Construction 9999999 0.00 0.00 198,715.09 (198,715.09) 0.00 Meadow Lake WTP-New Ground Storage Tank and Electrical Service upgrade Construction 00983WP 3,149,124.00 3,149,124.00 3,170,139.56 (21,015.56) 3,149,124.00 Henley Road 12"WM Loop-Sandridge to Small Lake Construction 01119WL 11,258.64 94,758.06 106,016.70 11,258.64 94,758.06 106,016.70 North Middleburg Water&Sewer Extension and Interconnection(Water Intercom Construction 02419WL 560,554.67 2,750,000.00 3,310,554.67 532,690.21 2,777,864.46 3,310,554.67 Rehab SP WW Clarifer#1/under drain 1-2 Construction 02519RR 1,549,176.20 0.00 1,549,176.20 1,436,025.38 113,150.82 1,549,176.20 Saratoga Springs WTP-Phase I Construction 03018WP 16,591,000.00 16,591,000.00 16,866,879.67 (275,879.67) 16,591,000.00 Ridgecrest WTP-Replace Softstart&Crossline Starters with VFD's Construction 20021RR 2,011,228.00 0.00 2,011,228.00 2,017,268.39 (6,040.39) 2,011,228.00 Purified Water Pilot Study Construction 20022WL 4,769,000.00 2,000,000.00 6,769,000.00 5,720,344.71 1,048,655.29 6,769,000.00 Plant Generators Construction 21002RR 0.00 500,000.00 500,000.00 0.00 500,000.00 500,000.00 Fleming Island Reg.WWTP-2nd BCR Plant,Two Tanks Construction 21010RR 7,200,000.00 1,680,000.00 8,880,000.00 6,081,815.00 2,798,185.00 8,880,000.00 CCUA Administrative Building Phase I Construction 21013AD 5,125,089.00 100,000.00 5,225,089.00 3,251,379.29 1,973,709.71 5,225,089.00 Lift Station#2 Upgrade Construction 21016RR 3,834,146.16 900,000.00 4,734,146.16 1,965,853.84 1,938,781.33 4,761,218.67 7 6,700,000.00 Ridaught WWTP Upgrades(Install Micro-screen,Grit Removal Equipment,and Influent,Rehabilitiation of Clarifier No.2) Construction 21019RR 2,887,000.00 1,185,000.00 4,072,000.00 3,908,278.51 163,721.49 4,072,000.00 Swimming Penn Creek WM Interconnect Construction 21020WL 2,250,000.00 1,810,000.00 4,060,000.00 2,600,000.00 2,924,387.08 3,735,612.92 6 6,660,000.00 Ravines to Henly Road Water Main Extension Construction 21023WL 2,250,000.00 2,400,000.00 4,650,000.00 2,934,268.79 1,715,731.21 4,650,000.00 Governor's Park WTP Design and Build Construction 21026WP 5,125,000.00 4,250,000.00 9,375,000.00 625,000.00 6,493,387.55 3,506,612.45 5 10,000,000.00 Meadowbrook Well Rehab Construction 21028RR 366,895.00 366,895.00 0.00 366,895.00 366,895.00 Meadowbrook WTP Upgrades-(GST#3 repair,Transfer switch,GST#2 roof repair,Aerator repair,replace 4 of the 5 HSP skids) Design 21029RR 2,082,308.00 2,517,692.00 4,600,000.00 544,735.91 4,055,264.09 4,600,000.00 Peters Creek WTP 2nd GST&3rd Well Design 21030WP 267,547.26 267,547.26 267,547.26 (0.00) 267,547.26 Peters Creek New Regional WRF Construction 22003SP 46,523,968.83 41,600,000.00 88,123,968.83 72,151,765.93 15,972,202.90 88,123,968.83 Ridaught WTP-Phase I GST Upgrades Design 22007RR 54,103.26 54,103.26 54,103.26 0.00 54,103.26 Lift Station#4 Upgrades Design 22008RR 800,000.00 400,000.00 1,200,000.00 46,443.91 1,153,556.09 1,200,000.00 Lift Station#62 and#67-Rehabilitation Design 22009RR 320,000.00 900,000.00 1,220,000.00 76,869.25 1,143,130.75 1,220,000.00 CCUA North Campus Driveway Design 22010AD 786,341.00 786,341.00 153,019.86 633,321.14 786,341.00 LAMPA E/W Interconnect#1 Water(Cathedral Oaks West-Green) Construction 22012WL 1,000,000.00 2,112,000.00 3,112,000.00 3,049,890.24 62,109.76 3,112,000.00 LAMPA E/W Interconnect#1 Wwtr-Reuse(Cathedral Oaks West-Green) Construction 22013SL 2,000,000.00 4,337,000.00 6,337,000.00 6,199,934.85 137,065.15 6,337,000.00 LAMPA E/W Interconnect#2 Water (Cathedral Oaks East-Blue) Design 22014WL 28,105.29 28,105.29 28,105.29 (0.00) 28,105.29 LAMPA E/W Interconnect#2 Wwtr-Reuse(Cathedral Oaks East-Blue) Design 22015SL 57,964.36 57,964.36 57,964.36 0.00 57,964.36 LAMPA N/S Interconnect#1 Water(SS WTP to Cathedral Oaks West-Red) Design 22016WL 17,319.95 17,319.95 17,319.95 0.00 17,319.95 LAMPA N/S Interconnect#1 Wwtr-Reuse(SS WTP to Cathedral Oaks West-P Design 22017SL 35,189.76 35,189.76 39,145.26 (3,955.50) 35,189.76 LAMPA N/S Interconnect#2 Water(Feed Mill Rd.-Black) Design 22018WL 10,298.93 10,298.93 10,298.93 (0.00) 10,298.93 LAMPA N/S Interconnect#2 Wwtr-Reuse (Feed Mill Rd.-Black) Design 22019SL 20,915.03 20,915.03 20,915.03 0.00 20,915.03 CR 218 widening from Pine Tree Lane to Cosmos Construction 22020RR 675,000.00 675,000.00 1,331,879.47 424,394.80 1,582,484.67 8 2,006,879.47 Emalyn Place 3 Single Family Units Construction 22021 WL 17,000.00 17,000.00 0.00 17,000.00 17,000.00 Postmaster WTP Electrical Upgrades Construction 23001WP 181,657.00 181,657.00 136,244.95 45,412.05 181,657.00 Potable and Reclaimed Water Meter and backflow device replacement Construction 23003RR 0.00 1,600,000.00 1,600,000.00 1,300,469.75 299,530.25 1,600,000.00 Miller WRF Electrical Upgrades&WWTP Upgrades Design 23004RR 155,005.00 81,000.00 236,005.00 192,148.54 43,856.46 236,005.00 Spencers WTP-Ground Storage&High Service Pump&Electrical Upgrades Design 23005RR 237,848.00 3,000,000.00 3,237,848.00 297,829.82 2,940,018.18 3,237,848.00 Pace Island&Fleming Oaks WTP Electrical Upgrades Design 23007RR 192,107.00 250,000.00 442,107.00 119,113.39 322,993.61 442,107.00 SCADA System Design 23008RR 250,000.00 250,000.00 500,000.00 48,500.00 451,500.00 500,000.00 Fleming island WRF electrical upgrades Nault upgrades Design 23009RR 296,171.00 1,786,190.00 2,082,361.00 279,125.39 1,803,235.61 2,082,361.00 ERP Software Replacement Construction 23010RR 2,843,782.00 1,622,922.00 4,466,704.00 4,725,406.88 (258,702.88) 4,466,704.00 Upgrade Lift Stations 11,41,69,51 Design 23012RR 158,092.80 500,000.00 658,092.80 243,730.80 414,362.00 658,092.80 Clay County-College Drive RRR Project Construction 23014WL 35,000.00 35,000.00 0.00 35,000.00 35,000.00 Sandridge Road widening from Henley to CR 209 and ForceMain Extension Construction 23015SL 2,040,000.00 2,040,000.00 1,623,712.44 416,287.56 2,040,000.00 CR 315 widening-Utility Relocation(design FY 23 construct FY 24) Construction 23017RR 922,000.00 922,000.00 0.00 922,000.00 922,000.00 Upsize Mains-Double Branch Cost Share Construction 23018WL 316,169.64 316,169.64 316,169.64 0.00 316,169.64 Knight Boxx/Old Jennings Force Main Extension and Lift Station 56 Design 23019SL 134,978.00 1,465,022.00 1,600,000.00 64,556.27 1,535,443.73 1,600,000.00 Water Service to 3255 Bliss Rd. Construction 23020WL 91,790.21 91,790.21 103,815.71 (12,025.50) 91,790.21 Upsizing Mains fro Bradley Creek to Russell Retreat Construction 23021WL 394,236.58 394,236.58 354,229.37 40,007.21 394,236.58 Water Service to 461 Creighton Rd. Construction 23022WL 71,520.73 71,520.73 71,955.32 (434.59) 71,520.73 Keystone Heights-Lakeside Street/Hilltop Street Water Main Rehabilitation Design 23024RR 237,600.00 237,600.00 88,902.47 148,697.53 237,600.00 Mid-Clay Entrance Road Stabilization Design 23025RR 50,000.00 50,000.00 30,052.31 19,947.69 50,000.00 Home Depot-Lowes Interconnect Construction 23026WL 23,664.53 23,664.53 22,465.48 1,199.05 23,664.53 Water Service to 879 Creighton Rd. Construction 23027WL 25,000.00 25,000.00 22,863.76 2,136.24 25,000.00 19 X5Finance\Controllers Folder\Monthly Financial\Monthly Construction Reports\2023-2024\CIP_2024.xlsx Page n of 3 Clay County Utility Authority References Capital Projects Budget Report Prior Years Current Fiscal for Transfers Current Fiscal Financial Carry Over Current Fiscal Year Year Combined Transfers and Funds Spent @ Job Cost and Year Job Costs Job Description Project Phase Job Number Budget Adopted Budget Budgets Amendments 07/31/24 Balances To Fund Amendments 2023/2024 Mid-Clay WRF Alternate Driveway Design 23028RR 1,200,000.00 1,200,000.00 81,490.80 1,118,509.20 1,200,000.00 Water Plant Meters Retrofits Construction 23029RR 108,000.00 300,000.00 408,000.00 190,236.92 217,763.08 408,000.00 Lake Asbury WM Improvements(602 Lake Asbury Road&Aldersgate St.) Construction 23030RR 1,530,000.00 1,530,000.00 74,773.52 1,455,226.48 1,530,000.00 Southern Baptist Hospital of Florida/cost participation w/development Construction 24001RR 0.00 195,435.28 195,435.28 0.00 1 195,435.28 Water Service to 646 Harrison Rd. Construction 24002WL 0.00 0.00 28,000.00 21,555.64 6,444.36 9 28,000.00 Upgrade Lift Station 20 Design 24003RR 0.00 0.00 125,000.00 26,522.04 98,477.96 2 125,000.00 Sugar Leaf Farms/cost participation w/development Construction 24004SL 0.00 260,834.63 260,834.63 0.00 3 260,834.63 Gravity Sewer Lining Construction 24005RR 406,692.68 1,000,000.00 1,406,692.68 894,260.39 512,432.29 1,406,692.68 Jeremy Hollow Subdivision/cost participation w/development Construction 24006WL 0.00 16,487.20 16,487.20 0.00 4 16,487.20 Keystone Wastewater Treatment Plant-Phase II Construction Construction 24007SP 0.00 500,000.00 500,000.00 125,116.46 374,883.54 500,000.00 FH and Gate Valve replacement Construction 24008RR 105,000.00 210,000.00 315,000.00 71,428.00 243,572.00 315,000.00 CR220 Quadrant Intersection Design 24009RR 578,000.00 578,000.00 0.00 578,000.00 578,000.00 12-inch Wm Keystone RV to Geneva lakes WTP 24011WP 0.00 2,300,000.00 2,300,000.00 12,893.27 2,287,106.73 2,300,000.00 Lift Station Bypass Pump 24012RR 200,000.00 200,000.00 202,538.26 (2,538.26) 200,000.00 Manhole Rehab 24014RR 150,000.00 150,000.00 300,000.00 106,012.19 193,987.81 300,000.00 Fleming BTU#1 Rehab design and construction 24016RR 0.00 500,000.00 500,000.00 13,000.00 487,000.00 500,000.00 Ravines Off-Site Mains-Middleburg W&S Extensions Not Started 1,238,000.00 1,238,000.00 0.00 1,238,000.00 1,238,000.00 Keystone Heights High School WM relocation Not Started 143,000.00 143,000.00 0.00 143,000.00 143,000.00 Upgrade Lift Station 20&56 Design Not Started 0.00 500,000.00 500,000.00 (125,000.00) 0.00 375,000.00 2 375,000.00 Miller St.WWTP Upgrades Influent Structure,Septage station&Electrical upgrades Not Started 0.00 375,000.00 375,000.00 0.00 375,000.00 375,000.00 New Lift Station Generators Not Started 0.00 350,000.00 350,000.00 0.00 350,000.00 350,000.00 12"Main Connecting Postmaters WTP to Geneva Lakes WTP along CR214 Not Started 0.00 0.00 0.00 0.00 0.00 12"WM Extension Hwy.100 to Brooklyn Bay Rd.(Keystone) Not Started 0.00 0.00 0.00 0.00 0.00 6"WM Extension Woodland Dr.to Payne Rd.via SR21 Not Started 0.00 0.00 0.00 0.00 0.00 Old Jennings WTP Electrical Upgrade Not Started 0.00 0.00 0.00 0.00 0.00 Tanglewood Electrical Upgrade Not Started 0.00 0.00 0.00 0.00 0.00 Orange Park South Electrical Upgrade Not Started 0.00 0.00 0.00 0.00 0.00 Ridaught WRF Electrical Upgrades Not Started 0.00 0.00 0.00 0.00 0.00 Spencer's WRF Electrical Upgrades Not Started 0.00 0.00 0.00 0.00 0.00 Oakleaf WTP Electrical Upgrades Not Started 0.00 0.00 0.00 0.00 0.00 Server Lifecycle Replacement Not Started 0.00 0.00 0.00 0.00 0.00 Upgrade Lift Station 98 Not Started 0.00 0.00 0.00 0.00 0.00 Upgrade Lift Stations 43,24,59 Not Started 0.00 0.00 0.00 0.00 0.00 Upgrade Lift Station Ill Not Started 0.00 0.00 0.00 0.00 0.00 Phase III Admin Building Not Started 0.00 0.00 0.00 0.00 0.00 CR 315 Peters Creek Spur(Orange) Not Started 0.00 0.00 0.00 0.00 0.00 16-inch WM Atlantis to Kindlewood Not Started 500,000.00 500,000.00 0.00 500,000.00 500,000.00 Upsizing pipes to accommodate Rookery GCS Not Started 0.00 466,000.00 466,000.00 0.00 466,000.00 466,000.00 Tanglewood Neighborhood Water Main Relocations Not Started 85,000.00 85,000.00 0.00 85,000.00 85,000.00 CR 220 widening Baxley to Henley Rd Design Not Started 250,000.00 510,000.00 760,000.00 0.00 760,000.00 760,000.00 CR 220 widening from Henley to Knightbox Design Not Started 50,000.00 20,000.00 70,000.00 0.00 70,000.00 70,000.00 Infill Projects Not Started 1,361,678.98 100,000.00 1,461,678.98 0.00 1,461,678.98 1,461,678.98 Well Rehab Not Started 0.00 150,000.00 150,000.00 0.00 150,000.00 150,000.00 Lead&Copper GSP replacement Design Not Started 0.00 60,000.00 60,000.00 0.00 60,000.00 60,000.00 Water Quality Lab Not Started 0.00 0.00 0.00 0.00 0.00 Chemical tanks Not Started 0.00 100,000.00 100,000.00 0.00 100,000.00 100,000.00 Facility Roof Repairs Not Started 0.00 100,000.00 100,000.00 0.00 100,000.00 100,000.00 -Reclaimed Transmission Main-Spencers to Oa deaf Not Started 0.00 0.00 0.00 0.00 0.00 -Reclaimed Transmission Main-Oakleaf to Challenger Not Started 0.00 0.00 0.00 0.00 0.00 -Reclaimed Transmission Main-Old Jennings Rd Bypass Not Started 0.00 0.00 0.00 0.00 0.00 -New Pumps-Old Jennings WRF pump station Not Started 0.00 0.00 0.00 0.00 0.00 -Reclaimed Water SCADA Not Started 0.00 530,000.00 530,000.00 0.00 530,000.00 530,000.00 Mid-Clay Rib Recovery pH adjustment evaluation Not Started 0.00 30,000.00 30,000.00 0.00 30,000.00 30,000.00 Evaluate replacement of 16"AC Pipe by Orange Park mall Not Started 0.00 30,000.00 30,000.00 0.00 30,000.00 30,000.00 -Geneva Lake Estates(Watermain-B)7,605 LF 12-inch WM Not Started 0.00 0.00 0.00 0.00 0.00 -Looping Fire Hydrants(Area D)170 LF 12-inch WM Not Started 0.00 0.00 0.00 0.00 0.00 -Looping Fire Hydrants(Area G)35LF of 6-inch WM Not Started 0.00 0.00 0.00 0.00 0.00 -Booster Pump Station Not Started 0.00 0.00 0.00 0.00 0.00 20 X:\Finance\Controllers Folder\Monthly Financial\Monthly Construction Reports\2023-2024\CIP_2024.xlsx Page 2 of 3 Clay County Utility Authority References Capital Projects Budget Report Prior Years Current Fiscal for Transfers Current Fiscal Financial Carry Over Current Fiscal Year Year Combined Transfers and Funds Spent @ Job Cost and Year Job Costs Job Description Project Phase Job Number Budget Adopted Budget Budgets Amendments 07/31/24 Balances To Fund Amendments 2023/2024 Treatment plant R&R Studies Not Started 0.00 500,000.00 500,000.00 0.00 500,000.00 500,000.00 Cost Participation w/Development Projects Not Started 0.00 1,659,369.32 1,659,369.32 (472,757.11) 0.00 1,186,612.21 1,3,4 1,186,612.21 Lift Station 88 Relocation Not Started 0.00 1,200,000.00 1,200,000.00 3,844.16 1,196,155.84 1,200,000.00 Commercial Meter Change outs Not Started 0.00 75,000.00 75,000.00 0.00 75,000.00 75,000.00 Pier Station E/W WM Extension and Interconnect(State Road 16 and FCOB) Not Started 0.00 50,000.00 50,000.00 0.00 50,000.00 50,000.00 Pier Station Force Main Extensions(State Road 16 and FCOB) Not Started 0.00 0.00 0.00 0.00 0.00 Pier Station Master Pump Station(State Road 16 and FCOB) Not Started 0.00 0.00 0.00 0.00 0.00 Pier Station WTP Expansion Not Started 0.00 0.00 0.00 0.00 0.00 Ravines WTP 2nd GST Not Started 0.00 0.00 0.00 0.00 0.00 Spencer's WWTP:Phase 6 Expansion Not Started 0.00 0.00 0.00 0.00 0.00 AMI Demand Management Not Started 0.00 0.00 0.00 0.00 Onsite Stormwater Harvesting Not Started 0.00 0.00 0.00 0.00 Public Access Reuse Storage Not Started 1,822,500.00 1,822,500.00 0.00 1,822,500.00 1,822,500.00 RENEWAL,REPLACEMENT&BETTERMENT SYSTEM EXPANSION ALTERNATIVE WATER SUPPLY Subtotals 127,501,372.01 95,215,608.86 222,716,980.87 6,550,733.31 152,974,160.27 76,293,553.91 229,267,714.18 Contingency 15,314,551.76 15,314,551.76 (6,550,733.31) 5-9 8,763,818.45 TOTAL CAPITAL EXPENDITURES 238,031,532.63 0.00 238,031,532.63 Construction In Progress 222,716,980.87 152,928,246.79 Not Started 11,657,791.19 Completed Jobs 45,913.48 Started 226,373,741.44 152,974,160.27 238,031,532.63 21 X:\Finance\Controllers Folder\Monthly Financial\Monthly Construction Reports\2023-2024\CIP_2024.xlsx Page 3 of 3 CLAY COUNTY UTILITY AUTHORITY OPERATING DETAIL BY MONTH FISCAL YEAR 2023/2024 Section F 22 CCUA Operating Revenue Budget Report 05:10 PM 10/25/2024 Page 1 of 2 Organization: Fund: General Fund Plan Structure:Amended Budget by Period Time Period: Current Year Period: FY2024-Jul Revenue by Category FY2024-Sep(YE_Sep) Current Month Current Year YTD %Budget Budget I Used Water Base Charges Commercial Potable Irrigation Base 299,078.00 18,105.84 193,089.27 64.56% General Service Water Base 1,434,056.00 105,627.05 1,144,279.06 79.79% Residential Water Base Charges 7,416,070.00 578,669.66 6,118,888.51 82.51% SUBTOTAL 9,149,204.00 702,402.55 7,456,256.84 81.50% Water Usage Charges Commercial Potable Irrigation Usage 678,133.00 99,728.78 599,684.87 88.43% Commercial Water Usage 2,633,109.00 252,882.12 2,213,069.84 84.05% Residential Water Usage 8,829,012.00 923,992.20 8,163,953.85 92.47% SUBTOTAL 12,140,254.00 1,276,603.10 10,976,708.56 90.42% Reuse Base Charges Reuse Commercial Base 337,285.00 27,144.84 279,871.10 82.98% Reuse Residential Base 3,421,315.00 276,569.77 2,915,839.13 85.23% SUBTOTAL 3,758,600.00 303,714.61 3,195,710.23 85.02% Reuse Usage Charges Crossings Reclaimed Water Charges 137,302.00 21,230.83 160,853.33 117.15% Reuse Commercial Usage 472,535.00 67,387.17 414,930.77 87.81% Reuse Residential Usage 2,217,198.00 272,102.89 1,950,709.01 87.98% SUBTOTAL 2,827,035.00 360,720.89 2,526,493.11 89.37% Total Water Revenues 27,875,093.00 2,643,441.15 24,155,168.74 86.66% Sewer Base Charges General Service Sewer Base 2,598,137.00 223,815.28 2,382,858.18 91.71% Residential Sewer Base Charge 16,011,289.00 1,763,210.24 13,709,997.49 85.63% SUBTOTAL 18,609,426.00 1,987,025.52 16,092,855.67 86.48% Sewer Usage Charges General Service Sewer Usage 3,718,832.00 352,493.36 3,324,165.18 89.39% Portalet Sewage Revenue 192,000.00 36,601.95 161,360.45 84.04% Residential Sewer Usage Charge 11,541,975.00 523,787.50 9,056,440.64 78.47% SUBTOTAL 15,452,807.00 912,882.81 12,541,966.27 81.16% Total Sewer Revenues 34,062,233.00 2,899,908.33 28,634,821.94 84.07% Total Base&Usage Charges 61.937.326.00 5.543.349.48 52.789.990.68 85.23% Miscellaneous Revenue Asbuilt Drawing Revenue 44,537.00 0 18,999.55 42.66% Cash Over/Short 0 (21.34) 143.88 0.00% Cut for Non Pay Service Charge 131,405.00 0 62,505.00 47.57% Guaranteed Revenue 4,544.00 994.50 3,978.00 87.54% Meter Installation Fee 868,500.00 46,541.03 873,736.33 100.60% Miscellaneous Repair Charges 11,997.00 0 10,169.23 84.76% Miscellaneous Revenue 0 4,863.48 148,428.74 0.00% Miscellaneous Service Charge 318,232.00 2,717.04 222,659.90 69.97% New Construction Inspection Charge 99,222.00 1,520.47 53,126.66 53.54% New Customer Service Charge 315,550.00 0 159,690.00 50.61% Plan Review Charge 44,964.00 1,193.50 31,290.75 69.59% Returned Check Service Charge 53,680.00 6,060.00 53,473.79 99.62% Trip Service Charge 42,219.00 34,980.00 136,770.00 323.95% Water-Sewer Line Permitting 13,473.00 560.00 10,780.00 80.01% Revenue (Blank) 0 0 (302.00) 0.00% SUBTOTAL 1,948,323.00 99,408.68 1,785,449.83 91.64% 23 CCUA Operating Revenue Budget Report 05:10 PM 10/25/2024 Page 2 of 2 Revenue by Category FY2024-Sep(YE_Sep) Current Month Current Year YTD %Budget Budget Used Total Operating Revenues 63,885,649.00 5,642 758.16 54,575,440.51 85.43% 24 Budgeted vs. Actual - Base & Use Charges, Total 35,000,000 30,000,000 25,000,000 r 20,000,000 - 1rS 15,000,000 10,000,000 I II IIIII 5,000,000 0 il October November December January February March April May June July August September Actual Base Charges Actual Use Charges Budgeted Base Charges Budgeted Use Charges Operating Revenue $8,000,000 $7,000,000 $6,000,000 • • • r $5,000,000 — — III PI II I $4,000,000 ____________ 1 $3,000,000 _ - V $2,000,000 r _ _....................r� 1 $1,000,000 Ips $0 October November December January February March April May June July August September Actual Optg Rev Prior Year Optg Rev Budgeted Optg Rev Operating Net Income $3,500,000 $3,000,000 $2,500,000 $2,000,000 41°;--- ;41111:01111hill Iiir $1,500,000 - — _...ar"1 $1,000,000 _-- 01 $500,000 $0 . October November December January February March April May June July August September Actual Net Income , II •PriorYear Net Income - Budgeted Net Income