Section_B_CLINs_092816_QA_update.xlsx

XLSX spreadsheet 53 KB Posted Sep 28, 2016

Attached to: DS/IP/OPO SUPPORT CONTRACT
Solicitation number: SAQMMA16R0232
Issued by: Department of State Office of Acquisition Management

About this file

From the source

Attachment 1 - Section B - CLINs

View the file

Other files

File	Type	Posted
SAQMMA16R0232-A007.pdf	PDF	Oct 20, 2016
A007.pdf	PDF	Oct 20, 2016
Q A_Responses_100516_Updated.xlsx	XLSX spreadsheet	Oct 5, 2016
ATTACHMENT_3_Summary_of_Benefits.docx	DOCX document	Sep 28, 2016
DRAFT_DD_254_SAQMMA16R0232_(1).pdf	PDF	Sep 28, 2016
SQMMA16R032-A005-Signed_Page_1_092816.pdf	PDF	Sep 28, 2016
SAQMMA16R0232-Final_Update_QA_092816.pdf	PDF	Sep 28, 2016
Wage_Determination_05-2103_(1).txt	TXT text file	Sep 28, 2016
Q A_Responses_092816_FINAL.xlsx	XLSX spreadsheet	Sep 28, 2016
SOW_092816_FINAL_QA_update.pdf	PDF	Sep 28, 2016
SAQMMA16R0232-A004.pdf	PDF	Sep 23, 2016
Amendment_A003.pdf	PDF	Sep 12, 2016
OPO_Support_Contract_SOW_FINAL_090916.pdf	PDF	Sep 12, 2016
Amendment_A002.pdf	PDF	Sep 12, 2016
Amendment_A001.pdf	PDF	Sep 12, 2016
SOW_FINAL_090916.pdf	PDF	Sep 12, 2016
DRAFT_DD_254_SAQMMA16R0232_(1).pdf	PDF	Sep 9, 2016
SUBCONTRACTING_PERCENTAGE_WORKSHEET.docx	DOCX document	Sep 9, 2016
Wage_Determination_05-2103_(1).txt	TXT text file	Sep 9, 2016
SAQMMA16R0232-FINAL_090916.pdf	PDF	Sep 9, 2016
Section_B_CLINs_FINAL_090916.xlsx	XLSX spreadsheet	Sep 9, 2016

Show all 21

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.

Base Year

ATTACHMENT 1 - Supplies and Services Prices/Costs

SECTION B CLIN STRUCTURE 1880 Hours Est. for Full Time Positions

At the time of task order if the Contractor can negotiate savings/discounts with new hires

each task order comes with an incentive to report those savings to the Government

	** Status - Exempt/Non-Exempt
	B.3.1 Base Year (2/21/2017 - 2/20/2018)
Line Item No. (CLIN)	Descripton (Labor Category)	Status	Estimated Quantity***	Unit	Full Loaded Hourly Rate	Total Cost	New Hire Discount	New Hire Total
0001	Program Manager		940	HR		$0.00
0002	EAA - Executive Admin Asst		3760	HR		$0.00
0003	EAA - Executive Admin Asst - OT		200	HR		$0.00
0004	*SPOIII - Security Program Officer		5640	HR		$0.00
0005	SPOIII - Security Program Officer - OT		300	HR		$0.00
0006	*SPOII - Security Program Officer		1880	HR		$0.00
0007	SPOII - Security Program Officer - OT		100	HR		$0.00
0008	*SPAIII - Security Program Assistant		1880	HR		$0.00
0009	SPAIII - Security Program Assistant - OT		100	HR		$0.00
0010	*SPAII - Security Program Assistant		3760	HR		$0.00
0011	SPAII - Security Program Assistant - OT		100	HR		$0.00
0012	*FMO- Financial Management Officer		9400	HR		$0.00
0013	FMO- Financial Management Officer - OT		500	HR		$0.00
0014	SA - Statistical Analyst		7520	HR		$0.00
0015	SA - Statistical Analyst -OT		400	HR		$0.00
0016	PA - Procurement Analyst		3760	HR		$0.00
0017	PA - Procurment Analyst - OT		200	HR		$0.00
0018	PAA - Procurement Analyst Assistant		1880	HR		$0.00
0019	PAA - Procurement Analyst Assistant - OT		100	HR		$0.00
0020	TA - Travel Coordinator		1880	HR		$0.00
0021	TA - Travel Coordinator - OT		100	HR		$0.00
0022	SPI Admin Security Program Information Administrator		1880	HR		$0.00
0023	SPI Admin Security Program Information Administrator -OT		100	HR		$0.00
0024	SPIA-Security Program Information Analyst		5640	HR		$0.00
0025	SPIA-Security Program Information Analyst - OT		300	HR		$0.00
0026	ITS - Information Technology Specialist		1880	HR		$0.00
0027	ITS - Information Technology Specialist - OT		100	HR		$0.00
0028	Technical Writer		1880	HR		$0.00
0029	Technical Writer - OT		100	HR		$0.00
0030	*Sr Project Manager - Facilities		1880	HR		$0.00
0031	Sr Project Manager - Facilities - OT		910	HR		$0.00
0032	ISS - Industrial Security Specialist		5640	HR		$0.00
0033	ISS - Industrial Security Specialist - OT		300	HR		$0.00
0034	PAT - Program Assistant		5640	HR		$0.00
0035	PAT- Program Assistant - OT		300	HR		$0.00
0036	*Acquisition Management Analyst		5640	HR		$0.00
0037	Acquisition Management Analyst - OT		300	HR		$0.00
0038	*SME 4 - Subject Matter Expert/Logistician		1880	HR		$0.00
0039	SME 4 - Subject Matter Expert/Logistician - OT		100	HR		$0.00
0040	PROAN - Program Analyst		1880	HR		$0.00
0041	PROAN - Program Analyst -OT		100	HR		$0.00

		Total	80850	$0.00	$0.00
	TRAVEL/OTHER DIRECT COSTS
900	Miscellaneous REIMBURSABLE CLIN			G&A %	$353,000.00
	Travel (Gov't Directed) SubClin			OR	Per Task Order Award
	ODC SubClin			Overhead %	Per Task Order Award
	Training (Gov't Directed) SubClin				Per Task Order Award
	DBA Insurance SubClin				Per Task Order Award
	Post DifferentialHazard/Danger Pay SubClin				Per Task Order Award

GRAND TOTAL	$0.00
* Indicates that the position may travel to Hazardous/Dangerous locations.
** Offerors need to provide this information
***Hours are estimated only, not guaranteed.

Option Year 1

ATTACHMENT 1 - Supplies and Services Prices/Costs

SECTION B CLIN STRUCTURE 1880 Hours Est. for Full Time Positions and 100 Hours Est. OT for Full time Position

At the time of task order if the Contractor can negotiate savings/discounts with new hires

each task order comes with an incentive to report those savings to the Government

	** Status - Exempt/Non-Exempt
	B.3.2 Option Year 1 (2/21/2018 - 2/20/2019)
Line Item No. (CLIN)	Descripton (Labor Category)	Status	Estimated Quantity***	Unit	Full Loaded Hourly Rate	Total Cost	New Hire Discount	New Hire Total
1001	Program Manager		940	HR		$0.00
1002	EAA - Executive Admin Asst		3760	HR		$0.00
1003	EAA - Executive Admin Asst - OT		200	HR		$0.00
1004	*SPOIII - Security Program Officer		5640	HR		$0.00
1005	SPOIII - Security Program Officer - OT		300	HR		$0.00
1006	*SPOII - Security Program Officer		1880	HR		$0.00
1007	SPOII - Security Program Officer - OT		100	HR		$0.00
1008	*SPAIII - Security Program Assistant		1880	HR		$0.00
1009	SPAIII - Security Program Assistant - OT		100	HR		$0.00
1010	*SPAII - Security Program Assistant		3760	HR		$0.00
1011	SPAII - Security Program Assistant - OT		100	HR		$0.00
1012	*FMO- Financial Management Officer		9400	HR		$0.00
1013	FMO- Financial Management Officer - OT		500	HR		$0.00
1014	SA - Statistical Analyst		7520	HR		$0.00
1015	SA - Statistical Analyst -OT		400	HR		$0.00
1016	PA - Procurement Analyst		3760	HR		$0.00
1017	PA - Procurment Analyst - OT		200	HR		$0.00
1018	PAA - Procurement Analyst Assistant		1880	HR		$0.00
1019	PAA - Procurement Analyst Assistant - OT		100	HR		$0.00
1020	TA - Travel Coordinator		1880	HR		$0.00
1021	TA - Travel Coordinator - OT		100	HR		$0.00
1022	SPI Admin Security Program Information Administrator		1880	HR		$0.00
1023	SPI Admin Security Program Information Administrator -OT		100	HR		$0.00
1024	SPIA-Security Program Information Analyst		5640	HR		$0.00
1025	SPIA-Security Program Information Analyst - OT		300	HR		$0.00
1026	ITS - Information Technology Specialist		1880	HR		$0.00
1027	ITS - Information Technology Specialist - OT		100	HR		$0.00
1028	Technical Writer		1880	HR		$0.00
1029	Technical Writer - OT		100	HR		$0.00
1030	ISS - Industrial Security Specialist		5640	HR		$0.00
1031	ISS - Industrial Security Specialist - OT		300	HR		$0.00
1032	PAT - Program Assistant		5640	HR		$0.00
1033	PAT- Program Assistant - OT		300	HR		$0.00
1034	*Acquisition Management Analyst		5640	HR		$0.00
1035	Acquisition Management Analyst - OT		300	HR		$0.00
1036	*SME 4 - Subject Matter Expert/Logistician		1880	HR		$0.00
1037	SME 4 - Subject Matter Expert/Logistician - OT		100	HR		$0.00
1038	PROAN - Program Analyst		1880	HR		$0.00
1039	PROAN - Program Analyst -OT		100	HR		$0.00

		Total	78060	$0.00	$0.00
	TRAVEL/OTHER DIRECT COSTS
1900	Miscellaneous REIMBURSABLE CLIN			G&A %	$300.000.00
	Travel (Gov't Directed) SubClin			OR	Per Task Order Award
	ODC SubClin			Overhead %	Per Task Order Award
	Training (Gov't Directed) SubClin				Per Task Order Award
	DBA Insurance SubClin				Per Task Order Award
	Post DifferentialHazard/Danger Pay SubClin				Per Task Order Award

GRAND TOTAL	$0.00
* Indicates that the position may travel to Hazardous/Dangerous locations.
** Offerors needsto provide this information
***Hours are estimated only, not guaranteed.

Option Year 2

ATTACHMENT 1 - Supplies and Services Prices/Costs

SECTION B CLIN STRUCTURE 1880 Hours Est. for Full Time Positions and 100 Hours Est. OT for Full time Position

At the time of task order if the Contractor can negotiate savings/discounts with new hires

each task order comes with an incentive to report those savings to the Government

	** Status - Exempt/Non-Exempt
	B.3.3 Option Year 2 (2/21/2019 - 2/20/2020)
Line Item No. (CLIN)	Descripton (Labor Category)	Status	Estimated Quantity***	Unit	Fully Loaded Hourly Rate	Total Cost	New Hire Discount	New Hire Total
2001	Program Manager		940	HR		$0.00
2002	EAA - Executive Admin Asst		3760	HR		$0.00
2003	EAA - Executive Admin Asst - OT		200	HR		$0.00
2004	*SPOIII - Security Program Officer		5640	HR		$0.00
2005	SPOIII - Security Program Officer - OT		300	HR		$0.00
2006	*SPOII - Security Program Officer		1880	HR		$0.00
2007	SPOII - Security Program Officer - OT		100	HR		$0.00
2008	*SPAIII - Security Program Assistant		1880	HR		$0.00
2009	SPAIII - Security Program Assistant - OT		100	HR		$0.00
2010	*SPAII - Security Program Assistant		3760	HR		$0.00
2011	SPAII - Security Program Assistant - OT		100	HR		$0.00
2012	*FMO- Financial Management Officer		9400	HR		$0.00
2013	FMO- Financial Management Officer - OT		500	HR		$0.00
2014	SA - Statistical Analyst		7520	HR		$0.00
2015	SA - Statistical Analyst -OT		400	HR		$0.00
2016	PA - Procurement Analyst		3760	HR		$0.00
2017	PA - Procurment Analyst - OT		200	HR		$0.00
2018	PAA - Procurement Analyst Assistant		1880	HR		$0.00
2019	PAA - Procurement Analyst Assistant - OT		100	HR		$0.00
2020	TA - Travel Coordinator		1880	HR		$0.00
2021	TA - Travel Coordinator - OT		100	HR		$0.00
2022	SPI Admin Security Program Information Administrator		1880	HR		$0.00
2023	SPI Admin Security Program Information Administrator -OT		100	HR		$0.00
2024	SPIA-Security Program Information Analyst		5640	HR		$0.00
2025	SPIA-Security Program Information Analyst - OT		300	HR		$0.00
2026	ITS - Information Technology Specialist		1880	HR		$0.00
2027	ITS - Information Technology Specialist - OT		100	HR		$0.00
2028	Technical Writer		1880	HR		$0.00
2029	Technical Writer - OT		100	HR		$0.00
2030	ISS - Industrial Security Specialist		5640	HR		$0.00
2031	ISS - Industrial Security Specialist - OT		300	HR		$0.00
2032	PAT - Program Assistant		5640	HR		$0.00
2033	PAT- Program Assistant - OT		300	HR		$0.00
2034	*Acquisition Management Analyst		5640	HR		$0.00
2035	Acquisition Management Analyst - OT		300	HR		$0.00
2036	*SME 4 - Subject Matter Expert/Logistician		1880	HR		$0.00
2037	SME 4 - Subject Matter Expert/Logistician - OT		100	HR		$0.00
2038	PROAN - Program Analyst		1880	HR		$0.00
2039	PROAN - Program Analyst -OT		100	HR		$0.00

		Total	78060	$0.00	$0.00
	TRAVEL/OTHER DIRECT COSTS
2900	Miscellaneous REIMBURSABLE CLIN			G&A %	$300,000.00
	Travel (Gov't Directed) SubClin			OR	Per Task Order Award
	ODC SubClin			Overhead %	Per Task Order Award
	Training (Gov't Directed) SubClin				Per Task Order Award
	DBA Insurance SubClin				Per Task Order Award
	Post DifferentialHazard/Danger Pay SubClin				Per Task Order Award

GRAND TOTAL	$0.00	`
* Indicates that the position may travel to Hazardous/Dangerous locations.
** Offerors need to provide this information
***Hours are estimated only, not guaranteed.

Option Year 3

ATTACHMENT 1 - Supplies and Services Prices/Costs

SECTION B CLIN STRUCTURE 1880 Hours Est. for Full Time Positions and 100 Hours Est. OT for Full time Position

At the time of task order if the Contractor can negotiate savings/discounts with new hires

each task order comes with an incentive to report those savings to the Government

	** Status - Exempt/Non-Exempt
	B.3.4 Option Year 3 (2/21/2020 - 2/20/2021)
Line Item No. (CLIN)	Descripton (Labor Category)	Status	Estimated Quantity***	Unit	Fully Loaded Hourly Rate	Total Cost	New Hire Discount	New Hire Total
3001	Program Manager		940	HR		$0.00
3002	EAA - Executive Admin Asst		3760	HR		$0.00
3003	EAA - Executive Admin Asst - OT		200	HR		$0.00
3004	*SPOIII - Security Program Officer		5640	HR		$0.00
3005	SPOIII - Security Program Officer - OT		300	HR		$0.00
3006	*SPOII - Security Program Officer		1880	HR		$0.00
3007	SPOII - Security Program Officer - OT		100	HR		$0.00
3008	*SPAIII - Security Program Assistant		1880	HR		$0.00
3009	SPAIII - Security Program Assistant - OT		100	HR		$0.00
3010	*SPAII - Security Program Assistant		3760	HR		$0.00
3011	SPAII - Security Program Assistant - OT		100	HR		$0.00
3012	*FMO- Financial Management Officer		9400	HR		$0.00
3013	FMO- Financial Management Officer - OT		500	HR		$0.00
3014	SA - Statistical Analyst		7520	HR		$0.00
3015	SA - Statistical Analyst -OT		400	HR		$0.00
3016	PA - Procurement Analyst		3760	HR		$0.00
3017	PA - Procurment Analyst - OT		200	HR		$0.00
3018	PAA - Procurement Analyst Assistant		1880	HR		$0.00
3019	PAA - Procurement Analyst Assistant - OT		100	HR		$0.00
3020	TA - Travel Coordinator		1880	HR		$0.00
3021	TA - Travel Coordinator - OT		100	HR		$0.00
3022	SPI Admin Security Program Information Administrator		1880	HR		$0.00
3023	SPI Admin Security Program Information Administrator -OT		100	HR		$0.00
3024	SPIA-Security Program Information Analyst		5640	HR		$0.00
3025	SPIA-Security Program Information Analyst - OT		300	HR		$0.00
3026	ITS - Information Technology Specialist		1880	HR		$0.00
3027	ITS - Information Technology Specialist - OT		100	HR		$0.00
3028	Technical Writer		1880	HR		$0.00
3029	Technical Writer - OT		100	HR		$0.00
3030	ISS - Industrial Security Specialist		5640	HR		$0.00
3031	ISS - Industrial Security Specialist - OT		300	HR		$0.00
3032	PAT - Program Assistant		5640	HR		$0.00
3033	PAT- Program Assistant - OT		300	HR		$0.00
3034	*Acquisition Management Analyst		5640	HR		$0.00
3035	Acquisition Management Analyst - OT		300	HR		$0.00
3036	*SME 4 - Subject Matter Expert/Logistician		1880	HR		$0.00
3037	SME 4 - Subject Matter Expert/Logistician - OT		100	HR		$0.00
3038	PROAN - Program Analyst		1880	HR		$0.00
3039	PROAN - Program Analyst -OT		100	HR		$0.00

		Total	78060	$0.00	$0.00
	TRAVEL/OTHER DIRECT COSTS
3900	Miscellaneous REIMBURSABLE CLIN			G&A %	$300,000.00
	Travel (Gov't Directed) SubClin			OR	Per Task Order Award
	ODC SubClin			Overhead %	Per Task Order Award
	Training (Gov't Directed) SubClin				Per Task Order Award
	DBA Insurance SubClin				Per Task Order Award
	Post DifferentialHazard/Danger Pay SubClin				Per Task Order Award

GRAND TOTAL	$0.00
* Indicates that the position may travel to Hazardous/Dangerous locations.
** Offerors need to provide this information
***Hours are estimated only, not guaranteed.

Option Year 4

ATTACHMENT 1 - Supplies and Services Prices/Costs

SECTION B CLIN STRUCTURE 1880 Hours Est. for Full Time Positions and 100 Hours Est. OT for Full time Position

At the time of task order if the Contractor can negotiate savings/discounts with new hires

each task order comes with an incentive to report those savings to the Government

	** Status - Exempt/Non-Exempt
	B.3.5 Option Year 4 (2/21/2021 - 2/20/2022)
Line Item No. (CLIN)	Descripton (Labor Category)	Status	Estimated Quantity***	Unit	Fully Loaded Hourly Rate	Total Cost	New Hire Discount	New Hire Total
4001	Program Manager		940	HR		$0.00
4002	EAA - Executive Admin Asst		3760	HR		$0.00
4003	EAA - Executive Admin Asst - OT		200	HR		$0.00
4004	*SPOIII - Security Program Officer		5640	HR		$0.00
4005	SPOIII - Security Program Officer - OT		300	HR		$0.00
4006	*SPOII - Security Program Officer		1880	HR		$0.00
4007	SPOII - Security Program Officer - OT		100	HR		$0.00
4008	*SPAIII - Security Program Assistant		1880	HR		$0.00
4009	SPAIII - Security Program Assistant - OT		100	HR		$0.00
4010	*SPAII - Security Program Assistant		3760	HR		$0.00
4011	SPAII - Security Program Assistant - OT		100	HR		$0.00
4012	*FMO- Financial Management Officer		9400	HR		$0.00
4013	FMO- Financial Management Officer - OT		500	HR		$0.00
4014	SA - Statistical Analyst		7520	HR		$0.00
4015	SA - Statistical Analyst -OT		400	HR		$0.00
4016	PA - Procurement Analyst		3760	HR		$0.00
4017	PA - Procurment Analyst - OT		200	HR		$0.00
4018	PAA - Procurement Analyst Assistant		1880	HR		$0.00
4019	PAA - Procurement Analyst Assistant - OT		100	HR		$0.00
4020	TA - Travel Coordinator		1880	HR		$0.00
4021	TA - Travel Coordinator - OT		100	HR		$0.00
4022	SPI Admin Security Program Information Administrator		1880	HR		$0.00
4023	SPI Admin Security Program Information Administrator -OT		100	HR		$0.00
4024	SPIA-Security Program Information Analyst		5640	HR		$0.00
4025	SPIA-Security Program Information Analyst - OT		300	HR		$0.00
4026	ITS - Information Technology Specialist		1880	HR		$0.00
4027	ITS - Information Technology Specialist - OT		100	HR		$0.00
4028	Technical Writer		1880	HR		$0.00
4029	Technical Writer - OT		100	HR		$0.00
4030	ISS - Industrial Security Specialist		5640	HR		$0.00
4031	ISS - Industrial Security Specialist - OT		300	HR		$0.00
4032	PAT - Program Assistant		5640	HR		$0.00
4033	PAT- Program Assistant - OT		300	HR		$0.00
4034	*Acquisition Management Analyst		5640	HR		$0.00
4035	Acquisition Management Analyst - OT		300	HR		$0.00
4036	*SME 4 - Subject Matter Expert/Logistician		1880	HR		$0.00
4037	SME 4 - Subject Matter Expert/Logistician - OT		100	HR		$0.00
4038	PROAN - Program Analyst		1880	HR		$0.00
4039	PROAN - Program Analyst -OT		100	HR		$0.00

		Total	78060	$0.00	$0.00
	TRAVEL/OTHER DIRECT COSTS
4900	Miscellaneous REIMBURSABLE CLIN			G&A %	$300,000.00
	Travel (Gov't Directed) SubClin			OR	Per Task Order Award
	ODC SubClin			Overhead %	Per Task Order Award
	Training (Gov't Directed) SubClin				Per Task Order Award
	DBA Insurance SubClin				Per Task Order Award
	Post DifferentialHazard/Danger Pay SubClin				Per Task Order Award

GRAND TOTAL	$0.00
* Indicates that the position may travel to Hazardous/Dangerous locations.
** Offerors need to provide this information
***Hours are estimated only, not guaranteed.

Summary by OY

Category Base Year Option Year 1 Option Year 2 Option Year 3 Option Year 4 Total Contract Value

Labor

ODC/Travel

Training

DBA

Hazard/Danger Pay

Total

New Labor Category Build Up

				HIGH	XX%	XX%	XX%	XX%	XX%
	Grade	Labor
Category	FTE	Hourly
DL Rate	Fringe	OT Burden	OH	G&A	Fee	TOTAL	New Hire Discount	New Hire Total

BOE

Please provide a breakdown of your firms loadings from direct labor through to how your firm arrived at the fully loaded rate? For example:

Direct Labor Rate FICA FUI SUI W/C Fringe Per Hour Direct Labor Rate Overhead Rate G&A Rate Profit Fully Loaded Rate

Please provide a rationale for:

1) What were the hourly rates for the labor categories based on?

2) What sources were used to establish the labor category rates?

3) How were the ODCs calculated?

4) Provide any other pertinent information used for your firm's rationale.

File details come from the government source that posted it. Updated Nov 14, 2017.