Attachment_15B_-_Performance_Incentive_Calculator_Kirtland.xlsx
XLSX spreadsheet 26 KB Posted
- Solicitation number
- FA6800-19-R-A002
About this file
This document contains a performance incentive calculator example for a helicopter maintenance contract at Kirtland Air Force Base. The calculator outlines metrics for maintenance of UH-1N, HH-60G, and HH-60W helicopters across categories such as minimum daily aircraft availability and maintenance scheduling effectiveness. Contractors would receive incentive reductions of up to 1% per metric failed on a monthly basis. The metrics and reductions would apply to CLINs for maintenance of specific helicopter models. The document provides templates to record performance results on a quarterly basis over multiple fiscal years. Contracting officers would use the templates to calculate reductions to contractor invoices based on incentive failures.
Kirtland Performance Incentive Plan Calculator (for use in billing CLINs X001 and X002 after award)
View the file
Other files
Show 40 more
Latest 50 of 70 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
Text version
PI Calculator Example
| Kirtland Helicopter Maintenance Performance Incentive | |
| 1% per Metric - Pass/Fail | |
| Example - Amounts are notional for illustration ONLY |
| CLIN PRICING | Metric | Pass Threshold | Monthly Performance | Pass/Fail | Fails/Eval Period | Associated CLIN Values | Reduction | PIR | CLIN | |||||||
| CLIN | Description | Monthly FFP | Minimum Daily Aircraft UH-1N (Monthly) | 80% | 79% | 85% | 80% | Fail | Pass | Pass | 1 | $ 10,000.00 | 1% | $ 100.00 | X001 | |
| CLIN X001 | UH-1N MX | $10,000.00 | Minimum Daily Aircraft HH-60G (Monthly) | 90% | 90% | 89% | 91% | Pass | Fail | Pass | 1 | $ 10,000.00 | 1% | $ 100.00 | X002 | |
| CLIN X002 | HH-60 MX | $10,000.00 | Minimum Daily Aircraft HH-60W (Monthly) | 90% | 90% | 89% | 91% | Pass | Fail | Pass | 1 | $ 10,000.00 | 1% | $ 100.00 | X002 | |
| Aircraft Technical Inspections (Quarterly) | 85% | 85% | Pass | Pass | Pass | 0 | $ 60,000.00 | 1% | $ - 0 | X001 & X002 | each | |||||
| Scheduled Observation Area Inspections (Quarterly) | 80% | 79% | Fail | Pass | Pass | 1 | $ 60,000.00 | 1% | $ 600.00 | X001 & X002 | each | |||||
| Monthly MX Scheduling Effectiveness UH-1N (Monthly) | 95% | 95% | 92% | 96% | Pass | Fail | Pass | 1 | $ 10,000.00 | 1% | $ 100.00 | X001 | ||||
| Monthly MX Scheduling Effectiveness HH-60G (Monthly) | 95% | 95% | 92% | 96% | Pass | Fail | Pass | 1 | $ 10,000.00 | 1% | $ 100.00 | X002 | ||||
| Monthly MX Scheduling Effectiveness HH-60W (Monthly) | 95% | 95% | 92% | 96% | Pass | Fail | Pass | 1 | $ 10,000.00 | 1% | $ 100.00 | X002 | ||||
| Total Quarterly PIR = | $ 1,200.00 | |||||||||||||||
| Total Quarter PIR % = | 2% | |||||||||||||||
| CLIN X001 PIR Invoice Reduction | $ 500.00 | |||||||||||||||
| Instructions: | CLIN X002 PIR Invoice Reduction | $ 700.00 | ||||||||||||||
| 1) Insert monthly FFP for X001 and X002 above | Total Quarterly PIR = | $ 1,200.00 | ||||||||||||||
| 2) Insert performance achieved for each month in the quarter under "Monthly Performance" column. | ||||||||||||||||
| 3) Apply Performance Incentive Reduction (PIR) to contractor invoices for the associated CLIN. | ||||||||||||||||
| NOTE: Inspection metrics apply to both X001 and X002; divide the PIR by 2 and apply to both X001 and X002 (i.e: $24,000 ÷ 2 = $12,000 reduction for X001 and X002). | ||||||||||||||||
| 4) Utilize the tabs below for each quarterly incentivized period. The ACO will save and retain all period calculations. |
FY20 1st Qtr
| Kirtland Helicopter Maintenance Performance Incentive | ||||||||||||||||
| 1% per Metric - Pass/Fail | ||||||||||||||||
| CLIN PRICING | Metric | Pass Threshold | Monthly Performance | Pass/Fail | Fails/Eval Period | Associated CLIN Values | Reduction | PIR | CLIN | |||||||
| CLIN | Description | Monthly FFP | Minimum Daily Aircraft UH-1N (Monthly) | 80% | TBD | TBD | TBD | Pass | Pass | Pass | 0 | $ 10,000.00 | 1% | $ - 0 | X001 | |
| CLIN X002 | UH-1N MX | $10,000.00 | Minimum Daily Aircraft HH-60G (Monthly) | 90% | TBD | TBD | TBD | Pass | Pass | Pass | 0 | $ 10,000.00 | 1% | $ - 0 | X002 | |
| CLIN X003 | HH-60 MX | $10,000.00 | Minimum Daily Aircraft HH-60W (Monthly) | 90% | TBD | TBD | TBD | Pass | Pass | Pass | 0 | $ 10,000.00 | 1% | $ - 0 | X002 | |
| Aircraft Technical Inspections (Quarterly) | 85% | TBD | Pass | Pass | Pass | 0 | $ 60,000.00 | 1% | $ - 0 | X001 & X002 | 50% each | |||||
| Scheduled Observation Area Inspections (Quarterly) | 80% | TBD | Pass | Pass | Pass | 0 | $ 60,000.00 | 1% | $ - 0 | X001 & X002 | 50% each | |||||
| Monthly MX Scheduling Effectiveness UH-1N (Monthly) | 95% | TBD | TBD | TBD | Pass | Pass | Pass | 0 | $ 10,000.00 | 1% | $ - 0 | X001 | ||||
| Monthly MX Scheduling Effectiveness HH-60G (Monthly) | 95% | TBD | TBD | TBD | Pass | Pass | Pass | 0 | $ 10,000.00 | 1% | $ - 0 | X002 | ||||
| Monthly MX Scheduling Effectiveness HH-60W (Monthly) | 95% | TBD | TBD | TBD | Pass | Pass | Pass | 0 | $ 10,000.00 | 1% | $ - 0 | X002 | ||||
| Total Quarterly PIR = | $ - 0 | |||||||||||||||
| Total Quarter PIR % = | 0% | |||||||||||||||
| Instructions: | CLIN X001 PIR Invoice Reduction | $ - 0 | ||||||||||||||
| 1) Insert monthly FFP for X001 and X002 above | CLIN X002 PIR Invoice Reduction | $ - 0 | ||||||||||||||
| 2) Insert performance achieved for each month in the quarter under "Monthly Performance" column. | Total Quarterly PIR = | $ - 0 | ||||||||||||||
| 3) Apply Performance Incentive Reduction (PIR) to contractor invoices for the associated CLIN. | ||||||||||||||||
| NOTE: Inspection metrics apply to both X001 and X002; divide the PIR by 2 and apply to both X001 and X002 (i.e: $24,000 ÷ 2 = $12,000 reduction for X001 and X002). | ||||||||||||||||
| 4) Utilize the tabs below for each quarterly incentivized period. The ACO will save and retain all period calculations. |
FY20 2nd Qtr
| Kirtland Helicopter Maintenance Performance Incentive | ||||||||||||||||
| 1% per Metric - Pass/Fail | ||||||||||||||||
| CLIN PRICING | Metric | Pass Threshold | Monthly Performance | Pass/Fail | Fails/Eval Period | Associated CLIN Values | Reduction | PIR | CLIN | |||||||
| CLIN | Description | Monthly FFP | Minimum Daily Aircraft UH-1N (Monthly) | 80% | TBD | TBD | TBD | Pass | Pass | Pass | 0 | $ 10,000.00 | 1% | $ - 0 | X001 | |
| CLIN X002 | UH-1N MX | $10,000.00 | Minimum Daily Aircraft HH-60G (Monthly) | 90% | TBD | TBD | TBD | Pass | Pass | Pass | 0 | $ 10,000.00 | 1% | $ - 0 | X002 | |
| CLIN X003 | HH-60 MX | $10,000.00 | Minimum Daily Aircraft HH-60W (Monthly) | 90% | TBD | TBD | TBD | Pass | Pass | Pass | 0 | $ 10,000.00 | 1% | $ - 0 | X002 | |
| Aircraft Technical Inspections (Quarterly) | 85% | TBD | Pass | Pass | Pass | 0 | $ 60,000.00 | 1% | $ - 0 | X001 & X002 | 50% each | |||||
| Scheduled Observation Area Inspections (Quarterly) | 80% | TBD | Pass | Pass | Pass | 0 | $ 60,000.00 | 1% | $ - 0 | X001 & X002 | 50% each | |||||
| Monthly MX Scheduling Effectiveness UH-1N (Monthly) | 95% | TBD | TBD | TBD | Pass | Pass | Pass | 0 | $ 10,000.00 | 1% | $ - 0 | X001 | ||||
| Monthly MX Scheduling Effectiveness HH-60G (Monthly) | 95% | TBD | TBD | TBD | Pass | Pass | Pass | 0 | $ 10,000.00 | 1% | $ - 0 | X002 | ||||
| Monthly MX Scheduling Effectiveness HH-60W (Monthly) | 95% | TBD | TBD | TBD | Pass | Pass | Pass | 0 | $ 10,000.00 | 1% | $ - 0 | X002 | ||||
| Total Quarterly PIR = | $ - 0 | |||||||||||||||
| Total Quarter PIR % = | 0% | |||||||||||||||
| Instructions: | CLIN X001 PIR Invoice Reduction | $ - 0 | ||||||||||||||
| 1) Insert monthly FFP for X001 and X002 above | CLIN X002 PIR Invoice Reduction | $ - 0 | ||||||||||||||
| 2) Insert performance achieved for each month in the quarter under "Monthly Performance" column. | Total Quarterly PIR = | $ - 0 | ||||||||||||||
| 3) Apply Performance Incentive Reduction (PIR) to contractor invoices for the associated CLIN. | ||||||||||||||||
| NOTE: Inspection metrics apply to both X001 and X002; divide the PIR by 2 and apply to both X001 and X002 (i.e: $24,000 ÷ 2 = $12,000 reduction for X001 and X002). | ||||||||||||||||
| 4) Utilize the tabs below for each quarterly incentivized period. The ACO will save and retain all period calculations. |
FY20 3rd Qtr
| Kirtland Helicopter Maintenance Performance Incentive | ||||||||||||||||
| 1% per Metric - Pass/Fail | ||||||||||||||||
| CLIN PRICING | Metric | Pass Threshold | Monthly Performance | Pass/Fail | Fails/Eval Period | Associated CLIN Values | Reduction | PIR | CLIN | |||||||
| CLIN | Description | Monthly FFP | Minimum Daily Aircraft UH-1N (Monthly) | 80% | TBD | TBD | TBD | Pass | Pass | Pass | 0 | $ 10,000.00 | 1% | $ - 0 | X001 | |
| CLIN X002 | UH-1N MX | $10,000.00 | Minimum Daily Aircraft HH-60G (Monthly) | 90% | TBD | TBD | TBD | Pass | Pass | Pass | 0 | $ 10,000.00 | 1% | $ - 0 | X002 | |
| CLIN X003 | HH-60 MX | $10,000.00 | Minimum Daily Aircraft HH-60W (Monthly) | 90% | TBD | TBD | TBD | Pass | Pass | Pass | 0 | $ 10,000.00 | 1% | $ - 0 | X002 | |
| Aircraft Technical Inspections (Quarterly) | 85% | TBD | Pass | Pass | Pass | 0 | $ 60,000.00 | 1% | $ - 0 | X001 & X002 | 50% each | |||||
| Scheduled Observation Area Inspections (Quarterly) | 80% | TBD | Pass | Pass | Pass | 0 | $ 60,000.00 | 1% | $ - 0 | X001 & X002 | 50% each | |||||
| Monthly MX Scheduling Effectiveness UH-1N (Monthly) | 95% | TBD | TBD | TBD | Pass | Pass | Pass | 0 | $ 10,000.00 | 1% | $ - 0 | X001 | ||||
| Monthly MX Scheduling Effectiveness HH-60G (Monthly) | 95% | TBD | TBD | TBD | Pass | Pass | Pass | 0 | $ 10,000.00 | 1% | $ - 0 | X002 | ||||
| Monthly MX Scheduling Effectiveness HH-60W (Monthly) | 95% | TBD | TBD | TBD | Pass | Pass | Pass | 0 | $ 10,000.00 | 1% | $ - 0 | X002 | ||||
| Total Quarterly PIR = | $ - 0 | |||||||||||||||
| Total Quarter PIR % = | 0% | |||||||||||||||
| Instructions: | CLIN X001 PIR Invoice Reduction | $ - 0 | ||||||||||||||
| 1) Insert monthly FFP for X001 and X002 above | CLIN X002 PIR Invoice Reduction | $ - 0 | ||||||||||||||
| 2) Insert performance achieved for each month in the quarter under "Monthly Performance" column. | Total Quarterly PIR = | $ - 0 | ||||||||||||||
| 3) Apply Performance Incentive Reduction (PIR) to contractor invoices for the associated CLIN. | ||||||||||||||||
| NOTE: Inspection metrics apply to both X001 and X002; divide the PIR by 2 and apply to both X001 and X002 (i.e: $24,000 ÷ 2 = $12,000 reduction for X001 and X002). | ||||||||||||||||
| 4) Utilize the tabs below for each quarterly incentivized period. The ACO will save and retain all period calculations. |
FY20 4th Qtr
| Kirtland Helicopter Maintenance Performance Incentive | ||||||||||||||||
| 1% per Metric - Pass/Fail | ||||||||||||||||
| CLIN PRICING | Metric | Pass Threshold | Monthly Performance | Pass/Fail | Fails/Eval Period | Associated CLIN Values | Reduction | PIR | CLIN | |||||||
| CLIN | Description | Monthly FFP | Minimum Daily Aircraft UH-1N (Monthly) | 80% | TBD | TBD | TBD | Pass | Pass | Pass | 0 | $ 10,000.00 | 1% | $ - 0 | X001 | |
| CLIN X002 | UH-1N MX | $10,000.00 | Minimum Daily Aircraft HH-60G (Monthly) | 90% | TBD | TBD | TBD | Pass | Pass | Pass | 0 | $ 10,000.00 | 1% | $ - 0 | X002 | |
| CLIN X003 | HH-60 MX | $10,000.00 | Minimum Daily Aircraft HH-60W (Monthly) | 90% | TBD | TBD | TBD | Pass | Pass | Pass | 0 | $ 10,000.00 | 1% | $ - 0 | X002 | |
| Aircraft Technical Inspections (Quarterly) | 85% | TBD | Pass | Pass | Pass | 0 | $ 60,000.00 | 1% | $ - 0 | X001 & X002 | 50% each | |||||
| Scheduled Observation Area Inspections (Quarterly) | 80% | TBD | Pass | Pass | Pass | 0 | $ 60,000.00 | 1% | $ - 0 | X001 & X002 | 50% each | |||||
| Monthly MX Scheduling Effectiveness UH-1N (Monthly) | 95% | TBD | TBD | TBD | Pass | Pass | Pass | 0 | $ 10,000.00 | 1% | $ - 0 | X001 | ||||
| Monthly MX Scheduling Effectiveness HH-60G (Monthly) | 95% | TBD | TBD | TBD | Pass | Pass | Pass | 0 | $ 10,000.00 | 1% | $ - 0 | X002 | ||||
| Monthly MX Scheduling Effectiveness HH-60W (Monthly) | 95% | TBD | TBD | TBD | Pass | Pass | Pass | 0 | $ 10,000.00 | 1% | $ - 0 | X002 | ||||
| Total Quarterly PIR = | $ - 0 | |||||||||||||||
| Total Quarter PIR % = | 0% | |||||||||||||||
| Instructions: | CLIN X001 PIR Invoice Reduction | $ - 0 | ||||||||||||||
| 1) Insert monthly FFP for X001 and X002 above | CLIN X002 PIR Invoice Reduction | $ - 0 | ||||||||||||||
| 2) Insert performance achieved for each month in the quarter under "Monthly Performance" column. | Total Quarterly PIR = | $ - 0 | ||||||||||||||
| 3) Apply Performance Incentive Reduction (PIR) to contractor invoices for the associated CLIN. | ||||||||||||||||
| NOTE: Inspection metrics apply to both X001 and X002; divide the PIR by 2 and apply to both X001 and X002 (i.e: $24,000 ÷ 2 = $12,000 reduction for X001 and X002). | ||||||||||||||||
| 4) Utilize the tabs below for each quarterly incentivized period. The ACO will save and retain all period calculations. |
File details come from the government source that posted it. Updated .