The file's text, extracted by GovTribe without its formatting.
Sheet1
| RFP 23NC0404 Attachment 12 - Cost Sheet | |
| Contractor Name: | |
| Key Staff Members Name and Title | Hourly Rate |
| Deliverable 1: Research and Evaluation Workplans and Updates | Unit of Measure | Cost Per Unit | Amount Required Years 1-4 | Total Cost Years 1-4 |
| 1) Research Sector Work Plans for each research sector which will describe the methodology and approach the Contractor will take to complete all subsequent Deliverables and studies for each sector addressed under this contract. | Per Plan | | 40 | |
| Deliverable 2: Final Impact Evaluation Reports | Unit of Measure | Cost Per Unit | Amount Required Years 1-4 | Total Cost Years 1-4 |
| 1) Final Reports | Per Report | | 40 | |
tc={754D7225-4438-430A-BBFB-70E7A17CF144}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
Originally 30, verify
| Deliverable 3: Impact Evaluation Report Stakeholder Briefings | Unit of Measure | Cost Per Unit | Amount Required Years 1-4 | Total Cost Years 1-4 |
| 1) Impact Evaluation Stakeholder Briefings (1/report/year) | Per Briefing | | 4 | |
| Deliverable 4: Annual EM&V Master Plan Update | Unit of Measure | Cost Per Unit | Amount Required Years 1-4 | Total Cost Years 1-4 |
| 1) Contractor to assist CPUC in updating Energy Division's EM&V Master Plan timeline and budget distribution across activities by December 31st of every other year (years 1 and 3 of contract) | Per Update | | 2 | |
| Deliverable 5: Monthly Progress Report | Unit of Measure | Cost Per Unit | Amount Required Years 1-4 | Total Cost Years 1-4 |
| 1) Prime Contractor to submit a Monthly Progress Report to the ED PM and/or other entities at the discretion of the EDPM that will include updates on progress made for each deliverable, deliverable-related activities, or other information upon request. (1/month for life of contract 48 months) | Per Report | | 48 | |
| Deliverable 6: Kickoff Meeting | Unit of Measure | Cost Per Unit | Amount Required Years 1-4 | Total Cost Years 1-4 |
| 1) Upon contract execution, Contractor will host a virtual kickoff meeting for CPUC staff and Contractor team to discuss and refine the draft workplan, etc. | Per Meeting | | 1 | |
| Deliverable 7:Project Coordination Meetings | Unit of Measure | Cost Per Unit | Amount Required Years 1-4 | Total Cost Years 1-4 |
| 1) Contractor will attend between 1-4 monthly project coordination meetings (up to 48 per year) with CPUC staff and other contractors to discuss status of tasks and activities across the entire contract. | Per Meeting | | up to 192 | |
| Deliverable 8: Stakeholder Workshops/Webinars | Unit of Measure | Cost Per Unit | Amount Required Years 1-4 | Total Cost Years 1-4 |
| 1) Contractor will participate in and/or conduct up to 200 stakeholder engagement activities throughout the initial contract. Meetings will be online or in-person, depending on the direction of the EDPM at the time | Per Meeting | | up to 200 | |
| Deliverable 9: Data collection plans | Unit of Measure | Cost Per Unit | Amount Required Years 1-4 | Total Cost Years 1-4 |
| 1) Contractor will submit a data collection plan for each study based on the goals and objectives of each study. Contractor should budget for 10 plans per year, based on 10 reports per year, for 40 plans over the life of the contract | Per Plan | | 40 | |
| Deliverable 10: Data Transfer | Unit of Measure | Cost Per Unit | Amount Required Years 1-4 | Total Cost Years 1-4 |
| 1) Contractors shall present all final evaluation data, for all studies, including resource acquisition, equity and NMEC, to one data set following the specifications of the "All Things Reported" longitudinal dataset as defined by the EDPM (at conclusion of each reporting year as defined by EDPM) | Per Contract | | 1 | |
| Deliverable 11: Portfolio and Policy Impact Recommendations | Unit of Measure | Cost Per Unit | Amount Required Years 1-4 | Total Cost Years 1-4 |
| 1) Frequency of deliverable may change but should include at least an ex-ante portfolio analysis each calendar year. | Per Report/analysis | | 4 | |
| Deliverable 12: Gross Savings Report | Unit of Measure | Cost Per Unit | Amount Required Years 1-4 | Total Cost Years 1-4 |
| 1) Contractor shall prepare a written Gross Savings Report draft to EDPM for review prior to finalization. Multiple reports will be submitted over the life of the contract, each of which is related and specified by the EDPM (1 per impact study, so 40 over the life of the contract) | Per Report | | 40 | |
| Deliverable 13: Net Savings Report | Unit of Measure | Cost Per Unit | Amount Required Years 1-4 | Total Cost Years 1-4 |
| 1) Contractor shall prepare a written Gross Savings Report draft to EDPM for review prior to finalization. Multiple reports will be submitted over the life of the contract, each of which is related and specified by the EDPM. (1 per impact study, so 40 over the life of the contract) | Per Report | | 40 | |
| Deliverable 14: Ex-ante Values Update Documentation | Unit of Measure | Cost Per Unit | Amount Required Years 1-4 | Total Cost Years 1-4 |
| 1) Contractor will develop a scoping document on the proposed updates for each year in a timeframe directed by CPUC staff and develop written documentation on all proposed changes to the ex-ante values to be included in the CPUC staff resolution | Per scoping documment | | 4 | |
| Deliverable 15: Ex-Ante Values Update Outreach | Unit of Measure | Cost Per Unit | Amount Required Years 1-4 | Total Cost Years 1-4 |
| 1) The contractor shall present the proposed updates during a public workshop(s) and participate in stakeholder engagement webinars, conference calls, in-person meetings (as needed) to address any questions. | Per webinar | | 4 | |
| Deliverable 16: Ex-Ante Values Update Supporting Materials | Unit of Measure | Cost Per Unit | Amount Required Years 1-4 | Total Cost Years 1-4 |
| 1) The Contractor shall assemble and deliver to the CPUC all supporting materials, including the source code and underlying scripts for the modeling tools and sofware used in coordination with CPUC's data hosting contractor | Per year | | 4 | |
| Deliverable 17: Ex-Ante Measure Package Dispositions | Unit of Measure | Cost Per Unit | Amount Required Years 1-4 | Total Cost Years 1-4 |
| 1) The Contractor shall prepare written dispositions for an estimate 227 measure packages during the update cycle and 67 measure packages reviewed during a mid-cycle year. (totalling 134 mid year cycle packages) | Per Disposition | | 361 | |
| Deliverable 18: Measure Package Review Meetings | Unit of Measure | Cost Per Unit | Amount Required Years 1-4 | Total Cost Years 1-4 |
| 1) Contractor shall participate in separate and regular coordination meetings with CPUC staff and PA staff in order to faciltiate a more transparent and collaborative review process. (Estimated 168 per year) | Per Meeting | | 672 | |
| Deliverable 19: Approved Measure Packages List | Unit of Measure | Cost Per Unit | Amount Required Years 1-4 | Total Cost Years 1-4 |
| 1) Contractor shall provide to the administrator of DEER Resources-CEDARS comprehensive lists of all approved measure packages that are kept current on a monthly basis. (12 per year) | Per Study | | 48 | |
| Deliverable 20: Deemed Rulebook Update | Unit of Measure | Cost Per Unit | Amount Required Years 1-4 | Total Cost Years 1-4 |
| 1) Contractor shall update the Deemed Rulebook as changes take place. | Per Update | | 4 | |
| Deliverable 21: Ex Ante Review Scoring Memorandums | Unit of Measure | Cost Per Unit | Amount Required Years 1-4 | Total Cost Years 1-4 |
| 1) Contractor will develop Ex Ante review scoring and write the annual mid-year and final ex-ante review performance scoring memorandums for the 4 IOUs. There are two memorandums per year for each IOU, for a total of 8 memorandums per year | Per Memorandum | | 32 | |
| Deliverable 22: Ex-Ante Scoring Review Interviews | Unit of Measure | Cost Per Unit | Amount Required Years 1-4 | Total Cost Years 1-4 |
| 1) After issuance of mid-year and annual scoring memorandums, Contractor under CPUC staff direction will conduct in-person meetings with each IOU to answer qualifying questions and address issues. | Per Interview | | 32 | |
| Deliverable 23: Effective Useful Life Report | Unit of Measure | Cost Per Unit | Amount Required Years 1-4 | Total Cost Years 1-4 |
| 1) Contractor will prepare a report that answers the five key questions and also provides recommendations for EULs to feed into the Energy Efficiency DEER updates. The frequency of this report shall be determined by the EDPM with input from the Contractor. | Per Report | | 4 | |
| Deliverable 24: Load Shape Report | Unit of Measure | Cost Per Unit | Amount Required Years 1-4 | Total Cost Years 1-4 |
| 1) Contractor will prepare a report on the impact of the hourly load shapes developed that describes the methodology and any limitations with the data. The report shall be delivered once a year, over the life of the contract. | Per Report | | 4 | |
| Deliverable 25: Additional Resource Acqusition Studies | Unit of Measure | Cost Per Unit | Amount Required Years 1-4 | Total Cost Years 1-4 |
| 1) Contractor will conduct up to 3 stand-alone studies of stand alone resource acquisition programs, as well as complementary programs in the market support and equity sectors. | Per Study | | 12 | |
| Basic Pricing | | | |
| Standard Pricing | | | |
| Enhanced Pricing | | | |
| Deliverable 26: Additional Policy Analysis Studies | Unit of Measure | Cost Per Unit | Amount Required Years 1-4 | Total Cost Years 1-4 |
| 1) Contractor will conduct up to 3 evaluation studies annually relating to a program/programs that are implemented in response to legislative mandates or Commmission directives (i.e. 2021 Summer Reliability programs administered by the IOUs). | Per Study | | 12 | |
| Basic Pricing | | | |
| Standard Pricing | | | |
| Enhanced Pricing | | | |
| Deliverable 27: Additional Portfolio and Parameter Level Studies | Unit of Measure | Cost Per Unit | Amount Required Years 1-4 | Total Cost Years 1-4 |
| 1) The Contractor will conduct up to 3 additional evaluation studies annually relating to the resource acquisition segment. Potential studies include those related to unanticipate elements of the TSB framework implementation as well as significant portfolio updates incurred by the Commission. | Per Study | | 12 | |
| Basic Pricing | | | |
| Standard Pricing | | | |
| Enhanced Pricing | | | |
| Deliverable 28: Additional Meetings | Unit of Measure | Cost Per Unit | Amount Required Years 1-4 | Total Cost Years 1-4 |
| 1) The proposer shall budget for approximately 5 remote meetings per year and 20 over the life of the contract. | Per meeting | | 20 | |
| Deliverable 29: Subject Matter Expert Services | Unit of Measure | Cost Per Unit | Amount Required Years 1-4 | Total Cost Years 1-4 |
| 1) Unanticipated Tasks | Per Hour | | | $250,000 |
| | Total Proposal Cost | | |