HSHQDC-17-R-00020_Amendment_1_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
Issued by

About this file

Written by GovTribe AI ·

This document contains a price template for a multiple award indefinite delivery indefinite quantity (IDIQ) contract. The price template includes 30 labor categories with estimated labor hours for each category over a five year ordering period. Offerors are instructed to provide fully burdened hourly rates for government and contractor facilities for all labor categories, with the template automatically calculating total prices. The template also requests the offeror's percentage profit for all labor categories.

The related federal contract opportunity notice indicates the solicitation for the Scientific, Technical, Engineering and Mathematics Applications III (SETA III) IDIQ is anticipated to post between late December 2017 and mid-January 2018. The notice provides this as a tentative timeframe and no responses are required. The contracting agency is the Department of Homeland Security Office of Procurement Operations.

From the source

HSHQDC-17-R-00020 Amendment 1 Attachment B Price Template - Revised

View the file

Other files

File Type Posted
HSHQDC-17-R-00020_Amendment_5.pdf PDF
HSHQDC-17-R-00020_Amendment_4..pdf PDF
HSHQDC-17-R-00020_Amendment_3.pdf PDF
HSHQDC-17-R-00020_Amendment_2.pdf PDF
HSHQDC-17-R-00020_Amendment_1.pdf PDF
HSHQDC-17-R-00020_Amendment_1_ATTACHMENT_C_Labor_Categories.docx DOCX document
HSHQDC-17-R-00020_Amendment_1_ATTACHMENT_A_Statement_of_Work.pdf PDF
HSHQDC-17-R-00020_Amendment_1_ATTACHMENT_G_Performance_Guarantee_Agreement.docx DOCX document
HSHQDC-17-R-00020_Amendment_1_ATTACHMENT_J_DRAFT_DD_FORM_254.pdf PDF
HSHQDC-17-R-00020_Amendment_1_ATTACHMENT_F_DHS_SETA_III_NDA_Supplement.pdf PDF
HSHQDC-17-R-00020_Amendment_1_ATTACHMENT_E_DHS_Non-Disclosure_Agreement_Form_11000-6.pdf PDF
HSHQDC-17-R-00020_Amendment_1.pdf PDF
HSHQDC-17-R-00020_Final_RFP_Question_Responses.pdf PDF
HSHQDC-17-R-00020_ATTACHMENT_F_DHS_SETA_III_NDA_Supplement.docx DOCX document
HSHQDC-17-R-00020_ATTACHMENT_B_PRICE_Template.xlsx XLSX spreadsheet
HSHQDC-17-R-00020_ATTACHMENT_D_Past_Performance_Questionnaire.doc DOC document
HSHQDC-17-R-00020_ATTACHMENT_I_SF-1408_Adequate_Accounting_System.pdf PDF
HSHQDC-17-R-00020_ATTACHMENT_H_Company_to_Company_Agreement_(Historical_Sample).pdf PDF
HSHQDC-17-R-00020_ATTACHMENT_G_Performance_Guarantee_Agreement.docx DOCX document
HSHQDC-17-R-00020_Request_for_Proposal.pdf PDF
HSHQDC-17-R-00020_ATTACHMENT_A_Statement_of_Work.pdf PDF
HSHQDC-17-R-00020_ATTACHMENT_J_DRAFT_DD_FORM_254.pdf PDF
HSHQDC-17-R-00020_ATTACHMENT_E_DHS_Non-Disclosure_Agreement_Form_11000-6.pdf PDF
HSHQDC-17-R-00020_ATTACHMENT_C_Labor_Categories.docx DOCX document
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
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Proposed Burdened Labor Rates

ATTACHMENT B - PRICE TEMPLATEAMENDMENT 1
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 1920 hours per year is anticipated for an IDIQ manager for price evaluation purposes. However, depending on the number of task orders awarded to the IDIQ holder the total hours may fluctuate.YEAR 1Year 2YEAR 3YEAR 4YEAR 5
Government Proposed Labor Category Title (LCAT)Contractor Proposed Labor Category Title *Est. Labor Hours Based on Historical SETA IDIQGovernment Facility Burdened Hourly Labor RatesGovernment Facility Total Price for LCATContractor Facility Burdened Hourly Labor RatesEst. Labor Hours Based on Historical SETA IDIQGovernment Facility Burdened Hourly Labor RatesGovernment Facility Total Price for LCATContractor Facility Burdened Hourly Labor RatesEst. Labor Hours Based on Historical SETA IDIQGovernment Facility Burdened Hourly Labor RatesGovernment Facility Total Price for LCATContractor Facility Burdened Hourly Labor RatesEst. Labor Hours Based on Historical SETA IDIQGovernment Facility Burdened Hourly Labor RatesGovernment Facility Total Price for LCATContractor Facility Burdened Hourly Labor RatesEst. Labor Hours Based on Historical SETA IDIQGovernment Facility Burdened Hourly Labor RatesGovernment Facility Total Price for LCATContractor Facility Burdened Hourly Labor Rates
Task Order Manager26960$ - 0$ - 0$ - 026960$ - 0$ - 0$ - 026960$ - 0$ - 0$ - 026960$ - 0$ - 0$ - 026960$ - 0$ - 0$ - 0
Senior Portfolio/Program/Project Analyst49720$ - 0$ - 0$ - 049720$ - 0$ - 0$ - 049720$ - 0$ - 0$ - 049720$ - 0$ - 0$ - 049720$ - 0$ - 0$ - 0
Portfolio/Program/Project Analyst63380$ - 0$ - 0$ - 063380$ - 0$ - 0$ - 063380$ - 0$ - 0$ - 063380$ - 0$ - 0$ - 063380$ - 0$ - 0$ - 0
Junior Portfolio/Program/Project Analyst7040$ - 0$ - 0$ - 07040$ - 0$ - 0$ - 07040$ - 0$ - 0$ - 07040$ - 0$ - 0$ - 07040$ - 0$ - 0$ - 0
Senior Budget Analyst3960$ - 0$ - 0$ - 03960$ - 0$ - 0$ - 03960$ - 0$ - 0$ - 03960$ - 0$ - 0$ - 03960$ - 0$ - 0$ - 0
Budget Analyst3960$ - 0$ - 0$ - 03960$ - 0$ - 0$ - 03960$ - 0$ - 0$ - 03960$ - 0$ - 0$ - 03960$ - 0$ - 0$ - 0
Junior Budget Analyst2960$ - 0$ - 0$ - 02960$ - 0$ - 0$ - 02960$ - 0$ - 0$ - 02960$ - 0$ - 0$ - 02960$ - 0$ - 0$ - 0
Senior Graphic Designer300$ - 0$ - 0$ - 0300$ - 0$ - 0$ - 0300$ - 0$ - 0$ - 0300$ - 0$ - 0$ - 0300$ - 0$ - 0$ - 0
Graphic Designer500$ - 0$ - 0$ - 0500$ - 0$ - 0$ - 0500$ - 0$ - 0$ - 0500$ - 0$ - 0$ - 0500$ - 0$ - 0$ - 0
Junior Graphic Designer250$ - 0$ - 0$ - 0250$ - 0$ - 0$ - 0250$ - 0$ - 0$ - 0250$ - 0$ - 0$ - 0250$ - 0$ - 0$ - 0
Senior Documentation Specialist300$ - 0$ - 0$ - 0300$ - 0$ - 0$ - 0300$ - 0$ - 0$ - 0300$ - 0$ - 0$ - 0300$ - 0$ - 0$ - 0
Documentation Specialist200$ - 0$ - 0$ - 0200$ - 0$ - 0$ - 0200$ - 0$ - 0$ - 0200$ - 0$ - 0$ - 0200$ - 0$ - 0$ - 0
Junior Documentation Specialist250$ - 0$ - 0$ - 0250$ - 0$ - 0$ - 0250$ - 0$ - 0$ - 0250$ - 0$ - 0$ - 0250$ - 0$ - 0$ - 0
Senior Technical Writer/Editor/Communications Specialist300$ - 0$ - 0$ - 0300$ - 0$ - 0$ - 0300$ - 0$ - 0$ - 0300$ - 0$ - 0$ - 0300$ - 0$ - 0$ - 0
Technical Writer/Editor/Communications Specialist300$ - 0$ - 0$ - 0300$ - 0$ - 0$ - 0300$ - 0$ - 0$ - 0300$ - 0$ - 0$ - 0300$ - 0$ - 0$ - 0
Junior Technical Writer/Editor/Communications Specialist500$ - 0$ - 0$ - 0500$ - 0$ - 0$ - 0500$ - 0$ - 0$ - 0500$ - 0$ - 0$ - 0500$ - 0$ - 0$ - 0
Senior Computer Systems Specialist30320$ - 0$ - 0$ - 030320$ - 0$ - 0$ - 030320$ - 0$ - 0$ - 030320$ - 0$ - 0$ - 030320$ - 0$ - 0$ - 0
Computer Systems Specialist1000$ - 0$ - 0$ - 01000$ - 0$ - 0$ - 01000$ - 0$ - 0$ - 01000$ - 0$ - 0$ - 01000$ - 0$ - 0$ - 0
Junior Computer Systems Specialist980$ - 0$ - 0$ - 0980$ - 0$ - 0$ - 0980$ - 0$ - 0$ - 0980$ - 0$ - 0$ - 0980$ - 0$ - 0$ - 0
Senior Administrative Specialist1980$ - 0$ - 0$ - 01980$ - 0$ - 0$ - 01980$ - 0$ - 0$ - 01980$ - 0$ - 0$ - 01980$ - 0$ - 0$ - 0
Administrative Specialist4940$ - 0$ - 0$ - 04940$ - 0$ - 0$ - 04940$ - 0$ - 0$ - 04940$ - 0$ - 0$ - 04940$ - 0$ - 0$ - 0
Junior Administrative Specialist1000$ - 0$ - 0$ - 01000$ - 0$ - 0$ - 01000$ - 0$ - 0$ - 01000$ - 0$ - 0$ - 01000$ - 0$ - 0$ - 0
Senior Analyst3760$ - 0$ - 0$ - 03760$ - 0$ - 0$ - 03760$ - 0$ - 0$ - 03760$ - 0$ - 0$ - 03760$ - 0$ - 0$ - 0
Analyst5940$ - 0$ - 0$ - 05940$ - 0$ - 0$ - 05940$ - 0$ - 0$ - 05940$ - 0$ - 0$ - 05940$ - 0$ - 0$ - 0
Junior Analyst1980$ - 0$ - 0$ - 01980$ - 0$ - 0$ - 01980$ - 0$ - 0$ - 01980$ - 0$ - 0$ - 01980$ - 0$ - 0$ - 0
Senior Engineer32770$ - 0$ - 0$ - 032770$ - 0$ - 0$ - 032770$ - 0$ - 0$ - 032770$ - 0$ - 0$ - 032770$ - 0$ - 0$ - 0
Engineer15540$ - 0$ - 0$ - 015540$ - 0$ - 0$ - 015540$ - 0$ - 0$ - 015540$ - 0$ - 0$ - 015540$ - 0$ - 0$ - 0
Junior Engineer2880$ - 0$ - 0$ - 02880$ - 0$ - 0$ - 02880$ - 0$ - 0$ - 02880$ - 0$ - 0$ - 02880$ - 0$ - 0$ - 0
Senior Scientist11480$ - 0$ - 0$ - 011480$ - 0$ - 0$ - 011480$ - 0$ - 0$ - 011480$ - 0$ - 0$ - 011480$ - 0$ - 0$ - 0
Scientist450$ - 0$ - 0$ - 0450$ - 0$ - 0$ - 0450$ - 0$ - 0$ - 0450$ - 0$ - 0$ - 0450$ - 0$ - 0$ - 0
Junior Scientist200$ - 0$ - 0$ - 0200$ - 0$ - 0$ - 0200$ - 0$ - 0$ - 0200$ - 0$ - 0$ - 0200$ - 0$ - 0$ - 0
Subject Matter Expert III8880$ - 0$ - 0$ - 08880$ - 0$ - 0$ - 08880$ - 0$ - 0$ - 08880$ - 0$ - 0$ - 08880$ - 0$ - 0$ - 0
Subject Matter Expert II6290$ - 0$ - 0$ - 06290$ - 0$ - 0$ - 06290$ - 0$ - 0$ - 06290$ - 0$ - 0$ - 06290$ - 0$ - 0$ - 0
Subject Matter Expert I5300$ - 0$ - 0$ - 05300$ - 0$ - 0$ - 05300$ - 0$ - 0$ - 05300$ - 0$ - 0$ - 05300$ - 0$ - 0$ - 0
Total Yearly Price296,570$ - 0$ - 0$ - 0296,570$ - 0$ - 0$ - 0296,570$ - 0$ - 0$ - 0296,570$ - 0$ - 0$ - 0296,570$ - 0$ - 0$ - 0
5 Year Total IDIQ Price for Government Facility$ - 0
5 Year Total Hours for IDIQ1,482,850

Percentage Profit for All Labor Categories

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