Attachment 5 Sample Streamlined Rates.xlsx
XLSX spreadsheet 26 KB Posted
- Solicitation number
- N6893619R0023
About this file
This document contains a sample rate sheet template and instructions for a Level of Effort contract opportunity with the Department of the Navy for engineering services and software support for AN/ALQ-165 and AN/ALQ-214 Radio Frequency Jammer systems. The rate sheet templates include columns for government labor categories and composite proposed burdened labor rates for prime and subcontractor costs by performance year. A separate section includes a fee rate per hour for non-performance work and a fee percentage for performance-based work. The opportunity will be awarded on a sole-source basis to Harris Corporation, the original equipment manufacturer, as no other source possesses the required capabilities to provide the engineering services and software support products. The pre-solicitation notice was posted on August 20, 2019, and contractors must register with Defense Logistics Information Services to access controlled unclassified information on the Federal Business Opportunities website for opportunity details.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 19R0023 Amendment 2.docx | DOCX document | |
| 19R0023 Amendment.docx | DOCX document | |
| Attachment 4 Sample Cost Spreadsheet.xlsx | XLSX spreadsheet | |
| 19R0023 Solicitation.docx | DOCX document |
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
| Applicable to all worksheets except the worksheet titled "B2 Fee" | ||
| Column | Column Heading | Description of Data Under this Column Heading |
| A | Government Labor Category | The Government Labor Categories correlating to Section C of the Government solicitation. |
| B-F | Composite Proposed Burdened Rate, Years 1 - 5 | Enter the Composite Burdened Labor Rate per Hour proposed for each labor category during the applicable performance year (1-5) of the ordering period. Enter numbers only, in U.S. dollar format ($###.##) rounded to the nearest cent. Burdened Labor Rates shall include direct labor rates plus all applicable burdens, to include indirect rates, subcontractor fee on subcontractor labor, and subcontractor pass-through costs (exclusive of prime fee on subcontractor's labor), but shall not include prime fee on prime labor, prime fee on subcontractor labor, Foreign-area Allowance, Other Direct Costs (ODCs) such as Travel and Material, and Cost of Money costs (if proposed). The Composite Burdened Labor Rate per hour would be the sum of both the prime and all subcontractors labor costs, as described above, for that labor category divided by the total number of labor hours for that labor category. These Composite Burdened Labor Rates will be incorporated into Section B of the contract for the establishment of streamlined task orders. The Government will utilize the rates when developing estimated labor ceilings for orders by using the estimated hours multiplied by the composite rates found in Section B. |
| NOTE: If Option CLINs are exercised IAW 52.217-8, Year 5 Composite Burdened Rates will be utilized. | ||
| Applicable to only the worksheet titled "B2 Fee" | ||
| Column | Row and Row Heading | Description of Data Under this Column Heading |
| B | 4, Non-Performance Based (Level of Effort) | Enter the fee per hour based on the total fee proposed for all ordering periods divided by the total number of hours for all ordering periods. |
| B | 9, Performance Based (Completion) | Enter the fixed fee percentage based on the total fee proposed for all ordering periods divided by the total proposed costs for all ordering periods. |
&10Instructions to Prime Contractors for completing Attachment P3 Burdened Rates Worksheet N68936-19-R-0023
LOE - (Contractor) Onsite
CPFF LOE
CONTRACTOR (ONSITE)
| Composite Proposed Burdened Rate | ||||||
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | 6 - month Option | |
| Government Labor Category | ||||||
| Engineering Labor Category |
| SR SOFTWARE ENG-LVL 6 |
| PROGRAM MGR-LVL 5 |
| SOFTWARE ENG-LVL 5 |
| SYS ENG-LVL 5 |
| ENG-LVL 4 |
| SYS ENG-LVL 4 |
| QA SOFTWARE ENG-LVL 4 |
| FINANCE SUPPORT-LVL 4 |
| SYS ENG-LVL 3 |
| CM-LVL 4 |
| ENG-LVL 1 |
| FINANCE SUPPORT-LVL 3 |
| SECURITY-LVL 1 |
| SYS ADMIN ENG-LVL 4 |
| SYS ADMIN ENG-LVL 6 |
| SYS ENG-LVL 1 |
| SYS ENG-LVL 2 |
| SOFTWARE ENG-LVL 3 |
| SOFTWARE ENG-LVL 5 |
Manufacturing AV Labor
| MFG MGR PM LVL 7 |
| MFG MGR PROJECT LEAD LVL 6 |
| MFG MGR ENG LVL 5 |
| MFG QA LVL 4 |
| MFG PROCUREMENT LVL 4 |
| MFG ENG SERVICES LVL 3 |
| MFG ENG SERVICES LVL 5 |
| MFG INSPECTION LVL U6 |
| MECHANICAL ENG LVL 6 |
| MFG ASSEMBLY LVL D6 |
| MFG PROCUREMENT LVL3 |
Solicitation N00421-19-R-0069 Attachment P3
LOE - (Gov't) Offsite
CPFF LOE
GOVERNMENT (OFFSITE)
| Composite Proposed Burdened Rate | ||||||
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | 6 - month Option | |
| Government Labor Category | ||||||
| Engineering Labor Category |
| SR SOFTWARE ENG-LVL 6 |
| PROGRAM MGR-LVL 5 |
| SOFTWARE ENG-LVL 5 |
| SYS ENG-LVL 5 |
| ENG-LVL 4 |
| SYS ENG-LVL 4 |
| QA SOFTWARE ENG-LVL 4 |
| FINANCE SUPPORT-LVL 4 |
| SYS ENG-LVL 3 |
| CM-LVL 4 |
| ENG-LVL 1 |
| FINANCE SUPPORT-LVL 3 |
| SECURITY-LVL 1 |
| SYS ADMIN ENG-LVL 4 |
| SYS ADMIN ENG-LVL 6 |
| SYS ENG-LVL 1 |
| SYS ENG-LVL 2 |
| SOFTWARE ENG-LVL 3 |
| SOFTWARE ENG-LVL 5 |
Manufacturing AV Labor
| MFG MGR PM LVL 7 |
| MFG MGR PROJECT LEAD LVL 6 |
| MFG MGR ENG LVL 5 |
| MFG QA LVL 4 |
| MFG PROCUREMENT LVL 4 |
| MFG ENG SERVICES LVL 3 |
| MFG ENG SERVICES LVL 5 |
| MFG INSPECTION LVL U6 |
| MECHANICAL ENG LVL 6 |
| MFG ASSEMBLY LVL D6 |
| MFG PROCUREMENT LVL3 |
Solicitation N00421-19-R-0069 Attachment P3
B2 Fee
FEE
| Fee Per Hour | |
| Non-Performance Based (Level of Effort) |
| Fee Percentage | |
| Performance Based (Completion) |
File details come from the government source that posted it. Updated .