Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
10.a EDB 2025 01 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. April 3, 2025 To: Board of Supervisors From: Karen Osborne Re: January 2025 Financial Package I have enclosed the following financial information: A) Comparative Financial Statements for the four months of fiscal years 2024/2025 and 2023/2024. Comparative Balance Sheet Revenue & Expenditure Report Cash-flow Statement B) Cash &Cash Equivalents Report as of January 31, 2025 C) Budget Reports for the four months of Fiscal Year 2024/2025 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 January 31, 2025 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 Operating income is$546,439 (8%) over budget due to an unfavorable revenue and favorable expense variance. Operating revenue is$970,178 (-4%) under budget and Operating expenses are$1,516,662 (9%) under budget. Itemized operating expense variances are in Section C. We gained 395 active (Residential 394, General Service 1)water accounts and 394 active sewer(Residential 394, General Service 0) accounts for the fiscal year 2024/2025 as compared to an increase of 243 active water accounts and an increase of 255 active sewer accounts for the same time in fiscal year 2023/2024. 1 CLAY COUNTY UTILITY AUTHORITY COMPARATIVE FINANCIAL STATEMENTS FISCAL YEAR 2024/2025 Section A CCUA Balance Sheet 05:59 PM 04/02/2025 Page 1 of 1 Period: FY2025-Jan Ledger Account Summary Current Year YTD Prior Year YTD Assets Cash 24,526,725.93 22,808,889.13 Investments 48,144,363.95 76,988,082.91 Accounts Receivable 5,453,345.07 3,087,053.81 Current Receivables 77,991.95 62,075.71 Other Current Assets 1,380,419.10 1,814,249.94 Inventory 1,193,936.37 719,029.09 Net Fixed Assets 392,382,768.96 343,385,638.91 Construction in Progress 154,113,140.54 102,610,433.59 Other Long-Term Assets 332,634.41 312,002.83 Deferred Outflow of Resources 1,230,156.70 1,415,693.74 Total Assets 628,835,482.98 553,203,149.66 Liabilities Current Liabilities 25,673,464.05 25,616,612.41 Long-Term Liabilities 173,239,760.85 148,715,465.23 Total Liabilities 198,913,224.90 174,332,077.64 Fund Balance Retained Earnings- Unreserved 65,273,623.34 62,657,550.17 Investment in Capital Assets 365,028,673.72 315,963,626.95 Total Fund Balance 430,302,297.06 378,621,177.12 Net of Revenues&Expenditures (380,038.98) 249,894.90 Total Liabilities&Fund Balance 628,835,482.98 553,203,149.66 3 Page 1 of 3 CCUA Balance Sheet - Detail Period: FY2025-Jan Ledger Account Summary Current Year YTD Prior Year YTD Assets Cash 1000:Cash 24,523,124.02 22,805,983.22 1015:Cash in Transit 1,106.84 0.00 1016:Cash in Transit-Billing (424.69) 0.00 1050:Petty Cash 2,919.76 2,905.91 Total Cash 24,526,725.93 22,808,889.13 Investments 1500:Investments 27,326,036.72 40,895,826.83 1501:Truist Escrow Investment Account 0.00 36,092,256.08 1502:Investments- LAMPA 20,818,327.23 0.00 Total Investments 48,144,363.95 76,988,082.91 Accounts Receivable 1100:Accounts Receivable W&S Cust 1,304,450.86 1,042,553.66 1101:Unbilled Receivables 4,364,927.69 727,146.69 1102:Accrued Accounts Receivable 0.00 1,059,406.57 1103:Accounts Receivable Unbilled Reuse Revenue 0.00 87,259.85 1104:A/R CIAC & Misc Repair Invs 95,341.47 366,593.19 1105:Accounts Receivable Clearing Account 5,536.97 (2,251.60) 1150:Allowance for Doubtful Accounts (316,911.92) (193,654.55) Total Accounts Receivable 5,453,345.07 3,087,053.81 Current Receivables 1620:Unused Postage 49,349.30 20,914.26 1630:Loans To Customers 28,642.65 41,161.45 Total Current Receivables 77,991.95 62,075.71 Other Current Assets 1160:Interest Receivable 124,177.37 264,823.53 1170:Prepaid Assets 1,256,241.73 1,549,426.41 Total Other Current Assets 1,380,419.10 1,814,249.94 Inventory 1600:Inventory 1,193,936.37 719,029.09 Total Inventory 1,193,936.37 719,029.09 Net Fixed Assets 1700:Buildings 21,586,126.19 15,240,674.68 1701:Intangible Assets 7,697,429.70 7,498,469.40 1702:Land 5,268,724.07 5,268,724.07 1703:Machinery& Equipment 571,412,972.27 518,555,414.51 1740:Subscription Based Asset 6,778,764.26 0.00 1790:Accumulated Depreciation (218,494,950.23) (203,177,643.75) 1791:Accumulated Amortization (1,866,297.30) 0.00 Total Net Fixed Assets 392,382,768.96 343,385,638.91 Construction in Progress 1750:Construction in Progress 154,113,140.54 102,610,433.59 Total Construction in Progress 154,113,140.54 102,610,433.59 Other Long-Term Assets 1800:Loan to Customers_Long-term 332,634.41 312,002.83 Total Other Long-Term Assets 332,634.41 312,002.83 4 Page 2 of 3 CCUA Balance Sheet - Detail Period: FY2025-Jan Ledger Account Summary Current Year YTD Prior Year YTD Deferred Outflow of Resources 1200: Deferred Outflow of Resources 1,230,156.70 1,415,693.74 Total Deferred Outflow of Resources 1,230,156.70 1,415,693.74 Total Assets 628,835,482.98 553,203,149.66 Liabilities Current Liabilities 2000:Accounts Payable 8,321,937.05 9,290,635.39 2004:AP-Customer Refunds Clearing 10,214.43 0.00 2310:Retainage Payable 2,822,126.90 2,634,243.58 2005:Due to Eagle Harbor (268.01) 0.00 2011:Procurement Card Payable 44,837.34 0.00 2012:Expenses Payable 974.56 0.00 2014:Virtual Card Payable 259,161.92 0.00 2020:Accrued Electric Expense Due 0.00 129,063.77 2030:Accrued Interest 1,486,465.09 1,146,985.62 2280:Florida Unemployment/Abandoned Property 0.00 29,229.81 2290:JAX Public Service Tax Collected 433.47 309.43 2100:Accrued Pension Due 0.00 68,190.54 2101:Accrued Sick and Vacation Payable 632,673.34 562,329.19 2102:Payroll Liabilities Payable (24,740.81) (248,684.11) 2103:Accrued Worker's Comp Insurance Due 0.00 16,843.06 2104:Accrued Wages Payable 0.00 119,576.26 2108:Employee FIT, FICA, Medicare Withholding 0.00 52,165.78 2109:Employee Fund Withheld 0.00 1,963.50 2060:Due to Lend a Helping Hand 814.61 403.68 2080:Escheatment Payable 66,218.48 0.00 2117:Net Payroll Payable 0.00 0.00 2118:Payroll Forward Accrual 295,084.64 0.00 2200:Bond Deposits 169,301.81 152,416.44 2205:Subscription Lease Payable- Current 0.00 0.00 2210:Current Bond Principal Due 7,209,488.04 7,059,376.15 2220:Cleaning Water Deposits 154,486.25 149,702.81 2300:Refundable Development Agreements 1,519.59 4,608.41 2330:W&S Customer Deposits 4,222,547.80 3,831,446.06 2340:Keystone Public Service Tax 0.00 28.59 9999:Cash Conversion Clearing 187.55 0.00 2240:Deferred Reuse Revenue 0.00 74,096.31 2250:Deferred Revenue Sewer 0.00 366,094.40 2260:Deferred Revenue Water 0.00 175,587.74 Total Current Liabilities 25,673,464.05 25,616,612.41 Long-Term Liabilities 2501:2014 DEP Payable 471,514.01 572,492.80 2502:2018 Revenue Bonds Payable DEP 9,832,048.08 10,462,103.58 2504:Contra Current Bond Principal (7,209,488.04) (7,059,376.15) 2506:SunTrust 2015 Adv Ref 2007 Bonds 28,348,379.00 31,575,245.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 2511:Subscription Lease Payable- Long Term 1,502,307.80 0.00 Total Long-Term Liabilities 173,239,760.85 148,715,465.23 Total Liabilities 198,913,224.90 174,332,077.64 5 Page 3 of 3 CCUA Balance Sheet - Detail Period: FY2025-Jan Ledger Account Summary Current Year YTD Prior Year YTD Fund Balance Retained Earnings- Unreserved 65,273,623.34 62,657,550.17 Investment in Capital Assets 2710:Grants 28,248,778.30 27,748,778.30 2720:AWS CIAC 10,266,447.94 8,840,418.10 2721:Debt Service Charges 2,426,871.13 1,830,664.46 2722:Fire Capacity Charges 2,267,957.32 2,164,401.82 2723:Sewer Capacity Charges 64,701,722.28 56,229,433.66 2724:Sewer Contributed Assets 151,316,669.30 127,331,128.82 2725:Sewer Main Extension Charge 7,115,619.35 6,046,683.07 2726:Sewer TAP in Charge 2,752,540.99 2,635,311.94 2727:SJRWMD Black Creek CIAC 1,633,230.64 1,468,936.55 2728:Water Capacity Charges 12,725,004.81 11,963,335.36 2729:Water Contributed Assets 74,995,499.05 63,632,775.36 2730:Water Main Extension Charge 3,980,450.63 3,555,479.38 2731:Water Tap in Charge 2,597,881.98 2,516,280.13 Total Investment in Capital Assets 365,028,673.72 315,963,626.95 Total Fund Balance 430,302,297.06 378,621,177.12 Net of Revenues & Expenditures (380,038.98) 249,894.90 Total Liabilities& Fund Balance 628,835,482.98 553,203,149.66 6 CCUA Income Statement 06:04 PM 04/02/2025 Page 1 of 1 Period: FY2025-Jan Ledger Account Current Year YTD Prior Year YTD Revenue Water Revenues 9,610,338.03 8,534,980.16 Sewer Revenue 12,031,613.93 10,957,833.50 Miscellaneous Revenue 731,440.74 588,817.21 Interest Unrestricted 662,952.60 956,902.39 Sale of Assets 0 0 Construction Income 68,343.06 23,005.79 Total Revenue 23,104,688.36 21,061,539.05 Expenditures Salary&Benefits Salaries 5,682,962.33 4,832,504.93 Benefits 2,107,126.05 1,942,927.02 Project Labor Recovery (97,942.97) 0 Total Salary&Benefits 7,692,145.41 6,775,431.95 General&Administrative Expenditures Bad Debt 287.24 264.58 Communications 118,333.64 132,041.07 Due in Lieu of Taxes 937,217.92 877,178.07 Electric& Fuel Expenses 851,826.83 735,962.08 Miscellaneous Expense 112,352.91 130,794.91 Property&Liability Insurance 453,761.80 639,306.24 Professional Services 487,759.44 211,654.49 Sludge Treatment& Disposal 1,005,620.01 898,035.60 Subcontractors 1,169,047.78 1,060,155.38 Suppliers 2,118,077.13 2,525,400.43 Transportation 260,549.59 222,978.55 Depreciation 5,440,763.30 4,948,574.47 Amortization 685,978.29 0 Interest Expense 2,071,449.02 1,573,230.25 Construction Expense 79,557.03 80,636.08 Debt Issuance Costs 0 0 Total G&A Expenditures 15,792,581.93 14,036,212.20 Total Expenditrues 23,484,727.34 20,811,644.15 Net of Revenue&Expenditures (380,038.98) 249,894.90 7 CLAY COUNTY UTILITY AUTHORITY STATEMENTS OF CASH FLOWS FOR THE FOUR MONTHS ENDED JANUARY 31,2024 AND 2025 January 31,2025 January 31,2024 Cash flows from operating activities $ 2,619,831 $ 5,093,720 Net cash provided by operating activities 2,619,831 5,093,720 Cash flows from capital and related financing activities Proceeds from issuance of bonds and loans - - Debt Issuance Costs - - Principal paid on long-term debt (3,945,303) (3,508,994) Interest paid on long-term debt (2,887,429) (1,811,023) Payments to acquire and construct plant property (15,744,244) (31,830,341) Capital contributions 3,690,194 1,720,116 Grants - 90,573 Net cash used in capital and related financing activities (18,886,782) (35,339,668) Cash flows from investing activities Purchases of investments (582,341) (951,632) Sales of investments 10,000,000 25,000,000 Interest income 662,953 956,902 Net cash provided by investing activities 10,080,612 25,005,271 Net increase(decrease)in cash and cash equivalents (6,186,339) (5,240,677) Cash and cash equivalents,beginning of period 30,712,383 28,049,566 Cash and cash equivalents,end of period $ 24,526,044 $ 22,808,889 Reconciliation of operating income to net cash provided by operating activities Cash flows from operating activities Operating income $ 1,028,457 $ 866,223 Adjustments to reconcile operating income to net cash provided by operating activities: Depreciation and Amortization expense 6,134,830 4,957,794 Changes in assets and liabilities Decrease(Increase)in notes and accounts receivable 1,107,987 1,680,636 Decrease(Increase)in prepaid items and inventory (1,045,873) (944,710) Decrease(Increase)in interest receivable 15,592 45,279 Increase(Decrease)in accounts payable (4,215,180) (1,059,747) Increase(Decrease)in accrued expenses (452,539) (698,477) Increase(Decrease)in unearned revenue - 170,994 Increase(Decrease)in customer deposits 46,557 75,728 Total adjustments 1,591,374 4,227,497 Net cash provided by operating activities S 2,619,831 $ 5,093,720 Utility plant property contributed by developers $ 19,376,648 $ 7,586,963 8 Cumulative Cash Flow $160,000,000 $140,000,000 $120,000,000 $100,000,000 I $80,000,000 $60,000,000 $40,000,000 $20,000,000 l $0 �e� mat P'e �aJ ��� �� P0° �e� p� �o Oe <(e 4\4 PQ � �� \ P ce p� �o Oe �a Cash w Investments CLAY COUNTY UTILITY AUTHORITY CASH AND CASH EQUIVALENTS REPORT As of January 31, 2025 Truist Ameris SBA Investments Total Lend A Helping Hand Fund $6 $6 Operating Accounts ** $10,383,561 $10,383,561 FSA Account $24,138 $24,138 Emergency Accounts $29,115 $29,115 Petty Cash $2,920 $2,920 Total Operating Funds $10,439,733 $10,439,733 Public Funds Now: Water Plant Connection Fund $43,081 * $43,081 R Water Line Connection Fund $62,924 * $62,924 R Sewer Plant Connection Fund $45,053 * $45,053 R Sewer Lines Connection Fund $183,709 * $183,709 R Alternative Water Supply Fund $1,839,014 * $1,839,014 R Renewal&Replacement Fund $714,056 * $714,056 R Debt Stabilization and Reserve Account_Unrestricted $1,580,691 * $1,580,691 LAMPA Investment Account $20,818,327 $20,818,327 R Surplus Fund $181,471 $174,427 $119,272 $27,326,037 $27,801,207 Available For Construction $4,649,999 $174,427 $119,272 $48,144,364 $53,088,062 Debt Service Sinking Funds: 2015 Refunding Sinking Fund $3,877,131 * $3,877,131 R DEP Loan Debt Service Sinking Acct $34,114 * $34,114 R 2018 Bond Sinking Fund $417,967 * $417,967 R Debt Stabilization and Reserve Account_Restricted Letter of Credit_Financial Responsible Officer $102,797 $102,797 R Customer Deposits&Self Insurance Fund Customer Deposits $4,185,597 $4,185,597 R Self Insurance Fund Sewage Backups $500,000 $500,000 Unemployment $25,000 $25,000 TOTAL Funds $4,432,009 $4,710,597 - - $9,142,607 TOTAL CASH&CASH EQUIVALENTS $19,521,747 $4,885,025 $119,272 $48,144,364 $72,670,408 Investment Accounts Maturity Date Balance APY US Bank Various $27,326,037 3.51% US Bank-LAMPA Immediate $20,818,327 4.26% $48,144,364 * BB&T Public Funds Money Checking Accounts $8,797,740 0.25% BB&T Public Funds Money Checking Accounts $10,383,561 0.25% Ameris Public Funds Money Checking Accounts $4,885,025 1.20% SBA $119,272 4.84% Construction Balance $53,088,062 Operating Cash $8,383,561 Available Construction Balance: $61,471,623 "R"indicates fund is Restricted by Bond Resolution,Enabling Legislation or Board Resolution. Section B Printed 4/3/2025 CLAY COUNTY UTILITY AUTHORITY BUDGET REPORTS FISCAL YEAR 2024/2025 Section C CCUA Operating Budget Report 06:06 PM 04/02/2025 Page 1 of 1 Organization: Fund: General Fund Plan Structure:Adopted Budget by Period Time Period: Current Year Period: FY2025-Jan Ledger Account Budget Current Year YTD Available Balance % Budget Used Operating Revenues Water Revenues Water Base Charges 10,183,285.00 3,181,964.77 7,001,320.23 31.25% Water Use Charges 12,833,994.00 4,108,902.23 8,725,091.77 32.02% Reuse Water Base Charges 4,330,358.00 1,392,859.22 2,937,498.78 32.17% Reuse Water Use Charges 3,230,539.00 926,611.81 2,303,927.19 28.68% Total Water Revenues 30,578,176.00 9,610,338.03 20,967,837.97 31.43% Sewer Revenues Sewer Base Charges 20,502,934.00 6,601,330.77 13,901,603.23 32.20% Sewer Use Charges 17,210,699.00 5,430,283.16 11,780,415.84 31.55% Total Sewer Revenues 37,713,633.00 12,031,613.93 25,682,019.07 31.90% Miscellaneous Revenue 2,068,233.24 731,440.74 1,336,792.50 35.37% Total Operating Revenues 70,360,042.24 22,373,392.70 47,986,649.54 31.80% Interest Income 1,430,766.00 662,952.60 767,813.40 46.34% Operating Expenses Salary&Benefits Salaries&Wages 15,884,560.33 5,682,962.33 10,201,598.00 35.78% Employee Benefits 5,950,402.13 2,107,126.05 3,843,276.08 35.41% Project Labor Recovery 0 (97,942.97) 97,942.97 0.00% Bad Debt 30,000.00 287.24 29,712.76 0.96% Communications 450,959.00 118,333.64 332,625.36 26.24% Due in Lieu of Taxes 3,073,131.00 937,217.92 2,135,913.08 30.50% Electric& Fuel Expenses 3,200,634.00 851,826.83 2,348,807.17 26.61% Miscellaneous Expense 441,372.00 112,352.91 329,019.09 25.46% Property&Liability Insurance 1,515,193.00 453,761.80 1,061,431.20 29.95% Professional Services 1,929,906.18 487,759.44 1,442,146.74 25.27% Sludge Treatment& Disposal 3,110,000.00 1,005,620.01 2,104,379.99 32.34% Subcontractors 5,732,305.52 1,169,047.78 4,563,257.74 20.39% Supplies 6,995,847.03 2,118,077.13 4,877,769.90 30.28% Transportation 778,882.40 260,549.59 518,332.81 33.45% Total Operating Expenses 49,093,192.59 15,206,979.70 33,886,212.89 30.98% Non-Operating Expenses Depreciation 14,944,399.00 5,440,763.30 9,503,635.70 36.41% Amortization 0 685,978.29 (685,978.29) 0.00% Interest Expense 5,549,875.00 2,071,449.02 3,478,425.98 37.32% Sale of Assets 0 0 0.00 0.00% Debt Issuance Costs 0 0 0.00 0.00% Total Non-Operating Expenses 20,494,274.00 8,198,190.61 12,296,083.39 40.00% Construction Income 493,695.00 68,343.06 425,351.94 13.84% Construction Expense 493,694.87 79,557.03 414,137.84 16.11% Contingency 1,092,553.00 0 1,092,553.00 0.00% Net of Revenue f3 Expenditures 1,110,78R 78 (3A0.038.981 1,490,827 76 (34.21%) 12 CCUA Operating Expense Report - Board 06:08 PM 04/02/2025 Page 1 of 2 Organization: Fund: General Fund Plan Structure:Adopted Budget by Period Time Period: Current Year Period: FY2025-Jan Ledger Account Budget Current Year YTD Available Balance % Budget Used SALARIES&WAGES Accrued wages 0 (219,462.21) 219,462.21 0.00% Emergency Pay 0 397,403.97 (397,403.97) 0.00% Employee Wages 0 9,011.84 (9,011.84) 0.00% Overtime Wages 516,769.38 279,108.69 237,660.69 54.01% Tuition Reimbursement 0 1,607.14 (1,607.14) 0.00% Wages Salary 15,367,790.95 5,215,292.90 10,152,498.05 33.94% SUBTOTAL 15,884,560.33 5,682,962.33 10,201,598.00 35.78% EMPLOYEE BENEFITS Employee Health and Life Insurance 3,015,279.11 975,456.45 2,039,822.66 32.35% Employee Retirement and Benefits 1,494,045.45 586,615.84 907,429.61 39.26% Employer Fica Payroll Taxes 1,155,957.86 433,709.59 722,248.27 37.52% Wellness 45,000.00 15,599.56 29,400.44 34.67% Workers Comp Insurance 240,119.71 95,744.61 144,375.10 39.87% SUBTOTAL 5,950,402.13 2,107,126.05 3,843,276.08 35.41% PROJECT LABOR RECOVERY Employee Health and Life Insurance 0 (12,251.45) 12,251.45 0.00% Employee Retirement and Benefits 0 (6,197.25) 6,197.25 0.00% Employer Fica Payroll Taxes 0 (5,307.58) 5,307.58 0.00% Overtime Wages 0 (1,185.12) 1,185.12 0.00% Wages Salary 0 (71,416.92) 71,416.92 0.00% Workers Comp Insurance 0 (1,584.65) 1,584.65 0.00% SUBTOTAL 0 (97,942.97) 97,942.97 0.00% BAD DEBT Bad Debt Expense 30,000.00 287.24 29,712.76 0.96% SUBTOTAL 30,000.00 287.24 29,712.76 0.96% COMMUNICATIONS Communication Expenses 450,959.00 118,333.64 332,625.36 26.24% SUBTOTAL 450,959.00 118,333.64 332,625.36 26.24% DUE IN LIEU OF TAXES Due in Lieu of Taxes 3,073,131.00 937,217.92 2,135,913.08 30.50% SUBTOTAL 3,073,131.00 937,217.92 2,135,913.08 30.50% ELECTRIC&FUEL EXPENSES Electric and Fuel 3,200,634.00 851,826.83 2,348,807.17 26.61% SUBTOTAL 3,200,634.00 851,826.83 2,348,807.17 26.61% MISCELLANEOUS EXPENSE Advertising Expense 46,660.00 6,135.97 40,524.03 13.15% Bank Fees 55,075.00 7,117.53 47,957.47 12.92% Miscellaneous Expense 288,599.00 98,574.41 190,024.59 34.16% Rental Expense 51,038.00 525.00 50,513.00 1.03% SUBTOTAL 441,372.00 112,352.91 329,019.09 25.46% PROPERTY&LIABILITY INSURANCE Property Insurance 1,515,193.00 453,761.80 1,061,431.20 29.95% SUBTOTAL 1,515,193.00 453,761.80 1,061,431.20 29.95% PROFESSIONAL SERVICES AWS Expense 0 153.67 (153.67) 0.00% Accounting Audit Expense 35,000.00 23,500.00 11,500.00 67.14% Employee Training and Travel 436,211.94 96,399.41 339,812.53 22.10% Engineering Expense 940,000.00 291,525.22 648,474.78 31.01% Legal Expenses 466,500.00 60,044.59 406,455.41 12.87% 13 CCUA Operating Expense Report - Board 06:08 PM 04/02/2025 Page 2 of 2 Ledger Account Budget Current Year YTD Available Balance % Budget Used Salaries for Board Members 52,194.24 16,136.55 36,057.69 30.92% SUBTOTAL 1,929,906.18 487,759.44 1,442,146.74 25.27% SLUDGE TREATMENT&DISPOSAL Sludge Removal 2,460,000.00 792,257.01 1,667,742.99 32.21% Sludge Treatment 650,000.00 213,363.00 436,637.00 32.83% SUBTOTAL 3,110,000.00 1,005,620.01 2,104,379.99 32.34% SUBCONTRACTORS Subcontractors 5,575,154.52 1,039,350.56 4,535,803.96 18.64% Subcontractors Testing 0 68,852.18 (68,852.18) 0.00% Trash Service 157,151.00 60,845.04 96,305.96 38.72% SUBTOTAL 5,732,305.52 1,169,047.78 4,563,257.74 20.39% SUPPLIES Administration Software 38,000.00 0 38,000.00 0.00% Brass Fittings 0 119,134.54 (119,134.54) 0.00% Chemicals 1,822,420.00 562,829.31 1,259,590.69 30.88% Furniture 41,065.00 79.61 40,985.39 0.19% Inventory 0 18,513.00 (18,513.00) 0.00% Software 1,312,089.04 309,793.62 1,002,295.42 23.61% Supplies Field 3,253,069.99 979,112.02 2,273,957.97 30.10% Supplies Office 529,203.00 121,665.79 407,537.21 22.99% Tools and Supplies 0 6,949.24 (6,949.24) 0.00% SUBTOTAL 6,995,847.03 2,118,077.13 4,877,769.90 30.28% TRANSPORTATION Fleet Repair and Maintenance 244,253.00 86,532.37 157,720.63 35.43% Transportation Expenses 534,629.40 174,017.22 360,612.18 32.55% SUBTOTAL 778,882.40 260,549.59 518,332.81 33.45% Total Operating Expenses 49,093,192.59 15,206,979.70 33,886,212.89 30.98% 14 CLAY COUNTY UTILITY AUTHORITY CIAC REPORTS FISCAL YEAR 2024/2025 Section D CCUA CIAC Report 06:09 PM 04/02/2025 Page 1 of 1 Period: FY2025-Jan Ledger Account Beginning Year Balance Activity for the Month Year To Date Ending Balance Contributions in Aid of Construction Grants 28,248,778.30 0 0 28,248,778.30 Water Capacity Charges 12,510,674.66 29,808.00 214,330.15 12,725,004.81 Sewer Capacity Charges 62,673,907.94 291,643.00 2,027,814.34 64,701,722.28 Fire Capacity Charges 2,227,641.82 15,810.00 40,315.50 2,267,957.32 Alternative Water Supply Charge 9,817,329.31 92,188.93 449,118.63 10,266,447.94 SJRWMD Black Creek Charge 1,585,367.51 6,634.24 47,863.13 1,633,230.64 Debt Service Charge 2,207,776.10 36,001.59 219,095.03 2,426,871.13 Water Tap-In Charge 2,571,607.59 18,204.29 26,274.39 2,597,881.98 Sewer Tap-In Charge 2,707,816.41 13,028.02 44,724.58 2,752,540.99 Water Main Extension Charge 3,836,569.54 38,064.76 143,881.09 3,980,450.63 Sewer Main Extension Charge 6,638,842.38 70,851.42 476,776.97 7,115,619.35 Water Contributed Assets 67,882,208.73 524,297.04 7,113,290.32 74,995,499.05 Sewer Contributed Assets 139,053,311.28 687,836.15 12,263,358.02 151,316,669.30 Total Contributions in Aid of 341,961,831.57 1,824,367.44 23,066,842.15 365,028,673.72 Construction 16 CLAY COUNTY UTILITY AUTHORITY 2024/2025 Alternative Water Supply Surcharges Beginning October November December January February March April May June July August September Balance Established 10/1/2015 Balance 2024 2024 2024 2025 2025 2025 2025 2025 2025 2025 2025 2025 9/30/2025 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 5,724,397.78 87,391.88 35,874.59 (19,015.40) 76,608.43 5,905,257.28 New Development: - Total Expenditures 8,632,483.39 87,391.88 35,874.59 (19,015.40) 76,608.43 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 8,813,342.89 Existing Customers: Revenue: Surcharge Fund(Existing Customers) 5,565,817.14 64,412.66 64,441.90 66,773.48 66,958.48 5,828,403.66 Connection Charge Fund(Growth) 4,265,263.81 29,963.30 74,594.88 43,595.38 40,564.48 4,453,981.85 Interest Income 40,273.79 40,273.79 Total Revenue 9,871,354.74 94,375.96 139,036.78 110,368.86 107,522.96 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 10,322,659.30 Balance 1,238,871.35 6,984.08 103,162.19 129,384.26 30,914.53 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,509,316.41 Cash Balance 1,712,475.83 Done in following Month: Less Construction Costs transferred after month close (76,608.43) J/E-Adjustment True Up for Move-Ins/Move-Outs J/E-Interfund Transfer (126,550.99) 1,509,316.41 Page D-la 17 CLAY COUNTY UTILITY AUTHORITY CAPITAL PROJECT BUDGET REPORT FISCAL YEAR 2024/2025 Section E 18 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 lob Description Job Number Budget Adopted Budget Budgets Amendments 1/31/25 Balances To Fund Amendments 2024/2025 RENEWAL,REPLACEMENT&BETTERMENT a Departmental Capital 100 1,165,695.76 1,497,600.00 2,663,295.76 181,663.80 2,481,631.96 2,663,295.76 Upgrade Lift station 9-Meadowbrook 755 108,077.74 108,077.74 108,077.74 108,077.74 Rehab SP WW Clarifer#1/under drain 1-2 02519RR 1,549,176.20 1,549,176.20 1,436,025.38 113,150.82 1,549,176.20 Well Monitoring Not Started 0.00 280,000.00 280,000.00 280,000.00 280,000.00 Fleming Island Reg.WWTP-2nd SCR Plant,Two Tanks 21010RR 8,880,000.00 8,880,000.00 7,521,707.91 1,358,292.09 8,880,000.00 Lift Station#2 Upgrade 21016RR 6,700,000.00 300,000.00 7,000,000.00 4,391,692.30 2,608,307.70 7,000,000.00 Ridaught WWTP Upgrades(Install Micro-screen,Grit Removal Equipment,and Influent,Rehabilitiation of Clarifier No.2) 21019RR 4,072,000.00 4,072,000.00 4,082,846.66 (10,846.66) 4,072,000.00 Meadowbrook Well Rehab 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) 21029RR 4,600,000.00 4,550,273.65 9,150,273.65 544,735.91 8,605,537.74 9,150,273.65 Ridaught WTP-Phase I GST Upgrades 22007RR 54,103.26 54,103.26 54,103.26 0.00 54,103.26 Lift Station#4 Upgrades 22008RR 1,200,000.00 813,696.16 2,013,696.16 61,833.91 1,951,862.25 2,013,696.16 Lift Station#62 and#67-Rehabilitation 22009RR 1,220,000.00 1,803,000.00 3,023,000.00 76,869.25 2,946,130.75 3,023,000.00 Miller WRF Electrical Upgrades&WWTP Upgrades 23004RR 236,005.00 236,005.00 219,498.04 16,506.96 236,005.00 Spencers WTP-Ground Storage&High Service Pump&Electrical Upgrades 23005RR 3,237,848.00 4,806,750.24 8,044,598.24 300,651.82 7,743,946.42 8,044,598.24 Pace Island&Fleming Oaks WTP Electrical Upgrades 23007RR 442,107.00 442,107.00 119,113.39 322,993.61 442,107.00 SCADA System 23008RR 500,000.00 1,000,000.00 1,500,000.00 48,500.00 1,451,500.00 1,500,000.00 Fleming island WRF electrical upgrades/Vault upgrades 23009RR 2,082,361.00 2,082,361.00 279,125.39 1,803,235.61 2,082,361.00 AC Replacements Not Started 0.00 30,000.00 30,000.00 0.00 30,000.00 30,000.00 Upgrade Lift Stations 11,41,69,51 23012RR 658,092.80 1,909,768.41 2,567,861.21 261,368.94 2,306,492.27 2,567,861.21 Sandridge Road widening from Henley to CR 209 and ForceMain Extension 23015SL 2,040,000.00 2,040,000.00 1,623,712.44 416,287.56 2,040,000.00 Gravity Sewer Lining 24005RR 1,358,136.76 1,000,000.00 2,358,136.76 949,767.12 1,408,369.64 2,358,136.76 Keystone Heights-Lakeside Street/Hilltop Street Water Main Rehabilitation 23024RR 237,600.00 237,600.00 226,427.03 11,172.97 237,600.00 Mid-Clay Entrance Road Stabilization 23025RR 50,000.00 40,000.00 90,000.00 30,052.31 59,947.69 90,000.00 Mid-Clay WRF Alternate Driveway 23028RR 1,200,000.00 1,200,000.00 116,415.44 1,083,584.56 1,200,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 Lift Station Bypass Pump Not Started 200,000.00 200,000.00 0.00 200,000.00 200,000.00 Manhole Rehab Not Started 300,000.00 100,000.00 400,000.00 0.00 400,000.00 400,000.00 Keystone Heights High School WM relocation Not Started 143,000.00 143,000.00 0.00 143,000.00 143,000.00 Plant Meters Retrofits 23029RR 214,767.08 150,000.00 364,767.08 226,677.91 138,089.17 364,767.08 FH and Gate Valve replacement 24008RR 216,552.49 210,000.00 426,552.49 111,234.23 315,318.26 426,552.49 Potable and Reclaimed Water Meter and backfow device replacement 23003RR 1,600,000.00 1,650,000.00 3,250,000.00 1,434,451.41 1,815,548.59 3,250,000.00 Lake Asbury WM Improvements(602 Lake Asbury Road&Aldersgate St.) 23030RR 1,530,000.00 1,530,000.00 319,112.14 1,210,887.86 1,530,000.00 Southern Baptist Hospital of Florida/cost participation w/development 24001RR 195,435.28 195,435.28 195,435.28 0.00 195,435.28 Keystone Wastewater Treatment Plant-Phase R Construction 24007SP 345,075.80 607,545.00 952,620.80 219,875.94 732,744.86 952,620.80 Upgrade Lift Station 20 24003RR 69,217.35 1,129,096.24 1,198,313.59 61,187.39 1,137,126.20 1,198,313.59 Upgrade Lift Station 20&56 Not Started 375,000.00 375,000.00 0.00 375,000.00 375,000.00 Plant Generators 21002RR 500,000.00 500,000.00 1,000,000.00 0.00 1,000,000.00 1,000,000.00 Upsizing within Creekside Trails Ph 1&2 24015RR 326,375.63 326,375.63 326,375.63 0.00 326,375.63 Miller St.WWTP Upgrades Influent Structure,Septage station&Electrical upgrades Not Started 375,000.00 2,725,393.00 3,100,393.00 3,100,393.00 3,100,393.00 New Lift Station Generators Not Started 693,891.24 350,000.00 1,043,891.24 1,043,891.24 1,043,891.24 12"WM Extension Hwy.100 to Brooklyn Bay Rd.(Keystone) Not Started 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 Old Jennings WTP Electrical Upgrade Not Started 0.00 0.00 0.00 0.00 Tanglewood Electrical Upgrade Not Started 0.00 0.00 0.00 0.00 Orange Park South Electrical Upgrade Not Started 0.00 0.00 0.00 0.00 Ridaught WRF Electrical Upgrades Not Started 0.00 0.00 0.00 0.00 Spencer's WRF Electrical Upgrades Not Started 0.00 0.00 0.00 0.00 Oakleaf WTP Electrical Upgrades Not Started 0.00 0.00 0.00 0.00 Server Lifecycle Replacement Not Started 0.00 1,925,000.00 1,925,000.00 1,925,000.00 1,925,000.00 Upgrade Lift Station 98 Not Started 0.00 0.00 0.00 0.00 Upgrade Lift Stations 43,24,59 Not Started 0.00 0.00 0.00 0.00 Upgrade Lift Station Ill Not Started 0.00 0.00 0.00 0.00 GST&Hydro Repairs Not Started 0.00 225,000.00 225,000.00 225,000.00 225,000.00 Reuse GST Repairs Not Started 0.00 400,000.00 400,000.00 400,000.00 400,000.00 BCR Upgrades 24019RR 0.00 426,400.00 426,400.00 159,050.00 267,350.00 426,400.00 New Meter&MXU Install Not Started 0.00 630,000.00 630,000.00 630,000.00 630,000.00 Well Pumps 4 Ea Not Started 0.00 120,000.00 120,000.00 120,000.00 120,000.00 W&WW Service to 1613 Blanding Blvd 24019RR 0.00 0.00 0.00 80,000.00 50,162.98 29,837.02 1 80,000.00 Check Valves Not Started 0.00 12,000.00 12,000.00 12,000.00 12,000.00 FDOT Blanding Blvd&Wells Rd Intersection Utility Relocation 24022WL 0.00 0.00 0.00 150,000.00 22,000.00 128,000.00 2 150,000.00 SYSTEM EXPANSION I = W Meadow Lake WTP-New Ground Storage Tank and Electrical Service upgrade 00983WP 3,149,124.00 3,149,124.00 3,149,124.00 3,149,124.00 Henley Road 12"WM Loop-Sandridge to Small Lake 01119WL 106,016.70 106,016.70 11,258.64 94,758.06 106,016.70 North Middleburg Water&Sewer Extension and Interconnection(Water Interconnect,Forcemain extension and pump station) 02419WL 3,310,554.67 2,848,023.20 6,158,577.87 552,385.90 5,606,191.97 6,158,577.87 19 X:\Finance\Controllers Folder\Monthly Financial\Monthly Construction Reports\2024-2025\CIP_2025-lanuary.xlsx Page 1 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 Job Number Budget Adopted Budget Budgets Amendments 1/31/25 Balances To Fund Amendments 2024/2025 Peter's Creek Land Acquisition Not Started 0.00 2,500,000.00 2,500,000.00 0.00 2,500,000.00 2,500,000.00 CCUA Administrative Building Phase I 21013AD 5,225,089.00 300,000.00 5,525,089.00 4,248,808.13 1,276,280.87 5,525,089.00 Phase III Admin Building Not Started 0.00 0.00 0.00 0.00 0.00 Swimming Penn Creek WM Interconnect 21020WL 6,660,000.00 6,660,000.00 5,566,722.56 1,093,277.44 6,660,000.00 Ravines to Henly Road Water Main Extension 21023WL 4,650,000.00 4,650,000.00 3,484,038.18 1,165,961.82 4,650,000.00 Governor's Park WTP Design and Build 21026WP 10,000,000.00 10,000,000.00 9,781,504.03 218,495.97 10,000,000.00 Peters Creek WTP 2nd GST&3rd Well 21030WP 267,547.26 267,547.26 267,547.26 (0.00) 267,547.26 Peters Creek New Regional WRF 22003SP 88,123,968.83 88,123,968.83 85,728,358.54 2,395,610.29 88,123,968.83 CCUA North Campus Driveway 22010AD 786,341.00 786,341.00 166,559.25 619,781.75 786,341.00 LAMPA(Freehold) 0.00 12,312,059.00 12,312,059.00 12,312,059.00 12,312,059.00 LAMPA E/W Interconnect#1 Water(Cathedral Oaks West-Green) 22012WL 3,112,000.00 3,112,000.00 3,061,128.65 50,871.35 3,112,000.00 LAMPA E/W Interconnect#1 Wwtr-Reuse(Cathedral Oaks West-Green) 22013SL 6,337,000.00 6,337,000.00 6,222,702.63 114,297.37 6,337,000.00 LAMPA E/W Interconnect#2 Water (Cathedral Oaks East-Blue) 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) 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) 22016WL 17,319.95 5,999,645.00 6,016,964.95 17,319.95 5,999,645.00 6,016,964.95 LAMPA N/S Interconnect#1 Wwtr-Reuse(SS WTP to Cathedral Oaks West-Red) 22017SL 39,145.26 39,145.26 39,145.26 0.00 39,145.26 LAMPA N/S Interconnect#2 Water(Feed Mill Rd.-Black) 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) 22019SL 20,915.03 20,915.03 20,915.03 0.00 20,915.03 Emalyn Place 3 Single Family Units 22021WL 17,000.00 17,000.00 17,000.00 17,000.00 Postmaster WTP Electrical Upgrades 23001 WP 181,657.00 181,657.00 154,411.00 27,246.00 181,657.00 Clay County-College Drive RRR Project 23014WL 35,000.00 35,000.00 0.00 35,000.00 35,000.00 Upsize Mains-Double Branch Cost Share 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 23019SL 1,600,000.00 883,432.16 2,483,432.16 104,529.61 2,378,902.55 2,483,432.16 Water Service to 3255 Bliss Rd 23020WL 103,815.71 103,815.71 103,815.71 (0.00) 103,815.71 Upsizing Mains from Bradley Creek to Russell Retreat 23021WL 394,236.58 394,236.58 394,236.58 0.00 394,236.58 Water Service to 461 Creighton Rd. 23022WL 88,950.03 88,950.03 88,950.03 0.00 88,950.03 Home Depot-Lowes Interconnect 23026WL 23,664.53 23,664.53 22,465.48 1,199.05 23,664.53 Water Service to 879 Creighton Rd. 23027WL 28,263.82 28,263.82 28,263.82 0.00 28,263.82 Water Service to 646 Harrison Rd. 24002WL 28,000.00 28,000.00 26,646.74 1,353.26 28,000.00 16-inch WM Atlantis to Kindlewood Not Started 500,000.00 180,000.00 680,000.00 680,000.00 680,000.00 Upsizing pipes to accommodate Rookery GCS Not Started 466,000.00 466,000.00 466,000.00 466,000.00 Tanglewood Neighborhood Water Main Relocations Not Started 85,000.00 85,000.00 85,000.00 85,000.00 CR 218 widening from Pine Tree Lane to Cosmos 22020RR 2,006,879.47 2,006,879.47 1,907,098.47 99,781.00 2,006,879.47 CR 220 widening Baxley to Henley Rd Not Started 760,000.00 699,650.00 1,459,650.00 1,459,650.00 1,459,650.00 CR 220 widening from Henley to Knightbox Not Started 70,000.00 70,000.00 70,000.00 70,000.00 CR 315 widening-Utility Relocation(design FY 23 construct FY 24) 23017RR 922,000.00 922,000.00 922,000.00 922,000.00 CR220 Quadrant Intersection 24009RR 578,000.00 578,000.00 578,000.00 578,000.00 InSll Projects Not Started 1,461,678.98 1,461,678.98 1,461,678.98 1,461,678.98 Well Rehab Not Started 150,000.00 150,000.00 300,000.00 300,000.00 300,000.00 Lead&Copper GSP replacement Not Started 60,000.00 60,000.00 120,000.00 120,000.00 120,000.00 Retrofit Existing Building for Laboratory Not Started 0.00 30,000.00 30,000.00 30,000.00 30,000.00 Chemical tanks Not Started 100,000.00 100,000.00 200,000.00 200,000.00 200,000.00 Facility Roof Repairs Not Started 100,000.00 100,000.00 200,000.00 200,000.00 200,000.00 -Reclaimed Transmission Main-Spencers to Oakleaf Not Started 0.00 0.00 0.00 0.00 -Reclaimed Transmission Main-Oakleaf to Challenger Not Started 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 -New Pumps-Old Jennings WRF pump station Not Started 0.00 0.00 0.00 0.00 -Reclaimed Water SCADA Not Started 530,000.00 530,000.00 530,000.00 530,000.00 Mid-Clay Rib Recovery pH adjustment BODR Not Started 30,000.00 40,000.00 70,000.00 70,000.00 70,000.00 Evaluate replacement of 16"AC Pipe by Orange Park mall Not Started 30,000.00 192,000.00 222,000.00 222,000.00 222,000.00 Treatment plant R&R Studies Not Started 500,000.00 500,000.00 500,000.00 500,000.00 Fleming BTU#1 Rehab design and construction 24016RR 500,000.00 500,000.00 1,000,000.00 (27,410.56) 1,027,410.56 1,000,000.00 Sugar Leaf Farms/cost participation w/development 24004SL 262,209.34 262,209.34 262,209.34 0.00 262,209.34 Jeremy Hollow Subdivision/cost participation w/development 24006WL 16,487.20 16,487.20 16,487.20 0.00 16,487.20 Cost Participation w/Development Projects Not Started 860,236.58 860,236.58 0.00 860,236.58 860,236.58 Lift Station 88 Relocation 24010RR 1,200,000.00 1,666,064.24 2,866,064.24 7,740.99 2,858,323.25 2,866,064.24 Commercial Meter Change outs Not Started 75,000.00 75,000.00 150,000.00 0.00 150,000.00 150,000.00 12-inch Wm Keystone RV to Geneva lakes WTP 24011 WP 2,300,000.00 2,300,000.00 67,497.21 2,232,502.79 2,300,000.00 Pier Station E/W WM Extension and Interconnect(State Road 16 and FCOB) Not Started 50,000.00 50,000.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 Pier Station Master Pump Station(State Road 16 and FCOB) Not Started 0.00 0.00 0.00 0.00 Pier Station WTP Expansion Not Started 0.00 0.00 0.00 0.00 Ravines WTP 2nd GST Not Started 0.00 0.00 0.00 0.00 Spencer's W WTP:Phase 6 Expansion Not Started 0.00 0.00 0.00 0.00 Laboratory Equipment&Software Not Started 0.00 305,275.00 305,275.00 305,275.00 305,275.00 20 X:\Finance\Controllers Folder\Monthly Financial\Monthly Construction Reports\2024-2025\CIP_2025-lanuary.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 Job Number Budget Adopted Budget Budgets Amendments 1/31/25 Balances To Fund Amendments 2024/2025 Russell Road-Russell Retreat to Anabolic Island Not Started 0.00 725,000.00 725,000.00 725,000.00 725,000.00 Batton Lakes RV Resort FM Not Started 0.00 360,000.00 360,000.00 360,000.00 360,000.00 Bella Lago Phase 2 WM&RM Not Started 0.00 265,000.00 265,000.00 265,000.00 265,000.00 Highland Park FM Not Started 0.00 230,000.00 230,000.00 230,000.00 230,000.00 'ALTERNATIVE WATER SUPPLY in Purified Water Pilot Study 20022WL 6,769,000.00 430,000.00 7,199,000.00 5,905,257.28 1,293,742.72 7,199,000.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-Petets Creek(1.0 MG GST) Not Started 1,822,500.00 1,822,500.00 1,822,500.00 1,822,500.00 Subtotals 207,203,552.55 60,142,671.30 267,346,223.85 230,000.00 154,294,804.34 113,281,419.51 267,576,223.85 Contingency 6,149,017.06 6,149,017.06 (230,000.00) 1,2 5,919,017.06 TOTAL CAPITAL EXPENDITURES 273,495,240.91 0.00 273,495,240.91 Construction In Progress 267,346,223.85 154,294,804.34 Not Started 23,784,624.80 Completed Jobs 0.00 Started 249,710,616.11 Funds Spent @ 1/31/25 154,294,804.34 273,495,240.91 21 X/tFinance\Controllers Folder\Monthly Financial\Monthly Construction Reports\2024-2025\CIP_2025-lanuary.clse Page 3 of 3 CLAY COUNTY UTILITY AUTHORITY OPERATING DETAIL BY MONTH FISCAL YEAR 2024/2025 Section F 22 CCUA Operating Revenue Budget Report 06:10 PM 04/02/2025 Page 1 of 1 Organization: Fund: General Fund Plan Structure:Adopted Budget by Period Time Period: Current Year Period: FY2025-Jan Revenue by Category FY2025-Sep(YE_Sep) Current Month Current Year YTD %Budget Budget Used Water Base Charges Commercial Potable Irrigation Base 323,152.00 21,428.17 80,783.62 25.00% General Service Water Base 1,705,375.00 127,885.35 480,962.30 28.20% Residential Water Base Charges 8,154,758.00 695,857.51 2,620,218.85 32.13% SUBTOTAL 10,183,285.00 845,171.03 3,181,964.77 31.25% Water Usage Charges Commercial Potable Irrigation Usage 710,082.00 35,012.87 206,887.92 29.14% Commercial Water Usage 2,814,885.00 220,196.22 891,405.74 31.67% Residential Water Usage 9,309,027.00 683,313.61 3,010,608.57 32.34% SUBTOTAL 12,833,994.00 938,522.70 4,108,902.23 32.02% Reuse Base Charges Reuse Commercial Base 409,900.00 33,939.23 125,050.81 30.51% Reuse Residential Base 3,920,458.00 339,693.22 1,267,808.41 32.34% SUBTOTAL 4,330,358.00 373,632.45 1,392,859.22 32.17% Reuse Usage Charges Crossings Reclaimed Water Charges 151,154.00 8,073.16 58,287.65 38.56% Reuse Commercial Usage 571,076.00 25,056.50 179,063.01 31.36% Reuse Residential Usage 2,508,309.00 112,656.38 689,261.15 27.48% SUBTOTAL 3,230,539.00 145,786.04 926,611.81 28.68% Total Water Revenues 30,578,176.00 2,303,112.22 9,610,338.03 31.43% Sewer Base Charges General Service Sewer Base 2,819,443.00 272,274.88 1,024,939.68 36.35% Residential Sewer Base Charge 17,683,491.00 1,505,795.68 5,576,391.09 31.53% SUBTOTAL 20,502,934.00 1,778,070.56 6,601,330.77 32.20% Sewer Usage Charges General Service Sewer Usage 4,203,255.00 328,646.25 1,368,192.29 32.55% Portalet Sewage Revenue 204,000.00 1,337.71 88,523.10 43.39% Residential Sewer Usage Charge 12,803,444.00 989,849.52 3,973,567.77 31.04% SUBTOTAL 17,210,699.00 1,319,833.48 5,430,283.16 31.55% Total Sewer Revenues 37,713,633.00 3,097,904.04 12,031,613.93 31.90% Total Base&Usage Charges 68,291.809.00 5.401.016.26 21,641.951.96 31.69% Miscellaneous Revenue Asbuilt Drawing Revenue 40,963.72 140.00 5,670.00 13.84% Cash Over/Short 0 (1.75) (1.38) 0.00% Cut for Non Pay Service Charge 127,260.00 0 94.00 0.07% Guaranteed Revenue 4,027.73 0 0 0.00% Meter Installation Fee 868,500.00 46,440.60 255,505.39 29.42% Miscellaneous Repair Charges 10,430.51 0 3,874.56 37.15% Miscellaneous Revenue 162,006.39 8,645.09 61,255.91 37.81% Miscellaneous Service Charge 313,005.08 28,832.10 126,864.55 40.53% New Construction Inspection Charge 87,736.02 6,534.59 44,306.15 50.50% New Customer Service Charge 303,070.00 259.00 259.00 0.09% Plan Review Charge 39,758.33 3,350.31 14,380.56 36.17% Returned Check Service Charge 57,010.00 4,410.00 19,020.00 33.36% Trip Service Charge 41,525.46 60,947.00 190,712.00 459.27% Water-Sewer Line Permitting 12,940.00 1,740.00 9,500.00 73.42% Revenue SUBTOTAL 2,068,233.24 161,296.94 731,440.74 35.37% Total Operating Revenues 70,360,042 24 5,562.313 20 22,373,392.70 31.R0% 23 Budgeted vs. Actual - Base & Use Charges, Total 40,000,000 35,000,000 30,000,000 — 1 25,000,000 20,000,000 all ................. 15,000,000 10,000,000 5,000,000 —I- 0 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 1°0 $6,000,000 -- —"NNW 4 I $5,000,000 I $4,000,000 _ _.....................- $3,000,000 $2,000,000 --- i $1,000,000 $0 October November December January February March April May June July August September Actual Optg Rev Prior Year Optg Rev Budgeted Optg Rev 111— Operating Net Income $3,500,000 $3,000,000 $2,500,000 $2,000,000 I ilIMIN I A 1r $1,500,000 $1,000,000 I PI ,i''r Ilri $500,000 $0 October November December January February March April May June July August September Actual Net Income Prior Year Net Income Budgeted Net Income 26 CLAY COUNTY UTILITY AUTHORITY OTHER REPORTS FISCAL YEAR 2024/2025 Section G 27 CCUA Construction Department Report 06:11 PM 04/02/2025 Page 1 of 1 Organization: Fund: General Fund Plan Structure:Adopted Budget by Period Time Period: Current Year Period: FY2025-Jan Ledger Account Budget Current Month Current Year YTD Available Balance % Budget Used INTERNAL BILLINGS TOTAL INTERNAL BILLINGS 493,695.00 3,709.24 68,343.06 425,351.94 13.84% SALARIES&WAGES Wages Hourly 0 1,627.43 29,742.75 (29,742.75) 0.00% Wages Salary 195,013.68 0 0 195,013.68 0.00% SUBTOTAL 195,013.68 1,627.43 29,742.75 165,270.93 15.25% EMPLOYEE BENEFITS Employee Health and Life 39,935.98 349.78 6,906.48 33,029.50 17.29% Insurance Employee Retirement and 19,501.37 162.75 2,974.27 16,527.10 15.25% Benefits Employer Fica Payroll Taxes 14,918.55 119.43 2,158.34 12,760.21 14.47% Workers Comp Insurance 5,029.29 36.10 723.69 4,305.60 14.39% SUBTOTAL 79,385.19 668.06 12,762.78 66,622.41 16.08% OTHER EXPENSES Construction R&R(Depreciation) 31,225.00 2,021.99 8,087.98 23,137.02 25.90% Contingency 40,000.00 0 0 40,000.00 0.00% Employee Training and Travel 734.00 0 0 734.00 0.00% Equipment Repair and 20,000.00 0 0 20,000.00 0.00% Maintenance Property Insurance- 90,387.00 7,240.88 28,963.52 61,423.48 32.04% Construction Supplies Office 250.00 0 0 250.00 0.00% Tools and Supplies 10,700.00 0 0 10,700.00 0.00% Transportation Expenses 26,000.00 0 0 26,000.00 0.00% SUBTOTAL 219,296.00 9,262.87 37,051.50 182,244.50 16.90% Total Revenue 493,695.00 3,709.24 68,343.06 425,351.94 13.84% Total Expenses 493,694.87 11,558.36 79,557.03 (414,137.84) 16.11% Net of Revenue& Expenditures 0.13 11214 10 (8,626,130 77%)1 28