Attachment 0007 Cost Price Workbook Final.xlsx

XLSX spreadsheet 39 KB Posted Aug 16, 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 · Aug 16, 2024

This document is a pricing workbook attachment related to a federal contract opportunity for Improved Environmental Control Units (IECUs). The contract includes four IECU variants: 9,000 BTU/hr, 18,000 BTU/hr single phase, 18,000 BTU/hr three-phase, and 36,000 BTU/hr three-phase.

The contract is structured as a hybrid, single award indefinite-delivery/indefinite-quantity (IDIQ) with firm-fixed-price (FFP), fixed-price economic price adjustment (FP-EPA), and cost reimbursable contract line items. The ordering period is 10 years. The workbook provides pricing details for the IECU units, production verification testing, first article testing, production, technical/engineering support, logistics support, and various data products. The workbook also includes pricing templates for shipping, travel, spare parts, and labor rates.

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
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 0007 Cost Price Workbook Final.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

See other tabs for data entry - Amounts will flow automatically. DO NOT change any formulas, formatting, or move any cells
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				Fill in YELLOW cells with prices for one unit (quantity information is provided to help you provide a unit price)
				DO NOT CHANGE any formulas, formatting, or move any cells
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	NSP	Priced separately on each order
0028	C.12	n/ap	FY26	Contractor Technical and Engineering Support	1	NSP	Priced separately on each order
0028	C.12	n/ap	FY27	Contractor Technical and Engineering Support	1	NSP	Priced separately on each order
0028	C.12	n/ap	FY28	Contractor Technical and Engineering Support	1	NSP	Priced separately on each order
0028	C.12	n/ap	FY29	Contractor Technical and Engineering Support	1	NSP	Priced separately on each order

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

Group 3. Data Products

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

Cost CLINs

Cost CLINs		The Government has provided values for Shipping and Travel as these are COST CLINs
						OPTION
Contract			Year	Description	$	Contract			Year	Description	$
CLIN	SECTION	CDRL				CLIN	SECTION	CDRL
Shipping						Shipping
0025	C.14	n/ap	FY25	Shipping	$50,000	2000	C.14	n/ap	FY30	Shipping	$50,000
0025	C.14	n/ap	FY26	Shipping	$50,000	2000	C.14	n/ap	FY31	Shipping	$50,000
0025	C.14	n/ap	FY27	Shipping	$100,000	2000	C.14	n/ap	FY32	Shipping	$100,000
0025	C.14	n/ap	FY28	Shipping	$100,000	2000	C.14	n/ap	FY33	Shipping	$100,000
0025	C.14	n/ap	FY29	Shipping	$100,000	2000	C.14	n/ap	FY34	Shipping	$100,000

Travel						Travel
0026	C.13	n/ap	FY25	Contractor Travel	$50,000	2001	C.13	n/ap	FY30	Contractor Travel	$50,000
0026	C.13	n/ap	FY26	Contractor Travel	$75,000	2001	C.13	n/ap	FY31	Contractor Travel	$75,000
0026	C.13	n/ap	FY27	Contractor Travel	$75,000	2001	C.13	n/ap	FY32	Contractor Travel	$75,000
0026	C.13	n/ap	FY28	Contractor Travel	$75,000	2001	C.13	n/ap	FY33	Contractor Travel	$75,000
0026	C.13	n/ap	FY29	Contractor Travel	$75,000	2001	C.13	n/ap	FY34	Contractor Travel	$75,000

Spare Parts Attachment 0005

	Fill in YELLOW cells with price for one unit
CLIN 0027					FY25	FY26	FY27	FY28	FY29
Item Name	IECU	Part Number	NSN	UOM	Unit price	Unit price	Unit price	Unit price	Unit price
Cable Assembly, IECU 5000, Power - Straight	9K	A1-48493D-1	6150-01-702-6823	Each
Cable Assembly, IECU 5000, Power - Angle	9K	A1-48493D-2	6150-01-702-6823
Cable Assembly, IECU 5100, Power - Straight	18K-1	A1-48494D-1	6150-01-702-7081
Cable Assembly, IECU 5100, Power - Angle	18K-1	A1-48494D-2	6150-01-702-7081
Cable Assembly, IECU 5200, Power - Straight	18K-3	A1-48495D-1	6150-01-702-7050
Cable Assembly, IECU 5200, Power - Angle	18K-3	A1-48495D-2	6150-01-702-7050
Cable Assembly, IECU 5300 or 5500, Power - Straight	36K	A1-48496D-1	6150-01-702-7097
Cable Assembly, IECU 5300 or 5500, Power - Angle	36K	A1-48496D-2	6150-01-702-7097
CLIN 2002					FY30	FY31	FY32	FY33	FY34
Item Name	IECU	Part Number	NSN	UOM	Unit price	Unit price	Unit price	Unit price	Unit price
Cable Assembly, IECU 5000, Power - Straight	9K	A1-48493D-1	6150-01-702-6823	Each
Cable Assembly, IECU 5000, Power - Angle	9K	A1-48493D-2	6150-01-702-6823
Cable Assembly, IECU 5100, Power - Straight	18K-1	A1-48494D-1	6150-01-702-7081
Cable Assembly, IECU 5100, Power - Angle	18K-1	A1-48494D-2	6150-01-702-7081
Cable Assembly, IECU 5200, Power - Straight	18K-3	A1-48495D-1	6150-01-702-7050
Cable Assembly, IECU 5200, Power - Angle	18K-3	A1-48495D-2	6150-01-702-7050
Cable Assembly, IECU 5300 or 5500, Power - Straight	36K	A1-48496D-1	6150-01-702-7097
Cable Assembly, IECU 5300 or 5500, Power - Angle	36K	A1-48496D-2	6150-01-702-7097

Labor Rates

Direct Labor Rates

Propose labor categories selected from the following source:

2018 SOC Manual (Entire Manual) (bls.gov)

https://www.bls.gov/soc/

Provide fully burdened hourly labor rates (including profit) to meet scope of work for CLIN 0028/2003 and CLIN 0029/2004.

Provide the basis for the proposed labor rates included, identifying any escalation rates and the profit rate (see Basis for Labor Rates tab).

Year 1

Year 2

Year 3

Year 4

Year 5

Year 6

Year 7

Year 8

Year 9

Year 10

Labor Category

Labor Hours

Labor Rate

https://www.bls.gov/soc/2018/soc_2018_manual.pdfhttps://usg01.safelinks.protection.office365.us/?url=https%3A%2F%2Fwww.bls.gov%2Fsoc%2F&data=05%7C02%7Cjoann.mattos.civ%40army.mil%7Cccd4d0e3ace4472d2f2308dcbd57db75%7Cfae6d70f954b481192b60530d6f84c43%7C0%7C0%7C638593432260463785%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=ZWrzNvEpIycKsYpUm043SxenypDaJ13rrlJhHlwH4bc%3D&reserved=0 Basis for Labor Rates

Basis of Labor Rates CLIN 0028/2003 and CLIN 0029/2004

Provide basis for direct labor rate:

Provide your fringe rate and basis:

Provide your labor overhead rate and basis:

Provide your G&A rate and basis:

Identify the profit rate and basis.

Identify any escalation applied and the basis for the escalation.

Unit Production

Unit Production					Fill in YELLOW cells with per unit price indexed to quantity
					DO NOT CHANGE any formulas, formatting, or move any cells
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 / 2005	C.11.1	n/ap	FY25	IECU - 9 kBTU/hr, 115 VAC, single-phase, Y1
0031 / 2006	C.11.1	n/ap	FY25	IECU - 18 kBTU/hr, 230 VAC, single-phase, Y1
0032 / 2007	C.11.1	n/ap	FY25	IECU - 18 kBTU/hr, 208 VAC, 3-phase, Y1
0033 / 2008	C.11.1	n/ap	FY25	IECU - 36 kBTU/hr, 208 VAC, 3-phase, Y1
0030 / 2005	C.11.1	n/ap	FY26	IECU - 9 kBTU/hr, 115 VAC, single-phase, Y2
0031 / 2006	C.11.1	n/ap	FY26	IECU - 18 kBTU/hr, 230 VAC, single-phase, Y2
0032 / 2007	C.11.1	n/ap	FY26	IECU - 18 kBTU/hr, 208 VAC, 3-phase, Y2
0033 / 2008	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 Aug 16, 2024.