CHS-5_Solicitation_Attachment_0007_-_CHS-5_Warranty_Input_Sheet_with_CEA_Tab_Final_.xlsx

XLSX spreadsheet 62 KB Posted Sep 16, 2017

Attached to: Common Hardware System 5th Generation (CHS-5)
Solicitation number: W15P7T17R0008
Issued by: Department of the Army Materiel Command Army Contracting Command Aberdeen Proving Ground

About this file

From the source

CHS-5 Solicitation Attachment 0007 - CHS-5 Warranty Input Sheet with CEA Tab Final

View the file

Other files

File	Type	Posted
CHS-5_Responses_to_Industry_Questions_dated_15_Sept_2017_(Industry_Responses_to_Post).docx	DOCX document	Sep 16, 2017
CHS-5_Solicitation_W15P7T17R0008_-_Amendment_0001.pdf	PDF	Sep 16, 2017
Solicitation_Attachment_0012_-_Small_Business_Participation	—	Sep 16, 2017
Solicitation Attachment 0005 - Contract Security Classification Specification - DD Form 2~.pdf	PDF	Sep 16, 2017
Solicitation Attachment 0006 - Pricing Spreadsheet_and_Instructions 12 Aug 17.xlsx	XLSX spreadsheet	Sep 16, 2017
CDRL C005 - TDP Developmental_SIGNED.pdf	PDF	Sep 16, 2017
CDRL B001 - FAT Report_SIGNED.pdf	PDF	Sep 16, 2017
Solicitation Attachment 0005 - DD254 Appendix D FOUO.doc	DOC document	Sep 16, 2017
Solicitation Attachment 0003 - CHS-5 PWS Appendix B -- Data Item Tables.xlsx	XLSX spreadsheet	Sep 16, 2017
CDRL C002 - V1+, V2, V3 Product Specs - Continuation.docx	DOCX document	Sep 16, 2017
CDRL B007 - Warranty Input Sheet_SIGNED Updated 31 May 17.pdf	PDF	Sep 16, 2017
Solicitation Attachment 0004 - CHS-5 PWS Appendix C -- Safety Specification.docx	DOCX document	Sep 16, 2017
CDRL C003 - User Guides_SIGNED as of 31 May 17.pdf	PDF	Sep 16, 2017
CDRL C006 - TDP Production_SIGNED.pdf	PDF	Sep 16, 2017
CDRL A005 - Phase-In Transition Plan_SIGNED.pdf	PDF	Sep 16, 2017
Solicitation Attachment 0011 -_CHS-4_Historical_Production_Data.xlsx	XLSX spreadsheet	Sep 16, 2017
Solicitation Attachment 0015 CHS Production Assessment Survey.docx	DOCX document	Sep 16, 2017
CDRL A001 - Program Protection Implementation Plan_SIGNED.pdf	PDF	Sep 16, 2017
Solicitation Attachment 0005 - Contract Security Classification Specification - DD Form 2~ .pdf	PDF	Sep 16, 2017
CDRL B003 - Failure Analysis_SIGNED.pdf	PDF	Sep 16, 2017
Solicitation Attachment 0002 - CHS-5 PWS Appendix A -- Survivability, Reliability, Verif.docx	DOCX document	Sep 16, 2017
Solicitation Attachment 0014 Past Performance Questionaire.docx	DOCX document	Sep 16, 2017
CDRL B005 - CHS-5 IDE_SIGNED Updated 31 May 17.pdf	PDF	Sep 16, 2017
Solicitation Attachment 0001 - CHS-5_PWS_v2.docx	DOCX document	Sep 16, 2017
CDRL B008 - Small Business Utilization Report v4 1430 170911.pdf	PDF	Sep 16, 2017
CDRL B004 - TASS Cost Report_SIGNED.pdf	PDF	Sep 16, 2017
CDRL A002 - Counterfeit Detection and Avoidance_SIGNED.pdf	PDF	Sep 16, 2017
Solicitation Attachment 0008 - CHS-5 V-1 Equipment Production List.xlsx	XLSX spreadsheet	Sep 16, 2017
CDRL B002 - EOL_SIGNED.pdf	PDF	Sep 16, 2017
Solicitation Attachment 0009 - CHS-5 V-1+ Equipment Production List.xlsx	XLSX spreadsheet	Sep 16, 2017
CDRL C002 - V1+ V2 V3 Product Specs_SIGNED as of 31 May 17.pdf	PDF	Sep 16, 2017
CDRL C004 - PDR and CDR_SIGNED as of 31 May 17.pdf	PDF	Sep 16, 2017
CDRL A006 - QAPP_SIGNED.pdf	PDF	Sep 16, 2017
Solicitation Attachment 0013 - CHS-5 Contract Year 1 Activity Baseline.xlsx	XLSX spreadsheet	Sep 16, 2017
CHS-5 Solicitation W15P7T-17-R-0008.pdf	PDF	Sep 16, 2017
CDRL B006 - SAR_SIGNED.pdf	PDF	Sep 16, 2017
CDRL C001 - V1 Product Specs_SIGNED.pdf	PDF	Sep 16, 2017
CDRL A003 - FAT Plan_SIGNED.pdf	PDF	Sep 16, 2017
Solicitation Attachment 0010 - CHS-5 V-2 and OTC Equipment Production List.xlsx	XLSX spreadsheet	Sep 16, 2017
CDRL A004 - CM Plan_SIGNED.pdf	PDF	Sep 16, 2017
Solicitation Attachment 0005 - DD254 Appendix A COMSEC.pdf	PDF	Sep 16, 2017
CDRL_A005_-_Phase-In_Transition_Plan_SIGNED.pdf	PDF	Aug 25, 2017
CDRL_C002_-_V1+,_V2,_V3_Product_Specs_-_Continuation.docx	DOCX document	Aug 25, 2017
CDRL_A003_-_FAT_Plan_SIGNED.pdf	PDF	Aug 25, 2017
CDRL_B001_-_FAT_Report_SIGNED.pdf	PDF	Aug 25, 2017
CDRL_C005_-_TDP_Developmental_SIGNED.pdf	PDF	Aug 25, 2017
CDRL_B003_-_Failure_Analysis_SIGNED.pdf	PDF	Aug 25, 2017
CDRL_C001_-_V1_Product_Specs_SIGNED.pdf	PDF	Aug 25, 2017
CDRL_A006_-_QAPP_SIGNED.pdf	PDF	Aug 25, 2017
CDRL_C003_-_User_Guides_SIGNED.pdf	PDF	Aug 25, 2017

Show 40 more

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

Explanation Sheet

Warranty Cost Effectiveness Analysis Requirements

Explanation

Army Regulations require that any Army acquisition organizations considering the purchase of a warranty must first determine the cost-effectiveness of the warranty (AR 700-139 and AR 11–18). A Cost-Effectiveness (C–E) analysis is required to determine the value of the potential benefits received in comparison with the contract cost of the warranty plus the Army’s cost of administration and execution. A Warranty Cost Effectiveness Analysis estimates and compares the Government costs to maintain and support a weapon system under a “Warranty” (including the costs of the warranty and any one time and recurring costs to setup and manage the warranty program) versus the costs associated with not having the warranty. The No-Warranty alternative can be a repair contract on a time and material (T&M) basis or an Organic repair.

Warranty Length -

If the warranty coverage starts when the Government signed the DD250 at delivery and fielding is 3 months after the delivery; then the 2 years of warranty is actually has an effective coverage of 1 years and 9 months. When calculate no warranty alternative use 1 years and 9 months of failures data

Prior to the contract award, the requiring activity shall provide a validated Warranty Cost Effectiveness (C-E) Analysis for all priced warranties to the contracting officer. The CECOM G8, Cost and Systems Analysis (CSA) Division has the capability of performing and validating this Analysis. This Division also has extensive experience reviewing/performing these warranty analyses prior to validation. To facilitate this role, the CSA Division has compiled the following template that outlines some of the critical data elements necessary to perform this analysis.

Estimate Repair Cost

If there is no data for the no warranty alternative repair cost assume 65% of the unit price. This represents an upper bound for the repair costs, higher ratio is beyond economic repair

Spare Requirement

If the TAT for the warranty repair is 24 hrs and the TAT for no warranty repair is 72 hrs; the Government has to purchase additional initial depot level spares and also pay for cost of holding and managing those spares.

The data required for a warranty cost effectiveness analysis align with three major categories of information: Program and Hardware, Warranty Considerations, and No-warranty Considerations. The sources for the analysis input data are dependent upon the details outlined in the warranty proposal and are described in the table below. The specific data elements required for the analysis are outlined in the table on the following page.	Cost paid to the contractor for warranted repairs - Cost Category:
	1.) Repair parts	6.) Site Activation
	2.) Spare Parts	7.) Training
	3.) Repair Labor	8.) Transportation/Shipping
	4.) Test/Diagnostics/Repair Equipment	9.) Other Administration
	5.) Data

Economic Analysis

4.0 Economic Analysis

a.) A Net Present Value Economic Analysis (EA) was used to compare the costs of repairing the failures by the time and materials repair on a unit by unit basis versus purchasing the warranty from the contractor, BAE Systems. The EA is a time value of money concept; it simply means a dollar today is worth more than a dollar in the future. Since purchasing the three years of warranty extension at the beginning of the repair cycle, the analysis has to consider not only how much the alternative repair costs during the life of the system but also when the expenditures will be made.

b.) A .9% discount rate was used to compute the present value and is updated and published annually by the OMB (Office of Management and Budget, Circular No A-94 3 year real interest rates).

c.) A mid-year discount rate was used for the present value computations because it is the average period of time period when the repairs occurs.

Economic Analysis/Net Present Value
The Real Treasury Interest Rate is adjusted for inflation ( From OMB, circular No A-94 )
Net Discounted Present Value = Discounted Cost with Inflation included
PV=1/(1+i)^n	Use Mid Year
PV=1/(1+i)^n-.5	(Due to Repair is all year round)

Input Sheet

1.0 Program and Hardware Data			Yellow cells are for input data
Item	Data Source	Warranted Item Information

Author: Please provide one Excel file for each warranty item, and use "Warranty Item Name" as part of your file name to aviod confusion.

For example, warranty item name is "XYZ", then you may use "Warranty Input - XYZ" as the file name.	Input data	Note: DO NOT modify this form, otherwise it may cause confusion when it is imported to automated warranty analysis tool.
		1.1	-G-	Warranted Item Name (DO NOT LEAVE BLANK)
		1.2	-G-	Warranted Item Density (Quantity of )
		1.3	-C-	Unit Price
		1.4	-G-	Economic Life of a (Year)
		1.5	-G-	Average Annual Operations Tempo (hrs) per
			-G/C-	Operational Availability (Ao)
		1.6	-C-	Mean Time Between Failures (MTBF) (Unit: Hour)
		1.7	-G-	Discount Rate (%)
		1.8	-S-	Fill Rate (%)
		1.9	-C-	What is returned when a fails: the warranted item itself or the failed component of the ? (DO NOT LEAVE BLANK)
		1.10	-C-	False Removal Rate (%)
		Item	Data Source	Component Information (if identified in 1.9)	Input data
		1.12	-C-	How many different components are there? (DO NOT LEAVE BLANK)
		1.13	-C-	Component Name
		1.14	-C-	Quantity for that type of component per ?

Author: The sum of this row should NOT exceed 300, which is the maximum value allowed in the COMPASS. This cell will turn to RED if the sum exceeds 300.

Please put down a POSITIVE INTEGER in each yellow cell in this row.	1.15	-C-	Component Unit Price
		1.16	-C-	Mean Time Between Failures (MTBF) for Each Individual Component
		1.17	-S-	Average Price of Repair Per Component (Enter one of the below)
		1.17.1	-S-	a.) Average Time and Materials (T & M) Cost Per Repair or
		1.17.2	-S-	b.) If no Repair Cost is available, use 65% of the Component Unit Price as an upper bound or
		1.17.3	-S-	c.) Firm Fixed Price Per Repair
		1.18	-C-	Component False Removal Rate (%)
		1.19	-S-	Average Cost per Component False Removal
		1.20	-C-	Component Washout Rate not due to Battle Damage or Abuse (%)
		1.21	-C-	Percent of above washouts not covered under warranty (%)
		1.22	-C-	Percent of component repairs not covered under warranty (%)
		2.0 Warranty Considerations
		Item	Data Source	Warranty Cost Factors	Input data
		2.1	-G/C-	Type of Warranty Proposed (Failure Free or Other). If other, provide description.
		2.2	-G/C-	Warranty Length (months)
		2.3	-C-	Warranty Price Per for the entire warranty period
		2.4	-C-	Warranty Set Up Fixed Cost - Repair Facility Set Up Cost, etc (if not included in warranty price)

Author: Enter 0 if it is included in warranty.

2.5 -C- Average Additional Transportation Cost per failure (if not included in warranty price) Author: Enter 0 if it is included in warranty.

2.6 -C- Average Annual Warranty Tracking Database Cost per (if not included in the warranty price) Author: Enter 0 if it is included in warranty.

2.7	-C-	Washout Rate not due to Battle Damage or Abuse (%)
2.8	-C-	Percent of above washouts not covered under warranty (%)
2.9	-C-	Percent of Repairs not covered under Warranty (%)
2.10	-G/C-	Skip this row (it ONLY applies when you choose 'Warranted Item' in the cell E13)
2.11	-C-	Annual Contractor General & Administration (G&A) Cost outside Warranty Costs
2.12	-G/C-	Are there additional government personnel costs? (Additional questions follow if "Yes")

2.13	-G/C-	Does the Government Own the Spares During the Warranty Period?
2.14	-G/C-	Warranty Turnaround Time per Event (days)
Item	Data Source	Fielding Timeline	Input data
2.15	-G/C-	Warranty starts after Delivery or after Fielding (DO NOT LEAVE BLANK)
2.16	-G-	If after delivery, the average delay until fielding (Months)

Author: Leave it blank if you choose "Fielding" for the section 2.15 Author: Enter 0 if it is included in warranty.

Author: Enter 0 if it is included in warranty.

2.17	-G-	Calculated Effective Warranty Period (months)
3.0 No Warranty Considerations
Item	Data Source	No-Warranty Cost Factors	Input data
3.1		Basis for the Repair Costs per (Enter one of the below)

Author: The red color will be gone once one of the sub-items is greater than 0.

Author: This cell is optional.	3.1.1	-S-	a.) Average Time and Materials (T & M) Cost Per Repair or
		3.1.2	-G-	b.) If No Repair Cost, use 65% of Unit Price as Upper Bound or
		3.1.3	-C-	c.) Firm Fixed Price Per Repair
		3.2	-S-	Repair Set Up Fixed Cost for all the
		3.3	-S-	Washout Rate not due to Battle Damage or Abuse (%)
		3.4	-G/C-	Average Cost per false removal for the
		3.5	-G-	Average Additional Transportation Cost per Failure, if it is outside of Organic Transportation System and Not Included in Repair Price
		3.6	-S-	Average Annual General and Admin (G & A) cost if not included in above Repair Costs
		3.7	-G-	Does the Government Own the Spares During the Warranty Period?
		3.8	-S-	Repair Turnaround Time per Event (days) WITHOUT Warranty

G - Government; C - Contractor; G/C - Government RFP or Contractor Proposal; S - Source of Repair

Analysis Sheet

WARRANTY COST EFFECTIVENESS ANALYSIS FOR

	Support Information	Months	Years
	Warranty Period (Months/Years)	0	0.0000
	Effective Warranty Period (Months/Years)		ERROR:#VALUE!
		Annual	Warranty Period
	Average Warranty Failures	ERROR:#DIV/0!	ERROR:#VALUE!
	Average Repair Failures
devon.morrese: If there are washouts, then this number needs to be modified by (1-washout rate)	ERROR:#DIV/0!	ERROR:#DIV/0!

	Warranty Costs	Annual	Warranty Period
	Cost of Item Warranty	$ - 0	$ - 0
	Cost of Warranty Washouts
devon.morrese: I am a little concerned that something may have been entered into the wrong row in the inputs with the washouts. In this section it says that there are no washouts but 25% of those zero washouts are not covered under the warranty, however in the bottom section it says there is a 25% washout rate	ERROR:#DIV/0!	ERROR:#VALUE!
	Cost of Warranty Repairs

devon.morrese: If the item is potentially repairable, I would recommend using $E$55 instead of $E$6 in this row. You may also need to add in $E$59 depending on if the repair price given is organic or contractor repair and who is expected to do the repair for those items not covered by the warranty.

Also, to keep from counting something as both a repair and a washout, this shoul probably reference $B(C)$8 instead of $B(C)$7 (after modifying $B$8 to exclude washouts).	ERROR:#DIV/0!	ERROR:#DIV/0!
	Cost of Warranty False Failures	ERROR:#DIV/0!	ERROR:#VALUE!
	Total Cost of Warranty	ERROR:#DIV/0!	ERROR:#VALUE!

	Repair Costs	Annual	Warranty Period
	Cost of Repairs	ERROR:#VALUE!	ERROR:#VALUE!
	Cost of Repairs Washout
devon.morrese: If $B(C)$8 is modified to exclude washouts, then this row should reference $B(C)$7 instead	ERROR:#DIV/0!	ERROR:#VALUE!
	Cost of Repairs False Failures

devon.morrese: If $B(C)$8 is modified to exclude washouts, then this row should reference $B(C)$7 instead.

devon.morrese: If there are washouts, then this number needs to be modified by (1-washout rate) devon.morrese: I am a little concerned that something may have been entered into the wrong row in the inputs with the washouts. In this section it says that there are no washouts but 25% of those zero washouts are not covered under the warranty, however in the bottom section it says there is a 25% washout rate devon.morrese: If the item is potentially repairable, I would recommend using $E$55 instead of $E$6 in this row. You may also need to add in $E$59 depending on if the repair price given is organic or contractor repair and who is expected to do the repair for those items not covered by the warranty.

Also, to keep from counting something as both a repair and a washout, this shoul probably reference $B(C)$8 instead of $B(C)$7 (after modifying $B$8 to exclude washouts).	ERROR:#DIV/0!	ERROR:#VALUE!
	Total Cost of Repairs	ERROR:#VALUE!	ERROR:#VALUE!

Warranty Analysis ERROR:#VALUE! ERROR:#VALUE!

Sensitivity Analysis

SENSITIVITY ANALYSIS FOR

Support Information	Months	Years
Warranty Period (Months/Years)	0	0.0000
Effective Warranty Period (Months/Years)		ERROR:#VALUE!
	Annual	Warranty Period
Average Warranty Failures	ERROR:#DIV/0!	ERROR:#VALUE!
Average Repair Failures	ERROR:#DIV/0!	ERROR:#DIV/0!

		Warranty Price	Total Warranty Cost
devon.morrese: Because the total on the other sheet includes more than just the individual rows on that sheet, this total is incomplete.	Total Repair Cost	Warranty Analysis
	Proposed	$ - 0	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!

File details come from the government source that posted it. Updated Nov 14, 2017.