ATTACHMENT E PRICE AND COST OFFER FORM V4.xlsm

75 KB Posted

Attached to
Agency RFP 25-054 Natural Climate Solutions and Metrics Analysis in Oregon
Solicitation number
S-33000-00014253
Issued by
Oregon

About this file

Written by GovTribe AI ·

This is a Price and Cost Offer Form (Attachment E) for the Oregon Buys Solicitation No. S-33000-00014253, Agency RFP 25-054 for Natural Climate Solutions and Metrics Analysis in Oregon. The project involves a comprehensive 12-task scope of work spanning from May 19, 2025, to October 31, 2025, focusing on developing climate solutions metrics and analysis. Key deliverables include project management memos, kick-off presentations, engagement and interview processes, compilation of existing Interagency Working Group (IWG) programs, development of a Natural Climate Solutions (NCS) data and methods library, factsheets, feasibility assessments, carbon contribution estimates, a public webinar, and a final report.

The pricing document is structured as an Excel spreadsheet with multiple tabs for budgeting, project team details, scheduling, and deliverables. The form is designed for bidders to input hourly rates, personnel hours, and task-specific costs, with most calculation cells auto-populated. Currently, the document shows placeholder values of $1 per hour and zero hours allocated, indicating it is a template awaiting specific pricing and staffing details. The pricing structure allows for primary proposers and sub-consultants, with flexibility for detailing personnel roles, hours, and associated costs across the 12 project tasks.

View the file

Other files

File Type Posted
ATTACHMENT F COBID CERTIFICATION.OUTREACH PLAN~1.docx DOCX document
25-054 NCS and Metrics RFP~2.pdf PDF
ATTACHMENT D REFERENCE CHECK FORM~1.docx DOCX document
ATTACHMENT B DISCLOSURE EXEMPTION AFFIDAVIT FORM~1.docx DOCX document
ATTACHMENT G RESPONSIBILITY INQUIRY~1.docx DOCX document
ATTACHMENT C OFFEROR INFORMATION AND CERTIFICATION SHEET~2.docx DOCX document
ATTACHMENT H AGENCY EXAMPLE LIST OF NATURAL CLIMATE SOLUTIONS~1.pdf PDF
ATTACHMENT A SAMPLE CONTRACT FINAL 2~1.pdf PDF

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Instructions

Instructions for Using the Price and Cost Offer Form - Resource Allocation and Cost Effectiveness Cost Sheet (Attachment E)
Only the Budget tab and Project Team tabs are required for submittal
The other tabs are optional but you may find them useful
Only fill in the gray colored cells. All the other cells are formulas and should not be altered
Budget tab: (Required)
Fill in the name of Key Personnel on row 3 (including sub-consultants) in the gray colored cells
Fill in the hourly rate for each Key Personnel on row 5 (including sub-consultants) in the gray colored cells
Fill in the total number of hours by deliverable that each person will spend doing that task in the gray colored cells
Subtotals and Totals cells in rows and columns (non-gray colored cells) will calculate automatically by formula
Budget Summary tab: (Required)
This table will auto-populate with the data you enter in the Budget tab - there is no manual entry required
Project Team tab: (Required)
Most of this table will auto-populate from the data that you enter in the Budget tab
The only part of the table that you will need to fill in is the Role of Key Personnel in the gray colored cells in Column F
Schedule tab: (NOT Required)
Filling in the Schedule tab is optional, but you can chose to use the Schedule tab for your own purposes and include it with your proposal
The Deliverables and their titles auto-populate from the data that you enter in the Budget tab
Filling in the Schedule tab cells is done manually
For each week when that deliverable will be worked on color the cell blue
Once the entire task schedule is complete add an "a" in the Task row and color it green
Add an "X" to the schedule to approximate the due date of the deliverable (this will be helpful in creating the Deliverables & Milestones tab
Summary Schedule tab: (NOT Required)
Filling in the Summary Schedule tab is optional, but you can chose to use the Summary Schedule tab for your own purposes and include it with your proposal
The Deliverables and their titles auto-populate from the data that you enter in the Budget tab
Filling in the Summary Schedule tab cells is only partially auto-populated
The "a" entered in the Schedule tab will appear in the Summary Schedule tab
For each week where an "a" appears color the cell green
Deliverables tab: (NOT Required)
Filling in the Deliverables tab is optional, but you can chose to use the Deliverables tab for your own purposes and include it with your proposal
The Deliverable (column B) and the Title (column C) are auto-populated from the data that you entered in the Budget tab
You may fill in the gray colored cells manually
Using the "X" from the deliverable dates previously entered into the Schedule tab estimate the due date of the deliverable and enter the due date in XX/XX/XX format
Add the Lead for the deliverable from the list of Key Personnel in column E
You may add descriptive notes for the deliverable in column F

Budget Attachment E, Price and Cost Offer Oregon Buys Solicitation No. S-33000-00014253;

Agency RFP 25-054 Natural Climate Solutions and Metrics Analysis in Oregon

Hourly Breakdown Per Person per Task/Subtask
Key Personnel Name:Name1Name2Name3Name4Name5Name6Name7Name8Name9Name10Name11Name12Name13Name14Total PrimarySubconsultant Name1Subconsultant Name2Subconsultant Name3Subconsultant Name4Total Sub-consultantsTotal Project
Classification:Total PrimaryTotal PrimarySub-consultantSub-consultantSub-consultantSub-consultantSub-consultantSub-consultantSub-consultantSub-consultantTotal Sub-consultantsTotal Sub-consultantsTotal ProjectTotal Project
Hourly Rate:$1$1$1$1$1$1$1$1$1$1$1$1$1$1HoursCostHours$1Hours$1Hours$1Hours$1HoursCostHoursCost
Task 1:Project Management
Deliverable 1.1Project Management Memo and Deliverable Schedule0$0$0$0$0$00$00$0
Deliverable 1.2Weekly Virtual Project Management Meetings0$0$0$0$0$00$00$0
Task 1 - Subtotal000000000000000$00$00$00$00$00$00$0
Task 2:Kick-off Meeting
Deliverable 2.1Draft Kick-Off PowerPoint Presentation0$0$0$0$0$00$00$0
Deliverable 2.2Final Kick-Off PowerPoint Presentation0$0$0$0$0$00$00$0
Task 2 - Subtotal000000000000000$00$00$00$00$00$00$0
Task 3:Project Approach
Deliverable 3.1Draft Project Approach and PowerPoint0$0$0$0$0$00$00$0
Deliverable 3.2Draft List of Non-IWG Agency Interviewees0$0$0$0$0$00$00$0
Deliverable 3.3Final Project Approach0$0$0$0$0$00$00$0
Deliverable 3.4Final List of Non-IWG Interviewees0$0$0$0$0$00$00$0
Task 3 - Subtotal000000000000000$00$00$00$00$00$00$0
Task 4:Engagement and Interviews
Deliverable 4.1Engagement Planning Meetings and PowerPoint0$0$0$0$0$00$00$0
Deliverable 4.2Feedback Group Meetings0$0$0$0$0$00$00$0
Deliverable 4.3Meeting Summary Notes0$0$0$0$0$00$00$0
Deliverable 4.4Conduct Interviews and Maintain Interview Spreadsheet w/ Summaries0$0$0$0$0$00$00$0
Deliverable 4.5Feedback Memo0$0$0$0$0$00$00$0
Task 4 - Subtotal000000000000000$00$00$00$00$00$00$0
Task 5:Compilation of Existing IWG Programs and Related Metrics
Deliverable 5.1Preliminary Compilation of IWG Programs and Metrics0$0$0$0$0$00$00$0
Deliverable 5.2Preliminary Compilation of ABMs and CIMs from Other States0$0$0$0$0$00$00$0
Deliverable 5.3Compilation Planning Meeting and Power Point0$0$0$0$0$00$00$0
Deliverable 5.4IWG Workshops0$0$0$0$0$00$00$0
Deliverable 5.5Draft Final Compilation of Existing IWG Programs and Metrics and other ABMs and CIMs0$0$0$0$0$00$00$0
Deliverable 5.6Submittal of Final Compilation0$0$0$0$0$00$00$0
Task 5 - Subtotal000000000000000$00$00$00$00$00$00$0
Task 6:NCS Data and Methods Library
Deliverable 6.1Draft Data and Methods Library0$0$0$0$0$00$00$0
Deliverable 6.2Final NCS Data and Methods Library0$0$0$0$0$00$00$0
Deliverable 6.3NCS Data and Methods Library Memo0$0$0$0$0$00$00$0
Task 6 - Subtotal000000000000000$00$00$00$00$00$00$0
Task 7:Oregon NCS Factsheets
Deliverable 7.1Draft NCS Factsheet Template0$0$0$0$0$00$00$0
Deliverable 7.2Draft NCS Factsheets0$0$0$0$0$00$00$0
Deliverable 7.3Final NCS Factsheets0$0$0$0$0$00$00$0
Task 7 - Subtotal000000000000000$00$00$00$00$00$00$0
Task 8:Feasibility Assessment
Deliverable 8.1Draft NCS Feasibility Assessment0$0$0$0$0$00$00$0
Deliverable 8.2Final NCS Feasibility Assessment0$0$0$0$0$00$00$0
Task 8 - Subtotal000000000000000$00$00$00$00$00$00$0
Task 9:NCS Carbon Contributions and Community Impact Estimates
Deliverable 9.1Draft Estimates0$0$0$0$0$00$00$0
Deliverable 9.2Final Estimates0$0$0$0$0$00$00$0
Task 9 - Subtotal000000000000000$00$00$00$00$00$00$0
Task 10:Public Webinar
Deliverable 10.1Planning and Participation in Public Webinar0$0$0$0$0$00$00$0
Deliverable 10.2Public Input Memo0$0$0$0$0$00$00$0
Deliverable 10.3Public Input and Webinar Debrief and Final Report Planning0$0$0$0$0$00$00$0
Task 10 - Subtotal000000000000000$00$00$00$00$00$00$0
Task 11:Final Report
Deliverable 11.1Draft Final Report0$0$0$0$0$00$00$0
Deliverable 11.2Final Report0$0$0$0$0$00$00$0
Task 11 - Subtotal000000000000000$00$00$00$00$00$00$0
Task 12:Goals Workshop with Agency
Deliverable 12.1Goals Workshop with Agency0$0$0$0$0$00$00$0
Deliverable 12.2Review of Agency Staff Report0$0$0$0$0$00$00$0
Task 12 - Subtotal0000000000000000000000000000
Project Total000000000000000$00$00$00$00$00$00$0

&Z&F _x000D_&1#&"Calibri"&10&K000000 Level 3 - Restricted &D

Budget Summary Attachment E, Price and Cost Offer Oregon Buys Solicitation No. S-33000-00014253;

Agency RFP 25-054 Natural Climate Solutions and Metrics Analysis in Oregon

Budget Summary
This Table is Auto-Populated; no need for manual entry!
TaskTask TitleHoursBudget Amount
Task 1:Project Management0$0
Task 2:Kick-off Meeting0$0
Task 3:Project Approach0$0
Task 4:Engagement and Interviews0$0
Task 5:Compilation of Existing IWG Programs and Related Metrics0$0
Task 6:NCS Data and Methods Library0$0
Task 7:Oregon NCS Factsheets0$0
Task 8:Feasibility Assessment0$0
Task 9:NCS Carbon Contributions and Community Impact Estimates0$0
Task 10:Public Webinar0$0
Task 11:Final Report0$0
Task 12:Goals Workshop with Agency0$0
Consultant Fees0$ - 0
Total

Check (should be 0) 0 $0

_x000D_&1#&"Calibri"&10&K000000 Level 3 - Restricted

Project Team Attachment E, Price and Cost Offer Oregon Buys Solicitation No. S-33000-00014253;

Agency RFP 25-054 Natural Climate Solutions and Metrics Analysis in Oregon

Project Team
Primary ProposerThis Table is Auto-Populated; no need for manual entry, except for "Role" in column G!

tc={36C5103C-6790-4AA5-B182-75CFF7965A12}: [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:

This is column F - may want to changeKey Personnel NameHours% of Total Project Hours$/HourTotal $Role
Name10ERROR:#DIV/0!$1$0
Name20ERROR:#DIV/0!$1$0
Name30ERROR:#DIV/0!$1$0
Name40ERROR:#DIV/0!$1$0
Name50ERROR:#DIV/0!$1$0
Name60ERROR:#DIV/0!$1$0
Name70ERROR:#DIV/0!$1$0
Name80ERROR:#DIV/0!$1$0
Name90ERROR:#DIV/0!$1$0
Name100ERROR:#DIV/0!$1$0
Name110ERROR:#DIV/0!$1$0
Name120ERROR:#DIV/0!$1$0
Name130ERROR:#DIV/0!$1$0
Name140ERROR:#DIV/0!$1$0
TOTAL0ERROR:#DIV/0!$0
Consultants
Key Personnel NameHours% of Total Project Hours$/HourTotal $Role
Subconsultant Name10ERROR:#DIV/0!$1$0
Subconsultant Name20ERROR:#DIV/0!$1$0
Subconsultant Name30ERROR:#DIV/0!$1$0
Subconsultant Name40ERROR:#DIV/0!$1$0
TOTAL0ERROR:#DIV/0!$0

_x000D_&1#&"Calibri"&10&K000000 Level 3 - Restricted

Schedule

ScheduleDetailed Schedule(Manually input range of dates with blue color infill in Subtask rows, input # of weeks for each task starting with 1 in Task row and color green)
Start DateMonday5/19/25

tc={B857CFD3-38CE-4243-B9E3-B3C1AE2B4403}: [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:

Date should start on the MONDAY of the first week!X = Meeting Date, Deliverable Date, or Milestone
End Date10/31/25On each Task Row, enter an "a" in each week of the task and color green.
Week Ending5/195/266/26/96/166/236/307/77/147/217/288/48/118/188/259/19/89/159/229/2910/610/1310/2010/27
Period123456789101112131415161718192021222324
Task 1:Project Managementaaaaaaaaaaaaaaaaaaaaaaaa
Deliverable 1.1Project Management Memo and Deliverable Schedule
Deliverable 1.2Weekly Virtual Project Management Meetings
Task 1 - Subtotal0.0
Task 2:Kick-off Meeting
Deliverable 2.1Draft Kick-Off PowerPoint Presentation
Deliverable 2.2Final Kick-Off PowerPoint Presentation
Task 2 - Subtotal0.0
Task 3:Project Approach
Deliverable 3.1Draft Project Approach and PowerPoint
Deliverable 3.2Draft List of Non-IWG Agency Interviewees
Deliverable 3.3Final Project Approach
Deliverable 3.4Final List of Non-IWG Interviewees
Task 3 - Subtotal0.0
Task 4:Engagement and Interviews
Deliverable 4.1Engagement Planning Meetings and PowerPoint
Deliverable 4.2Feedback Group Meetings
Deliverable 4.3Meeting Summary Notes
Deliverable 4.4Conduct Interviews and Maintain Interview Spreadsheet w/ Summaries
Deliverable 4.5Feedback Memo
ERROR:#REF!
Task 12:
Task 5:Compilation of Existing IWG Programs and Related Metrics
Deliverable 5.1Preliminary Compilation of IWG Programs and Metrics
Deliverable 5.2Preliminary Compilation of ABMs and CIMs from Other States
Deliverable 5.3Compilation Planning Meeting and Power Point
Deliverable 5.4IWG Workshops
Deliverable 5.5Draft Final Compilation of Existing IWG Programs and Metrics and other ABMs and CIMs
Deliverable 5.6Submittal of Final Compilation
Task 6:NCS Data and Methods Library
Deliverable 6.1Draft Data and Methods Library
Deliverable 6.2Final NCS Data and Methods Library
Deliverable 6.3NCS Data and Methods Library Memo
Task 7:Oregon NCS Factsheets
Deliverable 7.1Draft NCS Factsheet Template
Deliverable 7.2Draft NCS Factsheets
Deliverable 7.3Final NCS Factsheets
Task 8:Feasibility Assessment
Deliverable 8.1Draft NCS Feasibility Assessment
Deliverable 8.2Final NCS Feasibility Assessment
Task 9:NCS Carbon Contributions and Community Impact Estimates
Deliverable 9.1Draft Estimates
Deliverable 9.2Final Estimates
Task 10:Public Webinar
Deliverable 10.1Planning and Participation in Public Webinar
Deliverable 10.2Public Input Memo
Deliverable 10.3Public Input and Webinar Debrief and Final Report Planning
Task 11:Final Report
Task 11:Final Report
Deliverable 11.1Draft Final Report
Task 12:Goals Workshop with Agency
Deliverable 12.1Goals Workshop with Agency
Deliverable 12.2Review of Agency Staff Report

_x000D_&1#&"Calibri"&10&K000000 Level 3 - Restricted

Summary Schedule

Summary Schedule(Manually fill color green the range of cells that show an "a")
TaskTask Title Week Ending5/195/266/26/96/166/236/307/77/147/217/288/48/118/188/259/19/89/159/229/2910/610/1310/2010/27
Task 1:Project Management

tc={6B42AC82-F481-4910-8DC5-A95E6D8F17CA}: [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:

Not exactly as listed in Attachment A, order is the same, wording is slightly different. Not sure how specific we are being?aaaaaaaaaaaaaaaaaaaaaaaa
Task 2:Kick-off Meeting000000000000000000000000
Task 3:Project Approach000000000000000000000000
Task 4:Engagement and Interviews000000000000000000000000
Task 5:Compilation of Existing IWG Programs and Related Metrics000000000000000000000000
Task 6:NCS Data and Methods Library000000000000000000000000
Task 7:Oregon NCS Factsheets000000000000000000000000
Task 8:Feasibility Assessment000000000000000000000000
Task 9:NCS Carbon Contributions and Community Impact Estimates000000000000000000000000
Task 10:Public Webinar000000000000000000000000
Task 11:Final Report000000000000000000000000
Task 12:Goals Workshop with Agency000000000000000000000000

_x000D_&1#&"Calibri"&10&K000000 Level 3 - Restricted

Deliverables

Deliverables- due dates and leads
OrderDeliverableTitleDue DateLeadDescription/Notes
1Deliverable 1.1Project Management Memo and Deliverable Schedule
2Deliverable 1.2Weekly Virtual Project Management Meetings
5Deliverable 2.1Draft Kick-Off PowerPoint Presentation
6Deliverable 2.2Final Kick-Off PowerPoint Presentation
7Deliverable 3.1Draft Project Approach and PowerPoint
8Deliverable 3.2Draft List of Non-IWG Agency Interviewees
9Deliverable 3.3Final Project Approach
10Deliverable 3.4Final List of Non-IWG Interviewees
11Deliverable 4.1Engagement Planning Meetings and PowerPoint
12Deliverable 4.2Feedback Group Meetings
13Deliverable 4.3Meeting Summary Notes

tc={EFDBE238-DB91-47F9-AC2E-DB37ADABCAE7}: [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:

If we are nitpicking...This is Meeting Summary Notes in Attachment A ☺️

14Deliverable 4.4Conduct Interviews and Maintain Interview Spreadsheet w/ Summaries
15Deliverable 4.5Feedback Memo
17Deliverable 5.1Preliminary Compilation of IWG Programs and Metrics
18Deliverable 5.2Preliminary Compilation of ABMs and CIMs from Other States
19Deliverable 5.3Compilation Planning Meeting and Power Point
20Deliverable 5.4IWG Workshops
21Deliverable 5.5Draft Final Compilation of Existing IWG Programs and Metrics and other ABMs and CIMs
22Deliverable 5.6Submittal of Final Compilation
21Deliverable 6.1Draft Data and Methods Library
22Deliverable 6.2Final NCS Data and Methods Library
23Deliverable 6.3NCS Data and Methods Library Memo
25Deliverable 7.1Draft NCS Factsheet Template
26Deliverable 7.2Draft NCS Factsheets
27Deliverable 7.3Final NCS Factsheets
28Deliverable 8.1Draft NCS Feasibility Assessment
29Deliverable 8.2Final NCS Feasibility Assessment
31Deliverable 9.1Draft Estimates
32Deliverable 9.2Final Estimates
33Deliverable 10.1Planning and Participation in Public Webinar
34Deliverable 10.2Public Input Memo
35Deliverable 10.3Public Input and Webinar Debrief and Final Report Planning
35Deliverable 11.1Draft Final Report
36Deliverable 11.2Final Report
37Deliverable 12.1Goals Workshop with Agency
38Deliverable 12.2Review of Agency Staff Report

_x000D_&1#&"Calibri"&10&K000000 Level 3 - Restricted

File details come from the government source that posted it. Updated .