HomeMy WebLinkAboutEDB 2022-01 Board Financial Package Clay County Utility Authority Working together to
3176 Old Jennings Road protect public health,
Middleburg, 2 9 conserve our natural
GJI Telephone(90904)272 72-5 5999 resources,and create
♦ long-term value for
s/Ty AUTNOQ' www.clayutility.org our ratepayers.
February 23, 2022
To: Board of Supervisors
From: Jeffrey Wesselman
Re: January 2022 Financial Package
I have enclosed the following financial information:
A) Comparative Financial Statements for the four months of fiscal years 2021/2022 and 2020/2021.
Comparative Balance Sheet
c Revenue & Expenditure Report
cr Cash-flow Statement
B) Cash &Cash Equivalents Report at January 31, 2022
L C) Budget Reports for the four months of Fiscal Year 2021/2022
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, 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$1,450,102 (30%) over budget due to a unfavorable revenue and favorable expense variance.
Operating revenue is$86,077 (-0.5%) under budget and Operating expenses are$1,536,179 (12%) under budget.
Itemized operating expense variances are in Section C.
We gained 294 active (Residential 300, General Service, -6)water accounts and 285 active sewer (Residential 295,
General Service, -10) accounts for the fiscal year 2021/2022 as compared to an increase of 300 active water accounts
and an increase of 288 active sewer accounts for the same time in fiscal year 2020/2021.
1
CLAY COUNTY UTILITY AUTHORITY
COMPARATIVE FINANCIAL
STATEMENTS
to FISCAL YEAR 2021 /2022
Section A
02/23/2022 09:47 AM 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 01/31/2021 01/31/2022
*** Assets ***
Cash 39,110,960.65 39,852,414.58
Investments 46,575,070.67 52,261,698.16
Accounts Receivable 2,941,552.69 2,772,645.54
Fixed Assets 457,927,108.86 486,496,165.25
Accum. Depreciation (164,091,877.78) (176,316,883.18)
Other Assets 1,400,639.15 1,346,861.39
Deferred Outflows 2,091,917.13 1,861,655.52
Total Assets 385,955,371.37 408,274,557.26
*** Liabilities ***
Liabilities-ST 14,215,621.42 15,969,132.97
Liabilities-LT (over 1 year) 95,310,863.76 88,180,384.96
Total Liabilities 109,526,485.18 104,149,517.93
*** Fund Balance ***
Unassigned 50,926,382.11 53,823,792.64
Investment In Capital Assets 224,765,979.91 249,082,378.35
Total Fund Balance 275,692,362.02 302,906,170.99
Beginning Fund Balance 270,357,546.96 293,106,326.89
Net of Revenues VS Expenditures 736,524.17 1,218,868.34
Fund Balance Adjustments 5,334,815.06 9,799,844.10
Ending Fund Balance 276,428,886.19 304,125,039.33
Total Liabilities And Fund Balance 385,955,371.37 408,274,557.26
to
02/23/2022 09:47 AM 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 01/31/2021 01/31/2022
*** Assets ***
Cash
101.401.101.110 Cash-BB&T L.A.H.H. Account 4,041.51 1,134.69
101.401.101.125 '12 BBVA Compass Debt Service 326,066.34 364,242.97
101.401.101.160 Cash-BB&T Operating Account 11,257,144.39 12,868,487.59
101.401.101.161 Cash-BB&T Emergency Account 37,713.17 37,659.04
101.401.101.200 CASH-FSA 32,717.32 26,874.92
101.401.101.329 Debt Stabilization Reserve Unrestricted 586,127.08 1,030,850.16
101.401.101.331 2015/2019 Bond Sinking Fund 3,404,085.30 3,396,307.98
101.401.101.333 SBA - 2001 DEP Loan Debt Service Acct 34,131.28 34,127.80
101.401.101.335 CUSTOMER DEPOSIT FUND 3,413,079.37 3,496,380.32
101.401.101.336 SURPLUS FUND 9,492,262.45 2,528,228.63
101.401.101.337 SELF INSURANCE FUND 525,000.00 525,000.00
101.401.101.338 RENEWAL & REPLACEMENT FUND 4,192,237.36 5,047,398.59
101.401.101.340 WATER PLANT FUND (76%) 15,981.43 508,315.86
101.401.101.342 WATER LINE FUND (24%) 96,158.42 65,076.42
101.401.101.343 AWS Cash 1,519,543.80 2,865,610.38
101.401.101.344 SEWER PLANT FUND (53.33%) 3,452,717.40 5,916,498.66
101.401.101.346 SEWER LINE FUND (46.67%) 302,666.61 721,071.87
101.401.101.351 2018 Bond Sinking Fund 417,984.92 417,981.40
101.401.102.100 PETTY CASH FUND 1,302.50 1,167.30
Cash 39,110,960.65 39,852,414.58
Investments
101.401.101.321 Short Term Investments - Restricted 12,031,434.15 0.00
101.401.101.323 Short Term Investments - Surplus 34,543,636.52 52,261,698.16
Investments 46,575,070.67 52,261,698.16
Accounts Receivable
101.401.115.100 ACCOUNTS RECEIVABLE W&S CUST 981,467.85 719,817.62
101.401.115.110 A/R CIAC & MISC REPAIR INVS. 348,067.70 347,659.73
101.401.115.120 Loans To Customers 46,313.07 33,714.88
101.401.115.121 Loan to Customers Long-term 352,673.65 330,339.77
101.401.115.200 A/R UNBILLED WATER REVENUE 506,733.36 560,551.10
101.401.115.250 A/R Unbilled Reuse Revenue 73,394.43 92,581.97
101.401.115.300 A/R UNBILLED SEWER REVENUE 841,978.58 866,050.69
101.401.115.400 A/R CLEARING ACCOUNT (2,996.73) (1,741.29)
101.401.117.100 ALLOWANCE FOR DOUBTFULL A/R (206,079.22) (176,328.93)
Accounts Receivable 2,941,552.69 2,772,645.54
Fixed Assets
101.401.161.900 LAND 5,268,724.07 5,268,724.07
101.401.162.900 BUILDINGS 7,068,107.35 9,045,538.84
101.401.166.900 MACHINERY & EQUIPMENT 426,974,774.06 446,862,162.48
101.401.168.900 Intangible Assets 0.00 3,632,438.00
101.401.169.900 CONSTRUCTION IN PROGRESS 18,615,503.38 21,687,301.86
Fixed Assets 457,927,108.86 486,496,165.25
Accum. Depreciation
101.401.163.900 ACCUM.DEPRECIATION BUILDINGS (7,903,327.60) (8,547,711.26)
101.401.167.900 ACCUM.DEPR. MACHINERY & EQUIPT (156,188,550.18) (167,769,171.92)
Accum. Depreciation (164,091,877.78) (176,316,883.18)
Other Assets
101.401.115.150 INTEREST RECEIVABLE 98,170.44 73,374.08
101.401.115.500 PREPAID INSURANCE 373,859.47 407,658.39
101.401.115.550 PREPAID W/C INSURANCE 10,878.83 (24,718.08)
101.401.115.575 PREPAID DEP REGULATORY FEES 34,104.14 34,270.83
101.401.115.600 PREPAID MAINTENANCE & EXPENSES 501,632.87 429,506.01
101.401.141.000 INVENTORY 361,568.58 405,012.14
101.401.141.100 UNUSED POSTAGE 20,424.82 21,758.02
Other Assets 1,400,639.15 1,346,861.39
Deferred Outflows
101.401.158.201 Deferred Outflow of Resources 2,091,917.13 1,861,655.52
4
02/23/2022 09:47 AM 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 01/31/2021 01/31/2022
*** Assets ***
Deferred Outflows 2,091,917.13 1,861,655.52
Total Assets 385,955,371.37 408,274,557.26
*** Liabilities ***
Liabilities-ST
101.401.202.000 ACCOUNTS PAYABLE 1,330,652.53 2,822,323.47
101.401.202.001 Sales Tax (3.50) 0.00
101.401.202.002 Retainage Payable 392,769.37 343,889.36
101.401.215.100 ACCRUED INTEREST 640,610.78 574,585.31
101.401.216.100 ACCRUED WAGES PAYABLE 402,107.48 479,297.86
101.401.216.200 ACCRUED SICK, VACATION PAYABLE 378,105.06 413,401.64
101.401.217.100 EMPLOYEE FIT,FICA,MEDICARE W/H 59,686.24 68,291.54
101.401.217.200 FLORIDA UNEMPLOYMENT/ABANDONED PROP 21,227.75 17,599.36
101.401.217.300 Employee Fund Withheld 2,601.65 2,122.78
101.401.217.500 ACCRUED PENSION DUE 78,021.26 89,269.96
101.401.217.600 ACCRUED W/C INS. DUE 19,271.26 22,049.68
101.401.218.100 MISC W/H (63.66) (114.22)
101.401.218.200 DEFERRED COMP LOAN 0.00 (78.02)
101.401.218.250 LIFE INSURANCE (118.26) (101.28)
101.401.218.703 HMO/PPO 936.10 (13,409.25)
101.401.218.705 DENTAL (202.52) 20.14
101.401.218.706 VISION (14.23) (162.67)
101.401.218.707 ANCILLARY 79.27 2,908.57
101.401.218.900 ACCRUED ELECTRIC EXPENSE DUE 106,687.98 97,007.93
101.401.220.100 BOND DEPOSITS 83,911.43 85,745.78
101.401.220.150 CLEANING WATER DEPOSITS 106,357.80 107,649.59
101.401.220.175 W&S CUSTOMER DEPOSITS 3,413,699.47 3,511,787.06
101.401.220.180 DUE TO LEND A HELPING HAND 4,041.51 1,134.69
101.401.220.185 Refundable Development Agreements 2,654.00 3,305.58
101.401.223.100 DEFERRED REVENUES WATER 83,895.87 88,371.72
101.401.223.200 DEFERRED REVENUE SEWER 173,347.16 182,802.96
101.401.223.300 Deferred Reuse Revenue 30,368.07 33,852.13
101.401.229.200 JAX PUBLIC SERV.TAX COLLECTED 0.00 503.78
101.401.229.201 Keystone Public Service Tax 11.67 (51.68)
101.401.232.700 CURRENT BOND PRINCIPAL DUE 6,884,979.88 7,035,129.20
Liabilities-ST 14,215,621.42 15,969,132.97
Liabilities-LT (over 1 year)
101.401.232.569 2012 BBVA Compass Loan 4,510,637.00 3,293,841.00
101.401.232.570 Financing Lease 20,584.96 0.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 12,317,202.92 11,704,626.36
101.401.232.573 Dell Financing Lease 704,022.66 446,495.33
101.401.232.574 Suntrust 2019 Loan & Refinance 46,880,000.00 44,035,000.00
101.401.232.586 2014 DEP Payable 867,754.10 770,596.47
101.401.232.600 CONTRA CURRENT BOND PRINCIPAL (6,884,979.88) (7,035,129.20)
Liabilities-LT (over 1 year) 95,310,863.76 88,180,384.96
Total Liabilities 109,526,485.18 104,149,517.93
*** Fund Balance ***
Unassigned
101.401.272.000 RETAINED EARNINGS-UNRESERVED 50,926,382.11 53,823,792.64
Unassigned 50,926,382.11 53,823,792.64
Investment In Capital Assets
101.401.240.000 AWS CIAC 3,888,498.78 6,216,109.68
101.401.240.100 SJRWMD Black Creek CIAC 0.00 224,241.55
101.401.254.350 WATER CAPACITY CHARGES 9,053,483.69 10,760,674.22
5
02/23/2022 09:47 AM 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 01/31/2021 01/31/2022
*** Fund Balance ***
101.401.254.351 FIRE CAPACITY CHARGES 1,818,143.97 1,919,533.50
101.401.254.352 WATER TAP IN CHARGE 2,163,057.52 2,259,539.99
101.401.254.353 WATER CONTRIBUTED ASSETS 47,170,918.47 50,326,164.48
101.401.254.354 WATER MAIN EXTENSION CHARGE 2,537,057.90 2,834,566.39
101.401.254.355 DEBT SERVICE CHARGE 583,064.33 1,028,980.06
101.401.254.360 SEWER CAPACITY CHARGES 38,336,299.94 44,841,796.71
101.401.254.361 GRANTS 21,978,066.17 23,151,500.22
101.401.254.362 SEWER TAP IN CHARGE 2,321,887.04 2,452,084.64
101.401.254.363 SEWER CONTRIBUTED ASSETS 91,247,255.13 98,819,389.04
101.401.254.364 SEWER MAIN EXTENSION CHARGE 3,668,246.97 4,247,797.87
Investment In Capital Assets 224,765,979.91 249,082,378.35
Total Fund Balance 275,692,362.02 302,906,170.99
Beginning Fund Balance 270,357,546.96 293,106,326.89
Net of Revenues VS Expenditures 736,524.17 1,218,868.34
Fund Balance Adjustments 5,334,815.06 9,799,844.10
Ending Fund Balance 276,428,886.19 304,125,039.33
Total Liabilities And Fund Balance 385,955,371.37 408,274,557.26
t0
02/23/2022 09:48 AM REVENUE AND EXPENDITURE REPORT FOR CLAY COUNTY UTILITIES Page: 1/1
User: kosborne
DB: CCUA PERIOD ENDING 01/31/2022
YTD BALANCE YTD BALANCE
GL NUMBER DESCRIPTION 01/31/2021 01/31/2022
Fund 101 - GENERAL FUND
WATER REVENUES 6,292,905.36 7,316,942.44
SEWER REVENUES 9,199,907.04 9,727,208.57
MISCELLANEOUS REVENUES 489,462.17 570,809.94
INTEREST UNRESTRICTED 159,872.25 192,238.96
INTEREST RESTRICTED 62,717.75 34.03
SALE OF ASSETS 1,705.30 0.00
CONSTRUCTION INCOME 59,912.31 16,273.72
TOTAL REVENUES 16,266,482.18 17,823,507.66
BAD DEBT (1,770.69) (5,514.30)
COMMUNICATION 112,608.46 123,424.01
DUE IN LIEU OF TAXES 697,175.14 766,986.80
ELECTRIC & FUEL EXPENSES 741,350.05 806,768.88
MISCELLANEOUS EXPENSES 36,907.07 58,335.61
PROPERTY & LIABILITY INSURANCE 264,296.93 292,674.01
PROFESSIONAL SERVICES 183,400.49 674,397.50
SLUDGE TREATMENT & DISPOSAL 666,501.43 713,272.43
SUBCONTRACTORS 875,808.49 667,138.63
SUPPLIES 1,548,299.94 1,529,587.17
TRANSPORTATION 187,153.87 184,271.27
WAGES & RELATED EXPENSES 5,078,837.07 5,554,937.55
DEPRECIATION 4,191,029.70 4,388,691.21
INTEREST EXPENSE 844,835.57 769,326.92
CONSTRUCTION EXPENSE 103,524.49 80,341.63
TOTAL EXPENDITURES 15,529,958.01 16,604,639.32
Fund 101 - GENERAL FUND:
TOTAL REVENUES 16,266,482.18 17,823,507.66
TOTAL EXPENDITURES 15,529,958.01 16,604,639.32
NET OF REVENUES & EXPENDITURES 736,524.17 1,218,868.34
TOTAL REVENUES - ALL FUNDS 16,266,482.18 17,823,507.66
TOTAL EXPENDITURES - ALL FUNDS 15,529,958.01 16,604,639.32
NET OF REVENUES & EXPENDITURES 736,524.17 1,218,868.34
7
CLAY COUNTY UTILITY AUTHORITY
STATEMENTS OF CASH FLOWS
FOR THE FOUR MONTHS ENDED JANUARY 31,2021 AND 2022
January 31,2021 January 31,2022
Cash flows from operating activities $ 3,984,145 $ 7,333,974
Net cash provided by operating activities 3,984,145 7,333,974
Cash flows from capital and related financing activities
Proceeds from issuance of bonds and loans - -
Principal paid on long-term debt (3,231,474) (3,292,236)
Interest paid on long-term debt (1,085,104) (1,014,723)
Payments to acquire and construct plant property (3,384,246) (9,385,718)
Capital contributions 2,383,742 4,311,692
Grants 222,743 40,649
Net cash used in capital and related financing activities (5,094,340) (9,340,336)
Cash flows from investing activities
Purchases of investments (6,509,562) (208,089)
Sales of investments 6,151,250 -
Interest income 222,590 192,273
Net cash provided by investing activities (135,722) (15,816)
Net increase(decrease)in cash and cash equivalents (1,245,917) (2,022,178)
Cash and cash equivalents,beginning of period 40,356,878 41,874,593
Cash and cash equivalents,end of period $ 39,110,961 $ 39,852,415
Reconciliation of operating income to net cash provided by operating activities
Cash flows from operating activities
Operating income $ 1,357,064 $ 1,795,922
Adjustments to reconcile operating income to net
t0 cash provided by operating activities:
Depreciation expense 4,217,232 4,409,577
Changes in assets and liabilities
Decrease(Increase)in accounts receivable (201,357) 753,235
Decrease(Increase)in prepaid items and inventory (380,812) (395,403)
Decrease(Increase)in notes/interest receivable 148,443 23,074
Increase(Decrease)in accounts payable (1,011,152) 882,233
Increase(Decrease)in accrued expenses (43,958) 86,407
Increase(Decrease)in unearned revenue (143,009) (248,358)
Increase(Decrease)in customer deposits 41,692 27,287
Total adjustments 2,627,080 5,538,052
Net cash provided by operating activities $ 3,984,145 $ 7,333,974
Supplemental schedule of noncash investing,capital,and financing activities
Utility plant property contributed by developers $ 2,728,330 $ 5,447,503
8
Cumulative Cash Flow
$100,000,000
$90,000,000 '
I I
$80,000,000
$70,000,000
$60,000,000
$50,000,000
$40,000,000
$30,000,000
tO
$20,000,000
$10,000,000 -
$0 — — — — I—"1—,7— - —
,LO .LO `,LO ,.LO �O s\,10 ,,LO ` ‘'y �,L'y c.L'y �.L'y °.L'y .L'y e ti ,.L'y `ti �ti
�e� I Q9 �a �� \ PJ c e� p( �o Qe 4a <<e 4.'a QQ �a �J P� cDeQ p� �e Qe �a
Cash v Investments
9
CLAY COUNTY UTILITY AUTHORITY
CASH AND CASH EQUIVALENTS REPORT
As of January 31, 2022
BB&T Ameris SBA CD/CDARS Total
Lend A Helping Hand Fund $1,135 $1,135
Operating Accounts ** $12,868,488 $12,868,488
FSA Account $26,875 $26,875
Emergency Accounts $37,659 $37,659
Petty Cash $1,167 $1,167
Total Operating Funds $12,934,189 $12,934,189
Public Funds Now:
Water Plant Connection Fund $508,316 * $508,316 R
Water Line Connection Fund $65,076 * $65,076 R
Sewer Plant Connection Fund $5,916,499 * $5,916,499 R
Sewer Lines Connection Fund $721,072 * $721,072 R
Alternative Water Supply Fund $2,865,610 * $2,865,610 R
Renewal&Replacement Fund $5,047,399 * $5,047,399 R
Debt Stabilization and Reserve Account_Unrestricted $1,030,850 * - - $1,030,850
Surplus Fund $1,358,936 $961,978 $104,999 $52,261,698 $54,687,610
Available For Construction $17,513,757 $961,978 $104,999 $52,261,698 $70,842,432
Debt Service Sinking Funds:
2007A Bond Sinking Fund $3,396,308 * $3,396,308 R
DEP Loan Debt Service Sinking Acct $34,128 * $34,128 R
BBVA Compass Loan Sinking Funds $364,243 * $364,243 R
2018 Bond Sinking Fund $417,981 * $417,981 R
Debt Stabilization and Reserve Account_Restricted
Letter of Credit_Financial Responsible Officer $102,317 $102,317
Customer Deposits&Self Insurance Fund
Customer Deposits - * $3,496,380 $3,496,380
Self Insurance Fund_Sewage Backups *
Health Insurance - * $500,000 $500,000
Unemployment * $25,000 $25,000
TOTAL Funds $4,314,977 $4,021,380 - - $8,336,357
TOTAL CASH&CASH EQUIVALENTS $34,764,058 $4,983,358 $104,999 $52,261,698 $92,114,113
Certificates of Deposit
Maturity Date Balance APY
Scott&Stringfellow Various $52,261,698 Various
$52,261,698
* BB&T Public Funds Money Checking Accounts $20,367,482 0.25%
BB&T Public Funds Money Checking Accounts_Eamings Credit waives bank fees $12,868,488 0.25%
Ameris Public Funds Money Checking Accounts $4,983,358 0.30%
SBA $104,999 0.09%
Operating Account has significant Surplus Funds due to Earnings Credit offsetting fees greater than interest
Construction Balance $70,842,432
Operating Cash $10,868,488
Available Construction Balance: $81,710,919
"R"indicates fund is Restricted by Bond Resolution,Enabling Legislation or Board Resolution.
Printed 2/23/2022 Section B
CLAY COUNTY UTILITY AUTHORITY
BUDGET REPORTS
FISCAL YEAR 2021 /2022
to
Section C
n
02/23/2022 REVENUE AND EXPENDITURE REPORT FOR CLAY COUNTY UTILITIES
PERIOD ENDING 01/31/2022
OPERATING BUDGET REPORT
2021-22 YTD BALANCE AVAILABLE %BDGT
GL NUMBER DESCRIPTION AMENDED BUDGET 01/31/2022 BALANCE USED
OPERATING REVENUES
Water Revenues
Net Water Base Charges 7,870,135.00 2,644,396.77 5,225,738.23 33.60%
Net Water Use Charges 9,778,356.00 3,031,403.81 6,746,952.19 31.00%
Net Reuse Water Base Charges 2,743,539.00 1,001,152.69 1,742,386.31 36.49%
Net Reuse Water Usage Charges 2,135,303.00 639,989.17 1,495,313.83 29.97%
Net Water Revenues 22,527,333.00 7,316,942.44 15,210,390.56 32.48%
Sewage Revenues
Net Sewer Base Charges 15,923,690.00 5,428,466.87 10,495,223.13 34.09%
Net Sewer Use Charges 13,994,637.00 4,298,741.70 9,695,895.30 30.72%
Net Sewage Revenues 29,918,327.00 9,727,208.57 20,191,118.43 32.51%
Other Revenues
Net Miscellaneous 1,587,083.00 570,809.94 1,016,273.06 35.97%
Net Other Revenues 1,587,083.00 570,809.94 1,016,273.06 35.97%
Net OPERATING REVENUES 54,032,743.00 17,614,960.95 36,417,782.05 32.60%
INTEREST INCOME
Net Unrestricted 784,689.00 192,238.96 592,450.04 24.50%
Net Restricted 2,666.00 34.03 2,631.97 1.28%
Net INTEREST INCOME 787,355.00 192,272.99 595,082.01 24.42%
OPERATING EXPENSES
Net Bad Debt Expenses 5,000.00 (5,514.30) 10,514.30 -110.29%
Net Wage Related Expenses 4,829,171.19 1,635,239.03 3,193,932.16 33.86%
Net Communication Expenses 485,154.00 123,424.01 361,729.99 25.44%
Net Due in Lieu of Taxes 2,360,055.00 766,986.80 1,593,068.20 32.50%
Net Electric&Fuel Expenses 2,482,468.00 806,768.88 1,675,699.12 32.50%
Net Miscellaneous Expenses 439,234.00 58,335.61 380,898.39 13.28%
Net Property&Liability Insurance 859,395.00 292,674.01 566,720.99 34.06%
Net Professional Services 1,896,599.00 713,091.70 1,183,507.30 37.60%
Net Sludge Treatment&Disposal 1,924,160.00 713,272.43 1,210,887.57 37.07%
Net Subcontractors 3,633,616.00 650,051.23 2,983,564.77 17.89%
Net Supplies 5,702,144.00 1,529,587.17 4,172,556.83 26.82%
Net Transportation Expenses 502,451.00 184,271.27 318,179.73 36.67%
Net Wage Expense 12,321,959.87 3,898,091.72 8,423,868.15 31.64%
Net OPERATING EXPENSES 37,441,407.06 11,366,279.56 26,075,127.50 30.36%
NON-OPERATING EXPENSES
Net Depreciation Expense 12,504,881.00 4,388,691.21 8,116,189.79 35.10%
Net Interest Expense 2,074,592.00 769,326.92 1,305,265.08 37.08%
Net Loss(Gain)on Sale of Assets 0.00 0.00 0.00 100.00%
Net NON-OPERATING EXPENSES 14,579,473.00 5,158,018.13 9,421,454.87 35.38%
Net CONSTRUCTION EXPENSES 624,519.85 80,341.63 544,178.22 12.86%
Net CONSTRUCTION INCOME 624,519.00 16,273.72 608,245.28 2.61%
Net CONTINGENCY 1,186,170.00 0.00 1,186,170.00 0.00%
TOTAL REVENUES-ALL FUNDS 55,444,617.00 17,823,507.66 37,621,109.34 32.15%
TOTAL EXPENDITURES-ALL FUNDS 53,831,569.91 16,604,639.32 37,226,930.59 30.85%
NET OF REVENUES&EXPENDITURES 1,613,047.09 1,218,868.34 394,178.75 75.56%
12
02/23/2022 10:57 AM EXPENDITURE REPORT FOR CLAY COUNTY UTILITIES Page: 1/1
User: kosborne
DB: CCUA PERIOD ENDING 01/31/2022
OPERATING EXPENSE BUDGET REPORT
2021-22 YTD BALANCE AVAILABLE % BDGT
GL NUMBER DESCRIPTION AMENDED BUDGET 01/31/2022 BALANCE USED
Net WAGES & TEMP. LABOR 12,724,148.87 3,938,150.92 8,785,997.95 30.95
Net CAPITALIZED WAGES 241,797.65 5,191.94 236,605.71 2.15
Net HEALTH & LIFE INSURANCE 2,489,281.92 828,629.47 1,660,652.45 33.29
Net PENSION & BENEFITS 1,298,549.45 451,861.34 846,688.11 34.80
Net PAYROLL TAXES 921,385.72 285,064.23 636,321.49 30.94
Net W/C INSURANCE 236,296.30 75,934.20 160,362.10 32.14
Net PROPERTY & LIABILITY INSURANCE 914,250.00 311,355.32 602,894.68 34.06
Net TRANSPORTATION 527,951.00 193,424.53 334,526.47 36.64
Net RENTAL EXPENSE 43,194.00 10,480.37 32,713.63 24.26
Net COMMUNICATION EXPENSES 485,154.00 123,424.01 361,729.99 25.44
Net ELECTRIC & FUEL WATER PLANTS 734,000.00 223,789.47 510,210.53 30.49
Net ELECTRIC & FUEL LIFT STATIONS 400,000.00 127,581.94 272,418.06 31.90
Net ELECTRIC & FUEL SEWAGE PLANTS 1,310,865.00 443,667.50 867,197.50 33.85
Net ELECTRIC AT OFFICE 37,603.00 11,729.97 25,873.03 31.19
Net CHEMICALS FOR WATER 185,000.00 50,562.71 134,437.29 27.33
Net CHEMICALS FOR SEWAGE 821,203.00 227,145.26 594,057.74 27.66
Net SUPPLIES FOR WATER 1,775,024.00 340,171.53 1,434,852.47 19.16
Net SUPPLIES FOR SEWAGE 1,258,076.00 427,268.87 830,807.13 33.96
Net OFFICE SUPPLIES 1,668,741.00 493,168.39 1,175,572.61 29.55
Net ENGINEERING EXPENSES 926,900.00 523,667.44 403,232.56 56.50
Net LEGAL EXPENSES 545,535.00 129,374.75 416,160.25 23.72
Net AUDIT EXPENSES 33,500.00 23,500.00 10,000.00 70.15
Net SUBCONTRACTORS-WATER 1,295,475.00 165,732.13 1,129,742.87 12.79
Net SUBCONTRACTORS-SEWAGE 717,863.00 180,789.39 537,073.61 25.18
Net SUBCONTRACTORS-GENERAL 1,630,178.00 311,469.52 1,318,708.48 19.11
Net SLUDGE TREATMENT & DISPOSAL 1,924,160.00 713,272.43 1,210,887.57 37.07
Net BAD DEBT EXPENSE 5,000.00 (5,514.30) 10,514.30 (110.29)
Net MISCELLANEOUS 396,040.00 47,855.24 348,184.76 12.08
Net DUE IN LIEU OF TAXES 2,360,055.00 766,986.80 1,593,068.20 32.50
Net CONTINGENCY 1,240,485.00 0.00 1,240,485.00 0.00
TOTAL EXPENDITURES - ALL FUNDS 39,147,711.91 11,425,735.37 27,721,976.54 29.19
13
CLAY COUNTY UTILITY
AUTHORITY CIAC REPORTS
to FISCAL YEAR 2021 /2022
Section D
14
02/23/2022 10:58 AM TRIAL BALANCE REPORT FOR CLAY COUNTY UTILITIES Page: 1/2
User: kosborne
DB: CCUA PERIOD ENDING 01/31/2022
ACTIVITY FOR
2021-22 BEG. BALANCE MONTH YEAR-TO-DATE END BALANCE
GL NUMBER DESCRIPTION AMENDED BUDGET 10/01/2021 01/31/2022 THRU 01/31/22 01/31/2022
Fund 101 - GENERAL FUND
Fund Equity
WATER CAPACITY
101.401.254.350 WATER CAPACITY CHARGES 10,148,402.33 19,431.36 612,271.89 10,760,674.22
WATER CAPACITY 10,148,402.33 19,431.36 612,271.89 10,760,674.22
SEWER CAPACITY
101.401.254.360 SEWER CAPACITY CHARGES 42,567,255.88 262,988.34 2,274,540.83 44,841,796.71
101.401.254.361 GRANTS 23,110,851.53 0.00 40,648.69 23,151,500.22
SEWER CAPACITY 65,678,107.41 262,988.34 2,315,189.52 67,993,296.93
AWS
101.401.240.000 AWS CIAO 5,389,271.45 74,570.49 826,838.23 6,216,109.68
AWS 5,389,271.45 74,570.49 826,838.23 6,216,109.68
SJRWMD BLACK CREEK
101.401.240.100 SJRWMD Black Creek CIAC 0.00 54,727.67 224,241.55 224,241.55
SJRWMD BLACK CREEK 0.00 54,727.67 224,241.55 224,241.55
WATER MAIN
101.401.254.354 WATER MAIN EXTENSION CHARGE 2,781,061.91 8,686.53 53,504.48 2,834,566.39
WATER MAIN 2,781,061.91 8,686.53 53,504.48 2,834,566.39
SEWER MAIN
101.401.254.364 SEWER MAIN EXTENSION CHARGE 4,147,513.64 11,036.57 100,284.23 4,247,797.87
SEWER MAIN 4,147,513.64 11,036.57 100,284.23 4,247,797.87
FIRE
101.401.254.351 FIRE CAPACITY CHARGES 1,903,723.50 0.00 15,810.00 1,919,533.50
FIRE 1,903,723.50 0.00 15,810.00 1,919,533.50
WATER TAP IN
101.401.254.352 WATER TAP IN CHARGE 2,226,386.48 16,315.06 33,153.51 2,259,539.99
WATER TAP IN 2,226,386.48 16,315.06 33,153.51 2,259,539.99
SEWER TAP IN
101.401.254.362 SEWER TAP IN CHARGE 2,414,030.19 8,744.51 38,054.45 2,452,084.64
SEWER TAP IN 2,414,030.19 8,744.51 38,054.45 2,452,084.64
WATER CONT PROP
101.401.254.353 WATER CONTRIBUTED ASSETS 48,671,992.34 0.00 1,654,172.14 50,326,164.48
WATER CONT PROP 48,671,992.34 0.00 1,654,172.14 50,326,164.48
SEWER CONT PROP
101.401.254.363 SEWER CONTRIBUTED ASSETS 95,026,058.13 0.00 3,793,330.91 98,819,389.04
SEWER CONT PROP 95,026,058.13 0.00 3,793,330.91 98,819,389.04
DEBT SERVICE
101.401.254.355 DEBT SERVICE CHARGE 895,986.87 5,367.83 132,993.19 1,028,980.06
15
02/23/2022 10:58 AM TRIAL BALANCE REPORT FOR CLAY COUNTY UTILITIES Page: 2/2
User: kosborne
DB: CCUA PERIOD ENDING 01/31/2022
ACTIVITY FOR
2021-22 BEG. BALANCE MONTH YEAR-TO-DATE END BALANCE
GL NUMBER DESCRIPTION AMENDED BUDGET 10/01/2021 01/31/2022 THRU 01/31/22 01/31/2022
Fund 101 - GENERAL FUND
Fund Equity
DEBT SERVICE 895,986.87 5,367.83 132,993.19 1,028,980.06
TOTAL FUND EQUITY 239,282,534.25 461,868.36 9,799,844.10 249,082,378.35
Total Fund 101 - GENERAL FUND
TOTAL ASSETS 0.00 0.00 0.00 0.00
BEG. FUND BALANCE 293,106,326.89 293,106,326.89
+ NET OF REVENUES & EXPENDITURES
+ FUND BALANCE ADJUSTMENTS 10,377,127.92 10,377,127.92
= ENDING FUND BALANCE 239,282,534.25 461,868.36 9,799,844.10 249,082,378.35
+ LIABILITIES 0.00 0.00 0.00 0.00
= TOTAL LIABILITIES AND FUND BALANCE 239,282,534.25 461,868.36 9,799,844.10 249,082,378.35
OUT OF BALANCE 0.00 (461,868.36) (9,799,844.10) (249,082,378.35)
16
CLAY COUNTY UTILITY AUTHORITY
2021/2022 Alternative Water Supply Surcharges
Beginning October November December January February March April May June July August September Balance
Established 10/1/2015 Balance 2021 2021 2021 2022 2022 2022 2022 2022 2022 2022 2022 2022 9/30/2022
Expenditures:
Job 991 FCOB Stormwater Harvesting Pilot Project 752,127.03 752,127.03
Stormwater Harvesting Study 49,842.66 49,842.66
Job 00119WP Aquifer Storage&Recovery(ASR) 1,554,488.01 0.00 25.593.03 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 327,302.47 34,787.31 111,425.02 30,334.51 43,865.61 547,714.92
I
New Development: -
Total Expenditures 3,078,793.53 34,787.31 137,018.05 30,334.51 43,865.61 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3,324,799.01
Existing Customers:
Revenue:
Surcharge Fund(Existing Customers) 3,438,711.41 53,863.44 55,443.36 55,538.56 55,748.00 3,659,304.77
Connection Charge Fund(Growth) 1,836,928.17 21,664.31 492,122.50 70,217.45 26,038.59 2,446,971.02
Interest Income 40,259.54 5.84 1.36 1.25 40,267.99
Total Revenue 5,315,899.12 75,533.59 547,565.86 125,757.37 81,787.84 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6,146,543.78
Balance 2,237,105.59 40,746.28 410,547.81 95,422.86 37,922.23 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2,821,744.77
Cash Balance 2,865,610.38
Done in following Month:
Less Construction Costs transferred after month close (43,865.61)
J/E-Adjustment True Up for Move-Ins/Move-Outs
J/E-Interfund Transfer
2,821,744.77
Page D-la
17
CLAY COUNTY UTILITY AUTHORITY
CAPITAL PROJECT BUDGET
to REPORT
FISCAL YEAR 2021 /2022
Section E
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 Balances and Year Job Costs
Job Description Job Number Budget Adopted Budget Budgets Amendments 01/31/22 To Fund Amendments 2021 /2022
Departmental Capital 100 1,122,764.59 1,052,400.00 2,175,164.59 753,680.11 1,421,484.48 2,175,164.59
Upgrade Lift station 9-Meadowbrook 755 110,000.00 110,000.00 6,353.84 103,646.16 110,000.00
CCUA Main Office Paving and Stripping Rehab 839 105,000.00 105,000.00 1,500.00 103,500.00 105,000.00
Knight Boxx/Old Jennings Force Main Extension 967 100,000.00 100,000.00 9,114.95 90,885.05 100,000.00
LS 40 Orange Park Country Club Rehab 1052 60,000.00 60,000.00 31,496.60 28,503.40 60,000.00
Lucy Branch Maintenance Building Repairs and Renovations 02018RR 120,000.00 120,000.00 10,739.84 109,260.16 120,000.00
Holly Ridge Dr.Force Main Installation 02119SL 280,000.00 280,000.00 119.20 279,880.80 280,000.00
Woodland Drive Force Main Installation 02219SL 239,000.00 239,000.00 0.00 239,000.00 239,000.00
Rehab SP WW Clarifer#1/under drain 1-2 02519RR 100,000.00 900,000.00 1,000,000.00 64,176.20 935,823.80 1,000,000.00
CL2 Storage Tanks-Multiple WTPS 02619WP 50,000.00 50,000.00 100,000.00 29,848.11 70,151.89 100,000.00
Task Order No.33-Gravity Rehab in Bellair 20020RR 952,800.54 952,800.54 952,800.54 0.00 952,800.54
Ridgecrest WTP-Replace Softstart&Crossline Starters with VFD's 20021RR 985,000.00 568,016.26 1,553,016.26 145,137.74 1,407,878.52 1,553,016.26
New Lift Station Generators: 172, 165, 151, 142, 163, 124 21002RR 400,000.00 400,000.00 280,577.92 119,422.08 400,000.00
Keystone Club Estates WTP Well No. 1 &@ Well and Pump Evalaution 21008RR 98,263.96 98,263.96 68,838.04 29,425.92 98,263.96
Fleming Island Reg.WWTP-2nd BCR Plant,Two Tanks 21010RR 200,000.00 5,000,000.00 5,200,000.00 1,792,053.45 3,407,946.55 5,200,000.00
Fleming WRF Clarifier No. 1 Upgrade 21014RR 50,000.00 1,158,000.00 1,208,000.00 0.00 1,208,000.00 1,208,000.00
Long Bay Rd.Water and Reclaimed Interconnect(Pine Ridge) 21015RR 60,000.00 60,000.00 59,817.29 182.71 60,000.00
Lift Station#2-Upgrade 21016RR 700,000.00 21,822.44 678,177.56 5 700,000.00
Ridgecrest WTP GST#2 Repair 21017RR 108,500.00 120,750.00 (12,250.00) 10 108,500.00
Wastewater Extension to 1045 Live Ok Ln. 21018RR 27,000.00 27,000.00 25,540.58 1,459.42 27,000.00
Lift Station#3 Foxbay Upgrade 21016RR 750,000.00 8,302.50 741,697.50 6 750,000.00
Coopergate-TO#7 LS 56&MH 1 21024RR 17,023.15 17,023.15 0.00 3 17,023.15
TO#36-Sandalwood,Fireside&Walgreen 21025RR 23,473.94 24,232.41 (758.47) 4 23,473.94
Meadowbrook Well Rehab 21028RR 70,000.00 630,000.00 700,000.00 0.00 700,000.00 700,000.00
Meadowbrook WTP Upgrades-(GST#3 repair,Transfer switch,GST#2 roof repair,Aerator r 21029RR 72,000.00 1,000,000.00 1,072,000.00 4,973.80 1,067,026.20 1,072,000.00
Insituform R&R-Task Order 37 Rolling Hills&Tanglewood lA CIPP Lining 21031RR 0.00 1,000,000.00 1,000,000.00 0.00 1,000,000.00 1,000,000.00
Wastewater Extension to 3000 Pony Lane 21032RR 0.00 0.00 18,000.00 388.08 17,611.92 7 18,000.00
Dunster Court Water Main Replacement 22001RR 30,000.00 0.00 30,000.00 8 30,000.00
Sharone Court Water Main Replacement 22002RR 25,000.00 0.00 25,000.00 9 25,000.00
CR 218 widening from Pine Tree Lane to Cosmos Not Started 425,000.00 425,000.00 425,000.00 425,000.00
CR 220 widening Baxley to Henley Rd Not Started 0.00 575,000.00 575,000.00 575,000.00 575,000.00
CR 220 widening from Henley to Knightbox Not Started 0.00 420,000.00 420,000.00 420,000.00 420,000.00
ERP Software Replacement Not Started 0.00 1,400,000.00 1,400,000.00 1,400,000.00 1,400,000.00
Fleming Oaks WTP Electrical Upgrades&Hydro Tank Not Started 0.00 0.00 0.00 0.00
Fleming Oaks WTP:Replace roof on the pump,bleach,and generator buildings Not Started 30,000.00 30,000.00 30,000.00 30,000.00
Keystone Heights-Brooklyn Bay Road Water Main Rehabilitation Not Started 0.00 9,000.00 9,000.00 9,000.00 9,000.00
Keystone Heights-Lakeside Street/Hilltop Street Water Main Rehabilitation Not Started 0.00 0.00 0.00 0.00
Kingsley Cove WTP Well Rehab Not Started 0.00 0.00 0.00 0.00
Lake Asbury WM Improvements(602 Lake Asbury Road to Aldersgate Drive) Not Started 0.00 0.00 0.00 0.00
Lift Station SCADA System Not Started 0.00 0.00 0.00 0.00
Miller St.WWTP Upgrades(Complete Paving of Loop Road,Refurbish Influent Structure(Ext Not Started 0.00 0.00 0.00 0.00
Pace Island WTP:Electrical&Hydro Tank Upgrades(Replace Hydrotank Tank#1 and Electric Not Started 0.00 0.00 0.00 0.00
19
X:\Finance\Controllers Folder\Monthly Financial\Monthly Construction Reports\2021-2022\CIP_2022_January.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 Balances and Year Job Costs
Job Description Job Number Budget Adopted Budget Budgets Amendments 01/31/22 To Fund Amendments 2021 /2022
Ravines Off-Site Mains-Middleburg W&S Extensions Not Started 1,238,000.00 1,238,000.00 1,238,000.00 1,238,000.00
Ridaught WTP-Phase I GST Upgrades Not Started 50,000.00 1,100,000.00 1,150,000.00 1,150,000.00 1,150,000.00
Ridaught WWTP Upgrades(Install Micro-screen,Grit Removal Equipment,and Influent,Reha Not Started 103,936.00 1,663,706.00 1,767,642.00 1,767,642.00 1,767,642.00
Spencers WTP-Ground Storage&High Service Pump Not Started 0.00 0.00 0.00 0.00
Sandridge Road widening from Henley to CR 209 Not Started 0.00 150,000.00 150,000.00 150,000.00 150,000.00
Rehab PS 4&PS 62. Manifold PS 67 if feasible Not Started 0.00 200,000.00 200,000.00 200,000.00 200,000.00
Server Lifecycle Replacement Not Started 0.00 0.00 0.00 0.00
Upgrade Lift Stations 11,41,69,51 Not Started 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00
Upgrade Lift Station 98 Not Started 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
WRF SCADA System Not Started 0.00 0.00 0.00 0.00
Water SCADA System Not Started 0.00 0.00 0.00 0.00
Wesley RD WM Improvements(Branscomb Road to Arthur Moore Drive) Not Started 0.00 0.00 0.00 0.00
WTP Ground Storage Tanks:add Handrails Not Started 0.00 576,000.00 576,000.00 576,000.00 576,000.00
Water Plant Meters Retrofits Not Started 0.00 0.00 0.00 0.00 0.00
Ridaught/Greenwood/Lucy Branch/Orange Park South WTP Consolidation and Upgrades Not Started 0.00 250,000.00 250,000.00 250,000.00 250,000.00
SYSTEM EXPANSION
Meadow Lake WTP-New Ground Storage Tank and Electrical Service upgrade 00983WP 363,093.00 1,834,953.00 2,198,046.00 353,719.02 1,844,326.98 2,198,046.00
Peters Creek WTP-Land Costs 01118RR 75,000.00 75,000.00 14,425.70 60,574.30 75,000.00
Henley Road 12"WM Loop-Sandridge to Small Lake 01119WL 106,000.00 106,000.00 11,241.94 94,758.06 106,000.00
North Middleburg Water&Sewer Extension and Interconnection(Water Interconnect,Forcems 02419WL 169,191.77 1,700,000.00 1,869,191.77 277,557.15 1,591,634.62 1,869,191.77
Saratoga Springs WTP-Phase I 03018WP 1,211,426.55 1,137,327.00 2,348,753.55 1,696,689.69 652,063.86 2,348,753.55
Saratoga Springs RWP-Phase I 03118RP 1,160,831.00 446,202.00 1,607,033.00 565,839.53 1,041,193.47 1,607,033.00
FCOB Utility Crossings 03218WL 3,900,000.00 3,900,000.00 2,214,898.12 1,685,101.88 3,900,000.00
Middleburg Water and Sewer Relocations 03319WL 602,241.10 602,241.10 607,134.44 (4,893.34) 602,241.10
Saratoga Springs Offsite Main Extensions 03419WL 485,323.00 2,299,677.00 2,785,000.00 277,940.00 2,507,060.00 2,785,000.00
Mid Clay WWTP-Phase II Plant Expansion 20003SP 582,615.00 4,500,000.00 5,082,615.00 1,203,296.70 3,879,318.30 5,082,615.00
Fleming Island Reg.WWTP-#3 BTU Installation,Design 20004SP 2,149,000.00 4,371,000.00 6,520,000.00 5,360,777.58 1,159,222.42 6,520,000.00
Meadowbrook WTP Chlorine Room Roll-Up Door Addition 20006WP 50,000.00 50,000.00 27,679.08 22,320.92 50,000.00
Fleming Island WWTF Clarifier No.2 Evaluation and Repair 20007SP 140,000.00 140,000.00 110,444.57 29,555.43 140,000.00
2019-054 Doctors Lake Restoration Project 20011SL 236,340.52 175,000.00 411,340.52 635,640.20 (224,299.68) 411,340.52
Brannen Mill Extension-Challenger Center 20012WL 2,200,000.00 2,200,000.00 1,108,828.57 1,091,171.43 2,200,000.00
Peters Creek WRF-Phase II 20027SP 50,000.00 1,600,000.00 1,650,000.00 241,974.98 1,408,025.02 1,650,000.00
CCUA Storage Building and Site Improvements 21001AD 254,095.00 3,480,750.00 3,734,845.00 296,123.01 3,438,721.99 3,734,845.00
Aquarius Concourse Relocation Utility Relocations 21004WL 2,852,544.14 2,852,544.14 46,252.18 2,806,291.96 2,852,544.14
Cross Creek-315 Cost Share&Easement 21005WL 420,000.00 420,000.00 514,807.55 (94,807.55) 420,000.00
Governor's Park WWTF Design and Build 21012SP 25,000.00 25,000.00 44,388.80 (19,388.80) 25,000.00
Swimming Penn Creek WM Interconnect 21020WL 2,000,000.00 2,000,000.00 0.00 2,000,000.00 2,000,000.00
Water and Wastewater Service to 7065 Artis Rd 21021WL 33,000.00 18,173.40 14,826.60 2 33,000.00
Ravines to Henly Road Water Main Extension 21023WL 2,640,000.00 2,640,000.00 90,914.10 2,549,085.90 2,640,000.00
Governor's Park WTP Design and Build 21026WP 2,400.00 975,000.00 977,400.00 I 29,091.75 948,308.25 977,400.00
20
X:\Finance\Controllers Folder\Monthly Financial\Monthly Construction Reports\2021-2022\CIP_2022_January.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 Balances and Year Job Costs
Job Description Job Number Budget Adopted Budget Budgets Amendments 01/31/22 To Fund Amendments 2021 /2022
Water Service Extension to 3173 Park Ave 21027WL 0.00 48,000.00 7,210.79 40,789.21 1 48,000.00
Peters Creek WTP 2nd GST&3rd Well 21030WP 100,000.00 875,000.00 975,000.00 0.00 975,000.00 975,000.00
Engineering Cost Allocation 9999999 0.00 128,850.37 (128,850.37) 0.00
Bradley Creek Crossing Cost Share Not Started 129,500.00 129,500.00 129,500.00 129,500.00
Bradley Creek Crossing-Cost Share Not Started 79,000.00 79,000.00 79,000.00 79,000.00
CCUA Administrative Building Phase I Not Started 0.00 214,907.00 214,907.00 214,907.00 214,907.00
Cost Share-Extension from Mayfield Annex to Blanding Not Started 37,800.00 37,800.00 37,800.00 37,800.00
CR218 Utility Main Extensions Not Started 2,500,000.00 2,500,000.00 2,500,000.00 2,500,000.00
Infill Projects Not Started 1,161,679.98 100,000.00 1,261,679.98 1,261,679.98 1,261,679.98
Keystone-Master Plan WM-Mossy Oaks to Geneva Lake Est. Not Started 900,000.00 900,000.00 900,000.00 900,000.00
Keystone Wastewater Treatment Plant-Phase II Construction Not Started 0.00 0.00 0.00 0.00
Mid-Clay&Oakleaf Reclaimed WP Upgrades(Install 3rd High Service Pump at each facility) Not Started 350,000.00 350,000.00 350,000.00 350,000.00
Old Jennings Rd-Estimated Cost Share on oversizing to Commercial stub Not Started 40,000.00 40,000.00 40,000.00 40,000.00
Peters Creek WWTP-Land Acquisition Not Started 0.00 0.00 0.00 0.00
Peters Creek Reclaimed Additions Not Started 0.00 0.00 0.00
Pier Station E/W WM Extension and Interconnect(State Road 16 and FCOB) Not Started 0.00 750,000.00 750,000.00 750,000.00 750,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 250,000.00 250,000.00 250,000.00 250,000.00
Pier Station WTP Expansion Not Started 0.00 0.00 0.00 0.00
Ravines to Henly Road Water Main Extension Not Started 0.00 1,400,000.00 1,400,000.00 1,400,000.00 1,400,000.00
Ravines WTP 2nd GST Not Started 0.00 0.00 0.00 0.00
Ridaught RWP-750K Ground Storage Tank Not Started 0.00 0.00 0.00 0.00
Ridaught RWP-Install 3rd High Service Pump 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 0.00 660,000.00 660,000.00 660,000.00 660,000.00
Ridaught/Greenwood/Lucy Branch/Orange Park South WTP Consolidation and Upgrades Not Started 0.00 50,000.00 50,000.00 50,000.00 50,000.00
Longbay Rd.Master Pump Station and Force Main Not Started 0.00 0.00 0.00 0.00
Village Park&Bradley Creek(Developer Agreement MU18/19-1) Not Started 258,078.00 258,078.00 258,078.00 258,078.00
ALTERNATIVE WATER SUPPLY
Aquifer Storage&Recovery(ASR)-Hydrogeologic Well Construction and Testing 00119WP 2,321,500.00 2,321,500.00 1,580,081.04 741,418.96 2,321,500.00
Potable Reuse Pilot Project 20022WL 429,261.99 185,000.00 614,261.99 547,714.92 66,547.07 614,261.99
2 MGD Potable Reuse Not Started
Other AWS(Stormwater,RIBs,Reclaimed Storage,etc) Not Started
Subtotals 38,030,686.14 44,706,938.26 82,737,624.40 1,752,997.09 22,440,981.97 62,049,639.52 84,490,621.49
Contingency 13,719,293.47 13,719,293.47 (1,752,997.09) 1(1-10) 11,966,296.38
TOTAL CAPITAL EXPENDITURES 96,456,917.87 1 96,456,917.87
Construction In Progress 21,687,301.86 Not Started 18,071,606.98
Completed Jobs 753,680.11 Started 78,385,310.89
22,440,981.97 96,456,917.87
21
X:\Finance\Controllers Folder\Monthly Financial\Monthly Construction Reports\2021-2022\CIP_2022_January.xlsx Page 3 of 3
CLAY COUNTY UTILITY AUTHORITY
OPERATING DETAIL BY MONTH
to FISCAL YEAR 2021 /2022
Section F
02/23/2022 10:59 AM REVENUE REPORT FOR CLAY COUNTY UTILITIES Page: 1/1
User: kosborne
DB: CCUA PERIOD ENDING 01/31/2022
OPERATING REVENUE BUDGET REPORT
ACTIVITY FOR
2021-22 MONTH YTD BALANCE % BDGT
GL NUMBER DESCRIPTION AMENDED BUDGET 01/31/2022 01/31/2022 USED
OPERATING REVENUES
Water Revenues
Water Base Charges
101.401.343.301 RESIDENTIAL WATER BASE CHARGE 6,379,316.00 545,491.79 2,164,755.88 33.93
101.401.343.303 GENERAL SERVICE WATER BASE 1,226,278.00 103,602.23 405,949.20 33.10
101.401.346.303 Commercial Potable Irrigation Base 264,541.00 18,560.88 73,691.69 27.86
Net Water Base Charges 7,870,135.00 667,654.90 2,644,396.77 32.48
Water Use Charges
101.401.344.303 Residential Water Usage Tier 1 3,485,504.00 250,658.07 1,171,650.12 33.61
101.401.344.304 Residential Water Usage Tier 2 2,060,486.00 144,190.32 638,192.73 30.97
101.401.344.305 Residential Water Usage Tier 3 864,211.00 50,390.28 255,005.09 29.51
101.401.344.306 Residential Water Usage Tier 4 1,007,439.00 48,125.75 272,046.55 27.00
101.401.345.305 Commercial Water Usage 1,787,785.00 109,162.75 540,190.29 30.22
101.401.346.306 Commercial Potable Irrigation Usage T 124,838.00 7,925.10 37,697.96 30.20
101.401.346.307 Commercial Potable Irrigation Usage T 199,467.00 8,913.43 48,095.39 24.11
101.401.346.308 Commercial Potable Irrigation Usage T 155,689.00 2,337.06 33,128.34 21.28
101.401.346.309 Commercial Potable Irrigation Usage T 92,937.00 3,145.83 35,397.34 38.09
Net Water Use Charges 9,778,356.00 624,848.59 3,031,403.81 32.48
Reuse Water Base Charges
101.401.343.601 Reuse Residential Base 2,486,808.00 229,877.14 917,001.86 36.87
101.401.343.602 Reuse Commercial Base 256,731.00 21,006.90 84,150.83 32.78
Net Reuse Water Base Charges 2,743,539.00 250,884.04 1,001,152.69 32.48
Reuse Water Usage Charges
101.401.347.403 Reuse Residential Usage Tier 1 807,652.00 55,082.46 262,509.72 32.50
101.401.347.404 Reuse Residential Usage Tier 2 220,440.00 12,331.37 64,772.61 29.38
101.401.347.405 Reuse Residential Usage Tier 3 635,232.00 30,687.90 167,984.15 26.44
101.401.347.406 Reuse Commercial Usage Tier 1 95,776.00 5,448.35 26,244.01 27.40
101.401.347.407 Reuse Commercial Usage Tier 2 32,826.00 1,816.53 9,524.50 29.02
101.401.347.408 Reuse Commercial Usage Tier 3 229,727.00 7,784.16 70,289.63 30.60
101.401.349.506 CROSSINGS RECLAIMED WATER CHRG 113,650.00 6,616.66 38,664.55 34.02
Net Reuse Water Usage Charges 2,135,303.00 119,767.43 639,989.17 32.48
Net Water Revenues 22,527,333.00 1,663,154.96 7,316,942.44 32.48
Sewage Revenues
Sewer Base Charges
101.401.343.501 RESIDENTIAL SEWER BASE CHARGE 13,725,981.00 1,164,485.21 4,614,750.85 33.62
101.401.343.504 GENERAL SERVICE SEWER BASE 2,197,709.00 205,653.90 813,716.02 37.03
Net Sewer Base Charges 15,923,690.00 1,370,139.11 5,428,466.87 32.51
Sewer Use Charges
101.401.343.502 RESIDENTIAL SEWER USAGE CHARGE 10,261,010.00 675,394.04 3,197,239.86 31.16
101.401.343.505 GENERAL SERVICE SEWER USAGE 3,524,827.00 219,265.08 1,037,532.33 29.43
101.401.343.506 PORTALET SEWAGE REVENUE 208,800.00 17,408.76 63,969.51 30.64
Net Sewer Use Charges 13,994,637.00 912,067.88 4,298,741.70 32.51
Net Sewage Revenues 29,918,327.00 2,282,206.99 9,727,208.57 32.51
Net OPERATING REVENUES 52,445,660.00 3,945,361.95 17,044,151.01 32.51
TOTAL REVENUES - ALL FUNDS 52,445,660.00 3,945,361.95 17,044,151.01 32.50
23
Budgeted vs. Actual - Base & Use Charges, Total
30,000,000
25,000,000 or7
"ram
20,000,000
15,000,000
10,000,000
to Pr
Pr
5,000,000
i 1
0 March April May June July August September
October November December January February
Actual Base Charges mom Actual Use Charges tBudgeted Base Charges ..♦.Budgeted Use Charges
Operating Net Income
$2,500,000
$2,000,000
$1,500,000
$1,000,000
t0
$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
Operating Revenue
$6,000,000
$5,000,000
$4,000,000 ----- -
$3,000,000
$2,000,000
ro _ 1 III
$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
CLAY COUNTY UTILITY AUTHORITY
OTHER REPORTS
to FISCAL YEAR 2021 /2022
Section G
27
02/23/2022 11:01 AM REVENUE AND EXPENDITURE REPORT FOR CLAY COUNTY UTILITIES Page: 1/2
User: kosborne
DB: CCUA PERIOD ENDING 01/31/2022
CONSTRUCTION DEPARTMENT BUDGET
ACTIVITY FOR
2021-22 MONTH YTD BALANCE ENCUMBERED UNENCUMBERED % BDGT
GL NUMBER DESCRIPTION AMENDED BUDGET 01/31/22 01/31/2022 YEAR-TO-DATE BALANCE USED
INTERNAL BILLINGS
101.401.349.609 BILLINGS TO CCUA-CAPITAL ASSET 624,519.00 141.21 16,273.72 0.00 608,245.28 2.61
Net INTERNAL BILLINGS 624,519.00 141.21 16,273.72 0.00 608,245.28 2.61
WAGES
101.401.536.128 C/D JOB PAYROLL 0.00 76.63 7,594.48 0.00 (7,594.48) 100.00
101.401.536.129 C/D CONTRA JOB PAYROLL 0.00 (76.63) (7,594.48) 0.00 7,594.48 100.00
101.502.536.121 WAGES HOURLY 241,797.65 43.26 5,191.94 0.00 236,605.71 2.15
Net WAGES (241,797.65) (43.26) (5,191.94) 0.00 (236,605.71) 2.15
HEALTH/LIFE INSURANCE
101.502.536.230 EMPLOYEE HEALTH&LIFE INSURANCE 63,804.38 24.17 1,335.97 0.00 62,468.41 2.09
Net HEALTH/LIFE INSURANCE (63,804.38) (24.17) (1,335.97) 0.00 (62,468.41) 2.09
RETIREMENT & BENEFITS
101.502.536.220 EMPLOYEE RETIREMENT & BENEFITS 25,643.32 4.80 1,055.02 0.00 24,588.30 4.11
Net RETIREMENT & BENEFITS (25,643.32) (4.80) (1,055.02) 0.00 (24,588.30) 4.11
PAYROLL TAXES
101.502.536.210 EMPLOYER FICA PAYROLL TAXES 18,088.12 2.85 380.30 0.00 17,707.82 2.10
Net PAYROLL TAXES (18,088.12) (2.85) (380.30) 0.00 (17,707.82) 2.10
WORKMENS COMPENSATION INS.
101.502.536.240 W/C INSURANCE 8,806.38 1.55 118.25 0.00 8,688.13 1.34
101.508.536.246 CONSTRUCTION W/C INSURANCE 0.00 0.00 189.19 0.00 (189.19) 100.00
101.509.536.246 CONSTRUCTION W/C INSURANCE 0.00 564.83 2,877.59 0.00 (2,877.59) 100.00
101.517.536.246 CONSTRUCTION W/C INSURANCE 0.00 0.00 293.89 0.00 (293.89) 100.00
Net WORKMENS COMPENSATION INS. (8,806.38) (566.38) (3,478.92) 0.00 (5,327.46) 39.50
PROPERTY/LIABILITY INSURANCE
101.502.536.451 PROPERTY INSURANCE-CONSTRUCTION 54,855.00 4,670.33 18,681.31 0.00 36,173.69 34.06
Net PROPERTY/LIABILITY INSURANCE (54,855.00) (4,670.33) (18,681.31) 0.00 (36,173.69) 34.06
OFFICE SUPPLIES
101.502.536.529 SUPPLIES OFFICE 900.00 0.00 75.42 0.00 824.58 8.38
Net OFFICE SUPPLIES (900.00) 0.00 (75.42) 0.00 (824.58) 8.38
TOOLS & SUPPLIES
101.502.536.407 JOB EQUIPMENT CHARGES 0.00 27.00 4,169.00 0.00 (4,169.00) 100.00
101.502.536.527 TOOLS & SUPPLIES 5,000.00 2,317.39 4,485.17 42.50 472.33 90.55
Net TOOLS & SUPPLIES (5,000.00) (2,344.39) (8,654.17) (42.50) 3,696.67 173.93
FUEL, OIL, & REPAIRS
101.502.536.468 EQUIP REPAIR&MAINTENANCE 15,000.00 3,616.16 9,914.81 3,135.51 1,949.68 87.00
Net FUEL, OIL, & REPAIRS (15,000.00) (3,616.16) (9,914.81) (3,135.51) (1,949.68) 87.00
TRANSPORTATION
101.502.536.401 TRANSPORTATION EXPENSES 25,500.00 2,940.46 9,153.26 0.00 16,346.74 35.90
Net TRANSPORTATION (25,500.00) (2,940.46) (9,153.26) 0.00 (16,346.74) 35.90
28
02/23/2022 11:01 AM REVENUE AND EXPENDITURE REPORT FOR CLAY COUNTY UTILITIES Page: 2/2
User: kosborne
DB: CCUA PERIOD ENDING 01/31/2022
CONSTRUCTION DEPARTMENT BUDGET
ACTIVITY FOR
2021-22 MONTH YTD BALANCE ENCUMBERED UNENCUMBERED % BDGT
GL NUMBER DESCRIPTION AMENDED BUDGET 01/31/22 01/31/2022 YEAR-TO-DATE BALANCE USED
MISCELLANEOUS
101.502.536.221 EMPLOYEE TRAINING & TRAVEL 4,325.00 910.00 1,365.00 0.00 2,960.00 31.56
Net MISCELLANEOUS (4,325.00) (910.00) (1,365.00) 0.00 (2,960.00) 31.56
DEPRECIATION
101.401.536.595 CONSTRUCTION R&R (DEPRECIATION 104,385.00 5,221.46 20,885.82 0.00 83,499.18 20.01
Net DEPRECIATION (104,385.00) (5,221.46) (20,885.82) 0.00 (83,499.18) 20.01
MATERIALS & SUBCONTRACTORS
101.502.536.435 TRASH SERVICE 2,100.00 0.00 0.00 0.00 2,100.00 0.00
101.502.536.461 SUBCONTRACTORS 0.00 0.00 169.69 0.00 (169.69) 100.00
Net MATERIALS & SUBCONTRACTORS (2,100.00) 0.00 (169.69) 0.00 (1,930.31) 8.08
CONTINGENCY
101.401.536.990 CONTINGENCY 54,315.00 0.00 0.00 0.00 54,315.00 0.00
Net CONTINGENCY (54,315.00) 0.00 0.00 0.00 (54,315.00) 0.00
TOTAL REVENUES - ALL FUNDS 624,519.00 141.21 16,273.72 0.00 608,245.28 2.61
TOTAL EXPENDITURES - ALL FUNDS 624,519.85 20,344.26 80,341.63 3,178.01 541,000.21 13.37
NET OF REVENUES & EXPENDITURES (0.85) (20,203.05) (64,067.91) (3,178.01) 67,245.07 .1,284.71
29