Appendix E-OTD Disincentive Scenario Example.xlsx

XLSX spreadsheet 23 KB Posted

Attached to
FSG 53 Performance-Based Acquisition Support Strategy Federal contract opportunity
Solicitation number
SPE4A5-20-R-0150
Issued by
Defense Logistics Agency Aviation

About this file

This document contains details for a federal solicitation seeking support services for performance-based acquisition of hardware and abrasives under Federal Stock Group 53. The solicitation seeks a contractor to manage over 215,000 National Stock Numbers over an potential nine and a half year indefinite delivery indefinite quantity contract with the Defense Logistics Agency Aviation, including a three and a half year base period and two three-year option periods. Pricing will be fixed price with economic price adjustments. The contractor will be selected using best value criteria and a single award will be made. Letters of interest in subcontracting will be shared with the awardee.

View the file

Other files for this federal contract opportunity

Other files attached to FSG 53 Performance-Based Acquisition Support Strategy, newest first.
File Type Posted
A8_1946_CoreBasketRemovals.xlsx XLSX spreadsheet
A8_AppendixA_Total_Evaluated_Price_(TEP)_Model.xlsx XLSX spreadsheet
A7_1496_CoreBasketRemovals.xlsx XLSX spreadsheet
SPE4A520R0150-QandA-13Aug20.pdf PDF
SF30_SPE4A520R01500005.pdf PDF
A5_SPE4A520R0150_Section_M_Evaluation_Factors_for_Award.pdf PDF
SPE4A520R0150-QandA-24Jul20.pdf PDF
A4 SPE4A520R0150 Section L Instruction to Offerors.pdf PDF
SF30_SPE4A520R01500004.pdf PDF
SPE4A520R0150-AmendmentQandA-15May2020.pdf PDF
A3 SPE4A520R0150 Section L Instruction to Offerors.pdf PDF
A3 Appendix A-Total Evaluated Price (TEP) Model.xlsx XLSX spreadsheet
A3 SF30_SPE4A520R0150-0003.pdf PDF
A1 Appendix I Alt Requisition History 2018.xlsx XLSX spreadsheet
A1 Appendix I Alt Requisition History 2016.xlsx XLSX spreadsheet
A1 Appendix I Core Requisition History 2015.xlsx XLSX spreadsheet
SF30_SPE4A520R01500002.pdf PDF
A1 Appendix G-Surge and Sustainment List.xlsx XLSX spreadsheet
A1 Appendix C- Core-Alternative Data Matrixes.xlsx XLSX spreadsheet
A1 FSG53 Updated Lists - Core and Alternative.xlsx XLSX spreadsheet
A1 Appendix F-Small Business List.xlsx XLSX spreadsheet
A1 Appendix A-Total Evaluated Price (TEP) Model.xlsx XLSX spreadsheet
A1 Appendix F-Small Business List.xlsx XLSX spreadsheet
A1 Appendix A-Total Evaluated Price (TEP) Model.xlsx XLSX spreadsheet
SF30_SPE4A520R01500001.pdf PDF
A1 SPE4A520R0150 Potential Prime Contractors.pdf PDF
A1 Appendix H-EPA Example.xlsx XLSX spreadsheet
A1 Appendix B-Delivery-Production Lead Times (PLT).xlsx XLSX spreadsheet
A1 FSG53 Updated Lists - Core and Alternative.xlsx XLSX spreadsheet
Appendix A-Pricing and Total Evaluated Price (TEP) Model-10Feb2020.xlsx XLSX spreadsheet
Appendix I-CoreReqHistory2016.xlsx XLSX spreadsheet
Appendix I-ExtReqHistory2019.xlsx XLSX spreadsheet
Appendix I-CoreReqHistory2015.xlsx XLSX spreadsheet
Appendix I-CoreReqHistory2018.xlsx XLSX spreadsheet
Appendix I-ExtReqHistory2017.xlsx XLSX spreadsheet
Appendix B-Delivery-Production Lead Times (PLT)-6Feb20.xlsx XLSX spreadsheet
FSG 53 Solicitation Feedback Industry Day Questions & Answers.pdf PDF
FSG 53 Solicitation Feedback Industry Day Questions & Answers.pdf PDF
SPE4A520R0150 Section M Evaluation Factors for Award.pdf PDF
Appendix B-Delivery-Production Lead Times (PLT).xlsx XLSX spreadsheet
Appendix C (File 1 of 3) CORE Data Matrixes.xlsx XLSX spreadsheet
Appendix D-CDA Disincentive Scenario Examples.xlsx XLSX spreadsheet
SPE4A520R0150 Target Population.xlsx XLSX spreadsheet
Appendix C (File 3d of 3) ALTERNATIVE Inspection Matrix.xlsx XLSX spreadsheet
Appendix C (FIle 3a of 3) ALTERNATIVE Technical Matrix.xlsx XLSX spreadsheet
Appendix C (File 2 of 3) EXTENDED Data Matrixes.xlsx XLSX spreadsheet
SPE4A520R0150 Section L Instructions to Offerors.pdf PDF
Appendix F-Small Business List.xlsx XLSX spreadsheet
Appendix C (File 3b of 3) ALTERNATIVE Quality Matrix.xlsx XLSX spreadsheet
SPE4A520R0150 Contract Data Requirements List (CDRL).xlsx XLSX spreadsheet
Show all 50

FSG 53 Performance-Based Acquisition Support Strategy has more files on GovTribe.

On GovTribe

Work with this file on GovTribe

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

Text version

1a OTD Disincentive Example

Scenario: If OTD is less than 99%
EXAMPLE ONLY - VALUES FOR DEMONSTRATIVE PURPOSES ONLY
If OTD is less than 99%
Inputs
Performance period OTD:93.75%
Average days late:0.3

Total performance period spend: $ 456,877

Disincentive Total:$ 18,275
Min0510
Max49
MinMaxOverall % OTD Reached0-4 days late5-9 days late10+ days late
98.00%99.00%98.00% < OTD < 99.00%0.5%0.5%1.0%
97.00%98.00%97.00% < OTD ≤ 98.00%1.0%1.5%2.0%
96.00%97.00%96.00% < OTD ≤ 97.00%2.0%2.5%3.0%
95.00%96.00%95.00% < OTD ≤ 96.00%3.0%3.5%4.0%
95.00%OTD ≤ 95.00%4.0%4.5%5.0%

&"-,Bold"&12SPE4A5-20-R-0150 Appendix E - OTD Disincentive Scenario Example

Source Selection Information -- See FAR 2.101 and 3.104 For Official Use Only

1b OTD Example Data

Date of Contract Review:10/15/19
Input DataCalc. for days late
NIINPO NUMBERKT NUMPIINCAGEAWARD (AWD) UNIT PRICEAWARD DATEAdministrative Lead Time (ALT) OF RECORDACTUAL ALTDID AWD MAKE ALTProduction Lead Time (PLT) OF RECORDACTUAL PLTDID AWD MAKE PLTPO LINE VALUEORDER QTYDELIVERY QTYDELIVERY DATESCHED DELIVERY DATEDAYS PAST SCHED DELIVERYOPEN QTYDELQ INDNo. of Days Late
01xxxxxxxxxxxxxxxxxSPE4A520DXXXXSPE4A520FXXXXXXXXX10.9910/11/19150AWD WITHIN ALT304AWD WITHIN PLT109.9010010/15/19010YES0
01xxxxxxxxxxxxxxxxxSPE4A520DXXXXSPE4A520FXXXXXXXXX1489.6810/10/191600AWD WITHIN ALT2100AWD WITHIN PLT2979.362010/10/1952YES5
01xxxxxxxxxxxxxxxxxSPE4A520DXXXXSPE4A520FXXXXXXXXX414.8610/10/19150AWD WITHIN ALT360361MISSED PLT9541.7823010/5/20023NO0
01xxxxxxxxxxxxxxxxxSPE4A520DXXXXSPE4A520FXXXXXXXXX796.3710/10/191000AWD WITHIN ALT330330AWD WITHIN PLT1592.74209/4/2002NO0
01xxxxxxxxxxxxxxxxxSPE4A520DXXXXSPE4A520FXXXXXXXXX4579.5310/10/19150AWD WITHIN ALT450452MISSED PLT41215.77901/4/2109NO0
01xxxxxxxxxxxxxxxxxSPE4A520DXXXXSPE4A520FXXXXXXXXX210.7110/10/19150AWD WITHIN ALT2706AWD WITHIN PLT1474.977010/16/1907NO0
01xxxxxxxxxxxxxxxxxSPE4A520DXXXXSPE4A520FXXXXXXXXX575.9410/10/19150AWD WITHIN ALT300300AWD WITHIN PLT2879.70508/5/2005NO0
01xxxxxxxxxxxxxxxxxSPE4A520DXXXXSPE4A520FXXXXXXXXX283.3810/10/19310AWD WITHIN ALT930AWD WITHIN PLT850.143010/10/1953YES5
01xxxxxxxxxxxxxxxxxSPE4A520DXXXXSPE4A520FXXXXXXXXX575.9410/8/1915337MISSED ALT300300AWD WITHIN PLT6911.281208/3/20012NO0
01xxxxxxxxxxxxxxxxxSPE4A520DXXXXSPE4A520FXXXXXXXXX877.0510/3/1910060AWD WITHIN ALT510510AWD WITHIN PLT17541.002002/24/21020NO0
01xxxxxxxxxxxxxxxxxSPE4A520DXXXXSPE4A520FXXXXXXXXX877.0510/3/1910060AWD WITHIN ALT510510AWD WITHIN PLT4385.25502/24/2105NO0
01xxxxxxxxxxxxxxxxxSPE4A520DXXXXSPE4A520FXXXXXXXXX331.7610/3/19100268MISSED ALT424480MISSED PLT24550.247401/25/21074NO0
01xxxxxxxxxxxxxxxxxSPE4A520DXXXXSPE4A520FXXXXXXXXX877.0510/3/1910060AWD WITHIN ALT510510AWD WITHIN PLT2631.15302/24/2103NO0
01xxxxxxxxxxxxxxxxxSPE4A520DXXXXSPE4A520FXXXXXXXXX877.0510/3/1910060AWD WITHIN ALT510510AWD WITHIN PLT6139.35702/24/2107NO0
01xxxxxxxxxxxxxxxxxSPE4A520DXXXXSPE4A520FXXXXXXXXX226.679/30/191517MISSED ALT330330AWD WITHIN PLT453.34208/25/2002NO0
01xxxxxxxxxxxxxxxxxSPE4A520DXXXXSPE4A520FXXXXXXXXX45.919/22/19150AWD WITHIN ALT210211MISSED PLT3030.066604/20/20066NO0
01xxxxxxxxxxxxxxxxxSPE4A520DXXXXSPE4A520FXXXXXXXXX15.729/17/19154AWD WITHIN ALT370370AWD WITHIN PLT471.603009/21/20030NO0
01xxxxxxxxxxxxxxxxxSPE4A520DXXXXSPE4A520FXXXXXXXXX1699.859/17/19154AWD WITHIN ALT320210AWD WITHIN PLT142787.408404/14/20084NO0
01xxxxxxxxxxxxxxxxxSPE4A520DXXXXSPE4A520FXXXXXXXXX344.039/15/191000AWD WITHIN ALT330330AWD WITHIN PLT1032.09308/10/2003NO0
01xxxxxxxxxxxxxxxxxSPE4A520DXXXXSPE4A520FXXXXXXXXX282.869/13/19150AWD WITHIN ALT210210AWD WITHIN PLT5091.4818410/9/194/10/20014NO0
01xxxxxxxxxxxxxxxxxSPE4A520DXXXXSPE4A520FXXXXXXXXX49.069/13/19150AWD WITHIN ALT180180AWD WITHIN PLT1079.3222610/9/193/11/20016NO0
01xxxxxxxxxxxxxxxxxSPE4A520DXXXXSPE4A520FXXXXXXXXX90.009/13/19150AWD WITHIN ALT330332MISSED PLT5670.00631710/10/198/10/20046NO0
01xxxxxxxxxxxxxxxxxSPE4A520DXXXXSPE4A520FXXXXXXXXX1540.319/13/19150AWD WITHIN ALT360361MISSED PLT7701.555110/14/199/8/2004NO0
01xxxxxxxxxxxxxxxxxSPE4A520DXXXXSPE4A520FXXXXXXXXX13.489/13/19150AWD WITHIN ALT330332MISSED PLT310.042389/25/198/10/20015NO0
01xxxxxxxxxxxxxxxxxSPE4A520DXXXXSPE4A520FXXXXXXXXX5.049/13/19150AWD WITHIN ALT307307AWD WITHIN PLT226.8045279/20/197/16/20018NO0
01xxxxxxxxxxxxxxxxxSPE4A520DXXXXSPE4A520FXXXXXXXXX13.079/13/19150AWD WITHIN ALT340340AWD WITHIN PLT326.7525410/1/198/18/20021NO0
01xxxxxxxxxxxxxxxxxSPE4A520DXXXXSPE4A520FXXXXXXXXX249.249/13/19150AWD WITHIN ALT345346MISSED PLT996.964010/11/198/24/2004NO0
01xxxxxxxxxxxxxxxxxSPE4A520DXXXXSPE4A520FXXXXXXXXX2168.299/13/19150AWD WITHIN ALT390390AWD WITHIN PLT156116.8872010/10/1910/7/20072NO0
01xxxxxxxxxxxxxxxxxSPE4A520DXXXXSPE4A520FXXXXXXXXX957.875/22/19150AWD WITHIN ALT180180AWD WITHIN PLT2873.61316/26/1911/18/1902NO0
01xxxxxxxxxxxxxxxxxSPE4A520DXXXXSPE4A520FXXXXXXXXX357.205/22/19150AWD WITHIN ALT210210AWD WITHIN PLT2143.20626/7/1912/18/1904NO0
01xxxxxxxxxxxxxxxxxSPE4A520DXXXXSPE4A520FXXXXXXXXX35.495/22/19150AWD WITHIN ALT382383MISSED PLT2768.2278608/6/196/8/20018NO0
01xxxxxxxxxxxxxxxxxSPE4A520DXXXXSPE4A520FXXXXXXXXX23.155/22/19150AWD WITHIN ALT180180AWD WITHIN PLT995.45434210/1/1911/18/1901NO0

&"-,Bold"SPE4A5-20-R-0150 Appendix E - OTD Disincentive Scenario Example

Source Selection Information -- See FAR 2.101 and 3.104 For Official Use Only

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