A02_Attachment_9_Cost_Template.xlsx

XLSX spreadsheet 95 KB Posted

Attached to
Award Notice for The Next General Chemical Detector 1 (NGCD1), Aerosol & Vapor Chemical Agent Detector (AVCAD) 541712
Solicitation number
W911SR-17-R-0005
Issued by

About this file

Cost Template

View the file

Other files

File Type Posted
Government_Response_10_May.pdf PDF
NGCD1_AVCAD_Amendment__27_April_2018.pdf PDF
A07_Attachment_9_Cost_Template_Feb_2018_.xlsx XLSX spreadsheet
Attachment_4_-_40051-2C_TABLE_A-IV_TM_3-6665-441-23_and_P.XLSX XLSX spreadsheet
Attachment_3_-_40051-2C_TABLE_A-II_TM_3-6665-441-10.xlsx XLSX spreadsheet
Attachment_11_-_DDForm254_AVCAD_17_Aug_17_Signed.pdf PDF
Attachment_9_7th_BETA_NGCD_1_Cost_Template,_.xlsx XLSX spreadsheet
Attachment_12_-_Past_Performance_Questionnaire_01_Aug_2017_.docx DOCX document
Attachment_10_-_Small_Business_Participation_Proposa_01_Aug_2017_l.docx DOCX document
EXHIBIT_A_AVCAD_CDRLs_19_Sep_2017.pdf PDF
Attachment_5_-_40051-2C_TABLE_A-III_TM_3-6665-441-40.xlsx XLSX spreadsheet
Attachment_1_-_AVCAD_Performance_Specification_29AUG2017.pdf PDF
W911SR-17-R-0005_RFP_NGCD1_AVCAD_21_Sep_2017.pdf PDF
Attachment_2_-_AVCAD_Logistics_Product_Data_Selection_Worksheet.pdf PDF
NGCD_1_Technical_Slides.pptx PPTX presentation
NGCD_1_FPI(S)_Basics.pdf PDF
Government_response_to_Questions_27_July_2017.pdf PDF
A02_Attachment_4_Field_Maintenance_Manual.xlsx XLSX spreadsheet
CDRLs_5_Jul_2017.pdf PDF
A02_SECTION_L_5_July.pdf PDF
Attachment_1_Pspec_29JUN2017.pdf PDF
A02_Attachment_3_Operator's_Maintenance_Manual_.xlsx XLSX spreadsheet
B02_Section_M_7_July.pdf PDF
A02_Attachment_2_-_Logistics_Product_Data_Selection_Worksheet.pdf PDF
Draft_RFP.pdf PDF
A02_Section_B_30_June_2017.xlsx XLSX spreadsheet
A02_Attachment_10_Small_Business_Participation_Proposal_(Sample_Format).pdf PDF
A02Attachment_5_Depot_Maintenance_Manual.xlsx XLSX spreadsheet
Government_Response.pdf PDF
Government_Response.pdf PDF
13-Draft_AVCAD_section_L_2017420.pdf PDF
NGCD1_AVCAD_Questions_and_Responses.xlsx XLSX spreadsheet
13-Draft_AVCAD_section_L_2017420.pdf PDF
17-Draft_AVCAD_Section_M_20170420.pdf PDF
5-Attachment_1_-_Draft_AVCAD_Performance_Specification_20_Apr_2017.pdf PDF
4-Draft_AVCAD_Section_C_-_PWS_20170420.pdf PDF
Show all 36

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Summary

Evaluation Price
EMD$0
LRIP$0
FRPERROR:#NUM!
Proposed Evaluation PriceERROR:#NUM!

EMD Summary

CLINContract Type(Initial) Target Cost(Initial) Target Fee/ProfitPriceNotes
EMD Base Contract0001Aeresol Vapor Chemical De…CPIF<Sum>ERROR:#VALUE!$0
0002AVCAD with Alternate Aero…CPIF<Sum>ERROR:#VALUE!$0
0003System Support Package (S…CPIF<Sum>ERROR:#VALUE!$0
0004IPSCPIF<Sum>ERROR:#VALUE!$0
0005Accounting for Contract S…FFP←Usually NSP: If Proposed, Enter FFP Here
0006Contract Data Requirement…NSP←Not Separately Priced
Option 1 EMD AVCAD PQT Hardware0007AAAVCAD first delivery (24)CPIF<Sum>ERROR:#VALUE!$0Total CPIF (not each)
0007ABAVCAD second delivery (36)CPIF<Sum>ERROR:#VALUE!$0Total CPIF (not each)
0007ACAVCAD third delivery (15)CPIF<Sum>ERROR:#VALUE!$0Total CPIF (not each)
0008AASSP For 24 AVCADCPIF<Sum>ERROR:#VALUE!$0Total CPIF (not each)
0008ABSSP For 36 AVCADCPIF<Sum>ERROR:#VALUE!$0Total CPIF (not each)
0008ACSSP For 15 AVCADCPIF<Sum>ERROR:#VALUE!$0Total CPIF (not each)
Option 2 EMD Platform Integration0009AAShipboard Platform (2)CPIF<Sum>ERROR:#VALUE!$0Total CPIF (not each)
0009ABNBCRV (2)CPIF<Sum>ERROR:#VALUE!$0Total CPIF (not each)
0009ACUnmanned Ground Vehicle (2)CPIF<Sum>ERROR:#VALUE!$0Total CPIF (not each)
0009ADJoint Assault Bridge (2)CPIF<Sum>ERROR:#VALUE!$0Total CPIF (not each)
0009AEABRAMS Tank (2)CPIF<Sum>ERROR:#VALUE!$0Total CPIF (not each)
0009AFAMPV (2)CPIF<Sum>ERROR:#VALUE!$0Total CPIF (not each)
0009AGFixed-wing aircraft (2)CPIF<Sum>ERROR:#VALUE!$0Total CPIF (not each)
0009AHRotary-wing aircraft (2)CPIF<Sum>ERROR:#VALUE!$0Total CPIF (not each)
Option 3 TM0010Depot Maintenance ManualCPIF<Sum>ERROR:#VALUE!$0
Proposed Evaluation Price$0

LRIP Summary

CLINContract Type(Initial) Target Cost(Initial) Target Fee/ProfitPriceNotes
Option 4 LRIP0011AAAVCAD first delivery (68)FPI(S)$0Enter Initial Target Cost & Fee Directly Here. Enter Total Price (not each)
0011ABAVCAD second delivery (60)FPI(S)$0Enter Initial Target Cost & Fee Directly Here. Enter Total Price (not each)
0012AASSP for PVT testing (41,4…FPI(S)$0Enter Initial Target Cost & Fee Directly Here
0012ABSSP for MOT testing (32,4…FPI(S)$0Enter Initial Target Cost & Fee Directly Here
0013AATM updateFPI(S)$0Enter Initial Target Cost & Fee Directly Here
0013ABLogistics/Maintenance Dem…FPI(S)$0Enter Initial Target Cost & Fee Directly Here
0013ACTraining Course update De…FPI(S)$0Enter Initial Target Cost & Fee Directly Here
0014Consumable and Spare PartsFPI(S)$0$0$0
0015Technical SupportCPIF<Sum>ERROR:#VALUE!$0
0016AAShipboard Platform (2)FPI(S)$0Enter Initial Target Cost & Fee Directly Here. Enter Total Price (not each)
0016ABNBCRV (2)FPI(S)$0Enter Initial Target Cost & Fee Directly Here. Enter Total Price (not each)
0016ACUnmanned Ground Vehicle (2)FPI(S)$0Enter Initial Target Cost & Fee Directly Here. Enter Total Price (not each)
0016ADJoint Assault Bridge (2)FPI(S)$0Enter Initial Target Cost & Fee Directly Here. Enter Total Price (not each)
0016AEABRAMS Tank (2)FPI(S)$0Enter Initial Target Cost & Fee Directly Here. Enter Total Price (not each)
0016AFAMPV (2)FPI(S)$0Enter Initial Target Cost & Fee Directly Here. Enter Total Price (not each)
0016AGFixed-wing aircraft (2)FPI(S)$0Enter Initial Target Cost & Fee Directly Here. Enter Total Price (not each)
0016AHRotary-wing aircraft (2)FPI(S)$0Enter Initial Target Cost & Fee Directly Here. Enter Total Price (not each)
0017AVCAD WarrantyFFP$0
Proposed Evaluation Price$0

FRP Summary

FRP Year 1FRP Year 2FRP Year 3FRP Year 4FRP Year 5FRP Year 6Total
Avcad HardwareFPI(S)ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!
AVCAD WarrantyFFPERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!
Platform Integration KitsShipboardFPI(S)$0$0$0$0$0$0$0
NBCRVFPI(S)$0$0$0$0$0$0$0
Unmanned Ground VehicleFPI(S)$0$0$0$0$0$0$0
Joint Assault BridgeFPI(S)$0$0$0$0$0$0$0
ABRAMS TankFPI(S)$0$0$0$0$0$0$0
AMPVFPI(S)$0$0$0$0$0$0$0
Fixed-wing aircraftFPI(S)$0$0$0$0$0$0$0
Rotary-wing aircraftFPI(S)$0$0$0$0$0$0$0
Technical SupportCPIFERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
FRP Evaluation PriceERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!

CPIF - EMD

CLIN 0001CLIN 0002CLIN 0003CLIN 0004CLIN 0007AACLIN 0007ABCLIN 0007ACCLIN 0008AACLIN 0008ABCLIN 0008ACCLIN 0009AACLIN 0009ABCLIN 0009ACCLIN 0009ADCLIN 0009AECLIN 0009AFCLIN 0009AG
AVCADAVCAD with Alt. Aerosol DesignSSP for CLIN 0001 & 0002IPSAVCAD 1st Delivery (24 Total)AVCAD 2nd Delivery (36 Total)AVCAD 3rd Delivery (15 Total)System Support Package, 24 AVCADsSystem Support Package, 36 AVCADsSystem Support Package, 15 AVCADsShipboard Platform (2 total)NBCRV (2 total)Unmanned Ground Vehicle (2 total)Joint Assault Bridge (2 total)ABRAMS Tank (2 total)AMPV (2 total)Fixed-Wing Aircraft (2 total)
LaborHours/UnitsRateDollarsHours/UnitsRateDollarsHours/UnitsRateDollarsHours/UnitsRateDollarsHours/UnitsRateDollarsHours/UnitsRateDollarsHours/UnitsRateDollarsHours/UnitsRateDollarsHours/UnitsRateDollarsHours/UnitsRateDollarsHours/UnitsRateDollarsHours/UnitsRateDollarsHours/UnitsRateDollarsHours/UnitsRateDollarsHours/UnitsRateDollarsHours/UnitsRateDollarsHours/Units
Labor Category 10$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00
Labor Category 20$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00
Labor Category 30$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00
Labor Category 40$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00
Labor Category 50$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00
Labor Category 60$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00
Labor Category 70$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00
Labor Category 80$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00
Labor Category 90$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00
Labor Category 100$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00
Labor Category…0$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00
Subtotal, Direct Labor0$00$00$00$00$00$00$00$00$00$00$00$00$00$00$00$00
Fringe (Allocation Base)0.00%base*rate0.00%base*rate0.00%base*rate0.00%base*rate0.00%base*rate0.00%base*rate0.00%base*rate0.00%base*rate0.00%base*rate0.00%base*rate0.00%base*rate0.00%base*rate0.00%base*rate0.00%base*rate0.00%base*rate0.00%base*rate
Overhead (Allocation Base)0.00%base*rate0.00%base*rate0.00%base*rate0.00%base*rate0.00%base*rate0.00%base*rate0.00%base*rate0.00%base*rate0.00%base*rate0.00%base*rate0.00%base*rate0.00%base*rate0.00%base*rate0.00%base*rate0.00%base*rate0.00%base*rate
Labor0$00$00$00$00$00$00$00$00$00$00$00$00$00$00$00$00
Subcontracts
Subcontractor 1 (Contract Type)<Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref>
Subcontractor 2 (Contract Type)<Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref>
Subcontractor…<Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref>
Subtotal, Subcontracts0$00$00$00$00$00$00$00$00$00$00$00$00$00$00$00$00
Sub Handling0.00%$00.00%$00.00%$00.00%$00.00%$00.00%$00.00%$00.00%$00.00%$00.00%$00.00%$00.00%$00.00%$00.00%$00.00%$00.00%$0
Subcontracts0$00$00$00$00$00$00$00$00$00$00$00$00$00$00$00$00
Materials (may reference BOM)
Material 10$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00
Material 20$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00
Material 30$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00
Material…0$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00
Subtotal, Materials$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Material Handling0.00%$00.00%$00.00%$00.00%$00.00%$00.00%$00.00%$00.00%$00.00%$00.00%$00.00%$00.00%$00.00%$00.00%$00.00%$00.00%$0
Materials$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0

Travel (See "EMD Travel" Tab) <ref> <ref> <ref> <ref> <ref> <ref> <ref> <ref> <ref> <ref> <ref> <ref> <ref> <ref> <ref> <ref> <ref> <ref> <ref>

ODCs
ODC 10$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00
ODC 20$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00
ODC 30$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00
ODC…0$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00
Subtotal, ODCs$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
G&A
Allocation Base<sum><sum><sum><sum><sum><sum><sum><sum><sum><sum><sum><sum><sum><sum><sum><sum><sum><sum><sum>
G&A<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!
Target Cost<Sum><Sum><Sum><Sum><Sum><Sum><Sum><Sum><Sum><Sum><Sum><Sum><Sum><Sum><Sum><Sum><Sum><Sum><Sum>
Incentive Fee<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!
Target CPIFERROR:#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!
Min FeeERROR:#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!
Max FeeERROR:#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!

EMD Travel

CPIF TravelNumber ofDurationR/TPer DiemDaily Car RentalOther per TripTotalTotal Cost
PeopleTripsDaysAirfareLodgingM&IEAirfareLodgingM&IERentalOther
LRIP/FRP#: From <Origin> to <Destination> 1$0$0$0$0$0$0
LRIP/FRP#: From <Origin> to <Destination> 2$0$0$0$0$0$0
LRIP/FRP#: From <Origin> to <Destination> 3$0$0$0$0$0$0
LRIP/FRP#: From <Origin> to <Destination> 4$0$0$0$0$0$0
LRIP/FRP#: From <Origin> to <Destination> 5$0$0$0$0$0$0
LRIP/FRP#: From <Origin> to <Destination> 6$0$0$0$0$0$0
LRIP/FRP#: From <Origin> to <Destination> 7$0$0$0$0$0$0
LRIP/FRP#: From <Origin> to <Destination> 8$0$0$0$0$0$0
LRIP/FRP#: From <Origin> to <Destination> 9$0$0$0$0$0$0
LRIP/FRP#: From <Origin> to <Destination>…$0$0$0$0$0$0
Total$0$0$0$0$0$0

AVCAD FRP

ElementValueDescriptionFULL RATE PRODUCTION EVALUATION PRICE CALCULATION
EITHER 1) Input the cost of 3,200 Units and the "Cost Improvement Slope", OR 2) Manually input target costs for each ordering point (e.g. 1, 50, 200, etc.).Total Cost of 3,200 UnitsEstimated total cost to produce 3,200 units.Order PointWeightYear 1Year 2Year 3Year 4Year 5Year 6
Average Costs12.5%ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!
Cost Improvement SlopeUsed to calculate range pricing, which approximately reduces marginal initial target costs by [1-slope] percent per doubling of units.502.5%ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!
2002.5%ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!
8002.5%ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!
1,6002.5%ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!
"A" VariableERROR:#NUM!Theoretic cost of unit 1.3,2007.9%ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!
"b" VariableERROR:#NUM!ln(slope) / ln(2)6,40043.3%ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!
EscalationApplied annually.11,63536.3%ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!
Evaluation Wtd. Avg. CostERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!
x Evaluation Quantity3,20011,63511,63511,63511,6357,472
UnitsTarget CostSection B: Total Initial Target Cost CalculationEvaluation Initial Target CostERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!
FRP Year 11ERROR:#NUM!RangeTotal Initial Target CostTarget ProfitERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!
50ERROR:#NUM!1 - 49ERROR:#NUM!FPI(S) Evaluation PriceERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!
200ERROR:#NUM!50 - 199ERROR:#NUM!
800ERROR:#NUM!200 - 799ERROR:#NUM!Note: The weighted average for Year 1 excludes Order Points 6,400 and 11,635
1,600ERROR:#NUM!800 - 1,599ERROR:#NUM!Note: The weighted average for Year 6 excludes Order Point 11,636
3,200ERROR:#NUM!1,600 - 3,199ERROR:#NUM!
6,400ERROR:#NUM!3,200 - 6,399ERROR:#NUM!
11,635ERROR:#NUM!6,400 - 11,635ERROR:#NUM!
FRP Year 21ERROR:#NUM!
50ERROR:#NUM!1 - 49ERROR:#NUM!
200ERROR:#NUM!50 - 199ERROR:#NUM!
800ERROR:#NUM!200 - 799ERROR:#NUM!
1,600ERROR:#NUM!800 - 1,599ERROR:#NUM!
3,200ERROR:#NUM!1,600 - 3,199ERROR:#NUM!
6,400ERROR:#NUM!3,200 - 6,399ERROR:#NUM!
11,635ERROR:#NUM!6,400 - 11,635ERROR:#NUM!
FRP Year 31ERROR:#NUM!
50ERROR:#NUM!1 - 49ERROR:#NUM!
200ERROR:#NUM!50 - 199ERROR:#NUM!
800ERROR:#NUM!200 - 799ERROR:#NUM!
1,600ERROR:#NUM!800 - 1,599ERROR:#NUM!
3,200ERROR:#NUM!1,600 - 3,199ERROR:#NUM!
6,400ERROR:#NUM!3,200 - 6,399ERROR:#NUM!
11,635ERROR:#NUM!6,400 - 11,635ERROR:#NUM!
FRP Year 41ERROR:#NUM!
50ERROR:#NUM!1 - 49ERROR:#NUM!
200ERROR:#NUM!50 - 199ERROR:#NUM!
800ERROR:#NUM!200 - 799ERROR:#NUM!
1,600ERROR:#NUM!800 - 1,599ERROR:#NUM!
3,200ERROR:#NUM!1,600 - 3,199ERROR:#NUM!
6,400ERROR:#NUM!3,200 - 6,399ERROR:#NUM!
11,635ERROR:#NUM!6,400 - 11,635ERROR:#NUM!
FRP Year 51ERROR:#NUM!
50ERROR:#NUM!1 - 49ERROR:#NUM!
200ERROR:#NUM!50 - 199ERROR:#NUM!
800ERROR:#NUM!200 - 799ERROR:#NUM!
1,600ERROR:#NUM!800 - 1,599ERROR:#NUM!
3,200ERROR:#NUM!1,600 - 3,199ERROR:#NUM!
6,400ERROR:#NUM!3,200 - 6,399ERROR:#NUM!
11,635ERROR:#NUM!6,400 - 11,635ERROR:#NUM!
FRP Year 61ERROR:#NUM!
50ERROR:#NUM!1 - 49ERROR:#NUM!
200ERROR:#NUM!50 - 199ERROR:#NUM!
800ERROR:#NUM!200 - 799ERROR:#NUM!
1,600ERROR:#NUM!800 - 1,599ERROR:#NUM!
3,200ERROR:#NUM!1,600 - 3,199ERROR:#NUM!
6,400ERROR:#NUM!3,200 - 6,399ERROR:#NUM!
11,635ERROR:#NUM!6,400 - 11,635ERROR:#NUM!

Visual Representation of Initial Target Costs for Year 1

1 50 200 800 1600 3200 6400 11635 0 0 0 0 0 0 0 0 Units Ordered

Total Initial Target Cost (Millions)

Cons. & Spares MTBF (hours actively in use) Gilson, Benjamin C Mr CIV USA: Government:

Mean Time Before Failure (MTBF): Input the estimated average number of hours that the AVCAD would be used before the consumable or spare part would need to be replaced.

Annual EscalationQUANTITY CALCULATIONQuantity Range LogicTotal Initial Target Cost Calculation
Initial Target Cost per Unit: FY 2018AVCAD Usage (Thousands of Hours)Usage/AVCAD/Year (hours):500
Min:11015011,000FY 2018FY 2019FY 2020FY 2021FY 2022FY 2023FY 2024FY 2025CLIN:00140018AC0020AC0022AC0024AC0026AC0028AC
Part NamePart DescriptionMax:1005001,0000381021,7127,52913,34719,11424,982FY 2018FY 2019FY 2020FY 2021FY 2022FY 2023FY 2024FY 2025LRIPFRP 1FRP 2FRP 3FRP 4FRP 5FRP 6

e.g. USB Cord USB 3.0 3ft. 4,250 $5.49 $5.19 $4.99 $4.91 0 9 24 403 1,772 3,140 4,497 5,878 1 1 101 1000 1000 1000 1000 $49 $132 $2,092 $8,701 $15,417 $22,080 $28,861

Initial Target Cost$0$0$0$0$0$0$0
Initial Target Profit0.00%$0$0$0$0$0$0$0
Target Price$0$0$0$0$0$0$0

AVCAD Warranty Enter a percentage that will be used to calculate warranty Firm Fixed Prices, based on the rate below multiplied by Initial Target Costs of AVCAD Full Rate Production.

Warranty FFP %
LRIPYear 1Year 2Year 3Year 4Year 5Year 6
Initial Target Cost$0ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!
Warranty FFP Percentage0.00%0.00%0.00%0.00%0.00%0.00%0.00%
Warranty Eval. Price$0ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!

Integration Kits FRP

Escalation Rate:
FPI(S) Profit %
Initial Target Cost, Full Rate Production (each)Evaluation WeightWtd. Avg. CostEvaluation QuantityEval. Initial Target CostEval. Initial Target ProfitEval Price
Platform Integration Kit1-100101-500501-10001-100101-500501-1000
FRP Year 1Shipboard80%10%10%$030$0$0$0
NBCRV10%10%80%$0675$0$0$0
Unmanned Ground Vehicle10%80%10%$0300$0$0$0
Joint Assault Bridge80%10%10%$030$0$0$0
ABRAMS Tank10%80%10%$0225$0$0$0
AMPV80%10%10%$030$0$0$0
Fixed-wing aircraft80%10%10%$030$0$0$0
Rotary-wing aircraft80%10%10%$030$0$0$0
FRP Year 2Shipboard$0$0$080%10%10%$030$0$0$0
NBCRV$0$0$010%10%80%$0675$0$0$0
Unmanned Ground Vehicle$0$0$010%80%10%$0300$0$0$0
Joint Assault Bridge$0$0$080%10%10%$030$0$0$0
ABRAMS Tank$0$0$010%80%10%$0225$0$0$0
AMPV$0$0$080%10%10%$030$0$0$0
Fixed-wing aircraft$0$0$080%10%10%$030$0$0$0
Rotary-wing aircraft$0$0$080%10%10%$030$0$0$0
FRP Year 3Shipboard$0$0$080%10%10%$030$0$0$0
NBCRV$0$0$010%10%80%$0675$0$0$0
Unmanned Ground Vehicle$0$0$010%80%10%$0300$0$0$0
Joint Assault Bridge$0$0$080%10%10%$030$0$0$0
ABRAMS Tank$0$0$010%80%10%$0225$0$0$0
AMPV$0$0$080%10%10%$030$0$0$0
Fixed-wing aircraft$0$0$080%10%10%$030$0$0$0
Rotary-wing aircraft$0$0$080%10%10%$030$0$0$0
FRP Year 4Shipboard$0$0$080%10%10%$030$0$0$0
NBCRV$0$0$010%10%80%$0675$0$0$0
Unmanned Ground Vehicle$0$0$010%80%10%$0300$0$0$0
Joint Assault Bridge$0$0$080%10%10%$030$0$0$0
ABRAMS Tank$0$0$010%80%10%$0225$0$0$0
AMPV$0$0$080%10%10%$030$0$0$0
Fixed-wing aircraft$0$0$080%10%10%$030$0$0$0
Rotary-wing aircraft$0$0$080%10%10%$030$0$0$0
FRP Year 5Shipboard$0$0$080%10%10%$030$0$0$0
NBCRV$0$0$010%10%80%$0675$0$0$0
Unmanned Ground Vehicle$0$0$010%80%10%$0300$0$0$0
Joint Assault Bridge$0$0$080%10%10%$030$0$0$0
ABRAMS Tank$0$0$010%80%10%$0225$0$0$0
AMPV$0$0$080%10%10%$030$0$0$0
Fixed-wing aircraft$0$0$080%10%10%$030$0$0$0
Rotary-wing aircraft$0$0$080%10%10%$030$0$0$0
FRP Year 6Shipboard$0$0$080%10%10%$030$0$0$0
NBCRV$0$0$010%10%80%$0675$0$0$0
Unmanned Ground Vehicle$0$0$010%80%10%$0300$0$0$0
Joint Assault Bridge$0$0$080%10%10%$030$0$0$0
ABRAMS Tank$0$0$010%80%10%$0225$0$0$0
AMPV$0$0$080%10%10%$030$0$0$0
Fixed-wing aircraft$0$0$080%10%10%$030$0$0$0
Rotary-wing aircraft$0$0$080%10%10%$030$0$0$0

CPIF - Tech Support

LRIPFull Rate Production Year 1Full Rate Production Year 2Full Rate Production Year 3Full Rate Production Year 4Full Rate Production Year 5Full Rate Production Year 6
LaborHours/UnitsRateDollarsHours/UnitsRateDollarsHours/UnitsRateDollarsHours/UnitsRateDollarsHours/UnitsRateDollarsHours/UnitsRateDollarsHours/UnitsRateDollars
Labor Category 10$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$0
Labor Category 20$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$0
Labor Category 30$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$0
Labor Category 40$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$0
Labor Category 50$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$0
Labor Category 60$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$0
Labor Category 70$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$0
Labor Category 80$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$0
Labor Category 90$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$0
Labor Category 100$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$0
Labor Category…0$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$0
Subtotal, Direct Labor0$00$00$00$00$00$00$0
Fringe (Allocation Base)0.00%base*rate0.00%base*rate0.00%base*rate0.00%base*rate0.00%base*rate0.00%base*rate0.00%base*rate
Overhead (Allocation Base)0.00%base*rate0.00%base*rate0.00%base*rate0.00%base*rate0.00%base*rate0.00%base*rate0.00%base*rate
Labor0$00$00$00$00$00$00$0
Subcontracts
Subcontractor 1 (Contract Type)<Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref>
Subcontractor 2 (Contract Type)<Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref>
Subcontractor…<Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref><Ref>
Subtotal, Subcontracts0$00$00$00$00$00$00$0
Sub Handling0.00%$00.00%$00.00%$00.00%$00.00%$00.00%$00.00%$0
Subcontracts0$00$00$00$00$00$00$0
Materials (may reference BOM)
Material 10$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$0
Material 20$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$0
Material 30$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$0
Material…0$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$0
Subtotal, Materials$0$0$0$0$0$0$0
Material Handling0.00%$00.00%$00.00%$00.00%$00.00%$00.00%$00.00%$0
Materials$0$0$0$0$0$0$0

Travel (See "Technical Support Travel" Tab) <ref> <ref> <ref> <ref> <ref> <ref> <ref>

ODCs
ODC 10$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$0
ODC 20$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$0
ODC 30$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$0
ODC…0$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$0
Subtotal, ODCs$0$0$0$0$0$0$0
G&A
Allocation Base<sum><sum><sum><sum><sum><sum><sum>
G&A<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!
Target Cost<Sum><Sum><Sum><Sum><Sum><Sum><Sum>
Incentive Fee<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!
Target CPIFERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Min FeeERROR:#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!
Max FeeERROR:#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!

Tech Support Travel

CPIF TravelNumber ofDurationR/TPer DiemDaily Car RentalOther per TripTotalTotal Cost
PeopleTripsDaysAirfareLodgingM&IEAirfareLodgingM&IERentalOther
LRIP/FRP#: From <Origin> to <Destination> 1$0$0$0$0$0$0
LRIP/FRP#: From <Origin> to <Destination> 2$0$0$0$0$0$0
LRIP/FRP#: From <Origin> to <Destination> 3$0$0$0$0$0$0
LRIP/FRP#: From <Origin> to <Destination> 4$0$0$0$0$0$0
LRIP/FRP#: From <Origin> to <Destination> 5$0$0$0$0$0$0
LRIP/FRP#: From <Origin> to <Destination> 6$0$0$0$0$0$0
LRIP/FRP#: From <Origin> to <Destination> 7$0$0$0$0$0$0
LRIP/FRP#: From <Origin> to <Destination> 8$0$0$0$0$0$0
LRIP/FRP#: From <Origin> to <Destination> 9$0$0$0$0$0$0
LRIP/FRP#: From <Origin> to <Destination>…$0$0$0$0$0$0
Total$0$0$0$0$0$0

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated .