Att_7_Price_Evaluation_Worksheet_31July2014.xlsx

XLSX spreadsheet 15 KB Posted Aug 12, 2014

Attached to: JOINT BASE ELMENDORF-RICHARDSON SABER IDIQ Federal contract opportunity
Solicitation number: FA500014R0022
Issued by: Department of the Air Force Pacific Air Forces

About this file

From the source

Attachment 7 FA5000-14-R-0022 Price Evaluation Worksheet

Other files attached to JOINT BASE ELMENDORF-RICHARDSON SABER IDIQ, newest first.
File	Type	Posted
Att_11_CTC__Labor_Rates.pdf	PDF	Sep 3, 2014
FA5000-14-R-0022 _Amend_0001.pdf	PDF	Sep 3, 2014
_02_Q A.pdf	PDF	Aug 28, 2014
SABER_Site_Visit_Record_of_Attendance.pdf	PDF	Aug 22, 2014
SABER_Site_Visit_Minutes.pdf	PDF	Aug 22, 2014
SABER_Site_Visit_Powerpoint.pdf	PDF	Aug 22, 2014
_01_Q A.pdf	PDF	Aug 20, 2014
Att_8_-_Past_Performance_Project_Listing.docx	DOCX document	Aug 12, 2014
Att_4_SABER__SOW_(21Jul2014).pdf	PDF	Aug 12, 2014
Att_3_AK140007_Highway.pdf	PDF	Aug 12, 2014
SOW_Att_2_Elmendorf_Architectural_Standards.pdf	PDF	Aug 12, 2014
Att_1_AK140001_Building Heavy.pdf	PDF	Aug 12, 2014
SOW_Att_3_Richardson_Installation_Design_Guide.pdf	PDF	Aug 12, 2014
SOW_Att_1_JBER_OPLAN_19-3.pdf	PDF	Aug 12, 2014
Att_5_Technical_Specifications_March2014.pdf	PDF	Aug 12, 2014
SOW_Att_4_JBER_Telecommunications_Installation_Standards.pdf	PDF	Aug 12, 2014
Att_10_SABER_Historical_Data.pdf	PDF	Aug 12, 2014
Att_2_AK140004_Residential.pdf	PDF	Aug 12, 2014
FA5000-14-R-0022_Solicitation.pdf	PDF	Aug 12, 2014
Att_6_CTC_March2014.pdf	PDF	Aug 12, 2014
Att_9_PPQ.docx	DOCX document	Aug 12, 2014
SABER_Draft_Coefficient_Structure(17January2014).pdf	PDF	Jan 31, 2014
Draft_RFP_Verbiage.pdf	PDF	Jan 31, 2014
FA5000-14-R-0022_Draft_RFP_(30Jan2014).pdf	PDF	Jan 31, 2014
SABER_Draft_Inst_to_Offerors(17Jan2014).pdf	PDF	Jan 31, 2014
Questions_Comments_Matrix.xlsx	XLSX spreadsheet	Jan 31, 2014
SABER_Draft_SOW_(30_Jan_2014).pdf	PDF	Jan 31, 2014

Show all 27

On GovTribe

Try for free Login

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

Sheet1

CONTRACTOR :
Item	Description	Coefficient weighting Factor	Proposed Coefficient	Weighted Coefficient
Standard Working Hours (JBER):
000lAA	Contractor Coefficient for Commercial	76.00%	0	0
Non-Standard Working Hours (JBER):				0
000lAB	Contractor Coefficient for Commercial	5.00%	0	0
Standard Working Hours in controlled areas (JBER):				0
000lAC	Contractor Coefficient for Commercial	10.00%	0	0
Non-Standard Working Hours in controlled areas (JBER):				0
000lAD	Contractor Coefficient for Commercial	2.00%	0	0
Standard Working Hours in Hospital areas (JBER):				0
000lAE	Contractor Coefficient for Infectious Control	4.00%	0	0
Non-Standard Working Hours in Hospital areas (JBER):				0
000lAF	Contractor Coefficient for Infectious Control	3.00%	0	0
	Subtotal Overall Contractor Coefficient			0
	Tiered Pricing:
	Under $250,000.00 (no Tiered Factor)	20.00%	1	0
0001AJ	$250,000.00 - $750,000.00	60.00%	0	0
0001AK	$750,001.00 - $1,000,000.00	10.00%	0	0
0001AL	Over $1,000,000.00	10.00%	0	0

Overall Contractor Coefficient 0

Overall Contractor Coefficient multiplied by base max. contract value $ 20,000,000.00 $ - 0

Highlighted cells are coefficients provided by the contractor

Example CONTRACTOR A:
Item	Description	Coefficient weighting Factor	Proposed Coefficient	Weighted Coefficient
Standard Working Hours (JBER):
000lAA	Contractor Coefficient for Commercial	76.00%	1.25	0.95
Non-Standard Working Hours (JBER):				0
000lAB	Contractor Coefficient for Commercial	5.00%	1.35	0.0675
Standard Working Hours in controlled areas (JBER):				0
000lAC	Contractor Coefficient for Commercial	10.00%	1.35	0.135
Non-Standard Working Hours in controlled areas (JBER):				0
000lAD	Contractor Coefficient for Commercial	2.00%	1.45	0.029
Standard Working Hours in Hospital areas (JBER):				0
000lAE	Contractor Coefficient for Infectious Control	4.00%	1.35	0.054
Non-Standard Working Hours in Hospital areas (JBER):				0
000lAF	Contractor Coefficient for Infectious Control	3.00%	1.45	0.0435
	Subtotal Overall Contractor Coefficient			1.279
	Tiered Pricing:
	Under $250,000.00 (no Tiered Factor)	20.00%	1	0.2558
0001AJ	$250,000.00 - $750,000.00	60.00%	0.99	0.759726
0001AK	$750,001.00 - $1,000,000.00	10.00%	0.98	0.125342
0001AL	Over $1,000,000.00	10.00%	0.97	0.124063

Overall Contractor Coefficient 1.264931

Overall Contractor Coefficient multiplied by base max. contract value $ 20,000,000.00 $ 25,298,620.00

Example CONTRACTOR B:
Item	Description	Coefficient weighting Factor	Proposed Coefficient	Weighted Coefficient
Standard Working Hours (JBER):
000lAA	Contractor Coefficient for Commercial	76.00%	1.15	0.874
Non-Standard Working Hours (JBER):				0
000lAB	Contractor Coefficient for Commercial	5.00%	1.25	0.0625
Standard Working Hours in controlled areas (JBER):				0
000lAC	Contractor Coefficient for Commercial	10.00%	1.25	0.125
Non-Standard Working Hours in controlled areas (JBER):				0
000lAD	Contractor Coefficient for Commercial	2.00%	1.45	0.029
Standard Working Hours in Hospital areas (JBER):				0
000lAE	Contractor Coefficient for Infectious Control	4.00%	1.25	0.05
Non-Standard Working Hours in Hospital areas (JBER):				0
000lAF	Contractor Coefficient for Infectious Control	3.00%	1.45	0.0435
	Subtotal Overall Contractor Coefficient			1.184
	Tiered Pricing:
	Under $250,000.00 (no Tiered Factor)	20.00%	1	0.2368
0001AJ	$250,000.00 - $750,000.00	60.00%	0.98	0.696192
0001AK	$750,001.00 - $1,000,000.00	10.00%	0.98	0.116032
0001AL	Over $1,000,000.00	10.00%	0.97	0.114848

Overall Contractor Coefficient 1.163872

Overall Contractor Coefficient multiplied by base max. contract value $ 20,000,000.00 $ 23,277,440.00

FA5000-14-R-0022 Attachment #7 7/31/14

Sheet2

Sheet3

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