Data Modeling and Excel Tool Development

The Cape Fear Public Utility Authority is seeking a contractor to develop dynamic, Excel-based modeling tools designed to simulate water demand, supply scenarios, and cost projections for internal use by its staff. These tools must be robust, user-friendly, and built for ongoing operational reliability, enabling CFPUA personnel to analyze and plan for future water resources under varying conditions. The deliverables include fully functional spreadsheets with integrated calculations, scenario inputs, output visualizations, and clear documentation to ensure usability by non-technical staff. The contract is classified as a subcontract under NAICS code 541690, and proposals must be submitted by August 4, 2026. The work is to be performed in support of CFPUA’s operations in North Carolina, with full ownership and ongoing maintenance rights retained by the authority. The contractor is expected to have demonstrated expertise in building customized data models in Excel, experience in utility or water resource planning, and the ability to translate complex hydrological and financial data into intuitive, interactive tools. No set-aside provisions or special eligibility requirements are specified, but submissions must meet the technical and functional expectations outlined in the solicitation.