FA3047-12-R-0026 Attachment 4 Schedule B Spreadsheet.xlsx

XLSX spreadsheet 33 KB Posted Aug 10, 2012

Attached to: Full Food Services - Lackland AFB Federal contract opportunity
Solicitation number: FA3047-12-R-0026
Issued by: Department of the Air Force Air Education and Training Command

About this file

From the source

Complete and submit this Schedule B Spreadsheet as required in the Addendum to FAR Provisions 52.212-1 and 52.212-2. Please note the spreadsheet contains four worksheet tabs (Base Period Option 1 Option 2 Option 3). Offerors need to complete all four worksheets.

View the file

Other files for this federal contract opportunity

Other files attached to Full Food Services - Lackland AFB, newest first.
File	Type	Posted
PWS_for_New_Procurement_changed_28_Sep_12.pdf	PDF	Sep 28, 2012
2ND_SET_QUESTIONS_ANSWERS_AS_OF_25_SEP_12.pdf	PDF	Sep 27, 2012
FA3047-12-R-0026_Conformed_to_include_Amendments_0001_and_0002.pdf	PDF	Sep 27, 2012
FA3047-12-R-0026-0002.pdf	PDF	Sep 27, 2012
Revised_PWS_dated_27_September_2013_for_New_Requirement.pdf	PDF	Sep 27, 2012
Revised_CLIN_Structure_(26_Sep_2012)_for_Solicitation_FA3047-12-R-0026.xlsx	XLSX spreadsheet	Sep 27, 2012
Revised_CLIN_Structure_for_Solicitation_FA3047-12-R-0026.xlsx	XLSX spreadsheet	Sep 19, 2012
FA3047-12-R-0026_Attachment_4_Schedule_B_Spreadsheet.pdf	PDF	Sep 18, 2012
New_CBA_Effective_September_1 _2012.pdf	PDF	Sep 18, 2012
Revised PWS 14 Sep 2012 New Procurement.pdf	PDF	Sep 17, 2012
Completed Questions Answers.pdf	PDF	Sep 17, 2012
Completed Amendment 01 Solicitation FA3047-12-R-0026.pdf	PDF	Sep 17, 2012
Attach PWS 1-4 Tech Exhibit 5d Recommended Supplies	—	Sep 17, 2012
QUESTIONS SUBMITTED AFTER SITE VISIT HELD ON 17 AUGUST 2012.docx	DOCX document	Aug 22, 2012
DCF 1 entire layout	—	Aug 22, 2012
Attach PWS 1-4 Tech Exhibit 5d Recommended Supplies.doc	DOC document	Aug 10, 2012
FA3047-12-R-0026 Attachment 6a Questionnaire Cover Letter.pdf	PDF	Aug 10, 2012
FA3047-12-R-0026 Attachment 5 Past Performance Information Sheet.docx	DOCX document	Aug 10, 2012
FA3047-12-R-0026 Attachment 7 Subcontractor_Teaming Consent Form.docx	DOCX document	Aug 10, 2012
Attach PWS 1-2 Tech Exhibit 5b GFE.xlsx	XLSX spreadsheet	Aug 10, 2012
FA3047-12-R-0026 Solicitation.pdf	PDF	Aug 10, 2012
CBA.pdf	PDF	Aug 10, 2012
CBA Addendum 1 Oct 11.pdf	PDF	Aug 10, 2012
Attach PWS 1-1 Building Layouts.pdf	PDF	Aug 10, 2012
FA3047-12-R-0026 Attachment 6 Past Performance Questionnaire.doc	DOC document	Aug 10, 2012
PWS 8 Aug 12.pdf	PDF	Aug 10, 2012
FA3047-12-R-0026 Attachment 3 Manning Matrix.xlsx	XLSX spreadsheet	Aug 10, 2012
Attach PWS 1-3 Tech Exhibit 5c Materials.xls	XLS spreadsheet	Aug 10, 2012

Show all 28

On GovTribe

Work with this file on GovTribe

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 Period

CLIN/SubCLIN	UNIT OF ISSUE	QUANTITY	Quantity Constraint	OFFEROR SHALL ENTER PROPOSED UNIT PRICE IN THIS COLUMN	OFFEROR SHALL ENTER PROPOSED EXTENDED AMOUNT IN THIS COLUMN
0001
0001AA	days	365	FFP (EST)
0001AB	days	365	FFP (EST)
0001AC	days	365	FFP (EST)
0001AD	days	365	FFP (EST)
0001AE	days	365	FFP (EST)
0001AF	days	365	FFP (EST)
0001AG	days	251	FFP (EST)
0001AH	days	365	FFP (EST)
0001AJ	days	251	FFP (EST)
0001AK	days	114	FFP (EST)
0001AL	days	251	FFP (EST)
0001AM	days	114	FFP (EST)
0001AN	days	251	FFP (EST)
0001AP	days	114	FFP (EST)
0001AQ	days	251	FFP (EST)
0001AR	days	114	FFP (EST)
0001AS	days	251	FFP (EST)
0001AT	days	114	FFP (EST)
0001AU	days	251	FFP (EST)
0001AV	days	365	FFP (EST)
0001AW	months	12	FFP (EST)
0001AX	days	209	FFP (EST)
0001AY	days	365	FFP (EST)
0001AZ	days	365	FFP (EST)
0002
0002AA	days	516	FFP (EST)
0002AB	visit	52	FFP (EST)
0003
0003AA	half-hour	240	FFP (EST)
0003AB	half-hour	240	FFP (EST)
0003AC	half-hour	240	FFP (EST)
0003AD	half-hour	120	FFP (EST)
0003AE	half-hour	24	FFP (EST)
0004	half-hour	250	FFP (EST)
0005	days	32	FFP (EST)
0006
0006AA	half-hour	2300	FFP (EST)
0006AB	days	84	FFP (EST)
0006AC	days	101	FFP (EST)
0007	monetary value	1	COST (NTE)	$400,000.00	$400,000.00
0008	monetary value	1	COST (NTE)	$1,500,000.00	$1,500,000.00
0009	monetary value	1	COST (NTE)	$142,260.00	$142,260.00
0010	months	12	FFP (EST)
0011	each	1095	FFP (EST)
0012	each	156	FFP (EST)
0013	hours	624	FFP (EST)

TOTAL: $2,042,260.00

FFP (EST) = Firm Fixed unit Pricing (Estimated Quantities)

COST (NTE) = Cost reimbursable (not to exceed extended amount)

NOTE: Gray shading is for visual simplicity only. The purpose is to differentiate the parent CLIN from the subCLIN.

Base Period Pricing FA3047-12-R-0026 Attachment 4

Option 1

CLIN/SubCLIN	UNIT OF ISSUE	QUANTITY	Quantity Constraint	OFFEROR SHALL ENTER PROPOSED UNIT PRICE IN THIS COLUMN	OFFEROR SHALL ENTER PROPOSED EXTENDED AMOUNT IN THIS COLUMN
1001
1001AA	days	365	FFP (EST)
1001AB	days	365	FFP (EST)
1001AC	days	365	FFP (EST)
1001AD	days	365	FFP (EST)
1001AE	days	365	FFP (EST)
1001AF	days	365	FFP (EST)
1001AG	days	251	FFP (EST)
1001AH	days	365	FFP (EST)
1001AJ	days	251	FFP (EST)
1001AK	days	114	FFP (EST)
1001AL	days	251	FFP (EST)
1001AM	days	114	FFP (EST)
1001AN	days	251	FFP (EST)
1001AP	days	114	FFP (EST)
1001AQ	days	251	FFP (EST)
1001AR	days	114	FFP (EST)
1001AS	days	251	FFP (EST)
1001AT	days	114	FFP (EST)
1001AU	days	251	FFP (EST)
1001AV	days	365	FFP (EST)
1001AW	months	12	FFP (EST)
1001AX	days	209	FFP (EST)
1001AY	days	365	FFP (EST)
1001AZ	days	365	FFP (EST)
1002
1002AA	days	516	FFP (EST)
1002AB	visit	52	FFP (EST)
1003
1003AA	half-hour	240	FFP (EST)
1003AB	half-hour	240	FFP (EST)
1003AC	half-hour	240	FFP (EST)
1003AD	half-hour	120	FFP (EST)
1003AE	half-hour	24	FFP (EST)
1004	half-hour	250	FFP (EST)
1005	days	32	FFP (EST)
1006
1006AA	half-hour	2300	FFP (EST)
1006AB	days	84	FFP (EST)
1006AC	days	101	FFP (EST)
1007	monetary value	1	COST (NTE)	$400,000.00	$400,000.00
1008	monetary value	1	COST (NTE)	$1,500,000.00	$1,500,000.00
1009	monetary value	1	COST (NTE)	$142,260.00	$142,260.00
1010	months	12	FFP (EST)
1011	each	1095	FFP (EST)
1012	each	156	FFP (EST)
1013	hours	624	FFP (EST)

TOTAL:

FFP (EST) = Firm Fixed unit Pricing (Estimated Quantities)

COST (NTE) = Cost reimbursable (not to exceed extended amount)

NOTE: Gray shading is for visual simplicity only. The purpose is to differentiate the parent CLIN from the subCLIN.

Option Period #1 Pricing FA3047-12-R-0026 Attachment 4

Option 2

CLIN/SubCLIN	UNIT OF ISSUE	QUANTITY	Quantity Constraint	OFFEROR SHALL ENTER PROPOSED UNIT PRICE IN THIS COLUMN	OFFEROR SHALL ENTER PROPOSED EXTENDED AMOUNT IN THIS COLUMN
2001
2001AA	days	366	FFP (EST)
2001AB	days	366	FFP (EST)
2001AC	days	366	FFP (EST)
2001AD	days	366	FFP (EST)
2001AE	days	366	FFP (EST)
2001AF	days	366	FFP (EST)
2001AG	days	252	FFP (EST)
2001AH	days	366	FFP (EST)
2001AJ	days	252	FFP (EST)
2001AK	days	114	FFP (EST)
2001AL	days	252	FFP (EST)
2001AM	days	114	FFP (EST)
2001AN	days	252	FFP (EST)
2001AP	days	114	FFP (EST)
2001AQ	days	252	FFP (EST)
2001AR	days	114	FFP (EST)
2001AS	days	252	FFP (EST)
2001AT	days	114	FFP (EST)
2001AU	days	252	FFP (EST)
2001AV	days	366	FFP (EST)
2001AW	months	12	FFP (EST)
2001AX	days	210	FFP (EST)
2001AY	days	366	FFP (EST)
2001AZ	days	366	FFP (EST)
2002
2002AA	days	516	FFP (EST)
2002AB	visit	52	FFP (EST)
2003
2003AA	half-hour	240	FFP (EST)
2003AB	half-hour	240	FFP (EST)
2003AC	half-hour	240	FFP (EST)
2003AD	half-hour	120	FFP (EST)
2003AE	half-hour	24	FFP (EST)
2004	half-hour	250	FFP (EST)
2005	days	32	FFP (EST)
2006
2006AA	half-hour	2300	FFP (EST)
2006AB	days	84	FFP (EST)
2006AC	days	101	FFP (EST)
2007	monetary value	1	COST (NTE)	$400,000.00	$400,000.00
2008	monetary value	1	COST (NTE)	$1,500,000.00	$1,500,000.00
2009	monetary value	1	COST (NTE)	$142,260.00	$142,260.00
2010	months	12	FFP (EST)
2011	each	1098	FFP (EST)
2012	each	156	FFP (EST)
2013	hours	624	FFP (EST)

TOTAL:

FFP (EST) = Firm Fixed unit Pricing (Estimated Quantities)

COST (NTE) = Cost reimbursable (not to exceed extended amount)

NOTE: Gray shading is for visual simplicity only. The purpose is to differentiate the parent CLIN from the subCLIN.

Option Period #2 Pricing FA3047-12-R-0026 Attachment 4

Option 3

CLIN/SubCLIN	UNIT OF ISSUE	QUANTITY	Quantity Constraint	OFFEROR SHALL ENTER PROPOSED UNIT PRICE IN THIS COLUMN	OFFEROR SHALL ENTER PROPOSED EXTENDED AMOUNT IN THIS COLUMN
3001
3001AA	days	365	FFP (EST)
3001AB	days	365	FFP (EST)
3001AC	days	365	FFP (EST)
3001AD	days	365	FFP (EST)
3001AE	days	365	FFP (EST)
3001AF	days	365	FFP (EST)
3001AG	days	251	FFP (EST)
3001AH	days	365	FFP (EST)
3001AJ	days	251	FFP (EST)
3001AK	days	114	FFP (EST)
3001AL	days	251	FFP (EST)
3001AM	days	114	FFP (EST)
3001AN	days	251	FFP (EST)
3001AP	days	114	FFP (EST)
3001AQ	days	251	FFP (EST)
3001AR	days	114	FFP (EST)
3001AS	days	251	FFP (EST)
3001AT	days	114	FFP (EST)
3001AU	days	251	FFP (EST)
3001AV	days	365	FFP (EST)
3001AW	months	12	FFP (EST)
3001AX	days	206	FFP (EST)
3001AY	days	365	FFP (EST)
3001AZ	days	365	FFP (EST)
3002
3002AA	days	516	FFP (EST)
3002AB	visit	52	FFP (EST)
3003
3003AA	half-hour	240	FFP (EST)
3003AB	half-hour	240	FFP (EST)
3003AC	half-hour	240	FFP (EST)
3003AD	half-hour	120	FFP (EST)
3003AE	half-hour	24	FFP (EST)
3004	half-hour	250	FFP (EST)
3005	days	32	FFP (EST)
3006
3006AA	half-hour	2300	FFP (EST)
3006AB	days	84	FFP (EST)
3006AC	days	101	FFP (EST)
3007	monetary value	1	COST (NTE)	$400,000.00	$400,000.00
3008	monetary value	1	COST (NTE)	$1,500,000.00	$1,500,000.00
3009	monetary value	1	COST (NTE)	$142,260.00	$142,260.00
3010	months	12	FFP (EST)
3011	each	1095	FFP (EST)
3012	each	156	FFP (EST)
3013	hours	624	FFP (EST)

TOTAL:

FFP (EST) = Firm Fixed unit Pricing (Estimated Quantities)

COST (NTE) = Cost reimbursable (not to exceed extended amount)

NOTE: Gray shading is for visual simplicity only. The purpose is to differentiate the parent CLIN from the subCLIN.

Option Period #3 Pricing FA3047-12-R-0026 Attachment 4

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