The URL can be used to link to this page

Home My WebLink AboutRFP - 7293 AMI END POINT INSTALLATION SERVICES (2)3 ADDENDUM No. 4 SPECIFICATIONS AND CONTRACT DOCUMENTS Description of BID 7293: AMI End Point Installation OPENING DATE: 3:00 PM (Our Clock) November 3, 2011 To all prospective bidders under the specifications and contract documents described above, the following changes/additions are hereby made and detailed as follows: 1. Appendix E – AMI End Point Installation Services Pricing Workbook 10-24- 11 rev1 (attached as a separate Microsoft Xcel file) 2. This amendment provides the following updates to the subject RFP: 22.2.14 Encoder/Register Programming. Some Fort Collins water meters exist with Neptune Pro read encoder-registers that are programmed to accommodate a touch pad. At the time of water communications module installation, the Offeror is required to verify that these encoder-registers are already set to ‘auto detect/radio mode’, so as to enable these encoder-registers to properly work with the new communications module. If not set to this mode, Offeror shall re-program to this mode. Fort Collins believes that a maximum of 350 Pro Read registers (1.9% of total Pro Read population) exist which will require re-programming to "auto- detect/radio" mode. Therefore, Fort Collins is OK if the Offeror chooses to skip the step that requires the Offeror to verify that all Pro Read encoder/registers are already set to 'auto detect/radio' mode. If the Offeror elects to skip this verification step, the Offeror will be required to perform a second visit to these locations to re-program these encoder/registers to the 'auto detect/radio' mode, because these devices will not have "registered" on the Elster communications network. Please refer to Appendix E – Pricing AMI End Point Installation Services Pricing Workbook 10-24-11 rev1, Tab 2 – Water Module Installation and Tab 3 – Water Meter Information, for clarifying notes and information. Response: Financial Services Purchasing Division 215 N. Mason St. 2nd Floor PO Box 580 Fort Collins, CO 80522 970.221.6775 970.221.6707 fcgov.com/purchasing 22.3.9 Water Installation Requirements. Requirements are as follows. Please refer to Appendix E – AMI End Point Installation Services, Tab 2 – Water Communications Modules, for additional details. 22.3.9.1 Outdoor Pit Sets, non-ERT & all Encoder/Registers, All meter sizes: EPI Vendor verify Pro-read's in 'auto/radio mode'; Note 11 + install AMI Comms Module. 22.3.9.2 Outdoor Pit Sets, existing ERT & all encoder/registers, All meter sizes: EPI Vendor verify Pro-read's in 'auto/radio mode'; Note 11 + install AMI Comms Module. 22.3.9.3 Outdoor Wall Remotes, 3 wire & all encoder/registers, All meter sizes: EPI Vendor verify Pro-read's in 'auto/radio mode'; Note 11 + install AMI Comms Module. 22.3.9.4 Outdoor Wall Remotes, 2 wire & all encoder/registers, All meter sizes: EPI Vendor inspect & identify 2 wire config; install remote/wall mount AMI comms module inside premise; remove touchpad & install cover plate. Note 11 22.3.9.5 Indoor Meter Set, existing ERT & all encoder/registers, All meter sizes: Install remote/wall mount AMI comms module inside premise. Note 11 22.3.9.6 Indoor Meter Set, existing Generator Remotes - 3 wire & 2 wire & all encoder/registers, All meter sizes: replace meter & encoder/register; + install AMI Comms Modules inside premise. Note 11 10/24/11: Note 11: Additional Clarification to 22.2.14: Fort Collins believes that a maximum of 350 Pro Read registers (1.9% of total Pro Read population) exist which will require re-programming to "auto-detect/radio" mode. Therefore, Fort Collins is OK if the Offeror chooses to skip the step that requires the Offeror to verify that all Pro Read encoder/registers are already set to 'auto detect/radio' mode. If the Offeror elects to skip this verification step, the Offeror will be required to perform a second visit to these locations to re-program these encoder/registers to the 'auto detect/radio' mode, because these devices will not have "registered" on the Elster communications network. Offeror is required to acknowledge the preceding requirements. Response: 25 Pricing Information 25.1 General 25.1.2 Pricing Template: Has been revised as follows: Appendix E – AMI End Point Installation Services Pricing Schedule 10-24-11 rev1, contains the format for submittal of all required pricing. Response: 25.6 TAB 2: Water Communications Module Installation Pricing 25.6.3 The following explanatory notes are provided in this Tab. 25.6.3.1 EPI Vendor Workforce Required Competencies, Note 1: Please refer to Appendix F for the referenced Job Descriptions that describe the "Required Competencies" and workforce qualifications for this work. 25.6.3.2 For timing of installation of selected meter location and configurations, Note 2: Once 2 wire is identified, defer these to later in Phase 2 or 3. 25.6.3.3 For timing of installation of selected meter location and configurations ,Note 3: Since these can be manually read and the failure rates are more manageable as compared to the indoor ERTs, defer these to later in Phase 2 or 3. 25.6.3.4 Field Installation Unit Price, Note 4: Vendor Installation Unit Pricing shall be fully loaded and include all field supervision & field quality audit labor; field installation workforce labor; fleet, tools and equipment, uniforms, safety equipment, et al; and 'basic photograph(s)' as specified in RFP. 25.6.3.5 Work Order Management Unit Price, Note 5: Vendor Work Order Management shall be fully loaded and include the work order management system & handheld field devices, inclusive of all support as is required to perform daily work planning, issuing, data upload/download activities, et al. 25.6.3.6 Cross Dock Handling Unit Price, Note 6: Vendor Cross Dock Unit Pricing shall be fully loaded and include all cross dock labor and support as is required to perform daily staging and issuing meters and modules; receive used meters & modules; implement the scrapping process, and handle materials flows to/between the Offeror and Fort Collins. 25.6.3.7 (Optional) Post Installation Picture Unit Price, Note 7: This is optional pricing per section 22.3.4.1 of RFP. 25.6.3.8 Other Costs, Note 8: See Tab 4 for option for Vendor to provide other costs and services that Vendor expects to incur that are not included in this Tab. 25.6.3.9 Are Prices Fixed for Length of Contract?, Note 9: If Vendor's pricing is NOT fixed for life of contract, Vendor must provide explanation and inputs for 'escalation' on Tab 4 - Other Implementation Costs. 25.6.3.10 Extended Costs, Note 10: All Vendor costs shall be expressed in US 2012 constant dollars. 25.6.3.11 10/24/11: Note 11: Additional Clarification to 22.2.14: Fort Collins believes that a maximum of 350 Pro Read registers (1.9% of total Pro Read population) exist which will require re-programming to "auto-detect/radio" mode. Therefore, Fort Collins is OK if the Offeror chooses to skip the step that requires the Offeror to verify that all Pro Read encoder/registers are already set to 'auto detect/radio' mode. If the Offeror elects to skip this verification step, the Offeror will be required to perform a second visit to these locations to re-program these encoder/registers to the 'auto detect/radio' mode, because these devices will not have "registered" on the Elster communications network. Offeror is required to acknowledge these explanatory Notes. Response: 25.7 Tab 3, Water Meter Information 25.7.2 The quantities in Tab 2 – Water Module Installation, take precedence over the information contained in Tab 3. This table of information is amended and updated as of 10/24/11. [Refer to changes/updates in table therein]. 10/24/11: Additional Clarification to 22.2.14: Fort Collins believes that a maximum of 350 Pro Read registers (1.9% of total Pro Read population) exist which will require re-programming to "auto-detect/radio" mode. Therefore, Fort Collins is OK if the Offeror chooses to skip the step that requires the Offeror to verify that all Pro Read encoder/registers are already set to 'auto detect/radio' mode. If the Offeror elects to skip this verification step, the Offeror will be required to perform a second visit to these locations to re-program these encoder/registers to the 'auto detect/radio' mode, because these devices will not have "registered" on the Elster communications network. Response: Appendix E: AMI End Point Pricing Installation Services Workbook: A new Appendix E – “AMI End Point Installation Services Pricing Workbook 10-24-11 rev1” is provided/enclosed. Please refer to the notes and highlights in red as shown on Tab 2 – Water Module Installation and Tab 3 – Water Meter Information, for clarifying notes and information. Offeror is required to submit its pricing information using this “…10-24-11 rev1” template. Response: Submittal: Offeror is requested to submit this document inclusive of its responses, with its final submittal. Please contact Opal Dick, CPPO, Senior Buyer, Buyer at (970) 221-6778 with any questions regarding this addendum. RECEIPT OF THIS ADDENDUM MUST BE ACKNOWLEDGED BY A WRITTEN STATEMENT ENCLOSED WITH THE BID/QUOTE STATING THAT THIS ADDENDUM HAS BEEN RECEIVED. Appendix E - AMI End Point Installation Services Pricing Workbook 1. Please provide the name of your company here: = company_name (transfers company name to other sheets) 2. Please provide as a hard coded item the date of your submittal here: = submittal_date (transfers date to other sheets) 3. Please provide as a hard coded item the name of your file here. = file_name (transfers file name to other sheets) Please include the name of your company in the file name: Sample Vendor Name Sample Vendor File Name.xls 11/3/2011 Appendix E - AMI End Point Installation Services Pricing Workbook 10-24-11 rev1.xls Information Appendix E - AMI End Point Installation Services Pricing Workbook Tab 1 - Electric Meter Installation Pricing Responder: Vendor to fill in these cells Date File Name Phase 1 - Electric Only Pricing Ref. Item Responsibility Meter Configuration Meter Form Requirements Notes EPI Vendor Workforce Required Competencies (note 1) Qty ‐ Total System Field Installation Unit Price (note 4) Work Order Management Unit Price (note 5) Cross Dock Handling Unit Price (note 6) (Optional) Post Installation Picture Unit Price (note 7) Other Costs (note 8) Are Prices Fixed for Length of Contract? (note 9) Extended Costs (note 10) 1e Fort Collins - Single Phase Self-Contained 1S, 2S, 12S-Network Fort Collins to perform Phase 1 installation of these meter forms. Fort Colins intends to provide all labor for Phase 1 Electric Meter Technician 6,093 n/a see Tab 4 $0 2e Fort Collins - Single Phase Self-Contained 2S-Class 320 Fort Collins to perform Fort Colins intends to provide all labor for Phase 1 Electronic Technician II 0 n/a see Tab 4 $0 3e Fort Collins - Single Phase A-base meter replacement Various Fort Collins to perform Fort Colins intends to provide all labor for Phase 1 Electronic Technician II 0 n/a see Tab 4 $0 4e Fort Collins - Single Phase Transformer-Rated 3S, 4S Fort Collins to perform Fort Colins intends to provide all labor for Phase 1 Electronic Technician II 10 n/a see Tab 4 $0 5e Fort Collins - Three Phase Transformer-Rated 5S, 6S, 8S, 9S Fort Collins to perform Fort Colins intends to provide all labor for Phase 1 Electronic Technician II 7 n/a see Tab 4 $0 6e Fort Collins - Three Phase Self-Contained 13S, 14S, 15S, 16S Fort Collins to perform Fort Colins intends to provide all labor for Phase 1 Electronic Technician II 43 n/a see Tab 4 $0 7e Fort Collins - Three-Phase, C&I, GS50 & GS750, some with KYZ Various 3 phase polyphase Fort Collins to perform Fort Colins intends to provide all labor for Phase 1 Electronic Technician II 0 n/a see Tab 4 $0 Totals 6,153 $0.00 $0.00 $0.00 $0.00 (excludes Note 2's & 7's) $0 Phase 2 & 3 - Electric Only Pricing Ref. Item Responsibility Meter Configuration Meter Form Requirements Notes EPI Vendor Workforce Required Competencies (note 1) Qty ‐ Total Appendix E - AMI End Point Installation Services Pricing Workbook Tab 2 - Water Communications Module Installation Pricing Responder: Vendor to fill in these cells Date File Name Phase 1 ‐ Water Only Pricing Updated 10/24/11 Priority Ref. Item Initial Responsibility Final Responsibility Location Meter Configuration Meter Size Requirements Notes EPI Vendor Workforce Required Competencies (note 1) Qty ‐ Total System Field Installation Unit Price (note 4) Work Order Management Unit Price (note 5) Cross Dock Handling Unit Price (note 6) (Optional) Post Installation Picture Unit Price (note 7) Other Costs (note 8) Are Prices Fixed for Length of Contract? (note 9) Extended Costs 1 1w EPI Vendor EPI Vendor Outdoor Pit Sets non ERT & all encoder/registers All meter sizes EPI Vendor verify Pro-read's in 'auto/radio mode'; Note 11 + install AMI Comms Module Water Meter Systems Operator 1,067 see Tab 4 $0 1 2w EPI Vendor EPI Vendor Outdoor Pit Sets existing ERT & all encoder/registers All meter sizes EPI Vendor verify Pro-read's in 'auto/radio mode'; Note 11 + install AMI Comms Module Water Meter Technician 12 see Tab 4 $0 2 3w EPI Vendor EPI Vendor Outdoor Wall Remotes 3 wire & all encoder/registers All meter sizes EPI Vendor verify Pro-read's in 'auto/radio mode'; Note 11 + install AMI Comms Module Inspection is required to reveal 3W vs 2W; Water Meter Systems Operator 1,143 see Tab 4 $0 defer (note 2) 4w EPI Vendor EPI Vendor Outdoor Wall Remotes 2 wire & all encoder/registers All meter sizes EPI Vendor inspect & identify 2 wire config; install remote/wall mount AMI comms module inside premise; remove touchpad & install cover plate. Note 11 Inspection is required to reveal 3W vs 2W Water Meter Systems Operator 615 see Tab 4 $0 3 5w Fort Collins Fort Collins Indoor Meter Set existing ERT & all encoder/registers All meter sizes Install remote/wall mount AMI comms module inside premise. Note 11 Appendix E - AMI End Point Installation Services Pricing Workbook Tab 3 - Water Meter Information Only; No Vendor Pricing required Responder: Date File Name Water Meter, Encoder-Register Configuration Information Meter Size Meter Manuf Type Encoder/Register Make & Model ESTIMATE ONLY of # wires Pit Mount Quantity Wall/ Remote Mount Quantity 5/8" x 3/4" Badger Disc Badger ADE 3 4,987 2,279 5/8" x 3/4" Badger Disc Badger ADE 2 0 5,180 5/8 X 3/4" Neptune Disc Auto - Detect 0 0 0 5/8" x 3/4" Neptune Disc Pro Read 3 0 131 5/8 X 3/4" Neptune Disc Auto - Detect 0 0 0 5/8" x 3/4" Neptune Disc Pro Read 2 0 14 5/8 X 3/4" ABB Piston Direct Reads 000 3/4" Badger Disc Badger ADE 3 12 17 3/4" Badger Disc Badger ADE 2 0 3,511 3/4" Neptune Disc Auto - Detect 3 2,495 8,725 3/4" Neptune Disc Pro Read 0 0 0 3/4" Neptune Disc Auto - Detect 2 0 5,000 3/4" Neptune Disc Pro Read 0 0 0 1" Badger Disc Badger ADE 3 453 60 1" Badger Disc Badger ADE 2 0 483 1" Neptune Disc Auto - Detect 3 580 125 1" Neptune Disc Pro Read 0 0 0 1" Neptune Disc Auto - Detect 2 0 75 1" Neptune Disc Pro Read 0 0 0 1" ABB Piston Direct Reads 000 1 1/2" Badger Disc Badger ADE 3 748 0 1 1/2" Badger Disc Badger ADE 2 0 60 1 1/2" Neptune Disc Auto - Detect 3 250 0 1 1/2" Neptune Disc Pro Read 0 0 0 1 1/2" Neptune Disc Auto - Detect 2 0 1 1 1/2" Neptune Disc Pro Read 0 0 0 1 1/2" Sensus Piston Direct Reads 000 1 1/2" Sensus Piston Direct Reads 000 1 1/2" Neptune Turbine Auto - Detect 3840 1 1/2 " Sensus Turbine Direct Reads 000 1 1/2 " Sensus Turbine Direct Reads 000 2" Badger Disc Badger ADE 3 260 0 2" Badger Disc Badger ADE 2 0 20 2" Neptune Disc Auto - Detect 3 115 0 2" Neptune Disc Pro Read 0 0 0 2" Neptune Disc Auto - Detect 2 0 0 2" Neptune Disc Pro Read 0 0 0 2" Badger Turbine Badger ADE 3 40 0 2" Badger Turbine Badger ADE 2 0 0 2" Neptune Turbine Auto - Detect 3 49 0 2" Neptune Turbine Pro Read 0 0 0 2" Sensus Turbine Direct Reads 000 Meter Size Meter Manuf Type Encoder/Register Make & Model ESTIMATE ONLY of # wires Pit Mount Quantity Wall/ Remote Mount Quantity 2" Neptune ompound (Small Sid Auto - Detect 350 2" Neptune Compound Pro Read 0 0 0 3" Badger Turbine Badger ADE 3 4 0 3" Neptune Turbine Auto - Detect 3 14 0 3" Neptune Turbine Pro Read 0 0 0 3" Neptune Compound Auto - Detect 3 168 0 3" Neptune Compound Pro Read 0 0 0 4" Badger Turbine Badger ADE 3 12 0 4" Neptune Turbine Auto - Detect 3 18 0 4" Neptune Turbine Pro Read 0 0 0 4" Neptune Compound Auto - Detect 3 45 0 4" Neptune Compound Pro Read 0 0 0 6" Badger Turbine Badger ADE 3 1 0 6" Neptune Turbine Auto - Detect 3 7 0 6" Neptune Turbine Pro Read 0 0 0 6" Neptune Compound Auto - Detect 3 3 0 6" Neptune Compound Pro Read 0 0 0 6" Sensus Turbine Direct Reads 310 8" Neptune Turbine Auto - Detect 350 8" Neptune Turbine Pro Read 0 0 0 8" Neptune Compound Auto - Detect 3 4 0 8" Neptune Compound Pro Read 0 0 0 10" Sensus Turbine Sensus HSP 3 2 0 10,362 25,681 Total 36,043 Auto - Detect 3 5 17,768 Pro Read 0 0 131 10/24/11: Additional Clarification to 22.2.14: Fort Collins believes that a maximum of 350 Pro Read registers (1.9% of total Pro Read population) exist which will require re-programming to "auto-detect/radio" mode. Therefore, Fort Collins is OK if the Offeror chooses to skip the step that requires the Offeror to verify that all Pro Read encoder/registers are already set to 'auto detect/radio' mode. If the Offeror elects to skip this verification step, the Offeror will be required to perform a second visit to these locations to re-program these encoder/registers to the 'auto detect/radio' mode, because these devices will not have "registered" on the Elster communications network. 2.2.14 Encoder/Register Programming. Some Fort Collins water meters exist with Neptune Pro read encoder-registers that are programmed to accommodate a touch pad. At the time of water communications module installation, the Offeror is required to verify that these encoder-registers are already set to ‘auto detect/radio mode’, so as to enable these encoder-registers to properly work with the new communications module. If not set to this mode, Offeror shall re-program to this mode. Appendix E - AMI End Point Installation Services Pricing Workbook 10-24-11 rev1.xls Tab 3 Water Meter Information Appendix E - AMI End Point Installation Services Pricing Workbook Tab 4 Other Implementation Services Pricing Responder: Sample Vendor Name Vendor to fill in these cells Date 3-Nov-11 File Name Sample Vendor File Name.xls Other Implementation Services and Support Item Other Services and Requirements Unit of measure How many Units Cost Desc. Unit $Cost Are Prices Fixed for Length of Contract? (If 'No', see 5 below) Extended Cost (note 10) 1 Call Center 1a Call Center, Phase 1 months $/month $0 1b Call Center, Phase 2 months $/month $0 1c Call Center, Phase 3 months $/month $0 2 Post Installation Field Visits: (ref sect. 22.3.15.2) 2a 1S, 2S, 12S-Network unit rate 1 $/visit $0.00 2b 4S, 9S, 12S, 16S unit rate 1 $/visit $0.00 2c Pit Water set unit rate 1 $/visit $0.00 2d Outside remote/wall mount set unit rate 1 $/visit $0.00 2e Inside remote/wall mount set unit rate 1 $/visit $0.00 3 Hourly Wage Rates for Extra Work: 3a Electric Meter Technician (equivalent job classif) Fully Loaded Hourly Wage Rate 1 $/hour $0.00 3b Electronic Technician II (equivalent job classif) Fully Loaded Hourly Wage Rate 1 $/hour $0.00 3c Water Meter Systems Operator (equivalent job classif) Fully Loaded Hourly Wage Rate 1 $/hour $0.00 3d Water Meter Technician (equivalent job classif) Fully Loaded Hourly Wage Rate 1 $/hour $0.00 4 Facility Charge (ref. Sect. 19.1.5.1). (Applicable only if Offeror procures its own Facility in lieu of using the Fort Collins' provided facility). months $/month $0 5 Project Management Services. (monthly cost to provide project oversite and support for any items not included under the Electric and Water Installation Tabs) months $/month $0 6 Other Pricing Items (as defined by Offeror) 6a $0.00 6b $0.00 6c $0.00 6d $0.00 6e $0.00 7 Is Escalation to be Applied? 7a Electric Meter Installation (note 9, Tab 1) % escalation effective 1/1/2013 % - - 7b Water Module Installation (note 9, Tab 2) % escalation effective 1/1/2013 % - - 7c Call Center % escalation effective 1/1/2013 % - - 7d Post Installation Field Visits % escalation effective 1/1/2013 % - - 7e Hourly Wage Rates for Extra Work % escalation effective 1/1/2013 % - - 7f Facility Charge % escalation effective 1/1/2013 % - - 7g Project Management Services % escalation effective 1/1/2013 % - - 7h Other (add) % escalation effective 1/1/2013 % - - 7i Example % escalation effective 1/1/2013 (all/ partial / n/a) % (express in %) - - 7j Example % escalation effective 1/1/2013 n/a % 0.00% - - Total, All Services (Costs associated with escalation are calculated separately) $0 Note 9: From tabs 1 & 2: If Vendor's pricing is NOT fixed for life of contract, Vendor must provide explanation and inouts for 'escalation' on tab 4 ‐ Other Implementation Costs. Appendix E - AMI End Point Installation Services Pricing Workbook Tab 12 Assumptions & Exceptions Responder: Sample Vendor Name Date 3-Nov-11 File Name Sample Vendor File Name.xls See Pricing Instructions document. Vendor to fill in these cells Tab Item Sub-item/Line Appendix E - AMI End Point Installation Services Pricing Workbook 10-24-11 rev1.xls Tab 5 Assumptions & Exceptions Offeror to Provide additional explanation of Escalation, as required: Appendix E - AMI End Point Installation Services Pricing Workbook 10-24-11 rev1.xls Tab 4 Other Impl Costs The quantities in Tab 2 – Water Module Installation, take precedence over the information contained in Tab 3. This table of information is amended and updated as of 10/24/11. 3-Nov-11 Sample Vendor File Name.xls Sample Vendor Name Appendix E - AMI End Point Installation Services Pricing Workbook 10-24-11 rev1.xls Tab 3 Water Meter Information FC to replace approx 200 to 300 for Ph 1 Water Meter Technician 511 n/a see Tab 4 $0 defer (note 3) 6w Fort Collins Fort Collins Indoor Meter Set existing 'Generator Remotes' - 3 wire & 2 wire & all encoder/registers All meter sizes replace meter & encoder/register; + install AMI Comms Modules inside premise; Note 11 Inspection is required to reveal 3W vs 2W n/a 315 n/a see Tab 4 $0 Totals 3,663 $0 $0.00 $0.00 $0.00 (excludes Note 7's) $0 Phases 2 & 3 ‐ Water Only Pricing Priority Ref. Item Initial Responsibility Final Responsibility Location Meter Configuration Meter Size Requirements Notes EPI Vendor Workforce Required Competencies (note 1) Qty ‐ Total System Field Installation Unit Price (note 4) Work Order Management Unit Price (note 5) Cross Dock Handling Unit Price (note 6) (Optional) Post Installation Picture Unit Price (note 7) Other Costs (note 8) Are Prices Fixed for Length of Contract? (note 9) Extended Costs ‐ 7w EPI Vendor EPI Vendor Outdoor Pit Sets non ERT & all encoder/registers All meter sizes EPI Vendor verify Pro-read's in 'auto/radio mode'; Note 11 + install AMI Comms Module Water Meter Systems Operator 8,693 see Tab 4 $0 ‐ 8w EPI Vendor EPI Vendor Outdoor Pit Sets existing ERT & all encoder/registers All meter sizes EPI Vendor verify Pro-read's in 'auto/radio mode'; Note 11 + install AMI Comms Module Water Meter Technician 1,197 see Tab 4 $0 ‐ 9w EPI Vendor EPI Vendor Outdoor Wall Remotes 3 wire & all encoder/registers All meter sizes EPI Vendor verify Pro-read's in 'auto/radio mode'; Note 11 + install AMI Comms Module Inspection is required to reveal 3W vs 2W Water Meter Systems Operator 10,815 see Tab 4 $0 ‐ 10w EPI Vendor EPI Vendor Outdoor Wall Remotes 2 wire & all encoder/registers All meter sizes EPI Vendor inspect & identify 2 wire config; install remote/wall mount AMI comms module inside premise; remove touchpad & install cover plate. Note 11 Inspection is required to reveal 3W vs 2W Water Meter Systems Operator 5,825 see Tab 4 $0 ‐ 11w EPI Vendor EPI Vendor Indoor Meter Set existing ERT & all encoder/registers All meter sizes Install remote/wall mount AMI comms module inside premise. Note 11 Water Meter Technician 1,945 see Tab 4 $0 ‐ 12w Fort Collins Fort Collins Indoor Meter Set existing 'Generator Remotes' - 3 wire & 2 wire & all encoder/registers All meter sizes replace meter & encoder/register; + install AMI Comms Modules inside premise; Note 11 Inspection is required to reveal 3W vs 2W n/a 1,574 n/a see Tab 4 $0 Totals 30,049 $0 $0.00 $0.00 $0.00 (excludes Note 7's) $0 Total System - All Phases 33,712 $0 $0.00 $0.00 $0.00 (excludes Note 7's) $0 Note 1: Please refer to Appendix F for the referenced Job Descriptions that describe the "Required Competencies" and workforce qualifications for this work. Note 2: Once 2 wire is identified, defer these to later in Phase 2 or 3 Note 3: Since these can be manually read and the failure rates are more manageable as compared to the indoor ERTs, defer these to later in Phase 2 or 3 Note 4: Vendor Installation Unit Pricing shall be fully loaded and include all field supervision & field quality audit labor; field installation workforce labor; fleet, tools and equipment, uniforms, safety equipment, et al; and 'basic photograph(s)' as specified in RFP. Note 5: Vendor Work Order Management shall be fully loaded and include the work order management system & handheld field devices, inclusive of all support as is required to perform daily work planning, issuing, data upload/download activities, et al. Note 6: Vendor Cross Dock Unit Pricing shall be fully loaded and include all cross dock labor and support as is required to perform daily staging and issuing meters and modules; receive used meters & modules; implement the scrapping process, and handle materials flows to/between the Offeror and Fort Collins. Note 7: This is optional pricing per section 22.3.4.1 of RFP. Note 8: See Tab 4 for option for Vendor to provide other costs and services that Vendor expects to incur that are not included in this Tab Note 9: If Vendor's pricing is NOT fixed for life of contract, Vendor must provide explanation and inputs for 'escalation' on Tab 4 ‐ Other Implementation Costs. Note 10: All Vendor costs shall be expressed in US 2012 constant dollars. Sample Vendor Name 3-Nov-11 Sample Vendor File Name.xls 10/24/11: Note 11: Additional Clarification to 22.2.14: Fort Collins believes that a maximum of 350 Pro Read registers (1.9% of total Pro Read population) exist which will require re‐programming to "auto‐detect/radio" mode. Therefore, Fort Collins is OK if the Offeror chooses to skip the step that requires the Offeror to verify that all Pro Read encoder/registers are already set to 'auto detect/radio' mode. If the Offeror elects to skip this verification step, the Offeror will be required to perform a second visit to these locations to re‐program these encoder/registers to the 'auto detect/radio' mode, because these devices will not have "registered" on the Elster communications network. Appendix E - AMI End Point Installation Services Pricing Workbook 10-24-11 rev1.xls Tab 2 Water Module Installation System Vendor Installation Unit Price (note 4) Vendor Work Order Management Unit Price (note 5) Vendor Cross Dock Handling Unit Price (note 6) (Optional) Post Installation Picture Unit Price (note 7) Other Costs (note 8) Are Prices Fixed for Length of Contract? (note 9) Extended Costs (note 10) 8e EPI Vendor - Single Phase Self-Contained 1S, 2S, 12S-Network Fort Collins to perform Phase 1 installation of these meter forms Electric Meter Technician 55,407 see Tab 4 $0 9e Fort Collins - Single Phase Self-Contained 2S-Class 320 Fort Collins to perform Electronic Technician II 5 n/a see Tab 4 $0 10e Fort Collins - Single Phase A-base meter replacement Various Fort Collins to perform Electronic Technician II 4 n/a see Tab 4 $0 11e Fort Collins - Single Phase Transformer-Rated 3S, 4S Fort Collins to perform Note 2 Electronic Technician II 215 see Tab 4 $0 12e Fort Collins - Three Phase Transformer-Rated 5S, 6S, 8S, 9S Fort Collins to perform Note 2 Electronic Technician II 691 see Tab 4 $0 13e Fort Collins - Three Phase Self-Contained 13S, 14S, 15S, 16S Fort Collins to perform Note 2 Electronic Technician II 2,122 see Tab 4 $0 14e Fort Collins - Three-Phase, C&I, GS50 & GS750, some with KYZ Various 3 phase polyphase Fort Collins to perform Electronic Technician II 509 n/a see Tab 4 $0 Totals 58,953 $0 $0.00 $0.00 $0.00 (excludes Note 2's & 7's) $0 65,106 $0 $0.00 $0.00 $0.00 (excludes Note 2's & 7's) $0 Note 1: Please refer to Appendix F for the referenced Job Descriptions that describe the "Required Competencies" and workforce qualifications for this work. Note 2: While Fort Collins intends to complete this work, Offeror is asked to provide pricing in the event that Fort Collins requires additional support for this activitiy Note 3: (applies to water only) Note 4: Vendor Installation Unit Pricing shall be fully loaded and include all field supervision & field quality audit labor; field installation workforce labor; fleet, tools and equipment, uniforms, safety equipment, et al; and 'basic photograph(s)' as specified in RFP. Note 5: Vendor Work Order Management shall be fully loaded and include the work order management system & handheld field devices, inclusive of all support as is required to perform daily work planning, issuing, data upload/download activities, et al. Note 7: This is optional pricing per section 22.3.4.1 of RFP. Note 8: See Tab 4 for option for Vendor to provide other costs and services that Vendor expects to incur that are not included in this Tab Note 9: If Vendor's pricing is NOT fixed for life of contract, Vendor must provide explanation and inputs for 'escalation' on Tab 4 ‐ Other Implementation Costs. Note 10: All Vendor costs shall be expressed in US 2012 constant dollars. Sample Vendor Name 3-Nov-11 Sample Vendor File Name.xls Note 6: Vendor Cross Dock Unit Pricing shall be fully loaded and include all cross dock labor and support as is required to perform daily staging and issuing meters and modules; receive used meters & modules; implement the scrapping process, and handle materials flows to/between the Offeror and Fort Collins. Appendix E - AMI End Point Installation Services Pricing Workbook 10-24-11 rev1.xls Tab 1 Elect Meter Installation