Attachment 13 Cost-Price Workbook Example_08142020.xlsx

XLSX spreadsheet 52 KB Posted Sep 4, 2020

Attached to: Army Ground Aerial Target Control System (AGATCS) Support, Development, and Production (SDP)
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 solicitation for the Army Ground Aerial Target Control System (AGATCS) Support, Development, and Production (SDP) requirements. The U.S. Army Contracting Command Orlando is soliciting proposals for an Indefinite Delivery/Indefinite Quantity contract to provide AGATCS capabilities for aerial, maritime, and ground based targets over a five year base period and two optional one year ordering periods. The anticipated single award contract will be managed by the U.S. Army Program Executive Officer for Simulation, Training, and Instrumentation (PEO STRI), Program Manager Cyber Test Training (PM CT2). Proposals are due as stated in the attached solicitation W900KK-20-R-0020, with any questions due no later than seven calendar days before the response date. A completed Distribution Agreement is required to obtain restricted documents related to the draft solicitation.

View the file

Other files

File	Type	Posted
Attachment 04A Contract Data Requirement List_Delivery Order 0001_2Sep2020.pdf	PDF	Sep 4, 2020
Attachment 09 SF1408 Preaward_Survey_of_Prospective_Contractor_Accounting_System.pdf	PDF	Sep 4, 2020
Attachment 03 AGATCS SDP Sample Orders 0001_RevB_2Sep2020.docx	DOCX document	Sep 4, 2020
Attachment 10 DCAA Preaward_Survey_of_Prospective_Contractor_Accounting_System_Checklist.pdf	PDF	Sep 4, 2020
Attachment 19 DATA Rights CDRLs Workbook_23Jun2020.xlsx	XLSX spreadsheet	Sep 4, 2020
Distribution_Agreement.pdf	PDF	Sep 4, 2020
Attachment 18 -Contract Labor Rates (FFP and CPFF Rates)_02Jun2020.docx	DOCX document	Sep 4, 2020
Attachment 02A AGATCS SDP Delivery Order 0001_2Sep2020.docx	DOCX document	Sep 4, 2020
Attachment 12 DD254.pdf	PDF	Sep 4, 2020
Attachment 04 Contract Data Requirement List (CDRL)_Base Contract_1Sep2020.pdf	PDF	Sep 4, 2020
W900KK20R0020.pdf	PDF	Sep 4, 2020
Attachment 15 Government Furnished Property (GFP-GFE) 659.xlsx	XLSX spreadsheet	Sep 4, 2020
Exhibit A Consolidated CDRL List Base and DO .docx	DOCX document	Sep 4, 2020
Attachment 11A Quality Assurance Surveillance (QASP) Delivery Order 0001_10Aug2020.pdf	PDF	Sep 4, 2020
Attachment 11 Quality Assurance Surveillance Plan (QASP)_Final_v.1.0_20Apr2020.pdf	PDF	Sep 4, 2020
Attachment 08_Clarification_Form (Industry Questions).doc	DOC document	Sep 4, 2020
Attachment 14_Cross_Reference_Matrix_03Jun2020.xlsx	XLSX spreadsheet	Sep 4, 2020
Attachment 07 Technical_Experience_Project_Worksheet (Factor-1).docx	DOCX document	Sep 4, 2020

Show all 18

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.

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

Total Delivery Order 0001 $0.00

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 Order 0001 $0

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 for example purposes only.
	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 Order Years. 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.

Rate Build-Up

The offeror will input their base rate for each labor category proposed and then apply indirect rates to demonstrate the development of a fully burdened rate through fee/profit for each category. The offeror can adjust this worksheet as needed to complete the calculation. For example, if the offeror does not have a separate Fringe Rate, those columns can be deleted.

Offeror's Name:

"Offeror"

Fully Burdened Rate Build-up

Labor Category

Base Labor Rate

Fringe Rate

Fringe Dollars

Sub-Total

Overhead Rate

Overhead Dollars

Sub-Total

G&A Rate

G&A Dollars

Sub-Total

Fee/Profit

Total

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 Sep 4, 2020.