24-0573-REQ_Project_Financial_Overview_(for_Purchasing_only).pdf

PDF 360 KB Posted

Attached to
Construction Administration & Inspection Professional Services - Federal Funds - Mobile Home Community's (MHC's) - Project 2
Solicitation number
24-0573-RFP-CCNA
Issued by
Pinellas County, Clewiston City, Florida

About this file

This Project Financial Overview document is from Pinellas County, Florida, detailing a multi-year capital improvement program for wastewater collection system improvements in manufactured home communities. The project will replace wastewater collection systems in up to fifteen manufactured home communities in unincorporated southern Pinellas County, with the first phase focusing on Lake Seminole Estates and potentially four additional communities pending additional grant funding. The project is structured for Invitation to Bid (ITB) procurement and spans fiscal years 2024-2026, with a substantial completion deadline of June 30, 2026.

The project is funded through multiple sources, including $12,940,000 in ARPA funds, $54,000 in Restore funds, and anticipated grant funds totaling $42,700,000 from the U.S. Department of the Treasury and Florida Department of Environmental Protection's Resilient Florida Grant. The total estimated project cost is $81,633,000, with funding sources including Restore Funds ($54,000), Resilient Funds ($25,000,000), Anticipated Grant Funds ($42,700,000), and ARPA Funds ($13,879,000). The financial overview indicates sufficient funds for fiscal year 2024, but notes insufficient funding for fiscal years 2025 and 2026, recommending additional funding be secured before contract approval.

View the file

Other files

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

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

File details come from the government source that posted it. Updated .