HomeMy WebLinkAboutCHANGE ORDER - RFP - 7177 FORT COLLINS GHG TECHNICAL ASSISTANCE (3)04-10-11;20:07 ;SWCA 919702246177 ;8013224308 2/ 3
CHANGE ORDER NO.2
PROJECT TITLE: 7177 Fort Collins GHG Technical Assistance
CONTRACTOR: SWCA Environmental Consultants
PURCHASE ORDER NO.: 9110504
1. Reason for Change. Additional Services Needed and Modification of Task IV
2. Description of Change: Additional features and functionality added to the municipal
Greenhouse Gas (GHG) Emissions Management System (GEMS) database the Professional
recently completed under the original Scope of Work. These services would be completed under the
terms and conditions of our existing contract for GHG technical assistance (datedNavember, 10,
2011). Based on Professional's discussions with the City, Professional understands these
additional services could include the following:
Task IV Modification — No final deliverables were received for Task IV to design addon
tool functions to upload data to the database because the inventory process and data
quality were under review by the City's new Environmental Data Analyst (new job
position) hired May 31, 2011. Consequently, the City has determined that data storage
for waste, recycling, and fleet data will be significantly expanded to reflectrnore
complexity in the data, new data, more frequent activity data, and to automate uploading
of the data. This requires revision of the scope of work in Task IV of Amendment 1 to that
described in Tasks Via, Vib, Vllc, Vlld, Vlllb, Vllic, and Villd.
Task VI - Automate Waste and Recycling (Data Entry
a. Implement impart script for loading monthly waste and recycling data by acility.
b. Create user interface for importing data.
Task VII - Quarterly Departmental Reporting
a. Add detailed quarterly reporting by department to include departmental usage
and GHG emissions by scope and source, time series outputs by emissions
source, and department -specific fleet and waste/recycling, electric, natural gas,
sewer, and watersummaries.
b. Include quarter -to -quarter comparative reporting.
c. Expand departmental waste reporting to include "r6offs" and self -haul data.
d. Expand departmental fleet reporting to reflect new data as defined below.
Task Vlll - Expand Fleet Data Storage Capability
a. Add B10 fuels data storage.
b. Add capability to store municipal vehicles with year, make, model, vehicle type,
and fuel economy.
c. Develop an alternative fuel use indicator.
d. Assist with development of data collection protocol for individual vehicle usage.
Task IX -Add Data Export Functionality
a. Add capability to export report results to Microsoft Excel format for use outside
of GEMS database.
Task X - Process Emissions for Water and Waste Water
a. Review process emission methodologies and data and evaluate future
incorporation into the GHG Greenhouse Emissions Management System
(GEMS) database. Prepare a white paper that summarizes the findings.
The proposed additional services and estimated costs are as follows:
44 Sq
04-10-11;20:07 ;SWCA
919702246177 ;8013224308 # 3/ 3
• Task VI: Automate Waste and Recycling Data Entry
o Proposed estimated budget: $3,923
• Task VII: Quarterly Departmental Reporting
o Proposed estimated budget: $9,748
Task Vill: Expand Fleet Data Storage Capability
o Proposed estimated budget: $7.840
• Task IX: Add Data Export Functionality
o Proposed estimated budget: $5,552
• Task X: Process Emissions for Water and Wastewater
o Proposed estimated budget: $2.892
Professional will not exceed the total estimated budgets presented above without your prior
authorization.
3. Change in Contract Cost: $29.955
4. Contract Time: December 31, 2011
ORIGINAL CONTRACT COST
$_25,731
TOTAL APPROVED CHANGE ORDERS
_9,300 _
TOTAL PENDING CHANGE ORDERS
_0_
TOTAL THIS CHANGE ORDER
_$29,955_
TOTAL % OF ORIGINAL CONTRACT, THIS C.O.: 116%
TOTAL % OF ORIGINAL CONTRACT, ALL C.O.'S: 153%
ADJUSTED CONTRA OS
$,$64,986_
Assumin all than - a orde pip ve
ACCEPTED BY: t _ _
DATE: l0� I
Contr ctoes F fpresent ive
4
ACCEPTED BY:
DATE
Project Manager
REVIEWED BY:
DATE:
Title:
APPROVED BY: DATE:
Title:
APPROVED BY: _ DATE:.
Purchasing Agent over $60,000
cc: Purchasing