24-0545-REQ_Project_Financial_Overview.pdf

Purchasing Financial Information:

Funding Source: Budgeted in the Capital Improvement Program Title of Funding Source: Sewer Renewal & Replacement Fund Are funds currently available? Yes If grant funding, select type: N/A Date funds available: 10/01/2023

Adopted Planned Planned Multi-Year Project Costs FY24 FY25 FY26 Total Acquisitions -$ -$ -$ -$ Professional Services/Design 54,000$ -$ -$ 54,000$ Construction 12,940,000$ 12,500,000$ 12,500,000$ 37,940,000$ Other (CEI) 200,000$ 2,350,000$ 850,000$ 3,400,000$ Total Project Costs 13,194,000$ 14,850,000$ 13,350,000$ 41,394,000$ +/- Approved Carry-Forward (ARPA) 939,000$ -$ -$ 939,000$ +/- Approved Carry-Forward (Restore) 612,000$ -$ -$ 612,000$ Adjusted Total Project Costs 14,745,000$ 14,850,000$ 13,350,000$ 42,333,000$

Project Resources Funding Restore Funds 54,000$ -$ -$ 54,000$

Funding Anticipated Grant Funds 200,000$ 14,850,000$ 13,350,000$ 28,400,000$ (1)

Funding ARPA 12,940,000$ -$ -$ 12,940,000$ (2)

Total Project Resources 13,194,000$ 14,850,000$ 13,350,000$ 41,394,000$ +/- Approved Carry-Forward (ARPA) 939,000$ -$ -$ 939,000$ +/- Approved Carry-Forward (Restore) 612,000$ -$ -$ 612,000$ Adjusted Total Project Resources 14,745,000$ 14,850,000$ 13,350,000$ 42,333,000$

Estimate Proposed Proposed Multi-Year Project Costs FY24 FY25 FY25-26 Total Acquisitions $0 $0 $0 $0 Professional Services/Design $54,000 $0 $0 $54,000 Construction $257,000 $25,672,000 $55,650,000 $81,579,000 Other $0 $0 $0 $0 Total Project Costs $311,000 $25,672,000 $55,650,000 $81,633,000 +/- Budget Adjustments $0 $0 $0 $0 Adjusted Total Project Costs $311,000 $25,672,000 $55,650,000 $81,633,000

Project Resources Funding Restore Funds $54,000 $0 $0 $54,000 Funding Resilient Funds $0 $9,500,000 $15,500,000 $25,000,000 Funding Anticipated Grant Funds $0 $2,550,000 $40,150,000 $42,700,000

Funding ARPA Funds $257,000 $13,622,000 $0 $13,879,000 (1)

Total Project Resources $311,000 $25,672,000 $55,650,000 $81,633,000 (2)

+/- Budget Adjustments $0 $0 $0 $0 Adjusted Total Project Costs $311,000 $25,672,000 $55,650,000 $81,633,000

Year to Date Activity FY24 FY25 FY26

Multi-Year Total (3)

YTD Expenditures $714,567 - - 714,567.30 Encumbrances $407,858 - - 407,858.00 Total $1,122,425 - - 1,122,425.30

Budget Less YTD Activity 13,622,574.70$ 14,850,000.00$ 13,350,000.00$ 41,210,574.70$

Result Sufficient Funds Sufficient Funds Sufficient Funds Sufficient Funds

Estimated Activity FY24 FY25 FY26

Multi-Year Total (4)

Design $54,000 $0 $0 $54,000

Construction $5,000,000 $40,000,000 $35,643,086 $80,643,086

CEI and SDC $500,000 $2,500,000 $2,059,965 $5,059,965 (5)

$5,554,000 $42,500,000 $37,703,051 $85,757,051 (6)

Estimated Remaining Appropriation 9,191,000.00$ (27,650,000.00)$ (24,353,051.00)$ (43,424,051.00)$ (7)

Result Sufficient Funds Insufficient Funds Insufficient Funds Insufficient Funds (8)

Notes:

Prepared By the Office of Management & Budget, February 19, 2024.

(7) Project has sufficient funding for FY24 in the FY24-29 Capital Improvements Plan (CIP). The project has insufficient funding in FY25 and FY26, additional funding for all planned work should be secured and budgeted before the Granicus process. The budget only includes approved and agreed grant funding, enterprise funding can not be used on this project. The current budget must be adequate to fund all contracts prior to OMB Granicus review and at the time of contract approval.

(5) CEI = Construction Engineering Services, SDC = Services During Construction, both are charged to design tasks.

Amended Budget

Proposed Budget

(1) ARPA Funds must be spent by December 31, 2026.

(2) Estimated Activity section includes Year to Date Activity.

(3) Engineer estimate was provided by Jacobs consultant, Michelle Collins.

(4) Utilities is pursuing an additional Resilient Florida grant in the amount of $8,950,000 with a required match, to fund the remainder of the project. The matching funds would be derived from ARPA and Resilient, failure to spend those funds before the deadline could compromise the additional grant funds. This amount is not included in the Adopted FY24-29 Capital Improvements Plan (CIP), and will be included in the FY25-30 Proposed CIP as well as additional grant funding to be pursued at a later time.

(6) Estimated Remaining Appropriation at the end of each fiscal year will vary based on actual expenditures.

(1) Anticipated grant funds have not been fully executed.

Project Financial Overview

Parent/Budgeted Number: 005015A Manufactured Home Communities Wastewater Collection System Improvements Description: Project will include replacing up to fifteen (15) manufactured home communities wastewater collection systems in unincorporated southern Pinellas County.

Requested for: ITB

Requested By : Karen O'Connor

Multi-Year Capital Improvement Program