J.P-9 Cost-Price Template (Amd 0009).xlsx
XLSX spreadsheet 26 KB Posted
- Solicitation number
- 47QRCA23R0002-P2
- Issued by
-
GSA Federal Acquisition Service
About this file
This is a Cost-Price Template (Amendment 0009) instruction document for the OASIS+ 8(a) Small Business Set-Aside indefinite-delivery, indefinite-quantity (IDIQ) multi-agency contract solicitation issued by the General Services Administration (GSA). The template is a spreadsheet submission requirement for pricing proposals under this continuously open solicitation.
The template requires offerors to input their official legal entity name and SAM UEID, establish indirect cost pool structures (fringe benefits, overhead, and G&A), and provide direct labor rates for 20 predefined labor categories including engineers, managers, analysts, accountants, specialists, and other professional occupations. Offerors must enter direct labor rates rounded to two decimal places and specify profit percentages; the template automatically calculates fully burdened hourly rates by applying indirect cost multipliers to appropriate allocation bases. The spreadsheet includes pre-populated formulas applying fringe benefits to direct labor, overhead to the sum of direct labor and fringe benefits, G&A to total cost input, and profit to total costs. Offerors with different indirect rate structures may customize the template by editing cost pool names and formulas, with capability to add up to ten additional indirect rate columns. An embedded 4.41% annual escalation factor automatically calculates ceiling rates for Years 1 through 15 based on Bureau of Labor Statistics Economic Cost Index data; offerors cannot modify this escalation rate. Offerors must provide detailed explanations of their indirect cost rates and allocation bases in the Basis of Estimate section per RFP Section L.5.7.3. The document cautions that adding/deleting rows or columns or converting to other software formats will compromise compatibility with the OASIS+ Submission Portal (OSP) used for proposal submission.
View the file
Other files
Show all 36
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
| L.5.7.2 - Cost/Price Template Instructions | ||
| Amendment 0009 | ||
| Introduction: Offerors are highly recommended to review the entire solicitation, with a strong emphasis on Sections L and M of the RFP. Section L details the instructions to Offerors while Section M details the evaluation factors for award. | ||
| Row(s) | Column | Instruction |
| 4 | C | Enter the Official Legal Offering Entity Name. |
| 5 | C | Enter the Official Legal Offering Entity's SAM UEID. |
| 7 and 8 | D through P | In Row 7, the template has been pre-populated with Fringe Benefits, Overhead, and G&A indirect cost pool names. Offerors with a different indirect rate structure than that included in Row 7 are able to edit the indirect cost pool names and are provided with ten additional columns to include additional indirect rate(s), Columns D through P, as applicable. |
In Row 8, enter indirect rate percentages, rounded to two decimal places, for each indirect cost pool included in the Offeror's indirect rate structure applicable to the proposed direct labor rates.
For example, if an Offeror has two Overhead cost pools/rates included in their indirect rate structure, the Offeror will insert the name of each Overhead cost pool/rate into Row 7, within Columns D through P, and will enter the applicable indirect rate percentage into the corresponding column in Row 8. If the Offeror does not have a separate Fringe Benefits final indirect cost pool/rate, the Offeror may remove that indirect cost pool name from Row 7 and rename to an indirect cost pool that is included in the Offeror's indirect rate structure.
If an Offeror has a total of more than 13 indirect cost pools/rates, it may combine (i.e., wrap) multiple indirect rates into a column. A description of each of the rates and an explanation for combining them must be provided in the Basis of Estimate. See RFP Section L.5.7.3.
| 8 | Q | Enter the profit percentage. |
| 9-28 | C | Enter direct labor rates for all 20 labor categories, rounded to two decimal places. |
| 9-28 | D through R | The template has been pre-populated with the following formulas: Fringe Benefits applied to Direct Labor; Overhead applied to the sum of Direct Labor and Fringe Benefits; G&A applied to the sum of Direct Labor, Fringe Benefits, and Overhead (i.e, a Total Cost Input allocation base); and Profit applied to the sum of Direct Labor, Fringe Benefits, Overhead, and G&A. Offerors with a different indirect rate structure than that pre-populated in the template have the ability to edit the formulas to apply their actual indirect rates to the appropriate allocation bases. A description of each of the rates and their allocation bases must be provided in the Basis of Estimate. See RFP Section L.5.7.3. |
| Escalation: Sole source T&M/LH ceiling rates for Years 1 through 15 will automatically be calculated for each labor category by applying an escalation factor of 4.41%, which is embedded in the spreadsheet. Escalation is included in the Year 1 fully burdened (i.e., loaded) hourly labor rates to allow sufficient time for proposal evaluation between proposal submission and awards. This escalation factor is based on the average of the annual Bureau of Labor Statistics Economic Cost Index (Wages and salaries for Private industry workers in All industries and occupations, 12-month percent change) for the previous three years. Offerors shall not change the escalation factor in the spreadsheet. | ||
| Caution: Adding/deleting rows or columns, or converting this spreadsheet to other software programs or formats will affect compatibility with the OASIS+ Submission Portal (OSP) (Symphony) pricing module. |
Cost-Price Template
| ATTACHMENT J.P-9 - COST/PRICE TEMPLATE |
| This attachment is in support of the OASIS+ solicitation. |
| See instructions in RFP Section L.5.7.2. |
| OFFEROR: |
| SAM UEID: |
Labor SOC Number OASIS+ Labor Category Direct Labor Rate Fringe Benefits Overhead G&A Add'l Indirect Rate #1 (Optional) Add'l Indirect Rate #2 (Optional) Add'l Indirect Rate #3 (Optional) Add'l Indirect Rate #4 (Optional) Add'l Indirect Rate #5 (Optional) Add'l Indirect Rate #6 (Optional) Add'l Indirect Rate #7 (Optional) Add'l Indirect Rate #8 (Optional) Add'l Indirect Rate #9 (Optional) Add'l Indirect Rate #10 (Optional) Profit Year 1 Loaded Hourly Labor Rate Year 2 Loaded Hourly Labor Rate Year 3 Loaded Hourly Labor Rate Year 4 Loaded Hourly Labor Rate Year 5 Loaded Hourly Labor Rate Year 6 Loaded Hourly Labor Rate Year 7 Loaded Hourly Labor Rate Year 8 Loaded Hourly Labor Rate Year 9 Loaded Hourly Labor Rate Year 10 Loaded Hourly Labor Rate Year 11 Loaded Hourly Labor Rate Year 12 Loaded Hourly Labor Rate Year 13 Loaded Hourly Labor Rate Year 14 Loaded Hourly Labor Rate Year 15 Loaded Hourly Labor Rate
| 17-2199 | Engineers, All Other (SME) | $0.00 | $0.00 | $0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 11-9199 | Managers, All Other (SME) | $0.00 | $0.00 | $0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 13-1111 | Management Analysts (SME) | $0.00 | $0.00 | $0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 15-2031 | Operations Research Analysts (SME) | $0.00 | $0.00 | $0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 13-1199 | Business Operations Specialists, All Other (SME) | $0.00 | $0.00 | $0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 11-3012 | Administrative Services Managers (SME) | $0.00 | $0.00 | $0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 11-1021 | General and Operations Managers (SME) | $0.00 | $0.00 | $0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 13-2011 | Accountants and Auditors (SME) | $0.00 | $0.00 | $0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 13-2099 | Financial Specialists, All Other (SME) | $0.00 | $0.00 | $0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 13-1151 | Training and Development Specialists (SME) | $0.00 | $0.00 | $0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 43-6011 | Executive Secretaries and Executive Administrative Assistants (SME) | $0.00 | $0.00 | $0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 13-1081 | Logisticians (SME) | $0.00 | $0.00 | $0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 13-2051 | Financial and Investment Analysts (SME) | $0.00 | $0.00 | $0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 11-3131 | Training and Development Managers (SME) | $0.00 | $0.00 | $0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 25-3099 | Teachers and Instructors, All Other (SME) | $0.00 | $0.00 | $0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 13-1071 | Human Resources Specialists (SME) | $0.00 | $0.00 | $0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 49-9071 | Maintenance and Repair Workers (SME) | $0.00 | $0.00 | $0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 19-2041 | Environmental Scientists and Specialists, Including Health (SME) | $0.00 | $0.00 | $0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 19-3099 | Social Scientists and Related Workers (SME) | $0.00 | $0.00 | $0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 27-3031 | Public Relations Specialists (SME) | $0.00 | $0.00 | $0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
File details come from the government source that posted it. Updated .