SMART_Section_L_Attachment_1_-_CPI_Tables.xlsx

XLSX spreadsheet 51 KB Posted Jan 30, 2015

Attached to: Scientific Management Advice for Research and Technology (SMART)
Solicitation number: FA9453-15-R-0003
Issued by: Department of the Air Force Materiel Command Research Laboratory

About this file

From the source

SMART Section L Attachment 1 - CPI Tables

View the file

Other files

File	Type	Posted
SMART_RFP_Q A_Vol_1_5_Feb_2015.docx	DOCX document	Feb 6, 2015
SMART_Section_L_Attachment_2_Past_Performance_Information_Amend1.docx	DOCX document	Feb 6, 2015
SMART_Section_L_Attachment_1_-_CPI_Tables_Amend1.xlsx	XLSX spreadsheet	Feb 6, 2015
SMART_Section_L_Attachment_2_Past_Performance_Information.docx	DOCX document	Jan 30, 2015
FA9453-15-R-0003.pdf	PDF	Jan 30, 2015
SMART_Section_L_Attachment_3_Past_Performance_Questionnaire.docx	DOCX document	Jan 30, 2015
DRAFT_DD_254_FA9453-15-R-0003_Task_Orders_0001-0003.pdf	PDF	Jan 30, 2015
SMART_DRAFT_RFP_Questions.docx	DOCX document	Jan 9, 2015
SMART_Section_L_Attachment_3_Past_Performance_Questionnaire.docx	DOCX document	Dec 19, 2014
SMART_Section_L_Attachment_2_Past_Performance_Information.docx	DOCX document	Dec 19, 2014
Section_L_Attachment_1_-_CPI_Tables_-_SMART.xlsx	XLSX spreadsheet	Dec 19, 2014
SMART_QA_Vol_3_20141215.docx	DOCX document	Dec 15, 2014
SMART_QA_Vol_2_20141118.docx	DOCX document	Dec 5, 2014
SMART_QA_20141017.docx	DOCX document	Oct 23, 2014
SMART_Rules_of_Engagement.pdf	PDF	Oct 1, 2014

Show all 15

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.

Table 1, Transition Table 1 Transition Costs (if applicable, 5 Oct 15 - 15 Nov 15)

COST ELEMENT	BASE	RATE	AMOUNT
Direct Labor
Labor Category #1
Labor Category #2
Labor Category #3
TOTAL DIRECT LABOR
Labor Overhead
Fringe
SUBTOTAL LABOR
ODC - Travel
ODC - Other
SUBTOTAL
G&A
SUBTOTAL
FCCOM - Overhead
FCCOM - G&A
FEE
TOTAL COST & FEE
NMGRT - Kirtland AFB
NMGRT - Albuquerque
NMGRT - Out-of-State
TOTAL PRICE

FA9453-15-R-0003

Section L - Attachment 1 - Cost Proposal Submission

Table 1, TO #1

	SAMPLE Table 1 - COST ELEMENT SUMMARY						SAMPLE Table 1 - COST ELEMENT SUMMARY						SAMPLE Table 1 - COST ELEMENT SUMMARY						SAMPLE Table 1 - COST ELEMENT SUMMARY
Task Order 1 - Strategic Technology Planning LABOR ONLY	Task Order 1, CLIN 01: BASIC PERIOD						Task Order 1, CLIN 04: OPTION 1						Task Order 1, CLIN 07: OPTION 2						Task Order 1, TOTAL
	OFY YYYY			OFY YYYY			OFY YYYY			OFY YYYY			OFY YYYY			OFY YYYY			(16 Nov 2015 – 15 Nov 2018)
	(16 Nov 2015 – DD MMM YYYY)			(DD MMM YYYY – 15 Nov 2016)			(16 Nov 2016 – DD MMM YYYY)			(DD MMM YYYY – 15 Nov 2017)			(16 Nov 2017 – DD MMM YYYY)			(DD MMM YYYY – 15 Nov 2018)
COST ELEMENT	BASE	RATE	AMOUNT	BASE	RATE	AMOUNT	BASE	RATE	AMOUNT	BASE	RATE	AMOUNT	BASE	RATE	AMOUNT	BASE	RATE	AMOUNT	BASE	AMOUNT
Direct Labor
Labor Category #1	0.0		$ -	0.0		$ -	0.0		$ -	0.0		$ -	0.0		$ -	0.0		$ -	0.0	$ -
Labor Category #2	0.0		$ -	0.0		$ -	0.0		$ -	0.0		$ -	0.0		$ -	0.0		$ -	0.0	$ -
Labor Category #3	0.0		$ -	0.0		$ -	0.0		$ -	0.0		$ -	0.0		$ -	0.0		$ -	0.0	$ -
TOTAL DIRECT LABOR	0.0		$ -	0.0		$ -	0.0		$ -	0.0		$ -	0.0		$ -	0.0		$ -	0.0	$ -
Labor Overhead	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -	$ -
Fringe	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -	$ -
SUBTOTAL LABOR			$ -			$ -			$ -			$ -			$ -			$ -		$ -
Subcontracts – IOTs			$ -			$ -			$ -			$ -			$ -			$ -	0	$ -
SUBTOTAL			$ -			$ -			$ -			$ -			$ -			$ -		$ -
G&A	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -	$ -
SUBTOTAL			$ -			$ -			$ -			$ -			$ -			$ -		$ -
FCCOM - Overhead	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -	$ -
FCCOM - G&A	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -	$ -
FEE	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -	$ -
TOTAL COST & FEE			$ -			$ -			$ -			$ -			$ -			$ -		$ -
NMGRT - Kirtland AFB	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -	$ -
NMGRT - Albuquerque	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -	$ -
NMGRT - Out-of-State	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -	$ -
TOTAL PRICE			$ -			$ -			$ -			$ -			$ -			$ -		$ -

Task Order 1 - Strategic Technology Planning ODCs	Task Order 1, CLIN 02: BASIC PERIOD						Task Order 1, CLIN 05: OPTION 1						Task Order 1, CLIN 08: OPTION 2						Task Order 1, TOTAL
	OFY YYYY			OFY YYYY			OFY YYYY			OFY YYYY			OFY YYYY			OFY YYYY			(16 Nov 2015 – 15 Nov 2018)
	(16 Nov 2015 – DD MMM YYYY)			(DD MMM YYYY – 15 Nov 2016)			(16 Nov 2016 – DD MMM YYYY)			(DD MMM YYYY – 15 Nov 2017)			(16 Nov 2017 – DD MMM YYYY)			(DD MMM YYYY – 15 Nov 2018)
COST ELEMENT	BASE	RATE	AMOUNT	BASE	RATE	AMOUNT	BASE	RATE	AMOUNT	BASE	RATE	AMOUNT	BASE	RATE	AMOUNT	BASE	RATE	AMOUNT	BASE	AMOUNT
ODCs			$ -			$ -			$ -			$ -			$ -			$ -		$ -
SUBTOTAL			$ -			$ -			$ -			$ -			$ -			$ -		$ -
G&A	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -	$ -
SUBTOTAL			$ -			$ -			$ -			$ -			$ -			$ -		$ -
FCCOM - G&A	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -	$ -
TOTAL COST			$ -			$ -			$ -			$ -			$ -			$ -		$ -
NMGRT - Kirtland AFB	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -	$ -
NMGRT - Albuquerque	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -	$ -
NMGRT - Out-of-State	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -	$ -
BASELINED TOTAL PRICE			$ 68,000			$ 68,000			$ 70,000			$ 70,000			$ 72,000			$ 72,000		$ 420,000

Table 1, TO #2

	SAMPLE Table 1 - COST ELEMENT SUMMARY						SAMPLE Table 1 - COST ELEMENT SUMMARY						SAMPLE Table 1 - COST ELEMENT SUMMARY						SAMPLE Table 1 - COST ELEMENT SUMMARY
Task Order 2 - Business and Organizational Development LABOR ONLY	Task Order 2, CLIN 01: BASIC PERIOD						Task Order 2, CLIN 04: OPTION 1						Task Order 2, CLIN 07: OPTION 2						Task Order 2, TOTAL
	OFY YYYY			OFY YYYY			OFY YYYY			OFY YYYY			OFY YYYY			OFY YYYY			(16 Nov 2015 – 15 Nov 2018)
	(16 Nov 2015 – DD MMM YYYY)			(DD MMM YYYY – 15 Nov 2016)			(16 Nov 2016 – DD MMM YYYY)			(DD MMM YYYY – 15 Nov 2017)			(16 Nov 2017 – DD MMM YYYY)			(DD MMM YYYY – 15 Nov 2018)
COST ELEMENT	BASE	RATE	AMOUNT	BASE	RATE	AMOUNT	BASE	RATE	AMOUNT	BASE	RATE	AMOUNT	BASE	RATE	AMOUNT	BASE	RATE	AMOUNT	BASE	AMOUNT
Direct Labor
Labor Category #1	0.0		$ -	0.0		$ -	0.0		$ -	0.0		$ -	0.0		$ -	0.0		$ -	0.0	$ -
Labor Category #2	0.0		$ -	0.0		$ -	0.0		$ -	0.0		$ -	0.0		$ -	0.0		$ -	0.0	$ -
Labor Category #3	0.0		$ -	0.0		$ -	0.0		$ -	0.0		$ -	0.0		$ -	0.0		$ -	0.0	$ -
TOTAL DIRECT LABOR	0.0		$ -	0.0		$ -	0.0		$ -	0.0		$ -	0.0		$ -	0.0		$ -	0.0	$ -
Labor Overhead	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -	$ -
Fringe	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -	$ -
SUBTOTAL LABOR			$ -			$ -			$ -			$ -			$ -			$ -		$ -
Subcontracts – IOTs			$ -			$ -			$ -			$ -			$ -			$ -	0	$ -
SUBTOTAL			$ -			$ -			$ -			$ -			$ -			$ -		$ -
G&A	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -	$ -
SUBTOTAL			$ -			$ -			$ -			$ -			$ -			$ -		$ -
FCCOM - Overhead	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -	$ -
FCCOM - G&A	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -	$ -
FEE	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -	$ -
TOTAL COST & FEE			$ -			$ -			$ -			$ -			$ -			$ -		$ -
NMGRT - Kirtland AFB	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -	$ -
NMGRT - Albuquerque	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -	$ -
NMGRT - Out-of-State	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -	$ -
TOTAL PRICE			$ -			$ -			$ -			$ -			$ -			$ -		$ -
									0
Task Order 2 - Business and Organizational Development ODCs	Task Order 2, CLIN 02: BASIC PERIOD						Task Order 2, CLIN 05: OPTION 1						Task Order 2, CLIN 08: OPTION 2						Task Order 2, TOTAL
	OFY YYYY			OFY YYYY			OFY YYYY			OFY YYYY			OFY YYYY			OFY YYYY			(16 Nov 2015 – 15 Nov 2018)
	(16 Nov 2015 – DD MMM YYYY)			(DD MMM YYYY – 15 Nov 2016)			(16 Nov 2016 – DD MMM YYYY)			(DD MMM YYYY – 15 Nov 2017)			(16 Nov 2017 – DD MMM YYYY)			(DD MMM YYYY – 15 Nov 2018)
COST ELEMENT	BASE	RATE	AMOUNT	BASE	RATE	AMOUNT	BASE	RATE	AMOUNT	BASE	RATE	AMOUNT	BASE	RATE	AMOUNT	BASE	RATE	AMOUNT	BASE	AMOUNT
ODCs			$ -			$ -			$ -			$ -			$ -			$ -		$ -
SUBTOTAL			$ -			$ -			$ -			$ -			$ -			$ -		$ -
G&A	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -	$ -
SUBTOTAL			$ -			$ -			$ -			$ -			$ -			$ -		$ -
FCCOM - G&A	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -	$ -
TOTAL COST			$ -			$ -			$ -			$ -			$ -			$ -		$ -
NMGRT - Kirtland AFB	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -	$ -
NMGRT - Albuquerque	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -	$ -
NMGRT - Out-of-State	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -	$ -
BASELINED TOTAL PRICE			$ 24,465			$ 24,465			$ 25,195			$ 25,195			$ 25,950			$ 25,950		$ 151,220

Table 1, TO #3

	SAMPLE Table 1 - COST ELEMENT SUMMARY						SAMPLE Table 1 - COST ELEMENT SUMMARY						SAMPLE Table 1 - COST ELEMENT SUMMARY						SAMPLE Table 1 - COST ELEMENT SUMMARY
Task Order 3 - Division & Branch Planning Leadership Support LABOR ONLY	Task Order 3, CLIN 01: BASIC PERIOD						Task Order 3, CLIN 04: OPTION 1						Task Order 3, CLIN 07: OPTION 2						Task Order 3, TOTAL
	OFY YYYY			OFY YYYY			OFY YYYY			OFY YYYY			OFY YYYY			OFY YYYY			(16 Nov 2015 – 15 Nov 2018)
	(16 Nov 2015 – DD MMM YYYY)			(DD MMM YYYY – 15 Nov 2016)			(16 Nov 2016 – DD MMM YYYY)			(DD MMM YYYY – 15 Nov 2017)			(16 Nov 2017 – DD MMM YYYY)			(DD MMM YYYY – 15 Nov 2018)
COST ELEMENT	BASE	RATE	AMOUNT	BASE	RATE	AMOUNT	BASE	RATE	AMOUNT	BASE	RATE	AMOUNT	BASE	RATE	AMOUNT	BASE	RATE	AMOUNT	BASE	AMOUNT
Direct Labor
Labor Category #1	0.0		$ -	0.0		$ -	0.0		$ -	0.0		$ -	0.0		$ -	0.0		$ -	0.0	$ -
Labor Category #2	0.0		$ -	0.0		$ -	0.0		$ -	0.0		$ -	0.0		$ -	0.0		$ -	0.0	$ -
Labor Category #3	0.0		$ -	0.0		$ -	0.0		$ -	0.0		$ -	0.0		$ -	0.0		$ -	0.0	$ -
TOTAL DIRECT LABOR	0.0		$ -	0.0		$ -	0.0		$ -	0.0		$ -	0.0		$ -	0.0		$ -	0.0	$ -
Labor Overhead	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -	$ -
Fringe	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -	$ -
SUBTOTAL LABOR			$ -			$ -			$ -			$ -			$ -			$ -		$ -
Subcontracts – IOTs			$ -			$ -			$ -			$ -			$ -			$ -	0	$ -
SUBTOTAL			$ -			$ -			$ -			$ -			$ -			$ -		$ -
G&A	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -	$ -
SUBTOTAL			$ -			$ -			$ -			$ -			$ -			$ -		$ -
FCCOM - Overhead	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -	$ -
FCCOM - G&A	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -	$ -
FEE	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -	$ -
TOTAL COST & FEE			$ -			$ -			$ -			$ -			$ -			$ -		$ -
NMGRT - Kirtland AFB	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -	$ -
NMGRT - Albuquerque	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -	$ -
NMGRT - Out-of-State	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -	$ -
TOTAL PRICE			$ -			$ -			$ -			$ -			$ -			$ -		$ -

Task Order 3 - Division & Branch Planning Leadership Support ODCs	Task Order 3, CLIN 02: BASIC PERIOD						Task Order 3, CLIN 05: OPTION 1						Task Order 3, CLIN 08: OPTION 2						Task Order 3, TOTAL
	OFY YYYY			OFY YYYY			OFY YYYY			OFY YYYY			OFY YYYY			OFY YYYY			(16 Nov 2015 – 15 Nov 2018)
	(16 Nov 2015 – DD MMM YYYY)			(DD MMM YYYY – 15 Nov 2016)			(16 Nov 2016 – DD MMM YYYY)			(DD MMM YYYY – 15 Nov 2017)			(16 Nov 2017 – DD MMM YYYY)			(DD MMM YYYY – 15 Nov 2018)
COST ELEMENT	BASE	RATE	AMOUNT	BASE	RATE	AMOUNT	BASE	RATE	AMOUNT	BASE	RATE	AMOUNT	BASE	RATE	AMOUNT	BASE	RATE	AMOUNT	BASE	AMOUNT
ODCs			$ -			$ -			$ -			$ -			$ -			$ -		$ -
SUBTOTAL			$ -			$ -			$ -			$ -			$ -			$ -		$ -
G&A	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -	$ -
SUBTOTAL			$ -			$ -			$ -			$ -			$ -			$ -		$ -
FCCOM - G&A	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -	$ -
TOTAL COST			$ -			$ -			$ -			$ -			$ -			$ -		$ -
NMGRT - Kirtland AFB	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -	$ -
NMGRT - Albuquerque	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -	$ -
NMGRT - Out-of-State	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -		$ -	$ -	$ -
BASELINED TOTAL PRICE			$ 76,200			$ 76,200			$ 78,500			$ 78,500			$ 80,850			$ 80,850		$ 471,100

Table 2

SAMPLE Table 2 - PRICE SUMMARY for SUBCONTRACTORS/IOTs & CONSULTANTS
NAME	TASK ORDER NUMBERS	CONTRACT PERIOD	CONTRACT TYPE	QUOTED PRICE	PRIME's EVALUATED PRICE	DIFFERENCE	% of WORK
						$ -
						$ -
						$ -
TOTALS				$ -	$ -		%

Table 3

SAMPLE Table 3 - Travel

OFY

Task Order

Contract Period

From

Purpose

No. Trips

No. Tvlrs

No. Days

Per Diem

Lodging

Rental Car

Airfare

Total

YYY1

YYY1 Subtotal:

$ - 0

YYY2

YYY2 Subtotal:

$ - 0

TOTAL TRAVEL:

$ - 0

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