contractor pricing spreadsheet - draft.xls

XLS spreadsheet 142 KB Posted Mar 5, 2009

Attached to: LRSW Systems Engineering & Integration
Solicitation number: FA8811-R-09-0002
Issued by: Department of the Air Force Space Command Space and Missile Systems Center

About this file

From the source

LRSW SE I Draft Pricing Spreadsheet Format

View the file

Other files

File	Type	Posted
FA881109R0002AssembledWORDVersion.DOC	DOC document	Nov 2, 2009
offeror comment request 2 nov 09.pdf	PDF	Nov 2, 2009
L-1 Instructions to offerors 2 Nov 09.pdf	PDF	Nov 2, 2009
RFP Section L question and responses.pdf	PDF	Oct 30, 2009
L-1 Instructions to offerors 30 Oct 09.pdf	PDF	Oct 30, 2009
SEI DD254_1oct09 with cont sheet.pdf	PDF	Oct 22, 2009
Summary of Amendment 4 changes to SEI.pdf	PDF	Oct 22, 2009
45th LCG Base support plan.pdf	PDF	Oct 22, 2009
19 oct SEI questions and responses.pdf	PDF	Oct 22, 2009
SEI PWS 13 Oct 09.pdf	PDF	Oct 16, 2009
Summary of Amendment 3 changes to SEI.pdf	PDF	Oct 16, 2009
sei 15 oct questions and responses.pdf	PDF	Oct 16, 2009
L-1 Instructions to offerors 15 Oct 09.pdf	PDF	Oct 16, 2009
Summary of Amendment 2 changes to SEI.pdf	PDF	Oct 13, 2009
SEC M002 13 Oct 09 update.pdf	PDF	Oct 13, 2009
Sec L-1 Attach 5 PWS Potential OCI matrix 13 oct 09.xls	XLS spreadsheet	Oct 13, 2009
SEI RFP 13 Oct 09.pdf	PDF	Oct 13, 2009
LRSW SEI 28 Sep RFP questions and responses update.pdf	PDF	Oct 7, 2009
L-1 Instructions to offerors 7 Oct 09.pdf	PDF	Oct 7, 2009
Summary of Amendment 1 changes to SEI.pdf	PDF	Oct 7, 2009
Sec L-1 Attach 5 PWS Potential OCI matrix oct 09.xls	XLS spreadsheet	Oct 7, 2009
SEI PWS 5 Oct 09.pdf	PDF	Oct 7, 2009
Sec L-1 Attach 1 Pricing Format 5 oct 09.xls	XLS spreadsheet	Oct 7, 2009
SEI RFP 7 Oct 09 amend 1.pdf	PDF	Oct 7, 2009
SEI DD254_1Jul09 full.pdf	PDF	Sep 28, 2009
CDRLs 11 Jun.pdf	PDF	Sep 28, 2009
Sec L-1 Attach 1 Pricing Format.xls	XLS spreadsheet	Sep 28, 2009
Performance Plan 27 May 09.doc	DOC document	Sep 28, 2009
Sec L-1 Attach 5 PWS Potential OCI matrix.xls	XLS spreadsheet	Sep 28, 2009
Sec L-1 Attach 4 OCI plan checklist.DOC	DOC document	Sep 28, 2009
Sec L-1 ATTACH 3 Past performance info.doc	DOC document	Sep 28, 2009
SEI RFP 25 Sep 09.pdf	PDF	Sep 28, 2009
L-1 Instructions to offerors 28 Sep 09.pdf	PDF	Sep 28, 2009
SEI PWS 22 Sep 09.doc	DOC document	Sep 28, 2009
SEC M002 28 Sep 09 update.pdf	PDF	Sep 28, 2009
SEC L-1 Attach 2 FTE tasks matrix 30 may 09.xls	XLS spreadsheet	Sep 28, 2009
Award Term Plan 24 Aug 09 signed 14 sep 09.pdf	PDF	Sep 28, 2009
CDRLs 11 Jun.pdf	PDF	Jul 9, 2009
PWS DOCS - bidders library unclass.zip	ZIP file	Jul 9, 2009
SEI PWS 6 Jul 09 update .doc	DOC document	Jul 9, 2009
Industry Day Draft RFP Questions20 apr.xls	XLS spreadsheet	Apr 21, 2009
SEI Industry QAs 17 mar09 actual.ppt	PPT presentation	Mar 17, 2009
SEI Industry Briefing - Master 17 Mar 09 actual.ppt	PPT presentation	Mar 17, 2009
SMC_OCI_Plan_Checklist__May_2007_.pdf	PDF	Mar 5, 2009
Exhibit A CDRLs.pdf	PDF	Mar 5, 2009
PWS dated March 05 2009 - Master File .pdf	PDF	Mar 5, 2009
SE I award term plan.pdf	PDF	Mar 5, 2009
draft rfp 5 mar 09.pdf	PDF	Mar 5, 2009
draft DD254.pdf	PDF	Mar 5, 2009
FT Mac maps.pdf	PDF	Mar 5, 2009

Show 40 more

50 files listed here. See the rest on GovTribe.

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.

COVER PAGE

DRAFT

RFP FA8811-09-R-0002

ATTACHMENT 8

SAMPLE FORMAT

FOR

SUBMISSION OF

PROPOSED PRICE

DATE: TBD

Summary Proposal pricing

Sample Format for Submission of Proposed Price
BASE YEAR (FY 2010)					option 1 contract year 2			option 2 contract year 3			option 3 contract year 4		remaining AT option years to be included
(example - Offerors to use their estimating system)
	Hours/Base	Rate	Amount	Hours/Base	Rate	Amount	Hours/Base	Rate	Amount	Hours/Base	Rate	Amount
SMC LABOR	1,800	$ 66.67	$ 120,000	1,800	$ 68.83	$ 123,900	1,900	$ 68.68	$ 130,500	1,700	$ 65.29	$ 111,000
VAFB Labor	2,600	$ 54.27	$ 141,100	2,600	$ 55.27	$ 143,700	2,500	$ 53.78	$ 134,450	2,350	$ 52.06	$ 122,350
CCAFB LABOR	1,800	$ 67.50	$ 121,500	1,800	$ 69.44	$ 125,000	2,150	$ 66.86	$ 143,750	1,800	$ 67.50	$ 121,500
Total Direct Labor	6,200	$ 61.71	$ 382,600	6,200	$ 63.32	$ 392,600	6,550	$ 62.40	$ 408,700	5,850	$ 60.66	$ 354,850
Subcontracts
SMC Subcontract Labor	1,100	$ 117.27	$ 129,000	1,200	$ 126.25	$ 151,500	1,200	$ 126.25	$ 151,500	1,200	$ 126.25	$ 151,500
VAFB Subcontract Labor	900	$ 119.44	$ 107,500	1,100	$ 117.73	$ 129,500	1,100	$ 117.73	$ 129,500	1,100	$ 117.73	$ 129,500
CCAFB Subcontract Labor	500	$ 140.00	$ 70,000	1,100	$ 67.73	$ 74,500	700	$ 106.43	$ 74,500	700	$ 106.43	$ 74,500
Total Subcontracts	2,500	$ 122.60	$ 306,500	3,400	$ 104.56	$ 355,500	3,000	$ 118.50	$ 355,500	3,000	$ 118.50	$ 355,500
Overhead (identify separately as appropriate to your accounting systems)
G&A						$ - 0			$ - 0	$ - 0	10.0%	$ - 0
Total Estimated Cost (excluding Travel)			$ - 0			$ - 0			$ - 0			$ - 0
Fixed Fee (max 10%, excluding Travel))		8.0%	$		8.0%	$ - 0		8.5%	$ - 0		8.5%	$ - 0
TRAVEL, 4% of labor $	4.00%		$ - 0			$ - 0			$ - 0			$ - 0
Total Yearly Cost Plus Fixed Fee						$ - 0			$ - 0			$ - 0
Total contract price
NOTE: All amounts/rates are for illustrative purposes only -- The yellow highlighted cells require offeror inputs

labor base year

Prime Contractor (Base Year)				Subcontractor (Base Year)
SMC				SMC
	Hours/Base	Rate	Amount		Hours	Wrapped rate	Amount
Direct Labor Category*
Senior Engineer 1	500	$ 120.00	$ 60,000	Subcontractor A	500	$ 120.00	$ 60,000
Senior Engineer 2	200	$ 100.00	$ 20,000	Subcontractor B	300	$ 85.00	$ 25,500
Senior Engineer 3	100	$ 25.00	$ 2,500	Subcontractor C	300	$ 145.00	$ 43,500
Engineer 1	100	$ 20.00	$ 2,000
Engineer 2	500	$ 50.00	$ 25,000
Engineer 3	200	$ 30.00	$ 6,000
Techician	100	$ 25.00	$ 2,500
etc	100	$ 20.00	$ 2,000
Total SMC Direct Labor	1,800	$ 66.67	$ 120,000	Total SMC Subcontract Labor	1,100	$ 117.27	$ 129,000
VAFB				VAFB
	Hours/Base	Rate	Amount		Hours	Wrapped rate	Amount
Direct Labor Category*
Senior Engineer 1	500	$ 85.00	$ 42,500	Subcontractor A	200	$ 120.00	$ 24,000
Senior Engineer 2	200	$ 78.00	$ 15,600	Subcontractor B	300	$ 85.00	$ 25,500
Senior Engineer 3	600	$ 60.00	$ 36,000	Subcontractor C	400	$ 145.00	$ 58,000
Engineer 1	100	$ 45.00	$ 4,500
Engineer 2	800	$ 40.00	$ 32,000
Engineer 3	200	$ 30.00	$ 6,000
Techician	100	$ 25.00	$ 2,500
etc	100	$ 20.00	$ 2,000
Total VAFB Direct Labor	2,600	$ 54.27	$ 141,100	Total VAFB Subcontract Labor	900	$ 119.44	$ 107,500
CCAFB				CCAFB
	Hours/Base	Rate	Amount		Hours	Wrapped rate	Amount
Direct Labor Category*
Senior Engineer 1	500	$ 100.00	$ 50,000	Subcontractor A	100	$ 120.00	$ 12,000
Senior Engineer 2	200	$ 75.00	$ 15,000	Subcontractor B	- 0	$ 85.00	$ - 0
Senior Engineer 3	100	$ 50.00	$ 5,000	Subcontractor C	400	$ 145.00	$ 58,000
Engineer 1	100	$ 20.00	$ 2,000
Engineer 2	500	$ 50.00	$ 25,000
Engineer 3	200	$ 100.00	$ 20,000
Techician	100	$ 25.00	$ 2,500
etc	100	$ 20.00	$ 2,000
Total CCAFB Direct Labor	1,800	$ 67.50	$ 121,500	Total CCAFB Subcontract Labor	500	$ 140.00	$ 70,000
Total Prime direct labor	6,200	$61.71	$ 382,600	Total Subcontract	2,500	123	306,500
NOTE: All amounts/rates are for illustrative purposes only -- The yellow highlighted cells require offeror inputs

labor option 1

Prime Contractor (Core Option year 1)				Subcontractor (Core Option Year 1)
SMC				SMC
	Hours/Base	Rate	Amount		Hours	Wrapped rate	Amount
Direct Labor Category*
Senior Engineer 1	500	$ 122.00	$ 61,000	Subcontractor A	500	$ 130.00	$ 65,000
Senior Engineer 2	200	$ 112.00	$ 22,400	Subcontractor B	300	$ 95.00	$ 28,500
Senior Engineer 3	100	$ 30.00	$ 3,000	Subcontractor C	400	$ 145.00	$ 58,000
Engineer 1	100	$ 20.00	$ 2,000
Engineer 2	500	$ 50.00	$ 25,000
Engineer 3	200	$ 30.00	$ 6,000
Techician	100	$ 25.00	$ 2,500
etc	100	$ 20.00	$ 2,000
Total SMC Direct Labor	1,800	$ 68.83	$ 123,900	Total CCAFB Labor	1,200	$ 126.25	$ 151,500
VAFB				VAFB
	Hours/Base	Rate	Amount		Hours	Wrapped rate	Amount
Direct Labor Category*
Senior Engineer 1	500	$ 87.00	$ 43,500	Subcontractor A	400	$ 125.00	$ 50,000
Senior Engineer 2	200	$ 80.00	$ 16,000	Subcontractor B	300	$ 85.00	$ 25,500
Senior Engineer 3	600	$ 62.00	$ 37,200	Subcontractor C	400	$ 135.00	$ 54,000
Engineer 1	100	$ 45.00	$ 4,500
Engineer 2	800	$ 40.00	$ 32,000
Engineer 3	200	$ 30.00	$ 6,000
Techician	100	$ 25.00	$ 2,500
etc	100	$ 20.00	$ 2,000
Total VAFB Direct Labor	2,600	$ 55.27	$ 143,700	Total CCAFB Labor	1,100	$ 117.73	$ 129,500
CCAFB				CCAFB
	Hours/Base	Rate	Amount		Hours	Wrapped rate	Amount
Direct Labor Category*
Senior Engineer 1	500	$ 105.00	$ 52,500	Subcontractor A	- 0	$ 135.00	$ - 0
Senior Engineer 2	200	$ 77.00	$ 15,400	Subcontractor B	300	$ 95.00	$ 28,500
Senior Engineer 3	100	$ 53.00	$ 5,300	Subcontractor C	400	$ 115.00	$ 46,000
Engineer 1	100	$ 23.00	$ 2,300
Engineer 2	500	$ 50.00	$ 25,000
Engineer 3	200	$ 100.00	$ 20,000
Techician	100	$ 25.00	$ 2,500
etc	100	$ 20.00	$ 2,000
Total CCAFB Direct Labor	1,800	$ 69.44	$ 125,000	Total CCAFB Labor	700	$ 106.43	$ 74,500
Total Prime direct labor	6,200	$63.32	$ 392,600	Total Subcontract	3,000	350	355,500
NOTE: All amounts/rates are for illustrative purposes only -- The yellow highlighted cells require offeror inputs

labor option 2

Prime Contractor (Core Option year 2)				Subcontractor (Core Option Year 2)
SMC				SMC
	Hours/Base	Rate	Amount		Hours	Wrapped rate	Amount
Direct Labor Category*
Senior Engineer 1	500	$ 125.00	$ 62,500	Subcontractor A	500	$ 130.00	$ 65,000
Senior Engineer 2	200	$ 110.00	$ 22,000	Subcontractor B	300	$ 95.00	$ 28,500
Senior Engineer 3	100	$ 30.00	$ 3,000	Subcontractor C	400	$ 145.00	$ 58,000
Engineer 1	100	$ 25.00	$ 2,500
Engineer 2	600	$ 50.00	$ 30,000
Engineer 3	200	$ 30.00	$ 6,000
Techician	100	$ 25.00	$ 2,500
etc	100	$ 20.00	$ 2,000
Total SMC Direct Labor	1,900	$ 68.68	$ 130,500	Total CCAFB Labor	1,200	$ 126.25	$ 151,500
VAFB				VAFB
	Hours/Base	Rate	Amount		Hours	Wrapped rate	Amount
Direct Labor Category*
Senior Engineer 1	350	$ 90.00	$ 31,500	Subcontractor A	400	$ 125.00	$ 50,000
Senior Engineer 2	150	$ 83.00	$ 12,450	Subcontractor B	300	$ 85.00	$ 25,500
Senior Engineer 3	600	$ 65.00	$ 39,000	Subcontractor C	400	$ 135.00	$ 54,000
Engineer 1	200	$ 45.00	$ 9,000
Engineer 2	800	$ 40.00	$ 32,000
Engineer 3	200	$ 30.00	$ 6,000
Techician	100	$ 25.00	$ 2,500
etc	100	$ 20.00	$ 2,000
Total VAFB Direct Labor	2,500	$ 53.78	$ 134,450	Total CCAFB Labor	1,100	$ 117.73	$ 129,500
CCAFB				CCAFB
	Hours/Base	Rate	Amount		Hours	Wrapped rate	Amount
Direct Labor Category*
Senior Engineer 1	500	$ 115.00	$ 57,500	Subcontractor A	- 0	$ 135.00	$ - 0
Senior Engineer 2	200	$ 85.00	$ 17,000	Subcontractor B	300	$ 95.00	$ 28,500
Senior Engineer 3	200	$ 55.00	$ 11,000	Subcontractor C	400	$ 115.00	$ 46,000
Engineer 1	100	$ 25.00	$ 2,500
Engineer 2	500	$ 50.00	$ 25,000
Engineer 3	200	$ 100.00	$ 20,000
Techician	350	$ 25.00	$ 8,750
etc	100	$ 20.00	$ 2,000
Total CCAFB Direct Labor	2,150	$ 66.86	$ 143,750	Total CCAFB Labor	700	$ 106.43	$ 74,500
Total Prime direct labor	6,550	$62.40	$ 408,700	Total Subcontract	3,000	350	355,500
NOTE: All amounts/rates are for illustrative purposes only -- The yellow highlighted cells require offeror inputs

labor option 3

Prime Contractor (Core Option year 3)				Subcontractor (Core Option Year 3)
SMC				SMC
	Hours/Base	Rate	Amount		Hours	Wrapped rate	Amount
Direct Labor Category*
Senior Engineer 1	300	$ 120.00	$ 36,000	Subcontractor A	500	$ 130.00	$ 65,000
Senior Engineer 2	400	$ 100.00	$ 40,000	Subcontractor B	300	$ 95.00	$ 28,500
Senior Engineer 3	100	$ 25.00	$ 2,500	Subcontractor C	400	$ 145.00	$ 58,000
Engineer 1	100	$ 20.00	$ 2,000
Engineer 2	400	$ 50.00	$ 20,000
Engineer 3	200	$ 30.00	$ 6,000
Techician	100	$ 25.00	$ 2,500
etc	100	$ 20.00	$ 2,000
Total SMC Direct Labor	1,700	$ 65.29	$ 111,000	Total CCAFB Labor	1,200	$ 126.25	$ 151,500
VAFB				VAFB
	Hours/Base	Rate	Amount		Hours	Wrapped rate	Amount
Direct Labor Category*
Senior Engineer 1	350	$ 85.00	$ 29,750	Subcontractor A	400	$ 125.00	$ 50,000
Senior Engineer 2	200	$ 78.00	$ 15,600	Subcontractor B	300	$ 85.00	$ 25,500
Senior Engineer 3	500	$ 60.00	$ 30,000	Subcontractor C	400	$ 135.00	$ 54,000
Engineer 1	100	$ 45.00	$ 4,500
Engineer 2	800	$ 40.00	$ 32,000
Engineer 3	200	$ 30.00	$ 6,000
Techician	100	$ 25.00	$ 2,500
etc	100	$ 20.00	$ 2,000
Total VAFB Direct Labor	2,350	$ 52.06	$ 122,350	Total CCAFB Labor	1,100	$ 117.73	$ 129,500
CCAFB				CCAFB
	Hours/Base	Rate	Amount		Hours	Wrapped rate	Amount
Direct Labor Category*
Senior Engineer 1	500	$ 100.00	$ 50,000	Subcontractor A	- 0	$ 135.00	$ - 0
Senior Engineer 2	200	$ 75.00	$ 15,000	Subcontractor B	300	$ 95.00	$ 28,500
Senior Engineer 3	100	$ 50.00	$ 5,000	Subcontractor C	400	$ 115.00	$ 46,000
Engineer 1	100	$ 20.00	$ 2,000
Engineer 2	500	$ 50.00	$ 25,000
Engineer 3	200	$ 100.00	$ 20,000
Techician	100	$ 25.00	$ 2,500
etc	100	$ 20.00	$ 2,000
Total CCAFB Direct Labor	1,800	$ 67.50	$ 121,500	Total CCAFB Labor	700	$ 106.43	$ 74,500
Total Prime direct labor	5,850	$60.66	$ 354,850	Total Subcontract	3,000	350	355,500
NOTE: All amounts/rates are for illustrative purposes only -- The yellow highlighted cells require offeror inputs

Sheet3

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