Atch_5_-_PIR_Calculator_(Rev).xlsx

XLSX spreadsheet 41 KB Posted Nov 2, 2015

Attached to: Sheppard Aircraft Maintenance Support Services Federal contract opportunity
Solicitation number: FA3002-14-R-0015
Issued by: Department of the Air Force Materiel Command Installation and Mission Support Center Installation Contracting Agency

About this file

From the source

Atch 5 - Performance Incentive Reduction Calculator

View the file

Other files for this federal contract opportunity

Other files attached to Sheppard Aircraft Maintenance Support Services, newest first.
File	Type	Posted
Amend_0001_PWS_Change_Matrix_(1_Dec_15).pdf	PDF	Dec 8, 2015
FA3002-14-R-0015-0001.doc	DOC document	Dec 8, 2015
Atch_16_(Rev_1)_-_SGEM_Calculations.xlsx	XLSX spreadsheet	Dec 8, 2015
Atch_1_(Rev_1)_-_Performance_Work_Statement_(1_Dec_15).pdf	PDF	Dec 8, 2015
Atch_7_(Rev_1)_-_Sheppard_Manpower_Matrix.xlsx	XLSX spreadsheet	Dec 8, 2015
Consolidated_Q A__1_(FA3002-14-R-0015).pdf	PDF	Dec 3, 2015
Cover_Letter_for_Q A__1_and_Site_Visit_Brief_Release.pdf	PDF	Dec 3, 2015
Sheppard_Acft_MX_Pre-Proposal_Conf_Brief.pdf	PDF	Dec 3, 2015
Sheppard_Acft_MX_Site_Visit_Q A_Form.doc	DOC document	Nov 2, 2015
Sheppard_Acft_MX_Pre-Proposal_Conf_ _Site_Visit_Invitation.docx	DOCX document	Nov 2, 2015
Atch_6_-_Proposal_Incorporation_Memorandum.docx	DOCX document	Nov 2, 2015
Atch_11-_Subktr_Letter_of_Consent.docx	DOCX document	Nov 2, 2015
Atch_15_-_Past_Perf_Questionnaire.docx	DOCX document	Nov 2, 2015
Atch_16_-_SGEM_Calculations.xlsx	XLSX spreadsheet	Nov 2, 2015
Atch_13_-_Solicitation_Question_and_Comment_Sheet.xlsx	XLSX spreadsheet	Nov 2, 2015
Atch_10_-_Past_Performance_Information_Sheet.docx	DOCX document	Nov 2, 2015
Atch_4c_-_CBA_Memorandum_1_(Fringe_Benefit_Rate).pdf	PDF	Nov 2, 2015
Atch_14_-_Workforce_Demographic_Information_as_of_Aug_15.xls	XLS spreadsheet	Nov 2, 2015
Atch_1_-_Performance_Work_Statement_(1_Oct_15).pdf	PDF	Nov 2, 2015
Atch_4a_-_CBA_(18_May_2015).pdf	PDF	Nov 2, 2015
RFP_FA3002-14-R-0015 _Sheppard_Acft_MX_(2_Nov_15_Release).doc	DOC document	Nov 2, 2015
Atch_3_-_SCLS_WD_05-2525_(Rev_18)_8_Jul_15.pdf	PDF	Nov 2, 2015
Atch_2_-_DD_254.pdf	PDF	Nov 2, 2015
Atch_12_-_Client_Authorization_Letter.docx	DOCX document	Nov 2, 2015
Atch_4b_-_CBA_(TSquare_-_AGE)_(24_May_15).pdf	PDF	Nov 2, 2015
Atch_8_-_Sample_Vehicle_Matrix.xlsx	XLSX spreadsheet	Nov 2, 2015
Atch_9_-_Subcontracting_Plan_Checklist.docx	DOCX document	Nov 2, 2015
Atch_7_-_Sheppard_Manpower_Matrix.xlsx	XLSX spreadsheet	Nov 2, 2015
Sheppard_RFP_Cover_Attachment_1_-_PWS_Change_Matrix_(1_Oct_15).pdf	PDF	Nov 2, 2015
Sheppard_Acft_MX_RFP_Cover _FA3002-14-R-0015.pdf	PDF	Nov 2, 2015

Show all 30

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

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

FY 16 1st Qtr

	CLIN PRICING				Metric (Quarterly or Monthly)	Pass Threshold*	Measured Performance
JOYNER, TODD S GS-13 USAF AFICA 338 SCONS/PKC: Instructions: Step 2			Pass/Fail			Fails/Eval Period	CLIN Values	Reduction
	CLIN	Description	Monthly FFP
JOYNER, TODD S GS-13 USAF AFICA 338 SCONS/PKC: Instructions: Step 1				Month 1	Month 2	Month 3							PIR	CLIN
	CLIN X001	Site Support & Steady State	$ 100.00		Performance Management Inspections - Q	80%	79%			Fail			1	$300.00	3%	$9.00	X001
	CLIN X002	T-6A Flying Hours ACMX	$ 100.00		T-6A Aircraft Availability (AA) - M	80%	79%	79%	79%	Fail	Fail	Fail	3	$100.00	1%	$3.00	X002
	CLIN X003	T-38C UPT Flying Hours ACMX	$ 100.00		T-6A Average Fleet Time Hours - M	150	149	149	149	Fail	Fail	Fail	3	$100.00	1%	$3.00	X002
	CLIN X004	T-38C IFF Flying Hours ACMX	$ 100.00		T-6A Repeat Discrepancy Rate - M	2.5%	2.6%	2.6%	2.6%	Fail	Fail	Fail	3	$100.00	1%	$3.00	X002
					T-6A Recur Discrepancy Rate - M	2.5%	2.6%	2.6%	2.6%	Fail	Fail	Fail	3	$100.00	1%	$3.00	X002
	Monthly FFP CLIN Prices are notional and provided for the purpose of demonstrating how PIR will be calculated each quarter. NOTE: A scenario where the service provider failed to meet all metric threshold for the quarter would result in a 3.75% reduction in CLIN X001 - CLIN X004 payments for the quarter.				T-38C UPT Aircraft Availability (AA) - M	80%	79%	79%	79%	Fail	Fail	Fail	3	$100.00	1%	$3.00	X003
					T-38C UPT Average Fleet Time Hours - M	225	224	224	224	Fail	Fail	Fail	3	$100.00	1%	$3.00	X003
					T-38C UPT Repeat Discrepancy Rate - M	2.5%	2.6%	2.6%	2.6%	Fail	Fail	Fail	3	$100.00	1%	$3.00	X003
					T-38C UPT Recur Discrepancy Rate - M	2.5%	2.6%	2.6%	2.6%	Fail	Fail	Fail	3	$100.00	1%	$3.00	X003
					T-38C IFF Aircraft Availability (AA) - M	80%	79%	79%	79%	Fail	Fail	Fail	3	$100.00	1%	$3.00	X004
					T-38C IFF Average Fleet Time Hours - M	225	224	224	224	Fail	Fail	Fail	3	$100.00	1%	$3.00	X004
	Instructions:				T-38C IFF Repeat Discrepancy Rate - M	2.5%	2.6%	2.6%	2.6%	Fail	Fail	Fail	3	$100.00	1%	$3.00	X004
	1 - Insert Monthly FFP for CLINs X001 - X004				T-38C IFF Recur Discrepancy Rate - M	2.5%	2.6%	2.6%	2.6%	Fail	Fail	Fail	3	$100.00	1%	$3.00	X004
	2 - Insert Measured Performance M or Q (as appropriate)					*Thresholds are defined in PWS Section 3-2 and Section H-001								Total Quarterly PIR		$45.00
	3 - Service provider reduces affected invoice by Total Quarterly PIR for each affected CLIN													Total Quarter PIR %		3.75%

CLIN X001 PIR Invoice Reduction $9.00 JOYNER, TODD S GS-13 USAF AFICA 338 SCONS/PKC: Instructions: Step 3

JOYNER, TODD S GS-13 USAF AFICA 338 SCONS/PKC: Instructions: Step 1

JOYNER, TODD S GS-13 USAF AFICA 338 SCONS/PKC: Instructions: Step 2	CLIN X002 PIR Invoice Reduction	$12.00
			CLIN X003 PIR Invoice Reduction	$12.00
			CLIN X004 PIR Invoice Reduction	$12.00
			Total Quarterly PIR	$45.00

&"Times New Roman,Bold"&14Sheppard AFB Aircraft Maintenance Performance Incentive Reduction (PIR) Calculator

FA3002-14-R-0015, Sheppard Acft MX Attachment 5

FY 16 2nd Qtr

	CLIN PRICING				Metric (Quarterly or Monthly)	Pass Threshold*	Measured Performance
JOYNER, TODD S GS-13 USAF AFICA 338 SCONS/PKC: Instructions: Step 2			Pass/Fail			Fails/Eval Period	CLIN Values	Reduction
	CLIN	Description	Monthly FFP
JOYNER, TODD S GS-13 USAF AFICA 338 SCONS/PKC: Instructions: Step 1				Month 1	Month 2	Month 3							PIR	CLIN
	CLIN X001	Site Support & Steady State	$ 100.00		Performance Management Inspections - Q	80%	79%			Fail			1	$300.00	3%	$9.00	X001
	CLIN X002	T-6A Flying Hours ACMX	$ 100.00		T-6A Aircraft Availability (AA) - M	80%	79%	79%	79%	Fail	Fail	Fail	3	$100.00	1%	$3.00	X002
	CLIN X003	T-38C UPT Flying Hours ACMX	$ 100.00		T-6A Average Fleet Time Hours - M	150	149	149	149	Fail	Fail	Fail	3	$100.00	1%	$3.00	X002
	CLIN X004	T-38C IFF Flying Hours ACMX	$ 100.00		T-6A Repeat Discrepancy Rate - M	2.5%	2.6%	2.6%	2.6%	Fail	Fail	Fail	3	$100.00	1%	$3.00	X002
					T-6A Recur Discrepancy Rate - M	2.5%	2.6%	2.6%	2.6%	Fail	Fail	Fail	3	$100.00	1%	$3.00	X002
	Monthly FFP CLIN Prices are notional and provided for the purpose of demonstrating how PIR will be calculated each quarter. NOTE: A scenario where the service provider failed to meet all metric threshold for the quarter would result in a 3.75% reduction in CLIN X001 - CLIN X004 payments for the quarter.				T-38C UPT Aircraft Availability (AA) - M	80%	79%	79%	79%	Fail	Fail	Fail	3	$100.00	1%	$3.00	X003
					T-38C UPT Average Fleet Time Hours - M	225	224	224	224	Fail	Fail	Fail	3	$100.00	1%	$3.00	X003
					T-38C UPT Repeat Discrepancy Rate - M	2.5%	2.6%	2.6%	2.6%	Fail	Fail	Fail	3	$100.00	1%	$3.00	X003
					T-38C UPT Recur Discrepancy Rate - M	2.5%	2.6%	2.6%	2.6%	Fail	Fail	Fail	3	$100.00	1%	$3.00	X003
					T-38C IFF Aircraft Availability (AA) - M	80%	79%	79%	79%	Fail	Fail	Fail	3	$100.00	1%	$3.00	X004
					T-38C IFF Average Fleet Time Hours - M	225	224	224	224	Fail	Fail	Fail	3	$100.00	1%	$3.00	X004
	Instructions:				T-38C IFF Repeat Discrepancy Rate - M	2.5%	2.6%	2.6%	2.6%	Fail	Fail	Fail	3	$100.00	1%	$3.00	X004
	1 - Insert Monthly FFP for CLINs X001 - X004				T-38C IFF Recur Discrepancy Rate - M	2.5%	2.6%	2.6%	2.6%	Fail	Fail	Fail	3	$100.00	1%	$3.00	X004
	2 - Insert Measured Performance M or Q (as appropriate)					*Thresholds are defined in PWS Section 3-2 and Section H-001								Total Quarterly PIR		$45.00
	3 - Service provider reduces affected invoice by Total Quarterly PIR for each affected CLIN													Total Quarter PIR %		3.75%

CLIN X001 PIR Invoice Reduction $9.00

JOYNER, TODD S GS-13 USAF AFICA 338 SCONS/PKC: Instructions: Step 1

JOYNER, TODD S GS-13 USAF AFICA 338 SCONS/PKC: Instructions: Step 2	CLIN X002 PIR Invoice Reduction	$12.00
			CLIN X003 PIR Invoice Reduction	$12.00
			CLIN X004 PIR Invoice Reduction	$12.00
			Total Quarterly PIR	$45.00

FY 16 3rd Qtr

	CLIN PRICING				Metric (Quarterly or Monthly)	Pass Threshold*	Measured Performance
JOYNER, TODD S GS-13 USAF AFICA 338 SCONS/PKC: Instructions: Step 2			Pass/Fail			Fails/Eval Period	CLIN Values	Reduction
	CLIN	Description	Monthly FFP
JOYNER, TODD S GS-13 USAF AFICA 338 SCONS/PKC: Instructions: Step 1				Month 1	Month 2	Month 3							PIR	CLIN
	CLIN X001	Site Support & Steady State	$ 100.00		Performance Management Inspections - Q	80%	79%			Fail			1	$300.00	3%	$9.00	X001
	CLIN X002	T-6A Flying Hours ACMX	$ 100.00		T-6A Aircraft Availability (AA) - M	80%	79%	79%	79%	Fail	Fail	Fail	3	$100.00	1%	$3.00	X002
	CLIN X003	T-38C UPT Flying Hours ACMX	$ 100.00		T-6A Average Fleet Time Hours - M	150	149	149	149	Fail	Fail	Fail	3	$100.00	1%	$3.00	X002
	CLIN X004	T-38C IFF Flying Hours ACMX	$ 100.00		T-6A Repeat Discrepancy Rate - M	2.5%	2.6%	2.6%	2.6%	Fail	Fail	Fail	3	$100.00	1%	$3.00	X002
					T-6A Recur Discrepancy Rate - M	2.5%	2.6%	2.6%	2.6%	Fail	Fail	Fail	3	$100.00	1%	$3.00	X002
	Monthly FFP CLIN Prices are notional and provided for the purpose of demonstrating how PIR will be calculated each quarter. NOTE: A scenario where the service provider failed to meet all metric threshold for the quarter would result in a 3.75% reduction in CLIN X001 - CLIN X004 payments for the quarter.				T-38C UPT Aircraft Availability (AA) - M	80%	79%	79%	79%	Fail	Fail	Fail	3	$100.00	1%	$3.00	X003
					T-38C UPT Average Fleet Time Hours - M	225	224	224	224	Fail	Fail	Fail	3	$100.00	1%	$3.00	X003
					T-38C UPT Repeat Discrepancy Rate - M	2.5%	2.6%	2.6%	2.6%	Fail	Fail	Fail	3	$100.00	1%	$3.00	X003
					T-38C UPT Recur Discrepancy Rate - M	2.5%	2.6%	2.6%	2.6%	Fail	Fail	Fail	3	$100.00	1%	$3.00	X003
					T-38C IFF Aircraft Availability (AA) - M	80%	79%	79%	79%	Fail	Fail	Fail	3	$100.00	1%	$3.00	X004
					T-38C IFF Average Fleet Time Hours - M	225	224	224	224	Fail	Fail	Fail	3	$100.00	1%	$3.00	X004
	Instructions:				T-38C IFF Repeat Discrepancy Rate - M	2.5%	2.6%	2.6%	2.6%	Fail	Fail	Fail	3	$100.00	1%	$3.00	X004
	1 - Insert Monthly FFP for CLINs X001 - X004				T-38C IFF Recur Discrepancy Rate - M	2.5%	2.6%	2.6%	2.6%	Fail	Fail	Fail	3	$100.00	1%	$3.00	X004
	2 - Insert Measured Performance M or Q (as appropriate)					*Thresholds are defined in PWS Section 3-2 and Section H-001								Total Quarterly PIR		$45.00
	3 - Service provider reduces affected invoice by Total Quarterly PIR for each affected CLIN													Total Quarter PIR %		3.75%

CLIN X001 PIR Invoice Reduction $9.00

JOYNER, TODD S GS-13 USAF AFICA 338 SCONS/PKC: Instructions: Step 1

JOYNER, TODD S GS-13 USAF AFICA 338 SCONS/PKC: Instructions: Step 2	CLIN X002 PIR Invoice Reduction	$12.00
			CLIN X003 PIR Invoice Reduction	$12.00
			CLIN X004 PIR Invoice Reduction	$12.00
			Total Quarterly PIR	$45.00

FY 16 4th Qtr

	CLIN PRICING				Metric (Quarterly or Monthly)	Pass Threshold*	Measured Performance
JOYNER, TODD S GS-13 USAF AFICA 338 SCONS/PKC: Instructions: Step 2			Pass/Fail			Fails/Eval Period	CLIN Values	Reduction
	CLIN	Description	Monthly FFP
JOYNER, TODD S GS-13 USAF AFICA 338 SCONS/PKC: Instructions: Step 1				Month 1	Month 2	Month 3							PIR	CLIN
	CLIN X001	Site Support & Steady State	$ 100.00		Performance Management Inspections - Q	80%	79%			Fail			1	$300.00	3%	$9.00	X001
	CLIN X002	T-6A Flying Hours ACMX	$ 100.00		T-6A Aircraft Availability (AA) - M	80%	79%	79%	79%	Fail	Fail	Fail	3	$100.00	1%	$3.00	X002
	CLIN X003	T-38C UPT Flying Hours ACMX	$ 100.00		T-6A Average Fleet Time Hours - M	150	149	149	149	Fail	Fail	Fail	3	$100.00	1%	$3.00	X002
	CLIN X004	T-38C IFF Flying Hours ACMX	$ 100.00		T-6A Repeat Discrepancy Rate - M	2.5%	2.6%	2.6%	2.6%	Fail	Fail	Fail	3	$100.00	1%	$3.00	X002
					T-6A Recur Discrepancy Rate - M	2.5%	2.6%	2.6%	2.6%	Fail	Fail	Fail	3	$100.00	1%	$3.00	X002
	Monthly FFP CLIN Prices are notional and provided for the purpose of demonstrating how PIR will be calculated each quarter. NOTE: A scenario where the service provider failed to meet all metric threshold for the quarter would result in a 3.75% reduction in CLIN X001 - CLIN X004 payments for the quarter.				T-38C UPT Aircraft Availability (AA) - M	80%	79%	79%	79%	Fail	Fail	Fail	3	$100.00	1%	$3.00	X003
					T-38C UPT Average Fleet Time Hours - M	225	224	224	224	Fail	Fail	Fail	3	$100.00	1%	$3.00	X003
					T-38C UPT Repeat Discrepancy Rate - M	2.5%	2.6%	2.6%	2.6%	Fail	Fail	Fail	3	$100.00	1%	$3.00	X003
					T-38C UPT Recur Discrepancy Rate - M	2.5%	2.6%	2.6%	2.6%	Fail	Fail	Fail	3	$100.00	1%	$3.00	X003
					T-38C IFF Aircraft Availability (AA) - M	80%	79%	79%	79%	Fail	Fail	Fail	3	$100.00	1%	$3.00	X004
					T-38C IFF Average Fleet Time Hours - M	225	224	224	224	Fail	Fail	Fail	3	$100.00	1%	$3.00	X004
	Instructions:				T-38C IFF Repeat Discrepancy Rate - M	2.5%	2.6%	2.6%	2.6%	Fail	Fail	Fail	3	$100.00	1%	$3.00	X004
	1 - Insert Monthly FFP for CLINs X001 - X004				T-38C IFF Recur Discrepancy Rate - M	2.5%	2.6%	2.6%	2.6%	Fail	Fail	Fail	3	$100.00	1%	$3.00	X004
	2 - Insert Measured Performance M or Q (as appropriate)					*Thresholds are defined in PWS Section 3-2 and Section H-001								Total Quarterly PIR		$45.00
	3 - Service provider reduces affected invoice by Total Quarterly PIR for each affected CLIN													Total Quarter PIR %		3.75%

CLIN X001 PIR Invoice Reduction $9.00

JOYNER, TODD S GS-13 USAF AFICA 338 SCONS/PKC: Instructions: Step 1

JOYNER, TODD S GS-13 USAF AFICA 338 SCONS/PKC: Instructions: Step 2	CLIN X002 PIR Invoice Reduction	$12.00
			CLIN X003 PIR Invoice Reduction	$12.00
			CLIN X004 PIR Invoice Reduction	$12.00
			Total Quarterly PIR	$45.00

File details come from the government source that posted it. Updated Nov 14, 2017.