24NC0330_Attachment_14_Cost_Sheet.xlsx
XLSX spreadsheet 25 KB Posted
- Solicitation number
- 0000034178
- Issued by
- California
About this file
This is a cost sheet template from the California Public Utilities Commission (CPUC) for a contract related to energy efficiency and integrated resource planning services. The template requires bidders to list team members, their CPUC-equivalent classifications, hourly rates, and areas of expertise, along with detailed cost breakdowns for 18 specific deliverables spanning four base years with two optional years (Year 5 and 6). Key deliverables include work plans, progress reports, meetings, capacity expansion model updates, resource potential assessments, IRP scenarios, state priority analyses, technical research, and various planning support activities.
The cost structure includes fixed-price deliverables and hourly rate services, with specific quantities defined for each contract year. CPUC classifications range from Subject Matter Experts (requiring 5-15 years of experience) to General Analysts and Project Managers, with varying experience requirements. The template includes a $250,000 allocation for unanticipated tasks, and bidders must provide separate cost totals for the base period (Years 1-4) and each optional year. The pricing format requires detailed hour estimates and unit costs for each deliverable, with some deliverables recurring annually while others are one-time submissions.
View the file
Other files
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Team Members INSTRUCTIONS: 1) Enter the name, title, hourly rate, and areas of expertise for all Proposer's team members. 2) Add or subtract rows to accommodate the team's size. 3) Refer to the provided list of CPUC classifications that are to be used in Column B.
| Team Member Name | CPUC-equivalent Classification/Title | Hourly Rate | Areas of expertise (e.g. energy modelling, meter-based savings evaluation, field testing and verification) |
| Sample Entry: John Doe | Project Manager I/ Project Manager | $ 300.00 | Field Testing and Verification, Field Safety, Engineering Protocols |
| Team member 1 | |||
| Team member 2 | |||
| Team member 3 | |||
| Team member 4 | |||
| Team member 5 | |||
| Team member 6 | |||
| Team member 7 | |||
| Team member 8 | |||
| Team member 9 | |||
| Team member 10 | |||
| Team member 11 | |||
| Team member 12 | |||
| Team member 13 | |||
| Team member 14 | |||
| Team member 15 | |||
| Team member 16 | |||
| Team member 17 | |||
| Team member 18 | |||
| Team member 19 | |||
| Team member 20 | |||
| Team member 21 | |||
| Team member 22 | |||
| Team member 23 | |||
| Team member 24 | |||
| Team member 25 | |||
| Team member 26 | |||
| Team member 27 | |||
| Team member 28 | |||
| Team member 29 | |||
| Team member 30 | |||
| CPUC Classification/Title | Definition | ||
| Subject Matter Expert I | Has 5 or more years experience in one or more specific area/s of energy efficiency for which work is required in this contract (e.g. energy modelling) | ||
| Subject Matter Expert II | Has 10 or more years experience in the specific area of energy efficiency for which work is required in this contract | ||
| Subject Matter Expert III | Has 15 or more years experience in the specific area of energy efficiency for which work is required in this contract | ||
| General Analyst I | Has general analytical or computer skills to assist SME (e.g. knowledge of statistical methods, basic MS excel), can perform basic to mid-level tasks under supervision | ||
| General Analyst II | Same as above, but must perform intermediate to advance tasks under minimal supervision | ||
| General Analyst III | Can independently perform complex tasks, create work plans, manage other analysts work, with little to no supervision | ||
| Project Manager I | Has 0-5 years experience in project management, facilitation | ||
| Project Manager II | Has 6-10 years of experience in project management, facilitation, with minimal exposure in the Energy Efficiency industry | ||
| Project Manager III | Has more than 10 years of experience in project management, facilitation, with extensive exposure in the Energy Efficiency industry | ||
| Administrative Analyst I | Can independently handle administrative functions such as Invoicing and payroll, and is able to formulate new or revised systems to meet accounting needs | ||
| Administrative Supervisor | Has at least 2 years of experience in planning, organizing, and directing the administrative and staff services functions in a division, office, region, district, or one of the largest area offices; or assisting a higher-level administrator in planning, organizing, directing, and controlling two or more administrative staff functions in a large district or in a division. |
Task Quantification
| Cost Sheet |
| Deliverable Amounts |
| REQUIRED | |||||||||
| Deliverables | Unit | Estimated Hours for all Staff | Total Cost Per Unit | Total Number of Units Required | Total Cost Yr 1-4 | Number of Units Optional YR 5 | Total Cost Optional Yr 5 | Number of Units Oprional YR 6 | Total Cost Optional YR 6 |
| Yr 1 | Yr 2 | Yr 3 | Yr 4 | ||||||||
| 1) Work Plans | Per submission | $ - 0 | 1 | $ - 0 | $ - 0 | $ - 0 | |||||
| 2) Progress Reports and Updates | Per report | $ - 0 | 18 | 18 | 18 | 18 | $ - 0 | 18 | $ - 0 | 18 | $ - 0 |
| 3) Kickoff Meeting | Per meeting | $ - 0 | 1 | $ - 0 | $ - 0 | $ - 0 | |||||
| 4) CPUC Meetings | Per meeting | $ - 0 | 24 | 24 | 24 | 24 | $ - 0 | 24 | $ - 0 | 24 | $ - 0 |
| 5) Stakeholder Workshops and Webinars | Per event | $ - 0 | 4 | 4 | 4 | 4 | $ - 0 | 4 | $ - 0 | 4 | $ - 0 |
| 6) Updated Capacity Expansion Model and Inputs & Assumptions | Per update | $ - 0 | 1 | 1 | 1 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 |
| 7) Resource Potential, Land-Use, Transmission, and Busbar Mapping | |||||||||||
| a. Assessment 1 | Per assessment | $ - 0 | 1 | 1 | $ - 0 | 1 | $ - 0 | $ - 0 | |||
| b. Assessment 2 | Per assessment | $ - 0 | 1 | 1 | $ - 0 | 1 | $ - 0 | $ - 0 | |||
| c. Assessment 3 | Per assessment | $ - 0 | 1 | 1 | $ - 0 | 1 | $ - 0 | $ - 0 | |||
| d. Assessment 4 | Per assessment | $ - 0 | 1 | 1 | $ - 0 | 1 | $ - 0 | $ - 0 | |||
| e. Assessment 5 | Per assessment | $ - 0 | 1 | 1 | $ - 0 | 1 | $ - 0 | $ - 0 | |||
| 8) IRP Scenarios and Other Analysis Design Frameworks | Per submission | $ - 0 | 1 | 1 | $ - 0 | $ - 0 | 1 | $ - 0 | |||
| 9) State and Commission Priority Analyses | |||||||||||
| a. Assessment 1 | Per analysis | $ - 0 | 1 | 1 | $ - 0 | 1 | $ - 0 | $ - 0 | |||
| b. Assessment 2 | Per analysis | $ - 0 | 1 | 1 | $ - 0 | 1 | $ - 0 | $ - 0 | |||
| c. Assessment 3 | Per analysis | $ - 0 | 1 | 1 | $ - 0 | 1 | $ - 0 | $ - 0 | |||
| d. Assessment 4 | Per analysis | $ - 0 | 1 | 1 | $ - 0 | 1 | $ - 0 | $ - 0 | |||
| e. Assessment 5 | Per analysis | $ - 0 | 1 | 1 | $ - 0 | 1 | $ - 0 | $ - 0 | |||
| f. Assessment 6 | Per analysis | $ - 0 | 1 | 1 | $ - 0 | 1 | $ - 0 | $ - 0 | |||
| 10) Technical, Policy, and Program Research and Evaluations | Per update | $ - 0 | 1 | 1 | 1 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 |
| 11) Capacity Expansion Model Runs, Results, Reports, and Preferred Sysm Plan, Transmission Planning Process Modeling Support | Per update | $ - 0 | 1 | 1 | $ - 0 | $ - 0 | 1 | $ - 0 | |||
| 12) Supporting Transmission and Interconnection Planning | Per submission | $ - 0 | 1 | 1 | $ - 0 | 1 | $ - 0 | $ - 0 | |||
| 13) Proposer-Defined Studies | Per submission | $ - 0 | 3 | 3 | 3 | 3 | $ - 0 | 3 | $ - 0 | 3 | $ - 0 |
| 14) Support Integrated Resource Planning, Policies, Practices & Regulatory Oversight | Per submission | $ - 0 | 1 | 1 | 1 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 |
| 17) Contract Closeout | Per Closeout | $ - 0 | 1 | $ - 0 | $ - 0 | $ - 0 | |||||
| 18) Transition Activities (As described in attachment 17) | Per Transition | $ - 0 | 1 | 1 | $ - 0 | $ - 0 | $ - 0 |
Deliverables With Hourly Rates**
| 15) Analytical and technical support for developing and/or refining RCPPP and IRP Procurement Program implementation tools and programmatic process improvement | Total | $ - 0 | $ - 0 | $ - 0 |
| 16) Unanticpated Tasks | Total | $250,000 | ||
| **Contractor shall bill at proposed hourly rates identified in the "Team Members" worksheet. | ||||
| Total Propsosal Costs Years 1-4 | $ | |||
| Proposal Cost Optional Year 5 | $ | |||
| Proposal Cost Optional Year 6 | $ |
File details come from the government source that posted it. Updated .