Attachment 13 Cost-Price Workbook Example_Draft.xlsx

XLSX spreadsheet 39 KB Posted Jul 29, 2020

Attached to: Army Ground Aerial Target Control System (AGATCS) Support, Development, and Production (SDP) Federal contract opportunity
Solicitation number: W900KK-20-R-0020
Issued by: Department of the Army Materiel Command Contracting Command Orlando Contracting Center

About this file

Written by GovTribe AI · Dec 30, 2023

This document contains a draft cost-price workbook and statement of work for the Army Ground Aerial Target Control System (AGATCS) Support, Development, and Production (SDP) indefinite delivery/indefinite quantity contract. The U.S. Army Contracting Command Orlando has a requirement for the U.S. Army Program Executive Officer for Simulation, Training, and Instrumentation to procure AGATCS SDP capabilities for aerial, maritime, and ground-based targets over a five-year base ordering period and two optional one-year ordering periods. The draft solicitation is released for industry review and input by July 14, 2020. Interested vendors must register by July 15 for virtual one-on-one meetings on July 21 to discuss. The anticipated award date is third quarter of 2021. The cost-price workbook includes cost line items and indirect rate tables for the base and option years. The statement of work outlines engineering, development, production, and data requirements.

View the file

Other files for this federal contract opportunity

Other files attached to Army Ground Aerial Target Control System (AGATCS) Support, Development, and Production (SDP), newest first.
File	Type	Posted
Attachment 02 Delivery Order 0001 Draft.pdf	PDF	Jul 29, 2020
W900KK-20-R-0020 AGATCS SDP RFP DRAFT-V2.pdf	PDF	Jul 29, 2020
Attachment 03 SAMPLE Order Draft.pdf	PDF	Jul 29, 2020
W900KK-20-R-0020 AGATCS SDP RFP DRAFT.pdf	PDF	Jun 29, 2020
Distribution Agreement AGATCS SDP.docx	DOCX document	Jun 29, 2020
Attachment 11 Quality Assurance Surveillance Plan (QASP)_Final_v.1.0_20Apr2020.pdf	PDF	Jun 29, 2020
Attachment 08_Clarification_Form (Industry Questions).doc	DOC document	Jun 29, 2020
Attachment 15 Government Furnished Property (GFP-GFE) 659.xlsx	XLSX spreadsheet	Jun 29, 2020
Attachment 03 Sample Orders 0001_RevB_16Jun2020.docx	DOCX document	Jun 29, 2020
Attachment 02A Delivery Order 0001 CDRLs_23Jun2020.docx	DOCX document	Jun 29, 2020
Attachment 13 Cost-Price Workbook Example_18Jun2020.xlsx	XLSX spreadsheet	Jun 29, 2020
Attachment 10 DCAA Preaward_Survey_of_Prospective_Contractor_Accounting_System_Checklist.pdf	PDF	Jun 29, 2020
Attachment 18 -Contract Labor Rates (FFP and CPFF Rates)_02Jun2020.docx	DOCX document	Jun 29, 2020
Attachment 04 Contract Datat Requirements List.pdf	PDF	Jun 29, 2020
Attachment 19 DATA Rights CDRLs Workbook_23Jun2020.xlsx	XLSX spreadsheet	Jun 29, 2020
Attachment 09 SF1408 Preaward_Survey_of_Prospective_Contractor_Accounting_System.pdf	PDF	Jun 29, 2020
Attachment 07 Technical_Experience_Project_Worksheet (Factor-1).docx	DOCX document	Jun 29, 2020
Attachment 14_Cross_Reference_Matrix_03Jun2020.xlsx	XLSX spreadsheet	Jun 29, 2020
Attachment 04 Contract Datat Requirements List-CDRLs-AGATCS SDP 24Jun2020.pdf	PDF	Jun 29, 2020

Show all 19

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.

Delivery Order 0001

AGATCS SDP Delivery Order 0001
CLIN	DESCRIPTION	C TYPE	UNIT ISSUE	QUANTITY	UNIT PRICE	AMOUNT
1	Transition Phase-In	FFP	Months	2
	Year 1

CLIN	DESCRIPTION	C TYPE		QUANTITY	UNIT PRICE	AMOUNT
9	Cyber Security Requirements	CPFF	Lot	1
	Year 1

CLIN	DESCRIPTION	C TYPE		QUANTITY	UNIT PRICE	AMOUNT
10	Contract Data Requirements (CDRLs)	FFP	Lot	1		NSP
	Year 1

CLIN	DESCRIPTION	C TYPE		QUANTITY	UNIT PRICE	AMOUNT
12	Manpower Reporting	FFP	Lot	1		NSP
	Year 1

CLIN	DESCRIPTION	C TYPE		QUANTITY	UNIT PRICE	AMOUNT
13	Other Direct Costs	Cost	Lot	1
	Year 1

CLIN	DESCRIPTION	C TYPE		QUANTITY	UNIT PRICE	AMOUNT
14	GFP	FFP	Lot	1		NSP
	Year 1

CLIN	DESCRIPTION	C TYPE		QUANTITY	UNIT PRICE	AMOUNT
15	Contractor Acquired Property (CAP)	FFP	Lot	1		NSP
	Year 1

CLIN	DESCRIPTION	C TYPE		QUANTITY	UNIT PRICE	AMOUNT
16	Travel	Cost	Lot	1
	Year 1

CLIN	DESCRIPTION	C TYPE		QUANTITY	UNIT PRICE	AMOUNT
1009	Cyber Security Requirements	CPFF	Lot	1
	Year 2

CLIN	DESCRIPTION	C TYPE		QUANTITY	UNIT PRICE	AMOUNT
1010	Contract Data Requirements (CDRLs)	FFP	Lot	1		NSP
	Year 2

CLIN	DESCRIPTION	C TYPE		QUANTITY	UNIT PRICE	AMOUNT
1012	Manpower Reporting	FFP	Lot	1		NSP
	Year 2

CLIN	DESCRIPTION	C TYPE		QUANTITY	UNIT PRICE	AMOUNT
1013	Other Direct Costs	Cost	Lot	1
	Year 2

CLIN	DESCRIPTION	C TYPE		QUANTITY	UNIT PRICE	AMOUNT
1014	GFP	FFP	Lot	1		NSP
	Year 2

CLIN	DESCRIPTION	C TYPE		QUANTITY	UNIT PRICE	AMOUNT
1015	Contractor Acquired Property (CAP)	FFP	Lot	1		NSP
	Year 2

CLIN	DESCRIPTION	C TYPE		QUANTITY	UNIT PRICE	AMOUNT
1016	Travel	Cost	Lot	1
	Year 2

CLIN	DESCRIPTION	C TYPE		QUANTITY	UNIT PRICE	AMOUNT
2009	Cyber Security Requirements	CPFF	Lot	1
	Year 3

CLIN	DESCRIPTION	C TYPE		QUANTITY	UNIT PRICE	AMOUNT
2010	Contract Data Requirements (CDRLs)	FFP	Lot	1		NSP
	Year 3

CLIN	DESCRIPTION	C TYPE		QUANTITY	UNIT PRICE	AMOUNT
2012	Manpower Reporting	FFP	Lot	1		NSP
	Year 3

CLIN	DESCRIPTION	C TYPE		QUANTITY	UNIT PRICE	AMOUNT
2013	Other Direct Costs	Cost	Lot	1
	Year 3

CLIN	DESCRIPTION	C TYPE		QUANTITY	UNIT PRICE	AMOUNT
2014	GFP	FFP	Lot	1		NSP
	Year 3

CLIN	DESCRIPTION	C TYPE		QUANTITY	UNIT PRICE	AMOUNT
2015	Contractor Acquired Property (CAP)	FFP	Lot	1		NSP
	Year 3

CLIN	DESCRIPTION	C TYPE		QUANTITY	UNIT PRICE	AMOUNT
2016	Travel	Cost	Lot	1
	Year 3

CLIN	DESCRIPTION	C TYPE		QUANTITY	UNIT PRICE	AMOUNT
3009	Cyber Security Requirements	CPFF	Lot	1
	Year 4

CLIN	DESCRIPTION	C TYPE		QUANTITY	UNIT PRICE	AMOUNT
3010	Contract Data Requirements (CDRLs)	FFP	Lot	1		NSP
	Year 4

CLIN	DESCRIPTION	C TYPE		QUANTITY	UNIT PRICE	AMOUNT
3012	Manpower Reporting	FFP	Lot	1		NSP
	Year 4

CLIN	DESCRIPTION	C TYPE		QUANTITY	UNIT PRICE	AMOUNT
3013	Other Direct Costs	Cost	Lot	1
	Year 4

CLIN	DESCRIPTION	C TYPE		QUANTITY	UNIT PRICE	AMOUNT
3014	GFP	FFP	Lot	1		NSP
	Year 4

CLIN	DESCRIPTION	C TYPE		QUANTITY	UNIT PRICE	AMOUNT
3015	Contractor Acquired Property (CAP)	FFP	Lot	1		NSP
	Year 4

CLIN	DESCRIPTION	C TYPE		QUANTITY	UNIT PRICE	AMOUNT
3016	Travel	Cost	Lot	1
	Year 4

CLIN	DESCRIPTION	C TYPE		QUANTITY	UNIT PRICE	AMOUNT
4009	Cyber Security Requirements	CPFF	Lot	1
	Year 5

CLIN	DESCRIPTION	C TYPE		QUANTITY	UNIT PRICE	AMOUNT
4010	Contract Data Requirements (CDRLs)	FFP	Lot	1		NSP
	Year 5

CLIN	DESCRIPTION	C TYPE		QUANTITY	UNIT PRICE	AMOUNT
4012	Manpower Reporting	FFP	Lot	1		NSP
	Year 5

CLIN	DESCRIPTION	C TYPE		QUANTITY	UNIT PRICE	AMOUNT
4013	Other Direct Costs	Cost	Lot	1
	Year 5

CLIN	DESCRIPTION	C TYPE		QUANTITY	UNIT PRICE	AMOUNT
4014	GFP	FFP	Lot	1		NSP
	Year 5

CLIN	DESCRIPTION	C TYPE		QUANTITY	UNIT PRICE	AMOUNT
4015	Contractor Acquired Property (CAP)	FFP	Lot	1		NSP
	Year 5

CLIN	DESCRIPTION	C TYPE		QUANTITY	UNIT PRICE	AMOUNT
4016	Travel	Cost	Lot	1
	Year 5

Sample Order 0001

AGATCES SDP Sample Order 0001
CLIN	DESCRIPTION	C TYPE		QUANTITY	UNIT PRICE	AMOUNT
3	Engineering/Development/Production	CPFF	Lot	1

CLIN	DESCRIPTION	C TYPE		QUANTITY	UNIT PRICE	AMOUNT
10	Initial Contract Data Requirements (CDRLs)	FFP	Lot	1		NSP

CLIN	DESCRIPTION	C TYPE		QUANTITY	UNIT PRICE	AMOUNT
11	Technical Data Package (TDP)	FFP	Lot	1

CLIN	DESCRIPTION	C TYPE		QUANTITY	UNIT PRICE	AMOUNT
12	Manpower Reporting	NSP	Lot	1		NSP

CLIN	DESCRIPTION	C TYPE		QUANTITY	UNIT PRICE	AMOUNT
13	Other Direct Costs	Cost	Lot	1

CLIN	DESCRIPTION	C TYPE		QUANTITY	UNIT PRICE	AMOUNT
15	CAP	FFP	Lot	1		NSP

CLIN	DESCRIPTION	C TYPE		QUANTITY	UNIT PRICE	AMOUNT
16	Travel	Cost	Lot	1

Total Sample Delivery Order 0001

Indirect Rates Offeror's Name: "Offeror"

	Rates (and FCCM Factors)	Base	Order
Year 02	Order
Year 03	Order
Year 04	Order
Year 05	OPTIONAL Order
Year 06	OPTIONAL Order
Year 07	Definition and Allocation Base
		5.00%	5.10%	5.20%	5.30%	5.40%	5.40%	5.40%	These rates are samples to show formula breakout.*
	Labor Fringes
	Engineering Overhead
	Manufacturing Overhead
	Material Handing
	Subcontractor Handling
	G&A Expenses
	Proposed Fee (CPFF)
	Proposed Profit (FFP)
	Instructions:
		1. If any of the rates/factors are not used in your estimating/accounting systems, leave the yearly blocks empty & enter "Not Applicable" in the column titled "Definition and Allocation Base".
		2. Each Offeror shall supply their applicable rates for Base and all Four Option Years plus the Clause 52.217-8 Option to Extend Services. Offerors shall include a description and/or calculation of how their rates/factors were developed. That information can be included either below or elsewhere in your Cost/Price Volume.
		3. In the " Definition and Allocation Base" column, as a minimum, include a brief comment such as "Overhead is applied to base labor plus fringe." For G&A expenses: "Allocation base is Total Cost Input (or Single Element (Direct Labor Cost) or Value Added) and excludes …. and …".
		4. If you have additional rates/factors in your estimating/accounting systems, Offerors can add rows as needed.

Labor Rates Offeror's Name: "Offeror"

LABOR RATES
Offeror's Labor Category	Base Labor Rate	Order Year 02 Labor Rate	Order Year 03 Labor Rate	Order Year 04 Labor Rate	Order Year 05 Labor Rate	OPTIONAL Order Year 06 Labor Rate	OPTIONAL Order Year 07 Labor Rate
Example: Program Manger

It is the Government's Intent to included all proposed Labor Rates for each applicable year into the contract as 'Ceiling Labor Rates' at time of award. Offeror's shall fill in any additional rates they may utilize as appropriate for the base ordering period and all optional ordering period.

Labor Matrix

Labor Traceability Matrix
OFFEROR'S LABOR CATEGORY	DEFINITION	WD LABOR CATEGORY
EXAMPLE: Program Manager	Manages the information systems design, development, and analysis encompassing one or more of the following areas of technical expertise: computer programming, systems analysis, computer programming/analysis, systems analysis, applications programming, software development, systems integration, and related disciplines.	If Applicable

File details come from the government source that posted it. Updated Jul 29, 2020.