The URL can be used to link to this page

Home My WebLink AboutCORRESPONDENCE - RFP - 7177 FORT COLLINS GHG TECHNICAL ASSISTANCE (5)CHANGE ORDER NO. 6 POZ.O.J.E'dt TITLE: 71177� Fort Collins GHG T6chn]16 a[ Assistance' CONTRACTOR; SWCA Envir I on . m I entai Consultants PURCHASE ORDER NO.: 9110604 1.. Reason for Change: T r,Air Program Business Unit 705400 monies to this Purchase' Order_t',_7,_88r; _ I; accomplish rM ncemen f� s. _p-lis—h ne- database aie enhancements. 2. Description of Change: An amendment to P.O. 9110504 is requested to transfer $12,200 from the Air Program Business Unit 705400 for ditabase enhancement's to the b_H Q Emissions G HQ Management System (GEMS) and to extend the contract time to bec'e' ft"iber 3'1, 201 5. The proposed additional services and estimated costs are as follows: Task XVII: Develop an interface, cap ability to calculate Or pollutant concentrations, and an archival fb:a't*ure for the pollutants SO2, CO, NO, VOCs,, Hg, PM I . 0, PM 2. , 5, CH4, and ftylll;i 6k,.1111, .,. ., , I CO2 as 6 result of the following: a. bUrrent. 6omm uh a city usage on an annual basis. • Current community natural c • Current community nky vehicl6ii transpodaVon on an annual • Project- , and program -level,( reduced. We understand tK anti -idling and lawn mower i • Additional GHG reduction sl Action Plan. Usage on an annual basis. S traveled (VMT,) �6s . ing . G . EMS d .1 efaults for :is. Lilations of air pollutants emitted an d .. r ,pgram-level calculations would inclu8e the hives. igies developed for the updated Clim6te This task would include completing a review of available reference sources and recommending which emissions factors Would be most applicable to calculate air pollutant concentrations from the usage data available. o Proposad estimated budget: $8,500 • Task XVIII: Develop an annual report of co -benefits from air pollutant; reductions as listed in 1, above. This would be a standalone annual data summary report, Which could include a year -over- year summary if desired. 0 . Proposed estimated - budget: $2,600 J Task XIX Periodic calculation and archival feature forair pollutants 611utants (sarne as above) . and carbon sequestration resulting from the urban forest treecanopy, This would provide data storage and a summary reporting function for the i-Tree E60 Modeling data, which could be eip'ainded to historical trendingdata storage .. arid reporting, if desired. o Proposed estimated budget: $1,200 Professional will not exceed the total estimated budgets authorization. V/ J Acct fttO # —�' of = 7 U •��, p ti U 11, City of Fort Collins 215 North Mason Fort Collins, CO 80522 Sak Inks CM Orfiae I . 257 Ea 200 SvA, Side 200 SO Lake C4, Uhh 84111 , V 801.322.4307 Fm 801.322.4308 wvw.�wm.00m Attention: Bonnie Pierce, Environmental:Data Analyst November 6, 2014 RE: Proposal for Additional Services, Greenhouse Gas Technical Assistance, Greenhouse Gas Database and Reporting Tool Project, Air Pollutant Data Enhancements Dear Ms. Pierce: We appreciate the opportunity to submit this proposal for additional -greenhouse gas (GHG) technical assistance services to enhance the Community and Municipal GHG Data Storage and Reporting Tool (GEMS). At this time we understand these enhancements would include adding storage, and reporting capabilities for air pollutant concentrations and associated programs using GHG usage data -in the GEMS tool. These services would be completed under the terms and conditions of our eiasting contract for GHG technical assistance (dated November 10, 2011). Based on our discussions with you, we understand these additional services may include the following: 1. Task XVII: Develop an interface, capability to calculate air pollutant concentrations, and an archival feature for the pollutants S02, CO, NO, VOCs, Hg, PM 10, PM 2.5, CH4, and CO2 as a result of the following: a. Current community electricity usage on an annual basis. b. Current community natural gas usage on an annual basis. c. Current community vehicle miles traveled (VMT) using GEMS defaults for transportation on an annual basis. d. Project- and program -level calculations of air pollutants emitted and/or reduced. We understand that program -level calculations would include the anti -idling and lawn mower initiatives. e. Additional GHG reduction strategies developed for the updated Climate Action Plan. This task would include completing a reviewof available reference sources and recommending which emissions factors would be most applicable to calculate air pollutant concentrations from the usage data available. Proposed estimated budget: $8, 500 2. Task XVIII: Develop an annual report of co -benefits from air pollutant reductions as listed in 1, above. This would be a standalone annual data summary report, which could include a year -over - year summary if desired. Proposed estimated budget: $Z500 Environmental Services City of 215 North Mason Collins PO Box 580 Fort Collins, CO 80522 n 970.2216 � - 970.2214.4.617177 Fax MEMORANDUM TO: Gerry Paul, Director of Purchasing and Risk Management FROM: Bonnie Pierce, Environmental Data Analyst DATE: November 7, 2014 SUBJECT: Justification for Sixth Amendment to P.O.9110504 The purpose of this memo is to provide justification for a sixth request to amend P.O.9110504 and to extend the contract period to December 31, 2015. Paragraphs A through F describe the tasks completed under the original contract and amendments one through five: A. Original Contract: This PO was developed to work on an EECBG-funded project to provide greenhouse gas (GHGj technical assistance to the City of Fort Collins. SWCA was hired through -a competitive process to complete four tasks under the original scope of work: Task I - Evaluate the City of Fort Collins GHG reporting process Task II - Develop a GHG data repository and process Task IIIa - Develop a data reporting tool Task Illb - Conduct an independent review of the City's 2010 and 2011 GHG reporting. All deliverables from Tasks I through IIIa were completed by April, 2011, and Task IIIb was completed by June 2012. B. First Amendment: On February 16, 2011, the City requested an amendment to P.O. 9110504 in the amount of $9,300 to add two new items to the existing contract that were not covered under the original scope of work. Task IV - Design add -on tool functions to upload waste, recycling, and fleet data to the database. Task V - Provide on -call technical assistance, as needed, during implementation of the tool. Task V services were provided by September 2011, and the complexity of the features requested under Task IV required modification to the task under the second amendment to this contract.