HomeMy WebLinkAboutEDB 2022-10 Board Financial Package Clay County Utility Authority Working together to
3176 Old Jennings Road protect public health,
Middleburg,FL 32068-3907 conserve our natural
GJI Telephone(904)272-5999 resources,and create
long-term value for
♦
/Ty gUTNOQ' www.Clayutility.org our ratepayers.
December 13, 2022
To: Board of Supervisors
From: Jeffrey Wesselman
Re: October 2022 Financial Package
I have enclosed the following financial information:
A) Comparative Financial Statements for the one month of fiscal years 2022/2023 and 2021/2022.
co Comparative Balance Sheet
Revenue & Expenditure Report
Cash-flow Statement
co
B) Cash &Cash Equivalents Report at October 31, 2022
L
C) Budget Reports for the one month of Fiscal Year 2022/2023
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 October 31, 2022
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$57,167 (5%) over budget due to a favorable revenue and unfavorable expense variance.
Operating revenue is$136,893 (3%) over budget and Operating expenses are$79,726 (2%) over budget. Itemized
operating expense variances are in Section C.
We gained 48 active (Residential 52, General Service, -4) water accounts and 49 active sewer(Residential 51,
General Service, -2) accounts for the fiscal year 2022/2023 as compared to an increase of 100 active water accounts
and an increase of 91 active sewer accounts for the same time in fiscal year 2021/2022.
1
CLAY COUNTY UTILITY AUTHORITY
COMPARATIVE FINANCIAL
STATEMENTS
t° FISCAL YEAR 2022/2023
Section A
12/12/2022 05:27 PM COMPARATIVE BALANCE SHEET FOR CLAY COUNTY UTILITIES Page: 1/1
User: kosborne
DB: CCUA
Fund 101 GENERAL FUND
PERIOD ENDED PERIOD ENDED
GL Number Description 10/31/2021 10/31/2022
*** Assets ***
Cash 41,354,268.02 28,056,627.74
Investments 52,104,013.76 52,695,349.72
Accounts Receivable 3,557,194.21 3,745,537.60
Fixed Assets 482,034,964.83 529,019,042.39
Accum. Depreciation (173,006,581.73) (185,815,324.24)
Other Assets 1,326,304.00 1,758,030.57
Deferred Outflows 1,918,967.64 1,689,719.16
Total Assets 409,289,130.73 431,148,982.94
*** Liabilities ***
Liabilities-ST 16,125,662.72 20,196,539.51
Liabilities-LT (over 1 year) 91,472,621.00 84,379,852.99
Total Liabilities 107,598,283.72 104,576,392.50
*** Fund Balance ***
Unassigned 53,823,792.64 57,795,484.23
Investment In Capital Assets 247,290,363.28 268,771,329.63
Total Fund Balance 301,114,155.92 326,566,813.86
Beginning Fund Balance 293,106,326.89 324,403,223.95
Net of Revenues VS Expenditures 576,691.09 5,776.58
Fund Balance Adjustments 8,007,829.03 2,163,589.91
Ending Fund Balance 301,690,847.01 326,572,590.44
Total Liabilities And Fund Balance 409,289,130.73 431,148,982.94
t0
12/12/2022 05:27 PM COMPARATIVE BALANCE SHEET FOR CLAY COUNTY UTILITIES Page: 1/3
User: kosborne
DB: CCUA
Fund 101 GENERAL FUND
PERIOD ENDED PERIOD ENDED
GL Number Description 10/31/2021 10/31/2022
*** Assets ***
Cash
101.401.101.110 Cash-BB&T L.A.H.H. Account 2,434.85 151.09
101.401.101.125 '12 BBVA Compass Debt Service 1,259,557.07 1,423,570.27
101.401.101.160 Cash-BB&T Operating Account 13,149,929.51 4,686,452.27
101.401.101.161 Cash-BB&T Emergency Account 36,064.14 20,830.46
101.401.101.200 CASH-FSA 38,716.66 42,622.16
101.401.101.329 Debt Stabilization Reserve Unrestricted 903,224.62 1,312,344.88
101.401.101.331 2015/2019 Bond Sinking Fund 4,640,004.01 4,514,385.44
101.401.101.333 SBA - 2001 DEP Loan Debt Service Acct 61,139.38 61,135.90
101.401.101.335 CUSTOMER DEPOSIT FUND 3,467,308.96 3,630,973.80
101.401.101.336 SURPLUS FUND 3,749,225.70 3,611,291.42
101.401.101.337 SELF INSURANCE FUND 525,000.00 525,000.00
101.401.101.338 RENEWAL & REPLACEMENT FUND 4,125,711.48 1,493,881.98
101.401.101.340 WATER PLANT FUND (76%) 153,749.81 109,467.19
101.401.101.342 WATER LINE FUND (24%) 159,217.48 73,323.39
101.401.101.343 AWS Cash 2,291,518.56 3,598,993.29
101.401.101.344 SEWER PLANT FUND (53.33%) 5,756,764.64 2,407,694.85
101.401.101.346 SEWER LINE FUND (46.67%) 797,282.97 306,260.16
101.401.101.351 2018 Bond Sinking Fund 236,250.88 236,247.44
101.401.102.100 PETTY CASH FUND 1,167.30 2,001.75
Cash 41,354,268.02 28,056,627.74
Investments
101.401.101.323 Short Term Investments - Surplus 52,104,013.76 52,695,349.72
Investments 52,104,013.76 52,695,349.72
Accounts Receivable
101.401.115.100 ACCOUNTS RECEIVABLE W&S CUST 1,177,389.93 1,082,696.92
101.401.115.110 A/R CIAC & MISC REPAIR INVS. 357,375.38 605,888.25
101.401.115.120 Loans To Customers 48,600.19 23,973.53
101.401.115.121 Loan to Customers Long-term 330,339.77 301,709.88
101.401.115.200 A/R UNBILLED WATER REVENUE 743,379.56 833,204.77
101.401.115.250 A/R Unbilled Reuse Revenue 174,346.95 154,964.21
101.401.115.300 A/R UNBILLED SEWER REVENUE 904,233.69 962,926.56
101.401.115.400 A/R CLEARING ACCOUNT (2,142.33) (850.60)
101.401.117.100 ALLOWANCE FOR DOUBTFULL A/R (176,328.93) (218,975.92)
Accounts Receivable 3,557,194.21 3,745,537.60
Fixed Assets
101.401.161.900 LAND 5,268,724.07 5,268,724.07
101.401.162.900 BUILDINGS 9,045,538.84 9,855,443.42
101.401.166.900 MACHINERY & EQUIPMENT 445,996,753.95 463,069,672.10
101.401.168.900 Intangible Assets 3,632,438.00 3,866,031.40
101.401.169.900 CONSTRUCTION IN PROGRESS 18,091,509.97 46,959,171.40
Fixed Assets 482,034,964.83 529,019,042.39
Accum. Depreciation
101.401.163.900 ACCUM.DEPRECIATION BUILDINGS (8,378,829.45) (9,065,662.05)
101.401.167.900 ACCUM.DEPR. MACHINERY & EQUIPT (164,627,752.28) (176,749,662.19)
Accum. Depreciation (173,006,581.73) (185,815,324.24)
Other Assets
101.401.115.150 INTEREST RECEIVABLE 91,984.64 129,484.86
101.401.115.500 PREPAID INSURANCE 426,422.27 489,974.69
101.401.115.550 PREPAID W/C INSURANCE 12,940.45 (15,153.87)
101.401.115.575 PREPAID DEP REGULATORY FEES 18,108.30 18,508.32
101.401.115.600 PREPAID MAINTENANCE & EXPENSES 402,958.13 333,015.02
101.401.141.000 INVENTORY 354,966.00 775,029.19
101.401.141.100 UNUSED POSTAGE 18,924.21 23,158.64
101.401.158.300 Other Receivable 0.00 4,013.72
Other Assets 1,326,304.00 1,758,030.57
Deferred Outflows
101.401.158.201 Deferred Outflow of Resources 1,918,967.64 1,689,719.16
4
12/12/2022 05:27 PM COMPARATIVE BALANCE SHEET FOR CLAY COUNTY UTILITIES Page: 2/3
User: kosborne
DB: CCUA
Fund 101 GENERAL FUND
PERIOD ENDED PERIOD ENDED
GL Number Description 10/31/2021 10/31/2022
*** Assets ***
Deferred Outflows 1,918,967.64 1,689,719.16
Total Assets 409,289,130.73 431,148,982.94
*** Liabilities ***
Liabilities-ST
101.401.202.000 ACCOUNTS PAYABLE 2,546,816.05 5,197,706.13
101.401.202.002 Retainage Payable 197,545.16 1,218,190.70
101.401.215.100 ACCRUED INTEREST 1,065,085.87 988,235.40
101.401.216.100 ACCRUED WAGES PAYABLE 219,718.90 275,998.87
101.401.216.200 ACCRUED SICK, VACATION PAYABLE 755,354.95 854,377.94
101.401.217.100 EMPLOYEE FIT,FICA,MEDICARE W/H 74,593.15 86,473.84
101.401.217.300 Employee Fund Withheld 2,186.33 2,142.78
101.401.217.500 ACCRUED PENSION DUE 97,507.40 113,037.69
101.401.217.600 ACCRUED W/C INS. DUE 24,084.33 27,920.32
101.401.218.100 MISC W/H (153.34) (29.89)
101.401.218.250 LIFE INSURANCE 0.00 (576.59)
101.401.218.700 HEALTH INSURANCE W/H 2O0.00 0.00
101.401.218.703 HMO/PPO (1,031.12) (1,577.73)
101.401.218.705 DENTAL (302.94) (9,836.36)
101.401.218.706 VISION (155.14) (256.22)
101.401.218.707 ANCILLARY 1,712.53 1,957.11
101.401.218.900 ACCRUED ELECTRIC EXPENSE DUE 97,007.93 131,366.93
101.401.220.100 BOND DEPOSITS 85,745.78 112,565.24
101.401.220.150 CLEANING WATER DEPOSITS 114,385.88 129,562.58
101.401.220.175 W&S CUSTOMER DEPOSITS 3,484,662.06 3,636,749.56
101.401.220.180 DUE TO LEND A HELPING HAND 2,416.85 149.09
101.401.220.185 Refundable Development Agreements 8,867.08 20,930.25
101.401.223.100 DEFERRED REVENUES WATER 91,175.07 92,152.75
101.401.223.200 DEFERRED REVENUE SEWER 188,080.82 191,369.18
101.401.223.300 Deferred Reuse Revenue 34,685.03 36,616.06
101.401.229.200 JAX PUBLIC SERV.TAX COLLECTED 330.02 390.65
101.401.229.201 Keystone Public Service Tax 14.87 (1,844.78)
101.401.232.700 CURRENT BOND PRINCIPAL DUE 7,035,129.20 7,092,768.01
Liabilities-ST 16,125,662.72 20,196,539.51
Liabilities-LT (over 1 year)
101.401.232.569 2012 BBVA Compass Loan 4,510,637.00 3,293,841.00
101.401.232.571 SunTrust 2015 Adv Ref 2007 Bonds 36,895,642.00 34,964,955.00
101.401.232.572 2018 Revenue Bonds Payable DEP MIDCLAY 11,704,626.36 11,086,278.04
101.401.232.573 Dell Financing Lease 542,513.39 275,999.81
101.401.232.574 Suntrust 2019 Loan & Refinance 44,035,000.00 41,130,000.00
101.401.232.586 2014 DEP Payable 819,331.45 721,547.15
101.401.232.600 CONTRA CURRENT BOND PRINCIPAL (7,035,129.20) (7,092,768.01)
Liabilities-LT (over 1 year) 91,472,621.00 84,379,852.99
Total Liabilities 107,598,283.72 104,576,392.50
*** Fund Balance ***
Unassigned
101.401.272.000 RETAINED EARNINGS-UNRESERVED 53,823,792.64 57,795,484.23
Unassigned 53,823,792.64 57,795,484.23
Investment In Capital Assets
101.401.240.000 AWS CIAC 5,936,837.31 7,221,129.45
101.401.240.100 SJRWMD Black Creek CIAC 58,567.06 763,197.21
101.401.254.350 WATER CAPACITY CHARGES 10,646,662.86 11,255,687.36
101.401.254.351 FIRE CAPACITY CHARGES 1,919,533.50 2,044,084.68
101.401.254.352 WATER TAP IN CHARGE 2,235,323.02 2,345,309.67
101.401.254.353 WATER CONTRIBUTED ASSETS 50,326,164.48 52,936,482.98
5
12/12/2022 05:27 PM COMPARATIVE BALANCE SHEET FOR CLAY COUNTY UTILITIES Page: 3/3
User: kosborne
DB: CCUA
Fund 101 GENERAL FUND
PERIOD ENDED PERIOD ENDED
GL Number Description 10/31/2021 10/31/2022
*** Fund Balance ***
101.401.254.354 WATER MAIN EXTENSION CHARGE 2,823,785.11 3,109,856.87
101.401.254.355 DEBT SERVICE CHARGE 991,631.73 1,306,327.20
101.401.254.360 SEWER CAPACITY CHARGES 43,712,253.37 49,502,601.62
101.401.254.361 GRANTS 23,151,500.22 26,064,291.22
101.401.254.362 SEWER TAP IN CHARGE 2,437,692.75 2,503,301.88
101.401.254.363 SEWER CONTRIBUTED ASSETS 98,819,389.04 104,953,558.33
101.401.254.364 SEWER MAIN EXTENSION CHARGE 4,231,022.83 4,765,501.16
Investment In Capital Assets 247,290,363.28 268,771,329.63
Total Fund Balance 301,114,155.92 326,566,813.86
Beginning Fund Balance 293,106,326.89 324,403,223.95
Net of Revenues VS Expenditures 576,691.09 5,776.58
Fund Balance Adjustments 8,007,829.03 2,163,589.91
Ending Fund Balance 301,690,847.01 326,572,590.44
Total Liabilities And Fund Balance 409,289,130.73 431,148,982.94
tO
12/12/2022 05:29 PM REVENUE AND EXPENDITURE REPORT FOR CLAY COUNTY UTILITIES Page: 1/1
User: kosborne
DB: CCUA PERIOD ENDING 10/31/2022
YTD BALANCE YTD BALANCE
GL NUMBER DESCRIPTION 10/31/2021 10/31/2022
Fund 101 - GENERAL FUND
WATER REVENUES 2,085,142.23 2,177,668.20
SEWER REVENUES 2,588,868.39 2,674,505.72
MISCELLANEOUS REVENUES 173,145.46 139,309.94
INTEREST UNRESTRICTED 48,052.83 42,805.65
INTEREST RESTRICTED 24.04 0.00
CONSTRUCTION INCOME 8,469.38 0.00
TOTAL REVENUES 4,903,702.33 5,034,289.51
BAD DEBT (993.41) (1,568.46)
COMMUNICATION 42,814.82 29,415.78
DUE IN LIEU OF TAXES 210,330.48 218,347.83
ELECTRIC & FUEL EXPENSES 201,010.86 264,613.10
MISCELLANEOUS EXPENSES 3,892.47 41,162.99
PROPERTY & LIABILITY INSURANCE 72,855.17 85,391.55
PROFESSIONAL SERVICES 121,769.30 86,317.46
SLUDGE TREATMENT & DISPOSAL 160,220.07 183,839.97
SUBCONTRACTORS 219,768.53 386,761.68
SUPPLIES 452,983.66 423,409.07
TRANSPORTATION 49,367.57 42,413.49
WAGES & RELATED EXPENSES 1,487,488.00 1,947,543.46
DEPRECIATION 1,094,054.13 1,121,990.01
INTEREST EXPENSE 187,862.00 187,562.51
CONSTRUCTION EXPENSE 23,587.59 11,312.49
TOTAL EXPENDITURES 4,327,011.24 5,028,512.93
Fund 101 - GENERAL FUND:
TOTAL REVENUES 4,903,702.33 5,034,289.51
TOTAL EXPENDITURES 4,327,011.24 5,028,512.93
NET OF REVENUES & EXPENDITURES 576,691.09 5,776.58
TOTAL REVENUES - ALL FUNDS 4,903,702.33 5,034,289.51
TOTAL EXPENDITURES - ALL FUNDS 4,327,011.24 5,028,512.93
NET OF REVENUES & EXPENDITURES 576,691.09 5,776.58
7
CLAY COUNTY UTILITY AUTHORITY
STATEMENTS OF CASH FLOWS
FOR THE ONE MONTH ENDED OCTOBER 31,2021 AND 2022
October 31,2021 October 31,2022
Cash flows from operating activities $ 1,846,265 $ 688,654
Net cash provided by operating activities 1,846,265 688,654
Cash flows from capital and related financing activities
Proceeds from issuance of bonds and loans - -
Principal paid on long-term debt - -
Interest paid on long-term debt (70) (21)
Payments to acquire and construct plant property (4,924,517) (3,062,262)
Capital contributions 2,519,677 449,068
Grants 40,649 98,009
Net cash used in capital and related financing activities (2,364,261) (2,515,206)
Cash flows from investing activities
Purchases of investments (50,405) (67,367)
Sales of investments - -
Interest income 48,077 42,806
Net cash provided by investing activities (2,328) (24,562)
Net increase(decrease)in cash and cash equivalents (520,325) (1,851,114)
Cash and cash equivalents,beginning of period 41,874,593 29,907,741
Cash and cash equivalents,end of period $ 41,354,268 $ 28,056,628
Reconciliation of operating income to net cash provided by operating activities
Cash flows from operating activities
Operating income $ 716,476 $ 150,533
Adjustments to reconcile operating income to net
t0 cash provided by operating activities:
Depreciation expense 1,099,276 1,124,113
Changes in assets and liabilities
Decrease(Increase)in accounts receivable (31,314) 1,148,111
Decrease(Increase)in prepaid items and inventory (356,235) (689,202)
Decrease(Increase)in notes/interest receivable 4,464 31,092
Increase(Decrease)in accounts payable 467,118 (921,519)
Increase(Decrease)in accrued expenses 179,026 9,826
Increase(Decrease)in unearned revenue (239,444) (182,558)
Increase(Decrease)in customer deposits 6,898 18,258
Total adjustments 1,129,788 538,121
Net cash provided by operating activities $ 1,846,265 $ 688,654
Supplemental schedule of noncash investing,capital,and financing activities
Utility plant property contributed by developers $ 5,447,503 $ 1,616,513
8
Cumulative Cash Flow
$100,000,000 /--- —m°‘11illk--
$90,000,000 /
$80,000,000
$70,000,000
$60,000,000
$50,000,000 '
I I
$40,000,000
$30,000,000
t0
—
$20,000,000
—
$10,000,000
i
$0 / I —
ti� tic. titi titi titi 1> titi 1> titi titi titi 1> titi 1> ti� ti� ti� titi titi titi titi titi titi titi
�o� Oec Nam «�� 4\a PQt , ,J� � Pip° c42Q CO °2 0
e5 N'as < 4\4 QQt 4`a N`P Ns p0 y2.9 06
V Cash ■Investments
CLAY COUNTY UTILITY AUTHORITY
CASH AND CASH EQUIVALENTS REPORT
As of October 31, 2022
BB&T Ameris SBA Investments Total
Lend A Helping Hand Fund $151 $151
Operating Accounts ** $4,686,452 $4,686,452
FSA Account $42,622 $42,622
Emergency Accounts $20,830 $20,830
Petty Cash $2,002 $2,002
Total Operating Funds $4,751,907 $4,751,907
Public Funds Now:
Water Plant Connection Fund $109,467 * $109,467 R
Water Line Connection Fund $73,323 * $73,323 R
Sewer Plant Connection Fund $2,407,695 * $2,407,695 R
Sewer Lines Connection Fund $306,260 * $306,260 R
Alternative Water Supply Fund $3,598,993 * $3,598,993 R
Renewal&Replacement Fund $1,493,882 * $1,493,882 R
Debt Stabilization and Reserve Account_Unrestricted $1,312,345 * - - $1,312,345
Surplus Fund $2,563,433 $839,366 $106,134 $52,695,350 $56,204,282
Available For Construction $11,865,398 $839,366 $106,134 $52,695,350 $65,506,247
Debt Service Sinking Funds:
2007A Bond Sinking Fund $4,514,385 * $4,514,385 R
DEP Loan Debt Service Sinking Acct $61,136 * $61,136 R
BBVA Compass Loan Sinking Funds $1,423,570 * $1,423,570 R
2018 Bond Sinking Fund $236,247 * $236,247 R
Debt Stabilization and Reserve Account_Restricted
Letter of Credit_Financial Responsible Officer $102,360 $102,360
Customer Deposits&Self Insurance Fund
Customer Deposits - * $3,630,974 $3,630,974
Self Insurance Fund_Sewage Backups *
Health Insurance - * $500,000 $500,000
Unemployment * $25,000 $25,000
TOTAL Funds $6,337,699 $4,155,974 - - $10,493,672
TOTAL CASH&CASH EQUIVALENTS $22,955,155 $4,995,339 $106,134 $52,695,350 $80,751,977
Investment Accounts
Maturity Date Balance APY
US Bank Various $52,695,350 1.83%
$52,695,350
* BB&T Public Funds Money Checking Accounts $15,537,305 0.25%
BB&T Public Funds Money Checking Accounts_Earnings Credit waives bank fees $4,686,452 0.25%
Ameris Public Funds Money Checking Accounts $4,995,339 0.30%
SBA $106,134 3.15%
•w Operating Account has significant Surplus Funds due to Earnings Credit offsetting fees greater than interest
Construction Balance $65,506,247
Operating Cash $2,686,452
Available Construction Balance: $68,192,700
"R"indicates fund is Restricted by Bond Resolution,Enabling Legislation or Board Resolution.
Printed 12/13/2022 Section B
CLAY COUNTY UTILITY AUTHORITY
BUDGET REPORTS
FISCAL YEAR 2022/2023
to
Section C
12/12/2022 REVENUE AND EXPENDITURE REPORT FOR CLAY COUNTY UTILITIES
PERIOD ENDING 10/31/2022
OPERATING BUDGET REPORT
2022-23 YTD BALANCE AVAILABLE %BDGT
GL NUMBER DESCRIPTION AMENDED BUDGET 10/31/2022 BALANCE USED
OPERATING REVENUES
Water Revenues
Net Water Base Charges 8,192,383.00 722,299.41 7,470,083.59 8.82%
Net Water Use Charges 11,345,365.00 971,934.53 10,373,430.47 8.57%
Net Reuse Water Base Charges 3,164,349.00 286,158.28 2,878,190.72 9.04%
Net Reuse Water Usage Charges 2,412,586.00 197,275.98 2,215,310.02 8.18%
Net Water Revenues 25,114,683.00 2,177,668.20 22,937,014.80 8.67%
Sewage Revenues
Net Sewer Base Charges 16,615,838.00 1,496,929.21 15,118,908.79 9.01%
Net Sewer Use Charges 14,355,094.00 1,177,576.51 13,177,517.49 8.20%
Net Sewage Revenues 30,970,932.00 2,674,505.72 28,296,426.28 8.64%
Other Revenues
Net Miscellaneous 1,784,209.00 139,309.94 1,644,899.06 7.81%
Net Other Revenues 1,784,209.00 139,309.94 1,644,899.06 7.81%
Net OPERATING REVENUES 57,869,824.00 4,991,483.86 52,878,340.14 8.63%
INTEREST INCOME
Net Unrestricted 584,214.00 42,805.65 541,408.35 7.33%
Net Restricted 2,335.00 0.00 2,335.00 0.00%
Net INTEREST INCOME 586,549.00 42,805.65 543,743.35 7.30%
OPERATING EXPENSES
Net Bad Debt Expenses 500.00 (1,568.46) 2,068.46 -313.69%
Net Wage Related Expenses 5,230,405.84 533,173.57 4,697,232.27 10.19%
Net Communication Expenses 524,779.00 29,415.78 495,363.22 5.61%
Net Due in Lieu of Taxes 2,523,853.00 218,347.83 2,305,505.17 8.65%
Net Electric&Fuel Expenses 2,689,374.00 264,613.10 2,424,760.90 9.84%
Net Miscellaneous Expenses 302,642.00 41,162.99 261,479.01 13.60%
Net Property&Liability Insurance 966,619.00 85,391.55 881,227.45 8.83%
Net Professional Services 1,361,045.00 102,741.04 1,258,303.96 7.55%
Net Sludge Treatment&Disposal 2,684,753.00 183,839.97 2,500,913.03 6.85%
Net Subcontractors 6,052,714.00 383,965.56 5,668,748.44 6.34%
Net Supplies 5,879,439.00 423,409.07 5,456,029.93 7.20%
Net Transportation Expenses 723,366.00 42,413.49 680,952.51 5.86%
Net Wage Expense 13,537,455.61 1,400,742.43 12,136,713.18 10.35%
Net OPERATING EXPENSES 42,476,945.45 3,707,647.92 38,769,297.53 8.73%
NON-OPERATING EXPENSES
Net Depreciation Expense 13,170,852.00 1,121,990.01 12,048,861.99 8.52%
Net Interest Expense 1,920,828.00 187,562.51 1,733,265.49 9.76%
Net Loss(Gain)on Sale of Assets 0.00 0.00 0.00 100.00%
Net NON-OPERATING EXPENSES 15,091,680.00 1,309,552.52 13,782,127.48 8.68%
Net CONSTRUCTION EXPENSES 545,662.15 11,312.49 534,349.66 2.07%
Net CONSTRUCTION INCOME 545,662.00 0.00 545,662.00 0.00%
Net CONTINGENCY 1,039,583.00 0.00 1,039,583.00 0.00%
TOTAL REVENUES-ALL FUNDS 59,002,035.00 5,034,289.51 53,967,745.49 8.53%
TOTAL EXPENDITURES-ALL FUNDS 59,153,870.60 5,028,512.93 54,125,357.67 8.50%
NET OF REVENUES&EXPENDITURES (151,835.60) 5,776.58 (157,612.18) -3.80%
12
12/12/2022 05:37 PM EXPENDITURE REPORT FOR CLAY COUNTY UTILITIES Page: 1/1
User: kosborne
DB: CCUA PERIOD ENDING 10/31/2022
OPERATING EXPENSE BUDGET REPORT
2022-23 YTD BALANCE AVAILABLE % BDGT
GL NUMBER DESCRIPTION AMENDED BUDGET 10/31/2022 BALANCE USED
Net WAGES & TEMP. LABOR 13,941,858.61 1,417,166.01 12,524,692.60 10.16
Net CAPITALIZED WAGES 176,342.47 0.00 176,342.47 0.00
Net HEALTH & LIFE INSURANCE 2,680,227.61 250,453.59 2,429,774.02 9.34
Net PENSION & BENEFITS 1,435,295.57 150,599.95 1,284,695.62 10.49
Net PAYROLL TAXES 1,006,069.57 104,469.41 901,600.16 10.38
Net W/C INSURANCE 198,880.77 28,364.46 170,516.31 14.26
Net PROPERTY & LIABILITY INSURANCE 1,020,619.00 90,842.08 929,776.92 8.90
Net TRANSPORTATION 753,366.00 44,789.31 708,576.69 5.95
Net RENTAL EXPENSE 49,706.00 2,155.00 47,551.00 4.34
Net COMMUNICATION EXPENSES 524,779.00 29,415.78 495,363.22 5.61
Net ELECTRIC & FUEL WATER PLANTS 744,000.00 76,661.04 667,338.96 10.30
Net ELECTRIC & FUEL LIFT STATIONS 440,000.00 43,192.65 396,807.35 9.82
Net ELECTRIC & FUEL SEWAGE PLANTS 1,466,000.00 140,074.88 1,325,925.12 9.55
Net ELECTRIC AT OFFICE 39,374.00 4,684.53 34,689.47 11.90
Net CHEMICALS FOR WATER 233,400.00 14,040.77 219,359.23 6.02
Net CHEMICALS FOR SEWAGE 950,000.00 83,422.94 866,577.06 8.78
Net SUPPLIES FOR WATER 1,850,390.00 96,353.30 1,754,036.70 5.21
Net SUPPLIES FOR SEWAGE 1,240,684.00 110,447.49 1,130,236.51 8.90
Net OFFICE SUPPLIES 1,617,915.00 119,793.63 1,498,121.37 7.40
Net ENGINEERING EXPENSES 393,200.00 69,001.63 324,198.37 17.55
Net LEGAL EXPENSES 537,126.00 17,646.82 519,479.18 3.29
Net AUDIT EXPENSES 34,000.00 0.00 34,000.00 0.00
Net SUBCONTRACTORS-WATER 1,333,056.00 107,218.17 1,225,837.83 8.04
Net SUBCONTRACTORS-SEWAGE 993,729.00 75,384.55 918,344.45 7.59
Net SUBCONTRACTORS-GENERAL 3,750,829.00 201,031.85 3,549,797.15 5.36
Net SLUDGE TREATMENT & DISPOSAL 2,684,753.00 183,839.97 2,500,913.03 6.85
Net BAD DEBT EXPENSE 500.00 (1,568.46) 2,068.46 (313.69)
Net MISCELLANEOUS 252,936.00 39,007.99 213,928.01 15.42
Net DUE IN LIEU OF TAXES 2,523,853.00 218,347.83 2,305,505.17 8.65
Net CONTINGENCY 1,084,916.00 0.00 1,084,916.00 0.00
TOTAL EXPENDITURES - ALL FUNDS 43,957,805.60 3,716,837.17 40,240,968.43 8.46
13
CLAY COUNTY UTILITY
AUTHORITY CIAC REPORTS
t° FISCAL YEAR 2022/2023
Section D
12/12/2022 05:37 PM TRIAL BALANCE REPORT FOR CLAY COUNTY UTILITIES Page: 1/2
User: kosborne
DB: CCUA PERIOD ENDING 10/31/2022
ACTIVITY FOR
2022-23 BEG. BALANCE MONTH YEAR-TO-DATE END BALANCE
GL NUMBER DESCRIPTION AMENDED BUDGET 10/01/2022 10/31/2022 THRU 10/31/22 10/31/2022
Fund 101 - GENERAL FUND
Fund Equity
WATER CAPACITY
101.401.254.350 WATER CAPACITY CHARGES 11,224,067.36 31,620.00 31,620.00 11,255,687.36
WATER CAPACITY 11,224,067.36 31,620.00 31,620.00 11,255,687.36
SEWER CAPACITY
101.401.254.360 SEWER CAPACITY CHARGES 49,245,421.62 257,180.00 257,180.00 49,502,601.62
101.401.254.361 GRANTS 25,966,282.30 98,008.92 98,008.92 26,064,291.22
SEWER CAPACITY 75,211,703.92 355,188.92 355,188.92 75,566,892.84
AWS
101.401.240.000 AWS CIAO 7,130,813.49 90,315.96 90,315.96 7,221,129.45
AWS 7,130,813.49 90,315.96 90,315.96 7,221,129.45
SJRWMD BLACK CREEK
101.401.240.100 SJRWMD Black Creek CIAC 707,501.13 55,696.08 55,696.08 763,197.21
SJRWMD BLACK CREEK 707,501.13 55,696.08 55,696.08 763,197.21
WATER MAIN
101.401.254.354 WATER MAIN EXTENSION CHARGE 3,109,856.87 0.00 0.00 3,109,856.87
WATER MAIN 3,109,856.87 0.00 0.00 3,109,856.87
SEWER MAIN
101.401.254.364 SEWER MAIN EXTENSION CHARGE 4,765,501.16 0.00 0.00 4,765,501.16
SEWER MAIN 4,765,501.16 0.00 0.00 4,765,501.16
FIRE
101.401.254.351 FIRE CAPACITY CHARGES 2,035,389.18 8,695.50 8,695.50 2,044,084.68
FIRE 2,035,389.18 8,695.50 8,695.50 2,044,084.68
WATER TAP IN
101.401.254.352 WATER TAP IN CHARGE 2,340,817.16 4,492.51 4,492.51 2,345,309.67
WATER TAP IN 2,340,817.16 4,492.51 4,492.51 2,345,309.67
SEWER TAP IN
101.401.254.362 SEWER TAP IN CHARGE 2,503,301.88 0.00 0.00 2,503,301.88
SEWER TAP IN 2,503,301.88 0.00 0.00 2,503,301.88
WATER CONT PROP
101.401.254.353 WATER CONTRIBUTED ASSETS 52,464,976.63 471,506.35 471,506.35 52,936,482.98
WATER CONT PROP 52,464,976.63 471,506.35 471,506.35 52,936,482.98
SEWER CONT PROP
101.401.254.363 SEWER CONTRIBUTED ASSETS 103,808,551.24 1,145,007.09 1,145,007.09 104,953,558.33
SEWER CONT PROP 103,808,551.24 1,145,007.09 1,145,007.09 104,953,558.33
DEBT SERVICE
101.401.254.355 DEBT SERVICE CHARGE 1,305,259.70 1,067.50 1,067.50 1,306,327.20
15
12/12/2022 05:37 PM TRIAL BALANCE REPORT FOR CLAY COUNTY UTILITIES Page: 2/2
User: kosborne
DB: CCUA PERIOD ENDING 10/31/2022
ACTIVITY FOR
2022-23 BEG. BALANCE MONTH YEAR-TO-DATE END BALANCE
GL NUMBER DESCRIPTION AMENDED BUDGET 10/01/2022 10/31/2022 THRU 10/31/22 10/31/2022
Fund 101 - GENERAL FUND
Fund Equity
DEBT SERVICE 1,305,259.70 1,067.50 1,067.50 1,306,327.20
TOTAL FUND EQUITY 266,607,739.72 2,163,589.91 2,163,589.91 268,771,329.63
Total Fund 101 - GENERAL FUND
TOTAL ASSETS 0.00 0.00 0.00 0.00
BEG. FUND BALANCE 324,403,223.95 324,403,223.95
+ NET OF REVENUES & EXPENDITURES
+ FUND BALANCE ADJUSTMENTS 3,723,093.83 3,723,093.83
= ENDING FUND BALANCE 266,607,739.72 2,163,589.91 2,163,589.91 268,771,329.63
+ LIABILITIES 0.00 0.00 0.00 0.00
= TOTAL LIABILITIES AND FUND BALANCE 266,607,739.72 2,163,589.91 2,163,589.91 268,771,329.63
OUT OF BALANCE 0.00 (2,163,589.91) (2,163,589.91) (268,771,329.63)
16
CLAY COUNTY UTILITY AUTHORITY
2022/2023 Alternative Water Supply Surcharges
Beginning October November December January February March April May June July August September Balance
Established 10/1/2015 Balance 2022 2022 2022 2023 2023 2023 2023 2023 2023 2023 2023 2023 9/30/2023
Expenditures:
Job 991 FCOB Stormwater Harvesting Pilot Project 800,174.90 20,548.61 820,723.51
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 708,857.91 206,433.56 915,291.47
I
New Development: -
Total Expenditures 3,533,989.87 226,982.17 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3,760,972.04
Existing Customers:
Revenue:
Surcharge Fund(Existing Customers) 4,108,291.49 56,754.88 4,165,046.37
Connection Charge Fund(Growth) 2,894,376.18 33,286.82 2,927,663.00
Interest Income 40,273.79 40,273.79
Total Revenue 7,042,941.46 90,041.70 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 7,132,983.16
Balance 3,508,951.59 (136,940.47) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3,372,011.12
Cash Balance 3,598,993.29
Done in following Month:
Less Construction Costs transferred after month close (226,982.17)
J/E-Adjustment True Up for Move-Ins/Move-Outs
J/E-Interfund Transfer
3,372,011.12
Page D-la
17
CLAY COUNTY UTILITY AUTHORITY
CAPITAL PROJECT BUDGET
to REPORT
FISCAL YEAR 2022/2023
Section E
18
Clay County Utility Authority References
Capital Projects Budget Report
RENEWAL, REPLACEMENT & BETTERMENT 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 10/31/22 Balances To Fund Amendments 2022/2023
Departmental Capital 100 247,281.34 1,386,263.08 1,633,544.42 1,633,544.42 1,633,544.42
Upgrade Lift station 9-Meadowbrook 755 101,922.26 101,922.26 8,077.74 93,844.52 101,922.26
Knight Boxx/Old Jennings Force Main Extension 967 90,885.05 368,229.90 459,114.95 (300,000.00) 9,114.95 150,000.00 1 159,114.95
Rehab SP WW Clarifer#1/under drain 1-2 02519RR 933,274.98 615,901.22 1,549,176.20 66,725.02 1,482,451.18 1,549,176.20
Ridgecrest WTP-Replace Softstart&Crossline Starters with VFD's 20021RR 907,510.65 1,103,717.35 2,011,228.00 646,576.61 1,364,651.39 2,011,228.00
New Lift Station Generators: 172, 165, 151, 142, 163, 124 21002RR 56,108.76 1,713.37 57,822.13 343,891.24 (286,069.11) 57,822.13
Fleming Island Reg.WWTP-2nd BCR Plant,Two Tanks 21010RR 5,200,000.00 2,000,000.00 7,200,000.00 (1,130,000.00) 3,762,141.46 2,307,858.54 1 6,070,000.00
Fleming WRF Clarifier No. 1 Upgrade 21014RR 1,101,500.14 106,499.86 1,208,000.00 (339,500.14) 121,499.86 747,000.00 1 868,499.86
Lift Station#2-Upgrade 21016RR 649,208.59 2,298,937.57 2,948,146.16 (913,146.16) 50,791.41 1,984,208.59 1 2,035,000.00
Ridaught WWTP Upgrades(Install Micro-screen,Grit Removal Equipment, a 21019RR 1,505,007.13 1,381,992.87 2,887,000.00 271,216.61 2,615,783.39 2,887,000.00
Lift Station#3 Foxbay Upgrade 21022RR 713,703.00 172,297.00 886,000.00 36,297.00 849,703.00 886,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 roo 21029RR 949,070.30 1,133,237.70 2,082,308.00 (1,584,999.55) 137,646.09 359,662.36 1 497,308.45
Gravity Sewer Lining 21031RR 401,134.10 899,460.15 1,300,594.25 692,096.12 608,498.13 1,300,594.25
Oakleaf WTP Well No.2 22005RR 75,145.08 75,145.08 69,854.92 5,290.16 75,145.08
Ridaught WTP-Phase I GST Upgrades 22007RR 872,000.00 872,000.00 (817,896.74) 54,103.26 0.00 1 54,103.26
Lift Station#4 Upgrades 22008RR 487,985.00 312,015.00 800,000.00 (693,600.00) 12,015.00 94,385.00 1 106,400.00
Lift Station#62 and#67-Rehabilitation 22009RR 320,000.00 320,000.00 25,862.04 294,137.96 320,000.00
Fleming Oaks WTP Electrical Upgrades&Hydro Tank Not Started 0.00 190,000.00 190,000.00 0.00 190,000.00 190,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
Booster Station(Hwy. 100 @ Commercial Dr. -Keystone) Not Started 0.00 0.00 0.00 0.00 0.00
Keystone Wastewater Treatment Plant-Phase II Construction Not Started 0.00 0.00 0.00 0.00 0.00
Keystone Heights High School WM relocation Not Started 0.00 143,000.00 143,000.00 0.00 143,000.00 143,000.00
Keystone Heights-Lakeside Street/Hilltop Street Water Main Rehabilitation Not Started 0.00 237,600.00 237,600.00 0.00 237,600.00 237,600.00
Miller St.WWTP Upgrades(Complete Paving of Loop Road,Refurbish Influ Not Started 0.00 0.00 0.00 0.00 0.00
Pace Island WTP: Electrical&Hydro Tank Upgrades(Replace Hydrotank To Not Started 0.00 220,000.00 220,000.00 0.00 220,000.00 220,000.00
Old Jennings WTP Electrical Upgrade Not Started 0.00 0.00 0.00 0.00 0.00
Spencer's 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
Fleming island WRF electrical upgrades/Vault upgrades Not Started 0.00 296,171.00 296,171.00 0.00 296,171.00 296,171.00
Miller WRF Electrical Upgrades Not Started 0.00 125,005.00 125,005.00 0.00 125,005.00 125,005.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
Spencers WTP-Ground Storage&High Service Pump Not Started 0.00 565,000.00 565,000.00 0.00 565,000.00 565,000.00
Sandridge Road widening from Henley to CR 209 Not Started 40,000.00 40,000.00 80,000.00 0.00 80,000.00 80,000.00
Server Lifecycle Replacement Not Started 0.00 0.00 0.00 0.00 0.00
X:\Finance\Controllers Folder\Monthly Financial\Monthly Construction Reports\2022-2023\CI P_2023_Oct.xlsx Page 1 of 4
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 10/31/22 Balances To Fund Amendments 2022/2023
Upgrade Lift Stations 11,41,69,51 Not Started 542,000.00 542,000.00 0.00 542,000.00 542,000.00
Upgrade Lift Station 98 Not Started 0.00 0.00 0.00 0.00 0.00
Upgrade Lift Stations 9,43,24, 59 Not Started 0.00 0.00 0.00 0.00 0.00
Upgrade Lift Station 111 Not Started 0.00 0.00 0.00 0.00 0.00
Upgrade Lift Station 56 Not Started 0.00 125,000.00 125,000.00 0.00 125,000.00 125,000.00
Lift Station Bypass Pump Not Started 0.00 200,000.00 200,000.00 0.00 200,000.00 200,000.00
SCADA System Not Started 0.00 1,260,048.00 1,260,048.00 (500,000.00) 0.00 760,048.00 1 760,048.00
WTP Ground Storage Tanks: add Handrails Not Started 576,000.00 576,000.00 0.00 576,000.00 576,000.00
Water Plant Meters Retrofits Not Started 0.00 108,000.00 108,000.00 0.00 108,000.00 108,000.00
Manhole Rehab Not Started 150,000.00 150,000.00 0.00 150,000.00 150,000.00
FH and Gate Valve replacement Not Started 105,000.00 105,000.00 0.00 105,000.00 105,000.00
Potable and Reclaimed Water Meter and backflow device replacement Not Started 761,250.00 761,250.00 0.00 761,250.00 761,250.00
I SYSTEM EXPANSION
Meadow Lake WTP-New Ground Storage Tank and Electrical Service upgrad 00983WP 2,198,046.00 951,078.00 3,149,124.00 2,123,199.57 1,025,924.43 3,149,124.00
Henley Road 12"WM Loop-Sandridge to Small Lake 01119WL 106,000.00 106,000.00 11,258.64 94,741.36 106,000.00
North Middleburg Water&Sewer Extension and Interconnection(Water Inte 02419WL 1,869,191.77 1,130,808.23 3,000,000.00 (2,397,000.00) 347,734.63 255,265.37 1 603,000.00
Saratoga Springs WTP-Phase I 03018WP 2,348,753.55 6,850,213.45 9,198,967.00 6,830,949.73 2,368,017.27 9,198,967.00
Saratoga Springs RWP-Phase I 03118RP 1,607,033.00 3,000,000.00 4,607,033.00 4,317,346.77 289,686.23 4,607,033.00
Middleburg Water and Sewer Relocations 03319WL 602,241.10 602,241.10 273,197.44 329,043.66 602,241.10
Saratoga Springs Offsite Main Extensions 03419WL 2,785,000.00 2,785,000.00 1,476,478.86 1,308,521.14 2,785,000.00
Mid Clay WWTP-Phase II Plant Expansion 20003SP 5,082,615.00 2,167,385.00 7,250,000.00 6,296,246.05 953,753.95 7,250,000.00
Fleming Island Reg.WWTP-#3 BTU Installation,Design 20004SP 6,520,000.00 6,520,000.00 6,773,093.36 (253,093.36) 6,520,000.00
2019-054 Doctors Lake Restoration Project 20011SL 411,340.52 1,471,992.48 1,883,333.00 1,666,526.54 216,806.46 1,883,333.00
CCUA Storage Building and Site Improvements 21001AD 3,734,845.00 178,471.00 3,913,316.00 3,380,403.62 532,912.38 3,913,316.00
CCUA Administrative Building Phase I 21013AD 214,907.00 3,910,182.00 4,125,089.00 192,556.31 3,932,532.69 4,125,089.00
CCUA Administrative Building Phase II Not Started 0.00 350,000.00 350,000.00 0.00 350,000.00 350,000.00
Aquarius Concourse Relocation Utility Relocations 21004WL 1,948,637.00 195,000.00 2,143,637.00 2,166,611.25 (22,974.25) 2,143,637.00
Swimming Penn Creek WM Interconnect 21020WL 2,000,000.00 250,000.00 2,250,000.00 (952,200.00) 211,548.70 1,086,251.30 1 1,297,800.00
Ravines to Henly Road Water Main Extension 21023WL 2,250,000.00 2,250,000.00 (1,007,000.00) 214,740.01 1,028,259.99 1 1,243,000.00
Governor's Park WTP Design and Build 21026WP 977,400.00 4,147,600.00 5,125,000.00 318,352.05 4,806,647.95 5,125,000.00
Peters Creek WTP 2nd GST&3rd Well 21030WP 975,000.00 2,075,000.00 3,050,000.00 (2,560,000.00) 158,719.17 331,280.83 1 490,000.00
Peters Creek New Regional WRF 22003SP 1,675,000.00 41,085,192.00 42,760,192.00 2,328,926.02 40,431,265.98 42,760,192.00
CCUA North Campus Driveway 22010AD 36,340.73 750,000.27 786,341.00 (499,341.00) 28,577.80 258,422.20 1 287,000.00
LAMPA E/W Interconnect#1 -Water Lines 22012WL 247,500.00 247,500.00 3,914.12 243,585.88 247,500.00
LAMPA E/W Interconnect#1 -Wwtr-Reuse 22013SL 495,000.00 495,000.00 7,952.03 487,047.97 495,000.00
LAMPA E/W Interconnect#2-Water Lines 22014WL 165,000.00 165,000.00 7,834.14 157,165.86 165,000.00
LAMPA E/W Interconnect#2-Wwtr-Reuse 22015SL 330,000.00 330,000.00 15,909.96 314,090.04 330,000.00
LAMPA N/S Interconnect#1 -Water Lines 22016WL 305,250.00 305,250.00 4,827.81 300,422.19 305,250.00
LAMPA N/S Interconnect#2 Wwtr&Reuse 22017SL 610,500.00 610,500.00 9,808.88 600,691.12 610,500.00
•
X:\Finance\Controllers Folder\Monthly Financial\Monthly Construction Reports\2022-2023\CI P_2023_Oct.xlsx Page 2 of 4
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 10/31/22 Balances To Fund Amendments 2022/2023
LAMPA N/S Interconnect#2 Water Lines 22018WL 181,500.00 181,500.00 2,870.75 178,629.25 181,500.00
LAMPA N/S Interconnect#2 Wwtr&Reuse 22019SL 363,000.00 363,000.00 5,829.91 357,170.09 363,000.00
Emalyn Place 3 Single Family Units 22021WL 17,000.00 17,000.00 8,589.95 8,410.05 17,000.00
Peter's Creek WWTP-Land Acquisition 22022SP 3,000,000.00 3,000,000.00 4,035.00 2,995,965.00 3,000,000.00
Engineering Cost Allocation 9999999 0.00 32,348.59 (32,348.59) 0.00
Sandridge Parallel Sewer FM(PS#110 to RVZ Park via Creekview Tr.-5,00 Not Started 1,000,000.00 1,000,000.00 0.00 1,000,000.00 1,000,000.00
Reinhold Projects E/W interconnect#1 (W,WW&Reclaimed Mains from F Not Started 3,000,000.00 3,000,000.00 0.00 3,000,000.00 3,000,000.00
Reinhold Projects E/W interconnect #2(W,WW&Reclaimed Mains along] Not Started 2,000,000.00 2,000,000.00 0.00 2,000,000.00 2,000,000.00
Reinhold Projects N/S interconnect#1 Saratoga WM to West of 1st Coast Ex Not Started 3,700,000.00 3,700,000.00 0.00 3,700,000.00 3,700,000.00
Reinhold Projects N/S interconnect#2(W&Reclaimed Mains from Saratoga Not Started 0.00 0.00 0.00 0.00
16-inch WM Challenger Dr Interconnect to Atlantis dr. -Atlantis to Brannan Not Started 1,000,000.00 1,000,000.00 (1,000,000.00) 0.00 0.00 1 0.00
16-inch WM Atlantis to Kindlewood Not Started 500,000.00 500,000.00 (500,000.00) 0.00 0.00 1 0.00
Upsizing pipes to accommodate Rookery GCS Not Started 0.00 0.00 0.00 0.00
FDOT 447180-1:US17 from Eagle Harbor to Doctors Inlet Bridge Not Started 310,000.00 310,000.00 0.00 310,000.00 310,000.00
FDOT 443302-1: SR15(US17)From Water Oak Lane to Eagle Harbor Parkw. Not Started 0.00 0.00 0.00 0.00
CR-220 at Old Hard Rd.Intersection Not Started 410,000.00 410,000.00 0.00 410,000.00 410,000.00
Tanglewood Neighborhood Water Main Relocations Not Started 85,000.00 85,000.00 0.00 85,000.00 85,000.00
Habitat Drive Water Main Relocations Not Started 265,000.00 265,000.00 0.00 265,000.00 265,000.00
CR 218 widening from Pine Tree Lane to Cosmos 22022RR 425,000.00 250,000.00 675,000.00 424,394.80 250,605.20 675,000.00
CR 220 widening Baxley to Henley Rd Not Started 250,000.00 250,000.00 0.00 250,000.00 250,000.00
CR 220 widening from Henley to Knightbox Not Started 150,000.00 150,000.00 0.00 150,000.00 150,000.00
CR 315 widening-Utility Relocation(design FY 23 construct FY 24) Not Started 922,000.00 922,000.00 0.00 922,000.00 922,000.00
CR220 Quadrant Intersection Not Started 578,000.00 578,000.00 0.00 578,000.00 578,000.00
College Drive RRR Not Started 200,000.00 200,000.00 0.00 200,000.00 200,000.00
Infill Projects Not Started 1,261,678.98 100,000.00 1,361,678.98 1,361,678.98 1,361,678.98
Pier Station E/W WM Extension and Interconnect(State Road 16 and FCOB) Not Started 0.00 0.00 0.00 0.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 WWTP: Phase 6 Expansion Not Started 0.00 0.00 0.00 0.00
Water System Interconnects-Misc Not Started 660,000.00 15,000.00 675,000.00 675,000.00 675,000.00
Longbay Rd. Master Pump Station and Force Main Not Started 0.00 200,000.00 200,000.00 200,000.00 200,000.00
I
ALTERNATIVE WATER SUPPLY
Purified Water Pilot Study 20022WL 614,261.99 4,154,738.01 4,769,000.00 937,641.57 3,831,358.43 4,769,000.00
AMI Demand Management Not Started 0.00 0.00 0.00
Onsite Stormwater Harvesting Not Started 0.00 0.00 0.00
Irrigation CUP Not Started 510,000.00 510,000.00 (310,000.00) 200,000.00 1 200,000.00
Public Access Reuse Storage Not Started 2,042,000.00 2,042,000.00 2,042,000.00 2,042,000.00
•
21
X:\Finance\Controllers Folder\Monthly Financial\Monthly Construction Reports\2022-2023\CI P_2023_Oct.xlsx Page 3 of 4
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 10/31/22 Balances To Fund Amendments 2022 /2023
I
Subtotals 62,554,673.02 106,060,999.51 168,615,672.53 (15,504,683.59) 46,890,333.36 106,220,655.58 153,110,988.94
Contingency 10,348,162.81 10,348,162.81 4,374,066.10 14,722,228.91
-
TOTAL CAPITAL EXPENDITURES 178,963,835.34 (11,130,617.49) 167,833,217.85
Construction In Progress 168,615,672.53 46,890,333.36 Not Started 20,640,752.98
Completed Jobs 0.00 Started 147,192,464.87
46,890,333.36 167,833,217.85
to
22
X:\Finance\Controllers Folder\Monthly Financial\Monthly Construction Reports\2022-2023\CIP_2023_Oct.xlsx Page 4 of 4
CLAY COUNTY UTILITY AUTHORITY
OPERATING DETAIL BY MONTH
to FISCAL YEAR 2022/2023
Section F
23
12/12/2022 05:40 PM REVENUE REPORT FOR CLAY COUNTY UTILITIES Page: 1/1
User: kosborne
DB: CCUA PERIOD ENDING 10/31/2022
OPERATING REVENUE BUDGET REPORT
ACTIVITY FOR
2022-23 MONTH YTD BALANCE % BDGT
GL NUMBER DESCRIPTION AMENDED BUDGET 10/31/2022 10/31/2022 USED
OPERATING REVENUES
Water Revenues
Water Base Charges
101.401.343.301 RESIDENTIAL WATER BASE CHARGE 6,650,811.00 592,580.80 592,580.80 8.91
101.401.343.303 GENERAL SERVICE WATER BASE 1,273,001.00 110,274.94 110,274.94 8.66
101.401.346.303 Commercial Potable Irrigation Base 268,571.00 19,443.67 19,443.67 7.24
Net Water Base Charges 8,192,383.00 722,299.41 722,299.41 8.67
Water Use Charges
101.401.344.303 Residential Water Usage Tier 1 3,563,059.00 309,745.22 309,745.22 8.69
101.401.344.304 Residential Water Usage Tier 2 2,473,019.00 213,832.20 213,832.20 8.65
101.401.344.305 Residential Water Usage Tier 3 1,037,236.00 95,434.30 95,434.30 9.20
101.401.344.306 Residential Water Usage Tier 4 1,184,957.00 108,033.99 108,033.99 9.12
101.401.345.305 Commercial Water Usage 2,455,117.00 188,605.44 188,605.44 7.68
101.401.346.306 Commercial Potable Irrigation Usage T 123,817.00 10,092.13 10,092.13 8.15
101.401.346.307 Commercial Potable Irrigation Usage T 223,841.00 18,488.81 18,488.81 8.26
101.401.346.308 Commercial Potable Irrigation Usage T 171,240.00 16,463.11 16,463.11 9.61
101.401.346.309 Commercial Potable Irrigation Usage T 113,079.00 11,239.33 11,239.33 9.94
Net Water Use Charges 11,345,365.00 971,934.53 971,934.53 8.67
Reuse Water Base Charges
101.401.343.601 Reuse Residential Base 2,890,097.00 261,771.19 261,771.19 9.06
101.401.343.602 Reuse Commercial Base 274,252.00 24,387.09 24,387.09 8.89
Net Reuse Water Base Charges 3,164,349.00 286,158.28 286,158.28 8.67
Reuse Water Usage Charges
101.401.347.403 Reuse Residential Usage Tier 1 934,528.00 80,306.50 80,306.50 8.59
101.401.347.404 Reuse Residential Usage Tier 2 250,847.00 21,032.32 21,032.32 8.38
101.401.347.405 Reuse Residential Usage Tier 3 714,664.00 57,705.63 57,705.63 8.07
101.401.347.406 Reuse Commercial Usage Tier 1 100,963.00 7,097.87 7,097.87 7.03
101.401.347.407 Reuse Commercial Usage Tier 2 35,037.00 2,617.97 2,617.97 7.47
101.401.347.408 Reuse Commercial Usage Tier 3 248,766.00 15,878.33 15,878.33 6.38
101.401.349.506 CROSSINGS RECLAIMED WATER CHRG 127,781.00 12,637.36 12,637.36 9.89
Net Reuse Water Usage Charges 2,412,586.00 197,275.98 197,275.98 8.67
Net Water Revenues 25,114,683.00 2,177,668.20 2,177,668.20 8.67
Sewage Revenues
Sewer Base Charges
101.401.343.501 RESIDENTIAL SEWER BASE CHARGE 14,324,559.00 1,267,728.53 1,267,728.53 8.85
101.401.343.504 GENERAL SERVICE SEWER BASE 2,291,279.00 229,200.68 229,200.68 10.00
Net Sewer Base Charges 16,615,838.00 1,496,929.21 1,496,929.21 8.64
Sewer Use Charges
101.401.343.502 RESIDENTIAL SEWER USAGE CHARGE 10,787,637.00 858,209.54 858,209.54 7.96
101.401.343.505 GENERAL SERVICE SEWER USAGE 3,383,857.00 302,895.77 302,895.77 8.95
101.401.343.506 PORTALET SEWAGE REVENUE 183,600.00 16,471.20 16,471.20 8.97
Net Sewer Use Charges 14,355,094.00 1,177,576.51 1,177,576.51 8.64
Net Sewage Revenues 30,970,932.00 2,674,505.72 2,674,505.72 8.64
Net OPERATING REVENUES 56,085,615.00 4,852,173.92 4,852,173.92 8.64
TOTAL REVENUES - ALL FUNDS 56,085,615.00 4,852,173.92 4,852,173.92 8.65
24
Budgeted vs. Actual - Base & Use Charges, Total
30,000,000
25,000,000
20,000,000
15,000,000
10,000,000
tO
5,000,000
A.7
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
$6,000,000
$5,000,000
• • •
M
$4,000,000
$3,000,000
$2,000,000
4
t0
$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
Operating Net Income
$2,500,000
A
$2,000,000
$1,500,000
$1,000,000
■
tO
$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
CLAY COUNTY UTILITY AUTHORITY
OTHER REPORTS
to FISCAL YEAR 2022/2023
Section G
28
12/12/2022 05:40 PM REVENUE AND EXPENDITURE REPORT FOR CLAY COUNTY UTILITIES Page: 1/2
User: kosborne
DB: CCUA PERIOD ENDING 10/31/2022
CONSTRUCTION DEPARTMENT BUDGET
ACTIVITY FOR
2022-23 MONTH YTD BALANCE ENCUMBERED UNENCUMBERED % BDGT
GL NUMBER DESCRIPTION AMENDED BUDGET 10/31/22 10/31/2022 YEAR-TO-DATE BALANCE USED
INTERNAL BILLINGS
101.401.349.609 BILLINGS TO CCUA-CAPITAL ASSET 545,662.00 0.00 0.00 0.00 545,662.00 0.00
Net INTERNAL BILLINGS 545,662.00 0.00 0.00 0.00 545,662.00 0.00
WAGES
101.502.536.121 WAGES HOURLY 176,342.47 0.00 0.00 0.00 176,342.47 0.00
Net WAGES (176,342.47) 0.00 0.00 0.00 (176,342.47) 0.00
HEALTH/LIFE INSURANCE
101.502.536.230 EMPLOYEE HEALTH&LIFE INSURANCE 46,856.78 0.00 0.00 0.00 46,856.78 0.00
Net HEALTH/LIFE INSURANCE (46,856.78) 0.00 0.00 0.00 (46,856.78) 0.00
RETIREMENT & BENEFITS
101.502.536.220 EMPLOYEE RETIREMENT & BENEFITS 21,712.77 0.00 0.00 0.00 21,712.77 0.00
Net RETIREMENT & BENEFITS (21,712.77) 0.00 0.00 0.00 (21,712.77) 0.00
PAYROLL TAXES
101.502.536.210 EMPLOYER FICA PAYROLL TAXES 15,281.80 0.00 0.00 0.00 15,281.80 0.00
Net PAYROLL TAXES (15,281.80) 0.00 0.00 0.00 (15,281.80) 0.00
WORKMENS COMPENSATION INS.
101.502.536.240 W/C INSURANCE 6,216.33 0.00 0.00 0.00 6,216.33 0.00
101.509.536.246 CONSTRUCTION W/C INSURANCE 0.00 713.84 713.84 0.00 (713.84) 100.00
Net WORKMENS COMPENSATION INS. (6,216.33) (713.84) (713.84) 0.00 (5,502.49) 11.48
PROPERTY/LIABILITY INSURANCE
101.502.536.451 PROPERTY INSURANCE-CONSTRUCTION 54,000.00 5,450.53 5,450.53 0.00 48,549.47 10.09
Net PROPERTY/LIABILITY INSURANCE (54,000.00) (5,450.53) (5,450.53) 0.00 (48,549.47) 10.09
OFFICE SUPPLIES
101.502.536.529 SUPPLIES OFFICE 250.00 0.00 0.00 0.00 250.00 0.00
Net OFFICE SUPPLIES (250.00) 0.00 0.00 0.00 (250.00) 0.00
TOOLS & SUPPLIES
101.502.536.527 TOOLS & SUPPLIES 12,700.00 649.06 649.06 (23.39) 12,074.33 4.93
Net TOOLS & SUPPLIES (12,700.00) (649.06) (649.06) 23.39 (12,074.33) 4.93
FUEL, OIL, & REPAIRS
101.502.536.468 EQUIP REPAIR&MAINTENANCE 30,000.00 0.00 0.00 2,865.00 27,135.00 9.55
Net FUEL, OIL, & REPAIRS (30,000.00) 0.00 0.00 (2,865.00) (27,135.00) 9.55
TRANSPORTATION
101.502.536.401 TRANSPORTATION EXPENSES 30,000.00 2,375.82 2,375.82 0.00 27,624.18 7.92
Net TRANSPORTATION (30,000.00) (2,375.82) (2,375.82) 0.00 (27,624.18) 7.92
MISCELLANEOUS
101.502.536.221 EMPLOYEE TRAINING & TRAVEL 484.00 0.00 0.00 0.00 484.00 0.00
Net MISCELLANEOUS (484.00) 0.00 0.00 0.00 (484.00) 0.00
29
12/12/2022 05:40 PM REVENUE AND EXPENDITURE REPORT FOR CLAY COUNTY UTILITIES Page: 2/2
User: kosborne
DB: CCUA PERIOD ENDING 10/31/2022
CONSTRUCTION DEPARTMENT BUDGET
ACTIVITY FOR
2022-23 MONTH YTD BALANCE ENCUMBERED UNENCUMBERED % BDGT
GL NUMBER DESCRIPTION AMENDED BUDGET 10/31/22 10/31/2022 YEAR-TO-DATE BALANCE USED
DEPRECIATION
101.401.536.595 CONSTRUCTION R&R (DEPRECIATION 104,385.00 2,123.24 2,123.24 0.00 102,261.76 2.03
Net DEPRECIATION (104,385.00) (2,123.24) (2,123.24) 0.00 (102,261.76) 2.03
MATERIALS & SUBCONTRACTORS
101.502.536.435 TRASH SERVICE 2,100.00 0.00 0.00 0.00 2,100.00 0.00
Net MATERIALS & SUBCONTRACTORS (2,100.00) 0.00 0.00 0.00 (2,100.00) 0.00
CONTINGENCY
101.401.536.990 CONTINGENCY 45,333.00 0.00 0.00 0.00 45,333.00 0.00
Net CONTINGENCY (45,333.00) 0.00 0.00 0.00 (45,333.00) 0.00
TOTAL REVENUES - ALL FUNDS 545,662.00 0.00 0.00 0.00 545,662.00 0.00
TOTAL EXPENDITURES - ALL FUNDS 545,662.15 11,312.49 11,312.49 2,841.61 531,508.05 2.59
NET OF REVENUES & EXPENDITURES (0.15) (11,312.49) (11,312.49) (2,841.61) 14,153.95 ;6,066.67
30