Section_L_Attachment_Nine_Sample_BOE_Summary.xlsx

XLSX spreadsheet 38 KB Posted Nov 24, 2015

Attached to: Sustainment Upgrade for F-16 Programmable Display Generator Federal contract opportunity
Solicitation number: FA8232-16-R-3001
Issued by: Department of the Air Force Materiel Command Lifecycle Management Center Wright Patterson Air Force Base

About this file

From the source

PDGU Section L Attachment 9

View the file

Other files for this federal contract opportunity

Other files attached to Sustainment Upgrade for F-16 Programmable Display Generator, newest first.
File	Type	Posted
Correction_to_Questions_15 _37 _ _144.pdf	PDF	Jan 12, 2016
FA8232-16-R-3001_RFP_Q A_143 144_11Jan16.pdf	PDF	Jan 11, 2016
Exhibit_A_Admin_CDRLs_6Jan16.pdf	PDF	Jan 7, 2016
Section_J_Attachment_Labor_Categories_Mapping_Worksheet0002.xlsx	XLSX spreadsheet	Jan 7, 2016
FOUO_PDGU_TEP_Table_6Jan16.xlsx	XLSX spreadsheet	Jan 7, 2016
FA823216R3001_______0002.pdf	PDF	Jan 7, 2016
Section_J_Attachment_Labor_Rate_Matrix0002.xlsx	XLSX spreadsheet	Jan 7, 2016
Section_C_PDGU_SOO_7JAN16.pdf	PDF	Jan 7, 2016
FA8232-16-R-3001_RFP_Q A_131_-_142_6_Jan_16.pdf	PDF	Jan 6, 2016
FA8232-16-R-3001_RFP_Q A_13_-_118_18Dec15.pdf	PDF	Dec 18, 2015
ppi_tool_4Dec15.accdb	—	Dec 4, 2015
FA8232-16-R-3001_RFP_Q A_1_-_12_3Dec15.pdf	PDF	Dec 3, 2015
Section_L_PDGU_1Dec15.pdf	PDF	Dec 3, 2015
Section_C_PDGU_SOO_Appendix_C_SRTM_26Aug15.xlsx	XLSX spreadsheet	Dec 3, 2015
Section_M_PDGU_3Dec15b.pdf	PDF	Dec 3, 2015
FA823216R3001_______0001_3Dec15.pdf	PDF	Dec 3, 2015
Exhibit_B_TDP_CDRL.pdf	PDF	Nov 24, 2015
Exhibit_A_Admin_CDRLs_19Nov15.pdf	PDF	Nov 24, 2015
Section_L_Attachments_One_through_Seven_21Oct15.pdf	PDF	Nov 24, 2015
Section_C_PDGU_SOO_19_NOV.pdf	PDF	Nov 24, 2015
FOUO_PDGU_TEP_Table_20Nov15.xlsx	XLSX spreadsheet	Nov 24, 2015
PDGU_Draft_DD_254_4Nov15.pdf	PDF	Nov 24, 2015
Section_L_PDGU_2Nov2015.pdf	PDF	Nov 24, 2015
Section_L_Attachment_Eight_Email_Encryption_13Oct10.pdf	PDF	Nov 24, 2015
Section_J_Attachment_Labor_Rate_Matrix_8_Oct.xlsx	XLSX spreadsheet	Nov 24, 2015
Section_J_Attachment_Labor_Categories_Mapping_Worksheet.xlsx	XLSX spreadsheet	Nov 24, 2015
Section_M_PDGU_26Oct15.pdf	PDF	Nov 24, 2015
FA823216R3001_20Nov15.pdf	PDF	Nov 24, 2015

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.

Instructions

1. Offeror shall provide a spreadsheet with content substantially the same as this spreadsheet IAW with section L and this spreadsheet in support of all Cost-Plus Fixed Fee CLINs (0002, 0007)

2. Offeror shall direct all subcontractors who will be issued other-than fixed-price contracts on CPFF CLINs with a total other-than fixed-price proposed dollar value above $700,000 to complete this spreadsheet as well IAW with section L and this spreadsheet in support of all Cost-Plus Fixed Fee CLINs (0002, 0007)

3. Offeror/subcontractors may add/delete/alter cells, rows, columns, and formulas to fit the offeror's standard practices and proposal

4. Offeror/subcontractors will disclose and justify all components of cost IAW section L

CLIN 0002

	BOE Justification Location		Offeror Rate Year 1			Offeror Rate Year 2			Contract Year 1		Offeror Rate Year 2			Offeror Rate Year 3			Contract Year 2		Offeror Rate Year 3			Offeror Rate Year 4			Contract Year 3		Offeror Rate Year 4			Offeror Rate Year 5			Contract Year 4		Offeror Rate Year 5			Offeror Rate Year 6			Contract Year 5		Contract Total
Labor Category	Hours	Rate	Hours Base	Rate	Total	Hours Base	Rate	Total		Total	Hours Base	Rate	Total	Hours Base	Rate	Total		Total	Hours Base	Rate	Total	Hours Base	Rate	Total		Total	Hours Base	Rate	Total	Hours Base	Rate	Total		Total	Hours Base	Rate	Total	Hours Base	Rate	Total		Total		Total
Direct Labor
Program Manager	Vol III Page XX	Vol III Page XX	100	$1.00	$100	100	$1.00	$100		$200	100	$1.00	$100	100	$1.00	$100		$200	100	$1.00	$100	100	$1.00	$100		$200	100	$1.00	$100	100	$1.00	$100		$200	100	$1.00	$100	100	$1.00	$100		$200		$1,000
Assembler	Vol III Page XX	Vol III Page XX	100	$1.00	$100	100	$1.00	$100		$200	100	$1.00	$100	100	$1.00	$100		$200	100	$1.00	$100	100	$1.00	$100		$200	100	$1.00	$100	100	$1.00	$100		$200	100	$1.00	$100	100	$1.00	$100		$200		$1,000
Test Engineer	Vol III Page XX	Vol III Page XX	100	$1.00	$100	100	$1.00	$100		$200	100	$1.00	$100	100	$1.00	$100		$200	100	$1.00	$100	100	$1.00	$100		$200	100	$1.00	$100	100	$1.00	$100		$200	100	$1.00	$100	100	$1.00	$100		$200		$1,000
Etc…	Vol III Page XX	Vol III Page XX
Total Direct Labor			300		$300	300		$300		$600	300		$300	300		$300		$600	300		$300	300		$300		$600	300		$300	300		$300		$600	300		$300	300		$300		$600		$3,000

Indirects
Overhead	Vol III Page XX	$300	1.00%	$3	$300	1.00%	$3	$6	$300	1.00%	$3	$300	1.00%	$3	$6	$300	1.00%	$3	$300	1.00%	$3	$6	$300	1.00%	$3	$300	1.00%	$3	$6	$300	1.00%	$3	$300	1.00%	$3	$6	$30
Fringe	Vol III Page XX	$300	1.00%	$3	$300	1.00%	$3	$6	$300	1.00%	$3	$300	1.00%	$3	$6	$300	1.00%	$3	$300	1.00%	$3	$6	$300	1.00%	$3	$300	1.00%	$3	$6	$300	1.00%	$3	$300	1.00%	$3	$6	$30
Etc…

Other Direct Costs (ODCs) Vol III Page XX $1 $1 $2 $1 $1 $2 $1 $1 $2 $1 $1 $2 $1 $1 $2 $10

Subcontractors
Sub#1	Vol III Page XX	$1	$1	$2	$1	$1	$2	$1	$1	$2	$1	$1	$2	$1	$1	$2	$10
Sub#2	Vol III Page XX	$1	$1	$2	$1	$1	$2	$1	$1	$2	$1	$1	$2	$1	$1	$2	$10
etc	Vol III Page XX	$1	$1	$2	$1	$1	$2	$1	$1	$2	$1	$1	$2	$1	$1	$2	$10
Total		$3	$3	$6	$3	$3	$6	$3	$3	$6	$3	$3	$6	$3	$3	$6	$30

Material
Material Item #1	Vol III Page XX	$1	$1	$2	$1	$1	$2	$1	$1	$2	$1	$1	$2	$1	$1	$2	$10
Meterial Item #2	Vol III Page XX	$1	$1	$2	$1	$1	$2	$1	$1	$2	$1	$1	$2	$1	$1	$2	$10
etc	Vol III Page XX	$1	$1	$2	$1	$1	$2	$1	$1	$2	$1	$1	$2	$1	$1	$2	$10
Total		$3	$3	$6	$3	$3	$6	$3	$3	$6	$3	$3	$6	$3	$3	$6	$30

G&A	Vol III Page XX	Basis	1.00%	$1	Basis	1.00%	$1	$2	Basis	1.00%	$1	Basis	1.00%	$1	$2	Basis	1.00%	$1	Basis	1.00%	$1	$2	Basis	1.00%	$1	Basis	1.00%	$1	$2	Basis	1.00%	$1	Basis	1.00%	$1	$2	$10
Subtotal				$310			$310	$620			$310			$310	$620			$310			$310	$620			$310			$310	$620			$310			$310	$620	$3,100
COM	Vol III Page XX	Basis	1.00%	$1	Basis	1.00%	$1	$2	Basis	1.00%	$1	Basis	1.00%	$1	$2	Basis	1.00%	$1	Basis	1.00%	$1	$2	Basis	1.00%	$1	Basis	1.00%	$1	$2	Basis	1.00%	$1	Basis	1.00%	$1	$2	$10

Total Cost		$310		$309	$310		$309	$618	$310		$309	$310		$309	$618	$310		$309	$310		$309	$618	$310		$309	$310		$309	$618	$310		$309	$310		$309	$618	$3,090
Target Fee Rate	Vol III Page XX	$309	1.00%	$3	$309	1.00%	$3	$6	$309	1.00%	$3	$309	1.00%	$3	$6	$309	1.00%	$3	$309	1.00%	$3	$6	$309	1.00%	$3	$309	1.00%	$3	$6	$309	1.00%	$3	$309	1.00%	$3	$6	$31
Total Price				$313			$313	$626			$313			$313	$626			$313			$313	$626			$313			$313	$626			$313			$313	$626	$3,131

CLIN 0007

	BOE Justification Location		Offeror Rate Year 1			Offeror Rate Year 2			Contract Year 1		Offeror Rate Year 2			Offeror Rate Year 3			Contract Year 2		Offeror Rate Year 3			Offeror Rate Year 4			Contract Year 3		Offeror Rate Year 4			Offeror Rate Year 5			Contract Year 4		Offeror Rate Year 5			Offeror Rate Year 6			Contract Year 5		Contract Total
Labor Category	Hours	Rate	Hours Base	Rate	Total	Hours Base	Rate	Total		Total	Hours Base	Rate	Total	Hours Base	Rate	Total		Total	Hours Base	Rate	Total	Hours Base	Rate	Total		Total	Hours Base	Rate	Total	Hours Base	Rate	Total		Total	Hours Base	Rate	Total	Hours Base	Rate	Total		Total		Total
Direct Labor
Program Manager	Vol III Page XX	Vol III Page XX	100	$1.00	$100	100	$1.00	$100		$200	100	$1.00	$100	100	$1.00	$100		$200	100	$1.00	$100	100	$1.00	$100		$200	100	$1.00	$100	100	$1.00	$100		$200	100	$1.00	$100	100	$1.00	$100		$200		$1,000
Assembler	Vol III Page XX	Vol III Page XX	100	$1.00	$100	100	$1.00	$100		$200	100	$1.00	$100	100	$1.00	$100		$200	100	$1.00	$100	100	$1.00	$100		$200	100	$1.00	$100	100	$1.00	$100		$200	100	$1.00	$100	100	$1.00	$100		$200		$1,000
Test Engineer	Vol III Page XX	Vol III Page XX	100	$1.00	$100	100	$1.00	$100		$200	100	$1.00	$100	100	$1.00	$100		$200	100	$1.00	$100	100	$1.00	$100		$200	100	$1.00	$100	100	$1.00	$100		$200	100	$1.00	$100	100	$1.00	$100		$200		$1,000
Etc…	Vol III Page XX	Vol III Page XX
Total Direct Labor			300		$300	300		$300		$600	300		$300	300		$300		$600	300		$300	300		$300		$600	300		$300	300		$300		$600	300		$300	300		$300		$600		$3,000

Indirects
Overhead	Vol III Page XX	$300	1.00%	$3	$300	1.00%	$3	$6	$300	1.00%	$3	$300	1.00%	$3	$6	$300	1.00%	$3	$300	1.00%	$3	$6	$300	1.00%	$3	$300	1.00%	$3	$6	$300	1.00%	$3	$300	1.00%	$3	$6	$30
Fringe	Vol III Page XX	$300	1.00%	$3	$300	1.00%	$3	$6	$300	1.00%	$3	$300	1.00%	$3	$6	$300	1.00%	$3	$300	1.00%	$3	$6	$300	1.00%	$3	$300	1.00%	$3	$6	$300	1.00%	$3	$300	1.00%	$3	$6	$30
Etc…

Other Direct Costs (ODCs) Vol III Page XX $1 $1 $2 $1 $1 $2 $1 $1 $2 $1 $1 $2 $1 $1 $2 $10

Subcontractors
Sub#1	Vol III Page XX	$1	$1	$2	$1	$1	$2	$1	$1	$2	$1	$1	$2	$1	$1	$2	$10
Sub#2	Vol III Page XX	$1	$1	$2	$1	$1	$2	$1	$1	$2	$1	$1	$2	$1	$1	$2	$10
etc	Vol III Page XX	$1	$1	$2	$1	$1	$2	$1	$1	$2	$1	$1	$2	$1	$1	$2	$10
Total		$3	$3	$6	$3	$3	$6	$3	$3	$6	$3	$3	$6	$3	$3	$6	$30

Material
Material Item #1	Vol III Page XX	$1	$1	$2	$1	$1	$2	$1	$1	$2	$1	$1	$2	$1	$1	$2	$10
Meterial Item #2	Vol III Page XX	$1	$1	$2	$1	$1	$2	$1	$1	$2	$1	$1	$2	$1	$1	$2	$10
etc	Vol III Page XX	$1	$1	$2	$1	$1	$2	$1	$1	$2	$1	$1	$2	$1	$1	$2	$10
Total		$3	$3	$6	$3	$3	$6	$3	$3	$6	$3	$3	$6	$3	$3	$6	$30

G&A	Vol III Page XX	Basis	1.00%	$1	Basis	1.00%	$1	$2	Basis	1.00%	$1	Basis	1.00%	$1	$2	Basis	1.00%	$1	Basis	1.00%	$1	$2	Basis	1.00%	$1	Basis	1.00%	$1	$2	Basis	1.00%	$1	Basis	1.00%	$1	$2	$10
Subtotal				$310			$310	$620			$310			$310	$620			$310			$310	$620			$310			$310	$620			$310			$310	$620	$3,100
COM	Vol III Page XX	Basis	1.00%	$1	Basis	1.00%	$1	$2	Basis	1.00%	$1	Basis	1.00%	$1	$2	Basis	1.00%	$1	Basis	1.00%	$1	$2	Basis	1.00%	$1	Basis	1.00%	$1	$2	Basis	1.00%	$1	Basis	1.00%	$1	$2	$10

Total Cost		$310		$309	$310		$309	$618	$310		$309	$310		$309	$618	$310		$309	$310		$309	$618	$310		$309	$310		$309	$618	$310		$309	$310		$309	$618	$3,090
Target Fee Rate	Vol III Page XX	$309	1.00%	$3	$309	1.00%	$3	$6	$309	1.00%	$3	$309	1.00%	$3	$6	$309	1.00%	$3	$309	1.00%	$3	$6	$309	1.00%	$3	$309	1.00%	$3	$6	$309	1.00%	$3	$309	1.00%	$3	$6	$31
Total Price				$313			$313	$626			$313			$313	$626			$313			$313	$626			$313			$313	$626			$313			$313	$626	$3,131

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