Attachment 0007 Cost Price Workbook Final.xlsx

XLSX spreadsheet 30 KB Posted Jul 24, 2024

Attached to: Improved Environmental Control Units (9K/18K/36K IECU’s)
Solicitation number: W911QY24R0007
Issued by: Department of the Army Materiel Command Army Contracting Command Aberdeen Proving Ground

About this file

Written by GovTribe AI · Jul 24, 2024

This document is an attachment to a federal contract opportunity, specifically a Cost Price Workbook for the Improved Environmental Control Units (9K/18K/36K IECU's) Program. The key details are:

The federal contract opportunity is for the development, procurement, and fielding of a new generation of small IECUs to replace legacy Environmental Control Units (ECUs). It will involve the production of four basic "Horizontal Compact" IECU variants: 1) 9,000 BTUH, 115V, single phase; 2) 18,000 BTUH, 208V, 3-phase; 3) 18,000 BTUH, 230V, single phase; and 4) 36,000 BTUH, 208V, 3-phase. The contract will be a hybrid, single award IDIQ with FFP, FP-EPA, and a small percentage of cost reimbursable CLINs. The ordering period is anticipated to be 10 years. This Cost Price Workbook provides detailed pricing information for the various IECU units, production quantities, testing, technical support, and data deliverables.

View the file

Other files

File	Type	Posted
B08 Solicitation W911QY-24-R-0007 Amendment 0007 04SEPT2024.pdf	PDF	Sep 4, 2024
B08 Solicitation W911QY-24-R-0007 Amendment 0007 Conformed 04SEPT2024.pdf	PDF	Sep 4, 2024
B08 Solicitation W911QY-24-R-0007 Amendment 0006 Conformed 30AUG2024.pdf	PDF	Sep 3, 2024
B08 SAM updated Solicitation Amendment 0006 30Aug2024.pdf	PDF	Aug 30, 2024
B08 Solicitation W911QY-24-R-0007 Amendment 0005 Conformed.pdf	PDF	Aug 28, 2024
B08 Solicitation W911QY-24-R-0007 Amendment 0005 28AUG.pdf	PDF	Aug 28, 2024
B08 Solicitation W911QY-24-R-0007 Amendment 0004 27AUG.pdf	PDF	Aug 27, 2024
B08 Solicitation W911QY-24-R-0007 Amendment 0003 20AUG.pdf	PDF	Aug 20, 2024
B08 Solicitation W911QY-24-R-0007 Amendment 0003 Conformed 20AUG.pdf	PDF	Aug 20, 2024
B08 Solicitation W911QY-24-R-0007 Amendment 0002 Conformed 15AUG.pdf	PDF	Aug 18, 2024
Attachment 0007 Cost Price Workbook Final.xlsx	XLSX spreadsheet	Aug 16, 2024
CDRLs A001 - 043 IECU Amnd 0002 Aug 16.zip	ZIP file	Aug 16, 2024
B08 Att 0003 Integrated Product Support SOW Final.pdf	PDF	Aug 15, 2024
B08 Att 0005 Spare Parts for Contract Award.pdf	PDF	Aug 15, 2024
B08 Solicitation Att 0009 Past Performance Assessment Questionnaire.pdf	PDF	Aug 15, 2024
B08 Solicitation Att 0006 Small Business Subcontracting Worksheet.xlsx	XLSX spreadsheet	Aug 15, 2024
B08 Solicitation W911QY-24-R-0007 Amendment 0002 15AUG.pdf	PDF	Aug 15, 2024
CDRLs A001 - 043 IECU Amnd 0002.zip	ZIP file	Aug 15, 2024
B08 Solicitation W911QY-24-R-0007 Amendment 0002 Conformed 15AUG.pdf	PDF	Aug 15, 2024
B08 Soliciatation W911QY24R0007 IECU (1).pdf	PDF	Aug 8, 2024
B08 Solicitation W911QY-24-R-0007 Amendment 0001Conformed.pdf	PDF	Aug 8, 2024
B08 Solicitation W911QY-24-R-0007 Amendment 0001.pdf	PDF	Aug 8, 2024
Exhibit A CDRLs.zip	ZIP file	Aug 8, 2024
Att 0009 Past Performance Assessment Questionnaire.pdf	PDF	Aug 7, 2024
Attachment 0003 Integrated Product Support SOW Final.pdf	PDF	Jul 25, 2024
B08 Soliciatation W911QY24R0007 IECU.pdf	PDF	Jul 24, 2024
Attachment 0002 Interface Standard MIL-STD-1408D (2 Apr 2009) Final.pdf	PDF	Jul 24, 2024
Attachment 0010 Cable Assembly Drawings Final.pdf	PDF	Jul 24, 2024
Attachment 0006 Small Business Subcontracting Goals Worksheet.xlsx	XLSX spreadsheet	Jul 24, 2024
Attachment 0008 Past Performance Information Final.pdf	PDF	Jul 24, 2024
Attachment 0004 List of Acronyms Final.pdf	PDF	Jul 24, 2024
Attachment 0009 Past Performance Assessment Questionnaire Final.docx	DOCX document	Jul 24, 2024
Exhibit A CDRLs.zip	ZIP file	Jul 24, 2024
Attachment 0001 Performance Purchase Description.pdf	PDF	Jul 24, 2024
Attachment 0005 Spare parts pricing Final.xlsx	XLSX spreadsheet	Jul 24, 2024

Show all 35

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.

Total Evaluated Price

System Support Package	$0.00
PVT Units	$0.00
Conduct PVT	$0.00
FAT Units	$0.00
Conduct FAT	$0.00
Conduct PCA	$0.00
9K Production	$0.00
18K-1 Production	$0.00
18K-3 Production	$0.00
36 K Production	$0.00
CDRLs	$0.00	Data License Rights not included
TOTAL EVALUATED PRICE	$0.00

Base CLINs Base CLINs

Contract			Year	Description	Qty	$
CLIN	SECTION	CDRL
Group 1. Preparation

SubGroup 1a. 9K
0001	C.8	n/ap	FY25	System Support Package (SSP, 9K)	1
0002	C.9.1	n/ap	FY25	Fabricate Production Verification Test (PVT) Units (9K)	8
0003	C.9.5	n/ap	FY25	Conduct PVT (9K)	1
0004	C.10.1	n/ap	FY25	Fabricate First Article Test (FAT) Units (9K)	8
0005	C.10.5	n/ap	FY25	Conduct FAT (9K)	1
0006	C.10.8	n/ap	FY25	Conduct Physical Configuration Audit (PCA, 9K)	1

SubGroup 1a. 18K-1
0007	C.8	n/ap	FY25	System Support Package (SSP, 18K-1)	1
0008	C.9.1	n/ap	FY25	Fabricate Production Verification Test (PVT) Units (18K-1)	8
0009	C.9.5	n/ap	FY25	Conduct PVT (18K1)	1
0010	C.10.1	n/ap	FY25	Fabricate First Article Test (FAT) Units (18K-1)	8
0011	C.10.5	n/ap	FY25	Conduct FAT (18K-1)	1
0012	C.10.8	n/ap	FY25	Conduct Physical Configuration Audit (PCA, 18K-1)	1

SubGroup 1a. 18K-3
0013	C.8	n/ap	FY25	System Support Package (SSP, 18K-3)	1
0014	C.9.1	n/ap	FY25	Fabricate Production Verification Test (PVT) Units (18K-3)	8
0015	C.9.5	n/ap	FY25	Conduct PVT (18K-3)	1
0016	C.10.1	n/ap	FY25	Fabricate First Article Test (FAT) Units (18K-3)	8
0017	C.10.5	n/ap	FY25	Conduct FAT (18K-3)	1
0018	C.10.8	n/ap	FY25	Conduct Physical Configuration Audit (PCA, 18K-3)	1

SubGroup 1a. 36K
0019	C.8	n/ap	FY25	System Support Package (SSP, 36K)	1
0020	C.9.1	n/ap	FY25	Fabricate Production Verification Test (PVT) Units (36K)	8
0021	C.9.5	n/ap	FY25	Conduct PVT (36K)	1
0022	C.10.1	n/ap	FY25	Fabricate First Article Test (FAT) Units (36K)	8
0023	C.10.5	n/ap	FY25	Conduct FAT (36K)	1
0024	C.10.8	n/ap	FY25	Conduct Physical Configuration Audit (PCA, 36K)	1

Group 2. Production

SubGroup 2d. Technical & Engineering Support
0028	C.12	n/ap	FY25	Contractor Technical and Engineering Support	1	Priced separately on each order
0028	C.12	n/ap	FY26	Contractor Technical and Engineering Support	1	Priced separately on each order
0028	C.12	n/ap	FY27	Contractor Technical and Engineering Support	1	Priced separately on each order
0028	C.12	n/ap	FY28	Contractor Technical and Engineering Support	1	Priced separately on each order
0028	C.12	n/ap	FY29	Contractor Technical and Engineering Support	1	Priced separately on each order

SubGroup 2e. Logistics Support
0029	C.13	n/ap	FY25	Contractor Logisitics Support	1	Priced separately on each order
0029	C.13	n/ap	FY26	Contractor Logisitics Support	1	Priced separately on each order
0029	C.13	n/ap	FY27	Contractor Logisitics Support	1	Priced separately on each order
0029	C.13	n/ap	FY28	Contractor Logisitics Support	1	Priced separately on each order
0029	C.13	n/ap	FY29	Contractor Logisitics Support	1	Priced separately on each order

Group 3. Data Products

0034	C.SS.4.1	A001	FY25	Safety Assessment Report (SAR)	4
0034	C.6.2.2	A002	FY25	Concept Design Review (CoDR)	4
0034	C.6.2.3	A003	FY25	Preliminary Design Review (PDR)	4
0034	C.6.2.4	A004	FY25	Critical Design Review (CDR)	4
0034	C.9.7	A005	FY25	Production Verification Test (PVT) Report (PVTR)	4
0034	C.10.7	A006	FY25	First Article Test (FAT) Report (FATR)	4
0034	C.21.1	A007	FY25	Technical Data Package (TDP), Level 3	4
0034	C.21.2	A008	FY25	Data License Agreement (DLA)	4
0034	C.10.8	A009	FY25	Physical Configuration Audit (PCA) Plan and Report	4
0034	C.22	A010	FY25	Failure Modes, Effects, and Criticality Analysis (FMECA)	4
0034	IPSSOW	A011	FY25	Fault Tree Analysis (FTA)	4
0034	IPSSOW	A012	FY25	Maintenance Task Analysis (MTA)	4
0034	IPSSOW	A013	FY25	Level of Repair Analysis (LORA)	4
0034	IPSSOW	A014	FY25	Maintenance Allocation Chart (MAC)	4
0034	IPSSOW	A015	FY25	Provisioning Parts List (PPL)	4
0034	IPSSOW	A016	FY25	Engineering Data for Provisioning (EDFP)	4
0034	IPSSOW	A017	FY25	Technical Manual (TM) Validation Plan and Report (TMVPR)	4
0034	IPSSOW	A018	FY25	TM Operation and Maintenance, including Repair Parts and Special Tools List (-12&P TM)	4
0034	IPSSOW	A019	FY25	Interactive Multi-Media Instruction (IMI)	4
0034	IPSSOW	A020	FY25	Conduct of Training (CoT, OPNET)	4
0034	IPSSOW	A021	FY25	Program of Instruction (PoI, OPNET)	4
0034	IPSSOW	A022	FY25	Instructional Performance Requirements Document (IPRD, OPNET)	4
0034	IPSSOW	A023	FY25	Lesson Plan/Student Handouts/Visual Aids (LP-SG-VA, OPNET)	4
0034	IPSSOW	A024	FY25	Lesson Plan/Student Handouts/Visual Aids (LP-SG-VA, FLMNET)	4
0034	IPSSOW	A025	FY25	Logistics Management Information (LMI), Preservation & Packaging	4
0034	IPSSOW	A026	FY25	Program of Instruction (PoI, FLMNET)	4
0034	IPSSOW	A027	FY25	Instructional Performance Requirements Document (IPRD, FLMNET)	4
0034	IPSSOW	A028	FY25	Conduct of Training (CoT, FLMNET)	4
0034	IPSSOW	A029	FY25	Parts Screening Data (PSD)	4
0034	IPSSOW	A030	FY25	Proposed Spare Parts List (PSPL)	4
0034	IPSSOW	A031	FY25	Modification Work Order (MWO)	4
0034	IPSSOW	A032	FY25	MWO Plan & Report (MWOP)	4
0034	IPSSOW	A033	Y1-5	Monthly Status Report/Integrated Master Schedule (MSR)	60
0034	IPSSOW	A034	FY25	Production Verification Test (PVT) Plan	4
0034	IPSSOW	A035	FY25	First Article Test (FAT) Plan	4
0034	IPSSOW	A036	FY25	Care of Supplies in Storage Plan (COSIS)	4
0034	IPSSOW	A037	FY25	Contractor Quality Assurance Plan (CQAP)	4
0034	IPSSOW	A038	FY25	Production Acceptance Test and Inspection Plan (PATIP)	1	NSP
0034	IPSSOW	A039	FY25	Configuration Control Documents (CCD)	1	NSP
0034	IPSSOW	A040	FY25	System Support Package Component List (SSPCL)	4
0034	IPSSOW	A041	FY25	TM Quality Assurance Plan (TMQAP)	1
0034	IPSSOW	A042	FY25	Arsenal Utilization Report (AUR)	4
0034	IPSSOW	A043	FY25	Special Packaging Instruction (SPI)	4

Cost CLINs Cost CLINs

Contract			Year	Description	$
CLIN	SECTION	CDRL
Shipping
0025	C.14	n/ap	FY25	Shipping
0025	C.14	n/ap	FY25	Shipping
0025	C.14	n/ap	FY26	Shipping
0025	C.14	n/ap	FY27	Shipping
0025	C.14	n/ap	FY28	Shipping
0025	C.14	n/ap	FY29	Shipping

Travel
0026	C.13	n/ap	FY25	Contractor Travel
0026	C.13	n/ap	FY25	Contractor Travel
0026	C.13	n/ap	FY26	Contractor Travel
0026	C.13	n/ap	FY27	Contractor Travel
0026	C.13	n/ap	FY28	Contractor Travel
0026	C.13	n/ap	FY29	Contractor Travel

Spare Parts (Cables) Spare Parts (i.e., Cables)

Contract			Year	Description	Per Unit Based on Quantity
CLIN	SECTION	CDRL			1	2-10	11-25	26-50	51-100	101-200	201-500+
0027	n/ap	n/ap	FY25	9K (Cable Assembly, IECU 5000, Power - Angle), Y1
0027	n/ap	n/ap	FY25	9K (Cable Assembly, IECU 5000, Power - Straight), Y1
0027	n/ap	n/ap	FY25	18K-1 (Cable Assembly, IECU 5100, Power - Straight), Y1
0027	n/ap	n/ap	FY25	18K-1 (Cable Assembly, IECU 5100, Power - Angle), Y1
0027	n/ap	n/ap	FY25	18K-3 (Cable Assembly, IECU 5200, Power - Straight), Y1
0027	n/ap	n/ap	FY25	18K-3 (Cable Assembly, IECU 5200, Power - Angle), Y1
0027	n/ap	n/ap	FY25	36K (Cable Assembly, IECU 5300, Power - Straight), Y1
0027	n/ap	n/ap	FY25	36K (Cable Assembly, IECU 5300, Power - Angle), Y1
0027	n/ap	n/ap	FY26	9K (Cable Assembly, IECU 5000, Power - Angle), Y2
0027	n/ap	n/ap	FY26	9K (Cable Assembly, IECU 5000, Power - Straight), Y2
0027	n/ap	n/ap	FY26	18K-1 (Cable Assembly, IECU 5100, Power - Straight), Y2
0027	n/ap	n/ap	FY26	18K-1 (Cable Assembly, IECU 5100, Power - Angle), Y2
0027	n/ap	n/ap	FY26	18K-3 (Cable Assembly, IECU 5200, Power - Straight), Y2
0027	n/ap	n/ap	FY26	18K-3 (Cable Assembly, IECU 5200, Power - Angle), Y2
0027	n/ap	n/ap	FY26	36K (Cable Assembly, IECU 5300, Power - Straight), Y2
0027	n/ap	n/ap	FY26	36K (Cable Assembly, IECU 5300, Power - Angle), Y2

Labor Rates Direct Labor Rates

Labor Category

Program Manager

Senior

Manager

General Engineer

Draftsman

Manufacturing Engineer

Quality Control Manager

Trainer

Product Support

Technician - Machinist

Technician - Assembler

Manufacturing Lead

Logistics/Tech Writer

Administrative Support

FY25

FY26

FY27

FY28

FY29

FY30

FY31

FY32

FY33

FY34

Unit Production Unit Production

Contract			Year	Description	Per Unit Based on Quantity
CLIN	SECTION	CDRL			1	2-10	11-25	26-50	51-100	101-200	201-500+
0030	C.11.1	n/ap	FY25	IECU - 9 kBTU/hr, 115 VAC, single-phase, Y1
0031	C.11.1	n/ap	FY25	IECU - 18 kBTU/hr, 230 VAC, single-phase, Y1
0032	C.11.1	n/ap	FY25	IECU - 18 kBTU/hr, 208 VAC, 3-phase, Y1
0033	C.11.1	n/ap	FY25	IECU - 36 kBTU/hr, 208 VAC, 3-phase, Y1
0030	C.11.1	n/ap	FY26	IECU - 9 kBTU/hr, 115 VAC, single-phase, Y2
0031	C.11.1	n/ap	FY26	IECU - 18 kBTU/hr, 230 VAC, single-phase, Y2
0032	C.11.1	n/ap	FY26	IECU - 18 kBTU/hr, 208 VAC, 3-phase, Y2
0033	C.11.1	n/ap	FY26	IECU - 36 kBTU/hr, 208 VAC, 3-phase, Y2

File details come from the government source that posted it. Updated Jul 24, 2024.