HSHQDC-17-R-00020_ATTACHMENT_B_PRICE_Template.xlsx
XLSX spreadsheet 28 KB Posted
- Attached to
- Award of HSHQDC-17-R-00020 SETA III
- Solicitation number
- HSHQDC-17-R-00020
About this file
This document contains a price template for a multiple award indefinite delivery indefinite quantity (IDIQ) contract solicitation. The template includes estimated labor hours and labor categories for a full-time equivalent IDIQ manager and various other portfolio, program and project management, budget, graphic design, documentation, technical writing, computer systems, administrative, analyst, engineering, scientific, and subject matter expert positions. Pricing is to be provided as fully burdened hourly rates for labor performed at both government and contractor facilities for a base period of one year and four one-year options. The total estimated price for all labor categories and facilities is provided for each year. The related federal contract opportunity notice indicates the SETA III solicitation is anticipated to be posted between late December 2017 and mid-January 2018. The Department of Homeland Security Office of Procurement Operations is listed as the contracting agency.
HSHQDC-17-R-00020 Attachment B Price Template
View the file
Other files
Show all 24
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
Proposed Burdened Labor Rates
| ATTACHMENT B - PRICE TEMPLATE |
| Offeror Name: |
| DUNS Number: |
*If the Offeror proposes a labor category with a different title (i.e. title that differs from Government's labor category title) please indicate the corresponding proposed labor category title(s) under column B entitled "Contractor Proposed Labor Category Title." If this condition is not applicable, the Offeror shall input not applicable (n/a) in column B or leave blank. If column B is left blank, the Government will assume n/a.
* The Government has stated the historically based total hours for each labor category. The contractor is to provide "Government Facility Burdened Hourly Labor Rates" and "Contractor Facility Burdened Hourly Labor Rates.” The excel sheet will automatically calculate the Total for the "Government Facility Burdened Hourly Labor Rates” in order to conduct IDIQ price evaluation.
*Even though the excel sheet will automatically calculate the Total, it is the Offeror’s obligation to verify and confrim the numbers add up correctly before proposal submission. The contractor is prohibited from changing the estimated labor hours provided.
| The labor rates for the IDIQ contract shall reflect fully-burdened hourly rates for each labor category and will apply to all direct labor hours. The fully-burdened labor rates include direct cost, indirect cost (fringe & overhead), general & adiministrative expenses, profit. The fully-burdened rates include ALL costs associated with the management of the IDIQ contract. A total of 1989 hours per year will be requried for an IDIQ manager. | YEAR 1 | Year 2 | YEAR 3 | YEAR 4 | YEAR 5 | ||||||||||||||||
| Government Proposed Labor Category Title (LCAT) | Contractor Proposed Labor Category Title * | Est. Labor Hours Based on Historical SETA IDIQ | Government Facility Burdened Hourly Labor Rates | Government Facility Total Price for LCAT | Contractor Facility Burdened Hourly Labor Rates | Est. Labor Hours Based on Historical SETA IDIQ | Government Facility Burdened Hourly Labor Rates | Government Facility Total Price for LCAT | Contractor Facility Burdened Hourly Labor Rates | Est. Labor Hours Based on Historical SETA IDIQ | Government Facility Burdened Hourly Labor Rates | Government Facility Total Price for LCAT | Contractor Facility Burdened Hourly Labor Rates | Est. Labor Hours Based on Historical SETA IDIQ | Government Facility Burdened Hourly Labor Rates | Government Facility Total Price for LCAT | Contractor Facility Burdened Hourly Labor Rates | Est. Labor Hours Based on Historical SETA IDIQ | Government Facility Burdened Hourly Labor Rates | Government Facility Total Price for LCAT | Contractor Facility Burdened Hourly Labor Rates |
| Task Order Manager | 26960 | $ - 0 | $ - 0 | $ - 0 | 26960 | $ - 0 | $ - 0 | $ - 0 | 26960 | $ - 0 | $ - 0 | $ - 0 | 26960 | $ - 0 | $ - 0 | $ - 0 | 26960 | $ - 0 | $ - 0 | $ - 0 | |
| Senior Portfolio/Program/Project Analyst | 49720 | $ - 0 | $ - 0 | $ - 0 | 49720 | $ - 0 | $ - 0 | 49720 | $ - 0 | $ - 0 | $ - 0 | 49720 | $ - 0 | $ - 0 | $ - 0 | 49720 | $ - 0 | $ - 0 | $ - 0 | ||
| Portfolio/Program/Project Analyst | 63380 | $ - 0 | $ - 0 | $ - 0 | 63380 | $ - 0 | $ - 0 | $ - 0 | 63380 | $ - 0 | $ - 0 | $ - 0 | 63380 | $ - 0 | $ - 0 | $ - 0 | 63380 | $ - 0 | $ - 0 | $ - 0 | |
| Junior Portfolio/Program/Project Analyst | 7040 | $ - 0 | $ - 0 | $ - 0 | 7040 | $ - 0 | $ - 0 | $ - 0 | 7040 | $ - 0 | $ - 0 | $ - 0 | 7040 | $ - 0 | $ - 0 | $ - 0 | 7040 | $ - 0 | $ - 0 | $ - 0 | |
| Senior Budget Analyst | 3960 | $ - 0 | $ - 0 | $ - 0 | 3960 | $ - 0 | $ - 0 | $ - 0 | 3960 | $ - 0 | $ - 0 | $ - 0 | 3960 | $ - 0 | $ - 0 | $ - 0 | 3960 | $ - 0 | $ - 0 | $ - 0 | |
| Budget Analyst | 3960 | $ - 0 | $ - 0 | $ - 0 | 3960 | $ - 0 | $ - 0 | $ - 0 | 3960 | $ - 0 | $ - 0 | $ - 0 | 3960 | $ - 0 | $ - 0 | $ - 0 | 3960 | $ - 0 | $ - 0 | $ - 0 | |
| Junior Budget Analyst | 2960 | $ - 0 | $ - 0 | $ - 0 | 2960 | $ - 0 | $ - 0 | $ - 0 | 2960 | $ - 0 | $ - 0 | $ - 0 | 2960 | $ - 0 | $ - 0 | $ - 0 | 2960 | $ - 0 | $ - 0 | $ - 0 | |
| Senior Graphic Designer | 300 | $ - 0 | $ - 0 | $ - 0 | 300 | $ - 0 | $ - 0 | $ - 0 | 300 | $ - 0 | $ - 0 | $ - 0 | 300 | $ - 0 | $ - 0 | $ - 0 | 300 | $ - 0 | $ - 0 | $ - 0 | |
| Graphic Designer | 500 | $ - 0 | $ - 0 | $ - 0 | 500 | $ - 0 | $ - 0 | $ - 0 | 500 | $ - 0 | $ - 0 | $ - 0 | 500 | $ - 0 | $ - 0 | $ - 0 | 500 | $ - 0 | $ - 0 | $ - 0 | |
| Junior Graphic Designer | 250 | $ - 0 | $ - 0 | $ - 0 | 250 | $ - 0 | $ - 0 | $ - 0 | 250 | $ - 0 | $ - 0 | $ - 0 | 250 | $ - 0 | $ - 0 | $ - 0 | 250 | $ - 0 | $ - 0 | $ - 0 | |
| Senior Documentation Specialist | 300 | $ - 0 | $ - 0 | $ - 0 | 300 | $ - 0 | $ - 0 | $ - 0 | 300 | $ - 0 | $ - 0 | $ - 0 | 300 | $ - 0 | $ - 0 | $ - 0 | 300 | $ - 0 | $ - 0 | $ - 0 | |
| Documentation Specialist | 200 | $ - 0 | $ - 0 | $ - 0 | 200 | $ - 0 | $ - 0 | $ - 0 | 200 | $ - 0 | $ - 0 | $ - 0 | 200 | $ - 0 | $ - 0 | $ - 0 | 200 | $ - 0 | $ - 0 | $ - 0 | |
| Junior Documentation Specialist | 250 | $ - 0 | $ - 0 | $ - 0 | 250 | $ - 0 | $ - 0 | $ - 0 | 250 | $ - 0 | $ - 0 | $ - 0 | 250 | $ - 0 | $ - 0 | $ - 0 | 250 | $ - 0 | $ - 0 | $ - 0 | |
| Senior Technical Writer/Editor/Communications Specialist | 300 | $ - 0 | $ - 0 | $ - 0 | 300 | $ - 0 | $ - 0 | $ - 0 | 300 | $ - 0 | $ - 0 | $ - 0 | 300 | $ - 0 | $ - 0 | $ - 0 | 300 | $ - 0 | $ - 0 | $ - 0 | |
| Technical Writer/Editor/Communications Specialist | 300 | $ - 0 | $ - 0 | $ - 0 | 300 | $ - 0 | $ - 0 | $ - 0 | 300 | $ - 0 | $ - 0 | $ - 0 | 300 | $ - 0 | $ - 0 | $ - 0 | 300 | $ - 0 | $ - 0 | $ - 0 | |
| Junior Technical Writer/Editor/Communications Specialist | 500 | $ - 0 | $ - 0 | $ - 0 | 500 | $ - 0 | $ - 0 | $ - 0 | 500 | $ - 0 | $ - 0 | $ - 0 | 500 | $ - 0 | $ - 0 | $ - 0 | 500 | $ - 0 | $ - 0 | $ - 0 | |
| Senior Computer Systems Specialist | 30320 | $ - 0 | $ - 0 | $ - 0 | 30320 | $ - 0 | $ - 0 | $ - 0 | 30320 | $ - 0 | $ - 0 | $ - 0 | 30320 | $ - 0 | $ - 0 | $ - 0 | 30320 | $ - 0 | $ - 0 | $ - 0 | |
| Computer Systems Specialist | 1000 | $ - 0 | $ - 0 | $ - 0 | 1000 | $ - 0 | $ - 0 | $ - 0 | 1000 | $ - 0 | $ - 0 | $ - 0 | 1000 | $ - 0 | $ - 0 | $ - 0 | 1000 | $ - 0 | $ - 0 | $ - 0 | |
| Junior Computer Systems Specialist | 980 | $ - 0 | $ - 0 | $ - 0 | 980 | $ - 0 | $ - 0 | $ - 0 | 980 | $ - 0 | $ - 0 | $ - 0 | 980 | $ - 0 | $ - 0 | $ - 0 | 980 | $ - 0 | $ - 0 | $ - 0 | |
| Senior Administrative Specialist | 1980 | $ - 0 | $ - 0 | $ - 0 | 1980 | $ - 0 | $ - 0 | $ - 0 | 1980 | $ - 0 | $ - 0 | $ - 0 | 1980 | $ - 0 | $ - 0 | $ - 0 | 1980 | $ - 0 | $ - 0 | $ - 0 | |
| Administrative Specialist | 4940 | $ - 0 | $ - 0 | $ - 0 | 4940 | $ - 0 | $ - 0 | $ - 0 | 4940 | $ - 0 | $ - 0 | $ - 0 | 4940 | $ - 0 | $ - 0 | $ - 0 | 4940 | $ - 0 | $ - 0 | $ - 0 | |
| Junior Administrative Specialist | 1000 | $ - 0 | $ - 0 | $ - 0 | 1000 | $ - 0 | $ - 0 | $ - 0 | 1000 | $ - 0 | $ - 0 | $ - 0 | 1000 | $ - 0 | $ - 0 | $ - 0 | 1000 | $ - 0 | $ - 0 | $ - 0 | |
| Senior Analyst | 3760 | $ - 0 | $ - 0 | $ - 0 | 3760 | $ - 0 | $ - 0 | $ - 0 | 3760 | $ - 0 | $ - 0 | $ - 0 | 3760 | $ - 0 | $ - 0 | $ - 0 | 3760 | $ - 0 | $ - 0 | $ - 0 | |
| Analyst | 5940 | $ - 0 | $ - 0 | $ - 0 | 5940 | $ - 0 | $ - 0 | $ - 0 | 5940 | $ - 0 | $ - 0 | $ - 0 | 5940 | $ - 0 | $ - 0 | $ - 0 | 5940 | $ - 0 | $ - 0 | $ - 0 | |
| Junior Analyst | 1980 | $ - 0 | $ - 0 | $ - 0 | 1980 | $ - 0 | $ - 0 | $ - 0 | 1980 | $ - 0 | $ - 0 | $ - 0 | 1980 | $ - 0 | $ - 0 | $ - 0 | 1980 | $ - 0 | $ - 0 | $ - 0 | |
| Senior Engineer | 32770 | $ - 0 | $ - 0 | $ - 0 | 32770 | $ - 0 | $ - 0 | $ - 0 | 32770 | $ - 0 | $ - 0 | $ - 0 | 32770 | $ - 0 | $ - 0 | $ - 0 | 32770 | $ - 0 | $ - 0 | $ - 0 | |
| Engineer | 15540 | $ - 0 | $ - 0 | $ - 0 | 15540 | $ - 0 | $ - 0 | $ - 0 | 15540 | $ - 0 | $ - 0 | $ - 0 | 15540 | $ - 0 | $ - 0 | $ - 0 | 15540 | $ - 0 | $ - 0 | $ - 0 | |
| Junior Engineer | 2880 | $ - 0 | $ - 0 | $ - 0 | 2880 | $ - 0 | $ - 0 | $ - 0 | 2880 | $ - 0 | $ - 0 | $ - 0 | 2880 | $ - 0 | $ - 0 | $ - 0 | 2880 | $ - 0 | $ - 0 | $ - 0 | |
| Senior Scientist | 11480 | $ - 0 | $ - 0 | $ - 0 | 11480 | $ - 0 | $ - 0 | $ - 0 | 11480 | $ - 0 | $ - 0 | $ - 0 | 11480 | $ - 0 | $ - 0 | $ - 0 | 11480 | $ - 0 | $ - 0 | $ - 0 | |
| Scientist | 450 | $ - 0 | $ - 0 | $ - 0 | 450 | $ - 0 | $ - 0 | $ - 0 | 450 | $ - 0 | $ - 0 | $ - 0 | 450 | $ - 0 | $ - 0 | $ - 0 | 450 | $ - 0 | $ - 0 | $ - 0 | |
| Junior Scientist | 200 | $ - 0 | $ - 0 | $ - 0 | 200 | $ - 0 | $ - 0 | $ - 0 | 200 | $ - 0 | $ - 0 | $ - 0 | 200 | $ - 0 | $ - 0 | $ - 0 | 200 | $ - 0 | $ - 0 | $ - 0 | |
| Subject Matter Expert III | 8880 | $ - 0 | $ - 0 | $ - 0 | 8880 | $ - 0 | $ - 0 | $ - 0 | 8880 | $ - 0 | $ - 0 | $ - 0 | 8880 | $ - 0 | $ - 0 | $ - 0 | 8880 | $ - 0 | $ - 0 | $ - 0 | |
| Subject Matter Expert II | 6290 | $ - 0 | $ - 0 | $ - 0 | 6290 | $ - 0 | $ - 0 | $ - 0 | 6290 | $ - 0 | $ - 0 | $ - 0 | 6290 | $ - 0 | $ - 0 | $ - 0 | 6290 | $ - 0 | $ - 0 | $ - 0 | |
| Subject Matter Expert I | 5300 | $ - 0 | $ - 0 | $ - 0 | 5300 | $ - 0 | $ - 0 | $ - 0 | 5300 | $ - 0 | $ - 0 | $ - 0 | 5300 | $ - 0 | $ - 0 | $ - 0 | 5300 | $ - 0 | $ - 0 | $ - 0 | |
| Total Yearly Price | 296,570 | $ - 0 | $ - 0 | $ - 0 | 296,570 | $ - 0 | $ - 0 | $ - 0 | 296,570 | $ - 0 | $ - 0 | $ - 0 | 296,570 | $ - 0 | $ - 0 | $ - 0 | 296,570 | $ - 0 | $ - 0 | $ - 0 |
| 5 Year Total IDIQ Price for Government Facility | $ - 0 | ||
| 5 Year Total Hours for IDIQ | 1,482,850 |
Total Direct Labor Total Overhead Total G&A Total Profit/Fee
File details come from the government source that posted it. Updated .