ID 724640

Archived

City of Cedar Park: Rate Model Enhancement Project, Cedar Park, TX

Williamson County

Owner Reference: RFQ #09-12-224-MH-309

Bid Date: 10/17/2024 at 02:00pm

Trades: Supervisory Control & Data Acquisition (SCADA): Controllers, Process & Data Automation: Hardware/Software on High-Level Machiner

The City of Cedar Park has developed and currently maintains a comprehensive water and wastewater utility rate model. The model has been successfully used to set water and wastewater rates to ensure that the utility is financially viable and that customers are fairly charged. Originally developed in Microsoft Excel, the model is large and has a flat data structure. The City seeks the services of a qualified firm to provide assistance with a conversion or enhancements to the rate model to make it more intuitive and user-friendly. These enhancements include, but are not limited to, improving the data input functionality, consolidating data input locations, streamlining calculations, and creation of data analysis/data visualization components. The effort would also include documentation related to model structure, functionality, and the development of a user manual. Comprehensive training to key staff that will use the model should be provided. The City is willing to explore the use of existing template-based models, in which case the effort would include a data migration from the existing model to the new model.

City of Cedar Park TX
 Mike Huber
 Login or create an account To view email

Published 10/01/2024 on Construction Bid Source

DISCLAIMER: Projects posted by Construction Bid Source contain information that is aggregated daily from multiple sources. It is the individual responsibility of our members to contact the owner directly for purposes of bidding on a project and gaining additional project information. Construction Bid Source does not assume any responsibility for omissions or errors.