Attachment_14_XCTC_Pricing_Workbook_20190319.xlsx

XLSX spreadsheet 60 KB Posted Mar 21, 2019

Attached to: eXportable Combat Training Capability (XCTC)
Solicitation number: W900KK-19-R-0003
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 pricing workbook attachment and draft solicitation for the eXportable Combat Training Capability program. The pricing workbook includes instructions for offerors to populate unit costs, rates, and labor categories for providing exercise planning and support, property management, systems support, rotations, travel, opposing forces personnel and vehicles, civilians on the battlefield simulations, foreign language role players, contract data requirements, and contract management review assistance over a five year period. It also includes templates for offerors to identify fully burdened labor rates by location and year. The draft solicitation provides an overview of the eXportable Combat Training Capability program, operated by the Army National Guard to enable brigade combat teams to achieve trained proficiency in core missions through force-on-force and live-fire training exercises. It indicates the Army Contracting Command in Orlando intends to award a full and open contract and is releasing the draft in advance to allow industry to provide feedback on requirements by March 4, 2019 prior to issuing a final RFP.

From the source

Updated Draft Pricing workbook

View the file

Other files

File	Type	Posted
XCTC_IDIQ_RFP_Amendment_0002_conformed_track_changes.docx	DOCX document	May 14, 2019
XCTC_IDIQ_RFP_Amendment_0002.docx	DOCX document	May 14, 2019
Attachment_33_Camp_Guernsey_WD_15-5414_Rev_07.pdf	PDF	May 3, 2019
Attachment_14_XCTC_Pricing_Workbook_2019-04-30.xlsx	XLSX spreadsheet	May 3, 2019
Attachment_32_Sample_Task_Order_PWS_2019-04-30_track_changes.docx	DOCX document	May 3, 2019
XCTC_IDIQ_RFP_Amendment_0001.docx	DOCX document	May 3, 2019
Attachment_31_Sample_Task_Order_2019-04-30_track_changes.docx	DOCX document	May 3, 2019
Attachment_07_Potential_XCTC_training_locations_2019-04-30.xlsx	XLSX spreadsheet	May 3, 2019
Attachment_34_RFP_Q_and_A_2019-04-30.xlsx	XLSX spreadsheet	May 3, 2019
XCTC_IDIQ_RFP_Amendment_0001_conformed_track_changes.docx	DOCX document	May 3, 2019
Attachment_01_IDIQ_PWS_2019-04-30_track_changes.docx	DOCX document	May 3, 2019
Attachment_31_Sample_Task_Order_2019-04-30.docx	DOCX document	May 3, 2019
Attachment_02_GFP_List_2019-04-30.xlsx	XLSX spreadsheet	May 3, 2019
Exhibit_11_XCTC_CDRL_(SB_Sub_Report)_A010.pdf	PDF	Apr 16, 2019
Exhibit_10_XCTC_CDRL_(SBU_Use_Report)_A009.pdf	PDF	Apr 16, 2019
Exhibit_12__XCTC_CDRL_(QCP)_A011.pdf	PDF	Apr 16, 2019
Exhibit_02_XCTC_CDRL_(Mo_Rpt)_A001.pdf	PDF	Apr 16, 2019
Exhibit_07_XCTC_CDRL_(DAL)_A006.pdf	PDF	Apr 16, 2019
Exhibit_09_XCTC_CDRL_(OPSEC_Pln)_A008.pdf	PDF	Apr 16, 2019
Exhibit_04_XCTC_CDRL_(STIG_Rpt)_A003.pdf	PDF	Apr 16, 2019
Exhibit_06_XCTC_CDRL_(RMF)_A005.pdf	PDF	Apr 16, 2019
Exhibit_08_XCTC_CDRL_(GFE_INV_RPT)_A007.pdf	PDF	Apr 16, 2019
Exhibit_03_XCTC_CDRL_(Meet_min)_A002.pdf	PDF	Apr 16, 2019
Exhibit_01_XCTC_DD254.pdf	PDF	Apr 16, 2019
Exhibit_05_XCTC_CDRL_(RISK_Man_Pln)_A004.pdf	PDF	Apr 16, 2019
Example_04_Planning_Conferences.pptx	PPTX presentation	Apr 16, 2019
Example_01_RD_Monthly_Telecon_Slides.pptx	PPTX presentation	Apr 16, 2019
Example_03_Five-year_Rotation_Tracker.xlsx	XLSX spreadsheet	Apr 16, 2019
Example_06_Concept_Brief.pptx	PPTX presentation	Apr 16, 2019
Example_08_Trng_Res_Req_Matrix.xlsx	XLSX spreadsheet	Apr 16, 2019
Example_13_Academy_Trng_Schedule.pptx	PPTX presentation	Apr 16, 2019
Example_07_XCTC_Leader_Book_.pdf	PDF	Apr 16, 2019
Example_10_EXROE.pptx	PPTX presentation	Apr 16, 2019
Example_05_Rotation_Brief.pptx	PPTX presentation	Apr 16, 2019
Example_12_XCTC_Mission_Book.pdf	PDF	Apr 16, 2019
Example_02_Six-Month_event_calendar.xlsx	XLSX spreadsheet	Apr 16, 2019
Example_09_Exercise_Directive.pdf	PDF	Apr 16, 2019
Example_11_Horse_Blanket_20190318.xlsx	XLSX spreadsheet	Apr 16, 2019
Example_14_MILES_Request.pdf	PDF	Apr 16, 2019
RTS-comms-shelter_B3.pdf	PDF	Apr 16, 2019
100-300_Manual_Rev_B3.pdf	PDF	Apr 16, 2019
Masthead_Assembly_Design_Documents.zip	ZIP file	Apr 16, 2019
5100_ES_Model_I_Operating_Manual_B3.pdf	PDF	Apr 16, 2019
Network_Operations_Center_Design_Documents.zip	ZIP file	Apr 16, 2019
Base-X_Dome_manual_Rev_B3.pdf	PDF	Apr 16, 2019
Video_Take_Home_Package_BoM.zip	ZIP file	Apr 16, 2019
FREDI-2_Basic_Transit_Case_Design_Documents.zip	ZIP file	Apr 16, 2019
Administrative_Communications_Center.zip	ZIP file	Apr 16, 2019
IC-OUM-08002_2.3_B3.pdf	PDF	Apr 16, 2019
IC-OUM-07010_1.4_v2_(002)_B3.pdf	PDF	Apr 16, 2019

Show 40 more

Latest 50 of 233 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.

Attachment 14

Instructions: The Offeror shall populate all YELLOW highlighted cells.

Base Year
CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT COST	AMOUNT
1	Exercise Planning & Support	FFP	12	Month

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
0002	Property Management	FFP	12	Month

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
0003	Systems	FFP	12	Month

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
4	Rotations	FFP	1	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
5	Travel (excluding rotations)	Cost	1	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
6	OPFOR Personnel	FFP	1	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
7	OPFOR Vehicles	FFP	1	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
8	Civilians on the Battlefield	FFP	1	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
9	Foreign Language Role Players	FFP	1	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
10	CDRLS	NSP	1	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
11	CMRA	FFP	1	Each

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
12	Transition-In	FFP	2	Month

Subtotal $ -

Option Year 1
CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT COST	AMOUNT
1001	Exercise Planning & Support	FFP	12	Month

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
1002	Property Management	FFP	12	Month

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
1003	Systems	FFP	12	Month

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
1004	Rotations	FFP	1	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
1005	Travel (excluding rotations)	Cost	1	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
1006	OPFOR Personnel	FFP	1	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
1007	OPFOR Vehicles	FFP	1	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
1008	Civilians on the Battlefield	FFP	1	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
1009	Foreign Language Role Players	FFP	1	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
1010	CDRLS	NSP	1	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
1011	CMRA	FFP	1	Each

Subtotal $ -

Option Year 2
CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT COST	AMOUNT
2001	Exercise Planning & Support	FFP	12	Month

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
2002	Property Management	FFP	12	Month

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
2003	Systems	FFP	12	Month

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
2004	Rotations	FFP	1	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
2005	Travel (excluding rotations)	Cost	1	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
2006	OPFOR Personnel	FFP	1	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
2007	OPFOR Vehicles	FFP	1	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
2008	Civilians on the Battlefield	FFP	1	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
2009	Foreign Language Role Players	FFP	1	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
2010	CDRLS	NSP	1	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
2011	CMRA	FFP	1	Each

Subtotal $ -

Option Year 3
CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT COST	AMOUNT
3001	Exercise Planning & Support	FFP	12	Month

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
3002	Property Management	FFP	12	Month

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
3003	Systems	FFP	12	Month

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
3004	Rotations	FFP	1	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
3005	Travel (excluding rotations)	Cost	1	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
3006	OPFOR Personnel	FFP	1	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
3007	OPFOR Vehicles	FFP	1	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
3008	Civilians on the Battlefield	FFP	1	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
3009	Foreign Language Role Players	FFP	1	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
3010	CDRLS	NSP	1	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
3011	CMRA	FFP	1	Each

Subtotal $ -

Option Year 4
CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT COST	AMOUNT
4001	Exercise Planning & Support	FFP	12	Month

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
4002	Property Management	FFP	12	Month

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
4003	Systems	FFP	12	Month

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
4004	Rotations	FFP	1	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
4005	Travel (excluding rotations)	Cost	1	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
4006	OPFOR Personnel	FFP	1	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
4007	OPFOR Vehicles	FFP	1	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
4008	Civilians on the Battlefield	FFP	1	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
4009	Foreign Language Role Players	FFP	1	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
4010	CDRLS	NSP	1	Lot

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
4011	CMRA	FFP	1	Each

CLIN	DESCRIPTION	C TYPE	QUANTITY	UNIT	UNIT PRICE	AMOUNT
4012	Transition-Out	FFP	2	Month

Subtotal

Rotation Price Matrix 14a

The offeror shall input their proposed price for each rotation type for each location.

	Base/Post	State	IBCT	ABCT	SBCT	FAB
Base Year	Fort Drum	NY
	Fort Pickett	VA
	Fort Stewart	GA
	Camp Blanding	FL
	Fort Knox	KY
	Camp Grayling	MI
	Camp Atterbury	IN
	Camp Ripley	MN
	Camp Shelby	MS
	Fort Chaffee	AR
	Fort Bliss	TX
	Fort Hood	TX
	Orchard Combat Training Center	ID
	Yakima Training Center	WA
	Camp Roberts/Hunter Liggett	CA
Option Year 1	Fort Drum	NY
	Fort Pickett	VA
	Fort Stewart	GA
	Camp Blanding	FL
	Fort Knox	KY
	Camp Grayling	MI
	Camp Atterbury	IN
	Camp Ripley	MN
	Camp Shelby	MS
	Fort Chaffee	AR
	Fort Bliss	TX
	Fort Hood	TX
	Orchard Combat Training Center	ID
	Fort Riley	KS
	Yakima Training Center	WA
	Camp Roberts/Hunter Liggett	CA
Option Year 2	Fort Drum	NY
	Fort Pickett	VA
	Fort Stewart	GA
	Camp Blanding	FL
	Fort Knox	KY
	Camp Grayling	MI
	Camp Atterbury	IN
	Camp Ripley	MN
	Camp Shelby	MS
	Fort Chaffee	AR
	Fort Bliss	TX
	Fort Hood	TX
	Orchard Combat Training Center	ID
	Fort Riley	KS
	Yakima Training Center	WA
	Camp Roberts/Hunter Liggett	CA
Option Year 3	Fort Drum	NY
	Fort Pickett	VA
	Fort Stewart	GA
	Camp Blanding	FL
	Fort Knox	KY
	Camp Grayling	MI
	Camp Atterbury	IN
	Camp Ripley	MN
	Camp Shelby	MS
	Fort Chaffee	AR
	Fort Bliss	TX
	Fort Hood	TX
	Orchard Combat Training Center	ID
	Fort Riley	KS
	Yakima Training Center	WA
	Camp Roberts/Hunter Liggett	CA
Option Year 4	Fort Drum	NY
	Fort Pickett	VA
	Fort Stewart	GA
	Camp Blanding	FL
	Fort Knox	KY
	Camp Grayling	MI
	Camp Atterbury	IN
	Camp Ripley	MN
	Camp Shelby	MS
	Fort Chaffee	AR
	Fort Bliss	TX
	Fort Hood	TX
	Orchard Combat Training Center	ID
	Fort Riley	KS
	Yakima Training Center	WA
	Camp Roberts/Hunter Liggett	CA

Attachment 14b

Identify the labor categories that will be required, provide description, eduction level and number of years experience.
Labor Traceability Matrix
LABOR CATEGORY	DEFINITION	OFFEROR'S LABOR CATEGORY	WD LABOR CATEGORY
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. Requires xx number of years of experience and x level of education.

Attachment 14c Offeror's Name: "Offeror"

	Rates (and FCCM Factors)	Base year	Option
Year 01	Option
Year 02	Option
Year 03	Option
Year 04	Option
Year 05	Definition and Allocation Base
		5.00%	5.10%	5.20%	5.30%	5.40%	5.35%	These rates are samples to show formula breakout.*	Identify Where in the Proposal the Basis of Estimate for Each Rate is Located.
	Base Labor Rate Escalation
	Labor Fringe
	Overhead
	Material Handing
	Subcontractor Handling
	G&A
	Proposed Fee (Cost CLINs)
	Proposed Profit (FFP CLINs)
	Instructions:
		1. If any of the rates/factors are not used in your indirect rate structures in your accounting system, leave the blocks empty and enter "Not Applicable" in the column titled "Definition and Allocation Base".
		2. Each Offeror shall supply their applicable rates for Base and the Option Years and 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 describing the base used for application of each indirect rate: For example, G&A would be, Total Cost Input, Single Element (Direct Labor Cost) or Value Added (excludes …. and … ).
		4. If you have additional rates/factors as part of your indirect rtae structure as defined in your accounting policies and procedures, you can add rows as needed.

Attachment 14d For each location identified in Attachment 07 (XCTC Training Locations and Types of Teams Supported), the offeror shall propose labor categories and labor rates for the OPFOR Personnel, Civilians on the Battlefield, and Foreign Language Role Players. The Offeror shall ensure that each labor rate applicable to the Wage Determination (WD) meets the minimum wage requirement for the corresponding labor category identified in the Wage Determination attachments. The Offeror shall match each proposed Labor Category to the applicable WD Labor Category and annotate in Column D:

a. The Offeror shall annotate “Applicable” if it feels the category proposed can be adequately mapped to an appropriate WD category/rate and shall provide the category title and rate, or

b. The Offeror shall annotate “Not Applicable” if the WD is not applicable to an Offeror’s Labor Category. If not applicable the Offeror shall disclose one of the following:

i. The Offeror shall annotate “Exempt” and shall provide a detailed explanation as to why if it feels the proposed category is exempted from the WD, or

ii. The Offeror shall annotate “SF 1444 Requested” if it believes that the proposed category requires incorporation into the applicable WD and shall provide a completed Standard Form (SF) 1444 in this Volume.

Offeror's Name:

"Offeror"

Fully Burdened Rate Build-up

Fully Burdened Rate by Category and by Year

Location

Labor Category

WD match

Base Labor Rate

Fringe Rate

Fringe Dollars

Sub-Total

Overhead Rate

Overhead Dollars

Sub-Total

G&A Rate

G&A Dollars

Sub-Total

Profit

Total

Location

Labor Category (Fully Burdened)

Base Year

Option

Year 01

Option

Year 02

Option

Year 03

Option

Year 04

Option

Year 05

File details come from the government source that posted it. Updated Dec 30, 2023.