HomeMy WebLinkAboutCORRESPONDENCE - PURCHASE ORDER - 9161514 (3)Task Description
Division Manager - QA/QC
(Andrea Faucett)
Project Manager
(Chris Pletcher)
Engineer
(Katie Rubush)
Two-Man Survey Crew
Survey Manager
(Brian Nelson)
CAD / GIS
(Scott Reid)
Clerical
Total Labor
Cost Direct Costs
Total by
Task
$165 $130 $90 $125 $120 $85 $75
Task 1 Meetings, Coordination and Emergency Situation
Support
1.1 Weekly Meetings for 31 weeks 110 $14,300 $365 $14,665
1.2 Emergency Situation Support 40 $5,200 $135 $5,335
Task 1 Subtotal: 150 $19,500 $500 $20,000
Total 150 $19,500 $500 $20,000
LABOR DETAIL AND SUMMARY OF DIRECT AND SUBCONSULTING COSTS BY TASK
Ayres Associates - Professional Services Fee Proposal
H2O Map Water Model Monitoring and Update
Based on Scope of Services dated 5/28/09
Sue Paquette
City of Ft. Collins
700 Wood St.
Ft. Collins, CO 80521
RE: Proposed Services for the City of Ft. Collins Water Distribution Hydraulic Model
The City of Ft. Collins is planning on moving towards a model integrated with their asset
management system. In addition, they are looking to integrate AMI data into the
model for enhanced demand prediction and forecasting. The purpose of this
document is to detail the services that can be provided by Kedric Szana. All services
will be performed at the City of Ft. Collins using a City computer and software licenses.
Integrate the Existing Model with the Asset Management System
The existing model and asset management database will be examined to determine
the best practices for syncing these databases in the future. Based on this analysis,
some features (namely pipes and hydrants) may need integrated from scratch (while
maintaining the rest of the model elements), otherwise the update mechanism can
proceed directly. In the end, a procedures manual will be created for future reference.
The following is a brief description of the tasks that will be performed:
• Analyze the CAD-Access database as well as the esri database and comment
on benefits of one vs the other for model integration
• Valves, tanks, and pumps from the current hydraulic model will be retained
regardless
• Pipes (and hydrants if desired) will be analyzed to see if there is a way to match
the model pipes to the asset database pipes with a guaranteed 1 to 1
relationship
• Test the update to ensure it operates as expected, and ensure model runs
afterword with expected results
• Complete procedures manual with step by step detailed but simple instructions
• Create a methodology for easily assigning C-values based on age and material
etc.
The estimated time cap for this task is 50 hours.
AMI Integration with the Hydraulic Model
AMI data is quite new to hydraulic modeling. Few people have analyzed the vast
amount of data available in great detail. One major focus here will be determining
how the AMI can be leveraged to improve demand forecasting and model predictions
while not getting so detailed the benefit gets lost. Much emphasis will be placed on
explaining how AMI data can be used, pros vs. cons, and possible tools for additional
analysis. The end step will be integrating the AMI at a level the City of Ft. Collins desires.
The following is a brief description of the tasks that will be performed:
• Understand the AMI system in detail. AMI is a generic term for the infrastructure,
and the model is most interested with the AMI database and existing and
proposed tools that can be used for data analysis. Understanding the City of Ft.
Collins system will be crucial to make additional recommendations.
• There are off the shelf tools that can be used with AMI data and integrate with
the model. While I am not promoting anything, in due diligence I at least must
detail these to the City.
• Possibilities for integrating AMI data will be detailed, along with pros and cons.
Meetings will be held with the City staff to ensure they understand all the
possibilities and can determine what is best for the City.
• AMI Data will be used to create a model with enhanced demand modeling in
the 3 critical areas of demands (few break down to this detail, but it has massive
benefits):
o Spatial Distribution
o Temporal Distribution
o Daily Totals
• Patterns will be developed as desired from AMI data and implemented
• Spatial distribution will be developed from the AMI data and implemented
• Linking the model to AMI data for forecasting will be discussed in detail and
implemented at the request of the City.
I will place a cap on this of 100 hours, as I am confident a huge benefit can be realized
with that time. To be honest depending on the decision the City makes (and how
much I do vs. in-house), this could be 50 to well over 200 hours. However, since there is
an AMI expert in-house I could work with, I doubt 200 would ever be exceeded.
Have City Staff Shadow the Process
This mostly applies to integrating the model with the asset management database. If
the City chooses to have someone work with me and learn the software and process in
depth, the time for this would be increased by an estimated 50% max (25 hours).
For the AMI task, I will need to work with this person directly for much of the tasks, so any
additional shadowing would be minimal. I would estimate an additional 30 hours for
this task (most of which would be depending on the route the City chooses during this
phase).
The major benefit to the City from this task is being left with an in-house expert and not
requiring more services in the future for the same work.
This project can be completed in a maximum of 205 hours. The rate is $100/hr, for a
maximum of $20,500. I am available to meet and discuss more if you are interested. At
the current time I can commit a minimum of one day a week at the City of Ft. Collins.
Kind Regards,
Kedric Szana
Ked Solutions