J.P-9 Cost-Price Template (Amd 0009).xlsx
XLSX spreadsheet 26 KB Posted
- Solicitation number
- 47QRCA23R0001-P2
- Issued by
-
GSA Federal Acquisition Service
About this file
This is a Cost-Price Template (Amendment 0009) for the OASIS+ Total Small Business Set-Aside solicitation (47QRCA23R0001). The template is an Excel-based pricing tool that offerors must use to submit labor rates and associated costs for the OASIS+ indefinite-delivery, indefinite-quantity (IDIQ) multiple-award contract vehicle. Offerors are required to enter their official legal entity name and SAM UEID, establish their indirect cost rate structure (including Fringe Benefits, Overhead, and G&A), and populate direct labor rates for up to 20 predefined labor categories identified by Standard Occupational Classification (SOC) codes. The labor categories span professional disciplines including engineers, managers, analysts, specialists, instructors, and technicians. The template includes pre-populated formulas for applying indirect rates to direct labor costs at specified allocation bases, with a fixed 4.41% annual escalation factor automatically applied to generate loaded hourly rates for contract years 1 through 15. Offerors with alternative indirect rate structures may customize up to 10 additional indirect cost pools and modify the allocation base formulas, provided they submit a detailed Basis of Estimate explanation. All profit percentages must be entered as rounded percentages to two decimal places. The template prohibits changes to the embedded escalation factor and must remain in the original Excel format for compatibility with the OASIS+ Submission Portal (OSP). This template supports rolling admissions submissions for multiple domains, with award notifications and formal contract issuance occurring on an ongoing basis following apparent awardee determinations.
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 .