Draft_RFP_Atch_4_-_PIR_Calculator.xlsx

XLSX spreadsheet 21 KB Posted

Attached to
AFICA Sheppard Aircraft Maintenance Services Re-Compete
Solicitation number
FA3002-14-R-0015
Issued by

About this file

Attachment 4 - Performance Incentive Reduction Calculator

View the file

Other files

Show all 13

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

Sheppard Aircraft Maintenance Performance Incentive - Calculation
1
Performance PeriodPIR $Total Contract Dollars% of Total Contract Dollars for Period
FY16ERROR:#DIV/0!
FY17ERROR:#DIV/0!
FY18ERROR:#DIV/0!
FY19ERROR:#DIV/0!
FY20ERROR:#DIV/0!
FY21ERROR:#DIV/0!
FY22ERROR:#DIV/0!
FY23ERROR:#DIV/0!
TOTAL$ - 0$0.00ERROR:#DIV/0!
**The repeat/recurrence rate was not in the current contract as a service summary item. Data was pulled from the MDS Summary for objective rates and actuals
1% per Metric - Pass/Fail
3% per Metric - Pass/Fail

FY 16 1st Qtr

Sheppard Aircraft Maintenance Performance Incentive
1% per Metric - Pass/Fail
CLIN PRICINGMetricPass ThresholdMonthly PerformancePass/FailFails/Eval PeriodCLIN ValuesReduction
CLINDescriptionMonthly FFPMonth 1Month 2Month 3PIRCLIN
CLIN X001Site Support & Steady State$ 400,000.00Performance Management Inspections (Quarterly) *80%79%Fail1$400,000.003%$ 36,000.00X001
CLIN X002T-6A Flying Hours ACMX$ 400,001.00T-6A Aircraft Availability (AA) (Monthly)80%79%79%79%FailFailFail3$400,001.001%$ 12,000.03X002
CLIN X003T-38C UPT Flying Hours ACMX$ 400,002.00T-6A Average Fleet Time (Hours) (Monthly) *150149149149FailFailFail3$400,001.001%$ 12,000.03X002
CLIN X004T-38C IFF Flying Hours ACMX$ 400,003.00T-6A Repeat/Recurring (Monthly) *2.5%2.6%2.6%2.6%FailFailFail3$400,001.001%$ 12,000.03X002
T-38C UPT Aircraft Availability (AA) (Monthly)80%79%79%79%FailFailFail3$400,002.001%$ 12,000.06X003
All cells are example; offerors must add a sample value toT-38C UPT Average Fleet Time (Hours) (Monthly) *225224224224FailFailFail3$400,002.001%$ 12,000.06X003
to determine projected reduction for each CLIN.T-38C UPT Repeat/Recurring (Monthly) *2.5%2.6%2.6%2.6%FailFailFail3$400,002.001%$ 12,000.06X003
T-38C IFF Aircraft Availability (AA) (Monthly)80%79%79%79%FailFailFail3$400,003.001%$ 12,000.09X004
T-38C IFF Average Fleet Time (Hours) (Monthly) *225224224224FailFailFail3$400,003.001%$ 12,000.09X004
T-38C IFF Repeat/Recurring (Monthly) *2.5%2.6%2.6%2.6%FailFailFail3$400,003.001%$ 12,000.09X004
$ 144,000.54

Total Quarter PIR % 3.0000%

Instructions

1) Insert monthly FFP for X001 thru X004 above
2) Insert monthly Passing Threshold for Aircraft (AA)
2) Insert performance achieved (days or percentage) for each month in the quarter under "Monthly Performance" column
3) Apply Performance Incentive Reduction (PIR) to contractor invoices for the associated CLIN

(Draft) FA3002-14-R-0015 Sheppard Acft MX, Atch 4

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