Attachment 13 Cost-Price Workbook Example_18Jun2020.xlsx

XLSX spreadsheet 43 KB Posted Jun 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 cost-price workbook example and related federal contract opportunity notice for the Army Ground Aerial Target Control System (AGATCS) Support, Development, and Production (SDP) program. The anticipated single award IDIQ contract will have a five year base ordering period and two optional one year ordering periods to provide AGATCS capabilities for aerial, maritime, and ground based targets. Services required under the contract include engineering, development, production, field service and support, repair and rebuild, parts and spares, cyber security requirements, and other data and reporting. Pricing will be both firm-fixed-price and cost-plus-fixed-fee. Interested vendors must submit any comments on the draft solicitation attachments by July 14, 2020 and register for a virtual one-on-one meeting with the Army by July 15, 2020. Anticipated award date is third quarter of fiscal year 2021. The opportunity is being conducted by the Department of the Army Materiel Command Contracting Command Orlando Contracting Center.

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 03 SAMPLE Order Draft.pdf	PDF	Jul 29, 2020
Attachment 02 Delivery Order 0001 Draft.pdf	PDF	Jul 29, 2020
Attachment 13 Cost-Price Workbook Example_Draft.xlsx	XLSX spreadsheet	Jul 29, 2020
W900KK-20-R-0020 AGATCS SDP RFP DRAFT-V2.pdf	PDF	Jul 29, 2020
W900KK-20-R-0020 AGATCS SDP RFP DRAFT.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
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 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 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.

Delicery Order 0001

Delivery Order 0001
CLIN	DESCRIPTION	C TYPE	QUANTITY	COST	AMOUNT
1	AGATCS Post-Award Conference	FFP	Job

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT PRICE	AMOUNT
2	Engineering/Development/Production	FFP	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT PRICE	AMOUNT
3	Engineering/Development/Production	CPFF	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT PRICE	AMOUNT
4	Field Service/Support	FFP	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT PRICE	AMOUNT
5	Field Service/Support	CPFF	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT PRICE	AMOUNT
6	Repair/Rebuild	FFP	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT PRICE	AMOUNT
7	Parts/Spares	FFP	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT PRICE	AMOUNT
8	Cyber Security Requirements	FFP	Lot

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

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

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

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT PRICE	AMOUNT
12	Enterprise Contract Manpower Reporting Application	NSP	Lot		NSP
	(eCMRA)

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

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

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT PRICE	AMOUNT
15	CAP	Cost	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT PRICE	AMOUNT
16	Reserve	FFP	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT PRICE	AMOUNT
17	Reserve	FFP	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT PRICE	AMOUNT
18	Reserve	FFP	Lot

19 Reserve FFP Lot

Total Delivery Order 0001 $0

Sample Order 0001

Sample Delivery Order 0001
CLIN	DESCRIPTION	C TYPE	QUANTITY	COST	AMOUNT
1	AGATCS Post-Award Conference	FFP	Job

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT PRICE	AMOUNT
2	Engineering/Development/Production	FFP	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT PRICE	AMOUNT
3	Engineering/Development/Production	CPFF	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT PRICE	AMOUNT
4	Field Service/Support	FFP	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT PRICE	AMOUNT
5	Field Service/Support	CPFF	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT PRICE	AMOUNT
6	Repair/Rebuild	FFP	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT PRICE	AMOUNT
7	Parts/Spares	FFP	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT PRICE	AMOUNT
8	Cyber Security Requirements	FFP	Lot

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

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

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

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT PRICE	AMOUNT
12	Enterprise Contract Manpower Reporting Application	NSP	Lot		NSP
	(eCMRA)

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

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

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT PRICE	AMOUNT
15	CAP	Cost	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT PRICE	AMOUNT
16	Reserve	FFP	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT PRICE	AMOUNT
17	Reserve	FFP	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT PRICE	AMOUNT
18	Reserve	FFP	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT PRICE	AMOUNT
19	Reserve	FFP	Lot

Total Sample Delivery Order 0001 $0

Indirect Rates Offeror's Name: "Offeror"

	Rates (and FCCM Factors)	Base	Option
Year 01	Option
Year 02	Option
Year 03	Option
Year 04	Option
52.217-8	Definition and Allocation Base
		5.00%	5.10%	5.20%	5.30%	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	Option Year 01 Labor Rate	Option Year 02 Labor Rate	Option Year 03 Labor Rate	Option Year 04 Labor Rate	Option 52.217-8 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.

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 Jun 29, 2020.