Attachment_0001_-_Price_Model_(ATC)_Revised.xlsx

XLSX spreadsheet 36 KB Posted Feb 8, 2018

Attached to: Air Traffic Controller (ATC) Services
Solicitation number: W9133l-18-R-0012
Issued by: Department of the Army National Guard

About this file

From the source

Revised Pricing Spreadsheet

View the file

Other files

File	Type	Posted
W9133L18R0012_Amendment_0002.pdf	PDF	Feb 12, 2018
Attachment_0001_-_Price_Model_(ATC)_Revised_12FEB18.xlsx	XLSX spreadsheet	Feb 12, 2018
W9133L18R0012_Amendment_0002_Conform_Copy.pdf	PDF	Feb 12, 2018
W9133L18R0012_Amendment_0001.pdf	PDF	Feb 8, 2018
Solicitation_W9133L18R0012_-_Amendment_0001_Conform_-_08FEB18.pdf	PDF	Feb 8, 2018
Attachment_0004_-_OCI_Questionaire.docx	DOCX document	Jan 18, 2018
Attachment_0001_-_Price_Model_(ATC).xlsx	XLSX spreadsheet	Jan 18, 2018
Final_Solicitation_W9133L18R0012_-_18JAN18.pdf	PDF	Jan 18, 2018
Attachment_0002_-_Past_Performanec_Questionnaire_ATC_Services.docx	DOCX document	Jan 18, 2018
Attachment_0002_-_Past_Performanec_Questionnaire_ATC_Services.docx	DOCX document	Dec 19, 2017
Attachment_0001_-_Price_Model_(ATC).xlsx	XLSX spreadsheet	Dec 19, 2017
Attachment_0004_-_OCI_Questionaire.docx	DOCX document	Dec 19, 2017
Attachment_0003_-_Wage_Determinations.pdf	PDF	Dec 19, 2017
Draft_Solicitation_W9133L18R0012_19DEC17.pdf	PDF	Dec 19, 2017

Show all 14

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.

I - Final Pricing

Air Traffic Control (ATC) Services

CLIN Type	Description	CLIN	QTY	Unit of Measure	Price	Extended Price
FFP	ATC Services - Base Year (12 Months)	0001	1	JOB	$0.00	$0.00
Cost	Travel - Base Year (12 Months) Estimated	0002	1	JOB	$200,000.00	$200,000.00
FFP	Contractor Manapower Reporting (CMRA)	0003	1	JOB	$0.00	$0.00
FFP	ATC Services - 1st Option Year (12 Months)	1001	1	JOB	$0.00	$0.00
Cost	Travel- 1st Option Year (12 Months) Estimated	1002	1	JOB	$0.00	$0.00
FFP	Contractor Manapower Reporting (CMRA)	1003	1	JOB	$0.00	$0.00
FFP	ATC Services - 2nd Option Year (12 Months)	2001	1	JOB	$0.00	$0.00
Cost	Travel - 2nd Option Year (12 Months) Estimated	2002	1	JOB	$200,000.00	$200,000.00
FFP	Contractor Manapower Reporting (CMRA)	2003	1	JOB	$0.00	$0.00
FFP	ATC Services -3rd Option Year (12 Months)	3001	1	JOB	$0.00	$0.00
Cost	Travel- 3rd Option Year (12 Months) Estimated	3002	1	JOB	$200,000.00	$200,000.00
FFP	Contractor Manpower Reporting (CMRA)	3003	1	JOB	$0.00	$0.00
FFP	ATC Services - 4th Option Year (12 Months)	4001	1	JOB	$0.00	$0.00
Cost	Travel- 4th Option Year (12 Months) Estimated	4002	1	JOB	$200,000.00	$200,000.00
FFP	Contractor Manapower Reporting (CMRA)	4003	1	JOB	$0.00	$0.00
FFP	ATC Services - 52.217-8 Option	5001	1	JOB	$0.00	$0.00
Cost	Travel- 52.217-8 Option Estimated	5002	1	JOB	$100,000.00	$100,000.00
FFP	Contractor Manapower Reporting (CMRA)- 52.217-8 Option	5003	1	JOB	$0.00	$0.00
Note 1: This woksheet will be populated based on rates and quantities entered into the Pricing Detail Worksheets.

Note 2: Contractor may, on a monthly basis, invoice the lesser of 1/12 the CLIN price or that amount minus any equitable reduction in contract price due in accordance FAR 52.246-4 -- Inspection of Services -- Fixed-Price for all priced CLINs.

Note 3: Contractor Manpower Reporting is normally proposed as "Not Seperately Priced" as labor costs associated with the preparation of this report are included in G&A. These CLINs are included per Army policy and the contractor may propose a price if desired or propose this CLIN as NSP.

Base Period	$200,000.00
	Option Year 1	$0.00
	Option Year 2	$200,000.00
	Option Year 3	$200,000.00
	Option Year 4	$200,000.00
	FAR Clause 52.217-8 Option	$100,000.00
	Total Evaluated Price	$900,000.00

II - Pricing Detail ATC Services - Pricing Worksheet

Base Period		CLINS
Labor Category	Proposed Personnel	0001			0003
		ATC Services			CMRA (If priced)
		Rate	Hours	Price	Rate	Hours	Price
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
Other Direct Costs	Description	Price	Quantity	Ext Price	Rate	Quantity	Total Price
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
		Total Price:		$ - 0	Total Price:		$ - 0
		Unit Price:		$ - 0	Unit Price:		NSP

Option Year 1		CLINS
Labor Category	Proposed Personnel	1001			1003
		ATC Services			CMRA (If priced)
		Rate	Hours	Price	Rate	Hours	Price
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
Other Direct Costs	Description	Price	Quantity	Ext Price	Rate	Quantity	Total Price
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
		Total Price:		$ - 0	Total Price:		$ - 0
		Unit Price:		$ - 0	Unit Price:		NSP

Option Year 2		CLINS
Labor Category	Proposed Personnel	2001			2003
		ATC Services			CMRA (If priced)
		Rate	Hours	Price	Rate	Hours	Price
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
Other Direct Costs	Description	Price	Quantity	Ext Price	Rate	Quantity	Total Price
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
		Total Price:		$ - 0	Total Price:		$ - 0
		Unit Price:		$ - 0	Unit Price:		NSP

Option Year 3		CLINS
Labor Category	Proposed Personnel	3001			3003
		ATC Services			CMRA (If priced)
		Rate	Hours	Price	Rate	Hours	Price
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
Other Direct Costs	Description	Price	Quantity	Ext Price	Rate	Quantity	Total Price
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
		Total Price:		$ - 0	Total Price:		$ - 0
		Unit Price:		$ - 0	Unit Price:		NSP

Option Year 4		CLINS
Labor Category	Proposed Personnel	4001			4003
		ATC Services			CMRA (If priced)
		Rate	Hours	Price	Rate	Hours	Price
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
Other Direct Costs	Description	Price	Quantity	Ext Price	Rate	Quantity	Total Price
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
				$ - 0			$ - 0
		Total Price:		$ - 0	Total Price:		$ - 0
		Unit Price:		$ - 0	Unit Price:		NSP

III - FFP Burdened Rate Buildup ODS Services Rate Buildup Worksheet

	Year
	Base	Option Period 1	Option Period 2	Option Period 3	Option Period 4
Rates:		Escalation:	Escalation:	Escalation:	Escalation:
	Fringe	Fringe:	Fringe:	Fringe:	Fringe:
	Labor O/H	Labor O/H:	Labor O/H:	Labor O/H:	Labor O/H:
	G&A	G&A:	G&A:	G&A:	G&A:
	Profit	Profit:	Profit:	Profit:	Profit:

Base Year Labor Rates
Labor Category	Proposed Person	Base Salary	Base Hourly Rate	Fringe	Labor O/H	G&A	Subtotal	Profit	Fully Burdened Rate
Management Analyst	John Smith			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

Option Period 1 Labor Rates
Labor Category	Proposed Person	Base Salary	Base Hourly Rate	Fringe	Labor O/H	G&A	Subtotal	Profit	Fully Burdened Rate
Management Analyst	John Smith	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

Option Period 2 Labor Rates
Labor Category	Proposed Person	Base Salary	Base Hourly Rate	Fringe	Labor O/H	G&A	Subtotal	Profit	Fully Burdened Rate
Management Analyst	John Smith	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

Option Period 3 Labor Rates
Labor Category	Proposed Person	Base Salary	Base Hourly Rate	Fringe	Labor O/H	G&A	Subtotal	Profit	Fully Burdened Rate
Management Analyst	John Smith	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

Option Period 4 Labor Rates
Labor Category	Proposed Person	Base Salary	Base Hourly Rate	Fringe	Labor O/H	G&A	Subtotal	Profit	Fully Burdened Rate
Management Analyst	John Smith	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

File details come from the government source that posted it.