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
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 | ||||
| Min | 0 | 5 | 10 | ||
| Max | 4 | 9 | |||
| Min | Max | Overall % OTD Reached | 0-4 days late | 5-9 days late | 10+ 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 Data | Calc. for days late | ||||||||||||||||||||
| NIIN | PO NUMBER | KT NUM | PIIN | CAGE | AWARD (AWD) UNIT PRICE | AWARD DATE | Administrative Lead Time (ALT) OF RECORD | ACTUAL ALT | DID AWD MAKE ALT | Production Lead Time (PLT) OF RECORD | ACTUAL PLT | DID AWD MAKE PLT | PO LINE VALUE | ORDER QTY | DELIVERY QTY | DELIVERY DATE | SCHED DELIVERY DATE | DAYS PAST SCHED DELIVERY | OPEN QTY | DELQ IND | No. of Days Late |
| 01xxxxxxx | xxxxxxxxxx | SPE4A520DXXXX | SPE4A520FXXXX | XXXXX | 10.99 | 10/11/19 | 15 | 0 | AWD WITHIN ALT | 30 | 4 | AWD WITHIN PLT | 109.90 | 10 | 0 | 10/15/19 | 0 | 10 | YES | 0 | |
| 01xxxxxxx | xxxxxxxxxx | SPE4A520DXXXX | SPE4A520FXXXX | XXXXX | 1489.68 | 10/10/19 | 160 | 0 | AWD WITHIN ALT | 210 | 0 | AWD WITHIN PLT | 2979.36 | 2 | 0 | 10/10/19 | 5 | 2 | YES | 5 | |
| 01xxxxxxx | xxxxxxxxxx | SPE4A520DXXXX | SPE4A520FXXXX | XXXXX | 414.86 | 10/10/19 | 15 | 0 | AWD WITHIN ALT | 360 | 361 | MISSED PLT | 9541.78 | 23 | 0 | 10/5/20 | 0 | 23 | NO | 0 | |
| 01xxxxxxx | xxxxxxxxxx | SPE4A520DXXXX | SPE4A520FXXXX | XXXXX | 796.37 | 10/10/19 | 100 | 0 | AWD WITHIN ALT | 330 | 330 | AWD WITHIN PLT | 1592.74 | 2 | 0 | 9/4/20 | 0 | 2 | NO | 0 | |
| 01xxxxxxx | xxxxxxxxxx | SPE4A520DXXXX | SPE4A520FXXXX | XXXXX | 4579.53 | 10/10/19 | 15 | 0 | AWD WITHIN ALT | 450 | 452 | MISSED PLT | 41215.77 | 9 | 0 | 1/4/21 | 0 | 9 | NO | 0 | |
| 01xxxxxxx | xxxxxxxxxx | SPE4A520DXXXX | SPE4A520FXXXX | XXXXX | 210.71 | 10/10/19 | 15 | 0 | AWD WITHIN ALT | 270 | 6 | AWD WITHIN PLT | 1474.97 | 7 | 0 | 10/16/19 | 0 | 7 | NO | 0 | |
| 01xxxxxxx | xxxxxxxxxx | SPE4A520DXXXX | SPE4A520FXXXX | XXXXX | 575.94 | 10/10/19 | 15 | 0 | AWD WITHIN ALT | 300 | 300 | AWD WITHIN PLT | 2879.70 | 5 | 0 | 8/5/20 | 0 | 5 | NO | 0 | |
| 01xxxxxxx | xxxxxxxxxx | SPE4A520DXXXX | SPE4A520FXXXX | XXXXX | 283.38 | 10/10/19 | 31 | 0 | AWD WITHIN ALT | 93 | 0 | AWD WITHIN PLT | 850.14 | 3 | 0 | 10/10/19 | 5 | 3 | YES | 5 | |
| 01xxxxxxx | xxxxxxxxxx | SPE4A520DXXXX | SPE4A520FXXXX | XXXXX | 575.94 | 10/8/19 | 15 | 337 | MISSED ALT | 300 | 300 | AWD WITHIN PLT | 6911.28 | 12 | 0 | 8/3/20 | 0 | 12 | NO | 0 | |
| 01xxxxxxx | xxxxxxxxxx | SPE4A520DXXXX | SPE4A520FXXXX | XXXXX | 877.05 | 10/3/19 | 100 | 60 | AWD WITHIN ALT | 510 | 510 | AWD WITHIN PLT | 17541.00 | 20 | 0 | 2/24/21 | 0 | 20 | NO | 0 | |
| 01xxxxxxx | xxxxxxxxxx | SPE4A520DXXXX | SPE4A520FXXXX | XXXXX | 877.05 | 10/3/19 | 100 | 60 | AWD WITHIN ALT | 510 | 510 | AWD WITHIN PLT | 4385.25 | 5 | 0 | 2/24/21 | 0 | 5 | NO | 0 | |
| 01xxxxxxx | xxxxxxxxxx | SPE4A520DXXXX | SPE4A520FXXXX | XXXXX | 331.76 | 10/3/19 | 100 | 268 | MISSED ALT | 424 | 480 | MISSED PLT | 24550.24 | 74 | 0 | 1/25/21 | 0 | 74 | NO | 0 | |
| 01xxxxxxx | xxxxxxxxxx | SPE4A520DXXXX | SPE4A520FXXXX | XXXXX | 877.05 | 10/3/19 | 100 | 60 | AWD WITHIN ALT | 510 | 510 | AWD WITHIN PLT | 2631.15 | 3 | 0 | 2/24/21 | 0 | 3 | NO | 0 | |
| 01xxxxxxx | xxxxxxxxxx | SPE4A520DXXXX | SPE4A520FXXXX | XXXXX | 877.05 | 10/3/19 | 100 | 60 | AWD WITHIN ALT | 510 | 510 | AWD WITHIN PLT | 6139.35 | 7 | 0 | 2/24/21 | 0 | 7 | NO | 0 | |
| 01xxxxxxx | xxxxxxxxxx | SPE4A520DXXXX | SPE4A520FXXXX | XXXXX | 226.67 | 9/30/19 | 15 | 17 | MISSED ALT | 330 | 330 | AWD WITHIN PLT | 453.34 | 2 | 0 | 8/25/20 | 0 | 2 | NO | 0 | |
| 01xxxxxxx | xxxxxxxxxx | SPE4A520DXXXX | SPE4A520FXXXX | XXXXX | 45.91 | 9/22/19 | 15 | 0 | AWD WITHIN ALT | 210 | 211 | MISSED PLT | 3030.06 | 66 | 0 | 4/20/20 | 0 | 66 | NO | 0 | |
| 01xxxxxxx | xxxxxxxxxx | SPE4A520DXXXX | SPE4A520FXXXX | XXXXX | 15.72 | 9/17/19 | 15 | 4 | AWD WITHIN ALT | 370 | 370 | AWD WITHIN PLT | 471.60 | 30 | 0 | 9/21/20 | 0 | 30 | NO | 0 | |
| 01xxxxxxx | xxxxxxxxxx | SPE4A520DXXXX | SPE4A520FXXXX | XXXXX | 1699.85 | 9/17/19 | 15 | 4 | AWD WITHIN ALT | 320 | 210 | AWD WITHIN PLT | 142787.40 | 84 | 0 | 4/14/20 | 0 | 84 | NO | 0 | |
| 01xxxxxxx | xxxxxxxxxx | SPE4A520DXXXX | SPE4A520FXXXX | XXXXX | 344.03 | 9/15/19 | 100 | 0 | AWD WITHIN ALT | 330 | 330 | AWD WITHIN PLT | 1032.09 | 3 | 0 | 8/10/20 | 0 | 3 | NO | 0 | |
| 01xxxxxxx | xxxxxxxxxx | SPE4A520DXXXX | SPE4A520FXXXX | XXXXX | 282.86 | 9/13/19 | 15 | 0 | AWD WITHIN ALT | 210 | 210 | AWD WITHIN PLT | 5091.48 | 18 | 4 | 10/9/19 | 4/10/20 | 0 | 14 | NO | 0 |
| 01xxxxxxx | xxxxxxxxxx | SPE4A520DXXXX | SPE4A520FXXXX | XXXXX | 49.06 | 9/13/19 | 15 | 0 | AWD WITHIN ALT | 180 | 180 | AWD WITHIN PLT | 1079.32 | 22 | 6 | 10/9/19 | 3/11/20 | 0 | 16 | NO | 0 |
| 01xxxxxxx | xxxxxxxxxx | SPE4A520DXXXX | SPE4A520FXXXX | XXXXX | 90.00 | 9/13/19 | 15 | 0 | AWD WITHIN ALT | 330 | 332 | MISSED PLT | 5670.00 | 63 | 17 | 10/10/19 | 8/10/20 | 0 | 46 | NO | 0 |
| 01xxxxxxx | xxxxxxxxxx | SPE4A520DXXXX | SPE4A520FXXXX | XXXXX | 1540.31 | 9/13/19 | 15 | 0 | AWD WITHIN ALT | 360 | 361 | MISSED PLT | 7701.55 | 5 | 1 | 10/14/19 | 9/8/20 | 0 | 4 | NO | 0 |
| 01xxxxxxx | xxxxxxxxxx | SPE4A520DXXXX | SPE4A520FXXXX | XXXXX | 13.48 | 9/13/19 | 15 | 0 | AWD WITHIN ALT | 330 | 332 | MISSED PLT | 310.04 | 23 | 8 | 9/25/19 | 8/10/20 | 0 | 15 | NO | 0 |
| 01xxxxxxx | xxxxxxxxxx | SPE4A520DXXXX | SPE4A520FXXXX | XXXXX | 5.04 | 9/13/19 | 15 | 0 | AWD WITHIN ALT | 307 | 307 | AWD WITHIN PLT | 226.80 | 45 | 27 | 9/20/19 | 7/16/20 | 0 | 18 | NO | 0 |
| 01xxxxxxx | xxxxxxxxxx | SPE4A520DXXXX | SPE4A520FXXXX | XXXXX | 13.07 | 9/13/19 | 15 | 0 | AWD WITHIN ALT | 340 | 340 | AWD WITHIN PLT | 326.75 | 25 | 4 | 10/1/19 | 8/18/20 | 0 | 21 | NO | 0 |
| 01xxxxxxx | xxxxxxxxxx | SPE4A520DXXXX | SPE4A520FXXXX | XXXXX | 249.24 | 9/13/19 | 15 | 0 | AWD WITHIN ALT | 345 | 346 | MISSED PLT | 996.96 | 4 | 0 | 10/11/19 | 8/24/20 | 0 | 4 | NO | 0 |
| 01xxxxxxx | xxxxxxxxxx | SPE4A520DXXXX | SPE4A520FXXXX | XXXXX | 2168.29 | 9/13/19 | 15 | 0 | AWD WITHIN ALT | 390 | 390 | AWD WITHIN PLT | 156116.88 | 72 | 0 | 10/10/19 | 10/7/20 | 0 | 72 | NO | 0 |
| 01xxxxxxx | xxxxxxxxxx | SPE4A520DXXXX | SPE4A520FXXXX | XXXXX | 957.87 | 5/22/19 | 15 | 0 | AWD WITHIN ALT | 180 | 180 | AWD WITHIN PLT | 2873.61 | 3 | 1 | 6/26/19 | 11/18/19 | 0 | 2 | NO | 0 |
| 01xxxxxxx | xxxxxxxxxx | SPE4A520DXXXX | SPE4A520FXXXX | XXXXX | 357.20 | 5/22/19 | 15 | 0 | AWD WITHIN ALT | 210 | 210 | AWD WITHIN PLT | 2143.20 | 6 | 2 | 6/7/19 | 12/18/19 | 0 | 4 | NO | 0 |
| 01xxxxxxx | xxxxxxxxxx | SPE4A520DXXXX | SPE4A520FXXXX | XXXXX | 35.49 | 5/22/19 | 15 | 0 | AWD WITHIN ALT | 382 | 383 | MISSED PLT | 2768.22 | 78 | 60 | 8/6/19 | 6/8/20 | 0 | 18 | NO | 0 |
| 01xxxxxxx | xxxxxxxxxx | SPE4A520DXXXX | SPE4A520FXXXX | XXXXX | 23.15 | 5/22/19 | 15 | 0 | AWD WITHIN ALT | 180 | 180 | AWD WITHIN PLT | 995.45 | 43 | 42 | 10/1/19 | 11/18/19 | 0 | 1 | NO | 0 |
&"-,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 .