Attachment E - Price and Cost Offer Form .xlsm

XLSM spreadsheet 39 KB Posted

Attached to
Home Energy Score Implementation For EECBG
Solicitation number
S-33000-00013460
Issued by
Oregon

About this file

This is an Excel-based Price and Cost Offer Form for the Oregon Buys Solicitation No. S-33000-00013460, specifically for Agency RFP 25-034 Home Energy Scoring for Energy Efficiency and Conservation Block Grant. The document provides a detailed pricing template for bidders to complete, outlining six primary tasks: City Staff Engagement, Plan Development, Training Oregon Home Energy Score Assessors, Pre and Post Score Analysis, Making Home Energy Scores Viewable on Green Building Registry, and producing a Summary Report.

The pricing form requires bidders to input hourly rates and hours for key personnel and subconsultants across the identified tasks, with automatic calculation of subtotals and totals. The template includes tabs for Budget, Budget Summary, and Project Team, with instructions to only fill in gray-colored cells. Currently, the document shows placeholder entries of $1 per hour and zero hours, indicating it is a template awaiting completion by the proposing consultant. The form is designed to capture detailed cost and resource allocation information for the home energy scoring project, allowing for transparent and structured financial proposal submission.

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

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
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)
Please use the data from the Budget Tab to complete the Project Team Tab

Budget Attachment E, Price and Cost Offer | Oregon Buys Solicitation No. S-33000-00013460; Agency RFP 25-034 Home Energy Scoring For Energy Efficiency and Conservation Block Grant

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

tc={A3E9BFA4-B1D0-47EE-84E8-7216D35215F5}: [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 really hard to do with his task/deliverables….Hourly Rate:$1$1$1$1$1$1$1$1$1$1$1$1$1$1HoursCostHours$1Hours$1Hours$1Hours$1HoursCostHoursCost
Task 1:City Staff Engagement
Deliverable 1.10$0$0$0$0$00$00$0
Task 1 - Subtotal000000000000000$00$00$00$00$00$00$0
Task 2:Plan Development
Deliverable 2.10$0$0$0$0$00$00$0
Task 2 - Subtotal000000000000000$00$00$00$00$00$00$0
Task 3:Train Oregon Home Energy Score Assessors
Deliverable 3.10$0$0$0$0$00$00$0
Task 3 - Subtotal000000000000000$00$00$00$00$00$00$0
Task 4:Pre and Post Score Analysis
Deliverable 4.10$0$0$0$0$00$00$0
Task 4 - Subtotal000000000000000$00$00$00$00$00$00$0
Task 5:All Home Energy Scores viewable on Green Building Registry
Deliverable 5.10$0$0$0$0$00$00$0
Task 5 - Subtotal000000000000000$00$00$00$00$00$00$0
Task 6:Summary Report
Deliverable 6.10$0$0$0$0$00$00$0
Project Total000000000000000$00$00$00$00$00$00$0

This is really hard to do with his task/deliverables….

&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-00013460; Agency RFP 25-034 Home Energy Scoring For Energy Efficiency and Conservation Block Grant

Budget Summary
This Table is Auto-Populated; no need for manual entry!
TaskTask TitleHoursBudget Amount
Task 1:City Staff Engagement0$0
Task 2:Plan Development0$0
Task 3:Train Oregon Home Energy Score Assessors0$0
Task 4:Pre and Post Score Analysis0$0
Task 5:All Home Energy Scores viewable on Green Building Registry0$0
Task 6:Summary Report0$0
Consultant Fees0$ - 0
Project Total0$0

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-00013460; Agency RFP 25-034 Home Energy Scoring For Energy Efficiency and Conservation Block Grant

Project Team
Primary Proposer
Key Personnel NameHours% of Total Project Hours$/HourTotal $Role

TOTAL 0 0% $0

Consultant Name:
Company and Consulting PersonnelHours% of Total Project Hours$/HourTotal $Role

TOTAL 0 0% $0

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

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